function testdbRoomLogsModule() { // Creates some room logs to add to the database $today = date('y-m-d'); $roomLog1 = new RoomLog($today); $roomLog2 = new RoomLog("11-02-07"); // Alter the status and log notes of a room $roomLog2->set_log_notes("Room Log 2"); $roomLog2->set_status("archived"); // test the insert function $this->assertTrue(insert_dbRoomLog($roomLog1)); $this->assertTrue(insert_dbRoomLog($roomLog2)); // test the retrieve function $this->assertEqual(retrieve_dbRoomLog($roomLog1->get_id())->get_status(), "unpublished"); $this->assertEqual(retrieve_dbRoomLog($roomLog2->get_id())->get_status(), "archived"); // test the update function $roomLog1->set_log_notes("Room Log 1 notes"); $this->assertTrue(update_dbRoomLog($roomLog1)); $this->assertEqual(retrieve_dbRoomLog($roomLog1->get_id())->get_log_notes(), "Room Log 1 notes"); // test the delete function $this->assertTrue(delete_dbRoomLog($roomLog1->get_id())); $this->assertFalse(retrieve_dbRoomLog($roomLog1->get_id())); $this->assertTrue(delete_dbRoomLog($roomLog2->get_id())); echo "testdbRoomLogs complete"; }
// change the $date variable to an actual date $date = $roomLogID; } else { if (strtotime($date) < strtotime(date("y-m-d"))) { // Search for the room log in the database $roomLog = retrieve_dbRoomLog($date); } else { // future date, create a new room log $roomLogID = $date; $roomLog = new RoomLog($roomLogID); } } // Check if the save button was hit if ($_POST['submit'] == "Save Roomlog") { // Try to update the roomlog if (update_dbRoomLog($roomLog)) { echo "<h3 style=\"text-align:center\">Roomlog updated successfully</h3>"; } else { if (insert_dbRoomLog($roomLog)) { echo "<h3 style=\"text-align:center\">Roomlog saved successfully</h3>"; } } } // Check if today's room log has been saved before: if not, save it. if (!retrieve_dbRoomLog($roomLogID) && $roomLogID == date("y-m-d")) { if (insert_dbRoomLog($roomLog)) { echo "<h3 style=\"text-align:center\">Today's room log has been saved.</h3>"; } else { echo "<h3 style=\"text-align:center;color:red\">Today's room log has not been saved.</h3>"; } }