<?php

class Mprofile extends CI_Model {
    
	function __construct(){
        parent::__construct();
    }
	
	function selectQuery($query) {
		return $this->db->query($query);
	}
	
	function getApplicantDetail($condn = null)
	{
		$this->db->select('applicant.*, applicant_family_member_income_dtl.*, applicant_user_info.full_name AS aui_full_name, applicant_user_info.mobile AS aui_mobile, applicant_user_info.email AS aui_email, country_master.country_name, state_master.state_name');
		$this->db->from('applicant');
		$this->db->join('applicant_user_info', 'applicant.applicant_user_id = applicant_user_info.applicant_user_id', 'LEFT');
		$this->db->join('applicant_family_member_income_dtl', 'applicant.family_member_dtl_id = applicant_family_member_income_dtl.family_mem_inc_dtl_id', 'LEFT');
		$this->db->join('country_master', 'applicant.permanent_country_id = country_master.country_id', 'LEFT');
		$this->db->join('state_master', 'applicant.permanent_state_id = state_master.state_id', 'LEFT');
		foreach ($condn as $key => $value)
			$this->db->where($key, $value);
        $query=$this->db->get();
		//echo $this->db->last_query(); die;
        return $query->row_array();
	}
	
	function get_yearly_income($applicant_id = 0)
	{
		if($applicant_id > 0){
			$sql = "SELECT SUM(income) AS tot_family_income FROM applicant_family_member_income_dtl WHERE applicant_id = '".$applicant_id."' ";
			$query = $this->db->query($sql);
        	return $query->row_array();
		}
	}
	
	public function get_coapplicants($applicant_id) {

        $sql = "SELECT A.*
				FROM applicant_family_member_income_dtl AS A
				LEFT JOIN applicant AS B
				ON A.family_mem_inc_dtl_id = B.family_member_dtl_id
				WHERE B.family_member_dtl_id IS NULL 
				AND A.applicant_id = ".$applicant_id." 
				AND A.relationship != 'Self' ";
        $query = $this->db->query($sql);
		$rows = $query->result_array();
        
        if($rows){
            return $rows;
        } else {
            return false;
        }

    }
	
	public function get_organizationattribute($getType = 0, $attribute_type = '') {

		$result = array();
		
		$sql = "SELECT a.*, b.* FROM attribute_master a INNER JOIN organization_attribute_mapping b ON a.attribute_id = b.attribute_id WHERE b.org_type_id = ".$getType." AND a.attribute_type = '".$attribute_type."' ";
		$query = $this->db->query($sql);
		$rows = $query->result_array();	        
		
		if($rows){
			return $rows;
		} else {
			return false;
		}
    }
	
	public function applicant_type_attribute($applicant_com_id = 0) {

        $result = array();
		if($applicant_com_id > 0){
			$sql = "SELECT a.*, b.* FROM applicant_commercial_attribute_detail a INNER JOIN attribute_master b ON a.attribute_id = b.attribute_id WHERE a.applicant_com_id = ".$applicant_com_id."";
			$query = $this->db->query($sql);
			$rows = $query->result_array();	       
	
			if($rows){
				return $rows;
			} else {
				return false;
			}
		}

    }
	
	public function applicant_attributemap($finalArr) {
        $sql = $this->db->insert_batch('applicant_commercial_attribute_detail', $finalArr);
        if($sql){
            return true;
        }
    }
	
	function getComApplicantDetail($condn = null)
	{
		$this->db->select('applicant_commercial.applicant_com_id,applicant_commercial.applicant_user_com_id,applicant_commercial.applicant_type,applicant_commercial.full_name,applicant_commercial.father_name,applicant_commercial.residential_status,applicant_commercial.permanent_address1,applicant_commercial.permanent_city,applicant_commercial.permanent_district, applicant_commercial.permanent_state_id, applicant_commercial.permanent_pincode, applicant_commercial.permanent_country_id, applicant_commercial.present_address1, applicant_commercial.present_city, applicant_commercial.present_district, applicant_commercial.present_state_id, applicant_commercial.present_pincode, applicant_commercial.present_country_id, applicant_commercial.dob, applicant_commercial.age, applicant_commercial.detailed_age, applicant_commercial.minor_flag, applicant_commercial.email, applicant_commercial.mobile_country_code, applicant_commercial.mobile, applicant_commercial.alt_mobile_country_code, applicant_commercial.alt_mobile, applicant_commercial.gender, applicant_commercial.marital_status, applicant_commercial.org_name, applicant_commercial.organization_type_id, applicant_commercial.org_address, applicant_commercial.bank_name, applicant_commercial.bank_branch, applicant_commercial.bank_account_no, applicant_commercial.bank_ifsc, applicant_commercial.cancel_check_file, applicant_commercial.is_active, applicant_commercial.created_by, applicant_commercial.created_ts, applicant_commercial.updated_by, applicant_commercial.updated_ts, applicant_user_info_commercial.full_name AS aui_full_name, applicant_user_info_commercial.mobile AS aui_mobile, applicant_user_info_commercial.email AS aui_email, country_master.country_name, state_master.state_name');
		$this->db->from('applicant_commercial');
		$this->db->join('applicant_user_info_commercial', 'applicant_commercial.applicant_user_com_id = applicant_user_info_commercial.applicant_user_com_id', 'LEFT');
		$this->db->join('country_master', 'applicant_commercial.permanent_country_id = country_master.country_id', 'LEFT');
		$this->db->join('state_master', 'applicant_commercial.permanent_state_id = state_master.state_id', 'LEFT');
		foreach ($condn as $key => $value)
			$this->db->where($key, $value);
        $query=$this->db->get();
		//echo nl2br($this->db->last_query()); die;
        return $query->row_array();
	}
	
}