1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / api.kitchentoolsbd.com / app / Domains / ApiResponse / Service /
Filename : ApiDashboardService.php
back
<?php

namespace App\Domains\ApiResponse\Service;

use App\Domains\ApiResponse\Resources\CustomerOrderResource;
use App\Domains\Auth\Models\User;
use App\Domains\Auth\Notifications\OTPMail;
use App\Domains\Order\Models\Order;
use App\Domains\Order\Models\OrderItem;
use App\Domains\Order\Models\OrderReturn;
use App\Domains\Order\Models\OrderReturnItem;
use App\Domains\Order\Models\StoreCredit;
use Exception;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;

/**
 * Class ApiDashboardService.
 */
class ApiDashboardService
{
    public $excepts = ['request-for-return', 'return-progress', 'returned', 'return-cancel'];

    public function orders()
    {
        $page = \request('page', 1);
        $limit = \request('limit', 50);
        $page = ($page - 1);
        $offset = ($limit * $page);
        $auth_id = auth('sanctum')->id();
        $orders = Order::with('items', 'returnOrder')
            ->where('user_id', $auth_id)
            ->withSum('items', 'total_amount')
            ->orderByDesc('id')
            ->offset($offset)
            ->paginate($limit);

        return CustomerOrderResource::collection($orders, ['simple', 'items', 'returnOrder'])->response()->getData(true);
    }

    public function orderDetails($order_uuid): CustomerOrderResource
    {
        $auth_id = auth('sanctum')->id();
        $orders = Order::with(['returnOrder', 'items' => function ($item) {
            $item->with(['product', 'variations']);
        }])
            ->where('user_id', $auth_id)
            ->where('uuid', $order_uuid)
            ->first();

        return CustomerOrderResource::single($orders, ['simple', 'items', 'returnOrder','variations']);
    }

    public function reserve_orders()
    {
        $auth_id = auth('sanctum')->id();
        $reserve = Order::with('items', 'returnOrder')
            ->where('user_id', $auth_id)
            ->whereHas('items', function ($items) {
                $items->where('status', 'reserve');
            })
            ->withSum('items', 'total_amount')
            ->orderByDesc('id')
            ->get();
        return [
            'reserve' => $reserve
        ];
    }

    public function returns()
    {
        $auth_id = auth('sanctum')->id();
        $orders = OrderReturn::with('returnItems', 'order')
            ->where('user_id', $auth_id)
            ->withSum('returnItems', 'total_amount')
            ->orderByDesc('id')
            ->get();

        return [
            'returns' => $orders
        ];
    }

    public function store_credit()
    {
        $auth_id = auth('sanctum')->id();
        $credit = StoreCredit::where('user_id', $auth_id)
            ->orderByDesc('id')
            ->get();

        return [
            'credit' => $credit
        ];
    }

    public function return_orders()
    {
        $prof_picture = request('prof_picture');
        $selected = request('selected', []);
        $return_reason = request('return_reason');
        $order_id = request('order_id');
        $auth_id = auth('sanctum')->id();

        $orders = Order::where('user_id', $auth_id)
            ->where('id', $order_id)
            ->first();
        $orderItems = OrderItem::whereIn('id', $selected)->where('user_id', $auth_id)->get();

        if ($orderItems->count()) {
            $return = new  OrderReturn();
            $return->order_id = $order_id;
            $return->return_reason = $return_reason;
            $return->prof_picture = $prof_picture;
            $return->status = 'request-for-return';
            $return->user_id = $auth_id;
            $return->save();
            foreach ($orderItems as $item) {
                $r_item = new  OrderReturnItem();
                $r_item->order_return_id = $return->id;
                $r_item->order_item_id = $item->id;
                $r_item->product_id = $item->product_id;
                $r_item->name = $item->name;
                $r_item->original_price = $item->original_price;
                $r_item->sale_price = $item->sale_price;
                $r_item->discount_amount = $item->discount_amount;
                $r_item->quantity = $item->quantity;
                $r_item->sale_unit_id = $item->sale_unit_id;
                $r_item->total_amount = $item->total_amount;
                $r_item->attributes = $item->attributes;
                $r_item->status = 'request-for-return';
                $r_item->user_id = $auth_id;
                $r_item->save();

                $item->status = 'request-for-return';
                $item->save();
            }
        }
        return [
            'orders' => $orders
        ];
    }
}