function splitAction() { if ($this->getRequest()->isPost()) { $post = $this->params()->fromPost(); $table = $post['table-new']; $discount = $post['discount']; $oldOrder = $post['oldOrder']; unset($post['table-new']); unset($post['discount']); unset($post['oldOrder']); if (!empty($post)) { $Auth_service = new AuthenticationService(); $auth = $Auth_service->getIdentity(); $status = 'pending'; $orderEntity = new Orders(); $orderEntity->setTotalCost(0); $orderEntity->setTableId($table); $orderEntity->setCreateDate(time()); $orderEntity->setCouponId($discount); $orderEntity->setToTalRealCost(0); $orderEntity->setUserId($auth->userId); $orderEntity->setSurtaxId(0); $orderEntity->setIsdelete(0); $orderEntity->setStatus($status); $orderLastInsert = $this->modelOrder->insert($orderEntity); $lastOrderId = $orderLastInsert->getId(); $totalPrice = 0; $oldPrice = 0; $newRealCost = 0; foreach ($post as $order) { $orderDetailId = $order['orderDetailId']; $oldQty = $order['oldQty']; $qty = $order['qty']; $totalRealCost = $order['menuCost'] * $order['oldQty']; $qty >= $oldQty ? $qty = $oldQty : ($qty = $qty); $orderDetailModel = $this->modelOrderDetail->findOneBy(array('id' => $orderDetailId)); // check quantity split every order $orderDetail = new OrderDetail(); if ($qty > 0) { if ($qty >= $oldQty) { // update orderId for order detail $orderDetailModel->setOrderId($lastOrderId); if ($order['newCoupon'] != -1) { $Cost = $orderDetailModel->getQuantity() * $orderDetailModel->getMenuCost(); $orderDetailModel->setDiscount($order['newCoupon']); $orderDetailModel->setRealCost(Utility::getPriceUseCoupon($Cost, $order['newCoupon'])); } $this->modelOrderDetail->edit($orderDetailModel); $newCost = $orderDetailModel->getRealCost(); } else { // insert new order detail $realCost = $qty * Utility::getMenuValue($order['menuId'], $order['costType']); $data['menuid'] = $order['menuId']; $data['quantity'] = $qty; $data['menuCost'] = $order['menuCost']; $data['realcost'] = Utility::getPriceUseCoupon($realCost, $order['newCoupon']); $data['orderDetailType'] = $order['costType']; $data['discount'] = $order['newCoupon']; $newCost = $data['realcost']; Utility::insertOrderDetail($data, $lastOrderId); // update old order-item detail $lastQuantity = $order['oldQty'] - $order['qty']; // if ($order['discountType'] != '' && $order['discountType'] == 0) { // $newRealCost = ($lastQuantity * $order['menuCost']) - $order['discountValue']; // } elseif ($order['discountType'] != '' && $order['discountType'] == 1) { // $newRealCost = Utility::roundCost(($lastQuantity * $order['menuCost']) - ((($lastQuantity * $order['menuCost']) * $order['discountValue']) / 100)); // } else { // $newRealCost = ($lastQuantity * $order['menuCost']); // } this code replace by static function Utility::getPriceUseCoupon(price,discountId); $newRealCost = Utility::getPriceUseCoupon($lastQuantity * $order['menuCost'], $order['discountId']); $orderDetailModel->setQuantity($lastQuantity); $orderDetailModel->setRealCost($newRealCost); $this->modelOrderDetail->edit($orderDetailModel); } } else { $newRealCost = $orderDetailModel->getRealCost(); } $oldPrice += $newRealCost; $totalPrice += $newCost; } $oldOrderModel = $this->modelOrder->findOneBy(array('id' => $oldOrder)); $oldOrderModel->setTotalRealCost($oldPrice); $oldOrderModel->setTotalCost($oldPrice); $this->modelOrder->edit($oldOrderModel); $newTotalPrice = $totalPrice; // $coupon = Utility::getCouponInfo($discount); // // if ($coupon->getType() == 0) { // // $realCostAfter = Utility::roundCost($newTotalPrice - $coupon->getValue()); // // } elseif ($coupon->getType() == 1) { // // $realCostAfter = Utility::roundCost($newTotalPrice - ($newTotalPrice * $coupon->getValue()) / 100); // // } else { // // $realCostAfter = $newTotalPrice; // // } this code replace by function Utility::getPriceUseCoupon(price,discountId); $realCostAfter = Utility::getPriceUseCoupon($newTotalPrice, $discount); //update last order $lastOrder = $this->modelOrder->findOneBy(array('id' => $lastOrderId)); $lastOrder->setToTalRealCost($realCostAfter); $lastOrder->setTotalCost($newTotalPrice); $this->modelOrder->edit($lastOrder); // update old order } } $this->flashMessenger()->addSuccessMessage('Split order success!'); return $this->redirect()->toRoute('frontend/child', array('controller' => 'order', 'action' => 'add')); }
function splitAction() { if ($this->getRequest()->isPost()) { $post = $this->params()->fromPost(); $table = $post['table-new']; $discount = -1; // $oldDiscount = $post['discount']; $oldOrder = $post['oldOrder']; unset($post['table-new']); unset($post['discount']); unset($post['oldOrder']); if (!empty($post)) { $Auth_service = new AuthenticationService(); $auth = $Auth_service->getIdentity(); $status = 'pending'; $orderEntity = new Orders(); $orderEntity->setTotalCost(0); $orderEntity->setTableId($table); $orderEntity->setCreateDate(time()); $orderEntity->setCouponId(-1); $orderEntity->setToTalRealCost(0); $orderEntity->setUserId($auth->userId); $orderEntity->setSurtaxId(0); $orderEntity->setIsdelete(0); $orderEntity->setStatus($status); $orderEntity->setNewDate(date('Y-m-d H:i:s', time())); $orderLastInsert = $this->modelOrder->insert($orderEntity); $lastOrderId = $orderLastInsert->getId(); $totalPrice = 0; $oldPrice = 0; $newRealCost = 0; // echo '<pre>'; // print_r($post);die; foreach ($post as $order) { $order['newCoupon'] = -1; $orderDetailId = $order['orderDetailId']; $oldQty = $order['oldQty']; $qty = $order['qty']; $totalRealCost = $order['menuCost'] * $order['oldQty']; $qty >= $oldQty ? $qty = $oldQty : ($qty = $qty); $orderDetailModel = $this->modelOrderDetail->findOneBy(array('id' => $orderDetailId)); // check quantity split every order $orderDetail = new OrderDetail(); if ($qty > 0) { if ($qty >= $oldQty) { // update orderId for order detail $orderDetailModel->setOrderId($lastOrderId); // if($order['newCoupon'] != -1){ $Cost = $orderDetailModel->getQuantity() * $orderDetailModel->getMenuCost(); // $orderDetailModel->setDiscount($order['newCoupon']); // $orderDetailModel->setRealCost(Utility::getPriceUseCoupon($Cost,$order['newCoupon'])); $orderDetailModel->setDiscount(-1); $orderDetailModel->setRealCost($Cost); // } $this->modelOrderDetail->edit($orderDetailModel); $newCost = $orderDetailModel->getRealCost(); } else { // insert new order detail $realCost = $qty * Utility::getMenuValue($order['menuId'], $order['costType']); $data['menuid'] = $order['menuId']; $data['quantity'] = $qty; $data['menuCost'] = $order['menuCost']; // $data['realcost'] = Utility::getPriceUseCoupon($realCost,$order['newCoupon']) ; $data['realcost'] = $realCost; $data['orderDetailType'] = $order['costType']; // $data['discount'] = $order['newCoupon']; $data['discount'] = -1; $newCost = $data['realcost']; Utility::insertOrderDetail($data, $lastOrderId); // update old order-item detail $lastQuantity = $order['oldQty'] - $order['qty']; $newRealCost = $lastQuantity * $order['menuCost']; $orderDetailModel->setQuantity($newRealCost); $orderDetailModel->setRealCost($newRealCost); $this->modelOrderDetail->edit($orderDetailModel); } } else { // $newRealCost = $orderDetailModel->getRealCost(); } } $oldOrderModel = $this->modelOrder->findOneBy(array('id' => $oldOrder)); $sumCost = $this->modelOrderDetail->createQuerySumOrderDetail($oldOrder); $returnCost = $sumCost[0]['realCost']; $oldTotalCost = $returnCost; // $oldPrice = Utility::getPriceUseCoupon($oldTotalCost,$oldOrderModel->getCouponId()); // $oldPrice = Utility::getPriceUseSurtax($oldPrice,$oldOrderModel->getSurtaxId()); $oldOrderModel->setTotalRealCost($oldTotalCost); $oldOrderModel->setTotalCost($oldTotalCost); $this->modelOrder->edit($oldOrderModel); $newTotalPrice = $totalPrice; $sumCostLast = $this->modelOrderDetail->createQuerySumOrderDetail($lastOrderId); $returnCostLast = $sumCostLast[0]['realCost']; // $realCostAfter = Utility::getPriceUseCoupon($returnCostLast,$discount) ; $realCostAfter = $returnCostLast; //update last order $lastOrder = $this->modelOrder->findOneBy(array('id' => $lastOrderId)); $lastOrder->setToTalRealCost($realCostAfter); $lastOrder->setTotalCost($realCostAfter); $this->modelOrder->edit($lastOrder); // update old order } } $this->flashMessenger()->addSuccessMessage('Split order success!'); return $this->redirect()->toRoute('frontend/child', array('controller' => 'order', 'action' => 'add')); }