@extends('layouts.app')
@section('title') {{'Sales Return Details'}} @endsection
@section('content')

@include('layouts.numbertowords')

  
    <div class="col-md">
        <div class="panel panel-default">
            <div class="panel-heading">
                Sales Return Details 
                <a href="{{ url('/returnslist') }}" class="pull-right"> Back </a>
            </div>
            <div class="col-sm-12 text-center">
                <div class="clearfix">
                    <p class="pull-right">
                        @if ($orders_list[0]->status == 0 && Auth::user()->parent_id == "0")
                          <a href="#" class="btn btn-warning" data-toggle="modal" data-target="#for_confirm" > Confirm </a>
                        @endif
                        <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>
            @if (Session::has('msg'))
                    <div class="alert alert-info">{{ Session::get('msg') }}</div>
                @endif
<div class="form-group mt-1" style="width:100%; overflow: scroll;" >

            <div class="panel-body" id="myTablePrint">

                
                <div class="col-sm-12 text-center">
                    @include('layouts.head')
                    <br>
                    <h2><u> Sales Return Challan</u></h2>
                    <br>
                <table id="myTable" class="table text-center table-striped table-hover">
                  <tbody class="leftsidenobox">
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">WTC Sales Return No : WTC/SRI-{{ $orders_list[0]->id }}</div>
                      </td>
                      
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Return Date : {{date('d-m-Y', strtotime($orders_list[0]->txn_date)) }} </div>
                      </td>
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Customer Name : {{ $orders_list[0]->supplier_id }} - {{ $orders_list[0]->name }} </div>
                      </td>
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Contact Person : {{ $orders_list[0]->person_name }} </div>
                      </td>
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Address : {{ $orders_list[0]->address }} </div>
                      </td>
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Mobile No. : {{ $orders_list[0]->mobile }} </div>
                      </td>
                    </tr>
                  </tbody>
                    <div>
                    <br>
                    </div>
                </div>                

                <table id="myTable" class="table text-center table-striped table-hover">
                    <thead class="header" id="myHeader">
                        <tr>
                            <th>S.L.</th>
                            <th>ID</th>
                            <th>Item Name</th>
                            <th>Unit</th>
                            <th>Quantity</th>
                            <th>Sales Price</th> 
                            <th>Amount</th>
                            <th>Comm. %</th>
                            <th>Comm. Tk.</th>
                            <th>Total</th>
                        </tr>
                    </thead>
                    <tbody>
                    @php $i=0;

                        $torder_quantity = 0;
                        $torder_free = 0;
                        $torder_qty_free = 0;
                        $t_total_price = 0;
                        $total_commission_tk = 0;
                        
                    @endphp

                    @foreach($orders_list as $row)
                        @php
                            $i++;
                            $txn_date = $row->txn_date;
                            $free = $row->quantity * $row->free;
                            $total_quantity = $row->quantity + $free;
                            $total_price = $row->quantity * $row->tp_price;


                            $torder_free += $free;
                            $torder_qty_free += $total_quantity;
                            $t_total_price += $total_price;
                            $torder_quantity += $row->quantity;

                            $commission_tk = ($total_price * $row->commission)/100;

                            $total_commission_tk += $commission_tk;
                  
                            $sub_total = $total_price - $commission_tk;
                            $grand_total = $t_total_price - $total_commission_tk;

                        @endphp
                        <tr>
                            <td>{{ $i }}</td>
                            <td>{{ $row->product_id }}</td>
                            <td style="text-align: left;">{{ $row->product_name }}</td>
                            <td>{{ $row->pack_type }}</td>
                            <td>{{ $row->quantity }}</td>
                            <td>{{ number_format($row->tp_price,2) }}</td>
                            <td>{{ number_format($total_price,2) }}</td>
                            <td>{{ number_format($row->commission,2) }}</td>
                            <td>{{ number_format($commission_tk,2) }}</td>
                            <td>{{ number_format($sub_total,2) }}</td>
                            

                        </tr>
                       
                    @endforeach
                        <tr>
                            <th colspan="4">Total =</th>
                            <th>{!! number_format($torder_quantity) !!}</th>
                            <th></th>
                            <th>{{ number_format($t_total_price,2) }}</th>
                            <th></th>
                            <th>{{ number_format($total_commission_tk,2) }}</th>                            
                            <th>{{ number_format($grand_total,2) }}</th>
                        </tr>
                        <tr>
                            <td style="text-align:left;" colspan="12"><b>IN WORDS :</b> {!! numberTowords($grand_total) !!}</td>
                        </tr>
                    </tbody>
                </table>

                <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;}
                    thead th {border-collapse: collapse; border-right: 1px solid #000000 !important; }
                    div#myTablePrint table#myTable tbody.leftsidenobox tr td {border: none;}
                    div#myTablePrint table#myTable thead#myHeader tr th { border: 1px solid #000000!important; text-align:center; height: 25px; font-size: 18px;}
                    div#myTablePrint table#myTable tbody tr th{ border: 1px solid #000000!important; height: 25px; font-size: 18px;}
                    thead th { border-right: 1px solid #000000 !important; text-align: left; font-size: 18px;}
                    table#myTable thead#myHeader{
                        position: sticky;
                        top: 0;
                        /* width: 109%; */
                        background: #D9E5D8;
                    }
                </style>
            </div>
            </div>
        </div>
    </div>

<!-- upload Defect Description model start -->
         <div class="modal fade" id="for_confirm">
            <div class="modal-dialog modal-lg">
              <div class="modal-content">
              
                <!-- Modal Header -->
                <div class="modal-header">
                  <button type="button" class="close" data-dismiss="modal">&times;</button>
                </div>
                
    <!-- Modal body -->
          <div class="modal-body">
                <div class="for_confirm education">
              <header>
                  <h4>Return Confirmation <span style="color: red;">(Fill all fields)</span></h4>
              </header>
              <content>
                <form method="post" action="{{ url('/returnslist') }}" enctype="multipart/form-data">
                  {{csrf_field()}}
                        <div class="col-md-2" >
                            Return Date :
                            <input id="txn_date" type="text" class="form-control" name="txn_date" value="2026-06-04" autocomplete="off" required >
                        </div>
                        <div class="col-md-2">
                            Return No. :
                            <input type="text" name="return_id" readonly="" class="form-control" value="{!! $orders_list[0]->id !!}"  >
                        </div>
                        
                        <br/> 
                        <button type="submit" class="btn btn-info"><i class="glyphicon glyphicon-check"></i> Submit</button>
                        <input type="hidden" name="due_amount" id="due_amount" value="{!! $grand_total !!}"/>
                        <input type="hidden" name="supplier_id" id="supplier_id" value="{!! $orders_list[0]->supplier_id !!}"/>
                        <input type="hidden" name="_token" value="{{ csrf_token() }}"/> 
                </form>
              </content>
          </div>

        </div>
        
        <!-- Modal footer -->
        <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        </div>
        
      </div>
    </div>
</div>
        <!-- upload Defect Description model End -->

    <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();
        }
        jQuery( function($) {
            $( "#txn_date" ).datepicker(
                {
                  dateFormat: "yy-mm-dd"
                }
            );
        } 
        );
    </script>
 

@endsection