StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12899641
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-10-15T16:09:52.063
FavoriteCount
0
LastActivityDate
2012-10-15T16:09:52.063
LastEditDate
LastEditorUserId
0
OwnerUserId
416412
ParentId
10696556
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Maybe this will help you: Example deal: Buy 4 of PRODUCT_A get 2 of PRODUCT_B free Variables: <ul> <li><code>numSkuRequired</code>: number of products required for deal to work(in this case 4)</li> <li><code>skuRequired</code>: the product required for deal to work(in this case PRODUCT_A's identifier, sku/id or something)</li> <li><code>numSkuFree</code>: number of products to be given as free(in this case 2)</li> <li><code>skuFree</code>: the product that is given away for free(in this case PRODUCT_B's identifier, sku/id or something)</li> <li><code>quantityLookupRequired</code>: PRODUCT_A's summed quantity in cart, default <code>false</code></li> <li><code>quantityLookupFree</code>: PRODUCT_B's summed quantity in cart, default <code>false</code></li> <li><code>quantityFree</code>: final result that we're looking for to calculate the total amount, number of free products(PRODUCT_B), default <code>0</code></li> <li><code>price</code>: price of PRODUCT_B, default <code>0</code></li> <li><code>discount</code>: total discount amount, default <code>0</code></li> </ul> Steps <ol> <li>find sum of PRODUCT_A in cart, save in variable <code>quantityLookupRequired</code></li> <li>ensure that <code>quantityLookupRequired</code> is <code>>=</code> <code>numSkuRequired</code></li> <li>find sum of PRODUCT_B in cart, save in variable <code>quantityLookupFree</code></li> <li>ensure that <code>quantityLookupFree</code> is <code>>=</code> <code>numSkuFree</code></li> <li>find price of PRODUCT_B and save in variable <code>price</code></li> <li>loop(see below) to find <code>quantityFree</code> (the editor isn't allowing me to make this look much better sorry).</li> <li><code>discount</code> will be <code>quantityFree * price</code> for(int i = 0; i < numSkuRequired + numSkuFree; i <= quantityLookupRequired + quantityLookupFree; i += (numSkuRequired + numSkuFree)) { quantityFree += numSkuFree; } while(quantityFree % numSkuFree != 0)/* don't allow partial discounts */ { quantityFree--; } discount = quantityFree * price;</li> </ol> Note: a slightly different approach is taken when the deal only includes 1 product(Buy 4 of PRODUCT_A get 2 of PRODUCT_A free)
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSpecial logic\algorithm in Shopping Cart
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USbinnyb
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.