source: ether_megapoli/trunk/service/implementation/com/medias/integration/lecture_ecriture/LectureParametres.java @ 482

/**
 * Created on 26 Jan. 2007
 */

/**
 * @author 
 * 
 * 
 */

package integration.lecture_ecriture;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import jxl.Sheet;
import jxl.Workbook;
import jxl.WorkbookSettings;
import jxl.read.biff.BiffException;
import integration.utils.Constantes;

public class LectureParametres {

        private ArrayList<String> numerosParam;
        private ArrayList<String> nomsParam;
        private ArrayList<String> codesMegapoliParam;
        private ArrayList<String> categoriesParam;
        private ArrayList<String> numsUnitesParam;
        private ArrayList<String> descriptionsParam;
        private ArrayList<String> nomsParamFromFile;

        public LectureParametres() {
        }

        public void lireFichier() {
                //      Etape d'accés au chemin du modéle xml é amanipuler
                String nomFichierParam = Constantes.cheminListes + "/" + Constantes.nomListeParametres;
                File fichier = new File(nomFichierParam);
                if (fichier.exists()) {
                        Workbook workbook = null;
                        try {
                                WorkbookSettings ws = new WorkbookSettings();
                                ws.setEncoding(Constantes.encodageDefaut);
                                workbook = Workbook.getWorkbook(fichier, ws);
                        } catch (BiffException e) {
                                e.printStackTrace();
                        } catch (IOException e) {
                                e.printStackTrace();
                        }
                        //      Etape ou l'on récupére les données de la 1ére page du classeur
                        Sheet sheet = workbook.getSheet(0);
                        
                        //      Initialisation des listes.
                        numerosParam = new ArrayList<String>();
                        nomsParam = new ArrayList<String>();
                        codesMegapoliParam = new ArrayList<String>();
                        numsUnitesParam = new ArrayList<String>();
                        //descriptionsParam = new ArrayList<String>();
                        categoriesParam = new ArrayList<String>();
                        nomsParamFromFile = new ArrayList<String>();
                        //      Etape de lecture des cellules
                        int nbParams = sheet.getRows() - 1;//Constantes.nbParametres
                        for (int numParam = 0; numParam < nbParams; numParam++) {
                                numerosParam.add(sheet.getCell(0, numParam + 1).getContents());
                                nomsParam.add(sheet.getCell(1, numParam + 1).getContents());
                                codesMegapoliParam.add(sheet.getCell(2, numParam + 1).getContents());
                                categoriesParam.add(sheet.getCell(3, numParam + 1).getContents());
                                numsUnitesParam.add(sheet.getCell(4, numParam + 1).getContents());
                                nomsParamFromFile.add(sheet.getCell(5, numParam + 1).getContents());
                                //descriptionsParam.add(sheet.getCell(4, numParam + 1).getContents());
                        }
                        //      Etape de fermeture du flux
                        workbook.close();
                } else {
                        EcritureLog.ecrire(
                                        "Fichier " + fichier.getName() + " non trouvé !", "err");

                }
        }
        
        public ArrayList<String> getNumerosParam() {
                return numerosParam;
        }
        public ArrayList<String> getNomsParam() {
                return nomsParam;
        }
        public ArrayList<String> getCodesMegapoliParam() {
                return codesMegapoliParam;
        }
        public ArrayList<String> getNumsUnitesParam() {
                return numsUnitesParam;
        }
        public ArrayList<String> getDescriptionsParam() {
                return descriptionsParam;
        }
        public ArrayList<String> getCategoriesParam() {
                return categoriesParam;
        }

        public ArrayList<String> getNomsParamFromFile() {
                return nomsParamFromFile;
        }

        public int getIndice(int numero) {
                int indice = -1;
                int numeroCourant;
                for (int indiceListe = 0; indiceListe < numerosParam.size(); indiceListe++) {
                        numeroCourant = Integer.parseInt((String)numerosParam.get(indiceListe));
                        if (numeroCourant == numero) {
                                indice = indiceListe;
                                return indice;
                        }
                }
                return indice;
        }
}