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

package org.openconcerto.modules.customersupport;

import java.sql.SQLException;

import java.util.Date;

import java.util.HashSet;

import java.util.Set;

import javax.swing.JComponent;

import javax.swing.JLabel;

import org.openconcerto.sql.element.GroupSQLComponent;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.sqlobject.SQLSearchableTextCombo;

import org.openconcerto.sql.users.UserManager;

import org.openconcerto.ui.JDateTime;

import org.openconcerto.ui.component.ComboLockedMode;

import org.openconcerto.ui.component.ITextArea;

import org.openconcerto.ui.group.Group;

import org.openconcerto.utils.ExceptionHandler;

public class CustomerSupportTicketSQLComponent extends GroupSQLComponent {

    public CustomerSupportTicketSQLComponent(SQLElement element, Group group) {

        super(element, group);

    }

    @Override

    protected Set<String> createRequiredNames() {

        final Set<String> s = new HashSet<String>(1);

        s.add("ID_CLIENT");

        s.add("ID_USER_COMMON");

        s.add("LABEL");

        s.add("DATE");

        s.add("STATUS");

        return s;

    }

    @Override

    public int insert(SQLRow order) {

        int id = super.insert(order);

        SQLRow row = getTable().getRow(id);

        try {

            final SQLRowValues createEmptyUpdateRow = row.createEmptyUpdateRow();

            createEmptyUpdateRow.put("NUMBER", id);

            if (row.getObject("DATE") == null) {

                createEmptyUpdateRow.put("DATE", new Date());

            }

            SQLRowValues rowValsHisto = new SQLRowValues(getTable().getTable(Module.TABLE_CUSTOMER_SUPPORT_TICKET_HISTORY));

            rowValsHisto.put("INFORMATION", "Ouverture du ticket");

            // rowValsHisto.put("DATE", row.getObject("DATE"));

            rowValsHisto.put("ID_USER_COMMON", row.getForeignID("ID_USER_COMMON"));

            rowValsHisto.put("ID_" + getTable().getName(), createEmptyUpdateRow);

            createEmptyUpdateRow.commit();

        } catch (SQLException e) {

            ExceptionHandler.handle("Impossible d'affecter un numéro sur le ticket", e);

        }

        return id;

    }

    @Override

    public JComponent createEditor(String id) {

        if (id.equals("INFOS")) {

            final ITextArea jTextArea = new ITextArea();

            jTextArea.setFont(new JLabel().getFont());

            jTextArea.setRows(3);

            return jTextArea;

        } else if (id.equals("TYPE") || id.equals("STATUS") || id.equals("RATING")) {

            return new SQLSearchableTextCombo(ComboLockedMode.UNLOCKED, 1, 20, false);

        } else if (id.equals("DATE")) {

            return new JDateTime(true);

        }

        return super.createEditor(id);

    }

    @Override

    protected SQLRowValues createDefaults() {

        SQLRowValues rowVals = new SQLRowValues(getTable());

        rowVals.put("STATUS", "Nouveau");

        rowVals.put("RATING", "Normale");

        final int idUser = UserManager.getInstance().getCurrentUser().getId();

        rowVals.put("ID_USER_COMMON", idUser);

        return rowVals;

    }

}