Find Jobs
Hire Freelancers

VERY URGENT: Website and database with ISAPI and DELPHI

$300-1500 USD

Cancelled
Posted about 18 years ago

$300-1500 USD

Paid on delivery
This is a project for which we had a service provider selected, but they didn't do anything and just let time pass. So now we are very in a hurry! READ THIS CAREFULLY: WE NEED THIS PROJECT TO BE COMPLETED 100% BY NO MORE THAN APRIL 23rd. THE TECHNICAL STRUCTURE OF THE DATABASE RELATED TO THE HTML HAS TO BE DONE BY THIS COMING SUNDAY APRIL 16th. Because of this urgency, we are provinding here with much info, so you can know and start thing ASAP: 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. A SmartCard 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 SmartCard Reader (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 directly in the websitem thru their ID. The SmartCard readers 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 main database for the purchases (read directly from the swiping of SmartCards) is being developed by our Systems Administrator in Borland's Interbase, so the website will have to connect with it. The database you develope must be in DB ISAM, with non-persistent queries and no mosaic. You give us the source code NOT COMPILED (we'll compile it). We won't use Microsoft databases (no SQL, no MySQL, etc.). --->>> All design will have to be done using ISAPI, and, very important, NO SCRIPT LANGUAGES. So you can NOT use asp, 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 and only 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 or branch). 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. ASSOCIATES (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. CARDREADER 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 VERY URGENT. This HAS to be developed maximum IN THE NEXT WEEK, with the database technical structure and relation to HTML done no longer than this coming sunday! We have the diagrams for the dataflow (see attached files) and an early predesign of the homepage, but need all the database structure ASAP! Please, POST A BID ONLY IF YOU TRULY CAN DO IT IN THIS TIMEFRAME!
Project ID: 55008

About the project

8 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
8 freelancers are bidding on average $1,263 USD for this job
User Avatar
I can provide you with the best solution in reasonable price. see pmb
$700 USD in 15 days
4.8 (93 reviews)
7.1
7.1
User Avatar
We will doing all that you want (and more... :-))). Quickly, Professional, Quality - our answer you and your organization. We work more than 5 years.. There are questions?
$1,500 USD in 35 days
4.3 (2 reviews)
5.9
5.9
User Avatar
Hi dear We are really interested to bid this project. We have highly expertised flash designers working in our Group. We are ready to provide an excellent flash design with Content Management System Like shopping cart. if u want to complete ur project in better way with full security i can do it. i m intersed for ur project . if u want contact me perssonally mrbrijesh(at)gmail . this is for contact. I read your request according to this i m agree with it . i want good relation, money is not major problem here i want to work with you. So I m waiting for ur kind reply hope that i will satisfy you and deliver ur project in time. Keep in touch Brijesh Mishra
$1,300 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings, we have reviewed your outsourced project description in depth. We're confident we can deliver a professional looking design(s) to match your concept. We have several URLs that we deem professional and we'd like to show them to you. We believe something to these standards will match the professionalism of your concept. We take great pride in our workmanship and we take our commitment to your project is of great consideration. We can deliver the functionality you desire from your web site with all the bells and whistles of interactivity with DHTML and Style Sheet technologies with feedback forms, auto-responders etc. The design of your web site will be 100% original with easy navigational features and clear layout so that your site extends your brand on the Internet. Depending on the targeted audience, your web site will be given a unique look to it - the color combination, graphics and design elements will depend on your targeted prospects. Having implemented over 500 web projects in the last 5 years, we believe we can leverage our rich experience to help you meet your business challenges and get more customers. We also have an extensive search engine optimization experience and can help you with a very strong marketing and search engine promotional strategy, which is essential for online success. If you have any queries, just send us a note through the Private Message Board. We guarantee quick replies, fast turnaround time and FULL customer satisfaction. Thanks and regards, Vikram Rokade
$1,200 USD in 12 days
0.0 (0 reviews)
4.8
4.8
User Avatar
Hi My name is Nirbhay and I have a company by the name of Certitude Softwares. Certitude Softwares is a website and software development company providing services to enterprises across the globe. We have gained unmatched experience in various business and technical domains. If you are really interested in getting your work done then plz contact us. Thanks
$1,201 USD in 21 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MEXICO
Cuernavaca, Mexico
0.0
0
Member since Sep 9, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.