@extends('layouts.website.website')
@section('content')
<section id="main-content">
    <section class="wrapper site-min-height">
        <!--state overview start-->
        <div class="col-md-12">
            <div class="row state-overview" style="padding: 23px 0px;">
                <div class="col-md-8">
                    <!--custom chart start-->

                    <div class="panel-heading">
                        {{ Carbon\Carbon::now()->year }} Pharmacy Expense Report

                        <div class="col-md-1 pull-right no-print">
                            <a class="no-print pull-right" onclick="javascript:window.print();"> <i class="fa fa-print"></i> </a>
                        </div>
                        <div class="col-md-1 pull-right no-print">
                            <a href="finance/pharmacy/monthlyExpense?year=2021">
                                <i class="fa fa-arrow-right"></i>
                            </a>
                        </div>
                        <div class="col-md-1 pull-right no-print">
                            <a href="finance/pharmacy/monthlyExpense?year=2019">
                                <i class="fa fa-arrow-left"></i>
                            </a>
                        </div>
                    </div>
                    <div id="chart_div"></div>

                    <div class="panel-body">
                        <div class="adv-table editable-table">
                            <div class="space15"></div>
                            <table class="table table-striped table-hover table-bordered" id="editable-sample1">
                                <thead>
                                    <tr>
                                        <th>Date</th>
                                        <th>Amount</th>
                                    </tr>
                                </thead>
                                <tbody>

                                    @for ($i = 1; $i <=12 ; $i++)
                                        <tr>
                                            <td>{{ Carbon\Carbon::parse('1-'.$i.'-2020')->format('F') }}</td>
                                            <td>$ {{ App\Expense::whereMonth('created_at',$i)->sum('amount') }}</td>
                                        </tr>
                                    @endfor

                                    <style>
                                        .img_url {
                                            height: 20px;
                                            width: 20px;
                                            background-size: contain;
                                            max-height: 20px;
                                            border-radius: 100px;
                                        }
                                    </style>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!--state overview end-->
    </section>
</section>

@endsection