@extends('layouts.app')
@section('title') {{'General Ledger Report'}} @endsection
@section('content')

  
    <div class="col-md">
        <div class="panel panel-default">
            <div class="panel-heading"> General Ledger Report
                <a href="{{ url('/partyledger') }}" class="pull-right"> Back to Day Book List </a>
            </div>
            
                <div class="panel-body">
                    <div class="form-group">
                        <form method="get"  action="">
                            <div class="col-md-3">
                                Search By Customer/Supplier
                               <select name="supplier_id" id="supplier_id" data-live-search="true" class="form-control selectpicker">
                                    <option value=""> Select </option>
                                    @if(isset($buyers_list))
                                        @foreach($buyers_list as $val)
                                            <option value="{{ $val->id}}"  @if(isset($_GET['supplier_id']) && $_GET['supplier_id'] == $val->id) selected="selected" @endif >  {{ $val->id }} - {{ $val->name }} </option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                            <div class="col-md-3">
                                Search By Area
                               <select name="area_id" id="area_id" data-live-search="true" class="form-control selectpicker">
                                    <option value=""> Select </option>
                                    @if(isset($area_list))
                                        @foreach($area_list as $val)
                                            <option value="{{ $val->id}}"  @if(isset($_GET['area_id']) && $_GET['area_id'] == $val->id) selected="selected" @endif >  {{ $val->values }} </option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                            <div class="col-md-2">
                                Start Date
                                <input id="start_date" type="text" class="form-control" name="start_date" value="2026-06-01" 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>
                                    <input type="hidden" name="_token" value="{{ csrf_token() }}"/>    
                            </div>
                        </form>
                        
                    </div>
                    <div class="tab-pane " id="basic" role="tabpanel" aria-labelledby="basic-tab">
                    
                            <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>
                                        @if(isset($supplier_id) && $supplier_id !='')
                    <div class="form-group mt-1" style="width:100%; overflow: scroll;" >
                        <div class="panel-body" id="myTablePrint">
                            <div class="col-sm-12 text-center">

                                                        <br>
                            
                            @include('layouts.head')
                            <h4>Customer's Ledger</h4>
                            <h5>{!! date('d-F-Y', strtotime($start_date)) !!} to {!! date('d-F-Y', strtotime($end_date)) !!} </h5>
                            <br>
                            @if(isset($day_book_list[0]->name))
                            <div class="leftside" style="float: left; ">Customer Name : {!! $day_book_list[0]->supplier_id !!} - {!! $day_book_list[0]->name !!}</div>
                            <br>
                            <div class="leftside" style="float: left; ">Proprietor : {!! $day_book_list[0]->person_name !!}</div>
                            <br>
                            <div class="leftside" style="float: left; ">Address : {!! $day_book_list[0]->address !!}</div>
                            <br>
                            <div class="leftside" style="float: left; ">Contact No. : {!! $day_book_list[0]->mobile !!}</div>
                            @endif
                            <br><br>
                        </div>
                        <table id="myTable" class="table text-center table-striped table-hover">
                            <thead class="header" id="myHeader">
                            <tr>
                                <th> S.N.</th>
                                <th> Date</th>
                                <th> Description (Bill#, Challan#) </th>
                                <th> Vch No. </th>
                                <th> Vch Type </th>
                                <th> Debit (Tk.)</th>
                                <th> Credit (Tk.)</th>
                                <th> Balance (Tk.) </th>
                            </tr>

                            </thead>
                            <tbody>
                                @php $i=0;
                                    $opening_balance_query = $opening_amount[0]->bill_amount - $opening_amount[0]->payment_amount;

                                    if($opening_balance_query != '')
                                    {
                                        $opening_balance = $opening_balance_query;
                                        
                                    }else{
                                        $opening_balance = 0;
                                        
                                    }


                                    $payment_total =0;
                                    $billed_total =0;
                                    $balance_total =0;
                                    $usd_total =0;

                                    
                                @endphp
                                <tr> 
                                    <td style="text-align: center;"> 0 </td>
                                    <th style="text-align: center;"> {!! date('d-m-Y', strtotime($start_date))!!} </th>        
                                    <td> Opening Balance </td>     
                                    <td style="text-align: center;"> -- </td>      
                                    <td style="text-align: center;"> -- </td>      
                                    <td style="text-align: right;"> -- </td>      
                                    <td style="text-align: right;"> -- </td>  
                                    <th style="text-align: right;">0.00 Cr</th>                                           
                                </tr>
                                @if(isset($day_book_list[0]->name))
                                @foreach($day_book_list as $row)

                                    @php

                                        $i++;

                                        if(isset($row->db_types) && ($row->db_types =='Payment' || $row->db_types =='Received' || $row->db_types =='Purchase' || $row->db_types =='Sales Return' || $row->db_types =='Commission')){
                                            $payment_amount = $row->amount;
                                            $bill_amount = 0;
                                        }else{
                                            $payment_amount = 0;
                                            $bill_amount = $row->amount;
                                        }

                                        $payment_total += $payment_amount;
                                        $billed_total += $bill_amount;

                                        $total_balance = $opening_balance + $billed_total - $payment_total ;
                                        $usd_balance = $total_balance ;

                                        if($total_balance>0) { $amnt_sign = 'Dr'; } else { $amnt_sign = 'Cr'; }

                                    @endphp
                                    
                                    <tr>
                                        <td style="text-align: center;">{{ $i }}</td>
                                        <td style="text-align: center;">{{ date('d-m-Y', strtotime($row->txn_date)) }}</td>
                                        <td style="text-align: left;">{{ $row->values }}  
                                            <span style="font-size: 10px;">( {{ $row->remarks }} )</span>
                                        </td>                                        
                                        <td style="text-align: center;">VN#{{ $row->sales_id }}</td>
                                        <td style="text-align: center;">{{ $row->db_types }}</td>
                                        <td style="text-align: right;">{{ number_format($bill_amount,2) }}</td>
                                        <td style="text-align: right;">{{ number_format($payment_amount,2) }}</td>
                                        <td style="text-align: right;">{{ number_format($total_balance,2) }} {{ $amnt_sign }}</td>
                                    </tr>

                                    
                                @endforeach
                                
                                <tr> 
                                    <th>#</th>          
                                    <th> {!! date('d-m-Y', strtotime($end_date))!!}</th>  
                                    <th style="text-align: left;"> Closing Balance </th>
                                    <th style="text-align: center;"> -- </th>
                                    <th style="text-align: center;"> -- </th>
                                    <th style="text-align: right;">{{ number_format($billed_total,2) }}</th>
                                    <th style="text-align: right;">{{ number_format($payment_total,2) }}</th>
                                    <th style="text-align: right;">{{ number_format($total_balance,2) }} {{ $amnt_sign }}</th>
                                </tr>
                                @endif
                            </tbody>
                        </table>
                        </div>
                    </div>
@else
<div class="form-group mt-1" style="width:100%; overflow: scroll;" >
<div class="panel-body" id="myTablePrint">
<div class="col-sm-12 text-center">
        

                <br>
        
        @include('layouts.head')
        <h4>Customer's Ledger</h4>
        <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.N.</th>
            <th> ID </th>
            <th> Customer's Name </th>
            <th> Opening Balance (Tk.)</th>
            <th> Debit (Tk.)</th>
            <th> Credit (Tk.)</th>
            <th> Closing Balance (Tk.) </th>
        </tr>

        </thead>
        <tbody>
            @php $i=0;
                $billed_total = 0;
                $received_total = 0;
                $t_opening_balance = 0;
                $t_total_balance = 0;
                $t_o_amnt_sign = 0;
                $t_amnt_sign  = 0;
            @endphp

            @if(isset($opening_amount[0]))
            @foreach($opening_amount as $row)

                @php
                    
                    $i++;

                    $supplier_id = $row['supplier_id'];
                    $name = $row['name'];
                    $open_bill_amount = $row['open_bill_amount'];
                    $open_received_amount = $row['open_received_amount'];

                    $opening_balance = $open_bill_amount - $open_received_amount;
                    $bill_amount = $row['bill_amount'];
                    $received_amount = $row['received_amount'];

                    $total_balance =$opening_balance + $bill_amount - $received_amount ;

                    $received_total += $received_amount;
                    $billed_total += $bill_amount;

                    $t_opening_balance += $opening_balance;
                    $t_total_balance += $total_balance;

                    if($opening_balance>=0) { $o_amnt_sign = 'Dr'; } else { $o_amnt_sign = 'Cr'; }
                    if($t_opening_balance>=0) { $t_o_amnt_sign = 'Dr'; } else { $t_o_amnt_sign = 'Cr'; }
                    if($total_balance>0) { $amnt_sign = 'Dr'; } else { $amnt_sign = 'Cr'; }
                    if($t_total_balance>0) { $t_amnt_sign = 'Dr'; } else { $t_amnt_sign = 'Cr'; }

                @endphp
                
                <tr>
                    <td style="text-align: center;">{{ $i }}</td>
                    <td style="text-align: center;">{{ $supplier_id }}</td>
                    <td style="text-align: left;">{{ $name }}</td>
                    <td style="text-align: right;">{{  number_format($opening_balance,2) }} {{ $o_amnt_sign }}
                    </td>
                    <td style="text-align: right;">{{ number_format($bill_amount,2) }}</td>
                    <td style="text-align: right;">{{ number_format($received_amount,2) }}</td>
                    <td style="text-align: right;">{{ number_format($total_balance,2) }} {{ $amnt_sign }}</td>
                </tr>

                
            @endforeach
            @endif

            <tr> 
                <th>#</th>  
                <th></th>  
                <th style="text-align: left;"> Total = </th>
                <th style="text-align: right;">{{ number_format($t_opening_balance,2) }} {{ $t_o_amnt_sign }}</th>
                <th style="text-align: right;">{{ number_format($billed_total,2) }}</th>
                <th style="text-align: right;">{{ number_format($received_total,2) }}</th>
                <th style="text-align: right;">{{ number_format($t_total_balance,2) }} {{ $t_amnt_sign }}</th>
            </tr>
        </tbody>
    </table>
    </div>
</div>
@endif

<style>

        table#myTable thead#myHeader { background: #D9E5D8; color: #006C32; }
        div#myTablePrint table#myTable tbody tr td {  border: 1px solid; border-collapse: collapse; text-align: left; height: 28px; font-size: 15px;}
        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; }
        .requisitionmas.alert.alert-info { margin-top: 35px; }
        table#myTable thead#myHeader{
                position: sticky;
                top: 0;
                /* width: 109%; */
                background: #D9E5D8;
            }
        
        
    </style>

  
            </div>
        </div>
    </div>
</div>

   

<script>

 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, h4, h5 {text-align: center; margin: 0;}');
       win.document.write('div#myTablePrint table#myTable tbody tr th{border-collapse: collapse; border: 1px solid #000000!important; }');
       win.document.write('div#myTablePrint table#myTable tbody tr td{border-collapse: collapse; border: 1px solid #000000!important; }');
       win.document.write('div#myTablePrint table#myTable thead#myHeader tr th {border-collapse: collapse; border: 1px solid #000000!important;}');
       win.document.write('.col-sm-12.text-center .leftside {text-align: left; float:left!important;}');
       win.document.write('table {border-collapse: collapse;}');
       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();
      }
  }
function valueReset() {
        location.href = "http://localhost/store/public/dailysummaryreport";
    }

    $(window).scroll(function() {
    var scroll = $(window).scrollTop();

    if (scroll >= 100) {
        $("table#myTable").addClass("fixedHeader");
    } else {
        $("table#myTable").removeClass("fixedHeader");
    }
});
jQuery( function($) {
    $( "#start_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
    $( "#end_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
} );


</script>
    
 

@endsection