HSBC CSR Donor Report - downloaded from CMIS3.0 on {{$today}}

@php $i = 1; @endphp @foreach($report as $key) @php $i++; @endphp @endforeach
Partner Name CentreID Centre address Unique trainee ID Salutation Student ID Name of trainee Date Of Birth (DD) Date Of Birth (MM) Date Of Birth (YYYY) Gender Marital status Religion Caste category Highest education level Currently pursuing full-time education Technical education Guardian type Name of parent/ spouse/guardian Guardian contact number No. of family members in current household Family economic status (Ration Card) Major Source of household income Trainee Annual income before joining corse Annual household income Type of identification Aadhar number PAN number Voter ID number Trainee mobile number Trainee alternate number Trainee email ID Trainee address District State PIN code Type of disability PWD Certificate Mobilisation technique Pre-joining Councelling Pre-training job experience Trainee current employment status Course name Sector Course duration(in days) Course duration(in hours) Skill instructor/Trainer name Batch start date(DD) Batch start date(MM) Batch start date(YYYY) Batch end date(DD) Batch end date(MM) Batch end date(YYYY) Number of hours Trade related classroom training completed Number of hours of lab based training completed Number of hours of life skill training completed Industry visit attended OJT attended Guest lecture attended Training status Attendance (%) Final assessment conducted Date of course passing Certified Date of issuance of certificate Certificate name or award Grade/%/Pass/Fail
Anudip Foundation {{ $key->center_short_code }}/{{ $key->course_alias }}-01 {{ $key->center_address }} AF/{{ $key->center_short_code }}/{{ $key->course_alias }}-01/{{ $i }}/ {{ ucfirst($key->salutation) }}. {{ $key->member_code }} {{ $key->name_of_trainee }} {{ date('d', strtotime($key->dob)) }} {{ date('m', strtotime($key->dob)) }} {{ date('Y', strtotime($key->dob)) }} {{ ucfirst($key->gender) }} {{ ucfirst($key->marital_status) }} {{ ucfirst($key->religion) }} {{ ucfirst($key->cast) }} {{ ucfirst($key->highest_education) }} @if($key->pursue_id == 0) {{ "No" }} @else {{ "Yes" }} @endif @if($key->can_operate_computer == 0) {{ "No" }} @else {{ "Yes" }} @endif {{ $key->guardian_type }} {{ $key->guardian_name }} {{ $key->guardian_contact_no }} {{ $key->no_of_members }} {{ $key->ration_card_eco_status }} {{ ucfirst($key->father_occupation) }} {{ $key->current_monthly_earning }} @if(!empty($key->current_monthly_earning)) {{ $key->current_monthly_earning }} @else {{ "0" }} @endif {{ $key->family_monthly_earning }} @if($key->doc_type == "adhar") {{ "Aadhar card" }} @elseif($key->doc_type == "pan") {{ "Pan Card" }} @elseif($key->doc_type == "voter_card") {{ "Voter Card" }} @else {{ "No ID proof" }} @endif @if($key->doc_type == "adhar") {{ $key->identity_no }} @endif @if($key->doc_type == "pan") {{ $key->identity_no }} @endif @if($key->doc_type == "voter_card") {{ $key->identity_no }} @endif {{ $key->mobile_no }} @if($key->alt_contact_no != 0) {{ $key->alt_contact_no }} @endif {{ $key->email_id }} {{ $key->l_address }} {{ $key->district }} {{ $key->state }} {{ $key->pincode }} @if($key->disability_status == 0) {{ "Not applicable (NA)" }} @else {{ $key->disability_nature }} @endif @if($key->disability_status == 0) {{ "Not applicable (NA)" }} @else {{ "Yes" }} @endif {{ $key->mobilisation_technique }} Completed @if($key->occupation_status == 0) {{ "Unemployed" }} @else @if($key->employment_type == "business_part_time" || $key->employment_type == "business_full_time") {{ "Self-employed" }} @else {{ "Employed" }} @endif @endif @if($key->occupation_status == 0) {{ "Fresher" }} @else {{ "Experience" }} @endif {{ $key->course_name }} ({{$key->course_alias}}) IT and ITES {{ $key->course_duration_days }} {{ $key->course_duration_hours }} {{ $key->batch_trainers }} {{ date('d', strtotime($key->batch_start_date)) }} {{ date('m', strtotime($key->batch_start_date)) }} {{ date('Y', strtotime($key->batch_start_date)) }} {{ date('d', strtotime($key->batch_end_date)) }} {{ date('m', strtotime($key->batch_end_date)) }} {{ date('Y', strtotime($key->batch_end_date)) }} {{ (isset($key->trade_related_hours_count)?$key->trade_related_hours_count:'') }} {{ (isset($key->lab_training_hours_count )?$key->lab_training_hours_count :'')}} {{ (isset($key->life_skill_training_hours_count)?$key->life_skill_training_hours_count:'') }} {{ (isset($key->industry_visit_status_count)?$key->industry_visit_status_count:'') }} {{ (isset($key->ojt_attend_status_count)?$key->ojt_attend_status_count:'') }} {{ (isset($key->guest_lecture_status_count)?$key->guest_lecture_status_count:'') }} {{ (isset($key->training_status)?$key->training_status:'') }} {{ (isset($key->final_exam_date)?date('d-m-Y', $key->final_exam_date):'') }} @if(isset($key->final_exam_date) && $key->final_exam_date!=null) Certified @else Not issued @endif @if(isset($key->final_exam_date) && $key->final_exam_date!=null) {{ date('d-m-Y', $key->certificate_issue_date) }} @endif {{(isset($key->final_exam_marks)?$key->final_exam_marks:'')}}