Transcript Project Presentation

E-Invoice System
CS541 Database Systems
Class Project
By: Parul Gupta
Overview
• Web based system developed using PHP( a
scripting language to manipulate the information stored in a database and to generate
the dynamic web pages) and MySQL.
• Billing system for a company with small sales
volume to help in maintaining the records of
products, customers and sales.
CS541: Database Systems
1
Overview contd...
• FEATURES:
– Create invoices in a quick and easy manner.
– Provides option to apply discount on individual
items, and calculates sales tax automatically.
– Quick search for past invoices, create report.
– In addition to creating invoices, also helps in
maintaining the Product and Customer Lists.
CS541: Database Systems
3
Database Schema
Items:
P_Code
Name
Price
Quantity Description Add_Date
Clients:
Name
Phone_ Company_ Shipping_ Billing_
No
Name
Address
Address
CS541: Database Systems
Email Fax
4
Database Schema contd…
Orders:
Invoice_
No
Invoice_ Due_Date Order_No Client_
Date
Name
Shipvia
PO#
Client_
Phone
Credit_Cardno Credit_3digit Credit_Exdate
OrderItemlines:
L_Code
Invoice_No P_Code Quantity
CS541: Database Systems
Discount
Note
5
PHP Functions
•
•
•
•
mysql_connect( ): Open a connection to a MySQL Server
mysql_select_db( ): Select a MySQL database
mysql_query( ) : Send a MySQL query
mysql_fetch_array(result): Returns a row from a recordset as
an array
• mysql_num_rows(result): Returns the number of rows in a
recordset
• mysql_real_escape_string( ): This function escapes special
characters in a string for use in an SQL statement
CS541: Database Systems
6
Main Screen Layout:
CS541: Database Systems
7
CS541: Database Systems
8
CS541: Database Systems
9
Future work
• Generate sales report based on items,
customer, daily, monthly and yearly sales.
• Ability to print and email the invoice to
customer.
CS541: Database Systems
10
References
•
•
•
•
•
•
•
•
http:// www.forperfect.com/cinvoice/
http://www.nstarsolutions.com/sis/(Snappy Invoice system)
http:// www.w3schools.com/php/php_mysql_intro.asp
http:// www.phpf1.com/tutorial/php-mysql-tutorial.html
http:// http://www.php.net/manual/en/
http://www.php.net/manual/en/
http:// www.glassybuttons.com
http://www/960.gs
CS541: Database Systems
11