public function load(ObjectManager $manager)
{
$newClient1 = new Client();
$newClient1->setFullname("Иванов Иван");
$newClient1->setEmail("*****@*****.**");
$newClient1->setPhone("+7 (912) 12-34-567");
$newClient1->setStatus("Действующий");
$manager->persist($newClient1);
$newClient2 = new Client();
$newClient2->setFullname("Клиент 2");
$newClient2->setEmail("*****@*****.**");
$newClient2->setStatus("Действующий");
$manager->persist($newClient2);
$newClient3 = new Client();
$newClient3->setFullname("Клиент 3");
$newClient3->setEmail("*****@*****.**");
$newClient3->setStatus("Потенциальный");
$manager->persist($newClient3);
$newClient4 = new Client();
$newClient4->setFullname("Клиент 4");
$newClient4->setEmail("*****@*****.**");
$newClient4->setPhone("+7 (912) 76-54-321");
$newClient4->setStatus("Прошлый");
$manager->persist($newClient4);
$newClient5 = new Client();
$newClient5->setFullname("Петр Петров");
$newClient5->setEmail("*****@*****.**");
$newClient5->setPhone("+7 (912) 00-00-000");
$newClient5->setStatus("Потенциальный");
$manager->persist($newClient5);
$manager->flush();
$this->addReference('Client1', $newClient1);
$this->addReference('Client2', $newClient2);
$this->addReference('Client3', $newClient3);
$this->addReference('Client4', $newClient4);
$this->addReference('Client5', $newClient5);
}
public function processDataImportClients($lignes, $em)
{
foreach ($lignes as $col) {
//client traitement
$client = $em->getRepository('AppBundle:Client')->find($col['id']);
if (!$client) {
$client = new Client();
$client->setNom($col['nom']);
$client->setPrenom($col['prenom']);
$client->setEmail($col['email']);
$client->setSexe($col['sexe']);
$em->persist($client);
} else {
$client->setNom($col['nom']);
$client->setPrenom($col['prenom']);
$client->setEmail($col['email']);
$client->setSexe($col['sexe']);
}
// adresses traitement
if ($col['adresses'] != NULL) {
$adresses = explode(",", $col['adresses']);
foreach ($adresses as $adr) {
$adresseBase = $em->getRepository('AppBundle:Adresses')->findOneBy(array('adresse' => $adr, "client" => $client));
//var_dump($adresseBase);die;
if (!$adresseBase) {
$adresse = new Adresses();
$adresse->setAdresse($adr);
$adresse->setCp(78150);
$adresse->setVille("Le Chesnay");
$adresse->setPays("France");
$adresse->setClient($client);
$em->persist($adresse);
} else {
$adresseBase->setAdresse($adr);
$adresseBase->setCp(78150);
$adresseBase->setVille("Le Chesnay");
$adresseBase->setPays("France");
$adresseBase->setClient($client);
}
}
}
$em->flush();
}
}
