model = new AdminModel(); } /** * 查看 * @throws Throwable */ public function index(): void { if ($this->request->param('select')) { $this->select(); } list($where, $alias, $limit, $order) = $this->queryBuilder(); // halt($where, $alias, $limit, $order); // halt($where, $alias, $limit, $order,$this->withJoinTable); $res = $this->model ->withoutField('login_failure,password,salt') ->leftJoin("admin_group_access group",'admin.id = group.uid') ->alias($alias) ->where($where) ->where('group.group_id',3) ->order($order) ->paginate($limit); $this->success('', [ 'list' => $res->items(), 'total' => $res->total(), 'remark' => get_route_remark(), ]); } /** * 编辑 * @throws Throwable */ public function edit($id = null): void { $row = $this->model->find($id); if (!$row) { $this->error(__('Record not found')); } $dataLimitAdminIds = $this->getDataLimitAdminIds(); if ($dataLimitAdminIds && !in_array($row[$this->dataLimitField], $dataLimitAdminIds)) { $this->error(__('You have no permission')); } if ($this->request->isPost()) { $data = $this->request->post(); if (!$data) { $this->error(__('Parameter %s can not be empty', [''])); } if( $data['switch'] == 0 && !isset($data['types'])){ $this->error('请确保至少有一个学院审批人!'); } $data = $this->excludeFields($data); $result = false; $this->model->startTrans(); try { if( $data['switch'] == 1 && !isset($data['types'])){ $this->model->where('switch',1)->update(['switch' => 0]); } $result = $row->save($data); $this->model->commit(); } catch (Throwable $e) { $this->model->rollback(); $this->error($e->getMessage()); } if ($result !== false) { $this->success(__('Update successful')); } else { $this->error(__('No rows updated')); } } unset($row['salt'], $row['login_failure']); $row['password'] = ''; $this->success('', [ 'row' => $row ]); } }