def initFields(self):
self.magicFields = Frame(self.fieldsFrame.interior)
self.magicFields.pack(fill=X,expand=1)
self.normalFields = Frame(self.fieldsFrame.interior)
self.normalFields.pack(fill=X,expand=1)
self.saveRevertFrame = Frame(self.magicFields)
self.saveRevertFrame.pack(side=BOTTOM,fill=X,expand=1)
self.mSaveButton = Button(self.saveRevertFrame,text="Save",command=self.saveMagic,
style="SAVEButton.TButton")
self.mRevertButton = Button(self.saveRevertFrame,text="Revert",command=self.revertMagic)
self.mSaveButton.pack(side=LEFT,fill=X,expand=1)
self.mRevertButton.pack(side=RIGHT,fill=X,expand=1)
self.mFields={}
self.mFields['startDate']=CalendarBox(self.magicFields,
label="Start Date")
self.mFields['endDate']=CalendarBox(self.magicFields,label="End Date")
self.mFields['startDate'].pack(side=TOP,fill=X,expand=1)
self.mFields['endDate'].pack(side=TOP,fill=X,expand=1)
self.mFields['collegeName']=TextFieldBox(self.magicFields,label="Council Name",height=1)
self.mFields['collegeName'].pack(side=TOP,fill=X,expand=1)
self.mFields['cashOnHand']=TextFieldBox(self.magicFields,label="Cash On Hand",height=1)
self.mFields['cashOnHand'].pack(side=TOP,fill=X,expand=1)
self.mFields['cashInBank'] = TextFieldBox(self.magicFields,label='Cash In Bank',height=1)
self.mFields['cashInBank'].pack(side=TOP,fill=X,expand=1)
preparedByBox = LabelFrame(self.magicFields,text="Prepared By")
self.mFields['preparedByName'] = TextFieldBox(preparedByBox,label="Name",height=1)
self.mFields['preparedByName'].pack(side=TOP,fill=X,expand=1)
self.mFields['preparedByPosition'] = TextFieldBox(preparedByBox,label="Position",height=1)
self.mFields['preparedByPosition'].pack(side=TOP,fill=X,expand=1)
preparedByBox.pack(side=TOP,fill=X,expand=1)
notedByBox = LabelFrame(self.magicFields,text="Noted By")
self.mFields['notedByName'] = TextFieldBox(notedByBox,label="Name",height=1)
self.mFields['notedByName'].pack(side=TOP,fill=X,expand=1)
self.mFields['notedByPosition'] = TextFieldBox(notedByBox,label="Position",height=1)
self.mFields['notedByPosition'].pack(side=TOP,fill=X,expand=1)
notedByBox.pack(side=TOP,fill=X,expand=1)
self.notesEditFrame = NotesEditBox(self.fieldsFrame.interior,[],"",self.addNote,self.removeNote)
self.notesEditFrame.pack(fill=X,expand=1)
for field in self.mFields:
self.mFields[field].bind("<Return>",self.saveMagic)
class CashFlowsWindow(CashDisbursmentsWindow):
def generateNewButton(self):
pass
def initTree(self):
self.tree = tree = Treeview(self.treeFrame,selectmode="browse")
tree.bind("<<TreeviewSelect>>",self.getSelection)
yscroll = Scrollbar(self.treeFrame,orient="vertical",command=tree.yview)
xscroll = Scrollbar(self.xScrollFrame,orient="horizontal",command=tree.xview)
colList = ['one','two','three','four']
tree['columns']=colList
for i in colList:
tree.column(i,anchor=E,width=100,minwidth=100)
tree.heading('one',text="Notes")
tree.heading('two',text="Amount")
tree.heading('three',text="Total")
tree.column("#0",anchor=W,width=150,minwidth=100)
tree.insert("","end","inflows",text="Cash Inflows",open=True)
tree.insert("","end","outflows",text="Cash Outflows",open=True)
tree.insert("","end","net",text="Net Cashflow",open=True)
tree.configure(yscroll=yscroll.set,xscroll=xscroll.set)
yscroll.pack(side=RIGHT,fill=Y,expand=0)
xscroll.pack(side=TOP,fill=X,expand=0)
tree.pack(side=LEFT,fill=BOTH,expand=1)
#replace with db entry
self.inflow_categories=inflow_categories=['Council Mandated Funds','General Sponsorship Inflows','Income Generating Projects','Other Inflows']
for i in inflow_categories:
tree.insert("inflows",'end',i.lower().replace(" ",""),text=i,open=True)
#replace with db entry
self.outflow_categories=outflow_categories=['Council and Other College Projects','Operation and Maintenance Expenses','Long Term Investments','Other Outflows']
for i in outflow_categories:
tree.insert("outflows","end",i.lower().replace(" ",""),text=i,open=True)
def initTotalTag(self):
pass
def initSaveDelete(self):
pass
def initFields(self):
self.magicFields = Frame(self.fieldsFrame.interior)
self.magicFields.pack(fill=X,expand=1)
self.normalFields = Frame(self.fieldsFrame.interior)
self.normalFields.pack(fill=X,expand=1)
self.saveRevertFrame = Frame(self.magicFields)
self.saveRevertFrame.pack(side=BOTTOM,fill=X,expand=1)
self.mSaveButton = Button(self.saveRevertFrame,text="Save",command=self.saveMagic,
style="SAVEButton.TButton")
self.mRevertButton = Button(self.saveRevertFrame,text="Revert",command=self.revertMagic)
self.mSaveButton.pack(side=LEFT,fill=X,expand=1)
self.mRevertButton.pack(side=RIGHT,fill=X,expand=1)
self.mFields={}
self.mFields['startDate']=CalendarBox(self.magicFields,
label="Start Date")
self.mFields['endDate']=CalendarBox(self.magicFields,label="End Date")
self.mFields['startDate'].pack(side=TOP,fill=X,expand=1)
self.mFields['endDate'].pack(side=TOP,fill=X,expand=1)
self.mFields['collegeName']=TextFieldBox(self.magicFields,label="Council Name",height=1)
self.mFields['collegeName'].pack(side=TOP,fill=X,expand=1)
self.mFields['cashOnHand']=TextFieldBox(self.magicFields,label="Cash On Hand",height=1)
self.mFields['cashOnHand'].pack(side=TOP,fill=X,expand=1)
self.mFields['cashInBank'] = TextFieldBox(self.magicFields,label='Cash In Bank',height=1)
self.mFields['cashInBank'].pack(side=TOP,fill=X,expand=1)
preparedByBox = LabelFrame(self.magicFields,text="Prepared By")
self.mFields['preparedByName'] = TextFieldBox(preparedByBox,label="Name",height=1)
self.mFields['preparedByName'].pack(side=TOP,fill=X,expand=1)
self.mFields['preparedByPosition'] = TextFieldBox(preparedByBox,label="Position",height=1)
self.mFields['preparedByPosition'].pack(side=TOP,fill=X,expand=1)
preparedByBox.pack(side=TOP,fill=X,expand=1)
notedByBox = LabelFrame(self.magicFields,text="Noted By")
self.mFields['notedByName'] = TextFieldBox(notedByBox,label="Name",height=1)
self.mFields['notedByName'].pack(side=TOP,fill=X,expand=1)
self.mFields['notedByPosition'] = TextFieldBox(notedByBox,label="Position",height=1)
self.mFields['notedByPosition'].pack(side=TOP,fill=X,expand=1)
notedByBox.pack(side=TOP,fill=X,expand=1)
self.notesEditFrame = NotesEditBox(self.fieldsFrame.interior,[],"",self.addNote,self.removeNote)
self.notesEditFrame.pack(fill=X,expand=1)
for field in self.mFields:
self.mFields[field].bind("<Return>",self.saveMagic)
def newButtonCallback(self):
pass
def getSelection(self,event):
item = self.tree.selection()[0]
values = self.tree.item(item,"values")
if values[0]!="":
self.notesEditFrame.labels = values[0]
else:
self.notesEditFrame.labels=""
def _populateTree(self,entrylist):
pass
def addNote(self):
item = self.tree.selection()[0]
category = self.tree.item(item,"text")
self.notesEditFrame.labels = (self.notesEditFrame.labels+","+self.notesEditFrame.dropDown.get()).strip(",")
possibleInflows = [i for i in self.app.listCashflows(False) if i.source.content.split(":")[0] =="CashReceipt"]
possibleInflows = [i for i in possibleInflows if i.getContents().nature.content==category]
for i in possibleInflows:
self.app.editCashflow(i.pk.content,note=self.notesEditFrame.labels)
possibleOutflows = [i for i in self.app.listCashflows(False) if i.source.content.split(":")[0] in ("OME","LTINote","OONote")]
possibleOutflows = [i for i in possibleOutflows if i.getContents().nature.content==category]
possibleCOCPs = [i for i in self.app.listCashflows(False) if i.source.content.split(":")[0]=="COCPNote"]
possibleCOCPs = [i for i in possibleCOCPs if i.getContents().event.content==category]
possibleOutflows+=possibleCOCPs
for i in possibleOutflows:
self.app.editCashflow(i.pk.content,note=self.notesEditFrame.labels)
self.populateTree()
def removeNote(self):
item = self.tree.selection()[0]
notes = self.notesEditFrame.labels
notes = notes.split(",")
notes.remove(self.notesEditFrame.dropDown.get())
notes = ','.join(notes)
self.notesEditFrame.labels = notes
category = self.tree.item(item,"text")
possibleInflows = [i for i in self.app.listCashflows(False) if i.source.content.split(":")[0]=="CashReceipt"]
possibleInflows = [i for i in possibleInflows if i.getContents().nature.content==category]
for i in possibleInflows:
self.app.editCashflow(i.pk.content,note=self.notesEditFrame.labels)
possibleOutflows = [i for i in self.app.listCashflows(False) if i.source.content.split(":")[0] in ("OME","LTINote","OONote")]
possibleOutflows = [i for i in possibleOutflows if i.getContents().nature.content==category]
possibleCOCPs = [i for i in self.app.listCashflows(False) if i.source.content.split(":")[0]=="COCPNote"]
possibleCOCPs = [i for i in possibleCOCPs if i.getContents().event.content==category]
possibleOutflows+=possibleCOCPs
for i in possibleOutflows:
self.app.editCashflow(i.pk.content,note=self.notesEditFrame.labels)
self.populateTree()
def populateTree(self,*a):
self.revertMagic()
self.notesEditFrame.elements = list(set([i.noteNumber.content for i in self.app.listNotes()]))
#clear trees... FOR NOW
for i in self.inflow_categories:
cat = i.lower().replace(" ","")
for item in self.tree.get_children(cat):
self.tree.delete(item)
for i in self.outflow_categories:
cat = i.lower().replace(" ","")
for item in self.tree.get_children(cat):
self.tree.delete(item)
totalInflows=0
#change this when db is implemented
partialTotals={'councilmandatedfunds':{},'generalsponsorshipinflows':{},'incomegeneratingprojects':{},'otherinflows':{}}
showDeleted = self.deletedVar.get()
cashFlowList = self.app.listCashflows(showDeleted=False)
inflowList = [i for i in cashFlowList if i.source.content.split(":")[0]=="CashReceipt"]
inflowList = filterDOT(self.app,inflowList)
for i in inflowList:
name = i.getContents().nature.content
amount = i.getContents().amount.content
notes = i.note.content
category = i.getContents().category.content.lower().replace(" ","")
try:
amount=float(amount)
except:
amount=0
if category in partialTotals:
totalInflows+=amount
if name in partialTotals[category]:
partialTotals[category][name][0]+=amount
else:
partialTotals[category][name]=[amount]
partialTotals[category][name].append(notes)
for i in partialTotals:
for j in partialTotals[i]:
notes = partialTotals[i][j][1]
notes = notes.split(",")
partialTotals[i][j][1]=self.filterNotes(notes)
for i in partialTotals:
partialTotalKeys = [key for key in partialTotals[i].keys()]
partialTotalKeys.sort()
for j in partialTotalKeys:
self.tree.insert(i,"end",text=j,values=(partialTotals[i][j][1],floatToStr(partialTotals[i][j][0]),))
self.tree.item('inflows',values=("","",floatToStr(totalInflows),""))
for i in partialTotals:
categoryTotal = reduce(lambda x,y:x+y,[d[0] for d in partialTotals[i].values()]+[0,])
self.tree.item(i,values=("","",floatToStr(categoryTotal),""))
outflowList = [i for i in cashFlowList if i.source.content.split(":")[0] in ("OME","COCPNote","LTINote","OONote")]
outflowList = filterDOT(self.app,outflowList)
totalOutflows=0
#change for when updated to db-stored variables
partialOutflows={"otheroutflows":{},"operationandmaintenanceexpenses":{},"councilandothercollegeprojects":{},"longterminvestments":{}}
treeParent = {"OONote":"otheroutflows","OME":"operationandmaintenanceexpenses","COCPNote":"councilandothercollegeprojects","LTINote":"longterminvestments"}
for i in outflowList:
name=i.getContents().nature.content
amount = i.getContents().amount.content
notes = i.note.content
category = i.source.content.split(":")[0]
if category=="COCPNote":
name = i.getContents().event.content
try:
amount=float(amount)
except:
amount=0
if category in treeParent:
category = treeParent[category]
totalOutflows+=amount
if name in partialOutflows[category]:
partialOutflows[category][name][0]+=amount
else:
partialOutflows[category][name]=[amount]
partialOutflows[category][name].append(notes)
self.tree.item('outflows',values=("","",floatToStr(totalOutflows),""))
for i in partialOutflows:
partialOutflowsSorted = [key for key in partialOutflows[i].keys()]
partialOutflowsSorted.sort()
for j in partialOutflowsSorted:
self.tree.insert(i,"end",text=j,values=(partialOutflows[i][j][1],floatToStr(partialOutflows[i][j][0]),))
categoryTotal = reduce(lambda x,y:x+y,[d[0] for d in partialOutflows[i].values()]+[0,])
self.tree.item(i,values=("","",floatToStr(categoryTotal),""))
self.tree.item('net',values=("","",floatToStr(totalInflows-totalOutflows),""))
def exportToExcel(self):
"""Exports the data displayed on the treebox to excel"""
excelBuilder = ExcelBuilder()
self.addSheet(excelBuilder)
excelBuilder.build()
def addSheet(self, excelBuilder):
# Format row data
rowData = []
for tierAItem in self.tree.get_children():
text = self.tree.item(tierAItem, "text")
values = self.tree.item(tierAItem, "values")
newTuple = (text, "", "") + values
rowData.append(newTuple)
for tierBItem in self.tree.get_children(tierAItem):
text = self.tree.item(tierBItem, "text")
values = self.tree.item(tierBItem, "values")
newTuple = ("", text, "") + values
rowData.append(newTuple)
for tierCItem in self.tree.get_children(tierBItem):
text = self.tree.item(tierCItem, "text")
values = self.tree.item(tierCItem, "values")
newTuple = ("", "", text) + values
rowData.append(newTuple)
rows = [(i, ("none",)) for i in rowData]
columnHeaders = ["", "", "", "Notes", "Amount", "Total"]
fileName = 'CashFlows_' + datetime.datetime.now().strftime("%I%M%p_%B%d_%Y") + '.xls'
excelBuilder.setRows(rows)
excelBuilder.setColumnHeaders(columnHeaders)
excelBuilder.setStartingPoint(2, 0)
excelBuilder.setFileName(fileName)
excelBuilder.setTableColumnWidth(6000)
excelBuilder.setSheetName("Cash Flows")
excelBuilder.buildSheet()
excelBuilder.sheet.col(0).width = 4000
excelBuilder.sheet.col(1).width = 4000
excelBuilder.sheet.col(3).width = 2500
excelBuilder.sheet.col(4).width = 2500
excelBuilder.sheet.col(5).width = 2500
def saveMagic(self):
timeFrame = (stringToSecs(self.mFields['startDate'].text+":0:0:0"),stringToSecs(self.mFields['endDate'].text+":0:0:0"))
self.app.timeFrame = timeFrame
self.app.councilName = self.mFields['collegeName'].text
self.app.cashInBank = self.mFields['cashInBank'].text
self.app.cashOnHand = self.mFields['cashOnHand'].text
self.app.preparedBy = self.mFields['preparedByName'].text+"\n"+self.mFields['preparedByPosition'].text+"\n"+self.mFields['collegeName'].text
self.app.notedBy = self.mFields['notedByName'].text+"\n"+self.mFields['notedByPosition'].text+"\n"+self.mFields['collegeName'].text
self.populateTree()
def revertMagic(self):
tFrame = self.app.timeFrame
if tFrame!=(0,-1):
self.mFields['startDate'].text=secsToDay(tFrame[0])
self.mFields['endDate'].text=secsToDay(tFrame[1])
else:
dt = datetime.datetime.now()
self.mFields['startDate'].text=str(dt.year)+"-"+str(dt.month)+"-"+str(dt.day)
self.mFields['endDate'].text=str(dt.year)+"-"+str(dt.month)+"-"+str(dt.day)
self.mFields['collegeName'].text = self.app.councilName
self.mFields['cashInBank'].text=self.app.cashInBank
self.mFields['cashOnHand'].text=self.app.cashOnHand
while len(self.app.preparedBy.split("\n"))<2:
self.app.preparedBy = self.app.preparedBy+"\n"
while len(self.app.notedBy.split("\n"))<2:
self.app.notedBy=self.app.notedBy+"\n"
self.mFields['preparedByName'].text,self.mFields['preparedByPosition'].text=self.app.preparedBy.split("\n")[:2]
self.mFields['notedByName'].text,self.mFields['notedByPosition'].text=self.app.notedBy.split("\n")[:2]
def save(self):
pass
def filterNotes(self,notes):
start,end = self.app.timeFrame
rvList = []
if notes:
for i in notes:
noteParents = [note for note in self.app.listNotes(False) if note.noteNumber.content==i]
nonODN = [note for note in noteParents if note.identifier!="ODNote"]
rvList+=[note.noteNumber.content for note in noteParents if note.identifier=="ODNote"]
rvList+=(list(set([note.noteNumber.content for note in nonODN if int(note.dateOfTransaction.content)>int(start) and int(note.dateOfTransaction.content)<int(end)])))
return ','.join(list(set(rvList)))
else:
return ""
def delete(self):
pass
