public function preDispatch(Zend_Controller_Request_Abstract $request) { //clear session from search session //$this->clearSession(); $session_user = new Zend_Session_Namespace('auth'); $module = $request->getModuleName(); $controller = $request->getControllerName(); $action = $request->getActionName(); $url = $module . "/" . $controller . "/" . $action; $_url = ""; //have login if (isset($session_user->arr_acl)) { $arr_acl = $session_user->arr_acl; $valid_action = FALSE; foreach ($arr_acl as $acl) { if ($module == $acl["module"] && $controller == $acl["controller"]) { $valid_action = TRUE; break; } elseif ($module === "rsvAcl" && $controller === "user" && $action === "change-password") { //all user level can change password all $valid_action = TRUE; break; } elseif ($module === "rsvAcl" && $session_user->level === "1") { //user level 1 can access all action in module "rsvAcl" $valid_action = TRUE; break; } } //redirect to homepage if (!$valid_action) { //just open block below if ($url !== "default/index/index" && $url !== "default/error/error" && $url !== "default/index/changepassword" && $url !== "default/index/logout") { $_url = '/'; } $_have = false; foreach ($this->_exception_url as $i => $val) { if ($url === $val) { $_have = true; break; } } if (!$_have) { $_url = '/'; } } else { $_url = $this->rewriteUrl($url); } } else { //no login //redirect to login page if ($url !== "default/index/index") { $_url = "/"; } } if (!empty($_url)) { // echo"url here". $_url;exit(); $_url = "/home"; Application_Form_FrmMessage::redirectUrl($_url); } }
public function editAction() { if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $db = new Callecterall_Model_DbTable_DbCallecterall(); try { if (isset($data['btn_save'])) { $db->updatcallecterall($data); Application_Form_FrmMessage::message('ការបញ្ចូលជោគជ័យ'); } if (isset($data['btn_save_close'])) { $db->updatcallecterall($data); Application_Form_FrmMessage::message('ការបញ្ចូលជោគជ័យ'); Application_Form_FrmMessage::redirectUrl('/callecterall/Callecterall'); } } catch (Exception $e) { Application_Form_FrmMessage::message("INSERT_FAIL"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $id = $this->getRequest()->getParam('id'); $db = new Callecterall_Model_DbTable_DbCallecterall(); $row = $db->getcallecterallbyid($id); $fm = new Callecterall_Form_Frmcallecterall(); $frm = $fm->Frmcallecterall($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->Form_Frmcallecterall = $frm; }
function editAction() { $db_deposite = new Capital_Model_DbTable_DbCapital(); if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); try { if (isset($_data["save"])) { $db_deposite->updateCapital($_data); Application_Form_FrmMessage::Sucessfull("ការបញ្ចូលជោគជ័យ !", '/capital/capital/add'); } elseif (isset($_data["save_close"])) { $db_deposite->updateCapital($_data); Application_Form_FrmMessage::Sucessfull("ការបញ្ចូលជោគជ័យ !", '/capital/capital'); } else { Application_Form_FrmMessage::redirectUrl("/capital/capital"); } } catch (Exception $e) { Application_Form_FrmMessage::message("ការបញ្ចូលមិនជោគជ័យ"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $id = $this->getRequest()->getParam("id"); $row = $db_deposite->getpartnerById($id); $deposite = new Capital_Form_FrmCapitale(); $frm = $deposite->frmCapital($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm = $frm; }
public function editAction() { if($this->getRequest()->isPost()){ $data=$this->getRequest()->getPost(); $db = new Group_Model_DbTable_DbCallecteralltype(); try { $db->updatcallecterall($data); Application_Form_FrmMessage::message($this->tr->translate('EDIT_SUCCESS')); Application_Form_FrmMessage::redirectUrl('/other/callecteralltype'); } catch (Exception $e) { Application_Form_FrmMessage::message("INSERT_FAIL"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $id = $this->getRequest()->getParam('id'); $db = new Callecterall_Model_DbTable_DbCallecterall(); $row = $db->getcallecterallbyid($id); $fm = new Callecterall_Form_Frmcallecterall(); $frm = $fm->Frmcallecterall($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->Form_Frmcallecterall = $frm; }
public function addAction() { $db = new saleorder_Model_DbTable_DbSaleOrder(); $datas = $db->getAllProduct(); $saleorder = $db->getAllSaleOrder(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $db->addSaleOrder($data); Application_Form_FrmMessage::redirectUrl('/saleorder/index/add'); } $this->view->getdata = $datas; $this->view->saleorder = $saleorder; $form = new saleorder_Form_FrmSaleOrder(); $this->view->frm = $form->FrmSaleOrder(); $this->view->FrmSaleOrderUpdate = $form->FrmSaleOrderUpdate(); $itemRows = $db->getProductOption(); $this->view->itemsOption = $itemRows; }
public function preDispatch(Zend_Controller_Request_Abstract $request) { //clear session from search session $this->clearSession(); $session_user = new Zend_Session_Namespace('auth'); $module = $request->getModuleName(); $controller = $request->getControllerName(); $action = $request->getActionName(); $url = $module . "/" . $controller . "/" . $action; $_url = ""; //have login if (isset($session_user->arr_acl)) { $arr_acl = $session_user->arr_acl; $valid_action = FALSE; foreach ($arr_acl as $acl) { if ($module == $acl["module"] && $controller == $acl["controller"]) { $valid_action = TRUE; break; } elseif ($module === "rsvAcl" && $session_user->level === "1") { //user level 1 can access all action in module "rsvAcl" $valid_action = TRUE; break; } } //redirect to homepage if (!$valid_action) { if ($url !== "default/index/home" && $url !== "default/index/web-elements" && $url !== "default/error/error") { $_url = '/default/index/home'; } } else { $_url = $this->rewriteUrl($url); } } else { //no login //redirect to login page if ($url !== "default/index/index") { $_url = "/default/index/index"; } } if (!empty($_url)) { Application_Form_FrmMessage::redirectUrl($_url); } }
function editAction(){ if($this->getRequest()->isPost()){ $data=$this->getRequest()->getPost(); $db = new Group_Model_DbTable_DbClientBlackList(); try { $db->updatClientBlackList($data); Application_Form_FrmMessage::message($this->tr->translate('EDIT_SUCCESS')); Application_Form_FrmMessage::redirectUrl('/group/Clientblacklist'); } catch (Exception $e) { Application_Form_FrmMessage::message("EDIT_FAIL"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $db = new Group_Model_DbTable_DbClientBlackList(); $id = $this->getRequest()->getParam("id"); $row = $db->getBlackListById($id); $fm = new Group_Form_FrmClientBlackList(); $frm = $fm->FrmClientBlackList($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->Form_client_blacklist = $frm; }
public function editAction() { $id = $this->getRequest()->getParam('id'); $db = new Callecterall_Model_DbTable_DbCallecteralllist(); $row = $db->getcallecteralllistbyid($id); $is_fund = $db->checkisFun($id); if ($is_fund['is_fund'] == 0) { Application_Form_FrmMessage::Sucessfull('កាបពាំ្ចនេះបានសងរួចហើយ', '/callecterall/Callecteralllist'); } if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $db = new Callecterall_Model_DbTable_DbCallecteralllist(); //print_r($data);exit(); try { if (isset($data['save_close'])) { $db->updatcallecteralllist($data); //print_r($data);exit(); Application_Form_FrmMessage::message('ការបញ្ចូលជោគជ័យ'); Application_Form_FrmMessage::redirectUrl('/callecterall/Callecteralllist/'); } if (isset($data['save_new'])) { $db->updatcallecteralllist($data); Application_Form_FrmMessage::message('ការបញ្ចូលជោគជ័យ'); Application_Form_FrmMessage::redirectUrl('/callecterall/Callecteralllist/add'); } } catch (Exception $e) { Application_Form_FrmMessage::message("INSERT_FAIL"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $fm = new Callecterall_Form_Frmcallecteralllist(); $frm = $fm->callecteralllist($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->Form_Frmcallecterall = $frm; }
public function deleteoweAction() { if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); $_db = new Application_Model_DbTable_DbMoneyTransactions(); $_db->updateOwerbyTran($_data); Application_Form_FrmMessage::redirectUrl('/reports/index/rptowe'); exit; } }
public function updatePurchaseOrder($data) { try { $db = $this->getAdapter(); $db->beginTransaction(); $db_global = new Application_Model_DbTable_DbGlobal(); $session_user = new Zend_Session_Namespace('auth'); $userName = $session_user->user_name; $GetUserId = $session_user->user_id; //for update order by id\ $id_order_update = $data['id']; //print_r($id_order_update);exit(); //$recieved_id = $data["recieve_id"]; //update info of order in tb_purchase order // Select all qty in tb_product and tb_purchase_order_item for compare product exist or not for update qty to old qty $sql_itm = "SELECT\n\t\t\t\t\t\t(SELECT p.pro_id FROM tb_product AS p WHERE p.pro_id = po.`pro_id`) AS pro_id\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t,(SELECT p.qty_onorder FROM tb_product AS p WHERE p.pro_id = po.`pro_id`) AS qty_onorder\n\t\t\t\t\t\t\n\t\t\t\t\t\t,(SELECT p.qty_onhand \tFROM tb_product AS p WHERE p.pro_id = po.`pro_id`) AS qty_onhand\n\t\t\t\t\t\t\n\t\t\t\t\t\t,(SELECT p.qty_available \tFROM tb_product AS p WHERE p.pro_id = po.`pro_id`) AS qty_available\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t, SUM(po.`qty_order`) AS qty_order FROM\n\t\t\t\t\t\n\t\t\t\t\ttb_purchase_order_item AS po WHERE po.order_id = {$id_order_update} GROUP BY po.pro_id"; $rows_order = $db_global->getGlobalDb($sql_itm); if ($rows_order) { foreach ($rows_order as $row) { $row_get = $db_global->porductLocationExist($row["pro_id"], $data["old_location"]); $qty_onorder = $row["qty_onorder"] - $row["qty_order"]; $qty_available = $row["qty_available"] - $row["qty_order"]; $qty_onorder_prolo = $row_get["qty_onorder"] - $row["qty_order"]; $qty_available_prolo = $row_get["qty_avaliable"] - $row["qty_order"]; if ($qty_onorder <= 0 or $qty_onorder_prolo <= 0) { Application_Form_FrmMessage::message("The Main Stock or Location Stock is Not enough "); Application_Form_FrmMessage::redirectUrl("/purchase/advance/advance/id/" . $id_order_update); exit; } else { $update_product = array("qty_onorder" => $qty_onorder, "qty_available" => $qty_available); $this->_name = "tb_product"; $where = $this->getAdapter()->quoteInto("pro_id=?", $row["pro_id"]); $this->update($update_product, $where); unset($update_product); $update_prolocation = array("qty_onorder" => $qty_onorder_prolo, "qty_avaliable" => $qty_available_prolo); $this->_name = "tb_prolocation"; $where = $this->getAdapter()->quoteInto("ProLocationID=?", $row_get["ProLocationID"]); $this->update($update_prolocation, $where); } } } $info_purchase_order = array("vendor_id" => $data['v_name'], "LocationId" => $data["LocationId"], "order" => $data['txt_order'], "date_order" => $data['order_date'], "status" => $data["status"], "remark" => $data['remark'], "user_mod" => $GetUserId, "timestamp" => new Zend_Date(), "discount_value" => $data["dis_value"], "discount_real" => $data["global_disc"], "paid" => $data['paid'], "net_total" => $data["net_total"], "all_total" => $data['all_total'], "payment_method" => $data["payment_name"], "currency_id" => $data["currency"], "balance" => $data['balance']); $this->_name = "tb_purchase_order"; $where = $this->getAdapter()->quoteInto("order_id=?", $id_order_update); $this->update($info_purchase_order, $where); //$db_global->updateRecord($info_purchase_order,$id_order_update,"order_id","tb_purchase_order"); $sql = "DELETE FROM tb_purchase_order_item WHERE order_id IN ({$id_order_update})"; $db_global->deleteRecords($sql); unset($sql); $sql_history = "DELETE FROM tb_purchase_order_history WHERE `order` IN ({$id_order_update})"; $db_global->deleteRecords($sql_history); unset($sql_history); /// update $ids = explode(',', $data['identities']); // print_r($ids); foreach ($ids as $i) { if (@$data["pricefree_" . $i]) { $is_free = 1; } else { $is_free = 0; } // Insert New purchase order item in old order_id $data_item[$i] = array('order_id' => $id_order_update, 'pro_id' => $data['item_id_' . $i], 'qty_order' => $data['qty' . $i], 'price' => $data['price' . $i], 'sub_total' => $data['total' . $i], 'total_befor' => $data['total' . $i], 'remark' => $data['remark' . $i], 'disc_value' => $data['dis-value' . $i], 'is_free' => $is_free); //print_r($data_item); echo "<br />";echo "<br />"; $db->insert("tb_purchase_order_item", $data_item[$i]); unset($data_item[$i]); $data_history[$i] = array('order' => $id_order_update, 'pro_id' => $data['item_id_' . $i], 'type' => 1, 'customer_id' => $data['v_name'], 'status' => $data["status"], 'order_total' => $data['total' . $i], 'qty' => $data['qty' . $i], 'unit_price' => $data['price' . $i], 'sub_total' => $data['total' . $i], 'last_update_date' => new Zend_Date()); //print_r($data_history);exit(); $db->insert("tb_purchase_order_history", $data_history[$i]); unset($data_history[$i]); $locationid = $data['LocationId']; $itemId = $data['item_id_' . $i]; $qtyrecord = $data['qty' . $i]; //qty on 1 record // Update stock in tb_product $rows = $db_global->productLocationInventory($itemId, $locationid); //to check product location if ($rows) { $update_prolo = array("qty_onorder" => $rows["qty_onorder"] + $qtyrecord, "qty_avaliable" => $rows["qty_avaliable"] + $qtyrecord, "last_mod_date" => new Zend_Date()); $this->_name = "tb_prolocation"; $where = $this->getAdapter()->quoteInto("ProLocationID=?", $rows["ProLocationID"]); $this->update($update_prolo, $where); unset($update_prolo); $update_product = array("qty_onorder" => $rows["qty_onorder"] + $qtyrecord, "qty_available" => $rows["qty_available"] + $qtyrecord, "last_mod_date" => new Zend_Date()); $this->_name = "tb_product"; $where = $this->getAdapter()->quoteInto("pro_id=?", $itemId); $this->update($update_product, $where); } else { $update_prolo = array("qty_onorder" => $rows["qty_onorder"] + $qtyrecord, "qty_avaliable" => $rows["qty_avaliable"] + $qtyrecord, "last_mod_date" => new Zend_Date()); $this->_name = "tb_prolocation"; $this->insert($update_prolo); unset($update_prolo); $update_product = array("qty_onorder" => $rows["qty_onorder"] + $qtyrecord, "qty_available" => $rows["qty_available"] + $qtyrecord, "last_mod_date" => new Zend_Date()); $this->_name = "tb_product"; $this->insert($update_product); } } $db->commit(); } catch (Exception $e) { $db->rollBack(); $e->getMessage(); } }
public function CustomerAddOrderPayment($data) { try { $db = $this->getAdapter(); $db->beginTransaction(); $db_global = new Application_Model_DbTable_DbGlobal(); $session_user = new Zend_Session_Namespace('auth'); $userName = $session_user->user_name; $GetUserId = $session_user->user_id; $ids = explode(',', $data['identity']); //print_r($ids);exit(); //command below not yet use // $idrecord=$data['customer_id']; // $datainfo=array( // "contact_name"=>$data['contact'], // "phone" =>$data['txt_phone'], // ); // //updage customer info // $itemid=$db_global->updateRecord($datainfo, $idrecord, "customer_id","tb_customer"); // unset($datainfo); if ($data['order'] == "") { $date = new Zend_Date(); $order_add = "SO" . $date->get('hh-mm-ss'); } else { $order_add = $data['order']; } $db->getProfiler()->setEnabled(true); $info_order = array("customer_id" => $data['customer_id'], "LocationId" => $data['LocationId'], "order" => $order_add, "sales_ref" => $data['sales_ref'], "date_order" => $data['order_date'], "status" => $data['status'], "remark" => $data['remark'], "user_mod" => $GetUserId, "timestamp" => new Zend_Date(), "net_total" => $data['net_total'], "discount_value" => $data['dis_value'], "discount_real" => $data["global_disc"], "paid" => $data['paid'], "all_total" => $data['all_total'], "balance" => $data['remain']); //and info of order $id_order = $db_global->addRecord($info_order, "tb_sales_order"); unset($info_order); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); $ids = explode(',', $data['identity']); foreach ($ids as $i) { if (@$data["pricefree_" . $i]) { $check = 1; } else { $check = 0; } $db->getProfiler()->setEnabled(true); //add history order $data_history = array('pro_id' => $data['item_id_' . $i], 'type' => 2, 'order' => $id_order, 'customer_id' => $data['customer_id'], 'date' => $data['order_date'], "status" => $data['status'], 'order_total' => $data['remain'], 'qty' => $data['qty' . $i], 'unit_price' => $data['price' . $i], 'sub_total' => $data['total' . $i]); $db->insert("tb_order_history", $data_history); unset($data_history); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); $db->getProfiler()->setEnabled(true); $history = array('pro_id' => $data['item_id_' . $i], 'type' => 2, 'order' => $id_order, 'customer_id' => $data['customer_id'], 'date' => $data['order_date'], "status" => $data['status'], 'order_total' => $data['remain'], 'qty' => $data['qty' . $i], 'unit_price' => $data['price' . $i], 'sub_total' => $data['total' . $i], "dis_value" => $data['dis-value' . $i], "dis_amount" => $data["real-value" . $i], 'is_free' => $check); $db->insert("tb_sale_order_history", $history); unset($history); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); $db->getProfiler()->setEnabled(true); $sale_history = array('pro_id' => $data['item_id_' . $i], 'type' => 2, 'order' => $id_order, 'customer_id' => $data['customer_id'], 'date' => $data['order_date'], "status" => $data['status'], 'order_total' => $data['remain'], 'qty' => $data['qty' . $i], 'unit_price' => $data['price' . $i], 'sub_total' => $data['total' . $i]); $db->insert("tb_purchase_order_history", $sale_history); unset($sale_history); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); $db->getProfiler()->setEnabled(true); //$check = @$data["pricefree_".$i]; //print_r($check); $data_item[$i] = array('order_id' => $id_order, 'pro_id' => $data['item_id_' . $i], 'qty_order' => $data['qty' . $i], 'price' => $data['price' . $i], 'total_befor' => $data['total' . $i], 'is_free' => $check, 'sub_total' => $data['total' . $i], "disc_value" => $data['dis-value' . $i], "disc_amount" => $data["real-value" . $i]); $db->insert("tb_sales_order_item", $data_item[$i]); unset($data_item[$i]); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); //check stock product location $locationid = $data['LocationId']; $itemId = $data['item_id_' . $i]; $qtyrecord = $data['qty' . $i]; //qty on 1 record $db->getProfiler()->setEnabled(true); $rows = $db_global->productLocationInventory($itemId, $locationid); //to check product location Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); //exit(); $qtyold = $rows['qty']; $qty_avaliable = $rows["qty_avaliable"] - $qtyrecord; $qty_available = $rows["qty_available"] - $qtyrecord; $getrecord_id = $rows["ProLocationID"]; if ($rows) { if ($qty_available <= 0) { Application_Form_FrmMessage::message("The Qty onhanh is out of stock!!"); Application_Form_FrmMessage::redirectUrl("/sales/sales-order"); $db->rollBack(); break; } elseif ($qty_avaliable <= 0) { Application_Form_FrmMessage::message("The in your location is out of stock!!"); Application_Form_FrmMessage::redirectUrl("/sales/sales-order"); $db->rollBack(); break; } else { if ($data["status"] == 5) { $db->getProfiler()->setEnabled(true); $itemOnHand = array('qty_onhand' => $rows["qty_onhand"] - $qtyrecord, 'qty_available' => $rows["qty_available"] - $qtyrecord); $db_global->updateRecord($itemOnHand, $itemId, "pro_id", "tb_product"); unset($itemOnHand); $updatedata = array('qty' => $rows['qty'] - $qtyrecord, 'qty_avaliable' => $rows["qty_avaliable"] - $qtyrecord); //update stock product location $db_global->updateRecord($updatedata, $getrecord_id, "ProLocationID", "tb_prolocation"); unset($updatedata); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); } else { $db->getProfiler()->setEnabled(true); $itemOnHand = array('qty_onsold' => $rows["pqty_onsold"] + $qtyrecord, 'qty_available' => $rows["qty_available"] - $qtyrecord); //update total stock $db_global->updateRecord($itemOnHand, $itemId, "pro_id", "tb_product"); unset($itemOnHand); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); $db->getProfiler()->setEnabled(true); $updatedata = array('qty_onsold' => $rows['qty_onsold'] + $qtyrecord, 'qty_avaliable' => $rows["qty_avaliable"] - $qtyrecord); //update stock product location $db_global->updateRecord($updatedata, $getrecord_id, "ProLocationID", "tb_prolocation"); unset($updatedata); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery()); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams()); $db->getProfiler()->setEnabled(false); } //exit(); } //update stock record } else { //insert stock ; $rows_pro_exit = $db_global->productLocation($itemId, $locationid); if ($rows_pro_exit) { $updatedata = array('qty_onsold' => $rows_pro_exit['qty_onsold'] + $qtyrecord, 'qty_avaliable' => $rows["qty_available"] - $qtyrecord); //update stock product location $itemid = $db_global->updateRecord($updatedata, $rows_pro_exit['ProLocationID'], "ProLocationID", "tb_prolocation"); unset($updatedata); } else { $insertdata = array('pro_id' => $itemId, 'LocationId' => $locationid, 'last_usermod' => $GetUserId, 'qty_onsold' => $qtyrecord, 'qty_avaliable' => -$qtyrecord, 'qty' => -$qtyrecord, 'last_mod_date' => new Zend_Date()); //update stock product location $db->insert("tb_prolocation", $insertdata); unset($insertdata); } $rowitem = $db_global->InventoryExist($itemId); //to check product location if ($rowitem) { $itemOnHand = array('qty_onsold' => $rowitem["qty_onsold"] + $qtyrecord, 'qty_available' => $rows["qty_available"] - $qtyrecord); //update total stock $itemid = $db_global->updateRecord($itemOnHand, $itemId, "pro_id", "tb_product"); unset($itemOnHand); } else { $dataInventory = array('pro_id' => $itemId, 'qty_onsold' => $data['qty' . $i], 'Timestamp' => new Zend_date()); $db->insert("tb_product", $dataInventory); unset($dataInventory); //update stock product location } } } $db->commit(); } catch (Exception $e) { $db->rollBack(); $e->getMessage(); } }
public function updateVendorStock($data) { try { $db = $this->getAdapter(); $db->beginTransaction(); $db_global = new Application_Model_DbTable_DbGlobal(); $session_user = new Zend_Session_Namespace('auth'); $userName = $session_user->user_name; $GetUserId = $session_user->user_id; //for update order by id\ $id_order_update = $data['id']; $recieved_id = $data["recieve_id"]; //update info of order in tb_purchase order // Select all qty in tb_product and tb_purchase_order_item for compare product exist or not for update qty to old qty $sql_itm = "SELECT\n\t\t\t\t\t\t\t(SELECT p.pro_id FROM tb_product AS p WHERE p.pro_id = po.`pro_id`) AS pro_id\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t,(SELECT p.qty_onorder FROM tb_product AS p WHERE p.pro_id = po.`pro_id`) AS qty_onorder\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t,(SELECT p.qty_onhand \tFROM tb_product AS p WHERE p.pro_id = po.`pro_id`) AS qty_onhand\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t,(SELECT p.qty_available \tFROM tb_product AS p WHERE p.pro_id = po.`pro_id`) AS qty_available\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t, SUM(po.`qty_order`) AS qty_order FROM\n\t\t\t\t\t\t\n\t\t\t\t\ttb_purchase_order_item AS po WHERE po.order_id = {$id_order_update} GROUP BY po.pro_id"; $rows_order = $db_global->getGlobalDb($sql_itm); //print_r($rows_order);exit(); // if product in purchase order item if ($rows_order) { foreach ($rows_order as $row_order) { //print_r($row_order);exit(); //update qty and qty_onorder to old qty in tb_prolocation $row_get = $db_global->porductLocationExist($row_order["pro_id"], $data["old_location"]); // Check product Location exit //print_r($row_get);exit(); $qty_prolo = $row_get["qty"] - $row_order["qty_order"]; $qty_order_prolo = $row_get["qty_onorder"] - $row_order["qty_order"]; $qty = $row_order["qty_onhand"] - $row_order["qty_order"]; $qty_order = $row_order["qty_onorder"] - $row_order["qty_order"]; if ($row_get) { if ($data["oldStatus"] == 5 or $data["oldStatus"] == 4) { if ($qty_prolo < 0) { Application_Form_FrmMessage::message("You can't update!! because qty stock in Location is less than Quality order"); Application_Form_FrmMessage::redirectUrl("/purchase/index/index"); } else { $qty_on_location = array("qty" => $row_get["qty"] - $row_order["qty_order"], "last_usermod" => $GetUserId, "last_mod_date" => new Zend_Date()); } $db_global->updateRecord($qty_on_location, $row_get["ProLocationID"], "ProLocationID", "tb_prolocation"); } else { if ($qty_order_prolo < 0) { Application_Form_FrmMessage::message("You can't update!! because qty order in Location is less than Quality order"); Application_Form_FrmMessage::redirectUrl("/purchase/index/index"); } else { $qty_on_location = array("qty_onorder" => $row_get["qty_onorder"] - $row_order["qty_order"], "last_usermod" => $GetUserId, "last_mod_date" => new Zend_Date()); } $db_global->updateRecord($qty_on_location, $row_get["ProLocationID"], "ProLocationID", "tb_prolocation"); } } if ($data["oldStatus"] == 5 or $data["oldStatus"] == 4) { if ($qty < 0) { Application_Form_FrmMessage::message("You can't update!! because qty in stock is less than Quality order"); Application_Form_FrmMessage::redirectUrl("/purchase/index/index"); } else { $qty_on_order = array("qty_onhand" => $row_order["qty_onhand"] - $row_order["qty_order"], "qty_available" => $row_order["qty_available"] - $row_order["qty_order"], "last_mod_date" => new Zend_Date()); $db_global->updateRecord($qty_on_order, $row_order["pro_id"], "pro_id", "tb_product"); } } else { if ($qty_order < 0) { Application_Form_FrmMessage::message("You can't update!! because QTY onorder in stock is less than Quality order"); Application_Form_FrmMessage::redirectUrl("/purchase/index/index"); } else { $qty_on_order = array("qty_onorder" => $row_order["qty_onorder"] - $row_order["qty_order"], "last_mod_date" => new Zend_Date()); } $db_global->updateRecord($qty_on_order, $row_order["pro_id"], "pro_id", "tb_product"); } //update total stock } } unset($rows_order); $info_purchase_order = array("vendor_id" => $data['v_name'], "LocationId" => $data["LocationId"], "order" => $data['txt_order'], "date_order" => $data['order_date'], "status" => $data["status"], "remark" => $data['remark'], "user_mod" => $GetUserId, "timestamp" => new Zend_Date(), "paid" => $data['paid'], "all_total" => $data['totalAmoun'], "balance" => $data['remain']); $db_global->updateRecord($info_purchase_order, $id_order_update, "order_id", "tb_purchase_order"); // end update info of order in tb_purchase order $ids = explode(',', $data['identity']); $sql_recieve = new purchase_Model_DbTable_DbPurchaseOrder(); $result = $sql_recieve->recieved_info($id_order_update); $prifix = "SELECT * FROM tb_setting WHERE `code` =16"; $ro = $db_global->getGlobalDbRow($prifix); $RO = $ro["key_value"]; $date = new Zend_Date(); $recieve_no = $RO . $date->get('hh-mm-ss'); if ($result) { if ($data["oldStatus"] == 5 or $data["oldStatus"] == 4) { if ($data["status"] == 5 or $data["status"] == 4) { $data_recieved_order = array("recieve_type" => 1, "order_id" => $id_order_update, "order_no" => $data["txt_order"], "vendor_id" => $data['v_name'], "location_id" => $data["LocationId"], "date_recieve" => new Zend_Date(), "status" => $data['status'], "is_active" => 1, "paid" => $data['paid'], "all_total" => $data['totalAmoun'], "balance" => $data['remain'], "user_recieve" => $GetUserId); $recieved_order = $db_global->updateRecord($data_recieved_order, $recieved_id, "recieve_id", "tb_recieve_order"); unset($data_recieved_order); } else { $data_recieved_order = array("recieve_type" => 1, "order_id" => $id_order_update, "order_no" => $data["txt_order"], "vendor_id" => $data['v_name'], "location_id" => $data["LocationId"], "date_recieve" => new Zend_Date(), "status" => $data['status'], "is_active" => 0, "paid" => $data['paid'], "all_total" => $data['totalAmoun'], "balance" => $data['remain'], "user_recieve" => $GetUserId); $recieved_order = $db_global->updateRecord($data_recieved_order, $recieved_id, "recieve_id", "tb_recieve_order"); unset($data_recieved_order); } } $sqls = "DELETE FROM tb_recieve_order_item WHERE recieve_id IN ({$recieved_id})"; $db_global->deleteRecords($sqls); unset($sqls); foreach ($ids as $i) { $recieved_item[$i] = array("recieve_id" => $recieved_id, "pro_id" => $data['item_id_' . $i], "order_id" => $id_order_update, "qty_order" => $data['qty' . $i], "qty_recieve" => $data['qty' . $i], "price" => $data['price' . $i], "total_before" => $data['total' . $i], "sub_total" => $data['total' . $i]); $db->insert("tb_recieve_order_item", $recieved_item[$i]); unset($recieved_item[$i]); } } else { $prifix = "SELECT * FROM tb_setting WHERE `code` =16"; $ro = $db_global->getGlobalDbRow($prifix); $RO = $ro["key_value"]; $date = new Zend_Date(); $recieve_no = $RO . $date->get('hh-mm-ss'); if ($data["status"] == 5 or $data["status"] == 4) { $data_recieved_order = array("recieve_type" => 1, "order_id" => $id_order_update, "recieve_no" => $recieve_no, "order_no" => $data["txt_order"], "vendor_id" => $data['v_name'], "location_id" => $data["LocationId"], "order_date" => new Zend_Date(), "date_recieve" => new Zend_Date(), "status" => $data['status'], "is_active" => 1, "paid" => $data['paid'], "all_total" => $data['totalAmoun'], "balance" => $data['remain'], "user_recieve" => $GetUserId); $recieved_order = $db_global->addRecord($data_recieved_order, "tb_recieve_order"); unset($data_recieved_order); foreach ($ids as $i) { $recieved_item[$i] = array("recieve_id" => $recieved_order, "pro_id" => $data['item_id_' . $i], "order_id" => $id_order_update, "qty_order" => $data['qty' . $i], "qty_recieve" => $data['qty' . $i], "price" => $data['price' . $i], "total_before" => $data['total' . $i], "sub_total" => $data['total' . $i]); $db->insert("tb_recieve_order_item", $recieved_item[$i]); unset($recieved_item[$i]); } } } // Delete old purchase order item before insert new purchase order item in old order_id $sql = "DELETE FROM tb_purchase_order_item WHERE order_id IN ({$id_order_update})"; $db_global->deleteRecords($sql); unset($sql); $sql_history = "DELETE FROM tb_purchase_order_history WHERE `order` IN ({$id_order_update})"; $db_global->deleteRecords($sql_history); unset($sql_history); /// update $ids = explode(',', $data['identity']); //add order in tb_inventory must update code again 9/8/13 foreach ($ids as $i) { // Insert New purchase order item in old order_id $data_item[$i] = array('order_id' => $id_order_update, 'pro_id' => $data['item_id_' . $i], 'qty_order' => $data['qty' . $i], 'price' => $data['price' . $i], 'sub_total' => $data['total' . $i], 'total_befor' => $data['total' . $i], 'remark' => $data['remark_' . $i]); //print_r($data_item); echo "<br />";echo "<br />"; $db->insert("tb_purchase_order_item", $data_item[$i]); unset($data_item[$i]); $data_history[$i] = array('order' => $id_order_update, 'pro_id' => $data['item_id_' . $i], 'type' => 1, 'customer_id' => $data['v_name'], 'status' => $data["status"], 'order_total' => $data['total' . $i], 'qty' => $data['qty' . $i], 'unit_price' => $data['price' . $i], 'sub_total' => $data['total' . $i], 'date' => $data["old_history_date"], 'last_update_date' => new Zend_Date()); //print_r($data_history);exit(); $db->insert("tb_purchase_order_history", $data_history[$i]); unset($data_history[$i]); $locationid = $data['LocationId']; $itemId = $data['item_id_' . $i]; $qtyrecord = $data['qty' . $i]; //qty on 1 record // Update stock in tb_product $rows = $db_global->productLocationInventory($itemId, $locationid); //to check product location if ($rows) { $getrecord_id = $rows["ProLocationID"]; if ($data["status"] == 5 or $data["status"] == 4) { $itemOnHand = array('qty_onhand' => $rows["qty_onhand"] + $qtyrecord, 'qty_available' => $rows["qty_available"] + $qtyrecord, 'last_mod_date' => new Zend_date()); $db_global->updateRecord($itemOnHand, $itemId, "pro_id", "tb_product"); unset($itemOnHand); } else { $itemOnHand = array('qty_onorder' => $rows["pqty_onorder"] + $qtyrecord, 'last_mod_date' => new Zend_date()); $db_global->updateRecord($itemOnHand, $itemId, "pro_id", "tb_product"); unset($itemOnHand); } //End update total stock // Update product Location if ($data["status"] == 5 or $data["status"] == 4) { $updatedata = array('qty' => $rows['qty'] + $qtyrecord, 'last_mod_date' => new Zend_date()); $db_global->updateRecord($updatedata, $getrecord_id, "ProLocationID", "tb_prolocation"); unset($updatedata); } else { $updatedata = array('qty_onorder' => $rows['qty_onorder'] + $qtyrecord, 'last_mod_date' => new Zend_date()); $db_global->updateRecord($updatedata, $getrecord_id, "ProLocationID", "tb_prolocation"); unset($updatedata); } //End update stock product location //update stock record } else { //insert stock ; $rows_pro_exit = $db_global->productLocation($itemId, $locationid); // check product location exist $db->getProfiler()->setEnabled(true); // if product exist Update qty in tb_prolocation if ($rows_pro_exit) { if ($data["status"] == 5 or $data["status"] == 4) { $updatedata = array('qty' => $rows['qty'] + $qtyrecord, 'last_mod_date' => new Zend_date()); $itemid = $db_global->updateRecord($updatedata, $rows_pro_exit['ProLocationID'], "ProLocationID", "tb_prolocation"); unset($updatedata); } else { $updatedata = array('qty_onorder' => $rows['qty_onorder'] + $qtyrecord, 'last_mod_date' => new Zend_date()); $itemid = $db_global->updateRecord($updatedata, $rows_pro_exit['ProLocationID'], "ProLocationID", "tb_prolocation"); unset($updatedata); } // $itemid=$db_global->updateRecord($updatedata,$rows_pro_exit['ProLocationID'], "ProLocationID", "tb_prolocation"); // unset($updatedata); // End if product exist Update qty in tb_prolocation } else { // If product not exist insert New product in tb_prolocation $insertdata = array('pro_id' => $itemId, 'LocationId' => $locationid, 'last_usermod' => $GetUserId, 'qty' => $qtyrecord, 'last_mod_date' => new Zend_Date()); //update stock product location $db->insert("tb_prolocation", $insertdata); unset($insertdata); } // End If product not exist insert New product in tb_prolocation $rowitem = $db_global->InventoryExist($itemId); //to check product exist // If productt exist update product in tb_product if ($rowitem) { if ($data["status"] == 5 or $data["status"] == 4) { $itemOnHand = array('qty_onhand' => $rows["qty_onhand"] + $qtyrecord, 'qty_available' => $rows["qty_available"] + $qtyrecord, 'last_mod_date' => new Zend_date()); $itemid = $db_global->updateRecord($itemOnHand, $itemId, "pro_id", "tb_product"); unset($itemOnHand); } else { $itemOnHand = array('qty_onorder' => $rows["qty_onrder"] + $qtyrecord, 'last_mod_date' => new Zend_date()); $itemid = $db_global->updateRecord($itemOnHand, $itemId, "pro_id", "tb_product"); unset($itemOnHand); } //update total stock // $itemid=$db_global->updateRecord($itemOnHand,$itemId,"pro_id","tb_product"); // unset($itemOnHand); // If productt exist update product in tb_product } else { // If product not exist insert new product in tb_product $dataInventory = array('pro_id' => $itemId, 'qty_onhand' => $qtyrecord, 'qty_available' => $qtyrecord, 'last_mod_date' => new Zend_date()); $db->insert("tb_product", $dataInventory); unset($dataInventory); //update stock product location } } } $db->commit(); } catch (Exception $e) { $db->rollBack(); $e->getMessage(); //echo $theCauseOfErrorOnlyDoNotRedirectToError; //exit(); } }
public function editAction() { $id = $this->getRequest()->getParam("id"); $db = new phurchase_Model_DbTable_DbVendor(); $data = $db->getCateById($id); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); //print_r($data);exit(); if (isset($data['save'])) { $db->updatCat($data, $id); Application_Form_FrmMessage::message("ការកែប្រែបានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/phurchase/vendor/edit/id/' . $id); } elseif (isset($data['save_add'])) { $db->updatCat($data, $id); Application_Form_FrmMessage::message("ការកែប្រែបានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/phurchase/vendor/add'); } elseif (isset($data['save_close'])) { $db->updatCat($data, $id); Application_Form_FrmMessage::message("ការកែប្រែបានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/phurchase/vendor'); } } $form = new phurchase_Form_FrmVendor(); $this->view->frmcate = $form->FrmProCate($data); }
public function addRecieveAction() { $db = new Application_Model_DbTable_DbGlobal(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $payment_purchase_order = new purchase_Model_DbTable_DbPurchaseVendor(); $payment_purchase_order->vendorPurchaseOrderPayment($data); Application_Form_FrmMessage::message("Purchase has been received!"); if ($data['payment'] == 'Save New') { Application_Form_FrmMessage::redirectUrl("/purchase/index/add-purchase"); //$this->_redirect("purchase/index/add-purchase"); } else { $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"); } ///link left not yet get from DbpurchaseOrder $frm_purchase = new Application_Form_purchase(null); $form_add_purchase = $frm_purchase->productOrder(null); Application_Model_Decorator::removeAllDecorator($form_add_purchase); $this->view->form_purchase = $form_add_purchase; $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; }
public function editAction() { $id = $this->getRequest()->getParam('id') ? $this->getRequest()->getParam('id') : '0'; $db = new phurchase_Model_DbTable_DbOrder(); $itemRows = $db->selectProductOption(); $this->view->items = $itemRows; $orderDetail = $db->getSalesOderID($id); $this->view->rowsOrder = $orderDetail; $itemRowsGet = $db->getProductOption(); $this->view->itemsOption = $itemRowsGet; $data = $db->getPhurchase($id); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); //print_r($data);exit(); if (isset($data['save'])) { $db->updatCat($data, $id); Application_Form_FrmMessage::message("ការកែប្រែបានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/product/index/edit/id/' . $id); } elseif (isset($data['save_add'])) { $db->updatCat($data, $id); Application_Form_FrmMessage::message("ការកែប្រែបានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/product/index/add'); } elseif (isset($data['save_close'])) { $db->updatCat($data, $id); Application_Form_FrmMessage::message("ការកែប្រែបានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/product'); } } $form = new phurchase_Form_FrmPhurchaseOrder(); $this->view->frmcate = $form->FrmProCate($data); }
public function editAction(){ $db = new Group_Model_DbTable_DbClient(); if($this->getRequest()->isPost()){ try{ $data = $this->getRequest()->getPost(); //print_r($data);exit(); $id= $db->addClient($data); if($data['chackcall']==1){ Application_Form_FrmMessage::message("វានឹងបន្ថែមទ្រព្យបញ្ចាំរបស់អតិថិជនដោយស្វ័យប្រវត្តិ!"); Application_Form_FrmMessage::redirectUrl("/group/callteral/add/id/".$id); } Application_Form_FrmMessage::Sucessfull('EDIT_SUCCESS',"/group/index"); }catch (Exception $e){ Application_Form_FrmMessage::message("EDIT_FAILE"); echo $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } } $id = $this->getRequest()->getParam("id"); $row = $db->getClientById($id); $this->view->row=$row; $this->view->photo = $row['photo_name']; if(empty($row)){ $this->_redirect("/group/client"); } $fm = new Group_Form_FrmClient(); $frm = $fm->FrmAddClient($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_client = $frm; $dbpop = new Application_Form_FrmPopupGlobal(); $this->view->frm_popup_village = $dbpop->frmPopupVillage(); $this->view->frm_popup_comm = $dbpop->frmPopupCommune(); $this->view->frm_popup_district = $dbpop->frmPopupDistrict(); $this->view->frm_popup_clienttype = $dbpop->frmPopupclienttype(); $db = new Application_Model_DbTable_DbGlobal(); $client_type = $db->getclientdtype(); array_unshift($client_type,array( 'id' => -1, 'name' => '---Add New ---', ) ); $this->view->clienttype = $client_type; }
public function logoutAction() { // action body if ($this->getRequest()->getParam('value') == 1) { $db_access = new Application_Model_DbTable_DbAmountPC(); $pc_name = strtolower(gethostname()); $db_access->clearUserLogined($pc_name); $aut = Zend_Auth::getInstance(); $aut->clearIdentity(); $session_user = new Zend_Session_Namespace('auth'); $log = new Application_Model_DbTable_DbUserLog(); $log->insertLogout($session_user->user_id); $session_user->unsetAll(); Application_Form_FrmMessage::redirectUrl("/"); exit; } }
public function indexAction() { try { $db = new Application_Model_DbTable_DbGlobal(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); //print_r($invoice);exit(); $recieve_order = new purchase_Model_DbTable_DbCheckInProduct(); if (isset($data['SaveNew'])) { try { $recieve_order->RecievedPurchaseOrder($data); Application_Form_FrmMessage::message("Purchase has been received!"); Application_Form_FrmMessage::redirectUrl("/purchase/index/check-in"); } catch (Exception $e) { $e->getMessage(); } } else { $recieve_order->RecievedPurchaseOrder($data); $this->_redirect("/purchase/index/index"); } } $user = $this->GetuserInfoAction(); if ($user["level"] != 1 and $user["level"] != 2) { $this->_redirect("purchase/index/index"); } $db = new Application_Model_DbTable_DbGlobal(); $frm_purchase = new Application_Form_FrmCheckIn(); $form_add_purchase = $frm_purchase->productOrder(); 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\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 paymentAction() { $db_mail = new Application_Model_DbTable_DbSendEmail(); $db = new Application_Model_DbTable_Dbbookingtaxi(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $booking_id = $db->addTaxiBooking($data); $db_mail->sendInvoiceEmail($booking_id); $session = new Zend_Session_Namespace('taxibooking'); $session->unsetAll(); Application_Form_FrmMessage::redirectUrl("/index"); } }
public function viewTransferAction() { $id = $this->getRequest()->getParam('id') ? $this->getRequest()->getParam('id') : '0'; $transfer = new Product_Model_DbTable_DbUpdateTransfer(); $exist = $transfer->transferExist($id); $user = $this->GetuserInfoAction(); if ($exist == "") { //redirect if no transfer this id $this->_redirect("product/adjust-stock/index"); } else { $user_exist = $transfer->transferUserExist($id, $user["location_id"]); if ($user_exist == "") { //redirect if no transfer this id $this->_redirect("product/adjust-stock/index"); } } if ($this->getRequest()->getPost()) { // $post= $this->getRequest()->getPost(); // print_r($post);exit(); Application_Form_FrmMessage::message("You Haven't Permission To Change !"); Application_Form_FrmMessage::redirectUrl("/product/adjust-stock/index"); // $post = $this->getRequest()->getPost(); // $update = new Product_Model_DbTable_DbUpdateTransfer(); // $update->updateTransferStockTransaction($post); // $this->_redirect("product/adjust-stock/index"); } $db = new Application_Model_DbTable_DbGlobal(); $productinfo = new Product_Model_DbTable_DbProduct(); $rows = $productinfo->getTransferInfo($id); $row_item = $productinfo->getTransferItem($id); $this->view->transfer_item = $row_item; $frm = new Product_Form_FrmTransfer(); $frm_transfer = $frm->transferItem($rows); Application_Model_Decorator::removeAllDecorator($frm_transfer); $this->view->form_transfer = $frm_transfer; ///view on select location form table $getOption = new Application_Model_GlobalClass(); $locationRows = $getOption->getLocationOption(); $this->view->locationOption = $locationRows; ///view on select location form table $toLocationRows = $getOption->tolocationOption(); $this->view->tolocationOption = $toLocationRows; $itemRows = $getOption->getProductOption(); $this->view->productOption = $itemRows; //for add product; $formpopup = new Application_Form_FrmPopup(null); $formproduct = $formpopup->popuProduct(null); Application_Model_Decorator::removeAllDecorator($formproduct); $this->view->form = $formproduct; //for add location $formAdd = $formpopup->popuLocation(null); Application_Model_Decorator::removeAllDecorator($formAdd); $this->view->form_addstock = $formAdd; }
public function updateReturnItemIn($post) { try { $db = $this->getAdapter(); $db->beginTransaction(); $db_global = new Application_Model_DbTable_DbGlobal(); $session_user = new Zend_Session_Namespace('auth'); $userName = $session_user->user_name; $GetUserId = $session_user->user_id; $idrecord = $post['v_name']; // $datainfo=array( // "contact_name" => $post['contact'], // "phone" => $post['txt_phone'], // "add_name" => $post["vendor_address"] // ); // //updage vendor info // $db_global->updateRecord($datainfo,$idrecord,"vendor_id","tb_vendor"); // unset($datainfo); $return_id = $post["id"]; $old_location = $post["old_location"]; $sql_item = "SELECT\n\t \t(SELECT p.pro_id FROM tb_product AS p WHERE p.pro_id = rvi.`pro_id` LIMIT 1) AS pro_id\n\t \t\t\n\t \t,(SELECT p.qty_onorder FROM tb_product AS p WHERE p.pro_id = rvi.`pro_id` LIMIT 1) AS qty_onorder\n\t \n\t \t,(SELECT p.qty_onhand \tFROM tb_product AS p WHERE p.pro_id = rvi.`pro_id` LIMIT 1) AS qty_onhand\n\t \n\t \t,(SELECT p.qty_available \tFROM tb_product AS p WHERE p.pro_id = rvi.`pro_id` LIMIT 1) AS qty_available\n\t \t\t\n\t \t, SUM(rvi.`qty_return`) AS qty_return FROM\n \n \ttb_return_vendor_item_in AS rvi WHERE rvi.return_id = {$return_id} GROUP BY rvi.pro_id"; $rows_return = $db_global->getGlobalDb($sql_item); // print_r($rows_return); if ($rows_return) { foreach ($rows_return as $row_return) { $qty_stock = $row_return["qty_onhand"] - $row_return["qty_return"]; $rows = $db_global->inventoryLocation($old_location, $row_return["pro_id"]); $qty_location = $rows["qty"] - $row_return["qty_return"]; //print_r($rows);exit(); if ($qty_stock < 0) { Application_Form_FrmMessage::message("Your product stock is less than return"); Application_Form_FrmMessage::redirectUrl("/purchase/return/return-in"); //exit(); } elseif ($qty_location < 0) { Application_Form_FrmMessage::message("You Items is less than item return"); Application_Form_FrmMessage::redirectUrl("/purchase/return/return-in"); //exit(); } else { $qty_on_order = array("qty_onhand" => $row_return["qty_onhand"] - $row_return["qty_return"], "qty_available" => $row_return["qty_available"] - $row_return["qty_return"], "last_mod_date" => new Zend_date()); //update total stock $db_global->updateRecord($qty_on_order, $row_return["pro_id"], "pro_id", "tb_product"); unset($qty_on_order); $rowitem_exist = $db_global->porductLocationExist($row_return["pro_id"], $old_location); if ($rowitem_exist) { $updatedata = array('qty' => $rowitem_exist["qty"] - $row_return["qty_return"], "last_usermod" => $GetUserId, "last_mod_date" => new Zend_Date()); //update stock product location $db_global->updateRecord($updatedata, $rowitem_exist["ProLocationID"], "ProLocationID", "tb_prolocation"); unset($updatedata); } } } } $data_update = array("vendor_id" => $post["v_name"], "date_return_in" => $post["return_date"], "remark" => $post["return_remark"], "user_mod" => $GetUserId, "timestamp" => new Zend_Date(), "location_id" => $post["LocationId"], "all_total" => $post["all_total"]); $db_global->updateRecord($data_update, $return_id, "returnin_id", "tb_return_vendor_in"); unset($data_update); $sql = "DELETE FROM tb_return_vendor_item_in WHERE return_id IN ({$return_id})"; $db_global->deleteRecords($sql); $delete_history = "DELETE FROM tb_return_history WHERE return_id IN({$return_id})"; $db_global->deleteRecords($delete_history); $ids = explode(',', $post['identity']); //add order in tb_inventory must update code again 9/8/13 foreach ($ids as $i) { $add_data = array("return_id" => $return_id, "pro_id" => $post["item_id_" . $i], "qty_return" => $post["qty_return_" . $i], "price" => $post["price_" . $i], "sub_total" => $post["sub_total_" . $i], "return_remark" => $post["remark_" . $i]); $db->insert("tb_return_vendor_item", $add_data); $add_data = array("return_id" => $return_id, "pro_id" => $post["item_id_" . $i], "qty_return" => $post["qty_return_" . $i], "price" => $post["price_" . $i], "sub_total" => $post["sub_total_" . $i], "return_remark" => $post["remark_" . $i]); $db->insert("tb_return_vendor_item_in", $add_data); $rows = $db_global->inventoryLocation($post["LocationId"], $post["item_id_" . $i]); if ($rows) { $qty_on_return = array("qty_onhand" => $rows["qty_onhand"] + $post["qty_return_" . $i], "qty_available" => $rows["qty_available"] + $post["qty_return_" . $i], "last_mod_date" => new Zend_date()); //update total stock $db_global->updateRecord($qty_on_return, $post["item_id_" . $i], "pro_id", "tb_product"); unset($qty_on_return); $updatedata = array('qty' => $rows["qty"] + $post["qty_return_" . $i], "last_usermod" => $GetUserId, "last_mod_date" => new Zend_Date()); //update stock product location $db_global->updateRecord($updatedata, $rows["ProLocationID"], "ProLocationID", "tb_prolocation"); unset($updatedata); unset($qty_on_return); //add return history $data_history = array('transaction_type' => 4, 'pro_id' => $post["item_id_" . $i], 'date' => new Zend_Date(), 'location_id' => $post["LocationId_" . $i], 'Remark' => $post['remark_' . $i], 'qty_edit' => $post["qty_return_" . $i], 'qty_before' => $rows["qty"], 'qty_after' => $rows["qty"] - $post["qty_return_" . $i], 'user_mod' => $GetUserId); $db->insert("tb_move_history", $data_history); unset($data_history); $history = array("return_id" => $return_id, "return_no" => $post["retun_order"], "pro_id" => $post["item_id_" . $i], "location_id" => $post["LocationId"], "return_type" => 2, "vendor_id" => 1, "return_date" => $post["return_date"], "qty_return" => $post["qty_return_" . $i], "price" => $post["price_" . $i], "total_amount" => $post["sub_total_" . $i], "user_mod" => $GetUserId, "remark" => $post["return_remark"]); $db->insert("tb_return_history", $history); unset($history); } else { // Application_Form_FrmMessage::message("Your product in stock is not exist"); // Application_Form_FrmMessage::redirectUrl("/purchase/return"); // exit(); $row_location = $db_global->productLocation($post["LocationId"], $post["item_id_" . $i]); if ($row_location) { $updatedata = array('qty' => $rows["qty"] + $post["qty_return_" . $i], "last_usermod" => $GetUserId, "last_mod_date" => new Zend_Date()); //update stock product location $db_global->updateRecord($updatedata, $row_location["ProLocationID"], "ProLocationID", "tb_prolocation"); unset($updatedata); } else { $insertdata = array('pro_id' => $post["item_id_" . $i], 'LocationId' => $post["LocationId_" . $i], 'qty' => -$post["qty_return_" . $i]); } //update stock product location $db->insert("tb_prolocation", $insertdata); unset($insertdata); //add return history $data_history = array('transaction_type' => 4, 'pro_id' => $post["item_id_" . $i], 'date' => new Zend_Date(), 'location_id' => $post["LocationId_" . $i], 'Remark' => $post['remark_' . $i], 'qty_edit' => $post["qty_return_" . $i], 'qty_before' => 0, 'qty_after' => -$post["qty_return_" . $i], 'user_mod' => $GetUserId); $db->insert("tb_move_history", $data_history); unset($data_history); $history = array("return_id" => $return_id, "return_no" => $post["retun_order"], "pro_id" => $post["item_id_" . $i], "location_id" => $post["LocationId"], "return_type" => 2, "vendor_id" => 1, "return_date" => $post["return_date"], "qty_return" => $post["qty_return_" . $i], "price" => $post["price_" . $i], "total_amount" => $post["sub_total_" . $i], "user_mod" => $GetUserId, "remark" => $post["return_remark"]); $db->insert("tb_return_history", $history); unset($history); $rows_stock = $db_global->InventoryExist($post["item_id_" . $i]); if ($rows_stock) { $dataInventory = array('qty_onhand' => $rows_stock["qty_onhand"] - $post["qty_return_" . $i], 'qty_available' => $rows_stock["qty_available"] - $post["qty_return_" . $i], 'last_mod_date' => new Zend_date()); $db_global->updateRecord($dataInventory, $rows_stock["pro_id"], "pro_id", "tb_product"); unset($dataInventory); } else { $addInventory = array('pro_id' => $post["item_id_" . $i], 'qty_onhand' => -$post["qty_return_" . $i], 'qty_available' => -$post["qty_return_" . $i], 'last_mod_date' => new Zend_date()); $db->insert("tb_product", $addInventory); unset($addInventory); } } } $db->commit(); } catch (Exception $e) { $db->rollBack(); echo $e->getMessage(); } }
public function changePasswordAction() { $id = $this->getRequest()->getParam('id'); $form = new users_Form_FrmUser(); $this->view->frmusers = $form->frmuser(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $db = new users_Model_DbTable_DbUser(); $old_password = $this->getRequest()->getParam('old_password'); $password = $this->getRequest()->getParam('password'); if (isset($data['save'])) { if ($db->getpassword($id, $old_password)) { $db->changePassword($id, md5($password)); Application_Form_FrmMessage::message("កាបញ្ចូលប្រភេទអ្នកប្រើប្រាស់បានជោគជ័យ"); } else { Application_Form_FrmMessage::message("កាបញ្ចូលមិនបានជោគជ័យ"); } } if (isset($data['save_close'])) { if ($db->getpassword($id, $old_password)) { $db->changePassword($id, md5($password)); Application_Form_FrmMessage::message("កាបញ្ចូលប្រភេទអ្នកប្រើប្រាស់បានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/users'); } else { Application_Form_FrmMessage::message("កាបញ្ចូលមិនបានជោគជ័យ"); } } elseif (isset($data["km"]) == 2) { $dbs = new Application_Model_DbTable_DbSiteLanguages(); $ids = 2; $lang = $dbs->getbyid($ids); $session_lang = new Zend_Session_Namespace('lang'); $session_lang->unlock(); $session_lang->lang_id = $lang['id']; $session_lang->lang = $lang['language']; //print_r($lang);exit(); } elseif (isset($data["en"]) == 1) { $dbs = new Application_Model_DbTable_DbSiteLanguages(); $ids = 1; $lang = $dbs->getbyid($ids); $session_lang = new Zend_Session_Namespace('lang'); $session_lang->unlock(); $session_lang->lang_id = $lang['id']; $session_lang->lang = $lang['language']; //$this->_redirect('/login'); //exit(); } } }
public function editAction() { $id = $this->getRequest()->getParam("id"); $db = new location_Model_DbTable_DbLocation(); $row = $db->getLocationById($id); $this->view->icon = $row["icon"]; if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); //print_r($data);exit(); if (isset($data['save'])) { $db->updat($data, $id); Application_Form_FrmMessage::message("ការកែប្រែបានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/location/index/edit/id/' . $id); } if (isset($data['save_add'])) { $db->updat($data, $id); Application_Form_FrmMessage::message("ការកែប្រែបានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/location/index/add'); } if (isset($data['save_close'])) { $db->updat($data, $id); Application_Form_FrmMessage::message("ការកែប្រែបានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/location'); } elseif (isset($data["km"]) == 2) { $dbs = new Application_Model_DbTable_DbSiteLanguages(); $ids = 2; $lang = $dbs->getbyid($ids); $session_lang = new Zend_Session_Namespace('lang'); $session_lang->unlock(); $session_lang->lang_id = $lang['id']; $session_lang->lang = $lang['language']; //print_r($lang);exit(); } elseif (isset($data["en"]) == 1) { $dbs = new Application_Model_DbTable_DbSiteLanguages(); $ids = 1; $lang = $dbs->getbyid($ids); $session_lang = new Zend_Session_Namespace('lang'); $session_lang->unlock(); $session_lang->lang_id = $lang['id']; $session_lang->lang = $lang['language']; //$this->_redirect('/login'); //exit(); } } $form = new location_Form_FrmLocation(); $this->view->frmcate = $form->FrmLocation($row); }
public function advanceAction() { $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(); //print_r($data); if (isset($data["payment"]) == "UPDATE") { $update_purchase = new purchase_Model_DbTable_DbAdvance(); $get_result = $update_purchase->updatePurchaseOrder($data); } elseif (isset($data["recieve_paid"])) { $recieve_paid = new purchase_Model_DbTable_DbAdvance(); $result = $recieve_paid->receivePaidOrder($data); Application_Form_FrmMessage::message("Product have been recieved Success!!"); Application_Form_FrmMessage::redirectUrl("/purchase/advance/advance/id/" . $id); } elseif (isset($data["reorder"])) { $reorder = new purchase_Model_DbTable_DbAdvance(); $update_reoder = $reorder->rePurchaseOrder($data); Application_Form_FrmMessage::message("Product have been reoder Success!!"); } } ///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; $this->view->status = $rows["status"]; //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; $sql = "SELECT si.order_id,CONCAT(p.item_name,' (',p.item_code,' )') AS item_name,p.qty_perunit ,p.pro_id,si.remark as pi_remark,si.qty_order,si.price,si.total_befor,si.disc_type,\n\t\tsi.disc_value,si.is_free,si.sub_total,s.discount_value,s.`remark`,s.`discount_value`,s.`paid`,s.net_total,s.`all_total`,s.`balance`\n\t\tFROM tb_purchase_order_item AS si,tb_product AS p ,tb_purchase_order AS s\n\t\t WHERE p.pro_id = si.pro_id AND si.order_id = s.order_id AND si.order_id={$id}"; $result = $db->getGlobalDb($sql); $this->view->orderItem = $result; // 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; }
public function logoutAction() { // action body $this->_redirect("/index"); if ($this->getRequest()->getParam('value') == 1) { $aut = Zend_Auth::getInstance(); $aut->clearIdentity(); $session_user = new Zend_Session_Namespace('auth'); $log = new Application_Model_DbTable_DbUserLog(); $log->insertLogout($session_user->user_id); $session_user->unsetAll(); Application_Form_FrmMessage::redirectUrl("/"); exit; } }
public function editAction() { $user_type_id = $this->getRequest()->getParam('id'); $db = new users_Model_DbTable_DbUserType(); $row = $db->getUserType($user_type_id); $frmuser = new users_Form_FrmUserType(); $this->view->frmusers = $frmuser->frmTypeUser($row); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); if (isset($data['save'])) { $db->updateUserType($data, $user_type_id); Application_Form_FrmMessage::redirectUrl('/users/user-type/edit/id/' . $user_type_id); } if (isset($data['save_add'])) { $db->updateUserType($data, $user_type_id); Application_Form_FrmMessage::message("កាបញ្ចូលប្រភេទអ្នកប្រើប្រាស់បានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/users/user-type/add'); } if (isset($data['save_close'])) { $db->updateUserType($data, $user_type_id); Application_Form_FrmMessage::message("កាបញ្ចូលប្រភេទអ្នកប្រើប្រាស់បានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/users/user-type'); } } }
public function addBrandAction() { $category = new Product_Model_DbTable_DbProduct(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); //print_r($data);exit(); $addcategory = $category->addBrand($data); Application_Form_FrmMessage::message("Brand Name Has Been Saved !"); Application_Form_FrmMessage::redirectUrl('/product/index/brand'); } $id = $this->getRequest()->getParam('id') ? $this->getRequest()->getParam('id') : '0'; if ($id) { //view update if get id $rows = $category->getBrandName($id); $frmcategory = new Application_Form_FrmInclude($rows); $frmcate = $frmcategory->addBrand($rows); $action = BASE_URL . "/product/index/update-brand"; } else { $frmcategory = new Application_Form_FrmInclude(null); $frmcate = $frmcategory->addBrand(null); $action = BASE_URL . "/product/index/add-brand"; } Application_Model_Decorator::removeAllDecorator($frmcate); $method = "post"; $url_cancel = BASE_URL . "/product/index/brand"; $frm = new Application_Form_FrmGlobal(); $this->view->formVendor = $frm->getForm1($action, $method, $url_cancel, $frmcate, 'MENU_PRODUCT_INDEX_ADD_BRAND'); }
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; }
function getvehiclecitytourAction() { //action step3 $vehicle_id = $this->getRequest()->getParam("id"); if ($vehicle_id) { $dbbooking = new Application_Model_DbTable_Dbbookingcitytour(); $dbbooking->createSessionBookingCityTour($vehicle_id, 3); $this->_redirect("index/citytourbooking"); } Application_Form_FrmMessage::redirectUrl("/index/testing"); }
public function updateReturnItemAction() { try { $session_stock = new Zend_Session_Namespace('stock'); $id = $this->getRequest()->getParam('id') ? $this->getRequest()->getParam('id') : '0'; $db_global = new Application_Model_DbTable_DbGlobal(); $sql = "SELECT * FROM tb_return WHERE return_id =" . $id; $rs = $db_global->getGlobalDbRow($sql); if ($rs["is_active"] == 0) { Application_Form_FrmMessage::message("Can not update return becuase recieved already"); Application_Form_FrmMessage::redirectUrl("/purchase/return"); } else { if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); if ($data['Save']) { $update_return = new purchase_Model_DbTable_DbReturnItem(); $rs = $update_return->updateReturnItem($data); if ($rs == -1) { Application_Form_FrmMessage::Sucessfull("Your product location is not exist", "/purchase/return"); } // else // Application_Form_FrmMessage::Sucessfull("Update Sucessfull", "/purchase/return"); } } // $purchase = new purchase_Model_DbTable_DbPurchaseOrder(); // $rows = $purchase->purchaseInfo($id); // $db = new Application_Model_DbTable_DbGlobal(); $returnModel = new purchase_Model_DbTable_DbSQLReturnItem(); $row_info = $returnModel->returnInfo($id); $get_form = new Application_Form_FrmReturnItem(); $session_stock = new Zend_Session_Namespace('stock'); $frm_return = $get_form->returnItemForm($row_info); Application_Model_Decorator::removeAllDecorator($frm_return); $this->view->form_return = $frm_return; //get qty of return item $getReturnItem = $returnModel->getReturnItem($id); $this->view->returnItemDetail = $getReturnItem; //print_r($getReturnItem);exit(); //get return item $getOption = new Application_Model_GlobalClass(); $locationRows = $getOption->getLocationOption(); $this->view->locationOption = $locationRows; //print_r($locationRows);exit(); $itemRows = $getOption->getProductOption(); $this->view->productOption = $itemRows; //print_r($itemRows);exit(); $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_add_product = $formproduct; //for add vendor $formvendor = $formpopup->popupVendor(null); Application_Model_Decorator::removeAllDecorator($formvendor); $this->view->form_vendor = $formvendor; //for add location $formAdd = $formpopup->popuLocation(null); Application_Model_Decorator::removeAllDecorator($formAdd); $this->view->form_addstock = $formAdd; //for link advane $this->view->getorder_id = $id; } } catch (Exception $e) { echo $e->getMessage(); } }