public function updatePuirchaseOrderAction() { $data = $this->getRequest()->getPost(); $db = new Application_Model_DbTable_DbGlobal(); //if($post){ // $data_staust = array('status'=> 5 ); // $getorder = new purchase_Model_DbTable_DbPurchaseAdvance(); // $rows = $getorder->getStatusOrder($data['purchase_order']);//for update status in purchase order history // if($rows){ // foreach ($rows as $order){ // $db->updateRecord($data_staust, $order["history_id"],"history_id", "tb_order_history");//must update status too // } // //$result=$getorder->getPurchaseOrderExist($post); // } //get fully received $update_purchase = new purchase_Model_DbTable_DbPurchaseVendor(); $get_result = $update_purchase->updatePurchaseOrder($data); $suc = array("test" => 1); echo Zend_Json::encode($suc); exit; //} }
public function checkInAction() { try { $db = new Application_Model_DbTable_DbGlobal(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $recieve_order = new purchase_Model_DbTable_DbPurchaseVendor(); if (isset($data['SaveNew'])) { try { $recieve_order->RecievedPurchaseOrder($data); Application_Form_FrmMessage::message("Purchase has been received!"); } catch (Exception $e) { echo $e->getMessage(); } //Application_Form_FrmMessage::redirectUrl("/purchase/index/check-in"); //$this->_redirect("purchase/index/add-purchase"); } else { $recieve_order->RecievedPurchaseOrder($data); $this->_redirect("/purchase/index/index"); } //not yet use in this version // elseif(@$data['Save']=='Save'){ // $payment_purchase_order = new purchase_Model_DbTable_DbPurchaseVendor(); // $payment_purchase_order -> VendorOrder($data); // $this->_redirect("purchase/index/index"); // } // elseif(@$data['New']=='New'){ // $this->_redirect("purchase/index/add-purchase"); // } } $user = $this->GetuserInfoAction(); if ($user["level"] != 1 and $user["level"] != 2) { $this->_redirect("purchase/index/index"); } $frm_purchase = new Application_Form_FrmCheckIn(null); $form_add_purchase = $frm_purchase->productOrder(null); Application_Model_Decorator::removeAllDecorator($form_add_purchase); $this->view->form_purchase = $form_add_purchase; // item option in select $items = new Application_Model_GlobalClass(); $itemRows = $items->getProductOption(); $this->view->items = $itemRows; //get control $formControl = new Application_Form_FrmAction(null); $formViewControl = $formControl->AllAction(null); Application_Model_Decorator::removeAllDecorator($formViewControl); $this->view->control = $formViewControl; // //for search // $search = new purchase_Form_FrmSearch(); // $frmsearch= $search->formSearch(); // Application_Model_Decorator::removeAllDecorator($frmsearch); // $this->view->get_frmsearch= $frmsearch; //for view left purchase order $vendor_sql = "SELECT p.order, p.all_total,p.paid,p.balance\n\t\tFROM tb_purchase_order AS p INNER JOIN tb_vendor AS v ON v.vendor_id=p.vendor_id ORDER BY p.timestamp DESC "; $rows = $db->getGlobalDb($vendor_sql); $this->view->list = $rows; //for add product; $formpopup = new Application_Form_FrmPopup(null); $formproduct = $formpopup->popuProduct(null); Application_Model_Decorator::removeAllDecorator($formproduct); $this->view->form = $formproduct; //for add vendor $formStockAdd = $formpopup->popupVendor(null); Application_Model_Decorator::removeAllDecorator($formStockAdd); $this->view->form_vendor = $formStockAdd; //for add location $formAdd = $formpopup->popuLocation(null); Application_Model_Decorator::removeAllDecorator($formAdd); $this->view->form_addstock = $formAdd; } catch (Exception $e) { Application_Form_FrmMessage::messageError("INSERT_ERROR", $err = $e->getMessage()); } }
public function advanceTestAction() { $db = new Application_Model_DbTable_DbGlobal(); $id = $this->getRequest()->getParam('id') ? $this->getRequest()->getParam('id') : '0'; $r = new purchase_Model_DbTable_DbPurchaseVendor(); $r->updatePurcaheToInProgress($id); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); } ///link left not yet get from DbpurchaseOrder $session_vendor_info = new Zend_Session_Namespace('vendor_info'); $rows = $session_vendor_info->vendorinfo; // print_r($rows);exit(); // $purchase = new purchase_Model_DbTable_DbPurchaseOrder(); // $rows = $purchase->purchaseInfo($id); $formStock = new Application_Form_purchase(); $formpurchase_info = $formStock->productOrder($rows); Application_Model_Decorator::removeAllDecorator($formpurchase_info); // omit default zend html tag $this->view->form_purchase = $formpurchase_info; //get item of this order // $orderModel = new purchase_Model_DbTable_DbPurchaseOrder(); // $orderDetail = $orderModel->getPurchaseID($id); // $this->view->rowsOrder = $orderDetail; $session_record_order = new Zend_Session_Namespace('record_order'); //create in update purchase order in page indexcontroller action update $orderDetail = $session_record_order->orderDetail; $this->view->rowsOrder = $orderDetail; if ($rows['status'] == 4) { Application_Form_FrmMessage::message("You Can't Access Advance! Order Is Payment Already"); //$this->_redirect("/purchase/index/detail-purchase-order/id/".$id); } //for get item receive qty order $qty_receive = new purchase_Model_DbTable_DbPurchaseAdvance(); $row_receive = $qty_receive->getProductReceived($id); //print_r($row_receive); $this->view->rowsreceived = $row_receive; // 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; //get control $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 = $formproduct; //for add vendor $formStockAdd = $formpopup->popupVendor(null); Application_Model_Decorator::removeAllDecorator($formStockAdd); $this->view->form_vendor = $formStockAdd; //for add location $formAdd = $formpopup->popuLocation(null); Application_Model_Decorator::removeAllDecorator($formAdd); $this->view->form_addstock = $formAdd; // item option in select $items = new Application_Model_GlobalClass(); $itemRows = $items->getProductOption(); $this->view->itemsOption = $itemRows; }