Design website using ISAPI

This is a project for a guru website programmer who wants to showoff his/her expertise.

We need a website designed for a new project which will involve access for 1. Potential customers (public access), 2. Actual customers (limited access via password), 3. Potential distributors (public access), 4. Actual distributors (limited access), 5. Potential direct salespersons (public access), 6. Actual direct salespersons (limited access), and 7. Establishments wanting to register to get a card-reading machine (see below for an explanation of products).

The products are two: 1. An intelligent card with a chip that has stored the information about the person necessary to print a receipt for every purchase made (in Mexico, the only way to have a deductible purchase for tax matters is if we have a physical printed receipt with all our fiscal info on it). 2. The reading machine (kind of the machine that swipes credit cards) that reads the cards and prints the fiscal receipt.

The cards will be sold by direct salespersons in a two-tier sales system. Or directly in the website.

The reading machines will be sold by distributors, divided by regions.

Mainly, we can design and develop the webpages and the graphical aspects of our site (the presentation page, sales page, contact page, registration, etc.), but we need help in developing the databases, the relations between the databases and the webpage, and the online, real time actualization of the site.

The databases will be developed by our Systems Administrator in Borland's Interbase, so the website will have to connect with it. We won't use Access nor SQL, so please YOU don't quote your work thinking of using them.

--->>> All design will have to be done using ISAPI, and, very important, NO SCRIPT LANGUAGES. So you can NOT use asp, java, PHP, etc.

All of these will be exclusively for Mexico. So, we need the site to be in Spanish. We won't attend international clients, since our product is specifically developed for the fiscal laws in Mexico, applying only to Mexican citizens doing business in our country.

Let me tell you about the different limited areas of the website (where you'll have to program the access and the databases):

CUSTOMERS

Customers can be 1. Individuals, 2. Businesses with one master customer and several customers in one location, or 3. Corporations with lots of customers in several locations (with one master customer in each location).

Only individuals and master customers can access the limited areas of the website. There, mainly they can access their history of purchases made (date, amount, tax, name and address of the establishment or store). For master customers, this will be done for all their company, for location, for city and for every individual customer. They can filter the purchases reports by establishment, date, city, customers, etc.

SALESPERSONS

In their exclusive access area, they can view their own sales, the sales of the salespersons in their organization (2-tier), if they already met the minimum quota for each month (20 individual sales), the comission already made, the contact data of their downline. So, in essence, is access to the database of sales and downline.

DISTRIBUTORS

The area is the same as the salespersons' but they won't have a downline organization. They can have access to their sales, clients data, commisions, etc.

Now, for the INTERESTING PROGRAMMING:

This is the most important part of this project:

Once a customer (individual or master customer) clicks to register to buy their card(s), the system will have to do several things:

On the customer's end:

1. To buy, they must enter the password of the salesperson who referred them to the site. Or, enter the corporate password. Then, show the registration page, for the person to input all his/her data.

2. Save their data and assign a personal key in case they need to close the page and return later (so, they won't have to reenter all their info). For an individual this is not too much of a problem, but it is if it's a master customer registering all their locations and customers.

3. Show a personalized quote for their purchase, showing amount per customer and per location, tax and shipping costs.

4. Ask if they want to use a credit card or a direct bank deposit for their purchase or if they want to pay later (especially in case of corporate customers). If it's a credit card, show the page with the credit card info necessary to authorize the card.

5. If it's direct bank deposit, show a printable pop-up with the actual deposit slip, with all theirs and the bank's data already there. Especially, it will have to connect with our bank system to generate what is called a "Reference Number" so the system can know when they deposit and can determine to whose purchase it corresponds.

6. If it's a master customer of a company with different locations, ask if they want their cards shipped to one location or to every location.

7. Show all the data entered to be reviewed and approved. The master customer can assign privileges for every customer (delete, edit, add info).

On our end:

8. When the credit card is approved or the deposit is thru, then the system will instruct the printer (a machine, not a person) to print the card(s). They are personalized with a key number, their name and valid dates (like a credit card).

9. Print the shipping label(s) to ship the card(s)

10. Print the receipt with all the fiscal data (already stored). Send a confirmation email to the customer and send the physical receipt along the cards.

11. Actualize the customers database with a new customer or customers data; actualize the sales database with the sales data, so the salesperson and their upline can check their statistics on their webpage; actualize the comissions table with the sales data, to be paid to the salesperson and their upline.

12. Once per month, check who of all the salespersons complied with their requisite in order to earn comissions. Run the comissions program to determine the actual comissions. List all the people to be paid. Generate and print the checks to be paid. Actualize the accounting and fiscal systems.

13. Once per day or once per week (we haven't yet determined this period, but probably will be daily), connect to the main database to retrieve the movements of the day relating to the use of the cards and actualize the customer database, so they can log in and check all their movements.

That's the flow of information and the desired outcomes. Probably we'll need some other along the development of the project, but having the databases in place, this will be only a matter of designing tables and formats.

The timeframe for this project is urgent. This HAS to be developed maximum in the next 2 weeks.

Delphi Website Design

Project ID: #49858

About the project