@extends('layouts.master') @section('css') @endsection @section('title') {{ __('home.home') }} @stop @section('page-header')

{{ __('home.welcome') }} {{ Auth()->User()->name }} !

لوحة المؤشرات والتقارير الإحصائية المباشرة
{{--
--}} @endsection @section('content') @can('Home')
{{-- ========================================================================= --}} {{-- 1. العمليات الحسابية وتجهيز البيانات (مطابقة 100% للمنطق الأصلي) --}} {{-- ========================================================================= --}} @php $avt = App\Models\Avt::find(1); $saleavt = $avt->AVT ?? 0.15; // 1. مبيعات اليوم $totalPriceToday = 0; $invoicesToday = App\Models\invoices::whereDate('created_at', date('Y-m-d'))->where('save', 1)->get(); foreach ($invoicesToday as $product) { $totalPriceToday += round($product->cashamount, 2) + round($product->bankamount, 2) + round($product->Bank_transfer, 2) + round($product->creaditamount, 2); } $Invoices_returnToday = App\Models\return_sales::whereDate('created_at', date('Y-m-d'))->get(); $valuewithoudtaxToday = 0; foreach ($Invoices_returnToday as $returnsale) { $valuewithoudtaxToday += ($returnsale->return_Unit_Price * $returnsale->return_quantity) - $returnsale->discountvalue - $returnsale->discountoninvoice; } $todayEarnings = round($totalPriceToday, 2) - round($valuewithoudtaxToday + $valuewithoudtaxToday * $saleavt, 2); // 2. مبيعات الشهر $invoicesMonth = App\Models\invoices::whereDate('created_at', '>=', date('Y-m') . '-1')->whereDate('created_at', '<=', date('Y-m-d '))->where('save', 1)->get(); $totalPriceMonth = 0; foreach ($invoicesMonth as $product) { $totalPriceMonth += round($product->cashamount, 2) + round($product->bankamount, 2) + round($product->Bank_transfer, 2) + round($product->creaditamount, 2); } $Invoices_returnMonth = App\Models\return_sales::whereDate('created_at', '>=', date('Y-m') . '-1')->whereDate('created_at', '<=', date('Y-m-d '))->get(); $valuewithoudtaxMonth = 0; foreach ($Invoices_returnMonth as $returnsale) { $valuewithoudtaxMonth += ($returnsale->return_Unit_Price * $returnsale->return_quantity) - $returnsale->discountvalue - $returnsale->discountoninvoice; } $monthEarnings = $totalPriceMonth - round($valuewithoudtaxMonth + $valuewithoudtaxMonth * $saleavt, 2); // 3. مشتريات اليوم $purchasesTodaySum = 0; foreach (App\Models\resource_purchases::whereDate('created_at', date('Y-m-d'))->where('save', 1)->get() as $invoice) { $purchasesTodaySum += $invoice->In_debt + ($invoice['shipping fee'] ?? 0); } // 4. مشتريات الشهر $purchasesMonthSum = 0; foreach (App\Models\resource_purchases::whereDate('created_at', '>=', date('Y-m') . '-1')->whereDate('created_at', '<=', date('Y-m-d '))->where('save', 1)->get() as $invoice) { $purchasesMonthSum += $invoice->In_debt + ($invoice['shipping fee'] ?? 0); } // 5. مديونيات الموردين والعملاء $creadit_customer_amount = 0; $credit_supplier_amount = 0; // نفس طريقة قائمة حسابات العملاء: صافي الحركات المسجلة (مدين - دائن) لكل حساب، // ثم جمع الأرصدة المدينة فقط لإظهار إجمالي المستحق تحصيله. $customerAccountIds = App\Models\financial_accounts::where('orginal_type', 1)->pluck('id'); $customerLedgerBalances = App\Models\credittransactions::where('save', 1) ->whereIn('customer_id', $customerAccountIds) ->select('customer_id') ->selectRaw('COALESCE(SUM(debtor), 0) as total_debit') ->selectRaw('COALESCE(SUM(creditor), 0) as total_credit') ->groupBy('customer_id') ->get(); $creadit_customer_amount = $customerLedgerBalances->sum(function ($balance) { return max((float) $balance->total_debit - (float) $balance->total_credit, 0); }); // نفس منطق العملاء، مع عكس اتجاه الرصيد للموردين: الدائن - المدين. $supplierAccountIds = App\Models\financial_accounts::where('orginal_type', 2)->pluck('id'); $supplierLedgerBalances = App\Models\credittransactions::where('save', 1) ->whereIn('customer_id', $supplierAccountIds) ->select('customer_id') ->selectRaw('COALESCE(SUM(debtor), 0) as total_debit') ->selectRaw('COALESCE(SUM(creditor), 0) as total_credit') ->groupBy('customer_id') ->get(); $credit_supplier_amount = $supplierLedgerBalances->sum(function ($balance) { return max((float) $balance->total_credit - (float) $balance->total_debit, 0); }); // 6. المرتجعات $returnSales = App\Models\return_sales::whereDate('created_at', '=', date("Y-m-d"))->get(); $resource_purchases = App\Models\resource_purchases::whereDate('created_at', '>=', date("Y-m-d"))->where('recoveredـpieces', '!=', 0)->get(); $returnsalseList = []; $resource_purchasesList = []; foreach ($returnSales as $sale) { if (!in_array($sale->invoice_id, $returnsalseList)) { $returnsalseList[] = $sale->invoice_id; } } foreach ($resource_purchases as $resource_purchase) { $resource_purchasesList[] = $resource_purchase->id; } @endphp {{-- ========================================================================= --}} {{-- 2. شبكة الكروت الإحصائية --}} {{-- ========================================================================= --}}

ملخص الأداء

نظرة سريعة على حركة المبيعات والمشتريات والأرصدة

مؤشرات محدثة
{{ __('home.salesdoday') }}

{{ App\Models\invoices::whereDate('created_at', date('Y-m-d'))->where('save',1)->count() }} {{ __('home.invoice') }}

اليوم الحالي
{{ __('home.TODAYEARNINGS') }}

{{ number_format($todayEarnings, 2) }} {{ __('home.SAR') }}

صافي الدخل اليومي
{{ __('home.PRODUCT_number_SOLD') }}

{{ App\Models\invoices::whereDate('created_at', '>=', date('Y-m') . '-1')->where('save',1)->whereDate('created_at', '<=', date('Y-m-d '))->count() }} {{ __('home.invoice') }}

خلال الشهر الحالي
{{ __('home.TOTAL_EARNINGS_Month') }}

{{ number_format($monthEarnings, 2) }} {{ __('home.SAR') }}

صافي دخل الشهر
{{ __('home.creadit_customer_amount') }}

{{ number_format($creadit_customer_amount, 2) }} {{ __('home.SAR') }}

عرض قائمة العملاء
{{ __('home.credit_supplier_amount') }}

{{ number_format($credit_supplier_amount, 2) }} {{ __('home.SAR') }}

عرض قائمة الموردين
{{ __('home.purchasesdoday') }}

{{ App\Models\resource_purchases::whereDate('created_at', date('Y-m-d'))->where('save',1)->count() }} {{ __('home.invoice') }}

فواتير الشراء اليومية
{{ __('home.TODAYpurchases') }}

{{ number_format($purchasesTodaySum, 2) }} {{ __('home.SAR') }}

إجمالي قيمة المشتريات اليوم
{{ __('home.purchases_number_SOLD') }}

{{ App\Models\resource_purchases::whereDate('created_at', '>=', date('Y-m') . '-1')->whereDate('created_at', '<=', date('Y-m-d '))->where('save',1)->count() }} {{ __('home.invoice') }}

فواتير الشراء خلال الشهر
{{ __('home.TOTAL_purchases_Month') }}

{{ number_format($purchasesMonthSum, 2) }} {{ __('home.SAR') }}

إجمالي تكلفة المشتريات الشهرية
{{ __('home.numberodreturnsSale') }}

{{ count($returnsalseList) }} {{ __('home.invoice') }}

مرتجع مبيعات اليوم
{{ __('home.numberodreturnsPurchases') }}

{{ count($resource_purchasesList) }} {{ __('home.invoice') }}

مرتجع مشتريات اليوم
{{-- ========================================================================= --}} {{-- 3. كارد الرسم البياني لمقارنة المبيعات والمشتريات --}} {{-- ========================================================================= --}} @php $currentYear = date('Y'); $salesChartMonthly = []; $purchasesChartMonthly = []; for ($m = 1; $m <= 12; $m++) { $startDate = sprintf('%s-%02d-01', $currentYear, $m); $endDate = ($m == 12) ? sprintf('%s-12-31 23:59:59', $currentYear) : sprintf('%s-%02d-01', $currentYear, $m + 1); $salesChartMonthly[] = App\Models\invoices::whereDate('created_at', '>=', $startDate)->whereDate('created_at', '<', $endDate)->count(); $purchasesChartMonthly[] = App\Models\resource_purchases::whereDate('created_at', '>=', $startDate)->whereDate('created_at', '<', $endDate)->count(); } $chartjs2 = app() ->chartjs->name('lineChartTest') ->type('line') ->size(['width' => 400, 'height' => 140]) ->labels(['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December']) ->datasets([ [ 'label' => __('home.sales'), 'backgroundColor' => 'rgba(16, 185, 129, 0.15)', 'borderColor' => '#10b981', 'pointBorderColor' => '#10b981', 'pointBackgroundColor' => '#ffffff', 'pointHoverBackgroundColor' => '#10b981', 'pointHoverBorderColor' => '#ffffff', 'data' => $salesChartMonthly, ], [ 'label' => __('home.purchases'), 'backgroundColor' => 'rgba(59, 130, 246, 0.15)', 'borderColor' => '#3b82f6', 'pointBorderColor' => '#3b82f6', 'pointBackgroundColor' => '#ffffff', 'pointHoverBackgroundColor' => '#3b82f6', 'pointHoverBorderColor' => '#ffffff', 'data' => $purchasesChartMonthly, ], ]) ->options([]); @endphp
حركة المبيعات والمشتريات خلال العام ({{ date('Y') }})

مقارنة عدد الفواتير شهريًا

{!! $chartjs2->render() !!}

الملخص المالي

أهم الأرقام خلال الفترة الحالية

صافي إيرادات الشهر {{ number_format($monthEarnings, 2) }} ر.س
مشتريات الشهر {{ number_format($purchasesMonthSum, 2) }} ر.س
مستحقات العملاء {{ number_format($creadit_customer_amount, 2) }} ر.س
مستحقات الموردين {{ number_format($credit_supplier_amount, 2) }} ر.س
تساعدك هذه النظرة على متابعة الإيرادات والمشتريات والأرصدة المستحقة بسرعة.
@endcan @endsection @section('js') @endsection