@extends('layouts/pos_layout')
@section('title', '| Edit Opeining')
@section('content')
<div class="row add-data-form" style="height:100%">
    <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="{{url('pos/viewOpeningStock/')}}" 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">Edit Opening Stock</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('branch_id', $posOpeningStocksDetails->branch_id, ['class' => 'form-control input-sm', 'id' => 'branch_id']) !!}

                            <div class="col-md-6">
                                <div class="form-group">
                                    {!! Form::label('branch_id_for_view', 'Branch*', ['class' => 'col-sm-3 control-label']) !!}
                                    <div class="col-sm-9">
                                        <select name="branch_id_for_view" id="branch_id_for_view" class="form-control" disabled>
                                            <option value="">Select Branch</option>
                                            @if($branches)
                                            @foreach($branches as $branch)
                                            <option value="{{$branch->id}}" @if($branch->id == $posOpeningStocksDetails->branch_id) selected @endif>{{ $branch->branchCode }} - {{ $branch->name }}</option>
                                            @endforeach
                                            @endif
                                        </select>
                                        <p id='branch_id_for_viewe' style="max-height:3px;"></p>
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-6">
                                <div class="form-group">
                                    {!! Form::label('Opening Date', 'Opening Date:', ['class' => 'col-sm-5 control-label']) !!}
                                    <div class="col-sm-7">
                                        {!! Form::text('opening_date', date('d-m-Y',strtotime($posOpeningStocksDetails->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</th>
                                    <th>Cost Price</th>
                                    <th>Total Price</th>
                                </tr>
                            </thead>

                            <tbody>

                                @if (!empty($hasCategorys))

                                @php
                                $serial = 0;
                                @endphp

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

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

                                @php
                                $posProducts = App\Models\pos\ProductConfig\PosProduct::where('category_id', '=' , $key)->get();

                                @endphp

                                @if (!empty($posProducts))

                                @foreach ($posProducts as $posProduct)
                                @php
                                    $productInfoForDetails = App\Models\pos\Tools\PosOpeningStock::select(DB::raw("sum(quantity) as t_quantity"),DB::raw("sum(opening_amount) as t_cost_price"),DB::raw("sum(total_amount) as t_total_price"))
                                    ->where('product_id',$posProduct->id)->where('branch_id',$posOpeningStocksDetails->branch_id)->groupBy('branch_id')->first();
                                    $t_quantity = ($productInfoForDetails) ? $productInfoForDetails->t_quantity : '0';
                                    $t_cost_price = ($productInfoForDetails) ? $productInfoForDetails->t_cost_price : $posProduct->cost_price;
                                    $t_total_price = ($productInfoForDetails) ? $productInfoForDetails->t_total_price : '0';
                                    //dd($posProduct->id);
                                @endphp

                                <tr>
                                    <td style="text-align: left;">{{ ++$serial }}</td>
                                    <td style="text-align: left;">{{ $posProduct->barcode }}</td>
                                    <input type="hidden" name="barcode[]" value="{{  $posProduct->barcode }}" />
                                    <td style="text-align: left;">{{ ($posProduct->brand) ? $posProduct->brand->name : '' }}</td>
                                    <td style="text-align: left;">{{ $posProduct->name }}</td>
                                    <input type="hidden" name="productIds[]" value="{{ $posProduct->id }}" />
                                    <td style="text-align: left;">{{ ($posProduct->model) ? $posProduct->model->name : '' }}</td>
                                    <td style="text-align: right;">{{ $posProduct->sales_price }}</td>
                                    <td><input style="text-align: right;" id="quantity_<br />
<b>Warning</b>:  Undefined variable $posProduct in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/pos/tools/openingStock/editOpeningStock.blade.php</b> on line <b>110</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/pos/tools/openingStock/editOpeningStock.blade.php</b> on line <b>110</b><br />
" name="quantity[]" placeholder="Total Quantity" value="{{ $t_quantity}}" class="custom-quantity" data-qid='<br />
<b>Warning</b>:  Undefined variable $posProduct in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/pos/tools/openingStock/editOpeningStock.blade.php</b> on line <b>110</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/pos/tools/openingStock/editOpeningStock.blade.php</b> on line <b>110</b><br />
' /></td>
                                    <td><input style="text-align: right;" id="opening_amount_<br />
<b>Warning</b>:  Undefined variable $posProduct in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/pos/tools/openingStock/editOpeningStock.blade.php</b> on line <b>111</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/pos/tools/openingStock/editOpeningStock.blade.php</b> on line <b>111</b><br />
" name="opening_amount[]" value="{{ round($t_cost_price,2)}}" class="custom-costprice" readonly /></td>
                                    <td><input style="text-align: right;" id="total_amount_<br />
<b>Warning</b>:  Undefined variable $posProduct in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/pos/tools/openingStock/editOpeningStock.blade.php</b> on line <b>112</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/shikkhaplus/public_html/guk_bk/resources/views/pos/tools/openingStock/editOpeningStock.blade.php</b> on line <b>112</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="{{url('pos/viewOpeningStock/')}}" 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>
@endsection

<script src="{{asset('js/jquery-1.11.1.min.js')}}"></script>
<script type="text/javascript">
    $(document).ready(function() {

        // calculate total
        calculateSum();
        function calculateSum() {
            var Qtysum = 0;
            var QtyTotal = 0;

            //total quantity
            $(".custom-quantity").each(function() {
                if (!isNaN(this.value) && this.value.length > 0) {
                    Qtysum += parseFloat(this.value);
                }
            });
            $("#totalQty").html(Qtysum.toFixed(0));

            //total Grand Total
            $(".custom-total").each(function() {
                if (!isNaN(this.value) && this.value.length > 0) {
                    QtyTotal += parseFloat(this.value);
                }
            });
            $("#totalGrandPrice").html(QtyTotal.toFixed(0));
        }

        //Get Branch Opening Date
        $('#branch_id').on('change', function() {

            var brId = $("#branch_id").val();
            $.ajax({
                    url: "./gnrPosOpeningBranchDate",
                    type: 'POST',
                    dataType: 'json',
                    data: {
                        'brId': brId
                    },
                })
                .done(function(data) {
                    $("#opening_date_id").val(data);
                });

        });

        //form submit
        $('form').submit(function(event) {
            $('#loadingModal').show();
            event.preventDefault();
            $.ajax({
                type: 'post',
                // url: './updateOpeningStockItem',
                url: '{{route("pos_opening_stock_update")}}',
                data: $('form').serialize(),
                dataType: 'json',
                success: function(_response) {
                    $('#loadingModal').hide();
                    if (_response.errors) {
                        console.log(_response);

                        if (_response.errors['branch_id']) {

                            $('#branch_ide').append('<span class="errormsg" style="color:red;">' + _response.errors.branch_id + '</span>');
                            return false;
                        }
                        if (_response.errors['opening_date']) {
                            alert(_response.errors['opening_date']);
                            $('#opening_datee').append('<span class="errormsg" style="color:red;">' + _response.errors.opening_date + '</span>');
                            return false;
                        }

                    } else {
                        $('#loadingModal').hide();
                        $("#branch_id").val('');
                        $("#opening_date").val('');
                        toastr.success(_response.responseText, _response.responseTitle, opts);
                        setTimeout(function() {
                            window.location.href = '{{url("pos/viewOpeningStock/")}}';
                        }, 500);
                    }
                },
                error: function(_response) {
                    $('#loadingModal').hide();
                    // Handle error
                    alert(_response.errors);
                }
            });
        });


        // Total Amount Calculation By Product Quantity Start
        $('.custom-quantity').on('input', function() {
            var productId = $(this).data('qid');
            var quantity = parseFloat($(this).val());
            unit_amount = parseFloat($("#opening_amount_" + productId).val());
            total_amount = quantity * unit_amount;
            $("#total_amount_" + productId).val(total_amount);
            if (!quantity) {
                $("#total_amount_" + productId).val(0);
            }
            calculateSum();
        });



    });
</script>