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));
}
}
}
