public function testCreateReservationFromWeekdaytoWeekday(){
$this->setSessionUserAdmin();
$startDate = '2011-11-14'; # A Monday
$length = 1;
$endDate = DBTestUtil::incrementDateBy($startDate, $length);
$equipId = 1;
$userComment = "test user comment";
$adminComment = "test admin comment";
$modStatus = RES_STATUS_PENDING;
createReservation(getSessionVariable('user_id'), $equipId, $startDate, $length, $userComment, $adminComment, $modStatus);
$actualReservation = mysql_fetch_assoc(doQuery("select * from ".getConfigVar('db_prefix')."_reservations ORDER BY res_id DESC LIMIT 1"));
$this->assertEquals(getSessionVariable('user_id'), $actualReservation['user_id'], "User IDs not equal");
$this->assertEquals($equipId, $actualReservation['equip_id'], "Equip IDs not equal");
$this->assertEquals($startDate, $actualReservation['start_date'], "Start dates not equal");
$this->assertEquals($length, $actualReservation['length'], "Lengths not equal");
$this->assertEquals($endDate, $actualReservation['end_date'], "End dates not equal");
$this->assertEquals($userComment, $actualReservation['user_comment'], "User comments not equal");
$this->assertEquals($adminComment, $actualReservation['admin_comment'], "Admin comments not equal");
$this->assertEquals($modStatus, $actualReservation['mod_status'], "Statuses not equal");
}
private static function addMessages(){
doQuery("INSERT INTO ".getConfigVar('db_prefix')."_messages SET
user_id = '1', body = 'This is a very old message.',
start_date = '".DBTestUtil::decrementDateBy(DBTestUtil::getTestInitDate(), 20)."', end_date = '".DBTestUtil::decrementDateBy(DBTestUtil::getTestInitDate(),15)."',
priority = '1'");
doQuery("INSERT INTO ".getConfigVar('db_prefix')."_messages SET
user_id = '1', body = 'This is a low priority message.',
start_date = '".DBTestUtil::decrementDateBy(DBTestUtil::getTestInitDate(), 5)."', end_date = '".DBTestUtil::incrementDateBy(DBTestUtil::getTestInitDate(),5)."',
priority = '1'");
doQuery("INSERT INTO ".getConfigVar('db_prefix')."_messages SET
user_id = '1', body = 'This is a high priority message.',
start_date = '".DBTestUtil::decrementDateBy(DBTestUtil::getTestInitDate(), 4)."', end_date = '".DBTestUtil::incrementDateBy(DBTestUtil::getTestInitDate(),6)."',
priority = '2'");
}
