ViewVC Help
View File | Revision Log | Show Annotations | View Changeset | Root Listing
root/ns_dev/Python/NinoCode/Active_prgs/IssueTrackerReporter.py
(Generate patch)

Comparing Python/NinoCode/Active_prgs/IssueTrackerReporter.py (file contents):
Revision 503 by nino.borges, Thu Jan 9 02:41:47 2014 UTC vs.
Revision 504 by nino.borges, Thu Jan 9 21:43:30 2014 UTC

# Line 70 | Line 70 | def FinishReport(outputFile):
70      """)
71      outputFile.close()
72  
73 + def GetProjectList(mwePlate,kpmgPlate,closedPlate):
74 +    """Combines the plates (not lists) into the project list, so that you can populate the project view"""
75 +    ## cycle through the 2 open lists and only pull from the closed list, if the proj exists in the first two.
76 +    ## Everything should already be in a matrix by catagory.
77 +    projectMatrix = {}
78 +    for i in mwePlate.keys():
79 +        for p in mwePlate[i]:
80 +            project = p[3]
81 +            if project in projectMatrix.keys():
82 +                projectMatrix[project].append(p)
83 +            else:
84 +                projectMatrix[project] = [p]
85 +    for i in kpmgPlate.keys():
86 +        for p in kpmgPlate[i]:
87 +            project = p[3]
88 +            if project in projectMatrix.keys():
89 +                projectMatrix[project].append(p)
90 +            else:
91 +                projectMatrix[project] = [p,]
92 +    for p in projectMatrix.keys():
93 +        print p
94 +        print str(projectMatrix[p])
95 +        print "---------------"
96 +
97 +
98   def SplitIntoPlates(exportFile):
99      openMWEList = []
100      openKPMGList = []
# Line 279 | Line 304 | def ProcessToHTML(currentMatrix,outputFi
304      outputFile.close()
305  
306   if __name__ == '__main__':
307 <    exportFile = "/Users/ninoborges/Dropbox/Misc/export_20140109_011143.csv"
308 <    indexFile = "/Users/ninoborges/Documents/ITO_Report/index2.html"
309 <    kpmgFile = "/Users/ninoborges/Documents/ITO_Report/KPMGs_Plate.html"
310 <    closedFile = "/Users/ninoborges/Documents/ITO_Report/Closed_Items.html"
311 <    projectViewFile = "/Users/ninoborges/Documents/ITO_Report/Project_View.html"
312 <    #exportFile = "T:\honeywell\export_20140106_191259.csv"
313 <    #indexFile= "T:\honeywell\ITO_Report\index2.html"
314 <    #kpmgFile = "T:\honeywell\ITO_Report\KPMGs_Plate.html"
315 <    #closedFile = "T:\honeywell\ITO_Report\Closed_Items.html"
316 <    #projectViewFile = "T:\honeywell\ITO_Report\Project_View.html"
307 >    #exportFile = "/Users/ninoborges/Dropbox/Misc/export_20140109_011143.csv"
308 >    #indexFile = "/Users/ninoborges/Documents/ITO_Report/index2.html"
309 >    #kpmgFile = "/Users/ninoborges/Documents/ITO_Report/KPMGs_Plate.html"
310 >    #closedFile = "/Users/ninoborges/Documents/ITO_Report/Closed_Items.html"
311 >    #projectViewFile = "/Users/ninoborges/Documents/ITO_Report/Project_View.html"
312 >    exportFile = "T:\honeywell\ITO_Report\Export\export.csv"
313 >    indexFile= "T:\honeywell\ITO_Report\index2.html"
314 >    kpmgFile = "T:\honeywell\ITO_Report\KPMGs_Plate.html"
315 >    closedFile = "T:\honeywell\ITO_Report\Closed_Items.html"
316 >    projectViewFile = "T:\honeywell\ITO_Report\Project_View.html"
317      openMWEList,openKPMGList, closedList = SplitIntoPlates(exportFile)
318      print "mwe list %s"%len(openMWEList)
319      print "kpmg list %s"%len(openKPMGList)
# Line 311 | Line 336 | if __name__ == '__main__':
336      FinishReport(open(indexFile,'a'))
337      FinishReport(open(kpmgFile,'a'))
338      FinishReport(open(closedFile,'a'))
339 <    FinishReport(open(projectViewFile,'a'))
339 >    FinishReport(open(projectViewFile,'a'))
340 >    GetProjectList(mwePlate,kpmgPlate,closedPlate)

Diff Legend

Removed lines
+ Added lines
< Changed lines (old)
> Changed lines (new)