Bookkeeping module

[stagebrace]

dealbyethan.com;
Thank you for look at the design. Please note the program is far from complete. And I have not added any help or documentation files yet. Sorry, I am working on them.
Note: The project has been renamed to Zen Bookkeeping and is still in the form design state.

This version is a total remake of the code and how the layout is managed.

[stagebrace]

Update

• Forces SSL if its set to be used in configure.php
• Added "@" to all mysql functions.
• Removed "@" to all mysql functions.
• Added log file for errors.
• Makes the bookkeeping table `bk_expenses` if it has not been made already. (No SQL to upload by the user. The table may change soon to accept encrypted data)
• Shows customer data for an order number.
• Saves order number as secure cookie.
• Log in to Zen Cart, admin>tools>Bookkeeping
• Re add display for product sold for an order number
• Re add form for expense per order (with add a row button)
• Expense form multiplies the quantity and price then copies it to total.
• JavaScript table for account numbers and descriptions
• Account description populates the account number field
• Quantity, Unit price, and Line Total now calculate with onkeyup event
• encryption: The program will rely on SSL for security and privacy, it will not operate with out SSL.
• Project renamed to Zen Bookkeeping. New logo.

Help Needed

1. code check for cross and sql injection
2. look for issues with display
3. post any errors and error log.

Working on

1. Save expense form data.
2. design and create Vendor / Inventory expense input.
3. Reports
4. Instruction book

Attached Files

[beilana]

Stagebrace,

I am helping you on this module - but I don't yet have the answers for your last request for help.

I did want to tell you - I finally was able to get the "openbravo" up and running.


IT IS INCREDIBLE. TALK ABOUT POS - TINA's POS LINKS WITH IT AND IT WORKS GREAT.

THERE IS ONE VERY BIG PROBLEM THOUGH -

THE DATABASE IN THE MODULE IS RELATIONAL USING POSTGESQL.

AS YOU WRITE THIS MODULE - PLEASE KEEP IN MIND THAT WE WILL BE WANTING TO CROSS REFERENCE THE TWO DATABASES.

POSTGESQL is supposed to be much faster and state of the art open source.

I am trying to learn the JAVA as fast as I can so I can help out.

I will answer your call for help as soon as I get a chance.

[stagebrace]

PLEASE KEEP IN MIND THAT WE WILL BE WANTING TO CROSS REFERENCE THE TWO DATABASES

I do not understand this request.

[stagebrace]

Update version 1.00 (Alpha)

* Forces SSL if its set to be used in configure.php
* Added "@" to all mysql functions.
* Removed "@" to all mysql functions.
* Added log file for errors.
* Makes the bookkeeping table `bk_expenses` if it has not been made already. (No SQL to upload by the user. The table may change soon to accept encrypted data)
* Shows customer data for an order number.
* Saves order number as secure cookie.
* Log in to Zen Cart, admin>tools>Bookkeeping
* Re add display for product sold for an order number
* Re add form for expense per order (with add a row button)
* Expense form multiplies the quantity and price then copies it to total.
* JavaScript table for account numbers and descriptions
* Account description populates the account number field
* Quantity, Unit price, and Line Total now calculate with onkeyup event
* encryption: The program will rely on SSL for security and privacy, it will not operate with out SSL.
* Project renamed to Zen Bookkeeping. New logo.
* Saves expense form data.


Help Needed

1. code check for cross and sql injection
2. look for issues with display
3. post any errors and error log.



Working on

1. design and create Vendor / Inventory expense input.
2. Reports
3. Instruction book

[stagebrace]

A few bugs fixed

[ARRSE]

Hmm, not working for me at the moment but unsure why! You may also like to check out your error_log file on that latest download which contains the full path to your admin.