HomeController.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Lib\Backend;
  4. use App\Models\Appointment;
  5. use App\Models\AppSession;
  6. use App\Models\ClientSMS;
  7. use App\Models\Facility;
  8. use App\Models\IncomingReport;
  9. use App\Models\MBPayer;
  10. use App\Models\ProProAccess;
  11. use App\Models\SupplyOrder;
  12. use App\Models\Ticket;
  13. use DateTime;
  14. use App\Models\Client;
  15. use App\Models\Bill;
  16. use App\Models\Measurement;
  17. use App\Models\Note;
  18. use App\Models\Pro;
  19. use App\Models\ProTransaction;
  20. use GuzzleHttp\Cookie\CookieJar;
  21. use Illuminate\Http\Request;
  22. use Illuminate\Support\Facades\Cookie;
  23. use Illuminate\Support\Facades\DB;
  24. use Illuminate\Support\Facades\Http;
  25. class HomeController extends Controller
  26. {
  27. public function confirmSmsAuthToken(Request $request)
  28. {
  29. return view('app/confirm_sms_auth_token');
  30. }
  31. public function setPassword(Request $request)
  32. {
  33. return view('app/set_password');
  34. }
  35. public function setSecurityQuestions(Request $request)
  36. {
  37. return view('app/set_security_questions');
  38. }
  39. public function postConfirmSmsAuthToken(Request $request)
  40. {
  41. try {
  42. $url = config('stag.backendUrl') . '/session/confirmSmsAuthToken';
  43. $data = [
  44. 'cellNumber' => $request->input('cellNumber'),
  45. 'token' => $request->input('token'),
  46. ];
  47. $response = Http::asForm()
  48. ->withHeaders(['sessionKey' => $request->cookie('sessionKey')])
  49. ->post($url, $data)
  50. ->json();
  51. if (!isset($response['success']) || !$response['success']) {
  52. $message = 'API error';
  53. if (isset($response['error'])) {
  54. $message = $response['error'];
  55. if (isset($response['path'])) $message .= ': ' . $response['path'];
  56. } else if (isset($response['message'])) $message = $response['message'];
  57. return redirect('/confirm_sms_auth_token')
  58. ->withInput()
  59. ->with('message', $message);
  60. }
  61. return redirect('/');
  62. } catch (\Exception $e) {
  63. return redirect()->back()
  64. ->with('message', 'Unable to process your request at the moment. Please try again later.')
  65. ->withInput($request->input());
  66. }
  67. }
  68. public function resendSmsAuthToken(Request $request)
  69. {
  70. try {
  71. $url = config('stag.backendUrl') . '/session/resendSmsAuthToken';
  72. $data = [];
  73. $response = Http::asForm()
  74. ->withHeaders(['sessionKey' => $request->cookie('sessionKey')])
  75. ->post($url, $data)
  76. ->json();
  77. if (!isset($response['success']) || !$response['success']) {
  78. $message = 'API error';
  79. if (isset($response['error'])) {
  80. $message = $response['error'];
  81. if (isset($response['path'])) $message .= ': ' . $response['path'];
  82. } else if (isset($response['message'])) $message = $response['message'];
  83. return redirect('/confirm_sms_auth_token')
  84. ->withInput()
  85. ->with('message', $message);
  86. }
  87. return redirect()->back()->withInput()->with('message', "SMS Auth Token sent.");
  88. } catch (\Exception $e) {
  89. return redirect()->back()
  90. ->with('message', 'Unable to process your request at the moment. Please try again later.')
  91. ->withInput($request->input());
  92. }
  93. }
  94. public function postSetPassword(Request $request)
  95. {
  96. try {
  97. $url = config('stag.backendUrl') . '/pro/selfPutPassword';
  98. $data = [
  99. 'newPassword' => $request->input('newPassword'),
  100. 'newPasswordConfirmation' => $request->input('newPasswordConfirmation'),
  101. ];
  102. $response = Http::asForm()
  103. ->withHeaders(['sessionKey' => $request->cookie('sessionKey')])
  104. ->post($url, $data)
  105. ->json();
  106. if (!isset($response['success']) || !$response['success']) {
  107. $message = 'API error';
  108. if (isset($response['error'])) {
  109. $message = $response['error'];
  110. if (isset($response['path'])) $message .= ': ' . $response['path'];
  111. } else if (isset($response['message'])) $message = $response['message'];
  112. return redirect('/set_password')
  113. ->withInput()
  114. ->with('message', $message);
  115. }
  116. return redirect('/');
  117. } catch (\Exception $e) {
  118. return redirect()->back()
  119. ->with('message', 'Unable to process your request at the moment. Please try again later.')
  120. ->withInput($request->input());
  121. }
  122. }
  123. public function postSetSecurityQuestions(Request $request)
  124. {
  125. try {
  126. $url = env('BACKEND_URL', 'http://localhost:8080/api') . '/pro/selfPutSecurityQuestions';
  127. $data = [
  128. 'securityQuestion1' => $request->input('securityQuestion1'),
  129. 'securityAnswer1' => $request->input('securityAnswer1'),
  130. 'securityQuestion2' => $request->input('securityQuestion2'),
  131. 'securityAnswer2' => $request->input('securityAnswer2'),
  132. ];
  133. $response = Http::asForm()
  134. ->withHeaders(['sessionKey' => $request->cookie('sessionKey')])
  135. ->post($url, $data)
  136. ->json();
  137. if (!isset($response['success']) || !$response['success']) {
  138. $message = 'API error';
  139. if (isset($response['error'])) {
  140. $message = $response['error'];
  141. if (isset($response['path'])) $message .= ': ' . $response['path'];
  142. } else if (isset($response['message'])) $message = $response['message'];
  143. return redirect('/set_password')
  144. ->withInput()
  145. ->with('message', $message);
  146. }
  147. return redirect('/');
  148. } catch (\Exception $e) {
  149. return redirect()->back()
  150. ->with('message', 'Unable to process your request at the moment. Please try again later.')
  151. ->withInput($request->input());
  152. }
  153. }
  154. public function dashboard(Request $request)
  155. {
  156. //patients where performer is the mcp
  157. $performer = $this->performer();
  158. $performerProID = $performer->pro->id;
  159. $isAdmin = ($performer->pro->pro_type === 'ADMIN');
  160. $keyNumbers = [];
  161. $queryClients = $this->performer()->pro->getAccessibleClientsQuery();
  162. $keyNumbers['totalPatients'] = $queryClients->count();
  163. // patientNotSeenYet
  164. $patientNotSeenYet = $queryClients
  165. ->where(function ($query) use ($performer) { // own patient and primary OB visit pending
  166. $query->where('mcp_pro_id', $performer->pro->id)
  167. ->where('has_mcp_done_onboarding_visit', '!=', 'YES');
  168. })
  169. ->orWhere(function ($query) { // mcp of any client program and program OB pending
  170. $query->where(function ($_query) {
  171. $_query->select(DB::raw('COUNT(id)'))
  172. ->from('client_program')
  173. ->whereColumn('client_id', 'client.id')
  174. ->where('has_mcp_done_onboarding_visit', '!=', 'YES');
  175. }, '>=', 1);
  176. })->count();
  177. $keyNumbers['patientsNotSeenYet'] = $patientNotSeenYet;
  178. $pendingBillsToSign = Bill::where(function ($query) use ($performerProID) {
  179. $query->where('hcp_pro_id', $performerProID)->where('is_signed_by_hcp', false)->where('is_cancelled', false);
  180. })
  181. ->orWhere(function ($query) use ($performerProID) {
  182. $query->where('cm_pro_id', $performerProID)->where('is_signed_by_cm', false)->where('is_cancelled', false);;
  183. })->orWhere(function ($query) use ($performerProID) {
  184. $query->where('rme_pro_id', $performerProID)->where('is_signed_by_rme', false)->where('is_cancelled', false);;
  185. })->orWhere(function ($query) use ($performerProID) {
  186. $query->where('rmm_pro_id', $performerProID)->where('is_signed_by_rmm', false)->where('is_cancelled', false);;
  187. })->count();
  188. $keyNumbers['pendingBillsToSign'] = $pendingBillsToSign;
  189. $pendingNotesToSign = Note::where(function ($query) use ($performerProID) {
  190. $query->where('hcp_pro_id', $performerProID)->where('is_signed_by_hcp', false)->where('is_cancelled', false);;
  191. })
  192. ->orWhere(function ($query) use ($performerProID) {
  193. $query->where('ally_pro_id', $performerProID)->where('is_signed_by_ally', false)->where('is_cancelled', false);;
  194. })->count();
  195. $keyNumbers['pendingNotesToSign'] = $pendingNotesToSign;
  196. // open tickets
  197. $keyNumbers['numOpenTickets'] = Ticket::where('is_open', true)
  198. ->where(function ($q) use ($performerProID) {
  199. $q->where('assigned_pro_id', $performerProID)
  200. ->orWhere('manager_pro_id', $performerProID)
  201. ->orWhere('ordering_pro_id', $performerProID)
  202. ->orWhere('initiating_pro_id', $performerProID);
  203. })
  204. ->count();
  205. // num measurements that need stamping
  206. $keyNumbers['measurementsToBeStamped'] = ($this->performer()->pro->pro_type === 'ADMIN' ? '-' : count($this->performer()->pro->getMeasurements(true)));
  207. $reimbursement = [];
  208. $reimbursement["currentBalance"] = $performer->pro->balance;
  209. $reimbursement["nextPaymentDate"] = '--';
  210. $lastPayment = ProTransaction::where('pro_id', $performerProID)->where('plus_or_minus', 'PLUS')->orderBy('created_at', 'DESC')->first();
  211. if ($lastPayment) {
  212. $reimbursement["lastPayment"] = $lastPayment->amount;
  213. $reimbursement["lastPaymentDate"] = $lastPayment->created_at;
  214. } else {
  215. $reimbursement["lastPayment"] = '--';
  216. $reimbursement["lastPaymentDate"] = '--';
  217. }
  218. //if today is < 15th, next payment is 15th, else nextPayment is
  219. $today = strtotime(date('Y-m-d'));
  220. $todayDate = date('j', $today);
  221. $todayMonth = date('m', $today);
  222. $todayYear = date('Y', $today);
  223. if ($todayDate < 15) {
  224. $nextPaymentDate = new DateTime();
  225. $nextPaymentDate->setDate($todayYear, $todayMonth, 15);
  226. $reimbursement['nextPaymentDate'] = $nextPaymentDate->format('m/d/Y');
  227. } else {
  228. $nextPaymentDate = new \DateTime();
  229. $lastDayOfMonth = date('t', $today);
  230. $nextPaymentDate->setDate($todayYear, $todayMonth, $lastDayOfMonth);
  231. $reimbursement['nextPaymentDate'] = $nextPaymentDate->format('m/d/Y');
  232. }
  233. //expectedPay
  234. $expectedForHcp = DB::select(DB::raw("SELECT coalesce(SUM(hcp_expected_payment_amount),0) as expected_pay FROM bill WHERE hcp_pro_id = :performerProID AND has_hcp_been_paid = false AND is_signed_by_hcp IS TRUE AND is_cancelled = false"), ['performerProID' => $performerProID])[0]->expected_pay;
  235. $expectedForCm = DB::select(DB::raw("SELECT coalesce(SUM(cm_expected_payment_amount),0) as expected_pay FROM bill WHERE cm_pro_id = :performerProID AND has_cm_been_paid = false AND is_signed_by_cm IS TRUE AND is_cancelled = false"), ['performerProID' => $performerProID])[0]->expected_pay;
  236. $expectedForRme = DB::select(DB::raw("SELECT coalesce(SUM(rme_expected_payment_amount),0) as expected_pay FROM bill WHERE rme_pro_id = :performerProID AND has_rme_been_paid = false AND is_signed_by_rme IS TRUE AND is_cancelled = false"), ['performerProID' => $performerProID])[0]->expected_pay;
  237. $expectedForRmm = DB::select(DB::raw("SELECT coalesce(SUM(rmm_expected_payment_amount),0) as expected_pay FROM bill WHERE rmm_pro_id = :performerProID AND has_rmm_been_paid = false AND is_signed_by_rmm IS TRUE AND is_cancelled = false"), ['performerProID' => $performerProID])[0]->expected_pay;
  238. $expectedForNa = DB::select(DB::raw("SELECT coalesce(SUM(na_expected_payment_amount),0) as expected_pay FROM bill WHERE na_pro_id = :performerProID AND has_na_been_paid = false AND is_signed_by_hcp IS TRUE AND is_cancelled = false"), ['performerProID' => $performerProID])[0]->expected_pay;
  239. $totalExpectedAmount = $expectedForHcp + $expectedForCm + $expectedForRme + $expectedForRmm + $expectedForNa;
  240. $reimbursement['nextPaymentAmount'] = $totalExpectedAmount;
  241. $milliseconds = strtotime(date('Y-m-d')) . '000';
  242. $measurements = $performer->pro->getMeasurements();
  243. // bills & claims
  244. $businessNumbers = [];
  245. // Notes with bills to resolve
  246. $businessNumbers['notesWithBillsToResolve'] = Note::where('is_cancelled', '!=', true)
  247. ->where('is_bill_closed', '!=', true)
  248. ->whereRaw('(SELECT count(id) FROM bill WHERE note_id = note.id AND is_cancelled = false AND is_verified = false) > 0')
  249. ->count();
  250. // Notes pending bill closure
  251. $businessNumbers['notesPendingBillingClosure'] = Note::where('is_cancelled', '!=', true)
  252. ->where('is_bill_closed', '!=', true)
  253. ->whereRaw('(SELECT count(id) FROM bill WHERE note_id = note.id AND (is_cancelled = true OR is_verified = true)) = 0')
  254. ->count();
  255. // incoming reports not signed
  256. $incomingReports = IncomingReport::where('hcp_pro_id', $performerProID)
  257. ->where('has_hcp_pro_signed', false)
  258. ->where('is_entry_error', false)
  259. ->orderBy('created_at', 'ASC')
  260. ->get();
  261. // erx, labs & imaging that are not closed
  262. $tickets = Ticket::where('ordering_pro_id', $performerProID)
  263. ->where('is_entry_error', false)
  264. ->where('is_open', true)
  265. ->orderBy('created_at', 'ASC')
  266. ->get();
  267. $supplyOrders = SupplyOrder::where('is_cleared_for_shipment', false)
  268. ->where('is_cancelled', false)
  269. ->whereRaw('created_by_session_id IN (SELECT id FROM app_session where pro_id = ?)', [$performer->pro->id])
  270. ->orderBy('created_at', 'ASC')
  271. ->get();
  272. $numERx = Ticket::where('ordering_pro_id', $performerProID)
  273. ->where('category', 'erx')
  274. ->where('is_entry_error', false)
  275. ->where('is_open', true)
  276. ->count();
  277. $numLabs = Ticket::where('ordering_pro_id', $performerProID)
  278. ->where('category', 'lab')
  279. ->where('is_entry_error', false)
  280. ->where('is_open', true)
  281. ->count();
  282. $numImaging = Ticket::where('ordering_pro_id', $performerProID)
  283. ->where('category', 'imaging')
  284. ->where('is_entry_error', false)
  285. ->where('is_open', true)
  286. ->count();
  287. $numSupplyOrders = SupplyOrder::where('is_cleared_for_shipment', false)
  288. ->where('is_cancelled', false)
  289. ->whereRaw('created_by_session_id IN (SELECT id FROM app_session where pro_id = ?)', [$performer->pro->id])
  290. ->count();
  291. return view('app/dashboard', compact('keyNumbers', 'reimbursement', 'milliseconds', 'measurements', 'businessNumbers',
  292. 'incomingReports', 'tickets', 'supplyOrders',
  293. 'numERx', 'numLabs', 'numImaging', 'numSupplyOrders'));
  294. }
  295. public function dashboardAppointments(Request $request, $from, $to) {
  296. $performer = $this->performer();
  297. $performerProID = $performer->pro->id;
  298. $isAdmin = ($performer->pro->pro_type === 'ADMIN');
  299. $appointments = Appointment::where("start_time", '>=', $from)->where("start_time", '<=', $to.' 23:59:00+00');
  300. if(!$isAdmin) {
  301. $appointments = $appointments->where("pro_id", $performerProID);
  302. }
  303. $appointments = $appointments
  304. ->orderBy('start_time', 'asc')
  305. ->get();
  306. foreach ($appointments as $appointment) {
  307. $date = explode(" ", $appointment->start_time)[0];
  308. $appointment->milliseconds = strtotime($date) . '000';
  309. $appointment->newStatus = $appointment->status;
  310. $appointment->dateYMD = date('Y-m-d', strtotime($appointment->raw_date));
  311. $appointment->clientName = $appointment->client->displayName();
  312. $appointment->clientInitials = substr($appointment->client->name_first, 0, 1) . substr($appointment->client->name_last, 0, 1);
  313. $appointment->proInitials = substr($appointment->pro->name_first, 0, 1) . substr($appointment->pro->name_last, 0, 1);
  314. $appointment->friendlyStartTime = friendly_time($appointment->raw_start_time);
  315. $appointment->friendlyEndTime = friendly_time($appointment->raw_end_time);
  316. $appointment->clientSummary = friendly_date_time($appointment->client->dob, false) . ' (' .
  317. $appointment->client->age_in_years . ' y.o' .
  318. ($appointment->client->sex ? ' ' . $appointment->client->sex : '') .
  319. ')';
  320. $appointment->started = false;
  321. $appointment->inHowManyHours = date_diff(date_create('now'), date_create($appointment->start_time), false)
  322. ->format('%R%h h, %i m');
  323. if ($appointment->inHowManyHours[0] === '-') {
  324. $appointment->inHowManyHours = substr($appointment->inHowManyHours, 1) . ' ago';
  325. $appointment->started = true;
  326. } else {
  327. $appointment->inHowManyHours = 'Appt. in ' . substr($appointment->inHowManyHours, 1);
  328. }
  329. $appointment->clientUid = $appointment->client->uid;
  330. $appointment->proUid = $appointment->pro->uid;
  331. $appointment->proName = $appointment->pro->displayName();
  332. }
  333. return json_encode($appointments);
  334. }
  335. public function dashboardMeasurements(Request $request, $filter) {
  336. $measurements = $this->performer()->pro->getMeasurements($filter === 'NEED_ACK');
  337. return json_encode($measurements);
  338. }
  339. public function patients(Request $request, $filter = '')
  340. {
  341. $performer = $this->performer();
  342. $query = $performer->pro->getAccessibleClientsQuery();
  343. switch ($filter) {
  344. case 'not-yet-seen':
  345. $query = $query
  346. ->where(function ($query) use ($performer) {
  347. $query
  348. ->where(function ($query) use ($performer) { // own patient and primary OB visit pending
  349. $query->where('mcp_pro_id', $performer->pro->id)
  350. ->where('has_mcp_done_onboarding_visit', '<>', 'YES');
  351. })
  352. ->orWhere(function ($query) use ($performer) { // mcp of any client program and program OB pending
  353. $query->select(DB::raw('COUNT(id)'))
  354. ->from('client_program')
  355. ->whereColumn('client_id', 'client.id')
  356. ->where('mcp_pro_id', $performer->pro->id)
  357. ->where('has_mcp_done_onboarding_visit', '<>', 'YES');
  358. }, '>=', 1);
  359. });
  360. break;
  361. // more cases can be added as needed
  362. default:
  363. break;
  364. }
  365. $patients = $query->orderBy('id', 'desc')->paginate(500);
  366. return view('app/patients', compact('patients', 'filter'));
  367. }
  368. public function patientsSuggest(Request $request)
  369. {
  370. $pro = $this->pro;
  371. $term = $request->input('term') ? trim($request->input('term')) : '';
  372. if (empty($term)) return '';
  373. $clientQuery= Client::where(function ($q) use ($term) {
  374. $q->where('name_first', 'ILIKE', '%' . $term . '%')
  375. ->orWhere('name_last', 'ILIKE', '%' . $term . '%')
  376. ->orWhere('cell_number', 'ILIKE', '%' . $term . '%');
  377. });
  378. if($pro->pro_type != 'ADMIN') {
  379. $clientQuery->where(function ($q) use ($pro) {
  380. $q->whereIn('id', $pro->getMyClientIds())
  381. ->orWhereNull('mcp_pro_id');
  382. });
  383. }
  384. $clients = $clientQuery->get();
  385. return view('app/patient-suggest', compact('clients'));
  386. }
  387. public function pharmacySuggest(Request $request)
  388. {
  389. $term = $request->input('term') ? trim($request->input('term')) : '';
  390. if (empty($term)) return '';
  391. $term = strtolower($term);
  392. $pharmacies = Facility::where('facility_type', 'Pharmacy')
  393. ->where(function ($q) use ($term) {
  394. $q->orWhereRaw('LOWER(name::text) LIKE ?', ['%' . $term . '%'])
  395. ->orWhereRaw('LOWER(address_line1::text) LIKE ?', ['%' . $term . '%'])
  396. ->orWhereRaw('LOWER(address_line2::text) LIKE ?', ['%' . $term . '%'])
  397. ->orWhereRaw('LOWER(address_city::text) LIKE ?', ['%' . $term . '%'])
  398. ->orWhereRaw('LOWER(address_state::text) LIKE ?', ['%' . $term . '%'])
  399. ->orWhereRaw('LOWER(phone::text) LIKE ?', ['%' . $term . '%'])
  400. ->orWhereRaw('LOWER(address_zip::text) LIKE ?', ['%' . $term . '%']);
  401. })
  402. ->orderBy('name', 'asc')
  403. ->orderBy('address_line1', 'asc')
  404. ->orderBy('address_city', 'asc')
  405. ->orderBy('address_state', 'asc')
  406. ->get();
  407. return view('app/pharmacy-suggest', compact('pharmacies'));
  408. }
  409. public function proSuggest(Request $request) {
  410. $term = $request->input('term') ? trim($request->input('term')) : '';
  411. if (empty($term)) return '';
  412. $term = strtolower($term);
  413. $pros = Pro::where(function ($q) use ($term) {
  414. $q->orWhereRaw('LOWER(name_first::text) LIKE ?', ['%' . $term . '%'])
  415. ->orWhereRaw('LOWER(name_last::text) LIKE ?', ['%' . $term . '%'])
  416. ->orWhereRaw('cell_number LIKE ?', ['%' . $term . '%']);
  417. });
  418. if($this->performer->pro && $this->performer->pro->pro_type != 'ADMIN'){
  419. $accessiblePros = ProProAccess::where('owner_pro_id', $this->performer->pro->id);
  420. $accessibleProIds = [];
  421. foreach($accessiblePros as $accessiblePro){
  422. $accessibleProIds[] = $accessiblePro->id;
  423. }
  424. $accessibleProIds[] = $this->performer->pro->id;
  425. $pros->whereIn('id', $accessibleProIds);
  426. }
  427. $suggestedPros = $pros->orderBy('name_last')->orderBy('name_first')->get();
  428. return view('app/pro-suggest', compact('suggestedPros'));
  429. }
  430. public function proDisplayName(Request $request, Pro $pro) {
  431. return $pro ? $pro->displayName() : '';
  432. }
  433. public function unmappedSMS(Request $request, $filter = '')
  434. {
  435. $proID = $this->performer()->pro->id;
  436. if ($this->performer()->pro->pro_type === 'ADMIN') {
  437. $query = Client::where('id', '>', 0);
  438. } else {
  439. $query = Client::where(function ($q) use ($proID) {
  440. $q->where('mcp_pro_id', $proID)
  441. ->orWhere('cm_pro_id', $proID)
  442. ->orWhere('rmm_pro_id', $proID)
  443. ->orWhere('rme_pro_id', $proID)
  444. ->orWhereRaw('id IN (SELECT client_id FROM client_pro_access WHERE is_active AND pro_id = ?)', [$proID]);
  445. });
  446. }
  447. $patients = $query->orderBy('name_last', 'asc')->orderBy('name_first', 'asc')->get();
  448. $unmappedSMS = ClientSMS::where('client_id', null)->where('incoming_or_outgoing', 'INCOMING')->get();
  449. return view('app/unmapped-sms', compact('unmappedSMS', 'patients'));
  450. }
  451. public function newPatient(Request $request)
  452. {
  453. $mbPayers = MBPayer::all();
  454. return view('app/new-patient', compact('mbPayers'));
  455. }
  456. public function newNonMcnPatient(Request $request)
  457. {
  458. $mbPayers = MBPayer::all();
  459. return view('app/new-non-mcn-patient', compact('mbPayers'));
  460. }
  461. public function mc(Request $request, $fragment = "")
  462. {
  463. $page = "/";
  464. if ($fragment) {
  465. $page = '/' . $fragment;
  466. }
  467. return view('app/mc', compact('page'));
  468. }
  469. public function blank(Request $request)
  470. {
  471. return view('app/blank');
  472. }
  473. public function noteTemplateSet(Request $request, $section, $template)
  474. {
  475. return view('app/patient/note/_template', [
  476. "sectionInternalName" => $section,
  477. "templateName" => $template
  478. ]);
  479. }
  480. public function noteExamTemplateSet(Request $request, $exam, $template)
  481. {
  482. return view('app/patient/note/_template-exam', [
  483. "exam" => $exam,
  484. "sectionInternalName" => 'exam-' . $exam . '-detail',
  485. "templateName" => $template
  486. ]);
  487. }
  488. public function logInAs(Request $request)
  489. {
  490. if($this->pro->pro_type != 'ADMIN'){
  491. return redirect()->to(route('dashboard'));
  492. }
  493. $pros = Pro
  494. ::where('pro_type', '!=', 'ADMIN')
  495. ->orWhereNull('pro_type')
  496. ->orderBy('name_last', 'asc')
  497. ->orderBy('name_first', 'asc')
  498. ->get();
  499. return view('app/log-in-as', compact('pros'));
  500. }
  501. public function processLogInAs(Request $request)
  502. {
  503. $api = new Backend();
  504. try {
  505. $apiResponse = $api->post('session/proLogInAs', [
  506. 'proUid' => $request->post('proUid')
  507. ],
  508. [
  509. 'sessionKey'=>$this->performer()->session_key
  510. ]);
  511. $data = json_decode($apiResponse->getContents());
  512. if (!property_exists($data, 'success') || !$data->success) {
  513. return redirect()->to(route('log-in-as'))->with('message', $data->message)
  514. ->withInput($request->input());
  515. }
  516. Cookie::queue('sessionKey', $data->data->sessionKey);
  517. return redirect('/mc');
  518. } catch (\Exception $e) {
  519. return redirect()->to(route('log-in-as'))
  520. ->with('message', 'Unable to process your request at the moment. Please try again later.')
  521. ->withInput($request->input());
  522. }
  523. }
  524. public function backToAdminPro(Request $request){
  525. $adminPerformerId = $this->performer->logged_in_as_pro_from_admin_pro_app_session_id;
  526. $adminPerformer = AppSession::where('id', $adminPerformerId)->first();
  527. $url = "/session/pro_log_in_with_session_key/".$adminPerformer->session_key;
  528. $api = new Backend();
  529. try {
  530. $apiResponse = $api->post($url, []);
  531. $data = json_decode($apiResponse->getContents());
  532. if (!property_exists($data, 'success') || !$data->success) {
  533. return redirect()->to(route('logout'));
  534. }
  535. Cookie::queue('sessionKey', $data->data->sessionKey);
  536. return redirect(route('dashboard'));
  537. } catch (\Exception $e) {
  538. return redirect(route('dashboard'));
  539. }
  540. }
  541. }