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