public function indexAction() { try{ if($this->getRequest()->isPost()){ $search = $this->getRequest()->getPost(); }else{ $search = array( 'branch_name'=>'', 'co_code'=>'', 'name_co'=>'', 'start_date'=> date('Y-m-01'), 'end_date'=>date('Y-m-d'), 'txt_search'=>'', 'status' => '', 'note'=>'' ); } $db = new Loan_Model_DbTable_DbTransferCoClient(); $rs_rows= $db->getAllTransferCO($search);//call frome model $list = new Application_Form_Frmtable(); $collumns = array("BRANCH_NAME","FROM_CO","TO_CO","DATE","NOTE","STATUS",); $link=array( 'module'=>'loan','controller'=>'transferco','action'=>'edit', ); $this->view->list=$list->getCheckList(0, $collumns,$rs_rows,array('loan_number'=>$link,'branch_name'=>$link,'client_name'=>$link,'from_coname'=>$link,'to_coname'=>$link)); }catch (Exception $e){ Application_Form_FrmMessage::message("Application Error"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } $fm = new Loan_Form_FrmTransferCoClient(); $frm = $fm->FrmTransfer(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_transfer = $frm; }
public function editAction() { $id = $this->getRequest()->getParam('id'); $db = new Loan_Model_DbTable_DbTransferCoClient(); if($this->getRequest()->isPost()){ $post = $this->getRequest()->getPost(); if(isset($post['btn_save'])){ $db->updatTransfer($post, $id); Application_Form_FrmMessage::Sucessfull("EDIT_SUCCESS","/loan/transferco-client/"); } } $data = $db->getAllinfoTransfer($id); $fm = new Loan_Form_FrmTransferCoClient(); if(empty($data)){ Application_Form_FrmMessage::Sucessfull("Can not get data","/loan/transferco-client/"); } $frm = $fm->FrmTransfer($data); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_transfer = $frm; }
public function editAction() { // action body $id = $this->getRequest()->getParam('id'); $db = new Loan_Model_DbTable_DbTransferCoClient(); if($this->getRequest()->isPost()){ $post = $this->getRequest()->getPost(); //print_r($post);exit(); if(isset($post['btn_save'])){ $db->updatTransferloan($post, $id); Application_Form_FrmMessage::Sucessfull("INSERT_SUCCESS","/loan/transfercoloand/"); } } //print_r($id);exit(); $data = $db->getAllinfoTransfer($id); $fm = new Loan_Form_FrmTransferCoClient(); $frm = $fm->FrmTransfer($data); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_transfer = $frm; }
public function FrmTransfer($data=null){ $request=Zend_Controller_Front::getInstance()->getRequest(); $db = new Application_Model_DbTable_DbGlobal(); $db_co = new Loan_Model_DbTable_DbTransferCoClient(); $branch_name = new Zend_Dojo_Form_Element_FilteringSelect('branch_name'); $branch_name->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'required' =>'true' )); $rows = $db->getAllBranchName(); $options=array(''=>"------Select Branch Name------"); if(!empty($rows)) foreach($rows AS $row){ $options[$row['br_id']]=$row['branch_namekh']; } $branch_name->setMultiOptions($options); $branch_name->setValue($request->getParam('branch_name')); $_date= new Zend_Dojo_Form_Element_DateTextBox('Date'); $_date->setAttribs(array( 'dojoType'=>'dijit.form.DateTextBox', 'class'=>'fullside', )); $_date->setValue(date('Y-m-d')); $co_code = new Zend_Dojo_Form_Element_FilteringSelect('co_code'); $co_code->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'onchange'=>"getClientInfo(1);" )); $_member = new Zend_Dojo_Form_Element_FilteringSelect('member'); $_member->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'onchange'=>'getClientInfo(1);' )); $db = new Application_Model_DbTable_DbGlobal(); $options = $db->getGroupCodeById(2,0,1); $_member->setMultiOptions($options); $_customer_code = new Zend_Dojo_Form_Element_FilteringSelect('customer_code'); $_customer_code->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'onchange'=>'getClientInfo(2);' )); $group_opt = $db->getGroupCodeById(1,0,1);//code,individual,option $_customer_code->setMultiOptions($group_opt); $row_co = $db->getAllCOName(); $options_co =array(''=>"------Select From CO ------"); if (!empty($row_co)) foreach ($row_co AS $row_cos){ $options_co[$row_cos['co_id']] = $row_cos['co_firstname']; } $co_code->setMultiOptions($options_co); $co_code->setValue($request->getParam('co_code')); $formc_co = new Zend_Dojo_Form_Element_FilteringSelect('name_co'); $formc_co->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'onchange'=>"getClientInfo(2);" )); $options = $db->getAllCOName(1); $options['']='---Select To CO---'; $formc_co->setMultiOptions($options); $formc_co->setValue($request->getParam('name_co')); $name_client = new Zend_Dojo_Form_Element_FilteringSelect('name_client'); $name_client->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'onchange'=>"getClientInfo(3);" )); $row_co = $db_co->getcoinfo(); $options_co =array(''=>"---Select Client Name---"); if (!empty($row_co)) foreach ($row_co AS $row_cos){ $options_co[$row_cos['member_id']] = $row_cos['client_name']; } $name_client->setMultiOptions($options_co); $code_client = new Zend_Dojo_Form_Element_FilteringSelect('code_client'); $code_client->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'onchange'=>"getClientInfo(4);" )); $row_number = $db_co->getcoinfo(); $options_numbers=array(''=>"---Select Client Code---"); if (!empty($row_number)) foreach ($row_number AS $row_client){ $options_numbers[$row_client['member_id']] = $row_client['client_code']; } $code_client->setMultiOptions($options_numbers); $loan_number= new Zend_Dojo_Form_Element_FilteringSelect('loan_number'); $loan_number->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'onchange'=>"getClientInfo(5);" )); $row_number = $db_co->getcoinfo(); $options_from =array(''=>"------Select Loan Number------"); if (!empty($row_number)) foreach ($row_number AS $row_numbers){ $options_from[$row_numbers['member_id']] = $row_numbers['loan_number']; } $loan_number->setMultiOptions($options_from); $loan_number->setValue($request->getParam("loan_number")); $loan_client = new Zend_Dojo_Form_Element_FilteringSelect('loan_client'); $loan_client->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'onchange'=>"getClientInfo(3);" )); $loan_clientgroup = $db_co->getcoinfo(); $options_loan_client =array(''=>"------Select Client Name------"); if (!empty($loan_clientgroup)) foreach ($loan_clientgroup AS $loan_clientgroups){ $options_loan_client[$loan_clientgroups['member_id']] = $loan_clientgroups['client_name']; } $loan_client->setMultiOptions($options_loan_client); $loan_client->setValue($request->getParam('loan_client')); $desc = new Zend_Dojo_Form_Element_TextBox('note'); $desc ->setAttribs(array( 'dojoType'=>'dijit.form.TextBox', 'class'=>'fullside', )); $desc->setValue($request->getParam('note')); $note = new Zend_Dojo_Form_Element_Textarea('Note'); $note ->setAttribs(array( 'dojoType'=>'dijit.form.SimpleTextarea', 'class'=>'fullside', 'required' =>true, 'style'=>'width:98%' )); $user_id = new Zend_Dojo_Form_Element_FilteringSelect('user_id'); $user_id->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', )); $row_froms = $db_co->getcoinfo(); $options_from =array(''=>"------Select------"); if (!empty($row_froms)) foreach ($row_froms AS $row_from){ } $user_id->setMultiOptions($options_from); $_arr = array(1=>$this->tr->translate("ACTIVE"),0=>$this->tr->translate("DACTIVE"),-1=>$this->tr->translate("ALL")); $_status = new Zend_Dojo_Form_Element_FilteringSelect("status"); $_status->setMultiOptions($_arr); $_status->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'required'=>'true', 'missingMessage'=>'Invalid Module!', 'class'=>'fullside')); $star_date = new Zend_Dojo_Form_Element_DateTextBox('start_date'); $star_date->setAttribs(array('dojoType'=>'dijit.form.DateTextBox')); $date = $request->getParam("start_date"); if(empty($date)){ $date = date('Y-m-01'); } $star_date->setValue($date); $_enddate = new Zend_Dojo_Form_Element_DateTextBox('end_date'); $_enddate->setAttribs(array('dojoType'=>'dijit.form.DateTextBox','required'=>'true', )); $date = $request->getParam("end_date"); if(empty($date)){ $date = date("Y-m-d"); } $_enddate->setValue($date); $_btn_search = new Zend_Dojo_Form_Element_SubmitButton('btn_search'); $_btn_search->setAttribs(array( 'dojoType'=>'dijit.form.Button', 'iconclass'=>'dijitIconSearch', )); if($data!=null){ $branch_name->setValue($data['branch_id']); $co_code->setValue($data['code_to']); $formc_co->setValue($data['to']); $name_client->setValue($data['client_id']); $code_client->setValue($data['client_id']); $_status->setValue($data['status']); $_date->setValue($data['date']); $note->setValue($data['note']); $loan_number->setValue($data['loan_id']); $loan_client->setValue($data['loan_id']); $_member->setValue($data['client_id']); $_member->setValue($data['client_id']); $_customer_code->setValue($data['client_id']); } $this->addElements(array($_customer_code,$_member,$_btn_search,$desc,$star_date,$_enddate,$loan_client,$loan_number,$_status,$branch_name,$_date,$formc_co,$name_client,$co_code,$code_client,$note,$user_id)); return $this; }