1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / api.kitchentoolsbd.com / app / Http / Livewire / Backend / Orders /
Filename : InhouseOrderTable.php
back
<?php

namespace App\Http\Livewire\Backend\Orders;

use App\Domains\Order\Models\Order;
use Illuminate\Database\Eloquent\Builder;
use Rappasoft\LaravelLivewireTables\DataTableComponent;
use Rappasoft\LaravelLivewireTables\Views\Column;

/**
 * Class InhouseOrderTable.
 */
class InhouseOrderTable extends DataTableComponent
{

    private $excepts = ['return-progress', 'returned'];

    protected $listeners = ['incrementPostCount'];

    public $type;

    public function mount($type)
    {
        $this->type = $type;
    }

    /**
     * @return Builder
     */
    public function query(): Builder
    {
        $status = $this->excepts;
        if ($this->type == 'trashed') {
            return Order::onlyTrashed()->with(['user:id,name', 'items' => function ($query) use ($status) {
                $query->whereNotIn('status', $status);
            }]);
        }
        return Order::with(['user:id,name', 'items' => function ($query) use ($status) {
            $query->whereNotIn('status', $status);
        }])
            ->whereHas('items', function ($items) use ($status) {
                $items->whereNotIn('status', $status);
            })
            ->orderByDesc('id');
    }

    public function columns(): array
    {
        return [
            Column::make('orderNumber', 'order_number')
                ->sortable()
                ->searchable(),
            Column::make('Customer', 'user.name')
                ->searchable(),
            Column::make('Phone', 'user.phone')
                ->searchable(),
            Column::make('Area', 'area')
                ->searchable(),
            Column::make('Method', 'payment_method')
                ->searchable(),
            Column::make('Shipping', 'shipping_charge')
                ->searchable(),
            Column::make('Discount', 'coupon_discount')
                ->searchable(),
            Column::make('TotalAmount', 'total_amount')
                ->format(function ($value, $column, $row) {
                    return $row->items->sum('total_amount');
                }),
            Column::make('TotalItems', 'items_count')
                ->format(function ($value, $column, $row) {
                    return $row->items->count();
                }),
            Column::make('Status', 'status')
                ->searchable(),
            Column::make('Tracking', 'tracking_number')
                ->addClass('tracking_number'),
            Column::make('Note', 'note'),
            Column::make(__('Action'), 'action')
                ->format(function ($value, $column, $row) {
                    if ($this->type == 'trashed') {
                        return view('backend.orders.order.includes.trashActions', ['order' => $row]);
                    }
                    return view('backend.orders.order.includes.actions', ['order' => $row]);
                }),
        ];
    }

    public function setTableRowId($model)
    {
        return 'item_' . $model->id;
    }

    public function setTableDataClass($attribute, $value)
    {
        return $attribute->column;
    }
}