Tutorial Extension  1.0.0
SellerDeck Extensions - Tutorial Extension
COrderBase.php
1 <?php
2 
3 /**
4  * COrderBase.php - Implementation of Catalog/Order table class.
5  *
6  * @package SellerDeck Extensions
7  *
8  * @author Péter Erdődi
9  * @copyright © SellerDeck Ltd 2015. All rights reserved.
10  */
11 
12 namespace SDExtension\DB\Table;
13 
14 if (!defined('TABLE_ORDER'))
15  {
16  define('TABLE_ORDER', 'Order');
17  }
18 
19 class COrderBase extends CTable
20  {
21 
22  /**
23  * @var string $m_sTable Table
24  */
25  protected $m_sTable = TABLE_ORDER;
26 
27  /**
28  * @var string $m_sIdColumn ID Column name
29  */
30  protected $m_sIdColumn = 'Order Sequence Number';
31 
32  /**
33  * @var array $m_aDefaultValues Default Values
34  */
35  protected $m_aDefaultValues = [
36  'Order Sequence Number' => '',
37  'Order Number' => '',
38  'Version' => 1,
39  'Program Version' => '6AAA',
40  'Update Count' => 1,
41  'IP address' => null,
42  'Status' => 'N',
43  'Currency' => 'GPB',
44  'sUserDefinedPayment' => null,
45  'Movement' => 0,
46  'Reason For Purchase' => null,
47  'How Find Site' => null,
48  'sUserDefinedGeneral' => ' ',
49  'Total Cost' => 0,
50  'Discount Cost' => 0,
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,
61  'Total Lines' => 0,
62  'Total Lines Shipped' => 0,
63  'Total Lines Cancelled' => 0,
64  'Credit Card Expiry Date' => null,
65  'sCreditCardStartDate' => null,
66  'Date Ordered' => '',
67  'Date Received' => '',
68  'PO Number' => null,
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,
81  'ReportNumber' => 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,
91  'nBomStatus' => 0,
92  'sDateCCPrinted' => '',
93  'Discount Percent' => 0,
94  'Tax Percent 1' => 0,
95  'Tax Percent 2' => 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,
103  'sChecksum' => null,
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, //false
125  'bTax2UserExempt' => 0, //false
126  'sTax1ExemptionData' => null,
127  'sTax2ExemptionData' => null,
128  'nBuyerID' => -1,
129  'nCustomerID' => -1,
130  'nTotalItemsOrdered' => 0,
131  'nTotalItemsShipped' => 0,
132  'nTotalItemsCancelled' => 0,
133  'nTotalItemsBackOrdered' => 0,
134  'bOrderIsDeleted' => 0, //false
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',
140  'sTax1Name' => null,
141  'sTax2Name' => null,
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,
151  'nTax1Id' => 0,
152  'nTax2Id' => 0,
153  'sSeparatePackageDetails' => null,
154  'sMixedPackageDetails' => null,
155  'dOriginalOrderAdjustments' => 0,
156  'sCouponCode' => null,
157  'bECI' => 0, //false
158  'nColor' => -1,
159  'bOfflineOrder' => 0, //false
160  'sJournal' => null,
161  'bTermsAccepted' => 0, //false
162  'sCreditCardIssueNumber' => SQL_TYPE_STRING . '-1',
163  'bLockedForReport' => 0, //false
164  'sOriginalCustOrd' => 'U',
165  'nEncryptionType' => 0,
166  'Credit Card Number' => null,
167  'sEncryptionData' => null,
168  'Update Date' => '',
169  'Action Due Date' => null,
170  'bOngoingOrder' => 0, //false
171  'bTaxInclusiveMode' => true,
172  'bZoneTax1Applies' => true,
173  'bZoneTax2Applies' => 0, //false
174  'bTransferedToEPOS' => 0, //false
175  'sInvoiceNumber' => null,
176  'sTaxPoint' => null,
177  'nFraudState' => 0,
178  'ePickedStatus' => 0,
179  'bSentToFeefo' => 0, //false
180  'sTrackingCode' => null,
181  'bUseDatePromptAsDeliveryDate' => 0, //false
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, //false
191  'bInternationalShipping' => 0, //false
192  'nNumPackages' => -1,
193  'dTotalWeight' => -1,
194  'sChannelName' => '',
195  'sOriginalShipClass' => 'Unknown',
196  ];
197 
198  /**
199  * CreateOriginalCopies - Creates Original Copies
200  *
201  * @access public
202  * @return void
203  */
204  public function CreateOriginalCopies()
205  {
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'];
225  }
226 
227  }