<thead>
<tr>
<th>No</th>
<th>Nomor Body</th>
<th>Bravo</th>
<th>Charlie</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
?>
@foreach($listanakasuh as $fleet)
<?php
$infokso = Kso::where('fleet_id', '=', $fleet->fleet_id)->where('actived', '=', 1)->first();
?>
@if($infokso)
<?php
$bravo = Driver::find($infokso->bravo_driver_id);
?>
<?php
$charlie = Driver::find($infokso->charlie_driver_id);
?>
<tr>
<td>{{ $no }}</td>
<td><span class="label label-success"> <?php
$fl = Fleet::find($fleet->fleet_id);
?>
@if($fl)
public function post_expreportsetoran()
{
//var_dump(Input::all());
$mic_time = microtime();
$mic_time = explode(" ", $mic_time);
$mic_time = $mic_time[1] + $mic_time[0];
$start_time = $mic_time;
$date = Input::get('date');
$shift = Input::get('shift_id');
$all = Input::get('allbody', false);
$fleets = Input::get('bodylist', array());
$subdate = explode('/', $date);
$month = $subdate[0];
$year = $subdate[1];
$newdate = date("Y-m-t", strtotime($year . '-' . $month . '-01'));
$pool_id = Auth::user()->pool_id;
if ($all) {
$fleets = array();
$fleetsobj = Kso::where('pool_id', '=', $pool_id)->where('actived', '=', 1)->get(array('id', 'fleet_id'));
foreach ($fleetsobj as $sc) {
$fleets[] = $sc->id;
}
}
/*
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator(Auth::user()->fullname)
->setLastModifiedBy(Auth::user()->fullname)
->setTitle("Laporan Harian ".Pool::find(Auth::user()->pool_id)->pool_name. '-'.date('Y-m-d'))
->setSubject("Laporan Harian ".Pool::find(Auth::user()->pool_id)->pool_name. '-'.date('Y-m-d'))
->setDescription("Laporan harian operasi pool")
->setKeywords("Laporan Harian")
->setCategory("");
$styleArray = array(
'font' => array(
'bold' => true,
'color' => array('rgb' => 'FF0000'),
'size' => 16,
//'name' => 'Verdana'
));
*/
$sheet_active = 0;
$no = 1;
$starline = 8;
foreach ($fleets as $key => $kso_id) {
/*
$objPHPExcel->createSheet(NULL, $sheet_active);
$objPHPExcel->setActiveSheetIndex($sheet_active);
*/
$reports = DB::table('financial_report_daily')->where('kso_id', '=', $kso_id)->where('operasi_time', '>=', date("Y-m-01", strtotime($year . '-' . $month . '-01')))->where('operasi_time', '<=', date("Y-m-t", strtotime($year . '-' . $month . '-01')))->order_by('operasi_time', 'asc')->get();
$data = $this->infoSaldo($kso_id, $newdate);
/*
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $starline, $data->saldoks );
$objPHPExcel->getActiveSheet()->setTitle($data->taxi_number);
$sheet_active++;
*/
}
/*
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save(path('public').'x.xls');
*/
$mic_time = microtime();
$mic_time = explode(" ", $mic_time);
$mic_time = $mic_time[1] + $mic_time[0];
$endtime = $mic_time;
$total_execution_time = $endtime - $start_time;
return "Total Executaion Time " . $total_execution_time . " seconds";
//return Response::download(path('public').'x.xls', 'x.xls');
}
public function get_downloadreportbs($date = false)
{
if (!$date) {
$date = date('Y-m-d');
}
$ksos = Kso::where('pool_id', '=', Auth::user()->pool_id)->where('actived', '=', 1)->get();
$ksoaktif = array();
foreach ($ksos as $xkso) {
$ksoaktif[] = $xkso->id;
}
$financials = DB::table('financial_report_monthly_bykso')->where('month', '=', date('n', strtotime($date)))->where('year', '=', date('Y', strtotime($date)))->where_pool_id(Auth::user()->pool_id)->where_in('kso_id', $ksoaktif)->order_by('taxi_number', 'asc')->get();
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator(Auth::user()->fullname)->setLastModifiedBy(Auth::user()->fullname)->setTitle("Laporan Harian " . Pool::find(Auth::user()->pool_id)->pool_name . '-' . date('Y-m-d'))->setSubject("Laporan Harian " . Pool::find(Auth::user()->pool_id)->pool_name . '-' . date('Y-m-d'))->setDescription("Laporan harian operasi pool")->setKeywords("Laporan Harian")->setCategory("");
$objPHPExcel->createSheet(NULL, 0);
$objPHPExcel->setActiveSheetIndex(0);
//$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setVisible(false);
//$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setVisible(false);
$objPHPExcel->getActiveSheet()->mergeCells('A5:A6');
$objPHPExcel->getActiveSheet()->mergeCells('B5:B6');
$objPHPExcel->getActiveSheet()->mergeCells('C5:D5');
$objPHPExcel->getActiveSheet()->mergeCells('E5:E6');
$objPHPExcel->getActiveSheet()->mergeCells('F5:G5');
$objPHPExcel->getActiveSheet()->mergeCells('H5:H6');
$objPHPExcel->getActiveSheet()->mergeCells('I5:I6');
$objPHPExcel->getActiveSheet()->mergeCells('J5:J6');
$objPHPExcel->getActiveSheet()->mergeCells('K5:K6');
$objPHPExcel->getActiveSheet()->mergeCells('L5:O5');
$objPHPExcel->getActiveSheet()->mergeCells('P5:R5');
//$objPHPExcel->getActiveSheet()->mergeCells('R5:R6');
$objPHPExcel->getActiveSheet()->mergeCells('S5:S6');
$objPHPExcel->getActiveSheet()->mergeCells('T5:T6');
$objPHPExcel->getActiveSheet()->mergeCells('U5:U6');
$objPHPExcel->getActiveSheet()->mergeCells('V5:V6');
$objPHPExcel->getActiveSheet()->mergeCells('W5:W6');
$objPHPExcel->getActiveSheet()->mergeCells('X5:X6');
$objPHPExcel->getActiveSheet()->setCellValue('A5', 'NO');
$objPHPExcel->getActiveSheet()->setCellValue('B5', 'BAPAK ASUH');
$objPHPExcel->getActiveSheet()->setCellValue('C5', 'PENGEMUDI');
$objPHPExcel->getActiveSheet()->setCellValue('C6', 'NIP');
$objPHPExcel->getActiveSheet()->setCellValue('D6', 'NAMA');
$objPHPExcel->getActiveSheet()->setCellValue('E5', 'BODY');
$objPHPExcel->getActiveSheet()->setCellValue('F5', 'STATUS');
$objPHPExcel->getActiveSheet()->setCellValue('F6', 'OPS');
$objPHPExcel->getActiveSheet()->setCellValue('G6', 'BS');
$objPHPExcel->getActiveSheet()->setCellValue('H5', 'SETORAN MURNI');
$objPHPExcel->getActiveSheet()->setCellValue('I5', 'TAB SPAREPART');
$objPHPExcel->getActiveSheet()->setCellValue('J5', 'DENDA JAM');
$objPHPExcel->getActiveSheet()->setCellValue('K5', 'DP SPAREPART');
$objPHPExcel->getActiveSheet()->setCellValue('L5', 'BAYAR CICILAN');
$objPHPExcel->getActiveSheet()->setCellValue('L6', 'KS');
$objPHPExcel->getActiveSheet()->setCellValue('M6', 'S-PART');
$objPHPExcel->getActiveSheet()->setCellValue('N6', 'DP-KSO');
$objPHPExcel->getActiveSheet()->setCellValue('O6', 'HUT-LAMA');
$objPHPExcel->getActiveSheet()->setCellValue('P5', 'BAYAR');
$objPHPExcel->getActiveSheet()->setCellValue('P6', 'STIKER BANDARA & KEAMANAN');
$objPHPExcel->getActiveSheet()->setCellValue('Q6', 'CUCI');
$objPHPExcel->getActiveSheet()->setCellValue('R6', 'LAKA');
$objPHPExcel->getActiveSheet()->setCellValue('S5', 'HARUS SETOR');
$objPHPExcel->getActiveSheet()->setCellValue('T5', 'POTONGAN');
$objPHPExcel->getActiveSheet()->setCellValue('U5', 'SETOR CASH');
$objPHPExcel->getActiveSheet()->setCellValue('V5', 'KETEKORAN');
$objPHPExcel->getActiveSheet()->setCellValue('W5', 'SETORAN OPS');
$objPHPExcel->getActiveSheet()->setCellValue('X5', 'SELISIH');
$no = 1;
$starline = 8;
foreach ($financials as $finan) {
$ks = abs($finan->setoran_cash - ($finan->setoran_wajib + $finan->tabungan_sparepart + $finan->denda + $finan->cicilan_sparepart + $finan->cicilan_ks + $finan->biaya_cuci + $finan->iuran_laka + $finan->cicilan_dp_kso + $finan->cicilan_hutang_lama + $finan->cicilan_lain + $finan->hutang_dp_sparepart - $finan->potongan));
$bs = 'Tidak';
if ($ks <= $finan->cicilan_ks) {
$bs = 'Ya';
}
$bpkasuh = Anakasuh::where('status', '=', 1)->where('fleet_id', '=', $finan->fleet_id)->first();
$bravo = Kso::find($finan->kso_id);
$nip = 'NN';
$bravonama = 'NN';
if ($bravo) {
$oxx = Driver::find($bravo->bravo_driver_id);
if ($oxx) {
$nip = $oxx->nip;
$bravonama = $oxx->name;
}
}
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $starline, $no);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $starline, $bpkasuh ? User::find($bpkasuh->user_id)->fullname : 'TIDAK ADA BAPAK ASUH');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $starline, $nip);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $starline, $bravonama);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $starline, $finan->taxi_number);
//$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $starline, $finan->kode);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $starline, $bs);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $starline, $finan->setoran_wajib);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $starline, $finan->tabungan_sparepart);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $starline, $finan->denda);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $starline, $finan->hutang_dp_sparepart);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $starline, $finan->cicilan_ks);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, $starline, $finan->cicilan_sparepart);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, $starline, $finan->cicilan_dp_kso);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $starline, $finan->cicilan_hutang_lama);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(15, $starline, $finan->cicilan_lain);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(16, $starline, $finan->biaya_cuci);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(17, $starline, $finan->iuran_laka);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(18, $starline, '=SUM(H' . $starline . ':R' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(19, $starline, $finan->potongan);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(20, $starline, $finan->setoran_cash);
//$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(20, $starline, $finan->ks);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(21, $starline, '=(U' . $starline . '-(S' . $starline . '-T' . $starline . '))');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(22, $starline, '=(U' . $starline . '-(Q' . $starline . '+R' . $starline . '))');
//$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(23, $starline, $finan->shift); //col X
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(23, $starline, '=V' . $starline . '+ L' . $starline);
//$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $starline, $finan->cicilan_lain);
//hidden coloumn status operasi
//$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(25, $starline, $finan->operasi_status_id); //col Z
$no++;
$starline++;
}
$objPHPExcel->getActiveSheet()->mergeCells('A' . ($starline + 1) . ':G' . ($starline + 1) . '');
$objPHPExcel->getActiveSheet()->setCellValue('A' . ($starline + 1), 'TOTAL SETORAN ');
$objPHPExcel->getActiveSheet()->setCellValue('H' . ($starline + 1), '=SUM(H8:H' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('I' . ($starline + 1), '=SUM(I8:I' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('J' . ($starline + 1), '=SUM(J8:J' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('K' . ($starline + 1), '=SUM(K8:K' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('L' . ($starline + 1), '=SUM(L8:L' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('M' . ($starline + 1), '=SUM(M8:M' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('N' . ($starline + 1), '=SUM(N8:N' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('O' . ($starline + 1), '=SUM(O8:O' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('P' . ($starline + 1), '=SUM(P8:P' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('Q' . ($starline + 1), '=SUM(Q8:Q' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('R' . ($starline + 1), '=SUM(R8:R' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('S' . ($starline + 1), '=SUM(S8:S' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('T' . ($starline + 1), '=SUM(T8:T' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('U' . ($starline + 1), '=SUM(U8:U' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('V' . ($starline + 1), '=SUM(V8:V' . $starline . ')');
$objPHPExcel->getActiveSheet()->setCellValue('W' . ($starline + 1), '=SUM(W8:W' . $starline . ')');
$objPHPExcel->getActiveSheet()->getStyle('A5:X' . ($starline + 1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR);
$objPHPExcel->getActiveSheet()->getStyle('A5:X6')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A5:X' . ($starline + 1))->getBorders()->getOutline()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A' . ($starline + 1) . ':X' . ($starline + 1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->setTitle('Laporan BS ' . $date);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save(path('public') . 'Laporan-BS-' . Pool::find(Auth::user()->pool_id)->pool_name . '.xls');
return Response::download(path('public') . 'Laporan-BS-' . Pool::find(Auth::user()->pool_id)->pool_name . '.xls', 'Laporan-BS-' . Pool::find(Auth::user()->pool_id)->pool_name . '.xls');
}
public function get_editscheduleonmaster($scheduledate_id = false)
{
if (!$scheduledate_id) {
return false;
}
$schd = Scheduledate::find($scheduledate_id);
$schm = Schedule::find($schd->schedule_id);
$stmp = mktime(0, 0, 0, $schm->month, $schd->date, $schm->year);
$this->data['date'] = Myfungsi::fulldate($stmp);
$this->data['schd'] = $schd;
$this->data['schm'] = $schm;
$this->data['month'] = date('n', $stmp);
$this->data['year'] = date('Y', $stmp);
$this->data['bckso'] = Kso::where('fleet_id', '=', $schm->fleet_id)->where('actived', '=', 1)->first();
return View::make('themes.modul.' . $this->views . '.editscheduleonmaster', $this->data);
}
@endforeach
</td>
</tr>
<tr>
<td><span class="label label-important">KSO GUGUR</span></td>
</tr>
<tr>
<td>
<?php
$ksos = Fleet::join('ksos', 'fleets.id', '=', 'ksos.fleet_id')->where('ksos.actived', '=', 2)->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)
<?php
//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'));
?>
public function getCountAll()
{
$pool_id = Auth::user()->pool_id;
return Kso::where('actived', '=', 1)->where('pool_id', '=', $pool_id)->count();
}
