Python printHeader1 Examples

Example #1

File: binList.py Project: lezzgiles/esp

#!/python26/python.exe
# -*- coding: UTF-8 -*-

# enable debugging
import cgitb
import cgi
import sys
from myutils import c,cursor,sql, printRedirect,printHeader1,printHeader2, printFooter, printOptions, centsToDollarString, gotoButton, getItemName, sortLists
cgitb.enable()

form = cgi.FieldStorage()

printHeader1('Bin/stock list')

errorString = None

#########################################
if form.has_key('moveStock'):
    try:
        tableSize = int(form['tableSize'].value)

        delBin = form['delBin'].value
        delItem= form['delItem'].value

        history = "MOVE %s FROM %s"%(delItem,delBin)

        moveDetails = []
        totalToMove = 0
        for i in range(2,tableSize+1):
            binId = form['addBin-'+str(i)].value
            binQty = int(form['addQty-'+str(i)].value)

Example #2

File: sales.py Project: lezzgiles/esp

#!/python26/python.exe

# enable debugging
import cgitb
import cgi
import sys
from myutils import c,cursor,sql, printRedirect, printHeader1,printHeader2, printFooter, gotoButton, centsToDollarString, dollarStringToCents, cell, moneyCell, getItemName, getName

cgitb.enable()

form = cgi.FieldStorage()

printHeader1('Sales')

errorString = None

#cgi.print_form(form)

################
# Handle add sale

if form.has_key('addSale'):
    try:
        #cgi.print_form(form)
        buyer = form['buyer'].value
        shipping = dollarStringToCents(form['shipping'].value)
        if form.has_key('reconcile'):
            tranType = 'RECONCILE'
        else:
            tranType = 'REAL'
        cursor.execute('BEGIN IMMEDIATE TRANSACTION')

Example #3

File: kits.py Project: lezzgiles/esp

#!/python26/python.exe
#-*- coding: UTF-8 -*-

# enable debugging
import cgitb
import cgi
from myutils import c,cursor,sql,printRedirect, printHeader1,printHeader2, printFooter, gotoButton, centsToDollarString, dollarStringToCents, cell, moneyCell, getTranType, getItemName
import sys

cgitb.enable()

form = cgi.FieldStorage()

printHeader1('Kits')

errorString = None

#cgi.print_form(form)

##################
# Handle add kit request
if form.has_key('AddKit'):
    try:
        name = form['name'].value
        maxItemIdx = form['addLastItem'].value
        cursor.execute('BEGIN IMMEDIATE TRANSACTION')
        cursor.execute("INSERT INTO Kit (name) VALUES (?)",(name,))
        kitId = cursor.lastrowid

        for i in range(1,int(maxItemIdx)+1):
            if form.has_key('addItem-'+str(i)):

Example #4

File: expenses.py Project: lezzgiles/esp

#!/python26/python.exe
# -*- coding: UTF-8 -*-

# enable debugging
import cgitb
import cgi
from myutils import c,cursor,sql, printRedirect, printHeader1,printHeader2, printFooter, gotoButton,centsToDollarString,dollarStringToCents
import sqlite3
import sys

cgitb.enable()

form = cgi.FieldStorage()

printHeader1('Expenses & Fees')

errorString = None

######################
# Handle delete
if form.has_key('deleteId'):
    try:
        deleteId = int(form['deleteId'].value)

        cursor.execute('BEGIN IMMEDIATE TRANSACTION')
        cursor.execute('DELETE FROM expense WHERE expenseId = ?',(deleteId,))
        c.commit()
        printRedirect('Deleted expense','expenses.py',0)
        sys.exit()

    except Exception,e:

Example #5

File: saleDetails.py Project: lezzgiles/esp

#!/python26/python.exe
# -*- coding: UTF-8 -*-

# enable debugging
import cgitb
import cgi
import sys
from myutils import c,cursor,sql, printRedirect,printHeader1,printHeader2, printFooter, gotoButton, centsToDollarString, centsToString,dollarStringToCents,cell,moneyCell,getTranType,getItemName

cgitb.enable()

form = cgi.FieldStorage()

printHeader1('Sale Details')

errorString = None

tranId = form['tranId'].value

if form.has_key('tracking'):
    try:
        tracking = form['tracking'].value
        actualShipping = dollarStringToCents(form['actualShipping'].value)
        cursor.execute('BEGIN IMMEDIATE TRANSACTION')
        cursor.execute('UPDATE Trans SET tracking=?, actualShipping=? WHERE tranId = ?',(tracking,actualShipping,tranId))
        c.commit()
        # redirect to page, so page reload doesn't re-add change
        printRedirect('Updating Sale','sales.py',0)
        sys.exit()
    except Exception,e:
        c.rollback()

Example #6

File: purchases.py Project: lezzgiles/esp

#!/python26/python.exe

# enable debugging
import cgitb
import cgi
from myutils import c,cursor,sql,printRedirect, printHeader1,printHeader2, printFooter, gotoButton, centsToDollarString, dollarStringToCents, cell, moneyCell, getTranType, getItemName
import sys

cgitb.enable()

form = cgi.FieldStorage()

printHeader1('Purchases')

errorString = None

#cgi.print_form(form)

##################
# Handle add purchase request
if form.has_key('AddPurchase'):
    try:
        seller = form['seller'].value
        shipping = dollarStringToCents(form['shipping'].value)
        if form.has_key('reconcile'):
            tranType = 'RECONCILE'
        else:
            tranType = 'REAL'
        maxItemIdx = form['addLastItem'].value
        cursor.execute('BEGIN IMMEDIATE TRANSACTION')
        cursor.execute("INSERT INTO Trans (type,direction,tranDate,description,shipping) VALUES (?,'ADD',DATE('now'),?,?)",