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

class Console extends CI_Controller {

    function __construct() { 
        parent::__construct();
        $user_detail = $this->session->has_userdata('email_id');
        $data['menu'] = Array();
        $this->load->vars($data);

        if($this->session->userdata('module') != 'console') {
            redirect('consoleauth', 'refresh');
        }

        if(empty($user_detail)) {
            redirect('consoleauth', 'refresh');
        }

    }

    function index() {

       $usertype = $this->session->userdata('user_type');
       $data['banks'] = $this->mbank->get_bank_detail();

        if(!empty($usertype) && $usertype == 'bee') {
           
            $data['totalapp'] = $this->mter->get_ter_count(); // Fetch all form based on  ter condition
            $data['sanctioned'] = $this->getSanction($this->mconsole->get_sanction_detail());
            $data['disbursed'] = $this->getDisbursed($this->mconsole->get_disbursed_detail());
            $data['financed'] = $this->getFinanced('');
            $data['totalFinance'] = $this->mconsole->get_total_financed();
            $this->load->vars($data);
           
        } else {
            $data['bank'] = [];
            $data['bankwise'] = [];
            $state_code = $this->session->userdata('state_code');
            $data['statename'] = $this->mwillingness->state_name_bycode($state_code);
            $data['totalapp'] = $this->mter->get_total_count_forsda($state_code);
            $data['sanctioned'] = $this->getSanction($this->mconsole->get_sanction_detail($state_code));
            $data['disbursed'] = $this->getDisbursed($this->mconsole->get_disbursed_detail($state_code));
            $data['financed'] = [];
            $data['totalFinance'] = ['total' => 0];
            $this->load->vars($data);

        }
    
       $this->load->view('bee/layout/template', ['page'=> 'bee/dashboard/sda']);
    }


    function exportfi() {
    
        header("Content-type: application/vnd.ms-excel");
        $file="fi_wise_data.xls";
        header("Content-Disposition: attachment; filename=$file");

        $usertype = $this->session->userdata('user_type');
        $data['banks'] = $this->mbank->get_bank_detail();

        if(!empty($usertype) && $usertype == 'bee') {
           
            $data['totalapp'] = $this->mter->get_ter_count();
            $data['sanctioned'] = $this->getSanction($this->mconsole->get_sanction_detail());
            $data['disbursed'] = $this->getDisbursed($this->mconsole->get_disbursed_detail());
            $data['financed'] = $this->getFinanced('');
            $data['totalFinance'] = $this->mconsole->get_total_financed();
           
            $this->load->vars($data);
           
        } else {
            $data['bank'] = [];
            $data['bankwise'] = [];

           $state_code = $this->session->userdata('state_code');
            $data['totalapp'] = $this->mter->get_total_count_forsda($state_code);
            $data['sanctioned'] = $this->getSanction($this->mconsole->get_sanction_detail($state_code));
            $data['disbursed'] = $this->getDisbursed($this->mconsole->get_disbursed_detail($state_code));
            $data['financed'] = [];
            $data['totalFinance'] = ['total' => 0];
            $this->load->vars($data);

        }
    
        $this->load->view('bee/dashboard/sda_export');
       
    }


    function districtwise($action = "") {

        $state_code = $this->session->userdata('state_code');
        $data['statename'] = $this->mwillingness->state_name_bycode($state_code);
        $data['district'] = $this->mwillingstatus->get_district_name($state_code);
        $data1 = $this->mwillingstatus->district_wise_count($state_code);
        $data['sanctioned'] = $this->mconsole->get_sanction_districtwise($state_code);
        $data['disbursed'] = $this->mconsole->get_disbursed_districtwise($state_code);
        $data['fidata'] = [];
        if(!empty($data1)) {
            foreach($data1 as $res => $val) {
               $data['fidata'][$val['company_dist']] = $val['total'];
            }
        }
        $this->load->vars($data);
        if(empty($action)) {
             $this->load->view('bee/layout/template', ['page'=> 'bee/form/district_dashboard']);
        }

        
        if(!empty($action) && $action == "download"){
            header('Content-Type: application/octet-stream');
            $file="district_wise_report.xls";
            header("Content-Disposition: attachment; filename=$file");
            $this->load->view('bee/form/district_wise_export');
            return;
        }
    
    }

    function getSanction($data1) {
        $sanction = [];
      
        if(!empty($data1)) {
            foreach($data1 as $res => $val) {
               if(!empty($val['bank_code'])) {
                $keyname = trim($val['bank_code']);
                $sanction[$keyname]['num'] = $val['total'];
                $sanction[$keyname]['amount'] = $val['sanctioned'];
               }
            }
        }
        return $sanction;
    }


    function getDisbursed($data1) {
      
        $disbursed = [];
        if(!empty($data1)) {
            foreach($data1 as $res => $val) {
                if(!empty($val['financed_bank'])) {
                    $keyname = $val['financed_bank'];
                    $disbursed[$keyname]['num'] = $val['total'];
                    $disbursed[$keyname]['amount'] = $val['loan_disbursed'];
                }
            }
        }
        return $disbursed;
    }


    
    function getFinanced() {
        $financed = [];
        $data1 = $this->mconsole->get_financed();
        if(!empty($data1)) {
            foreach($data1 as $res => $val) {
               $keyname = trim($val['bank_code']);
               $financed[$keyname]['num'] = $val['total'];
               $financed[$keyname]['amount'] = $val['sanctioned'];
            }
        }
        return $financed;
    }


    function downloadStatereport() {
    
        header("Content-type: application/vnd.ms-excel");
        $file="state_wise_data.xls";
        header("Content-Disposition: attachment; filename=$file");

        $usertype = $this->session->userdata('user_type');
        $data['banks'] = $this->mbank->get_bank_detail();

        if(!empty($usertype) && $usertype == 'bee') {
            $data['states'] = $this->mwillingstatus->get_state_name();
            $data1 = $this->mwillingstatus->statewise_count_bee();
            $data['sanctioned'] = $this->get_state_sanction($this->mconsole->get_sanction_statewise());
            $data['disbursed'] = $this->get_state_disbursed($this->mconsole->get_disbursed_statewise());
            $data['fidata'] = [];
            if(!empty($data1)) {
                foreach($data1 as $res => $val) {
                   $data['fidata'][$val['company_state']] = $val['total'];
                }
            }

            $this->load->vars($data);
        }
    
        $this->load->view('bee/dashboard/statewise_export');
       
    }


    function reportstate() { 
        $data['states'] = $this->mwillingstatus->get_state_name();
        $data1 = $this->mwillingstatus->statewise_count_bee();
        $data['sanctioned'] = $this->get_state_sanction($this->mconsole->get_sanction_statewise());
        $data['disbursed'] = $this->get_state_disbursed($this->mconsole->get_disbursed_statewise());
        $data['fidata'] = [];
        if(!empty($data1)) {
            foreach($data1 as $res => $val) {
               $data['fidata'][$val['company_state']] = $val['total'];
            }
        }
    $this->load->vars($data);
    $this->load->view('bee/layout/template', ['page'=> 'bee/dashboard/states_bee']);
}



function get_state_sanction($data1) {
    $sanction = [];
  
    if(!empty($data1)) {
        foreach($data1 as $res => $val) {
            if(!empty($val['company_state'])) {
                $keyname =  trim($val['company_state']);
                $sanction[$keyname]['num'] = $val['total'];
                $sanction[$keyname]['amount'] = $val['sanctioned'];
            }
        }
    }
    return $sanction;
}


function get_state_disbursed($data1) {
  
    $disbursed = [];
    if(!empty($data1)) {
        foreach($data1 as $res => $val) {
            if(!empty($val['company_state'])) {
                $keyname = $val['company_state'];
                $disbursed[$keyname]['num'] = $val['total'];
                $disbursed[$keyname]['amount'] = $val['loan_disbursed'];
            }
        }
    }
    return $disbursed;
}



    function states() {
        $data['project'] = $this->mconsole->get_projects();
        $this->load->vars($data);
        $this->load->view('bee/layout/template', ['page'=> 'bee/dashboard/project-detail']);
    }

    function daily($pagenum = 1) {

        $order = "asc";
        if(!empty($_REQUEST['sortby']) && $_REQUEST['sortby'] == "asc") {
            $order = "desc";
        } else if(!empty($_REQUEST['sortby']) && $_REQUEST['sortby'] == "desc") {
            $order = "asc";
        }

        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
        
		$this->load->library('pagination');
		$config['base_url'] = base_url('console/daily');
	
        $limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	

        if(empty($search)) {
            $config['total_rows'] = $this->mwillingness->get_total_app($search);
        } else {
            $config['total_rows'] = $this->mwillingness->total_list_search($search);
        }
       
		$config['use_page_numbers'] = TRUE;
        $config['reuse_query_string'] = true;
		$this->pagination->initialize($config);

       $data['pmustatus']= Array('Inprogress', 'Pending', 'Completed');
       $data['status']= Array('Pending Approval', 'Approved', 'Reject');
       $data['forms'] = $this->mwillingness->get_list_all($limit, $offset, $search);
       $data['pagenum'] = $pagenum;
       $data['order'] = $order;
       $this->load->vars($data);
       $this->load->view('bee/layout/template', ['page'=> 'bee/form/willingnewss-list']);
    }


    function users() {
        $data['users'] = $this->mbeeuser->get_all_user();
        $this->load->vars($data);
        $this->load->view('bee/layout/template', ['page'=> 'bee/user/user-list']);
    }


  
    function application($appNumber) {
	 	$sector = $this->home_model->sector();
	 	$bank = $this->beneficiary_model->getBankDetails();
		$data['sector'] = array_column($sector,"name","sectorid");
	 	$data['application']  = $this->beneficiary_model->get_application_detail($appNumber);
        if(!empty($data['application'])) {
            $data['userdetail'] = $this->beneficiary_model->get_user_detail($data['application']->beneficiary_user_id);
        }
	
		$data['projects']  = $this->beneficiary_model->get_projects($appNumber);
		$data['states'] = $this->home_model->getStates();
		$data['districts'] = $this->home_model->getDistricts();
		$data['app_upload'] = $this->beneficiary_model->get_uploads_detail($appNumber);
		$data['bank'] = array_column($bank,"bank_name","bank_code");
        $this->load->vars($data);
		$this->load->view('bee/layout/template', ['page'=> 'bee/form/willingness-detail']);
	}


    function adduser() {

        $this->load->library('form_validation');
        $this->form_validation->set_rules('name','Name','required');
        $this->form_validation->set_rules('email_id','Email','required|valid_email');
        $this->form_validation->set_rules('password','Password','required');
        $this->form_validation->set_rules('user_type','User Type','required');

        if($this->input->post('user_type') == 'sda') {
            $this->form_validation->set_rules('state_code','State','required');  
        }

        if($this->form_validation->run() == FALSE) {
            $data['states'] = $this->mconsole->get_state();
            $this->load->vars($data);
            $this->load->view('bee/layout/template', ['page'=> 'bee/user/user-add']);
        } else {
            $this->mbeeuser->add_user();
        }
    }


    public function edituser($id) {
        $id = $this->uri->segment(3);
        $this->load->library('form_validation');     
        
        $this->form_validation->set_rules('name','Name','required');
      
        if ($this->form_validation->run() == false) {

            $data['states'] = $this->mconsole->get_state();
            $data['user'] = $this->mbeeuser->get_user_byid($id);
            $this->load->vars($data);
            $this->load->view('bee/layout/template', ['page'=> 'bee/user/user-add']);

        } else {
            $this->mbeeuser->update_user($id);
        }
    }


    public function view($id) {
        $data['pid'] = $id;
        $data['page'] = $this->mpackage->get_package_byid($id);
        $this->load->vars($data);
        $this->load->view('admin/package/package-view');
    }



    // Sda User start from Here


    public function sdawillingness($pagenum = 1) {

        $state_code = $this->session->userdata('state_code');

        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
		$this->load->library('pagination');
		$config['base_url'] = base_url('console/sdawillingness');
	
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;

            if(!empty($search)) {
                 $config['total_rows'] = $this->mwillingness->get_state_wise_total($state_code, $search);
            } else {
                $config['total_rows'] = $this->mwillingness->get_state_wise_total($state_code);
            }

        $config['use_page_numbers'] = TRUE;
        $config['reuse_query_string'] = true;

		$this->pagination->initialize($config);
       
        $data['pmustatus']= Array('Inprogress', 'Pending', 'Completed');
        $data['status']= Array('Pending Approval', 'Approved', 'Reject');
    
        $data['forms'] = $this->mwillingness->get_state_wise($state_code, $limit, $offset, $search);
        $this->load->vars($data);
        $this->load->view('bee/layout/template', ['page'=> 'bee/form/state_willingnewss_list']);
    }



    public function sdastates() {
        $state_code = $this->session->userdata('state_code');
        $data['project'] = $this->mconsole->get_state_wise_projects($state_code);
        $this->load->vars($data);
        $this->load->view('bee/layout/template', ['page'=> 'bee/dashboard/state_project_detail']);
    }


   


    function statesr($state) {

        $pagenum = $this->uri->segment(4);
        $pagenum = !empty($pagenum) ? $pagenum : 1;
        $this->load->library('pagination');
		$config['base_url'] = base_url('console/statesr/'.$state);
	
        $limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
    
        $config['total_rows'] =  $this->mwillingness->getforbee_total_by_state($state);
        $config['use_page_numbers'] = TRUE;
        $this->pagination->initialize($config);
       
        $data['forms'] = $this->mwillingness->getforbeeuser_by_state($state, $limit, $offset);
        $data['pmustatus']= Array('Inprogress', 'Pending', 'Completed');
        $data['status']= Array('Pending Approval', 'Approved', 'Reject');
      
        $data['state'] = $this->mwillingness->state_name_bycode($state);
        $this->load->vars($data);
        $this->load->view('bee/layout/template', ['page'=> 'bee/form/willingnewss-list']);
    }


    function deleteuser($id) {
        $this->db->where('user_id', $id);
        $this->db->delete('bee_users');
        $this->session->set_flashdata('message','User deleted Successfully.'); 
        redirect('console/users', 'refresh');
    }


  
    function dreport($dcode) {
        $pagenum = $this->uri->segment(4);
        $pagenum = !empty($pagenum) ? $pagenum : 1;
        $this->load->library('pagination');
		$config['base_url'] = base_url('console/dreport/'.$dcode);
	
        $limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
            $data['dname'] = $this->mconsole->get_district_name($dcode);
            $config['total_rows'] = $this->mwillingness->get_total_by_district($dcode);
            $config['use_page_numbers'] = TRUE;
            $this->pagination->initialize($config);
            $data['forms'] = $this->mwillingness->get_by_district($dcode, $limit, $offset);

            $data['pmustatus']= Array('Inprogress', 'Pending', 'Completed');
            $data['status']= Array('Pending Approval', 'Approved', 'Reject');
           
            $this->load->vars($data);
            $this->load->view('bee/layout/template', ['page'=> 'bee/form/district_willingnewss_list']);
    }

    function updateprofile() {

        if(empty($this->session->user_id)) {
            redirect('auth/logout', 'refresh');
        }

        $this->load->library('form_validation');
        $this->form_validation->set_rules('designation','Designation','required');
        $this->form_validation->set_rules('contact_no','Contact No','required');

        if($this->form_validation->run() == FALSE) {
            $data['user'] = $this->mbeeuser->get_user_byid($this->session->user_id);
            $this->load->vars($data);
            $this->load->view('bee/layout/template', ['page'=> 'bee/form/user-profile']);
        } else {
            $this->mbeeuser->update_profile($this->session->user_id);
        }
    }




    function updatepassword() {

        if(empty($this->session->user_id)) {
            redirect('auth/logout', 'refresh');
        }

        $this->load->library('form_validation');
        $this->form_validation->set_rules('password','Password','required');
        $this->form_validation->set_rules('confirm_password','Confirm Password','required');

        if($this->form_validation->run() == FALSE) {
            $this->load->view('bee/layout/template', ['page'=> 'bee/form/user-password']);
        } else {
            $this->mbeeuser->update_password($this->session->user_id);
        }
    }



    //####################################################################################
    //@@@@@@@@@@@@@@@@@@@@@@ FI Approval Start from HERE @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    //##################################################################################

    function fiapproval($pageNo = 1) {
        $this->load->library('pagination');
        $config['base_url'] = base_url('console/fiapproval');
        $config['total_rows'] = $this->mfi->get_total_fi_byloggedin_director();
        $config['per_page'] = 20;
        $config['use_page_numbers'] = TRUE;
        $this->pagination->initialize($config);

        $limit = 20; 
        $offset = ($pageNo - 1) * $limit;

        $data['forms'] = $this->mfi->get_newfi_bydirector($limit, $offset);
        $this->load->vars($data);
        $this->load->view('bee/layout/template', ['page'=> 'bee/user/new-fi-list']);
    }


    public function detailfi($id) {

        $data['action'] = "view";
        $data['user'] = $this->mfi->get_form_byid($id);
        $this->load->vars($data); 
        $this->load->view('bee/layout/template', ['page'=> 'bee/user/fi_user_edit']);
     }


     public function editfi($id) {


         $data['action'] = "edit";
       
         $this->load->library('form_validation');
         $this->form_validation->set_rules('status','Status','required');
         $this->form_validation->set_rules('director_comment','Comment','required');

         $data['user'] = $this->mfi->get_form_byid($id);
         if($this->form_validation->run() == FALSE) {
             $data['bank']   = $this->mbank->get_bank_detail();
             $this->load->vars($data);
             $this->load->view('bee/layout/template', ['page'=> 'bee/user/fi_user_edit']);
         } else {
            $status = $this->input->post('status');

            $this->onApprove($id, $data, $status);
            redirect('console/fithanks', 'refresh');
         }
     }


     function onApprove($id, $data, $status) {
        if($status == 'BEE_APPROVED') {
           $password = password_generate(7);
            $hashp = password_hash($password, PASSWORD_DEFAULT);
            $isSuccess =  $this->mfi->copy_data_into_usertable($data['user'], $hashp);
            $this->mfi->update_bank($data['user']['bank_code']);
           if($isSuccess == TRUE) {
                $this->mfi->bee_update_fi($id);
    
               $data['user']['password'] =  $password;
               $message = $this->load->view("email/user_activate", $data['user'], true);
                
               // Message After Bee Approval

               $this->session->set_flashdata('message', 'BEE approved and credentials shared with FI');
               $success= emailCheck('Financial Institution Details', $message, [$data['user']['email']], '');
           }
         } else {
           $this->mfi->bee_update_fi($id);
           $this->session->set_flashdata('message', 'BEE has Rejected Application');
           $message = $this->fiRegRejectionEmail($this->input->post('director_comment'));
           $success= emailCheck('Financial Institution Rejection Acknowledgement', $message, [$data['user']['email']], '');
         }
    }

     public function fithanks() {
        $data = [''];
        $this->load->vars($data); 
        $this->load->view('bee/layout/template', ['page'=> 'bee/user/fi_thanks']);
     }


     // #######################################################################################
     // @@@@@@@@@@@@@@@@@@@@@@@ FC Recommondation start from Here @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

     function firecommondation($pageNo = 1) {
        $this->load->library('pagination');
        $config['base_url'] = base_url('console/firecommondation');
        $config['total_rows'] = $this->mfi->get_total_fi_byloggedinpe();
        $config['per_page'] = 20;
        $config['use_page_numbers'] = TRUE;
        $this->pagination->initialize($config);

        $limit = 20; 
        $offset = ($pageNo - 1) * $limit;
        $data['forms'] = $this->mfi->get_newfi_bype($limit, $offset);
        $this->load->vars($data);
        $this->load->view('bee/layout/template', ['page'=> 'bee/fcrecommended/new-fi-list']);
    }

    function fcrecmndetail($id) {
        $data['action'] = "view";
        $data['user'] = $this->mfi->get_form_byid($id);
        $this->load->vars($data); 
        $this->load->view('bee/layout/template', ['page'=> 'bee/fcrecommended/fi_user_edit']); 
     }


     public function perecommendation($id) {
      

        $this->load->library('form_validation');
        $this->form_validation->set_rules('status','Status','required');
        $this->form_validation->set_rules('pe_comment','PE Comment','required');
        $this->form_validation->set_rules('director','Please select for Final Approval','required');

        $data = [];
        $data['action'] = 'edit';
        $data['pelist'] = $this->mbeeuser->get_ac_user('director');

       

        $data['user'] = $this->mfi->get_form_byid($id);

        if($data['user']['status'] == 'PE_RECOMMENDED') {
            redirect('console/firecommondation');
        }

        if($this->form_validation->run() == FALSE) {
            $this->load->vars($data);
            $this->load->view('bee/layout/template', ['page'=> 'bee/fcrecommended/fi_user_edit']);
            
        } else {

            $this->mfi->update_fi_bype($id);
            if($this->input->post('status') == 'PE_RECOMMENDED') {

               $message = $this->fiRegEmail( $data['user']['first_name']);
               $this->session->set_flashdata('message', 'Your details submit successfully !');
               $success= emailCheck('Acknowledgment of FI registration, Recommended By – Project Engineer / Project Economist / Executive Assistant Recommendation team', $message, $this->input->post('director'), '');
            }

            if($this->input->post('status') == 'PE_REJECTED') {
                $message = $this->fiRegRejectionEmail($this->input->post('pe_comment'));
                $success= emailCheck('Financial Institution Rejection Acknowledgement', $message, $data['user']['email'], '');
            }
        }
    }


    function fiRegEmail($name = "") {
        $emialtem = "<html>";
        $emialtem .="<div>Dear Sir/ Ma’am,</div>";
        $emialtem .="<div>&nbsp;</div>";
        $emialtem .="<div>&nbsp;</div>";
        $emialtem .="This is to inform you that _".$name."_ (name of FI/ bank) has register at ADEETIE portal and is pending at your end for approval. Request you to approve.";
        $emialtem .="<div>&nbsp;</div>";
        $emialtem .="<div>&nbsp;</div>";
        $emialtem .="Regards,";
        $emialtem .="Bureau of Energy Efficiency - Facilitation Centre Project";
        $emialtem .="4th Floor, Sewa Bhawan, R. K. Puram";
        $emialtem .="New Delhi - 110066";
        $emialtem .="</html>";
        return $emialtem;
    }


    function fiRegRejectionEmail($reason) {
        $emialtem = "<html>";
        $emialtem .="<div>Dear Sir/ Ma’am,</div>";
        $emialtem .="<div>&nbsp;</div>";
        $emialtem .="<div>&nbsp;</div>";
        $emialtem .="This is to inform you that Your registration has been rejected, Due to below reason:";
        $emialtem .="<div>".$reason."</div>";
        $emialtem .="<div>&nbsp;</div>";
        $emialtem .="Regards,";
        $emialtem .="Bureau of Energy Efficiency - Facilitation Centre Project";
        $emialtem .="4th Floor, Sewa Bhawan, R. K. Puram";
        $emialtem .="New Delhi - 110066";
        $emialtem .="</html>";
        return $emialtem;
    }



    function checkuser() {

    }


}