Navigation

← Previous Changeset
Next Changeset →

Changeset 2331

Timestamp:

06/25/07 08:58:41 (1 year ago)

Author:

bobbysmith007

Message:

TimingAndEstimationPlugin:

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

Files:

timingandestimationplugin/branches/trac0.10/setup.py (modified) (2 diffs)
timingandestimationplugin/branches/trac0.10/timingandestimationplugin/reports.py (modified) (27 diffs)
timingandestimationplugin/branches/trac0.11/setup.py (modified) (1 diff)
timingandestimationplugin/branches/trac0.11/timingandestimationplugin/reports.py (modified) (27 diffs)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

timingandestimationplugin/branches/trac0.10/setup.py

r2291	r2331
8	8	description='Plugin to make Trac support time estimation and tracking',
9	9	keywords='trac plugin estimation timetracking',
10		version='0.4.0',
	10	version='0.4.2',
11	11	url='',
12	12	license='http://www.opensource.org/licenses/mit-license.php',
…	…
16	16	This Trac 0.10 plugin provides support for Time estimation and tracking.
17	17
18		See http://trac-hacks.org/wiki/Tim~~eEstimationAndQuotingSpecificatio~~n for details.
	18	See http://trac-hacks.org/wiki/TimingAndEstimationPlugin for details.
19	19	""",
20	20	packages=[PACKAGE],

timingandestimationplugin/branches/trac0.10/timingandestimationplugin/reports.py

r1606	r2331
9	9	"title":"Ticket Work Summary",
10	10	"reportnumber":None,
11		"version":12,
	11	"version":13,
12	12	"sql":"""
13	13	SELECT __ticket__ as __group__, __style__, __ticket__,
…	…
15	15	FROM(
16	16	SELECT '' as __style__, author, t.id as __ticket__,
17		CAST(newvalue as REAL) as newvalue, ticket_change.time as time, 0 as _ord
	17	CAST(newvalue as DECIMAL) as newvalue, ticket_change.time as time, 0 as _ord
18	18	FROM ticket_change
19	19	JOIN ticket t on t.id = ticket_change.ticket
…	…
30	30	SELECT 'background-color:#DFE;' as __style__,
31	31	'Total work done on the ticket in the selected time period ' as author,
32		t.id as __ticket__, sum( CAST(newvalue as ~~real~~) ) as newvalue,
	32	t.id as __ticket__, sum( CAST(newvalue as DECIMAL) ) as newvalue,
33	33	NULL as time, 1 as _ord
34	34	FROM ticket_change
…	…
50	50	"title":"Milestone Work Summary",
51	51	"reportnumber":None,
52		"version":11,
	52	"version":12,
53	53	"sql":"""
54	54
…	…
58	58	FROM(
59	59	SELECT '' as __style__, t.id as ticket,
60		SUM(CAST(newvalue as ~~real~~)) as newvalue, t.summary as summary,
	60	SUM(CAST(newvalue as DECIMAL)) as newvalue, t.summary as summary,
61	61	MAX(ticket_change.time) as time, t.milestone as milestone, 0 as _ord
62	62	FROM ticket_change
…	…
74	74
75	75	SELECT 'background-color:#DFE;' as __style__, NULL as ticket,
76		sum(CAST(newvalue as ~~real~~)) as newvalue, 'Total work done' as summary,
	76	sum(CAST(newvalue as DECIMAL)) as newvalue, 'Total work done' as summary,
77	77	NULL as time, t.milestone as milestone, 1 as _ord
78	78	FROM ticket_change
…	…
97	97	"title":"Developer Work Summary",
98	98	"reportnumber":None,
99		"version":11,
	99	"version":12,
100	100	"sql":"""
101	101	SELECT author as __group__,__style__, ticket,
…	…
103	103	FROM(
104	104	SELECT '' as __style__, author, cast(t.id as text) as ticket,
105		CAST(newvalue as REAL) as newvalue, ticket_change.time as time, 0 as _ord
	105	CAST(newvalue as DECIMAL) as newvalue, ticket_change.time as time, 0 as _ord
106	106	FROM ticket_change
107	107	JOIN ticket t on t.id = ticket_change.ticket
…	…
117	117
118	118	SELECT 'background-color:#DFE;' as __style__, author, NULL as ticket,
119		sum(CAST(newvalue as ~~real~~)) as newvalue, NULL as time, 1 as _ord
	119	sum(CAST(newvalue as DECIMAL)) as newvalue, NULL as time, 1 as _ord
120	120	FROM ticket_change
121	121	JOIN ticket t on t.id = ticket_change.ticket
…	…
138	138	"title": "Ticket Hours",
139	139	"reportnumber": None,
140		"version":8,
	140	"version":9,
141	141	"sql": """
142	142	SELECT __color__, __style__, ticket, summary, component ,version, severity,
…	…
147	147	t.id AS ticket, summary AS summary, -- ## Break line here
148	148	component,version, severity, milestone, status, owner,
149		CAST(EstimatedHours.value as REAL) as Estimated_work,
150		CAST(totalhours.value as REAL) as Total_work,
	149	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	150	CAST(totalhours.value as DECIMAL) as Total_work,
151	151	CASE WHEN billable.value = 1 THEN 'Y' else 'N' END as billable,
152	152	time AS created, changetime AS modified, -- ## Dates are formatted
…	…
176	176	NULL as ticket, 'Total' AS summary,
177	177	NULL as component,NULL as version, NULL as severity, NULL as milestone, NULL as status, NULL as owner,
178		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
179		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	178	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	179	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
180	180	NULL as billable,
181	181	NULL as created, NULL as modified, -- ## Dates are formatted
…	…
207	207	"title": "Ticket Hours with Description",
208	208	"reportnumber": None,
209		"version":9,
	209	"version":10,
210	210	"sql": """
211	211	SELECT __color__, __style__, ticket, summary, component ,version, severity,
…	…
222	222	t.id AS ticket, summary AS summary, -- ## Break line here
223	223	component,version, severity, milestone, status, owner,
224		CAST(EstimatedHours.value as REAL) as Estimated_work,
225		CAST(totalhours.value as REAL) as Total_work,
	224	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	225	CAST(totalhours.value as DECIMAL) as Total_work,
226	226	CASE WHEN billable.value = 1 THEN 'Y'
227	227	else 'N'
…	…
253	253	NULL as ticket, 'Total' AS summary,
254	254	NULL as component,NULL as version, NULL as severity, NULL as milestone, NULL as status, NULL as owner,
255		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
256		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	255	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	256	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
257	257	NULL as billable,
258	258	NULL as created, NULL as modified, -- ## Dates are formatted
…	…
285	285	"title":"Ticket Hours Grouped By Component",
286	286	"reportnumber":None,
287		"version":8,
	287	"version":9,
288	288	"sql": """
289	289	SELECT __color__, __group__, __style__, ticket, summary, __component__ ,version,
…	…
297	297	t.id AS ticket, summary AS summary, -- ## Break line here
298	298	component as __component__,version, severity, milestone, status, owner,
299		CAST(EstimatedHours.value as REAL) as Estimated_work,
300		CAST(totalhours.value as REAL) as Total_work,
	299	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	300	CAST(totalhours.value as DECIMAL) as Total_work,
301	301	CASE WHEN billable.value = 1 THEN 'Y'
302	302	else 'N'
…	…
331	331	NULL as milestone, NULL as status,
332	332	NULL as owner,
333		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
334		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	333	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	334	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
335	335	NULL as billable,
336	336	NULL as created,
…	…
365	365	"title":"Ticket Hours Grouped By Component with Description",
366	366	"reportnumber":None,
367		"version":7,
	367	"version":8,
368	368	"sql": """
369	369	SELECT __color__, __group__, __style__, ticket, summary, __component__ ,
…	…
377	377	t.id AS ticket, summary AS summary, -- ## Break line here
378	378	component as __component__, version, severity, milestone, status, owner,
379		CAST(EstimatedHours.value as REAL) as Estimated_work,
380		CAST(totalhours.value as REAL) as Total_work,
	379	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	380	CAST(totalhours.value as DECIMAL) as Total_work,
381	381	CASE WHEN billable.value = 1 THEN 'Y' else 'N' END as billable,
382	382	time AS created, changetime AS modified, -- ## Dates are formatted
…	…
408	408	t.component as __component__, NULL as version, NULL as severity,
409	409	NULL as milestone, NULL as status, NULL as owner,
410		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
411		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	410	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	411	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
412	412	NULL as billable,
413	413	NULL as created, NULL as modified, -- ## Dates are formatted
…	…
440	440	"title":"Ticket Hours Grouped By Milestone",
441	441	"reportnumber":None,
442		"version":8,
	442	"version":9,
443	443	"sql": """
444	444	SELECT __color__, __group__, __style__, ticket, summary, component ,version,
…	…
452	452	t.id AS ticket, summary AS summary, -- ## Break line here
453	453	component,version, severity, milestone as __milestone__, status, owner,
454		CAST(EstimatedHours.value as REAL) as Estimated_work,
455		CAST(totalhours.value as REAL) as Total_work,
	454	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	455	CAST(totalhours.value as DECIMAL) as Total_work,
456	456	CASE WHEN billable.value = 1 THEN 'Y'
457	457	else 'N'
…	…
484	484	NULL as component,NULL as version, NULL as severity,
485	485	t.milestone as __milestone__, NULL as status, NULL as owner,
486		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
487		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	486	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	487	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
488	488	NULL as billable,
489	489	NULL as created, NULL as modified, -- ## Dates are formatted
…	…
516	516	"title":"Ticket Hours Grouped By MileStone with Description",
517	517	"reportnumber":None,
518		"version":8,
	518	"version":9,
519	519	"sql": """
520	520	SELECT __color__, __group__, __style__, ticket, summary, component ,version, severity,
…	…
528	528	t.id AS ticket, summary AS summary, -- ## Break line here
529	529	component,version, severity, milestone as __milestone__, status, owner,
530		CAST(EstimatedHours.value as REAL) as Estimated_work,
531		CAST(totalhours.value as REAL) as Total_work,
	530	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	531	CAST(totalhours.value as DECIMAL) as Total_work,
532	532	CASE WHEN billable.value = 1 THEN 'Y'
533	533	else 'N'
…	…
562	562	t.milestone as __milestone__,
563	563	NULL as status, NULL as owner,
564		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
565		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	564	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	565	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
566	566	NULL as billable,
567	567	NULL as created, NULL as modified, -- ## Dates are formatted

timingandestimationplugin/branches/trac0.11/setup.py

r2298	r2331
8	8	description='Plugin to make Trac support time estimation and tracking',
9	9	keywords='trac plugin estimation timetracking',
10		version='0.4.1',
	10	version='0.4.2',
11	11	url='http://trac-hacks.org/wiki/TimingAndEstimationPlugin',
12	12	license='http://www.opensource.org/licenses/mit-license.php',

timingandestimationplugin/branches/trac0.11/timingandestimationplugin/reports.py

r1606	r2331
9	9	"title":"Ticket Work Summary",
10	10	"reportnumber":None,
11		"version":12,
	11	"version":13,
12	12	"sql":"""
13	13	SELECT __ticket__ as __group__, __style__, __ticket__,
…	…
15	15	FROM(
16	16	SELECT '' as __style__, author, t.id as __ticket__,
17		CAST(newvalue as REAL) as newvalue, ticket_change.time as time, 0 as _ord
	17	CAST(newvalue as DECIMAL) as newvalue, ticket_change.time as time, 0 as _ord
18	18	FROM ticket_change
19	19	JOIN ticket t on t.id = ticket_change.ticket
…	…
30	30	SELECT 'background-color:#DFE;' as __style__,
31	31	'Total work done on the ticket in the selected time period ' as author,
32		t.id as __ticket__, sum( CAST(newvalue as ~~real~~) ) as newvalue,
	32	t.id as __ticket__, sum( CAST(newvalue as DECIMAL) ) as newvalue,
33	33	NULL as time, 1 as _ord
34	34	FROM ticket_change
…	…
50	50	"title":"Milestone Work Summary",
51	51	"reportnumber":None,
52		"version":11,
	52	"version":12,
53	53	"sql":"""
54	54
…	…
58	58	FROM(
59	59	SELECT '' as __style__, t.id as ticket,
60		SUM(CAST(newvalue as ~~real~~)) as newvalue, t.summary as summary,
	60	SUM(CAST(newvalue as DECIMAL)) as newvalue, t.summary as summary,
61	61	MAX(ticket_change.time) as time, t.milestone as milestone, 0 as _ord
62	62	FROM ticket_change
…	…
74	74
75	75	SELECT 'background-color:#DFE;' as __style__, NULL as ticket,
76		sum(CAST(newvalue as ~~real~~)) as newvalue, 'Total work done' as summary,
	76	sum(CAST(newvalue as DECIMAL)) as newvalue, 'Total work done' as summary,
77	77	NULL as time, t.milestone as milestone, 1 as _ord
78	78	FROM ticket_change
…	…
97	97	"title":"Developer Work Summary",
98	98	"reportnumber":None,
99		"version":11,
	99	"version":12,
100	100	"sql":"""
101	101	SELECT author as __group__,__style__, ticket,
…	…
103	103	FROM(
104	104	SELECT '' as __style__, author, cast(t.id as text) as ticket,
105		CAST(newvalue as REAL) as newvalue, ticket_change.time as time, 0 as _ord
	105	CAST(newvalue as DECIMAL) as newvalue, ticket_change.time as time, 0 as _ord
106	106	FROM ticket_change
107	107	JOIN ticket t on t.id = ticket_change.ticket
…	…
117	117
118	118	SELECT 'background-color:#DFE;' as __style__, author, NULL as ticket,
119		sum(CAST(newvalue as ~~real~~)) as newvalue, NULL as time, 1 as _ord
	119	sum(CAST(newvalue as DECIMAL)) as newvalue, NULL as time, 1 as _ord
120	120	FROM ticket_change
121	121	JOIN ticket t on t.id = ticket_change.ticket
…	…
138	138	"title": "Ticket Hours",
139	139	"reportnumber": None,
140		"version":8,
	140	"version":9,
141	141	"sql": """
142	142	SELECT __color__, __style__, ticket, summary, component ,version, severity,
…	…
147	147	t.id AS ticket, summary AS summary, -- ## Break line here
148	148	component,version, severity, milestone, status, owner,
149		CAST(EstimatedHours.value as REAL) as Estimated_work,
150		CAST(totalhours.value as REAL) as Total_work,
	149	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	150	CAST(totalhours.value as DECIMAL) as Total_work,
151	151	CASE WHEN billable.value = 1 THEN 'Y' else 'N' END as billable,
152	152	time AS created, changetime AS modified, -- ## Dates are formatted
…	…
176	176	NULL as ticket, 'Total' AS summary,
177	177	NULL as component,NULL as version, NULL as severity, NULL as milestone, NULL as status, NULL as owner,
178		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
179		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	178	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	179	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
180	180	NULL as billable,
181	181	NULL as created, NULL as modified, -- ## Dates are formatted
…	…
207	207	"title": "Ticket Hours with Description",
208	208	"reportnumber": None,
209		"version":9,
	209	"version":10,
210	210	"sql": """
211	211	SELECT __color__, __style__, ticket, summary, component ,version, severity,
…	…
222	222	t.id AS ticket, summary AS summary, -- ## Break line here
223	223	component,version, severity, milestone, status, owner,
224		CAST(EstimatedHours.value as REAL) as Estimated_work,
225		CAST(totalhours.value as REAL) as Total_work,
	224	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	225	CAST(totalhours.value as DECIMAL) as Total_work,
226	226	CASE WHEN billable.value = 1 THEN 'Y'
227	227	else 'N'
…	…
253	253	NULL as ticket, 'Total' AS summary,
254	254	NULL as component,NULL as version, NULL as severity, NULL as milestone, NULL as status, NULL as owner,
255		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
256		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	255	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	256	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
257	257	NULL as billable,
258	258	NULL as created, NULL as modified, -- ## Dates are formatted
…	…
285	285	"title":"Ticket Hours Grouped By Component",
286	286	"reportnumber":None,
287		"version":8,
	287	"version":9,
288	288	"sql": """
289	289	SELECT __color__, __group__, __style__, ticket, summary, __component__ ,version,
…	…
297	297	t.id AS ticket, summary AS summary, -- ## Break line here
298	298	component as __component__,version, severity, milestone, status, owner,
299		CAST(EstimatedHours.value as REAL) as Estimated_work,
300		CAST(totalhours.value as REAL) as Total_work,
	299	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	300	CAST(totalhours.value as DECIMAL) as Total_work,
301	301	CASE WHEN billable.value = 1 THEN 'Y'
302	302	else 'N'
…	…
331	331	NULL as milestone, NULL as status,
332	332	NULL as owner,
333		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
334		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	333	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	334	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
335	335	NULL as billable,
336	336	NULL as created,
…	…
365	365	"title":"Ticket Hours Grouped By Component with Description",
366	366	"reportnumber":None,
367		"version":7,
	367	"version":8,
368	368	"sql": """
369	369	SELECT __color__, __group__, __style__, ticket, summary, __component__ ,
…	…
377	377	t.id AS ticket, summary AS summary, -- ## Break line here
378	378	component as __component__, version, severity, milestone, status, owner,
379		CAST(EstimatedHours.value as REAL) as Estimated_work,
380		CAST(totalhours.value as REAL) as Total_work,
	379	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	380	CAST(totalhours.value as DECIMAL) as Total_work,
381	381	CASE WHEN billable.value = 1 THEN 'Y' else 'N' END as billable,
382	382	time AS created, changetime AS modified, -- ## Dates are formatted
…	…
408	408	t.component as __component__, NULL as version, NULL as severity,
409	409	NULL as milestone, NULL as status, NULL as owner,
410		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
411		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	410	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	411	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
412	412	NULL as billable,
413	413	NULL as created, NULL as modified, -- ## Dates are formatted
…	…
440	440	"title":"Ticket Hours Grouped By Milestone",
441	441	"reportnumber":None,
442		"version":8,
	442	"version":9,
443	443	"sql": """
444	444	SELECT __color__, __group__, __style__, ticket, summary, component ,version,
…	…
452	452	t.id AS ticket, summary AS summary, -- ## Break line here
453	453	component,version, severity, milestone as __milestone__, status, owner,
454		CAST(EstimatedHours.value as REAL) as Estimated_work,
455		CAST(totalhours.value as REAL) as Total_work,
	454	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	455	CAST(totalhours.value as DECIMAL) as Total_work,
456	456	CASE WHEN billable.value = 1 THEN 'Y'
457	457	else 'N'
…	…
484	484	NULL as component,NULL as version, NULL as severity,
485	485	t.milestone as __milestone__, NULL as status, NULL as owner,
486		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
487		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	486	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	487	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
488	488	NULL as billable,
489	489	NULL as created, NULL as modified, -- ## Dates are formatted
…	…
516	516	"title":"Ticket Hours Grouped By MileStone with Description",
517	517	"reportnumber":None,
518		"version":8,
	518	"version":9,
519	519	"sql": """
520	520	SELECT __color__, __group__, __style__, ticket, summary, component ,version, severity,
…	…
528	528	t.id AS ticket, summary AS summary, -- ## Break line here
529	529	component,version, severity, milestone as __milestone__, status, owner,
530		CAST(EstimatedHours.value as REAL) as Estimated_work,
531		CAST(totalhours.value as REAL) as Total_work,
	530	CAST(EstimatedHours.value as DECIMAL) as Estimated_work,
	531	CAST(totalhours.value as DECIMAL) as Total_work,
532	532	CASE WHEN billable.value = 1 THEN 'Y'
533	533	else 'N'
…	…
562	562	t.milestone as __milestone__,
563	563	NULL as status, NULL as owner,
564		SUM(CAST(EstimatedHours.value as ~~real~~)) as Estimated_work,
565		SUM(CAST(totalhours.value as ~~real~~)) as Total_work,
	564	SUM(CAST(EstimatedHours.value as DECIMAL)) as Estimated_work,
	565	SUM(CAST(totalhours.value as DECIMAL)) as Total_work,
566	566	NULL as billable,
567	567	NULL as created, NULL as modified, -- ## Dates are formatted

Download in other formats: