File Manager

Editing File: /home/ubuntu/walnutminds-ecom-backend-base/app/Exports/OrderPaymentsExport.php

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromCollection;

use Illuminate\Contracts\View\View;

use Maatwebsite\Excel\Concerns\FromView;

use Illuminate\Http\Request;

use App\Models\OrderPayment;

use App\Helpers\Helper;

class OrderPaymentsExport implements FromView
{
    public function __construct(Request $request)
    {
        $this->search_key = $request->search_key;
        $this->status = $request->status;
        $this->email_status = $request->email_status;
        $this->filter_by = $request->filter_by;
        $this->user_id = $request->user_id;
    }

/**
    * @return \Illuminate\Support\Collection
    */
    public function view(): View {

$order_payments = OrderPayment::Query()
                        ->with(['user:id,name'])
                        ->when(isset($this->status), function ($query) {
                            $query->where('status', $request->status);
                        })->when($this->filter_by == "TODAY", function ($query) {
                            $query->whereDate('created_at', today());
                        })->when(isset($this->user_id), function ($query) {
                            $query->where('user_id', $request->user_id);
                        })->when($this->search_key, function($query) {
                            $query->where('unique_id', "LIKE", "%". $request->search_key . "%");
                            $query->orWhere('payment_id', "LIKE", "%". $request->search_key . "%")
                                ->orWhereHas('user', function ($query) {
                                    $query->where('name', "LIKE", "%" . $request->search_key . "%");
                            });
                        })->orderBy('created_at', 'DESC')->get();

return view('exports.order_payments', [ 'data' => $order_payments ]);
    }
}

Back to Directory File Manager