/** * Import customer Orders * * Import customer orders from the import array passed as a parameter, and * return customer record counts. * * @param array $aryImport * @return type * @throws \Exception */ private function _importOrders(array $aryImport) { $numRecs = count($aryImport); $newOrd = 0; $updateOrd = 0; for ($i = 0; $i < $numRecs; $i++) { $orderNum = $aryImport[$i]['orderNum']; $order = $this->getRepo('Custorder')->findByOrdernumber($orderNum); if (!$order) { //This is a new order record $newOrd++; $customer = $this->getRepo('Customer')->findByCustomerNum($aryImport[$i]['customernumber']); if (!$customer) { throw new \Exception("ERROR: Could not find customer record for Customer#: {$aryImport[$i]['customernumber']}"); } $order = new Custorder(); $order->setOrderdate(new \DateTime($aryImport[$i]['orderDate'])); $order->setOrdernumber($orderNum); $order->setCustomerId($customer->getId()); $order->setCustomer($customer); $order->setOrderstatus(Custorder::$STATUS_RECEIVED); $order->setNeedsexport(false); $order->setDeleted(0); $order->setNeedsexport(false); $this->persistEntity($order); } else { //This is an existing order record //@TODO Do something with updated order records } } $this->flushEntities(); $data = array('orderNew' => $newOrd, 'orderUpdate' => $updateOrd); $response = array('status' => true, 'data' => $data); return $response; }
public function load(ObjectManager $manager) { $order = new Custorder(); // Church on Wheels $order->setCustomerId(12975); $order->setOrdernumber(139378); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Tidmore Flags $order->setCustomerId(10719); $order->setOrdernumber(139379); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Tidmore Flags $order->setCustomerId(10719); $order->setOrdernumber(139450); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Americanflagstore.com INC $order->setCustomerId(12758); $order->setOrdernumber(139380); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Americanflagstore.com INC $order->setCustomerId(12758); $order->setOrdernumber(139381); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Flutter Flag Source $order->setCustomerId(13276); $order->setOrdernumber(139383); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Carrot-Top Industries, Inc. $order->setCustomerId(13884); $order->setOrdernumber(139386); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Carrot-Top Industries, Inc. $order->setCustomerId(13884); $order->setOrdernumber(139456); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Oats Flag Co. Inc $order->setCustomerId(11157); $order->setOrdernumber(139394); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Oats Flag Co. Inc $order->setCustomerId(11157); $order->setOrdernumber(139395); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Oats Flag Co. Inc $order->setCustomerId(11157); $order->setOrdernumber(139396); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // Oats Flag Co. Inc $order->setCustomerId(11157); $order->setOrdernumber(139447); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $order = new Custorder(); // US Flag Supply $order->setCustomerId(14584); $order->setOrdernumber(139389); $order->setOrderstatus('RECEIVED'); $order->setUpdateby(1); $order->setDeleted(0); $manager->persist($order); $manager->flush(); }