Skip to main content
W
whitsunday_lad
Known Participant
February 25, 2010
Question

Can a web application do the following?

  • February 25, 2010
  • 2 replies
  • 776 views

Hi,

I have just finished building a web site for my business with basic content for marketing and 2 client functions that signs up new clients and sends them by email a copy of the document, and a form that lets the client load up over due debtors for our business to process.  (We are a slow or bad debtor collection service.)

Currently the application is using classic asp and a MS Access DB.  I want to change this to PHP and Mysql.  The DB is not normalized and I am redesigning that currently and I hope to get it to (3NF)

The DB is going to have a major over haul to provide functionality to automate and produce 10 to 15 standard legal documents that we file at the appropriate court of jurisdiction, plus support documents such as invoices to the client. 

I hope to have the data from the record sets in the Mysql DB populate different fields in a given document specific to the details of our client/plaintiff and the debtor/defendant.

Some of the more difficult automation functions will be related to a diary in the application, the diary will control when to produce a spesific legal document and file it at the court, I also need an input value such as the specific number of days after the clients last invoice to the debtor was sent, further interest calculations are needed to input the interest on the debt amount in the legal documents from when the debt was first due to judgment or final payment.  Currently this is worked out manually like this;

Number of days since invoice sent, Thursday 29th October 2009 to Friday 19th February 2010

3+ 30+31+31+19 = 114 days 

114 x 10 x 19,806.10 / 365 / 100 = $618.60 (Number of days x 10% interest x debt amount $19,806.10 /365/100)

The last thing is, after I build a web page interface into my site (a password protected admin area) to input above values can I out put the data from the web page to a standard Word or PDF document that can be printed or emailed and holding all the correct formatting?

Following below is one of the legal documents a statement of claim that will give you an idea of the complexity of automation and different data types that will have to be input and output from the Mysql DB to build the word or PDF document.

MAGISTRATES COURT OF QUEENSLAND

Cheers

Len O'Grady

This topic has been closed for replies.

2 replies

David_Powers
David_Powers
Inspiring
February 27, 2010

It's not quite clear what your question is, but MySQL and/or PHP can easily work out the number of days between certain dates, and calculate an interest amount. PHP can also generate PDF documents. What you're proposing is not a trivial task, and Dreamweaver won't automate any of the coding for you, but it can definitely be done.

W
whitsunday_ladAuthor
Known Participant
February 28, 2010

Hi David,

Thanks very much for that.  I am going to build an application for my site, probable in partnership with an industry professional in MySQL and PHP as I am a novice Dreamweaver MX user.  I need a back office application in my business site http://www.debtorstocash.com The new back office application will automate from a new MySQL DB with PHP.

The application will automate our business core functions as follows;

New client/plaintiff details from a form on my site http://www.debtorstocash.com/ssl/getauth.asp to input to my MySQL DB and email to me.

New debtor/defendant details from a form on my site http://www.debtorstocash.com/online.asp use my test login name: Len O'Grady Password: guest  You will be presented with a list of services on the next web page, select Upload debtors link and you will be presented with the upload debtors form with my test business details at the top of the form (this saves my actual clients the trouble of filling in their details) I want this form data to also input to my MySQL DB and email to me.

All the above data that has been uploaded to the MySQL DB has to be then checked against Australian government ATSIC DB as correct, the client data only once the debtor data in each legal matter.  (This will probable be done manualy)

I want to design and use an interface and the raw data above with further input data in the MySQL DB to automate every step of our collection process including building our legal documents in PDF format for filing at the courts via email.

This will probable be a 12 month project I will takle in small bites as I have a business to run but will be invaluable to the growth of my business.

I have MySQL and PHP but I am very much a novice with the aforementioned, the first project will be building the DB.

Can I get an industry professional such as you or another within this forum to work on a contract rate to help with the coding that is out of my experience, and also assist in tutoring me with the coding I can manage as I am most interested to learn?  Or is this forbidden?

Can you recomend tutorials for above and coding examples close to what I am trying to build?

Cheers

Leonard P.O'Grady

David_Powers
David_Powers
Inspiring
March 2, 2010

whitsunday lad wrote:

Thanks very much for that.  I am going to build an application for my site, probable in partnership with an industry professional in MySQL and PHP as I am a novice Dreamweaver MX user.

The PHP code generated by Dreamweaver MX is out of date and insecure. You must use Dreamweaver 8.0.2 or later.

The project that you envisage is quite complex, even for a professional. It's not something that should be undertaken lightly.

Can I get an industry professional such as you or another within this forum to work on a contract rate to help with the coding that is out of my experience, and also assist in tutoring me with the coding I can manage as I am most interested to learn?  Or is this forbidden?

There is nothing wrong with contracting a member of this forum to undertake work for you. Unfortunately, I'm not in a position to undertake such a project at the moment.

Can you recomend tutorials for above and coding examples close to what I am trying to build?

The first thing you need to do is to get a solid understanding of PHP and MySQL. I would not recommend relying on Dreamweaver's automatically generated code (server behaviors) for this sort of project. I have written a number of books about PHP/MySQL. Some show how to customize Dreamweaver code. Others, such as "PHP Solutions", teach you how to hand-code. PHP Solutions might help you get started, but a more in-depth book, such as "PHP and MySQL Web Development" by Wellings and Thomson, might be better.

You have a long journey ahead of you. Good luck.

W
whitsunday_ladAuthor
Known Participant
February 25, 2010
Please download the attached file to view this post
Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices