#!/usr/bin/python

#/*
# * AV Admin - Helps to manage an AV department
# *
# * Copyright (C) 2003, 2004 Josef "Jeff" Sipek
# *
# * This program is free software; you can redistribute it and/or modify
# * it under the terms of the GNU General Public License as published by
# * the Free Software Foundation; either version 2 of the License, or
# * (at your option) any later version.
# *
# * This program is distributed in the hope that it will be useful,
# * but WITHOUT ANY WARRANTY; without even the implied warranty of
# * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# * GNU General Public License for more details.
# *
# * You should have received a copy of the GNU General Public License
# * along with this program; if not, write to the Free Software
# * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
# *
# * $Id$
# */

import av_conn
import av_log

conn = av_conn.Conn()

conn.html.content("text/html")
conn.html.header("Room Editor")
conn.html.heading("Room Editor")

conn.securitycheck(conn.user.getPERM()["room"],loglevel=av_log.SECLOG)
	
room = conn.getparam("room")

if (not conn.validatestring(room,caps=0,lower=0)):
	pass # FIXME: invalid room number
	
conn.html.body.set("Nothing here to see...")

# FIXME: make me pretty looking
"""
for rec in user.execSQL("SELECT room, name, note, id FROM rooms ORDER BY room"):
	print "<tr><td>" + rec[0]
	if (rec[1]):
		print " (" + rec[1] + ")"
	print "</td><td>" + rec[2] + "</td><td>"
	equip = ""
	for eq in user.execSQL("SELECT enumber FROM leases WHERE doroom=" + str(rec[3])):
		if (equip):
			equip += "</td></tr>\n<tr><td>&nbsp;</td><td>&nbsp;</td><td>" 
		equip += str(eq[0])
	if (equip):
		print equip
	else:
		print "<i>(none)</i>"
	print "</td></tr>\n"
"""
conn.html.footer()

print conn.flush()