Application.php 64 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153
  1. <?php
  2. namespace app\inter\controller;
  3. use think\Config;
  4. use think\Controller;
  5. use think\Db;
  6. use think\Session;
  7. use app\common\library\UUIDs;
  8. use think\Cache;
  9. use think\Log;
  10. use app\common\library\Verify;
  11. use think\File;
  12. use app\common\library\send_message;
  13. use app\common\library\Message;
  14. use app\inter\service\WechatService;
  15. class Application extends Base
  16. {
  17. /**
  18. * 发起远程申请
  19. *
  20. * @ApiTitle (发起远程申请)
  21. * @ApiSummary (发起远程申请)
  22. * @ApiSector (远程诊断)
  23. * @ApiMethod (POST)
  24. * @ApiRoute (/inter/application/index)
  25. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  26. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  27. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  28. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  29. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  30. * @ApiParams (name="is_remote", type="string", required=true, description="参数json字符串")
  31. * @ApiParams (name="param[id]", type="string", sample="", description="预约登记exams表id值<必填>")
  32. * @ApiParams (name="param[rid]", type="string", sample="", description="远程申请表id值<远程列表进入必填>")
  33. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  34. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  35. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  36. * @ApiReturnParams (name="is_remote", type="object", sample="{}", description="是否为远程诊断进入")
  37. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  38. * @ApiReturn (data="
  39. {
  40. 'status': ok,
  41. 'code': '0000',
  42. 'sessionid': 'a17z7a7a8f9g9rh9d89jio',
  43. 'is_remote': 1,
  44. 'info' : '',
  45. 'rid' : ''
  46. }
  47. *")
  48. **/
  49. public function index(){
  50. try{
  51. $sessionid = $_REQUEST['sessionid'];
  52. $param = $_REQUEST['param'];
  53. $id = $param['id'];
  54. $is_remote = 0;
  55. if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote']==1){
  56. $is_remote = 1;
  57. }
  58. $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();
  59. $exam_class = DB::table('constant')->where('id',$info['exam_class'])->field('constant_value')->find();
  60. $exam_subclass = DB::table('exam_subclass')->where('id',$info['exam_sub_class'])->cache(300)->find();
  61. $exam_project = DB::table('exam_project')->where('id',$info['exam_project'])->cache(300)->find();
  62. $device = DB::table('device')->where('id',$info['device'])->cache(300)->find();
  63. $info['exam_class_name'] = $exam_class['constant_value'];
  64. $info['exam_subclass_name'] = $exam_subclass['name'];
  65. $info['exam_project_name'] = $exam_project['name'];
  66. $info['device_name'] = $device['name'];
  67. $patient_info = DB::table('patient_infos')->where('id',$info['patient_id'])->field(['temp_patient_id','id','name','sex','age','birthday', 'phone'])->find();
  68. $info['pid'] = $patient_info['id'];
  69. $info['temp_patient_id'] = $patient_info['temp_patient_id'];
  70. $info['name'] = $patient_info['name'];
  71. $info['sex'] = $patient_info['sex'];
  72. $info['age'] = $patient_info['age'];
  73. $info['phone'] = $patient_info['phone'];
  74. if(!empty($patient_info['birthday'])){
  75. $info['birthday'] = $patient_info['birthday'];
  76. }
  77. $doctor = Cache::get($sessionid);
  78. $institution_id = $doctor['institution_id'];
  79. $hospital = DB::table('institution')->where('id',$institution_id)->find();
  80. $is_pay = $hospital['is_pay'];
  81. $parent_name = array();
  82. // 特殊机构
  83. $special_doctors = Db::table('special_contact')
  84. ->alias("sc")
  85. ->join('doctors d', 'sc.did = d.id')
  86. ->join('institution i', 'sc.hid = i.id')
  87. ->join('special_remote sr', 'sc.sid = sr.id')
  88. ->where('sr.status', 1)
  89. ->where('sc.status', 1)
  90. ->order('sr.sort asc')
  91. ->order('sc.sort asc')
  92. ->field('sc.hid, sc.did, sc.id, sc.cost, sc.describe, sr.id as sid, sr.name, sr.check, sr.color, d.realname as dname, i.name as hname')
  93. ->select();
  94. $super_hospitals = array();
  95. // 特殊机构
  96. if(!empty($special_doctors)) {
  97. $special_hospitals = array();
  98. foreach($special_doctors as $v) {
  99. if(!isset($super_hospitals[$v['sid']])){
  100. $super_hospitals[$v['sid']] = [
  101. "doctor" => [
  102. [
  103. "id" => $v['did'],
  104. "hid" => $v['hid'],
  105. "is_admin" => '0',
  106. "realname" => $v['dname'],
  107. "describe" => $v['describe'],
  108. "hname" => $v['hname'],
  109. "scid" => $v['id']
  110. ]
  111. ],
  112. "name" => $v['name'],
  113. "color" => $v['color'],
  114. "sid" => $v['sid'],
  115. "id" => $v['sid'],
  116. "check" => $v['check']
  117. ];
  118. } else {
  119. $super_hospitals[$v['sid']]['doctor'][] = [
  120. "id" => $v['did'],
  121. "hid" => $v['hid'],
  122. "is_admin" => '0',
  123. "realname" => $v['dname'],
  124. "describe" => $v['describe'],
  125. "hname" => $v['hname'],
  126. "scid" => $v['id']
  127. ];
  128. }
  129. }
  130. foreach($super_hospitals as $v) {
  131. $parent_name[] = $v;
  132. }
  133. }
  134. // select rc1.hospital_id, rc1.super_hospital_id, rc1.hospital_name, rc1.super_hospital_name, rc1.pay_type, rc2.super_doctor_id, rc2.super_doctor_name, rc2.exam_class from remote_contact rc1 join remote_cost rc2 on rc1.hospital_id = rc2.hospital_id and rc1.super_hospital_id = rc2.super_hospital_id where rc1.hospital_id = '13000003' and rc2.exam_class='CT' order by rc1.sort, rc2.sort
  135. if($is_pay === 1) {
  136. $super_hospitals = array();
  137. $super_doctors = DB::table("remote_contact")
  138. ->alias("rc1")
  139. ->join('remote_cost rc2', 'rc1.hospital_id = rc2.hospital_id and rc1.super_hospital_id = rc2.super_hospital_id')
  140. ->where('rc1.hospital_id', $institution_id)
  141. ->where('rc2.exam_class', $info['exam_class'])
  142. ->field('rc1.hospital_id, rc1.super_hospital_id, rc1.hospital_name, rc1.super_hospital_name, rc1.pay_type, rc2.super_doctor_id, rc2.super_doctor_name, rc2.exam_class, rc2.is_admin')
  143. // ->fetchSql()
  144. ->select();
  145. // var_dump($super_doctors);
  146. foreach($super_doctors as $v) {
  147. if(!isset($super_hospitals[$v['hospital_id']])){
  148. $super_hospitals[$v['hospital_id']] = [
  149. "doctor" => [
  150. [
  151. "id" => $v['super_doctor_id'],
  152. "is_admin" => $v['is_admin'],
  153. "realname" => $v['super_doctor_name']
  154. ]
  155. ],
  156. "id" => $v['super_hospital_id'],
  157. "name" => $v['super_hospital_name'],
  158. ];
  159. } else {
  160. $super_hospitals[$v['hospital_id']]['doctor'][] = [
  161. "id" => $v['super_doctor_id'],
  162. "is_admin" => $v['is_admin'],
  163. "realname" => $v['super_doctor_name']
  164. ];
  165. }
  166. }
  167. foreach($super_hospitals as $v) {
  168. $parent_name[] = $v;
  169. }
  170. } else {
  171. $parent_hosp = explode(',',$hospital['parent_institution']);
  172. foreach($parent_hosp as $v){
  173. $phname = DB::table("institution")->where('id',$v)->cache(300)->field(['id','name'])->find();
  174. log::record('上级医院----'.json_encode($phname));
  175. if(!isset($phname['id']) || empty($phname['id'])){
  176. $phname['id'] = $v;
  177. }
  178. $doctor_info = DB::table('doctors')->where('institution_id',$v)->field('id,realname,is_admin')->order('is_admin desc')->select();
  179. foreach($doctor_info as $key=>$value){
  180. if($value['is_admin'] == 1){
  181. $doctor_info[$key]['realname'] = $value['realname'].'---医院管理员';
  182. }
  183. }
  184. $phname['doctor'] = $doctor_info;
  185. $parent_name[] =$phname;
  186. }
  187. }
  188. $info['parent_hospital'] = $parent_name;
  189. //申请信息
  190. if(isset($param['rid']) && !empty($param['rid'])){
  191. $rid = $param['rid'];
  192. $application = DB::table('remote_application')->where('id',$rid)->field(['id,remote_institution_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();
  193. $aid = $application['id'];
  194. }else{
  195. $rid = '';
  196. $application = DB::table('remote_application')->where('exam_id',$id)->field(['id,remote_institution_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();
  197. $aid = $application['id'];
  198. }
  199. $remote_order = DB::table('remote_order')
  200. ->where('application_id', $application['id'])
  201. ->where('status', 'neq', Config::get('ORDER_STATUS')['CANCEL'])
  202. ->where('status', 'neq', Config::get('ORDER_STATUS')['REDUCE'])
  203. ->field('id, status, exam_class, super_hospital_id, super_doctor_id')
  204. ->find();
  205. if($remote_order) {
  206. $info['remote_order'] = $remote_order;
  207. }
  208. if($is_remote == 1){
  209. Message::read($doctor['id'],$aid,1);
  210. //远程申请点击进入
  211. $dinfo = DB::table('doctors')->where('id',$application['req_doctor_id'])->field('department_id')->find();
  212. $dep = DB::table('department')->where('id',$dinfo['department_id'])->field('department_name')->find();
  213. }else{
  214. Message::read($doctor['id'],$aid,2);
  215. //本地远程申请中
  216. $dep = DB::table('department')->where('id',$doctor['department_id'])->field('department_name')->find();
  217. }
  218. $info['department_name'] = $dep['department_name'];
  219. if(empty($application)){
  220. $exam_application = DB::table('exams')->where('id',$id)->field(['illness_desc','phys_sign','clin_symp','remark','clin_diag','anamnesis','family_ill'])->find();
  221. if(empty($exam_application['anamnesis'])){
  222. $exam_application['anamnesis'] = '';
  223. }else{
  224. $exam_application['anamnesis'] = explode(',',$exam_application['anamnesis']);
  225. }
  226. if(empty($exam_application['family_ill'])){
  227. $exam_application['family_ill'] = '';
  228. }else{
  229. $exam_application['family_ill'] = explode(',',$exam_application['family_ill']);
  230. }
  231. $exam_application['report_status'] = '';
  232. $exam_application['remark'] = '';
  233. $exam_application['remote_institution'] =
  234. $info['application'] = $exam_application;
  235. }else{
  236. $remote_name = DB::table('doctors')->where('id',$application['remote_doctor_id'])->field('realname')->find();
  237. $remote_institution = DB::table('institution')->where('id',$application['remote_institution_id'])->value('name');
  238. $application['remote_institution'] = $remote_institution;
  239. $application['remote_doctor'] = $remote_name['realname'];
  240. if(empty($application['anamnesis'])){
  241. $application['anamnesis'] = '';
  242. }else{
  243. $application['anamnesis'] = explode(',',$application['anamnesis']);
  244. }
  245. if(empty($application['family_ill'])){
  246. $application['family_ill'] = '';
  247. }else{
  248. $application['family_ill'] = explode(',',$application['family_ill']);
  249. }
  250. $info['application'] = $application;
  251. }
  252. $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();
  253. $info['unread_message_num'] = $count['count'];
  254. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid,'is_remote'=>$is_remote,'rid'=>$aid]);
  255. }catch(\Exception $e){
  256. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  257. }
  258. }
  259. /**取消订单 */
  260. public function cancel(WechatService $wechatService){
  261. try{
  262. log::record($_REQUEST);
  263. $sessionid = $_REQUEST['sessionid'];
  264. $doctor = Cache::get($sessionid);
  265. // 远程申请权限 6
  266. $return = Verify::check_role($sessionid, 6);
  267. if($return != 1){
  268. return json_encode(['status'=>'fail','code'=>'1029','msg'=>'没有操作权限']);
  269. }
  270. $param = $_REQUEST['param'];
  271. $order_id = $param['order_id'];
  272. $remote_order = DB::table('remote_order')->where('id', $order_id)->field('application_id, hospital_id, doctor_id, status, pay_type, order_money')->find();
  273. if(!$remote_order) {
  274. return json_encode(['status'=>'fail','code'=>'2101','msg'=> '没有找到该订单']);
  275. }
  276. if(!($remote_order['status'] === Config::get('ORDER_STATUS')['CREATE'] || $remote_order['status'] === Config::get('ORDER_STATUS')['PAYCOMPLTET'])) {
  277. return json_encode(['status'=>'fail','code'=>'2102','msg'=> '订单状态不可取消']);
  278. }
  279. $application = DB::table('remote_application')->where('id', $remote_order['application_id'])->field('report_status, exam_id')->find();
  280. if(!$application) {
  281. return json_encode(['status'=>'fail','code'=>'2103','msg'=> '没有找到远程诊断申请单']);
  282. }
  283. if(!($application['report_status'] === '5' || $application['report_status'] === '12')) {
  284. return json_encode(['status'=>'fail','code'=>'2103','msg'=> '进行中的远程诊断订单不可取消']);
  285. }
  286. // 微信消息推送
  287. // $wechatService->pushWechatCancel($application['exam_id']);
  288. $wechatService->pushWechatCancel($order_id);
  289. if($remote_order['pay_type'] === Config::get('PAY_TYPE')['HOSPITAL']) {
  290. return $this->cancelHospitalOrder($order_id, $remote_order['hospital_id'], $remote_order['order_money']);
  291. }
  292. if($remote_order['pay_type'] === Config::get('PAY_TYPE')['PATIENT']) {
  293. return $this->cancelPatientsOrder($order_id, $remote_order['application_id']);
  294. }
  295. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid]);
  296. }catch(\Exception $e){
  297. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  298. }
  299. }
  300. /**
  301. * 提交申请
  302. *
  303. * @ApiTitle (提交申请)
  304. * @ApiSummary (提交申请)
  305. * @ApiSector (远程诊断)
  306. * @ApiMethod (POST)
  307. * @ApiRoute (/inter/application/apply)
  308. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  309. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  310. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  311. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  312. * @ApiParams (name="param", type="string", required=true, description="参数json字符串")
  313. * @ApiParams (name="param[id]", type="string", sample="", description="预约登记exams表id值<必填>")
  314. * @ApiParams (name="param[illness]", type="string", sample="", description="主诉<选填>")
  315. * @ApiParams (name="param[clin_symp]", type="string", sample="", description="临床症状<选填>")
  316. * @ApiParams (name="param[anamnesis]", type="string", sample="", description="既往史<选填>")
  317. * @ApiParams (name="param[family_ill]", type="string", sample="", description="家族史<选填>")
  318. * @ApiParams (name="param[remark]", type="string", sample="", description="备注<选填>")
  319. * @ApiParams (name="param[institution_id]", type="string", sample="", description="发起申请医院id值<选填>")
  320. * @ApiParams (name="param[clin_diag]", type="string", sample="", description="临床诊断<选填>")
  321. * @ApiParams (name="param[remote_institution]", type="string", sample="", description="申请的目标医院id值<选填>")
  322. * @ApiParams (name="param[is_urgent]", type="string", sample="", description="是否急诊 0否 1是<选填>")
  323. * @ApiParams (name="param[description]", type="string", sample="", description="申请描述<选填>")
  324. * @ApiParams (name="param[remote_doctor_id]", type="string", sample="", description="申请的目标医生id值<选填>")
  325. * @ApiParams (name="param[attachment]", type="string", sample="", description="附件<选填>")
  326. * @ApiParams (name="param[apply]", type="string", sample="", description="保存或者申请 存在值即保存 不存在则为申请<必填>")
  327. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  328. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  329. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  330. * @ApiReturn (data="
  331. {
  332. 'status': ok,
  333. 'code': '0000',
  334. 'sessionid': 'a17z7a7a8f9g9rh9d89jio'
  335. }
  336. *")
  337. **/
  338. public function apply(WechatService $wechatService){
  339. try{
  340. // var_dump(1);
  341. // var_dump($wechatService);
  342. log::record($_REQUEST);
  343. $sessionid = $_REQUEST['sessionid'];
  344. $doctor = Cache::get($sessionid);
  345. // 远程申请权限 6
  346. $return = Verify::check_role($sessionid,6);
  347. if($return != 1){
  348. return json_encode(['status'=>'fail','code'=>'1029','msg'=>'没有操作权限']);
  349. }
  350. $param = $_REQUEST['param'];
  351. $application_info = array();
  352. $application_info['remote_institution_id'] = isset($param['remote_institution']) ? $param['remote_institution'] : '';
  353. if(isset($param['remote_doctor_id']) && !empty($param['remote_doctor_id']) && empty($application_info['remote_doctor_id'])){
  354. $remote_doctor = DB::table('doctors')->where('id',$param['remote_doctor_id'])->find();
  355. $application_info['remote_institution_id'] = $remote_doctor['institution_id'];
  356. }
  357. if(empty($application_info['remote_institution_id'])){
  358. return json_encode(['status'=>'fail','code'=>'3029','msg'=>'没有选择远程机构']);
  359. }
  360. $exam_info = DB::table('exams')->where('id',$param['id'])->field('exam_class,exam_status,patient_id')->find();
  361. // 修改病人姓名
  362. DB::table('patient_infos')->where('id',$exam_info['patient_id'])->update(['name'=>$param['name'], 'phone'=> $param['phone']]??'');
  363. if($exam_info['exam_status'] != 3 && $exam_info['exam_status'] != 5 && $exam_info['exam_status'] != 8){
  364. // 3 检查完毕 5已驳回
  365. switch($exam_info['exam_status']){
  366. case 1:
  367. $msg = '患者还未检查,请检查完毕后再进行远程申请';
  368. return json_encode(['status'=>'fail','code'=>'1029','msg'=>$msg]);
  369. break;
  370. case 2:
  371. $msg = '影像未到达,不能发起远程申请';
  372. return json_encode(['status'=>'fail','code'=>'1029','msg'=>$msg]);
  373. break;
  374. }
  375. }
  376. Verify::applicationCheck($param);
  377. $where = array();
  378. // 申请医生
  379. $where['req_doctor_id'] = $doctor['id'];
  380. $where['remote_institution_id'] = $application_info['remote_institution_id'];
  381. // 只允许有一个申请 ----------------------------- 暂时添加
  382. $r = DB::table('remote_application')->where('exam_id',$param['id'])->where('report_status','not in',',5,12')->find();
  383. if($r){
  384. return json_encode(['status'=>'fail','code'=>'1120','msg'=>'每个医院同一个检查只能申请一次']);
  385. }
  386. //不等于9 代表
  387. $a_info = DB::table('remote_application')->where($where)->where('exam_id',$param['id'])->where('report_status','not in',',12,5,9')->find();
  388. if($a_info){
  389. return json_encode(['status'=>'fail','code'=>'1120','msg'=>'该申请目标医院存在未完成报告,只有报告完成后才能再次发起申请']);
  390. }
  391. $application_info['exam_id'] = isset($param['id']) ? $param['id'] : '';
  392. $application_info['illness_desc'] = isset($param['illness']) ? $param['illness'] : '';
  393. $application_info['phys_sign'] = isset($param['phys_sign']) ? $param['phys_sign'] : '';
  394. $application_info['clin_symp'] = isset($param['clin_symp']) ? $param['clin_symp'] : '';
  395. if(!empty($param['anamnesis'])){
  396. $application_info['anamnesis'] = implode(',',$param['anamnesis']);
  397. }
  398. if(!empty($param['family_ill'])){
  399. $application_info['family_ill'] = implode(',',$param['family_ill']);
  400. }
  401. $application_info['remark'] = isset($param['remark']) ? $param['remark'] : '';
  402. $application_info['local_institution_id'] = $doctor['institution_id'];
  403. $application_info['req_date_time'] = date('Y-m-d H:i:s',time());
  404. $application_info['clin_diag'] = isset($param['clin_diag']) ? $param['clin_diag'] : '';
  405. if(isset($param['is_urgent']) && $param['is_urgent'] == 'true' ){
  406. $application_info['is_urgent'] = 1;
  407. $remote_doctor_id = '';
  408. $d_time = date('H:i',strtotime('+30 min'));
  409. }else{
  410. $application_info['is_urgent'] = 0;
  411. $remote_doctor_id = isset($param['remote_doctor_id']) ? $param['remote_doctor_id'] : '';
  412. $d_time = date('H:i',strtotime('+1 hour'));
  413. if($remote_doctor_id === '') {
  414. $manager = DB::table('doctors')->where('institution_id',$application_info['remote_institution_id'])->where('is_admin', '1')->field('id')->find();
  415. if(!empty($manager)) {
  416. $remote_doctor_id = $manager['id'];
  417. }
  418. }
  419. }
  420. $application_info['application_desc'] = isset($param['description']) ? $param['description'] : '';
  421. $application_info['req_doctor_id'] = $doctor['id'];
  422. $application_info['phone'] = $param['phone']?? '';
  423. $application_info['remote_doctor_id'] = $remote_doctor_id;
  424. $application_info['attachment'] = isset($param['attachment']) ? $param['attachment'] : '';
  425. $application_info['sid'] = isset($param['sid']) && !empty($param['sid']) ? $param['sid'] : null;
  426. $application_info['scid'] = isset($param['scid']) && !empty($param['scid']) ? $param['scid'] : null;
  427. // $remote_application = DB::table('remote_application')->where('exam_id',$param['id'])->select();
  428. // 申请远程
  429. // if(empty($remote_application)){
  430. log::record('新增远程申请');
  431. $re = DB::table('remote_application')->where('exam_id',$param['id'])->find();
  432. $report = array();
  433. if($re){
  434. // 存在被驳回申请 再次申请时则为驳回后发起的申请
  435. DB::table('remote_application')->where('exam_id',$param['id'])->update($application_info);
  436. $app_id = $re['id'];
  437. }else{
  438. $application_info['id'] = UUIDs::uuid16();
  439. $application_info['createdAt'] = date('Y-m-d H:i:s',time());
  440. DB::table('remote_application')->insert($application_info);
  441. $app_id = $application_info['id'];
  442. }
  443. $aid = $app_id;
  444. $r_info = DB::table('report')->where('exam_id',$param['id'])->where('remote_application_id', $aid)->find();
  445. if(empty($r_info)){
  446. $report['id'] = UUIDs::uuid16();
  447. $report['exam_id'] = $param['id'];
  448. $report['remote_application_id'] = $aid;
  449. $report['type'] = 2;
  450. DB::table('report')->insert($report);
  451. $r_id = $report['id'];
  452. }else{
  453. $r_id = $r_info['id'];
  454. }
  455. // }else{
  456. // log::record('修改远程申请');
  457. // DB::table('remote_application')->where('exam_id',$param['id'])->update($application_info);
  458. // $r = DB::table('remote_application')->where('exam_id',$param['id'])->field('id')->find();
  459. // $aid = $r['id'];
  460. // }
  461. if(isset($param['apply']) && !empty($param['apply'])){
  462. $institution_id = $doctor['institution_id'];
  463. $lower_hospital = DB::table('institution')->where('id', $institution_id)->field('is_pay')->find();
  464. $is_pay = $lower_hospital['is_pay'];
  465. $application = DB::table('remote_application')->where('exam_id', $param['id'])->field('id, sid, scid, remote_institution_id, remote_doctor_id, local_institution_id, req_doctor_id, is_urgent')->find();
  466. if(empty($application)) {
  467. return json_encode(['status'=>'fail','code'=>'2011','msg'=> '申请单创建失败']);
  468. }
  469. $remote_institution_id = $application['remote_institution_id'];
  470. $remote_doctor_id = $application['remote_doctor_id'];
  471. $is_urgent = $application['is_urgent'];
  472. $local_institution_id = $application['local_institution_id'];
  473. $req_doctor_id = $application['req_doctor_id'];
  474. $sid = $application['sid'];
  475. $scid = $application['scid'];
  476. if(empty($remote_institution_id)) {
  477. return json_encode(['status'=>'fail','code'=>'2012','msg'=> '远程机构id为空']);
  478. }
  479. // if(empty($remote_doctor_id)) {
  480. // return json_encode(['status'=>'fail','code'=>'2013','msg'=> '远程医生id为空']);
  481. // }
  482. if(empty($local_institution_id)) {
  483. return json_encode(['status'=>'fail','code'=>'2014','msg'=> '本地机构id为空']);
  484. }
  485. if(empty($req_doctor_id)) {
  486. return json_encode(['status'=>'fail','code'=>'2015','msg'=> '本地医生id为空']);
  487. }
  488. if(!empty($sid) && empty($scid)) {
  489. return json_encode(['status'=>'fail','code'=>'2016','msg'=> '请选择问诊医生']);
  490. }
  491. if($is_pay === 1 && empty($sid)) {
  492. $cost = DB::table('remote_cost')
  493. ->where('hospital_id', $local_institution_id)
  494. ->where('super_hospital_id', $remote_institution_id)
  495. ->where('super_doctor_id', $remote_doctor_id)
  496. ->where('exam_class', $exam_info['exam_class'])
  497. ->field('money')
  498. ->find();
  499. if(!$cost) {
  500. return json_encode(['status'=>'ok','code'=>'2016','msg'=> '远程医生获取失败']);
  501. }
  502. if($cost['money'] !== 0) {
  503. $contact = DB::table('remote_contact')
  504. ->where('hospital_id', $local_institution_id)
  505. ->where('super_hospital_id', $remote_institution_id)
  506. ->field('pay_type')
  507. ->find();
  508. if(!$contact) {
  509. return json_encode(['status'=>'ok','code'=>'2017','msg'=> '远程机构获取失败']);
  510. }
  511. $res = false;
  512. if($contact['pay_type'] === Config::get('PAY_TYPE')['HOSPITAL']) { //医院挂账
  513. // $hospital_id, $super_hospital_id, $doctor_id, $super_doctor_id, $exam_class, $application_id, $order_money
  514. $res = $this->createHospitalOrder($local_institution_id, $remote_institution_id, $req_doctor_id, $remote_doctor_id, $exam_info['exam_class'], $application['id'], $cost['money'], $is_urgent, $wechatService);
  515. }
  516. if($contact['pay_type'] === Config::get('PAY_TYPE')['PATIENT']) { // 患者支付
  517. // var_dump(2);
  518. // var_dump($wechatService);
  519. // $push_res = WechatService::pushWechatOrder($param['id']);
  520. // $wechatService->pushWechatOrder($param['id']);
  521. $res = $this->createPatientsOrder($local_institution_id, $remote_institution_id, $req_doctor_id, $remote_doctor_id, $exam_info['exam_class'], $application['id'], $cost['money'], $is_urgent, $wechatService);
  522. return json_encode(['status'=>'ok','code'=>'0000']);
  523. }
  524. if($res === true) {
  525. return ['status'=>'ok','code'=>'0000'];
  526. }
  527. return $res;
  528. }
  529. } else {
  530. DB::table('remote_order')->insert([
  531. 'id' => UUIDs::uuid16(),
  532. 'hospital_id' => $local_institution_id,
  533. 'super_hospital_id' => $remote_institution_id,
  534. 'exam_class' => $exam_info['exam_class'],
  535. 'doctor_id' => $req_doctor_id,
  536. 'application_id' => $application['id'],
  537. 'super_doctor_id' => $remote_doctor_id,
  538. 'is_urgent' => $is_urgent,
  539. 'status' => Config::get('ORDER_STATUS')['PAYCOMPLTET'],
  540. 'order_money' => 0,
  541. 'pay_type' => Config::get('PAY_TYPE')['HOSPITAL'],
  542. 'pay_way' => Config::get('PAY_WAY')['HOSPITAL'],
  543. 'timestamp' => time()
  544. ]);
  545. DB::table('remote_application')->where('exam_id',$param['id'])->update(['report_status'=>4]);
  546. }
  547. // 添加messages信息
  548. // $wechatService->pushWechatOrder($param['id']);
  549. $t = '收到一条远程诊断申请';
  550. $ins = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  551. $c = $ins['name'].$doctor['realname'].'医师向您发起一条远程诊断申请';
  552. $d = $application_info['remote_doctor_id'];
  553. $type = '1';
  554. $url = Message::url($sessionid,$param['id'],1,$exam_info['exam_class'],$r_id,$aid);
  555. Message::insert($t,$c,$d,$type,$url,1,$aid);
  556. //保存 申请
  557. // 发送通知短信
  558. $this->sendApplySms($d_time, $application_info['remote_doctor_id'], $application_info['remote_institution_id']);
  559. // $dinfo = DB::table('doctors')->where('id',$application_info['remote_doctor_id'])->find();
  560. // $d_phone = $dinfo['phone'];
  561. // $d_name = $dinfo['realname'];
  562. // if($dinfo['institution_id'] == '22100003' || $dinfo['send_sms'] == 1){ //魏庙
  563. // $repsone = send_message::sendSms2Apply($d_phone,$d_time,$d_name);
  564. // }
  565. // $tel = '18910184804';
  566. // $type = '发起申请';
  567. // $content = $aid;
  568. // $response = send_message::sendSms2Self($tel,$type,$content);
  569. }
  570. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid,'aid'=>$aid]);
  571. }catch(\Exception $e){
  572. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  573. }
  574. }
  575. /**
  576. * @param d_time 时间
  577. * @param d_id 医生id
  578. * @param i_id 机构id
  579. */
  580. private function sendApplySms($d_time, $d_id, $i_id) {
  581. $dinfo = false;
  582. if(!empty($d_id)) {
  583. $dinfo = DB::table('doctors')->where('id', $d_id)->find();
  584. }
  585. if($dinfo) {
  586. if($dinfo['institution_id'] == '22100003' || $dinfo['send_sms'] == 1){ //魏庙
  587. $repsone = send_message::sendSms2Apply($dinfo['phone'], $d_time, $dinfo['realname']);
  588. }
  589. return;
  590. }
  591. // 查找医院管理员并发送短信
  592. $admins = DB::table('doctors')->where('institution_id', $i_id)->where('is_admin', '1')->where('send_sms', '1')->select();
  593. foreach($admins as $key=>$value){
  594. $repsone = send_message::sendSms2Apply($value['phone'], $d_time, $value['realname']);
  595. }
  596. }
  597. private function createHospitalOrder($hospital_id, $super_hospital_id, $doctor_id, $super_doctor_id, $exam_class, $application_id, $order_money, $is_urgent = 0, $wechatService) {
  598. DB::startTrans();
  599. $pay_type = Config::get('PAY_TYPE')['HOSPITAL'];
  600. $pay_way = Config::get('PAY_TYPE')['HOSPITAL'];
  601. $water_type = Config::get('WATER_TYPE')['REDUCE'];
  602. $water_why = Config::get('WATER_WHY')['REMOTEPAY'];
  603. try{
  604. $remote_order = DB::table('remote_order')
  605. ->where('application_id', $application_id)
  606. ->where('status', 'neq', Config::get('ORDER_STATUS')['CANCEL'])
  607. ->where('status', 'neq', Config::get('ORDER_STATUS')['REDUCE'])
  608. ->field('id')
  609. ->find();
  610. DB::table('remote_application')->where('id',$application_id)->update(['report_status'=>4]);
  611. if($remote_order) {
  612. DB::commit();
  613. // return true;
  614. // DB::rollback();
  615. return json_encode(['status'=>'fail','code'=>'2019','msg' => '已存在订单,请勿重复发起']);
  616. }
  617. $hospital = DB::table('institution')
  618. ->where('id', $hospital_id)
  619. ->field('min_money, current_money')
  620. ->find();
  621. if(!$hospital) {
  622. DB::rollback();
  623. return json_encode(['status'=>'fail','code'=>'2017','msg' => '查找本地医院失败']);
  624. }
  625. $min_money = $hospital['min_money'];
  626. $current_money = $hospital['current_money'];
  627. if($current_money - $order_money < $min_money) {
  628. DB::rollback();
  629. return json_encode(['status'=>'fail','code'=>'2017','msg' => '余额不足请联系医院管理员充值']);
  630. }
  631. DB::table('institution')->where('id',$hospital_id)->update(['current_money'=> $current_money - $order_money]);
  632. $order_id = UUIDs::uuid16();
  633. DB::table('remote_order')->insert([
  634. 'id' => $order_id,
  635. 'hospital_id' => $hospital_id,
  636. 'super_hospital_id' => $super_hospital_id,
  637. 'exam_class' => $exam_class,
  638. 'doctor_id' => $doctor_id,
  639. 'is_urgent' => $is_urgent,
  640. 'application_id' => $application_id,
  641. 'super_doctor_id' => $super_doctor_id,
  642. 'order_money' => $order_money,
  643. 'pay_type' => $pay_type,
  644. 'pay_way' => $pay_way,
  645. 'timestamp' => time(),
  646. ]);
  647. DB::table('remote_water')->insert([
  648. 'id' => UUIDs::uuid16(),
  649. 'hospital_id' => $hospital_id,
  650. 'order_id' => $order_id,
  651. 'money' => $order_money,
  652. 'type' => $water_type,
  653. 'why' => $water_why,
  654. 'timestamp' => time(),
  655. ]);
  656. // 提交事务
  657. DB::commit();
  658. $wechatService->pushWechatOrder($order_id);
  659. return true;
  660. } catch (\Exception $e) {
  661. // 回滚事务
  662. DB::rollback();
  663. }
  664. return json_encode(['status'=>'fail','code'=>'2018','msg' => '远程诊断发起失败']);
  665. }
  666. private function createPatientsOrder($hospital_id, $super_hospital_id, $doctor_id, $super_doctor_id, $exam_class, $application_id, $order_money, $is_urgent = 0, $wechatService) {
  667. $pay_type = Config::get('PAY_TYPE')['PATIENT'];
  668. $pay_way = Config::get('PAY_WAY')['WECHAT'];
  669. DB::startTrans();
  670. try{
  671. $remote_order = DB::table('remote_order')
  672. ->where('application_id', $application_id)
  673. ->where('status', 'neq', Config::get('ORDER_STATUS')['CANCEL'])
  674. ->where('status', 'neq', Config::get('ORDER_STATUS')['REDUCE'])
  675. ->field('id')
  676. ->find();
  677. DB::table('remote_application')->where('id',$application_id)->update(['report_status'=>4]);
  678. if($remote_order) {
  679. DB::commit();
  680. // return json_encode(['status'=>'ok','code'=>'0000','oid'=>$remote_order['id'],'aid'=>$application_id]);
  681. // DB::rollback();
  682. return json_encode(['status'=>'fail','code'=>'2019','msg' => '已存在订单,请勿重复发起']);
  683. }
  684. $order_id = UUIDs::uuid16();
  685. DB::table('remote_order')->insert([
  686. 'id' => $order_id,
  687. 'hospital_id' => $hospital_id,
  688. 'super_hospital_id' => $super_hospital_id,
  689. 'exam_class' => $exam_class,
  690. 'doctor_id' => $doctor_id,
  691. 'application_id' => $application_id,
  692. 'super_doctor_id' => $super_doctor_id,
  693. 'is_urgent' => $is_urgent,
  694. 'order_money' => $order_money,
  695. 'pay_type' => $pay_type,
  696. 'pay_way' => $pay_way,
  697. 'timestamp' => time(),
  698. 'status' => Config::get('ORDER_STATUS')['CREATE']
  699. ]);
  700. DB::commit();
  701. $wechatService->pushWechatOrder($order_id);
  702. return true;
  703. } catch (\Exception $e) {
  704. var_dump($e);
  705. DB::rollback();
  706. }
  707. return json_encode(['status'=>'fail','code'=>'2020','msg' => '远程诊断发起失败']);
  708. }
  709. private function cancelHospitalOrder($order_id, $hospital_id, $order_money) {
  710. DB::startTrans();
  711. $water_type = Config::get('WATER_TYPE')['ADD'];
  712. $water_why = Config::get('WATER_WHY')['REFUNDINCOME'];
  713. try{
  714. DB::table('remote_order')->where('id', $order_id)->update(["status" => Config::get('ORDER_STATUS')["REDUCE"]]);
  715. $hospital = DB::table('institution')
  716. ->where('id', $hospital_id)
  717. ->field('current_money')
  718. ->find();
  719. $current_money = $hospital['current_money'];
  720. DB::table('institution')->where('id',$hospital_id)->update(['current_money'=> $current_money + $order_money]);
  721. DB::table('remote_water')->insert([
  722. 'id' => UUIDs::uuid16(),
  723. 'hospital_id' => $hospital_id,
  724. 'order_id' => $order_id,
  725. 'money' => $order_money,
  726. 'type' => $water_type,
  727. 'why' => $water_why,
  728. 'timestamp' => time(),
  729. ]);
  730. // 提交事务
  731. DB::commit();
  732. // todo 消息推送
  733. return json_encode(['status'=>'ok','code'=>'0000']);
  734. } catch (\Exception $e) {
  735. // 回滚事务
  736. DB::rollback();
  737. }
  738. return json_encode(['status'=>'fail','code'=>'2018','msg' => '取消订单失败']);
  739. }
  740. private function cancelPatientsOrder($order_id) {
  741. try{
  742. DB::table('remote_order')->where('id', $order_id)->update(["status" => Config::get('ORDER_STATUS')["CANCEL"]]);
  743. // todo 消息推送
  744. return json_encode(['status'=>'ok','code'=>'0000']);
  745. } catch (\Exception $e) {
  746. var_dump($e);
  747. }
  748. return json_encode(['status'=>'fail','code'=>'2109','msg' => '订单取消失败']);
  749. }
  750. /**
  751. * 上传附件
  752. *
  753. * @ApiTitle (上传附件)
  754. * @ApiSummary (上传附件)
  755. * @ApiSector (远程诊断)
  756. * @ApiMethod (POST)
  757. * @ApiRoute (/inter/application/upload)
  758. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  759. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  760. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  761. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  762. * @ApiParams (name="file", type="string", required=true, description="上传的文件<必填>")
  763. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  764. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  765. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  766. * @ApiReturn (data="
  767. {
  768. 'status': ok,
  769. 'code': '0000',
  770. 'info' : '/upload/20180101/12346asd.jpg'
  771. }
  772. *")
  773. **/
  774. //上传附件
  775. public function upload(){
  776. // 获取表单上传文件 例如上传了001.jpg
  777. $file = request()->file('file');
  778. log::record('----------上传的文件-----------');
  779. log::record($file);
  780. // 移动到框架应用根目录/public/uploads/ 目录下
  781. if($file){
  782. $info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
  783. log::record($info);
  784. if($info){
  785. return json_encode(['status'=>'ok','code'=>'0000','info'=>'/'.$_SERVER["SERVER_NAME"]. '/' . 'uploads'. '/' .$info->getSaveName()]);
  786. }else{
  787. // 上传失败获取错误信息
  788. return json_encode(['status'=>'fail','code'=>'1040','info'=>$file->getError()]);
  789. }
  790. }
  791. }
  792. /**
  793. * 远程申请驳回
  794. *
  795. * @ApiTitle (远程申请驳回)
  796. * @ApiSummary (远程申请驳回)
  797. * @ApiSector (远程诊断)
  798. * @ApiMethod (POST)
  799. * @ApiRoute (/inter/application/reject)
  800. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  801. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  802. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  803. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  804. * @ApiParams (name="param", type="string", required=true, sample="", description="参数json字符串,预约登记exams表id值<必填>")
  805. * @ApiParams (name="param[id]", type="string", sample="", description="预约登记exams表id值<必填>")
  806. * @ApiParams (name="param[description]", type="string", sample="", description="驳回原因<必填>")
  807. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  808. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  809. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  810. * @ApiReturn (data="
  811. {
  812. 'status': ok,
  813. 'code': '0000',
  814. 'sessionid': 'a17z7a7a8f9g9rh9d89jio'
  815. }
  816. *")
  817. **/
  818. //驳回 7
  819. public function reject(){
  820. $sessionid = $_REQUEST['sessionid'];
  821. $doctor = Cache::get($sessionid);
  822. $param = $_REQUEST['param'];
  823. $id = $param['id'];
  824. $re = DB::table('remote_application')->where('id',$id)->field('exam_id,report_status')->find();
  825. if($re['report_status'] != 4){
  826. return json_encode(['status'=>'fail','code'=>'0321','msg'=>'只能驳回申请中的单子']);
  827. }
  828. $report = DB::table('report')->where('remote_application_id',$id)->field('id')->find();
  829. $info = array();
  830. $info['id'] = UUIDs::uuid16();
  831. $info['report_id'] = $report['id'];
  832. $info['description'] = $param['description'];
  833. $info['createdAt'] = date('Y-m-d H:i:s',time());
  834. $info['type'] = 4;
  835. $info['doctor_id'] = $doctor['id'];
  836. DB::table('report_record')->insert($info);
  837. $binfo = array();
  838. $binfo['id'] = UUIDs::uuid16();
  839. $binfo['initiator'] = $doctor['id'];
  840. // $info['reply'] = $param['reply']; // 回复人
  841. $binfo['remote_application_id'] = $id; //申请单id
  842. $binfo['content'] = '驳回原因:'.$param['description'];
  843. $binfo['createdAt'] = date('Y-m-d H:i:s',time());
  844. DB::table('bbs')->insert($binfo);
  845. // $message = array();
  846. // $message['id'] = UUIDs::uuid16();
  847. // $message['title'] = '申请单驳回';
  848. // $message['content'] = $param['description'];
  849. // $message['createdAt'] = date('Y-m-d H:i:s',time());
  850. $application = DB::table('remote_application')->where('id',$id)->find();
  851. // $message['doctor_id'] = $application['req_doctor_id'];
  852. // $message['institution_id'] = $application['local_institution_id'];
  853. DB::table('remote_application')->where('id',$id)->update(['report_status'=>5]);
  854. $dinfo = DB::table('doctors')->where('id',$application['req_doctor_id'])->find();
  855. $institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  856. // 驳回添加messages消息
  857. $t = '您的远程诊断申请被驳回';
  858. $c = '您的远程诊断申请,被'.$institution['name'].$doctor['realname'].'医师驳回。驳回理由:'.$param['description'];
  859. $d = $application['req_doctor_id'];
  860. $type = '2';
  861. $exam_class = DB::table('exams')->where('id',$re['exam_id'])->field('exam_class')->find();
  862. $url = Message::url($sessionid,$re['exam_id'],0,$exam_class['exam_class'],$report['id'],$id);
  863. Message::insert($t,$c,$d,$type,$url,1,$id);
  864. // 驳回发短信
  865. $d_phone = $dinfo['phone'];
  866. if($dinfo['institution_id'] == '22100002' || $dinfo['send_sms'] == 1){ //魏庙下级
  867. $des = mb_substr($param['description'],0,20,'utf-8');
  868. $repsone = send_message::sendSms2RejectApply($d_phone,$des);
  869. }
  870. $tel = '18910184804';
  871. $type = '驳回申请';
  872. $content = $application['id'];
  873. // send_message::sendSms2Self($tel,$type,$content);
  874. $tel = '18366391911';
  875. send_message::sendSms2Self($tel,$type,$content);
  876. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid]);
  877. }
  878. /**
  879. * 远程申请接收
  880. *
  881. * @ApiTitle (远程申请接收)
  882. * @ApiSummary (远程申请接收)
  883. * @ApiSector (远程诊断)
  884. * @ApiMethod (POST)
  885. * @ApiRoute (/inter/application/recive)
  886. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  887. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  888. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  889. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  890. * @ApiParams (name="id", type="string", required=true, sample="", description="参数json字符串,预约登记exams表id值<必填>")
  891. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  892. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  893. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  894. * @ApiReturn (data="
  895. {
  896. 'status': ok,
  897. 'code': '0000',
  898. 'sessionid': 'a17z7a7a8f9g9rh9d89jio'
  899. }
  900. *")
  901. **/
  902. public function recive(){
  903. $sessionid = $_REQUEST['sessionid'];
  904. $doctor = Cache::get($sessionid);
  905. $id = $_REQUEST['id'];
  906. $re = DB::table('remote_application')->where('id',$id)->field('report_status,req_doctor_id,exam_id')->find();
  907. if($re['report_status'] != 4){
  908. return json_encode(['status'=>'fail','code'=>'0321','msg'=>'只能接收申请中的单子']);
  909. }
  910. DB::table('remote_application')->where('id',$id)->update(['report_status'=>6]);
  911. $application = DB::table('remote_application')->where('exam_id',$id)->find();
  912. $tel = '18910184804';
  913. $type = '接收申请';
  914. $content = $application['id'];
  915. // send_message::sendSms2Self($tel,$type,$content);
  916. // 添加messages消息
  917. $t = '您的远程诊断申请被接收';
  918. $institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  919. $c = '您的远程诊断申请,被'.$institution['name'].$doctor['realname'].'医师接收';
  920. $d = $re['req_doctor_id'];
  921. $type = '4';
  922. $exam_class = DB::table('exams')->where('id',$re['exam_id'])->field('exam_class')->find();
  923. $report = DB::table('report')->where('exam_id',$re['exam_id'])->where('type',1)->field('id')->find();
  924. $url = Message::url($sessionid,$re['exam_id'],0,$exam_class['exam_class'],$report['id'],$id);
  925. Message::insert($t,$c,$d,$type,$url,1,$id);
  926. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid]);
  927. }
  928. /**
  929. * bbs通话保存
  930. *
  931. * @ApiTitle (bbs通话保存)
  932. * @ApiSummary (bbs通话保存)
  933. * @ApiSector (远程诊断)
  934. * @ApiMethod (POST)
  935. * @ApiRoute (/inter/application/bbs_save)
  936. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  937. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  938. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  939. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  940. * @ApiParams (name="param", type="string", required=true, sample="", description="参数json字符串,预约登记exams表id值<必填>")
  941. * @ApiParams (name="param[appid]", type="string", sample="", description="申请单id值<必填>")
  942. * @ApiParams (name="param[content]", type="string", sample="", description="留言内容<必填>")
  943. * @ApiParams (name="param[attachment]", type="string", sample="", description="上传图片<选填>")
  944. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  945. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  946. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  947. * @ApiReturn (data="
  948. {
  949. 'status': ok,
  950. 'code': '0000',
  951. 'sessionid': 'a17z7a7a8f9g9rh9d89jio',
  952. 'info' : ''
  953. }
  954. *")
  955. **/
  956. public function bbs_save(){
  957. $sessionid = $_REQUEST['sessionid'];
  958. $doctor = Cache::get($sessionid);
  959. $param = $_REQUEST['param'];
  960. if(empty($param['content'])){
  961. return json_encode(['status'=>'fail','msg'=>'内容为空,请填写要发送的内容','sessionid'=>$sessionid]);
  962. }
  963. $info = array();
  964. $info['id'] = UUIDs::uuid16();
  965. $info['initiator'] = $doctor['id'];
  966. $is_remote = $_REQUEST['is_remote'];
  967. $rinfo = DB::table('remote_application')->where('id',$param['appid'])->field('req_doctor_id,remote_doctor_id')->find();
  968. if($is_remote == 1){
  969. // 远程医生
  970. $info['reply'] = $rinfo['req_doctor_id']; //申请医生
  971. $remote = 0;
  972. }else{
  973. $info['reply'] = $rinfo['remote_doctor_id']; //申请的目标远程医生
  974. $remote = 1;
  975. }
  976. $info['remote_application_id'] = $param['appid']; //申请单id
  977. $info['content'] = $param['content'];
  978. $info['attachment'] = $param['attachment'];
  979. $info['createdAt'] = date('Y-m-d H:i:s',time());
  980. DB::table('bbs')->insert($info);
  981. // 添加message消息
  982. Message::bbs_message($param['appid'],$doctor['id'],$param['content'],$info['reply'],$remote,$sessionid);
  983. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid]);
  984. }
  985. public function getbbs(){
  986. $sessionid = $_REQUEST['sessionid'];
  987. $doctor = Cache::get($sessionid);
  988. $remote_id = $_REQUEST['application_id'];
  989. Message::read($doctor['id'],$remote_id,5);
  990. $info = DB::table('bbs')->where('remote_application_id',$remote_id)->order('createdAt desc')->select();
  991. foreach ($info as $k => $v) {
  992. $initiator = DB::table('doctors')->where('id',$v['initiator'])->field('realname')->find();
  993. $info[$k]['faqiren'] = $initiator['realname'];
  994. // $reply = DB::table('doctors')->where('id',$v['reply'])->field('realname')->find();
  995. // $info[$k]['huifuren'] = $reply['realname'];
  996. }
  997. return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid,'info'=>$info]);
  998. }
  999. /**
  1000. * 上传通话留言附件
  1001. *
  1002. * @ApiTitle (上传通话留言附件)
  1003. * @ApiSummary (上传通话留言附件)
  1004. * @ApiSector (远程诊断)
  1005. * @ApiMethod (POST)
  1006. * @ApiRoute (/inter/application/bbs_upload)
  1007. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  1008. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  1009. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  1010. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  1011. * @ApiParams (name="file", type="string", required=true, description="上传的文件<必填>")
  1012. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  1013. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  1014. * @ApiReturnParams (name="info", type="string", required=true, sample="返回成功", description="返回信息")
  1015. * @ApiReturn (data="
  1016. {
  1017. 'status': ok,
  1018. 'code': '0000',
  1019. 'info' : '/upload/20180101/12346asd.jpg'
  1020. }
  1021. *")
  1022. **/
  1023. public function bbs_upload(){
  1024. // 获取表单上传文件 例如上传了001.jpg
  1025. $file = request()->file('file');
  1026. log::record('----------上传的文件-----------');
  1027. log::record($file);
  1028. // 移动到框架应用根目录/public/uploads/ 目录下
  1029. if($file){
  1030. $info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
  1031. log::record($info);
  1032. if($info){
  1033. return json_encode(['status'=>'ok','code'=>'0000','info'=>'/'.$_SERVER["SERVER_NAME"]. '/' . 'uploads'. '/' .$info->getSaveName()]);
  1034. }else{
  1035. // 上传失败获取错误信息
  1036. echo $file->getError();
  1037. }
  1038. }
  1039. }
  1040. /**
  1041. * 撤回
  1042. *
  1043. * @ApiTitle (撤回)
  1044. * @ApiSummary (撤回)
  1045. * @ApiSector (远程诊断)
  1046. * @ApiMethod (POST)
  1047. * @ApiRoute (/inter/application/revoke)
  1048. * @ApiHeaders (name="sign", type="string", required=true, description="请求头-校验key")
  1049. * @ApiHeaders (name="nonce", type="string", required=true, description="请求头-随机数")
  1050. * @ApiHeaders (name="timestamp", type=string, required=true, description="请求头-时间戳s")
  1051. * @ApiParams (name="sessionid", type="string", required=true, description="参数json字符串")
  1052. * @ApiParams (name="id", type="string", required=true, sample="", description="参数json字符串,预约登记exams表id值<必填>")
  1053. * @ApiReturnParams (name="status", type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
  1054. * @ApiReturnParams (name="code", type="integer", required=true, sample="0", description="返回状态码")
  1055. * @ApiReturnParams (name="sessionid", type="object", sample="{}", description="缓存的数据key")
  1056. * @ApiReturn (data="
  1057. {
  1058. 'status': ok,
  1059. 'code': '0000',
  1060. 'sessionid': 'a17z7a7a8f9g9rh9d89jio'
  1061. }
  1062. *")
  1063. **/
  1064. //
  1065. public function revoke(){
  1066. $sessionid = $_REQUEST['sessionid'];
  1067. $doctor = Cache::get($sessionid);
  1068. $id = $_REQUEST['id'];
  1069. $status = DB::table('remote_application')->where('exam_id',$id)->field('id,report_status,remote_doctor_id')->find();
  1070. if($status['report_status'] == 4){
  1071. DB::table('remote_application')->where('exam_id',$id)->update(['report_status'=>12]);
  1072. }else{
  1073. return json_encode(['status'=>'ok','code'=>'0100','msg'=>'只能撤回申请中状态的申请单']);
  1074. }
  1075. $binfo = array();
  1076. $binfo['id'] = UUIDs::uuid16();
  1077. $binfo['initiator'] = $doctor['id'];
  1078. // $info['reply'] = $param['reply']; // 回复人
  1079. $binfo['remote_application_id'] = $status['id']; //申请单id
  1080. $binfo['content'] = '已撤回了该申请';
  1081. $binfo['createdAt'] = date('Y-m-d H:i:s',time());
  1082. DB::table('bbs')->insert($binfo);
  1083. //
  1084. $t = '发起给您的远程诊断申请被撤回';
  1085. $institution = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
  1086. $c = '您的远程诊断申请'.$institution['name'].$doctor['realname'].'医师撤回';
  1087. $d = $status['remote_doctor_id'];
  1088. $type = '3';
  1089. $exam_class = DB::table('exams')->where('id',$id)->field('exam_class')->find();
  1090. $report = DB::table('report')->where('remote_application_id',$status['id'])->field('id')->find();
  1091. $url = Message::url($sessionid,$id,1,$exam_class['exam_class'],$report['id'],$status['id']);
  1092. Message::insert($t,$c,$d,$type,$url,1,$status['id']);
  1093. return json_encode(['status'=>'ok','code'=>'0000','msg'=>'撤回成功']);
  1094. }
  1095. public function bind_doctor()
  1096. {
  1097. try{
  1098. $ra_id = $_REQUEST['ra_id'];
  1099. $status = DB::table('remote_application')->where('id',$ra_id)->value('report_status');
  1100. if($status != 4){
  1101. return json_encode(['status'=>'fail','code'=>'0410','msg'=>'只能分配未经处理的报告']);
  1102. }
  1103. $did = $_REQUEST['did'];
  1104. $info = DB::table('remote_application')->where('id',$ra_id)->update(['remote_doctor_id'=>$did]);
  1105. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info]);
  1106. }catch(\Exception $e){
  1107. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  1108. }
  1109. }
  1110. //获取医生的接收和分配权限
  1111. public function get_doctor_role()
  1112. {
  1113. try{
  1114. $sessionid = $_REQUEST['sessionid'];
  1115. $doctor = Cache::get($sessionid);
  1116. $info = [];
  1117. $info['is_admin'] = $doctor['is_admin'];
  1118. $role = DB::table('doctor_class')->where('doctor_id',$doctor['id'])->value('doctor_class');
  1119. if(strpos($role,'7') !== false){
  1120. $info['is_doctor'] = 1;
  1121. }else{
  1122. $info['is_doctor'] = 0;
  1123. }
  1124. return json_encode(['status'=>'ok','code'=>'0000','info'=>$info]);
  1125. }catch(\Exception $e){
  1126. return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
  1127. }
  1128. }
  1129. }