@extends('layouts.app')

@section('title')
    {{ __('RIS Report') }}
@endsection

@section('breadcrumb')
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0 text-dark">
                        <i class="fas fa-file-invoice-dollar"></i>
                        {{ __('RIS Report') }}
                    </h1>
                </div><!-- /.col -->
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="{{ route('admin.index') }}">{{ __('Home') }}</a></li>
                        <li class="breadcrumb-item active">{{ __('RIS Report') }}</li>
                    </ol>
                </div><!-- /.col -->
            </div><!-- /.row -->
        </div><!-- /.container-fluid -->
    </div>
@endsection

@section('content')
    <div class="card card-primary">
        <!-- card-header -->
        <div class="card-header">
            <!-- <h3 class="card-title">{{ __('Products report') }}</h3> -->
        </div>
        <!-- /.card-header -->
        <!-- card-body -->
        <div class="card-body">

            <!-- Filtering Form -->
            <div id="accordion">
                <div class="card card-info">
                    <a data-toggle="collapse" data-parent="#accordion" href="#collapseOne" class="btn btn-primary collapsed"
                        aria-expanded="false">
                        <i class="fas fa-filter"></i> {{ __('Filters') }}
                    </a>
                    <form method="get" action="{{ route('admin.reports.ris') }}">
                        <div id="collapseOne" class="panel-collapse in collapse show">
                            <div class="card-body">
                                <div class="row">
                                    <!-- date range -->
                                    <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3">
                                        <label>{{ __('Date range') }}:</label>
                                        <div class="input-group">
                                            <div class="input-group-prepend">
                                                <span class="input-group-text">
                                                    <i class="far fa-calendar-alt"></i>
                                                </span>
                                            </div>
                                            {{-- <input type="text" name="date"
                                                class="form-control float-right datepickerrange"
                                                @if (request()->has('date')) value="{{ request()->get('date') }}" @else value="{{ date('Y/m/d', strtotime('-1month')) . ' - ' . date('Y/m/d') }}" @endif
                                                id="date" required> --}}
                                            <input type="text" name="date" id="date" autocomplete="off"
                                                class="form-control float-right datepickerrange"
                                                @if (request()->has('date')) value="{{ request()->get('date') }}" @else value="{{ date('F d, Y', strtotime('-1month')) . ' - ' . date('F d, Y') }}" @endif
                                                id="date" required>
                                            <div class="input-group-append">
                                                <button class="btn btn-outline-secondary clear_date" type="button">Clear</button>
                                            </div>
                                        </div>
                                    </div>
                                    <!-- \date range -->
                                    <!-- Branches/Department -->
                                    <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3">
                                        <div class="form-group">
                                            <label>{{ __('Laboratory') }}</label>
                                            <select class="form-control" name="branch_id[]" id="branch" multiple>
                                                @if (request()->has('branch_id') && isset($branches))
                                                    @foreach ($branches as $branch)
                                                        <option value="{{ $branch['id'] }}" selected>{{ $branch['name'] }}
                                                        </option>
                                                    @endforeach
                                                @endif
                                            </select>
                                        </div>
                                    </div>
                                    <!-- \Branches/Department -->

                                    <!-- Products -->
                                    <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3">
                                        <div class="form-group">
                                            <label>{{ __('Product') }}</label>
                                            <select class="form-control" name="product_id[]" id="product" multiple>
                                                @if (request()->has('product_id') && isset($products))
                                                    @foreach ($products as $product)
                                                        <option value="{{ $product['id'] }}" selected>
                                                            {{ $product['name'] }}</option>
                                                    @endforeach
                                                @endif
                                            </select>
                                        </div>
                                    </div>
                                    <!-- \Products -->
                                    <input type="hidden" name="generate" value="true">
                                </div>
                            </div>
                            <div class="card-footer">
                                <button type="submit" class="btn btn-primary">
                                    <i class="fas fa-cog"></i>
                                    {{ __('Generate') }}
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            <!-- Filtering Form -->

            @if (isset($ris_products))
                <!-- Report Details -->
                <div class="card card-primary card-tabs">
                    <div class="card-header p-0">
                        <ul class="nav nav-tabs" id="custom-tabs-one-tab" role="tablist">
                            <li class="nav-item">
                                <a class="nav-link active" id="custom-tabs-one-purchases-tab" data-toggle="pill"
                                    href="#custom-tabs-one-purchases" role="tab"
                                    aria-controls="custom-tabs-one-purchases" aria-selected="false">{{ __('RIS') }}</a>
                            </li>
                            <li class="nav-item">
                                <a class="nav-link" id="custom-tabs-one-payments-tab" data-toggle="pill"
                                    href="#custom-tabs-one-payments" role="tab" aria-controls="custom-tabs-one-payments"
                                    aria-selected="false">{{ __('Tally') }}</a>
                            </li>
                        </ul>
                    </div>
                    <div class="card-body">
                        <div class="tab-content" id="custom-tabs-one-tabContent">
                            <div class="tab-pane fade active show" id="custom-tabs-one-purchases" role="tabpanel"
                                aria-labelledby="custom-tabs-one-purchases-tab">
                                <div class="row">
                                    <div class="col-lg-12 table-responsive">
                                        <table class="table table-striped table-bordered datatable">
                                            <thead>
                                                <tr>
                                                    <th>{{ __('#') }}</th>
                                                    <th>{{ __('Date Issued') }}</th>
                                                    <th>{{ __('RIS No.') }}</th>
                                                    <th>{{ __('Code') }}</th>
                                                    <th>{{ __('Type') }}</th>
                                                    <th>{{ __('Particulars') }}</th>
                                                    <th>{{ __('Requested by') }}</th>
                                                    <th>{{ __('Issued by') }}</th>
                                                    <th>{{ __('Received by') }}</th>
                                                    <th>{{ __('Unit') }}</th>
                                                    <th>{{ __('Quantity') }}</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($ris_products as $key => $product)
                                                    <tr>
                                                        <td>
                                                            {{ $key + 1 }}
                                                        </td>
                                                        <td>{{ date('F j, Y', strtotime($product['created_at'])) }}</td>
                                                        <td>
                                                            @if (isset($product->req_issuance->request_product->ris_number))
                                                                {{ $product->req_issuance->request_product->ris_number }}
                                                            @endif
                                                        </td>
                                                        <td>
                                                            {{ $product['product']['code'] }}
                                                        </td>
                                                        <td>
                                                            
                                                            {{ isset($product['product']['product_type']['name'])  ? $product['product']['product_type']['name'] : ''}}
                                                        </td>
                                                        <td>
                                                            {{ $product['product']['name'] }}
                                                            {{-- {{ $product['product']['product_category']['name'] }} --}}
                                                            {{ $product['product']['description'] }}
                                                        </td>
                                                        <td>{{ isset($product['req_issuance']['request_product']['requestor_user']['name']) ? $product['req_issuance']['request_product']['requestor_user']['name'] : '' }}
                                                        </td>
                                                        <td>{{ isset($product['req_issuance']['request_product']['issuer_user']['name']) ? $product['req_issuance']['request_product']['issuer_user']['name'] : '' }}
                                                        </td>
                                                        <td>{{ isset($product['req_issuance']['request_product']['receiver_user']['name']) ? $product['req_issuance']['request_product']['receiver_user']['name'] : '' }}
                                                        </td>
                                                        <td>
                                                            {{ isset($product['product']['product_unit']['name']) ? $product['product']['product_unit']['name'] : ''}}
                                                        </td>
                                                        <td>
                                                            {{ $product['quantity'] }}
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <style>
                                .table_tally td,
                                .table_tally th,
                                .table_tally {
                                    border: 0.5px solid !important;
                                }
                            </style>
                            <div class="tab-pane fade" id="custom-tabs-one-payments" role="tabpanel"
                                aria-labelledby="custom-tabs-one-payments-tab">
                                <div class="row">
                                    <div class="col-lg-12 table-responsive">
                                        <table class="table table-striped table-bordered datatable table_tally">
                                            <thead>
                                                <tr>
                                                    <th rowspan="2">#</th>
                                                    <th rowspan="2">{{ __('Code') }}</th>
                                                    <th rowspan="2">{{ __('Type') }}</th>
                                                    <th rowspan="2">{{ __('Particulars') }}</th>
                                                    <th rowspan="2">{{ __('Unit') }}</th>
                                                    @foreach ($datesArray as $d)
                                                        <th colspan="2">{{ $d }}</th>
                                                    @endforeach
                                                    <th rowspan="2">Total</th>
                                                    {{-- <th>{{ __('Cost') }}</th> --}}
                                                </tr>
                                                <tr>
                                                    @foreach ($datesArray as $d)
                                                        <th>RIS</th>
                                                        <th>QTY</th>
                                                    @endforeach

                                                </tr>
                                            </thead>
                                            <tbody>

                                                @foreach ($products_ris as $key => $p_ris)
                                                @php
                                                    $total = 0
                                                @endphp
                                                    <tr>
                                                        <td>{{ $key + 1 }}</td>
                                                        <td>
                                                            {{ $p_ris['code'] }}
                                                        </td>
                                                        <td>
                                                            {{ $p_ris['product_type']['name'] }}
                                                        </td>
                                                        <td>
                                                            {{ $p_ris['name'] }}
                                                            {{ $p_ris['product_category']['name'] }}
                                                            {{ $p_ris['description'] }}
                                                        </td>
                                                        <td>
                                                            {{ $p_ris['product_unit']['name'] }}
                                                        </td>
                                                        @foreach ($datesArray as $d)
                                                            <td>
                                                                @if (isset($p_ris->ris_products))
                                                                    @foreach ($p_ris->ris_products as $data)
                                                                        @if ($data->request_product->date == $d)
                                                                            @if ($data->consumption->sum('quantity') != 0)
                                                                                {{ $data->request_product->ris_number }}
                                                                                <br>
                                                                            @endif
                                                                        @endif
                                                                    @endforeach
                                                                @endif
                                                            </td>
                                                            <td>
                                                                @if (isset($p_ris->ris_products))
                                                                    @foreach ($p_ris->ris_products as $data)
                                                                        @if ($data->request_product->date == $d)
                                                                            @if ($data->consumption->sum('quantity') != 0)
                                                                                {{ $data->consumption->sum('quantity') }}
                                                                                @php
                                                                                $total = $total + $data->consumption->sum('quantity')
                                                                                @endphp
                                                                                <br>
                                                                            @endif
                                                                        @endif
                                                                    @endforeach
                                                                @endif
                                                            </td>
                                                        @endforeach
                                                        <td>{{$total}}</td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            @endif
        </div>
        @if (request()->has('date'))
            <div class="card-footer">
                <a href="{{ request()->fullUrl() }}&excel=true" class="btn btn-success">
                    <i class="fas fa-file-excel mr-1"></i> {{ __('Excel') }}
                </a>
            </div>
        @endif
    </div>
    <!-- /.card-body -->

    </div>

@endsection
@section('scripts')
    <script src="{{ url('plugins/daterangepicker/daterangepicker.js') }}"></script>
    <script src="{{ url('js/admin/ris_reports.js') }}"></script>
@endsection