Learnings

Posted on

This post comprises the learnings gathered throughout the development of the nuvoPOS.

  1. javax.naming.NoInitialContextException  -> This error was encountered during the setup of JMS on Glassfish. The library gf-client.jar needs to point to the library in the Glassfish folder.

Reset all sales data

Posted on

How to reset all sales data in the nuvoPos database.

Open MySQL Workbench and create a new SQL queries.

Insert the following:

/* This sql deletes all transactions in nuvoPos */
/* Delete ticketlines before tickets for consistent constraints */
USE nuvopos;
delete from TICKETLINES;
delete from TICKETS;
delete from PAYMENTS;
delete from TAXLINES;
delete from RECEIPTS;
delete from CLOSEDCASH;
delete from STOCKDIARY;
delete from STOCKCURRENT;
delete from RESERVATION_CUSTOMERS;
delete from RESERVATIONS;
delete from SHAREDTICKETS;
update TICKETSNUM set ID = 0;
update PRODUCTS set STOCKCOST=0, STOCKVOLUME=0;
update CUSTOMERS set CURDEBT=0, CURDATE=null;

 

Execute the querie.

Restart nuvoPos.