0.8 Released

New release 0.8 is named persa.
This is an early release due to the situation I live now. I decided to release it as is because i will be offline in my house, and will look for a connection outside from time to time.

Update: I have gotten a paypal account, as some people suggested, and now i can receive donations. Here is the link:
Donate

Release 0.7.3 and starting new features

Yesterday was released the 0.7.3 version with some fixes.

From now, Im starting to incorporate new features that users requested. This requieres some big changes to the database structure, and starting at SVN revision 285 I have introduced new tables that will replace some fields from the products table. So I advice you to use SVN revision 284 or the 0.7.3 release. The SVN always has new code that im testing and may not always work as it should -now it has a floating toolbar for product filters that does not work-.

The big change Im working is to support different stores with a single stock managment from which a product could be sold from a different location -store,warehouse-. Also, a product could have peculiarities that differentiate from the same product, such as color and sizes, having the same code -and price,cost,etc-.

So, there are good things to come, stay tunned.

mailing list, trac and releases

I have released 0.7.1 and 0.7.2 and do not post about. These versions fixes a couple of bugs reported by users, there is a new release coming soon with another fixes.

I have setup a mailing list for lemonpos in sourceforge, the list info page (for subscription) is here:mailing list

Also, I decided to use trac instead of tracker for bug reports and feature requests. Of course trac also provides a timeline view -from svn commits-, roadmap and source -svn- browse. For bug reports and feature request create new tickets. Go trac

And of course, the wiki is here.To edit the wiki, you need to be a sourceforge user -registered- (i have not test it with another account, someone comfirm this), i cannot enable edit for anonymous -sourceforge limitation-.

Version 0.7 released!

After some days doing checks -i found a crash- finally i have release the 0.7 version.

I want to thank David Plater for reporting the bug at database-creation-script and Biel Frontera for his contributions to this version.

There are new features and bug fixes as shown in the changelog:

General:
– Added Catalan translation (ca.po).

Lemon:
– BUGFIX: regexp for payment input (1…20, now only one ‘.’ is allowed)
– BUGFIX: ticket Alignment done (printTicket) [patch by Biel Frontera]
– BUGFIX: added a missing i18n at line 1392 [patch by Biel Frontera]
– BUGFIX: At search items, when doubleclicked on an already inserted product, the search panel is not closed.
– BUGFIX: Double clicking on any product in shopping list that is sold by pieces is not incremented.
– Improvement: ENABLED Cash Drawer openning. Added an option to enable at configuration.
Can someone test this? I dont have a cash drawer.
– Improvement: Transaction cancel now saves cashout, substract client points, restore stockqty for sold products.
Also does not allow ticket cancelation on already canecelled tickets, and when there is not enough cash in drawer.
– Improvement: Changed the way to search items with the priceChecker; now an ‘enter’ is requiered, resulting an improved
usability when using a barcode reader.
– Improvement: Dont close purchase dialog on return pressed on any widget to improve usability for barcode reader.
– Added Feature: support for item qty in code input. Example: 10×123456 means 10 units of the product which code is 123456.
– Added Feature: Now in every transaction items and its price/discount are saved in the database
to preserve the data at which they were sold. [patch by Biel Frontera]
– Added feature: one more filter to product grid filters: most sold products [by Biel Frontera]
– Added feature: Reprint Ticket [Adapted from Biel Frontera code ]
– Added feature: Change sale date (to register old sales that were not registered before) [Adapted from Biel Frontera code ].
– Added feature: Cash-Out. To take out money for payments at the POS.
– Added Feature: Now lemon does not quit if not connected to mysql, a config dialog for database is shown.
– Added Feature: A low level cash in drawer alarm. A config option for showing the alert and minimum value.
– Added Icons: cash-out, re-print ticket, balance.

Squeeze:
– BUGFIX: Preferences disabled/enabled when requiered.
– BUGFIX: Spanish Translation fixed for the filter ’show only not empty transactions’.
– BUGFIX: PurchaseEditor changed focus to empty fields when entering ‘Items Per Box’ qty. This is giving the
impression of not allowing more than 1 digit at the qty. [thanks for the report to Dave Plater]
– Added Feature: New report for cash-outs.
– Added Feature: New field in the offers editor to allow calculation of offer-percentage with the price entered
So now offers can be calculated with price or percentage [by Biel Frontera]
– Added Feature: Now squeeze does not quit if not connected to mysql, a config dialog for database is shown.

Database:
– New TransactionItems table, adapted code at finishCurrentTransaction() and others [ by Biel Frontera ]
– Changed collates from ‘utf8_spanish_ci’ and ‘latin1_general_ci’ to ‘utf8_general_ci’.

Azahar:
– BUG FIX: at SQL quieries: getAlmostSoldOutProducts,getTop5SoldProducts…
– Added some methods for future use at squeeze, regarding new tables and fields. [by Biel Frontera]

New release, 0.6.1 version!

The 0.6.1 version is now available at sourceforge download page.

Plots and piecharts

Here is the changelog:

CHANGELOG FOR LEMONPOS VERSION 0.6.1 (SVN revision 198)
—————————————————–

Hotest new stuff:
– Qick-View Plot reports [Welcome screen - Quick Information]. Just information on sales, profit, most sold products and low stock.
– Transactions and Balances table viewer (Without filters).

General
– Introducing the new azahar class to provide all database access.
– Code cleaning completed (generating the new azahar class).
– New offers system, with date start and date end.
– Created three new icons (categories, offers, price-checker).
– Low security mode.
– Azahar code improved (removed some for/while unnecessary loops, some missing values when updating data). Thanks to Biel Frontera from Spain, whom found the bugs and sent me the patches.
– Adding terminalnumber field for balances.

Squeeze:
– BUG FIX: Newly created categories not appearing in products filter’s combobox.
– BUG FIX: Categories now can be deleted.
– New filters for products (offers dates – by diferent ways).
– Graphic bar for discounted percentage of a product at the offers’ table view.
– A purchase action, to check-in stock purchases.
– Qick-View Plot/pie-chart reports [Welcome screen - Qick Information]. Just information on sales, profit, most sold products and low stock.
This may have some bugs (in fact, it has).
– Added login.
– Added style support.
– Implemented a new left menu bar.
– Changed the way to insert a category.
– Changed the way to insert a weight or measure.
– Spanish Translation (es.po) Updated.
– Low Stock Alert min and max values (used for piechart for now).
– Added one more filter for Products (almost sold-out items).
– Added viewing product list as grid/table at your option. This for better view when filtering.
– Added basic Transactions table-viewer (just a list with transactions, with filters)
– Added basic Balances table-viewer (just a list with balances, no filters yet)

Lemon:
– BUG FIX: now lemon stores sold units and date last sold at each sale.
– BUG FIX: A workaround for the oxygen bug for login/password dialog.
– BUG FIX: automatic showGridView button’ checked state is now working as expected.
– BUG FIX: ticket# validator When cancelling a ticket let enter no other than 0’s.
– BUG FIX: Disabled action “Start Operation” even if action is cancelled by te user. This prevented to start operations.
– BUG FIX: An issue was detected when testing with KDE 4.2, ticket dialog was not shown.
– Spanish Translation (es.po) updated.
– Improved loginwindow appearance, changed password dialog background.
– Improved login background, including lemon version.
– Added and themed a Price Checker for consulting product prices without adding to the list.
– Low Stock Alert min and max values (used at search)
– Low security mode (do not ask passwords).
– Saving balances on quit.
– Saving terminal number of each balance.
– Adding a configuration option for the time showing the ticket dialog on screen.

Database:
– Removed old sample data.
– Added database creation script to the instalation, installed in /usr/share/apps/lemon/
or /usr/local/share/apps/lemon/ depending on your system and configuration;
This will help ubuntu package’s users
– Added terminalnum flied to balances table (of course to database creation script).
– Adding new tables to save strings for pay-types, transactions-types, transactions-states.
– Adding an upgrade script, to upgrade your database from 0.5 to 0.6 version of lemon POS.
– Changing transaction state ids to start at 1 (not at 0). Mysql refused to insert a new record with 0 in the id. All code related was changed too. If you have a populated database with old transactions types ids, change all id=0 to 1, id=1 to 2, id=2 to 3.

Release 0.5

Version 0.5 has been released.
Includes a fix to a crash when mysql was not running, the improved UI for the main window, the filter for offers and the validation of dates for offers.

New Release!

There is a fourth beta release!

• Adds improvements to squeeze, such the purchase action which is used to add products to the stock and store purchase log for further usage.
• Adds some verification functions to each editor, to prevent entering blank users/clients, duplicate/overwrite products and delete default measure/client.
• Redesign of the product editor, now it has a better look/usage, less fields (not needed were gone).
• Some new icons and general code review.
• Lemon now support clients with discounts.