OpenConcerto

Dépôt officiel du code source de l'ERP OpenConcerto
sonarqube

svn://code.openconcerto.org/openconcerto

Rev

Rev 167 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
43 ilm 1
package org.openconcerto.modules.badge;
2
 
3
import java.awt.Component;
4
import java.io.File;
5
import java.io.IOException;
153 ilm 6
import java.sql.SQLException;
43 ilm 7
import java.text.DateFormat;
153 ilm 8
import java.text.Normalizer;
9
import java.text.Normalizer.Form;
43 ilm 10
import java.text.SimpleDateFormat;
11
import java.util.ArrayList;
79 ilm 12
import java.util.Arrays;
43 ilm 13
import java.util.Calendar;
14
import java.util.Date;
153 ilm 15
import java.util.HashMap;
43 ilm 16
import java.util.HashSet;
17
import java.util.List;
153 ilm 18
import java.util.Map;
43 ilm 19
import java.util.Set;
153 ilm 20
import java.util.regex.Matcher;
21
import java.util.regex.Pattern;
43 ilm 22
 
23
import javax.swing.Action;
98 ilm 24
import javax.swing.Icon;
43 ilm 25
import javax.swing.JFrame;
26
import javax.swing.JTable;
27
import javax.swing.table.DefaultTableCellRenderer;
28
 
29
import org.openconcerto.erp.action.CreateFrameAbstractAction;
30
import org.openconcerto.erp.config.MainFrame;
153 ilm 31
import org.openconcerto.erp.core.common.element.AdresseSQLElement;
43 ilm 32
import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
33
import org.openconcerto.erp.core.common.ui.ListeViewPanel;
181 ilm 34
import org.openconcerto.erp.core.customerrelationship.customer.element.ComptaContactSQLElement;
153 ilm 35
import org.openconcerto.erp.core.customerrelationship.customer.element.CustomerSQLElement;
43 ilm 36
import org.openconcerto.erp.modules.AbstractModule;
37
import org.openconcerto.erp.modules.ComponentsContext;
38
import org.openconcerto.erp.modules.DBContext;
79 ilm 39
import org.openconcerto.erp.modules.MenuContext;
43 ilm 40
import org.openconcerto.erp.modules.ModuleFactory;
79 ilm 41
import org.openconcerto.erp.modules.ModulePreferencePanel;
42
import org.openconcerto.erp.modules.ModulePreferencePanelDesc;
153 ilm 43
import org.openconcerto.erp.modules.ModuleVersion;
43 ilm 44
import org.openconcerto.sql.Configuration;
45
import org.openconcerto.sql.element.SQLComponent;
46
import org.openconcerto.sql.element.SQLElement;
47
import org.openconcerto.sql.element.SQLElementDirectory;
48
import org.openconcerto.sql.element.UISQLComponent;
167 ilm 49
import org.openconcerto.sql.model.DBRoot;
43 ilm 50
import org.openconcerto.sql.model.SQLName;
153 ilm 51
import org.openconcerto.sql.model.SQLRow;
43 ilm 52
import org.openconcerto.sql.model.SQLRowAccessor;
153 ilm 53
import org.openconcerto.sql.model.SQLRowValues;
54
import org.openconcerto.sql.model.SQLRowValuesListFetcher;
43 ilm 55
import org.openconcerto.sql.model.SQLSyntax;
153 ilm 56
import org.openconcerto.sql.model.SQLTable;
43 ilm 57
import org.openconcerto.sql.model.Where;
58
import org.openconcerto.sql.utils.SQLCreateTable;
59
import org.openconcerto.sql.view.FileDropHandler;
60
import org.openconcerto.sql.view.IListFrame;
61
import org.openconcerto.sql.view.IListPanel;
62
import org.openconcerto.sql.view.list.IListe;
63
import org.openconcerto.sql.view.list.RowAction;
64
import org.openconcerto.sql.view.list.SQLTableModelSourceOnline;
65
import org.openconcerto.ui.PanelFrame;
153 ilm 66
import org.openconcerto.ui.group.Group;
67
import org.openconcerto.ui.group.LayoutHints;
118 ilm 68
import org.openconcerto.utils.ListMap;
79 ilm 69
import org.openconcerto.utils.PrefType;
153 ilm 70
import org.openconcerto.utils.StringUtils;
43 ilm 71
import org.openconcerto.utils.cc.IClosure;
72
 
73
public final class Module extends AbstractModule {
74
 
153 ilm 75
    private static final String CLIENT_ADH_FIELDNAME = "ID_ADHERENT";
76
    private static final Pattern FIRST_NAME_PATTERN = Pattern.compile("([^0-9]*)([0-9]*).*");
77
    public static final boolean HAS_CODE_IN_FIRST_NAME = Boolean.getBoolean("adherent.hasCodeInFirstName");
78
 
43 ilm 79
    public Module(ModuleFactory f) throws IOException {
80
        super(f);
81
 
82
    }
83
 
84
    @Override
153 ilm 85
    protected void install(final DBContext ctxt) throws SQLException, IOException {
43 ilm 86
        super.install(ctxt);
153 ilm 87
        final AdresseSQLElement addrElem = ctxt.getElementDirectory().getElement(AdresseSQLElement.class);
43 ilm 88
 
153 ilm 89
        final ModuleVersion dbVersion = ctxt.getLastInstalledVersion() == null ? ModuleVersion.MIN : ctxt.getLastInstalledVersion();
90
        if (dbVersion.getMerged() > this.getFactory().getVersion().getMerged())
91
            throw new IllegalStateException("Cannot downgrade from " + dbVersion + " to " + this.getFactory());
92
        if (dbVersion.getMerged() < ModuleVersion.getMerged(1, 0)) {
43 ilm 93
            // ENTREE
94
            final SQLCreateTable createTableEntree = ctxt.getCreateTable("ENTREE");
95
            createTableEntree.addDateAndTimeColumn("DATE");
96
            createTableEntree.addVarCharColumn("NUMERO_CARTE", 256);
97
            createTableEntree.addVarCharColumn("ADHERENT", 512);
98
            createTableEntree.addVarCharColumn("MOTIF", 2048);
99
            createTableEntree.addColumn("ACCEPTE", "boolean");
153 ilm 100
 
43 ilm 101
            // PLAGE
102
            final SQLCreateTable createTablePlage = ctxt.getCreateTable("PLAGE_HORAIRE");
103
            createTablePlage.addVarCharColumn("NOM", 256);
104
            createTablePlage.addColumn("DEBUT_1_LUNDI", "time");
105
            createTablePlage.addColumn("DEBUT_1_MARDI", "time");
106
            createTablePlage.addColumn("DEBUT_1_MERCREDI", "time");
107
            createTablePlage.addColumn("DEBUT_1_JEUDI", "time");
108
            createTablePlage.addColumn("DEBUT_1_VENDREDI", "time");
109
            createTablePlage.addColumn("DEBUT_1_SAMEDI", "time");
110
            createTablePlage.addColumn("DEBUT_1_DIMANCHE", "time");
111
 
112
            createTablePlage.addColumn("DEBUT_2_LUNDI", "time");
113
            createTablePlage.addColumn("DEBUT_2_MARDI", "time");
114
            createTablePlage.addColumn("DEBUT_2_MERCREDI", "time");
115
            createTablePlage.addColumn("DEBUT_2_JEUDI", "time");
116
            createTablePlage.addColumn("DEBUT_2_VENDREDI", "time");
117
            createTablePlage.addColumn("DEBUT_2_SAMEDI", "time");
118
            createTablePlage.addColumn("DEBUT_2_DIMANCHE", "time");
119
 
120
            createTablePlage.addColumn("DEBUT_3_LUNDI", "time");
121
            createTablePlage.addColumn("DEBUT_3_MARDI", "time");
122
            createTablePlage.addColumn("DEBUT_3_MERCREDI", "time");
123
            createTablePlage.addColumn("DEBUT_3_JEUDI", "time");
124
            createTablePlage.addColumn("DEBUT_3_VENDREDI", "time");
125
            createTablePlage.addColumn("DEBUT_3_SAMEDI", "time");
126
            createTablePlage.addColumn("DEBUT_3_DIMANCHE", "time");
127
 
128
            createTablePlage.addColumn("FIN_1_LUNDI", "time");
129
            createTablePlage.addColumn("FIN_1_MARDI", "time");
130
            createTablePlage.addColumn("FIN_1_MERCREDI", "time");
131
            createTablePlage.addColumn("FIN_1_JEUDI", "time");
132
            createTablePlage.addColumn("FIN_1_VENDREDI", "time");
133
            createTablePlage.addColumn("FIN_1_SAMEDI", "time");
134
            createTablePlage.addColumn("FIN_1_DIMANCHE", "time");
135
 
136
            createTablePlage.addColumn("FIN_2_LUNDI", "time");
137
            createTablePlage.addColumn("FIN_2_MARDI", "time");
138
            createTablePlage.addColumn("FIN_2_MERCREDI", "time");
139
            createTablePlage.addColumn("FIN_2_JEUDI", "time");
140
            createTablePlage.addColumn("FIN_2_VENDREDI", "time");
141
            createTablePlage.addColumn("FIN_2_SAMEDI", "time");
142
            createTablePlage.addColumn("FIN_2_DIMANCHE", "time");
143
 
144
            createTablePlage.addColumn("FIN_3_LUNDI", "time");
145
            createTablePlage.addColumn("FIN_3_MARDI", "time");
146
            createTablePlage.addColumn("FIN_3_MERCREDI", "time");
147
            createTablePlage.addColumn("FIN_3_JEUDI", "time");
148
            createTablePlage.addColumn("FIN_3_VENDREDI", "time");
149
            createTablePlage.addColumn("FIN_3_SAMEDI", "time");
150
            createTablePlage.addColumn("FIN_3_DIMANCHE", "time");
151
 
152
            // ADHERENT
153
            final SQLCreateTable createTable = ctxt.getCreateTable("ADHERENT");
154
 
155
            createTable.addVarCharColumn("NUMERO_CARTE", 256);
156
            createTable.addVarCharColumn("NOM", 256);
157
 
158
            createTable.addVarCharColumn("TEL", 256);
159
            createTable.addColumn("ACTIF", "boolean default false");
160
            createTable.addColumn("ADMIN", "boolean default false");
161
            createTable.addVarCharColumn("MAIL", 256);
162
            createTable.addVarCharColumn("PRENOM", 256);
163
            createTable.addVarCharColumn("INFOS", 2048);
164
            createTable.addColumn("DATE_VALIDITE_INSCRIPTION", "date");
165
            createTable.addColumn("DATE_NAISSANCE", "date");
166
 
153 ilm 167
            createTable.addForeignColumn("ID_ADRESSE", addrElem.getTable());
43 ilm 168
            createTable.addForeignColumn("ID_PLAGE_HORAIRE", new SQLName("PLAGE_HORAIRE"), SQLSyntax.ID_NAME, null);
181 ilm 169
            ctxt.executeSQL();
43 ilm 170
        }
153 ilm 171
        // at least v1.0
172
 
173
        if (dbVersion.getMerged() < ModuleVersion.getMerged(1, 1)) {
174
            // migrate from non-private
175
            final SQLTable adhT = ctxt.getRoot().getTable("ADHERENT");
176
            final CustomerSQLElement clientElem = ctxt.getElementDirectory().getElement(CustomerSQLElement.class);
177
            final SQLTable clientT = clientElem.getTable();
178
            ctxt.getAlterTable(clientT.getName()).addForeignColumn(CLIENT_ADH_FIELDNAME, adhT);
179
            // fill new field (no need to do anything in uninstall() since the field will be
180
            // dropped and new clients shouldn't be dropped)
181
            if (adhT.getRowCount(false) > 0) {
182
                ctxt.executeSQL();
183
                this.setupElements(ctxt.getElementDirectory());
184
                // 1. fetch all clients
185
                final ListMap<String, SQLRow> clientByName = new ListMap<>();
186
                final ListMap<String, SQLRow> clientByCode = new ListMap<>();
187
                for (final SQLRowValues clientR : SQLRowValuesListFetcher.create(new SQLRowValues(clientT).putNulls("NOM", "CODE")).fetch()) {
188
                    final String normalized = normalize(clientR.getString("NOM"));
189
                    clientByName.add(normalized, clientR.asRow());
190
                    clientByCode.add(clientR.getString("CODE"), clientR.asRow());
191
                }
192
                // 2. for each ADHERENT, link it to a single matching CLIENT, or create a
193
                // new one. Also fill CLIENT fields with duplicates from ADHERENT.
194
                // créer plutôt plus de clients : si besoin, fusion après coup.
195
                final SQLRowValues adhToFetch = new SQLRowValues(adhT).putNulls("NOM", "PRENOM", "MAIL", "TEL", "DATE_NAISSANCE");
196
                adhToFetch.putRowValues("ID_ADRESSE").setAllToNull();
197
                final Map<SQLRow, SQLRow> updatedClientsAndAdh = new HashMap<>();
198
 
199
                for (final SQLRowValues adhR : SQLRowValuesListFetcher.create(adhToFetch).fetch(null, true)) {
200
                    final String firstName;
201
                    final String code;
202
                    SQLRow existingClient = null;
203
                    if (HAS_CODE_IN_FIRST_NAME) {
204
                        final Matcher matcher = FIRST_NAME_PATTERN.matcher(adhR.getString("PRENOM"));
205
                        if (!matcher.matches())
206
                            throw new IllegalStateException("Couldn't match " + adhR);
207
                        firstName = matcher.group(1).trim();
208
                        code = matcher.group(2);
209
                    } else {
210
                        firstName = adhR.getString("PRENOM");
211
                        code = null;
212
                    }
213
                    if (!StringUtils.isEmpty(code)) {
214
                        existingClient = getUnique(clientByCode.get(code));
215
                    }
216
                    final String firstLastName = firstName + " " + adhR.getString("NOM");
217
                    if (existingClient == null) {
218
                        existingClient = getUnique(clientByName.get(normalize(firstLastName)));
219
                    }
220
                    final SQLRow newClient;
221
                    if (existingClient != null && !updatedClientsAndAdh.containsKey(existingClient)) {
222
                        updatedClientsAndAdh.put(existingClient, adhR.asRow());
223
                        // TODO use SQLElement.createFetcher()
224
                        final SQLRowValues clientToUpdateVals = SQLRowValuesListFetcher.create(clientElem.createGraph()).fetchOne(existingClient.getIDNumber(), true);
225
                        // TODO use new UpdateAction(SQLElement.createContext())
226
                        final SQLRowValues newVals = fillFields(clientToUpdateVals.deepCopy(), adhR, false, addrElem);
227
                        newClient = clientElem.update(clientToUpdateVals, newVals).exec();
228
                    } else {
229
                        // TODO use Logger
230
                        if (existingClient != null) {
231
                            System.err.println("While matching " + adhT + ", existing client " + existingClient + " already updated with " + updatedClientsAndAdh.get(existingClient)
232
                                    + " so creating new client for " + adhR);
233
                        } else {
234
                            System.err.println("While matching " + adhT + ", no client found for " + adhR);
235
                        }
236
                        // create new client row
237
                        // TODO use new InsertAction(SQLElement.createContext()) or at least
238
                        // SQLElement.insert()
239
                        final SQLRowValues vals = fillFields(new SQLRowValues(clientT).put("NOM", firstLastName), adhR, true, addrElem);
240
                        if (!StringUtils.isEmpty(code))
241
                            vals.put("CODE", code);
242
                        newClient = vals.insert();
243
                    }
181 ilm 244
                    final SQLRowValues contactVals = new SQLRowValues(ctxt.getElementDirectory().getElement(ComptaContactSQLElement.class).getTable());
153 ilm 245
                    contactVals.putForeignID("ID_CLIENT", newClient);
246
                    contactVals.load(adhR.asRow(), Arrays.asList("NOM", "DATE_NAISSANCE"));
247
                    contactVals.put("PRENOM", firstName);
248
                    contactVals.put("EMAIL", adhR.getString("MAIL"));
249
                    contactVals.insert();
250
                }
251
 
252
                ctxt.getAlterTable(adhT.getName()).dropColumn("ID_ADRESSE");
253
            }
254
        }
43 ilm 255
    }
256
 
153 ilm 257
    protected SQLRow getUnique(final List<SQLRow> clientRows) {
258
        return clientRows != null && clientRows.size() == 1 ? clientRows.get(0) : null;
259
    }
260
 
261
    private final SQLRowValues fillFields(final SQLRowValues clientVals, final SQLRowValues adhVals, final boolean useAdhID, final SQLElement addrElem) {
262
        clientVals.put(CLIENT_ADH_FIELDNAME, useAdhID ? adhVals.getIDNumber() : adhVals.deepCopy());
263
        concatField(clientVals, adhVals, "MAIL");
264
        concatField(clientVals, adhVals, "TEL");
265
        final SQLRowValues adhAddr = (SQLRowValues) adhVals.getNonEmptyForeign("ID_ADRESSE");
266
        if (adhAddr != null && !StringUtils.isEmpty(adhAddr.getString("VILLE"), true)) {
267
            clientVals.put("ID_ADRESSE", addrElem.createCopy(adhAddr, true, null));
268
        }
269
        return clientVals;
270
    }
271
 
272
    private final void concatField(final SQLRowValues clientVals, final SQLRowValues adhVals, final String fieldName) {
273
        final String adhStr = adhVals.getString(fieldName);
274
        if (StringUtils.isEmpty(adhStr, true))
275
            return;
276
        final String clientStr = clientVals.getString(fieldName);
277
        if (StringUtils.isEmpty(clientStr, true)) {
278
            clientVals.put(fieldName, adhStr);
279
        } else {
280
            clientVals.put(fieldName, clientStr + ", " + adhStr);
281
        }
282
    }
283
 
284
    static private final Pattern diacriticalPattern = Pattern.compile("\\p{InCombiningDiacriticalMarks}+");
285
    static private final Pattern punctPattern = Pattern.compile("\\p{Punct}+");
286
    static private final Pattern spacePattern = Pattern.compile("\\p{Space}+");
287
 
288
    // remove punctation, multiple spaces and accents
289
    static private String normalize(final String s) {
290
        final String noMarks = diacriticalPattern.matcher(Normalizer.normalize(s, Form.NFD)).replaceAll("");
291
        final String noPunct = punctPattern.matcher(noMarks).replaceAll("_");
292
        return spacePattern.matcher(noPunct.trim()).replaceAll(" ").toLowerCase();
293
    }
294
 
43 ilm 295
    @Override
296
    protected void setupElements(SQLElementDirectory dir) {
297
        super.setupElements(dir);
298
 
299
        final ComptaSQLConfElement entreeElement = new ComptaSQLConfElement("ENTREE", "une entrée", "entrées") {
300
 
301
            @Override
302
            protected List<String> getListFields() {
303
                final List<String> l = new ArrayList<String>();
304
                l.add("DATE");
305
                l.add("NUMERO_CARTE");
306
                l.add("ADHERENT");
307
                l.add("MOTIF");
308
                l.add("ACCEPTE");
309
                return l;
310
            }
311
 
312
            @Override
313
            public Set<String> getReadOnlyFields() {
314
                Set<String> s = new HashSet<String>(super.getReadOnlyFields());
315
                s.add("NUMERO_CARTE");
316
                return s;
317
            }
318
 
319
            @Override
320
            protected List<String> getComboFields() {
321
                final List<String> l = new ArrayList<String>();
322
                l.add("NUMERO_CARTE");
323
                l.add("DATE");
324
                return l;
325
            }
326
 
327
            @Override
118 ilm 328
            public ListMap<String, String> getShowAs() {
329
                return ListMap.singleton(null, getComboFields());
43 ilm 330
            }
331
 
332
            @Override
333
            public SQLComponent createComponent() {
334
                return new UISQLComponent(this) {
335
                    @Override
336
                    protected void addViews() {
337
                        this.addView("NUMERO_CARTE");
338
                        this.addView("DATE");
339
                    }
340
                };
341
            }
342
        };
343
        dir.addSQLElement(entreeElement);
344
        dir.addSQLElement(new PlageHoraireSQLElement());
345
        dir.addSQLElement(new AdherentSQLElement());
346
    }
347
 
348
    private IListPanel getPanelEntree(boolean filtered) {
349
        final SQLElement element = Configuration.getInstance().getDirectory().getElement("ENTREE");
350
 
351
        final SQLTableModelSourceOnline tableModelEntree = element.getTableSource(true);
352
 
353
        if (filtered) {
354
            Calendar cal = Calendar.getInstance();
355
            cal.add(Calendar.DAY_OF_MONTH, -15);
356
            Where wAttente = new Where(element.getTable().getField("DATE"), ">=", cal.getTime());
357
            tableModelEntree.getReq().setWhere(wAttente);
358
        }
359
        tableModelEntree.getColumn(element.getTable().getField("DATE")).setRenderer(new DefaultTableCellRenderer() {
360
 
361
            DateFormat format = new SimpleDateFormat("EEEE dd MMMM yyyy HH:mm:ss");
362
 
363
            @Override
364
            public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) {
365
                final String format2 = format.format((Date) value);
366
                return super.getTableCellRendererComponent(table, format2, isSelected, hasFocus, row, column);
367
 
368
            }
369
        });
370
 
371
        final IListPanel panel = new ListeViewPanel(element, new IListe(tableModelEntree));
372
 
98 ilm 373
        final Action createAction = RowAction.createAction("Assigner à", (Icon) null, new IClosure<List<? extends SQLRowAccessor>>() {
43 ilm 374
            @Override
98 ilm 375
            public void executeChecked(List<? extends SQLRowAccessor> input) {
43 ilm 376
                SQLRowAccessor row = input.get(0);
377
                PanelFrame frame = new PanelFrame(new AssignationPanel(row.getString("NUMERO_CARTE")), "Assignation d'une carte");
378
                frame.setLocationRelativeTo(null);
379
                frame.setVisible(true);
380
 
381
            }
382
        });
383
 
384
        panel.getListe().addRowAction(createAction);
385
 
386
        return panel;
387
    }
388
 
389
    @Override
390
    protected void setupComponents(ComponentsContext ctxt) {
153 ilm 391
        final Group g = new Group("customerrelationship.customer.adherent", LayoutHints.DEFAULT_SEPARATED_GROUP_HINTS);
392
        ctxt.getElement("CLIENT").getDefaultGroup().add(g);
393
        g.addItem(CLIENT_ADH_FIELDNAME, new LayoutHints(true, true, true, true, true, true));
43 ilm 394
        ctxt.addFileDropHandler("ADHERENT", new FileDropHandler() {
395
 
396
            @Override
397
            public boolean handle(File f, Component source) {
398
                AdherentImporter importer;
399
                try {
400
                    importer = new AdherentImporter(f);
401
                    importer.importAdherent();
402
                } catch (Exception e) {
403
                    e.printStackTrace();
404
                }
405
                return true;
406
            }
407
 
408
            @Override
409
            public boolean canHandle(File f) {
410
                String n = f.getName().toLowerCase();
411
                return n.endsWith(".xls") || n.endsWith(".ods");
412
            }
413
        });
79 ilm 414
    }
415
 
416
    @Override
417
    protected void setupMenu(MenuContext ctxt) {
43 ilm 418
        ctxt.addMenuItem(new CreateFrameAbstractAction("Liste des entrées") {
419
 
420
            @Override
421
            public JFrame createFrame() {
422
 
423
                return new IListFrame(getPanelEntree(false));
424
            }
425
        }, MainFrame.LIST_MENU);
167 ilm 426
        ctxt.addMenuItem(ctxt.getMenuAndActions().getAction("preferences"), MainFrame.FILE_MENU);
43 ilm 427
    }
428
 
429
    @Override
430
    protected void start() {
431
        MainFrame.getInstance().getTabbedPane().addTab("Liste des entrées", getPanelEntree(true));
432
    }
433
 
434
    @Override
435
    protected void stop() {
436
    }
437
 
79 ilm 438
    public final static String ENTREE_PREF = "entreeAdmin";
439
 
440
    @Override
167 ilm 441
    public List<ModulePreferencePanelDesc> getPrefDescriptors(final DBRoot root) {
79 ilm 442
        return Arrays.<ModulePreferencePanelDesc> asList(new ModulePreferencePanelDesc("Gestion des entrées") {
443
            @Override
444
            protected ModulePreferencePanel createPanel() {
167 ilm 445
                return new ModulePreferencePanel(root, "Gestion des entrées") {
79 ilm 446
                    @Override
447
                    protected void addViews() {
448
                        this.addView(new SQLPrefView<Boolean>(PrefType.BOOLEAN_TYPE, "N'autoriser que les administrateurs à entrer ", ENTREE_PREF));
449
                    }
450
                };
451
            }
452
        }.setLocal(false).setKeywords("entrée"));
453
    }
454
 
43 ilm 455
}