@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 {{ $mainLbl }} Sale Orders
            <a href="{{ $isWarehouse ? route('warehouse-sale-orders.add') : route('pos-sale-orders.create') }}" class="btn btn-info float-right btn-sm"><i class="fa fas fa-plus"></i> Add new {{ $mainLbl }} Sale Order</a>
        </h4>
    </div>
    <div class="card-body">
        <div class="alert alert-default">
            <form action="{{ Route::currentRouteName() == 'pos-sale-orders.index' ? route('pos-sale-orders.index') : route('warehouse-sale-orders.index') }}">
                <h4>Filter {{ $mainLbl }} Sales Orders</h4>
                <table class="table filterPosSo">
                    <tr>
                        <td width="100">REF 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">OUTWARD</td>
                        <td width="100">READY</td>
                        <td width="100">ACCOUNTS</td>
                        <td width="100">DELIVERED</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>
                            <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>
                                @if($isWarehouse)
                                @foreach($ALL_WAREHOUSES as $warehouse)
                                <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                                @endforeach
                                @else
                                @foreach($ALL_POS as $warehouse)
                                <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>{{ $warehouse->warehouse_code . ' ('.$warehouse->name.')' }}</option>
                                @endforeach
                                @endif
                            </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="outward" id="outwards" class="" style="width:50px;">
                                <option value="">All</option>
                                <option value="1" {{ request('outward') == 1 ? 'selected' : '' }}>Yes</option>
                                <option value="0" {{ request('outward') == 0 ? 'checked' : '' }}>No</option>
                            </select>
                        </td>
                        <td>
                            <select name="ready" id="ready" class="" style="width:50px;">
                                <option value="">All</option>
                                <option value="1" {{ request('ready') == 1 ? 'selected' : '' }}>Yes</option>
                                <option value="0" {{ request('ready') == 0 ? 'checked' : '' }}>No</option>
                            </select>
                        </td>
                        <td>
                            <select name="accounts" id="accounts" class="" style="width:50px;">
                                <option value="">All</option>
                                <option value="1" {{ request('accounts') == 1 ? 'selected' : '' }}>Yes</option>
                                <option value="0" {{ request('accounts') == 0 ? 'checked' : '' }}>No</option>
                            </select>
                        </td>
                        <td>
                            <select name="delivered" id="delivered" class="" style="width:50px;">
                                <option value="">All</option>
                                <option value="1" {{ request('delivered') == 1 ? 'selected' : '' }}>Yes</option>
                                <option value="0" {{ request('delivered') == 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>FROM</th>
                    <th>TO</th>
                    <th>DATE</th>
                    <th>SHIPTO</th>
                    <th>ITEMS</th>
                    <th>Order Qty</th>
                    <th>Generated Qty</th>
                    <th>OUTWARD</th>
                    <th>READY</th>
                    <th>ACCOUNTS</th>
                    <th>Invoice Amount</th>
                    <th>Tax Amount</th>
                    <!--th>DELIVERED</th-->
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>
                @if($posSalesOrders->count() > 0)
                @foreach($posSalesOrders as $posSalesOrder)
                <tr>
                    <td>{{ $posSalesOrder->in_ref_no }}</td>
                    <td>{{ $posSalesOrder->warehouse->name }}</td>
                    @if($isWarehouse)
                    <td>{{ $posSalesOrder->twarehouse->name }}</td>
                    @else
                    <td>{{ $posSalesOrder->mwarehouse->name }}</td>
                    @endif
                    <td>{{ $posSalesOrder->order_date }}</td>
                    <td>{{ $posSalesOrder->shipto }}</td>
                    <td>{{ $posSalesOrder->items->where('outward', 1)->count() }}</td>
					<td>
						<?php 														
						 $pr=\DB::table('oc_sales_order_pre_products')->where('pre_sales_id',trim($posSalesOrder->id))->count('qty');
							echo $pr;							
						?><!--{{ $posSalesOrder->products_count }}-->
					</td>
					<td>
					<?php 														
						 $pr=\DB::table('oc_sales_order_pre_products')->where('pre_sales_id',trim($posSalesOrder->id))->where('accounts',1)->count('qty');
						 echo $pr;
														
						?>
							<!--{{ $posSalesOrder->products_delivered }}</td>-->
					
                    <td>{{ empty($posSalesOrder->outward) ? 'No' : 'Yes' }}</td>
                    <td>{{ empty($posSalesOrder->gatepass) ? 'No' : 'Yes' }}</td>
                    <td>{{ empty($posSalesOrder->accounts) ? 'No' : 'Yes' }}</td>
					<td>
							<?php 														
						 $pr=\DB::table('oc_sales_order_pre_products')->where('pre_sales_id',trim($posSalesOrder->id))->where('accounts',1)->sum('finalprc');
							
							echo number_format($pr, 2, '.', '');
							
														
						?>
							<!--{{ $posSalesOrder->grandtotal }}</td>-->
					<td>
							<?php 														
						 $pr=\DB::table('oc_sales_order_pre_products')->where('pre_sales_id',trim($posSalesOrder->id))->where('accounts',1)->sum('igst');
							
							echo number_format($pr, 2, '.', '');
														
						?>
								<!--{{ $posSalesOrder->tax }}</td>-->
                    <!--td>{{ empty($posSalesOrder->delivered) ? 'No' : 'Yes' }}</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-sale-orders.edit',['id' => $posSalesOrder->id]) }}"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-pencil"></i> Modify</small></a>
                              <a class="dropdown-item" href="{{ route('pos-sale-orders-outward',['id' => $posSalesOrder->id]) }}"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-upload"></i> Outward</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> Ready to Send</small></a>
                              <a class="dropdown-item" href="#" onclick="setSaleOrderStatus('accounts',{{ $posSalesOrder->id }}, {{ $posSalesOrder->from_pos }});return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-list"></i> Accounts Approval</small></a>
                              <a class="dropdown-item" href="#" onclick="$('#so_id').val({{ $posSalesOrder->id }});$('#act2').val('print-so-packing-slip');document.sofrm.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Packing Slip</small></a>
                              <a class="dropdown-item" href="#" onclick="$('#so_id').val({{ $posSalesOrder->id }});$('#act2').val('print-so-packing-slip-box-wise');document.sofrm.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Box Packing Slip</small></a>
                              <a class="dropdown-item" href="#" onclick="$('#so_id').val({{ $posSalesOrder->id }});$('#act2').val('print-so-order-slip');document.sofrm.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Order Slip</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>
                              <a class="dropdown-item" href="#" onclick="$('#so_id3').val({{ $posSalesOrder->id }});document.sofrm3.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Invoice XLS</small></a>
                              <a class="dropdown-item" href="#" onclick="$('#sortage_id').val({{ $posSalesOrder->id }});$('#actstorage').val('print-so-sortage-slip');document.sortagefrm.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Sortage Order</small></a>
                              <a class="dropdown-item" href="#" onclick="$('#preinvoice_id').val({{ $posSalesOrder->id }});$('#preinvoice').val('print-pre-invoice-slip');document.preinvoicefrm.submit();return false;"><small style="font-size:11px;font-weight:bold;"><i class="fa fas fa-table"></i> Pre Invoice</small></a>
                           
                            </div>
                        </div>
                    </td>
                </tr>
                @endforeach
                @else
                <tr>
                    <td colspan="10"><div class="alert alert-danger">No sale 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="xls" id="xls" value="0">
            <input type="hidden" name="act" id="act" value="print-so-invoice">
        </form>
        <form action="{{ $postUrl }}" target="_blank" method="post" name="sofrm3">
            <input type="hidden" name="so_id" id="so_id3" value="0">
            <input type="hidden" name="xls" id="xls" value="1">
            <input type="hidden" name="act" id="act" value="print-so-invoice">
        </form>
        <form action="{{ $postUrl }}" target="_blank" method="post" name="sortagefrm">
            <input type="hidden" name="so_id" id="sortage_id" value="0">           
            <input type="hidden" name="act" id="actstorage" value="print-so-sortage-slip">
        </form>
        <form action="{{ $postUrl }}" target="_blank" method="post" name="preinvoicefrm">
             <input type="hidden" name="so_id" id="preinvoice_id" value="0">           
             <input type="hidden" name="act" id="preinvoice" value="print-pre-invoice-slip">
        </form>
        <div class="text-right">
            {!! $posSalesOrders->render() !!}
        </div>
    </div>
</div>
@endsection

@section('extraJs')
@endsection