public function post_saveeditkso() { Log::write('info', Request::ip() . ' User : '******' Event: Edit KSO', true); $data = Input::all(); $extradata = array('user_id' => Auth::user()->id, 'last_update' => date('Y-m-d H:i:s')); $savedata = $data + $extradata; $datasave = Kso::find($data['id']); $datasave->kso_number = $data['kso_number']; $datasave->fleet_id = $data['fleet_id']; $datasave->bravo_driver_id = $data['bravo_driver_id']; $datasave->charlie_driver_id = $data['charlie_driver_id']; $datasave->pool_id = $data['pool_id']; $datasave->dp = $data['dp']; $datasave->sisa_dp = $data['sisa_dp']; $datasave->setoran = $data['setoran']; $datasave->tab_sparepart = $data['tab_sparepart']; $datasave->kso_type_id = $data['kso_type_id']; $datasave->ops_start = $data['ops_start']; $datasave->ops_end = $data['ops_end']; $datasave->actived = $data['actived']; $datasave->save(); if ($datasave) { if ($data['actived'] == 2) { $c = Fleet::find($data['fleet_id']); $c->fg_kso = 0; $c->save(); $s = Anakasuh::where('fleet_id', '=', $data['fleet_id'])->where('status', '=', 1)->first(); if ($s) { $s->status = 0; $s->end_date = date('Y-m-d', Myfungsi::sysdate()); $s->save(); } } else { if ($data['actived'] == 1) { $c = Fleet::find($data['fleet_id']); $c->fg_kso = 1; $c->save(); } } return Redirect::to('ksos'); } var_dump($data); }
public function post_exphutangarmada() { $input = Input::all(); $shift = 'all'; $saldohutangbymonth = $this->allQuery($input['date'], Auth::user()->pool_id, $shift, 0, 1000); if ($saldohutangbymonth) { $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)); $sheet_active = 0; $objPHPExcel->createSheet(NULL, $sheet_active); $objPHPExcel->setActiveSheetIndex($sheet_active); //title $objPHPExcel->getActiveSheet()->mergeCells('A2:J2'); $objPHPExcel->getActiveSheet()->setCellValue('A2', 'LAPORAN HUTANG ARMADA PER TANGGAL ' . Myfungsi::fulldate(strtotime($input['date']))); $objPHPExcel->getActiveSheet()->getStyle('A2')->applyFromArray($styleArray); // Coloum header $objPHPExcel->getActiveSheet()->mergeCells('A5:A6'); $objPHPExcel->getActiveSheet()->mergeCells('B5:B6'); $objPHPExcel->getActiveSheet()->mergeCells('C5:D5'); $objPHPExcel->getActiveSheet()->mergeCells('E5:E6'); $objPHPExcel->getActiveSheet()->mergeCells('F5:I5'); $objPHPExcel->getActiveSheet()->mergeCells('J5:L5'); $objPHPExcel->getActiveSheet()->mergeCells('M5:O5'); $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', 'PEMAKAIAN SPAREPART ARMADA'); $objPHPExcel->getActiveSheet()->setCellValue('F6', 'PEMAKAIAN'); $objPHPExcel->getActiveSheet()->setCellValue('G6', 'TABUNGAN'); $objPHPExcel->getActiveSheet()->setCellValue('H6', 'BAYAR'); $objPHPExcel->getActiveSheet()->setCellValue('I6', 'SELISIH'); $objPHPExcel->getActiveSheet()->setCellValue('J5', 'SETORAN ARMADA'); $objPHPExcel->getActiveSheet()->setCellValue('J6', 'KS'); $objPHPExcel->getActiveSheet()->setCellValue('K6', 'BAYAR KS'); $objPHPExcel->getActiveSheet()->setCellValue('L6', 'SELISIH'); $objPHPExcel->getActiveSheet()->setCellValue('M5', 'SALDO ARMADA'); $objPHPExcel->getActiveSheet()->setCellValue('M6', 'SALDO SPAREPART'); $objPHPExcel->getActiveSheet()->setCellValue('N6', 'SALDO KS'); $objPHPExcel->getActiveSheet()->setCellValue('O6', 'SALDO AKHIR'); $objPHPExcel->getActiveSheet()->setCellValue('P5', 'SHIFT'); $no = 1; $starline = 8; foreach ($saldohutangbymonth as $saldo) { $bpkasuh = Anakasuh::where('status', '=', 1)->where('fleet_id', '=', $saldo->fleet_id)->first(); $bravo = Driver::find($saldo->bravo_driver_id); $saldosp = $saldo->tabungan_sparepart + $saldo->hutang_dp_sparepart + $saldo->cicilan_sparepart - $saldo->pemakaian_part; $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, $bravo ? $bravo->nip : 'NONE'); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $starline, $bravo ? $bravo->name : 'NONE'); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $starline, $saldo->taxi_number); //pemakaikan sp $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $starline, $saldo->pemakaian_part); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, $starline, $saldo->tabungan_sparepart); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, $starline, $saldo->hutang_dp_sparepart + $saldo->cicilan_sparepart); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, $starline, $saldosp); //setoran armada $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(9, $starline, $saldo->ks); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(10, $starline, $saldo->cicilan_ks); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(11, $starline, $saldo->selisi_ks); //saldo armada $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(12, $starline, $saldosp); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(13, $starline, $saldo->selisi_ks); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(14, $starline, $saldosp + $saldo->selisi_ks); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(15, $starline, $saldo->shift_id); $no++; $starline++; } $objPHPExcel->getActiveSheet()->getStyle('A5:O' . ($starline + 1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR); $objPHPExcel->getActiveSheet()->getStyle('A5:O6')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getStyle('A5:O' . ($starline + 1))->getBorders()->getOutline()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getStyle('A' . ($starline + 1) . ':O' . ($starline + 1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //end //SET TANGGAL UNDUH DAN PASSWORD $objPHPExcel->getActiveSheet()->setCellValue('B' . ($starline + 10), 'Tanggal Unduh'); $objPHPExcel->getActiveSheet()->setCellValue('C' . ($starline + 10), ':'); $objPHPExcel->getActiveSheet()->setCellValue('D' . ($starline + 10), date('Y-m-d H:i:s')); $objPHPExcel->getSecurity()->setLockWindows(true); $objPHPExcel->getSecurity()->setLockStructure(true); $objPHPExcel->getSecurity()->setWorkbookPassword("FreeBlocking"); $objPHPExcel->getActiveSheet()->getProtection()->setPassword('FreeBlocking'); $objPHPExcel->getActiveSheet()->getProtection()->setSheet(true); // This should be enabled in order to enable any of the following! //$objPHPExcel->getActiveSheet()->getProtection()->setSort(true); $objPHPExcel->getActiveSheet()->getProtection()->setInsertRows(true); //END $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save(path('public') . 'Laporan-hutang-armada.xls'); return Response::download(path('public') . 'Laporan-hutang-armada.xls'); } //end if //var_dump($saldohutangbymonth); }
public function post_searchFleet() { $jsondata = Input::json(); $pool_id = Auth::user()->pool_id; $user_id = Auth::user()->id; $fleets = array(); foreach (Anakasuh::where('user_id', '=', $user_id)->where('status', '=', 1)->get() as $fleet) { array_push($fleets, $fleet->fleet_id); } $fleets = Fleet::where_pool_id($pool_id)->where_in('id', $fleets)->where('taxi_number', 'LIKE', '%' . $jsondata->taxi_number . '%')->get(array('id', 'taxi_number')); $fleetdata = array_map(function ($object) { return $object->to_array(); }, $fleets); $data['fleets'] = $fleetdata; return json_encode($data); }
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'); }
<th>Anak Asuh</th> <th>Actions</th> </tr> </thead> <tbody> <?php $no = 1; ?> @foreach($userperpool as $man) <tr> <td>{{ $no }}</td> <td>{{ $man->fullname }}</td> <td> - </td> <td> <?php $anakasuh = Anakasuh::join('fleets', 'fleets.id', '=', 'anak_asuh.fleet_id')->where('anak_asuh.user_id', '=', $man->id)->where('anak_asuh.status', '=', 1)->get(array('anak_asuh.id', 'fleets.taxi_number', 'anak_asuh.fleet_id')); ?> @foreach($anakasuh as $fleet) {{ HTML::link('cardcontrols/kartukontrolarmada/'.$fleet->fleet_id ,$fleet->taxi_number,array('class'=>'btn btn-mini btn-success','target'=>'_blank')) }} @endforeach </td> <td>{{ HTML::link('anakasuh/daftar/'.$man->id ,'Manage Anak Asuh',array('class'=>'btn btn-mini btn-success')) }}</td> </tr> <?php $no++; ?> @endforeach </tbody> </table> <!-- Button to trigger modal -->
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); }