EVOLUTION-NINJA

Edit File: Controller.php

<?php

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

// This can be removed if you use __autoload() in config.php OR use Modular Extensions
/** @noinspection PhpIncludeInspection */
require APPPATH . '/libraries/REST_Controller.php';

/**
 * This is an example of a few basic user interaction methods you could use
 * all done with a hardcoded array
 *
 * @package         CodeIgniter
 * @subpackage      Rest Server
 * @category        Controller
 * @Company	        JayBlues Technologies
 * @link            https://github.com/chriskacerguis/codeigniter-restserver
 */
class Controller extends REST_Controller {

function __construct()
    {
        // Construct the parent class
        parent::__construct();
        header('Access-Control-Allow-Origin: *');
        header('Access-Control-Allow-Methods: POST, GET, PUT, DELETE, OPTIONS'); 
        header('Access-Control-Allow-Headers: X-Requested-With, content-type, X-Token, x-token');
        header('Access-Control-Allow-Credentials: true');
        header("Cache-Control: public, max-age=60, s-maxage=60");
        //header('Pragma: no-cache');
       
    }
    
    public function login_post()
    {
        $email    = $this->input->post('email');
        $password = $this->input->post('password');                     
        $result   = $this->Model->admin_login($email,$password);
    
        if($result)
        {   
            $table = 'gss_access_controls';
            $where = array('delete_status'=>'ACTIVE','department_id'=>$result->user_type_id);
            $res   = $this->Model->get_where_result($table,$where);
       
            $result = array(
                            'result'       => 1,
                            'user_type'    => $result->user_type,
                            'user_type_id' => $result->user_type_id,
                            'username'     => $result->username,
                            'admin_id'     => $result->user_id,
                            //'powers'       => $this->session->userdata('powers')
                            );

$message = ['status'=>'Success','message'=> 'User Found','status_code'=>'200','result'=>$result];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (200) being the HTTP response code
        }       
        else
        {
            $message = ['status'=>'Fail','message'=> 'Wrong Credentials','status_code'=>'401','result'=>0];
            $this->set_response($message, REST_Controller::HTTP_UNAUTHORIZED); // CREATED (401) being the HTTP response code  
        }       
    }

public function project_types_get()
    {
        $project_types = ['ONGOING','COMPLETED'];
        if($project_types)
        {
            $message = ['status'=>'Success','message'=> 'Data Found','status_code'=>'200','result'=>$project_types];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (200) being the HTTP response code
        }
        else
        {
            $message = ['status'=>'Fail','message'=> 'Data not found','status_code'=>'200','result'=>0];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (401) being the HTTP response code  
        }
    }

public function project_list_get()
    {
        $project_type = $this->uri->segment(2);
        $result       = $this->Model->projects_list($project_type);
        if($result)
        {
            $message = ['status'=>'Success','message'=> 'Data Found','status_code'=>'200','count'=>count($result),'result'=>$result];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (200) being the HTTP response code
        }
        else
        {
            $message = ['status'=>'Fail','message'=> 'Data not found','status_code'=>'200','result'=>0];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (401) being the HTTP response code  
        }
    }
    
    public function all_projects_get()
    {
        $project_type = $this->uri->segment(2);
        $result       = $this->Model->all_projects_list();
        if($result)
        {
            $message = ['status'=>'Success','message'=> 'Data Found','status_code'=>'200','count'=>count($result),'result'=>$result];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (200) being the HTTP response code
        }
        else
        {
            $message = ['status'=>'Fail','message'=> 'Data not found','status_code'=>'200','result'=>0];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (401) being the HTTP response code  
        }
    }

public function project_details_get()
    {
        $project_id = $this->uri->segment(2);
        $result     = $this->Model->project_details($project_id);
        if($result)
        {
            $message = ['status'=>'Success','message'=> 'Data Found','status_code'=>'200','count'=>count($result),'result'=>$result];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (200) being the HTTP response code
        }
        else
        {
            $message = ['status'=>'Fail','message'=> 'Data not found','status_code'=>'200','result'=>0];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (401) being the HTTP response code  
        }
    }

public function project_site_details_get()
    {
        $project_id  = $this->uri->segment(2);
        $site_number = $this->uri->segment(3);
        $result      = $this->Model->site_details($project_id,$site_number);
        if($result)
        {
            $message = ['status'=>'Success','message'=> 'Data Found','status_code'=>'200','count'=>count($result),'result'=>$result];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (200) being the HTTP response code
        }
        else
        {
            $message = ['status'=>'Fail','message'=> 'Data not found','status_code'=>'200','result'=>0];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (401) being the HTTP response code  
        }
    }

public function forgot_password_post()
    {
        $email       = $this->input->post('email');
        $table       = 'gss_login';
        $where       = array('email'=>$email,'delete_status'=>'ACTIVE');
        $check_email = $this->Model->get_where_row($table,$where);

if($check_email)
        {
            $subject = 'Password Information';
            $message = 'Your password : '.$check_email->password;
            $this->load->library('email');
            $config = array(
                    'protocol'  => 'smtp',
                    'smtp_host' => 'ssl://smtp.googlemail.com',
                    'smtp_port' => 465,
                    'smtp_user' => 'saanviacb@gmail.com',
                    'smtp_pass' => 'SaanvI294',
                    'mailtype'  => 'html',
                    'charset'   => 'utf-8'
                );
                $this->email->initialize($config);
                $this->email->set_mailtype("html");
                $this->email->set_newline("\r\n");
                $this->email->from('info@jayblues.org','GSS'); // change it to yours
                $this->email->to($email,'GSS');// change it to yours
                $this->email->subject($subject);
                $this->email->message($message);  
                $this->email->print_debugger();  
                if ($this->email->send())
                {
                    $message = ['status'=>'Success','message'=> 'Password Information sent successfully','status_code'=>'200','result'=>1];
                    $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (200) being the HTTP response code
                }
                else
                {
                    $message = ['status'=>'Fail','message'=> 'Email count not send','status_code'=>'200','result'=>0];
                    $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (401) being the HTTP response code  
                }
        }
        else
        {
            $message = ['status'=>'Fail','message'=> 'Email not found','status_code'=>'200','result'=>0];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (401) being the HTTP response code  
        }
    }
    
    public function download_sketch_get()
    {
        $project_id  = $this->uri->segment(2);
        $site_number = $this->uri->segment(3);
        $result      = $this->Model->project_site_details($site_number,$project_id);  
        $href        = base_url();
        if($result)
        {
            if(strtoupper($result->status) == "RECEIVED" || strtoupper($result->status) == "RELEASED")
            {
                $north_in_mtrs = $result->north_in_mtrs;
                $value1 = floatval($north_in_mtrs) * 3.2808399;
                $north_in_mtrs_to_ft =  sprintf('%0.2f',$value1);

$east_in_mtrs = $result->east_in_mtrs;
                $value2 = floatval($east_in_mtrs) * 3.2808399;
                $east_in_mtrs_to_ft =  sprintf('%0.2f',$value2);

$south_in_mtrs = $result->south_in_mtrs;
                $value3 = floatval($south_in_mtrs) * 3.2808399;
                $south_in_mtrs_to_ft =  sprintf('%0.2f',$value3);

$west_in_mtrs = $result->west_in_mtrs;
                $value4 = floatval($west_in_mtrs) * 3.2808399;
                $west_in_mtrs_to_ft =  sprintf('%0.2f',$value4);
            }
            else
            {
                $north_in_mtrs_to_ft = 0.0;
                $east_in_mtrs_to_ft  = 0.0;
                $south_in_mtrs_to_ft = 0.0;
                $west_in_mtrs_to_ft  = 0.0;
            }

$pdf_content = '';

$pdf_content .= '<!DOCTYPE HTML>';
            $pdf_content .= '<html lang="en-US">';
            $pdf_content .= '<head>';
            $pdf_content .= '<meta charset="UTF-8">';
            $pdf_content .= '<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">';
            $pdf_content .= '<meta http-equiv="X-UA-Compatible" content="IE=Edge" />';
            $pdf_content .= '<title>Home</title>';

$pdf_content .= '</head>';
            $pdf_content .= '<body style="width: 1000px;">';

$pdf_content .= '<div style="display: table;clear:both;margin: 0 auto;">';
            $pdf_content .= '<div style="display: table-cell;width: 400px;float:left;">';
            $pdf_content .= '<p style="text-decoration: underline;text-align: center;">Site number '.$result->site_number.' - sketch</p>';
            
            $pdf_content .= '<p style="padding-left: 82px;">Note:<br>1 Mtr - 3.281 ft<br>1 SqMtr - 10.764 sft</p>';
            $pdf_content .= '<p style="text-align: center;"><b>Status: <span style="color: green;">'.$result->status.'</span></b></p>';
            
            $pdf_content .= '<table style="border: 2px solid #787a75;margin: 0 auto;padding: 3px;width:325px">';
            $pdf_content .= '<tr>';
            $pdf_content .= '<td><img src="'.$href.'/assets/images/arrow-img1.jpg"/></td>';
            $pdf_content .= '<td style="text-align: center;vertical-align: top;">';
            $pdf_content .= '<span style="display: block;font-size: 14px;">'.$result->north_in_mtrs.' m</span><br/>';
            $pdf_content .= '<span style="display: block;font-size: 14px;">('.$north_in_mtrs_to_ft.' ft)</span>';
            $pdf_content .= '</td>';
            $pdf_content .= '<td><img src="'.$href.'/assets/images/arrow-img2.jpg"/></td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr>';
            $pdf_content .= '<td style="text-align: left;">';
            $pdf_content .= '<span style="display: block;font-size: 14px;">'.$result->west_in_mtrs.' m</span><br/>';
            $pdf_content .= '<span style="display: block;font-size: 14px;">('.$west_in_mtrs_to_ft.' ft)</span>';
            $pdf_content .= '</td>';
            $pdf_content .= '<td style="text-align: center;"><span style="font-size: 30px;">'.$result->site_number.'</span></td>';
            $pdf_content .= '<td style="text-align: right;">';
            $pdf_content .= '<span style="display: block;font-size: 14px;">'.$result->east_in_mtrs.' m</span><br/>';
            $pdf_content .= '<span style="display: block;font-size: 14px;">('.$east_in_mtrs_to_ft.' ft)</span>';
            $pdf_content .= '</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr>';
            $pdf_content .= '<td><img src="'.$href.'/assets/images/arrow-img3.jpg"/></td>';
            $pdf_content .= '<td style="text-align: center;vertical-align: bottom;">';
            $pdf_content .= '<span style="display: block;font-size: 14px;">'.$result->south_in_mtrs.' m</span><br/>';
            $pdf_content .= '<span style="display: block;font-size: 14px;">('.$south_in_mtrs_to_ft.' ft)</span>';
            $pdf_content .= '</td>';
            $pdf_content .= '<td><img src="'.$href.'/assets/images/arrow-img4.jpg"/></td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '</table>';

$total_sq_mtrs = (($result->north_in_mtrs + $result->south_in_mtrs)/2) * (($result->east_in_mtrs + $result->west_in_mtrs)/2);
            $sq_mtrs       = sprintf('%f',$total_sq_mtrs);
            
            $total_sq_ft = ((($result->north_in_mtrs + $result->south_in_mtrs)/2) * (($result->east_in_mtrs + $result->west_in_mtrs)/2))*10.764;
            $sq_ft       = sprintf('%.2f',$total_sq_ft);

$pdf_content .= '<p style="text-align: center;">'.$result->west_in_mtrs.' m * '.$result->north_in_mtrs.' m '.' = '.sprintf('%.2f',$sq_mtrs).' sq mtrs'.'</p>';
            $pdf_content .= '<p style="text-align: center;">'.$west_in_mtrs_to_ft.' ft * '.$north_in_mtrs_to_ft.' ft '.' = '.$sq_ft.' sq ft'.'</p>';
            $pdf_content .= '</div>';

$pdf_content .= '<div style="display: table-cell;width: 200px;vertical-align: middle;padding-left: 50px;padding-top:30px;">';
            $pdf_content .= '<img src="'.$href.'/assets/images/north-img.jpg" />';
            $pdf_content .= '</div>';
            $pdf_content .= '</div>';

$pdf_content .= '<div style="clear:both;padding-top: 25px;padding-bottom: 25px;margin: 0 auto;">';
            $pdf_content .= '<table style="border-collapse: collapse;border:1px solid #757575;margin: 0 auto;width: 600px;">';
            $pdf_content .= '<tr style="background: #F9F9F9;">';
            $pdf_content .= '<th style="padding: 10px;border:1px solid #757575;width: 200px;">PROJECT</th>';
            $pdf_content .= '<th style="padding: 10px;border:1px solid #757575;width: 400px;">'.$result->project_name.'</th>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">SITE NO</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->site_number.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr style="background: #F9F9F9;">';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">NORTH(in mtrs)</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->north_in_mtrs.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">SOUTH(in mtrs)</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->south_in_mtrs.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr style="background: #F9F9F9;">';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">EAST(in mtrs)</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->east_in_mtrs.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">WEST(in mtrs)</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->west_in_mtrs.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr style="background: #F9F9F9;">';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">TOTAL IN SQ MTRS</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->total_in_sqmtrs.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">TOTAL IN SFT</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->total_in_sqft.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr style="background: #F9F9F9;">';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">EAST FACING</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->east_facing.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">WEST FACING</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->west_facing.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr style="background: #F9F9F9;">';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">NORTH FACING</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->north_facing.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '<tr>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">SOUTH FACING</td>';
            $pdf_content .= '<td style="padding: 10px;border:1px solid #757575;">'.$result->south_facing.'</td>';
            $pdf_content .= '</tr>';
            $pdf_content .= '</table>';
            $pdf_content .= '</div>';

$pdf_content .= '<div style="clear:both;padding-top: 25px;padding-bottom: 25px;margin: 0 auto;">';
            $pdf_content .= '<img src="https://www.gssorganised.com/project_uploads/'.$result->approval_image.'" />';
            $pdf_content .= '</div>';

$pdf_content .= '</body>';
            $pdf_content .= '</html>';

$name  = 'sketch_'.$project_id.'_'.$site_number.'.pdf';
            // include_once "mpdf60/mpdf.php";
            // $mpdf=new mPDF('A4'); 
            // $mpdf->mirrorMargins = 1;
            // $mpdf->SetDisplayMode('fullpage');
            // $mpdf->watermark_font = 'DejaVuSansCondensed';
            // $mpdf->showWatermarkText = true;
            // $mpdf->WriteHTML($pdf_content);
            require "vendor/autoload.php";
            $mpdf = new \Mpdf\Mpdf();
            $mpdf->WriteHTML($pdf_content);
            $data = date('d-M-y H:i');
            $pdf=$mpdf->Output("./sketches/".$name, 'F');
            if($name != "")
            {
                $file_path = $href.'/sketches/'.$name;
                $message = ['status'=>'Success','message'=> 'File Found','status_code'=>'200','file_path'=>$file_path];
                $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (200) being the HTTP response code
            }
            else
            {
                $message = ['status'=>'Fail','message'=> 'File cant be downloaded','status_code'=>'200','result'=>0];
                $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (401) being the HTTP response code  
            }
        }
        else
        {
            $message = ['status'=>'Fail','message'=> 'Site details not found','status_code'=>'200','result'=>0];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (401) being the HTTP response code  
        }
    }
    
    
    public function project_sketch_details_get()
    {
        $data['project_id'] = $this->uri->segment(2);
        /*$result     = $this->Model->project_details($project_id);
        if($result)
        {
            $message = ['status'=>'Success','message'=> 'Data Found','status_code'=>'200','count'=>count($result),'result'=>$result];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (200) being the HTTP response code
        }
        else
        {
            $message = ['status'=>'Fail','message'=> 'Data not found','status_code'=>'200','result'=>0];
            $this->set_response($message, REST_Controller::HTTP_OK); // CREATED (401) being the HTTP response code  
        }*/
        $this->load->view('site_available_form',$data);
        
    }
    
    public function get_approved_plan_post()
	{
		$table      = 'gss_new_projects';
		$project_id = $this->input->post('project_id');
		$where      = array('project_id'=>$project_id,'delete_status'=>'ACTIVE','project_status'=>'ONGOING');
		$result     = $this->Model->get_where_row($table,$where);
		if($result)
		{
			echo json_encode(array('approved_plan'=>$result,'result'=>1));
		}
		else
		{
			echo json_encode(array('result'=>0,'message'=>'Approved plan not found'));
		}		
	}
	
		public function sites_status_list_post()
	{
		$project_id = $this->input->post('project_id');
		$result = $this->Model->sites_status_list($project_id);
		if($result)
		{
			echo json_encode(array('site_status_list'=>$result,'result'=>1));
		}
		else
		{
			echo json_encode(array('result'=>0));
		}
	}
	
	public function single_project_sites_post()
	{
		$table       = 'gss_new_sites';
		$project_id  = $this->input->post('project_id');
		$where   	 = array('project_id' => $project_id);
		$order_by    = 'site_number';
		$result 		= $this->Model->single_project_sites($table,$where,$order_by);
		//print_r($result);die();
		if($result)
		{
			echo json_encode(array('result'=>1,'sites'=>$result));
		}
		else
		{
			echo json_encode(array('result'=>0));
		}
	}

}