Category Archives: Flex Client

Dong Shin 11.11.2010

  • find duplicate projects functional
    • when services and totals of FY amount match
    • using query below, create dynamic FY values
  • find duplicate projects query
    SELECT p.uid, project_id, center_number, center_name, year, services, SUM(IF(year=1, amount, 0)) as FY1, SUM(IF(year=2, amount, 0)) as FY2, SUM(IF(year=3, amount, 0)) as FY3 FROM `budget_centers` b, budget_amounts a, projects p  WHERE begin_year=2010 AND end_year=2012 AND p.uid = project_id AND b.uid = budget_center_id AND services = ” AND p.uid = @lid GROUP BY p.uid ORDER BY p.uid

Dong Shin 11.09.2010

  • diable creating Funding Request on INCOMPLETE projects (total_funding = 0)
  • PPM bugs from Phil/Christina 11/09/2010
    • unable to update Contracts – fixed
      • UID must not be set on UPDATE
    • sort enabled on Project Mgmt Panel
    • Projects with < $0 Total Budget gets warning and recalculated
    • added refresh on unlock in Project Mgmt Panel
    • fixed horizontal scroll control showing up on Budgets Grid
    • resize Add Comment/View Comments buttons

Dong Shin 11.08.2010

  • working from home
  • packed up PPM for review.
    • new tables structure – project_portfolio_additional_tables_110810.sql
    • complete db dump – project_portfolio_complete_test_data_110810.sql
    • uploaded files to /exchange/PPM_110810
  • added project duplicate check on creation – Project ID and Name only for now
  • added Funding Request generation from Project Mgmt Panel
    • for COMPLETE projects only

Dong Shin 11.05.2010

  • PPM enhancements
    • separated Comments Window into two
      • Add Comments
      • View Comments
    • added filter/search for View Comments
    • added add/view comments to Financial Data Editor (Project Viewer)
    • disable opening of financial data of non-editable project
    • tweaked Dynamic Panels to maximize – at the end of data retrieval???

Dong Shin 11.02.2010

  • PPM enahancements
    • Create/Modify/Edit project now has multiple contact entries using ComboBox
      • saves single entry into projects table, more than 1 goes into separate relational tables – this is done to preserve the existing data
    • Project Management uses ComboBox ItemRenderers for the multiple contacts, single contact shows up as a label
    • added ItemRenderer for Total Budget
    • working on Project Mgmt event handling (Create, Edit, Copy, Delete, Refresh)
    • Added TabNavigator for Search and Filter

Dong Shin 11.01.2010

  • PPM enhancement
    • search functioning on Project Mgmt Panel
      • disables filter on search
      • still need to tie the buttons to other panels
    • added multiple contacts for Project Manager, Finance POC, Portfolio Mgr, Portfolio Admin
      • duplicates will be ignored
      • contacts in project table cannot be NULL! set it to ”
      • save works….

Phil 10.27.2010

7:30 – 2:00 VISIBILITY

  • Fixed the table that was misbehaving for Anne. It turns out that you can’t have a ‘/’ in a column header and still expect Google SQL to handle it. Need to add that to the substitutions in the ingestors
  • Working out a fancier password system. Done. To test, I’ve put Tom’s Dong’s and my accounts into the system. If it’s working tomorrow, we’ll transfer more of the accounts over

2:00 – 3:00 FP

  • Demo for Mike F. and Scott G.

Phil 10.26.2010

8:00 – 5:00VISIBILITY

  • Well, the server is mostly back up
    • Wrote up a description of what happened for Laurie
  • Got additional req’s from Christina for PPM. Went over them with Dong.
    • Open multiple projects for editing or modifying
    • A “back” button that re-launches the previous panel. The best way to do this may be to extend the LayoutManager to store the panel with an associated data object? Unsure about this
    • All personnel fields should be able to handle multiple entries. I’m thinking that a variant on the “Add New” combobox might work here.
    • The Portfolio Manager in a funding request also needs to handle multiple entries
    • Look for duplicate projects. The thought is that if the budget values and the service match, then an alert could be shown that warns of the potential match
  • Flex in a week
    • Day 5, Episode 2
    • Day 5, Episode 3
    • Day 5, Episode 4
  • Anne had some problems with a query not showing up in the data visualizer. Will try and see what’s up tomorrow.

Phil 10.25.2010

7:30 – VISIBILITY

  • PPM is getting used. Talked to Christie Richard, who is entering most of the data. She has a list of suggestions
    • She needs to be sysadm to view projects she creates. We need to make it so that if you create a project, you should still be able to see it.
    • We need to make it so that projects can be created piecemeal. The minimum amount of information should be the project name and ID, but after that, the user should be able to enter data in any order or amount.
      • An incomplete project is one that does not have all the fields plus (sufficient? e.g. something other than all zeros) financial data entered.
      • There should be an INCOMPLETE warning in the title bar if a project is not sufficiently entered. Maybe we can flag that in the project list by highlighting the row, or being able to filter on incomplete projects.
      • It might be worth having an alert come up that indicates what still needs to be done on an incomplete project.
    • She’d like the ability to enter more than one POC for a project. Need to find out just what fields those are. Is this just on project creation or also other forms, such as creating funding requests
    • Add a per-project comment log. It should be visible on the project page and the enter financial data forms (Maybe funding request as well?). There should be an entry field that is editable, and then a text area (searchable?) that shown entries with timestamps and user id.
  • Worked on the MavenAssist site with Dong. The updater site is up, as is a download site. The home page is prettier (it’s a copy of our own web page on MavenAssist)

Mike 7.30.2010

  • Still working on autocomplete text area
  • Have a popup list with options popping up correctly when I press ctrl+space, may add smarter logic for this later but this seems fine for now
  • Popup currently always appears in the top right corner of the text area.  Finding the x-y position based on the caret index in the text field may prove complicated so I’m saving it for once the proof of concept is working

Mike 7.19.2010

  • “Blank” rows no longer show up in the flex widgets.  A row must contain at least one entry that is not an empty string or a single space character ignoring the “uid” and “timestamp” fields.  Side note: somehow some completely empty excel cells are being converted to a single space character on ingest
  • Installed Flex 4 and got distracted by that for awhile…
  • Added a settable actionMax variable to the network widget.  The movement threshold slider in the settings now has two variables which can be set: one which sets the minimum movement required to animate and one that defines the farthest a smartshape can move in a single frame.  No more crazy dancing smartshapes.

Mike 6.30.2010

  • Fixed a bug with multiple selection and the map widget
  • Any selections made in the map widget are now reflected in the data tab of the AdvancedQueryWidget
  • Tried to help Phil with some build problems but of course when you expect something to fail it works just fine…
  • Added a “New Widget’ button to the network widget.  Clicking it while in either the map mode or the connection list will spawn a new AQW with both the selected nodes and any connections that refer to them.