all(), [
'name' => 'required|max:100',
'phone' => [
'required',
Rule::when(!empty($request->phone), Rule::unique('users', 'phone')->where(function ($query) {
return $query->whereNull('deleted_at');
})->ignore($request->user_id)),
Rule::when(empty(@$request->email), ['numeric', Rule::unique('users', 'phone')->where(function ($query) {
return $query->whereNull('deleted_at');
})->ignore($request->user_id)])
],
'email' => [
'nullable',
'email',
Rule::unique('users', 'email')->where(function ($query) use ($request) {
return $query->whereNull('deleted_at');
})->ignore($request->user_id),
],
'country' => 'required',
]);
$validator->errors = $validator->errors();
if ($validator->fails()) {
$errors = $validator->errors;
return response()->json([
'error' => $errors,
'status' => 3
]);
}
$data['country'] = null;
$data['country_code'] = null;
if (!empty($request->country)) {
$countryData = explode('@#$?', $request->country);
$country = $countryData[0];
$data['country'] = $country;
if (!empty($country)) $data['country'] = $country;
$code = $countryData[1];
if (!empty($code)) $data['country_code'] = $code;
}
// $user_save_data = [
// 'name' => $request->name,
// 'phone' => $request->phone,
// 'email' => $request->email,
// 'country' => $data['country'],
// 'country_code' => $data['country_code'],
// 'source' => $request->source,
// 'created_at' => Carbon::now()->tz(env('APP_TIMEZONE', 'UTC'))->format('Y-m-d H:i:s'),
// 'updated_at' => Carbon::now()->tz(env('APP_TIMEZONE', 'UTC'))->format('Y-m-d H:i:s'),
// ];
// dd(Carbon::now()->tz(env('APP_TIMEZONE', 'UTC'))->format('Y-m-d H:i:s'));
$new_data = User::create([
'role' => 'candidate',
'name' => $request->name,
'phone' => $request->phone,
'email' => $request->email,
'country' => $data['country'],
'country_code' => $data['country_code'],
'source' => $request->source,
]);
$candidate = Candidate::where('user_id', $new_data->id)->first();
// $candidate = Candidate::create([
// 'created_at' => "2024-01-08 15:18:14",
// 'user_id' => $data->id,
// ]);
if($new_data){
return response()->json(['status'=>1,'message' => "Lead Created Successfully","candidate_id" =>$candidate]);
}else{
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong Detail Not Save"]);
}
}
public function candidateEdit(Request $request, $id)
{
$candidate = Candidate::where('id',$id)->first();
$formattedTime = Carbon::now()->format('Y-m-d H:i:s');
$candidateDisplay = 0;
$roleNames = Auth()->user()->getRoleNames()->toArray();
if (Auth::check()) {
if ($candidate) {
$formattedTime = Carbon::now();
if ($candidate->open_auth_id && $formattedTime <= $candidate->open_date_time && $candidate->open_auth_id != Auth::user()->id) {
$candidateDisplay = 1;
}
if (!$candidate->open_auth_id || $formattedTime > $candidate->open_date_time) {
if(!in_array('superadmin', $roleNames)){
$candidate->update([
'open_auth_id' => Auth::user()->id,
'open_date_time' => $formattedTime->addMinutes(30),
]);
}
}
} else {
flashError("Candidate not found.");
return back();
}
}
$roleEnvNames = explode(',', env('AVAILABLE_LEAD_ROLES', 'Lead Manager,Operation Manager'));
$admin_list = Admin::where('id', '!=', 1)
->whereHas('roles', function ($query) use ($roleEnvNames) {
$query->whereIn('name', $roleEnvNames);
})
->get()
->toArray();
$user = User::findOrFail($candidate->user_id);
$countries = Countries::all('id', 'name','sortname');
$preferred_countries = [];
$other_countries = [];
$jsonString = str_replace(['"', '[', ']'], '', @$candidate->destination[0]->preferred_country);
$preferred_country_ids = explode(",", $jsonString);
foreach ($preferred_country_ids as $preferred_country_id) {
$country = $countries->firstWhere('id', $preferred_country_id);
if ($country) {
$preferred_countries[] = [
'id' => $country->id,
'name' => $country->name,
'sortname' => $country->sortname,
];
}
}
$other_countries = $countries->reject(function ($country) use ($preferred_country_ids) {
return in_array($country->id, $preferred_country_ids);
})->toArray(); // Convert the collection to an array
$countries = array_merge($preferred_countries, $other_countries);
$jsonString = str_replace(['"', '[', ']'], '', @$candidate->destination[0]->preferred_country);
$preferred_country_ids = explode(",", $jsonString);
$preferred_countries = [];
$other_countries = [];
foreach ($countries as $country) {
if (in_array($country['id'], $preferred_country_ids)) {
$preferred_countries[] = [
'id' => $country['id'],
'name' => $country['name'],
'sortname' => $country['sortname'],
];
}
}
$sourcesData = Source::distinct('name')->with("source")->where("parent_id",null)->get();
$ind_universities = IndianUniversity::all(['id', 'name']);
$partners = Partner::select('id', 'name')->get()->toArray();
$exam_list = Exam::get()->toArray();
$profile_progress = $this->profile_complete($candidate->id);
$services = Service::select('id', 'name')->get()->toArray();
$streams = StudyArea::get()->toArray();
return view('admin.lead-management.customer-detail', compact(
'countries',
'candidate',
'user',
'preferred_country_ids',
'preferred_countries',
'admin_list',
'ind_universities',
'services',
'partners',
'exam_list',
'profile_progress',
'sourcesData',
'streams',
));
}
public function candidate_application(Request $request)
{
abort_if(!userCan('candidateApplication.update'), 403);
// dd($request->candidate_id);
$candidate_id = $request->candidate_id;
// dd( $candidate_id->candidate_id);
// $partner_find = Partner::select('id', 'name')->get()->toArray();
$data['candidateApplications'] = [];
$data['candidates'] = [];
$data['universities'] = [];
$data['partner_find'] = [];
if(!empty(@$candidate_id)){
$data['candidateApplications'] = CandidateApplication::with('partners','timeLine')->where('candidate_id', $candidate_id)->get();
// $data['universities'] = Universities::where('status', 1)->get(['id', 'name']);
// $data['candidates'] = Candidate::where('id', $candidate_id)->with('user')->first();
// $data['partner_find'] = Partner::select('id', 'name')->get()->toArray();
}else{
flashError("Candidate not found.");
return redirect()->route('candidateApplication.index');
}
// dd(Auth::user()->image_url);
// dd($data['candidateApplications']);
$data['candidateApplicationsID'] = $request->id;
if(count($data['candidateApplications']) <= 0){
$code = '';
$code .= '';
}
$data['code'] = $code;
return $data;
}
public function followup(Request $request){
$candidate = Candidate::where('user_id', $request->user_id)->first();
$followups = Followup::latest()->where('user_id', $candidate->user_id)->get();
$followupList = [];
$count = count($followups);
foreach ($followups as $followup){
if (empty($followup->datetime)) {
$date_time = "";
} else {
$date_time = date('d-m-Y H:i:s', strtotime($followup->datetime));
}
if (empty($followup->created_at)) {
$created_at = "";
} else {
$created_at = date('d-m-Y H:i:s', strtotime($followup->created_at));
}
$followupItem = '
Followup Date:' . @$date_time . '
Type:' . @$followup->type . '
Priority:' . @$followup->priority . '
Status:';
$followupItem .= (@$followup->follow_up_status == 'Not Connected') ? 'Not Connected ' : 'Connected ';
$followupItem .= '
Assign To:' . ucwords(adminIdToNameGet(@$followup->assign_to)) . '
Followup:' . @$followup->followup_up . '
Comment:' . @$followup->comment . '
Created By:' . @$followup->admin->name . '
Created Date:' . @$created_at . '
';
array_push($followupList, $followupItem);
}
if($followupList == null){
$followupItem = '
No Data Avaialable
" . $webinar_history_use->webinar_name . "
" . date('d-m-Y H:i:s', strtotime($webinar_history_use->dateTime)) . "
";
if (!empty($webinar_history_use->webinar_link)) {
$code .= "Join Link ";
} else {
$code .= "--";
}
$code .= "
" . ($webinar_history_use->attended == 1 ? 'Yes' : 'No') . "
";
}
return response()->json(['status'=>1,'message' => "Webinar Successfully Added",'code' => $code]);
}else{
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong Detail Not Save"]);
}
}
}
elseif($request->type == "add_tests"){
$user_id = $request->user_id;
$test_id = $request->test_id;
$userMockTestData = UsersMockTest::where('user_id', $user_id)->first();
$mockTestResults = MockTestResult::where('user_id', $user_id)->get()->toArray();
$tests = IeltsMockTest::select('id')->get()->toArray();
if ($test_id == null) {
return response()->json(['status' => 2, 'message' => "Test Is null. Please Select Valid Test"]);
}
if ($userMockTestData == null) {
$words = explode(',', $test_id);
if (isset($words[0]) && is_numeric($words[0])) {
array_shift($words);
}
$test_id = implode(',', $words);
UsersMockTest::create([
'user_id' => $user_id,
'ielts_test_ids' => $test_id,
]);
return response()->json(['status' => 1, 'message' => "Test Successfully Added"]);
} else {
$oldTests = explode(",", $userMockTestData->ielts_test_ids);
$newTests = explode(",", $test_id);
$missingTests = array_diff($newTests, $oldTests);
if ($missingTests == []) {
return response()->json(['status' => 1, 'message' => "You Are Already Joined This Test"]);
} else {
$testIdsToAdd = implode(',', $missingTests);
$test_data = $userMockTestData->ielts_test_ids . ',' . $testIdsToAdd;
$words = explode(',', $test_data);
if (isset($words[0]) && is_numeric($words[0])) {
array_shift($words);
}
$test_data = implode(',', $words);
$userMockTestData->update(['ielts_test_ids' => $test_data]);
return response()->json(['status' => 1, 'message' => "Test Successfully Added"]);
$response = ['status' => 1, 'message' => "Test Successfully Added"];
}
}
}
elseif($request->type == "lead_type"){
$data = [
'lead_type' => $request->lead_type,
];
$stage_data = User::where('id',$request->user_id)->update($data);
if( $stage_data > 0){
return response()->json(['status'=>1,'message' => "Lead Changed Successfully","stage" => $request->stage]);
}else{
$stage_data = User::where('id',$request->user_id)->first();
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong Detail Not Save","stage" => $stage_data->stages]);
}
}
elseif($request->type == "stage_change"){
$candidate = Candidate::where('user_id',$request->user_id)->first();
$user = User::findOrFail($candidate->user_id);
if (!empty($request->stage) && $request->stage !== $user->stages) {
UserTimeline::create([
'user_id' => $user->id,
'stages' => $request->stage,
'event' => 0,
'comment' => "Stage Changed from " . (@$user->stages ? @$user->stages : "-NA-") . " to " . (@$request->stage ? @$request->stage : "-NA-") . ".",
'auth_id' => Auth::user()->id
]);
}
$data = [
'stages' => $request->stage,
];
$stage_data = User::where('id',$request->user_id)->update($data);
$user = User::findOrFail($candidate->user_id);
// Generate HTML for user timeline
$userTimelineHtml = '';
foreach ($user->timeLine as $timeLine) {
$userTimelineHtml .= '';
if (!empty($timeLine->event)) {
$userTimelineHtml .= '
';
} else {
$userTimelineHtml .= '
';
}
if ($timeLine->stages == 'Assign To') {
$userTimelineHtml .= '-- ' . $timeLine->stages . ' ' . $timeLine->comment . ' ' . ucwords(adminIdToNameGet($timeLine->auth_id)) . ' -- ' . dateMonthTimeFormat($timeLine->created_at) . ' -- ';
}
// Now you can use $userTimelineHtml and $webinarHistoryHtml in your response
if( $stage_data > 0){
$stage_name = getStageGroup($request->stage);
return response()->json(['status'=>1,'message' => "Stage Changed Successfully","stage" => $request->stage, "stage_name" => $stage_name,"code"=> $userTimelineHtml]);
}else{
$stage_data = User::where('id',$request->user_id)->first();
$stage_name = getStageGroup($stage_data->stages);
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong Detail Not Save","stage" => $stage_data->stages ,"stage_name" => $stage_name, "code"=> $userTimelineHtml]);
}
}
elseif($request->type == "stage_save"){
$candidate = Candidate::where('user_id',$request->user_id)->first();
$user = User::findOrFail($candidate->user_id);
if (!empty($request->stage) && $request->stage !== $user->stages) {
UserTimeline::create([
'user_id' => $user->id,
'stages' => $request->stage,
'event' => 0,
'comment' => "Stage Changed from " . (@$user->stages ? @$user->stages : "-NA-") . " to " . (@$request->stage ? @$request->stage : "-NA-") . ".",
'auth_id' => Auth::user()->id
]);
}
if($request->dropped_reason == "other"){
$request->dropped_reason = $request->dropped_reason1;
}
$data = [
'stages' => $request->stage,
'dropped_reason' => $request->dropped_reason,
'stage_expiry_date' => $request->expire_date,
];
$stage_data = User::where('id',$request->user_id)->update($data);
$user = User::findOrFail($candidate->user_id);
// Generate HTML for user timeline
$userTimelineHtml = '';
foreach ($user->timeLine as $timeLine) {
$userTimelineHtml .= '';
if (!empty($timeLine->event)) {
$userTimelineHtml .= '
';
} else {
$userTimelineHtml .= '
';
}
if ($timeLine->stages == 'Assign To') {
$userTimelineHtml .= '-- ' . $timeLine->stages . ' ' . $timeLine->comment . ' ' . ucwords(adminIdToNameGet($timeLine->auth_id)) . ' -- ' . dateMonthTimeFormat($timeLine->created_at) . ' -- ';
}
// Now you can use $userTimelineHtml and $webinarHistoryHtml in your response
if( $stage_data > 0){
$stage_name = getStageGroup($request->stage);
return response()->json(['status'=>1,'message' => "Stage Changed Successfully","stage" => $request->stage, "stage_name" => $stage_name,"code"=> $userTimelineHtml]);
}else{
$stage_data = User::where('id',$request->user_id)->first();
$stage_name = getStageGroup($stage_data->stages);
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong Detail Not Save","stage" => $stage_data->stages ,"stage_name" => $stage_name, "code"=> $userTimelineHtml]);
}
}
elseif($request->type == "highest_education_change"){
$candidate = Candidate::where('user_id',$request->user_id)->first();
$user = User::findOrFail($candidate->user_id);
$data = [
'highest_education' => $request->highest_education,
];
$candidate = Candidate::where('user_id',$request->user_id)->update($data);
if( $candidate > 0){
$highest_education = Candidate::where('user_id',$request->user_id)->first()->highest_education;
return response()->json(['status'=>1,'message' => "Highest Education Changed Successfully", "highest_education" => $highest_education]);
}else{
$candidate = User::where('id',$request->user_id)->first();
$highest_education = Candidate::where('user_id',$request->user_id)->first()->highest_education;
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong Detail Not Save", "highest_education" => $highest_education]);
}
}
elseif($request->type == "work_experience"){
// $validator = Validator::make($request->all(), [
// 'organization_name' => 'required| max: 250',
// 'organization_type' => 'required| max: 250',
// 'organization_address' => 'required| max: 250',
// 'position' => 'required| max: 250',
// 'start_date' => 'required| max: 250',
// 'end_date' => 'required| max: 250',
// 'experience_letter' => 'required| max: 250',
// 'mode_of_salery' => 'required| max: 250',
// ]);
// if ($validator->fails()) {
// $errors = $validator->errors();
// return response()->json([
// 'error' => $errors,
// 'status' => 3
// ]);
// }
if($request->id != null){
$workExperience = WorkExperience::find($request->id);
if ($workExperience) {
$workExperience->organization_name = $request->organization_name;
$workExperience->organization_type = $request->organization_type;
$workExperience->organization_address = $request->organization_address;
$workExperience->position = $request->position;
$workExperience->start_date = $request->start_date;
$workExperience->end_date = $request->end_date;
$workExperience->name = $request->name;
$workExperience->department_name = $request->department_name;
$workExperience->mobile_number = $request->mobile_number;
$workExperience->experience_letter = $request->experience_letter;
$workExperience->mode_of_salery = $request->mode_of_salery;
$workExperience->Justification = $request->Justification;
$workExperience->Justification_valid = $request->Justification_valid;
$workExperience->Justification_reason = $request->Justification_reason;
$workExperience->save();
return response()->json(['status' => 1, 'message' => "Data Successfully Updated"]);
} else {
return response()->json(['status' => 2, 'message' => "Record not found for the given ID"]);
}
}else{
$candidate = Candidate::where('user_id',$request->user_id)->first();
$workExperience = new WorkExperience;
$workExperience->candidate_id = $candidate->id;
$workExperience->organization_name = $request->organization_name;
$workExperience->organization_type = $request->organization_type;
$workExperience->organization_address = $request->organization_address;
$workExperience->position = $request->position;
$workExperience->start_date = $request->start_date;
$workExperience->end_date = $request->end_date;
$workExperience->name = $request->name;
$workExperience->department_name = $request->department_name;
$workExperience->mobile_number = $request->mobile_number;
$workExperience->experience_letter = $request->experience_letter;
$workExperience->mode_of_salery = $request->mode_of_salery;
$workExperience->Justification = $request->Justification;
$workExperience->Justification_valid = $request->Justification_valid;
$workExperience->Justification_reason = $request->Justification_reason;
$workExperience->save();
if ($workExperience->id) {
return response()->json(['status' => 1, 'message' => "Data Successfully Saved"]);
} else {
return response()->json(['status' => 2, 'message' => "Please Try Again Something Went Wrong, Data Not Saved"]);
}
}
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong Detail Not Save"]);
}
elseif($request->type == "save_suggested_course"){
if(userCan('candidateApplication.create')){
$validator = Validator::make($request->all(), [
'partner_application_id' => 'required',
// 'candidate_id' => 'required',
// 'university_id' => 'required',
// 'course' => 'required',
// 'intake' => 'required',
'partner' => 'required',
// 'status' => 'required',
// 'next_step' => 'required',
]);
if ($validator->fails()) {
$errors = $validator->errors();
return response()->json([
'error' => $errors,
'status' => 3
]);
}
$candidate = Candidate::where('user_id',$request->id)->first();
$datetime = NUll;
if (!empty($request->datetime)) {
$datetime = Carbon::parse($request->datetime);
}
$data = CandidateApplication::create([
'partner_application_id' => $request->partner_application_id,
'candidate_id' => $candidate->id,
'university_id' => $request->university_id,
'course' => $request->course,
// 'intake' => $request->intake,
'partner' => $request->partner,
'status' => $request->status,
'next_step' => $request->next_step,
'intake_months' => $request->intake_months[0],
'intake_years' => $request->intake_years[0],
'university_name' => $request->university_id ,
'course_name' => $request->course,
// 'university_name' => $request->university_id == 0 ? $request->university_name :null,
// 'course_name' =>$request->course == 0 ? $request->course_name :null,
'created_by' => Auth()->user()->id,
'datetime' => $datetime,
// 'created_by_name' => $request->created_by_name,
'stage_reason' => $request->stage_reason,
]);
if(!empty($request->status)){
$new_data = CandidateApplicationTimeline::create([
'application_id' => $data->id,
'candidate_id' => $data->candidate_id,
'status' => $request->status,
'comment' => "Status Changed from " . "-NA-" . " to " . (@$request->status ? @$request->status : "-NA-") . ".",
'auth_id' => Auth::user()->id,
'auth_type' => "admin",
]);
if($new_data){
return response()->json(['status'=>1,'message' => "Application Create Successfully With Time line",'data' => $data->id]);
}else{
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong Detail Not Save"]);
}
}else{
if( $data){
return response()->json(['status'=>1,'message' => "Application Create Successfully",'data' => $data->id]);
}else{
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong Detail Not Save"]);
}
}
}
else{
return response()->json(['status'=>2,'message' => "You Are Not Allow to Create application contact to admin"]);
}
}
}
public function education_detail_delete(Request $request){
abort_if(!userCan('candidate.update'), 403);
if($request->doc_type == "education"){
$data = CandidateEducation::where('id', $request->doc_delete_id)->delete();
if($data == 1){
return response()->json(['status'=>1,'message' => "Education Detail Successfully Deleted","type" =>$request->doc_type]);
}else{
return response()->json(['status'=>0,'message' => "Please Try Again Something Wrong Detail Not Delete","type" =>$request->doc_type]);
}
}else if($request->doc_type == "document"){
$data = Documents::where('id', $request->doc_delete_id)->delete();
if($data == 1){
return response()->json(['status'=>1,'message' => "Document Successfully Deleted","type" =>$request->doc_type]);
}else{
return response()->json(['status'=>0,'message' => "Please Try Again Something Wrong Document Not Delete","type" =>$request->doc_type]);
}
}else if($request->doc_type == "work_experience"){
$data = WorkExperience::where('id', $request->doc_delete_id)->delete();
if($data == 1){
return response()->json(['status'=>1,'message' => "Work Experience Detail Successfully Deleted","type" =>$request->doc_type]);
}else{
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong Work Experience Detail Not Delete","type" =>$request->doc_type]);
}
}
else if($request->doc_type == "webinar_delete"){
if($request->doc_delete_id == null){
return response()->json(['status'=>2,'message' => "Webinar Is Not Valid"]);
}
$data = InterestedCandidatesWebinar::where('id',$request->doc_delete_id)->delete();
$candidate = Candidate::where('user_id',$request->user_id)->first();
if($data){
$webinar_history = InterestedCandidatesWebinar::where('candidate_id', $candidate->id)->get();
foreach($webinar_history as $webinar_history_use){
$webinar = Webinars::where('id', $webinar_history_use->webinar_id)->first();
if($webinar != null){
$webinar_history_use->webinar_name = $webinar->webinar_name;
$webinar_history_use->webinar_link = $webinar->webinar_link;
$webinar_history_use->dateTime = $webinar->dateTime;
}
}
$code = "";
foreach ($webinar_history as $webinar_history_use) {
$code .= "
" . $webinar_history_use->webinar_name . "
" . date('d-m-Y H:i:s', strtotime($webinar_history_use->dateTime)) . "
";
if (!empty($webinar_history_use->webinar_link)) {
$code .= "Join Link ";
} else {
$code .= "--";
}
$code .= "
" . ($webinar_history_use->attended == 1 ? 'Yes' : 'No') . "
";
if (userCan('candidate.create')) {
$code .= "
";
}
$code .= "
";
}
return response()->json(['status'=>1,'message' => "Webinar Successfully Deleted",'code' => $code,"type" =>$request->doc_type]);
}
else{
$webinar_history = InterestedCandidatesWebinar::where('candidate_id', $candidate->id)->get();
foreach($webinar_history as $webinar_history_use){
$webinar = Webinars::where('id', $webinar_history_use->webinar_id)->first();
if($webinar != null){
$webinar_history_use->webinar_name = $webinar->webinar_name;
$webinar_history_use->webinar_link = $webinar->webinar_link;
$webinar_history_use->dateTime = $webinar->dateTime;
}
}
$code = "";
foreach ($webinar_history as $webinar_history_use){
$code .= "
" . $webinar_history_use->webinar_name . "
" . date('d-m-Y H:i:s', strtotime($webinar_history_use->dateTime)) . "
Join Link
";
if ($webinar_history_use->attended == 1) {
$code .= "Yes";
} else {
$code .= "No";
}
$code .= "
";
}
return response()->json(['status'=>1,'message' => "Something Else Try Again",'code' => $code,"type" =>$request->doc_type]);
}
// $data = WorkExperience::where('id', $request->doc_delete_id)->delete();
// if($data == 1){
// return response()->json(['status'=>1,'message' => "Work Experience Detail Successfully Deleted","type" =>$request->doc_type]);
// }else{
// return response()->json(['status'=>0,'message' => "Please Try Again Something Wrong Work Experience Detail Not Delete","type" =>$request->doc_type]);
// }
}
else if($request->doc_type == "test_delete"){
if($request->doc_delete_id == null){
return response()->json(['status'=>2,'message' => "Test Is Not Valid"]);
}else{
$UsersMockTest_data = UsersMockTest::where('user_id',$request->user_id)->first();
if($UsersMockTest_data != null){
$new_test = explode(",",$UsersMockTest_data->ielts_test_ids);
$key = array_search($request->doc_delete_id, $new_test);
if($key !== false){
unset($new_test[$key]);
}
$new_test_data = implode(',', $new_test);
$words = explode(',', $new_test_data);
if (isset($words[0]) && is_numeric($words[0])) {
array_shift($words);
}
$new_test_data = implode(',', $words);
$test = [
'user_id' => $request->user_id,
'ielts_test_ids' => $new_test_data,
];
$data = UsersMockTest::where('user_id',$request->user_id)->update($test);
if($data){
return response()->json(['status'=>1,'message' => "Successfully Delete Test","type" =>$request->doc_type]);
}
return response()->json(['status'=>2,'message' => "Something Else Try Again","type" =>$request->doc_type]);
}else{
return response()->json(['status'=>2,'message' => "Something Else Try Again","type" =>$request->doc_type]);
}
}
}
else{
}
}
public function check_qualification_year(Request $request){
$down_to_up = ['10th','12th','Diploma','Bachelors','Masters','
PhD'];
$up_to_down = ['PhD','Masters','Bachelors','Diploma','12th','10th'];
$candidate = Candidate::where('user_id',$request->user_id)->first();
$max[0] = 2024;
$min[0] = 1980;
// $data = CandidateEducation::where('candidate_id',$candidate->id)->get();
// $year = 0;
// $flag = 0;
// $i = 0;
// $new_flag = 0;
// foreach ($down_to_up as $down_to_up_use) {
// $year++;
// if ($down_to_up_use == $request->qualification) {
// $flag = 1;
// } else {
// if ($flag == 1) {
// foreach ($data as $data_use) {
// if ($data_use->qualification == $down_to_up_use) {
// if (($data_use->qualification == "10th" || $data_use->qualification == "12th") && ($data_use->passing_year != "" || $data_use->passing_year != null)) {
// $max[$i] = $data_use->passing_year - 1;
// $i++;
// $new_flag = 1;
// break;
// }
// if (($data_use->qualification == "Diploma" || $data_use->qualification == "Bachelors" || $data_use->qualification == "Masters" || $data_use->qualification == "PhD") && ($data_use->year != "" || $data_use->year != null)) {
// $max[$i] = $data_use->year - 1;
// $i++;
// $new_flag = 1;
// break;
// }
// // if ($data_use->qualification == "10th" || $data_use->qualification == "12th") {
// // } elseif ($data_use->qualification == "Diploma" || $data_use->qualification == "Bachelors" || $data_use->qualification == "Masters") {
// // $max[$i] = $data_use->year - 1;
// // } else {
// // // $max[$i] = $data_use->year - 1;
// // }
// }
// }
// }
// }
// if ($new_flag == 1) {
// break;
// }
// }
// $flag = 0;
// $i = 0;
// rsort($max);
// $new_flag = 0;
// foreach($up_to_down as $up_to_down_use){
// $year++;
// if($up_to_down_use == $request->qualification){
// $flag = 1;
// }else{
// if($flag == 1){
// foreach($data as $data_use){
// if($data_use->qualification == $up_to_down_use){
// // if($up_to_down_use == "10th" || $up_to_down_use == "12th"){
// // $min[$i] = $data_use->passing_year+1;
// // }else{
// // $min[$i] = $data_use->passing_year+1;
// // }
// // $i++;
// // $new_flag = 1;
// // break;
// if (($data_use->qualification == "10th" || $data_use->qualification == "12th") && ($data_use->passing_year != "" || $data_use->passing_year != null)) {
// $min[$i] = $data_use->passing_year+1;
// $i++;
// $new_flag = 1;
// break;
// }
// if (($data_use->qualification == "Diploma" || $data_use->qualification == "Bachelors" || $data_use->qualification == "Masters" || $data_use->qualification == "PhD") && ($data_use->year != "" || $data_use->year != null)) {
// $min[$i] = $data_use->passing_year+1;
// $i++;
// $new_flag = 1;
// break;
// }
// }
// }
// }
// }
// if($new_flag == 1){
// break;
// }
// }
// sort($min);
if($request->doc_id == "null"){
$candidate = Candidate::where('user_id',$request->user_id)->first();
$education_data = CandidateEducation::where('candidate_id',$candidate->id)->get();
}else{
$education_data = CandidateEducation::where('id',$request->doc_id)->first();
}
$currentYear = now()->year;
if($min[0] <= 1980 || $min[0] > $currentYear){
$min[0] = 1980;
}
if($max[0] <= 1980 || $max[0] > $currentYear){
$max[0] = $currentYear;
}
$stream = [];
if($request->qualification == "10th"){
$stream = null;
}else if($request->qualification == "12th"){
$stream[] = [
"name" => "Science",
];
$stream[] = [
"name" => "Commerce",
];
$stream[] = [
"name" => "Arts",
];
$stream[] = [
"name" => "Vocational",
];
}else if($request->qualification == "Diploma"){
$stream = Diploma_course::where('status',1)->get();
}
else if($request->qualification == "Bachelors"){
$stream = Degree::where('degree_type',"UG")->get();
}
else if($request->qualification == "Masters"){
$stream = Degree::where('degree_type',"PG")->get();
}
else if($request->qualification == "PhD"){
$stream = Degree::where('degree_type',"PhD")->get();
}
else if($request->qualification == "Certification"){
$stream = null;
}
$data = 1;
if($data == 1){
return response()->json(['status'=>1,'message' => "Education Detail Successfully Fetch",'max'=>$max[0] , 'min' => $min[0],'education_detail' => $education_data, 'stream' => $stream ]);
}else{
return response()->json(['status'=>0,'message' => "Please Try Again Something Wrong Detail Not Delete", 'min' => $min[0],'education_detail' => $education_data, 'stream' => $stream ]);
}
}
public function education_detail_get(Request $request){
if($request->doc_id == "null"){
$candidate = Candidate::where('user_id',$request->user_id)->first();
$education_data = CandidateEducation::where('candidate_id',$candidate->id)->get();
}else{
$education_data = CandidateEducation::where('id',$request->doc_id)->first();
}
$doc_category = DocumentCategory::get()->ToArray();
$doc_sub_category = DocumentSubcategory::get()->ToArray();
$document_link = Storage::disk('s3')->url('/');
$document_link = substr($document_link, 0, -1);
$documents = Documents::where('user_id', $request->user_id)->get();
foreach ($documents as $item) {
$flag = 0;
$documentData = $item['document_data'];
$item['document_category_name'] = "";
if ($documentData != null && $documentData != "") {
$parsedData = json_decode($documentData, true);
$commaSeparatedData = implode(',', $parsedData);
$item['document_data'] = $commaSeparatedData;
}
foreach ($doc_sub_category as $doc_sub_category_one) {
if ($doc_sub_category_one['id'] == $item['document_subcategory_id']) {
$item['document_sub_category_name'] = $doc_sub_category_one['document_subcategory_name'];
$flag = 1;
foreach ($doc_category as $doc_category_one) {
if ($doc_category_one['id'] == $doc_sub_category_one['document_category_id']) {
$item['document_category_name'] = $doc_category_one['document_category_name'];
}
}
}
}
if ($flag == 0) {
$item['document_sub_category_name'] = null;
}
$item['document_link'] = $document_link;
}
$document = $documents->ToArray();
$data = compact(['document', 'document_link','doc_category','doc_sub_category','education_data']);
return $data;
}
public function form_work_experience_get(Request $request){
if($request->id == "null"){
$candidate = Candidate::where('user_id',$request->user_id)->first();
$education_data = WorkExperience::where('candidate_id',$candidate->id)->get();
foreach($education_data as $education_data_use){
if (!is_null($education_data_use->start_date)){
$education_data_use->start_date = date('d-m-Y', strtotime($education_data_use->start_date));
}else{
$education_data_use->start_date = "";
}
if (!is_null($education_data_use->end_date)){
$education_data_use->end_date = date('d-m-Y', strtotime($education_data_use->end_date));
}else{
$education_data_use->end_date = "";
}
}
}else{
$education_data = WorkExperience::where('id',$request->id)->first();
if (!is_null($education_data->start_date)){
$education_data->start_date = date('Y-m-d', strtotime($education_data->start_date));
}else{
$education_data->start_date = "";
}
if (!is_null($education_data->end_date)){
$education_data->end_date = date('Y-m-d', strtotime($education_data->end_date));
}else{
$education_data->end_date = "";
}
}
return $education_data;
}
public function delete_documents(Request $request)
{
abort_if(!userCan('candidate.update'), 403);
// $user_id=Auth::user()->id;
// $subcategory_id=$request->subcategory_id;
// $document=Documents::where('user_id',$user_id)
// ->where('document_subcategory_id',$subcategory_id);
$document_id = $request->document_id;
$document = Documents::where('id', $document_id)->first();
if (isset($document)) {
$document_path = $document->get()->toArray()[0]["document_location"];
$path = Storage::disk('s3')->delete($document_path);
if ($path) {
$document->delete();
return response()->json(['status' => 1]);
}
}
return response()->json(['status' => 0]);
}
public function documents_upload(Request $request)
{
if($request->subcategory_name == "LOR 1" || $request->subcategory_name == "LOR 2" ||$request->subcategory_name == "LOR 3" ){
}else{
$validator = Validator::make($request->all(), [
'file' => 'required|mimes:pdf,doc,xlsx,csv,docx,jpeg,jpg,png|max:16000000'
]);
if ($validator->fails()) {
$errors = $validator->errors();
return response()->json([
'error' => $errors,
'status' => 3
]);
}
}
$jsonData = "";
if($request->subcategory_name == "LOR 1" || $request->subcategory_name == "LOR 2" || $request->subcategory_name == "LOR 3"){
$data = [
"name" => $request->input("name"),
"designation" => $request->input("designation"),
"ofemail" => $request->input("ofemail"),
"relation" => $request->input("relation"),
];
$jsonData = json_encode($data);
}
$user_id = $request->user_id;
if ($request->hasFile('file')) {
// $user_id=Auth::user()->id;
// $subcategory=DocumentSubcategory::find($request->document_subcategory_id)->toArray()['document_subcategory_name'];
// $subcategory=str_replace("'"," ",$subcategory);
// $subcategory=explode(' ', $subcategory);
// $subcategory=implode('_', $subcategory);
$subcategory = $request->subcategory_name;
$file = $request->file('file');
$target_dir = "https://gradding.s3.ap-south-1.amazonaws.com/";
$file_type = strtolower($file->getClientOriginalExtension());
$filename = $subcategory . "_" . time() . "." . $file_type;
$user_dir = "candidate/documents/" . $user_id . "/";
$document_subcategory_id = null;
$document_name = $request->document_name;
$document_subcategory_id = $request->document_subcategory_id;
$file_path = $user_dir . $filename;
$path = Storage::disk('s3')->put($file_path, fopen($file, 'r+')); //stores file
if ($path) {
if($request->document_id != null){
$document = Documents::find($request->document_id);
$document->user_id = $user_id;
$document->document_subcategory_id = $document_subcategory_id;
$document->document_name = $document_name;
$document->document_location = $user_dir . $filename;
$document->document_size = $file->getSize();
$document->document_data = $jsonData;
$document->save();
}else{
$document = new Documents;
$document->user_id = $user_id;
$document->document_subcategory_id = $document_subcategory_id;
$document->document_name = $document_name;
$document->document_location = $user_dir . $filename;
$document->document_size = $file->getSize();
$document->document_data = $jsonData;
$document->save();
}
return response()->json(['document_subcategory_id' => $request->document_subcategory_id, 'status' => 1, "message" => "document successfully Uploaded"]);
}
else{
return response()->json(['document_subcategory_id' => $request->document_subcategory_id, 'status' => 0, "message" => "Something Wrong Please Try Again"]);
}
}
else if($request->subcategory_name == "LOR 1" || $request->subcategory_name == "LOR 2" || $request->subcategory_name == "LOR 3"){
$document = Documents::find($request->document_id);
if (!$document) {
$document = new Documents();
}
$document->user_id = $user_id;
$document->document_subcategory_id = $request->document_subcategory_id;
$document->document_data = $jsonData;
$document->save();
return response()->json(['document_subcategory_id' => $request->document_subcategory_id, 'status' => 1, "message" => "document successfully Uploaded"]);
}
else{
return response()->json(['document_subcategory_id' => $request->document_subcategory_id, 'status' => 2, "message" => "Attach Document File"]);
}
}
public function get_documents(Request $request)
{
$doc_category = DocumentCategory::get()->ToArray();
$doc_sub_category = DocumentSubcategory::get()->ToArray();
$document_link = Storage::disk('s3')->url('/');
$document_link = substr($document_link, 0, -1);
$documents = Documents::where('user_id', $request->user_id)->get();
foreach ($documents as $item) {
$flag = 0;
$documentData = $item['document_data'];
$item['document_category_name'] = "";
if ($documentData != null && $documentData != "") {
$parsedData = json_decode($documentData, true);
$commaSeparatedData = implode(',', $parsedData);
$item['document_data'] = $commaSeparatedData;
}
foreach ($doc_sub_category as $doc_sub_category_one) {
if ($doc_sub_category_one['id'] == $item['document_subcategory_id']) {
$item['document_sub_category_name'] = $doc_sub_category_one['document_subcategory_name'];
$flag = 1;
foreach ($doc_category as $doc_category_one) {
if ($doc_category_one['id'] == $doc_sub_category_one['document_category_id']) {
$item['document_category_name'] = $doc_category_one['document_category_name'];
}
}
}
}
if ($flag == 0) {
$item['document_sub_category_name'] = null;
}
$item['document_link'] = $document_link;
}
$document = $documents->ToArray();
$data = compact(['document', 'document_link','doc_category','doc_sub_category']);
return view('admin.lead-management.candidate-detail.get_documents',compact('data'));
return response()->json(['data' => $data]);
}
public function get_webinar(Request $request)
{
$candidate = Candidate::where('user_id',$request->user_id)->select('id')->first();
$webinar_history = InterestedCandidatesWebinar::where('candidate_id', $candidate->id)->get();
foreach($webinar_history as $webinar_history_use){
$webinar = Webinars::where('id', $webinar_history_use->webinar_id)->first();
if($webinar != null){
$webinar_history_use->webinar_name = $webinar->webinar_name;
$webinar_history_use->webinar_link = $webinar->webinar_link;
$webinar_history_use->dateTime = $webinar->dateTime;
}
}
$code = "";
foreach ($webinar_history as $webinar_history_use){
$code .= "
" . $webinar_history_use->webinar_name . "
" . date('d-m-Y H:i:s', strtotime($webinar_history_use->dateTime)) . "
";
if (!empty($webinar_history_use->webinar_link)) {
$code .= "Join Link ";
} else {
$code .= "--";
}
$code .= "
" . ($webinar_history_use->attended == 1 ? 'Yes' : 'No') . "
";
}
$webinards= Webinars::select('id', 'webinar_name','webinar_link','dateTime')->get()->toArray();
return response()->json(['code' => $code,'webinars' => $webinards]);
}
public function get_tests_data(Request $request)
{
$userMockTestData = UsersMockTest::where('user_id',$request->user_id)->first();
$mockTestResults = MockTestResult::where('user_id',$request->user_id)->get()->ToArray();
$response = [];
if($userMockTestData != null){
$new_test = explode(",",$userMockTestData->ielts_test_ids);
// dd($new_test);
$IeltsMockTests = IeltsMockTest::whereIn('id',$new_test)->get()->ToArray();
$new_test = array_reverse($new_test);
return view('admin.lead-management.candidate-detail.get_tests_data', compact('userMockTestData', 'mockTestResults', 'response','new_test','IeltsMockTests'));
}else{
return view('admin.lead-management.candidate-detail.get_tests_data', compact('userMockTestData', 'mockTestResults', 'response'));
}
}
public function get_test_by_category(Request $request)
{
$tests = IeltsMockTest::where('category_id',$request->category_id)->select('id')->get()->toArray();
return $tests;
}
public function get_activity(Request $request)
{
$user = User::where('id',$request->user_id)->first();
return view('admin.lead-management.candidate-detail.get_activity',compact('user'));
}
public function profile_complete($candidate_id){
$candidate = Candidate::where('id',$candidate_id)->first();
$user = User::findOrFail($candidate->user_id);
$null_fields = 0;
$Available_fields = 0;
$Available_mandatary = 0;
$null_mandatary = 0;
$fields = [
'name' => $user->name,
'phone' => $user->phone,
'email' => $user->email,
'birth_date' => $candidate->birth_date,
'country_id' => $candidate->country_id,
'state_id' => $candidate->state_id,
'city_id' => $candidate->city_id,
'address' => $candidate->address,
'budget' => $candidate->budget,
'fund_source' => $candidate->fund_source,
'preferred_country' => @$candidate->destination[0]->preferred_country,
'preferred_program' => @$candidate->destination[0]->preferred_program,
'preffered_stream' => @$candidate->destination[0]->preffered_stream,
];
if($candidate->visa_refusal == 1){
$fields['visa_refusal'] = $candidate->visa_refusal;
$fields['visa_refusal_reason'] = $candidate->visa_refusal_reason;
}
if($candidate->passport_status == 1){
$fields['passport_expiry'] = $candidate->passport_expiry;
$fields['passport_number'] = $candidate->passport_number;
}
if($candidate->marital_status == 1){
$fields['marital_status'] = $candidate->marital_status;
if($candidate->spouse_comming == 1){
$fields['spouse_comming'] = $candidate->spouse_comming;
$fields['spouse_qualification'] = $candidate->spouse_qualification;
$fields['spouse_employment_status'] = $candidate->spouse_employment_status;
$fields['spouse_income'] = $candidate->spouse_income;
$fields['kids_count'] = $candidate->kids_count;
$fields['accompanying_applicant'] = $candidate->accompanying_applicant;
$fields['comment'] = $candidate->comment;
}
}
$mandatoryFields = ['name', 'phone', 'email', 'birth_date', 'gender', 'passport_number', 'passport_expiry', 'country_id', 'state_id', 'city_id', 'visa_refusal', 'marital_status', ];
foreach ($fields as $field => $value) {
if ($value != "" && $value != null) {
$Available_fields++;
if (in_array($field, $mandatoryFields)) {
$Available_mandatary++;
}
} else {
$null_fields++;
if (in_array($field, $mandatoryFields)) {
$null_mandatary++;
}
}
}
$personal_info = $Available_fields+$null_fields;
$personal_info_available = $Available_fields;
if($null_mandatary > 0){
$personal_info_mandatary = 1;
}else{
$personal_info_mandatary = 0;
}
$personal_info_available_percentage = ($Available_fields/$personal_info)*100;
$null_fields = 0;
$Available_fields = 0;
$Available_mandatary = 0;
$null_mandatary = 0;
if(isset($candidate->destination[0])){
if($candidate->destination[0]['preferred_country'] != "" && $candidate->destination[0]['preferred_country'] !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
if($candidate->destination[0]['intake_years'] != "" && $candidate->destination[0]['intake_years'] !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
if($candidate->destination[0]->intake_months != "" && $candidate->destination[0]->intake_months !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
if($candidate->destination[0]->preferred_program != "" && $candidate->destination[0]->preferred_program !=null){
$Available_fields++;
}else{
$null_fields++;
}
if($candidate->destination[0]->preffered_stream != "" && $candidate->destination[0]->preffered_stream !=null){
$Available_fields++;
}else{
$null_fields++;
}
}else{
$Available_fields = 0;
$null_fields = 4;
$null_mandatary = 4;
$Available_mandatary = 0;
}
$study_abroad_info = $Available_fields+$null_fields;
$study_abroad_info_available = $Available_fields;
if($null_mandatary > 0){
$study_abroad_info_mandatary = 1;
}else{
$study_abroad_info_mandatary = 0;
}
$study_abroad_info_available_percentage = ($Available_fields/$study_abroad_info)*100;
$null_fields = 0;
$Available_fields = 0;
$Available_mandatary = 0;
$null_mandatary = 0;
if($candidate->budget != "" && $candidate->budget !=null){
$Available_fields++;
}else{
$null_fields++;
}
if($candidate->fund_source != "" && $candidate->fund_source !=null){
$Available_fields++;
}else{
$null_fields++;
}
if($candidate->loan_type != "" && $candidate->loan_type !=null){
$Available_fields++;
}else{
$null_fields++;
}
$budget_info = $Available_fields+$null_fields;
$budget_info_available = $Available_fields;
if($null_mandatary > 0){
$budget_info_mandatary = 1;
}else{
$budget_info_mandatary = 0;
}
$budget_info_available_percentage = ($Available_fields/$budget_info)*100;
$null_fields = 0;
$Available_fields = 0;
$Available_mandatary = 0;
$null_mandatary = 0;
$english_test = [
'test_name' => '',
'test_taken_date' => '',
'test_result_date' => '',
'test_scores' => '',
];
$abroad_test = [
'test_name' => '',
'test_taken_date' => '',
'test_result_date' => '',
'test_scores' => '',
];
foreach ($candidate->candidate_exam as $index => $exam){
if ($exam->test_type == 1){
$abroad_test = [
'test_name' => $exam->test_name,
'test_taken_date' => $exam->test_taken_date,
'test_result_date' => $exam->test_result_date,
'test_scores' => $exam->test_scores,
];
}
else if($exam->test_type == 0){
$english_test = [
'test_name' => $exam->test_name,
'test_taken_date' => $exam->test_taken_date,
'test_result_date' => $exam->test_result_date,
'test_scores' => $exam->test_scores,
];
}
}
if($english_test['test_name'] != "NT"){
if($english_test['test_name'] != "" && $english_test['test_name'] !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
if($english_test['test_taken_date'] != "" && $english_test['test_taken_date'] !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
if(@$english_test['test_result_date'] != "" && @$english_test['test_result_date'] !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
if($english_test['test_scores'] != "" && $english_test['test_scores'] !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
}
if($abroad_test['test_name'] != "NT"){
if($abroad_test['test_name'] != "" && $abroad_test['test_name'] !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
if($abroad_test['test_taken_date'] != "" && $abroad_test['test_taken_date'] !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
if($abroad_test['test_result_date'] != "" && $abroad_test['test_result_date'] !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
if($abroad_test['test_scores'] != "" && $abroad_test['test_scores'] !=null){
$Available_fields++;
$Available_mandatary++;
}else{
$null_fields++;
$null_mandatary++;
}
}
$test_score_info = $Available_fields+$null_fields;
$test_score_info_available = $Available_fields;
if($null_mandatary > 0){
$test_score_info_mandatary = 1;
}else{
$test_score_info_mandatary = 0;
}
// $test_score_info_available_percentage = ($Available_fields/$test_score_info)*100;
$null_fields = 0;
$Available_fields = 0;
$Available_mandatary = 0;
$null_mandatary = 0;
$total_fields = $study_abroad_info+$personal_info+$test_score_info;
$total_available_fields = $study_abroad_info_available+$test_score_info_available+$personal_info_available;
$available_percentage = ($total_available_fields/$total_fields)*100;
$profile_progress = [];
$profile_progress['available_percentage'] = round($available_percentage);
$profile_progress['personal_info_mandatary'] = $personal_info_mandatary;
$profile_progress['study_abroad_info_mandatary'] = $study_abroad_info_mandatary;
$profile_progress['budget_info_mandatary'] = $budget_info_mandatary;
$profile_progress['test_score_info_mandatary'] = $test_score_info_mandatary;
$profile_lock = $candidate->lock_profile;
$data = [
'profile_complete' => $profile_progress['available_percentage'],
];
if($profile_progress['available_percentage'] == 100.0){
if($profile_lock == null){
$current_date = date('Y-m-d');
$after_seven_days = date('Y-m-d', strtotime($current_date . ' + 7 days'));
$data['lock_profile'] = $after_seven_days;
}
}
Candidate::where('id',$candidate_id)->update($data);
return $profile_progress;
}
public function changesIntakes(){
$candidateDestination = CandidateDestination::get();
// dd($candidateDestination);
$count = 0;
if(!empty($candidateDestination)){
foreach ($candidateDestination as $candidate) {
if(!empty($candidate->intake)){
$intakeArray = explode(",", $candidate->intake);
// dd($intakeArray);
$months = [];
$years = [];
foreach ($intakeArray as $intake) {
// dd($intake);
list($month, $year) = explode("'", $intake);
if (!preg_match('/^20\d{2}$/', $year)) {
$year = '20' . $year;
}
$months[] = $month;
$years[] = $year;
}
$months = array_unique($months);
$years = array_unique($years);
$monthsString = implode(",", $months);
$yearsString = implode(",", $years);
if(!empty($monthsString) && !empty($yearsString)){
// dd('inside');
$data = [
'intake_years' =>$yearsString,
'intake_months' =>$monthsString
];
CandidateDestination::where('id',$candidate->id)->update($data);
}
}
}
}
if($count > 0){
echo "Intakes Updated: " . $count;
}
}
public function changesIntakesin_candidate_university_suggest(){
$candidateDestination = UniversitySuggest::get();
// dd($candidateDestination);
$count = 0;
if(!empty($candidateDestination)){
foreach ($candidateDestination as $candidate) {
if(!empty($candidate->intake)){
$intakeArray = explode(",", $candidate->intake);
// dd($intakeArray);
$months = [];
$years = [];
foreach ($intakeArray as $intake) {
// dd($intake);
list($month, $year) = explode("'", $intake);
if (!preg_match('/^20\d{2}$/', $year)) {
$year = '20' . $year;
}
$months[] = $month;
$years[] = $year;
}
$months = array_unique($months);
$years = array_unique($years);
$monthsString = implode(",", $months);
$yearsString = implode(",", $years);
if(!empty($monthsString) && !empty($yearsString)){
$data = [
'intake_years' =>$yearsString,
'intake_months' =>$monthsString
];
UniversitySuggest::where('id',$candidate->id)->update($data);
}
}
}
}
if($count > 0){
echo "Intakes Updated: " . $count;
}
}
public function get_user_number_with_country_code(Request $request,$id){
$data = User::where('id',$id)->first();
$new_data = [
'phone' => @$data->phone,
'country_code' => @$data->country_code,
'country' => $data->country,
'email' => $data->email
];
return $new_data;
}
public function transaction_invoice_download($id)
{
$payment = Payment::find($id);
$data = [
'invoice_number' => @$payment->invoice_number,
'amount' => @$payment->amount,
'currency_symbol' => @$payment->currency_symbol,
'plan_name' => @$payment->order->plan->title,
'name' => @$payment->order->name,
'email' => @$payment->order->email,
];
$pdf = app()->make(PDF::class);
$pdf->loadView('admin.lead-management.invoice', ['data' => $data]);
return $pdf->download('invoice.pdf');
}
public function get_courses_by_stream(Request $request){
$preffered_stream_list = [];
if(isset($request->preffered_stream)){
$preffered_stream_list = Course::whereIn('study_area_id',$request->preffered_stream)->orderBy('name', 'asc')->get();
}
$code = "";
foreach ($preffered_stream_list as $preffered_stream) {
if($request->preferred_course == null){
$code .= "" . $preffered_stream->name . " ";
}else{
if (in_array($preffered_stream->id, $request->preferred_course)) {
$code .= "" . $preffered_stream->name . " ";
} else {
$code .= "" . $preffered_stream->name . " ";
}
}
}
return response()->json(['code' => $code]);
}
public function commentInsertByApplicationsId(Request $request)
{
abort_if(!userCan('candidateApplication.update'), 403);
try {
$candidateApplication = CandidateApplication::where('id', $request->applications_id)->first();
if($candidateApplication){
CandidateApplicationComment::create([
'application_id' => $request->applications_id,
'comment' => $request->comment_text,
'admin_id' => Auth::user()->id,
'type' => @$request->type == 1 ? @$request->type : 0,
]);
flashSuccess("Comment Created Successfully!");
return response()->json(['success' => true]);
}
return response()->json(['success' => false, 'message' => 'Something Went Wrong'], 404);
} catch (\Exception $e) {
return response()->json(['success' => false, 'message' => $e->getMessage()], 500);
}
}
public function commentAndApplicationGetByApplicationID(Request $request)
{
abort_if(!userCan('candidateApplication.view'), 403);
try {
$candidateApplication = CandidateApplication::where('id', $request->id)->first();
if(!empty($request->type) && $request->type == 1){
$comments = CandidateApplicationComment::where("application_id", $request->id)->where("type", 1)->get();
}else{
$comments = CandidateApplicationComment::where("application_id", $request->id)->where("type",'!=', 1)->get();
}
$applicationTimeline = CandidateApplicationTimeline::where("application_id", $request->id)->get();
$partnerCode = " ";
if (!empty($candidateApplication->partners->code)) {
$partnerCode = $candidateApplication->partners->code;
}
$data['candidateApplications']['partnerApplicationId'] = ($partnerCode ? $partnerCode : '-NA-') . ' ' . ($candidateApplication->partner_application_id ?? '-NA-');
$data['candidateApplications']['id'] = @$candidateApplication->id ?? '-NA-';
$data['candidateApplications']['created_at'] = dateMonthTimeFormat(@$candidateApplication->created_at) ?? '-NA-';
$data['candidateApplications']['course'] = @$candidateApplication->courses->name ?? '-NA-';
$data['candidateApplications']['universities'] = @$candidateApplication->university->name ?? '-NA-';
$data['candidateApplications']['status'] = @$candidateApplication->status;
$data['comments'] = [];
foreach ($comments as $comment) {
$data['comments'][] = [
'id' => @$comment->id,
'comment' => @$comment->comment,
'created_at' => dateMonthTimeFormat(@$comment->created_at),
'comment_by_admin' => ucwords(@$comment->commentByAdmin->name),
'comment_by_image_url' => @$comment->commentByAdmin->image_url,
];
}
$data['applicationTimeline'] = [];
foreach ($applicationTimeline as $timeline) {
$data['applicationTimeline'][] = [
'id' => @$timeline->id,
'application_id' => @$timeline->application_id,
'candidate_id' => @$timeline->candidate_id,
'status' => @$timeline->status,
'auth_name' => ucwords(@$timeline->auth_name),
'auth_type' => @$timeline->auth_type,
'comment' => @$timeline->comment,
'created_at' => dateMonthTimeFormat(@$timeline->created_at),
];
}
return response()->json($data);
} catch (\Exception $e) {
return response()->json(['success' => false, 'message' => $e->getMessage()], 500);
}
}
public function get_short_list(Request $request){
$list = CourseShortlist::where('user_id',$request->user_id)
->leftjoin('courses','courses.id','course_shortlists.course_id')
->leftjoin('universities','universities.id','courses.university_id')
->select('courses.name as course_name','universities.name as university_name','universities.logo','course_shortlists.applied','courses.IntakeDeadLines','course_shortlists.id as id')
->get()->ToArray();
return view('admin.lead-management.candidate-detail.get_short_list',compact('list'));
}
public function add_new_course(Request $request){
$partner_find = Partner::select('id','name')->get()->ToArray();
return view('admin.lead-management.candidate-detail.add_new_course',compact('partner_find'));
}
public function get_whatsapp_log(Request $request){
// $whatsapplogs = Whatsapplog::where('user_id',$request->user_id)->where('status',1)->get()->ToArray();
$whatsapplogs = Whatsapp_tracker::where('user_id', $request->user_id)->orderBy('created_at', 'desc')->get();
return view('admin.lead-management.candidate-detail.get_whatsapp_log',compact('whatsapplogs'));
}
public function order_get(Request $request){
$orders = Order::where('candidate_id', $request->candidate_id)->orderBy('created_at', 'desc')->get();
return view('admin.lead-management.candidate-detail.order_get',compact('orders'));
}
public function get_transaction(Request $request){
$transactions = Payment::where('candidate_id',$request->candidate_id)->get();
return view('admin.lead-management.candidate-detail.get_transaction',compact('transactions'));
}
// public function study_abroad_preference(Request $request){
// $candidate = Candidate::where('id',$request->candidate_id)->first();
// $countries = Countries::all('id', 'name','sortname');
// $preferred_countries = [];
// $other_countries = [];
// $jsonString = str_replace(['"', '[', ']'], '', @$candidate->destination[0]->preferred_country);
// $preferred_country_ids = explode(",", $jsonString);
// foreach ($preferred_country_ids as $preferred_country_id) {
// $country = $countries->firstWhere('id', $preferred_country_id);
// if ($country) {
// $preferred_countries[] = [
// 'id' => $country->id,
// 'name' => $country->name,
// 'sortname' => $country->sortname,
// ];
// }
// }
// $intake_years = explode(',', @$candidate->destination[0]->intake_years);
// $intake_months = explode(',', @$candidate->destination[0]->intake_months);
// $jsonString = str_replace(['"', '[', ']'], '', @$candidate->destination[0]->preferred_country);
// $preferred_program = explode(',', @$candidate->destination[0]->preferred_program);
// $preferredPrograms = explode(',', @$candidate->destination[0]->preffered_stream);
// $streams = StudyArea::get()->toArray();
// $code = "";
// $code .= '';
// $code .= '';
// $code .= '
//
// ';
// if(isset($countries)){
// foreach ($countries as $country){
// $code .= '';
// $code .= $country['name'];
// } else {
// $code .= 'value="' . $country['id'] . '">' . $country['name'];
// }
// $code .= ' ';
// }
// }
// $code .= '
//
//
Country(You Can Select Only 3 Contries)
//
';
// $code .= '
//
// ';
// for ($i = 2022; $i <= date('Y') + 3; $i++) {
// $code .= '' . $i . ' ';
// }
// $code .= '
// Not Decided ';
// // Closing PHP tag after the loop
// $code .= '
//
//
Plan Year
//
';
// $code .= '
//
//
// Jan
// Feb
// Mar
// Apr
// May
// Jun
// July
// Aug
// Sept
// Oct
// Nov
// Dec
// Not Decided
//
//
//
Intake Season
//
';
// $code .= '
//
//
// MBA
// Bachelors
// Masters
// PG Diploma
// Certification
// PHD
// Others
// Not Decided
//
//
//
Preferred Program
//
';
// $code .= '
//
// ';
// foreach ($streams as $stream)
// $code .= '' . $stream["name"] . '
// value="' . $stream["id"] . '">' . $stream["name"] . '';
// $code .= ' Not Decided
//
//
// Other
// No
// Preference
//
//
//
//
Preferred Stream
//
';
// $code .= '
//
//
//
Preferred Courses
//
';
// $code .= '
//
//
//
// Applied University ';
// if (@$candidate->destination[0]->applied_university_name != null){
// $code .= 'Yes
// No ';
// }
// else{
// $code .= 'Yes
// No ';
// }
// $code .= '
//
//
Applied University
//
';
// $code .= '
//
//
//
Name of University
//
';
// $code .= '
//
//
// Connected Consultant ';
// if (@$candidate->destination[0]->consultant_name != null){
// $code .= 'Yes
// No ';
// }else{
// $code .= 'Yes
// No ';
// }
// $code .= '
//
//
//
Connected Consultant
//
';
// $code .= '
//
//
//
Name of Consultant
//
';
// $code .= '
' . $answer->name . '
';
if(is_array($answer->value)) {
$code .= '';
foreach($answer->value as $item) {
$code .= '' . $item . '
';
} else {
$code .= '' . $answer->value . '
';
}
}
}
}
}
}else{
$status = 2;
}
$data = [
'status' => $status,
'code' => $code,
'data' => $MockTestResults,
];
return $data;
}
public function save_test_result(Request $request){
$data = [
'score' => $request->score,
];
$MockTestResults = MockTestResult::where('id',@$request->test_id)->update($data);
if($MockTestResults == 1){
return response()->json(['status'=>1,'message' => "Test Result Update Successfully"]);
}else{
return response()->json(['status'=>2,'message' => "Please Try Again Something Wrong "]);
}
}
public function get_forms(Request $request){
$user = User::where('id',$request->user_id)->first();
return view('admin.lead-management.candidate-detail.get_forms',compact('user'));
}
public function get_candidate_data(Request $request) {
$user = User::where('id', $request->user_id)->select('stages', 'dropped_reason', 'stage_expiry_date', 'id')->first();
$user->stage_expiry_date = date('d-m-Y h:i:s A', strtotime($user->stage_expiry_date));
$userArray = $user->toArray();
$userArray['stage_name'] = getStageGroup($userArray['stages']);
return $userArray;
}
public function notes_save(Request $request)
{
$candidate = Candidate::findOrFail($request->id);
// Check if notes is already an array
$jsonData = is_array($candidate->notes) ? $candidate->notes : json_decode($candidate->notes, true);
if (!is_array($jsonData)) {
// If it's not an array, create a new array
$jsonData = [];
}
$flag = 0;
foreach ($jsonData as &$item) {
if ($item['auth_id'] == auth()->user()->id) {
$item['notes'] = $request->notes;
$item['auth_name'] = auth()->user()->name;
$flag = 1;
}
}
if ($flag == 0) {
$newJson = [
'auth_id' => auth()->user()->id,
'auth_name' => auth()->user()->name,
'notes' => $request->notes,
];
// Use array_merge to add the new entry to the existing array
$jsonData[] = $newJson;
}
// Update the 'notes' field directly
$candidate->update([
'notes' => $jsonData,
]);
if ($candidate) {
return response()->json(['status' => 1]);
}
return response()->json(['status' => 0]);
}
}
![delete-icon](" . asset("backend") . "/lead-management/images/delete.svg)
Comments
21/09/202304:49PM
Dear Team,
We are not going to take this case forward as the applicant is from Bihar and completed a bachelor’s from Punjab, which is a GTE concern, hence we are closing this case.