E-mail Broadcast:
John Friesen is currently building a function that will allow a site supervisor to fill out a form that will generate an e-mail message to be sent to the e-mail addresses that we captured using the site specific Free E-mail Picks form on the Ecapper sites.

Site supervisor will enter text (subject and body), click send e-mail. The system will send this e-mail to all e-mail addresses in his sites data file.




Priority 5 Clear Order Count:
An Ecapper Site Supv can Reset / Clear the order count of a system member once in a seven-day period. Once any member has had his order count reset once, no other Ecap Sup will be able to reset that same members order count until the 7-day period is over.

There will be an auto system member count reset at 00:05:00 on Sun.


Ecap Sup has link to "Member Services". After he clicks this link he sees a Member Search screen where he can search with the following choices:
1) First Name
2) Last Name
3) User Name
4) Password
5) E-mail Address

A successful search returns ALL information about the member EXCEPT CREDIT CARD information. This includes Current Purchase Count (7 day period) and Member Level

Possibly look like ---

Jim | Ratica | jimrt | jimrt | jim@ecapper.net   VIEW    (click here for an example of the VIEW)
Jim | Jones | erter | ert667 | jim@hotmail.com   VIEW

After the VIEW link is clicked the member infomation is displayed so the Supv. can verify that he has the member he is looking for. This page contains the link to Reset Current Purchase Count.

We can use this format for any other member functions we want the supervisor to have. This way we help to reduce the chance of the Supv. changing the wrong customers settings.


After the Ecapp Sup click reset he will se a screen that explains he has successfully reset that members order count and he will be unable to perform another reset for that member until the new 7 day period begins. Additionally, no other Ecap Sup can reset that members order count AND if any other Ecap Sup has reset another member he can not reset that member if he wishes.

By Friday? ALSO: Look at ways to log which site supervisor has reset any members count and when.

We need 2 text messages generated.
1) After a successful order count clear a message that states: You have successfully reset (member_id) order count to Zero for the current 7 day purchasing period. This customer can not have his order count reset again during this current 7 day period.

2) If some one attempts to reset a member who has already been reset:
This member has already had his order count reset in this 7 day period. To investigate clearing this order count further, please call Ecapper Admin Offices at 1-800-333-1117.



Priority 2 Sales Count Reports (SUPV Only)

Ecap Sup will be able to generate a READ ONLY Report of sales activity on his site. We will use PB's Web Box Summary Report search screen and this will yield the following search fields:
-Date Ordered/ Single Date or Date Range
-Handicapper (All option included, if site only has 1 capper then only 1 name appears in drop down)
We will drop the 'Sales for Site' field for Ecapper because we do not think that we will many cases where the same person will be a supervisor for more that 1 site. If that does occur then that supervisor can access this data by using the unique site supervisor login for each site he supervises.

Results on this Report will show:

Box (?) | Handicapper | Sales(count) | Credits(count) | Charge Backs(count) | Total Calls(looks to be same as Sales count) | Sales $ | Credits $ | Charge Backs $ | Total $

TOTAL CALLS = Sales + Credits + Charge Backs

Total $ is a sum (horizontally) for that handicappers activity. Individual columns also total vertically (except hcaper and box(?)). This helps provide a crosscheck to ensure the Total $ figure matches.


Priority 3 Ecapper (NON SUPV) Sales Report:
When an Active Handicapper logs in he will have a link to see HIS SALES ACTIVITY ONLY. This is modeled after the PB Daily Call Count Report (from hcap.cgi) After he clicks on this link he sees a search screen with the following choices:
- Date Ordered/ Single Date or Date Range
- Currently has a drop down that says Handicapper. This is really a way for the handicapper to choose from his different price pick price levels.
- Sales for Site. If handicapper is only on 1 site then this drop down will only have 1 choice.

After making his search choices, he clicks Submit and the handicapper sees data under these headers:

Ref# (invoice#?) | Date | Tip Sheet(Box name text) | Price | Balance

Ref# IS cust_id from old playbook.


This is a report with 1 purchase per line. It is possible to have a negative value if a purchase had been credited or charged back.

David: The query string was being printed to the screen in PB. I assume for testing. Here is the query string for Cincy Kid login choosing: August, 2002, Cincinnati Kid Key Play, All Sites:

Content-type:text/html SQL: SELECT W.win_id, W.order_id, W.pb_id, W.date_ordered, W.amount, H.h_from FROM orders_win W LEFT JOIN pic_items P ON W.product_id = P.product_id, handicapper H WHERE P.handicapper_id = H.handicapper_id AND P.handicapper_id IN (8) AND (W.cancelled = '0' or W.cancelled IS NULL) AND ((W.date_ordered >= '2002-8-01 00:00:01') and (W.date_ordered < '2002-9-1 00:00:00')) ORDER BY W.date_ordered .



Priority 4 General Search for Member:
Site supervisor will be able to do a general member search. This is NOT the same search that is done during a Reset/Clear Order Count.

Supervisor can search with the following fields:
2) First Name
3) Last Name
4) User Name
5) Password
6) E-mail Address

After hitting submit we will have to return just these values initially because there will be multiple results (entering first name only will return many results that the supervisor must chose from to access that members information).

He then chooses one member to 'expand' and then sees the following applicable information for that member:
7) First Name
8) Last Name
9) Street Address
10) City
11) State
12) Zip
13) Country
14) Member id
15) Password
16) E-mail Address
17) Level (0,1,2,3)
18) Day Phone
19) Evening Phone
20) Fax
21) Current purchases
22) Total purchases THIS IS ON HOLD UNTIL SITE SPECIFIC CONTS ARE AVAILABLE.

IF POSSIBLE we will also report site purchase count.
ALSO we must plan to have some type of NOTES functions. Most likely some pre-set choices such as 1) Calls to dispute Win/Loss of plays, 2) Calls to harass, 3) Calls to get member id and password 4) Calls to have purchase count reset.
This will allow Site supervisor to make notes about a member that everyone who uses the system will understand.


Priority 1 Win / Loss Grading:

This begins with a Win / Loss Grading Page which contains:
23) Radio Button Choices for WIN, LOSS and PENDING
24) Pick ID
25) Handicapper Name: BOX NAME TEXT
26) Pick Purchased: All text in the actual pick. This excludes the Title and Teaser or call out.
27) Pick Expiration Date: Date Time Pick was unavailable for sale or it's earliest event data and time

When the page first comes on the screen ALL PICKS will be marked PENDING because none have yet been graded. This page contains ONLY PICKS THAT HAVE BEEN PURHCASED and have an authorize code. If there is no authorize code associated with a specific pick that means the pick does not have an entry at authorize.net waiting to be captured or voided.

After clicking on submit we tag the picks table with a W or L. The picks table information is used send to auth net a capture or void instruction for each graded pick. Currently we send captures and voids to authorize.net 'manually'. There are no automatic submissions to auth net occurring.


Priority 1.2 Buy / Cancel Page:
This page display to be sorted by SITE_ID
We then display a page that contains:
28) Buy or Cancel radio button
29) Handicapper Name and Site Sold (one line for each pick sold on any site)
30) Purchase Date/Time
31) Member ID, Invoice Number (from auth net at time of purchase) and Purchase ID
32) Password
33) Pick Expiration Data/Time

This page allows changes to the Picks table before it is sent to auth net. This is where we can identify Picks that we want to hold from the batch process. Clicking on submit from this page will send a void or capture to auth net for all selected picks.


Priority 6 Win / Loss Non Sales Report:

We will repare to tag Picks Not Purchased as "H ". This will allow us to archive these picks so they can be graded "in house" at some point in the future and produce a handicappers W/L % based on all his picks. This can become an Ecapper Monitoring Service.