Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Aggregate Storage for Product and Warehouse #662

Closed
metas-mk opened this issue Nov 7, 2017 · 1 comment
Closed

Aggregate Storage for Product and Warehouse #662

metas-mk opened this issue Nov 7, 2017 · 1 comment
Assignees
@metas-dh
Labels
branch:master branch:release priority:high type:enhancement

Comments

@metas-mk
Copy link
Member

metas-mk commented Nov 7, 2017

Is this a bug or feature request?

Feature Request

What is the current behavior?

Currently, we have Storages in HU_Storage.

Which are the steps to reproduce?

None

What is the expected or desired behavior?

For a faster retrieval of Storage Info we need an aggregation of storages per Product and Warehouse.
teosarca added a commit to metasfresh/metasfresh that referenced this issue Nov 8, 2017
@teosarca
CandidateRepositoryRetrieval.retrieveAvailableStock prototyping
22ebac6 
metasfresh/metasfresh-webui-api-legacy#662
teosarca added a commit to metasfresh/metasfresh that referenced this issue Nov 8, 2017
@teosarca
ImmutableAttributeSet.copyOf
36fb052 
metasfresh/metasfresh-webui-api-legacy#662
metasfresh/metasfresh-webui-api-legacy#663
teosarca added a commit to metasfresh/metasfresh that referenced this issue Nov 8, 2017
@teosarca
AvailableStockResult: use ImmutableAttributeSet
18c5462 
metasfresh/metasfresh-webui-api-legacy#662
metasfresh/metasfresh-webui-api-legacy#663
teosarca added a commit to metasfresh/metasfresh that referenced this issue Nov 8, 2017
@teosarca
IAttributeSetInstanceBL.createAttributeSetInstanceFromProductAndAttri…
d547b4d 
…buteSet

metasfresh/metasfresh-webui-api-legacy#662
metasfresh/metasfresh-webui-api-legacy#663
teosarca added a commit to metasfresh/metasfresh that referenced this issue Nov 8, 2017
@teosarca
rename MaterialDescriptorQuery to MaterialQuery
b1f8627 
metasfresh/metasfresh-webui-api-legacy#662
teosarca added a commit that referenced this issue Nov 8, 2017
@teosarca
rename MaterialDescriptorQuery to MaterialQuery
89555aa 
#662
teosarca added a commit to metasfresh/metasfresh that referenced this issue Nov 8, 2017
@teosarca
rename to IAttributeSetInstanceBL.createASIFromAttributeSet
14e0160 
metasfresh/metasfresh-webui-api-legacy#662
teosarca added a commit that referenced this issue Nov 8, 2017
@teosarca
rename to IAttributeSetInstanceBL.createASIFromAttributeSet
80f72ea 
#662
teosarca added a commit to metasfresh/metasfresh that referenced this issue Nov 8, 2017
@teosarca
rename to IAttributeSetInstanceBL.createASIFromAttributeSet
44719be 
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 8, 2017
@metas-ts
document some stuff i had forgotten and needed to figure out again
49ce1c1 
metasfresh/metasfresh-webui-api-legacy#662
@teosarca teosarca mentioned this issue Nov 13, 2017
Closed
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 14, 2017
@metas-ts
start to separate "client" code from "service" code
bb87b22 
goal of that: not have business and dimension within the metasfresh-material-dispo "core" service
also experiment with using version version ranges again (this time deplaring the metasfresh-version property in every single pom.xml)

Aggregate Storage for Product and Warehouse metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit that referenced this issue Nov 14, 2017
@metas-ts
start to separate "client" code from "service" code
54d8d63 
goal of that: not have business and dimension within the metasfresh-material-dispo "core" service
also experiment with using version version ranges again (this time deplaring the metasfresh-version property in every single pom.xml)

Aggregate Storage for Product and Warehouse #662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 14, 2017
@metas-ts
minor/unrelated pom.xml fixed
0ecd98f 
Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 14, 2017
@metas-ts
supply "constant" version=10.0.0 to artifact, hopefully fixing build …
53ffad6 
…issue

also use version range more consistently/aggressively
also cleanup legacy "dispo" folder

Aggregate Storage for Product and Warehouse metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 14, 2017
@metas-ts
specify explicit maven versions plugin version to use
d908bd6 
Aggregate Storage for Product and Warehouse metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 14, 2017
@metas-ts
hope to solve the build issue now in the Jenkinsfile
790130c 
also minor in pom.xml

Aggregate Storage for Product and Warehouse metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 14, 2017
@metas-ts
build fix
abb4e7a 
Aggregate Storage for Product and Warehouse metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 14, 2017
@metas-ts
SQL syntax fix
47879f1 
Aggregate Storage for Product and Warehouse metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 14, 2017
@metas-ts
use range [1,10.0.0] instead of 10.0.0 in further pomx.xml files
f032beb 
Aggregate Storage for Product and Warehouse metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 15, 2017
@metas-ts
allow up to insert "system" M_AttributeValues
c9d80d3 
Aggregate Storage for Product and Warehouse metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 17, 2017
@metas-ts
work in progress
0e80167 
* move DispoTestUtils to test
* extend MaterialQuery for multiple storage attributes keys
* move code about avaialable stock out of CandidateRepositoryRetrieval and candidateRepositoryRetrievalTests
* introduce StockRepository and related classes, to be queried about avaiable stock
* minor changes in IDimensionspecDAO
* rename method in ProductDescriptor to be a bit less confusing
* mere adaptive changes (to refactrings etc) in AvailableStockService, AvailableStockServiceTests, TestHelper, DemandCandiateHandler, StockUpCandiateHandler, CandidateChangeHandlerTests, DemandCandiateCangeHandlerTest, MaterialDispoEventListenerFacadeTests, SupplyProposalEvaluatorTests, DistributionPlanEventHandlerTests, ForecastEventHandlerTest, ProductionPlanEventHandlerTests, ShipmentScheduleEventHandlerTests, MaterialDescriptorTest, ProductDescriptorTest
* change MD_Candidate_Latest_v to MD_Candidate_Stock_v and also add model classes

Aggregate Storage for Product and Warehouse metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 17, 2017
@metas-ts
add metasfresh version range to 3 more pom.xmls
d33c740 
Aggregate Storage for Product and Warehouse metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 17, 2017
@metas-ts
* addStringNotLikeFilter to ICompositeQueryFilter
8204f0f 
* prevent the stupid mistake of adding a CompositeQueryFilter to itself 😊
* remove at least some gibberish from StringLikeFilter's toString method
* solve a minor bug in InArrayQueryFilter's toString method
* open NotQueryFilter for testing
* extend CompositeQueryFilterAssert and add QueryFilterAssert and QueryFilterTestUtil for better query filter testing
* minor change in ImmutableAttributeSet
* start implementing the trl between client and commons in AvailableStockService
* finish implementation in StockRepository incl search for result with "any-other-attribute"

Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 17, 2017
@metas-ts
implement Q&D method to get AttributeSet from StorageAtributesKey string
7dc9e21 
also add another assert

Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit that referenced this issue Nov 17, 2017
@metas-ts
small cleanup within a test
c8c0fbb 
Aggregate Storage for Product and Warehouse
#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 20, 2017
@metas-ts
remove unused dimensionSpecId from query
6f60b60 
Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 20, 2017
@metas-ts
solve unit test errors
8012525 
Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 20, 2017
@metas-ts
Add SQL for sysconfigs and specical storage attribute keys
8ae5040 
also rename "unspecified" to "all" and adapt AvailableStockService to its current use

Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit that referenced this issue Nov 20, 2017
@metas-ts
set attributes from query result
80d4016 
Aggregate Storage for Product and Warehouse
#662
metas-ts added a commit that referenced this issue Nov 20, 2017
@metas-ts
solve minor problems during devtest
d3fccce 
Aggregate Storage for Product and Warehouse
#662
teosarca added a commit that referenced this issue Nov 20, 2017
@teosarca
LookupValuesList: allow lookup values with same ID
0c6d791 
#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 20, 2017
@metas-ts
solve bug and add sql for expired&damaged attribute set
7f012a8 
Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh-dist-legacy that referenced this issue Nov 20, 2017
@metas-ts
solve wrong artifact name for material-dispo-service; minor cleanups
727975a 
Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 20, 2017
@metas-ts
move logic into AvailableStockResult
52582a1 
Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit that referenced this issue Nov 20, 2017
@metas-ts
move logic into AvailableStockResult and change the caption text
512a63c 
Aggregate Storage for Product and Warehouse
#662
This was referenced Nov 21, 2017
Merged
Merged
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 21, 2017
@metas-ts
minor changes during manual review
352f285 
Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 21, 2017
@metas-ts
address some of the static tool feedback
7cad856 
Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit that referenced this issue Nov 21, 2017
@metas-ts
address some of the static tool feedback
98ead10 
Aggregate Storage for Product and Warehouse
#662
metas-ts added a commit that referenced this issue Nov 21, 2017
@metas-ts
Merge pull request #691 from metasfresh/gh662-webui
379e5a6 
Aggregate Storage for Product and Warehouse #662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 21, 2017
@metas-ts
allow switching of the whole available stock querying
7ac0125 
Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit that referenced this issue Nov 21, 2017
@metas-ts
allow switching of the whole available stock querying
bbeb22a 
Aggregate Storage for Product and Warehouse
#662
teosarca added a commit to metasfresh/metasfresh that referenced this issue Nov 21, 2017
@teosarca
fix pom.xml
d08768f 
metasfresh/metasfresh-webui-api-legacy#662
metasfresh/metasfresh-webui-api-legacy#664
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 21, 2017
@metas-ts
solve bug in StockRepository where multiple MD_Candiates caused an error
dea807a 
also minor refactoring

Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 21, 2017
@metas-ts
solve bug in view MD_Candidate_Stock_v; also..
512dfdf 
* make sure we store '' instead of NULL or '<ALL_STORAGE_ATTRIBUTES_KEYS>' in MD_Candidates
* rename CandidateRepositoryCommands to CandidateRepositoryWriteService

Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 21, 2017
@metas-ts
solve bug of IQuery filter not containing the parentID...
e778400 
...even if the CandidatesQuery had one
Aggregate Storage for Product and Warehouse
metasfresh/metasfresh-webui-api-legacy#662
metas-ts added a commit to metasfresh/metasfresh that referenced this issue Nov 26, 2017
@metas-ts
update ReleaseNotes.md
bfa6bcb 
[#1293](metasfresh/metasfresh-webui-frontend-legacy#1293)
Cannot scroll down in a filter with lots of parameters
[#669](metasfresh/metasfresh-webui-api-legacy#669)
CU-TU's built name and description is wrong
[#1366](metasfresh/metasfresh-webui-frontend-legacy#1366)
Error in Quickentry dropdown List
[#1345](metasfresh/metasfresh-webui-frontend-legacy#1345)
Invalid date was used on dateTime tablecell
[#701](metasfresh/metasfresh-webui-api-legacy#701)
webui server is losing session context
[#683](metasfresh/metasfresh-webui-api-legacy#683)
Source HU Actions shall only be "Drop Source HU"
[#1358](metasfresh/metasfresh-webui-frontend-legacy#1358)
View field editor: number field is behaving weird when using keyboard
[#2945](#2945) Adjustment
in pain001
[#3056](#3056) purchase
candidates: implement locking mechanism
[#694](metasfresh/metasfresh-webui-api-legacy#694)
purchase view: set modal title as process caption
[#700](metasfresh/metasfresh-webui-api-legacy#700)
Filter error after static filter set
[#3057](#3057) display
order, forecast or shipmentschedule in material dispo main window
[#3055](#3055) purchase
candidates: notify user when the purchase order was generated
[#697](metasfresh/metasfresh-webui-api-legacy#697)
New BPartner is not available as SubProducerBPartner in MaterialReceipt
BPartner
[#3034](#3034) solve
material dispo regressions
[#671](metasfresh/metasfresh-webui-api-legacy#671)
T_WEBUI_ViewSelection[Line] shall be truncated and not deleted
[#695](metasfresh/metasfresh-webui-api-legacy#695)
picking terminal: implement dynamic picking slot allocation/release
[#3043](#3043) A contract
shall not be created when a completing a quotation
[#1380](metasfresh/metasfresh-webui-frontend-legacy#1380)
Shortcut for new document
[#2944](#2944) Allow more
than 1 PostFinanceUserNo per Account
[#3023](#3023) ad_org is
ignored when doing quick order entry
[#1363](metasfresh/metasfresh-webui-frontend-legacy#1363)
jenkins: run npm test on each build
[#3010](#3010) Inherit
c_order_id and orderline_id from flatrate term to invoice candidate
[#2958](#2958) 2nd
Discount Break is ignored
[#2997](#2997) Partner
Import: Support importing the Org via value
[#689](metasfresh/metasfresh-webui-api-legacy#689)
Picking processed compress to top-level HU
[#692](metasfresh/metasfresh-webui-api-legacy#692)
Error in Quickentry Sales Order when canceling input
[#679](metasfresh/metasfresh-webui-api-legacy#679) HU
taken out in Picking Tray Clearing still displayed in the Picking Slot
in Picking Terminal
[#687](metasfresh/metasfresh-webui-api-legacy#687)
picking terminal: show BPartner instead of DeliveryDate
[#693](metasfresh/metasfresh-webui-api-legacy#693)
Error in create purchase orders from Sales order line
[#662](metasfresh/metasfresh-webui-api-legacy#662)
Aggregate Storage for Product and Warehouse
[#1351](metasfresh/metasfresh-webui-frontend-legacy#1351)
wrong backend api call for grid view editing

me-45
@metas-dh metas-dh self-assigned this Nov 27, 2017
@metas-dh
Copy link
Member

Results of IT1
tested in mf15

  • SysConfig QueryAvailableStock=Y, with QueryStockAttributesKeys "all": "all" displayed for attributes, when selecting product in quick entry (0 Stk bc new db): OK
  • SysConfig QueryAvailableStock=Y, with QueryStockAttributesKeys Bio": "Bio" displayed for attributes, when selecting product in quick entry (0 Stk bc new db): OK
  • SysConfig QueryAvailableStock=N: nothing displayed for attributes, when selecting product in quick entry: OK

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@metas-dh metas-dh

Labels
branch:master branch:release priority:high type:enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@teosarca @metas-ts @metas-mk @metas-dh