Add a unit test based on testWorklist to check SQL-cached worklists.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18123 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18122 20353a03-c40f-0410-a6d1-a30d3c3de9de

Stop to use "group by reference" without aggregate function. if reference column is not constant, result is indeterminate value.

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18121 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18120 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18119 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18118 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18117 20353a03-c40f-0410-a6d1-a30d3c3de9de

a "read" line, but this script was non interactive, so it might have side
effect to wait for input...



git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18114 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18113 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18112 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18111 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18110 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18109 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18107 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18106 20353a03-c40f-0410-a6d1-a30d3c3de9de

Add a key on aggregate_uid, simulation_state and date. This is used in LEFT JOINs done by Resource_zGetTrackingList.

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18105 20353a03-c40f-0410-a6d1-a30d3c3de9de

Remove DateTimeKeys as at the time erp5_core is installed (at site creation) there's any catalog created yet.

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18104 20353a03-c40f-0410-a6d1-a30d3c3de9de

   the employee is the destination of the social services
- change variable name base_amount_current_value_dict in base_amount_dict and
  use the share.
- use the cartesian product instead of lot of for loops. It's more efficient
  and more evolutive in the sense that it could handle new categories without
  modify the source code
- change the update of the base_participation to use the share in the
  base_amount_dict.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18102 20353a03-c40f-0410-a6d1-a30d3c3de9de

use reverse() anymore


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18101 20353a03-c40f-0410-a6d1-a30d3c3de9de

- rename base_amount_current_value_dict in base_amount_dict
- change this previous dict to stock values of all tax_category
- now, Pay Sheet Model Line could use only tax_category (without any slice)
- add a comment in PaySheetTransaction_getMovementList
- add uses of cartesian_product witch is more efficient and more evolutive
- enhance PaySheetTransaction_getYearToDateNetPay script (over_time is not take
into account in french payroll)
- add PaySheetTransaction_getYearToDateBaseSalary script
- add PaySheetTransaction_getYearToDateOvertimeAmount script
- rename PaySheetTransaction_getYearToDateOverTimeHours in
PaySheetTransaction_getYearToDateOvertimeHours.xml
- remove all reverse() : before this commit, there were some reverse() to have  the Matrixbox displayed with slice on the left column and the tax_category on
the head line. Now it's in the default order, and it's less confused.
- typo

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18100 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18098 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18097 20353a03-c40f-0410-a6d1-a30d3c3de9de

prevent "RuntimeError function attributes are not accessible from restricted code" that happens on Zope 2.7

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18096 20353a03-c40f-0410-a6d1-a30d3c3de9de

move PurchaseInvoiceTransaction_selectPackingListMovement and PurchaseInvoiceTransaction_selectInvoiceMovement from erp5_accounting to erp5_invoicing

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18095 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18092 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18091 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18089 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18087 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18085 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18083 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18082 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18081 20353a03-c40f-0410-a6d1-a30d3c3de9de

for them ...



git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18080 20353a03-c40f-0410-a6d1-a30d3c3de9de

Add possibility to define child category which are not Categories (ex: all people assigned to a project can access the project module).

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18079 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18078 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18076 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18074 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18073 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18071 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18070 20353a03-c40f-0410-a6d1-a30d3c3de9de