123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213 |
- <?php
- /**
- * Created by PhpStorm.
- * User: Yuanhang Liu & Xiaoyun Liu
- * Date: 20-10-14
- * Time: 下午2:50
- */
- namespace App\Http\Controllers\Api\V2;
- use App\Http\Controllers\Api\V1\AuthController;
- use App\Models\Docter;
- use App\Models\Office;
- use App\Models\Order;
- use App\Models\OrderPack;
- use App\Models\OrderPatient;
- use App\Models\Patient;
- use App\Models\Qualification;
- use App\Models\Suggest;
- use App\Models\Areas;
- use App\Models\Collection as Collections;
- use App\Models\Organization;
- use App\Models\DocterTimes;
- use App\Models\DocterOrganization;
- use App\Http\Controllers\Api\V2\CommonController as Commons;
- use App\Models\Team;
- use App\Models\User;
- use Illuminate\Support\Facades\DB;
- use MongoDB\BSON\ObjectId;
- use PhpParser\Comment\Doc;
- use App\Models\DocterUser;
- use App\Models\Schedule;
- use App\Models\TimePeriod;
- use App\Models\SchedulePeriod;
- use App\Models\DocterMessage;
- use App\Models\Evaluate;
- use App\Models\UserDocter;
- use App\Models\ServiceApply;
- use App\Models\SystemConfig;
- use App\Models\WeekSchedule;
- use App\Models\SelfSchedule;
- use App\Models\DocterSetting;
- use App\Models\DocterServiceTimes;
- use App\Models\CallLog;
- use App\Models\ImMessage;
- use App\Models\DocterLable;
- use App\Models\SchedueFlags as Sflag;
- /**
- * 医生相关类
- * Auth Yuanhang Liu
- * Date 2020/10/14 15:06
- * Class DoctorController
- * @package App\Http\Controllers\Api\V2
- */
- class DoctorController extends AuthController
- {
- /**service_schedule
- * @return \Illuminate\Http\JsonResponse
- * 首页医生个人信息接口
- */
- public function doctorInfor()
- {
- $req = $this->user;
- $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']);
- if (!empty($data)) {
- // 获取标签
- $LabFind = [];
- if ($data['label']!='无'){
- if(count($data['label'])!=0){
- $labstr = $data['label'];
- $LabFind = DocterLable::whereIn('id',$labstr)->where('status',1)->select('label_name')->get();
- }
- }
- $data['label'] = $LabFind;
- // $counts = Evaluate::where('docter_id', '=', $req['id'])->count();
- $evalList = Evaluate::where('docter_id', '=', $req['id'])->get();
- $counts = count($evalList);
- $data['eva_num'] = $counts;
- $soc = 0;
- if ($counts != 0) {
- $evalList = $evalList->toArray();
- foreach ($evalList as $k => $v) {
- $soc += $v['score'];
- }
- $data['score'] = upDecimal($soc / $counts, 1);
- }
- $data['service_days'] = numDays(date('Y-m-d', strtotime($data['created_at'])));
- return out($data);
- } else {
- return exit_out($data, 1, '参数错误,数据不存在');
- }
- }
- /**
- * 医生端个人信息修改
- * @return mixed
- */
- public function doctorInfoEdit()
- {
- $user = $this->user;
- $doctor_id = $user['id'];
- if (request()->isMethod('post')) {
- $req = request()->post();
- $this->validate(request(), [
- 'avatar' => 'string',
- 'sign' => 'max:255',
- // 'phone|手机号不正确' => 'regex:/^1[3456789][0-9]{9}$/',
- 'intro' => 'max:2555'
- ]);
- $data = [];
- if (isset($req['avatar']) && !empty($req['avatar'])) {
- $data['avatar'] = $req['avatar'];
- }
- if (isset($req['sign']) && !empty($req['sign'])) {
- $data['sign'] = $req['sign'];
- }
- if (isset($req['intro']) && !empty($req['intro'])) {
- $data['intro'] = $req['intro'];
- }
- if (empty($data)) {
- return out();
- }
- if ($doctor_id) {
- $save = Docter::where('id', $doctor_id)->update($data);
- return out();
- }
- } else {
- // get提交哈
- $list = Docter::where('id', '=', $doctor_id)->first()->toArray();
- // 头像,个人标签,服务简介展示
- $data = [
- 'avatar' => !empty($list['avatar'])?$list['avatar']:'',
- 'sign' => !empty($list['sign'])?$list['sign']:'',
- 'intro' => !empty($list['intro'])?$list['intro']:'',
- ];
- return out($data);
- }
- }
- /**
- * 修改密码
- * @return \Illuminate\Http\JsonResponse
- * @author Liu-Yh
- * Create By 2020/11/4 18:19
- */
- public function passwordEdit()
- {
- $user = $this->user;
- $doctor_id = $user['id'];
- $req = request()->post();
- $this->validate(request(), [
- 'lis:原密码' => 'string',
- 'newpassword:新密码' => 'string',
- ]);
- $data = [];
- $data = Docter::where('id', '=', $doctor_id)->first()->toArray();
- $password = md5(md5(md5($req['newpassword'])));
- if ($data['password'] == '' || !$data['password']) {
- // 说明第一次直接跳过
- $save = Docter::where('id', $doctor_id)->update(['password' => $password]);
- return out();
- } else {
- if(isset($req['lis'])&&!empty($req['lis'])){
- $oldpassword = md5(md5(md5($req['lis'])));
- if ($oldpassword != $data['password']) {
- return out('', '401', '旧密码错误');
- } else {
- $save = Docter::where('id', $doctor_id)->update(['password' => $password]);
- return out();
- }
- }else{
- return out('', '401', '请输入旧密码');
- }
- }
- }
- /**
- * 基本/更多设置读取(废弃)
- * @return \Illuminate\Http\JsonResponse
- * @author Yuanhang Liu
- */
- public function getSettingList()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'type' => 'required|integer|in:1,2',
- 'service_type' => 'integer'
- ]);
- $user = $this->user;
- $doctor_id = (new Commons)->getUserIdByDoctorId($user['phone']);
- $finds = Docter::select(['is_chat', 'is_phone', 'is_appoint'])->where('id', $doctor_id)->first()->toArray();
- $finds['is_chat'] = $finds['is_chat'] == 0 ? false : true;
- $finds['is_phone'] = $finds['is_phone'] == 0 ? false : true;
- $finds['is_appoint'] = $finds['is_appoint'] == 0 ? false : true;
- $finds['is_chat_status'] = $this->getStyStatus(1);
- $finds['is_phone_status'] = $this->getStyStatus(2);
- $finds['is_appoint_status'] = $this->getStyStatus(3);
- if ($req['type'] == 2) {
- (array)$list = [];
- // 获取显示状态:
- $list['show'] = $finds;
- // 获取电话咨询时间
- $phone_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 1])->first();
- if ($phone_fins) {
- $phone_fins = $phone_fins->toArray();
- } else {
- $phone_fins = [];
- }
- $list['list']['phone'] = $phone_fins;
- // 图文咨询时间
- $pic_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 2])->first();
- if ($pic_fins) {
- $pic_fins = $pic_fins->toArray();
- } else {
- $pic_fins = [];
- }
- $list['list']['chat'] = $pic_fins;
- // 门诊咨询时间
- $men_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 3])->get();
- if ($men_fins) {
- $men_fins = $men_fins->toArray();
- } else {
- $men_fins = [];
- }
- $list['list']['men'] = $men_fins;
- // 获取医院
- $org = DocterOrganization::with('organization')->where('docter_id', $doctor_id)->get();
- $org_pre = [];
- $org_pres = [];
- if ($org) {
- $org = $org->toArray();
- foreach ($org as $k => $v) {
- $org_pres[$k]['id'] = $v['organization']['id'];
- $org_pres[$k]['name'] = $v['organization']['name'];
- $org_pre[$k]['name'] = $v['organization']['name'];
- }
- }
- $list['org'] = $org_pre;
- $list['orgs'] = $org_pres;
- $times = TimePeriod::get();
- if ($times) {
- $times = $times->toArray();
- $newTimes = [];
- foreach ($times as $k => $v) {
- $newTimes[$k]['id'] = $v['id'];
- $newTimes[$k]['name'] = $v['start_time_period'] . ' - ' . $v['end_time_period'];
- $newTimes[$k]['checked'] = false;
- }
- $times1 = [];
- $times2 = [];
- $times3 = [];
- foreach ($newTimes as $k => $v) {
- if ($k >= 0 && $k < 16) {
- array_push($times1, $v);
- } else if ($k >= 16 && $k < 32) {
- array_push($times2, $v);
- } else {
- array_push($times3, $v);
- }
- }
- $list['times']['list1'] = $times1;
- $list['times']['list2'] = $times2;
- $list['times']['list3'] = $times3;
- } else {
- $times = [];
- }
- return out($list);
- }
- return out($finds);
- }
- /**
- * 更多设置读取,新的
- * @return \Illuminate\Http\JsonResponse
- * @author Liu-Yh
- * Create By 2020/12/16 11:10
- */
- public function getSettingListnew()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'type' => 'required|integer|in:1,2',
- 'service_type' => 'integer'
- ]);
- $user = $this->user;
- $doctor_id = (new Commons)->getUserIdByDoctorId($user['phone']);
- $finds = Docter::select(['is_chat', 'is_phone', 'is_appoint'])->where('id', $doctor_id)->first()->toArray();
- $finds['is_chat'] = $finds['is_chat'] == 0 ? false : true;
- $finds['is_phone'] = $finds['is_phone'] == 0 ? false : true;
- $finds['is_appoint'] = $finds['is_appoint'] == 0 ? false : true;
- $finds['is_chat_status'] = $this->getStyStatus(1);
- $finds['is_phone_status'] = $this->getStyStatus(2);
- $finds['is_appoint_status'] = $this->getStyStatus(3);
- if ($req['type'] == 2) {
- (array)$list = [];
- // 获取显示状态:
- $list['show'] = $finds;
- // 获取电话咨询时间
- $phone_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 1])->first();
- if ($phone_fins) {
- $phone_fins = $phone_fins->toArray();
- $phone_fins['service_time'] = json_decode($phone_fins['service_time']);
- } else {
- $phone_fins = [];
- }
- $list['list']['phone'] = $phone_fins;
- // 图文咨询时间
- $pic_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 2])->first();
- if ($pic_fins) {
- $pic_fins = $pic_fins->toArray();
- $pic_fins['service_time'] = json_decode($pic_fins['service_time']);
- } else {
- $pic_fins = [];
- }
- $list['list']['chat'] = $pic_fins;
- // 门诊咨询时间
- $newLists=[];
- $men_fins = DocterSetting::where(['docter_id' => $doctor_id, 'type' => 1])->orderBy('org_id','asc')->get();
- $org = DocterOrganization::with('organization')->where(['docter_id'=>$doctor_id,'state'=>1])->orderBy('organization_id','asc')->get();
- if ($org) {
- $org = $org->toArray();
- foreach ($org as $k => $v) {
- $org_pre[$k]['id'] = $v['organization']['id'];
- $org_pre[$k]['name'] = $v['organization']['name'];
- }
- }
- if ($men_fins) {
- $men_fins = $men_fins->toArray();
- foreach ($men_fins as $k => $v) {
- $men_fins[$k]['service_time'] = json_decode($v['service_time'],true);
- }
- $org_list=[];
- foreach ($org as $k=>$v){
- $org_list[$k]['docter_id'] = $doctor_id;
- $org_list[$k]['type'] = 1;
- $org_list[$k]['status'] = 2;
- $org_list[$k]['show_days'] = '';
- $org_list[$k]['service_times'] = '';
- $org_list[$k]['service_num'] = '';
- $org_list[$k]['org_id'] = $v['organization']['id'];
- $org_list[$k]['org_name'] = $v['organization']['name'];
- $org_list[$k]['appoint_price'] = '';
- $org_list[$k]['service_time'] = [
- 1=>['amStartTime'=>'','amEndTime'=>'','amPerson'=>''],
- 2=>['pmStartTime'=>'','pmEndTime'=>'','pmPerson'=>''],
- 3=>['nightStartTime'=>'','nightEndTime'=>'','nightPerson'=>''],
- ];
- }
- foreach ($org_list as $k=>$v){
- foreach ($men_fins as $kk=>$vv){
- if ($v['org_id']==$vv['org_id']){
- $org_list[$k]['docter_id'] = $doctor_id;
- $org_list[$k]['type'] = 1;
- $org_list[$k]['status'] = 2;
- $org_list[$k]['show_days'] = $vv['show_days'];
- $org_list[$k]['service_times'] = $vv['service_times'];
- $org_list[$k]['service_num'] = $vv['service_num'];
- $org_list[$k]['org_id'] = $vv['org_id'];
- $org_list[$k]['org_name'] = $v['org_name'];
- $org_list[$k]['appoint_price'] = $vv['appoint_price'];
- $org_list[$k]['service_time'] = [
- 1=>['amStartTime'=>$vv['service_time'][1]['amStartTime'],'amEndTime'=>$vv['service_time'][1]['amEndTime'],'amPerson'=>$vv['service_time'][1]['amPerson']],
- 2=>['pmStartTime'=>$vv['service_time'][2]['pmStartTime'],'pmEndTime'=>$vv['service_time'][2]['pmEndTime'],'pmPerson'=>$vv['service_time'][2]['pmPerson']],
- 3=>['nightStartTime'=>$vv['service_time'][3]['nightStartTime'],'nightEndTime'=>$vv['service_time'][3]['nightEndTime'],'nightPerson'=>$vv['service_time'][3]['nightPerson']],
- ];
- }
- }
- }
- $newLists = $org_list;
- } else {
- $men_fins = [];
- foreach ($org as $k=>$v){
- $newLists[$k]['docter_id'] = $doctor_id;
- $newLists[$k]['type'] = 1;
- $newLists[$k]['status'] = 2;
- $newLists[$k]['show_days'] = '';
- $newLists[$k]['service_times'] = '';
- $newLists[$k]['service_num'] = '';
- $newLists[$k]['org_id'] = $v['organization']['id'];
- $newLists[$k]['org_name'] = $v['organization']['name'];
- $newLists[$k]['appoint_price'] = '';
- $newLists[$k]['service_time'] = [
- 1=>['amStartTime'=>'','amEndTime'=>'','amPerson'=>''],
- 2=>['pmStartTime'=>'','pmEndTime'=>'','pmPerson'=>''],
- 3=>['nightStartTime'=>'','nightEndTime'=>'','nightPerson'=>''],
- ];
- }
- }
- // 获取医院
- // $org_pre = [];
- $list['list']['men'] = $newLists;
- // $list['org'] = $org_pre;
- return out($list);
- }
- return out($finds);
- }
- /**
- * 获取审核状态
- * @param $type
- * @return bool
- */
- public function getStyStatus($type)
- {
- $user = $this->user;
- $doctor_id = $user['id'];
- $where['docter_id'] = $doctor_id;
- $where['service_type'] = $type;
- $statusD = ServiceApply::where($where)->first();
- if ($statusD) {
- return $statusD;
- } else {
- return false;
- }
- }
- /**
- * 基本/更多设置修改
- * @return \Illuminate\Http\JsonResponse
- * @author Yuanhang Liu
- */
- public function saveSettingList()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'type' => 'required|integer|in:1,2',
- ]);
- $data = json_decode($req['data'], true);
- $user = $this->user;
- $doctor_id = $user['id'];
- $finds = Docter::select(['is_chat', 'is_phone', 'is_appoint'])->where('id', $doctor_id)->first();
- $flag = false;
- if ($req['type'] == 1) {
- // 修改基本信息
- $list = [];
- isset($data['is_chat']) ? $data['is_chat'] == true ? $list['is_chat'] = 1 : $list['is_chat'] = 0 : '';
- isset($data['is_phone']) ? $data['is_phone'] == true ? $list['is_phone'] = 1 : $list['is_phone'] = 0 : '';
- isset($data['is_appoint']) ? $data['is_appoint'] == true ? $list['is_appoint'] = 1 : $list['is_appoint'] = 0 : '';
- Docter::where('id', $doctor_id)->update($list);
- return out();
- } else if ($req['type'] == 2) {
- Db::beginTransaction();
- try {
- // 修改更多信息
- if ($finds['is_chat'] == 0) {
- if (isset($data['is_chat']) && !empty($data['is_chat'])) {
- unset($data['is_chat']);
- }
- } else {
- if (isset($data['is_chat']) && !empty($data['is_chat'])) {
- DocterServiceTimes::where(['docter_id'=>$doctor_id,'type'=>2])->delete();
- $save_data = $data['is_chat'];
- $newData = [];
- $serviceData = [];
- $newData['base_price'] = $save_data['base_price'];
- $newData['step_price'] = $save_data['step_price'];
- $serviceData[0]['docter_id']=$doctor_id;
- $serviceData[0]['type']=2;
- $serviceData[0]['start_time_period']=$save_data['amStartTime'];
- $serviceData[0]['end_time_period']=$save_data['amEndTime'];
- $serviceData[0]['start_time_line']=str_replace(':','',$save_data['amStartTime']);
- $serviceData[0]['end_time_line']=str_replace(':','',$save_data['amEndTime']);
- $serviceData[1]['docter_id']=$doctor_id;
- $serviceData[1]['type']=2;
- $serviceData[1]['start_time_period']=$save_data['pmStartTime'];
- $serviceData[1]['end_time_period']=$save_data['pmEndTime'];
- $serviceData[1]['start_time_line']=str_replace(':','',$save_data['pmStartTime']);
- $serviceData[1]['end_time_line']=str_replace(':','',$save_data['pmEndTime']);
- $serviceData[2]['docter_id']=$doctor_id;
- $serviceData[2]['type']=2;
- $serviceData[2]['start_time_period']=$save_data['nightStartTime'];
- $serviceData[2]['end_time_period']=$save_data['nightEndTime'];
- $serviceData[2]['start_time_line']=str_replace(':','',$save_data['nightStartTime']);
- $serviceData[2]['end_time_line']=str_replace(':','',$save_data['nightEndTime']);
- $service_times = [
- 1 => ['amStartTime' => $save_data['amStartTime'], 'amEndTime' => $save_data['amEndTime']],
- 2 => ['pmStartTime' => $save_data['pmStartTime'], 'pmEndTime' => $save_data['pmEndTime']],
- 3 => ['nightStartTime' => $save_data['nightStartTime'], 'nightEndTime' => $save_data['nightEndTime']],
- ];
- $newData['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE);
- $newData['person'] = $save_data['person'];
- $newData['type'] = $save_data['type'];
- $pic_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 2])->first();
- DocterServiceTimes::insert($serviceData);
- if (empty($pic_fins)) {
- $newData['docter_id'] = $doctor_id;
- DocterTimes::create($newData);
- } else {
- $pic_fins = $pic_fins->toArray();
- DocterTimes::where(['id' => $pic_fins['id']])->update($newData);
- }
- }
- }
- if ($finds['is_phone'] == 0) {
- if (isset($data['is_phone']) && !empty($data['is_phone'])) {
- unset($data['is_phone']);
- }
- } else {
- if (isset($data['is_phone']) && !empty($data['is_phone'])) {
- // 存入状态为1的操作
- DocterServiceTimes::where(['docter_id'=>$doctor_id,'type'=>1])->delete();
- $save_data = $data['is_phone'];
- $newData = [];
- $serviceData = [];
- $newData['base_price'] = $save_data['base_price'];
- $newData['step_price'] = $save_data['step_price'];
- $serviceData[0]['docter_id']=$doctor_id;
- $serviceData[0]['type']=1;
- $serviceData[0]['start_time_period']=$save_data['amStartTime'];
- $serviceData[0]['end_time_period']=$save_data['amEndTime'];
- $serviceData[0]['start_time_line']=str_replace(':','',$save_data['amStartTime']);
- $serviceData[0]['end_time_line']=str_replace(':','',$save_data['amEndTime']);
- $serviceData[1]['docter_id']=$doctor_id;
- $serviceData[1]['type']=1;
- $serviceData[1]['start_time_period']=$save_data['pmStartTime'];
- $serviceData[1]['end_time_period']=$save_data['pmEndTime'];
- $serviceData[1]['start_time_line']=str_replace(':','',$save_data['pmStartTime']);
- $serviceData[1]['end_time_line']=str_replace(':','',$save_data['pmEndTime']);
- $serviceData[2]['docter_id']=$doctor_id;
- $serviceData[2]['type']=1;
- $serviceData[2]['start_time_period']=$save_data['nightStartTime'];
- $serviceData[2]['end_time_period']=$save_data['nightEndTime'];
- $serviceData[2]['start_time_line']=str_replace(':','',$save_data['nightStartTime']);
- $serviceData[2]['end_time_line']=str_replace(':','',$save_data['nightEndTime']);
- $service_times = [
- 1 => ['amStartTime' => $save_data['amStartTime'], 'amEndTime' => $save_data['amEndTime']],
- 2 => ['pmStartTime' => $save_data['pmStartTime'], 'pmEndTime' => $save_data['pmEndTime']],
- 3 => ['nightStartTime' => $save_data['nightStartTime'], 'nightEndTime' => $save_data['nightEndTime']],
- ];
- $newData['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE);
- $newData['person'] = $save_data['person'];
- $newData['type'] = $save_data['type'];
- // 图文咨询时间
- $phone_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 1])->first();
- DocterServiceTimes::insert($serviceData);
- if (empty($phone_fins)) {
- $newData['docter_id'] = $doctor_id;
- DocterTimes::create($newData);
- } else {
- $phone_fins = $phone_fins->toArray();
- DocterTimes::where(['id' => $phone_fins['id']])->update($newData);
- }
- }
- }
- if ($finds['is_appoint'] == 0) {
- if (isset($data['is_appoint']) && !empty($data['is_appoint'])) {
- unset($data['is_appoint']);
- }
- } else {
- // 此时可能有两个医院,为一个数组,一个一个入库
- if (isset($data['is_appoint']) && !empty($data['is_appoint'])) {
- $save_data = $data['is_appoint'];
- $setting_data = [];
- $times_data = [];
- // 查询除本地来
- $edutime = DocterSetting::where(['docter_id' => $doctor_id, 'type' => 1])->get();
- if ($edutime) {
- $newedu = [];
- foreach ($edutime as $k => $v) {
- $newedu[$k]['org_id'] = $v['org_id'];
- $newedu[$k]['service_times'] = $v['service_times'];
- }
- $flag_arr = [];
- foreach ($newedu as $k => $v) {
- foreach ($save_data as $kk => $vv) {
- if ($v['org_id'] == $vv['org_id']) {
- if ($v['service_times'] != $vv['service_times']) {
- $flag_arr[] = $vv['org_id'];
- }
- }
- }
- }
- $flag = !empty($flag_arr) ? $flag_arr : false;
- }
- foreach ($save_data as $k => $v) {
- if (!isset($v['service_times'])||empty($v['service_times'])){
- unset($save_data[$k]);
- }else{
- DocterSetting::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete();
- TimePeriod::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete();
- $setting_data[$k]['docter_id'] = $doctor_id;
- $setting_data[$k]['type'] = 1;
- $setting_data[$k]['status'] = 2;
- $setting_data[$k]['appoint_price'] = $v['base_price'];
- $setting_data[$k]['show_days'] = $v['show_days'];
- $setting_data[$k]['service_times'] = $v['service_times'];
- $setting_data[$k]['service_num'] = $v['service_num'];
- $setting_data[$k]['org_id'] = $v['org_id'];
- $service_times = [
- 1 => ['amStartTime' => $v['amStartTime'], 'amEndTime' => $v['amEndTime'], 'amPerson' => $v['amPerson']],
- 2 => ['pmStartTime' => $v['pmStartTime'], 'pmEndTime' => $v['pmEndTime'], 'pmPerson' => $v['pmPerson']],
- 3 => ['nightStartTime' => $v['nightStartTime'], 'nightEndTime' => $v['nightEndTime'], 'nightPerson' => $v['nightPerson']],
- ];
- $setting_data[$k]['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE);
- $setting_data[$k]['created_at'] = date('Y-m-d H:i:s', time());
- $setting_data[$k]['updated_at'] = date('Y-m-d H:i:s', time());
- // 第二步, 根据时长去生成24小时的时间段,也要存id
- $timeList = $this->getTimeHoures($v['service_times']);
- foreach ($timeList as $kk => $vv) {
- $times_data[$k][$kk]['type'] = 1;
- $times_data[$k][$kk]['docter_id'] = $doctor_id;
- $times_data[$k][$kk]['start_time_period'] = $vv[0];
- $times_data[$k][$kk]['end_time_period'] = $vv[1];
- $times_data[$k][$kk]['org_id'] = $v['org_id'];
- }
- }
- }
- if($times_data&&$setting_data){
- foreach ($times_data as $k => $v) {
- TimePeriod::insert($v);
- }
- DocterSetting::insert($setting_data);
- }
- }
- }
- DB::commit();
- } catch (\Exception $e) {
- DB::rollBack();
- return out('', 500, $e->getMessage());
- } catch (\PDOException $e) {
- DB::rollBack();
- return out('', 500, $e->getMessage());
- }
- if ($finds['is_appoint'] != 0 && isset($data['is_appoint']) && !empty($data['is_appoint'])) {
- /*去重新更新,自定义排班表,和排班详情表,因为时间段id发生了变化!*/
- if ($flag != false) {
- $weekList = WeekSchedule::where('docter_id', $doctor_id)->get();
- $moth_date = $this->date_bool();
- $counts = Schedule::where('schedule_date', '>=', $moth_date[0]['date'])->where('schedule_date', '<=', end($moth_date)['date'])->get();
- if ($weekList && $counts) {
- $weekList = $weekList->toArray();
- $selfScheduleList = SelfSchedule::where('docter_id', $doctor_id)->whereIn('organization_id', $flag)->get();
- // 修改自定义表 不存在则不管就好
- SchedulePeriod::where('docter_id', '=', $doctor_id)->delete();
- if ($selfScheduleList) {
- $selfScheduleList = $selfScheduleList->toArray();
- $selfList = [];
- foreach ($selfScheduleList as $k => $v) {
- if (!isset($selfList[$v['schedule_date']])) {
- $selfList[$v['schedule_date']] = $v;
- if ($v['type'] == 1) {
- $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id'];
- $selfList[$v['schedule_date']]['ident']['xia_id'] = 0;
- $selfList[$v['schedule_date']]['ident']['wan_id'] = 0;
- } else if ($v['type'] == 2) {
- $selfList[$v['schedule_date']]['ident']['zao_id'] = 0;
- $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id'];
- $selfList[$v['schedule_date']]['ident']['wan_id'] = 0;
- } else {
- $selfList[$v['schedule_date']]['ident']['zao_id'] = 0;
- $selfList[$v['schedule_date']]['ident']['xia_id'] = 0;
- $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id'];
- }
- } else {
- if ($v['type'] == 1) {
- $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id'];
- } else if ($v['type'] == 2) {
- $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id'];
- } else {
- $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id'];
- }
- }
- }
- // 拼接数据交给saveDay来操作
- $saveDatas = [];
- SelfSchedule::where('docter_id', $doctor_id)->delete();
- foreach ($selfList as $k => $v) {
- $saveDatas[$k]['schedule_date'] = $v['schedule_date'];
- $saveDatas[$k]['week'] = $v['week'];
- if ($v['ident']['zao_id']) {
- $saveDatas[$k]['type'] = 1;
- $saveDatas[$k]['organization_id'] = $v['ident']['zao_id'];
- $saveSelf = $this->saveDay($saveDatas[$k]);
- if (!$saveSelf) {
- return out('', 500, '修改排班失败!');
- }
- }
- if ($v['ident']['xia_id']) {
- $saveDatas[$k]['type'] = 2;
- $saveDatas[$k]['organization_id'] = $v['ident']['xia_id'];
- $saveSelf = $this->saveDay($saveDatas[$k]);
- if (!$saveSelf) {
- return out('', 500, '修改排班失败!');
- }
- }
- if ($v['ident']['wan_id']) {
- $saveDatas[$k]['type'] = 3;
- $saveDatas[$k]['organization_id'] = $v['ident']['wan_id'];
- $saveSelf = $this->saveDay($saveDatas[$k]);
- if (!$saveSelf) {
- return out('', 500, '修改排班失败!');
- }
- }
- }
- }
- Db::beginTransaction();
- try {
- $selfScheduleList = SelfSchedule::where('docter_id', $doctor_id)->whereIn('organization_id', $flag)->get();
- foreach ($counts as $kk => $vv) {
- $schedule[$kk]['schedule_date'] = $vv['schedule_date'];
- $schedule[$kk]['week'] = $vv['week'];
- $sid[$kk] = $vv['id'];
- }
- // 占用效率
- $scheduleLists = [];
- foreach ($sid as $kk => $vv) {
- foreach ($weekList as $k => $v) {
- if ($schedule[$kk]['week'] == $v['week']) {
- if ($v['type'] == 1) {
- $times = $this->num_time($v['organization_id'], 1);
- if (!$times) {
- return out('', 500, "请先在排班设置中填写本机构的时间段");
- }
- $maf = $this->getMaf($vv, $times, ['organization_id' => $v['organization_id'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 1], $doctor_id);
- if ($maf) {
- foreach ($maf as $os) {
- $scheduleLists[] = $os;
- }
- }
- }
- if ($v['type'] == 2) {
- $times = $this->num_time($v['organization_id'], 2);
- if (!$times) {
- return out('', 500, "请先在排班设置中填写本机构的时间段");
- }
- $maf = $this->getMaf($vv, $times, ['organization_id' => $v['organization_id'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 2], $doctor_id);
- if ($maf) {
- foreach ($maf as $os) {
- $scheduleLists[] = $os;
- }
- }
- }
- if ($v['type'] == 3) {
- $times = $this->num_time($v['organization_id'], 3);
- if (!$times) {
- return out('', 500, "请先在排班设置中填写本机构的时间段");
- }
- $maf = $this->getMaf($vv, $times, ['organization_id' => $v['organization_id'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 3], $doctor_id);
- if ($maf) {
- foreach ($maf as $os) {
- $scheduleLists[] = $os;
- }
- }
- }
- }
- }
- }
- // 查询重复替换
- $chong = [];
- if ($selfScheduleList && $scheduleLists) {
- foreach ($scheduleLists as $k => $v) {
- foreach ($selfScheduleList as $kk => $vv) {
- if ($v['schedule_date'] == $vv['schedule_date']) {
- $chong[$kk]['schedule_id'] = $v['schedule_id'];
- $chong[$kk]['docter_id'] = $v['docter_id'];
- $chong[$kk]['order_num'] = $v['order_num'];
- $chong[$kk]['organization_id'] = $vv['organization_id'];
- $chong[$kk]['time_period_id'] = $vv['time_period_id'];
- $chong[$kk]['type'] = $vv['type'];
- $chong[$kk]['schedule_date'] = $vv['schedule_date'];
- unset($scheduleLists[$k]);
- }
- }
- }
- }
- $listPeriod = array_merge($chong, $scheduleLists);
- SchedulePeriod::insert($listPeriod);
- DB::commit();
- } catch (\Exception $e) {
- DB::rollBack();
- return out('', 500, '2' . $$e->getMessage());
- } catch (\PDOException $e) {
- DB::rollBack();
- return out('', 500, '2' . $e->getMessage());
- }
- }
- }
- }
- }
- return out();
- }
- /**
- * 计算24小时的时间区间段
- * @param $minute 分钟比如:15
- * @return array
- */
- public function getTimeHoures($minute)
- {
- // 可选10分钟,15分钟,20分钟,30分钟,1个小时
- $start = strtotime(date("Y-m-d 00:00:00"));
- $end = strtotime(date("Y-m-d 23:59:59"));
- $returnArr = [];
- for ($time = $start; $time <= $end; $time = $time + $minute * 60) {
- array_push($returnArr, date("H:i", $time));
- }
- $newList = [];
- // for($i=0;$i<count($returnArr)-1;$i++){
- // $newList[$i]['start']=$returnArr[$i];
- // $newList[$i]['end']=$returnArr[$i+1];
- // }
- $k = 0;
- for ($i = 0; $i < (count($returnArr) * 2) - 1; $i++) {
- if ($i % 2 != 0) {
- if ($i != 0) {
- $k++;
- $newList[$k][0] = $returnArr[$k];
- }
- } else {
- if ($i != 0) {
- $newList[$k - 1][1] = $returnArr[$k];
- } else {
- $newList[$k][0] = $returnArr[$k];
- }
- }
- }
- $newList[count($newList) - 1][1] = $returnArr[0];
- return $newList;
- }
- /**
- * 新修改医生排班设置(废弃)
- * @return mixed
- * @throws \Exception
- */
- public function service_schedule()
- {
- $req = request()->post();
- $data = json_decode($req['data'], true);
- $user = $this->user;
- $doctor_id = $user['id'];
- Db::beginTransaction();
- try {
- if (isset($data) && !empty($data)) {
- $setting_data = [];
- $times_data = [];
- foreach ($data as $k => $v) {
- DocterSetting::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete();
- TimePeriod::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete();
- $setting_data[$k]['docter_id'] = $doctor_id;
- $setting_data[$k]['type'] = 1;
- $setting_data[$k]['status'] = 2;
- $setting_data[$k]['show_days'] = $v['show_days'];
- $setting_data[$k]['service_times'] = $v['service_times'];
- $setting_data[$k]['service_num'] = $v['service_num'];
- $setting_data[$k]['org_id'] = $v['org_id'];
- $service_times = [
- 1 => ['amStartTime' => $v['amStartTime'], 'amEndTime' => $v['amEndTime'], 'amPerson' => $v['amPerson']],
- 2 => ['pmStartTime' => $v['pmStartTime'], 'pmEndTime' => $v['pmEndTime'], 'pmPerson' => $v['pmPerson']],
- 3 => ['nightStartTime' => $v['nightStartTime'], 'nightEndTime' => $v['nightEndTime'], 'nightPerson' => $v['nightPerson']],
- ];
- $setting_data[$k]['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE);
- $setting_data[$k]['created_at'] = date('Y-m-d H:i:s', time());
- $setting_data[$k]['updated_at'] = date('Y-m-d H:i:s', time());
- // 第二步, 根据时长去生成24小时的时间段,也要存id
- $timeList = $this->getTimeHoures($v['service_times']);
- foreach ($timeList as $kk => $vv) {
- $times_data[$k][$kk]['type'] = 1;
- $times_data[$k][$kk]['docter_id'] = $doctor_id;
- $times_data[$k][$kk]['start_time_period'] = $vv[0];
- $times_data[$k][$kk]['end_time_period'] = $vv[1];
- $times_data[$k][$kk]['org_id'] = $v['org_id'];
- }
- }
- foreach ($times_data as $k => $v) {
- TimePeriod::insert($v);
- }
- DocterSetting::insert($setting_data);
- }
- DB::commit();
- return out('');
- } catch (\Exception $e) {
- DB::rollBack();
- return out('', 500, $e->getMessage());
- } catch (\PDOException $e) {
- DB::rollBack();
- return out('', 500, $e->getMessage());
- }
- }
- /**
- * 提交认证
- * Auth:Yuanhang-Liu
- * Date:2020/10/14 15:08 *
- * @return \Illuminate\Http\JsonResponse
- */
- public function addthen()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'name|医生姓名' => 'required|max:50',
- 'sex|性别' => 'required|in:男,女',
- 'ID|身份证号' => 'required|min:16|max:18',
- 'works|医院信息' => 'required',
- 'certificate|医生照片和执业证书' => 'required|string',
- 'idPhoto|身份证正反面' => 'required|string',
- 'doctorQualification|照片和资格证书' => 'required|string',
- ]);
- if ($req['sex'] == '男') {
- $req['sex'] = 1;
- } else {
- $req['sex'] = 2;
- }
- // 首先获取医生姓名,性别,身份证号,照片,身份证,资格证去补全医生表
- // 入库organization_ids这个数据是一条字符串,先分割成数组,如果只有一条则医生只选择了一个医院,机构id和医生id入库docter_organization(医生机构关联表)
- $user = $this->user;
- $doctor_id = $user['id'];
- if (!$doctor_id) {
- return out(null, 500, '医生信息错误!');
- }
- $data = [];
- $data['name'] = $req['name'];
- $data['sex'] = $req['sex'];
- $data['card_id'] = $req['ID'];
- $data['practice'] = $req['certificate'];
- $data['card_photo'] = $req['idPhoto'];
- $data['is_quail'] = $req['doctorQualification'];
- //处理医院机构id
- $work = json_decode($req['works'], true);
- if (!$work) {
- return out('', '', '缺少医院');
- }
- $off_then = DocterOrganization::where('docter_id', '=', $doctor_id)->get('id')->toArray();
- $is_del = false;
- if ($off_then) {
- $newids = [];
- foreach ($off_then as $k => $v) {
- $newids[$k] = $v['id'];
- }
- $is_del = true;
- }
- $org_list = [];
- foreach ($work as $k => $v) {
- if ($v['hospital']) {
- $org_list[$k]['docter_id'] = $doctor_id;
- $org_list[$k]['organization_id'] = $v['hospital'];
- $org_list[$k]['offices_id'] = $v['department'];
- $org_list[$k]['qualifications_id'] = $v['qualifications'];
- $org_list[$k]['state'] = $v['state'];
- }
- }
- DB::beginTransaction();//开启事务
- try {
- //补全医生表
- Docter::where('id', $doctor_id)->update($data);
- if ($is_del) {
- foreach ($newids as $k => $v) {
- DocterOrganization::where('id', $v)->delete();
- }
- }
- // 提交消息;
- DocterMessage::create([
- 'docter_id' => $doctor_id,
- 'status' => 1,
- 'type' => 8,
- 'content' => '您已提交医生资质认证审核材料 '
- ]);
- DocterOrganization::insertOrIgnore($org_list);
- DB::commit();//提交至数据库
- return out();
- } catch (\Exception $e) {
- DB::rollback();
- return out(null, 500, $e->getMessage());
- }
- }
- /**
- <<<<<<< HEAD
- * 联动医院
- =======
- * 获取地区/联动医院
- >>>>>>> dev
- * Auth:Yuanhang-Liu
- * Date:2020/10/14 17:17 *
- * @return \Illuminate\Http\JsonResponse
- */
- public function get_city_id()
- {
- // 查询机构!
- $req = request()->post();
- $this->validate(request(), [
- 'level_type' => 'required|in:4',
- 'province|省或直辖市id' => 'required_if:level_type,==,4',
- 'city|市' => 'required_if:level_type,==,4',
- 'area|区' => 'required_if:level_type,==,4',
- ]);
- // 查找下医院
- // $ids_string = explode(',',$req['organizations_ids']);
- $province = trim($req['province']);
- $city = trim($req['city']);
- $area = trim($req['area']);
- $where['province_id'] = $province;
- $where['city_id'] = $city;
- $where['area_id'] = $area;
- $where['type'] = 1;
- $Organization = Organization::with('offices')->where($where)->get()->toArray();
- $qulire = Qualification::where('status', 1)->get();
- $newList = [];
- if ($Organization) {
- foreach ($Organization as $k => $v) {
- $newList[$k]['value'] = $v['id'];
- $newList[$k]['label'] = $v['name'];
- if ($v['offices']) {
- foreach ($v['offices'] as $kk => $vv) {
- $newList[$k]['children'][$kk]['value'] = $vv['id'];
- $newList[$k]['children'][$kk]['label'] = $vv['name'];
- if ($qulire) {
- foreach ($qulire as $p => $c) {
- $newList[$k]['children'][$kk]['children'][$p]['value'] = $c['id'];
- $newList[$k]['children'][$kk]['children'][$p]['label'] = $c['name'];
- }
- } else {
- unset($Organization[$k], $newList[$k]);
- }
- }
- } else {
- unset($Organization[$k], $newList[$k]);
- }
- }
- }
- return out($newList);
- }
- /**
- * 获取城市联动
- * @return \Illuminate\Http\JsonResponse
- * @author Liu-Yh
- * Create By 2020/11/4 19:35
- */
- public function getCityList()
- {
- // 查询机构!
- $req = request()->post();
- $where['status'] = 1;
- $data = Areas::where($where)->get(['id', 'name', 'level', 'parent_id'])->toArray();
- $newData = [];
- foreach ($data as $k => $v) {
- $newData[$k]['value'] = $v['id'];
- $newData[$k]['label'] = $v['name'];
- $newData[$k]['pid'] = $v['parent_id'];
- }
- $list = $this->getTrees($newData);
- $list = $this->getTree($list);
- return out($list);
- }
- /**
- * 获取城市树
- * @param $data
- * @return array
- */
- protected function getTrees($arr, $pid = 0)
- {
- static $list = [];
- foreach ($arr as $key => $value) {
- if ($value["pid"] == $pid) {
- $list[] = $value;
- unset($arr[$key]); //删除已经排好的数据为了减少遍历的次数,当然递归本身就很费神就是了
- $this->getTrees($arr, $value["value"]);
- }
- }
- return $list;
- }
- /**
- * 整合树🌲
- * @param $data
- * @param $pId
- * @return string
- */
- protected function getTree($data, $pId = 0)
- {
- $tree = [];
- foreach ($data as $k => $v) {
- if ($v['pid'] == $pId) { //父亲找到儿子
- $chid = $this->getTree($data, $v['value']);
- if ($chid) {
- $v['children'] = $chid;
- }
- $tree[] = $v;
- unset($data[$k]);
- } else {
- unset($data[$k]);
- }
- }
- return $tree;
- }
- /* public function getCityList(){
- // 查询机构!
- $req = request()->post();
- $this->validate(request(), [
- 'type' => 'required|in:1,2,3',
- 'parent_id|父级id' => 'required_if:type,==,2|required_if:type,==,3|integer',
- ]);//1=省,2=市,3=区
- $where['level'] = $req['type'];
- $where['status'] = 1;
- if($req['type']==1){
- $cityList = Areas::where($where)->get(['id','name'])->toArray();
- }else if ($req['type']==2){
- $where['parent_id']= $req['parent_id'];
- $cityList = Areas::where($where)->get(['id','name'])->toArray();
- }else if ($req['type']==3){
- $where['parent_id']= $req['parent_id'];
- $cityList = Areas::where($where)->get(['id','name'])->toArray();
- }else{
- return out('','','错误请求');
- }
- return out($cityList);
- }*/
- /**
- * 获取科室和资质
- * @return mixed
- */
- public function getOfferList()
- {
- // 查询机构!
- $req = request()->post();
- $this->validate(request(), [
- 'type' => 'required|in:1,2',
- ]);//1=科室,2=资质
- $type = $req['type'];
- if ($type == 1) {
- $List = Office::get(['id', 'name'])->toArray();
- } else if ($type == 2) {
- $List = Qualification::get(['id', 'name'])->toArray();
- } else {
- return out('', '', '错误请求');
- }
- return out($List);
- }
- /**
- * 获取我的患者列表
- * Auth:Yuanhang-Liu
- * Date:2020/10/17 13:21
- * @return \Illuminate\Http\JsonResponse
- */
- public function userList()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'userId' => 'integer',
- 'userType|用户类型' => 'integer|in:1,2,3,4,5,6,7',
- ]);
- $user = $this->user;
- $doctor_id = $user['id'];
- if (!$doctor_id) {
- return out(null, 500, '医生信息错误!');
- }
- $returnList = [];
- $orderList = Order::with(['user'])->where('docter_id', '=', $doctor_id)->groupBy('id', 'product_type', 'user_id')->get()->toArray();
- $collections = DocterUser::with('user')->where('docter_id', '=', $doctor_id)->groupBy('user_id')->get()->toArray();
- $newList = [];
- foreach ($orderList as $k => $v) {
- $newList[$k]['order_id'] = $v['id'];
- $newList[$k]['user_id'] = $v['user_id'];
- $newList[$k]['order_sn'] = $v['order_sn'];
- $newList[$k]['nickname'] = $v['user']['nickname'];
- $save = UserDocter::where('user_id', '=', $v['user']['id'])->first();
- if ($save) {
- $newList[$k]['remark'] = $save['remark'];
- } else {
- $newList[$k]['remark'] = '';
- }
- $newList[$k]['avatar'] = $v['user']['avatar'];
- $newList[$k]['product_type'] = $v['product_type'];
- }
- $newcoll = [];
- foreach ($collections as $k => $v) {
- $newcoll[$k]['id'] = $v['id'];
- $newcoll[$k]['user_id'] = $v['user_id'];
- $newcoll[$k]['nickname'] = $v['user']['nickname'];
- $save = UserDocter::where('user_id', '=', $v['user_id'])->first();
- if ($save) {
- $newList[$k]['remark'] = $save['remark'];
- } else {
- $newList[$k]['remark'] = '';
- }
- $newcoll[$k]['avatar'] = $v['user']['avatar'];
- }
- $user_pic = [];
- $user_relation = [];
- $user_vaccines = [];
- $user_guar = [];
- $user_pack = [];
- foreach ($newList as $k => $v) {
- if ($v['product_type'] == 1 || $v['product_type'] == 2) {
- // 咨询患者
- if (!$this->putusers($user_pic, $v['user_id'])) {
- array_push($user_pic, $v);
- }
- }
- if ($v['product_type'] == 3) {
- // 门诊患者
- if (!$this->putusers($user_relation, $v['user_id'])) {
- array_push($user_relation, $v);
- }
- }
- if ($v['product_type'] == 4) {
- // 疫苗患者
- if (!$this->putusers($user_vaccines, $v['user_id'])) {
- array_push($user_vaccines, $v);
- }
- }
- if ($v['product_type'] == 5) {
- // 儿保预约
- if (!$this->putusers($user_guar, $v['user_id'])) {
- array_push($user_guar, $v);
- }
- }
- if ($v['product_type'] == 6) {
- // 服务包
- $OrderPacks = OrderPack::where('order_id', '=', $v['order_id'])->first();
- if ($OrderPacks) {
- $teams = Team::with('docter')->where('id', '=', $OrderPacks['team_id'])->first();
- if ($teams) {
- $teams = $teams->toArray();
- if ($teams['docter']) {
- foreach ($teams['docter'] as $kk => $vv) {
- if ($vv['id'] == $doctor_id) {
- array_push($user_pack, $v);
- }
- }
- }
- }
- }
- }
- }
- $returnList['user_pic']['data'] = $user_pic;
- $returnList['user_relation']['data'] = $user_relation;
- $returnList['user_vaccines']['data'] = $user_vaccines;
- $returnList['user_guar']['data'] = $user_guar;
- $returnList['user_pack']['data'] = $user_pack;
- if (empty($newcoll)) {
- // 关注患者
- $returnList['user_collection']['data'] = [];
- } else {
- $returnList['user_collection']['data'] = $newcoll;
- }
- $returnList['user_pic']['count'] = count($user_pic);
- $returnList['user_relation']['count'] = count($user_relation);
- $returnList['user_vaccines']['count'] = count($user_vaccines);
- $returnList['user_guar']['count'] = count($user_guar);
- $returnList['user_pack']['count'] = count($user_pack);
- $returnList['user_collection']['count'] = count($returnList['user_collection']['data']);
- return out($returnList);
- }
- /**
- * 升级版 in_array
- * @param $data1
- * @param $data2
- * @return bool
- * @author Liu-Yh
- * Create By 2020/11/27 16:18
- */
- protected function putusers($data1, $data2)
- {
- if (empty($data1)) {
- return false;
- }
- $list = [];
- foreach ($data1 as $k => $v) {
- array_push($list, $v['user_id']);
- }
- if (in_array($data2, $list)) {
- return true;
- } else {
- return false;
- }
- }
- /**
- * 上备注
- * @return \Illuminate\Http\JsonResponse
- * @author Liu-Yh
- * Create By 2020/11/27 16:16
- */
- public function remacks()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'remak|备注' => 'required',
- 'id|id' => 'required',
- ]);
- $user = $this->user;
- $user_id = $user['id'];
- $wheres['docter_id'] = $user_id;
- $wheres['user_id'] = $req['id'];
- $save = UserDocter::where($wheres)->first();
- if ($save) {
- UserDocter::where('id', '=', $save['id'])->update([
- 'remark' => $req['remak']
- ]);
- } else {
- UserDocter::create([
- 'docter_id' => $user_id,
- 'user_id' => $req['id'],
- 'remark' => $req['remak']
- ]);
- }
- return out([]);
- }
- /**
- * 评价列表
- * @return \Illuminate\Http\JsonResponse
- * @author Liu-Yh
- * Create By 2020/11/17 17:41
- */
- public function evaluate()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'curPage' => 'required|integer',
- 'pageSize' => 'required|integer',
- ]);
- $pageSize = ($req['curPage'] - 1) * $req['pageSize'];
- $user = $this->user;
- $doctor_id = $user['id'];
- $wheres['docter_id'] = $doctor_id;
- $wheres['status'] = 2;
- $data = Evaluate::with(['order', 'user'])->where($wheres)->skip($pageSize)->take($req['pageSize'])->groupBy('id')->get()->toArray();;
- if ($data) {
- $newList = [];
- foreach ($data as $k => $v) {
- $newList[$k]['order_id'] = $v['order']['order_sn'];
- $newList[$k]['user'] = $v['user']['nickname'];
- $newList[$k]['lv'] = $v['score'];
- $newList[$k]['time'] = $v['created_at'];
- $newList[$k]['evaluate'] = $v['content'];
- }
- return out($newList);
- } else {
- return out([]);
- }
- }
- /**
- * 我的列表进入详情
- * Auth:Yuanhang-Liu
- * Date:2020/10/18 15:21
- * @return \Illuminate\Http\JsonResponse
- */
- public function userListDetile()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'user_id|用户ID' => 'required|integer',
- 'userType|用户类型' => 'integer|in:1,2,3,4,5,6,7',
- ]);
- $user = $this->user;
- // 查询详情;
- $finds_patient = User::with('patients')->where('id', '=', $req['user_id'])->first();
- $remarks = UserDocter::where('user_id', '=', $req['user_id'])->first();
- $finds_order = Order::with('orderPatient')->where('user_id', '=', $req['user_id'])->orderBy('created_at', 'desc')->limit(3)->get();
- if ($finds_order) {
- $finds_order = $finds_order->toArray();
- }
- $userArr = $patientsArr = $orderArr = $fuwArr = [];
- $patientsArr = [];
- $ws['user_id'] = $req['user_id'];
- $ws['product_type'] = 6;
- $fuw_order = Order::with('orderPack')->where($ws)->orderBy('created_at', 'desc')->get();
- if ($fuw_order) {
- $fuw_order = $fuw_order->toArray();
- foreach ($fuw_order as $kk => $vv) {
- $fuwArr[$kk]['order_id'] = $vv['id'];
- if ($vv['order_pack']) {
- foreach ($vv['order_pack'] as $k => $v) {
- $fuwArr[$kk]['id'] = $v['id'];
- $fuwArr[$kk]['pack_name'] = $v['pack_name'];
- $fuwArr[$kk]['pack_intro'] = $v['pack_intro'];
- $fuwArr[$kk]['pack_price'] = $v['pack_price'];
- $fuwArr[$kk]['effective_days'] = $v['effective_days'];
- $fuwArr[$kk]['start_time'] = date('Y-m-d,H:i', $v['start_time']);
- $fuwArr[$kk]['end_time'] = date('Y-m-d,H:i', $v['end_time']);
- }
- }
- }
- }
- if ($finds_patient) {
- $finds_patient = $finds_patient->toArray();
- $userArr['id'] = $finds_patient['id'];
- if ($remarks) {
- $userArr['remark'] = $remarks['remark']; //用户备注
- } else {
- $userArr['remark'] = ''; //用户备注
- }
- $userArr['nickname'] = $finds_patient['nickname'];
- $userArr['avatar'] = $finds_patient['avatar'];
- if ($finds_patient['patients']) {
- foreach ($finds_patient['patients'] as $kk => $vv) {
- $patientsArr[$kk]['id'] = $vv['id'];
- $patientsArr[$kk]['avatar'] = $vv['avatar'];
- $patientsArr[$kk]['name'] = $vv['name'];
- if ($vv['sex'] == 0) {
- $patientsArr[$kk]['sex'] = '未知';
- } elseif ($vv['sex'] == 1) {
- $patientsArr[$kk]['sex'] = '男';
- } else {
- $patientsArr[$kk]['sex'] = '女';
- }
- $patientsArr[$kk]['age'] = numBirthday($vv['birthday']);
- }
- }
- }
- if ($finds_order) {
- foreach ($finds_order as $k => $v) {
- $orderArr[$k]['id'] = $v['id'];
- $orderArr[$k]['order_sn'] = $v['order_sn'];
- if ($v['order_status'] >= 4) {
- $orderArr[$k]['receiving_time'] = date('Y-m-d H:i', $v['receiving_time']);
- $orderArr[$k]['outtime'] = date('Y-m-d H:i', $v['end_time']);
- } else {
- $orderArr[$k]['receiving_time'] = '';
- $orderArr[$k]['outtime'] = '';
- }
- $orderArr[$k]['order_status'] = $v['order_status'];
- $orderArr[$k]['product_type'] = $v['product_type'];
- $orderArr[$k]['created_at'] = $v['created_at'];
- $orderArr[$k]['name'] = $v['order_patient']['name'];
- $orderArr[$k]['birthday'] = numBirthday($v['order_patient']['birthday']);
- }
- }
- // 拼接服务消息
- $wh['user_id'] = $req['user_id'];
- $wh['order_status'] = ['>', 3];
- $wh['product_type'] = 6;
- $fuwuList = [];
- $fuwuInfo = Order::where($wh)->get();
- $fuwuList['fuwu_num'] = count($fuwuInfo);
- $whs['user_id'] = $req['user_id'];
- $whs['order_status'] = ['>', 3];
- $order_nums = Order::where($whs)->get();
- $fuwuList['order_num'] = count($order_nums);
- $pati_nums = Patient::where('user_id', '=', $req['user_id'])->get();
- $fuwuList['pati_num'] = count($pati_nums);
- $returnArr = [
- 'user_arr' => $userArr,
- 'patients_arr' => $patientsArr,//患者档案
- 'order_arr' => $orderArr, //历史问诊
- 'fuwu_arr' => $fuwArr, //已购服务
- 'nums' => $fuwuList,
- ];
- return out($returnArr);
- }
- /**
- * 我的列表进入详情
- * Auth:Yuanhang-Liu
- * Date:2020/10/20 23:21
- * @return \Illuminate\Http\JsonResponse
- */
- public function patientsDetile()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'patient_id|患者ID' => 'required|integer',
- ]);
- $user = $this->user;
- $finds = Patient::where('id', '=', $req['patient_id'])->first();
- if ($finds) {
- $finds = $finds->toArray();
- }
- if ($finds['sex'] == 0) {
- $finds['sex'] = '中性';
- } elseif ($finds['sex'] == 1) {
- $finds['sex'] = '男';
- } else {
- $finds['sex'] = '女';
- }
- switch ($finds['relationship_type']) {
- case 1:
- $finds['relationship_type'] = '父亲';
- break;
- case 2:
- $finds['relationship_type'] = '母亲';
- break;
- case 3:
- $finds['relationship_type'] = '祖父';
- break;
- case 4:
- $finds['relationship_type'] = '祖母';
- break;
- case 5:
- $finds['relationship_type'] = '外祖父';
- break;
- case 6:
- $finds['relationship_type'] = '外祖母';
- break;
- case 7:
- $finds['relationship_type'] = '叔侄';
- break;
- default:
- $finds['relationship_type'] = '其他';
- }
- $finds['age'] = numBirthday($finds['birthday']);
- // 患者单子
- $patient_list = OrderPatient::with('order')->where('patient_id', '=', $req['patient_id'])->groupBy('id', 'order_id')->get();
- $patient_arr = [];
- if ($patient_list) {
- $patient_list = $patient_list->toArray();
- foreach ($patient_list as $k => $v) {
- switch ($v['order']['product_type']) {
- case 1:
- $patient_arr[$k]['product_type'] = '电话咨询';
- break;
- case 2:
- $patient_arr[$k]['product_type'] = '图文咨询';
- break;
- case 3:
- $patient_arr[$k]['product_type'] = '门诊';
- break;
- case 4:
- $patient_arr[$k]['product_type'] = '疫苗接种预约';
- break;
- case 5:
- $patient_arr[$k]['product_type'] = '儿保预约';
- break;
- case 6:
- $patient_arr[$k]['product_type'] = '服务包';
- break;
- case 7:
- $patient_arr[$k]['product_type'] = '充值';
- break;
- default:
- $patient_arr[$k]['product_type'] = '错误';
- }
- switch ($v['order']['order_status']) {
- case 1:
- $patient_arr[$k]['order_status'] = '未支付';
- break;
- case 2:
- $patient_arr[$k]['order_status'] = '待接单';
- break;
- case 3:
- $patient_arr[$k]['order_status'] = '进行中';
- break;
- case 4:
- $patient_arr[$k]['order_status'] = '已完成';
- break;
- case 5:
- $patient_arr[$k]['order_status'] = '已取消';
- break;
- default:
- $patient_arr[$k]['order_status'] = '未知';
- }
- $patient_arr[$k]['created_at'] = $v['created_at'];
- }
- }
- $returnArr = [
- 'patient' => $finds,
- 'patientOrder' => $patient_arr,
- ];
- return out($returnArr);
- }
- /**
- * 关注用户
- * Auth:Yuanhang-Liu
- * Date:2020/10/21 00:21
- * @return \Illuminate\Http\JsonResponse
- */
- public function userFollow()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'user_id|用户ID' => 'required|integer',
- 'is_ley' => 'required',
- ]);
- // 如果ley==false说明要取消关注,反之添加关注
- $user = $this->user;
- $docter_id = $user['id'];
- if ($req['is_ley'] == 1) {
- DocterUser::where('user_id', '=', $req['user_id'])->delete();
- } else {
- DocterUser::create([
- 'user_id' => $req['user_id'],
- 'docter_id' => $user['id'],
- ]);
- }
- return out();
- }
- /**
- * 是否关注用户
- * Auth:Yuanhang-Liu
- * Date:2020/10/21 00:21
- * @return \Illuminate\Http\JsonResponse
- */
- public function getFollows()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'user_id|用户ID' => 'required|integer',
- ]);
- $user = $this->user;
- $docter_id = $user['id'];
- $where['docter_id'] = $docter_id;
- $where['user_id'] = $req['user_id'];
- $find = DocterUser::where($where)->first();
- if ($find) {
- $find = $find->toArray();
- return out(true);
- } else {
- return out(false);
- }
- }
- /**
- * 获取医生所在机构列表
- * Auth:Yuanhang-Liu
- * Date:2020/10/21 00:21
- * @return \Illuminate\Http\JsonResponse
- */
- public function organizationList()
- {
- $user = $this->user;
- $doctor_id = $user['id'];
- $where['docter_id'] = $doctor_id;
- $where['state'] = 1;
- $orgList = DocterOrganization::with('organization')->where($where)->get()->toArray();
- $newList = [];
- foreach ($orgList as $k => $v) {
- $newList[$k]['value'] = $v['organization']['id'];
- $newList[$k]['label'] = $v['organization']['name'];
- }
- return out($newList);
- }
- /**
- * 获取医院的服务时间
- * @return mixed
- */
- public function getOrgTimes()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'org_id|医院id' => 'required',
- ]);
- $user = $this->user;
- $doctor_id = $user['id'];
- $where['docter_id'] = $doctor_id;
- $orgList = DocterSetting::where(['docter_id'=>$doctor_id,'type'=>1,'org_id'=>$req['org_id']])->first();
- $newList = [];
- if($orgList){
- $time = json_decode($orgList['service_time'],true);
- $newList['zao']['amStartTime'] = isset($time[1])?$time[1]['amStartTime']:'';
- $newList['zao']['amEndTime'] = isset($time[1])?$time[1]['amEndTime']:'';
- $newList['zao']['amPerson'] = isset($time[1])?$time[1]['amPerson']:'';
- $newList['zhong']['pmStartTime'] = isset($time[2])?$time[2]['pmStartTime']:'';
- $newList['zhong']['pmEndTime'] = isset($time[2])?$time[2]['pmEndTime']:'';
- $newList['zhong']['pmPerson'] = isset($time[2])?$time[2]['pmPerson']:'';
- $newList['wan']['nightStartTime'] = isset($time[3])?$time[3]['nightStartTime']:'';
- $newList['wan']['nightEndTime'] = isset($time[3])?$time[3]['nightEndTime']:'';
- $newList['wan']['nightPerson'] = isset($time[3])?$time[3]['nightPerson']:'';
- }
- return out($newList);
- }
- /**
- * 获取历史排班时间列表
- */
- public function getLinsList()
- {
- $user = $this->user;
- $doctor_id = $user['id'];
- $newData = [];
- $strim = date('Y-m-d', (time() + (7 - (date('w') == 0 ? 7 : date('w'))) * 24 * 3600));
- $wheres['docter_id'] = $doctor_id;
- $data = Schedule::select(['id', 'schedule_date'])->where($wheres)->whereDate('schedule_date', '>', $strim)->orderBy('schedule_date', 'desc')->get();
- if ($data) {
- $data = $data->toArray();
- } else {
- return out($newData);
- }
- // $newDates = [];
- // foreach ($data as $k=>$v){
- // if((time() + (7 - (date('w') == 0 ? 7 : date('w'))) * 24 * 3600) > strtotime($v['schedule_date'])){
- // array_push($newDates,$data[$k]);
- // }
- // }
- // $data =$newDates;
- // $k=1;
- // foreach ($data as $v){
- // $newData[$k]=$v;
- // $k++;
- // }
- $newData = array_values($data);
- $lab = [];
- $p = 0;
- for ($i = count($newData); $i > 0; $i--) {
- // if ($i%7==0||$i==1){
- //
- // if ($p>=1){
- // $lab[$p-1]['end_time'] = $arr[$i-1];
- // $lab[$p]['start_time'] = $arr[$i-1];
- // if(isset($arr[$i-7])){
- // $lab[$p]['end_time'] = isset($arr[$i-7])?$arr[$i-7]:'error';
- //
- // }else{
- // unset($lab[$p]);
- // }
- //// $lab[$p]['end_time'] = isset($arr[$i-7])?$arr[$i-7]:'error';
- // }else{
- // $lab[$p]['start_time'] = $arr[$i-1];
- // }
- // ++$p;
- // }else{
- // continue;
- // }
- if ($i % 7 == 0 || $i == 1) {
- if ($p >= 1) {
- $lab[$p - 1]['end_time'] = $newData[$i - 1];
- if (isset($newData[$i - 7])) {
- $lab[$p]['start_time'] = $newData[$i - 1];
- $lab[$p]['end_time'] = $newData[$i - 7];
- } else {
- unset($lab[$p]);
- }
- } else {
- $lab[$p]['start_time'] = $newData[$i - 1];
- }
- ++$p;
- } else {
- continue;
- }
- }
- // 审核通过时间拿出来
- $wh['docter_id'] = $doctor_id;
- $wh['service_type'] = 3;
- $wh['status'] = 2;
- $service = ServiceApply::where($wh)->first();
- if ($service) {
- $service = $service;
- } else {
- $service = 0;
- }
- $rtuenList = [
- 'list' => $lab,
- 'service' => $service,
- ];
- return out($rtuenList);
- }
- /**
- * 获取历史排班详情(废弃)
- */
- public function getLinsDetail()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'start_date|开始时间' => 'required',
- 'end_date|结束时间' => 'required',
- ]);
- $user = $this->user;
- $doctor_id = $user['id'];
- $newData = [];
- $req['start_date'] = date("Y-m-d", strtotime($req['start_date']));
- $req['end_date'] = date("Y-m-d", strtotime($req['end_date']));
- // $data = Schedule::with(['schedulePeriod'])->orderBy('id','desc')->get();
- $data = SchedulePeriod::with('organization')->where('docter_id', '=', $doctor_id)->whereBetween('schedule_date', [$req['start_date'], $req['end_date']])->groupBy('schedule_id', 'type')->get();
- if ($data) {
- $data = $data->toArray();
- } else {
- return out($newData);
- }
- $lab = [];
- $datesList = getDateFromList($req['start_date'], $req['end_date']);
- foreach ($data as $k => $v) {
- $lab[$k]['schedule_id'] = $v['schedule_id'];
- $lab[$k]['type'] = $v['type']; // 1=早上,2=下午,3=晚上
- switch (date('w', strtotime($v['schedule_date']))) {
- case "0":
- $lab[$k]['week'] = '周日';
- break;
- case "1":
- $lab[$k]['week'] = '周一';
- break;
- case "2":
- $lab[$k]['week'] = '周二';
- break;
- case "3":
- $lab[$k]['week'] = '周三';
- break;
- case "4":
- $lab[$k]['week'] = '周四';
- break;
- case "5":
- $lab[$k]['week'] = '周五';
- break;
- default:
- $lab[$k]['week'] = '周六';
- }
- $lab[$k]['schedule_date'] = date('m-d', strtotime($v['schedule_date'])); // 日期
- $lab[$k]['name'] = $v['organization']; // 所在医院
- $lab[$k]['flag'] = $v['me_sure']; // 所在医院
- }
- $newLists = [];
- $newReturn = [];
- foreach ($lab as $k => $v) {
- if (!isset($newLists[$v['schedule_id']])) {
- $newLists[$v['schedule_id']] = $v;
- $newReturn[$v['schedule_id']]['schedule_id'] = $v['schedule_id'];
- if ($v['type'] == 1) {
- if ($v['flag'] != 0) {
- $newReturn[$v['schedule_id']]['type']['zao_flag'] = true;
- $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
- $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
- } else {
- $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
- $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
- $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
- }
- $newReturn[$v['schedule_id']]['type']['zao'] = $v['name']['name'];
- $newReturn[$v['schedule_id']]['type']['xia'] = false;
- $newReturn[$v['schedule_id']]['type']['wan'] = false;
- $newReturn[$v['schedule_id']]['type']['zao_id'] = $v['name']['id'];
- $newReturn[$v['schedule_id']]['type']['xia_id'] = 0;
- $newReturn[$v['schedule_id']]['type']['wan_id'] = 0;
- } else if ($v['type'] == 2) {
- if ($v['flag'] != 0) {
- $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
- $newReturn[$v['schedule_id']]['type']['xia_flag'] = true;
- $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
- } else {
- $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
- $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
- $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
- }
- $newReturn[$v['schedule_id']]['type']['zao'] = false;
- $newReturn[$v['schedule_id']]['type']['xia'] = $v['name']['name'];
- $newReturn[$v['schedule_id']]['type']['wan'] = false;
- $newReturn[$v['schedule_id']]['type']['zao_id'] = 0;
- $newReturn[$v['schedule_id']]['type']['xia_id'] = $v['name']['id'];
- $newReturn[$v['schedule_id']]['type']['wan_id'] = 0;
- } else {
- if ($v['flag'] != 0) {
- $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
- $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
- $newReturn[$v['schedule_id']]['type']['wan_flag'] = true;
- } else {
- $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
- $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
- $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
- }
- $newReturn[$v['schedule_id']]['type']['zao'] = false;
- $newReturn[$v['schedule_id']]['type']['xia'] = false;
- $newReturn[$v['schedule_id']]['type']['wan'] = $v['name']['name'];
- $newReturn[$v['schedule_id']]['type']['zao_id'] = 0;
- $newReturn[$v['schedule_id']]['type']['xia_id'] = 0;
- $newReturn[$v['schedule_id']]['type']['wan_id'] = $v['name']['id'];
- }
- $newReturn[$v['schedule_id']]['week'] = $v['week'];
- $newReturn[$v['schedule_id']]['schedule_date'] = $v['schedule_date'];
- $newReturn[$v['schedule_id']]['name'] = $v['name'];
- } else {
- if ($v['type'] == 1) {
- if ($v['flag'] != 0) {
- $newReturn[$v['schedule_id']]['type']['zao_flag'] = true;
- } else {
- $newReturn[$v['schedule_id']]['type']['zao_flag'] = false;
- }
- $newReturn[$v['schedule_id']]['type']['zao'] = $v['name']['name'];
- $newReturn[$v['schedule_id']]['type']['zao_id'] = $v['name']['id'];
- } else if ($v['type'] == 2) {
- $newReturn[$v['schedule_id']]['type']['xia'] = $v['name']['name'];
- if ($v['flag'] != 0) {
- $newReturn[$v['schedule_id']]['type']['xia_flag'] = true;
- } else {
- $newReturn[$v['schedule_id']]['type']['xia_flag'] = false;
- }
- $newReturn[$v['schedule_id']]['type']['xia_id'] = $v['name']['id'];
- } else {
- $newReturn[$v['schedule_id']]['type']['wan'] = $v['name']['name'];
- if ($v['flag'] != 0) {
- $newReturn[$v['schedule_id']]['type']['wan_flag'] = true;
- } else {
- $newReturn[$v['schedule_id']]['type']['wan_flag'] = false;
- }
- $newReturn[$v['schedule_id']]['type']['wan_id'] = $v['name']['id'];
- }
- }
- }
- $returnLists['list'] = array_values($newReturn);
- $instartTimes = $req['start_date'];
- // 判断数据库有没有这个时间段
- $whr['docter_id'] = $doctor_id;
- $whr['schedule_date'] = $instartTimes;
- $finds = Schedule::where($whr)->first();
- if ($finds) {
- $returnLists['save_flag'] = false;
- } else {
- $returnLists['save_flag'] = true;
- }
- return out($returnLists);
- }
- /**
- * 获取周模板详情
- * @return \Illuminate\Http\JsonResponse
- * @author Liu-Yh
- * Create By 2020/12/16 12:09
- */
- public function getLinsDetailnew()
- {
- $req = request()->post();
- $user = $this->user;
- $doctor_id = $user['id'];
- $newData = [];
- // $data = Schedule::with(['schedulePeriod'])->orderBy('id','desc')->get();
- $data = WeekSchedule::with('organization')->where('docter_id', '=', $doctor_id)->groupBy('type', 'week')->orderBy('week', 'asc')->get();
- if ($data) {
- $data = $data->toArray();
- } else {
- return out($newData);
- }
- $lab = [];
- foreach ($data as $k => $v) {
- $lab[$k]['id'] = $v['id'];
- $lab[$k]['type'] = $v['type']; // 1=早上,2=下午,3=晚上
- $lab[$k]['organization_id'] = $v['organization_id']; // 1=早上,2=下午,3=晚上
- $lab[$k]['flag'] = $v['week'];
- switch ($v['week']) {
- case "7":
- $lab[$k]['week'] = '周日';
- break;
- case "1":
- $lab[$k]['week'] = '周一';
- break;
- case "2":
- $lab[$k]['week'] = '周二';
- break;
- case "3":
- $lab[$k]['week'] = '周三';
- break;
- case "4":
- $lab[$k]['week'] = '周四';
- break;
- case "5":
- $lab[$k]['week'] = '周五';
- break;
- default:
- $lab[$k]['week'] = '周六';
- }
- $lab[$k]['name'] = $v['organization']; // 所在医院
- }
- $weekList = ['周一', '周二', '周三', '周四', '周五', '周六', '周日'];
- try {
- $newReturn = [];
- foreach ($lab as $k => $v) {
- if (!isset($newReturn[$v['flag']])) {
- $newReturn[$v['flag']] = $v;
- if ($v['type'] == 1) {
- if ($v['flag'] != 0) {
- $newReturn[$v['flag']]['ident']['zao_flag'] = true;
- $newReturn[$v['flag']]['ident']['xia_flag'] = false;
- $newReturn[$v['flag']]['ident']['wan_flag'] = false;
- } else {
- $newReturn[$v['flag']]['ident']['zao_flag'] = false;
- $newReturn[$v['flag']]['ident']['xia_flag'] = false;
- $newReturn[$v['flag']]['ident']['wan_flag'] = false;
- }
- $newReturn[$v['flag']]['ident']['zao'] = $v['name']['name'];
- $newReturn[$v['flag']]['ident']['xia'] = false;
- $newReturn[$v['flag']]['ident']['wan'] = false;
- $newReturn[$v['flag']]['ident']['zao_id'] = $v['name']['id'];
- $newReturn[$v['flag']]['ident']['xia_id'] = 0;
- $newReturn[$v['flag']]['ident']['wan_id'] = 0;
- } else if ($v['type'] == 2) {
- if ($v['flag'] != 0) {
- $newReturn[$v['flag']]['ident']['zao_flag'] = false;
- $newReturn[$v['flag']]['ident']['xia_flag'] = true;
- $newReturn[$v['flag']]['ident']['wan_flag'] = false;
- } else {
- $newReturn[$v['flag']]['ident']['zao_flag'] = false;
- $newReturn[$v['flag']]['ident']['xia_flag'] = false;
- $newReturn[$v['flag']]['ident']['wan_flag'] = false;
- }
- $newReturn[$v['flag']]['ident']['zao'] = false;
- $newReturn[$v['flag']]['ident']['xia'] = $v['name']['name'];
- $newReturn[$v['flag']]['ident']['wan'] = false;
- $newReturn[$v['flag']]['ident']['zao_id'] = 0;
- $newReturn[$v['flag']]['ident']['xia_id'] = $v['name']['id'];
- $newReturn[$v['flag']]['ident']['wan_id'] = 0;
- } else {
- if ($v['flag'] != 0) {
- $newReturn[$v['flag']]['ident']['zao_flag'] = false;
- $newReturn[$v['flag']]['ident']['xia_flag'] = false;
- $newReturn[$v['flag']]['ident']['wan_flag'] = true;
- } else {
- $newReturn[$v['flag']]['ident']['zao_flag'] = false;
- $newReturn[$v['flag']]['ident']['xia_flag'] = false;
- $newReturn[$v['flag']]['ident']['wan_flag'] = false;
- }
- $newReturn[$v['flag']]['ident']['zao'] = false;
- $newReturn[$v['flag']]['ident']['xia'] = false;
- $newReturn[$v['flag']]['ident']['wan'] = $v['name']['name'];
- $newReturn[$v['flag']]['ident']['zao_id'] = 0;
- $newReturn[$v['flag']]['ident']['xia_id'] = 0;
- $newReturn[$v['flag']]['ident']['wan_id'] = $v['name']['id'];
- }
- $newReturn[$v['flag']]['week'] = $v['week'];
- $newReturn[$v['flag']]['name'] = $v['name'];
- } else {
- if ($v['type'] == 1) {
- if ($v['flag'] != 0) {
- $newReturn[$v['flag']]['ident']['zao_flag'] = true;
- } else {
- $newReturn[$v['flag']]['ident']['zao_flag'] = false;
- }
- $newReturn[$v['flag']]['ident']['zao'] = $v['name']['name'];
- $newReturn[$v['flag']]['ident']['zao_id'] = $v['name']['id'];
- } else if ($v['type'] == 2) {
- $newReturn[$v['flag']]['ident']['xia'] = $v['name']['name'];
- if ($v['flag'] != 0) {
- $newReturn[$v['flag']]['ident']['xia_flag'] = true;
- } else {
- $newReturn[$v['flag']]['ident']['xia_flag'] = false;
- }
- $newReturn[$v['flag']]['ident']['xia_id'] = $v['name']['id'];
- } else {
- $newReturn[$v['flag']]['ident']['wan'] = $v['name']['name'];
- if ($v['flag'] != 0) {
- $newReturn[$v['flag']]['ident']['wan_flag'] = true;
- } else {
- $newReturn[$v['flag']]['ident']['wan_flag'] = false;
- }
- $newReturn[$v['flag']]['ident']['wan_id'] = $v['name']['id'];
- }
- }
- unset($newReturn[$v['flag']]['name']);
- }
- } catch (\Exception $e) {
- var_dump($e->getMessage() . $e->getFile() . $e->getLine());
- }
- $returnLists['list'] = array_values($newReturn);
- return out($returnLists);
- }
- /**
- * 门诊排班(废弃)
- * Auth:Yuanhang-Liu
- * Date:2020/10/21 00:21
- * @return \Illuminate\Http\JsonResponse
- */
- public function scheduling()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'data|数据' => 'required',
- ]);
- $user = $this->user;
- $doctor_id = $user['id'];
- $data = json_decode($req['data'], true);
- $schedule = [];
- $morning = [];//早上
- $afternoon = [];//下午
- $night = [];//晚上
- $zaoTimes = [];
- $zhongTimes = [];
- $wanTimes = [];
- $configs = SystemConfig::get()->toArray();
- if (isset($configs[0]['value']) && !empty($configs[0]['value'])) {
- $zaoTimes[0] = $configs[0]['value'];
- } else {
- $zaoTimes[0] = "09:00";
- }
- if (isset($configs[1]['value']) && !empty($configs[1]['value'])) {
- $zaoTimes[1] = $configs[1]['value'];
- } else {
- $zaoTimes[1] = "12:00";
- }
- if (isset($configs[2]['value']) && !empty($configs[2]['value'])) {
- $zhongTimes[0] = $configs[2]['value'];
- } else {
- $zhongTimes[0] = "13:00";
- }
- if (isset($configs[3]['value']) && !empty($configs[3]['value'])) {
- $zhongTimes[1] = $configs[3]['value'];
- } else {
- $zhongTimes[1] = "18:00";
- }
- if (isset($configs[4]['value']) && !empty($configs[4]['value'])) {
- $wanTimes[0] = $configs[4]['value'];
- } else {
- $wanTimes[0] = "19:00";
- }
- if (isset($configs[5]['value']) && !empty($configs[5]['value'])) {
- $wanTimes[1] = $configs[5]['value'];
- } else {
- $wanTimes[1] = "21:00";
- }
- $morningd = TimePeriod::where('start_time_period', '>=', $zaoTimes[0])->where('end_time_period', '<=', $zaoTimes[1])->get()->toArray();
- $morning = array_column($morningd, 'id');
- $afternoond = TimePeriod::where('start_time_period', '>=', $zhongTimes[0])->where('end_time_period', '<=', $zhongTimes[1])->get()->toArray();
- $afternoon = array_column($afternoond, 'id');
- $nightd = TimePeriod::where('start_time_period', '>=', $wanTimes[0])->where('end_time_period', '<=', $wanTimes[1])->get()->toArray();
- $night = array_column($nightd, 'id');
- // 先进行删除
- DB::beginTransaction();
- try {
- foreach ($data as $k => $v) {
- // 删除
- Schedule::where('schedule_date', '=', $v["schedule_date"])->delete();
- SchedulePeriod::where('schedule_date', '=', $v['schedule_date'])->delete();
- $schedule[$k]['schedule_date'] = $v['schedule_date'];
- $schedule[$k]['schedule_day'] = str_replace('-', '', $v['schedule_date']);
- $schedule[$k]['docter_id'] = $doctor_id;
- $schedule[$k]['organization_id'] = 0;
- $schedule[$k]['per_time_num'] = 10;
- $sid = Schedule::insertGetId($schedule[$k]);
- // 插入详情
- if ($v['hospital'][0]['organization_id']) {
- $maf = $this->getMaf($sid, $morning, ['organization_id' => $v['hospital'][0]['organization_id'], 'schedule_date' => $v['schedule_date'], 'type' => 1], $doctor_id);
- SchedulePeriod::insert($maf);
- }
- if ($v['hospital'][1]['organization_id']) {
- $maf = $this->getMaf($sid, $afternoon, ['organization_id' => $v['hospital'][1]['organization_id'], 'schedule_date' => $v['schedule_date'], 'type' => 2], $doctor_id);
- SchedulePeriod::insert($maf);
- }
- if ($v['hospital'][2]['organization_id']) {
- $maf = $this->getMaf($sid, $night, ['organization_id' => $v['hospital'][2]['organization_id'], 'schedule_date' => $v['schedule_date'], 'type' => 3], $doctor_id);
- SchedulePeriod::insert($maf);
- }
- }
- DB::commit();
- return out('', '', '成功');
- } catch (\Exception $e) {
- DB::rollBack();
- return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage());
- }
- }
- /**
- * 生成时间段
- * @param int $org_id 机构id
- * @param int $type 时间段,1=早上,2=下午,3=晚上
- * @return array|bool
- * @author Liu-Yh
- * Create By 2020/12/15 18:47
- */
- protected function num_time($org_id = 0, $type = 1)
- {
- $user = $this->user;
- $doctor_id = $user['id'];
- $zaoTimes = [];
- $zhongTimes = [];
- $wanTimes = [];
- $where['docter_id'] = $doctor_id;
- $where['type'] = 1;
- $where['org_id'] = $org_id;
- $configs = DocterSetting::where($where)->first();
- if ($configs) {
- $list = json_decode($configs['service_time'], true);
- if (isset($list[1]['amStartTime']) && !empty($list[1]['amStartTime'])) {
- $zaoTimes[0] = $list[1]['amStartTime'];
- } else {
- $zaoTimes[0] = "08:00";
- }
- if (isset($list[1]['amEndTime']) && !empty($list[1]['amEndTime'])) {
- $zaoTimes[1] = $list[1]['amEndTime'];
- } else {
- $zaoTimes[1] = "12:00";
- }
- if (isset($list[2]['pmStartTime']) && !empty($list[2]['pmStartTime'])) {
- $zhongTimes[0] = $list[2]['pmStartTime'];
- } else {
- $zhongTimes[0] = "13:00";
- }
- if (isset($list[2]['pmEndTime']) && !empty($list[2]['pmEndTime'])) {
- $zhongTimes[1] = $list[2]['pmEndTime'];
- } else {
- $zhongTimes[1] = "18:00";
- }
- if (isset($list[3]['nightStartTime']) && !empty($list[3]['nightStartTime'])) {
- $wanTimes[0] = $list[3]['nightStartTime'];
- } else {
- $wanTimes[0] = "19:00";
- }
- if (isset($list[3]['nightEndTime']) && !empty($list[3]['nightEndTime'])) {
- $wanTimes[1] = $list[3]['nightEndTime'];
- } else {
- $wanTimes[1] = "21:00";
- }
- } else {
- return false;
- }
- if ($type == 1) {
- $morningWhere[] = ['start_time_period', '>=', $zaoTimes[0]];
- $morningWhere[] = ['end_time_period', '<=', $zaoTimes[1]];
- $morningWhere['docter_id'] = $doctor_id;
- $morningWhere['org_id'] = $org_id;
- $morningd = TimePeriod::where($morningWhere)->get()->toArray();
- if (count($morningd)>1){
- array_pop($morningd);
- }
- $morning = array_column($morningd, 'id');
- return $morning;
- } elseif ($type == 2) {
- $afternoondWhere[] = ['start_time_period', '>=', $zhongTimes[0]];
- $afternoondWhere[] = ['end_time_period', '<=', $zhongTimes[1]];
- $afternoondWhere['docter_id'] = $doctor_id;
- $afternoondWhere['org_id'] = $org_id;
- $afternoond = TimePeriod::where($afternoondWhere)->get()->toArray();
- if (count($afternoond)>1){
- array_pop($afternoond);
- }
- $afternoon = array_column($afternoond, 'id');
- return $afternoon;
- } elseif ($type == 3) {
- $nightWhere[] = ['start_time_period', '>=', $wanTimes[0]];
- $nightWhere[] = ['end_time_period', '<=', $wanTimes[1]];
- $nightWhere['docter_id'] = $doctor_id;
- $nightWhere['org_id'] = $org_id;
- $nightd = TimePeriod::where($nightWhere)->get()->toArray();
- if (count($nightd)>1){
- array_pop($nightd);
- }
- $night = array_column($nightd, 'id');
- return $night;
- } else {
- $morningWhere[] = ['start_time_period', '>=', $zaoTimes[0]];
- $morningWhere[] = ['end_time_period', '<=', $zaoTimes[1]];
- $morningWhere['docter_id'] = $doctor_id;
- $morningWhere['org_id'] = $org_id;
- $morningd = TimePeriod::where($morningWhere)->get()->toArray();
- if (count($morningd)>1){
- array_pop($morningd);
- }
- $morning = array_column($morningd, 'id');
- $afternoondWhere[] = ['start_time_period', '>=', $zhongTimes[0]];
- $afternoondWhere[] = ['end_time_period', '<=', $zhongTimes[1]];
- $afternoondWhere['docter_id'] = $doctor_id;
- $afternoondWhere['org_id'] = $org_id;
- $afternoond = TimePeriod::where($afternoondWhere)->get()->toArray();
- if (count($afternoond)>1){
- array_pop($afternoond);
- }
- $afternoon = array_column($afternoond, 'id');
- $nightWhere[] = ['start_time_period', '>=', $wanTimes[0]];
- $nightWhere[] = ['end_time_period', '<=', $wanTimes[1]];
- $nightWhere['docter_id'] = $doctor_id;
- $nightWhere['org_id'] = $org_id;
- $nightd = TimePeriod::where($nightWhere)->get()->toArray();
- if (count($nightd)>1){
- array_pop($nightd);
- }
- $night = array_column($nightd, 'id');
- return [$morning, $afternoon, $night];
- }
- }
- /**
- * 获取俩月日期
- * @return array
- */
- protected function date_bool($start_time = false, $end_time = false)
- {
- $weekarray = array(7, 1, 2, 3, 4, 5, 6);
- $monthDays = [];
- if ($start_time && $end_time) {
- $firstDay = $start_time;
- $lastDay = $end_time;
- } else {
- $firstDay = date('Y-m-01', time());
- $lastDay = date('Y-m-d', strtotime("$firstDay +2 month -1 day"));
- }
- $i = 0;
- while (date('Y-m-d', strtotime("$firstDay +$i days")) <= $lastDay) {
- $monthDays[$i]['date'] = date('Y-m-d', strtotime("$firstDay +$i days"));
- $monthDays[$i]['week'] = $weekarray[date("w", strtotime("$firstDay +$i days"))];
- $i++;
- }
- return $monthDays;
- }
- /**
- * 新版门诊排班(排班周模板)
- * @return mixed
- * @throws \Exception
- */
- public function week_scheduling()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'data|数据' => 'required',
- ]);
- $user = $this->user;
- $doctor_id = $user['id'];
- $data = json_decode($req['data'], true);
- $moth_date = $this->date_bool();
- // 添加到周模板(不管时间)
- $weekList = [];
- $weekModel = new WeekSchedule();
- // 先进行删除
- $counts = Schedule::where('schedule_date', '>=', $moth_date[0]['date'])->where('docter_id',$doctor_id)->where('schedule_date', '<=', end($moth_date)['date'])->get();
- // 12个月平均两个月最短是29天
- $selfWhere['docter_id'] = $doctor_id;
- $selfWhere[] = ['schedule_date','>=',date('Y-m-d',time())];
- $selfScheduleList = SelfSchedule::where($selfWhere)->get();
- $flag = false;
- DB::beginTransaction();
- try {
- $weekModel->where('docter_id', '=', $doctor_id)->where('schedule_type', '=', 1)->delete();
- $delWhere['docter_id'] = $doctor_id;
- $delWhere[] = ['schedule_date','>=',date('Y-m-d',time())];
- SchedulePeriod::where($delWhere)->delete();
- $schedule = [];
- if (count($counts) < 29) {
- $flag = true;
- Schedule::where('docter_id', '=', $doctor_id)->delete();
- foreach ($moth_date as $kk => $vv) {
- $schedule[$kk]['schedule_date'] = $vv['date'];
- $schedule[$kk]['schedule_day'] = str_replace('-', '', $vv['date']);
- $schedule[$kk]['docter_id'] = $doctor_id;
- $schedule[$kk]['organization_id'] = 0;
- $schedule[$kk]['week'] = $vv['week'];
- $schedule[$kk]['per_time_num'] = 10;
- $sid[$kk] = Schedule::insertGetId($schedule[$kk]);
- }
- } else {
- foreach ($counts as $kk => $vv) {
- if ($vv['schedule_date'] >= date('Y-m-d',time())){
- $schedule[$kk]['schedule_date'] = $vv['schedule_date'];
- $schedule[$kk]['week'] = $vv['week'];
- $sid[$kk] = $vv['id'];
- }
- }
- }
- foreach ($data as $k => $v) {
- // 插入详情
- if ($v['identifi']['zao']!=0) {
- $maf[$k]['schedule_type'] = 1;
- $maf[$k]['docter_id'] = $doctor_id;
- $maf[$k]['week'] = $v['week'];
- $maf[$k]['type'] = 1;
- $maf[$k]['organization_id'] = $v['identifi']['zao'];
- $weekList[] = $maf[$k];
- // $times = $this->num_time($v['identifi']['zao'],1);
- // if (!$times){
- // return out('',500,"请先在排班设置中填写本机构的时间段");
- // }
- // $zao_maf=$this->week_getMaf($times,['organization_id'=>$v['identifi']['zao'],'week'=>$v['week'],'type'=>1],$doctor_id);
- // if ($zao_maf){
- // foreach ($zao_maf as $o){
- // $weekList[]=$o;
- // }
- // }
- }
- if ($v['identifi']['zhong']!=0) {
- $maf[$k]['schedule_type'] = 1;
- $maf[$k]['docter_id'] = $doctor_id;
- $maf[$k]['week'] = $v['week'];
- $maf[$k]['type'] = 2;
- $maf[$k]['organization_id'] = $v['identifi']['zhong'];
- $weekList[] = $maf[$k];
- /* $times = $this->num_time($v['identifi']['zhong'],2);
- if (!$times){
- return out('',500,"请先在排班设置中填写本机构的时间段");
- }
- $zhong_maf=$this->week_getMaf($times,['organization_id'=>$v['identifi']['zhong'],'week'=>$v['week'],'type'=>2],$doctor_id);
- if ($zhong_maf){
- foreach ($zhong_maf as $o){
- $weekList[]=$o;
- }
- }*/
- }
- if ($v['identifi']['wan']!=0) {
- $maf[$k]['schedule_type'] = 1;
- $maf[$k]['docter_id'] = $doctor_id;
- $maf[$k]['week'] = $v['week'];
- $maf[$k]['type'] = 3;
- $maf[$k]['organization_id'] = $v['identifi']['wan'];
- $weekList[] = $maf[$k];
- /*$times = $this->num_time($v['identifi']['wan'],3);
- if (!$times){
- return out('',500,"请先在排班设置中填写本机构的时间段");
- }
- $wan_maf=$this->week_getMaf($times,['organization_id'=>$v['identifi']['wan'],'week'=>$v['week'],'type'=>3],$doctor_id);
- if ($wan_maf){
- foreach ($wan_maf as $o){
- $weekList[]=$o;
- }
- }*/
- }
- }
- // 占用效率
- $scheduleLists = [];
- foreach ($sid as $kk => $vv) {
- foreach ($data as $k => $v) {
- if ($schedule[$kk]['week'] == $v['week']) {
- //检查有没有设置时间
- // if ($v['identifi']['zao']==0) {
- // $times = $this->num_time($v['identifi']['zao'], 1);
- // if (!$times) {
- // return out('', 500, "请先在排班设置中填写本机构的时间段1");
- // }
- // }
- if ($v['identifi']['zao']) {
- $times = $this->num_time($v['identifi']['zao'], 1);
- if (!$times) {
- return out('', 500, "请先在排班设置中填写本机构的时间段2");
- }
- $maf = $this->getMaf($vv, $times, ['organization_id' => $v['identifi']['zao'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 1], $doctor_id);
- if ($maf) {
- foreach ($maf as $os) {
- // array_push($scheduleLists, $os);
- $scheduleLists[] = $os;
- }
- }
- }
- if ($v['identifi']['zhong']) {
- $times = $this->num_time($v['identifi']['zhong'], 2);
- if (!$times) {
- return out('', 500, "请先在排班设置中填写本机构的时间段3");
- }
- $maf = $this->getMaf($vv, $times, ['organization_id' => $v['identifi']['zhong'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 2], $doctor_id);
- if ($maf) {
- foreach ($maf as $os) {
- $scheduleLists[] = $os;
- }
- }
- }
- if ($v['identifi']['wan']) {
- $times = $this->num_time($v['identifi']['wan'], 3);
- if (!$times) {
- return out('', 500, "请先在排班设置中填写本机构的时间段4");
- }
- $maf = $this->getMaf($vv, $times, ['organization_id' => $v['identifi']['wan'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 3], $doctor_id);
- if ($maf) {
- foreach ($maf as $os) {
- // array_push($scheduleLists, $os);
- $scheduleLists[] = $os;
- }
- }
- }
- }
- }
- }
- // 查询重复替换
- $chong = [];
- if ($selfScheduleList && $scheduleLists) {
- foreach ($scheduleLists as $k => $v) {
- foreach ($selfScheduleList as $kk => $vv) {
- if ($v['schedule_date'] == $vv['schedule_date']) {
- $chong[$kk]['schedule_id'] = $v['schedule_id'];
- $chong[$kk]['docter_id'] = $v['docter_id'];
- $chong[$kk]['order_num'] = $v['order_num'];
- $chong[$kk]['organization_id'] = $vv['organization_id'];
- $chong[$kk]['time_period_id'] = $vv['time_period_id'];
- $chong[$kk]['type'] = $vv['type'];
- $chong[$kk]['schedule_date'] = $vv['schedule_date'];
- unset($scheduleLists[$k]);
- }
- }
- }
- }
- $listPeriod = array_merge($chong, $scheduleLists);
- SchedulePeriod::insert($listPeriod);
- WeekSchedule::insert($weekList);
- DB::commit();
- return out();
- } catch (\Exception $e) {
- DB::rollBack();
- return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage());
- } catch (\PDOException $e) {
- DB::rollBack();
- return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage());
- }
- }
- /**
- * 修改某一天的数据
- * @author Liu-Yh
- * Create By 2020/12/16 18:46
- */
- public function saveDay($data = [])
- {
- $flag = false;
- if (empty($data)) {
- $req = request()->post();
- $this->validate(request(), [
- 'schedule_date|日期' => 'required',
- 'week|日期' => 'required',
- 'type|类型' => 'required',
- 'organization_id|日期' => 'required',
- ]);
- } else {
- $flag = true;
- $req = $data;
- }
- $user = $this->user;
- $doctor_id = $user['id'];
- $save_data = [];
- // $type_data = explode(',', $req['type']);
- DB::beginTransaction();
- try {
- $findFlag = Sflag::where(['docter_id'=>$doctor_id,'schedule_date'=>$req['schedule_date']])->first();
- if (!$findFlag){
- Sflag::create(['schedule_date'=>$req['schedule_date'],'docter_id'=>$doctor_id]);
- }
- $type_data = json_decode($req['type'],true);
- $finds = SelfSchedule::where(['schedule_date' => $req['schedule_date'], 'docter_id' => $doctor_id, 'schedule_type' => 1])->delete();
- $save_data=[];
- if($type_data['mon']!=0) {
- $mon_times = $this->num_time($type_data['mon'], 1);
- $mf1 = $this->arrangeDay($mon_times, ['organization_id' => $type_data['mon'], 'week' => $req['week'], 'schedule_date' => $req['schedule_date'], 'type' => 1], $doctor_id);
- if($mf1){
- foreach ($mf1 as $v){
- $save_data[] = $v;
- }
- }
- }
- if($type_data['aft']!=0){
- $aft_times = $this->num_time($type_data['aft'], 2);
- $mf2 = $this->arrangeDay($aft_times, ['organization_id' => $type_data['aft'], 'week' => $req['week'], 'schedule_date' => $req['schedule_date'], 'type' => 2], $doctor_id);
- if($mf2){
- foreach ($mf2 as $v){
- $save_data[] = $v;
- }
- }
- }
- if($type_data['nig']!=0) {
- $nig_times = $this->num_time($type_data['nig'], 3);
- $mf3 = $this->arrangeDay($nig_times, ['organization_id' => $type_data['nig'], 'week' => $req['week'], 'schedule_date' => $req['schedule_date'], 'type' => 3], $doctor_id);
- if($mf3){
- foreach ($mf3 as $v){
- $save_data[] = $v;
- }
- }
- }
- if (!$flag){
- $lists = Schedule::where(['docter_id'=>$doctor_id,'schedule_date'=>$req['schedule_date']])->first();
- if($lists){
- SchedulePeriod::where(['docter_id'=>$doctor_id,'schedule_date'=>$req['schedule_date']])->delete();
- if($save_data){
- $chong = [];
- foreach ($save_data as $k => $v) {
- $chong[$k]['schedule_id'] = $lists['id'];
- $chong[$k]['docter_id'] = $v['docter_id'];
- $chong[$k]['order_num'] = 0;
- $chong[$k]['organization_id'] = $v['organization_id'];
- $chong[$k]['time_period_id'] = $v['time_period_id'];
- $chong[$k]['type'] = $v['type'];
- $chong[$k]['schedule_date'] = $v['schedule_date'];
- }
- SchedulePeriod::insert($chong);
- SelfSchedule::insert($save_data);
- }
- }
- }
- DB::commit();
- if ($flag) {
- return true;
- } else {
- return out();
- }
- } catch (\Exception $e) {
- DB::rollBack();
- if ($flag) {
- return false;
- } else {
- return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage());
- }
- } catch (\PDOException $e) {
- DB::rollBack();
- if ($flag) {
- return false;
- } else {
- return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage());
- }
- }
- }
- /**
- * 整理单个修改排班的数据
- * @param $time
- * @param $req
- * @param $doctor_id
- * @return array
- * @author Liu-Yh
- * Create By 2020/12/16 19:00
- */
- protected function arrangeDay($time, $req, $doctor_id)
- {
- $save_data = [];
- foreach ($time as $k => $v) {
- $save_data[$k]['schedule_date'] = $req['schedule_date'];
- $save_data[$k]['week'] = $req['week'];
- $save_data[$k]['schedule_type'] = 1;
- $save_data[$k]['type'] = $req['type'];
- $save_data[$k]['organization_id'] = $req['organization_id'];
- $save_data[$k]['docter_id'] = $doctor_id;
- $save_data[$k]['time_period_id'] = $v;
- }
- return $save_data;
- }
- /**
- * 查看月视图
- * @author Liu-Yh
- * Create By 2020/12/16 19:20
- */
- public function monthDetail()
- {
- $req = request()->post();
- $this->validate(request(), [
- 'start_day|日期' => 'required',
- 'end_day|日期' => 'required',
- ]);
- $user = $this->user;
- $doctor_id = $user['id'];
- $selfScheduleList = SelfSchedule::where('docter_id', '=', $doctor_id)->get();
- $weekSchduleList = WeekSchedule::with('organization')->where('docter_id', '=', $doctor_id)->groupBy('type', 'week')->orderBy('week', 'asc')->get()->toArray();
- // 占用效率
- $scheduleLists = [];
- $moth_date = $this->date_bool($req['start_day'], $req['end_day']);
- $lab=[];
- foreach ($weekSchduleList as $k => $v) {
- $lab[$k]['id'] = $v['id'];
- $lab[$k]['type'] = $v['type']; // 1=早上,2=下午,3=晚上
- $lab[$k]['organization_id'] = $v['organization_id']; // 1=早上,2=下午,3=晚上
- $lab[$k]['flag'] = $v['week'];
- switch ($v['week']) {
- case "7":
- $lab[$k]['week'] = '周日';
- break;
- case "1":
- $lab[$k]['week'] = '周一';
- break;
- case "2":
- $lab[$k]['week'] = '周二';
- break;
- case "3":
- $lab[$k]['week'] = '周三';
- break;
- case "4":
- $lab[$k]['week'] = '周四';
- break;
- case "5":
- $lab[$k]['week'] = '周五';
- break;
- default:
- $lab[$k]['week'] = '周六';
- }
- }
- $newReturn = [];
- $weekList = ['周一', '周二', '周三', '周四', '周五', '周六', '周日'];
- foreach ($lab as $k => $v) {
- if (!isset($newReturn[$v['flag']])) {
- $newReturn[$v['flag']] = $v;
- if ($v['type'] == 1) {
- $newReturn[$v['flag']]['ident']['zao_id'] = $v['organization_id'];
- $newReturn[$v['flag']]['ident']['xia_id'] = 0;
- $newReturn[$v['flag']]['ident']['wan_id'] = 0;
- } else if ($v['type'] == 2) {
- $newReturn[$v['flag']]['ident']['zao_id'] = 0;
- $newReturn[$v['flag']]['ident']['xia_id'] = $v['organization_id'];
- $newReturn[$v['flag']]['ident']['wan_id'] = 0;
- } else {
- $newReturn[$v['flag']]['ident']['zao_id'] = 0;
- $newReturn[$v['flag']]['ident']['xia_id'] = 0;
- $newReturn[$v['flag']]['ident']['wan_id'] = $v['organization_id'];
- }
- } else {
- if ($v['type'] == 1) {
- $newReturn[$v['flag']]['ident']['zao_id'] = $v['organization_id'];
- } else if ($v['type'] == 2) {
- $newReturn[$v['flag']]['ident']['xia_id'] = $v['organization_id'];
- } else {
- $newReturn[$v['flag']]['ident']['wan_id'] = $v['organization_id'];
- }
- }
- }
- $newList = [];
- foreach ($moth_date as $k => $v) {
- $newList[$k]['date'] = $v['date'];
- $newList[$k]['ident']['zao'] = 0;
- $newList[$k]['ident']['xia'] = 0;
- $newList[$k]['ident']['wan'] = 0;
- foreach ($newReturn as $kk => $vv) {
- if ($v['week'] == $vv['flag']) {
- $newList[$k]['date'] = $v['date'];
- $newList[$k]['ident']['zao'] = $vv['ident']['zao_id'];
- $newList[$k]['ident']['xia'] = $vv['ident']['xia_id'];
- $newList[$k]['ident']['wan'] = $vv['ident']['wan_id'];
- }
- }
- }
- $selfList = [];
- if ($selfScheduleList) {
- $putArr = [];
- // 自定义排班数组
- $selfScheduleList = $selfScheduleList->toArray();
- foreach ($selfScheduleList as $k => $v) {
- if (!isset($selfList[$v['schedule_date']])) {
- $selfList[$v['schedule_date']] = $v;
- if ($v['type'] == 1) {
- $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id'];
- $selfList[$v['schedule_date']]['ident']['xia_id'] = 0;
- $selfList[$v['schedule_date']]['ident']['wan_id'] = 0;
- } else if ($v['type'] == 2) {
- $selfList[$v['schedule_date']]['ident']['zao_id'] = 0;
- $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id'];
- $selfList[$v['schedule_date']]['ident']['wan_id'] = 0;
- } else {
- $selfList[$v['schedule_date']]['ident']['zao_id'] = 0;
- $selfList[$v['schedule_date']]['ident']['xia_id'] = 0;
- $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id'];
- }
- } else {
- if ($v['type'] == 1) {
- $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id'];
- } else if ($v['type'] == 2) {
- $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id'];
- } else {
- $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id'];
- }
- }
- }
- // 自定义的
- $pusList = Sflag::where('docter_id',$doctor_id)->get();
- //然后查看下自定义排班是否删除了
- if ($pusList){
- foreach ($pusList as $k=>$v){
- foreach ($selfScheduleList as $kk=>$vv){
- if ($v['schedule_date']==$vv['schedule_date']){
- unset($pusList[$k]);
- }
- }
- }
- foreach ($pusList as $k=>$v){
- $bl = [
- 'schedule_date'=>$v['schedule_date'],
- 'ident'=>[
- 'zao_id'=>0,
- 'xia_id'=>0,
- 'wan_id'=>0,
- ],
- ];
- $selfList[$v['schedule_date']] = $bl;
- }
- }
- foreach ($selfList as $k => $v) {
- foreach ($newList as $kk => $vv) {
- if ($v['schedule_date'] == $vv['date']) {
- $newList[$kk]['date'] = $vv['date'];
- $newList[$kk]['ident']['zao'] = $v['ident']['zao_id'];
- $newList[$kk]['ident']['xia'] = $v['ident']['xia_id'];
- $newList[$kk]['ident']['wan'] = $v['ident']['wan_id'];
- }
- }
- }
- }
- return out($newList);
- }
- /**
- * 获取早中下午的id
- * @param $sid
- * @param $time
- * @param $req
- * @param $doctor_id
- * @return array
- * @author Liu-Yh
- * Create By 2020/11/6 16:27
- */
- protected function getMaf($sid, $time, $req, $doctor_id)
- {
- $maf = [];
- foreach ($time as $k => $v) {
- $maf[$k]['schedule_id'] = $sid;
- $maf[$k]['organization_id'] = $req['organization_id'];
- $maf[$k]['time_period_id'] = $v;
- $maf[$k]['schedule_date'] = $req['schedule_date'];
- $maf[$k]['docter_id'] = $doctor_id;
- $maf[$k]['type'] = $req['type'];
- $maf[$k]['order_num'] = 0;
- }
- return $maf;
- }
- /**
- * 周模板添加数据
- * @param $time
- * @param $req
- * @param $doctor_id
- * @return array
- */
- protected function week_getMaf($time, $req, $doctor_id)
- {
- $maf = [];
- foreach ($time as $k => $v) {
- // $maf[$k]['schedule_id']=$sid;
- // $maf[$k]['schedule_date']=$req['schedule_date'];
- $maf[$k]['type'] = $req['type'];
- $maf[$k]['schedule_type'] = 1;
- $maf[$k]['organization_id'] = $req['organization_id'];
- $maf[$k]['docter_id'] = $doctor_id;
- $maf[$k]['time_period_id'] = $v;
- $maf[$k]['week'] = $req['week'];
- }
- return $maf;
- }
- /**
- * 获取会话列表
- * @return \Illuminate\Http\JsonResponse
- * @author Liu-Yh
- * Create By 2020/11/6 17:11
- */
- public function getUserListMsg()
- {
- $req = request()->post();
- $user = $this->user;
- $doctor_id = $user['id'];
- $where[] = ['product_type', 2];
- $where[] = ['order_status', '>', 2];
- $where[] = ['payment_status', 2];
- $where[] = ['docter_id', $doctor_id];
- $list = Order::with('user')->where($where)->orderBy('receiving_time', 'desc')->get();
- $newList = [];
- if ($list) {
- $list = $list->toArray();
- foreach ($list as $k => $v) {
- $messages = ImMessage::where(['senderId'=>'doctor_'.$doctor_id,'receiverId'=>'member_'.$v['user_id']])->orWhere(function ($query) use ($req,$doctor_id,$v){
- $query->where(['senderId'=>'member_'.$v['user_id'],'receiverId'=>'doctor_'.$doctor_id]);
- })->orderBy('id','desc')->first();
- if($messages){
- if($messages['type']=='text'){
- $newList[$v['user_id']]['out_message'] = $messages['payload'];
- }else if ($messages['type'] == 'audio'){
- $newList[$v['user_id']]['out_message'] = "[语音消息]";
- }else{
- $newList[$v['user_id']]['out_message'] = "[图片消息]";
- }
- if (empty($messages['create_time'])){
- $newList[$v['user_id']]['out_time'] = "";
- }else{
- $newList[$v['user_id']]['out_time'] = date('m-d',$messages['create_time']);
- }
- }else{
- $newList[$v['user_id']]['out_message'] = '';
- $newList[$v['user_id']]['out_time'] = '';
- }
- $newList[$v['user_id']]['flag'] = 'member_' . $v['user_id'];
- $newList[$v['user_id']]['order_status'] = $v['order_status'];
- $newList[$v['user_id']]['nickname'] = $v['user']['nickname'];
- $newList[$v['user_id']]['avatar'] = $v['user']['avatar'];
- $newList[$v['user_id']]['remark'] = !empty($v['user']['remark'])?$v['user']['remark']:'';
- }
- $newList = array_values($newList);
- }
- return out($newList);
- }
- /**
- * 获取认证信息
- * @return mixed
- */
- public function getRenInfo()
- {
- $req = request()->post();
- $user = $this->user;
- $doctor_id = $user['id'];
- // 获取本人认证信息
- $returnRes = [];
- $docter = Docter::where('id', '=', $doctor_id)->first();
- if ($docter) {
- $docter = $docter->toArray();
- } else {
- return $docter;
- }
- $returnRes['info'] = $docter;
- // 获取申请的认证机构
- $org = DocterOrganization::with(['organization'])->where('docter_id', '=', $doctor_id)->get();
- $oqf = DocterOrganization::with(['office', 'qualification'])->where('docter_id', '=', $doctor_id)->get();
- foreach ($org as $k => $v) {
- $org[$k]['province'] = Areas::where('id', '=', $v['organization']['province_id'])->select('name')->first()['name'];
- $org[$k]['city'] = Areas::where('id', '=', $v['organization']['city_id'])->select('name')->first()['name'];
- $org[$k]['area'] = Areas::where('id', '=', $v['organization']['area_id'])->select('name')->first()['name'];
- $org[$k]['name'] = $v['organization']['name'];
- }
- $returnRes['orgList'] = $org;
- $returnRes['oqf'] = $oqf;
- return out($returnRes);
- }
- /**
- * 获取通话记录
- * @return mixed
- */
- public function callLog(){
- $req = request()->post();
- $user = $this->user;
- $doctor_id = $user['id'];
- $where =[];
- if(isset($req['order_id'])&&!empty($req['order_id'])){
- $where['order_id'] = $req['order_id'];
- }
- $where['docter_id'] = $doctor_id;
- $list = CallLog::where($where)->get();
- return out($list);
- }
- /**
- * 通话列表
- * @return mixed
- */
- public function user_call(){
- $req = request()->post();
- $user = $this->user;
- $doctor_id = $user['id'];
- $list=[];
- // var_dump($doctor_id);
- //die();
- if(isset($req['user_id'])&&!empty($req['user_id'])){
- $ids = [];
- $orderList = Order::where(['user_id'=>$req['user_id'],'product_type'=>1,'payment_status'=>2])->select('id')->get();
- if($orderList){
- foreach ($orderList as $k=>$v){
- $ids[$k] = $v['id'];
- }
- }
- $lists = CallLog::with('orders')->whereIn('order_id',$ids)->orderBy('call_time', 'desc')->get();
- if ($lists){
- foreach ($lists as $k=>$v){
- $list[$k]['time'] = $v['call_time'];
- $list[$k]['talk_time'] = $v['talk_time'];
- $list[$k]['order_sn'] = $v['orders']['order_sn'];
- }
- }
- }else{
- $orderList = Order::with(['user','calllog'])->where(['docter_id'=>$doctor_id,'product_type'=>1,'payment_status'=>2])->groupBy(['user_id'])->get();
- if ($orderList){
- foreach ($orderList as $k=>$v){
- $list[$k]['user'] = $v['user'];
- $calls = CallLog::where('docter_id',$doctor_id)->orderBy('id','desc')->first();
- if ($calls){
- $list[$k]['user']['dates'] = $calls['call_time'];
- }else{
- $list[$k]['user']['dates'] = '无';
- }
- $save = UserDocter::where(['user_id'=>$v['user']['id'],'docter_id'=>$doctor_id])->first();
- if ($save) {
- $list[$k]['user']['remark'] = $save['remark'];
- } else {
- $list[$k]['user']['remark'] = '';
- }
- $list[$k]['user']['log'] = $v['calllog'];
- // $list[$k]['log']['date'] = date('m/d',strtotime(end($v['calllog'])['call_time']));
- }
- }
- }
- return out($list);
- }
- /**
- * 获取聊天记录
- * @return mixed
- */
- public function getImList(){
- $req = request()->post();
- $user = $this->user;
- $doctor_id = $user['id'];
- $where =[];
- if(!isset($req['flag'])||empty($req['flag'])){
- return out("",500,'用户flag不能为空');
- }
- $list = ImMessage::where(['senderId'=>'doctor_'.$doctor_id,'receiverId'=>$req['flag']])->orWhere(function ($query) use ($req,$doctor_id){
- $query->where(['senderId'=>$req['flag'],'receiverId'=>'doctor_'.$doctor_id]);
- })->get();
- $newList=[];
- if ($list){
- foreach ($list as $k=>$v){
- $decode = json_decode($v['text'],true);
- // $newList[$k]['id']=$decode['id'];
- $newList[$k]['messageId']=$decode[0]['messageId'];
- $newList[$k]['type']=$decode[0]['type'];
- $newList[$k]['senderId']=$decode[0]['senderId'];
- $newList[$k]['receiverId']=$decode[0]['receiverId'];
- $newList[$k]['timestamp']=$decode[0]['timestamp'];
- $newList[$k]['payload']= json_decode($decode[0]['payload'],true);
- }
- }
- return out($newList);
- }
- }
|