@extends('layouts.main_without_top_button')
@section('title')
    Cash Book Report
@stop
@section('navigation')
    <ul class="breadcrumb">
        <li><a href="{{route('home')}}">Dashboard</a> <span class="divider">/</span></li>
        <li><a href="">Reports</a> <span class="divider">/</span></li>
        <li class="active">Cash Book Report</li>
    </ul>
@stop
@section('contentinner')
    <div class="tabbable">
        <style>
            .td_left_border {
                border-top: 1px solid #dddddd;
                border-left: 1px solid #dddddd;
                border-bottom: 0;
            }

            .td_border_right {
                border-right: 1px solid #dddddd;
            }

            .widgettitle {
                color: #000000;
            }
        </style>
        <div class="tab-content">
            <div class="tab-pane active" style="margin-top: 12px">
                <center>
                    <center style="margin-bottom: 8px">
                        <form class=" form-inline">
                            <label class="control-label" for="Category"> DATE FROM </label>
                            <input type="text" name="date_from" id="" class="form-control span3 date_picker"
                                   value="{{\Carbon\Carbon::parse($date[0])->format('Y-m-d')}}">
                            <label class="control-label" for="Category"> DATE TO </label>
                            <input type="text" name="date_to" id="" class="form-control span2 date_picker"
                                   value="{{\Carbon\Carbon::parse($date[1])->format('Y-m-d')}}">
                            <button type="submit" class="btn" id="re_generate_report">RE-GENERATE</button>
                            <a id="print_generate_report" class="btn" style="" data-href="">PRINT</a>
                            <a class="btn" style="margin-right: 20px;" data-href="" id="export_generate_report">
                                <span class="iconsweets-excel"></span>EXPORT</a>
                        </form>
                    </center>
                    <div id="income_statement">
                        <input data-href="{{route('reports.company-income-statements.excel',['date_from'=>$date[0],'date_to'=>$date[1]])}}"
                               id="income_statement_date" type="hidden">
                        <table class="table table-bordered table-striped" id="route_invoice_status_list">
                            <thead>
                            <tr>
                                <td colspan="8" class="widgettitle"
                                    style="text-align: center;font-size: 14px;color: #000;line-height: 24px">
                                    CASH BOOK REPORT<br>
                                    FROM {{\Carbon\Carbon::parse($date[0])->toFormattedDateString()}}
                                    TO {{\Carbon\Carbon::parse($date[1])->toFormattedDateString()}}
                                </td>
                            </tr>
                            <tr>
                                <th style="width: 10px">&nbsp;</th>
                                <th style="width: 80px">Date</th>
                                <th>Particulars</th>
                                <th>Payee</th>
                                <th>REF</th>
                                <th>AMOUNT- DR</th>
                                <th>AMOUNT- CR</th>
                                <th>Balance</th>
                                {{--<th>Amount Due</th>--}}
                            </tr>
                            </thead>
                            <tbody>
                            <tr>
                                <td>&nbsp;</td>
                                <td>-</td>
                                <td> bal b/f</td>
                                <td></td>
                                <td></td>
                                @if($cash_book_transactions_open_balance > 0)
                                    <td style="text-align: right">{{number_format($cash_book_transactions_open_balance,2)}}</td>
                                    <td style="text-align: right"></td>
                                @else
                                    <td style="text-align: right"></td>
                                    <td style="text-align: right">{{number_format($cash_book_transactions_open_balance,2)}}</td>
                                @endif
                                <td style="text-align: right"></td>
                            </tr>
                            {{--*/ $dr_total = 0 /*--}}
                            {{--*/ $cr_total = 0 /*--}}
                            {{--*/ $total = $cash_book_transactions_open_balance /*--}}
                            @foreach($cash_book_transactions as $index=>$cash_book_transaction)
                                <tr>
                                    <td>&nbsp;</td>
                                    <td>{{\Carbon\Carbon::parse($cash_book_transaction['date'])->toFormattedDateString()}}</td>
                                    <td>{{$cash_book_transaction['description']}}</td>
                                    <td>{{$cash_book_transaction['payee']}}</td>
                                    <td>{{$cash_book_transaction['document_number']}}</td>
                                    <td style="text-align: right">
                                        @if($cash_book_transaction['type']=='DEBITED')
                                            {{number_format($cash_book_transaction['amount'],2)}}
                                            {{--*/ $total += $cash_book_transaction['amount'] /*--}}
                                        @endif
                                        @if($cash_book_transaction['type']=='OPEN_BALANCE')
                                            {{number_format($cash_book_transaction['amount'],2)}}
                                            {{--*/ $total = $cash_book_transaction['amount'] /*--}}
                                        @endif
                                    </td>
                                    <td style="text-align: right">
                                        @if($cash_book_transaction['type']=='CREDITED')
                                            {{number_format($cash_book_transaction['amount'],2)}}
                                            {{--*/ $total -= $cash_book_transaction['amount'] /*--}}
                                        @endif
                                    </td>
                                    <td style="text-align: right">{{number_format($total,2)}}</td>
                                </tr>
                            @endforeach
                            </tbody>

                        </table>
                    </div>
                </center>
            </div><!--tab-pane-->
        </div><!--tabcontent-->
    </div><!--tabbable-->
    <script>
        jQuery('.date_picker').datepicker();
        jQuery('#re_generate_report').on('click', function (e) {
            e.preventDefault();
            jQuery.ajax({
                url: '{{route('reports.accounts.cash-book.create')}}',
                type: 'get',
                data: jQuery('form').serialize(),
                success: function (data) {
                    jQuery('#income_statement').empty().append(data);

                }
            });
        });

        jQuery('#export_generate_report').on('click', function (e) {
            e.preventDefault();
            var url = jQuery('#income_statement_date').attr("data-href");
            window.open(url, '_blank');
        });
    </script>
@stop