Gentlemen, We have Liftoff … (continued)

Here is a cleaner self-contained zipped NetBeans 6.1 project, containing the source code and a compiled distribution:
apptracbeta11_src_dist.zip
If you are not using NetBeans [6.1] IDE, add the three JARs from apptracbeta11_src_dist.zip/AppTrac/dist/lib/ to project libraries.

And here is the zipped ready-2-run distribution:
apptracbeta11_dist.zip
Once you unzip it, run ../AppTrac_dist/AppTrac.jar.

You will need JRE6 to run AppTrac. We recommend downloading the latest JRE update (Update 6 at the time of writing).

Victor.

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

Workspaces

Workspace that doesn’t work: workspace1
And the one that works: workspace
And the missing report generator: reportgeneratorgui1

Rename the first two to .zip, and the third one to .java after downloading.

Interface/GUI Update

Here is my updated code for the GUI. It adds the interface for the user control panel. There is still no “generate reports” panel.

http://uhaweb.hartford.edu/padilla/d3/AppTrac-GUI-4-21-08.zip

Interface/GUI

I have been hard at work on the interface and this is what I have thus far:

http://uhaweb.hartford.edu/padilla/d3/AppTrac-GUI.zip

It is in no way complete. I also have altered some of the methods and have some general questions when we meet again. Take a look at it and let me know what you think.

AppTrac DataBase

The AppTrac database design those of us present at the 04/18/08 meeting all agreed on is this:

The database in the form of SQL code can be found here (rename to .zip after downloading). Content still consists of the leftovers of John Manchester’s original design, and some table(s) lack(s) it altogether.

‘log_sessionid’ field from the ‘apptraclog’ table can consist of the concatenation of ‘user_id’ and ’log_timestamp’ of their login. This way session ID will be unique per user per session. Session here is defined as the period of time containing all events from login to logout (inclusively) of a particular user.

Java Examples

John Manchester was kind enough to share the following links to two Java examples we could use:

A Swing Demo (Login Screen)

Password Demo

Loading applications

Test strip:
public class testopen
{
public static void main(String[] args) throws Exception
{
Runtime rt = Runtime.getRuntime();
Process p = rt.getRuntime().exec(“c:\\windows\\system32\\notepad.exe”);
p.waitFor();
}
}

//spaces in the path MAY need extra quotations.