def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "dms"
self.xmlTableDef = 0
self.loadTable(allTables)
# self.saveTable()
self.size_x = 0
self.size_y = 0
self.imageData = 'No Image'
self.ModulNumber = 0
#self.athread = threading.Thread(target = self.loadTable())
#self.athread.start()
self.listHeader['names'] = ['name', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
self.out( "number of Columns ")
self.out( len(self.table.Columns))
#
self.statusfields = ['title']
self.imageWidget = None
self.fileFormat = None
self.fileSuffix = None
self.tmpfile = None
self.ModulNumber = 0
def __init__(self, allTables):
SingleData.__init__(self)
self.sqlDicUser['noWhereClient'] = 'YES'
self.dicUser['noWhereClient'] = 'YES'
# tables.dbd and address
self.sNameOfTable = "clients"
self.xmlTableDef = 0
self.loadTable(allTables)
# self.saveTable()
#self.athread = threading.Thread(target = self.loadTable())
#self.athread.start()
self.listHeader['names'] = ['name', 'zip', 'city', 'Street', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
self.out( "number of Columns ")
self.out( len(self.table.Columns))
#
#self.statusfields = ['lastname', 'city']
dicClients = self.rpc.callRP('User.getClientInfo', self.sqlDicUser )
self.out(dicClients)
liClientIds = dicClients['clientsID']
s = ''
for iZ in range(len(liClientIds)-1):
s += `iZ`
s += ' or id = '
s += `liClientIds[len(liClientIds)-1]`
self.sWhere = 'where id = ' + s
self.out('sWhere by clients: ' + `self.sWhere`)
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "hibernation"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore(
gtk.ListStore(
gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT
)
)
self.listHeader["size"] = [25, 10, 25, 25, 10]
#
self.setTreeFields(
[
"sequence_of_stock",
"hibernation_number",
"address.lastname as lastname",
"address.firstname as firstname",
]
)
self.setTreeOrder("sequence_of_stock, hibernation_number")
self.setListHeader([_("Stocknr"), _("Number"), _("Lastname"), _("Firstname")])
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "country"
self.xmlTableDef = 0
print "allTables = ", ` allTables `
self.loadTable(allTables)
self.listHeader["names"] = ["name", "zip", "city", "Street", "ID"]
self.listHeader["size"] = [25, 10, 25, 25, 10]
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "zipcode"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.listHeader['names'] = ['name', 'zip', 'city', 'Street', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
print "number of Columns "
print len(self.table.Columns)
self.Zips = {}
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "hibernation"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore( gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT) )
self.listHeader['size'] = [25,10,25,25,10]
#
self.setTreeFields( ['sequence_of_stock', 'hibernation_number', 'address.lastname as lastname', 'address.firstname as firstname',"id"] )
self.setTreeOrder('sequence_of_stock, hibernation_number')
self.setListHeader([_('Stocknr'), _('Number'),_('Lastname'), _('Firstname'),_("ID")])
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "hibernation"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT) )
self.listHeader['size'] = [25,10,25,25,10]
#
self.setTreeFields( ['hibernation_number', '(select firstname || \' \' || lastname from address where id = addressnumber) as address_name'] )
self.setTreeOrder('hibernation_number')
self.setListHeader([_('name'),_('customer')])
def __init__(self, allTables = None):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "countries"
self.xmlTableDef = 0
self.loadTable(allTables)
#self.athread = threading.Thread(target = self.loadTable())
#self.athread.start()
self.listHeader['name'] = []
self.listHeader['iso_code_2'] = []
self.out( "number of Columns ")
self.out( len(self.table.Columns))
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "account_plan"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT) )
self.listHeader['names'] = ['name', 'designation', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
print "number of Columns "
print len(self.table.Columns)
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "webshop"
self.xmlTableDef = 0
self.loadTable(allTables)
# self.saveTable()
#self.athread = threading.Thread(target = self.loadTable())
#self.athread.start()
self.listHeader['names'] = ['table', 'myName','ID']
self.listHeader['size'] = [25,25,10]
self.out( "number of Columns ")
self.out( len(self.table.Columns))
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "hibernation_plant"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_FLOAT, gobject.TYPE_UINT) )
self.listHeader['size'] = [25,10,25,25,10]
self.setTreeFields( ['plant_number','botany.botany_name as botany_name','diameter' ])
self.setTreeOrder('plant_number')
self.setListHeader([_('number'),_('plant'), _('diameter')])
self.hibernationID = 0
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "botany_divisio"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT) )
self.listHeader['size'] = [25,10,25,25,10]
#
self.setTreeFields( ['name', 'description'] )
self.setTreeOrder('name')
self.setListHeader([_('name'),_('description')])
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "account_sentence"
self.xmlTableDef = 0
self.loadTable(allTables)
# self.saveTable()
#self.athread = threading.Thread(target = self.loadTable())
#self.athread.start()
self.listHeader['names'] = ['name', 'zip', 'city', 'Street', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
self.out( "number of Columns ")
self.out( len(self.table.Columns))
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "thinking"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore(gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT))
self.listHeader["names"] = ["title", "designation", "ID"]
self.listHeader["size"] = [25, 10, 25, 25, 10]
print "number of Columns "
print len(self.table.Columns)
#
self.cType = "html"
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "material_group_accounts"
self.xmlTableDef = 0
self.loadTable(allTables)
# self.athread = threading.Thread(target = self.loadTable())
# self.athread.start()
self.listHeader["names"] = []
self.listHeader["size"] = []
self.out("number of Columns ")
self.out(len(self.table.Columns))
#
self.addressId = 0
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "address_bank"
self.xmlTableDef = 0
self.loadTable(allTables)
#self.athread = threading.Thread(target = self.loadTable())
#self.athread.start()
self.listHeader['names'] = []
self.listHeader['size'] = []
self.out( "number of Columns ")
self.out( len(self.table.Columns))
#
self.addressId = 0
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
#self.sNameOfTable = "biblio"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.allTables = allTables
#self.loadTable(allTables)
#self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT) )
#self.listHeader['names'] = ['title', 'designation', 'ID']
#self.listHeader['size'] = [25,10,25,25,10]
#print "number of Columns "
#print len(self.table.Columns)
#
self.tree1 = None
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "support_ticket"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT) )
self.listHeader['names'] = ['title', 'designation', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
print "number of Columns "
print len(self.table.Columns)
#
self.cType = 'html'
self.SupportProjectId = 0 ;
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "hibernation_plant"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore(gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_FLOAT, gobject.TYPE_UINT))
self.listHeader["size"] = [25, 10, 25, 25, 10]
self.setTreeFields(
["plant_number", "(select botany_name from botany where id = botany_number) as botany_name", "diameter"]
)
self.setTreeOrder("plant_number")
self.setListHeader([_("number"), _("plant"), _("diameter")])
self.hibernationID = 0
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "articles_stock"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_UINT) )
self.listHeader['names'] = ['designation', 'ID']
self.listHeader['size'] = [25,10]
print "number of Columns "
print len(self.table.Columns)
#
self.articlesNumber = 9
self.liOtherEntries = []
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "procurement"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT) )
self.listHeader['names'] = ['number', 'designation', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
print "number of Columns "
print len(self.table.Columns)
#
self.statusfields = ['number', 'designation']
self.NotesArticles = None
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "project_phases"
self.xmlTableDef = 0
#print 'allTables = ',`allTables`
self.loadTable(allTables)
# self.saveTable()
#self.athread = threading.Thread(target = self.loadTable())
#self.athread.start()
self.listHeader['names'] = ['name', 'zip', 'city', 'Street', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
self.out( "number of Columns ")
self.out( len(self.table.Columns))
self.projectId = 0
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "preferences"
self.xmlTableDef = 0
self.loadTable(allTables)
# self.saveTable()
self.username = None
#self.athread = threading.Thread(target = self.loadTable())
#self.athread.start()
self.listHeader['names'] = ['name', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
self.out( "number of Columns ")
self.out( len(self.table.Columns))
#
self.statusfields = ['profile_name']
self.profileName = None
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "address_bank"
self.xmlTableDef = 0
self.loadTable(allTables)
# self.saveTable()
# self.athread = threading.Thread(target = self.loadTable())
# self.athread.start()
self.listHeader["names"] = ["name", "zip", "city", "Street", "ID"]
self.listHeader["size"] = [25, 10, 25, 25, 10]
self.out("number of Columns ")
self.out(len(self.table.Columns))
#
self.addressId = 0
self.statusfields = ["lastname", "firstname"]
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "proposal"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT) )
self.listHeader['names'] = ['number', 'designation', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
print "number of Columns "
print len(self.table.Columns)
#
self.invoiceNumber = 0
self.proposalNumber = 0
self.processStatus = 500
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "proposalsupply"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT) )
self.listHeader['names'] = ['number', 'designation', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
print "number of Columns "
print len(self.table.Columns)
#
self.ordernumber = 0
#self.statusfields = ['lastname', 'firstname']
self.deliveryNumber = 0
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "grave_service_notes"
self.xmlTableDef = 0
self.loadTable(allTables)
# self.saveTable()
#self.athread = threading.Thread(target = self.loadTable())
#self.athread.start()
self.listHeader['names'] = ['name', 'zip', 'city', 'Street', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
self.out( "number of Columns ")
self.out( len(self.table.Columns))
#
self.statusfields = ['lastname', 'city']
self.graveID = 0
self.graveServiceID = 0
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "staff_vacation"
self.xmlTableDef = 0
print 'allTables = ',`allTables`
self.loadTable(allTables)
# self.saveTable()
#self.athread = threading.Thread(target = self.loadTable())
#self.athread.start()
self.listHeader['names'] = ['name', 'designation', 'ID']
self.listHeader['size'] = [25,35,10]
#self.out( "number of Columns ")
#self.out( len(self.table.Columns))
#
self.statusfields = ['lastname', 'city']
self.staff_id = 0
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "proposalget"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore(gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT))
self.listHeader["names"] = ["number", "designation", "ID"]
self.listHeader["size"] = [25, 10, 25, 25, 10]
print "number of Columns "
print len(self.table.Columns)
#
self.ordernumber = 0
# self.statusfields = ['lastname', 'firstname']
self.pickupNumber = 0
def __init__(self, allTables):
SingleData.__init__(self)
# tables.dbd and address
self.sNameOfTable = "support_project"
self.xmlTableDef = 0
# self.loadTable()
# self.saveTable()
self.loadTable(allTables)
self.setStore( gtk.ListStore(gobject.TYPE_STRING, gobject.TYPE_STRING, gobject.TYPE_UINT) )
self.listHeader['names'] = ['title', 'designation', 'ID']
self.listHeader['size'] = [25,10,25,25,10]
print "number of Columns "
print len(self.table.Columns)
#
self.cType = 'html'
# def readNonWidgetEntries(self, dicValues):
# print 'readNonWidgetEntries(self) by SingleWeb2'
# dicValues['ctype'] = [self.cType, 'string']
# return dicValues
