An error occurred fetching the project authors.
- 02 May, 2017 5 commits
-
-
Jérome Perrin authored
Performance is still not optimal, but should be better than before. At least it does not assume that movements will be in predicate table.
-
Jérome Perrin authored
variation_category is implemented
-
Jérome Perrin authored
-
Jérome Perrin authored
instead of implementing this logic in ZSQL's DTML
-
Jérome Perrin authored
jerome/erp5!6 rebased and in a big commit so that we can start using that SimulationTool: implement "linear" flow API Conflicts: product/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Resource_zGetInventoryList.xml testInventoryAPI: silent pyflakes warnings more interpolation implementation inventory_list interpolation flow: support at_date & to_date more and more interpolation API interpolation interpolation group_by_time_sequence_list testInventoryAPI: move inventory valuation methods in a dedicated test class This should not be in test inventory list. test: move Tracking API to a dedicated test module inventory api: dirty way of disabling cache if keys such as node_category are used. interpolation: security on SimulationTool_zGetInterpolationMethod
-
- 05 Apr, 2017 1 commit
-
-
Vincent Pelletier authored
-
- 03 Apr, 2017 1 commit
-
-
Vincent Pelletier authored
Also, do not use deprecated parameter name to pass a logical operator.
-
- 11 Oct, 2016 1 commit
-
-
Jérome Perrin authored
If we don't propagate movement_list_mode to catalog, this prevents catalog from raising an error about this unknown parameter.
-
- 29 Sep, 2016 1 commit
-
-
Jérome Perrin authored
Over the years, we included almost all possible default group by criterions for getMovementHistoryList, so that in essence, we do not group ... for example, we did 7814c521 . It would be better for performance and more logical to just not group by at all, getMovementHistoryList should just return the list of movements. This is still possible to use explicit group by parameters in getMovementHistoryList, for example grouping by [explanation_uid](https://lab.nexedi.com/nexedi/erp5/blob/c413d34b9d5db0beda2b9540d563529082855d91/product/ERP5/tests/testInventoryAPI.py#L2416) like we can do in [some accounting reports](https://lab.nexedi.com/nexedi/erp5/blob/c413d34b9d5db0beda2b9540d563529082855d91/bt5/erp5_accounting/SkinTemplateItem/portal_skins/erp5_accounting/AccountModule_getGeneralLedgerReportSectionList.py#L111). I don't have a proper benchmark, but on the instance where we discover the issue, a simple getMovementHistoryList yieliding 112301 results went from several minutes spent in state *Removing duplicates* (I killed the query after some time) to about 3 seconds. cc @vpelletier @jm @gabriel /reviewed-on nexedi/erp5!171
-
- 26 Sep, 2016 1 commit
-
-
Sebastien Robin authored
ProgrammingError could be raised for various raisons, while the code was assuming that the only raison was missing table. Improve by making sure the error is about missing table, if not, raise.
-
- 16 Sep, 2016 1 commit
-
-
Sebastien Robin authored
-
- 15 Sep, 2016 2 commits
-
-
Sebastien Robin authored
-
Sebastien Robin authored
Instead of only having possibility to check when inventory will be below a reference_quantity, allow to check when it will be higher.
-
- 15 Jul, 2016 1 commit
-
-
Vincent Pelletier authored
-
- 22 Jun, 2016 1 commit
-
-
Nicolas Wavrant authored
A new column ledger in the stock table and some related keys (stored in erp5_mysql_innodb_catalog) have also been created Adds tests for inventory queries based on ledger in testInventoryAPI
-
- 21 Apr, 2016 3 commits
-
-
Vincent Pelletier authored
Also, remove orginal _getOmitQuery which was dead code, and merge _buildOmitQuery into its only remaining caller. Also, factorise two pieces of code generating omit queries.
-
Vincent Pelletier authored
Also, simplify code a bit while reading it.
-
Vincent Pelletier authored
Fixes a bug when select_list is present in related_key_dict_passthrough but group_by_list is not. Also, reduce the number of code paths.
-
- 12 Jan, 2016 1 commit
-
-
Kazuhiko Shiozaki authored
-
- 07 Oct, 2015 2 commits
-
-
Kazuhiko Shiozaki authored
Now we have explicit ORDER BY in the outer query so that we no longer need to disable derived_merge optimizer. c.f. https://bugs.launchpad.net/maria/+bug/985828
-
Kazuhiko Shiozaki authored
Revert "Add auto_extend_select_list argument in buildSQLQuery() and use alias in group_by_expression and order_by_expression." Revert "Support group_by_list and order_by_list in WebSection_getDocumentValueList." Revert "Support order_by_list in Resource_zGetMovementHistoryList." No need to extend SQLCatalog parameter to support group_by_list and order_by_list in sub-queries.
-
- 04 Oct, 2015 1 commit
-
-
Kazuhiko Shiozaki authored
Now we have explicit ORDER BY in the outer query so that we no longer need to disable derived_merge optimizer. c.f. https://bugs.launchpad.net/maria/+bug/985828
-
- 10 Mar, 2015 2 commits
-
-
Sebastien Robin authored
-
Sebastien Robin authored
-
- 17 Feb, 2015 5 commits
-
-
Sebastien Robin authored
-
Sebastien Robin authored
-
Sebastien Robin authored
-
Sebastien Robin authored
So all newSimulation expected failures are removed. Make generateMovementListForStockOptimisation looking min_flow and max_delay on supply lines. Introduce a getNextAlertInventoryDate in addition to getNextNegativeInventoryDate. This allows to know when an inventory will be below a reference quantity. This is particularly helpful to know when an inventory is below the minimal admitted stock
-
Sebastien Robin authored
Like this we stop using Resource_zGetInventory which is less and less used. Indeed, it's better to only have Resource_zGetInventoryList and sometimes returns a list of a single line.
-
- 12 Dec, 2014 1 commit
-
-
Gabriel Monnerat authored
Avoid pass next_item_simulation_state to _generateSQLKeywordDict because it will always ignore this parameter and display messages in logs Add test to parameter with output=1 in getTrackingList method
-
- 16 Oct, 2014 1 commit
-
-
Julien Muchembled authored
-
- 01 May, 2014 1 commit
-
-
Kazuhiko Shiozaki authored
-
- 28 Apr, 2014 2 commits
-
-
Sebastien Robin authored
-
Sebastien Robin authored
All the logic was inside Person_getAvailableTimeMovementList. Algorithm was old and hard to understand. Move this algorithm to simulation tool, and rewrite it using the interval library for having less code to maintain and easier understanding
-
- 04 Nov, 2013 1 commit
-
-
Aurel authored
some script pass group_by=('function_uid',) instead of group_by_function=1, resulting behaviour in the end must be the same
-
- 13 Sep, 2013 3 commits
-
-
Tatuya Kamada authored
This is not a new feature, this behavior is compatible with the old caching implementation that was using inventory_stock table. In other words, this brings backs the backward compatibility in inventory caching. (This commit fixes the incomplete tests that was reverted just before.)
-
Tatuya Kamada authored
Needs more tests. This reverts commit 74db4d39.
-
Tatuya Kamada authored
This is not a new feature, this behavior is compatible with the old caching implementation that was using inventory_stock table. In other words, this brings backs the backword compatibility in invetory caching.
-
- 09 Apr, 2013 1 commit
-
-
Jérome Perrin authored
We were joining catalog for section, node and resource, mainly in order to expose _title and _relative_url in brains. We just need to select the corresponding uids and let brains do another catalog search to get the object when accessed. Note that erp5_banking_core is not updated
-
- 04 Mar, 2013 1 commit
-
-
Vincent Pelletier authored
-