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 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 editAction()
{
if($this->getRequest()->isPost()){
$calldata=$this->getRequest()->getPost();
$db_call = new Group_Model_DbTable_DbCallteral();
try{
$db = $db_call->updatecallteral($calldata);
Application_Form_FrmMessage::Sucessfull('EDIT_SUCCESS', self::REDIRECT_URL. '/callteral/index');
} catch (Exception $e) {
Application_Form_FrmMessage::message("INSERT_FAIL");
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
}
$id = $this->getRequest()->getParam('id');
$db = new Group_Model_DbTable_DbCallteral();
$row = $db->getecallteralbyid($id);
if(empty($id) OR empty($row) ){
Application_Form_FrmMessage::Sucessfull('RECORD_NOT_EXIST', self::REDIRECT_URL. '/callteral/index');
}
$this->view->client_id = $row['client_id'];
$this->view->branch_id = $row['branch_id'];
$this->view->rows = $db->getCallecteralDetailById($id);
$fm = new Group_Form_Frmcallterals();
$frm = $fm->FrmCallTeral($row);
Application_Model_Decorator::removeAllDecorator($frm);
$this->view->frm_callteral = $frm;
$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 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;
}
