Package com.openbravo.data.loader

Examples of com.openbravo.data.loader.StaticSentence

61
62
63
64
65
66
67
68
69
70
        }
    }
   
    public final List<SharedTicketInfo> getSharedTicketList() throws BasicException {
       
        return (List<SharedTicketInfo>) new StaticSentence(s
                , "SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID"
                , null
                , new SerializerReadClass(SharedTicketInfo.class)).list();
    }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
    public void addParameter(String name) {
        paramnames.add(name);       
    }
   
    protected BaseSentence getSentence() {
        return new StaticSentence(m_App.getSession()
            , new QBFBuilder(sentence, paramnames.toArray(new String[paramnames.size()]))
            , qbffilter.getSerializerWrite()
            , new SerializerReadBasic(fielddatas.toArray(new Datas[fielddatas.size()])));
    }
View Full Code Here
88
89
90
91
92
93
94
95
96
            , new SerializerWriteBasicExt(datas, new int[] {0, 1, 2})).exec(values);
    }
   
    public final void deleteSharedTicket(final String id) throws BasicException {

        new StaticSentence(s
            , "DELETE FROM SHAREDTICKETS WHERE ID = ?"
            , SerializerWriteString.INSTANCE).exec(id);     
    }   
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
179
                        " 'N'," +
                        " 0," +
                        " null)";
                System.out.println(i);
                System.out.println(sentence);
                BaseSentence sent = new StaticSentence(m_App.getSession(), sentence);
                sent.exec();
            }
        } catch (BasicException e) {
            e.printStackTrace();
        }       
    }
View Full Code Here
63
64
65
66
67
68
69
    public void init(Session s) {
        this.s = s;
    }
    
    public void syncCustomersBefore() throws BasicException {
        new StaticSentence(s, "UPDATE CUSTOMERS SET VISIBLE = " + s.DB.FALSE()).exec();
    }
View Full Code Here
103
104
105
106
107
108
109
        t.execute();
    }
       
   
    public void syncProductsBefore() throws BasicException {
        new StaticSentence(s, "DELETE FROM PRODUCTS_CAT").exec();
    }  
View Full Code Here
258
259
260
261
262
263
264
265
266
267
268
                                setDouble(13, 0.0);                              
                            }});
                }
                       
                // Insert in catalog
                new StaticSentence(s,
                        "INSERT INTO PRODUCTS_CAT(PRODUCT, CATORDER) VALUES (?, NULL)",
                        SerializerWriteString.INSTANCE
                        ).exec(prod.getID());  
               
                return null;       
View Full Code Here
301
302
303
304
305
306
307
                    }               
                }).list(ticket);
    }   

    public void execTicketUpdate() throws BasicException {
        new StaticSentence(s, "UPDATE TICKETS SET STATUS = 1 WHERE STATUS = 0").exec();
    }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
        this.s = s;
    }
    
    public void syncCustomersBefore() throws BasicException {
// sync problems
        new StaticSentence(s, "UPDATE CUSTOMERS SET VISIBLE = " + s.DB.TRUE()).exec();
        new StaticSentence(s, "DELETE FROM CUSTOMERS WHERE ID NOT LIKE '0' AND ID NOT IN (SELECT CUSTOMER FROM TICKETS GROUP BY CUSTOMER)").exec();
//ZAV
       // if (TicketInfo.getPayID()==2)
       //     new StaticSentence(s, "UPDATE CUSTOMERS SET CURDEBT=0.0 WHERE ID NOT LIKE '0' AND CURDEBT > 0.0").exec();

    }
View Full Code Here
143
144
145
146
147
148
149
        t.execute();
    }
       
   
    public void syncProductsBefore() throws BasicException {
        new StaticSentence(s, "DELETE FROM PRODUCTS_CAT").exec();
    }
View Full Code Here
TOP

Related Classes of com.openbravo.data.loader.StaticSentence

  • com.openbravo.pos.admin.DataLogicAdmin
  • com.openbravo.pos.customers.DataLogicCustomers
  • com.openbravo.pos.inventory.AttributeFilter
  • com.openbravo.pos.inventory.AttributeSetFilter
  • com.openbravo.pos.inventory.AttributeUseEditor
  • com.openbravo.pos.panels.JPanelCloseMoney
  • com.openbravo.pos.reports.PanelReportBean
  • com.openbravo.pos.sales.DataLogicReceipts
  • com.openbravo.pos.sales.restaurant.JTicketsBagRestaurantMap
  • com.openbravo.pos.sql.JPanelSQL
    • Copyright © 2018 www.massapicom. 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.