<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Mdashboard extends CI_Model {

    public function __construct() {
        parent::__construct();

    }

	public function get_dashboard_details(){
        
		$sql = "SELECT (SELECT COUNT(project_id) FROM project WHERE project_status = 'P') AS total_project, 
				(SELECT COUNT(applicant_id) FROM applicant WHERE main_applicant_flag = '1') AS total_applicant,
				(SELECT COUNT(application_id) FROM application WHERE payment_status = 'Success') AS total_application,
				(SELECT SUM(amount) FROM payment_info WHERE (status = 'Success' OR status = 'SUCCESSFUL')) AS total_application_money";
				
		$query = $this->db->query($sql);
        return $query->row_array();
    }
	
	public function get_application_count_category_wise($where = array()){
        $this->db->select('COUNT(application.application_id) AS tot_count_cate_wise, SUM(payment_info.amount) AS total_amount, application.project_det_id, project_det.category_id');
        $this->db->from('application');
        $this->db->join('project_det', 'application.project_det_id = project_det.project_det_id', 'LEFT');
		$this->db->join('payment_info', 'application.application_id = payment_info.application_id', 'LEFT');
        if(!empty($where)){
            $this->db->where($where);
        }
        $query=$this->db->get();
		//echo nl2br($this->db->last_query());die;
        return $query->row_array();
    }


}