[Erp5-report] r36203 aurel - in /erp5/trunk/bt5/erp5_base: SkinTemplateItem/portal_skins/er...

[nobody at svn.erp5.org]

Author: aurel
Date: Thu Jun 10 11:16:52 2010
New Revision: 36203

URL: http://svn.erp5.org?rev=36203&view=rev
Log:
fix sql expression used in report (see bugs #1820 and #1824)

Modified:
    erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/Person_getPersonDetailedContributionList.xml
    erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/Person_statPersonDetailedContributionList.xml
    erp5/trunk/bt5/erp5_base/bt/revision

Modified: erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/Person_getPersonDetailedContributionList.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/Person_getPersonDetailedContributionList.xml?rev=36203&r1=36202&r2=36203&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/Person_getPersonDetailedContributionList.xml [utf8] (original)
+++ erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/Person_getPersonDetailedContributionList.xml [utf8] Thu Jun 10 11:16:52 2010
@@ -97,8 +97,8 @@ elif from_date is not None:\n
 elif to_date is not None:\n
   params = {"creation_date":to_date}\n
   query = Query(range="max", **params)\n
-select_expression = \'DATE_FORMAT(creation_date, "%s") as date, portal_type\' %sql_format\n
-group_by = \'DATE_FORMAT(creation_date, "%s"), portal_type\' %sql_format\n
+select_expression = {\'date\' : \'DATE_FORMAT(creation_date, "%s")\'%sql_format, \'portal_type\' : None}\n
+group_by = [\'DATE_FORMAT(creation_date, "%s")\' % sql_format, \'portal_type\']\n
 \n
 # count number of object created by the user for each type of document\n
 reference = kw.get(\'person_reference_list\', context.getReference())\n

Modified: erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/Person_statPersonDetailedContributionList.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/Person_statPersonDetailedContributionList.xml?rev=36203&r1=36202&r2=36203&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/Person_statPersonDetailedContributionList.xml [utf8] (original)
+++ erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/Person_statPersonDetailedContributionList.xml [utf8] Thu Jun 10 11:16:52 2010
@@ -61,7 +61,6 @@ stat_line = request.get(\'stat_line\', N
 return stat_line\n
 \n
 \n
-\n
 # XXX example of another way to get the stat line but this is slower\n
 from Products.ERP5Type.Log import log\n
 from Products.PythonScripts.standard import Object\n
@@ -98,8 +97,9 @@ elif from_date is not None:\n
 elif to_date is not None:\n
   params = {"creation_date":to_date}\n
   query = Query(range="ngt", **params)\n
-select_expression_list = \'DATE_FORMAT(creation_date, "%s") as date\' %sql_format\n
-group_by_list = \'DATE_FORMAT(creation_date, "%s")\' %sql_format\n
+select_expression = {\'date\' : \'DATE_FORMAT(creation_date, "%s")\'%sql_format}\n
+group_by = [\'DATE_FORMAT(creation_date, "%s")\' % sql_format,]\n
+\n
 # count number of object created by the user for each type of document\n
 result_list = context.portal_catalog.countResults(select_expression=select_expression_list,\n
                                                   portal_type=portal_type_list,limit=None,\n
@@ -191,6 +191,8 @@ return [obj,]\n
                             <string>params</string>
                             <string>query</string>
                             <string>_apply_</string>
+                            <string>select_expression</string>
+                            <string>group_by</string>
                             <string>select_expression_list</string>
                             <string>group_by_list</string>
                             <string>result_list</string>

Modified: erp5/trunk/bt5/erp5_base/bt/revision
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_base/bt/revision?rev=36203&r1=36202&r2=36203&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_base/bt/revision [utf8] (original)
+++ erp5/trunk/bt5/erp5_base/bt/revision [utf8] Thu Jun 10 11:16:52 2010
@@ -1 +1 @@
-772
\ No newline at end of file
+773
\ No newline at end of file