Default page

Your IP: 192.88.135.6
Server IP: 192.124.249.6
Server: Linux 56.244.72.148.host.secureserver.net 5.14.0-570.62.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Nov 11 10:10:59 EST 2025 x86_64
Server Software: Apache
PHP Version: 8.1.33
Buat File | Buat Folder

Edit File: EnrolmentsExport.php

<?php

namespace App\Exports;

use App\Models\User\BasicSetting;
use App\Models\User\Language;
use Illuminate\Support\Facades\Auth;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;

class EnrolmentsExport implements FromCollection, WithHeadings, WithMapping
{
  public $enrols;

public function __construct($enrols)
  {
    $this->enrols = $enrols;
  }
  /**
   * @return \Illuminate\Support\Collection
   */
  public function collection()
  {
    return $this->enrols;
  }

public function map($enrol): array
  {
    $bs = BasicSetting::where('user_id', Auth::guard('web')->user()->id)->firstOrFail();
    $deLang = Language::where('user_id', Auth::guard('web')->user()->id)->where('is_default', 1)->first();

return [
      $enrol->order_id,
      $enrol->course->courseInformation()->where('language_id', $deLang->id)->pluck('title')->first(),

($bs->base_currency_symbol_position == 'left' ? $bs->base_currency_symbol : '') . $enrol->course_price . ($bs->base_currency_symbol_position == 'right' ? $bs->base_currency_symbol : ''),

($bs->base_currency_symbol_position == 'left' ? $bs->base_currency_symbol : '') . (empty($enrol->discount) ? 0 : $enrol->discount) . ($bs->base_currency_symbol_position == 'right' ? $bs->base_currency_symbol : ''),

($bs->base_currency_symbol_position == 'left' ? $bs->base_currency_symbol : '') . $enrol->grand_total . ($bs->base_currency_symbol_position == 'right' ? $bs->base_currency_symbol : ''),

$enrol->billing_first_name,
      $enrol->billing_email,
      $enrol->billing_contact_number,
      $enrol->billing_city,
      $enrol->billing_state,
      $enrol->billing_country,
      $enrol->payment_method,
      $enrol->payment_status,
      $enrol->created_at
    ];
  }

public function headings(): array
  {
    return [
      'Order Number', 'Course', 'Course Price', 'Discount', 'Total', 'Name', 'Email', 'Phone', 'City', 'State', 'Country', 'Gateway', 'Payment Status', 'Date'
    ];
  }
}