<span class="block-icon pull-right"> </span> <a href="#widgetGroup1" data-toggle="collapse">Daftar Armada Perserta KSO</a> </div> <div class="block-body collapse in" id="widgetGroup1"> <table class="table"> @foreach(Pool::all() as $pool) <tr> <td> {{$pool->pool_name}} </td> </tr> <tr> <td> <?php $ksos = Fleet::join('ksos', 'fleets.id', '=', 'ksos.fleet_id')->where_in('ksos.actived', array(1, 2))->where('fleets.pool_id', '=', $pool->id)->get(array('ksos.id', 'fleets.taxi_number', 'fleets.id as fleet_id')); ?> @foreach($ksos as $kso) {{ HTML::link('ksos/ksofleet/'.$kso->fleet_id ,$kso->taxi_number,array('class'=>'btn btn-mini btn-success')) }} @endforeach </td> </tr> @endforeach </table> </div> </div> @endsection @section('otherscript')
public function get_detail($id = false, $id_group = false) { if (!$id || !$id_group) { return false; } $group = Schedulegroup::find($id_group); $interval = Schedulemaster::find($group->schedule_master_id); $dayofmonth = array(); $optionsmonth = array(); $optionsyears = array(); for ($i = 1; $i <= $interval->bravo_interval + 1; $i++) { $dayofmonth[$i] = $i; } for ($month = 1; $month <= 12; $month++) { $optionsmonth[$month] = Myfungsi::bulan($month); } for ($year = date('Y'); $year < date('Y') + 3; $year++) { $optionsyears[$year] = $year; } $this->data['fleets'] = Schedulefleetgroup::where('schedule_group_id', '=', $id_group)->get(); $this->data['group'] = Schedulegroup::find($id_group); $this->data['dayofmonth'] = $dayofmonth; $this->data['months'] = $optionsmonth; $this->data['years'] = $optionsyears; $this->data['shifts'] = Koki::to_dropdown(Shift::all(), 'id', 'shift'); $this->data['fleetinfo'] = Fleet::join('ksos', 'fleets.id', '=', 'ksos.fleet_id')->where('ksos.fleet_id', '=', $id)->where('ksos.actived', '=', 1)->where('fleets.pool_id', '=', Auth::user()->pool_id)->first(); //->get(array('fleets.*','ksos.bravo_driver_id', 'ksos.charlie_driver_id')); return View::make('themes.modul.' . $this->views . '.setholiday', $this->data); }
public function get_bp() { $pool_id = Auth::user()->pool_id; $this->data['fleetsbp'] = Fleet::join('ksos', 'fleets.id', '=', 'ksos.fleet_id')->where('ksos.actived', '=', 1)->where('fleets.fg_bp', '=', 1)->where('fleets.pool_id', '=', $pool_id)->order_by('fleets.taxi_number', 'asc')->get(array('fleets.taxi_number', 'fleets.id')); return View::make('themes.modul.' . $this->views . '.bp', $this->data); }
//membuat yang aktif tidak ada tapi yang gugur ada $active = Kso::where('fleet_id', '=', $kso->fleet_id)->where('actived', '=', 1)->get(); ?> @if(!$active) {{ HTML::link('ksos/ksofleet/'.$kso->fleet_id ,$kso->taxi_number,array('class'=>'btn btn-mini btn-success')) }} @endif @endforeach </td> </tr> <tr> <td><span class="label label-important">KSO SELESAI</span></td> </tr> <tr> <td> <?php $ksos = Fleet::join('ksos', 'fleets.id', '=', 'ksos.fleet_id')->where('ksos.actived', '=', 3)->where('ksos.pool_id', '=', $pool->id)->group_by('fleets.id')->order_by('fleets.taxi_number', 'asc')->get(array('ksos.id', 'fleets.taxi_number', 'fleets.id as fleet_id')); ?> @foreach($ksos as $kso) {{ HTML::link('ksos/ksofleet/'.$kso->fleet_id ,$kso->taxi_number,array('class'=>'btn btn-mini btn-success')) }} @endforeach </td> </tr> </table> </td> </tr> @endforeach </table> </div> </div>
public function get_allFleet() { $query = Input::get('query'); $fleets = Fleet::join('pools', 'pools.id', '=', 'fleets.pool_id')->join('ksos', 'ksos.fleet_id', '=', 'fleets.id')->join('drivers', 'drivers.id', '=', 'ksos.bravo_driver_id')->where('ksos.actived', '=', 1)->where('ksos.pool_id', '=', Auth::user()->pool_id)->where('fleets.taxi_number', 'LIKE', '%' . $query . '%')->get(array('ksos.id as kso_id', 'fleets.id', 'fleets.taxi_number', 'fleets.police_number', 'pools.pool_name', 'pools.id as pool_id', 'drivers.name', 'drivers.nip', 'drivers.id as driver_id')); $fleetdatas = array_map(function ($object) { return $object->to_array(); }, $fleets); return json_encode($fleetdatas); }
public function post_searchFleet() { $jsondata = Input::json(); $pool_id = Auth::user()->pool_id; //$fleets = Fleet::where_pool_id($pool_id)->where('taxi_number','LIKE','%'.$jsondata->taxi_number.'%')->get(array('fleets.taxi_number', 'fleets.id', 'ksos.id as kso_id')); //$fleets = Fleet::join('ksos', 'fleets.id', '=', 'ksos.fleet_id')->where('ksos.actived', '=', 1)->where('fleets.pool_id', '=', Auth::user()->pool_id)->where('taxi_number','LIKE','%'.$jsondata->taxi_number.'%')->order_by('fleets.taxi_number','asc')->get(array('fleets.taxi_number', 'fleets.id', 'ksos.id as kso_id')); $fleets = Fleet::join('ksos', 'fleets.id', '=', 'ksos.fleet_id')->where('fleets.pool_id', '=', Auth::user()->pool_id)->where('taxi_number', 'LIKE', '%' . $jsondata->taxi_number . '%')->order_by('fleets.taxi_number', 'asc')->get(array('fleets.taxi_number', 'fleets.id', 'ksos.id as kso_id', 'ksos.actived as actived')); /* $fleetdata = array_map(function($object) { return $object->to_array(); }, $fleets); */ $fleetdata = array(); foreach ($fleets as $fleet) { $actived = $fleet->actived == 1 ? 'Active' : 'Gugur'; $fleetdata[] = array('taxi_number' => $fleet->taxi_number . '(' . $actived . ' )', 'id' => $fleet->id, 'kso_id' => $fleet->kso_id); } $data['fleets'] = $fleetdata; return json_encode($data); }