#print sqlStatement dbResult = ecommerce.executeSQL(db, sqlStatement) if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Could not retrieve sales tax data to edit\n" + dbResult['message']) else: result = dbResult['result'] table_data = ecommerce.dbToTableData(table_data, 'sales_tax_by_state', result[0]) ecommerce.display_form(table_data, 'sales_tax_by_state', 1, 'useValues', 1, db) ecommerce.alertsArea(form, "Sales tax data retrieved successfully") 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']) ecommerce.editHiddenFields(form["uHidden"].value,
sqlStatement = ecommerce.selectAllColumnsSqlStatement(table_data,'product_categories',form["key_id"].value,'category') #print sqlStatement dbResult = ecommerce.executeSQL(db, sqlStatement) if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not retrieve category values to edit\n" + dbResult['message']); else: result = dbResult['result'] table_data = ecommerce.dbToTableData(table_data, 'product_categories', result[0]) ecommerce.display_form(table_data, 'product_categories', 1, 'useValues', 1, db) ecommerce.alertsArea(form, "Product Categoriess retrieved successfully"); 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']) ecommerce.editHiddenFields(form["uHidden"].value, form["pHidden"].value) print "</FORM>" ecommerce.trailer(table_data, db) db.close()
# sqlStatement = "SELECT p.id, p.date_built, p.car_garage, p.town, p.subdivision, p.style, p.full_basement, p.bedrooms, p.baths, p.square_footage, p.price, p.description, p.image, p.directions, p.heating_air, p.number_rooms, p.electric_service, p.school_district, p.acreage FROM customers p WHERE p.id = '" + form["key_id"].value + "'" dbResult = ecommerce.executeSQL(db, sqlStatement) if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Could not retrieve customer data to edit\n" + dbResult['message']) else: result = dbResult['result'] table_data = ecommerce.dbToTableData(table_data, 'customers', result[0]) ecommerce.display_form(table_data, 'customers', 1, 'useValues', 1, db) ecommerce.alertsArea(form, "Customer data retrieved successfully") 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']) ecommerce.editHiddenFields(form["uHidden"].value, form["pHidden"].value)
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 = ecommerce.dbToTableData(table_data, 'orders', result[0]) ecommerce.display_form(table_data, 'orders', 1, 'useValues', 1, db) dbResult = ecommerce.executeSQL(db, "SELECT line_item, order_id, product_id, quantity, quantity_shipped, price, line_subtotal FROM order_items WHERE order_id = '" + form['key_id'].value + "'") if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not retrieve order data to edit\n" + dbResult['message']) else: print '<HR>' ecommerce.printText('Items In Order') print '<TABLE BORDER=1>' print '<TR><TH>Line Item</TH><TH>Code</TH><TH>Quantity</TH><TH>Shipped</TH><TH>Description</TH><TH>Price</TH><TH>Extension</TH><TH>Message</TH><TH>Functions</TH></TR>'
db = dbResult['result'] sqlStatement = ecommerce.selectAllColumnsSqlStatement( table_data, 'store_info', '1') dbResult = ecommerce.executeSQL(db, sqlStatement) if dbResult['status'] != 'success': email = '*****@*****.**' else: result = dbResult['result'] table_data = ecommerce.dbToTableData(table_data, 'store_info', result[0]) email = table_data['store_info']['email']['value'] html_msg = '<P>Your information has been submitted.' html_msg = html_msg + '<p>If you have requested information we will ' html_msg = html_msg + 'respond to your request as soon as possible.' email_msg = '' email_msg = email_msg + 'Customer Feedback\n\n' email_msg = email_msg + 'Name: ' + form['name'].value + '\n' email_msg = email_msg + 'Street: ' + form['street'].value + '\n' email_msg = email_msg + 'City: ' + form['city'].value + '\n' email_msg = email_msg + 'State: ' + form['state'].value + '\n' email_msg = email_msg + 'Zip: ' + form['zip'].value + '\n' email_msg = email_msg + 'Phone: ' + form['phone'].value + '\n'
sqlStatement = ecommerce.selectAllColumnsSqlStatement(table_data,'order_status_values',form["key_id"].value,'status_of_order') #print sqlStatement dbResult = ecommerce.executeSQL(db, sqlStatement) if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not retrieve order status values to edit\n" + dbResult['message']); else: result = dbResult['result'] table_data = ecommerce.dbToTableData(table_data, 'order_status_values', result[0]) ecommerce.display_form(table_data, 'order_status_values', 1, 'useValues', 1, db) ecommerce.alertsArea(form, "Order Statuss retrieved successfully"); 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']) ecommerce.editHiddenFields(form["uHidden"].value, form["pHidden"].value) print "</FORM>" ecommerce.trailer(table_data, db) db.close() print "</BODY>"
sqlStatement = ecommerce.selectAllColumnsSqlStatement(table_data,'shipping_methods',form["key_id"].value,'method') #print sqlStatement dbResult = ecommerce.executeSQL(db, sqlStatement) if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not retrieve shipping methods to edit\n" + dbResult['message']); else: result = dbResult['result'] table_data = ecommerce.dbToTableData(table_data, 'shipping_methods', result[0]) ecommerce.display_form(table_data, 'shipping_methods', 1, 'useValues', 1, db) ecommerce.alertsArea(form, "Shipping Methodss retrieved successfully"); 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']) ecommerce.editHiddenFields(form["uHidden"].value, form["pHidden"].value) print "</FORM>" ecommerce.trailer(table_data, db) db.close() print "</BODY>"
sqlStatement = ecommerce.selectAllColumnsSqlStatement(table_data,'payment_methods',form["key_id"].value,'payment_type') #print sqlStatement dbResult = ecommerce.executeSQL(db, sqlStatement) if dbResult['status'] != 'success': ecommerce.alertsArea(form, "Could not retrieve Payment Methods to edit\n" + dbResult['message']); else: result = dbResult['result'] table_data = ecommerce.dbToTableData(table_data, 'payment_methods', result[0]) ecommerce.display_form(table_data, 'payment_methods', 1, 'useValues', 1, db) ecommerce.alertsArea(form, "Payment Methods retrieved successfully"); 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']) ecommerce.editHiddenFields(form["uHidden"].value, form["pHidden"].value) print "</FORM>" ecommerce.trailer(table_data, db) # close db
sqlStatement = ecommerce.selectAllColumnsSqlStatement( table_data, 'products', form["key_id"].value) dbResult = ecommerce.executeSQL(db, sqlStatement) if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Could not retrieve product data to edit\n" + dbResult['message']) else: result = dbResult['result'] table_data = ecommerce.dbToTableData(table_data, 'products', result[0]) ecommerce.display_form(table_data, 'products', 1, 'useValues', 1, db) ecommerce.alertsArea(form, "Product data retrieved successfully") 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']) ecommerce.editHiddenFields(form["uHidden"].value, form["pHidden"].value)
sqlStatement = ecommerce.selectAllColumnsSqlStatement( table_data, 'properties', form["key_id"].value) dbResult = ecommerce.executeSQL(db, sqlStatement) if dbResult['status'] != 'success': ecommerce.alertsArea( form, "Could not retrieve property data to edit\n" + dbResult['message']) else: result = dbResult['result'] table_data = ecommerce.dbToTableData(table_data, 'properties', result[0]) ecommerce.display_form(table_data, 'properties', 1, 'useValues', 1, db) ecommerce.alertsArea(form, "Property data retrieved successfully") ecommerce.editFunctionButtons( form["key_id"].value, '/' + declarations.store_info['db_name'] + '-cgi-bin/property_admin.pyc?username='******'&password='******'&performDbQuery=1', declarations.store_info['help_file']) ecommerce.editHiddenFields(form["uHidden"].value, form["pHidden"].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 }