Gentlemen, We have Liftoff …

Well, after careful review, we seem to have a functional version of App-Trac!  User Adding, Application Adding, Application Loading all works.  Even better, time tracking now is in place.  Here is a simple query i wrote for the database to get some nice results:

select u.user_id UserID,
u.user_fname FirstName,
u.user_lname LastName,
ul1.log_timestamp TimeIn,
ul2.log_timestamp TimeOut,
a.application_name AppName
from   (select * from apptraclog where activity_id = 1) as ul1
inner join (select * from apptraclog where activity_id = 2) as ul2
on ul1.log_sessionid = ul2.log_sessionid AND ul1.log_id <> ul2.log_id
inner join apptracuser u
on u.user_id = ul1.user_id
inner join apptracapplication a
on a.application_id = ul1.application_id

also, i am uploading the code here:

app-tracbeta10

rename to .zip to extract.

Some minor issues to address:

-Loading applications will load an application twice

-Some of the interface screens do not take up the whole screen (which would be nice)

-status bar should be added (to let the user know that app trac is logging in)

-exit button needs to be moved

-report generation still needs to be done

-anyone up for avatars? it would be nice to have this

-application restricted access (no matter how hard i tried, i just couldnt get this down)

-exception handling structure all screwed up (easy fix, not too complicated)

Nice job to all =)  We have the requirements done…Next Phase, look and feel =D

Myles