phpgwtimetrack-developers — Mailling List for developers

Re: [Phpgwtimetrack-developers] Timetrack with PHPGW 0.9.4

[Bob S. <bo...@pr...>]

To All:
I went ahead today and added this statement to all the php pages
in timetrack, as the nextmatchs class is pretty much used by all
of it if you count the calls to alternate_row_color(), 
show_sort_order(), etc. CVS has been updated, doesn't interfere
with previous versions, but I can't verify yet that it works
in 0.9.4 + as I am not using it myself.
Bob Schader

Camden Spiller wrote:
> 
> I just had to add:
> $phpgw_info["flags"]["enable_nextmatchs_class"] = "True";
> to timetracks index.php and it seems to be working quite well with an
> unmodified version of the GW 0.9.4 release. Will this cause any errors with
> older versions of GW and Timetrack? Or shall I goahead and commit it?
> 
> Camden
> 
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers

-- 
______________________________________________________________________
Bob Schader
Computer Systems Manager
Product Design International, Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512

Voice: (616) 667-2600 x104
Fax:   (616) 667-2692

Re: [Phpgwtimetrack-developers] Timetrack with PHPGW 0.9.4

[Bob S. <bo...@pr...>]

I don't see it causing any problems with earlier versions, although
I was un-aware of them doing anything that would now require this
setting. I would also question why it needs to be in the index.php
page at all, as the only page using the nextmatchs class right now
is jobslist.php. What was the result of not setting this variable?

I have not upgraded to this version yet myself due to the many changes
they have made in regards to using account_id instead of account_lid
and how that affects my current data, plus I have made minor mods to
the core to fix other issues and make it work the way I wanted it
to, and I just haven't had the time to make those same modifications
to the new code release, other tasks at work have been keeping me
quite busy.

Bob Schader

Camden Spiller wrote:
> 
> I just had to add:
> $phpgw_info["flags"]["enable_nextmatchs_class"] = "True";
> to timetracks index.php and it seems to be working quite well with an
> unmodified version of the GW 0.9.4 release. Will this cause any errors with
> older versions of GW and Timetrack? Or shall I goahead and commit it?
> 
> Camden
>

[Phpgwtimetrack-developers] Timetrack with PHPGW 0.9.4

[Camden S. <csp...@su...>]

I just had to add:
$phpgw_info["flags"]["enable_nextmatchs_class"] = "True";
to timetracks index.php and it seems to be working quite well with an
unmodified version of the GW 0.9.4 release. Will this cause any errors with
older versions of GW and Timetrack? Or shall I goahead and commit it?

Camden

Re: [Phpgwtimetrack-developers] Help implementing an idea

[Bob S. <bo...@pr...>]

Camden,
Thanks, I had no knowledge of this "title" attribute, but I notice it
only seems to work for me in IE. My netscape 4.7 doesn't recognize it.
Oh well.
Bob

Camden Spiller wrote:
> 
> Hi Bob,
> 
> The window.status feature looks great, but I went ahead and also added title
> attributes to the "a" tags on around the num_hours - title is like an alt
> for text, and it should work on any 4.0 browser.
> 
> Camden
> 
> ----- Original Message -----
> From: Bob Schader <bo...@pr...>
> To: phpgwtimetrack devlist <php...@li...>
> Sent: Friday, November 17, 2000 9:08 AM
> Subject: [Phpgwtimetrack-developers] Help implementing an idea
> 
> > To all timetrack developers:
> >
> > I would like to add a popup on the timesheets page so when you
> > move the mouse over a editdetail link showing the hours worked,
> > the popup would show the start and end times. I know javascript
> > can do this using window.status in the status line, and alt text
> > COULD do this if the link were an image instead, but I am not
> > sure how it could be done. I am sure it will probably be javascript,
> > I would like to avoid using layers if at all possible, unless it can
> > be shown to work the same on Unix netscape (I have had some problems
> > with layers on netscape for Linux and HPUX, but I might be doing it
> > wrong).
> >
> > Bob S.
> > --
> > ______________________________________________________________________
> > Bob Schader
> > Computer Systems Manager
> > Product Design International, Inc.
> > 4880 36th St. SE, Suite 100
> > Grand Rapids, MI 49512
> >
> > Voice: (616) 667-2600 x104
> > Fax:   (616) 667-2692
> > _______________________________________________
> > Phpgwtimetrack-developers mailing list
> > Php...@li...
> > http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
> >
> 
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers

-- 
______________________________________________________________________
Bob Schader
Computer Systems Manager
Product Design International, Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512

Voice: (616) 667-2600 x104
Fax:   (616) 667-2692

Re: [Phpgwtimetrack-developers] Help implementing an idea

[Camden S. <ca...@ar...>]

Hi Bob,

The window.status feature looks great, but I went ahead and also added title
attributes to the "a" tags on around the num_hours - title is like an alt
for text, and it should work on any 4.0 browser.

Camden


----- Original Message -----
From: Bob Schader <bo...@pr...>
To: phpgwtimetrack devlist <php...@li...>
Sent: Friday, November 17, 2000 9:08 AM
Subject: [Phpgwtimetrack-developers] Help implementing an idea


> To all timetrack developers:
>
> I would like to add a popup on the timesheets page so when you
> move the mouse over a editdetail link showing the hours worked,
> the popup would show the start and end times. I know javascript
> can do this using window.status in the status line, and alt text
> COULD do this if the link were an image instead, but I am not
> sure how it could be done. I am sure it will probably be javascript,
> I would like to avoid using layers if at all possible, unless it can
> be shown to work the same on Unix netscape (I have had some problems
> with layers on netscape for Linux and HPUX, but I might be doing it
> wrong).
>
> Bob S.
> --
> ______________________________________________________________________
> Bob Schader
> Computer Systems Manager
> Product Design International, Inc.
> 4880 36th St. SE, Suite 100
> Grand Rapids, MI 49512
>
> Voice: (616) 667-2600 x104
> Fax:   (616) 667-2692
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
>

[Phpgwtimetrack-developers] Help implementing an idea

[Bob S. <bo...@pr...>]

To all timetrack developers:

I would like to add a popup on the timesheets page so when you
move the mouse over a editdetail link showing the hours worked,
the popup would show the start and end times. I know javascript
can do this using window.status in the status line, and alt text
COULD do this if the link were an image instead, but I am not
sure how it could be done. I am sure it will probably be javascript,
I would like to avoid using layers if at all possible, unless it can
be shown to work the same on Unix netscape (I have had some problems
with layers on netscape for Linux and HPUX, but I might be doing it
wrong).

Bob S.
-- 
______________________________________________________________________
Bob Schader
Computer Systems Manager
Product Design International, Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512

Voice: (616) 667-2600 x104
Fax:   (616) 667-2692

[Phpgwtimetrack-developers] End time updates in cvs

[Bob S. <bo...@pr...>]

I have just finished updating CVS with numerous updates to add support
for entering end_time and fixing time calculations (I hope I got them
all). Also added trailing ":00" to time strings before storing.
Another item I did was to rename the newjobslist.php file back to
jobslist.php, in order to remove any idea that it has to do with
new jobs. Best thing for anyone to do is use the cvs update command to
update everything.

A previous posting to this list showed how the end_time field can
be updated to calculate the values for existing entries, but I am
pretty sure it only works in MySQL v3.23+ in it's current form.
The end_time field must be manually added at this time to the
job_details table.

Regarding entering data for the end_time, the num_hours field is still
shown as a read-only value with a Update button next to it if someone
wants to check the value. The javascript function that does this
updating is also called when the submit button is pressed, so it is
not necessary to use the update button at all unless you want a 
visual check. Of course, it would be nice to also have the num_hours
input be able to update the end_time field too, but I am not up to
it yet (javascript is tricky enough for me with the simple things).

Bob S.
______________________________________________________________________
Bob Schader
Computer Systems Manager
Product Design International, Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512

Voice: (616) 667-2600 x104
Fax:   (616) 667-2692

Re: [Phpgwtimetrack-developers] Reply to header of List is set

[Bob S. <bo...@pr...>]

Well, so far no good, looks like there might be a lag between when
I set it up and when it goes into effect.

Bob Schader wrote:
> 
> I have finally used the mailman interface on sourceforge to set the
> default reply to header of the list to the list and not the poster.
> This message is to announce that and also test it to make sure it works.
> 
> Bob Schader
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers

[Phpgwtimetrack-developers] Reply to header of List is set

[Bob S. <bo...@pr...>]

I have finally used the mailman interface on sourceforge to set the
default reply to header of the list to the list and not the poster.
This message is to announce that and also test it to make sure it works.

Bob Schader

[Phpgwtimetrack-developers] addjobdetail.php

[Camden S. <ca...@ar...>]

I think this another problem envolving different versions of MySQL.

I had to change line 32 of addjobdetail.php to look like this:
   $starttime = $n_start_time_h . ":" . $n_start_time_m . ":" . "00"; // <=
See the extra ":00" at the end?

otherwise it wouldn't insert the times correctly into my database. Please
let me know if commiting this change to CVS is going to cause anyone else
problems.

Thanks,
____________________________
Camden Spiller

[Phpgwtimetrack-developers] end_time field updates

[Bob S. <bo...@pr...>]

All,
I have been working on updating timetrack to use an end_time field
in the job_details field, and I have developed the following sql
script which can be used to update the current table to calculate
the value for this field. However, I believe the last line only
works in MySQL 3.23 or higher. Can anyone come up with something
that will work with earlier versions? I also already have the code
completed for inputing end_times with a readonly field that is updated
to show hours and still stores hours in the table (I know this is a
little redundant, but maybe we can change it later). But I am still
working on the editdetails.php page. 

The following sql code assumes that the end_time field already exists:
 
alter table job_details change end_time end_time varchar(30);
update job_details set end_time = concat(floor(num_hours),":",
  truncate((num_hours-floor(num_hours))*60,0),":00"); 
alter table job_details change end_time end_time time;
# The next line MAY only work in MySQL 3.23+
update job_details set end_time = start_time + end_time;

-- 
______________________________________________________________________
Bob Schader
Computer Systems Manager
Product Design International, Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512

Voice: (616) 667-2600 x104
Fax:   (616) 667-2692

Re: [Phpgwtimetrack-developers] invoicing

[Jeroen L. <je...@zw...>]

> I agree with your reasoning that the financial program should keep track
of
> what's been billed etc., but it just occured to me that it would if there
> were a bit set we could use it to prevent time track users from editing
> hours that already been processed.
>
> Maybe the new bit could be called 'approved' instead of 'processed' to
> clarify what it does.

Agree. I build a timetracking programs some years ago in Borland Delphi with
the same functionality in it. At a certain time the hours are processed and
users should not be able to change them after that. Kind of read-only flag.
So using the flag for that sounds good.
But ... I am not sure if am export should set this flag automatically. Our
normal procedure was:
1. users input their hours
2. manager makes output and checks the hours.
3. users correct their errors, e.g. if some had a meeting together, it's
nice if they write the same number of hours (on the same day) :)
4. manager makes final output for invoice and from that moment users are not
allowed to change their hours in that period.

So optional setting this flag sound best for me.

To prevent to many input errors I added a list of hours as inputed by
you/others (this week) below the hour input form.

I still think about something to make checking the hours easier.

Greetings
Jeroen.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Jeroen Laarhoven, Zwolle, Netherlands
business: je...@we..., www.webbridge.nl
private: je...@zw..., www.zwolnet.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

----- Original Message -----
From: "Camden Spiller" <ca...@ar...>
To: "phpgwtimetrack devlist"
<php...@li...>
Sent: Saturday, November 11, 2000 9:48 PM
Subject: Re: [Phpgwtimetrack-developers] invoicing


> Thanks for the input Jeroen,
>
> I agree with your reasoning that the financial program should keep track
of
> what's been billed etc., but it just occured to me that it would if there
> were a bit set we could use it to prevent time track users from editing
> hours that already been processed.
>
> Maybe the new bit could be called 'approved' instead of 'processed' to
> clarify what it does.
>
> Let me know what you guys think,
>
> Camden
>
> ----- Original Message -----
> From: Jeroen Laarhoven <je...@zw...>
> To: phpgwtimetrack <php...@li...>
> Sent: Friday, November 10, 2000 3:01 AM
> Subject: Re: [Phpgwtimetrack-developers] invoicing
>
>
> > The financial program (or people) should know what has been billed,
when,
> if
> > paid, etc. That's why I (but who am I) see no reason why to set a
> > 'processed' bit in timetrack. Even if the record has been processed in
> > timetrack you're not sure it has been processed in your financial
program.
> > So let the financial program decide if something has been processed.
> > Before you know timetrack will be extended to a financial program :(
> >
>
>
>
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
>

Re: [Phpgwtimetrack-developers] invoicing

[Bob S. <bo...@pr...>]

Camden Spiller wrote:
> 
> 
> That's fine. I think detail_report1.php is more inkeeping with the "Job
> Status" description, however when a click the hours link from
> newjobslist.php I don't get any hours listed in the "Complete Job Activity
> Report".

Thats odd, I thought I had that fixed at work yesterday? I will look at it.
For some reason now my viewjob page isn't displaying the links at the
bottom for the generate report item either, I think it may be the same layer
bug I experienced on HPUX though (I am using Linux tonight instead of Windows).
The source window seems to show all the html that should be there. Anyway,
I think the hourslist DOES have potential, and maybe a separate menu pick
for it would also be a better place for it, my personal usage sort of dictated
the detail report as a way to get there without also having to go through
the viewjob page except if I wanted to do specific dates.

Bob S.
 
> 
> What I was tring to accomplish with hourslist was to be able to examine a
> jobs hours, and be able to edit them - it would be the tool that a project
> manager would use manage the employees hours etc.. Perhaps you could even
> approve hours from there (that would be using that 'approved' bit)... This
> page may need to be seperated completely from Job Status and made it's own
> page for "Hours Administration"... but I'm still thinking about how to
> implement that - comments are welcome.
> 
> I like how when you view a job, that the start date range of the Activity
> Report is the date the job was opened. Good work.
> 
> Camden
> 
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers

Re: [Phpgwtimetrack-developers] invoicing

[Camden S. <ca...@ar...>]

> To fix the filterobj error you should only need the latest
> inc/phpgwapi/phpgw_nextmatchs.inc.php file.

Thanks, that did the trick.

> If you do, notice that in my cvs I have changed the link to hourslist.php
> on the status page to my detail_report1.php page, but you should be able
to
> change it back with no problems.

That's fine. I think detail_report1.php is more inkeeping with the "Job
Status" description, however when a click the hours link from
newjobslist.php I don't get any hours listed in the "Complete Job Activity
Report".

What I was tring to accomplish with hourslist was to be able to examine a
jobs hours, and be able to edit them - it would be the tool that a project
manager would use manage the employees hours etc.. Perhaps you could even
approve hours from there (that would be using that 'approved' bit)... This
page may need to be seperated completely from Job Status and made it's own
page for "Hours Administration"... but I'm still thinking about how to
implement that - comments are welcome.

I like how when you view a job, that the start date range of the Activity
Report is the date the job was opened. Good work.

Camden

Re: [Phpgwtimetrack-developers] invoicing

[Bob S. <bo...@pr...>]

Camden Spiller wrote:

> 
> > Have anyone updated their addjobdetail and editdetail.php to the latest
> > CVS yet?
> 
> I just checked it out... I can't quite put it into production yet because
> I'm getting a "Call to unsupported or undefined function filterobj() " error
> on newjobslist.php - I'm still working on the last phpgroupware relase
> (0.9.2 I think) so I think that may be the cause.
> 
To fix the filterobj error you should only need the latest 
inc/phpgwapi/phpgw_nextmatchs.inc.php file. It should be a dropin replacement
I think, but you might keep your old one in case. The only other item
in phpgroupware that really uses that is the addressbook, but the way it
was redone should be completely transparent to that app. Try it and see.

If you do, notice that in my cvs I have changed the link to hourslist.php
on the status page to my detail_report1.php page, but you should be able to
change it back with no problems.

I am just about done finishing all the updates to the new date selectors and
should have that in cvs tonight (maybe).

Bob
> 
> No kidding... It looks great Bob!!
> 
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers

Re: [Phpgwtimetrack-developers] invoicing

[Camden S. <ca...@ar...>]

> It appears to work  so far. I think as things progress, it would be
> nicer
> to eventually have the separate entries pre-totaled as the printer
> friendly
> version still does, with editdetail handling navigation between entries,
> but
> as long as this works for now, we can leave that for the future.

I think so to, this just kinda good enough to implement the start and and
times without creating mass confusion with the users.

> I did notice that the totalled entry on the printer friendly page was
> not
> formatted the same as single entries ( "4" instead of 4.00). Just a
> little
> nit-picking there.

I guess it needs some kinda number_format() function applied to it, eh?

> Using time fields, we should be able to just use sql's built-in
> calculation
> functions to have it calculate the num_hours field.

I was thinking that it would be best do to this calculation in php so that
we don't start using database specific functions.

> Have anyone updated their addjobdetail and editdetail.php to the latest
> CVS yet?

I just checked it out... I can't quite put it into production yet because
I'm getting a "Call to unsupported or undefined function filterobj() " error
on newjobslist.php - I'm still working on the last phpgroupware relase
(0.9.2 I think) so I think that may be the cause.

> I think I did a pretty good job on the Time Selector. It has the ability
> to configure
> the minutes increment amount

No kidding... It looks great Bob!!

Re: [Phpgwtimetrack-developers] invoicing

[Bob S. <bo...@pr...>]

Camden Spiller wrote:
> 
> Okay, I've got my changes made to allow timesheets.php to display multiple
> entries per day.
> 
> Check it out from CVS and let me know what you think.
> 
> Camden
Camden,
It appears to work  so far. I think as things progress, it would be
nicer
to eventually have the separate entries pre-totaled as the printer
friendly
version still does, with editdetail handling navigation between entries,
but
as long as this works for now, we can leave that for the future.
I did notice that the totalled entry on the printer friendly page was
not
formatted the same as single entries ( "4" instead of 4.00). Just a
little
nit-picking there.

Regarding your other emails, I think it best to add a end_time field to
job_details
as type TIME, similar to start_time. Status fields can be added for
processed,
approved, finalized, whatever. 

Using time fields, we should be able to just use sql's built-in
calculation 
functions to have it calculate the num_hours field.

Have anyone updated their addjobdetail and editdetail.php to the latest
CVS yet?
Need to update the whole timetrack module, actually. Anyway, I Was
wondering what
everyone thinks of the new Date and Time Selector widgets (as I like to
call them.
I think I did a pretty good job on the Time Selector. It has the ability
to configure
the minutes increment amount (have to currently edit the code to change
it until
I add a configurable option for it though). The latest changes to the
date selector
have it currently popup in a separate window due to a layering
incompatibility
with Netscape on HP-UX, but I plan on also allowing a configure option
for that too.
I did not write the main portion of the Calendar date selector, only
incorporated it.

It should be quite easy to use the TimeSelector for the endtime field
also. I also
still need to change other date entry fields to the new selector soon,

Bob S.

> 
> ----- Original Message -----
> From: Bob Schader <bo...@pr...>
> To: Camden Spiller <ca...@ar...>
> Sent: Saturday, November 11, 2000 1:27 PM
> Subject: Re: [Phpgwtimetrack-developers] invoicing
> 
> > Go for it.
> > Bob
> >
> > Camden Spiller wrote:
> > >
> > > I'm glad to hear you'll be able to make use of the start and end times!
> > >
> > > Should I goahead and rework timesheets.php to handle multiple
> job_details
> > > per day?
> > >
> > > Thanks,
> > >
> > > Camden
> 
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers

Re: [Phpgwtimetrack-developers] invoicing

[Camden S. <ca...@ar...>]

Okay, I've got my changes made to allow timesheets.php to display multiple
entries per day.

Check it out from CVS and let me know what you think.

Camden

----- Original Message -----
From: Bob Schader <bo...@pr...>
To: Camden Spiller <ca...@ar...>
Sent: Saturday, November 11, 2000 1:27 PM
Subject: Re: [Phpgwtimetrack-developers] invoicing


> Go for it.
> Bob
>
> Camden Spiller wrote:
> >
> > I'm glad to hear you'll be able to make use of the start and end times!
> >
> > Should I goahead and rework timesheets.php to handle multiple
job_details
> > per day?
> >
> > Thanks,
> >
> > Camden

Re: [Phpgwtimetrack-developers] invoicing

[Camden S. <ca...@ar...>]

Thanks for the input Jeroen,

I agree with your reasoning that the financial program should keep track of
what's been billed etc., but it just occured to me that it would if there
were a bit set we could use it to prevent time track users from editing
hours that already been processed.

Maybe the new bit could be called 'approved' instead of 'processed' to
clarify what it does.

Let me know what you guys think,

Camden

----- Original Message -----
From: Jeroen Laarhoven <je...@zw...>
To: phpgwtimetrack <php...@li...>
Sent: Friday, November 10, 2000 3:01 AM
Subject: Re: [Phpgwtimetrack-developers] invoicing


> The financial program (or people) should know what has been billed, when,
if
> paid, etc. That's why I (but who am I) see no reason why to set a
> 'processed' bit in timetrack. Even if the record has been processed in
> timetrack you're not sure it has been processed in your financial program.
> So let the financial program decide if something has been processed.
> Before you know timetrack will be extended to a financial program :(
>

[Phpgwtimetrack-developers] Determining number of hours worked based on start and end times

[Camden S. <ca...@ar...>]

Here's an example of the code we could use to determine the time elapsed =
between start and end times:

<?=20

$date1=3Dmktime($hour1,$minute1,$second1,$month1,$day1,$year1);=20
$date2=3Dmktime($hour2,$minute2,$second2,$month2,$day2,$year2);=20
$diff_in_secs=3D$date2 - $date1;=20
$diff_in_minutes=3D$diff_in_secs / 1440;=20

// This is the num_hours that gets inserted into job_details:
$num_hours =3D $diff_in_minutes;
?>

____________________________
Camden Spiller

[Phpgwtimetrack-developers] implementing an end_time

[Camden S. <ca...@ar...>]

Do you think an end_time field should be added to the job_details table?

As far as layout on the addjobdetail.php page, I think we would just want to
have two methods of adding time on addjobdetail.php. We could have the start
time fields, then a new line and the end time fields and then a new line
that says "Or enter the number of hours worked. If they user entered
something in the number of hours worked we would just insert their value and
not do the calculation to determine number of hours worked based on start
and end times.

Let me know what you're thinking,
____________________________
Camden Spiller

Re: [Phpgwtimetrack-developers] invoicing

[Camden S. <ca...@ar...>]

I'm glad to hear you'll be able to make use of the start and end times!

Should I goahead and rework timesheets.php to handle multiple job_details
per day?

Thanks,

Camden


----- Original Message ----- 
From: Bob Schader <bo...@pr...>
Cc: phpgwtimetrack <php...@li...>
Sent: Friday, November 10, 2000 8:29 AM
Subject: Re: [Phpgwtimetrack-developers] invoicing

> Regarding items previously mentioned, it seems I was wrong about our
> company and users not wanting start and end times too! They have
> recently
> asked about the possibility of that. We should be able to do it with
> the current tables, but the pages would need to be redone to support
> the possible entry of more than one detail per job per day. This would
> mainly affect the timesheets.php page and the editdetail.php page, as
> far as I can tell.

Re: [Phpgwtimetrack-developers] invoicing

[Jeroen L. <je...@zw...>]

> Regarding the export, I am working on a page that currently prints
> it's comma separated values to the browser as preformatted text and
> includes those fields, but I currently don't have a form setup to
> control date ranges and such. It should be easy enough to have it
> save this info to a file somewhere instead.

An easy temporary way to get things like a range is to let the user add them
as GET params.
We often do this with admin pages and then make one admin UI page with form
input calling these admin pages with GET params.

> I also have some other cosmetic changes and such that I will try to
> get into CVS sometime today if I have the time. I have spent most
> if the week working on them. I have also been fixing bugs in my running
> version of phpgroupware, which is right now a mix of versions at
> or around 0.9.3pre4. Some of the later changes they have been making
> has made me want to hold back from trying to keep up with them, as
> the changes are too many to keep up with. Perhaps if I make a new
> sourceforge release soon, I should include my customized version of
> phpgroupware as it's base? Any opinions welcome.

Sounds very good. I got GW from CVS tried parts of it, but it was so buggy
that I kept the 0.92 version and just modified (or better hacked :]) the
addressbook in there so it does what I want for the moment: have a list with
names, emails and tel-numbers.

I am looking forward to your export page.

Greetings
Jeroen.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Jeroen Laarhoven, Zwolle, Netherlands
business: je...@we..., www.webbridge.nl
private: je...@zw..., www.zwolnet.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

----- Original Message -----
From: "Bob Schader" <bo...@pr...>
Cc: "phpgwtimetrack" <php...@li...>
Sent: Friday, November 10, 2000 3:29 PM
Subject: Re: [Phpgwtimetrack-developers] invoicing


> Regarding the export, I am working on a page that currently prints
> it's comma separated values to the browser as preformatted text and
> includes those fields, but I currently don't have a form setup to
> control date ranges and such. It should be easy enough to have it
> save this info to a file somewhere instead.
>
> I also have some other cosmetic changes and such that I will try to
> get into CVS sometime today if I have the time. I have spent most
> if the week working on them. I have also been fixing bugs in my running
> version of phpgroupware, which is right now a mix of versions at
> or around 0.9.3pre4. Some of the later changes they have been making
> has made me want to hold back from trying to keep up with them, as
> the changes are too many to keep up with. Perhaps if I make a new
> sourceforge release soon, I should include my customized version of
> phpgroupware as it's base? Any opinions welcome.
>
> Regarding a new field for "processed" or "exported", am I correct in
> assuming that this should go into the job_details table instead
> of the jobs table, so hours can be processed in an ongoing manner?
> I had originallly thought the status_id field in the jobs table
> could be used for something similar, but to track details separately
> like this would require the field to be in the job_details records
> instead. Adding the field to the table should be no problem, coding
> might be a little trickier as to exactly when to set the field, etc.
>
> Also, is anyone familiar with quickbooks? Is the company data the same
> for all setups? They have their "iif" format for exporting and importing
> data, but I understand that data for jobs would need to be imported
> separately into quickbooks before data for timesheets related to those
> jobs could be imported.
>
> Regarding items previously mentioned, it seems I was wrong about our
> company and users not wanting start and end times too! They have
> recently
> asked about the possibility of that. We should be able to do it with
> the current tables, but the pages would need to be redone to support
> the possible entry of more than one detail per job per day. This would
> mainly affect the timesheets.php page and the editdetail.php page, as
> far as I can tell.
>
> Jeroen Laarhoven wrote:
> >
> > > Next week I'm going to need to generate invoices based on the hours
that
> > > have put into time track.
> >
> > Next week we'll start using timetrack for our time tracking operational
and
> > the end of this month we also need something to generate so money ...
> >
> > > I would like to hear everyones thoughts on the best way to implement
this.
> > > For now, all I need to do is mark hours processed. Should I just add
> > another
> > > field named "processed" and set it's value to "1" when I do my export?
> >
> > In my opinion the export (flat table) should include:
> > date + customer_name + job_name + employee(_name) + work_category +
hours
> > (with the combination of the first 5 field being unique)
> >
> > We will base the rate on the combination customer + job + employee +
> > work_category. I think that most companies should be able to choose a
rate
> > based on the combination customer + job and the employee or
work_category or
> > both, maybe in combination with the total hours in a period.
> >
> > I would separate the financial functionality totally from time tracking.
> > Using a standard format like XML or CVS for the export. A financial
program
> > (any or some PHP pages) imports the numbers and makes the bills. (This
means
> > that timetrack probably needs more then one export filter.)
> >
> > The financial program (or people) should know what has been billed,
when, if
> > paid, etc. That's why I (but who am I) see no reason why to set a
> > 'processed' bit in timetrack. Even if the record has been processed in
> > timetrack you're not sure it has been processed in your financial
program.
> > So let the financial program decide if something has been processed.
> > Before you know timetrack will be extended to a financial program :(
> >
> > This is how we will probably process the hours:
> > - make a timetrack 'hours export'.
> > - import this on our local gw system (different server) and generate the
> > invoice (appendix).
> >
> > So we keep the two completely separated.
> > I'll make some PHP pages generating a invoice (appendix) out of the
> > timetrack hours.
> >
> > So far my thoughts ... now back to work.
> >
> > Greetings
> > Jeroen.
> >
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > Jeroen Laarhoven, Zwolle, Netherlands
> > business: je...@we..., www.webbridge.nl
> > private: je...@zw..., www.zwolnet.com
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> >
> > ----- Original Message -----
> > From: "Camden Spiller" <ca...@ar...>
> > To: "phpgwtimetrack" <php...@li...>
> > Sent: Friday, November 10, 2000 8:03 AM
> > Subject: [Phpgwtimetrack-developers] invoicing
> >
> > > Next week I'm going to need to generate invoices based on the hours
that
> > > have put into time track.
> > >
> > > Bob, I think I read one of your comments in the code that said you
would
> > > like use time track to export hours to Quickbooks and then mark the
> > exported
> > > hours as "processed" or something. I'm going to be doing a similar
type
> > > export.
> > >
> > > I would like to hear everyones thoughts on the best way to implement
this.
> > > For now, all I need to do is mark hours processed. Should I just add
> > another
> > > field named "processed" and set it's value to "1" when I do my export?
> > >
> > > Camden
> > >
> > > _______________________________________________
> > > Phpgwtimetrack-developers mailing list
> > > Php...@li...
> > >
http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
> > >
> >
> > _______________________________________________
> > Phpgwtimetrack-developers mailing list
> > Php...@li...
> > http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
>
> --
> ______________________________________________________________________
> Bob Schader
> Computer Systems Manager
> Product Design International, Inc.
> 4880 36th St. SE, Suite 100
> Grand Rapids, MI 49512
>
> Voice: (616) 667-2600 x104
> Fax:   (616) 667-2692
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
>

Re: [Phpgwtimetrack-developers] invoicing

[Bob S. <bo...@pr...>]

I have commited all of my timetrack changes to CVS earlier today,
but things are starting to get hectic around here with other work so
probably won't get to anything else until early next week.
Bob

Jeroen Laarhoven wrote:
> 
> > Regarding the export, I am working on a page that currently prints
> > it's comma separated values to the browser as preformatted text and
> > includes those fields, but I currently don't have a form setup to
> > control date ranges and such. It should be easy enough to have it
> > save this info to a file somewhere instead.
> 
> An easy temporary way to get things like a range is to let the user add them
> as GET params.
> We often do this with admin pages and then make one admin UI page with form
> input calling these admin pages with GET params.
> 
> > I also have some other cosmetic changes and such that I will try to
> > get into CVS sometime today if I have the time. I have spent most
> > if the week working on them. I have also been fixing bugs in my running
> > version of phpgroupware, which is right now a mix of versions at
> > or around 0.9.3pre4. Some of the later changes they have been making
> > has made me want to hold back from trying to keep up with them, as
> > the changes are too many to keep up with. Perhaps if I make a new
> > sourceforge release soon, I should include my customized version of
> > phpgroupware as it's base? Any opinions welcome.
> 
> Sounds very good. I got GW from CVS tried parts of it, but it was so buggy
> that I kept the 0.92 version and just modified (or better hacked :]) the
> addressbook in there so it does what I want for the moment: have a list with
> names, emails and tel-numbers.
> 
> I am looking forward to your export page.
> 
> Greetings
> Jeroen.
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Jeroen Laarhoven, Zwolle, Netherlands
> business: je...@we..., www.webbridge.nl
> private: je...@zw..., www.zwolnet.com
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> ----- Original Message -----
> From: "Bob Schader" <bo...@pr...>
> Cc: "phpgwtimetrack" <php...@li...>
> Sent: Friday, November 10, 2000 3:29 PM
> Subject: Re: [Phpgwtimetrack-developers] invoicing
> 
> > Regarding the export, I am working on a page that currently prints
> > it's comma separated values to the browser as preformatted text and
> > includes those fields, but I currently don't have a form setup to
> > control date ranges and such. It should be easy enough to have it
> > save this info to a file somewhere instead.
> >
> > I also have some other cosmetic changes and such that I will try to
> > get into CVS sometime today if I have the time. I have spent most
> > if the week working on them. I have also been fixing bugs in my running
> > version of phpgroupware, which is right now a mix of versions at
> > or around 0.9.3pre4. Some of the later changes they have been making
> > has made me want to hold back from trying to keep up with them, as
> > the changes are too many to keep up with. Perhaps if I make a new
> > sourceforge release soon, I should include my customized version of
> > phpgroupware as it's base? Any opinions welcome.
> >
> > Regarding a new field for "processed" or "exported", am I correct in
> > assuming that this should go into the job_details table instead
> > of the jobs table, so hours can be processed in an ongoing manner?
> > I had originallly thought the status_id field in the jobs table
> > could be used for something similar, but to track details separately
> > like this would require the field to be in the job_details records
> > instead. Adding the field to the table should be no problem, coding
> > might be a little trickier as to exactly when to set the field, etc.
> >
> > Also, is anyone familiar with quickbooks? Is the company data the same
> > for all setups? They have their "iif" format for exporting and importing
> > data, but I understand that data for jobs would need to be imported
> > separately into quickbooks before data for timesheets related to those
> > jobs could be imported.
> >
> > Regarding items previously mentioned, it seems I was wrong about our
> > company and users not wanting start and end times too! They have
> > recently
> > asked about the possibility of that. We should be able to do it with
> > the current tables, but the pages would need to be redone to support
> > the possible entry of more than one detail per job per day. This would
> > mainly affect the timesheets.php page and the editdetail.php page, as
> > far as I can tell.
> >
> > Jeroen Laarhoven wrote:
> > >
> > > > Next week I'm going to need to generate invoices based on the hours
> that
> > > > have put into time track.
> > >
> > > Next week we'll start using timetrack for our time tracking operational
> and
> > > the end of this month we also need something to generate so money ...
> > >
> > > > I would like to hear everyones thoughts on the best way to implement
> this.
> > > > For now, all I need to do is mark hours processed. Should I just add
> > > another
> > > > field named "processed" and set it's value to "1" when I do my export?
> > >
> > > In my opinion the export (flat table) should include:
> > > date + customer_name + job_name + employee(_name) + work_category +
> hours
> > > (with the combination of the first 5 field being unique)
> > >
> > > We will base the rate on the combination customer + job + employee +
> > > work_category. I think that most companies should be able to choose a
> rate
> > > based on the combination customer + job and the employee or
> work_category or
> > > both, maybe in combination with the total hours in a period.
> > >
> > > I would separate the financial functionality totally from time tracking.
> > > Using a standard format like XML or CVS for the export. A financial
> program
> > > (any or some PHP pages) imports the numbers and makes the bills. (This
> means
> > > that timetrack probably needs more then one export filter.)
> > >
> > > The financial program (or people) should know what has been billed,
> when, if
> > > paid, etc. That's why I (but who am I) see no reason why to set a
> > > 'processed' bit in timetrack. Even if the record has been processed in
> > > timetrack you're not sure it has been processed in your financial
> program.
> > > So let the financial program decide if something has been processed.
> > > Before you know timetrack will be extended to a financial program :(
> > >
> > > This is how we will probably process the hours:
> > > - make a timetrack 'hours export'.
> > > - import this on our local gw system (different server) and generate the
> > > invoice (appendix).
> > >
> > > So we keep the two completely separated.
> > > I'll make some PHP pages generating a invoice (appendix) out of the
> > > timetrack hours.
> > >
> > > So far my thoughts ... now back to work.
> > >
> > > Greetings
> > > Jeroen.
> > >
> > > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > > Jeroen Laarhoven, Zwolle, Netherlands
> > > business: je...@we..., www.webbridge.nl
> > > private: je...@zw..., www.zwolnet.com
> > > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > >
> > > ----- Original Message -----
> > > From: "Camden Spiller" <ca...@ar...>
> > > To: "phpgwtimetrack" <php...@li...>
> > > Sent: Friday, November 10, 2000 8:03 AM
> > > Subject: [Phpgwtimetrack-developers] invoicing
> > >
> > > > Next week I'm going to need to generate invoices based on the hours
> that
> > > > have put into time track.
> > > >
> > > > Bob, I think I read one of your comments in the code that said you
> would
> > > > like use time track to export hours to Quickbooks and then mark the
> > > exported
> > > > hours as "processed" or something. I'm going to be doing a similar
> type
> > > > export.
> > > >
> > > > I would like to hear everyones thoughts on the best way to implement
> this.
> > > > For now, all I need to do is mark hours processed. Should I just add
> > > another
> > > > field named "processed" and set it's value to "1" when I do my export?
> > > >
> > > > Camden
> > > >
> > > > _______________________________________________
> > > > Phpgwtimetrack-developers mailing list
> > > > Php...@li...
> > > >
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
> > > >
> > >
> > > _______________________________________________
> > > Phpgwtimetrack-developers mailing list
> > > Php...@li...
> > > http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
> >
> > --
> > ______________________________________________________________________
> > Bob Schader
> > Computer Systems Manager
> > Product Design International, Inc.
> > 4880 36th St. SE, Suite 100
> > Grand Rapids, MI 49512
> >
> > Voice: (616) 667-2600 x104
> > Fax:   (616) 667-2692
> > _______________________________________________
> > Phpgwtimetrack-developers mailing list
> > Php...@li...
> > http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
> >
> 
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers

-- 
______________________________________________________________________
Bob Schader
Computer Systems Manager
Product Design International, Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512

Voice: (616) 667-2600 x104
Fax:   (616) 667-2692

Re: [Phpgwtimetrack-developers] invoicing

[Jeroen L. <je...@zw...>]

> Regarding the export, I am working on a page that currently prints
> it's comma separated values to the browser as preformatted text and
> includes those fields, but I currently don't have a form setup to
> control date ranges and such. It should be easy enough to have it
> save this info to a file somewhere instead.

An easy temporary way to get things like a range is to let the user add them
as GET params.
We often do this with admin pages and then make one admin UI page with form
input calling these admin pages with GET params.

> I also have some other cosmetic changes and such that I will try to
> get into CVS sometime today if I have the time. I have spent most
> if the week working on them. I have also been fixing bugs in my running
> version of phpgroupware, which is right now a mix of versions at
> or around 0.9.3pre4. Some of the later changes they have been making
> has made me want to hold back from trying to keep up with them, as
> the changes are too many to keep up with. Perhaps if I make a new
> sourceforge release soon, I should include my customized version of
> phpgroupware as it's base? Any opinions welcome.

Sounds very good. I got GW from CVS tried parts of it, but it was so buggy
that I kept the 0.92 version and just modified (or better hacked :]) the
addressbook in there so it does what I want for the moment: have a list with
names, emails and tel-numbers.

I am looking forward to your export page.

Greetings
Jeroen.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Jeroen Laarhoven, Zwolle, Netherlands
business: je...@we..., www.webbridge.nl
private: je...@zw..., www.zwolnet.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
----- Original Message -----
From: "Bob Schader" <bo...@pr...>
Cc: "phpgwtimetrack" <php...@li...>
Sent: Friday, November 10, 2000 3:29 PM
Subject: Re: [Phpgwtimetrack-developers] invoicing


> Regarding the export, I am working on a page that currently prints
> it's comma separated values to the browser as preformatted text and
> includes those fields, but I currently don't have a form setup to
> control date ranges and such. It should be easy enough to have it
> save this info to a file somewhere instead.
>
> I also have some other cosmetic changes and such that I will try to
> get into CVS sometime today if I have the time. I have spent most
> if the week working on them. I have also been fixing bugs in my running
> version of phpgroupware, which is right now a mix of versions at
> or around 0.9.3pre4. Some of the later changes they have been making
> has made me want to hold back from trying to keep up with them, as
> the changes are too many to keep up with. Perhaps if I make a new
> sourceforge release soon, I should include my customized version of
> phpgroupware as it's base? Any opinions welcome.
>
> Regarding a new field for "processed" or "exported", am I correct in
> assuming that this should go into the job_details table instead
> of the jobs table, so hours can be processed in an ongoing manner?
> I had originallly thought the status_id field in the jobs table
> could be used for something similar, but to track details separately
> like this would require the field to be in the job_details records
> instead. Adding the field to the table should be no problem, coding
> might be a little trickier as to exactly when to set the field, etc.
>
> Also, is anyone familiar with quickbooks? Is the company data the same
> for all setups? They have their "iif" format for exporting and importing
> data, but I understand that data for jobs would need to be imported
> separately into quickbooks before data for timesheets related to those
> jobs could be imported.
>
> Regarding items previously mentioned, it seems I was wrong about our
> company and users not wanting start and end times too! They have
> recently
> asked about the possibility of that. We should be able to do it with
> the current tables, but the pages would need to be redone to support
> the possible entry of more than one detail per job per day. This would
> mainly affect the timesheets.php page and the editdetail.php page, as
> far as I can tell.
>
> Jeroen Laarhoven wrote:
> >
> > > Next week I'm going to need to generate invoices based on the hours
that
> > > have put into time track.
> >
> > Next week we'll start using timetrack for our time tracking operational
and
> > the end of this month we also need something to generate so money ...
> >
> > > I would like to hear everyones thoughts on the best way to implement
this.
> > > For now, all I need to do is mark hours processed. Should I just add
> > another
> > > field named "processed" and set it's value to "1" when I do my export?
> >
> > In my opinion the export (flat table) should include:
> > date + customer_name + job_name + employee(_name) + work_category +
hours
> > (with the combination of the first 5 field being unique)
> >
> > We will base the rate on the combination customer + job + employee +
> > work_category. I think that most companies should be able to choose a
rate
> > based on the combination customer + job and the employee or
work_category or
> > both, maybe in combination with the total hours in a period.
> >
> > I would separate the financial functionality totally from time tracking.
> > Using a standard format like XML or CVS for the export. A financial
program
> > (any or some PHP pages) imports the numbers and makes the bills. (This
means
> > that timetrack probably needs more then one export filter.)
> >
> > The financial program (or people) should know what has been billed,
when, if
> > paid, etc. That's why I (but who am I) see no reason why to set a
> > 'processed' bit in timetrack. Even if the record has been processed in
> > timetrack you're not sure it has been processed in your financial
program.
> > So let the financial program decide if something has been processed.
> > Before you know timetrack will be extended to a financial program :(
> >
> > This is how we will probably process the hours:
> > - make a timetrack 'hours export'.
> > - import this on our local gw system (different server) and generate the
> > invoice (appendix).
> >
> > So we keep the two completely separated.
> > I'll make some PHP pages generating a invoice (appendix) out of the
> > timetrack hours.
> >
> > So far my thoughts ... now back to work.
> >
> > Greetings
> > Jeroen.
> >
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > Jeroen Laarhoven, Zwolle, Netherlands
> > business: je...@we..., www.webbridge.nl
> > private: je...@zw..., www.zwolnet.com
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> >
> > ----- Original Message -----
> > From: "Camden Spiller" <ca...@ar...>
> > To: "phpgwtimetrack" <php...@li...>
> > Sent: Friday, November 10, 2000 8:03 AM
> > Subject: [Phpgwtimetrack-developers] invoicing
> >
> > > Next week I'm going to need to generate invoices based on the hours
that
> > > have put into time track.
> > >
> > > Bob, I think I read one of your comments in the code that said you
would
> > > like use time track to export hours to Quickbooks and then mark the
> > exported
> > > hours as "processed" or something. I'm going to be doing a similar
type
> > > export.
> > >
> > > I would like to hear everyones thoughts on the best way to implement
this.
> > > For now, all I need to do is mark hours processed. Should I just add
> > another
> > > field named "processed" and set it's value to "1" when I do my export?
> > >
> > > Camden
> > >
> > > _______________________________________________
> > > Phpgwtimetrack-developers mailing list
> > > Php...@li...
> > >
http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
> > >
> >
> > _______________________________________________
> > Phpgwtimetrack-developers mailing list
> > Php...@li...
> > http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
>
> --
> ______________________________________________________________________
> Bob Schader
> Computer Systems Manager
> Product Design International, Inc.
> 4880 36th St. SE, Suite 100
> Grand Rapids, MI 49512
>
> Voice: (616) 667-2600 x104
> Fax:   (616) 667-2692
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/mailman/listinfo/phpgwtimetrack-developers
>