@extends('admin.layouts.master')
@section('title', 'Stock')
@section('content')
    <style>
        .some-text {
            color: red;
            font-style: italic;
            font-size: 15px;
        }

        .help-block {
            color: red;
            font-size: 13px;
            font-weight: normal;
        }

        input::-webkit-outer-spin-button,
        input::-webkit-inner-spin-button {
            -webkit-appearance: none;
            margin: 0;
        }
    </style>
    <!-- Page Wrapper -->
    <div class="page-wrapper">
        <div class="content container-fluid">

            <div class="row">

                <div class="col-md-12">
                    <div class="card">
                        <div class="card-header">
                            Filter
                        </div>
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-3">
                                    <label>Search</label>
                                    <input type="text" id="gsearch" placeholder="Search Product" class="form-control">
                                </div>
                                <div class="col-md-3">
                                    <form action="" method="get">
                                        <label>Company</label>
                                        <select class="form-control" name="company" id="company">
                                            <option value="">--Choose Company--</option>
                                            @foreach($filter['company'] as $c)
                                                <option value="{{$c->company_name}}" @if(isset($_GET['company']) && $_GET['company']==$c->company_name) selected @endif>{{$c->company_name}}</option>
                                            @endforeach
                                        </select>
                                    </form>
                                </div>
                                @php /* @endphp
                                <div class="col-md-3">
                                    <form action="" method="get">
                                        <label>SKU</label>
                                        <select class="form-control" name="sku" id="sku">
                                            <option value="">--Choose Sku--</option>
                                            @foreach($filter['sku'] as $c)
                                                <option value="{{$c->sku}}"  @if(isset($_GET['sku']) && $_GET['sku']==$c->sku) selected @endif>{{$c->sku}}</option>
                                            @endforeach
                                        </select>
                                    </form>
                                </div>
                                @php */ @endphp
                                <div class="col-md-3">
                                    <form action="" method="get">
                                        <label>Subcategory</label>
                                        <select class="form-control" name="subcategory" id="subcategory">
                                            <option value="">--Choose Subcategory--</option>
                                            @foreach($filter['subcategory'] as $c)
                                                <option value="{{$c->id}}"  @if(isset($_GET['subcategory']) && $_GET['subcategory']==$c->id) selected @endif>{{$c->categoryName}}</option>
                                            @endforeach
                                        </select>
                                    </form>
                                </div>
                                <div class="col-md-3">
                                    <form action="" method="get">
                                        <label>Stock</label>
                                        <select class="form-control" name="stock" id="stock">
                                            <option value="">--All--</option>
                                            <option value="instock" @if(isset($_GET['stock']) && $_GET['stock']=="instock") selected @endif>InStock</option>
                                            <option value="outofstock" @if(isset($_GET['stock']) && $_GET['stock']=="outofstock") selected @endif>Out Of Stock</option>
                                        </select>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>

                    @include('admin.includes.msg')
                    <div class="card card-table">
                        <div class="card-header">
                            <h4 class="card-title">Stock ({{count($product)}})</h4>
                            <a href="javascript:" onclick="printDiv('printableArea')" class="btn-info btn  fr" style="margin-right: 15px;margin-top: -20px"> Print </a> &nbsp; &nbsp; &nbsp;
                            <a href="/export-stock" class="btn-info btn  fr" style="margin-right: 15px;margin-top: -20px"> Export </a> &nbsp; &nbsp; &nbsp;
                        </div>
                        <div class="card-body">

                            <style>
                                .select2 {
                                    width: 100% !important;
                                }

                                .td {
                                    width: 5%;
                                }

                                .td2 {
                                    width: 10%;
                                }

                                .select2-selection--single {
                                    height: 36px !important;
                                    width: 100%;
                                }

                                .select2-container--default .select2-selection--single .select2-selection__rendered {
                                    height: 36px !important;
                                    line-height: 36px !important;
                                }

                                @if(Auth::user()->role<4)
                                    .retailerhide {
                                    display: none
                                }
                                @endif
                            </style>

                            <div class="before_mystocktable" id="printableArea">
                                <style type="text/css" media="print">
                                    @media print {
                                        @page {
                                            margin-top: 0;
                                            margin-bottom: 0;
                                        }

                                        body {
                                            padding-top: 72px;
                                            padding-bottom: 72px;
                                        }
                                    }
                                </style>
                                <div class="table-responsive" id="mytable">
                                    <table class="mystocktable">
                                        <thead>
                                        <tr>
                                            <th style="display:none">#</th>
                                            <th>Product</th>
                                            <th class="td2">Company</th>
                                            <th class="td">MRP</th>
                                            <th class="td">Price</th>
                                            <th class="td">BP Code</th>
                                            <th class="td">SKU</th>
                                            <th class="td">Confugration</th>
                                            <th>Stock</th>
                                            @if(Auth::user()->role==1 || Auth::user()->role==6)
                                                <th>Required</th>
{{--                                                <th>Average Purchase Rate</th>--}}
{{--                                                <th>Minimum Purchase Rate</th>--}}
                                            @endif
 <th>Amount</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        @foreach($product as $p)
                                            <tr @if(Auth::user()->role==1 && $p->anystock==0) style="background: #f87b44;color:#fff" @endif>
                                                <td style="display: none"></td>
                                                <td><a href="/trackstock/{{$p->id}}" target="_blank" style="color: #0D0A0A" title="View Tracks">{{$p->productName}}</a></td>
                                                <td>{{$p->company}}</td>
                                                <td>{{$p->compareAtPrice}}</td>
                                                <td>{{$p->price}}</td>
                                                <td>{{$p->base_pack_code}}</td>
                                                <td>
                                                    <span @if($p->is_focus == 1) style="color:#007bff;" @endif>
                                                        {{$p->sku_code}}
                                                    </span>
                                                </td>
                                                <td>{{$p->conf_2nd_unit}}</td>
                                                <td>
                                                    @php

$investmet_amount+=$p->price*$p->current_stock;
                                                        $stock_in_2nd_unit=$p->current_stock;
                                                       echo  $required=intval(($stock_in_2nd_unit)/$p->conf_2nd_unit).".".$stock_in_2nd_unit%$p->conf_2nd_unit;

                                                    @endphp
                                                </td>
                                                @if(Auth::user()->role==1  || Auth::user()->role==6)
                                                    <td @if($p->alert_stock>=$p->current_stock)style="background-color: #f87b4424" @endif>
                                                        @if($p->cf_req_stock>$p->current_stock)
                                                            @php


                                                                $stock_in_2nd_unit=$p->cf_req_stock-$p->current_stock;
                                                          echo  $required=intval(($stock_in_2nd_unit)/$p->conf_2nd_unit).".".$stock_in_2nd_unit%$p->conf_2nd_unit;

                                                            @endphp
                                                        @else
                                                            0
                                                        @endif
                                                    </td>
{{--                                                    <td>{{$p->avgstockprice}}</td>--}}
{{--                                                    <td>{{$p->minstockprice}}</td>--}}


                                                @endif
                                                
                                                <td>{{$p->price*$p->current_stock}}</td>
                                            </tr>
                                        @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>


                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>
    
    
    <div style="position: absolute;
    right: 56px;
    top: 110px;
    background: #f87b44;
    padding: 2px 10px;
    color: #fff;
    z-index: 9999;">Total Amount {{ number_format($investmet_amount,2)}}</div>
    
    </div>
    <!-- /Main Wrapper -->
    </div>

    <style>
        .form-control {
            min-width: 60px;
        }
    </style>
    <script>
        document.querySelectorAll("#company, #subcategory, #stock").forEach(select => {
            select.addEventListener("change", function() {
                let params = new URLSearchParams(window.location.search);
                if (this.value) {
                    params.set(this.name, this.value); // Update or add the selected value
                } else {
                    params.delete(this.name); // Remove empty selections
                }
                window.location.search = params.toString(); // Update URL and reload
            });
        });
        $(document).ready(function () {
            $("#gsearch").on("keyup blur", function () {
                var value = $(this).val().toLowerCase();
                $("#mytable tbody tr").filter(function () {
                    $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
                });
            });
        });


    </script>

@endsection