Gecko [ gandhischool.edu.np ]

Name	Size	Permission	Action
CylinderBarcodeExport.php	1.29 KB	-rw-rw-r--

Code Editor : CylinderBarcodeExport.php

<?php

namespace App\Exports;

use App\Models\CylinderBarcode;
use App\Models\RepairDetail;
use App\Models\Repair;
use App\Models\Receive;
use App\Models\Company;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithColumnWidths;
use DB;

class CylinderBarcodeExport implements FromCollection,WithHeadings, WithColumnWidths
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        
        $data = DB::table('repair_details')
                    ->join('repair','repair_details.repair_id','=','repair.id')
                    ->join('receive', 'receive.id', '=', 'repair.receive_id')
                    ->join('company', 'receive.company_id', '=', 'company.id')
                    ->select('company.name','receive.lot_no','receive.date','repair_details.cylinder_code')
                    ->get();

return $data;
    }

public function headings(): array
    {
        return [
            'Company',
            'Lot Number',
            'receivedate',
            'cylinder Code'
        ];
    }

public function columnWidths(): array
    {
        return [
            'A' => 60,
            'B' => 25, 
            'C' => 25,
            'D' => 20          
        ];
    }
}

${this.title}

Code Editor : CylinderBarcodeExport.php