@extends('layouts.adminlayout')

@section('content')
<style>
    .w-5{
        width: 20px;
    }

    .bdr{
        font-size: 13px;
    }
    </style>
<section class="">
<div class="container py-2">
    <div class="row py-4">
        <div class="col-12 d-flex">
            <div class="pe-3">
                <a href="{{ url('/senddailymail') }}" class="btn butono "><i class="fas fa-mail-bulk"></i> Send Daily Mail Report</a>
            </div>
            <div class="pe-3">
                <a href="{{ url('/sendwealkymail') }}" class="btn butono "><i class="fas fa-mail-bulk"></i> Send Weekly Mail Report</a>
            </div>
            <div class="pe-3">
                <a href="{{ url('/sendmonthlymail') }}" class="btn butono "><i class="fas fa-mail-bulk"></i> Send Monthly Mail Report</a>
            </div>
        </div>
        <!-- <div class="col-12 mt-3 d-flex">
            <div class="pe-3">
                <a href="#" class="btn butong "><i class="fas fa-file-excel"></i> Excel</a>
            </div>
            <div class="pe-3">
                <a href="#" class="btn butong "><i class="fas fa-file-pdf"></i> PDF</a>
            </div>
            <div class="pe-3">
                <a href="#" class="btn butong "><i class="fas fa-print"></i> Print</a>
            </div>
        </div> -->
        
        <div class="col-12 mt-4 mb-3">
             <h4>Report Details</h4>
        </div>
        <div class="col-12 d-flex align-items-baseline">
           <form action="" method="get">
    @csrf
    <div class="row">
        <div class="col-3">
            <h6>Territory:</h6>
            <select name="unit_no" id="territorySelect" class="form-control ms-2 me-3">
                <option value disabled selected>--- Select Territory ---</option>
                @php
                    $territoryIds = App\Models\TerritoryUser::where('user_id', Auth::user()->id)->pluck('territory_id')->first();
                    if (!empty($territoryIds)) {
                        $territoryIds = json_decode($territoryIds, true);
                        if (!is_array($territoryIds)) $territoryIds = [];
                    } else {
                        $territoryIds = [];
                    }
                @endphp
                @foreach(App\Models\Territory::whereIn('id', $territoryIds)->get() as $territory)
                    <option value="{{ $territory->id }}" {{ ($requestData['unit_no'] ?? '') == $territory->id ? 'selected' : '' }}>
                        {{ $territory->name }}
                    </option>
                @endforeach
            </select>
        </div>

        <div class="col-3">
            <h6>Plant:</h6>
            <select name="plant_id" id="plantSelect" class="form-control ms-2 me-3">
                <option value="">--- Select Plant---</option>
            </select>
        </div>

        <div class="col-3">
            <h6>Section:</h6>
            <select id="areaSelect" name="area" class="form-control ms-2 me-3">
                <option value="">--- Select Section---</option>
            </select>
        </div>

        <div class="col-3">
            <h6>Department:</h6>
            <select name="dept_id" class="form-control ms-2 me-3">
                <option value="">--- Select Dept---</option>
                @foreach($depts as $dept)
                    <option value="{{ $dept->id }}" {{ ($requestData['dept_id'] ?? '') == $dept->id ? 'selected' : '' }}>
                        {{ $dept->deptName }}
                    </option>
                @endforeach
            </select>
        </div>
    </div>

    <div class="row mt-3">
        <div class="col-3">
            <h6>Severity Level:</h6>
            <select name="rating" class="form-control ms-2 me-3">
                <option value="">--- Select Severity---</option>
                <option value="0" {{ ($requestData['rating'] ?? '') == '0' ? 'selected' : '' }}>Low</option>
                <option value="1" {{ ($requestData['rating'] ?? '') == '1' ? 'selected' : '' }}>Medium</option>
                <option value="2" {{ ($requestData['rating'] ?? '') == '2' ? 'selected' : '' }}>High</option>
                <option value="3" {{ ($requestData['rating'] ?? '') == '3' ? 'selected' : '' }}>Very High</option>
            </select>
        </div>

        <div class="col-3">
            <h6>Status:</h6>
            <select name="status" class="form-control ms-2 me-3">
                <option value="">--- Select Status---</option>
                @foreach(['open', 'close request for manager', 'closed request', 'closed', 'terminate'] as $status)
                    <option value="{{ $status }}" {{ ($requestData['status'] ?? '') == $status ? 'selected' : '' }}>
                        {{ ucfirst($status) }}
                    </option>
                @endforeach
            </select>
        </div>

        <div class="col-3">
            <h6>Start Date:</h6>
            <input type="date" name="start_date" class="form-control ms-2 me-3"
                value="{{ $requestData['start_date'] ?? '' }}">
        </div>

        <div class="col-3">
            <h6>End Date:</h6>
            <input type="date" name="end_date" class="form-control ms-2"
                value="{{ $requestData['end_date'] ?? '' }}">
        </div>

        <div class="col-12">
            <button type="submit" class="btn d-inline butong ms-3 mt-4">Apply</button>
        </div>
    </div>

    <!-- Hidden Inputs to keep plant_id and area for JS -->
    <input type="hidden" id="hiddenPlantId" value="{{ $requestData['plant_id'] ?? '' }}">
    <input type="hidden" id="hiddenAreaId" value="{{ $requestData['area'] ?? '' }}">
</form>

        </div>
        
        
        <div class="pe-3 text-right text-end col-12 me-5 pe-5">
    <a href="{{ route('export.issue.report', request()->query()) }}" class="btn butong">
        <i class="fas fa-file-excel"></i> Export to Excel
    </a>
</div>

        <div class="col-12 my-4">
            <div class="shadw br p-4">
             
                <table class="table caption-top">
                  
                  <thead>
                    <tr>
                      <th scope="col" class="bdr">ID</th>
                      <th scope="col" class="bdr">ISSUE TYPE</th>
                      <th scope="col" class="bdr">TERRITORY</th>
                      <th scope="col" class="bdr">PLANT</th>
                      <th scope="col" class="bdr">SECTION</th>
                      <th scope="col" class="bdr">DESCRIPTION</th>
                      <th scope="col" class="bdr">DEPARTMENT</th>
                      <th scope="col" class="bdr">REPORTED BY</th>
                      <th scope="col" class="bdr">SEVERITY LEVEL</th>
                      <th scope="col" class="bdr">ACTION</th>
                      <th scope="col" class="bdr">STATUS</th>
                      <th scope="col" class="bdr">CREATED BY</th>
                      <th scope="col" class="bdr">TARGET DATE</th>
                      <th scope="col" class="bdr">CLOSED DATE</th>
                    </tr>
                  </thead>
                  <tbody>
                  @if(count($issuelist) > 0)

                    @foreach($issuelist as $issue)

                            
                        <tr>
                            <td scope="row" class="bdr">{{ $issue->id }}</td>
                            <td class="bdr">{{ $issue->type }}</td>
                           <td>{{ $issue->territory->name }}</td>
                            <td class="bdr">{{ $issue->plant->name }}</td>
                            <td class="bdr">{{ $issue->areaDetails->name }}</td>
                            <td class="bdr">
                                {{ $issue->description }}</td>
                            <td class="bdr">{{ $issue->deptName }}</td>
                            <td class="bdr">{{ $issue->name }}</td>
                            <td class="bdr" style="text-align: center;"> @if($issue->color($issue->rating)=="#ffc500")
                                    <b style="color:#ffc500; font-weight: bold;">Low</b>
                                @elseif($issue->color($issue->rating)=="#ffa500")
                                    <b style="color:#ffa500; font-weight: bold;">Moderate</b>
                                @elseif($issue->color($issue->rating)=="#fb4a09f2")
                                    <b style="color:#fb4a09f2; font-weight: bold;">High</b>
                                @elseif($issue->color($issue->rating)=="#ff0000")
                                    <b style="color:#ff0000; font-weight: bold;">Very High</b>
                                @endif </td>
                            <td class="bdr" >
                                {{ $issue->action }}</td>
                            <td class="bdr" style="text-align: center;">

                                @if($issue->status=="open")
                                    <b style="color:white; padding: 3px;
                    border-radius: 6px; background-color: red; font-weight: normal;">{{ $issue->status }}</b>
                                @elseif($issue->status=="issued")
                                    <b style="color:white; padding: 3px;
                    border-radius: 6px; background-color: #e1330c; font-weight: normal;">{{ $issue->status }}</b>
                                @elseif($issue->status=="close request for manager")
                                <b style="color:white; padding: 3px;
                    border-radius: 6px; background-color: #5742cb; font-weight: normal;    display: block;
    text-align: center;">{{ $issue->status }}</b>
                                @elseif($issue->status=="closed request")
                                <b style="color:white; padding: 3px;
                    border-radius: 6px; background-color: #21b3df; font-weight: normal;">{{ $issue->status }}</b>
                                @elseif($issue->status=="closed")
                                    <b style="color:white; padding: 3px;
                    border-radius: 6px; background-color: #16b916; font-weight: normal;">{{ $issue->status }}</b>
                                @elseif($issue->status=="terminate")
                                    <b style="color:white; padding: 3px;
                    border-radius: 6px; background-color: orange; font-weight: normal;">{{ $issue->status }}</b>
                                @endif</td>
                            <td class="bdr">{{ date('d-m-Y',strtotime($issue->created_at))}}</td>
                            <td class="bdr">{{ date('d-m-Y',strtotime($issue->targetdate))}}</td>
                            <td class="bdr"> @if($issue->status=="closed")
                                {{ date('d-m-Y',strtotime($issue->updated_at))}}@endif</td>
                        </tr>

                    @endforeach	

                    @else
                        <tr>
                            <td>No Records Found..</td>
                        </tr>
                    @endif
                    </tbody>

                </table>

                {{ $issuelist->links() }}
            </div>
        </div>
        
    </div>
</div>
</section>


<script type="text/javascript">
document.addEventListener('DOMContentLoaded', function () {
    const territorySelect = document.getElementById('territorySelect');
    const plantSelect = document.getElementById('plantSelect');
    const areaSelect = document.getElementById('areaSelect');
    const selectedPlantId = document.getElementById('hiddenPlantId').value;
    const selectedAreaId = document.getElementById('hiddenAreaId').value;

    function loadPlants(territoryId, callback) {
        fetch(`/get-plants/${territoryId}`)
            .then(response => response.json())
            .then(plants => {
                plantSelect.innerHTML = '<option value="">--- Select Plant ---</option>';
                plants.forEach(plant => {
                    const option = document.createElement('option');
                    option.value = plant.id;
                    option.text = plant.name;
                    if (selectedPlantId == plant.id) {
                        option.selected = true;
                    }
                    plantSelect.appendChild(option);
                });
                if (callback) callback();
            });
    }

    function loadAreas(plantId) {
        fetch(`/get-areas/${plantId}`)
            .then(response => response.json())
            .then(areas => {
                areaSelect.innerHTML = '<option value="">--- Select Section ---</option>';
                areas.forEach(area => {
                    const option = document.createElement('option');
                    option.value = area.id;
                    option.text = area.name;
                    if (selectedAreaId == area.id) {
                        option.selected = true;
                    }
                    areaSelect.appendChild(option);
                });
            });
    }

    territorySelect.addEventListener('change', function () {
        loadPlants(this.value);
    });

    plantSelect.addEventListener('change', function () {
        loadAreas(this.value);
    });

    // Auto load for pre-filled values
    if (territorySelect.value) {
        loadPlants(territorySelect.value, function () {
            if (selectedPlantId) {
                loadAreas(selectedPlantId);
            }
        });
    }
});
</script>

@endsection