HomeController.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652
  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. // unacknowledged cancelled bills for authed pro
  208. $keyNumbers['unacknowledgedCancelledBills'] = Bill::where('hcp_pro_id', $performerProID)
  209. ->where('is_cancelled', true)
  210. ->where('is_cancellation_acknowledged', false)
  211. ->count();
  212. $reimbursement = [];
  213. $reimbursement["currentBalance"] = $performer->pro->balance;
  214. $reimbursement["nextPaymentDate"] = '--';
  215. $lastPayment = ProTransaction::where('pro_id', $performerProID)->where('plus_or_minus', 'PLUS')->orderBy('created_at', 'DESC')->first();
  216. if ($lastPayment) {
  217. $reimbursement["lastPayment"] = $lastPayment->amount;
  218. $reimbursement["lastPaymentDate"] = $lastPayment->created_at;
  219. } else {
  220. $reimbursement["lastPayment"] = '--';
  221. $reimbursement["lastPaymentDate"] = '--';
  222. }
  223. //if today is < 15th, next payment is 15th, else nextPayment is
  224. $today = strtotime(date('Y-m-d'));
  225. $todayDate = date('j', $today);
  226. $todayMonth = date('m', $today);
  227. $todayYear = date('Y', $today);
  228. if ($todayDate < 15) {
  229. $nextPaymentDate = new DateTime();
  230. $nextPaymentDate->setDate($todayYear, $todayMonth, 15);
  231. $reimbursement['nextPaymentDate'] = $nextPaymentDate->format('m/d/Y');
  232. } else {
  233. $nextPaymentDate = new \DateTime();
  234. $lastDayOfMonth = date('t', $today);
  235. $nextPaymentDate->setDate($todayYear, $todayMonth, $lastDayOfMonth);
  236. $reimbursement['nextPaymentDate'] = $nextPaymentDate->format('m/d/Y');
  237. }
  238. //expectedPay
  239. $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;
  240. $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;
  241. $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;
  242. $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;
  243. $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;
  244. $totalExpectedAmount = $expectedForHcp + $expectedForCm + $expectedForRme + $expectedForRmm + $expectedForNa;
  245. $reimbursement['nextPaymentAmount'] = $totalExpectedAmount;
  246. $milliseconds = strtotime(date('Y-m-d')) . '000';
  247. $measurements = $performer->pro->getMeasurements();
  248. // bills & claims
  249. $businessNumbers = [];
  250. // Notes with bills to resolve
  251. $businessNumbers['notesWithBillsToResolve'] = 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 = false AND is_verified = false) > 0')
  254. ->count();
  255. // Notes pending bill closure
  256. $businessNumbers['notesPendingBillingClosure'] = Note::where('is_cancelled', '!=', true)
  257. ->where('is_bill_closed', '!=', true)
  258. ->whereRaw('(SELECT count(id) FROM bill WHERE note_id = note.id AND (is_cancelled = true OR is_verified = true)) = 0')
  259. ->count();
  260. // incoming reports not signed
  261. $incomingReports = IncomingReport::where('hcp_pro_id', $performerProID)
  262. ->where('has_hcp_pro_signed', false)
  263. ->where('is_entry_error', false)
  264. ->orderBy('created_at', 'ASC')
  265. ->get();
  266. // erx, labs & imaging that are not closed
  267. $tickets = Ticket::where('ordering_pro_id', $performerProID)
  268. ->where('is_entry_error', false)
  269. ->where('is_open', true)
  270. ->orderBy('created_at', 'ASC')
  271. ->get();
  272. $supplyOrders = SupplyOrder::where('is_cleared_for_shipment', false)
  273. ->where('is_cancelled', false)
  274. ->whereRaw('created_by_session_id IN (SELECT id FROM app_session where pro_id = ?)', [$performer->pro->id])
  275. ->orderBy('created_at', 'ASC')
  276. ->get();
  277. $numERx = Ticket::where('ordering_pro_id', $performerProID)
  278. ->where('category', 'erx')
  279. ->where('is_entry_error', false)
  280. ->where('is_open', true)
  281. ->count();
  282. $numLabs = Ticket::where('ordering_pro_id', $performerProID)
  283. ->where('category', 'lab')
  284. ->where('is_entry_error', false)
  285. ->where('is_open', true)
  286. ->count();
  287. $numImaging = Ticket::where('ordering_pro_id', $performerProID)
  288. ->where('category', 'imaging')
  289. ->where('is_entry_error', false)
  290. ->where('is_open', true)
  291. ->count();
  292. $numSupplyOrders = SupplyOrder::where('is_cleared_for_shipment', false)
  293. ->where('is_cancelled', false)
  294. ->whereRaw('created_by_session_id IN (SELECT id FROM app_session where pro_id = ?)', [$performer->pro->id])
  295. ->count();
  296. return view('app/dashboard', compact('keyNumbers', 'reimbursement', 'milliseconds', 'measurements', 'businessNumbers',
  297. 'incomingReports', 'tickets', 'supplyOrders',
  298. 'numERx', 'numLabs', 'numImaging', 'numSupplyOrders'));
  299. }
  300. public function dashboardAppointments(Request $request, $from, $to) {
  301. $performer = $this->performer();
  302. $performerProID = $performer->pro->id;
  303. $isAdmin = ($performer->pro->pro_type === 'ADMIN');
  304. $appointments = Appointment::where("start_time", '>=', $from)->where("start_time", '<=', $to.' 23:59:00+00');
  305. if(!$isAdmin) {
  306. $appointments = $appointments->where("pro_id", $performerProID);
  307. }
  308. $appointments = $appointments
  309. ->orderBy('start_time', 'asc')
  310. ->get();
  311. foreach ($appointments as $appointment) {
  312. $date = explode(" ", $appointment->start_time)[0];
  313. $appointment->milliseconds = strtotime($date) . '000';
  314. $appointment->newStatus = $appointment->status;
  315. $appointment->dateYMD = date('Y-m-d', strtotime($appointment->raw_date));
  316. $appointment->clientName = $appointment->client->displayName();
  317. $appointment->clientInitials = substr($appointment->client->name_first, 0, 1) . substr($appointment->client->name_last, 0, 1);
  318. $appointment->proInitials = substr($appointment->pro->name_first, 0, 1) . substr($appointment->pro->name_last, 0, 1);
  319. $appointment->friendlyStartTime = friendly_time($appointment->raw_start_time);
  320. $appointment->friendlyEndTime = friendly_time($appointment->raw_end_time);
  321. $appointment->clientSummary = friendly_date_time($appointment->client->dob, false) . ' (' .
  322. $appointment->client->age_in_years . ' y.o' .
  323. ($appointment->client->sex ? ' ' . $appointment->client->sex : '') .
  324. ')';
  325. $appointment->started = false;
  326. $appointment->inHowManyHours = date_diff(date_create('now'), date_create($appointment->start_time), false)
  327. ->format('%R%h h, %i m');
  328. if ($appointment->inHowManyHours[0] === '-') {
  329. $appointment->inHowManyHours = substr($appointment->inHowManyHours, 1) . ' ago';
  330. $appointment->started = true;
  331. } else {
  332. $appointment->inHowManyHours = 'Appt. in ' . substr($appointment->inHowManyHours, 1);
  333. }
  334. $appointment->clientUid = $appointment->client->uid;
  335. $appointment->proUid = $appointment->pro->uid;
  336. $appointment->proName = $appointment->pro->displayName();
  337. unset($appointment->client);
  338. unset($appointment->pro);
  339. unset($appointment->detail_json);
  340. }
  341. return json_encode($appointments);
  342. }
  343. public function dashboardMeasurements(Request $request, $filter) {
  344. $measurements = $this->performer()->pro->getMeasurements($filter === 'NEED_ACK');
  345. return json_encode($measurements);
  346. }
  347. public function patients(Request $request, $filter = '')
  348. {
  349. $performer = $this->performer();
  350. $query = $performer->pro->getAccessibleClientsQuery();
  351. switch ($filter) {
  352. case 'not-yet-seen':
  353. $query = $query
  354. ->where(function ($query) use ($performer) {
  355. $query
  356. ->where(function ($query) use ($performer) { // own patient and primary OB visit pending
  357. $query->where('mcp_pro_id', $performer->pro->id)
  358. ->where('has_mcp_done_onboarding_visit', '<>', 'YES');
  359. })
  360. ->orWhere(function ($query) use ($performer) { // mcp of any client program and program OB pending
  361. $query->select(DB::raw('COUNT(id)'))
  362. ->from('client_program')
  363. ->whereColumn('client_id', 'client.id')
  364. ->where('mcp_pro_id', $performer->pro->id)
  365. ->where('has_mcp_done_onboarding_visit', '<>', 'YES');
  366. }, '>=', 1);
  367. });
  368. break;
  369. // more cases can be added as needed
  370. default:
  371. break;
  372. }
  373. $patients = $query->orderBy('id', 'desc')->paginate(50);
  374. return view('app/patients', compact('patients', 'filter'));
  375. }
  376. public function patientsSuggest(Request $request)
  377. {
  378. $pro = $this->pro;
  379. $term = $request->input('term') ? trim($request->input('term')) : '';
  380. if (empty($term)) return '';
  381. $clientQuery= Client::where(function ($q) use ($term) {
  382. $q->where('name_first', 'ILIKE', '%' . $term . '%')
  383. ->orWhere('name_last', 'ILIKE', '%' . $term . '%')
  384. ->orWhere('cell_number', 'ILIKE', '%' . $term . '%');
  385. });
  386. if($pro->pro_type != 'ADMIN') {
  387. $clientQuery->where(function ($q) use ($pro) {
  388. $q->whereIn('id', $pro->getMyClientIds())
  389. ->orWhereNull('mcp_pro_id');
  390. });
  391. }
  392. $clients = $clientQuery->get();
  393. return view('app/patient-suggest', compact('clients'));
  394. }
  395. public function pharmacySuggest(Request $request)
  396. {
  397. $term = $request->input('term') ? trim($request->input('term')) : '';
  398. if (empty($term)) return '';
  399. $term = strtolower($term);
  400. $pharmacies = Facility::where('facility_type', 'Pharmacy')
  401. ->where(function ($q) use ($term) {
  402. $q->orWhereRaw('LOWER(name::text) LIKE ?', ['%' . $term . '%'])
  403. ->orWhereRaw('LOWER(address_line1::text) LIKE ?', ['%' . $term . '%'])
  404. ->orWhereRaw('LOWER(address_line2::text) LIKE ?', ['%' . $term . '%'])
  405. ->orWhereRaw('LOWER(address_city::text) LIKE ?', ['%' . $term . '%'])
  406. ->orWhereRaw('LOWER(address_state::text) LIKE ?', ['%' . $term . '%'])
  407. ->orWhereRaw('LOWER(phone::text) LIKE ?', ['%' . $term . '%'])
  408. ->orWhereRaw('LOWER(address_zip::text) LIKE ?', ['%' . $term . '%']);
  409. })
  410. ->orderBy('name', 'asc')
  411. ->orderBy('address_line1', 'asc')
  412. ->orderBy('address_city', 'asc')
  413. ->orderBy('address_state', 'asc')
  414. ->get();
  415. return view('app/pharmacy-suggest', compact('pharmacies'));
  416. }
  417. public function proSuggest(Request $request) {
  418. $term = $request->input('term') ? trim($request->input('term')) : '';
  419. if (empty($term)) return '';
  420. $term = strtolower($term);
  421. $pros = Pro::where(function ($q) use ($term) {
  422. $q->orWhereRaw('LOWER(name_first::text) LIKE ?', ['%' . $term . '%'])
  423. ->orWhereRaw('LOWER(name_last::text) LIKE ?', ['%' . $term . '%'])
  424. ->orWhereRaw('cell_number LIKE ?', ['%' . $term . '%']);
  425. });
  426. if($this->performer->pro && $this->performer->pro->pro_type != 'ADMIN'){
  427. $accessiblePros = ProProAccess::where('owner_pro_id', $this->performer->pro->id);
  428. $accessibleProIds = [];
  429. foreach($accessiblePros as $accessiblePro){
  430. $accessibleProIds[] = $accessiblePro->id;
  431. }
  432. $accessibleProIds[] = $this->performer->pro->id;
  433. $pros->whereIn('id', $accessibleProIds);
  434. }
  435. $suggestedPros = $pros->orderBy('name_last')->orderBy('name_first')->get();
  436. return view('app/pro-suggest', compact('suggestedPros'));
  437. }
  438. public function proDisplayName(Request $request, Pro $pro) {
  439. return $pro ? $pro->displayName() : '';
  440. }
  441. public function unmappedSMS(Request $request, $filter = '')
  442. {
  443. $proID = $this->performer()->pro->id;
  444. if ($this->performer()->pro->pro_type === 'ADMIN') {
  445. $query = Client::where('id', '>', 0);
  446. } else {
  447. $query = Client::where(function ($q) use ($proID) {
  448. $q->where('mcp_pro_id', $proID)
  449. ->orWhere('cm_pro_id', $proID)
  450. ->orWhere('rmm_pro_id', $proID)
  451. ->orWhere('rme_pro_id', $proID)
  452. ->orWhereRaw('id IN (SELECT client_id FROM client_pro_access WHERE is_active AND pro_id = ?)', [$proID]);
  453. });
  454. }
  455. $patients = $query->orderBy('name_last', 'asc')->orderBy('name_first', 'asc')->get();
  456. $unmappedSMS = ClientSMS::where('client_id', null)->where('incoming_or_outgoing', 'INCOMING')->get();
  457. return view('app/unmapped-sms', compact('unmappedSMS', 'patients'));
  458. }
  459. public function newPatient(Request $request)
  460. {
  461. $mbPayers = MBPayer::all();
  462. return view('app/new-patient', compact('mbPayers'));
  463. }
  464. public function newNonMcnPatient(Request $request)
  465. {
  466. $mbPayers = MBPayer::all();
  467. return view('app/new-non-mcn-patient', compact('mbPayers'));
  468. }
  469. public function mc(Request $request, $fragment = "")
  470. {
  471. $page = "/";
  472. if ($fragment) {
  473. $page = '/' . $fragment;
  474. }
  475. return view('app/mc', compact('page'));
  476. }
  477. public function blank(Request $request)
  478. {
  479. return view('app/blank');
  480. }
  481. public function noteTemplateSet(Request $request, $section, $template)
  482. {
  483. return view('app/patient/note/_template', [
  484. "sectionInternalName" => $section,
  485. "templateName" => $template
  486. ]);
  487. }
  488. public function noteExamTemplateSet(Request $request, $exam, $template)
  489. {
  490. return view('app/patient/note/_template-exam', [
  491. "exam" => $exam,
  492. "sectionInternalName" => 'exam-' . $exam . '-detail',
  493. "templateName" => $template
  494. ]);
  495. }
  496. public function logInAs(Request $request)
  497. {
  498. if($this->pro->pro_type != 'ADMIN'){
  499. return redirect()->to(route('dashboard'));
  500. }
  501. $pros = Pro
  502. ::where('pro_type', '!=', 'ADMIN')
  503. ->orWhereNull('pro_type')
  504. ->orderBy('name_last', 'asc')
  505. ->orderBy('name_first', 'asc')
  506. ->get();
  507. return view('app/log-in-as', compact('pros'));
  508. }
  509. public function processLogInAs(Request $request)
  510. {
  511. $api = new Backend();
  512. try {
  513. $apiResponse = $api->post('session/proLogInAs', [
  514. 'proUid' => $request->post('proUid')
  515. ],
  516. [
  517. 'sessionKey'=>$this->performer()->session_key
  518. ]);
  519. $data = json_decode($apiResponse->getContents());
  520. if (!property_exists($data, 'success') || !$data->success) {
  521. return redirect()->to(route('log-in-as'))->with('message', $data->message)
  522. ->withInput($request->input());
  523. }
  524. Cookie::queue('sessionKey', $data->data->sessionKey);
  525. return redirect('/mc');
  526. } catch (\Exception $e) {
  527. return redirect()->to(route('log-in-as'))
  528. ->with('message', 'Unable to process your request at the moment. Please try again later.')
  529. ->withInput($request->input());
  530. }
  531. }
  532. public function backToAdminPro(Request $request){
  533. $adminPerformerId = $this->performer->logged_in_as_pro_from_admin_pro_app_session_id;
  534. $adminPerformer = AppSession::where('id', $adminPerformerId)->first();
  535. $url = "/session/pro_log_in_with_session_key/".$adminPerformer->session_key;
  536. $api = new Backend();
  537. try {
  538. $apiResponse = $api->post($url, []);
  539. $data = json_decode($apiResponse->getContents());
  540. if (!property_exists($data, 'success') || !$data->success) {
  541. return redirect()->to(route('logout'));
  542. }
  543. Cookie::queue('sessionKey', $data->data->sessionKey);
  544. return redirect(route('dashboard'));
  545. } catch (\Exception $e) {
  546. return redirect(route('dashboard'));
  547. }
  548. }
  549. }