- Financial Data navigation in Project Assistant
- takes to the beginning of the records when option changes
- combined checkbox navigation – done
- working on current months navigation – done coding
- testing would take a while….
- revised the Budget Details query to ignore $0 budgets and years beyond current year
- SELECT c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count, r.duration,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_1), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_1), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_1_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_2), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_2), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_2_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_3), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_3), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_3_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_4), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_4), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_4_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_5), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_5), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_5_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_6), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_6), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_6_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_7), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_7), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_7_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_8), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_8), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_8_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_9), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_9), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_9_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_10), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_10), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_10_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_11), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_11), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_11_status,
IF (amount = 0 OR o.year + o.year_count – 1 > 2012, ‘IGNORE’, (IF(SUM(IF(ISNULL(month_12), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_12), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)))) as month_12_status
FROM budget_centers c, obligations_outlays o, budget_amounts a, appropriations r, projects p
WHERE p.uid = 174 AND c.project_id = p.uid AND c.uid = a.budget_center_id AND a.year = o.year – p.begin_year + 1 AND c.uid = o.funding_id AND c.appropriation = r.type
AND o.type <> ‘Reported Outlay $:’ AND o.type <> ‘Outlay $ (Reported in FACTS)’ GROUP BY a.uid, o.year, o.year_count ORDER BY c.uid, o.year, o.year_count
- SELECT c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count, r.duration,
Dong Shin 11.29.2011
- working on Financial Data Navigation on Project Assistant
- simple navigation done – single status navigation
Tom DeVito 11.29.11
Start: 10:00
- Finished the testing sandbox for datadictionary. Its strange, it uploads with some errors about the class object not being there, it doesn’t crash during runtime, but still doesn’t work. It is actually using the class which is having the error to send the serial data back.
- Still trying to figure this out. I have decided its not necessary on the arduino side. The DataDictionary will still work in the main sketch so the transfer from the PC side will work fine it just won’t be able to be used in the other classes which don’t really need it considering there is no graphical interface or anything else to interact with on this side.
- Rewrote the ComUtil class to work without the DataDictionary.
End: 6:00
Mike 11.29.11
- Finished things up in the phone app:
- Implemented filtering in the ColumnView
- Removed the filtering option in the TableView
- Made the map markers DPI dependent
- Few other small fixes
- Looking in to GWT / Java Enterprise Architectures, specifically 3-tier application architectures
- Fiddling around with GWT Examples
Phil 11.29.11
7:30 – 3:30 VISIBILITY
- Sent a note to Vernon CCing all the players stating that I was getting nowhere on testing. He gave me some new people to try.
- More GWT
- GWT anti-patterns: http://www.zackgrossbart.com/hackito/antiptrn-gwt/
- Communicating with the server via GWT RPC.
- Retrieving JSON data via HTTP
- Unit testing with JUnit
- Running a GWT application on Google App Engine
- Starting the GWT Designer tutorial
- Installing
- Tutorial: Creating a Login Manager Application with GWT Designer
- And here’s the result. Very cool interface.
Thomas DeVito 11.28.2011
Start: 9:45
- Upon clicking the compiler error, I found that for some reason it was using a different DataDictionary then the one seen in the project folder. I was able to make the changes and compile.
- For some reason Visual Micro is not able to make the objects properly when trying to deploy.
- Something went very wrong with Visual Micro, none of my sketches will compile now.
- Reinstalled Visual Micro which was actually kinda annoying. Not only did you have to delete it but you also had to go in the setting and disable the mod that did shouldn’t be installed.
- Visual Micro is now able to compile working sketches again
- The DataDictionary is still making a weird error message. I commented out all the instance of it and found that there are no errors if it is only declared in the main sketch.
- Uncommeted the datadictionary in ComUtilB, I still get a weird error message but the sketch seems to be sent.
- Setting up a sandbox to test datadictionary from a class. All previous tests were done in the main sketch. I have a feeling it will work but I will still get the weird compiling messages.
End: 5:45
Phil 11.28.11
8:00 – 4:00 VISIBILITY
- Ran backups. Data *is* being entered.
- Working on the GWT tutorial. At step 5 now.
- And here is the working version: http://fgmdev.com:8080/stockwatcher/StockWatcher.html
- Next things to look at:
Dong Shin 11.28.2011
- revised Budget Details Query so that the navigation is bit easier….
- SELECT c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count, p.duration,
IF(SUM(IF(ISNULL(month_1), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_1), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_1_status,
IF(SUM(IF(ISNULL(month_2), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_2), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_2_status,
IF(SUM(IF(ISNULL(month_3), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_3), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_3_status,
IF(SUM(IF(ISNULL(month_4), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_4), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_4_status,
IF(SUM(IF(ISNULL(month_5), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_5), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_5_status,
IF(SUM(IF(ISNULL(month_6), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_6), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_6_status,
IF(SUM(IF(ISNULL(month_7), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_7), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_7_status,
IF(SUM(IF(ISNULL(month_8), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_8), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_8_status,
IF(SUM(IF(ISNULL(month_9), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_9), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_9_status,
IF(SUM(IF(ISNULL(month_10), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_10), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_10_status,
IF(SUM(IF(ISNULL(month_11), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_11), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_11_status,
IF(SUM(IF(ISNULL(month_12), 1, 0)) >= 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(month_12), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as month_12_status
FROM budget_centers c, obligations_outlays o, budget_amounts a, appropriations p
WHERE c.project_id = 173
AND c.uid = o.funding_id
AND a.budget_center_id = c.uid
AND a.year = o.year_count
AND c.appropriation = p.type
AND o.type <> ‘Reported Outlay $:’ AND o.type <> ‘Outlay $ (Reported in FACTS)’
GROUP BY o.year, o.year_count
ORDER BY c.uid, o.year, o.year_count
- SELECT c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count, p.duration,
- looks like a separate list of current months’ status is needed to handle all/current months navigation…
- query
- SELECT o.year, o.year_count, o.project_id
IF(SUM(IF(ISNULL(o.month_2), 1, 0)) = 4, ‘OVERDUE’, IF(SUM(IF(ISNULL(o.month_2), 1, 0)) > 0, ‘INCOMPLETE’, ‘CURRENT’)) as status
FROM obligations_outlays o
WHERE o.project_id=172
AND (o.year + o.year_count) = 2013
AND o.type <> ‘Reported Outlay $:’ AND o.type <> ‘Outlay $ (Reported in FACTS)’
GROUP BY year, year_count
- SELECT o.year, o.year_count, o.project_id
- query
Phil 11.25.11
8:30 – 12:30 VISIBILITY
- Rode in today – that should burn a calorie or two
- Tried creating an HTML page using the eclipse gwt wizards and had the same problem. I’m going to try the tutorial from Google to see if I get any different results.
- It seems as though this is a known bug, and has been around for a long time. The fix is to manually create the html.
- Though if you create a project with default code in it, all the pieces are created without the widgets and you just need to change the source. Which explains why the bug has been unfixed for so long.
- Saving the changed code shows in the browser on refresh. Very cool.
- The proper way to do event handlers in GWT.
Dong Shin 11.25.2011
- created ItemRenderer and skin for Month Status ComboBox
- realized that Reported Outlay and Outlay $ (Reported in FACTS) are not shown to Project Managers. These should not be counted in Project Status
- new Query
- SELECT
IF ( (((SUM(IF(ISNULL(month_1), 1, 0)) = 4 OR SUM(IF(ISNULL(month_2), 1, 0)) = 4) AND o.year+year_count=2013) OR ((SUM(IF(ISNULL(month_1), 1, 0)) = 4 OR SUM(IF(ISNULL(month_2), 1, 0)) = 4 OR SUM(IF(ISNULL(month_3), 1, 0)) = 4 OR SUM(IF(ISNULL(month_4), 1, 0)) = 4 OR SUM(IF(ISNULL(month_5), 1, 0)) = 4 OR SUM(IF(ISNULL(month_6), 1, 0)) = 4 OR SUM(IF(ISNULL(month_7), 1, 0)) = 4 OR SUM(IF(ISNULL(month_8), 1, 0)) = 4 OR SUM(IF(ISNULL(month_9), 1, 0)) = 4 OR SUM(IF(ISNULL(month_10), 1, 0)) = 4 OR SUM(IF(ISNULL(month_11), 1, 0)) = 4 OR SUM(IF(ISNULL(month_12), 1, 0)) = 4) AND o.year+year_count<2013)) ,’OVERDUE’, ‘CURRENT’) as status,
(
IF ((SUM(IF(ISNULL(month_1), 1, 0)) = 4 AND o.year+year_count=2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_2), 1, 0)) = 4 AND o.year+year_count=2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_1), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_2), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_3), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_4), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_5), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_6), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_7), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_8), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_9), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_10), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_11), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_12), 1, 0)) = 4 AND o.year+year_count<2013), 1, 0)
)
as overdue_count,
(
IF ((SUM(IF(ISNULL(month_1), 1, 0)) > 0 AND SUM(IF(ISNULL(month_1), 1, 0)) < 4 AND o.year+year_count=2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_2), 1, 0)) > 0 AND SUM(IF(ISNULL(month_2), 1, 0)) < 4 AND o.year+year_count=2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_1), 1, 0)) > 0 AND SUM(IF(ISNULL(month_1), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_2), 1, 0)) > 0 AND SUM(IF(ISNULL(month_2), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_3), 1, 0)) > 0 AND SUM(IF(ISNULL(month_3), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_4), 1, 0)) > 0 AND SUM(IF(ISNULL(month_4), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_5), 1, 0)) > 0 AND SUM(IF(ISNULL(month_5), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_6), 1, 0)) > 0 AND SUM(IF(ISNULL(month_6), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_7), 1, 0)) > 0 AND SUM(IF(ISNULL(month_7), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_8), 1, 0)) > 0 AND SUM(IF(ISNULL(month_8), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_9), 1, 0)) > 0 AND SUM(IF(ISNULL(month_9), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_10), 1, 0)) > 0 AND SUM(IF(ISNULL(month_10), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_11), 1, 0)) > 0 AND SUM(IF(ISNULL(month_11), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_12), 1, 0)) > 0 AND SUM(IF(ISNULL(month_12), 1, 0)) < 4 AND o.year+year_count<2013), 1, 0)
)
as incomplete_count,
c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count, p.duration
FROM budget_centers c, obligations_outlays o, budget_amounts a, appropriations p
WHERE o.project_id = 173 AND c.uid = o.funding_id AND a.budget_center_id = c.uid AND a.year = year_count AND c.appropriation = p.type
AND o.type <> ‘Reported Outlay $:’ AND o.type <> ‘Outlay $ (Reported in FACTS)’
GROUP BY o.year, year_count
- SELECT
Tom DeVito 11.23.2011
Start: 9:45
- For some reason, the ComUtil class would not include properly. Renamed it ComUtilB and it works again. No idea why I had to do this but it will help keep the arduino and pc versions from getting confused.
- The Singleton method of the DataDictionary is not working on the arduino side.
- Fixed a few things which were causing compiler errors, still can’t figure out why the singleton method isn’t working
- Checked to see if I was having the same problem on the PC side. It seems to be working fine.
- Googled “singleton arduino,” apparently it can’t be done in the standard way because the arduino is single threaded. There is a solution which I have yet to try in the second to last post: http://www.arduino.cc/cgi-bin/yabb2/YaBB.pl?num=1295472760
End: 5:45
Phil 11.23.11
7:30 – 3:30 VISIBILITY
- Hanging out on site. Reading lots of Communication of the ACM. Found some interesting things that I thought I’d share:
- Researchers say old helmets were just as good
- Military robots can leaver operators at home
- Researcher build a 3D-printed robotic spider
- Stanford posts six free online iPhone app device courses
- Army invites SMBs to compete to develop next-gen training tools
- True 3D technology emits 50,000 dots in 3D space – the truly startling images are around 1:15
- More GWT
- Ran into a but with the GWT HTML widget where it does not do the generation. A module and an entry point were created first, following the Manning book. (page 47). The buttons enable, but nothing happens. Same behavior on Mike’s machine. Try different orders on Friday?
Dong Shin 11.23.2011
- more PA changes
- queries done, tested
- changed BudgetCenter and created BudgetCenterDetail classes to map the new queries to AS objects
- overhauling Financial Data Navigator to use new data types
- realized that there could be more than one overdue/incomplete columns in a year, tweaked the query (longer!).
- SELECT
IF ( (((SUM(IF(ISNULL(month_1), 1, 0)) = 6 OR SUM(IF(ISNULL(month_2), 1, 0)) = 6) AND o.year+year_count=2013) OR ((SUM(IF(ISNULL(month_1), 1, 0)) = 6 OR SUM(IF(ISNULL(month_2), 1, 0)) = 6 OR SUM(IF(ISNULL(month_3), 1, 0)) = 6 OR SUM(IF(ISNULL(month_4), 1, 0)) = 6 OR SUM(IF(ISNULL(month_5), 1, 0)) = 6 OR SUM(IF(ISNULL(month_6), 1, 0)) = 6 OR SUM(IF(ISNULL(month_7), 1, 0)) = 6 OR SUM(IF(ISNULL(month_8), 1, 0)) = 6 OR SUM(IF(ISNULL(month_9), 1, 0)) = 6 OR SUM(IF(ISNULL(month_10), 1, 0)) = 6 OR SUM(IF(ISNULL(month_11), 1, 0)) = 6 OR SUM(IF(ISNULL(month_12), 1, 0)) = 6) AND o.year+year_count<2013)) ,’OVERDUE’, ‘CURRENT’) as status,
(
IF ((SUM(IF(ISNULL(month_1), 1, 0)) = 6 AND o.year+year_count=2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_2), 1, 0)) = 6 AND o.year+year_count=2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_1), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_2), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_3), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_4), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_5), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_6), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_7), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_8), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_9), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_10), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_11), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_12), 1, 0)) = 6 AND o.year+year_count<2013), 1, 0)
)
as overdueCount,
(
IF ((SUM(IF(ISNULL(month_1), 1, 0)) > 0 AND SUM(IF(ISNULL(month_1), 1, 0)) < 6 AND o.year+year_count=2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_2), 1, 0)) > 0 AND SUM(IF(ISNULL(month_2), 1, 0)) < 6 AND o.year+year_count=2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_1), 1, 0)) > 0 AND SUM(IF(ISNULL(month_1), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_2), 1, 0)) > 0 AND SUM(IF(ISNULL(month_2), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_3), 1, 0)) > 0 AND SUM(IF(ISNULL(month_3), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_4), 1, 0)) > 0 AND SUM(IF(ISNULL(month_4), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_5), 1, 0)) > 0 AND SUM(IF(ISNULL(month_5), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_6), 1, 0)) > 0 AND SUM(IF(ISNULL(month_6), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_7), 1, 0)) > 0 AND SUM(IF(ISNULL(month_7), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_8), 1, 0)) > 0 AND SUM(IF(ISNULL(month_8), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_9), 1, 0)) > 0 AND SUM(IF(ISNULL(month_9), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_10), 1, 0)) > 0 AND SUM(IF(ISNULL(month_10), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_11), 1, 0)) > 0 AND SUM(IF(ISNULL(month_11), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0) +
IF ((SUM(IF(ISNULL(month_12), 1, 0)) > 0 AND SUM(IF(ISNULL(month_12), 1, 0)) < 6 AND o.year+year_count<2013), 1, 0)
)
as incompleteCount,
c.*, a.uid as a_uid, a.amount as amount, o.year, o.year_count, p.duration FROM budget_centers c, obligations_outlays o, budget_amounts a, appropriations p WHERE o.project_id = 100 AND c.uid = o.funding_id AND a.budget_center_id = c.uid AND a.year = year_count AND c.appropriation = p.type GROUP BY o.year, year_count
- SELECT
Tom DeVito 11.22.2011
Start: 11:00
- The link I posted yesterday for using visual studio with the arduino only works with VS2008. There is a new link which was added to the bottom for a addin called Visual Micro: http://www.visualmicro.com/
- I was having a problem creating a arduino project. I had to reset the addins: http://www.visualmicro.com/post/2011/10/01/How-to-reset-the-arduino-visual-studio-interface.aspx
- Imported all the arduino classes into the project. I used the testing sketch to check and make sure it uploaded to the arduino, everything seems to be working. There are some red underlines here and there for no apparent reason but it compiles and transmits correctly.
- Everything is in one place now. Its much easier to see and edit all the classes from one place. Before I could only really see the main sketch and had multiple windows open for the classes.
- There are a couple bugs in the error checking. The IDE will red line some things which are actually not errors and compile fine. Still a vast improvement.
- The ComUtil class on the arduino side was not being included properly. Not exactly sure what I did but it is working now.
- Everything seems to be working properly in individual testing now. Putting it all together, hopefully will have something to show by end of the day tomorrow.
End: 6:00
Mike 11.22.11
- More waiting around at site for permissions
- Created a set of icons for the ColumnView page of the mobile app, added multiple versions for different screen DPI
- Updated the pie chart colors
- Added another logo screen for larger screen sizes
- Yearly review with Brian
- Various other bug fixes and polishing on the mobile app

You must be logged in to post a comment.