You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
58 lines
2.2 KiB
58 lines
2.2 KiB
<div class="row pb-4">
|
|
<div class="col-12">
|
|
<div class="section-title">Variazioni albo
|
|
<div class="right">
|
|
<form method="post">
|
|
<select name="year" class="py-1" onChange="this.form.submit()">
|
|
<?php
|
|
|
|
$currentYear = $_POST['year'] ? $_POST['year'] : date("Y");
|
|
$q=mysqli_query($conn,"SELECT DISTINCT YEAR(date) FROM files WHERE path='/docs/variazioni-albo' ORDER BY YEAR(date) DESC");
|
|
while($r=mysqli_fetch_array($q)){
|
|
echo "<option value=\"".$r[0]."\" ";
|
|
if($r[0] == $currentYear){echo "selected";}
|
|
echo ">".$r[0]."</option>";
|
|
}
|
|
?>
|
|
</select>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="col-12 file-list">
|
|
<div class="item-title pt-4">
|
|
<div class=" row">
|
|
<div class="title col-6 col-sm-8 font-bold">nome del file</div>
|
|
<div class="size col-2 font-bold">dimensione</div>
|
|
<div class="date text-right col-4 col-sm-2 font-bold">ultima mod.</div>
|
|
</div>
|
|
</div>
|
|
<?php
|
|
$q=mysqli_query($conn,"SELECT * FROM files WHERE path='/docs/variazioni-albo' AND date LIKE '$currentYear%'");
|
|
while($r=mysqli_fetch_array($q)){
|
|
item_file($r);
|
|
}
|
|
?>
|
|
</div>
|
|
|
|
<div class="col-12 mt-5">
|
|
<div class="section-title">Variazioni farmacie</div>
|
|
</div>
|
|
|
|
<div class="col-12 file-list">
|
|
<div class="item-title pt-4">
|
|
<div class=" row">
|
|
<div class="title col-6 col-sm-8 font-bold">nome del file</div>
|
|
<div class="size col-2 font-bold">dimensione</div>
|
|
<div class="date text-right col-4 col-sm-2 font-bold">ultima mod.</div>
|
|
</div>
|
|
</div>
|
|
<?php
|
|
$q=mysqli_query($conn,"SELECT * FROM files WHERE path='/docs/variazioni-farmacie'");
|
|
while($r=mysqli_fetch_array($q)){
|
|
item_file($r);
|
|
}
|
|
?>
|
|
</div>
|
|
</div>
|