@extends('layouts/pos_layout')
@section('title', '| Details Opening Balance')
@section('content')
    @include('successMsg')
    <style>
        .table>tbody>tr.info>th,
        .table>tfoot>tr.info>th,
        .table>tbody>tr.info>th:hover,
        .table-hover>tbody>tr>td.info:hover,
        .table-hover>tbody>tr>th.info:hover,
        .table-hover>tbody>tr.info:hover>td,
        .table-hover>tbody>tr:hover>.info,
        .table-hover>tbody>tr.info:hover>th {
            background-color: #708090;
        }
    </style>
    <div class="row add-data-form" style="height:100%">
        <div class="col-md-12">
            <div class="col-md-1"></div>
            <div class="col-md-10 fullbody">
                <div class="viewTitle" style="border-bottom: 1px solid white;">
                    <a href="{{ url('/pos/viewOpeningBalance') }}" class="btn btn-info pull-right addViewBtn"><i
                            class="glyphicon glyphicon-th-list viewIcon"></i>Opening Balance List</a>
                    <button type="button" class="btn btn-primary" onclick='printDiv();' id="print">Print</button>
                    &nbsp;&nbsp;&nbsp;

                </div>
                <div class="panel panel-default panel-border">
                    <div class="panel-heading">
                        <div class="panel-title">Details Opening Balance</div>
                    </div>
                    <div class="panel-body">

                        <div class="row">

                            <table class="table table-bordered table-hover">
                                <tr class="info">
                                    <th width="50" rowspan="2">SL.</th>
                                    <th colspan="2">Customer Information</th>
                                    <th colspan="3">Product Information</th>
                                    <th colspan="5">Sale Information</th>
                                    <th colspan="2">Collection Information</th>
                                    <th rowspan="2">Balance Amount</th>
                                    <th rowspan="2">Action</th>

                                </tr>

                                <th style="background-color: #aebccb;">Customer Name</th>
                                <th style="background-color: #aebccb;">Customer Id</th>

                                <th style="background-color: #aebccb;">Product Name</th>
                                <th style="background-color: #aebccb;">Product Model</th>
                                <th style="background-color: #aebccb;">Product Barcode</th>

                                <th style="background-color: #aebccb;">Sale Date</th>
                                <th style="background-color: #aebccb;">Bill Number</th>
                                <th style="background-color: #aebccb;">Installment Package</th>
                                <!-- <th style="background-color: #afdff4;">1st Installment Amount</th> -->
                                <th style="background-color: #aebccb;">Installment Amount</th>
                                <th style="background-color: #aebccb;">Sale Amount</th>

                                <th style="background-color: #aebccb;">Last Collection Date</th>
                                <th style="background-color: #aebccb;">Collection Amount</th>

                                @php $no=0;
                                $totalInstallment = 0;
                                $totalSales = 0;
                                $totalCollection = 0;
                                $totalBalance = 0;
                                @endphp
                                @foreach ($data as $details)
                                @php
                                    $totalInstallment += $details->installment_amount;
                                    $totalSales += $details->opening_amount;
                                    $totalCollection += $details->paid_amount;
                                    $totalBalance += $details->balance;
                                @endphp
                                    <tr>
                                        <td>{{ ++$no }}</td>
                                        {{-- <td>{{++$no}} {{$details->id}}</td> --}}
                                        <td style="text-align: left;">{{ $details->customer->name }}</td>
                                        <td>{{ $details->customer->customer_id_no }}</td>
                                        <td style="text-align: left;">{{ ($details->product) ? $details->product->name : '' }}</td>
                                        <td>{{ ($details->product) ? (($details->product->model) ? $details->product->model->name : '') : '' }}</td>
                                        <td>{{ ($details->product) ? $details->product->barcode : '' }}</td>

                                        <td>{{ $details->sales_date }}</td>
                                        <td>SLS{{ $details->sale_bill_no }}</td>
                                        <td>{{ $details->installment_package }}</td>

                                        <td style="text-align: right;">{{ $details->installment_amount }}</td>
                                        <td style="text-align: right;">{{ $details->opening_amount }}</td>

                                        <td>{{ $details->last_collection_date }}</td>
                                        <td style="text-align: right;">{{ $details->paid_amount }}</td>

                                        <td style="text-align: right;">{{ $details->balance }}</td>
                                        @php
                                            $count = DB::select(
                                                DB::raw(
                                                    "SELECT count(id) as total FROM pos_collections WHERE sales_bill_no = '$details->sale_bill_no' AND is_opening_balance = 0 AND deleted_at IS NULL",
                                                ),
                                            );
                                            // dd(date('Y-m-d',strtotime($branch_active_date)), date('Y-m-d',strtotime($details->opening_date)), $count[0]->total == 0 )
                                        @endphp

                                        {{-- @if ($branch_active_date == $details->opening_date && $count[0]['total'] == 0) --}}
                                        @if (date('Y-m-d', strtotime($branch_active_date)) == date('Y-m-d', strtotime($details->opening_date)) &&
                                                $count[0]->total == 0)
                                            <td>
                                                &nbsp
												<a id="editIcone" href="{{url('pos/editBranchOpeningBalanceDetails/'.$details->id)}}">
													<span class="glyphicon glyphicon-pencil"></span>
												</a>
												&nbsp
												<a id="deleteIcone" href="javascript:;" class="delete-action" data-id="{{ $details->id }}" data-sales-bill-no="{{ $details->sale_bill_no }}">
													<span class="glyphicon glyphicon-trash"></span>
												</a>
                                            </td>
                                        @else
                                            <td>Close</td>
                                        @endif

                                    </tr>
                                @endforeach

                                <tr>
                                    <td colspan="9"><b>Total:</b></td>
                                    <td style="text-align: right;"><b>{{ number_format($totalInstallment, 2) }}</b></td>
                                    <td style="text-align: right;"><b>{{ number_format($totalSales, 2) }}</b></td>
                                    <td style="text-align: right;"></td>
                                    <td style="text-align: right;"><b>{{ number_format($totalCollection, 2) }}</b></td>
                                    <td style="text-align: right;"><b>{{ number_format($totalBalance, 2) }}</b></td>
                                    <td></td>

                                </tr>
                            </table>

                        </div>

                    </div>
                </div>
                <div class="footerTitle" style="border-top:1px solid white"></div>
            </div>
            <div class="col-md-1"></div>
        </div>
    </div>
@endsection

<script src="{{ asset('js/jquery-1.11.1.min.js') }}"></script>
<script type="text/javascript">
    $(document).ready(function() {
        //delete function
        $(document).on('click', '.delete-action', function() {
            if (hasAccess('pos/deleteOpeningBalance')) {
                Swal.fire({
                    title: 'Are you sure?',
                    text: "Once delete you won't be able to revert this!",
                    icon: 'warning',
                    showCancelButton: true,
                    confirmButtonColor: '#d33',
                    cancelButtonColor: '#7e7979',
                    confirmButtonText: 'Yes, delete it!'
                }).then((result) => {
                    if (result.isConfirmed) {
                        console.log($(this).data('id'));
                        $.ajax({
                            type: 'post',
                            url: '{{ route('pos_opening_balance_delete') }}',
                            data: {
                                '_token': $('input[name=_token]').val(),
                                'id': $(this).data('id'),
                                'sales_bill_no': $(this).data('sales-bill-no')
                            },
                            success: function(_response) {

                                if (_response.responseTitle == 'success') {
                                    Swal.fire({
                                        icon: 'success',
                                        title: 'Deleted!',
                                        text: 'This data has been deleted.',
                                        showConfirmButton: false,
                                        timer: 1500
                                    });
                                    setTimeout(function() {
                                        location.reload();
                                    }, 1000);

                                } else {
                                    Swal.fire({
                                        icon: 'error',
                                        title: 'Failed to delete!',
                                        text: 'This data has not been deleted.',
                                        showConfirmButton: true,
                                    })
                                }
                            }
                        });
                    }
                })
            } else {
                Swal.fire({
                    icon: 'error',
                    title: 'Failed to delete!',
                    text: 'Access Denied',
                    showConfirmButton: true,
                })
            }
        });
    });

    function printDiv() {
        $("#mainDiv").hide();
        var divToPrint = document.getElementById('printDiv');

        var newWin = window.open('', 'Print-Window');

        newWin.document.open();

        newWin.document.write('<html><body onload="window.print()">' + divToPrint.innerHTML + '</body></html>');

        newWin.document.close();

        setTimeout(function() {
            newWin.close();
            window.location.reload(1);
        }, 10);
    };
</script>