public function indexAction(){
try{
$db = new Loan_Model_DbTable_DbLoanILPayment();
if($this->getRequest()->isPost()){
$formdata=$this->getRequest()->getPost();
$search = array(
'advance_search' => $formdata['advance_search'],
'client_name'=>$formdata['client_name'],
'start_date'=>$formdata['start_date'],
'end_date'=>$formdata['end_date'],
'status'=>$formdata['status'],
'branch_id' => $formdata['branch_id'],
'co_id' => $formdata['co_id'],
'paymnet_type' => $formdata["paymnet_type"],
);
}
else{
$search = array(
'adv_search' => '',
'client_name' => -1,
'start_date'=> date('Y-m-d'),
'end_date'=>date('Y-m-d'),
'branch_id' => -1,
'co_id' => -1,
'paymnet_type' => -1,
'status'=>"",);
}
$rs_rows= $db->getAllIndividuleLoan($search);
$result = array();
$list = new Application_Form_Frmtable();
$collumns = array("BRANCH_NAME","LOAN_NO","CUSTOMER_NAME","RECIEPT_NO","TOTAL_PRINCEPLE","TOTAL_INTEREST","PENALIZE AMOUNT","TOTAL_PAYMENT","RECEIVE_AMOUNT","PAY_DATE","DATE","CO_NAME",
);
$link=array(
'module'=>'loan','controller'=>'ilpayment','action'=>'edit',
);
$this->view->list=$list->getCheckList(0, $collumns, $rs_rows,array('team_group'=>$link,'loan_number'=>$link,'client_name'=>$link,'receipt_no'=>$link,'branch'=>$link));
}catch (Exception $e){
Application_Form_FrmMessage::message("Application Error");
echo $e->getMessage();
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
$frm = new Loan_Form_FrmSearchGroupPayment();
$fm = $frm->AdvanceSearch();
Application_Model_Decorator::removeAllDecorator($fm);
$this->view->frm_search = $fm;
}
public function indexAction(){
try{
$db = new Loan_Model_DbTable_DbGroupPayment();
if($this->getRequest()->isPost()){
$formdata=$this->getRequest()->getPost();
$search = array(
'advance_search' => $formdata['advance_search'],
'client_name' => $formdata['g_client_name'],
'start_date' => $formdata['start_date'],
'end_date' => $formdata['end_date'],
'status' => $formdata['status'],
'branch_id' => $formdata['branch_id'],
'co_id' => $formdata['co_id'],
);
}
else{
$search = array(
'adv_search' => '',
'client_name' => -1,
'start_date'=> date('Y-m-d'),
'end_date'=>date('Y-m-d'),
'branch_id' => -1,
'co_id' => -1,
'status'=>"",);
}
$rs_rows= $db->getAllGroupPPayment($search);
$list = new Application_Form_Frmtable();
$collumns = array("Branch","Recirpt No","Loan No","Group Client","Total Principle","Total Interest","Penalize Amount","Total Payment","Recieve Amount","Payment Date","Due Date","CO Name"
);
$link=array(
'module'=>'loan','controller'=>'grouppayment','action'=>'edit',
);
$this->view->list=$list->getCheckList(0, $collumns, $rs_rows,array('receipt_no'=>$link,'team_group'=>$link,'date'=>$link));
}catch (Exception $e){
Application_Form_FrmMessage::message("Application Error");
echo $e->getMessage();
Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage());
}
$frm = new Loan_Form_FrmSearchGroupPayment();
$fm = $frm->AdvanceSearch();
Application_Model_Decorator::removeAllDecorator($fm);
$this->view->frm_search = $fm;
}
function rptLoanExpectIncomeAction(){
if($this->getRequest()->isPost()){
$search = $this->getRequest()->getPost();
}else{
$search = array(
'adv_search' => '',
'client_name' => -1,
'start_date'=> date('Y-m-d'),
'end_date'=>date('Y-m-d'),
'branch_id' => -1,
'co_id' => -1,
'paymnet_type' => -1,
'status'=>"",);
}
$this->view->list_end_date=$search;
$db = new Report_Model_DbTable_DbLoan();
$this->view->LoanCollectionco_list =$db->getALLLoanExpectIncome($search);
$frm = new Loan_Form_FrmSearchGroupPayment();
$fm = $frm->AdvanceSearch();
Application_Model_Decorator::removeAllDecorator($fm);
$this->view->frm_search = $fm;
$key = new Application_Model_DbTable_DbKeycode();
$this->view->data=$key->getKeyCodeMiniInv(TRUE);
}