print "<HTML>"
print "<HEAD>"
ecommerce.generate_form_javascript(table_data, 'customers',
'customer_admin', 0, 0)
ecommerce.title("Customer Administration")
print "</HEAD>"
ecommerce.bodySetup()
ecommerce.mainHeading('Customer Administration')
ecommerce.subHeading('Edit Customer')
ecommerce.formSetup("customer_admin", "customer_admin",
"return submitForm(document.customer_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'])
else:
'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)
if dbResult['status'] != 'success':
ecommerce.alertsArea(form, "Could not retrieve order data to edit\n" + dbResult['message'])
else:
result = dbResult['result']
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,
form["pHidden"].value,
declarations.store_info['db_name'])
# if db connection failed
if dbResult['status'] != 'success':
# generate appropriate message in alerts area
ecommerce.alertsArea(
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
}
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
}
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']);
else:
db = dbResult['result']
sqlStatement = ecommerce.selectAllColumnsSqlStatement(table_data,'order_status_values',form["key_id"].value,'status_of_order')
#print sqlStatement
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 """
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']);
else:
db = dbResult['result']
sqlStatement = ecommerce.selectAllColumnsSqlStatement(table_data,'product_categories',form["key_id"].value,'category')
#print sqlStatement
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']);
else:
db = dbResult['result']
sqlStatement = ecommerce.selectAllColumnsSqlStatement(table_data,'market_status_values',form["key_id"].value,'status_of_market')
dbResult = ecommerce.executeSQL(db, sqlStatement)
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,
declarations.store_info['db_name'])
if dbResult['status'] != 'success':
ecommerce.alertsArea(
form,
"Could not connect to the database\n" + dbResult['message'])
else:
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,
declarations.store_info['db_name'])
if dbResult['status'] != 'success':
ecommerce.alertsArea(
form,
"Could not connect to the database\n" + dbResult['message'])
else:
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
}
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}
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']);
else:
db = dbResult['result']
sqlStatement = ecommerce.selectAllColumnsSqlStatement(table_data,'payment_methods',form["key_id"].value,'payment_type')
#print sqlStatement
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,
declarations.store_info['db_name'])
if dbResult['status'] != 'success':
ecommerce.alertsArea(
form,
"Could not connect to the database\n" + dbResult['message'])
else:
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']);
else:
db = dbResult['result']
sqlStatement = ecommerce.selectAllColumnsSqlStatement(table_data,'shipping_methods',form["key_id"].value,'method')
#print sqlStatement
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}
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,
declarations.store_info['db_name'])
if dbResult['status'] != 'success':
ecommerce.alertsArea(
form,
"Could not connect to the database\n" + dbResult['message'])
else:
