DoctorController.php 127 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: Yuanhang Liu & Xiaoyun Liu
  5. * Date: 20-10-14
  6. * Time: 下午2:50
  7. */
  8. namespace App\Http\Controllers\Api\V2;
  9. use App\Http\Controllers\Api\V1\AuthController;
  10. use App\Models\Docter;
  11. use App\Models\Office;
  12. use App\Models\Order;
  13. use App\Models\OrderPack;
  14. use App\Models\OrderPatient;
  15. use App\Models\Patient;
  16. use App\Models\Qualification;
  17. use App\Models\Suggest;
  18. use App\Models\Areas;
  19. use App\Models\Collection as Collections;
  20. use App\Models\Organization;
  21. use App\Models\DocterTimes;
  22. use App\Models\DocterOrganization;
  23. use App\Http\Controllers\Api\V2\CommonController as Commons;
  24. use App\Models\Team;
  25. use App\Models\User;
  26. use Illuminate\Support\Facades\DB;
  27. use MongoDB\BSON\ObjectId;
  28. use PhpParser\Comment\Doc;
  29. use App\Models\DocterUser;
  30. use App\Models\Schedule;
  31. use App\Models\TimePeriod;
  32. use App\Models\SchedulePeriod;
  33. use App\Models\DocterMessage;
  34. use App\Models\Evaluate;
  35. use App\Models\UserDocter;
  36. use App\Models\ServiceApply;
  37. use App\Models\SystemConfig;
  38. use App\Models\WeekSchedule;
  39. use App\Models\SelfSchedule;
  40. use App\Models\DocterSetting;
  41. use App\Models\DocterServiceTimes;
  42. use App\Models\CallLog;
  43. use App\Models\ImMessage;
  44. use App\Models\DocterLable;
  45. /**
  46. * 医生相关类
  47. * Auth Yuanhang Liu
  48. * Date 2020/10/14 15:06
  49. * Class DoctorController
  50. * @package App\Http\Controllers\Api\V2
  51. */
  52. class DoctorController extends AuthController
  53. {
  54. /**service_schedule
  55. * @return \Illuminate\Http\JsonResponse
  56. * 首页医生个人信息接口
  57. */
  58. public function doctorInfor()
  59. {
  60. $req = $this->user;
  61. $data = Docter::where('phone', $req['phone'])->first(['id', 'name', 'avatar', 'label', 'sign', 'intro', 'service_days', 'service_persons','password', 'eva_num', 'score', 'is_then', 'created_at']);
  62. if (!empty($data)) {
  63. // 获取标签
  64. $LabFind = [];
  65. if ($data['label']!='无'){
  66. if(count($data['label'])!=0){
  67. $labstr = $data['label'];
  68. $LabFind = DocterLable::whereIn('id',$labstr)->where('status',1)->select('label_name')->get();
  69. }
  70. }
  71. $data['label'] = $LabFind;
  72. // $counts = Evaluate::where('docter_id', '=', $req['id'])->count();
  73. $evalList = Evaluate::where('docter_id', '=', $req['id'])->get();
  74. $counts = count($evalList);
  75. $data['eva_num'] = $counts;
  76. $soc = 0;
  77. if ($counts != 0) {
  78. $evalList = $evalList->toArray();
  79. foreach ($evalList as $k => $v) {
  80. $soc += $v['score'];
  81. }
  82. $data['score'] = upDecimal($soc / $counts, 1);
  83. }
  84. $data['service_days'] = numDays(date('Y-m-d', strtotime($data['created_at'])));
  85. return out($data);
  86. } else {
  87. return exit_out($data, 1, '参数错误,数据不存在');
  88. }
  89. }
  90. /**
  91. * 医生端个人信息修改
  92. * @return mixed
  93. */
  94. public function doctorInfoEdit()
  95. {
  96. $user = $this->user;
  97. $doctor_id = $user['id'];
  98. if (request()->isMethod('post')) {
  99. $req = request()->post();
  100. $this->validate(request(), [
  101. 'avatar' => 'string',
  102. 'sign' => 'max:255',
  103. // 'phone|手机号不正确' => 'regex:/^1[3456789][0-9]{9}$/',
  104. 'intro' => 'max:2555'
  105. ]);
  106. $data = [];
  107. if (isset($req['avatar']) && !empty($req['avatar'])) {
  108. $data['avatar'] = $req['avatar'];
  109. }
  110. if (isset($req['sign']) && !empty($req['sign'])) {
  111. $data['sign'] = $req['sign'];
  112. }
  113. if (isset($req['intro']) && !empty($req['intro'])) {
  114. $data['intro'] = $req['intro'];
  115. }
  116. if (empty($data)) {
  117. return out();
  118. }
  119. if ($doctor_id) {
  120. $save = Docter::where('id', $doctor_id)->update($data);
  121. return out();
  122. }
  123. } else {
  124. // get提交哈
  125. $list = Docter::where('id', '=', $doctor_id)->first()->toArray();
  126. // 头像,个人标签,服务简介展示
  127. $data = [
  128. 'avatar' => !empty($list['avatar'])?$list['avatar']:'',
  129. 'sign' => !empty($list['sign'])?$list['sign']:'',
  130. 'intro' => !empty($list['intro'])?$list['intro']:'',
  131. ];
  132. return out($data);
  133. }
  134. }
  135. /**
  136. * 修改密码
  137. * @return \Illuminate\Http\JsonResponse
  138. * @author Liu-Yh
  139. * Create By 2020/11/4 18:19
  140. */
  141. public function passwordEdit()
  142. {
  143. $user = $this->user;
  144. $doctor_id = $user['id'];
  145. $req = request()->post();
  146. $this->validate(request(), [
  147. 'lis:原密码' => 'string',
  148. 'newpassword:新密码' => 'string',
  149. ]);
  150. $data = [];
  151. $data = Docter::where('id', '=', $doctor_id)->first()->toArray();
  152. $password = md5(md5(md5($req['newpassword'])));
  153. if ($data['password'] == '' || !$data['password']) {
  154. // 说明第一次直接跳过
  155. $save = Docter::where('id', $doctor_id)->update(['password' => $password]);
  156. return out();
  157. } else {
  158. if(isset($req['lis'])&&!empty($req['lis'])){
  159. $oldpassword = md5(md5(md5($req['lis'])));
  160. if ($oldpassword != $data['password']) {
  161. return out('', '401', '旧密码错误');
  162. } else {
  163. $save = Docter::where('id', $doctor_id)->update(['password' => $password]);
  164. return out();
  165. }
  166. }else{
  167. return out('', '401', '请输入旧密码');
  168. }
  169. }
  170. }
  171. /**
  172. * 基本/更多设置读取(废弃)
  173. * @return \Illuminate\Http\JsonResponse
  174. * @author Yuanhang Liu
  175. */
  176. public function getSettingList()
  177. {
  178. $req = request()->post();
  179. $this->validate(request(), [
  180. 'type' => 'required|integer|in:1,2',
  181. 'service_type' => 'integer'
  182. ]);
  183. $user = $this->user;
  184. $doctor_id = (new Commons)->getUserIdByDoctorId($user['phone']);
  185. $finds = Docter::select(['is_chat', 'is_phone', 'is_appoint'])->where('id', $doctor_id)->first()->toArray();
  186. $finds['is_chat'] = $finds['is_chat'] == 0 ? false : true;
  187. $finds['is_phone'] = $finds['is_phone'] == 0 ? false : true;
  188. $finds['is_appoint'] = $finds['is_appoint'] == 0 ? false : true;
  189. $finds['is_chat_status'] = $this->getStyStatus(1);
  190. $finds['is_phone_status'] = $this->getStyStatus(2);
  191. $finds['is_appoint_status'] = $this->getStyStatus(3);
  192. if ($req['type'] == 2) {
  193. (array)$list = [];
  194. // 获取显示状态:
  195. $list['show'] = $finds;
  196. // 获取电话咨询时间
  197. $phone_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 1])->first();
  198. if ($phone_fins) {
  199. $phone_fins = $phone_fins->toArray();
  200. } else {
  201. $phone_fins = [];
  202. }
  203. $list['list']['phone'] = $phone_fins;
  204. // 图文咨询时间
  205. $pic_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 2])->first();
  206. if ($pic_fins) {
  207. $pic_fins = $pic_fins->toArray();
  208. } else {
  209. $pic_fins = [];
  210. }
  211. $list['list']['chat'] = $pic_fins;
  212. // 门诊咨询时间
  213. $men_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 3])->get();
  214. if ($men_fins) {
  215. $men_fins = $men_fins->toArray();
  216. } else {
  217. $men_fins = [];
  218. }
  219. $list['list']['men'] = $men_fins;
  220. // 获取医院
  221. $org = DocterOrganization::with('organization')->where('docter_id', $doctor_id)->get();
  222. $org_pre = [];
  223. $org_pres = [];
  224. if ($org) {
  225. $org = $org->toArray();
  226. foreach ($org as $k => $v) {
  227. $org_pres[$k]['id'] = $v['organization']['id'];
  228. $org_pres[$k]['name'] = $v['organization']['name'];
  229. $org_pre[$k]['name'] = $v['organization']['name'];
  230. }
  231. }
  232. $list['org'] = $org_pre;
  233. $list['orgs'] = $org_pres;
  234. $times = TimePeriod::get();
  235. if ($times) {
  236. $times = $times->toArray();
  237. $newTimes = [];
  238. foreach ($times as $k => $v) {
  239. $newTimes[$k]['id'] = $v['id'];
  240. $newTimes[$k]['name'] = $v['start_time_period'] . ' - ' . $v['end_time_period'];
  241. $newTimes[$k]['checked'] = false;
  242. }
  243. $times1 = [];
  244. $times2 = [];
  245. $times3 = [];
  246. foreach ($newTimes as $k => $v) {
  247. if ($k >= 0 && $k < 16) {
  248. array_push($times1, $v);
  249. } else if ($k >= 16 && $k < 32) {
  250. array_push($times2, $v);
  251. } else {
  252. array_push($times3, $v);
  253. }
  254. }
  255. $list['times']['list1'] = $times1;
  256. $list['times']['list2'] = $times2;
  257. $list['times']['list3'] = $times3;
  258. } else {
  259. $times = [];
  260. }
  261. return out($list);
  262. }
  263. return out($finds);
  264. }
  265. /**
  266. * 更多设置读取,新的
  267. * @return \Illuminate\Http\JsonResponse
  268. * @author Liu-Yh
  269. * Create By 2020/12/16 11:10
  270. */
  271. public function getSettingListnew()
  272. {
  273. $req = request()->post();
  274. $this->validate(request(), [
  275. 'type' => 'required|integer|in:1,2',
  276. 'service_type' => 'integer'
  277. ]);
  278. $user = $this->user;
  279. $doctor_id = (new Commons)->getUserIdByDoctorId($user['phone']);
  280. $finds = Docter::select(['is_chat', 'is_phone', 'is_appoint'])->where('id', $doctor_id)->first()->toArray();
  281. $finds['is_chat'] = $finds['is_chat'] == 0 ? false : true;
  282. $finds['is_phone'] = $finds['is_phone'] == 0 ? false : true;
  283. $finds['is_appoint'] = $finds['is_appoint'] == 0 ? false : true;
  284. $finds['is_chat_status'] = $this->getStyStatus(1);
  285. $finds['is_phone_status'] = $this->getStyStatus(2);
  286. $finds['is_appoint_status'] = $this->getStyStatus(3);
  287. if ($req['type'] == 2) {
  288. (array)$list = [];
  289. // 获取显示状态:
  290. $list['show'] = $finds;
  291. // 获取电话咨询时间
  292. $phone_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 1])->first();
  293. if ($phone_fins) {
  294. $phone_fins = $phone_fins->toArray();
  295. $phone_fins['service_time'] = json_decode($phone_fins['service_time']);
  296. } else {
  297. $phone_fins = [];
  298. }
  299. $list['list']['phone'] = $phone_fins;
  300. // 图文咨询时间
  301. $pic_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 2])->first();
  302. if ($pic_fins) {
  303. $pic_fins = $pic_fins->toArray();
  304. $pic_fins['service_time'] = json_decode($pic_fins['service_time']);
  305. } else {
  306. $pic_fins = [];
  307. }
  308. $list['list']['chat'] = $pic_fins;
  309. // 门诊咨询时间
  310. $newLists=[];
  311. $men_fins = DocterSetting::where(['docter_id' => $doctor_id, 'type' => 1])->orderBy('org_id','asc')->get();
  312. $org = DocterOrganization::with('organization')->where(['docter_id'=>$doctor_id,'state'=>1])->orderBy('organization_id','asc')->get();
  313. if ($org) {
  314. $org = $org->toArray();
  315. foreach ($org as $k => $v) {
  316. $org_pre[$k]['id'] = $v['organization']['id'];
  317. $org_pre[$k]['name'] = $v['organization']['name'];
  318. }
  319. }
  320. if ($men_fins) {
  321. $men_fins = $men_fins->toArray();
  322. foreach ($men_fins as $k => $v) {
  323. $men_fins[$k]['service_time'] = json_decode($v['service_time'],true);
  324. }
  325. $org_list=[];
  326. foreach ($org as $k=>$v){
  327. $org_list[$k]['docter_id'] = $doctor_id;
  328. $org_list[$k]['type'] = 1;
  329. $org_list[$k]['status'] = 2;
  330. $org_list[$k]['show_days'] = '';
  331. $org_list[$k]['service_times'] = '';
  332. $org_list[$k]['service_num'] = '';
  333. $org_list[$k]['org_id'] = $v['organization']['id'];
  334. $org_list[$k]['org_name'] = $v['organization']['name'];
  335. $org_list[$k]['appoint_price'] = '';
  336. $org_list[$k]['service_time'] = [
  337. 1=>['amStartTime'=>'','amEndTime'=>'','amPerson'=>''],
  338. 2=>['pmStartTime'=>'','pmEndTime'=>'','pmPerson'=>''],
  339. 3=>['nightStartTime'=>'','nightEndTime'=>'','nightPerson'=>''],
  340. ];
  341. }
  342. foreach ($org_list as $k=>$v){
  343. foreach ($men_fins as $kk=>$vv){
  344. if ($v['org_id']==$vv['org_id']){
  345. $org_list[$k]['docter_id'] = $doctor_id;
  346. $org_list[$k]['type'] = 1;
  347. $org_list[$k]['status'] = 2;
  348. $org_list[$k]['show_days'] = $vv['show_days'];
  349. $org_list[$k]['service_times'] = $vv['service_times'];
  350. $org_list[$k]['service_num'] = $vv['service_num'];
  351. $org_list[$k]['org_id'] = $vv['org_id'];
  352. $org_list[$k]['org_name'] = $v['org_name'];
  353. $org_list[$k]['appoint_price'] = $vv['appoint_price'];
  354. $org_list[$k]['service_time'] = [
  355. 1=>['amStartTime'=>$vv['service_time'][1]['amStartTime'],'amEndTime'=>$vv['service_time'][1]['amEndTime'],'amPerson'=>$vv['service_time'][1]['amPerson']],
  356. 2=>['pmStartTime'=>$vv['service_time'][2]['pmStartTime'],'pmEndTime'=>$vv['service_time'][2]['pmEndTime'],'pmPerson'=>$vv['service_time'][2]['pmPerson']],
  357. 3=>['nightStartTime'=>$vv['service_time'][3]['nightStartTime'],'nightEndTime'=>$vv['service_time'][3]['nightEndTime'],'nightPerson'=>$vv['service_time'][3]['nightPerson']],
  358. ];
  359. }
  360. }
  361. }
  362. $newLists = $org_list;
  363. } else {
  364. $men_fins = [];
  365. foreach ($org as $k=>$v){
  366. $newLists[$k]['docter_id'] = $doctor_id;
  367. $newLists[$k]['type'] = 1;
  368. $newLists[$k]['status'] = 2;
  369. $newLists[$k]['show_days'] = '';
  370. $newLists[$k]['service_times'] = '';
  371. $newLists[$k]['service_num'] = '';
  372. $newLists[$k]['org_id'] = $v['organization']['id'];
  373. $newLists[$k]['org_name'] = $v['organization']['name'];
  374. $newLists[$k]['appoint_price'] = '';
  375. $newLists[$k]['service_time'] = [
  376. 1=>['amStartTime'=>'','amEndTime'=>'','amPerson'=>''],
  377. 2=>['pmStartTime'=>'','pmEndTime'=>'','pmPerson'=>''],
  378. 3=>['nightStartTime'=>'','nightEndTime'=>'','nightPerson'=>''],
  379. ];
  380. }
  381. }
  382. // 获取医院
  383. // $org_pre = [];
  384. $list['list']['men'] = $newLists;
  385. // $list['org'] = $org_pre;
  386. return out($list);
  387. }
  388. return out($finds);
  389. }
  390. /**
  391. * 获取审核状态
  392. * @param $type
  393. * @return bool
  394. */
  395. public function getStyStatus($type)
  396. {
  397. $user = $this->user;
  398. $doctor_id = $user['id'];
  399. $where['docter_id'] = $doctor_id;
  400. $where['service_type'] = $type;
  401. $statusD = ServiceApply::where($where)->first();
  402. if ($statusD) {
  403. return $statusD;
  404. } else {
  405. return false;
  406. }
  407. }
  408. /**
  409. * 基本/更多设置修改
  410. * @return \Illuminate\Http\JsonResponse
  411. * @author Yuanhang Liu
  412. */
  413. public function saveSettingList()
  414. {
  415. $req = request()->post();
  416. $this->validate(request(), [
  417. 'type' => 'required|integer|in:1,2',
  418. ]);
  419. $data = json_decode($req['data'], true);
  420. $user = $this->user;
  421. $doctor_id = $user['id'];
  422. $finds = Docter::select(['is_chat', 'is_phone', 'is_appoint'])->where('id', $doctor_id)->first();
  423. $flag = false;
  424. if ($req['type'] == 1) {
  425. // 修改基本信息
  426. $list = [];
  427. isset($data['is_chat']) ? $data['is_chat'] == true ? $list['is_chat'] = 1 : $list['is_chat'] = 0 : '';
  428. isset($data['is_phone']) ? $data['is_phone'] == true ? $list['is_phone'] = 1 : $list['is_phone'] = 0 : '';
  429. isset($data['is_appoint']) ? $data['is_appoint'] == true ? $list['is_appoint'] = 1 : $list['is_appoint'] = 0 : '';
  430. Docter::where('id', $doctor_id)->update($list);
  431. return out();
  432. } else if ($req['type'] == 2) {
  433. Db::beginTransaction();
  434. try {
  435. // 修改更多信息
  436. if ($finds['is_chat'] == 0) {
  437. if (isset($data['is_chat']) && !empty($data['is_chat'])) {
  438. unset($data['is_chat']);
  439. }
  440. } else {
  441. if (isset($data['is_chat']) && !empty($data['is_chat'])) {
  442. DocterServiceTimes::where(['docter_id'=>$doctor_id,'type'=>2])->delete();
  443. $save_data = $data['is_chat'];
  444. $newData = [];
  445. $serviceData = [];
  446. $newData['base_price'] = $save_data['base_price'];
  447. $newData['step_price'] = $save_data['step_price'];
  448. $serviceData[0]['docter_id']=$doctor_id;
  449. $serviceData[0]['type']=2;
  450. $serviceData[0]['start_time_period']=$save_data['amStartTime'];
  451. $serviceData[0]['end_time_period']=$save_data['amEndTime'];
  452. $serviceData[0]['start_time_line']=str_replace(':','',$save_data['amStartTime']);
  453. $serviceData[0]['end_time_line']=str_replace(':','',$save_data['amEndTime']);
  454. $serviceData[1]['docter_id']=$doctor_id;
  455. $serviceData[1]['type']=2;
  456. $serviceData[1]['start_time_period']=$save_data['pmStartTime'];
  457. $serviceData[1]['end_time_period']=$save_data['pmEndTime'];
  458. $serviceData[1]['start_time_line']=str_replace(':','',$save_data['pmStartTime']);
  459. $serviceData[1]['end_time_line']=str_replace(':','',$save_data['pmEndTime']);
  460. $serviceData[2]['docter_id']=$doctor_id;
  461. $serviceData[2]['type']=2;
  462. $serviceData[2]['start_time_period']=$save_data['nightStartTime'];
  463. $serviceData[2]['end_time_period']=$save_data['nightEndTime'];
  464. $serviceData[2]['start_time_line']=str_replace(':','',$save_data['nightStartTime']);
  465. $serviceData[2]['end_time_line']=str_replace(':','',$save_data['nightEndTime']);
  466. $service_times = [
  467. 1 => ['amStartTime' => $save_data['amStartTime'], 'amEndTime' => $save_data['amEndTime']],
  468. 2 => ['pmStartTime' => $save_data['pmStartTime'], 'pmEndTime' => $save_data['pmEndTime']],
  469. 3 => ['nightStartTime' => $save_data['nightStartTime'], 'nightEndTime' => $save_data['nightEndTime']],
  470. ];
  471. $newData['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE);
  472. $newData['person'] = $save_data['person'];
  473. $newData['type'] = $save_data['type'];
  474. $pic_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 2])->first();
  475. DocterServiceTimes::insert($serviceData);
  476. if (empty($pic_fins)) {
  477. $newData['docter_id'] = $doctor_id;
  478. DocterTimes::create($newData);
  479. } else {
  480. $pic_fins = $pic_fins->toArray();
  481. DocterTimes::where(['id' => $pic_fins['id']])->update($newData);
  482. }
  483. }
  484. }
  485. if ($finds['is_phone'] == 0) {
  486. if (isset($data['is_phone']) && !empty($data['is_phone'])) {
  487. unset($data['is_phone']);
  488. }
  489. } else {
  490. if (isset($data['is_phone']) && !empty($data['is_phone'])) {
  491. // 存入状态为1的操作
  492. DocterServiceTimes::where(['docter_id'=>$doctor_id,'type'=>1])->delete();
  493. $save_data = $data['is_phone'];
  494. $newData = [];
  495. $serviceData = [];
  496. $newData['base_price'] = $save_data['base_price'];
  497. $newData['step_price'] = $save_data['step_price'];
  498. $serviceData[0]['docter_id']=$doctor_id;
  499. $serviceData[0]['type']=1;
  500. $serviceData[0]['start_time_period']=$save_data['amStartTime'];
  501. $serviceData[0]['end_time_period']=$save_data['amEndTime'];
  502. $serviceData[0]['start_time_line']=str_replace(':','',$save_data['amStartTime']);
  503. $serviceData[0]['end_time_line']=str_replace(':','',$save_data['amEndTime']);
  504. $serviceData[1]['docter_id']=$doctor_id;
  505. $serviceData[1]['type']=1;
  506. $serviceData[1]['start_time_period']=$save_data['pmStartTime'];
  507. $serviceData[1]['end_time_period']=$save_data['pmEndTime'];
  508. $serviceData[1]['start_time_line']=str_replace(':','',$save_data['pmStartTime']);
  509. $serviceData[1]['end_time_line']=str_replace(':','',$save_data['pmEndTime']);
  510. $serviceData[2]['docter_id']=$doctor_id;
  511. $serviceData[2]['type']=1;
  512. $serviceData[2]['start_time_period']=$save_data['nightStartTime'];
  513. $serviceData[2]['end_time_period']=$save_data['nightEndTime'];
  514. $serviceData[2]['start_time_line']=str_replace(':','',$save_data['nightStartTime']);
  515. $serviceData[2]['end_time_line']=str_replace(':','',$save_data['nightEndTime']);
  516. $service_times = [
  517. 1 => ['amStartTime' => $save_data['amStartTime'], 'amEndTime' => $save_data['amEndTime']],
  518. 2 => ['pmStartTime' => $save_data['pmStartTime'], 'pmEndTime' => $save_data['pmEndTime']],
  519. 3 => ['nightStartTime' => $save_data['nightStartTime'], 'nightEndTime' => $save_data['nightEndTime']],
  520. ];
  521. $newData['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE);
  522. $newData['person'] = $save_data['person'];
  523. $newData['type'] = $save_data['type'];
  524. // 图文咨询时间
  525. $phone_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 1])->first();
  526. DocterServiceTimes::insert($serviceData);
  527. if (empty($phone_fins)) {
  528. $newData['docter_id'] = $doctor_id;
  529. DocterTimes::create($newData);
  530. } else {
  531. $phone_fins = $phone_fins->toArray();
  532. DocterTimes::where(['id' => $phone_fins['id']])->update($newData);
  533. }
  534. }
  535. }
  536. if ($finds['is_appoint'] == 0) {
  537. if (isset($data['is_appoint']) && !empty($data['is_appoint'])) {
  538. unset($data['is_appoint']);
  539. }
  540. } else {
  541. // 此时可能有两个医院,为一个数组,一个一个入库
  542. if (isset($data['is_appoint']) && !empty($data['is_appoint'])) {
  543. $save_data = $data['is_appoint'];
  544. $setting_data = [];
  545. $times_data = [];
  546. // 查询除本地来
  547. $edutime = DocterSetting::where(['docter_id' => $doctor_id, 'type' => 1])->get();
  548. if ($edutime) {
  549. $newedu = [];
  550. foreach ($edutime as $k => $v) {
  551. $newedu[$k]['org_id'] = $v['org_id'];
  552. $newedu[$k]['service_times'] = $v['service_times'];
  553. }
  554. $flag_arr = [];
  555. foreach ($newedu as $k => $v) {
  556. foreach ($save_data as $kk => $vv) {
  557. if ($v['org_id'] == $vv['org_id']) {
  558. if ($v['service_times'] != $vv['service_times']) {
  559. $flag_arr[] = $vv['org_id'];
  560. }
  561. }
  562. }
  563. }
  564. $flag = !empty($flag_arr) ? $flag_arr : false;
  565. }
  566. foreach ($save_data as $k => $v) {
  567. if (!isset($v['service_times'])||empty($v['service_times'])){
  568. unset($save_data[$k]);
  569. }else{
  570. DocterSetting::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete();
  571. TimePeriod::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete();
  572. $setting_data[$k]['docter_id'] = $doctor_id;
  573. $setting_data[$k]['type'] = 1;
  574. $setting_data[$k]['status'] = 2;
  575. $setting_data[$k]['appoint_price'] = $v['base_price'];
  576. $setting_data[$k]['show_days'] = $v['show_days'];
  577. $setting_data[$k]['service_times'] = $v['service_times'];
  578. $setting_data[$k]['service_num'] = $v['service_num'];
  579. $setting_data[$k]['org_id'] = $v['org_id'];
  580. $service_times = [
  581. 1 => ['amStartTime' => $v['amStartTime'], 'amEndTime' => $v['amEndTime'], 'amPerson' => $v['amPerson']],
  582. 2 => ['pmStartTime' => $v['pmStartTime'], 'pmEndTime' => $v['pmEndTime'], 'pmPerson' => $v['pmPerson']],
  583. 3 => ['nightStartTime' => $v['nightStartTime'], 'nightEndTime' => $v['nightEndTime'], 'nightPerson' => $v['nightPerson']],
  584. ];
  585. $setting_data[$k]['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE);
  586. $setting_data[$k]['created_at'] = date('Y-m-d H:i:s', time());
  587. $setting_data[$k]['updated_at'] = date('Y-m-d H:i:s', time());
  588. // 第二步, 根据时长去生成24小时的时间段,也要存id
  589. $timeList = $this->getTimeHoures($v['service_times']);
  590. foreach ($timeList as $kk => $vv) {
  591. $times_data[$k][$kk]['type'] = 2;
  592. $times_data[$k][$kk]['docter_id'] = $doctor_id;
  593. $times_data[$k][$kk]['start_time_period'] = $vv[0];
  594. $times_data[$k][$kk]['end_time_period'] = $vv[1];
  595. $times_data[$k][$kk]['org_id'] = $v['org_id'];
  596. }
  597. }
  598. }
  599. if($times_data&&$setting_data){
  600. foreach ($times_data as $k => $v) {
  601. TimePeriod::insert($v);
  602. }
  603. DocterSetting::insert($setting_data);
  604. }
  605. }
  606. }
  607. DB::commit();
  608. } catch (\Exception $e) {
  609. DB::rollBack();
  610. return out('', 500, $e->getMessage());
  611. } catch (\PDOException $e) {
  612. DB::rollBack();
  613. return out('', 500, $e->getMessage());
  614. }
  615. if ($finds['is_appoint'] != 0 && isset($data['is_appoint']) && !empty($data['is_appoint'])) {
  616. /*去重新更新,自定义排班表,和排班详情表,因为时间段id发生了变化!*/
  617. if ($flag != false) {
  618. $weekList = WeekSchedule::where('docter_id', $doctor_id)->get();
  619. $moth_date = $this->date_bool();
  620. $counts = Schedule::where('schedule_date', '>=', $moth_date[0]['date'])->where('schedule_date', '<=', end($moth_date)['date'])->get();
  621. if ($weekList && $counts) {
  622. $weekList = $weekList->toArray();
  623. $selfScheduleList = SelfSchedule::where('docter_id', $doctor_id)->whereIn('organization_id', $flag)->get();
  624. // 修改自定义表 不存在则不管就好
  625. SchedulePeriod::where('docter_id', '=', $doctor_id)->delete();
  626. if ($selfScheduleList) {
  627. $selfScheduleList = $selfScheduleList->toArray();
  628. $selfList = [];
  629. foreach ($selfScheduleList as $k => $v) {
  630. if (!isset($selfList[$v['schedule_date']])) {
  631. $selfList[$v['schedule_date']] = $v;
  632. if ($v['type'] == 1) {
  633. $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id'];
  634. $selfList[$v['schedule_date']]['ident']['xia_id'] = 0;
  635. $selfList[$v['schedule_date']]['ident']['wan_id'] = 0;
  636. } else if ($v['type'] == 2) {
  637. $selfList[$v['schedule_date']]['ident']['zao_id'] = 0;
  638. $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id'];
  639. $selfList[$v['schedule_date']]['ident']['wan_id'] = 0;
  640. } else {
  641. $selfList[$v['schedule_date']]['ident']['zao_id'] = 0;
  642. $selfList[$v['schedule_date']]['ident']['xia_id'] = 0;
  643. $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id'];
  644. }
  645. } else {
  646. if ($v['type'] == 1) {
  647. $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id'];
  648. } else if ($v['type'] == 2) {
  649. $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id'];
  650. } else {
  651. $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id'];
  652. }
  653. }
  654. }
  655. // 拼接数据交给saveDay来操作
  656. $saveDatas = [];
  657. SelfSchedule::where('docter_id', $doctor_id)->delete();
  658. foreach ($selfList as $k => $v) {
  659. $saveDatas[$k]['schedule_date'] = $v['schedule_date'];
  660. $saveDatas[$k]['week'] = $v['week'];
  661. if ($v['ident']['zao_id']) {
  662. $saveDatas[$k]['type'] = 1;
  663. $saveDatas[$k]['organization_id'] = $v['ident']['zao_id'];
  664. $saveSelf = $this->saveDay($saveDatas[$k]);
  665. if (!$saveSelf) {
  666. return out('', 500, '修改排班失败!');
  667. }
  668. }
  669. if ($v['ident']['xia_id']) {
  670. $saveDatas[$k]['type'] = 2;
  671. $saveDatas[$k]['organization_id'] = $v['ident']['xia_id'];
  672. $saveSelf = $this->saveDay($saveDatas[$k]);
  673. if (!$saveSelf) {
  674. return out('', 500, '修改排班失败!');
  675. }
  676. }
  677. if ($v['ident']['wan_id']) {
  678. $saveDatas[$k]['type'] = 3;
  679. $saveDatas[$k]['organization_id'] = $v['ident']['wan_id'];
  680. $saveSelf = $this->saveDay($saveDatas[$k]);
  681. if (!$saveSelf) {
  682. return out('', 500, '修改排班失败!');
  683. }
  684. }
  685. }
  686. }
  687. Db::beginTransaction();
  688. try {
  689. $selfScheduleList = SelfSchedule::where('docter_id', $doctor_id)->whereIn('organization_id', $flag)->get();
  690. foreach ($counts as $kk => $vv) {
  691. $schedule[$kk]['schedule_date'] = $vv['schedule_date'];
  692. $schedule[$kk]['week'] = $vv['week'];
  693. $sid[$kk] = $vv['id'];
  694. }
  695. // 占用效率
  696. $scheduleLists = [];
  697. foreach ($sid as $kk => $vv) {
  698. foreach ($weekList as $k => $v) {
  699. if ($schedule[$kk]['week'] == $v['week']) {
  700. if ($v['type'] == 1) {
  701. $times = $this->num_time($v['organization_id'], 1);
  702. if (!$times) {
  703. return out('', 500, "请先在排班设置中填写本机构的时间段");
  704. }
  705. $maf = $this->getMaf($vv, $times, ['organization_id' => $v['organization_id'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 1], $doctor_id);
  706. if ($maf) {
  707. foreach ($maf as $os) {
  708. $scheduleLists[] = $os;
  709. }
  710. }
  711. }
  712. if ($v['type'] == 2) {
  713. $times = $this->num_time($v['organization_id'], 2);
  714. if (!$times) {
  715. return out('', 500, "请先在排班设置中填写本机构的时间段");
  716. }
  717. $maf = $this->getMaf($vv, $times, ['organization_id' => $v['organization_id'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 2], $doctor_id);
  718. if ($maf) {
  719. foreach ($maf as $os) {
  720. $scheduleLists[] = $os;
  721. }
  722. }
  723. }
  724. if ($v['type'] == 3) {
  725. $times = $this->num_time($v['organization_id'], 3);
  726. if (!$times) {
  727. return out('', 500, "请先在排班设置中填写本机构的时间段");
  728. }
  729. $maf = $this->getMaf($vv, $times, ['organization_id' => $v['organization_id'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 3], $doctor_id);
  730. if ($maf) {
  731. foreach ($maf as $os) {
  732. $scheduleLists[] = $os;
  733. }
  734. }
  735. }
  736. }
  737. }
  738. }
  739. // 查询重复替换
  740. $chong = [];
  741. if ($selfScheduleList && $scheduleLists) {
  742. foreach ($scheduleLists as $k => $v) {
  743. foreach ($selfScheduleList as $kk => $vv) {
  744. if ($v['schedule_date'] == $vv['schedule_date']) {
  745. $chong[$kk]['schedule_id'] = $v['schedule_id'];
  746. $chong[$kk]['docter_id'] = $v['docter_id'];
  747. $chong[$kk]['order_num'] = $v['order_num'];
  748. $chong[$kk]['organization_id'] = $vv['organization_id'];
  749. $chong[$kk]['time_period_id'] = $vv['time_period_id'];
  750. $chong[$kk]['type'] = $vv['type'];
  751. $chong[$kk]['schedule_date'] = $vv['schedule_date'];
  752. unset($scheduleLists[$k]);
  753. }
  754. }
  755. }
  756. }
  757. $listPeriod = array_merge($chong, $scheduleLists);
  758. SchedulePeriod::insert($listPeriod);
  759. DB::commit();
  760. } catch (\Exception $e) {
  761. DB::rollBack();
  762. return out('', 500, '2' . $$e->getMessage());
  763. } catch (\PDOException $e) {
  764. DB::rollBack();
  765. return out('', 500, '2' . $e->getMessage());
  766. }
  767. }
  768. }
  769. }
  770. }
  771. return out();
  772. }
  773. /**
  774. * 计算24小时的时间区间段
  775. * @param $minute 分钟比如:15
  776. * @return array
  777. */
  778. public function getTimeHoures($minute)
  779. {
  780. // 可选10分钟,15分钟,20分钟,30分钟,1个小时
  781. $start = strtotime(date("Y-m-d 00:00:00"));
  782. $end = strtotime(date("Y-m-d 23:59:59"));
  783. $returnArr = [];
  784. for ($time = $start; $time <= $end; $time = $time + $minute * 60) {
  785. array_push($returnArr, date("H:i", $time));
  786. }
  787. $newList = [];
  788. // for($i=0;$i<count($returnArr)-1;$i++){
  789. // $newList[$i]['start']=$returnArr[$i];
  790. // $newList[$i]['end']=$returnArr[$i+1];
  791. // }
  792. $k = 0;
  793. for ($i = 0; $i < (count($returnArr) * 2) - 1; $i++) {
  794. if ($i % 2 != 0) {
  795. if ($i != 0) {
  796. $k++;
  797. $newList[$k][0] = $returnArr[$k];
  798. }
  799. } else {
  800. if ($i != 0) {
  801. $newList[$k - 1][1] = $returnArr[$k];
  802. } else {
  803. $newList[$k][0] = $returnArr[$k];
  804. }
  805. }
  806. }
  807. $newList[count($newList) - 1][1] = $returnArr[0];
  808. return $newList;
  809. }
  810. /**
  811. * 新修改医生排班设置(废弃)
  812. * @return mixed
  813. * @throws \Exception
  814. */
  815. public function service_schedule()
  816. {
  817. $req = request()->post();
  818. $data = json_decode($req['data'], true);
  819. $user = $this->user;
  820. $doctor_id = $user['id'];
  821. Db::beginTransaction();
  822. try {
  823. if (isset($data) && !empty($data)) {
  824. $setting_data = [];
  825. $times_data = [];
  826. foreach ($data as $k => $v) {
  827. DocterSetting::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete();
  828. TimePeriod::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete();
  829. $setting_data[$k]['docter_id'] = $doctor_id;
  830. $setting_data[$k]['type'] = 1;
  831. $setting_data[$k]['status'] = 2;
  832. $setting_data[$k]['show_days'] = $v['show_days'];
  833. $setting_data[$k]['service_times'] = $v['service_times'];
  834. $setting_data[$k]['service_num'] = $v['service_num'];
  835. $setting_data[$k]['org_id'] = $v['org_id'];
  836. $service_times = [
  837. 1 => ['amStartTime' => $v['amStartTime'], 'amEndTime' => $v['amEndTime'], 'amPerson' => $v['amPerson']],
  838. 2 => ['pmStartTime' => $v['pmStartTime'], 'pmEndTime' => $v['pmEndTime'], 'pmPerson' => $v['pmPerson']],
  839. 3 => ['nightStartTime' => $v['nightStartTime'], 'nightEndTime' => $v['nightEndTime'], 'nightPerson' => $v['nightPerson']],
  840. ];
  841. $setting_data[$k]['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE);
  842. $setting_data[$k]['created_at'] = date('Y-m-d H:i:s', time());
  843. $setting_data[$k]['updated_at'] = date('Y-m-d H:i:s', time());
  844. // 第二步, 根据时长去生成24小时的时间段,也要存id
  845. $timeList = $this->getTimeHoures($v['service_times']);
  846. foreach ($timeList as $kk => $vv) {
  847. $times_data[$k][$kk]['type'] = 2;
  848. $times_data[$k][$kk]['docter_id'] = $doctor_id;
  849. $times_data[$k][$kk]['start_time_period'] = $vv[0];
  850. $times_data[$k][$kk]['end_time_period'] = $vv[1];
  851. $times_data[$k][$kk]['org_id'] = $v['org_id'];
  852. }
  853. }
  854. foreach ($times_data as $k => $v) {
  855. TimePeriod::insert($v);
  856. }
  857. DocterSetting::insert($setting_data);
  858. }
  859. DB::commit();
  860. return out('');
  861. } catch (\Exception $e) {
  862. DB::rollBack();
  863. return out('', 500, $e->getMessage());
  864. } catch (\PDOException $e) {
  865. DB::rollBack();
  866. return out('', 500, $e->getMessage());
  867. }
  868. }
  869. /**
  870. * 提交认证
  871. * Auth:Yuanhang-Liu
  872. * Date:2020/10/14 15:08 *
  873. * @return \Illuminate\Http\JsonResponse
  874. */
  875. public function addthen()
  876. {
  877. $req = request()->post();
  878. $this->validate(request(), [
  879. 'name|医生姓名' => 'required|max:50',
  880. 'sex|性别' => 'required|in:男,女',
  881. 'ID|身份证号' => 'required|min:16|max:18',
  882. 'works|医院信息' => 'required',
  883. 'certificate|医生照片和执业证书' => 'required|string',
  884. 'idPhoto|身份证正反面' => 'required|string',
  885. 'doctorQualification|照片和资格证书' => 'required|string',
  886. ]);
  887. if ($req['sex'] == '男') {
  888. $req['sex'] = 1;
  889. } else {
  890. $req['sex'] = 2;
  891. }
  892. // 首先获取医生姓名,性别,身份证号,照片,身份证,资格证去补全医生表
  893. // 入库organization_ids这个数据是一条字符串,先分割成数组,如果只有一条则医生只选择了一个医院,机构id和医生id入库docter_organization(医生机构关联表)
  894. $user = $this->user;
  895. $doctor_id = $user['id'];
  896. if (!$doctor_id) {
  897. return out(null, 500, '医生信息错误!');
  898. }
  899. $data = [];
  900. $data['name'] = $req['name'];
  901. $data['sex'] = $req['sex'];
  902. $data['card_id'] = $req['ID'];
  903. $data['practice'] = $req['certificate'];
  904. $data['card_photo'] = $req['idPhoto'];
  905. $data['is_quail'] = $req['doctorQualification'];
  906. //处理医院机构id
  907. $work = json_decode($req['works'], true);
  908. if (!$work) {
  909. return out('', '', '缺少医院');
  910. }
  911. $off_then = DocterOrganization::where('docter_id', '=', $doctor_id)->get('id')->toArray();
  912. $is_del = false;
  913. if ($off_then) {
  914. $newids = [];
  915. foreach ($off_then as $k => $v) {
  916. $newids[$k] = $v['id'];
  917. }
  918. $is_del = true;
  919. }
  920. $org_list = [];
  921. foreach ($work as $k => $v) {
  922. if ($v['hospital']) {
  923. $org_list[$k]['docter_id'] = $doctor_id;
  924. $org_list[$k]['organization_id'] = $v['hospital'];
  925. $org_list[$k]['offices_id'] = $v['department'];
  926. $org_list[$k]['qualifications_id'] = $v['qualifications'];
  927. $org_list[$k]['state'] = $v['state'];
  928. }
  929. }
  930. DB::beginTransaction();//开启事务
  931. try {
  932. //补全医生表
  933. Docter::where('id', $doctor_id)->update($data);
  934. if ($is_del) {
  935. foreach ($newids as $k => $v) {
  936. DocterOrganization::where('id', $v)->delete();
  937. }
  938. }
  939. // 提交消息;
  940. DocterMessage::create([
  941. 'docter_id' => $doctor_id,
  942. 'status' => 1,
  943. 'type' => 8,
  944. 'content' => '您已提交医生资质认证审核材料 '
  945. ]);
  946. DocterOrganization::insertOrIgnore($org_list);
  947. DB::commit();//提交至数据库
  948. return out();
  949. } catch (\Exception $e) {
  950. DB::rollback();
  951. return out(null, 500, $e->getMessage());
  952. }
  953. }
  954. /**
  955. * 获取地区/联动医院
  956. * Auth:Yuanhang-Liu
  957. * Date:2020/10/14 17:17 *
  958. * @return \Illuminate\Http\JsonResponse
  959. */
  960. public function get_city_id()
  961. {
  962. // 查询机构!
  963. $req = request()->post();
  964. $this->validate(request(), [
  965. 'level_type' => 'required|in:4',
  966. 'province|省或直辖市id' => 'required_if:level_type,==,4',
  967. 'city|市' => 'required_if:level_type,==,4',
  968. 'area|区' => 'required_if:level_type,==,4',
  969. ]);
  970. // 查找下医院
  971. // $ids_string = explode(',',$req['organizations_ids']);
  972. $province = trim($req['province']);
  973. $city = trim($req['city']);
  974. $area = trim($req['area']);
  975. $where['province_id'] = $province;
  976. $where['city_id'] = $city;
  977. $where['area_id'] = $area;
  978. $where['type'] = 1;
  979. $Organization = Organization::with('offices')->where($where)->get()->toArray();
  980. $qulire = Qualification::where('status', 1)->get();
  981. $newList = [];
  982. if ($Organization) {
  983. foreach ($Organization as $k => $v) {
  984. $newList[$k]['value'] = $v['id'];
  985. $newList[$k]['label'] = $v['name'];
  986. if ($v['offices']) {
  987. foreach ($v['offices'] as $kk => $vv) {
  988. $newList[$k]['children'][$kk]['value'] = $vv['id'];
  989. $newList[$k]['children'][$kk]['label'] = $vv['name'];
  990. if ($qulire) {
  991. foreach ($qulire as $p => $c) {
  992. $newList[$k]['children'][$kk]['children'][$p]['value'] = $c['id'];
  993. $newList[$k]['children'][$kk]['children'][$p]['label'] = $c['name'];
  994. }
  995. } else {
  996. unset($Organization[$k], $newList[$k]);
  997. }
  998. }
  999. } else {
  1000. unset($Organization[$k], $newList[$k]);
  1001. }
  1002. }
  1003. }
  1004. return out($newList);
  1005. }
  1006. /**
  1007. * 获取城市联动
  1008. * @return \Illuminate\Http\JsonResponse
  1009. * @author Liu-Yh
  1010. * Create By 2020/11/4 19:35
  1011. */
  1012. public function getCityList()
  1013. {
  1014. // 查询机构!
  1015. $req = request()->post();
  1016. $where['status'] = 1;
  1017. $data = Areas::where($where)->get(['id', 'name', 'level', 'parent_id'])->toArray();
  1018. $newData = [];
  1019. foreach ($data as $k => $v) {
  1020. $newData[$k]['value'] = $v['id'];
  1021. $newData[$k]['label'] = $v['name'];
  1022. $newData[$k]['pid'] = $v['parent_id'];
  1023. }
  1024. $list = $this->getTrees($newData);
  1025. $list = $this->getTree($list);
  1026. return out($list);
  1027. }
  1028. /**
  1029. * 获取城市树
  1030. * @param $data
  1031. * @return array
  1032. */
  1033. protected function getTrees($arr, $pid = 0)
  1034. {
  1035. static $list = [];
  1036. foreach ($arr as $key => $value) {
  1037. if ($value["pid"] == $pid) {
  1038. $list[] = $value;
  1039. unset($arr[$key]); //删除已经排好的数据为了减少遍历的次数,当然递归本身就很费神就是了
  1040. $this->getTrees($arr, $value["value"]);
  1041. }
  1042. }
  1043. return $list;
  1044. }
  1045. /**
  1046. * 整合树🌲
  1047. * @param $data
  1048. * @param $pId
  1049. * @return string
  1050. */
  1051. protected function getTree($data, $pId = 0)
  1052. {
  1053. $tree = [];
  1054. foreach ($data as $k => $v) {
  1055. if ($v['pid'] == $pId) { //父亲找到儿子
  1056. $chid = $this->getTree($data, $v['value']);
  1057. if ($chid) {
  1058. $v['children'] = $chid;
  1059. }
  1060. $tree[] = $v;
  1061. unset($data[$k]);
  1062. } else {
  1063. unset($data[$k]);
  1064. }
  1065. }
  1066. return $tree;
  1067. }
  1068. /* public function getCityList(){
  1069. // 查询机构!
  1070. $req = request()->post();
  1071. $this->validate(request(), [
  1072. 'type' => 'required|in:1,2,3',
  1073. 'parent_id|父级id' => 'required_if:type,==,2|required_if:type,==,3|integer',
  1074. ]);//1=省,2=市,3=区
  1075. $where['level'] = $req['type'];
  1076. $where['status'] = 1;
  1077. if($req['type']==1){
  1078. $cityList = Areas::where($where)->get(['id','name'])->toArray();
  1079. }else if ($req['type']==2){
  1080. $where['parent_id']= $req['parent_id'];
  1081. $cityList = Areas::where($where)->get(['id','name'])->toArray();
  1082. }else if ($req['type']==3){
  1083. $where['parent_id']= $req['parent_id'];
  1084. $cityList = Areas::where($where)->get(['id','name'])->toArray();
  1085. }else{
  1086. return out('','','错误请求');
  1087. }
  1088. return out($cityList);
  1089. }*/
  1090. /**
  1091. * 获取科室和资质
  1092. * @return mixed
  1093. */
  1094. public function getOfferList()
  1095. {
  1096. // 查询机构!
  1097. $req = request()->post();
  1098. $this->validate(request(), [
  1099. 'type' => 'required|in:1,2',
  1100. ]);//1=科室,2=资质
  1101. $type = $req['type'];
  1102. if ($type == 1) {
  1103. $List = Office::get(['id', 'name'])->toArray();
  1104. } else if ($type == 2) {
  1105. $List = Qualification::get(['id', 'name'])->toArray();
  1106. } else {
  1107. return out('', '', '错误请求');
  1108. }
  1109. return out($List);
  1110. }
  1111. /**
  1112. * 获取我的患者列表
  1113. * Auth:Yuanhang-Liu
  1114. * Date:2020/10/17 13:21
  1115. * @return \Illuminate\Http\JsonResponse
  1116. */
  1117. public function userList()
  1118. {
  1119. $req = request()->post();
  1120. $this->validate(request(), [
  1121. 'userId' => 'integer',
  1122. 'userType|用户类型' => 'integer|in:1,2,3,4,5,6,7',
  1123. ]);
  1124. $user = $this->user;
  1125. $doctor_id = $user['id'];
  1126. if (!$doctor_id) {
  1127. return out(null, 500, '医生信息错误!');
  1128. }
  1129. $returnList = [];
  1130. $orderList = Order::with(['user'])->where('docter_id', '=', $doctor_id)->groupBy('id', 'product_type', 'user_id')->get()->toArray();
  1131. $collections = DocterUser::with('user')->where('docter_id', '=', $doctor_id)->groupBy('user_id')->get()->toArray();
  1132. $newList = [];
  1133. foreach ($orderList as $k => $v) {
  1134. $newList[$k]['order_id'] = $v['id'];
  1135. $newList[$k]['user_id'] = $v['user_id'];
  1136. $newList[$k]['order_sn'] = $v['order_sn'];
  1137. $newList[$k]['nickname'] = $v['user']['nickname'];
  1138. $save = UserDocter::where('user_id', '=', $v['user']['id'])->first();
  1139. if ($save) {
  1140. $newList[$k]['remark'] = $save['remark'];
  1141. } else {
  1142. $newList[$k]['remark'] = '';
  1143. }
  1144. $newList[$k]['avatar'] = $v['user']['avatar'];
  1145. $newList[$k]['product_type'] = $v['product_type'];
  1146. }
  1147. $newcoll = [];
  1148. foreach ($collections as $k => $v) {
  1149. $newcoll[$k]['id'] = $v['id'];
  1150. $newcoll[$k]['user_id'] = $v['user_id'];
  1151. $newcoll[$k]['nickname'] = $v['user']['nickname'];
  1152. $save = UserDocter::where('user_id', '=', $v['user_id'])->first();
  1153. if ($save) {
  1154. $newList[$k]['remark'] = $save['remark'];
  1155. } else {
  1156. $newList[$k]['remark'] = '';
  1157. }
  1158. $newcoll[$k]['avatar'] = $v['user']['avatar'];
  1159. }
  1160. $user_pic = [];
  1161. $user_relation = [];
  1162. $user_vaccines = [];
  1163. $user_guar = [];
  1164. $user_pack = [];
  1165. foreach ($newList as $k => $v) {
  1166. if ($v['product_type'] == 1 || $v['product_type'] == 2) {
  1167. // 咨询患者
  1168. if (!$this->putusers($user_pic, $v['user_id'])) {
  1169. array_push($user_pic, $v);
  1170. }
  1171. }
  1172. if ($v['product_type'] == 3) {
  1173. // 门诊患者
  1174. if (!$this->putusers($user_relation, $v['user_id'])) {
  1175. array_push($user_relation, $v);
  1176. }
  1177. }
  1178. if ($v['product_type'] == 4) {
  1179. // 疫苗患者
  1180. if (!$this->putusers($user_vaccines, $v['user_id'])) {
  1181. array_push($user_vaccines, $v);
  1182. }
  1183. }
  1184. if ($v['product_type'] == 5) {
  1185. // 儿保预约
  1186. if (!$this->putusers($user_guar, $v['user_id'])) {
  1187. array_push($user_guar, $v);
  1188. }
  1189. }
  1190. if ($v['product_type'] == 6) {
  1191. // 服务包
  1192. $OrderPacks = OrderPack::where('order_id', '=', $v['order_id'])->first();
  1193. if ($OrderPacks) {
  1194. $teams = Team::with('docter')->where('id', '=', $OrderPacks['team_id'])->first();
  1195. if ($teams) {
  1196. $teams = $teams->toArray();
  1197. if ($teams['docter']) {
  1198. foreach ($teams['docter'] as $kk => $vv) {
  1199. if ($vv['id'] == $doctor_id) {
  1200. array_push($user_pack, $v);
  1201. }
  1202. }
  1203. }
  1204. }
  1205. }
  1206. }
  1207. }
  1208. $returnList['user_pic']['data'] = $user_pic;
  1209. $returnList['user_relation']['data'] = $user_relation;
  1210. $returnList['user_vaccines']['data'] = $user_vaccines;
  1211. $returnList['user_guar']['data'] = $user_guar;
  1212. $returnList['user_pack']['data'] = $user_pack;
  1213. if (empty($newcoll)) {
  1214. // 关注患者
  1215. $returnList['user_collection']['data'] = [];
  1216. } else {
  1217. $returnList['user_collection']['data'] = $newcoll;
  1218. }
  1219. $returnList['user_pic']['count'] = count($user_pic);
  1220. $returnList['user_relation']['count'] = count($user_relation);
  1221. $returnList['user_vaccines']['count'] = count($user_vaccines);
  1222. $returnList['user_guar']['count'] = count($user_guar);
  1223. $returnList['user_pack']['count'] = count($user_pack);
  1224. $returnList['user_collection']['count'] = count($returnList['user_collection']['data']);
  1225. return out($returnList);
  1226. }
  1227. /**
  1228. * 升级版 in_array
  1229. * @param $data1
  1230. * @param $data2
  1231. * @return bool
  1232. * @author Liu-Yh
  1233. * Create By 2020/11/27 16:18
  1234. */
  1235. protected function putusers($data1, $data2)
  1236. {
  1237. if (empty($data1)) {
  1238. return false;
  1239. }
  1240. $list = [];
  1241. foreach ($data1 as $k => $v) {
  1242. array_push($list, $v['user_id']);
  1243. }
  1244. if (in_array($data2, $list)) {
  1245. return true;
  1246. } else {
  1247. return false;
  1248. }
  1249. }
  1250. /**
  1251. * 上备注
  1252. * @return \Illuminate\Http\JsonResponse
  1253. * @author Liu-Yh
  1254. * Create By 2020/11/27 16:16
  1255. */
  1256. public function remacks()
  1257. {
  1258. $req = request()->post();
  1259. $this->validate(request(), [
  1260. 'remak|备注' => 'required',
  1261. 'id|id' => 'required',
  1262. ]);
  1263. $user = $this->user;
  1264. $user_id = $user['id'];
  1265. $wheres['docter_id'] = $user_id;
  1266. $wheres['user_id'] = $req['id'];
  1267. $save = UserDocter::where($wheres)->first();
  1268. if ($save) {
  1269. UserDocter::where('id', '=', $save['id'])->update([
  1270. 'remark' => $req['remak']
  1271. ]);
  1272. } else {
  1273. UserDocter::create([
  1274. 'docter_id' => $user_id,
  1275. 'user_id' => $req['id'],
  1276. 'remark' => $req['remak']
  1277. ]);
  1278. }
  1279. return out([]);
  1280. }
  1281. /**
  1282. * 评价列表
  1283. * @return \Illuminate\Http\JsonResponse
  1284. * @author Liu-Yh
  1285. * Create By 2020/11/17 17:41
  1286. */
  1287. public function evaluate()
  1288. {
  1289. $req = request()->post();
  1290. $this->validate(request(), [
  1291. 'curPage' => 'required|integer',
  1292. 'pageSize' => 'required|integer',
  1293. ]);
  1294. $pageSize = ($req['curPage'] - 1) * $req['pageSize'];
  1295. $user = $this->user;
  1296. $doctor_id = $user['id'];
  1297. $wheres['docter_id'] = $doctor_id;
  1298. $wheres['status'] = 2;
  1299. $data = Evaluate::with(['order', 'user'])->where($wheres)->skip($pageSize)->take($req['pageSize'])->groupBy('id')->get()->toArray();;
  1300. if ($data) {
  1301. $newList = [];
  1302. foreach ($data as $k => $v) {
  1303. $newList[$k]['order_id'] = $v['order']['order_sn'];
  1304. $newList[$k]['user'] = $v['user']['nickname'];
  1305. $newList[$k]['lv'] = $v['score'];
  1306. $newList[$k]['time'] = $v['created_at'];
  1307. $newList[$k]['evaluate'] = $v['content'];
  1308. }
  1309. return out($newList);
  1310. } else {
  1311. return out([]);
  1312. }
  1313. }
  1314. /**
  1315. * 我的列表进入详情
  1316. * Auth:Yuanhang-Liu
  1317. * Date:2020/10/18 15:21
  1318. * @return \Illuminate\Http\JsonResponse
  1319. */
  1320. public function userListDetile()
  1321. {
  1322. $req = request()->post();
  1323. $this->validate(request(), [
  1324. 'user_id|用户ID' => 'required|integer',
  1325. 'userType|用户类型' => 'integer|in:1,2,3,4,5,6,7',
  1326. ]);
  1327. $user = $this->user;
  1328. // 查询详情;
  1329. $finds_patient = User::with('patients')->where('id', '=', $req['user_id'])->first();
  1330. $remarks = UserDocter::where('user_id', '=', $req['user_id'])->first();
  1331. $finds_order = Order::with('orderPatient')->where('user_id', '=', $req['user_id'])->orderBy('created_at', 'desc')->limit(3)->get();
  1332. if ($finds_order) {
  1333. $finds_order = $finds_order->toArray();
  1334. }
  1335. $userArr = $patientsArr = $orderArr = $fuwArr = [];
  1336. $patientsArr = [];
  1337. $ws['user_id'] = $req['user_id'];
  1338. $ws['product_type'] = 6;
  1339. $fuw_order = Order::with('orderPack')->where($ws)->orderBy('created_at', 'desc')->get();
  1340. if ($fuw_order) {
  1341. $fuw_order = $fuw_order->toArray();
  1342. foreach ($fuw_order as $kk => $vv) {
  1343. $fuwArr[$kk]['order_id'] = $vv['id'];
  1344. if ($vv['order_pack']) {
  1345. foreach ($vv['order_pack'] as $k => $v) {
  1346. $fuwArr[$kk]['id'] = $v['id'];
  1347. $fuwArr[$kk]['pack_name'] = $v['pack_name'];
  1348. $fuwArr[$kk]['pack_intro'] = $v['pack_intro'];
  1349. $fuwArr[$kk]['pack_price'] = $v['pack_price'];
  1350. $fuwArr[$kk]['effective_days'] = $v['effective_days'];
  1351. $fuwArr[$kk]['start_time'] = date('Y-m-d,H:i', $v['start_time']);
  1352. $fuwArr[$kk]['end_time'] = date('Y-m-d,H:i', $v['end_time']);
  1353. }
  1354. }
  1355. }
  1356. }
  1357. if ($finds_patient) {
  1358. $finds_patient = $finds_patient->toArray();
  1359. $userArr['id'] = $finds_patient['id'];
  1360. if ($remarks) {
  1361. $userArr['remark'] = $remarks['remark']; //用户备注
  1362. } else {
  1363. $userArr['remark'] = ''; //用户备注
  1364. }
  1365. $userArr['nickname'] = $finds_patient['nickname'];
  1366. $userArr['avatar'] = $finds_patient['avatar'];
  1367. if ($finds_patient['patients']) {
  1368. foreach ($finds_patient['patients'] as $kk => $vv) {
  1369. $patientsArr[$kk]['id'] = $vv['id'];
  1370. $patientsArr[$kk]['avatar'] = $vv['avatar'];
  1371. $patientsArr[$kk]['name'] = $vv['name'];
  1372. if ($vv['sex'] == 0) {
  1373. $patientsArr[$kk]['sex'] = '未知';
  1374. } elseif ($vv['sex'] == 1) {
  1375. $patientsArr[$kk]['sex'] = '男';
  1376. } else {
  1377. $patientsArr[$kk]['sex'] = '女';
  1378. }
  1379. $patientsArr[$kk]['age'] = numBirthday($vv['birthday']);
  1380. }
  1381. }
  1382. }
  1383. if ($finds_order) {
  1384. foreach ($finds_order as $k => $v) {
  1385. $orderArr[$k]['id'] = $v['id'];
  1386. $orderArr[$k]['order_sn'] = $v['order_sn'];
  1387. if ($v['order_status'] >= 4) {
  1388. $orderArr[$k]['receiving_time'] = date('Y-m-d H:i', $v['receiving_time']);
  1389. $orderArr[$k]['outtime'] = date('Y-m-d H:i', $v['end_time']);
  1390. } else {
  1391. $orderArr[$k]['receiving_time'] = '';
  1392. $orderArr[$k]['outtime'] = '';
  1393. }
  1394. $orderArr[$k]['order_status'] = $v['order_status'];
  1395. $orderArr[$k]['product_type'] = $v['product_type'];
  1396. $orderArr[$k]['created_at'] = $v['created_at'];
  1397. $orderArr[$k]['name'] = $v['order_patient']['name'];
  1398. $orderArr[$k]['birthday'] = numBirthday($v['order_patient']['birthday']);
  1399. }
  1400. }
  1401. // 拼接服务消息
  1402. $wh['user_id'] = $req['user_id'];
  1403. $wh['order_status'] = ['>', 3];
  1404. $wh['product_type'] = 6;
  1405. $fuwuList = [];
  1406. $fuwuInfo = Order::where($wh)->get();
  1407. $fuwuList['fuwu_num'] = count($fuwuInfo);
  1408. $whs['user_id'] = $req['user_id'];
  1409. $whs['order_status'] = ['>', 3];
  1410. $order_nums = Order::where($whs)->get();
  1411. $fuwuList['order_num'] = count($order_nums);
  1412. $pati_nums = Patient::where('user_id', '=', $req['user_id'])->get();
  1413. $fuwuList['pati_num'] = count($pati_nums);
  1414. $returnArr = [
  1415. 'user_arr' => $userArr,
  1416. 'patients_arr' => $patientsArr,//患者档案
  1417. 'order_arr' => $orderArr, //历史问诊
  1418. 'fuwu_arr' => $fuwArr, //已购服务
  1419. 'nums' => $fuwuList,
  1420. ];
  1421. return out($returnArr);
  1422. }
  1423. /**
  1424. * 我的列表进入详情
  1425. * Auth:Yuanhang-Liu
  1426. * Date:2020/10/20 23:21
  1427. * @return \Illuminate\Http\JsonResponse
  1428. */
  1429. public function patientsDetile()
  1430. {
  1431. $req = request()->post();
  1432. $this->validate(request(), [
  1433. 'patient_id|患者ID' => 'required|integer',
  1434. ]);
  1435. $user = $this->user;
  1436. $finds = Patient::where('id', '=', $req['patient_id'])->first();
  1437. if ($finds) {
  1438. $finds = $finds->toArray();
  1439. }
  1440. if ($finds['sex'] == 0) {
  1441. $finds['sex'] = '中性';
  1442. } elseif ($finds['sex'] == 1) {
  1443. $finds['sex'] = '男';
  1444. } else {
  1445. $finds['sex'] = '女';
  1446. }
  1447. switch ($finds['relationship_type']) {
  1448. case 1:
  1449. $finds['relationship_type'] = '父亲';
  1450. break;
  1451. case 2:
  1452. $finds['relationship_type'] = '母亲';
  1453. break;
  1454. case 3:
  1455. $finds['relationship_type'] = '祖父';
  1456. break;
  1457. case 4:
  1458. $finds['relationship_type'] = '祖母';
  1459. break;
  1460. case 5:
  1461. $finds['relationship_type'] = '外祖父';
  1462. break;
  1463. case 6:
  1464. $finds['relationship_type'] = '外祖母';
  1465. break;
  1466. case 7:
  1467. $finds['relationship_type'] = '叔侄';
  1468. break;
  1469. default:
  1470. $finds['relationship_type'] = '其他';
  1471. }
  1472. $finds['age'] = numBirthday($finds['birthday']);
  1473. // 患者单子
  1474. $patient_list = OrderPatient::with('order')->where('patient_id', '=', $req['patient_id'])->groupBy('id', 'order_id')->get();
  1475. $patient_arr = [];
  1476. if ($patient_list) {
  1477. $patient_list = $patient_list->toArray();
  1478. foreach ($patient_list as $k => $v) {
  1479. switch ($v['order']['product_type']) {
  1480. case 1:
  1481. $patient_arr[$k]['product_type'] = '电话咨询';
  1482. break;
  1483. case 2:
  1484. $patient_arr[$k]['product_type'] = '图文咨询';
  1485. break;
  1486. case 3:
  1487. $patient_arr[$k]['product_type'] = '门诊';
  1488. break;
  1489. case 4:
  1490. $patient_arr[$k]['product_type'] = '疫苗接种预约';
  1491. break;
  1492. case 5:
  1493. $patient_arr[$k]['product_type'] = '儿保预约';
  1494. break;
  1495. case 6:
  1496. $patient_arr[$k]['product_type'] = '服务包';
  1497. break;
  1498. case 7:
  1499. $patient_arr[$k]['product_type'] = '充值';
  1500. break;
  1501. default:
  1502. $patient_arr[$k]['product_type'] = '错误';
  1503. }
  1504. switch ($v['order']['order_status']) {
  1505. case 1:
  1506. $patient_arr[$k]['order_status'] = '未支付';
  1507. break;
  1508. case 2:
  1509. $patient_arr[$k]['order_status'] = '待接单';
  1510. break;
  1511. case 3:
  1512. $patient_arr[$k]['order_status'] = '进行中';
  1513. break;
  1514. case 4:
  1515. $patient_arr[$k]['order_status'] = '已完成';
  1516. break;
  1517. case 5:
  1518. $patient_arr[$k]['order_status'] = '已取消';
  1519. break;
  1520. default:
  1521. $patient_arr[$k]['order_status'] = '未知';
  1522. }
  1523. $patient_arr[$k]['created_at'] = $v['created_at'];
  1524. }
  1525. }
  1526. $returnArr = [
  1527. 'patient' => $finds,
  1528. 'patientOrder' => $patient_arr,
  1529. ];
  1530. return out($returnArr);
  1531. }
  1532. /**
  1533. * 关注用户
  1534. * Auth:Yuanhang-Liu
  1535. * Date:2020/10/21 00:21
  1536. * @return \Illuminate\Http\JsonResponse
  1537. */
  1538. public function userFollow()
  1539. {
  1540. $req = request()->post();
  1541. $this->validate(request(), [
  1542. 'user_id|用户ID' => 'required|integer',
  1543. 'is_ley' => 'required',
  1544. ]);
  1545. // 如果ley==false说明要取消关注,反之添加关注
  1546. $user = $this->user;
  1547. $docter_id = $user['id'];
  1548. if ($req['is_ley'] == 1) {
  1549. DocterUser::where('user_id', '=', $req['user_id'])->delete();
  1550. } else {
  1551. DocterUser::create([
  1552. 'user_id' => $req['user_id'],
  1553. 'docter_id' => $user['id'],
  1554. ]);
  1555. }
  1556. return out();
  1557. }
  1558. /**
  1559. * 是否关注用户
  1560. * Auth:Yuanhang-Liu
  1561. * Date:2020/10/21 00:21
  1562. * @return \Illuminate\Http\JsonResponse
  1563. */
  1564. public function getFollows()
  1565. {
  1566. $req = request()->post();
  1567. $this->validate(request(), [
  1568. 'user_id|用户ID' => 'required|integer',
  1569. ]);
  1570. $user = $this->user;
  1571. $docter_id = $user['id'];
  1572. $where['docter_id'] = $docter_id;
  1573. $where['user_id'] = $req['user_id'];
  1574. $find = DocterUser::where($where)->first();
  1575. if ($find) {
  1576. $find = $find->toArray();
  1577. return out(true);
  1578. } else {
  1579. return out(false);
  1580. }
  1581. }
  1582. /**
  1583. * 获取医生所在机构列表
  1584. * Auth:Yuanhang-Liu
  1585. * Date:2020/10/21 00:21
  1586. * @return \Illuminate\Http\JsonResponse
  1587. */
  1588. public function organizationList()
  1589. {
  1590. $user = $this->user;
  1591. $doctor_id = $user['id'];
  1592. $where['docter_id'] = $doctor_id;
  1593. $where['state'] = 1;
  1594. $orgList = DocterOrganization::with('organization')->where($where)->get()->toArray();
  1595. $newList = [];
  1596. foreach ($orgList as $k => $v) {
  1597. $newList[$k]['value'] = $v['organization']['id'];
  1598. $newList[$k]['label'] = $v['organization']['name'];
  1599. }
  1600. return out($newList);
  1601. }
  1602. /**
  1603. * 获取医院的服务时间
  1604. * @return mixed
  1605. */
  1606. public function getOrgTimes()
  1607. {
  1608. $req = request()->post();
  1609. $this->validate(request(), [
  1610. 'org_id|医院id' => 'required',
  1611. ]);
  1612. $user = $this->user;
  1613. $doctor_id = $user['id'];
  1614. $where['docter_id'] = $doctor_id;
  1615. $orgList = DocterSetting::where(['docter_id'=>$doctor_id,'type'=>1,'org_id'=>$req['org_id']])->first();
  1616. $newList = [];
  1617. if($orgList){
  1618. $time = json_decode($orgList['service_time'],true);
  1619. $newList['zao']['amStartTime'] = isset($time[1])?$time[1]['amStartTime']:'';
  1620. $newList['zao']['amEndTime'] = isset($time[1])?$time[1]['amEndTime']:'';
  1621. $newList['zao']['amPerson'] = isset($time[1])?$time[1]['amPerson']:'';
  1622. $newList['zhong']['pmStartTime'] = isset($time[2])?$time[2]['pmStartTime']:'';
  1623. $newList['zhong']['pmEndTime'] = isset($time[2])?$time[2]['pmEndTime']:'';
  1624. $newList['zhong']['pmPerson'] = isset($time[2])?$time[2]['pmPerson']:'';
  1625. $newList['wan']['nightStartTime'] = isset($time[3])?$time[3]['nightStartTime']:'';
  1626. $newList['wan']['nightEndTime'] = isset($time[3])?$time[3]['nightEndTime']:'';
  1627. $newList['wan']['nightPerson'] = isset($time[3])?$time[3]['nightPerson']:'';
  1628. }
  1629. return out($newList);
  1630. }
  1631. /**
  1632. * 获取历史排班时间列表
  1633. */
  1634. public function getLinsList()
  1635. {
  1636. $user = $this->user;
  1637. $doctor_id = $user['id'];
  1638. $newData = [];
  1639. $strim = date('Y-m-d', (time() + (7 - (date('w') == 0 ? 7 : date('w'))) * 24 * 3600));
  1640. $wheres['docter_id'] = $doctor_id;
  1641. $data = Schedule::select(['id', 'schedule_date'])->where($wheres)->whereDate('schedule_date', '>', $strim)->orderBy('schedule_date', 'desc')->get();
  1642. if ($data) {
  1643. $data = $data->toArray();
  1644. } else {
  1645. return out($newData);
  1646. }
  1647. // $newDates = [];
  1648. // foreach ($data as $k=>$v){
  1649. // if((time() + (7 - (date('w') == 0 ? 7 : date('w'))) * 24 * 3600) > strtotime($v['schedule_date'])){
  1650. // array_push($newDates,$data[$k]);
  1651. // }
  1652. // }
  1653. // $data =$newDates;
  1654. // $k=1;
  1655. // foreach ($data as $v){
  1656. // $newData[$k]=$v;
  1657. // $k++;
  1658. // }
  1659. $newData = array_values($data);
  1660. $lab = [];
  1661. $p = 0;
  1662. for ($i = count($newData); $i > 0; $i--) {
  1663. // if ($i%7==0||$i==1){
  1664. //
  1665. // if ($p>=1){
  1666. // $lab[$p-1]['end_time'] = $arr[$i-1];
  1667. // $lab[$p]['start_time'] = $arr[$i-1];
  1668. // if(isset($arr[$i-7])){
  1669. // $lab[$p]['end_time'] = isset($arr[$i-7])?$arr[$i-7]:'error';
  1670. //
  1671. // }else{
  1672. // unset($lab[$p]);
  1673. // }
  1674. //// $lab[$p]['end_time'] = isset($arr[$i-7])?$arr[$i-7]:'error';
  1675. // }else{
  1676. // $lab[$p]['start_time'] = $arr[$i-1];
  1677. // }
  1678. // ++$p;
  1679. // }else{
  1680. // continue;
  1681. // }
  1682. if ($i % 7 == 0 || $i == 1) {
  1683. if ($p >= 1) {
  1684. $lab[$p - 1]['end_time'] = $newData[$i - 1];
  1685. if (isset($newData[$i - 7])) {
  1686. $lab[$p]['start_time'] = $newData[$i - 1];
  1687. $lab[$p]['end_time'] = $newData[$i - 7];
  1688. } else {
  1689. unset($lab[$p]);
  1690. }
  1691. } else {
  1692. $lab[$p]['start_time'] = $newData[$i - 1];
  1693. }
  1694. ++$p;
  1695. } else {
  1696. continue;
  1697. }
  1698. }
  1699. // 审核通过时间拿出来
  1700. $wh['docter_id'] = $doctor_id;
  1701. $wh['service_type'] = 3;
  1702. $wh['status'] = 2;
  1703. $service = ServiceApply::where($wh)->first();
  1704. if ($service) {
  1705. $service = $service;
  1706. } else {
  1707. $service = 0;
  1708. }
  1709. $rtuenList = [
  1710. 'list' => $lab,
  1711. 'service' => $service,
  1712. ];
  1713. return out($rtuenList);
  1714. }
  1715. /**
  1716. * 获取历史排班详情(废弃)
  1717. */
  1718. public function getLinsDetail()
  1719. {
  1720. $req = request()->post();
  1721. $this->validate(request(), [
  1722. 'start_date|开始时间' => 'required',
  1723. 'end_date|结束时间' => 'required',
  1724. ]);
  1725. $user = $this->user;
  1726. $doctor_id = $user['id'];
  1727. $newData = [];
  1728. $req['start_date'] = date("Y-m-d", strtotime($req['start_date']));
  1729. $req['end_date'] = date("Y-m-d", strtotime($req['end_date']));
  1730. // $data = Schedule::with(['schedulePeriod'])->orderBy('id','desc')->get();
  1731. $data = SchedulePeriod::with('organization')->where('docter_id', '=', $doctor_id)->whereBetween('schedule_date', [$req['start_date'], $req['end_date']])->groupBy('schedule_id', 'type')->get();
  1732. if ($data) {
  1733. $data = $data->toArray();
  1734. } else {
  1735. return out($newData);
  1736. }
  1737. $lab = [];
  1738. $datesList = getDateFromList($req['start_date'], $req['end_date']);
  1739. foreach ($data as $k => $v) {
  1740. $lab[$k]['schedule_id'] = $v['schedule_id'];
  1741. $lab[$k]['type'] = $v['type']; // 1=早上,2=下午,3=晚上
  1742. switch (date('w', strtotime($v['schedule_date']))) {
  1743. case "0":
  1744. $lab[$k]['week'] = '周日';
  1745. break;
  1746. case "1":
  1747. $lab[$k]['week'] = '周一';
  1748. break;
  1749. case "2":
  1750. $lab[$k]['week'] = '周二';
  1751. break;
  1752. case "3":
  1753. $lab[$k]['week'] = '周三';
  1754. break;
  1755. case "4":
  1756. $lab[$k]['week'] = '周四';
  1757. break;
  1758. case "5":
  1759. $lab[$k]['week'] = '周五';
  1760. break;
  1761. default:
  1762. $lab[$k]['week'] = '周六';
  1763. }
  1764. $lab[$k]['schedule_date'] = date('m-d', strtotime($v['schedule_date'])); // 日期
  1765. $lab[$k]['name'] = $v['organization']; // 所在医院
  1766. $lab[$k]['flag'] = $v['me_sure']; // 所在医院
  1767. }
  1768. $newLists = [];
  1769. $newReturn = [];
  1770. foreach ($lab as $k => $v) {
  1771. if (!isset($newLists[$v['schedule_id']])) {
  1772. $newLists[$v['schedule_id']] = $v;
  1773. $newReturn[$v['schedule_id']]['schedule_id'] = $v['schedule_id'];
  1774. if ($v['type'] == 1) {
  1775. if ($v['flag'] != 0) {
  1776. $newReturn[$v['schedule_id']]['type']['zao_flag'] = true;
  1777. $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
  1778. $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
  1779. } else {
  1780. $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
  1781. $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
  1782. $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
  1783. }
  1784. $newReturn[$v['schedule_id']]['type']['zao'] = $v['name']['name'];
  1785. $newReturn[$v['schedule_id']]['type']['xia'] = false;
  1786. $newReturn[$v['schedule_id']]['type']['wan'] = false;
  1787. $newReturn[$v['schedule_id']]['type']['zao_id'] = $v['name']['id'];
  1788. $newReturn[$v['schedule_id']]['type']['xia_id'] = 0;
  1789. $newReturn[$v['schedule_id']]['type']['wan_id'] = 0;
  1790. } else if ($v['type'] == 2) {
  1791. if ($v['flag'] != 0) {
  1792. $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
  1793. $newReturn[$v['schedule_id']]['type']['xia_flag'] = true;
  1794. $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
  1795. } else {
  1796. $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
  1797. $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
  1798. $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
  1799. }
  1800. $newReturn[$v['schedule_id']]['type']['zao'] = false;
  1801. $newReturn[$v['schedule_id']]['type']['xia'] = $v['name']['name'];
  1802. $newReturn[$v['schedule_id']]['type']['wan'] = false;
  1803. $newReturn[$v['schedule_id']]['type']['zao_id'] = 0;
  1804. $newReturn[$v['schedule_id']]['type']['xia_id'] = $v['name']['id'];
  1805. $newReturn[$v['schedule_id']]['type']['wan_id'] = 0;
  1806. } else {
  1807. if ($v['flag'] != 0) {
  1808. $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
  1809. $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
  1810. $newReturn[$v['schedule_id']]['type']['wan_flag'] = true;
  1811. } else {
  1812. $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
  1813. $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
  1814. $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
  1815. }
  1816. $newReturn[$v['schedule_id']]['type']['zao'] = false;
  1817. $newReturn[$v['schedule_id']]['type']['xia'] = false;
  1818. $newReturn[$v['schedule_id']]['type']['wan'] = $v['name']['name'];
  1819. $newReturn[$v['schedule_id']]['type']['zao_id'] = 0;
  1820. $newReturn[$v['schedule_id']]['type']['xia_id'] = 0;
  1821. $newReturn[$v['schedule_id']]['type']['wan_id'] = $v['name']['id'];
  1822. }
  1823. $newReturn[$v['schedule_id']]['week'] = $v['week'];
  1824. $newReturn[$v['schedule_id']]['schedule_date'] = $v['schedule_date'];
  1825. $newReturn[$v['schedule_id']]['name'] = $v['name'];
  1826. } else {
  1827. if ($v['type'] == 1) {
  1828. if ($v['flag'] != 0) {
  1829. $newReturn[$v['schedule_id']]['type']['zao_flag'] = true;
  1830. } else {
  1831. $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
  1832. }
  1833. $newReturn[$v['schedule_id']]['type']['zao'] = $v['name']['name'];
  1834. $newReturn[$v['schedule_id']]['type']['zao_id'] = $v['name']['id'];
  1835. } else if ($v['type'] == 2) {
  1836. $newReturn[$v['schedule_id']]['type']['xia'] = $v['name']['name'];
  1837. if ($v['flag'] != 0) {
  1838. $newReturn[$v['schedule_id']]['type']['xia_flag'] = true;
  1839. } else {
  1840. $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
  1841. }
  1842. $newReturn[$v['schedule_id']]['type']['xia_id'] = $v['name']['id'];
  1843. } else {
  1844. $newReturn[$v['schedule_id']]['type']['wan'] = $v['name']['name'];
  1845. if ($v['flag'] != 0) {
  1846. $newReturn[$v['schedule_id']]['type']['wan_flag'] = true;
  1847. } else {
  1848. $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
  1849. }
  1850. $newReturn[$v['schedule_id']]['type']['wan_id'] = $v['name']['id'];
  1851. }
  1852. }
  1853. }
  1854. $returnLists['list'] = array_values($newReturn);
  1855. $instartTimes = $req['start_date'];
  1856. // 判断数据库有没有这个时间段
  1857. $whr['docter_id'] = $doctor_id;
  1858. $whr['schedule_date'] = $instartTimes;
  1859. $finds = Schedule::where($whr)->first();
  1860. if ($finds) {
  1861. $returnLists['save_flag'] = false;
  1862. } else {
  1863. $returnLists['save_flag'] = true;
  1864. }
  1865. return out($returnLists);
  1866. }
  1867. /**
  1868. * 获取周模板详情
  1869. * @return \Illuminate\Http\JsonResponse
  1870. * @author Liu-Yh
  1871. * Create By 2020/12/16 12:09
  1872. */
  1873. public function getLinsDetailnew()
  1874. {
  1875. $req = request()->post();
  1876. $user = $this->user;
  1877. $doctor_id = $user['id'];
  1878. $newData = [];
  1879. // $data = Schedule::with(['schedulePeriod'])->orderBy('id','desc')->get();
  1880. $data = WeekSchedule::with('organization')->where('docter_id', '=', $doctor_id)->groupBy('type', 'week')->orderBy('week', 'asc')->get();
  1881. if ($data) {
  1882. $data = $data->toArray();
  1883. } else {
  1884. return out($newData);
  1885. }
  1886. $lab = [];
  1887. foreach ($data as $k => $v) {
  1888. $lab[$k]['id'] = $v['id'];
  1889. $lab[$k]['type'] = $v['type']; // 1=早上,2=下午,3=晚上
  1890. $lab[$k]['organization_id'] = $v['organization_id']; // 1=早上,2=下午,3=晚上
  1891. $lab[$k]['flag'] = $v['week'];
  1892. switch ($v['week']) {
  1893. case "7":
  1894. $lab[$k]['week'] = '周日';
  1895. break;
  1896. case "1":
  1897. $lab[$k]['week'] = '周一';
  1898. break;
  1899. case "2":
  1900. $lab[$k]['week'] = '周二';
  1901. break;
  1902. case "3":
  1903. $lab[$k]['week'] = '周三';
  1904. break;
  1905. case "4":
  1906. $lab[$k]['week'] = '周四';
  1907. break;
  1908. case "5":
  1909. $lab[$k]['week'] = '周五';
  1910. break;
  1911. default:
  1912. $lab[$k]['week'] = '周六';
  1913. }
  1914. $lab[$k]['name'] = $v['organization']; // 所在医院
  1915. }
  1916. $weekList = ['周一', '周二', '周三', '周四', '周五', '周六', '周日'];
  1917. try {
  1918. $newReturn = [];
  1919. foreach ($lab as $k => $v) {
  1920. if (!isset($newReturn[$v['flag']])) {
  1921. $newReturn[$v['flag']] = $v;
  1922. if ($v['type'] == 1) {
  1923. if ($v['flag'] != 0) {
  1924. $newReturn[$v['flag']]['ident']['zao_flag'] = true;
  1925. $newReturn[$v['flag']]['ident']['xia_flag'] = false;
  1926. $newReturn[$v['flag']]['ident']['wan_flag'] = false;
  1927. } else {
  1928. $newReturn[$v['flag']]['ident']['zao_flag'] = false;
  1929. $newReturn[$v['flag']]['ident']['xia_flag'] = false;
  1930. $newReturn[$v['flag']]['ident']['wan_flag'] = false;
  1931. }
  1932. $newReturn[$v['flag']]['ident']['zao'] = $v['name']['name'];
  1933. $newReturn[$v['flag']]['ident']['xia'] = false;
  1934. $newReturn[$v['flag']]['ident']['wan'] = false;
  1935. $newReturn[$v['flag']]['ident']['zao_id'] = $v['name']['id'];
  1936. $newReturn[$v['flag']]['ident']['xia_id'] = 0;
  1937. $newReturn[$v['flag']]['ident']['wan_id'] = 0;
  1938. } else if ($v['type'] == 2) {
  1939. if ($v['flag'] != 0) {
  1940. $newReturn[$v['flag']]['ident']['zao_flag'] = false;
  1941. $newReturn[$v['flag']]['ident']['xia_flag'] = true;
  1942. $newReturn[$v['flag']]['ident']['wan_flag'] = false;
  1943. } else {
  1944. $newReturn[$v['flag']]['ident']['zao_flag'] = false;
  1945. $newReturn[$v['flag']]['ident']['xia_flag'] = false;
  1946. $newReturn[$v['flag']]['ident']['wan_flag'] = false;
  1947. }
  1948. $newReturn[$v['flag']]['ident']['zao'] = false;
  1949. $newReturn[$v['flag']]['ident']['xia'] = $v['name']['name'];
  1950. $newReturn[$v['flag']]['ident']['wan'] = false;
  1951. $newReturn[$v['flag']]['ident']['zao_id'] = 0;
  1952. $newReturn[$v['flag']]['ident']['xia_id'] = $v['name']['id'];
  1953. $newReturn[$v['flag']]['ident']['wan_id'] = 0;
  1954. } else {
  1955. if ($v['flag'] != 0) {
  1956. $newReturn[$v['flag']]['ident']['zao_flag'] = false;
  1957. $newReturn[$v['flag']]['ident']['xia_flag'] = false;
  1958. $newReturn[$v['flag']]['ident']['wan_flag'] = true;
  1959. } else {
  1960. $newReturn[$v['flag']]['ident']['zao_flag'] = false;
  1961. $newReturn[$v['flag']]['ident']['xia_flag'] = false;
  1962. $newReturn[$v['flag']]['ident']['wan_flag'] = false;
  1963. }
  1964. $newReturn[$v['flag']]['ident']['zao'] = false;
  1965. $newReturn[$v['flag']]['ident']['xia'] = false;
  1966. $newReturn[$v['flag']]['ident']['wan'] = $v['name']['name'];
  1967. $newReturn[$v['flag']]['ident']['zao_id'] = 0;
  1968. $newReturn[$v['flag']]['ident']['xia_id'] = 0;
  1969. $newReturn[$v['flag']]['ident']['wan_id'] = $v['name']['id'];
  1970. }
  1971. $newReturn[$v['flag']]['week'] = $v['week'];
  1972. $newReturn[$v['flag']]['name'] = $v['name'];
  1973. } else {
  1974. if ($v['type'] == 1) {
  1975. if ($v['flag'] != 0) {
  1976. $newReturn[$v['flag']]['ident']['zao_flag'] = true;
  1977. } else {
  1978. $newReturn[$v['flag']]['ident']['zao_flag'] = false;
  1979. }
  1980. $newReturn[$v['flag']]['ident']['zao'] = $v['name']['name'];
  1981. $newReturn[$v['flag']]['ident']['zao_id'] = $v['name']['id'];
  1982. } else if ($v['type'] == 2) {
  1983. $newReturn[$v['flag']]['ident']['xia'] = $v['name']['name'];
  1984. if ($v['flag'] != 0) {
  1985. $newReturn[$v['flag']]['ident']['xia_flag'] = true;
  1986. } else {
  1987. $newReturn[$v['flag']]['ident']['xia_flag'] = false;
  1988. }
  1989. $newReturn[$v['flag']]['ident']['xia_id'] = $v['name']['id'];
  1990. } else {
  1991. $newReturn[$v['flag']]['ident']['wan'] = $v['name']['name'];
  1992. if ($v['flag'] != 0) {
  1993. $newReturn[$v['flag']]['ident']['wan_flag'] = true;
  1994. } else {
  1995. $newReturn[$v['flag']]['ident']['wan_flag'] = false;
  1996. }
  1997. $newReturn[$v['flag']]['ident']['wan_id'] = $v['name']['id'];
  1998. }
  1999. }
  2000. unset($newReturn[$v['flag']]['name']);
  2001. }
  2002. } catch (\Exception $e) {
  2003. var_dump($e->getMessage() . $e->getFile() . $e->getLine());
  2004. }
  2005. $returnLists['list'] = array_values($newReturn);
  2006. return out($returnLists);
  2007. }
  2008. /**
  2009. * 门诊排班(废弃)
  2010. * Auth:Yuanhang-Liu
  2011. * Date:2020/10/21 00:21
  2012. * @return \Illuminate\Http\JsonResponse
  2013. */
  2014. public function scheduling()
  2015. {
  2016. $req = request()->post();
  2017. $this->validate(request(), [
  2018. 'data|数据' => 'required',
  2019. ]);
  2020. $user = $this->user;
  2021. $doctor_id = $user['id'];
  2022. $data = json_decode($req['data'], true);
  2023. $schedule = [];
  2024. $morning = [];//早上
  2025. $afternoon = [];//下午
  2026. $night = [];//晚上
  2027. $zaoTimes = [];
  2028. $zhongTimes = [];
  2029. $wanTimes = [];
  2030. $configs = SystemConfig::get()->toArray();
  2031. if (isset($configs[0]['value']) && !empty($configs[0]['value'])) {
  2032. $zaoTimes[0] = $configs[0]['value'];
  2033. } else {
  2034. $zaoTimes[0] = "09:00";
  2035. }
  2036. if (isset($configs[1]['value']) && !empty($configs[1]['value'])) {
  2037. $zaoTimes[1] = $configs[1]['value'];
  2038. } else {
  2039. $zaoTimes[1] = "12:00";
  2040. }
  2041. if (isset($configs[2]['value']) && !empty($configs[2]['value'])) {
  2042. $zhongTimes[0] = $configs[2]['value'];
  2043. } else {
  2044. $zhongTimes[0] = "13:00";
  2045. }
  2046. if (isset($configs[3]['value']) && !empty($configs[3]['value'])) {
  2047. $zhongTimes[1] = $configs[3]['value'];
  2048. } else {
  2049. $zhongTimes[1] = "18:00";
  2050. }
  2051. if (isset($configs[4]['value']) && !empty($configs[4]['value'])) {
  2052. $wanTimes[0] = $configs[4]['value'];
  2053. } else {
  2054. $wanTimes[0] = "19:00";
  2055. }
  2056. if (isset($configs[5]['value']) && !empty($configs[5]['value'])) {
  2057. $wanTimes[1] = $configs[5]['value'];
  2058. } else {
  2059. $wanTimes[1] = "21:00";
  2060. }
  2061. $morningd = TimePeriod::where('start_time_period', '>=', $zaoTimes[0])->where('end_time_period', '<=', $zaoTimes[1])->get()->toArray();
  2062. $morning = array_column($morningd, 'id');
  2063. $afternoond = TimePeriod::where('start_time_period', '>=', $zhongTimes[0])->where('end_time_period', '<=', $zhongTimes[1])->get()->toArray();
  2064. $afternoon = array_column($afternoond, 'id');
  2065. $nightd = TimePeriod::where('start_time_period', '>=', $wanTimes[0])->where('end_time_period', '<=', $wanTimes[1])->get()->toArray();
  2066. $night = array_column($nightd, 'id');
  2067. // 先进行删除
  2068. DB::beginTransaction();
  2069. try {
  2070. foreach ($data as $k => $v) {
  2071. // 删除
  2072. Schedule::where('schedule_date', '=', $v["schedule_date"])->delete();
  2073. SchedulePeriod::where('schedule_date', '=', $v['schedule_date'])->delete();
  2074. $schedule[$k]['schedule_date'] = $v['schedule_date'];
  2075. $schedule[$k]['schedule_day'] = str_replace('-', '', $v['schedule_date']);
  2076. $schedule[$k]['docter_id'] = $doctor_id;
  2077. $schedule[$k]['organization_id'] = 0;
  2078. $schedule[$k]['per_time_num'] = 10;
  2079. $sid = Schedule::insertGetId($schedule[$k]);
  2080. // 插入详情
  2081. if ($v['hospital'][0]['organization_id']) {
  2082. $maf = $this->getMaf($sid, $morning, ['organization_id' => $v['hospital'][0]['organization_id'], 'schedule_date' => $v['schedule_date'], 'type' => 1], $doctor_id);
  2083. SchedulePeriod::insert($maf);
  2084. }
  2085. if ($v['hospital'][1]['organization_id']) {
  2086. $maf = $this->getMaf($sid, $afternoon, ['organization_id' => $v['hospital'][1]['organization_id'], 'schedule_date' => $v['schedule_date'], 'type' => 2], $doctor_id);
  2087. SchedulePeriod::insert($maf);
  2088. }
  2089. if ($v['hospital'][2]['organization_id']) {
  2090. $maf = $this->getMaf($sid, $night, ['organization_id' => $v['hospital'][2]['organization_id'], 'schedule_date' => $v['schedule_date'], 'type' => 3], $doctor_id);
  2091. SchedulePeriod::insert($maf);
  2092. }
  2093. }
  2094. DB::commit();
  2095. return out('', '', '成功');
  2096. } catch (\Exception $e) {
  2097. DB::rollBack();
  2098. return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage());
  2099. }
  2100. }
  2101. /**
  2102. * 生成时间段
  2103. * @param int $org_id 机构id
  2104. * @param int $type 时间段,1=早上,2=下午,3=晚上
  2105. * @return array|bool
  2106. * @author Liu-Yh
  2107. * Create By 2020/12/15 18:47
  2108. */
  2109. protected function num_time($org_id = 0, $type = 1)
  2110. {
  2111. $user = $this->user;
  2112. $doctor_id = $user['id'];
  2113. $zaoTimes = [];
  2114. $zhongTimes = [];
  2115. $wanTimes = [];
  2116. $where['docter_id'] = $doctor_id;
  2117. $where['type'] = 1;
  2118. $where['org_id'] = $org_id;
  2119. $configs = DocterSetting::where($where)->first();
  2120. if ($configs) {
  2121. $list = json_decode($configs['service_time'], true);
  2122. if (isset($list[1]['amStartTime']) && !empty($list[1]['amStartTime'])) {
  2123. $zaoTimes[0] = $list[1]['amStartTime'];
  2124. } else {
  2125. $zaoTimes[0] = "08:00";
  2126. }
  2127. if (isset($list[1]['amEndTime']) && !empty($list[1]['amEndTime'])) {
  2128. $zaoTimes[1] = $list[1]['amEndTime'];
  2129. } else {
  2130. $zaoTimes[1] = "12:00";
  2131. }
  2132. if (isset($list[2]['pmStartTime']) && !empty($list[2]['pmStartTime'])) {
  2133. $zhongTimes[0] = $list[2]['pmStartTime'];
  2134. } else {
  2135. $zhongTimes[0] = "13:00";
  2136. }
  2137. if (isset($list[2]['pmEndTime']) && !empty($list[2]['pmEndTime'])) {
  2138. $zhongTimes[1] = $list[2]['pmEndTime'];
  2139. } else {
  2140. $zhongTimes[1] = "18:00";
  2141. }
  2142. if (isset($list[3]['nightStartTime']) && !empty($list[3]['nightStartTime'])) {
  2143. $wanTimes[0] = $list[3]['nightStartTime'];
  2144. } else {
  2145. $wanTimes[0] = "19:00";
  2146. }
  2147. if (isset($list[3]['nightEndTime']) && !empty($list[3]['nightEndTime'])) {
  2148. $wanTimes[1] = $list[3]['nightEndTime'];
  2149. } else {
  2150. $wanTimes[1] = "21:00";
  2151. }
  2152. } else {
  2153. return false;
  2154. }
  2155. if ($type == 1) {
  2156. $morningWhere[] = ['start_time_period', '>=', $zaoTimes[0]];
  2157. $morningWhere[] = ['end_time_period', '<=', $zaoTimes[1]];
  2158. $morningWhere['docter_id'] = $doctor_id;
  2159. $morningWhere['org_id'] = $org_id;
  2160. $morningd = TimePeriod::where($morningWhere)->get()->toArray();
  2161. array_pop($morningd);
  2162. $morning = array_column($morningd, 'id');
  2163. return $morning;
  2164. } elseif ($type == 2) {
  2165. $afternoondWhere[] = ['start_time_period', '>=', $zhongTimes[0]];
  2166. $afternoondWhere[] = ['end_time_period', '<=', $zhongTimes[1]];
  2167. $afternoondWhere['docter_id'] = $doctor_id;
  2168. $afternoondWhere['org_id'] = $org_id;
  2169. $afternoond = TimePeriod::where($afternoondWhere)->get()->toArray();
  2170. array_pop($afternoond);
  2171. $afternoon = array_column($afternoond, 'id');
  2172. return $afternoon;
  2173. } elseif ($type == 3) {
  2174. $nightWhere[] = ['start_time_period', '>=', $wanTimes[0]];
  2175. $nightWhere[] = ['end_time_period', '<=', $wanTimes[1]];
  2176. $nightWhere['docter_id'] = $doctor_id;
  2177. $nightWhere['org_id'] = $org_id;
  2178. $nightd = TimePeriod::where($nightWhere)->get()->toArray();
  2179. array_pop($nightd);
  2180. $night = array_column($nightd, 'id');
  2181. return $night;
  2182. } else {
  2183. $morningWhere[] = ['start_time_period', '>=', $zaoTimes[0]];
  2184. $morningWhere[] = ['end_time_period', '<=', $zaoTimes[1]];
  2185. $morningWhere['docter_id'] = $doctor_id;
  2186. $morningWhere['org_id'] = $org_id;
  2187. $morningd = TimePeriod::where($morningWhere)->get()->toArray();
  2188. array_pop($morningd);
  2189. $morning = array_column($morningd, 'id');
  2190. $afternoondWhere[] = ['start_time_period', '>=', $zhongTimes[0]];
  2191. $afternoondWhere[] = ['end_time_period', '<=', $zhongTimes[1]];
  2192. $afternoondWhere['docter_id'] = $doctor_id;
  2193. $afternoondWhere['org_id'] = $org_id;
  2194. $afternoond = TimePeriod::where($afternoondWhere)->get()->toArray();
  2195. array_pop($afternoond);
  2196. $afternoon = array_column($afternoond, 'id');
  2197. $nightWhere[] = ['start_time_period', '>=', $wanTimes[0]];
  2198. $nightWhere[] = ['end_time_period', '<=', $wanTimes[1]];
  2199. $nightWhere['docter_id'] = $doctor_id;
  2200. $nightWhere['org_id'] = $org_id;
  2201. $nightd = TimePeriod::where($nightWhere)->get()->toArray();
  2202. array_pop($nightd);
  2203. $night = array_column($nightd, 'id');
  2204. return [$morning, $afternoon, $night];
  2205. }
  2206. }
  2207. /**
  2208. * 获取俩月日期
  2209. * @return array
  2210. */
  2211. protected function date_bool($start_time = false, $end_time = false)
  2212. {
  2213. $weekarray = array(7, 1, 2, 3, 4, 5, 6);
  2214. $monthDays = [];
  2215. if ($start_time && $end_time) {
  2216. $firstDay = $start_time;
  2217. $lastDay = $end_time;
  2218. } else {
  2219. $firstDay = date('Y-m-01', time());
  2220. $lastDay = date('Y-m-d', strtotime("$firstDay +2 month -1 day"));
  2221. }
  2222. $i = 0;
  2223. while (date('Y-m-d', strtotime("$firstDay +$i days")) <= $lastDay) {
  2224. $monthDays[$i]['date'] = date('Y-m-d', strtotime("$firstDay +$i days"));
  2225. $monthDays[$i]['week'] = $weekarray[date("w", strtotime("$firstDay +$i days"))];
  2226. $i++;
  2227. }
  2228. return $monthDays;
  2229. }
  2230. /**
  2231. * 新版门诊排班(排班周模板)
  2232. * @return mixed
  2233. * @throws \Exception
  2234. */
  2235. public function week_scheduling()
  2236. {
  2237. $req = request()->post();
  2238. $this->validate(request(), [
  2239. 'data|数据' => 'required',
  2240. ]);
  2241. $user = $this->user;
  2242. $doctor_id = $user['id'];
  2243. $data = json_decode($req['data'], true);
  2244. $moth_date = $this->date_bool();
  2245. // 添加到周模板(不管时间)
  2246. $weekList = [];
  2247. $weekModel = new WeekSchedule();
  2248. // 先进行删除
  2249. $counts = Schedule::where('schedule_date', '>=', $moth_date[0]['date'])->where('docter_id',$doctor_id)->where('schedule_date', '<=', end($moth_date)['date'])->get();
  2250. // 12个月平均两个月最短是29天
  2251. $selfWhere['docter_id'] = $doctor_id;
  2252. $selfWhere[] = ['schedule_date','>=',date('Y-m-d',time())];
  2253. $selfScheduleList = SelfSchedule::where($selfWhere)->get();
  2254. $flag = false;
  2255. DB::beginTransaction();
  2256. try {
  2257. $weekModel->where('docter_id', '=', $doctor_id)->where('schedule_type', '=', 1)->delete();
  2258. $delWhere['docter_id'] = $doctor_id;
  2259. $delWhere[] = ['schedule_date','>=',date('Y-m-d',time())];
  2260. SchedulePeriod::where($delWhere)->delete();
  2261. $schedule = [];
  2262. if (count($counts) < 29) {
  2263. $flag = true;
  2264. Schedule::where('docter_id', '=', $doctor_id)->delete();
  2265. foreach ($moth_date as $kk => $vv) {
  2266. $schedule[$kk]['schedule_date'] = $vv['date'];
  2267. $schedule[$kk]['schedule_day'] = str_replace('-', '', $vv['date']);
  2268. $schedule[$kk]['docter_id'] = $doctor_id;
  2269. $schedule[$kk]['organization_id'] = 0;
  2270. $schedule[$kk]['week'] = $vv['week'];
  2271. $schedule[$kk]['per_time_num'] = 10;
  2272. $sid[$kk] = Schedule::insertGetId($schedule[$kk]);
  2273. }
  2274. } else {
  2275. foreach ($counts as $kk => $vv) {
  2276. if ($vv['schedule_date'] >= date('Y-m-d',time())){
  2277. $schedule[$kk]['schedule_date'] = $vv['schedule_date'];
  2278. $schedule[$kk]['week'] = $vv['week'];
  2279. $sid[$kk] = $vv['id'];
  2280. }
  2281. }
  2282. }
  2283. foreach ($data as $k => $v) {
  2284. // 插入详情
  2285. if ($v['identifi']['zao']!=0) {
  2286. $maf[$k]['schedule_type'] = 1;
  2287. $maf[$k]['docter_id'] = $doctor_id;
  2288. $maf[$k]['week'] = $v['week'];
  2289. $maf[$k]['type'] = 1;
  2290. $maf[$k]['organization_id'] = $v['identifi']['zao'];
  2291. $weekList[] = $maf[$k];
  2292. // $times = $this->num_time($v['identifi']['zao'],1);
  2293. // if (!$times){
  2294. // return out('',500,"请先在排班设置中填写本机构的时间段");
  2295. // }
  2296. // $zao_maf=$this->week_getMaf($times,['organization_id'=>$v['identifi']['zao'],'week'=>$v['week'],'type'=>1],$doctor_id);
  2297. // if ($zao_maf){
  2298. // foreach ($zao_maf as $o){
  2299. // $weekList[]=$o;
  2300. // }
  2301. // }
  2302. }
  2303. if ($v['identifi']['zhong']!=0) {
  2304. $maf[$k]['schedule_type'] = 1;
  2305. $maf[$k]['docter_id'] = $doctor_id;
  2306. $maf[$k]['week'] = $v['week'];
  2307. $maf[$k]['type'] = 2;
  2308. $maf[$k]['organization_id'] = $v['identifi']['zhong'];
  2309. $weekList[] = $maf[$k];
  2310. /* $times = $this->num_time($v['identifi']['zhong'],2);
  2311. if (!$times){
  2312. return out('',500,"请先在排班设置中填写本机构的时间段");
  2313. }
  2314. $zhong_maf=$this->week_getMaf($times,['organization_id'=>$v['identifi']['zhong'],'week'=>$v['week'],'type'=>2],$doctor_id);
  2315. if ($zhong_maf){
  2316. foreach ($zhong_maf as $o){
  2317. $weekList[]=$o;
  2318. }
  2319. }*/
  2320. }
  2321. if ($v['identifi']['wan']!=0) {
  2322. $maf[$k]['schedule_type'] = 1;
  2323. $maf[$k]['docter_id'] = $doctor_id;
  2324. $maf[$k]['week'] = $v['week'];
  2325. $maf[$k]['type'] = 3;
  2326. $maf[$k]['organization_id'] = $v['identifi']['wan'];
  2327. $weekList[] = $maf[$k];
  2328. /*$times = $this->num_time($v['identifi']['wan'],3);
  2329. if (!$times){
  2330. return out('',500,"请先在排班设置中填写本机构的时间段");
  2331. }
  2332. $wan_maf=$this->week_getMaf($times,['organization_id'=>$v['identifi']['wan'],'week'=>$v['week'],'type'=>3],$doctor_id);
  2333. if ($wan_maf){
  2334. foreach ($wan_maf as $o){
  2335. $weekList[]=$o;
  2336. }
  2337. }*/
  2338. }
  2339. }
  2340. // 占用效率
  2341. $scheduleLists = [];
  2342. foreach ($sid as $kk => $vv) {
  2343. foreach ($data as $k => $v) {
  2344. if ($schedule[$kk]['week'] == $v['week']) {
  2345. //检查有没有设置时间
  2346. // if ($v['identifi']['zao']==0) {
  2347. // $times = $this->num_time($v['identifi']['zao'], 1);
  2348. // if (!$times) {
  2349. // return out('', 500, "请先在排班设置中填写本机构的时间段1");
  2350. // }
  2351. // }
  2352. if ($v['identifi']['zao']) {
  2353. $times = $this->num_time($v['identifi']['zao'], 1);
  2354. if (!$times) {
  2355. return out('', 500, "请先在排班设置中填写本机构的时间段2");
  2356. }
  2357. $maf = $this->getMaf($vv, $times, ['organization_id' => $v['identifi']['zao'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 1], $doctor_id);
  2358. if ($maf) {
  2359. foreach ($maf as $os) {
  2360. // array_push($scheduleLists, $os);
  2361. $scheduleLists[] = $os;
  2362. }
  2363. }
  2364. }
  2365. if ($v['identifi']['zhong']) {
  2366. $times = $this->num_time($v['identifi']['zhong'], 2);
  2367. if (!$times) {
  2368. return out('', 500, "请先在排班设置中填写本机构的时间段3");
  2369. }
  2370. $maf = $this->getMaf($vv, $times, ['organization_id' => $v['identifi']['zhong'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 2], $doctor_id);
  2371. if ($maf) {
  2372. foreach ($maf as $os) {
  2373. $scheduleLists[] = $os;
  2374. }
  2375. }
  2376. }
  2377. if ($v['identifi']['wan']) {
  2378. $times = $this->num_time($v['identifi']['wan'], 3);
  2379. if (!$times) {
  2380. return out('', 500, "请先在排班设置中填写本机构的时间段4");
  2381. }
  2382. $maf = $this->getMaf($vv, $times, ['organization_id' => $v['identifi']['wan'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 3], $doctor_id);
  2383. if ($maf) {
  2384. foreach ($maf as $os) {
  2385. // array_push($scheduleLists, $os);
  2386. $scheduleLists[] = $os;
  2387. }
  2388. }
  2389. }
  2390. }
  2391. }
  2392. }
  2393. // 查询重复替换
  2394. $chong = [];
  2395. if ($selfScheduleList && $scheduleLists) {
  2396. foreach ($scheduleLists as $k => $v) {
  2397. foreach ($selfScheduleList as $kk => $vv) {
  2398. if ($v['schedule_date'] == $vv['schedule_date']) {
  2399. $chong[$kk]['schedule_id'] = $v['schedule_id'];
  2400. $chong[$kk]['docter_id'] = $v['docter_id'];
  2401. $chong[$kk]['order_num'] = $v['order_num'];
  2402. $chong[$kk]['organization_id'] = $vv['organization_id'];
  2403. $chong[$kk]['time_period_id'] = $vv['time_period_id'];
  2404. $chong[$kk]['type'] = $vv['type'];
  2405. $chong[$kk]['schedule_date'] = $vv['schedule_date'];
  2406. unset($scheduleLists[$k]);
  2407. }
  2408. }
  2409. }
  2410. }
  2411. $listPeriod = array_merge($chong, $scheduleLists);
  2412. SchedulePeriod::insert($listPeriod);
  2413. WeekSchedule::insert($weekList);
  2414. DB::commit();
  2415. return out();
  2416. } catch (\Exception $e) {
  2417. DB::rollBack();
  2418. return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage());
  2419. } catch (\PDOException $e) {
  2420. DB::rollBack();
  2421. return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage());
  2422. }
  2423. }
  2424. /**
  2425. * 修改某一天的数据
  2426. * @author Liu-Yh
  2427. * Create By 2020/12/16 18:46
  2428. */
  2429. public function saveDay($data = [])
  2430. {
  2431. $flag = false;
  2432. if (empty($data)) {
  2433. $req = request()->post();
  2434. $this->validate(request(), [
  2435. 'schedule_date|日期' => 'required',
  2436. 'week|日期' => 'required',
  2437. 'type|日期' => 'required',
  2438. 'organization_id|日期' => 'required',
  2439. ]);
  2440. } else {
  2441. $flag = true;
  2442. $req = $data;
  2443. }
  2444. $user = $this->user;
  2445. $doctor_id = $user['id'];
  2446. $save_data = [];
  2447. $type_data = explode(',', $req['type']);
  2448. DB::beginTransaction();
  2449. try {
  2450. foreach ($type_data as $k => $v) {
  2451. $finds = SelfSchedule::where(['schedule_date' => $req['schedule_date'], 'docter_id' => $doctor_id, 'schedule_type' => 1, 'organization_id' => $req['organization_id']])->delete();
  2452. $times = $this->num_time($req['organization_id'], $v);
  2453. $mf = $this->arrangeDay($times, ['organization_id' => $req['organization_id'], 'week' => $req['week'], 'schedule_date' => $req['schedule_date'], 'type' => $v], $doctor_id);
  2454. if ($mf) {
  2455. foreach ($mf as $v) {
  2456. $save_data[] = $v;
  2457. }
  2458. }
  2459. }
  2460. if (!$flag){
  2461. $lists = Schedule::where(['docter_id'=>$doctor_id,'schedule_date'=>$req['schedule_date']])->first();
  2462. if($lists){
  2463. SchedulePeriod::where(['docter_id'=>$doctor_id,'schedule_date'=>$req['schedule_date']])->delete();
  2464. $chong = [];
  2465. foreach ($save_data as $k => $v) {
  2466. $chong[$k]['schedule_id'] = $lists['id'];
  2467. $chong[$k]['docter_id'] = $v['docter_id'];
  2468. $chong[$k]['order_num'] = 0;
  2469. $chong[$k]['organization_id'] = $v['organization_id'];
  2470. $chong[$k]['time_period_id'] = $v['time_period_id'];
  2471. $chong[$k]['type'] = $v['type'];
  2472. $chong[$k]['schedule_date'] = $v['schedule_date'];
  2473. }
  2474. SchedulePeriod::insert($chong);
  2475. }
  2476. }
  2477. SelfSchedule::insert($save_data);
  2478. DB::commit();
  2479. if ($flag) {
  2480. return true;
  2481. } else {
  2482. return out();
  2483. }
  2484. } catch (\Exception $e) {
  2485. DB::rollBack();
  2486. if ($flag) {
  2487. return false;
  2488. } else {
  2489. return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage());
  2490. }
  2491. } catch (\PDOException $e) {
  2492. DB::rollBack();
  2493. if ($flag) {
  2494. return false;
  2495. } else {
  2496. return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage());
  2497. }
  2498. }
  2499. }
  2500. /**
  2501. * 整理单个修改排班的数据
  2502. * @param $time
  2503. * @param $req
  2504. * @param $doctor_id
  2505. * @return array
  2506. * @author Liu-Yh
  2507. * Create By 2020/12/16 19:00
  2508. */
  2509. protected function arrangeDay($time, $req, $doctor_id)
  2510. {
  2511. $save_data = [];
  2512. foreach ($time as $k => $v) {
  2513. $save_data[$k]['schedule_date'] = $req['schedule_date'];
  2514. $save_data[$k]['week'] = $req['week'];
  2515. $save_data[$k]['schedule_type'] = 1;
  2516. $save_data[$k]['type'] = $req['type'];
  2517. $save_data[$k]['organization_id'] = $req['organization_id'];
  2518. $save_data[$k]['docter_id'] = $doctor_id;
  2519. $save_data[$k]['time_period_id'] = $v;
  2520. }
  2521. return $save_data;
  2522. }
  2523. /**
  2524. * 查看月视图
  2525. * @author Liu-Yh
  2526. * Create By 2020/12/16 19:20
  2527. */
  2528. public function monthDetail()
  2529. {
  2530. $req = request()->post();
  2531. $this->validate(request(), [
  2532. 'start_day|日期' => 'required',
  2533. 'end_day|日期' => 'required',
  2534. ]);
  2535. $user = $this->user;
  2536. $doctor_id = $user['id'];
  2537. $selfScheduleList = SelfSchedule::where('docter_id', '=', $doctor_id)->get();
  2538. $weekSchduleList = WeekSchedule::with('organization')->where('docter_id', '=', $doctor_id)->groupBy('type', 'week')->orderBy('week', 'asc')->get()->toArray();
  2539. // 占用效率
  2540. $scheduleLists = [];
  2541. $moth_date = $this->date_bool($req['start_day'], $req['end_day']);
  2542. $lab=[];
  2543. foreach ($weekSchduleList as $k => $v) {
  2544. $lab[$k]['id'] = $v['id'];
  2545. $lab[$k]['type'] = $v['type']; // 1=早上,2=下午,3=晚上
  2546. $lab[$k]['organization_id'] = $v['organization_id']; // 1=早上,2=下午,3=晚上
  2547. $lab[$k]['flag'] = $v['week'];
  2548. switch ($v['week']) {
  2549. case "7":
  2550. $lab[$k]['week'] = '周日';
  2551. break;
  2552. case "1":
  2553. $lab[$k]['week'] = '周一';
  2554. break;
  2555. case "2":
  2556. $lab[$k]['week'] = '周二';
  2557. break;
  2558. case "3":
  2559. $lab[$k]['week'] = '周三';
  2560. break;
  2561. case "4":
  2562. $lab[$k]['week'] = '周四';
  2563. break;
  2564. case "5":
  2565. $lab[$k]['week'] = '周五';
  2566. break;
  2567. default:
  2568. $lab[$k]['week'] = '周六';
  2569. }
  2570. }
  2571. $newReturn = [];
  2572. $weekList = ['周一', '周二', '周三', '周四', '周五', '周六', '周日'];
  2573. foreach ($lab as $k => $v) {
  2574. if (!isset($newReturn[$v['flag']])) {
  2575. $newReturn[$v['flag']] = $v;
  2576. if ($v['type'] == 1) {
  2577. $newReturn[$v['flag']]['ident']['zao_id'] = $v['organization_id'];
  2578. $newReturn[$v['flag']]['ident']['xia_id'] = 0;
  2579. $newReturn[$v['flag']]['ident']['wan_id'] = 0;
  2580. } else if ($v['type'] == 2) {
  2581. $newReturn[$v['flag']]['ident']['zao_id'] = 0;
  2582. $newReturn[$v['flag']]['ident']['xia_id'] = $v['organization_id'];
  2583. $newReturn[$v['flag']]['ident']['wan_id'] = 0;
  2584. } else {
  2585. $newReturn[$v['flag']]['ident']['zao_id'] = 0;
  2586. $newReturn[$v['flag']]['ident']['xia_id'] = 0;
  2587. $newReturn[$v['flag']]['ident']['wan_id'] = $v['organization_id'];
  2588. }
  2589. } else {
  2590. if ($v['type'] == 1) {
  2591. $newReturn[$v['flag']]['ident']['zao_id'] = $v['organization_id'];
  2592. } else if ($v['type'] == 2) {
  2593. $newReturn[$v['flag']]['ident']['xia_id'] = $v['organization_id'];
  2594. } else {
  2595. $newReturn[$v['flag']]['ident']['wan_id'] = $v['organization_id'];
  2596. }
  2597. }
  2598. }
  2599. $newList = [];
  2600. foreach ($moth_date as $k => $v) {
  2601. $newList[$k]['date'] = $v['date'];
  2602. $newList[$k]['ident']['zao'] = 0;
  2603. $newList[$k]['ident']['xia'] = 0;
  2604. $newList[$k]['ident']['wan'] = 0;
  2605. foreach ($newReturn as $kk => $vv) {
  2606. if ($v['week'] == $vv['flag']) {
  2607. $newList[$k]['date'] = $v['date'];
  2608. $newList[$k]['ident']['zao'] = $vv['ident']['zao_id'];
  2609. $newList[$k]['ident']['xia'] = $vv['ident']['xia_id'];
  2610. $newList[$k]['ident']['wan'] = $vv['ident']['wan_id'];
  2611. }
  2612. }
  2613. }
  2614. $selfList = [];
  2615. if ($selfScheduleList) {
  2616. // 自定义排班数组
  2617. $selfScheduleList = $selfScheduleList->toArray();
  2618. foreach ($selfScheduleList as $k => $v) {
  2619. if (!isset($selfList[$v['schedule_date']])) {
  2620. $selfList[$v['schedule_date']] = $v;
  2621. if ($v['type'] == 1) {
  2622. $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id'];
  2623. $selfList[$v['schedule_date']]['ident']['xia_id'] = 0;
  2624. $selfList[$v['schedule_date']]['ident']['wan_id'] = 0;
  2625. } else if ($v['type'] == 2) {
  2626. $selfList[$v['schedule_date']]['ident']['zao_id'] = 0;
  2627. $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id'];
  2628. $selfList[$v['schedule_date']]['ident']['wan_id'] = 0;
  2629. } else {
  2630. $selfList[$v['schedule_date']]['ident']['zao_id'] = 0;
  2631. $selfList[$v['schedule_date']]['ident']['xia_id'] = 0;
  2632. $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id'];
  2633. }
  2634. } else {
  2635. if ($v['type'] == 1) {
  2636. $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id'];
  2637. } else if ($v['type'] == 2) {
  2638. $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id'];
  2639. } else {
  2640. $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id'];
  2641. }
  2642. }
  2643. }
  2644. foreach ($selfList as $k => $v) {
  2645. foreach ($newList as $kk => $vv) {
  2646. if ($v['schedule_date'] == $vv['date']) {
  2647. $newList[$kk]['date'] = $vv['date'];
  2648. $newList[$kk]['ident']['zao'] = $v['ident']['zao_id'];
  2649. $newList[$kk]['ident']['xia'] = $v['ident']['xia_id'];
  2650. $newList[$kk]['ident']['wan'] = $v['ident']['wan_id'];
  2651. }
  2652. }
  2653. }
  2654. }
  2655. return out($newList);
  2656. }
  2657. /**
  2658. * 获取早中下午的id
  2659. * @param $sid
  2660. * @param $time
  2661. * @param $req
  2662. * @param $doctor_id
  2663. * @return array
  2664. * @author Liu-Yh
  2665. * Create By 2020/11/6 16:27
  2666. */
  2667. protected function getMaf($sid, $time, $req, $doctor_id)
  2668. {
  2669. $maf = [];
  2670. foreach ($time as $k => $v) {
  2671. $maf[$k]['schedule_id'] = $sid;
  2672. $maf[$k]['organization_id'] = $req['organization_id'];
  2673. $maf[$k]['time_period_id'] = $v;
  2674. $maf[$k]['schedule_date'] = $req['schedule_date'];
  2675. $maf[$k]['docter_id'] = $doctor_id;
  2676. $maf[$k]['type'] = $req['type'];
  2677. $maf[$k]['order_num'] = 0;
  2678. }
  2679. return $maf;
  2680. }
  2681. /**
  2682. * 周模板添加数据
  2683. * @param $time
  2684. * @param $req
  2685. * @param $doctor_id
  2686. * @return array
  2687. */
  2688. protected function week_getMaf($time, $req, $doctor_id)
  2689. {
  2690. $maf = [];
  2691. foreach ($time as $k => $v) {
  2692. // $maf[$k]['schedule_id']=$sid;
  2693. // $maf[$k]['schedule_date']=$req['schedule_date'];
  2694. $maf[$k]['type'] = $req['type'];
  2695. $maf[$k]['schedule_type'] = 1;
  2696. $maf[$k]['organization_id'] = $req['organization_id'];
  2697. $maf[$k]['docter_id'] = $doctor_id;
  2698. $maf[$k]['time_period_id'] = $v;
  2699. $maf[$k]['week'] = $req['week'];
  2700. }
  2701. return $maf;
  2702. }
  2703. /**
  2704. * 获取会话列表
  2705. * @return \Illuminate\Http\JsonResponse
  2706. * @author Liu-Yh
  2707. * Create By 2020/11/6 17:11
  2708. */
  2709. public function getUserListMsg()
  2710. {
  2711. $req = request()->post();
  2712. $user = $this->user;
  2713. $doctor_id = $user['id'];
  2714. $where[] = ['product_type', 2];
  2715. $where[] = ['order_status', '>', 2];
  2716. $where[] = ['payment_status', 2];
  2717. $where[] = ['docter_id', $doctor_id];
  2718. $list = Order::with('user')->where($where)->orderBy('receiving_time', 'desc')->get();
  2719. $newList = [];
  2720. if ($list) {
  2721. $list = $list->toArray();
  2722. foreach ($list as $k => $v) {
  2723. $newList[$v['user_id']]['flag'] = 'member_' . $v['user_id'];
  2724. $newList[$v['user_id']]['order_status'] = $v['order_status'];
  2725. $newList[$v['user_id']]['nickname'] = $v['user']['nickname'];
  2726. $newList[$v['user_id']]['avatar'] = $v['user']['avatar'];
  2727. $newList[$v['user_id']]['remark'] = !empty($v['user']['remark'])?$v['user']['remark']:'';
  2728. }
  2729. $newList = array_values($newList);
  2730. }
  2731. return out($newList);
  2732. }
  2733. /**
  2734. * 获取认证信息
  2735. * @return mixed
  2736. */
  2737. public function getRenInfo()
  2738. {
  2739. $req = request()->post();
  2740. $user = $this->user;
  2741. $doctor_id = $user['id'];
  2742. // 获取本人认证信息
  2743. $returnRes = [];
  2744. $docter = Docter::where('id', '=', $doctor_id)->first();
  2745. if ($docter) {
  2746. $docter = $docter->toArray();
  2747. } else {
  2748. return $docter;
  2749. }
  2750. $returnRes['info'] = $docter;
  2751. // 获取申请的认证机构
  2752. $org = DocterOrganization::with(['organization'])->where('docter_id', '=', $doctor_id)->get();
  2753. $oqf = DocterOrganization::with(['office', 'qualification'])->where('docter_id', '=', $doctor_id)->get();
  2754. foreach ($org as $k => $v) {
  2755. $org[$k]['province'] = Areas::where('id', '=', $v['organization']['province_id'])->select('name')->first()['name'];
  2756. $org[$k]['city'] = Areas::where('id', '=', $v['organization']['city_id'])->select('name')->first()['name'];
  2757. $org[$k]['area'] = Areas::where('id', '=', $v['organization']['area_id'])->select('name')->first()['name'];
  2758. $org[$k]['name'] = $v['organization']['name'];
  2759. }
  2760. $returnRes['orgList'] = $org;
  2761. $returnRes['oqf'] = $oqf;
  2762. return out($returnRes);
  2763. }
  2764. /**
  2765. * 获取通话记录
  2766. * @return mixed
  2767. */
  2768. public function callLog(){
  2769. $req = request()->post();
  2770. $user = $this->user;
  2771. $doctor_id = $user['id'];
  2772. $where =[];
  2773. if(isset($req['order_id'])&&!empty($req['order_id'])){
  2774. $where['order_id'] = $req['order_id'];
  2775. }
  2776. $where['docter_id'] = $doctor_id;
  2777. $list = CallLog::where($where)->get();
  2778. return out($list);
  2779. }
  2780. /**
  2781. * 通话列表
  2782. * @return mixed
  2783. */
  2784. public function user_call(){
  2785. $req = request()->post();
  2786. $user = $this->user;
  2787. $doctor_id = $user['id'];
  2788. $list=[];
  2789. // var_dump($doctor_id);
  2790. //die();
  2791. if(isset($req['user_id'])&&!empty($req['user_id'])){
  2792. $ids = [];
  2793. $orderList = Order::where(['user_id'=>$req['user_id'],'product_type'=>1,'payment_status'=>2])->select('id')->get();
  2794. if($orderList){
  2795. foreach ($orderList as $k=>$v){
  2796. $ids[$k] = $v['id'];
  2797. }
  2798. }
  2799. $lists = CallLog::with('orders')->whereIn('order_id',$ids)->orderBy('call_time', 'desc')->get();
  2800. if ($lists){
  2801. foreach ($lists as $k=>$v){
  2802. $list[$k]['time'] = $v['call_time'];
  2803. $list[$k]['talk_time'] = $v['talk_time'];
  2804. $list[$k]['order_sn'] = $v['orders']['order_sn'];
  2805. }
  2806. }
  2807. }else{
  2808. $orderList = Order::with(['user','calllog'])->where(['docter_id'=>$doctor_id,'product_type'=>1,'payment_status'=>2])->groupBy(['id','user_id'])->get();
  2809. if ($orderList){
  2810. foreach ($orderList as $k=>$v){
  2811. $list[$k]['user'] = $v['user'];
  2812. if ($v['calllog']){
  2813. $dates = $v['calllog']->toArray();
  2814. $list[$k]['user']['dates'] = end($dates)['call_time'];
  2815. }else{
  2816. $list[$k]['user']['dates'] = '无';
  2817. }
  2818. $save = UserDocter::where(['user_id'=>$v['user']['id'],'docter_id'=>$doctor_id])->first();
  2819. if ($save) {
  2820. $list[$k]['user']['remark'] = $save['remark'];
  2821. } else {
  2822. $list[$k]['user']['remark'] = '';
  2823. }
  2824. $list[$k]['user']['log'] = $v['calllog'];
  2825. // $list[$k]['log']['date'] = date('m/d',strtotime(end($v['calllog'])['call_time']));
  2826. }
  2827. }
  2828. }
  2829. return out($list);
  2830. }
  2831. /**
  2832. * 获取聊天记录
  2833. * @return mixed
  2834. */
  2835. public function getImList(){
  2836. $req = request()->post();
  2837. $user = $this->user;
  2838. $doctor_id = $user['id'];
  2839. $where =[];
  2840. if(!isset($req['flag'])||empty($req['flag'])){
  2841. return out("",500,'用户flag不能为空');
  2842. }
  2843. $list = ImMessage::where(['senderId'=>'doctor_'.$doctor_id,'receiverId'=>$req['flag']])->orWhere(function ($query) use ($req,$doctor_id){
  2844. $query->where(['senderId'=>$req['flag'],'receiverId'=>'doctor_'.$doctor_id]);
  2845. })->get();
  2846. $newList=[];
  2847. if ($list){
  2848. foreach ($list as $k=>$v){
  2849. $decode = json_decode($v['text'],true);
  2850. // $newList[$k]['id']=$decode['id'];
  2851. $newList[$k]['messageId']=$decode[0]['messageId'];
  2852. $newList[$k]['type']=$decode[0]['type'];
  2853. $newList[$k]['senderId']=$decode[0]['senderId'];
  2854. $newList[$k]['receiverId']=$decode[0]['receiverId'];
  2855. $newList[$k]['timestamp']=$decode[0]['timestamp'];
  2856. $newList[$k]['payload']= json_decode($decode[0]['payload'],true);
  2857. }
  2858. }
  2859. return out($newList);
  2860. }
  2861. }