@extends('layouts.app')
@section('title') {{'Sales Register'}} @endsection
@section('content')
@include('layouts.numbertowords')
    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading">
                Sales Register
                <a href="{{ url('/salesregister') }}" 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-3">
                        Search Customer
                        <select name="id" id="id"data-live-search="true" class="form-control selectpicker">
                            <option value=""> Summary </option>
                            <option value="All" @if(isset($_GET['id']) && ($_GET['id'] == "All")) selected="selected" @endif > All </option>
                            @if(isset($supplier_info))
                                @foreach($supplier_info as $val)
                                    <option value="{{ $val->id }}"  @if(isset($_GET['id']) && ($_GET['id'] == $val->id)) selected="selected" @endif >{{ $val->id }} - {{ $val->name }}</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-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>Sales Register</u></h2>
                    <h5>{!! date('d-F-Y', strtotime($start_date)) !!} to {!! date('d-F-Y', strtotime($end_date)) !!} </h5>
                    <br>
                <table id="myTable" class="table text-center table-striped table-hover">
                  <tbody class="leftsidenobox">
                    
                    @if (isset( $supplier_list[0]->id) &&  $supplier_list[0]->id !='')
                        
                    
                        <tr>
                        <td>
                        <div style="float: left; height: 20px;">Customer Name : {{ $supplier_list[0]->id }} - {{ $supplier_list[0]->name }} </div>
                        </td>
                        </tr>
                        <tr>
                        <td>
                        <div style="float: left; height: 20px;">Contact Person : {{ $supplier_list[0]->person_name }} </div>
                        </td>
                        </tr>
                        <tr>
                        <td>
                        <div style="float: left; height: 20px;">Address : {{ $supplier_list[0]->address }} </div>
                        </td>
                        </tr>
                        <tr>
                        <td>
                        <div style="float: left; height: 20px;">Mobile No. : {{ $supplier_list[0]->mobile }} </div>
                        </td>
                        </tr>
                    @else
                        <td>
                            <div style="float: left; height: 20px;">Customer Name : {{ isset($_GET['id']) && $_GET['id'] == "All" ? "All" : "Summary" }} </div>
                        </td>
                    @endif
                  </tbody>
                    <div>
                    <br>
                    </div>
              </div>
                
                <table id="myTable" class="table text-center table-striped table-hover">
                    @php 
                                    
                        $grand_torder_quantity = 0;
                        $grand_total_price = 0;
                        $grand_total_commission_tk = 0;
                        $grand_total_value = 0;
                        $grand_r_torder_quantity = 0;
                        $grand_r_total_price = 0;
                        $grand_r_total_commission_tk = 0;
                        $grand_r_total_value = 0;
                        $grand_t_total_value = 0;
                    @endphp 
                    <thead class="header" id="myHeader">
                        @if (isset($_GET['id']) &&  $_GET['id'] == 'All')
                            <tr>
                                <th>S.L.</th>
                                <th>ID</th>
                                <th>Item Name</th>
                                <th>Unit</th>
                                <th>Sales Qty</th>
                                <th>Amount</th>
                                <th>Comm. Tk.</th>
                                <th>Sub Total</th>
                            </tr>
                        @elseif (isset($_GET['id']) && $_GET['id'] != "")
                            <tr>
                                <th>S.L.</th>
                                <th>ID</th>
                                <th>Item Name</th>
                                <th>Unit</th>
                                <th>Sales Qty</th>
                                <th>Amount</th>
                                <th>Comm. Tk.</th>
                                <th>Sub Total</th>
                            </tr>
                        @else
                            <tr>
                                <th>S.L.</th>
                                <th>ID</th>
                                <th>Item Name</th>
                                <th>Unit</th>
                                <th>Sales Qty</th>
                                <th>Amount</th>
                                <th>Comm. Tk.</th>
                                <th>Sales Total</th>
                                <th>Return Qty</th>
                                <th>Amount</th>
                                <th>Comm. Tk.</th>
                                <th>Return Total</th>
                                <th>Sub Total</th>
                            </tr>
                        @endif
                        
                    </thead>
                    <tbody>
                        
                    @if (isset($_GET['id']) &&  $_GET['id'] == 'All')
                        @foreach($department_info as $txn_date => $dept)
                        
                            @php
                                $sub_grand_qty = 0;
                                $sub_grand_total = 0;
                                $sub_grand_commission_tk = 0;
                                $sub_grand_total_value = 0;
                            @endphp
                            <tr>
                                <td style="font-weight: 700; text-align: left;" colspan="13"> Date: {!! date('d-F-Y', strtotime($txn_date)) !!}</td>
                            </tr>                        
                            @foreach($dept as $sales_id => $catrow)
                                @php
                                
                                    unset($product_quantity);
                                    $product_id = isset($catrow->product_id) ? explode(',',$catrow->product_id) : [];
                                    $product_qty = isset($catrow->product_qty) ? explode(',',$catrow->product_qty) : [];
                                    
                                    $product_information = [];

                                    foreach ($product_id as $k => $v) 
                                    {
                                        $product_quantity[$v] = 0;
                                        $product_information[$v] = $product_qty[$k];
                                    }
                                    foreach ($product_id as $k => $v) 
                                    {
                                        $product_quantity[$v] += @$product_qty[$k];
                                    }   
                                                    
                                @endphp
                                <tr>
                                    <td style="font-weight: 700; text-align: left;" colspan="13">SI#{{ $sales_id }} {{'- - -'}}Customer Name : {{ $catrow->id }} - {{ $catrow->name }}</td>
                                </tr>
                        
                                @php 
                                    $i = 1;  
                                    $sub_torder_quantity = 0;
                                    $sub_total_price = 0;                          
                                    $sub_commission_tk = 0;
                                    $sub_total_value = 0;                         
                            
                                foreach($product_info as $row)
                                {      
                                    // print_r($product_information[$row->product_id]); 
                                    // print_r($row->product_id); 
                                    //  exit();
                                    $product_qty =  isset($product_information[$row->product_id]) ? $product_information[$row->product_id] : 0;

                                    //$product_qty =  $product_information[$row->product_id];
                                    $product_id = $row->product_id;
                                    $product_name = $row->product_name;
                                    $pack_type = $row->pack_type;
                                    $tp_price = $row->tp_price;
                                    $total = $product_qty;
                                    $commission_tk = $row->t_commission;
                                    $t_price = $row->t_price;
                                    $total_value = $t_price - $commission_tk;

                                    if(isset($product_quantity[$product_id]) && $catrow->sales_id == $row->sales_id)
                                    {
                                        $product_id = $row->product_id;
                                        $product_name = $row->product_name;
                                        $pack_type = $row->pack_type;
                                        $product_qty = $row->quantity;
                                        $tp_price = $row->tp_price;
                                        $commission = $row->commission;
                                        $total = $product_qty;
                                        $amount = $total * $tp_price;
                                        $commission_tk = ($amount * $commission)/100;
                                        $total_value = $amount - $commission_tk;
                                        $t_r_quantity = $row->t_r_quantity;
                                        $t_r_commission = $row->t_r_commission;

                                        $sub_torder_quantity += $product_qty;
                                        $sub_commission_tk += $commission_tk;
                                        $sub_total_price += $amount;
                                        $sub_total_value += $total_value;

                                        echo '<tr>';
                                        echo '<td>'. $i++ .'</td> ';
                                        echo '<td>'. $product_id .'</td> ';
                                        echo '<td style="text-align: left;">'. $product_name .'</td> ';
                                        echo '<td>'. $pack_type .'</td> ';
                                        echo '<td>'. $product_qty .'</td> ';
                                        echo '<td>'. $amount .'</td> ';
                                        echo '<td>'. $commission_tk .'</td> ';
                                        echo '<td >'. $total_value .'</td> ';
                                        echo '</tr>';                         
                                    } 
                                }

                                $sub_grand_qty += $sub_torder_quantity;
                                $sub_grand_total += $sub_total_price;
                                $sub_grand_commission_tk += $sub_commission_tk;
                                $sub_grand_total_value += $sub_total_value;

                                $grand_torder_quantity += $sub_torder_quantity;
                                $grand_total_price += $sub_total_price;
                                $grand_total_commission_tk += $sub_commission_tk;
                                $grand_total_value += $sub_total_value;
                                $grand_t_total_value = $grand_total_value;

                                @endphp
                                <tr>
                                    <th colspan="4">Sub Total =</th>
                                    <th>{!! number_format($sub_torder_quantity) !!}</th>
                                    <th>{!! number_format($sub_total_price,2) !!}</th>
                                    <th>{!! number_format($sub_commission_tk,2) !!}</th>
                                    <th>{!! number_format($sub_total_value,2) !!}</th>
                                </tr>
                                
                            @endforeach
                            <tr>
                                <th colspan="4">Sub Grand Total =</th>
                                <th>{!! number_format($sub_grand_qty) !!}</th>
                                <th>{!! number_format($sub_grand_total,2) !!}</th>
                                <th>{!! number_format($sub_grand_commission_tk,2) !!}</th>
                                <th>{!! number_format($sub_grand_total_value,2) !!}</th>
                            </tr>
                        @endforeach
                        <tr>
                            <th colspan="4">Grand Total =</th>
                            <th>{!! number_format($grand_torder_quantity) !!}</th>
                            <th>{{ number_format($grand_total_price,2) }}</th>
                            <th>{{ number_format($grand_total_commission_tk,2) }}</th>
                            <th>{{ number_format($grand_total_value,2) }}</th>
                        </tr>

                    @elseif (isset($_GET['id']) && $_GET['id'] != "")
                            @foreach($department_info as $sales_id => $catrow)
                                @php
                                    unset($product_quantity);
                                    $product_id = isset($catrow->product_id) ? explode(',',$catrow->product_id) : [];
                                    $product_qty = isset($catrow->product_qty) ? explode(',',$catrow->product_qty) : [];
                                    
                                    foreach ($product_id as $k => $v) 
                                    {
                                        $product_quantity[$v] = 0;
                                    }
                                    foreach ($product_id as $k => $v) 
                                    {
                                        $product_quantity[$v] += @$product_qty[$k];
                                    }   
                                                    
                                @endphp
                                <tr>
                                    <td style="font-weight: 700; text-align: left;" colspan="13">SI#{{ $catrow->sales_id }} - - - Date: {!! date('d-F-Y', strtotime($catrow->txn_date)) !!}</td>
                                </tr>
                            
                                @php 
                                    
                                    $i = 1;  
                                    $sub_torder_quantity = 0;
                                    $sub_total_price = 0;                          
                                    $sub_commission_tk = 0;
                                    $sub_total_value = 0;   
                                
                                foreach($product_info as $row)
                                {
                                    $product_id = $row->product_id;
                                    $product_name = $row->product_name;
                                    $pack_type = $row->pack_type;
                                    $product_qty = $row->t_quantity;
                                    $tp_price = $row->tp_price;
                                    $total = $product_qty;
                                    $amount = $total * $tp_price;
                                    $commission_tk = $row->t_commission;
                                    $total_value = $amount - $commission_tk;

                                    if(isset($product_quantity[$product_id]) && $row->sales_id == $catrow->sales_id)
                                    {
                                        $sub_torder_quantity += $product_qty;
                                        $sub_commission_tk += $commission_tk;
                                        $sub_total_price += $amount;
                                        $sub_total_value += $total_value;

                                        echo '<tr>';
                                        echo '<td>'. $i++ .'</td> ';
                                        echo '<td>'. $product_id .'</td> ';
                                        echo '<td style="text-align: left;">'. $product_name .'</td> ';
                                        echo '<td>'. $pack_type .'</td> ';
                                        echo '<td>'. $product_qty .'</td> ';
                                        echo '<td>'. $amount .'</td> ';
                                        echo '<td>'. $commission_tk .'</td> ';
                                        echo '<td >'. $total_value .'</td> ';
                                        echo '</tr>'; 
                                    } 
                                }

                                $grand_torder_quantity += $sub_torder_quantity;
                                $grand_total_price += $sub_total_price;
                                $grand_total_commission_tk += $sub_commission_tk;
                                $grand_total_value += $sub_total_value;
                                $grand_t_total_value = $grand_total_value;

                                @endphp
                                @if (isset($_GET['id']) && $_GET['id'] != "")
                                <tr>
                                    <th colspan="4">Sub Total =</th>
                                    <th>{!! number_format($sub_torder_quantity) !!}</th>
                                    <th>{!! number_format($sub_total_price,2) !!}</th>
                                    <th>{!! number_format($sub_commission_tk,2) !!}</th>
                                    <th>{!! number_format($sub_total_value,2) !!}</th>
                                </tr>
                                
                            @endif
                            @endforeach
                            <tr>
                                <th colspan="4">Grand Total =</th>
                                <th>{!! number_format($grand_torder_quantity) !!}</th>
                                <th>{{ number_format($grand_total_price,2) }}</th>
                                <th>{{ number_format($grand_total_commission_tk,2) }}</th>
                                <th>{{ number_format($grand_total_value,2) }}</th>
                            </tr>
                    @else
                            @php
                                $product_information = [];
                            @endphp
                            @foreach($department_info as $return_id => $catrow)
                                @php
                                    unset($product_quantity);
                                    $product_id = isset($catrow->product_id) ? explode(',',$catrow->product_id) : [];
                                    $product_qty = isset($catrow->product_qty) ? explode(',',$catrow->product_qty) : [];
                                    
                                    foreach ($product_id as $k => $v) 
                                    {
                                        $product_quantity[$v] = 0;
                                    }
                                    foreach ($product_id as $k => $v) 
                                    {
                                        $product_quantity[$v] += @$product_qty[$k];
                                    }
                                    $sub_torder_quantity = 0;
                                    $sub_total_price = 0;                          
                                    $sub_commission_tk = 0;
                                    $sub_total_value = 0;
                                
                                foreach($product_info as $row)
                                {   

                                    $product_id = $row->product_id;
                                    $product_name = $row->product_name;
                                    $pack_type = $row->pack_type;
                                    $product_qty = $row->quantity;
                                    $tp_price = $row->tp_price;
                                
                                    $commission = $row->commission;
                                    $total = $product_qty;
                                    $commission_tk = $row->t_commission;
                                    $amount = $row->t_price;
                                    $total_value = $amount - $commission_tk;
                                    
                                    $t_r_quantity = $row->t_r_quantity;
                                    $t_r_amount = $t_r_quantity * $tp_price;
                                    $t_r_commission = $row->t_r_commission;

                                    if(isset($product_quantity[$product_id]) && $catrow->sales_id == $row->sales_id)
                                    {
                                        $sub_torder_quantity += $product_qty;
                                        $sub_commission_tk += $commission_tk;
                                        $sub_total_price += $amount;
                                        $sub_total_value += $total_value;
                                        if(!isset($product_information[$product_id]))
                                            $product_information[$product_id] = array('product_id'=>$product_id,'product_name'=>$product_name,'pack_type'=>$pack_type,'t_r_quantity'=>$t_r_quantity,'t_r_commission'=>$t_r_commission,'t_r_amount'=>$t_r_amount);
                                        $product_information[$product_id]['product_qty'] = ($product_information[$product_id]['product_qty'] ?? 0) + $product_qty;
                                        $product_information[$product_id]['amount'] = ($product_information[$product_id]['amount'] ?? 0) + $amount;
                                        $product_information[$product_id]['commission_tk'] = ($product_information[$product_id]['commission_tk'] ?? 0) + $commission_tk;
                                        $product_information[$product_id]['total_value'] = ($product_information[$product_id]['total_value'] ?? 0) + $total_value;                          
                                        //$product_information[$product_id]['t_r_quantity'] = ($product_information[$product_id]['t_r_quantity'] ?? 0) + $t_r_quantity;
                                    } 
                                }
                                
                                $grand_torder_quantity += $sub_torder_quantity;
                                $grand_total_price += $sub_total_price;
                                $grand_total_commission_tk += $sub_commission_tk;
                                $grand_total_value += $sub_total_value;
                                
                                @endphp                                
                            @endforeach
                                @php
                                    $i=1;                               

                                    foreach($product_information as $info){
                                        echo '<tr>';
                                        echo '<td>'. $i++ .'</td> ';
                                        echo '<td>'. $info['product_id'] .'</td> ';
                                        echo '<td style="text-align: left;">'. $info['product_name'] .'</td> ';
                                        echo '<td>'. $info['pack_type'] .'</td> ';
                                        echo '<td>'. $info['product_qty'] .'</td> ';
                                        echo '<td>'. number_format($info['amount'],2) .'</td> ';
                                        echo '<td>'. number_format($info['commission_tk'],2) .'</td> ';
                                        echo '<td>'. number_format($info['total_value'],2) .'</td> ';
                                        echo '<td>'. $info['t_r_quantity'] .'</td> ';
                                        echo '<td>'. number_format($info['t_r_amount'],2) .'</td> ';
                                        echo '<td>'. number_format($info['t_r_commission'],2) .'</td> ';
                                        echo '<td>'. number_format($info['t_r_amount']-$info['t_r_commission'],2) .'</td> ';
                                        echo '<td>'. number_format($info['total_value']-$info['t_r_amount']-$info['t_r_commission'],2) .'</td> ';
                                        echo '</tr>';

                                        $grand_r_torder_quantity += $info['t_r_quantity'];
                                        $grand_r_total_price += $info['t_r_amount'];
                                        $grand_r_total_commission_tk += $info['t_r_commission'];
                                        $grand_r_total_value += $info['t_r_amount']-$info['t_r_commission'];
                                        $grand_t_total_value += $info['total_value']-$info['t_r_amount']-$info['t_r_commission'];
                                    }
                                @endphp
                                <tr>
                                    <th colspan="4">Grand Total =</th>
                                    <th>{!! number_format($grand_torder_quantity) !!}</th>
                                    <th>{{ number_format($grand_total_price,2) }}</th>
                                    <th>{{ number_format($grand_total_commission_tk,2) }}</th>
                                    <th>{{ number_format($grand_total_value,2) }}</th>
                                    <th>{!! number_format($grand_r_torder_quantity) !!}</th>
                                    <th>{{ number_format($grand_r_total_price,2) }}</th>
                                    <th>{{ number_format($grand_r_total_commission_tk,2) }}</th>
                                    <th>{{ number_format($grand_r_total_value,2) }}</th>
                                    <th>{{ number_format($grand_t_total_value,2) }}</th>
                                </tr>
                    @endif
                       
                    
                        <tr>
                            <td style="text-align:left;" colspan="13"><b>IN WORDS :</b> {!! numberTowords($grand_t_total_value) !!}</td>
                        </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 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