/** * @Route("/signup", name="signup") */ public function signupAction(Request $request) { if ($request->getMethod() == 'POST') { $account = $request->request->get('company'); $user = $request->request->get('user'); if ($account['name'] == '') { return $this->_result(['code' => '-1', 'mess' => 'empty_fields']); } if ($account['company'] == '') { return $this->_result(['code' => '-1', 'mess' => 'empty_fields']); } if ($account['site'] == '') { return $this->_result(['code' => '-1', 'mess' => 'empty_fields']); } if ($account['country'] == '') { return $this->_result(['code' => '-1', 'mess' => 'empty_fields']); } if ($user['name'] == '') { return $this->_result(['code' => '-1', 'mess' => 'empty_fields']); } if ($user['email'] == '') { return $this->_result(['code' => '-1', 'mess' => 'empty_fields']); } if ($user['passwd'] == '') { return $this->_result(['code' => '-1', 'mess' => 'empty_fields']); } //check user email if (!filter_var($user['email'], FILTER_VALIDATE_EMAIL)) { return $this->_result(['code' => '-1', 'mess' => 'wrong_email']); } //parse website if (strpos($account['site'], "http://") === false && strpos($account['site'], "https://") === false) { $account['site'] = 'http://' . $account['site']; } //check if company exists $companyDB = $this->getDoctrine()->getRepository('AppBundle:Company')->findOneBy(['account_name' => $account['name']]); if ($companyDB) { return $this->_result(['code' => '-1', 'mess' => 'company_exists']); } $activateCode = rand(11111111, 99999999); //add company $companyDB = new Company(); $companyDB->setAccountName($account['name'])->setCompanyName($account['company'])->setUrl($account['site'])->setCountry($account['country'])->setTimezone($account['timezone'])->setActive('N')->setBanned('N')->setRegisteredAt(time())->setUpdatedAt(time())->setActivateCode($activateCode); $em = $this->getDoctrine()->getManager(); $em->persist($companyDB); $em->flush(); $companyId = $companyDB->getId(); //add user $usersDB = new Users(); $usersDB->setCompanyId($companyId)->setEmail($user['email'])->setName($user['name'])->setPasswd(md5($user['passwd']))->setTimezone($account['timezone'])->setAdmin('Y'); $em->persist($usersDB); $em->flush(); //send mail $message = \Swift_Message::newInstance()->setSubject('inWorkFlow registration')->setFrom(['*****@*****.**' => 'inWorkFlow'])->setTo([$user['email'] => $user['name']])->setBody($this->renderView('emails/registration.html.twig', ['user' => $user, 'company' => $account, 'activateCode' => $activateCode]), 'text/html'); $this->get('mailer')->send($message); return $this->_result(['code' => '1']); } else { return $this->redirect('/', 301); } }
/** * @Given existen las siguientes compañías: */ public function createCompanies(TableNode $tableNode) { $em = $this->getEntityManager(); foreach ($tableNode->getHash() as $companyHash) { $company = new Company(); $company->setName($companyHash['nombre']); $company->setNif($companyHash['nif']); $em->persist($company); } $em->flush(); }
public function load(ObjectManager $manager) { $obj = new Company(); $obj->setName("CAPella"); $obj->setAddress("rue de l'église, 25"); $obj->setCode("4000"); $obj->setLocality("Boncelles"); $obj->setTelSecretary("04225566"); $obj->setUrlWeb("www.cap.be"); $obj->setEmail("*****@*****.**"); $obj->setDescription("Rien de spécial"); $manager->persist($obj); $manager->flush(); }
/** * @Route("/", name="homepage") */ public function indexAction(Request $request) { /** @var EntityManager $em */ $em = $this->getDoctrine()->getManager(); $user = new EnboxUser(); $user->setName('Alan'); $quotation = new Quotation(); $quote = new Quote(); $company = new Company(); $company->setName('Enbox'); $timeline = new Timeline(); $timeline->setCompany($company); $qo = new QuotationOpenActivityItem(); $qs = new QuoteSentActivityItem(); $timeline->addActivity($qo); $timeline->addActivity($qs); $qo->setActor($user); $qo->setObject($quotation); $qo->setTarget($company); $qs->setActor($company); $qs->setObject($quote); $qs->setTarget($quotation); $em->persist($user); $em->persist($quotation); $em->persist($quote); $em->persist($company); $em->persist($qo); $em->persist($qs); $em->persist($timeline); $em->flush(); //dump($company); $qb = new QueryBuilder($em); $qb->from('AppBundle:Timeline', 't')->select('t')->leftJoin('t.activities', 'ta'); $timeline = $qb->getQuery()->execute(); dump($timeline); $qb = new QueryBuilder($em); $qb->from('AppBundle:ActivityItem', 'a')->select('a'); $activities = $qb->getQuery()->execute(); dump($activities); return $this->render('default/result.html.twig', array("timeline" => $timeline[0], "activities" => $activities)); }
/** * @param Company $company * @param CompanyEntity $companyEntity * * @return CompanyEntity */ public static function toEntity(Company $company, CompanyEntity $companyEntity) { $companyEntity->setId($company->id()); $companyEntity->setName($company->getName()); $companyEntity->setMainActivity($company->mainActivity()->code()); $companyEntity->setLegalCode($company->getLegalCode()); if ($company->users()) { foreach ($company->users() as $user) { $companyEntity->addUser($user); } } return $companyEntity; }
protected function parseCompany($record) { $idno = $record[0]; $title = $record[2]; $address = $record[4]; $director = $record[5]; $company = new Company(); $company->setIdno($idno); $company->setTitle($title); $company->setAddress($address); $company->setDirector($director); $this->em->persist($company); }
/** * @Route("/parserVera/6") */ public function parserVera6Action($hot = false) { $em = $this->em; $company = $em->getRepository('AppBundle:Company')->findOneByTitle('Вера Олимп'); if ($company == null) { $company = new Company(); $company->setTitle('Вера Олимп'); $em->persist($company); $em->flush($company); $em->refresh($company); } $phpExcelObject = $this->container->get('phpexcel')->createPHPExcelObject($this->filePath); $num = 11; $city = $em->getRepository('AppBundle:City')->findOneById(2); while (true) { if ($phpExcelObject->setActiveSheetIndex(5)->getCell('A' . $num)->getValue() == '') { break; } $banner = new Banner(); $banner->setCompany($company); $banner->setAdrs(explode("\n", $phpExcelObject->setActiveSheetIndex(5)->getCell('B' . $num)->getValue())[0]); $banner->setTitle(explode("\n", $phpExcelObject->setActiveSheetIndex(5)->getCell('B' . $num)->getValue())[0]); $banner->setBody($phpExcelObject->setActiveSheetIndex(5)->getCell('B' . $num)->getValue()); $banner->setSide($phpExcelObject->setActiveSheetIndex(5)->getCell('R' . $num)->getValue()); $banner->setCity($city); $banner->setGrp(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(5)->getCell('E' . $num)->getValue())); $banner->setGid($phpExcelObject->setActiveSheetIndex(5)->getCell('F' . $num)->getValue()); $banner->setOts(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(5)->getCell('M' . $num)->getValue())); $banner->setPrice(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(5)->getCell('G' . $num)->getValue())); $banner->setPrice2(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(5)->getCell('G' . $num)->getValue() * 1.18)); $banner->setTaxType('НДС (18%)'); $banner->setPriceDeploy(str_replace(array(',', ' '), array('.', ''), $phpExcelObject->setActiveSheetIndex(5)->getCell('Q' . $num)->getValue())); $banner->setFormat('3x6'); $banner->setType($phpExcelObject->setActiveSheetIndex(5)->getCell('O' . $num)->getValue()); $banner->setArea(null); $banner->setLight($phpExcelObject->setActiveSheetIndex(5)->getCell('N' . $num)->getValue() == 'Да' || $phpExcelObject->setActiveSheetIndex(5)->getCell('N' . $num)->getValue() == 'да' ? 1 : 0); $banner->setImg(null); $banner->setLink($phpExcelObject->setActiveSheetIndex(5)->getCell('J' . $num)->getHyperlink()->getUrl()); // $pos = $this->getPosition($phpExcelObject->setActiveSheetIndex(5)->getCell('R'.$num)->getValue()); // $banner->setLongitude($pos[1]); // $banner->setLatitude($pos[0]); // if ($hot){ // $banner->setHot(true); // }else{ $banner->setHot(true); // } $banner2 = $em->getRepository('AppBundle:Banner2')->findOneByTitle($banner->getTitle()); if ($banner2) { $banner->setLatitude($banner2->getLatitude()); $banner->setLongitude($banner2->getLongitude()); } else { $banner->setLatitude(0); $banner->setLongitude(0); } $em->persist($banner); $em->flush($banner); $num++; } return true; }
public function parserGellary3Action($hot = false) { // $this->filePath = $this->filePath.'G2.XLSX'; $em = $this->em; $company = $em->getRepository('AppBundle:Company')->findOneByTitle('Gallery roller'); if ($company == null) { $company = new Company(); $company->setTitle('Gallery roller'); $em->persist($company); $em->flush($company); $em->refresh($company); } $phpExcelObject = $this->container->get('phpexcel')->createPHPExcelObject($this->filePath); $num = 2; while (true) { if ($phpExcelObject->setActiveSheetIndex(0)->getCell('B' . $num)->getValue() == '') { break; } $banner = new Banner(); $banner->setCompany($company); $banner->setAdrs($phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue()); $banner->setTitle($phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue()); $banner->setBody($phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue()); $banner->setSide($this->getSide($phpExcelObject->setActiveSheetIndex(0)->getCell('D' . $num)->getValue())); $city = $this->em->getRepository('AppBundle:City')->findOneByTitle($phpExcelObject->setActiveSheetIndex(0)->getCell('A' . $num)->getValue()); if ($city == null) { $city = new City(); $city->setTitle($phpExcelObject->setActiveSheetIndex(0)->getCell('A' . $num)->getValue()); $em->persist($city); $em->flush($city); $em->refresh($city); } $banner->setCity($city); $banner->setGid($phpExcelObject->setActiveSheetIndex(0)->getCell('N' . $num)->getValue()); $banner->setGrp(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(0)->getCell('L' . $num)->getValue())); $banner->setOts(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(0)->getCell('M' . $num)->getValue())); $banner->setPrice(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(0)->getCell('J' . $num)->getValue())); $banner->setPrice2(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(0)->getCell('I' . $num)->getValue())); $banner->setPriceDeploy(0); $banner->setTaxType('НДС (18%)'); $banner->setFormat('small'); $banner->setType($phpExcelObject->setActiveSheetIndex(0)->getCell('B' . $num)->getValue()); $banner->setArea($phpExcelObject->setActiveSheetIndex(0)->getCell('W' . $num)->getValue()); $banner->setLight($phpExcelObject->setActiveSheetIndex(0)->getCell('C' . $num)->getValue() == 'Да' || $phpExcelObject->setActiveSheetIndex(0)->getCell('C' . $num)->getValue() == 'да' ? 1 : 0); $banner->setImg($this->getImage($phpExcelObject->setActiveSheetIndex(0)->getCell('G' . $num)->getHyperlink()->getUrl())); $banner->setLink($phpExcelObject->setActiveSheetIndex(0)->getCell('G' . $num)->getHyperlink()->getUrl()); if ($hot) { $banner->setHot(true); } else { $banner->setHot(false); } $url = 'http://geocode-maps.yandex.ru/1.x/?geocode=' . urlencode($phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue()); $content = file_get_contents($url); $XmlObj = simplexml_load_string($content); if (isset($XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)) { $pos['x'] = explode(' ', $XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)[1]; $pos['y'] = explode(' ', $XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)[0]; } else { $pos['x'] = 0; $pos['y'] = 0; } $banner->setLongitude($pos['y']); $banner->setLatitude($pos['x']); $banner = $this->setBanner($banner); $month = array('2015-06-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getStyle('O' . $num)->getFill()->getStartColor()->getRGB()), '2015-07-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getStyle('P' . $num)->getFill()->getStartColor()->getRGB()), '2015-08-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getStyle('Q' . $num)->getFill()->getStartColor()->getRGB()), '2015-09-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getStyle('R' . $num)->getFill()->getStartColor()->getRGB()), '2015-10-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getStyle('S' . $num)->getFill()->getStartColor()->getRGB()), '2015-11-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getStyle('T' . $num)->getFill()->getStartColor()->getRGB()), '2015-12-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getStyle('U' . $num)->getFill()->getStartColor()->getRGB())); $this->refreshStatus($banner, $month, array('date' => '2015-06-01', 'sale' => $hot)); $num++; if ($num % 50 == 0) { sleep(rand(1, 5)); } } return true; }
/** * @Route("/parserVera/6") */ public function parserVera6Action() { $em = $this->getDoctrine()->getManager(); $company = $em->getRepository('AppBundle:Company')->findOneByTitle('Вера Олимп'); if ($company == null) { $company = new Company(); $company->setTitle('Вера Олимп'); $em->persist($company); $em->flush($company); $em->refresh($company); } $phpExcelObject = $this->get('phpexcel')->createPHPExcelObject($this->filePath); $num = 11; while (true) { if ($phpExcelObject->setActiveSheetIndex(4)->getCell('A' . $num)->getValue() == '') { break; } $banner = new Banner(); $banner->setCompany($company); $banner->setAdrs(explode("\n", $phpExcelObject->setActiveSheetIndex(4)->getCell('B' . $num)->getValue())[0]); $banner->setTitle(explode("\n", $phpExcelObject->setActiveSheetIndex(4)->getCell('B' . $num)->getValue())[0]); $banner->setBody($phpExcelObject->setActiveSheetIndex(4)->getCell('B' . $num)->getValue()); $banner->setSide($phpExcelObject->setActiveSheetIndex(4)->getCell('C' . $num)->getValue()); $banner->setCity('Московская область'); $banner->setGrp(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(4)->getCell('E' . $num)->getValue())); $banner->setGid($phpExcelObject->setActiveSheetIndex(4)->getCell('F' . $num)->getValue()); $banner->setPrice(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(4)->getCell('G' . $num)->getValue())); $banner->setPrice2(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(4)->getCell('G' . $num)->getValue()) * 1.18); $banner->setTaxType('НДС (18%)'); $banner->setOts(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(4)->getCell('M' . $num)->getValue())); $banner->setFormat('3x6'); $banner->setType($phpExcelObject->setActiveSheetIndex(4)->getCell('N' . $num)->getValue()); $banner->setArea(null); $banner->setLight($phpExcelObject->setActiveSheetIndex(4)->getCell('Q' . $num)->getValue() == 'Да' || $phpExcelObject->setActiveSheetIndex(4)->getCell('Q' . $num)->getValue() == 'да' ? 1 : 0); $banner->setImg(null); $banner->setLink($phpExcelObject->setActiveSheetIndex(0)->getCell('J' . $num)->getHyperlink()->getUrl()); $pos = $this->getPosition($phpExcelObject->setActiveSheetIndex(4)->getCell('R' . $num)->getValue()); $banner->setLongitude($pos[1]); $banner->setLatitude($pos[0]); $em->persist($banner); $em->flush($banner); $num++; } return new Response('открылось'); }
/** * @Route("/parserRus/{type}", name="parserRus") */ public function parserRusAction($type) { set_time_limit(0); ini_set("memory_limit", "-1"); // if ($type == 1){ // $filename = '3x6/'.$filename.'.json'; // }elseif($type == 2){ // $filename = 'big/'.$filename; // } if ($type == 1) { $folder = '3x6'; } elseif ($type == 2) { $folder = 'big'; } $em = $this->getDoctrine()->getManager(); $company = $em->getRepository('AppBundle:Company')->findOneByTitle('Russoutdoor'); if ($company == null) { $company = new Company(); $company->setTitle('Russoutdoor'); $em->persist($company); $em->flush($company); $em->refresh($company); } $files = scandir($this->get('kernel')->getRootDir() . '/../web/' . $folder); unset($files[1]); unset($files[0]); foreach ($files as $f) { $filename = $this->get('kernel')->getRootDir() . '/../web/' . $folder . '/' . $f; $file = file_get_contents($filename); $array = json_decode($file, true); $i = 0; foreach ($array['billboards'] as $val) { if (isset($val['longtitude']) && isset($val['latitude']) && isset($val['address'])) { $i++; $banner = new Banner(); $city = $this->getDoctrine()->getRepository('AppBundle:City')->findOneByTitle($val['cityName']); if ($city == null) { $city = new City(); $city->setTitle($val['cityName']); $em->persist($city); $em->flush($city); $em->refresh($city); } $banner->setCity($city); $banner->setCompany($company); $banner->setAdrs($val['address']); $banner->setTitle($val['address']); $banner->setGid($val['gid']); $banner->setGrp($val['grp']); $banner->setOts($val['ots']); $banner->setPrice((isset($val['price']) ? $val['price'] : 0) * 0.82); $banner->setPrice2(isset($val['price']) ? $val['price'] : 0); $banner->setLight($val['light']); $banner->setSide($val['side']); $desc = (isset($val['top']) ? $val['top'] : '') . '<br />' . (isset($val['distance']) ? $val['distance'] : ''); $banner->setBody($desc); if ($type == 1) { $banner->setFormat('3x6'); } elseif ($type == 2) { $banner->setFormat('big'); } $banner->setLongitude($val['longtitude']); $banner->setLatitude($val['latitude']); $banner->setImg(str_replace('//', 'http://', $val['imageURL'])); $em->persist($banner); $em->flush(); } else { echo $val['address'] . '<br />'; echo '<br />'; print_r($val); echo '<br />'; echo '<br />'; } } } exit; }
/** * @Route("/parserGellary/2") */ public function parserGellary2Action() { $this->filePath = $this->filePath . 'G2.XLSX'; $em = $this->getDoctrine()->getManager(); $company = $em->getRepository('AppBundle:Company')->findOneByTitle('Gallery'); if ($company == null) { $company = new Company(); $company->setTitle('Gallery'); $em->persist($company); $em->flush($company); $em->refresh($company); } $phpExcelObject = $this->get('phpexcel')->createPHPExcelObject($this->filePath); $num = 11; while (true) { if ($phpExcelObject->setActiveSheetIndex(0)->getCell('B' . $num)->getValue() == '') { break; } $banner = new Banner(); $banner->setCompany($company); $banner->setAdrs($phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue()); $banner->setTitle($phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue()); $banner->setBody($phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue()); $banner->setSide($this->getSide($phpExcelObject->setActiveSheetIndex(0)->getCell('D' . $num)->getValue())); $banner->setCity($phpExcelObject->setActiveSheetIndex(0)->getCell('A' . $num)->getValue() == 'Москва' ? 'Москва' : 'Московская область'); $banner->setGid($phpExcelObject->setActiveSheetIndex(0)->getCell('F' . $num)->getValue()); $banner->setGrp(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(0)->getCell('K' . $num)->getValue())); $banner->setOts(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(0)->getCell('L' . $num)->getValue())); $banner->setPrice(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(0)->getCell('J' . $num)->getValue())); $banner->setPrice2(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(0)->getCell('I' . $num)->getValue())); $banner->setPriceDeploy(0); $banner->setTaxType('НДС (18%)'); $banner->setFormat('small'); $banner->setType($phpExcelObject->setActiveSheetIndex(0)->getCell('B' . $num)->getValue()); $banner->setArea($phpExcelObject->setActiveSheetIndex(0)->getCell('X' . $num)->getValue()); $banner->setLight($phpExcelObject->setActiveSheetIndex(0)->getCell('C' . $num)->getValue() == 'Да' || $phpExcelObject->setActiveSheetIndex(0)->getCell('C' . $num)->getValue() == 'да' ? 1 : 0); $banner->setImg($this->getImage($phpExcelObject->setActiveSheetIndex(0)->getCell('G' . $num)->getHyperlink()->getUrl())); $banner->setLink($phpExcelObject->setActiveSheetIndex(0)->getCell('G' . $num)->getHyperlink()->getUrl()); $url = 'http://geocode-maps.yandex.ru/1.x/?geocode=' . urlencode($phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue()); $content = file_get_contents($url); $XmlObj = simplexml_load_string($content); if (isset($XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)) { $pos['x'] = explode(' ', $XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)[1]; $pos['y'] = explode(' ', $XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)[0]; } else { $pos['x'] = 0; $pos['y'] = 0; } $banner->setLongitude($pos['y']); $banner->setLatitude($pos['x']); $em->persist($banner); $em->flush($banner); $num++; if ($num % 50 == 0) { sleep(rand(1, 5)); } } return new Response('открылось'); }
/** * @Route("/parserRasvero/1") */ public function parserRasvero1Action($hot = false) { $em = $this->em; $company = $em->getRepository('AppBundle:Company')->findOneByTitle('Расверо'); if ($company == null) { $company = new Company(); $company->setTitle('Расверо'); $em->persist($company); $em->flush($company); $em->refresh($company); } $phpExcelObject = $this->container->get('phpexcel')->createPHPExcelObject($this->filePath); $num = 7; $city = $em->getRepository('AppBundle:City')->findOneById(1); while (true) { if ($phpExcelObject->setActiveSheetIndex(0)->getCell('B' . $num)->getValue() == '') { break; } $banner = new Banner(); $banner->setCompany($company); $banner->setAdrs(explode("\n", $phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue())[0]); $banner->setTitle(explode("\n", $phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue())[0]); $banner->setBody($phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue()); $banner->setSide($phpExcelObject->setActiveSheetIndex(0)->getCell('H' . $num)->getValue()); $banner->setCity($city); $banner->setGrp(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(0)->getCell('L' . $num)->getValue())); $banner->setOts(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(0)->getCell('M' . $num)->getValue())); $banner->setGid($phpExcelObject->setActiveSheetIndex(0)->getCell('K' . $num)->getValue()); $banner->setPrice(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(0)->getCell('R' . $num)->getValue() * 0.82)); $banner->setPrice2(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(0)->getCell('R' . $num)->getValue())); $banner->setTaxType('НДС (18%)'); $banner->setFormat('small'); $banner->setType($phpExcelObject->setActiveSheetIndex(0)->getCell('I' . $num)->getValue() . ' ' . $phpExcelObject->setActiveSheetIndex(0)->getCell('J' . $num)->getValue() . ' ' . ' ( ' . $phpExcelObject->setActiveSheetIndex(0)->getCell('G' . $num)->getValue() . ' ) '); $banner->setArea($phpExcelObject->setActiveSheetIndex(0)->getCell('F' . $num)->getValue()); $banner->setLight(0); $banner->setImg($this->getPhoto($phpExcelObject->setActiveSheetIndex(0)->getCell('O' . $num)->getValue())); $banner->setLink(0); $url = $phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue(); $url = 'http://geocode-maps.yandex.ru/1.x/?geocode=' . urlencode($url); $content = file_get_contents($url); $XmlObj = simplexml_load_string($content); if (isset($XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)) { $pos['x'] = explode(' ', $XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)[1]; $pos['y'] = explode(' ', $XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)[0]; } else { $pos['x'] = 0; $pos['y'] = 0; } $banner->setLongitude($pos['y']); $banner->setLatitude($pos['x']); // $banner = $this->setBanner($banner); // $month = array( // '2015-08-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getCell('S'.$num)->getValue()), // '2015-09-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getCell('T'.$num)->getValue()), // '2015-10-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getCell('U'.$num)->getValue()), // '2015-11-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getCell('V'.$num)->getValue()), // '2015-12-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getCell('W'.$num)->getValue()), //// '2015-12-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getCell('X'.$num)->getValue()), //// '2015-12-01' => $this->getStatus($phpExcelObject->setActiveSheetIndex(0)->getCell('Y'.$num)->getValue()), // ); // $this->refreshStatus($banner,$month, array('date' => '2015-06-01' , 'sale' => $hot)); // if ($hot){ // $banner->setHot(true); // }else{ $banner->setHot(false); // } // if (strripos($phpExcelObject->setActiveSheetIndex(0)->getCell('S' . $num)->getValue(),'Свободно') !== false){ // $banner->setHot(true); // } $this->em->persist($banner); $this->em->flush($banner); $num++; if ($num % 50 == 0) { sleep(rand(1, 5)); } } return true; }
/** * Creates a form to delete a Company entity. * * @param Company $company The Company entity * * @return \Symfony\Component\Form\Form The form */ private function createDeleteForm(Company $company) { return $this->createFormBuilder()->setAction($this->generateUrl('company_delete', array('id' => $company->getId())))->setMethod('DELETE')->getForm(); }
/** * @Route("/parserRasvero/1") */ public function parserVera1Action() { $em = $this->getDoctrine()->getManager(); $company = $em->getRepository('AppBundle:Company')->findOneByTitle('Расверо'); if ($company == null) { $company = new Company(); $company->setTitle('Расверо'); $em->persist($company); $em->flush($company); $em->refresh($company); } $phpExcelObject = $this->get('phpexcel')->createPHPExcelObject($this->filePath); $num = 7; $city = $this->getDoctrine()->getRepository('AppBundle:City')->findOneById(1); while (true) { if ($phpExcelObject->setActiveSheetIndex(0)->getCell('B' . $num)->getValue() == '') { break; } $banner = new Banner(); $banner->setCompany($company); $banner->setAdrs(explode("\n", $phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue())[0]); $banner->setTitle(explode("\n", $phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue())[0]); $banner->setBody($phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue()); $banner->setSide($this->getSide($phpExcelObject->setActiveSheetIndex(0)->getCell('I' . $num)->getValue())); $banner->setCity($city); $banner->setGrp(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(0)->getCell('M' . $num)->getValue())); $banner->setOts(str_replace(',', '.', $phpExcelObject->setActiveSheetIndex(0)->getCell('N' . $num)->getValue())); $banner->setGid($phpExcelObject->setActiveSheetIndex(0)->getCell('C' . $num)->getValue()); $banner->setPrice(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(0)->getCell('R' . $num)->getValue())); $banner->setPrice2(str_replace(array(',', ''), array('.', ''), $phpExcelObject->setActiveSheetIndex(0)->getCell('T' . $num)->getValue())); $banner->setTaxType('НДС (18%)'); $banner->setFormat('small'); $banner->setType($phpExcelObject->setActiveSheetIndex(0)->getCell('J' . $num)->getValue() . ' ' . $phpExcelObject->setActiveSheetIndex(0)->getCell('K' . $num)->getValue() . ' ' . ' ( ' . $phpExcelObject->setActiveSheetIndex(0)->getCell('H' . $num)->getValue() . ' ) '); $banner->setArea($phpExcelObject->setActiveSheetIndex(0)->getCell('G' . $num)->getValue()); $banner->setLight(0); $banner->setImg($this->getPhoto($phpExcelObject->setActiveSheetIndex(0)->getCell('P' . $num)->getValue())); $banner->setLink(0); if ($phpExcelObject->setActiveSheetIndex(0)->getCell('S' . $num)->getValue() == 'Свободно') { $banner->setHot(true); } // $url = substr ($phpExcelObject->setActiveSheetIndex(0)->getCell('E'.$num)->getValue(), 0, strrpos($phpExcelObject->setActiveSheetIndex(0)->getCell('E'.$num)->getValue(), '.')); $url = $phpExcelObject->setActiveSheetIndex(0)->getCell('E' . $num)->getValue(); // if ($url == ''){ // echo '<br /><br />'.$num; // break; // } $url = 'http://geocode-maps.yandex.ru/1.x/?geocode=' . urlencode($url); $content = @file_get_contents($url); $XmlObj = simplexml_load_string($content); if (isset($XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)) { $pos['x'] = explode(' ', $XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)[1]; $pos['y'] = explode(' ', $XmlObj->GeoObjectCollection->featureMember->GeoObject->Point->pos)[0]; } else { $pos['x'] = 0; $pos['y'] = 0; } $banner->setLongitude($pos['y']); $banner->setLatitude($pos['x']); $em->persist($banner); $em->flush($banner); $num++; if ($num % 30 == 0) { sleep(rand(1, 5)); } } return new Response('открылось'); }