@extends('layouts.app')
@section('title') {{'Received & Payment Report'}} @endsection
@section('content')
@include('layouts.numbertowords')
    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading">
                Received & Payment Report
                <a href="{{ url('/ReceivedPaymentReport') }}" class="pull-right"> Back </a>
            </div>
            @if (Session::has('msg'))
                <div class="alert alert-info">{{ Session::get('msg') }}</div>
            @endif
            <div class="panel-body">
                <div class="form-group"> 
                <form action="" method="get" autocomplete="off">
                        <div class="col-md-2">
                            Start Date
                            <input id="start_date" type="text" class="form-control" name="start_date" value="2026-06-04" autocomplete="off" required>
                        </div>
                        <div class="col-md-2">
                            End Date
                            <input id="end_date" type="text" class="form-control" name="end_date" value="2026-06-04" autocomplete="off" required>
                        </div>
                        <div class="col-md-2">
                            <br/> &nbsp;
                            <button type="submit" class="btn btn-success">Search</button>
                        </div>
                    
                </form>
                </div>
                <div class="clearfix">
                    <p class="pull-right">
                        <span title="Print" class="btn btn-primary" onclick="printData('myTablePrint')"> <i class="glyphicon glyphicon-print"> </i> </span>
                        <span title="Download" class="btn btn-success" onclick="exportTableToExcel('myTablePrint')" > <i class="glyphicon glyphicon-download-alt"></i> </span>
                    </p>
                </div>
                <div id="myTablePrint" class="form-group mt-1" style="width:100%; overflow: scroll;" >
                    <div class="col-sm-12 text-center">
                        @include('layouts.head') 
                                                <h2><u>Received & Payment Transactions</u></h2>
                        <h5>{!! date('d-F-Y', strtotime($start_date)) !!} to {!! date('d-F-Y', strtotime($end_date)) !!} </h5>
                        <br>
                    
                  </div>
                    <table id="myTable" class="table text-center table-striped table-hover">
                        <thead class="header" id="myHeader">
                            <tr>
                                <th>S.L.</th>
                                <th>Date</th>
                                <th>Voucher No.</th>
                                <th>A/C Name</th>
                                <th>Particulars</th>
                                <th>Receipt(BDT)</th>
                                <th>Payment(BDT)</th>
                            </tr>
                        </thead>
                        @php
                            $total_receipt = 0;
                            $total_payment = 0;
                            $i=1;
                        @endphp
                        <tbody>
                            @foreach ($report as $data)
                                <tr>
                                    <td>{{ $i++ }}</td>
                                    <td>{{date('d-F-Y', strtotime($data->txn_date))}}</td>
                                    <td>{{ $data->customer_id == 24 ? 'RV#' : 'PV#'}}{{ $data->voucher_no }}</td>
                                    <td>{{ $data->name }}</td>
                                    <td>{{ $data->type_id }}</td>
                                    <td>{{ $data->customer_id == 24 ? number_format($data->amount,2) : '' }}</td>
                                    <td>{{ $data->customer_id == 23 ? number_format($data->amount,2) : '' }}</td>
                                </tr>
                                @php
                                    switch ($data->customer_id) {
                                        case 24:
                                            $total_receipt += $data->amount;
                                            break;
                                        case 23:
                                            $total_payment += $data->amount;
                                            break;
                                        default:
                                            $total_receipt += 0;
                                            $total_payment += 0;
                                            break;
                                    }
                                @endphp
                            @endforeach
                            <tr>
                                <th colspan="5">Grand Total =</th>
                                <th>{{ number_format($total_receipt,2) }}</th>
                                <th>{{ number_format($total_payment,2) }}</th>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
<style>
    table#myTable thead#myHeader { background: #D9E5D8; color: #006C32; }
    div#myTablePrint table#myTable tbody tr td {  border: 1px solid; border-collapse: collapse;  height: 28px; font-size: 15px;}
    div#myTablePrint table#myTable .rightside {text-align: right; }
    div#myTablePrint table#myTable tbody.leftsidenobox tr td {border: none;}
    div#myTablePrint table#myTable thead#myHeader tr th {border-collapse: collapse; border: 1px solid #000000!important;}
    div#myTablePrint table#myTable tbody tr th{border-collapse: collapse; border: 1px solid #000000!important; }
    thead th {border-collapse: collapse; border-right: 1px solid #000000 !important; }
    table.table.text-center.table-striped.table-hover.fixedHeader .header tr th {
        position: sticky;
        top: 0;
        /* width: 109%; */
        background: #D9E5D8;
    }

    table#myTablePrint thead#myHeader{
        position: sticky;
        top: 0;
        /* width: 109%; */
        background: #D9E5D8;
    }
    table.table.text-center.table-striped.table-hover.fixedHeader .header tr:last-child th{
        top: 32px;
    }
    thead#myHeader tr th { text-align: center;}
</style>

    <script>
        function resetOption(param1, param2){
            document.getElementById(param1).value = "";
            $('#' + param1).selectpicker('refresh');
            document.getElementById(param2).value = "";
            $('#' + param2).selectpicker('refresh');
        }
        function printData() {
            var print_ = document.getElementById("myTablePrint");
            win = window.open("");
            win.document.write(print_.outerHTML);

            win.document.write('<style type="text/css">');
            
            win.document.write('.col-sm-12.text-center h2, .col-sm-12.text-center h4, .col-sm-12.text-center h5 { text-align: center; margin: 0; }');
            win.document.write('.col-sm-12.text-center h2 { font-size: 24px; }');
            win.document.write('.col-sm-12.text-center h4 { font-size: 18px; }');
            win.document.write('.col-sm-12.text-center.printlogo { text-align: center; }');

            win.document.write('#myTablePrint table { width: 100%; border-collapse: collapse; font-family: Arial, sans-serif; }');
            win.document.write('#myTablePrint table#myTable thead tr th { font-weight: bold; border: 1px solid #000000!important; font-size: 14px; padding: 8px; text-align: center; }');
            win.document.write('#myTablePrint table#myTable tbody tr td { text-align: center; height: 20px; border: 1px solid #000000!important; font-size: 14px; font-weight: bold; padding: 5px; }');
            win.document.write('#myTablePrint table#myTable tbody tr th { text-align: center; height: 20px; border: 1px solid #000000!important; font-size: 14px; font-weight: bold; padding: 5px;}');
            win.document.write('#myTablePrint table tbody .leftsidenobox tr td { border: none; padding: 5px; }');

            win.document.write('#myTablePrint table tfoot tr th { font-weight: normal; text-align: center; font-size: 12px; padding: 5px; }');
            win.document.write('#myTablePrint table tfoot tr td { font-size: 12px; font-weight: normal; padding: 5px; text-align: left; }');
            win.document.write('#myTablePrint table tfoot tr th:last-child { font-size: 10px; font-style: italic; }');

            win.document.write('#myTablePrint table tfoot tr td { font-weight: bold; font-size: 14px; }');
            win.document.write('#myTablePrint table tfoot tr th, #myTablePrint table tfoot tr td { padding: 10px 5px; }');
            
            win.document.write('#myTablePrint table tfoot tr td b { font-size: 14px; font-weight: normal; }');
            win.document.write('#myTablePrint table tfoot tr td { font-size: 14px; padding-left: 5px; padding-right: 5px; text-align: left;}');

            win.document.write('body { margin: 20px; padding: 10px; font-family: Arial, sans-serif; }');
            win.document.write('table { border-collapse: collapse; }');

            win.document.write('.col-sm-12.text-center img { width: 15%; }');
            

            win.document.write('</style>');

            win.print();
            win.close();
        }


        function exportTableToExcel(tableID, filename = '',report_header='')
          {
              var downloadLink;
              var dataType = 'application/vnd.ms-excel';
              var tableSelect = document.getElementById(tableID);
              var tableHTML = '';

              if(report_header!='')
              {
                  tableHTML = $("#"+report_header).html();
              } else {
                  tableHTML = '';
              }

              tableHTML = tableHTML + tableSelect.outerHTML.replace(/ /g, '%20');

              // Specify file name
              filename = filename?filename+'.xls':'excel_data.xls';

              // Create download link element
              downloadLink = document.createElement("a");

              document.body.appendChild(downloadLink);

              if(navigator.msSaveOrOpenBlob){
                  var blob = new Blob(['\ufeff', tableHTML], {
                      type: dataType
                  });
                  navigator.msSaveOrOpenBlob( blob, filename);
              }else{
                  // Create a link to the file
                  downloadLink.href = 'data:' + dataType + ', ' + tableHTML;

                  // Setting the file name
                  downloadLink.download = filename;

                  //triggering the function
                  downloadLink.click();
              }
          }
        
        jQuery( function($) {
            $( "#start_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
            $( "#end_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
        } );

        
    </script>
@endsection