8:00 – 2:30 SR

• Make the list for approval a global – done
• Add a “required” config for items. Grids that gave an empty required field remain yellow
• Make “add’ trigger a save. If there is no project name, add a dialog that forces that – done.
• Make the lab dropdown loads from a config file – done.

8:00 – 5:00 SR

• DB Backups
• Task number query is messing with taskID query – removed taskID query. Junit test seems OK
• add multiple role checks during login. – Added to java code. Passed Junit.
• Scrollbars is not working. Test with other browsers. Tested and all seems to work. added reset-min.css to see what gives.

8:00 – 4:00 SR

• DB Backups
• Deployed FR, FA, RA
• Need to add Project Number to comments – done
• Need to format HTML – done. That’s a wierd one, too. If you’re using a div, then setContent() getContent() works like a charm. But since I’m using IE8 compatable textarea, I have to convert CR to <br/>. using JavaScript’s replace() function to do it all by regex.
• Need to add scrollbar to FundingRequestPanel – done
• Remove “Testbed” – done

8:00 – 4:30 SR

• DB Backups,
• Deploy new FR, FA, RA and db updates to production server
• Change queries top use login and fr_name
• Change queries to inner joins
• Handle load of empty project
• Work on task number insert query
• Change it so that other roles can see all FRs
• Junit tests
  • Bad login
  • Good login
  • Empty project
  • Create project
  • Update project delete project

8:00 – 4:00 SR

• DB Backups
• Deployed more fixed FRF app. All seems to be working. Logging is working!
• Get dev env working on the laptop.

8:00 – 5:00 SR

• DB Backups – done
• Deploy new FR app – done
• Update index page with link and description – done
• Removed “Update” button for a while
• Need to add top and bottom marking <div>
• Add delete FR and delete row functionality to client
• Update should “add” if there are no rows
• Make sure that the year is greater  or equal to today – done
• Add validators to update
• Add logger – done
• Send error message back to client for alert.
• Make sure that date parser is correct – may need to add one to month – done
• leave ‘@’ in string validator – done
• Add default zeros in number fields – done
• Realized that using delete/add would cause artifacts in the DB, changed it so that the table has the old funding request deleted before the new one is added.

8:00 – 6:00 SR

• Woke up at 3:30 thinking about the loading problem. Thoughts are in the previous entry.
• Deployed the new version, which went nicely.
• Discovered a problem with IE8. Comments (//) in the <style> section don’t work, and the following needs to be added to the .panelButton style:
  • display: inline-block;
  • float: left;
• Onward…
• Made all the changes to FundingRequestPanel and things are working. Still need to add the adjustment of the fr_master_table for Submit. If the testing works out, then things are kind of beta?
• Add deleteRow() and deleteFR() to java. Done
• Integrated new save

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.

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:

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.

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.

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());