package com.vetropack;

import android.app.Activity;
import android.content.Context;
import android.content.Intent;
import android.os.Bundle;
import android.os.Environment;

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.*;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Map;


public class SessionDAO {
	private static String PATH_DOSSIER = Environment.getExternalStorageDirectory()+"/Vetropack/";
	private static String NOM_FICHIER = "bulletin_livraisons.xlsm";
	private static int LIGNE_DEPART = 11;
	
	private Context context;
	private Session session;
	
	public SessionDAO(Context context, Session session) {
		this.context = context;
		this.session = session;
	}
	
	public void ajoutFichier() throws Exception {
		try {
			File dir = new File (PATH_DOSSIER);
			if (!dir.exists())
			{
				dir.mkdirs();
			}

			File file = new File(PATH_DOSSIER, NOM_FICHIER);

            System.setProperty("org.apache.poi.javax.xml.stream.XMLInputFactory", "com.fasterxml.aalto.stax.InputFactoryImpl");
            System.setProperty("org.apache.poi.javax.xml.stream.XMLOutputFactory", "com.fasterxml.aalto.stax.OutputFactoryImpl");
            System.setProperty("org.apache.poi.javax.xml.stream.XMLEventFactory", "com.fasterxml.aalto.stax.EventFactoryImpl");

			XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(file));
			
			ArrayList<Chargement> chargements = this.session.getChargements();
			
			for(int i=0; i<chargements.size(); i++)
			{
				Chargement chargement = chargements.get(i);
				XSSFSheet sheet = wb.getSheetAt(i);


				XSSFRow rowNbPal = sheet.getRow(LIGNE_DEPART - 1);
				XSSFCell cellNbPal = rowNbPal.getCell(9);
				cellNbPal.setCellValue(chargement.getPalettes().size());
				
				SimpleDateFormat SDFormat = new SimpleDateFormat("dd/MM/yyyy");
				
				ArrayList<Palette> palettes = chargement.getPalettes();
				for(int j=0; j<palettes.size(); j++)
				{
					Palette palette = palettes.get(j);
					XSSFRow row = sheet.getRow(LIGNE_DEPART + j);
					
					XSSFCell cellSAP = row.getCell(1);
					cellSAP.setCellValue(palette.getNumSAP());
					
					XSSFCell cellDate = row.getCell(2);
					cellDate.setCellValue(SDFormat.format(palette.getDate().getTime()));
					
					XSSFCell cellPal = row.getCell(3);
					cellPal.setCellValue(palette.getNumPalette());

					XSSFCell cellOrdre = row.getCell(4);
					cellOrdre.setCellValue(palette.getNumOrdre());
				}
			}

			FileOutputStream out = new FileOutputStream(file);
			wb.write(out);
			out.close();
			wb.close();
		}
		catch(FileNotFoundException e) {
			e.printStackTrace();
			throw new Exception("Impossible d'accéder au fichier, carte SD manquante ou en cours d'utilisation par une autre application");
		}
		catch(IOException e) {
			e.printStackTrace();
		}
	}

	private void copierModele() throws Exception {
	    InputStream in = null;
	    OutputStream out = null;
	    try {


	        in = this.context.getResources().getAssets().open(NOM_FICHIER);    
	        out = new FileOutputStream(PATH_DOSSIER + NOM_FICHIER);

	        byte[] buffer = new byte[1024];
	        int read;
	        while ((read = in.read(buffer)) != -1) {
	            out.write(buffer, 0, read);
	        }
	        in.close();
	        in = null;

            // write the output file
            out.flush();
	        out.close();
	        out = null;
	    } 
	    catch (FileNotFoundException e) {
	    	e.printStackTrace();
	    	throw e;
	    }
	    catch (Exception e) {
	        e.printStackTrace();
	        throw e;
	    }

	}
	
	public boolean fichierExistant() {
		File file = new File(PATH_DOSSIER, NOM_FICHIER);
		return file.exists();
	}
}