Make use of new CMFCategory feature to scan fewer predicates: originaly, CMFCategory buildSQLSelector returned more predicates as search criterions (categories) were added, because it was just OR-ing those conditions. Using the new version should improve performances on systems using many predicates.


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

Improve CategoryTool buildSQLSelector result pertinence: when searching for documents matching categories, use a left join instead of a succession of "OR".
This is implemented in a new method, with the possibility to fallback to original behaviour.
Original method now just calls the new one in compatibility mode.


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

  Do not generate a from_expression if no from_expression was passed by parameter.
  Fix a swap between table and alias in new code.


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

* Fix WebSection_viewInlinePageRenderer. Prevent to get a non document object. Thank you for Thomas Nouret.

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

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

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

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

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

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

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

Provide a way to replace table alias ("AS" inclued) by an arbitrary string. Given value must be a dictionary, with impacted table as a key and the arbitrary string as a value.
This allows, for example, to generate queries with LEFT JOINs.


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

 - add check, that well transformation is chosen for resource, removed start date existence - it is tested on order, and acquisition do not works for chcker (???)

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

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

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

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

- associate Production Order portal type with ProductionOrder Property Sheet to enforce minimal constraints

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

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

 - split cases depended and not depended on aparrel


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

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

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

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

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

- associate transformation_interaction_workflow with Production Order Line to set transformation while changing resource on line: if only one, not invalidated Transformation exists, set it, if no Transformations are for this resource, or resource is unset, set specialise on order line to None

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

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

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

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

- add listfield, which is able represent list of possible transformations to field library

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

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

- change title of resource field

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

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

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

- title is no more editable in listboxes

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

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

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

- added reference to form

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

- let system decide which column is sortable or searchable

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

- the text "Order page 1 of 1" is in the correct cell
- the "section" is centered horizontally

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

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

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

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