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_simpanbap()
{
Log::write('info', Request::ip() . ' User : '******' Event: Simpan Proses BAP', true);
$lastnumber = Bap::max('id');
$num = myFungsi::numberComplate($lastnumber + 1, 5);
$total_amount = Input::get('total_amount');
$amount = Input::get('amount');
foreach (Input::get('financial_type_id') as $key => $val) {
if ($val == 6) {
$besar_ks = $total_amount[$key];
$bayar_ks = $amount[$key];
}
$ke = Kewajiban::where_fleet_id(Input::get('fleet_id'))->where_driver_id(Input::get('driver_id'))->where_financial_type_id($val)->first();
if ($ke) {
$ke->amount = $amount[$key];
$ke->total_amount = $total_amount[$key];
$ke->save();
} else {
Kewajiban::create(array('fleet_id' => Input::get('fleet_id'), 'driver_id' => Input::get('driver_id'), 'financial_type_id' => $val, 'amount' => $amount[$key], 'total_amount' => $total_amount[$key]));
}
}
$fleet_id = Input::get('fleet_id');
$bap_number = 'DT-' . $num . '/BAP/' . Fleet::find($fleet_id)->taxi_number . '/' . date('m') . '/' . date('Y');
$driver_id = Input::get('driver_id');
$driver_status = Input::get('driver_status');
$keputusan_id = Input::get('keputusan_id');
$pool_id = Input::get('pool_id');
$sum_sparepart = Input::get('sum_sparepart');
$sum_ks = Input::get('sum_ks');
$sum_akhir_unit = Input::get('sum_akhir_unit');
$lampiran = Input::get('lampiran');
$std_bap_id = implode(',', Input::get('pelanggaran'));
$ket_bap_other = Input::get('ket_bap_other');
$keterangan = Input::get('keterangan');
$solusi = Input::get('solusi');
$saksi1_name = Input::get('saksi1_name');
$saksi1_nik = Input::get('saksi1_nik');
$saksi1_jabatan = Input::get('saksi1_jabatan');
$saksi2_name = Input::get('saksi2_name');
$saksi2_nik = Input::get('saksi2_nik');
$saksi2_jabatan = Input::get('saksi2_jabatan');
$bap = Bap::create(array('date' => date('Y-m-d'), 'bap_number' => $bap_number, 'fleet_id' => $fleet_id, 'driver_id' => $driver_id, 'driver_status' => $driver_status, 'keputusan_id' => $keputusan_id, 'pool_id' => $pool_id, 'sum_sparepart' => $sum_sparepart, 'sum_ks' => $sum_ks, 'sum_akhir_unit' => $sum_akhir_unit, 'lampiran' => $lampiran, 'std_bap_id' => $std_bap_id, 'ket_bap_other' => $ket_bap_other, 'keterangan' => $keterangan, 'solusi' => $solusi, 'saksi1_name' => $saksi1_name, 'saksi1_nik' => $saksi1_nik, 'saksi1_jabatan' => $saksi1_jabatan, 'saksi2_name' => $saksi2_name, 'saksi2_nik' => $saksi2_nik, 'saksi2_jabatan' => $saksi2_jabatan, 'user_id' => Auth::user()->id, 'last_update' => date('Y-m-d H:i:s', Myfungsi::sysdate()), 'besar_ks' => $besar_ks, 'bayar_ks' => $bayar_ks));
return Redirect::to('proses');
}
public function post_toolspj()
{
$date = Input::get('tanggal', date('Y-m-d'));
ini_set('max_execution_time', 120);
$timestamp = strtotime($date);
//list armada on schedule
$arrayschedule = array();
$schedule = Schedule::where('month', '=', date('n', $timestamp))->where('year', '=', date('Y', $timestamp))->get(array('id', 'fleet_id'));
foreach ($schedule as $sc) {
$arrayschedule[] = $sc->id;
}
$fleets = array();
if (is_array($arrayschedule) && !empty($arrayschedule)) {
$fleets = Scheduledate::join('schedules', 'schedules.id', '=', 'schedule_dates.schedule_id')->join('fleets', 'fleets.id', '=', 'schedules.fleet_id')->join('ksos', 'ksos.fleet_id', '=', 'schedules.fleet_id')->where_in('schedule_dates.schedule_id', $arrayschedule)->where('schedules.pool_id', '=', Auth::user()->pool_id)->where('schedule_dates.date', '=', date('j', $timestamp))->where('schedules.month', '=', date('n', $timestamp))->where('schedule_dates.shift_id', '=', 1)->where('ksos.actived', '=', 1)->order_by('fleets.taxi_number', 'asc')->get(array('schedule_dates.id as id', 'schedule_dates.driver_id', 'schedules.fleet_id', 'fleets.taxi_number'));
}
if ($fleets) {
foreach ($fleets as $f) {
$scheduledate = Scheduledate::find($f->id);
$scheduledate->fg_check = 1;
$scheduledate->save();
$schedule = Schedule::find($scheduledate->schedule_id);
//$driverinfo = Driver::find($scheduledate->driver_id);
//$fleetinfo = Fleet::find($schedule->fleet_id);
$ksoinfo = Kso::where_fleet_id($schedule->fleet_id)->where_actived(1)->first();
$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();
//delete checkouts
if ($checkouts) {
$checkouts->delete();
}
$codeops = 1;
$status = 7;
$keterangan = 'Print SPJ melalui Tools';
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 = $schedule->fleet_id;
$checkouts->driver_id = $scheduledate->driver_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->save();
$cinada = Checkin::where('operasi_time', '=', date('Y-m-d', $dateopertion))->where('fleet_id', '=', $schedule->fleet_id)->first();
if ($cinada) {
$cinada->delete();
}
if (!$cinada) {
$cin = Checkin::create(array('kso_id' => $ksoinfo->id, 'fleet_id' => $schedule->fleet_id, 'driver_id' => $scheduledate->driver_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' => 2, '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();
//return Redirect::to('schedule');
}
//
}
}
}
return Redirect::to('schedule');
}
}
public function get_allafterpay($date = false)
{
if (!$date) {
$date = date('Y-m-d');
}
$date = date('Y-m-d', Myfungsi::sysdate($date));
$fleets = Checkin::join('fleets', 'fleets.id', '=', 'checkins.fleet_id')->where('checkins.pool_id', '=', Auth::user()->pool_id)->where('checkins.operasi_time', '=', $date)->where('checkins.checkin_step_id', '=', 3)->order_by('fleets.taxi_number', 'asc')->get(array('fleets.taxi_number', 'checkins.id'));
$fleetdatas = array_map(function ($object) {
return $object->to_array();
}, $fleets);
$data['fleet'] = $fleetdatas;
return json_encode($data);
}
public function get_allafterpay($date = false)
{
if (!$date) {
$date = date('Y-m-d');
}
$date = date('Y-m-d', Myfungsi::sysdate($date));
/*
$fleets = Checkin::where('pool_id', '=', Auth::user()->pool_id)
->where('operasi_time','=',$date)
->where('checkin_step_id','=',3)
->get(array('fleet_id','id'));
$data = array();
foreach ($fleets as $f) {
$data['fleet'][] = array('id' => $f->id, 'taxi_number' => ($fle = Fleet::find($f->fleet_id))? $fle->taxi_number : 'error fleet' );
}
return json_encode($data);
*/
$fleets = Checkin::join('fleets', 'fleets.id', '=', 'checkins.fleet_id')->where('checkins.pool_id', '=', Auth::user()->pool_id)->where('checkins.operasi_time', '=', $date)->where('checkins.checkin_step_id', '=', 3)->order_by('fleets.taxi_number', 'asc')->get(array('fleets.taxi_number', 'checkins.id'));
$fleetdatas = array_map(function ($object) {
return $object->to_array();
}, $fleets);
$data['fleet'] = $fleetdatas;
return json_encode($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);
}
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));
}
}
}
