<?php

include "../../config/master.php";
allowRoles([1,5]);

include "../layout/header.php";
include "../layout/sidebar.php";

$role_id = $_SESSION['role_id'] ?? 0;

if($role_id == 1){

$anganwadi=mysqli_query($conn,"
SELECT a.*,v.village_name
FROM village_anganwadi a
LEFT JOIN villages v ON a.village_id=v.id
ORDER BY a.id DESC
");

}else{

$village_id=$_SESSION['village_id'];

$anganwadi=mysqli_query($conn,"
SELECT a.*,v.village_name
FROM village_anganwadi a
LEFT JOIN villages v ON a.village_id=v.id
WHERE a.village_id='$village_id'
ORDER BY a.id DESC
");

}

?>

<div class="main">

<div style="display:flex;justify-content:space-between;margin-bottom:20px;">

<h2>Village Anganwadi</h2>

<a href="add_anganwadi.php" class="btn-success">Add Anganwadi</a>

</div>

<table>

<thead>

<tr>
<th>#</th>
<th>Village</th>
<th>Image</th>
<th>Anganwadi</th>
<th>Location</th>
</tr>

</thead>

<tbody>

<?php
$i=1;

while($row=mysqli_fetch_assoc($anganwadi)){
?>

<tr>

<td><?php echo $i++; ?></td>

<td><?php echo $row['village_name']; ?></td>

<td>

<?php if($row['image']){ ?>

<img src="../../uploads/anganwadi/<?php echo $row['image']; ?>" width="50">

<?php } ?>

</td>

<td><?php echo $row['anganwadi_name']; ?></td>

<td><?php echo $row['location']; ?></td>

</tr>

<?php } ?>

</tbody>

</table>

</div>

<?php include "../layout/footer.php"; ?>