Bookkeeping module

[stagebrace]

Reading from the database now.
Copy the folder "bookkeeping" into <your admin folder name>
example: www.somewhere.com/store/<your admin folder name>/bookkeeping
Then point your URL to the same as the example above and cycle through your customers using the form.

The current program requires you to have SSL at your domain. Not shared. This will get changed later.

Your comments please!

[stagebrace]

Java and JavaScript are not compatible.

[beilana]

The number system seems to work fine for selecting, but I do get an error shown bellow.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/beilana/public_html/cataloged/-----/bookkeeping/index.php on line

Am I supposed to give greater access to the file once ssl is in place? I imagine that the error is due to the fact that I can not sellect a customer because it is not seeing my database. Or is it?

[stagebrace]

Working on some SSL issues.
Please try again.

[stagebrace]

Update

• Forces SSL if its set to be used in configure.php
• Added "@" to all mysql functions. (don't understand what it does, but it fixed no connect issues)
• 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 some customer data for an order number.
• Saves order number as cookie (its the safest way to pass a JavaScript variable to a PHP variable)

Working on

1. Log in
2. browser and server based AES encryption based on Log in
3. Re add display for product sold for an order number
4. Re add form for expense per order (with add a row button)
5. Save expense form data after encryption.

[stagebrace]

Update

• Forces SSL if its set to be used in configure.php
• Added "@" to all mysql functions. (don't understand what it does, but it fixed no connect issues)
• 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 some customer data for an order number.
• Saves order number as cookie (its the safest way to pass a JavaScript variable to a PHP variable)
• 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)

Working on

1. Instruction book
2. browser and server based encryption (goal: all data from client to server and server to client to be encrypted. Considering the possibility to save the data encrypted)
3. Save expense form data after encryption.
4. Vendor / Inventory expense management
5. Reports

[stagebrace]

Update

• Forces SSL if its set to be used in configure.php
• Added "@" to all mysql functions. (don't understand what it does, but it fixed no connect issues)
• 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 some customer data for an order number.
• Saves order number as cookie (its the safest way to pass a JavaScript variable to a PHP variable)
• 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.

Working on

1. Instruction book
2. JavaScript table for account numbers and descriptions
3. browser and server based encryption (goal: all data from client to server and server to client to be encrypted. Considering the possibility to save the data encrypted)
4. Save expense form data after encryption.
5. Vendor / Inventory expense management
6. Reports