One Hat Cyber Team

Your IP : 3.145.91.233

Server IP : 162.241.123.123

Server : Linux sh016.hostgator.in 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64

Server Software : Apache

PHP Version : 8.2.25

Buat File | Buat Folder

Dir : ~/home1/saicsazq/sitecreator.in/app/Exports/

View File Name : ProductOrderExport.php

<?php

namespace App\Exports;

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


class ProductOrderExport implements FromCollection, WithHeadings, WithMapping
{
    public $orders;

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

    public function map($order): array
    {

        $bex = BasicSetting::where('user_id', Auth::guard('web')->user()->id)->first();

        return [
            $order->order_number,
            $order->billing_fname,
            $order->billing_email,
            $order->billing_number,
            $order->billing_city,
            $order->billing_country,
            $order->shpping_fname,
            $order->shpping_email,
            $order->shpping_number,
            $order->shpping_city,
            $order->shpping_country,
            $order->method,
            !empty($order->shipping_method) ? $order->shipping_method : '-',
            $order->payment_status,
            $order->order_status,
            ($bex->base_currency_symbol_position == 'left' ? $bex->base_currency_symbol : '') . $order->cart_total . ($bex->base_currency_symbol_position == 'right' ? $bex->base_currency_symbol : ''),
            ($bex->base_currency_symbol_position == 'left' ? $bex->base_currency_symbol : '') . $order->discount . ($bex->base_currency_symbol_position == 'right' ? $bex->base_currency_symbol : ''),
            ($bex->base_currency_symbol_position == 'left' ? $bex->base_currency_symbol : '') . $order->tax . ($bex->base_currency_symbol_position == 'right' ? $bex->base_currency_symbol : ''),
            ($bex->base_currency_symbol_position == 'left' ? $bex->base_currency_symbol : '') . $order->shipping_charge . ($bex->base_currency_symbol_position == 'right' ? $bex->base_currency_symbol : ''),
            ($bex->base_currency_symbol_position == 'left' ? $bex->base_currency_symbol : '') . $order->total . ($bex->base_currency_symbol_position == 'right' ? $bex->base_currency_symbol : ''),
            $order->created_at
        ];
    }

    public function headings(): array
    {
        return [
            'Order Number', 'Billing Name', 'Billing Email', 'Billing Phone', 'Billing City', 'Billing Country', 'Shipping Name', 'Shipping Email', 'Shipping Phone', 'Shipping City', 'Shipping Country', 'Gateway', 'Shipping Method', 'Payment Status', 'Order Status', 'Cart Total', 'Discount', 'Tax', 'Shipping Charge', 'Total', 'Date'
        ];
    }

}