110 lines
5.0 KiB
PHP
110 lines
5.0 KiB
PHP
<?php
|
|
check_message();
|
|
?>
|
|
|
|
<div class="row">
|
|
<div class="col-lg-12">
|
|
<h1 class="page-header">List of Deceased Person <a href="index.php?view=add" class="btn btn-primary btn-xs "> <i class="fa fa-plus-circle fw-fa"></i> New</a> </h1>
|
|
</div>
|
|
<!-- /.col-lg-12 -->
|
|
</div>
|
|
<form action="controller.php?action=delete" Method="POST">
|
|
<div class="table-responsive">
|
|
<table id="dash-table" class="table table-striped table-bordered table-hover " style="font-size:12px" cellspacing="0" >
|
|
|
|
<thead>
|
|
<tr>
|
|
<th>#</th>
|
|
<th>Name of the Deceased</td>
|
|
<th>Born</th>
|
|
<th>Died</th>
|
|
<th>Section</th>
|
|
<th>Location</th>
|
|
</tr>
|
|
</thead>
|
|
|
|
<tbody>
|
|
<?php
|
|
|
|
$query = "SELECT * FROM `tblpeople`";
|
|
$mydb->setQuery($query);
|
|
$cur = $mydb->loadResultList();
|
|
|
|
foreach ($cur as $result) {
|
|
|
|
// $borndate = ($result->BORNDATE !='0000-00-00') ? date_format(date_create($result->BORNDATE), "m/d/Y"): 'NONE';
|
|
// $dieddate = ($result->DIEDDATE !='0000-00-00') ? date_format(date_create($result->DIEDDATE), "m/d/Y") : 'NONE';
|
|
|
|
|
|
$borndate = $result->BORNDATE;
|
|
$dieddate = $result->DIEDDATE;
|
|
|
|
|
|
|
|
echo '<tr>';
|
|
echo '<td width="1%" align="center"><input type="checkbox" name="selector[]" id="selector[]" value="'.$result->PEOPLEID. '"/>'. $result->GRAVENO.'</td>';
|
|
// echo '<td><a title="edit" href="'.web_root.'admin/person/index.php?view=edit&id='.$result->PEOPLEID.'"><i class="fa fa-pencil "></i>'.$result->LNAME.', '.$result->FNAME.' '.$result->MNAME.'</a></td>';
|
|
echo '<td><a title="edit" href="'.web_root.'admin/person/index.php?view=edit&id='.$result->PEOPLEID.'"><i class="fa fa-pencil "></i>'.$result->FNAME.'</a></td>';
|
|
echo '<td>'. $borndate.'</td>';
|
|
echo '<td>'. $dieddate.'</td>';
|
|
echo '<td>'. $result->CATEGORIES.'</td>';
|
|
echo '<td>'. $result->LOCATION.'</td>';
|
|
echo '</tr>';
|
|
}
|
|
?>
|
|
</tbody>
|
|
|
|
|
|
</table>
|
|
|
|
<div class="btn-group">
|
|
<!-- <a href="index.php?view=add" class="btn btn-default">New</a> -->
|
|
<button type="submit" class="btn btn-default" name="delete"><i class="fa fa-trash fw-fa"></i> Delete Selected</button>
|
|
</div>
|
|
</div>
|
|
</form>
|
|
|
|
<div class="modal fade" id="productmodal" tabindex="-1">
|
|
<div class="modal-dialog">
|
|
<div class="modal-content">
|
|
<div class="modal-header">
|
|
<button class="close" data-dismiss="modal" type=
|
|
"button">�</button>
|
|
|
|
<h4 class="modal-title" id="myModalLabel">Image.</h4>
|
|
</div>
|
|
|
|
<form action="<?php echo web_root; ?>admin/products/controller.php?action=photos" enctype="multipart/form-data" method=
|
|
"post">
|
|
<div class="modal-body">
|
|
<div class="form-group">
|
|
<div class="rows">
|
|
<div class="col-md-12">
|
|
<div class="rows">
|
|
<div class="col-md-8">
|
|
|
|
<input class="proid" type="hidden" name="proid" id="proid" value="">
|
|
<input name="MAX_FILE_SIZE" type=
|
|
"hidden" value="1000000"> <input id=
|
|
"photo" name="photo" type=
|
|
"file">
|
|
</div>
|
|
|
|
<div class="col-md-4"></div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="modal-footer">
|
|
<button class="btn btn-default" data-dismiss="modal" type=
|
|
"button">Close</button> <button class="btn btn-primary"
|
|
name="savephoto" type="submit">Upload Photo</button>
|
|
</div>
|
|
</form>
|
|
</div><!-- /.modal-content -->
|
|
</div><!-- /.modal-dialog -->
|
|
</div><!-- /.modal -->
|
|
|
|
|