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'); $items = $items->paginate(); foreach($items as $item) { $item->status = Option::find($item->status); } return $this->success(['data' => $items->items()]); } }