/**
* 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();
}
