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