Changeset 1586


Ignore:
Timestamp:
Nov 22, 2006, 6:44:59 PM (10 years ago)
Author:
Russ Tyndall
Message:

TimingAndEstimationPlugin:

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

Location:
timingandestimationplugin/trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • timingandestimationplugin/trunk/setup.py

    r1578 r1586  
    88      description='Plugin to make Trac support time estimation and tracking',
    99      keywords='trac plugin estimation timetracking',
    10       version='0.2.6',
     10      version='0.2.7',
    1111      url='',
    1212      license='http://www.opensource.org/licenses/mit-license.php',
  • timingandestimationplugin/trunk/timingandestimationplugin/reports.py

    r1571 r1586  
    99    "title":"Ticket Work Summary",
    1010    "reportnumber":None,
    11     "version":9,
     11    "version":11,
    1212    "sql":"""
    1313SELECT ticket as __group__, __style__, ticket,
     
    1818 _ord
    1919FROM(
    20 SELECT '' as __style__, author, t.id as ticket, newvalue,
     20SELECT '' as __style__, author, t.id as ticket, CAST(newvalue as REAL) as newvalue,
    2121 ticket_change.time as time,
    2222 
     
    129129    "title":"Developer Work Summary",
    130130    "reportnumber":None,
    131     "version":9,
     131    "version":10,
    132132    "sql":"""
    133133SELECT author as __group__,__style__, ticket,
     
    138138 _ord
    139139FROM(
    140 SELECT '' as __style__, author, t.id as ticket, newvalue,
     140SELECT '' as __style__, author, t.id as ticket, CAST(newvalue as REAL) as newvalue,
    141141 ticket_change.time as time,
    142142
     
    183183    "title": "Ticket Hours",
    184184    "reportnumber": None,
    185     "version":6,
     185    "version":7,
    186186    "sql": """
    187187SELECT __color__,  __style__,  ticket, summary_, component ,version, severity,
     
    198198       t.id AS ticket, summary AS summary_,             -- ## Break line here
    199199       component,version, severity, milestone, status, owner,
    200        EstimatedHours.value as Estimated_hours,
    201        totalhours.value as total_hours,
     200       CAST(EstimatedHours.value as REAL) as Estimated_hours,
     201       CAST(totalhours.value as REAL) as total_hours,
    202202       CASE WHEN billable.value = 1 THEN 'Y'
    203203            else 'N'
     
    260260    "title": "Ticket Hours with Description",
    261261    "reportnumber": None,
    262     "version":7,
     262    "version":8,
    263263    "sql": """
    264264SELECT __color__,  __style__,  ticket, summary_, component ,version, severity,
     
    275275       t.id AS ticket, summary AS summary_,             -- ## Break line here
    276276       component,version, severity, milestone, status, owner,
    277        EstimatedHours.value as Estimated_hours,
    278        totalhours.value as total_hours,
     277       CAST(EstimatedHours.value as REAL) as Estimated_hours,
     278       CAST(totalhours.value as REAL) as total_hours,
    279279       CASE WHEN billable.value = 1 THEN 'Y'
    280280            else 'N'
     
    338338    "title":"Ticket Hours Grouped By Component",
    339339    "reportnumber":None,
    340     "version":6,
     340    "version":7,
    341341    "sql": """
    342342SELECT __color__, __group__, __style__,  ticket, summary_, component ,version, severity,
     
    354354       t.id AS ticket, summary AS summary_,             -- ## Break line here
    355355       component,version, severity, milestone, status, owner,
    356        EstimatedHours.value as Estimated_hours,
    357        totalhours.value as total_hours,
     356       CAST(EstimatedHours.value as REAL) as Estimated_hours,
     357       CAST(totalhours.value as REAL) as total_hours,
    358358       CASE WHEN billable.value = 1 THEN 'Y'
    359359            else 'N'
     
    437437       t.id AS ticket, summary AS summary_,             -- ## Break line here
    438438       component,version, severity, milestone, status, owner,
    439        EstimatedHours.value as Estimated_hours,
    440        totalhours.value as total_hours,
     439       CAST(EstimatedHours.value as REAL) as Estimated_hours,
     440       CAST(totalhours.value as REAL) as total_hours,
    441441       CASE WHEN billable.value = 1 THEN 'Y'
    442442            else 'N'
     
    501501    "title":"Ticket Hours Grouped By Milestone",
    502502    "reportnumber":None,
    503     "version":6,
     503    "version":7,
    504504    "sql": """
    505505SELECT __color__, __group__, __style__,  ticket, summary_, component ,version, severity,
     
    517517       t.id AS ticket, summary AS summary_,             -- ## Break line here
    518518       component,version, severity, milestone, status, owner,
    519        EstimatedHours.value as Estimated_hours,
    520        totalhours.value as total_hours,
     519       CAST(EstimatedHours.value as REAL) as Estimated_hours,
     520       CAST(totalhours.value as REAL) as total_hours,
    521521       CASE WHEN billable.value = 1 THEN 'Y'
    522522            else 'N'
     
    582582    "title":"Ticket Hours Grouped By MileStone with Description",
    583583    "reportnumber":None,
    584     "version":6,
     584    "version":7,
    585585    "sql": """
    586586SELECT __color__, __group__, __style__,  ticket, summary_, component ,version, severity,
     
    598598       t.id AS ticket, summary AS summary_,             -- ## Break line here
    599599       component,version, severity, milestone, status, owner,
    600        EstimatedHours.value as Estimated_hours,
    601        totalhours.value as total_hours,
     600       CAST(EstimatedHours.value as REAL) as Estimated_hours,
     601       CAST(totalhours.value as REAL) as total_hours,
    602602       CASE WHEN billable.value = 1 THEN 'Y'
    603603            else 'N'
Note: See TracChangeset for help on using the changeset viewer.