@extends('layouts.app')
@section('title', __('app.dashboard'))

		@section('content')
		<!--start page wrapper -->
		<div class="page-wrapper">
			<div class="page-content">

                @can('dashboard.can.view.widget.cards')
				<div class="row row-cols-1 row-cols-md-4 row-cols-xl-4 mb-3">
                   <div class="col">
					 <div class="card h-100 radius-10 border-start border-0 border-4 border-info">
						<div class="card-body">
							<div class="d-flex align-items-center">
								<div>
									<p class="mb-0 text-secondary">Today Sale (Net)</p>
									<h4 class="my-1 text-info">{{ $todaySale }}</h4>
								</div>
								<div class="widgets-icons-2 rounded-circle bg-gradient-blues text-white ms-auto flex-shrink-0"><i class='bx bxs-cart'></i>
								</div>
							</div>
						</div>
					 </div>
				   </div>
				   <div class="col">
					<div class="card h-100 radius-10 border-start border-0 border-4 border-success">
					   <div class="card-body">
						   <div class="d-flex align-items-center">
							   <div>
								   <p class="mb-0 text-secondary">Customer Due Payments</p>
									<h4 class="my-1 text-success">{{ $totalReceivable }}</h4>
							   </div>
							   <div class="widgets-icons-2 rounded-circle bg-gradient-ohhappiness text-white ms-auto flex-shrink-0"><i class='bx bx-wallet' ></i>
							   </div>
						   </div>
					   </div>
					</div>
				  </div>
				   <div class="col">
					<div class="card h-100 radius-10 border-start border-0 border-4 border-warning">
					   <div class="card-body">
						   <div class="d-flex align-items-center">
							   <div class="flex-grow-1">
								   <p class="mb-1 text-secondary">Supplier Balances</p>
                                   <div class="d-flex align-items-center gap-2 mt-1">
                                       <div>
                                           <h4 class="my-0 text-danger fw-bold" style="font-size: 1.15rem; line-height: 1;">{{ $supplierBalances['payable'] }}</h4>
                                           <small class="text-muted d-block" style="font-size: 0.72rem; margin-top: 2px;">To Pay</small>
                                       </div>
                                       <div class="border-start mx-1" style="height: 25px; border-left: 1px solid #dee2e6 !important;"></div>
                                       <div>
                                           <h4 class="my-0 text-success fw-bold" style="font-size: 1.15rem; line-height: 1;">{{ $supplierBalances['receivable'] }}</h4>
                                           <small class="text-muted d-block" style="font-size: 0.72rem; margin-top: 2px;">To Receive</small>
                                       </div>
                                   </div>
							   </div>
							   <div class="widgets-icons-2 rounded-circle bg-gradient-orange text-white ms-auto flex-shrink-0"><i class='bx bxs-user-detail'></i>
							   </div>
						   </div>
					   </div>
					</div>
				  </div>
				   <div class="col">
					<div class="card h-100 radius-10 border-start border-0 border-4 border-primary">
					   <div class="card-body">
						   <div class="d-flex align-items-center">
							   <div>
								   <p class="mb-0 text-secondary">Today Purchase (Net)</p>
									<h4 class="my-1 text-primary">{{ $todayPurchase }}</h4>
							   </div>
							   <div class="widgets-icons-2 rounded-circle bg-gradient-moonlit text-white ms-auto flex-shrink-0"><i class='bx bxs-archive-in'></i>
							   </div>
						   </div>
					   </div>
					</div>
				  </div>
				</div><!--end row-->
				<div class="row row-cols-1 row-cols-md-2 row-cols-xl-4 mb-3">
                   <div class="col">
					<div class="card h-100 radius-10 border-start border-0 border-4 border-danger">
					   <div class="card-body">
						   <div class="d-flex align-items-center">
							   <div>
								   <p class="mb-0 text-secondary">This Month Expense</p>
									<h4 class="my-1 text-danger">{{ $thisMonthExpense }}</h4>
							   </div>
							   <div class="widgets-icons-2 rounded-circle bg-gradient-burning text-white ms-auto flex-shrink-0"><i class='bx bxs-minus-circle'></i>
							   </div>
						   </div>
					   </div>
					</div>
				  </div>
				   <div class="col">
					<div class="card h-100 radius-10 border-start border-0 border-4 border-info">
					   <div class="card-body">
						   <div class="d-flex align-items-center">
							   <div>
								   <p class="mb-0 text-secondary">Total Stock</p>
									<h4 class="my-1 text-info">{{ $totalStock }}</h4>
							   </div>
							   <div class="widgets-icons-2 rounded-circle bg-gradient-blues text-white ms-auto flex-shrink-0"><i class='bx bxs-box' ></i>
							   </div>
						   </div>
					   </div>
					</div>
				  </div>
				   <div class="col">
					<div class="card h-100 radius-10 border-start border-0 border-4 border-primary">
					   <div class="card-body">
						   <div class="d-flex align-items-center">
							   <div>
								   <p class="mb-0 text-secondary">Total Stock Worth</p>
									<h4 class="my-1 text-primary">{{ $totalStockWorth }}</h4>
							   </div>
							   <div class="widgets-icons-2 rounded-circle bg-gradient-moonlit text-white ms-auto flex-shrink-0"><i class='bx bxs-wallet'></i>
							   </div>
						   </div>
					   </div>
					</div>
				  </div>
				  <div class="col">
					<div class="card h-100 radius-10 border-start border-0 border-4 border-warning">
					   <div class="card-body">
						   <div class="d-flex align-items-center">
							   <div>
								   <p class="mb-0 text-secondary">Today Return</p>
									<h4 class="my-1 text-warning">{{ $todayReturn }}</h4>
							   </div>
							   <div class="widgets-icons-2 rounded-circle bg-gradient-orange text-white ms-auto flex-shrink-0"><i class='bx bxs-share' ></i>
							   </div>
						   </div>
					   </div>
					</div>
				  </div>
				</div><!--end row-->
                @endcan
				<div class="row">
                    @can('dashboard.can.view.sale.vs.purchase.bar.chart')
                   <div class="col-12 col-lg-8 d-flex">
                      <div class="card radius-10 w-100">
						<div class="card-header">
							<div class="d-flex align-items-center">
								<div>
									<h6 class="mb-0">{{ __('sale.sale_vs_purchase') }}</h6>
								</div>
							</div>
						</div>
						  <div class="card-body">
							<div class="d-flex align-items-center ms-auto font-13 gap-2 mb-3">
								<span class="border px-1 rounded cursor-pointer"><i class="bx bxs-circle me-1" style="color: #ffc107"></i>{{ __('purchase.purchase_bills') }}</span>
								<span class="border px-1 rounded cursor-pointer"><i class="bx bxs-circle me-1" style="color: #14abef"></i>{{ __('sale.sale_invoices') }}</span>
							</div>
							<div class="chart-container-1">
								<canvas id="chart1"></canvas>
							</div>
						  </div>
					  </div>
				   </div>
                   @endcan
                   @can('dashboard.can.view.trending.items.pie.chart')
				   <div class="col-12 col-lg-4 d-flex">
                       <div class="card radius-10 w-100">
						<div class="card-header">
							<div class="d-flex align-items-center">
								<div>
									<h6 class="mb-0">{{ __('item.trending') }}</h6>
								</div>
							</div>
						</div>
						   <div class="card-body">
							<div class="chart-container-2">
								<canvas id="chart2"></canvas>
							  </div>
						   </div>
						   <ul class="list-group list-group-flush">
								@foreach($trendingItems as $item)
								  <li class="list-group-item d-flex bg-transparent justify-content-between align-items-center border-top">
								    {{ $item['name'] }}
								    <span class="badge bg-success rounded-pill">{{ $formatNumber->formatQuantity($item['total_quantity']) }}</span>
								  </li>
								@endforeach
						</ul>
					   </div>
				   </div>
                   @endcan
				</div><!--end row-->

                @can('dashboard.can.view.recent.invoices.table')
				 <div class="card radius-10">
					<div class="card-header">
						<div class="d-flex align-items-center">
							<div>
								<h6 class="mb-0">{{ __('sale.recent_invoices') }}</h6>
							</div>
                            @can('sale.invoice.view')
                            <div class="font-13 ms-auto">
                                <a href="{{ route('sale.invoice.list') }}" class="btn btn-sm btn-outline-primary">{{ __('app.view_all') }}</a>
                            </div>
                            @endcan
						</div>
					</div>
                    <div class="card-body">
                        <div class="table-responsive">
                        <table class="table align-middle mb-0">
                            <thead class="table-light">
                            <tr>
                                <th>{{ __('sale.invoice_date') }}</th>
                                <th>{{ __('sale.code') }}</th>
                                <th>{{ __('customer.name') }}</th>
                                <th>{{ __('app.grand_total') }}</th>
                                <th>{{ __('app.balance') }}</th>
                                <th>{{ __('app.status') }}</th>
                            </tr>
                            </thead>
                            <tbody>
                                @foreach($recentInvoices as $recent)

                                        <tr>
                                            <td>{{ $recent->formatted_sale_date }}</td>
                                            <td>{{ $recent->sale_code }}</td>
                                            <td>{{ $recent->party->getFullName() }}</td>
                                            <td class="">{{ $formatNumber->formatWithPrecision($recent->grand_total) }}</td>
                                            <td class="">{{ $formatNumber->formatWithPrecision($recent->grand_total - $recent->paid_amount) }}</td>

                                            @php
                                                $returnTotal = $recent->saleReturn->sum('grand_total');
                                                if($returnTotal > 0){
                                                    $class = 'info';
                                                    $message = ($returnTotal >= $recent->grand_total) ? 'Returned' : 'Partial Return';
                                                } else if($recent->paid_amount > 0 && $recent->paid_amount < $recent->grand_total){
                                                    $class = 'warning';
                                                    $message = 'Partial';
                                                } else if($recent->paid_amount >= $recent->grand_total){
                                                    $class = 'success';
                                                    $message = 'Paid';
                                                }else{
                                                    $class = 'danger';
                                                    $message = 'Unpaid';
                                                }
                                            @endphp

                                            <td class=""><div class="badge rounded-pill text-{{ $class }} bg-light-{{ $class }} p-2 text-uppercase px-3">{{ $message }}</div></td>
                                        </tr>

                                @endforeach
                            </tbody>
                        </table>
                        </div>
                    </div>
                </div>
                @endcan

                @can('dashboard.can.view.low.stock.items.table')
				 <div class="card radius-10">
					<div class="card-header">
						<div class="d-flex align-items-center">
							<div>
								<h6 class="mb-0">{{ __('item.low_stock_items') }}</h6>
							</div>
                            @can('item.view')
                            <div class="font-13 ms-auto">
                                <a href="{{ route('item.list') }}" class="btn btn-sm btn-outline-primary">{{ __('app.view_all') }}</a>
                            </div>
                            @endcan
						</div>
					</div>
                    <div class="card-body">
                        <div class="table-responsive">
                        <table class="table align-middle mb-0">
                            <thead class="table-light">
                                <tr class="text-uppercase">
                                    <th>#</th>
                                    <th>{{ __('item.item_name') }}</th>
                                    <th>{{ __('item.brand.brand') }}</th>
                                    <th>{{ __('item.category.category') }}</th>
                                    <th>{{ __('item.min_stock') }}</th>
                                    <th>{{ __('item.current_stock') }}</th>
                                    <th>{{ __('unit.unit') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php $i = 1; @endphp
                                @foreach($lowStockItems as $item)
                                        <tr>
                                            <td>{{ $i++ }}</td>
                                            <td>{{ $item->name }}</td>
                                            <td>{{ $item->brand->name??'' }}</td>
                                            <td>{{ $item->category->name }}</td>
                                            <td class="">{{ $formatNumber->formatQuantity($item->min_stock) }}</td>
                                            <td class="text-danger fw-bold">{{ $formatNumber->formatQuantity($item->current_stock) }}</td>
                                            <td>{{ $item->baseUnit->name }}</td>
                                        </tr>

                                @endforeach
                            </tbody>
                        </table>
                        </div>
                    </div>
                </div>
                @endcan



				<div class="row">
					<div class="col-12">
						<div class="card radius-10">
							<div class="card-body">
								<div class="d-flex align-items-center">
									<div>
										<h6 class="mb-0">System Health & Reliability</h6>
									</div>
								</div>
								<hr>
								<div class="row">
									<div class="col-md-3 text-center">
										<p class="mb-0 text-secondary">Free Disk Space</p>
										<h5 class="my-1 text-primary">{{ $systemHealth['disk_free'] }}</h5>
									</div>
									<div class="col-md-3 text-center border-start">
										<p class="mb-0 text-secondary">Last Backup</p>
										<h5 class="my-1 text-success">{{ $systemHealth['last_backup'] }}</h5>
									</div>
									<div class="col-md-3 text-center border-start">
										<p class="mb-0 text-secondary">Database Status</p>
										<h5 class="my-1 text-info">{{ $systemHealth['db_connection'] }}</h5>
									</div>
									<div class="col-md-3 text-center border-start">
										<p class="mb-0 text-secondary">PHP Version</p>
										<h5 class="my-1 text-secondary">{{ $systemHealth['php_version'] }}</h5>
									</div>
								</div>
							</div>
						</div>
					</div>
				</div>

			</div>
		</div>
		<!--end page wrapper -->
		@endsection

@section('js')
<script src="{{ versionedAsset('custom/js/dashboard.js') }}"></script>
<script src="{{ versionedAsset('custom/js/custom.js') }}"></script>
<script>
	/*Bar Chart Data*/
	var chartMonths = @json($saleVsPurchase).map(record => record.label);
	var chartSales = @json($saleVsPurchase).map(record => record.sales);
	var chartPurchases = @json($saleVsPurchase).map(record => record.purchases);

	/*Doughnut Chart Data*/
	var serviceNames = @json($trendingItems).map(x => x.name);
	var serviceCounts = @json($trendingItems).map(x => x.total_quantity);

</script>
@endsection