public function post_searchDriver()
{
$jsondata = Input::json();
$date = $jsondata->date;
$timestamp = strtotime($date);
$drivers = Checkout::join('drivers as d', 'd.id', '=', 'checkouts.driver_id')->where_operasi_time($date)->where('checkouts.pool_id', '=', Auth::user()->pool_id)->where('d.fg_blocked', '=', 1)->where('d.nip', 'LIKE', '%' . $jsondata->taxi_number . '%')->get(array('d.name', 'd.nip', 'checkouts.id'));
$driverdata = array_map(function ($object) {
return $object->to_array();
}, $drivers);
$data['drivers'] = $driverdata;
return json_encode($data);
}
public function post_searchChekouts()
{
$jsondata = Input::json();
$date = $jsondata->date;
$timestamp = strtotime($date);
//list armada on checkouts
$fleets = Checkout::join('fleets as f', 'f.id', '=', 'checkouts.fleet_id')->where_operasi_time($date)->where('checkouts.pool_id', '=', Auth::user()->pool_id)->where('f.taxi_number', 'LIKE', '%' . $jsondata->taxi_number . '%')->get(array('f.taxi_number', 'checkouts.id'));
$fleetdata = array_map(function ($object) {
return $object->to_array();
}, $fleets);
$data['fleets'] = $fleetdata;
return json_encode($data);
}
public function get_fleetsoncheckin()
{
$date = Input::get('date', date('Y-m-d'));
$pool_id = Auth::user()->pool_id;
$fleets_on_checkin = Checkout::join('fleets as f', 'f.id', '=', 'checkouts.fleet_id')->where_operasi_time($date)->where('checkouts.pool_id', '=', $pool_id)->where('checkouts.checkout_step_id', '=', 4)->where('checkouts.operasi_status_id', '=', 1)->order_by('f.taxi_number', 'asc')->get(array('f.taxi_number', 'checkouts.id'));
$datas = array_map(function ($object) {
return $object->to_array();
}, $fleets_on_checkin);
return Response::json($datas);
}
