@extends('layouts/contentLayoutMaster')

@section('title', 'Management Statements')

@section('vendor-style')
{{-- Page Css files --}}
<link rel="stylesheet" href="{{ asset(mix('vendors/css/forms/select/select2.min.css')) }}">
<link rel="stylesheet" href="{{ asset(mix('vendors/css/pickers/flatpickr/flatpickr.min.css')) }}">
<link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/dataTables.bootstrap5.min.css')) }}">
<link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/responsive.bootstrap5.min.css')) }}">
<link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/buttons.bootstrap5.min.css')) }}">
<link rel="stylesheet" href="{{ asset(mix('vendors/css/tables/datatable/rowGroup.bootstrap5.min.css')) }}">
<link rel="stylesheet" href="{{ asset('tablesorter/dist/css/jquery-ui.css') }}">
<link rel="stylesheet" href="{{ asset('tablesorter/dist/css/theme.jui.min.css') }}">
@endsection

@section('page-style')
{{-- Page Css files --}}
<link rel="stylesheet" href="{{ asset(mix('css/base/plugins/forms/form-validation.css')) }}">
<link rel="stylesheet" href="{{ asset(mix('css/base/plugins/forms/pickers/form-flat-pickr.css')) }}">
<link rel="stylesheet" href="{{ asset('vendors/css/ui/gray-themes.css') }}">
@endsection

@section('content')

<!-- list start -->
<section class="app-post-list">

    @include('content.partial.form-message')

    <!-- Striped rows start -->
    <div class="row financialTheme statementsList">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">Statements List</h4>
                </div>

                <div class="card-body">

                    <form class="form row" method="GET" action="{{route('statements.index')}}" enctype="multipart/form-data">
                        <div class="row">
                            <div class="col-md-3 col-12">
                                <div class="mb-1">
                                    <label class="form-label" for="date_from">Date From</label>
                                    <input type="text" id="date_from" autocomplete="off" class="form-control" placeholder="{{ date('Y-m-d') }}" name="date_from" value="{{ old("date_from", request()->input("date_from")) }}"/>
                                </div>
                            </div>
                            <div class="col-md-3 col-12">
                                <div class="mb-1">
                                    <label class="form-label" for="date_to">Date To</label>
                                    <input type="text" id="date_to" autocomplete="off" class="form-control" placeholder="{{ date('Y-m-d') }}" name="date_to" value="{{ old("date_to", request()->input("date_to")) }}"/>
                                </div>
                            </div>
                            <div class="col-md-3 col-12">
                                <div class="mb-1">
                                    <label class="form-label" for="category">Show</label>
                                    @php
                                    $default_show = request()->input("show") ? request()->input("show") : "Without Zero Balance";
                                    $shows = ['Without Zero Balance', 'With Zero Balance'];
                                    if(!empty($shows)){
                                    @endphp

                                    <select class="select2 form-select" id="show" name="show">
                                        <option value="" selected="selected">select</option>
                                        @foreach($shows as $show)
                                        <option value="{{ $show }}" @if( $default_show == $show ) selected @endif>{{ $show }}</option>
                                        @endforeach
                                    </select>

                                    @php
                                    }
                                    @endphp
                                </div>
                            </div>
                            <div class="col-md-3 pt9 align-self-center pe-0 text-end">
                                <button type="submit" class="btn btn-primary me-1" onclick="this.form.submit()">Search</button>
                                <a class="btn btn-outline-secondary" href="{{url()->current()}}" role="button">Reset</a>
                            </div>
                        </div>

                    </form>

                    @php
                    $currencies = ['USD', 'AED', 'EUR', 'IRR'];
                    $categories = ['Customers', 'Vendors', 'Resources', 'Temporary', 'Other'];
                    @endphp

                    <p style="height: 20px;" align="center"><h2>Head Accounts:</h2></p>

                    <div class="table-responsive defaultThemeTable">
                        <table id="tablesorter-categories" class="table" cellpadding="5" cellspacing="0" style="border-collapse: collapse;" border="0" bordercolor="#666666">
                            <thead>
                            <tr>
                                <th class="rowTH">Row</th>
                                <th>Head Account</th>

                                @foreach($currencies as $currency)
                                <th>{{ $currency }}</th>
                                @endforeach
                            </tr>
                            </thead>
                            <tbody>
                            @php
                            $i = 0;
                            $sum = [];
                            @endphp
                            @foreach($categories as $category)


                            @if ($category == "Customers")
                            <tr class="customerThemes">
                                @elseif ($category == "Vendors")
                            <tr class="vendorTheme">
                                @elseif ($category == "Resources")
                            <tr class="financialTheme">
                                @else
                            <tr>
                                @endif

                                <td>{{ ++$i }}</td>
                                <td>
                                    <a href="{{ request()->url() . "?head_account=$category&date_from=" . request()->input("date_from") . "&date_to=" . request()->input("date_to") . "&show=$default_show" }}">
                                        {{ $category }}
                                    </a>
                                </td>

                                @foreach($currencies as $currency)
                                @php
                                if( !in_array($category, ['Temporary', 'Other'])){
                                $sum[$currency] = (isset($sum[$currency]) ? $sum[$currency] : 0.00) + (isset($head_accounts[$category][$currency]) ? $head_accounts[$category][$currency] : 0.00);
                                }
                                @endphp
                                <td>{{ isset($head_accounts[$category][$currency]) ? number_format($head_accounts[$category][$currency], 2) : 0.00 }}</td>
                                @endforeach
                            </tr>
                            @endforeach

                            </tbody>
                            <thfoot>
                                <tr class="thFootTR" style="background-color: #c6d9ff; color: #00509d; font-weight: bold; font-size: 14px; color:#00509d;">
                                    <td colspan="2">Summation</td>
                                    @foreach($currencies as $currency)
                                    <td>{{ number_format(isset($sum[$currency]) ? $sum[$currency] : 0.00, 2) }}</td>
                                    @endforeach
                                </tr>
                            </thfoot>
                        </table>
                    </div>

                    @if( $accounts )

                    <p style="height: 20px;" align="center"><h2>{{ request()->input("head_account") }} Accounts:</h2></p>


                    @if (request()->input("head_account") == "Customers")
                    <div class="table-responsive customerThemes">
                        @elseif (request()->input("head_account") == "Vendors")
                        <div class="table-responsive vendorTheme">
                            @elseif (request()->input("head_account") == "Resources")
                            <div class="table-responsive financialTheme">
                                @else
                                <div class="table-responsive defaultThemeTable">
                                    @endif
                                    <table id="tablesorter-account" class="table" cellpadding="5" cellspacing="0" style="border-collapse: collapse;" border="0" bordercolor="#666666">
                                        <thead>
                                        <tr>
                                            <th class="rowTH">Row</th>
                                            <th>Account</th>

                                            @foreach($currencies as $currency)
                                            <th>{{ $currency }}</th>
                                            @endforeach
                                        </tr>
                                        </thead>
                                        <tbody>
                                        @php
                                        $i = 0;
                                        $sum = [];
                                        @endphp
                                        @foreach($accounts as $name => $balance)
                                        @php
                                        if( $default_show == "Without Zero Balance" && array_sum($balance) == 0 ){
                                        $show_account = false;
                                        }
                                        else{
                                        $show_account = true;
                                        }
                                        @endphp

                                        @if( $show_account )
                                        <tr>
                                            <td>{{ ++$i }}</td>
                                            <td>{{ $name }}</td>

                                            @foreach($currencies as $currency)
                                            @php
                                            $sum[$currency] = (isset($sum[$currency]) ? $sum[$currency] : 0.00) + (isset($balance[$currency]) ? $balance[$currency] : 0.00);
                                            @endphp
                                            <td>
                                                <a href="{{ route('statements.show', ["head_account" => request()->input("head_account"), "account" => $name, "currency" => $currency, "date_from" => request()->input("date_from"), "date_to" => request()->input("date_to"), "show" => $default_show]) }}" target="_blank">
                                                {{ isset($balance[$currency]) ? number_format($balance[$currency], 2) : 0.00 }}
                                                </a>
                                            </td>
                                            @endforeach
                                        </tr>
                                        @endif
                                        @endforeach

                                        </tbody>
                                        <thfoot>
                                            <tr class="tableFoot" style=" font-weight: bold; font-size: 14px;">
                                                <td colspan="2">Summation</td>
                                                @foreach($currencies as $currency)
                                                <td>{{ number_format(isset($sum[$currency]) ? $sum[$currency] : 0.00 , 2) }}</td>
                                                @endforeach
                                            </tr>
                                        </thfoot>
                                    </table>
                                </div>

                                @endif
                            </div>
                        </div>
                    </div>
                </div>
                <!-- Striped rows end -->
</section>
<!-- list ends -->
@endsection

@section('vendor-script')
{{-- Vendor js files --}}
<script src="{{ asset(mix('vendors/js/forms/select/select2.full.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/jquery.dataTables.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/dataTables.bootstrap5.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/dataTables.responsive.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/responsive.bootstrap5.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/datatables.buttons.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/jszip.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/pdfmake.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/vfs_fonts.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/buttons.html5.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/buttons.print.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/tables/datatable/dataTables.rowGroup.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/forms/validation/jquery.validate.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/forms/cleave/cleave.min.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/forms/cleave/addons/cleave-phone.us.js')) }}"></script>
<script src="{{ asset(mix('vendors/js/pickers/flatpickr/flatpickr.min.js')) }}"></script>
<script src="{{ asset('tablesorter/dist/js/jquery.tablesorter.min.js') }}"></script>
<script src="{{ asset('tablesorter/dist/js/jquery.tablesorter.widgets.min.js') }}"></script>
@endsection

@section('page-script')
<script src="{{ asset(mix('js/scripts/forms/form-select2.js')) }}"></script>
<script type="text/javascript">
    $(function() {
        // Extend the themes to change any of the default class names
        $.extend($.tablesorter.themes.jui, {
            // change default jQuery uitheme icons - find the full list of icons at
            // http://jqueryui.com/themeroller/ (hover over them for their name)
            table        : 'ui-widget ui-widget-content ui-corner-all', // table classes
            caption      : 'ui-widget-content',
            // header class names
            header       : 'ui-widget-header ui-corner-all ui-state-default', // header classes
            sortNone     : '',
            sortAsc      : '',
            sortDesc     : '',
            active       : 'ui-state-active', // applied when column is sorted
            hover        : 'ui-state-hover',  // hover class
            // icon class names
            icons        : 'ui-icon', // icon class added to the <i> in the header
            iconSortNone : 'ui-icon-carat-2-n-s ui-icon-caret-2-n-s', // class name added to icon when column is not sorted
            iconSortAsc  : 'ui-icon-carat-1-n ui-icon-caret-1-n', // class name added to icon when column has ascending sort
            iconSortDesc : 'ui-icon-carat-1-s ui-icon-caret-1-s', // class name added to icon when column has descending sort
            filterRow    : '',
            footerRow    : '',
            footerCells  : '',
            even         : 'ui-widget-content', // even row zebra striping
            odd          : 'ui-state-default'   // odd row zebra striping
        });

        $("#tablesorter-account").tablesorter({
            theme : 'jui', // theme "jui" and "bootstrap" override the uitheme widget option in v2.7+
            headerTemplate : '{content} {icon}', // needed to add icon for jui theme
            // widget code now contained in the jquery.tablesorter.widgets.js file
            widgets : ['uitheme', 'filter', 'zebra'],
            widgetOptions : {
                // zebra striping class names - the uitheme widget adds the class names defined in
                // $.tablesorter.themes to the zebra widget class names
                zebra   : ["even", "odd"],

                // set the uitheme widget to use the jQuery UI theme class names
                // ** this is now optional, and will be overridden if the theme name exists in $.tablesorter.themes **
                // uitheme : 'jui'
            }
        });
    });
</script>

<script>
    $('#date_from').flatpickr();
    $('#date_to').flatpickr();
</script>
@endsection