<?php

namespace App\Exports;

use Illuminate\Support\Facades\DB;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\FromCollection;
use Illuminate\Support\Facades\Session;
use App\Models\User;
use App\Models\RestaurantKey;

class RestaurantKeyExport implements FromCollection, WithHeadings
{
	/**
	 * @return \Illuminate\Support\Collection
	 */
	public function collection()
	{

		$query = RestaurantKey::with("employee_details")->orderBy('created_at', 'DESC')->get(
			[
        "admin_id",
        "licence_key",
        "employee_id",
        "created_date",
        "activation_date",
        "duration",
        "status",
        "customer_id",
        "customer_name",
        "customer_email",
        "customer_mobile"
      ]);

      foreach($query as $q)
      {
         $q->employee_name = $q->employee_details ? $q->employee_details->name : "";
         $q->employee_mobile = $q->employee_details ? $q->employee_details->mobile : "";
         $q->employee_email = $q->employee_details ? $q->employee_details->email : "";
      }

      unset($query->employee_id);

      return $query;

	}

	public function headings(): array
	{
		return [
      "admin_id",
        "licence_key",
        "employee_id",
        "created_date",
        "activation_date",
        "duration",
        "status",
        "customer_id",
        "customer_name",
        "customer_email",
        "customer_mobile",
        "employee_name",
        "employee_mobile",
        "employee_email"
		];
	}
}