2022-01-10 Pricing Flow - Revision history

Sven the Barbarian at 03:25, 5 April 2023

2023-04-05T03:25:55Z

Sven the Barbarian at 02:16, 18 January 2022

2022-01-18T02:16:09Z

Show changes

Sven the Barbarian at 15:18, 16 January 2022

2022-01-16T15:18:52Z

← Older revision		Revision as of 15:18, 16 January 2022
Line 1:		Line 1:
	[[Service Stack - Products]]		[[Service Stack - Products]]

	= ~~Filtered List of~~ Sell Offers =		= Filtering Sell Offers by price (complexFilter logical) =

	* eg: from Browse Catalog		* Final result expected is a list of sellOfferIds
			* Original request is sent to sellOffer complexFilter service which uses SellOfferManager service to process Logicals
	~~== SearchResult: sellOffer ==~~

	* Final result expected is a list of sellOfferIds ~~and their pricing (eg min or max), along with any other fields wanted~~
	* Original request is sent to sellOffer ~~Search Result~~ service which uses SellOfferManager service to process Logicals ~~and FindData~~
	* Request might originate higher up, eg Product/VariantProduct level, for pricing the sellOffer level is the important start point		* Request might originate higher up, eg Product/VariantProduct level, for pricing the sellOffer level is the important start point
	* sellOffer searchType / sellOffer filterType		* sellOffer searchType / sellOffer filterType
	* logical/findData types can be maxPrice/minPrice

	== Logical: SellOfferManager - sellOffer - maxPrice / minPrice ==		== Logical: SellOfferManager - sellOffer - maxPrice / minPrice ==
Line 125:		Line 120:

	* finds all aggregatedSellOfferPrices logicals that match the received sellOffer's sorted prices sellOfferOrderPriceSortedRequest		* finds all aggregatedSellOfferPrices logicals that match the received sellOffer's sorted prices sellOfferOrderPriceSortedRequest
	* for each logical found find this sellOffer's orderPriceId from SortResult service ~~that matches~~ the ~~requested~~ aggregation		* for each logical found find this sellOffer's aggregated orderPriceId from SortResult service > FindAggregatedValue, matching the logical's aggregation
	* check any sellOffer AwaitingMultipleSteps remain for aggregatedSellOfferPrices logical, if not complete it		* check any sellOffer AwaitingMultipleSteps remain for aggregatedSellOfferPrices logical, if not complete it
	* original ~~maxPricePerSellOffer~~ / ~~minPricePerSellOffer logical created an awaiting step waiting aggregatedSellOfferPrices~~ logical ~~that triggers CompleteLogicalSortedRequest~~		* completed aggregatedSellOfferPrices logical will trigger CompleteLogicalSortedRequest for original maxPrice / minPrice logical

	== SellOfferManager - CompleteLogicalSortedRequest ==		== SellOfferManager - CompleteLogicalSortedRequest ==

	* performs ~~maxPricePerSellOffer~~ / ~~minPricePerSellOffer~~ logical's comparison and completes that logical		* performs maxPrice / minPrice logical's comparison on the per sellOffer aggregated price, and completes that logical
			* also works for orderPrice type maxPricePerSellOffer / minPricePerSellOffer logicals

			= FindData for Sell Offer aggregated price =

			* can be part of a sellOffer searchResult
			* optionally has a complexFilter that filters by an aggregated price, not required
			* once we have the list of sellOfferIds returned by the complexFilter we initiate FindData to find the aggregated price
			* Final result expected is a list of sellOfferIds, their aggregated pricing (eg min or max), along with any other fields wanted
			* can be either sortResult or searchResult
			* Original request is sent to sellOffer Search Result service which uses SellOfferManager service to process Logicals and FindData
			* Request might originate higher up, eg Product/VariantProduct level, for pricing the sellOffer level is the important start point
			* sellOffer searchType / sellOffer filterType

	== ~~aggregatedSellOfferPrices logical complete~~ ==		== complexFilter finishes first ==

			* then passes
	* completed aggregatedSellOfferPrices logical will pass back to the aggregatedOrderPriceSortedRequest SearchResult initiated in "SellOfferManager - orderPrice - maxPricePerSellOffer / minPricePerSellOffer" logical		* completed aggregatedSellOfferPrices logical will pass back to the aggregatedOrderPriceSortedRequest SearchResult initiated in "SellOfferManager - orderPrice - maxPricePerSellOffer / minPricePerSellOffer" logical
	* SearchResult triggers FindData field "price"		* SearchResult triggers FindData field "price"

Sven the Barbarian at 13:24, 16 January 2022

2022-01-16T13:24:05Z

← Older revision		Revision as of 13:24, 16 January 2022
Line 56:		Line 56:
	* saves each sellOfferQuantityLocationIdCombinations request into AwaitingMultipleStep for the original aggregatedSellOfferPrices logical		* saves each sellOfferQuantityLocationIdCombinations request into AwaitingMultipleStep for the original aggregatedSellOfferPrices logical
	* sends sortResult request to SellOfferManager sortResult service		* sends sortResult request to SellOfferManager sortResult service
	* once the per sellOffer orderPrice sortResult completes triggers ~~AggregateOneSellOfferPrices~~ for each (set callingFlow = this service's ~~AggregateOneSellOfferPrices~~)		* once the per sellOffer orderPrice sortResult completes triggers AggregateOneSellOffersPrices for each (set callingFlow = this service's AggregateOneSellOffersPrices)

	== Logical: SellOfferManager - orderPrice - sellOfferQuantityLocationIdCombinations ==		== Logical: SellOfferManager - orderPrice - sellOfferQuantityLocationIdCombinations ==

Sven the Barbarian at 13:20, 16 January 2022

2022-01-16T13:20:35Z

← Older revision		Revision as of 13:20, 16 January 2022
Line 71:		Line 71:
	* this will result in multiple orderPriceIds being created/checked exist for one logicalResultMain		* this will result in multiple orderPriceIds being created/checked exist for one logicalResultMain
	* complete each sellOfferQuantityLocationIdCombinations logicalResultMain		* complete each sellOfferQuantityLocationIdCombinations logicalResultMain
	* for each sellOfferQuantityLocationIdCombinations logicalResultMain found, the logical complete message will trigger FindData for orderPrice - "price" field (original request created in createPerSellOfferSortedPriceRequests)		* for each sellOfferQuantityLocationIdCombinations logicalResultMain found, the logical complete message will finish the complexFilter and in searchResult will trigger FindData for orderPrice > "price" field (original request created in createPerSellOfferSortedPriceRequests)

	== FindData: SellOfferManager - orderPrice - price ==		== FindData: SellOfferManager - orderPrice - price ==
Line 77:		Line 77:
	* orderPrice record should always exist when entering here, eg created by CreateOrderPriceCombinations		* orderPrice record should always exist when entering here, eg created by CreateOrderPriceCombinations
	* finds the sellOffer subtotal for the orderPrice (not delivery/payment method costs yet) and saves into orderPrice record		* finds the sellOffer subtotal for the orderPrice (not delivery/payment method costs yet) and saves into orderPrice record
	* passes on to a ~~sorted searchResult~~ request for sellOfferPlanDeliveryMethodLink with fixed dataIds being a list of deliveryMethodLinkIds (no complexFilter), sorted by price (minDeliveryPrice)		* passes on to a sortResult request for sellOfferPlanDeliveryMethodLink with fixed dataIds being a list of deliveryMethodLinkIds (no complexFilter), sorted by price (minDeliveryPrice)
	* require minimum DeliveryPrice because there might be multiple locationIds found and we want to use the lowest priced one		* require minimum DeliveryPrice because there might be multiple locationIds found and we want to use the lowest priced one
	* searchResult requiredData is "minDeliveryPrice", which is required for the sorting		* searchResult requiredData is "minDeliveryPrice", which is required for the sorting
	* once we have the sorted results we actually want the maximum of the (minDeliveryPrice) results, because there might be multiple deliveryMethodLinkIds found in the given sellOfferQuantities, and we want to return the highest priced one		* once we have the sorted results we actually want the maximum of the (minDeliveryPrice) results, because there might be multiple deliveryMethodLinkIds found in the given sellOfferQuantities, and we want to return the highest priced one, do this by saving into createFindDataSortedRequest
	* once sellOfferPlanDeliveryMethodLink sorted ~~searchResult~~ completes ~~triggers ProcessFindDataSortedRequest~~ (set callingFlow = this service's ProcessFindDataSortedRequest)		* once sellOfferPlanDeliveryMethodLink sortResult is complete it triggers ProcessFindDataSortedRequest (set callingFlow = this service's ProcessFindDataSortedRequest)

			== FindData: SellOfferPlan - sellOfferPlanDeliveryMethodLink - minDeliveryPrice ==

			* will find the lowest delivery price for one sellOfferPlanDeliveryMethodLink
			* passes on to sortResult type deliveryMethodRateTable sorted by rate
			* when deliveryMethodRateTable sortResult complete will trigger ProcessFindDataSortedRequest which finds the minimum rate and completes the minDeliveryPrice logical (set callingFlow = this service's ProcessFindDataSortedRequest)

			== Logical: Delivery Method Rate Table - deliveryMethodRateTable - activeSellOfferPlanDeliveryMethodLinkId ==

			== Logical: Delivery Method Rate Table - deliveryMethodRateTable - deliverToLocationId ==

			== FindData: Delivery Method Rate Table - deliveryMethodRateTable - rate ==

			== ProcessFindDataSortedRequest: SellOfferPlan - ProcessFindDataSortedRequest ==

			* completes the minDeliveryPrice findData by finding the lowest rate
			* triggers SellOfferManager's awaiting findData for fieldname "price" in it's ProcessFindDataSortedRequest function, which will find the maximum rate from all deliveryMethodLinkIds sent

	== ProcessFindDataSortedRequest: SellOfferManager - orderPrice - price - sellOfferPlanDeliveryMethodLink ==		== ProcessFindDataSortedRequest: SellOfferManager - orderPrice - price - sellOfferPlanDeliveryMethodLink ==

	* saves into orderPrice record: deliveryPrice and sellOfferPlanDeliveryMethodLinkId		* saves into orderPrice record: deliveryPrice and sellOfferPlanDeliveryMethodLinkId
	* passes on to a ~~sorted searchResult~~ request for sellOfferPlanUserPaymentMethodLink with fixed dataIds being a list of userPaymentMethodLinkIds (no complexFilter), sorted by price (paymentPrice)		* passes on to a sortResult request for sellOfferPlanUserPaymentMethodLink with fixed dataIds being a list of userPaymentMethodLinkIds (no complexFilter), sorted by price (paymentPrice)
	* searchResult requiredData is "paymentPrice", which is required for the sorting		* searchResult requiredData is "paymentPrice", which is required for the sorting
	* once we have the sorted results we ~~actually~~ want the maximum of the (paymentPrice) results, because there might be multiple userPaymentMethodLinkIds found in the given sellOfferQuantities, and we want to return the highest priced one		* once we have the sorted results we want the maximum of the (paymentPrice) results, because there might be multiple userPaymentMethodLinkIds found in the given sellOfferQuantities, and we want to return the highest priced one
	* once sellOfferPlanUserPaymentMethodLink sorted searchResult completes triggers ProcessFindDataSortedRequest (set callingFlow = this service's ProcessFindDataSortedRequest)		* once sellOfferPlanUserPaymentMethodLink sorted searchResult completes triggers ProcessFindDataSortedRequest (set callingFlow = this service's ProcessFindDataSortedRequest)

			== FindData: SellOfferPlan - sellOfferPlanUserPaymentMethodLink - paymentPrice ==

			* completes the paymentPrice findData for each userPaymentMethodLinkIds
			* triggers SellOfferManager's awaiting findData for fieldname "price" in it's ProcessFindDataSortedRequest function, which will find the maximum rate from all userPaymentMethodLinkIds sent

	== ProcessFindDataSortedRequest: SellOfferManager - orderPrice - price - sellOfferPlanUserPaymentMethodLink ==		== ProcessFindDataSortedRequest: SellOfferManager - orderPrice - price - sellOfferPlanUserPaymentMethodLink ==

Sven the Barbarian at 12:25, 16 January 2022

2022-01-16T12:25:40Z

← Older revision		Revision as of 12:25, 16 January 2022
Line 5:		Line 5:
	* eg: from Browse Catalog		* eg: from Browse Catalog

	== SearchResult: ~~orderPrice~~ ==		== SearchResult: sellOffer ==

	* Final result expected is a list of ~~orderPriceIds~~ and their pricing (eg min or max), along with any other fields wanted		* Final result expected is a list of sellOfferIds and their pricing (eg min or max), along with any other fields wanted
	* Original request is sent to ~~OrderPrice~~ Search Result service which uses SellOfferManager service to process Logicals and FindData		* Original request is sent to sellOffer Search Result service which uses SellOfferManager service to process Logicals and FindData
	* Request might originate higher up, eg ~~SellOffer/~~Product/VariantProduct level, for pricing the ~~OrderPrice~~ level is the important start point		* Request might originate higher up, eg Product/VariantProduct level, for pricing the sellOffer level is the important start point
	* ~~orderPrice~~ searchType / ~~orderPrice~~ filterType		* sellOffer searchType / sellOffer filterType
	* ~~orderPrice types can have fields maxPricePerSellOffer/minPricePerSellOffer~~		* logical/findData types can be maxPrice/minPrice
	* use translateIds to find matching sellOfferIds from orderPrice complexFilter
	* use searchResult/findData~~'s child id structure to copy aggregated price up from orderPrice level to sellOffer level~~
	* so entry point into pricing flow is begun by orderPrice level filter/requiredData
	* orderPrice level does not need to be sorted, can be ~~a standard searchResult, but sellOffer level could layer sorting on top of the orderPrice searchResult data according to it's needs~~

	== Logical: SellOfferManager - ~~orderPrice~~ - ~~maxPricePerSellOffer~~ / ~~minPricePerSellOffer~~ ==		== Logical: SellOfferManager - sellOffer - maxPrice / minPrice ==

	* passes on to a ~~sorted searchResult~~ request for ~~orderPrice~~ that has logicalTag = aggregatedSellOfferPrices, sorted by price (ascending)		* passes on to a sortResult request for sellOffer that has logicalTag = aggregatedSellOfferPrices, sorted by price (ascending)
			* at the end after the sortResult complete message it will perform logical comparison in ProcessLogicalSortedRequest
	* requires sorted aggregatedSellOfferPrices so can perform it's comparison		* requires sorted aggregatedSellOfferPrices so can perform it's comparison
	* searchResult requiredData is "price", ~~this will invoke FindData~~ after aggregatedSellOfferPrices complexFilter complete		* searchResult requiredData/FindData is "price" fieldname, found after aggregatedSellOfferPrices complexFilter complete
	* once aggregatedSellOfferPrices completes triggers ProcessLogicalSortedRequest (set callingFlow = this service's ProcessLogicalSortedRequest), which will trigger SortResult's CopyDataToExternalTable lambda		* once aggregatedSellOfferPrices completes triggers ProcessLogicalSortedRequest (set callingFlow = this service's ProcessLogicalSortedRequest), which will trigger SortResult's CopyDataToExternalTable lambda
	* CopyDataToExternalTable will copy records to SellOfferManager's LogicalResults table		* CopyDataToExternalTable will copy sellOfferId records to SellOfferManager's LogicalResults table
	* SellOfferManager's CompleteLogicalSortedRequest lambda subscribes to sortResult's CopyDataToExternalTableComplete topic, and completes the Logical request		* SellOfferManager's CompleteLogicalSortedRequest lambda subscribes to sortResult's CopyDataToExternalTableComplete topic, and completes the Logical request

	== Logical: SellOfferManager - ~~orderPrice~~ - aggregatedSellOfferPrices ==		== Logical: SellOfferManager - sellOffer - aggregatedSellOfferPrices ==

	* passes on to sellOffer complexFilter with child complexFilter type planDeliveryPaymentCombination		* passes on to sellOffer complexFilter with child complexFilter type planDeliveryPaymentCombination
Line 42:		Line 39:
	* queries graph for all sellOfferPlanId + sellOfferPlanDeliveryMethodLinkId + sellOfferPlanPaymentMethodLinkId combinations that match given paymentMethodIds/deliveryMethodIds		* queries graph for all sellOfferPlanId + sellOfferPlanDeliveryMethodLinkId + sellOfferPlanPaymentMethodLinkId combinations that match given paymentMethodIds/deliveryMethodIds
	* saves each combination into it's LogicalResultsData table		* saves each combination into it's LogicalResultsData table
	* completes it's logical, which completes the planDeliveryPaymentCombination complexFilter which completes the sellOffer complexFilter, which triggers SellOfferManager's FindSellOfferFilterComplete lambda		* completes it's logical, which completes the planDeliveryPaymentCombination complexFilter which completes the sellOffer complexFilter (after TranslateIds), which triggers SellOfferManager's FindSellOfferFilterComplete lambda

	== SellOfferManager - FindSellOfferFilterComplete ==		== SellOfferManager - FindSellOfferFilterComplete ==

	* receives complexFilterComplete message for sellOffer level complexFilter ~~that lists~~ all ~~aggregatedSellOfferPrices logicals,~~ unique sellOffers that have planDeliveryPaymentCombination (any combination of given paymentMethodIds/deliveryMethodIds)		* receives complexFilterComplete message for sellOffer level complexFilter
	* for each logicalResultMain found, send request to CreatePerSellOfferSortedPriceRequests		* sellOffer level complexFilter found all unique sellOffers that have planDeliveryPaymentCombination (any combination of given paymentMethodIds/deliveryMethodIds)
			* finds all logicalResultMain waiting for this sellOffer complexFilter
			* for each logicalResultMain found, send request to CreatePerSellOfferSortedPriceRequests (because next step needs to handle multiple invocations per logicalResultMain)

	== SellOfferManager - CreatePerSellOfferSortedPriceRequests ==		== SellOfferManager - CreatePerSellOfferSortedPriceRequests ==

	* for one logicalResultMain, iterates all sellOfferIds found in sellOffer-planDeliveryPaymentCombination complexFilter results		* for one logicalResultMain, iterates all sellOfferIds found in sellOffer-planDeliveryPaymentCombination complexFilter results
	* passes on to a ~~sorted searchResult~~ request for orderPrice that has logicalTag = sellOfferQuantityLocationIdCombinations, sorted by price (ascending)		* passes on to a sortResult request for orderPrice that has logicalTag = sellOfferQuantityLocationIdCombinations, sorted by price (ascending)
	* for each sellOfferId we need an ordered list of prices that come from the different deliverToLocationIds/paymentMethodIds/deliveryMethodIds combinations		* for each sellOfferId we need an ordered list of prices that come from the different deliverToLocationIds/paymentMethodIds/deliveryMethodIds combinations
	* searchResult requiredData is "price", will invoke FindData after sellOfferQuantityLocationIdCombinations complexFilter complete		* searchResult requiredData is "price", will invoke FindData after sellOfferQuantityLocationIdCombinations complexFilter complete
	* saves each sellOfferQuantityLocationIdCombinations request into AwaitingMultipleStep for the original aggregatedSellOfferPrices logical		* saves each sellOfferQuantityLocationIdCombinations request into AwaitingMultipleStep for the original aggregatedSellOfferPrices logical
	* sends ~~searchResult~~ request to SellOfferManager ~~searchResult~~ service		* sends sortResult request to SellOfferManager sortResult service
	* once ~~sellOfferQuantityLocationIdCombinations~~ completes ~~per sellOfferId~~ triggers ~~CreateOrderPriceCombinations~~ (set callingFlow = this service's ~~CreateOrderPriceCombinations~~)		* once the per sellOffer orderPrice sortResult completes triggers AggregateOneSellOfferPrices for each (set callingFlow = this service's AggregateOneSellOfferPrices)

	== Logical: SellOfferManager - orderPrice - sellOfferQuantityLocationIdCombinations ==		== Logical: SellOfferManager - orderPrice - sellOfferQuantityLocationIdCombinations ==
Line 63:		Line 62:
	* passes on to planDeliveryPaymentCombination complexFilter, finding all combinations for only the requested sellOfferId		* passes on to planDeliveryPaymentCombination complexFilter, finding all combinations for only the requested sellOfferId
	* will use the same results as aggregatedSellOfferPrices for the planDeliveryPaymentCombination logicalTag		* will use the same results as aggregatedSellOfferPrices for the planDeliveryPaymentCombination logicalTag
	* once planDeliveryPaymentCombination complexFilter complete triggers SellOfferManager - CreateOrderPriceCombinations		* once planDeliveryPaymentCombination complexFilter complete triggers SellOfferManager - CreateOrderPriceCombinations (set callingFlow = this service's CreateOrderPriceCombinations)

	== SellOfferManager - CreateOrderPriceCombinations ==		== SellOfferManager - CreateOrderPriceCombinations ==

Sven the Barbarian at 21:16, 15 January 2022

2022-01-15T21:16:24Z

← Older revision		Revision as of 21:16, 15 January 2022
Line 11:		Line 11:
	* Request might originate higher up, eg SellOffer/Product/VariantProduct level, for pricing the OrderPrice level is the important start point		* Request might originate higher up, eg SellOffer/Product/VariantProduct level, for pricing the OrderPrice level is the important start point
	* orderPrice searchType / orderPrice filterType		* orderPrice searchType / orderPrice filterType
	* orderPrice types can have fields ~~maxPrice~~/~~minPrice~~		* orderPrice types can have fields maxPricePerSellOffer/minPricePerSellOffer
	* use translateIds to find matching sellOfferIds from orderPrice complexFilter		* use translateIds to find matching sellOfferIds from orderPrice complexFilter
	* use searchResult/findData's child id structure to copy aggregated price up from orderPrice level to sellOffer level		* use searchResult/findData's child id structure to copy aggregated price up from orderPrice level to sellOffer level
Line 17:		Line 17:
	* orderPrice level does not need to be sorted, can be a standard searchResult, but sellOffer level could layer sorting on top of the orderPrice searchResult data according to it's needs		* orderPrice level does not need to be sorted, can be a standard searchResult, but sellOffer level could layer sorting on top of the orderPrice searchResult data according to it's needs

	== Logical: SellOfferManager - orderPrice - ~~maxPrice~~ / ~~minPrice~~ ==		== Logical: SellOfferManager - orderPrice - maxPricePerSellOffer / minPricePerSellOffer ==

	* passes on to a sorted searchResult request for orderPrice that has logicalTag = aggregatedSellOfferPrices, sorted by price (ascending)		* passes on to a sorted searchResult request for orderPrice that has logicalTag = aggregatedSellOfferPrices, sorted by price (ascending)
Line 106:		Line 106:
	* for each logical found find this sellOffer's orderPriceId from SortResult service that matches the requested aggregation		* for each logical found find this sellOffer's orderPriceId from SortResult service that matches the requested aggregation
	* check any sellOffer AwaitingMultipleSteps remain for aggregatedSellOfferPrices logical, if not complete it		* check any sellOffer AwaitingMultipleSteps remain for aggregatedSellOfferPrices logical, if not complete it
	* completed aggregatedSellOfferPrices logical will pass back to the aggregatedOrderPriceSortedRequest SearchResult initiated in "SellOfferManager - orderPrice - ~~maxPrice~~ / ~~minPrice~~" logical		* original maxPricePerSellOffer / minPricePerSellOffer logical created an awaiting step waiting aggregatedSellOfferPrices logical that triggers CompleteLogicalSortedRequest

			== SellOfferManager - CompleteLogicalSortedRequest ==

			* performs maxPricePerSellOffer / minPricePerSellOffer logical's comparison and completes that logical

			== aggregatedSellOfferPrices logical complete ==

			* completed aggregatedSellOfferPrices logical will pass back to the aggregatedOrderPriceSortedRequest SearchResult initiated in "SellOfferManager - orderPrice - maxPricePerSellOffer / minPricePerSellOffer" logical
	* SearchResult triggers FindData field "price"		* SearchResult triggers FindData field "price"

Line 112:		Line 120:

	* will find cached result in FindData table for the recorded orderPriceId, or will re-calculate if FindData expired		* will find cached result in FindData table for the recorded orderPriceId, or will re-calculate if FindData expired
	* after all FindData for ~~maxPrice~~ / ~~minPrice~~ logical is complete will trigger ProcessLogicalSortedRequest which will perform the comparison and trigger CompleteLogicalSortedRequest to complete the logical		* after all FindData for maxPricePerSellOffer / minPricePerSellOffer logical is complete will trigger ProcessLogicalSortedRequest which will perform the comparison and trigger CompleteLogicalSortedRequest to complete the logical

Sven the Barbarian at 12:51, 10 January 2022

2022-01-10T12:51:36Z

← Older revision		Revision as of 12:51, 10 January 2022
Line 5:		Line 5:
	* eg: from Browse Catalog		* eg: from Browse Catalog

	== ~~Sorted~~ SearchResult: ~~sellOffer~~ ==		== SearchResult: orderPrice ==

	* Final result expected is a list of orderPriceIds and their pricing (eg min or max), along with any other fields wanted		* Final result expected is a list of orderPriceIds and their pricing (eg min or max), along with any other fields wanted
Line 16:		Line 16:
	* so entry point into pricing flow is begun by orderPrice level filter/requiredData		* so entry point into pricing flow is begun by orderPrice level filter/requiredData
	* orderPrice level does not need to be sorted, can be a standard searchResult, but sellOffer level could layer sorting on top of the orderPrice searchResult data according to it's needs		* orderPrice level does not need to be sorted, can be a standard searchResult, but sellOffer level could layer sorting on top of the orderPrice searchResult data according to it's needs

	~~== SearchResult: orderPrice ==~~

	== Logical: SellOfferManager - orderPrice - maxPrice / minPrice ==		== Logical: SellOfferManager - orderPrice - maxPrice / minPrice ==

Sven the Barbarian at 12:29, 10 January 2022

2022-01-10T12:29:13Z

← Older revision		Revision as of 12:29, 10 January 2022
Line 7:		Line 7:
	== Sorted SearchResult: sellOffer ==		== Sorted SearchResult: sellOffer ==

	* Final result expected is a list of ~~Sell Offer Ids~~ and their pricing (eg min or max), along with any other fields wanted		* Final result expected is a list of orderPriceIds and their pricing (eg min or max), along with any other fields wanted
	* Original request is sent to ~~SellOffer~~ Search Result service which uses SellOfferManager service to process Logicals and FindData		* Original request is sent to OrderPrice Search Result service which uses SellOfferManager service to process Logicals and FindData
	* Request might originate higher up, eg Product/VariantProduct level, for pricing the ~~SellOffer~~ level is the important start point		* Request might originate higher up, eg SellOffer/Product/VariantProduct level, for pricing the OrderPrice level is the important start point
	* ~~sellOffer~~ searchType / ~~sellOffer~~ filterType		* orderPrice searchType / orderPrice filterType
	* ~~sellOffer~~ types can have fields maxPrice/minPrice		* orderPrice types can have fields maxPrice/minPrice
	* has child searchResult/complexFilter type orderPrice
	* use translateIds to find matching sellOfferIds from orderPrice complexFilter		* use translateIds to find matching sellOfferIds from orderPrice complexFilter
	* use searchResult/findData's child id structure to copy aggregated price up from orderPrice level to sellOffer level		* use searchResult/findData's child id structure to copy aggregated price up from orderPrice level to sellOffer level
Line 24:		Line 23:
	* passes on to a sorted searchResult request for orderPrice that has logicalTag = aggregatedSellOfferPrices, sorted by price (ascending)		* passes on to a sorted searchResult request for orderPrice that has logicalTag = aggregatedSellOfferPrices, sorted by price (ascending)
	* requires sorted aggregatedSellOfferPrices so can perform it's comparison		* requires sorted aggregatedSellOfferPrices so can perform it's comparison
	* searchResult requiredData is "price~~" and "status~~", ~~these~~ will invoke FindData after aggregatedSellOfferPrices complexFilter complete		* searchResult requiredData is "price", this will invoke FindData after aggregatedSellOfferPrices complexFilter complete
	* once aggregatedSellOfferPrices completes triggers ProcessLogicalSortedRequest (set callingFlow = this service's ProcessLogicalSortedRequest), which will trigger SortResult's CopyDataToExternalTable lambda		* once aggregatedSellOfferPrices completes triggers ProcessLogicalSortedRequest (set callingFlow = this service's ProcessLogicalSortedRequest), which will trigger SortResult's CopyDataToExternalTable lambda
	* CopyDataToExternalTable will copy records to SellOfferManager's LogicalResults table		* CopyDataToExternalTable will copy records to SellOfferManager's LogicalResults table
Line 110:		Line 109:
	* check any sellOffer AwaitingMultipleSteps remain for aggregatedSellOfferPrices logical, if not complete it		* check any sellOffer AwaitingMultipleSteps remain for aggregatedSellOfferPrices logical, if not complete it
	* completed aggregatedSellOfferPrices logical will pass back to the aggregatedOrderPriceSortedRequest SearchResult initiated in "SellOfferManager - orderPrice - maxPrice / minPrice" logical		* completed aggregatedSellOfferPrices logical will pass back to the aggregatedOrderPriceSortedRequest SearchResult initiated in "SellOfferManager - orderPrice - maxPrice / minPrice" logical
	* SearchResult ~~has~~ FindData ~~fields~~ "price" ~~and "status" fields~~		* SearchResult triggers FindData field "price"
	* FindData ~~for "~~price~~" field~~ will find cached result for the recorded orderPriceId, ~~and return it's value~~
	* FindData for ~~"status" field~~ will ~~find cached result for~~ the ~~recorded orderPriceId,~~ and ~~return it's status~~		== FindData: SellOfferManager - orderPrice - price ==

			* will find cached result in FindData table for the recorded orderPriceId, or will re-calculate if FindData expired
			* after all FindData for maxPrice / minPrice logical is complete will trigger ProcessLogicalSortedRequest which will perform the comparison and trigger CompleteLogicalSortedRequest to complete the logical

Sven the Barbarian at 12:08, 10 January 2022

2022-01-10T12:08:07Z

← Older revision		Revision as of 12:08, 10 January 2022
Line 49:		Line 49:
	== SellOfferManager - FindSellOfferFilterComplete ==		== SellOfferManager - FindSellOfferFilterComplete ==

	* receives complexFilterComplete message for sellOffer level complexFilter that lists all unique sellOffers that have planDeliveryPaymentCombination (any combination of given paymentMethodIds/deliveryMethodIds)~~, initiated in Logical aggregatedSellOfferPrices~~		* receives complexFilterComplete message for sellOffer level complexFilter that lists all aggregatedSellOfferPrices logicals, unique sellOffers that have planDeliveryPaymentCombination (any combination of given paymentMethodIds/deliveryMethodIds)
	* for each logicalResultMain found, send request to CreatePerSellOfferSortedPriceRequests		* for each logicalResultMain found, send request to CreatePerSellOfferSortedPriceRequests

Line 58:		Line 58:
	* for each sellOfferId we need an ordered list of prices that come from the different deliverToLocationIds/paymentMethodIds/deliveryMethodIds combinations		* for each sellOfferId we need an ordered list of prices that come from the different deliverToLocationIds/paymentMethodIds/deliveryMethodIds combinations
	* searchResult requiredData is "price", will invoke FindData after sellOfferQuantityLocationIdCombinations complexFilter complete		* searchResult requiredData is "price", will invoke FindData after sellOfferQuantityLocationIdCombinations complexFilter complete
	* saves each sellOfferQuantityLocationIdCombinations request into AwaitingMultipleStep for ~~this logicalResultId~~		* saves each sellOfferQuantityLocationIdCombinations request into AwaitingMultipleStep for the original aggregatedSellOfferPrices logical
	* sends searchResult request to SellOfferManager searchResult service		* sends searchResult request to SellOfferManager searchResult service
	* once sellOfferQuantityLocationIdCombinations completes per sellOfferId triggers CreateOrderPriceCombinations (set callingFlow = this service's CreateOrderPriceCombinations)		* once sellOfferQuantityLocationIdCombinations completes per sellOfferId triggers CreateOrderPriceCombinations (set callingFlow = this service's CreateOrderPriceCombinations)
Line 70:		Line 70:
	== SellOfferManager - CreateOrderPriceCombinations ==		== SellOfferManager - CreateOrderPriceCombinations ==

	* find all logicalResultMains (ie: sellOfferId+orderQuantity+deliverToLocationIds+deliveryMethodIds+paymentMethodIds+excludeEmpty request) that are waiting for this sellOfferId+planDeliveryPaymentCombination filter		* find all logicalResultMains (ie: sellOfferId+orderQuantity+deliverToLocationIds+deliveryMethodIds+paymentMethodIds+excludeEmpty request) that are waiting for this sellOfferId+planDeliveryPaymentCombination filter (initiated in sellOfferQuantityLocationIdCombinations logical)
	* for each logicalResultMain's planDeliveryPaymentCombination, iterate the logicalResultMain's deliverToLocationIds to create orderPriceId		* for each logicalResultMain's planDeliveryPaymentCombination, iterate the logicalResultMain's deliverToLocationIds to create orderPriceId
	* make sure an orderPrice record exists for the calculated orderPriceId		* make sure an orderPrice record exists for the calculated orderPriceId
	* this will result in multiple orderPriceIds being created/checked exist for one logicalResultMain		* this will result in multiple orderPriceIds being created/checked exist for one logicalResultMain
	* complete each sellOfferQuantityLocationIdCombinations logicalResultMain		* complete each sellOfferQuantityLocationIdCombinations logicalResultMain
	* for each logicalResultMain found, the logical complete message will trigger FindData for orderPrice - "price" field (original request created in createPerSellOfferSortedPriceRequests)		* for each sellOfferQuantityLocationIdCombinations logicalResultMain found, the logical complete message will trigger FindData for orderPrice - "price" field (original request created in createPerSellOfferSortedPriceRequests)

	== FindData: SellOfferManager - orderPrice - price ==		== FindData: SellOfferManager - orderPrice - price ==
Line 101:		Line 101:
	* completes the "orderPrice - price" FindData record, this is where one orderPrice is completed		* completes the "orderPrice - price" FindData record, this is where one orderPrice is completed
	* FindData records are from the sellOfferQuantityLocationIdCombinations searchResult requests, initiated in CreatePerSellOfferSortedPriceRequests		* FindData records are from the sellOfferQuantityLocationIdCombinations searchResult requests, initiated in CreatePerSellOfferSortedPriceRequests
	* each CreatePerSellOfferSortedPriceRequests triggers AwaitingMultipleSteps link in		* each CreatePerSellOfferSortedPriceRequests triggers AwaitingMultipleSteps link created in CreatePerSellOfferSortedPriceRequests but linking to original aggregatedSellOfferPrices logical
			* each AwaitingMultipleStep triggers AggregateOneSellOffersPrices

			== SellOfferManager - AggregateOneSellOffersPrices ==

			* finds all aggregatedSellOfferPrices logicals that match the received sellOffer's sorted prices sellOfferOrderPriceSortedRequest
			* for each logical found find this sellOffer's orderPriceId from SortResult service that matches the requested aggregation
			* check any sellOffer AwaitingMultipleSteps remain for aggregatedSellOfferPrices logical, if not complete it
			* completed aggregatedSellOfferPrices logical will pass back to the aggregatedOrderPriceSortedRequest SearchResult initiated in "SellOfferManager - orderPrice - maxPrice / minPrice" logical
			* SearchResult has FindData fields "price" and "status" fields
			* FindData for "price" field will find cached result for the recorded orderPriceId, and return it's value
			* FindData for "status" field will find cached result for the recorded orderPriceId, and return it's status

← Older revision		Revision as of 03:25, 5 April 2023
Line 15:		Line 15:
	* sellOffer complexFilter will trigger FindSellOfferFilterComplete lambda (callingFlow = this service's FindSellOfferFilterComplete)		* sellOffer complexFilter will trigger FindSellOfferFilterComplete lambda (callingFlow = this service's FindSellOfferFilterComplete)
	* at the end after the sortResult complete message it will perform logical comparison in ProcessLogicalSortedRequest		* at the end after the sortResult complete message it will perform logical comparison in ProcessLogicalSortedRequest
	* searchResult requiredData/FindData ~~fieldname~~ matches logicalTag, this FindData requests finds the aggregated price for each sellOfferId returned from complexFilter		* searchResult requiredData/FindData fieldName matches logicalTag, this FindData requests finds the aggregated price for each sellOfferId returned from complexFilter
	* once sortResult completes triggers ProcessLogicalSortedRequest (set callingFlow = this service's ProcessLogicalSortedRequest), which will trigger SortResult's CopyDataToExternalTable lambda		* once sortResult completes triggers ProcessLogicalSortedRequest (set callingFlow = this service's ProcessLogicalSortedRequest), which will trigger SortResult's CopyDataToExternalTable lambda
	* CopyDataToExternalTable will perform comparison, then copy sellOfferId results to SellOfferManager's LogicalResults table		* CopyDataToExternalTable will perform comparison, then copy sellOfferId results to SellOfferManager's LogicalResults table
Line 79:		Line 79:

	* completes the minDeliveryPrice findData by finding the lowest rate		* completes the minDeliveryPrice findData by finding the lowest rate
	* triggers SellOfferManager's awaiting findData for ~~fieldname~~ "price" in it's ProcessFindDataSortedRequest function, which will find the maximum rate from all deliveryMethodLinkIds sent		* triggers SellOfferManager's awaiting findData for fieldName "price" in it's ProcessFindDataSortedRequest function, which will find the maximum rate from all deliveryMethodLinkIds sent

	== SellOfferManager - ProcessFindDataSortedRequest - orderPrice - price - sellOfferPlanDeliveryMethodLink ==		== SellOfferManager - ProcessFindDataSortedRequest - orderPrice - price - sellOfferPlanDeliveryMethodLink ==
Line 92:		Line 92:

	* completes the paymentPrice findData for each userPaymentMethodLinkIds		* completes the paymentPrice findData for each userPaymentMethodLinkIds
	* triggers SellOfferManager's awaiting findData for ~~fieldname~~ "price" in it's ProcessFindDataSortedRequest function, which will find the maximum rate from all userPaymentMethodLinkIds sent		* triggers SellOfferManager's awaiting findData for fieldName "price" in it's ProcessFindDataSortedRequest function, which will find the maximum rate from all userPaymentMethodLinkIds sent

	== SellOfferManager - ProcessFindDataSortedRequest - orderPrice - price - sellOfferPlanUserPaymentMethodLink ==		== SellOfferManager - ProcessFindDataSortedRequest - orderPrice - price - sellOfferPlanUserPaymentMethodLink ==