Application.php 64 KB

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