Find Jobs
Hire Freelancers

Coupon Validation

$20-100 USD

Fermé
Publié il y a environ 19 ans

$20-100 USD

Payé lors de la livraison
I am looking for some help on a internal Intranet form for database entry. I currently have an Excel worksheet (macro) that works as follow: A magnetic card swipe inputs customer # into an input text field which dumps it into a column, then a barcoded coupon is scanned and enter into another column in the same manner. The two are then merged into a third column,it combines the two as a unique combination. So, if a customer trys to use the same card # and barcoded coupon again it is rejected as already being redeemed.. There is also a time/date stamp added to each entry in a new column, as well as a machine ID entry into a new column for location where it was redeemed in the store. The current Excel based Coupon validation System also tracks customers who attempt to abuse the system, by popping up a warning message that a coupon has been redeemed, then copying thier card # and coupon code to an "abusers" page in the spreadsheet.. In the final workbook we have a redeemed page, and an abusers page with the following info: CARD#|COUPONBARCODE|CARD#&BARCODECOMBINED|TIMESTAMP|L0CATION| This info is inserted into the redeemed page by an Excel Form, and then is also inserted on to the abuse page in the same format when a duplicate CARD# & BARCODE combination is entered. So when we are harvesting data we get a listing of all coupons redeemed, by date and time and promo barcode. As well as customers who would potentially abuse the system. It seems the same Card#s pop up frequently on the abuse page. It makes it easier for us to identify those problem customers. This does work rather effectively; there are some sharing issues that pop up from time to time. One of the features I would like to add is a validation by time/date stamp and Customer Card ID, so a customer can only redeem one bar-coded coupon per day. If the same acct# is entered on same business day it will popup an error message to the data entry person stating another coupon already redeemed that day. There might be as many as 2-3 valid coupons at any given time. some with an option of a one time use coupon, another for a specific date, another perhaps that can be redeemed only on a weekly basis, or a once a year coupon as in a birthday or anniversary promotion, etc.. The excel system with the card swipe and barcode validation combination has cut down on the amount of abuse by some of the umm? Shadier customers. I am looking on how to convert this to PHP/HTML to dump into a MYSQL Database. I think this would eliminate the sharing issues, plus be easier to query for data harvesting on the back end. I want to eliminate the file sharing issues of excel, and have a friendlier interface for employees to use. I currently have a system running winxp pro with IIS and PhP 4.39 with latest MySql version. Our business day runs differently then the standard calendar day, we use from 7:00am-7:00am as our business day. I can zip all the files I have so far and email them for review to and whom ever is interested. This is meant to be an internal data entry platform only. I am wanting a SUPER version of MS access for data entry with damn near unlimited potential. Thanks for any help in advance, Sam Shinn
N° de projet : 10214

Concernant le projet

5 propositions
Projet à distance
Actif à il y a 17 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
5 freelances proposent en moyenne $100 USD pour ce travail
Avatar de l'utilisateur
Dear sir, pls check pmb,thanx
$100 USD en 18 jours
4,4 (38 commentaires)
7,6
7,6
Avatar de l'utilisateur
Hello, your task sounds interesting. I would like to provide a cost-efficient solution for the php/mysql transformation of your macro. I can have this done professionally in a timely fashion. Please contact me if your interested and we can discuss the details.
$100 USD en 7 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
we can do it
$100 USD en 5 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
we can do it.
$100 USD en 5 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED STATES
Ferndale, WA, United States
0,0
0
Membre depuis déc. 27, 2004

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.