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

class Mter extends CI_Model{

    function get_ter_form($limit, $offset) {
        $data = [];
        $data['count'] = $this->get_ter_count();

        $query = $this->db->select("users.company, applications.*")
        ->from('users')
        ->join('applications', 'applications.beneficiary_user_id = users.id')
        ->where('applications.eval_link_static !=', '')
        ->where('applications.eval_link_static !=', NULL)
        ->order_by('applications.created_on', 'DESC')
        ->limit($limit, $offset)
        ->get();
        if ( $query->num_rows() > 0) {
            $data['data'] = $query->result_array();
        }
        return $data;
    }

    function get_ter_count($search = NULL) {

        if(!empty($search)) {
            $this->db->where('application_num', $search);
        }

        $this->db->where('eval_link_static !=', '');
        $this->db->where('eval_link_static !=', NULL);
        $query = $this->db->get('applications');
       return $query->num_rows();
    }



    public function get_total_ter_forfi($limit, $offset, $search = NULL, $sortby='applications.created_on', $asc ='DESC') {

		$column= 'users.id as userid, applications.id as appid, applications.*, (select count(*) from applications_projects where 
		applications_projects.application_num = applications.application_num) as countprojects, users.*';
		$this->db->select($column);
		$this->db->from('applications');
		$this->db->join('users', 'applications.beneficiary_user_id = users.id');
		if(!empty($search)) {
			 $this->db->like('applications.application_num', $search);
			 $this->db->or_like('users.email', $search);
             $this->db->or_like('applications.pmu_approve_status', $search);
			 $this->db->or_like('users.company_phone', $search);
		}
		
        $this->db->where('applications.eval_link_static !=', '');
        $this->db->where('applications.eval_link_static !=', NULL);


        $this->db->order_by($sortby, $asc);
		$this->db->limit($limit, $offset);
		return $this->db->get()->result();
	}


    
    public function get_total_ter_forsda($limit, $offset, $state = '', $sortby='applications.created_on', $asc ='DESC') {

		$column= 'users.id as userid, applications.id as appid, applications.*, (select count(*) from applications_projects where 
		applications_projects.application_num = applications.application_num) as countprojects, users.*';
		$this->db->select($column);
		$this->db->from('applications');
		$this->db->join('users', 'applications.beneficiary_user_id = users.id');

		if(!empty($state)) {
            $this->db->where('applications.eval_link_static !=', '');
		}
		
        $this->db->where('applications.eval_link_static !=', '');
        $this->db->where('applications.eval_link_static !=', NULL);


        $this->db->order_by($sortby, $asc);
		$this->db->limit($limit, $offset);
		return $this->db->get()->result();
	}


    function get_total_count_forsda($state) {
        $this->db->where('company_state', $state);
        $this->db->where('eval_link_static !=', '');
        $this->db->where('eval_link_static !=', NULL);
        $query = $this->db->get('applications');
       return $query->num_rows();
    }

}