Package com.openbravo.data.loader

Examples of com.openbravo.data.loader.PreparedSentence.find()


    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);
View Full Code Here


        //System.out.println(status);
        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 = 2 OR T.TICKETTYPE = 1 ) AND P.TOTAL < 0.0 "
                        , SerializerWriteString.INSTANCE
                    , SerializerReadDouble.INSTANCE);
        Double d = (Double) p.find(status);
        return d == null ? 0.0 : d.doubleValue();
    }
   
    public List getUsers() throws BasicException {
        return new PreparedSentence(s
View Full Code Here

            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"
                     "SELECT COUNT(P.ID) FROM CATEGORIES C INNER JOIN PRODUCTS P ON P.CATEGORY = C.ID AND C.NAME = ? "
                            , SerializerWriteString.INSTANCE
                            , SerializerReadDouble.INSTANCE);
            Double d = (Double) p.find(name);
           
            return d == null ? 0.0 : d.doubleValue();
           
        } catch (BasicException ex) {
           
View Full Code Here

    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);
View Full Code Here

        //System.out.println(status);
        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 = 2 OR T.TICKETTYPE = 1 ) AND P.TOTAL < 0.0 "
                        , SerializerWriteString.INSTANCE
                    , SerializerReadDouble.INSTANCE);
        Double d = (Double) p.find(status);
        return d == null ? 0.0 : d.doubleValue();
    }
   
    public List getUsers() throws BasicException {
        return new PreparedSentence(s
View Full Code Here

            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"
                     "SELECT COUNT(P.ID) FROM CATEGORIES C INNER JOIN PRODUCTS P ON P.CATEGORY = C.ID AND C.NAME = ? "
                            , SerializerWriteString.INSTANCE
                            , SerializerReadDouble.INSTANCE);
            Double d = (Double) p.find(name);
           
            return d == null ? 0.0 : d.doubleValue();
           
        } catch (BasicException ex) {
           
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.