예제 #1
0
 function rptLoanIncomeAction(){
 	$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();
 	}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->LoanCollectionco_list =$db->getALLLoanIcome($search);
 	$this->view->LoanFee_list =$db->getALLLFee($search);
 	
 	$this->view->list_end_date=$search;
 	$frm = new Loan_Form_FrmSearchGroupPayment();
 	$fm = $frm->AdvanceSearch();
 	Application_Model_Decorator::removeAllDecorator($fm);
 	$this->view->frm_search = $fm;
 }
예제 #2
0
 function rptLoanIncomeAction(){
 	$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->getALLLoanIcome($search);
  			$this->view->LoanFee_list =$db->getALLLFee($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->getALLLoanIcome(),$collumn);
 	}
 	}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->LoanCollectionco_list =$db->getALLLoanIcome($search);
			$this->view->LoanFee_list =$db->getALLLFee($search);
 	}
 	$this->view->list_end_date=$search;
 	$frm = new Loan_Form_FrmSearchGroupPayment();
 	$fm = $frm->AdvanceSearch();
 	Application_Model_Decorator::removeAllDecorator($fm);
 	$this->view->frm_search = $fm;
 }