public function get_exportcheckin()
{
$date = Input::get('tanggal', date('Y-m-d'));
$checkins = Checkin::join('fleets as f', 'f.id', '=', 'checkins.fleet_id')->join('drivers as d', 'd.id', '=', 'checkins.driver_id')->where_operasi_time($date)->where('checkins.pool_id', '=', Auth::user()->pool_id)->order_by('f.taxi_number', 'asc')->get(array('f.taxi_number', 'd.nip', 'd.name', 'checkins.*'));
$this->data['tanggal'] = $date;
$this->data['checkins'] = $checkins;
return View::make('themes.modul.' . $this->views . '.expcheckin', $this->data);
}
public function post_searchChekins()
{
$jsondata = Input::json();
$date = $jsondata->date;
$timestamp = strtotime($date);
//list armada on checkouts
$fleets = Checkin::join('fleets as f', 'f.id', '=', 'checkins.fleet_id')->where_operasi_time($date)->where('checkins.pool_id', '=', Auth::user()->pool_id)->order_by('f.taxi_number', 'asc')->where('f.taxi_number', 'LIKE', '%' . $jsondata->taxi_number . '%')->get(array('f.taxi_number', 'checkins.id'));
$fleetdata = array_map(function ($object) {
return $object->to_array();
}, $fleets);
$data['fleets'] = $fleetdata;
return json_encode($data);
}
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 post_searchafterpay()
{
$jsondata = Input::json();
$fleets = Checkin::join('fleets', 'fleets.id', '=', 'checkins.fleet_id')->where('fleets.taxi_number', 'LIKE', '%' . $jsondata->taxi_number . '%')->where('checkins.operasi_time', '=', $jsondata->date)->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_fleetsonbeforepay()
{
$date = Input::get('date', date('Y-m-d'));
$pool_id = Auth::user()->pool_id;
$fleets_on_before_pay = Checkin::join('fleets as f', 'f.id', '=', 'checkins.fleet_id')->where_operasi_time($date)->where('checkins.pool_id', '=', $pool_id)->where('checkins.checkin_step_id', '=', 11)->where('checkins.operasi_status_id', '=', 1)->order_by('f.taxi_number', 'asc')->get(array('f.taxi_number', 'checkins.id'));
$datas = array_map(function ($object) {
return $object->to_array();
}, $fleets_on_before_pay);
return Response::json($datas);
}
