Changes between Version 10 and Version 11 of S3XRC/ResourceReport

Timestamp:

08/28/10 19:25:44 (15 years ago)

Author:

Dominic König

Comment:

--

S3XRC/ResourceReport

@@ -160 +160 @@
 }}}
 
-Now we add the HTML representation:
+Then we add the HTML representation:
 
 {{{
@@ -172 +172 @@
 }}}
 
+The next step would be to provide a form to select the first and the last date of the interval. This would look like that:
+
+{{{
+    if r.representation == "html":
+
+        # Filter form
+        form = FORM(
+                 TABLE(
+                   TR(
+                     T("Date from:"),
+                     INPUT(_type="text", _name="date_from", _class="date", _value=datetime.now().date(), requires=IS_DATE()),
+                     T("until:"),
+                     INPUT(_type="text", _name="date_until", _class="date", _value=datetime.now().date(), requires=IS_DATE())
+                   )
+                 )
+               )
+
+        output = dict(form=form)
+
+        if form.accepts(request.vars, session, keepvalues=True):
+            # Processing of the form data goes here
+
+        return output
+
+}}}
+
+From this, we need to process the form data into two dates. We use {{{datetime}}} for that:
+
+{{{
+        if form.accepts(request.vars, session, keepvalues=True):
+
+            from datetime import date, datetime, time
+
+            # Date from
+            if form.vars.date_from:
+                from = datetime.combine(form.vars.date_from, time(0,0,0))
+
+            # Date until
+            if form.vars.date_until:
+                until = datetime.combine(form.vars.date_until+timedelta(days=1), time(0,0,0))
+
+}}}
+
+To select the corresponding records, we need to extend our query:
+
+{{{
+        if form.accepts(request.vars, session, keepvalues=True):
+
+            # Get the initial query from the resource
+            # => this implements authorisation as well as URL queries
+            resource = r.resource
+            table = resource.table
+            filter = resource.get_query()
+
+            from datetime import date, datetime, time
+
+            # Date from
+            if form.vars.date_from:
+                from = datetime.combine(form.vars.date_from, time(0,0,0))
+                date_query = (table.timestmp >= from)
+
+            # Date until
+            if form.vars.date_until:
+                until = datetime.combine(form.vars.date_until+timedelta(days=1), time(0,0,0))
+                q = (table.timetmp <= until)
+                if date_query:
+                    date_query = date_query & q
+                else:
+                    date_query = q
+
+            # Add our filter and rebuild the resource query
+            filter = filter & date_query
+            resource.build_query(filter=filter)
+
+}}}
+
+From there, it is easy to select the sum of the "cost" field:
+
+{{{
+        if form.accepts(request.vars, session, keepvalues=True):
+
+            # Get the initial query from the resource
+            # => this implements authorisation as well as URL queries
+            resource = r.resource
+            table = resource.table
+            filter = resource.get_query()
+
+            from datetime import date, datetime, time
+
+            # Date from
+            if form.vars.date_from:
+                from = datetime.combine(form.vars.date_from, time(0,0,0))
+                date_query = (table.timestmp >= from)
+
+            # Date until
+            if form.vars.date_until:
+                until = datetime.combine(form.vars.date_until+timedelta(days=1), time(0,0,0))
+                q = (table.timetmp <= until)
+                if date_query:
+                    date_query = date_query & q
+                else:
+                    date_query = q
+
+            # Add our filter and rebuild the resource query
+            filter = filter & date_query
+            resource.build_query(filter=filter)
+
+            # Get the total costs
+            costs = table.costs.sum()
+            total = db(query).select(costs)
+
+            # Build the result string
+            result = "%s: %s" % (T("The total costs of the selected projects are"), total)
+
+            output.update(result=result)
+}}}
+
+Done with the method handler! Here at a glance:
+
+{{{
+
+def s3_xxx_yyy_report(r, **attr):
+
+    if r.representation == "html":
+
+        # Filter form
+        form = FORM(
+                 TABLE(
+                   TR(
+                     T("Date from:"),
+                     INPUT(_type="text", _name="date_from", _class="date", _value=datetime.now().date(), requires=IS_DATE()),
+                     T("until:"),
+                     INPUT(_type="text", _name="date_until", _class="date", _value=datetime.now().date(), requires=IS_DATE())
+                   )
+                 )
+               )
+
+        output = dict(form=form)
+
+        if form.accepts(request.vars, session, keepvalues=True):
+
+            # Get the initial query from the resource
+            # => this implements authorisation as well as URL queries
+            resource = r.resource
+            table = resource.table
+            filter = resource.get_query()
+
+            from datetime import date, datetime, time
+
+            # Date from
+            if form.vars.date_from:
+                from = datetime.combine(form.vars.date_from, time(0,0,0))
+                date_query = (table.timestmp >= from)
+
+            # Date until
+            if form.vars.date_until:
+                until = datetime.combine(form.vars.date_until+timedelta(days=1), time(0,0,0))
+                q = (table.timetmp <= until)
+                if date_query:
+                    date_query = date_query & q
+                else:
+                    date_query = q
+
+            # Add our filter and rebuild the resource query
+            filter = filter & date_query
+            resource.build_query(filter=filter)
+
+            # Get the total costs
+            costs = table.costs.sum()
+            total = db(query).select(costs)
+
+            # Build the result string
+            result = "%s: %s" % (T("The total costs of the selected projects are"), total)
+
+            output.update(result=result)
+
+            # Select the corresponding view:
+            response.view = "xxx/report.html"
+
+    else:
+        raise HTTP(501, body=s3xrc.ERROR.BAD_FORMAT)
+
+    return output
+
+s3xrc.model.set_method("xxx", "yyy", method="report", action=s3_xxx_yyy_report)
+}}}
+
+We have added a line to raise an HTTP error in case an unsupported format gets requested, and added a line to select a proper view template "xxx/report.html", which would look like that:
+
+{{{
+{{extend 'layout.html'}}
+<div class='form-container'>
+{{try:}}{{=form}}{{except:}}{{pass}}
+</div>
+<div id='table-container'>
+{{try:}}{{=result}}{{except:}}{{pass}}
+</div>
+}}}
+
+...and that's all.
+
 ...to be continued...
+...to be continued...