HEX
Server: Apache/2.4.41 (Amazon) OpenSSL/1.0.2k-fips PHP/5.6.40
System: Linux ip-172-31-40-18 4.14.146-93.123.amzn1.x86_64 #1 SMP Tue Sep 24 00:45:23 UTC 2019 x86_64
User: apache (48)
PHP: 5.6.40
Disabled: NONE
Upload Files
File: //var/www/html/pmw24/app/application/controllers/admin/Jobreport_10_11_2025.php
<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Jobreport extends MY_Controller
{
    public function __construct()
    {
        parent::__construct();
        $this->redirect_guest();
        $this->admin = $this->session->userdata('admin');
        $this->load->model('admin/mtyreservicereport');
        $this->load->model('admin/mbookingreport');
    }

    public function index()
    {
        $this->_load_list_view();
    }

    private function _load_list_view()
    {

        $assignjobList = $this->mbookingreport->assignedJob(array());

        $jobList = array();

        if (!empty($assignjobList)) {
            foreach ($assignjobList as $key => $assignjob) {

                $job_condition = array("job_id" => $assignjob['job_id']);
                $job = $this->mcommon->getRow('job', $job_condition);

                //if(!empty($job)){


                $services = $this->mbookingreport->getServices($assignjob['job_id']);

                $service_date_condition = array("job_id" => $assignjob['job_id']);
                $job_service_date = $this->mcommon->getRow("job_service_date", $service_date_condition);


                $car_condition = array("car_id" => $assignjob['car_id']);
                $car = $this->mcommon->getRow('car', $car_condition);

                $assigned_by_condition = array("admin_id" => $assignjob['created_by']);
                $assigned_by = $this->mcommon->getRow('admins', $assigned_by_condition);

                $mechanic_condition = array("admin_id" => $assignjob['mechanic_id']);
                $mechanic = $this->mcommon->getRow('admins', $mechanic_condition);
                //$service = explode(',',$job['service']);



                $jobList[$key]['job_id'] = $assignjob['job_id'];
                $jobList[$key]['service_date'] = $job_service_date['service_date'];
                $jobList[$key]['formatted_service_date'] = date("d/m/Y", strtotime($job_service_date['service_date']));
                $jobList[$key]['company_name'] = $car['company_name'];
                $jobList[$key]['car_no'] = $car['car_no'];
                $jobList[$key]['assigned_by'] = $assigned_by['name'];
                $jobList[$key]['mechanic_name'] = $mechanic['name'];
                $jobList[$key]['job_type'] = ($assignjob['created_by'] == $assignjob['mechanic_id']) ? 2 : 1; //1=>Admin Job,2=>Mechanic Job

                if ($assignjob['job_status'] == 0) {
                    $job_status = "Not Started";
                } else if ($assignjob['job_status'] == 1) {
                    $job_status = "In Progress";
                } else if ($assignjob['job_status'] == 2) {
                    $job_status = "Completed";

                    if (!empty($job_service_date['service_end_date'])) {
                        $job_status = $job_status . ' On ' . date("d/m/Y", strtotime($job_service_date['service_end_date']));
                    }
                }

                if ($assignjob['assign_status'] == 0) {
                    $assign_status = "Rejected";
                } else if ($assignjob['assign_status'] == 1) {
                    $assign_status = "Accepted";
                } else {
                    $assign_status = 'Pending';
                }
                $jobList[$key]['job_status'] =  $job_status;
                $jobList[$key]['assign_status'] = $assign_status;

                $jobList[$key]['service_count'] = sizeof($services);
                $jobList[$key]['paid_or_unpaid'] = $assignjob['paid_or_unpaid'];
            }
        }
        //echo '<pre>';print_r($jobList);die;
        $data['calendar_data'] = $jobList;
        $data['content'] = 'admin/jobreport/list';
        $this->load->view('admin/layouts/index', $data);
    }
}