'Transferred' AND InventoryItems.status<>'Surveyed' AND InventoryItems.status<>'Deleted' GROUP BY InventoryLocations.item_id ORDER BY InventoryTypes.type ASC"; $safe_sql = prepareSQL($items_this_room_sql, array($room_id)); $items_this_room = mysql_query($safe_sql) or dbError(mysql_error(), $safe_sql); $items_this_room_num_rows = mysql_num_rows($items_this_room); if($items_this_room_num_rows > 0) $had_inventory_items = TRUE; // Get Maintenance history $maintenance_sql = "SELECT * FROM csis.Maintenance WHERE room_id={0} ORDER BY time_maintained DESC"; $safe_sql = prepareSQL($maintenance_sql, array($room_id)) . " LIMIT " . $maintenance_to_display; $maintenance_result = mysql_query($safe_sql) or dbError(mysql_error(), $safe_sql); $maintenance_num_rows = mysql_num_rows($maintenance_result); if($maintenance_num_rows > 0) $has_maintenance_history = TRUE; // Get Support Ticket history $support_ticket_sql = "SELECT * FROM csis.SupportTickets WHERE room_id={0} ORDER BY time_added DESC"; $safe_sql = prepareSQL($support_ticket_sql, array($room_id)) . " LIMIT " . $tickets_to_display; $support_tickets_result = mysql_query($safe_sql) or dbError(mysql_error(), $safe_sql); $support_tickets_num_rows = mysql_num_rows($support_tickets_result); if($support_tickets_num_rows > 0) $has_support_ticket_history = TRUE; } ?> Classroom Support Internal System (CSIS) - Rooms - <?php echo $building_prefix . " " . $room_num; ?>

Classroom Support Internal System » Rooms »

Rooms

\n"; printErrorsXHTML(); echo "\n

"; } ?>

Zone List | Build Sheets | Add Room | Add Building | Edit Building ()

Go to Building Selector, CS Classrooms, All Rooms

">
"> - View Room Schedule - Edit Room
Type:
Capacity:
Tech Podium:
Wireless Network:
TurningPoint Channel #:
Ladder Height:
Xantech Model:
Podium Upgrade:
Status:
Last Edited: -
()
Notes:
 

">
Inventory Items - Add Inventory Item
Equipment Type Brand Name Model Number Decal Number  
"> ">Move
No Inventory Items Found

"> >
Maintenance History - Add Maintenance Record
Time Added Added By Desk Count Lamp Hours Proj. Maint. Condition
View Entire Maintenance Record History
No Maintenance History Found

">
Support Ticket History - Add Support Ticket
Time Added Description Status
"> 50) $description .= "..."; echo $description; ?>
View Entire Support Ticket History
No Support Ticket History Found