We have a cold fusion based application used to create a job ticket that is printed out. This job ticket contains all the information needed to produce a job in our shop. The ticket is passed around in a job bag with job assets inside of the bag.
To create a ticket the user basically enters data into an HTML form and the data is inserted into a database. When the ticket needs to be printed out we pull the data out of the database and populate an HTML page that can be printed. As our company has changed over the years more fields in the database have been added to support new sections on the ticket and more form fields have been added to the HTML forms to collect the new data. It has grown into a very clumsy way of storing the data and inputting/retrieving the data. We have hundreds of fields in the database. We have hundreds of HTML form fields. It is extremely hard to maintain now and make additions and changes to the ticket is a nightmare. I am looking for the following: 1) a better way for the user to create custom tickets that can be printed. They would be able to change the appearance of the ticket by themselves. They would not have to come to one of our developers to get a ticket changed. There needs to be some structure of course. They need to be able to select predefined products that we produce so they are not re-typing. 2) a better way of storing the data. Something that is free form and can except new data on the fly (I am thinking XML right now stored in a few fields of a database). 3) A better way of printing the information. Control of page breaks/pages so multiple pages can be printed (I am thinking PDF). If anyone has tackled such a web application and has some suggestions on how to solve these problems we have run into I would love to hear them. Thanks! Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241673 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
