public function addAction() { $request = $this->getRequest(); if ($request->isPost()) { $data = $this->params()->fromPost(); echo json_encode($data); die; //check api $userApi = Utility::userApi($data['userName'], $data['apiKey']); if ($userApi->getId() == '') { die(-1); } $this->userId = $userApi->getId(); //end check api // insert new customer before insert new order $customerId = Utility::createCustomer($data); //insert new order $order = new Orders(); $order->setUserId($this->userId); $order->setStatus($data['status']); $order->setTotalCost($data['total_cost']); $order->setTotalRealCost($data['total_real_cost']); $order->setCreateDate(time()); $order->setIsdelete(0); $order->setTableId(0); $order->setSurtaxId(0); $order->setCustomerId($customerId); //end insert new order $order = $this->orderModel->insert($order); $orderId = $order->getId(); //insert orderDetail $orderDetails = $data['detai']; foreach ($orderDetails as $details) { $orderDetail = new OrderDetail(); $orderDetail->setOrderId($orderId); $orderDetail->setMenuId($details['menu_id']); $orderDetail->setCostType($details['cost_type']); $orderDetail->setQuantity($details['quantity']); $orderDetail->setMenuCost($details['menu_cost']); $orderDetail->setRealCost($details['real_cost']); $orderDetail->setCustomerId($customerId); $orderDetail->setIsdelete(0); $this->orderDetailModel->insert($orderDetail); } //insert order detail die; } die; }
public static function addNewOrder($param, $request, $url = 'admin/child') { $tables = self::$servicelocator->get('doctrine'); $table = new orderModel($tables); $orderItem = new orderdetailModel($tables); $tableModel = new tableModel($tables); $transactionModel = new transactionModel($tables); $translator = self::translate(); $id = $param->fromRoute('id'); $catID = 0; $tableManage = $tableModel->findBy(array('isdelete' => 0)); $save = $param->fromPost('save'); $status = 'pending'; $isdelete = 0; if ($save == "payment") { $status = 'finish'; $isdelete = 1; } //insert if ($id == '') { if ($request->isPost()) { $Auth_service = new AuthenticationService(); $auth = $Auth_service->getIdentity(); if ($auth->userId) { $tableId = $param->fromPost('table_id'); $dataDetail = $param->fromPost('detail'); $totalRealCost = $param->fromPost('total_real_cost'); $cat = new Orders(); $cat->setTotalCost($param->fromPost('total_cost')); $cat->setTableId($param->fromPost('table_id')); $cat->setCreateDate(time()); $cat->setCouponId($param->fromPost('coupon_id')); $cat->setToTalRealCost($totalRealCost); $cat->setUserId($auth->userId); $cat->setSurtaxId($param->fromPost('surtax_id')); $cat->setIsdelete(0); $cat->setStatus($status); $cat->setCustomerId(0); $cat->setNewDate(date('Y-m-d H:i:s', time())); $cat = $table->insert($cat); $catID = $cat->getId(); if ($param->fromPost('coupon_id') != -1) { $doctrine = self::$servicelocator->get('doctrine'); $couponModel = new couponModel($doctrine); $coupon = $couponModel->findOneBy(array('id' => $param->fromPost('coupon_id'))); if ($coupon->getReuse() == 0) { if ($save == 'payment') { $coupon->setIsdelete($isdelete); $couponModel->edit($coupon); } } } foreach ($dataDetail as $k => $val) { if ($val['menuid'] != -1) { self::insertOrderDetail($val, $catID); } } if ($save == 'payment') { $url = "http://" . $_SERVER['HTTP_HOST'] . '/frontend/order/detail/' . $catID; header("Location:" . $url); exit; } else { $url = "http://" . $_SERVER['HTTP_HOST'] . '/frontend/order/add'; header("Location:" . $url); exit; } } else { $url = "http://" . $_SERVER['HTTP_HOST'] . '/frontend/login'; header("Location:" . $url); exit; } } //insert new user //$this->redirect()->toRoute('admin/child',array('controller'=>'category')); return array('title' => $translator->translate('Add new order'), 'data' => null, 'url' => $url, 'orderId' => $catID, 'tables' => $tableManage, 'dataObject' => array()); } else { $cats = $table->findOneBy(array('id' => $id)); $orderDetail = $orderItem->findBy(array('orderId' => $id, 'isdelete' => 0)); if ($request->isPost()) { $idFormPost = $param->fromPost('id'); $cat = $table->findOneBy(array('id' => $idFormPost)); $dataDetail = $param->fromPost('detail'); $Auth_service = new AuthenticationService(); $auth = $Auth_service->getIdentity(); $totalRealCost = $param->fromPost('total_real_cost'); $totalCost = $param->fromPost('total_cost'); $tableId = $param->fromPost('table_id'); $cat->setTotalCost($totalCost); $cat->setTableId($param->fromPost('table_id')); $cat->setCreateDate(time()); $cat->setCouponId($param->fromPost('coupon_id')); $cat->setToTalRealCost($totalRealCost); $cat->setUserId($auth->userId); $cat->setSurtaxId($param->fromPost('surtax_id')); $cat->setIsdelete(0); $cat->setStatus($status); $cat->setCustomerId(0); $cat->setNewDate(date('Y-m-d H:i:s', time())); $table->edit($cat); if ($param->fromPost('coupon_id') != -1) { $doctrine = self::$servicelocator->get('doctrine'); $couponModel = new couponModel($doctrine); $coupon = $couponModel->findOneBy(array('id' => $param->fromPost('coupon_id'))); if ($coupon->getReuse() == 0) { if ($save == 'payment') { $coupon->setIsdelete(1); $couponModel->edit($coupon); } } } //update order // delete order detail $orderItem->deleteAll(array('orderId' => $id)); $transactionModel->deleteAll(array('orderId' => $id)); // insert order detail foreach ($dataDetail as $k => $val) { if ($val['menuid'] != -1) { self::insertOrderDetail($val, $id); } } if ($save == 'payment') { $url = "http://" . $_SERVER['HTTP_HOST'] . '/frontend/order/detail/' . $id; header("Location:" . $url); exit; } else { $url = "http://" . $_SERVER['HTTP_HOST'] . '/frontend/order/add'; header("Location:" . $url); exit; } } $cat = $table->convertSingleToArray($cats); return array('title' => 'Edit Order', 'data' => $cat, 'url' => $url, 'orderDetails' => $orderDetail, 'orderId' => 0, 'dataObject' => $cats, 'tables' => $tableManage); } }