ASP Recurring Billing Help

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.

## Deliverables

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).

## Platform

Classic ASP and MS Access Hosted on IIS

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Veja mais: ms access form data entry, ms access data entry form, intranet ms, BILLING DATA ENTRY, customer help, classic name, billing web-based, web based data entry form access, intranet access, classic asp install, application page data entry, actions form asp, classic asp user, customer billing php, billing software access, program script data entry, classic asp required field, classic asp php, help package file, loop table, asp working iis, script due date, classic asp 2008 server, desktop asp application, value engineering

Acerca do Empregador:
( 1 comentário ) United Kingdom

ID do Projeto: #3061344

Concedido a:


See private message.

$85 USD em 2 dias
(7 Comentários)

7 freelancers are bidding on average $140 for this job


See private message.

$178.5 USD in 2 dias
(266 Comentários)

See private message.

$216.75 USD in 2 dias
(121 Comentários)

See private message.

$204 USD in 2 dias
(20 Comentários)

See private message.

$127.5 USD in 2 dias
(11 Comentários)

See private message.

$85 USD in 2 dias
(3 Comentários)

See private message.

$85 USD in 2 dias
(1 Comentário)