1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / startupfintech / application / controllers /
Filename : Admin.php
back
<?php
if(!defined('BASEPATH')) exit('No direct script access allowed');
class Admin extends CI_Controller
{
    public function __construct(){
        parent::__construct();
        $this->load->model('common_model');
		
        $this->load->model('loan_category_model');
        $this->load->model('enquiry_model');
        $this->load->model('leads_model');
        $this->load->model('customer_model');
        $this->load->model('staff_model');
        $this->load->model('loan_model');
		
		$isSessionAlive=$this->session->userdata('is_logged_in');
		if(!$isSessionAlive || $isSessionAlive==NULL){
			redirect('login');
		}
    }
	
	public function loan_calculator(){
		$data['page_title']	= 'Loan Calculatoe';
		$data['inner_view']	= 'loan_calculator';
        $this->load->view('includes/web_view',$data);
	}
	
	public function loan_category(){
		$data['page_title']	= 'Loan Category';
		$data['inner_view']	= 'loan_category';
        $this->load->view('includes/web_view',$data);
	}
	
	public function list_loan_category()
	{
		$data = $row = array();
		$resultData 	= $this->loan_category_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($resultData as $row){
			$i++;
			
			$action = "<button type='button' data-id='".$row->id."' data-name='".$row->category_name."' data-percent='".$row->category_percent."' class='btn btn-primary btn-sm edit_data'><i class='fa fa-edit'></i></button>&nbsp;";
			$action.= "<button type='button' data-id='".$row->id."' class='btn btn-danger btn-sm delete_data'><i class='fa fa-trash'></i></button>&nbsp;";
			
			$data[] = array($i, $row->category_name, $row->category_percent. "%", $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->loan_category_model->countAll($_POST),
			"recordsFiltered" 	=> $this->loan_category_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function submit_loan_category(){
		$row_id			= $this->input->post('row_id');
		
		$data_arr 	=	array(
			'category_name' 	=> $this->input->post('category_name'),
			'category_percent' 	=> $this->input->post('category_percent'),
		);
		
		if(empty($row_id)){
			$data_arr['created_at'] 		= CURRENT_TIME;
			$data_arr['created_by'] 		= $this->session->userdata('user_id');
			
			$this->common_model->insert('tbl_loan_category',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Category Added Successfully',
			);
		}else{
			$data_arr['updated_at'] 		= CURRENT_TIME;
			$data_arr['updated_by'] 		= $this->session->userdata('user_id');
			
			$where = "id='$row_id'";
			$this->common_model->update('tbl_loan_category',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Category Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	//Enquiry
	public function enquiry(){
		$data['page_title']		= 'Enquiry';
		$data['inner_view']		= 'enquiry';
		$data['list_enquiry']	= $this->db->select('*')->order_by('category_name', 'ASC')->get('tbl_loan_category')->result();
        $this->load->view('includes/web_view',$data);
	}
	
	public function list_enquiry()
	{
		$data = $row = array();
		$resultData 	= $this->enquiry_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($resultData as $row){
			$i++;
			
			$action = "<button type='button' data-id='".$row->id."' class='btn btn-primary btn-sm convert_data'><i class='fa fa-refresh'></i></button>&nbsp;";
			$action.= "<button type='button' data-id='".$row->id."' class='btn btn-danger btn-sm delete_data'><i class='fa fa-trash'></i></button>&nbsp;";
			
			$created_at = date('d-m-Y h:i a',strtotime($row->created_at));
			
			$data[] = array($i, $row->enq_name, $row->enq_email_address, $row->enq_mobile_no, $row->enq_type, $created_at, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->enquiry_model->countAll($_POST),
			"recordsFiltered" 	=> $this->enquiry_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function submit_enquiry(){
		$row_id			= $this->input->post('row_id');
		
		$data_arr 	=	array(
			'enq_name' 				=> $this->input->post('enq_name'),
			'enq_email_address' 	=> $this->input->post('enq_email_address'),
			'enq_mobile_no' 		=> $this->input->post('enq_mobile_no'),
			'enq_type' 				=> $this->input->post('enq_type'),
			'enq_description' 		=> $this->input->post('enq_description'),
		);

		$data_arr['created_at'] = CURRENT_TIME;
		$data_arr['created_by'] = $this->session->userdata('user_id');
		
		$this->common_model->insert('tbl_enquiry',$data_arr);
		$output = array(
			'status'	=> 'Success',
			'msg'		=> 'Enquiry Added Successfully',
		);
		echo json_encode($output);
	}
	
	//Leads
	public function leads(){
		$data['page_title']		= 'Leads';
		$data['inner_view']		= 'leads';
		$data['list_enquiry']	= $this->db->select('*')->order_by('category_name', 'ASC')->get('tbl_loan_category')->result();
        $this->load->view('includes/web_view',$data);
	}
	
	public function submit_leads(){
		$row_id			= $this->input->post('row_id');
		
		$data_arr 	=	array(
			'lead_name' 			=> $this->input->post('lead_name'),
			'lead_email_address'	=> $this->input->post('lead_email_address'),
			'lead_mobile_no'	 	=> $this->input->post('lead_mobile_no'),
			'lead_loan_category'	=> $this->input->post('lead_loan_category'),
			'lead_loan_amount'	 	=> $this->input->post('lead_loan_amount'),
			'lead_loan_tenure'	 	=> $this->input->post('lead_loan_tenure'),
			'lead_status'			=> $this->input->post('lead_status'),
			'lead_lost_status'	 	=> $this->input->post('lead_lost_status'),
			'lead_description'		=> $this->input->post('lead_description'),
		);
		
		if(empty($row_id)){
			$data_arr['created_at'] = CURRENT_TIME;
			$data_arr['created_by'] = $this->session->userdata('user_id');
			
			$this->common_model->insert('tbl_leads',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Lead Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = CURRENT_TIME;
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			
			$where = "id='$row_id'";
			$this->common_model->update('tbl_leads',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Lead Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function list_leads()
	{
		$data = $row = array();
		$resultData 	= $this->leads_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($resultData as $row){
			$i++;
			
			$action = "<button type='button' data-id='".$row->id."' class='btn btn-primary btn-sm edit_data'><i class='fa fa-edit'></i></button>&nbsp;";
			$action.= "<button type='button' data-id='".$row->id."' class='btn btn-danger btn-sm delete_data'><i class='fa fa-trash'></i></button>&nbsp;";
			
			$loan = 'Amount : <i class="fas fa-rupee-sign"></i> '.number_format($row->lead_loan_amount)."<br/>";
			$loan.= 'Tenure : '.$row->lead_loan_tenure." Months";
			
			$created_at = date('d-m-Y h:i a',strtotime($row->created_at));
			
			$status = "<span class='badge badge-info'>New</span>";
			if($row->lead_status==2){
				$status = "<span class='badge badge-success'>Lead Win</span>";
			}else if($row->lead_status==3){
				$status = "<span class='badge badge-danger'>Lead Lost</span>";
			}
				
			
			$data[] = array($i, $row->lead_name, $row->lead_email_address, $row->lead_mobile_no, $loan, $status, $created_at, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->leads_model->countAll($_POST),
			"recordsFiltered" 	=> $this->leads_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function edit_leads(){
		$keys		= $this->input->post("keys");
		$result 	= $this->db->select('*')->where('id', $keys)->get('tbl_leads')->row();
		
		echo json_encode($result);
	}
	
	//Customer
	public function customer(){
		$data['page_title']	= 'Customer';
		$data['inner_view']	= 'customer';
        $this->load->view('includes/web_view',$data);
	}
	
	public function list_customer()
	{
		$data = $row = array();
		$resultData 	= $this->customer_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($resultData as $row){
			$i++;
			
			$action = "<button type='button' data-id='".$row->id."' class='btn btn-primary btn-sm edit_data'><i class='fa fa-edit'></i></button>&nbsp;";
			$action.= "<button type='button' data-id='".$row->id."' class='btn btn-danger btn-sm delete_data'><i class='fa fa-trash'></i></button>&nbsp;";
			
			$created_at = date('d-m-Y h:i a',strtotime($row->created_at));
			$data[] = array($i, $row->customer_name, $row->customer_email_address, $row->customer_mobile_no, $row->customer_city, $created_at, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->customer_model->countAll($_POST),
			"recordsFiltered" 	=> $this->customer_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function submit_customer(){
		$row_id			= $this->input->post('row_id');
		
		$data_arr 	=	array(
			'customer_name' 			=> $this->input->post('customer_name'),
			'customer_email_address' 	=> $this->input->post('customer_email_address'),
			'customer_mobile_no' 		=> $this->input->post('customer_mobile_no'),
			'customer_address' 			=> $this->input->post('customer_address'),
			'customer_city' 			=> $this->input->post('customer_city'),
			'customer_state' 			=> $this->input->post('customer_state'),
			'customer_pin_code' 		=> $this->input->post('customer_pin_code'),
			'customer_description' 		=> $this->input->post('customer_description'),
		);
		
		if(empty($row_id)){
			$data_arr['created_at'] = CURRENT_TIME;
			$data_arr['created_by'] = $this->session->userdata('user_id');
			
			$this->common_model->insert('tbl_customer',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Customer Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = CURRENT_TIME;
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			
			$where = "id='$row_id'";
			$this->common_model->update('tbl_customer',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Customer Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function edit_customer(){
		$keys		= $this->input->post("keys");
		$result 	= $this->db->select('*')->where('id', $keys)->get('tbl_customer')->row();
		
		echo json_encode($result);
	}
	
	//Staff
	public function staff(){
		$data['page_title']	= 'Staff';
		$data['inner_view']	= 'staff';
        $this->load->view('includes/web_view',$data);
	}
	
	public function list_staff()
	{
		$data = $row = array();
		$resultData 	= $this->staff_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($resultData as $row){
			$i++;
			
			$action = "<button type='button' data-id='".$row->id."' class='btn btn-primary btn-sm edit_data'><i class='fa fa-edit'></i></button>&nbsp;";
			$action.= "<button type='button' data-id='".$row->id."' class='btn btn-danger btn-sm delete_data'><i class='fa fa-trash'></i></button>&nbsp;";
			
			$created_at = date('d-m-Y h:i a',strtotime($row->created_at));
			$data[] = array($i, $row->staff_name, $row->staff_email_address, $row->staff_mobile_no, $row->staff_city, $created_at, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->staff_model->countAll($_POST),
			"recordsFiltered" 	=> $this->staff_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function submit_staff(){
		$row_id			= $this->input->post('row_id');
		
		$data_arr 	=	array(
			'staff_name' 			=> $this->input->post('staff_name'),
			'staff_email_address' 	=> $this->input->post('staff_email_address'),
			'staff_mobile_no' 		=> $this->input->post('staff_mobile_no'),
			'staff_address' 		=> $this->input->post('staff_address'),
			'staff_city' 			=> $this->input->post('staff_city'),
			'staff_state' 			=> $this->input->post('staff_state'),
			'staff_pin_code' 		=> $this->input->post('staff_pin_code'),
			'staff_description' 	=> $this->input->post('staff_description'),
		);
		
		if(empty($row_id)){
			$data_arr['created_at'] = CURRENT_TIME;
			$data_arr['created_by'] = $this->session->userdata('user_id');
			
			$this->common_model->insert('tbl_staff',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Staff Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = CURRENT_TIME;
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			
			$where = "id='$row_id'";
			$this->common_model->update('tbl_staff',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Staff Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function edit_staff(){
		$keys		= $this->input->post("keys");
		$result 	= $this->db->select('*')->where('id', $keys)->get('tbl_staff')->row();
		
		echo json_encode($result);
	}
	
	//Loan
	public function loan(){
		$data['page_title']	= 'Loan';
		$data['inner_view']	= 'loan';
        $this->load->view('includes/web_view',$data);
	}
	
	public function new_loan(){
		$data['page_title']	= 'New Loan';
		$data['inner_view']	= 'loan_new';
        $this->load->view('includes/web_view',$data);
	}
	
	
	
	public function submit_loan(){
		
		$loan_id		= $this->input->post('loan_id');
		
		$data_arr 	=	array(
			'customer_name' 				=> $this->input->post('customer_name'),
			'customer_email' 				=> $this->input->post('customer_email'),
			'customer_phone' 				=> $this->input->post('customer_phone'),
			'customer_community_address' 	=> $this->input->post('customer_community_address'),
			'customer_community_city' 		=> $this->input->post('customer_community_city'),
			'customer_community_state' 		=> $this->input->post('customer_community_state'),
			'customer_community_pincode' 	=> $this->input->post('customer_community_pincode'),
			'customer_perment_address' 		=> $this->input->post('customer_perment_address'),
			'customer_perment_city' 		=> $this->input->post('customer_perment_city'),
			'customer_perment_state' 		=> $this->input->post('customer_perment_state'),
			'customer_perment_pincode' 		=> $this->input->post('customer_perment_pincode'),
			'business_applicant_name' 		=> $this->input->post('business_applicant_name'),
			'business_co_applicant_name' 	=> $this->input->post('business_co_applicant_name'),
			'business_gst_no' 				=> $this->input->post('business_gst_no'),
			'business_msme' 				=> $this->input->post('business_msme'),
			'business_threeb_no' 			=> $this->input->post('business_threeb_no'),
			'applicant_name' 				=> $this->input->post('applicant_name'),
			'applicant_email_address' 		=> $this->input->post('applicant_email_address'),
			'applicant_mobile_no' 			=> $this->input->post('applicant_mobile_no'),
			'applicant_address' 			=> $this->input->post('applicant_address'),
			'applicant_city' 				=> $this->input->post('applicant_city'),
			'applicant_state' 				=> $this->input->post('applicant_state'),
			'applicant_pincode' 			=> $this->input->post('applicant_pincode'),
			'guarantor_name' 				=> $this->input->post('guarantor_name'),
			'guarantor_email_address' 		=> $this->input->post('guarantor_email_address'),
			'guarantor_mobile_no' 			=> $this->input->post('guarantor_mobile_no'),
			'guarantor_address' 			=> $this->input->post('guarantor_address'),
			'guarantor_city' 				=> $this->input->post('guarantor_city'),
			'guarantor_state' 				=> $this->input->post('guarantor_state'),
			'guarantor_pincode' 			=> $this->input->post('guarantor_pincode'),
			'bank_name' 					=> $this->input->post('bank_name'),
			'bank_number' 					=> $this->input->post('bank_number'),
			'bank_ifsc_code' 				=> $this->input->post('bank_ifsc_code'),
			'bank_branch_name' 				=> $this->input->post('bank_branch_name'),
			'loan_amount' 					=> $this->input->post('loan_amount'),
			'loan_tenure' 					=> $this->input->post('loan_tenure'),
			'loan_type' 					=> $this->input->post('loan_type'),
			'rate_intrest' 					=> $this->input->post('rate_intrest'),
		);
		
		
		$test_con 	 = 0;	
		$small_image = "";
		if(isset($_FILES["customer_address_proof"]["name"]) && !empty($_FILES["customer_address_proof"]["name"])){
    		$image_info = getimagesize($_FILES["customer_address_proof"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='customer_address_proof';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["customer_address_proof"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['customer_address_proof']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = CUSTOMER_DETAILS_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP|pdf';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('customer_address_proof')){
    			$test_con   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_con       = 0;
    			$data_arr['customer_address_proof']    = $data['upload_data']['file_name'];
    		}
        }
		
		$test_cons 	 = 0;	
		$small_image = "";
		if(isset($_FILES["customer_own_house_proof"]["name"]) && !empty($_FILES["customer_own_house_proof"]["name"])){
    		$image_info = getimagesize($_FILES["customer_own_house_proof"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='customer_own_house_proof';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["customer_own_house_proof"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['customer_own_house_proof']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = CUSTOMER_DETAILS_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP|pdf';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('customer_own_house_proof')){
    			$test_cons   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_cons     = 0;
    			$data_arr['customer_own_house_proof']    = $data['upload_data']['file_name'];
    		}
        }
		
		$test_cons 	 = 0;	
		$small_image = "";
		if(isset($_FILES["customer_bussiness_proof"]["name"]) && !empty($_FILES["customer_bussiness_proof"]["name"])){
    		$image_info = getimagesize($_FILES["customer_bussiness_proof"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='customer_bussiness_proof';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["customer_bussiness_proof"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['customer_bussiness_proof']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = CUSTOMER_DETAILS_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP|pdf';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('customer_bussiness_proof')){
    			$test_cons   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_cons     = 0;
    			$data_arr['customer_bussiness_proof']    = $data['upload_data']['file_name'];
    		}
        }
		
		$test_cons 	 = 0;	
		$small_image = "";
		if(isset($_FILES["business_bank_statement"]["name"]) && !empty($_FILES["business_bank_statement"]["name"])){
    		$image_info = getimagesize($_FILES["business_bank_statement"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='business_bank_statement';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["business_bank_statement"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['business_bank_statement']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = BUSINESS_DETAILS_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP|pdf';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('business_bank_statement')){
    			$test_cons   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_cons     = 0;
    			$data_arr['business_bank_statement']    = $data['upload_data']['file_name'];
    		}
        }
		
		$test_cons 	 = 0;	
		$small_image = "";
		if(isset($_FILES["business_itr1"]["name"]) && !empty($_FILES["business_itr1"]["name"])){
    		$image_info = getimagesize($_FILES["business_itr1"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='business_itr1';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["business_itr1"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['business_itr1']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = BUSINESS_DETAILS_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP|pdf';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('business_itr1')){
    			$test_cons   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_cons     = 0;
    			$data_arr['business_itr1']    = $data['upload_data']['file_name'];
    		}
        }
		
		
		$test_cons 	 = 0;	
		$small_image = "";
		if(isset($_FILES["business_itr2"]["name"]) && !empty($_FILES["business_itr2"]["name"])){
    		$image_info = getimagesize($_FILES["business_itr2"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='business_itr2';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["business_itr2"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['business_itr2']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = BUSINESS_DETAILS_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP|pdf';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('business_itr2')){
    			$test_cons   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_cons     = 0;
    			$data_arr['business_itr2']    = $data['upload_data']['file_name'];
    		}
        }
		
		
		$test_cons 	 = 0;	
		$small_image = "";
		if(isset($_FILES["business_itr3"]["name"]) && !empty($_FILES["business_itr3"]["name"])){
    		$image_info = getimagesize($_FILES["business_itr3"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='business_itr3';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["business_itr3"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['business_itr3']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = BUSINESS_DETAILS_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP|pdf';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('business_itr3')){
    			$test_cons   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_cons     = 0;
    			$data_arr['business_itr3']    = $data['upload_data']['file_name'];
    		}
        }
		
		$test_cons 	 = 0;	
		$small_image = "";
		if(isset($_FILES["business_pl"]["name"]) && !empty($_FILES["business_pl"]["name"])){
    		$image_info = getimagesize($_FILES["business_pl"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='business_pl';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["business_pl"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['business_pl']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = BUSINESS_DETAILS_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP|pdf';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('business_pl')){
    			$test_cons   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_cons     = 0;
    			$data_arr['business_pl']    = $data['upload_data']['file_name'];
    		}
        }
		
		$test_cons 	 = 0;	
		$small_image = "";
		if(isset($_FILES["business_balance_sheet"]["name"]) && !empty($_FILES["business_balance_sheet"]["name"])){
    		$image_info = getimagesize($_FILES["business_balance_sheet"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='business_balance_sheet';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["business_balance_sheet"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['business_balance_sheet']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = BUSINESS_DETAILS_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP|pdf';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('business_balance_sheet')){
    			$test_cons   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_cons     = 0;
    			$data_arr['business_balance_sheet']    = $data['upload_data']['file_name'];
    		}
        }
		
		
		$test_cons 	 = 0;	
		$small_image = "";
		if(isset($_FILES["bank_passbook"]["name"]) && !empty($_FILES["bank_passbook"]["name"])){
    		$image_info = getimagesize($_FILES["bank_passbook"]["tmp_name"]);
    		$image_width = $image_info[0];
    		$image_height = $image_info[1];
    		$imageData1['imageName']='bank_passbook';
    		$imageData1['imageWidth']=$image_width;
    		$imageData1['imageHeight']=$image_height;
    		$imageData1['prefWidth']=$image_width;
		    $imageData1['prefHeight']=$image_height;
    		$extension = pathinfo($_FILES["bank_passbook"]["name"], PATHINFO_EXTENSION);
    		$filename = pathinfo($_FILES['bank_passbook']['name'], PATHINFO_FILENAME);
    		
    		$config['upload_path']    = BANK_DETAILS_IMG_PATH;
    		$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP|pdf';
    		$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
    		$this->load->library('upload', $config);
    		if(!$this->upload->do_upload('bank_passbook')){
    			$test_cons   = 1;
    			$error      = $this->upload->display_errors();
    		}else{
    			$data           = array('upload_data' => $this->upload->data());
    			$test_cons     = 0;
    			$data_arr['bank_passbook']    = $data['upload_data']['file_name'];
    		}
        }
		
	
		if(empty($loan_id)){
		$data_arr['created_at'] = CURRENT_TIME;
		$data_arr['created_by'] = $this->session->userdata('user_id');
		
		$this->common_model->insert('tbl_loan',$data_arr);
		$output = array(
			'status'	=> 'Success',
			'msg'		=> 'Loan Added Successfully',
		);
		}else{
		$data_arr['updated_at'] = CURRENT_TIME;
		$data_arr['updated_by'] = $this->session->userdata('user_id');
				
		$where = "id='$loan_id'";
		$this->common_model->update('tbl_loan',$data_arr,$where);
		$output = array(
			'status'	=> 'Success',
			'msg'		=> 'Loan Updated Successfully',
			'loan_id'	=> $loan_id,
		);
			
		  }
		
		echo json_encode($output);
	}
	
	public function list_loan(){
		$data = $row = array();
		$resultData 	= $this->loan_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($resultData as $row){
			$i++;
			
			$links  = base_url().'edit_loan/'.$row->id;
			$action = "<a href='".$links."' class='btn btn-primary btn-sm edit_data'><i class='fa fa-edit'></i></a>&nbsp;&nbsp;";
			
			$links1  = base_url().'view_loan/'.$row->id;
			$action.= "<a href='".$links1."' class='btn btn-primary btn-sm view_data'><i class='fa fa-eye'></i></a>&nbsp;&nbsp;";
			$data[] = array("LT".$i, $row->customer_name, $row->customer_phone, $row->customer_email, $row->loan_amount, $row->loan_tenure, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->loan_model->countAll($_POST),
			"recordsFiltered" 	=> $this->loan_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function edit_loan($loan_id){
		$data['page_title']	= 'Edit Loan';
		$data['inner_view']	= 'loan_new';
		$data['loan_details'] 	= $this->db->select('*')->where('id',$loan_id)->get('tbl_loan')->row();
		//$data['loan_details'] 	= $this->loan_category_model->edit_loan($loan_id);
        $this->load->view('includes/web_view',$data);
	}
	
	
	public function view_loan($loan_id){
		$data['page_title']	= 'View Loan';
		$data['inner_view']	= 'view_loan';
		$data['loan_details'] 	= $this->db->select('*')->where('id',$loan_id)->get('tbl_loan')->row();
        $this->load->view('includes/web_view',$data);
	}
}
?>