public function updateSalesAction() { $id = $this->getRequest()->getParam('id') ? $this->getRequest()->getParam('id') : '0'; if ($this->getRequest()->isPost()) { //just block only but can use other version $data = $this->getRequest()->getPost(); // if($data["status"]!=="Paid"){ // if(@$data['payment']!==''){ // $update_payment_order = new sales_Model_DbTable_DbSalesOrder(); // $update_payment_order->updateCustomerOrderPayment($data); // } // elseif(@$data['Update']=='Update'){ // $update_order = new sales_Model_DbTable_DbSalesOrder(); // //not yet dork stock in table inventory // $update_order->updateCustomerOrder($data); // } // } // else{ // Application_Form_FrmMessage::message("Cann't Edit!Sales Order Has Been Payment Already"); // Application_Form_FrmMessage::redirectUrl("/sales/sales-order/index"); // } //for new version $sale_order = new sales_Model_DbTable_DbCustomerOrder(); if (isset($data["payment"])) { if ($data["oldStatus"] == 6) { $addOrder = new sales_Model_DbTable_DbSalesOrder(); $addOrder->CustomerAddOrderPayment($data); Application_Form_FrmMessage::message("You has been Re-Order successe!"); Application_Form_FrmMessage::redirectUrl("/sales/sales-order/index"); } else { $sale_order->updateCustomerOrder($data); Application_Form_FrmMessage::message("You have been Update customer order success! "); Application_Form_FrmMessage::redirectUrl("/sales/sales-order/index"); } } elseif (isset($data["cancel_order"])) { //for cancel customer order if ($data["oldStatus"] != 6) { $sale_order->cancelCustomerOrder($data); Application_Form_FrmMessage::message("You have been cancel customer order success! "); Application_Form_FrmMessage::redirectUrl("/sales/sales-order/index"); } else { Application_Form_FrmMessage::message("Can not cancel again!Becuase You have been cancel customer order already!"); Application_Form_FrmMessage::redirectUrl("/sales/sales-order/index"); } // $sale_order->cancelCustomerOrder($data); // Application_Form_FrmMessage::message("You have been cancel customer order success! "); // Application_Form_FrmMessage::redirectUrl("/sales/sales-order/index"); } } $user = $this->GetuserInfoAction(); if ($user["level"] != 1 and $user["level"] != 2) { $gb = new Application_Model_DbTable_DbGlobal(); $exist = $gb->userSaleOrderExist($id, $user["location_id"]); if ($exist == "") { $this->_redirect("sales/sales-order/index"); } } $sql = "SELECT o.order_id,o.customer_id,o.LocationId,o.order,o.sales_ref,o.date_order,o.status,o.payment_method,o.currency_id,\n\t\t\to.remark,o.net_total,o.discount_type,o.discount_value,o.paid,o.all_total,o.balance,\n\t\t\tc.contact_name,c.phone,c.add_name,c.add_remark\n\t\t\tFROM tb_sales_order AS o\n\t\t\tINNER JOIN tb_customer AS c ON c.customer_id= o.customer_id\n\t\t\tINNER JOIN tb_sales_order_item AS so ON so.order_id=o.order_id\n\t\t\tWHERE o.order_id=" . $id; $db = new Application_Model_DbTable_DbGlobal(); $row = $db->getGlobalDbRow($sql); $formStock = new Application_Form_purchase(); $formStockEdit = $formStock->SalesOrder($row); Application_Model_Decorator::removeAllDecorator($formStockEdit); // omit default zend html tag $this->view->form = $formStockEdit; $this->view->status_so = $row['status']; if ($row['status'] == 1) { $this->_redirect("sales/sales-order/update-customer-quote/id/{$id}"); } //get item of this lost $orderModel = new sales_Model_DbTable_DbOrder(); $orderDetail = $orderModel->getSalesOderID($id); $this->view->rowsOrder = $orderDetail; // item option in select $items = new Application_Model_GlobalClass(); $itemRows = $items->getProductOption(); $this->view->itemsOption = $itemRows; $items = new Application_Model_GlobalClass(); $itemRows = $items->getProductOption(); $this->view->items = $itemRows; // $formControl = new Application_Form_FrmAction(null); // $formViewControl = $formControl->AllAction(null); // Application_Model_Decorator::removeAllDecorator($formViewControl); // $this->view->control = $formViewControl; //for add product; $formpopup = new Application_Form_FrmPopup(null); $formproduct = $formpopup->popuProduct(null); Application_Model_Decorator::removeAllDecorator($formproduct); $this->view->form_product = $formproduct; //for customer $formpopup = $formpopup->popupCustomer(null); Application_Model_Decorator::removeAllDecorator($formpopup); $this->view->form_customer = $formpopup; //for add location $formAdd = $formpopup->popuLocation(null); Application_Model_Decorator::removeAllDecorator($formAdd); $this->view->form_addstock = $formAdd; $form_agent = $formpopup->popupSaleAgent(null); Application_Model_Decorator::removeAllDecorator($form_agent); $this->view->form_agent = $form_agent; }