Category Archives: VISIBILITY

Phil 8.5.14

8:00 – 6:00 SR

  • Submit button
  • Clear button – done
  • Why are the buttons turning yellow on load? State issues. Fixed
  • Check to see that users are not being changed on save.
  • Disable access to dropdown and remove NA from list – done
  • The Submit and changed users are the result of the data about a funding request (name, approval) are being saved in the FundingRequestPanel as part of each submission. There needs to be a fr_master_table:
    • uid: hash of frName and login
    • frName
    • status
  • This table will be used by FundingRequestPanel (FRP) only, and the FRP will not be stored in the fr_panel_table. Rows will not be kept in the table. Instead, the rows will be reconstituted. This means that a lot of the base class functionality (_fromArray(), _toJson()) will have to be rewritten to access the new table. Login will read from this table and if there is data to load, then the FRP will show. Maybe show it anyway, with a “New” button that fires a “FundingRequestPanel:clear” event.

Phil 8.4.14

8:00 – 2:30 SR

  • Add non-admin viewing logic to server code – done
  • Add ability to select requests by status (incomplete, submitted, rejected accepted) to req panel, then clear and re-run the query
  • Add submit functionality.
  • Set status to green when NA is selected.
  • Get the latest YUI-base for deployment and test – done
  • Make sure that the DB creation files are correct. – done
  • Make sure that the original user’s information is being saved when updated by Admin – done
  • Check https functionality.
  • Zip up and try deploying!
  • Fixed some bugs in the assembling of the queries. Also had to add a regex

Phil 8.1.14

8:00 – 5:30 SR

  • DB and webapps backup
  • Deployed new FA, but had to roll back because the FMPs were broken
  • Working on getting all the login permutations handled.
    • Added status return if no entries found.
    • Added fr_name parameter to the getPanel call.
  • Built the load query
  • Added a method that iterates through the array of results and builds the panel from that
  • Hooked op the FundingRequestPanel to the fromArray() method and connected it to the login. I still need to adjust the behavior based on whether the role is admin, but it works.
  • Added a load event to FundingRequestPanel
  • Added a method to grab the array of results and feed it to all the panels except FundingRequestPanel.
  • Tested and wporking for one funding request and the Administrator role.

Saved out and loaded in from the DB:

woohoo

Phil 7.31.14

8:00 – 5:00

  • Deployed new FA, RA
  • DB Backups.
  • Changed the query in the truancy report because SUM(0, null) != 0 + null in MySQL
  • Got the query built to construct a single response from the master/date/number/text tables :
    • select fpt.gid, fpt.panel_name, fpt.field_name, ftt.value from fr_panel_table fpt right
      join fr_text_table ftt on fpt.uid = ftt.uid where login = ‘projportfolio’ and panel_name =
      ‘fundingRequestsPanel’
      union
      select fpt.gid, fpt.panel_name, fpt.field_name, ftt.value from fr_panel_table fpt right
      join fr_number_table ftt on fpt.uid = ftt.uid where login = ‘projportfolio’ and panel_name
      = ‘fundingRequestsPanel’
      union
      select fpt.gid, fpt.panel_name, fpt.field_name, ftt.value from fr_panel_table fpt right
      join fr_date_table ftt on fpt.uid = ftt.uid where login = ‘projportfolio’ and panel_name =
      ‘fundingRequestsPanel’;
  • Getting the fundingRequestTable back with the login info
  • For tomorrow
    • Populate funding request panel
    • Populate other panels on load
    • Submit changes status and just saves, I think
    • Change the YUI library to point at a local copy
    • Zip and deploy???

 

Phil 7.30.14

8:00 – 5:00 SR

  • DB backups
  • New FA. There does seem to be a problem with the calculation for cell colors
  • Continuing with writing to the DB from the JS client
  • Chased down a bunch of bugs having to do with the way that fields were being loaded, particularly on the Funding Panel, where items are represented by sourceDivs
  • Set up the table structure so that guids are produced for each row on the client then used to match between the master table and the String/data/number tables.
  • Added the code to the servlet that inserts data, but haven’t connected it to the DB yet. Tomorrow.

Phil 7.29.14

8:00 – 5:00 SR

  • DB Backups
  • Wound up having to write a class that allows for the traversal of a JSON object, which I was not expecting and added a day to the effort. It’s based on the code up at json.org. Finished with the basics, and can recursively navigate and return key/value pairs or an array of Objects that match a given key. Tomorrow we’ll need to add capability (either to the JsonNav class or to the servlet that will write rows into the db.

Dong Shin 07.28.2014

  • deployed new FA with Req’s by Project queries
    • found that Query Builder adds where and group by clause – fixed
    • not saving queries – fixed
    • percent values should be calculated using Total Budgets, not Committed Amounts  – fixed
  • working on summarizing obligations, outlays, pm actuals for Req’s by Project queries

Phil 7.28.14

8:00 – 2:30 SR

  • DB Backups
  • Deploy new queries.
  • Remote object problems. Bounced the VM, which seemed to fix
  • Added a query to see who’d logged in today, so we can warn people before stopping the server.

Dong Shin 07.25.2014

  • working on Query Builder
    • disable obligated, outlays, pm actuals when query is using GROUP BY
    • adding queries by Req by Project
      • FY 13 Financial Status – done
      • FY14 Financial Status – done
      • FY14 Outlay Plan – done
      • FY14 Current Month Planned vs. PM Actuals – done, need to discuss what columns to show and how the calculations are done
  • working on new FMP editor
    • reworked the layout of the questions and added projectedDate field – sets label based on meeting Obligation/Outlay goals
    • added validators (question 1, 2, 3, projected date)
    • separated FinancialMitigationPlanContent from FinancialMitigationPlanWindow

Phil 7.25.14

8:00 – 5:00 SR

  • DB Backups
  • Added a event handler to get the comments.
  • Add clear() method. Nope, just used location.reload(true) to force a reload of the page from the server. Better!
  • Drat. I need it anyway, to prep for loading JSON. Done.
  • Save and Load should use the name in the FR name field. If the name is not in the list when save is pressed, it’s added to the list.
  • Work on save first, then load.
  • How to do a compound insert from Dong:
    • LAST_INSERT_ID() gives you the key/index of the last record inserted…..

      1. insert the first record

      INSERT INTO data_table (uid, data) VALUES (null, ‘data’)
      2. insert into master record
      INSERT INTO master_table (uid, some_data, key_to_data_table) VALUES (null, ‘some_data’, LAST_INSERT_ID());