Tops Friendly Markets Web Administration

A1. Website Home - Last Week
A2. Website Home - This Week
A3. Website Home - Next Week

B. Web Admin

C1. Test Weekly Ad by Store. Page that allows testing of ad that breaks next week, as well as the current week's ad and last week's ad.
C2. Test Weekly Ad by Ad Zone. Lists ad zones and ad numbers of base ad, wraps, inserts and go ads.
C3. Weekly Ad by Base Page Code. Lists ad zones, ad numbers and optional base page codes.
C4. Weekly Ad--Versions. Lists all ad versions.

C5. STATIC - Test Weekly Ad by Ad Zone. Lists ad zones and ad numbers of base ad, wraps, inserts and go ads.

D1. AdZone Maintenance Crunch for NEXT week, 2014-11-02 DO THIS FIRST before crunching the weekly ad items!!! Creates records in AdZone table from AdZone_maint table. New records have site, StoreNbr, AdZoneRetailer, numeric AdZone (1..22), DateStart and DateEnd fields.
D2. AdZone Maintenance Crunch for THIS week, 2014-10-26 Creates records in AdZone table from AdZone_maint table. New records have site, StoreNbr, AdZoneRetailer, numeric AdZone (1..22), DateStart and DateEnd fields.
D3. AdZone Maintenance Crunch for 2 WEEKS OUT, 2014-11-09 Creates records in AdZone table from AdZone_maint table. New records have site, StoreNbr, AdZoneRetailer, numeric AdZone (1..22), DateStart and DateEnd fields.

E1. Ad Crunch for NEXT week, 2014-11-02 DO THIS SECOND before clearing the weekly ad items!!! Creates records in Ad table from AdZone table.
E2. Ad Crunch for THIS week, 2014-10-26 Creates records in Ad table from AdZone table.
E3. Ad Crunch for TWO WEEKS OUT, 2014-11-09 Creates records in Ad table from AdZone table.

J1. WrapFirst Crunch for NEXT week, 2014-11-02 This sets the WrapFirst field in the AdZone table based on settings in the Ad table.
J2. WrapFirst Crunch for THIS week, 2014-10-26 This sets the WrapFirst field in the AdZone table based on settings in the Ad table.
J3. WrapFirst Crunch for TWO WEEKS OUT, 2014-11-09 This sets the WrapFirst field in the AdZone table based on settings in the Ad table.

C3. Ad Items/Recipe Links - for NEXT week 11/02/2014 For Tops Friendly Markets - this determines recipes to link the ad items to (randomly) based on the ad item's key ingredient name entries. It also creates corresponding records in the IngredNameTrans table to link back from recipes to the Ad page.
C4. Ad Items/Recipe Links for THIS week (10/26/2014) Same as C2, but for current ad.

E8. Weekly Ad Filler Items

F1 A. Card Maint CRUNCH
Card_Maint file date:   -- (yyyy-mm-dd)

H. 2 Select tops Sweeps Winners from TWO weeks ago. 2014-10-12 thru 2014-10-26
H. 3 Select tops Sweeps Winners from THREE weeks ago. 2014-10-05 thru 2014-10-19

L. Recipe's IngredientNameList Crunch Convert *** to list of Ingred Names for search functions.
L1. Featured Recipe Links Link for Current Featured Recipe, Next Week's Featured Recipe, 2 Weeks Out Featured Recipe

M. StateLong Crunch Lookup StatLong from Global table & crunch into Stores records.

J1. WebSpecials test for NEXT week, 2014-11-02
J2. WebSpecials test for THIS week, 2014-10-26
J3. WebSpecials test for TWO WEEKS OUT, 2014-11-09

K. Card Nbr Crunch Calculates an encrypted CardNbr and sets the field CardNbrEncr to that value. Only selects card records with an email address that also have no value in CardNbrEncr.





PWS 28