Writereport.php 48 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880
  1. <?php
  2. namespace app\inter\controller;
  3. //use Doctrine\Common\Cache\Cache;
  4. use think\Controller;
  5. use think\Db;
  6. use think\Session;
  7. use app\common\library\UUIDs;
  8. use think\Cache;
  9. use think\Log;
  10. use app\common\library\Verify;
  11. use app\common\library\send_message;
  12. class Writereport extends Base
  13. {
  14. /**
  15. * 写报告页面
  16. *
  17. * @ApiTitle (写报告页面)
  18. * @ApiSummary (写报告页面)
  19. * @ApiSector (远程诊断)
  20. * @ApiMethod (POST)
  21. * @ApiRoute (/inter/writereport/index)
  22. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  23. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  24. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  25. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  26. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  27. * @ApiParams (name="is_remote", type="string", required=true, description="是否为远程列表进入")
  28. * @ApiParams (name="param[id]", type="string", sample="", description="exams表id值<必填>")
  29. * @ApiParams (name="param[images]", type="string", sample="", description="影像图片<选填>")
  30. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  31. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  32. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  33. * @ApiReturnParams (name="is_remote", type="object", sample="{}", description="是否为远程诊断进入")
  34. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  35. * @ApiReturn (data="
  36. {
  37. 'status': ok,
  38. 'code': '0000',
  39. 'sessionid': 'a17z7a7a8f9g9rh9d89jio',
  40. 'is_remote': 1,
  41. 'info' : ''
  42. }
  43. *")
  44. **/
  45. public function index(){
  46. try{
  47. log::record('-----请求值-----');
  48. log::record($_REQUEST);
  49. log::record('-----请求值-----');
  50. $sessionid = $_REQUEST['sessionid'];
  51. if(isset($_REQUEST['is_remote']) && !empty($_REQUEST['is_remote'])){
  52. $is_remote = $_REQUEST['is_remote'];
  53. }else{
  54. $is_remote = 0;
  55. }
  56. $doctor = Cache::get($sessionid);
  57. $institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name,report_subtitle')->find();
  58. $param = $_REQUEST['param'];
  59. $id = $param['id'];
  60. $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'])->find();
  61. $exam_class = DB::table('constant')->where('id',$info['exam_class'])->field('constant_value')->find();
  62. $info['exam_class'] = $exam_class['constant_value'];
  63. $exam_subclass = DB::table('exam_subclass')->where('id',$info['exam_sub_class'])->field('name')->find();
  64. $info['exam_sub_class'] = $exam_subclass['name'];
  65. $patient_info = DB::table('patient_infos')->where('id',$info['patient_id'])->field(['id','temp_patient_id','name','phone','sex','age'])->find();
  66. $info['pid'] = $patient_info['temp_patient_id'];
  67. $info['name'] = $patient_info['name'];
  68. $info['sex'] = $patient_info['sex'];
  69. $info['age'] = $patient_info['age'];
  70. $info['phone'] = $patient_info['phone'];
  71. $info['hospital_name'] = $institution['name'];
  72. $info['hospital_title'] = $institution['report_subtitle'];
  73. $info['images'] = isset($param['images']) ? $param['images'] : '';
  74. $report = DB::table('report')->where('exam_id',$id)->field('report_result,report_datetime,report_doctor_id,review_datetime,review_doctor_id,impression,description')->find();
  75. $report_doctor = DB::table('doctors')->where('id',$report['report_doctor_id'])->field('realname')->find();
  76. $info['report_doctor'] = $report_doctor['realname'];
  77. $info['report_datetime'] = $report['report_datetime'];
  78. $review_doctor = DB::table('doctors')->where('id',$report['review_doctor_id'])->field('realname')->find();
  79. $info['review_doctor'] = $review_doctor['realname'];
  80. $info['review_datetime'] = $report['review_datetime'];
  81. $info['description'] = $report['description'];
  82. $info['impression'] = $report['impression'];
  83. $info['report_result'] = $report['report_result'];
  84. $cache_key = $doctor['id'].'_'.$id;
  85. if(Cache::get($cache_key)){
  86. $cache = Cache::get($cache_key);
  87. $info['description'] = isset($cache['description']) ? $cache['description'] : '';
  88. $info['impression'] = isset($cache['impression']) ? $cache['impression'] : '';
  89. $info['report_result'] = isset($cache['r_result']) ?$cache['r_result'] : '';
  90. $info['name'] = isset($cache['name']) ? $cache['name'] : '';
  91. $info['sex'] = isset($cache['sex']) ? $cache['sex'] : '';
  92. $info['age'] = isset($cache['age']) ? $cache['age'] : '';
  93. $info['phone'] = isset($cache['phone']) ? $cache['phone'] : '';
  94. }
  95. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid,'is_remote'=>$is_remote]);
  96. }catch(\Exception $e){
  97. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  98. }
  99. }
  100. /**
  101. * 上远程申请附件
  102. *
  103. * @ApiTitle (上远程申请附件)
  104. * @ApiSummary (上远程申请附件)
  105. * @ApiSector (远程诊断)
  106. * @ApiMethod (POST)
  107. * @ApiRoute (/inter/writereport/upload)
  108. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  109. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  110. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  111. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  112. * @ApiParams (name="file", type="string", required=true, description="上传的文件<必填>")
  113. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  114. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  115. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  116. * @ApiReturn (data="
  117. {
  118. 'status': ok,
  119. 'code': '0000',
  120. 'info' : '/upload/20180101/12346asd.jpg'
  121. }
  122. *")
  123. **/
  124. public function upload($files){
  125. // 获取表单上传文件
  126. foreach($files as $file){
  127. // 移动到框架应用根目录/public/uploads/ 目录下
  128. $info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
  129. if($info){
  130. return $info->getSaveName();
  131. // 成功上传后 获取上传信息
  132. // 输出 jpg
  133. // echo $info-> getExtension();
  134. // 输出 42a79759f284b767dfcb2a0197904287.jpg
  135. // echo $info->getFilename();
  136. }else{
  137. // 上传失败获取错误信息
  138. // echo $file->getError();
  139. }
  140. }
  141. }
  142. /**
  143. * 报告保存
  144. *
  145. * @ApiTitle (报告保存)
  146. * @ApiSummary (报告保存)
  147. * @ApiSector (远程诊断)
  148. * @ApiMethod (POST)
  149. * @ApiRoute (/inter/writereport/write)
  150. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  151. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  152. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  153. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  154. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  155. * @ApiParams (name="is_remote", type="string", required=true, description="是否为远程列表进入")
  156. * @ApiParams (name="param[id]", type="string", sample="", description="exams表id值<必填>")
  157. * @ApiParams (name="param[pid]", type="string", sample="", description="患者id值<必填>")
  158. * @ApiParams (name="param[name]", type="string", sample="", description="患者姓名<必填>")
  159. * @ApiParams (name="param[age]", type="string", sample="", description="患者年龄<必填>")
  160. * @ApiParams (name="param[sex]", type="string", sample="", description="患者性别<必填>")
  161. * @ApiParams (name="param[impression]", type="string", sample="", description="影响所见<必填>")
  162. * @ApiParams (name="param[description]", type="string", sample="", description="意见建议<必填>")
  163. * @ApiParams (name="param[film_type]", type="string", sample="", description="胶片<必填>")
  164. * @ApiParams (name="param[r_result]", type="string", sample="", description="检查结果<必填>")
  165. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  166. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  167. * @ApiReturnParams (name="msg", type="string", required=true, sample="返回成功", description="返回消息")
  168. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  169. * @ApiReturn (data="
  170. {
  171. 'status': ok,
  172. 'code': '0000',
  173. 'sessionid': 'a17z7a7a8f9g9rh9d89jio',
  174. 'msg' : '保存成功'
  175. }
  176. *")
  177. **/
  178. public function write(){
  179. try{
  180. $sessionid = $_REQUEST['sessionid'];
  181. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  182. // 是远程写报告 7
  183. $return = Verify::check_role($sessionid,7);
  184. }else{
  185. // 本地写报告权限 2
  186. $return = Verify::check_role($sessionid,2);
  187. }
  188. if($return != 1){
  189. return json_encode(['status'=>'fail','code'=>'1029','msg'=>'没有操作权限']);
  190. }
  191. $param = $_REQUEST['param'];
  192. $status = DB::table('exams')->where('id',$param['id'])->field('exam_status')->find();
  193. if($status['exam_status'] > 6){
  194. return json_encode(['status'=>'fail','code'=>'1034','msg'=>'报告已被保存,无法再次被修改']);
  195. }
  196. // Verify::wreportCheck($param);
  197. $doctor = Cache::get($sessionid);
  198. // $remote_app = DB::table('remote_application')->where('exam_id',$param['id'])->field('remote_doctor_id')->find();
  199. // if(!empty($remote_app['remote_doctor_id'])){
  200. // if($remote_app['remote_doctor_id'] != $doctor['id']){
  201. // return json_encode(['status'=>'fail','code'=>'1029','msg'=>'已被指定报告医生,您没有操作权限']);
  202. // }
  203. // }
  204. $this->uuids = new UUIDs();
  205. //初步报告生成
  206. $film_type = isset($param['film_type']) ? $param['film_type'] : '';
  207. // $exam_status = $this->get_exam_status($doctor['id'],7);
  208. $patient_info = array();
  209. $patient_info['id'] = isset($param['pid']) ? $param['pid'] : '';
  210. $patient_info['name'] = isset($param['name']) ? $param['name'] : '';
  211. $patient_info['age'] = isset($param['age']) ? $param['age'] : '';
  212. $patient_info['phone'] = isset($param['phone']) ? $param['phone'] : '';
  213. $patient_info['sex'] = isset($param['sex']) ? $param['sex'] : '';
  214. $patient = DB::table('patient_infos')->where('id',$param['pid'])->update($patient_info);
  215. $info = array();
  216. $info['exam_id'] = $param['id'];
  217. $info['impression'] = isset($param['impression']) ? $param['impression'] : '';
  218. $info['description'] = isset($param['description']) ? $param['description'] : '';
  219. if(isset($param['r_result']) && $param['r_result'] == 'true'){
  220. $info['report_result'] = 2;
  221. }else{
  222. $info['report_result'] = 1;
  223. }
  224. DB::table('exams')->where('id',$param['id'])->update(['exam_status'=>'7','film_type'=>$film_type,'exam_report'=>$info['report_result']]);
  225. $info['report_datetime'] = date('Y-m-d H:i:s',time());
  226. $info['report_doctor_id'] = $doctor['id'];
  227. $report_info = DB::table('report')->where('exam_id',$param['id'])->find();
  228. if($report_info){
  229. $report = DB::table('report')->where('exam_id',$param['id'])->update($info);
  230. $id = $report_info['id'];
  231. }else{
  232. $id = $this->uuids->uuid16();
  233. $info['id'] = $id;
  234. $info['createdAt'] = date('Y-m-d H:i:s',time());
  235. $report = DB::table('report')->insert($info);
  236. }
  237. $cache_key = $doctor['id'].'_'.$param['id'];
  238. if(Cache::get($cache_key)){
  239. Cache::rm($cache_key);
  240. }
  241. //写入log日志
  242. log::record('----日志写入----');
  243. $log = array();
  244. $log['id'] = UUIDs::uuid16();
  245. $log['impression'] = isset($param['impression']) ? $param['impression'] : '';
  246. $log['description'] = isset($param['description']) ? $param['description'] : '';
  247. $log['report_id'] = $id;
  248. $log['createdAt'] = date('Y-m-d H:i:s',time());
  249. $log['doctor_id'] = $doctor['id'];
  250. $log['type'] = 1; //写报告
  251. log::record($log);
  252. $report_log = DB::table('report_record')->insert($log);
  253. log::record($report_log);
  254. log::record('----日志写入成功----');
  255. $application = DB::table('remote_application')->where('exam_id',$id)->find();
  256. if($application['req_doctor_id'] == 'c44663d6d3c0b535'){
  257. // 上级医院
  258. $s_institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  259. //下级医院
  260. $x_institution = DB::table('institution')->where('id',$application['local_institution_id'])->field('name')->find();
  261. $x_name = DB::table('doctors')->where('id',$application['req_doctor_id'])->field('realname')->find();
  262. $tel = '18910184804';
  263. $type = '保存报告';
  264. $content = $s_institution['name'].'医院的'.$doctor['realname'].'医生保存了下级'.$x_institution['name'].'医院的'.$x_name['realname'].'医生发起的申请,单子的申请单id是'.$application['id'];
  265. send_message::sendSms2Self($tel,$type,$content);
  266. }
  267. return json_encode(['status'=>'ok','code'=>'0000','msg'=>'保存成功','sessionid'=>$sessionid]);
  268. }catch(\Exception $e){
  269. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  270. }
  271. }
  272. public function get_exam_status($doctorid,$status){
  273. $doctor_class = DB::table('doctor_class')->where('doctor_id',$doctorid)->field('doctor_class')->find();
  274. if(strpos($doctor_class['doctor_class'],'9')){
  275. return 9;
  276. }elseif(strpos($doctor_class['doctor_class'],'8')){
  277. return 8;
  278. }else{
  279. return $status;
  280. }
  281. }
  282. /**
  283. * 公有模板列表
  284. *
  285. * @ApiTitle (公有模板列表)
  286. * @ApiSummary (公有模板列表)
  287. * @ApiSector (远程诊断)
  288. * @ApiMethod (POST)
  289. * @ApiRoute (/inter/writereport/public_template)
  290. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  291. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  292. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  293. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  294. * @ApiParams (name="exam_class", type="string", required=true, description="检查类id")
  295. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  296. * @ApiReturn (data="
  297. {
  298. 'info' : ''
  299. }
  300. *")
  301. **/
  302. public function public_template(){
  303. $sessionid = $_REQUEST['sessionid'];
  304. $doctor = Cache::get($sessionid);
  305. $exam = $_REQUEST['exam_class'];
  306. //第一级 公共模板
  307. $info = $this->get_template(1,$doctor['id'],$exam);
  308. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid]);
  309. }
  310. /**
  311. * 私有模板列表
  312. *
  313. * @ApiTitle (私有模板列表)
  314. * @ApiSummary (私有模板列表)
  315. * @ApiSector (远程诊断)
  316. * @ApiMethod (POST)
  317. * @ApiRoute (/inter/writereport/private_template)
  318. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  319. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  320. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  321. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  322. * @ApiParams (name="exam_class", type="string", required=true, description="检查类id")
  323. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  324. * @ApiReturn (data="
  325. {
  326. 'info' : ''
  327. }
  328. *")
  329. **/
  330. public function private_template(){
  331. $sessionid = $_REQUEST['sessionid'];
  332. $doctor = Cache::get($sessionid);
  333. $exam = $_REQUEST['exam_class'];
  334. //私有模板
  335. $info = $this->get_template(2,$doctor['id'],$exam);
  336. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid]);
  337. }
  338. public function get_template($public,$id,$exam){
  339. // 查询exam_class表
  340. $examCla = DB::table('constant')->where('id',$exam)->field('constant_value as name')->find();
  341. if($public == 1){
  342. $t = DB::table('templates')->where('is_public',$public)->where('exam_class_id',$examCla['name'])->field(['id','title as label','impression','description','parent_id'])->select();
  343. }else{
  344. // 私有模板 添加创建人条件
  345. $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();
  346. }
  347. if(!$t){
  348. return '';
  349. }
  350. $data = array();
  351. foreach ($t as $k => $v) {
  352. if($v['parent_id'] == '0'){
  353. $data[] = $v;
  354. }
  355. }
  356. foreach ($data as $k => $v) {
  357. unset($data[$k]['impression']);
  358. unset($data[$k]['description']);
  359. unset($data[$k]['parent_id']);
  360. }
  361. foreach ($t as $k => $v) {
  362. foreach ($data as $key => $value) {
  363. if($v['parent_id'] == $value['id']){
  364. unset($t[$k]['parent_id']);
  365. $data[$key]['children'][] = $t[$k];
  366. }
  367. }
  368. }
  369. if($data){
  370. return $data;
  371. }
  372. }
  373. /**
  374. * 确认报告
  375. *
  376. * @ApiTitle (确认报告)
  377. * @ApiSummary (确认报告)
  378. * @ApiSector (远程诊断)
  379. * @ApiMethod (POST)
  380. * @ApiRoute (/inter/writereport/confirm)
  381. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  382. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  383. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  384. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  385. * @ApiParams (name="id", type="string", sample="", description="exams表id值<必填>")
  386. * @ApiParams (name="film_type", type="string", sample="", description="胶片类型<必填>")
  387. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  388. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  389. * @ApiReturnParams (name="msg", type="string", required=true, sample="返回成功", description="返回消息")
  390. * @ApiReturn (data="
  391. {
  392. 'status': ok,
  393. 'code': '0000',
  394. 'msg': '已确认',
  395. }
  396. *")
  397. **/
  398. public function confirm(){
  399. try{
  400. $is_remote = $_REQUEST['is_remote'];
  401. if($is_remote == 1){
  402. return json_encode(['status'=>'fail','code'=>'1133','msg'=>'远程无法确诊报告']);
  403. }
  404. $sessionid = $_REQUEST['sessionid'];
  405. $doctor = Cache::get($sessionid);
  406. $param = $_REQUEST['param'];
  407. $id = $param['id'];
  408. $status = DB::table('exams')->where('id',$id)->field('exam_status')->find();
  409. if($status['exam_status'] < 8 ){
  410. return json_encode(['status'=>'fail','code'=>'1033','msg'=>'只能确认通过审核的报告']);
  411. }elseif($status['exam_status'] == 9){
  412. return json_encode(['status'=>'fail','code'=>'1034','msg'=>'已经确认过该报告,不可再次确认']);
  413. }
  414. $rinfo = array();
  415. $rinfo['impression'] = isset($param['impression']) ? $param['impression'] : '';
  416. $rinfo['description'] = isset($param['description']) ? $param['description'] : '';
  417. if(isset($param['r_result']) && $param['r_result'] == 'true'){
  418. $rinfo['report_result'] = 2;
  419. }else{
  420. $rinfo['report_result'] = 1;
  421. }
  422. $rinfo['confirm_datetime'] = date('Y-m-d H:i:s',time());
  423. $rinfo['confirm_doctor_id'] = $doctor['id'];
  424. // $exam_status = $this->get_exam_status($doctor['id'],9);
  425. DB::table('exams')->where('id',$id)->update(['exam_status'=>'9','film_type'=>$_REQUEST['param']['film_type']]);
  426. DB::table('report')->where('exam_id',$id)->update($rinfo);
  427. $cache_key = $doctor['id'].'_'.$id;
  428. if(Cache::get($cache_key)){
  429. Cache::rm($cache_key);
  430. }
  431. // 添加 确认log日志
  432. $info = array();
  433. $info['id'] = UUIDs::uuid16();
  434. $info['createdAt'] = date('Y-m-d H:i:s',time());
  435. $info['doctor_id'] = $doctor['id'];
  436. $info['type'] = 3;
  437. $info['report_id'] = '';
  438. DB::table('report_record')->insert($info);
  439. return json_encode(['status'=>'ok','code'=>'0000','msg'=>'已确认']);
  440. }catch(\Exception $e){
  441. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  442. }
  443. }
  444. /**
  445. * 审核报告
  446. *
  447. * @ApiTitle (审核报告)
  448. * @ApiSummary (审核报告)
  449. * @ApiSector (远程诊断)
  450. * @ApiMethod (POST)
  451. * @ApiRoute (/inter/writereport/examine)
  452. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  453. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  454. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  455. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  456. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  457. * @ApiParams (name="is_remote", type="string", required=true, description="是否为远程列表进入")
  458. * @ApiParams (name="id", type="string", sample="", description="exams表id值<必填>")
  459. * @ApiParams (name="param[impression]", type="string", sample="", description="检查所见<必填>")
  460. * @ApiParams (name="param[description]", type="string", sample="", description="意见建议<必填>")
  461. * @ApiParams (name="param[r_result]", type="string", sample="", description="检查结果<必填>")
  462. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  463. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  464. * @ApiReturnParams (name="msg", type="string", required=true, sample="返回成功", description="返回消息")
  465. * @ApiReturn (data="
  466. {
  467. 'status': ok,
  468. 'code': '0000',
  469. 'msg': '已审核',
  470. }
  471. *")
  472. **/
  473. public function examine(){
  474. try{
  475. $id = $_REQUEST['id'];
  476. $status = DB::table('exams')->where('id',$id)->field('exam_status')->find();
  477. if($status['exam_status'] < 7){
  478. return json_encode(['status'=>'fail','code'=>'1032','msg'=>'只能审核已提交的报告']);
  479. }elseif($status['exam_status']>7){
  480. return json_encode(['status'=>'fail','code'=>'1035','msg'=>'报告已通过审核步骤,请勿重复操作']);
  481. }
  482. $report = DB::table('report')->where('exam_id',$id)->field('id')->find();
  483. $param = $_REQUEST['param'];
  484. $sessionid = $_REQUEST['sessionid'];
  485. $doctor = Cache::get($sessionid);
  486. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  487. // 是远程审核报告 8
  488. $return = Verify::check_role($sessionid,8);
  489. }else{
  490. // 本地审核权限 3
  491. $return = Verify::check_role($sessionid,3);
  492. }
  493. $report_info = array();
  494. $report_info['impression'] = isset($param['impression']) ? $param['impression'] : '';
  495. $report_info['description'] = isset($param['description']) ? $param['description'] : '';
  496. if(isset($param['r_result']) && $param['r_result'] == 'true'){
  497. $report_info['report_result'] = 2;
  498. }else{
  499. $report_info['report_result'] = 1;
  500. }
  501. $report_info['review_datetime'] = date('Y-m-d H:i:s',time());
  502. $report_info['review_doctor_id'] = $doctor['id'];
  503. DB::table('report')->where('id',$report['id'])->update($report_info);
  504. $cache_key = $doctor['id'].'_'.$id;
  505. if(Cache::get($cache_key)){
  506. Cache::rm($cache_key);
  507. }
  508. $info = array();
  509. $info['id'] = UUIDs::uuid16();
  510. $info['type'] = 2; //审核
  511. $info['createdAt'] = date('Y-m-d H:i:s',time());
  512. $info['doctor_id'] = $doctor['id'];
  513. $info['impression'] = isset($param['impression']) ? $param['impression'] : '';
  514. $info['description'] = isset($param['description']) ? $param['description'] : '';
  515. $info['report_id'] = $report['id'];
  516. DB::table('report_record')->insert($info);
  517. // $exam_status = $this->get_exam_status($doctor['id'],8);
  518. DB::table('exams')->where('id',$id)->update(['exam_status'=>'8','film_type'=>$param['film_type']]);
  519. // 已审核 发送短信
  520. $application = DB::table('remote_application')->where('exam_id',$id)->find();
  521. if($application['req_doctor_id'] == 'c44663d6d3c0b535'){
  522. $dinfo = DB::table('doctors')->where('id',$application['req_doctor_id'])->find();
  523. $d_phone = $dinfo['phone'];
  524. $d_name = '';
  525. $repsone = send_message::sendSms2CompleteReport($d_phone,$d_name);
  526. // 上级医院
  527. $s_institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  528. //下级医院
  529. $x_institution = DB::table('institution')->where('id',$application['local_institution_id'])->field('name')->find();
  530. $x_name = DB::table('doctors')->where('id',$application['req_doctor_id'])->field('realname')->find();
  531. $tel = '18910184804';
  532. $type = '完成并审核报告';
  533. $content = $s_institution['name'].'医院的'.$doctor['realname'].'医生完成并审核了下级'.$x_institution['name'].'医院的'.$x_name['realname'].'医生发起的申请,单子的申请单id是'.$application['id'];
  534. send_message::sendSms2Self($tel,$type,$content);
  535. }
  536. return json_encode(['status'=>'ok','code'=>'0000','msg'=>'已审核']);
  537. }catch(\Exception $e){
  538. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  539. }
  540. }
  541. /**
  542. * 获取报告权限
  543. *
  544. * @ApiTitle (获取报告权限)
  545. * @ApiSummary (获取报告权限)
  546. * @ApiSector (远程诊断)
  547. * @ApiMethod (POST)
  548. * @ApiRoute (/inter/writereport/getrole)
  549. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  550. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  551. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  552. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  553. * @ApiParams (name="is_remote", type="string", required=true, description="是否为远程列表进入")
  554. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  555. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  556. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  557. * @ApiReturn (data="
  558. {
  559. 'status': ok,
  560. 'code': '0000',
  561. 'info': '',
  562. }
  563. *")
  564. **/
  565. public function getrole(){
  566. try{
  567. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote'] == 1){
  568. $is_remote = $_REQUEST['is_remote'];
  569. }
  570. $sessionid = $_REQUEST['sessionid'];
  571. $doctor = Cache::get($sessionid);
  572. $dclass = DB::table('doctor_class')->where('doctor_id',$doctor['id'])->field('doctor_class')->find();
  573. $doctor_class = explode(',',$dclass['doctor_class']);
  574. $info = array();
  575. foreach ($doctor_class as $k=>$v) {
  576. switch($v){
  577. case 2: //报告医生
  578. if(isset($is_remote)){
  579. //远程报告
  580. break;
  581. }
  582. $info['bg'] = 1;
  583. break;
  584. case 7: //远程报告医生
  585. if(!isset($is_remote)){
  586. //远程报告
  587. break;
  588. }
  589. $info['bg'] = 1;
  590. break;
  591. case 3: //3审核医生
  592. if(isset($is_remote)){
  593. //远程报告
  594. break;
  595. }
  596. $info['sh'] = 2;
  597. break;
  598. case 8: //远程审核医生
  599. if(!isset($is_remote)){
  600. //远程报告
  601. break;
  602. }
  603. $info['sh'] = 2;
  604. break;
  605. case 4: //确认医生
  606. $info['qr'] = 3;
  607. break;
  608. }
  609. }
  610. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info]);
  611. }catch(\Exception $e){
  612. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  613. }
  614. }
  615. /**
  616. * 获取报告日志
  617. *
  618. * @ApiTitle (获取报告日志)
  619. * @ApiSummary (获取报告日志)
  620. * @ApiSector (远程诊断)
  621. * @ApiMethod (POST)
  622. * @ApiRoute (/inter/writereport/get_report_log)
  623. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  624. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  625. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  626. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  627. * @ApiParams (name="id", type="string", required=true, description="exams表id值")
  628. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  629. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  630. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  631. * @ApiReturn (data="
  632. {
  633. 'status': ok,
  634. 'code': '0000',
  635. 'info': '',
  636. }
  637. *")
  638. **/
  639. public function get_report_log(){
  640. try{
  641. $sessionid = $_REQUEST['sessionid'];
  642. $doctor = Cache::get($sessionid);
  643. $exam_id = $_REQUEST['id'];
  644. $report = DB::table('report')->where('exam_id',$exam_id)->field('id')->find();
  645. if(empty($report)){
  646. return json_encode(['status'=>'ok','code'=>'0000','info'=>'','msg'=>'无数据']);
  647. }
  648. $log_id = $report['id'];
  649. $log = DB::table('report_record')->where('doctor_id',$doctor['id'])->where('report_id',$log_id)->order('createdAt asc,type asc')->select();
  650. foreach ($log as $k => $v) {
  651. $doc = DB::table('doctors')->where('id',$v['doctor_id'])->field('realname')->find();
  652. $log[$k]['doctor_name'] = $doc['realname'];
  653. }
  654. return json_encode(['status'=>'ok','code'=>'0000','info'=>$log]);
  655. }catch(\Exception $e){
  656. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  657. }
  658. }
  659. /**
  660. * 打印报告
  661. *
  662. * @ApiTitle (打印报告)
  663. * @ApiSummary (打印报告)
  664. * @ApiSector (远程诊断)
  665. * @ApiMethod (POST)
  666. * @ApiRoute (/inter/writereport/print_report)
  667. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  668. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  669. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  670. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  671. * @ApiParams (name="id", type="string", required=true, description="exams表id值")
  672. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  673. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  674. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  675. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  676. * @ApiReturn (data="
  677. {
  678. 'status': ok,
  679. 'code': '0000',
  680. 'sessionid': 'a17z7a7a8f9g9rh9d89jio',
  681. 'info': '',
  682. }
  683. *")
  684. **/
  685. public function print_report(){
  686. try{
  687. $sessionid = $_REQUEST['sessionid'];
  688. $doctor = Cache::get($sessionid);
  689. $id = $_REQUEST['id'];
  690. $info = array();
  691. // 检查日期 住院号 床号
  692. $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')->find();
  693. $info['id'] = $exam_info['id'];
  694. $info['ext'] = $exam_info['ext'];
  695. $info['accession_num'] = $exam_info['accession_num'];
  696. if(!empty($exam_info['exam_datetime'])){
  697. $datetime = explode(' ',$exam_info['exam_datetime']);
  698. $info['exam_datetime'] = $datetime[0];
  699. }else{
  700. $info['exam_datetime'] = '';
  701. }
  702. $info['hopitalized_no'] = $exam_info['hopitalized_no'];
  703. $info['bed_no'] = $exam_info['bed_no'];
  704. // 检查项目
  705. $project = DB::table('exam_project')->where('id',$exam_info['exam_project'])->field('name')->find();
  706. $info['project'] = $project['name'];
  707. //检查类
  708. $exam_class = DB::table('constant')->where('id',$exam_info['exam_class'])->field('constant_value')->find();
  709. $info['exam_class'] = $exam_class['constant_value'];
  710. // 病历号 姓名 年龄 性别
  711. $patient_info = DB::table('patient_infos')->where('id',$exam_info['patient_id'])->field('temp_patient_id,name,sex,age')->find();
  712. $remote = DB::table('remote_application')->where('exam_id',$id)->field('req_doctor_id')->find();
  713. $info['pnumber'] = $patient_info['temp_patient_id'];
  714. $info['name'] = $patient_info['name'];
  715. $info['sex'] = $patient_info['sex'];
  716. $info['age'] = $patient_info['age'];
  717. // 申请医生
  718. $application_name = DB::table('doctors')->where('id',$remote['req_doctor_id'])->field('realname,department_id')->find();
  719. $info['application_name'] = $application_name['realname'];
  720. // 申请科室
  721. $department = DB::table('department')->where('id',$application_name['department_id'])->field('department_name')->find();
  722. $info['department_name'] = $department['department_name'];
  723. // 报告时间 影像所见 意见建议
  724. $report = DB::table('report')->where('exam_id',$id)->field('report_datetime,impression,description,report_doctor_id,review_doctor_id')->find();
  725. if(!empty($report['report_datetime'])){
  726. $datetime1 = explode(' ',$report['report_datetime']);
  727. $info['report_datetime'] = $datetime1[0];
  728. }else{
  729. $info['report_datetime'] = '';
  730. }
  731. $info['report_datetime_xa'] = $report['report_datetime'];
  732. $info['impression'] = $report['impression'];
  733. $info['description'] = $report['description'];
  734. // 报告医生
  735. $report_doctor = DB::table('doctors')->where('id',$report['report_doctor_id'])->field('realname')->find();
  736. $info['report_doctor'] = $report_doctor['realname'];
  737. //审核医生
  738. $review_doctor = DB::table('doctors')->where('id',$report['review_doctor_id'])->field('realname')->find();
  739. $info['review_doctor'] = $review_doctor['realname'];
  740. $hospital = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  741. $info['hospital'] = $hospital['name'];
  742. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid]);
  743. }catch(\Exception $e){
  744. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  745. }
  746. }
  747. /**
  748. * 变更胶片
  749. *
  750. * @ApiTitle (变更胶片)
  751. * @ApiSummary (变更胶片)
  752. * @ApiSector (远程诊断)
  753. * @ApiMethod (POST)
  754. * @ApiRoute (/inter/writereport/change_film)
  755. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  756. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  757. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  758. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  759. * @ApiParams (name="id", type="string", required=true, description="exams表id值")
  760. * @ApiParams (name="film_type", type="string", required=true, description="胶片")
  761. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  762. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  763. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  764. * @ApiReturn (data="z
  765. {
  766. 'status': ok,
  767. 'code': '0000',
  768. 'info': '',
  769. }
  770. *")
  771. **/
  772. public function change_film(){
  773. $id = $_REQUEST['id'];
  774. $film = $_REQUEST['film_type'];
  775. DB::table('exams')->where('id',$id)->update(['film_type'=>$film]);
  776. return json_encode(['status'=>'ok','info'=>$film,'code'=>'0000']);
  777. }
  778. public function draft(){
  779. $sessionid = $_REQUEST['sessionid'];
  780. $doctor = Cache::get($sessionid);
  781. $param = $_REQUEST['param'];
  782. $exam_id = $param['id'];
  783. $key = $doctor['id'].'_'.$exam_id;
  784. Cache::set($key,$param);
  785. return json_encode(['status'=>'ok','msg'=>'保存成功','code'=>'0000']);
  786. }
  787. // XA类型数据获取
  788. public function get_rinfo(){
  789. $sessionid = $_REQUEST['sessionid'];
  790. $doctor = Cache::get($sessionid);
  791. $id = $_REQUEST['id'];
  792. $key = $doctor['id'].'_'.$id;
  793. if(Cache::get($key)){
  794. $patient = Cache::get($key);
  795. }else{
  796. $exam = DB::table('exams')->where('id',$id)->field('accession_num,exam_class,patient_id,ext,hopitalized_no,bed_no')->find();
  797. $patient = DB::table('patient_infos')->where('id',$exam['patient_id'])->field(['id','temp_patient_id','name','phone','sex','age'])->find();
  798. $report_info = DB::table('report')->where('exam_id',$id)->field('description')->find();
  799. $patient['ext'] = $exam['ext'];
  800. $patient['exam_id'] = $id;
  801. $patient['bed_no'] = $exam['bed_no'];
  802. $patient['accession_num'] = $exam['accession_num'];
  803. $patient['exam_class'] = $exam['exam_class'];
  804. $patient['hopitalized_no'] = $exam['hopitalized_no'];
  805. $patient['description'] = $report_info['description'];
  806. }
  807. return json_encode(['status'=>'ok','info'=>$patient,'code'=>'0000']);
  808. }
  809. // XA类型保存
  810. public function write_info(){
  811. $sessionid = $_REQUEST['sessionid'];
  812. $doctor = Cache::get($sessionid);
  813. $param = $_REQUEST['param'];
  814. $patient_info['name'] = isset($param['name']) ? $param['name'] : '';
  815. $patient_info['sex'] = isset($param['sex']) ? $param['sex'] : '';
  816. $patient_info['age'] = isset($param['age']) ? $param['age'] : '';
  817. $exam_info['hopitalized_no'] = isset($param['hospital_number']) ? $param['hospital_number'] : '';
  818. $exam_info['bed_no'] = isset($param['bed_number']) ? $param['bed_number'] : '';
  819. $exam_info['ext'] = isset($param['ext']) ? $param['ext'] : '';
  820. $exam_info['accession_num'] = isset($param['accession_num']) ? $param['accession_num'] : '';
  821. $report['description'] = isset($param['description']) ? $param['description'] : '';
  822. $report['report_datetime'] = date('Y-m-d H:i:s',time());
  823. $report['report_doctor_id'] = $doctor['id'];
  824. DB::table('patient_infos')->where('id',$param['pid'])->update($patient_info);
  825. DB::table('exams')->where('id',$param['id'])->update($exam_info);
  826. $rinfo = DB::table('report')->where('exam_id',$param['id'])->find();
  827. if($rinfo){
  828. DB::table('report')->where('exam_id',$param['id'])->update($report);
  829. $rinfo = DB::table('report')->where('exam_id',$param['id'])->find();
  830. $rid = $rinfo['id'];
  831. }else{
  832. $report['id'] = UUIDs::uuid16();
  833. $report['exam_id'] = $param['id'];
  834. $report['createdAt'] = date('Y-m-d H:i:s',time());
  835. DB::table('report')->insert($report);
  836. $rid = $report['id'];
  837. }
  838. $log = array();
  839. $log['id'] = UUIDs::uuid16();
  840. $log['impression'] = isset($param['ext']) ? $param['ext'] : '';
  841. $log['description'] = isset($param['description']) ? $param['description'] : '';
  842. $log['report_id'] = $rid;
  843. $log['createdAt'] = date('Y-m-d H:i:s',time());
  844. $log['doctor_id'] = $doctor['id'];
  845. $log['type'] = 1; //写报告
  846. log::record($log);
  847. $report_log = DB::table('report_record')->insert($log);
  848. $application = DB::table('exam_id',$param['id'])->find();
  849. if($application['req_doctor_id'] == 'c44663d6d3c0b535'){
  850. // 上级医院
  851. $s_institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  852. //下级医院
  853. $x_institution = DB::table('institution')->where('id',$application['local_institution_id'])->field('name')->find();
  854. $x_name = DB::table('doctors')->where('id',$application['req_doctor_id'])->field('realname')->find();
  855. $tel = '18910184804';
  856. $type = '保存报告';
  857. $content = $s_institution['name'].'医院的'.$doctor['realname'].'医生保存了下级'.$x_institution['name'].'医院的'.$x_name['realname'].'医生发起的申请,单子的申请单id是'.$application['id'];
  858. send_message::sendSms2Self($tel,$type,$content);
  859. }
  860. return json_encode(['status'=>'ok','msg'=>'成功','code'=>'0000']);
  861. }
  862. }