public function addProgramName($data = null, $type = null) { $_title = new Zend_Dojo_Form_Element_TextBox('title'); $_title->setAttribs(array('dojoType' => $this->tvalidate, 'required' => 'true', 'class' => 'fullside')); $_db = new Application_Model_DbTable_DbGlobal(); if (!empty($type)) { $rows = $_db->getServiceType(2); } else { $rows = $_db->getServiceType(1); } //array_unshift($rows,array('id' => '-1',"title"=>$this->tr->translate("ADD")) ); $opt = ""; if (!empty($rows)) { foreach ($rows as $row) { $opt[$row['id']] = $row['title']; } } $_service_name = new Zend_Dojo_Form_Element_FilteringSelect("type"); $_service_name->setMultiOptions($opt); $_service_name->setAttribs(array('dojoType' => $this->filter, 'required' => 'true', 'class' => 'fullside')); $_desc = new Zend_Dojo_Form_Element_Textarea('desc'); $_desc->setAttribs(array('dojoType' => $this->tarea, 'class' => 'fullside', 'style' => 'width:96%;min-height:50px;')); $_status = new Zend_Dojo_Form_Element_FilteringSelect('status_program'); $_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); if (!empty($data)) { $_title->setValue($data['title']); $_desc->setValue($data['desc']); } $this->addElements(array($_service_name, $_title, $_desc, $_status)); return $this; }
public function editAction() { $db = new agreement_Model_DbTable_DbAgreement(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); try { $db->addAgreement($data); Application_Form_FrmMessage::Sucessfull("EDIT_SUCCESS", "/agreement/imdex/add"); } catch (Exception $e) { Application_Form_FrmMessage::message("Application Error"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } } $id = $this->getRequest()->getParam('id'); if (empty($id)) { $this->_redirect("/agreement"); } $this->view->row_agreement = $db->getAgreementById($id); print_r($db->getAgreementById($id)); $db = new Application_Model_DbTable_DbGlobal(); $this->view->rs_tax = $db->getAllTax(); $owner = $db->getAllNameOwner(); $this->view->country = $db->getAllCountry(); $this->view->rows_owner = $owner; $cus = new Booking_Model_DbTable_DbBooking(); $rows_cus = $cus->getIdNamecustomer(); $this->view->rows_cus = $rows_cus; $row_vehicle = $cus->getVehiclerefNo(); $this->view->row_vehicle = $row_vehicle; $db = new agreement_Model_DbTable_DbAgreement(); $this->view->rsbooking = $db->getAllBookingNumber(); }
public function FrmBrand($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]')); $parent = new Zend_Form_Element_Select("parent_id"); $parent->setAttribs(array('class' => 'select', 'style' => 'width:100%')); $category = $db->getAllBrand(); if (empty($category)) { $option_category = array('0' => 'No Brand To Select'); } else { $option_category = array('0' => 'Choose Brand'); foreach ($category as $row_cat) { $option_category[$row_cat["brand_id"]] = $row_cat["name_kh"]; } } $parent->setMultiOptions($option_category); $brand_en = new Zend_Form_Element_Text("name_en"); $brand_en->setAttribs(array('class' => 'validate[required]', 'placeholder' => ' Brand Name In English', "OnChange" => "GetBrandName(1)")); $brand_km = new Zend_Form_Element_Text("name_km"); $brand_km->setAttribs(array('class' => 'validate[required]', 'placeholder' => ' Brand Name In Khmer', "OnChange" => "GetBrandName(2)")); $icon = new Zend_Form_Element_File("icon"); $this->addElements(array($icon, $status, $brand_en, $brand_km, $parent)); if ($frm != "") { $parent->setValue($frm["parent_id"]); $brand_en->setValue($frm["name_en"]); $brand_km->setValue($frm["name_kh"]); $status->setValue($frm["status"]); } 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 addMeasure($data) { $db = new Application_Model_DbTable_DbGlobal(); $_arr = array("measure_name" => $data["measure_name"]); $result = $db->addRecord($_arr, "tb_measure"); return $result; }
public function FrmGeneraljurnal($data = null) { $Brance = new Zend_Dojo_Form_Element_FilteringSelect('branch_id'); $Brance->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'required' => true, 'onchange' => 'getJurnalcode();')); $db = new Application_Model_DbTable_DbGlobal(); $rows = $db->getAllBranchName(); $options = ''; if (!empty($rows)) { foreach ($rows as $row) { $options[$row['br_id']] = $row['branch_namekh']; } } $rows = $db->getAllBranchName(); $options = array('' => '---Select Branch---'); if (!empty($rows)) { foreach ($rows as $row) { $options[$row['br_id']] = $row['branch_namekh']; } } $Brance->setMultiOptions($options); $_currency_type = new Zend_Dojo_Form_Element_FilteringSelect('currency_type'); $_currency_type->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside')); $opt = $db->getVewOptoinTypeByType(15, 1, 3, 1); $_currency_type->setMultiOptions($opt); $_currency_type->setValue(2); $parent = new Zend_Dojo_Form_Element_FilteringSelect('parent'); $parent->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'required' => true, 'onchange' => 'getAllAccountNameByParents();')); $db = new Accounting_Model_DbTable_DbChartaccount(); $option = $db->getAllchartaccount(3, 1); $parent->setMultiOptions($option); $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_TextBox('journal_code'); $Account_Number->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside', 'readOnly' => 'readOnly', 'required' => 'true')); $invoice = new Zend_Dojo_Form_Element_TextBox('invoice'); $invoice->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside')); $Note = new Zend_Dojo_Form_Element_TextBox('note'); $Note->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside')); $Debit = new Zend_Dojo_Form_Element_NumberTextBox('debit'); $Debit->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside', 'required' => 1, 'readonly' => 'readonly')); // $Debit->setValue(0); $Credit = new Zend_Dojo_Form_Element_NumberTextBox('credit'); $Credit->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside', 'required' => 1, 'readonly' => 'readonly')); $id = new Zend_Form_Element_Hidden('id'); if ($data != null) { $id->setValue($data['id']); $Brance->setValue($data['branch_id']); $Account_Number->setValue($data['journal_code']); $invoice->setValue($data['receipt_number']); $_currency_type->setValue($data['currency_id']); $Note->setValue($data['note']); $Add_Date->setValue($data['date']); $Debit->setValue($data['debit']); $Credit->setValue($data['credit']); } // $Credit->setValue(0); $this->addElements(array($id, $invoice, $_currency_type, $parent, $Add_Date, $Account_Number, $Note, $Debit, $Credit, $Brance)); return $this; }
public function editAction() { if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); //print_r($data);exit(); try { $db_make = new Vehicle_Model_DbTable_DbMake(); if (!empty($data['save_close'])) { $db_make->updateMake($data); Application_Form_FrmMessage::Sucessfull($this->tr->translate("INSERT_SUCCESS"), self::REDIRECT_URL_ADD_CLOSE); } } catch (Exception $e) { Application_Form_FrmMessage::message($this->tr->translate("INSERT_FAIL")); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $id = $this->getRequest()->getParam('id'); $db_make = new Vehicle_Model_DbTable_DbMake(); $rows = $db_make->getMakeById($id); $this->view->row = $rows; $db = new Application_Model_DbTable_DbGlobal(); $status = $db->getViews(2); $this->view->status_view = $status; }
public function SelectItem() { $db = $this->getAdapter(); $user_info = new Application_Model_DbTable_DbGetUserInfo(); $result = $user_info->getUserInfo(); $db = new Application_Model_DbTable_DbGlobal(); $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"; return $rows = $db_rs->fetchAll($productSql); }
public function editAction() { $db_model = new Driverguide_Model_DbTable_DbDriver(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); try { $id = $db_model->updateDriver($data); Application_Form_FrmMessage::Sucessfull("EDIT_SUCCESSS", "/driverguide"); } catch (Exception $e) { Application_Form_FrmMessage::message("Application Error"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } } $db = new Application_Model_DbTable_DbGlobal(); $client_type = $db->getclientdtype(); array_unshift($client_type, array('id' => -1, 'name' => '---Add New ---')); $this->view->clienttype = $client_type; $dbpop = new Application_Form_FrmPopupGlobal(); $this->view->frm_popup_clienttype = $dbpop->frmPopupclienttype(); $id = $this->getRequest()->getParam("id"); $row = $db_model->getDriverById($id); $this->view->rs = $row; $fm = new Group_Form_FrmClient(); $frm = $fm->FrmaddGuide($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_client = $frm; }
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 function editAction() { if ($this->getRequest()->isPost()) { try { $_data = $this->getRequest()->getPost(); $_dbmodel = new Application_Model_DbTable_DbDept(); $_dbmodel->UpdateDepartment($_data); Application_Form_FrmMessage::Sucessfull("ការកៃប្រែដោយជោគជ័យ !", "/global/faculty/index"); //$this->_redirect(""); } catch (Exception $e) { $err = $e->getMessage(); Application_Form_FrmMessage::message("Application Error!"); Application_Model_DbTable_DbUserLog::writeMessageError($err); echo $e->getMessage(); exit; } } $id = $this->getRequest()->getParam("id"); $_db = new Application_Model_DbTable_DbGlobal(); $_row = $_db->getDeptById($id); $frm = new Application_Form_FrmOther(); $frm->FrmAddDept($_row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_dept = $frm; }
public function indexAction() { try { $db = new Other_Model_DbTable_DbZone(); if ($this->getRequest()->isPost()) { $search = $this->getRequest()->getPost(); } else { $search = array('adv_search' => '', 'search_status' => -1); } $rs_rows = $db->getAllZoneArea($search); $glClass = new Application_Model_GlobalClass(); $rs_rows = $glClass->getImgActive($rs_rows, BASE_URL, true); $list = new Application_Form_Frmtable(); $collumns = array("ZONE_NAME", "ZONE_NUMBER", "DATE", "STATUS", "BY"); $link = array('module' => 'other', 'controller' => 'zone', 'action' => 'edit'); $this->view->list = $list->getCheckList(0, $collumns, $rs_rows, array('zone_name' => $link, 'zone_num' => $link)); } catch (Exception $e) { Application_Form_FrmMessage::message("Application Error"); echo $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } $frm = new Other_Form_FrmZone(); $frm_co = $frm->FrmAddZone(); Application_Model_Decorator::removeAllDecorator($frm_co); $this->view->frm_zone = $frm_co; $db = new Application_Model_DbTable_DbGlobal(); $this->view->district = $db->getAllDistricts(); $this->view->commune_name = $db->getCommune(); $this->view->result = $search; }
function indexAction() { $dbbooking = new Application_Model_DbTable_Dbstuffrental(); $db_globle = new Application_Model_DbTable_DbGlobal(); if ($this->getRequest()->isPost()) { $post = $this->getRequest()->getPost(); if (isset($post["term_condiction"])) { $dbbooking->createSessionStuffBooking($post, 3); //print_r("test");exit(); $this->_redirect("stuffbooking/index"); } elseif (isset($post["confirm_book"])) { $dbbooking->createSessionStuffBooking($post, 4); $this->_redirect("stuffbooking/index"); } } $customer_session = new Zend_Session_Namespace('customer'); $user_session = $customer_session->customer_session; if (!empty($user_session)) { $customer_user_session = $user_session; $customer_user = $customer_session->customer_id; $this->view->user_name = $customer_session->customer_name; $this->view->user_info = $customer_session->user_info; } else { $customer_user_session = 0; } $db = new Application_Model_DbTable_Dbbookingtaxi(); $session = new Zend_Session_Namespace('stuffbooking'); $this->view->bookinginfo = $session; $this->view->producttermcomdiction = $db_globle->getAllParameter('producttermcomdiction'); $frmbooks = new Application_Form_FrmBooking(); $frmbooking = $frmbooks->FromBooking(); Application_Model_Decorator::removeAllDecorator($frmbooking); $this->view->frmbooking = $frmbooking; $this->view->user_session = $customer_user_session; }
function rptVillageAction(){ $db = new Report_Model_DbTable_DbParamater(); $this->view->village_list = $db->getAllVillage(); //print_r($db->getAllstaff()); $key = new Application_Model_DbTable_DbKeycode(); $this->view->data=$key->getKeyCodeMiniInv(TRUE); if($this->getRequest()->isPost()){ $search = $this->getRequest()->getPost(); // if(isset($search['btn_search'])){ //print_r($search);exit(); $this->view->village_list = $db->getAllVillage($search); }else{ $collumn = array("vill_id","village_namekh","village_name","displayby","commune_name","district_name","province_en_name","modify_date","status","user_name"); $this->exportFileToExcel('ln_village',$db->getAllVillage(),$collumn); } }else { $search = array('adv_search' => '', 'search_status' => -1, 'province_name'=>0, 'district_name'=>'', 'commune_name'=>''); } $frm = new Other_Form_FrmVillage(); $frms = $frm->FrmAddVillage(); Application_Model_Decorator::removeAllDecorator($frms); $this->view->frm_village= $frms; $db= new Application_Model_DbTable_DbGlobal(); $this->view->district = $db->getAllDistricts(); $this->view->commune_name = $db->getCommune(); $this->view->result = $search; }
public function editAction() { $db = new Other_Model_DbTable_DbVillage(); if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); try { $db->addVillage($_data); Application_Form_FrmMessage::Sucessfull("ការបញ្ចូលជោគជ័យ !", '/other/Village'); } catch (Exception $e) { Application_Form_FrmMessage::message("ការបញ្ចូលមិនជោគជ័យ"); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $id = $this->getRequest()->getParam("id"); $row = $db->getVillageById($id); $this->view->row = $row; if (empty($row)) { $this->_redirect('other/Village'); } $fm = new Other_Form_FrmVillage(); $frm = $fm->FrmAddVillage($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_village = $frm; $db = new Application_Model_DbTable_DbGlobal(); $this->view->district = $db->getAllDistricts(); $this->view->commune_name = $db->getCommune(); }
public function addNewAgent($data) { $db = new Application_Model_DbTable_DbGlobal(); $datainfo = array("name" => $data['agent_name'], "phone" => $data['phone'], "job_title" => $data['position'], "stock_id" => $data['location'], "description" => $data['desc']); $agent_id = $db->addRecord($datainfo, "tb_sale_agent"); return $agent_id; }
public function editAction() { $db_model = new Driverguide_Model_DbTable_Dbvehicleprice(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); try { $id = $db_model->updateVehicleRental($data); Application_Form_FrmMessage::Sucessfull("Edit Success", "/driverguide/vehicleprice"); } catch (Exception $e) { Application_Form_FrmMessage::message("Application Error"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } } $db = new Application_Model_GlobalClass(); $this->view->package_option = $db->getAllPackageDayOption(); $db = new Application_Model_DbTable_DbGlobal(); $this->view->rs_tax = $db->getAllTax(); $this->view->vehicle = $db_model->getVehecleName(); $id = $this->getRequest()->getParam("id"); $this->view->rows = $db_model->getVehiclePriceById($id); // print_r($db_model->getVehiclePriceById($id)); $this->view->vehicle_id = $id; // $db=new Vehicle_Model_DbTable_DbVehicle(); // $this->view->vehicle=$db->getVehicleById($id); }
function addTransactionJournal($data) { $arr = array('branch_id' => $data['branch_id'], 'client_id' => $data['client_id'], 'receipt_number' => $data['receipt_number'], 'date' => $data['date'], 'create_date' => date('Y-m-d'), 'note' => $data['note'], 'user_id' => $this->getUserId(), 'from_location' => $data['from_location'], 'receipt_number' => $data['receipt_number']); $id = $this->insert($arr); unset($arr); $this->_name = 'ln_journal_detail'; $acc_id = 1; $db_g = new Application_Model_DbTable_DbGlobal(); $db_g->getAccountBranchByOther($acc_id, $data['branch_id'], $data['currency_type'], $data['balance'], 1); //update data to server $arr = array('jur_id' => $id, 'branch_id' => $data['branch_id'], 'account_type' => 1, 'balance' => $data['balance'], 'account_id' => $acc_id, 'is_increase' => 1, 'currency_type' => $data['currency_type']); $this->insert($arr); $arr['is_increase'] = 0; $acc_id = 2; $arr['account_id'] = $acc_id; $arr['account_type'] = 2; $accs = $db_g->getAccountBranchByOther($arr['account_id'], $data['branch_id'], $data['currency_type'], $data['balance'], $arr['is_increase']); $this->insert($arr); if (!empty($data['loan_fee'])) { $arr['is_increase'] = 1; $arr['account_id'] = 2; $arr['note'] = 'Admin fee from disburse loan '; $this->insert($arr); $db_g->getAccountBranchByOther($arr['account_id'], $data['branch_id'], $data['currency_type'], $data['loan_fee'], $arr['is_increase']); $arr['is_increase'] = 1; $arr['account_id'] = 3; $this->insert($arr); $db_g->getAccountBranchByOther($arr['account_id'], $data['branch_id'], $data['currency_type'], $data['loan_fee'], $arr['is_increase']); } }
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 addClient($_data) { $photoname = str_replace(" ", "_", $_data['name_en'] . '-AGN') . '.jpg'; $upload = new Zend_File_Transfer(); $upload->addFilter('Rename', array('target' => PUBLIC_PATH . '/images/' . $photoname, 'overwrite' => true), 'photo'); $receive = $upload->receive(); if ($receive) { $_data['photo'] = $photoname; } else { $_data['photo'] = !empty($_data['id']) ? $_data['id'] : ""; } try { $db = new Application_Model_DbTable_DbGlobal(); $client_code = $db->getNewClientId(); $_arr = array('title' => $_data['title'], 'customer_code' => $client_code, 'first_name' => $_data['name_kh'], 'last_name' => $_data['name_en'], 'sex' => $_data['sex'], 'dob' => $_data['dob_client'], 'pob' => $_data['country'], 'occupation' => $_data['occupation'], 'nationality' => $_data['nationality'], 'company_name' => $_data['company_name'], 'customer_type' => $_data['customer_type'], 'photo' => $_data['photo'], 'note' => $_data['desc'], 'passport_name' => $_data['passport'], 'pass_issuedate' => $_data['pissue_date'], 'pass_expireddate' => $_data['pexpired_date'], 'card_name' => $_data['card_code'], 'card_issuedate' => $_data['cissue_date'], 'card_expireddate' => $_data['cexpired_date'], 'ftb' => $_data['ftb'], 'ftb_issuedate' => $_data['fissue_date'], 'ftb_expireddate' => $_data['fexpired_date'], 'phone' => $_data['phone'], 'email' => $_data['email'], 'fax' => $_data['fax'], 'group_num' => $_data['group_num'], 'house_num' => $_data['address'], 'street' => $_data['street'], 'commune' => $_data['commune'], 'district' => $_data["district"], 'province_id' => $_data['province'], 'balance' => $_data['balance'], 'address1' => $_data['address1'], 'address2' => $_data['address2'], 'i_city' => $_data['i_city'], 'i_zipcode' => $_data['i_zipcode'], 'i_state' => $_data['state'], 'country' => $_data['countries'], 'i_phone' => $_data['i_phone'], 'status' => $_data['status'], 'date' => date("Y-m-d")); if (!empty($_data['id'])) { $where = 'id = ' . $_data['id']; $this->update($_arr, $where); return $_data['id']; } else { return $this->insert($_arr); } } catch (Exception $e) { Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } }
function rptGeneralAction(){ // $fr=new Application_Form_FrmReportParameter(); // $form=$fr->getFormReport(array( // 'budget'=>-1, // 'division'=>-1, // 'fund_type'=>-1, // 'year'=>-1, // 'wa_type'=>-1, // 'fund_no'=>-1, // ),$this,true); // $this->view->filter = $form; $file='/budget/budget.html'; // $head=$report->getHeadBudgetList('project',date('Y')); $report=new Application_Model_DbTable_DbGlobal(); $content=$report->getContent($result_row); $param=array( 'division'=>1, 'budget'=>1, 'head'=>1, 'content'=>1); $db=new Application_Model_DbTable_DbGlobal(); $new=$db->setReportParam($param, $file); $this->view->file=$new; }
public function editAction() { $db_model = new Driverguide_Model_DbTable_Dbvehicleprice(); $id = $this->getRequest()->getParam('id'); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $db = new Driverguide_Model_DbTable_DbTaxiprice(); try { if (!empty($data['save_close'])) { $db->updateVehicletaxi($data); Application_Form_FrmMessage::Sucessfull("INSERT_SUCCESSS", "/driverguide/taxiprice"); } } catch (Exception $e) { //echo $e->getMessage();exit(); Application_Form_FrmMessage::message("Application Error"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } } $db = new Application_Model_GlobalClass(); $this->view->pro_option = $db->getAllLocationOption(); $db = new Application_Model_DbTable_DbGlobal(); $this->view->rs_tax = $db->getAllTax(); $this->view->vehicle = $db_model->getVehecleName(); $db = new Driverguide_Model_DbTable_DbTaxiprice(); $row = $this->view->row_taxi = $db->getVehicleTaxiById($id); //print_r($row);exit(); }
public function editAction() { if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); //print_r($data);exit(); try { $db_model = new Vehicle_Model_DbTable_DbSubModel(); if (isset($data['save_close'])) { $db_model->updateSubmodel($data); Application_Form_FrmMessage::Sucessfull($this->tr->translate("INSERT_SUCCESS"), self::REDIRECT_URL_CLOSE); } } catch (Exception $e) { Application_Form_FrmMessage::message($this->tr->translate("INSERT_FAIL")); $err = $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($err); } } $db = new Application_Model_DbTable_DbGlobal(); $status = $db->getViews(); $this->view->status_view = $status; // $db = new Vehicle_Model_DbTable_DbMake(); $model = $db->getAllMake(); array_unshift($model, array('id' => -1, 'name' => 'បន្ថែមអ្នកទទួលថ្មី')); $this->view->allmake = $model; $model = $db->getAllModels(); $this->view->allmodel = $model; $id = $this->getRequest()->getParam('id'); $sub_model = new Vehicle_Model_DbTable_DbSubModel(); $row = $sub_model->getSubModelById($id); $this->view->row = $row; }
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 FrmTeller($data = null) { $db = new Application_Model_DbTable_DbGlobal(); $_groupid = new Zend_Dojo_Form_Element_FilteringSelect('group_id'); $_groupid->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'onchange' => 'popupCheckClient();')); $bran_ = new Zend_Dojo_Form_Element_FilteringSelect('bran'); $bran_->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside')); $account_number = new Zend_Dojo_Form_Element_NumberTextBox('account_number'); $account_number->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside')); // $rows = $db ->getClientByType(1); // $options=""; // if(!empty($rows))foreach($rows AS $row){ // $options[$row['client_id']]=$row['name_en'].','.$row['province_en_name'].','.$row['district_name'].','.$row['commune_name'].','.$row['village_name']; // } // $_groupid->setMultiOptions($options); $_coid = new Zend_Dojo_Form_Element_FilteringSelect('co_id'); $_coid = new Zend_Dojo_Form_Element_FilteringSelect('co_id'); $rows = $db->getAllCOName(); $options = array('' => "------Select------", -1 => "Add New"); if (!empty($rows)) { foreach ($rows as $row) { $options[$row['co_id']] = $row['co_khname']; } } $_coid->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'onchange' => 'popupCheckCO();')); $_coid->setMultiOptions($options); $_priciple_amount = new Zend_Dojo_Form_Element_NumberTextBox('priciple_amount'); $_priciple_amount->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside')); $_loan_fee = new Zend_Dojo_Form_Element_NumberTextBox('loan_fee'); $_loan_fee->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside')); $_os_amount = new Zend_Dojo_Form_Element_NumberTextBox('os_amount'); $_os_amount->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside')); $_rate = new Zend_Dojo_Form_Element_NumberTextBox('total_interest'); $_rate->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside', 'required' => 'true')); // $value_interest = 2.5; // $_rate->setValue($value_interest); $_penalize_amount = new Zend_Dojo_Form_Element_NumberTextBox('penalize_amount'); $_penalize_amount->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside')); $_penalize_amount->setValue(0); $_total_payment = new Zend_Dojo_Form_Element_NumberTextBox('total_payment'); $_total_payment->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside', 'required' => 'true')); $_note = new Zend_Dojo_Form_Element_NumberTextBox('note'); $_note->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside', 'required' => 'true')); $cash_got = new Zend_Dojo_Form_Element_NumberTextBox('cash_got'); $cash_got->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside')); $cash_return = new Zend_Dojo_Form_Element_NumberTextBox('cash_return'); $cash_return->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside')); $_collect_date = new Zend_Dojo_Form_Element_DateTextBox('collect_date'); $_collect_date->setAttribs(array('dojoType' => 'dijit.form.DateTextBox', 'class' => 'fullside', 'required' => 'true')); $_date_paymented = new Zend_Dojo_Form_Element_DateTextBox('date_payment'); $_date_paymented->setAttribs(array('dojoType' => 'dijit.form.DateTextBox', 'class' => 'fullside', 'required' => 'true')); $invoice_number = new Zend_Dojo_Form_Element_ValidationTextBox('invoice_number'); $invoice_number->setAttribs(array('dojoType' => 'dijit.form.ValidationTextBox', 'class' => 'fullside', 'required' => 'true')); $c_date = date('Y-d-m'); $_collect_date->setValue($c_date); $this->addElements(array($invoice_number, $_date_paymented, $bran_, $account_number, $_groupid, $_coid, $_priciple_amount, $_loan_fee, $_os_amount, $_rate, $_penalize_amount, $_collect_date, $_total_payment, $cash_got, $cash_return, $_note)); return $this; }
public function Frmchengcallecterall() { $db = new Application_Model_DbTable_DbGlobal(); $request = Zend_Controller_Front::getInstance()->getRequest(); $branch = new Zend_Dojo_Form_Element_FilteringSelect('branch'); $branch->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'required' => true)); $rows = $db->getAllBranchName(); $options = ''; if (!empty($rows)) { foreach ($rows as $row) { $options[$row['br_id']] = $row['branch_namekh']; } } $branch->setMultiOptions($options); $db = new Application_Model_DbTable_DbGlobal(); $owner = new Zend_Dojo_Form_Element_FilteringSelect('owner'); $owner->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'onchange' => "popupCheckStaff();")); $options = $db->getGroupCodeById(2, 0, 1); $owner->setMultiOptions($options); $db = new Application_Model_DbTable_DbGlobal(); $owner_code = new Zend_Dojo_Form_Element_FilteringSelect('owner_code'); $group_opt = $db->getGroupCodeById(1, 0, 1); //code,individual,option $owner_code->setMultiOptions($group_opt); $owner_code->setValue($request->getParam('client_code')); $from = new Zend_Dojo_Form_Element_FilteringSelect('from'); $from->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'required' => true)); $from->setValue($request->getParam('from')); $opt = $db->getCollteralType(1); $from->setMultiOptions($opt); $to = new Zend_Dojo_Form_Element_FilteringSelect('to'); $to->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'required' => true)); $opt = $db->getCollteralType(1); $to->setMultiOptions($opt); $owners = new Zend_Dojo_Form_Element_TextBox('owners'); $owners->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside', 'required' => true)); $_personal = new Zend_Dojo_Form_Element_FilteringSelect('personal'); $_personal->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside')); $opt = array(1 => 'ផ្ទាល់ខ្លួន', 2 => 'អ្នកធានាជំនួស'); $_personal->setMultiOptions($opt); $_personal->setValue(1); $numbernote = new Zend_Dojo_Form_Element_NumberTextBox('numbernote'); $numbernote->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside', 'required' => true)); $date = new Zend_Dojo_Form_Element_DateTextBox('date'); $date->setAttribs(array('dojoType' => 'dijit.form.DateTextBox', 'class' => 'fullside', 'required' => true)); $date->setValue(date('Y-m-d')); $note = new Zend_Dojo_Form_Element_TextBox('note'); $note->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside', 'required' => true)); $status = new Zend_Dojo_Form_Element_FilteringSelect('status'); $status->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'required' => true)); $options = array(1 => "ប្រើប្រាស់", 2 => "មិនប្រើប្រាស់"); $status->setMultiOptions($options); $detial = new Zend_Dojo_Form_Element_TextBox('detial'); $detial->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'class' => 'fullside', 'required' => true)); $this->addElements(array($branch, $owner, $from, $to, $date, $note, $status, $owners, $owner_code, $detial, $_personal, $numbernote)); return $this; }
public function FrmAddExpense($data = null) { $request = Zend_Controller_Front::getInstance()->getRequest(); $_title = new Zend_Dojo_Form_Element_TextBox('adv_search'); $_title->setAttribs(array('dojoType' => $this->tvalidate, 'onkeyup' => 'this.submit()', 'placeholder' => $this->tr->translate("SEARCH SALARY EXPENSE"))); $_title->setValue($request->getParam("adv_search")); $_btn_search = new Zend_Dojo_Form_Element_SubmitButton('btn_search'); $_btn_search->setAttribs(array('dojoType' => 'dijit.form.Button', 'iconclass' => 'dijitIconSearch')); $account_name = new Zend_Dojo_Form_Element_ValidationTextBox('account_name'); $account_name->setAttribs(array('dojoType' => 'dijit.form.ValidationTextBox', 'class' => 'fullside', 'required' => true)); $for_date = new Zend_Dojo_Form_Element_FilteringSelect('for_date'); $for_date->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside')); $dg = new Application_Model_DbTable_DbGlobal(); $opt_month = $dg->getAllMonths(); $for_date->setMultiOptions($opt_month); $for_date->setValue(date('m')); // $for_date->setValue($request->getParam('for_date')); $for_date_search = new Zend_Dojo_Form_Element_FilteringSelect('for_date_search'); $for_date_search->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside')); $dg = new Application_Model_DbTable_DbGlobal(); $opt_month = $dg->getAllMonths(); $for_date_search->setMultiOptions($opt_month); $for_date_search->setValue($request->getParam('for_date_search')); $_Date = new Zend_Dojo_Form_Element_DateTextBox('Date'); $_Date->setAttribs(array('dojoType' => 'dijit.form.DateTextBox', 'required' => true, 'class' => 'fullside')); $_Date->setValue(date('Y-m-d')); $_status_search = new Zend_Dojo_Form_Element_FilteringSelect('status_search'); $_status_search->setAttribs(array('dojoType' => $this->filter)); $_status_opt = array(-1 => $this->tr->translate("ALL"), 1 => $this->tr->translate("ACTIVE"), 0 => $this->tr->translate("DACTIVE")); $_status_search->setMultiOptions($_status_opt); $_status_search->setValue($request->getParam("status_search")); $_stutas = new Zend_Dojo_Form_Element_FilteringSelect('Stutas'); $_stutas->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside')); $options = array(1 => "ប្រើប្រាស់", 2 => "មិនប្រើប្រាស់"); $_stutas->setMultiOptions($options); $currency_type = new Zend_Dojo_Form_Element_FilteringSelect('currency_type'); $currency_type->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside')); $options = array(1 => "រៀល", 2 => "ដុល្លារ", 3 => "បាត"); $currency_type->setMultiOptions($options); $_Description = new Zend_Dojo_Form_Element_Textarea('Description'); $_Description->setAttribs(array('dojoType' => 'dijit.form.SimpleTextarea', 'class' => 'fullside', 'style' => 'width:98%')); $total_amount = new Zend_Dojo_Form_Element_NumberTextBox('total_amount'); $total_amount->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'class' => 'fullside', 'required' => true)); $id = new Zend_Form_Element_Hidden("id"); if ($data != null) { $account_name->setValue($data['account_name']); $total_amount->setValue($data['total_amount']); $currency_type->setValue($data['currency_type']); $for_date->setValue($data['fordate']); $_Description->setValue($data['disc']); $_Date->setValue($data['date']); $_stutas->setValue($data['status']); $id->setValue($data['id']); } $this->addElements(array($account_name, $_Date, $_stutas, $_Description, $total_amount, $_title, $_btn_search, $_status_search, $for_date_search, $currency_type, $for_date, $id)); return $this; }
public function testAction() { $start = '2014-01-01'; $db = new Application_Model_DbTable_DbGlobal(); $rs = $db->checkHolidayExist(1, $start); echo $rs; // print_r($rs); // exit(); }
public function partnerinformation($data = null) { $_db = new Application_Model_DbTable_DbGlobal(); $id = new Zend_Form_Element_Hidden('id'); /* Form Elements & Other Definitions Here ... */ $request = Zend_Controller_Front::getInstance()->getRequest(); /* Form Elements & Other Definitions Here ... */ $accourn_number = new Zend_Dojo_Form_Element_TextBox('accourn_number'); $accourn_number->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'readOnly' => true)); $name_partner = new Zend_Dojo_Form_Element_FilteringSelect('name_partner'); $name_partner->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'class' => 'fullside', 'Onchange' => 'getPartner()', 'Required' => true)); $db = new Application_Model_DbTable_DbGlobal(); $opt = $db->getAllPartner(null, 1); $name_partner->setMultiOptions($opt); $name_partner->setValue($request->getParam('name_partner')); $moneyinaccount = new Zend_Dojo_Form_Element_TextBox('moneyinaccount'); $moneyinaccount->setAttribs(array('dojoType' => 'dijit.form.TextBox')); $account = new Zend_Dojo_Form_Element_NumberTextBox('account'); $account->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox')); $box1 = new Zend_Dojo_Form_Element_NumberTextBox('box1'); $box1->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox')); $box2 = new Zend_Dojo_Form_Element_NumberTextBox('box2'); $box2->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox')); $box3 = new Zend_Dojo_Form_Element_DateTextBox('box3'); $box3->setAttribs(array('dojoType' => 'dijit.form.DateTextBox')); $box4 = new Zend_Dojo_Form_Element_NumberTextBox('box4'); $box4->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox')); $usa = new Zend_Dojo_Form_Element_NumberTextBox('usa'); $usa->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'readOnly' => true)); $bathe = new Zend_Dojo_Form_Element_NumberTextBox('bathe'); $bathe->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'readOnly' => true)); $reil = new Zend_Dojo_Form_Element_NumberTextBox('reil'); $reil->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'readOnly' => true)); $creat_date = new Zend_Dojo_Form_Element_DateTextBox('creat_date'); $creat_date->setAttribs(array('dojoType' => 'dijit.form.DateTextBox')); $creat_date->setValue(date('Y-m-d')); $db_Deposite = new Partner_Model_DbTable_DbDeposite(); $invoices_num = $db_Deposite->getAutonumber(); $num_invoice = new Zend_Dojo_Form_Element_TextBox('num_invoice'); $num_invoice->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'readOnly' => true, 'style' => 'color:red')); $num_invoice->setValue($invoices_num); $id = new Zend_Form_Element_Hidden('id'); if ($data != null) { $name_partner->setValue($data['partner_id']); $accourn_number->setValue($data['account_no']); $creat_date->setValue($data['date']); $moneyinaccount->setValue($data['note']); $num_invoice->setValue($data['invoice']); $id->setValue($data['id']); $usa->setValue($data['cash_dollar']); $reil->setValue($data['cash_riel']); $bathe->setValue($data['cash_bath']); } $this->addElements(array($accourn_number, $name_partner, $moneyinaccount, $account, $box1, $box2, $box3, $box4, $bathe, $usa, $creat_date, $reil, $id, $num_invoice)); return $this; }
public function updateSaleAgentAction() { $session_stock = new Zend_Session_Namespace('stock'); $id = $this->getRequest()->getParam('id') ? $this->getRequest()->getParam('id') : '0'; $db = new Application_Model_DbTable_DbGlobal(); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); if ($data["submit_update"]) { $update_agent = new sales_Model_DbTable_DbSalesAgent(); $update_agent->updateSalesAgent($data); $this->_redirect("sales/sale-agent/index"); } else { $this->_redirect("sales/sale-agent/index"); } } // show form with value $sql = "SELECT * FROM tb_sale_agent where agent_id=" . $id; $rows = $db->getGlobalDbRow($sql); $formAgent = new sales_Form_FrmStock(null); $formShowAgent = $formAgent->showSaleAgentForm($rows, $session_stock->stockID); Application_Model_Decorator::removeAllDecorator($formShowAgent); $this->view->form_agent = $formShowAgent; $formpopup = new Application_Form_FrmPopup(null); //for add location $formAdd = $formpopup->popuLocation(null); Application_Model_Decorator::removeAllDecorator($formAdd); $this->view->form_addstock = $formAdd; }