isAjax()) { $param = request()->all(); $where = []; $model = new Videotasks(); # 风险点 $project_id = isset($param['project_id']) ? $param['project_id'] : ''; if (!empty($project_id)) { $where[] = ['risk_management_id', '=', $project_id]; } else { $wherea1 = [['admin_id','=',admin_id()]]; $project_id = ((new ManagementAnnotations())->findOne($wherea1,'risk_management_id'))['data']['risk_management_id']; if (!$project_id) { # 查空 $where[] = ['risk_management_id', '<', 0]; } else { $where[] = ['risk_management_id', '=', $project_id]; } } $list = $model->getPaginateList($where, ['*'], ['id' => 'asc'], [], $param['limit']); if($list['total']>0) { foreach ($list['data'] as $key => $item) { $whereao = [['id','=',$item['project_org_id']]]; $nameData = ((new AdminOrg())->findOne($whereao,'name'))['data']; $list['data'][$key]['projectname'] = isset($nameData['name']) ? $nameData['name'] : ''; $AdminUserData = (new AdminUser) ->where('id', $item['report_user_id']) ->first('nickname'); $list['data'][$key]['user_name'] =$AdminUserData ? $AdminUserData['nickname'] : ''; } } return sparkSuccess(dataReturn(0, 'success', $list)); } return view('video/annotations/index'); } public function add(Request $request){ if ($request->isAjaxPost()) { $param = $request->post(); $model = new ManagementAnnotations(); $param['admin_id'] = admin_id(); $param['add_time'] = date('Y-m-d H:i:s'); $res = $model->insertOne($param); return sparkSuccess(dataReturn(0, '添加成功')); } return sparkSuccess(dataReturn(0, 'error')); } /** * 项目层级别树 * @param Request $request * @return \support\Response */ public function treeList(Request $request){ $param = $request->all(); $list = $this->getListorg(); return sparKSuccess(dataReturn(0, 'success', $list)); } /** 单位无分页列表 */ public function getListorg(){ $where = [['admin_id','=',admin_id()]]; $model = new ManagementAnnotations(); $res = $model->where($where)->select('risk_management_id')->groupBy('risk_management_id')->selectRaw('count(*) as num')->get()->toArray(); $list = []; foreach ($res as $k=>$v){ $list[$k]['value'] = $v['risk_management_id']; $list[$k]['label'] = (new Management())->where(['id'=>$v['risk_management_id']])->value('name'); $list[$k]['id'] = $v['risk_management_id']; } return $list; } }