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)