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