@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();
}