public function post_reporthutang() { $msg = null; $pool_id = Auth::user()->pool_id; $date = Input::get('dateops', date('Y-m-d')); $shift_id = Input::get('shift_id'); $page = Input::get('page'); $limit = Input::get('rows'); $sidx = Input::get('sidx', 'operasi_time'); $sord = Input::get('sord', 'asc'); if ($shift_id == 'all') { $count = Checkin::join('ksos', 'ksos.id', '=', 'kso_id')->where('checkins.operasi_time', '<=', $date)->where('ksos.pool_id', '=', Auth::user()->pool_id)->where('ksos.actived', '=', 1)->group_by('kso_id')->count(); } else { $count = Checkin::join('ksos', 'ksos.id', '=', 'kso_id')->where('checkins.operasi_time', '<=', $date)->where('checkins.shift_id', '=', $shift_id)->where('ksos.pool_id', '=', Auth::user()->pool_id)->where('ksos.actived', '=', 1)->group_by('kso_id')->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; } $saldohutangbymonth = $this->sqlData($date, $pool_id, $shift_id, $start, $limit); $responce['page'] = $page; $responce['total'] = $total_pages; $responce['records'] = $count; if ($saldohutangbymonth) { $no = $start + 1; $ksavr = 0; $selisiavr = 0; $setoranopsavr = 0; $totalavr = 0; $cicilanksavr = 0; $dendaavr = 0; $cicilan_dp_ksoavr = 0; foreach ($saldohutangbymonth as $finan) { $saldosp = $finan->tabungan_sparepart + $finan->hutang_dp_sparepart + $finan->cicilan_sparepart - $finan->pemakaian_part; $responce['rows'][] = array('no' => $no++, 'taxi_number' => ($c = Fleet::find($finan->fleet_id)) ? $c->taxi_number : 'Body Error', 'bravo' => ($b = Driver::find($finan->bravo_driver_id)) ? $b->name : 'Bravo Error', 'shift_id' => Shift::find($finan->shift_id)->shift, 'pemakaian_sp' => $finan->pemakaian_part, 'tabungan_sp' => $finan->tabungan_sparepart, 'bayar_sp' => $finan->hutang_dp_sparepart + $finan->cicilan_sparepart, 'saldo_sp' => $saldosp, 'ks' => $finan->ks, 'bayar_ks' => $finan->cicilan_ks, 'selisi_ks' => $finan->selisi_ks, 'saldo_armada' => $saldosp + $finan->selisi_ks); } } return json_encode($responce); }
public function get_findbyIdFleet($id = false) { if (!$id) { return false; } $fleet = Fleet::find($id); $kso = Kso::where_fleet_id($fleet->id)->first(); $financial_fleet = DB::table('financial_report_bykso')->where('kso_id', '=', $kso->id)->first(); $financial_fleet_part = DB::table('wo_financial_report_bykso')->where('kso_id', '=', $kso->id)->first(); $fleet_ks = 0; $fleet_cicilan_ks = 0; $fleet_tabungan_sparepart = 0; $fleet_cicilan_db_kso = 0; $fleet_cicilan_sparepart = 0; $fleet_dp_sparepart = 0; if ($financial_fleet) { $fleet_ks = $financial_fleet->ks; $fleet_cicilan_ks = $financial_fleet->cicilan_ks; $fleet_tabungan_sparepart = $financial_fleet->tabungan_sparepart; $fleet_cicilan_db_kso = $financial_fleet->cicilan_dp_kso; $fleet_cicilan_sparepart = $financial_fleet->cicilan_sparepart; $fleet_dp_sparepart = $financial_fleet->hutang_dp_sparepart; } $total_pemakaian_part = 0; if ($financial_fleet_part) { $total_pemakaian_part = $financial_fleet_part->pemakaian_part; } $fleetinfo = array('id' => $fleet->id, 'police_number' => $fleet->police_number, 'bravo' => Driver::find($kso->bravo_driver_id)->name, 'taxi_number' => $fleet->taxi_number, 'total_ks' => number_format($fleet_ks, 2, ',', '.'), 'pembayaran_ks' => number_format($fleet_cicilan_ks, 2, ',', '.'), 'tab_sparepart' => number_format($fleet_tabungan_sparepart, 2, ',', '.'), 'dp_kso' => number_format($kso->dp, 2, ',', '.'), 'hutang_dp_kso' => number_format($kso->sisa_dp, 2, ',', '.'), 'pem_hutang_dp_kso' => number_format($fleet_cicilan_db_kso, 2, ',', '.'), 'pem_sparepart' => number_format($total_pemakaian_part, 2, ',', '.'), 'saldo_unit' => number_format($fleet_cicilan_ks + $fleet_cicilan_db_kso + $kso->dp - ($fleet_ks + $kso->sisa_dp) + ($fleet_tabungan_sparepart + $fleet_cicilan_sparepart + $fleet_dp_sparepart - $total_pemakaian_part), 2, ',', '.'), 'pembayaran_sparepart' => $fleet_cicilan_sparepart + $fleet_dp_sparepart, 'status' => $fleet->fg_blocked == 1 || $fleet->fg_bengkel == 1 ? 'Blocked' : 'Ready'); $returndata = array('fleetinfo' => $fleetinfo); return json_encode($returndata); }
font-size: .8em; font-family:Tahoma, Geneva, sans-serif; position: fixed; } #content { padding: 10px 10px 10px 10px; } h1 { font-size: 1.4em; } </style> </head> <body> <?php $driver = Driver::find($wo->driver_id); $fleet = Fleet::find($wo->fleet_id); ?> <div id="KERTASSEDANG"> <div id="content"> <table cellspacing="0" cellpadding="0" width="100%"> <tr> <td colspan="4" align="center">BUKTI KELUAR BARANG</td> </tr> <tr> <td colspan="4" align="center">PT. DHARMA INDAH AGUNG METROPOLITAN</td> </tr> <tr> <td> </td> <td></td> <td></td> <td></td>
public function post_stockspart() { $part_number = Input::get('part_number'); $sparepart = Sparepart::where('part_number', '=', $part_number)->first(); $data = array('status' => 0, 'data' => 'null'); if ($sparepart) { $stock = DB::table('stock_sp')->where('pool_id', '=', Auth::user()->pool_id)->where('sparepart_id', '=', $sparepart->id)->first(); $lists = DB::table('wo_listparts')->where('pool_id', '=', Auth::user()->pool_id)->where('sparepart_id', '=', $sparepart->id)->order_by('inserted_date_set', 'desc')->get(); $xs = array(); if ($stock) { $no = 1; foreach ($lists as $ls) { $xs[] = array($no++, date('d/m/Y', strtotime($ls->inserted_date_set)), $ls->wo_number, Fleet::find($ls->fleet_id)->taxi_number, $ls->qty, $ls->satuan); } $data = array('status' => 1, 'data' => $stock, 'aaData' => $xs); } } return json_encode($data); }
foreach ($driver_ar as $key => $value) { $a = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->where('schedules.month', '=', date('n', $timestamp))->where('schedules.year', '=', date('Y', $timestamp))->where('pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.driver_id', '=', $value)->get(); $free = array(); // prosess pembentukan jadwal per pengemudi dalam group foreach ($a as $aa) { //echo 'Tanggal '. $aa->date .' di bawa pengemudi ' . $aa->driver_id ; //echo '<br>'; array_push($free, $aa->date); } // DISPLY PENGEMUDI echo '<tr>'; echo '<td>'; //echo 'Driv ' . $value ; $kso = Kso::where_bravo_driver_id($value)->where_actived(1)->first(); if ($kso) { echo Fleet::find($kso->fleet_id)->taxi_number; } echo '</td>'; echo '<td>'; echo Driver::find($value)->name; echo '</td>'; $holiday = array(); for ($i = 1; $i <= date('t', $timestamp); $i++) { if (is_array($free) && !empty($free)) { if (!in_array($i, $free)) { echo '<td style="background-color: #fcf8e3">'; // Set Libur symbol echo ' L '; array_push($holiday, $i); } else { echo '<td style="background-color: #dff0d8">';
<th>KM Keluar</th> <th>Waktu Masuk Pool</th> <th>KM Masuk</th> <th>Shift</th> <th>Status OPS</th> <th>Action</th> </tr> </thead> <?php $no = 1; ?> <tbody> @foreach($checkout as $out) <?php $fleet = Fleet::find($out->fleet_id); ?> <?php $driver = Driver::find($out->driver_id); ?> <tr> <td>{{ $no }}</td> <td>@if($fleet) {{ $fleet->taxi_number }} @endif</td> <td>@if($driver) {{ $driver->nip }} @endif</td> <td>@if($driver) {{ $driver->name }} @endif</td> <td>{{ $out->printspj_time }}</td> <td>{{ $out->checkout_time }}</td> <td> <?php $last_operasi = date('Y-m-d', strtotime($out->operasi_time . ' -1 days')); $last_checkin = Checkin::where_fleet_id($out->fleet_id)->where_operasi_time($last_operasi)->first();
public function get_delete($id = false) { if (!$id) { return Redirect::to('fleets'); } $fleet = Fleet::find($id); $fleet->delete(); return Redirect::to('fleets'); }
public function post_otorisasi() { $input = Input::json(); $username = $input->username; $password = $input->password; $bap_id = $input->bap_id; $ver2 = User::where('username', '=', $username)->first(); if ($ver2) { if (Hash::check($password, $ver2->password)) { if ($ver2->id !== Auth::user()->id) { //melihat driver_id dan fleet_id pada bap $bap = Bap::find($bap_id); //create log open block try { $open = Openblocking::create(array('bap_id' => $bap_id, 'tanggal' => date('Y-m-d H:i:s'), 'otorisasi1_id' => Auth::user()->id, 'otorisasi2_id' => $ver2->id)); if ($open) { $driver = Driver::find($bap->driver_id); $driver->fg_blocked = 0; $driver->save(); $setor = Fleet::find($bap->fleet_id); $setor->fg_setor = 0; $setor->save(); return json_encode(array('status' => true, 'msg' => 'Otorisasi open block berhasil!')); } } catch (Exception $e) { return json_encode(array('status' => true, 'msg' => 'Otorisasi sudah dilakukan!')); } } else { return json_encode(array('status' => false, 'msg' => 'Otorisasi harus orang yang berbeda!')); } } } return json_encode(array('status' => false, 'msg' => 'Otorisasi kedua gagal!')); }
public function post_otorisasi() { $input = Input::json(); $username = $input->username; $password = $input->password; $bap_id = $input->bap_id; $ver2 = User::where('username', '=', $username)->first(); if ($ver2) { if (Hash::check($password, $ver2->password)) { $roleoto = array(); foreach ($ver2->roles as $role) { array_push($roleoto, $role->id); } if ($ver2->id !== Auth::user()->id && in_array(14, $roleoto)) { //melihat driver_id dan fleet_id pada bap $bap = Bap::find($bap_id); //create log open block try { $open = Openblocking::create(array('bap_id' => $bap_id, 'tanggal' => date('Y-m-d H:i:s'), 'otorisasi1_id' => Auth::user()->id, 'otorisasi2_id' => $ver2->id)); if ($open) { $driver = Driver::find($bap->driver_id); $driver->fg_blocked = 0; $driver->save(); $setor = Fleet::find($bap->fleet_id); $setor->fg_setor = 0; $setor->save(); $msg = 'Otorisasi Open Blocking Berhasil !'; //openblock pusat if ($driver->fg_super_blocked == 1) { $msg = 'Open Blocking membutuhkan persetujuan pusat silahkan telp / chat dengan bagian pusat \\n Terima Kasih'; } return json_encode(array('status' => true, 'msg' => $msg)); } } catch (Exception $e) { return json_encode(array('status' => true, 'msg' => 'Otorisasi sudah dilakukan! ')); } } else { return json_encode(array('status' => false, 'msg' => 'Otorisasi harus orang yang berbeda! / User 2 tidak di izinkan memberikan otorisasi')); } } } return json_encode(array('status' => false, 'msg' => 'Otorisasi kedua gagal!')); }
public function post_analisasave() { $wo_id = Input::get('wo_id'); //update status WO $upwo = Workorder::find($wo_id); $upwo->status = Input::get('status'); $upwo->complaint = Input::get('compalaint'); $upwo->information_complaint = Input::get('information'); $upwo->finished_date_set = date('Y-m-d H:i:s'); $upwo->mechanic = Input::get('mechanic'); $upwo->save(); if (Input::get('status') == 3 || Input::get('status') == 4 || Input::get('status') == 5) { $z = Fleet::find($upwo->fleet_id); $z->fg_bengkel = 0; $z->save(); } Session::flash('status', 'Work Order berhasil di simpan!'); return Redirect::to('workshops/woanalisis/' . $wo_id); }
public function get_kartukontrolarmadakso($id = false) { $startdate = Input::get('datestart', false); $enddate = Input::get('dateend', false); $cont = Input::get('con', false); if (!$id) { return false; } if (!$startdate) { $startdate = date('Y-m-d', mktime(0, 0, 0, (int) strtotime('m', $startdate), 1, (int) strtotime('Y', $enddate))); } if (!$enddate) { $enddate = date('Y-m-d', (int) mktime(0, 0, 0, strtotime('m', $enddate), (int) strtotime('j', $enddate), (int) strtotime('Y', $enddate))); } //$kso = Kso::where_fleet_id($id)->where_actived(1)->first(); $kso = Kso::find($id); $fleet = Fleet::find($kso->fleet_id); $financial_fleet = DB::table('financial_report_bykso')->where('kso_id', '=', $kso->id)->first(); $financial_fleet_part = DB::table('wo_financial_report_bykso')->where('kso_id', '=', $kso->id)->first(); $fleet_ks = 0; $fleet_cicilan_ks = 0; $fleet_tabungan_sparepart = 0; $fleet_cicilan_dp_kso = 0; $fleet_cicilan_sparepart = 0; $fleet_dp_sparepart = 0; if ($financial_fleet) { $fleet_ks = $financial_fleet->ks; $fleet_cicilan_ks = $financial_fleet->cicilan_ks; $fleet_tabungan_sparepart = $financial_fleet->tabungan_sparepart; $fleet_cicilan_dp_kso = $financial_fleet->cicilan_dp_kso; $fleet_cicilan_sparepart = $financial_fleet->cicilan_sparepart; $fleet_dp_sparepart = $financial_fleet->hutang_dp_sparepart; } $total_pemakaian_part = 0; if ($financial_fleet_part) { $total_pemakaian_part = $financial_fleet_part->pemakaian_part; } $fleetinfo = array('id' => $fleet->id, 'police_number' => $fleet->police_number, 'nip' => Driver::find($kso->bravo_driver_id)->nip, 'bravo' => Driver::find($kso->bravo_driver_id)->name, 'taxi_number' => $fleet->taxi_number, 'total_ks' => number_format($fleet_ks, 0, ',', '.'), 'pembayaran_ks' => number_format($fleet_cicilan_ks, 0, ',', '.'), 'tab_sparepart' => number_format($fleet_tabungan_sparepart, 0, ',', '.'), 'dp_kso' => number_format($kso->dp, 0, ',', '.'), 'hutang_dp_kso' => number_format($kso->sisa_dp, 0, ',', '.'), 'pem_hutang_dp_kso' => number_format($fleet_cicilan_dp_kso, 0, ',', '.'), 'pem_sparepart' => number_format($total_pemakaian_part, 0, ',', '.'), 'saldo_unit' => number_format($fleet_cicilan_ks - $fleet_ks + ($fleet_tabungan_sparepart + $fleet_cicilan_sparepart + $fleet_dp_sparepart - $total_pemakaian_part), 0, ',', '.'), 'pembayaran_sparepart' => number_format($fleet_cicilan_sparepart + $fleet_dp_sparepart, 0, ',', '.'), 'status' => $fleet->fg_blocked == 1 || $fleet->fg_bengkel == 1 ? 'Blocked' : 'Ready', 'saldo_dp' => $kso->sisa_dp - $fleet_cicilan_dp_kso); $reports = DB::table('financial_report_daily')->where('kso_id', '=', $kso->id)->where('operasi_time', '>=', $startdate)->where('operasi_time', '<=', $enddate)->order_by('operasi_time', 'asc')->get(); $this->data['reports'] = $reports; $this->data['detailarmada'] = $fleetinfo; if ($cont == 'tampil') { return View::make('themes.modul.' . $this->views . '.kartukontrolarmada', $this->data); } else { if ($cont == 'download') { return View::make('themes.modul.' . $this->report . '.printkartukontrol', $this->data); } } return View::make('themes.modul.' . $this->views . '.kartukontrolarmada', $this->data); }
public function get_ksofleet($fleet_id = false) { if (!$fleet_id) { return false; } $this->data['fleet'] = Fleet::find($fleet_id); $this->data['fleetkso'] = Kso::where_fleet_id($fleet_id)->get(); return View::make('themes.modul.' . $this->views . '.fleetkso', $this->data); }
public function post_saveCheckFisik() { Log::write('info', Request::ip() . ' User : '******' Event: Save Checkin', true); $data = Input::json(); $id = $data->id; $docs_ket = $data->std_docs; $neats = $data->std_neats; $equips = $data->std_equips; $sp_kets = $data->ket_sp; $checkin = Checkin::find($id); //$checkin->operasi_status_id = $data->status_ops; $checkin->save(); $docs = array(); foreach (Stddoc::all() as $doc) { array_push($docs, $doc->id); } $sps = array(); foreach (Stdfleet::all() as $sp) { array_push($sps, $sp->id); } $fg_bengkel = $data->hasilcheckfisik == 2 ? 1 : 0; $cin = Checkindocument::where_checkin_id($id)->first(); $cpy = Checkinphysic::where_checkin_id($id)->first(); if (!$cpy) { $cpy = Checkinphysic::create(array('checkin_id' => $id)); } if ($cin->operasi_time > date('Y-m-d', Myfungsi::sysdate())) { $datax['message'] = 'invalide time'; } else { $cin->std_neats_id = implode(",", $neats); $cin->std_document_id = implode(",", $docs); $cin->ket = implode(",", $docs_ket); $cin->std_equip_id = implode(",", $equips); $cin->save(); //save pysicly $cpy->sparepart_id = implode(",", $sps); $cpy->ket = implode(",", $sp_kets); $cpy->save(); //update jika perlu berbaikan $fl = Fleet::find($checkin->fleet_id); $fl->fg_bengkel = $fg_bengkel; $fl->save(); $datax['message'] = 'Data Saved'; } return json_encode($datax); }
<td colspan="5">Pembayaran</td> <td rowspan="2">KS</td> <td rowspan="2">Keterangan OPS</td> </tr> <tr> <td>KS</td> <td>SP</td> <td>DP KSO</td> <td>DP SP</td> <td>HUT LAMA</td> </tr> </thead> <tbody> @foreach($reports as $report) <?php $fleet = Fleet::find($report->fleet_id); ?> <tr> <td>{{ $report->operasi_time }}</td> <td>{{ $fleet->taxi_number }}</td> <td class="text-right">{{ number_format($report->setoran_cash, 2, ',', '.') }}</td> <td class="text-right">{{ number_format($report->denda, 2, ',', '.') }}</td> <td class="text-right">{{ number_format($report->cicilan_ks, 2, ',', '.') }}</td> <td class="text-right">{{ number_format($report->cicilan_sparepart, 2, ',', '.') }}</td> <td class="text-right">{{ number_format($report->cicilan_dp_kso, 2, ',', '.') }}</td> <td class="text-right">{{ number_format($report->hutang_dp_sparepart, 2, ',', '.') }}</td> <td class="text-right">{{ number_format($report->cicilan_hutang_lama, 2, ',', '.') }}</td> <td class="text-right">{{ number_format($report->ks, 2, ',', '.') }}</td> <td class="text-right">{{ Statusoperasi::find($report->operasi_status_id)->kode }}</td> </tr> <?php
public function post_delgroup() { $id = Input::get('id'); if (!$id) { return false; } $group = Schedulefleetgroup::where('schedule_group_id', '=', $id)->get(); if ($group) { foreach ($group as $x) { $fleet = Fleet::find($x->fleet_id); $fleet->fg_group = 0; $fleet->save(); } DB::table('schedule_groups')->where('id', '=', $id)->delete(); DB::table('schedule_fleet_groups')->where('schedule_group_id', '=', $id)->delete(); } return Redirect::to('schedule/groups'); }
padding-right: 5mm; } h3 { font-size: 13pt; } </style> </head> <body> <div id="content"> <?php $driver = Driver::find($bap->driver_id); $fleet = Fleet::find($bap->fleet_id); ?> <table width="100%" cellpadding="0" cellspacing="0" id="header"> <tr> <td rowspan="3">{{ HTML::image('img/diantaksi.png','',array('id' => 'logo')) }}</td> <td>PT DHARMA INDAH AGUNG METROPOLITAN</td> </tr> <tr> <td><strong><u><h3>BERITA ACARA PROSES PENGEMUDI</h3></u></strong></td> </tr> <tr> <td> NO : {{ $bap->bap_number }} </td> </tr> </table> <br>
public function post_findbyidafterpay() { $jsondata = Input::json(); $checkin = Checkin::find($jsondata->id); $driverinfo = Driver::find($checkin->driver_id); $fleetinfo = Fleet::find($checkin->fleet_id); $kso = Kso::find($checkin->kso_id); $payment = Checkinfinancial::where_checkin_id($checkin->id)->get(); $datapayment = array(); foreach ($payment as $pay) { $datapayment[$pay->financial_type_id] = $pay->amount; } //km tempuh operasi $last_operasi = date('Y-m-d', strtotime($checkin->operasi_time . ' -1 days')); $last_checkin = Checkin::where_fleet_id($checkin->fleet_id)->where_operasi_time($last_operasi)->first(); $km_tempuh = $checkin->km_fleet; if ($last_checkin) { $km_tempuh = $checkin->km_fleet - $last_checkin->km_fleet; } $returndata = array('id' => $checkin->id, 'nip' => $driverinfo->nip, 'name' => $driverinfo->name, 'taxi_number' => $fleetinfo->taxi_number, 'police_number' => $fleetinfo->police_number, 'pool_id' => $fleetinfo->pool_id, 'pool' => Pool::find($fleetinfo->pool_id)->pool_name, 'operasi_status_id' => $checkin->operasi_status_id, 'shift_id' => $checkin->shift_id, 'setoran_wajib' => $datapayment[1], 'tab_sp' => $datapayment[2], 'pot' => $datapayment[4], 'denda' => $datapayment[3], 'iuran_laka' => $datapayment[8], 'biaya_tc' => $datapayment[7], 'tag_spart' => $datapayment[5], 'tag_ks' => $datapayment[6], 'tag_cicilan_dp' => $datapayment[9], 'tag_dp_spart' => $datapayment[13], 'tag_hut_lama' => $datapayment[10], 'tag_other' => $datapayment[12], 'ks' => $datapayment[20] - ($datapayment[1] + $datapayment[2] + $datapayment[3] + $datapayment[8] + $datapayment[7] + $datapayment[5] + $datapayment[6] + $datapayment[9] + $datapayment[13] + $datapayment[10] + $datapayment[12] - $datapayment[4]), 'cash' => $datapayment[20], 'in_time' => $checkin->checkin_time, 'km_tempuh' => $km_tempuh, 'total' => $datapayment[1] + $datapayment[2] + $datapayment[3] + $datapayment[8] + $datapayment[7] + $datapayment[5] + $datapayment[6] + $datapayment[9] + $datapayment[13] + $datapayment[10] + $datapayment[12] - $datapayment[4]); return json_encode($returndata); }
{{ $fl->taxi_number }} @endif </span></td> <td>( {{$bravo->nip}} ) {{$bravo->name}} </td> <td>@if($charlie) ( {{$charlie->nip}} ) {{$charlie->name}} </td> @else Tidak Ada Charlie @endif </td> <td>{{ HTML::link('anakasuh/remove/'.$fleet->id ,'Hapus',array('class'=>'btn btn-mini btn-success')) }}</td> </tr> @else <tr> <td>{{ $no }}</td> <td><span class="label label-success"><?php $fl = Fleet::find($fleet->fleet_id); ?> @if($fl) {{ $fl->taxi_number }} @endif</span></td> <td>Gugur KSO</td> <td></td> <td>{{ HTML::link('anakasuh/remove/'.$fleet->id ,'Hapus',array('class'=>'btn btn-mini btn-success')) }}</td> </tr> @endif <?php $no++; ?> @endforeach </tbody>
public function post_qzotorisasicetak() { $data = Input::json(); $username = $data->username; $password = $data->password; $ver2 = User::where('username', '=', $username)->first(); if ($ver2) { if (Hash::check($password, $ver2->password)) { Log::write('info', Request::ip() . ' User : '******' Event: Print SPJ otoritas', true); $scheduledate = Scheduledate::find($data->id); $schedule = Schedule::find($scheduledate->schedule_id); $scheduledate->fg_check = 1; $scheduledate->save(); $driverinfo = Driver::find($scheduledate->driver_id); $fleetinfo = Fleet::find($schedule->fleet_id); $ksoinfo = Kso::where_fleet_id($schedule->fleet_id)->where_actived(1)->first(); $this->data['driverinfo'] = $driverinfo; $this->data['fleetinfo'] = $fleetinfo; $this->data['pool'] = Pool::find($schedule->pool_id); $codeops = $data->statusops; $keterangan = $data->keterangan; if ((int) $codeops == 1) { if ($driverinfo->fg_blocked == 1) { $status = 5; $codeops = 7; } else { if ($driverinfo->fg_super_blocked == 1) { $status = 5; $codeops = 7; } else { if ($fleetinfo->fg_blocked == 1) { $status = 5; $codeops = 7; } else { if ($fleetinfo->fg_bengkel == 1) { $status = 6; $codeops = 4; } else { if ($fleetinfo->fg_super_blocked == 1) { $status = 5; $codeops = 7; } else { $status = 3; $codeops = $codeops; } } } } } } else { $status = 3; } $dateopertion = mktime(0, 0, 0, $schedule->month, $scheduledate->date, $schedule->year); $checkouts = Checkout::where_fleet_id($schedule->fleet_id)->where_operasi_time(date('Y-m-d', $dateopertion))->first(); if (!$checkouts) { //insert into to checkouts step $checkouts = new Checkout(); $checkouts->kso_id = $ksoinfo->id; $checkouts->operasi_time = date('Y-m-d', $dateopertion); $checkouts->fleet_id = $fleetinfo->id; $checkouts->driver_id = $driverinfo->id; $checkouts->checkout_step_id = $status; $checkouts->shift_id = $scheduledate->shift_id; $checkouts->user_id = Auth::user()->id; $checkouts->pool_id = Auth::user()->pool_id; $checkouts->printspj_time = date('Y-m-d H:i:s', Myfungsi::sysdate()); $checkouts->operasi_status_id = $codeops; $checkouts->keterangan = $keterangan; $checkouts->print_out_time = 1; $checkouts->otorisasi_user_id = $ver2->id; $checkouts->save(); if ((int) $codeops == 1) { $scheduledate->fg_check = 1; $scheduledate->save(); } if ((int) $codeops !== 1) { $cin = Checkin::create(array('kso_id' => $ksoinfo->id, 'fleet_id' => $fleetinfo->id, 'driver_id' => $driverinfo->id, 'checkin_time' => date('Y-m-d H:i:s', Myfungsi::sysdate()), 'shift_id' => $scheduledate->shift_id, 'km_fleet' => 0, 'rit' => 0, 'incomekm' => 0, 'operasi_time' => date('Y-m-d', $dateopertion), 'pool_id' => Auth::user()->pool_id, 'operasi_status_id' => $codeops, 'fg_late' => '', 'checkin_step_id' => 12, 'document_check_user_id' => Auth::user()->id, 'physic_check_user_id' => '', 'bengkel_check_user_id' => '', 'finance_check_user_id' => '', 'keterangan' => $keterangan)); if ($cin) { $docs = new Checkindocument(); $docs->checkin_id = $cin->id; $docs->save(); } //make can't print before setoran $setor = Fleet::find($fleetinfo->id); $setor->fg_setor = 1; $setor->save(); } } else { if ((int) $codeops !== 1) { $checkinstatus = Checkin::where_fleet_id($schedule->fleet_id)->where_operasi_time(date('Y-m-d', $dateopertion))->first(); if (!$checkinstatus) { $cin = Checkin::create(array('kso_id' => $ksoinfo->id, 'fleet_id' => $fleetinfo->id, 'driver_id' => $driverinfo->id, 'checkin_time' => date('Y-m-d H:i:s', Myfungsi::sysdate()), 'shift_id' => $scheduledate->shift_id, 'km_fleet' => 0, 'rit' => 0, 'incomekm' => 0, 'operasi_time' => date('Y-m-d', $dateopertion), 'pool_id' => Auth::user()->pool_id, 'operasi_status_id' => $codeops, 'fg_late' => '', 'checkin_step_id' => 12, 'document_check_user_id' => Auth::user()->id, 'physic_check_user_id' => '', 'bengkel_check_user_id' => '', 'finance_check_user_id' => '', 'keterangan' => $keterangan)); if ($cin) { $docs = new Checkindocument(); $docs->checkin_id = $cin->id; $docs->save(); } } } //reprint after open blocking if ((int) $codeops == 1) { $checkinremove = Checkin::where_fleet_id($schedule->fleet_id)->where_operasi_time(date('Y-m-d', $dateopertion))->where_in('operasi_status_id', array(2, 3, 4, 5, 6, 7))->first(); if ($checkinremove) { $checkinremove->delete(); //make can print before setoran becouse update set on checkout step $setor = Fleet::find($schedule->fleet_id); $setor->fg_setor = 0; $setor->save(); } } if ((int) $codeops == 1) { $scheduledate->fg_check = 1; $scheduledate->save(); } $checkouts->kso_id = $ksoinfo->id; $checkouts->operasi_time = date('Y-m-d', $dateopertion); $checkouts->fleet_id = $fleetinfo->id; $checkouts->driver_id = $driverinfo->id; $checkouts->checkout_step_id = $status; $checkouts->shift_id = $scheduledate->shift_id; $checkouts->user_id = Auth::user()->id; $checkouts->pool_id = Auth::user()->pool_id; $checkouts->operasi_status_id = $codeops; $checkouts->printspj_time = date('Y-m-d H:i:s', Myfungsi::sysdate()); $checkouts->keterangan = $keterangan; $checkouts->print_out_time = 1; $checkouts->otorisasi_user_id = $ver2->id; $checkouts->save(); } $content = ""; if ($checkouts->operasi_status_id == 1) { $kopsurat = 'SURAT PERINTAH JALAN'; $content .= "Nama dan kendaraan yang tercantum diatas"; $content .= "DI IZINKAN untuk mengoprasikan kendaraan"; $content .= "PT.DIAN TAKSI sesuai dengan tanggal yang"; $content .= "tercantum diatas\r\n"; $content .= "--------------------------------------- \r\n"; $content .= "a"; // 1 SET CENTER PAGE $content .= "Tanda Tangan \r\n"; $content .= "a"; // 1 SET LEFT PAGE $content .= "--------------------------------------- \r\n"; $content .= " Bag. Operasi Security \r\n"; $content .= "\r\n \r\n \r\n"; } else { $kopsurat = 'SURAT PENGANTAR PROSES BAP'; $content .= "Nama dan kendaraan yang tercantum diatas"; $content .= "TIDAK DI IZINKAN mengoprasikan kendaraan"; $content .= "PT.DIAN TAKSI sesuai dengan tanggal yang"; $content .= "tercantum diatas\r\n"; } $headerPrint = ""; for ($j = 1; $j < 2; $j++) { $headerPrint .= "@"; $headerPrint .= "a"; // 1 SET CENTER PAGE $headerPrint .= "!"; $headerPrint .= $kopsurat . " \r\n"; $headerPrint .= "!"; $headerPrint .= "@"; // 1 RESET $headerPrint .= "a"; // 1 SET CENTER PAGE $headerPrint .= "PT. DHARMA INDAH AGUNG METROPOLITAN \r\n"; $headerPrint .= "POOL " . Pool::find($checkouts->pool_id)->pool_name . " \r\n"; $headerPrint .= "======================================= \r\n"; $headerPrint .= "a"; // 1 SET LEFT PAGE //content printer $headerPrint .= "Nama : " . substr($driverinfo->name, 0, 25) . " \r\n"; $headerPrint .= "Nip : " . $driverinfo->nip . " \r\n"; $headerPrint .= "Body : " . $fleetinfo->taxi_number . " \r\n"; $headerPrint .= "Tgl Operasi : " . date('d/m/Y', strtotime($checkouts->operasi_time)) . " \r\n"; $headerPrint .= "--------------------------------------- \r\n"; $headerPrint .= $content; $headerPrint .= "======================================= \r\n"; $headerPrint .= "Tanggal Cetak " . date('d/m/Y H:i:s', MyFungsi::sysdate(date('Y-m-d H:i:s'))) . " \r\n"; $headerPrint .= "Lembar ke - " . $j . " \r\n"; $headerPrint .= "\f"; // 5 FF $headerPrint .= "VA"; // 4 motong kertas $headerPrint .= "@"; // 5 END } //create temp file $file = 'dataprintspj' . $checkouts->pool_id . '.txt'; $myFile = path('public') . '/qzprint/templatedata/' . $file; $fh = fopen($myFile, 'w') or die("can't open file"); $resetPrint = ""; fwrite($fh, $resetPrint); $dataPrint = $headerPrint; fwrite($fh, $dataPrint); fclose($fh); return json_encode(array('status' => 1, 'urlfile' => $file)); } } }