ModalController.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491
  1. <?php
  2. namespace App\Http\Controllers;
  3. use Illuminate\Http\Request;
  4. use App\Http\Controllers\Controller;
  5. use App\Proposal;
  6. use App\User;
  7. use App\StudentProposal;
  8. use App\Country;
  9. use App\Models\ReferUser;
  10. use App\Models\Admin;
  11. use App\Models\Requirement;
  12. use App\Models\University;
  13. use App\Models\Publication;
  14. use App\Workexperience;
  15. use App\Institution;
  16. use App\Score;
  17. use Hash;
  18. use DB;
  19. use Session;
  20. use Auth;
  21. use Mail;
  22. class ModalController extends Controller{
  23. public function get(Request $req, $name){
  24. $user = Auth::user();
  25. $carbon=new \Carbon\Carbon;
  26. $data=[
  27. 'name'=>$name,
  28. 'carbon'=>$carbon
  29. ];
  30. if($name=="apply_student_proposal"){
  31. $student =Auth::user();
  32. $data['teacher'] = User::find($req->t_id);
  33. $data['student'] = User::find($student->id);
  34. $data['proposal']= Proposal::where('student_id',$user->id)->get();
  35. }elseif($name=="update_student_proposal"){
  36. $data['std_proposal'] =StudentProposal::find($req->id);
  37. $data['teacher'] = User::find($req->teacher_id);
  38. $data['student'] = User::find($req->student_id);
  39. $data['proposal']= Proposal::where('student_id',$req->student_id)->get();
  40. $data['years']=range((int)date('Y'), date('Y')+1);
  41. }elseif($name=="view_apply_proposal"){
  42. $data['std_proposal'] =StudentProposal::find($req->id);
  43. }elseif($name=="view_student_proposal"){
  44. $data['proposal']= Proposal::where(
  45. 'student_id',$user->id
  46. )->where(
  47. 'id',$req->id
  48. )->first();
  49. }elseif($name=="add_destination"){
  50. }elseif($name=="add_wishlist"){
  51. $user =Auth::guard('teacher')->user();
  52. $data['refer'] = new ReferUser;
  53. }elseif($name=="teacher_invited"){
  54. $data['admin'] =Admin::find($req->id);
  55. }elseif($name=="add_doc_required"){
  56. $data['std_proposal']=StudentProposal::find($req->id);
  57. }elseif($name=="edit_doc_required"){
  58. $data['requirements']=Requirement::find($req->id);
  59. }elseif($name=="landing_ragister_form"){
  60. $data['countries'] =Country::where('status',1)->orderBy('name','ASC')->get();
  61. //$data['universities'] =University::orderBy('name','ASC')->get();
  62. }else $name='default';
  63. return view("modal_pages.{$name}", $data);
  64. }
  65. public function post(Request $req, $name){
  66. $user=Auth::user();
  67. $carbon=new \Carbon\Carbon;
  68. if($name=='apply_student_proposal'){
  69. $new_rules=[
  70. 'proposal_id'=>'required',
  71. ];
  72. $validator=\Validator::make($req->all(),$new_rules,[
  73. 'proposal_id.required'=>'No Proposal available.',
  74. 'startdate'=>'required',
  75. 'startmonth'=>'required',
  76. ]);
  77. if($validator->fails()){
  78. $errors=$validator->errors()->all();
  79. return response(['msg'=>$errors[0]], 422);
  80. }
  81. $already_exists = StudentProposal::where('student_id',$req->student_id)->where('proposal_submit_status',1)->exists();
  82. if($already_exists){
  83. return response(['msg'=>'Sorry! You already submitted. You can not submit proposal.'],403);
  84. }
  85. $publication =User::where('id',$req->student_id)->whereNull('is_publication')->exists();
  86. $worK_exp =User::where('id',$req->student_id)->whereNull('is_work_experience')->exists();
  87. $institution =User::where('id',$req->student_id)->whereNull('is_education')->exists();
  88. $score =User::where('id',$req->student_id)->whereNull('is_test_score')->exists();
  89. if($publication || $worK_exp || $institution || $score){
  90. return response(['msg'=>'you didn\'t complete your profile.'],403);
  91. }
  92. $student_proposal =new StudentProposal;
  93. $student_proposal->student_id =$req->student_id;
  94. $student_proposal->teacher_id =$req->teacher_id;
  95. $student_proposal->proposal_id =$req->proposal_id;
  96. $student_proposal->start_year =$req->startdate;
  97. $student_proposal->start_month =$req->startmonth;
  98. $student_proposal->student_apply_ref =studentRefNoGenerate();
  99. $student_proposal->proposal_submit_status = 1;
  100. $student_proposal->submitted_date = now();
  101. $student_proposal->created_by =$req->student_id;
  102. $student_proposal->save();
  103. $student_data =User::find($student_proposal->student_id);
  104. $student_data->freez_profile =1;
  105. $student_data->update();
  106. $teacher =User::find($student_proposal->teacher_id);
  107. if($student_data){
  108. $data['name'] = $student_data->first_name.' '.$student_data->last_name;
  109. $data['teacher'] = $teacher->first_name.' '.$teacher->last_name;
  110. $data['university'] = $teacher->university_name;
  111. $data['submission_date'] = $student_data->created_at;
  112. $data['receive_email']=$student_data->email;
  113. //$data['arn'] = $teacher->ref_no;
  114. $user_mail =$student_data->email;
  115. $from = 'asraful@revinr.com';
  116. Mail::send('email.student_proposal_email',$data, function ($message) use ($user_mail,$from,$student_proposal) {
  117. $message->from($from);
  118. $message->to($user_mail)->subject('Apply Ref:' .$student_proposal->student_apply_ref. '- Proposal has been submitted successfully ');
  119. });
  120. }
  121. $proposal =Proposal::where(
  122. 'student_id',$student_proposal->student_id
  123. )->where(
  124. 'id',$student_proposal->proposal_id
  125. )->first();
  126. if($teacher){
  127. $data['name'] = $teacher->first_name.' '.$teacher->last_name;
  128. $data['std_name'] = $user->first_name.' '.$user->last_name;
  129. $data['proposal_title'] =$proposal->title;
  130. $data['date_time']=$student_proposal->submitted_date;
  131. $data['receive_email']=$teacher->email;
  132. $user_mail =$teacher->email;
  133. $from = 'asraful@revinr.com';
  134. Mail::send('email.teacher_proposal_email',$data, function ($message) use ($user_mail,$from) {
  135. $message->from($from);
  136. $message->to($user_mail)->subject('New Proposal Received - Action Required');
  137. });
  138. }
  139. return response(['msg'=>'Proposal send successfully.']);
  140. }elseif($name=="update_student_proposal"){
  141. $new_rules=[
  142. 'proposal_id'=>'required',
  143. ];
  144. $validator=\Validator::make($req->all(),$new_rules,[
  145. 'proposal_id.required'=>'No Proposal available.',
  146. 'startdate'=>'required',
  147. 'startmonth'=>'required',
  148. ]);
  149. if($validator->fails()){
  150. $errors=$validator->errors()->all();
  151. return response(['msg'=>$errors[0]], 422);
  152. }
  153. $already_exists = StudentProposal::where('student_id',$req->student_id)->where('proposal_submit_status',1)->exists();
  154. if($already_exists){
  155. return response(['msg'=>'Sorry! You already submitted. You can not submit proposal.'],403);
  156. }
  157. $publication =User::where('id',$req->student_id)->whereNull('is_publication')->exists();
  158. $worK_exp =User::where('id',$req->student_id)->whereNull('is_work_experience')->exists();
  159. $institution =User::where('id',$req->student_id)->whereNull('is_education')->exists();
  160. $score =User::where('id',$req->student_id)->whereNull('is_test_score')->exists();
  161. if($publication || $worK_exp || $institution || $score){
  162. return response(['msg'=>'you didn\'t complete your profile.'],403);
  163. }
  164. $student_proposal =StudentProposal::find($req->id);
  165. $student_proposal->proposal_id =$req->proposal_id;
  166. $student_proposal->start_year =$req->startdate;
  167. $student_proposal->start_month =$req->startmonth;
  168. $student_proposal->student_apply_ref =studentRefNoGenerate();
  169. $student_proposal->proposal_submit_status = 1;
  170. $student_proposal->submitted_date = now();
  171. $student_proposal->created_by =$req->student_id;
  172. $student_proposal->update();
  173. $student_data =User::find($student_proposal->student_id);
  174. $student_data->freez_profile =1;
  175. $student_data->update();
  176. $teacher =User::find($student_proposal->teacher_id);
  177. if($student_data){
  178. $data['name'] = $student_data->first_name.' '.$student_data->last_name;
  179. $data['teacher'] = $teacher->first_name.' '.$teacher->last_name;
  180. $data['university'] = $teacher->university_name;
  181. $data['submission_date'] = $student_data->created_at;
  182. $data['receive_email']=$student_data->email;
  183. //$data['arn'] = $proposal_user->ref_no;
  184. $user_mail =$student_data->email;
  185. $from = 'asraful@revinr.com';
  186. Mail::send('email.student_proposal_email',$data, function ($message) use ($user_mail,$from,$student_proposal) {
  187. $message->from($from);
  188. $message->to($user_mail)->subject('Apply Ref:' .$student_proposal->student_apply_ref. '- Proposal has been submitted successfully ');
  189. });
  190. }
  191. $proposal =Proposal::where(
  192. 'student_id',$student_proposal->student_id
  193. )->where(
  194. 'id',$student_proposal->proposal_id
  195. )->first();
  196. if($teacher){
  197. $data['name'] = $teacher->first_name.' '.$teacher->last_name;
  198. $data['std_name'] = $student_data->first_name.' '.$student_data->last_name;
  199. $data['proposal_title'] =$proposal->title;
  200. $data['date_time']=$student_proposal->submitted_date;
  201. $data['receive_email']=$teacher->email;
  202. $user_mail =$teacher->email;
  203. $from = 'asraful@revinr.com';
  204. Mail::send('email.teacher_proposal_email',$data, function ($message) use ($user_mail,$from) {
  205. $message->from($from);
  206. $message->to($user_mail)->subject('New Proposal Received - Action Required');
  207. });
  208. }
  209. return response(['msg'=>'Successfully updated.']);
  210. }elseif($name=="add_wishlist"){
  211. $user =Auth::guard('teacher')->user();
  212. $validator=\Validator::make($req->all(), [
  213. 'name'=>'required',
  214. 'email'=>'required|email|max:255'
  215. ]);
  216. if($validator->fails()){
  217. $errors=$validator->errors()->all();
  218. return response(['msg'=>$errors[0]], 422);
  219. }
  220. // $already_exists =User::where('email',$req->email)->exists();
  221. // if($already_exists){
  222. // return response(['msg'=>'Sorry! this email is already exists!.'],403);
  223. // }
  224. $user_check_data =User::where('email',$req->email)->where('user_type',1)->doesntExist();
  225. if($user_check_data){
  226. $user_data =new User;
  227. $user_data->first_name =$req->name;
  228. $user_data->email =$req->email;
  229. $user_data->user_type =1;
  230. $user_data->status =0;
  231. $user_data->register_type =4; // 1=invitation ; 2= landing/wishlish; 3 =q_form ; 4=student-wishlist
  232. $user_data->invitation_date =now();
  233. $user_data->wishlist_teacher_id =$user->id;
  234. $user_data->save();
  235. }
  236. $refer =new ReferUser;
  237. $refer->name =$req->name;
  238. $refer->email =$req->email;
  239. $refer->refer_by =$user->id;
  240. $refer->teacher_id =$user->id;
  241. $refer->save();
  242. $user_notify =User::where('email',$req->email)->where('user_type',1)->first();
  243. if($refer->save()){
  244. $data['name'] = $refer->name;
  245. $data['teacher_id'] = $refer->teacher_id;
  246. $data['student_id'] = $user_notify->id;
  247. $data['std_email'] = $refer->email;
  248. $data['teacher'] = $user->first_name.' '.$user->last_name;
  249. $data['designation'] = $user->designation;
  250. $data['department'] = $user->others_department;
  251. $data['university'] = $user->university_name;
  252. $data['receive_email']=$refer->email;
  253. $user_mail = $refer->email;
  254. $from = 'asraful@revinr.com';
  255. Mail::send('email.wishlist_email',$data, function ($message) use ($user_mail,$from) {
  256. $message->from($from);
  257. $message->to($user_mail)->subject('Research Admission Platform Sign-Up');
  258. });
  259. }
  260. return response(
  261. ['msg'=>'Refer saved successfully.']
  262. );
  263. }elseif($name=="teacher_invited"){
  264. $admin =Admin::find($req->id);
  265. $validator=\Validator::make($req->all(), [
  266. 'name'=>'required',
  267. 'email'=>'required|email|max:255'
  268. ]);
  269. if($validator->fails()){
  270. $errors=$validator->errors()->all();
  271. return response(['msg'=>$errors[0]], 422);
  272. }
  273. $user_check_data =User::where('email',$req->email)->where('user_type',2)->doesntExist();
  274. if($user_check_data){
  275. // return response(['msg'=>'Sorry! this email is already exists!.'],403);
  276. $user_data =new User;
  277. $user_data->first_name =$req->name;
  278. $user_data->email =$req->email;
  279. $user_data->admin_invite_id =$admin->id;
  280. $user_data->user_type =2;
  281. $user_data->register_type =1; // 1=invitation ; 2=wishlist/landing
  282. $user_data->invitation_date =now();
  283. $user_data->save();
  284. }
  285. $teacher_user =User::where('email',$req->email)->where('user_type',2)->first();
  286. $refer =new ReferUser;
  287. $refer->name =$req->name;
  288. $refer->email =$req->email;
  289. $refer->refer_by =$admin->id;
  290. $refer->teacher_id =$teacher_user->id;
  291. $refer->save();
  292. if($refer->save()){
  293. $data['name'] = $refer->name;
  294. $data['teacher_id'] = $teacher_user->id;
  295. $data['applicant_name'] = $admin->first_name.' '.$admin->last_name;
  296. $data['email']=$refer->email;
  297. $data['receive_email']=$refer->email;
  298. $user_mail = $refer->email;
  299. $from = 'asraful@revinr.com';
  300. if($req->is_currently_open==1){
  301. Mail::send('email.invitation_to_supervisor_email_with_checked',$data, function ($message) use ($user_mail,$from) {
  302. $message->from($from);
  303. $message->to($user_mail)->subject('Accepting Doctoral Applications? We Have a Tool to Simplify the Process!');
  304. });
  305. }else{
  306. Mail::send('email.invitation_to_supervisor_email',$data, function ($message) use ($user_mail,$from) {
  307. $message->from($from);
  308. $message->to($user_mail)->subject('Manage Doctoral Applicants with Ease - You’re invited!');
  309. });
  310. }
  311. }
  312. $already_invited =ReferUser::where('email',$refer->email)->count();
  313. if($already_invited > 1) {
  314. return response(
  315. ['msg'=>"Successfully saved. Already invitation send {$already_invited} times."]
  316. );
  317. }else{
  318. return response(
  319. ['msg'=>'Invitation saved successfully.']
  320. );
  321. }
  322. }elseif($name=="add_doc_required"){
  323. $user=auth_user();
  324. $new_rules=[
  325. 'others'=>'required|array',
  326. 'others.*.requirement_title'=>'required',
  327. ];
  328. $validator=\Validator::make($req->all(),$new_rules,[
  329. 'others.*.requirement_title.required'=>'Please!, fill-up all requirement field.'
  330. ]);
  331. if($validator->fails()){
  332. $errors=$validator->errors()->all();
  333. return response(['msg'=>$errors[0]], 422);
  334. }
  335. $std_proposal=StudentProposal::find($req->id);
  336. foreach($req->others as $row){
  337. Requirement::create([
  338. 'std_proposal_id'=>$std_proposal->id,
  339. 'requirement_title'=>$row['requirement_title'],
  340. 'need_upload'=>$row['need_upload'],
  341. 'created_by'=>$user->id
  342. ]);
  343. }
  344. return response([
  345. 'msg'=>'Successfully Saved.'
  346. ]);
  347. }elseif($name=="edit_doc_required"){
  348. $requirements=Requirement::find($req->id);
  349. $requirements->requirement_title =$req->requirement_title;
  350. $requirements->need_upload =$req->need_upload;
  351. $requirements->update();
  352. return response([
  353. 'msg'=>'Successfully updated.'
  354. ]);
  355. }elseif($name=="landing_ragister_form"){
  356. $validator=\Validator::make($req->all(), [
  357. 'name'=>'required',
  358. 'email'=>'required|email|max:255'
  359. ]);
  360. if($validator->fails()){
  361. $errors=$validator->errors()->all();
  362. return response(['msg'=>$errors[0]], 422);
  363. }
  364. // $already_exists =User::where('email',$req->email)->exists();
  365. // if($already_exists){
  366. // return response(['msg'=>'Sorry! this email is already exists!.'],403);
  367. // }
  368. $user_check_data =User::where('email',$req->email)->where('user_type',2)->doesntExist();
  369. if($user_check_data){
  370. $user_data =new User;
  371. $user_data->first_name =$req->name;
  372. $user_data->email =$req->email;
  373. $user_data->nationality =$req->country_id;
  374. $user_data->university_name =$req->university;
  375. $user_data->uni_website =$req->uni_website;
  376. $user_data->user_type =2;
  377. $user_data->register_type =2; // 1=invitation ; 2= landing/wishlish
  378. // $user_data->invitation_date =now();
  379. $user_data->save();
  380. }
  381. $user =User::where('email',$req->email)->where('user_type',2)->first();
  382. $refer =new ReferUser;
  383. $refer->name =$req->name;
  384. $refer->email =$req->email;
  385. $refer->teacher_id =$user->id;
  386. $refer->save();
  387. return response(
  388. ['msg'=>'Successfully saved.']
  389. );
  390. }
  391. return response(['msg'=>'No name argument found.'], 403);
  392. }
  393. }