<?php
  
namespace App\Exports;
  
use DB;
use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Auth;
   
class ProjectExport implements FromCollection, WithHeadings
{
    /**
    * @return \Illuminate\Support\Collection
    */
    use Exportable; 

   
    public function collection()
    {  
        return DB::table('project_details AS project')
                    ->select(\DB::raw('project.id, project.title,project.start_date, project.description, CASE WHEN project.is_active = 0 THEN "Active"  WHEN project.is_active = 1 THEN "In Active"  END AS Status, project.created_at'))
                    ->get();
        
    }

    public function headings(): array
    {
        return [
            'Id',
            'Name',
            'Start Date',
            'Description',
            'Status',
            'Created At',
        ];
    }
}