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); }
public function get_autopart() { $query = Input::get('query'); $sp = Sparepart::where('part_number', 'LIKE', '%' . $query . '%')->get(); $spareparts = array_map(function ($object) { return $object->to_array(); }, $sp); return json_encode($spareparts); }
public function get_sparepart() { $query = Input::get('query'); $sparepart = Sparepart::where('part_number', 'LIKE', '%' . $query . '%')->take(5)->get(array('id', 'part_number', 'name_sparepart')); $sparepartdatas = array_map(function ($object) { return $object->to_array(); }, $sparepart); return json_encode($sparepartdatas); }