DoctorController.php 131 KB

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