000

<?php

namespace App\Exports;

use Illuminate\Http\Request;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use DB;
use Maatwebsite\Excel\Concerns\WithColumnFormatting;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;
use Maatwebsite\Excel\Concerns\WithColumnWidths;

// class UserFormExport implements FromCollection,WithHeadings
class UserPendingFormExport extends \PhpOffice\PhpSpreadsheet\Cell\StringValueBinder implements FromCollection,WithHeadings
,WithColumnFormatting, WithColumnWidths
{
     public function columnWidths(): array
    {
        return [
            'BO' => 30,
        ];
    }
    
    public function __construct(Request $request)
    {
        $this->request = $request;
    }
    public function collection()
    {
        
            if(\Auth::user()->role_id == '2'){
                if(\Auth::user()->role_type=='1'){
                 $form_data = \DB::table('membership_details')->select('membership_details.*','master.mcc_name as mccname','master.mcc_code as mcccode','master.mpp_name as mppname','master.mpp_code as mppcode','master.village_code','master.village_name','master.hamlet_code','master.hamlet_name','master.tehsil_code','master.tehsil_name','master.district_code','master.district_name','master.state_name')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('master.is_active', 1)->leftjoin('user_edit_permissions','user_edit_permissions.form_id','membership_details.id')->where('membership_details.is_active', 1)->where(function ($query) {  $query->where('membership_details.final_approval_status', 'Requested')->orWhereNull('membership_details.final_approval_status');})->orderBy('membership_details.id','desc')->whereIn('membership_details.mcc_code',explode(',',\Auth::user()->assigned_mcc))->where('user_edit_permissions.user_id', \Auth::user()->id)->get();
                }elseif(\Auth::user()->role_type=='2'){
                 $form_data = \DB::table('membership_details')->select('membership_details.*','master.mcc_name as mccname','master.mcc_code as mcccode','master.mpp_name as mppname','master.mpp_code as mppcode','master.village_code','master.village_name','master.hamlet_code','master.hamlet_name','master.tehsil_code','master.tehsil_name','master.district_code','master.district_name','master.state_name')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('master.is_active', 1)->leftjoin('legal_edit_permissions','legal_edit_permissions.form_id','membership_details.id')->where('membership_details.is_active', 1)->where(function ($query) {  $query->where('membership_details.final_approval_status', 'Requested')->orWhereNull('membership_details.final_approval_status');})->orderBy('membership_details.id','desc')->whereIn('membership_details.mcc_code',explode(',',\Auth::user()->assigned_mcc))->where('legal_edit_permissions.user_id', \Auth::user()->id)->get();
                }elseif(\Auth::user()->role_type=='3'){
                 $form_data = \DB::table('membership_details')->select('membership_details.*','master.mcc_name as mccname','master.mcc_code as mcccode','master.mpp_name as mppname','master.mpp_code as mppcode','master.village_code','master.village_name','master.hamlet_code','master.hamlet_name','master.tehsil_code','master.tehsil_name','master.district_code','master.district_name','master.state_name')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('master.is_active', 1)->leftjoin('finance_edit_permissions','finance_edit_permissions.form_id','membership_details.id')->where('membership_details.is_active', 1)->where(function ($query) {  $query->where('membership_details.final_approval_status', 'Requested')->orWhereNull('membership_details.final_approval_status');})->orderBy('membership_details.id','desc')->whereIn('membership_details.mcc_code',explode(',',\Auth::user()->assigned_mcc))->where('finance_edit_permissions.user_id', \Auth::user()->id)->get();
                }
            }else{
            $form_data = \DB::table('membership_details')->select('membership_details.*','master.mcc_name as mccname','master.mcc_code as mcccode','master.mpp_name as mppname','master.mpp_code as mppcode','master.village_code','master.village_name','master.hamlet_code','master.hamlet_name','master.tehsil_code','master.tehsil_name','master.district_code','master.district_name','master.state_name')->leftJoin('master','master.mpp_code','membership_details.mpp_code')->where('master.is_active', 1)->where('membership_details.is_active', 1)->where(function ($query) {  $query->where('membership_details.final_approval_status', 'Requested')->orWhereNull('membership_details.final_approval_status');})->orderBy('membership_details.id','desc')->get();
            }

$finalArr = array();
        $n = 0 ;
        foreach($form_data as $key=>$member_data) {
            $finalArr[$n]['form_number'] = $member_data->form_no;
            $finalArr[$n]['member_name'] = strtoupper($member_data->applicant_name);
            $finalArr[$n]['father_name'] = $member_data->husband_or_father_name;
            $finalArr[$n]['member_relation'] = $member_data->husband_or_father;
            $finalArr[$n]['gender'] = $member_data->gender;
            $finalArr[$n]['age'] = $member_data->applicant_age;
            $finalArr[$n]['caste_category'] = $member_data->cast;
            $finalArr[$n]['qualification'] = $member_data->education;
            $finalArr[$n]['house_no'] = $member_data->house_no;
            $finalArr[$n]['member_hamlet_code'] = $member_data->hamlet_code;
            $finalArr[$n]['member_hamlet_name'] = $member_data->hamlet_name;
            $finalArr[$n]['member_village_code'] = $member_data->village_code;
            $finalArr[$n]['member_village_name'] = $member_data->village_name;
            $finalArr[$n]['post_office'] = $member_data->post_office;
            $finalArr[$n]['member_tehshil_code'] = $member_data->tehsil_code;
            $finalArr[$n]['member_tehshil_name'] = $member_data->tehsil_name;
            $finalArr[$n]['member_district_code'] = $member_data->district_code;
            $finalArr[$n]['member_district_name'] = $member_data->district_name;
            $finalArr[$n]['state_name'] = $member_data->state_name;
            $finalArr[$n]['pincode'] = $member_data->pincode;
            $finalArr[$n]['mobile_no'] = $member_data->mobile_no;
            $finalArr[$n]['phone_no'] = $member_data->landline;
            $finalArr[$n]['shg_member'] = $member_data->shg_member;
            $desiCow = explode(',', $member_data->desiCow);
            $buffalo = explode(',', $member_data->buffalo);
            $crossBred = explode(',', $member_data->crossBred);
            
            $finalArr[$n]['cow_herifer_no'] = isset($desiCow[0])?$desiCow[0]:0;
            $finalArr[$n]['buffalo_herifer_no'] = isset($buffalo[0])?$buffalo[0]:0;
            $finalArr[$n]['mix_herifer_no'] = isset($crossBred[0])?$crossBred[0]:0;
            
            $finalArr[$n]['cow_dry_no'] = isset($desiCow[1])?$desiCow[1]:0;
            $finalArr[$n]['buffalo_dry_no'] = isset($buffalo[1])?$buffalo[1]:0;
            $finalArr[$n]['mix_dry_no'] = isset($crossBred[1])?$crossBred[1]:0;
            
            $finalArr[$n]['cow_animal_nos'] = isset($desiCow[2])?$desiCow[2]:0;
            $finalArr[$n]['buffalo_animal_nos'] = isset($buffalo[2])?$buffalo[2]:0;
            $finalArr[$n]['mix_animal_nos'] = isset($crossBred[2])?$crossBred[2]:0;
            
            $finalArr[$n]['lpd_no'] = $member_data->MilkProduction;
            $finalArr[$n]['household_consumption'] = $member_data->HouseHoldConsumption;
            $finalArr[$n]['market_consumption'] = $member_data->MarketableSurplus;
            $finalArr[$n]['accountant_name'] = $member_data->account_holder_name;
            $finalArr[$n]['bank_account_no'] = $member_data->s_account_number;
            $finalArr[$n]['member_bank_name'] = $member_data->bank_name;
            $finalArr[$n]['member_branch_name'] = $member_data->branch_name;
            $finalArr[$n]['ifsc'] = $member_data->ifsc_code;
            $finalArr[$n]['particluar1_name'] = '';
            $finalArr[$n]['particluar1_name_gender'] = '';
            $finalArr[$n]['particluar1_name_age'] = '';
            $finalArr[$n]['particluar1_relation_name'] = '';
            $finalArr[$n]['nominee_name'] = $member_data->nominee_name;
            $finalArr[$n]['relation'] = $member_data->relation_with_application;
            $finalArr[$n]['nominee_address'] = $member_data->address;
            $finalArr[$n]['guardian_name'] = $member_data->guardian_name;
            $finalArr[$n]['member_family_age'] = $member_data->age;
            $finalArr[$n]['mcc_tr_code'] = $member_data->mcccode;
            $finalArr[$n]['mcc_name'] = $member_data->mccname;
            $finalArr[$n]['mpp_tr_code'] = $member_data->mppcode;
            $finalArr[$n]['mpp_name'] = $member_data->mppname;
            $finalArr[$n]['mpp_village_code'] = $member_data->village_code;
            $finalArr[$n]['mpp_village_name'] = $member_data->village_name;
            $finalArr[$n]['mpp_tehshil_code'] = $member_data->tehsil_code;
            $finalArr[$n]['mpp_tehshil_name'] = $member_data->tehsil_name;
            $finalArr[$n]['mpp_district_code'] = $member_data->district_code;
            $finalArr[$n]['mpp_district_name'] = $member_data->district_name;;
            $finalArr[$n]['mpp_hamlet_code'] = $member_data->hamlet_code;
            $finalArr[$n]['mpp_hamlet_name'] = $member_data->hamlet_name;
            $finalArr[$n]['aadhar_no'] = $member_data->aadhar_card;
            $finalArr[$n]['admission_fee'] = $member_data->admission_fee;
            $finalArr[$n]['share_qty'] = $member_data->share_quantity;
            $finalArr[$n]['paid_amount'] = $member_data->received_amount;
            $finalArr[$n]['depositor_bank_name'] = $member_data->fee_bank_name;
            $finalArr[$n]['depositor_branch_name'] = $member_data->fee_branch_name;
            $finalArr[$n]['DD_no'] = $member_data->fee_receipt_no;
            $finalArr[$n]['transaction_date'] = $member_data->fee_receipt_date;
            $finalArr[$n]['payment_mode'] = $member_data->cash_dd;
            $finalArr[$n]['wef_date'] = '';
            $finalArr[$n]['member_tr_code'] = $member_data->member_code;
            $finalArr[$n]['member_type'] = '';
            $finalArr[$n]['user_id'] = '';
            $finalArr[$n]['approval_status'] = '';  
            $finalArr[$n]['accepted_by'] = '';
            $finalArr[$n]['approval_date'] = '';
            // $finalArr[$n]['member_status'] = ($member_data->is_active == 1)?"Active":"InActive";
            $finalArr[$n]['ao_approval_status']=$member_data->ao_approval_status;
         //   $finalArr[$n]['lo_approval_status']=$member_data->lo_approval_status;
            $finalArr[$n]['fo_approval_status']=$member_data->fo_approval_status;
             $finalArr[$n]['member_status']=$member_data->final_approval_status;
             $finalArr[$n]['remark']=$member_data->remark;
             $finalArr[$n]['created_by'] = getModelById('User',$member_data->created_by_id)->name;
             $finalArr[$n]['member_code'] = $member_data->member_code;
             $finalArr[$n]['folio_number'] = $member_data->folio_number;
             $finalArr[$n]['birth_date']=date("d.m.Y", strtotime($member_data->dob));
            // if(!empty($member_data->final_approval_status)){
            //     $finalArr[$n]['member_status']=$member_data->final_approval_status;
            // }else{
            //     $finalArr[$n]['member_status']="Pending";
            // }
            $n++;
        }
        
        return collect($finalArr);

}
    
    public function columnFormats(): array
    {
        return [
            'U' => '0',
            'BO' => '0',
            'AJ' => '0',
            'BI' => '0',
            'CE' => '0',
            'CF' => '0',
        ];
    }
   
    public function headings(): array
     { 
        return [
            'form_number',
            'member_name',
            'father_name',
            'member_relation',
            'gender',
            'age',
            'caste_category',
            'qualification',
            'house_no',
            'member_hamlet_code',
            'member_hamlet_name',
            'member_village_code',
            'member_village_name',
            'post_office',
            'member_tehshil_code',
            'member_tehshil_name',
            'member_district_code',
            'member_district_name',
            'state_name',
            'pincode',
            'mobile_no',
            'phone_no',
             'shg_member',
            'cow_herifer_no',
            'buffalo_herifer_no',
            'mix_herifer_no',
            'cow_dry_no',
            'buffalo_dry_no',
            'mix_dry_no',
            'cow_in_milk_no',
            'buffalo_in_milk_no',
            'mix_in_milk_no',
            'lpd_no',
            'household_consumption',
            'market_consumption',
            'accountant_name',
            'bank_account_no',
            'member_bank_name',
            'member_branch_name',
            'ifsc',
            'particluar1_name',
            'particluar1_name_gender',
            'particluar1_name_age',
            'particluar1_relation_name',
            'nominee_name',
            'relation',
            'nominee_address',
            'guardian_name',
            'member_family_age',
            'mcc_tr_code',
            'mcc_name',
            'mpp_tr_code',
            'mpp_name',
            'mpp_village_code',
            'mpp_village_name',
            'mpp_tehshil_code',
            'mpp_tehshil_name',
            'mpp_district_code',
            'mpp_district_name',
            'mpp_hamlet_code',
            'mpp_hamlet_name',
            'aadhar_no',
            'admission_fee',
            'share_qty',
            'paid_amount',
            'depositor_bank_name',
            'depositor_branch_name',
            'transaction_number',
            'transaction_date',
            'payment_mode',
            'wef_date',
            'member_tr_code',
            'member_type',
            'user_id',
            'approval_status',
            'accepted_by',
            'approval_date',
            'pib_officer_status',
           // 'governance_officer_status',
            'finance_officer_status',
            'governance_officer_status',
            'remark',
            'facilitator',
            'member_code',
            'folio_number',
            'birth_date'
        ];
    }
 
}