1#@!#!123s

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

namespace App\Http\Livewire\Backend\Report;

use App\Domains\Order\Models\Order;
use App\Domains\Order\Models\OrderItem;
use App\Domains\Order\Models\OrderItemVariation;
use App\Domains\Order\Models\OrderReturn;
use App\Domains\Products\Models\Product;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Str;
use Rappasoft\LaravelLivewireTables\DataTableComponent;
use Rappasoft\LaravelLivewireTables\Views\Column;

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

    public $currency = '';

    /**
     * @return Builder
     */
    public function query(): Builder
    {

        $this->currency = get_setting('currency_icon', '$');


        return Product::with([
            'saleUnit:id,name',
            'orderItems' => function ($query) {
                $query->with('variations')
                    ->where('status', 'delivered');
            }])
            ->whereHas('orderItems')
            ->withCount('orderItems')
            ->orderBy('order_items_count', 'DESC');
    }

    public function columns(): array
    {
        return [
            Column::make('#productId', 'id')
                ->sortable()
                ->searchable(),
            Column::make('Thumbnail', 'thumbnail_img')
                ->format(function ($value) {
                    $img = $value ?: 'img/no-image.gif';
                    return '<img src="' . asset($img) . '" style="width:50px">';
                })->asHtml(),
            Column::make('Name', 'name')
                ->searchable()
                ->format(function ($value) {
                    return '<span title="' . $value . '">' . Str::limit($value, 45) . '</span>';
                })
                ->asHtml(),
            Column::make('SKU', 'sku')
                ->searchable(),
            Column::make('No. of Orders', 'order_items_count')
                ->searchable()
                ->format(function ($value) {
                    return $value ?: 0;
                }),
            Column::make('Last Sale Price', 'sale_price')
                ->searchable()
                ->format(function ($sale_price) {
                    return $this->currency . ' ' . ($sale_price ?: 0);
                })
                ->addClass('font-weight-bold'),
            Column::make('Total Quantity', 'quantity')
                ->format(function ($value, $row, $model) {
                    if ($model->orderItems->count() > 0) {
                        $quantity = $model->orderItems->map(function ($item) {
                            return [
                                'quantity' => $item->variations->sum('quantity')
                            ];
                        })->sum('quantity');
                        return $quantity ?: 0 . ' ' . $model->saleUnit->name;
                    }
                    return 0;
                }),
            Column::make('Order Amount', 'total_price')
                ->format(function ($value, $row, $model) {
                    $total = $model->orderItems->map(function ($item) {
                        return [
                            'total' => $item->variations->map(function ($variation) {
                                $quantity = (int)$variation->quantity;
                                $salePrice = (int)$variation->sale_price;
                                return [
                                    'total' => round($quantity * $salePrice, 2),
                                ];
                            })->sum('total')
                        ];
                    })->sum('total');
                    return $this->currency . ' ' . ($total ?: 0);
                })
        ];
    }

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

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