[Erp5-report] r13094 - in /erp5/trunk/bt5: erp5_accounting/SkinTemplateItem/portal_skins/er...
nobody at svn.erp5.org
nobody at svn.erp5.org
Wed Feb 28 10:36:47 CET 2007
Author: kazuhiko
Date: Wed Feb 28 10:36:33 2007
New Revision: 13094
URL: http://svn.erp5.org?rev=13094&view=rev
Log:
use portal_selections.buildSQLExpressionFromDomainSelection instead of selection_domain.asSQLExpression.
Modified:
erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/AccountingTransactionModule_zGetAccountingTransactionList.xml
erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting_bbb/Account_zGetAccountingTransactionList.xml
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/Resource_zGetTrackingList.xml
Modified: erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/AccountingTransactionModule_zGetAccountingTransactionList.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/AccountingTransactionModule_zGetAccountingTransactionList.xml?rev=13094&r1=13093&r2=13094&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/AccountingTransactionModule_zGetAccountingTransactionList.xml (original)
+++ erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/AccountingTransactionModule_zGetAccountingTransactionList.xml Wed Feb 28 10:36:33 2007
@@ -430,10 +430,10 @@
</dtml-if>\n
</dtml-in>\n
<dtml-if selection_domain>\n
- <dtml-var "selection_domain.asSQLJoinExpression()">,\n
+ <dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_domain)">,\n
</dtml-if>\n
<dtml-if selection_report>\n
- <dtml-var "selection_report.asSQLJoinExpression()">,\n
+ <dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_report)">,\n
</dtml-if>\n
<dtml-if use_movement_table> movement, </dtml-if>\n
<dtml-if "stat or omit_input or omit_output or node">\n
@@ -448,10 +448,10 @@
AND <dtml-var "query[\'where_expression\']">\n
</dtml-if>\n
<dtml-if selection_domain>\n
- AND <dtml-var "selection_domain.asSQLExpression()">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_domain)">\n
</dtml-if>\n
<dtml-if selection_report>\n
- AND <dtml-var "selection_report.asSQLExpression(strict_membership=1)">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_report, strict_membership=1)">\n
</dtml-if>\n
<dtml-if specific_reference> AND (\n
catalog.source_reference LIKE\n
@@ -617,10 +617,10 @@
</dtml-if>\n
</dtml-in>\n
<dtml-if selection_domain>\n
- <dtml-var "selection_domain.asSQLJoinExpression()">,\n
+ <dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_domain)">,\n
</dtml-if>\n
<dtml-if selection_report>\n
- <dtml-var "selection_report.asSQLJoinExpression()">,\n
+ <dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_report)">,\n
</dtml-if>\n
<dtml-if use_movement_table> movement, </dtml-if>\n
<dtml-if "stat or omit_input or omit_output or node">\n
@@ -635,10 +635,10 @@
AND <dtml-var "query[\'where_expression\']">\n
</dtml-if>\n
<dtml-if selection_domain>\n
- AND <dtml-var "selection_domain.asSQLExpression()">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_domain)">\n
</dtml-if>\n
<dtml-if selection_report>\n
- AND <dtml-var "selection_report.asSQLExpression(strict_membership=1)">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_report, strict_membership=1)">\n
</dtml-if>\n
<dtml-if specific_reference> AND (\n
catalog.source_reference LIKE\n
Modified: erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting_bbb/Account_zGetAccountingTransactionList.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting_bbb/Account_zGetAccountingTransactionList.xml?rev=13094&r1=13093&r2=13094&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting_bbb/Account_zGetAccountingTransactionList.xml (original)
+++ erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting_bbb/Account_zGetAccountingTransactionList.xml Wed Feb 28 10:36:33 2007
@@ -282,8 +282,8 @@
catalog AS section_bc,\n
category AS section_membership,\n
catalog AS section,\n
- <dtml-if selection_domain><dtml-var "selection_domain.asSQLJoinExpression()">, </dtml-if>\n
- <dtml-if selection_report><dtml-var "selection_report.asSQLJoinExpression()">, </dtml-if>\n
+ <dtml-if selection_domain><dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_domain)">, </dtml-if>\n
+ <dtml-if selection_report><dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_report)">, </dtml-if>\n
<dtml-if where_expression>, category </dtml-if>\n
stock\n
LEFT JOIN catalog AS mirror_section\n
@@ -356,10 +356,10 @@
AND <dtml-var where_expression>\n
</dtml-if>\n
<dtml-if selection_domain>\n
- AND <dtml-var "selection_domain.asSQLExpression()">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_domain)">\n
</dtml-if>\n
<dtml-if selection_report>\n
- AND <dtml-var "selection_report.asSQLExpression(strict_membership=1)">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_report, strict_membership=1)">\n
</dtml-if>\n
ORDER BY\n
stock.date, transaction_line.uid\n
@@ -426,8 +426,8 @@
catalog AS section_bc,\n
category AS section_membership,\n
catalog AS section,\n
- <dtml-if selection_domain><dtml-var "selection_domain.asSQLJoinExpression()">, </dtml-if>\n
- <dtml-if selection_report><dtml-var "selection_report.asSQLJoinExpression()">, </dtml-if>\n
+ <dtml-if selection_domain><dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_domain)">, </dtml-if>\n
+ <dtml-if selection_report><dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_report)">, </dtml-if>\n
<dtml-if where_expression>, category </dtml-if>\n
stock\n
LEFT JOIN catalog AS mirror_section\n
@@ -500,10 +500,10 @@
AND <dtml-var where_expression>\n
</dtml-if>\n
<dtml-if selection_domain>\n
- AND <dtml-var "selection_domain.asSQLExpression()">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_domain)">\n
</dtml-if>\n
<dtml-if selection_report>\n
- AND <dtml-var "selection_report.asSQLExpression(strict_membership=1)">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_report, strict_membership=1)">\n
</dtml-if>\n
ORDER BY\n
stock.date, transaction_line.uid\n
Modified: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/Resource_zGetTrackingList.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/Resource_zGetTrackingList.xml?rev=13094&r1=13093&r2=13094&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/Resource_zGetTrackingList.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/Resource_zGetTrackingList.xml Wed Feb 28 10:36:33 2007
@@ -413,8 +413,8 @@
<dtml-if expr="table_key != \'item\'">, <dtml-var table_item> AS <dtml-var table_key></dtml-if>\n
</dtml-in>\n
</dtml-if>\n
-<dtml-if selection_domain>, <dtml-var "selection_domain.asSQLJoinExpression()"> </dtml-if>\n
-<dtml-if selection_report>, <dtml-var "selection_report.asSQLJoinExpression()"> </dtml-if>\n
+<dtml-if selection_domain>, <dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_domain)"> </dtml-if>\n
+<dtml-if selection_report>, <dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_report)"> </dtml-if>\n
, item\n
\n
\n
@@ -462,11 +462,10 @@
\n
\n
<dtml-if selection_domain>\n
- AND <dtml-var "selection_domain.asSQLExpression(join_table=\'item\',\n
- join_column=\'node_uid\')">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_domain, join_table=\'item\', join_column=\'node_uid\')">\n
</dtml-if>\n
<dtml-if selection_report>\n
- AND <dtml-var "selection_report.asSQLExpression(strict_membership=1)">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_report, strict_membership=1)">\n
</dtml-if>\n
\n
<dtml-if group_by_expression>\n
@@ -532,8 +531,8 @@
<dtml-if expr="table_key != \'item\'">, <dtml-var table_item> AS <dtml-var table_key></dtml-if>\n
</dtml-in>\n
</dtml-if>\n
-<dtml-if selection_domain>, <dtml-var "selection_domain.asSQLJoinExpression()"> </dtml-if>\n
-<dtml-if selection_report>, <dtml-var "selection_report.asSQLJoinExpression()"> </dtml-if>\n
+<dtml-if selection_domain>, <dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_domain)"> </dtml-if>\n
+<dtml-if selection_report>, <dtml-var "portal_selections.buildSQLJoinExpressionFromDomainSelection(selection_report)"> </dtml-if>\n
, item\n
\n
\n
@@ -581,11 +580,10 @@
\n
\n
<dtml-if selection_domain>\n
- AND <dtml-var "selection_domain.asSQLExpression(join_table=\'item\',\n
- join_column=\'node_uid\')">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_domain, join_table=\'item\', join_column=\'node_uid\')">\n
</dtml-if>\n
<dtml-if selection_report>\n
- AND <dtml-var "selection_report.asSQLExpression(strict_membership=1)">\n
+ AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_report, strict_membership=1)">\n
</dtml-if>\n
\n
<dtml-if group_by_expression>\n
More information about the Erp5-report
mailing list