function display($title, $content)
{
print showHeader($title);
print $content;
print showFooter();
exit;
}
/**
* Show login page
*
* @return void
*/
function showLogin()
{
showHeader();
?>
<form name="login" method="post" action="">
<table class="form">
<tr>
<th class="title" colspan="2">Authentification administrateur obligatoire</th>
</tr>
<tr>
<th><label for="username">Nom d'utilisateur :</label></th>
<td><input type="text" name="username" autofocus="autofocus" /></td>
</tr>
<tr>
<th><label for="password">Mot de passe :</label></th>
<td><input type="password" name="password" /></td>
</tr>
<tr>
<td class="button" colspan="2"><button class="submit" type="submit">Valider</button></td>
</tr>
</table>
</form>
<?php
showFooter();
}
function showLogin($error = '')
{
showHeader();
if ($error) {
print $error;
}
print <<<LOGINFORM
\t\t<form action="{$_SERVER['PHP_SELF']}" method="post">
\t\t<table>
\t\t\t<tr><td><b>Username:</b></td><td><input type="text" name="username" /></td></tr>
\t\t\t<tr><td><b>Password:</b></td><td><input type="password" name="password" /></td></tr>
\t\t\t<tr><td colspan="2"><button name="Login" value="Login" type="submit">Login</button></td></tr>
\t\t</table>
\t\t</form>
LOGINFORM;
showFooter();
}
/**
* Displays the main content of the page.
*
* @param $title The title of the page
*/
function showContent($title)
{
$db = new DB();
$cartID = getCartID();
$sql = "SELECT ID, name, products.price, quantity, date \n FROM shoppingcarts, products\n WHERE productID=ID AND CartID='{$cartID}'";
$result = $db->query($sql);
echo "<h1>{$title}</h1>\n";
echo "<table>\n";
showHeading();
$user = isset($_SESSION['user']) ? $_SESSION['user'] : "";
while ($row = mysql_fetch_row($result)) {
list($productId, $prodName, $price, $qty, $date) = $row;
$total += $price * $qty;
showItem($productId, $prodName, $price, $qty);
$sql = "INSERT INTO orders(username, date, status)\n VALUES ('{$user}', '{$date}', 'ordered')";
$db->query($sql);
$sql = "INSERT INTO orderItems(orderID, productID, quantity, status)\n VALUES ('LAST_INSERT_ID()', '{$productId}', '{$qty}', 'ordered')";
$db->query($sql);
$sql = "DELETE FROM shoppingcarts WHERE CartID='{$cartID}'";
$db->query($sql);
}
$total = "\$" . number_format($total, 2);
showFooter($total);
echo "</table>\n";
$sql = "SELECT fname, lname, address, city, state, zip, country\n FROM customers, addresses \n WHERE customers.username=addresses.username \n AND customers.username='******'";
$result = $db->query($sql);
$row = mysql_fetch_row($result);
list($fname, $lname, $address, $city, $state, $zip, $country) = $row;
echo "<p>This order will be shipped to</p>";
echo "<p>{$fname} {$lname}</p>";
echo "<p>{$address}</p>";
echo "<p>{$city}, {$state} {$zip}</p>";
echo "<p>{$country}</p>";
setcookie('cartID', '', time() - 86400, '/');
session_destroy();
}
function showPage($username = '', $accessLvl = '', $errors = '')
{
showHeader($username, $accessLvl);
global $db;
if ($errors) {
//show errors at top of page
print '<h2 class = "error"> The following errors were encountered:</h2>';
print '<ul><li>';
print implode('</li><li>', $errors);
print '</li></ul>';
}
if (isset($_POST['amount'])) {
print <<<ADDREFUNDPAGE
\t\t<h2 align="center">Add a New Refund</h2>
\t\t<a href="refunds.php">Back to Refunds</a>
\t<br/><br/>
\t
\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="add_refund" enctype="multipart/form-data">
<table style="width: 100%" border="1">
<tbody>
<tr>
<td>Urgent</td>
<td><input maxlength="50" name="urgent" type="checkbox" value ="1"><br>
</td>
</tr>
<tr>
\t<td>Amount</td>
\t\t\t
\t<td><input maxlength="50" name="amount" type="text" value ="{$_POST['amount']}"><br />
</tr>
<tr>
<td>Check Payable To:</td>
<td><input name="payable" type="text" value="{$_POST['payable']}">
</td>
</tr>
<tr>
<td>Address Line 1</td>
<td><input name="addr_ln_1" type="text" value="{$_POST['addr_ln_1']}">
</td>
</tr>
<tr>
<td>Address Line 2</td>
<td><input name="addr_ln_2" type="text" value="{$_POST['addr_ln_2']}">
</td>
</tr>
<tr>
<td>City</td>
<td><input name="city" type="text" value="{$_POST['city']}">
</td>
<tr>
<td>State</td>
<td><input maxlength="2" name="state" type="text" value="{$_POST['state']}">
</td>
</tr>
<tr>
<td>Zip</td>
<td><input maxlength="10" name="zip" type="text" value="{$_POST['zip']}">
</td>
</tr>
<tr>
<td>Encounter Number</td>
<td><input name="enc_nbr" type="text" value="{$_POST['enc_nbr']}">
</td>
</tr>
<tr>
<td>Purpose</td>
<td><input name="purpose" type="text" value="{$_POST['purpose']}">
</td>
</tr>
<tr>
<td>Comments</td>
<td><textarea name="comments" cols="20" rows="4" value="{$_POST['comments']}" ></textarea>
</td>
</tr>
<tr>
\t<td>Attachment 1</td>
\t<td><input type="file" name="file1" ></td>
</tr>
<tr>
\t<td>Attachment 2</td>
\t<td><input type="file" name="file2"></td>
</tr>
<tr>
\t<td>Attachment 3</td>
\t<td><input type="file" name="file3"></td>
</tr>
<tr>
\t<td>Attachment 4</td>
\t<td><input type="file" name="file4"></td>
</tr>
<tr>
\t<td>Attachment 5</td>
\t<td><input type="file" name="file5"></td>
</tr>
</tbody>
</table>
<input type="hidden" name="_submit_check" value="1" />
\t <br/>
<button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="submit" name="Submit">Request Refund</button></form>
ADDREFUNDPAGE;
} else {
print <<<ADDREFUNDPAGE
\t\t<h2 align="center">Add a New Refund</h2>
\t\t\t<a href="refunds.php">Back to Refunds</a>
\t<br/><br/>
\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="add_refund" enctype="multipart/form-data">
<table style="width: 100%" border="1">
<tbody>
<tr>
<td>Urgent</td>
<td><input maxlength="50" name="urgent" type="checkbox" value ="1"><br>
</td>
</tr>
<tr>
\t<td>Amount</td>
\t\t\t
\t<td><input maxlength="50" name="amount" type="text" value =""><br />
</tr>
<tr>
<td>Check Payable To:</td>
<td><input name="payable" type="text" value="">
</td>
</tr>
<tr>
<td>Address Line 1</td>
<td><input name="addr_ln_1" type="text" value="">
</td>
</tr>
<tr>
<td>Address Line 2</td>
<td><input name="addr_ln_2" type="text" value="">
</td>
</tr>
<tr>
<td>City</td>
<td><input name="city" type="text" value="">
</td>
<tr>
<td>State</td>
<td><input maxlength="2" name="state" type="text" value="">
</td>
</tr>
<tr>
<td>Zip</td>
<td><input maxlength="10" name="zip" type="text" value="">
</td>
</tr>
<tr>
<td>Encounter Number</td>
<td><input name="enc_nbr" type="text" value="">
</td>
</tr>
<tr>
<td>Purpose</td>
<td><input name="purpose" type="text" value="">
</td>
</tr>
<tr>
<td>Comments</td>
<td><textarea name="comments" cols="20" rows="4" value="" ></textarea>
</td>
</tr>
<tr>
\t<td>Attachment 1</td>
\t<td><input type="file" name="file1" ></td>
</tr>
<tr>
\t<td>Attachment 2</td>
\t<td><input type="file" name="file2"></td>
</tr>
<tr>
\t<td>Attachment 3</td>
\t<td><input type="file" name="file3"></td>
</tr>
<tr>
\t<td>Attachment 4</td>
\t<td><input type="file" name="file4"></td>
</tr>
<tr>
\t<td>Attachment 5</td>
\t<td><input type="file" name="file5"></td>
</tr>
</tbody>
</table>
<input type="hidden" name="_submit_check" value="1" />
\t <br/>
<button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="submit" name="Submit">Request Refund</button></form>
ADDREFUNDPAGE;
}
showFooter();
}
function showPost($title, $url, $path, $tags, $pdate)
{
showHeader($title);
showPostContent($title, $url, $path, $tags, $pdate, false);
showFooter();
return true;
}
</div>
</form>
<div style="padding: 5px; font-weight: bold; height: 30px; background: orange; color: white; border-radius: 0px 0px 10px 10px; float: right;">
<label style="display: inline-block; float: right; padding: 0px 10px 0px 10px;">
Total Items: <?php
echo $itemsAvail;
?>
</label>
</div>
</div>
</div>
<div style="width: 100%; height: 100px; background: white; box-shadow: 0px 0px 10px 2px gray inset; border-radius: 0px 0px 10px 10px; margin-top: 10px;">
<?php
echo showFooter();
?>
</div>
</div>
</div>
</div>
</div>
<?php
//closeDB($con);
?>
</body>
</html>
function showPage($username = '', $accessLvl = '', $errors = '')
{
showHeader($username, $accessLvl);
global $db;
if ($errors) {
//show errors at top of page
print '<h2 class = "error"> The following errors were encountered:</h2>';
print '<ul><li>';
print implode('</li><li>', $errors);
print '</li></ul>';
}
$parts_emailName_30 = explode("@", $_SESSION['mailto_over30']);
$parts_emailName_15 = explode("@", $_SESSION['mailto_over15']);
print <<<ADDUSERPAGE
\t\t\t<h2 align="center">Configure Email Settings</h2>
\t\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="add_user">
\t\t <table style="width: 100%" border="1">
\t\t\t<tbody>
\t\t\t <tr>
\t\t\t\t<td>Email After 30 Days</td>
\t\t\t\t<td>
\t <select name="30_days_overdue">
ADDUSERPAGE;
$query_users = 'SELECT user_id, first_name, last_name, username FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
while ($row_users = mysqli_fetch_array($result_users)) {
$selected = $row_users['username'] === $parts_emailName_30[0] ? ' selected="selected"' : '';
print "<option value=\"{$row_users['user_id']}\" {$selected} ";
print ">{$row_users['first_name']} {$row_users['last_name']}</option>";
}
print <<<ADDUSERPAGE
</select>
<br>
</td>
</tr>
<tr>
\t\t <td>Email After 15 Days</td>
\t\t <td>
\t\t <select name="15_days_overdue">
ADDUSERPAGE;
$result_users_15 = mysqli_query($db, $query_users);
//$selected=1;
while ($row_users_15 = mysqli_fetch_array($result_users_15)) {
$selected = $row_users_15['username'] === $parts_emailName_15[0] ? ' selected="selected"' : '';
print "<option value=\"{$row_users_15['user_id']}\" {$selected} ";
print ">{$row_users_15['first_name']} {$row_users_15['last_name']}</option>";
}
print <<<ADDUSERPAGE
</select>
<br>
</td>
</tr>
<tr>
\t\t
\t\t</tbody>
</table>
<input type="hidden" name="_submit_check" value="1" />
\t <br>
<button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="submit" name="Submit">Add User</button></form>
ADDUSERPAGE;
print '<h4 align="center"><a href="admin.php">Return to User Administration Page</a></h4>';
showFooter();
}
function showPage($username = '', $accessLvl = '', $errors = '')
{
showHeader($username, $accessLvl);
global $db;
include 'connectToDB.php';
if ($errors) {
//show errors at top of page
print '<h2 class = "error"> The following errors were encountered:</h2>';
print '<ul><li>';
print implode('</li><li>', $errors);
print '</li></ul>';
}
//if(isset($_POST['first_name']) && isset($_POST['last_name']) && isset($_POST['username'])){
print <<<ADDUSERPAGE
\t\t\t<h2 align="center">Add/Edit Accounting Recipients</h2>
\t\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="add_acc_rec">
\t\t <table style="width: 100%" border="1">
\t\t\t<tbody>
\t\t\t <tr>
\t\t\t\t<td>Accounting Recipient 1</td>
\t\t\t\t<td><input maxlength="50" name="accounting_recipient_1" type="text" value ="{$_POST['accounting_recipient_1']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t \t<tr>
\t\t\t\t<td>Accounting Recipient 2</td>
\t\t\t\t<td><input maxlength="50" name="accounting_recipient_2" type="text" value ="{$_POST['accounting_recipient_2']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t \t<tr>
\t\t\t\t<td>Accounting Recipient 3</td>
\t\t\t\t<td><input maxlength="50" name="accounting_recipient_3" type="text" value ="{$_POST['accounting_recipient_3']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t
\t\t\t <tr>
\t\t\t\t<td>Billing Recipient 1</td>
\t\t\t\t<td><input maxlength="50" name="par1_recipient_1" type="text" value ="{$_POST['par1_recipient_1']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t<tr>
\t\t\t\t<td>Billing Recipient 2</td>
\t\t\t\t<td><input maxlength="50" name="par1_recipient_2" type="text" value ="{$_POST['par1_recipient_2']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t <tr>
\t\t\t\t<td>Billing Recipient 3</td>
\t\t\t\t<td><input maxlength="50" name="par1_recipient_3" type="text" value ="{$_POST['par1_recipient_3']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t \t\t
\t\t\t\t\t
\t\t\t\t\t <tr>
\t\t\t\t<td>Overdue 15 Days Recipient 1</td>
\t\t\t\t<td><input maxlength="50" name="over15_recipient_1" type="text" value ="{$_POST['over15_recipient_1']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t<tr>
\t\t\t\t<td>Overdue 15 Days Recipient 2</td>
\t\t\t\t<td><input maxlength="50" name="over15_recipient_2" type="text" value ="{$_POST['over15_recipient_2']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t <tr>
\t\t\t\t<td>Overdue 15 Days Recipient 3</td>
\t\t\t\t<td><input maxlength="50" name="over15_recipient_3" type="text" value ="{$_POST['over15_recipient_3']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t
\t\t\t\t\t <tr>
\t\t\t\t<td>Overdue 30 Days Recipient 1</td>
\t\t\t\t<td><input maxlength="50" name="over30_recipient_1" type="text" value ="{$_POST['over30_recipient_1']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t<tr>
\t\t\t\t<td>Overdue 30 Days Recipient 2</td>
\t\t\t\t<td><input maxlength="50" name="over30_recipient_2" type="text" value ="{$_POST['over30_recipient_2']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t <tr>
\t\t\t\t<td>Overdue 30 Days Recipient 3</td>
\t\t\t\t<td><input maxlength="50" name="over30_recipient_3" type="text" value ="{$_POST['over30_recipient_3']}"><br>
\t\t\t\t</td>
\t\t\t </tr>\t\t\t
\t\t\t\t\t
\t\t\t\t
\t\t\t\t\t <tr>
\t\t\t\t<td>Completed Recipient 1</td>
\t\t\t\t<td><input maxlength="50" name="completed_recipient_1" type="text" value ="{$_POST['completed_recipient_1']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t
\t\t\t \t\t <tr>
<td>Re-Assign Refund To: </td>
<td>
<select name="assignee">
ADDUSERPAGE;
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
while ($row_users = mysqli_fetch_array($result_users)) {
print "<option value=\"{$row_users['user_id']}\"";
print ">{$row_users['first_name']} {$row_users['last_name']}</option>";
}
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
print <<<EDITUSERPAGE
</select>
<br>
</td>
</tr>
\t\t\t
\t\t\t<tr>
\t\t\t\t<td>Completed Recipient 2</td>
\t\t\t\t<td><input maxlength="50" name="completed_recipient_2" type="text" value ="{$_POST['completed_recipient_2']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t <tr>
\t\t\t\t<td>Completed Recipient 3</td>
\t\t\t\t<td><input maxlength="50" name="completed_recipient_3" type="text" value ="{$_POST['completed_recipient_3']}"><br>
\t\t\t\t</td>
\t\t\t </tr>\t\t\t
\t\t\t\t\t <tr> Select A Name:
\t\t <select name="refund_search_term">
EDITUSERPAGE;
while ($row_users = mysqli_fetch_array($result_users)) {
print "<option value=\"{$row_users['user_id']}\"";
print $selected;
">{$row_users['first_name']} {$row_users['last_name']}</option>";
}
print <<<EDITUSERPAGE
\t\t </select>
\t\t <br>
\t\t</td>
\t </tr>\t
</tbody>
</table>
<input type="hidden" name="_submit_check" value="1" />
\t <br>
<button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="submit" name="Submit">Submit Changes</button></form>
\t
EDITUSERPAGE;
//}
print '<h4 align="center"><a href="admin.php">Return to User Administration Page</a></h4>';
showFooter();
}
function showPage($username = '', $accessLvl = '', $errors = '')
{
//page where user will select user to edit
global $db;
showHeader($username, $accessLvl);
if ($errors) {
//show errors at top of page
print '<h2 class = "error"> The following errors were encountered:</h2>';
print '<ul><li>';
print implode('</li><li>', $errors);
print '</li></ul>';
}
$query = "SELECT user_id, first_name,last_name,access_lvl, D.name, U.dept_id, username FROM users AS U INNER JOIN departments AS D ON U.dept_id = D.dept_id WHERE delete_ind IS NULL ORDER BY last_name,first_name";
$result = mysqli_query($db, $query);
print '<br /><br /><div align = "center">';
print '<table border="1" cellpadding = "3"><tr><td><b>First Name</b></td><td><b>Last Name</b></td><td><b>Username</b></td><td><b>Access Level</b></td><td><b>Department</b></td><td><b>Actions</b></td>';
while ($row = mysqli_fetch_array($result)) {
print '<tr><td>' . $row['first_name'] . '</td><td>' . $row['last_name'] . '</td><td>' . $row['username'] . '</td>';
if ($row['access_lvl'] == 'U') {
print '<td>User</td>';
} elseif ($row['access_lvl'] == 'A') {
print '<td>Approver</td>';
} elseif ($row['access_lvl'] == 'S') {
print '<td>Super User</td>';
} else {
print '<td><b>BAD DATA!</b></td>';
}
print '<td>' . $row['name'] . '</td>';
print '<td><a href="' . $_SERVER['PHP_SELF'] . '?user_id=' . $row['user_id'] . '&dept_id=' . $row['dept_id'] . '&action=edit">Edit</a> <a href="' . $_SERVER['PHP_SELF'] . '?user_id=' . $row['user_id'] . '&action=delete">Delete</a></td></tr>';
}
print '</table></div>';
print '<h4 align="center"><a href="admin.php">Return to User Administration Page</a></h4>';
showFooter();
}
function showInterface($body = '', $showHeaderAndFooter = true)
{
global $APP, $SETTINGS, $CURRENT_USER, $TABLE_PREFIX;
if ($showHeaderAndFooter) {
showHeader();
}
if ($body) {
include "lib/menus/{$body}";
}
if ($showHeaderAndFooter) {
showFooter();
}
exit;
}
/**
* Displays the main content of the page.
*
* @param $title The title of the page
* @param $db A DB object for secure database operations
*/
function showContent($title, $db)
{
$cartID = getCartId();
$sql = "SELECT ID, name, products.price, Quantity \n FROM shoppingcarts, products \n WHERE ID=ProductID AND CartID='{$cartID}'";
$result = $db->query($sql);
echo "<h1>{$title}</h1>\n";
echo "<table>\n";
showHeading();
$total = 0;
while ($row = mysql_fetch_row($result)) {
list($id, $prodName, $price, $qty) = $row;
$total += $price * $qty;
showItem($id, $prodName, $price, $qty);
}
$total = "\$" . number_format($total, 2);
showFooter($total);
echo "</table>\n";
$url = isset($_SESSION['user']) ? "true" : "false";
echo "<button onclick=\"checkout({$url})\">Checkout</button>\n";
$f = new FormLib();
?>
<p>Keep shopping</p>
<form action="products.php" method="post" id="categories">
<fieldset>
<legend>Select a category</legend>
<table>
<tr>
<td class="inputcell">
<?php
$list = array("All" => "", "On the Lawn" => "lawn", "Back at Camp" => "camping", "Jammin'" => "jam", "At the Lake" => "water", "Artists' CDs" => "cd");
echo $f->makeSelect('category', $list);
?>
</td>
</tr>
</table>
</fieldset>
<p><input type="submit" value="Submit" /></p>
</form>
<?php
}
function showPage($username = '', $accessLvl = '', $errors = '')
{
showHeader($username, $accessLvl);
global $db;
if ($errors) {
//show errors at top of page
print '<h2 class = "error"> The following errors were encountered:</h2>';
print '<ul><li>';
print implode('</li><li>', $errors);
print '</li></ul>';
}
if (isset($_POST['first_name']) && isset($_POST['last_name']) && isset($_POST['username'])) {
print <<<ADDUSERPAGE
\t\t\t<h2 align="center">Add a New User</h2>
\t\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="add_user">
\t\t <table style="width: 100%" border="1">
\t\t\t<tbody>
\t\t\t <tr>
\t\t\t\t<td>First Name</td>
\t\t\t\t<td><input maxlength="50" name="first_name" type="text" value ="{$_POST['first_name']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t <tr>
\t\t\t\t<td>Last Name</td>
\t\t\t\t<td><input maxlength="50" name="last_name" type="text" value ="{$_POST['last_name']}"><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t <tr>
\t\t\t\t<td>User Name</td>
\t\t\t\t<td><input maxlength="50" name="username" type="text" value ="{$_POST['username']}"><br />
\t\t\t </tr>
\t\t\t <tr>
\t\t\t\t<td>Department</td>
\t\t\t\t<td>
\t\t\t\t <select name="department">
ADDUSERPAGE;
} else {
print <<<ADDUSERPAGE
\t\t\t<h2 align="center">Add a New User</h2>
\t\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="add_user">
\t\t <table style="width: 100%" border="1">
\t\t\t<tbody>
\t\t\t <tr>
\t\t\t\t<td>First Name</td>
\t\t\t\t<td><input maxlength="50" name="first_name" type="text" value =""><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t <tr>
\t\t\t\t<td>Last Name</td>
\t\t\t\t<td><input maxlength="50" name="last_name" type="text" value =""><br>
\t\t\t\t</td>
\t\t\t </tr>
\t\t\t <tr>
\t\t\t\t<td>User Name</td>
\t\t\t\t<td><input maxlength="50" name="username" type="text" value =""><br />
\t\t\t </tr>
\t\t\t <tr>
\t\t\t\t<td>Department</td>
\t\t\t\t<td>
\t\t\t\t <select name="department">
ADDUSERPAGE;
}
$query = 'SELECT dept_id, name FROM departments';
$result = @mysqli_query($db, $query);
/*
echo 'hello <br>';
echo $query;
echo '<br>';
var_dump($result);
echo '<br>';
*/
//die();
if (isset($_POST['department'])) {
while ($row = @mysqli_fetch_array($result)) {
print "<option value=\"{$row['dept_id']}\"";
if ($_POST['department'] == $row['dept_id']) {
print ' selected="selected" ';
}
print ">{$row['name']}</option>";
}
} else {
while ($row = @mysqli_fetch_array($result)) {
print "<option value=\"{$row['dept_id']}\"";
/*if ($_POST['department']==$row['dept_id']){
print ' selected="selected" ';
}*/
print ">{$row['name']}</option>";
}
}
print <<<ADDUSERPAGE
</select>
<br>
</td>
</tr>
<tr>
<td>Access Level</td>
<td>
<select name="access">
<option value="U">User</option>
<option value="A">Approver</option>
<option value="S">Superuser</option>
</select>
</td>
</tr>
<tr>
<td>Password</td>
<td><input maxlength="10" name="password" type="password"><br>
</td>
</tr>
<tr>
<td>Confirm Password</td>
<td><input maxlength="10" name="passwordConfirm" type="password"><br>
</td>
</tr>
</tbody>
</table>
<input type="hidden" name="_submit_check" value="1" />
\t <br>
<button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="submit" name="Submit">Add User</button></form>
ADDUSERPAGE;
print '<h4 align="center"><a href="admin.php">Return to User Administration Page</a></h4>';
showFooter();
}
function _showIframeSections()
{
global $schema;
if (@$schema['menuType'] != 'link') {
return;
}
// show messages
alert(@$schema['_linkMessage']);
// get page html
$iframeHeight = coalesce(@$schema['_iframeHeight'], 600);
ob_start();
showHeader();
?>
<div class="clear"></div>
<div class="content-box">
<form method="post" action="?" autocomplete="off">
<div class="content-box-header">
<h3><?php
echo htmlencode(@$schema['menuName']);
?>
</h3>
<div style="float:right;">
</div>
<div class="clear"></div>
</div> <!-- End .content-box-header -->
<iframe src='<?php
echo $schema['_url'];
?>
' style='height: <?php
echo $iframeHeight;
?>
px; width: 100%;' id="iframe-container"></iframe>
</form>
</div><!-- End .content-box -->
<?php
showFooter();
$html = ob_get_clean();
//
print $html;
exit;
}
<body>
<div id="outerHeader"> </div>
<div id="main">
<div id="title">
<?php showTitle(); ?>
</div>
<div id="banner">
<?php showBanner(); ?>
</div>
<div id="container">
<div id="content">
<div id="leftMargin">
<?php showLeftBar(); ?>
</div>
<?php showRightBar(); ?>
<div id="topToolbar" class="ajax">
<?php showTopToolbar(); ?>
</div>
<div id="bodyContent" class="ajax">
<?php showContent(); ?>
</div>
<div id="innerFooter">
<?php showFooter(); ?>
</div>
</div>
</div>
<div id="outerFooter"><?php showOuterFooter(); ?></div>
</body>
</html>
</head>
<body>
<?php
showHeader($lang);
?>
<div class="container" id="container_index">
<?php
if ($page == "main") {
main_page($data, $json_url);
} else {
if ($page == "video") {
video_page($data, $json_url);
} else {
if ($page == "main_server_error") {
main_page_error();
}
}
}
showFooter($lang);
?>
</div> <!-- /container_index -->
</body>
</html>
?>
<option value="<?php
echo $id;
?>
" <?php
echo $selected;
?>
><?php
echo $value;
?>
</option>
<?php
}
?>
</select>
</div>
<span class="text-danger"><strong>*</strong></span>
</div>
</div>
<div class="form-group text-center">
<br /><br />
<button type="submit" class="btn btn-info">Gravar <span class="glyphicon glyphicon-ok"></span></button>
<button type="reset" name="reset" class="btn btn-warning">Limpar <span class="glyphicon glyphicon-erase"></span></button>
</div>
</form>
</div>
<?php
require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . '../template/footer.php';
showFooter(['confirmDelete', 'ajaxFormUsers']);
function plugin_footer()
{
ob_start();
?>
</div><!-- End .content-box-content -->
</form>
</div><!-- End .content-box -->
<?php
showFooter();
$html = ob_get_clean();
return $html;
}
function displayPaginationReports($numResultENTIRERows, $tempOrigStartPosition, $URL_String_BACK, $URL_String_FORWARD)
{
/*
echo 'forward in pagination reports ';
echo $URL_String_FORWARD;
echo '<br>';
echo 'end forward';
*/
$newOffSet = 0;
//include 'dump_all_page_contents.php';
if ($_GET['page_number'] >= 1) {
$newOffSet = $_SESSION['RowsPerPage'] * $_GET['page_number'];
} else {
$newOffSet = 0;
}
print <<<EDITUSERPAGE
\t</tbody>
</table>
EDITUSERPAGE;
echo '<br><br><br>';
if ($tempOrigStartPosition > 0) {
print <<<EDITUSERPAGE
\t\t\t\t<center><b><i><a href="{$URL_String_BACK}"> << PREVIOUS PAGE </a>
EDITUSERPAGE;
}
echo ' ';
echo ' ';
echo ' ';
echo ' ';
echo ' ';
echo ' ';
echo ' ';
if ($numResultENTIRERows >= $newOffSet + $_SESSION['RowsPerPage']) {
print <<<EDITUSERPAGE
\t\t\t\t<b><i><a href="{$URL_String_FORWARD}">NEXT PAGE >> </a></center>
EDITUSERPAGE;
}
echo '<br><br><br><br>';
print <<<EDITUSERPAGE
\t<center><a href="reports.php"><button value="Back" name="Back">Back To Reports Page</button></a></center>
EDITUSERPAGE;
showFooter();
die;
}
function showEditPage($username = '', $accessLvl = '', $errors = '')
{
//page where user will actually edit user information
showHeader($username, $accessLvl);
global $db;
if ($errors) {
//show errors at top of page
print '<h2 class = "error"> The following errors were encountered:</h2>';
print '<ul><li>';
print implode('</li><li>', $errors);
print '</li></ul>';
}
$query = "SELECT user_id, first_name,last_name,access_lvl, D.name, username FROM users AS U INNER JOIN departments AS D ON U.dept_id = D.dept_id WHERE user_id = '{$_SESSION['userid']}'";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
print <<<EDITUSERPAGE
\t
\t\t<h2 align="center">Edit User</h2>
\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="add_user">
<table align="center" style="width: 50%" border="1">
<tbody>
<tr>
<td>First Name</td>
<td><input maxlength="50" name="first_name" type="text" value ="{$row['first_name']}" readonly><br>
</td>
</tr>
<tr>
<td>Last Name</td>
<td><input maxlength="50" name="last_name" type="text" value ="{$row['last_name']}" readonly><br>
</td>
</tr>
<tr>
<td>New Password</td>
<td><input maxlength="10" name="password" type="password"><br>
</td>
</tr>
<tr>
<td>Confirm Password</td>
<td><input maxlength="10" name="passwordConfirm" type="password"><br>
</td>
</tr>
</tbody>
</table>
<input type="hidden" name="_edit_submit" value="1" /><input type="hidden" name = "user_id" value="{$_SESSION['loginName']}" />
<br/>
\t <center><button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="update" name="Submit">Update User</button></center></form>
EDITUSERPAGE;
showFooter();
}
function showMeassage($message, $urlForward = '', $type = 'message', $success = 0)
{
showHeader();
if ($type == 'message') {
echo '<div class="status-tip status-tip-' . ($success ? 'success' : 'error') . '">' . $message . '</div>';
} elseif ($type == 'redirect') {
echo "{$message} ...";
echo "<br /><br /><br /><a href=\"{$urlForward}\">浏览器会自动跳转页面，无需人工干预。除非当您的浏览器长时间没有自动跳转时，请点击这里</a>";
echo "<script>setTimeout(\"redirect('{$urlForward}');\", 1250);</script>";
} elseif ($type == 'confirm') {
echo "{$message}";
echo "<br /><br /><br /><button class=\"btn btn-primary\" id=\"confirmbtn\" onclick=\"redirect('{$urlForward}')\">确定</button><button class=\"btn\" id=\"cancelbtn\" onclick=\"redirect('restore.php')\">取消</button>";
}
showFooter();
}
function showPage($username = '', $accessLvl = '', $errors = '')
{
showHeader($username, $accessLvl);
global $db;
include 'dropDownListValues.php';
/* commented out for debugging
if($errors){
//show errors at top of page
print '<h2 class = "error"> The following errors were encountered:</h2>';
print '<ul><li>';
print implode('</li><li>', $errors);
print '</li></ul>';
}
*/
$array_of_statesFull = array('Alabama', 'Alaska', 'Arizona', 'Arkansas', 'California', 'Colorado', 'Connecticut', 'Delaware', 'District of Columbia', 'Florida', 'Georgia', 'Hawaii', 'Idaho', 'Illinois', 'Indiana', 'Iowa', 'Kansas', 'Kentucky', 'Louisiana', 'Maine', 'Maryland', 'Massachusetts', 'Michigan', 'Minnesota', 'Mississippi', 'Missouri', 'Montana', 'Nebraska', 'Nevada', 'New Hampshire', 'New Jersey', 'New Mexico', 'New York', 'North Carolina', 'North Dakota', 'Ohio', 'Oklahoma', 'Oregon', 'Pennsylvania', 'Rhode Island', 'South Carolina', 'South Dakota', 'Tennessee', 'Texas', 'Utah', 'Virginia', 'Vermont', 'Washington', 'West Virginia', 'Wisconsin', 'Wyoming');
$array_of_statesShort = array("AK", "AL", "AZ", "AR", "CA", "CO", "CT", "DE", "DC", "FL", "GA", "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NE", "NV", "NH", "ND", "NJ", "NM", "NY", "NC", "OH", "OK", "OR", "PA", "RI", "SC", "SD", "TN", "TX", "UT", "VA", "VT", "WA", "WV", "WI", "WY");
/*
<tr>
<td>Type of Refund</td>
<td>Commercial<input maxlength="50" name="refund_type_commercial" id="refund_type_commercial" type="checkbox" value ="1" onClick="{removeFocusPersonal()}">
Personal<input maxlength="50" name="refund_type_personal" id="refund_type_personal" type="checkbox" value ="1" onClick="{removeFocusCommercial()}"></td>
</tr>
*/
//include 'connectToDB.php';
if (isset($_POST['amount'])) {
$query = "SELECT refund_id from refund ORDER BY refund_id DESC LIMIT 1";
$resultLargestRefundID = mysqli_query($db, $query);
while ($row = mysqli_fetch_array($resultLargestRefundID)) {
$nextRefundID = $row['refund_id'];
}
$nextRefundID += 1;
print <<<ADDREFUNDPAGE
\t\t<h2 align="center">Add a New Refund</h2>
\t\t<a href="index.php">Back to Refunds</a>
\t<br/><br/>
\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="add_refund" enctype="multipart/form-data">
\t\t<button class="add_field_button">Add More Fields</button>
<table style="width: 100%" border="1">
<tbody>
\t\t
\t\t<tr>
\t\t\t<td><b>Refund ID</b></td>
\t\t\t<td><b>{$nextRefundID}</b></td>
\t\t</tr>
\t\t
\t <tr>
<td>Type Of Refund</td>
<td>
\t\t\t<select name="refund_type">
ADDREFUNDPAGE;
print "<option value=\"\"";
print "></option>";
print "<option value='Commercial' selected>Commercial</option> ";
print "<option value='Personal'>Personal</option> ";
print <<<ADDREFUNDPAGE
\t\t </select>
\t\t</td>
\t </tr>\t\t
\t\t
<tr>
<td>Urgent</td>
<td><input maxlength="50" name="urgent" type="checkbox" value ="1"><br>
</td>
</tr>
<tr>
\t<td>Amount</td>
\t\t\t
\t<td>\$<input maxlength="50" name="amount" type="text" value ="{$_POST['amount']}"><br />
</tr>
<tr>
<td>Check Payabless To:</td>
<td><input name="payable" type="text" value="{$_POST['payable']}">
</td>
</tr>
<tr>
<td>Address Line 1</td>
<td><input name="addr_ln_1" type="text" value="{$_POST['addr_ln_1']}">
</td>
</tr>
<tr>
<td>Address Line 2</td>
<td><input name="addr_ln_2" type="text" value="{$_POST['addr_ln_2']}">
</td>
</tr>
<tr>
<td>City</td>
<td><input name="city" type="text" value="{$_POST['city']}">
</td>
<tr>
<td>State</td>
<td>
\t\t\t<select name="state">
ADDREFUNDPAGE;
print "<option value=\"\"";
print "></option>";
$loopstateCtr = 0;
foreach ($array_of_statesFull as $key => $value) {
if ($_POST['state'] == $array_of_statesShort[$loopstateCtr]) {
print "<option value=\"{$array_of_statesShort[$loopstateCtr]}\"";
print " selected >{$value}</option>";
} else {
print "<option value=\"{$array_of_statesShort[$loopstateCtr]}\"";
print " >{$value}</option>";
}
$loopstateCtr++;
}
print <<<ADDREFUNDPAGE
\t\t </select>
\t\t</td>
\t </tr>\t
\t
<tr>
<td>Zip</td>
<td><input maxlength="10" name="zip" type="text" value="{$_POST['zip']}">
</td>
</tr>
ADDREFUNDPAGE;
print <<<ADDREFUNDPAGE
<tr>
<td>Purpose</td>
<td><input name="purpose" type="text" value="{$_POST['purpose']}">
</td>
</tr>
<tr>
<td>Comments</td>
<td><textarea name="comments" cols="20" rows="4" value="{$_POST['comments']}" ></textarea>
</td>
</tr>
<tr>
\t<td>Encounter Note</td>
\t<td><input type="file" name="encounter_note" ></td>
</tr>
<tr>
\t<td>Transaction Detail Page</td>
\t<td><input type="file" name="transaction_detail_page"></td>
</tr>
<tr>
\t<td>Commercial Paperwork</td>
\t<td><input type="file" name="commercial_paperwork"></td>
</tr>
<tr>
\t<td>Attachment 4</td>
\t<td><input type="file" name="file4"></td>
</tr>
<tr>
\t<td>Attachment 5</td>
\t<td><input type="file" name="file5"></td>
</tr>
\t\t
\t\t \t<tr>
\t\t\t\t<td> Encounter Number: </td>
\t\t\t\t<td><input name="encounters[]" type="text" value=""></td>
\t\t\t</tr>
\t\t
</tbody>
</table>
<input type="hidden" name="_submit_check" value="1" />
\t <br/>
<button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="submit" name="Submit">Request Refund</button></form>
ADDREFUNDPAGE;
} else {
//include 'dump_all_page_contents.php';
$_POST = $_SESSION['SAVE_POST'];
$query = "SELECT refund_id from refund ORDER BY refund_id DESC LIMIT 1";
$resultLargestRefundID = mysqli_query($db, $query);
while ($row = mysqli_fetch_array($resultLargestRefundID)) {
$nextRefundID = $row['refund_id'];
}
$nextRefundID += 1;
print <<<ADDREFUNDPAGE
\t\t<h2 align="center">Add a New Refund</h2>
\t\t\t<a href="index.php">Back to Refunds</a>
\t<br/><br/>
\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="add_refund" enctype="multipart/form-data" >
<table style="width: 100%" border="1" class="input_fields_wrap">
<tbody>
\t\t
\t\t<tr>
\t\t\t<td><b>Refund ID</b></td>
\t\t\t<td><b>{$nextRefundID}</b></td>
\t\t</tr>
\t
\t\t<tr>
<td>Type Of Refund</td>
<td>
\t\t\t<select name="refund_type">
ADDREFUNDPAGE;
print "<option value=\"\"";
print "></option>";
print "<option value='Commercial' selected>Commercial</option> ";
print "<option value='Personal'>Personal</option> ";
print <<<ADDREFUNDPAGE
\t\t </select>
\t\t</td>
\t </tr>\t\t \t\t
<tr>
<td>Urgent</td>
<td><input maxlength="50" name="urgent" type="checkbox" value ="1"><br>
</td>
</tr>
<tr>
\t<td>Amount</td>
\t\t\t
\t<td><input maxlength="50" name="amount" type="text" value ="{$_POST['amount']}"><br />
</tr>
<tr>
<td>Check Payable To:</td>
<td><input name="payable" type="text" value="{$_POST['payable']}">
</td>
</tr>
<tr>
<td>Address Line 1</td>
<td><input name="addr_ln_1" type="text" value="{$_POST['addr_ln_1']}">
</td>
</tr>
<tr>
<td>Address Line 2</td>
<td><input name="addr_ln_2" type="text" value="{$_POST['addr_ln_2']}">
</td>
</tr>
<tr>
<td>City</td>
<td><input name="city" type="text" value="{$_POST['city']}">
</td>
\t\t </tr>\t
\t\t\t
<tr>
<td>State</td>
<td>
\t\t\t<select name="state">
ADDREFUNDPAGE;
print "<option value=\"\"";
print "></option>";
$loopstateCtr = 0;
foreach ($array_of_statesFull as $key => $value) {
print "<option value=\"{$array_of_statesShort[$loopstateCtr]}\"";
print ">{$value}</option>";
$loopstateCtr++;
}
print <<<ADDREFUNDPAGE
\t\t </select>
\t\t</td>
\t </tr>\t
\t
\t\t
<tr>
<td>Zip</td>
<td><input maxlength="10" name="zip" type="text" value="{$_POST['zip']}">
</td>
</tr>
ADDREFUNDPAGE;
print <<<ADDREFUNDPAGE
<tr>
<td>Purpose</td>
<td><input name="purpose" type="text" value="{$_POST['purpose']}">
</td>
</tr>
<tr>
<td>Comments</td>
<td><textarea name="comments" cols="20" rows="4" value="{$_POST['comments']}" ></textarea>
</td>
</tr>
<tr>
\t<td>Encounter Note</td>
\t<td><input type="file" name="encounter_note" ></td>
</tr>
<tr>
\t<td>Transaction Detail Page</td>
\t<td><input type="file" name="transaction_detail_page"></td>
</tr>
<tr>
\t<td>Commercial Paperwork</td>
\t<td><input type="file" name="commercial_paperwork"><font color=red>* Only Required if Commercial Refund</font></td>
</tr>
<tr>
\t<td>Attachment 4</td>
\t<td><input type="file" name="file4"></td>
</tr>
<tr>
\t<td>Attachment 5</td>
\t<td><input type="file" name="file5"></td>
</tr>
\t\t <tr>
\t\t\t<tr>
\t\t\t\t<td> Encounter Number: </td>
\t\t\t\t<td><input name="encounters[]" type="text" value=""></td>
\t\t\t</tr>
\t\t\t
\t\t\t
\t\t
\t </tr>
\t\t
</tbody>
</table><br>
\t <button class="add_field_button">Add Additional Encounter Numbers associated with this Refund</button><br><br>
<input type="hidden" name="_submit_check" value="1" />
\t <br/><br>
<center><button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="submit" name="Submit">Request Refund</button></center></form>
ADDREFUNDPAGE;
?>
<?php
}
showFooter();
}
echo "</td>";
$i++;
}
}
echo "</tr>";
}
?>
<tr>
<td colspan="7" align="right">
<input type="button" value="Toggle Print View" onClick="location.href='?print_view=<?php
echo $printView ? "false" : "true";
?>
'" />
<?php
if (Auth::schoolID() == 0) {
?>
<input type="submit" value="Add/Change Meet" />
<?php
}
?>
</td>
</tr>
</table>
<?php
if (Auth::schoolID() == 0 && !$printView) {
?>
</form>
<?php
}
showFooter(true);
function showEditPage($username = '', $accessLvl = '', $errors = '')
{
//page where user will actually edit user information
//echo 'hi';
showHeader($username, $accessLvl);
global $db;
?>
<html lang="en">
<head>
<meta charset="utf-8">
<title>jQuery UI Datepicker - Default functionality</title>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css">
<script>
$(function() {
$( "#datepickerSTART" ).datepicker();
});
$(function() {
$( "#datepickerEND" ).datepicker();
});
</script>
</head>
<body>
</body>
</html>
<?php
if ($errors) {
//show errors at top of page
print '<h2 class = "error"> The following errors were encountered:</h2>';
print '<ul><li>';
print implode('</li><li>', $errors);
print '</li></ul>';
}
$query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request, dt_required, payable, addr_ln_1, addr_ln_2, city, \n\tstate, zip, purpose, amount, status, comments \n\tFROM refund AS R INNER JOIN users AS U \n\tON R.created_by= U.user_id WHERE refund_id = '{$_GET['refund_id']}'";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
//echo $query;
//echo '<br>';
print <<<EDITUSERPAGE
<h2 align="center">Edit Refund INDEX PAGE</h2>
<a href="index.php">Back to Refunds</a>
\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="update_refund">
<table style="width: 100%" border="1">
<tbody>
<tr>
<td>Date Required</td>
\t\t\t<td><input type="text" name="dt_request" id="datepickerSTART" value ="{$row['dt_request']}"></td>
</tr>
<tr>
\t<td>Amount</td>
\t<td>\$<input maxlength="50" name="amount" type="text" value ="{$row['amount']}"><br />
</tr>
<tr>
<td>Check Payable To:</td>
<td><input name="payable" type="text" value="{$row['payable']}">
</td>
</tr>
<tr>
<td>Address Line 1</td>
<td><input name="addr_ln_1" type="text" value="{$row['addr_ln_1']}">
</td>
</tr>
<tr>
<td>Address Line 2</td>
<td><input name="addr_ln_2" type="text" value="{$row['addr_ln_2']}">
</td>
</tr>
<tr>
<td>City</td>
<td><input name="city" type="text" value="{$row['city']}">
</td>
<tr>
<td>State</td>
<td><input maxlength="2" name="state" type="text" value="{$row['state']}">
</td>
</tr>
<tr>
<td>Zip</td>
<td><input maxlength="10" name="zip" type="text" value="{$row['zip']}">
</td>
</tr>
<tr>
<td>Encounter Number</td>
<td><input name="enc_nbr" type="text" readonly value="{$row['NG_enc_id']}">
</td>
</tr>
\t\t <tr>
<td>Refund ID</td>
<td><input name="refund_id" type="text" value="{$row['refund_id']}">
</td>
</tr>
<tr>
<td>Purpose</td>
<td><input name="purpose" type="text" value="{$row['purpose']}">
</td>
</tr>
<tr>
<td>Comments</td>
<td><input name="comments" type="text" value="{$row['comments']}">
</td>
</tr>
</tbody>
</table>
<input type="hidden" name="_edit_submit" value="1" />
<input type="hidden" name="refund_id" value = "{$_GET['refund_id']}">
<button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="submit" name="Submit">Update Refund</button></form>
EDITUSERPAGE;
showFooter();
}
<tr>
<td class="col-md-1 text-right"><strong>Setor:</strong></td>
<td><?php
echo $sigla;
?>
(<?php
echo $setor;
?>
)</td>
</tr>
<tr>
<td class="col-md-1 text-right"><strong>Tipo:</strong></td>
<td><?php
echo $tipo;
?>
</td>
</tr>
<tr>
<td class="col-md-1 text-right"><strong>Ativo:</strong></td>
<td><?php
echo $ativo;
?>
</td>
</tr>
</tbody>
</table>
</div>
<?php
require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . '../template/footer.php';
showFooter(['confirmDelete']);
function showPage($username = '', $accessLvl = '', $errors = '')
{
showHeader($username, $accessLvl);
global $db;
include 'connectToDB.php';
if ($errors) {
//show errors at top of page
print '<h2 class = "error"> The following errors were encountered:</h2>';
print '<ul><li>';
print implode('</li><li>', $errors);
print '</li></ul>';
}
//if(isset($_POST['first_name']) && isset($_POST['last_name']) && isset($_POST['username'])){
print <<<ADDUSERPAGE
\t\t\t<h2 align="center">Add/Edit PAR1 Recipients</h2>
\t\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="add_acc_rec">
\t\t <table style="width: 100%" border="1">
\t\t\t<tbody>
\t\t\t \t\t
\t\t\t <tr>
<td>PAR1 Recipient 1 </td>
<td>
<select name="par1_recipient_1">
ADDUSERPAGE;
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$query_users_rec_1 = "SELECT recipient_1 FROM email_recipients WHERE step='par1' ";
$result_users_rec_1 = mysqli_query($db, $query_users_rec_1);
$rec_1 = mysqli_fetch_array($result_users_rec_1);
while ($row_users = mysqli_fetch_array($result_users)) {
$selected = $row_users['user_id'] === $rec_1['recipient_1'] ? ' selected="selected"' : '';
print "<option value=\"{$row_users['user_id']}\"";
print " {$selected} >{$row_users['first_name']} {$row_users['last_name']}</option>";
}
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
print <<<EDITUSERPAGE
</select>
<br>
</td>
</tr>
\t\t\t <tr>
<td>PAR1 Recipient 2</td>
<td>
<select name="par1_recipient_2">\t\t
\t\t\t
EDITUSERPAGE;
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$query_users_rec_2 = "SELECT recipient_2 FROM email_recipients WHERE step='par1' ";
$result_users_rec_2 = mysqli_query($db, $query_users_rec_2);
$rec_2 = mysqli_fetch_array($result_users_rec_2);
print "<option value=\"\"></option>";
while ($row_users = mysqli_fetch_array($result_users)) {
$selected = $row_users['user_id'] === $rec_2['recipient_2'] ? ' selected="selected"' : '';
print "<option value=\"{$row_users['user_id']}\"";
print " {$selected}>{$row_users['first_name']} {$row_users['last_name']}</option>";
}
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
print <<<EDITUSERPAGES
</select>
<br>
</td>
</tr>
\t\t
\t\t <td>PAR1 Recipient 3</td>
\t\t <td>
\t\t <select name="par1_recipient_3">\t\t
EDITUSERPAGES;
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
$query_users_rec_3 = "SELECT recipient_3 FROM email_recipients WHERE step='par1' ";
$result_users_rec_3 = mysqli_query($db, $query_users_rec_3);
$rec_3 = mysqli_fetch_array($result_users_rec_3);
print "<option value=\"\"></option>";
while ($row_users = mysqli_fetch_array($result_users)) {
$selected = $row_users['user_id'] === $rec_3['recipient_3'] ? ' selected="selected"' : '';
print "<option value=\"{$row_users['user_id']}\"";
print " {$selected}>{$row_users['first_name']} {$row_users['last_name']}</option>";
}
print <<<EDITUSERPAGES
</select>
<br>
</td>
</tr>\t\t
\t\t
</tbody>
</table>
<input type="hidden" name="_submit_check" value="1" />
\t <br>
<center><button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="submit" name="Submit">Submit Changes</button></center>
\t </form>
\t
EDITUSERPAGES;
//}
echo '<br><br>';
print '<h4 align="center"><a href="admin.php">Return to User Administration Page</a></h4>';
showFooter();
}
if ($action == "edit" && $id) {
$sql = "SELECT Name, Note FROM restaurants WHERE id='{$id}' LIMIT 1;";
$db->query($sql);
if ($row = $db->fetchrow()) {
list($name, $note) = $row;
$button = "Save";
$action = "save";
$task = "Edit";
$idInput = '<input type="hidden" name="id" value="' . $id . '"/>';
}
}
if (!$name || !$task || !$button) {
$button = "Create";
$action = "add";
$task = "Add New";
$idInput = "";
}
$db->query("SELECT ID,Name,Note from restaurants ORDER BY Name DESC");
$body .= "<table><thead><tr><td>Name</td><td>Note</td><td>Delete</td></tr></thead><tbody>";
while (list($id, $rName, $rNote) = $db->fetchrow()) {
$body .= "<tr><td><a href=\"?action=edit&id={$id}\">{$rName}</a></td><td>{$rNote}</td><td><a href=\"?action=delete&id={$id}\" onclick=\"return confirm('Deleting this restaurant will destroy all history and preference data stored with it. Are you sure?!')\"><img src=\"delete.png\" alt=\"delete\"/></a></td></tr>";
}
$body .= "</tbody></table>";
$body .= '<br/><form method="get"><input type="hidden" name="action" value="' . $action . '"/>' . $idInput . '
<h2>' . $task . ' Restaurant:</h2> <input type="text" placeholder="Restaurant Name" name="name" value="' . $name . '"/><br/>Notes:<br/>
<textarea name="note" style="width:400px;height:100px;">' . htmlentities($note) . '</textarea><br/><button type="submit">' . $button . '</button></form>';
// Render to Screen
print showHeader("Restaurants");
print $body;
print showFooter();
function reportRejected()
{
//include 'dump_all_page_contents.php';
showHeaderALL($_SESSION['username'], $_SESSION['access']);
include 'connectToDB.php';
include 'pagination_functionality.php';
if ($accessLvl == 'U') {
//is access is only at the user level, then must match the refunds pulled to display only the current users created refunds
if (!isset($_SESSION['order'])) {
$query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to,rejected \n\t\t\tFROM refund AS R \n\t\t\tINNER JOIN \n\t\t\tusers AS U \n\t\t\tON R.created_by = U.user_id \n\t\t\tWHERE status ='REJECTED'\n\t\t\tORDER BY dt_request,U.last_name,status LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage'];
} else {
$query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to,rejected \n\t\t\tFROM refund AS R \n\t\t\tINNER JOIN \n\t\t\tusers AS U \n\t\t\tON R.created_by = U.user_id \n\t\t\tWHERE status ='REJECTED'\n\t\t\tORDER BY " . $_SESSION['order'] . " LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage'];
}
} else {
if (!isset($_SESSION['order'])) {
$query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to,\n\t\t\taccounting_approval,billing_initial_approval,billing_final_approval,rejected \n\t\t\tFROM refund AS R \n\t\t\tINNER JOIN \n\t\t\tusers AS U \n\t\t\tON R.created_by = U.user_id \n\t\t\tWHERE status ='REJECTED'\n\t\t\tORDER BY dt_request,U.last_name,status LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage'];
} else {
$query = "SELECT NG_enc_id, U.first_name, U.last_name, dt_request,amount, status,refund_id, payable,assigned_to,\n\t\t\taccounting_approval,billing_initial_approval,billing_final_approval,rejected \t\t\t\n\t\t\tFROM refund AS R \n\t\t\tINNER JOIN \n\t\t\tusers AS U \n\t\t\tON R.created_by = U.user_id \n\t\t\tWHERE status ='REJECTED'\n\t\t\tORDER BY " . $_SESSION['order'] . " LIMIT " . $_SESSION['initialOffset'] . "," . $_SESSION['RowsPerPage'];
}
}
//ECHO 'THE QUERY NOW IS <BR>';
//ECHO $query;
$result = mysqli_query($db, $query);
$arrayRefundUsers = array();
$queryUserIDs = "SELECT user_id, first_name, last_name FROM users";
$resultUserIDs = mysqli_query($db, $queryUserIDs);
$ctr = 0;
while ($row = mysqli_fetch_array($resultUserIDs)) {
$arrayRefundUsers[$row['user_id']] = $row['first_name'] . ' ' . $row['last_name'];
}
///////HEADINGS FROM THE REFUNDS PAGE//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
print '<br><br>';
print '<center>Displaying: <b>REJECTED Reports</b></center>';
print '<br /><br /><div align = "center">';
print '<table border="1" cellpadding = "3">
<tr>
<td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?encounter_num=y>Encounter Number</a></b></center></td>
<td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?refund_id=y>Refund IDs</a></b></center></td>
<td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?encounter_date=y>Date Requested</a></b></center></td>
<td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?encounter_date=y>Urgent</a></b></center></td>
<td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?requested_by=y>Requested By</a></b></center></td>
<td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?payable_order=y>Payable To</a></b></center></td>
<td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?amount_order=y>Amount</a></b></center></td>
<td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?status_order=y>Status</a></b></center></td>
<td><center><b><a href=' . $_SERVER['PHP_SELF'] . '?status_order=y>Assigned To</a></b></center></td>';
///////END HEADINGS FROM THE REFUNDS PAGE////////////////////?////////////////////////////////////////////////////////////////////////////////////////////////////////
/*
<td><b><center>Actions</center></b></td>
*/
$current_date = date("Y-m-d H:i:s");
//$row = mysqli_fetch_array($result);
while ($row = mysqli_fetch_array($result)) {
$today_dt = $entered_dt = $interval = $refund_requested_by = $date_requested = $refund_assigned_to = $interval = "";
calculateInterval($row, $refund_requested_by, $date_requested, $today_dt, $entered_dt, $interval, $refund_assigned_to);
//$refund_assigned_to=$row['assigned_to'];
$refund_assigned_to = "";
$queryUserIDs = "SELECT first_name, last_name FROM users WHERE user_id= '{$row['assigned_to']}'";
$resultUserIDs = mysqli_query($db, $queryUserIDs);
while ($rowUserIds = mysqli_fetch_array($resultUserIDs)) {
//build up the assigned to username
$refund_assigned_to = $rowUserIds['first_name'] . ' ' . $rowUserIds['last_name'];
}
if ($interval->days > 30 && $row['status'] != "COMPLETED") {
print '<tr bgcolor=#FF0000>';
} elseif ($interval->days >= 15 && $interval->days < 30 && $row['status'] != "COMPLETED") {
print '<tr bgcolor=yellow>';
} elseif ($interval->days <= 1 && $row['status'] != "COMPLETED") {
print '<tr bgcolor=#009900>';
} else {
print '<tr>';
}
//print '<tr>
print '<td><a href="' . $_SERVER['PHP_SELF'] . '?refund_id=' . $row['refund_id'] . '&action=edit">' . $row['NG_enc_id'] . '</a></td>
<td><a href="' . $_SERVER['PHP_SELF'] . '?refund_id=' . $row['refund_id'] . '&action=edit">' . $row['refund_id'] . '</a></td>
<td>' . $row['dt_request'] . '</td>
<td>' . ($row['urgent'] ? 'Yes' : 'No') . '</td>
<td>' . $row['first_name'] . ' ' . $row['last_name'] . '</td>
<td>' . $row['payable'] . '</td>';
print '<td>$ ' . $row['amount'] . '</td>';
print '<td>REJECTED</td>';
print '<td>' . $refund_assigned_to . '</td>';
print '</td></tr>';
}
print '</table></div>';
print <<<EDITUSERPAGE
\t\t<br><center><a href="reports.php"><button value="Back" name="Back">Back To Reports Page</button></a></center>
EDITUSERPAGE;
//print '<h3 align="center"><a href="addrefund.php">Create a New Refund Request</a></h3>';
showFooter();
}
<?php
includeCss();
includeJs();
?>
<title>
List Postoffice
</title>
</head>
<body>
<?php
showHeader();
showLeftColLayout();
showLeftCol($authorise);
showMdlColLayout();
showMdlCol($authorise, $filterValue);
showFooter();
?>
</body>
</html>
<?php
function showLeftCol($authorise)
{
showLeftMenuBar($authorise);
}
function showMdlCol($authorise, $filterValue)
{
$intCount = "";
if ($authorise == "GMO" || $authorise == "DAO" || $authorise == "ADMIN") {
echo '<table>
<tr>
function showPage($username = '', $accessLvl = '', $errors = '')
{
showHeader($username, $accessLvl);
global $db;
include 'connectToDB.php';
if ($errors) {
//show errors at top of page
print '<h2 class = "error"> The following errors were encountered:</h2>';
print '<ul><li>';
print implode('</li><li>', $errors);
print '</li></ul>';
}
//if(isset($_POST['first_name']) && isset($_POST['last_name']) && isset($_POST['username'])){
/* Send initial Warning Emails to Accounting After How Many Days?
Send Second Warning Email to Accounting After Delinquent for How Many Days?
*/
print <<<ADDUSERPAGE
\t\t\t<h2 align="center"><br><br>Configure Email Send Dates and Times</h2>
\t\t\t<form method="POST" action="{$_SERVER['PHP_SELF']}" name="cfg_send_date_time">
\t\t <table style="width: 100%" border="0">
\t\t\t<tbody align="center">
\t\t\t<tr>
\t\t\t
\t\t\t<td>Send Initial Billing Warning Emails after How many Days?</td>
\t\t\t
\t\t\t<td>
\t\t\t
\t\t\t
<select name="initialBillingWarning_Email">
ADDUSERPAGE;
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
$days_ctr = 1;
print "<option value=\"\"";
print "</option>";
$selected = "";
$selected = $row_users['user_id'] === $rec_1['recipient_1'] ? ' selected="selected"' : '';
while ($days_ctr <= 365) {
print "<option value=\"{$days_ctr}\"";
print ">{$days_ctr}</option>";
$days_ctr++;
}
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
print <<<ADDUSERPAGE
\t
\t</select>
</td>
\t\t\t</tr>
\t\t\t\t\t\t\t<br><br>
\t\t\t<tr>
\t\t\t<td>Send Final Billing Warning Email after How many Days?</td>
\t\t\t
\t\t\t<td>
\t\t\t
\t\t\t
<select name="finalBillingWarning_Email">
ADDUSERPAGE;
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
$days_ctr = 1;
print "<option value=\"\"";
print "</option>";
$selected = "";
$selected = $row_users['user_id'] === $rec_1['recipient_1'] ? ' selected="selected"' : '';
while ($days_ctr <= 365) {
print "<option value=\"{$days_ctr}\"";
print ">{$days_ctr}</option>";
$days_ctr++;
}
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
print <<<ADDUSERPAGES
\t\t\t\t</select>
\t\t\t\t</td>
\t\t\t\t</tr>
\t\t\t\t
\t\t\t\t\t\t\t\t<br><br>
\t\t\t\t<tr>
\t\t\t\t<td>Send Accounting Initial Warning Email after how many Days? </td>
\t\t\t\t
ADDUSERPAGES;
print <<<ADDUSERPAGE
\t\t\t<td>
\t\t\t
\t\t\t
<select name="initialAccountingWarning_Email">
ADDUSERPAGE;
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
$days_ctr = 1;
print "<option value=\"\"";
print "</option>";
$selected = "";
$selected = $row_users['user_id'] === $rec_1['recipient_1'] ? ' selected="selected"' : '';
while ($days_ctr <= 365) {
print "<option value=\"{$days_ctr}\"";
print ">{$days_ctr}</option>";
$days_ctr++;
}
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
print <<<ADDUSERPAGED
\t\t\t\t</tr>
\t\t\t\t<br><br>
\t\t\t\t<tr>
\t\t\t\t<td>Send Accounting Final Warning Email after how many Days? </td>
\t\t\t\t<td>
\t\t\t <select name="finalAccountingWarning_Email">
ADDUSERPAGED;
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
$days_ctr = 1;
print "<option value=\"\"";
print "</option>";
$selected = "";
$selected = $row_users['user_id'] === $rec_1['recipient_1'] ? ' selected="selected"' : '';
while ($days_ctr <= 365) {
print "<option value=\"{$days_ctr}\"";
print ">{$days_ctr}</option>";
$days_ctr++;
}
$query_users = 'SELECT user_id, first_name, last_name FROM users';
$result_users = mysqli_query($db, $query_users);
$selected = 1;
print <<<ADDUSERPAGES
\t\t\t\t</select>
\t\t\t\t</tr>
\t\t\t\t</td>
ADDUSERPAGES;
print <<<EDITUSERPAGED
\t
\t
\t\t<tr>
\t\t<td>Send Emails at each step of the Process if Status is Urgent? </td>
\t\t<td>\t
EDITUSERPAGED;
print "<option value=''></option>";
print <<<EDITUSERPAGED
\t
\t
\t\t<select name="email_if_urgent">
EDITUSERPAGED;
print "<option value=yes>Yes</option>";
print "<option value=no>No</option>";
print <<<EDITUSERPAGED
\t\t</select>
\t\t</td>
\t\t</tr>
</tbody>
</table>
<input type="hidden" name="_submit_dates_set_accounting_check" value="1" />
\t <br><br><br>
<center><button formmethod="post" formaction="{$_SERVER['PHP_SELF']}" value="submit" name="Submit">Submit Changes</button></center></form>
\t
EDITUSERPAGED;
//}
print '<br><h4 align="center"><a href="admin.php">Return to User Administration Page</a></h4>';
showFooter();
}
