Changeset 26

Timestamp:

02/11/12 08:06:13 (16 months ago)

Author:

matobaa

Message:

add snapshot for Report

Location:

trunk/Snapshot

Files:

• setup.py (modified) (1 diff)
• snapshot/macro.py (modified) (1 diff)
• snapshot/query.py (modified) (3 diffs)

trunk/Snapshot/setup.py

@@ -12 +12 @@
     url='http://trac-hacks.org/wiki/matobaa',
     description='store query result to wiki as static snapshot',
-    zip_safe=False,
+    zip_safe=True,
     packages=find_packages(exclude=['*.tests']),
     include_package_data=True,

trunk/Snapshot/snapshot/macro.py

@@ -46 +46 @@
             for field in ticket_fields:
                 fields[field['name']] = {'label': field['label']} # transform list to expected dict
+            # fail safe
+            fields[None] = 'NONE'
+            for group in groups.keys():
+                if not fields.has_key(group):
+                    fields[group] = group
             #
             group_name = 'group' in args and args['group'] or None

trunk/Snapshot/snapshot/query.py

@@ -6 +6 @@
 from genshi.filters.transform import Transformer
 from trac.core import Component, implements
-from trac.util.datefmt import format_datetime
+from trac.resource import get_resource_url, Resource
+from trac.util.datefmt import format_datetime, format_time, from_utimestamp, \
+    format_date
 from trac.web.api import ITemplateStreamFilter
 from trac.wiki.model import WikiPage
 
-class SaveToWiki(Component):
+class Query(Component):
     implements (ITemplateStreamFilter)
     
@@ -33 +35 @@
         text = '= Snapshot of [%s the query]: =\n' % query_string
         text += '{{{#!QueryResults(group=%s) \n' % data['query'].group
-        text += '||= href =||= ' + ' =||= '.join(cols)
-        text += '\n'
+        text += '||= href =||= %s\n' % ' =||= '.join(cols)
         for (group_name, tickets) in data['groups']:
             text += '|| group: %s\n' % group_name
@@ -46 +47 @@
                       tag.input(name='page', value=page_name))
         return stream | Transformer('//div[@id="content"]/div[@class="buttons"]') \
-            .append(tag.form(div, action='wiki'))
+            .append(tag.form(div, action=get_resource_url(self.env, Resource('wiki'), self.env.href)))
+            
+class Report(Component):
+    implements(ITemplateStreamFilter)
+
+    @classmethod
+    def formatter(self, col, cell_value):
+        if col == 'time':
+            return cell_value != '' and format_time(from_utimestamp(long(cell_value))) or '--'
+        if col in ('date', 'created', 'modified'):
+            return cell_value != '' and format_date(from_utimestamp(long(cell_value))) or '--'
+        if col == 'datetime':
+            return cell_value != '' and format_datetime(from_utimestamp(long(cell_value))) or '--'
+        return cell_value
+
+    #ITemplateStreamFilter methods
+    def filter_stream(self, req, method, filename, stream, data):
+        if filename != 'report_view.html':
+            return stream
+        page_name = 'report:%s' % data['context'].resource.id
+        page_label = data['title']
+        page = WikiPage(self.env, page_name)
+        if 'WIKI_MODIFY' not in req.perm(page.resource):
+            return stream
+        text = '= Snapshot of [%s %s]: =\n' % (page_name, page_label)
+        text += '{{{#!QueryResults\n'
+        cols = [header['col'] for header in data['header_groups'][0] if not header['hidden']]
+        text += '||= href =||= %s\n' % ' =||= '.join(cols)
+        for  groupindex, row_group in data['row_groups']:
+            text += '|| group: %s\n' % groupindex
+            for row in row_group:
+                row = row['cell_groups'][0]
+                ticket = {}
+                for value in row:
+                    ticket[value['header']['col']] = value['value']
+                ticket['href'] = get_resource_url(self.env, Resource('ticket',ticket.get('ticket',0)), self.env.href)
+                text += '|| %s || %s\n' % ( ticket['href'] ,
+                    ' || '.join([self.formatter(col, ticket[col]) for col in cols]))
+        text += '}}}'
+        div = tag.div(tag.input(value='Save as wiki:', type='submit'),
+                      tag.input(name='action', value='edit', type='hidden'),
+                          tag.input(name='text', value=text, type='hidden'),
+                      tag.input(name='page', value=page_name))
+        return stream | Transformer('//div[@id="content"]/div[@class="buttons"]') \
+            .append(tag.form(div, action=get_resource_url(self.env, Resource('wiki'), self.env.href)))