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

@include('layouts.numbertowords')

    <div class="col-md">
        <div class="panel panel-default">
            <div class="panel-heading">
                Sales Quotation Details 
                <a href="{{ url('/dailysales') }}" class="pull-right"> Back to List </a>
            </div>
            <div class="col-sm-12 text-center">
                <div class="clearfix">
                    <p class="pull-right">
                        <!-- upload Defect stary -->
                        @if ($sales_info[0]->status == 0 && Auth::user()->parents == "0")
                                <a href="#" class="btn btn-warning" data-toggle="modal" data-target="#defect_description" > Confirm </a>
                        @endif
                        <!-- upload Defect End -->
                        <span title="Print" class="btn btn-primary" onclick="printData('myTablePrint')" > <i class="glyphicon glyphicon-print"> </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 Quotation 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 Quotation No : WTC0{{ $sales_info[0]->id }}</div>
                      </td>
                      
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Quotation Date : {{date('d-m-Y', strtotime($sales_info[0]->txn_date)) }} </div>
                      </td>
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Customer Name : {{ $sales_info[0]->supplier_id }} - {{ $sales_info[0]->name }} </div>
                      </td>
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Contact Person : {{ $sales_info[0]->person_name }} </div>
                      </td>
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Address : {{ $sales_info[0]->address }} </div>
                      </td>
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Mobile No. : {{ $sales_info[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>Returns</th>
                            <th>Sales Quantity</th>
                            <th>Free</th>
                            <th>Sales Price</th>
                            <th>Total</th>
                            <th>Damage</th>
                            <th>Comm. %</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php 
                            $i = 1;               
                            $total = 0;
                            $g_torder_quantity = 0;
                            $g_treturns_quantity = 0;
                            $g_t_quantity = 0;
                            $g_torder_free = 0;
                            $g_t_total_price = 0;
                            $g_t_damage = 0;
                            $g_t_commission = 0;

                        @endphp 
                        
                        @foreach($department_info as $catrow)
                            @php
                                unset($product_quantity);
                                $product_id = explode(',',$catrow->product_id);
                                $product_qty = explode(',',$catrow->product_qty);
                                foreach ($product_id as $k => $v) {
                                    $product_quantity[$v] = $product_qty[$k];
                                }                                                                
                            @endphp
                        <tr>
                            <td colspan="12"> {{ $catrow->department_name }} </td>
                        </tr>                        
                            @php 
                                $torder_quantity = 0;
                                $treturns_quantity = 0;
                                $t_quantity = 0;
                                $torder_free = 0;
                                $t_total_price = 0;
                                $t_damage = 0;
                                $t_commission = 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;
                                    $returns = $row->returns;
                                    $free = $row->free;
                                    $tp_price = $row->tp_price;
                                    $damage = $row->damage;
                                    $commission = $row->commission;
                                    $total = $product_qty - $returns;
                                    $total_value = $total * $tp_price;

                                    if(isset($product_quantity[$product_id]))
                                    {
                                        $torder_quantity += $product_qty;
                                        $treturns_quantity += $returns;
                                        $t_quantity += $total;
                                        $torder_free += $free;
                                        $t_total_price += $total_value;
                                        $t_damage += $damage;
                                        $t_commission += $commission;

                                        echo '<tr>';
                                        echo '<td>'. $i++ .'</td> ';
                                        echo '<td>'. $product_id .'</td> ';
                                        echo '<td style="text-align: left;">'. $product_name .'</td> ';
                                        echo '<td style="text-align: left;">'. $pack_type .'</td> ';
                                        echo '<td>'. $product_qty .'</td> ';
                                        echo '<td>'. $returns .'</td> ';
                                        echo '<td>'. $total .'</td> ';
                                        echo '<td>'. $free .'</td> ';
                                        echo '<td>'. $tp_price .'</td> ';
                                        echo '<td>'. $total_value .'</td> ';
                                        echo '<td>'. $damage .'</td> ';
                                        echo '<td>'. $commission .'</td> ';
                                        echo '</tr>';                         
                                    } 
                                }

                                $g_torder_quantity += $torder_quantity;
                                $g_treturns_quantity += $treturns_quantity;
                                $g_t_quantity += $t_quantity;
                                $g_torder_free += $torder_free;
                                $g_t_total_price += $t_total_price;
                                $g_t_damage += $t_damage;
                                $g_t_commission += $t_commission;

                            @endphp
                        <tr>
                            <th colspan="4">Sub Total =</th>
                            <th>{!! number_format($torder_quantity) !!}</th>
                            <th>{!! number_format($treturns_quantity) !!}</th>
                            <th>{!! number_format($t_quantity) !!}</th>
                            <th>{!! $torder_free !!}</th>
                            <th></th>
                            <th>{!! number_format($t_total_price,2) !!}</th>
                            <th>{!! number_format($t_damage) !!}</th>
                            <th>{!! number_format($t_commission) !!}</th>
                        </tr>
                            
                        @endforeach
                        <tr>
                            <th colspan="4">Grand Total =</th>
                            <th>{!! number_format($g_torder_quantity) !!}</th>
                            <th>{!! number_format($g_treturns_quantity) !!}</th>
                            <th>{!! number_format($g_t_quantity) !!}</th>
                            <th>{{ $g_torder_free }}</th>
                            <th></th>
                            <th>{{ number_format($g_t_total_price,2) }}</th>
                            <th>{!! number_format($g_t_damage) !!}</th>
                            <th>{!! number_format($g_t_commission) !!}</th>
                        </tr>
                    
                        <tr>
                            <td style="text-align:left;" colspan="12"><b>IN WORDS :</b> {!! numberTowords($g_t_total_price) !!}</td>
                        </tr>
                    </tbody>
                </table>

                <div class="col-sm-12 marginleft">
                <div class="col-sm-6 margintop">
                    <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>Party Name</th>
                                <th>Due Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                        @php $i=0;
                            $t_due = 0;                            
                        @endphp

                        @foreach($due_info as $row)
                            @php
                                $i++;
                                $t_due += $row->amount;
                                

                            @endphp
                            <tr>
                                <td>{{ $i }}</td>
                                <td>{{ $row->id }}</td>
                                <td style="text-align: left;">{{ $row->name }}</td>
                                <td>{{ number_format($row->amount,2) }}</td>
                            </tr>
                           
                        @endforeach
                            <tr>
                                <th colspan="3">Total =</th>
                                <th>{{ number_format($t_due,2) }}</th>
                            </tr>
                            <tr>
                                <td style="text-align:left;" colspan="12"><b>IN WORDS :</b> {!! numberTowords($t_due) !!}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
                <div class="col-sm-6 margintop">
                    <table id="myTable" class="table text-center table-striped table-hover">
                        <thead class="header" id="myHeader">
                            <tr>
                                <th>S.L.</th>
                                <th>Cost Details</th>
                                <th>Cost Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                        @php $i=0;
                            $t_cost = 0;                            
                        @endphp

                        @foreach($cost_info as $row)
                            @php
                                $i++;
                                $t_cost += $row->cost_amount;
                            @endphp
                            <tr>
                                <td>{{ $i }}</td>
                                <td style="text-align: left;">{{ $row->values }}</td>
                                <td>{{ number_format($row->cost_amount,2) }}</td>
                            </tr>                           
                        @endforeach
                            <tr>
                                <th colspan="2">Total =</th>
                                <th>{{ number_format($t_cost,2) }}</th>
                            </tr>
                            <tr>
                                <td style="text-align:left;" colspan="12"><b>IN WORDS :</b> {!! numberTowords($t_cost) !!}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
                </div>
                <div class="col-sm-12 margintop">
                    <table id="myTable" class="table text-center table-striped table-hover">
                        <thead class="header" id="myHeader">
                            <tr>
                                <th colspan="3">Debit (Tk.)</th>
                                <th colspan="3">Credit (Tk.)</th>
                            </tr>
                            <tr>
                                <th>S.L.</th>
                                <th>Details</th>
                                <th>Amount</th>
                                <th>S.L.</th>
                                <th>Details</th>
                                <th>Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php 
                                $payable =$g_t_total_price - ($t_cost + $t_due + $g_t_commission) ;
                                $total = $t_cost + $t_due + $payable + $g_t_commission;
                            @endphp
                            <tr>
                                <td>1</td>
                                <td>Due Amount</td>
                                <td>{{ number_format($t_due,2) }}</td>

                                <td>1</td>
                                <td>Sales Amount</td>
                                <td>{{ number_format($g_t_total_price,2) }}</td>
                            </tr>
                            <tr>
                                <td>2</td>
                                <td>Cost Amount</td>
                                <td>{{ number_format($t_cost,2) }}</td>

                                <td>2</td>
                                <td>-</td>
                                <td>0</td>
                            </tr>
                            <tr>
                                <td>3</td>
                                <td>Product Commission</td>
                                <td>{{ number_format($g_t_commission,2) }}</td>

                                <td>3</td>
                                <td>-</td>
                                <td>0</td>
                            </tr>
                            <tr>
                                <td>4</td>
                                <td>Payable Amount</td>
                                <td>{{ number_format($payable,2) }}</td>

                                <td>4</td>
                                <td>-</td>
                                <td>0</td>
                            </tr>
                            <tr>
                                <th colspan="2">Total =</th>
                                <th>{{ number_format($total,2) }}</th>
                                <th colspan="2">Total =</th>
                                <th>{{ number_format($g_t_total_price,2) }}</th>
                            </tr>
                            <tr>
                                <td style="text-align:center;" colspan="12"><b>Payable Amount : {!! number_format($payable,2) !!}</b> </td>
                            </tr>
                            <tr>
                                <td style="text-align:left;" colspan="12"><b>IN WORDS :</b>
                                @if($payable>=0)
                                    {!! numberTowords($payable) !!}
                                @else
                                    Sorry! The amount is minus = {!! ($payable) !!}
                                @endif

                                </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>
    </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>Sales Confirmation <span style="color: red;">(Fill all fields)</span></h4>
                      </header>
                      <content>
                        <form method="post" action="{{ url('/confirmdailysales') }}" enctype="multipart/form-data">
                          {{csrf_field()}}
                                <div class="col-md-2" >
                                    Sales Date :
                                    <input id="txn_date" type="text" class="form-control" name="txn_date" value="2026-06-13" autocomplete="off" required >
                                </div>
                                <div class="col-md-2">
                                    Sales No. :
                                    <input type="text" name="sales_id" readonly="" class="form-control" value="{!! $sales_info[0]->sales_id !!}"  >
                                </div>                                
                                <br/> 
                                <button type="submit" class="btn btn-info"><i class="glyphicon glyphicon-check"></i> Submit</button>

                                <input type="hidden" name="supplier_id" id="supplier_id" value="{!! $sales_info[0]->supplier_id !!}"/> 
                                <input type="hidden" name="debit_amount" id="debit_amount" value="{!! $g_t_total_price !!}"/> 
                                <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