WebSVN - OpenConcerto - Diff - Rev 156 and 174 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/customerrelationship/customer/element/CustomerSQLComponent.java



 
import org.openconcerto.erp.core.common.component.AdresseSQLComponent;
import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;
import org.openconcerto.erp.core.customerrelationship.customer.ui.AdresseClientItemTable;
import org.openconcerto.erp.core.sales.product.element.ClientCodeArticleTable;
import org.openconcerto.erp.core.sales.product.ui.CustomerProductQtyPriceListTable;
import org.openconcerto.erp.preferences.ModeReglementDefautPrefPanel;
import org.openconcerto.erp.utils.TM;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.element.ElementSQLObject;
import org.openconcerto.sql.element.GroupSQLComponent;

 
public class CustomerSQLComponent extends GroupSQLComponent {
    private ContactItemTable table;
    private ClientCodeArticleTable tableCustomProduct;
    private AdresseClientItemTable adresseTable = new AdresseClientItemTable();
 
    private SQLTable contactTable = Configuration.getInstance().getDirectory().getElement("CONTACT").getTable();
    private final SQLTable tableNum = getTable().getBase().getTable("NUMEROTATION_AUTO");
    private final JUniqueTextField code = new JUniqueTextField(20) {
        @Override
        public String getAutoRefreshNumber() {

                return null;
            }
        }
    };
 
    private CustomerProductQtyPriceListTable clienTarifTable = new CustomerProductQtyPriceListTable();
    private SQLRowValues defaultContactRowVals = new SQLRowValues(UndefinedRowValuesCache.getInstance().getDefaultRowValues(this.contactTable));
    private JCheckBox checkAdrLivraison, checkAdrFacturation;
 
    public CustomerSQLComponent(SQLElement element) {
        super(element);

            return new JDate(true);
        } else if (id.equals("customerrelationship.customer.contacts")) {
            return this.table;
        } else if (id.equals("customerrelationship.customer.customproduct")) {
            return this.tableCustomProduct;
        } else if (id.equals("customerrelationship.customer.customtarif")) {
            return this.clienTarifTable;
        } else if (id.equals("customerrelationship.customer.addresses")) {
            return createAdressesComponent();
        } else if (id.equals("NOM")) {
            return super.createEditor(id);
        }

    @Override
    public void update() {
        super.update();
        final int selectedID = getSelectedID();
        this.table.updateField("ID_CLIENT", selectedID);
        this.clienTarifTable.updateField("ID_CLIENT", selectedID);
        this.tableCustomProduct.updateField("ID_CLIENT", selectedID);
        this.adresseTable.updateField("ID_CLIENT", selectedID);
    }
 
    @Override

        super.select(r);
        this.checkAdrLivraison.setSelected(r == null || !r.getFields().contains("ID_ADRESSE_L") || r.isForeignEmpty("ID_ADRESSE_L"));
        this.checkAdrFacturation.setSelected(r == null || !r.getFields().contains("ID_ADRESSE_F") || r.isForeignEmpty("ID_ADRESSE_F"));
        if (r != null) {
            this.table.insertFrom("ID_CLIENT", r.asRowValues());
            this.clienTarifTable.insertFrom("ID_CLIENT", r.asRowValues());
            this.tableCustomProduct.insertFrom("ID_CLIENT", r.asRowValues());
            this.adresseTable.insertFrom("ID_CLIENT", r.asRowValues());
        }
    }
 

            }
        } else {
            id = super.insert(order);
            this.table.updateField("ID_CLIENT", id);
            this.tableCustomProduct.updateField("ID_CLIENT", id);
            this.clienTarifTable.updateField("ID_CLIENT", id);
            this.adresseTable.updateField("ID_CLIENT", id);
            if (NumerotationAutoSQLElement.getNextNumero(getElement().getClass()).equalsIgnoreCase(this.code.getText().trim())) {
                SQLRowValues rowVals = new SQLRowValues(this.tableNum);
                final SQLRow rowNumAuto = this.tableNum.getRow(2);
                if (rowNumAuto.getObject("CLIENT_START") != null) {

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

svn://code.openconcerto.org/openconcerto

(root)/trunk/OpenConcerto/src/org/openconcerto/erp/core/customerrelationship/customer/element/CustomerSQLComponent.java - Rev 156 → 174

Rev 156		Rev 174
Line 15...		Line 15...
15		15
16	`import org.openconcerto.erp.core.common.component.AdresseSQLComponent;`	16	`import org.openconcerto.erp.core.common.component.AdresseSQLComponent;`
17	`import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;`	17	`import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;`
18	`import org.openconcerto.erp.core.customerrelationship.customer.ui.AdresseClientItemTable;`	18	`import org.openconcerto.erp.core.customerrelationship.customer.ui.AdresseClientItemTable;`
19	`import org.openconcerto.erp.core.sales.product.element.ClientCodeArticleTable;`	19	`import org.openconcerto.erp.core.sales.product.element.ClientCodeArticleTable;`
-		20	`import org.openconcerto.erp.core.sales.product.ui.CustomerProductQtyPriceListTable;`
20	`import org.openconcerto.erp.preferences.ModeReglementDefautPrefPanel;`	21	`import org.openconcerto.erp.preferences.ModeReglementDefautPrefPanel;`
21	`import org.openconcerto.erp.utils.TM;`	22	`import org.openconcerto.erp.utils.TM;`
22	`import org.openconcerto.sql.Configuration;`	23	`import org.openconcerto.sql.Configuration;`
23	`import org.openconcerto.sql.element.ElementSQLObject;`	24	`import org.openconcerto.sql.element.ElementSQLObject;`
24	`import org.openconcerto.sql.element.GroupSQLComponent;`	25	`import org.openconcerto.sql.element.GroupSQLComponent;`
Line 73...		Line 74...
73		74
74	`public class CustomerSQLComponent extends GroupSQLComponent {`	75	`public class CustomerSQLComponent extends GroupSQLComponent {`
75	`private ContactItemTable table;`	76	`private ContactItemTable table;`
76	`private ClientCodeArticleTable tableCustomProduct;`	77	`private ClientCodeArticleTable tableCustomProduct;`
77	`private AdresseClientItemTable adresseTable = new AdresseClientItemTable();`	78	`private AdresseClientItemTable adresseTable = new AdresseClientItemTable();`
-		79
78	`private SQLTable contactTable = Configuration.getInstance().getDirectory().getElement("CONTACT").getTable();`	80	`private SQLTable contactTable = Configuration.getInstance().getDirectory().getElement("CONTACT").getTable();`
79	`private final SQLTable tableNum = getTable().getBase().getTable("NUMEROTATION_AUTO");`	81	`private final SQLTable tableNum = getTable().getBase().getTable("NUMEROTATION_AUTO");`
80	`private final JUniqueTextField code = new JUniqueTextField(20) {`	82	`private final JUniqueTextField code = new JUniqueTextField(20) {`
81	`@Override`	83	`@Override`
82	`public String getAutoRefreshNumber() {`	84	`public String getAutoRefreshNumber() {`
Line 86...		Line 88...
86	`return null;`	88	`return null;`
87	`}`	89	`}`
88	`}`	90	`}`
89	`};`	91	`};`
90		92
-		93	`private CustomerProductQtyPriceListTable clienTarifTable = new CustomerProductQtyPriceListTable();`
91	`private SQLRowValues defaultContactRowVals = new SQLRowValues(UndefinedRowValuesCache.getInstance().getDefaultRowValues(this.contactTable));`	94	`private SQLRowValues defaultContactRowVals = new SQLRowValues(UndefinedRowValuesCache.getInstance().getDefaultRowValues(this.contactTable));`
92	`private JCheckBox checkAdrLivraison, checkAdrFacturation;`	95	`private JCheckBox checkAdrLivraison, checkAdrFacturation;`
93		96
94	`public CustomerSQLComponent(SQLElement element) {`	97	`public CustomerSQLComponent(SQLElement element) {`
95	`super(element);`	98	`super(element);`
Line 165...		Line 168...
165	`return new JDate(true);`	168	`return new JDate(true);`
166	`} else if (id.equals("customerrelationship.customer.contacts")) {`	169	`} else if (id.equals("customerrelationship.customer.contacts")) {`
167	`return this.table;`	170	`return this.table;`
168	`} else if (id.equals("customerrelationship.customer.customproduct")) {`	171	`} else if (id.equals("customerrelationship.customer.customproduct")) {`
169	`return this.tableCustomProduct;`	172	`return this.tableCustomProduct;`
-		173	`} else if (id.equals("customerrelationship.customer.customtarif")) {`
-		174	`return this.clienTarifTable;`
170	`} else if (id.equals("customerrelationship.customer.addresses")) {`	175	`} else if (id.equals("customerrelationship.customer.addresses")) {`
171	`return createAdressesComponent();`	176	`return createAdressesComponent();`
172	`} else if (id.equals("NOM")) {`	177	`} else if (id.equals("NOM")) {`
173	`return super.createEditor(id);`	178	`return super.createEditor(id);`
174	`}`	179	`}`
Line 241...		Line 246...
241	`@Override`	246	`@Override`
242	`public void update() {`	247	`public void update() {`
243	`super.update();`	248	`super.update();`
244	`final int selectedID = getSelectedID();`	249	`final int selectedID = getSelectedID();`
245	`this.table.updateField("ID_CLIENT", selectedID);`	250	`this.table.updateField("ID_CLIENT", selectedID);`
-		251	`this.clienTarifTable.updateField("ID_CLIENT", selectedID);`
246	`this.tableCustomProduct.updateField("ID_CLIENT", selectedID);`	252	`this.tableCustomProduct.updateField("ID_CLIENT", selectedID);`
247	`this.adresseTable.updateField("ID_CLIENT", selectedID);`	253	`this.adresseTable.updateField("ID_CLIENT", selectedID);`
248	`}`	254	`}`
249		255
250	`@Override`	256	`@Override`
Line 252...		Line 258...
252	`super.select(r);`	258	`super.select(r);`
253	`this.checkAdrLivraison.setSelected(r == null \|\| !r.getFields().contains("ID_ADRESSE_L") \|\| r.isForeignEmpty("ID_ADRESSE_L"));`	259	`this.checkAdrLivraison.setSelected(r == null \|\| !r.getFields().contains("ID_ADRESSE_L") \|\| r.isForeignEmpty("ID_ADRESSE_L"));`
254	`this.checkAdrFacturation.setSelected(r == null \|\| !r.getFields().contains("ID_ADRESSE_F") \|\| r.isForeignEmpty("ID_ADRESSE_F"));`	260	`this.checkAdrFacturation.setSelected(r == null \|\| !r.getFields().contains("ID_ADRESSE_F") \|\| r.isForeignEmpty("ID_ADRESSE_F"));`
255	`if (r != null) {`	261	`if (r != null) {`
256	`this.table.insertFrom("ID_CLIENT", r.asRowValues());`	262	`this.table.insertFrom("ID_CLIENT", r.asRowValues());`
-		263	`this.clienTarifTable.insertFrom("ID_CLIENT", r.asRowValues());`
257	`this.tableCustomProduct.insertFrom("ID_CLIENT", r.asRowValues());`	264	`this.tableCustomProduct.insertFrom("ID_CLIENT", r.asRowValues());`
258	`this.adresseTable.insertFrom("ID_CLIENT", r.asRowValues());`	265	`this.adresseTable.insertFrom("ID_CLIENT", r.asRowValues());`
259	`}`	266	`}`
260	`}`	267	`}`
261		268
Line 292...		Line 299...
292	`}`	299	`}`
293	`} else {`	300	`} else {`
294	`id = super.insert(order);`	301	`id = super.insert(order);`
295	`this.table.updateField("ID_CLIENT", id);`	302	`this.table.updateField("ID_CLIENT", id);`
296	`this.tableCustomProduct.updateField("ID_CLIENT", id);`	303	`this.tableCustomProduct.updateField("ID_CLIENT", id);`
-		304	`this.clienTarifTable.updateField("ID_CLIENT", id);`
297	`this.adresseTable.updateField("ID_CLIENT", id);`	305	`this.adresseTable.updateField("ID_CLIENT", id);`
298	`if (NumerotationAutoSQLElement.getNextNumero(getElement().getClass()).equalsIgnoreCase(this.code.getText().trim())) {`	306	`if (NumerotationAutoSQLElement.getNextNumero(getElement().getClass()).equalsIgnoreCase(this.code.getText().trim())) {`
299	`SQLRowValues rowVals = new SQLRowValues(this.tableNum);`	307	`SQLRowValues rowVals = new SQLRowValues(this.tableNum);`
300	`final SQLRow rowNumAuto = this.tableNum.getRow(2);`	308	`final SQLRow rowNumAuto = this.tableNum.getRow(2);`
301	`if (rowNumAuto.getObject("CLIENT_START") != null) {`	309	`if (rowNumAuto.getObject("CLIENT_START") != null) {`