source: ether_megapoli/trunk/service/implementation/com/medias/integration/lecture_ecriture/LectureOrganismes.java @ 488

/*
 * Created on 29 Jan. 2007
 */
/**
 * @author 
 * 
 * 
 */
package com.medias.integration.lecture_ecriture;

import com.medias.Constantes;
import jxl.Sheet;
import jxl.Workbook;
import jxl.WorkbookSettings;
import jxl.read.biff.BiffException;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;

public class LectureOrganismes {
        public LectureOrganismes() {
        }

        public void lireFichier() {
                String nomFichierOrg = Constantes.cheminListes + "/" + Constantes.nomListeOrganismes;
                File fichier = new File(nomFichierOrg);
                if (fichier.exists()) {
                        // Etape ou l' on crée le Workbook
                        Workbook workbook = null;
                        try {
                                WorkbookSettings ws = new WorkbookSettings();
                                //ws.setEncoding("OS2-850");//ISO-8859-1
                                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.
                        numerosOrg = new ArrayList<String>();
                        nomsOrg = new ArrayList<String>();
                        descriptionsOrg = new ArrayList<String>();
                        mailsOrg = new ArrayList<String>();
                        urlsOrg = new ArrayList<String>();
                        ruesOrg = new ArrayList<String>();
                        codesPostalsOrg = new ArrayList<String>();
                        villesOrg = new ArrayList<String>();
                        paysOrg = new ArrayList<String>();
                        int nbOrganismes = sheet.getRows() - 1;//Constantes.nbOrganismes;
                        // Etape de lecture des cellules
                        for (int numOrg = 0; numOrg < nbOrganismes; numOrg++) {
                                numerosOrg.add(sheet.getCell(0, numOrg + 1).getContents());
                                nomsOrg.add(sheet.getCell(1, numOrg + 1).getContents());
                                descriptionsOrg.add(sheet.getCell(2, numOrg + 1).getContents());
                                mailsOrg.add(sheet.getCell(3, numOrg + 1).getContents());
                                urlsOrg.add(sheet.getCell(4, numOrg + 1).getContents());
                                ruesOrg.add(sheet.getCell(5, numOrg + 1).getContents());
                                codesPostalsOrg.add(sheet.getCell(6, numOrg + 1).getContents());
                                villesOrg.add(sheet.getCell(7, numOrg + 1).getContents());
                                paysOrg.add(sheet.getCell(8, numOrg + 1).getContents());
                        }
                        // Etape de fermeture du flux
                        workbook.close();
                }
        }
        
        public int getIndice(int numero) {
                int indice = -1;
                int numeroCourant;
                for (int indiceListe = 0; indiceListe < numerosOrg.size(); indiceListe++) {
                        numeroCourant = Integer.parseInt((String)numerosOrg.get(indiceListe));
                        if (numeroCourant == numero) {
                                indice = indiceListe;
                                return indice;
                        }
                }
                return indice;
        }

        public ArrayList<String> getNumerosOrg() {
                return numerosOrg;
        }

        public ArrayList<String> getNomsOrg() {
                return nomsOrg;
        }

        public ArrayList<String> getMailsOrg() {
                return mailsOrg;
        }

        public ArrayList<String> getDescriptionsOrg() {
                return descriptionsOrg;
        }

        public ArrayList<String> getRuesOrg() {
                return ruesOrg;
        }

        public ArrayList<String> getCodesPostalsOrg() {
                return codesPostalsOrg;
        }

        public ArrayList<String> getVillesOrg() {
                return villesOrg;
        }

        public ArrayList<String> getPaysOrg() {
                return paysOrg;
        }

        public ArrayList<String> getUrlsOrg() {
                return urlsOrg;
        }

        private ArrayList<String> numerosOrg;
        private ArrayList<String> nomsOrg;
        private ArrayList<String> mailsOrg;
        private ArrayList<String> descriptionsOrg;
        private ArrayList<String> ruesOrg;
        private ArrayList<String> codesPostalsOrg;
        private ArrayList<String> villesOrg;
        private ArrayList<String> paysOrg;
        private ArrayList<String> urlsOrg;
}