зеркало из https://github.com/mozilla/oldpto.git
82 строки
1.9 KiB
PHP
82 строки
1.9 KiB
PHP
<?php
|
|
|
|
require_once('config.php');
|
|
require_once('auth.php');
|
|
|
|
function pretty_die() {
|
|
global $GLOBAL_AUTH_USERNAME;
|
|
include './templates/header.php';
|
|
echo 'There was a problem getting your PTO records. Please try again later.';
|
|
include './templates/footer.php';
|
|
exit;
|
|
}
|
|
|
|
$me = $GLOBAL_AUTH_USERNAME;
|
|
|
|
$conn = @mysql_connect($mysql['host'], $mysql['user'], $mysql['password'])
|
|
or pretty_die();
|
|
|
|
@mysql_select_db($mysql['database'], $conn) or pretty_die();
|
|
|
|
$query = "select
|
|
added,
|
|
start,
|
|
end,
|
|
details
|
|
from pto
|
|
where person = '".mysql_real_escape_string($me, $conn)."'
|
|
order by start desc";
|
|
|
|
$result = @mysql_query($query, $conn) or pretty_die();
|
|
|
|
$mypto = array();
|
|
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
|
|
$row['added'] = date('D, d M Y', $row['added']);
|
|
$row['start'] = date('D, d M Y', $row['start']);
|
|
$row['end'] = date('D, d M Y', $row['end']);
|
|
$mypto[] = $row;
|
|
}
|
|
|
|
mysql_free_result($result);
|
|
mysql_close($conn);
|
|
|
|
$i = 0;
|
|
$mypto_table_contents = '';
|
|
foreach ($mypto as $row) {
|
|
// adding some row colours
|
|
$i++;
|
|
if ($i%2 == 0) {
|
|
$mypto_table_contents .= '<tr class="highlight">';
|
|
}
|
|
else {
|
|
$mypto_table_contents .= '<tr>';
|
|
}
|
|
|
|
foreach($row as $value) {
|
|
$mypto_table_contents .= '<td>'.$value.'</td>';
|
|
}
|
|
$mypto_table_contents .= '</tr>';
|
|
}
|
|
|
|
include './templates/header.php';
|
|
?>
|
|
<div class='pto_table_container'>
|
|
<h2>My Reported PTO</h2>
|
|
<table id='mypto_table' class='display'>
|
|
<thead>
|
|
<tr>
|
|
<th class='datetime'>Added</th>
|
|
<th class='datetime'>Start</th>
|
|
<th class='datetime'>End</th>
|
|
<th>Details</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php echo $mypto_table_contents; ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
|
|
<?php
|
|
include './templates/footer.php';
|