Bookkeeping module

[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

[landshark]

Yeah, Quickbooks is way powerful and constantly updated. And isn't there already a way to sync Zencart with it?

But using Quickbooks as a POS is a POS, from what I understand. And this is *exactly* what I've been searching for. Inventory control and POS from Zencart for our physical brick-and-mortar store. From what I can tell, doesn't quite exist yet for Zencart. All the parts are there, they just haven't quite been put together.

My thought is to code up a 'Register' module accessed from the admin screen. People would sign on to the Admin account, then open up the Register module and everything they need to sell things to physical customers would be right there.

What do you guys think? We have a couple coders and a fair amount of free time. Where should we begin?

Craig Rickel
Tech Gurus

P.S. I tried out that CK-ERP thing, and it seemed both highly user-unfriendly and ... er... broken. ' Please inform System Admin: /ck-css/reportfilter.php MD5 checksum failure' was all I got on most pages.

I came across this in a search similar to yours ollacart-pos.com/ haven't played with it much but it looks promising.

[stagebrace]

I made a goal to pass an encrypted string from the server to the client. This was not as easy at it may sound. First I had to decide what encryption to use. There are thousands to choose from. AES is said to be the best. XXTEA is said to be good enough for most needs. I chose XXTEA. Then I was off to find a compatible PHP and JavaScript version. After days of playing and searching I found then at
http://www.coolcode.cn/?p=128&pp=2 and http://www.coolcode.cn/?p=128&pp=3
They are free to distribute and the logic has no patent.
Now I will be able to privately transmit all bookkeeping values with or without SSL. Chances are the values will be stored encrypted also. It will take a little more database memory but for privacy, its worth it.

[beilana]

Excellent!

INTERESTING INFORMATION...

I have installed several of the free POS systems. Most have been old and ineffective, but there is one in particular that seems VERY interesting. I am loading it onto my home computer because I do not have the latest versions of the software on my server.

It is called "Openbravo" and it already seems to do just about everything linking to a fully expandable network. It merges seemlessly with Tina POS which is opensource and has inventory management, graphs and everything. Tina POS also works with touch screens, UPCs scanning, and even phone sales. It also has security, and a great - user-friendly look for employees.

Here is the site to run the on-line preview and get to the downloads section:

http://www.openbravo.com/index.php?o...244&lang=en_US

At the very least, I think we will be able to port a lot of open source code from this set-up.

Infact, I am almost thinking we should be working on linking it to Zencart. It is a bit of a bear to set up though because you need so many other modules downloaded.

Apache Ant, Java JDK and EE, MySQL, PostgrelSQL or Oracle, Tina POS, the Openbravo itself consists of many modules (Accounting, Backoffice, Warehouse, ERP, CRM, Sales Accounts, etc) ALL OPENSOURCE...

I think the reality is that NO SOFTWARE IS AN ISLAND. You either learn to merge with the many great other open source softwares out there or die. I really think we should help zencart talk to this system - IT LOOKS TO BE THE BEST OPEN SOURCE POS GOING AND COULD LIKELY KNOCK-OUT PLAYERS LIKE QUICKBOOKS IN THE NEAR FUTURE.


Ler me know what you think.

[stagebrace]

Update

• Forces SSL if its set to be used in configure.php
• Added "@" to all mysql functions.
• 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.
• 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

Working on

1. add try catch and log errors to file
2. Instruction book
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