def sendEmail():
subject="New user for %s project" % form['project_name'].value
content="Name: %s\n" % form['name'].value
content=content+"Organization: %s\n" % form['org'].value
content=content+"Address: %s\n" % form['address'].value
content=content+"City: %s\n" % form['city'].value
content=content+"State: %s\n" % form['state'].value
content=content+"Zip: %s\n" % form['zip'].value
content=content+"Phone Number: %s\n" % form['phone'].value
content=content+"Email: %s\n" % form['email'].value
content=content+"Reason for Access: %s\n" % form['reason'].value
try:
pmt_utils.send_email('localhost',form['email'].value,['*****@*****.**'], subject, content)
except smtplib.SMTPSenderRefused:
getData()
print "<br><font color=red><b>The email you entered is invalid.</b></font>"
return
if form.has_key('project_name'):
if string.upper(form['project_name'].value)=="USAFSR":
print "Thank you for your interest in the MultiUAV research software. An email will be sent to %s with your username and password.<br><br>For further information please call (304)368-9300 x237" % form['email'].value
else:
print "An email will be sent to %s with your username and password." % form['email'].value
print '<form>'
print '<input type=submit value="Close Window" name=submit onClick=self.close()>'
print '</form>'
def mail_support(msg=""):
email_addr = db_name +"*****@*****.**"
content = "---------------------------------------\n"
content = content + msg + '\n\n'
for x in [ 'REQUEST_URI','HTTP_USER_AGENT','REMOTE_ADDR',
'HTTP_FROM','REMOTE_HOST','REMOTE_PORT',
'SERVER_SOFTWARE','HTTP_REFERER','REMOTE_IDENT',
'REMOTE_USER','QUERY_STRING','DATE_LOCAL' ]:
if os.environ.has_key(x):
line = "%s: %s\n" % (x, os.environ[x])
content = content + line
content = content + "---------------------------------------\n"
db_label=string.upper(db_name)
if db_label=="SAVE":
db_label="IFCS"
elif db_label=="BUAV":
db_label="FCST"
elif db_label=="CUAB":
db_label="PADV"
subject="%s Documentation Maintenance Report" % db_label
pmt_utils.send_email('www.linuxden.com',
email_addr,[email_addr],
subject,content)
def mail_support(msg=""):
email=db_name + "*****@*****.**" # where to email reports
#email="*****@*****.**"
content = "---------------------------------------\n"
content = content + msg + '\n\n'
for x in [ 'REQUEST_URI','HTTP_USER_AGENT','REMOTE_ADDR','HTTP_FROM',
'REMOTE_HOST','REMOTE_PORT','SERVER_SOFTWARE','HTTP_REFERER',
'REMOTE_IDENT','REMOTE_USER','QUERY_STRING','DATE_LOCAL' ]:
if os.environ.has_key(x):
line = "%s: %s\n" % (x, os.environ[x])
content = content + line
content = content + "---------------------------------------\n"
db_label=string.upper(db_name)
if db_label=="SAVE":
db_label="IFCS"
elif db_label=="BUAV":
db_label="FCST"
elif db_label=="CUAB":
db_label="PADV"
subject="%s Upload Report" % db_label
pmt_utils.send_email('www.isrparc.org',email,[email],subject,content)
def mail_support(msg=""):
if email:
content = "---------------------------------------\n"
content = content + msg + '\n\n'
for x in [
'REQUEST_URI', 'HTTP_USER_AGENT', 'REMOTE_ADDR', 'HTTP_FROM',
'REMOTE_HOST', 'REMOTE_PORT', 'SERVER_SOFTWARE',
'HTTP_REFERER', 'REMOTE_IDENT', 'REMOTE_USER', 'QUERY_STRING',
'DATE_LOCAL'
]:
if os.environ.has_key(x):
line = "%s: %s\n" % (x, os.environ[x])
content = content + line
content = content + "---------------------------------------\n"
pmt_utils.send_email('www.isrparc.org', email, [email],
"Clean Site Report", content)
def sendEmail():
content = urllib.unquote(form['content'].value)
if form.has_key('comments'):
content = form['comments'].value + '\n\n' + content
for key in form.keys():
if (key == 'to_box' or key == 'subject') and form[key].value == '':
print "Please specify and subject and recipient"
if form.has_key('table'):
print '<form method=post>'
print '<input type=hidden name=table '
print 'value="%s">' % form['table'].value
print '<input type=hidden name=key '
print 'value="%s">' % form['key'].value
elif form.has_key('project'):
print '<form method=post>'
print '<input type=hidden name=project '
print 'value="%s">' % form['project'].value
print '<input type=hidden name=fullpath '
print 'value="%s">' % form['fullpath'].value
print '<input type=hidden name=name '
print 'value="%s">' % form['name'].value
print '<input type=hidden name=username '
print 'value="%s">' % username
link = '/%s-cgi-bin/email.pyc' % declarations.pmt_info['db_name']
print '<HR><input type=submit name=send value="Back" '
print 'onClick="return goto_url(' + "'" + link + "'" + ')">'
print '</form>'
sys.exit()
pmt_utils.send_email('localhost', form['from_box'].value,
[form['to_box'].value], form['subject'].value,
content)
print 'An email has been sent to %s<hr>' % form['to_box'].value
def doSave():
status,table_data,db=pageInit('Save',formJS=1)
if status != 'success':
message="Could not connect to db.\n%s" % status
exit(message)
create='false'
if form["key_id"].value == 'create':
create='true'
# check for duplicate username
sql="select id from project_members "
sql=sql+"where member_username='******'" % form['member_username'].value
dupResult=pmt_utils.executeSQL(db,sql)
if len(dupResult['result'])!=0:
msg="The specified username '%s' "% form['member_username'].value
msg=msg+'is already in use.'
exit(msg)
# update the member id
sql="SELECT NEXTVAL('project_members_id_seq')"
queryResult = pmt_utils.executeSQL(db, sql)
if queryResult['status']!='success':
message="Unable to retrieve project member id"
exit(message,table_data,db)
form["key_id"].value = `queryResult['result'][0]['nextval']`
form['id'].value=form['key_id'].value
# save member data to project_members table in db
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="Project member could not be saved.\n" + dbResult['message']
exit(message,table_data,db)
# save privileges to privileges table in db
whereStr=" WHERE member_username='******'" % form["member_username"].value
dbResult = pmt_utils.saveForm(table_data, db,
form['member_username'].value,
"priviledges",
whereStr,
form)
if dbResult['status'] != 'success':
message="Unable to save member privileges.\n%s" % dbResult['message']
exit(message,table_data,db)
# Display the user information
table_data = pmt_utils.formToTableData(table_data,
'project_members',
form, form['key_id'].value)
pmt_utils.display_form(table_data,'project_members',1,'useValues',1,db)
# Display the user's privileges
sql = "select * from priviledges "
sql=sql+"where member_username='******'" % (form['member_username'].value)
dbResult = pmt_utils.executeSQL(db, sql)
if dbResult['status'] != 'success':
message="Could not get member privileges.\n%s" % dbResult['message']
exit(message)
result = dbResult['result']
table_data = pmt_utils.dbToTableData(table_data, 'priviledges', result[0])
displayPriviledges(result[0], table_data)
pmt_utils.alertsArea(form,"Project member successfully saved")
# if create=='true':
# Add the username and password to the .passwd file or htaccess
command='/usr/bin/htpasswd -b '
command=command+'/var/www/admin/%s.passwd ' % db_name
#NOTE : Use the form data here since an admin's cookie is logged in
command=command+'%s ' % form['member_username'].value
command=command+'%s' % form['member_password'].value
status, output = commands.getstatusoutput(command)
if create=='true':
# Send an email to the new user
db_label=string.upper(db_name)
if db_label=='SAVE':
db_label="IFCS"
if db_label=="BUAV":
db_label="FCST"
if db_label=="CUAV":
db_label="PADV"
msg="A new user account has been created for you "
msg=msg+"on the %s site at www.isrparc.org.\n\n"%string.upper(db_label)
#NOTE : Use the form data here since an admin's cookie is logged in
msg=msg+"Username: %s\n" % form['member_username'].value
msg=msg+"Password: %s" % form['member_password'].value
pmt_utils.send_email('localhost',
'*****@*****.**',
[form['email'].value],
"New User Account",
msg)
# 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.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)
print '{'
print ' if (! (window.focus && window.opener))return true;'
print ' window.opener.focus();'
print ' window.close();'
print ' if (opener.top.location != opener.location) {'
print ' opener.location.reload();}'
print ' return false;'
print '}'
print '//-->'
print '</SCRIPT>'
print '</head>'
pmt_utils.bodySetup()
if form.has_key('dest') and not form.has_key('name'):
showForm()
if form.has_key('name'):
if validate() == 'true':
addLink()
to_addr = "*****@*****.**" % db_name
msg = 'The link "%s" has been uploaded' % (form['name'].value)
msg = msg + ' to the %s site.' % (db_name)
pmt_utils.send_email('localhost', '*****@*****.**', [to_addr],
'Link uploaded', msg)
else:
showForm()
print '<br><font color=red>'
print '<b>All fields are required.</b></font>'
print '</body></html>'
#------------------------------------------------------------------------------