@extends('layouts.dash')

@section('content')
<!--begin::Project Report Main-->
			<div class="app-main flex-column flex-row-fluid" id="kt_app_main">
						<!--begin::Content wrapper-->
						<div class="d-flex flex-column flex-column-fluid">
							<!--begin::Toolbar-->
							<div id="kt_app_toolbar" class="app-toolbar py-3 py-lg-6">
								<!--begin::Toolbar container-->
								<div id="kt_app_toolbar_container" class="app-container container-xxl d-flex flex-stack">
									<!--begin::Page title-->
									<div class="page-title d-flex flex-column justify-content-center flex-wrap me-3">
										<!--begin::Title-->
										<h1 class="page-heading d-flex text-gray-900 fw-bold fs-3 flex-column justify-content-center my-0">Individual Report</h1>
										<!--end::Title-->
										<!--begin::Breadcrumb-->
										
										<!--end::Breadcrumb-->
									</div>
									<!--end::Page title-->
									<!--begin::Actions-->
									<div class="d-flex align-items-center gap-2 gap-lg-3">
										<!--begin::Filter menu-->
										<div class="m-0">
											<!--begin::Menu toggle-->
											<a href="#" class="btn btn-sm btn-flex btn-secondary fw-bold" data-kt-menu-trigger="click" data-kt-menu-placement="bottom-end">
											<i class="ki-duotone ki-filter fs-6 text-muted me-1">
												<span class="path1"></span>
												<span class="path2"></span>
											</i>Filter</a>
											<!--end::Menu toggle-->
											<!--begin::Menu 1-->
											<div class="menu menu-sub menu-sub-dropdown w-250px w-md-300px" data-kt-menu="true" id="kt_menu_66b9704f2d6ab">
												<!--begin::Header-->
												<div class="px-7 py-5">
													<div class="fs-5 text-gray-900 fw-bold">Filter Options</div>
												</div>
												<!--end::Header-->
												<!--begin::Menu separator-->
												<div class="separator border-gray-200"></div>
												<!--end::Menu separator-->
												<!--begin::Form-->
												<div class="px-7 py-5">
												    <form action="{{ route('filterindividualReport') }}" method="POST">
                                                    @csrf
													<!--begin::Input group-->
													<div class="mb-10">
														<!--begin::Label-->
														<label class="form-label fw-semibold">User Types:</label>
														<!--end::Label-->
														<!--begin::Input-->
														
															
															<div>
															<select class="form-select form-select-solid" data-control="select2" data-hide-search="true" data-placeholder="Select User Type" name="userType" id="userType" onchange="userTypeChanged();"  >	
															    <option></option>
																<option value="1">Delivery Agent </option>
																<option value="2">Contractor </option>																
																<option value="3">District Coordinator </option>
															</select>
														</div>
													
														<!--end::Input-->
													</div>
													<div class="mb-10">
														<!--begin::Label-->
														<label class="form-label fw-semibold">User Name:</label>
														<!--end::Label-->
														<!--begin::Input-->
														<div>
															<select class="form-select form-select-solid" data-control="select2" data-hide-search="true" data-placeholder="Select User Name" data-kt-ecommerce-order-filter="status" name="users" id="users">	
																<option></option>
																
															</select>
														</div>
														<!--end::Input-->
													</div>
													<!--end::Input group-->
													<!--begin::Input group-->
													
													<!--end::Input group-->
													<!--begin::Input group-->
												
													<!--end::Input group-->
													<!--begin::Actions-->
													<div class="d-flex justify-content-end">
														<button type="reset" class="btn btn-sm btn-light btn-active-light-primary me-2" data-kt-menu-dismiss="true">Reset</button>
														<button type="submit" class="btn btn-sm btn-primary" data-kt-menu-dismiss="true">Apply</button>
													</div>
													<!--end::Actions-->
														</form>
												</div>
												<!--end::Form-->
											</div>
											<!--end::Menu 1-->
										</div>
										<!--end::Filter menu-->
										<!--begin::Secondary button-->
										<!--end::Secondary button-->
										<!--begin::Primary button-->
										
										<!--end::Primary button-->
									</div>
									<!--end::Actions-->
								</div>
								<!--end::Toolbar container-->
							</div>
							<!--end::Toolbar-->
							<!--begin::Content-->
							<div id="kt_app_content" class="app-content flex-column-fluid">
								<!--begin::Content container-->
								<div id="kt_app_content_container" class="app-container container-xxl">
									<!--begin::Products-->
									<div class="card card-flush">
										<!--begin::Card header-->
										<div class="card-header align-items-center py-5 gap-2 gap-md-5">
											<!--begin::Card title-->
											<div class="card-title">
												<!--begin::Search-->
												<div class="d-flex align-items-center position-relative my-1">
													<i class="ki-duotone ki-magnifier fs-3 position-absolute ms-4">
														<span class="path1"></span>
														<span class="path2"></span>
													</i>
													<input type="text" data-kt-ecommerce-order-filter="search" class="form-control form-control-solid w-250px ps-12" placeholder="Search Report" />
												</div>
												<!--end::Search-->
												<!--begin::Export buttons-->
												<div id="kt_ecommerce_report_customer_orders_export" class="d-none"></div>
												<!--end::Export buttons-->
											</div>
											<!--end::Card title==

        <!==begin::Card toolbar-->
		
											<div class="card-toolbar flex-row-fluid justify-content-end gap-5">
												<!--begin::Daterangepicker-->
												<!--<input class="form-control form-control-solid w-100 mw-250px" placeholder="Pick date range" id="kt_ecommerce_report_customer_orders_daterangepicker" />-->
												<!--end::Daterangepicker-->
												<!--begin::Filter-->
												<!--<div class="w-150px">-->
													<!--begin::Select2-->
												<!--	<select class="form-select form-select-solid" data-control="select2" data-hide-search="true" data-placeholder="Project Status" data-kt-ecommerce-order-filter="status">-->
												<!--		<option></option>-->
												<!--		<option value="all">All</option>-->
												<!--		<option value="active">Pending</option>-->
												<!--		<option value="locked">Completed</option>-->
												<!--		<option value="disabled">Rejected</option>-->
												<!--		<option value="banned">Approve Request</option>-->
												<!--	</select>-->
													<!--end::Select2-->
												<!--</div>-->
												<!--end::Filter-->
												<!--begin::Export dropdown-->
												<button type="button" class="btn btn-light-primary" data-kt-menu-trigger="click" data-kt-menu-placement="bottom-end">
												<i class="ki-duotone ki-exit-up fs-2">
													<span class="path1"></span>
													<span class="path2"></span>
												</i>Export Report</button>
												<!--begin::Menu-->
												<div id="kt_ecommerce_report_customer_orders_export_menu" class="menu menu-sub menu-sub-dropdown menu-column menu-rounded menu-gray-600 menu-state-bg-light-primary fw-semibold fs-7 w-200px py-4" data-kt-menu="true">
													
													<!--begin::Menu item-->
													<div class="menu-item px-3">
														<a href="#" class="menu-link px-3" data-kt-ecommerce-export="excel">Export as Excel</a>
													</div>
													<!--end::Menu item-->
													<!--begin::Menu item-->
													<div class="menu-item px-3">
														<a href="#" class="menu-link px-3" data-kt-ecommerce-export="csv">Export as CSV</a>
													</div>
													<!--end::Menu item-->
													<!--begin::Menu item-->
													<div class="menu-item px-3">
														<a href="#" class="menu-link px-3" data-kt-ecommerce-export="pdf">Export as PDF</a>
													</div>
													<!--end::Menu item-->
												</div>
												<!--end::Menu-->
												<!--end::Export dropdown-->
											</div>
											<!--end::Card toolbar-->
										</div>
										<!--end::Card header-->
										<!--begin::Card body-->
										<div class="card-body pt-0">
											<!--begin::Table-->
											<table class="table align-middle table-row-dashed fs-6 gy-5" id="kt_ecommerce_report_customer_orders_table">
												<thead>
													<tr class="text-start text-gray-500 fw-bold fs-7 text-uppercase gs-0">
														<th class="min-w-50px">ID</th>
														<th class="min-w-100px">Project ID</th>
														<th class="min-w-150px">Project Name</th>
													<!--	<th class="min-w-150px">Project Status</th>-->
														<th class="min-w-150px">SchoolName</th>
														<th class="min-w-100px">District </th>
														<th class="min-w-100px">BRC </th>
														<th class="min-w-100px">LSGD</th>
														<th class="min-w-100px">Task Name</th>
														<th class="min-w-100px">Task Status</th>
														<th class="min-w-150px">Voucher Amt</th>
														<th class="min-w-150px">Assigned Date </th>
														<th class="min-w-150px">Start Date</th>
														<th class="min-w-150px">End Date </th>
														<th class="min-w-275px">User Type </th>
														<th class="min-w-250px">User Name</th>
														<th class="min-w-250px">User Contact No</th>
														<th class="min-w-250px">User Email</th>
													</tr>
												</thead>
												<tbody class="fw-semibold text-gray-600">
												    @php
												    $sl=0;
												    @endphp
												
													 @forEach($projects as $pro)
													   	@php
													 
												
                                                        switch($pro['projectStatus']){
                                                            case"Pending":
                                                             $text_color="yellow";
                                                            break;
                                                            case"New":
                                                             $text_color="blue";
                                                            break;
                                                            case"Completed":
                                                             $text_color="blue";
                                                            break;
                                                            case"Rejected":
                                                             $text_color="red";
                                                            break;
                                                            case"In Progress":
                                                             $text_color="orange";
                                                            break;
                                                        }
                                                      	
                                                        @endphp    
												
                                                        <tr>
                                                            <td>{{ ++$sl }}</td>
                                                            <td>{{ $pro['projectId'] }}</td>
                                                           <td>{{ $pro['projectName'] }}</td>
                                                         <!--  <td><span style="color:{{ $text_color}}">{{ $pro['projectStatus'] }}</span></td>-->
                                                           <td>{{ $pro['school_name'] }}</td>
                                                            <td>{{ $pro['district'] }}</td>
                                                            <td>{{ $pro['brc'] }}</td>
                                                            <td>{{ $pro['panchayat'] }}</td>
                                                            <td>{{ $pro['task_name'] }}</td>
                                                            <td>{{ $pro['task_status'] }}</td>
                                                            <td>{{ $pro['voucher_amt']}}</td>
                                                            <td>{{date('d/m/Y',strtotime($pro['assigned_date'])) }}</td>
                                                            <td>{{date('d/m/Y',strtotime($pro['start_date'])) }}</td>
                                                            <td>{{date('d/m/Y',strtotime($pro['end_date'])) }}</td>
                                                            <td>{{ $pro['user_type'] }}</td>
                                                            <td>{{ $pro['user_name'] }}</td>
                                                            <td>{{ $pro['user_contact'] }}</td>
                                                            <td>{{ $pro['user_email'] }}</td>
                                                        </tr>    
                                                    @endforeach 
												</tbody>
											</table>
											<!--end::Table-->
										</div>
										<!--end::Card body-->
									</div>
									<!--end::Products-->
								</div>
								<!--end::Content container-->
							</div>
							<!--end::Content-->
						</div>
						<!--end::Content wrapper-->
						<!--begin::Footer-->
						<div id="kt_app_footer" class="app-footer">
							<!--begin::Footer container-->
							<div class="app-container container-fluid d-flex flex-column flex-md-row flex-center flex-md-stack py-3">
								<!--begin::Copyright-->
								<div class="text-gray-900 order-2 order-md-1">
									<span class="text-muted fw-semibold me-1">2024&copy;</span>
									<a href="#" target="_blank" class="text-gray-800 text-hover-primary">PMS</a>
								</div>
								<!--end::Copyright-->
								<!--begin::Menu-->
							
								<!--end::Menu-->
							</div>
							<!--end::Footer container-->
						</div>
						<!--end::Footer-->
					</div>
					<script>
			            function userTypeChanged(){
                            const user_type = $('#userType').val();
                            
                            // Clear the Panchayat dropdown
                            $('#users').html('<option value="">Select</option>');
                    
                            if (user_type) {
                                // Make AJAX request to fetch panchayats
                                $.ajax({
                                    url: '{{ route('getUsers') }}', // Replace with your route URL
                                    type: 'GET',
                                    data: { userType: user_type },
                                    success: function (data) {
                                   
                                        if (data) {
                                            
                                            console.log(data);
                                            // Append panchayat options
                                            data.forEach(function (users) {
                                                
                                                $('#users').append(
                                                    `<option value="${users.user_id}">${users.user_name}</option>`
                                                );
                                               
                                            });
                                        }
                                    },
                                    error: function () {
                                        alert('Failed to load Users. Please try again.');
                                    },
                                });
                               
                            }
                        }
					</script>

@endsection