| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/(Del)pathways.org.hk/MIS20140127/old20140414/Payroll/ |
Upload File : |
<!DOCTYPE html>
<?php require_once 'PayRoll_Sql.php'; ?>
<?php ($staff_array = Search_Staff_Name()->fetchAll(PDO::FETCH_ASSOC)); ?>
<?php ob_start(); ?>
<?php
if (isset($_GET['search']['search_button'])) {
$staff_name = $_GET['search']['staff_name'];
$start_date = $_GET['search']['start_date'];
$end_date = $_GET['search']['end_date'];
$position = $_GET['search']["position"];
}
?>
<html>
<head>
<?php require_once '../include/head.php'; ?>
<?php require_once '../include/checkuser.php'; ?>
<?php require_once '../include/Nav_bar.php'; ?>
<script>
$(function() {
$("#staff_name").select2();
$("#start_date").datetimepicker({autoclose: true, pickTime: false, format: 'yyyy-MM-dd'})
$("#end_date").datetimepicker({autoclose: true, pickTime: false, format: 'yyyy-MM-dd'})
$('#start_date').datetimepicker().on('changeDate', function(ev) {
date = new Date($('#start_date_input').val());
$('#end_date').datetimepicker('setStartDate', date);
$('#end_date').datetimepicker('setDate', date);
$('#end_date').datetimepicker('show');
$('#start_date').datetimepicker('hide');
$('#end_date').datetimepicker('remove');
});
$('#end_date').datetimepicker().on('changeDate', function(ev) {
$('#end_date').datetimepicker('hide');
});
})
</script>
<style>
.div-search{
margin: 0;
padding: 5px 10px;
background-color: #F7F7F7;
border: 1px solid #E6E6E6;
border-radius: 5px;
box-shadow: 0 1px 2px rgba(0,0,0,.05);
}
</style>
</head>
<body>
<!-- line between nav bar and content -->
<div class="text-right">
<ul class="breadcrumb">
<li class="active"></li>
</ul>
</div>
<div class="container-fluid pathways-container">
<h3>Payroll</h3>
<form class="form-inline" action="" method="get" autocomplete="off">
<div class="div-search">
<table style="margin: 10px 10px 10px 10px;width: 100%">
<tr>
<td>Staff Name</td>
<td style="width: 10px;"></td>
<td>
<select id="staff_name" name="search[staff_name]" style="width: 300px;">
<option></option>
<?php foreach ($staff_array as $arr) { ?>
<option value="<?= $arr['root_id'] ?>"><?= $arr['name'] ?></option>
<?php } ?>
</select>
</td>
<td style="width: 15px;"></td>
<td style="padding-top: 5px;">Start Date</td>
<td style="width: 10px;"></td>
<td>
<div id="start_date" class="input-append date form_datetime datetime_picker">
<input type="text" id="start_date_input" name="search[start_date]" />
<span class="add-on"><i class="icon-calendar"></i></span>
</div>
</td>
<td style="width: 15px;"></td>
<td style="padding-top: 5px;">End Date</td>
<td style="width: 10px;"></td>
<td>
<div id="end_date" class="input-append date form_datetime datetime_picker">
<input type="text" id="end_date_input" name="search[end_date]" />
<span class="add-on"><i class="icon-calendar"></i></span>
</div>
</td>
<td style="width: 15px;"></td>
</tr>
<tr style="height:15px;"></tr>
<tr>
<td>Position</td>
<td></td>
<td>
<select name="search[position]">
<option></option>
<?php $sth = Position_List(); ?>
<?php while ($result = $sth->fetch(PDO::FETCH_ASSOC)) { ?>
<option value="<?= $result['position_id'] ?>"><?= $result['position_name'] ?></option>
<?php } ?>
</select>
</td>
<td style="width: 20px;"></td>
<td colspan="7"><button type="submit" class="btn pull-right" name="search[search_button]">Search</button></td>
</tr>
</table>
</div>
</form>
<?php if (isset($_GET['search']['search_button'])) { ?>
<form action="" method="post">
<table class="table table-striped table-bordered table-hover table-condensed">
<thead>
<tr>
<th style="width: 50px;"></th>
<th>Payroll No.</th>
<th>Staff Name</th>
<th>Staff Position</th>
<th>Payroll Period</th>
<th>Total Amount</th>
<th>Creation Date</th>
</tr>
</thead>
<tbody>
<?php $sth = Find_Payrollby_date_staffid($staff_name, $start_date, $end_date, $position); ?>
<?php if ($sth->rowCount() > 0) { ?>
<?php while ($result = $sth->fetch(PDO::FETCH_ASSOC)) { ?>
<tr>
<td style="margin-left:auto;margin-right:auto;">
<div class="btn-group" data-toggle="buttons">
<a href="PayRoll_Generate_From.php?view=1&root_id=<?= $result['root_id'] ?>&startdate=<?= $result['start_date'] ?>&enddate=<?= $result['end_date'] ?>&payroll_id=<?= $result['payroll_id'] ?>" class="btn"><i class="icon-eye-open"></i> View</a>
</div>
</td>
<td><?= $result['payroll_code'] ?></td>
<td><?= $result['name'] ?></td>
<td><?= $result['position_name'] ?></td>
<td><?= $result['start_date'] . " - " . $result['end_date'] ?></td>
<td>$ <?= number_format($result['total_amount'], 2) ?></td>
<td><?= $result['payroll_date'] ?></td>
</tr>
<?php } ?>
<?php } else { ?>
<tr>
<td colspan="6">No Payroll !!</td>
</tr>
<?php } ?>
</tbody>
</table>
</form>
<?php } ?>
</div> <!-- /container -->
</body>
</html>