all data is live and searchable



« Back . [new search - developer's notebook] . [new search - adilas community funded projects]
Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Yellow
Assigned To: Brandon Moore
Created By: Brandon Moore
Created Date/Time: 6/12/2017 5:22 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
Priority: 0
 
Time Id: 2768
Template/Type: Brandon Time
Title/Caption: Brandon's Custom Projects
Start Date/Time: 6/27/2017 2:00 pm
End Date/Time: 6/27/2017 5:30 pm
Main Status: Active
Sorry, no photos available for this element of time.

Notes:
On a GoToMeeting session with Steve. We were working more on the sales tax expansion project. I spent most of the day working on the invoice line items and coding the updates for them. Tons of updates with pagination and looping over corporations to handle corp-specific updates and tables.

One break through for the day was adding two columns instead of just one for the sub reference id and the sub reference id list. One is a real id and allows us to join tables and do quick look-ups. The other is a string or varchar field and allows us to insert a list of id values if needed (small one-to-many relationship vs. a straight one-to-one relationship). Anyways, we decided to do the same thing with the time id and the time id list. This allows for both one-to-one's and one-to-many's. This may be pretty cool.