Menu
▾
▴
tsheetx-developers — Timesheet Next Gen - Developer's mailing list
You can subscribe to this list here.
| 2008 |
Jan
|
Feb
(1) |
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
(3) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2009 |
Jan
(1) |
Feb
|
Mar
|
Apr
(4) |
May
(3) |
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
|
Mar
|
Apr
(6) |
May
(10) |
Jun
(1) |
Jul
(3) |
Aug
(19) |
Sep
(52) |
Oct
(5) |
Nov
(15) |
Dec
|
| 2011 |
Jan
|
Feb
(65) |
Mar
(53) |
Apr
(55) |
May
(37) |
Jun
|
Jul
(1) |
Aug
(17) |
Sep
(28) |
Oct
(7) |
Nov
|
Dec
|
| 2012 |
Jan
(3) |
Feb
|
Mar
(2) |
Apr
|
May
(4) |
Jun
(3) |
Jul
(1) |
Aug
|
Sep
|
Oct
(1) |
Nov
(1) |
Dec
(1) |
| 2013 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(3) |
| 2014 |
Jan
|
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
|
From: Peter L. <pal...@gm...> - 2011-09-20 05:45:19
|
I have been wrestling with why some of the timestamps in my database are
14 or 15 hours out of whack. Specifically the end_time is wrong. If I
clockin/out at 10:00-11:00 am, the timestamps in the db are start_time
of 10am and end_time of 2am the next day. Duration shows as 60 mins. So
I think what is happening is that function fixStartEndDuration and
fix_entry_endstamp are changing the end times.
There is this comment at the start of function fixStartEndDuration
//Due to a bug in mysql with converting to unix timestamp from the
string,
//we are going to use php's strtotime to make the timestamp
from the string.
//the problem has something to do with timezones.
Can anyone shed some light on what this bug might have been? Was it a
mysql 4.x bug? The url
http://jokke.dk/blog/2007/07/timezones_in_mysql_and_php mentioned in the
same function talks about handling timezones in php. It appears to me
that this web site may have changed since the url was pasted into the
function as I remember there were a few added comments then which are no
longer there. So any description of what bug there was, is no longer there.
This problem is most likely influenced by the system timezone, which
mysql uses, and whatever timezone is given to php. But I haven't
investigated that on my system yet.
In a future release i would like to change the way dates/times are
stored in the database. I think the database needs to keep time in UTC
only. Now we could change the mysql datetime fields to timestamp. Values
for |TIMESTAMP| <http://dev.mysql.com/doc/refman/5.5/en/datetime.html>
columns are converted from the current time zone to UTC for storage, and
from UTC to the current time zone for retrieval. datetime fields store
time in local time with no conversion i.e. set by the server's timezone.
See here for a discussion
http://billauer.co.il/blog/2009/03/mysql-datetime-epoch-unix-time/ with
some suggestions in this blog that datetime fields are better for
performance, possibly because the database does not have to do date
conversions.
There is also a short howto /user experience on converting your database
to using UTC:
http://stackoverflow.com/questions/2982897/php-mysql-time-zone-migration
Anyway, the reason I want to convert to UTC in the database is to remove
the probable timezone problems that fixStartEndDuration seems to be
trying to correct. The more important reason however is to support
multiple timezones. Since we have made a major effort to
internationalise the language in the web pages, we should also manage
the timestamps better. Being able to manage multiple timezones would
mean allowing each user to save and display his times in his own
timezone. The application then becomes a useful application for
international use, where users are in many different timezones.
Peter
|
|
From: Mark W. <ma...@rw...> - 2011-09-09 22:24:52
|
Very very strange. Since i've been working on the project today. The missing clocks from August have reappeared........ _____________________________________________ Mob: 07725 695178 Email: ma...@rw... On 06/09/2011 18:54, Mark Wrightson wrote: > It only seems to be that one week. September seems to work. I have > multiple projects, clients, and tasks. The SQL transaction retrieves > the data, it just isn't displayed. > I will look into reproducing the problem. > > Mark > > _____________________________________________ > > Mob: 07725 695178 > Email: ma...@rw... > > > On 05/09/2011 23:25, Peter Lazarus wrote: >> Hi Mark, >> can't reporduce your bug. I tried under 1.5.2 and demo version. You >> mention last week of August. Was that because you were testing when the >> actual date was 30 August? Or was it because you think a short week >> ending a month displayed in Month might be the cause of the problem? >> Peter >> >> On 09/04/2011 08:29 PM, Mark Wrightson wrote: >>> Hi All, >>> >>> I have found a bug in monthly.php and have not found the source of it. >>> I am missing all clock entries in the last week of August under the All >>> Clients view. If I select a particular client then the items reappear. >>> I've checked the SQL output, and I can confirm that the data is being >>> extracted from the database. >>> >>> Please could someone have a look at this issue? >>> >>> Many Thanks >>> >>> Mark >>> >> ------------------------------------------------------------------------------ >> Special Offer -- Download ArcSight Logger for FREE! >> Finally, a world-class log management solution at an even better >> price-free! And you'll get a free "Love Thy Logs" t-shirt when you >> download Logger. Secure your free ArcSight Logger TODAY! >> http://p.sf.net/sfu/arcsisghtdev2dev >> _______________________________________________ >> Tsheetx-developers mailing list >> Tsh...@li... >> https://lists.sourceforge.net/lists/listinfo/tsheetx-developers >> > ------------------------------------------------------------------------------ > Using storage to extend the benefits of virtualization and iSCSI > Virtualization increases hardware utilization and delivers a new level of > agility. Learn what those decisions are and how to modernize your storage > and backup environments for virtualization. > http://www.accelacomm.com/jaw/sfnl/114/51434361/ > _______________________________________________ > Tsheetx-developers mailing list > Tsh...@li... > https://lists.sourceforge.net/lists/listinfo/tsheetx-developers > |
|
From: Mark W. <ma...@rw...> - 2011-09-09 19:53:20
|
Hi Paul,
Not really no.. The internationalisation is done using the Joomla JText
library which gets its data from an ini file.
The output for the javascript needs to be:
lang["HR"] = "h";
lang["MN"] = "m";
etc
The above output is currently generated with this code:
lang["HR"] = "<?php echo JText::_('HR'); ?>";
lang["MN"] = "<?php echo JText::_('MN'); ?>";
Cheers
Mark
_____________________________________________
Mob: 07725 695178
Email: ma...@rw...
On 09/09/2011 20:06, paul cooper wrote:
> is this the sort of thing you are after.
> ive had to do a series of dropdown menus using a multidimensional JS
> array
>
> http://www.medalto.co.uk/dropdown.php
>
> generated by this. I could probably put it in some sort of recursive
> loop to construct the multiidimensional JS array/object
>
> $SQL = "SELECT * FROM coding ORDER BY SYSTEM,SITE,PROCESS" ;
> $ic=array();
> $r = mysql_query($SQL);
> while ($d = mysql_fetch_assoc($r))
> {
> #print_r($d);print'<hr>';
>
> $sy=$d['SYSTEM'];$si=$d['SITE'];$pr=$d['PROCESS'];$co=$d['CONDITION'];
> if (!(array_key_exists($sy, $ic))){ $ic[$sy]= array(); }
> if (!(array_key_exists($si, $ic[$sy]))){ $ic[$sy][$si]= array(); }
> if (!(array_key_exists($pr, $ic[$sy][$si]))){ $ic[$sy][$si][$pr]=
> array(); }
> if (!(array_key_exists($co, $ic[$sy][$si][$pr]))){
> $ic[$sy][$si][$pr][$co]= array(); }
> $ic[$sy][$si][$pr][$co]=$d['ICMcodeExcludingType'];
> }
> print "\n<br>";
> }
> print '<script language="javascript">';
> print "var sys=document.getElementById(\"system\");\n";
> print "var icnarc = {};\n";
> foreach ($ic as $k1 => $v1)
> {
> print "icnarc[\"$k1\"]={}";print "\n";
> print "icnarc[\"$k1\"]".'.name='."\"$k1\";";print "\n";
> foreach ($v1 as $k2 =>$v2)
> {
> print "icnarc[\"$k1\"][\"$k2\"]={};";print "\n";
> print "icnarc[\"$k1\"][\"$k2\"].name=\"$k2\";";print "\n";
> foreach ($v2 as $k3 =>$v3)
> {
> print "icnarc[\"$k1\"][\"$k2\"][\"$k3\"]={};";print "\n";
> print "icnarc[\"$k1\"][\"$k2\"][\"$k3\"].name=\"$k3\";";print "\n";
> foreach ($v3 as $k4 =>$v4)
> {
> print "icnarc[\"$k1\"][\"$k2\"][\"$k3\"][\"$k4\"]={};";print "\n";
> print "icnarc[\"$k1\"][\"$k2\"][\"$k3\"][\"$k4\"].name=\"$k4\";";print
> "\n";
> print
> "icnarc[\"$k1\"][\"$k2\"][\"$k3\"][\"$k4\"].value=\"$v4\";";print "\n";
> }
> }
> }
> print "\n";
> }
>
> ?>
>
|
|
From: Mark W. <ma...@rw...> - 2011-09-09 16:11:30
|
Hi All,
I noticed some sections of javascript that wern't working properly due
to the internationalisation not working. Some sections had PHP code
written into them which wasn't being parsed by PHP hence caused the errors.
So, I have implemented a simple way of getting JText data into the
application. The PHP version is: JText::_("HR"); The javascript
version is: jtext.get("HR");
The code to achieve this is in js/lang.js.php
The one caveat at the moment is that it can only be used by "HR" and
"MN". If you need to use more values then they need to be entered into
the lang.js.php file
Alternatively, If anyone would like to write something to grab all the
values and convert them into a javascript associative array, please be
my guest!
Mark
--
_____________________________________________
Mob: 07725 695178
Email: ma...@rw...
|
|
From: Mark W. <ma...@rw...> - 2011-09-07 07:03:46
|
It only seems to be that one week. September seems to work. I have multiple projects, clients, and tasks. The SQL transaction retrieves the data, it just isn't displayed. I will look into reproducing the problem. Mark _____________________________________________ Mob: 07725 695178 Email: ma...@rw... On 05/09/2011 23:25, Peter Lazarus wrote: > Hi Mark, > can't reporduce your bug. I tried under 1.5.2 and demo version. You > mention last week of August. Was that because you were testing when the > actual date was 30 August? Or was it because you think a short week > ending a month displayed in Month might be the cause of the problem? > Peter > > On 09/04/2011 08:29 PM, Mark Wrightson wrote: >> Hi All, >> >> I have found a bug in monthly.php and have not found the source of it. >> I am missing all clock entries in the last week of August under the All >> Clients view. If I select a particular client then the items reappear. >> I've checked the SQL output, and I can confirm that the data is being >> extracted from the database. >> >> Please could someone have a look at this issue? >> >> Many Thanks >> >> Mark >> > ------------------------------------------------------------------------------ > Special Offer -- Download ArcSight Logger for FREE! > Finally, a world-class log management solution at an even better > price-free! And you'll get a free "Love Thy Logs" t-shirt when you > download Logger. Secure your free ArcSight Logger TODAY! > http://p.sf.net/sfu/arcsisghtdev2dev > _______________________________________________ > Tsheetx-developers mailing list > Tsh...@li... > https://lists.sourceforge.net/lists/listinfo/tsheetx-developers > |
|
From: Peter L. <pal...@gm...> - 2011-09-05 22:25:10
|
Hi Mark, can't reporduce your bug. I tried under 1.5.2 and demo version. You mention last week of August. Was that because you were testing when the actual date was 30 August? Or was it because you think a short week ending a month displayed in Month might be the cause of the problem? Peter On 09/04/2011 08:29 PM, Mark Wrightson wrote: > Hi All, > > I have found a bug in monthly.php and have not found the source of it. > I am missing all clock entries in the last week of August under the All > Clients view. If I select a particular client then the items reappear. > I've checked the SQL output, and I can confirm that the data is being > extracted from the database. > > Please could someone have a look at this issue? > > Many Thanks > > Mark > |
|
From: Mark W. <ma...@rw...> - 2011-09-04 10:29:25
|
Hi All, I have found a bug in monthly.php and have not found the source of it. I am missing all clock entries in the last week of August under the All Clients view. If I select a particular client then the items reappear. I've checked the SQL output, and I can confirm that the data is being extracted from the database. Please could someone have a look at this issue? Many Thanks Mark -- _____________________________________________ Mob: 07725 695178 Email: ma...@rw... |
|
From: Isabelle V. <ver...@fr...> - 2011-08-28 12:49:17
|
Hello Peter, In datetimepicker_css.js, I forgot to comment lines 20 to 22: lines for the first creation of the 3 global variables MonthName, WeekDayName1 and WeekDayName2. I don't know if this can help you... Before to choose to move these 3 variables in the file include/language/datetimepicker_lang.inc, I tried many solutions "to set the values" using PHP and the JText::_ directly in the datetimepicker_css.js without success... like this: var variable1=<?php echo $var1; ?>; It is probably due to a problem for the kind of quotes for javascript array. In the language files, it is not possible to use strings containing '"'. (see include/jclasses/language.php) I continue to search if there is a solution to keep the 3 variables in datetimepicker_css.js and using values defined in the language files. Isabelle. |
|
From: Peter L. <pal...@gm...> - 2011-08-28 03:41:58
|
Update 392 implements the suggestion Isabelle made re selecting just month and year for monthly type forms. I have only implemented it for monthly.php so far. There is a small bug in the datetimepicker.js when used in monthly.php. It puts "undefined" at the top of the date picking popup, and I haven't worked out where that is coming from. If someone can help fix that error it would be much appreciated. Once the bug is fixed, i will propagate the change to other monthly type forms. Peter On 08/27/2011 07:18 AM, Isabelle Vergely wrote: > Hello, > > In this revision: > > - minor changes: utf8_encode added for correct display of dates; use of the utf-8 charset for meta tag of popup_template.php > > - modification of datetimepicker_css.js for translation of month names and week day names: > o removal of MonthName, WeekDayName1 and WeekDayName2 in datetimepicker_css.js > o new corresponding values of these variables in language files > o new file include/language/datetimepicker_lang.inc to set variables using the language files > o before each use of datetimepicker_css.js in PHP files, addition of require_once for datetimepicker_lang.inc > > I think what the datetimepicker is only needed for forms about a short period of time (less than a month) as for: daily, weekly, simple, weekly and half-month reports. > For other forms where the period of time is a month (monthly, submit, absence, ...), I suggest a small calendar displaying only month and year or the use of two "selects" (month, year). What is your opinion? > > Isabelle. > > ------------------------------------------------------------------------------ > EMC VNX: the world's simplest storage, starting under $10K > The only unified storage solution that offers unified management > Up to 160% more powerful than alternatives and 25% more efficient. > Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev > _______________________________________________ > Tsheetx-developers mailing list > Tsh...@li... > https://lists.sourceforge.net/lists/listinfo/tsheetx-developers |
|
From: Peter L. <pal...@gm...> - 2011-08-28 03:14:43
|
Isabelle, thanks for these changes in update 389. I agree with your comment about just selecting month and year for forms where the period is a month. I am making modifications to datetimepicker which will implement that function. Peter On 08/27/2011 07:18 AM, Isabelle Vergely wrote: > Hello, > > In this revision: > > - minor changes: utf8_encode added for correct display of dates; use of the utf-8 charset for meta tag of popup_template.php > > - modification of datetimepicker_css.js for translation of month names and week day names: > o removal of MonthName, WeekDayName1 and WeekDayName2 in datetimepicker_css.js > o new corresponding values of these variables in language files > o new file include/language/datetimepicker_lang.inc to set variables using the language files > o before each use of datetimepicker_css.js in PHP files, addition of require_once for datetimepicker_lang.inc > > I think what the datetimepicker is only needed for forms about a short period of time (less than a month) as for: daily, weekly, simple, weekly and half-month reports. > For other forms where the period of time is a month (monthly, submit, absence, ...), I suggest a small calendar displaying only month and year or the use of two "selects" (month, year). What is your opinion? > > Isabelle. > > ------------------------------------------------------------------------------ > EMC VNX: the world's simplest storage, starting under $10K > The only unified storage solution that offers unified management > Up to 160% more powerful than alternatives and 25% more efficient. > Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev > _______________________________________________ > Tsheetx-developers mailing list > Tsh...@li... > https://lists.sourceforge.net/lists/listinfo/tsheetx-developers |
|
From: Isabelle V. <ver...@fr...> - 2011-08-26 21:18:43
|
Hello, In this revision: - minor changes: utf8_encode added for correct display of dates; use of the utf-8 charset for meta tag of popup_template.php - modification of datetimepicker_css.js for translation of month names and week day names: o removal of MonthName, WeekDayName1 and WeekDayName2 in datetimepicker_css.js o new corresponding values of these variables in language files o new file include/language/datetimepicker_lang.inc to set variables using the language files o before each use of datetimepicker_css.js in PHP files, addition of require_once for datetimepicker_lang.inc I think what the datetimepicker is only needed for forms about a short period of time (less than a month) as for: daily, weekly, simple, weekly and half-month reports. For other forms where the period of time is a month (monthly, submit, absence, ...), I suggest a small calendar displaying only month and year or the use of two "selects" (month, year). What is your opinion? Isabelle. |
|
From: Peter L. <pal...@gm...> - 2011-08-25 22:49:55
|
Just experimenting with tsng. I created a new client. Client appears in client lists,and doesn't appear in any drop down lists I created a new project for this client. a default task gets created as well. Delete the default task, and the project list says "no tasks". Try to add some time to this project, and the task list says "no tasks assigned to you" So it seems that tsng already handles the situation where there are no default tasks or projects. Just need to delete the code that creates the defaults in the first place and test using an empty database. Peter On 08/26/2011 12:54 AM, Scott Miller wrote: > I believe the default task, project and client entries were created as > a solution to the problem of "how should the system handle a user that > has no clients, projects or tasks?". This particular answer meant the > system didn't have to handle that problem as there should never be a > time when a user didn't have at least one of each. > > FWIW, I dislike them as well, and I'm hopeful that they can be removed. > > -Scott > > On Thu, Aug 25, 2011 at 7:10 AM, Peter Lazarus <pal...@gm... > <mailto:pal...@gm...>> wrote: > > I don't like these default things either. Will investigate. > > On 08/25/2011 09:47 PM, David Thompson wrote: >> Back on the list... >> >> I think "no/any client" is handled ok, I have set up an install >> with clients turned off completely. >> Default project and default task worry me. Do we really >> need these? It gets confusing when times are entered against them. >> >> Dave >> >> ------------------------------------------------------------------------ >> Date: Wed, 24 Aug 2011 19:31:48 +1000 >> From: pal...@gm... <mailto:pal...@gm...> >> To: tom...@us... >> <mailto:tom...@us...> >> CC: ma...@rw... <mailto:ma...@rw...>; >> 2n...@ak... <mailto:2n...@ak...>; >> sco...@gm... <mailto:sco...@gm...> >> Subject: Re: [Tsheetx-developers] Customizable default tasks >> >> David, >> what are you referring to in special handling of defaults? Do you >> mean that a default task, project, client are currently inserted >> in the database and show up in lists? >> Peter >> >> On 08/24/2011 06:08 PM, David Thompson wrote: >> >> Peter >> Without looking at the code, but from your good analysis, I >> agree that your suggestion is better. Scott was working on a >> new config style (in the V2 branch?) anyway, so extending the >> old config table that is earmarked for removal is not useful. >> >> So a good design sounds something like you said: a set of >> (potential) standard tasks, that can be checkboxed when >> creating tasks in a project, together with a UI to manage >> that list of standard tasks (add, delete, modify). >> >> Can we also get away from special handling of defaults here >> (default task, default project, no/any client)? >> >> Cheers >> Dave >> > |
|
From: Peter L. <pal...@gm...> - 2011-08-25 21:53:59
|
I haven't looked at the code yet. The situation could simply be handled by saying: no tasks, no projects. But then additional code could be needed in some sql selects to ignore incomplete clients and projects. Perhaps that;s prefereable to forcing the addition of a project when creating a client, or jumping to add new task just after a new project is created. Peter On 26 August 2011 00:54, Scott Miller <sco...@gm...> wrote: > I believe the default task, project and client entries were created as a > solution to the problem of "how should the system handle a user that has no > clients, projects or tasks?". This particular answer meant the system > didn't have to handle that problem as there should never be a time when a > user didn't have at least one of each. > > FWIW, I dislike them as well, and I'm hopeful that they can be removed. > > -Scott > > > On Thu, Aug 25, 2011 at 7:10 AM, Peter Lazarus <pal...@gm...>wrote: > >> I don't like these default things either. Will investigate. >> >> On 08/25/2011 09:47 PM, David Thompson wrote: >> >> Back on the list... >> >> I think "no/any client" is handled ok, I have set up an install with >> clients turned off completely. >> Default project and default task worry me. Do we really need these? It >> gets confusing when times are entered against them. >> >> Dave >> >> ------------------------------ >> Date: Wed, 24 Aug 2011 19:31:48 +1000 >> From: pal...@gm... >> To: tom...@us... >> CC: ma...@rw...; 2n...@ak...; >> sco...@gm... >> Subject: Re: [Tsheetx-developers] Customizable default tasks >> >> David, >> what are you referring to in special handling of defaults? Do you mean >> that a default task, project, client are currently inserted in the database >> and show up in lists? >> Peter >> >> On 08/24/2011 06:08 PM, David Thompson wrote: >> >> Peter >> Without looking at the code, but from your good analysis, I agree >> that your suggestion is better. Scott was working on a new config style (in >> the V2 branch?) anyway, so extending the old config table that is earmarked >> for removal is not useful. >> >> So a good design sounds something like you said: a set of (potential) >> standard tasks, that can be checkboxed when creating tasks in a project, >> together with a UI to manage that list of standard tasks (add, delete, >> modify). >> >> Can we also get away from special handling of defaults here (default task, >> default project, no/any client)? >> >> Cheers >> Dave >> >> >> > |
|
From: Scott M. <sco...@gm...> - 2011-08-25 14:54:11
|
I believe the default task, project and client entries were created as a solution to the problem of "how should the system handle a user that has no clients, projects or tasks?". This particular answer meant the system didn't have to handle that problem as there should never be a time when a user didn't have at least one of each. FWIW, I dislike them as well, and I'm hopeful that they can be removed. -Scott On Thu, Aug 25, 2011 at 7:10 AM, Peter Lazarus <pal...@gm...> wrote: > I don't like these default things either. Will investigate. > > On 08/25/2011 09:47 PM, David Thompson wrote: > > Back on the list... > > I think "no/any client" is handled ok, I have set up an install with > clients turned off completely. > Default project and default task worry me. Do we really need these? It gets > confusing when times are entered against them. > > Dave > > ------------------------------ > Date: Wed, 24 Aug 2011 19:31:48 +1000 > From: pal...@gm... > To: tom...@us... > CC: ma...@rw...; 2n...@ak...; > sco...@gm... > Subject: Re: [Tsheetx-developers] Customizable default tasks > > David, > what are you referring to in special handling of defaults? Do you mean that > a default task, project, client are currently inserted in the database and > show up in lists? > Peter > > On 08/24/2011 06:08 PM, David Thompson wrote: > > Peter > Without looking at the code, but from your good analysis, I agree that your > suggestion is better. Scott was working on a new config style (in the V2 > branch?) anyway, so extending the old config table that is earmarked for > removal is not useful. > > So a good design sounds something like you said: a set of (potential) > standard tasks, that can be checkboxed when creating tasks in a project, > together with a UI to manage that list of standard tasks (add, delete, > modify). > > Can we also get away from special handling of defaults here (default task, > default project, no/any client)? > > Cheers > Dave > > > |
|
From: Peter L. <pal...@gm...> - 2011-08-25 12:10:25
|
I don't like these default things either. Will investigate. On 08/25/2011 09:47 PM, David Thompson wrote: > Back on the list... > > I think "no/any client" is handled ok, I have set up an install with > clients turned off completely. > Default project and default task worry me. Do we really need these? It > gets confusing when times are entered against them. > > Dave > > ------------------------------------------------------------------------ > Date: Wed, 24 Aug 2011 19:31:48 +1000 > From: pal...@gm... > To: tom...@us... > CC: ma...@rw...; 2n...@ak...; > sco...@gm... > Subject: Re: [Tsheetx-developers] Customizable default tasks > > David, > what are you referring to in special handling of defaults? Do you mean > that a default task, project, client are currently inserted in the > database and show up in lists? > Peter > > On 08/24/2011 06:08 PM, David Thompson wrote: > > Peter > Without looking at the code, but from your good analysis, I agree > that your suggestion is better. Scott was working on a new config > style (in the V2 branch?) anyway, so extending the old config > table that is earmarked for removal is not useful. > > So a good design sounds something like you said: a set of > (potential) standard tasks, that can be checkboxed when creating > tasks in a project, together with a UI to manage that list of > standard tasks (add, delete, modify). > > Can we also get away from special handling of defaults here > (default task, default project, no/any client)? > > Cheers > Dave > |
|
From: David T. <tom...@us...> - 2011-08-25 11:47:27
|
Back on the list... I think "no/any client" is handled ok, I have set up an install with clients turned off completely. Default project and default task worry me. Do we really need these? It gets confusing when times are entered against them. Dave Date: Wed, 24 Aug 2011 19:31:48 +1000 From: pal...@gm... To: tom...@us... CC: ma...@rw...; 2n...@ak...; sco...@gm... Subject: Re: [Tsheetx-developers] Customizable default tasks David, what are you referring to in special handling of defaults? Do you mean that a default task, project, client are currently inserted in the database and show up in lists? Peter On 08/24/2011 06:08 PM, David Thompson wrote: Peter Without looking at the code, but from your good analysis, I agree that your suggestion is better. Scott was working on a new config style (in the V2 branch?) anyway, so extending the old config table that is earmarked for removal is not useful. So a good design sounds something like you said: a set of (potential) standard tasks, that can be checkboxed when creating tasks in a project, together with a UI to manage that list of standard tasks (add, delete, modify). Can we also get away from special handling of defaults here (default task, default project, no/any client)? Cheers Dave |
|
From: Peter L. <pal...@gm...> - 2011-08-22 22:46:24
|
Hi All, I have added definitions for three new tables, std_tasks, expense, and category. The first provides a table for keeping a list of standard tasks which can be selectively added to any project. The latter two are for some basic new function to track expenses. Also, there are three new authorisation levels to help manage access to expenses, which have been defined in the config table. You can find the definitions in the timesheet.sql.in file or in the timesheet_upgrade_to_1.5.3.sql.in file. Peter |
|
From: Peter L. <pal...@gm...> - 2011-08-22 22:37:44
|
Paul, that's an interesting suggestion. Being able to selectively copy tasks from one project to another. I will add it to my todo list. Peter On 08/21/2011 04:54 PM, paul cooper wrote: > is there some crossover between this and the 'clone user' stuff. For > that , you need to set up one user and then can copy all the tasks > across to another. > Coming at the same problem from the other end ? > > |
|
From: Mark W. <ma...@rw...> - 2011-08-22 14:55:16
|
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Peter, <br>
<br>
The admin, manager, basic clearances can now be used through the
same method as check aclClients etc.<br>
<br>
The command:<br>
<blockquote>$this->requestPageAuth('aclClients')) <br>
</blockquote>
should only really be used once at the top of the page, as it is the
governing factor that sets whether the page should be displayed or
not.<br>
The new options are "Administrator", "Manager", "Basic"<br>
<br>
If you need to check auth anywhere else i.e. in the menu you should
use the command below:<br>
<br>
if(Auth::ACCESS_GRANTED == Auth::requestAuth('Administrator')){<br>
echo 'yes';<br>
}<br>
<br>
Please note the quotation marks around Administrator.<br>
<br>
Cheers!<br>
Mark<br>
<br>
<br>
<pre class="moz-signature" cols="72">_____________________________________________
Mob: 07725 695178
Email: <a class="moz-txt-link-abbreviated" href="mailto:ma...@rw...">ma...@rw...</a></pre>
<br>
On 21/08/2011 02:42, Peter Lazarus wrote:
<blockquote cite="mid:4E5...@gm..." type="cite">Mark,
<br>
I should specifically ask about admin authorisation. There are the
simple existing levels of basic, mgr, admin, none which are tested
in say if(Auth::ACCESS_GRANTED !=
$this->requestPageAuth('aclClients'))return;
<br>
<br>
The old code has this: if
(!$authenticationManager->isLoggedIn() ||
!$authenticationManager->hasClearance(CLEARANCE_ADMINISTRATOR))
<br>
<br>
have you changed this code to OOO yet? It seems not.
<br>
<br>
Otherwise I have already worked out how to add additional page
authentications.
<br>
Peter
<br>
<br>
</blockquote>
</body>
</html>
|
|
From: paul c. <pdc...@bl...> - 2011-08-21 06:54:15
|
is there some crossover between this and the 'clone user' stuff. For that , you need to set up one user and then can copy all the tasks across to another. Coming at the same problem from the other end ? On 21/08/11 01:30, Peter Lazarus wrote: > Hi Denis, > I have already coded a standard tasks function. It is to be found in the > txsheet-2.0-demo branch. The code there includes a form to add and > delete standard tasks to the standard task table. And in the add task > form, I list out the standard tasks that can be chosen to be added to a > project. The code is ./tsx/tasks/task_add_std.php, > ./tsx/tasks/task_std_action.php, and ./tsx/tasks/task_add.php > > I would like to look at what you have implemented, and we can agree to > merge code, or select appropriate features from both sets to improve TSNG. > > Peter > > On 08/19/2011 11:32 PM, Denis Carniel wrote: >> Hi, >> >> Looking on the web for a good solution to implement a timesheet solution in my company I came across your project (the old version at first then found the Next Gen one). >> >> One minor caveat of the current solution to my taste was the lack of possibility to automatically add a set of tasks to a newly created project, therefore I looked in the code and implemented that feature (including the configuration entry to set the tasks labels). >> >> That seems to work nicely for me and I'd be more than happy to send you the updated package so it can be included in a future release, I've updated the project creation logic as well as configuration page& action and the database model so the default stays on "Default Task". >> >> Don't hesitate to let me know if you're interested, I've got all that right at hand. >> >> Regards, >> Denis >> >> >> ------------------------------------------------------------------------------ >> Get a FREE DOWNLOAD! and learn more about uberSVN rich system, >> user administration capabilities and model configuration. Take >> the hassle out of deploying and managing Subversion and the >> tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 >> _______________________________________________ >> Tsheetx-developers mailing list >> Tsh...@li... >> https://lists.sourceforge.net/lists/listinfo/tsheetx-developers > > ------------------------------------------------------------------------------ > Get a FREE DOWNLOAD! and learn more about uberSVN rich system, > user administration capabilities and model configuration. Take > the hassle out of deploying and managing Subversion and the > tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 > _______________________________________________ > Tsheetx-developers mailing list > Tsh...@li... > https://lists.sourceforge.net/lists/listinfo/tsheetx-developers |
|
From: Peter L. <pal...@gm...> - 2011-08-21 00:30:25
|
Hi Denis, I have already coded a standard tasks function. It is to be found in the txsheet-2.0-demo branch. The code there includes a form to add and delete standard tasks to the standard task table. And in the add task form, I list out the standard tasks that can be chosen to be added to a project. The code is ./tsx/tasks/task_add_std.php, ./tsx/tasks/task_std_action.php, and ./tsx/tasks/task_add.php I would like to look at what you have implemented, and we can agree to merge code, or select appropriate features from both sets to improve TSNG. Peter On 08/19/2011 11:32 PM, Denis Carniel wrote: > Hi, > > Looking on the web for a good solution to implement a timesheet solution in my company I came across your project (the old version at first then found the Next Gen one). > > One minor caveat of the current solution to my taste was the lack of possibility to automatically add a set of tasks to a newly created project, therefore I looked in the code and implemented that feature (including the configuration entry to set the tasks labels). > > That seems to work nicely for me and I'd be more than happy to send you the updated package so it can be included in a future release, I've updated the project creation logic as well as configuration page& action and the database model so the default stays on "Default Task". > > Don't hesitate to let me know if you're interested, I've got all that right at hand. > > Regards, > Denis > > > ------------------------------------------------------------------------------ > Get a FREE DOWNLOAD! and learn more about uberSVN rich system, > user administration capabilities and model configuration. Take > the hassle out of deploying and managing Subversion and the > tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 > _______________________________________________ > Tsheetx-developers mailing list > Tsh...@li... > https://lists.sourceforge.net/lists/listinfo/tsheetx-developers |
|
From: Scott M. <sco...@gm...> - 2011-08-20 19:54:34
|
Denis, I've been unable to work on the project for a while, but I know this was one of the areas that several people have been interested in fixing. So, yes, I think it's safe to say we would like to see what you've added to the project. -Scott L. Miller On Fri, Aug 19, 2011 at 8:32 AM, Denis Carniel <2n...@ak...>wrote: > Hi, > > Looking on the web for a good solution to implement a timesheet solution in > my company I came across your project (the old version at first then found > the Next Gen one). > > One minor caveat of the current solution to my taste was the lack of > possibility to automatically add a set of tasks to a newly created project, > therefore I looked in the code and implemented that feature (including the > configuration entry to set the tasks labels). > > That seems to work nicely for me and I'd be more than happy to send you the > updated package so it can be included in a future release, I've updated the > project creation logic as well as configuration page & action and the > database model so the default stays on "Default Task". > > Don't hesitate to let me know if you're interested, I've got all that right > at hand. > > Regards, > Denis > > > > ------------------------------------------------------------------------------ > Get a FREE DOWNLOAD! and learn more about uberSVN rich system, > user administration capabilities and model configuration. Take > the hassle out of deploying and managing Subversion and the > tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 > _______________________________________________ > Tsheetx-developers mailing list > Tsh...@li... > https://lists.sourceforge.net/lists/listinfo/tsheetx-developers > |
|
From: Denis C. <2n...@ak...> - 2011-08-19 13:45:05
|
Hi, Looking on the web for a good solution to implement a timesheet solution in my company I came across your project (the old version at first then found the Next Gen one). One minor caveat of the current solution to my taste was the lack of possibility to automatically add a set of tasks to a newly created project, therefore I looked in the code and implemented that feature (including the configuration entry to set the tasks labels). That seems to work nicely for me and I'd be more than happy to send you the updated package so it can be included in a future release, I've updated the project creation logic as well as configuration page & action and the database model so the default stays on "Default Task". Don't hesitate to let me know if you're interested, I've got all that right at hand. Regards, Denis |
|
From: Peter L. <pal...@gm...> - 2011-08-10 02:38:09
|
Hi All,
I've done it, but you may not like the result!!
I have made major changes to simple.php.
Peter
1.
Assumptions in the design of simple.php V1.5.2
and earlier
1.
Times with the same client/project/task/description on each day
are consolidated for reporting, and then written back to the
database as just one record
2.
Times are rewritten to the database, with the start time reset to
midnight, hence destroying previous time details which could have
been entered using other time entry sheets.
3.
Database records are all deleted and re-inserted, leaving the
system exposed to failure.
4.
Time records can cross date boundaries, e.g. 11:00pm to 3:00am
5.
If a record is changed, then the order of the tasks in the simple
form is changed.
6.
Records get lost under unknown circumstances, perhaps when there
are too many lines to display?
1.
Proposed solution, change no. 338
1.
Each and every time record will be listed without consolidation.
Records for the same task/description will be listed across the
week, and down the screen. This means that multiple records
created in one day are listed separately.
2.
Time records will be updated for duration and end time, and other
values such as start time will be left un-touched. Where the
increased duration causes the end time to exceed midnight, the
record will be split into two records.
3.
New time records will be inserted, and split across two or more
days as necessary
4.
New time records will be inserted with a start time of midnight.
5.
Modified time records will be updated in place rather than being
deleted and re-inserted.
6.
Database times will now be in UTC – are they already?
7.
Minimal changes to limit the impact on other forms
8.
If a record is submitted or approved, it will not be alterable in
any of its details
9.
These changes may have unintended consequences on other timesheet
forms, so those forms may need adjusting
Please note that not all of the proposed solution items have been
implemented yet. The changes I am making to simple.php and
simple_action.php are still in progress. There still may be bugs in the
code. The splitting of records across midnight has yet to be
implemented. The submission of time records doesn't yet result in them
being unalterable.
*Crossing Date Boundaries
*The current implementation allows times records to record times
crossing midnight, or even many days. I propose changing this in the
near future to split such records before they are written into the
database so that no record crosses a midnight boundary, nor has a
duration greater than 24 hours.
*UTC*
The database records are not written in UTC as far as I can fathom from
reading the mysql details. But it's not at all clear to me yet. In any
case we have to plan to change the system to keep time records in UTC
and convert them to the local time format when they are read. By doing
this, we can then implement a future feature where each user can see his
records in his local timezone, and we can properly support users in
multiple timezones recording their timesheets.
|
|
From: Isabelle V. <ver...@fr...> - 2011-07-17 18:48:18
|
Revision 333, modifications for internationalization: * include/language/en-GB.ini and include/language/fr-FR.ini * include/tsx/common.class.php, * js/client_proj_task_javascript.class.php and js/simple.js * tsx/client_proj_task_javascript.class.php, tsx/simple.php * and tsx/tasks/task_maint.php Isabelle. |
29 messages has been excluded from this view by a project administrator.
