[Erp5-report] r37335 jerome - in /erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_sk...
nobody at svn.erp5.org
nobody at svn.erp5.org
Wed Jul 28 14:20:00 CEST 2010
Author: jerome
Date: Wed Jul 28 14:19:59 2010
New Revision: 37335
URL: http://svn.erp5.org?rev=37335&view=rev
Log:
remove obsolete scripts
Removed:
erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/Account_zGetTotalQuantity.xml
erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting_bbb/Account_statSourceBalance.xml
Removed: erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/Account_zGetTotalQuantity.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/Account_zGetTotalQuantity.xml?rev=37334&view=auto
==============================================================================
--- erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/Account_zGetTotalQuantity.xml [utf8] (original)
+++ erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/Account_zGetTotalQuantity.xml (removed)
@@ -1,426 +0,0 @@
-<?xml version="1.0"?>
-<ZopeData>
- <record id="1" aka="AAAAAAAAAAE=">
- <pickle>
- <tuple>
- <global name="SQL" module="Products.ZSQLMethods.SQL"/>
- <tuple/>
- </tuple>
- </pickle>
- <pickle>
- <dictionary>
- <item>
- <key> <string>_Use_Database_Methods_Permission</string> </key>
- <value>
- <list>
- <string>Assignee</string>
- <string>Assignor</string>
- <string>Associate</string>
- <string>Auditor</string>
- <string>Member</string>
- </list>
- </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>from_date</string> </key>
- <value>
- <dictionary/>
- </value>
- </item>
- <item>
- <key> <string>mirror_section_uid</string> </key>
- <value>
- <dictionary/>
- </value>
- </item>
- <item>
- <key> <string>no_mirror_section_uid</string> </key>
- <value>
- <dictionary/>
- </value>
- </item>
- <item>
- <key> <string>no_payment_uid</string> </key>
- <value>
- <dictionary/>
- </value>
- </item>
- <item>
- <key> <string>node_uid</string> </key>
- <value>
- <dictionary/>
- </value>
- </item>
- <item>
- <key> <string>omit_input</string> </key>
- <value>
- <dictionary/>
- </value>
- </item>
- <item>
- <key> <string>omit_output</string> </key>
- <value>
- <dictionary/>
- </value>
- </item>
- <item>
- <key> <string>payment_uid</string> </key>
- <value>
- <dictionary/>
- </value>
- </item>
- <item>
- <key> <string>query</string> </key>
- <value>
- <dictionary/>
- </value>
- </item>
- <item>
- <key> <string>resource_uid</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>transaction_section_category</string> </key>
- <value>
- <dictionary/>
- </value>
- </item>
- <item>
- <key> <string>transaction_simulation_state</string> </key>
- <value>
- <dictionary>
- <item>
- <key> <string>type</string> </key>
- <value> <string>list</string> </value>
- </item>
- </dictionary>
- </value>
- </item>
- </dictionary>
- </value>
- </item>
- <item>
- <key> <string>_keys</string> </key>
- <value>
- <list>
- <string>node_uid</string>
- <string>query</string>
- <string>omit_input</string>
- <string>omit_output</string>
- <string>resource_uid</string>
- <string>from_date</string>
- <string>to_date</string>
- <string>at_date</string>
- <string>transaction_simulation_state</string>
- <string>transaction_section_category</string>
- <string>payment_uid</string>
- <string>no_payment_uid</string>
- <string>mirror_section_uid</string>
- <string>no_mirror_section_uid</string>
- </list>
- </value>
- </item>
- </dictionary>
- </state>
- </object>
- </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>node_uid\r\n
-query\r\n
-omit_input\r\n
-omit_output\r\n
-resource_uid:list\r\n
-from_date\r\n
-to_date\r\n
-at_date\r\n
-transaction_simulation_state:list\r\n
-transaction_section_category\r\n
-payment_uid\r\n
-no_payment_uid\r\n
-mirror_section_uid\r\n
-no_mirror_section_uid</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>ZSQLCatalog.zsqlbrain</string> </value>
- </item>
- <item>
- <key> <string>class_name_</string> </key>
- <value> <string>ZSQLBrain</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>Account_zGetTotalQuantity</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>0</int> </value>
- </item>
- <item>
- <key> <string>src</string> </key>
- <value> <string encoding="cdata"><![CDATA[
-
-SELECT\n
- SUM(ROUND(stock.quantity,2)) AS quantity,\n
- SUM(ROUND(stock.total_price,2)) AS total_price\n
-FROM\n
- movement,\n
- stock,\n
- catalog as child,\n
- catalog AS section_c,\n
- catalog AS section_bc, -- XXX probably not necessary\n
- category AS section_membership,\n
- catalog AS section\n
-<dtml-if query>\n
- , category\n
-</dtml-if>\n
-WHERE stock.node_uid = <dtml-var node_uid>\n
- AND child.uid = stock.uid\n
- AND movement.uid = stock.uid\n
- AND child.portal_type <> \'Simulation Movement\'\n
- AND movement.is_accountable = 1\n
-<dtml-if resource_uid>\n
- AND (\n
- <dtml-in resource_uid>\n
- movement.resource_uid = <dtml-sqlvar sequence-item type="int"><dtml-if sequence-end><dtml-else> OR </dtml-if>\n
- </dtml-in>\n
- )\n
-</dtml-if>\n
-<dtml-if from_date>\n
- AND stock.date >= <dtml-sqlvar from_date type="datetime">\n
-</dtml-if>\n
-<dtml-if at_date>\n
- AND stock.date <= <dtml-sqlvar at_date type="datetime">\n
-</dtml-if>\n
-<dtml-if to_date>\n
- AND stock.date < <dtml-sqlvar to_date type="datetime">\n
-</dtml-if>\n
-<dtml-if omit_input>\n
- AND stock.total_price > 0.0\n
-</dtml-if>\n
-<dtml-if omit_output>\n
- AND stock.total_price < 0.0\n
-</dtml-if>\n
-<dtml-if payment_uid>\n
- AND stock.payment_uid = <dtml-sqlvar payment_uid type="int">\n
-</dtml-if>\n
-<dtml-if no_payment_uid>\n
- AND stock.payment_uid IS NULL\n
-</dtml-if>\n
-<dtml-if mirror_section_uid>\n
- AND stock.mirror_section_uid = <dtml-sqlvar mirror_section_uid type="int">\n
-</dtml-if>\n
-<dtml-if no_mirror_section_uid>\n
- AND stock.mirror_section_uid IS NULL\n
-</dtml-if>\n
-<dtml-if transaction_simulation_state>\n
- AND (\n
- <dtml-in transaction_simulation_state>\n
- stock.simulation_state = <dtml-sqlvar sequence-item type="string"><dtml-if sequence-end><dtml-else> OR </dtml-if>\n
- </dtml-in>\n
- )\n
-<dtml-else>\n
- AND stock.simulation_state != \'cancelled\' \n
- AND stock.simulation_state != \'draft\' \n
-</dtml-if>\n
- AND section.uid = stock.section_uid\n
-<dtml-if transaction_section_category>\n
- AND section_c.relative_url = <dtml-sqlvar transaction_section_category type="string">\n
-</dtml-if>\n
- AND section_membership.category_uid = section_c.uid\n
- AND section_membership.base_category_uid = section_bc.uid\n
- AND section_membership.uid = section.uid\n
- AND section.portal_type = \'Organisation\'\n
-<dtml-if query>\n
- AND category.uid = stock.section_uid\n
-AND <dtml-var query>\n
-</dtml-if>\n
-
-
-]]></string> </value>
- </item>
- <item>
- <key> <string>template</string> </key>
- <value>
- <object>
- <klass>
- <global name="__newobj__" module="copy_reg"/>
- </klass>
- <tuple>
- <global name="SQL" module="Shared.DC.ZRDB.DA"/>
- </tuple>
- <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
- SUM(ROUND(stock.quantity,2)) AS quantity,\n
- SUM(ROUND(stock.total_price,2)) AS total_price\n
-FROM\n
- movement,\n
- stock,\n
- catalog as child,\n
- catalog AS section_c,\n
- catalog AS section_bc, -- XXX probably not necessary\n
- category AS section_membership,\n
- catalog AS section\n
-<dtml-if query>\n
- , category\n
-</dtml-if>\n
-WHERE stock.node_uid = <dtml-var node_uid>\n
- AND child.uid = stock.uid\n
- AND movement.uid = stock.uid\n
- AND child.portal_type <> \'Simulation Movement\'\n
- AND movement.is_accountable = 1\n
-<dtml-if resource_uid>\n
- AND (\n
- <dtml-in resource_uid>\n
- movement.resource_uid = <dtml-sqlvar sequence-item type="int"><dtml-if sequence-end><dtml-else> OR </dtml-if>\n
- </dtml-in>\n
- )\n
-</dtml-if>\n
-<dtml-if from_date>\n
- AND stock.date >= <dtml-sqlvar from_date type="datetime">\n
-</dtml-if>\n
-<dtml-if at_date>\n
- AND stock.date <= <dtml-sqlvar at_date type="datetime">\n
-</dtml-if>\n
-<dtml-if to_date>\n
- AND stock.date < <dtml-sqlvar to_date type="datetime">\n
-</dtml-if>\n
-<dtml-if omit_input>\n
- AND stock.total_price > 0.0\n
-</dtml-if>\n
-<dtml-if omit_output>\n
- AND stock.total_price < 0.0\n
-</dtml-if>\n
-<dtml-if payment_uid>\n
- AND stock.payment_uid = <dtml-sqlvar payment_uid type="int">\n
-</dtml-if>\n
-<dtml-if no_payment_uid>\n
- AND stock.payment_uid IS NULL\n
-</dtml-if>\n
-<dtml-if mirror_section_uid>\n
- AND stock.mirror_section_uid = <dtml-sqlvar mirror_section_uid type="int">\n
-</dtml-if>\n
-<dtml-if no_mirror_section_uid>\n
- AND stock.mirror_section_uid IS NULL\n
-</dtml-if>\n
-<dtml-if transaction_simulation_state>\n
- AND (\n
- <dtml-in transaction_simulation_state>\n
- stock.simulation_state = <dtml-sqlvar sequence-item type="string"><dtml-if sequence-end><dtml-else> OR </dtml-if>\n
- </dtml-in>\n
- )\n
-<dtml-else>\n
- AND stock.simulation_state != \'cancelled\' \n
- AND stock.simulation_state != \'draft\' \n
-</dtml-if>\n
- AND section.uid = stock.section_uid\n
-<dtml-if transaction_section_category>\n
- AND section_c.relative_url = <dtml-sqlvar transaction_section_category type="string">\n
-</dtml-if>\n
- AND section_membership.category_uid = section_c.uid\n
- AND section_membership.base_category_uid = section_bc.uid\n
- AND section_membership.uid = section.uid\n
- AND section.portal_type = \'Organisation\'\n
-<dtml-if query>\n
- AND category.uid = stock.section_uid\n
-AND <dtml-var query>\n
-</dtml-if>\n
-
-
-]]></string> </value>
- </item>
- </dictionary>
- </state>
- </object>
- </value>
- </item>
- <item>
- <key> <string>title</string> </key>
- <value> <string></string> </value>
- </item>
- </dictionary>
- </pickle>
- </record>
-</ZopeData>
Removed: erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting_bbb/Account_statSourceBalance.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting_bbb/Account_statSourceBalance.xml?rev=37334&view=auto
==============================================================================
--- erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting_bbb/Account_statSourceBalance.xml [utf8] (original)
+++ erp5/trunk/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting_bbb/Account_statSourceBalance.xml (removed)
@@ -1,289 +0,0 @@
-<?xml version="1.0"?>
-<ZopeData>
- <record id="1" aka="AAAAAAAAAAE=">
- <pickle>
- <tuple>
- <global name="PythonScript" module="Products.PythonScripts.PythonScript"/>
- <tuple/>
- </tuple>
- </pickle>
- <pickle>
- <dictionary>
- <item>
- <key> <string>Script_magic</string> </key>
- <value> <int>3</int> </value>
- </item>
- <item>
- <key> <string>_bind_names</string> </key>
- <value>
- <object>
- <klass>
- <global name="NameAssignments" module="Shared.DC.Scripts.Bindings"/>
- </klass>
- <tuple/>
- <state>
- <dictionary>
- <item>
- <key> <string>_asgns</string> </key>
- <value>
- <dictionary>
- <item>
- <key> <string>name_container</string> </key>
- <value> <string>container</string> </value>
- </item>
- <item>
- <key> <string>name_context</string> </key>
- <value> <string>context</string> </value>
- </item>
- <item>
- <key> <string>name_m_self</string> </key>
- <value> <string>script</string> </value>
- </item>
- <item>
- <key> <string>name_subpath</string> </key>
- <value> <string>traverse_subpath</string> </value>
- </item>
- </dictionary>
- </value>
- </item>
- </dictionary>
- </state>
- </object>
- </value>
- </item>
- <item>
- <key> <string>_body</string> </key>
- <value> <string>context.log(\'erp5_account\', \'%s is deprecated, use %s instead\'\n
- % (script.getId(), \'Account_statBalance\'))\n
-\n
-params = {}\n
-pref = context.getPortalObject().portal_preferences\n
-precision = context.Base_getPreferredPrecision()\n
-\n
-###\n
-# Merge selection parameters in kw\n
-selection_params = None\n
-if selection_name is not None:\n
- selection_params = context.portal_selections.getSelectionParamsFor(selection_name)\n
- kw.update(selection_params)\n
-\n
-###\n
-# Get the node UID\n
-params[\'node_uid\'] = kw.get(\'node_uid\', context.getUid())\n
-\n
-###\n
-# Get the \'where_expression\' parameter\n
-if kw.has_key(\'where_expression\'):\n
- params[\'where_expression\'] = kw[\'where_expression\']\n
-\n
-###\n
-# Get the \'resource_uid\' parameter\n
-if kw.get(\'resource\'):\n
- try:\n
- params[\'resource_uid\'] = context.restrictedTraverse(selection_params[\'resource\']).getUid()\n
- except (KeyError, AttributeError):\n
- pass\n
-\n
-###\n
-# Get the \'from_date\' parameter\n
-if kw.get(\'no_from_date\', 0):\n
- from_date = None\n
-else:\n
- from_date = kw.get( \'from_date\'\n
- , pref.getPreferredAccountingTransactionFromDate()\n
- )\n
-if from_date:\n
- params[\'from_date\'] = from_date\n
-\n
-###\n
-# Get the \'at_date\' parameter\n
-at_date = kw.get( \'at_date\'\n
- , pref.getPreferredAccountingTransactionAtDate()\n
- )\n
-if at_date:\n
- params[\'at_date\'] = at_date\n
-\n
-###\n
-# Get the \'to_date\' parameter\n
-to_date = kw.get( \'to_date\'\n
- , None\n
- )\n
-if to_date:\n
- params[\'to_date\'] = to_date\n
-\n
-###\n
-# Get the \'simulation_state\' parameter\n
-# Sometimes \'simulation_state\' is now as \'transaction_simulation_state\'\n
-simulation_state = kw.get( \'transaction_simulation_state\'\n
- , None\n
- )\n
-if not simulation_state:\n
- simulation_state = kw.get( \'simulation_state\'\n
- , pref.getPreferredAccountingTransactionSimulationStateList()\n
- )\n
-if simulation_state:\n
- params[\'transaction_simulation_state\'] = simulation_state\n
-\n
-###\n
-# Get the \'section_category\' parameter\n
-# Sometimes \'section_category\' is now as \'transaction_section_category\'\n
-section_category = kw.get( \'transaction_section_category\'\n
- , None\n
- )\n
-if not section_category:\n
- section_category = kw.get( \'section_category\'\n
- , pref.getPreferredAccountingTransactionSectionCategory()\n
- )\n
-if section_category:\n
- params[\'transaction_section_category\'] = section_category\n
-\n
-###\n
-# Get omit parameters\n
-if kw.get(\'omit_input\') : params[\'omit_input\'] = 1\n
-if kw.get(\'omit_output\'): params[\'omit_output\'] = 1\n
-\n
-###\n
-# Get payment and mirror related parameters\n
-MARKER = []\n
-no_payment_uid = MARKER\n
-no_mirror_section_uid = MARKER\n
-payment_uid = MARKER\n
-mirror_section_uid = MARKER\n
-if selection_params != None:\n
- no_payment_uid = selection_params.get(\'no_payment_uid\', MARKER)\n
- no_mirror_section_uid = selection_params.get(\'no_mirror_section_uid\', MARKER)\n
- payment_uid = selection_params.get(\'payment_uid\', MARKER)\n
- mirror_section_uid = selection_params.get(\'mirror_section_uid\', MARKER)\n
-if no_payment_uid is not MARKER: params[\'no_payment_uid\'] = 1\n
-if no_mirror_section_uid is not MARKER: params[\'no_mirror_section_uid\'] = 1\n
-if payment_uid is not MARKER: params[\'payment_uid\'] = payment_uid\n
-if mirror_section_uid is not MARKER: params[\'mirror_section_uid\'] = mirror_section_uid\n
-\n
-###\n
-# Clean up date params.\n
-\n
-# Don\'t use the from_date parameter if from_date_summary is present\n
-if kw.get(\'from_date_summary\', 0) and params.has_key(\'from_date\'):\n
- del params[\'from_date\']\n
-\n
-# \'to_date\' exclude the use of \'from_date\' and \'at_date\'\n
-# In fact, \'to_date\' is handle by the SQL query as "at_date minus one day"\n
-if params.has_key(\'to_date\'):\n
- if params.has_key(\'at_date\'): del params[\'at_date\']\n
- if params.has_key(\'from_date\'): del params[\'from_date\']\n
-\n
-###\n
-# Include the previous balance\n
-if params.has_key(\'from_date\') and params.has_key(\'at_date\'):\n
- del params[\'from_date\']\n
-\n
-###\n
-# Call the query with selected parameters\n
-# context.log("SQL with %s \\n" % params, context.Account_zGetTotalQuantity(src__=1, **params))\n
-result = context.Account_zGetTotalQuantity(**params)\n
-row = result[0]\n
-\n
-###\n
-# Round the result to avoid float bad precision\n
-# TODO: use currency precision\n
-return context.Base_getRoundValue(row.total_price or 0.0, precision)\n
-</string> </value>
- </item>
- <item>
- <key> <string>_code</string> </key>
- <value>
- <none/>
- </value>
- </item>
- <item>
- <key> <string>_params</string> </key>
- <value> <string>selection, selection_name, **kw</string> </value>
- </item>
- <item>
- <key> <string>_proxy_roles</string> </key>
- <value>
- <tuple>
- <string>Manager</string>
- </tuple>
- </value>
- </item>
- <item>
- <key> <string>errors</string> </key>
- <value>
- <tuple/>
- </value>
- </item>
- <item>
- <key> <string>func_code</string> </key>
- <value>
- <object>
- <klass>
- <global name="FuncCode" module="Shared.DC.Scripts.Signature"/>
- </klass>
- <tuple/>
- <state>
- <dictionary>
- <item>
- <key> <string>co_argcount</string> </key>
- <value> <int>2</int> </value>
- </item>
- <item>
- <key> <string>co_varnames</string> </key>
- <value>
- <tuple>
- <string>selection</string>
- <string>selection_name</string>
- <string>kw</string>
- <string>_getattr_</string>
- <string>context</string>
- <string>script</string>
- <string>params</string>
- <string>pref</string>
- <string>precision</string>
- <string>None</string>
- <string>selection_params</string>
- <string>_write_</string>
- <string>_getitem_</string>
- <string>KeyError</string>
- <string>AttributeError</string>
- <string>from_date</string>
- <string>at_date</string>
- <string>to_date</string>
- <string>simulation_state</string>
- <string>section_category</string>
- <string>MARKER</string>
- <string>no_payment_uid</string>
- <string>no_mirror_section_uid</string>
- <string>payment_uid</string>
- <string>mirror_section_uid</string>
- <string>_apply_</string>
- <string>result</string>
- <string>row</string>
- </tuple>
- </value>
- </item>
- </dictionary>
- </state>
- </object>
- </value>
- </item>
- <item>
- <key> <string>func_defaults</string> </key>
- <value>
- <none/>
- </value>
- </item>
- <item>
- <key> <string>id</string> </key>
- <value> <string>Account_statSourceBalance</string> </value>
- </item>
- <item>
- <key> <string>warnings</string> </key>
- <value>
- <tuple/>
- </value>
- </item>
- </dictionary>
- </pickle>
- </record>
-</ZopeData>
More information about the Erp5-report
mailing list