@Override public void init(Session s) { m_sInitScript = "/com/openbravo/pos/scripts/" + s.DB.getName(); m_dbVersion = s.DB.getName(); m_version = new PreparedSentence( s, "SELECT VERSION FROM APPLICATIONS WHERE ID = ?", SerializerWriteString.INSTANCE, SerializerReadString.INSTANCE); m_dummy = new StaticSentence(s, "SELECT * FROM PEOPLE WHERE 1 = 0"); final ThumbNailBuilder tnb = new ThumbNailBuilder(32, 32, "com/openbravo/images/sysadmin.png"); peopleread = new SerializerRead() { @Override public Object readValues(DataRead dr) throws BasicException { return new AppUser( dr.getString(1), dr.getString(2), dr.getString(3), dr.getString(4), dr.getString(5), new ImageIcon(tnb.getThumbNail(ImageUtils.readImage(dr.getBytes(6))))); } }; m_peoplevisible = new StaticSentence( s, "SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE VISIBLE = " + s.DB.TRUE() + " ORDER BY NAME", null, peopleread); m_peoplebycard = new PreparedSentence( s, "SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE CARD = ? AND VISIBLE = " + s.DB.TRUE(), SerializerWriteString.INSTANCE, peopleread); m_resourcebytes = new PreparedSentence( s, "SELECT CONTENT FROM RESOURCES WHERE NAME = ?", SerializerWriteString.INSTANCE, SerializerReadBytes.INSTANCE); Datas[] resourcedata = new Datas[] {Datas.STRING, Datas.STRING, Datas.INT, Datas.BYTES}; m_resourcebytesinsert = new PreparedSentence( s, "INSERT INTO RESOURCES(ID, NAME, RESTYPE, CONTENT) VALUES (?, ?, ?, ?)", new SerializerWriteBasic(resourcedata)); m_resourcebytesupdate = new PreparedSentence( s, "UPDATE RESOURCES SET NAME = ?, RESTYPE = ?, CONTENT = ? WHERE NAME = ?", new SerializerWriteBasicExt(resourcedata, new int[] {1, 2, 3, 1})); m_rolepermissions = new PreparedSentence( s, "SELECT PERMISSIONS FROM ROLES WHERE ID = ?", SerializerWriteString.INSTANCE, SerializerReadBytes.INSTANCE); m_changepassword = new StaticSentence( s, "UPDATE PEOPLE SET APPPASSWORD = ? WHERE ID = ?", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING})); m_sequencecash = new StaticSentence( s, "SELECT MAX(HOSTSEQUENCE) FROM CLOSEDCASH WHERE HOST = ?", SerializerWriteString.INSTANCE, SerializerReadInteger.INSTANCE); m_activecash = new StaticSentence( s, "SELECT HOST, HOSTSEQUENCE, DATESTART, DATEEND, NOSALES FROM CLOSEDCASH WHERE MONEY = ?", SerializerWriteString.INSTANCE, new SerializerReadBasic( new Datas[] { Datas.STRING, Datas.INT, Datas.TIMESTAMP, Datas.TIMESTAMP, Datas.INT })); m_insertcash = new StaticSentence( s, "INSERT INTO CLOSEDCASH(MONEY, HOST, HOSTSEQUENCE, DATESTART, DATEEND) " + "VALUES (?, ?, ?, ?, ?)", new SerializerWriteBasic( new Datas[] { Datas.STRING, Datas.STRING, Datas.INT, Datas.TIMESTAMP, Datas.TIMESTAMP })); m_draweropened = new StaticSentence( s, "INSERT INTO DRAWEROPENED ( NAME, TICKETID) " + "VALUES (?, ?)", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING})); m_locationfind = new StaticSentence( s, "SELECT NAME FROM LOCATIONS WHERE ID = ?", SerializerWriteString.INSTANCE, SerializerReadString.INSTANCE); resetResourcesCache(); }
/** @param s */ @Override public void init(Session s) { m_sInitScript = "/uk/chromis/pos/scripts/" + s.DB.getName(); m_dbVersion = s.DB.getName(); m_version = new PreparedSentence( s, "SELECT VERSION FROM APPLICATIONS WHERE ID = ?", SerializerWriteString.INSTANCE, SerializerReadString.INSTANCE); m_dummy = new StaticSentence(s, "SELECT * FROM PEOPLE WHERE 1 = 0"); final ThumbNailBuilder tnb = new ThumbNailBuilder(32, 32, "uk/chromis/images/sysadmin.png"); peopleread = new SerializerRead() { @Override public Object readValues(DataRead dr) throws BasicException { return new AppUser( dr.getString(1), dr.getString(2), dr.getString(3), dr.getString(4), dr.getString(5), new ImageIcon(tnb.getThumbNail(ImageUtils.readImage(dr.getBytes(6))))); } }; // ******************************************************************* productIdRead = new SerializerRead() { @Override public String readValues(DataRead dr) throws BasicException { return (dr.getString(1)); } }; m_getProductAllFields = new PreparedSentence( s, "SELECT ID FROM PRODUCTS WHERE REFERENCE=? AND CODE=? AND NAME=? ", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING}), productIdRead); m_getProductRefAndCode = new PreparedSentence( s, "SELECT ID FROM PRODUCTS WHERE REFERENCE=? AND CODE=?", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING}), productIdRead); m_getProductRefAndName = new PreparedSentence( s, "SELECT ID FROM PRODUCTS WHERE REFERENCE=? AND NAME=? ", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING}), productIdRead); m_getProductCodeAndName = new PreparedSentence( s, "SELECT ID FROM PRODUCTS WHERE CODE=? AND NAME=? ", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING}), productIdRead); m_getProductByReference = new PreparedSentence( s, "SELECT ID FROM PRODUCTS WHERE REFERENCE=? ", SerializerWriteString.INSTANCE // (Datas.STRING) , productIdRead); m_getProductByCode = new PreparedSentence( s, "SELECT ID FROM PRODUCTS WHERE CODE=? ", SerializerWriteString.INSTANCE // (Datas.STRING) // , new SerializerWriteBasic(Datas.STRING) , productIdRead); m_getProductByName = new PreparedSentence( s, "SELECT ID FROM PRODUCTS WHERE NAME=? ", SerializerWriteString.INSTANCE // (Datas.STRING) // , new SerializerWriteBasic(Datas.STRING) , productIdRead); // ****************************************************************** m_peoplevisible = new StaticSentence( s, "SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE VISIBLE = " + s.DB.TRUE() + " ORDER BY NAME", null, peopleread); m_peoplevisibleByRights = new StaticSentence( s, "SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE RIGHTSLEVEL > ? AND VISIBLE = " + s.DB.TRUE() + " ORDER BY NAME", SerializerWriteString.INSTANCE, peopleread); m_peoplebycard = new PreparedSentence( s, "SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE CARD = ? AND VISIBLE = " + s.DB.TRUE(), SerializerWriteString.INSTANCE, peopleread); m_resourcebytes = new PreparedSentence( s, "SELECT CONTENT FROM RESOURCES WHERE NAME = ?", SerializerWriteString.INSTANCE, SerializerReadBytes.INSTANCE); Datas[] resourcedata = new Datas[] {Datas.STRING, Datas.STRING, Datas.INT, Datas.BYTES}; m_resourcebytesinsert = new PreparedSentence( s, "INSERT INTO RESOURCES(ID, NAME, RESTYPE, CONTENT) VALUES (?, ?, ?, ?)", new SerializerWriteBasic(resourcedata)); m_resourcebytesupdate = new PreparedSentence( s, "UPDATE RESOURCES SET NAME = ?, RESTYPE = ?, CONTENT = ? WHERE NAME = ?", new SerializerWriteBasicExt(resourcedata, new int[] {1, 2, 3, 1})); m_rolepermissions = new PreparedSentence( s, "SELECT PERMISSIONS FROM ROLES WHERE ID = ?", SerializerWriteString.INSTANCE, SerializerReadBytes.INSTANCE); m_changepassword = new StaticSentence( s, "UPDATE PEOPLE SET APPPASSWORD = ? WHERE ID = ?", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING})); m_sequencecash = new StaticSentence( s, "SELECT MAX(HOSTSEQUENCE) FROM CLOSEDCASH WHERE HOST = ?", SerializerWriteString.INSTANCE, SerializerReadInteger.INSTANCE); m_activecash = new StaticSentence( s, "SELECT HOST, HOSTSEQUENCE, DATESTART, DATEEND, NOSALES FROM CLOSEDCASH WHERE MONEY = ?", SerializerWriteString.INSTANCE, new SerializerReadBasic( new Datas[] { Datas.STRING, Datas.INT, Datas.TIMESTAMP, Datas.TIMESTAMP, Datas.INT })); m_insertcash = new StaticSentence( s, "INSERT INTO CLOSEDCASH(MONEY, HOST, HOSTSEQUENCE, DATESTART, DATEEND) " + "VALUES (?, ?, ?, ?, ?)", new SerializerWriteBasic( new Datas[] { Datas.STRING, Datas.STRING, Datas.INT, Datas.TIMESTAMP, Datas.TIMESTAMP })); m_draweropened = new StaticSentence( s, "INSERT INTO DRAWEROPENED ( NAME, TICKETID) " + "VALUES (?, ?)", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING})); m_lineremoved = new StaticSentence( s, "INSERT INTO LINEREMOVED (NAME, TICKETID, PRODUCTID, PRODUCTNAME, UNITS) " + "VALUES (?, ?, ?, ?, ?)", new SerializerWriteBasic( new Datas[] { Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.DOUBLE })); m_locationfind = new StaticSentence( s, "SELECT NAME FROM LOCATIONS WHERE ID = ?", SerializerWriteString.INSTANCE, SerializerReadString.INSTANCE); // Add 13.2.14 JDL for new gui based permissions m_permissionlist = new StaticSentence( s, "SELECT PERMISSIONS FROM PERMISSIONS WHERE ID = ?", SerializerWriteString.INSTANCE, new SerializerReadBasic(new Datas[] {Datas.STRING})); m_updatepermissions = new StaticSentence( s, "INSERT INTO PERMISSIONS (ID, PERMISSIONS) " + "VALUES (?, ?)", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING})); // added 1.3.14.14 JDL new routine to write to CSV table, to clean up CSV import routine m_insertCSVEntry = new StaticSentence( s, "INSERT INTO CSVIMPORT (ID, ROWNUMBER, CSVERROR, REFERENCE, CODE, NAME, PRICEBUY, PRICESELL, PREVIOUSBUY, PREVIOUSSELL, CATEGORY) " + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", new SerializerWriteBasic( new Datas[] { Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.DOUBLE, Datas.DOUBLE, Datas.DOUBLE, Datas.DOUBLE, Datas.STRING })); m_addOrder = new StaticSentence( s, "INSERT INTO ORDERS (ID, ORDERID, QTY, DETAILS, ATTRIBUTES, NOTES, TICKETID, DISPLAYID) " + "VALUES (?, ?, ?, ?, ?, ?, ?, ?) ", new SerializerWriteBasic( new Datas[] { Datas.STRING, Datas.STRING, Datas.INT, Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.INT })); resetResourcesCache(); }