Closed GoogleCodeExporter closed 9 years ago
@Vilem, set this to me, anyway you can also have a look.
Original comment by harald.g...@gmail.com
on 8 Jul 2012 at 8:44
Original comment by harald.g...@gmail.com
on 8 Jul 2012 at 8:46
cannot reproduce: * OpenBravoPOS saves ticket when changing from sales panel to
other panels (...) this does not work anymore.
Ticket is saved when leaving. When re-entering 'Sales', first ticket is loaded
from the list (see "bullet-list icon" for tickets) - so when are there more
tickets, odds are that you will need to enter this list & select other ticket
which you were working on...
Solution would be easy perharps - OTOH there will probably be none tickets
saved in the list - besides the ticket saved when leaving sales - so this is
probably minor problem...
Original comment by benes.vi...@gmail.com
on 9 Jul 2012 at 7:53
On my machine, ticket is only saved when paying.
Going to other menu entry loses ticket.
In the log, no SQL UPDATE is executed on leave, nor is a SELECT on TICKETS on
entry of the sales panel.
I wonder if there is an option to disable this. What could be the difference?
Original comment by harald.g...@gmail.com
on 9 Jul 2012 at 9:19
Is anything wrong with your db? Locked / read-only access? Something missing?
Did you interfere somehow with shared tickets (maybe JTicketsBagShared class)?
In db, there is 'sharedtickets' table with stored tickets. These (or one of
them) are loaded when switching back to 'Sales' (or when launching app). I
tried to delete the ticket (which was created after switching to 'Edit sales')
from this table. When i switched back, I had no ticket - but I saw in log many
other SQL queries (TAXES & others)...
Seems like the ticket is stored (when leaving 'Sales' or when closing app) in
shared tickets,
INFO: Executing prepared SQL: INSERT INTO SHAREDTICKETS (ID, NAME,CONTENT)
VALUES (?, ?, ?)
when returning, it is restored from there:
INFO: Executing static SQL: SELECT CONTENT FROM SHAREDTICKETS WHERE ID =
'84e851b1-f4f7-4f13-a734-5c1d07baf952'
INFO: Executing static SQL: DELETE FROM SHAREDTICKETS WHERE ID =
'84e851b1-f4f7-4f13-a734-5c1d07baf952'
----
Full log when change to 'Sales' (eg. fom 'Edit sales'):
Jan 25, 2013 12:49:08 AM com.openbravo.data.loader.StaticSentence openExec
INFO: Executing static SQL: SELECT ID, NAME, CATEGORY, VALIDFROM, CUSTCATEGORY,
PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME
Jan 25, 2013 12:49:08 AM com.openbravo.data.loader.StaticSentence openExec
INFO: Executing static SQL: SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME
Jan 25, 2013 12:49:08 AM com.openbravo.data.loader.StaticSentence openExec
INFO: Executing static SQL: SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID
Jan 25, 2013 12:49:08 AM com.openbravo.data.loader.StaticSentence openExec
INFO: Executing static SQL: SELECT CONTENT FROM SHAREDTICKETS WHERE ID =
'26a3aa3a-0c2d-47c5-bc6f-9b2a28e41be5'
Jan 25, 2013 12:49:08 AM com.openbravo.data.loader.StaticSentence openExec
INFO: Executing static SQL: DELETE FROM SHAREDTICKETS WHERE ID =
'26a3aa3a-0c2d-47c5-bc6f-9b2a28e41be5'
Jan 25, 2013 12:49:08 AM com.openbravo.data.loader.PreparedSentence openExec
INFO: Executing prepared SQL: SELECT P.ID, P.REFERENCE, P.CODE, P.NAME,
P.ISCOM, P.ISSCALE, P.PRICEBUY, P.PRICESELL, P.TAXCAT, P.CATEGORY,
P.ATTRIBUTESET_ID, P.IMAGE, P.ATTRIBUTES, P.PRICESELL_RECOMMENDED,
P.MANUAL_PRICE FROM PRODUCTS P, PRODUCTS_CAT O, PRODUCTS_COM M WHERE P.ID =
O.PRODUCT AND P.ID = M.PRODUCT2 AND M.PRODUCT = ? AND P.ISCOM = True ORDER BY
O.CATORDER, P.NAME
Jan 25, 2013 12:49:08 AM com.openbravo.data.loader.StaticSentence openExec
INFO: Executing static SQL: SELECT ID, NAME, CATEGORY, VALIDFROM, CUSTCATEGORY,
PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME
Jan 25, 2013 12:49:08 AM com.openbravo.data.loader.PreparedSentence openExec
INFO: Executing prepared SQL: SELECT ID, NAME, IMAGE FROM CATEGORIES WHERE
PARENTID IS NULL ORDER BY NAME
Jan 25, 2013 12:49:08 AM com.openbravo.data.loader.PreparedSentence openExec
INFO: Executing prepared SQL: SELECT ID, NAME, IMAGE FROM CATEGORIES WHERE
PARENTID = ? ORDER BY NAME
Jan 25, 2013 12:49:08 AM com.openbravo.data.loader.PreparedSentence openExec
INFO: Executing prepared SQL: SELECT P.ID, P.REFERENCE, P.CODE, P.NAME,
P.ISCOM, P.ISSCALE, P.PRICEBUY, P.PRICESELL, P.TAXCAT, P.CATEGORY,
P.ATTRIBUTESET_ID, P.IMAGE, P.ATTRIBUTES, P.PRICESELL_RECOMMENDED,
P.MANUAL_PRICE FROM PRODUCTS P, PRODUCTS_CAT O WHERE P.ID = O.PRODUCT AND
P.CATEGORY = ? ORDER BY O.CATORDER, P.NAME
Original comment by benes.vi...@gmail.com
on 25 Jan 2013 at 12:39
Works again, no idea what was wrong.
Let's ignore this as it wa sonly on my dev machine and now gone.
Original comment by harald.g...@gmail.com
on 2 Feb 2013 at 10:52
Original issue reported on code.google.com by
harald.g...@gmail.com
on 8 Jul 2012 at 8:44