Changeset 3521

Show
Ignore:
Timestamp:
04/16/08 13:37:17 (9 months ago)
Author:
bobbysmith007
Message:

closes #2862
closes #2763

Fixed reports for mysql. Also made the plugin handle status names that contain an underscore.

version 0.6.5

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • timingandestimationplugin/branches/trac0.11/setup.py

    r3398 r3521  
    88      description='Plugin to make Trac support time estimation and tracking', 
    99      keywords='trac plugin estimation timetracking', 
    10       version='0.6.4', 
     10      version='0.6.5', 
    1111      url='http://www.trac-hacks.org/wiki/TimingAndEstimationPlugin', 
    1212      license='http://www.opensource.org/licenses/mit-license.php', 

  • timingandestimationplugin/branches/trac0.11/timingandestimationplugin/htdocs/linkifyer.js

    r2774 r3521  
    100100 
    101101      for(var i=0, f = null ; f = statusfields[i] ; i++){ 
    102          val = f.name.toUpperCase()+"="; 
     102         val = f.name.toUpperCase().replace("_","", "g").replace(" ","","g")+"="; 
    103103         if(f.getval()){ 
    104104            val += f.name 

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

    r3398 r3521  
    200200       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    201201         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    202          AS VARCHAR(1024))  as owner, 
     202         AS CHAR(512))  as owner, 
    203203         SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    204204      ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 
    …… 
    238238SELECT __color__,  __style__,  ticket, summary, component ,version, severity, 
    239239 milestone, status, owner, Estimated_work, Total_work, billable 
    240 --##,created,  modified,         -- ## Dates are formatted 
     240-- ## ,created,  modified,         -- ## Dates are formatted 
    241241,_description_ 
    242 --## _changetime, 
    243 --## _reporter 
     242-- ## _changetime, 
     243-- ## _reporter 
    244244,_ord 
    245245 
    …… 
    288288       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    289289         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    290          AS VARCHAR(1024))  as owner, 
     290         AS CHAR(512))  as owner, 
    291291       SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    292292         ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 
    …… 
    375375       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    376376         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    377          AS VARCHAR(1024))  as owner, 
     377         AS CHAR(512))  as owner, 
    378378       SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    379379         ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 
    …… 
    462462       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    463463         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    464          AS VARCHAR(1024))  as owner, 
     464         AS CHAR(512))  as owner, 
    465465       SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    466466         ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 
    …… 
    548548       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    549549         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    550          AS VARCHAR(1024)) as owner, 
     550         AS CHAR(512)) as owner, 
    551551       SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    552552         ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 
    …… 
    636636       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    637637         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    638          AS VARCHAR(1024)) as owner, 
     638         AS CHAR(512)) as owner, 
    639639       SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    640640         ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 

  • timingandestimationplugin/branches/trac0.11/timingandestimationplugin/statuses.py

    r3119 r3521  
    44 
    55def status_variables(statuses): 
    6     return ', '.join(['$'+i.upper() for i in list(statuses)]) 
     6    return ', '.join(['$'+i.upper().replace("_","").replace(" ","") for i in list(statuses)]) 
    77                      
    88def get_statuses(config, env):