@extends('admin.layouts.app')
@section('title','Income Statement')
@push('styles')
    <style>

        .table-bordered td, .table-bordered th {
            border: 1px solid #000 !important;
            vertical-align: middle !important;
            text-align: center;
            padding: 0.2rem !important;
            font-size: 19px !important;
        }
        .table-bordered td{
            border: none !important;
        }
        .table-bordered {
            border: 1px solid #ffffff;
        }
        table thead{
            border-collapse: inherit !important;
        }
        @media print {
            @page {
                size: auto;
                margin: 20px !important;
            }

        }
        td.double-single-border {
            border-top: 1px solid #000 !important;
            border-bottom: 4px double #000 !important;
        }
        td.border-left-right{
            border-left: 1px solid #000 !important;
            border-right: 1px solid #000 !important;
        }
        td.border-top{
            border-top: 1px solid #000 !important;
        }
        td.border-bottom{
            border-bottom: 1px solid #000 !important;
        }
        td b a ,td a{
            color: #000 !important;
            text-decoration: none !important;
        }
        .custom-ml-18{
            margin-left: 18px !important;
        }
        .text-left{
            text-align: left !important;
        }
        .text-right{
            text-align: right !important;
        }
    </style>
@endpush
@section('container')
    <div class="row">
        <!-- left column -->
        <div class="col-md-12">
            <!-- jquery validation -->
            <div class="card card-outline card-default">
                <div class="card-header">
                    <h3 class="card-title">Data Filter</h3>
                </div>
                <!-- /.card-header -->
                <!-- form start -->
                <form action="{{ route('report.income_statement') }}">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label for="start_date">Start Date <span
                                            class="text-danger">*</span></label>
                                    <input required type="date" id="start_date" autocomplete="off"
                                           name="start_date" class="form-control date-picker"
                                           placeholder="Enter Start Date"
                                           value="{{ request()->get('start_date') ?? date('Y-m-d',strtotime($startDate)) }}">
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label for="end_date">End Date <span
                                            class="text-danger">*</span></label>
                                    <input required type="date" id="end_date" autocomplete="off"
                                           name="end_date" class="form-control date-picker"
                                           placeholder="Enter Start Date"
                                           value="{{ request()->get('end_date') ?? date('Y-m-d')  }}">
                                </div>
                            </div>

                            <div class="col-md-2">
                                <div class="form-group">
                                    <label>&nbsp;</label>
                                    <input type="submit" name="search"
                                           class="btn btn-primary bg-gradient-primary form-control" value="Search">
                                </div>
                            </div>
                        </div>
                    </div>

                </form>
            </div>
            <!-- /.card -->
        </div>
        <!--/.col (left) -->
    </div>

    @if(request('start_date'))
    <div class="row">
            <div class="col-12">
                <div class="card card-default">
                    <div class="card-header">
                        <a href="#" onclick="getprint('printArea')"
                           class="btn btn-primary bg-gradient-primary btn-sm"><i class="fa fa-print"></i></a>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive-sm" id="printArea">
                            <div class="row" style="border-bottom: 1.5px solid #000;">
                                <div class="col-4">
                                    <h1 class="text-left m-0 mb-2" style="font-size: 45px !important;font-weight: bold">
                                        <img height="110px" src="{{ asset('assets/images/logos/logo-security.png') }}" alt="">
                                    </h1>
                                </div>
                                <div class="col-8 text-right">
                                    <h2 class="m-0"><b>{{ config('app.name') }}</b></h2>
                                    <h5 class="m-0">{{ config('app.address') }}</h5>
                                    <h5 class="m-0">{{ config('app.phone') }}</h5>
                                    <h5 class="m-0">{{ config('app.email') }}</h5>
                                </div>
                            </div>
                            <div class="row print-heading">
                                <div class="col-12">
                                    <p class="text-center m-0" style="font-size: 20px !important;">
                                        STATEMENT OF PROFIT OR LOSS AND OTHER COMPREHENSIVE INCOME </p>
                                    <p class="text-center" style="font-size: 20px !important;">FOR THE
                                        PERIOD ENDED {{ date('d',strtotime(request('end_date'))) }}th {{ date('F',strtotime(request('end_date'))) }},
                                        {{ date('Y',strtotime(request('end_date'))) }} (Provisional)</p>
                                </div>
                            </div>
                            <table class="table table-bordered">
                                <thead>
                                <tr>
                                    <th colspan="" width="50%" class="text-center" rowspan="2">Particulars</th>
                                    <th width="3%" class="text-center" rowspan="2">Note</th>
                                    <th colspan="4" class="text-center">Amount in Taka</th>
                                </tr>
                                <tr>
                                    <th class="text-center">{{ date('d-m-Y',strtotime(request('end_date'))) }}</th>
{{--                                    <th width="2%"></th>--}}
{{--                                    <th class="text-center">{{ date('d-m-Y',strtotime('-1 day', strtotime(request('start_date')))) }}</th>--}}
                                </tr>
                                </thead>
                                <tbody>
                                <tr><td colspan="5">&nbsp;</td></tr>
                                <tr>
                                    <td colspan="5" class="text-left"><b><u>Revenue</u></b></td>
                                </tr>
                                <tr>
                                    <td class="text-left">Sales Revenue</td>
                                    <td></td>
                                    <td class="text-right border-left-right border-top">{{ \App\Helpers\Helper::number_bn_format(abs($sales_revenue)) }}</td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right border-left-right border-top">{{ number_format(abs(0),2) }}</td>--}}
                                </tr>
                                <tr>
                                    <td class="text-left">Commission</td>
                                    <td></td>
                                    <td class="text-right border-left-right">{{ \App\Helpers\Helper::number_bn_format(abs($commission)) }}</td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right border-left-right border-top">{{ number_format(abs(0),2) }}</td>--}}
                                </tr>
                                <tr>
                                    <td class="text-left">Less: Sales Returns</td>
                                    <td></td>
                                    <td class="text-right border-left-right">{{ \App\Helpers\Helper::number_bn_format(abs(0)) }}</td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right border-left-right">{{ number_format(abs(0),2) }}</td>--}}
                                </tr>
{{--                                <tr>--}}
{{--                                    <td class="text-left">Less: </td>--}}
{{--                                    <td></td>--}}
{{--                                    <td class="text-right border-left-right">{{ number_format(abs(0),2) }}</td>--}}
{{--                                    <td></td>--}}
{{--                                    <td class="text-right border-left-right">{{ number_format(abs(0),2) }}</td>--}}
{{--                                </tr>--}}
                                <tr>
                                    <td class="text-left">Less: Sales Discount</td>
                                    <td></td>
                                    <td class="text-right border-left-right border-bottom">{{ \App\Helpers\Helper::number_bn_format(abs(0)) }}</td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right border-left-right border-bottom">{{ number_format(abs(0),2) }}</td>--}}
                                </tr>
                                <tr>
                                    <td colspan="2" class="text-left"><b>Net Sales</b></td>
                                    <td class="text-right"><b>{{ \App\Helpers\Helper::number_bn_format(abs($sales_revenue+$commission)) }}</b></td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right"><b>{{ number_format(abs(0),2) }}</b></td>--}}
                                </tr>

                                <tr>

                                    <td class="text-left">Less: Cost of Goods Sold (COGS)</td>
                                    <td></td>
                                    <td class="text-right border-bottom">{{ \App\Helpers\Helper::number_bn_format(abs($purchase_price)) }}</td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right border-bottom">{{ number_format(abs(0),2) }}</td>--}}
                                </tr>
                                @php
                                $gross_profit_loss = $sales_revenue + $commission - $purchase_price;
                                @endphp
                                <tr>
                                    <td colspan="2" class="text-left"><b>Gross Profit/(Loss)</b></td>
                                    <td class="text-right"><b>@if($gross_profit_loss < 0)(-)@endif {{ \App\Helpers\Helper::number_bn_format(abs($gross_profit_loss)) }}</b></td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right"><b>{{ number_format(abs(0),2) }}</b></td>--}}
                                </tr>
                                <tr><td colspan="5">&nbsp;</td></tr>
                                <tr>

                                    <td class="text-left">Less: Administrative Expenses</td>
                                    <td></td>
                                    <td class="text-right text-right border-left-right border-top border-bottom">{{ \App\Helpers\Helper::number_bn_format(abs($administrative_expenses)) }}</td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right text-right border-left-right border-top border-bottom">{{ number_format(abs(0),2) }}</td>--}}
                                </tr>
                                @php
                                    $operating_profit_loss = $gross_profit_loss - $administrative_expenses;
                                @endphp
                                <tr><td colspan="5">&nbsp;</td></tr>
                                <tr>
                                    <td colspan="2" class="text-left"><b>Operating Profit/(Loss)</b></td>
                                    <td class="text-right"><b>@if($operating_profit_loss < 0)(-)@endif {{ \App\Helpers\Helper::number_bn_format(abs($operating_profit_loss)) }}</b></td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right"><b>{{ number_format(abs(0),2) }}</b></td>--}}
                                </tr>
                                <tr><td colspan="5">&nbsp;</td></tr>
                                <tr>
                                    <td class="text-left">Other Income</td>
                                    <td></td>
                                    <td class="text-right border-bottom">{{ \App\Helpers\Helper::number_bn_format(abs($other_income)) }}</td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right border-bottom">{{ number_format(abs(0),2) }}</td>--}}
                                </tr>
                                @php
                                    $net_profit_loss = $operating_profit_loss + $other_income;
                                @endphp
                                <tr><td colspan="5">&nbsp;</td></tr>
                                <tr>
                                    <td colspan="2" class="text-left"><b>@if($net_profit_loss > 0) Net Profit @else Net Loss @endif</b></td>
                                    <td class="text-right double-single-border"><b>@if($net_profit_loss < 0)(-)@endif {{ \App\Helpers\Helper::number_bn_format(abs($net_profit_loss)) }}</b></td>
{{--                                    <td></td>--}}
{{--                                    <td class="text-right double-single-border"><b>{{ number_format(abs(0),2) }}</b></td>--}}
                                </tr>
                                <tr><td colspan="5">&nbsp;</td></tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    @endif
@endsection

@push('scripts')
    <script>
        var APP_URL = '{!! url()->full()  !!}';

        function getprint(print) {
            $('.print-heading').css('display', 'block');
            $('.extra_column').remove();
            $('body').html($('#' + print).html());
            window.print();
            window.location.replace(APP_URL)
        }
    </script>
@endpush