public function purchaseAction() { $db = new report_Model_DbTable_DbReport(); $db_global = new Application_Model_DbTable_DbGlobal(); $form = new report_Form_FrmReport(); $itemRows = $db_global->getProductOption(); $this->view->itemsOption = $itemRows; $company_name = $db_global->getSettingByCode(4); $slogan = $db_global->getSettingByCode(5); $address = $db_global->getSettingByCode(2); $tel = $db_global->getSettingByCode(3); $qty_warning = $db_global->getSettingByCode(6); $this->view->company_name = $company_name; $this->view->slogan = $slogan; $this->view->address = $address; $this->view->tel = $tel; if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $search = array('txt_search' => $data['txt_search'], 'start_date' => $data['start_date'], 'end_date' => $data['end_date'], 'status' => $data['status'], 'supplier' => $data['supplier'], 'pay_status' => $data['pay_status'], 'purchase_no' => $data['purchase_no']); } else { $search = array('txt_search' => '', 'start_date' => date('Y-m-d'), 'end_date' => date('Y-m-d'), 'status' => -1, 'supplier' => -1, 'pay_status' => -1, 'purchase_no' => -1); } $sale = $db->getPurchase($search); $this->view->sale = $sale; $this->view->frm = $form->FrmSearch(); }
public function indexAction() { $db = new phurchase_Model_DbTable_DbOrder(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); if (isset($data["search"])) { $search = array('txt_search' => $data['txt_search'], 'start_date' => $data['start_date'], 'end_date' => $data['end_date'], 'status' => $data['status'], 'supplier' => $data['supplier'], 'pay_status' => $data['pay_status'], 'purchase_no' => $data['purchase_no']); } // if(isset($data['status'])){ // $ids = $data['status']; // $db->updateUnStatus($ids); // $this->_redirect("/phurchase/order"); // }elseif (isset($data['unstatus'])){ // $ids = $data['unstatus']; // $db->updateStatus($ids); // $this->_redirect("/phurchase/order"); // } $id = $data['checkBox']; if (isset($data['update']) && $id != "") { $this->_redirect("/phurchase/order/edit/id/" . $id); } elseif (isset($data['delete']) && $id != "") { $db->deleteCat($id); Application_Form_FrmMessage::message("កាលុបប្រភេទអ្នកប្រើប្រាស់បានជោគជ័យ"); Application_Form_FrmMessage::redirectUrl('/phurchase/order'); } else { $this->_redirect("/phurchase/order"); } } else { $search = array('txt_search' => '', 'start_date' => date('Y-m-d'), 'end_date' => date('Y-m-d'), 'status' => -1, 'supplier' => -1, 'pay_status' => -1, 'purchase_no' => -1); } $datas = $db->getAllCate($search); $this->view->getdata = $datas; $form = new report_Form_FrmReport(); $this->view->frm = $form->FrmSearch(); }
public function indexAction() { $db = new saleorder_Model_DbTable_DbSaleOrder(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $search = array('txt_search' => $data['txt_search'], 'start_date' => $data['start_date'], 'end_date' => $data['end_date'], 'status' => $data['status'], 'customer' => $data['customer'], 'pay_status' => $data['pay_status'], 'invoice_no' => $data['invoice_no']); } else { $search = array('txt_search' => '', 'start_date' => date('Y-m-d'), 'end_date' => date('Y-m-d'), 'status' => -1, 'customer' => -1, 'pay_status' => -1, 'invoice_no' => -1); } $datas = $db->getAllSaleOrderList($search); $this->view->getdata = $datas; $form = new report_Form_FrmReport(); $this->view->frm = $form->FrmSearch(); }