Changeset 4382

Timestamp:

10/03/08 10:40:57 (2 months ago)

Author:

bobbysmith007

Message:

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

Files:

• timingandestimationplugin/branches/trac0.11-Permissions/setup.py (modified) (1 diff)
• timingandestimationplugin/branches/trac0.11-Permissions/timingandestimationplugin/reports.py (modified) (12 diffs)
• timingandestimationplugin/branches/trac0.11/setup.py (modified) (1 diff)
• timingandestimationplugin/branches/trac0.11/timingandestimationplugin/reports.py (modified) (12 diffs)

timingandestimationplugin/branches/trac0.11-Permissions/setup.py

@@ -8 +8 @@
-      description='Plugin to make Trac support time estimation and tracking with permissions',
-      keywords='trac plugin estimation timetracking permissions',
-2
+3
-      url='http://www.trac-hacks.org/wiki/TimingAndEstimationPlugin',
-      license='http://www.opensource.org/licenses/mit-license.php',

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

@@ -9 +9 @@
-    "uuid":"b24f08c0-d41f-4c63-93a5-25e18a8513c2",
-    "title":"Ticket Work Summary",
-0
+1
-    "sql":"""
-SELECT __ticket__ as __group__, __style__, ticket,
@@ -57 +57 @@
-    "uuid":"af13564f-0e36-4a17-96c0-632dc68d8d14",
-    "title":"Milestone Work Summary",
-7
+8
-    "sql":"""
-
@@ -81 +81 @@
-  UNION
-
-NULL
+0
-    sum( CASE WHEN newvalue = '' OR newvalue IS NULL THEN 0
-         ELSE CAST( newvalue AS DECIMAL ) END) as newvalue, 'Total work done' as summary,
@@ -106 +106 @@
-    "uuid":"7bd4b0ce-da6d-4b11-8be3-07e65b540d99",
-    "title":"Developer Work Summary",
-7
+8
-    "sql":"""
-SELECT author as __group__,__style__, ticket, summary,
@@ -128 +128 @@
-  UNION
-
-NULL
+0
-    Null as summary,
-    SUM( CASE WHEN newvalue = '' OR newvalue IS NULL THEN 0
@@ -149 +149 @@
-    },#END Hours Per Developer
-]
-5
+6
-ticket_hours_reports = [
-{
@@ -192 +192 @@
-  SELECT '1' AS __color__,
-         'background-color:#DFE;' as __style__,
-NULL
+0
-         NULL as component,NULL as version, NULL as severity, NULL as  milestone,
-         'Time Remaining: ' as status,
@@ -280 +280 @@
-SELECT '1' AS __color__,
-       'background-color:#DFE;' as __style__,
-NULL
+0
-       NULL as component,NULL as version, NULL as severity, NULL as  milestone,
-       'Time Remaining: ' as status,
@@ -367 +367 @@
-       t.component AS __group__,
-       'background-color:#DFE;' as __style__,
-NULL
+0
-       t.component as __component__, NULL as version, NULL as severity,
-       NULL as  milestone, 'Time Remaining: ' as status,
@@ -454 +454 @@
-       t.component AS __group__,
-       'background-color:#DFE;' as __style__,
-NULL
+0
-       t.component as __component__, NULL as version, NULL as severity,
-       NULL as  milestone, 'Time Remaining: ' as status,
@@ -540 +540 @@
-       t.milestone AS __group__,
-       'background-color:#DFE;' as __style__,
-NULL
+0
-       NULL as component,NULL as version, NULL as severity,
-       t.milestone as  __milestone__, 'Time Remaining: ' as status,
@@ -627 +627 @@
-       t.milestone AS __group__,
-       'background-color:#DFE;' as __style__,
-NULL
+0
-       NULL as component,NULL as version, NULL as severity,
-       t.milestone as __milestone__,

timingandestimationplugin/branches/trac0.11/setup.py

@@ -8 +8 @@
-      description='Plugin to make Trac support time estimation and tracking',
-      keywords='trac plugin estimation timetracking',
-0
+3
-      url='http://www.trac-hacks.org/wiki/TimingAndEstimationPlugin',
-      license='http://www.opensource.org/licenses/mit-license.php',

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

@@ -9 +9 @@
-    "uuid":"b24f08c0-d41f-4c63-93a5-25e18a8513c2",
-    "title":"Ticket Work Summary",
-0
+1
-    "sql":"""
-SELECT __ticket__ as __group__, __style__, ticket,
@@ -57 +57 @@
-    "uuid":"af13564f-0e36-4a17-96c0-632dc68d8d14",
-    "title":"Milestone Work Summary",
-7
+8
-    "sql":"""
-
@@ -81 +81 @@
-  UNION
-
-NULL
+0
-    sum( CASE WHEN newvalue = '' OR newvalue IS NULL THEN 0
-         ELSE CAST( newvalue AS DECIMAL ) END) as newvalue, 'Total work done' as summary,
@@ -106 +106 @@
-    "uuid":"7bd4b0ce-da6d-4b11-8be3-07e65b540d99",
-    "title":"Developer Work Summary",
-7
+8
-    "sql":"""
-SELECT author as __group__,__style__, ticket, summary,
@@ -128 +128 @@
-  UNION
-
-NULL
+0
-    Null as summary,
-    SUM( CASE WHEN newvalue = '' OR newvalue IS NULL THEN 0
@@ -149 +149 @@
-    },#END Hours Per Developer
-]
-5
+6
-ticket_hours_reports = [
-{
@@ -192 +192 @@
-  SELECT '1' AS __color__,
-         'background-color:#DFE;' as __style__,
-NULL
+0
-         NULL as component,NULL as version, NULL as severity, NULL as  milestone,
-         'Time Remaining: ' as status,
@@ -280 +280 @@
-SELECT '1' AS __color__,
-       'background-color:#DFE;' as __style__,
-NULL
+0
-       NULL as component,NULL as version, NULL as severity, NULL as  milestone,
-       'Time Remaining: ' as status,
@@ -367 +367 @@
-       t.component AS __group__,
-       'background-color:#DFE;' as __style__,
-NULL
+0
-       t.component as __component__, NULL as version, NULL as severity,
-       NULL as  milestone, 'Time Remaining: ' as status,
@@ -454 +454 @@
-       t.component AS __group__,
-       'background-color:#DFE;' as __style__,
-NULL
+0
-       t.component as __component__, NULL as version, NULL as severity,
-       NULL as  milestone, 'Time Remaining: ' as status,
@@ -540 +540 @@
-       t.milestone AS __group__,
-       'background-color:#DFE;' as __style__,
-NULL
+0
-       NULL as component,NULL as version, NULL as severity,
-       t.milestone as  __milestone__, 'Time Remaining: ' as status,
@@ -627 +627 @@
-       t.milestone AS __group__,
-       'background-color:#DFE;' as __style__,
-NULL
+0
-       NULL as component,NULL as version, NULL as severity,
-       t.milestone as __milestone__,