I am currently developing an intranet/web based subscription application (using classic ASP and MS Access) to enable us to generate a csv file of payments due in the current month.
I have all of the data entry sorted and can generate the csv file but below is the bit i am having difficulty with.
The customers need to have an option of monthly, weekly and quarterly
the way i am intending to acheive this is by having the following tables.
The first will be the subscription table containg the fields:
(various user info fields), DateOfFirstPayment, DateOfPreviousPayment.
I think i will need to have a transaction table containing fields:
Customer, PaymentDueDate, (various user info fields). Hope that makes sense so far.
This is the required page/script i am having difficulty with:
I need an update page that will loop through the subscription table;
check if the DateOfPreviousPayment is empty if it is it needs to check if the
DateOfFirstPayment is in the current month and if it is perform the following actions:
update field in subsciption table DateOfPreviousPayment to DateOfFirstPayment and also insert a record into the transaction table
for the payment due. (company name, date of payment etc)
If when it checks the DateOfPreviousPayment it has a value it needs to check if the date is in the previous month and if it is change to current month and update the transaction table.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Classic ASP and MS Access Hosted on IIS