/**
* @param ObjectManager $manager
* @throws \Doctrine\DBAL\DBALException
*/
protected function loadClients(ObjectManager $manager)
{
echo "\nClients ... ";
$stmt = $this->connection->executeQuery('SELECT * FROM client');
foreach ($stmt->fetchAll() as $i => $record) {
$client = new Client();
$client->setFirstname($record['firstname']);
$client->setLastname($record['lastname']);
$client->setOrigin($record['origin']);
$client->setPhone($record['phone']);
$client->setEmailAddress($record['email_address']);
$client->setIsEmailConfirmed($record['email_confirmed']);
$client->setCreated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['created_at'])));
$client->setUpdated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['updated_at'])));
$manager->persist($client);
$i += 1;
$this->addReference("client-" . $record['id'], $client);
}
}
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);
}
