public function sendOpticRegisteredEmailMessage(Optic $optic)
{
//envio el email con la clave
$message = \Swift_Message::newInstance()->setSubject('Bienvenido a core')->setFrom(array('*****@*****.**' => 'Core avisos'))->setTo($optic->getEmail())->setBody($this->templating->render('FrontBundle:Registration:register.email.optic.html.twig', array('nombre' => $optic->getName(), 'email' => $optic->getEmail(), 'hss_validacion' => md5($optic->getEmail() . 'corekey' . $optic->getId()))), 'text/html');
//Presencia en la plataforma
if ($optic->getPack()->getId() == 2) {
$html = $this->templating->render('FrontBundle:Registration/Contract:plataforma.html.twig', array('optic' => $optic));
$html2pdf = $this->html2pdf_factory->create();
$html2pdf->WriteHTML($html);
$filename = 'contrato_presencia-plataforma_' . $optic->getId() . '-' . $optic->getPack()->getId() . '.pdf';
$fileDir = $this->kernel->getRootDir() . '/../web/uploads/documents/' . $filename;
$html2pdf->Output($fileDir, 'F');
$message->attach(\Swift_Attachment::fromPath($fileDir));
}
//Pack Internet Plus
if ($optic->getPack()->getId() == 3) {
$html = $this->templating->render('FrontBundle:Registration/Contract:plus.html.twig', array('optic' => $optic));
$html2pdf = $this->html2pdf_factory->create();
$html2pdf->WriteHTML($html);
$filename = 'contrato_internet-plus_' . $optic->getId() . '-' . $optic->getPack()->getId() . '.pdf';
$fileDir = $this->kernel->getRootDir() . '/../web/uploads/documents/' . $filename;
$html2pdf->Output($fileDir, 'F');
$message->attach(\Swift_Attachment::fromPath($fileDir));
}
//Pack Internet Total
if ($optic->getPack()->getId() == 4) {
$html = $this->templating->render('FrontBundle:Registration/Contract:total.html.twig', array('optic' => $optic));
$html2pdf = $this->html2pdf_factory->create();
$html2pdf->WriteHTML($html);
$filename = 'contrato_internet-total_' . $optic->getId() . '-' . $optic->getPack()->getId() . '.pdf';
$fileDir = $this->kernel->getRootDir() . '/../web/uploads/documents/' . $filename;
$html2pdf->Output($fileDir, 'F');
$message->attach(\Swift_Attachment::fromPath($fileDir));
}
$this->mailer->send($message);
}
public function importOptics(Import $entity, $output)
{
$factory = $this->container->get('security.encoder_factory');
$encoder = $factory->getEncoder(new Optic());
$em = $this->container->get('doctrine')->getManager();
$role = $em->getRepository('CoreBundle:Role')->findOneByRole('ROLE_OPTIC');
$sql = ' SELECT o.id, o.id_usuario, o.id_pack, o.id_codigo_postal, o.nombre, o.asociacion, o.codigo, o.cuenta, o.recibir_paquete, ' . ' o.direccion, o.provincia, o.cp, o.lat, o.lang, o.descripcion, o.url_img, slug, o.acu_visitas, o.acu_ventas, o.extension_img, ' . ' o.autor, o.autor_descripcion, o.acu_productos, o.acu_servicios, o.url_facebook, o.url_twitter, o.tiene_web, o.newsletter, ' . ' o.recibir_informacion, o.meta_titulo, o.meta_descripcion, o.meta_keywords, o.bank_account_token, o.bank_account_time, ' . ' o.responsable, o.razon, o.cif, u.email, u.password, u.username, u.salt, u.estado, u.fecha_alta ' . ' FROM `optica` AS o ' . ' LEFT JOIN usuario AS u ON o.id_usuario = u.id ' . ' ORDER BY o.id ' . ' LIMIT ' . $entity->getLimitStart() . ', ' . $entity->getLimitEnd();
$title = null;
$link = mysqli_connect($entity->getServer(), $entity->getUsername(), $entity->getPassword(), $entity->getDbname()) or die('No se pudo conectar: ' . mysqli_error($link));
$resultado = $link->query($sql);
if (mysqli_num_rows($resultado) > 0) {
$x = 0;
$count = 0;
$count2 = 0;
while ($fila = mysqli_fetch_assoc($resultado)) {
$x++;
print_r($x . '-' . utf8_encode($fila['nombre']));
echo PHP_EOL;
$user = new Optic();
if ($fila['id_usuario'] == 1) {
$count++;
$username = $this->slugify(utf8_encode($fila['nombre']));
$user->setUsername($username);
$user->setEmail($username . $fila['id'] . '@optisoop.com');
} else {
$count2++;
$user->setUsername(utf8_encode($fila['username']));
$user->setEmail(utf8_encode($fila['email']));
}
$user->setName(utf8_encode($fila['nombre']));
$user->setCreated(new DateTime($fila['fecha_alta']));
$user->addRole($role);
$user->setPassword($fila['password']);
$user->setSalt($fila['salt']);
$user->setDescription(utf8_encode($fila['descripcion']));
$user->setSlug($this->slugify(utf8_encode($fila['nombre'])));
$user->setLatitude($fila['lat']);
$user->setLongitude($fila['lang']);
$user->setAssociation(utf8_encode($fila['asociacion']));
$user->setBankAccountNumber($fila['cuenta']);
$user->setAddress(utf8_encode($fila['direccion']));
$user->setPostalCode($fila['cp']);
$user->setCity(utf8_encode($fila['provincia']));
$user->setFacebookUrl($fila['url_facebook']);
$user->setTwitterUrl($fila['url_twitter']);
if (utf8_encode($fila['meta_titulo']) != '') {
$user->setMetaTitle($fila['meta_titulo']);
} else {
$user->setMetaTitle($fila['nombre']);
}
if (utf8_encode($fila['meta_descripcion']) != '') {
$user->setMetaDescription($fila['meta_descripcion']);
} else {
$user->setMetaDescription($fila['descripcion']);
}
if (utf8_encode($fila['meta_keywords']) != '') {
$user->setMetaTags($fila['meta_keywords']);
} else {
$user->setMetaTags($fila['nombre']);
}
//pack
$pack = $em->getRepository('CoreBundle:Pack')->find($fila['id_pack']);
$user->setPack($pack);
//state and country
$this->setStateAndCountry($fila, $user);
$em->persist($user);
$em->flush();
// print_r($fila);
//image
if ($fila['url_img'] != '') {
$dir = '/home/sebastian/www/optisoop/src/Symfony/web/optisoop/uploads/documents';
$imagePath = '';
$absoluteImagePath = $dir . '/' . utf8_encode($fila['url_img']);
if (file_exists($absoluteImagePath . '.jpeg')) {
$imagePath = utf8_encode($fila['url_img']) . '.jpeg';
}
if (file_exists($absoluteImagePath . '.jpg')) {
$imagePath = utf8_encode($fila['url_img']) . '.jpg';
}
if (file_exists($absoluteImagePath . '.gif')) {
$imagePath = utf8_encode($fila['url_img']) . '.gif';
}
if (file_exists($absoluteImagePath . '.png')) {
$imagePath = utf8_encode($fila['url_img']) . '.png';
}
//Thumb
$imagePathThumb = '';
$absoluteImagePathThumb = $dir . '/' . utf8_encode($fila['url_img']) . '_260.jpg';
if (file_exists($absoluteImagePathThumb)) {
$imagePathThumb = utf8_encode($fila['url_img']) . '_260.jpg';
}
$imagePathThumb2 = '';
$absoluteImagePathThumb2 = $dir . '/' . utf8_encode($fila['url_img']) . '_142.jpg';
if (file_exists($absoluteImagePathThumb2)) {
$imagePathThumb2 = utf8_encode($fila['url_img']) . '_142.jpg';
}
print_r($dir . '/' . $imagePath);
echo PHP_EOL;
@mkdir(__DIR__ . '/../../../../../web/uploads/images/profile');
@mkdir(__DIR__ . '/../../../../../web/uploads/images/profile/' . $user->getId());
@mkdir(__DIR__ . '/../../../../../web/uploads/images/profile/' . $user->getId() . '/thumbnail');
copy($dir . '/' . $imagePath, __DIR__ . '/../../../../../web/uploads/images/profile/' . $user->getId() . '/' . $imagePath);
if ($imagePathThumb != '') {
copy($dir . '/' . $imagePathThumb, __DIR__ . '/../../../../../web/uploads/images/profile/' . $user->getId() . '/thumbnail/' . $imagePathThumb);
}
if ($imagePathThumb2 != '') {
copy($dir . '/' . $imagePathThumb2, __DIR__ . '/../../../../../web/uploads/images/profile/' . $user->getId() . '/thumbnail/' . $imagePathThumb2);
}
$image0 = new Image();
$image0->setPath($imagePath);
$user->setImage($image0);
$em->persist($image0);
}
$em->flush();
}
$output->writeln('Opticas sin usuarios = ' . $count . ' ');
$output->writeln('Opticas con usuarios = ' . $count2 . ' ');
} else {
$output->writeln('No se ha procesado ningun usuario');
}
}