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

@include('layouts.numbertowords')

  
    <div class="col-md">
        <div class="panel panel-default">
            <div class="panel-heading">
                Sales Details 
                <a href="{{ url('/sales') }}" class="pull-right"> Back </a>
            </div>
            <div class="col-sm-12 text-center">
                <div class="clearfix">
                    <p class="pull-right">
                        <!-- upload Defect stary -->
                        @if ($orders_list[0]->status == 0)
                              <!-- upload Inspection AQL stary -->
                          <a href="#" class="btn btn-warning" data-toggle="modal" data-target="#add_cash" > Add Cash </a>
                          <a href="#" class="btn btn-warning" data-toggle="modal" data-target="#add_commission" > Commission %</a>
                            <!-- upload Inspection AQL End -->
                        
                        @if (Auth::user()->parent_id == "0")
                          <a href="#" class="btn btn-warning" data-toggle="modal" data-target="#defect_description" > Confirm </a>
                        @endif
                        @endif
                        <!-- upload Defect End -->
                        <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>Invoice/Delivery 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;">WPL Sales No : WPL0{{ $orders_list[0]->id }}</div>
                      </td>
                      
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Sales 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 colspan="3">Product Name</th>
                            <th>Unit</th>
                            <th>Quantity</th>
                            <th>Free</th>
                            <th>TP Price</th>
                            <th>Amount</th>
                            <th>Comm. %</th>
                            <th>Comm. Tk.</th>
                            <th>Sub Total</th>
                        </tr>
                    </thead>
                    <tbody>
                    @php $i=0;

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

                    @foreach($orders_list as $row)
                        @php
                            $i++;
                            $txn_date = $row->txn_date;
                            $free = $row->free;
                            $total_quantity = $row->quantity * $row->tp_price + $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;
                            $total_commission += $row->commission;

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

                            $total_commission_tk += $commission_tk;
                            $cash_amount = $row->cash_amount;

                            $sub_total = $total_price - $commission_tk;
                            $grand_total = $t_total_price - $total_commission_tk;
                            $commission_amount = ($grand_total * $row->commission_per)/100;
                            $due_balance = $grand_total - $cash_amount - $commission_amount;

                        @endphp
                        <tr>
                            <td>{{ $i }}</td>
                            <td >{{ $row->product_id }}</td>
                            <td colspan="3" style="text-align: left;">{{ $row->product_name }}</td>
                            <td>{{ $row->pack_type }}</td>
                            <td>{{ $row->quantity }}</td>
                            <td>{{ $free }}</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="6">Total =</th>
                            <th>{!! number_format($torder_quantity) !!}</th>
                            <th>{{ $torder_free }}</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>
                      </tbody>
                      <tfoot>
                        <tr>
                            <td style="text-align:left;" colspan="9"><b>IN WORDS :</b> 
                            @if($due_balance>=0)
                                {!! numberTowords($due_balance) !!}
                            @else
                                Sorry! The amount is minus = {!! ($due_balance) !!}
                            @endif
                            </td>
                        
                          <th style="text-align:right;" colspan="2">Receivable Amount :</th>
                          <th style="text-align:right;" colspan="2"> {{ number_format($grand_total,2) }}</th>
                        </tr>
                        <tr> 
                          <td colspan="9"></td>
                          <th style="text-align:right;" colspan="2">Comm. Tk. {!! number_format($row->commission_per,2) !!} %: </th>
                          <th style="text-align:right;" colspan="2">{{ number_format($commission_amount,2) }}</th>
                        </tr>
                        <tr>
                          <td colspan="9"></td>
                          <th style="text-align:right;" colspan="2">Cash Received : </th>
                          <th style="text-align:right;" colspan="2">{{ number_format($cash_amount,2) }}</th>
                        </tr>
                        <tr>
                          <td colspan="9"></td>
                          <th style="text-align:right;" colspan="2">Due Balance :</th>
                          <th style="text-align:right;" colspan="2"> {{ number_format($due_balance,2) }}</th>
                        </tr>
                    @php 

                    // $Previous_balance = @$supp_balance->amount;
                    // $Current_balance = $Previous_balance + $due_balance;
                    $Current_balance = @$supp_balance->amount;
                    $Previous_balance = $Current_balance-$due_balance;
                    if ($orders_list[0]->status == 0){
                      $Previous_balance=$Current_balance;
                      $Current_balance += $due_balance;
                    }
                        
                    @endphp
                        <tr>
                          <td colspan="9"></td>
                          <th style="text-align:right;" colspan="2">Previous Balance : </th>
                          <th style="text-align:right;" colspan="2">{{ number_format($Previous_balance,2) }}</th>
                        </tr>
                        <tr>
                          <td colspan="9"></td>
                          <th style="text-align:right;" colspan="2">Current Balance :</th>
                          <th style="text-align:right;" colspan="2"> {{ number_format($Current_balance,2) }}</th>
                        </tr>
                        <tr>
                          <td><br></td>
                        </tr>
                        <tr>
                          <td colspan="10"></td>
                          <th colspan="3" style="text-align:center;">For,  </th>
                        </tr>
                        
                        <tr>
                          <td><br></td>
                        </tr>
                        <tr>
                          <td><br></td>
                        </tr>
                        <tr>
                          <td colspan="10"></td>
                          <th colspan="3" style="text-align:center;"> Authorized Signatory</th>
                        </tr>
                        
                    </tfoot>
                </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="defect_description">
                    <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="experience_section education">
                      <header>
                          <h4>Invoice Confirmation <span style="color: red;">(Fill all fields)</span></h4>
                      </header>
                      <content>
                        <form method="post" action="{{ url('/sales') }}" enctype="multipart/form-data">
                          {{csrf_field()}}
                                <div class="col-md-2" >
                                    Invoice 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">
                                    Invoice No. :
                                    <input type="text" name="invoice_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="sales_id" id="sales_id" value="{!! $orders_list[0]->id !!}"/> 
                                <input type="hidden" name="supplier_id" id="supplier_id" value="{!! $orders_list[0]->supplier_id !!}"/> 
                                <input type="hidden" name="due_amount" id="due_amount" value="{!! $due_balance !!}"/> 
                                <input type="hidden" name="receivable_amount" id="receivable_amount" value="{!! $grand_total !!}"/> 
                                <input type="hidden" name="percentage" id="percentage" value="{!! $total_commission !!}"/> 
                                <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 -->
        <!-- Add Cash start -->
        <div class="modal fade" id="add_cash">
            <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="experience_section education">
                      <header>
                          <h4>Add Cash Received <span style="color: red;">(*)</span></h4>
                      </header>
                      <content>
                        <form method="post" action="{{ url('/sales') }}" enctype="multipart/form-data">
                          {{csrf_field()}}
                            
                                <div class="col-md-3" >
                                    Cash Received
                                    <input type="number" name="add_cash_amounts" id="add_cash_amounts" style="height: 34px;">
                                    
                                </div>
                                <div class="col-md-2" ><br/> &nbsp;
                                <button type="submit" class="btn btn-info pull-left"  ><i class="glyphicon glyphicon-check"></i> Submit</button>
                                </div>
                                <input type="hidden" name="id" id="id" value="{!! $orders_list[0]->id !!}"/>
                                <input type="hidden" name="supplier_id" id="supplier_id" value="{!! $orders_list[0]->supplier_id !!}"/> 
                                <input type="hidden" name="txn_date" id="txn_date" value="{!! $orders_list[0]->txn_date !!}"/> 
                                <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 Inspection Level AQL model End -->

        <!-- Add Commission start -->
        <div class="modal fade" id="add_commission">
            <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="experience_section education">
                      <header>
                          <h4>Add Commission % <span style="color: red;">(*)</span></h4>
                      </header>
                      <content>
                        <form method="post" action="{{ url('/sales') }}" enctype="multipart/form-data">
                          {{csrf_field()}}
                            
                                <div class="col-md-3" >
                                    Commission
                                    <input type="text" name="commission_per" id="commission_per" style="height: 34px;">
                                    
                                </div>
                                <div class="col-md-2" ><br/> &nbsp;
                                <button type="submit" class="btn btn-info pull-left"  ><i class="glyphicon glyphicon-check"></i> Submit</button>
                                </div>
                                <input type="hidden" name="id" id="id" value="{!! $orders_list[0]->id !!}"/> 
                                <input type="hidden" name="supplier_id" id="supplier_id" value="{!! $orders_list[0]->supplier_id !!}"/> 
                                <input type="hidden" name="txn_date" id="txn_date" value="{!! $orders_list[0]->txn_date !!}"/> 
                                <input type="hidden" name="grand_total" id="grand_total" value="{!! $grand_total !!}"/> 
                                <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 Inspection Level AQL model End -->
      

@endsection