public static function setUpBeforeClass(){
require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . '/config.php';
require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . '../../src/functions.php';
DBTestUtil::init(getCurrentMySQLDate(), getCurrentMySQLDateTime());
DBTestUtil::setup();
session_start();
}
if ($equipment['max_length'] < $length) {
$message = "<font color=\"#FF0000\"><b>Error: Cannot reserve this equipment for that long.</b></font><br><br>";
} else {
if (isDateRangeBlackedOut($startdate, $enddate)) {
$message = "<font color=\"#FF0000\"><b>Error: Date Range Blacked-Out.</b></font><br><br>";
} else {
if ($equipment['checkoutfrom'] != -1) {
$message = "<font color=\"#FF0000\"><b>Error: You must check this out from it's assigned user.</b></font><br><br>";
} else {
createReservation($userid, $equipid, $startdate, $length, $usercomment, "", 0);
$message = "<font color=\"#005500\"><b>Successfully created new reservation!</b></font><br><br>";
}
}
}
}
}
}
$equipment = mysql_fetch_assoc(getEquipmentByID($equipid));
$length = "";
for ($i = 1; $i <= $equipment["max_length"]; $i++) {
$length = $length . "<option value=\"" . $i . "\">" . $i . "</option>";
}
echo "\r\n\t\t<center><h3>Make Reservation</h3>" . $message . "</center>\r\n\t\t\r\n\t\t<script type=\"text/javascript\">\r\n\t\t\tfunction checkDate(){\r\n\r\n\t\t\t\tif(document.reservation.startdate.value == \"" . getCurrentMySQLDate() . "\"){\r\n\r\n\t\t\t\t\treturn confirm(\"Reservations placed on the same day as they are created cannot be guaranteed to be ready for their start date. By continuing you are acknowledging that. Would you like to continue?\");\r\n\r\n\t\t\t\t}else{\r\n\t\t\t\t\treturn true;\r\n\t\t\t\t}\r\n\r\n\t\t\t}\r\n\t\t</script>\r\n\r\n\t\t<form name=\"reservation\" action=\"./index.php?pageid=finishres\" method=\"POST\" onsubmit=\"return checkDate();\">\r\n\t\t\r\n\t\t<table class=\"reservation\">\r\n\t\t\r\n\t\t\t<tr>\r\n\t\t\t\r\n\t\t\t\t<td colspan=4 class=\"header\">Reserve the " . $equipment["name"] . "<input type=\"hidden\" name=\"equip_id\" value=\"" . $equipid . "\"></td>\r\n\t\t\t\r\n\t\t\t</tr>\r\n\t\t\r\n\t\t\t<tr>\r\n\t\t\t\r\n\t\t\t\t<td class=\"centeredcellbold\">Date (YYYY-MM-DD)</td>\r\n\t\t\t\t<td class=\"centeredcell\"><script language=\"JavaScript\" id=\"jscal1x\">\r\n\tvar cal1x = new CalendarPopup(\"testdiv1\");\r\n\t</script><input type=\"text\" name=\"startdate\" id=\"startdate\" onClick=\"cal1x.select(document.forms[0].startdate,'anchor1x','yyyy-MM-dd'); return false;\"><a style=\"visibility:hidden;\" name=\"anchor1x\" id=\"anchor1x\">a</a></td>\r\n\t\t\t\t<td class=\"centeredcellbold\">Length</td>\r\n\t\t\t\t<td class=\"centeredcell\"><select name=\"length\">" . $length . "</select></td>\r\n\t\t\r\n\t\t\t</tr>\r\n\t\t\r\n\t\t\t<!--<tr>\r\n\t\t\t\t\r\n\t\t\t\t<td colspan=4 class=\"centeredcellbold\">Pickup Time: \r\n\t\t\t\t\t<select name=\"pickup\">\r\n\t\t\t\t\t\t<option value=\"10am-12pm (Monday/Friday)\">10am-12pm (Monday/Friday)</option>\r\n\t\t\t\t\t\t<option value=\"9am-12pm (Tuesday)\">9am-12pm (Tuesday)</option>\r\n\t\t\t\t\t\t<option value-\"9-10 (Wednesday/Thursday)\">9-10 (Wednesday/Thursday)</option>\r\n\t\t\t\t\t\t<option value=\"2pm-4pm (Wednesday)\">2pm-4pm (Wednesday)</option>\r\n\t\t\t\t\t\t<option value=\"12pm-2pm (Thursday)\">12pm-2pm (Thursday)</option>\r\n\t\t\t\t\t</select>\r\n\t\t\t\t</td>\r\n\t\t\t\t\t\r\n\t\t\t</tr>-->\r\n\r\n\t\t\t<tr>\r\n\t\t\t\r\n\t\t\t\t<td colspan=1 class=\"centeredcellbold\">User Comment</th>\r\n\t\t\t\t<td class=\"centeredcell\" colspan=3><textarea rows=5 cols=45 name=\"usercomment\"></textarea></td>\r\n\t\t\t\r\n\t\t\t</tr>\r\n\t\t\t\t\r\n\t\t\t\t<tr>\r\n\t\t\t\t\r\n\t\t\t\t\t<td colspan=4 class=\"centeredcell\"><input type=\"submit\" value=\"Reserve\"></td>\r\n\t\t\r\n\t\t\t\t</tr>\r\n\t\t\t\t\r\n\t\t\t</table>\r\n\t\t\t</form></div><DIV ID=\"testdiv1\" STYLE=\"position:absolute;visibility:hidden;background-color:white;\"></DIV>\r\n\t";
} else {
echo "<center><h3><font color=\"#FF0000\">Error: You have recieved 3 or more warnings.</font></h3>To reserve equipment please contact an admin: <br><br>";
$admins = getAdmins();
while ($row = mysql_fetch_assoc($admins)) {
echo $row['name'] . " -- " . $row['email'] . "<br>";
}
echo "</center>";
}
public function testMakeReservationPage(){
$this->setSessionUserAdmin();
$_GET['equipid'] = 1;
$_GET['pageid'] = "reservation";
require dirname(__FILE__) . DIRECTORY_SEPARATOR . '../../src/reservation.php';
$expectedPage = "<center><h3>Make Reservation</h3></center>
<script type=\"text/javascript\">
function checkDate(){
if(document.reservation.startdate.value == \"".getCurrentMySQLDate()."\"){
return confirm(\"Reservations placed on the same day as they are created cannot be guaranteed to be ready for their start date. By continuing you are acknowledging that. Would you like to continue?\");
}else{
return true;
}
}
</script>
<form name=\"reservation\" action=\"./index.php?pageid=finishres\" method=\"POST\" onsubmit=\"return checkDate();\">
<table class=\"reservation\">
<tr>
<td colspan=4 class=\"header\">Reserve the All Users1<input type=\"hidden\" name=\"equip_id\" value=\"1\"></td>
</tr>
<tr>
<td class=\"centeredcellbold\">Date (YYYY-MM-DD)</td>
<td class=\"centeredcell\"><script language=\"JavaScript\" id=\"jscal1x\">
var cal1x = new CalendarPopup(\"testdiv1\");
</script><input type=\"text\" name=\"startdate\" id=\"startdate\" onClick=\"cal1x.select(document.forms[0].startdate,'anchor1x','yyyy-MM-dd'); return false;\"><a style=\"visibility:hidden;\" name=\"anchor1x\" id=\"anchor1x\">a</a></td>
<td class=\"centeredcellbold\">Length</td>
<td class=\"centeredcell\">
<select name=\"length\">
<option value=\"1\">1</option>
<option value=\"2\">2</option>
<option value=\"3\">3</option>
<option value=\"4\">4</option>
<option value=\"5\">5</option>
</select>
</td>
</tr>
<tr>
<td colspan=1 class=\"centeredcellbold\">User Comment</th>
<td class=\"centeredcell\" colspan=3><textarea rows=5 cols=45 name=\"usercomment\"></textarea></td>
</tr>
<tr>
<td colspan=4 class=\"centeredcell\"><input type=\"submit\" value=\"Reserve\"></td>
</tr>
</table>
</form></div><DIV ID=\"testdiv1\" STYLE=\"position:absolute;visibility:hidden;background-color:white;\"></DIV>";
$this->assertPageEquals($expectedPage, $pageData);
}
function checkInReservation($res_id)
{
$res_id = makeStringSafe($res_id);
$mysqldate = getCurrentMySQLDate();
doQuery("UPDATE " . getDBPrefix() . "_reservations SET mod_status = '" . RES_STATUS_CHECKED_IN . "', checked_in_by = '" . getSessionVariable('user_id') . "' ,check_in_date = '" . $mysqldate . "' WHERE res_id = " . $res_id . "");
logAdminCheckInReservation(getSessionVariable('user_id'), $res_id);
}
$length = "";
for($i = 1; $i <= $equipment["max_length"]; $i++){
$length = $length . "<option value=\"".($i)."\">".($i)."</option>";
}
$pageData = $pageData . "
<center><h3>Make Reservation</h3>".$message."</center>
<script type=\"text/javascript\">
function checkDate(){
if(document.reservation.startdate.value == \"".getCurrentMySQLDate()."\"){
return confirm(\"Reservations placed on the same day as they are created cannot be guaranteed to be ready for their start date. By continuing you are acknowledging that. Would you like to continue?\");
}else{
return true;
}
}
</script>
<form name=\"reservation\" action=\"./index.php?pageid=finishres\" method=\"POST\" onsubmit=\"return checkDate();\">
<table class=\"reservation\">
<tr>
*/
$browsetable = "";
$start = "";
$end = "";
if(isset($_GET['start']) && isset($_GET['end'])){
$start = $_GET['start'];
$end = $_GET['end'];
}else{
$mysqldate = getCurrentMySQLDate();
$start_Date = new DateTime(''.$mysqldate.' 00:00:00');
$interval = new DateInterval("P7D");
$start_Date->add($interval);
$enddate = $start_Date->format("Y-m-d");
$start = $mysqldate;
$end = $enddate;
}
$browsetable = "P: Pending | C: Confirmed | D: Denied | CO: Checked-Out | CI: Checked-In<br><br>
<table class=\"browse\">
<tr>
<td class=\"header\">User</td>
<td class=\"header\">Equipment</td>
Known Bugs/Fixes:
None
*/
function getAllMessages()
{
$result = doQuery("SELECT * FROM " . getDBPrefix() . "_messages");
foreach($equipArray[$key] as $row){
$status = "-";
/*
The current piece of equipment is NOT at Calhoun
*/
if(isEquipmentOut($row['equip_id'], getCurrentMySQLDate())){
$status = "Out";
}
/*
The current piece of equipment will be out of Calhoun in a few days
-For exact length see isEquipmentReserved() in functions.php
*/
else if(isEquipmentReserved($row['equip_id'], getCurrentMySQLDate())){
$status = "Reserved";
}
else{
$status = "Available";
}
/*
Check logged in user's user level against the equipments min user level
*/
if(getSessionVariable('user_level') >= $row['min_user_level']){
if($row['checkoutfrom'] == -1){
$ourequipment = $ourequipment . "<tr><td class=\"centeredcell\">".$row['name']."</td><td class=\"centeredcell\"><a href=\"./index.php?pageid=moreinfo&equipid=".$row['equip_id']."\">More Info</a></td><td class=\"centeredcell\">".$status."</td><td class=\"centeredcell\"><a href=\"./index.php?pageid=reservation&equipid=".$row['equip_id']."\">Reserve</a></td></tr>";
<?php
