Application.php 41 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713
  1. <?php
  2. namespace app\inter\controller;
  3. use think\Controller;
  4. use think\Db;
  5. use think\Session;
  6. use app\common\library\UUIDs;
  7. use think\Cache;
  8. use think\Log;
  9. use app\common\library\Verify;
  10. use think\File;
  11. use app\common\library\send_message;
  12. use app\common\library\Message;
  13. class Application extends Base
  14. {
  15. /**
  16. * 发起远程申请
  17. *
  18. * @ApiTitle (发起远程申请)
  19. * @ApiSummary (发起远程申请)
  20. * @ApiSector (远程诊断)
  21. * @ApiMethod (POST)
  22. * @ApiRoute (/inter/application/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=true, 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="参数json字符串")
  29. * @ApiParams (name="param[id]", type="string", sample="", description="预约登记exams表id值<必填>")
  30. * @ApiParams (name="param[rid]", type="string", sample="", description="远程申请表id值<远程列表进入必填>")
  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. 'rid' : ''
  44. }
  45. *")
  46. **/
  47. public function index(){
  48. try{
  49. $sessionid = $_REQUEST['sessionid'];
  50. $param = $_REQUEST['param'];
  51. $id = $param['id'];
  52. $is_remote = 0;
  53. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote']==1){
  54. $is_remote = 1;
  55. }
  56. $info = DB::table('exams')->where('id',$id)->field('id,urgent,study_id,patient_id,register_datetime,exam_class,exam_sub_class,exam_project,device,exam_datetime,exam_status')->find();
  57. $exam_class = DB::table('constant')->where('id',$info['exam_class'])->field('constant_value')->find();
  58. $exam_subclass = DB::table('exam_subclass')->where('id',$info['exam_sub_class'])->cache(300)->find();
  59. $exam_project = DB::table('exam_project')->where('id',$info['exam_project'])->cache(300)->find();
  60. $device = DB::table('device')->where('id',$info['device'])->cache(300)->find();
  61. $info['exam_class_name'] = $exam_class['constant_value'];
  62. $info['exam_subclass_name'] = $exam_subclass['name'];
  63. $info['exam_project_name'] = $exam_project['name'];
  64. $info['device_name'] = $device['name'];
  65. $patient_info = DB::table('patient_infos')->where('id',$info['patient_id'])->field(['temp_patient_id','id','name','sex','age','birthday'])->find();
  66. $info['pid'] = $patient_info['id'];
  67. $info['temp_patient_id'] = $patient_info['temp_patient_id'];
  68. $info['name'] = $patient_info['name'];
  69. $info['sex'] = $patient_info['sex'];
  70. $info['age'] = $patient_info['age'];
  71. if(!empty($patient_info['birthday'])){
  72. $info['birthday'] = $patient_info['birthday'];
  73. }
  74. $doctor = Cache::get($sessionid);
  75. $institution_id = $doctor['institution_id'];
  76. $hospital = DB::table('institution')->where('id',$institution_id)->find();
  77. $parent_hosp = explode(',',$hospital['parent_institution']);
  78. $parent_name = array();
  79. foreach($parent_hosp as $v){
  80. $phname = DB::table("institution")->where('id',$v)->cache(300)->field(['id','name'])->find();
  81. $doctor_info = DB::table('doctors')->where('institution_id',$v)->field('id,realname,is_admin')->order('is_admin desc')->select();
  82. foreach($doctor_info as $key=>$value){
  83. if($value['is_admin'] == 1){
  84. $doctor_info[$key]['realname'] = $value['realname'].'---医院管理员';
  85. }
  86. }
  87. $phname['doctor'] = $doctor_info;
  88. $parent_name[] =$phname;
  89. }
  90. $info['parent_hospital'] = $parent_name;
  91. //申请信息
  92. if(isset($param['rid']) && !empty($param['rid'])){
  93. $rid = $param['rid'];
  94. $application = DB::table('remote_application')->where('id',$rid)->field(['id,report_status,id,remote_doctor_id','application_desc','attachment','req_doctor_id','illness_desc','phys_sign','is_urgent','clin_symp','anamnesis','family_ill','remark','clin_diag'])->find();
  95. $aid = $application['id'];
  96. }else{
  97. $rid = '';
  98. $application = DB::table('remote_application')->where('exam_id',$id)->field(['id,report_status,id,remote_doctor_id','application_desc','attachment','req_doctor_id','illness_desc','phys_sign','clin_symp','is_urgent','anamnesis','family_ill','remark','clin_diag'])->find();
  99. $aid = $application['id'];
  100. }
  101. if($is_remote == 1){
  102. Message::read($doctor['id'],$aid,1);
  103. //远程申请点击进入
  104. $dinfo = DB::table('doctors')->where('id',$application['req_doctor_id'])->field('department_id')->find();
  105. $dep = DB::table('department')->where('id',$dinfo['department_id'])->field('department_name')->find();
  106. }else{
  107. Message::read($doctor['id'],$aid,2);
  108. //本地远程申请中
  109. $dep = DB::table('department')->where('id',$doctor['department_id'])->field('department_name')->find();
  110. }
  111. $info['department_name'] = $dep['department_name'];
  112. if(empty($application)){
  113. $exam_application = DB::table('exams')->where('id',$id)->field(['illness_desc','phys_sign','clin_symp','remark','clin_diag','anamnesis','family_ill'])->find();
  114. if(empty($exam_application['anamnesis'])){
  115. $exam_application['anamnesis'] = '';
  116. }else{
  117. $exam_application['anamnesis'] = explode(',',$exam_application['anamnesis']);
  118. }
  119. if(empty($exam_application['family_ill'])){
  120. $exam_application['family_ill'] = '';
  121. }else{
  122. $exam_application['family_ill'] = explode(',',$exam_application['family_ill']);
  123. }
  124. $exam_application['report_status'] = '';
  125. $info['application'] = $exam_application;
  126. }else{
  127. $remote_name = DB::table('doctors')->where('id',$application['remote_doctor_id'])->field('realname')->find();
  128. $application['remote_doctor'] = $remote_name['realname'];
  129. if(empty($application['anamnesis'])){
  130. $application['anamnesis'] = '';
  131. }else{
  132. $application['anamnesis'] = explode(',',$application['anamnesis']);
  133. }
  134. if(empty($application['family_ill'])){
  135. $application['family_ill'] = '';
  136. }else{
  137. $application['family_ill'] = explode(',',$application['family_ill']);
  138. }
  139. $info['application'] = $application;
  140. }
  141. $count = DB::table('messages')->where('application_id',$aid)->where('doctor_id',$doctor['id'])->where('status',0)->where('type',7)->where('is_read',0)->field('count')->find();
  142. $info['unread_message_num'] = $count['count'];
  143. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid,'is_remote'=>$is_remote,'rid'=>$aid]);
  144. }catch(\Exception $e){
  145. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  146. }
  147. }
  148. /**
  149. * 提交申请
  150. *
  151. * @ApiTitle (提交申请)
  152. * @ApiSummary (提交申请)
  153. * @ApiSector (远程诊断)
  154. * @ApiMethod (POST)
  155. * @ApiRoute (/inter/application/apply)
  156. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  157. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  158. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  159. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  160. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  161. * @ApiParams (name="param[id]", type="string", sample="", description="预约登记exams表id值<必填>")
  162. * @ApiParams (name="param[illness]", type="string", sample="", description="主诉<选填>")
  163. * @ApiParams (name="param[clin_symp]", type="string", sample="", description="临床症状<选填>")
  164. * @ApiParams (name="param[anamnesis]", type="string", sample="", description="既往史<选填>")
  165. * @ApiParams (name="param[family_ill]", type="string", sample="", description="家族史<选填>")
  166. * @ApiParams (name="param[remark]", type="string", sample="", description="备注<选填>")
  167. * @ApiParams (name="param[institution_id]", type="string", sample="", description="发起申请医院id值<选填>")
  168. * @ApiParams (name="param[clin_diag]", type="string", sample="", description="临床诊断<选填>")
  169. * @ApiParams (name="param[remote_institution]", type="string", sample="", description="申请的目标医院id值<选填>")
  170. * @ApiParams (name="param[is_urgent]", type="string", sample="", description="是否急诊 0否 1是<选填>")
  171. * @ApiParams (name="param[description]", type="string", sample="", description="申请描述<选填>")
  172. * @ApiParams (name="param[remote_doctor_id]", type="string", sample="", description="申请的目标医生id值<选填>")
  173. * @ApiParams (name="param[attachment]", type="string", sample="", description="附件<选填>")
  174. * @ApiParams (name="param[apply]", type="string", sample="", description="保存或者申请 存在值即保存 不存在则为申请<必填>")
  175. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  176. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  177. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  178. * @ApiReturn (data="
  179. {
  180. 'status': ok,
  181. 'code': '0000',
  182. 'sessionid': 'a17z7a7a8f9g9rh9d89jio'
  183. }
  184. *")
  185. **/
  186. public function apply(){
  187. try{
  188. log::record($_REQUEST);
  189. $sessionid = $_REQUEST['sessionid'];
  190. $doctor = Cache::get($sessionid);
  191. // 远程申请权限 6
  192. $return = Verify::check_role($sessionid,6);
  193. if($return != 1){
  194. return json_encode(['status'=>'fail','code'=>'1029','msg'=>'没有操作权限']);
  195. }
  196. $param = $_REQUEST['param'];
  197. $application_info = array();
  198. $application_info['remote_institution_id'] = isset($param['remote_institution']) ? $param['remote_institution'] : '';
  199. if(isset($param['remote_doctor_id']) && !empty($param['remote_doctor_id']) && empty($application_info['remote_doctor_id'])){
  200. $remote_doctor = DB::table('doctors')->where('id',$param['remote_doctor_id'])->find();
  201. $application_info['remote_institution_id'] = $remote_doctor['institution_id'];
  202. }
  203. if(empty($application_info['remote_institution_id'])){
  204. return json_encode(['status'=>'fail','code'=>'3029','msg'=>'没有选择远程机构']);
  205. }
  206. $exam_info = DB::table('exams')->where('id',$param['id'])->field('exam_class,exam_status,patient_id')->find();
  207. // 修改病人姓名
  208. DB::table('patient_infos')->where('id',$exam_info['patient_id'])->update(['name'=>$param['name']]);
  209. if($exam_info['exam_status'] != 3 && $exam_info['exam_status'] != 5 && $exam_info['exam_status'] != 8){
  210. // 3 检查完毕 5已驳回
  211. switch($exam_info['exam_status']){
  212. case 1:
  213. $msg = '患者还未检查,请检查完毕后再进行远程申请';
  214. return json_encode(['status'=>'fail','code'=>'1029','msg'=>$msg]);
  215. break;
  216. case 2:
  217. $msg = '影像未到达,不能发起远程申请';
  218. return json_encode(['status'=>'fail','code'=>'1029','msg'=>$msg]);
  219. break;
  220. }
  221. }
  222. Verify::applicationCheck($param);
  223. $where = array();
  224. // 申请医生
  225. $where['req_doctor_id'] = $doctor['id'];
  226. $where['remote_institution_id'] = $application_info['remote_institution_id'];
  227. // 只允许有一个申请 ----------------------------- 暂时添加
  228. $r = DB::table('remote_application')->where('exam_id',$param['id'])->where('report_status','not in',',5,12')->find();
  229. if($r){
  230. return json_encode(['status'=>'fail','code'=>'1120','msg'=>'每个医院同一个检查只能申请一次']);
  231. }
  232. //不等于9 代表
  233. $a_info = DB::table('remote_application')->where($where)->where('exam_id',$param['id'])->where('report_status','not in',',12,5,9')->find();
  234. if($a_info){
  235. return json_encode(['status'=>'fail','code'=>'1120','msg'=>'该申请目标医院存在未完成报告,只有报告完成后才能再次发起申请']);
  236. }
  237. $application_info['exam_id'] = isset($param['id']) ? $param['id'] : '';
  238. $application_info['illness_desc'] = isset($param['illness']) ? $param['illness'] : '';
  239. $application_info['phys_sign'] = isset($param['phys_sign']) ? $param['phys_sign'] : '';
  240. $application_info['clin_symp'] = isset($param['clin_symp']) ? $param['clin_symp'] : '';
  241. if(!empty($param['anamnesis'])){
  242. $application_info['anamnesis'] = implode(',',$param['anamnesis']);
  243. }
  244. if(!empty($param['family_ill'])){
  245. $application_info['family_ill'] = implode(',',$param['family_ill']);
  246. }
  247. $application_info['remark'] = isset($param['remark']) ? $param['remark'] : '';
  248. $application_info['local_institution_id'] = $doctor['institution_id'];
  249. $application_info['req_date_time'] = date('Y-m-d H:i:s',time());
  250. $application_info['clin_diag'] = isset($param['clin_diag']) ? $param['clin_diag'] : '';
  251. if(isset($param['is_urgent']) && $param['is_urgent'] == 'true' ){
  252. $application_info['is_urgent'] = 1;
  253. $application_info['remote_doctor_id'] = '';
  254. $d_time = date('H:i',strtotime('+30 min'));
  255. }else{
  256. $application_info['is_urgent'] = 0;
  257. $application_info['remote_doctor_id'] = isset($param['remote_doctor_id']) ? $param['remote_doctor_id'] : '';
  258. $d_time = date('H:i',strtotime('+1 hour'));
  259. }
  260. $application_info['application_desc'] = isset($param['description']) ? $param['description'] : '';
  261. $application_info['req_doctor_id'] = $doctor['id'];
  262. $application_info['remote_doctor_id'] = isset($param['remote_doctor_id']) ? $param['remote_doctor_id'] : '';
  263. $application_info['attachment'] = isset($param['attachment']) ? $param['attachment'] : '';
  264. // $remote_application = DB::table('remote_application')->where('exam_id',$param['id'])->select();
  265. // 申请远程
  266. // if(empty($remote_application)){
  267. log::record('新增远程申请');
  268. $re = DB::table('remote_application')->where('exam_id',$param['id'])->find();
  269. $report = array();
  270. if($re){
  271. // 存在被驳回申请 再次申请时则为驳回后发起的申请
  272. DB::table('remote_application')->where('exam_id',$param['id'])->update($application_info);
  273. $app_id = $re['id'];
  274. }else{
  275. $application_info['id'] = UUIDs::uuid16();
  276. $application_info['createdAt'] = date('Y-m-d H:i:s',time());
  277. DB::table('remote_application')->insert($application_info);
  278. $app_id = $application_info['id'];
  279. }
  280. $aid = $app_id;
  281. $r_info = DB::table('report')->where('exam_id',$param['id'])->find();
  282. if(empty($r_info)){
  283. $report['id'] = UUIDs::uuid16();
  284. $report['exam_id'] = $param['id'];
  285. $report['remote_application_id'] = $aid;
  286. $report['type'] = 2;
  287. DB::table('report')->insert($report);
  288. $r_id = $report['id'];
  289. }else{
  290. $r_id = $r_info['id'];
  291. }
  292. // }else{
  293. // log::record('修改远程申请');
  294. // DB::table('remote_application')->where('exam_id',$param['id'])->update($application_info);
  295. // $r = DB::table('remote_application')->where('exam_id',$param['id'])->field('id')->find();
  296. // $aid = $r['id'];
  297. // }
  298. if(isset($param['apply']) && !empty($param['apply'])){
  299. DB::table('remote_application')->where('exam_id',$param['id'])->update(['report_status'=>4]);
  300. // 添加messages信息
  301. $t = '收到一条远程诊断申请';
  302. $ins = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  303. $c = $ins['name'].$doctor['realname'].'医师向您发起一条远程诊断申请';
  304. $d = $application_info['remote_doctor_id'];
  305. $type = '1';
  306. $url = Message::url($sessionid,$param['id'],1,$exam_info['exam_class'],$r_id,$aid);
  307. Message::insert($t,$c,$d,$type,$url,1,$aid);
  308. //保存 申请
  309. $dinfo = DB::table('doctors')->where('id',$application_info['remote_doctor_id'])->find();
  310. $d_phone = $dinfo['phone'];
  311. $d_name = $dinfo['realname'];
  312. if($dinfo['institution_id'] == '22100003' || $dinfo['send_sms'] == 1){ //魏庙
  313. $repsone = send_message::sendSms2Apply($d_phone,$d_time,$d_name);
  314. }
  315. $tel = '18910184804';
  316. $type = '发起申请';
  317. $content = $aid;
  318. // $response = send_message::sendSms2Self($tel,$type,$content);
  319. }
  320. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid,'aid'=>$aid]);
  321. }catch(\Exception $e){
  322. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  323. }
  324. }
  325. /**
  326. * 上传附件
  327. *
  328. * @ApiTitle (上传附件)
  329. * @ApiSummary (上传附件)
  330. * @ApiSector (远程诊断)
  331. * @ApiMethod (POST)
  332. * @ApiRoute (/inter/application/upload)
  333. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  334. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  335. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  336. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  337. * @ApiParams (name="file", type="string", required=true, description="上传的文件<必填>")
  338. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  339. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  340. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  341. * @ApiReturn (data="
  342. {
  343. 'status': ok,
  344. 'code': '0000',
  345. 'info' : '/upload/20180101/12346asd.jpg'
  346. }
  347. *")
  348. **/
  349. //上传附件
  350. public function upload(){
  351. // 获取表单上传文件 例如上传了001.jpg
  352. $file = request()->file('file');
  353. log::record('----------上传的文件-----------');
  354. log::record($file);
  355. // 移动到框架应用根目录/public/uploads/ 目录下
  356. if($file){
  357. $info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
  358. log::record($info);
  359. if($info){
  360. return json_encode(['status'=>'ok','code'=>'0000','info'=>'/'.$_SERVER["SERVER_NAME"]. '/' . 'uploads'. '/' .$info->getSaveName()]);
  361. }else{
  362. // 上传失败获取错误信息
  363. return json_encode(['status'=>'fail','code'=>'1040','info'=>$file->getError()]);
  364. }
  365. }
  366. }
  367. /**
  368. * 远程申请驳回
  369. *
  370. * @ApiTitle (远程申请驳回)
  371. * @ApiSummary (远程申请驳回)
  372. * @ApiSector (远程诊断)
  373. * @ApiMethod (POST)
  374. * @ApiRoute (/inter/application/reject)
  375. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  376. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  377. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  378. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  379. * @ApiParams (name="param", type="string", required=true, sample="", description="参数json字符串,预约登记exams表id值<必填>")
  380. * @ApiParams (name="param[id]", type="string", sample="", description="预约登记exams表id值<必填>")
  381. * @ApiParams (name="param[description]", type="string", sample="", description="驳回原因<必填>")
  382. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  383. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  384. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  385. * @ApiReturn (data="
  386. {
  387. 'status': ok,
  388. 'code': '0000',
  389. 'sessionid': 'a17z7a7a8f9g9rh9d89jio'
  390. }
  391. *")
  392. **/
  393. //驳回 7
  394. public function reject(){
  395. $sessionid = $_REQUEST['sessionid'];
  396. $doctor = Cache::get($sessionid);
  397. $param = $_REQUEST['param'];
  398. $id = $param['id'];
  399. $re = DB::table('remote_application')->where('id',$id)->field('exam_id,report_status')->find();
  400. if($re['report_status'] != 4){
  401. return json_encode(['status'=>'fail','code'=>'0321','msg'=>'只能驳回申请中的单子']);
  402. }
  403. $report = DB::table('report')->where('remote_application_id',$id)->field('id')->find();
  404. $info = array();
  405. $info['id'] = UUIDs::uuid16();
  406. $info['report_id'] = $report['id'];
  407. $info['description'] = $param['description'];
  408. $info['createdAt'] = date('Y-m-d H:i:s',time());
  409. $info['type'] = 4;
  410. $info['doctor_id'] = $doctor['id'];
  411. DB::table('report_record')->insert($info);
  412. $binfo = array();
  413. $binfo['id'] = UUIDs::uuid16();
  414. $binfo['initiator'] = $doctor['id'];
  415. // $info['reply'] = $param['reply']; // 回复人
  416. $binfo['remote_application_id'] = $id; //申请单id
  417. $binfo['content'] = '驳回原因:'.$param['description'];
  418. $binfo['createdAt'] = date('Y-m-d H:i:s',time());
  419. DB::table('bbs')->insert($binfo);
  420. // $message = array();
  421. // $message['id'] = UUIDs::uuid16();
  422. // $message['title'] = '申请单驳回';
  423. // $message['content'] = $param['description'];
  424. // $message['createdAt'] = date('Y-m-d H:i:s',time());
  425. $application = DB::table('remote_application')->where('id',$id)->find();
  426. // $message['doctor_id'] = $application['req_doctor_id'];
  427. // $message['institution_id'] = $application['local_institution_id'];
  428. DB::table('remote_application')->where('id',$id)->update(['report_status'=>5]);
  429. $dinfo = DB::table('doctors')->where('id',$application['req_doctor_id'])->find();
  430. $institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  431. // 驳回添加messages消息
  432. $t = '您的远程诊断申请被驳回';
  433. $c = '您的远程诊断申请,被'.$institution['name'].$doctor['realname'].'医师驳回。驳回理由:'.$param['description'];
  434. $d = $application['req_doctor_id'];
  435. $type = '2';
  436. $exam_class = DB::table('exams')->where('id',$re['exam_id'])->field('exam_class')->find();
  437. $url = Message::url($sessionid,$re['exam_id'],0,$exam_class['exam_class'],$report['id'],$id);
  438. Message::insert($t,$c,$d,$type,$url,1,$id);
  439. // 驳回发短信
  440. $d_phone = $dinfo['phone'];
  441. if($dinfo['institution_id'] == '22100002' || $dinfo['send_sms'] == 1){ //魏庙下级
  442. $des = mb_substr($param['description'],0,20,'utf-8');
  443. $repsone = send_message::sendSms2RejectApply($d_phone,$des);
  444. }
  445. $tel = '18910184804';
  446. $type = '驳回申请';
  447. $content = $application['id'];
  448. // send_message::sendSms2Self($tel,$type,$content);
  449. $tel = '18366391911';
  450. send_message::sendSms2Self($tel,$type,$content);
  451. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid]);
  452. }
  453. /**
  454. * 远程申请接收
  455. *
  456. * @ApiTitle (远程申请接收)
  457. * @ApiSummary (远程申请接收)
  458. * @ApiSector (远程诊断)
  459. * @ApiMethod (POST)
  460. * @ApiRoute (/inter/application/recive)
  461. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  462. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  463. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  464. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  465. * @ApiParams (name="id", type="string", required=true, sample="", description="参数json字符串,预约登记exams表id值<必填>")
  466. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  467. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  468. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  469. * @ApiReturn (data="
  470. {
  471. 'status': ok,
  472. 'code': '0000',
  473. 'sessionid': 'a17z7a7a8f9g9rh9d89jio'
  474. }
  475. *")
  476. **/
  477. public function recive(){
  478. $sessionid = $_REQUEST['sessionid'];
  479. $doctor = Cache::get($sessionid);
  480. $id = $_REQUEST['id'];
  481. $re = DB::table('remote_application')->where('id',$id)->field('report_status,req_doctor_id,exam_id')->find();
  482. if($re['report_status'] != 4){
  483. return json_encode(['status'=>'fail','code'=>'0321','msg'=>'只能接收申请中的单子']);
  484. }
  485. DB::table('remote_application')->where('id',$id)->update(['report_status'=>6]);
  486. $application = DB::table('remote_application')->where('exam_id',$id)->find();
  487. $tel = '18910184804';
  488. $type = '接收申请';
  489. $content = $application['id'];
  490. // send_message::sendSms2Self($tel,$type,$content);
  491. // 添加messages消息
  492. $t = '您的远程诊断申请被接收';
  493. $institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  494. $c = '您的远程诊断申请,被'.$institution['name'].$doctor['realname'].'医师接收';
  495. $d = $re['req_doctor_id'];
  496. $type = '4';
  497. $exam_class = DB::table('exams')->where('id',$re['exam_id'])->field('exam_class')->find();
  498. $report = DB::table('report')->where('exam_id',$re['exam_id'])->where('type',1)->field('id')->find();
  499. $url = Message::url($sessionid,$re['exam_id'],0,$exam_class['exam_class'],$report['id'],$id);
  500. Message::insert($t,$c,$d,$type,$url,1,$id);
  501. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid]);
  502. }
  503. /**
  504. * bbs通话保存
  505. *
  506. * @ApiTitle (bbs通话保存)
  507. * @ApiSummary (bbs通话保存)
  508. * @ApiSector (远程诊断)
  509. * @ApiMethod (POST)
  510. * @ApiRoute (/inter/application/bbs_save)
  511. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  512. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  513. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  514. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  515. * @ApiParams (name="param", type="string", required=true, sample="", description="参数json字符串,预约登记exams表id值<必填>")
  516. * @ApiParams (name="param[appid]", type="string", sample="", description="申请单id值<必填>")
  517. * @ApiParams (name="param[content]", type="string", sample="", description="留言内容<必填>")
  518. * @ApiParams (name="param[attachment]", type="string", sample="", description="上传图片<选填>")
  519. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  520. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  521. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  522. * @ApiReturn (data="
  523. {
  524. 'status': ok,
  525. 'code': '0000',
  526. 'sessionid': 'a17z7a7a8f9g9rh9d89jio',
  527. 'info' : ''
  528. }
  529. *")
  530. **/
  531. public function bbs_save(){
  532. $sessionid = $_REQUEST['sessionid'];
  533. $doctor = Cache::get($sessionid);
  534. $param = $_REQUEST['param'];
  535. if(empty($param['content'])){
  536. return json_encode(['status'=>'fail','msg'=>'内容为空,请填写要发送的内容','sessionid'=>$sessionid]);
  537. }
  538. $info = array();
  539. $info['id'] = UUIDs::uuid16();
  540. $info['initiator'] = $doctor['id'];
  541. $is_remote = $_REQUEST['is_remote'];
  542. $rinfo = DB::table('remote_application')->where('id',$param['appid'])->field('req_doctor_id,remote_doctor_id')->find();
  543. if($is_remote == 1){
  544. // 远程医生
  545. $info['reply'] = $rinfo['req_doctor_id']; //申请医生
  546. $remote = 0;
  547. }else{
  548. $info['reply'] = $rinfo['remote_doctor_id']; //申请的目标远程医生
  549. $remote = 1;
  550. }
  551. $info['remote_application_id'] = $param['appid']; //申请单id
  552. $info['content'] = $param['content'];
  553. $info['attachment'] = $param['attachment'];
  554. $info['createdAt'] = date('Y-m-d H:i:s',time());
  555. DB::table('bbs')->insert($info);
  556. // 添加message消息
  557. Message::bbs_message($param['appid'],$doctor['id'],$param['content'],$info['reply'],$remote,$sessionid);
  558. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid]);
  559. }
  560. public function getbbs(){
  561. $sessionid = $_REQUEST['sessionid'];
  562. $doctor = Cache::get($sessionid);
  563. $remote_id = $_REQUEST['application_id'];
  564. Message::read($doctor['id'],$remote_id,5);
  565. $info = DB::table('bbs')->where('remote_application_id',$remote_id)->order('createdAt desc')->select();
  566. foreach ($info as $k => $v) {
  567. $initiator = DB::table('doctors')->where('id',$v['initiator'])->field('realname')->find();
  568. $info[$k]['faqiren'] = $initiator['realname'];
  569. // $reply = DB::table('doctors')->where('id',$v['reply'])->field('realname')->find();
  570. // $info[$k]['huifuren'] = $reply['realname'];
  571. }
  572. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid,'info'=>$info]);
  573. }
  574. /**
  575. * 上传通话留言附件
  576. *
  577. * @ApiTitle (上传通话留言附件)
  578. * @ApiSummary (上传通话留言附件)
  579. * @ApiSector (远程诊断)
  580. * @ApiMethod (POST)
  581. * @ApiRoute (/inter/application/bbs_upload)
  582. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  583. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  584. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  585. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  586. * @ApiParams (name="file", type="string", required=true, description="上传的文件<必填>")
  587. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  588. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  589. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  590. * @ApiReturn (data="
  591. {
  592. 'status': ok,
  593. 'code': '0000',
  594. 'info' : '/upload/20180101/12346asd.jpg'
  595. }
  596. *")
  597. **/
  598. public function bbs_upload(){
  599. // 获取表单上传文件 例如上传了001.jpg
  600. $file = request()->file('file');
  601. log::record('----------上传的文件-----------');
  602. log::record($file);
  603. // 移动到框架应用根目录/public/uploads/ 目录下
  604. if($file){
  605. $info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
  606. log::record($info);
  607. if($info){
  608. return json_encode(['status'=>'ok','code'=>'0000','info'=>'/'.$_SERVER["SERVER_NAME"]. '/' . 'uploads'. '/' .$info->getSaveName()]);
  609. }else{
  610. // 上传失败获取错误信息
  611. echo $file->getError();
  612. }
  613. }
  614. }
  615. /**
  616. * 撤回
  617. *
  618. * @ApiTitle (撤回)
  619. * @ApiSummary (撤回)
  620. * @ApiSector (远程诊断)
  621. * @ApiMethod (POST)
  622. * @ApiRoute (/inter/application/revoke)
  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, sample="", description="参数json字符串,预约登记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="sessionid", type="object", sample="{}", description="缓存的数据key")
  631. * @ApiReturn (data="
  632. {
  633. 'status': ok,
  634. 'code': '0000',
  635. 'sessionid': 'a17z7a7a8f9g9rh9d89jio'
  636. }
  637. *")
  638. **/
  639. //
  640. public function revoke(){
  641. $sessionid = $_REQUEST['sessionid'];
  642. $doctor = Cache::get($sessionid);
  643. $id = $_REQUEST['id'];
  644. $status = DB::table('remote_application')->where('exam_id',$id)->field('id,report_status,remote_doctor_id')->find();
  645. if($status['report_status'] == 4){
  646. DB::table('remote_application')->where('exam_id',$id)->update(['report_status'=>12]);
  647. }else{
  648. return json_encode(['status'=>'ok','code'=>'0100','msg'=>'只能撤回申请中状态的申请单']);
  649. }
  650. $binfo = array();
  651. $binfo['id'] = UUIDs::uuid16();
  652. $binfo['initiator'] = $doctor['id'];
  653. // $info['reply'] = $param['reply']; // 回复人
  654. $binfo['remote_application_id'] = $status['id']; //申请单id
  655. $binfo['content'] = '已撤回了该申请';
  656. $binfo['createdAt'] = date('Y-m-d H:i:s',time());
  657. DB::table('bbs')->insert($binfo);
  658. //
  659. $t = '发起给您的远程诊断申请被撤回';
  660. $institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  661. $c = '您的远程诊断申请'.$institution['name'].$doctor['realname'].'医师撤回';
  662. $d = $status['remote_doctor_id'];
  663. $type = '3';
  664. $exam_class = DB::table('exams')->where('id',$id)->field('exam_class')->find();
  665. $report = DB::table('report')->where('remote_application_id',$status['id'])->field('id')->find();
  666. $url = Message::url($sessionid,$id,1,$exam_class['exam_class'],$report['id'],$status['id']);
  667. Message::insert($t,$c,$d,$type,$url,1,$status['id']);
  668. return json_encode(['status'=>'ok','code'=>'0000','msg'=>'撤回成功']);
  669. }
  670. public function bind_doctor()
  671. {
  672. try{
  673. $ra_id = $_REQUEST['ra_id'];
  674. $did = $_REQUEST['did'];
  675. $info = DB::table('remote_application')->where('id',$ra_id)->update(['remote_doctor_id'=>$did]);
  676. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info]);
  677. }catch(\Exception $e){
  678. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  679. }
  680. }
  681. //获取医生的接收和分配权限
  682. public function get_doctor_role()
  683. {
  684. try{
  685. $sessionid = $_REQUEST['sessionid'];
  686. $doctor = Cache::get($sessionid);
  687. $info = [];
  688. $info['is_admin'] = $doctor['is_admin'];
  689. $role = DB::table('doctor_class')->where('doctor_id',$doctor['id'])->value('doctor_class');
  690. if(strpos($role,'7') !== false){
  691. $info['is_doctor'] = 1;
  692. }else{
  693. $info['is_doctor'] = 0;
  694. }
  695. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info]);
  696. }catch(\Exception $e){
  697. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  698. }
  699. }
  700. }