66 lines
1.6 KiB
PHP
66 lines
1.6 KiB
PHP
<div class="card" onclick="window.location='notice_details.php'">
|
|
|
|
<!-- /.card-header -->
|
|
<div class="card-body p-0">
|
|
<div class="table-responsive">
|
|
<table class="table m-0">
|
|
<thead>
|
|
<tr style="color:black;">
|
|
<th width="4%" style="background-color:white"><strong>Sr.</strong></th>
|
|
<th width="30%" style="background-color:white"><strong>SOP Name</strong></th>
|
|
<th width="30%" style="background-color:white"><strong>Certificate. No</strong></th>
|
|
<th width="50%" style="background-color:white"><strong>Next Renewal Date</strong></th>
|
|
|
|
</tr>
|
|
</thead>
|
|
|
|
<tbody>
|
|
<?php
|
|
|
|
|
|
$new_renewal_date = $row['new_renewal_date'];
|
|
|
|
$new_date = date('Y-m-d', strtotime($new_renewal_date . ' -1 months'));
|
|
|
|
$currentDate = date('Y-m-d');
|
|
error_log($currentDate);
|
|
|
|
|
|
|
|
|
|
$quiry = getTableFieldValue('sop_document', 'date(date(`new_renewal_date`)-INTERVAL 30 DAY)', 'new_renewal_date', $new_renewal_date);
|
|
error_log($quiry . "dipak mali");
|
|
|
|
|
|
?>
|
|
|
|
<?php
|
|
$sqlgetdata = "SELECT * FROM sop_document where new_renewal_date BETWEEN NOW() - INTERVAL 30 day and now() ";
|
|
|
|
error_log($sqlgetdata . "sql");
|
|
|
|
|
|
|
|
$resultgetdata = @mysqli_query($conn, $sqlgetdata);
|
|
|
|
while ($rowgetdata = mysqli_fetch_array($resultgetdata)) {
|
|
?>
|
|
<tr>
|
|
|
|
<td><?php echo $i++; ?></td>
|
|
<td><?php echo $rowgetdata['medical_doc_desc']; ?></td>
|
|
<td><?php echo $rowgetdata['sop_number'] ?></td>
|
|
<td><?php echo $rowgetdata['new_renewal_date'] ?></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
|
|
|
|
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
<!-- /.table-responsive -->
|
|
</div>
|
|
</div>
|