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

class Fc extends CI_Controller {

    private $appStatus = [];

    function __construct() { 
        parent::__construct();
        $this->load->library('pagination');

        if($this->session->userdata('module') != 'fc') {
            redirect('fauth', 'refresh');
        }
        $user_detail = $this->session->has_userdata('email_id');
        if(empty($user_detail)) {
            redirect('fauth', 'refresh');
        }

        $this->fetch_app_status();
    }


    function fetch_app_status() {
        $data1 = $this->mwillingstatus->get_app_statuscount();
        $data['appstatus'] = [];
       if(!empty($data1)) {
           foreach($data1 as $res => $val) {
              $data['appstatus'][$val['pmu_approve_status']] = $val['total'];
           }
       }

       $this->appStatus = $data['appstatus'];
    }

    function index() {

        $data['ters'] =  $this->mter->get_ter_count();
        $data['appstatus'] = $this->appStatus;
        $data['rejected'] = $this->mwillingstatus->get_final_appl_status('rejected');

    
        // Sanctioned Start

        $disb = $this->mwillingness->get_total_app_status('disbursed');
        $sanctioned = $this->mwillingness->get_total_app_status('sanctioned');
        $data['sanctioned']= ($disb + $sanctioned);

        $data['tapp'] = $this->mwillingstatus->get_total_application();
        $this->load->vars($data);
        $this->load->view('facilation/layout/template', ['page'=> 'facilation/dashboard/sda']);
    }


    function Willingness($pagenum = 1) {
        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";

        
		
		$config['base_url'] = base_url('fc/willingness');
	
		$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['reuse_query_string'] = true;
        $config['use_page_numbers'] = 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['page_num'] = $pagenum; 
       $this->load->vars($data);
       $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/willingnewss-list']);
    }
  

    function workshop($pagenum = 1) {
		$config['base_url'] = base_url('fc/workshop');
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
        $data['sno'] = ($pagenum - 1)*10;
		$config['total_rows'] = $this->mfc->get_total_workshop();
        $config['use_page_numbers'] = TRUE;
		$this->pagination->initialize($config);
       $data['workshops'] = $this->mfc->get_all_workshop($limit, $offset);
       $this->load->vars($data);
       $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/workshop-list']);
    }


    function wuser($workshopid) {
       $data['users'] = $this->mfc->get_workshop_participants($workshopid);
       $this->load->vars($data);
       $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/regsitered-user-list']);
    }


    function form($pagenum = 1) {
        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
		$this->load->library('pagination');
        $config['use_page_numbers'] = TRUE;
		$config['base_url'] = base_url('fc/form');
        
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
	
		$config['total_rows'] = $this->appStatus['pending'];
		$this->pagination->initialize($config);

        $data['page_num'] = $pagenum;
        $data['forms'] = $this->mwillingness->get_pmustatus_list($limit, $offset, 'pending');
        $this->load->vars($data);
        $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/willingnewss-list']);
     }


     function project_edit($id) {
       $appnumber = $this->uri->segment(4);
       if(empty($appnumber ) || empty($id)) {
            redirect('fc/willingness');
       }

       $this->load->library('form_validation');
       $this->form_validation->set_rules('project_cost', 'Project Cost', 'required');
       $this->form_validation->set_rules('loan_amount', 'Loan amount', 'required');
       $this->form_validation->set_rules('cost_of_ee_measures', 'Cost of ee measures', 'required');
       $this->form_validation->set_rules('details_of_ee_measure', 'Details of ee measure', 'required');

       if($this->form_validation->run() == FALSE) {
            $data['project'] = $this->mwillingness->get_project_byid($id);
            $this->load->vars($data);
            $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/project-edit']);
       } else {
            $this->mwillingness->update_project($id, $appnumber);
       }  
     }

    function ter($pagenum = 1) {
        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
		$this->load->library('pagination');
        $config['use_page_numbers'] = TRUE;
		$config['base_url'] = base_url('fc/ter');
	
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;
        
        $ter = $this->mter->get_ter_form($limit, $offset);
	
		$config['total_rows'] = $ter['count'];
		$this->pagination->initialize($config);

       $data['page_num'] = $pagenum;
       $data['forms'] = $ter['data'];
       $this->load->vars($data);
       $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/willingnewss-list']);
    }


    
    function closed($pagenum = 1) {
        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
		$this->load->library('pagination');
        $config['use_page_numbers'] = TRUE;
		$config['base_url'] = base_url('fc/closed');
	
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
	
		$config['total_rows'] = $this->appStatus['closed'];
		$this->pagination->initialize($config);

       $data['page_num'] = $pagenum;
       $data['forms'] = $this->mwillingness->get_pmustatus_list($limit, $offset, 'closed');
       $this->load->vars($data);
       $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/willingnewss-list']);
    }


    function financed($pagenum = 1) {
        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
		$this->load->library('pagination');
        $config['use_page_numbers'] = TRUE;
		$config['base_url'] = base_url('fc/financed');
	
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
	
		$config['total_rows'] = $this->appStatus['financed'];
		$this->pagination->initialize($config);

       $data['page_num'] = $pagenum;
       $data['forms'] = $this->mwillingness->get_pmustatus_list($limit, $offset, 'approved');
       $this->load->vars($data);
       $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/willingnewss-list']);
    }


    function inprogress($pagenum = 1) {
        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
		$this->load->library('pagination');
        $config['use_page_numbers'] = TRUE;
		$config['base_url'] = base_url('fc/inprogress');
	
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
	
		$config['total_rows'] = $this->mwillingness->get_total_app('inprogress');
		$this->pagination->initialize($config);
        $data['page_num'] = $pagenum;
        $data['forms'] = $this->mwillingness->get_pmustatus_list($limit, $offset, 'inprogress');
        $this->load->vars($data);
        $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/willingnewss-list']);
     }

     function rejected($pagenum = 1) {
        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
		$this->load->library('pagination');
        $config['use_page_numbers'] = TRUE;
		$config['base_url'] = base_url('fc/rejected');
	
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
	
		$config['total_rows'] = $this->mwillingness->get_total_app('rejected');
		$this->pagination->initialize($config);

        $data['page_num'] = $pagenum;
        $data['forms'] = $this->mwillingness->get_pmustatus_list($limit, $offset, 'rejected');
        $this->load->vars($data);
        $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/willingnewss-list']);
     }


     function sactioned($pagenum = 1) {
        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
		$this->load->library('pagination');
        $config['use_page_numbers'] = TRUE;
		$config['base_url'] = base_url('fc/sactioned');
	
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
	
		$disb = $this->mwillingness->get_total_app_status('disbursed');
        $sanctioned = $this->mwillingness->get_total_app_status('sanctioned');
        $config['total_rows'] = ($disb + $sanctioned);
		$this->pagination->initialize($config);
        $data['page_num'] = $pagenum;
        $data['forms'] = $this->mwillingness->get_app_status($limit, $offset, 'sanctioned');
        $data['forms2'] = $this->mwillingness->get_app_status($limit, $offset, 'disbursed');
        $this->load->vars($data);
        $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/willingnewss-list']);
     }


     function company($pagenum = 1) {
        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
		$this->load->library('pagination');
        $config['use_page_numbers'] = TRUE;
		$config['base_url'] = base_url('fc/company');
	
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
	
		$config['total_rows'] = $this->mwillingness->get_total_app('pending');
		$this->pagination->initialize($config);
        $data['page_num'] = $pagenum;
        $data['forms'] = $this->mwillingness->get_registered_company($limit, $offset, 'pending');
        $this->load->vars($data);
        $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/willingnewss-list']);
     }


     function queryraised($pagenum = 1) {
        $search = !empty($_REQUEST['search']) ? $_REQUEST['search']: "";
		$this->load->library('pagination');
        $config['use_page_numbers'] = TRUE;
		$config['base_url'] = base_url('fc/queryraised');
	
		$limit = 10; 
        $offset = ($pagenum - 1) * $limit;
	
	
		$config['total_rows'] = $this->mwillingness->get_total_app('queryraised');
		$this->pagination->initialize($config);
        $data['page_num'] = $pagenum;
        $data['forms'] = $this->mwillingness->get_pmustatus_list($limit, $offset, 'queryraised');
        $this->load->vars($data);
        $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/willingnewss-list']);
     }


    public function editwillingness($id) {
        $this->load->library('form_validation');     
        $this->form_validation->set_rules('pmu_approve_status', 'FC Approval Status', 'required');
        $this->form_validation->set_rules('remarks', 'Fc comments', 'required');

        if ($this->form_validation->run() == false) {

            $data['detail'] = $this->mwillingness->get_form_byid($id);
            $data['enableForm'] = true;
            $data['fcstatus'] = $this->mwillingstatus->get_all_status($id);
            $this->load->vars($data);
            $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/form-status']);

        } else {

            $pmustatus = $this->input->post('pmu_approve_status');
            $this->mwillingstatus->create_status($id);


            if($pmustatus == 'approved') {
                $file = $this->uploadImage();
                if(!empty($file['filename'])) {
                    $path = "static/form/".$file['filename'];
                    $this->mwillingness->update_willingness($path, $id);  
                } else {
                    $this->session->set_flashdata('error', 'File uploadation failed');
                    redirect('fc/editwillingness/'.$id);
                }
            } else {
                $this->mwillingness->update_willingness('', $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');
    }


    public function registeredcompany($pageNo = 1) {

        $this->load->library('pagination');
        $config['base_url'] = base_url('fc/registeredcompany');
        $config['total_rows'] = $this->mwillingness->get_total_company();
        $config['per_page'] = 20;
        $config['use_page_numbers'] = TRUE;
        $this->pagination->initialize($config);

        $limit = 20; 
        $offset = ($pageNo - 1) * $limit;
        $data['forms'] = $this->mwillingness->get_registered_company($limit, $offset);
        $this->load->vars($data);
        $this->load->view('facilation/layout/template', ['page'=> 'facilation/form/user-list']);
    }


    public function delete_reg_company($id) {
        $this->db->where('id', $id);
        $this->db->delete('users');
        $this->session->set_flashdata('message','Successfully Deleted'); 
        redirect('fc/registeredcompany', 'refresh');
    }

    function application($appNumber) {
        $sector = $this->home_model->sector();
        $bank = $this->beneficiary_model->getBankDetails();
        $data['sector'] = array_column($sector,"name","sectorid");
        $data['appNumber']  = $appNumber;
        $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('facilation/layout/template', ['page'=> 'facilation/form/willingness-detail']);
   }


    function uploadImage() {
        $config['upload_path'] = './static/form/';
        $config['allowed_types'] = 'gif|jpg|png|JPG|PDF|pdf';
        $config['max_size']	= '100000';
        $this->load->library('upload', $config);
        if (!$this->upload->do_upload()) {
            $error = $this->upload->display_errors();
           return $data = ['status' => 'failed', 'filename' => ''];
        } else {
            $data = $this->upload->data();
            return $ndata = ['status' => 'success', 'filename' => $data['file_name']];
        }
    }


    // User start
    // All user operation
    // user related ui is available in view

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

    
    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->form_validation->run() == FALSE) {
            $this->load->view('facilation/layout/template', ['page'=> 'facilation/user/user-add']);
        } else {
            $this->mfc->add_user();
        }
    }


    public function edituser($id) {
        $this->load->library('form_validation'); 
        $this->form_validation->set_rules('name','Name','required');
      
        if ($this->form_validation->run() == false) {
            $data['user'] = $this->mfc->get_user_byid($id);
            $this->load->vars($data);
            $this->load->view('facilation/layout/template', ['page'=> 'facilation/user/user-add']);

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

    public function deleteuser($id) {
        $this->mfc->delete_user($id);
    }


    public function registeredfis($pageNo = 1) {

        $this->load->library('pagination');
        $config['base_url'] = base_url('fc/registeredfis');
        $config['total_rows'] = $this->mfi->get_registered_fiforfc();
        $config['per_page'] = 20;
        $config['use_page_numbers'] = TRUE;
        $this->pagination->initialize($config);

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

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

    public function editfi($id) {
      
        $this->load->library('form_validation');
        $this->form_validation->set_rules('bank_code','Bank code','required');
        $this->form_validation->set_rules('status','Status','required');
        $this->form_validation->set_rules('fc_comment','FC Comment','required');
      
        if($this->input->post('status') == 'FC_RECOMMENDED') {
            $this->form_validation->set_rules('project_engineer','Project Engineer','required');
        }

        $data = [];
        $reason = $this->input->post('fc_comment');
        $data['action'] = 'edit';
        $data['pelist'] = $this->mbeeuser->get_ac_user('pe');
        $data['user'] = $this->mfi->get_form_byid($id);
        if($this->form_validation->run() == FALSE) {

            $data['bank']   = $this->mbank->get_bank_all();
            $this->load->vars($data);
            $this->load->view('facilation/layout/template', ['page'=> 'facilation/user/fi_user_edit']);

        } else {

            $path = '';
            $file = $this->uploadImage();
            if(!empty($file['filename'])) {
                $path = "static/form/".$file['filename'];
            }

            $this->mfi->update_fi_fc($id, $path);

            if($this->input->post('status') == 'FC_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 Facilitation Centre team', $message, [$this->input->post('project_engineer')]);
            } elseif($this->input->post('status') == 'FC_REJECTED') {
               $message = $this->fiRegRejectionEmail($reason);
               $this->session->set_flashdata('message', 'Your details submit successfully !');
               $success= emailCheck('Acknowledgment of FI registration', $message, [$data['user']['email']]);
            }

        }
    }

    public function deletefi($id) {
        if(!empty($id)) {
            $this->mfi->delete_fi($id);
        }
    }


    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;
    }


}