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???