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

@php

function numberTowords($num)
{ 
$ones = array(
1 => "ONE",
2 => "TWO",
3 => "THREE",
4 => "FOUR",
5 => "FIVE",
6 => "SIX",
7 => "SEVEN",
8 => "EIGHT",
9 => "NINE",
10 => "TEN",
11 => "ELEVEN",
12 => "TWELVE",
13 => "THIRTEEN",
14 => "FOURTEEN",
15 => "FIFTEEN",
16 => "SIXTEEN",
17 => "SEVENTEEN",
18 => "EIGHTEEN",
19 => "NINETEEN"
);
$tens = array(
1 => "TEN",
2 => "TWENTY",
3 => "THIRTY", 
4 => "FORTY", 
5 => "FIFTY", 
6 => "SIXTY", 
7 => "SEVENTY", 
8 => "EIGHTY", 
9 => "NINETY" 
);
$hundreds = array(
"HUNDRED", 
"THOUSAND", 
"MILLION", 
"BILLION", 
"TRILLION", 
"QUARDRILLION" 
);
$num = number_format($num,2,".",",");
$num_arr = explode(".",$num);
$wholenum = $num_arr[0];
$decnum = $num_arr[1];
$whole_arr = array_reverse(explode(",",$wholenum));
krsort($whole_arr);
$words = "";
foreach($whole_arr as $key => $i) {
if($i == 0) {
continue;
}
if($i < 20) {
$words .= $ones[intval($i)];
} elseif($i < 100) {
if(substr($i,0,1) == 0 && strlen($i) == 3) {
$words .= $tens[substr($i,1,1)];
if(substr($i,2,1) != 0) {
$words .= " ".$ones[substr($i,2,1)];
}
} else {
$words .= $tens[substr($i,0,1)];
if(substr($i,1,1) != 0) {
$words .= " ".$ones[substr($i,1,1)];
}
}
} else {
// $words .= $ones[substr($i,0,1)]." ".$hundreds[0];
if(substr($i,1,1) != 0 || substr($i,2,1) != 0) {
$words .= $ones[substr($i,0,1)]." ".$hundreds[0];
} else {
$words .= $ones[substr($i,0,1)]." ".$hundreds[0];
}
if(substr($i,1,2) < 20 && substr($i,1,1) != 0) {
$words .= " ".$ones[(substr($i,1,2))];
} else {
if(substr($i,1,1) != 0) {
$words .= " ".$tens[substr($i,1,1)];
}
if(substr($i,2,1) != 0) {
$words .= " ".$ones[substr($i,2,1)];
}
}
}
if($key > 0) {
$words .= " ".$hundreds[$key]." ";
}
}

$words .= " DOLLAR ";

if($decnum > 0) {
$words .= " AND ";
if($decnum < 20) {
$words .= $ones[intval($decnum)];
} elseif($decnum < 100) {
$words .= $tens[substr($decnum,0,1)];
if(substr($decnum,1,1) != 0) {
$words .= " ".$ones[substr($decnum,1,1)];
}
}
$words .= $subunit??' CENTS ONLY.';
}
else{

$words .= "ONLY.";
}
return $words;
} 


@endphp

  
    <div class="col-md">
        <div class="panel panel-default">
            <div class="panel-heading">
              Foreign Requisition Details 
                <a href="{{ url('/foreignrequisition') }}" 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 ($orders_list[0]->status == 1 && $orders_list[0]->count_status >0 && Auth::user()->parent_id == "0")
                        <a href="{{ url('/re-order/'.$orders_list[0]->id) }}" class="btn btn-warning"> Order </a>  @endif                  
                        @if ($orders_list[0]->status == 0 && Auth::user()->parent_id == "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>
                        <!-- <span title="Download" class="btn btn-success" onclick="exportTableToExcel('myTablePrint')" > <i class="glyphicon glyphicon-download-alt"></i> </span> -->
                    </p>
                </div>
            </div>
<div class="form-group mt-1" style="width:100%; overflow: scroll;" >
 
            <div class="panel-body" id="myTablePrint">

                @if (Session::has('msg'))
                    <div class="alert alert-info">{{ Session::get('msg') }}</div>
                @endif

                <div class="col-sm-12 text-center">
                    @include('layouts.head')
                    <br>
                    <h2><u>Foreign Purchase Requisition</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 Requisition No : WPL/R-0{{ $orders_list[0]->id }}</div>
                      </td>
                      
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Requisition Date : {{date('d-m-Y', strtotime($orders_list[0]->txn_date)) }} </div>
                      </td>
                    </tr>
                    <tr>
                      <td>
                    <div style="float: left; height: 20px;">Supplier 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>Present Stock Qty</th>
                            <th>Last 2 Years Consumption</th>
                            <th>Indent Qty</th>
                            <th>$ Price</th>
                            <th>Last Purchase $ Rate</th>
                            <th>Sub Total $</th>
                            <th>HS Code</th>
                            <th>Item Number</th>
                            <th>LC Number</th>
                            <th>LC Date</th>                            
                            <th>PI Number</th>
                            <th>PI Date</th>
                            <th>Country of Origin</th>
                        </tr>
                    </thead>
                    <tbody>
                    @php $i=0;

                        $torder_quantity = 0;
                        $torder_free = 0;
                        $torder_qty_free = 0;
                        $t_six_month_sales = 0;
                        $t_stock = 0;
                        $grand_total = 0;
                        
                    @endphp

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

                            $stock = $row->product_received - $row->product_sales + $row->product_in - $row->product_out + $row->product_return;

                            $torder_free += $free;
                            $t_stock += $stock;
                            $torder_qty_free += $total_quantity;
                            $grand_total += $total_price;
                            $torder_quantity += $row->quantity;
                            $t_six_month_sales += $row->six_month_sales;

                            $sub_total = $total_price ;
                        @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>{{ $stock }}</td>
                            <td>{{ number_format($row->six_month_sales) }}</td>
                            <td>{{ $row->quantity }}</td>
                            <td>$ {{ number_format($row->dollar,2) }}</td>
                            <td>$ {{ number_format($row->last_dollar_price,2) }}</td>
                            <td>$ {{ number_format($sub_total,2) }}</td>
                            <td>{{$row->hs_code}}</td>
                            <td>{{$row->item_number}}</td>
                            <td>{{$row->lc_number}}</td>
                            <td>{{$row->lc_date}}</td>
                            <td>{{$row->pi_number}}</td>
                            <td>{{$row->pi_date}}</td>
                            <td>{{$row->country_of_origin}}</td>
                        </tr>
                       
                    @endforeach
                        <tr>
                            <th colspan="4">Total =</th>
                            <th>{!! number_format($t_stock) !!}</th>
                            <th>{!! number_format($t_six_month_sales) !!}</th>
                            <th>{!! number_format($torder_quantity) !!}</th>
                            <th></th>
                            <th></th>
                            <th>$ {{ number_format($grand_total,2) }}</th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                        </tr>
                      </tbody>
                      <tfoot>
                        <tr>
                            <td style="text-align:left;" colspan="17"><b>IN WORDS :</b>
                                {!! numberTowords($grand_total) !!}
                            </td>                          
                        </tr>
                        <tr>
                          <td colspan="12"></td>
                        </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><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>Requisition Confirmation <span style="color: red;">(Fill all fields)</span></h4>
                      </header>
                      <content>
                        <form method="post" action="{{ url('/foreignrequisition') }}" enctype="multipart/form-data">
                          {{csrf_field()}}
                                <div class="col-md-2" >
                                    Requisition 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">
                                    Requisition 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="order_id" id="order_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="percentage" id="percentage" value="0"/> 
                                <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();
        }


        function exportTableToExcel(tableID, filename = '',report_header='')
          {
              var downloadLink;
              var dataType = 'application/vnd.ms-excel';
              var tableSelect = document.getElementById(tableID);
              var tableHTML = '';

              if(report_header!='')
              {
                  tableHTML = $("#"+report_header).html();
              } else {
                  tableHTML = '';
              }

              tableHTML = tableHTML + tableSelect.outerHTML.replace(/ /g, '%20');

              // Specify file name
              filename = filename?filename+'.xls':'excel_data.xls';

              // Create download link element
              downloadLink = document.createElement("a");

              document.body.appendChild(downloadLink);

              if(navigator.msSaveOrOpenBlob){
                  var blob = new Blob(['\ufeff', tableHTML], {
                      type: dataType
                  });
                  navigator.msSaveOrOpenBlob( blob, filename);
              }else{
                  // Create a link to the file
                  downloadLink.href = 'data:' + dataType + ', ' + tableHTML;

                  // Setting the file name
                  downloadLink.download = filename;

                  //triggering the function
                  downloadLink.click();
              }
          }
        function valueReset() {
                location.href = "http://localhost/store/public/dailysummaryreport";
            }

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

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

        
    </script>

@endsection