Writereport.php 73 KB

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