public function get_downtime()
{
$date = Input::get('date', date('Y-m-d'));
$ksos = Kso::where('pool_id', '=', Auth::user()->pool_id)->where('actived', '=', 1)->get();
$fleets = array();
foreach ($ksos as $fleet) {
array_push($fleets, $fleet->fleet_id);
}
$datax = array();
if (!empty($fleets)) {
$userx = User::where('pool_id', '=', Auth::user()->pool_id)->get();
foreach ($userx as $u) {
$anakasuh = Anakasuh::where_in('anak_asuh.fleet_id', $fleets)->where('anak_asuh.status', '=', 1)->where('anak_asuh.user_id', '=', $u->id)->get(array('anak_asuh.id', 'anak_asuh.fleet_id', 'anak_asuh.user_id'));
$fleetsx = array();
$jumlaharmada = 0;
foreach ($anakasuh as $f) {
array_push($fleetsx, $f->fleet_id);
$jumlaharmada = $jumlaharmada + 1;
}
$selisiks = 0;
if (!empty($fleetsx)) {
$bapakasuh = DB::table('financial_report_monthly_fleet')->where_in('fleet_id', $fleetsx)->where('month', '=', date('n', strtotime($date)))->where('year', '=', date('Y', strtotime($date)))->order_by('selisi_ks', 'asc')->take(10)->get();
foreach ($bapakasuh as $x) {
$selisiks = $selisiks + $x->selisi_ks;
}
//data array selisi ks
$datax[] = array('bapak_asuh' => $u->id, 'selisi_ks' => $selisiks, 'nama' => $u->first_name . ' ' . $u->last_name, 'total_anakasuh' => $jumlaharmada);
}
}
}
/*
if(empty($fleets))
{
$bapakasuh = array();
} else{
$bapakasuh = DB::table('bapak_asuh_financial_month')
->join('users','users.id','=','bapak_asuh_financial_month.bapak_asuh')
->where('month','=',date('n',strtotime($date)) )
->where('year','=',date('Y',strtotime($date)) )
->where_pool(Auth::user()->pool_id)
->where('bapak_asuh_financial_month.pool_id','=',Auth::user()->pool_id)
->order_by('selisi_ks', 'asc')
->take(10)
->get();
}*/
$retundata = $this->aasort($datax, 'selisi_ks');
return Response::json($retundata);
}
