wiki:TimingAndEstimationFullChangeLog

17249 by bobbysmith007 on 2018-07-30 16:26:11
Change db backend import stuff to allow running without all backends installed re #13462
17107 by bobbysmith007 on 2018-04-09 17:22:27
1.5.9(b) - fixed Decimal cast in ticket_daemon re #13405
17096 by bobbysmith007 on 2018-04-05 15:41:39
Fix hour summing in reports to not round partial hours

version 1.5.8(b)

re #13405

17028 by bobbysmith007 on 2018-02-01 17:24:41
Fixing bug relating to <none> status in billing.html 1.5.7
17019 by bobbysmith007 on 2018-01-08 16:47:41
Fix extra footer TD by waiting a little before totalling. re #13270
17012 by bobbysmith007 on 2017-12-01 18:36:29
Try again to fix report linkink 1.5.5
17011 by bobbysmith007 on 2017-12-01 18:11:32
Try again to fix status <none>
17010 by bobbysmith007 on 2017-12-01 18:07:36
Code to handle status <none>
16842 by bobbysmith007 on 2017-10-04 01:35:51
1.5.2(b) Remove macros include for trac1.1
16690 by bobbysmith007 on 2017-06-29 20:42:59

make HoursLayoutChanger respect long fields (colspan=3)

re #10547
re #11657

16689 by bobbysmith007 on 2017-06-29 19:40:09
Fix query to not add unneccessary footers

fix #11579

16688 by bobbysmith007 on 2017-06-29 19:17:56

Porting changes from the non permission branch

  • Remove defunct, unused macros include in billing.html re #12853
  • Update database access for proper trac 1.1 Thanks lkraav re #13080
  • be more forgiving about what goes through convert float in ticket daemon re #13219
  • Change billing html a bit re #11280
16687 by bobbysmith007 on 2017-06-29 19:06:52
TandE version 1.5.0 with billing html changes
re #11280
16686 by bobbysmith007 on 2017-06-29 19:06:22
Fix bugs in dbhelper - need to return values
16685 by bobbysmith007 on 2017-06-29 18:34:52
Handle false-ish values in ticket_daemon convert_float

re #13219

16684 by bobbysmith007 on 2017-06-29 18:19:41
Applying patches from trac-hacks to modernize interfacing with the database re #13080
16683 by bobbysmith007 on 2017-06-29 16:14:27
Remove defunct unused macros include in billing

re #12853

14864 by bobbysmith007 on 2015-08-07 17:47:03
fix broken version number
14863 by bobbysmith007 on 2015-08-07 17:32:40
Fixing bug in ticket_change_delete of ticket_daemon re #12532
14856 by bobbysmith007 on 2015-08-04 14:45:17
trying to work around mysql integrity errors re #12470
14580 by bobbysmith007 on 2015-05-11 15:09:22
Replace CSV filter with one that doesnt require monkey patching (or does this in a more controlled manner) v1.4.7b fix #12305
14426 by bobbysmith007 on 2015-02-16 20:32:36
fixing report Primary Key bugs 1.4.6 fix #12010 fix #12191
14424 by bobbysmith007 on 2015-02-13 16:02:35
fix bad variable reference in csv export filters re #12191
14419 by bobbysmith007 on 2015-02-09 15:32:48
port hours/float/decimal point changes to Permissions branch, bumped version to 1.4.4 re #12173
14418 by bobbysmith007 on 2015-02-09 15:29:53
fixing bugs in update_hours_to_floats re 12173
14417 by bobbysmith007 on 2015-02-09 15:20:35
add missing =
14416 by bobbysmith007 on 2015-02-09 15:19:35
attempting to better handle "," in numbers re #12173
14408 by bobbysmith007 on 2015-02-03 22:01:36
Fixing new ticket hours after concurrency bug (again) re #12173
14407 by bobbysmith007 on 2015-02-03 21:59:34
Fixing new ticket hours after concurrency bug re #12173
14406 by bobbysmith007 on 2015-02-03 21:55:22
convert hours back to string in effort to round trip them into the ticket_change table
14405 by bobbysmith007 on 2015-02-03 21:49:12
improve convertfloat to handle already floats
14404 by bobbysmith007 on 2015-02-03 21:45:49
new ticket hours bugs fix
14403 by bobbysmith007 on 2015-02-03 20:40:57
concurrency fixes to ticket_daemon, version bumped to 1.4.1 re #12173
14402 by bobbysmith007 on 2015-02-03 20:39:21
(more)Porting concurrency fixes to Permissions branch re #12173
14401 by bobbysmith007 on 2015-02-03 20:28:19
Porting concurrency fixes to Permissions branch re #12173
14400 by bobbysmith007 on 2015-02-03 20:07:44
fixed typo bug (where is my git!)
14399 by bobbysmith007 on 2015-02-03 20:05:57
fixed indent bug
14398 by bobbysmith007 on 2015-02-03 19:48:37
Attempt at fixing concurrency errors in the ticket_daemon

Replaces stateful work with a handful of sql statements that will
behave correctly regardless of ordering in the case of concurrency

re #12173

14062 by bobbysmith007 on 2014-08-04 13:13:24
Updated csv export permissions monkey patch for trac 1.0 re #11898
14061 by bobbysmith007 on 2014-08-04 13:04:36
branched for trac1.0
13377 by bobbysmith007 on 2013-09-05 15:01:48
removed misleading sentence in the user manual
12966 by bobbysmith007 on 2013-04-08 18:47:56
remove hours/work summary reports from the view-tickets screen re #11005
12858 by bobbysmith007 on 2013-04-01 16:06:03
make add_hours_from_comment work in the face of ajax previews
12856 by bobbysmith007 on 2013-04-01 14:36:15
fixed broken import of module I refactored away last week fix #10988
12837 by bobbysmith007 on 2013-03-29 14:13:55
remove debugging code
12832 by bobbysmith007 on 2013-03-28 18:50:43
comment out console.log re #10983
12831 by bobbysmith007 on 2013-03-28 18:50:05
better table reorganizer - handles twocell-rows in tables of four-cell rows re #10983
12829 by bobbysmith007 on 2013-03-28 14:40:46
use isinstance instead of checking types eql re #10978
12828 by bobbysmith007 on 2013-03-28 14:38:47
use ensure correct timestamp type in delete_ticket_change re #10978
12823 by bobbysmith007 on 2013-03-27 20:34:32
fixed bug in add_hours_from_comment.js
12822 by bobbysmith007 on 2013-03-27 20:12:20
more JS refactor to modernize and simplify re #10977
12821 by bobbysmith007 on 2013-03-27 20:06:12
major rewrite of much of the javascript this plugin uses to modernize it and fix some latent bugs
12744 by bobbysmith007 on 2013-03-19 19:01:33
make report joins to enum be left joins to prevent missing data due to invalid priorities
12047 by bobbysmith007 on 2012-09-21 20:39:40
bumped version to 1.3.0 re #10277
12045 by bobbysmith007 on 2012-09-21 20:37:49
changed from back from throwing exceptions to returning booleans in ticket_policy, not sure what prompted the change the other way
12035 by bobbysmith007 on 2012-09-20 20:43:51
prevent unicode error fix #10141
11739 by bobbysmith007 on 2012-07-19 15:27:31
bumped version to 1.2.8 re #10165
11738 by bobbysmith007 on 2012-07-19 15:25:51
updated db-helper backend checks to correctly handle pooled connections fix #10165
11737 by bobbysmith007 on 2012-07-19 15:25:40
updated db-helper backend checks to correctly handle pooled connections fix #10165
11653 by bobbysmith007 on 2012-06-18 20:58:20
Removing deprecated unused code in prep for trac1.0 re #10101
11652 by bobbysmith007 on 2012-06-18 20:55:41
Removing deprecated unused code in prep for trac1.0 re #10101
11386 by bobbysmith007 on 2012-03-14 19:36:25
added example date format to trac 12 templates
11385 by bobbysmith007 on 2012-03-14 19:04:45
T&E Bug fixes (version 1.2.7 - prev version 0.9.8)

  • Enforce customizable permission on the billing/management page

re #9901

11384 by bobbysmith007 on 2012-03-14 19:03:12
T&E Bug fixes (version 1.2.7)

  • Enforce customizable permission on the billing/management page
  • remove python version requirements
  • fix date parsing (again)
  • fix db_table_exists (again)

re #9612 and #9793 and #9844 and #9901

11383 by bobbysmith007 on 2012-03-14 19:01:07
T&E Bug fixes

  • remove python version requirements
  • fix date parsing (again)
  • fix db_table_exists (again)

re #9612 and #9793 and #9844 and #9901

11274 by bobbysmith007 on 2012-02-13 21:32:42
Add minimum version check to setup.py scripts re #9793
11261 by bobbysmith007 on 2012-02-07 21:00:27
removed extraneous print that shouldnt have been committed re #7446
11260 by bobbysmith007 on 2012-02-07 15:06:40
fixing bugs in single instance postgres with schemas and db_table_exists fix #7446
11259 by bobbysmith007 on 2012-02-07 14:35:16
fixing indentation in git_post_receieve

Thanks for the patch, sorry for the bad changeset

fix #9774

11258 by bobbysmith007 on 2012-02-07 14:32:35
fixing indentation in git_post_receieve

Thanks for the patch, sorry for the bad changeset

11138 by bobbysmith007 on 2012-01-12 21:49:25
remove version check in reportmanager.CustomReportManger . It was only causing upgrades to fail
11059 by bobbysmith007 on 2011-12-21 19:31:04
fix bugs in db_table_exists re #9629
11040 by bobbysmith007 on 2011-12-14 18:54:36
added a couple more timeformats (to allow plain dates) re #9612
10840 by bobbysmith007 on 2011-10-26 16:01:40
Sorry for the delay, untabified those files, should fix #8910
10779 by bobbysmith007 on 2011-10-14 13:29:11
fixed copy/paste bug where I forgot an import (Thanks for the bug report!) fix #9266
10766 by bobbysmith007 on 2011-10-13 13:50:25
Changed def of table_exists to special case sqlite, hopefully will prevent problems with nested transactions <ver 1.2.0> re #9259 and #9250
10653 by bobbysmith007 on 2011-09-12 14:47:12
better hour totaler on /query screen fix #9040
10643 by bobbysmith007 on 2011-09-07 18:50:14
Backported hours_layout_changer from the trac12 branch - ver 0.9.8
10626 by bobbysmith007 on 2011-08-29 18:48:09
ver 1.1.8b

when searching for groups, dont query all permissions unless we are
using the default store (LDAP store takes a long time to return all
permissions).

fix #3828

10625 by bobbysmith007 on 2011-08-29 17:39:17
  • Got date printing to be mostly iso8601 compliant (iternationalized)
  • Allow setting a bill date to a manual time, rather than only when clicked (mostly accepts iso8601 format eg: 2010-08-01 12:42:01)

fix #1593 and #7170

10336 by bobbysmith007 on 2011-06-20 13:55:53
patched to support multiple repos - close #8910
10335 by bobbysmith007 on 2011-06-20 12:00:00
it was old, use the branches folder
10267 by bobbysmith007 on 2011-06-07 20:48:37
added a timeline filter to remove information about private fields from the timeline
10266 by bobbysmith007 on 2011-06-06 13:26:31
fixed UTF-8 field label bugs related to genshi Stream.render calls re #8866
10182 by bobbysmith007 on 2011-05-11 19:15:40
removed some parts of the fields upgrade check to make it more configurable 1.1.4 and 1.1.4b
10114 by bobbysmith007 on 2011-04-25 13:47:56
  • Got query.js being included at the correct url
  • use jquery for much smaller more readable query.js
  • make it only attach to estimatedhours and hours (though there is an easy place to change this)

Thanks very much for the bug report and patch. I ended up
rewriting that javascript file to use jquery and be much
shorter more re and moree

version 1.1.3 & 1.1.3b
fix #8732

9989 by bobbysmith007 on 2011-03-28 17:30:53
better logging and install re #8575
9973 by bobbysmith007 on 2011-03-22 19:44:25
Changed where the add-hours field is being moved to (not visibly) to increase interoperability ver 1.1.1 fix #8314
9971 by bobbysmith007 on 2011-03-18 12:22:01
added svn-post-commit hook scripts
9963 by bobbysmith007 on 2011-03-16 19:10:44
fixed a bug about updating report sequences in postgres re #8608
9887 by bobbysmith007 on 2011-02-23 12:45:00
added LICENSE files, just incase there was doubt or the license declaration in the setup was not good enough
9866 by bobbysmith007 on 2011-02-16 18:14:32
Downcase the url (/billing) so that it can be put in trac.ini as a key for trac MenusPlugin fix #8506
9762 by bobbysmith007 on 2011-01-12 15:09:31
added a license to the bottom of the git_post_receive files, so it is extra clear you can use it
9714 by bobbysmith007 on 2011-01-03 15:26:05
fixed some uninstaller bugs
9709 by bobbysmith007 on 2010-12-31 19:42:34
added an uninstall script, probably not perfect, and I cant imagine people helping me debug it, but at least its a start
9706 by bobbysmith007 on 2010-12-28 21:06:54
added some better post-commit debugging re #8341
9701 by bobbysmith007 on 2010-12-23 15:51:07
Found a bug in nested_transaction handling, I think it is now corrected, which should resolve - re #8324
9633 by bobbysmith007 on 2010-12-07 17:34:16
Make trac-post-commit handle putting tickets into the correct "resolved" state based on configureable workflow. Also added newer better git_post_receive that wont post patches moved from one branch to another a second time. fix #8234
9630 by bobbysmith007 on 2010-12-07 14:42:53
Fixed a bug where changes you didnt have permission to see were visible. Trac changed from showing the field to showing the field.label but the plugin missed this initially. fix #8285
8350 by bobbysmith007 on 2010-08-10 16:54:21
added missing whitespace cleanup file (oops)
8300 by bobbysmith007 on 2010-07-26 19:06:06
fixed a bug in add-hours javascript layout changer, that only affected the new ticket screen. fix #7385
8299 by bobbysmith007 on 2010-07-26 19:05:58
fixed a bug in add-hours javascript layout changer, that only affected the new ticket screen. fix #7385
8262 by bobbysmith007 on 2010-07-12 21:47:11
Added a whitespace cleaner (from Josh Godsiff - thanks!) to the ticket page to remove extra whitespace, and fixed csv exports in permissions branch. ver 1.0.5 - fix #7354 and #7025
8260 by bobbysmith007 on 2010-07-12 15:28:14
Add report group descriptions on management page. Fixed too small default end date (version 1.0.4) fix #7368 and #7369
8252 by bobbysmith007 on 2010-07-09 20:06:16
t&e version 1.0.3 - add an hours layout changer component that relocates the hours on a trac ticket to directly beneath the comment field
8202 by bobbysmith007 on 2010-07-02 13:58:55

Added special casing on the database backend to make this work on sqlites < 3.6.8

re #7315

8193 by bobbysmith007 on 2010-07-01 15:08:15
use savepoints for nested transactions so that sequence updates dont cause the upgrade to fail on sqlite fix #7315
8176 by bobbysmith007 on 2010-06-30 17:07:32
fixed #7315 - upgrade bug was preventing proper upgrade
8166 by bobbysmith007 on 2010-06-29 14:41:56
Missed a changed where a function started accepting env instead of a component. fixed #7305
8142 by bobbysmith007 on 2010-06-22 21:03:00
added a comment
8141 by bobbysmith007 on 2010-06-22 20:56:00
Converting to use new trac12 DB convensions. version 0.9.8b
8140 by bobbysmith007 on 2010-06-22 19:57:45
Working on converting DB access to trac12 standards. version 0.9.8
8131 by bobbysmith007 on 2010-06-18 20:31:32
attempting to make TandE handle times the way Trac12 wants re #7055
8130 by bobbysmith007 on 2010-06-18 19:23:35
fixed missing import that would cause ticket query exports with CC/Reporter to error, fixes #7244
8124 by bobbysmith007 on 2010-06-18 18:08:51
First trac-12 version, changed db access to not close databases (now that its not good to do so) re #7259
8123 by bobbysmith007 on 2010-06-18 17:49:04
branching for trac 12
8122 by bobbysmith007 on 2010-06-18 17:48:30
branching anew for trac12
8107 by bobbysmith007 on 2010-06-09 15:23:21
Applied patch to add stylesheet in a better way - version 0.9.4 and 0.9.4b fix #7224
7919 by bobbysmith007 on 2010-05-03 21:49:16
Second stab at fixing blackmagic permissions on the select type fields. ver: 0.9.3b fix #6985
7869 by bobbysmith007 on 2010-04-19 16:09:25
Made permissions handle elements that are not INPUT (eg: select) re #6985
7840 by bobbysmith007 on 2010-04-12 14:35:56
Updated permissions user manual. Bill dates on Billing/Management screen are now sorted in decending cron order version 0.9.1
7477 by bobbysmith007 on 2010-01-25 16:13:27
Made the stopwatch component less susceptible to browser flakiness and jsavascript slowdown. (Thanks T.R.Chuan)
7437 by bobbysmith007 on 2010-01-22 15:21:29
added author note re #6469
7436 by bobbysmith007 on 2010-01-22 15:17:43
merged stopwatch into trac0.11-Permissions branch re #6469
7435 by bobbysmith007 on 2010-01-22 15:11:34
Merged in stopwatch changes to trac0.11 branch re #6469
7434 by bobbysmith007 on 2010-01-22 14:14:15
removed misleading log message see: #6478
7433 by bobbysmith007 on 2010-01-22 14:13:23
removed misleading log message re #6478
7235 by bobbysmith007 on 2009-12-09 15:00:36
While I could not reproduce the error on my end, I made the blackmagic istrue function be more robust. This should take care of type errors being experienced. fixes #6305
7234 by bobbysmith007 on 2009-12-09 14:46:25
Fixed bug in linkifyer where null values were treated as invalid dates. Sorry for the trouble :/ fixes #6306
7231 by bobbysmith007 on 2009-12-08 18:40:43
got it alerting invalid dates
re #6229
7230 by bobbysmith007 on 2009-12-08 18:36:57
fixes #6229

Date entry on the billing/management/time reports screen should be more forgiving.

I have pulled in a javascript date library that seems to do a better job of parsing arbitrary date formats. On my check it seems to support both the current date format and iso8601 type descending precedence dates.

http://www.datejs.com/

Hope this helps
Russ

7011 by bobbysmith007 on 2009-11-02 21:24:05
fixed #6076 - Changed the way I was filtering TandE report rows, so that it would work with newer genshis and newer tracs
7000 by bobbysmith007 on 2009-11-02 17:55:13
Made report filters commit/close their db connection
6902 by bobbysmith007 on 2009-10-27 18:31:19
fixes #6043 during ticket field validation dont throw exceptions if the field isnt there
6826 by bobbysmith007 on 2009-10-23 14:28:38
fixed bug when other plugins are using the report view template re #6026
6790 by bobbysmith007 on 2009-10-21 21:51:02
fixed #5997 found what seems to be a bug in Transformer.filter, added a new FilterTransformation and apply that instead
6591 by bobbysmith007 on 2009-09-24 22:23:45
started work to add "Add Time" buttons next to comments that will set the add hours field appropriatly (off by default with config to turn on)
6531 by bobbysmith007 on 2009-09-11 15:06:01
trying to remove deprecation warnings
6451 by bobbysmith007 on 2009-08-28 15:11:39
close #4670 found a problem with ticket_policy that would cause it to fail on total rows of reports
6269 by bobbysmith007 on 2009-07-22 17:42:04
closes #5468 after googling about, I think I found a way to get around the warnings. I dont have python 2.6, but it works in python 2.4
6268 by bobbysmith007 on 2009-07-22 17:29:51
re #5489 changed the ticket validation code to be forgiving of empty values, treating them like a 0 instead of a validation error.
5684 by bobbysmith007 on 2009-05-07 14:19:47
Got a patch from Ian Sherratt fixing a bug in the javascript that made it interact badly with the BatchModify plugin
5494 by bobbysmith007 on 2009-04-06 19:51:09
closes #4861 patched that so that it passes the unit tests. Thanks for the bug report.
5493 by bobbysmith007 on 2009-04-06 18:53:23
re #4184 ported changes to permissions branch and fixed a missing function ref in reportmanager
5492 by bobbysmith007 on 2009-04-06 18:47:40
reset the report version number since it didnt change (it was changed for debugging)
5491 by bobbysmith007 on 2009-04-06 18:43:55
fixes #4184 Reworked the report upgrade code to allow deletion of reports. If the report version is updated the report is reinstalled.
5486 by bobbysmith007 on 2009-04-06 15:43:50
close #4886 Upgrade should now respect user defined labels and default values
5370 by bobbysmith007 on 2009-03-19 20:05:02
Applied patch from Greg Troxel to bring post commit hook inline with upstream trac (THANKS!)
5368 by bobbysmith007 on 2009-03-19 14:54:44
changed line endings in post commit scripts to unix (rather than win)
5348 by bobbysmith007 on 2009-03-09 15:25:03
fixed bug in hidding unselected checkboxes re #4400
5162 by bobbysmith007 on 2009-01-28 11:24:21
closes #1376 Much thanks to Anonymous for the patch!

Adds standard trac validation on the ticket hours and estimated hours fields
New version is 0.7.6 and available

4874 by bobbysmith007 on 2008-11-25 22:39:55
re #4141
re #4111

fixed stack overflow that was caused by a change in how INavigationProvider worked. This is now using genshi filters which should allow it to work a bit better (aka no stack overflow)

4783 by bobbysmith007 on 2008-11-13 01:03:26
closes #1593 made billdates render in a manner close to ISO 8601 (without TZ)
4782 by bobbysmith007 on 2008-11-13 00:31:50
closes #4008 Made Billing page matching more precise
4382 by bobbysmith007 on 2008-10-03 15:40:57
fixes #3833 changed all the null as tickets to 0 as ticket (this still seems like a bug in trac, but one easily enough fixed
4358 by bobbysmith007 on 2008-09-29 17:16:53
re #3828 fixed a bug in ticket policy where it should have been checking for a permission or a group, but was only checking for a permission
4293 by bobbysmith007 on 2008-09-18 21:02:47
added ticket_policy which allows us to have an 'internal' checkbox to turn off certain tickets.

added internal checkbox

Updated the manual to contain the new stuff.

4282 by bobbysmith007 on 2008-09-14 17:15:47
actually enforce permissions instead of just denying access to billing report csv-exports
4281 by bobbysmith007 on 2008-09-14 17:06:04
Monkey patched the report module to allow enforcing permissions in _send_csv
4280 by bobbysmith007 on 2008-09-14 16:56:26
prevent the billing reports from being rendered if the user does not have permissions
4279 by bobbysmith007 on 2008-09-14 15:50:41
Got query screen exports correctly enforcing field permissions (had to monkey patch the query module)
4271 by bobbysmith007 on 2008-09-11 21:15:01
added permission check for adding hours to the ticket_daemon
4270 by bobbysmith007 on 2008-09-11 18:30:07
worked it out so that form fields that are hidden are still submitted (such as billable which needs to as a checkbox)
4269 by bobbysmith007 on 2008-09-11 16:52:20
closes #3702

python 2.3 doesnt support generator expressions. I have changed that to just a list comprehension which should work as well.

4268 by bobbysmith007 on 2008-09-11 16:12:04
removed extra log message
4267 by bobbysmith007 on 2008-09-11 14:05:13
removed some excess installer
4266 by bobbysmith007 on 2008-09-11 13:52:04
changed blackmagics permissions stuff to make sense and also made api do upgrades in the correct order
4265 by bobbysmith007 on 2008-09-11 13:35:04
updated the user manual and added default ticket field permissions to the installer
4264 by bobbysmith007 on 2008-09-11 13:06:53
improved logging

added a filter for the query screen that enforces permissions

4261 by bobbysmith007 on 2008-09-11 12:06:56
finished the ticket permissions
Commented out the javascript that hid the hours in the header now that I can do that from python
(based on additions to blackmagic plugin: http://trac-hacks.org/wiki/BlackMagicTicketTweaksPlugin)
4260 by bobbysmith007 on 2008-09-10 22:40:17
mostly worked out the filters now, just tweaking how the config will work
4259 by bobbysmith007 on 2008-09-10 21:00:26
4258 by bobbysmith007 on 2008-09-10 16:13:58
straightening out some permission stuff
4257 by bobbysmith007 on 2008-09-10 16:08:17
added an external for blackmagic
4255 by bobbysmith007 on 2008-09-10 14:50:16
Made a start on a new branch (sponsored by Obsidian Software) that incorporates permissions into T&E
4253 by bobbysmith007 on 2008-09-10 13:49:55
4245 by bobbysmith007 on 2008-09-08 15:15:23
Added a copy of my git-post-receive incase others are interested this interacts with the trac-post-commit hook
4233 by bobbysmith007 on 2008-09-03 12:38:11
fixes #3646

There were a couple of flaws in the logic of recording ticket times.
I cleaned that up a bit, and verified that it correctly records times and estimations

4171 by bobbysmith007 on 2008-08-21 17:52:14
closes #3588 re #3579 thanks for catching that, this patch fixes a bug where i would occasionaly try to replace on a value I wasnt sure was a string
4170 by bobbysmith007 on 2008-08-21 17:51:51
closes #3588 re #3579 thanks for catching that, this patch fixes a bug where i would occasionaly try to replace on a value I wasnt sure was a string
4168 by bobbysmith007 on 2008-08-21 17:31:10
re #3579

Updating this to better support entry of floats that use comma as the decimal separator

version 0.6.9

4166 by bobbysmith007 on 2008-08-21 17:29:50
re #3579

I found that this was creating extra changelog crap that it shouldnt have. This fixes that by not inserting changes that were not changes.

4165 by bobbysmith007 on 2008-08-21 16:13:17
closes #3579 updated version to 0.6.9
4164 by bobbysmith007 on 2008-08-21 16:12:30
re #3579 this should hopefully successfully convert all incoming hour strings into a form where decimals are separated by . rather than ,
4158 by bobbysmith007 on 2008-08-20 13:50:39
re #3579 T&E 0.6.8 made the ticket_daemon handle numbers with , as the decimal separator
4157 by bobbysmith007 on 2008-08-20 13:50:19
re #3579 T&E 0.6.8 made the ticket_daemon handle numbers with , as the decimal separator
4069 by bobbysmith007 on 2008-07-28 17:48:09
closes #3166

applied patch that adds commits to the ticket_daemon (necessary for some dbs)
bumped version to 0.6.7

4020 by bobbysmith007 on 2008-07-16 15:45:22
closes #3125 Added some code to make the postgres install not choke after inserting reports. This basically involved manually moving the sequence forward.
3962 by bobbysmith007 on 2008-07-04 17:41:47
re #3329 tried importing set to increase backwards compatibility
3960 by bobbysmith007 on 2008-07-04 17:16:57
re #3329 removed the decorator that seemed to be breaking backward compatibility
3785 by bobbysmith007 on 2008-06-04 13:36:00
closes #3131
closes #3074
T&E(trac 10) 0.6.6

I brought the trac 10 branch up to the same version number of the plugin so that hopefully there is less confusion on my part about versions.

Fixes horrible bug relating to database access (due to my misunderstanding of which things were stateful in trac/python).

Fixed some bugs in the way billable values were being compared in the reports file (strong vs weak typed databases)

3784 by bobbysmith007 on 2008-06-04 13:30:58
closes #3131
closes #3074
T&E 0.6.6

Fixes horrible bug relating to database access (due to my misunderstanding of which things were stateful in trac/python).

Fixed some bugs in the way billable values were being compared in the reports file (strong vs week typed databases)

3687 by bobbysmith007 on 2008-05-16 13:14:57
made commit hook regexes be case insensitive
3686 by bobbysmith007 on 2008-05-16 13:14:45
made commit hook regexes be case insensitive
3521 by bobbysmith007 on 2008-04-16 18:37:17
closes #2862
closes #2763

Fixed reports for mysql. Also made the plugin handle status names that contain an underscore.

version 0.6.5

3520 by bobbysmith007 on 2008-04-16 18:16:46
closes #2862

version 0.5.6 update reports sql to be mysql 5 compatible

3398 by bobbysmith007 on 2008-03-19 15:06:28
closes #2334

Added that t.summary to the group by clause as that did not change my results with SQLite and was preventing someone from using it with a different database

What database are you using?

3363 by bobbysmith007 on 2008-03-14 17:58:06
re #2381

I have added a pair of square brackets, though I am not sure if this will fix you problem or not

3362 by bobbysmith007 on 2008-03-14 17:52:42
closes #2740

Made the billable field not be required. the upgrade manager should no longer look for

I have not had the chance to test this (my trac environ is down at the moment, but it should work and if you have any problems, please let me know.

3350 by bobbysmith007 on 2008-03-12 16:27:29
re # 2497

Fixed comment that is malformed for MySql

3182 by bobbysmith007 on 2008-02-06 00:12:29
re #2519 version 0.6.2

Sorry, I had this file open in two windows and corrected that syntax error in one and not the other.

Doh, syntax error in api.py should be fixed now

3179 by bobbysmith007 on 2008-02-05 16:05:21
re #2519 T&E for trac 11 version 0.6.1

I concluded that the logic to figure out when to upgrade reports was fairly incorrect and so rewrote what I hope will be a better fucntion for this. I also added some more logging statements to help debug this in the future

3119 by bobbysmith007 on 2008-01-21 19:36:51
closes #2438

Replaced dbhelper with a version of that file that maintains its own connections (via an env var set during environment setup)

2948 by bobbysmith007 on 2007-12-28 19:15:53
re #2334
closes #2335

Fixed error caused by printing to std out rather than to the trac log.
There might also be an underlying error, but I cannot recreate it right now (all reports work for me with this version of the plugin).

2893 by bobbysmith007 on 2007-12-13 17:24:44
closes #2239

Fixed bug where db.commit became necessary and wasnt being called. This was causing the ticket observer to fail in it duties.
Also fixed a potential bug in dbhelper having to do with iterating over None.

2850 by bobbysmith007 on 2007-12-05 18:17:59
added documentation back to post-commit hook
2835 by bobbysmith007 on 2007-11-28 13:56:52
re #2171

Fixed typo.

2824 by bobbysmith007 on 2007-11-26 16:50:21
fixed some bugs in the api about updating the system version for the trac10 version of the plugin.

Also tried to synch various versions of the dbhelper functions

2823 by bobbysmith007 on 2007-11-26 15:50:35
closes #2205
TandE (trac11) version 0.5.6

Fixed a few bugs related to starting an environment from scratch.
Fixed a bug in get scalar that caused every execute to fail.

2813 by bobbysmith007 on 2007-11-21 16:45:17
closes #2205

Fixed bug in report manager where it was throwing an error while trying to (None+1).

T&E trac11 version 0.5.5

2806 by bobbysmith007 on 2007-11-20 21:26:51
turning off logging by default
2805 by bobbysmith007 on 2007-11-20 21:26:09
updated the trac-post-commit.py to be more like the official trac version of this.
2804 by bobbysmith007 on 2007-11-20 19:28:14
removed random accidental paste
2803 by bobbysmith007 on 2007-11-20 19:27:40
Turned Logging off by default
2786 by bobbysmith007 on 2007-11-15 22:47:44
closes #2155

Fixed goofy javascript bugs that were cause because of anomalous text nodes in the dom.

T&E trac 10 - 0.5.1
T&E trac 11 - 0.5.4

2785 by bobbysmith007 on 2007-11-15 21:44:29
closes #1995

updated reports to use datetime as the column name instead of time.

refactored the reportsmanager a bit more and used these changes to make it update reports when their version changes as opposed to having to change my system version as well.

T&E (trac11) version 0.5.3

2782 by bobbysmith007 on 2007-11-15 16:55:02
closes #2127

Changed the javascript that changes hours to hours/minutes to handle negative values. I also made this javascript work again in trac.11

trac0.10 - T&E ver 0.5.0
trac0.11 - T&E ver 0.5.2

2778 by bobbysmith007 on 2007-11-14 16:05:20
closes #2171

Upgraded the trac-post-commit.py to be compatable with trac 11

2776 by bobbysmith007 on 2007-11-14 05:15:25
re #1913

refactored reportmanager a bit more in response to feed back from Colin Guthrie

bumped version number to 0.5.1

2775 by bobbysmith007 on 2007-11-13 23:01:45
re #1913
bumped version number to 0.5.0
2774 by bobbysmith007 on 2007-11-13 22:53:28
closes #1913

After much waiting and thinking, I came to the conclusion that the best way to handle the dynamic statuses was to rebuild the reports each time they change. To that end I have added code to check to see if the statuses have changed and then update the reports with the new statuses every time they change (requiring a trac-admin upgrade). Rendering out the statuses and the linkifying javascript were changed to be compatible with this.

2590 by bobbysmith007 on 2007-08-22 17:35:23
closes #1697 I was wrong about this, It was just a leftover quirk and has been removed

closes #901 reports now contain time remaining

closes #1958 added case statements all over the place to better support postegres when there are null/empty values

closes #1959 changed the work summary report to include links to the ticket and ticket summaries

Now at version 0.4.9

2538 by bobbysmith007 on 2007-07-31 15:00:01

TimingAndEstimationPlugin:

closes #1870
re #1873

  • (.11) applied patch to increase trac forge compatability
  • (.11) I also got David Abrahams Genshi Filters working and applied
  • (.10 & .11) changed user manual
2489 by bobbysmith007 on 2007-07-19 12:36:41
TimingAndEstimationPlugin:

moved trunk to a different name, since now there are just two branches, one for either version of trac and trunk really shouldnt be used

2467 by bobbysmith007 on 2007-07-14 03:07:53
TimingAndEstimationPlugin:

closes #1791

fixed bug in the way I was emitting the javascript that was causing infinite recursion.

2460 by bobbysmith007 on 2007-07-12 15:25:15
TimingAndEstimationPlugin:

closes #1772

added javascript provided by Colin Guthrie that:

  • Changes the totalhours field to a non-editable span (no change).
  • Changes the estimated hours and total hours fields in the header table to be hours/minutes rather than a conceptually harder for humans decimal value!
  • Changes the billable flag in the header table to read Yes or No rather than 1 or 0.
  • Does the above two changes for all changelog entries through the ticket.

The only change I made to the javascript was to not emit any javascript into the global environment, instead add everything as local to a function that gets executed. Should keep the browser's namespace a bit cleaner for greasemonkey/other scripts and what not.

2390 by bobbysmith007 on 2007-07-05 14:00:57
TimingAndEstimationPlugin:

closes #1737

Applied Colin Guthrie's patch to make managing custom reports easier.

Thanks for the patch!

2372 by bobbysmith007 on 2007-07-03 15:02:20
TimingAndEstimationPlugin:

closes #1723

Ok I think this patch fixes the problem with fresh installs not working (we cant iterate over None).

Please reopen or create a new ticket, if you continue to have trouble

2349 by bobbysmith007 on 2007-06-28 14:23:54
TimingAndEstimationPlugin:

closes #1043

There is now a way to add custom reports to the management page. This is explained in the user manual (which is also upgraded in this version).

2331 by bobbysmith007 on 2007-06-25 13:58:41
TimingAndEstimationPlugin:

re #1697

Changed REAL to DECIMAL in all reports and bumped the version number up to 0.4.2

2298 by bobbysmith007 on 2007-06-13 14:42:08
TimingAndEstimationPlugin:

re #1653

Initial Checking for trac0.11 version of the plugin.

  • Converted Management Page to Genshi
  • added some integration with the query module
    • Add total rows for every numeric column (handled in javascript)
    • This will not be able replace reports until the results can be limited by ticket change time. (not really likely). Hopefully it will at the very least make working with the plugin a bit nicer in some circumstances.


2297 by bobbysmith007 on 2007-06-13 14:29:44
TimingAndEstimationPlugin:

made a copy

2296 by bobbysmith007 on 2007-06-13 14:28:50
TimingAndEstimationPlugin:

made a copy

2295 by bobbysmith007 on 2007-06-13 14:25:18
TimingAndEstimationPlugin:

added branches folder

2291 by bobbysmith007 on 2007-06-11 14:06:07
TimingAndEstimationPlugin:

re #1648

Added jonas' patch that makes it no longer necesary to have base_url specified in the trac conf

also added a file that should have been there a while ago

2284 by bobbysmith007 on 2007-06-07 13:26:27
TimingAndEstimationPlugin:

Upgraded User Manual to contain links back to the plugin.

2254 by bobbysmith007 on 2007-05-22 12:05:40
TimingAndEstimationPlugin:

made trac-post-commit handle hours longer than 9 (thanks to didoux on trac-hacks)

2015 by bobbysmith007 on 2007-02-21 17:24:50
TimingAndEstimationPlugin:

#1230
fixed a bug having to do with timestamps in trac.11

1906 by bobbysmith007 on 2007-01-25 14:54:21
TimingAndEstimationPlugin:

added bookmarklet javascript

1852 by bobbysmith007 on 2007-01-08 17:29:43
TimingAndEstimationPlugin:

made this accept both .25 and 0.25 where it used to only accept 0.25 for times. also removed logging code that might cause issues

1847 by bobbysmith007 on 2007-01-05 21:19:55
TimingAndEstimationPlugin:
1840 by bobbysmith007 on 2007-01-02 21:33:30
TimingAndEstimationPlugin:

trying to fix mysql error that shouldnt be occuring

version 0.3.7

1710 by bobbysmith007 on 2006-12-18 17:12:48
TimingAndEstimationPlugin:

removed some sql injection possibility and added a bug fix for a future version of trac (beyond 10.3)

Plugin version 0.3.6

1693 by bobbysmith007 on 2006-12-14 23:49:34
TimingAndEstimationPlugin:

fixing ticket:941 comment 17 0.3.5

1692 by bobbysmith007 on 2006-12-13 22:30:20
TimingAndEstimationPlugin:

make the db layer not so error prone

1670 by bobbysmith007 on 2006-12-12 16:04:55
TimingAndEstimationPlugin:

Updated user manual and made the button on the navbar say 'Management' rather than 'Billing and Estimation' because it takes less of this important space.
0.3.3

1667 by bobbysmith007 on 2006-12-11 17:24:33
TimingAndEstimationPlugin:

Incorporated changed from kkurzweil@… for postegresql compatibility.

1631 by bobbysmith007 on 2006-12-04 22:43:18
TimingAndEstimationPlugin:

Fixed safari javascript bug

1627 by bobbysmith007 on 2006-12-04 20:54:00
TimingAndEstimationPlugin:

fixed bug where hours added to a ticket when it is created didnt work particularly. It now should

1626 by bobbysmith007 on 2006-12-04 19:49:58
TimingAndEstimationPlugin:

trying to get postgres to work during trac upgrades. It was giving errors about aborted transactions. In playing in IPython, I was able to figure out that it had somethign to do with needing to commit after every use of the connection. Normally I don't commit after selects. This has changed.
see ticket:957

1606 by bobbysmith007 on 2006-11-27 16:00:31
TimingAndEstimationPlugin:

version 0.2.8
We have postgre compatable reports (thanks masariello). (Also fixed a bug in the report map)

1586 by bobbysmith007 on 2006-11-22 17:44:59
TimingAndEstimationPlugin:

Attempting to fix the reports for postegres (again) ticket:861 ticket:927

1578 by bobbysmith007 on 2006-11-17 17:15:57
TimingAndEstimationPlugin:

Fixed bug that affected tickets created before the plugin was installed. SEE ticket:#918 on trachacks

1571 by bobbysmith007 on 2006-11-15 18:19:12
TimingAndEstimationPlugin:

Updated reports in an effort to make sum work on postegre and fix rollups showing at the top rather than the bottom of the ticket

1554 by bobbysmith007 on 2006-11-13 20:43:24
TimingAndEstimationPlugin:

added field ordinalls and added missing pass in init of ticket_webui

1516 by bobbysmith007 on 2006-11-10 17:03:50
TimingAndEstimationPlugin:

My attempt at enforcing the "dont edit the total hours field" rule. Javascript replaces the input with a span now (which was what I wanted anyway)

1496 by bobbysmith007 on 2006-11-08 17:45:46
TimingAndEstimationPlugin:

Trying ot upgrade reports so that they work in more databases (postgre)

1444 by bobbysmith007 on 2006-10-23 17:14:39
TimingAndEstimationPlugin:

trying to fix where time got corrupted on the wiki table for a while (The user manual entry has %s rather than a valid int)

1397 by bobbysmith007 on 2006-10-18 18:53:50
TimingAndEstimationPlugin:

Real version 0.2.0 The previous one had an error in one of the column names

1396 by bobbysmith007 on 2006-10-18 18:40:03
TimingAndEstimationPlugin:

Version 0.2.0 everything should now support all database backends this patch removed string formating of dates from th Billing Reports

1390 by bobbysmith007 on 2006-10-16 17:47:59
TimingAndEstimationPlugin:

bumped version

1389 by bobbysmith007 on 2006-10-16 17:46:55
TimingAndEstimationPlugin:

Fixed database compatiblity bug for the MySqldb connector (it returns tuples rather than the lists of other connectors when calling cursor.fetchall)

1370 by bobbysmith007 on 2006-10-10 13:24:14
TimingAndEstimationPlugin:

bumped version

1369 by bobbysmith007 on 2006-10-10 13:22:17
TimingAndEstimationPlugin:

Working toward postegres compatibility. Removed square brackets and an instance of the sqlite strftime

1365 by bobbysmith007 on 2006-10-09 18:21:32
TimingAndEstimationPlugin:

first attempt at postegres compatability (plugin version 0.1.7)

1286 by bobbysmith007 on 2006-09-19 22:57:45
TimingAndEstimationPlugin:

Upgrading to match new Trac API

1285 by bobbysmith007 on 2006-09-19 22:43:44
TimingAndEstimationPlugin:
1284 by bobbysmith007 on 2006-09-19 22:42:09
TimingAndEstimationPlugin:

This is a tag before changing the ticket_chaged_observer api (trac changeset 3692)

1283 by bobbysmith007 on 2006-09-19 22:39:33
TimingAndEstimationPlugin:

Moved everything into the trunk folder

1282 by bobbysmith007 on 2006-09-19 22:37:49
TimingAndEstimationPlugin:

Added Trunk and tags folder so that I caould tag a version before a breaking change

1204 by bobbysmith007 on 2006-08-28 22:22:06
TimingAndEstimationPlugin:

Fixed bugs related to print and CGI as well as some template markup bugs

1177 by bobbysmith007 on 2006-08-22 13:46:02
TimingAndEstimationPlugin:

Fixed some bugs reported in ticket #624 that had to do with column names

1120 by bobbysmith007 on 2006-08-15 14:36:04
TimingAndEstimationPlugin:
1119 by bobbysmith007 on 2006-08-15 14:30:54
TimingAndEstimationPlugin:

Initial Checkin of version 0.1.3

1062 by bobbysmith007 on 2006-07-25 20:02:59
New hack TimingAndEstimationPlugin, created by bobbysmith007
(more)

Last modified 17 years ago Last modified on Jun 7, 2007, 1:29:11 PM