all(); if(!$params['xjdw']){ return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result['status'] = true; $result['msg'] = ApiEnum::RETURN_SUCCESS; $result['data'] = []; $list = DB::connection('mysql_fwe10')->table('uf_zhxx_qlczgry')->where('dwmc',$params['xjdw'])->get(); if(count($list) > 0){ for($i=0;$izgrxm.'|'.$list[$i]->zgrgh; } } return $result; } //网格化录入 public function addConition(Request $request) { $params = Input::get(); if (!$params) { return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result = ApiService::addConition($params); return self::successResponse($result); } //网格化整改 public function editConition(Request $request){ $params = Input::get(); if (!$params) { return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result = ApiService::editConition($params); return self::successResponse($result); } //网格化人员轨迹查询条件 public function getQueryConition(Request $request) { $date = Input::get('date', ''); if (!$date) { return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result = ApiService::getQueryConitions($date); return self::successResponse($result); } //网格化人员轨迹 public function getPersonTravel(Request $request) { $person_id = Input::get('person_id', ''); $depart = Input::get('depart', ''); $date = Input::get('date', ''); if (!$person_id || !$depart) { return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result = ApiService::getPersonTravel($person_id, $depart, $date); return self::successResponse($result); } //网格化巡检记录查询条件 public function getResultConition() { $result = ApiService::getResultConition(); return self::successResponse($result); } //网格化巡检记录查询 public function getResultRecord() { $depart = Input::get('depart', 'all'); $date_type = Input::get('date_type', 'week'); $result = ApiService::getResultRecord($depart, $date_type); return self::successResponse($result); } //网格化巡检记录列表 public function getResultList() { $person_id = Input::get('person_id', ''); $depart = Input::get('depart', 'all'); $date_type = Input::get('date_type', 'week'); if (!$person_id) { return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result = ApiService::getResultList($person_id, $depart, $date_type); return self::successResponse($result); } //网格化巡检记录列表明细 public function getResultDlist() { $person_id = Input::get('person_id', ''); $depart = Input::get('depart', ''); $date = Input::get('date', ''); if (!$person_id || !$depart || !$date) { return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result = ApiService::getResultDlist($person_id, $depart, $date); return self::successResponse($result); } //网格化巡检记录明细 public function getResultDetail() { $id = Input::get('id', ''); if (!$id) { return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result = ApiService::getResultDetails($id); return self::successResponse($result); } //网格化巡检记录 public function getFinalList() { $start_date = Input::get('start_date', ''); $end_date = Input::get('end_date', ''); $depart = Input::get('depart', ''); $person = Input::get('person', ''); if (!$start_date || !$end_date) { return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result = ApiService::getFinalList($start_date, $end_date, $depart, $person); return self::successResponse($result); } //设备管理添加设备单位列表 public function sbglUnitList(){ $result['status'] = true; $result['msg'] = ApiEnum::RETURN_SUCCESS; $result['data'] = []; $unit_list = DB::connection('mysql_fwe10')->table('uf_zhxx_sbgl_qygl')->where('is_delete',0)->get(); foreach($unit_list as $k => $v){ $result['data'][] = [ 'id' => $v->ID, 'qymc' => $v->qymc ]; } return self::successResponse($result); } //设备管理添加设备新设备负责人列表 public function sbglNewPeopleList(){ $unit_id = Input::get('unit_id', ''); if (!$unit_id) { return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result['status'] = true; $result['msg'] = ApiEnum::RETURN_SUCCESS; $result['data'] = []; $new_people_list = DB::connection('mysql_fwe10')->table('uf_zhxx_sbgl_rygl')->where('ssdw',$unit_id)->where('is_delete',0)->get(); foreach($new_people_list as $k => $v){ $result['data'][] = [ 'id' => $v->ID, 'xm' => $v->xm ]; } return self::successResponse($result); } //设备管理添加新设备 public function sbglAdd(Request $request){ $params = Input::get(); if (!$params) { return self::errorResponse(ApiEnum::STATUS_CODE_EMPTY); } $result['status'] = true; $result['msg'] = ApiEnum::RETURN_SUCCESS; $result['data'] = []; $id = mt_rand(pow(10, 18), pow(10, 18) + 999999999); $insert = [ 'ID' => $id, 'FORM_DATA_ID' => $id, 'DATA_INDEX' => 0.0, 'CREATE_TIME' => date('Y-m-d H:i:s'), 'TENANT_KEY' => 't1zz9w8165', 'IS_DELETE' => 0, 'DELETE_TYPE' => 0, 'FT_STATUS' => 0, 'ssdw' => $params['qymc'], 'xsbdhfzr' => $params['xsbdhfzr'], 'sbmc' => $params['sbmc'], 'sbzp' => $params['sbzp'], 'rhzq' => $params['rhzq'], 'sbbh' => $params['sbbh'], 'ggxh' => $params['ggxh'], 'jscs' => $params['jscs'], 'sccj' => $params['sccj'], 'ccrq' => $params['ccrq'], 'dhrq' => $params['dhrq'], 'azrq' => $params['azrq'], 'syrq' => $params['syrq'], 'zyfssb' => $params['zyfssb'], 'ptjsj' => $params['ptjsj'], 'ylohq' => $params['ylohq'], 'ptqt' => $params['ptqt'], 'zypj' => $params['zypj'], 'bz' => $params['bz'], 'sbzt' => 0, 'sylx' => 4 ]; DB::connection('mysql_fwe10')->table('uf_uf_zhxx_sbgl')->insert($insert); return self::successResponse($result); } }