/**
* {@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.');
}
/**
* @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()));
}