@extends('hr_main') @section('title', '| Appoinment Letter Waiting List') @section('content') @include('convert_word') {{-- @include('microfin/passBookBalanceViews/PassBookBalanceAjax') --}} @php $salaryTotal = 0; $company = DB::table('gnr_company')->where('id', Auth::user()->company_id_fk)->select('name','address')->first(); $operationalConfig =DB::table('mfn_cfg')->where('name','operationalPolicy_cfg')->value('config'); $operationalConfiguration = json_decode($operationalConfig,true); $fiscalYear = DB::table('gnr_fiscal_year') ->select('name') ->orderBy('id', 'DESC') ->limit(1) ->pluck('name') ->toArray(); @endphp

Appointment Letter


{{-- {!! Form::open(array('url' => '#', 'role' => 'form', 'class'=>'form-horizontal form-groups', 'id' => 'filterFormId', 'method'=>'POST')) !!} --}}
{{-- Start of Branch Name --}}
{{-- Start of the Submit Button --}}
Ref.: {{$company->name}}/Admin/Appointment-HO/{{$fiscalYear[0]}}
@php $appointmentDate = date("Y-m-d"); list($year, $month, $day) = explode('-', $appointmentDate); switch ($month) { case 1: $month = 'January'; break; case 2: $month = 'February'; break; case 3: $month = 'March'; break; case 4: $month = 'April'; break; case 5: $month = 'May'; break; case 6: $month = 'June'; break; case 7: $month = 'July'; break; case 8: $month = 'August'; break; case 9: $month = 'September'; break; case 10: $month = 'October'; break; case 11: $month = 'November'; break; case 12: $month = 'December'; break; } echo $month.' '.$day.', '.$year; @endphp
 
@foreach ($emp_infos as $key => $emp_info) @php $id = $empName = $emp_infos->pluck('emp_id_fk')->toArray(); $emp_id = DB::table('hr_emp_general_info') ->where('id', $id[0]) ->pluck('emp_id') ->toArray(); @endphp @endforeach
To: {{$emp_info->emp_name_english}}
{{$emp_info->present_address}} {{$emp_id[0]}}
 
{{-- --}}
Subject: Appointment Letter
 
@php $empName = $emp_infos->pluck('emp_name_english')->toArray(); $interview_process_date = $emp_infos->pluck('interview_process_date')->toArray(); $branchInfo = $emp_infos->pluck('branch_Id_Fk')->toArray(); $positionInfo = $emp_infos->pluck('position_id_fk')->toArray(); $gradeInfo = $emp_infos->pluck('grade')->toArray(); $levelInfo = $emp_infos->pluck('level_id_fk')->toArray(); $joiningPlace = $emp_infos->pluck('joining_place')->toArray(); $salaryInfo = $emp_infos->pluck('salary')->toArray(); $officialJoiningDate = $emp_infos->pluck('official_joining_date')->toArray(); $joiningPlace = $emp_infos->pluck('joining_place')->toArray(); $baseStation = $emp_infos->pluck('base_station')->toArray(); $appointmentType = $emp_infos->pluck('appointment_type')->toArray(); $contractPeriodDate = $emp_infos->pluck('contract_period_date')->toArray(); $firstSupervisor = $emp_infos->pluck('first_supervisor')->toArray(); $employeeJoiningDate = $emp_infos->pluck('employee_joining_date')->toArray(); $empIdFk = $emp_infos->pluck('emp_id_fk')->toArray(); // dd($empIdFk[0]); $benefitTypeAndAmount = DB::table('hr_emp_org_info') ->select('benefit_type_fk', 'benefit_type_amount') ->where('emp_id_fk', $empIdFk[0]) ->get(); $benefitType = $benefitTypeAndAmount->pluck('benefit_type_fk')->toArray(); $benefitTypeArray = explode(',', $benefitType[0]); foreach ($benefitTypeArray as $key => $benefitTypeArrayValue) { // code... $benefitTypeName[$benefitTypeArrayValue] = DB::table('hr_settings_benefit_type') ->select('name') ->where('id', $benefitTypeArrayValue) ->pluck('name') ->toArray(); } $benefitAmount = $benefitTypeAndAmount->pluck('benefit_type_amount')->toArray(); $benefitAmountArray = explode(',', $benefitAmount[0]); // dd($benefitTypeName, $benefitAmountArray, $benefitTypeArray); $branch = DB::table('gnr_branch') ->select('name') ->where('id', $branchInfo[0]) ->pluck('name') ->toArray(); $position = DB::table('hr_settings_position') ->select('name') ->where('id', $positionInfo[0]) ->pluck('name') ->toArray(); $higherAuthorityPosition = DB::table('hr_settings_position') ->select('id') ->where('name', '=', 'Executive Director') ->pluck('id') ->toArray(); $higherAuthorityORGid = DB::table('hr_emp_org_info') ->select('emp_id_fk') ->where('position_id_fk', $higherAuthorityPosition[0]) ->pluck('emp_id_fk') ->toArray(); $higherAuthorityInfos = DB::table('hr_emp_general_info') ->select('emp_name_english') ->where('id', $higherAuthorityORGid[0]) ->pluck('emp_name_english') ->toArray(); $grade = DB::table('hr_settings_grade') ->select('name') ->where('id', $gradeInfo[0]) ->pluck('name') ->toArray(); $level = DB::table('hr_settings_level') ->select('name') ->where('id', $levelInfo[0]) ->pluck('name') ->toArray(); list($year_for_interview_date, $month_for_interview_date, $day_for_interview_date) = explode('-', $interview_process_date[0]); switch ($month_for_interview_date) { case 1: $month_for_interview_date = 'January'; break; case 2: $month_for_interview_date = 'February'; break; case 3: $month_for_interview_date = 'March'; break; case 4: $month_for_interview_date = 'April'; break; case 5: $month_for_interview_date = 'May'; break; case 6: $month_for_interview_date = 'June'; break; case 7: $month_for_interview_date = 'July'; break; case 8: $month_for_interview_date = 'August'; break; case 9: $month_for_interview_date = 'September'; break; case 10: $month_for_interview_date = 'October'; break; case 11: $month_for_interview_date = 'November'; break; case 12: $month_for_interview_date = 'December'; break; } list($year_for_joining_date, $month_for_joining_date, $day_for_joining_date) = explode('-', $officialJoiningDate[0]); switch ($month_for_joining_date) { case 1: $month_for_joining_date = 'January'; break; case 2: $month_for_joining_date = 'February'; break; case 3: $month_for_joining_date = 'March'; break; case 4: $month_for_joining_date = 'April'; break; case 5: $month_for_joining_date = 'May'; break; case 6: $month_for_joining_date = 'June'; break; case 7: $month_for_joining_date = 'July'; break; case 8: $month_for_joining_date = 'August'; break; case 9: $month_for_joining_date = 'September'; break; case 10: $month_for_joining_date = 'October'; break; case 11: $month_for_joining_date = 'November'; break; case 12: $month_for_joining_date = 'December'; break; } list($year_for_contract_date, $month_for_contract_date, $day_for_contract_date) = explode('-', $contractPeriodDate[0]); switch ($month_for_contract_date) { case 1: $month_for_contract_date = 'January'; break; case 2: $month_for_contract_date = 'February'; break; case 3: $month_for_contract_date = 'March'; break; case 4: $month_for_contract_date = 'April'; break; case 5: $month_for_contract_date = 'May'; break; case 6: $month_for_contract_date = 'June'; break; case 7: $month_for_contract_date = 'July'; break; case 8: $month_for_contract_date = 'August'; break; case 9: $month_for_contract_date = 'September'; break; case 10: $month_for_contract_date = 'October'; break; case 11: $month_for_contract_date = 'November'; break; case 12: $month_for_contract_date = 'December'; break; } list($year_for_employee_joinning_date, $month_for_employee_joinning_date, $day_for_employee_joinning_date) = explode('-', $employeeJoiningDate[0]); switch ($month_for_employee_joinning_date) { case 1: $month_for_employee_joinning_date = 'January'; break; case 2: $month_for_employee_joinning_date = 'February'; break; case 3: $month_for_employee_joinning_date = 'March'; break; case 4: $month_for_employee_joinning_date = 'April'; break; case 5: $month_for_employee_joinning_date = 'May'; break; case 6: $month_for_employee_joinning_date = 'June'; break; case 7: $month_for_employee_joinning_date = 'July'; break; case 8: $month_for_employee_joinning_date = 'August'; break; case 9: $month_for_employee_joinning_date = 'September'; break; case 10: $month_for_employee_joinning_date = 'October'; break; case 11: $month_for_employee_joinning_date = 'November'; break; case 12: $month_for_employee_joinning_date = 'December'; break; } @endphp
Dear {{$empName[0]}},
Congratulation! We are happy to inform you that your performance in the interview process held on {{$day_for_interview_date}} {{$month_for_interview_date}}, {{$year_for_interview_date}} at {{$company->name}} Head Office in Dhaka has seemed satisfactory. We are offering you the post of  '{{$position[0]}}' for  '{{$joiningPlace[0]}}' of {{$company->name}} as per the following Terms and Conditions.
 
@for ($i=0; $i < sizeof($benefitTypeArray); $i++) @php $nameValue = $benefitTypeArray[$i]; $salaryTotal = $salaryTotal + $benefitAmountArray[$i]; @endphp @endfor
Post : {{$position[0]}}
Grade & Level : {{$grade[0]}}, {{$level[0]}}
Salary (Gross) : {{$salaryInfo[0]}} /- (@php echo convert_number_to_words($salaryInfo[0]); @endphp)
{{$benefitAmountArray[$i]}} /- As {{$benefitTypeName[$nameValue][0]}}
{{$salaryTotal + $salaryInfo[0]}} /= (@php echo convert_number_to_words($salaryTotal + $salaryInfo[0]); @endphp)
Other Facalities : You will be provided two festival bonuses, welfare fund and other admissible benefites as per the official policies.
Joining Date : {{$day_for_joining_date}} {{$month_for_joining_date}}, {{$year_for_joining_date}} at 9:00 AM
Joining Place : {{$joiningPlace[0]}}
Base Station : {{$baseStation[0]}}. But you will have to work in any project or place in Bangladesh as per the purpose of the organization.
 
Conditions:
{{-- --}}
  		• {{-- Your period will be {{$day_for_contract_date}} {{$month_for_contract_date}}, {{$year_for_contract_date}}, in this period if you are willing to leave the organization for your own reason, you have notify the authority of the organization at least two month before. --}} Your {{$appointmentType[0]}} Period is {{$day_for_contract_date}} {{$month_for_contract_date}}, {{$year_for_contract_date}}; after completing this period satisfactorily you will be a confirmed staff as per the organization policies and then your salary will be revised as per salary structure of the organization. During the {{$appointmentType[0]}} period, the organization authority may terminate your service without giving any clarification/prior notice if your performance is not up to expectation or for any other reason, Note that The Authority of the organization can extend if the performance of yours seems dissatisfactory.
    2. Authority has the rights to evaluate your workings progress and revise your salary and others financial and non-financial benefits,but due to lack of satisfactory performance this letter or contract can be cancelled without any clarification or prior notice by the authority.
  		• This is a position of continuous responsibility and does not entail payment of extra time or overtime.
  		• You will have to respect & obey to the organizational rules & regulations currently in practice in addition with the new policies that may be introduced by the organization in course of time.
  		• You are expected to be fit to provide necessary energy and commitment to your job to fulfill your duties ably and fully. It is not permitted to be gainfully engaged in other employment while working for Ambala Foundation.
  		• Your first supervisor will be the {{$firstSupervisor[0]}}.
  		• Your details job description will be given after joining.
  		• You are responsible to do all the work as per your job description (JD) as well as responsible to support other correspondent personnel as per need.
  		• Any document, information or data entrusted to or produced by Ambala Foundation shall be strictly confidential and cannot be used by you for any other purpose without the written consent of the EC authority.
  		• And you have to perform any other responsibilities assigned by the authority time to time for the greater interest of the organization.
     
    We hope that you will do the best in {{$company->name}} to strengthen the organization. We wish you all the success.
     
    Thanking You
     
     
     
    {{$higherAuthorityInfos[0]}}
    Executive Director
     
    Copy to:
  • Director.
    		•
  • Program Director-(MFP).
    		•
  • HR & Admin-Department.
    		•
  • Finance & Accounts-Dept.
    		•
  • IT Department.
    		•
  • Personnel File of the employee.
    		•
    Acceptance by the Employer
    I have read, understood and accepted the above terms and conditions and I am accepting all the terms and conditions of employment. As desired, I shall join service within the {{$day_for_employee_joinning_date}} {{$month_for_employee_joinning_date}}, {{$year_for_employee_joinning_date}} or earlier.
     
     
    Signature
    Date:
    @php // dd($fiscalYear[0]); @endphp
    {{--
    {!! Form::label('', '', ['class' => 'control-label col-md-12', 'style' => 'color:#708090; padding-top: 25px;']) !!}
    --}}
    {{-- {!! Form::close() !!} --}}
    {{-- @include('microfin/reports/mfnFieldOfficerReport/mfnFieldreport1_new_table'); --}}
    @endsection