Changeset 1396

Show
Ignore:
Timestamp:
10/18/06 13:40:03 (2 years ago)
Author:
bobbysmith007
Message:

TimingAndEstimationPlugin:

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

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • timingandestimationplugin/trunk/setup.py

    r1390 r1396  
    88      description='Plugin to make Trac support time estimation and tracking', 
    99      keywords='trac plugin estimation timetracking', 
    10       version='0.1.9', 
     10      version='0.2.0', 
    1111      url='', 
    1212      license='http://www.opensource.org/licenses/mit-license.php', 

  • timingandestimationplugin/trunk/timingandestimationplugin/reports.py

    r1369 r1396  
    99    "title":"Ticket Work Summary", 
    1010    "reportnumber":None, 
    11     "version":4, 
     11    "version":6, 
    1212    "sql":""" 
    13 SELECT ticket as __group__,__style__, ticket,  
    14 newvalue as Hours_added, time as _time, strtime as Time_Entered, 
     13SELECT ticket as __group__, __style__, ticket, 
     14newvalue as Hours_added, author, time, 
     15 
     16-- strtime as Time_Entered, 
     17 
    1518 _ord 
    1619FROM( 
    1720SELECT '' as __style__, author, t.id as ticket, newvalue, 
    1821 ticket_change.time as time, 
    19  strftime('%m/%d/%Y %H:%M:%S', ticket_change.time, 'unixepoch', 'localtime') as strtime , 
     22  
     23-- strftime('%m/%d/%Y %H:%M:%S', ticket_change.time, 'unixepoch', 'localtime') as strtime , 
     24 
    2025 0  as _ord 
    2126FROM ticket_change 
    …… 
    3136UNION  
    3237 
    33 SELECT 'background-color:#DFE;' as __style__, '' as author, t.id as ticket, sum(newvalue) as newvalue, strftime('%s', 'now') as time, 
    34  'Ticket Work Summary for '|| 
    35  strftime('%m/%d/%Y %H:%M:%S', $STARTDATE, 'unixepoch', 'localtime' )||' - '|| 
    36  strftime('%m/%d/%Y %H:%M:%S', $ENDDATE, 'unixepoch', 'localtime') as strtime , 
     38SELECT 'background-color:#DFE;' as __style__, 'Ticket Work Summary for the selected time period ' as author, t.id as ticket, sum(newvalue) as newvalue, NULL as time, 
     39 
     40-- 'Ticket Work Summary for the selected time period ' 
     41-- || 
     42-- strftime('%m/%d/%Y %H:%M:%S', STARTDATE, 'unixepoch', 'localtime' )||' - '|| 
     43-- strftime('%m/%d/%Y %H:%M:%S', ENDDATE, 'unixepoch', 'localtime') as strtime , 
     44 
    3745 1 as _ord 
    3846FROM ticket_change 
    …… 
    4755GROUP By t.id 
    4856) 
    49 ORDER BY ticket, _time,  _ord 
     57ORDER BY ticket, _ord , time 
    5058 
    5159    """ 
    …… 
    5462    "title":"Milestone Work Summary", 
    5563    "reportnumber":None, 
    56     "version":4, 
     64    "version":5, 
    5765    "sql":""" 
     66 
    5867SELECT  
    5968  milestone as __group__,  
    …… 
    6271  summary, 
    6372  newvalue as Hours_added, 
    64   time as _time, 
    65   strtime as Last_Updated, 
     73  time as time as LastU_pdated, 
     74--  strtime as Last_Updated, 
    6675 _ord 
    6776FROM( 
    6877SELECT '' as __style__, t.id as ticket, SUM(newvalue) as newvalue,t.summary as summary, 
    6978 MAX(ticket_change.time) as time, 
    70  strftime('%m/%d/%Y %H:%M:%S', MAX(ticket_change.time), 'unixepoch', 'localtime') as strtime , 
     79 
     80-- strftime('%m/%d/%Y %H:%M:%S', MAX(ticket_change.time), 'unixepoch', 'localtime') as strtime , 
     81 
    7182 t.milestone as milestone, 
    7283 0  as _ord 
    …… 
    8798 '' as ticket, sum(newvalue)  as newvalue,  
    8899'' as summary, 
    89 strftime('%s', 'now') as time, 
    90  'Ticket Work Summary for '|| 
    91  strftime('%m/%d/%Y %H:%M:%S', $STARTDATE, 'unixepoch', 'localtime')||' - '|| 
    92  strftime('%m/%d/%Y %H:%M:%S', $ENDDATE, 'unixepoch', 'localtime')  as strtime , 
     100NULL as time, 
     101 
     102-- 'Ticket Work Summary for '|| 
     103-- strftime('%m/%d/%Y %H:%M:%S', STARTDATE, 'unixepoch', 'localtime')||' - '|| 
     104-- strftime('%m/%d/%Y %H:%M:%S', ENDDATE, 'unixepoch', 'localtime')  as strtime , 
     105 
    93106 t.milestone as milestone, 
    94107 1 as _ord 
    …… 
    104117GROUP By t.milestone 
    105118) 
    106 ORDER BY milestone, ticket, _time,  _ord 
     119ORDER BY milestone, ticket, time,  _ord 
    107120 
    108121 
    …… 
    114127    "title":"Developer Work Summary", 
    115128    "reportnumber":None, 
    116     "version":4, 
     129    "version":5, 
    117130    "sql":""" 
    118131SELECT author as __group__,__style__, ticket,  
    119 newvalue as Hours_added, time as _time, strtime as Time_Entered, 
     132newvalue as Hours_added, time as time, 
     133 
     134-- strtime as Time_Entered, 
     135 
    120136 _ord 
    121137FROM( 
    122138SELECT '' as __style__, author, t.id as ticket, newvalue, 
    123139 ticket_change.time as time, 
    124  strftime('%m/%d/%Y %H:%M:%S', ticket_change.time, 'unixepoch', 'localtime') as strtime , 
     140 
     141-- strftime('%m/%d/%Y %H:%M:%S', ticket_change.time, 'unixepoch', 'localtime') as strtime , 
     142 
    125143 0  as _ord 
    126144FROM ticket_change 
    …… 
    136154 
    137155SELECT 'background-color:#DFE;' as __style__, author, '' as ticket, sum(newvalue) as newvalue, strftime('%s', 'now') as time, 
    138  'Developer Work Summary for '|| 
    139  strftime('%m/%d/%Y %H:%M:%S', $STARTDATE, 'unixepoch', 'localtime')||' - '|| 
    140  strftime('%m/%d/%Y %H:%M:%S', $ENDDATE, 'unixepoch', 'localtime') as strtime , 
     156 
     157-- 'Developer Work Summary for '|| 
     158-- strftime('%m/%d/%Y %H:%M:%S', STARTDATE, 'unixepoch', 'localtime')||' - '|| 
     159-- strftime('%m/%d/%Y %H:%M:%S', ENDDATE, 'unixepoch', 'localtime') as strtime , 
     160 
    141161 1 as _ord 
    142162FROM ticket_change 
    …… 
    151171GROUP By author 
    152172) 
    153 ORDER BY author, _time,  _ord 
     173ORDER BY author, time,  _ord 
    154174     
    155175    """