View Full Version : Cash Register SQL database
11-09-2007, 11:36 AM
ok i have a data base for my products and i can use it as i would a cash register but i would like for it to print it like an invoice on a template without having the invoice ready printed before hand is there a way to add the template so when i press save and print it prints all the structure and info on a blank page
11-09-2007, 12:37 PM
you want it to print in a template but not in a template? umm thats confusing.
if you are using some type of server-side coding such as PHP you can save the products to a session "shopping cart" and when the user saves the page it can be put into a cookie and/or print you can create a default structure of how to print the page.
if thats not what you are looking for can you please explain it again?
11-10-2007, 07:39 PM
yes that is very helpful thank you but you miss understood
Right at this moment in time i have invoices printed templates and i have to organise data each time and i would like to get this set up as an SLQ or MySQL database
what i want to do is some how store the template in and when i input data it will print data + template eliminating the printed invoice templates i pay for to get done
so in a way i would like to make an SQL database work like a cash register so when i input data like address phone number and other fields it would print on an A4 Sheet of paper with an invoice template so the A4 Page is blank when i place it in the print fead tray
11-12-2007, 03:14 AM
oh well that is just a matter of creating the database how you want it... then creating a html template and a stylesheet for online viewing... if you need help with your database design we would need to know the fields you want in your database (info you will store)
11-22-2007, 01:05 PM
Price Ex VAT
these are the fields that i have written on the Invoice and i would like to make into a database
VAT is a Value Added Tax in ireland on goods and services 21% on a product and about 15% on a service
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.