Laboratoire ICAR » CCC

<?xml version="1.0" encoding="UTF-8"?>

<classpath>

	<classpathentry kind="src" path="src"/>

	<classpathentry kind="src" output="test-classes" path="test"/>

	<classpathentry kind="con" path="com.google.gwt.eclipse.core.GWT_CONTAINER"/>

	<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>

	<classpathentry kind="lib" path="war/WEB-INF/lib/smartgwt-skins.jar"/>

	<classpathentry kind="lib" path="war/WEB-INF/lib/smartgwt.jar"/>

	<classpathentry kind="lib" path="war/WEB-INF/lib/gwt-servlet.jar"/>

	<classpathentry kind="lib" path="war/WEB-INF/lib/hsqldb.jar"/>

	<classpathentry kind="lib" path="war/WEB-INF/lib/servlet-2_3-fcs-classfiles.zip"/>

	<classpathentry kind="lib" path="war/WEB-INF/lib/sqltool.jar"/>

	<classpathentry kind="output" path="war/WEB-INF/classes"/>

</classpath>

<?xml version="1.0" encoding="UTF-8"?>

<projectDescription>

	<name>BCCCC</name>

	<comment></comment>

	<projects>

	</projects>

	<buildSpec>

		<buildCommand>

			<name>org.eclipse.wst.common.project.facet.core.builder</name>

			<arguments>

			</arguments>

		</buildCommand>

		<buildCommand>

			<name>org.eclipse.jdt.core.javabuilder</name>

			<arguments>

			</arguments>

		</buildCommand>

		<buildCommand>

			<name>com.google.gdt.eclipse.core.webAppProjectValidator</name>

			<arguments>

			</arguments>

		</buildCommand>

		<buildCommand>

			<name>com.google.gwt.eclipse.core.gwtProjectValidator</name>

			<arguments>

			</arguments>

		</buildCommand>

	</buildSpec>

	<natures>

		<nature>org.eclipse.jdt.core.javanature</nature>

		<nature>com.google.gwt.eclipse.core.gwtNature</nature>

		<nature>org.eclipse.wst.common.project.facet.core.nature</nature>

	</natures>

</projectDescription>

SET DATABASE UNIQUE NAME HSQLDB4E0077E43C

SET DATABASE GC 0

SET DATABASE DEFAULT RESULT MEMORY ROWS 0

SET DATABASE EVENT LOG LEVEL 0

SET DATABASE TRANSACTION CONTROL LOCKS

SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED

SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE

SET DATABASE TEXT TABLE DEFAULTS ''

SET DATABASE SQL NAMES FALSE

SET DATABASE SQL REFERENCES FALSE

SET DATABASE SQL SIZE TRUE

SET DATABASE SQL TYPES FALSE

SET DATABASE SQL TDC DELETE TRUE

SET DATABASE SQL TDC UPDATE TRUE

SET DATABASE SQL TRANSLATE TTI TYPES TRUE

SET DATABASE SQL CONCAT NULLS TRUE

SET DATABASE SQL UNIQUE NULLS TRUE

SET DATABASE SQL CONVERT TRUNCATE TRUE

SET DATABASE SQL AVG SCALE 0

SET DATABASE SQL DOUBLE NAN TRUE

SET FILES WRITE DELAY 500 MILLIS

SET FILES BACKUP INCREMENT TRUE

SET FILES CACHE SIZE 10000

SET FILES CACHE ROWS 50000

SET FILES SCALE 32

SET FILES LOB SCALE 32

SET FILES DEFRAG 0

SET FILES NIO TRUE

SET FILES NIO SIZE 256

SET FILES LOG TRUE

SET FILES LOG SIZE 50

CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e'

ALTER USER SA SET LOCAL TRUE

CREATE SCHEMA PUBLIC AUTHORIZATION DBA

SET SCHEMA PUBLIC

CREATE MEMORY TABLE PUBLIC.TERRAINS(ID INTEGER PRIMARY KEY,NAME VARCHAR(45),LIEU VARCHAR(45),PARTICIPANTS INTEGER,DATE VARCHAR(45))

ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1

SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC

GRANT DBA TO SA

SET SCHEMA SYSTEM_LOBS

INSERT INTO BLOCKS VALUES(0,2147483647,0)

SET DATABASE UNIQUE NAME HSQLDB4E0077559C

SET DATABASE GC 0

SET DATABASE DEFAULT RESULT MEMORY ROWS 0

SET DATABASE EVENT LOG LEVEL 0

SET DATABASE TRANSACTION CONTROL LOCKS

SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED

SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE

SET DATABASE TEXT TABLE DEFAULTS ''

SET DATABASE SQL NAMES FALSE

SET DATABASE SQL REFERENCES FALSE

SET DATABASE SQL SIZE TRUE

SET DATABASE SQL TYPES FALSE

SET DATABASE SQL TDC DELETE TRUE

SET DATABASE SQL TDC UPDATE TRUE

SET DATABASE SQL TRANSLATE TTI TYPES TRUE

SET DATABASE SQL CONCAT NULLS TRUE

SET DATABASE SQL UNIQUE NULLS TRUE

SET DATABASE SQL CONVERT TRUNCATE TRUE

SET DATABASE SQL AVG SCALE 0

SET DATABASE SQL DOUBLE NAN TRUE

SET FILES WRITE DELAY 0

SET FILES BACKUP INCREMENT TRUE

SET FILES CACHE SIZE 10000

SET FILES CACHE ROWS 50000

SET FILES SCALE 32

SET FILES LOB SCALE 32

SET FILES DEFRAG 0

SET FILES NIO TRUE

SET FILES NIO SIZE 256

SET FILES LOG TRUE

SET FILES LOG SIZE 50

CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e'

ALTER USER SA SET LOCAL TRUE

CREATE SCHEMA PUBLIC AUTHORIZATION DBA

SET SCHEMA PUBLIC

CREATE MEMORY TABLE PUBLIC.TERRAINS(ID INTEGER PRIMARY KEY,NAME VARCHAR(45),LIEU VARCHAR(45),PARTICIPANTS INTEGER,DATE VARCHAR(45))

CREATE MEMORY TABLE PUBLIC.PROJETS(ID INTEGER PRIMARY KEY,NAME VARCHAR(45),LIEN VARCHAR(45),ID_DISCIPLINE INTEGER)

CREATE MEMORY TABLE PUBLIC.DISCIPLINES(ID INTEGER PRIMARY KEY,NAME VARCHAR(45),DESC VARCHAR(45))

CREATE MEMORY TABLE PUBLIC.PRODUIT_PAR_PROJET(ID_PROJET INTEGER,ID_TERRAIN INTEGER,FOREIGN KEY(ID_TERRAIN) REFERENCES PUBLIC.TERRAINS(ID),FOREIGN KEY(ID_PROJET) REFERENCES PUBLIC.PROJETS(ID))

CREATE MEMORY TABLE PUBLIC.PARTICIPANTS(ID INTEGER PRIMARY KEY,NAME VARCHAR(45),ROLE VARCHAR(45))

CREATE MEMORY TABLE PUBLIC.PARTICIPE(ID_PARTICIPANT INTEGER,ID_PROJET INTEGER)

CREATE MEMORY TABLE PUBLIC.EVALUATIONS(ID INTEGER PRIMARY KEY,COMMENTAIRE VARCHAR(45),ID_TERRAIN INTEGER,ID_PARTICIPANT INTEGER,FOREIGN KEY(ID_TERRAIN) REFERENCES PUBLIC.TERRAINS(ID),FOREIGN KEY(ID_PARTICIPANT) REFERENCES PUBLIC.PARTICIPANTS(ID))

CREATE MEMORY TABLE PUBLIC.RETOURS(ID INTEGER PRIMARY KEY,TYPE VARCHAR(45),LIEN VARCHAR(45),ID_TERRAIN INTEGER,ID_DONNEE INTEGER,ID_PARTICIPANT INTEGER,FOREIGN KEY(ID_TERRAIN) REFERENCES PUBLIC.TERRAINS(ID),FOREIGN KEY(ID_PARTICIPANT) REFERENCES PUBLIC.PARTICIPANTS(ID))

CREATE MEMORY TABLE PUBLIC.TYPES(ID INTEGER PRIMARY KEY,NAME VARCHAR(45),DESC VARCHAR(45))

CREATE MEMORY TABLE PUBLIC.EST_DE_TYPE(ID_TYPE INTEGER,ID_TERRAIN INTEGER,FOREIGN KEY(ID_TERRAIN) REFERENCES PUBLIC.TERRAINS(ID),FOREIGN KEY(ID_TYPE) REFERENCES PUBLIC.TYPES(ID))

CREATE MEMORY TABLE PUBLIC.KEYWORDS(ID INTEGER PRIMARY KEY,NAME VARCHAR(45),DESC VARCHAR(45))

CREATE MEMORY TABLE PUBLIC.A_POUR_KEYWORD(ID_KEYWORD INTEGER,ID_TERRAIN INTEGER,FOREIGN KEY(ID_TERRAIN) REFERENCES PUBLIC.TERRAINS(ID),FOREIGN KEY(ID_KEYWORD) REFERENCES PUBLIC.KEYWORDS(ID))

CREATE MEMORY TABLE PUBLIC.MATERIAUX(ID INTEGER PRIMARY KEY,NAME VARCHAR(45),LIEN_RAVI VARCHAR(45),TYPE VARCHAR(45),MOBILE BOOLEAN)

CREATE MEMORY TABLE PUBLIC.UTILISE_PAR(ID_MATERIEL INTEGER,ID_TERRAIN INTEGER,FOREIGN KEY(ID_TERRAIN) REFERENCES PUBLIC.TERRAINS(ID),FOREIGN KEY(ID_MATERIEL) REFERENCES PUBLIC.MATERIAUX(ID))

CREATE MEMORY TABLE PUBLIC.DOCUMENTATIONS(ID INTEGER PRIMARY KEY,ID_TYPE_DOCUMENTATION VARCHAR(45),LIEN VARCHAR(45))

CREATE MEMORY TABLE PUBLIC.DOCUMENTE(ID_DOCUMENT INTEGER,ID_TERRAIN INTEGER,FOREIGN KEY(ID_TERRAIN) REFERENCES PUBLIC.TERRAINS(ID),FOREIGN KEY(ID_DOCUMENT) REFERENCES PUBLIC.DOCUMENTATIONS(ID))

ALTER TABLE PUBLIC.PROJETS ADD FOREIGN KEY(ID_DISCIPLINE) REFERENCES PUBLIC.DISCIPLINES(ID)

ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1

SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC

GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC

GRANT DBA TO SA

SET SCHEMA SYSTEM_LOBS

INSERT INTO BLOCKS VALUES(0,2147483647,0)

#HSQL Database Engine 2.3.2

#Wed Jun 17 09:44:49 CEST 2015

version=2.3.2

modified=no

#HSQL Database Engine 2.3.2

#Wed Jun 17 12:07:49 CEST 2015

version=2.3.2

modified=no

#HSQL Database Engine 2.3.2

#Wed Jun 17 09:35:19 CEST 2015

version=2.3.2

modified=yes

/*

 * Authors: Matthieu Decorde

 * 

 * COPYRIGHT 2015 ICAR - CCC

 * 

 * This software is free software: you can redistribute it 

 * and/or modify it under the terms of the GNU General Public

 * License as published by the Free Software Foundation,

 * either version 2 of the License, or (at your option) any

 * later version.

 * 

 * This software is distributed in the hope that it will be

 * useful, but WITHOUT ANY WARRANTY; without even the implied

 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR

 * PURPOSE. See the GNU General Public License for more

 * details.

 * 

 */

package org.ccc.bcccc.server;

import java.io.BufferedReader;

import java.io.BufferedWriter;

import java.io.File;

import java.io.FileReader;

import java.io.FileWriter;

import java.io.IOException;

import java.util.HashMap;

// TODO: Auto-generated Javadoc

/**

 * The Class ConfigDB.

 */

public class ConfigDB {

	/** The Constant HOMEDIR. */

	public static final File HOMEDIR = new File(System.getProperty("user.home"), "bcccc");

	/** The Constant config_db_file. */

	protected static final File config_db_file = new File(HOMEDIR, "config.txt");

	/** The Constant ADMIN. */

	public static final String ADMIN = "ADMIN";

	/** The Constant CONTACT. */

	public static final String CONTACT = "CONTACT";

	/** The Constant db. */

	protected static final HashMap<String, String> db = new HashMap<String, String>();

	/** The loaded. */

	protected static boolean loaded = false;

	static {

		HOMEDIR.mkdir();

		if (!HOMEDIR.exists()) {

			GreetingServiceImpl.log.severe("Fail to create HOMEDIR config directory "+HOMEDIR);

		} else {

			// load values at start up

			try {

				load();

			} catch (IOException e) {

				GreetingServiceImpl.log.severe("Fail to load config from "+config_db_file+" : "+e);

				e.printStackTrace();

			}

		}

	}

	/**

	 * Load.

	 *

	 * @throws IOException Signals that an I/O exception has occurred.

	 */

	public static void load() throws IOException {

		if (!config_db_file.exists()) { // create a sample users.txt

			GreetingServiceImpl.log.severe("ConfigDB: the "+config_db_file+" file is missing creating a sample one.");

			BufferedWriter writer = new BufferedWriter(new FileWriter(config_db_file));

			writer.write(ADMIN+"\tadmin@ens-lyon.fr\n");

			writer.write(CONTACT+"\tmatthieu.decorde@ens-lyon.Fr\n");

			writer.close();

		}

		BufferedReader reader = new BufferedReader(new FileReader(config_db_file));

		String line = reader.readLine();

		while (line != null) {

			String[] split = line.split("\t",2);

			db.put(split[0], split[1]);

			line = reader.readLine();

		}

		reader.close();

		loaded = true;

	}

	/**

	 * Gets the admin.

	 *

	 * @return the admin

	 */

	public static String getAdmin() {

		return db.get(ADMIN);

	}

	/**

	 * Gets the contact.

	 *

	 * @return the contact

	 */

	public static String getContact() {

		return db.get(CONTACT);

	}

}

/*

 * Authors: Matthieu Decorde

 * 

 * COPYRIGHT 2015 ICAR - CCC

 * 

 * This software is free software: you can redistribute it 

 * and/or modify it under the terms of the GNU General Public

 * License as published by the Free Software Foundation,

 * either version 2 of the License, or (at your option) any

 * later version.

 * 

 * This software is distributed in the hope that it will be

 * useful, but WITHOUT ANY WARRANTY; without even the implied

 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR

 * PURPOSE. See the GNU General Public License for more

 * details.

 * 

 */

package org.ccc.bcccc.server;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

// TODO: Auto-generated Javadoc

/**

 * The Class HSQLDB.

 */

public class HSQLDB {

	/** The con. */

	private Connection con;

	/**

	 * Inits the.

	 *

	 * @return true, if successful

	 */

	public boolean init() {

		try {

			Class.forName("org.hsqldb.jdbc.JDBCDriver");

		} catch (ClassNotFoundException e) {

			e.printStackTrace(System.out);

			return false;

		}

		try {

			con = DriverManager.getConnection("jdbc:hsqldb:file:db/bcccc;shutdown=true;hsqldb.write_delay=false","SA","");

			//con = DriverManager.getConnection("jdbc:hsqldb:mydatabase","SA","");

			con.createStatement().executeUpdate("create table terrains (id integer, primary key(id), name varchar(45),lieu varchar(45), participants integer, date varchar(45))");

			con.createStatement().executeUpdate("create table projets (id integer, primary key(id), name varchar(45),lien varchar(45), id_discipline integer)");

			con.createStatement().executeUpdate("create table disciplines (id integer, primary key(id), name varchar(45),desc varchar(45))");

			con.createStatement().executeUpdate("alter table projets add foreign key(id_discipline) references disciplines(id)");

			con.createStatement().executeUpdate("create table produit_par_projet (id_projet integer, id_terrain integer)");

			con.createStatement().executeUpdate("alter table produit_par_projet add foreign key(id_terrain) references terrains(id)");

			con.createStatement().executeUpdate("alter table produit_par_projet add foreign key(id_projet) references projets(id)");

			con.createStatement().executeUpdate("create table participants (id integer, primary key(id), name varchar(45),role varchar(45))");

			con.createStatement().executeUpdate("create table participe (id_participant integer, id_projet integer)");

			con.createStatement().executeUpdate("create table evaluations (id integer, primary key(id), commentaire varchar(45), id_terrain integer, id_participant integer)");

			con.createStatement().executeUpdate("alter table evaluations add foreign key(id_terrain) references terrains(id)");

			con.createStatement().executeUpdate("alter table evaluations add foreign key(id_participant) references participants(id)");

			con.createStatement().executeUpdate("create table retours (id integer, primary key(id), type varchar(45), lien varchar(45), id_terrain integer, id_donnee integer, id_participant integer)");

			con.createStatement().executeUpdate("alter table retours add foreign key(id_terrain) references terrains(id)");

			con.createStatement().executeUpdate("alter table retours add foreign key(id_participant) references participants(id)");

			con.createStatement().executeUpdate("create table types (id integer, primary key(id), name varchar(45),desc varchar(45))");

			con.createStatement().executeUpdate("create table est_de_type (id_type integer, id_terrain integer)");

			con.createStatement().executeUpdate("alter table est_de_type add foreign key(id_terrain) references terrains(id)");

			con.createStatement().executeUpdate("alter table est_de_type add foreign key(id_type) references types(id)");

			con.createStatement().executeUpdate("create table keywords (id integer, primary key(id), name varchar(45),desc varchar(45))");

			con.createStatement().executeUpdate("create table a_pour_keyword (id_keyword integer, id_terrain integer)");

			con.createStatement().executeUpdate("alter table a_pour_keyword add foreign key(id_terrain) references terrains(id)");

			con.createStatement().executeUpdate("alter table a_pour_keyword add foreign key(id_keyword) references keywords(id)");

			con.createStatement().executeUpdate("create table materiaux (id integer, primary key(id), name varchar(45),lien_ravi varchar(45), type varchar(45), mobile boolean)");

			con.createStatement().executeUpdate("create table utilise_par (id_materiel integer, id_terrain integer)");

			con.createStatement().executeUpdate("alter table utilise_par add foreign key(id_terrain) references terrains(id)");

			con.createStatement().executeUpdate("alter table utilise_par add foreign key(id_materiel) references materiaux(id)");

			con.createStatement().executeUpdate("create table documentations (id integer, primary key(id), id_type_documentation varchar(45),lien varchar(45))");

			con.createStatement().executeUpdate("create table documente (id_document integer, id_terrain integer)");

			con.createStatement().executeUpdate("alter table documente add foreign key(id_terrain) references terrains(id)");

			con.createStatement().executeUpdate("alter table documente add foreign key(id_document) references documentations(id)");

//			con.createStatement().executeUpdate("create table contacts (name varchar(45),email varchar(45),phone varchar(45))");

//			PreparedStatement pst;

//			pst = con.prepareStatement("insert into contacts values(?,?,?)");

//			pst.clearParameters();

//			pst.setString(1, "name value");

//			pst.setString(2, "email value");

//			pst.setString(3, "phone value");

//			int i = pst.executeUpdate();

//			

			con.commit();

		} catch (SQLException e) {

			e.printStackTrace(System.out);

			return false;

		}

		return true;

	}

	/**

	 * Prints the db.

	 */

	public void printDB() {

		PreparedStatement pst;

		try {

			System.out.println("listing terrains...");

			pst = con.prepareStatement("select * from terrains");

			pst.clearParameters();

			ResultSet rs=pst.executeQuery();

			while(rs.next()){

				System.out.println("id="+rs.getString(1));

				System.out.println("name="+rs.getString(2));

				System.out.println("lieu="+rs.getString(3));

				System.out.println("participants="+rs.getString(4));

				System.out.println("date="+rs.getString(5));

			}

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	/**

	 * The main method.

	 *

	 * @param args the arguments

	 */

	public static void main(String[] args) {

		HSQLDB db = new HSQLDB();

		if (db.init()) {

			System.out.println("DB ready.");

			db.printDB();

			//db.close();

		} else {

			System.out.println("DB init fail.");

		}

	}

	/**

	 * Close.

	 */

	private void close() {

		try {

			con.close();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

}

/*

 * Authors: Matthieu Decorde

 * 

 * COPYRIGHT 2015 ICAR - CCC

 * 

 * This software is free software: you can redistribute it 

 * and/or modify it under the terms of the GNU General Public

 * License as published by the Free Software Foundation,

 * either version 2 of the License, or (at your option) any

 * later version.

 * 

 * This software is distributed in the hope that it will be

 * useful, but WITHOUT ANY WARRANTY; without even the implied

 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR

 * PURPOSE. See the GNU General Public License for more

 * details.

 * 

 */

package org.ccc.bcccc.server;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.HashMap;

import java.util.List;

import java.util.logging.Logger;

import java.util.regex.Pattern;

import org.ccc.bcccc.client.GreetingService;

import org.ccc.bcccc.shared.K;

import org.ccc.bcccc.shared.TerrainRecord;

import org.ccc.bcccc.shared.TerrainRecordAndRights;

import org.eclipse.jetty.util.log.Log;

import com.google.gwt.user.server.rpc.RemoteServiceServlet;

// TODO: Auto-generated Javadoc

/**

 * The server-side implementation of the RPC service.

 */

public class GreetingServiceImpl extends RemoteServiceServlet implements GreetingService {

	/** The log. */

	public static Logger log = Logger.getGlobal();

	/** The Constant serialVersionUID. */

	private static final long serialVersionUID = 8258170818449828341L;

	/** The connected users. */

	static HashMap<String, String> connectedUsers = new HashMap<String, String>();

	/** The records. */

	static RecordsDB records = new RecordsDB();

	/** The users db. */

	static UsersDB usersDB = new UsersDB();

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#createRecord(org.ccc.bcccc.shared.TerrainRecord)

	 */

	@Override

	public Boolean createRecord(TerrainRecord newRecord) {

		log.info("createRecord: "+newRecord);

		if (isLogged()) {

			newRecord.uniq_id = System.currentTimeMillis();

			if (records.containsKey(newRecord.uniq_id)) {

				log.warning("createRecord: record already exists: "+newRecord.uniq_id);

				return false;

			} else {

				String session = this.getThreadLocalRequest().getSession().getId();

				String user = connectedUsers.get(session);

				newRecord.user = user;

				records.put(newRecord.uniq_id, newRecord);

				if (!records.containsUser(user)) records.registerUser(user);

				records.setRecordToUser(user, newRecord.uniq_id);

				if (records.save(newRecord)) {

					log.info("createRecord: record created: "+newRecord.uniq_id);

					return true;

				} else {

					log.info("createRecord: record NOT created: "+newRecord.uniq_id);

					return false;

				}

			}

		} else {

			log.warning("createRecord: user is NOT logged.");

			return false;

		}

	}

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#deleteRecord(java.lang.Long)

	 */

	@Override

	public Boolean deleteRecord(Long ID) {

		log.info("deleteRecord: "+ID);

		if (isLogged()) {

			String session = this.getThreadLocalRequest().getSession().getId();

			String user = connectedUsers.get(session);

			log.info("deleteRecord: "+user);

			if (!records.containsKey(ID)) {

				log.warning("deleteRecord: record does not exists "+ID);

				return false;

			} else {

				if (records.isRecordSetToUser(user, ID) || user.equals(ConfigDB.getAdmin())) {

					log.info("deleteRecord: ok "+ID);

					TerrainRecord record = records.get(ID);

					records.remove(ID);

					records.unsetRecordToUser(user, ID);

					records.save(record);

					return true;

				} else {

					log.warning("deleteRecord: user has not the rigths "+user);

					return false;

				}

			}

		} else {

			log.warning("deleteRecord: user is NOT logged.");

			return false;

		}

	}

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#getMyRecords()

	 */

	@Override

	public ArrayList<TerrainRecord> getMyRecords() {

		log.info("getMyRecords");

		if (isLogged()) {

			String session = this.getThreadLocalRequest().getSession().getId();

			String user = connectedUsers.get(session);

			log.info("getMyRecords: "+user);

			ArrayList<Long> userRecordsID = records.getUserRecordIDs(user);

			ArrayList<TerrainRecord> my_records = new ArrayList<TerrainRecord>();

			if (userRecordsID != null) {

				for (Long recordKey : records.keySet()) {

					if (userRecordsID.contains(recordKey)) {

						TerrainRecord r = records.get(recordKey);

						my_records.add(r);

					}

				}

			}

			return my_records;

		} else {

			log.warning("getMyRecords: user is NOT logged.");

			return new ArrayList<TerrainRecord>();

		}

	}

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#getRecord(java.lang.Long)

	 */

	@Override

	public TerrainRecordAndRights getRecord(Long ID) {

		log.info("getRecord: "+ID);

		String session = this.getThreadLocalRequest().getSession().getId();

		String user = connectedUsers.get(session);

		TerrainRecordAndRights r = new TerrainRecordAndRights(records.get(ID));

		if (user != null) {

			if (user.equals(ConfigDB.getAdmin())) {

				r.deletable = true;

				r.editable = true;

				r.validable = r.record.mustBeValidated;

			} else if (user.equals(r.record.user)) {

				r.deletable = true;

				r.editable = true;

			}

		}

		return r;

	}

	/**

	 * get all records.

	 *

	 * @return the records

	 */

	@Override

	public ArrayList<TerrainRecord> getRecords() {

		log.info("getRecords");

		ArrayList<TerrainRecord> all_records = new ArrayList<TerrainRecord>(records.values());

		boolean mustRemoveNonValidatedRecords = true;

		if (isLogged()) {

			String session = this.getThreadLocalRequest().getSession().getId();

			String user = connectedUsers.get(session);

			if (user.equals(ConfigDB.getAdmin())) mustRemoveNonValidatedRecords = false;

		}

		if (mustRemoveNonValidatedRecords) {

			log.info("Removing non validated records from "+all_records.size()+" records...");

			for (int i = 0 ; i < all_records.size() ; i++) {

				TerrainRecord record = all_records.get(i);

				if (record.mustBeValidated) {

					all_records.remove(i);

					log.fine("Remove "+record);

					i--;

				}

			}

		}

		return all_records;

	}

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#getRecordsWithComplexCritera(java.util.HashMap)

	 */

	@Override

	public ArrayList<TerrainRecord> getRecordsWithComplexCritera(HashMap<String, String> critera) {

		log.info("getRecordWithComplexCritera: "+critera);

		ArrayList<TerrainRecord> searched_records = new ArrayList<TerrainRecord>();

		String words = addBackSlash(critera.get(K.WORDS)).replace(" ", "|");

		Pattern p = null;

		if (words.length() > 0) {

			try {

				p = Pattern.compile(words);

			} catch(Exception e) {

				log.warning("Error while compiling search pattern with "+words+": "+e);

				p = null;

			}

		}

		List<String> types = new ArrayList<String>();

		if (critera.get(K.TYPES).length() > 0)

			types= Arrays.asList(critera.get(K.TYPES).split(","));

		List<String> dispositifs = new ArrayList<String>();

		if (critera.get(K.DISPOSITIFS).length() > 0)

			dispositifs = Arrays.asList(critera.get(K.DISPOSITIFS).split(","));

		List<String> supports = new ArrayList<String>();

		if (critera.get(K.SUPPORTS).length() > 0)

			supports = Arrays.asList(critera.get(K.SUPPORTS).split(","));

		List<String> projets = new ArrayList<String>();

		if (critera.get(K.PROJECTS).length() > 0)

			projets = Arrays.asList(critera.get(K.PROJECTS).split(","));

		int persons = Integer.parseInt(critera.get(K.NUMBEROFPARTICIPANTS));

		log.info("getRecordWithComplexCritera: WORDS="+words+", TYPES="+types+" DISPOSITIFS="+dispositifs+" SUPPORTS="+supports+" PROJECTS="+projets+" NUMBEROFPARTICIPANTS="+persons);

		for (TerrainRecord record : records.values()) {

			if (p != null && p.matcher(record.short_description).find()) {

				searched_records.add(record);

				log.info("Found "+record+" with words critera "+words);

			} else if (persons > 0 && record.numberOfParticipants >= persons) {

				searched_records.add(record);

				log.info("Found "+record+" with persons critera "+persons);

			} else if (types.size() > 0 && inter(record.types, types)) {

				searched_records.add(record);

				log.info("Found "+record+" with types critera "+types);

			} else if (dispositifs.size() > 0 && inter(record.dispositifs, dispositifs)) {

				searched_records.add(record);

				log.info("Found "+record+" with dispositifs critera "+dispositifs);

			} else if (projets.size() > 0) {

				searched_records.add(record);

				log.info("Found "+record+" with projets critera "+projets);

			} else if (supports.size() > 0 && inter(record.supports, supports)) {

				searched_records.add(record);

				log.info("Found "+record+" with supports critera "+supports);

			}

		}

		return searched_records;

	}

	/** The chars. */

	private static String chars = "^$<>|\\\"{()}?+*."; //$NON-NLS-1$

	/**

	 * Adds the back slash.

	 *

	 * @param squery the squery

	 * @return the string

	 */

	public static String addBackSlash(String squery) {

		if ("\"".equals(squery)) return "\"\\\"\""; //$NON-NLS-1$ //$NON-NLS-2$

		StringBuffer buff = new StringBuffer();

		for(int i = 0 ; i < squery.length() ; i++) {

			int j = chars.indexOf(squery.charAt(i));

			if ( j >= 0 )

				buff.append("\\"+squery.charAt(i)); //$NON-NLS-1$

			else

				buff.append(squery.charAt(i));

		}

		return buff.toString();

	}

	/**

	 * Inter.

	 *

	 * @param big the big

	 * @param little the little

	 * @return true, if successful

	 */

	public static boolean inter(List big, List little) {

		for (Object o : little) {

			for(Object o2 : big)

				if (o2.toString().equals(o)) return true;

		}

		return false;

	}

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#getRecordsWithSimpleCritera(java.util.HashMap)

	 */

	@Override

	public ArrayList<TerrainRecord> getRecordsWithSimpleCritera(HashMap<String, String> critera) {

		log.info("getRecordWithSimpleCritera");

		ArrayList<TerrainRecord> searched_records = new ArrayList<TerrainRecord>();

		for (Long recordKey : records.keySet()) {

			if (Math.random() > 0.7) {

				searched_records.add(records.get(recordKey));

			}

		}

		return searched_records;

	}

	/**

	 * load records from database.

	 *

	 * @return user@eta if user is actually logged

	 * @throws IllegalArgumentException the illegal argument exception

	 */

	public String hello() throws IllegalArgumentException {

		log.info("hello");

		try {

			records.loadAll(); // load if needed

			String session = this.getThreadLocalRequest().getSession().getId();

			String user =  GreetingServiceImpl.connectedUsers.get(session);

			return user;

		} catch(Exception e) {

			Log.warn(e.getMessage());

			e.printStackTrace();

		}

		return null;

	}

	/**

	 * Test if the associated HTTP session is shiboleted.

	 *

	 * @return the boolean

	 */

	@Override

	public Boolean isLogged() {

		log.info("isLogged");

		String session = this.getThreadLocalRequest().getSession().getId();

		return connectedUsers.containsKey(session);

	}

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#logIn(java.lang.String, java.lang.String, java.lang.String)

	 */

	@Override

	public Boolean logIn(String login, String eta, String mdp) {

		log.info("logIn: "+login+"@"+eta);

		//if (mdp == null || !mdp.equals("lol")) return false; // TODO: replace with a shibboleth access

		if (!usersDB.test(login+"@"+eta, mdp)) {

			log.warning("logIn: wrong password/login: "+login+"@"+eta);

			return false;

		}

		//		System.setProperty("javax.net.ssl.trustStore", "...");

		//		System.setProperty("javax.net.ssl.keyStore", "...");

		//		System.setProperty("javax.net.ssl.keyStorePassword", "...");

		//System.out.println("Header names: "+this.getThreadLocalRequest().getHeaderNames());

		//		Enumeration<String> headerNames = this.getThreadLocalRequest().getHeaderNames();

		//		System.out.println("Listing names: ");

		//		while (headerNames.hasMoreElements()) {

		//			String name = headerNames.nextElement();

		//			System.out.println(" Name: "+name+"\tValue: "+this.getThreadLocalRequest().getHeader(name));

		//

		//		}

		//		String uniqueID = this.getThreadLocalRequest().getHeader("Shib-SwissEP-UniqueID");

		//		System.out.println("uniqueID: "+uniqueID);

		// Test an affiliation

		// if (request.getHeader("Shib-EP-Affiliation").equals("staff")){...}

		String session = this.getThreadLocalRequest().getSession().getId();

		connectedUsers.put(session, login+"@"+eta);

		log.info("logIn: ok "+login+"@"+eta);

		return true;

	}

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#logOut()

	 */

	@Override

	public Boolean logOut() {

		log.info("logOut");

		String session = this.getThreadLocalRequest().getSession().getId();

		connectedUsers.remove(session);

		return true;

	}

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#updateRecord(java.lang.Long, org.ccc.bcccc.shared.TerrainRecord)

	 */

	@Override

	public Boolean updateRecord(Long ID, TerrainRecord content) {

		log.info("updateRecord: "+ID+" "+content);

		if (isLogged()) {

			String session = this.getThreadLocalRequest().getSession().getId();

			String user = connectedUsers.get(session);

			log.info("updateRecord: user="+user);

			if (records.containsKey(ID)) {

				log.warning("updateRecord: record does not exists: "+ID);

				return false;

			} else {

				if (records.isRecordSetToUser(user, ID)) {

					log.info("updateRecord: updating record: "+ID);

					TerrainRecord record = records.get(ID);

					if (record.mustBeValidated) {

						log.warning("updateRecord: record needs to be validatd before: "+ID);

						return false;

					}

					record.setDetailFields(content.numberOfParticipants, content.place, content.types, content.keywords, content.dispositifs, content.documentations, content.supports, content.reports, content.publications);

					record.setInfoFields(content.name, content.project, content.date, content.short_description, content.user);

					return records.save(record);

				} else {

					log.warning("updateRecord: user "+user+" can't edit record "+ID);

					return false;

				}

			}

		} else {

			log.warning("updateRecord: user is NOT logged");

			return false;

		}

	}

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#setValidateRecordValue(java.lang.Long, java.lang.Boolean)

	 */

	@Override

	public boolean setValidateRecordValue(Long ID, Boolean newValue) {

		log.info("validateRecord: "+ID+": "+newValue);

		if (isLogged()) {

			String session = this.getThreadLocalRequest().getSession().getId();

			String user = connectedUsers.get(session);

			log.info("validateRecord: user="+user);

			if (user.equals(ConfigDB.getAdmin())) {

				log.info("validateRecord: user is admin");

				TerrainRecord record = records.get(ID);

				record.mustBeValidated = newValue;

				return records.save(records.get(ID));

			} else {

				log.warning("validateRecord: user is NOT admin");

				return false;

			}

		} else {

			log.warning("validateRecord: user is NOT logged");

			return false;

		}

	}

	/* (non-Javadoc)

	 * @see org.ccc.bcccc.client.GreetingService#isAdmin()

	 */

	@Override

	public Boolean isAdmin() {

		log.info("isAdmin");

		if (isLogged()) {

			String session = this.getThreadLocalRequest().getSession().getId();

			String user = connectedUsers.get(session);

			return user.equals(ConfigDB.getAdmin());

		} else {

			return false;

		}

	}

}

/*

 * Authors: Matthieu Decorde

 * 

 * COPYRIGHT 2015 ICAR - CCC

 * 

 * This software is free software: you can redistribute it 

 * and/or modify it under the terms of the GNU General Public

 * License as published by the Free Software Foundation,

 * either version 2 of the License, or (at your option) any

 * later version.

 * 

 * This software is distributed in the hope that it will be

 * useful, but WITHOUT ANY WARRANTY; without even the implied

 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR

 * PURPOSE. See the GNU General Public License for more

 * details.

 * 

 */

package org.ccc.bcccc.server;

import java.io.File;

import java.io.FileInputStream;

import java.text.DateFormat;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.HashMap;

import javax.xml.parsers.DocumentBuilder;

import javax.xml.parsers.DocumentBuilderFactory;

import javax.xml.transform.Transformer;

import javax.xml.transform.TransformerFactory;

import javax.xml.transform.dom.DOMSource;

import javax.xml.transform.stream.StreamResult;

import org.ccc.bcccc.shared.Data;

import org.ccc.bcccc.shared.Dispositif;

import org.ccc.bcccc.shared.DocumentUnit;

import org.ccc.bcccc.shared.K;

import org.ccc.bcccc.shared.TerrainRecord;

import org.w3c.dom.Document;

import org.w3c.dom.Element;

import org.w3c.dom.NodeList;

// TODO: Auto-generated Javadoc

/**

 * The Class RecordsDB.

 */

public class RecordsDB extends HashMap<Long, TerrainRecord> {

	/** The Constant serialVersionUID. */

	private static final long serialVersionUID = -1902619207859271728L;

	// TODO: replace this shit with a SGBD access

	/** The all users record ids. */

	// TODO: a record is not a String -> create the CCCRecord object

	HashMap<String, ArrayList<Long>> allUsersRecordIDS = new HashMap<String, ArrayList<Long>>();

	/** The Constant RECORD_EXT. */

	public final static String RECORD_EXT = ".record.xml";

	/** The Constant recordsDB. */

	public final static File recordsDB = new File(ConfigDB.HOMEDIR, "records");

	/** The Constant formatter. */

	public static final DateFormat formatter = new SimpleDateFormat("YYYY-MM-DD");

	/** The loaded. */

	boolean loaded = false;

	/**

	 * Instantiates a new records db.

	 */

	public RecordsDB() {

//		this.put("test1", new TerrainRecord().setInfoFields("test1", "projet A", new Date(),  "desc test1", "A"));

//		this.put("test2", new TerrainRecord().setInfoFields("test2", "projet A", new Date(),  "desc test1", "A"));

//		this.put("test3", new TerrainRecord().setInfoFields("test3", "projet B", new Date(),  "desc test1", "A"));

//		this.put("test4", new TerrainRecord().setInfoFields("test4", "projet B", new Date(),  "desc test1", "A"));

//		this.put("test5", new TerrainRecord().setInfoFields("test5", "projet C", new Date(),  "desc test1", "A"));

//		this.put("test6", new TerrainRecord().setInfoFields("test6", "projet D", new Date(),  "desc test1", "A"));

//		this.put("test7", new TerrainRecord().setInfoFields("test7", "projet B", new Date(),  "desc test1", "A"));

//		this.put("test8", new TerrainRecord().setInfoFields("test8", "projet A", new Date(),  "desc test1", "A"));

	}

	/**

	 * Contains user.

	 *

	 * @param user the user

	 * @return true, if successful

	 */

	public boolean containsUser(String user) {

		return allUsersRecordIDS.containsKey(user);

	}

	/**

	 * Register user.

	 *

	 * @param user the user

	 * @return the array list

	 */

	public ArrayList<Long> registerUser(String user) {

		return allUsersRecordIDS.put(user, new ArrayList<Long>());

	}

	/**

	 * Gets the user record i ds.

	 *

	 * @param user the user

	 * @return the user record i ds

	 */

	public ArrayList<Long> getUserRecordIDs(String user) {

		return allUsersRecordIDS.get(user);

	}

	/**

	 * Sets the record to user.

	 *

	 * @param user the user

	 * @param uniq_id the uniq_id

	 * @return true, if successful

	 */

	public boolean setRecordToUser(String user, long uniq_id) {

		return allUsersRecordIDS.get(user).add(uniq_id);

	}

	/**

	 * Unset record to user.

	 *

	 * @param user the user

	 * @param recordID the record id

	 * @return true, if successful

	 */

	public boolean unsetRecordToUser(String user, Long recordID) {

		return allUsersRecordIDS.get(user).remove(recordID);

	}

	/**

	 * Checks if is record set to user.

	 *

	 * @param user the user

	 * @param recordID the record id

	 * @return true, if is record set to user

	 */

	public boolean isRecordSetToUser(String user, Long recordID) {

		return allUsersRecordIDS.get(user).contains(recordID);

	}

	/**

	 * Load all.

	 */

	public void loadAll() {

		if (loaded) return;

		recordsDB.mkdir();

		File[] files = recordsDB.listFiles();

		if (files != null)

		for (File recordDB : files) {

			if (recordDB.getName().endsWith(RECORD_EXT)) {

				TerrainRecord record = new TerrainRecord();

				DocumentBuilderFactory builderFactory =	DocumentBuilderFactory.newInstance();

				DocumentBuilder builder = null;

				try {

					builder = builderFactory.newDocumentBuilder();

					Document document = builder.parse(new FileInputStream(recordDB));

					Element rootElement = document.getDocumentElement();

					String uniq_id_str = rootElement.getAttribute(K.UNIQID);

					String name = rootElement.getAttribute(K.ID);

					String project = rootElement.getAttribute(K.PROJECT);

					String date_str = rootElement.getAttribute(K.DATE);

					String year_str = rootElement.getAttribute(K.YEAR);

					String user = rootElement.getAttribute(K.USER);

					String numberOfParticipants_str = rootElement.getAttribute(K.NUMBEROFPARTICIPANTS);

					String place = rootElement.getAttribute(K.PLACE);

					String mustBeValidated_str = rootElement.getAttribute(K.MUSTBEVALIDATED);

					record.uniq_id = Long.parseLong(uniq_id_str);

					record.name = name;

					record.project = project;

					record.place = place;

					record.user = user;

					record.numberOfParticipants = Integer.parseInt(numberOfParticipants_str);

					record.date = formatter.parse(date_str);

					record.year = Integer.parseInt(year_str);

					record.mustBeValidated = Boolean.parseBoolean(mustBeValidated_str);

					// get description

					NodeList nodes = rootElement.getElementsByTagName(K.DESC);

					for (int i=0; i<nodes.getLength(); i++){

						Element node = (Element)(nodes.item(i));

						String desc = node.getTextContent();

						record.short_description = desc;

					}

					// get types

					NodeList types = rootElement.getElementsByTagName(K.TYPE);

					for (int i=0; i<types.getLength(); i++){

						Element node = (Element)(types.item(i));

						String type = node.getTextContent();

						record.types.add(type);

					}

					// get keywords

					NodeList keywords = rootElement.getElementsByTagName(K.KEYWORD);

					for (int i=0; i<keywords.getLength(); i++){

						Element node = (Element)(keywords.item(i));

						String keyword = node.getTextContent();

						record.keywords.add(keyword);

					}

					// get dispositifs

					NodeList dispositifs = rootElement.getElementsByTagName(K.DISPOSITIF);

					for (int i=0; i<dispositifs.getLength(); i++){

						Element node = (Element)(dispositifs.item(i));

						String dname = node.getAttribute(K.NAME);

						String url = node.getAttribute(K.URL);

						boolean mobile = Boolean.parseBoolean(node.getAttribute(K.MOBILE));

						record.dispositifs.add(new Dispositif(dname, url, mobile));

					}

					// get supports

					NodeList supports = rootElement.getElementsByTagName(K.SUPPORT);

					for (int i=0; i<supports.getLength(); i++){

						Element node = (Element)(supports.item(i));

						String type = node.getAttribute(K.TYPE);

						String url = node.getAttribute(K.URL);

						record.supports.add(new Data(type, url));

					}

					// get documentations

					NodeList documentations = rootElement.getElementsByTagName(K.DOCUMENTATION);

					for (int i=0; i<documentations.getLength(); i++){

						Element node = (Element)(documentations.item(i));

						String type = node.getAttribute(K.TYPE);

						String dname = node.getAttribute(K.NAME);

						String url = node.getAttribute(K.URL);

						record.documentations.add(new DocumentUnit(type, url, dname));

					}

					this.put(record.uniq_id, record);

					if (!this.containsUser(record.user)) this.registerUser(record.user);

					this.setRecordToUser(record.user, record.uniq_id);

				} catch (Exception e) {

					GreetingServiceImpl.log.warning("Fail to load record: "+recordDB+" "+e);

					e.printStackTrace();  

				} 

			}

		}

		loaded = true;

	}

	/**

	 * If record is not registered then it'll be deleted from file system.

	 *

	 * @param record the record

	 * @return true, if successful

	 */

	public boolean save(TerrainRecord record) {

		File recordDB = new File(recordsDB, record.uniq_id+".record.xml"); // TODO: create uniq_id then the use will be allow to rename records

		recordsDB.mkdir();

		if (!this.containsKey(record.uniq_id)) { // must be deleted

			recordDB.delete();

			return true;

		}

		DocumentBuilderFactory builderFactory =	DocumentBuilderFactory.newInstance();

		DocumentBuilder builder = null;

		try {

			builder = builderFactory.newDocumentBuilder();

			Document doc = builder.newDocument();

			Element rootElement = doc.createElement(K.RECORD);

			doc.appendChild(rootElement);

			rootElement.setAttribute(K.UNIQID, Long.toString(record.uniq_id));

			rootElement.setAttribute(K.ID, record.name);

			rootElement.setAttribute(K.PROJECT, record.project);

			rootElement.setAttribute(K.USER, record.user);

			rootElement.setAttribute(K.DATE, formatter.format(record.date));

			rootElement.setAttribute(K.YEAR, Integer.toString(record.year));

			rootElement.setAttribute(K.NUMBEROFPARTICIPANTS, Integer.toString(record.numberOfParticipants));

			rootElement.setAttribute(K.PLACE, record.place);

			rootElement.setAttribute(K.MUSTBEVALIDATED, Boolean.toString(record.mustBeValidated));

			Element descriptionElement = doc.createElement(K.DESC);

			rootElement.appendChild(descriptionElement);

			descriptionElement.setTextContent(record.short_description);

			for (String v : record.types) {

				Element e = doc.createElement(K.TYPE);

				e.setTextContent(v);

				rootElement.appendChild(e);