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 indexAction()
{
if ($this->getRequest()->isPost()) {
$db = new Group_Model_DbTable_DbClient();
$data = $this->getRequest()->getPost();
$_data['status'] = 1;
$id = $db->addClient($data);
print_r(Zend_Json::encode($id));
exit;
}
}
public function indexAction(){
try{
$db = new Group_Model_DbTable_DbClient();
if($this->getRequest()->isPost()){
$search=$this->getRequest()->getPost();
}
else{
$search = array(
'adv_search' => '',
'status' => -1);
}
$rs_rows= $db->getAllClients($search);
$result = array();
foreach ($rs_rows as $key =>$rs){
$result[$key]=array(
'client_id'=>$rs['client_id'],
'client_number'=>$rs['client_number'],
'name_kh'=>$rs['name_kh'],
'name_en'=>$rs['name_en'],
'sex'=>$this->sex[$rs['sex']],
'phone'=>$rs['phone'],
'house'=>$rs['house'],
'street'=>$rs['street'],
'village_name'=>$rs['village_name'],
'spouse_name'=>$rs['spouse_name'],
'user_name'=>$rs['user_name'],
'status'=>$rs['status'],
);
}
$glClass = new Application_Model_GlobalClass();
$rs_rows = $glClass->getImgActive($result, BASE_URL, true);
$list = new Application_Form_Frmtable();
$collumns = array("Client No","Client ID","Client Name(Kh)","Release Amount","Method","Time Collection","Zone","CO Name",
"By","status");
$link=array(
'module'=>'group','controller'=>'Client','action'=>'edit',
);
$this->view->list=$list->getCheckList(0, $collumns, array(),array('client_number'=>$link,'name_kh'=>$link,'name_en'=>$link));
}catch (Exception $e){
Application_Form_FrmMessage::message("Application Error");
echo $e->getMessage();
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
$frm = new Application_Form_FrmAdvanceSearch();
$frm = $frm->AdvanceSearch();
Application_Model_Decorator::removeAllDecorator($frm);
$this->view->frm_search = $frm;
}
public function getclientInfoAction()
{
if ($this->getRequest()->isPost()) {
$db = new Group_Model_DbTable_DbClient();
$data = $this->getRequest()->getPost();
$row = $db->getClientById($data['client_id']);
print_r(Zend_Json::encode($row));
exit;
}
}
function insertClientAction()
{
//At callecteral when click client
if ($this->getRequest()->isPost()) {
$data = $this->getRequest()->getPost();
$db = new Group_Model_DbTable_DbClient();
$row = $db->addIndividaulClient($data);
print_r(Zend_Json::encode($row));
exit;
}
}
