def query_properties(performDbQuery=0, onLoad=None, queryFields=None): table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.javaScript("view_properties", 1) ecommerce.title("Property Listing") print "</HEAD>" ecommerce.bodySetup(onLoad) print '<CENTER>' print '<TABLE COLS=1 WIDTH=585>' print '<TR><TD>' ecommerce.mainHeading('Property Listing') ecommerce.subHeading('View Properties') ecommerce.formSetup("view_properties", "view_properties", "return submitForm(document.view_properties)", declarations.store_info['db_name']) if form.has_key("performDbQuery") or performDbQuery == 1: dbResult = ecommerce.connectDB( declarations.store_info['browser_username'], declarations.store_info['browser_password'], declarations.store_info['db_name']) # could not connect to db if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Can not connect to database,\n" + dbResult['message']) # connected to db ecommerce.queryFunctionButtons( 0, declarations.store_info['help_file']) else: db = dbResult['result'] queryFields, whereFields = ecommerce.getQueryWhereFields( form, table_data, 'properties') if queryFields == None or queryFields == []: queryFields = [] whereFields = None queryFields.append('town') queryFields.append('price') queryFields.append('square_footage') dbResult, queryStatement = ecommerce.executeQuery( db, table_data, 'properties', queryFields, whereFields, 'query', ecommerce.viewPropertiesFunctionsHtml, 'ORDER BY id', 'id', "display_property = 't'", ['order_id', 'customer_id', 'display_property', 'image']) # if query was not successful if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Could not retrieve properties from database,\n" + dbResult['message']) # else properties were retrieved ok else: ecommerce.alertsArea( form, "Last Query Statement: " + queryStatement + "\n" + ` len(dbResult['result']) ` + " properties retrieved from database") ecommerce.viewPropertiesFunctionButtons( declarations.store_info['help_file']) else: ecommerce.viewPropertiesFunctionButtons( declarations.store_info['help_file']) ecommerce.viewPropertiesHiddenFields( declarations.store_info['browser_username'], declarations.store_info['browser_password']) print "</FORM>" try: ecommerce.trailer(table_data, db) db.close() except NameError: pass print '</TD>' print '</TR>' print '</TABLE>' print '</CENTER>' print "</BODY>" print "</HTML>" if form.has_key("performDbQuery") or performDbQuery == 1: return dbResult else: return { 'status': 'success', 'message': 'query successful', 'result': 0 }
'default' : '0', \ 'display' : 'editable', \ 'value' : '', \ 'display_order' : 2, \ 'validation_routine' : 'valid_integer', \ 'validation_arguments' : ['form.add_quantity',"''","'Quantity to Add'","false"], \ 'leaveFocus' : "checkBlankField(this, 'Quantity')", \ 'gainFocus' : "displayHint('Enter the quantity of product to add')", \ 'format' : "####" \ } ecommerce.generate_form_javascript(table_data,'orders','order_admin',0) table_data = declarations.define_tables() ecommerce.title("Order Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Order Administration') ecommerce.subHeading('Edit Order') ecommerce.formSetup("order_admin","order_admin","return submitForm(document.order_admin)",declarations.store_info['db_name']) sqlStatement = ecommerce.selectAllColumnsSqlStatement(table_data,'orders',form["key_id"].value) dbResult = ecommerce.executeSQL(db, sqlStatement)
return {'status' : 'success', 'message' : 'query successful', 'result' : 0} form = ecommerce.getFormData() if form.has_key("action"): if form["action"].value == "edit": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.generate_form_javascript(table_data,'order_status_values','order_status_values_admin',0,0) ecommerce.title("Order Status Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Order Status Administration') ecommerce.subHeading('Edit Order Statuss') ecommerce.formSetup("order_status_values_admin","order_status_values_admin","return submitForm(document.order_status_values_admin)",declarations.store_info['db_name']) dbResult = ecommerce.connectDB(form["uHidden"].value, form["pHidden"].value,declarations.store_info['db_name']) if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not connect to the database\n" + dbResult['message']);
if form["action"].value == "query": query_properties(1) # view button pressed elif form["action"].value == "view": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.javaScript("view_properties") ecommerce.title("View Property Listing Id " + form['key_id'].value) print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Property Listing') ecommerce.subHeading('Property Ad: ' + form['key_id'].value) ecommerce.formSetup("view_properties", "view_properties", "return submitForm(document.view_properties)", declarations.store_info['db_name']) # attempt to connect to db dbResult = ecommerce.connectDB(form["uHidden"].value,
def edit_store_info(performDbQuery=0, onLoad=None, queryFields=None): table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.javaScript("store_admin", 1) ecommerce.title("Store Administration") print "</HEAD>" ecommerce.bodySetup(onLoad) ecommerce.mainHeading('Store Administration') ecommerce.subHeading('Store Info') ecommerce.formSetup("store_admin", "store_admin", "return submitForm(document.store_admin)", declarations.store_info['db_name']) if form.has_key("username"): username = form["username"].value else: if form.has_key("uHidden"): username = form["uHidden"].value else: username = '' if form.has_key("password"): password = form["password"].value else: if form.has_key("pHidden"): password = form["pHidden"].value else: password = '' ecommerce.usernamePasswordDisplay(username, password) if form.has_key("performDbQuery") or performDbQuery == 1: dbResult = ecommerce.connectDB(username, password, declarations.store_info['db_name']) # could not connect to db if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Can not connect to database,\n" + dbResult['message']) # connected to db storeButtons() else: db = dbResult['result'] sqlStatement = ecommerce.selectAllColumnsSqlStatement( table_data, 'store_info', form["key_id"].value) dbResult = ecommerce.executeSQL(db, sqlStatement) if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Could not retrieve store information\n" + dbResult['message']) else: result = dbResult['result'] table_data = ecommerce.dbToTableData(table_data, 'store_info', result[0]) ecommerce.table_data['store_info']['id']['value'] = '1' ecommerce.display_form(table_data, 'store_info', 1, 'useValues', 1, db) ecommerce.alertsArea( form, "Store Information retrieved successfully") storeButtons(button_name='save') ecommerce.editHiddenFields(form["uHidden"].value, form["pHidden"].value) else: storeButtons(button_name='edit') ecommerce.editHiddenFields(username, password, '1') print "</FORM>" try: ecommerce.trailer(table_data, db) db.close() except NameError: pass print "</BODY>" print "</HTML>" if form.has_key("performDbQuery") or performDbQuery == 1: return dbResult else: return { 'status': 'success', 'message': 'query successful', 'result': 0 }
return {'status' : 'success', 'message' : 'query successful', 'result' : 0} form = ecommerce.getFormData() if form.has_key("action"): if form["action"].value == "edit": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.generate_form_javascript(table_data,'shipping_methods','shipping_methods_admin',0,0) ecommerce.title("Shipping Methods Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Shipping Methods Administration') ecommerce.subHeading('Edit Shipping Methods') ecommerce.formSetup("shipping_methods_admin","shipping_methods_admin","return submitForm(document.shipping_methods_admin)",declarations.store_info['db_name']) dbResult = ecommerce.connectDB(form["uHidden"].value, form["pHidden"].value,declarations.store_info['db_name']) if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not connect to the database\n" + dbResult['message']);
form = ecommerce.getFormData() if form.has_key("action"): if form["action"].value == "edit": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.generate_form_javascript(table_data, 'products', 'product_admin', 0, 0) ecommerce.title("Product Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Product Administration') ecommerce.subHeading('Edit Product') ecommerce.formSetup("product_admin", "product_admin", "return submitForm(document.product_admin)", declarations.store_info['db_name']) dbResult = ecommerce.connectDB(form["uHidden"].value, form["pHidden"].value,
return {'status' : 'success', 'message' : 'query successful', 'result' : 0} form = ecommerce.getFormData() if form.has_key("action"): if form["action"].value == "edit": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.generate_form_javascript(table_data,'product_categories','product_categories_admin',0,0) ecommerce.title("Product Categories Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Product Categories Administration') ecommerce.subHeading('Edit Product Categories Values') ecommerce.formSetup("product_categories_admin","product_categories_admin","return submitForm(document.product_categories_admin)",declarations.store_info['db_name']) dbResult = ecommerce.connectDB(form["uHidden"].value, form["pHidden"].value,declarations.store_info['db_name']) if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not connect to the database\n" + dbResult['message']);
form = ecommerce.getFormData() if form.has_key("action"): if form["action"].value == "edit": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.generate_form_javascript(table_data, 'properties', 'property_admin', 0, 0) ecommerce.title("Property Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Property Administration') ecommerce.subHeading('Edit Property') ecommerce.formSetup("property_admin", "property_admin", "return submitForm(document.property_admin)", declarations.store_info['db_name']) dbResult = ecommerce.connectDB(form["uHidden"].value, form["pHidden"].value,
return {'status' : 'success', 'message' : 'query successful', 'result' : 0} form = ecommerce.getFormData() if form.has_key("action"): if form["action"].value == "edit": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.generate_form_javascript(table_data,'market_status_values','market_status_values_admin',0,0) ecommerce.title("Market Status Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Market Status Administration') ecommerce.subHeading('Edit Market Status Values') ecommerce.formSetup("market_status_values_admin","market_status_values_admin","return submitForm(document.market_status_values_admin)",declarations.store_info['db_name']) dbResult = ecommerce.connectDB(form["uHidden"].value, form["pHidden"].value,declarations.store_info['db_name']) if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not connect to the database\n" + dbResult['message']);
def display_form(display_files=0,alerts=None): print "<HTML>" print "<HEAD>" ecommerce.title("Site Maintenance (Clean)") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Site Maintenance') ecommerce.subHeading('Clean') ecommerce.formSetup("clean_site","clean_site",None,declarations.store_info['db_name']) if not display_files: print '<TABLE BORDER=0><TR><TD><B>Website Name</B>:</TD><TD><input name="website_name" type="text" size="50" maxlength="50"></TD></TR><TR><TD><B>Username</B>:</TD><TD><input name="username" type="text" size="9" maxlength="9"></TD></TR><TR><TD><B>Password:</B></TD><TD><input name="password" type="password" size="8" maxlength="8"></TD></TR></TABLE>' if display_files: if form.has_key('website_name'): website_value = form['website_name'].value else: website_value = form['website_name_hidden'].value os.chdir(os.path.join('/home',string.lower(string.strip(website_value)))) file_list = os_utils.walk_list_files( directory_name='.', list_only_files=0, exclude_list = dir_exclusions, include_file_type=1) if len(file_list) > 25: list_size = 25 else: list_size = len(file_list) print """ <CENTER> <TABLE BORDER=0> <CAPTION><BLINK><B>WARNING:<B></BLINK></CAPTION> <TR><TD WIDTH=300> Any files that you select for deletion are permanently deleted. You should have a local backup of any files you delete in case you really did not mean to delete. Backups are crucial. You have been warned. <p>Selecting a directory will delete the directory and all files under it including subdirectories. Select directory names with caution. <p>Your deletes will not be confirmed. When you press [Delete Selected Files] your files are deleted.</TD></TR></TABLE> """ print '<BR><CENTER><B>Select files to delete</B>:<BR><SELECT NAME="files_to_remove" SIZE="%d" MULTIPLE>' % (list_size) for curfile in file_list: print '<OPTION>%s' % (curfile) print "</SELECT><BR>" if alerts != None: ecommerce.alertsArea(form,alerts) print '</CENTER>' print """ <CENTER> <HR> """ if display_files: print '<input name="submit" type="submit" value="Delete Selected Files">' else: print '<input name="submit" type="submit" value="Login">' print '</CENTER>' if display_files: if form.has_key('website_name'): print '<input name ="website_name_hidden" type="hidden" value="%s">' % (form['website_name'].value) else: print '<input name ="website_name_hidden" type="hidden" value="%s">' % (form['website_name_hidden'].value) print """
def query_properties(performDbQuery=0, onLoad=None, queryFields=None): table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.javaScript("customer_property_admin", 1) ecommerce.title("Customer Property Administration") print "</HEAD>" ecommerce.bodySetup(onLoad) print '<CENTER>' print '<TABLE COLS=1 WIDTH=585>' print '<TR><TD>' ecommerce.mainHeading('Customer Property Administration') ecommerce.subHeading('Property Listing') ecommerce.formSetup("customer_property_admin", "customer_property_admin", "return submitForm(document.customer_property_admin)", declarations.store_info['db_name']) if form.has_key("customer_id"): customer_id = form["customer_id"].value else: if form.has_key("cHidden"): customer_id = form["cHidden"].value else: customer_id = '' if form.has_key("username"): username = form["username"].value else: if form.has_key("uHidden"): username = form["uHidden"].value else: username = '' if form.has_key("password"): password = form["password"].value else: if form.has_key("pHidden"): password = form["pHidden"].value else: password = '' print '<TABLE><BORDER=0>' print '<TR>' ecommerce.tableColumn('<B>Customer ID:</B>') print '<TD ALIGN=CENTER NOWRAP>' ecommerce.textbox(None, 'customer_id', customer_id, '10', '10', "checkBlankField(this, 'Customer ID')", "displayHint('Enter your customer id')") print '</TD>' ecommerce.tableColumn('<B>Username:</B>') print '<TD ALIGN=CENTER NOWRAP>' ecommerce.textbox(None, 'username', username, '9', '9', "checkBlankField(this, 'Username')", "displayHint('Enter your username')") print '</TD>' ecommerce.tableColumn('<B>Password:</B>') print '<TD ALIGN=CENTER NOWRAP>' ecommerce.textbox(None, 'password', password, '8', '8', "checkBlankField(this, 'Password')", "displayHint('Enter your password')", 'password') print '</TD>' print '</TR>' print '</TABLE>' if form.has_key("performDbQuery") or performDbQuery == 1: dbResult = ecommerce.connectDB( declarations.store_info['browser_username'], declarations.store_info['browser_password'], declarations.store_info['db_name']) # could not connect to db if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Can not connect to database,\n" + dbResult['message']) print '<HR>' print '<TABLE>' print '<TR>' ecommerce.tableColumn( '<INPUT NAME="query" type="button" value=" Query " onClick="return execute(' + "'query'" + ')">') ecommerce.tableColumn( '<INPUT TYPE="button" NAME="help" VALUE=" Help " onClick="return goto_url (' + "'" + help_pdf + "'" + ')">') print '</TR>' print '</TABLE>' else: db = dbResult['result'] # validate username password and customer id dbResult = ecommerce.executeSQL( db, "SELECT count(*) FROM customers WHERE id = '" + string.strip(customer_id) + "' AND account_username = '******' AND account_password = '******'") if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Could not validate customer information provided\n" + dbResult['message']) ecommerce.textbox(None, 'key_id', '', '10', '10', None, None, 'hidden') ecommerce.textbox(None, 'action', '', '10', '10', None, None, 'hidden') ecommerce.textbox(None, 'cHidden', customer_id, '10', '10', None, None, 'hidden') ecommerce.textbox(None, 'uHidden', username, '9', '9', None, None, 'hidden') ecommerce.textbox(None, 'pHidden', password, '8', '8', None, None, 'hidden') print "</FORM>" ecommerce.trailer(table_data, db) print '</TD>' print '</TR>' print '</TABLE>' print '</CENTER>' print "</BODY>" print "</HTML>" else: result = dbResult['result'] if result[0]['count'] != 1: ecommerce.alertsArea( form, "Could not validate customer information provided\n" + dbResult['message']) print '<HR>' print '<TABLE>' print '<TR>' ecommerce.tableColumn( '<INPUT NAME="query" type="button" value=" Query " onClick="return execute(' + "'query'" + ')">') ecommerce.tableColumn( '<INPUT TYPE="button" NAME="help" VALUE=" Help " onClick="return goto_url (' + "'" + help_pdf + "'" + ')">') print '</TR>' print '</TABLE>' ecommerce.textbox(None, 'key_id', '', '10', '10', None, None, 'hidden') ecommerce.textbox(None, 'action', '', '10', '10', None, None, 'hidden') ecommerce.textbox(None, 'cHidden', customer_id, '10', '10', None, None, 'hidden') ecommerce.textbox(None, 'uHidden', username, '9', '9', None, None, 'hidden') ecommerce.textbox(None, 'pHidden', password, '8', '8', None, None, 'hidden') print "</FORM>" ecommerce.trailer(table_data, db) print '</TD>' print '</TR>' print '</TABLE>' print '</CENTER>' print "</BODY>" print "</HTML>" sys.exit(1) queryFields, whereFields = ecommerce.getQueryWhereFields( form, table_data, 'properties') if queryFields == None or queryFields == []: queryFields = [] whereFields = None queryFields.append('id') queryFields.append('town') queryFields.append('style') queryFields.append('bedrooms') queryFields.append('price') dbResult, queryStatement = ecommerce.executeQuery( db, table_data, 'properties', queryFields, whereFields, 'query', queryCustomerItemHtml, 'ORDER BY id', 'id', "customer_id='" + customer_id + "' and display_property = 't'") # if query was not successful if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Could not retrieve properties from database,\n" + dbResult['message']) # else properties were retrieved ok else: ecommerce.alertsArea( form, "Last Query Statement: " + queryStatement + "\n" + ` len(dbResult['result']) ` + " properties retrieved from database") print '<HR>' print '<TABLE>' print '<TR>' ecommerce.tableColumn( '<INPUT NAME="query" type="button" value=" Query " onClick="return execute(' + "'query'" + ')">') ecommerce.tableColumn( '<INPUT TYPE="button" NAME="help" VALUE=" Help " onClick="return goto_url (' + "'" + help_pdf + "'" + ')">') print '</TR>' print '</TABLE>' else: print '<HR>' print '<TABLE>' print '<TR>' ecommerce.tableColumn( '<INPUT NAME="query" type="button" value=" Query " onClick="return execute(' + "'query'" + ')">') ecommerce.tableColumn( '<INPUT TYPE="button" NAME="help" VALUE=" Help " onClick="return goto_url (' + "'" + help_pdf + "'" + ')">') print '</TR>' print '</TABLE>' ecommerce.textbox(None, 'key_id', '', '10', '10', None, None, 'hidden') ecommerce.textbox(None, 'action', '', '10', '10', None, None, 'hidden') ecommerce.textbox(None, 'cHidden', customer_id, '10', '10', None, None, 'hidden') ecommerce.textbox(None, 'uHidden', username, '9', '9', None, None, 'hidden') ecommerce.textbox(None, 'pHidden', password, '8', '8', None, None, 'hidden') print "</FORM>" try: ecommerce.trailer(table_data, db) db.close() except NameError: pass print '</TD>' print '</TR>' print '</TABLE>' print '</CENTER>' print "</BODY>" print "</HTML>" if form.has_key("performDbQuery") or performDbQuery == 1: return dbResult else: return { 'status': 'success', 'message': 'query successful', 'result': 0 }
if form["action"].value == "edit": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" table_data['properties']['customer_id']['display'] = 'read-only' table_data['properties']['order_id']['display'] = 'read-only' table_data['properties']['display_property']['display'] = 'Hidden' ecommerce.generate_form_javascript(table_data, 'properties', 'customer_property_admin', 0, 0) ecommerce.title("Customer Property Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Customer Property Administration') ecommerce.subHeading('Edit Property') ecommerce.formSetup( "customer_property_admin", "customer_property_admin", "return submitForm(document.customer_property_admin)", declarations.store_info['db_name']) dbResult = ecommerce.connectDB(
def query_orders(performDbQuery=0, onLoad=None, queryFields=None): table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.javaScript("order_admin", 1) ecommerce.title("Order Administration") print "</HEAD>" ecommerce.bodySetup(onLoad) print '<CENTER>' print '<TABLE COLS=1 WIDTH=585>' print '<TR><TD>' ecommerce.mainHeading('Order Administration') ecommerce.subHeading('Order Listing') ecommerce.formSetup("order_admin","order_admin","return submitForm(document.order_admin)",declarations.store_info['db_name']) if form.has_key("username"): username = form["username"].value else: if form.has_key("uHidden"): username = form["uHidden"].value else: username = '' if form.has_key("password"): password = form["password"].value else: if form.has_key("pHidden"): password = form["pHidden"].value else: password = '' ecommerce.usernamePasswordDisplay(username, password) if form.has_key("performDbQuery") or performDbQuery == 1: dbResult = ecommerce.connectDB(username, password, declarations.store_info['db_name']) # could not connect to db if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Can not connect to database,\n" + dbResult['message']) # connected to db ecommerce.queryFunctionButtons(0, declarations.store_info['help_file']) else: db = dbResult['result'] # check to see if a query has been performed with at least one column queryFields, whereFields = ecommerce.getQueryWhereFields(form, table_data, 'orders') if queryFields == None or queryFields == []: queryFields = [] whereFields = None queryFields.append('id') queryFields.append('customer_id') queryFields.append('creation_date') queryFields.append('shipped_date') queryFields.append('total') dbResult, queryStatement = ecommerce.executeQuery(db, table_data, 'orders', queryFields, whereFields, 'query', ecommerce.queryItemFunctionsHtml) # if query was not successful if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Invalid query where clause specified,\n" + dbResult['message'] + '\nLast Query Statement: ' + queryStatement) # else orders were retrieved ok else: ecommerce.alertsArea(form, "Last Query Statement: " + queryStatement + "\n" + `len(dbResult['result'])` + " orders retrieved from database") ecommerce.queryFunctionButtons(1, declarations.store_info['help_file']) else: ecommerce.queryFunctionButtons(0, declarations.store_info['help_file']) ecommerce.queryHiddenFields(username, password) print "</FORM>" try: ecommerce.trailer(table_data, db) db.close() except NameError: pass print '</TD>' print '</TR>' print '</TABLE>' print '</CENTER>' print "</BODY>" print "</HTML>" if form.has_key("performDbQuery") or performDbQuery == 1: return dbResult else: return {'status' : 'success', 'message' : 'query successful', 'result' : 0}
def display_form(display_files=0,alerts=None): print "<HTML>" print "<HEAD>" ecommerce.title("Site Maintenance (Usage)") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Site Maintenance') ecommerce.subHeading('Usage') ecommerce.formSetup("site_usage","site_usage",None,declarations.store_info['db_name']) if not display_files: print '<TABLE BORDER=0><TR><TD><B>Website Name</B>:</TD><TD><input name="website_name" type="text" size="50" maxlength="50"></TD></TR><TR><TD><B>Username</B>:</TD><TD><input name="username" type="text" size="9" maxlength="9"></TD></TR><TR><TD><B>Password:</B></TD><TD><input name="password" type="password" size="8" maxlength="8"></TD></TR></TABLE>' if display_files: if form.has_key('website_name'): website_value = form['website_name'].value else: website_value = form['website_name_hidden'].value os.chdir(os.path.join('/home',string.lower(string.strip(website_value)))) file_list = os_utils.walk_list_files( directory_name='.', list_only_files=1, exclude_list = dir_exclusions, include_file_type=0, include_file_size=1) if len(file_list) > 25: list_size = 25 else: list_size = len(file_list) status, du = os_utils.disk_usage(os.path.join('/home',website_value)) if status == 'error': du_str = 'can not calculate file size' else: du_str = `du` print """ <CENTER> <TABLE BORDER=0> <CAPTION><B>Site Usage:<B></CAPTION> <TR><TD WIDTH=300> All file sizes are in bytes. The maximum amount of disk space allowed for your account is <B>%d</b> bytes. The disk space allotment includes hit counter and administrative runtime files as well as any ecommerce engines you may have installed. You are currently using <B>%s</b> bytes of your allowable disk space.""" % (upload_ceiling, du_str) if du > upload_ceiling: print '<p><B>You have exceeded the maximum disk space allotment for your website by <B>%d</b> bytes.' % (du - upload_ceiling) print '<p>Please remove files to lower your disk space usage or the monthly fee for your site will be increased.' print '<p>Contact <A HREF="mailto:[email protected]">clickTree Sales</A> for more information.</B>' mail_support('The site: ' + website_value + ' has exceeded their maximum disk space allotment of ' + `upload_ceiling` + ' bytes.\n' + 'The site is currently using ' + du_str + ' bytes of disk space\n' + 'The site has exceeded allotment allowed by ' + `du - upload_ceiling` + ' bytes.') else: print '<P>You have <B>%d</b> bytes of disk space left.' % (upload_ceiling - du) print '</TD></TR></TABLE>' print '<BR><CENTER><B>File Sizes</B>:<BR><SELECT NAME="file_sizes" SIZE="%d" MULTIPLE>' % (list_size) for curfile in file_list: print '<OPTION>%s' % (curfile) print "</SELECT><BR>" if alerts != None: ecommerce.alertsArea(form,alerts) print '</CENTER>' print """ <CENTER> <HR> """ if display_files: print '<input name="submit" type="submit" value="Refresh List">' else: print '<input name="submit" type="submit" value="Login">' print '</CENTER>' if display_files: if form.has_key('website_name'): print '<input name ="website_name_hidden" type="hidden" value="%s">' % (form['website_name'].value) else: print '<input name ="website_name_hidden" type="hidden" value="%s">' % (form['website_name_hidden'].value) print """
form = ecommerce.getFormData() if form.has_key("action"): if form["action"].value == "edit": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.generate_form_javascript(table_data, 'sales_tax_by_state', 'sales_tax_admin', 0, 0) ecommerce.title("Sales Tax Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Sales Tax Administration') ecommerce.subHeading('Edit Sales Tax Data') ecommerce.formSetup("sales_tax_admin", "sales_tax_admin", "return submitForm(document.sales_tax_admin)", declarations.store_info['db_name']) dbResult = ecommerce.connectDB(form["uHidden"].value, form["pHidden"].value,
return {'status' : 'success', 'message' : 'query successful', 'result' : 0} form = ecommerce.getFormData() if form.has_key("action"): if form["action"].value == "edit": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.generate_form_javascript(table_data,'payment_methods','payment_methods_admin',0,0) ecommerce.title("Payment Method Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Payment Method Administration') ecommerce.subHeading('Edit Payment Methods') ecommerce.formSetup("payment_methods_admin","payment_methods_admin","return submitForm(document.payment_methods_admin)",declarations.store_info['db_name']) dbResult = ecommerce.connectDB(form["uHidden"].value, form["pHidden"].value,declarations.store_info['db_name']) if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not connect to the database\n" + dbResult['message']);
def query_product_categories(performDbQuery=0, onLoad=None, queryFields=None): table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.javaScript("product_categories_admin", 1) ecommerce.title("Product Categories Administration") print "</HEAD>" ecommerce.bodySetup(onLoad) ecommerce.mainHeading('Product Categories Administration') ecommerce.subHeading('Product Category Values') ecommerce.formSetup("product_categories_admin","product_categories_admin","return submitForm(document.product_categories_admin)",declarations.store_info['db_name']) if form.has_key("username"): username = form["username"].value else: if form.has_key("uHidden"): username = form["uHidden"].value else: username = '' if form.has_key("password"): password = form["password"].value else: if form.has_key("pHidden"): password = form["pHidden"].value else: password = '' ecommerce.usernamePasswordDisplay(username, password) if form.has_key("performDbQuery") or performDbQuery == 1: dbResult = ecommerce.connectDB(username, password, declarations.store_info['db_name']) # could not connect to db if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Can not connect to database,\n" + dbResult['message']) # connected to db ecommerce.queryFunctionButtons(0, declarations.store_info['help_file']) else: db = dbResult['result'] # check to see if a query has been performed with at least one column queryFields, whereFields = ecommerce.getQueryWhereFields(form, table_data, 'product_categories') if queryFields == None or queryFields == []: queryFields = [] whereFields = None queryFields.append('category') dbResult, queryStatement = ecommerce.executeQuery(db, table_data, 'product_categories', queryFields, whereFields, 'query', ecommerce.queryItemFunctionsHtmlNoEdit, 'ORDER by category','category') # if query was not successful if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not retrieve category values data from database,\n" + dbResult['message']); # else category values data was retrieved ok else: ecommerce.alertsArea(form, "Last Query Statement: " + queryStatement + "\n" + `len(dbResult['result'])` + " category value items retrieved from database"); ecommerce.queryFunctionButtons(1, declarations.store_info['help_file']) else: ecommerce.queryFunctionButtons(0, declarations.store_info['help_file']) ecommerce.queryHiddenFields(username, password) print "</FORM>" try: ecommerce.trailer(table_data, db) db.close() except NameError: pass print "</BODY>" print "</HTML>" if form.has_key("performDbQuery") or performDbQuery == 1: return dbResult else: return {'status' : 'success', 'message' : 'query successful', 'result' : 0}
form = ecommerce.getFormData() if form.has_key("action"): if form["action"].value == "edit": table_data = declarations.define_tables() print "<HTML>" print "<HEAD>" ecommerce.generate_form_javascript(table_data, 'store_info', 'store_admin', 0, 0) ecommerce.title("Store Info Administration") print "</HEAD>" ecommerce.bodySetup() ecommerce.mainHeading('Store Info Administration') ecommerce.subHeading('Edit Store Infos') ecommerce.formSetup("store_admin", "store_admin", "return submitForm(document.store_admin)", declarations.store_info['db_name']) dbResult = ecommerce.connectDB(form["uHidden"].value, form["pHidden"].value,