function rptUnpaidLoanByCoAction(){
$db = new Report_Model_DbTable_DbLoan();
$key = new Application_Model_DbTable_DbKeycode();
$this->view->data=$key->getKeyCodeMiniInv(TRUE);
if($this->getRequest()->isPost()){
$search = $this->getRequest()->getPost();
if(isset($search['btn_submit'])){
$this->view->LoanCollectionco_list =$db->getAllLoanByCo($search);
}else {
$collumn = array("id","branch","co_name","receipt_no","loan_number","team_group","total_principal_permonth"
,"total_interest","penalize_amount","amount_payment","service_charge","date_pay");
$this->exportFileToExcel('ln_client_receipt_money',$db->getAllLoanByCo(),$collumn);
}
}else{
$search = array(
'advance_search' => '',
'client_name' => "",
'start_date'=> date('Y-m-d'),
'end_date'=>date('Y-m-d'),
'branch_id' => -1,
'co_id' => "",
'paymnet_type' => -1,
'status'=>"",);
$this->view->LoanCollectionco_list =$db->getAllLoanByCo($search);
}
$this->view->date_show=$search['end_date'];
$this->view->start_date=$search['start_date'];
$frm = new Loan_Form_FrmSearchGroupPayment();
$fm = $frm->AdvanceSearch();
Application_Model_Decorator::removeAllDecorator($fm);
$this->view->frm_search = $fm;
}
