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