[4382] by bobbysmith007 on 10/03/08 10: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 09/29/08 12: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 09/18/08 16: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 09/14/08 12:15:47
actually enforce permissions instead of just denying access to billing report csv-exports
[4281] by bobbysmith007 on 09/14/08 12:06:04
Monkey patched the report module to allow enforcing permissions in _send_csv
[4280] by bobbysmith007 on 09/14/08 11:56:26
prevent the billing reports from being rendered if the user does not have permissions
[4279] by bobbysmith007 on 09/14/08 10:50:41
Got query screen exports correctly enforcing field permissions (had to monkey patch the query module)
[4271] by bobbysmith007 on 09/11/08 16:15:01
added permission check for adding hours to the ticket_daemon
[4270] by bobbysmith007 on 09/11/08 13: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 09/11/08 11: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 09/11/08 11:12:04
removed extra log message
[4267] by bobbysmith007 on 09/11/08 09:05:13
removed some excess installer
[4266] by bobbysmith007 on 09/11/08 08:52:04
changed blackmagics permissions stuff to make sense and also made api do upgrades in the correct order
[4265] by bobbysmith007 on 09/11/08 08:35:04
updated the user manual and added default ticket field permissions to the installer
[4264] by bobbysmith007 on 09/11/08 08:06:53
improved logging
added a filter for the query screen that enforces permissions
[4261] by bobbysmith007 on 09/11/08 07: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 09/10/08 17:40:17
mostly worked out the filters now, just tweaking how the config will work
[4259] by bobbysmith007 on 09/10/08 16:00:26
[4258] by bobbysmith007 on 09/10/08 11:13:58
straightening out some permission stuff
[4257] by bobbysmith007 on 09/10/08 11:08:17
added an external for blackmagic
[4255] by bobbysmith007 on 09/10/08 09:50:16
Made a start on a new branch (sponsored by Obsidian Software) that incorporates permissions into T&E
[4253] by bobbysmith007 on 09/10/08 08:49:55
[4245] by bobbysmith007 on 09/08/08 10: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 09/03/08 07: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 08/21/08 12: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 08/21/08 12: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 08/21/08 12: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 08/21/08 12: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 08/21/08 11:13:17
closes #3579 updated version to 0.6.9
[4164] by bobbysmith007 on 08/21/08 11: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 08/20/08 08:50:39
re #3579 T&E 0.6.8 made the ticket_daemon handle numbers with , as the decimal separator
[4157] by bobbysmith007 on 08/20/08 08:50:19
re #3579 T&E 0.6.8 made the ticket_daemon handle numbers with , as the decimal separator
[4069] by bobbysmith007 on 07/28/08 12: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 07/16/08 10: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 07/04/08 12:41:47
re #3329 tried importing set to increase backwards compatibility
[3960] by bobbysmith007 on 07/04/08 12:16:57
re #3329 removed the decorator that seemed to be breaking backward compatibility
[3785] by bobbysmith007 on 06/04/08 08: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 06/04/08 08: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 05/16/08 08:14:57
made commit hook regexes be case insensitive
[3686] by bobbysmith007 on 05/16/08 08:14:45
made commit hook regexes be case insensitive
[3521] by bobbysmith007 on 04/16/08 13:37:17
Fixed reports for mysql. Also made the plugin handle status names that contain an underscore.
version 0.6.5
[3520] by bobbysmith007 on 04/16/08 13:16:46
closes #2862
version 0.5.6 update reports sql to be mysql 5 compatible
[3398] by bobbysmith007 on 03/19/08 10: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 03/14/08 12: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 03/14/08 12: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 03/12/08 11:27:29
re # 2497
Fixed comment that is malformed for MySql?
[3182] by bobbysmith007 on 02/05/08 18: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 02/05/08 10: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 01/21/08 13: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 12/28/07 13:15:53
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 12/13/07 11: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 12/05/07 12:17:59
added documentation back to post-commit hook
[2835] by bobbysmith007 on 11/28/07 07:56:52
re #2171
Fixed typo.
[2824] by bobbysmith007 on 11/26/07 10: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 11/26/07 09: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 11/21/07 10: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 11/20/07 15:26:51
turning off logging by default
[2805] by bobbysmith007 on 11/20/07 15:26:09
updated the trac-post-commit.py to be more like the official trac version of this.
[2804] by bobbysmith007 on 11/20/07 13:28:14
removed random accidental paste
[2803] by bobbysmith007 on 11/20/07 13:27:40
Turned Logging off by default
[2786] by bobbysmith007 on 11/15/07 16: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 11/15/07 15: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 11/15/07 10: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 11/14/07 10:05:20
closes #2171
Upgraded the trac-post-commit.py to be compatable with trac 11
[2776] by bobbysmith007 on 11/13/07 23: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 11/13/07 17:01:45
re #1913 bumped version number to 0.5.0
[2774] by bobbysmith007 on 11/13/07 16: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 08/22/07 12: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 07/31/07 10:00:01
- (.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 07/19/07 07:36:41
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 07/13/07 22:07:53
closes #1791
fixed bug in the way I was emitting the javascript that was causing infinite recursion.
[2460] by bobbysmith007 on 07/12/07 10:25:15
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 07/05/07 09:00:57
closes #1737
Applied Colin Guthrie's patch to make managing custom reports easier.
Thanks for the patch!
[2372] by bobbysmith007 on 07/03/07 10:02:20
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 06/28/07 09:23:54
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 06/25/07 08:58:41
re #1697
Changed REAL to DECIMAL in all reports and bumped the version number up to 0.4.2
[2298] by bobbysmith007 on 06/13/07 09:42:08
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 06/13/07 09:29:44
made a copy
[2296] by bobbysmith007 on 06/13/07 09:28:50
made a copy
[2295] by bobbysmith007 on 06/13/07 09:25:18
added branches folder
[2291] by bobbysmith007 on 06/11/07 09:06:07
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 06/07/07 08:26:27
Upgraded User Manual to contain links back to the plugin.
[2254] by bobbysmith007 on 05/22/07 07:05:40
made trac-post-commit handle hours longer than 9 (thanks to didoux on trac-hacks)
[2015] by bobbysmith007 on 02/21/07 11:24:50
#1230 fixed a bug having to do with timestamps in trac.11
[1906] by bobbysmith007 on 01/25/07 08:54:21
added bookmarklet javascript
[1852] by bobbysmith007 on 01/08/07 11:29:43
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 01/05/07 15:19:55
[1840] by bobbysmith007 on 01/02/07 15:33:30
trying to fix mysql error that shouldnt be occuring
version 0.3.7
[1710] by bobbysmith007 on 12/18/06 11:12:48
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 12/14/06 17:49:34
fixing ticket:941 comment 17 0.3.5
[1692] by bobbysmith007 on 12/13/06 16:30:20
make the db layer not so error prone
[1670] by bobbysmith007 on 12/12/06 10:04:55
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 12/11/06 11:24:33
Incorporated changed from kkurzweil@lulu.com for postegresql compatibility.
[1631] by bobbysmith007 on 12/04/06 16:43:18
Fixed safari javascript bug
[1627] by bobbysmith007 on 12/04/06 14:54:00
fixed bug where hours added to a ticket when it is created didnt work particularly. It now should
[1626] by bobbysmith007 on 12/04/06 13:49:58
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 11/27/06 10:00:31
version 0.2.8 We have postgre compatable reports (thanks masariello). (Also fixed a bug in the report map)
[1586] by bobbysmith007 on 11/22/06 11:44:59
Attempting to fix the reports for postegres (again) ticket:861 ticket:927
[1578] by bobbysmith007 on 11/17/06 11:15:57
Fixed bug that affected tickets created before the plugin was installed. SEE ticket:#918 on trachacks
[1571] by bobbysmith007 on 11/15/06 12:19:12
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 11/13/06 14:43:24
added field ordinalls and added missing pass in init of ticket_webui
[1516] by bobbysmith007 on 11/10/06 11:03:50
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 11/08/06 11:45:46
Trying ot upgrade reports so that they work in more databases (postgre)
[1444] by bobbysmith007 on 10/23/06 12:14:39
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 10/18/06 13:53:50
Real version 0.2.0 The previous one had an error in one of the column names
[1396] by bobbysmith007 on 10/18/06 13:40:03
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 10/16/06 12:47:59
bumped version
[1389] by bobbysmith007 on 10/16/06 12:46:55
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 10/10/06 08:24:14
bumped version
[1369] by bobbysmith007 on 10/10/06 08:22:17
Working toward postegres compatibility. Removed square brackets and an instance of the sqlite strftime
[1365] by bobbysmith007 on 10/09/06 13:21:32
first attempt at postegres compatability (plugin version 0.1.7)
[1286] by bobbysmith007 on 09/19/06 17:57:45
Upgrading to match new Trac API
[1285] by bobbysmith007 on 09/19/06 17:43:44
[1284] by bobbysmith007 on 09/19/06 17:42:09
This is a tag before changing the ticket_chaged_observer api (trac changeset 3692)
[1283] by bobbysmith007 on 09/19/06 17:39:33
Moved everything into the trunk folder
[1282] by bobbysmith007 on 09/19/06 17:37:49
Added Trunk and tags folder so that I caould tag a version before a breaking change
[1204] by bobbysmith007 on 08/28/06 17:22:06
Fixed bugs related to print and CGI as well as some template markup bugs
[1177] by bobbysmith007 on 08/22/06 08:46:02
Fixed some bugs reported in ticket #624 that had to do with column names
[1120] by bobbysmith007 on 08/15/06 09:36:04
[1119] by bobbysmith007 on 08/15/06 09:30:54
Initial Checkin of version 0.1.3
[1062] by bobbysmith007 on 07/25/06 15:02:59
New hack TimingAndEstimationPlugin, created by bobbysmith007
