package optipalette.ui.model;

import com.ownyx.table.ORTableModel;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Query;
import optipalette.entities.Client;
import optipalette.entities.Echange;
import optipalette.entities.TypePalette;

/**
 *
 * @author mr
 */
public class StatClientModel extends ORTableModel {

    List echanges = fetchList(null, null);
    String[] cols = {"Date", "N° Ordre", "Référence", "Type palette", "Enlevées", "Laissées", "Chèque", "N° Chèque", "Validité"};

    public StatClientModel() {
        super();
        echanges = fetchList(null, null);
        List<Class> columnsClass = new ArrayList<Class>();
        setColumnsClass(columnsClass);
        for (int i = 0; i < cols.length; i++) {
            columnsClass.add(Object.class);
        }
        columnsClass.set(0, Date.class);
        columnsClass.set(7, Date.class);
    }

    public void updateTable(Client client, TypePalette typePalette) {
        echanges = fetchList(client, typePalette);
        fireTableDataChanged();
    }

    public int getRowCount() {
        if (echanges != null) {
            return echanges.size();
        } else {
            return 0;
        }
    }

    public int getColumnCount() {
        return cols.length;
    }

    @Override
    public String getColumnName(int column) {
        return cols[column];
    }

    public Object getValueAt(int rowIndex, int columnIndex) {
        Echange echange = (Echange) echanges.get(rowIndex);
        switch (columnIndex) {
            case 0:
                return echange.getMouvement().getDateMouvement();
            case 1:
                return echange.getMouvement().getOrdre();
            case 2:
                return echange.getMouvement().getReference();
            case 3:
                return echange.getTypePalette().getNom();
            case 4:
                return echange.getNombrePaletteEnlevee();
            case 5:
                return echange.getNombrePaletteLaissee();
            case 6:
                if (echange.getMouvement().getChequeCollection().iterator().hasNext()) {
                    return echange.getMouvement().getChequeCollection().iterator().next().getNombrePalette();
                }
            case 7:
                if (echange.getMouvement().getChequeCollection().iterator().hasNext()) {
                    return echange.getMouvement().getChequeCollection().iterator().next().getNumero();
                }
            case 8:
                if (echange.getMouvement().getChequeCollection().iterator().hasNext()) {
                    return echange.getMouvement().getChequeCollection().iterator().next().getValidite();
                }
            default:
                return "";
        }
    }

    public List fetchList(Client client, TypePalette typePalette) {
        List list = null;
        EntityManagerFactory emf = javax.persistence.Persistence.createEntityManagerFactory("OptiPalettePU");
        EntityManager em = emf.createEntityManager();
        em.getTransaction().begin();
        try {
            if (!(client == null || typePalette == null)) {
                Query query = em.createQuery(
                        "select e from Echange e " +
                        "where e.client = :client " +
                        "and e.typePalette = :type_palette " +
                        "order by e.mouvement.dateMouvement desc");
                query.setParameter("client", client);
                query.setParameter("type_palette", typePalette);
                list = query.getResultList();
            }
        } catch (Exception e) {
            e.printStackTrace();
            em.getTransaction().rollback();
        } finally {
            em.close();
        }
        return list;
    }
}