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'"); }