From: David N. <dav...@bi...> - 2006-12-12 19:24:50
|
I have checked in my first set of code. I have added all my options to the bottom of config_defaults_inc.php. I have implemented some of the features discussed here and in the blog. johnwebbcole - I even added a nifty stop watch feature just for you ;) All comments will be gratefully received. Regards, David --------------------------------------- Managing Director BigSoft Limited Reading, UK http://www.bigsoft.co.uk/ |
From: Jeferson O. <jef...@gm...> - 2006-12-12 19:50:00
|
"David Newcomb" escreveu: > I have implemented some of the features discussed here and > in the blog. Great David! I have read some of your posts and became interested in this time tacker add-ons to Mantis. Are the checked in modifications related to the features discussed in the link belos? http://forums.mantisbugtracker.com/viewtopic.php?t=589&postdays=0&postorder=asc&start=0&sid=11201dc3d61c6fe5d3e2cb6fa1a11104 How can I download this version? Do I need CVS access? Regards, Jeferson Oliveira Brazil |
From: Jeferson O. <jef...@gm...> - 2006-12-13 11:28:22
|
"Jeferson Oliveira" escreveu: > How can I download this version? > Do I need CVS access? I've follow the instructions in http://www.mantisbugtracker.com/cvs.php and got the source using rsync. Thanks! Jeferson Oliveira Brazil |
From: David N. <dav...@bi...> - 2006-12-13 18:41:52
|
I have briefly looked at the source for this and it appears that it deals with the time spent on the bug as a whole. This is more a-kin to the way that custom fields work. My time tracker allows you to assign a unit of time to a bugnote. ie I spent 2 hours on doing that piece of work. The idea is that you can work out how much time was spent on a particular bug. Most people have found that the results are quite surprising. There is stuff in there to total up the times spent on a particular bug between a particular time frame thus helping with billing. I plan on thinking about a flexible costing solution based on project/person/whatever. On Tue, December 12, 2006 8:52 pm, Jeferson Oliveira wrote: > "David Newcomb" escreveu: >> I have implemented some of the features discussed here and >> in the blog. > > Great David! > I have read some of your posts and became interested in this time tacker > add-ons to Mantis. > Are the checked in modifications related to the features discussed in the > link belos? > http://forums.mantisbugtracker.com/viewtopic.php?t=589&postdays=0&postorder=asc&start=0&sid=11201dc3d61c6fe5d3e2cb6fa1a11104 > > How can I download this version? > Do I need CVS access? > > > Regards, > > Jeferson Oliveira > Brazil > > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Mantisbt-dev mailing list > Man...@li... > https://lists.sourceforge.net/lists/listinfo/mantisbt-dev > Regards, David --------------------------------------- Managing Director +44 (0) 7866 262 398 BigSoft Limited Reading, UK http://www.bigsoft.co.uk/ |
From: Jeferson O. <jef...@gm...> - 2006-12-17 04:43:25
|
Jeferson Oliveira escreveu: > I've follow the instructions in http://www.mantisbugtracker.com/cvs.php and > got the source using rsync. Just a comment. I am familiar with JediVCS and Subversion, but not the same with CVS. To access the Mantis repository I've tried WinCVS, but after some hours trying to configure it, I gave up. In a Delphi newsgroup I've read a suggestion to use TortoiseCVS. What a great tool is TortoiseCVS (http://www.tortoisecvs.org/)! I'm really impressed with its capability to became a CVS server access a very simple task. I apologize for the OFF-TOPIC, but publish my satisfaction with the tool, was the better way I found to express my gratitude and congratulate the TortoiseCVS developers for their good work. Regards, Jeferson Oliveira Brazil |
From: David N. <dav...@bi...> - 2006-12-20 20:15:52
|
Started going through the comments made by vboctor. The following are done and checked in: - We should create a Wiki page for this feature that explains the supported functionality. Please use the Wiki page associated with this issue. - Store the time in the database as an integer with minutes as the unit. - Add a step to the schema that adds the required field. - In the documentation for $g_time_tracking_stopwatch clarify the dependency on $g_use_javascript and that the javascript needs to be enabled in the browser. For those of you who have been here since the start you will probably have a TIME column type for your time_tracking. I have posted some SQL on the Wiki to help you convert to the new INT column type: http://www.mantisbt.org/wiki/doku.php?id=mantisbt%3Aissue%3A4428 Going away for Christmas, so I don't speak to you before then have a good one. Any of you people from Copenhagen? I'll be there at New Years Eve - can you recommend any where to go? Regards, David --------------------------------------- Managing Director +44 (0) 7866 262 398 BigSoft Limited Reading, UK http://www.bigsoft.co.uk/ |
From: Paul <pa...@qu...> - 2006-12-12 22:00:38
|
David, The one thing I tend to pick up on is mysql-specific features. Having scan-read part of the patch I believe the timetracknig stuff contains some. Given that, a) I personally use mssql with mantis, so have an interest in features working in mssql b) I'm not sure how much the adodb datadict stuff supports TIME as a data type. c) I dread to think how pgsql/mssql/oracle and mysql would all support that datatype d) that your commit earlier didn't actually update the schema.php file I've started some investigative work into how to support this feature in mssql/pgsql etc. My current thinking is along the following lines: Use the fact that the schema.php file did not get updated and users wont get a DB schema update yet to investigate the feasibility of storing the time_tracking data as an unsigned int, in terms of number of seconds for a task. This would then mean that we don't need to worry about db specific data/time handling, and can display php to format the display of the data. Can you see any problems with this approach? Additionally, can you hold off from committing an updated schema.php until we sort out the best way to support other DB's. Paul > -----Original Message----- > From: man...@li... [mailto:mantisbt-dev- > bo...@li...] On Behalf Of David Newcomb > Sent: 12 December 2006 19:25 > To: man...@li... > Subject: [Mantisbt-dev] Time Tracking: checkin > > > I have checked in my first set of code. I have added all my > options to the bottom of config_defaults_inc.php. > I have implemented some of the features discussed here and > in the blog. > johnwebbcole - I even added a nifty stop watch feature just > for you ;) > > All comments will be gratefully received. > > > Regards, > David > --------------------------------------- > Managing Director > BigSoft Limited > Reading, UK > http://www.bigsoft.co.uk/ > > > > ----------------------------------------------------------------------- > -- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD > EV > _______________________________________________ > Mantisbt-dev mailing list > Man...@li... > https://lists.sourceforge.net/lists/listinfo/mantisbt-dev |
From: David N. <dav...@bi...> - 2006-12-13 18:46:15
|
Will do. I was reading the Mantis documentation and it said they it only supported MySQL, so I did not feel bad about adding MySQL specific SQL. I had previously thought about seconds but that idea was lost in the mists of time. I will look at converting it to seconds on my side of the fence. On Tue, December 12, 2006 9:59 pm, Paul wrote: > David, > > The one thing I tend to pick up on is mysql-specific features. Having > scan-read part of the patch I believe the timetracknig stuff contains > some. > > Given that, > a) I personally use mssql with mantis, so have an interest in features > working in mssql > b) I'm not sure how much the adodb datadict stuff supports TIME as a data > type. > c) I dread to think how pgsql/mssql/oracle and mysql would all support > that > datatype > d) that your commit earlier didn't actually update the schema.php file > > I've started some investigative work into how to support this feature in > mssql/pgsql etc. > > My current thinking is along the following lines: > > Use the fact that the schema.php file did not get updated and users wont > get > a DB schema update yet to investigate the feasibility of storing the > time_tracking data as an unsigned int, in terms of number of seconds for a > task. This would then mean that we don't need to worry about db specific > data/time handling, and can display php to format the display of the data. > > Can you see any problems with this approach? > > Additionally, can you hold off from committing an updated schema.php until > we sort out the best way to support other DB's. > > Paul > > >> -----Original Message----- >> From: man...@li... [mailto:mantisbt-dev- >> bo...@li...] On Behalf Of David Newcomb >> Sent: 12 December 2006 19:25 >> To: man...@li... >> Subject: [Mantisbt-dev] Time Tracking: checkin >> >> >> I have checked in my first set of code. I have added all my >> options to the bottom of config_defaults_inc.php. >> I have implemented some of the features discussed here and >> in the blog. >> johnwebbcole - I even added a nifty stop watch feature just >> for you ;) >> >> All comments will be gratefully received. >> >> >> Regards, >> David >> --------------------------------------- >> Managing Director >> BigSoft Limited >> Reading, UK >> http://www.bigsoft.co.uk/ >> >> >> >> ----------------------------------------------------------------------- >> -- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to share >> your >> opinions on IT & business topics through brief surveys - and earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD >> EV >> _______________________________________________ >> Mantisbt-dev mailing list >> Man...@li... >> https://lists.sourceforge.net/lists/listinfo/mantisbt-dev > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Mantisbt-dev mailing list > Man...@li... > https://lists.sourceforge.net/lists/listinfo/mantisbt-dev > Regards, David --------------------------------------- Managing Director +44 (0) 7866 262 398 BigSoft Limited Reading, UK http://www.bigsoft.co.uk/ |
From: <pa...@qu...> - 2006-12-13 19:00:28
|
> > Will do. > I was reading the Mantis documentation and it said they it only > supported MySQL, so I did not feel bad about adding MySQL specific > SQL. I had previously thought about seconds but that idea was lost > in the mists of time. I will look at converting it to seconds on my > side of the fence. Ok, I know the home page mentiosn mssql/pgsql - I wouldn't be surprised if some of the manual only mention mysql as we've been keeping pgsql/mssql as 'beta' (albeit it is stable) +$upgrade[] = Array('AddColumnSQL',Array(config_get('mantis_bugnote_table'), "time_tracking I UNSIGNED NOTNULL")); ^ I'd say that is probably the type of schema.php change you'll need, and if your going to look at converting it, i'll leave you to it for now. My guess would be you just need to add a function to the date api or somewhere appropriate to convert to/from a time string (if appropriate), revert the database_api.php change - hopefully shouldn't be too much work. Paul |