function searchPrice()
{
$request = Zend_Controller_Front::getInstance()->getRequest();
$db = new Application_Model_DbTable_DbGlobal();
/////////////Filter Product/////////////////
$tr = Application_Form_FrmLanguages::getCurrentlanguage();
$nameValue = $request->getParam('g_name');
$nameElement = new Zend_Form_Element_Text('g_name');
$nameElement->setValue($nameValue);
$this->addElement($nameElement);
$rs = $db->getGlobalDb('SELECT type_id, price_type_name FROM tb_price_type WHERE public = 1 AND price_type_name!=""');
$options = array('' => $tr->translate('Please_Select_Type_Price'));
$pricetypeValue = $request->getParam('type_id');
if (!empty($rs)) {
foreach ($rs as $read) {
$options[$read['type_id']] = $read['price_type_name'];
}
}
$pricetype_id = new Zend_Form_Element_Select('type_id');
$pricetype_id->setMultiOptions($options);
$pricetype_id->setAttribs(array('id' => 'type_id', 'onchange' => 'this.form.submit()'));
$pricetype_id->setValue($pricetypeValue);
$this->addElement($pricetype_id);
$nameValue = $request->getParam('p_name');
$nameElement = new Zend_Form_Element_Text('p_name');
$nameElement->setValue($nameValue);
$this->addElement($nameElement);
$nameValue = $request->getParam('p_price');
$nameElement = new Zend_Form_Element_Text('p_price');
$nameElement->setValue($nameValue);
$this->addElement($nameElement);
$rs = $db->getGlobalDb('SELECT CategoryId, Name FROM tb_category WHERE Name!="" ');
$options = array('Please Select Product');
$cateValue = $request->getParam('category_id');
foreach ($rs as $read) {
$options[$read['CategoryId']] = $read['Name'];
}
$cate_element = new Zend_Form_Element_Select('category_id');
$cate_element->setMultiOptions($options);
$cate_element->setAttribs(array('id' => 'category_id', 'class' => 'demo-code-language', 'onchange' => 'this.form.submit()'));
$cate_element->setValue($cateValue);
$this->addElement($cate_element);
$codeValue = $request->getParam('p_code');
$codeElement = new Zend_Form_Element_Text('p_code');
$codeElement->setValue($codeValue);
$this->addElement($codeElement);
$_arroption = array(1 => $tr->translate("ACTIVE"), 0 => $tr->translate("DEACTIVE"));
$_var = $request->getParams("status");
$statusElement = new Zend_Form_Element_Select("status");
$statusElement->setMultiOptions($_arroption);
$statusElement->setAttribs(array('id' => 'status', 'onchange' => 'this.form.submit()'));
$statusElement->setValue($_var);
$this->addElement($statusElement);
return $this;
}
public function addBrand($data = null)
{
$tr = Application_Form_FrmLanguages::getCurrentlanguage();
$db = new Application_Model_DbTable_DbGlobal();
$rowsbrand = $db->getGlobalDb('SELECT branch_id, Name
FROM tb_branch WHERE Name!="" ');
$options = array('' => $tr->translate('Please_Select'));
if ($rowsbrand) {
foreach ($rowsbrand as $readBrand) {
$options[$readBrand['branch_id']] = $readBrand['Name'];
}
}
$brandElement = new Zend_Form_Element_Select('Parent brand');
$brandElement->setAttribs(array('class' => 'demo-code-language'));
$brandElement->setMultiOptions($options);
$this->addElement($brandElement);
$b_nameElement = new Zend_Form_Element_Text('brand Name');
$b_nameElement->setAttribs(array('class' => 'validate[required]'));
$this->addElement($b_nameElement);
$optionsStatus = array(1 => $tr->translate("ACTIVE"), 2 => $tr->translate('DEACTIVE'));
$statusElement = new Zend_Form_Element_Select('status');
$statusElement->setAttribs(array('class' => 'demo-code-language'));
$statusElement->setMultiOptions($optionsStatus);
$this->addElement($statusElement);
if ($data != null) {
$idElement = new Zend_Form_Element_Hidden('id');
$this->addElement($idElement);
$statusElement->setValue($data["IsActive"]);
$idElement->setValue($data['branch_id']);
$b_nameElement->setValue($data['Name']);
$brandElement->setValue($data['parent_id']);
}
return $this;
}
public function indexAction()
{
$formFilter = new sales_Form_FrmStockFilter();
$this->view->formFilter = $formFilter;
Application_Model_Decorator::removeAllDecorator($formFilter);
$list = new Application_Form_Frmlist();
$db = new Application_Model_DbTable_DbGlobal();
$sales_agent_sql = "SELECT sg.agent_id, sg.name, sg.phone, sg.email, sg.address, sg.job_title, l.Name, sg.description\n FROM tb_sale_agent AS sg \n INNER JOIN tb_sublocation As l ON l.LocationId = sg.stock_id WHERE 1 ";
if ($this->getRequest()->isPost()) {
$search = $this->getRequest()->getPost();
if ($search["s_name"] != '') {
$sales_agent_sql .= " AND sg.name LIKE '%" . $search['s_name'] . "%'";
$sales_agent_sql .= " OR sg.phone LIKE '%" . $search['s_name'] . "%'";
}
if ($search["stock_location"] != '' and $search["stock_location"] != 0) {
$sales_agent_sql .= " AND sg.stock_id = " . $search['stock_location'];
}
}
$sales_agent_sql .= " ORDER BY sg.agent_id DESC";
$rows = $db->getGlobalDb($sales_agent_sql);
$columns = array("SALE-AGENT", "CONTACT_NUM_CAP", "EMAIL_CAP", "ADDRESS_CAP", "POSTION_CAP", "LOCATION_NAME_CAP", "DESC_CAP");
$link = array('module' => 'sales', 'controller' => 'sale-agent', 'action' => 'update-sale-agent');
$urlEdit = BASE_URL . "/sales/sale-agent/update-sale-agent";
$glClass = new Application_Model_GlobalClass();
$this->view->list = $list->getCheckList(1, $columns, $rows, array('name' => $link), $urlEdit);
}
public function frmSearchTeacher($_data = null)
{
$request = Zend_Controller_Front::getInstance()->getRequest();
$_title = new Zend_Dojo_Form_Element_TextBox('title');
$_title->setAttribs(array('dojoType' => $this->text, 'placeholder' => $this->tr->translate("SEARCH_BY_TEACHER_NAME")));
$_title->setValue($request->getParam('title'));
$_db = new Application_Model_DbTable_DbGlobal();
$rows = $_db->getGlobalDb("SELECT DISTINCT subject_name_en FROM rms_teacher WHERE teacher_name_en!='' AND subject_name_en!=''");
$opt = array(-1 => $this->tr->translate("CHOOSE_SUJECT"));
if (!empty($rows)) {
foreach ($rows as $row) {
$opt[$row['subject_name_en']] = $row['subject_name_en'];
}
}
$_subject = new Zend_Dojo_Form_Element_FilteringSelect('subjec_name');
$_subject->setMultiOptions($opt);
$_subject->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'placeholder' => $this->tr->translate("INPUT_VALUE_SETTING")));
$_subject->setValue($request->getParam('subjec_name'));
$_status = new Zend_Dojo_Form_Element_FilteringSelect('status_search');
$_status->setAttribs(array('dojoType' => $this->filter));
$_status_opt = array(-1 => $this->tr->translate("ALL_STATUS"), 1 => $this->tr->translate("ACTIVE"), 0 => $this->tr->translate("DACTIVE"));
$_status->setMultiOptions($_status_opt);
$_status->setValue($request->getParam("status_search"));
$this->addElements(array($_title, $_subject, $_status));
if (!empty($_data)) {
}
return $this;
}
public function FrmAddSchool($data = null)
{
$_classname = new Zend_Dojo_Form_Element_TextBox('schoolname');
$_classname->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside'));
$_province = new Zend_Dojo_Form_Element_FilteringSelect('province');
$_province->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
$_db = new Application_Model_DbTable_DbGlobal();
$rows_school = $_db->getGlobalDb("SELECT province_id,province_en_name FROM rms_province ");
$opt_school = "";
if (!empty($rows_school)) {
foreach ($rows_school as $row) {
$opt_school[$row['province_id']] = $row['province_en_name'];
}
}
$_province->setMultiOptions($opt_school);
$_status = new Zend_Dojo_Form_Element_FilteringSelect('status');
$_status->setAttribs(array('dojoType' => $this->filter, 'class' => 'fullside'));
$_status_opt = array(1 => $this->tr->translate("ACTIVE"), 2 => $this->tr->translate("DACTIVE"));
$_status->setMultiOptions($_status_opt);
$_submit = new Zend_Dojo_Form_Element_SubmitButton('submit');
$_submit->setLabel("save");
$id = new Zend_Form_Element_Hidden('id');
if (!empty($data)) {
$_classname->setValue($data['school_name']);
$_status->setValue($data['status']);
$_province->setValue($data['province_id']);
$id->setValue($data['id']);
}
$this->addElements(array($_classname, $_status, $_submit, $_province, $id));
return $this;
}
public function init()
{
$request = Zend_Controller_Front::getInstance()->getRequest();
$db = new Application_Model_DbTable_DbGlobal();
/////////////Filter stock/////////////////
$tr = Application_Form_FrmLanguages::getCurrentlanguage();
$nameElement = new Zend_Form_Element_Text('s_name');
$nameValue = $request->getParam('s_name');
$nameElement->setValue($nameValue);
$this->addElement($nameElement);
$phonevalue = $request->getParam('phone');
$phoneElement = new Zend_Form_Element_Text('phone');
$phoneElement->setValue($phonevalue);
$this->addElement($phoneElement);
$rs = $db->getGlobalDb('SELECT LocationId,Name FROM tb_sublocation ORDER BY LocationId DESC ');
$options = array('' => $tr->translate('Please_Select'));
$agentValue = $request->getParam('stock_location');
foreach ($rs as $read) {
$options[$read['LocationId']] = $read['Name'];
}
$sale_agent = new Zend_Form_Element_Select('stock_location');
$sale_agent->setMultiOptions($options);
$sale_agent->setAttribs(array('id' => 'LocationId', 'class' => 'demo-code-language'));
$sale_agent->setValue($agentValue);
$this->addElement($sale_agent);
return $this;
}
public static function getDataAutocompleteData($sql)
{
$gb_db = new Application_Model_DbTable_DbGlobal();
$rs = $gb_db->getGlobalDb($sql);
//echo Zend_Json::encode($rs);
$data = Zend_Json::encode($rs);
return $data;
}
public function init()
{
/* Initialize action controller here */
header('content-type: text/html; charset=utf8');
defined('BASE_URL') || define('BASE_URL', Zend_Controller_Front::getInstance()->getBaseUrl());
$db = new Application_Model_DbTable_DbGlobal();
$sql = "SELECT u.user_type_id,u.user_type FROM `rms_acl_user_type` u where u.`status`=1";
$results = $db->getGlobalDb($sql);
foreach ($results as $key => $r) {
$this->user_typelist[$r['user_type_id']] = $r['user_type'];
}
}
/**
* create option for setMultiOption in select box
* @param string $value
* @param string $label
* @param string $sql
* @return array('id'=>'label')
*/
public function getOption($value, $label, $sql)
{
$db = new Application_Model_DbTable_DbGlobal();
$rs = $db->getGlobalDb($sql);
$options = array();
if ($rs) {
foreach ($rs as $read) {
$options[$read[$value]] = $read[$label];
}
}
return $options;
}
public function getfillteraddAction()
{
if ($this->getRequest()->IsPost()) {
$data = $this->getRequest()->getPost();
$user_type = $data['user_type'];
$sql = "SELECT user_type FROM tbwu_acl_user_type WHERE user_type = '{$user_type}'";
$db = new Application_Model_DbTable_DbGlobal();
$row = $db->getGlobalDb($sql);
echo Zend_Json::encode($row);
exit;
}
}
public function init()
{
/* Initialize action controller here */
header('content-type: text/html; charset=utf8');
//clear all other sessions
Application_Form_FrmSessionManager::clearSessionSearch();
$db = new Application_Model_DbTable_DbGlobal();
$sql = "SELECT u.user_type_id,u.user_type FROM `rsv_acl_user_type` u where u.`status`=1";
$results = $db->getGlobalDb($sql);
foreach ($results as $key => $r) {
$this->user_typelist[$r['user_type_id']] = $r['user_type'];
}
}
public function init()
{
//user name
$user_type = new Zend_Form_Element_Text('user_type');
$user_type->setAttribs(array('id' => 'user_type'));
$this->addElement($user_type);
//Main parent of user type
$db = new Application_Model_DbTable_DbGlobal();
$rs = $db->getGlobalDb("SELECT ut.user_type_id,ut.user_type FROM rsv_acl_user_type AS ut");
$options = array();
foreach ($rs as $read) {
$options[$read['user_type_id']] = $read['user_type'];
}
$user_type_id = new Zend_Form_Element_Select('user_type_id');
$user_type_id->setMultiOptions($options);
$this->addElement($user_type_id);
$rs = $db->getGlobalDb("SELECT acl.acl_id, CONCAT(acl.module,'/', acl.controller,'/', acl.action) AS user_access FROM rsv_acl_acl AS acl");
$options = array();
foreach ($rs as $read) {
$options[$read['acl_id']] = $read['user_access'];
}
$user_access_id = new Zend_Form_Element_Select('acl_id');
$user_access_id->setMultiOptions($options);
$this->addElement($user_access_id);
//Project assignment
//Sophen add here to assign project
$user_session_id = new Zend_Session_Namespace('auth');
$id = $user_session_id->user_type_id;
//echo $user_id;exit;
$db_user = new Application_Model_DbTable_DbGlobal();
if ($id == 1) {
$sql = "select acl.acl_id,CONCAT(acl.module,'/', acl.controller,'/', acl.action) AS user_access from rsv_acl_acl as acl";
} else {
$sql = "SELECT acl.acl_id, CONCAT(acl.module,'/', acl.controller,'/', acl.action) AS user_access, acl.status FROM rsv_acl_user_access AS ua \r\n\t\t INNER JOIN rsv_acl_user_type AS ut ON (ua.user_type_id = ut.parent_id)\r\n\t\t\t INNER JOIN rsv_acl_acl AS acl ON (acl.acl_id = ua.acl_id) WHERE ut.user_type_id =" . $id;
}
//print_r($sql); exit;
$project = $db_user->getGlobalDb($sql);
if ($project) {
$i = 0;
foreach ($project as $read) {
//print_r($read);exit;
$i++;
$check_fund = new Zend_Form_Element_Checkbox('acl_id_' . $i, array('label' => $read['user_access']));
$check_fund->setUncheckedValue('')->setCheckedValue($read['acl_id']);
$this->addElement($check_fund);
}
$this->plus = $i;
}
//remove decorator
Application_Model_Decorator::removeAllDecorator($this);
}
public function getPurchaseidAction()
{
if ($this->getRequest()->isPost()) {
$db = new Application_Model_DbTable_DbGlobal();
$post = $this->getRequest()->getPost();
$invoice = $post['invoice_id'];
$sqlinfo = "SELECT * FROM `tb_purchase_order` WHERE order_id = {$invoice} LIMIT 1";
$rowinfo = $db->getGlobalDbRow($sqlinfo);
$sql = "SELECT pui.qty_order,pui.pro_id,pui.price,pui.sub_total\n\t\t\t\t\t,(SELECT pur.order FROM tb_purchase_order as pur WHERE pur.order_id = pui.order_id ) as order_no\n\t\t\t\t\t,(SELECT pur.all_total FROM tb_purchase_order as pur WHERE pur.order_id = pui.order_id ) as all_total\n\t\t\t\t\t,(SELECT pr.qty_perunit FROM tb_product AS pr WHERE pr.pro_id = pui.pro_id LIMIT 1) AS qty_perunit\n \t\t\t\t,(SELECT pr.item_name FROM tb_product AS pr WHERE pr.pro_id = pui.pro_id LIMIT 1) AS item_name\n\t\t\t\t\t,(SELECT pr.pro_id FROM tb_product AS pr WHERE pr.pro_id = pui.pro_id LIMIT 1) AS pro_id\n \t\t\t\t,(SELECT `label` FROM tb_product AS pr WHERE pr.pro_id = pui.pro_id LIMIT 1) AS label\n \t\t\t\t ,(SELECT `measure_name` FROM `tb_measure` AS ms WHERE ms.id=(SELECT measure_id FROM tb_product WHERE pro_id=pui.`pro_id`)) AS measure_name\n \t\t\tFROM `tb_purchase_order_item` AS pui WHERE pui.order_id = " . $invoice;
$rows = $db->getGlobalDb($sql);
$result = array('poinfo' => $rowinfo, 'item' => $rows);
echo Zend_Json::encode($result);
exit;
}
}
public function FrmGeneraljurnal($data = null)
{
$Brance = new Zend_Dojo_Form_Element_FilteringSelect('brance');
$Brance->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'required' => true));
$db = new Application_Model_DbTable_DbGlobal();
$rows = $db->getAllBranchName();
$options = '';
if (!empty($rows)) {
foreach ($rows as $row) {
$options[$row['br_id']] = $row['branch_namekh'];
}
}
$Brance->setMultiOptions($options);
$Add_Date = new Zend_Dojo_Form_Element_DateTextBox('add_date');
$Add_Date->setAttribs(array('dojoType' => 'dijit.form.DateTextBox', 'class' => 'fullside', 'required' => true));
$Add_Date->setValue(date('Y-m-d'));
$Account_Number = new Zend_Dojo_Form_Element_FilteringSelect('account_number');
$Account_Number->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'required' => 'true'));
$db = new Application_Model_DbTable_DbGlobal();
$sql = "SELECT id,account_name_en,account_code FROM ln_account_name WHERE status=1";
$rows = $db->getGlobalDb($sql);
$opt = '';
if (!empty($rows)) {
foreach ($rows as $row) {
$opt[$row['id']] = $row['account_code'];
}
}
$Account_Number->setMultiOptions($opt);
$Account_name = new Zend_Dojo_Form_Element_FilteringSelect('account_name');
$Account_name->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside'));
$opt = '';
if (!empty($rows)) {
foreach ($rows as $row) {
$opt[$row['id']] = $row['account_name_en'];
}
}
$Account_name->setMultiOptions($opt);
$Note = new Zend_Dojo_Form_Element_TextBox('note');
$Note->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside'));
$Debit = new Zend_Dojo_Form_Element_TextBox('debit');
$Debit->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside'));
$Debit->setValue(0);
$Credit = new Zend_Dojo_Form_Element_TextBox('credit');
$Credit->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside'));
$Credit->setValue(0);
$this->addElements(array($Add_Date, $Account_Number, $Account_name, $Note, $Debit, $Credit, $Brance));
return $this;
}
public function indexAction()
{
$formFilter = new Product_Form_FrmProductFilter();
$this->view->formFilter = $formFilter;
//$cate = $formFilter->listCategory();
//$this->view->cate = $cate;
$list = new Application_Form_Frmlist();
$user_info = new Application_Model_DbTable_DbGetUserInfo();
$result = $user_info->getUserInfo();
$db = new Application_Model_DbTable_DbGlobal();
// $productSql = "SELECT p.pro_id,p.item_name,p.item_code,g.Name As cate_name, b.Name as LocationName, lo.Name, pl.qty
// FROM tb_product AS p
// INNER JOIN tb_prolocation AS pl ON pl.pro_id = p.pro_id
// INNER JOIN tb_category AS g ON g.CategoryId = p.cate_id
// INNER JOIN tb_branch as b ON b.branch_id = p.brand_id
// INNER JOIN tb_sublocation AS lo ON lo.LocationId = pl.LocationId WHERE 1 ";
$productSql = "SELECT \n\t\t\t\tp.pro_id \n\t\t\t\t,p.item_name\n\t\t\t\t,p.item_code\n\t\t\t\t,(SELECT g.Name FROM tb_category AS g WHERE g.CategoryId = (SELECT cate_id FROM tb_product WHERE pro_id = pl.`pro_id` LIMIT 1)) AS Cate_name\n\t\t\t\t,(SELECT b.Name FROM tb_branch AS b WHERE b.branch_id = (SELECT brand_id FROM tb_product WHERE pro_id = pl.`pro_id` LIMIT 1 )) AS Branch\n\t\t\t\t,(SELECT lo.Name FROM tb_sublocation AS lo WHERE lo.LocationId = pl.LocationId LIMIT 1) AS LocationName\n\t\t\t\t,pl.qty\n\t\t\tFROM tb_prolocation AS pl,tb_product AS p WHERE pl.`pro_id`=p.pro_id ";
$str_condition = " AND pl.LocationId";
$productSql .= $db->getAccessPermission($result["level"], $str_condition, $result["location_id"]);
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
$productName = $this->getRequest()->getParam('s_name');
if ($post['LocationId'] !== '' and $post['LocationId'] != 0) {
$productSql .= " AND pl.LocationId = " . trim($post['LocationId']);
}
if ($post['p_name'] != '') {
$productSql .= " AND p.item_name LIKE '%" . trim($post['p_name']) . "%'";
$productSql .= " OR p.item_code LIKE '%" . trim($post['p_name']) . "%'";
}
if ($post['category_id'] !== '' and $post['category_id'] != 0) {
//echo $post['category_id']; exit();
$productSql .= " AND p.cate_id =" . trim($post['category_id']);
}
if ($post['branch_id'] !== '' and $post['branch_id'] != 0) {
$productSql .= " AND p.brand_id =" . trim($post['branch_id']);
}
}
//echo $productSql;exit();
$productSql .= " ORDER BY p.item_name,p.cate_id DESC";
$rows = $db->getGlobalDb($productSql);
$link = array('module' => 'product', 'controller' => 'index', 'action' => 'update');
$columns = array("ITEM_NAME_CAP", "item_code", "CATEGORY_CAP", "BRAND_CAP", "LOCATION_NAME_CAP", "QTY_HAND_CAP");
$urlEdit = BASE_URL . "/distributor/index/update";
$urlEdit = BASE_URL . "/product/index/update";
$this->view->list = $list->getCheckList(1, $columns, $rows, array('item_name' => $link), $urlEdit);
Application_Model_Decorator::removeAllDecorator($formFilter);
}
public function showSaleAgentForm($data = null, $stockID = null)
{
$db = new Application_Model_DbTable_DbGlobal();
$nameElement = new Zend_Form_Element_Text('name');
$nameElement->setAttribs(array('class' => 'validate[required]', 'placeholder' => 'Enter Agent Name'));
$this->addElement($nameElement);
$phoneElement = new Zend_Form_Element_Text('phone');
$phoneElement->setAttribs(array('class' => 'validate[required]', 'placeholder' => 'Enter Phone Number'));
$this->addElement($phoneElement);
$emailElement = new Zend_Form_Element_Text('email');
$emailElement->setAttribs(array('class' => 'validate[custom[email]]', 'placeholder' => 'Enter Email Address'));
$this->addElement($emailElement);
$addressElement = new Zend_Form_Element_Text('address');
$addressElement->setAttribs(array('placeholder' => 'Enter Current Address'));
$this->addElement($addressElement);
$jobTitleElement = new Zend_Form_Element_Text('job_title');
$jobTitleElement->setAttribs(array('placeholder' => 'Enter Position'));
$this->addElement($jobTitleElement);
$descriptionElement = new Zend_Form_Element_Textarea('description');
$descriptionElement->setAttribs(array('placeholder' => 'Descrtion Here...'));
$this->addElement($descriptionElement);
$rowsStock = $db->getGlobalDb('SELECT LocationId,Name FROM tb_sublocation WHERE Name!="" ORDER BY LocationId DESC ');
$optionsStock = array('1' => 'Default Location', '-1' => 'Add New Location');
if (count($rowsStock) > 0) {
foreach ($rowsStock as $readStock) {
$optionsStock[$readStock['LocationId']] = $readStock['Name'];
}
}
$mainStockElement = new Zend_Form_Element_Select('main_stock_id');
$mainStockElement->setAttribs(array('OnChange' => 'AddLocation()', 'class' => 'demo-code-language'));
$mainStockElement->setMultiOptions($optionsStock);
$this->addElement($mainStockElement);
//set value when edit
if ($data != null) {
$idElement = new Zend_Form_Element_Hidden('id');
$this->addElement($idElement);
$idElement->setValue($data['agent_id']);
$nameElement->setValue($data['name']);
$phoneElement->setValue($data['phone']);
$emailElement->setValue($data['email']);
$addressElement->setValue($data['address']);
$jobTitleElement->setValue($data['job_title']);
$mainStockElement->setValue($data["stock_id"]);
$descriptionElement->setValue($data['description']);
}
return $this;
}
public function indexAction()
{
$formFilter = new Application_Form_Frmsearch();
$this->view->formFilter = $formFilter;
$list = new Application_Form_Frmlist();
$db = new Application_Model_DbTable_DbGlobal();
$sale_order_sql = "SELECT o.order_id,o.order,o.date_order, o.status,c.cust_name, o.all_total, u.username\n\t\t\t\t\t FROM tb_sales_order AS o ,tb_customer AS c, rsv_acl_user AS u\n\t\t\t\t\t WHERE c.customer_id=o.customer_id AND o.user_mod = u.user_id ";
// $sale_order_sql = "SELECT o.order_id,o.order,o.date_order, o.status,c.cust_name, o.all_total, o.paid,o.balance
// FROM tb_sales_order AS o INNER JOIN tb_customer AS c ON c.customer_id=o.customer_id";
$user = $this->GetuserInfoAction();
$str_condition = " AND o.LocationId";
$sale_order_sql .= $db->getAccessPermission($user["level"], $str_condition, $user["location_id"]);
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
//echo $post["order"];
if ($post['order'] != '') {
$sale_order_sql .= " AND o.order LIKE '%" . $post['order'] . "%'";
}
// if($post['customer_id'] !=''){
// $sale_order_sql .= " AND c.customer_id LIKE '%".$post['customer_id']."%'";
// }
if ($post['sale_agent_id'] != '' and $post['sale_agent_id'] != 0) {
$sale_order_sql .= " AND o.sales_ref = " . $post['sale_agent_id'];
}
if ($post['status'] != '') {
$sale_order_sql .= " AND o.status =" . $post['status'];
}
$start_date = $post['search_start_date'];
$end_date = $post['search_end_date'];
if ($start_date != "" && $end_date != "" && strtotime($end_date) >= strtotime($start_date)) {
$sale_order_sql .= " AND o.date_order BETWEEN '{$start_date}' AND '{$end_date}'";
}
} else {
//$sale_order_sql.="";
}
$sale_order_sql .= " ORDER BY o.order_id DESC";
$rows = $db->getGlobalDb($sale_order_sql);
$glClass = new Application_Model_GlobalClass();
$rows = $glClass->getStatusType($rows, BASE_URL, true);
$columns = array("ORDER_ADD_CAP", "ORDER_DATE_CAP", "STATUS_CAP", "CON_NAME_CAP", "TOTAL_CAP_DOLLAR", "BY_USER_CAP");
//$columns=array("ORDER_ADD_CAP","ORDER_DATE_CAP","STATUS_CAP", "CON_NAME_CAP","TOTAL_CAP_DOLLAR","PAID_DOLLAR_CAP","BALANCE_CAP");
$link = array('module' => 'sales', 'controller' => 'sales-order', 'action' => 'detail-sales-order');
$urlEdit = BASE_URL . "/sales/sales-order/update-sales";
$this->view->list = $list->getCheckList(1, $columns, $rows, array('order' => $link, 'cust_name' => $link, 'contact_name' => $link), $urlEdit);
Application_Model_Decorator::removeAllDecorator($formFilter);
}
public function frmuser($frm = null)
{
$db = new Application_Model_DbTable_DbGlobal();
$status = new Zend_Form_Element_Select('status');
$_arr_status = array(1 => $this->tr->translate("ACTIVE"), 0 => $this->tr->translate("DACTIVE"));
$status->setMultiOptions($_arr_status);
$status->setAttribs(array('class' => 'form-control validate[required]'));
$id_code = new Zend_Form_Element_Text('id_code');
$id_code->setAttribs(array('class' => 'form-control validate[required]'));
$fullname = new Zend_Form_Element_Text('fullname');
$fullname->setAttribs(array('class' => 'form-control validate[required]'));
$username = new Zend_Form_Element_Text('username');
$username->setAttribs(array('class' => 'form-control validate[required]', 'Onkeyup' => 'getfillterUserType()'));
$email = new Zend_Form_Element_Text('email');
$email->setAttribs(array('class' => 'validate[required,custom[email]] form-control', 'Onkeyup' => 'getfillterUserType()'));
$old_password = new Zend_Form_Element_Password('old_password');
$old_password->setAttribs(array('class' => 'validate[required,minSize[5]] form-control'));
$password = new Zend_Form_Element_Password('password');
$password->setAttribs(array('class' => 'validate[required,minSize[5]] form-control'));
$confirm_password = new Zend_Form_Element_Password('confirm_password');
$confirm_password->setAttribs(array('class' => 'validate[required,equals[password]] form-control'));
$rs = $db->getGlobalDb('SELECT user_type_id,user_type FROM tb_user_type where user_type_id');
$options = array('' => '--- ជ្រើសរើសប្រភេទអ្នកប្រើប្រាស់ ---');
foreach ($rs as $read) {
$options[$read['user_type_id']] = $read['user_type'];
}
$user_type_id = new Zend_Form_Element_Select('user_type');
$user_type_id->setMultiOptions($options);
$user_type_id->setAttribs(array('id' => 'user_type_id', 'class' => 'form-control chzn-select validate[required]'));
$id = new Zend_Form_Element_Hidden('id');
$photo = new Zend_Form_Element_File('photo');
$this->addElements(array($status, $id_code, $photo, $id, $fullname, $username, $email, $password, $confirm_password, $user_type_id, $old_password));
if ($frm != "") {
$id->setValue($frm['user_id']);
$fullname->setValue($frm['name']);
$username->setValue($frm['user_name']);
$email->setValue($frm['email']);
$id_code->setValue($frm['user_code']);
// $password->setValue($frm['password']);
$user_type_id->setValue($frm['user_type']);
$photo->setValue($frm['photo']);
$status->setValue($frm['status']);
}
return $this;
}
public function init()
{
//user name
$user_type = new Zend_Form_Element_Text('user_type');
$user_type->setAttribs(array('id' => 'user_type', 'class' => 'validate[required]'));
$this->addElement($user_type);
//Main parent of user type
$db = new Application_Model_DbTable_DbGlobal();
$rs = $db->getGlobalDb('SELECT user_type_id,user_type FROM rsv_acl_user_type');
$options = array('' => 'Please select');
foreach ($rs as $read) {
$options[$read['user_type_id']] = $read['user_type'];
}
$user_type_id = new Zend_Form_Element_Select('parent_id');
$user_type_id->setMultiOptions($options);
$user_type_id->setAttribs(array('id' => 'parent_id', 'class' => 'validate[required]'));
$this->addElement($user_type_id);
}
public function editAction()
{
if ($this->getRequest()->getParam('id')) {
$db = new RsvAcl_Model_DbTable_DbUserType();
$user_type_id = $this->getRequest()->getParam('id');
$rs = $db->getUserType($user_type_id);
$this->view->usertype = $rs;
$db1 = new Application_Model_DbTable_DbGlobal();
$allusertype = $db1->getGlobalDb('SELECT user_type_id,user_type FROM rms_acl_user_type WHERE status=1 AND user_type_id <> ' . $user_type_id);
$options = array('' => 'Please select');
foreach ($allusertype as $read) {
$options[$read['user_type_id']] = $read['user_type'];
}
$this->view->usertype_list = $options;
} else {
Application_Form_FrmMessage::message('User type had not existed');
}
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
//print_r($rs); exit;
if ($rs['user_type'] == $post['user_type']) {
$db->updateUserType($post, $rs['user_type_id']);
//write log file
$userLog = new Application_Model_Log();
$userLog->writeUserLog($user_type_id);
//End write log file
//Application_Form_FrmMessage::message('One row affected!');
Application_Form_FrmMessage::redirector('/rsvacl/usertype/index');
} else {
if (!$db->isUserTypeExist($post['user_type'])) {
$db->updateUserType($post, $rs['user_type_id']);
//write log file
$userLog = new Application_Model_Log();
$userLog->writeUserLog($user_type_id);
//End write log file
//Application_Form_FrmMessage::message('One row affected!');
Application_Form_FrmMessage::redirector('/rsvacl/usertype/index');
} else {
Application_Form_FrmMessage::message('User had existed already');
}
}
}
}
public function FrmAddStudentRoom($data = null)
{
$_start_date = new Zend_Dojo_Form_Element_DateTextBox('dob');
$date = date("Y-MM-d");
$_start_date->setAttribs(array('data-dojo-type' => "dijit.form.DateTextBox", 'data-dojo-props' => "value:'{$date}','class':'fullside'", 'required' => true));
$_expire_date = new Zend_Dojo_Form_Element_TextBox('expire_date');
$_expire_date->setAttribs(array('dojoType' => $this->t_date, 'class' => 'fullside', 'required' => 'true'));
$_check = new Zend_Dojo_Form_Element_RadioButton("check");
$_check->setMultiOptions(array('1' => 'check', '0' => 'allow'));
// $_check=$this->createElement('radio','Choose');
// $_check->setLabel('Choose:')->addMultiOptions(array( 'check' => 'check', 'allow' => 'allow' ))
// ->setSeparator('');
//$_allow=new Zend_Dojo_Form_Element_RadioButton("allow");
$_db_room = new Application_Model_DbTable_DbGlobal();
$rows_room = $_db_room->getGlobalDb('SELECT room_id,room_name FROM rms_room WHERE is_active=1 AND room_name !="" ');
$_room_opt = "";
if (!empty($rows_room)) {
foreach ($rows_room as $row) {
$_room_opt[$row['room_id']] = $row['room_name'];
}
}
$_room_name = new Zend_Dojo_Form_Element_FilteringSelect("room_name");
$_room_name->setMultiOptions($_room_opt);
$_room_name->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'class' => 'fullside'));
$_session = new Zend_Dojo_Form_Element_FilteringSelect("session");
$opt_session = array(1 => $this->tr->translate('MORNING'), 2 => $this->tr->translate('AFTERNOON'), 3 => $this->tr->translate('EVERNING'), 4 => $this->tr->translate('WEEKEND'));
$_session->setMultiOptions($opt_session);
$_session->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'class' => 'fullside'));
$_db = new Application_Model_DbTable_DbGlobal();
$rows = $_db->getGlobalDb('SELECT major_id,major_enname FROM rms_major WHERE is_active=1 AND major_enname !="" ');
$opt = "";
if (!empty($rows)) {
foreach ($rows as $row) {
$opt[$row['major_id']] = $row['major_enname'];
}
}
$_major = new Zend_Dojo_Form_Element_FilteringSelect("major");
$_major->setMultiOptions($opt);
$_major->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'class' => 'fullside'));
$this->addElements(array($_start_date, $_check, $_room_name, $_session, $_major, $_expire_date));
return $this;
}
public function indexAction()
{
$formFilter = new Application_Form_Frmsearch();
$this->view->formFilter = $formFilter;
Application_Model_Decorator::removeAllDecorator($formFilter);
$list = new Application_Form_Frmlist();
$db = new Application_Model_DbTable_DbGlobal();
$vendor_sql = "SELECT p.order_id, p.order, p.date_order, p.status, v.v_name, p.all_total,p.paid,p.balance\n\t\t\t\t\t\tFROM tb_purchase_order AS p INNER JOIN tb_vendor AS v ON v.vendor_id=p.vendor_id ";
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
//echo $post["order"];
if ($post['order'] != '') {
$vendor_sql .= " AND p.order LIKE '%" . $post['order'] . "%'";
}
if ($post['vendor_name'] != '') {
$vendor_sql .= " AND v.vendor_id =" . $post['vendor_name'];
}
if ($post['phone'] != '') {
$vendor_sql .= " AND v.phone LIKE '%" . $post['phone'] . "%'";
}
if ($post['status'] != '') {
$vendor_sql .= " AND p.status =" . $post['status'];
}
$start_date = $post['search_start_date'];
$end_date = $post['search_end_date'];
if ($start_date != "" && $end_date != "" && strtotime($end_date) >= strtotime($start_date)) {
$vendor_sql .= " AND p.date_order BETWEEN '{$start_date}' AND '{$end_date}'";
}
}
$vendor_sql .= " ORDER BY p.timestamp DESC";
$rows = $db->getGlobalDb($vendor_sql);
$glClass = new Application_Model_GlobalClass();
$rows = $glClass->getStatusType($rows, BASE_URL, true);
$columns = array("PURCHASE_ORDER_CAP", "ORDER_DATE_CAP", "STATUS_CAP", "VENDOR_NAME_CAP", "TOTAL_CAP_DOLLAR", "PAID_DOLLAR_CAP", "BALANCE_CAP");
$link = array('module' => 'purchase', 'controller' => 'index', 'action' => 'detail-purchase-order');
$urlEdit = BASE_URL . "/purchase/index/update-purchase-order";
$this->view->list = $list->getCheckList(1, $columns, $rows, array('order' => $link), $urlEdit);
}
public function FrmSearchFromCustomer()
{
$tr = Application_Form_FrmLanguages::getCurrentlanguage();
$request = Zend_Controller_Front::getInstance()->getRequest();
$db = new Application_Model_DbTable_DbGlobal();
$nameValue = $request->getParam('order');
$nameElement = new Zend_Form_Element_Text('order');
$nameElement->setValue($nameValue);
$this->addElement($nameElement);
$returninValue = $request->getParam('return_in');
$returninElement = new Zend_Form_Element_Text('return_in');
$returninElement->setValue($returninValue);
$this->addElement($returninElement);
$startDateValue = $request->getParam('search_start_date');
$startDateElement = new Zend_Form_Element_Text('search_start_date');
$startDateElement->setValue($startDateValue);
$this->addElement($startDateElement);
$endDateValue = $request->getParam('search_end_date');
$endDateElement = new Zend_Form_Element_Text('search_end_date');
$endDateElement->setValue($endDateValue);
$this->addElement($endDateElement);
$rowCustomers = $db->getGlobalDb('SELECT customer_id, cust_name FROM tb_customer WHERE cust_name!="" AND is_active=1 ORDER BY customer_id DESC');
$agentValue = $request->getParam('customer_id');
$options = array('' => $tr->translate('Please_Select_Customer'));
if (!empty($rowCustomers)) {
foreach ($rowCustomers as $rowCustomer) {
$options[$rowCustomer['customer_id']] = $rowCustomer['cust_name'];
}
}
$customer_id = new Zend_Form_Element_Select('customer_id');
$customer_id->setMultiOptions($options);
$customer_id->setattribs(array('id' => 'customer_id', 'class' => 'validate[required]'));
$customer_id->setValue($agentValue);
$this->addElement($customer_id);
Application_Form_DateTimePicker::addDateField(array('search_start_date', 'search_end_date'));
return $this;
}
public function FrmAddMajor($data = null)
{
$_major_enname = new Zend_Dojo_Form_Element_TextBox('major_enname');
$_major_enname->setAttribs(array('dojoType' => 'dijit.form.ValidationTextBox', 'required' => 'true', 'missingMessage' => 'Invalid Module!', 'class' => 'full height-text'));
$_major_khname = new Zend_Dojo_Form_Element_TextBox('major_khname');
$_major_khname->setAttribs(array('dojoType' => 'dijit.form.ValidationTextBox', 'required' => 'true', 'missingMessage' => 'Invalid Module!', 'class' => 'full height-text'));
$_shortcut = new Zend_Dojo_Form_Element_TextBox('shortcut');
$_shortcut->setAttribs(array('dojoType' => 'dijit.form.ValidationTextBox', 'required' => 'true', 'class' => 'full height-text'));
$_arr = array(1 => $this->tr->translate("ACTIVE"), 0 => $this->tr->translate("DACTIVE"));
$_status = new Zend_Dojo_Form_Element_FilteringSelect("status");
$_status->setMultiOptions($_arr);
$_status->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'required' => 'true', 'missingMessage' => 'Invalid Module!', 'class' => 'full height-text'));
$_db = new Application_Model_DbTable_DbGlobal();
$rows = $_db->getGlobalDb('SELECT DISTINCT en_name,dept_id FROM rms_dept WHERE is_active=1 AND en_name !="" ');
$opt = "";
$opt = array('' => '', '-1' => $this->tr->translate("ADD_NEW"));
if (!empty($rows)) {
foreach ($rows as $row) {
$opt[$row['dept_id']] = $row['en_name'];
}
}
//print_r($opt);exit();
$_dept = new Zend_Dojo_Form_Element_FilteringSelect("dept");
$_dept->setMultiOptions($opt);
$_dept->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'required' => 'true', 'missingMessage' => 'Invalid Module!', 'class' => 'full height-text', 'onChange' => 'ShowPopupDept()'));
$_majorid = new Zend_Form_Element_Hidden('major_id');
if (!empty($data)) {
$_majorid->setValue($data['major_id']);
$_major_enname->setValue($data["major_enname"]);
$_major_khname->setValue($data["major_khname"]);
$_dept->setValue($data["dept_id"]);
$_shortcut->setValue($data['shortcut']);
$_status->setValue($data["is_active"]);
}
$this->addElements(array($_majorid, $_major_enname, $_major_khname, $_dept, $_shortcut, $_status));
return $this;
}
public function indexAction()
{
$formFilter = new Application_Form_Frmsearch();
$this->view->formFilter = $formFilter;
Application_Model_Decorator::removeAllDecorator($formFilter);
$list = new Application_Form_Frmlist();
$db = new Application_Model_DbTable_DbGlobal();
$vendorSql = "SELECT v.vendor_id, v.v_name,v.contact_name, v.phone, v.email, v.website,v.add_name\n\t\tFROM tb_vendor AS v WHERE 1 ";
/*$vendorSql = "SELECT v.vendor_id, v.v_name,v.contact_name, v.phone, v.email, v.website,v.add_name,
CONCAT(cur.Description, ' ', cur.Symbol) AS currency FROM tb_vendor AS v
INNER JOIN tb_currency AS cur ON cur.CurrencyId=v.CurrencyId ";*/
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
//echo $post["order"];
if ($post['name'] != '') {
$vendorSql .= " AND v.v_name LIKE '%" . trim($post['name']) . "%'";
}
if ($post['phone'] != '') {
$vendorSql .= " AND v.phone LIKE '%" . trim($post['phone']) . "%'";
$vendorSql .= " OR v.contact_name LIKE '%" . trim($post['phone']) . "%'";
}
if ($post['email'] != '') {
$vendorSql .= " AND v.email LIKE '%" . trim($post['email']) . "%'";
$vendorSql .= " OR v.website LIKE '%" . trim($post['email']) . "%'";
}
if ($post['address'] != '') {
$vendorSql .= " AND v.add_name LIKE '%" . trim($post['address']) . "%'";
}
}
$vendorSql .= " ORDER BY v.vendor_id DESC";
$rows = $db->getGlobalDb($vendorSql);
$columns = array("VENDOR_NAME_CAP", "CON_NAME_CAP", "CONTACT_NUM_CAP", "EMAIL_CAP", "WEBSITE_CAP", "ADDRESS_CAP");
$link = array('module' => 'purchase', 'controller' => 'vendor', 'action' => 'update-vendor');
$urlEdit = BASE_URL . "/purchase/vendor/update-vendor";
$this->view->list = $list->getCheckList(1, $columns, $rows, array('v_name' => $link, 'contact_name' => $link), $urlEdit);
}
public function indexAction()
{
$formFilter = new Application_Form_Frmsearch();
$frmfillter = $formFilter->customerSearch();
Application_Model_Decorator::removeAllDecorator($frmfillter);
$this->view->formFilter = $frmfillter;
$list = new Application_Form_Frmlist();
Application_Model_Decorator::removeAllDecorator($formFilter);
$db = new Application_Model_DbTable_DbGlobal();
$vendorSql = "SELECT c.customer_id, c.cust_name,c.contact_name, c.phone, c.email, c.website,\n\t\ttp.price_type_name ,c.is_active\n\t\tFROM tb_customer AS c,tb_price_type as tp\n\t\tWHERE tp.type_id=c.type_price AND c.cust_name!='' ";
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
if ($post['name'] != '') {
$vendorSql .= " AND c.cust_name LIKE '%" . trim($post['name']) . "%'";
}
if ($post['phone'] != '') {
$vendorSql .= " AND ( c.contact_name LIKE '%" . trim($post['phone']) . "%'";
$vendorSql .= " OR c.phone LIKE '%" . trim($post['phone']) . "%')";
}
if ($post['email'] != '') {
$vendorSql .= " AND c.email LIKE '%" . trim($post['email']) . "%'";
$vendorSql .= " OR c.website LIKE '%" . trim($post['email']) . "%'";
}
if ($post['type_price'] != '' and $post['type_price'] != 0) {
$vendorSql .= " AND tp.type_id = " . trim($post['type_price']);
}
}
$vendorSql .= " ORDER BY c.cust_name,c.is_active ";
$rows = $db->getGlobalDb($vendorSql);
$glClass = new Application_Model_GlobalClass();
$rows = $glClass->getImgActive($rows, BASE_URL, true);
$columns = array("CUSTOMER_NAME_CAP", "CON_NAME_CAP", "CONTACT_NUM_CAP", "EMAIL_CAP", "WEBSITE_CAP", "TYPE_PRICE", "STATUS_CAP");
$link = array('module' => 'sales', 'controller' => 'customer', 'action' => 'update-customer');
$urlEdit = BASE_URL . "/sales/customer/update-customer";
$this->view->list = $list->getCheckList(1, $columns, $rows, array('c.v_name' => $link, 'c.cust_name' => $link), $urlEdit);
}
public function getDistrictFilterAction()
{
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
$ids = $post["province_number"];
$sql = "SELECT p.id,d.pro_id,d.district_name FROM cms_district AS d,cs_provinces AS p \r\n\t\t\t\t\tWHERE d.pro_id = p.id AND d.pro_id = " . $ids;
$db = new Application_Model_DbTable_DbGlobal();
$row = $db->getGlobalDb($sql);
echo Zend_Json::encode($row);
exit;
}
}
public function itemalertAction()
{
$formFilter = new Product_Form_FrmProductFilter();
$this->view->formFilter = $formFilter;
Application_Model_Decorator::removeAllDecorator($formFilter);
$list = new Application_Form_Frmlist();
$db = new Application_Model_DbTable_DbGlobal();
$request = $this->getRequest();
$id = $request->getParam("id", NULL);
$sql = " SELECT p.pro_id, p.item_name, p.item_code,pm.min_qty,pm.message\n\t\tFROM tb_product AS p,tb_qty_setting AS pm\n\t\tWHERE p.pro_id = pm.pro_id ";
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
if ($post['pro_id'] != '' and $post['pro_id'] != 0) {
$sql .= " AND p.pro_id =" . trim($post['pro_id']);
}
if ($post['category_id'] != '' and $post['category_id'] != 0) {
$sql .= " AND p.cate_id = " . trim($post['category_id']);
}
}
$sql .= " ORDER BY p.pro_id";
$rows = $db->getGlobalDb($sql);
// $glClass = new Application_Model_GlobalClass();
// $rows = $glClass->getpublic($rows, BASE_URL, true);
$columns = array("ITEM_NAME_CAP", "item_code", "MIN_QTY_ALERT_CAP", "MSM_ALERT_CAP");
$link = array('module' => 'product', 'controller' => 'index', 'action' => 'update-itemalert');
$urlEdit = BASE_URL . "/product/index/update-itemalert";
$this->view->list = $list->getCheckList(1, $columns, $rows, array('item_name' => $link, 'Name' => $link), $urlEdit);
Application_Model_Decorator::removeAllDecorator($formFilter);
}
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 getuserss()
{
$db = new Application_Model_DbTable_DbGlobal();
$sql = "SELECT * FROM tb_user";
return $db->getGlobalDb($sql);
}
