function updatecallteral($format) { $db = $this->getAdapter(); $db->beginTransaction(); try { $arr = array('branch_id' => $format['branch_id'], 'collecteral_code' => $format['cod_cal'], 'co_id' => $format['co_name'], 'client_id' => $format['client_name'], 'join_with' => $format['name'], 'relative' => $format['names'], 'guarantor' => $format['owner'], 'guarantor_relative' => $format['and_name'], 'note' => $format['note'], 'date' => $format['date_estate'], 'status' => $format['Stutas']); $this->_name = 'ln_client_callecteral'; $where = " id = " . $format['id']; $this->update($arr, $where); $this->_name = 'ln_client_callecteral_detail'; $where = 'is_return =0 AND client_coll_id = ' . $format['id']; $this->delete($where); $ids = explode(",", $format['record_row']); foreach ($ids as $i) { $code = Group_Model_DbTable_DbCallteral::getCallteralCode(); $array = array('client_coll_id' => $format['id'], 'collecteral_code' => $code, 'collecteral_type' => $format['collect_type' . $i], 'owner_type' => $format['owner_type' . $i], 'owner_name' => $format['owner_name' . $i], 'number_collecteral' => $format['number_collteral' . $i], 'issue_date' => $format['issue_date' . $i], 'status' => $format['Stutas'], 'note' => $format['note' . $i]); $this->insert($array); } $db->commit(); } catch (exception $e) { Application_Form_FrmMessage::message("Application Error"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); $db->rollBack(); } }
public function addAction(){ $id=$this->getRequest()->getParams('id'); $db = new Group_Model_DbTable_DbClient(); $id = $this->getRequest()->getParam("id"); $row = $db->getClientById($id); if(!empty($row)){ $row['co_id']=''; $row['guarantor']=$row['spouse_name']; $row['relative']=$row['relate_with']; $row['guarantor_relative']=$row['guarantor_with']; $row['note']=$row['remark']; $row['id']=''; $code = Group_Model_DbTable_DbCallteral::getCallteralCode(); $row['collecteral_code']=$code; } //$row = $db->addClient($id); //print_r($row); if($this->getRequest()->isPost()){ $calldata=$this->getRequest()->getPost(); $db_call = new Group_Model_DbTable_DbCallteral(); try { $db = $db_call->addcallteral($calldata); if(!empty($calldata['save_new'])){ Application_Form_FrmMessage::message('ការបញ្ចូលជោគជ័យ'); }else{ Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL . '/Callteral/add'); } } catch (Exception $e) { Application_Form_FrmMessage::message("Application Error"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } } $fm = new Group_Form_Frmcallterals(); $frm = $fm->FrmCallTeral($row); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm_callteral = $frm; $this->view->row=$row; // $frmpopup = new Application_Form_FrmPopupGlobal(); // $this->view->frmpupopclient = $frmpopup->frmPopupClient(); // $this->view->frmPopupCO = $frmpopup->frmPopupCO(); // $this->view->frmPopupZone = $frmpopup->frmPopupZone(); $db = new Application_Model_DbTable_DbGlobal(); $this->view->allclient = $db->getAllClient(); $this->view->allclient_number = $db->getAllClientNumber(); $db = new Application_Model_GlobalClass(); $this->view->collect_option = $db->getCollecteralOption(); $this->view->owner_type = $db->getCollecteralTypeOption(); }
public function FrmChangeCollteral($data = null) { $db = new Application_Model_DbTable_DbGlobal(); $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("ADVANCE_SEARCH"))); $_title->setValue($request->getParam("adv_search")); $_client_code = new Zend_Dojo_Form_Element_FilteringSelect('client_code'); $_client_code->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'onchange' => 'getOwnerInfo();')); $group_opt = $db->getGroupCodeById(1, 0, 1); //code,individual,option $_client_code->setMultiOptions($group_opt); $_client_code->setValue($request->getParam('client_code')); $_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")); $_btn_search = new Zend_Dojo_Form_Element_SubmitButton('btn_search'); $_btn_search->setAttribs(array('dojoType' => 'dijit.form.Button', 'iconclass' => 'dijitIconSearch')); $_branch_id = new Zend_Dojo_Form_Element_FilteringSelect('branch_id'); $_branch_id->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'required' => 'true', 'onchange' => 'filterClient();')); $rows = $db->getAllBranchName(); $options = array('' => "---Select Branch Name---"); if (!empty($rows)) { foreach ($rows as $row) { $options[$row['br_id']] = $row['branch_namekh']; } } $_branch_id->setMultiOptions($options); $_branch_id->setValue($request->getParam('branch_id')); $db = new Application_Model_DbTable_DbGlobal(); $co_name = new Zend_Dojo_Form_Element_FilteringSelect('co_name'); $rows = $db->getAllCOName(); $options = array('' => "------Select------", -1 => "Add New"); if (!empty($rows)) { foreach ($rows as $row) { $options[$row['co_id']] = $row['co_khname']; } } $co_name->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'onchange' => 'popupCheckCO();')); $Date = new Zend_Dojo_Form_Element_DateTextBox('date'); $Date->setAttribs(array('dojoType' => 'dijit.form.DateTextBox')); $number_code = new Zend_Dojo_Form_Element_NumberTextBox('number_code'); $number_code->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'required' => true)); $contract_code = new Zend_Dojo_Form_Element_NumberTextBox('contract_code'); $contract_code->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'required' => true)); $_code = new Zend_Dojo_Form_Element_NumberTextBox('code'); $_code->setAttribs(array('dojoType' => 'dijit.form.NumberTextBox', 'required' => true)); $clint_name = new Zend_Dojo_Form_Element_FilteringSelect('client_name'); $clint_name->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', 'onchange' => 'checkClientCode()')); $options = $db->getGroupCodeById(2, 0, 1); $clint_name->setMultiOptions($options); $owner = new Zend_Dojo_Form_Element_ValidationTextBox('owner'); $owner->setAttribs(array('dojoType' => 'dijit.form.ValidationTextBox')); $db = new Application_Model_DbTable_DbGlobal(); $collteral_type = new Zend_Dojo_Form_Element_FilteringSelect('collteral_type'); $collteral_type->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect')); $opt = $db->getCollteralType(1); $opt = array('' => '------Select------', 1 => 'ផ្ទាល់ខ្លួន', 2 => 'អ្នកធានាជំនួស'); $collteral_type->setMultiOptions($opt); $collteral_type->setValue($request->getParam('collteral_type')); $note = new Zend_Dojo_Form_Element_TextBox('note'); $note->setAttribs(array('dojoType' => 'dijit.form.TextBox')); $_note = new Zend_Dojo_Form_Element_TextBox('_note'); $_note->setAttribs(array('dojoType' => 'dijit.form.TextBox')); $_note->setValue('return back to client'); $Date = new Zend_Dojo_Form_Element_DateTextBox('date'); $Date->setAttribs(array('dojoType' => 'dijit.form.DateTextBox')); $Date->setValue(date('Y-m-d')); $stutas = new Zend_Dojo_Form_Element_FilteringSelect('Stutas'); $stutas->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect')); $options = array(1 => "ប្រើប្រាស់", 0 => "មិនប្រើប្រាស់"); $stutas->setMultiOptions($options); $cod_cal = new Zend_Dojo_Form_Element_TextBox('cod_cal'); $cod_cal->setAttribs(array('dojoType' => 'dijit.form.TextBox', 'readOnly' => 'readOnly', 'style' => 'color:red')); $code = Group_Model_DbTable_DbCallteral::getCallteralCode(); $cod_cal->setValue($code); $db = new Application_Model_DbTable_DbGlobal(); $from = new Zend_Dojo_Form_Element_FilteringSelect('from'); $from->setAttribs(array('dojoType' => 'dijit.form.FilteringSelect', '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', 'required' => true)); $opt = $db->getCollteralType(1); $to->setMultiOptions($opt); $to->setValue($request->getParam('to')); $receiver_name = new Zend_Dojo_Form_Element_ValidationTextBox('receiver_name'); $receiver_name->setAttribs(array('dojoType' => 'dijit.form.ValidationTextBox', 'required' => true)); $giver_name = new Zend_Dojo_Form_Element_ValidationTextBox('giver_name'); $giver_name->setAttribs(array('dojoType' => 'dijit.form.ValidationTextBox', 'required' => true)); $owner_name = new Zend_Dojo_Form_Element_TextBox('owner_name'); $owner_name->setAttribs(array('dojoType' => 'dijit.form.TextBox')); $collteral_id = new Zend_Form_Element_Hidden('collteral_id'); $collteral_id->setAttribs(array('dojoType' => 'dijit.form.TextBox')); $changecollteral_id = new Zend_Form_Element_Text('changecollteral_id'); $changecollteral_id->setAttribs(array('dojoType' => 'dijit.form.TextBox')); $from_date = new Zend_Dojo_Form_Element_DateTextBox('start_date'); $from_date->setAttribs(array('dojoType' => 'dijit.form.DateTextBox', 'onchange' => 'CalculateDate();')); $_date = $request->getParam("start_date"); if (empty($_date)) { $_date = date('Y-m-d'); } $from_date->setValue($_date); $to_date = new Zend_Dojo_Form_Element_DateTextBox('end_date'); $to_date->setAttribs(array('dojoType' => 'dijit.form.DateTextBox', 'required' => 'true')); $_date = $request->getParam("end_date"); if (empty($_date)) { $_date = date("Y-m-d"); } $to_date->setValue($_date); $id = new Zend_Form_Element_Hidden("id"); $receiver_name->setValue($this->getUserName()); if ($data != null) { $_branch_id->setValue($data['branch_id']); $giver_name->setValue($data['giver_name']); $receiver_name->setValue($data['receiver_name']); $note->setValue($data['note']); $Date->setValue($data['date']); $stutas->setValue($data['status']); $_note->setValue($data['return_note']); $id->setValue($data['id']); //$_client_code->setValue($data['owner_code_id']); //$clint_name->setValue($data['owner_id']); //$collteral_id->setValue($data['collteral_id']); //$changecollteral_id->setValue($data['id']); //$to->setValue($data['to_id']); //$collteral_type->setValue($data['collteral_type']); //$number_code->setValue($data['number_code']); // $owner_name->setValue($data['owner']); } $this->addElements(array($from_date, $to_date, $changecollteral_id, $collteral_id, $owner_name, $giver_name, $receiver_name, $_note, $from, $to, $_client_code, $_btn_search, $_status_search, $_title, $co_name, $Date, $number_code, $contract_code, $_code, $clint_name, $owner, $collteral_type, $note, $Date, $_branch_id, $id, $stutas, $cod_cal)); return $this; }
function addChangeCollteral($data){ $db=$this->getAdapter(); $db->beginTransaction(); try { $array=array( 'branch_id'=>$data['branch_id'], 'client_id'=>$data['client_name'], 'date'=>$data['date'], 'note'=>$data['note'], 'status'=>1,//$data['Stutas'], 'user_id'=>$this->getUserId() ); $change_id = $this->insert($array); $_arr=array( 'change_id'=>$change_id, 'branch_id'=>$data['branch_id'], 'client_id'=>$data['client_name'], 'giver_name'=>$data['giver_name'], 'receiver_name'=>$data['receiver_name'], 'date'=>$data['date'], 'user_id'=>$this->getUserId(), 'note'=>$data['_note'], ); $this->_name='ln_return_collteral'; $return_id = $this->insert($_arr); $ids = explode(',', $data['record_row']); foreach($ids as $i){ $this->_name='ln_client_callecteral_detail';//what relationship $array = array( 'note'=>'return by change collateral', 'is_return'=>1 ); $where = " id = ".$data['coid'.$i]; $this->update($array, $where); ////////////////////////////////add new more calleteral detail $this->_name='ln_changecollteral_detail'; $code = Group_Model_DbTable_DbCallteral::getCallteralCode(); $array = array( // 'client_coll'=>$data['client_coll'], // colllecteral_code 'client_coll_id'=>$data['coid'.$i], 'change_id'=>$change_id, 'from_collateral_type'=>$data['collect_type'.$i], 'from_owner_id'=>$data['owner_type'.$i], 'from_owner_name'=>$data['owner_name'.$i], 'from_number_collateral'=>$data['number_collteral'.$i], 'collateral_type'=>$data['tocollect_type'.$i], 'owner_id'=>$data['toowner_type'.$i], 'toowner_name'=>$data['toowner_name'.$i], 'number_collateral'=>$data['tonumber_collteral'.$i], 'issue_date'=>$data['issue_date'.$i], 'note'=>$data['tonote'.$i], // 'is_changed'=>1, ); $change_detail_id = $this->insert($array); $this->_name='ln_client_callecteral_detail';//what relationship $code = Group_Model_DbTable_DbCallteral::getCallteralCode(); $array = array( 'collecteral_code'=>$code, 'changecollteral_id'=>$change_detail_id, 'client_coll_id'=> $data['client_coll'], 'collecteral_type'=>$data['tocollect_type'.$i], 'owner_type'=>$data['toowner_type'.$i], 'owner_name'=>$data['toowner_name'.$i], 'number_collecteral'=>$data['tonumber_collteral'.$i], 'issue_date'=>$data['issue_date'.$i], 'note'=>$data['tonote'.$i], ); $this->insert($array); $this->_name='ln_return_collteral_detail'; $array=array( 'return_id'=>$return_id, 'collect_type'=>$data['collect_type'.$i], 'owner_type'=>$data['owner_type'.$i], 'owner_name'=>$data['owner_name'.$i], 'number_collteral'=>$data['number_collteral'.$i], 'issue_date'=>$data['issue_date'.$i] ); $this->insert($array); } $db->commit(); }catch (Exception $e){ $db->rollBack(); Application_Form_FrmMessage::message("INSERT_FALSE"); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } }
public function FrmCallTeral($data=null){ $db = new Application_Model_DbTable_DbGlobal(); $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_COLLTERAL") )); $_title->setValue($request->getParam("adv_search")); $_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")); $_btn_search = new Zend_Dojo_Form_Element_SubmitButton('btn_search'); $_btn_search->setAttribs(array( 'dojoType'=>'dijit.form.Button', 'iconclass'=>'dijitIconSearch' )); $_branch_id = new Zend_Dojo_Form_Element_FilteringSelect('branch_id'); $_branch_id->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'required' =>'true', 'Onchange'=>"filterClient();" )); $rows = $db->getAllBranchName(); $options=array(''=>"------Select Branch------"); if(!empty($rows)) foreach($rows AS $row){ $options[$row['br_id']]=$row['branch_namekh']; } $_branch_id->setMultiOptions($options); $_branch_id->setValue($request->getParam('branch_id')); $db = new Application_Model_DbTable_DbGlobal(); $co_name = new Zend_Dojo_Form_Element_FilteringSelect('co_name'); $rows = $db ->getAllCOName(); $options=array(''=>"------Select Staff------",-1=>"Add New"); if(!empty($rows))foreach($rows AS $row) $options[$row['co_id']]=$row['co_khname']; $co_name->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', 'onchange'=>'popupCheckCO();' )); $co_name->setMultiOptions($options); $co_name->setValue($request->getParam('co_name')); $getter_name = new Zend_Dojo_Form_Element_ValidationTextBox('getter_name'); $getter_name->setAttribs(array( 'dojoType'=>'dijit.form.ValidationTextBox', 'class'=>'fullside', 'required'=>true )); $giver_name = new Zend_Dojo_Form_Element_TextBox('giver_name'); $giver_name->setAttribs(array( 'dojoType'=>'dijit.form.TextBox', 'class'=>'fullside', 'required'=>true )); $Date=new Zend_Dojo_Form_Element_DateTextBox('date'); $Date->setAttribs(array( 'dojoType'=>'dijit.form.DateTextBox', 'class'=>'fullside' )); $_name=new Zend_Dojo_Form_Element_ValidationTextBox('name'); $_name->setAttribs(array( 'dojoType'=>'dijit.form.ValidationTextBox', 'class'=>'fullside' )); $relattive=new Zend_Dojo_Form_Element_ValidationTextBox('names'); $relattive->setAttribs(array( 'dojoType'=>'dijit.form.ValidationTextBox', 'class'=>'fullside' )); $guarantor=new Zend_Dojo_Form_Element_ValidationTextBox('owner'); $guarantor->setAttribs(array( 'dojoType'=>'dijit.form.ValidationTextBox', 'class'=>'fullside' )); $relative_guarantor=new Zend_Dojo_Form_Element_ValidationTextBox('and_name'); $relative_guarantor->setAttribs(array( 'dojoType'=>'dijit.form.ValidationTextBox', 'class'=>'fullside' )); $relative_guarantor_=new Zend_Dojo_Form_Element_ValidationTextBox('and_names'); $relative_guarantor_->setAttribs(array( 'dojoType'=>'dijit.form.ValidationTextBox', 'class'=>'fullside' )); // $db = new Application_Model_DbTable_DbGlobal(); // $collteral_type=new Zend_Dojo_Form_Element_FilteringSelect('collteral_type'); // $collteral_type->setAttribs(array( // 'dojoType'=>'dijit.form.FilteringSelect', // 'class'=>'fullside' // )); // $opt= $db->getCollteralType(1); // $collteral_type->setMultiOptions($opt); // $collteral_type->setValue($request->getParam('collteral_type')); $note=new Zend_Dojo_Form_Element_TextBox('note'); $note->setAttribs(array( 'dojoType'=>'dijit.form.TextBox', 'class'=>'fullside', )); $Date_estate=new Zend_Dojo_Form_Element_DateTextBox('date_estate'); $Date_estate->setAttribs(array( 'dojoType'=>'dijit.form.DateTextBox', 'class'=>'fullside' )); $Date_estate->setValue(date('Y-m-d')); $stutas = new Zend_Dojo_Form_Element_FilteringSelect('Stutas'); $stutas ->setAttribs(array( 'dojoType'=>'dijit.form.FilteringSelect', 'class'=>'fullside', )); $options= array(1=>"ប្រើប្រាស់",2=>"មិនប្រើប្រាស់"); $stutas->setMultiOptions($options); $cod_cal = new Zend_Dojo_Form_Element_TextBox('cod_cal'); $cod_cal ->setAttribs(array( 'dojoType'=>'dijit.form.TextBox', 'readOnly'=>'readOnly', 'class'=>'fullside', 'style'=>'color:red' )); $code = Group_Model_DbTable_DbCallteral::getCallteralCode(); $cod_cal->setValue($code); $from_date = new Zend_Dojo_Form_Element_DateTextBox('start_date'); $from_date->setAttribs(array('dojoType'=>'dijit.form.DateTextBox','required'=>'true', 'class'=>'fullside')); $_date = $request->getParam("start_date"); if(empty($_date)){ $_date = date('Y-m-d'); } $from_date->setValue($_date); $to_date = new Zend_Dojo_Form_Element_DateTextBox('end_date'); $to_date->setAttribs(array('dojoType'=>'dijit.form.DateTextBox','required'=>'true','class'=>'fullside', )); $_date = $request->getParam("end_date"); if(empty($_date)){ $_date = date("Y-m-d"); } $to_date->setValue($_date); $id = new Zend_Form_Element_Hidden("id"); if($data!=null){ $_branch_id->setValue($data['branch_id']); $cod_cal->setValue($data['collecteral_code']); $co_name->setValue($data['co_id']); $_name->setValue($data['join_with']); $relattive->setValue($data['relative']); $guarantor->setValue($data['guarantor']); $relative_guarantor->setValue($data['guarantor_relative']); $note->setValue($data['note']); // $Date_estate->setValue($data['date_registration']); $stutas->setValue($data['status']); $id->setValue($data['id']); } $this->addElements(array($from_date,$to_date,$_btn_search,$_status_search,$_title,$co_name,$getter_name,$giver_name,$Date, $_name,$relattive,$guarantor,$relative_guarantor,$note, $Date_estate,$_branch_id,$id,$stutas,$cod_cal)); return $this; }