def main(): # Arguments: form = cgi.FieldStorage() sn = cgi.escape(form.getvalue('serial_num')) # This is coming from a form. cardid = cgi.escape(form.getvalue('card_id')) person_id = base.cleanCGInumber(form.getvalue('person_id')) db = settings.get_db() note = cgi.escape(form.getvalue('note')) if form.getvalue('note') else False # base.begin() # print person_id # print note # base.bottom() if not person_id: base.error(db, "You must select a tester to be associated with this note.") else: if not note: base.error(db, "You left the note field empty. You're not allowed to make an empty note.") else: # Begin: base.begin() base.header_redirect("module.py?db={0}&card_id={1}#notes".format(db, cardid)) base.top(db) # Add note: result = add_note(db, sn, note, person_id) if result: print "added note:<br>" print note # base.header_redirect_module_notes(card_id, serial_num) base.bottom()
def main(): # Arguments form = cgi.FieldStorage() cardid = base.cleanCGInumber(form.getvalue('card_id')) suggested_test = base.cleanCGInumber(form.getvalue('suggested')) db = settings.get_db() sn = module.fetch_sn_from_cardid(db, cardid) # Basic: base.begin() base.header(title='{0}: test'.format(db)) base.top(db) # Test form: print_test_form(db, cardid, sn, suggested_test) base.bottom()
def main(): # Arguments: form = cgi.FieldStorage() person_id = base.cleanCGInumber(form.getvalue("person_id")) test_type = base.cleanCGInumber(form.getvalue("test_type")) card_id = base.cleanCGInumber(form.getvalue("card_id")) success = (False, True)[bool(form.getvalue("success"))] db = settings.get_db() ## Comments: comments = form.getvalue("comments") if comments: comments = cgi.escape(comments) if person_id != 0: # Basic: base.begin() base.header_redirect("module.py?db={0}&card_id={1}".format(db, card_id)) base.top(db) # Add the test to the DB: test_id = add_test_basic(db, person_id, test_type, card_id, success, comments) ## Attachments: for i in range(1, 4): afile = form['attach{0}'.format(i)] if (afile.filename): adesc= form.getvalue("attachdesc{0}".format(i)) if adesc: adesc = cgi.escape(adesc) acomment= form.getvalue("attachcomment{0}".format(i)) if acomment: acomment = cgi.escape(acomment) add_test_attachment(db, test_id, afile, adesc, acomment) base.bottom() else: base.error(db, "You must select a tester from the available list.") else: base.error(db, "You must input comments before the test can be added.")
def main(): # Arguments: form = cgi.FieldStorage() cardid = base.cleanCGInumber(form.getvalue('card_id')) db = settings.get_db() # Basic: base.begin() base.header(title='{0}: module'.format(db)) base.top(db) # Form: print_form(db, cardid) base.bottom()
def main(): # Arguments: form = cgi.FieldStorage() test_id = base.cleanCGInumber(form.getvalue('test_id')) comment = form.getvalue('comment') db = settings.get_db() card_id = test.fetch_cardid_from_testid(db, test_id) testtype_id = test.fetch_testtypeid_from_testid(db, test_id) # Revoke: revoke_test(db, test_id, revoke=True, comment=comment) # Basic: base.begin() # base.header(title='{0}: revoke'.format(db)) base.header_redirect("module.py?db={0}&card_id={1}#test-{2}".format(db, card_id, testtype_id)) base.top(db) base.bottom()
#!/usr/bin/python import cgi import base import home_page_list import module_functions from connect import connect # cgi header print "Content-type: text/html\n" form = cgi.FieldStorage() card_id = base.cleanCGInumber(form.getvalue("card_id")) serial_num = base.cleanCGInumber(form.getvalue("serial_num")) base.header(title="uHTR ePortage") base.top() # print 'card_id = ', card_id # print 'serial_num = ', serial_num module_functions.add_test_tab(serial_num, card_id) revokes = module_functions.Portage_fetch_revokes(serial_num) db = connect(0) cur = db.cursor() cur.execute("select test_type, name from Test_Type where required = 1 order by relative_order ASC") for test_type in cur: module_functions.ePortageTest(test_type[0], serial_num, test_type[1], revokes)
#!/usr/bin/python import cgi import base import home_page_list import exportCard_functions #cgi header print "Content-type: text/html\n" form = cgi.FieldStorage() #card_id = form.getvalue('card_id') serial_num = base.cleanCGInumber(form.getvalue('serial_num')) base.header(title='Exporting Card: {0}'.format(serial_num)) base.top() exportCard_functions.export(serial_num) base.bottom()
#!/usr/bin/python import cgi import base import home_page_list import add_test_functions #cgi header print "Content-type: text/html\n" form = cgi.FieldStorage() #card_id = form.getvalue('card_id') serial_num = base.cleanCGInumber(form.getvalue('serial_num')) suggested_test = base.cleanCGInumber(form.getvalue('suggested')) base.header(title='Add Test') base.top() add_test_functions.add_test_template(serial_num,suggested_test) base.bottom()
#!/usr/bin/python import cgi import base import home_page_list #import add_test_functions #cgi header print "Content-type: text/html\n" form = cgi.FieldStorage() test_id = base.cleanCGInumber(form.getvalue('test_id')) #suggested_test = base.cleanCGInumber(form.getvalue('suggested')) base.header(title='Revoke Success') base.top() print '<br><br>' print 'Revoking test %i from list of valid tests'%test_id print 'Please add any comments about why the test is being revoked:' print '<form action="revokeFormHandler.py" method="post" enctype="multipart/form-data">' print ' <input type="hidden" name="test_id" value=%i>'%test_id print ' <br><br>' print ' <textarea rows="5" cols="100" name="comments"></textarea>' print ' <br><br>' print ' <input type="submit" value="Revoke">' print '</form>' base.bottom()
#!/usr/bin/python import cgi import base import home_page_list import module_functions from connect import connect #cgi header print "Content-type: text/html\n" form = cgi.FieldStorage() card_id = base.cleanCGInumber(form.getvalue('card_id')) serial_num = base.cleanCGInumber(form.getvalue('serial_num')) base.header(title='ngCCM ePortage') base.top() #print 'card_id = ', card_id #print 'serial_num = ', serial_num module_functions.add_test_tab(serial_num, card_id) revokes=module_functions.Portage_fetch_revokes(serial_num) db = connect(0) cur = db.cursor() cur.execute("select test_type, name , desc_long from Test_Type where required = 1 order by relative_order ASC") for test_type in cur: module_functions.ePortageTest(test_type[0], serial_num, test_type[1], revokes, test_type[2])
#!/usr/bin/python import cgi import base import home_page_list import module_functions from connect import connect #cgi header print "Content-type: text/html\n" form = cgi.FieldStorage() card_id = base.cleanCGInumber(form.getvalue('card_id')) serial_num = base.cleanCGInumber(form.getvalue('serial_num')) base.header(title='QIE card ePortage') base.top() #print 'card_id = ', card_id #print 'serial_num = ', serial_num module_functions.add_test_tab(serial_num, card_id) revokes = module_functions.Portage_fetch_revokes(serial_num) db = connect(0) cur = db.cursor() cur.execute( "select test_type, name from Test_Type where required = 1 order by relative_order ASC" ) for test_type in cur: module_functions.ePortageTest(test_type[0], serial_num, test_type[1], revokes)
return not rows==[] def addTestToRevokeList( test_id ) : db = connect(1) cur = db.cursor() cur.execute("INSERT INTO TestRevoke SET test_id=%i,comment='%s'"%(test_id,comments)) db.commit() #cgi header print "Content-type: text/html\n" form = cgi.FieldStorage() test_id = base.cleanCGInumber(form.getvalue("test_id")) comments = form.getvalue("comments") base.header(title='Revoke') base.top() print '<br><br>' if not inRevokeList( test_id ) : addTestToRevokeList( test_id ) print 'Done' else : print 'Test already revoked...' base.bottom()
#!/usr/bin/python import cgi import base import module_functions from connect import connect import settings import os.path import sys form = cgi.FieldStorage() attach_id = base.cleanCGInumber(form.getvalue('attach_id')) db = connect(0) cur = db.cursor() cur.execute( "SELECT test_id, attachmime, originalname FROM Attachments WHERE attach_id=%d" % (attach_id)) if not cur.with_rows: print "Content-type: text/html\n" base.header("Attachment Request Error") base.top() print "<h1>Attachment not available</h1>" base.bottom() else: thevals = cur.fetchall() attpath = settings.getAttachmentPathFor(thevals[0][0], attach_id) if not os.path.isfile(attpath): print "Content-type: text/html\n"
#!/usr/bin/python import cgi import base import add_test_functions #cgi header print "Content-type: text/html\n" form = cgi.FieldStorage() person_id = base.cleanCGInumber(form.getvalue("person_id")) test_type = base.cleanCGInumber(form.getvalue("test_type")) serial_num = base.cleanCGInumber(form.getvalue("serial_number")) success = base.cleanCGInumber(form.getvalue("success")) comments = form.getvalue("comments") if comments: comments = cgi.escape(comments) base.header(title='Add Test') base.top() test_id = add_test_functions.add_test(person_id, test_type, serial_num, success, comments) for itest in (1, 2, 3): afile = form['attach%d' % (itest)] if (afile.filename): adesc = form.getvalue("attachdesc%d" % (itest)) if adesc: adesc = cgi.escape(adesc)
#!/usr/bin/python import cgi import base import add_test_functions # cgi header print "Content-type: text/html\n" form = cgi.FieldStorage() person_id = base.cleanCGInumber(form.getvalue("person_id")) test_type = base.cleanCGInumber(form.getvalue("test_type")) serial_num = base.cleanCGInumber(form.getvalue("serial_number")) success = base.cleanCGInumber(form.getvalue("success")) comments = form.getvalue("comments") if comments: comments = cgi.escape(comments) base.header(title="Add Test") base.top() test_id = add_test_functions.add_test(person_id, test_type, serial_num, success, comments) for itest in (1, 2, 3): afile = form["attach%d" % (itest)] if afile.filename: adesc = form.getvalue("attachdesc%d" % (itest)) if adesc: adesc = cgi.escape(adesc) acomment = form.getvalue("attachcomment%d" % (itest))
#!/usr/bin/python import cgi import base import module_functions from connect import connect import settings import os.path import sys form = cgi.FieldStorage() attach_id = base.cleanCGInumber(form.getvalue('attach_id')) db=connect(0) cur=db.cursor() cur.execute("SELECT test_id, attachmime, originalname FROM Attachments WHERE attach_id=%d" % (attach_id)); if not cur.with_rows: print "Content-type: text/html\n" base.header("Attachment Request Error") base.top() print "<h1>Attachment not available</h1>" base.bottom() else: thevals=cur.fetchall(); attpath=settings.getAttachmentPathFor(thevals[0][0],attach_id) if not os.path.isfile(attpath): print "Content-type: text/html\n" print print attpath
def addTestToRevokeList(test_id): db = connect(1) cur = db.cursor() cur.execute("INSERT INTO TestRevoke SET test_id=%i,comment='%s'" % (test_id, comments)) db.commit() #cgi header print "Content-type: text/html\n" form = cgi.FieldStorage() test_id = base.cleanCGInumber(form.getvalue("test_id")) comments = form.getvalue("comments") base.header(title='Revoke') base.top() print '<br><br>' if not inRevokeList(test_id): addTestToRevokeList(test_id) print 'Done' else: print 'Test already revoked...' base.bottom()