db=jdbc:postgresql://studentittools.ipl.be:5432/dbmickael_marlard?user=mickael_marlard&password=aca452
DalServices=dal.dalimpl.DalServicesImpl
BizFactory=biz.factory.BizFactoryImpl
PropertiesHandler=util.PropertiesHandler
DalBackendServices=dal.dalimpl.DalServicesImpl


############
#User#######
############

UserUcc=biz.uccimpl.UserUccImpl
UserDao=dal.daoimpl.UserDaoImpl

############
#Mobility#######
############

MobilityDao=dal.daoimpl.MobilityDaoImpl
MobilityUcc=biz.uccimpl.MobilityUccImpl

############
#Country#######
############

CountryDao=dal.daoimpl.CountryDaoImpl
CountryUcc=biz.uccimpl.CountryUccImpl

############
#student#######
###########

StudentDao=dal.daoimpl.StudentDaoImpl
StudentUcc=biz.uccimpl.StudentUccImpl

############
#csv#######
###########

CsvDao=dal.daoimpl.CsvDaoImpl
CsvUcc=biz.uccimpl.CsvUccImpl

############
#payment#######
###########

PaymentDao=dal.daoimpl.PaymentDaoImpl
PaymentUcc=biz.uccimpl.PaymentUccImpl


############
#partner#######
###########

PartnerDao=dal.daoimpl.PartnerDaoImpl
PartnerUcc=biz.uccimpl.PartnerUccImpl


################
###Query########
################

#QueryUser
query.findUser=SELECT * FROM izymobi.utilisateurs WHERE pseudo=(?)
query.insertUser= INSERT INTO izymobi.utilisateurs (pseudo, mot_de_passe, sel, email, nom, prenom, date_inscription, professeur) VALUES (?,?,?,?,?,?,?,?)
query.updateToTeacher = UPDATE izymobi.utilisateurs SET professeur = (?), version = (?) WHERE id_utilisateur = (?) AND version =
query.getStudentForMobility = SELECT * FROM izymobi.utilisateurs WHERE id_utilisateur IN (SELECT id_etudiant FROM izymobi.mobilites WHERE id_mobilite = (?) )
query.getUsersInfos=SELECT * FROM izymobi.utilisateurs WHERE id_utilisateur = (?)
query.searchUserWithFirstName= SELECT * FROM izymobi.utilisateurs WHERE prenom LIKE '% (?) %'
query.searchUserWithLastName=SELECT * FROM izymobi.utilisateurs WHERE nom LIKE '% (?) %'
query.searchUser=SELECT u.* FROM izymobi.utilisateurs AS u, izymobi.etudiants AS e WHERE LOWER(u.nom) LIKE LOWER((?)) AND LOWER(u.prenom) LIKE LOWER((?)) AND u.id_utilisateur = e.id_utilisateur

#QueryCountries
query.selectAllCountries=SELECT * FROM izymobi.pays
query.getMatchingCountry=SELECT * FROM izymobi.pays WHERE nom LIKE '% (?) %'

#QueryMobility
query.CreateMobility= INSERT INTO izymobi.mobilites (id_etudiant, id_partenaire, type_programme, anneeAcademique, quadrimestre, priorite, date_introduction, etat_mobilite, etat_demande_payement, contrat_bourse, convention, charte_etudiant, test_langue_aller, test_langue_retour, engagement, attestation_sejour, releve_notes_certificat, rapport_final, annulation, commentaire_annulation, version) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
query.UpdateCancellation= UPDATE izymobi.mobilites SET annulation = (?),commentaire_annulation=(?), version=(?) WHERE id_mobilite = (?) AND version = (?)
query.UpdateMobilityState= UPDATE izymobi.mobilites SET etat_mobilite = (?), version=(?) WHERE id_mobilite = (?) AND version = (?)
query.UpdateScholarshipContractSignature=UPDATE izymobi.mobilites SET contrat_bourse = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
query.UpdateStageConventionSignature=UPDATE izymobi.mobilites SET convention = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
query.UpdateStudentConventionSignature=UPDATE izymobi.mobilites SET charte_etudiant = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
query.UpdateLinguisticTestToGo=UPDATE izymobi.mobilites SET test_langue_aller = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
query.UpdateEngagementDocumentSignature=UPDATE izymobi.mobilites SET engagement = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
query.UpdatePaymentRequestState=UPDATE izymobi.mobilites SET etat_demande_payment = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
query.UpdateSojournCertificate=UPDATE izymobi.mobilites SET attestation_sejour = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
query.UpdateStudentNotes=UPDATE izymobi.mobilites SET releve_notes_certificat = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
query.UpdateFinalReport=UPDATE izymobi.mobilites SET rapport_final = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
query.UpdateLinguisticTestsProof=UPDATE izymobi.mobilites SET test_langue_retour = (?), version=(?) WHERE id_mobilite = (?) AND version=(?)
query.findMobilityWithAcademicYear=SELECT * FROM izymobi.mobilites WHERE anneeAcademique LIKE '% (?) %'
query.findMobilityWithMobilityState=SELECT * FROM izymobi.mobilites WHERE etat_mobilite LIKE '% (?) %'
query.selectStudentMobilities=SELECT * FROM izymobi.mobilites WHERE id_etudiant = (?)
query.findMobilityWithId=SELECT * FROM izymobi.mobilites WHERE id_mobilite =(?)
query.getMobilitiesByYear=SELECT * FROM izymobi.mobilites WHERE anneeAcademique =(?)
query.getMobilitiesByYearDepartment=SELECT * FROM izymobi.mobilites WHERE anneeAcademique = (?) AND id_partenaire IN (SELECT id_partenaire FROM izymobi.partenaires WHERE departement LIKE '% (?) %')
query.selectAllCancellationComments=SELECT * FROM izymobi.mobilites
query.searchMobility=SELECT * FROM izymobi.mobilities WHERE anneeAcademique = (?) AND etat_mobilite LIKE ' (?) '


#QueryPartenaire
query.insertPartenaire=INSERT INTO izymobi.partenaires (nom_legal, nom_affaires, nom_complet, type_organisation, nb_employes, adresse, code_postal, ville, region, pays, email, telephone, site_web, departement, version, visibilite) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
query.searchPartnerWithName=SELECT * FROM izymobi.partenaires WHERE nom_complet LIKE '% (?) %' AND department = "UNI"
query.findAllUniPartner = SELECT * FROM izymobi.partenaires WHERE type_organisation LIKE ' (?) '
query.findAllPartners = SELECT * FROM izymobi.partenaires
query.updatePartner=UPDATE izymobi.partenaires SET nom_legal =(?), nom_affaires=(?), nom_complet=(?), type_organisation=(?), nb_employes=(?), adresse=(?), code_postal=(?), ville=(?), region=(?), pays=(?), email=(?), telephone=(?), site_web=(?), departement=(?), version=(?), visibilite=(?) WHERE id_partenaire=(?) AND version =(?)
query.findPartnerWithCountry = SELECT * FROM izymobi.partenaires WHERE id_partenaire = (?)
query.getPartner = SELECT * FROM izymobi.partenaires WHERE id_partenaire = (SELECT id_partenaire FROM izymobi.mobilites WHERE id_mobilite =(?))
query.getMobilityPartner = SELECT id_partenaire FROM izymobi.mobilites WHERE id_mobilite = (?)
query.searchPartnerWithCountry=SELECT * FROM izymobi.partenaires WHERE pays LIKE '% (?) %' AND department = "UNI"
query.searchPartnerWithTown=SELECT * FROM izymobi.partenaires WHERE ville LIKE '% (?) %' AND department = "UNI"
query.searchPartner=SELECT * FROM izymobi.partenaires WHERE pays LOWER(nom_complet) LIKE LOWER((?)) AND pays LIKE LOWER((?)) AND ville LIKE LOWER((?)) AND department = "UNI"
query.deletePartner=UPDATE izymobi.partenaires SET visibilite = false, version = (?) WHERE id_partenaire = (?) AND version = (?)
query.getAllVisiblePartners = SELECT * FROM izymobi.partenaires WHERE visibilite = true


#QueryStudent
query.findStudent=SELECT * FROM izymobi.etudiants WHERE id_utilisateur = (?)
query.insertStudent=INSERT INTO izymobi.etudiants (departement, date_naissance, sexe, nationalite, adresse, telephone, annees_reussies, compte_bancaire, proeco, mobi_mobility_tool, version, id_utilisateur) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)
query.updateStudent=UPDATE izymobi.etudiants SET departement=(?), date_naissance=(?), sexe=(?), nationalite=(?), adresse=(?), telephone=(?), annees_reussies=(?), compte_bancaire=(?), proeco=(?), mobi_mobility_tool=(?), version=(?) WHERE id_utilisateur=(?) AND version=(?)
query.getAllStudents= SELECT * FROM izymobi.etudiants
query.updateBankAccount=UPDATE izymobi.comptes_bancaires SET titulaire =(?), bic=(?), banque=(?), version=(?) WHERE compte_bancaire=(?) AND version=(?)
query.insertBankAccount=INSERT INTO izymobi.comptes_bancaires (titulaire, bic, banque, version) VALUES(?,?,?,?)
query.findBankAccount=SELECT * FROM izymobi_comptes_bancaires WHERE compte_bancaire =(?)

#QueryPayment
query.getAllPaymentsFromMobilityId= SELECT * FROM izymobi.paiements WHERE id_mobilite =(?)
query.CreatePayment=INSERT INTO izymobi.paiements (id_mobilite, pourcentage_paye, date_paiement, version) VALUES (?,?,?,?)