190676 osc project

Sedang Disiapkan Disiarkan Jan 7, 2008 Dibayar semasa penghantaran
Sedang Disiapkan Dibayar semasa penghantaran

I need this project done today.

website: [url removed, login to view]

Project 1

Redeem Functionality:

Please don't implement anything until we discuss this project in detail.

a. A customer gets $1 for every 100 credits. (already exists)

b. A customer can redeem cash if the customer has more than or equal to 1000 credits (need to build)

c. For every transaction a customer makes he gets 50 credits (already exists)

d. For every transaction a customer's invitee makes the customer gets 50 credits (already exists)

e. For every transaction there is a vesting time, it is a variable. Set it to 60 days default. What does this mean? Read point f

f. There will be two checks before the customer can redeem cash or use credits towards a product/offer purchase:

a. First check if the customer has 1000 credits. If the customer does then perfect to go check “b”. If the customer does not have 1000 credits then display message “We are sorry you do not have 1000 credits. You must have 1000 credits to move forward.”

b. If the customer has 1000 credits, then check every transaction that the customer or his invitee (the person he invited) made and see if it matches the vested time period i.e. 60 days. For example if I purchased something 60 days ago and I got 50 credits so that means I can use those credits. If the person I invited purchased something 60 days ago and I got 50 credits for that then I can use those credits. If it's 59 days then I cannot use those credits. The vested time is a variable and may change at anytime. So the function that you will write must accept a vested time as a parameter and then check all the transactions. If there is any transaction(s) which is less than 60 days or the vested time (it's a variable), then display all those transactions with their dates. So you will write “All the following transactions are under 60 days, therefore you cannot redeem credits, you will need to wait until the vested time is passed”. Display the following fields:

i. Person's Name

ii. Transaction Date

iii. The number of days the customer has to wait

iv. The date the customer can use those credits

g. If the both f(a) and f(b) checks are cleared then the customer will be able to redeem the credits.

h. The customer will have 2 options to redeem the credits:

a. Redeem Cash: So in the “My Credits” section the customer will have a button that will say “Redeem Cash”. The customer will then click on the button. That button will take the customer to a page which will have the following fields:

i. How would you like to get paid?

1. Check by mail

2. Paypal

ii. Whether it's paypal or check, flag (unusable) credits from the pendingcredits and currentcredits table for this customer. This is basically used to update the user's account history.

iii. Insert a record for that customer into a NEW table usedcredits (you will need to create this table in the db). This table will tell the client and the admin how many credits have been used.

iv. If Check by mail, please provide your mailing address by filling in the form below:

1. First Name

2. Last Name

3. Name on the check:

4. Address 1

5. Address 2

6. City

7. State

8. Zip

9. Click Submit

v. When the customer clicks on the submit button then do the following:

1. Save a record in the database with all the following details

a. All the form details above

b. Total Amount Sent

c. Payment Method : “Check”

d. Redeemed Date

2. Send a confirmation email to the customer which will say

a. Subject: “Payment From [url removed, login to view]”

b. From Email:

c. To Email: Get customers email from the database

d. Body: “ Dear CUSTOMER NAME, Thank you for your business. You will receive a check of $X within 5 business days.” (put dollar amount instead of $X)

3. Send a confirmation email to the admin at which will say:

a. Subject: “Send Payment via Check”

b. From Email: customers email

c. To Email:

d. Body: “Dear Admin, Please send a check to the following individual for the amount of $X. Display form details.”

vi. If Paypal:

1. Please enter your paypal's email address.

2. Click Submit

vii. When the customer clicks on the submit button then do the following:

1. Save a record in the database with all the following details

a. Customers paypal email address

b. Total Amount Sent

c. Payment Method : “Paypal”

d. Redeemed Date

2. Send a confirmation email to the customer which will say

a. Subject: “Payment From [url removed, login to view]”

b. From Email:

c. To Email: Get customers email from the database

d. Body: “ Dear CUSTOMER NAME, Thank you for your business. You will receive a payment of $X via paypal within 5 business days.” (put dollar amount instead of $X)

3. Send a confirmation email to the admin at which will say:

a. Subject: “Send Payment via Paypal”

b. From Email: customers email

c. To Email:

d. Body: “Dear Admin, Please send a check to the following individual for the amount of $X. Display form details.”

b. Redeem credits to purchase a product on the website. A user can use his credits to purchase two kinds of products

i. Products that are stored in the OSCommerce system. Currently there are no products. You can add a test product to test this functionality.

ii. Magazine Offers – Users can purchase Magazines using their credits

c. Please note that when users purchase magazines they get credits. When they purchase a magazine with full or partial credits then they should NOT get any credits.

d. When you redeem credits while buying a product or a magazine the database must be updated

i. Subtract credits from the pendingcredits table

ii. Subtract credits from the currentcredits table

iii. Add a new record in the new table usedcredits. This table will tell the client and the admin how many credits have been used.

MySQL Odd Jobs PHP

ID Projek: #1936890

Tentang projek

Projek jarak jauh Aktif Jul 11, 2012