def exit(message,table_data=None,db=None,display_login=1):
if display_login:
pmt_utils.usernamePasswordDisplay(username)
pmt_utils.alertsArea(form, message);
create_priv=0
#url='/%s/html/sprsum.html' % db_name
#pmt_utils.queryFunctionButtons(create_priv, url)
print '<HR>'
print '<TABLE><TR>'
java="return goto_url ('doc_maintenance.pyc')"
html='<INPUT TYPE="button" NAME="return_to_menu" VALUE=" Listing " '
html=html+'onClick="%s">' % java
pmt_utils.tableColumn(html)
print '</TR></TABLE>'
pmt_utils.textbox(None, 'key_id', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'action', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'item_no', '', '8', '8', None, None, 'hidden')
if table_data!=None and db!=None:
pageEnd(table_data,db)
sys.exit()
def exit(message):
pmt_utils.usernamePasswordDisplay()
pmt_utils.alertsArea(form, message)
queryFunctionButtons(0, '/%s/html/contactsum.html' % (db_name))
pmt_utils.textbox(None, 'key_id', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'action', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'item_no', '', '8', '8', None, None, 'hidden')
sys.exit()
def displayLogin(form,alert=None):
print "<HTML>"
print "<HEAD>"
pmt_utils.javaScript("cvsweb")
pmt_utils.title("Development Library")
print "</HEAD>"
pmt_utils.bodySetup()
pmt_utils.mainHeading('Development Library')
pmt_utils.subHeading('Login')
pmt_utils.formSetup("cvsweb",
db_name,
"cvsweb",
"return submitForm(document.cvsweb)")
pmt_utils.usernamePasswordDisplay()
if alert!=None:
pmt_utils.alertsArea(form, alert)
print "<hr><INPUT TYPE='submit' NAME='submit' value='Submit' >"
def displayLogin(alert=None):
print "<HTML>"
print "<HEAD>"
pmt_utils.javaScript("upload")
pmt_utils.title("Upload")
print "</HEAD>"
pmt_utils.bodySetup()
pmt_utils.mainHeading('Upload')
pmt_utils.subHeading('Login')
pmt_utils.formSetup("upload",declarations.pmt_info['db_name'],
"upload","return submitForm(document.upload)")
pmt_utils.usernamePasswordDisplay()
if alert!=None:
pmt_utils.alertsArea(form,alert)
print "<hr><INPUT TYPE='submit' NAME='submit' value='Submit' >"
if form.has_key('dest'):
print '<INPUT TYPE=hidden NAME=dest value="%s">' % form['dest'].value
def exit(message,table_data=None,db=None):
pmt_utils.usernamePasswordDisplay(username)
pmt_utils.alertsArea(form, message);
if username!=None and db!=None:
create_priv=pmt_utils.hasPriv(db,username,'user_admin')
else:
create_priv=0
url='/%s/html/contactsum.html' % db_name
pmt_utils.queryFunctionButtons(create_priv, url)
pmt_utils.textbox(None, 'key_id', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'action', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'item_no', '', '8', '8', None, None, 'hidden')
if table_data!=None and db!=None:
pageEnd(table_data,db)
sys.exit()
def exit(message, table_data=None, db=None, login_display=1):
if login_display:
pmt_utils.usernamePasswordDisplay()
pmt_utils.alertsArea(form, message)
if username != None and db != None:
create_priv = pmt_utils.hasPriv(db, username, 'create_ecp')
else:
create_priv = 0
queryFunctionButtons(create_priv, 0, '/%s/html/ecpsum.html' % db_name)
pmt_utils.textbox(None, 'key_id', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'action', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'item_no', '', '8', '8', None, None, 'hidden')
if table_data != None and db != None:
pageEnd(table_data, db)
sys.exit()
def displayLogin(form, alert=None):
print "<HTML>"
print "<HEAD>"
pmt_utils.javaScript("list_docs")
pmt_utils.title("Data Item Listing")
print "</HEAD>"
pmt_utils.bodySetup()
pmt_utils.mainHeading('Data Item Listing')
pmt_utils.subHeading('Login')
java = "return submitForm(document.list_docs)"
pmt_utils.formSetup("list_docs", db_name, "list_docs", java)
pmt_utils.usernamePasswordDisplay()
if alert != None:
pmt_utils.alertsArea(form, alert)
print "<hr><INPUT TYPE='submit' NAME='submit' value='Submit' >"
if form.has_key('directory'):
if string.find(form['directory'].value, '..') >= 0:
sys.exit()
print "<INPUT TYPE='hidden' NAME='directory' "
print "value='%s'>" % form['directory'].value
def exit(message, table_data=None, display_login=1):
if display_login:
pmt_utils.usernamePasswordDisplay(username)
pmt_utils.alertsArea(form, message)
#if username!=None and db!=None:
# create_priv=pmt_utils.hasPriv(db,username,'create_spr')
#else:
# create_priv=0
#url='/%s/html/sprsum.html' % db_name
#pmt_utils.queryFunctionButtons(create_priv, url)
textbox(None, 'key_id', '', '10', '10', None, None, 'hidden')
textbox(None, 'action', '', '10', '10', None, None, 'hidden')
textbox(None, 'item_no', '', '8', '8', None, None, 'hidden')
if table_data != None and db != None:
pageEnd(table_data, db)
sys.exit()
def verifyUserPass(db):
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
print "<form method=post>"
pmt_utils.usernamePasswordDisplay()
pmt_utils.alertsArea(form, details)
print "<hr><INPUT TYPE='submit' NAME='submit' value='Submit' >"
print "</form>"
sys.exit(1)
if pmt_utils.hasPriv(db, username, 'project_data')!=1:
print "<form method=post>"
pmt_utils.usernamePasswordDisplay()
message='User %s does not have access to view Data Items' % username
pmt_utils.alertsArea(form, message)
print "<hr><INPUT TYPE='submit' NAME='submit' value='Submit' >"
print "</form>"
sys.exit(1)
message=''
if form.has_key('add'):
message=addOption(db)
if form.has_key('delete'):
message=deleteOption(db)
print '<FORM METHOD=POST ACTION=/%s-cgi-bin/options.pyc>' % db_name
getTableName(db)
if form.has_key('table_name'):
listOptions(db)
addPrompt()
print '</FORM>'
if message!='':
pmt_utils.textarea(None, 'alerts', message,'2', '32', None, None)
else:
print "<form method=post>"
pmt_utils.usernamePasswordDisplay()
print "<hr><INPUT TYPE='submit' NAME='submit' value='Submit' >"
print "</form>"
print '</BODY>'
print '</HTML>'
#------------------------------------------------------------------------------
def edit_project_info(performDbQuery=0, onLoad=None, queryFields=None):
table_data = declarations.define_tables()
print "<HTML>"
print "<HEAD>"
pmt_utils.javaScript("project_admin")
pmt_utils.title("Project Administration")
print "</HEAD>"
pmt_utils.bodySetup(onLoad)
pmt_utils.mainHeading('Project Administration')
pmt_utils.subHeading('Project Info')
pmt_utils.formSetup("project_admin", db_name, "project_admin",
"return submitForm(document.project_admin)")
if username == None:
pmt_utils.usernamePasswordDisplay()
project_adminButtons(button_name='edit')
pmt_utils.textbox(None, 'key_id', '1', '10', '10', None, None,
'hidden')
pmt_utils.textbox(None, 'action', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'item_no', '', '8', '8', None, None, 'hidden')
print "</FORM>"
try:
pmt_utils.trailer(table_data, db)
db.close()
except NameError:
pass
print "</BODY>"
print "</HTML>"
return
dbResult = pmt_utils.connectDB(declarations.pmt_info['browser_username'],
declarations.pmt_info['browser_password'],
declarations.pmt_info['db_name'])
# could not connect to db
if dbResult['status'] != 'success':
pmt_utils.alertsArea(
form, "Can not connect to database,\n" + dbResult['message'])
project_adminButtons()
print "</FORM>"
try:
pmt_utils.trailer(table_data, db)
db.close()
except NameError:
pass
print "</BODY>"
print "</HTML>"
return
db = dbResult['result']
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
print '<form method=post action=/%s-cgi-bin/project_admin.pyc>' % db_name
pmt_utils.usernamePasswordDisplay(username)
pmt_utils.alertsArea(form, 'Can not verify you as a valid user')
print '<hr><input name=reload type=submit value="Query">'
print '<input name=action value=edit type=hidden>'
print '</form>'
sys.exit()
if pmt_utils.hasPriv(db, username, 'project_data') != 1:
print '<form method=post action=/%s-cgi-bin/project_admin.pyc>' % db_name
pmt_utils.usernamePasswordDisplay(username)
msg = 'User %s does not have project admin privileges>' % username
pmt_utils.alertsArea(form, msg)
print '<hr><input name=reload type=submit value="Query">'
print '<input name=action value=edit type=hidden>'
print '</form>'
sys.exit()
if form.has_key('key_id'):
key_id = form['key_id'].value
else:
key_id = '1'
sqlStatement = pmt_utils.selectAllColumnsSqlStatement(
table_data, 'project_info', key_id)
dbResult = pmt_utils.executeSQL(db, sqlStatement)
if dbResult['status'] != 'success':
msg = "Could not retrieve project information\n" + dbResult['message']
pmt_utils.alertsArea(form, msg)
else:
result = dbResult['result']
table_data = pmt_utils.dbToTableData(table_data, 'project_info',
result[0])
table_data['project_info']['id']['value'] = '1'
pmt_utils.display_form(table_data, 'project_info', 1, 'useValues', 1,
db)
pmt_utils.alertsArea(form,
"Project Information retrieved successfully")
project_adminButtons(button_name='save')
pmt_utils.textbox(None, 'key_id', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'action', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'item_no', '', '8', '8', None, None, 'hidden')
print "</FORM>"
try:
pmt_utils.trailer(table_data, db)
db.close()
except NameError:
pass
print "</BODY>"
print "</HTML>"
def doEdit():
table_data = declarations.define_tables()
print "<HTML>"
print "<HEAD>"
pmt_utils.generate_form_javascript(table_data, 'project_info',
'project_admin', 0)
pmt_utils.title("Project Info Administration")
print "</HEAD>"
pmt_utils.bodySetup()
pmt_utils.mainHeading('Project Info Administration')
pmt_utils.subHeading('Edit Project Info')
pmt_utils.formSetup("project_admin", db_name, "project_admin",
"return submitForm(document.project_admin)")
dbResult = pmt_utils.connectDB(declarations.pmt_info['browser_username'],
declarations.pmt_info['browser_password'],
declarations.pmt_info['db_name'])
if dbResult['status'] != 'success':
msg = "Could not connect to the database\n"
pmt_utils.alertsArea(form, msg + dbResult['message'])
sys.exit()
db = dbResult['result']
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
print '<form method=post action=/%s-cgi-bin/project_admin.pyc>' % db_name
pmt_utils.usernamePasswordDisplay(username)
pmt_utils.alertsArea(form, 'Can not verify you as a valid user')
print '<hr><input name=reload type=submit value="Query">'
print '<input name=action value=edit type=hidden>'
print '</form>'
sys.exit()
if pmt_utils.hasPriv(db, username, 'project_data') != 1:
print '<form method=post action=/%s-cgi-bin/project_admin.pyc>' % db_name
pmt_utils.usernamePasswordDisplay(username)
msg = 'User %s does not have project admin privileges' % username
pmt_utils.alertsArea(form, msg)
print '<hr><input name=reload type=submit value="Query">'
print '<input name=action value=edit type=hidden>'
print '</form>'
sys.exit()
sqlStatement = pmt_utils.selectAllColumnsSqlStatement(
table_data, 'project_info', '1')
dbResult = pmt_utils.executeSQL(db, sqlStatement)
if dbResult['status'] != 'success':
msg = "Could not retrieve project info to edit\n"
pmt_utils.alertsArea(form, msg + dbResult['message'])
else:
result = dbResult['result']
table_data = pmt_utils.dbToTableData(table_data, 'project_info',
result[0])
table_data['project_info']['id']['value'] = '1'
pmt_utils.display_form(table_data, 'project_info', 1, 'useValues', 1,
db)
pmt_utils.alertsArea(form, "Project Info retrieved successfully")
project_adminButtons('save')
pmt_utils.textbox(None, 'key_id', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'action', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'item_no', '', '8', '8', None, None, 'hidden')
print "</FORM>"
pmt_utils.trailer(table_data, db)
db.close()
print "</BODY>"
print "</HTML>"
