Code : Tout sélectionner
public class SimpleCustomer {
private String name;
private String email;
private String street;
private String postalCode;
private String city;
public SimpleCustomer(String name, String email, String street, String postalCode, String city) {
this.name = name;
this.email = email;
this.street = street;
this.postalCode = postalCode;
this.city = city;
}
public int createIfNotExists(DBRoot root) throws Exception {
final SQLTable tClient = root.getTable("CLIENT");
final SQLTable tAdresse = root.getTable("ADRESSE");
// retrieve all the customers and check
final SQLRowValues graph_address = new SQLRowValues(tAdresse);
graph_address.put("VILLE", null);
final SQLRowValues graph = new SQLRowValues(tClient);
graph.put("NOM", null);
graph.put("ID_ADRESSE", graph_address);
final SQLRowValuesListFetcher f = new SQLRowValuesListFetcher(graph);
// use setSelTransf() on the fetcher to add a where if needed
final List<SQLRowValues> rowsClient = f.fetch();
SQLRowValues client = null;
for (SQLRowValues rClient : rowsClient) {
String name = rClient.getString("NOM").toLowerCase();
String city = rClient.getForeign("ID_ADRESSE").getString("VILLE");
if (name.equalsIgnoreCase(this.name) && city.equalsIgnoreCase(this.city)) {
// put other test here for duplicate customer criteria
client = rClient;
break;
}
}
// exit if customer already exists
if (client != null) {
return client.getID();
}
// Customer
final SQLRowValues r = new SQLRowValues(tClient);
r.put("NOM", this.name);
r.put("MAIL", this.email);
// Customer address
final SQLRowValues rAddr = new SQLRowValues(root.getTable("ADRESSE"));
rAddr.put("RUE", this.street);
rAddr.put("CODE_POSTAL", this.postalCode);
rAddr.put("VILLE", this.city);
r.put("ID_ADRESSE", rAddr);
// Customer default payment method
final SQLRow rMode = ModeReglementDefautPrefPanel.getDefaultRow(true);
final SQLElement eltModeReglement = ComptaPropsConfiguration.getInstance().getDirectory().getElement("MODE_REGLEMENT");
final SQLRowValues rowVals = eltModeReglement.createCopy(rMode, null);
r.put("ID_MODE_REGLEMENT", rowVals);
// Customer default account
r.put("ID_COMPTE_PCE", ComptePCESQLElement.getIdComptePceDefault("Clients"));
// store the new customer
return r.commit().getID();
}
public static void main(String[] args) {
final HeadlessOpenConcerto c = new HeadlessOpenConcerto(2, 42);
final SimpleCustomer customer = new SimpleCustomer("MegaCorp", "contact@megacorp.eu", "3 rue de Boston", "80000", "Amiens");
int customerId;
try {
customerId = customer.createIfNotExists(c.getCompanyRoot());
System.out.println("Customer successfully created (id:" + customerId + ")");
} catch (Exception e) {
System.err.println("Unable to create customer");
e.printStackTrace();
}
}
}
