public function get_fleetsonnotprintspj() { $date = Input::get('date', date('Y-m-d')); $pool_id = Auth::user()->pool_id; $timestamp = strtotime($date); /* $fleets_on_not_printspj = Scheduledate::join('schedules','schedules.id','=','schedule_dates.schedule_id') ->join('fleets', 'fleets.id', '=', 'schedules.fleet_id' ) //->join('ksos', 'ksos.fleet_id', '=', 'schedules.fleet_id' ) //->where_in('schedule_dates.schedule_id', $arrayschedule ) //->where('ksos.actived','=',1) ->where('schedules.pool_id', '=', $pool_id ) ->where('schedule_dates.date', '=', date('j', $timestamp)) ->where('schedules.month','=',date('n', $timestamp )) ->where('schedule_dates.fg_check','=',0) ->order_by('fleets.taxi_number','asc') ->get(array('schedule_dates.id as id','schedule_dates.driver_id','schedules.fleet_id','fleets.taxi_number')); */ $arrayschedule = array(); $schedule = Schedule::where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(array('id', 'fleet_id')); foreach ($schedule as $sc) { $arrayschedule[] = $sc->id; } $fleets_on_not_printspj = array(); if (is_array($arrayschedule) && !empty($arrayschedule)) { $fleets_on_not_printspj = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->join('fleets', 'fleets.id', '=', 'schedules.fleet_id')->where_in('schedule_dates.schedule_id', $arrayschedule)->where('schedules.pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.date', '=', date('j', $timestamp))->where('schedule_dates.fg_check', '=', 0)->order_by('fleets.taxi_number', 'asc')->get(array('fleets.taxi_number', 'schedule_dates.id as id')); } $datas = array_map(function ($object) { return $object->to_array(); }, $fleets_on_not_printspj); return Response::json($datas); }
public function get_checkout() { $callback = Input::get('callback'); $id = Input::get('schedule_id'); $fleets = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->join('fleets', 'fleets.id', '=', 'schedules.fleet_id')->join('drivers', 'drivers.id', '=', 'schedule_dates.driver_id')->where('schedule_dates.id', '=', $id)->first(); $fleetdatas = $fleets->to_array(); return Response::jsonp($callback, $fleetdatas); }
public function post_search() { $jsondata = Input::json(); $date = $jsondata->date; $timestamp = strtotime($date); //list armada on schedule $arrayschedule = array(); $schedule = Schedule::where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(array('id', 'fleet_id')); foreach ($schedule as $sc) { $arrayschedule[] = $sc->id; } $fleets = array(); if (is_array($arrayschedule) && !empty($arrayschedule)) { $fleets = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->join('fleets', 'fleets.id', '=', 'schedules.fleet_id')->join('ksos', 'ksos.fleet_id', '=', 'schedules.fleet_id')->where_in('schedule_dates.schedule_id', $arrayschedule)->where('schedules.pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.date', '=', date('j', $timestamp))->where('schedules.month', '=', date('n', $timestamp))->where('ksos.actived', '=', 1)->where('taxi_number', 'LIKE', '%' . $jsondata->taxi_number . '%')->get(array('schedule_dates.id as id', 'schedule_dates.driver_id', 'schedules.fleet_id', 'fleets.taxi_number')); } $fleetdatas = array_map(function ($object) { return $object->to_array(); }, $fleets); $data['fleet'] = $fleetdatas; return json_encode($data); }
public function post_toolspj() { $date = Input::get('tanggal', date('Y-m-d')); ini_set('max_execution_time', 120); $timestamp = strtotime($date); //list armada on schedule $arrayschedule = array(); $schedule = Schedule::where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(array('id', 'fleet_id')); foreach ($schedule as $sc) { $arrayschedule[] = $sc->id; } $fleets = array(); if (is_array($arrayschedule) && !empty($arrayschedule)) { $fleets = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->join('fleets', 'fleets.id', '=', 'schedules.fleet_id')->join('ksos', 'ksos.fleet_id', '=', 'schedules.fleet_id')->where_in('schedule_dates.schedule_id', $arrayschedule)->where('schedules.pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.date', '=', date('j', $timestamp))->where('schedules.month', '=', date('n', $timestamp))->where('schedule_dates.shift_id', '=', 1)->where('ksos.actived', '=', 1)->order_by('fleets.taxi_number', 'asc')->get(array('schedule_dates.id as id', 'schedule_dates.driver_id', 'schedules.fleet_id', 'fleets.taxi_number')); } if ($fleets) { foreach ($fleets as $f) { $scheduledate = Scheduledate::find($f->id); $scheduledate->fg_check = 1; $scheduledate->save(); $schedule = Schedule::find($scheduledate->schedule_id); //$driverinfo = Driver::find($scheduledate->driver_id); //$fleetinfo = Fleet::find($schedule->fleet_id); $ksoinfo = Kso::where_fleet_id($schedule->fleet_id)->where_actived(1)->first(); $dateopertion = mktime(0, 0, 0, $schedule->month, $scheduledate->date, $schedule->year); $checkouts = Checkout::where_fleet_id($schedule->fleet_id)->where_operasi_time(date('Y-m-d', $dateopertion))->first(); //delete checkouts if ($checkouts) { $checkouts->delete(); } $codeops = 1; $status = 7; $keterangan = 'Print SPJ melalui Tools'; if (!$checkouts) { //insert into to checkouts step $checkouts = new Checkout(); $checkouts->kso_id = $ksoinfo->id; $checkouts->operasi_time = date('Y-m-d', $dateopertion); $checkouts->fleet_id = $schedule->fleet_id; $checkouts->driver_id = $scheduledate->driver_id; $checkouts->checkout_step_id = $status; $checkouts->shift_id = $scheduledate->shift_id; $checkouts->user_id = Auth::user()->id; $checkouts->pool_id = Auth::user()->pool_id; $checkouts->printspj_time = date('Y-m-d H:i:s', Myfungsi::sysdate()); $checkouts->operasi_status_id = $codeops; $checkouts->keterangan = $keterangan; $checkouts->save(); $cinada = Checkin::where('operasi_time', '=', date('Y-m-d', $dateopertion))->where('fleet_id', '=', $schedule->fleet_id)->first(); if ($cinada) { $cinada->delete(); } if (!$cinada) { $cin = Checkin::create(array('kso_id' => $ksoinfo->id, 'fleet_id' => $schedule->fleet_id, 'driver_id' => $scheduledate->driver_id, 'checkin_time' => date('Y-m-d H:i:s', Myfungsi::sysdate()), 'shift_id' => $scheduledate->shift_id, 'km_fleet' => 0, 'rit' => 0, 'incomekm' => 0, 'operasi_time' => date('Y-m-d', $dateopertion), 'pool_id' => Auth::user()->pool_id, 'operasi_status_id' => $codeops, 'fg_late' => '', 'checkin_step_id' => 2, 'document_check_user_id' => Auth::user()->id, 'physic_check_user_id' => '', 'bengkel_check_user_id' => '', 'finance_check_user_id' => '', 'keterangan' => $keterangan)); if ($cin) { $docs = new Checkindocument(); $docs->checkin_id = $cin->id; $docs->save(); //return Redirect::to('schedule'); } // } } } return Redirect::to('schedule'); } }
public function get_ExportJhoHarianPdf($date = false) { if (!$date) { $date = date('Y-m-d'); } $timestamp = strtotime($date); $arrayschedule = array(); $schedule = Schedule::where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(array('id', 'fleet_id')); foreach ($schedule as $sc) { $arrayschedule[] = $sc->id; } $this->data['scheduleday'] = array(); if (is_array($arrayschedule) && !empty($arrayschedule)) { $this->data['scheduleday'] = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->where_in('schedule_dates.schedule_id', $arrayschedule)->where('schedules.pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.date', '=', date('j', $timestamp))->get(array('schedule_dates.id as id', 'schedule_dates.driver_id', 'schedules.fleet_id', 'schedule_dates.fg_check')); } $this->data['tanggal'] = Myfungsi::fulldate($timestamp); /* ob_start(); echo View::make('themes.modul.'.$this->report.'.scheduleharian',$this->data); $content = ob_get_clean(); try { $html2pdf = new HTML2PDF('P', 'A4', 'en'); $html2pdf->pdf->SetDisplayMode('fullpage'); //$html2pdf->pdf->SetProtection(array('print'), 'spipu'); $html2pdf->writeHTML($content, isset($_GET['vuehtml'])); return Response::make($html2pdf->Output(), 200, array('Content-type' => 'application/pdf')); } catch(HTML2PDF_exception $e) { echo $e; exit; } */ return View::make('themes.modul.' . $this->report . '.scheduleharian', $this->data); }
foreach ($scdul as $as) { // loop schedule date / driver $scheduledate = Scheduledate::where('schedule_id', '=', $as->id)->group_by('driver_id')->get(array('driver_id')); foreach ($scheduledate as $gdriver) { if (!in_array($gdriver->driver_id, $driver_ar)) { array_push($driver_ar, $gdriver->driver_id); } } } } /********************************/ /* Proses Pembuatan Jadwal View */ /********************************/ if (is_array($driver_ar) && !empty($driver_ar)) { foreach ($driver_ar as $key => $value) { $a = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->where('schedules.month', '=', date('n', $timestamp))->where('schedules.year', '=', date('Y', $timestamp))->where('pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.driver_id', '=', $value)->get(); $free = array(); // prosess pembentukan jadwal per pengemudi dalam group foreach ($a as $aa) { //echo 'Tanggal '. $aa->date .' di bawa pengemudi ' . $aa->driver_id ; //echo '<br>'; array_push($free, $aa->date); } // DISPLY PENGEMUDI echo '<tr>'; echo '<td>'; echo 'Driv ' . $value; //$kso = Kso::where_bravo_driver_id($value)->where_actived(1)->first(); //if($kso) echo Fleet::find($kso->fleet_id)->taxi_number; echo '</td>'; echo '<td>';