AdminCuratedRegisterController.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Mail\CuratedRegisterAcceptUser;
  4. use App\Mail\CuratedRegisterRejectUser;
  5. use App\Mail\CuratedRegisterRequestDetailsFromUser;
  6. use App\Models\CuratedRegister;
  7. use App\Models\CuratedRegisterActivity;
  8. use App\Models\CuratedRegisterTemplate;
  9. use App\User;
  10. use Illuminate\Http\Request;
  11. use Illuminate\Support\Facades\Mail;
  12. use Illuminate\Support\Str;
  13. class AdminCuratedRegisterController extends Controller
  14. {
  15. public function __construct()
  16. {
  17. $this->middleware(['auth', 'admin']);
  18. }
  19. public function index(Request $request)
  20. {
  21. $this->validate($request, [
  22. 'filter' => 'sometimes|in:open,all,awaiting,approved,rejected,responses',
  23. 'sort' => 'sometimes|in:asc,desc',
  24. ]);
  25. $filter = $request->input('filter', 'open');
  26. $sort = $request->input('sort', 'asc');
  27. $records = CuratedRegister::when($filter, function ($q, $filter) {
  28. if ($filter === 'open') {
  29. return $q->where('is_rejected', false)
  30. ->where(function ($query) {
  31. return $query->where('user_has_responded', true)->orWhere('is_awaiting_more_info', false);
  32. })
  33. ->whereNotNull('email_verified_at')
  34. ->whereIsClosed(false);
  35. } elseif ($filter === 'all') {
  36. return $q;
  37. } elseif ($filter === 'responses') {
  38. return $q->whereIsClosed(false)
  39. ->whereNotNull('email_verified_at')
  40. ->where('user_has_responded', true)
  41. ->where('is_awaiting_more_info', true);
  42. } elseif ($filter === 'awaiting') {
  43. return $q->whereIsClosed(false)
  44. ->where('is_rejected', false)
  45. ->where('is_approved', false)
  46. ->where('user_has_responded', false)
  47. ->where('is_awaiting_more_info', true);
  48. } elseif ($filter === 'approved') {
  49. return $q->whereIsClosed(true)->whereIsApproved(true);
  50. } elseif ($filter === 'rejected') {
  51. return $q->whereIsClosed(true)->whereIsRejected(true);
  52. }
  53. })
  54. ->when($sort, function ($query, $sort) {
  55. return $query->orderBy('id', $sort);
  56. })
  57. ->paginate(10)
  58. ->withQueryString();
  59. return view('admin.curated-register.index', compact('records', 'filter'));
  60. }
  61. public function show(Request $request, $id)
  62. {
  63. $record = CuratedRegister::findOrFail($id);
  64. return view('admin.curated-register.show', compact('record'));
  65. }
  66. public function apiActivityLog(Request $request, $id)
  67. {
  68. $record = CuratedRegister::findOrFail($id);
  69. $res = collect([
  70. [
  71. 'id' => 1,
  72. 'action' => 'created',
  73. 'title' => 'Onboarding application created',
  74. 'message' => null,
  75. 'link' => null,
  76. 'timestamp' => $record->created_at,
  77. ],
  78. ]);
  79. if ($record->email_verified_at) {
  80. $res->push([
  81. 'id' => 3,
  82. 'action' => 'email_verified_at',
  83. 'title' => 'Applicant successfully verified email address',
  84. 'message' => null,
  85. 'link' => null,
  86. 'timestamp' => $record->email_verified_at,
  87. ]);
  88. }
  89. $activities = CuratedRegisterActivity::whereRegisterId($record->id)->get();
  90. $idx = 4;
  91. $userResponses = collect([]);
  92. foreach ($activities as $activity) {
  93. $idx++;
  94. if ($activity->from_user) {
  95. $userResponses->push($activity);
  96. continue;
  97. }
  98. $res->push([
  99. 'id' => $idx,
  100. 'aid' => $activity->id,
  101. 'action' => $activity->type,
  102. 'title' => $activity->from_admin ? 'Admin requested info' : 'User responded',
  103. 'message' => $activity->message,
  104. 'link' => $activity->adminReviewUrl(),
  105. 'timestamp' => $activity->created_at,
  106. ]);
  107. }
  108. foreach ($userResponses as $ur) {
  109. $res = $res->map(function ($r) use ($ur) {
  110. if (! isset($r['aid'])) {
  111. return $r;
  112. }
  113. if ($ur->reply_to_id === $r['aid']) {
  114. $r['user_response'] = $ur;
  115. return $r;
  116. }
  117. return $r;
  118. });
  119. }
  120. if ($record->is_approved) {
  121. $idx++;
  122. $res->push([
  123. 'id' => $idx,
  124. 'action' => 'approved',
  125. 'title' => 'Application Approved',
  126. 'message' => null,
  127. 'link' => null,
  128. 'timestamp' => $record->action_taken_at,
  129. ]);
  130. } elseif ($record->is_rejected) {
  131. $idx++;
  132. $res->push([
  133. 'id' => $idx,
  134. 'action' => 'rejected',
  135. 'title' => 'Application Rejected',
  136. 'message' => null,
  137. 'link' => null,
  138. 'timestamp' => $record->action_taken_at,
  139. ]);
  140. }
  141. return $res->reverse()->values();
  142. }
  143. public function apiMessagePreviewStore(Request $request, $id)
  144. {
  145. $record = CuratedRegister::findOrFail($id);
  146. return $request->all();
  147. }
  148. public function apiMessageSendStore(Request $request, $id)
  149. {
  150. $this->validate($request, [
  151. 'message' => 'required|string|min:5|max:1000',
  152. ]);
  153. $record = CuratedRegister::findOrFail($id);
  154. abort_if($record->email_verified_at === null, 400, 'Cannot message an unverified email');
  155. $activity = new CuratedRegisterActivity;
  156. $activity->register_id = $record->id;
  157. $activity->admin_id = $request->user()->id;
  158. $activity->secret_code = Str::random(32);
  159. $activity->type = 'request_details';
  160. $activity->from_admin = true;
  161. $activity->message = $request->input('message');
  162. $activity->save();
  163. $record->is_awaiting_more_info = true;
  164. $record->user_has_responded = false;
  165. $record->save();
  166. Mail::to($record->email)->send(new CuratedRegisterRequestDetailsFromUser($record, $activity));
  167. return $request->all();
  168. }
  169. public function previewDetailsMessageShow(Request $request, $id)
  170. {
  171. $record = CuratedRegister::findOrFail($id);
  172. abort_if($record->email_verified_at === null, 400, 'Cannot message an unverified email');
  173. $activity = new CuratedRegisterActivity;
  174. $activity->message = $request->input('message');
  175. return new \App\Mail\CuratedRegisterRequestDetailsFromUser($record, $activity);
  176. }
  177. public function previewMessageShow(Request $request, $id)
  178. {
  179. $record = CuratedRegister::findOrFail($id);
  180. abort_if($record->email_verified_at === null, 400, 'Cannot message an unverified email');
  181. $record->message = $request->input('message');
  182. return new \App\Mail\CuratedRegisterSendMessage($record);
  183. }
  184. public function apiHandleReject(Request $request, $id)
  185. {
  186. $this->validate($request, [
  187. 'action' => 'required|in:reject-email,reject-silent',
  188. ]);
  189. $action = $request->input('action');
  190. $record = CuratedRegister::findOrFail($id);
  191. abort_if($record->email_verified_at === null, 400, 'Cannot reject an unverified email');
  192. $record->is_rejected = true;
  193. $record->is_closed = true;
  194. $record->action_taken_at = now();
  195. $record->save();
  196. if ($action === 'reject-email') {
  197. Mail::to($record->email)->send(new CuratedRegisterRejectUser($record));
  198. }
  199. return [200];
  200. }
  201. public function apiHandleApprove(Request $request, $id)
  202. {
  203. $record = CuratedRegister::findOrFail($id);
  204. abort_if($record->email_verified_at === null, 400, 'Cannot reject an unverified email');
  205. $record->is_approved = true;
  206. $record->is_closed = true;
  207. $record->action_taken_at = now();
  208. $record->save();
  209. $user = User::create([
  210. 'name' => $record->username,
  211. 'username' => $record->username,
  212. 'email' => $record->email,
  213. 'password' => $record->password,
  214. 'app_register_ip' => $record->ip_address,
  215. 'email_verified_at' => now(),
  216. 'register_source' => 'cur_onboarding',
  217. ]);
  218. Mail::to($record->email)->send(new CuratedRegisterAcceptUser($record));
  219. return [200];
  220. }
  221. public function templates(Request $request)
  222. {
  223. $templates = CuratedRegisterTemplate::paginate(10);
  224. return view('admin.curated-register.templates', compact('templates'));
  225. }
  226. public function templateCreate(Request $request)
  227. {
  228. return view('admin.curated-register.template-create');
  229. }
  230. public function templateEdit(Request $request, $id)
  231. {
  232. $template = CuratedRegisterTemplate::findOrFail($id);
  233. return view('admin.curated-register.template-edit', compact('template'));
  234. }
  235. public function templateEditStore(Request $request, $id)
  236. {
  237. $this->validate($request, [
  238. 'name' => 'required|string|max:30',
  239. 'content' => 'required|string|min:5|max:3000',
  240. 'description' => 'nullable|sometimes|string|max:1000',
  241. 'active' => 'sometimes',
  242. ]);
  243. $template = CuratedRegisterTemplate::findOrFail($id);
  244. $template->name = $request->input('name');
  245. $template->content = $request->input('content');
  246. $template->description = $request->input('description');
  247. $template->is_active = $request->boolean('active');
  248. $template->save();
  249. return redirect()->back()->with('status', 'Successfully updated template!');
  250. }
  251. public function templateDelete(Request $request, $id)
  252. {
  253. $template = CuratedRegisterTemplate::findOrFail($id);
  254. $template->delete();
  255. return redirect(route('admin.curated-onboarding.templates'))->with('status', 'Successfully deleted template!');
  256. }
  257. public function templateStore(Request $request)
  258. {
  259. $this->validate($request, [
  260. 'name' => 'required|string|max:30',
  261. 'content' => 'required|string|min:5|max:3000',
  262. 'description' => 'nullable|sometimes|string|max:1000',
  263. 'active' => 'sometimes',
  264. ]);
  265. CuratedRegisterTemplate::create([
  266. 'name' => $request->input('name'),
  267. 'content' => $request->input('content'),
  268. 'description' => $request->input('description'),
  269. 'is_active' => $request->boolean('active'),
  270. ]);
  271. return redirect(route('admin.curated-onboarding.templates'))->with('status', 'Successfully created new template!');
  272. }
  273. public function getActiveTemplates(Request $request)
  274. {
  275. $templates = CuratedRegisterTemplate::whereIsActive(true)
  276. ->orderBy('order')
  277. ->get()
  278. ->map(function ($tmp) {
  279. return [
  280. 'name' => $tmp->name,
  281. 'content' => $tmp->content,
  282. ];
  283. });
  284. return response()->json($templates);
  285. }
  286. }