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