Hideyo\Ecommerce\Framework\Services\Order\Entity\OrderRepository::create()

Complexity

Conditions	2
Paths	2

Size

Total Lines	12
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	OrderRepository::getOrderPaymentMethodModel()	0	3	1
A	OrderRepository::getOrderSendingMethodModel()	0	3	1

<?php
namespace Hideyo\Ecommerce\Framework\Services\Order\Entity;
 
use Hideyo\Ecommerce\Framework\Services\Order\Entity\Order;
use Hideyo\Ecommerce\Framework\Services\Order\Entity\OrderProduct;
use Hideyo\Ecommerce\Framework\Services\Order\Entity\OrderAddress;
use Hideyo\Ecommerce\Framework\Services\Order\Entity\OrderSendingMethod;
use Hideyo\Ecommerce\Framework\Services\Order\Entity\OrderPaymentMethod;
use DB;

The type DB was not found. Maybe you did not declare it correctly or list all dependencies?

use Carbon\Carbon;

The type Carbon\Carbon was not found. Maybe you did not declare it correctly or list all dependencies?

use Hideyo\Ecommerce\Framework\Services\BaseRepository;
 
class OrderRepository extends BaseRepository 
{
    protected $model;

    public function __construct(
        Order $model,
        OrderProduct $modelOrderProduct,
        OrderAddress $modelOrderAddress,
        OrderSendingMethod $modelOrderSendingMethod,
        OrderPaymentMethod $modelOrderPaymentMethod
    ) {
        $this->model = $model;
        $this->modelOrderProduct = $modelOrderProduct;

The property modelOrderProduct does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->modelOrderAddress = $modelOrderAddress;

The property modelOrderAddress does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->modelOrderSendingMethod = $modelOrderSendingMethod;

The property modelOrderSendingMethod does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $this->modelOrderPaymentMethod = $modelOrderPaymentMethod;

The property modelOrderPaymentMethod does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

    }
  
    public function getProductModel()
    {
        return $this->modelOrderProduct;
    }

    public function getAddressModel()
    {
        return $this->modelOrderAddress;
    }

    public function getOrderSendingMethodModel()
    {
        return $this->modelOrderSendingMethod;
    }

    public function getOrderPaymentMethodModel()
    {
        return $this->modelOrderPaymentMethod;
    }

    public function selectAllByShopIdAndStatusId($orderStatusId, $startDate = false, $endDate = false, $shopId = false)

The parameter $shopId is not used and could be removed.

    {
        $query = $this->model
        ->where('shop_id', '=', auth('hideyobackend')->user()->selected_shop_id)

The function auth was not found. Maybe you did not declare it correctly or list all dependencies?

        ->where('order_status_id', '=', $orderStatusId);

        if ($startDate) {
            $dt = Carbon::createFromFormat('d/m/Y', $startDate);
            $query->where('created_at', '>=', $dt->toDateString('Y-m-d'));
        }

        if ($endDate) {
            $dt = Carbon::createFromFormat('d/m/Y', $endDate);
            $query->where('created_at', '<=', $dt->toDateString('Y-m-d'));
        }

        $query->orderBy('created_at', 'ASC');
        return $query->get();
    }

    public function selectAllByAllProductsAndProductCategoryId($productCategoryId)
    {
        return $this->model->select('extra_field.*')->leftJoin('product_category_related_extra_field', 'extra_field.id', '=', 'product_category_related_extra_field.extra_field_id')->where('all_products', '=', 1)->orWhere('product_category_related_extra_field.product_category_id', '=', $productCategoryId)->get();
    }

    public function orderProductsByClientId($clientId, $shopId)
    {
        return $this->modelOrderProduct->with(array('product'))->whereHas('Order', function ($query) use ($clientId, $shopId) {
            $query->where('client_id', '=', $clientId)->where('shop_id', '=', $shopId);
        });
    }

    public function selectAllByCompany()
    {
        return $this->model->leftJoin('shop', 'order.shop_id', '=', 'shop.id')->get();
    }

    public function productsByOrderIds(array $orderIds) 
    {
        $result = DB::table('order_product')
        ->select(DB::raw('DISTINCT(CONCAT_WS(\' - \',order_product.title, IFNULL(order_product.product_attribute_title, \'\'))) as title, order_product.product_attribute_title, order_product.reference_code, order_product.price_with_tax, order_product.price_without_tax,  SUM(order_product.amount) as total_amount'))
        ->whereIn('order_product.order_id', $orderIds)
        ->whereNotNull('order_product.product_attribute_title')
        ->groupBy('order_product.title', 'order_product.product_attribute_title')
        ->get();


        $result2 = DB::table('order_product')
        ->select(DB::raw('DISTINCT(order_product.title) as title, order_product.product_attribute_title, order_product.reference_code, order_product.price_with_tax, order_product.price_without_tax,  SUM(order_product.amount) as total_amount'))
        ->whereIn('order_product.order_id', $orderIds)
        ->whereNull('order_product.product_attribute_title')
        ->groupBy('order_product.title', 'order_product.product_attribute_title')
        ->get();

        $result = array_merge($result, $result2);
        return $result;
    }
}