@extends('layouts.layout')

@section('title', 'Dashboard')

@section('content')

<section class="content">
    <div class="container-fluid">
        <div class="block-header">
            <div class="row">
                <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                    <ul class="breadcrumb breadcrumb-style ">
                        <li class="breadcrumb-item bcrumb-1">
                            <a href=""><i class="fas fa-home"></i> Home</a>
                        </li>
                        <li class="breadcrumb-item active">Dashboard </li>
                    </ul>
                </div>
            </div>
        </div>

        <div class="row">
            @if(Session::has('message'))
            <div class="col-lg-12 mb-2">
                <div class="alert bg-{{Session::get('status')}} alert-dismissible" role="alert">
                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                    {{ Session::get('message') }}
                </div>
                </div>
            @endif 
        </div>
        
        <div class="row">
            <div class="col-lg-7 mb-2">
                <div class="welcome-banner mt-1 mb-2 mb-sm-0">
                    <img class="banner" src="{{url('/')}}/assets/images/learning.png" alt="">
                    <h1> Hello {{Auth::user()->name}}</h1>
                    <p>Welcome to SHREE AARTHI JEWELLERY <br> Admin Panel</p>
                </div>
            </div>

            <div class="col-lg-5 mb-5">
                <div class="card mt-1 bg-transparent border-0 shadow-none">
                    <div class="mobile-clock-widget">
                      <div>
                        <div class="clock-card gradient-gold">
                          <ul class="clock" id="clock">
                            <li class="hour" id="hour"></li>
                            <li class="min" id="min"></li>
                            <li class="sec" id="sec"></li>
                          </ul>
                        </div>
                      </div>
                      <div class="clock-details">
                        <div class="date f-44 mb-2" id="date"><span id="monthDay"></span><span id="year">, </span><br><h4 style="color: goldenrod;" id="day"></h4></div>
                      </div>
                    </div>
                  </div>
            </div>
        </div>

        <div class="row">
            
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    
            </div>

            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center gradient-primary">
                    <div class="text m-b-10">This Month </div>
                    @php
                        $this_month_payment = DB::table('payment_details')->whereMonth('created_at',date('m'))->orderBy('id', 'DESC')->sum('amount');
                    @endphp
                    <h3 class="m-b-0"><i class="fas fa-rupee-sign"></i> {{number_format($this_month_payment,2)}} </h3>
                </div>
            </div>
            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center gradient-secondary">
                    <div class="text m-b-10">This Year</div>
                    @php
                        $this_year_payment = DB::table('payment_details')->whereYear('created_at',date('Y'))->orderBy('id', 'DESC')->sum('amount');
                    @endphp
                    <h3 class="m-b-0"><i class="fas fa-rupee-sign"></i> {{number_format($this_year_payment,2)}}</h3>
                </div>
            </div>
            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center gradient-green">
                    @php
                        $total_payment = DB::table('payment_details')->orderBy('id', 'DESC')->sum('amount');
                    @endphp
                    <div class="text m-b-10">Overall Payment</div>
                    <h3 class="m-b-0"><i class="fas fa-rupee-sign"></i> {{number_format($total_payment,2)}} </h3>
                </div>
            </div>
            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center gradient-info">
                    @php
                        $users_count = DB::table('users')->where(function($q) {
                                $q->where('is_member', 1);
                                })->orderBy('id','DESC')->count(); 
                    @endphp
                    <div class="text m-b-10">Total Active Users</div>
                    <h3 class="m-b-0">{{$users_count}} </h3>
                </div>
            </div>
            
            <div class="col-lg-12 col-sm-12"><h5 class="text-center">SWARNA AKSHYAM SCHEME</h5></div>
            
            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center white">
                    @php
                        $this_year_gold = DB::table('payment_details AS p'); 
                        $this_year_gold = $this_year_gold->select('p.gold_weight');
                        $this_year_gold = $this_year_gold->join('chit_details AS c', 'c.id', '=', 'p.chit_detail_id');
                        $this_year_gold = $this_year_gold->where('c.scheme_id', 1);
                        $this_year_gold = $this_year_gold->sum('gold_weight');
                    @endphp
                    <div class="text-primary m-b-10">Total Gold Accumulated </div>
                    <h3 class="m-b-0 text-primary"><i class="fas fa-coin"></i>{{number_format((float)$this_year_gold, 2, '.', '')}} gms</h3>
                </div>
            </div>
            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center white">
                    @php
                        $this_year_gold_interest = DB::table('chit_details')->where('scheme_id', 1)->sum('total_interest');
                    @endphp
                    <div class="text-navy m-b-10">Total Interest Gold Accumulated </div>
                    <h3 class="m-b-0 text-navy"><i class="fas fa-coin"></i> {{number_format((float)$this_year_gold_interest, 2, '.', '')}} gms</h3>
                </div>
            </div>
            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center white">
                    @php
                        $this_year_gold_claimed = DB::table('gold_claim AS g'); 
                        $this_year_gold_claimed = $this_year_gold_claimed->select('g.claimed_wt');
                        $this_year_gold_claimed = $this_year_gold_claimed->join('chit_details AS c', 'c.id', '=', 'g.chit_id');
                        $this_year_gold_claimed = $this_year_gold_claimed->where('c.scheme_id', 1);
                        $this_year_gold_claimed = $this_year_gold_claimed->sum('claimed_wt');
                    @endphp
                    <div class="text-success m-b-10">Total Gold Claimed</div>
                    <h3 class="m-b-0 text-success"><i class="fas fa-coin"></i>{{number_format((float)$this_year_gold_claimed, 2, '.', '')}} gms</h3>
                </div>
            </div>
            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center white">
                    @php
                        $gold = $this_year_gold;
                        $gold_claimed = $this_year_gold_claimed;
                    @endphp
                    <div class="text-danger m-b-10">Total Gold Not Claimed</div>
                    <h3 class="m-b-0 text-danger"><i class="fas fa-coin"></i>{{number_format((float)($gold - $gold_claimed), 2, '.', '')}} gms</h3>
                </div>
            </div>
            <!-- <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center gradient-primary">
                    <div class="icon m-b-10">
                        <i class="material-icons">trending_up</i>
                    </div>
                    <div class="text m-b-10">This Month</div>
                    <h3 class="m-b-0"><i class="fas fa-rupee-sign"></i> 45,860 </h3>
                    <small class="displayblock">21% Higher Than Average </small>
                </div>
            </div> -->
            
            <div class="col-lg-12 col-sm-12"><h5 class="text-center">GOLD WALLET </h5></div>
            
            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center white">
                    @php
                        $this_year_gold = DB::table('payment_details AS p'); 
                        $this_year_gold = $this_year_gold->select('p.gold_weight');
                        $this_year_gold = $this_year_gold->join('chit_details AS c', 'c.id', '=', 'p.chit_detail_id');
                        $this_year_gold = $this_year_gold->where('c.scheme_id', 2);
                        $this_year_gold = $this_year_gold->sum('gold_weight');
                    @endphp
                    <div class="text-danger m-b-10">Total Gold Accumulated </div>
                    <h3 class="m-b-0 text-danger"><i class="fas fa-coin"></i>{{number_format((float)$this_year_gold, 2, '.', '')}} gms</h3>
                </div>
            </div>
            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center white">
                    @php
                        $this_year_gold_interest = DB::table('chit_details')->where('scheme_id', 2)->sum('total_interest');
                    @endphp
                     <a href="{{url('/')}}/reports/interest"><div class="text-success m-b-10">Total Interest Gold Accumulated </div>
                    <h3 class="m-b-0 text-success"><i class="fas fa-coin"></i> {{number_format((float)$this_year_gold_interest, 2, '.', '')}} gms</h3></a>
                </div>
            </div>
           <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center white">
                    @php
                        $this_year_gold_claimed = DB::table('gold_claim AS g'); 
                        $this_year_gold_claimed = $this_year_gold_claimed->select('g.claimed_wt');
                        $this_year_gold_claimed = $this_year_gold_claimed->join('chit_details AS c', 'c.id', '=', 'g.chit_id');
                        $this_year_gold_claimed = $this_year_gold_claimed->where('c.scheme_id', 2);
                        $this_year_gold_claimed = $this_year_gold_claimed->sum('claimed_wt');
                    @endphp
                     <a href="{{url('/')}}/reports/claimed"><div class="text-navy m-b-10">Total Gold Claimed</div>
                    <h3 class="m-b-0 text-navy"><i class="fas fa-coin"></i>{{number_format((float)$this_year_gold_claimed, 2, '.', '')}} gms</h3></a>
                </div>
            </div>
            <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center white">
                    @php
                        $gold = $this_year_gold;
                        $gold_claimed = $this_year_gold_claimed;
                    @endphp
                    <div class="text-primary m-b-10">Total Gold Not Claimed</div>
                    <h3 class="m-b-0 text-primary"><i class="fas fa-coin"></i>{{number_format((float)($gold - $gold_claimed), 2, '.', '')}} gms</h3>
                </div>
            </div>
            <!-- <div class="col-lg-3 col-sm-6">
                <div class="support-box text-center gradient-primary">
                    <div class="icon m-b-10">
                        <i class="material-icons">trending_up</i>
                    </div>
                    <div class="text m-b-10">This Month</div>
                    <h3 class="m-b-0"><i class="fas fa-rupee-sign"></i> 45,860 </h3>
                    <small class="displayblock">21% Higher Than Average </small>
                </div>
            </div> -->
        </div>
        </div>
        
        <div class="row clearfix">
            <!-- Task Info -->
            <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                <div class="card">
                    <div class="header">
                        <h2>
                            <strong>Recent Payment</strong> Details</h2>
                    </div>
                    <div class="tableBody">
                        <div class="table-responsive">
                            @php
                                $payment_history = DB::table('payment_details')->orderBy('id', 'DESC')->limit('3')->get();
                            @endphp
                            <table class="table table-hover dashboard-task-infos">
                                <thead>
                                    <tr>
                                       <th>#</th>
                                       <th>Group</th>
                                        <th>Bill No</th>
                                        <th>Payment Date</th>
                                        <th>Amount</th>
                                        <th>Rate</th>
                                        <th>Weight</th>
                                        <th>Instalment</th>
                                        <th>Mode</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if(count($payment_history)>0) 
                                        @foreach($payment_history as $key=>$item)
                                            @php
                                                $userinfo = DB::table('users')->where('id',$item->user_id)->first();

                                                $chitdetailinfo = DB::table('chit_details')->where('id',$item->chit_detail_id)->first();
                                                
                                                $chitinfo = '';
                                                if($chitdetailinfo) {
                                                    if($chitdetailinfo->scheme_id && $chitdetailinfo->group_id) {
                                                        $chitinfo = DB::table('chit_scheme')->where('scheme_id',$chitdetailinfo->scheme_id)->where('id',$chitdetailinfo->group_id)->first();
                                                    }
                                                }
                                            @endphp
                                            <tr>
                                                <td>{{ $key+1 }}</td>
                                                <td>
                                                   @if($chitinfo) @if($chitinfo->chit_name) {{ $chitinfo->chit_name }} @endif @endif 
                                                </td>
                                                <td>
                                                    @if($item->is_same_month=='1') 
                                                        <a title="Paid on the same month" class="text-warning"><i class="fa fa-info-circle"></i></a>
                                                    @endif 
                                                    {{ $item->bill_no }}</td>
                                                <td>
                                                    @if($item->payment_date && $item->payment_date!='0000-00-00') 
                                                        {{ date("d/m/Y",strtotime($item->payment_date))}} 
                                                    @else
                                                        @if($item->created_at) 
                                                            {{ date("d/m/Y",strtotime($item->created_at))}} 
                                                        @endif
                                                    @endif
                                                </td>
                                                <td><i class="fas fa-rupee-sign"></i> {{ number_format((int)$item->amount) }}</td>
                                                <td><i class="fas fa-rupee-sign"></i> {{ number_format((int)$item->gold_rate)  }}</td>
                                                <td>{{ number_format($item->gold_weight,3) }}</td>
                                                <td>{{ $item->no_of_installments }}</td>
                                                <td>{{$item->payment_mode}}</td>                
                                            </tr>
                                        @endforeach
                                    @else 
                                        <tr>
                                            <td class="text-center" colspan="10">
                                                <img src="{{url('/')}}/assets/images/nodata.png"> 
                                                <br><h3>No records found!</h3> 
                                            </td>
                                        </tr>
                                    @endif
                                </tbody>
                            </table>
                            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 text-center">
                                <a href="{{ url('/') }}/payment/history"><button class="btn-hover color-3">View All Details</button></a>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- #END# Task Info -->
            
            <!-- Browser Usage -->
            <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                <div class="card">
                        <div class="header">
                            <h2>
                                <strong>Today's Gold Rate</strong>
                            </h2>
                        </div>
                        <div class="body">
                            @php
                                $gold_rate = DB::table('gold_rate')->orderBy('id', 'DESC')->first();

                                if($gold_rate) {
                                    $statistic = DB::table('gold_rate')->where('id','<',$gold_rate->id)->orderBy('id','DESC')->first();
                                }
                            @endphp
                            <ul class="list-group">
                                <li class="list-group-item">Gold 24k Rate
                                    <span class="badge bg-pink">
                                        <i class="fas fa-rupee-sign"></i> {{number_format($gold_rate->gold_24k_rate,2)}}</span>
                                    <span class="badge bg-transparent text-success border-0">

                                        @php
                                            if($gold_rate->id!=1) {
                                                $gold_24k_rate = isset($statistic->gold_24k_rate)?$statistic->gold_24k_rate:'';
                                                $difference = (int)$gold_rate->gold_24k_rate - (int)$gold_24k_rate;

                                                if($difference!=0) {
                                                    if($gold_rate->gold_24k_rate < $gold_24k_rate) {
                                                        echo "<a class='text-success'>".$difference." <i class='fa fa-arrow-down'></i></a>";  
                                                    } else{
                                                        echo "<a class='text-danger'>+".$difference." <i class='fa fa-arrow-up'></i></a>";
                                                    }
                                                } else {
                                                    echo '0';
                                                }
                                            } 
                                        @endphp
                                    </span>
                                </li>
                                <li class="list-group-item">Gold 22k Rate 
                                    <span class="badge bg-cyan"> 
                                        <i class="fas fa-rupee-sign"></i> {{number_format($gold_rate->gold_22k_rate,2)}} </span>
                                     <span class="badge bg-transparent text-danger border-0">
                                        @php
                                            if($gold_rate->id!=1) {
                                                $gold_22k_rate = isset($statistic->gold_22k_rate)?$statistic->gold_22k_rate:'';
                                                $difference = (int)$gold_rate->gold_22k_rate - (int)$gold_22k_rate;

                                                if($difference!=0) {
                                                    if($gold_rate->gold_22k_rate < $gold_22k_rate) {
                                                        echo "<a class='text-success'>".$difference." <i class='fa fa-arrow-down'></i></a>";  
                                                    } else{
                                                        echo "<a class='text-danger'>+".$difference." <i class='fa fa-arrow-up'></i></a>";
                                                    }
                                                } else {
                                                    echo '0';
                                                }
                                            } 
                                        @endphp
                                    </span>
                                </li>
                                <li class="list-group-item">Gold 18k Rate 
                                    <span class="badge bg-teal"> 
                                        <i class="fas fa-rupee-sign"></i> {{number_format($gold_rate->gold_18k_rate,2)}} </span>
                                    <span class="badge bg-transparent text-success border-0">
                                        @php
                                            if($gold_rate->id!=1) {
                                                $gold_18k_rate = isset($statistic->gold_18k_rate)?$statistic->gold_18k_rate:'';
                                                $difference = (int)$gold_rate->gold_18k_rate - (int)$gold_18k_rate;

                                                if($difference!=0) {
                                                    if($gold_rate->gold_18k_rate < $gold_18k_rate) {
                                                        echo "<a class='text-success'>".$difference." <i class='fa fa-arrow-down'></i></a>";  
                                                    } else{
                                                        echo "<a class='text-danger'>+".$difference." <i class='fa fa-arrow-up'></i></a>";
                                                    }
                                                } else {
                                                    echo '0';
                                                }
                                            } 
                                        @endphp    
                                    </span>
                                </li>
                                <li class="list-group-item">Silver Rate
                                    <span class="badge bg-orange">
                                        <i class="fas fa-rupee-sign"></i> {{number_format($gold_rate->silver_rate,2)}} </span>
                                    <span class="badge bg-transparent text-danger border-0">
                                        @php
                                            if($gold_rate->id!=1) {
                                                $silver_rate = isset($statistic->silver_rate)?$statistic->silver_rate:'';
                                                $difference = (int)$gold_rate->silver_rate - (int)$silver_rate;

                                                if($difference!=0) {
                                                    if($gold_rate->silver_rate < $silver_rate) {
                                                        echo "<a class='text-success'>".$difference." <i class='fa fa-arrow-down'></i></a>";  
                                                    } else{
                                                        echo "<a class='text-danger'>+".$difference." <i class='fa fa-arrow-up'></i></a>";
                                                    }
                                                } else {
                                                    echo '0';
                                                }
                                            } 
                                        @endphp
                                    </span>
                                </li>
                                <li class="list-group-item">Platinum Rate
                                    <span class="badge bg-purple">
                                        <i class="fas fa-rupee-sign"></i> {{number_format($gold_rate->platinum_rate,2)}}</span>
                                    <span class="badge bg-transparent text-danger border-0">
                                        @php
                                            if($gold_rate->id!=1) {
                                                $platinum_rate = isset($statistic->platinum_rate)?$statistic->platinum_rate:'';
                                                $difference = (int)$gold_rate->platinum_rate - (int)$platinum_rate;

                                                if($difference!=0) {
                                                    if($gold_rate->platinum_rate < $platinum_rate) {
                                                        echo "<a class='text-success'>".$difference." <i class='fa fa-arrow-down'></i></a>";  
                                                    } else{
                                                        echo "<a class='text-danger'>+".$difference." <i class='fa fa-arrow-up'></i></a>";
                                                    }
                                                } else {
                                                    echo '0';
                                                }
                                            } 
                                        @endphp
                                    </span>
                                </li>
                                <li class="list-group-item">Diamand Rate
                                    <span class="badge bg-red">
                                        <i class="fas fa-rupee-sign"></i> {{number_format($gold_rate->diamond_rate,2)}}</span>
                                    <span class="badge bg-transparent text-success border-0">
                                        @php
                                            if($gold_rate->id!=1) {
                                                $diamond_rate = isset($statistic->diamond_rate)?$statistic->diamond_rate:'';
                                                $difference = (int)$gold_rate->diamond_rate - (int)$diamond_rate;

                                                if($difference!=0) {
                                                    if($gold_rate->diamond_rate < $diamond_rate) {
                                                        echo "<a class='text-success'>".$difference." <i class='fa fa-arrow-down'></i></a>";  
                                                    } else{
                                                        echo "<a class='text-danger'>+".$difference." <i class='fa fa-arrow-up'></i></a>";
                                                    }
                                                } else {
                                                    echo '0';
                                                }
                                            } 
                                        @endphp
                                    </span>
                                </li>
                            </ul>

                            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 text-center">
                                <a href="{{ route('gold_rate.create') }}"><button class="btn-hover color-8">Update Gold Rate</button></a><br>
                                <a href="#" onclick="return false;" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
                                        Updated on : @if($gold_rate->updated_at)
                                                {{ date("d/m/Y h:i A",strtotime($gold_rate->updated_at))}}
                                                @else
                                                {{ date("d/m/Y h:i A",strtotime($gold_rate->created_at))}}
                                                @endif
                                    </a>
                            </div>

                        </div>
                    </div>
            </div>
            <!-- #END# Browser Usage -->
        </div>

    </div>
</section>

<style type="text/css">
    .support-box { min-height: 100px !important; }
</style>

@endsection