public static function LoginTypeResponse($user_id)
{
$final = array();
$data = array();
//COALESCE(masters,"") as masters
$vid_path = "https://s3-us-west-2.amazonaws.com/cbrealestate/connected_uploads/";
Users::updateLastVisited($user_id);
$user_details = DB::table('users')->selectRaw("users.*,users.id as user_id,user_qualification.id as qid,active,masters,college,user_attachments.id as aid,filename,\n\t\t \t\t\t \t(SELECT FLOOR(DATEDIFF( NOW(),users.dob) / 365.25)) as age,\n company.id as cid,company.company_name as mycompany,designation,company_description,passout_year,job_description,user_jobs.id as jid,user_jobs.company_name as job_company,testimonials.id as tid,\n (SELECT U.full_name FROM users as U JOIN testimonials as T ON T.user_id1=U.id WHERE T.id=testimonials.id) as t_name,\n\t\t\t\t\t\t\t\t\tCASE \n\t\t\t\t\t\t\t\t\t WHEN DATEDIFF(NOW(),testimonials.created_at) != 0 THEN CONCAT(DATEDIFF(NOW(),testimonials.created_at) ,'d ago')\n\t\t\t\t\t\t\t\t\t WHEN HOUR(TIMEDIFF(NOW(),testimonials.created_at)) != 0 THEN CONCAT(HOUR(TIMEDIFF(NOW(),testimonials.created_at)) ,'h ago')\n\t\t\t\t\t\t\t\t\t WHEN MINUTE(TIMEDIFF(NOW(),testimonials.created_at)) != 0 THEN CONCAT(MINUTE(TIMEDIFF(NOW(),testimonials.created_at)) ,'m ago')\n\t\t\t\t\t\t\t\t\t ELSE\n\t\t\t\t\t\t\t\t\t\t CONCAT(SECOND(TIMEDIFF(NOW(),testimonials.created_at)) ,' s ago')\n\t\t\t\t\t\t\t\t\tEND as time_elapsed,\n\t\t \t\t\t \ttestimonials.description,testimonials.user_id1 as u_id,testimonials.user_id2 as u_id1, job_designation,start_year,end_year,present_job")->leftJoin('user_qualification', 'users.id', '=', 'user_qualification.user_id')->leftJoin('testimonials', 'users.id', '=', 'testimonials.user_id2')->leftJoin('company', 'users.id', '=', 'company.user_id')->leftJoin('user_attachments', 'users.id', '=', 'user_attachments.user_id')->leftJoin('user_jobs', 'users.id', '=', 'user_jobs.user_id')->Where('users.id', '=', $user_id)->orderBy('testimonials.created_at', 'DESC')->get();
if ($user_details) {
foreach ($user_details as $value) {
if (!isset($final[$value->user_id])) {
$final[$value->user_id] = array("user_id" => (string) $value->user_id, "fbid" => $value->fbid ? $value->fbid : "", "linkedin_id" => $value->linkedin_id ? $value->linkedin_id : "", "place" => $value->place ? $value->place : "", "apn_id" => $value->apn_id ? $value->apn_id : "", "reg_id" => $value->reg_id ? $value->reg_id : "", "full_name" => $value->full_name, "email" => $value->email, "password" => $value->password, "phone_number" => $value->phone_number, "profile_pic" => $value->profile_pic ? Users::getFormattedImage($value->profile_pic) : "", "lat" => $value->lat ? $value->lat : "0", "lng" => $value->lng ? $value->lng : "0", "profile_thumb" => $value->profile_thumb ? Users::getFormattedImage($value->profile_thumb) : "", "profile_video" => $value->profile_video ? $vid_path . $value->profile_video : "", "dob" => $value->dob, "age" => $value->age ? $value->age : "0", "fraternity" => $value->fraternity ? $value->fraternity : "", "bio" => $value->bio ? $value->bio : "", "user_type" => $value->user_type, "access_token" => $value->access_token, "jobs" => array(), "testimonials" => array(), "qualification" => array(), "attachment" => array(), "company" => array());
}
if (!isset($final[$value->user_id]['jobs'][$value->jid])) {
if ($value->jid) {
$final[$value->user_id]['jobs'][$value->jid] = array("job_id" => $value->jid, "company_name" => $value->job_company, "designation" => $value->job_designation, "job_description" => $value->job_description ? $value->job_description : "", "start_year" => $value->start_year, "end_year" => $value->end_year, "present_job" => $value->present_job ? (string) $value->present_job : '0');
}
}
if (!isset($final[$value->user_id]['testimonials'][$value->tid])) {
if ($value->tid) {
$final[$value->user_id]['testimonials'][$value->tid] = array("testimonial_id" => $value->tid, "user_id" => $value->u_id, "other_id" => $value->u_id1, "testimonial_by" => $value->t_name, "description" => $value->description ? $value->description : "", "time_elapsed" => $value->time_elapsed);
}
}
if (!isset($final[$value->user_id]['qualification'][$value->qid])) {
if ($value->qid) {
$final[$value->user_id]['qualification'][$value->qid] = array("qid" => (string) $value->qid, "masters" => $value->masters, "college" => $value->college, "passout_year" => $value->passout_year, "active" => $value->active ? (string) $value->active : '0');
}
}
if (!isset($final[$value->user_id]['attachment'][$value->aid])) {
if ($value->aid) {
$final[$value->user_id]['attachment'][$value->aid] = array("attachment_id" => (string) $value->aid, "filename" => $value->filename ? preg_match("/(pdf|doc|docx)/i", $value->filename) ? $vid_path . $value->filename : Users::getFormattedImage($value->filename) : "");
}
}
if (!isset($final[$value->user_id]['company'][$value->cid])) {
//if($value->cid){
$final[$value->user_id]['company'][$value->cid] = array("company_id" => $value->cid ? $value->cid : "", "company_name" => $value->mycompany ? $value->mycompany : "", "company_description" => $value->company_description ? $value->company_description : "", "designation" => $value->designation ? $value->designation : "");
//}
}
}
foreach ($final as $value) {
$job = array();
$qual = array();
$attach = array();
$company = array();
$testimonial = array();
foreach ($value['jobs'] as $value2) {
$job[] = $value2;
}
$value['jobs'] = $job;
foreach ($value['testimonials'] as $value2) {
$testimonial[] = $value2;
}
$value['testimonials'] = $testimonial;
foreach ($value['qualification'] as $value2) {
$qual[] = $value2;
}
$value['qualification'] = $qual;
foreach ($value['attachment'] as $value2) {
$attach[] = $value2;
}
$value['attachment'] = $attach;
foreach ($value['company'] as $value2) {
$company[] = $value2;
}
$value['company'] = $company;
$data[] = $value;
}
}
return $data;
}
