La vie très intéressante de MagicBuzz

La vie très intéressante de MagicBuzz - Algo - Programmation

Marsh Posté le 13-09-2002 à 15:45:13    

Pfiou !
Je viens de terminer les évolutions du site de GEMSE :)
Et la doc (in barbarian english :D)
 

Code :
  1. General Electric Medical Systems Europe Accessories Web Site
  2. Table of contents:
  3. I. Prices calculation 3
  4. A) Description 3
  5. B) When ordering 3
  6. C) When navigating in catalog 4
  7. II. Product visibility 6
  8. III. ?Our promotions? category 7
  9. I. Prices calculation
  10. This section does not describe ?promotional prices? calculation. It will be added in future document update, when process will be finalized.
  11. All prices found in database are converted ?on the fly? to EURO currency, to be able to compare them together. Round rule is: We add 0.5 to all amounts, and we truncate to unit. For currency with cents, we multiply per 100, then we round the amount, and then we divide it by 100. This is the standard round rule for currency.
  12. A) Description
  13. In GE structure, there are five prices types.
  14. 1) Customer prices ? Contracted prices, digressive and localized by customer
  15. 2) Scale prices ? Decrease, localized by ?scale of price code?
  16. 3) Column prices ? Decrease, non-localized
  17. 4) Standard prices ? Non-decrease, localized by establishment
  18. 5) Corporate prices ? Non-decrease, non-localized
  19. All of these prices are stocked in Web database as below:
  20. They are separated in three tables.
  21. GENcts contains customer prices (type 1)
  22. GENtac contains scale prices and column prices (types 2 and 3)
  23. GENtas contains standard prices and corporate prices (types 4 and 5)
  24. B) When ordering
  25. In order process, all prices are retrieved and calculated by Microsoft Commerce Server 2.0 pipeline. It uses VBS Script ?price.vbs? that contains all functions used for managing prices. Process in these functions is described below:
  26. When a customer adds a product to his cart, we get price as this:
  27. - We try to find prices in this order: 1, 2, 3, 4 and 5 corresponding to user?s profile and quantity chosen.
  28. - When prices are found for any category, we get lower price from applicable prices.
  29. - When an applicable price is found, we don?t try to find another price type.
  30. Example:
  31. Customer A adds 50 units of product P in his cart. He hasn?t negotiated price with GE, but he is subject to scale of price. He lives in country C so he depends from establishment E.
  32. We look for contract (price type 1) in GENcts. As we don?t find any one, we try to find a price type 2 in GENtac.
  33. We find 3 different prices for this product and applicable scale of price:
  34. From 1 unit: 24 ?/SU
  35. From 30 units: 25 ?/SU
  36. 60 units and more: 20 ?/SU
  37. Only the two first prices are applicable. The lower one is 24?/SU from 1 unit. We use this one.
  38. As we already found a usable price for this product, we don?t try to find other types of price.
  39. C) When navigating in catalog
  40. For catalog price managing process, a ASP file ?x_calc_price.asp? is used. It is a copy of ?price.vbs? file (see paragraph ?B) When Ordering? for more details), plus a new function for displaying digressive prices, described below:
  41. - When customer navigates in catalog, we use the same process that the one used to add a product to the cart with quantity settled to 1.
  42. - But in ?product details? page, we display all digressive prices by quantity.
  43. For this, we get all applicable prices from all five types of price, ordered by price type, ascending, and then price value, ascending. So, we get price from each line when quantity is lower than precedent.
  44. Example:
  45. For user U and product P, we have these applicable prices:
  46. Type 5:
  47. 25 ?
  48. Type 4:
  49. 28 ?
  50. Type 3:
  51. 27 ? from 5 units
  52. 26 ? from 30 units
  53. Type 2:
  54. 20 ? from 8 units
  55. 18 ? from 25 units
  56. Type 1:
  57. 16 ? from 50 units
  58. 14 ? from 60 units
  59. Query returns values:
  60. TYPE QUANTITY PRICE
  61. 1 60 14
  62. 1 50 16
  63. 2 25 18
  64. 2 8 20
  65. 3 30 26
  66. 3 5 27
  67. 4 1 28
  68. 5 1 25
  69. When parsing results, we get only prices where quantity is lower than previous one. So we display this (array is filled from bottom):
  70. From To Price
  71. 1 4 28 ?
  72. 5 7 27 ?
  73. 8 24 20 ?
  74. 25 49 18 ?
  75. 50 59 16 ?
  76. 60 +¥ 14 ?
  77. II. Product visibility
  78. GE sells products that some countries are not allowed to buy. Furthermore GE?s catalog contains non-sellable products.
  79. These permissions are stocked in database in two tables:
  80. - GENpro: A binary flag ?pro_cntdstb? indicates which countries can access or no to the product.
  81. - GENbit: Associate countries to a bit position in ?pro_cntdstb? binary flag.
  82. When a user is logged, we know what country he comes from. So we just have to verify if the bit corresponding to his country is set to ?1? for the product he is looking to.
  83. When user is not logged, we can?t know what products he can see and what products he can?t see. So we display only products that all countries can see.
  84. III. ?Our promotions? category
  85. A new section in ?Accessories corner? had been added to advertise about promotions.
  86. This is not the real promotion function that is described below: this is a products list with a unique price used to sell at low price for diestock (end series)
  87. A new table ?TABOURPROMO? has been added in database to manage products that are in promotion.
  88. In the ?Promotion? page, we just have to get all products that are in this new table.
  89. But as products that are in promotion are old products, they were unable to be imported from GENERIX as this. So a new ?product life status? has been created in GENERIX, and import now gets also codblocage = ?15?. Update all import SQL Queries (PRMREQ table) to add this filter.
  90. These products don?t have specific treatments when used outside ?promotion? category. They are simple products, with a unique price and are managed in catalog as other products.
  91. Note: TABOURPROMO is all managed in the manager. Import doesn?t provide information about promotion. As this is a new administration interface, don?t forget to update permissions for each admin users.


 
ct vraiment très intéressant :jap: :D

Reply

Marsh Posté le 13-09-2002 à 15:45:13   

Reply

Marsh Posté le 13-09-2002 à 15:47:44    

Was here  [:yaisse2]  
 


---------------
Informaticien.be - Lancez des défis à vos amis
Reply

Marsh Posté le 13-09-2002 à 15:49:37    

:lol:


---------------
Des bons sites pour Delphi? http://forum.hardware.fr/forum2.php3?post=16838&cat=10 -- informaticien -- http://www.z0rglub.com/phpwebgallery/ -- Delphi :love:
Reply

Marsh Posté le 13-09-2002 à 15:55:06    

MagicBuzz a écrit a écrit :

ct vraiment très intéressant :jap: :D




 
ouais heu la prochaine fois tu vas atterrir chez les telletubies
c'est pas une poubelle ici :p

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed