@extends('layouts.backend')

@section('extraCss')
<style>
    .select2-container--open .select2-dropdown--below {
        min-width:200px !important;
    }
    .tblPosOrdList td, .tblPosOrdList th {
        font-size:12px;
    }
</style>
@endsection

@section('mainContentArea')
<div class="card card-default">
    <div class="card-header">
        <h4>
            Manage POS Purchase Orders
        </h4>
    </div>
    <div class="card-body">
        <div class="alert alert-default">
            <form action="{{ route('pos-po.index') }}">
                <h4>Filter POS Purchase Orders</h4>
                <table class="table filterPosSo">
                    <tr>
                        <!--td width="100">REF NO#</td-->
                        <td width="100">Invoice NO#</td>
                        <td width="150">FROM</td>
                        <td width="150">TO</td>
                        <td width="150">DATE FROM</td>
                        <td width="150">DATE TO</td>
                        <td width="100">INFACTORY</td>
                        <td width="100">INWARD</td>
                        <td colspan="2">ACTION</td>
                    </tr>
                    <tr>
                        <!--td>
                            <input name="manual_ref_no" id="manual_ref_nos" class="form-control" value="{{ request('manual_ref_no') }}" style="width:100px;">
                        </td-->
						<td>
                            <input name="in_no" id="in_nos" class="form-control" value="{{ request('in_no') }}" style="width:100px;">
                        </td>
                        <td>
                            <select name="from_pos" id="from_pos" class="select2"  style="width:150px;">
                                <option value="">Any</option>
                                @foreach($ALL_WAREHOUSES as $warehouse)
                                <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                                @endforeach
                            </select>
                        </td>
                        <td>
                            <select name="to_pos" id="to_poss" class="select2" style="width:150px;">
                                <option value="">Any</option>
                                
								@foreach($ALL_POS as $warehouse)
                                <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                                @endforeach
                            </select>
                        </td>
                        <td>
                            <input name="datefrom" id="datefrom" class="form-control datepicker" value="{{ request('datefrom') }}" style="width:150px;">
                        </td>
                        <td>
                            <input name="dateto" id="dateto" class="form-control datepicker" value="{{ request('dateto') }}" style="width:150px;">
                        </td>
                        <td>
                            <select name="gatepass" id="gatepass" class="" style="width:50px;">
                                <option value="">All</option>
                                <option value="1" {{ request('gatepass') == 1 ? 'selected' : '' }}>Yes</option>
                                <option value="0" {{ request('gatepass') == 0 ? 'checked' : '' }}>No</option>
                            </select>
                        </td>
                        <td>
                            <select name="inward" id="inwards" class="" style="width:50px;">
                                <option value="">All</option>
                                <option value="1" {{ request('inward') == 1 ? 'selected' : '' }}>Yes</option>
                                <option value="0" {{ request('inward') == 0 ? 'checked' : '' }}>No</option>
                            </select>
                        </td>
                        <td><button class="btn btn-block btn-success"><i class="fa fas fa-search"></i></button></td>
                        <td><button class="btn btn-block btn-warning" type="button" onclick="window.location.href='{{ route('pos-sale-orders.index') }}';"><i class="fa fas fa-refresh"></i></button></td>
                    </tr>
                </table>
            </form>
        </div>
        <table class="table table-bordered tblPosOrdList">
            <thead>
                <tr>
                    <th>REF#</th>
					<th>Invoice NO</th>
                    <th>FROM</th>
                    <th>TO</th>
                    <th>DATE</th>
                    <th>SHIPBY</th>
                    <!--th>ITEMS</th-->
                    <th>Order qty</th>
                    <th>Received qty</th>					
                    <!--th>INFACTORY</th-->
                    <th>INWARD</th>
                    <th>Bill value</th>
                    <th>Total Tax</th>
					
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>              
                @if($posSalesOrders->count() > 0)
                @foreach($posSalesOrders as $posSalesOrder)
                	<?php $finalprc=0;
						  $totaltax=0; 
					?>
                <tr>               
                    <td>{{ $posSalesOrder->in_ref_no }}</td>
                    <td>{{ $posSalesOrder->salesOrder->in_ref_no }}</td>
                    <td>{{ $posSalesOrder->warehouse->name }}</td>
                    <td>{{ $posSalesOrder->pos->name }}</td>
                    <td>{{ $posSalesOrder->order_date }}</td>
                    <td>{{ $posSalesOrder->shipto }}</td>
                    <!--td>{{ $posSalesOrder->products_delivered }}</td-->
                    <td> <?php 														
						 $pr=\DB::table('oc_sales_order_pre_products')->where('prid',trim($posSalesOrder->id))->where('accounts',1)->count('qty');
							echo $pr;							
						?></td>
                    <td> <?php 														
						 $pr=\DB::table('oc_purchase_order_pre_products')->where('pre_purchase_id',trim($posSalesOrder->id))->where('inwarded',1)->count('qty');
							echo $pr;							
						?></td>
                    <!--td>{{ empty($posSalesOrder->gatepass) ? 'No' : 'Yes' }}</td-->
                    <td> {{ empty($posSalesOrder->inward) ? 'No' : 'Yes' }}</td>					
                    <td> <!--{{ $posSalesOrder->grandtotal }}-->
						<?php 														
						 $pr=\DB::table('oc_sales_order_pre_products')->where('prid',trim($posSalesOrder->id))->where('accounts',1)->sum('finalprc');
							
							echo number_format($pr, 2, '.', '');
														
						?>
					</td>					
                    <td>
                       <!-- {{ $posSalesOrder->tax}} -->
					   <?php 														
						 $pr=\DB::table('oc_sales_order_pre_products')->where('prid',trim($posSalesOrder->id))->where('accounts',1)->sum('igst');
							echo number_format($pr, 2, '.', '');						
						?>
                      
                    </td>
                    <td width="100">
                        <div class="dropdown">
                            <button type="button" class="btn btn-primary btn-sm btn-block dropdown-toggle" data-toggle="dropdown">
                              Actions
                            </button>
                            <div class="dropdown-menu">
                                <a class="dropdown-item" href="{{ route('pos-po.edit',['id' => $posSalesOrder->id]) }}"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-eye"></i> View</small></a>
                                <a class="dropdown-item" href="{{ route('pos-po-assign',['id' => $posSalesOrder->id]) }}"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-plus"></i> Assign Barcodes</small></a>
                                {{-- <a class="dropdown-item" href="#" onclick="setSaleOrderStatus('gatepass',{{ $posSalesOrder->id }}, {{ $posSalesOrder->from_pos }});return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-gear"></i> InFactory</small></a> --}}
                                <a class="dropdown-item" href="{{ route('pos-po-inward',['id' => $posSalesOrder->id]) }}"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-upload"></i> Inward</small></a> 
                                <a class="dropdown-item" href="#" onclick="$('#so_id2').val({{ $posSalesOrder->id }});document.sofrm2.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Invoice</small></a>
                            </div>
                        </div>
                    </td>
                </tr>
                @endforeach
                @else
                <tr>
                    <td colspan="8"><div class="alert alert-danger">No Purchase order found!</div></td>
                </tr>
                @endif
            </tbody>
        </table>
        {{--  --}}
        @php
            $urlHost = request()->getHttpHost();
            if(strstr($urlHost, 'localhost')) {
                $postUrl = 'http://localhost/sutionline/suti-pos/process.php';
            } else {
                $postUrl = 'https://www.sutionline.com/suti-pos/process.php';
            }
        @endphp
        <form action="{{ $postUrl }}" target="_blank" method="post" name="sofrm">
            <input type="hidden" name="so_id" id="so_id" value="0">
            <input type="hidden" name="act" id="act2" value="">
        </form>
        <form action="{{ $postUrl }}" target="_blank" method="post" name="sofrm2">
            <input type="hidden" name="so_id" id="so_id2" value="0">
            <input type="hidden" name="act" id="act" value="print-po-invoice">
        </form>
        {{--  --}}
        <div class="text-right">
            {!! $posSalesOrders->render() !!}
        </div>
    </div>
</div>
@endsection

@section('extraJs')
@endsection