<?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>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>resource_uid</string> </key>
                                <value>
                                  <dictionary>
                                    <item>
                                        <key> <string>type</string> </key>
                                        <value> <string>list</string> </value>
                                    </item>
                                  </dictionary>
                                </value>
                            </item>
                            <item>
                                <key> <string>section_category</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</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>selection_domain</string>
                            <string>selection_report</string>
                            <string>node_uid</string>
                            <string>where_expression</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>simulation_state</string>
                            <string>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>_col</string> </key>
            <value>
              <tuple/>
            </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>selection_domain\r\n
selection_report\r\n
node_uid\r\n
where_expression\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
simulation_state:list\r\n
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_zGetAccountingTransactionList</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[

<dtml-call "log(\'Account_zGetAccountingTransactionList is deprecated, use Inventory API instead\')>\n
<dtml-if node_uid>\n
SELECT\n
  DISTINCT transaction.uid, transaction.path,\n
  transaction_line.path as current_transaction_line_path,\n
  transaction.title as transaction_title,\n
  mirror_section.title AS third_party,\n
  IF(stock.total_price > 0, stock.total_price, 0.0) AS debit,\n
  IF(stock.total_price < 0, - stock.total_price, 0.0) AS credit,\n
  stock.date AS date,\n
  IF(stock.section_uid = delivery.source_section_uid,\n
       transaction.source_reference,\n
       transaction.destination_reference) AS specific_reference,\n
  stock.total_price AS balance,\n
  stock.payment_uid AS payment_uid\n
FROM\n
  catalog,\n
  catalog  AS transaction_line,\n
  catalog  AS transaction,\n
  delivery,\n
  catalog  AS section_c,\n
  catalog  AS section_bc,\n
  category AS section_membership,\n
  catalog  AS section,\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
      ON mirror_section.uid = stock.mirror_section_uid\n
        AND stock.node_uid = <dtml-var node_uid>\n
\n
WHERE stock.node_uid = <dtml-var node_uid>\n
  AND delivery.uid = transaction.uid\n
  AND transaction_line.uid = stock.uid\n
  AND transaction_line.portal_type <> \'Simulation Movement\'\n
  AND transaction_line.parent_uid = transaction.uid\n
  AND catalog.uid = stock.section_uid\n
<dtml-if resource_uid>\n
  AND (\n
  <dtml-in resource_uid>\n
    stock.resource_uid = <dtml-sqlvar sequence-item type="int">\n
          <dtml-unless sequence-end> OR </dtml-unless>\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\n
</dtml-if>\n
<dtml-if omit_output>\n
  AND stock.total_price > 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 simulation_state>\n
  AND (\n
  <dtml-in simulation_state>\n
    transaction.simulation_state = <dtml-sqlvar sequence-item type="string">\n
            <dtml-if sequence-end><dtml-else> OR </dtml-if>\n
  </dtml-in>\n
  )\n
<dtml-else>\n
  AND transaction.simulation_state != \'cancelled\'\n
  AND transaction.simulation_state != \'draft\' \n
</dtml-if>\n
  AND section.uid = stock.section_uid\n
<dtml-if section_category>\n
  AND section_c.relative_url = <dtml-sqlvar\n
          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 where_expression>\n
  AND catalog.uid = category.uid\n
  AND <dtml-var where_expression>\n
</dtml-if>\n
<dtml-if selection_domain>\n
  AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_domain)">\n
</dtml-if>\n
<dtml-if selection_report>\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
</dtml-if>\n


]]></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[

<dtml-call "log(\'Account_zGetAccountingTransactionList is deprecated, use Inventory API instead\')>\n
<dtml-if node_uid>\n
SELECT\n
  DISTINCT transaction.uid, transaction.path,\n
  transaction_line.path as current_transaction_line_path,\n
  transaction.title as transaction_title,\n
  mirror_section.title AS third_party,\n
  IF(stock.total_price > 0, stock.total_price, 0.0) AS debit,\n
  IF(stock.total_price < 0, - stock.total_price, 0.0) AS credit,\n
  stock.date AS date,\n
  IF(stock.section_uid = delivery.source_section_uid,\n
       transaction.source_reference,\n
       transaction.destination_reference) AS specific_reference,\n
  stock.total_price AS balance,\n
  stock.payment_uid AS payment_uid\n
FROM\n
  catalog,\n
  catalog  AS transaction_line,\n
  catalog  AS transaction,\n
  delivery,\n
  catalog  AS section_c,\n
  catalog  AS section_bc,\n
  category AS section_membership,\n
  catalog  AS section,\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
      ON mirror_section.uid = stock.mirror_section_uid\n
        AND stock.node_uid = <dtml-var node_uid>\n
\n
WHERE stock.node_uid = <dtml-var node_uid>\n
  AND delivery.uid = transaction.uid\n
  AND transaction_line.uid = stock.uid\n
  AND transaction_line.portal_type <> \'Simulation Movement\'\n
  AND transaction_line.parent_uid = transaction.uid\n
  AND catalog.uid = stock.section_uid\n
<dtml-if resource_uid>\n
  AND (\n
  <dtml-in resource_uid>\n
    stock.resource_uid = <dtml-sqlvar sequence-item type="int">\n
          <dtml-unless sequence-end> OR </dtml-unless>\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\n
</dtml-if>\n
<dtml-if omit_output>\n
  AND stock.total_price > 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 simulation_state>\n
  AND (\n
  <dtml-in simulation_state>\n
    transaction.simulation_state = <dtml-sqlvar sequence-item type="string">\n
            <dtml-if sequence-end><dtml-else> OR </dtml-if>\n
  </dtml-in>\n
  )\n
<dtml-else>\n
  AND transaction.simulation_state != \'cancelled\'\n
  AND transaction.simulation_state != \'draft\' \n
</dtml-if>\n
  AND section.uid = stock.section_uid\n
<dtml-if section_category>\n
  AND section_c.relative_url = <dtml-sqlvar\n
          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 where_expression>\n
  AND catalog.uid = category.uid\n
  AND <dtml-var where_expression>\n
</dtml-if>\n
<dtml-if selection_domain>\n
  AND <dtml-var "portal_selections.buildSQLExpressionFromDomainSelection(selection_domain)">\n
</dtml-if>\n
<dtml-if selection_report>\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
</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>
