public function convertSingleToArray($data)
{
$array = array();
$input = TransactionUtility::checkStore($data->getId(), INSERT_STORE_ACRION);
if (isset($input[0])) {
$input = $input[0]['sum_store'];
} else {
$input = 0;
}
$output = TransactionUtility::checkStore($data->getId(), ADD_ORDER_ACTION);
if (isset($output[0])) {
$output = $output[0]['sum_store'];
} else {
$output = 0;
}
$supplier = Utility::getSupplierInfo($data->getSupplier());
$array['id'] = $data->getId();
$array['name'] = $data->getName();
$array['quantityInput'] = number_format($input);
$array['quantityOutput'] = number_format($output);
$array['quantityInStock'] = TransactionUtility::getMenuItemQuantityInStore($data->getId());
$array['unit'] = $data->getUnit();
$array['outOfStock'] = $data->getOutOfStock();
$array['des'] = $data->getDes();
$array['cost'] = $data->getCost();
$array['supplier'] = $supplier->getCompanyName();
$array['supplyType'] = $data->getSupplyItem();
$array['InMenu'] = Utility::getMenuInMenuStore($data->getId());
return $array;
}
public function onBootstrap(Event $e)
{
$app = $e->getApplication();
Utility::setSM($app->getServiceManager());
TransactionUtility::setSM($app->getServiceManager());
UnitCalcUtility::setSM($app->getServiceManager());
}
public function convertToArray($datas, $store = SUB_STORE)
{
$return = array();
foreach ($datas as $data) {
$storeInfo = Utility::getStoreInfo($data->getMenuStoreId());
if ($store == MAIN_STORE) {
$storeInfo = Utility::getMainStoreInfo($data->getMenuStoreId());
}
$note = TransactionUtility::getStoreItemInOrder($data->getNote());
if ($note == '') {
$note = $data->getNote();
}
$supplier = Utility::getSupplierInfo($data->getSupplier());
$array = array();
$array['id'] = $data->getId();
$array['menuStoreId'] = $storeInfo->getName();
$array['action'] = $data->getAction();
$array['quantity'] = $data->getQuantity();
$array['unit'] = $data->getUnit();
$array['date'] = date('d-m-Y', $data->getDate());
$array['note'] = $note;
$array['cost'] = $data->getCost();
$array['supplier'] = $supplier->getCompanyName();
$return[] = $array;
}
return $return;
}
public function indexAction()
{
TransactionUtility::updateQuantityMenuItemInStore(1, ADD_ORDER, ADD_ORDER_ACTION);
die;
$data['menuStoreId'] = 1;
$data['quantity'] = -10;
$data['action'] = 'X';
$data['unit'] = 'KG';
$data['menuId'] = 1;
TransactionUtility::insertTransaction($data);
die;
}
protected function insertTransaction($menuStoreId, $data)
{
$subStoreId = $this->insertSubStore($data);
//insert transaction
//insert transaction in menuID
$data['menuStoreId'] = $subStoreId;
$data['quantity'] = $data['quantity'] * INSERT_STORE;
$data['action'] = INSERT_STORE_ACRION;
$data['unit'] = $data['unit'];
$data['note'] = $this->translator->translate('Import item into store');
TransactionUtility::insertTransaction($data, 0, 0);
//transaction main store
$data['menuStoreId'] = $menuStoreId;
$data['quantity'] = $data['quantity'] * ADD_ORDER;
$data['action'] = ADD_ORDER_ACTION;
$data['unit'] = $data['unit'];
$data['note'] = $this->translator->translate('Insert sub store');
TransactionUtility::insertTransaction($data, 0, 0, MAIN_STORE);
}
public function mailAction()
{
TransactionUtility::checkAndSendNotifyEmail();
die;
}
static function insertOrderDetail($data, $orderID)
{
$table = self::$servicelocator->get('doctrine');
$table = new orderdetailModel($table);
$orderDetail = new OrderDetail();
$orderDetail->setOrderId($orderID);
$orderDetail->setMenuId($data['menuid']);
$orderDetail->setQuantity($data['quantity']);
$orderDetail->setMenuCost($data['menuCost']);
$orderDetail->setRealCost($data['realcost']);
$orderDetail->setIsdelete(0);
$orderDetail->setCostType($data['orderDetailType']);
$orderDetail->setDiscount($data['discount']);
$orderDetail->setCustomerId(0);
$orderDetail->setTime(date('Y-m-d H:i:s', time()));
$orderDetailInserted = $table->insert($orderDetail);
//insert transaction
TransactionUtility::updateQuantityMenuItemInStore($data['menuid'], $data['quantity'], ADD_ORDER, ADD_ORDER_ACTION, json_encode(array('orderID' => $orderID, 'orderDetailId' => $orderDetailInserted->getID())), $orderID);
$config = self::getConfig();
}
public function addMultiAction()
{
if ($this->getRequest()->isPost()) {
$datas = $this->params()->fromPost('item');
$menuStoreId = 0;
foreach ($datas as $data) {
if ($data['quantity'] > 0) {
$name = $data['name'];
$menuStore = $this->menuStoreModel->findOneBy(array('name' => $name));
if ($menuStore) {
$menuStore->setName($data['name']);
$menuStore->setUnit($data['unit']);
$menuStore->setDes('');
$menuStore->setOutOfStock(0);
$menuStore->setCost(0);
$menuStore->setSupplier(0);
$menuStore->setSupplyItem($data['supplyType']);
$menuStore->setIsdelete(0);
$this->menuStoreModel->edit($menuStore);
$menuStoreId = $menuStore->getId();
} else {
//else add
$menuStore = new MenuStore();
$menuStore->setName($data['name']);
$menuStore->setUnit($data['unit']);
$menuStore->setDes('');
$menuStore->setOutOfStock(0);
$menuStore->setCost(0);
$menuStore->setSupplier(0);
$menuStore->setSupplyItem($data['supplyType']);
$menuStore->setIsdelete(0);
$menuStore = $this->menuStoreModel->insert($menuStore);
$menuStoreId = $menuStore->getId();
}
//insert transaction
//insert transaction in menuID
$data['menuStoreId'] = $menuStoreId;
$data['quantity'] = $data['quantity'] * INSERT_STORE;
$data['action'] = INSERT_STORE_ACRION;
$data['unit'] = $data['unit'];
$data['note'] = $this->translator->translate('Import item into store');
TransactionUtility::insertTransaction($data, 0, 0);
//transaction main store
$data['menuStoreId'] = $data['id'];
$data['quantity'] = $data['quantity'] * ADD_ORDER;
$data['action'] = ADD_ORDER_ACTION;
$data['unit'] = $data['unit'];
$data['note'] = $this->translator->translate('Insert sub store');
TransactionUtility::insertTransaction($data, 0, 0, MAIN_STORE);
}
}
//flash
$this->flashMessenger()->addSuccessMessage("Insert Success");
$this->redirect()->toRoute('admin/child', array('controller' => 'menustore'));
}
return new ViewModel(array('title' => $this->translator->translate('Add Inventory Multi')));
}
