menusActive[0] = 'adminCamera'; $this->menusActive[1] = 'adminCameraList'; $camera_list = CameraList::join( 'mine_list', 'camera_list.mine_id', '=', 'mine_list.id' )->select( 'camera_list.id', 'camera_list.camera_url', 'mine_list.title' )->get(); $tableObj = new TableAuxiliary('camera/list', $camera_list); $tableObj->topActions = ['export', 'import', 'importTemplate']; $tableObj->column('title', '矿区名称'); $tableObj->column('camera_url', '链接'); return $this->tableList($tableObj); } //添加摄像头列表 public function cameraListAdd(Request $request) { $mineService = new MineServices(); $mineService->initMineList(); $titleList = $mineService->getTierList(); // $field_list = CameraFieldList::select( // [ // 'id', // 'field_name' // ] // )->get(); // // $field_arr = []; // foreach ($field_list as $key => $val) { // $field_arr[$val['id']] = $val['field_name']; // } $formObj = new FromAuxiliary('camera/list/add'); $formObj->tree_select('mine_id', '矿区单位', $titleList); $formObj->input('camera_url', '请求链接'); // $formObj->checkbox('camera_field', '字段', $field_arr); $formObj->title = '添加请求链接'; return $this->from($formObj); } //添加摄像头列表操作 public function cameraListAddPost(Request $request) { if (!$request->input('mine_id')) { return $this->error(1, '请选择矿区单位'); } if (!$request->input('camera_url')) { return $this->error(1, '请输入请求链接'); } $result = CameraServices::addCameraList($request->all()); if (!$result['status']) { return $this->error(1, $result['msg']); } return $this->redirect('admin/camera/list'); } //导入摄像头列表 public function cameraListImport(Request $request) { if (!$request->hasFile('excel')) { return $this->error(9001, '缺少上传文件'); } ini_set('memory_limit', '500M'); set_time_limit(300); $reader = ReaderEntityFactory::createReaderFromFile($request->file('excel')->getClientOriginalName()); $reader->open($request->file('excel')->getRealPath()); $sheet = $reader->getSheetIterator(); // 获取sheet对象 $sheet->rewind(); // 指定当前sheet序数 $sheet = $sheet->current(); // 获取指定sheet $arr = []; foreach ($sheet->getRowIterator() as $index => $row) { // 读取每行记录 if ($index == 1) { continue; } $arr[] = $row->toArray(); } $reader->close(); CameraListExcel::dispatch($arr); return $this->success(); } //字段列表 public function fieldList(Request $request) { $this->menusActive[0] = 'adminCamera'; $this->menusActive[1] = 'adminCameraFieldlist'; $field_list = CameraFieldList::get(); $tableObj = new TableAuxiliary('camera/field_list', $field_list); $tableObj->actionBtns = ['edit', 'del']; $tableObj->column('field_name', '字段名称'); return $this->tableList($tableObj); } //添加字段 public function fieldListAdd(Request $request) { $formObj = new FromAuxiliary('camera/field_list/add'); $formObj->input('field_name', '字段名称'); $formObj->title = '添加字段'; return $this->from($formObj); } //添加字段操作 public function fieldListAddPost(Request $request) { if (!$request->input('field_name')) { return $this->error(1, '请输入字段名称'); } $result = CameraServices::addCameraFieldList($request->all()); if (!$result['status']) { return $this->error(1, $result['msg']); } return $this->redirect('admin/camera/field_list'); } //编辑字段 public function fieldListEdit(Request $request) { $field_list_id = $request->input('id'); if (empty($field_list_id)) { return $this->redirect('admin/camera/field_list'); } $field_list = CameraFieldList::find($field_list_id); $fromObj = new FromAuxiliary('camera/field_list/edit', $field_list); $fromObj->input("field_name", "字段名称", $field_list->field_name); $fromObj->title = '修改字段'; return $this->from($fromObj); } //编辑字段操作 public function fieldListEditPost(Request $request) { if (!$request->input('field_name')) { return $this->error(1, '请输入字段名称'); } $result = CameraServices::editCameraFieldList($request->all()); if (!$result['status']) { return $this->error(1, $result['msg']); } return $this->redirect('admin/camera/field_list'); } //删除字段 public function fieldListDelPost(Request $request) { if (!$request->has('id')) { return $this->error(1, '缺少必要参数'); } $result = CameraServices::delCameraFieldList($request->all()); if (!$result['status']) { return $this->error(1, $result['msg']); } return $this->success(); } }