@extends('layouts.master') @section('title') billing @endsection @section('css')
<link href="{{URL::asset('assets/js/datatables/datatables.min.css')}}" rel="stylesheet" type="text/css" />
<link href="{{URL::asset('assets/css/datatable-custom.css')}}" rel="stylesheet" type="text/css" />
<style>
   .striped {
   background-color: #f7f8fc !important;
   }
</style>
@endsection @section('content') 
{{-- @component('components.breadcrumb') @slot('li_1') Dashboard @endslot @slot('title') Finance @endslot @endcomponent --}}
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
   <h4 class="mb-sm-0 font-size-18">Finance</h4>
   <div class="page-title-right">
      <ol class="breadcrumb m-0">
         <li class="breadcrumb-item"><a>Crm</a></li>
         <li class="breadcrumb-item active"><a href="{{ route('billing.index') }}">Finance</a></li>
      </ol>
   </div>
</div>
<div class="dashboard-widget-container mb-3">
   <!-- Dashboard Title -->
   <div class="mb-2">
      <div class="d-flex align-items-center">
         <i class="ri-wallet-3-line fs-3 text-primary me-2"></i>
         <h2 class="h5 text-uppercase fw-bold mb-0">
            <span class="text-gradient">PAYMENTS</span> 
            <span class="text-muted">OVERVIEW</span>
         </h2>
      </div>
   </div>
   <!-- Bootstrap Grid Row with Controlled Gaps -->
   <div class="row g-2">
      <!-- This Month Payments -->
      <div class="col-6 col-md-3">
         <div class="widget-card payments-card smart-card h-100">
            <div class="widget-header">
               <h3 class="widget-title">{{ date('F') }} Payments</h3>
               <i class="ri-bank-card-line widget-icon text-info"></i>
            </div>
            <div class="widget-content">
               <div class="widget-main-value">
                  <span>{{ $transactions[0]->deposit_sum ?? '0' }}</span>
               </div>
               <div class="widget-icon-small">
                  <i class="ri-bank-card-line text-info"></i>
               </div>
            </div>
            <!-- <a href="#" class="widget-footer">
               View <i class="ri-arrow-right-line"></i>
               </a> -->
         </div>
      </div>
      <!-- M-Pesa Payments -->
      <div class="col-6 col-md-3">
         <div class="widget-card mpesa-card smart-card h-100">
            <div class="widget-header">
               <h3 class="widget-title">M-Pesa Payments</h3>
               <i class="ri-exchange-funds-line widget-icon text-success"></i>
            </div>
            <div class="widget-content">
               <div class="widget-main-value">
                  <span>{{ $mpesa[0]->sum ?? '0' }}</span>
               </div>
               <div class="widget-icon-small">
                  <i class="ri-exchange-funds-line text-success"></i>
               </div>
            </div>
            <!-- <a href="#" class="widget-footer">
               View <i class="ri-arrow-right-line"></i>
               </a> -->
         </div>
      </div>
      <!-- Other Payments -->
      <div class="col-6 col-md-3">
         <div class="widget-card other-card smart-card h-100">
            <div class="widget-header">
               <h3 class="widget-title">Other Payments</h3>
               <i class="ri-hand-coin-line widget-icon text-warning"></i>
            </div>
            <div class="widget-content">
               <div class="widget-main-value">
                  <span>{{ ($transactions[0]->deposit_sum ?? 0) - ($mpesa[0]->sum ?? 0) }}</span>
               </div>
               <div class="widget-icon-small">
                  <i class="ri-hand-coin-line text-warning"></i>
               </div>
            </div>
            <!-- <a href="#" class="widget-footer">
               View <i class="ri-arrow-right-line"></i>
               </a> -->
         </div>
      </div>
      <!-- Paid Services -->
      <div class="col-6 col-md-3">
         <div class="widget-card services-card smart-card h-100">
            <div class="widget-header">
               <h3 class="widget-title">Paid Services</h3>
               <i class="ri-service-line widget-icon text-danger"></i>
            </div>
            <div class="widget-content">
               <div class="widget-main-value">
                  <span>{{ abs($transactions[0]->withdraw_sum ?? 0) }}</span>
               </div>
               <div class="widget-icon-small">
                  <i class="ri-service-line text-danger"></i>
               </div>
            </div>
            <!-- <a href="#" class="widget-footer">
               View <i class="ri-arrow-right-line"></i>
               </a> -->
         </div>
      </div>
   </div>
</div>
<div class="row g-3 mb-3">
    @foreach($growth as $key => $value)
    <div class="col-xl-4 col-md-4 col-12">
        <div class="card card-hover border-0 shadow-sm h-100">
            <div class="card-header bg-transparent border-0 pb-0 d-flex align-items-center mb-2">
                <h4 class="card-title mb-0 text-primary">{{ $value->months }}</h4>
            </div>
            
            <div class="card-body pt-1 pb-0">
                <div class="d-flex flex-column gap-2">
                    <!-- Payments -->
                    <div class="d-flex align-items-center justify-content-between p-3 bg-light rounded">
                        <div>
                            <p class="text-muted mb-1 small">Payments</p>
                            <h5 class="mb-0 text-info">{{ $value->deposit_sum }} Ksh</h5>
                        </div>
                        <i class="ri-wallet-3-line text-info fs-4"></i>
                    </div>
                    
                    <!-- Paid Services -->
                    <div class="d-flex align-items-center justify-content-between p-3 bg-light rounded">
                        <div>
                            <p class="text-muted mb-1 small">Paid Services</p>
                            <h5 class="mb-0">{{ abs($value->withdraw_sum) }} Ksh</h5>
                        </div>
                        <i class="ri-bill-line text-primary fs-4"></i>
                    </div>
                    
                    <!-- Growth -->
                    <div class="d-flex align-items-center justify-content-between p-3 bg-light rounded">
                        <div>
                            <p class="text-muted mb-1 small">Growth</p>
                            @if($key == 0)
                                <h5 class="mb-0">base</h5>
                            @else
                                @php
                                $previous = $growth[$key-1];
                                $previous_month_sum = $previous->deposit_sum - $previous->withdraw_sum;
                                $current_month_sum = $value->deposit_sum - $value->withdraw_sum;
                                $growth_percentage = ($previous_month_sum != 0) ? 
                                    (($current_month_sum - $previous_month_sum) / abs($previous_month_sum)) * 100 : 0;
                                @endphp
                                @if($growth_percentage > 0)
                                <h5 class="mb-0 text-success"><i class="ri-arrow-up-fill align-middle"></i> {{ number_format($growth_percentage, 2) }}%</h5>
                                @elseif($growth_percentage < 0)
                                <h5 class="mb-0 text-danger"><i class="ri-arrow-down-fill align-middle"></i> {{ number_format(abs($growth_percentage), 2) }}%</h5>
                                @else
                                <h5 class="mb-0">No Change</h5>
                                @endif
                            @endif
                        </div>
                        <i class="ri-line-chart-line fs-4 text-warning"></i>
                    </div>
                </div>
            </div>
        </div>
    </div>
    @endforeach
</div>
<div class="row">
   <div class="col-md-6">
      <div style="width: 100%; height: 400px;" class="card">
         <div class="card-header">
            Monthly Transactions (graph)
         </div>
         <div class="card-body">
            <canvas id="myChart"></canvas>
         </div>
      </div>
   </div>
   <div class="col-md-6">
      <div style="width: 100%; height: 400px;" class="card">
         <div class="card-header">
            Top 5 Payers
         </div>
         <div class="card-body">
            <canvas id="pie-chart"></canvas>
         </div>
      </div>
   </div>
</div>
{{-- 
<div class="row">
   <div class="col-md-12">
      <div style="width: 100%; height: 400px;" class="card">
         <div class="card-header">
            Revenue growth (graph)
         </div>
         <div class="card-body">
            <canvas id="revenueChart"></canvas>
         </div>
      </div>
   </div>
</div>
--}}
<!--end row-->
@endsection 
@section('script')
<script src="{{ URL::asset('/assets/js/jquery-3.6.1.js')}}"></script>
{{-- <script src="{{ URL::asset('/assets/js/datatables/datatables.min.js') }}"></script> --}}
<script src="{{ URL::asset('/assets/js/app.min.js') }}"></script>
{{-- <script src="{{ URL::asset('/assets/js/datatable.js') }}"></script>  --}}
{{-- <script src="https://cdn.jsdelivr.net/npm/chart.js"></script> --}}
<script src="https://cdn.jsdelivr.net/npm/chart.js@3.7.0/dist/chart.min.js"></script>
<script>
   var months = {!! json_encode($growth->pluck('months')) !!};
   var depositSums = {!! json_encode($growth->pluck('deposit_sum')) !!};
   var withdrawSums = {!! json_encode($growth->pluck('withdraw_sum')->map(function($value) { return abs($value); })) !!};
   
   var ctx = document.getElementById('myChart').getContext('2d');
   var chart = new Chart(ctx, {
     type: 'bar',
     data: {
       labels: months,
       datasets: [
         {
           label: 'Payments',
           data: depositSums,
           backgroundColor: 'rgba(0, 128, 0, 0.5)',
           borderColor: 'rgba(0, 128, 0, 1)',
           borderWidth: 1
         },
         {
           label: 'Service paid',
           data: withdrawSums,
           backgroundColor: 'rgba(255, 0, 0, 0.5)',
           borderColor: 'rgba(255, 0, 0, 1)',
           borderWidth: 1
         }
       ]
     },
     options: {
       plugins: {
         legend: {
           display: true,
           position: 'top'
         }
       },
       scales: {
         y: {
           title: {
             display: true,
             text: 'Amount (KSH)'
           },
           suggestedMin: 0
         },
         x: {
           title: {
             display: true,
             text: 'Month'
           }
         }
       },
       aspectRatio: false
     }
   });
</script>
<script>
   var topUsers = {!! json_encode($topUsers) !!};
   
   var labels = [];
   var data = [];
   var backgroundColor = [
   '#FF6384',
   '#36A2EB',
   '#6C0BA9',
   '#5cb85c',
   '#f0ad4e'
   ];
   
   // Loop through the top users and add data for users with non-zero transactions_sum_amount
   topUsers.forEach(function(user) {
   if(user.transactions_sum_amount > 0) {
       labels.push(user.firstname);
       data.push(user.transactions_sum_amount);
   }
   });
   
   var chartData = {
   labels: labels,
   datasets: [{
       data: data,
       backgroundColor: backgroundColor
   }]
   };
   
   var options = {
   responsive: true,
   maintainAspectRatio: false,
   tooltips: {
       callbacks: {
           label: function(tooltipItem, data) {
               var value = data.datasets[0].data[tooltipItem.index];
               return "Ksh " + value.toFixed(2);
           }
       }
   },
   legend: {
       position: 'bottom'
   }
   };
   
   var pieChart = new Chart(document.getElementById('pie-chart'), {
   type: 'pie',
   data: chartData,
   options: options
   });
</script>
@endsection