Blame view

lib/syspro/business_objects/parsers/sorqry_parser.rb 14.8 KB
b0dddc7f   Isaac Lewis   change from sorqb...
1
2
3
4
5
6
7
8
9
  # frozen_string_literal: true
  
  module Syspro
    module BusinessObjects
      module Parsers
        class SorQryParser
          attr_reader :doc
  
          def initialize(doc)
193ef3c1   Nathan Ockerman   LM issue 845 - sh...
10
            @calculated_weight = 0
b0dddc7f   Isaac Lewis   change from sorqb...
11
12
13
14
            @doc = doc
          end
  
          def parse
b1c0def6   Samuel J Clopton   rubocop violation...
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
            sor = Syspro::BusinessObjects::Models::SorDetail.new
            sor.sales_order = doc.first_element_child.xpath('SalesOrder').text
            sor.document_type = doc.first_element_child.xpath('DocumentType').text
            sor.document_type_desc = doc.first_element_child.xpath('DocumentTypeDesc').text
            sor.inter_branch_transfer = doc.first_element_child.xpath('InterBranchTransfer').text
            sor.inter_wh_sale = doc.first_element_child.xpath('InterWhSale').text
            sor.source_warehouse = doc.first_element_child.xpath('SourceWarehouse').text
            sor.target_warehouse = doc.first_element_child.xpath('TargetWarehouse').text
            sor.gtr_reference = doc.first_element_child.xpath('GtrReference').text
            sor.customer = doc.first_element_child.xpath('Customer').text
            sor.customer_name = doc.first_element_child.xpath('CustomerName').text
            sor.tax_status_code = doc.first_element_child.xpath('TaxStatusCode').text
            sor.tax_status = doc.first_element_child.xpath('TaxStatus').text
            sor.gst_tax_status_code = doc.first_element_child.xpath('GstTaxStatusCode').text
            sor.gst_tax_status = doc.first_element_child.xpath('GstTaxStatus').text
            sor.eu_flag = doc.first_element_child.xpath('EuFlag').text
            sor.eu_flag_desc = doc.first_element_child.xpath('EuFlagDesc').text
            sor.sold_to_name = doc.first_element_child.xpath('SoldToName').text
            sor.sold_addr_1 = doc.first_element_child.xpath('SoldAddr1').text
            sor.sold_addr_2 = doc.first_element_child.xpath('SoldAddr2').text
            sor.sold_addr_3 = doc.first_element_child.xpath('SoldAddr3').text
            sor.sold_addr_3_locality = doc.first_element_child.xpath('SoldAddr3Locality').text
            sor.sold_addr_4 = doc.first_element_child.xpath('SoldAddr4').text
            sor.sold_addr_5 = doc.first_element_child.xpath('SoldAddr5').text
            sor.sold_postal_code = doc.first_element_child.xpath('SoldPostalCode').text
            sor.sold_gps_lat = doc.first_element_child.xpath('SoldGpsLat').text
            sor.sold_gps_long = doc.first_element_child.xpath('SoldGpsLong').text
            sor.salesperson = doc.first_element_child.xpath('Salesperson').text
            sor.scheduled_ord_flag = doc.first_element_child.xpath('ScheduledOrdFlag').text
            sor.disc_pct_1 = doc.first_element_child.xpath('DiscPct1').text
            sor.disc_pct_2 = doc.first_element_child.xpath('DiscPct2').text
            sor.disc_pct_3 = doc.first_element_child.xpath('DiscPct3').text
b0dddc7f   Isaac Lewis   change from sorqb...
47
            sor.salsls_name = doc.first_element_child.at_xpath('//SALSLS:Name').children.text
b1c0def6   Samuel J Clopton   rubocop violation...
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
            sor.order_status = doc.first_element_child.xpath('OrderStatus').text
            sor.order_status_desc = doc.first_element_child.xpath('OrderStatusDesc').text
            sor.customer_po_number = doc.first_element_child.xpath('CustomerPoNumber').text
            sor.order_date = doc.first_element_child.xpath('OrderDate').text
            sor.git_reference = doc.first_element_child.xpath('GITReference').text
            sor.req_ship_date = doc.first_element_child.xpath('ReqShipDate').text
            sor.shipping_instrs = doc.first_element_child.xpath('ShippingInstrs').text
            sor.shipping_instrs_cod = doc.first_element_child.xpath('ShippingInstrsCod').text
            sor.special_instrs = doc.first_element_child.xpath('SpecialInstrs').text
            sor.inv_terms_override = doc.first_element_child.xpath('InvTermsOverride').text
            sor.delivery_note = doc.first_element_child.xpath('DeliveryNote').text
            sor.last_del_note = doc.first_element_child.xpath('LastDelNote').text
            sor.time_del_prted_hh = doc.first_element_child.xpath('TimeDelPrtedHh').text
            sor.time_del_prted_mm = doc.first_element_child.xpath('TimeDelPrtedMm').text
            sor.last_invoice = doc.first_element_child.xpath('LastInvoice').text
            sor.date_last_inv_prt = doc.first_element_child.xpath('DateLastInvPrt').text
            sor.time_inv_prt_hh = doc.first_element_child.xpath('TimeInvPrtHh').text
            sor.time_inv_prt_mm = doc.first_element_child.xpath('TimeInvPrtMm').text
            sor.tblart_description = doc.first_element_child.xpath('//TBLART:Description').children.text
            sor.branch = doc.first_element_child.xpath('Branch').text
            sor.salbrn_description = doc.first_element_child.xpath('//SALBRN:Description').children.text
            sor.ent_invoice = doc.first_element_child.xpath('EntInvoice').text
            sor.order_type = doc.first_element_child.xpath('OrderType').text
            sor.area = doc.first_element_child.xpath('Area').text
            sor.salare_description = doc.first_element_child.xpath('//SALARE:Description').children.text
            sor.tax_exempt_number = doc.first_element_child.xpath('TaxExemptNumber').text
            sor.gst_exempt_number = doc.first_element_child.xpath('GstExemptNumber').text
            sor.currency = doc.first_element_child.xpath('Currency').text
            sor.tblcur_description = doc.first_element_child.xpath('//TBLCUR:Description').children.text
            sor.ship_address_1 = doc.first_element_child.xpath('ShipAddress1').text
            sor.ship_address_2 = doc.first_element_child.xpath('ShipAddress2').text
            sor.ship_address_3 = doc.first_element_child.xpath('ShipAddress3').text
            sor.ship_address_3_locality = doc.first_element_child.xpath('ShipAddress3Locality').text
            sor.ship_address_4 = doc.first_element_child.xpath('ShipAddress4').text
            sor.ship_address_5 = doc.first_element_child.xpath('ShipAddress5').text
            sor.ship_postal_code = doc.first_element_child.xpath('ShipPostalCode').text
            sor.ship_gps_lat = doc.first_element_child.xpath('ShipGpsLat').text
            sor.ship_gps_long = doc.first_element_child.xpath('ShipGpsLong').text
            sor.ship_complete = doc.first_element_child.xpath('ShipComplete').text
            sor.email = doc.first_element_child.xpath('Email').text
            sor.fix_exchange_rate = doc.first_element_child.xpath('FixExchangeRate').text
            sor.exchange_rate = doc.first_element_child.xpath('ExchangeRate').text
            sor.edited_exchange_rate = doc.first_element_child.xpath('EditedExchangeRate').text
            sor.mul_div = doc.first_element_child.xpath('MulDiv').text
            sor.consolidated_order = doc.first_element_child.xpath('ConsolidatedOrder').text
            sor.gst_deduction = doc.first_element_child.xpath('GstDeduction').text
            sor.credited_inv_date = doc.first_element_child.xpath('CreditedInvDate').text
            sor.job = doc.first_element_child.xpath('Job').text
            sor.serialized_flag = doc.first_element_child.xpath('SerializedFlag').text
            sor.counter_sales_flag = doc.first_element_child.xpath('CounterSalesFlag').text
            sor.nationality = doc.first_element_child.xpath('Nationality').text
            sor.delivery_terms = doc.first_element_child.xpath('DeliveryTerms').text
            sor.shipping_location = doc.first_element_child.xpath('ShippingLocation').text
            sor.transaction_nature = doc.first_element_child.xpath('TransactionNature').text
            sor.transport_mode = doc.first_element_child.xpath('TransportMode').text
            sor.process_flag = doc.first_element_child.xpath('ProcessFlag').text
            sor.jobs_exist_flag = doc.first_element_child.xpath('JobsExistFlag').text
            sor.alternate_key = doc.first_element_child.xpath('AlternateKey').text
            sor.hierarchy_flag = doc.first_element_child.xpath('HierarchyFlag').text
            sor.deposit_flag = doc.first_element_child.xpath('DepositFlag').text
            sor.edi_source = doc.first_element_child.xpath('EdiSource').text
            sor.mult_ship_code = doc.first_element_child.xpath('MultShipCode').text
            sor.company_tax_no = doc.first_element_child.xpath('CompanyTaxNo').text
            sor.last_operator = doc.first_element_child.xpath('LastOperator').text
            sor.operator = doc.first_element_child.xpath('Operator').text
            sor.state = doc.first_element_child.xpath('State').text
            sor.county_zip = doc.first_element_child.xpath('CountyZip').text
            sor.extended_tax_code = doc.first_element_child.xpath('ExtendedTaxCode').text
            sor.web_created = doc.first_element_child.xpath('WebCreated').text
            sor.quote = doc.first_element_child.xpath('Quote').text
            sor.dispatches_made = doc.first_element_child.xpath('DispatchesMade').text
            sor.live_disp_exist = doc.first_element_child.xpath('LiveDispExist').text
            sor.num_dispatches = doc.first_element_child.xpath('NumDispatches').text
            sor.include_in_mrp = doc.first_element_child.xpath('IncludeInMrp').text
            sor.header_text = doc.first_element_child.xpath('HeaderText').text
            sor.header_notes = doc.first_element_child.xpath('HeaderNotes').text
b0dddc7f   Isaac Lewis   change from sorqb...
124
  
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
125
126
127
            # Inner Nested Structure Parsing
            sor.commissions = parse_commissions(doc)
            sor.sales_order_lines = parse_sales_order_lines(doc)
193ef3c1   Nathan Ockerman   LM issue 845 - sh...
128
            sor.ship_weight = @calculated_weight
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
129
130
131
132
133
  
            sor
          end
  
          def parse_commissions(doc)
b1c0def6   Samuel J Clopton   rubocop violation...
134
            commissions = doc.first_element_child.xpath('Commissions')
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
135
136
137
138
139
            commissions_obj = parse_children_elements(commissions)
  
            commissions_obj
          end
  
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
140
          def parse_sales_order_lines(doc)
b1c0def6   Samuel J Clopton   rubocop violation...
141
            sales_order_lines = doc.first_element_child.xpath('SalesOrderLine')
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
142
143
            sales_order_lines_obj = {}
  
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
144
            sales_order_lines.children.each do |el|
b1c0def6   Samuel J Clopton   rubocop violation...
145
              next if el.name == 'text'
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
146
147
148
149
150
151
  
              serial_obj = {}
              bin_obj = {}
              attached_items_obj = {}
              lot_obj = {}
  
b1c0def6   Samuel J Clopton   rubocop violation...
152
              if el.name == 'MiscCharge'
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
153
154
155
156
157
158
159
160
                unless sales_order_lines_obj[:misc_charge]
                  sales_order_lines_obj[:misc_charge] = []
                end
  
                misc_charge_arr = parse_children_elements(el)
                sales_order_lines_obj[:misc_charge].push(misc_charge_arr)
              end
  
b1c0def6   Samuel J Clopton   rubocop violation...
161
              if el.name == 'Freight'
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
162
163
164
165
166
167
168
169
                unless sales_order_lines_obj[:freight]
                  sales_order_lines_obj[:freight] = []
                end
  
                freight_arr = parse_children_elements(el)
                sales_order_lines_obj[:freight].push(freight_arr)
              end
  
b1c0def6   Samuel J Clopton   rubocop violation...
170
              if el.name == 'CommentLine'
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
171
172
173
174
175
176
177
178
                unless sales_order_lines_obj[:comment_line]
                  sales_order_lines_obj[:comment_line] = []
                end
  
                comment_line_arr = parse_children_elements(el)
                sales_order_lines_obj[:comment_line].push(comment_line_arr)
              end
  
b1c0def6   Samuel J Clopton   rubocop violation...
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
              next unless el.name == 'Merchandise'
              unless sales_order_lines_obj[:merchandise]
                sales_order_lines_obj[:merchandise] = []
              end
  
              merchandise_arr = el.children.map do |el_child|
                next if el_child.name == 'text'
  
                if el_child.name == 'MOrderQty'
                  @calculated_weight += el_child.text.split(' ')[0].split(',').join.to_f
  
                  {
                    name: el_child.name,
                    text: el_child.text
                  }
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
194
195
                end
  
b1c0def6   Samuel J Clopton   rubocop violation...
196
197
198
199
200
                # NOTE: These first three in the following
                # conditionals are "Merchandise" elements with
                # thier own nested structure that need parsed
                if el_child.name == 'Serial'
                  serial_obj[:serial] = [] unless serial_obj[:serial]
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
201
  
b1c0def6   Samuel J Clopton   rubocop violation...
202
203
204
                  serial_arr = parse_children_elements(el_child)
                  serial_obj[:serial].push(serial_arr)
                  serial_obj
193ef3c1   Nathan Ockerman   LM issue 845 - sh...
205
  
b1c0def6   Samuel J Clopton   rubocop violation...
206
207
                elsif el_child.name == 'Bin'
                  bin_obj[:bin] = [] unless bin_obj[:bin]
193ef3c1   Nathan Ockerman   LM issue 845 - sh...
208
  
b1c0def6   Samuel J Clopton   rubocop violation...
209
210
211
                  bin_arr = parse_children_elements(el_child)
                  bin_obj[:bin].push(bin_arr)
                  bin_obj
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
212
  
b1c0def6   Samuel J Clopton   rubocop violation...
213
214
                elsif el_child.name == 'Lot'
                  lot_obj[:lot] = [] unless lot_obj[:lot]
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
215
  
b1c0def6   Samuel J Clopton   rubocop violation...
216
217
218
                  lot_arr = parse_children_elements(el_child)
                  lot_obj[:lot].push(lot_arr)
                  lot_obj
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
219
  
b1c0def6   Samuel J Clopton   rubocop violation...
220
221
222
223
224
                elsif el_child.name == 'AttachedItems'
                  # NOTE: Like "Merchandise", "AttachedItems" is
                  # an element within "Merchandise" that contains
                  # elements with thier own nested structure that
                  # need parsed
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
225
  
b1c0def6   Samuel J Clopton   rubocop violation...
226
227
228
229
230
231
232
                  sct_item_obj = {}
                  requisition_item_obj = {}
                  purchase_order_obj = {}
  
                  unless attached_items_obj[:attached_items]
                    attached_items_obj[:attached_items] = []
                  end
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
233
  
b1c0def6   Samuel J Clopton   rubocop violation...
234
235
                  attached_items_arr = el_child.children.map do |attached_items_child|
                    next if attached_items_child.name == 'text'
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
236
  
b1c0def6   Samuel J Clopton   rubocop violation...
237
238
                    if attached_items_child.name == 'SctItem'
                      sct_item_obj[:sct_item] = [] unless sct_item_obj[:sct_item]
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
239
  
b1c0def6   Samuel J Clopton   rubocop violation...
240
241
242
                      sct_item_arr = parse_children_elements(attached_items_child)
                      sct_item_obj[:sct_item].push(sct_item_arr)
                      sct_item_obj
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
243
  
b1c0def6   Samuel J Clopton   rubocop violation...
244
245
246
247
                    elsif attached_items_child.name == 'RequisitionItem'
                      unless requisition_item_obj[:requisition_item]
                        requisition_item_obj[:requisition_item] = []
                      end
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
248
  
b1c0def6   Samuel J Clopton   rubocop violation...
249
250
251
252
253
254
255
                      requisition_item_arr = parse_children_elements(attached_items_child)
                      requisition_item_obj[:requisition_item].push(requisition_item_arr)
                      requisition_item_obj
  
                    elsif attached_items_child.name == 'PurchaseOrder'
                      unless purchase_order_obj[:purchase_order]
                        purchase_order_obj[:purchase_order] = []
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
256
                      end
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
257
  
b1c0def6   Samuel J Clopton   rubocop violation...
258
259
260
                      purchase_order_arr = parse_children_elements(attached_items_child)
                      purchase_order_obj[:purchase_order].push(purchase_order_arr)
                      purchase_order_obj
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
261
  
b1c0def6   Samuel J Clopton   rubocop violation...
262
263
264
265
266
267
268
                    else
                      {
                        name: attached_items_child.name,
                        text: attached_items_child.text
                      }
                    end
                  end.compact
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
269
  
b1c0def6   Samuel J Clopton   rubocop violation...
270
271
272
273
274
275
276
277
278
279
280
281
                  attached_items_obj[:attached_items].push(attached_items_arr)
                  attached_items_obj
  
                else
                  {
                    name: el_child.name,
                    text: el_child.text
                  }
                end
              end.compact
  
              sales_order_lines_obj[:merchandise].push(merchandise_arr)
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
282
283
284
285
286
287
288
            end
  
            sales_order_lines_obj
          end
  
          def parse_children_elements(el_child)
            obj_array = el_child.children.map do |el|
b1c0def6   Samuel J Clopton   rubocop violation...
289
              next if el.name == 'text'
b0dddc7f   Isaac Lewis   change from sorqb...
290
291
292
293
294
              {
                name: el.name,
                text: el.text
              }
            end.compact
b0dddc7f   Isaac Lewis   change from sorqb...
295
  
1fce007e   Nathan Ockerman   LM Issue 769 - sa...
296
            obj_array
b0dddc7f   Isaac Lewis   change from sorqb...
297
          end
b0dddc7f   Isaac Lewis   change from sorqb...
298
299
300
301
        end
      end
    end
  end