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

PATH: home / lab2454c / vaultchip.com / platform / plugins / ecommerce / src / Repositories / Eloquent

<?php

namespace Botble\Ecommerce\Repositories\Eloquent;

use Botble\Ecommerce\Repositories\Interfaces\OrderInterface;
use Botble\Payment\Enums\PaymentStatusEnum;
use Botble\Support\Repositories\Eloquent\RepositoriesAbstract;
use Illuminate\Support\Facades\DB;

class OrderRepository extends RepositoriesAbstract implements OrderInterface
{
    /**
     * {@inheritDoc}
     */
    public function getRevenueData($startDate, $endDate, $select = [])
    {
        if (empty($select)) {
            $select = [
                DB::raw('DATE(payments.created_at) AS date'),
                DB::raw('SUM(COALESCE(payments.amount, 0) - COALESCE(payments.refunded_amount, 0)) as revenue'),
            ];
        }
        $data = $this->model
            ->join('payments', 'payments.id', '=', 'ec_orders.payment_id')
            ->whereDate('payments.created_at', '>=', $startDate)
            ->whereDate('payments.created_at', '<=', $endDate)
            ->where('payments.status', PaymentStatusEnum::COMPLETED)
            ->groupBy('date')
            ->select($select);

return $this->applyBeforeExecuteQuery($data)->get();
    }

/**
     * {@inheritDoc}
     */
    public function countRevenueByDateRange($startDate, $endDate)
    {
        $data = $this->model
            ->join('payments', 'payments.id', '=', 'ec_orders.payment_id')
            ->whereDate('payments.created_at', '>=', $startDate)
            ->whereDate('payments.created_at', '<=', $endDate)
            ->where('payments.status', PaymentStatusEnum::COMPLETED);

return $this
            ->applyBeforeExecuteQuery($data)
            ->sum(DB::raw('COALESCE(payments.amount, 0) - COALESCE(payments.refunded_amount, 0)'));
    }
}

[-] ProductAttributeSetRepository.php [edit]
[-] ProductTagRepository.php [edit]
[-] ProductAttributeRepository.php [edit]
[-] ReviewRepository.php [edit]
[-] FlashSaleRepository.php [edit]
[+] ..
[-] OrderRepository.php [edit]
[-] CurrencyRepository.php [edit]
[-] ProductCollectionRepository.php [edit]
[-] TaxRepository.php [edit]
[-] ProductCategoryRepository.php [edit]
[-] OrderProductRepository.php [edit]
[-] ShipmentRepository.php [edit]
[-] ShippingRuleRepository.php [edit]
[-] ShipmentHistoryRepository.php [edit]
[-] WishlistRepository.php [edit]
[-] DiscountRepository.php [edit]
[-] OrderAddressRepository.php [edit]
[-] CustomerRepository.php [edit]
[-] AddressRepository.php [edit]
[-] ShippingRuleItemRepository.php [edit]
[-] OrderHistoryRepository.php [edit]
[-] ProductVariationItemRepository.php [edit]
[-] GroupedProductRepository.php [edit]
[-] StoreLocatorRepository.php [edit]
[-] BrandRepository.php [edit]
[-] ProductVariationRepository.php [edit]
[-] ProductRepository.php [edit]
[-] ProductLabelRepository.php [edit]
[-] ShippingRepository.php [edit]