if form["key_id"].value == 'create': form["key_id"].value = form['category'].value # save the Form dbResult = ecommerce.saveForm(table_data, db, None, "product_categories", " WHERE category = '" + form["key_id"].value + "'", form) # if the form was not successfully saved if dbResult['status'] != 'success': ecommerce.alertsArea(form,"Product Categories could not be saved due to an error during save,\n" + dbResult['message'] ) # form was successfully saved else: table_data = declarations.define_tables() table_data = ecommerce.formToTableData(table_data,'product_categories', form) ecommerce.display_form(table_data, 'product_categories', 1, 'useValues', 1, db) ecommerce.alertsArea(form,"Product Categories successfully saved") # generate function button row ecommerce.editFunctionButtons(form["key_id"].value, '/' + declarations.store_info['db_name'] + '-cgi-bin/product_categories_admin.pyc?username='******'&password='******'&performDbQuery=1', declarations.store_info['help_file']) # generate hidden fields for form ecommerce.createHiddenFields(form["uHidden"].value, form["pHidden"].value) print "</FORM>" ecommerce.trailer(table_data, db) db.close()
ecommerce.subHeading('Edit Order')
ecommerce.formSetup("order_admin","order_admin","return submitForm(document.order_admin)",declarations.store_info['db_name'])
this_is_a_create = 0
if form["key_id"].value == 'create':
this_is_a_create = 1
queryResult = ecommerce.executeSQL(db, "SELECT NEXTVAL('orders_id_seq')")
form["key_id"].value = `queryResult['result'][0]['nextval']`
ecommerce.formToTableData(table_data,'orders',form)
if not this_is_a_create:
ecommerce.formToTableData(table_data,'orders',form)
# delete all order items currently in db
sqlStatement = "DELETE FROM order_items WHERE order_id = '" + form["key_id"].value + "'"
dbResult = ecommerce.executeSQL(db, sqlStatement)
if dbResult['status'] != 'success':
ecommerce.alertsArea(form,"Order items could not be deleted prior to insert,\n" + dbResult['message'] )
print "</FORM>"
ecommerce.trailer(table_data, db)
table_data, db, None, "sales_tax_by_state",
" WHERE state_name = '" + form["key_id"].value + "'", form)
# if the form was not successfully saved
if dbResult['status'] != 'success':
ecommerce.alertsArea(
form,
"Sales tax data could not be saved due to an error during save,\n"
+ dbResult['message'])
# form was successfully saved
else:
table_data = declarations.define_tables()
table_data = ecommerce.formToTableData(table_data,
'sales_tax_by_state',
form)
ecommerce.display_form(table_data, 'sales_tax_by_state', 1,
'useValues', 1, db)
ecommerce.alertsArea(form, "Sales tax data successfully saved")
# generate function button row
ecommerce.editFunctionButtons(
form["key_id"].value, '/' + declarations.store_info['db_name'] +
'-cgi-bin/sales_tax_admin.pyc?username='******'&password='******'&performDbQuery=1',
declarations.store_info['help_file'])
# generate hidden fields for form
if form["key_id"].value == 'create': form["key_id"].value = form['status_of_order'].value # save the Form dbResult = ecommerce.saveForm(table_data, db, None, "order_status_values", " WHERE status_of_order = '" + form["key_id"].value + "'", form) # if the form was not successfully saved if dbResult['status'] != 'success': ecommerce.alertsArea(form,"Order Status could not be saved due to an error during save,\n" + dbResult['message'] ) # form was successfully saved else: table_data = declarations.define_tables() table_data = ecommerce.formToTableData(table_data,'order_status_values', form) ecommerce.display_form(table_data, 'order_status_values', 1, 'useValues', 1, db) ecommerce.alertsArea(form,"Order Status successfully saved") # generate function button row ecommerce.editFunctionButtons(form["key_id"].value, '/' + declarations.store_info['db_name'] + '-cgi-bin/order_status_values_admin.pyc?username='******'&password='******'&performDbQuery=1', declarations.store_info['help_file']) # generate hidden fields for form ecommerce.createHiddenFields(form["uHidden"].value, form["pHidden"].value) print "</FORM>" ecommerce.trailer(table_data, db) db.close()
table_data, db, form["key_id"].value, "customers",
" WHERE id = '" + form["key_id"].value + "'", form)
# if the form was not successfully saved
if dbResult['status'] != 'success':
ecommerce.alertsArea(
form,
"Customer data could not be saved due to an error during save,\n"
+ dbResult['message'])
# form was successfully saved
else:
table_data = declarations.define_tables()
table_data = ecommerce.formToTableData(table_data, 'customers',
form,
form["key_id"].value)
ecommerce.display_form(table_data, 'customers', 1, 'useValues',
1, db)
ecommerce.alertsArea(form, "Customer data successfully saved")
# generate function button row
ecommerce.editFunctionButtons(
form["key_id"].value, '/' + declarations.store_info['db_name'] +
'-cgi-bin/customer_admin.pyc?username='******'&password='******'&performDbQuery=1',
declarations.store_info['help_file'])
# generate hidden fields for form
form["key_id"].value = form['method'].value # save the Form dbResult = ecommerce.saveForm(table_data, db, None, "shipping_methods", " WHERE method = '" + form["key_id"].value + "'", form) # if the form was not successfully saved if dbResult['status'] != 'success': ecommerce.alertsArea(form,"Shipping Methods could not be saved due to an error during save,\n" + dbResult['message'] ) # form was successfully saved else: table_data = declarations.define_tables() table_data = ecommerce.formToTableData(table_data,'shipping_methods', form) ecommerce.display_form(table_data, 'shipping_methods', 1, 'useValues', 1, db) ecommerce.alertsArea(form,"Shipping Methods successfully saved") # generate function button row ecommerce.editFunctionButtons(form["key_id"].value, '/' + declarations.store_info['db_name'] + '-cgi-bin/shipping_methods_admin.pyc?username='******'&password='******'&performDbQuery=1', declarations.store_info['help_file']) # generate hidden fields for form ecommerce.createHiddenFields(form["uHidden"].value, form["pHidden"].value) print "</FORM>" ecommerce.trailer(table_data, db)
if form["key_id"].value == 'create': form["key_id"].value = form['payment_type'].value # save the Form dbResult = ecommerce.saveForm(table_data, db, None, "payment_methods", " WHERE payment_type = '" + form["key_id"].value + "'", form) # if the form was not successfully saved if dbResult['status'] != 'success': ecommerce.alertsArea(form,"Payment Method could not be saved due to an error during save,\n" + dbResult['message'] ) # form was successfully saved else: table_data = declarations.define_tables() table_data = ecommerce.formToTableData(table_data,'payment_methods', form) ecommerce.display_form(table_data, 'payment_methods', 1, 'useValues', 1, db) ecommerce.alertsArea(form,"Payment Method successfully saved") # generate function button row ecommerce.editFunctionButtons(form["key_id"].value, '/' + declarations.store_info['db_name'] + '-cgi-bin/payment_methods_admin.pyc?username='******'&password='******'&performDbQuery=1', declarations.store_info['help_file']) # generate hidden fields for form ecommerce.createHiddenFields(form["uHidden"].value, form["pHidden"].value) print "</FORM>" ecommerce.trailer(table_data, db)
dbResult = ecommerce.saveForm(
table_data, db, form["key_id"].value, "products",
" WHERE id = '" + form["key_id"].value + "'", form)
# if the form was not successfully saved
if dbResult['status'] != 'success':
ecommerce.alertsArea(
form,
"Product data could not be saved due to an error during save,\n"
+ dbResult['message'])
# form was successfully saved
else:
table_data = ecommerce.formToTableData(table_data, 'products',
form,
form["key_id"].value)
ecommerce.display_form(table_data, 'products', 1, 'useValues',
1, db)
ecommerce.alertsArea(form, "Product data successfully saved")
# generate function button row
ecommerce.editFunctionButtons(
form["key_id"].value, '/' + declarations.store_info['db_name'] +
'-cgi-bin/product_admin.pyc?username='******'&password='******'&performDbQuery=1',
declarations.store_info['help_file'])
# generate hidden fields for form
form["key_id"].value = form['status_of_market'].value # save the Form dbResult = ecommerce.saveForm(table_data, db, None, "market_status_values", " WHERE status_of_market = '" + form["key_id"].value + "'", form) # if the form was not successfully saved if dbResult['status'] != 'success': ecommerce.alertsArea(form,"Market Status could not be saved due to an error during save,\n" + dbResult['message'] ) # form was successfully saved else: table_data = declarations.define_tables() table_data = ecommerce.formToTableData(table_data,'market_status_values', form) ecommerce.display_form(table_data, 'market_status_values', 1, 'useValues', 1, db) ecommerce.alertsArea(form,"Market Status successfully saved") # generate function button row ecommerce.editFunctionButtons(form["key_id"].value, '/' + declarations.store_info['db_name'] + '-cgi-bin/market_status_values_admin.pyc?username='******'&password='******'&performDbQuery=1', declarations.store_info['help_file']) # generate hidden fields for form ecommerce.createHiddenFields(form["uHidden"].value, form["pHidden"].value) print "</FORM>" ecommerce.trailer(table_data, db) # close db
# save the Form
dbResult = ecommerce.saveForm(table_data, db, None, "store_info",
" WHERE id = '1'", form)
# if the form was not successfully saved
if dbResult['status'] != 'success':
ecommerce.alertsArea(
form,
"Store Info could not be saved due to an error during save,\n"
+ dbResult['message'])
# form was successfully saved
else:
table_data = declarations.define_tables()
table_data = ecommerce.formToTableData(table_data,
'store_info', form)
table_data['store_info']['id']['value'] = '1'
ecommerce.display_form(table_data, 'store_info', 1,
'useValues', 1, db)
ecommerce.alertsArea(form, "Store Info successfully saved")
# generate function button row
storeButtons('save')
# generate hidden fields for form
ecommerce.createHiddenFields(form["uHidden"].value,
form["pHidden"].value)