<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
require_once("Secure_Controller.php");
class Mutual_fund extends Secure_Controller{
	
	public function __construct(){
		parent::__construct('mutual_fund');
		$this->load->model('Mutual_fund_model');
	}
	
	public function index(){
		if(!$this->Appconfig->isAppvalid()){
			redirect('config');
		}
		$data['table_headers'] = $this->xss_clean(get_mutual_fund_table_headers());
		$this->load->view('mutual_fund/manage',$data);
	}
	
	public function search(){
		$search   = $this->input->get('search');
		$limit    = $this->input->get('limit');
		$offset   = $this->input->get('offset');
		$sort     = $this->input->get('sort');
		$order    = $this->input->get('order');
		$filters  = array('start_date' => $this->input->get('start_date'),'end_date' => $this->input->get('end_date'));
		$filledup = array_fill_keys($this->input->get('filters'), TRUE);
		$filters  = array_merge($filters, $filledup);

		$all_leads = $this->Mutual_fund_model->search($search, $filters, $limit, $offset, $sort, $order);
		$total_rows = $this->Mutual_fund_model->get_found_rows($search, $filters);
		$data_rows = array();
		foreach($all_leads->result() as $leads){
			$data_rows[] = get_mutual_fund_data_row($leads, $this);
		}
		echo json_encode(array('total' => $total_rows, 'rows' => $data_rows));
	}
	
	public function view($mf_id){
		$info = $this->Mutual_fund_model->get_info($mf_id);
		foreach(get_object_vars($info) as $property => $value){
			$info->$property = $this->xss_clean($value);
		}
		$data['lead_info']   = $info;
		$bank_info[""] = "-- Select Bank Name --";
		foreach($this->Mutual_fund_model->get_bank_info() as $row){
			$bank_info[$this->xss_clean($row->bank_id)] = $this->xss_clean($row->bank_name);
		}
		$data['bank_info'] = $bank_info;
		
		$data['family_info']      = $this->Mutual_fund_model->get_family_list($mf_id);
		$data['mf_log']           = $this->Mutual_fund_model->mf_log($mf_id);
		$data['mf_bank_info']     = $this->Mutual_fund_model->get_bank_list($mf_id);
		$data['investment_info']  = $this->Mutual_fund_model->get_investment($mf_id);
		$data['ewealth_info']     = $this->Mutual_fund_model->get_ewealth($mf_id);
		$data['ewealth_log_info'] = $this->Mutual_fund_model->get_ewealth_log($mf_id);
		
		$rm_info[""] = "-- Select RM Name --";
		foreach($this->Mutual_fund_model->get_rm_name() as $row){
			$rm_info[$this->xss_clean($row->id)] = $this->xss_clean($row->first_name);
		}
		$data['rm_info'] = $rm_info;
		
		$distributer_info[""] = "-- Company Name --";
		foreach($this->Mutual_fund_model->get_distributer() as $row){
			$distributer_info[$this->xss_clean($row->vendor_id)] = $this->xss_clean($row->vendorcompanyname);
		}
		$data['distributer_info'] = $distributer_info;
		
		$dis_code_info[""] = "-- Compamy Code --";
		foreach($this->Mutual_fund_model->get_distributer_code() as $row){
			$dis_code_info[$this->xss_clean($row->code_id)] = $this->xss_clean($row->company_code);
		}
		$data['dis_code_info'] = $dis_code_info;
		
		$investor_info[""] = "-- Investor Name --";
		$nominee_info[""]   = "-- Nominee Name --";
		$guardian_info[""] = "-- Guardian Name --";
		foreach($this->Mutual_fund_model->get_family_list($mf_id) as $row){
			$investor_info[$this->xss_clean($row->mf_family_id)] = $this->xss_clean($row->fam_name);
			$nominee_info[$this->xss_clean($row->mf_family_id)] = $this->xss_clean($row->fam_name);
			$guardian_info[$this->xss_clean($row->mf_family_id)] = $this->xss_clean($row->fam_name);
		}
		$data['investor_info'] = $investor_info;
		$data['nominee_info']  = $nominee_info;
		$data['guardian_info'] = $guardian_info;
		
		$investor_bk_info[""] = "-- Investor Bank --";
		foreach($this->Mutual_fund_model->get_bank_list($mf_id) as $row){
			$investor_bk_info[$this->xss_clean($row->mf_bank_id)] = $this->xss_clean($row->bank_acc_no." - ".$row->bank_name);
		}
		$data['investor_bk_info'] = $investor_bk_info;
		
		$amc_info[""] = "-- Select AMC --";
		foreach($this->Mutual_fund_model->get_amc() as $row){
			$amc_info[$this->xss_clean($row->amc_id)] = $this->xss_clean($row->amc_name);
		}
		$data['amc_info'] = $amc_info;
		
		$scheme_info[""] = "-- Select Scheme --";
		foreach($this->Mutual_fund_model->get_scheme_info() as $row){
			$scheme_info[$this->xss_clean($row->fund_name_id)] = $this->xss_clean($row->fund_name);
		}
		$data['scheme_info'] = $scheme_info;
		
		$ew_investor_info[""] = "-- Investor Name --";
		foreach($this->Mutual_fund_model->get_ewealth($mf_id) as $row){
			$ew_investor_info[$this->xss_clean($row->mf_family_id)] = $this->xss_clean($row->fam_name);
		}
		$data['ew_investor_info'] = $ew_investor_info;
		
		$this->load->view("mutual_fund/form", $data);
	}
	
	public function save_custinfo($mf_id = -1){
		$cust_id = $this->input->post('cust_id');
		$customer_data = array(
			'cust_name'          => $this->input->post('cust_name'),
			'dob'                => date('Y-m-d',strtotime($this->input->post('dob'))),
			'cust_mobile'        => $this->input->post('cust_mobile'),
			'alter_mobile'       => $this->input->post('alter_mobile'),
			'cust_email'         => $this->input->post('cust_email'),
			'cust_address'       => $this->input->post('cust_address'),
			'permanent_address'  => $this->input->post('permanent_address'),
			'pan_no'             => $this->input->post('pan_no'),
			'aadhaar_no'         => $this->input->post('aadhaar_no'),
			'income'             => $this->input->post('income'),
			'profile'            => $this->input->post('profile'),
			'office'             => $this->input->post('office'),
			'industry'           => $this->input->post('industry'),
			'designation'        => $this->input->post('designation'),
			'marrital'           => $this->input->post('marrital'),
			'kyc_sts'            => $this->input->post('kyc_sts'),
			'id_proof'           => $this->input->post('hid_id_proof'),
			'address_proof'      => $this->input->post('hid_address_proof'),
			'income_proof'       => $this->input->post('hid_income_proof'),
			'bank_cheque'        => $this->input->post('hid_bank_cheque_proof'),
			'mf_pan'             => $this->input->post('hid_mf_pan_proof'),
			'updated_by'         => $this->session->userdata('emp_id'),
			'updated_date'       => date('Y-m-d h:i:s'),
		);
		$cust_name = $this->input->post('cust_name');
		$cust_data = $this->Mutual_fund_model->lead_update_customer($customer_data, $cust_id);
		echo json_encode(array('success' => TRUE, 'message' => "$cust_name Personal Information updated"));

	}
	
	public function save_family(){
		$cust_id      = $this->input->post('cust_id');
		$mf_id        = $this->input->post('mf_id');
		$mf_family_id = $this->input->post('mf_family_id');

		$family_data = array(
			'cust_id'        => $this->input->post('cust_id'),
			'mf_id'          => $this->input->post('mf_id'),
			'fam_name'       => $this->input->post('fam_name'),
			'fam_dob'        => date('Y-m-d',strtotime($this->input->post('fam_dob'))),
			'fam_relation'   => $this->input->post('fam_relation'),
			'fam_profile'    => $this->input->post('fam_profile'),
			'fam_sex'        => $this->input->post('fam_sex'),
			'created_by'     => $this->session->userdata('emp_id'),
			'created_date'   => date('Y-m-d h:i:s'),
		);
		$family_data = $this->Mutual_fund_model->lead_save_family($family_data,$mf_id,$mf_family_id);
		echo json_encode(array('status' =>"SUCCESS",'family_data' => $family_data));
	}
	
	public function get_family_person(){
		$mf_family_id = $_REQUEST['mf_family_id'];
		$person_data = $this->Mutual_fund_model->get_family_person($mf_family_id);
		echo json_encode(array('status' =>"SUCCESS",'person_data' => $person_data));
	}
	
	public function remove_family_person(){
		$mf_family_id = $_REQUEST['mf_family_id'];
		$mf_id        = $_REQUEST['mf_id'];

		$family_data = array(
			'deleted'        => '1',
			'deleted_by'     => $this->session->userdata('emp_id'),
			'deleted_date'   => date('Y-m-d h:i:s'),
		);
		$this->Mutual_fund_model->remove_family_person($mf_family_id,$family_data);
		$person_data = $this->Mutual_fund_model->get_family_list($mf_id);
		echo json_encode(array('status' =>"SUCCESS",'person_data' => $person_data));
	}
	
	public function save_bank(){
		$bk_mf_id = $this->input->post('bk_mf_id');
		$bank_data = array(
			'bank_name'    => $this->input->post('bank_name'),
			'bank_branch'  => $this->input->post('bank_branch'),
			'bank_acc_no'  => $this->input->post('bank_acc_no'),
			'bank_ifsc'    => $this->input->post('bank_ifsc'),
			'bk_mf_id'     => $this->input->post('bk_mf_id'),
			'bk_cust_id'   => $this->input->post('bk_cust_id'),
		);
		$this->Mutual_fund_model->save_bank($bank_data);
		$bank_data = $this->Mutual_fund_model->get_bank_list($bk_mf_id);
		echo json_encode(array('status' =>"SUCCESS",'bank_data' => $bank_data));
	}
	public function get_bank_by_id(){
		$mf_bank_id = $this->input->post('mf_bank_id');
		$bank_data  = $this->Mutual_fund_model->get_bank_by_id($mf_bank_id);
		echo json_encode(array('status' =>"SUCCESS",'bank_data' => $bank_data));
	}
	public function delete_bank(){
		$mf_bank_id = $this->input->post('mf_bank_id');
		$bk_mf_id   = $this->input->post('bk_mf_id');
		$bank_data = array(
			'status'        => '0',
			'deleted_by'     => $this->session->userdata('emp_id'),
			'deleted_date'   => date('Y-m-d h:i:s'),
		);
		$this->Mutual_fund_model->delete_bank($bank_data,$mf_bank_id);
		$bank_data = $this->Mutual_fund_model->get_bank_list($bk_mf_id);
		echo json_encode(array('status' =>"SUCCESS",'bank_data' => $bank_data));
	}
	
	public function get_fund_by_id(){
		$amc = $this->input->post('amc');
		$amc_data  = $this->Mutual_fund_model->get_fund_by_id($amc);
		echo json_encode(array('status' =>"SUCCESS",'amc_data' => $amc_data));
	}
	public function get_code(){
		$distributer      = $this->input->post('distributer');
		$distributer_info = $this->Mutual_fund_model->get_company_code($distributer);
		echo json_encode(array('status' =>"SUCCESS",'distributer_info' => $distributer_info));
	}
	public function get_age(){
		$investor      = $this->input->post('investor');
		$investor_info = $this->Mutual_fund_model->get_family_person($investor);
		$fam_dob       = $investor_info[0]->fam_dob;		
		$from = new DateTime($fam_dob);
		$to   = new DateTime('today');
		$age  = $from->diff($to)->y;
		//echo "$age";
		$sts = "Hide";
		if($age < 18){
			$sts = "Show";
		}
		echo json_encode(array('status' =>"SUCCESS",'sts' => $sts));
	}
	public function save_investment(){
		$investment_id = $this->input->post('investment_id');
		$inves_mf_id   = $this->input->post('inves_mf_id');
		$investor      = $this->input->post('investor');
		$investment_data = array(
			'inves_mf_id'      => $this->input->post('inves_mf_id'),
			'entry_date'       => date('Y-m-d',strtotime($this->input->post('entry_date'))),
			'rm_name'          => $this->input->post('rm_name'),
			'distributer'      => $this->input->post('distributer'),
			'distributer_code' => $this->input->post('distributer_code'),
			'amc'              => $this->input->post('amc'),
			'scheme_name'      => $this->input->post('scheme_name'),
			'fund_class'       => $this->input->post('fund_class'),
			'fund_type'   	   => $this->input->post('fund_type'),
			'investment_type'  => $this->input->post('investment_type'),
			'sip_day'   	   => $this->input->post('sip_day'),
			'amount'           => $this->input->post('amount'),
			'purpose'          => $this->input->post('purpose'),
			'policy_no'        => $this->input->post('policy_no'),
			'investor'         => $this->input->post('investor'),
			'nominee'          => $this->input->post('nominee'),
			'guardian'         => $this->input->post('guardian'),
			'investor_bank'    => $this->input->post('investor_bank'),
			'cheque_no'        => $this->input->post('cheque_no'),
			'login_status'     => $this->input->post('login_status'),
			'folio_no'         => $this->input->post('folio_no'),
			'sip_status'       => $this->input->post('sip_status'),
			'rejected_reason'  => $this->input->post('rejected_reason'),
			'remarks'          => $this->input->post('remarks'),
			'lead_id'          => $this->input->post('lead_id'),
		);
		$this->Mutual_fund_model->save_investment($investment_data,$investment_id);
		$this->Mutual_fund_model->save_ewealth($inves_mf_id,$investor);		
		$investment_data = $this->Mutual_fund_model->get_investment($inves_mf_id);
		$ewealth_data = $this->Mutual_fund_model->get_ewealth($inves_mf_id);
		echo json_encode(array('status' =>"SUCCESS",'investment_data' => $investment_data,'ewealth_data' => $ewealth_data));
	}
	public function get_investmen_by_id(){
		$investment_id = $this->input->post('investment_id');
		$investment_data  = $this->Mutual_fund_model->get_investmen_by_id($investment_id);
		echo json_encode(array('status' =>"SUCCESS",'investment_data' => $investment_data));
	}
	
	public function delete_investment(){
		$investment_id = $this->input->post('investment_id');
		$inves_mf_id   = $this->input->post('inves_mf_id');
		$investment_data = array(
			'status'        => '0',
			'deleted_by'     => $this->session->userdata('emp_id'),
			'deleted_date'   => date('Y-m-d h:i:s'),
		);
		$this->Mutual_fund_model->delete_investment($investment_data,$investment_id);
		$investment_data = $this->Mutual_fund_model->get_investment($inves_mf_id);
		echo json_encode(array('status' =>"SUCCESS",'investment_data' => $investment_data));
	}
	public function update_ewealth(){
		$inves_mf_id = $this->input->post('ew_inves_mf_id');
		$ewealth_data = array(
			'inves_mf_id'    => $this->input->post('ew_inves_mf_id'),
			'ew_investor'    => $this->input->post('ew_investor'),
			'client_sts'     => $this->input->post('client_sts'),
			'doc_sts'        => $this->input->post('doc_sts'),
			'ewealth_sts'    => $this->input->post('ewealth_sts'),
			'rejected_reason'=> $this->input->post('rejected_reason'),
			'ucc_code'       => $this->input->post('ucc_code'),
		);
		$this->Mutual_fund_model->update_ewealth($ewealth_data);
		$ewealth_data = $this->Mutual_fund_model->get_ewealth($inves_mf_id);
		echo json_encode(array('status' =>"SUCCESS",'ewealth_data' => $ewealth_data));
	}
	public function get_ewealth_by_id(){		
		$ewealth_id = $this->input->post('ewealth_id');
		$ewealth_data  = $this->Mutual_fund_model->get_ewealth_by_id($ewealth_id);
		echo json_encode(array('status' =>"SUCCESS",'ewealth_data' => $ewealth_data));
	}
	public function upd_completed(){
		$lead_id   = $this->input->post('lead_id');
		$mf_id     = $this->input->post('mf_id');
		$sts       = $this->input->post('sts');
		$completed_data = array(
			'mf_lead_status' => $this->input->post('sts'),
			'updated_by'     => $this->session->userdata('emp_id'),
			'updated_date'   => date('Y-m-d h:i:s'),
		);
		$this->Mutual_fund_model->upd_completed($completed_data,$lead_id);
		$this->Mutual_fund_model->update_lead_status($lead_id,$mf_id);
		echo json_encode(array('status' =>"SUCCESS",'msg' => "Updated Successfully !!!"));
	}
}
?>