model = new InnerDevice(); } public function get(Request $request) { if($request->input('type') == 'drop_menu') { $items = $this->model->get()->pluck('name')->unique()->map(function($item) { return collect(['text' => $item, 'value' => $item]); }); $items = $items->prepend(collect(['text' => '设备名称', 'value' => ''])); return $this->success(['data' => $items]); } $items = $this->model->get(); return $this->success(['data' => $items]); } public function search(Request $request) { $items = $this->model->with('workPoint', 'spec', 'device', 'device_name'); $equal_items = ['device_id', 'device_name_id', 'spec_id']; foreach ($equal_items as $item) { if($request->input($item)) { $items = $items->where($item, '=', $request->input($item)); } } $like_items = ['number']; foreach ($like_items as $item) { if($request->input($item)) { $keyword = '%' . $request->input($item) . '%'; $items = $items->where($item, 'like', $keyword); } } $in_items = ['project_ids', 'work_point_ids']; $key_items = ['project_id', 'work_point_id']; foreach ($in_items as $key => $item) { if($request->input($item)) { $ids = collect($request->input($item))->filter(function($id) { return $id; }); if($ids->count() > 0) { $items = $items->whereIn($key_items[$key], $ids); } } } // $items = $items->orderBy('created_at'); $stat_items = []; if($request->input('stat')) { $stat_items = $this->getStat($items); } $items = $items->paginate(); foreach($items as $item) { $item->status = Option::find($item->status); } return $this->success(['data' => $items->items(), 'stat' => $stat_items]); } public function getStat($items) { $items = $items->get(); $types = ['free', 'using', 'repair', 'scrap']; $result = []; foreach ($types as $type) { $id = Option::get('inner_devices', 'status', $type); $num = $items->where('status', $id)->count(); $result[$type] = $num; } return $result; } public function detail(Request $request) { $item = $this->model->with('workPoint', 'spec', 'device', 'device_name')->find($request->input('id')); if(!$item) $this->error(['msg' => '未找到设备']); $item['status'] = Option::find($item['status']); return $this->success(['data' => $item]); } }