RE: payperiods

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ok, that makes sense. I have all the payperiods specified in a table to
begin with, then just query selecting all >= start && <= end.

Thanks,

- Darren

On Tue, 2002-11-12 at 11:29, Peter Beckman wrote:
> Put the dates for employees into one table.
> 
> In another, put the payperiods.
> 
> You could populate the payperiods table for the next 90 years if you wanted
> if it is always on a 2 week schedule.
> 
> To look at past payperiods:
> 
>   select start, end from payperiods where start = '$querydate';
> 
> Or just date, but you'll have to decide if the date in the payperiod table
> will be the start of the payperiod or end of the payperiod. IE:
> 
>   select date as start,date_add(date,interval 14 day) as end from
>   payperiods where start = '$querydate';
> 
> Then get the employees who put in time between those days, assuming $pp
> contains the row found:
> 
>   select * from timesheets where date>={$pp[start]} and date<{$pp[end]};
> 
> Then you'd have all of the hours employees put in.  Then just sort by
> employee name (add a group by) and/or sum their hours, etc.
> 
> Pretty easy.
> 
> Peter
> 
> 
> On 12 Nov 2002, Darren Bentley wrote:
> 
> > Our payperiods will always be 2 week increments.
> >
> > So if I specify a starting day in the database I need to have that
> > starting day always updated to the current starting day. (when we switch
> > to the new payperiod), so as Jerrad mentioned I could use a cron job.
> >
> > But how would I be able to look at past payperiods? Lets say I want to
> > view a payperiod from September, then this method won't work.
> >
> > I'm trying to automate this so employees don't have to specify dates.
> > They just click the date on the calendar and enter their hours worked
> > per task.
> >
> > Then the accountants can go to a "summaries" page where they can click
> > on the staff member and view any current and past pay periods.
> >
> > This sounded easy when I first started :)
> >
> > Thanks again for the help!
> >
> > --
> > Darren Bentley / Systems Administrator
> > Borealis Internet / 1-800-667-0307
> > Prince George, BC, Canada
> > http://www.pgweb.com
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> 
> ---------------------------------------------------------------------------
> Peter Beckman            Systems Engineer, Fairfax Cable Access Corporation
> beckman@purplecow.com                             http://www.purplecow.com/
> ---------------------------------------------------------------------------
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
-- 
Darren Bentley / Systems Administrator
Borealis Internet / 1-800-667-0307
Prince George, BC, Canada
http://www.pgweb.com


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux