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();
}
