OSCOMMERCE - Customer / Address Payment Control

hi i run an oscommerce store i need to setup Payment Control for the Customers to allow me to restrict certain payment methods/modules to certain customers/address

e.g suppose we have Customer with Customers_id = 43 then Allowed_Payment_Module = cod, cc

this means the customer with id 43 can pay by Cash (cod) or Credit Card (cc)

but if i set Customers_id = 43 then Allowed_Payment_Module = cod then they can only Choose CASH (cod) as a payment module,

Note: this only affects customer with id = 43 , all other customers can use ALL payment methods by default

as a neat trick we can control this from the admin panel example click on the customer and choose allowed payment methods then it will update in db OR we can add a new option into admin/[login to view URL]

Allowed Payment Methods then have the payment method name and checkboxes and we can choose the one we want or DROP DOWN

e,g

ALL

CASH ONLY

CARD ONLY

then this will update the data in the db

we will need a new column in customers table called Allowed_Payment_Methods

EXTENSION

----------------------

i also need an extension to this to allow me to restrict payment methods depending on

Firstname

Lastname

Email

Street Address

Postcode

City

State

Phone

IP Address

we can add more parameters later but

any of those 4 we can use to begin with so for example suppose i have the following

Street Address Allowed Payment Methods/Modules

1 London Road CASH (cod)

this means anyone ordering from 1 London Road can only pay by CASH

the table will have all the columns and the last column will be Allowed Payment

# Street Address Email Address IP Address Tel Number Allowed_Payments

1 1 London Rd CASH

2 [login to view URL] CARD

3 71 Regent Rd 123456789 CASH

Example 3 is more strict

it says anyone living in 71 Regent Rd with phone number 123456789 can pay by CASH ONLY

ALL conditions for each case must be satisfied for the Payment filter to apply

case 1 and 2 are simple just 1 condition case 3 has two conditions

other casese may have more conditions point is ALL must be satisfied.

Note: Case sensitivity is not required infact dont use it please

NO TIME WASTERS this is a sensitive project and must be done perfectly

MySQL OSCommerce PHP

Project ID: #11692636

About the project