Home

Welcome to your wiki!

This is the default page, edit it as you see fit. To add a new page simply reference it within brackets, e.g.: [SamplePage].

The wiki uses Markdown syntax.

Project Admins:

• Larry Judd

[Larry Judd]

New version using Bootstrap and PDO. Leaving old version on repos for those who may need to relaod some day but this new version, 1.3.0 should be more than a great replacement. The tables are the same but you will have to export the old MySQL tables and change out with the new. Themn replace your data. The new tables us INNOB.

[Larry Judd]

== Changle Log ==
v 1.3.1
08/09/2015

• fixed invoice insert into database page to return to a cleaner page
• added instructions
• cleaned print-header file

[Larry Judd]

New 2.0 is fully reworked so be careful if you are using your older version database data when loading the new 2.0 version. Backup your database and reload it after loading new tables into database. All fields are the same except at the end of table is a 'status' field. This will allow the new version to track paid invoices.

[Larry Judd]

NEW 3.0.0 is completely rebuilt!

Invoicing and Contacts program accessed from your web browser.

• Print from preview window.
• Bootstrap HTML5 - PDO - MySQL - PHP
• Log in secure sessions
• Menu driven selections to create new invoice and display current invoices.
• Adaptable CSS styles and @print @page calls for printing.
• Scheduler calendar and vendor, client, contacts directory
• Email invoice directly from page without exporting file

== Install
Must be installed on a server with PHP 5.2 or greater.
1 - Create database called cginvoice (for example)
2 - Extract files to folder on Apache Server/Linux/localhost
3 - Add tables to your database (PHPMyAdmin) from file ..../inc/cginvoice.sql*
4 - Add your database access information into inc/db.php
5 - Add your company address and info into the admin panel to configure emails and other company information.
7 - Put backlink to tradesouthwest.com somewhere on the net!

*The program was designed for MySQL but is written using PDO. Prepared statements used in all instances. Tables are altered to preserve PDO connection types.

== Usage
a) Navigate from side menu.
b) Reprint last will give you a copy of the last invoice you just put into the database.
c) View/Print lets you print an invoice and pulls up every customer on a single page
e) Print button at bottom of invoice sends the invoice to a preview page and then can be printed.
f) Instructions link in footer.

[Larry Judd]

3.0.01 CREATED A NEW VENDOR TEMPLATE AND ADDED SQL PASSWORD.
The password is in the readme file.