POS - How to add values in receipt
How to add & retrieve the values from database and display in the receipt. 1. Insert into Database
- Altered Payments table and added CardType column
ALTER TABLE payments ADD COLUMN cardname character varying(20); ALTER TABLE payments ALTER COLUMN cardname SET STORAGE EXTENDED;
- Modify the SaveTicket(..) method in DataLogicSales.Java which is in 'com.openbravo.pos.forms' package.
SentenceExec paymentinsert = new PreparedSentence(s
, "INSERT INTO PAYMENTS (ID, RECEIPT, PAYMENT, TOTAL, TRANSID, RETURNMSG, CARDNAME) VALUES (?, ?, ?, ?, ?, ?, ?)"
, SerializerWriteParams.INSTANCE);
for (final PaymentInfo p : ticket.getPayments()) {
paymentinsert.exec(new DataParams() { public void writeValues() throws BasicException {
setString(1, UUID.randomUUID().toString());
setString(2, ticket.getId());
setString(3, p.getName());
setDouble(4, p.getTotal());
setString(5, ticket.getTransactionID());
setBytes(6, (byte[]) Formats.BYTEA.parseValue(ticket.getReturnMessage()));
setString(7, p.getCardName());
}});
- Add Abstract method in PaymentInfo.java file which is in 'com.openbravo.pos.payment' package.
public abstract String getCardName();
Override this method in all the payments java files (PaymentInfoCash.java, PaymentInfoFree.java , PaymentInfoTicket.java)
private String m_dCardName =null;
private String m_dCardName =null;
public String getCardName() {
return m_dCardName;
}
But In PaymentInfoMagcard.java
protected String m_dCardName =null;
public String getCardName() {
return getCardType(m_sCardNumber);
}
public String getCardType(String sCardNumber){
c = "UNKNOWN";
if (sCardNumber.startsWith("4")) {
c = "VISA";
} else if (sCardNumber.startsWith("6")) {
c = "DISC";
} else if (sCardNumber.startsWith("5")) {
c = "MAST";
} else if (sCardNumber.startsWith("34") || sCardNumber.startsWith("37")) {
c = "AMEX";
} else if (sCardNumber.startsWith("3528") || sCardNumber.startsWith("3589")) {
c = "JCB";
} else if (sCardNumber.startsWith("3")) {
c = "DINE";
}
m_dCardName = c;
return c;
}
Using these activities we saved our card type in the database.
2.Retrieve from the database.
- Modify the loadTicket(..) method in DataLogicSales.Java which is in 'com.openbravo.pos.forms' package.
change this sentence
ticket.setLines(new PreparedSentence(s
, "SELECT L.TICKET, L.LINE, L.PRODUCT, L.ATTRIBUTESETINSTANCE_ID, L.UNITS, L.PRICE, T.ID, T.NAME, T.CATEGORY, T.CUSTCATEGORY, T.PARENTID, T.RATE, T.RATECASCADE, T.RATEORDER, L.ATTRIBUTES " +
"FROM TICKETLINES L, TAXES T WHERE L.TAXID = T.ID AND L.TICKET = ? ORDER BY L.LINE"
, SerializerWriteString.INSTANCE
, new SerializerReadClass(TicketLineInfo.class)).list(ticket.getId()));
ticket.setPayments(new PreparedSentence(s
, "SELECT PAYMENT, TOTAL, TRANSID FROM PAYMENTS WHERE RECEIPT = ?"
, SerializerWriteString.INSTANCE
, new SerializerReadClass(PaymentInfoTicket.class)).list(ticket.getId()));
As a
ticket.setLines(new PreparedSentence(s
, "SELECT L.TICKET, L.LINE, L.PRODUCT, L.ATTRIBUTESETINSTANCE_ID, L.UNITS, L.PRICE, T.ID, T.NAME, T.CATEGORY, T.CUSTCATEGORY, T.PARENTID, T.RATE, T.RATECASCADE, T.RATEORDER, L.ATTRIBUTES " +
"FROM TICKETLINES L, TAXES T WHERE L.TAXID = T.ID AND L.TICKET = ? ORDER BY L.LINE"
, SerializerWriteString.INSTANCE
, new SerializerReadClass(TicketLineInfo.class)).list(ticket.getId()));
ticket.setPayments(new PreparedSentence(s
, "SELECT PAYMENT, TOTAL, TRANSID, CARDNAME FROM PAYMENTS WHERE RECEIPT = ?"
, SerializerWriteString.INSTANCE
, new SerializerReadClass(PaymentInfoTicket.class)).list(ticket.getId()));
- In PaymentInfoTicket.java
Add this ( m_dCardName = dr.getString(4);) line in the readValues(..) method.
public void readValues(DataRead dr) throws BasicException {
m_sName = dr.getString(1);
m_dTicket = dr.getDouble(2).doubleValue();
m_transactionID = dr.getString(3);
m_dCardName = dr.getString(4);
}
3. Display in Receipt.
- Modify the Printer.Ticket Or Printer.TicketPreview templates
<line> <text>Card Type</text> </line> <line> <text>${paymentline.getCardName()}</text> </line>
Using this we can get card type in the receipt at any time.