private void btnCustomerActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_btnCustomerActionPerformed
JCustomerFinder finder = JCustomerFinder.getCustomerFinder(this, dlCustomers);
finder.search(ticket.getCustomer());
finder.setVisible(true);
ticket.setCustomer(finder.getSelectedCustomer());
// The ticket name
m_jTicketId.setText(ticket.getName(ticketext));
} // GEN-LAST:event_btnCustomerActionPerformed
private void m_jRefundActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_m_jRefundActionPerformed
java.util.List aRefundLines = new ArrayList();
for (int i = 0; i < m_ticket.getLinesCount(); i++) {
TicketLineInfo newline = new TicketLineInfo(m_ticket.getLine(i));
aRefundLines.add(newline);
}
m_ticketCopy = null;
m_TicketsBagTicketBag.showRefund();
m_panelticketedit.showRefundLines(aRefundLines);
TicketInfo refundticket = new TicketInfo();
refundticket.setTicketType(TicketInfo.RECEIPT_REFUND);
refundticket.setCustomer(m_ticket.getCustomer());
m_panelticketedit.setActiveTicket(refundticket, null);
} // GEN-LAST:event_m_jRefundActionPerformed
public final TicketInfo loadTicket(final int tickettype, final int ticketid)
throws BasicException {
TicketInfo ticket =
(TicketInfo)
new PreparedSentence(
s,
"SELECT T.ID, T.TICKETTYPE, T.TICKETID, R.DATENEW, R.MONEY, R.ATTRIBUTES, P.ID, P.NAME, T.CUSTOMER FROM RECEIPTS R JOIN TICKETS T ON R.ID = T.ID LEFT OUTER JOIN PEOPLE P ON T.PERSON = P.ID WHERE T.TICKETTYPE = ? AND T.TICKETID = ?",
SerializerWriteParams.INSTANCE,
new SerializerReadClass(TicketInfo.class))
.find(
new DataParams() {
public void writeValues() throws BasicException {
setInt(1, tickettype);
setInt(2, ticketid);
}
});
if (ticket != null) {
String customerid = ticket.getCustomerId();
ticket.setCustomer(customerid == null ? null : loadCustomerExt(customerid));
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.VALIDFROM, 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()));
}
return ticket;
}
private void btnPayActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_btnPayActionPerformed
paymentdialog.setPrintSelected(true);
// MSL : get total of selected tickets
double tt = 0;
for (Object tl : jList1.getSelectedValues()) {
FindTicketsInfoCustomer sTicket = (FindTicketsInfoCustomer) tl;
TicketInfo t = new TicketInfo();
try {
t = dlsales.loadTicket(0, sTicket.getTicketId());
tt = tt + t.getTotal(); // - t.getTotalPaid();
} catch (BasicException e) {
}
}
// -------------
// if (paymentdialog.showDialog(customerext.getCurdebt(), null)) {
if (paymentdialog.showDialog(tt, null)) {
// Save the ticket
/*TicketInfo ticket = new TicketInfo();
ticket.setTicketType(TicketInfo.RECEIPT_PAYMENT);
List<PaymentInfo> payments = paymentdialog.getSelectedPayments();
double total = 0.0;
for (PaymentInfo p : payments) {
total += p.getTotal();
}
payments.add(new PaymentInfoTicket(-total, "debtpaid"));
ticket.setPayments(payments);
ticket.setUser(app.getAppUserView().getUser().getUserInfo());
ticket.setActiveCash(app.getActiveCashIndex());
ticket.setDate(new Date());
ticket.setCustomer(customerext);
try {
dlsales.saveTicket(ticket, app.getInventoryLocation());
} catch (BasicException eData) {
MessageInf msg = new MessageInf(MessageInf.SGN_NOTICE, AppLocal.getIntString("message.nosaveticket"), eData);
msg.show(this);
}
*
*/
// Save the ticket
TicketInfo ticket = new TicketInfo();
ticket.setTicketType(TicketInfo.RECEIPT_PAYMENT);
List<PaymentInfo> payments = paymentdialog.getSelectedPayments();
double total = 0.0;
for (PaymentInfo p : payments) {
total += p.getTotal();
}
double reste = total;
for (Object tl : jList1.getSelectedValues()) {
FindTicketsInfoCustomer sTicket = (FindTicketsInfoCustomer) tl;
TicketInfo t = new TicketInfo();
if (reste > 0) {
try {
t = dlsales.loadTicket(0, sTicket.getTicketId());
payments.add(new PaymentInfoTicket(-t.getTotal(), "debtpaid"));
reste = total - t.getTotal();
ticket.setPayments(payments);
ticket.setUser(app.getAppUserView().getUser().getUserInfo());
ticket.setActiveCash(app.getActiveCashIndex());
ticket.setDate(new Date());
ticket.setCustomer(customerext);
dlsales.saveTicket(ticket, app.getInventoryLocation());
new StaticSentence(
this.app.getSession(),
"UPDATE TICKETS Set STATUS=9 WHERE ID = ?",
SerializerWriteString.INSTANCE)
.exec(t.getId());
// MSL : break the system : set the receipt with original one
// TODO : split the amount paid to the ticket values
/*new StaticSentence(this.app.getSession()
, "UPDATE RECEIPTS Set ID=? WHERE ID = ?"
, new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING}))
.exec(new Object[] {t.getId(), ticket.getId()});
*/
new StaticSentence(
this.app.getSession(),
"UPDATE PAYMENTS Set TICKETID=? WHERE RECEIPT = ?",
new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING}))
.exec(new Object[] {t.getId(), ticket.getId()});
} catch (BasicException eData) {
MessageInf msg =
new MessageInf(
MessageInf.SGN_NOTICE, AppLocal.getIntString("message.nosaveticket"), eData);
msg.show(this);
}
}
}
// MSL : no tickets selected
if ((jList1.getSelectedValues() == null) || (reste > 0)) {
payments.add(new PaymentInfoTicket(-reste, "debtpaid"));
ticket.setPayments(payments);
ticket.setUser(app.getAppUserView().getUser().getUserInfo());
ticket.setActiveCash(app.getActiveCashIndex());
ticket.setDate(new Date());
ticket.setCustomer(customerext);
try {
dlsales.saveTicket(ticket, app.getInventoryLocation());
} catch (BasicException eData) {
MessageInf msg =
new MessageInf(
MessageInf.SGN_NOTICE, AppLocal.getIntString("message.nosaveticket"), eData);
msg.show(this);
}
}
// reload customer
CustomerInfoExt c;
try {
c = dlsales.loadCustomerExt(customerext.getId());
if (c == null) {
MessageInf msg =
new MessageInf(
MessageInf.SGN_WARNING, AppLocal.getIntString("message.cannotfindcustomer"));
msg.show(this);
} else {
editCustomer(c);
}
} catch (BasicException ex) {
c = null;
MessageInf msg =
new MessageInf(
MessageInf.SGN_WARNING, AppLocal.getIntString("message.cannotfindcustomer"), ex);
msg.show(this);
}
printTicket(
paymentdialog.isPrintSelected() ? "Printer.CustomerPaid" : "Printer.CustomerPaid2",
ticket,
c);
}
editorcard.reset();
editorcard.activate();
} // GEN-LAST:event_btnPayActionPerformed