31 Oct 2007
It's done!!! The CCT is (though it needs some more testing and validation by Rich) done!! At least the user side. I'll need to start thinking about the administrator's side.

TODO list 12 Oct 2007
X Sample Activity at top as guide (halfway done with this)
X label the skills as being a list of skills
X make the print-out look like what's on screen (ie css instead of ez_pdf. this will be the biggest hurdle)
X IE compatibility
X No header on help pop-ups
X write help files myself (except for the general help)
X be sure to clear out the test activities that wouldn't look good at a demo
- meet again in early november

12 Sept 2007
-Looked into ezpdf.

10 Sept 2007
-Continued documenting code.

9 Sept 2007
-Added a yellow color for editing box
-Consolidated a little code in cct.php (merged the submit and edit conditionals)
-started work on documentation

7 Sept 2007
-Fixed activity type field display bug

4 Sept 2007
-Began working on fixing the delete confirmation box javascript code.

3 Sept 2007
-Resumed worklogging.
-Cleaned home dir out of summer refuse
-Investigated the new repos
-Worked on back-up scheme for cct files (until i can get them working in the repository)
-emailed dylan about svn help

31 July 2007
-in at 1000
-Continued redesign of record printing; ironed out bugs and enhanced readability greatly.
-Fixed overflowing skill list ( wrapped it and the creation form in a height-coded div)
-Fixed mystery <br /> tags; they were from the one echo i missed during the final refactoring.

30 July 2007
-in at 900
-actRole now both reloads its other field and reselects other option.
-Matured javascript code to handle toggling other fields instead of just showing them in edit/create form.
-added confirm delete box
-fixed bug that resulted in the same id for every option in drop downs (solution: don't give the options ids. they don't need them)
-Completely redesigned code for printed records; much easier to read now

27 July 2007
-in at 1030
-actName now both reloads its Other field and reselects Other in its drop down
-rewrote driving for loop in getDropDown
-left at 1700

26 July 2007
-in at 900
-Fixed bug in cct.php regarding activity type fetching
-got VB.NET installed on my laptop; realized i lacked a usb key to transfer stuff over, will do tomorrow
-actName now reloads its Other field on fail

25 July 2007
-In at 930
-Found backup of webDB an restored to a working state.
-reimplemented history research update
-ran scripts for mark P and sent him output
-out at 1700; 6.5 hours of work.

18 July 2007
-In at 845
-Released update to webDB for History Research course deisgnation -Pretty much everything went to hell

10 July 2007
-In at 1000 (oversleep + hour commute)
-Finished refactoring (JS was last step)
-Began testing new code...
-Fixed typos and logical errors in the record printing sections
-found new, refactored code to be MUCH easier to deal with...it assembles all necessary dynamic data at the top then a static HTML dump merely echos the right variables.
-left at 1730; 6.5 hours of work.

9 July 2007
-In at 900
-Still refactoring. Finished rewriting getDropDown and added function getPossibleDates. Removed all globals from program as well as setMessage function. cctHtml is now much clearer, though I haven't tested it yet.
-Once I tidy up a little JS I'll be ready to test.

6 July 2007
-Got in at 845
-Tested new password for frog (in load_from_banner script)
-continued refactoring:
+wrote code necessary to display edit form
+rewrote certain parts of getDropDown
+fixed miscellaneous typos
-left at 1630; 7.25 hours; 67.5 for the week.

5 July 2007
-Got in at 900.
-Worked more on javascript. Realized that current structure of cctHtml is woefully inefficient and veritably illegible. Began probably the last refactoring of this script. Worked on this all day.
-Left at 1800; 8 hours of work.

2-3 July 2007
-Parents here, worked weird hours (5-6 hours during day, 1-2 at night) -Worked on javascript and HTML.
-Finally got working solution to the JS bit. had to hack extra at the begin and end date boxes.
-Implemented hilighting changed entries on update/submit
-Realized that JS didn't yet apply to edit form; fixed that. just need to style it.
-Allowed for case flexibility in dates...first letter of term can be upper or lower. debating whether to check beyond this - but really, will people be typing in fAll?

29 June 2007
-Finally got printDropDown menu somewhat consolidated and working.
-Researched javascript
-started writing necessary JS
-left at 1730; 7.5 hours of work.

28 June 2007
-Got in at 900
-Worked on printDropDown method
-Fiddled with curses for randy
-left at 1645; worked 6.75 hours

27 June 2007
-Got in at 900
-Fixed date method; PHP was doing a nasty behind the scenes string -> int conversion. fixed with some parens.
-Dates now reload on fail
-Test case expanded to account for date update
-Cleaned up edit form
-Fixed bug in printRecord() - $messageCode was not declared global.
-Edit form now loads dates the way it should when edit is first clicked
-Successfully refactored much of cctHtml. Replaced individual drop down printing functions with unified function printDropDown, which takes a drop down type and optional record array. It's smart enough to know which default to select. cctHtml is now much cleaner; all the text boxes in the edit and submit forms have been replaced by pre-populated lists.
-Need to fix bug in printDropDown for $currentAction == 'edit'
-Updated cct.pm with methods:

• getActNames
• getRoles

-left at 1800; worked 8.5 hours

26 June 2007
-Figured out how to test for reload; decided that now was a good time to implement dynamic date selection.
-Wrote method to do date selection ( printDateDropDowns ), but the array-filling has an error
-Cleaned up some miscellaneous bugs in the code.

25 June 2007
-Finally fixed apostrophe parsing for good. Needed two separate str_replace calls for each string.
-Added line around activities display
-Wrote more test cases...
-Currently trying to figure out how to determine if a reload from post on error was successful

22 June 2007
-Figured out how to redirect echo/print output in PHP using ob_start/ob_end_clean.
-finished faking a login to webdb.
-blocked my test script off from web access.
-wrote testSuite.pm; it can be used to locally test webDB stuff by faking a login and logout.
-got test script working. worked on adding test cases all day.
-fixed bug that ocurred on empty skill selection
-left at 1645; 6.75 hours of work (75 for pay period)

21 June 2007
-Got in at 1000
-Updated test data population scripts to match new linkPtoA signature
-backend mysteriously stopped working; seemingly random combinations of restarting apache, recreating DB, and refreshing page fixed it.
-Corrected an edit form error.
-Worked around magic quotes bug in valificate(), printSubmitDiv(), and printEditForm()
-added refresh button
-Started work on php test script
-Left at 1900; 8 hours of work

20 June 2007
-got in at 845
-Worked more with kevin, got to a workable state.
-implemented editing.
-successfully refactored CCT
-added php method: printEditForm()
-left at 1700; 6.75 hours of work

19 June 2007
-got in at 900
-Started to refactor CCT
-thoroughly ruined code
-worked with kevin
-left at 1800; 8 hours of work

18 June 2007
-Got in at 900
-Worked on getting new computer up and running;
++Installed Xubuntu 704 (kevin fixed install error using dd if=/dev/zero/ of=/dev/sda bs=4k count=10000 to wipe partitions on drive)
++Installed Sun Java and built jEdit
++Installed x-chat
++config'd environment
-implemented alternated colors for rows
-program now remembers skills on insert fail
-added reset button to submit form
-began implementing editing. Had good start, but the new code revealed a lot of poor coding on my part. I'm now restructuring the code using 4 state global variables that exist across included files. The various statuses of these state variables will determine a lot of the action that takes place. The cct is definitely broken now, but I'll spend tomorrow getting it working with this new paradigm.
-left at 1800; 8.5 hours of work.

15 June 2007
-Got in at 930
-Updated error message handling to use a global variable
-Implemented deleting
-Started work on a test-data input script - it's erring for some reason.
-left at 1630; 7 hours of work.

14 June 2007
-Got in at 845
-Touched up a few things for Rich; specifically the listing of dates in the date drop down menus.
-Fixed persistent 'Success!' message - i wasn't properly checking the BE's return value.
-Added delete and edit links
-Met with Rich; he was pleased. Took notes, will make requested immediate changes. Will resume weekly emails
-Coded framework for deletion. All that needs to be coded is the actual BE methods
-left at 1345; 4.5 hours of work.

13 June 2007
-Got in at 900
-fixed some miscellaneous insertion bugs (incl. apostrophes in input)
-Did Skills. Coded insertion and retrieval on both front and back end. decided on design scheme for skill listing. Lots of buggy toil but it seems to work fine now.
-left at 2030; 10.5 hours of work.

12 June 2007
-Got in at 900
-Continued debugging front end. Accomplished:
+restoring inputted data when a submit fails
+more careful checking of input (specifically dates - now checks to insure that end date isn't sooner than begin date.
+started working on skill linking
+caught case where student has no records
-left at 1700; 7.5 hours of work.

11 June 2007
-Got in at 1030
-Continued debugging HTML. Finally fixed overflowing div.
-Prettied up HTML; switched headers aroun, tidied divs (especially in the records display section)
-added in some dummy help links as placeholders for future functionality
-fixed submission code; activities can now be added (with error checking)
-started learning about constraints/triggers to handle date checking.
-left at 1900; 7.5 hours of work

8 June 2007
-Got in at 900
-Worked on cleaning up HTML; couldn't fix overflowing div and got lost in sloppy code - had messed up divs, poor format, etc.
-decided to start html over; began refactoring it.
-left at 4; 6 hours of work.

7 June 2007
-Got in at 930
-Sketched design for front end.
-wrote skeletal CSS styles; added to dev/php/styles.css
-wrote static html
-got decent draft of dynamic html. still some kinks to work out
-left at 1815; 7 hours of work

6 June 2007
-Got in at 900
-Worked with Kevin on debugging the front and back end. fixed numerous bugs involved in all aspects of the program. can now submit and retrieve records much more efficiently (and correctly).
-learned many new sql tricks (aliases and joining).
-Updated date handling in front end
-made todo list (order of precedence):

• front end design
• documentation in-code
• code clean up
• skill linking
• written documentation

-left at 5; 7.5 hours of work.

5 June 2007
-Got in at 900
-Finished underlying date mechanism. Methods added:

• newTerm($)
• getTermID($)
• newDateRange($)
• dateRangeInDB($$)
• termInDB($)
• getTerm($)

-Discovered jEdit folding. Eases things a lot.
-Incorporated date mechanism changes into linkPersonToActivity($$$$$$)
-Incorporated date mechanism changes into getActivities($)
-Began testing
-Left at 1630; 7.5 hours of work

4 June 2007
-Got in at 900
-Finished updating schema SQL, touched up the creation scripts.
-Switched from populating via SQL to populating via cct.pm + db.pm
-Worked on getting the new date set-up integrated with cct.pm
-learned about altering @INC (using a begin{} block)
-left at 1745; 7.5 hours.

1 June 2007
-Got in at 1000.
-Continued working on schema to update date mechanism
-Went through nightly scripts with Kevin
-Added lindsje1 to the wildman timesheet account as per her request (plus learned how to do it)
-Got key request form from Denise; must turn in to security
-Start giving timesheets to Lou Murray starting Monday
-left at 1800; 7 hours

31 May 2007
-Got in at 900. -Wrote code to sort records by date. Took long time; code is convoluted due to string/int conversion, the nature of the $records array, and a lack of whitespace trimming up front.
-Sorting code generated an infinite loop.
-Worked out column duplication error. In working out on board, Kevin noted that I made some (innocently) poor choices in my schema. I'm backing up now and using the date format for dates as well as the date table originally implemented in the schema kevin made. note to self: refer to that original schema more frequently.
-Date mechanism is inherently flawed. Will redo.
-left at 1800, 7.58 hours

30 May 2007
-Got in at 900
-Continued hacking away at front end, but decided that I needed to finish implementing dates and skill linking in the backend before i went any further.
-implemented date functionality
-encountered strange bug with cctTest.pl script - my cwd is being printed out for some reason after every method call (but before its return).
-left at 1800; 7 hours of work.

29 May 2007
-Got in at 900.
-Restored some changes lost due to a buggy suspend.
-Made rough first draft of CCT front end
-Made BE/FE todo list (post-it format)
-Added PHP helper methods get(Types, Skills)
-left at 1730; 7.5 hrs of work

25 May 07
-Got in at 900.
-Figured out how to access production DB
-Added myself to admin groups
-Added necessary payperiods for summer work
-Drew up whiteboard plans for front and backends of CCT
-Started work on front end interface.

24 May 07
-Got in at 900.
Had to replace corrupted 6.10 install as I ruined my package directory by accidentally suspending during a software update which, somehow, broke several parts of the OS.
-Set up (Sun) Java, SVN, jEdit, xchat, and my personal Ubuntu preferences.
-Connected to local IRC chats
-Joined PGSQL and MySQL mailing lists.
-worked on diagrams of front end and back end data flow / method calls
-Left at 1730; 7.5 hours of work

23 May 07
-Got in at 1430; set up work computer
-Left at 1745; with break for housing, 2 hours of work.

25 Apr 07
-Finished back end methods and wrote test script ( .../dev/perl/cctTest.pl )
-Restructured (Added additional include file but cleaned up cctStudent.php dramatically) the PHP and prepared to start enabling it to talk more fluently with my new back end methods.
New backend methods:

• getSkills
• getTypes

Todo:
-Fix getActivities method (PHP)
-Continue cleaning up PHP
-Think about precons/postcons and error checking (be & fe)

24 Apr 07
-Figured out weird error, it was a stupid mistake: I forgot to export the newActivity method.
-Added new functions:

• newActivity
• actInDB
• roleInDB
• newActRole
• linkPersonToAct

NO testing on these yet. That's for tomorrow.

23 Apr 07
-Finished getActivities method.
-Cleaned up PHP a little.
-Started newActivity method; weird error. Work on when less sleepy, it's probably a stupid mistake.

18 Apr 07
-Tracked perl errors through debugging & apache error logs; fixed some typos and got my php to work with be_call. only problem is, my perl script is returning a value from some unknown place ("hey world" as opposed to "returned"). I think it's using the wrong version of the script or something, but I can't even find any of my files with the word "hey" in them in the perl directory.
Began testing db access with perl using a locally run pl script (simply calls the method so i can check the return values).
TODO:
-Figure out why PHP isn't getting right return value
-Add date functionality to the database

17 apr 07
-Traced function calls that make frontend - backend transition. -created boilerplate cct.pl and cct.pm files in the dev/perl directory TODO: -Test. -Figure out esoteric (to me, anyway) perl code in other files. -ask Kevin about junk in .pm files (post subroutine declaration)

12 apr 07
Made one unified population SQL script;
updated perl scripts;
Recreate now uses the already created create/drop pl scripts.
Debugged escape character issue (set escape \).
Made my Rongo terminal a little friendlier.
Todo:
-Trace widget call; figure out when DB (via perl) communication occurs
-Revoke privs from webdb schema; give to alpha_new
-Update (re)creation scripts to do user/privs as well as tables & all data
-Fix referencing issue (Mtg with kevin today)
-Update PHP
-Update test scripts

11 apr 07
Updated command line scripts to work with sqlplus. Ran into problem with referencing the pidm column in both my and webdb's person view; will bring up with kevin.
Todo:
-Update population scripts
-Fix referencing issue
-Update PHP

10 apr 07
Finished converting create and drop SQL scripts to oracle-understandable code. Todo (in order of precedent):
-Fix cct's person view - it's too expansive.
-Figure out command-line script input
-Update Perl scripts
-Update PHP