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