File: /var/www/html/pmw24/app/application/controllers/admin/Servicedue.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Servicedue extends MY_Controller {
public function __construct() {
parent::__construct();
$this->redirect_guest();
$this->admin=$this->session->userdata('admin');
$this->load->model('admin/mservicedue');
$this->load->model('admin/mcar');
}
public function index() {
$this->_load_list_view();
}
private function _load_list_view() {
$condition = array();
//$data['cars'] = $this->mservicehistory->getRows('car',$condition);
$data['content'] = 'admin/servicedue/list';
$this->load->view('admin/layouts/index', $data);
}
public function all_content_list(){
$s_date = $_POST['start_date'];
$e_date = $_POST['end_date'];
$service_id=$_POST['service_id'];
// $s_date = '01/07/2019';
// $e_date = '13/03/2020';
$s_date_array = explode('/',$s_date);
$start_date = $s_date_array[2]."-".$s_date_array[1]."-".$s_date_array[0];
$e_date_array = explode('/',$e_date);
$end_date = $e_date_array[2]."-".$e_date_array[1]."-".$e_date_array[0];
$list = $this->mservicedue->get_datatables($start_date,$end_date,$service_id);
//print_r($list); die;
$data = array();
$no = $_POST['start'];
$i=1;
if($no>1)
{
$i=$i*$no+1;
}
foreach ($list as $person) {
$no++;
$row = array();
$row[]=$i;
$row[]=$person->service_name;
$row[]=$person->car_no;
$row[]=date("d-m-Y", strtotime($person->next_service_date));
$row[] = '<a class="cstm_view" id="view" style="padding-left:5px" href="javascript:void(0)" title="'.$person->job_service_date_id.'"><i class="glyphicon glyphicon-pencil"></i>';
$data[] = $row;
$i++;
}
//print_r($i); die;
$output = array(
"draw" => $_POST['draw'],
"recordsTotal" => $this->mservicedue->count_all($start_date,$end_date,$service_id),
"recordsFiltered" => $this->mservicedue->count_filtered($start_date,$end_date,$service_id),
"data" => $data,
);
echo json_encode($output);
}
public function all_content_list1(){
$s_date = '15/02/2019';
$e_date = '30/03/2019';
// $s_date = $_POST['start_date'];
// $e_date = $_POST['end_date'];
$s_date_array = explode('/',$s_date);
$start_date = $s_date_array[2]."-".$s_date_array[1]."-".$s_date_array[0];
$e_date_array = explode('/',$e_date);
$end_date = $e_date_array[2]."-".$e_date_array[1]."-".$e_date_array[0];
$list = $this->mservicedue->get_datatables1($start_date,$end_date);
$data = array();
$no = $_POST['start'];
$i=0;
foreach ($list as $person) {
$no++;
$row = array();
$res['car']=$this->mcar->get_details($person[0]);
$row[] = $res['car']['car_no'];
$row[] = $person[1];
$row[] = $person[2];
$row[] = $person[3];
$data[] = $row;
$i++;
}
//print_r($i); die;
$output = array(
"draw" => $_POST['draw'],
"recordsTotal" => $i,
"recordsFiltered" => $i,
"data" => $data,
);
echo json_encode($output);
}
public function all_content_list_csv(){
$s_date = $_POST['start_date'];
$e_date = $_POST['end_date'];
$s_date_array = explode('/',$s_date);
$start_date = $s_date_array[2]."-".$s_date_array[1]."-".$s_date_array[0];
$e_date_array = explode('/',$e_date);
$end_date = $e_date_array[2]."-".$e_date_array[1]."-".$e_date_array[0];
$filename= 'due_service_report'.time().'.csv';
if($_POST['service_id']!='')
{
$list = $this->mservicedue->get_data_excel($start_date,$end_date,$_POST['service_id']);
}
else
{
$list = $this->mservicedue->get_data_excel($start_date,$end_date);
}
$row1 = array('SL No','Service Name','Car No','Due Date');
$data[] = $row1;
$i=0;
foreach ($list as $person) {
$i++;
$row = array();
$row[]=$i;
$row[]=$person->service_name;
$row[]=$person->car_no;
$row[]=date("d-m-Y", strtotime($person->next_service_date));
$data[] = $row;
}
@array_to_csv($data,$filename);
echo $filename;
}
public function all_details(){
$job_id = $this->input->post('job_id');
$car_id = $this->input->post('car_id');
$services = $this->mservicehistory->get_details($job_id);
foreach($services as $key=>$service)
{
$condition = array("service_id"=>$service['service_id']);
$task = $this->mservicehistory->getRows('task',$condition);
$services[$key]['task'] = $task;
}
$result['services'] = $services;
$car_condition = array("car_id"=>$car_id);
$car = $this->mservicehistory->getRow('car',$car_condition);
$result['car'] = $car;
echo json_encode($result);
}
public function details(){
$job_id = $this->input->post('job_id');
$condition = array("job_service_date_id"=>$job_id);
$result = $this->mservicedue->get_Row($job_id);
echo json_encode($result);
}
public function update(){
//echo "okkk";die;
if($this->input->post()){
$job_id = $this->input->post('job_id');
$due_date = $this->input->post('due_date');
$condition=array('job_service_date_id'=>$job_id);
$date_array = explode('/',$due_date);
$newdueDate = $date_array[2]."-".$date_array[1]."-".$date_array[0];
$udata['next_service_date']=$newdueDate;
$udata['next_service_date_reminder_before_seven'] = date('Y-m-d', strtotime($newdueDate. ' - 7 days'));
$udata['next_service_date_before_three'] = date('Y-m-d', strtotime($newdueDate. ' - 3 days'));
$this->mservicedue->update_due_date($condition,$udata);
$response=array('status'=>1,'message'=>'Due Date updated successfully');
echo json_encode($response);
}else{
$this->_load_list_view();
}
}
//////////////////////data insert/////////////////////////////
// public function data_import(){
// $CI1 =& get_instance();
// $CI1->db->select('*');
// $CI1->db->from('job_services');
// $where1 = "service_id IN (7,8,20)";
// $CI1->db->where($where1);
// $query1=$CI1->db->get();
// $jobs = $query1->result_array();
// // echo '<pre>';
// // print_r($jobs); die;
// foreach($jobs as $row){
// $condition['job_id']=$row['job_id'];
// $job_date_data=$this->mcommon->getRow('job_service_date',$condition);
// $udata=array();
// $udata['job_id']=$row['job_id'];
// $udata['service_id']=$row['service_id'];
// $udata['car_id']=$job_date_data['car_id'];
// $udata['service_date']=$job_date_data['service_date'];
// $udata['next_service_date']=$job_date_data['next_service_date'];
// $udata['next_service_date_reminder_before_seven']=$job_date_data['next_service_date_reminder_before_seven'];
// $udata['next_service_date_before_three']=$job_date_data['next_service_date_before_three'];
// $udata['service_end_date']=$job_date_data['service_end_date'];
// $udata['service_end_time']=$job_date_data['service_end_time'];
// $this->mcommon->insert('job_service_date_specific',$udata);
// //echo $this->db->last_query();die;
// }
// echo 'done'; die;
// }
}