[Erp5-report] r7445 - in /erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/er...
nobody at svn.erp5.org
nobody at svn.erp5.org
Tue May 23 14:52:46 CEST 2006
Author: aurel
Date: Tue May 23 14:52:42 2006
New Revision: 7445
URL: http://svn.erp5.org?rev=7445&view=rev
Log:
many skins improvement
Added:
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/DeliveryCell_view/my_cash_status_translated_title.xml
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/Resource_zGetTrackingList.xml
Modified:
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDeliveryLine_view.xml
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDeliveryLine_view/matrixbox_quantity.xml
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDelivery_checkCounterInventory.xml
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDelivery_generateCashDetailInputDialog.xml
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDetail_asCellRange.xml
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_getVaultTransactionList.xml
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_viewVaultReport.xml
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_viewVaultReport/listbox.xml
erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/DeliveryCell_view.xml
Modified: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDeliveryLine_view.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDeliveryLine_view.xml?rev=7445&r1=7444&r2=7445&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDeliveryLine_view.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDeliveryLine_view.xml Tue May 23 14:52:42 2006
@@ -100,6 +100,7 @@
<list>
<string>matrixbox_membership_criterion_category_list</string>
<string>membership_criterion_base_category_list</string>
+ <string>matrixbox_quantity</string>
</list>
</value>
</item>
@@ -109,7 +110,6 @@
<list>
<string>my_resource_translated_title</string>
<string>my_total_price</string>
- <string>matrixbox_quantity</string>
</list>
</value>
</item>
Modified: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDeliveryLine_view/matrixbox_quantity.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDeliveryLine_view/matrixbox_quantity.xml?rev=7445&r1=7444&r2=7445&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDeliveryLine_view/matrixbox_quantity.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDeliveryLine_view/matrixbox_quantity.xml Tue May 23 14:52:42 2006
@@ -126,27 +126,29 @@
</item>
<item>
<key> <string>default</string> </key>
- <value> <string></string> </value>
- </item>
- <item>
- <key> <string>description</string> </key>
- <value> <string></string> </value>
- </item>
- <item>
- <key> <string>display_maxwidth</string> </key>
- <value> <string></string> </value>
- </item>
- <item>
- <key> <string>display_width</string> </key>
- <value> <string></string> </value>
- </item>
- <item>
- <key> <string>editable</string> </key>
<value>
<persistent> <string encoding="base64">AAAAAAAAAAI=</string> </persistent>
</value>
</item>
<item>
+ <key> <string>description</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>display_maxwidth</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>display_width</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>editable</string> </key>
+ <value>
+ <persistent> <string encoding="base64">AAAAAAAAAAM=</string> </persistent>
+ </value>
+ </item>
+ <item>
<key> <string>enabled</string> </key>
<value> <string></string> </value>
</item>
@@ -165,7 +167,7 @@
<item>
<key> <string>input_style</string> </key>
<value>
- <persistent> <string encoding="base64">AAAAAAAAAAM=</string> </persistent>
+ <persistent> <string encoding="base64">AAAAAAAAAAQ=</string> </persistent>
</value>
</item>
<item>
@@ -275,7 +277,7 @@
<dictionary>
<item>
<key> <string>_text</string> </key>
- <value> <string>python: here.getSimulationState() == \'draft\'</string> </value>
+ <value> <string>python: int(cell.getProperty(\'quantity\'))</string> </value>
</item>
</dictionary>
</pickle>
@@ -294,6 +296,25 @@
<dictionary>
<item>
<key> <string>_text</string> </key>
+ <value> <string>python: here.getSimulationState() == \'draft\'</string> </value>
+ </item>
+ </dictionary>
+ </pickle>
+ </record>
+ <record id="4" aka="AAAAAAAAAAQ=">
+ <pickle>
+ <tuple>
+ <tuple>
+ <string>Products.Formulator.TALESField</string>
+ <string>TALESMethod</string>
+ </tuple>
+ <none/>
+ </tuple>
+ </pickle>
+ <pickle>
+ <dictionary>
+ <item>
+ <key> <string>_text</string> </key>
<value> <string>string:-1 234.5 | preferences/getPreferredMoneyQuantityStyle</string> </value>
</item>
</dictionary>
Modified: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDelivery_checkCounterInventory.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDelivery_checkCounterInventory.xml?rev=7445&r1=7444&r2=7445&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDelivery_checkCounterInventory.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDelivery_checkCounterInventory.xml Tue May 23 14:52:42 2006
@@ -106,11 +106,11 @@
if line.hasCellContent() :\n
for cell in line.objectValues() :\n
variation_text = cell.getVariationText()\n
- # context.log(\'check cell : \', str((source_counter, line_resource, variation_text)))\n
+ context.log(\'check cell : \', str((source_counter, line_resource, variation_text)))\n
inventory_value = context.portal_simulation.getFutureInventory(node=source_counter, resource = line_resource,\n
variation_text = variation_text)\n
- # context.log(\'cell quantity\', cell.getQuantity())\n
- # context.log(\'inventory value\', inventory_value)\n
+ context.log(\'cell quantity\', cell.getQuantity())\n
+ context.log(\'inventory value\', inventory_value)\n
if inventory_value - cell.getQuantity() < 0:\n
return 1\n
\n
@@ -195,6 +195,7 @@
<string>line_resource</string>
<string>cell</string>
<string>variation_text</string>
+ <string>str</string>
<string>inventory_value</string>
</tuple>
</value>
Modified: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDelivery_generateCashDetailInputDialog.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDelivery_generateCashDetailInputDialog.xml?rev=7445&r1=7444&r2=7445&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDelivery_generateCashDetailInputDialog.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDelivery_generateCashDetailInputDialog.xml Tue May 23 14:52:42 2006
@@ -198,7 +198,6 @@
for currency_cash in currency_cash_list:\n
# Search if the current object contains a line with a given portal type.\n
cash_delivery_line = context.CashDelivery_searchLineByResource(currency_cash.getId(), line_portal_type)\n
- #context.log("cash_delivery_line", str((cash_delivery_line, currency_cash.getTitle())))\n
# This variable counts the number of lines added for this currency cash.\n
line_number = 0\n
\n
@@ -328,10 +327,11 @@
listbox_line_count = len(listbox)\n
if listbox_line_count > 0:\n
listbox_line_count_plus_1 = listbox_line_count+1\n
- else:\n
+ else: # XXX when this can happen ?\n
listbox_line_count_plus_1 = listbox_line_count\n
\n
last_row = False\n
+ context.log("listbox", listbox)\n
# for x in listbox :\n
for i_listbox in xrange(0,listbox_line_count_plus_1) : # Element of ListBox\n
if i_listbox < listbox_line_count:\n
@@ -340,9 +340,10 @@
else:\n
last_row = True\n
\n
- if preview_listbox_line is None :\n
+ if preview_listbox_line is None : # first line\n
preview_listbox_line = listbox_line.copy()\n
- elif last_row or preview_listbox_line[\'resource_id\'] <> listbox_line[\'resource_id\'] :\n
+ elif last_row or preview_listbox_line[\'resource_id\'] <> listbox_line[\'resource_id\']:\n
+ # last line or line of different resource\n
if number_line_to_add > (max_lines - number_same_line) :\n
number_line_to_add = max_lines - number_same_line\n
if number_line_to_add > 0:\n
Modified: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDetail_asCellRange.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDetail_asCellRange.xml?rev=7445&r1=7444&r2=7445&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDetail_asCellRange.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CashDetail_asCellRange.xml Tue May 23 14:52:42 2006
@@ -68,7 +68,7 @@
<key> <string>_body</string> </key>
<value> <string>#if context.getPortalType() == \'Container Line\' :\n
# category_list = ((\'variation\',),)\n
-context.log(context.getPath(), base_category)\n
+#context.log(context.getPath(), base_category)\n
if base_category != None and base_category in context.getVariationBaseCategoryList():\n
variation_list = []\n
for category_item in context.getVariationCategoryItemList():\n
@@ -85,7 +85,7 @@
cash_line_list = []\n
for base_category in base_category_list :\n
cash_line_list.append([x for x in context.OrderLine_getMatrixItemList(base_category) if x in variation_category_list])\n
-context.log("cash line list", str((cash_line_list, base_category_list, variation_category_list, context.OrderLine_getMatrixItemList(base_category))))\n
+#context.log("cash line list", str((cash_line_list, base_category_list, variation_category_list, context.OrderLine_getMatrixItemList(base_category))))\n
return cash_line_list\n
</string> </value>
</item>
@@ -142,9 +142,9 @@
<string>base_category</string>
<string>base_id</string>
<string>matrixbox</string>
+ <string>None</string>
<string>_getattr_</string>
<string>context</string>
- <string>None</string>
<string>variation_list</string>
<string>_getiter_</string>
<string>category_item</string>
@@ -158,7 +158,6 @@
<string>append</string>
<string>$append0</string>
<string>x</string>
- <string>str</string>
</tuple>
</value>
</item>
Modified: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_getVaultTransactionList.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_getVaultTransactionList.xml?rev=7445&r1=7444&r2=7445&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_getVaultTransactionList.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_getVaultTransactionList.xml Tue May 23 14:52:42 2006
@@ -81,15 +81,20 @@
vault_url = vault\n
vault_dict[vault_url] = 1\n
vault_inventory_dict[vault_url] = {}\n
+inventory_kw = {}\n
+inventory_kw[\'group_by_variation\'] = 1\n
+if vault_report_type==\'inventory\':\n
+ inventory_kw[\'group_by_resource\'] = 1\n
vault_inventory_list = context.portal_simulation.getInventoryList( node_category=vault\n
#, resource_category=\'currency/\' + context.Baobab_getPortalReferenceCurrencyID()\n
, ignore_variation=0\n
+ ,**inventory_kw\n
)\n
context.log(\'len(vault_inventory_list:\',len(vault_inventory_list))\n
for vault_inventory in vault_inventory_list:\n
context.log(\'vault_inventory total_quantity\',vault_inventory.total_quantity)\n
context.log(\'vault_inventory total_price\',vault_inventory.total_price)\n
- resource = (vault_inventory.resource_uid, tuple(getVariationTitleList(vault_inventory.resource_relative_url)))\n
+ resource = (vault_inventory.resource_uid, vault_inventory.variation_text or \'\')\n
if not vault_inventory_dict[vault_url].has_key(resource):\n
vault_inventory_dict[vault_url][resource] = {\'quantity\':vault_inventory.total_quantity, \'total_price\':vault_inventory.total_price}\n
\n
@@ -113,8 +118,22 @@
context.log(\'vault_inventory_dict\',vault_inventory_dict)\n
\n
i = 0\n
-for resource in context.Baobab_sortResourceTitleList(resource_dict.keys()):\n
- tmp_dict = {\'resource\':resource[0], \'variation_text\':resource[1]}\n
+#for resource in context.Baobab_sortResourceTitleList(resource_dict.keys()):\n
+for resource in resource_dict.keys():\n
+ variation_text = resource[1]\n
+ tmp_dict = {\'resource\':resource[0], \'variation_text\':variation_text}\n
+ for variation in variation_text.split(\'/n\'):\n
+ if variation.startswith(\'cash_status\'):\n
+ tmp_dict[\'cash_status\'] = variation\n
+ elif variation.startswith(\'emission_letter\'):\n
+ tmp_dict[\'emission_letter\'] = variation\n
+ elif variation.startswith(\'variation\'):\n
+ tmp_dict[\'variation\'] = variation\n
+ tmp_dict[\'variation_title\'] = \' \'.join(getVariationTitleList(resource[1]))\n
+ #resource = (vault_inventory.resource_uid, tuple(getVariationTitleList(vault_inventory.variation_text or \'\')))\n
+ resource_value = context.portal_catalog.getObject(resource[0])\n
+ tmp_dict[\'base_price\'] = resource_value.getBasePrice()\n
+ tmp_dict[\'resource_title\'] = resource_value.getTitle()\n
general_total_price = 0\n
for vault in vault_dict.keys():\n
try:\n
@@ -127,7 +146,15 @@
tmp_dict[\'general_total_price\'] = general_total_price\n
total_inventory_list.append(newTempBase(context, "new_%3i" % i, **tmp_dict))\n
i += 1\n
+\n
+def sort_base_price(a,b):\n
+ return -cmp(a.base_price,b.base_price)\n
+\n
+total_inventory_list.sort(sort_base_price)\n
+\n
return total_inventory_list\n
+\n
+\n
return repr([x for x in total_inventory_list])\n
</string> </value>
</item>
@@ -155,7 +182,7 @@
</item>
<item>
<key> <string>_params</string> </key>
- <value> <string>vault=None,column_names=0, **kw</string> </value>
+ <value> <string>vault=None,vault_report_type=None,column_names=0, **kw</string> </value>
</item>
<item>
<key> <string>errors</string> </key>
@@ -175,13 +202,14 @@
<dictionary>
<item>
<key> <string>co_argcount</string> </key>
- <value> <int>2</int> </value>
+ <value> <int>3</int> </value>
</item>
<item>
<key> <string>co_varnames</string> </key>
<value>
<tuple>
<string>vault</string>
+ <string>vault_report_type</string>
<string>column_names</string>
<string>kw</string>
<string>Products.ERP5Type.Document</string>
@@ -193,23 +221,27 @@
<string>vault_inventory_dict</string>
<string>vault_url</string>
<string>_write_</string>
+ <string>inventory_kw</string>
+ <string>_apply_</string>
<string>_getattr_</string>
<string>context</string>
<string>vault_inventory_list</string>
<string>len</string>
<string>_getiter_</string>
<string>vault_inventory</string>
- <string>tuple</string>
<string>resource</string>
<string>_getitem_</string>
<string>column_list</string>
<string>total_inventory_list</string>
<string>i</string>
+ <string>variation_text</string>
<string>tmp_dict</string>
+ <string>variation</string>
+ <string>resource_value</string>
<string>general_total_price</string>
<string>resource_in_vault</string>
<string>KeyError</string>
- <string>_apply_</string>
+ <string>sort_base_price</string>
<string>repr</string>
<string>append</string>
<string>$append0</string>
@@ -226,6 +258,7 @@
<key> <string>func_defaults</string> </key>
<value>
<tuple>
+ <none/>
<none/>
<int>0</int>
</tuple>
Modified: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_viewVaultReport.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_viewVaultReport.xml?rev=7445&r1=7444&r2=7445&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_viewVaultReport.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_viewVaultReport.xml Tue May 23 14:52:42 2006
@@ -140,7 +140,7 @@
</item>
<item>
<key> <string>title</string> </key>
- <value> <string></string> </value>
+ <value> <string>Vault Report</string> </value>
</item>
<item>
<key> <string>unicode_mode</string> </key>
Modified: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_viewVaultReport/listbox.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_viewVaultReport/listbox.xml?rev=7445&r1=7444&r2=7445&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_viewVaultReport/listbox.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/CounterModule_viewVaultReport/listbox.xml Tue May 23 14:52:42 2006
@@ -370,7 +370,7 @@
<string>Total Price</string>
</tuple>
<tuple>
- <string>variation_text</string>
+ <string>variation_text_title</string>
<string>Variation</string>
</tuple>
<tuple>
Modified: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/DeliveryCell_view.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/DeliveryCell_view.xml?rev=7445&r1=7444&r2=7445&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/DeliveryCell_view.xml (original)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/DeliveryCell_view.xml Tue May 23 14:52:42 2006
@@ -105,7 +105,7 @@
<value>
<list>
<string>my_variation_title</string>
- <string>my_cash_status_title</string>
+ <string>my_cash_status_translated_title</string>
<string>my_emission_letter_title</string>
</list>
</value>
Added: erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/DeliveryCell_view/my_cash_status_translated_title.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/DeliveryCell_view/my_cash_status_translated_title.xml?rev=7445&view=auto
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/DeliveryCell_view/my_cash_status_translated_title.xml (added)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/DeliveryCell_view/my_cash_status_translated_title.xml Tue May 23 14:52:42 2006
@@ -1,0 +1,272 @@
+<?xml version="1.0"?>
+<ZopeData>
+ <record id="1" aka="AAAAAAAAAAE=">
+ <pickle>
+ <tuple>
+ <tuple>
+ <string>Products.Formulator.StandardFields</string>
+ <string>StringField</string>
+ </tuple>
+ <none/>
+ </tuple>
+ </pickle>
+ <pickle>
+ <dictionary>
+ <item>
+ <key> <string>_owner</string> </key>
+ <value>
+ <none/>
+ </value>
+ </item>
+ <item>
+ <key> <string>id</string> </key>
+ <value> <string>my_cash_status_translated_title</string> </value>
+ </item>
+ <item>
+ <key> <string>message_values</string> </key>
+ <value>
+ <dictionary>
+ <item>
+ <key> <string>external_validator_failed</string> </key>
+ <value> <string>The input failed the external validator.</string> </value>
+ </item>
+ <item>
+ <key> <string>required_not_found</string> </key>
+ <value> <string>Input is required but no input given.</string> </value>
+ </item>
+ <item>
+ <key> <string>too_long</string> </key>
+ <value> <string>Too much input was given.</string> </value>
+ </item>
+ </dictionary>
+ </value>
+ </item>
+ <item>
+ <key> <string>overrides</string> </key>
+ <value>
+ <dictionary>
+ <item>
+ <key> <string>alternate_name</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>css_class</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>default</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>description</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>display_maxwidth</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>display_width</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>editable</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>enabled</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>external_validator</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>extra</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>hidden</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>max_length</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>required</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>title</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>truncate</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>unicode</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>whitespace_preserve</string> </key>
+ <value> <string></string> </value>
+ </item>
+ </dictionary>
+ </value>
+ </item>
+ <item>
+ <key> <string>tales</string> </key>
+ <value>
+ <dictionary>
+ <item>
+ <key> <string>alternate_name</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>css_class</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>default</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>description</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>display_maxwidth</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>display_width</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>editable</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>enabled</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>external_validator</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>extra</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>hidden</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>max_length</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>required</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>title</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>truncate</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>unicode</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>whitespace_preserve</string> </key>
+ <value> <string></string> </value>
+ </item>
+ </dictionary>
+ </value>
+ </item>
+ <item>
+ <key> <string>values</string> </key>
+ <value>
+ <dictionary>
+ <item>
+ <key> <string>alternate_name</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>css_class</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>default</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>description</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>display_maxwidth</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>display_width</string> </key>
+ <value> <int>20</int> </value>
+ </item>
+ <item>
+ <key> <string>editable</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>enabled</string> </key>
+ <value> <int>1</int> </value>
+ </item>
+ <item>
+ <key> <string>external_validator</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>extra</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>hidden</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>max_length</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>required</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>title</string> </key>
+ <value> <string>Cash Status</string> </value>
+ </item>
+ <item>
+ <key> <string>truncate</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>unicode</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>whitespace_preserve</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ </dictionary>
+ </value>
+ </item>
+ </dictionary>
+ </pickle>
+ </record>
+</ZopeData>
Added: 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=7445&view=auto
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/Resource_zGetTrackingList.xml (added)
+++ erp5/trunk/bt5/erp5_banking_core/SkinTemplateItem/portal_skins/erp5_banking_core/Resource_zGetTrackingList.xml Tue May 23 14:52:42 2006
@@ -1,0 +1,616 @@
+<?xml version="1.0"?>
+<ZopeData>
+ <record id="1" aka="AAAAAAAAAAE=">
+ <pickle>
+ <tuple>
+ <tuple>
+ <string>Products.ZSQLMethods.SQL</string>
+ <string>SQL</string>
+ </tuple>
+ <none/>
+ </tuple>
+ </pickle>
+ <pickle>
+ <dictionary>
+ <item>
+ <key> <string>_Use_Database_Methods_Permission</string> </key>
+ <value>
+ <list>
+ <string>Member</string>
+ </list>
+ </value>
+ </item>
+ <item>
+ <key> <string>__ac_local_roles__</string> </key>
+ <value>
+ <none/>
+ </value>
+ </item>
+ <item>
+ <key> <string>_arg</string> </key>
+ <value>
+ <object>
+ <klass>
+ <global name="Args" module="Shared.DC.ZRDB.Aqueduct"/>
+ </klass>
+ <tuple/>
+ <state>
+ <dictionary>
+ <item>
+ <key> <string>_data</string> </key>
+ <value>
+ <dictionary>
+ <item>
+ <key> <string>at_date</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>date_condition_in_join</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>from_date</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>from_table_list</string> </key>
+ <value>
+ <dictionary>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>list</string> </value>
+ </item>
+ </dictionary>
+ </value>
+ </item>
+ <item>
+ <key> <string>group_by_expression</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>input</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>join_on_item</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>order_by_expression</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>output</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>selection_domain</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>selection_report</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>simulation_state_list</string> </key>
+ <value>
+ <dictionary>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>list</string> </value>
+ </item>
+ </dictionary>
+ </value>
+ </item>
+ <item>
+ <key> <string>to_date</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>where_expression</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ </dictionary>
+ </value>
+ </item>
+ <item>
+ <key> <string>_keys</string> </key>
+ <value>
+ <list>
+<string>from_date</string>
+<string>at_date</string>
+<string>to_date</string>
+<string>input</string>
+<string>output</string>
+<string>from_table_list</string>
+<string>where_expression</string>
+<string>selection_domain</string>
+<string>selection_report</string>
+<string>order_by_expression</string>
+<string>group_by_expression</string>
+<string>join_on_item</string>
+<string>date_condition_in_join</string>
+<string>simulation_state_list</string>
+ </list>
+ </value>
+ </item>
+ </dictionary>
+ </state>
+ </object>
+ </value>
+ </item>
+ <item>
+ <key> <string>_col</string> </key>
+ <value>
+ <list>
+ <dictionary>
+ <item>
+ <key> <string>name</string> </key>
+ <value> <string>uid</string> </value>
+ </item>
+ <item>
+ <key> <string>null</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>i</string> </value>
+ </item>
+ <item>
+ <key> <string>width</string> </key>
+ <value> <int>10</int> </value>
+ </item>
+ </dictionary>
+ <dictionary>
+ <item>
+ <key> <string>name</string> </key>
+ <value> <string>path</string> </value>
+ </item>
+ <item>
+ <key> <string>null</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>t</string> </value>
+ </item>
+ <item>
+ <key> <string>width</string> </key>
+ <value> <int>27</int> </value>
+ </item>
+ </dictionary>
+ <dictionary>
+ <item>
+ <key> <string>name</string> </key>
+ <value> <string>resource_title</string> </value>
+ </item>
+ <item>
+ <key> <string>null</string> </key>
+ <value> <int>1</int> </value>
+ </item>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>t</string> </value>
+ </item>
+ <item>
+ <key> <string>width</string> </key>
+ <value> <int>16</int> </value>
+ </item>
+ </dictionary>
+ <dictionary>
+ <item>
+ <key> <string>name</string> </key>
+ <value> <string>resource_relative_url</string> </value>
+ </item>
+ <item>
+ <key> <string>null</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>t</string> </value>
+ </item>
+ <item>
+ <key> <string>width</string> </key>
+ <value> <int>13</int> </value>
+ </item>
+ </dictionary>
+ <dictionary>
+ <item>
+ <key> <string>name</string> </key>
+ <value> <string>resource_uid</string> </value>
+ </item>
+ <item>
+ <key> <string>null</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>i</string> </value>
+ </item>
+ <item>
+ <key> <string>width</string> </key>
+ <value> <int>8</int> </value>
+ </item>
+ </dictionary>
+ <dictionary>
+ <item>
+ <key> <string>name</string> </key>
+ <value> <string>section_uid</string> </value>
+ </item>
+ <item>
+ <key> <string>null</string> </key>
+ <value> <int>1</int> </value>
+ </item>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>i</string> </value>
+ </item>
+ <item>
+ <key> <string>width</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ </dictionary>
+ <dictionary>
+ <item>
+ <key> <string>name</string> </key>
+ <value> <string>node_uid</string> </value>
+ </item>
+ <item>
+ <key> <string>null</string> </key>
+ <value> <int>1</int> </value>
+ </item>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>i</string> </value>
+ </item>
+ <item>
+ <key> <string>width</string> </key>
+ <value> <int>10</int> </value>
+ </item>
+ </dictionary>
+ <dictionary>
+ <item>
+ <key> <string>name</string> </key>
+ <value> <string>variation_text</string> </value>
+ </item>
+ <item>
+ <key> <string>null</string> </key>
+ <value> <int>1</int> </value>
+ </item>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>t</string> </value>
+ </item>
+ <item>
+ <key> <string>width</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ </dictionary>
+ <dictionary>
+ <item>
+ <key> <string>name</string> </key>
+ <value> <string>date</string> </value>
+ </item>
+ <item>
+ <key> <string>null</string> </key>
+ <value> <int>1</int> </value>
+ </item>
+ <item>
+ <key> <string>type</string> </key>
+ <value> <string>d</string> </value>
+ </item>
+ <item>
+ <key> <string>width</string> </key>
+ <value> <int>19</int> </value>
+ </item>
+ </dictionary>
+ </list>
+ </value>
+ </item>
+ <item>
+ <key> <string>_owner</string> </key>
+ <value>
+ <none/>
+ </value>
+ </item>
+ <item>
+ <key> <string>allow_simple_one_argument_traversal</string> </key>
+ <value>
+ <none/>
+ </value>
+ </item>
+ <item>
+ <key> <string>arguments_src</string> </key>
+ <value> <string>from_date\r\n
+at_date\r\n
+to_date\r\n
+input\r\n
+output\r\n
+from_table_list:list\r\n
+where_expression\r\n
+selection_domain\r\n
+selection_report\r\n
+order_by_expression\r\n
+group_by_expression\r\n
+join_on_item\r\n
+date_condition_in_join\r\n
+simulation_state_list:list</string> </value>
+ </item>
+ <item>
+ <key> <string>cache_time_</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>class_file_</string> </key>
+ <value> <string>InventoryBrain.py</string> </value>
+ </item>
+ <item>
+ <key> <string>class_name_</string> </key>
+ <value> <string>InventoryListBrain</string> </value>
+ </item>
+ <item>
+ <key> <string>connection_hook</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>connection_id</string> </key>
+ <value> <string>erp5_sql_connection</string> </value>
+ </item>
+ <item>
+ <key> <string>id</string> </key>
+ <value> <string>Resource_zGetTrackingList</string> </value>
+ </item>
+ <item>
+ <key> <string>max_cache_</string> </key>
+ <value> <int>100</int> </value>
+ </item>
+ <item>
+ <key> <string>max_rows_</string> </key>
+ <value> <int>1000</int> </value>
+ </item>
+ <item>
+ <key> <string>src</string> </key>
+ <value> <string encoding="cdata"><![CDATA[
+
+SELECT \n
+ item.aggregate_uid AS uid,\n
+ item_catalog.path AS path,\n
+ item.date AS date,\n
+ item.node_uid AS node_uid,\n
+ item.section_uid AS section_uid,\n
+ item.resource_uid AS resource_uid,\n
+ item.variation_text AS variation_text,\n
+ item.uid AS delivery_uid\n
+FROM\n
+ catalog as item_catalog\n
+<dtml-if from_table_list>\n
+ <dtml-in prefix="table" expr="from_table_list"> \n
+ <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
+, item\n
+\n
+\n
+<dtml-if join_on_item>\n
+ LEFT JOIN \n
+ item AS next_item\n
+ ON (\n
+ <dtml-if date_condition_in_join>\n
+ next_item.date <= <dtml-sqlvar at_date type="string">\n
+ AND\n
+ </dtml-if>\n
+ next_item.aggregate_uid = item.aggregate_uid\n
+ AND\n
+ <dtml-if input>\n
+ next_item.date < item.date\n
+ <dtml-else>\n
+ next_item.date > item.date\n
+ </dtml-if>\n
+ <dtml-if simulation_state_list>\n
+ AND (\n
+ <dtml-in simulation_state_list>\n
+ next_item.simulation_state = <dtml-sqlvar sequence-item type="string"> \n
+ <dtml-if sequence-end>\n
+ <dtml-else>\n
+ OR \n
+ </dtml-if>\n
+ </dtml-in>\n
+ )\n
+ </dtml-if>\n
+ )\n
+</dtml-if>\n
+\n
+WHERE\n
+ 1 = 1\n
+\n
+<dtml-if where_expression>\n
+ AND <dtml-var where_expression>\n
+</dtml-if>\n
+\n
+ AND item_catalog.uid = item.aggregate_uid\n
+\n
+<dtml-if join_on_item>\n
+ AND next_item.uid IS NULL\n
+</dtml-if>\n
+\n
+\n
+<dtml-if selection_domain>\n
+ AND <dtml-var "selection_domain.asSqlExpression(join_table=\'item\',\n
+ join_column=\'node_uid\')">\n
+</dtml-if>\n
+<dtml-if selection_report>\n
+ AND <dtml-var "selection_report.asSqlExpression(strict_membership=1)">\n
+</dtml-if>\n
+\n
+<dtml-if group_by_expression>\n
+GROUP BY <dtml-var group_by_expression>\n
+</dtml-if>\n
+\n
+<dtml-if order_by_expression>\n
+ORDER BY\n
+ <dtml-var order_by_expression>\n
+<dtml-else>\n
+ORDER BY item.date DESC\n
+</dtml-if>
+
+]]></string> </value>
+ </item>
+ <item>
+ <key> <string>template</string> </key>
+ <value>
+ <object>
+ <klass>
+ <global name="SQL" module="Shared.DC.ZRDB.DA"/>
+ </klass>
+ <none/>
+ <state>
+ <dictionary>
+ <item>
+ <key> <string>__name__</string> </key>
+ <value> <string encoding="cdata"><![CDATA[
+
+<string>
+
+]]></string> </value>
+ </item>
+ <item>
+ <key> <string>_vars</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>globals</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>raw</string> </key>
+ <value> <string encoding="cdata"><![CDATA[
+
+SELECT \n
+ item.aggregate_uid AS uid,\n
+ item_catalog.path AS path,\n
+ item.date AS date,\n
+ item.node_uid AS node_uid,\n
+ item.section_uid AS section_uid,\n
+ item.resource_uid AS resource_uid,\n
+ item.variation_text AS variation_text,\n
+ item.uid AS delivery_uid\n
+FROM\n
+ catalog as item_catalog\n
+<dtml-if from_table_list>\n
+ <dtml-in prefix="table" expr="from_table_list"> \n
+ <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
+, item\n
+\n
+\n
+<dtml-if join_on_item>\n
+ LEFT JOIN \n
+ item AS next_item\n
+ ON (\n
+ <dtml-if date_condition_in_join>\n
+ next_item.date <= <dtml-sqlvar at_date type="string">\n
+ AND\n
+ </dtml-if>\n
+ next_item.aggregate_uid = item.aggregate_uid\n
+ AND\n
+ <dtml-if input>\n
+ next_item.date < item.date\n
+ <dtml-else>\n
+ next_item.date > item.date\n
+ </dtml-if>\n
+ <dtml-if simulation_state_list>\n
+ AND (\n
+ <dtml-in simulation_state_list>\n
+ next_item.simulation_state = <dtml-sqlvar sequence-item type="string"> \n
+ <dtml-if sequence-end>\n
+ <dtml-else>\n
+ OR \n
+ </dtml-if>\n
+ </dtml-in>\n
+ )\n
+ </dtml-if>\n
+ )\n
+</dtml-if>\n
+\n
+WHERE\n
+ 1 = 1\n
+\n
+<dtml-if where_expression>\n
+ AND <dtml-var where_expression>\n
+</dtml-if>\n
+\n
+ AND item_catalog.uid = item.aggregate_uid\n
+\n
+<dtml-if join_on_item>\n
+ AND next_item.uid IS NULL\n
+</dtml-if>\n
+\n
+\n
+<dtml-if selection_domain>\n
+ AND <dtml-var "selection_domain.asSqlExpression(join_table=\'item\',\n
+ join_column=\'node_uid\')">\n
+</dtml-if>\n
+<dtml-if selection_report>\n
+ AND <dtml-var "selection_report.asSqlExpression(strict_membership=1)">\n
+</dtml-if>\n
+\n
+<dtml-if group_by_expression>\n
+GROUP BY <dtml-var group_by_expression>\n
+</dtml-if>\n
+\n
+<dtml-if order_by_expression>\n
+ORDER BY\n
+ <dtml-var order_by_expression>\n
+<dtml-else>\n
+ORDER BY item.date DESC\n
+</dtml-if>
+
+]]></string> </value>
+ </item>
+ </dictionary>
+ </state>
+ </object>
+ </value>
+ </item>
+ <item>
+ <key> <string>title</string> </key>
+ <value> <string></string> </value>
+ </item>
+ </dictionary>
+ </pickle>
+ </record>
+</ZopeData>
More information about the Erp5-report
mailing list