Time Tracker

SELECT 
	DATE(start) as day_worked,
	login as contractant, 
	tag as customer,
	@fee as fee_by_hour,
	CAST(sum(TIME_TO_SEC(TIMEDIFF(stop,start)))/3600 AS DECIMAL(10,2) ) as hour, 
	CAST(sum( TIME_TO_SEC(TIMEDIFF(stop,start))/3600)   * @fee AS DECIMAL(11,2)) as fee
FROM event
GROUP BY day(start),login,tag 
ORDER BY day_worked DESC;

My plan for world domination

• Dont put math and tedious in code : most database are better for counting than programmation language (clean, portable and efficient implementation of IEEE, iso standards on computation and formats) ;
• Dont optimize as long as it is not ended : therefore SQL wont be in stored procedure (as long as it is not finalized);
• Dont take responsabilities you need not : these code snippets intends to work in a protected realm, therefore I dont intend to store password because time tracking could be (and I plan it) be integrated in something else like squirrelmail wich does a perfect job for authentification ;
• Dont try to swallow a bigger piece that your stomach cant stand, therefore the problem is cut in different pieces (storing events, showing events, presenting an invoice ...) that will be glued in the end after each piece will haveproved to work ;
• Think of humans, I intend to store finer customer logic in a quite human readbale format (NOT XML) like YAML because so many language have adopted it, therefore it will be easier to eventually implement a separate front end for its edition ;
• Have fun, I inted to use perl, why ? Because ! I used PHP because I just finished a PHP assignment, I however find it as un-pleasent as object programming in perl. However I still prefer perl that has numerous module (like pdf class,ORM,YAML parsing) that will prove helpful when dealing with more complex task
• I will do some ajax for fun too ^_^

And above all I want a software as easy to use as a washing machine

Roadmap

Start stop Event

This is the root. I want a pretty simple logic : I don't work for 2 customers at a time, I therfore cannot begin a task while another is running.

Timesheet

Being able to report to costumer how much time I worked for them.

Evil calculation

In accordance with my lawyer and sales partners abilities for establishing contract, I intend to be able in the country where we are supposed to work 35hours a week, to begin to work less as 48 hours a week (the supposedly maximum in all developped countries that signed the International Worl Organisation / Bureau International du Travail).

Lazyness

If I get bored, I will try to have invoice being print, formated, and emailed.