/**
* Get Adresse Mail Etu.
*
* @return string format@etu.emse.fr
*/
public function getEmailEtu(Membre $membre)
{
$now = new \DateTime('now');
$now = (int) $now->format('Y');
if ($promo = $membre->getPromotion() && $membre->getPersonne()) {
if ($promo < $now) {
return preg_replace('#[^a-zA-Z.0-9_]#', '', $this->enMinusculeSansAccent($membre->getPersonne()->getPrenom() . '.' . $membre->getPersonne()->getNom())) . $this->emailAncien;
} else {
return preg_replace('#[^a-zA-Z.0-9_]#', '', $this->enMinusculeSansAccent($membre->getPersonne()->getPrenom() . '.' . $membre->getPersonne()->getNom())) . $this->emailEtu;
}
} elseif ($membre->getPersonne()) {
return preg_replace('#[^a-zA-Z.0-9_]#', '', $this->enMinusculeSansAccent($membre->getPersonne()->getPrenom() . '.' . $membre->getPersonne()->getNom())) . $this->emailEtu;
} else {
return '';
}
}
/**
* @Security("has_role('ROLE_SUIVEUR')")
*/
public function modifierAction($id)
{
$em = $this->getDoctrine()->getManager();
$documentManager = $this->get('Mgate.document_manager');
if (!($membre = $em->getRepository('Mgate\\PersonneBundle\\Entity\\Membre')->find($id))) {
$membre = new Membre();
$now = new \DateTime('now');
$now->modify('+ 3 year');
$membre->setPromotion($now->format('Y'));
$now = new \DateTime('now');
$now->modify('- 20 year');
$membre->setDateDeNaissance($now);
}
// Mail étudiant
if (!$membre->getEmailEMSE()) {
$email_etu_service = $this->container->get('Mgate.email_etu');
$membre->setEmailEMSE($email_etu_service->getEmailEtu($membre));
}
$form = $this->createForm(new MembreType(), $membre);
$deleteForm = $this->createDeleteForm($id);
$mandatsToRemove = $membre->getMandats()->toArray();
$form = $this->createForm(new MembreType(), $membre);
if ($this->get('request')->getMethod() == 'POST') {
$form->handleRequest($this->get('request'));
$photoUpload = $form->get('photo')->getData();
if ($form->isValid()) {
if ($membre->getPersonne()) {
// Photo de l'étudiant
$path = $membre->getPromotion() . '/' . preg_replace('#[^a-zA-Z0-9ÁÀÂÄÉÈÊËÍÌÎÏÓÒÔÖÚÙÛÜáàâäéèêëíìîïóòôöúùûüÇç\\-_]#', '_', mb_strtolower($membre->getPersonne()->getNom(), 'UTF-8')) . '_' . preg_replace('#[^a-zA-Z0-9ÁÀÂÄÉÈÊËÍÌÎÏÓÒÔÖÚÙÛÜáàâäéèêëíìîïóòôöúùûüÇç\\-_]#', '_', mb_strtolower($membre->getPersonne()->getPrenom(), 'UTF-8'));
} else {
$path = '';
}
$promo = $membre->getPromotion();
/*
* Traitement de l'image de profil
*/
if ($membre->getPersonne()) {
$authorizedMIMEType = array('image/jpeg', 'image/png', 'image/bmp');
$photoInformation = new RelatedDocument();
$photoInformation->setMembre($membre);
$name = 'Photo - ' . $membre->getIdentifiant() . ' - ' . $membre->getPersonne()->getPrenomNom();
if ($photoUpload) {
$document = $documentManager->uploadDocumentFromFile($photoUpload, $authorizedMIMEType, $name, $photoInformation, true);
$membre->setPhotoURI($document->getWebPath());
} elseif (!$membre->getPhotoURI() && $promo !== null && $membre->getPersonne()) {
// Spécifique EMSE
$ressourceURL = 'http://ismin.emse.fr/ismin/Photos/P' . urlencode($path);
$headers = get_headers($ressourceURL);
if (preg_match('#200#', $headers[0])) {
$document = $documentManager->uploadDocumentFromUrl($ressourceURL, $authorizedMIMEType, $name, $photoInformation, true);
$membre->setPhotoURI($document->getWebPath());
}
}
}
/*
* Traitement des postes
*/
if ($this->get('request')->get('add')) {
$mandatNew = new Mandat();
$poste = $em->getRepository('Mgate\\PersonneBundle\\Entity\\Poste')->findOneBy(array('intitule' => 'Membre'));
$dt = new \DateTime('now');
$dtl = clone $dt;
$dtl->modify('+1 year');
if ($poste) {
$mandatNew->setPoste($poste);
}
$mandatNew->setMembre($membre);
$mandatNew->setDebutMandat($dt);
$mandatNew->setFinMandat($dtl);
$membre->addMandat($mandatNew);
}
if (!$membre->getIdentifiant()) {
$initial = substr($membre->getPersonne()->getPrenom(), 0, 1) . substr($membre->getPersonne()->getNom(), 0, 1);
$ident = count($em->getRepository('Mgate\\PersonneBundle\\Entity\\Membre')->findBy(array('identifiant' => $initial))) + 1;
while ($em->getRepository('Mgate\\PersonneBundle\\Entity\\Membre')->findOneBy(array('identifiant' => $initial . $ident))) {
++$ident;
}
$membre->setIdentifiant(strtoupper($initial . $ident));
}
if (isset($now)) {
// Si c'est un nouveau membre et qu'on ajoute un poste
$em->persist($membre);
$em->flush();
return $this->redirect($this->generateUrl('MgatePersonne_membre_modifier', array('id' => $membre->getId())));
}
// Suppression des mandat à supprimer
//Recherche des mandats supprimés
foreach ($membre->getMandats() as $mandat) {
$key = array_search($mandat, $mandatsToRemove);
if ($key !== false) {
array_splice($mandatsToRemove, $key, 1);
}
}
//Supression de la BDD
foreach ($mandatsToRemove as $mandat) {
$em->remove($mandat);
}
$em->persist($membre);
// persist $etude / $form->getData()
$em->flush();
$form = $this->createForm(new MembreType(), $membre);
}
}
return $this->render('MgatePersonneBundle:Membre:modifier.html.twig', array('form' => $form->createView(), 'delete_form' => $deleteForm->createView(), 'photoURI' => $membre->getPhotoURI()));
}
/**
* {@inheritdoc}
*/
protected function execute(InputInterface $input, OutputInterface $output)
{
$em = $this->getContainer()->get('doctrine.orm.entity_manager');
$array_projects = array(array('nom' => '315GLA', 'description' => 'Realisation site web', 'statut' => 1, 'nbrJEH' => 9, 'duree' => 5, 'dateCC' => 'ok', 'prospect' => array('entreprise' => 'Gladiator Consulting', 'adresse' => '3 rue du chene noir', 'codePostal' => 33100, 'ville' => 'Toulouse', 'entite' => 2, 'email' => '*****@*****.**')), array('nom' => '316BLA', 'description' => 'Electronique avancee', 'statut' => 2, 'nbrJEH' => 5, 'duree' => 3, 'dateCC' => 'ok', 'prospect' => array('entreprise' => 'Blackwater', 'adresse' => '1020 5th Avenue', 'codePostal' => 92200, 'ville' => 'Neuilly', 'entite' => 3, 'email' => '*****@*****.**')), array('nom' => '317IMU', 'description' => 'Design Base de donnes', 'statut' => 4, 'nbrJEH' => 8, 'duree' => 4, 'dateCC' => 'ok', 'prospect' => array('entreprise' => 'Imuka', 'adresse' => 'Kuruma San', 'codePostal' => 91000, 'ville' => 'Evry', 'entite' => 4, 'email' => '*****@*****.**')), array('nom' => '319UNI', 'description' => 'Conception Radar recul', 'statut' => 4, 'nbrJEH' => 12, 'duree' => 8, 'dateCC' => 'ok', 'prospect' => array('entreprise' => 'Universal rad', 'adresse' => '2 rue Marie Curie', 'codePostal' => 35000, 'ville' => 'Rennes', 'entite' => 5, 'email' => '*****@*****.**')), array('nom' => '320TEK', 'description' => 'Refactorisation code Java', 'statut' => 2, 'nbrJEH' => 10, 'duree' => 8, 'dateCC' => 'ok', 'prospect' => array('entreprise' => 'Teknik studio', 'adresse' => '10 impasse sunderland', 'codePostal' => 35000, 'ville' => 'Rennes', 'entite' => 6, 'email' => '*****@*****.**')), array('nom' => '321DUV', 'description' => 'Calcul de flux thermique', 'statut' => 2, 'nbrJEH' => 9, 'duree' => 4, 'dateCC' => 'ok', 'prospect' => array('entreprise' => 'Duvilcolor', 'adresse' => '600 la pyrennene ', 'codePostal' => 33100, 'ville' => 'Labege', 'entite' => 4, 'email' => '*****@*****.**')), array('nom' => '322NIL', 'description' => 'Application Android', 'statut' => 1, 'nbrJEH' => 8, 'duree' => 12, 'dateCC' => 'ok', 'prospect' => array('entreprise' => 'Nilsen Industries', 'adresse' => '2 rue saint-louis', 'codePostal' => 31000, 'ville' => 'Bordeaux', 'entite' => 7, 'email' => '*****@*****.**')), array('nom' => '323PRR', 'description' => 'Etude de faisabilite', 'statut' => 3, 'nbrJEH' => 4, 'duree' => 4, 'dateCC' => 'ok', 'prospect' => array('entreprise' => 'PRR', 'adresse' => 'PRR', 'codePostal' => 35000, 'ville' => 'Rennes', 'entite' => 4, 'email' => '*****@*****.**')));
$inserted_projects = 0;
$inserted_prospects = 0;
foreach ($array_projects as $etude) {
//create project
$e = new Etude();
$inserted_projects++;
$mandat = rand(2013, 2016);
$month = rand(1, 10);
$day = rand(1, 30);
$e->setMandat($mandat);
$e->setNom($etude['nom']);
$e->setDescription($etude['description']);
$e->setDateCreation(new \DateTime($mandat . '-' . $month . '-' . $day));
$e->setStateID($etude['statut']);
$e->setAcompte(true);
$e->setPourcentageAcompte(0.3);
$e->setFraisDossier(90);
$e->setPresentationProjet('Presentation ' . $etude['description']);
$e->setDescriptionPrestation('Describe what we will do here');
$e->setSourceDeProspection(rand(1, 10));
$em->persist($e);
$c = $em->getRepository('N7consultingRhBundle:Competence')->find(rand(1, 12));
if ($c !== null) {
$c->addEtude($e);
}
/** Prospect management */
$p = new Prospect();
$inserted_prospects++;
$p->setNom($etude['prospect']['entreprise']);
$p->setAdresse($etude['prospect']['adresse']);
$p->setCodePostal($etude['prospect']['codePostal']);
$p->setVille($etude['prospect']['ville']);
$p->setEntite($etude['prospect']['entite']);
$pe = new Personne();
$pe->setPrenom(self::PRENOM[array_rand(self::PRENOM)]);
//whitespace explode : not perfect but better than nothing
$pe->setNom(self::NOM[array_rand(self::NOM)]);
$pe->setEmailEstValide(true);
$pe->setEstAbonneNewsletter(false);
$pe->setEmail($etude['prospect']['email']);
$pe->setAdresse($etude['prospect']['adresse']);
$pe->setCodePostal($etude['prospect']['codePostal']);
$pe->setVille($etude['prospect']['ville']);
$emp = new Employe();
$emp->setProspect($p);
$p->addEmploye($emp);
$emp->setPersonne($pe);
$em->persist($emp->getPersonne());
$em->persist($emp);
$em->persist($p);
$e->setProspect($p);
//create phases
$g = new GroupePhases();
//default group
$g->setTitre('Random generated' . rand());
$g->setNumero(1);
$g->setDescription('Automatic description');
$g->setEtude($e);
$em->persist($g);
$ph = new Phase();
$ph->setEtude($e);
$ph->setGroupe($g);
$ph->setPosition(0);
$ph->setNbrJEH($etude['nbrJEH']);
$ph->setPrixJEH(340);
$ph->setTitre('Default phase');
$ph->setDelai($etude['duree'] * 7);
$ph->setDateDebut(new \DateTime($mandat . '-' . $month . '-' . $day));
$em->persist($ph);
//manage project manager
$pm = new Personne();
$pm->setPrenom(self::PRENOM[array_rand(self::PRENOM)]);
$pm->setNom(self::NOM[array_rand(self::NOM)]);
$pm->setEmailEstValide(false);
$pm->setEstAbonneNewsletter(false);
$em->persist($pm);
$m = new Membre();
$m->setPersonne($pm);
$m->setPromotion($mandat + 2);
$em->persist($m);
if ($c !== null) {
$c->addMembre($m);
}
$e->setSuiveur($pm);
//manage AP & CC
if ($etude['dateCC'] !== null && $etude['statut'] > 1) {
$ap = new Ap();
$ap->setEtude($e);
$em->persist($ap);
$cc = new Cc();
$cc->setEtude($e);
$cc->setDateSignature(new \DateTime($mandat . '-' . $month . '-' . $day));
$cc->setSignataire2($pe);
$em->persist($cc);
}
//manage intervenant
if ($etude['statut'] > 1 && $etude['statut'] < 5) {
//manage developper
$dev = new Personne();
$dev->setPrenom(self::PRENOM[array_rand(self::PRENOM)]);
$dev->setNom(self::NOM[array_rand(self::NOM)]);
$dev->setEmailEstValide(false);
$dev->setEstAbonneNewsletter(false);
$em->persist($dev);
$mdev = new Membre();
$mdev->setPersonne($dev);
$mdev->setPromotion($mandat + rand(1, 2));
$em->persist($mdev);
if ($c !== null) {
$c->addMembre($mdev);
}
$mi = new Mission();
$mi->setSignataire2($dev);
$mi->setEtude($e);
$mi->setDateSignature(new \DateTime($mandat . '-' . $month . '-' . $day));
$mi->setDebutOm(new \DateTime($mandat . '-' . $month . '-' . $day));
$mi->setAvancement(rand(90, 100));
$mi->setIntervenant($mdev);
$em->persist($mi);
}
//manage PVR
if ($etude['statut'] > 1 && $etude['statut'] < 5) {
$pv = new ProcesVerbal();
$pv->setEtude($e);
$pv->setDateSignature(new \DateTime($mandat . '-' . ($month + 1) . '-' . $day));
$pv->setSignataire2($pe);
$pv->setType('pvr');
$em->persist($pv);
}
}
$em->flush();
$output->writeln('Done.');
}
/**
* @param UploadedFile $file resources file contzaining data to import.
* @return mixed Process Import.
* Process Import.
*/
public function run(UploadedFile $file)
{
if ($file->guessExtension() == "txt") {
//csv is seen as text/plain
$i = 1;
$inserted_projects = 0;
$inserted_prospects = 0;
if (($handle = fopen($file->getPathname(), "r")) !== FALSE) {
$array_manager = array();
//an array containing references to managers.
$array_prospect = array();
//an array containing references to projects.
//iterate csv, row by row
while (($data = fgetcsv($handle, 0, ",")) !== FALSE) {
if ($i > 1 && $this->readArray($data, 'Intitule') != "") {
//first row is column headers
$etude = $this->em->getRepository('MgateSuiviBundle:Etude')->findOneByNom($this->readArray($data, 'Intitule'));
if ($etude === null) {
//create project if it doesn't exists in DB
$e = new Etude();
$inserted_projects++;
$e->setMandat($this->readArray($data, 'Exercice comptable'));
// $e->setNum($this->readArray($data, 'No Etude')); //untrusted, can be duplicated in siaje.
$e->setNom($this->readArray($data, 'Intitule'));
$e->setDescription($this->readArray($data, 'Domaine de compétence'));
$e->setDateCreation($this->dateManager($this->readArray($data, 'Date d\'ajout')));
if (array_key_exists($this->normalize($this->readArray($data, 'Statut')), self::SIAJE_AVAILABLE_STATE)) {
$e->setStateID(self::SIAJE_AVAILABLE_STATE[$this->normalize($this->readArray($data, 'Statut'))]);
} else {
$e->setStateID(self::SIAJE_AVAILABLE_STATE['Contact initial']);
}
$e->setAcompte(true);
if ($this->readArray($data, 'Acompte') !== null) {
$rate = explode(',', $this->readArray($data, 'Acompte'));
//acompte is a percentage such as "30,00%".
$e->setPourcentageAcompte($rate['0'] / 100);
}
$e->setFraisDossier($this->readArray($data, 'Frais de dossier HT'));
$e->setPresentationProjet('Etude importée depuis Siaje');
$e->setDescriptionPrestation($this->readArray($data, 'Domaine de compétence'));
$e->setPourcentageAcompte($this->readArray($data, 'Acompte'));
$this->em->persist($e);
/** Prospect management */
// Check if a prospect with same already exists in database
if ($this->readArray($data, 'Entreprise', true) !== "") {
$prospect = $this->em->getRepository('MgatePersonneBundle:Prospect')->findOneByNom($this->readArray($data, 'Entreprise', true));
if ($prospect === null) {
//check if prospect already exist in local objects
if (array_key_exists($this->readArray($data, 'Entreprise', true), $array_prospect)) {
$prospect = $array_prospect[$this->readArray($data, 'Entreprise', true)];
}
}
} else {
$prospect = null;
}
if ($prospect !== null) {
$e->setProspect($prospect);
} else {
$p = new Prospect();
$inserted_prospects++;
if ($this->readArray($data, 'Entreprise', true) !== "") {
$p->setNom($this->readArray($data, 'Entreprise', true));
} else {
$p->setNom('Prospect sans nom ' . rand());
}
$p->setAdresse($this->readArray($data, 'Adresse'));
$p->setCodePostal($this->readArray($data, 'Code Postal'));
$p->setVille($this->readArray($data, 'Ville'));
$contact = explode(' ', $this->normalize($this->readArray($data, 'Contact', true)));
$pe = new Personne();
$pe->setPrenom($contact[0]);
//whitespace explode : not perfect but better than nothing
unset($contact[0]);
if (implode(' ', $contact) == "") {
$pe->setNom('inconnu');
} else {
$pe->setNom(implode(' ', $contact));
}
$pe->setEmailEstValide(true);
$pe->setEstAbonneNewsletter(false);
$pe->setEmail($this->readArray($data, 'Email'));
$pe->setAdresse($this->readArray($data, 'Adresse'));
$pe->setCodePostal($this->readArray($data, 'Code Postal'));
$pe->setVille($this->readArray($data, 'Ville'));
$emp = new Employe();
$emp->setProspect($p);
$p->addEmploye($emp);
$emp->setPersonne($pe);
$this->em->persist($emp->getPersonne());
$this->em->persist($emp);
$this->em->persist($p);
$e->setProspect($p);
$array_prospect[$this->readArray($data, 'Entreprise', true)] = $p;
}
//create phases
$g = new GroupePhases();
//default group
$g->setTitre('Imported from Siaje');
$g->setNumero(1);
$g->setDescription('Automatic description');
$g->setEtude($e);
$this->em->persist($g);
$ph = new Phase();
$ph->setEtude($e);
$ph->setGroupe($g);
$ph->setPosition(0);
$ph->setNbrJEH($this->readArray($data, 'JEHs'));
if ($this->readArray($data, 'JEHs') > 0) {
$ph->setPrixJEH(round($this->floatManager($this->readArray($data, 'Montant HT')) / $this->floatManager($this->readArray($data, 'JEHs'))));
}
$ph->setTitre('Default phase');
$ph->setDelai($this->readArray($data, 'Durée en semaine') * 7);
$ph->setDateDebut($this->dateManager($this->readArray($data, 'Date signature CC')));
$this->em->persist($ph);
//manage project manager
$contact = explode(' ', $this->normalize($this->readArray($data, 'Suiveur principal', true)));
$firstname = $contact[0];
unset($contact[0]);
$surname = implode(' ', $contact);
$pm = $this->em->getRepository('MgatePersonneBundle:Personne')->findOneBy(array('nom' => $surname, 'prenom' => $firstname));
if ($pm !== null) {
$e->setSuiveur($pm);
} else {
//create a new member and a new person
if (array_key_exists($this->readArray($data, 'Suiveur principal', true), $array_manager) && $this->readArray($data, 'Suiveur principal', true) != '') {
//has already been created before
$e->setSuiveur($array_manager[$this->readArray($data, 'Suiveur principal', true)]);
} else {
$pm = new Personne();
$pm->setPrenom($firstname);
if ($surname == "") {
$pm->setNom('inconnu');
} else {
$pm->setNom($surname);
}
$pm->setEmailEstValide(false);
$pm->setEstAbonneNewsletter(false);
$this->em->persist($pm);
$m = new Membre();
$m->setPersonne($pm);
$this->em->persist($m);
$e->setSuiveur($pm);
$array_manager[$this->readArray($data, 'Suiveur principal', true)] = $pm;
}
}
//manage AP & CC
if ($this->dateManager($this->readArray($data, 'Date signature CC')) !== null) {
$ap = new Ap();
$ap->setEtude($e);
$this->em->persist($ap);
$cc = new Cc();
$cc->setEtude($e);
$cc->setDateSignature($this->dateManager($this->readArray($data, 'Date signature CC')));
if (isset($pe)) {
//if firm has been created in this loop iteration
$cc->setSignataire2($pe);
}
$this->em->persist($cc);
}
//manage PVR
if ($this->dateManager($this->readArray($data, 'Date signature PV')) !== null) {
$pv = new ProcesVerbal();
$pv->setEtude($e);
$pv->setDateSignature($this->dateManager($this->readArray($data, 'Date signature PV')));
$this->em->persist($pv);
}
}
}
$i++;
}
fclose($handle);
$this->em->flush();
}
return array('inserted_projects' => $inserted_projects, 'inserted_prospects' => $inserted_prospects);
}
return array('inserted_projects' => 0, 'inserted_prospects' => 0);
}