API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
81
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.51 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. require_once("../app/classes/siteClass.php");
  3. require_once(ROOT_PATH . "app/classes/databaseClass.php");
  4. require_once("iReset.php");
  5.  
  6. class ResetProductsLocationTest implements iReset
  7. {
  8. private $orderID;
  9. public function reset()
  10. {
  11. $mysqlConnection = $this->databaseConnect();
  12. $deletingPurchaseOrderQuery = "DELETE FROM koretrack_purchaseorders WHERE PONumber = 1";
  13. $deletingProductsQuery = "DELETE FROM `koretrack_products` WHERE `ID` BETWEEN 92 AND 136";
  14.  
  15. $insertingPurchaseOrderQuery = "INSERT INTO `koretrack_purchaseorders` (`ID`, `PONumber`, `SupplierCode`, `OrderDateTimestamp`, `DueDateTimestamp`, `Status`, `Notes`) VALUES (NULL, '1', '', '0', '0', 'Part Received', NULL)";
  16.  
  17.  
  18. try {
  19. //begin transaction to minimize database connections
  20. $mysqlConnection->beginTransaction();
  21.  
  22. // A set of queries; if one fails, an exception should be thrown
  23. $mysqlConnection->query($deletingPurchaseOrderQuery);
  24. $mysqlConnection->query($deletingProductsQuery);
  25. $mysqlConnection->query($insertingPurchaseOrderQuery);
  26. $purchaseOrderID = $mysqlConnection->lastInsertId();
  27. $this->orderID = $purchaseOrderID;
  28. $mysqlConnection->query("
  29. INSERT INTO `koretrack_products`(`ID`, `ProductCode`, `ProductQuantity`, `ProductUnit`, `ProductType`, `LocationID`, `PurchaseOrderID`, `Status`, `ProductLength`, `MotherID`, `Allocation`, `Notes`, `LedFlexProductsID`, `BatchNumber`) VALUES
  30. (92, 'Master 92', 2.000, 'master', 'master', 0, $purchaseOrderID, 'received', 3.000, NULL, 0, NULL, 2, 1),
  31. (93, 'Master 93', 2.000, 'master', 'master', 0, $purchaseOrderID, 'partReceived', 3.000, NULL, 0, NULL, 2, 1),
  32. (94, '011-0201', 3.000, 'Metre', 'reel', 0, $purchaseOrderID, 'notChecked', 3.000, 93, 0, NULL, 2, 1),
  33. (95, '011-0201', 1.000, 'Metre', 'piece_reel', 0, $purchaseOrderID, 'notChecked', 3.000, 94, 0, NULL, 2, 1),
  34. (96, '011-0201', 1.000, 'Metre', 'piece_reel', 0, $purchaseOrderID, 'notChecked', 3.000, 94, 0, NULL, 2, 1),
  35. (97, '011-0201', 1.000, 'Metre', 'piece_reel', 0, $purchaseOrderID, 'notChecked', 3.000, 94, 0, NULL, 2, 1),
  36. (98, '011-0201', 1.000, 'Metre', 'reel', 0, $purchaseOrderID, 'received', 1.000, 93, 0, NULL, 2, 1),
  37. (99, '011-0201', 1.000, 'Metre', 'piece_reel', 0, $purchaseOrderID, 'received', 1.000, 98, 0, NULL, 2, 1),
  38. (100, '041-1205', 5.000, 'piece', 'pack', 0, $purchaseOrderID, 'partReceived', 0.000, NULL, 0, NULL, 2, 1),
  39. (101, '041-1205', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 0.000, 100, 0, NULL, 2, 1),
  40. (102, '041-1205', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 0.000, 100, 0, NULL, 2, 1),
  41. (103, '041-1205', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 0.000, 100, 0, NULL, 2, 1),
  42. (104, '041-1205', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 0.000, 100, 0, NULL, 2, 1),
  43. (105, '041-1205', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 0.000, 100, 0, NULL, 2, 1),
  44. (106, '041-1205', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 0.000, NULL, 0, NULL, 2, 1),
  45. (107, '041-1205', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'notChecked', 0.000, NULL, 0, NULL, 2, 1),
  46. (108, '041-1205', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'notChecked', 0.000, NULL, 0, NULL, 2, 1),
  47. (109, '041-1205', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'notChecked', 0.000, NULL, 0, NULL, 2, 1),
  48. (110, '041-1205', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'notChecked', 0.000, NULL, 0, NULL, 2, 1),
  49. (111, '010-6106', 4.000, 'Metre', 'pack_neon', 0, $purchaseOrderID, 'partReceived', 2.000, NULL, 0, NULL, 2, 1),
  50. (112, '010-6106', 1.000, 'Metre', 'piece_neon', 0, $purchaseOrderID, 'received', 2.000, 111, 0, NULL, 2, 1),
  51. (113, '010-6106', 1.000, 'Metre', 'piece_neon', 0, $purchaseOrderID, 'received', 2.000, 111, 0, NULL, 2, 1),
  52. (114, '010-6106', 1.000, 'Metre', 'piece_neon', 0, $purchaseOrderID, 'notChecked', 2.000, 111, 0, NULL, 2, 1),
  53. (115, '010-6106', 1.000, 'Metre', 'piece_neon', 0, $purchaseOrderID, 'notChecked', 2.000, 111, 0, NULL, 2, 1),
  54. (116, '010-6106', 1.000, 'Metre', 'pack_neon', 0, $purchaseOrderID, 'received', 1.000, 92, 0, NULL, 2, 1),
  55. (117, '010-6106', 1.000, 'Metre', 'piece_neon', 0, $purchaseOrderID, 'received', 1.000, 116, 0, NULL, 2, 1),
  56. (118, '010-6106', 1.000, 'Metre', 'pack_neon', 0, $purchaseOrderID, 'received', 1.000, 92, 0, NULL, 2, 1),
  57. (119, '010-6106', 1.000, 'Metre', 'piece_neon', 0, $purchaseOrderID, 'received', 1.000, 118, 0, NULL, 2, 1),
  58. (120, '013-0531', 8.000, 'piece', 'pack', 0, $purchaseOrderID, 'received', 1.000, NULL, 0, NULL, 2, 1),
  59. (121, '013-0531', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 1.000, 120, 0, NULL, 2, 1),
  60. (122, '013-0531', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 1.000, 120, 0, NULL, 2, 1),
  61. (123, '013-0531', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 1.000, 120, 0, NULL, 2, 1),
  62. (124, '013-0531', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 1.000, 120, 0, NULL, 2, 1),
  63. (125, '013-0531', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 1.000, 120, 0, NULL, 2, 1),
  64. (126, '013-0531', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 1.000, 120, 0, NULL, 2, 1),
  65. (127, '013-0531', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 1.000, 120, 0, NULL, 2, 1),
  66. (128, '013-0531', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 1.000, 120, 0, NULL, 2, 1),
  67. (129, '013-0531', 2.000, 'piece', 'pack', 0, $purchaseOrderID, 'received', 1.000, NULL, 0, NULL, 2, 1),
  68. (130, '013-0531', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 1.000, 129, 0, NULL, 2, 1),
  69. (131, '013-0531', 1.000, 'piece', 'piece', 0, $purchaseOrderID, 'received', 1.000, 129, 0, NULL, 2, 1) ");
  70.  
  71. $mysqlConnection->commit();
  72. } catch (Exception $e) {
  73. // An exception has been thrown
  74. // We must rollback the transaction
  75. $mysqlConnection->rollback();
  76. return array('error' => $e->getMessage(), 'result' => false);
  77. }
  78.  
  79. return array('error' => '', 'result' => true);
  80. }
  81.  
  82. public function remove()
  83. {
  84. $mysqlConnection = $this->databaseConnect();
  85. $deletingPurchaseOrderQuery = "DELETE FROM koretrack_purchaseorders WHERE PONumber = 1";
  86. $deletingProductsQuery = "DELETE FROM `koretrack_products` WHERE `ID` BETWEEN 92 AND 136";
  87.  
  88. try {
  89. //begin transaction to minimize database connections
  90. $mysqlConnection->beginTransaction();
  91.  
  92. // A set of queries; if one fails, an exception should be thrown
  93. $mysqlConnection->query($deletingProductsQuery);
  94. $mysqlConnection->query($deletingPurchaseOrderQuery);
  95.  
  96.  
  97. $mysqlConnection->commit();
  98. } catch (Exception $e) {
  99. // An exception has been thrown
  100. // We must rollback the transaction
  101. $mysqlConnection->rollback();
  102. return array('error' => $e->getMessage(), 'result' => false);
  103. }
  104.  
  105. return array('error' => '', 'result' => true);
  106. }
  107.  
  108. public function addMastersToOrder(){
  109.  
  110. $mysqlConnection = $this->databaseConnect();
  111. $deletingProductsQuery = "DELETE FROM `koretrack_products` WHERE `ID` BETWEEN 92 AND 136";
  112.  
  113. $insertingProductsQuery = "INSERT INTO `koretrack_products` (`ID`, `ProductCode`, `ProductQuantity`, `ProductUnit`, `ProductType`, `LocationID`, `PurchaseOrderID`, `Status`, `ProductLength`, `MotherID`, `Allocation`, `Notes`, `LedFlexProductsID`, `BatchNumber`) VALUES
  114. (136, 'Master 136', 4.000, 'master', 'master', 0, $this->orderID, 'received', 0.000, NULL, NULL, NULL,1,2),
  115. (135, 'Master 135', 3.000, 'master', 'master', 0, $this->orderID, 'received', 0.000, 136, NULL, NULL,1,2),
  116. (133, 'Master 133', 2.000, 'master', 'master', 0, $this->orderID, 'received', 0.000, 135, NULL, NULL,1,2),
  117. (132, 'Master 132', 3.000, 'master', 'master', 0, $this->orderID, 'received', 0.000, 133, NULL, NULL,1,2),
  118. (134, 'Master 134', 3.000, 'master', 'master', 0, $this->orderID, 'received', 0.000, 136, NULL, NULL,1,2),
  119. (92, 'Master 92', 2.000, 'master', 'master', 1, $this->orderID, 'received', 3.000, 133, NULL, NULL,1,2),
  120. (93, 'Master 93', 2.000, 'master', 'master', 0, $this->orderID, 'received', 3.000, 132, NULL, NULL,1,2),
  121. (94, '011-0201', 3.000, 'Metre', 'reel', 0, $this->orderID, 'received', 3.000, 93, NULL, NULL,1,2),
  122. (95, '011-0201', 1.000, 'Metre', 'piece_reel', 0, $this->orderID, 'received', 3.000, 94, NULL, NULL,1,2),
  123. (96, '011-0201', 1.000, 'Metre', 'piece_reel', 0,$this->orderID, 'received', 3.000, 94, NULL, NULL,1,2),
  124. (97, '011-0201', 1.000, 'Metre', 'piece_reel', 0,$this->orderID, 'received', 3.000, 94, NULL, NULL,1,2),
  125. (98, '011-0201', 1.000, 'Metre', 'reel', 1, $this->orderID, 'received', 1.000, 93, NULL, NULL,1,2),
  126. (99, '011-0201', 1.000, 'Metre', 'piece_reel', 1, $this->orderID, 'received', 1.000, 98, NULL, NULL,1,2),
  127. (100, '041-1205', 5.000, 'piece', 'pack', 0, $this->orderID, 'received', 0.000, 134, NULL, NULL,1,2),
  128. (101, '041-1205', 1.000, 'piece', 'piece', 0, $this->orderID, 'received', 0.000, 100, NULL, NULL,1,2),
  129. (102, '041-1205', 1.000, 'piece', 'piece', 0, $this->orderID, 'received', 0.000, 100, NULL, NULL,1,2),
  130. (103, '041-1205', 1.000, 'piece', 'piece', 0, $this->orderID, 'received', 0.000, 100, NULL, NULL,1,2),
  131. (104, '041-1205', 1.000, 'piece', 'piece', 0, $this->orderID, 'received', 0.000, 100, NULL, NULL,1,2),
  132. (105, '041-1205', 1.000, 'piece', 'piece', 0, $this->orderID, 'received', 0.000, 100, NULL, NULL,1,2),
  133. (106, '041-1205', 1.000, 'piece', 'piece', 2 ,$this->orderID, 'received', 0.000, 134, NULL, NULL,1,2),
  134. (107, '041-1205', 1.000, 'piece', 'piece', 0, $this->orderID, 'received', 0.000, 136, NULL, NULL,1,2),
  135. (108, '041-1205', 1.000, 'piece', 'piece', 0, $this->orderID, 'received', 0.000, 136, NULL, NULL,1,2),
  136. (109, '041-1205', 1.000, 'piece', 'piece', 0, $this->orderID, 'received', 0.000, 132, NULL, NULL,1,2),
  137. (110, '041-1205', 1.000, 'piece', 'piece', 0, $this->orderID, 'received', 0.000, 132, NULL, NULL,1,2),
  138. (111, '010-6106', 4.000, 'Metre', 'pack_neon', 0, $this->orderID, 'received', 2.000, 135, NULL, NULL,1,2),
  139. (112, '010-6106', 1.000, 'Metre', 'piece_neon', 0, $this->orderID, 'received', 2.000, 111, NULL, NULL,1,2),
  140. (113, '010-6106', 1.000, 'Metre', 'piece_neon', 0, $this->orderID, 'received', 2.000, 111, NULL, NULL,1,2),
  141. (114, '010-6106', 1.000, 'Metre', 'piece_neon', 0, $this->orderID, 'received', 2.000, 111, NULL, NULL,1,2),
  142. (115, '010-6106', 1.000, 'Metre', 'piece_neon', 0, $this->orderID, 'received', 2.000, 111, NULL, NULL,1,2),
  143. (116, '010-6106', 1.000, 'Metre', 'pack_neon', 1, $this->orderID, 'received', 1.000, 92, NULL, NULL,1,2),
  144. (117, '010-6106', 1.000, 'Metre', 'piece_neon', 1, $this->orderID, 'received', 1.000, 116, NULL, NULL,1,2),
  145. (118, '010-6106', 1.000, 'Metre', 'pack_neon', 1, $this->orderID, 'received', 1.000, 92, NULL, NULL,1,2),
  146. (119, '010-6106', 1.000, 'Metre', 'piece_neon', 1, $this->orderID, 'received', 1.000, 118, NULL, NULL,1,2),
  147. (120, '013-0531', 8.000, 'piece', 'pack', 2, $this->orderID, 'received', 1.000, 134, NULL, NULL,1,2),
  148. (121, '013-0531', 1.000, 'piece', 'piece', 2, $this->orderID, 'received', 1.000, 120, NULL, NULL,1,2),
  149. (122, '013-0531', 1.000, 'piece', 'piece', 2, $this->orderID, 'received', 1.000, 120, NULL, NULL,1,2),
  150. (123, '013-0531', 1.000, 'piece', 'piece', 2, $this->orderID, 'received', 1.000, 120, NULL, NULL,1,2),
  151. (124, '013-0531', 1.000, 'piece', 'piece', 2, $this->orderID, 'received', 1.000, 120, NULL, NULL,1,2),
  152. (125, '013-0531', 1.000, 'piece', 'piece', 2, $this->orderID, 'received', 1.000, 120, NULL, NULL,1,2),
  153. (126, '013-0531', 1.000, 'piece', 'piece', 2, $this->orderID, 'received', 1.000, 120, NULL, NULL,1,2),
  154. (127, '013-0531', 1.000, 'piece', 'piece', 2, $this->orderID, 'received', 1.000, 120, NULL, NULL,1,2),
  155. (128, '013-0531', 1.000, 'piece', 'piece', 2, $this->orderID, 'received', 1.000, 120, NULL, NULL,1,2),
  156. (129, '013-0531', 2.000, 'piece', 'pack', 2, $this->orderID, 'received', 1.000, 135, NULL, NULL,1,2),
  157. (130, '013-0531', 1.000, 'piece', 'piece', 2, $this->orderID, 'received', 1.000, 129, NULL, NULL,1,2),
  158. (131, '013-0531', 1.000, 'piece', 'piece', 2,$this->orderID, 'received', 1.000, 129, NULL, NULL,1,2)
  159. ";
  160. try {
  161. //begin transaction to minimize database connections
  162. $mysqlConnection->beginTransaction();
  163.  
  164. // A set of queries; if one fails, an exception should be thrown
  165. $mysqlConnection->query($deletingProductsQuery);
  166. $mysqlConnection->query($insertingProductsQuery);
  167.  
  168. $mysqlConnection->commit();
  169. } catch (Exception $e) {
  170. // An exception has been thrown
  171. // We must rollback the transaction
  172. $mysqlConnection->rollback();
  173. return array('error' => $e->getMessage(), 'result' => false);
  174. }
  175.  
  176. return array('error' => '', 'result' => true);
  177. }
  178.  
  179. private function databaseConnect()
  180. {
  181. return DatabaseConnection::getInstance()->getConnection();
  182. }
  183. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!