ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / costbloc.com / app / Filters

<?php

namespace App\Filters;
use App\Filters\Filter;

class OrderFilter extends Filter
{
    /**
     * set the rules of query string
     *
     * @var array
     */
    protected $filterRules = [
        'order_status_id' => 'required',
        'vendor_id' => 'required',
        'start_date' => 'required',
        'end_date' => 'required',
        'payment_status' => 'required',
    ];

/**
     * filter status  query string
     *
     * @param string $status
     * @return query builder
     */
    public function orderStatusId($orderStatusId)
    {
        return $this->query->where('order_status_id', $orderStatusId);
    }

/**
     * filter by payment query string
     *
     * @param int $type
     * @return void
     */
    public function paymentStatus($paymentStatus)
    {
        return $this->query->where('payment_status', $paymentStatus);
    }

/**
     * filter by vendor query string
     *
     * @param int $type
     * @return void
     */
    public function vendorId($vendorId)
    {
        return $this->query->whereHas("orderDetails", function ($q) use ($vendorId) {
            $q->where('vendor_id', $vendorId);
        })->with('orderDetails');
    }

/**
     * @param $startDate
     * @return void
     */
    public function startDate($startDate)
    {
        if ($startDate != 'null') {
            return $this->query->where('order_date', '>=', DbDateFormat($startDate));
        }
    }

/**
     * @param $endDate
     * @return void
     */
    public function endDate($endDate)
    {
        if ($endDate != 'null') {
            return $this->query->where('order_date', '<=', DbDateFormat($endDate));
        }
    }

/**
     * filter by search query string
     *
     * @param string $value
     * @return query builder
     */
    public function search($value)
    {
        $value = xss_clean($value['value']);
        if (!empty($value)) {
            return $this->query->where(function ($query) use ($value) {
                $query->WhereLike('reference', $value)
                    ->orWhereLike('payment_status', $value)
                    ->orWhereLike('total', $value)
                    ->orwhereHas("user", function ($q) use ($value) {
                        $q->whereLike('name', $value);
                    })->orwhereHas("orderStatus", function ($q) use ($value) {
                        $q->whereLike('name', $value);
                    });
            });
        }
    }
}

[-] ProductVariationSearchFilter.php [edit]
[-] ReviewFilter.php [edit]
[-] Filter.php [edit]
[-] VendorFilter.php [edit]
[+] ..
[-] ProductFilter.php [edit]
[-] ProductSearchFilter.php [edit]
[-] TransactionFilter.php [edit]
[-] UserActivityLogFilter.php [edit]
[-] ThreadFilter.php [edit]
[-] OrderFilter.php [edit]
[-] UsersActivityLogFilter.php [edit]
[-] VendorProductFilter.php [edit]
[-] UserFilter.php [edit]
[-] WithdrawalFilter.php [edit]