@extends('fronted.layout.main')
@section('adcontent')
@php
use Illuminate\Support\Facades\DB;
use Carbon\Carbon;
$currentMonth = Carbon::now()->format('m');
$currentYear = Carbon::now()->format('Y');
$currentMonthDate = Carbon::now();
@endphp
<style>
    #ElecticityUpdateModal .form-control,
    #ElecticityInsertModal .form-control,
    #ElecticityUpdateModal .form-label,
    #ElecticityInsertModal .form-label {
        font-size: 0.8rem;
    }

    #ElecticityUpdateModal .form-control:focus,
    #ElecticityInsertModal .form-control:focus {
        box-shadow: none;
    }
</style>
@if(session()->has('Electicity'))
<script>
    Swal.fire({
        icon: "success",
        text: "{{session('Electicity')}}"
    })
</script>
@endif
<div class="container-fluid">
    <div class="container">
        <div class="d-flex justify-content-between align-items-center">
            <div class="left-btn">
                <button type="button" class="btn btn-warning mb-1" data-bs-toggle="modal" data-bs-target="#ElecticityModal">
                    Add Electricity
                </button>
                <button type="button" class="btn btn-danger mb-1" id="ElectricityBillReportDownload"><i class="fa-solid fa-download me-1"></i>Report</button>
            </div>
            <div class="attendaceFilterBox">
                <div class="d-flex justify-content-end align-items-center">
                    <form id="StudentelecticityForm" action="{{ route('electicity.view') }}" method="GET">
                        <div class="d-flex justify-content-between g-5 gap-3 align-items-center">
                            <label class="form-label text-nowrap" for="selected_month">Select Month:</label>
                            <select class="form-select d-inline-block" name="selected_month" id="selected_month">
                                @foreach($allBillDates as $elctricityBill)
                                <option value="{{ $elctricityBill->BillDate }}" {{ $selectedMonth == $elctricityBill->BillDate ? 'selected' : '' }}>
                                    {{ \Carbon\Carbon::parse($elctricityBill->BillDate)->format('d-M-Y')}}
                                </option>
                                @endforeach
                                <option value="custom">
                                    custom
                                </option>
                            </select>
                            <div class="d-none d-flex align-items-center g-2 gap-2" id="noticeFilterBox">
                                <label class="form-labal-sm text-nowrap" for="startDate">Start Date</label>
                                <input class="form-control-sm" type="date" name="startDate" id="startDate">
                                <label class="form-labal-sm text-nowrap" for="endDate">End Date</label>
                                <input class="form-control-sm" type="date" name="endDate" id="endDate">
                            </div>
                            <button id="filterBtnSubmit" class="btn btn-warning" type="submit">Submit</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <div class="container">
        <div class="table-responsive dataTable">
            <table class="table align-middle text-center roomSeatTable">
                <thead>
                    <tr>
                        <th>S No</th>
                        <th>Room No</th>
                        <th>
                            <span class="text-white">
                                {{ $PreviousBillDate }}
                            </span>
                            <br>
                            Previous Reading

                        </th>
                        <th>
                            <span class="text-white">
                                {{ $PrenseBillDate }}
                            </span>
                            <br>
                            Present Reading
                        </th>
                        <th>Total Unit</th>
                        <th>Waved Off Units</th>
                        <th>Candidate Name</th>
                        <th>Candidate/Unit</th>
                        <th>Amount</th>
                        <th>Status</th>
                        <th>Total Amount</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                    $count = 1;
                    $ChangeRoom = null;
                    $totalCandidatesAmount = 0;
                    $electricityRooms = DB::table("electicity_management")
                    ->where(DB::raw('MONTH(billDate)'), '=', $selectedMonth)
                    ->where(DB::raw('YEAR(billDate)'), '=', $currentYear)
                    ->orderBy("roomno","ASC")
                    ->get();
                    @endphp

                    @if($electricityRooms->isEmpty())
                    <tr>
                        <td colspan="10">No Records Founds</td>
                    </tr>
                    @endif

                    @foreach($electricityRooms as $row)
                    @php
                    $electricityRecords = DB::table("students_electricity_bill")->where(DB::raw('MONTH(billDate)'), '=', $selectedMonth)
                    ->where(DB::raw('YEAR(billDate)'), '=', $currentYear)
                    ->where("roomNo",$row->roomno)
                    ->orderBy("roomNo","ASC")
                    ->orderBy('seatNo',"ASC")
                    ->get();
                    $noOfRow = $electricityRecords->count();
                    @endphp

                    @foreach($electricityRecords as $records)
                    @php
                    $candidateName = DB::table('studentregisters')->select("candidatename")
                    ->where('id',$records->userId)->first();

                    $Amount = $row->readingRate * $records->prUnitCharge;
                    $totalCandidatesAmount += $Amount;
                    $TotalAmount = DB::table('students_electricity_bill')
                    ->where('userId', $records->userId)
                    ->where('status', 0)
                    ->sum('amount');

                    @endphp

                    @if($ChangeRoom == null || $ChangeRoom != $row->roomno)
                    <tr>
                        <td rowspan="{{$noOfRow}}">{{$count++}}</td>
                        <td rowspan="{{$noOfRow}}">{{$row->roomno}}</td>
                        <td rowspan="{{$noOfRow}}">
                            {{ $row->previous_reading }}
                        </td>
                        <td rowspan="{{$noOfRow}}">
                            {{ $row->present_reading }}
                        </td>
                        <td rowspan="{{$noOfRow}}">{{$row->units}}</td>
                        <td rowspan="{{$noOfRow}}">{{$row->discountUnits}}</td>
                        <td>
                            {{ ($candidateName) ? $candidateName->candidatename : $records->userId  }}
                        </td>
                        <td>
                            {{ $records->prUnitCharge }}
                        </td>
                        <td><i class="fa-solid fa-indian-rupee-sign me-1"></i>{{$Amount}}</td>
                        <td style="color:{{ $records->status == 0 ? '#00ff00' : '#ffc107'}}">{{$records->status==0?"Unpaid":"Paid"}}</td>
                        <td>
                            <i class="fa-solid fa-indian-rupee-sign me-1"></i> {{ $TotalAmount}}
                        </td>
                        <td rowspan="{{$noOfRow}}">
                            <button class="btn" onclick="ElecticityBillEdite('{{$row->id}}')" data-bs-toggle="tooltip" data-placement="top" title="Edit Record">
                                <i class="fa-solid fa-pen-to-square"></i>
                            </button>
                        </td>
                    </tr>
                    @else
                    <tr>
                        <td>
                            {{ ($candidateName) ? $candidateName->candidatename : $records->userId  }}
                        </td>
                        <td>
                            {{ $records->prUnitCharge }}
                        </td>
                        <td><i class="fa-solid fa-indian-rupee-sign me-1"></i>{{$Amount}}</td>
                        <td style="color:{{$records->status == 0 ? '#00ff00' : '#ffc107'}}">{{$records->status==0?"Unpaid":"Paid"}}</td>
                        <td>
                            <i class="fa-solid fa-indian-rupee-sign me-1"></i> {{ $TotalAmount}}
                        </td>
                    </tr>
                    @endif
                    @php
                    $ChangeRoom = $row->roomno;
                    @endphp
                    @endforeach
                    @if($electricityRecords->isEmpty())
                    <tr>
                        <td>{{$count++}}</td>
                        <td>{{$row->roomno}}</td>
                        <td>
                            {{ $row->previous_reading }}
                        </td>
                        <td>
                            {{ $row->present_reading }}
                        </td>
                        <td>{{$row->units}}</td>
                        <td>{{$row->discountUnits}}</td>
                        <td>---</td>
                        <td>---</td>
                        <td>---</td>
                        <td>---</td>
                        <td>---</td>
                        <td>
                            <button class="btn" onclick="ElecticityBillEdite('{{$row->id}}')" data-bs-toggle="tooltip" data-placement="top" title="Edit Record">
                                <i class="fa-solid fa-pen-to-square"></i>
                            </button>
                        </td>
                    </tr>
                    @endif
                    @endforeach
                    <tr>
                        <th colspan="2">Total Units</th>
                        <th>
                            @php
                            $totalValuesCounts = DB::table("electicity_management")
                            ->where(DB::raw('MONTH(billDate)'), '=', $selectedMonth)
                            ->where(DB::raw('YEAR(billDate)'), '=', $currentYear)
                            ->orderBy("roomno","ASC");

                            $totalUnits = $totalValuesCounts->sum('units')

                            @endphp
                            {{ $totalValuesCounts->sum('units') }}
                        </th>
                        <th colspan="2">Total waved off Units</th>
                        <th>{{ $totalValuesCounts->sum('discountUnits') }}</th>
                        <th colspan="3">
                            Total Amount
                        </th>
                        <th>
                            <i class="fa-solid fa-indian-rupee-sign me-1"></i> {{ $totalCandidatesAmount }}
                        </th>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>
</div>

<!-- Modal -->
<div class="modal fade" id="ElecticityModal" data-bs-backdrop="static" data-bs-keyboard="false" tabindex="-1" aria-labelledby="ElecticityModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered modal-dialog-scrollable ml-5">
        <div class="modal-content" style="left:10%">
            <div class="modal-header">
                <h5 class="modal-title" id="ElecticityModalLabel">Electricity </h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <form action="{{route('electicity.store')}}" method="post">
                    @csrf
                    <div class="container-fluid">
                        <div class="container">
                            @if($checkElectricityRecords == 0)
                            <p class="text-danger" style="font-size: 0.8rem;">Note: Please Insert base reading as present reading</p>
                            @endif
                            <div class="table-responsive dataTable">
                                <div class="d-flex justify-content-between align-items-center mb-1 gap-1">
                                    <div class="form-group">
                                        <label class="form-label" for="billDate">Bill Date</label>
                                        <input class="form-control" type="date" name="billdate" id="billDate" required>
                                    </div>
                                    <div class="form-group">
                                        <label class="form-label" for="readingRate">Reading/Rate</label>
                                        <input class="form-control" type="number" name="readingRate" id="ReadingRate" required>
                                    </div>
                                    <div class="form-group">
                                        <label class="form-label" for="discount Units">Wave Off Units</label>
                                        <input type="number" class="form-control" value="0" name="discountUnits" id="discountUnits" required>
                                    </div>
                                </div>
                                <table class="table roomSeatTable align-middle text-nowrap">
                                    <thead>
                                        <tr>
                                            <th>S No</th>
                                            <th>Room No</th>
                                            @if($checkElectricityRecords == 0)
                                            <th>Base Reading</th>
                                            @endif
                                            <th>present Reading</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php $sno = 1 @endphp
                                        @foreach($roomSeats as $rooms)
                                        <tr>
                                            <td>{{$sno++}}</td>
                                            <td>{{$rooms->roomno}}</td>
                                            @if($checkElectricityRecords == 0)
                                            <td>
                                                <input type="number" class="form-control" name="roomSeatsData[{{$rooms->roomno}}][previous_red]" placeholder="Base Reading" required>
                                            </td>
                                            @endif
                                            <td>
                                                <input type="number" class="form-control" name="roomSeatsData[{{$rooms->roomno}}][present_red]" placeholder="Present Reading" required>
                                            </td>
                                        </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
            </div>
            <div class="modal-footer">
                <button class="btn btn-warning" type="submit">Submit</button>
            </div>
            </form>
        </div>
    </div>
</div>
<div class="modal fade" id="ElecticityUpdateModal" data-bs-backdrop="static" data-bs-keyboard="false" tabindex="-1" aria-labelledby="ElecticityUpdateModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered modal-dialog-scrollable ml-5">
        <div class="modal-content" style="left:10%">
            <div class="modal-header">
                <h5 class="modal-title" id="ElecticityUpdateModalLabel">Electricity Bill Update</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form action="#" method="post" id="ElecticityUpdateForm">
                @csrf
                @method('PUT')
                <div class="modal-body">
                    <div class="container-fluid">
                        <div class="container">
                            <input type="text" hidden name="billId" value="" id="billId">
                            <div class="form-group">
                                <label class="form-label" for="billDateUpdate">Bill Date</label>
                                <input class="form-control" type="date" name="billdate" id="billDateUpdate" readonly required>
                            </div>
                            <div class="form-group">
                                <label class="form-label" for="readingRateUpdate">Reading Value</label>
                                <input class="form-control" type="number" name="readingRate" id="ReadingRateUpdate" required>
                            </div>
                            <div class="form-group">
                                <label class="form-label" for="discount Units">Wave Off Units</label>
                                <input type="number" class="form-control" value="0" name="discountUnits" id="EditdiscountUnits" required>
                            </div>
                            <div class="form-group">
                                <label for="previousRedUpdate" class="form-label">Previous Reading</label>
                                <input class="form-control" type="number" name="previousRed" id="previousRedUpdate" readonly required>
                            </div>
                            <div class="form-group">
                                <label for="PresentRedUpdate" class="form-label">Present Reading</label>
                                <input class="form-control" type="number" name="PresentRed" id="PresentRedUpdate" required>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button class="btn btn-warning btn-sm" id="updateElecticityRecord" type="submit">Update</button>
                </div>
            </form>
        </div>
    </div>
</div>
<div class="modal fade" id="ElecticityInsertModal" data-bs-backdrop="static" data-bs-keyboard="false" tabindex="-1" aria-labelledby="ElecticityInsertModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered modal-dialog-scrollable ml-5">
        <div class="modal-content" style="left:10%">
            <div class="modal-header">
                <h5 class="modal-title" id="ElecticityInsertModalLabel">Electricity Bill Insert</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form action="{{route('electicity.store.one')}}" method="post" id="">
                @csrf
                <div class="modal-body">
                    <div class="container-fluid">
                        <div class="container">
                            <input type="text" hidden name="roomno" id="ElecticityBillRoomNo">
                            <div class="form-group">
                                <label class="form-label" for="billDateInsert">Bill Date</label>
                                <input class="form-control" type="date" name="billdate" id="billDateInsert" required>
                            </div>
                            <div class="form-group">
                                <label class="form-label" for="readingRateInsert">Reading Value</label>
                                <input class="form-control" type="number" name="readingRate" id="ReadingRateInsert" required>
                            </div>
                            <div class="form-group">
                                <label for="previousRedInsert" class="form-label">Previous Reading</label>
                                <input class="form-control" type="number" name="previousRed" id="previousRedInsert" required>
                            </div>
                            <div class="form-group">
                                <label for="PresentRedInsert" class="form-label">Present Reading</label>
                                <input class="form-control" type="number" name="PresentRed" id="PresentRedInsert" required>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button class="btn btn-warning btn-sm" id="InsertElecticityRecord" type="submit">Insert</button>
                </div>
            </form>
        </div>
    </div>
</div>
<script>
    function submitForm(form) {
        $(form).submit();
    }
    $(document).ready(function() {

        $("#selected_month").on("change",function(){
            var selectedValue = $(this).val();
            if(selectedValue === 'custom'){
                $("#noticeFilterBox").removeClass('d-none');
            }
        }); 
        $(".deleteElectricityRecords").on("click", function() {
            var electricityRecrodsId = $(this).data('electricity-recrods-id');
            var roomno = $(this).data('roomno');
            console.log(electricityRecrodsId);
            Swal.fire({
                title: 'Are you sure?',
                text: "Do you want delete bill records for this room?",
                icon: 'warning',
                showCancelButton: true,
                confirmButtonColor: '#3085d6',
                cancelButtonColor: '#d33',
                confirmButtonText: 'Yes, delete it!'
            }).then((result) => {
                if (result.isConfirmed) {
                    $.ajax({
                        url: '{{ route("electicity.delete") }}',
                        type: 'DELETE',
                        headers: {
                            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                        },
                        data: {
                            id: electricityRecrodsId,
                            roomno: roomno
                        },
                        success: function(data) {
                            Swal.fire(
                                'Deleted!',
                                data.status,
                                'success'
                            )
                        },
                        error: function(error) {
                            Swal.fire(
                                'Error!',
                                'Your file has not been deleted.',
                                'warning'
                            )
                        }
                    });

                }
            })
        });
        $("#ElectricityBillReportDownload").on("click", function() {
            var selectedMonth = $("#selected_month").val();
            $.ajax({
                type: "get",
                url: "{{route('download.electricity.bill.monthly')}}",
                data: {
                    "selectedMonth": selectedMonth,
                    "selectedYear": "{{ $currentYear }}",
                    'PrenseBillDate': "{{$PrenseBillDate}}",
                    "PreviousBillDate": "{{$PreviousBillDate}}",
                },
                xhrFields: {
                    responseType: 'blob' // Set the response type to 'blob'
                },
                success: function(response, status, xhr) {
                    // Convert the received PDF data to a Blob
                    var blob = new Blob([response], {
                        type: 'application/pdf'
                    });

                    // Create a unique filename
                    var fileName = 'ElectricityReport_' + new Date().toISOString() + '.pdf';

                    // Create a download link
                    var link = document.createElement('a');
                    link.href = window.URL.createObjectURL(blob);

                    // Set the download attribute with the unique file name
                    link.download = fileName;

                    // Append the link to the body
                    document.body.appendChild(link);

                    // Trigger a click on the link to start the download
                    link.click();

                    // Remove the link from the body
                    document.body.removeChild(link);
                },
                error: function(error) {
                    console.log("error");
                }
            });
        });
    });

    function ElecticityBillEdite(billId) {
        $.ajax({
            url: '{{ route("fetch.record", [":id", ":billId"]) }}'.replace(':id', billId).replace(':billId', billId),
            type: 'GET',
            success: function(data) {
                $("#ElecticityUpdateModal").on("show.bs.modal", function() {
                    var discountUnits = 0;
                    if (data.discountUnits != 0) {
                        discountUnits = (data.units) - (data.discountUnits);
                    }
                    $("#billId").val(billId);
                    $("#billDateUpdate").val(data.BillDate);
                    $("#ReadingRateUpdate").val(data.readingRate);
                    $("#previousRedUpdate").val(data.previous_reading);
                    $("#PresentRedUpdate").val(data.present_reading);
                    $("#EditdiscountUnits").val(discountUnits);
                }).modal("show");
            },
            error: function(error) {
                // Handle errors
                console.log(error);
            }
        });

    }
    $('#ElecticityUpdateForm').submit(function(e) {
        e.preventDefault();
        var id = $("#billId").val();
        var actionUrl = '{{ route("update.record", [":id"]) }}'.replace(":id", id);
        $(this).attr('action', actionUrl);
        this.submit();
    });

    function ElecticityBillInsert(roomno) {
        var roomno = roomno;
        $("#ElecticityInsertModal").on("show.bs.modal", function() {
            $("#ElecticityBillRoomNo").val(roomno);
        }).modal("show");
    }
</script>
@endsection