protected function execute(InputInterface $input, OutputInterface $output)
{
$container = $this->getContainer();
$em = $container->get('doctrine')->getManager();
$txt = file_get_contents('/var/www/teva/current/Teva2.csv');
$array1 = explode("\n", $txt);
foreach ($array1 as $val) {
$array2 = explode(',', $val);
// $output->writeln($array2[4]);
$user = $em->getRepository('LearningMainBundle:User')->findOneByUsername($array2[4]);
if (!$user) {
$fio = explode(' ', $array2[2]);
if (isset($fio[2]) && $fio[2] && $fio[2] != '') {
$surname = $fio[2];
} else {
$surname = '';
}
$pass = $this->generatePassword();
if (strripos($array2[0], 'МП') !== false) {
$roles = 'ROLE_MEDREP;ROLE_NOTDEFAULT;';
} elseif (strripos($array2[0], 'РМ') !== false) {
$roles = 'ROLE_MEDREP_ADMIN;ROLE_NOTDEFAULT;';
} else {
$roles = '';
}
$user = new User();
$city = $em->getRepository('LearningMainBundle:City')->find($array2[1]);
$user->setUsername($array2[4]);
$user->setCity($city);
$user->setLastName($fio[0]);
$user->setFirstName($fio[1]);
$user->setSurName($surname);
$user->setEnabled(true);
$user->setPassword($pass);
$user->setRoles($roles);
$user->setEmailConfirmed(true);
$em->persist($user);
$em->flush($user);
$em->refresh($user);
$container->get('email.service')->send($user->getUsername(), array('LearningMainBundle:Email:registration.html.twig', array('user' => $user, 'password_orig' => $user->getPassword())), 'Благодарим за регистрацию на нашем портале!');
$txt = "INSERT `user` SET username='******'4']}', city_id={$array2['1']} , lastName = '{$fio['0']}', firstName='{$fio['1']}', surName='{$surname}', password='******', roles='{$roles}';";
$output->writeln($txt);
}
}
}