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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: