[Erp5-report] r45519 aurel - /erp5/trunk/bt5/erp5_banking_inventory/SkinTemplateItem/portal...
nobody at svn.erp5.org
nobody at svn.erp5.org
Fri Apr 15 16:09:31 CEST 2011
Author: aurel
Date: Fri Apr 15 16:09:31 2011
New Revision: 45519
URL: http://svn.erp5.org?rev=45519&view=rev
Log:
no longer needed script
Removed:
erp5/trunk/bt5/erp5_banking_inventory/SkinTemplateItem/portal_skins/erp5_banking_inventory/InventoryLine_zGetTotal.xml
Removed: erp5/trunk/bt5/erp5_banking_inventory/SkinTemplateItem/portal_skins/erp5_banking_inventory/InventoryLine_zGetTotal.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_inventory/SkinTemplateItem/portal_skins/erp5_banking_inventory/InventoryLine_zGetTotal.xml?rev=45518&view=auto
==============================================================================
--- erp5/trunk/bt5/erp5_banking_inventory/SkinTemplateItem/portal_skins/erp5_banking_inventory/InventoryLine_zGetTotal.xml [utf8] (original)
+++ erp5/trunk/bt5/erp5_banking_inventory/SkinTemplateItem/portal_skins/erp5_banking_inventory/InventoryLine_zGetTotal.xml (removed)
@@ -1,143 +0,0 @@
-<?xml version="1.0"?>
-<ZopeData>
- <record id="1" aka="AAAAAAAAAAE=">
- <pickle>
- <global name="SQL" module="Products.ZSQLMethods.SQL"/>
- </pickle>
- <pickle>
- <dictionary>
- <item>
- <key> <string>_col</string> </key>
- <value>
- <list>
- <dictionary>
- <item>
- <key> <string>name</string> </key>
- <value> <string>total_quantity</string> </value>
- </item>
- <item>
- <key> <string>null</string> </key>
- <value> <int>1</int> </value>
- </item>
- <item>
- <key> <string>type</string> </key>
- <value> <string>n</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>total_price</string> </value>
- </item>
- <item>
- <key> <string>null</string> </key>
- <value> <int>1</int> </value>
- </item>
- <item>
- <key> <string>type</string> </key>
- <value> <string>n</string> </value>
- </item>
- <item>
- <key> <string>width</string> </key>
- <value> <int>6</int> </value>
- </item>
- </dictionary>
- <dictionary>
- <item>
- <key> <string>name</string> </key>
- <value> <string>target_total_quantity</string> </value>
- </item>
- <item>
- <key> <string>null</string> </key>
- <value> <int>1</int> </value>
- </item>
- <item>
- <key> <string>type</string> </key>
- <value> <string>n</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>target_total_price</string> </value>
- </item>
- <item>
- <key> <string>null</string> </key>
- <value> <int>1</int> </value>
- </item>
- <item>
- <key> <string>type</string> </key>
- <value> <string>n</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>average_price</string> </value>
- </item>
- <item>
- <key> <string>null</string> </key>
- <value> <int>1</int> </value>
- </item>
- <item>
- <key> <string>type</string> </key>
- <value> <string>n</string> </value>
- </item>
- <item>
- <key> <string>width</string> </key>
- <value> <int>5</int> </value>
- </item>
- </dictionary>
- </list>
- </value>
- </item>
- <item>
- <key> <string>arguments_src</string> </key>
- <value> <string>uid</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>InventoryLine_zGetTotal</string> </value>
- </item>
- <item>
- <key> <string>src</string> </key>
- <value> <string encoding="cdata"><![CDATA[
-
-SELECT \n
-\tSUM(inventory) AS total_inventory, \n
-\tSUM(inventory * price) AS total_price, \n
-\tAVG(price) AS average_price\n
-FROM\n
- catalog, movement\n
-WHERE \n
-\tcatalog.parent_uid = <dtml-sqlvar uid type="int">\n
-AND\t\n
-\tcatalog.uid = movement.uid\n
-
-
-]]></string> </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