Writereport.php 75 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350
  1. <?php
  2. namespace app\inter\controller;
  3. //use Doctrine\Common\Cache\Cache;
  4. use app\common\library\Message;
  5. use think\Controller;
  6. use think\Db;
  7. use think\Session;
  8. use app\common\library\UUIDs;
  9. use think\Cache;
  10. use think\Log;
  11. use app\common\library\Verify;
  12. use app\common\library\send_message;
  13. use app\inter\service\WechatService;
  14. class Writereport extends Base
  15. {
  16. /**
  17. * 写报告页面
  18. *
  19. * @ApiTitle (写报告页面)
  20. * @ApiSummary (写报告页面)
  21. * @ApiSector (远程诊断)
  22. * @ApiMethod (POST)
  23. * @ApiRoute (/inter/writereport/index)
  24. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  25. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  26. * @ApiHeaders (name="timestamp", type=string, required=truee, description="请求头-时间戳s")
  27. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  28. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  29. * @ApiParams (name="is_remote", type="string", required=true, description="是否为远程列表进入")
  30. * @ApiParams (name="param[id]", type="string", sample="", description="exams表id值<必填>")
  31. * @ApiParams (name="param[images]", type="string", sample="", description="影像图片<选填>")
  32. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  33. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  34. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  35. * @ApiReturnParams (name="is_remote", type="object", sample="{}", description="是否为远程诊断进入")
  36. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  37. * @ApiReturn (data="
  38. {
  39. 'status': ok,
  40. 'code': '0000',
  41. 'sessionid': 'a17z7a7a8f9g9rh9d89jio',
  42. 'is_remote': 1,
  43. 'info' : ''
  44. }
  45. *")
  46. **/
  47. public function index(){
  48. try{
  49. log::record('-----请求值-----');
  50. log::record($_REQUEST);
  51. log::record('-----请求值-----');
  52. $sessionid = $_REQUEST['sessionid'];
  53. if(isset($_REQUEST['is_remote']) && !empty($_REQUEST['is_remote'])){
  54. $is_remote = $_REQUEST['is_remote'];
  55. }else{
  56. $is_remote = 0;
  57. }
  58. $doctor = Cache::get($sessionid);
  59. $institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name,report_subtitle')->find();
  60. $param = $_REQUEST['param'];
  61. $id = $param['id'];
  62. $info = DB::table('exams')->where('id',$id)->field(['id','ext','study_id','exam_class','exam_status','exam_datetime','exam_sub_class','body_part','accession_num','patient_id','film_type','patient_area','bed_no','hopitalized_no'])->find();
  63. $exam_class = DB::table('constant')->where('id',$info['exam_class'])->field('constant_value')->find();
  64. $info['exam_class'] = $exam_class['constant_value'];
  65. $exam_subclass = DB::table('exam_subclass')->where('id',$info['exam_sub_class'])->field('name')->find();
  66. $info['exam_sub_class'] = $exam_subclass['name'];
  67. $patient_info = DB::table('patient_infos')->where('id',$info['patient_id'])->field(['id','temp_patient_id','name','phone','sex','age'])->find();
  68. $info['pid'] = $patient_info['temp_patient_id'];
  69. $info['name'] = $patient_info['name'];
  70. $info['sex'] = $patient_info['sex'];
  71. $info['age'] = $patient_info['age'];
  72. $info['phone'] = $patient_info['phone'];
  73. $info['hospital_name'] = $institution['name'];
  74. $info['hospital_title'] = $institution['report_subtitle'];
  75. $info['images'] = isset($param['images']) ? $param['images'] : '';
  76. if(isset($param['rid']) && !empty($param['rid'])){
  77. $remote_id = $param['rid'];
  78. $report = DB::table('report')->where('exam_id',$id)->where('remote_application_id',$remote_id)->field('qr_code,id,remote_application_id,report_result,report_datetime,report_doctor_id,review_datetime,review_doctor_id,impression,description')->find();
  79. $sta = DB::table('remote_application')->where('id',$remote_id)->field('report_status')->find();
  80. $info['report_status'] = $sta['report_status'];
  81. $r_id = $report['remote_application_id'];
  82. }else{
  83. // 不存在 本地点击进入 获取本地报告
  84. $report = DB::table('report')->where('exam_id',$id)->where('type',1)->field('qr_code,id,remote_application_id,report_result,report_datetime,report_doctor_id,review_datetime,review_doctor_id,impression,description')->find();
  85. $info['report_status'] = '';
  86. $r_report = DB::table('report')->where('exam_id',$id)->where('type',2)->field('remote_application_id')->find();
  87. $r_id = $r_report['remote_application_id'];
  88. }
  89. if( $r_id == ''){
  90. $info['remote'] = 1;
  91. }else{
  92. $info['remote'] = 2;
  93. }
  94. $report_doctor = DB::table('doctors')->where('id',$report['report_doctor_id'])->field('realname')->find();
  95. $info['report_doctor'] = $report_doctor['realname'];
  96. $info['report_datetime'] = $report['report_datetime'];
  97. $review_doctor = DB::table('doctors')->where('id',$report['review_doctor_id'])->field('realname')->find();
  98. $info['review_doctor'] = $review_doctor['realname'];
  99. $info['review_datetime'] = $report['review_datetime'];
  100. $info['description'] = $report['description'];
  101. $info['impression'] = $report['impression'];
  102. $info['report_result'] = $report['report_result'];
  103. $info['report_id'] = $report['id'];
  104. $info['qr_code'] = $report['qr_code'];
  105. $cache_key = $doctor['id'].'_'.$report['id'];
  106. if(Cache::get($cache_key)){
  107. $cache = Cache::get($cache_key);
  108. $info['description'] = isset($cache['description']) ? $cache['description'] : '';
  109. $info['impression'] = isset($cache['impression']) ? $cache['impression'] : '';
  110. $info['report_result'] = isset($cache['r_result']) ?$cache['r_result'] : '';
  111. $info['name'] = isset($cache['name']) ? $cache['name'] : '';
  112. $info['sex'] = isset($cache['sex']) ? $cache['sex'] : '';
  113. $info['age'] = isset($cache['age']) ? $cache['age'] : '';
  114. $info['phone'] = isset($cache['phone']) ? $cache['phone'] : '';
  115. $info['patient_area'] = isset($cache['patient_area']) ? $cache['patient_area'] : '';
  116. $info['hopitalized_no'] = isset($cache['hopitalized_no']) ? $cache['hopitalized_no'] : '';
  117. $info['bed_no'] = isset($cache['bed_no']) ? $cache['bed_no'] : '';
  118. }
  119. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid,'is_remote'=>$is_remote]);
  120. }catch(\Exception $e){
  121. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  122. }
  123. }
  124. /**
  125. * 上远程申请附件
  126. *
  127. * @ApiTitle (上远程申请附件)
  128. * @ApiSummary (上远程申请附件)
  129. * @ApiSector (远程诊断)
  130. * @ApiMethod (POST)
  131. * @ApiRoute (/inter/writereport/upload)
  132. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  133. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  134. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  135. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  136. * @ApiParams (name="file", type="string", required=true, description="上传的文件<必填>")
  137. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  138. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  139. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  140. * @ApiReturn (data="
  141. {
  142. 'status': ok,
  143. 'code': '0000',
  144. 'info' : '/upload/20180101/12346asd.jpg'
  145. }
  146. *")
  147. **/
  148. public function upload($files){
  149. // 获取表单上传文件
  150. foreach($files as $file){
  151. // 移动到框架应用根目录/public/uploads/ 目录下
  152. $info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
  153. if($info){
  154. return $info->getSaveName();
  155. // 成功上传后 获取上传信息
  156. // 输出 jpg
  157. // echo $info-> getExtension();
  158. // 输出 42a79759f284b767dfcb2a0197904287.jpg
  159. // echo $info->getFilename();
  160. }else{
  161. // 上传失败获取错误信息
  162. // echo $file->getError();
  163. }
  164. }
  165. }
  166. /**
  167. * 报告保存
  168. *
  169. * @ApiTitle (报告保存)
  170. * @ApiSummary (报告保存)
  171. * @ApiSector (远程诊断)
  172. * @ApiMethod (POST)
  173. * @ApiRoute (/inter/writereport/write)
  174. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  175. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  176. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  177. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  178. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  179. * @ApiParams (name="is_remote", type="string", required=true, description="是否为远程列表进入")
  180. * @ApiParams (name="param[id]", type="string", sample="", description="exams表id值<必填>")
  181. * @ApiParams (name="param[pid]", type="string", sample="", description="患者id值<必填>")
  182. * @ApiParams (name="param[name]", type="string", sample="", description="患者姓名<必填>")
  183. * @ApiParams (name="param[age]", type="string", sample="", description="患者年龄<必填>")
  184. * @ApiParams (name="param[sex]", type="string", sample="", description="患者性别<必填>")
  185. * @ApiParams (name="param[impression]", type="string", sample="", description="影响所见<必填>")
  186. * @ApiParams (name="param[description]", type="string", sample="", description="意见建议<必填>")
  187. * @ApiParams (name="param[film_type]", type="string", sample="", description="胶片<必填>")
  188. * @ApiParams (name="param[r_result]", type="string", sample="", description="检查结果<必填>")
  189. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  190. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  191. * @ApiReturnParams (name="msg", type="string", required=true, sample="返回成功", description="返回消息")
  192. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  193. * @ApiReturn (data="
  194. {
  195. 'status': ok,
  196. 'code': '0000',
  197. 'sessionid': 'a17z7a7a8f9g9rh9d89jio',
  198. 'msg' : '保存成功'
  199. }
  200. *")
  201. **/
  202. public function write(){
  203. try{
  204. $sessionid = $_REQUEST['sessionid'];
  205. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  206. // 是远程写报告 7
  207. $return = Verify::check_role($sessionid,7);
  208. }else{
  209. // 本地写报告权限 2
  210. $return = Verify::check_role($sessionid,2);
  211. }
  212. if($return != 1){
  213. return json_encode(['status'=>'fail','code'=>'1029','msg'=>'没有操作权限']);
  214. }
  215. $param = $_REQUEST['param'];
  216. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  217. //远程
  218. $status = DB::table('remote_application')->where('id',$param['rid'])->field('report_status')->find();
  219. if($status['report_status'] == 12){
  220. return json_encode(['status'=>'fail','code'=>'1034','msg'=>'报告已被撤回,无法进行保存填写']);
  221. }elseif($status['report_status'] > 7 && $status['report_status'] != 13){
  222. return json_encode(['status'=>'fail','code'=>'1034','msg'=>'报告已被审核,无法再次被保存']);
  223. }
  224. }else{
  225. //本地
  226. $status = DB::table('exams')->where('id',$param['id'])->field('exam_status')->find();
  227. if($status['exam_status'] > 6 && $status['exam_status'] != 13){
  228. return json_encode(['status'=>'fail','code'=>'1034','msg'=>'报告已被保存,无法再次被修改']);
  229. }
  230. }
  231. // Verify::wreportCheck($param);
  232. $doctor = Cache::get($sessionid);
  233. // $remote_app = DB::table('remote_application')->where('exam_id',$param['id'])->field('remote_doctor_id')->find();
  234. // if(!empty($remote_app['remote_doctor_id'])){
  235. // if($remote_app['remote_doctor_id'] != $doctor['id']){
  236. // return json_encode(['status'=>'fail','code'=>'1029','msg'=>'已被指定报告医生,您没有操作权限']);
  237. // }
  238. // }
  239. $this->uuids = new UUIDs();
  240. //初步报告生成
  241. $film_type = isset($param['film_type']) ? $param['film_type'] : '';
  242. // $exam_status = $this->get_exam_status($doctor['id'],7);
  243. $patient_info = array();
  244. $patient_info['id'] = isset($param['pid']) ? $param['pid'] : '';
  245. $patient_info['name'] = isset($param['name']) ? $param['name'] : '';
  246. $patient_info['age'] = isset($param['age']) ? $param['age'] : '';
  247. $patient_info['phone'] = isset($param['phone']) ? $param['phone'] : '';
  248. if(isset($param['sex']) && !empty($param['sex'])){
  249. switch($param['sex']){
  250. case '男';
  251. $sex = 'M';
  252. break;
  253. case '女';
  254. $sex = 'F';
  255. break;
  256. case 'm';
  257. $sex = 'M';
  258. break;
  259. case 'f';
  260. $sex = 'F';
  261. break;
  262. default :
  263. $sex = $param['sex'];
  264. }
  265. $patient_info['sex'] = $sex;
  266. }
  267. $patient = DB::table('patient_infos')->where('id',$param['pid'])->update($patient_info);
  268. $info = array();
  269. $info['exam_id'] = $param['id'];
  270. $info['impression'] = isset($param['impression']) ? $param['impression'] : '';
  271. $info['description'] = isset($param['description']) ? $param['description'] : '';
  272. $exam_info = [];
  273. $exam_info['patient_area'] = isset($param['patient_area']) ? $param['patient_area'] : '';
  274. $exam_info['hopitalized_no'] = isset($param['hopitalized_no']) ? $param['hopitalized_no'] : '';
  275. $exam_info['bed_no'] = isset($param['bed_no']) ? $param['bed_no'] : '';
  276. $exam_info['film_type'] = $film_type;
  277. $exam_info['phone'] = isset($param['phone']) ? $param['phone'] : '';
  278. $exam_info['exam_report'] = isset($param['report_result']) ? $param['report_result'] : '';
  279. if(isset($param['r_result']) && $param['r_result'] == 'true'){
  280. $info['report_result'] = 2;
  281. }else{
  282. $info['report_result'] = 1;
  283. }
  284. DB::table('exams')->where('id',$param['id'])->update($exam_info);
  285. // 报告的id
  286. $report_id = $param['report_id'];
  287. if(isset($_REQUEST['is_remote']) && !empty($_REQUEST['is_remote'])){
  288. // 远程保存
  289. DB::table('remote_application')->where('id',$param['rid'])->update(['report_status'=>'7']);
  290. $info['type'] = 2;
  291. }else{
  292. //本地保存
  293. DB::table('exams')->where('id',$param['id'])->update(['exam_status'=>'7']);
  294. $info['type'] = 1;
  295. }
  296. $info['report_datetime'] = date('Y-m-d H:i:s',time());
  297. $info['report_doctor_id'] = $doctor['id'];
  298. $info['remote_application_id'] = $param['rid'];
  299. if($report_id){
  300. $report_info = DB::table('report')->where('id',$report_id)->find();
  301. $report = DB::table('report')->where('id',$report_id)->update($info);
  302. $id = $report_info['id'];
  303. $cache_key = $doctor['id'].'_'.$report_id;
  304. $rid = $report_id;
  305. } else {
  306. $id = $this->uuids->uuid16();
  307. $info['id'] = $id;
  308. $info['createdAt'] = date('Y-m-d H:i:s',time());
  309. $report = DB::table('report')->insert($info);
  310. $cache_key = $doctor['id'].'_'.$id;
  311. $rid = $id;
  312. }
  313. if(Cache::get($cache_key)){
  314. Cache::rm($cache_key);
  315. }
  316. //写入log日志
  317. log::record('----日志写入----');
  318. $log = array();
  319. $log['id'] = UUIDs::uuid16();
  320. $log['impression'] = isset($param['impression']) ? $param['impression'] : '';
  321. $log['description'] = isset($param['description']) ? $param['description'] : '';
  322. $log['report_id'] = $rid;
  323. $log['createdAt'] = date('Y-m-d H:i:s',time());
  324. $log['doctor_id'] = $doctor['id'];
  325. $log['type'] = 1; //写报告
  326. log::record($log);
  327. $report_log = DB::table('report_record')->insert($log);
  328. log::record($report_log);
  329. log::record('----日志写入成功----');
  330. $application = DB::table('remote_application')->where('exam_id',$param['id'])->find();
  331. if($application['req_doctor_id'] == 'c44663d6d3c0b535'){
  332. $tel = '18910184804';
  333. $type = '保存报告';
  334. $content = $application['id'];
  335. // send_message::sendSms2Self($tel,$type,$content);
  336. }
  337. $url = 'http://wechat.pacsonline.cn/wx_patient/api/unifyGetWxQrcode?reportId='.$rid;
  338. $info = $this->curl_get($url);
  339. return json_encode(['status'=>'ok','code'=>'0000','msg'=>'保存成功','sessionid'=>$sessionid]);
  340. }catch(\Exception $e){
  341. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  342. }
  343. }
  344. public function get_exam_status($doctorid,$status){
  345. $doctor_class = DB::table('doctor_class')->where('doctor_id',$doctorid)->field('doctor_class')->find();
  346. if(strpos($doctor_class['doctor_class'],'9')){
  347. return 9;
  348. }elseif(strpos($doctor_class['doctor_class'],'8')){
  349. return 8;
  350. }else{
  351. return $status;
  352. }
  353. }
  354. /**
  355. * 公有模板列表
  356. *
  357. * @ApiTitle (公有模板列表)
  358. * @ApiSummary (公有模板列表)
  359. * @ApiSector (远程诊断)
  360. * @ApiMethod (POST)
  361. * @ApiRoute (/inter/writereport/public_template)
  362. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  363. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  364. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  365. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  366. * @ApiParams (name="exam_class", type="string", required=true, description="检查类id")
  367. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  368. * @ApiReturn (data="
  369. {
  370. 'info' : ''
  371. }
  372. *")
  373. **/
  374. public function public_template(){
  375. $sessionid = $_REQUEST['sessionid'];
  376. $doctor = Cache::get($sessionid);
  377. $exam = $_REQUEST['exam_class'];
  378. //第一级 公共模板
  379. $info = $this->get_template(1,$doctor['id'],$exam);
  380. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid]);
  381. }
  382. /**
  383. * 私有模板列表
  384. *
  385. * @ApiTitle (私有模板列表)
  386. * @ApiSummary (私有模板列表)
  387. * @ApiSector (远程诊断)
  388. * @ApiMethod (POST)
  389. * @ApiRoute (/inter/writereport/private_template)
  390. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  391. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  392. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  393. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  394. * @ApiParams (name="exam_class", type="string", required=true, description="检查类id")
  395. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  396. * @ApiReturn (data="
  397. {
  398. 'info' : ''
  399. }
  400. *")
  401. **/
  402. public function private_template(){
  403. $sessionid = $_REQUEST['sessionid'];
  404. $doctor = Cache::get($sessionid);
  405. $exam = $_REQUEST['exam_class'];
  406. //私有模板
  407. $info = $this->get_template(2,$doctor['id'],$exam);
  408. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid]);
  409. }
  410. public function get_template($public,$id,$exam){
  411. // 查询exam_class表
  412. $examCla = DB::table('constant')->where('id',$exam)->field('constant_value as name')->find();
  413. if($public == 1){
  414. $t = DB::table('templates')->where('is_public',$public)->where('exam_class_id',$examCla['name'])->field(['id','title as label','impression','description','parent_id'])->select();
  415. }else{
  416. // 私有模板 添加创建人条件
  417. $t = DB::table('templates')->where('is_public',$public)->where('create_user',$id)->where('exam_class_id',$examCla['name'])->field(['id','title as label','impression','description','parent_id'])->select();
  418. }
  419. if(!$t){
  420. return '';
  421. }
  422. $data = array();
  423. foreach ($t as $k => $v) {
  424. if($v['parent_id'] == '0'){
  425. $data[] = $v;
  426. }
  427. }
  428. foreach ($data as $k => $v) {
  429. unset($data[$k]['impression']);
  430. unset($data[$k]['description']);
  431. unset($data[$k]['parent_id']);
  432. }
  433. foreach ($t as $k => $v) {
  434. foreach ($data as $key => $value) {
  435. if($v['parent_id'] == $value['id']){
  436. unset($t[$k]['parent_id']);
  437. $data[$key]['children'][] = $t[$k];
  438. }
  439. }
  440. }
  441. if($data){
  442. return $data;
  443. }
  444. }
  445. /**
  446. * 确认报告
  447. *
  448. * @ApiTitle (确认报告)
  449. * @ApiSummary (确认报告)
  450. * @ApiSector (远程诊断)
  451. * @ApiMethod (POST)
  452. * @ApiRoute (/inter/writereport/confirm)
  453. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  454. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  455. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  456. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  457. * @ApiParams (name="id", type="string", sample="", description="exams表id值<必填>")
  458. * @ApiParams (name="film_type", type="string", sample="", description="胶片类型<必填>")
  459. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  460. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  461. * @ApiReturnParams (name="msg", type="string", required=true, sample="返回成功", description="返回消息")
  462. * @ApiReturn (data="
  463. {
  464. 'status': ok,
  465. 'code': '0000',
  466. 'msg': '已确认',
  467. }
  468. *")
  469. **/
  470. public function confirm(WechatService $wechatService){
  471. try{
  472. Log::record('confirm');
  473. $is_remote = $_REQUEST['is_remote'];
  474. if($is_remote == 1){
  475. return json_encode(['status'=>'fail','code'=>'1133','msg'=>'远程无法确诊报告']);
  476. }
  477. $sessionid = $_REQUEST['sessionid'];
  478. $doctor = Cache::get($sessionid);
  479. Log::record($doctor);
  480. $param = $_REQUEST['param'];
  481. Log::record($param);
  482. $id = $param['id'];
  483. $report_id = $param['report_id'];
  484. $report_info = DB::table('report')->where('id',$report_id)->find();
  485. Log::record($report_info);
  486. if($report_info['type'] == 1){
  487. //本地报告
  488. $status = DB::table('exams')->where('id',$id)->field('exam_status')->find();
  489. if($status['exam_status'] < 8 ){
  490. return json_encode(['status'=>'fail','code'=>'1033','msg'=>'只能确认通过审核的报告']);
  491. }elseif($status['exam_status'] == 9){
  492. return json_encode(['status'=>'fail','code'=>'1034','msg'=>'已经确认过该报告,不可再次确认']);
  493. }
  494. }else{
  495. //远程
  496. $status = DB::table('remote_application')->where('id',$report_info['remote_application_id'])->field('remote_doctor_id,report_status')->find();
  497. if($status['report_status'] < 8 ){
  498. return json_encode(['status'=>'fail','code'=>'1033','msg'=>'只能确认通过审核的报告']);
  499. }elseif($status['report_status'] == 9){
  500. return json_encode(['status'=>'fail','code'=>'1034','msg'=>'已经确认过该报告,不可再次确认']);
  501. }
  502. }
  503. $rinfo = array();
  504. if(isset($param['r_result']) && $param['r_result'] == 'true'){
  505. $rinfo['report_result'] = 2;
  506. }else{
  507. $rinfo['report_result'] = 1;
  508. }
  509. $rinfo['confirm_datetime'] = date('Y-m-d H:i:s',time());
  510. $rinfo['confirm_doctor_id'] = $doctor['id'];
  511. if($report_info['type'] == 1){
  512. //本地报告确认
  513. DB::table('exams')->where('id',$id)->update(['exam_status'=>'9']);
  514. }else{
  515. Message::read($doctor['id'],$report_info['remote_application_id'],4);
  516. //远程
  517. $this->confirmReport($report_info['remote_application_id'], $wechatService);
  518. // DB::table('remote_application')->where('id',$report_info['remote_application_id'])->update(['report_status'=>'9']);
  519. // 添加messages消息
  520. $t = '您的报告已确认';
  521. $institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  522. $c = '您的远程诊断报告,已被'.$institution['name'].$doctor['realname'].'医师确认';
  523. $d = $status['remote_doctor_id'];
  524. $type = '6';
  525. $url = '';
  526. Message::insert($t,$c,$d,$type,$url,1,$report_info['remote_application_id']);
  527. }
  528. DB::table('exams')->where('id',$id)->update(['film_type'=>$_REQUEST['param']['film_type']]);
  529. DB::table('report')->where('id',$report_id)->update($rinfo);
  530. $cache_key = $doctor['id'].'_'.$report_info['id'];
  531. if(Cache::get($cache_key)){
  532. Cache::rm($cache_key);
  533. }
  534. // 添加 确认log日志
  535. $info = array();
  536. $info['id'] = UUIDs::uuid16();
  537. $info['createdAt'] = date('Y-m-d H:i:s',time());
  538. $info['doctor_id'] = $doctor['id'];
  539. $info['type'] = 3;
  540. $info['report_id'] = $report_id;
  541. DB::table('report_record')->insert($info);
  542. return json_encode(['status'=>'ok','code'=>'0000','msg'=>'已确认']);
  543. }catch(\Exception $e){
  544. Log::record('confirm error ');
  545. Log::record($e);
  546. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  547. }
  548. }
  549. private function confirmReport($application_id, $wechatService) {
  550. Db::startTrans();
  551. try{
  552. DB::table('remote_application')->where('id', $application_id)->update(['report_status'=>'9']);
  553. DB::table('remote_application')->where('id',$application_id)->update(['report_status'=>'9']);
  554. $remote_order = DB::table('remote_order')
  555. ->where('status', Application::ORDER_STATUS['PAYCOMPLTET'])
  556. ->where('application_id', $application_id)
  557. ->field('order_money, id, super_hospital_id')
  558. ->find();
  559. $hospital = DB::table('institution')->where('id', $remote_order['super_hospital_id'])->field('current_money')->find();
  560. if(!$remote_order) {
  561. DB::commit();
  562. // todo 微信消息推送
  563. return true;
  564. }
  565. $brfore_money = $hospital['current_money'];
  566. $order_money = $remote_order['order_money'];
  567. $after_money = $brfore_money + $order_money;
  568. DB::table('institution')->where('id', $remote_order['super_hospital_id'])->update(['current_money' => $after_money]);
  569. DB::table('remote_order')->where('id', $remote_order['id'])->update(['status' => Application::ORDER_STATUS['CONFIRM']]);
  570. $hospital_id = $remote_order['super_hospital_id'];
  571. $order_id = $remote_order['id'];
  572. $type = Application::WATER_TYPE['ADD'];
  573. $why = Application::WATER_WHY['REMOTEINCOME'];
  574. $water_id = DB::table('remote_water')->insertGetId([
  575. 'hospital_id' => $hospital_id,
  576. 'order_id' => $order_id,
  577. 'money' => $order_money,
  578. 'type' => $type,
  579. 'why' => $why,
  580. 'timestamp' => time(),
  581. ]);
  582. DB::table('remote_water_log')->insert([
  583. 'hospital_id' => $hospital_id,
  584. 'order_id' => $order_id,
  585. 'water_id' => $water_id,
  586. 'order_money' => $order_money,
  587. 'brfore_money' => $brfore_money,
  588. 'after_money' => $after_money,
  589. 'type' => $type,
  590. 'why' => $why,
  591. 'timestamp' => time(),
  592. ]);
  593. // 提交事务
  594. Db::commit();
  595. $wechatService->pushWechatComplete($order_id);
  596. // todo 消息推送
  597. return true;
  598. } catch (\Exception $e) {
  599. // 回滚事务
  600. Db::rollback();
  601. Log::record("-----错误-----");
  602. Log::record('xxxxxxxxx');
  603. var_dump($e->getMessage());
  604. }
  605. return json_encode(['status'=>'fail','code'=>'2110','确认报告失败']);
  606. }
  607. /**
  608. * 审核报告
  609. *
  610. * @ApiTitle (审核报告)
  611. * @ApiSummary (审核报告)
  612. * @ApiSector (远程诊断)
  613. * @ApiMethod (POST)
  614. * @ApiRoute (/inter/writereport/examine)
  615. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  616. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  617. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  618. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  619. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  620. * @ApiParams (name="is_remote", type="string", required=true, description="是否为远程列表进入")
  621. * @ApiParams (name="id", type="string", sample="", description="exams表id值<必填>")
  622. * @ApiParams (name="param[impression]", type="string", sample="", description="检查所见<必填>")
  623. * @ApiParams (name="param[description]", type="string", sample="", description="意见建议<必填>")
  624. * @ApiParams (name="param[r_result]", type="string", sample="", description="检查结果<必填>")
  625. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  626. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  627. * @ApiReturnParams (name="msg", type="string", required=true, sample="返回成功", description="返回消息")
  628. * @ApiReturn (data="
  629. {
  630. 'status': ok,
  631. 'code': '0000',
  632. 'msg': '已审核',
  633. }
  634. *")
  635. **/
  636. public function examine(){
  637. try{
  638. $id = $_REQUEST['id'];
  639. $param = $_REQUEST['param'];
  640. $report_id = $param['report_id'];
  641. $report = DB::table('report')->where('id',$report_id)->find();
  642. $sessionid = $_REQUEST['sessionid'];
  643. $doctor = Cache::get($sessionid);
  644. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  645. // 是远程审核报告 8
  646. $return = Verify::check_role($sessionid,8);
  647. $status = DB::table('remote_application')->where('id',$report['remote_application_id'])->field('req_doctor_id,report_status')->find();
  648. if($status['report_status'] < 7){
  649. return json_encode(['status'=>'fail','code'=>'1032','msg'=>'只能审核已提交的报告']);
  650. }elseif($status['report_status']>8){
  651. return json_encode(['status'=>'fail','code'=>'1035','msg'=>'报告已被下级医院所确认,无法进行审核']);
  652. }elseif($status['report_status'] == 8){
  653. if($report['review_doctor_id'] != $doctor['id']){
  654. return json_encode(['status'=>'fail','code'=>'1039','msg'=>'审核人不一致']);
  655. }
  656. }
  657. DB::table('remote_application')->where('id',$report['remote_application_id'])->update(['report_status'=>'8']);
  658. }else{
  659. // 本地审核权限 3
  660. $return = Verify::check_role($sessionid,3);
  661. $status = DB::table('exams')->where('id',$id)->field('exam_status')->find();
  662. if($status['exam_status'] < 7){
  663. return json_encode(['status'=>'fail','code'=>'1032','msg'=>'只能审核已提交的报告']);
  664. }elseif($status['exam_status']>7){
  665. return json_encode(['status'=>'fail','code'=>'1035','msg'=>'报告已通过审核步骤,请勿重复操作']);
  666. }
  667. DB::table('exams')->where('id',$id)->update(['exam_status'=>'8']);
  668. }
  669. $report_info = array();
  670. $report_info['impression'] = isset($param['impression']) ? $param['impression'] : '';
  671. $report_info['description'] = isset($param['description']) ? $param['description'] : '';
  672. if(isset($param['r_result']) && $param['r_result'] == 'true'){
  673. $report_info['report_result'] = 2;
  674. }else{
  675. $report_info['report_result'] = 1;
  676. }
  677. $report_info['review_datetime'] = date('Y-m-d H:i:s',time());
  678. $report_info['review_doctor_id'] = $doctor['id'];
  679. DB::table('report')->where('id',$report['id'])->update($report_info);
  680. $cache_key = $doctor['id'].'_'.$report['id'];
  681. if(Cache::get($cache_key)){
  682. Cache::rm($cache_key);
  683. }
  684. $info = array();
  685. $info['id'] = UUIDs::uuid16();
  686. $info['type'] = 2; //审核
  687. $info['createdAt'] = date('Y-m-d H:i:s',time());
  688. $info['doctor_id'] = $doctor['id'];
  689. $info['impression'] = isset($param['impression']) ? $param['impression'] : '';
  690. $info['description'] = isset($param['description']) ? $param['description'] : '';
  691. $info['report_id'] = $report['id'];
  692. DB::table('report_record')->insert($info);
  693. DB::table('exams')->where('id',$id)->update(['film_type'=>$param['film_type']]);
  694. // 已审核 发送短信
  695. $application = DB::table('remote_application')->where('exam_id',$id)->find();
  696. $dinfo = DB::table('doctors')->where('id',$application['req_doctor_id'])->find();
  697. $d_phone = $dinfo['phone'];
  698. log::record('发短信的手机号为'.$d_phone);
  699. $d_name = $doctor['realname'];
  700. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  701. if($dinfo['institution_id'] == '22100002' || $dinfo['send_sms'] == 1){ //魏庙下级
  702. $repsone = send_message::sendSms2CompleteReport($d_phone,$d_name);
  703. }
  704. $tel = '18910184804';
  705. $type = '完成并审核报告';
  706. $content =$application['id'];
  707. // send_message::sendSms2Self($tel,$type,$content);
  708. }
  709. // 添加messages消息
  710. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  711. Message::read($doctor['id'],$report['remote_application_id'],3);
  712. $t = '您的远程诊断申请已完成';
  713. $institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  714. $c = '您的远程诊断申请,已由被'.$institution['name'].$doctor['realname'].'医师完成报告';
  715. $d = $status['req_doctor_id'];
  716. $type = '5';
  717. $exam_class = DB::table('exams')->where('id',$id)->field('exam_class')->find();
  718. $url = Message::url($sessionid,$id,0,$exam_class['exam_class'],$report_id,$report['remote_application_id']);
  719. Message::insert($t,$c,$d,$type,$url,1,$report['remote_application_id']);
  720. }
  721. $url = 'http://wechat.pacsonline.cn/wx_patient/api/unifyGetWxQrcode?reportId='.$report_id;
  722. $info = $this->curl_get($url);
  723. return json_encode(['status'=>'ok','code'=>'0000','msg'=>'已审核']);
  724. }catch(\Exception $e){
  725. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  726. }
  727. }
  728. public function curl_get($url){
  729. //初始化
  730. $curl = curl_init();
  731. //设置抓取的url
  732. curl_setopt($curl, CURLOPT_URL, $url);
  733. //设置头文件的信息作为数据流输出
  734. curl_setopt($curl, CURLOPT_HEADER, 0);
  735. //设置获取的信息以文件流的形式返回,而不是直接输出。
  736. curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
  737. // 重定向
  738. curl_setopt($curl, CURLOPT_FOLLOWLOCATION, 1);
  739. //执行命令
  740. $data = curl_exec($curl);
  741. //关闭URL请求
  742. curl_close($curl);
  743. return $data;
  744. }
  745. /**
  746. * 获取报告权限
  747. *
  748. * @ApiTitle (获取报告权限)
  749. * @ApiSummary (获取报告权限)
  750. * @ApiSector (远程诊断)
  751. * @ApiMethod (POST)
  752. * @ApiRoute (/inter/writereport/getrole)
  753. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  754. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  755. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  756. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  757. * @ApiParams (name="is_remote", type="string", required=true, description="是否为远程列表进入")
  758. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  759. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  760. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  761. * @ApiReturn (data="
  762. {
  763. 'status': ok,
  764. 'code': '0000',
  765. 'info': '',
  766. }
  767. *")
  768. **/
  769. public function getrole(){
  770. try{
  771. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  772. $is_remote = $_REQUEST['is_remote'];
  773. }
  774. $sessionid = $_REQUEST['sessionid'];
  775. $doctor = Cache::get($sessionid);
  776. $dclass = DB::table('doctor_class')->where('doctor_id',$doctor['id'])->field('doctor_class')->find();
  777. $doctor_class = explode(',',$dclass['doctor_class']);
  778. $info = array();
  779. foreach ($doctor_class as $k=>$v) {
  780. switch($v){
  781. case 2: //报告医生
  782. if(isset($is_remote)){
  783. //远程报告
  784. break;
  785. }
  786. $info['bg'] = 1;
  787. break;
  788. case 7: //远程报告医生
  789. if(!isset($is_remote)){
  790. //远程报告
  791. break;
  792. }
  793. $info['bg'] = 1;
  794. break;
  795. case 3: //3审核医生
  796. if(isset($is_remote)){
  797. //远程报告
  798. break;
  799. }
  800. $info['sh'] = 2;
  801. break;
  802. case 8: //远程审核医生
  803. if(!isset($is_remote)){
  804. //远程报告
  805. break;
  806. }
  807. $info['sh'] = 2;
  808. break;
  809. case 4: //确认医生
  810. $info['qr'] = 3;
  811. break;
  812. }
  813. }
  814. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info]);
  815. }catch(\Exception $e){
  816. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  817. }
  818. }
  819. /**
  820. * 获取报告日志
  821. *
  822. * @ApiTitle (获取报告日志)
  823. * @ApiSummary (获取报告日志)
  824. * @ApiSector (远程诊断)
  825. * @ApiMethod (POST)
  826. * @ApiRoute (/inter/writereport/get_report_log)
  827. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  828. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  829. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  830. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  831. * @ApiParams (name="id", type="string", required=true, description="exams表id值")
  832. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  833. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  834. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  835. * @ApiReturn (data="
  836. {
  837. 'status': ok,
  838. 'code': '0000',
  839. 'info': '',
  840. }
  841. *")
  842. **/
  843. public function get_report_log(){
  844. try{
  845. $sessionid = $_REQUEST['sessionid'];
  846. $doctor = Cache::get($sessionid);
  847. $id = $_REQUEST['id'];
  848. $exam_id = $_REQUEST['exam_id'];
  849. if(isset($_REQUEST['is_remote']) && !empty($_REQUEST['is_remote'])){
  850. // 远程
  851. $report = DB::table('report')->where('id',$id)->find();
  852. }else{
  853. // 本地
  854. $report = DB::table('report')->where('exam_id',$exam_id)->where('type',1)->find();
  855. }
  856. if(empty($report)){
  857. return json_encode(['status'=>'ok','code'=>'0000','info'=>'','msg'=>'无数据']);
  858. }
  859. $log = DB::table('report_record')->where('doctor_id',$doctor['id'])->where('report_id',$report['id'])->order('createdAt asc,type asc')->select();
  860. foreach ($log as $k => $v) {
  861. $doc = DB::table('doctors')->where('id',$v['doctor_id'])->field('realname')->find();
  862. $log[$k]['doctor_name'] = $doc['realname'];
  863. }
  864. return json_encode(['status'=>'ok','code'=>'0000','info'=>$log]);
  865. }catch(\Exception $e){
  866. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  867. }
  868. }
  869. /**
  870. * 打印报告
  871. *
  872. * @ApiTitle (打印报告)
  873. * @ApiSummary (打印报告)
  874. * @ApiSector (远程诊断)
  875. * @ApiMethod (POST)
  876. * @ApiRoute (/inter/writereport/print_report)
  877. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  878. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  879. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  880. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  881. * @ApiParams (name="id", type="string", required=true, description="exams表id值")
  882. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  883. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  884. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  885. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  886. * @ApiReturn (data="
  887. {
  888. 'status': ok,
  889. 'code': '0000',
  890. 'sessionid': 'a17z7a7a8f9g9rh9d89jio',
  891. 'info': '',
  892. }
  893. *")
  894. **/
  895. public function print_report(){
  896. try{
  897. $sessionid = $_REQUEST['sessionid'];
  898. $doctor = Cache::get($sessionid);
  899. $id = $_REQUEST['id'];
  900. $is_remote = $_REQUEST['is_remote'];
  901. $report_id = $_REQUEST['report_id'];
  902. $report = DB::table('report')->where('id',$report_id)->field('qr_code,remote_application_id,report_datetime,impression,description,report_doctor_id,review_doctor_id')->find();
  903. $info = array();
  904. // 检查日期 住院号 床号 本地申请科室 本地申请医生
  905. $exam_info = DB::table('exams')->where('id',$id)->field('id,ext,accession_num,exam_datetime,exam_class,hopitalized_no,bed_no,exam_project,patient_id,application_department,application_doctor,patient_area')->find();
  906. $info['id'] = $exam_info['id'];
  907. $info['ext'] = $exam_info['ext'];
  908. $info['patient_area'] = $exam_info['patient_area'];
  909. $info['accession_num'] = $exam_info['accession_num'];
  910. if(!empty($exam_info['exam_datetime'])){
  911. $datetime = explode(' ',$exam_info['exam_datetime']);
  912. $info['exam_datetime'] = $datetime[0];
  913. }else{
  914. $info['exam_datetime'] = '';
  915. }
  916. $info['hopitalized_no'] = $exam_info['hopitalized_no'];
  917. $info['bed_no'] = $exam_info['bed_no'];
  918. // 检查项目
  919. $project = DB::table('exam_project')->where('id',$exam_info['exam_project'])->field('name')->find();
  920. $info['project'] = $project['name'];
  921. //检查类
  922. $exam_class = DB::table('constant')->where('id',$exam_info['exam_class'])->field('constant_value')->find();
  923. $info['exam_class'] = $exam_class['constant_value'];
  924. // 病历号 姓名 年龄 性别
  925. $patient_info = DB::table('patient_infos')->where('id',$exam_info['patient_id'])->field('temp_patient_id,name,sex,age')->find();
  926. $remote = DB::table('remote_application')->where('id',$report['remote_application_id'])->field('req_doctor_id')->find();
  927. $info['pnumber'] = $patient_info['temp_patient_id'];
  928. $info['name'] = $patient_info['name'];
  929. $info['sex'] = $patient_info['sex'];
  930. $info['age'] = $patient_info['age'];
  931. // 申请医生
  932. $application_name = DB::table('doctors')->where('id',$remote['req_doctor_id'])->field('realname,department_id,autograph,is_use_autograph')->find();
  933. if($is_remote == 1){
  934. $info['application_name'] = $application_name['realname'];
  935. // 申请科室
  936. $department = DB::table('department')->where('id',$application_name['department_id'])->field('department_name')->find();
  937. $info['department_name'] = $department['department_name'];
  938. }else{
  939. $info['application_name'] = $exam_info['application_doctor'];
  940. $info['application_department'] = $exam_info['application_department'];
  941. }
  942. $info['application_use_autograph'] = $application_name['is_use_autograph'];
  943. $info['application_autograph'] = $application_name['autograph'];
  944. // 报告时间 影像所见 意见建议
  945. if(!empty($report['report_datetime'])){
  946. $datetime1 = explode(' ',$report['report_datetime']);
  947. $info['report_datetime'] = $datetime1[0];
  948. }else{
  949. $info['report_datetime'] = '';
  950. }
  951. $info['report_datetime_xa'] = $report['report_datetime'];
  952. $info['impression'] = $report['impression'];
  953. $info['description'] = $report['description'];
  954. $info['qr_code'] = $report['qr_code'];
  955. // 报告医生
  956. $report_doctor = DB::table('doctors')->where('id',$report['report_doctor_id'])->field('realname,autograph,is_use_autograph,institution_id')->find();
  957. $info['report_doctor'] = $report_doctor['realname'];
  958. $info['report_use_autograph'] = $report_doctor['is_use_autograph'];
  959. $info['report_autograph'] = $report_doctor['autograph'];
  960. //审核医生
  961. $review_doctor = DB::table('doctors')->where('id',$report['review_doctor_id'])->field('realname,autograph,is_use_autograph')->find();
  962. $info['review_doctor'] = $review_doctor['realname'];
  963. $info['review_use_autograph'] = $review_doctor['is_use_autograph'];
  964. $info['review_autograph'] = $review_doctor['autograph'];
  965. // $hospital = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  966. $hospital = DB::table('institution')->where('id',$report_doctor['institution_id'])->field('name')->find();
  967. $info['hospital'] = $hospital['name'];
  968. if(empty($report['qr_code'])){
  969. $url = 'http://wechat.pacsonline.cn/wx_patient/api/unifyGetWxQrcode?reportId='.$report_id;
  970. $code = $this->curl_get($url);
  971. $qr_code = DB::table('report')->where('id',$report_id)->value('qr_code');
  972. $info['qr_code'] = $qr_code;
  973. }
  974. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid]);
  975. }catch(\Exception $e){
  976. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  977. }
  978. }
  979. /**
  980. * 变更胶片
  981. *
  982. * @ApiTitle (变更胶片)
  983. * @ApiSummary (变更胶片)
  984. * @ApiSector (远程诊断)
  985. * @ApiMethod (POST)
  986. * @ApiRoute (/inter/writereport/change_film)
  987. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  988. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  989. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  990. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  991. * @ApiParams (name="id", type="string", required=true, description="exams表id值")
  992. * @ApiParams (name="film_type", type="string", required=true, description="胶片")
  993. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  994. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  995. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  996. * @ApiReturn (data="z
  997. {
  998. 'status': ok,
  999. 'code': '0000',
  1000. 'info': '',
  1001. }
  1002. *")
  1003. **/
  1004. public function change_film(){
  1005. $id = $_REQUEST['id'];
  1006. $film = $_REQUEST['film_type'];
  1007. DB::table('exams')->where('id',$id)->update(['film_type'=>$film]);
  1008. return json_encode(['status'=>'ok','info'=>$film,'code'=>'0000']);
  1009. }
  1010. /**
  1011. * 保存草稿
  1012. *
  1013. * @ApiTitle (保存草稿)
  1014. * @ApiSummary (保存草稿)
  1015. * @ApiSector (远程诊断)
  1016. * @ApiMethod (POST)
  1017. * @ApiRoute (/inter/writereport/draft)
  1018. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  1019. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  1020. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  1021. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  1022. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  1023. * @ApiParams (name="param[report_id]", type="string", sample="", description="报告表id值<必填>")
  1024. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  1025. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  1026. * @ApiReturnParams (name="msg", type="string", required=true, sample="返回成功", description="返回消息")
  1027. * @ApiReturn (data="
  1028. {
  1029. 'status': ok,
  1030. 'code': '0000',
  1031. 'msg': '保存成功',
  1032. }
  1033. *")
  1034. **/
  1035. public function draft(){
  1036. $sessionid = $_REQUEST['sessionid'];
  1037. $doctor = Cache::get($sessionid);
  1038. $param = $_REQUEST['param'];
  1039. $report_id = $param['report_id'];
  1040. $rinfo = DB::table('report')->where('id',$report_id)->find();
  1041. if($rinfo['type'] == 2){
  1042. //远程报告
  1043. $status = DB::table('remote_application')->where('id',$rinfo['remote_application_id'])->find();
  1044. if($status['report_status'] ==6 || $status['report_status'] ==7){
  1045. $key = $doctor['id'].'_'.$report_id;
  1046. Cache::set($key,$param);
  1047. return json_encode(['status'=>'ok','msg'=>'保存成功','code'=>'0000']);
  1048. }else{
  1049. return json_encode(['status'=>'fail','msg'=>'只能为未保存或者未审核的报告填写草稿','code'=>'0110']);
  1050. }
  1051. }else {
  1052. //本地报告
  1053. $status = DB::table('exams')->where('id', $rinfo['exam_id'])->find();
  1054. if ($status['exam_status'] == 7 || $status['exam_status'] == 3) {
  1055. $key = $doctor['id'] . '_' . $report_id;
  1056. Cache::set($key, $param);
  1057. return json_encode(['status' => 'ok', 'msg' => '保存成功', 'code' => '0000']);
  1058. } else {
  1059. return json_encode(['status' => 'fail', 'msg' => '只能为未保存或者未审核的报告填写草稿', 'code' => '0110']);
  1060. }
  1061. }
  1062. }
  1063. /**
  1064. * XA类型数据获取
  1065. *
  1066. * @ApiTitle (XA类型数据获取)
  1067. * @ApiSummary (XA类型数据获取)
  1068. * @ApiSector (远程诊断)
  1069. * @ApiMethod (POST)
  1070. * @ApiRoute (/inter/writereport/get_rinfo)
  1071. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  1072. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  1073. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  1074. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  1075. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  1076. * @ApiParams (name="report_id", type="string", required=true, description="报告表id<必填>")
  1077. * @ApiParams (name="id", type="string", sample="", description="exams表id值<必填>")
  1078. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  1079. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  1080. * @ApiReturnParams (name="msg", type="string", required=true, sample="返回成功", description="返回消息")
  1081. * @ApiReturn (data="
  1082. {
  1083. 'status': ok,
  1084. 'code': '0000',
  1085. 'msg': '已审核',
  1086. }
  1087. *")
  1088. **/
  1089. public function get_rinfo(){
  1090. $sessionid = $_REQUEST['sessionid'];
  1091. $doctor = Cache::get($sessionid);
  1092. $id = $_REQUEST['id'];
  1093. $report_id = $_REQUEST['report_id'];
  1094. $key = $doctor['id'].'_'.$report_id;
  1095. if(Cache::get($key)){
  1096. $patient = Cache::get($key);
  1097. }else{
  1098. $exam = DB::table('exams')->where('id',$id)->field('accession_num,exam_class,patient_id,ext,hopitalized_no,bed_no')->find();
  1099. $patient = DB::table('patient_infos')->where('id',$exam['patient_id'])->field(['id','temp_patient_id','name','phone','sex','age'])->find();
  1100. $report_info = DB::table('report')->where('id',$report_id)->field('description')->find();
  1101. $patient['ext'] = $exam['ext'];
  1102. $patient['exam_id'] = $id;
  1103. $patient['bed_no'] = $exam['bed_no'];
  1104. $patient['accession_num'] = $exam['accession_num'];
  1105. $patient['exam_class'] = $exam['exam_class'];
  1106. $patient['hopitalized_no'] = $exam['hopitalized_no'];
  1107. $patient['description'] = $report_info['description'];
  1108. $patient['report_id'] = $report_id;
  1109. }
  1110. return json_encode(['status'=>'ok','info'=>$patient,'code'=>'0000']);
  1111. }
  1112. /**
  1113. * XA类型保存
  1114. *
  1115. * @ApiTitle (XA类型保存)
  1116. * @ApiSummary (XA类型保存)
  1117. * @ApiSector (远程诊断)
  1118. * @ApiMethod (POST)
  1119. * @ApiRoute (/inter/writereport/write_info)
  1120. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  1121. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  1122. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  1123. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  1124. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  1125. * @ApiParams (name="is_remote", type="string", required=true, description="是否为远程列表进入")
  1126. * @ApiParams (name="param[id]", type="string", sample="", description="exams表id值<必填>")
  1127. * @ApiParams (name="param[name]", type="string", sample="", description="姓名<必填>")
  1128. * @ApiParams (name="param[sex]", type="string", sample="", description="性别<必填>")
  1129. * @ApiParams (name="param[age]", type="string", sample="", description="年龄<必填>")
  1130. * @ApiParams (name="param[hospital_number]", type="string", sample="", description="住院号<必填>")
  1131. * @ApiParams (name="param[bed_number]", type="string", sample="", description="病床号<必填>")
  1132. * @ApiParams (name="param[ext]", type="string", sample="", description="其他<必填>")
  1133. * @ApiParams (name="param[description]", type="string", sample="", description="意见建议<必填>")
  1134. * @ApiParams (name="param[accession_num]", type="string", sample="", description="检查号<必填>")
  1135. * @ApiParams (name="param[pid]", type="string", sample="", description="患者id<必填>")
  1136. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  1137. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  1138. * @ApiReturnParams (name="msg", type="string", required=true, sample="返回成功", description="返回消息")
  1139. * @ApiReturn (data="
  1140. {
  1141. 'status': ok,
  1142. 'code': '0000',
  1143. 'msg': '保存成功',
  1144. }
  1145. *")
  1146. **/
  1147. public function write_info(){
  1148. $sessionid = $_REQUEST['sessionid'];
  1149. /*if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  1150. // 是远程写报告 7
  1151. $return = Verify::check_role($sessionid,7);
  1152. }else{
  1153. // 本地写报告权限 2
  1154. $return = Verify::check_role($sessionid,2);
  1155. }
  1156. if($return != 1){
  1157. return json_encode(['status'=>'fail','code'=>'1029','msg'=>'没有操作权限']);
  1158. }
  1159. $param = $_REQUEST['param'];
  1160. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  1161. //远程
  1162. $status = DB::table('remote_application')->where('id',$param['rid'])->field('report_status')->find();
  1163. if($status['report_status'] == 12){
  1164. return json_encode(['status'=>'fail','code'=>'1034','msg'=>'报告已被撤回,无法进行保存填写']);
  1165. }elseif($status['report_status'] > 6){
  1166. return json_encode(['status'=>'fail','code'=>'1034','msg'=>'报告已被保存,无法再次被修改']);
  1167. }
  1168. }else{
  1169. //本地
  1170. $status = DB::table('exams')->where('id',$param['id'])->field('exam_status')->find();
  1171. if($status['exam_status'] > 6){
  1172. return json_encode(['status'=>'fail','code'=>'1034','msg'=>'报告已被保存,无法再次被修改']);
  1173. }
  1174. }*/
  1175. $doctor = Cache::get($sessionid);
  1176. $is_remote = $_REQUEST['is_remote'];
  1177. $param = $_REQUEST['param'];
  1178. $patient_info['name'] = isset($param['name']) ? $param['name'] : '';
  1179. $patient_info['sex'] = isset($param['sex']) ? $param['sex'] : '';
  1180. $patient_info['age'] = isset($param['age']) ? $param['age'] : '';
  1181. $exam_info['hopitalized_no'] = isset($param['hospital_number']) ? $param['hospital_number'] : '';
  1182. $exam_info['bed_no'] = isset($param['bed_number']) ? $param['bed_number'] : '';
  1183. $exam_info['ext'] = isset($param['ext']) ? $param['ext'] : '';
  1184. $exam_info['accession_num'] = isset($param['accession_num']) ? $param['accession_num'] : '';
  1185. $report['description'] = isset($param['description']) ? $param['description'] : '';
  1186. $report['report_datetime'] = date('Y-m-d H:i:s',time());
  1187. $report['report_doctor_id'] = $doctor['id'];
  1188. DB::table('patient_infos')->where('id',$param['pid'])->update($patient_info);
  1189. DB::table('exams')->where('id',$param['id'])->update($exam_info);
  1190. $rinfo = DB::table('report')->where('exam_id',$param['id'])->find();
  1191. if($rinfo){
  1192. DB::table('report')->where('exam_id',$param['id'])->update($report);
  1193. $rinfo = DB::table('report')->where('exam_id',$param['id'])->find();
  1194. $rid = $rinfo['id'];
  1195. }else{
  1196. $report['id'] = UUIDs::uuid16();
  1197. $report['exam_id'] = $param['id'];
  1198. $report['createdAt'] = date('Y-m-d H:i:s',time());
  1199. DB::table('report')->insert($report);
  1200. $rid = $report['id'];
  1201. }
  1202. $log = array();
  1203. $log['id'] = UUIDs::uuid16();
  1204. $log['impression'] = isset($param['ext']) ? $param['ext'] : '';
  1205. $log['description'] = isset($param['description']) ? $param['description'] : '';
  1206. $log['report_id'] = $rid;
  1207. $log['createdAt'] = date('Y-m-d H:i:s',time());
  1208. $log['doctor_id'] = $doctor['id'];
  1209. $log['type'] = 1; //写报告
  1210. log::record($log);
  1211. $report_log = DB::table('report_record')->insert($log);
  1212. $application = DB::table('remote_application')->where('exam_id',$param['id'])->find();
  1213. if($application['req_doctor_id'] == 'c44663d6d3c0b535'){
  1214. $tel = '18910184804';
  1215. $type = '保存报告';
  1216. $content = $application['id'];
  1217. // send_message::sendSms2Self($tel,$type,$content);
  1218. }
  1219. if($is_remote == 1){
  1220. DB::table('remote_application')->where('exam_id',$param['id'])->update(['report_status'=>7]);
  1221. }else{
  1222. DB::table('exams')->where('id',$param['id'])->update(['exam_status'=>7]);
  1223. }
  1224. $url = 'http://wechat.pacsonline.cn/wx_patient/api/unifyGetWxQrcode?reportId='.$rid;
  1225. $info = $this->curl_get($url);
  1226. return json_encode(['status'=>'ok','msg'=>'保存成功','code'=>'0000']);
  1227. }
  1228. /**
  1229. * 获取远程报告列表
  1230. *
  1231. * @ApiTitle (获取远程报告列表)
  1232. * @ApiSummary (获取远程报告列表)
  1233. * @ApiSector (远程诊断)
  1234. * @ApiMethod (POST)
  1235. * @ApiRoute (/inter/writereport/get_report_list)
  1236. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  1237. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  1238. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  1239. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  1240. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  1241. * @ApiParams (name="is_remote", type="string", required=true, description="是否为远程列表进入")
  1242. * @ApiParams (name="param[id]", type="string", sample="", description="exams表id值<必填>")
  1243. * @ApiParams (name="param[pid]", type="string", sample="", description="病历号<必填>")
  1244. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  1245. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  1246. * @ApiReturnParams (name="msg", type="string", required=true, sample="返回成功", description="返回消息")
  1247. * @ApiReturn (data="
  1248. {
  1249. 'status': ok,
  1250. 'code': '0000',
  1251. 'info': '',
  1252. }
  1253. *")
  1254. **/
  1255. public function get_report_list(){
  1256. $sessionid = $_REQUEST['sessionid'];
  1257. $doctor = Cache::get($sessionid);
  1258. $param = $_REQUEST['param'];
  1259. $rinfo = DB::table('report')->where('exam_id',$param['id'])->where('type','<>',1)->select();
  1260. $einfo = DB::table('exams')->where('id',$param['id'])->field('exam_class,exam_sub_class,exam_datetime,patient_id')->find();
  1261. $pinfo = DB::table('patient_infos')->where('id',$einfo['patient_id'])->field('name,temp_patient_id,sex,age,phone')->find();
  1262. $info = array();
  1263. $arr = array();
  1264. foreach ($rinfo as $k => $v) {
  1265. $remote_info = DB::table('remote_application')->where('id',$v['remote_application_id'])->find();
  1266. Message::read($doctor['id'],$remote_info['id'],4);
  1267. if($remote_info['report_status'] == 8 || $remote_info['report_status'] == 9){
  1268. $arr = $v;
  1269. $remote_did = DB::table('doctors')->where('id',$v['report_doctor_id'])->field('realname')->find();
  1270. $arr['report_doctor'] = $remote_did['realname'];
  1271. $review_did = DB::table('doctors')->where('id',$v['review_doctor_id'])->field('realname')->find();
  1272. $arr['review_doctor'] = $review_did['realname'];
  1273. $arr['name'] = $pinfo['name'];
  1274. $arr['pid'] = $pinfo['temp_patient_id'];
  1275. $arr['sex'] = $pinfo['sex'];
  1276. $arr['age'] = $pinfo['age'];
  1277. $arr['phone'] = $pinfo['phone'];
  1278. $arr['exam_class'] = $einfo['exam_class'];
  1279. $arr['exam_sub_class'] = $einfo['exam_sub_class'];
  1280. $arr['exam_datetime'] = $einfo['exam_datetime'];
  1281. $arr['report_status'] = $remote_info['report_status'];
  1282. $arr['hospital_name'] = DB::table('institution')->where('id',$remote_info['remote_institution_id'])->value('name');
  1283. $info = $arr;
  1284. }elseif($remote_info['report_status'] == 4){
  1285. //申请中
  1286. return json_encode(['status'=>'fail','code'=>'0125','msg'=>'申请单正在申请中,暂无医生接收远程报告']);
  1287. }elseif($remote_info['report_status'] == 5){
  1288. // 驳回
  1289. return json_encode(['status'=>'fail','code'=>'0125','msg'=>'申请单已被驳回,没有医生完成远程报告']);
  1290. }elseif($remote_info['report_status'] == 12){
  1291. // 撤回
  1292. return json_encode(['status'=>'fail','code'=>'0125','msg'=>'申请单正在申请中,暂无医生完成远程报告']);
  1293. }elseif($remote_info['report_status'] == ''){
  1294. // 撤回
  1295. return json_encode(['status'=>'fail','code'=>'0126','msg'=>'没有申请单']);
  1296. }else{
  1297. // 其他
  1298. return json_encode(['status'=>'fail','code'=>'0125','msg'=>'申请单还没有被完成,请等待']);
  1299. }
  1300. }
  1301. return json_encode(['status'=>'ok','info'=>$info,'code'=>'0000']);
  1302. }
  1303. public function reject_examine()
  1304. {
  1305. $sessionid = $_REQUEST['sessionid'];
  1306. //传值报告id
  1307. $report_id = $_REQUEST['report_id'];
  1308. $reason = $_REQUEST['reason'];
  1309. $is_remote = $_REQUEST['is_remote'];
  1310. $report = DB::table('report')->where('id',$report_id)->field('remote_application_id,exam_id,report_doctor_id')->find();
  1311. $exam = DB::table('exams')->where('id',$report['exam_id'])->value('exam_class');
  1312. if($is_remote == 1){
  1313. //远程
  1314. DB::table('remote_application')->where('id',$report['remote_application_id'])->update(['report_status'=>13]);
  1315. }else{
  1316. // 本地
  1317. DB::table('exams')->where('id',$report['exam_id'])->update(['exam_status'=>13]);
  1318. }
  1319. $url = Message::url($sessionid,$report['exam_id'],0,$exam,$report_id,$report['remote_application_id']);
  1320. $t = '您的报告在审核步骤已被驳回';
  1321. $c = '您保存的报告在审核步骤已被驳回,驳回的原因是:'.$reason.',请您重新更改您的报告';
  1322. $d = $report['report_doctor_id'];
  1323. $type = '8';
  1324. Message::insert($t,$c,$d,$type,$url,1,$report['remote_application_id']);
  1325. return json_encode(['status'=>'ok','msg'=>'审核已驳回','code'=>'0000']);
  1326. }
  1327. }