def doEdit():
status, table_data, db = pageInit("Edit", formJS=1)
if status != 'success':
message = "Could not connect to the database\n" + status
exit(message.table_data, db)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details, table_data, db)
sqlStatement = pmt_utils.selectAllColumnsSqlStatement(
table_data, 'ecp', form["key_id"].value)
dbResult = pmt_utils.executeSQL(db, sqlStatement)
if dbResult['status'] != 'success':
message = "Could not retrieve item.\n" + dbResult['message']
exit(message, table_data, db)
result = dbResult['result']
table_data = pmt_utils.dbToTableData(table_data, 'ecp', result[0])
display_questionnaire(db, table_data, 'edit')
pmt_utils.alertsArea(form, "Item data retrieved successfully")
del_priv = pmt_utils.hasPriv(db, username, 'del_ecp')
list_url = '/%s-cgi-bin/ecp_admin.pyc?performDbQuery=1' % (db_name)
help_url = "/%s/html/ecp_intro.html" % db_name
editFunctionButtons(form["key_id"].value, list_url, help_url, del_priv)
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')
pmt_utils.textbox(None, 'analyst_signature',
table_data['ecp']['analyst_signature']['value'], '40',
'40', None, None, 'hidden')
pmt_utils.textbox(None, 'swm_analysis_signature',
table_data['ecp']['swm_analysis_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'swm_completion_signature',
table_data['ecp']['swm_completion_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'gccb_signature',
table_data['ecp']['gccb_signature']['value'], '40', '40',
None, None, 'hidden')
pmt_utils.textbox(None, 'ccb_signature',
table_data['ecp']['ccb_signature']['value'], '40', '40',
None, None, 'hidden')
pmt_utils.textbox(None, 'qa_completion_signature',
table_data['ecp']['qa_completion_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'test_completion_signature',
table_data['ecp']['test_completion_signature']['value'],
'40', '40', None, None, 'hidden')
pageEnd(table_data, db)
def doCreate():
status, table_data, db = pageInit('Create', formJS=1)
if status != 'success':
message = "Could not connect to db,\n" + dbResult['message']
exit(message)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
display_questionnaire(db, table_data, 'edit')
message = "Enter information on form and depress Create button"
pmt_utils.alertsArea(form, message)
listing_url = '/%s-cgi-bin/inv_admin.pyc?performDbQuery=1' % (db_name)
help_url = '/%s/html/sprsum.html' % db_name
pmt_utils.createFunctionButtons('create', listing_url, help_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')
po_id = table_data['inventory']['po_id']['value']
print '<input type=hidden name=po_id value="%s">' % po_id
val = table_data['inventory']['prop_id_assigned_by_signature']['value']
pmt_utils.textbox(None, 'prop_id_assigned_by_signature', val, '40', '40',
None, None, 'hidden')
pageEnd(table_data, db)
def verifyUserPass(): db = pmt_utils.connectDB(declarations.pmt_info['browser_username'], declarations.pmt_info['browser_password'], declarations.pmt_info['db_name']) # could not connect to db if db['status'] != 'success': message= "Can not connect to database,\n" + db['message'] pmt_utils.alertsArea(form,message) displayLogin(form) sys.exit(1) status, details = db_authentication.password_valid(db['result'], crypt_salt=db_name, username=username, password=password) if status != 'success': displayLogin(form,details) sys.exit(1) cvs_web_priv=pmt_utils.hasPriv(db['result'],username,'cvs_web') cvs_export_priv=pmt_utils.hasPriv(db['result'],username,'cvs_export') if cvs_web_priv==0 and cvs_export_priv==0: message='User %s does not have access to CVS' % username displayLogin(form, message) sys.exit() return cvs_web_priv,cvs_export_priv
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 query_project_members(performDbQuery=0,onLoad=None,queryFields=None):
status,table_data,db=pageInit('Members',formJS=0)
if status != 'success':
message='Could not connect to database.\n%s' % status
exit(message)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
# Check for user admin privileges
if pmt_utils.hasPriv(db, username,'user_admin')!=1:
message='User %s does not have user admin privileges.' % username
exit(message)
queryFields,whereFields=pmt_utils.getQueryWhereFields(form,
table_data,
'project_members')
if queryFields == None or queryFields == []:
queryFields = []
whereFields = None
queryFields.append('first_name')
queryFields.append('last_name')
queryFields.append('phone_number_voice')
dbResult,queryStatement=pmt_utils.executeQuery(db,
table_data,
'project_members',
queryFields,
whereFields,
'query',
queryItemFunctionsHtml,
'ORDER by last_name',
['id'],
None,None,
"return execute('query')",
["",""])
if dbResult['status'] != 'success':
message="Could not get member data from db.\n%s" % dbResult['message']
exit(message)
msg="Last Query Statement: %s\n" % queryStatement
msg=msg+"%s project members retrieved from db" % `len(dbResult['result'])`
pmt_utils.alertsArea(form,msg)
# Add buttons and hidden fields
help_url='/%s/html/contactsum.html' % db_name
pmt_utils.queryFunctionButtons(1,help_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')
pageEnd(table_data,db)
def doSave():
saveDueToCreate = 0
status, table_data, db = pageInit('Save', formJS=1)
if status != 'success':
message = "Could not connect to db.\n" + status
exit(message)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
if form["key_id"].value == 'create':
saveDueToCreate = 1
queryResult = pmt_utils.executeSQL(db, "SELECT NEXTVAL('pai_id_seq')")
form["key_id"].value = ` queryResult['result'][0]['nextval'] `
dbResult = pmt_utils.saveForm(table_data, db, form['key_id'].value, "pai",
" WHERE id = '%s'" % form["key_id"].value,
form)
if dbResult['status'] != 'success':
message = "Action item could not be saved.\n" + dbResult['message']
exit(message)
if saveDueToCreate:
subject = 'New PAI #%s has been generated' % (form['key_id'].value)
msg = "PAI #%s has been generated.\n\n" % form["key_id"].value
msg = msg + "Assigned to: %s\n" % form['assigned_to'].value
msg = msg + "Problem Description:\n%s" % form['action_required'].value
msg = msg + "\n\nLog into the Project Action Item tracking tool at "
msg = msg + "http://www.isrparc.org for further info.\n\n"
msg = msg + "If you do not wish to be on this mailing list please "
msg = msg + "send an email requesting removal to [email protected].\n"
pmt_utils.emailList(db, 'localhost', 'pai_list', subject, msg)
table_data = pmt_utils.formToTableData(table_data, 'pai', form,
form['key_id'].value)
pmt_utils.display_form(table_data, 'pai', 1, 'useValues', 1, db)
pmt_utils.alertsArea(form, "Action item successfully saved")
# generate function button row
listing_url = '/%s-cgi-bin/pai_admin.pyc?performDbQuery=1' % (db_name)
help_url = '/%s/html/paisum.html' % (db_name)
editFunctionButtons(form["key_id"].value, listing_url, help_url)
# generate hidden fields for form
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')
pageEnd(table_data, db)
def doCreate():
status, table_data, db = pageInit('Create', formJS=1)
if status != 'success':
message = "Item could not be created.\n" + status
exit(message)
# initialize form data values to zero or blank and set origination date
table_data = pmt_utils.init_table_data(table_data, 'ecp')
now = time_pkg.current_time_MM_DD_YYYY()
table_data['ecp']['origination_date']['value'] = now
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
display_questionnaire(db, table_data, 'edit')
# display alerts area to create
message = "Enter information on form and depress Create button"
pmt_utils.alertsArea(form, message)
# create functions button row
listing_url = '/%s-cgi-bin/ecp_admin.pyc?performDbQuery=1' % (db_name)
help_url = "/%s/html/ecp_intro.html" % db_name
pmt_utils.createFunctionButtons('create', listing_url, help_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')
pmt_utils.textbox(None, 'analyst_signature',
table_data['ecp']['analyst_signature']['value'], '40',
'40', None, None, 'hidden')
pmt_utils.textbox(None, 'swm_analysis_signature',
table_data['ecp']['swm_analysis_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'swm_completion_signature',
table_data['ecp']['swm_completion_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'ccb_signature',
table_data['ecp']['ccb_signature']['value'], '40', '40',
None, None, 'hidden')
pmt_utils.textbox(None, 'gccb_signature',
table_data['ecp']['gccb_signature']['value'], '40', '40',
None, None, 'hidden')
pmt_utils.textbox(None, 'qa_completion_signature',
table_data['ecp']['qa_completion_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'test_completion_signature',
table_data['ecp']['test_completion_signature']['value'],
'40', '40', None, None, 'hidden')
pageEnd(table_data, db)
def display_form(form, alerts):
username = ''
current_password = ''
new_password = ''
verify_password = ''
if form.has_key('username'):
username = form['username'].value
if form.has_key('current_password'):
current_password = form['current_password'].value
if form.has_key('new_password'):
new_password = form['new_password'].value
if form.has_key('verify_password'):
verify_password = form['verify_password'].value
print '<html><head><title>Password Maintenance</title></head>'
# print '<body bgcolor="#B7BAB7" TEXT="#000000">
print '<body background="/%s/icons/circ_bg.jpg">' % (
declarations.pmt_info['db_name'])
# print '<H1>Password Maintenance</H1>'
pmt_utils.mainHeading('Maintenance')
pmt_utils.subHeading('Change Password')
print '<form action="/%s-cgi-bin/passwd_admin.pyc" method="POST" enctype="application/x-www-form-urlencoded">' % (
declarations.pmt_info['db_name'])
print '<TABLE BORDER=0>'
print '<TR><TD><B>Username</B>:</TD><TD><input name="username" type="text" size="9" maxlength="9" value="%s"></TD></TR>' % (
username)
print '<TR><TD><B>Current Password:</B></TD><TD><input name="current_password" type="password" size="8" maxlength="8" value="%s"></TD></TR>' % (
current_password)
print '<TR><TD><B>New Password:</B></TD><TD><input name="new_password" type="password" size="8" maxlength="8" value="%s"></TD></TR>' % (
new_password)
print '<TR><TD><B>Verify Password:</B></TD><TD><input name="verify_password" type="password" size="8" maxlength="8" value="%s"></TD></TR>' % (
verify_password)
print '<TR><TD COLSPAN=2>'
pmt_utils.alertsArea(form, alerts)
print '</TD></TR>'
print """</TABLE>
<HR>
<input name="submit" type="submit" value="Update Password">
<p align="right"><A HREF="mailto:[email protected]">Contact Support Team</a>"""
print """</form>
def doEdit():
status, table_data, db = pageInit("Edit", formJS=1)
if status != 'success':
message = "Could not connect to the database.\n" + status
exit(message)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
sqlStatement = pmt_utils.selectAllColumnsSqlStatement(
table_data, 'inventory', form["key_id"].value)
dbResult = pmt_utils.executeSQL(db, sqlStatement)
if dbResult['status'] != 'success':
message = "Could not retrieve item to edit.\n" + dbResult['message']
exit(message)
result = dbResult['result']
table_data = pmt_utils.dbToTableData(table_data, 'inventory', result[0])
display_questionnaire(db, table_data, 'edit')
pmt_utils.alertsArea(form, "Item data retrieved successfully")
pmt_utils.textbox(
None, 'prop_id_assigned_by_signature',
table_data['inventory']['prop_id_assigned_by_signature']['value'],
'40', '40', None, None, 'hidden')
listing_url = '/%s-cgi-bin/inv_admin.pyc?performDbQuery=1' % (db_name)
help_url = '/%s/html/sprsum.html' % (db_name)
po_id = table_data['inventory']['po_id']['value']
print '<input type=hidden name=po_id value="%s">' % po_id
if form.has_key("return_to_po"):
print '<input type=hidden name=return_to_po value=1>'
java = "return goto_url('/%s-cgi-bin/po_admin.pyc?action=edit&key_id=%s')" % (
db_name, table_data['inventory']['po_id']['value'])
html = '<INPUT NAME="edit" type="button" value=" Return to PO " onClick="%s">' % java
print '<BR><BR>'
print html
editFunctionButtons(form["key_id"].value, listing_url, help_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')
pageEnd(table_data, db)
def doEdit():
status,table_data,db = pageInit('Edit',formJS=1)
if status!='success':
message="Could not connect to db.\n%s" % status
exit(message)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
sqlStatement = pmt_utils.selectAllColumnsSqlStatement(table_data,
'project_members',
form["key_id"].value)
dbResult = pmt_utils.executeSQL(db, sqlStatement)
if dbResult['status'] != 'success':
message="Could not get project member data.\n%s" % dbResult['message']
exit(message)
result = dbResult['result']
table_data=pmt_utils.dbToTableData(table_data,'project_members',result[0])
pmt_utils.display_form(table_data,'project_members', 1,'useValues', 1, db)
# get user privileges and display them
sqlStatement = "select * from priviledges where " +\
"member_username='******'" % (result[0]['member_username'])
dbResult = pmt_utils.executeSQL(db, sqlStatement)
if dbResult['status'] != 'success':
message="Could not get privileges from db.\n%s" % dbResult['message']
exit(message,table_data,db)
result = dbResult['result']
table_data = pmt_utils.dbToTableData(table_data,'priviledges', result[0])
displayPriviledges(result[0], table_data)
pmt_utils.alertsArea(form,"Project member data retrieved successfully")
listing_url= '/%s-cgi-bin/project_members_admin.pyc?performDbQuery=1' % (db_name)
help_url='/%s/html/contactsum.html' % db_name
pmt_utils.editFunctionButtons(form["key_id"].value,listing_url,help_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')
pageEnd(table_data,db)
def doSave():
status, table_data, db = pageInit('Save', formJS=0)
if status != 'success':
message = "Could not connect to db.\n" + status
exit(message)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
# save the Form
dbResult = pmt_utils.saveForm(table_data, db, form['key_id'].value,
"project_members",
" WHERE id = '%s'" % form["key_id"].value,
form)
if dbResult['status'] != 'success':
message = "Save error.\n" + dbResult['message']
exit(message)
table_data = pmt_utils.formToTableData(table_data, 'project_members', form,
form['key_id'].value)
table_data['project_members']['member_username']['display'] = 'read-only'
table_data['project_members']['member_role']['display'] = 'read-only'
table_data['project_members']['member_password']['display'] = 'Hidden'
pmt_utils.display_form(table_data, 'project_members', 1, 'useValues', 1,
db)
pmt_utils.alertsArea(form, "Member data successfully saved")
# generate function button row
listing_url = '/%s-cgi-bin/contact_list.pyc?performDbQuery=1' % db_name
help_url = '/%s/html/contactsum.html' % (db_name)
editFunctionButtons(form["key_id"].value, listing_url, help_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')
pageEnd(table_data, db)
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 doEdit():
status, table_data, db = pageInit('Edit', formJS=0)
if status != 'success':
message = "Could not connect to db.\n%s" % status
exit(message)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
sqlStatement = pmt_utils.selectAllColumnsSqlStatement(
table_data, 'project_members', form["key_id"].value)
dbResult = pmt_utils.executeSQL(db, sqlStatement)
if dbResult['status'] != 'success':
message = "Unable to get member data from db.\n" + dbResult['message']
exit(message)
result = dbResult['result']
table_data = pmt_utils.dbToTableData(table_data, 'project_members',
result[0])
table_data['project_members']['member_username']['display'] = 'read-only'
table_data['project_members']['member_password']['display'] = 'Hidden'
table_data['project_members']['member_role']['display'] = 'read-only'
pmt_utils.display_form(table_data, 'project_members', 1, 'useValues', 1,
db)
pmt_utils.alertsArea(form, "Member data retrieved successfully")
listing_url = '/%s-cgi-bin/contact_list.pyc?performDbQuery=1' % db_name
help_url = '/%s/html/contactsum.html' % (db_name)
editFunctionButtons(form['key_id'].value, listing_url, help_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')
pageEnd(table_data, db)
def doCreate():
status,table_data,db=pageInit('Create',formJS=1)
if status != 'success':
message="Could not connect to db,\n" + dbResult['message']
exit(message)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
display_questionnaire(db,table_data, 'edit')
message="Enter information on form and depress Create button"
pmt_utils.alertsArea(form,message)
listing_url='/%s-cgi-bin/spr_admin.pyc?performDbQuery=1' % (db_name)
help_url='/%s/html/spr_intro.html' % db_name
pmt_utils.createFunctionButtons('create',listing_url,help_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')
pmt_utils.textbox(None, 'analyst_signature',
table_data['spr']['analyst_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'swm_analysis_signature',
table_data['spr']['swm_analysis_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'swm_completion_signature',
table_data['spr']['swm_completion_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'test_completion_signature',
table_data['spr']['test_completion_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'cm_completion_signature',
table_data['spr']['cm_completion_signature']['value'],
'40', '40', None, None, 'hidden')
pmt_utils.textbox(None, 'qa_completion_signature',
table_data['spr']['qa_completion_signature']['value'],
'40', '40', None, None, 'hidden')
pageEnd(table_data,db)
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 validUserPass(username, password):
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.htmlContentType()
print '<html>'
pmt_utils.alertsArea(form, "Can not connect to database")
sys.exit(1)
else:
db = dbResult['result']
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
return status
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 doCreate():
status,table_data,db=pageInit('Create',formJS=1)
if status != 'success':
message="Could not connect to db.\n%s" % status
exit(message)
pmt_utils.display_form(table_data, 'project_members', 1,'useValues',1,db)
displayPriviledges({}, table_data)
message="Enter information on form and depress Create button"
pmt_utils.alertsArea(form,message)
# Add buttons and hidden fields
listing_url='/%s-cgi-bin/project_members_admin.pyc?performDbQuery=1' % (db_name)
help_url='/%s/html/contactsum.html' % db_name
pmt_utils.createFunctionButtons('create',listing_url, help_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')
pageEnd(table_data,db)
def doEdit():
status, table_data, db = pageInit('Edit', formJS=1)
if status != 'success':
message = "Could not connect to the database.\n" + status
exit(message)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
sqlStatement = pmt_utils.selectAllColumnsSqlStatement(
table_data, 'pai', form["key_id"].value)
dbResult = pmt_utils.executeSQL(db, sqlStatement)
if dbResult['status'] != 'success':
message = "Could not retrieve action item to edit.\n" + dbResult[
'message']
exit(message)
result = dbResult['result']
table_data = pmt_utils.dbToTableData(table_data, 'pai', result[0])
pmt_utils.display_form(table_data, 'pai', 1, 'useValues', 1, db)
pmt_utils.alertsArea(form, "Action item data retrieved successfully")
listing_url = '/%s-cgi-bin/pai_admin.pyc?performDbQuery=1' % (db_name)
help_url = '/%s/html/pai_intro.html' % (db_name)
del_priv = pmt_utils.hasPriv(db, username, 'del_pai')
editFunctionButtons(form["key_id"].value, listing_url, help_url, del_priv)
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')
pageEnd(table_data, db)
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)
def doCreate():
status, table_data, db = pageInit('Create', formJS=1)
if status != 'success':
message = "Could not connect to db.\n%s" % status
exit(message)
# initialize form data values to zero or blank
table_data = pmt_utils.init_table_data(table_data, 'pai')
now = time_pkg.current_time_MM_DD_YYYY()
table_data['pai']['date_created']['value'] = now
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
table_data['pai']['id']['display'] = 'hidden'
pmt_utils.display_form(table_data, 'pai', 1, 'useValues', 1, db)
message = "Enter information on form and depress Create button"
pmt_utils.alertsArea(form, message)
# create functions button row
listing_url = '/%s-cgi-bin/pai_admin.pyc?performDbQuery=1' % (db_name)
help_url = '/%s/html/pai_intro.html' % (db_name)
pmt_utils.createFunctionButtons('create', listing_url, help_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')
pageEnd(table_data, db)
print "<HEAD>"
pmt_utils.title("Edit Project Options")
print "</HEAD>"
pmt_utils.bodySetup()
pmt_utils.mainHeading("Project Option Manager")
pmt_utils.subHeading("Add/Delete Options")
if username!=None:
dbResult=pmt_utils.connectDB(declarations.pmt_info['browser_username'],
declarations.pmt_info['browser_password'],
declarations.pmt_info['db_name'])
if dbResult['status'] != 'success':
message="Can not connect to database,\n" + dbResult['message']
pmt_utils.alertsArea(form,message)
sys.exit()
db=dbResult['result']
verifyUserPass(db)
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
print "<TABLE CELLPADDING=1 CELLSPACING=0></TABLE>"
print '<center>'
print '<A HREF="/%s/html/siteInfo.html" target="siteInfo">' % db
print '<img src="/%s/icons/%s.jpg" width=125></A></center>' % (db, db)
print '<center>'
username, password = pmt_utils.getUserPass(None)
if username != None and password != None:
dbResult = pmt_utils.connectDB(declarations.pmt_info['browser_username'],
declarations.pmt_info['browser_password'],
declarations.pmt_info['db_name'])
if dbResult['status'] != 'success':
pmt_utils.alertsArea(None, dbResult['message'])
sys.exit()
else:
DB = dbResult['result']
print '<img src=/%s/icons/top.gif usemap="#top" border=0><br>' % db
#print db
if db == "usafsr":
form = pmt_utils.getFormData()
#print form
if form.has_key('public'):
print '<img src=/%s/icons/downloads.gif usemap="#file_exchange" border=0><br>' % db
simpleAdmin()
print '<img src=/%s/icons/logout.gif usemap="#logout" border=0><br>' % db
print '<map name=file_exchange>'
def display_form(display_files=0,alerts=None):
print "<HTML>"
print "<HEAD>"
pmt_utils.javaScript("doc_maintenance")
pmt_utils.title("Documentation Maintenance")
print "</HEAD>"
pmt_utils.bodySetup()
pmt_utils.mainHeading('Documentation Maintenance')
pmt_utils.subHeading('Create and Delete Folders/Files')
pmt_utils.formSetup("doc_maintenance",db_name,"doc_maintenance",None)
dbResult=pmt_utils.connectDB(declarations.pmt_info['browser_username'],
declarations.pmt_info['browser_password'],
declarations.pmt_info['db_name'])
if dbResult['status']!='success':
exit(dbResult['message'])
db=dbResult['result']
status,details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status!='success':
exit(details)
if not pmt_utils.hasPriv(db,username,'folder_admin'):
msg="User %s does not have folder maintenance priviledges" % username
exit(msg)
print '<hr><br><CENTER><B>Delete Folders/Files</B></CENTER>'
stripped_db=string.lower(string.strip(db_name))
os.chdir(os.path.join('/home',stripped_db,'documents'))
file_list = os_utils.walk_list_files(
directory_name='.',
list_only_files=0,
exclude_list = [],
include_file_type=1)
if len(file_list) > 25:
list_size = 25
else:
list_size = len(file_list)
print '<BLINK><B>WARNING:</B></BLINK><br>'
print 'Any folders or files that you select for deletion are '
print 'permanently deleted. You should have a local backup of '
print 'any folders/files you delete in case you really did not mean '
print 'to delete. Backups are crucial. You have been warned.'
print '<p>Selecting a folder will delete the folder and all files '
print 'under it including sub folders. '
print 'Select folder names with caution.'
print '<p>Your deletes will not be confirmed. '
print 'When you press [Delete Folders/Files] your files are deleted.'
print '<BR><CENTER><B>Select folders/files to delete</B>:<BR>'
print '<SELECT NAME="files_to_remove" SIZE="8" MULTIPLE>'
for curfile in file_list:
print '<OPTION>%s' % (curfile)
print "</SELECT><br>"
java_call="return execute('delete_folder','1')"
print '<input name="delete_folder" type="button" '
print 'value=" Delete Folders/Files " onClick="%s">' % java_call
print '<input name ="website_name_hidden" '
print 'type="hidden" value="%s">' % (db_name)
print "<hr><BR><BR>"
print '<CENTER><B>Create Folder</B></CENTER><BR>'
print '<B>Folder Name</B>: '
print '<input name="folder" type="text" size="50" maxlength="100"><BR>'
java_call="return execute('create','1')"
print '<input name="create" type="button" '
print 'value=" Create Folder " onClick="%s">' % java_call
print '<input name ="website_name_hidden" '
print 'type="hidden" value="%s"><hr>' % (db_name)
if alerts != None:
pmt_utils.alertsArea(form,alerts)
print '</CENTER>'
pmt_utils.textbox(None, 'action', '', '10', '10', None, None, 'hidden')
pmt_utils.textbox(None, 'key_id', '1', '10', '10', None, None,'hidden')
print '</form>'
print '<p align="right">'
print '<A HREF="mailto:[email protected]">Contact Support Team</a>'
print "</body></html>"
username, password = pmt_utils.getUserPass(form)
if username == None:
displayLogin(form)
else:
pageSetup()
db = pmt_utils.connectDB(declarations.pmt_info['browser_username'],
declarations.pmt_info['browser_password'],
declarations.pmt_info['db_name'])
# could not connect to db
if db['status'] != 'success':
message = "Can not connect to database,\n" + db['message']
pmt_utils.alertsArea(form, )
sys.exit(1)
verifyUserPass(db['result'])
edit_priv = pmt_utils.hasPriv(db['result'], username, 'edit_details')
del_priv = pmt_utils.hasPriv(db['result'], username, 'del_docs')
up_priv = pmt_utils.hasPriv(db['result'], username, 'upload')
private_priv = pmt_utils.hasPriv(db['result'], username, 'private_data')
admin_priv = pmt_utils.hasPriv(db['result'], username, 'folder_admin')
writeTable(form, username, edit_priv, del_priv, up_priv, private_priv,
admin_priv)
print '</BODY>'
print '</HTML>'
#------------------------------------------------------------------------------
def doSave():
saveDueToCreate = 0
status, table_data, db = pageInit('Edit', formJS=1)
if status != 'success':
message = "Could not connect to db.\n%" % status
exit(message)
status, details = db_authentication.password_valid(db,
crypt_salt=db_name,
username=username,
password=password)
if status != 'success':
exit(details)
if form["key_id"].value == 'create':
saveDueToCreate = 1
queryResult = pmt_utils.executeSQL(
db, "SELECT NEXTVAL('inventory_id_seq')")
form["key_id"].value = ` queryResult['result'][0]['nextval'] `
table_data = pmt_utils.formToTableData(table_data, 'inventory', form,
form['key_id'].value)
alerts = ''
data = pmt_utils.process_signature(
db, form['prop_id_assigned_by_username'].value,
form['prop_id_assigned_by_password'].value, 'Property ID Authority',
form['prop_id_assigned_by_signature'].value,
form['prop_id_assigned_by_sig_func'].value)
(status, details,
table_data['inventory']['prop_id_assigned_by_username']['value'],
table_data['inventory']['prop_id_assigned_by_password']['value'],
table_data['inventory']['prop_id_assigned_by_signature']['value'],
table_data['inventory']['prop_id_assigned_by_sig_func']['value']) = data
dbResult = pmt_utils.saveForm(table_data, db, form['key_id'].value,
"inventory",
" WHERE id = '%s'" % form["key_id"].value,
form, 0, 0)
if dbResult['status'] != 'success':
message = "Item could not be saved.\n" + dbResult['message']
exit(message)
if saveDueToCreate:
subject = 'New INV #%s has been generated' % form['key_id'].value
# message='INV #%s has been generated.\n\n' % form["key_id"].value
# message=message+'Assigned to: %s\n\n' % form['assigned_to'].value
# message=message+'Problem Description is as follows:\n'
# message=message+form['problem_description'].value+'\n\n'
# message=message+'Log into the Inventory tracking tool at '
# message=message+'http://www.isrparc.org for further info.'
# message=message+'If you do not wish to be on this mailing list '
# message=message+'please send an email requesting removal to '
# message=message+'[email protected].\n'
# pmt_utils.emailList(db,'localhost', 'inv_list', subject, message)
display_questionnaire(db, table_data, 'edit')
alerts = alerts + '\nItem saved successfully'
pmt_utils.alertsArea(form, alerts)
listing_url = '/%s-cgi-bin/inv_admin.pyc?performDbQuery=1' % (db_name)
help_url = '/%s/html/sprsum.html' % db_name
# This will return to po_admin.py or inv_admin.py in Edit mode.
if form.has_key("return_to_po"):
data = '?action=edit&key_id=%s' % table_data['inventory']['po_id'][
'value']
java = "return goto_url('/%s-cgi-bin/po_admin.pyc%s')" % (db_name,
data)
html = '<INPUT NAME="edit" type="button" value=" Return to PO '
html = html + '" onClick="%s">' % java
print '<BR><BR>'
print html
editFunctionButtons(form["key_id"].value, listing_url, help_url)
po_id = table_data['inventory']['po_id']['value']
print '<input type=hidden name=po_id value="%s">' % po_id
val = table_data['inventory']['prop_id_assigned_by_signature']['value']
pmt_utils.textbox(None, 'prop_id_assigned_by_signature', val, '40', '40',
None, None, 'hidden')
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')
pageEnd(table_data, db)
