/**
* sum loader.
*
* @return
*/
public function dailysum(Request $request)
{
$date = $request->get('dateops', date('Y-m-d'));
$shift_id = $request->get('shift_id', 0);
$checkins = $this->checkins->where('operasi_time', $date)->where('pool_id', $this->user->pool_id)->where('shift_id', $shift_id)->get();
$financialdata['ks'] = 0;
$financialdata['total'] = 0;
$financialdata['setoranops'] = 0;
$financialdata = [];
//set default 0
foreach ($this->label as $key => $value) {
$financialdata[$value] = 0;
}
foreach ($checkins as $finan) {
$financial = $finan->financial;
if ($financial) {
foreach ($financial as $mony) {
$financialdata[$this->label[$mony->financial_type_id]] += $mony->amount;
}
$financialdata['ks'] = $financialdata['setoran_cash'] - ($financialdata['setoran_wajib'] + $financialdata['tabungan_sparepart'] + $financialdata['denda'] + $financialdata['cicilan_sparepart'] + $financialdata['cicilan_ks'] + $financialdata['biaya_cuci'] + $financialdata['iuran_laka'] + $financialdata['cicilan_dp_kso'] + $financialdata['cicilan_hutang_lama'] + $financialdata['cicilan_lain'] + $financialdata['hutang_dp_sparepart'] - $financialdata['potongan']);
$financialdata['total'] = $financialdata['setoran_wajib'] + $financialdata['tabungan_sparepart'] + $financialdata['denda'] + $financialdata['cicilan_sparepart'] + $financialdata['cicilan_ks'] + $financialdata['biaya_cuci'] + $financialdata['iuran_laka'] + $financialdata['cicilan_dp_kso'] + $financialdata['cicilan_hutang_lama'] + $financialdata['cicilan_lain'] + $financialdata['hutang_dp_sparepart'];
$financialdata['setoranops'] = $financialdata['setoran_cash'] - ($financialdata['biaya_cuci'] + $financialdata['iuran_laka']);
}
}
return response($financialdata, 200)->header('Content-Type', 'application/json');
}
/**
* json.
*
* @return
*/
public function json(Request $request)
{
$date = $request->get('dateops', date('Y-m-d'));
$kso_id = $request->get('kso_id', 0);
$page = $request->get('page');
$limit = $request->get('rows');
$sidx = $request->get('sidx', 'operasi_time');
$sord = $request->get('sord', 'asc');
$year = date('Y', strtotime($date));
$month = date('n', strtotime($date));
$checkins = $this->checkins->where('kso_id', $kso_id)->whereRaw('YEAR(operasi_time) = ? AND MONTH(operasi_time) = ?', [$year, $month]);
$count = $checkins->count();
if ($count > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
$financials = $checkins->skip($start)->take($limit)->orderBy($sidx, $sord)->get();
$data['page'] = $page;
$data['total'] = $total_pages;
$data['records'] = $count;
$no = $start + 0;
$totalks = 0;
$selisi_ks = 0;
$setoranops = 0;
$total = 0;
$denda = 0;
$cicilan_ks = 0;
$cicilan_dp_kso = 0;
foreach ($financials as $finan) {
$no++;
$driver = $finan->driver;
$status = $finan->status;
$financial = $finan->financial;
$bapakasuh = $finan->fleet->bapakasuh()->wherePivot('status', 1)->first();
$namabapakasuh = $bapakasuh ? $bapakasuh->first_name . ' ' . $bapakasuh->last_name : 'N/A';
$datainfromation = ['no' => $no, 'nip' => $driver ? $driver->nip : 'N/A', 'nama' => $driver ? $driver->name : 'N/A', 'checkin_time' => $finan->checkin_time->format('Y-m-d H:i:s'), 'bapakasuh' => $namabapakasuh, 'operasi_time' => $finan->operasi_time, 'operasi_status_id' => $status ? $status->kode : 'N/A'];
$financialdata = [];
//set default 0
foreach ($this->label as $key => $value) {
$financialdata[$value] = 0;
}
if ($financial) {
foreach ($financial as $mony) {
$financialdata[$this->label[$mony->financial_type_id]] = $mony->amount;
}
$financialdata['ks'] = $financialdata['setoran_cash'] - ($financialdata['setoran_wajib'] + $financialdata['tabungan_sparepart'] + $financialdata['denda'] + $financialdata['cicilan_sparepart'] + $financialdata['cicilan_ks'] + $financialdata['biaya_cuci'] + $financialdata['iuran_laka'] + $financialdata['cicilan_dp_kso'] + $financialdata['cicilan_hutang_lama'] + $financialdata['cicilan_lain'] + $financialdata['hutang_dp_sparepart'] - $financialdata['potongan']);
$financialdata['total'] = $financialdata['setoran_wajib'] + $financialdata['tabungan_sparepart'] + $financialdata['denda'] + $financialdata['cicilan_sparepart'] + $financialdata['cicilan_ks'] + $financialdata['biaya_cuci'] + $financialdata['iuran_laka'] + $financialdata['cicilan_dp_kso'] + $financialdata['cicilan_hutang_lama'] + $financialdata['cicilan_lain'] + $financialdata['hutang_dp_sparepart'];
$financialdata['setoranops'] = $financialdata['setoran_cash'] - ($financialdata['biaya_cuci'] + $financialdata['iuran_laka']);
$totalks += $financialdata['ks'];
$selisi_ks += 0;
$setoranops += $financialdata['setoranops'];
$total += $financialdata['total'];
$denda += $financialdata['denda'];
$cicilan_ks += $financialdata['cicilan_ks'];
$cicilan_dp_kso += $financialdata['cicilan_dp_kso'];
}
$data['rows'][] = $datainfromation + $financialdata;
}
$data['userdata']['operasi_time'] = 'TOTAL';
$data['userdata']['ks'] = $totalks;
$data['userdata']['selisi_ks'] = $selisi_ks;
$data['userdata']['setoranops'] = $setoranops;
$data['userdata']['total'] = $total;
$data['userdata']['denda'] = $denda;
$data['userdata']['cicilan_ks'] = $cicilan_ks;
$data['userdata']['cicilan_dp_kso'] = $cicilan_dp_kso;
return response($data, 200)->header('Content-Type', 'application/json');
}
