@extends('layouts/inventory_layout')
@section('title', '| ' . $pageTitle)
@section('content')

<div class="row add-data-form" style="padding-bottom:20px;">
    <div class="col-md-12">
        <div class="col-md-1"></div>
        <div class="col-md-10 fullbody">
            <div class="viewTitle" style="border-bottom: 1px solid white;">
                <a href="{{route('inventory_opening_stock_list')}}" class="btn btn-info pull-right addViewBtn"><i class="glyphicon glyphicon-th-list viewIcon">
                    </i>Opening Stock List</a>
            </div>
            <div class="panel panel-default panel-border">
                <div class="panel-heading">
                    <div class="panel-title">{{ $pageTitle }}</div>
                </div>
                <div class="panel-body">

                    {!! Form::open(array('url' => '' , 'enctype' => 'multipart/form-data', 'role' => 'form', 'class'=>'form-horizontal form-groups')) !!}

                    <div class="row">
                        <div class="col-md-12" id="formDiv">
                            {!! Form::hidden('opening_stock_id', $opening_stock->id, ['class' => 'form-control input-sm', 'id' => 'opening_stock_id']) !!}

                            <div class="col-md-6">
                                <div class="form-group">
                                    {!! Form::label('branch_id', 'Branch:<sup class="text-danger">*</sup>', ['class' => 'col-sm-4 control-label'],false) !!}
                                    <div class="col-sm-9">
                                        {!! Form::select('branch_id', $branches,$opening_stock->branch_id, ['class' => 'form-control custom-select2', 'id' => 'branch_id','placeholder' => 'Select Branch','required'=>'required','autocomplete'=>'off','disable'=>'disable']) !!}
                                        <p id='branch_ide' style="max-height:3px;"></p>
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group">
                                    {!! Form::label('Opening Date', 'Opening Date:<sup class="text-danger">*</sup>', ['class' => 'col-sm-5 control-label'],false) !!}
                                    <div class="col-sm-7">
                                        {!! Form::text('opening_date', date('d-m-Y',strtotime($opening_stock->opening_date)), ['class'=>'form-control', 'id' => 'opening_date_id','readonly']) !!}
                                        <p id='opening_datee' class="error"></p>
                                    </div>
                                </div>
                            </div>

                        </div>

                        <table class="table table-bordered responsive table-hover">
                            <thead>
                                <tr>
                                    <th>Sl.</th>
                                    <th>Barcode</th>
                                    <th>Brand</th>
                                    <th>Product Name</th>
                                    <th>Model</th>
                                    <th>Sale Price</th>
                                    <th>Total Quantity<sup class="text-danger">*</sup></th>
                                    <th>Cost Price<sup class="text-danger">*</sup></th>
                                    <th>Total Price<sup class="text-danger">*</sup></th>
                                </tr>
                            </thead>

                            <tbody>

                                @if (!empty($hasCategories))

                                @php
                                $serial = 0;
                                @endphp

                                @foreach ($hasCategories as $key => $hasCategory)

                                    <tr>
                                        <td style="color: #006699; font-weight: bold; text-align: left; background: #ebebeb;" colspan="9">
                                            {{$hasCategories[$key]}}
                                        </td>
                                    </tr>

                                @php
                                    $invProducts = App\Models\inventory\productConfig\InvProduct::where('category_id', '=' , $key)->get();
                                    // dd($invProducts);
                                @endphp

                                @if (!empty($invProducts))

                                @foreach ($invProducts as $invProduct)
                                    @php
                                        $productInfoForDetails = App\Models\inventory\tools\InvOpeningStockDetails::select(DB::raw("sum(quantity) as t_quantity"),DB::raw("sum(cost_price) as t_cost_price"),DB::raw("sum(total_price) as t_total_price"))
                                        ->where('product_id',$invProduct->id)->where('branch_id',$opening_stock->branch_id)->groupBy('branch_id')->first();
                                        $t_quantity = ($productInfoForDetails) ? $productInfoForDetails->t_quantity : '0';
                                        $t_cost_price = ($productInfoForDetails) ? $productInfoForDetails->t_cost_price : $invProduct->cost_price;
                                        $t_total_price = ($productInfoForDetails) ? $productInfoForDetails->t_total_price : '0';
                                    @endphp
                                    <tr>
                                        <td style="text-align: center;">{{ ++$serial }}</td>
                                        <td style="text-align: center;">{{ $invProduct->barcode }}</td>
                                        <input type="hidden" name="barcode[]" value="{{  $invProduct->barcode }}" />
                                        <td style="text-align: center;">{{ $invProduct->inv_brand->name }}</td>
                                        <td style="text-align: center;">{{ $invProduct->name }}</td>
                                        <input type="hidden" name="productIds[]" value="{{ $invProduct->id }}" />
                                        <td style="text-align: center;">{{ $invProduct->inv_model->name }}</td>
                                        <td style="text-align: right;">{{ round($invProduct->sales_price,2) }}</td>
                                        <td><input style="text-align: right;" id="quantity_<br />
<b>Warning</b>:  Undefined variable $invProduct in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>102</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>102</b><br />
" name="quantity[]" placeholder="Total Quantity" value="{{ $t_quantity}}" class="custom-quantity" data-qid='<br />
<b>Warning</b>:  Undefined variable $invProduct in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>102</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>102</b><br />
' /></td>
                                        <td><input style="text-align: right;" id="opening_amount_<br />
<b>Warning</b>:  Undefined variable $invProduct in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>103</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>103</b><br />
" name="opening_amount[]" value="{{ round($t_cost_price,2)}}" class="custom-costprice" data-qid='<br />
<b>Warning</b>:  Undefined variable $invProduct in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>103</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>103</b><br />
' /></td>
                                        <td><input style="text-align: right;" id="total_amount_<br />
<b>Warning</b>:  Undefined variable $invProduct in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>104</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>104</b><br />
" name="total_amount[]" value="{{ round($t_total_price,2)}}" class="custom-total" readonly /></td>
                                    </tr>

                                @endforeach

                                @endif

                                @endforeach
                                <tr>
                                    <td colspan="6" style='text-align:right;font-weight:900'>Total</td>
                                    <td id='totalQty' style='text-align:right;font-weight:900;padding-right: 38px;'></td>
                                    <td id='totalCostPrice' style='text-align:right;font-weight:900;padding-right: 38px;'></td>
                                    <td id='totalGrandPrice' style='text-align:right;font-weight:900;padding-right: 38px;'></td>
                                </tr>

                                @endif

                            </tbody>
                        </table>
                    </div>


                    <div class="row">
                        <div class="col-md-4"></div>
                        <div class="col-md-4"></div>
                        <div class="form-group col-md-4 text-right" style="float:right">
                            {!! Form::label('submit', ' ', ['class' => 'col-sm-2 control-label']) !!}
                            <div class="col-sm-12">
                                {!! Form::submit('Update', ['id' => 'add', 'class' => 'btn btn-info']); !!}
                                <a href="{{route('inventory_opening_stock_list')}}" class="btn btn-danger closeBtn">Close</a>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <span id="success" style="color:green; font-size:20px;"></span>
                        </div>
                    </div>
                    {!! Form::close() !!}

                </div>
            </div>
            <div class="footerTitle" style="border-top:1px solid white"></div>
        </div>
        <div class="col-md-1"></div>
    </div>
</div>



<script>
    $(document).ready(function() {
        // calculate total
        calculateSum();

        $(".numeric").keypress(function(e) {
            $(this).val($(this).val().replace(/[^0-9\.]/g, ''));
            if ((event.which != 46 || $(this).val().indexOf('.') != -1) && (event.which < 48 || event.which > 57)) {
                $("#numericError").html("Digits Only").show().fadeOut("slow");
                event.preventDefault();
            }
        });

        //  Start Product Barcode
        $("#branch_id").change(function() {
            var branch_id = $("#branch_id").val();
            var csrf = "<br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function csrf_token() in /home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php:168
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/demo_bk/resources/views/inventory_me/tools/openingStock/edit.blade.php</b> on line <b>168</b><br />