Viewing file:  VendorDashboardReportService.php (14.25 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/**
* @package VendorDashboardReportService
* @author TechVillage <support@techvill.org>
* @contributor Muhammad AR Zihad <[zihad.techvill@gmail.com]>
* @contributor Al Mamun <[almamun.techvill@gmail.com]>
* @created 19-04-2022
*/
namespace App\Services\Reports;
use App\Traits\ApiResponse;
use Illuminate\Support\Facades\DB;
use Modules\Refund\Entities\Refund;
use App\Models\{
Brand,
Product, Order, OrderDetail, OrderStatus,
Review, User, Wallet
};
class VendorDashboardReportService
{
use ApiResponse, ReportHelperTrait;
/**
* Stores vendor id
*/
private $vendorId = null;
/**
* Calculates total orders in last 30 days
*
* @param string|null $key
* @return DashboardReportService | array
*/
public function thisMonthOrdersCount($key = 'thisMonthOrdersCount', $returnSelf = true)
{
if ($key == '') {
$key = 'thisMonthOrdersCount';
}
$total = OrderDetail::select('vendor_id', 'order_id', DB::raw('concat("v-", vendor_id, "o-", order_id) as vendor_order'))
->join('orders', 'orders.id', 'order_details.order_id')
->where('orders.order_date', '>=', $this->offsetDate("-30"))
->whereVendorId($this->getVendorId())
->groupBy('order_id')
->get()->count();
return $this->complete($total, $key, $returnSelf);
}
/**
* Compare this month orders count against last month orders count
*
* @param string|null $key
* @return DashboardReportService
*/
public function thisMonthOrdersCompare($key = 'thisMonthOrdersCompare')
{
$totalLastMonth = OrderDetail::join('orders', 'orders.id', 'order_details.order_id')
->where('orders.order_date', '>=', $this->offsetDate('-60'))
->where('orders.order_date', '<', $this->offsetDate('-30'))
->whereVendorId($this->getVendorId())
->groupBy('order_id', 'vendor_id')
->get()
->count();
$totalThisMonth = $this->getValue('thisMonthOrdersCount') ?? $this->thisMonthOrdersCount('', false);
return $this->complete($this->growthRate($totalThisMonth, $totalLastMonth), $key);
}
/**
* Calculates total sales in last 30 days
*
* @param string|null $key
* @return DashboardReportService
*/
public function thisMonthSalesCount($key = 'thisMonthSales', $returnSelf = true)
{
if ($key == '') {
$key = 'thisMonthSales';
}
$total = OrderDetail::whereVendorId($this->getVendorId())
->leftJoin('orders', 'orders.id', '=', 'order_details.order_id')
->where('orders.order_date', '>=', $this->offsetDate("-30"))
->where('orders.payment_status', 'Paid')
->whereLike('orders.payment_status', 'Paid')
->sum(DB::raw('order_details.price * order_details.quantity'));
return $this->complete($total, $key, $returnSelf);
}
/**
* Compare this month sales count against last month sales count
*
* @param string|null $key
* @return DashboardReportService
*/
public function thisMonthSalesCompare($key = 'thisMonthSalesCompare')
{
$totalLastMonth = OrderDetail::join('orders', 'orders.id', 'order_details.order_id')
->where('orders.order_date', '>=', $this->offsetDate('-60'))
->where('orders.order_date', '<', $this->offsetDate('-30'))
->whereVendorId($this->getVendorId())
->sum(DB::raw('price * quantity'));
$totalThisMonth = $this->getValue('thisMonthSales') ?? $this->thisMonthSalesCount('', false);
return $this->complete($this->growthRate($totalThisMonth, $totalLastMonth), $key);
}
/**
* Finds the most sold products in last 30 days
*
* @param string|null $key
* @return DashboardReportService
*/
public function mostSoldProducts($key = 'mostSoldProducts')
{
$products = OrderDetail::select('id', 'product_id', 'parent_id', 'product_name', 'quantity', DB::raw('sum(quantity) as total'))
->with('product:id,code')->has('product')->whereHas('order', function ($q) {
$q->where('order_date', '>=', $this->offsetDate("-30"));
})
->whereVendorId($this->getVendorId())
->groupBy('product_name')
->orderBy('total', 'desc')
->get()
->map(function ($orderDetail) {
if ($orderDetail->parent_id) {
$code = $orderDetail?->parentProduct?->code;
} else {
$code = $orderDetail?->product?->code;
}
return [
'name' => $orderDetail->product_name,
'total' => round($orderDetail->total, 5),
'url' => route('vendor.product.edit', ['code' => $code])
];
});
return $this->complete($products, $key);
}
/**
* Users with most orders by last 30 days
*
* @param string|null $key
* @return DashboardReportService
*/
public function mostActiveUsers($key = 'mostActiveUsers')
{
$users = Order::select('id', 'user_id', DB::raw('count(user_id) as total'))
->with('user:id,name')
->whereNotNull('user_id')
->where('order_date', '>=', $this->offsetDate('-60'))
->whereHas('orderDetails', function($q) {
$q->whereVendorId($this->getVendorId());
})
->groupBy('user_id')
->orderBy('total', 'desc')
->get()
->map(function ($order) {
return [
'name' => $order->user->name,
'total' => $order->total,
'profile' => route('users.edit', ['id' => $order->user_id])
];
});
return $this->complete($users, $key);
}
/**
* New products added into the system in last 30 days
*
* @param string|null $key
* @return DashboardReportService
*/
public function newProductsCount($key = 'newProducts', $returnSelf = true)
{
if ($key == '') {
$key = 'newProducts';
}
$count = Product::where('created_at', '>=', $this->offsetDate('-30'))->whereVendorId($this->getVendorId())->count();
return $this->complete($count, $key, $returnSelf);
}
/**
* Compare last month products count with this month products count
*
* @param string|null $key
* @return DashboardReportService
*/
public function newProductsCountCompare($key = 'newProductsCompare')
{
$totalLastMonth = Product::where('created_at', '>=', $this->offsetDate('-60'))->where('created_at', '<', $this->offsetDate('-60'))->whereVendorId($this->getVendorId())->count();
$totalThisMonth = $this->getValue('newProducts') ?? $this->newProductsCount('', false);
return $this->complete($this->growthRate($totalThisMonth, $totalLastMonth), $key);
}
/**
* New refund requests in last 30 days
*
* @param string|null $key
* @return DashboardReportService
*/
public function newRefundsCount($key = 'newRefunds', $returnSelf = true)
{
if ($key == '') {
$key = 'newRefunds';
}
$count = Refund::whereHas('orderDetail', function ($query) {
$query->whereVendorId($this->getVendorId());
})->where('created_at', '>=', $this->offsetDate('-30'))->count();
return $this->complete($count, $key, $returnSelf);
}
/**
* Compare last month refund requests count with this week refund requests count
*
* @param string|null $key
* @return DashboardReportService
*/
public function newRefundsCountCompare($key = 'newRefundsCompare')
{
$dates = $this->lastMonth();
$totalLastMonth = Refund::WhereHas('orderDetail', function ($query) {
$query->whereVendorId($this->getVendorId());
})->where('created_at', '>=', $this->offsetDate('-60'))
->where('created_at', '<', $this->offsetDate('-30'))->count();
$totalThisMonth = $this->getValue('newRefunds') ?? $this->newRefundsCount('', false);
return $this->complete($this->growthRate($totalThisMonth, $totalLastMonth), $key);
}
/**
* Review in last 30 days
*
* @param string|null $key
* @return DashboardReportService
*/
public function thisMonthReviews($key = 'newReviews', $returnSelf = true)
{
if ($key == '') {
$key = 'newReviews';
}
$count = Review::select('reviews.id', 'product_id', 'user_id')->whereHas('product', function ($query) {
$query->where('vendor_id', auth()->user()->vendor()->vendor_id);
})->where('created_at', '>=', $this->offsetDate('-30'))->count();
return $this->complete($count, $key, $returnSelf);
}
/**
* Compare last month refund requests count with this week refund requests count
*
* @param string|null $key
* @return DashboardReportService
*/
public function thisMonthReviewCompare($key = 'newReviewsCompare')
{
$dates = $this->lastMonth();
$totalLastMonth = Review::select('reviews.id', 'product_id', 'user_id', 'reviews.status')->whereHas('product', function ($query) {
$query->where('vendor_id', auth()->user()->vendor()->vendor_id);
})->where('created_at', '>=', $this->offsetDate('-60'))
->where('created_at', '<', $this->offsetDate('-30'))->count();
$totalThisMonth = $this->getValue('newReviews') ?? $this->complete('', false);
return $this->complete($this->growthRate($totalThisMonth, $totalLastMonth), $key);
}
/**
* Orders of different statuses
*
* @param string|null $key
* @return DashboardReportService
*/
public function orderStatusWithCount($key = 'orderStatus')
{
$data['status'] = $data['count'] = [];
OrderStatus::withCount(['orderDetails' => function ($q) {
$q->join('orders', 'orders.id', 'order_details.order_id')
->select(DB::raw('count(distinct(order_id))'))
->where('vendor_id', $this->getVendorId())
->where('orders.order_date', '>=', $this->offsetDate('-30'));
}])->get()
->map(function ($order) use (&$data) {
$data['status'][] = $order->name;
$data['count'][] = $order->order_details_count;
});
return $this->complete($data, $key);
}
/**
* Get single product details
*
* @param int $productId
* @param string|null $key
* @return DashboardReportService
*/
public function productDetails($productId, $key = 'productDetails')
{
$product = Product::firstWhere('id', $productId);
return $this->complete(view('admin.dashboxes.partials.product-details', compact('product'))->render(), $key);
}
/**
* Get single user details
*
* @param int $userId
* @param string|null $key
* @return DashboardReportService
*/
public function userDetails($userId, $key = 'userDetails')
{
$user = User::findOrFail($userId);
return $this->complete(view('admin.dashboxes.partials.user-pop', compact('user'))->render(), $key);
}
/**
* Get sales comparison
*
* @param string|null $key
* @return DashboardReportService
*/
public function salesOfTheMonth($key = 'salesComparison')
{
$range = $this->getDay($this->offsetDate());
$dates = range(1, 31);
$currentMonth = $this->getMonth($this->offsetDate());
$values[$currentMonth] = array_fill(0, $range - 1, 0);
$values[$currentMonth - 1] = array_fill(0, 31, 0);
$values[$currentMonth - 2] = array_fill(0, 31, 0);
OrderDetail::select('orders.id', 'order_date', DB::raw('sum(price * quantity) as total'))
->join('orders', 'orders.id', 'order_details.order_id')
->where('order_date', '>=', $this->offsetDate('-' . 60 + $range - 1))
->where('order_date', '<', $this->tomorrow())
->whereVendorId($this->getVendorId())
->groupBy('order_date')
->get()
->map(function ($sale) use (&$values, $currentMonth) {
$month = $this->getMonth($sale->order_date);
if ($currentMonth < 3 && $month > 10) {
$month -= 12;
}
$values[$month][$this->getDay($sale->order_date) - 1] = $sale->total;
});
return $this->complete([
'dates' => $dates,
'values' => $values,
'thisMonth' => date('M Y')
], $key);
}
/**
* Get vendor wallet balance
*
* @param string|null $key
* @return DashboardReportService
*/
public function walletBalances($key = 'walletBalances')
{
$balance = Wallet::select('balance', 'currency_id')->where('user_id', auth()->id())->with('currency:id,name,symbol')->get();
return $this->complete($balance, $key);
}
/**
* Get top selling brands
*
* @param string|null $key
* @return DashboardReportService
*/
public function topSoldBrands($key = 'topSoldBrands')
{
$brands = Brand::join('products', 'products.brand_id', 'brands.id')
->select('brands.id', 'brands.name', DB::raw('count(products.brand_id) as total'))
->where('products.vendor_id', $this->getVendorId())
->where('products.total_sales', '>', 0)
->orderBy('total', 'desc')->take($this->getLimit())
->groupBy('products.brand_id')
->get()
->map(function ($q) {
return [
'name' => $q->name,
'total' => $q->total ?? 0,
'url' => ''
];
});
return $this->complete($brands, $key);
}
}
|