import withdraw_helper def field_name_1(field, ben='Ben'): field = 'pnlSetupNewPayeePayaPerson:frmPayaPersonArrangement:str' + ben + field return "document.forms[1]['" + field + "'].value='%s';" cursor = withdraw_helper.cursor() withdrawals = withdraw_helper.get_withdrawals(cursor, 'PROCES') count = 1 for reqid, amount, name, bank, acc_num, sort_code in withdrawals: print count, '/', len(withdrawals) print count += 1 # truncate decimals to 2 places amount = withdraw_helper.quantize(amount) print 'Name =\t\t', name print 'Account =\t', acc_num if len(sort_code) != 6: print 'Sort code is wrong length' print 'Request ID =\t', reqid break sort_code = sort_code[0:2], sort_code[2:4], sort_code[4:6] print 'Sort code =\t', sort_code[0], sort_code[1], sort_code[2] print
import withdraw_helper def field_name_1(field, ben='Ben'): field = 'pnlSetupNewPayeePayaPerson:frmPayaPersonArrangement:str' + ben + field return "document.forms[1]['" + field + "'].value='%s';" cursor = withdraw_helper.cursor() withdrawals = withdraw_helper.get_withdrawals(cursor, 'PROCES') count = 1 for reqid, amount, name, bank, acc_num, sort_code in withdrawals: print count, '/', len(withdrawals) print count += 1 # truncate decimals to 2 places amount = withdraw_helper.quantize(amount) print 'Name =\t\t', name print 'Account =\t', acc_num if len(sort_code) != 6: print 'Sort code is wrong length' print 'Request ID =\t', reqid break sort_code = sort_code[0:2], sort_code[2:4], sort_code[4:6] print 'Sort code =\t', sort_code[0], sort_code[1], sort_code[2] print print 'Amount =\t', amount
import withdraw_helper import decimal cursor = withdraw_helper.cursor() withdrawals = withdraw_helper.get_withdrawals(cursor, 'AWAIT') total = decimal.Decimal(0) count = 1 for reqid, amount, name, bank, acc_num, sort_code in withdrawals: print count, '/', len(withdrawals) print count += 1 # truncate decimals to 2 places amount = withdraw_helper.quantize(amount) print 'Search for: \t', acc_num print print 'Name =\t\t', name if len(sort_code) != 6: print 'Sort code is wrong length' print 'Request ID =\t', reqid break sort_code = sort_code[0:2], sort_code[2:4], sort_code[4:6] print 'Sort code =\t', sort_code[0], sort_code[1], sort_code[2] print 'Amount =\t', amount if len(acc_num) != 8: print 'Account number is not 8 digits'