Add table name value when generating final query parameters to make possible to use bare column name after first half of parameter generation.
Update a user (update is not mandatory unless first half results have to be used).


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

  - it's its job to handle group-by-resource-by-default behaviour when another group-by is provided
  - move task of updating dictionnary from this method to caller, to make it easier to understand when reading caller


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

Moreover, it's not to this function to decide which group-by must be applied.


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

group_by_resource alone has a meaning, for example if nodes are explicitely selected (I was to get the total amount of that resource on [those nodes|that node]). It should not be prevented by code, because it leads to situation where providing just one grouping criterion causes no grouping to be done on final query, which causes in turn a SQL syntax error.


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

Add detected missing parameters.


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

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

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

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

Make _generateSQLKeywordDictFromKeywordDict more usable: provide default values and avoid poluting parameters with internal processing.


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

Move related key name generation from _generateKeywordDict to _generateSQLKeywordDictFromKeywordDict. This removes the need of the "table" parameter in the first method, so remove it aswell, and update caller.


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

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

Move simulation, omition, reserved simulation and reserved omition query generation from _generateKeywordDict to _generateSQLKeywordDictFromKeywordDict.


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

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

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

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

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

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

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

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

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

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

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

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

"total_quantity" and "inventory" are alias for the same calculation in inventory request. Always use "total_quantity" so that "inventory" can be removed in the future.


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

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

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

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

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

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

Typo error: do not call getInventoryList directly, but alias method with the correct simulation period

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

Keep compatibility: getInventory joined related keys with the catalog table instead of the stock table.


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

make sure that getTrackingList use nice group by by default, and make sure the date is well given to Resource_zGetTrackingList

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

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

- remove the use of Resource_zGetInventory in many places, replace
  it by calling getInventoryList
- get[*]Inventory now use getInventoryList
- get[*]InventoryStat now use getInventoryList
- getNextNegativeInventoryDate now use getInventoryList


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

Fix getCurrentInventoryState, getFutureInventoryState, getCurrentInventoryList, getFutureInventoryList, in order to have the same behaviour than getInventory.
getAvailableInventoryState and getAvailableInventoryList still need to be fixed.


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

The at_date parameter must be in both the where expression and
in pamaters given to the zsql methods.


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

Do not pass at_date to ZSQLQuery, because it passes an unformated date to the catalog, while the date is already handled by _generateSQLKeywordDict.


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

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

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

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