@extends('layouts/inventory_layout')
@section('title', '| ' . $moduleTitle)
@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">{{ $moduleTitle }}</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', $data->id, ['class' => 'form-control input-sm', 'id' => 'issue_id']) !!}

                            <div class="col-md-6">
                                <div class="form-group">
                                    {!! Form::label('Branch', 'Branch:', ['class' => 'col-sm-5 control-label']) !!}
                                    <div class="col-sm-7">
                                        {!! Form::text('branch_id', $data->inv_branch->name, ['class'=>'form-control', 'id' => 'branch_id_id','readonly']) !!}
                                        <p id='branch_ide' class="error"></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($data->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($hasCategories))

                                @php
                                $serial = 0;

                                $totalQty = 0;
                                $totalCostPrice = 0;
                                $totalTotalPrice = 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::join('inv_opening_stock_details', 'inv_opening_stock_details.product_id', '=', 'inv_product.id')
                                ->selectRaw("inv_product.id,inv_product.id,inv_product.group_id,inv_product.model_id,inv_product.category_id,inv_product.sub_category_id,inv_product.brand_id,inv_product.name,inv_product.barcode,inv_opening_stock_details.opening_stock_id,inv_opening_stock_details.quantity,inv_opening_stock_details.cost_price,inv_opening_stock_details.total_price")
                                ->where('inv_product.category_id', '=' , $key)->where('inv_opening_stock_details.branch_id', '=' , $data->branch_id)->get();
                                //dd($invProducts);
                                @endphp

                                @if (!empty($invProducts))

                                @foreach ($invProducts as $invProduct)
                                    @php
                                    $totalQty += $invProduct->quantity;
                                    $totalCostPrice += $invProduct->cost_price;
                                    $totalTotalPrice += $invProduct->total_price;
                                    @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;">{{ number_format($invProduct->sales_price,2) }}</td>
                                        <td style="text-align: center;">{{ $invProduct->quantity}}</td>
                                        <td style="text-align: right;">{{ number_format($invProduct->cost_price,2)}}</td>
                                        <td style="text-align: right;">{{ number_format($invProduct->total_price,2)}}</td>
                                    </tr>

                                @endforeach

                                @endif

                                @endforeach
                                <tr>
                                    <td colspan="6" style='text-align:right;font-weight:900'>Total</td>
                                    <td id='totalQty' style='text-align:center;font-weight:900'>{{ $totalQty}}</td>
                                    <td id='totalCostPrice' style='text-align:right;font-weight:900'>{{ number_format($totalCostPrice,2)}}</td>
                                    <td id='totalGrandPrice' style='text-align:right;font-weight:900'>{{ number_format($totalTotalPrice,2)}}</td>
                                </tr>

                                @endif

                            </tbody>
                        </table>
                    </div>
                    {!! Form::close() !!}

                </div>
            </div>
            <div class="footerTitle" style="border-top:1px solid white"></div>
        </div>
        <div class="col-md-1"></div>
    </div>
</div>
<style>
    input[type=number]::-webkit-outer-spin-button,
    input[type=number]::-webkit-inner-spin-button {
        -webkit-appearance: none;
        margin: 0;
    }

    input[type=number] {
        -moz-appearance: textfield;
    }
</style>
@endsection