@extends('layouts.layouts') @section('content') @php $data=array("TEST_PACKAGE_ID"=>0,"FIRSTNAME"=>"","LASTNAME"=>"","FATHERSNAME"=>"","FIRSTNAME"=>"","DOB"=>"","GENDER"=>"","MINORITYCATEGORY"=>"","EMAIL"=>"", "MOBILE"=>"","RELIGION"=>"","WIDOW"=>"","EXSERVICEMAN"=>"","DIFFERENTLYABLED"=>"","VISUALLYIMPAIRED"=>"","HEARINGIMPAIRED"=>"","ortho"=>"","DISABILITYPERCENTAGE"=>0, "FB"=>"","GOOGLE"=>"","ADDRESS"=>"","CURRENTEDUSTATUS"=>"","SSLCYEAR"=>"","SSLCMEDIUM"=>"","SSLCDEGREE"=>"","SSLCSUBJECT"=>"","SSLCBOARD"=>"", "SSLCINSTITUTION"=>"","SSLCSCORE"=>"","HSCYEAR"=>"","HSCMEDIUM"=>"","HSCDEGREE"=>"","HSCSUBJECT"=>"","HSCBOARD"=>"","HSCINSTITUTION"=>"","HSCSCORE"=>"", "DIPLOMOYEAR"=>"","DIPLOMOMEDIUM"=>"","DIPLOMODEGREE"=>"","DIPLOMOSUBJECT"=>"","DIPLOMOBOARD"=>"","DIPLOMOINSTITUTION"=>"","DIPLOMOSCORE"=>"","UGYEAR"=>"","UGMEDIUM"=>"", "UGDEGREE"=>"","UGSUBJECT"=>"","UGBOARD"=>"","UGINSTITUTION"=>"","UGSCORE"=>"","PGYEAR"=>"","PGMEDIUM"=>"","PGDEGREE"=>"","PGSUBJECT"=>"", "PGBOARD"=>"","REG_FEES_STATUS"=>0,"PGINSTITUTION"=>"","PGSCORE"=>"","PREFERRENTIALDEGREE"=>"","NATIONALAWARD"=>"","CURRENTEMPLOYEE"=>"","EMPLOYEEPOSITION"=>"","COMPANYNAME"=>"","HEARABOUTUS"=>"","PROFILEIMG"=>0,"PROFILEPIC"=>"","FILE_ID_INDEX"=>"","COURSES"=>array(),"STATEID"=>"","CITYID"=>"","STREETNAME"=>"","PINCODE"=>"","REGSTATUS"=>"OFFLINE"); if(array_key_exists("INFO",$FORMDATA)){ if(count($FORMDATA['INFO']['PERSONALINFO'])>0){ $data['FIRSTNAME']=$FORMDATA['INFO']['PERSONALINFO'][0]->FIRSTNAME; $data['LASTNAME']=$FORMDATA['INFO']['PERSONALINFO'][0]->LASTNAME; $data['FATHERSNAME']=$FORMDATA['INFO']['PERSONALINFO'][0]->FATHERSNAME; $data['DOB']=$FORMDATA['INFO']['PERSONALINFO'][0]->DOB; $data['GENDER']=$FORMDATA['INFO']['PERSONALINFO'][0]->GENDER; $data['MINORITYCATEGORY']=$FORMDATA['INFO']['PERSONALINFO'][0]->MINORITYCATEGORY; $data['EMAIL']=$FORMDATA['INFO']['PERSONALINFO'][0]->EMAIL; $data['MOBILE']=$FORMDATA['INFO']['PERSONALINFO'][0]->MOBILE; $data['RELIGION']=$FORMDATA['INFO']['PERSONALINFO'][0]->RELIGION; $data['WIDOW']=$FORMDATA['INFO']['PERSONALINFO'][0]->WIDOW; $data['EXSERVICEMAN']=$FORMDATA['INFO']['PERSONALINFO'][0]->SERVICEMAN; $data['DIFFERENTLYABLED']=$FORMDATA['INFO']['PERSONALINFO'][0]->DIFFERENTLYABLED; $data['VISUALLYIMPAIRED']=$FORMDATA['INFO']['PERSONALINFO'][0]->visually_impaired; $data['HEARINGIMPAIRED']=$FORMDATA['INFO']['PERSONALINFO'][0]->hearing_impaired; $data['ortho']=$FORMDATA['INFO']['PERSONALINFO'][0]->ortho; $data['DISABILITYPERCENTAGE']=$FORMDATA['INFO']['PERSONALINFO'][0]->disability_percent; $data['FB']=$FORMDATA['INFO']['PERSONALINFO'][0]->FB; $data['GOOGLE']=$FORMDATA['INFO']['PERSONALINFO'][0]->LINKEDIN; $data['ADDRESS']=$FORMDATA['INFO']['PERSONALINFO'][0]->ADDRESS; $data['PINCODE']=$FORMDATA['INFO']['PERSONALINFO'][0]->PINCODE; $data['STATEID']=$FORMDATA['INFO']['PERSONALINFO'][0]->STATEID; $data['CITYID']=$FORMDATA['INFO']['PERSONALINFO'][0]->CITYID; $data['STREETNAME']=$FORMDATA['INFO']['PERSONALINFO'][0]->STREETNAME; $data['CURRENTEMPLOYEE']=$FORMDATA['INFO']['PERSONALINFO'][0]->currently_employee; $data['EMPLOYEEPOSITION']=$FORMDATA['INFO']['PERSONALINFO'][0]->position; $data['COMPANYNAME']=$FORMDATA['INFO']['PERSONALINFO'][0]->company_name; if(count($FORMDATA['INFO']['EDUCATIONINFO'])>0){ $data['SSLCYEAR']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->SSLC_year_passing; $data['SSLCMEDIUM']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->SSLC_language; $data['SSLCDEGREE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->SSLC_degree; $data['SSLCSUBJECT']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->SSLC_dept; $data['SSLCBOARD']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->SSLC_board; $data['SSLCINSTITUTION']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->SSLC_institution; $data['SSLCSCORE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->SSLC_percentage; if($FORMDATA['INFO']['EDUCATIONINFO'][0]->HSC_year_passing!=""){ $data['HSCYEAR']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->HSC_year_passing; $data['HSCMEDIUM']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->HSC_language; $data['HSCDEGREE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->HSC_degree; $data['HSCSUBJECT']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->HSC_dept; $data['HSCBOARD']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->HSC_board; $data['HSCINSTITUTION']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->HSC_institution; $data['HSCSCORE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->HSC_percentage; } if($FORMDATA['INFO']['EDUCATIONINFO'][0]->Diplomo_year_passing!=""){ $data['DIPLOMOYEAR']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->Diplomo_year_passing; $data['DIPLOMOMEDIUM']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->Diplomo_language; $data['DIPLOMODEGREE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->Diplomo_degree; $data['DIPLOMOSUBJECT']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->Diplomo_dept; $data['DIPLOMOBOARD']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->Diplomo_board; $data['DIPLOMOINSTITUTION']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->Diplomo_institution; $data['DIPLOMOSCORE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->Diplomo_percentage; } if($FORMDATA['INFO']['EDUCATIONINFO'][0]->UG_year_passing!=""){ $data['UGYEAR']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->UG_year_passing; $data['UGMEDIUM']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->UG_language; $data['UGDEGREE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->UG_degree; $data['UGSUBJECT']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->UG_dept; $data['UGBOARD']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->UG_board; $data['UGINSTITUTION']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->UG_institution; $data['UGSCORE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->UG_percentage; } if($FORMDATA['INFO']['EDUCATIONINFO'][0]->PG_year_passing!=""){ $data['PGYEAR']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->PG_year_passing; $data['PGMEDIUM']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->PG_language; $data['PGDEGREE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->PG_degree; $data['PGSUBJECT']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->PG_dept; $data['PGBOARD']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->PG_board; $data['PGINSTITUTION']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->PG_institution; $data['PGSCORE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->PG_percentage; } $data['PREFERRENTIALDEGREE']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->posses_degree; $data['NATIONALAWARD']=$FORMDATA['INFO']['EDUCATIONINFO'][0]->posses_award; } } } $user_profile_sql="SELECT * FROM tbl_attachments WHERE REFERID='".$USERINFO['REFERID']."' AND (Title='STD-PROFILE-PIC' OR IMAGETYPE='PROFILE') AND Module='STUDENT' "; $user_profile_result=DB::select($user_profile_sql); if(count($user_profile_result)>0){ $data['PROFILEPIC']=url('/')."/".$user_profile_result[0]->UploadDir.$user_profile_result[0]->UploadName; } @endphp