14 if (!defined(
'TABLE_ORDER'))
16 define(
'TABLE_ORDER',
'Order');
25 protected $m_sTable = TABLE_ORDER;
30 protected $m_sIdColumn =
'Order Sequence Number';
35 protected $m_aDefaultValues = [
36 'Order Sequence Number' =>
'',
39 'Program Version' =>
'6AAA',
44 'sUserDefinedPayment' => null,
46 'Reason For Purchase' => null,
47 'How Find Site' => null,
48 'sUserDefinedGeneral' =>
' ',
51 'Sub-heading Cost' => 0,
52 'Shipping Total Cost' => 0,
53 'Shipping Tax Treatment' => 0,
54 'Shipping Tax Cost 1' => 0,
55 'Shipping Tax Cost 2' => 0,
56 'sUserDefinedShipping' => null,
57 'Tax Total Cost 1' => 0,
58 'Tax Total Cost 2' => 0,
59 'sUserDefinedTax' => null,
60 'Order Total Cost' => 0,
62 'Total Lines Shipped' => 0,
63 'Total Lines Cancelled' => 0,
64 'Credit Card Expiry Date' => null,
65 'sCreditCardStartDate' => null,
67 'Date Received' =>
'',
69 'Date Order Finished' => null,
70 'Adjustment Message' => null,
71 'Original Tax Cost 1' => 0,
72 'Original Tax Cost 2' => 0,
73 'Original Shipping Cost' => 0,
74 'Original Shipping Tax Treatment' => 0,
75 'Original Shipping Tax Cost 1' => 0,
76 'Original Shipping Tax Cost 2' => 0,
77 'Original Order Cost' => 0,
78 'Original Sub-heading Cost' => 0,
79 'Original Discount Cost' => 0,
80 'Original Total Cost' => 0,
82 'InvoiceContactID' => 0,
83 'DeliverContactID' => 0,
84 'CC Authorization code' => null,
85 'sReferenceNumber' => null,
86 'sOpaqueShipData' =>
'',
87 'sCatalogKey' => null,
88 'sShippingDescription' =>
'',
89 'nPaymentStatus' =>
'10',
90 'nInvoiceStatus' => 0,
92 'sDateCCPrinted' =>
'',
93 'Discount Percent' => 0,
96 'Original Discount Percent' => 0,
97 'Original Tax Percent 1' => 0,
98 'Original Tax Percent 2' => 0,
99 'Payment Option' =>
'10002',
100 'nTotalLinesBackOrdered' => 0,
101 'sBackorderNumber' => null,
102 'nParentSequenceNumber' => 0,
104 'sDeliveryCountryCode' => null,
105 'sDeliveryRegionCode' => null,
106 'sInvoiceCountryCode' => null,
107 'sInvoiceRegionCode' => null,
108 'dHandlingCost' => 0,
109 'nHandlingTaxTreatment' => 0,
110 'dHandlingTax1' => 0,
111 'dHandlingTax2' => 0,
112 'dOriginalHandlingCost' => 0,
113 'nOriginalHandlingTaxTreatment' => 0,
114 'dOriginalHandlingTax1' => 0,
115 'dOriginalHandlingTax2' => 0,
116 'sOpaqueHandlingData' =>
'Handling;0;',
117 'sHandlingDescription' => null,
118 'sTax1OpaqueData' =>
'VAT=2=0=0=0=0=0=3=',
119 'sTax2OpaqueData' =>
'=0=0=0=0=0=0=0=',
120 'sTaxModelOpaqueData' =>
'1=2=0=0=0=Zero-Rated=0=0=0==0=0=0==0=0=0==',
121 'sOrigTaxModelOpaqueData' =>
'1=2=0=0=0=Zero-Rated=0=0=0==0=0=0==0=0=0==',
122 'sOrigTax1OpaqueData' =>
'=0=0=0=0=0=0=0=',
123 'sOrigTax2OpaqueData' =>
'=0=0=0=0=0=0=0=',
124 'bTax1UserExempt' => 0,
125 'bTax2UserExempt' => 0,
126 'sTax1ExemptionData' => null,
127 'sTax2ExemptionData' => null,
130 'nTotalItemsOrdered' => 0,
131 'nTotalItemsShipped' => 0,
132 'nTotalItemsCancelled' => 0,
133 'nTotalItemsBackOrdered' => 0,
134 'bOrderIsDeleted' => 0,
135 'Credit Card Type' => null,
136 'sTax1ShippingCode' => SQL_TYPE_STRING .
'000',
137 'sTax2ShippingCode' => SQL_TYPE_STRING .
'000',
138 'sTax1HandlingCode' => SQL_TYPE_STRING .
'000',
139 'sTax2HandlingCode' => SQL_TYPE_STRING .
'000',
142 'dTax1ShippingRate' => 0,
143 'dTax1HandlingRate' => 0,
144 'dTax2ShippingRate' => 0,
145 'dTax2HandlingRate' => 0,
146 'sCreditCardVV2' => SQL_TYPE_STRING .
'-1',
147 'nSSPProviderID' => -1,
148 'sSSPOpaqueData' => null,
149 'nPreauthReportNumber' => 0,
150 'sWorldShipExportDate' => null,
153 'sSeparatePackageDetails' => null,
154 'sMixedPackageDetails' => null,
155 'dOriginalOrderAdjustments' => 0,
156 'sCouponCode' => null,
159 'bOfflineOrder' => 0,
161 'bTermsAccepted' => 0,
162 'sCreditCardIssueNumber' => SQL_TYPE_STRING .
'-1',
163 'bLockedForReport' => 0,
164 'sOriginalCustOrd' =>
'U',
165 'nEncryptionType' => 0,
166 'Credit Card Number' => null,
167 'sEncryptionData' => null,
169 'Action Due Date' => null,
170 'bOngoingOrder' => 0,
171 'bTaxInclusiveMode' =>
true,
172 'bZoneTax1Applies' =>
true,
173 'bZoneTax2Applies' => 0,
174 'bTransferedToEPOS' => 0,
175 'sInvoiceNumber' => null,
178 'ePickedStatus' => 0,
180 'sTrackingCode' => null,
181 'bUseDatePromptAsDeliveryDate' => 0,
182 'nCustomMessageStatusID' => 0,
183 'nCarrierStatus' => 0,
184 'sCarrierName' => null,
185 'sCarrierClassOfService' => null,
186 'sCarrierLabelPrintedDate' => null,
187 'sCarrierShipmentCommittedDate' => null,
188 'sCarrierMessage' => null,
189 'sDespatchDate' => null,
190 'bGFSAddressValidated' => 0,
191 'bInternationalShipping' => 0,
192 'nNumPackages' => -1,
193 'dTotalWeight' => -1,
194 'sChannelName' =>
'',
195 'sOriginalShipClass' =>
'Unknown',
206 $this->m_aActualValues[
'Original Discount Percent'] = $this->m_aActualValues[
'Discount Percent'];
207 $this->m_aActualValues[
'nOriginalHandlingTaxTreatment'] = $this->m_aActualValues[
'nHandlingTaxTreatment'];
208 $this->m_aActualValues[
'Original Tax Percent 1'] = $this->m_aActualValues[
'Tax Percent 1'];
209 $this->m_aActualValues[
'Original Tax Percent 2'] = $this->m_aActualValues[
'Tax Percent 2'];
210 $this->m_aActualValues[
'sOrigTax1OpaqueData'] = $this->m_aActualValues[
'sTax1OpaqueData'];
211 $this->m_aActualValues[
'sOrigTax2OpaqueData'] = $this->m_aActualValues[
'sTax2OpaqueData'];
212 $this->m_aActualValues[
'sOrigTaxModelOpaqueData'] = $this->m_aActualValues[
'sTaxModelOpaqueData'];
213 $this->m_aActualValues[
'Original Discount Cost'] = $this->m_aActualValues[
'Discount Cost'];
214 $this->m_aActualValues[
'dOriginalHandlingCost'] = $this->m_aActualValues[
'dHandlingCost'];
215 $this->m_aActualValues[
'dOriginalHandlingTax1'] = $this->m_aActualValues[
'dHandlingTax1'];
216 $this->m_aActualValues[
'dOriginalHandlingTax2'] = $this->m_aActualValues[
'dHandlingTax2'];
217 $this->m_aActualValues[
'Original Shipping Cost'] = $this->m_aActualValues[
'Shipping Total Cost'];
218 $this->m_aActualValues[
'Original Sub-heading Cost'] = $this->m_aActualValues[
'Sub-heading Cost'];
219 $this->m_aActualValues[
'Original Shipping Tax Cost 1'] = $this->m_aActualValues[
'Shipping Tax Cost 1'];
220 $this->m_aActualValues[
'Original Shipping Tax Cost 2'] = $this->m_aActualValues[
'Shipping Tax Cost 2'];
221 $this->m_aActualValues[
'Original Tax Cost 1'] = $this->m_aActualValues[
'Tax Total Cost 1'];
222 $this->m_aActualValues[
'Original Tax Cost 2'] = $this->m_aActualValues[
'Tax Total Cost 2'];
223 $this->m_aActualValues[
'Original Order Cost'] = $this->m_aActualValues[
'Order Total Cost'];
224 $this->m_aActualValues[
'Original Total Cost'] = $this->m_aActualValues[
'Total Cost'];