public double getDebt(String status) throws BasicException {
PreparedSentence p = new PreparedSentence(s
, "SELECT SUM(P.TOTAL) FROM TICKETS T LEFT JOIN PAYMENTS P ON P.RECEIPT = T.ID WHERE T.STATUS = ? AND T.TICKETTYPE = 0 AND P.PAYMENT LIKE 'debt' GROUP BY STATUS"
, SerializerWriteString.INSTANCE
, SerializerReadDouble.INSTANCE);
Double d = (Double) p.find(status);
return d == null ? 0.0 : d.doubleValue();
}
public double getPaid(String status) throws BasicException {
//System.out.println(status);