/**
* @Route("/contrat/{id}/societe", name="contrats_societe")
* @ParamConverter("societe", class="AppBundle:Societe")
*/
public function societeAction(Request $request, Societe $societe)
{
$dm = $this->get('doctrine_mongodb')->getManager();
$contrats = $this->get('contrat.manager')->getRepository()->findBy(array('societe' => $societe->getId()), array('dateDebut' => 'DESC'));
usort($contrats, array("AppBundle\\Document\\Contrat", "cmpContrat"));
return $this->render('contrat/societe.html.twig', array('societe' => $societe, 'contrats' => $contrats));
}
public function createFromImport($ligne)
{
if (!is_numeric($ligne[self::CSV_ID_SOCIETE])) {
return;
}
$societe = new Societe();
$societe->setIdentifiant(sprintf("%06d", $ligne[self::CSV_ID_SOCIETE]));
$societe->setIdentifiantReprise($ligne[self::CSV_ID_SOCIETE]);
$societe->setRaisonSociale($ligne[self::CSV_RAISON_SOCIALE]);
$societe->setCodeComptable($ligne[self::CSV_CODE_COMPTABLE]);
$societe->setCommentaire(null);
$ligne[self::CSV_COMMENTAIRE] = str_replace('"', "", $ligne[self::CSV_COMMENTAIRE]);
$ligne[self::CSV_ADRESSE_COMMENTAIRE] = str_replace('"', "", $ligne[self::CSV_COMMENTAIRE]);
if ($ligne[self::CSV_TYPE_ADRESSE] != "1") {
$ligne[self::CSV_ADRESSE_COMMENTAIRE] = null;
}
if (trim($ligne[self::CSV_COMMENTAIRE])) {
$societe->setCommentaire($ligne[self::CSV_COMMENTAIRE] . "\n");
}
if (trim($ligne[self::CSV_ADRESSE_COMMENTAIRE]) && $ligne[self::CSV_COMMENTAIRE] != $ligne[self::CSV_ADRESSE_COMMENTAIRE]) {
$societe->setCommentaire($societe->getCommentaire() . "\n" . $ligne[self::CSV_ADRESSE_COMMENTAIRE]);
}
$societe->setSousTraitant(!$ligne[self::CSV_SOUS_TRAITANT]);
$adresse = new Adresse();
$adresseStr = $ligne[self::CSV_ADRESSE_SOCIETE_1];
if ($ligne[self::CSV_ADRESSE_SOCIETE_2]) {
$adresseStr .= ", " . $ligne[self::CSV_ADRESSE_SOCIETE_2];
}
$adresse->setAdresse($adresseStr);
$adresse->setCodePostal($ligne[self::CSV_CP]);
$adresse->setCommune($ligne[self::CSV_VILLE]);
$societe->setAdresse($adresse);
$contactCoordonnee = new ContactCoordonnee();
$contactCoordonnee->setTelephoneFixe($ligne[self::CSV_TEL_FIXE]);
$contactCoordonnee->setTelephoneMobile($ligne[self::CSV_TEL_MOBILE]);
$contactCoordonnee->setFax($ligne[self::CSV_FAX]);
$contactCoordonnee->setSiteInternet($ligne[self::CSV_SITE_WEB]);
$contactCoordonnee->setEmail($ligne[self::CSV_EMAIL]);
$societe->setContactCoordonnee($contactCoordonnee);
if ($ligne[self::CSV_TYPE_SOCIETE] == "") {
$societe->setType(EtablissementManager::TYPE_ETB_NON_SPECIFIE);
} else {
$types_etablissements = EtablissementManager::$type_libelles;
$types_etb_keys = array_keys($types_etablissements);
if (intval($ligne[self::CSV_TYPE_SOCIETE]) - 1 >= 0) {
$societe->setType($types_etb_keys[intval($ligne[self::CSV_TYPE_SOCIETE]) - 1]);
}
}
return $societe;
}
public function getBySociete(Societe $societe)
{
return $this->createQueryBuilder()->field('paiement.facture')->equals(new \MongoRegex('/^FACTURE-' . $societe->getIdentifiant() . '.*/i'))->sort('dateCreation', 'desc')->getQuery()->execute();
}
/**
* @Route("/decloturer/{id}/{factureId}", name="facture_decloturer")
* @ParamConverter("societe", class="AppBundle:Societe")
*/
public function decloturerAction(Request $request, Societe $societe, $factureId)
{
$dm = $this->get('doctrine_mongodb')->getManager();
$facture = $this->get('facture.manager')->getRepository()->findOneById($factureId);
$facture->decloturer();
$dm->persist($facture);
$dm->flush();
return $this->redirectToRoute('facture_societe', array('id' => $societe->getId()));
}
public function findBySociete(Societe $societe)
{
return $this->getRepository()->findBy(array('societe' => $societe->getId()), array('dateEmission' => 'desc'));
}
