/**
  * @param OrdersImportItem $import_item
  *
  * @return Entity\Client
  */
 private function createNewClient(OrdersImportItem $import_item)
 {
     $client = new Entity\Client();
     /**
      * Встречаются следующие варианты обозначения VIP-статуса:
      *	VIP, иван
      *	VIP, Максим VIP
      * 	VIP, Анастасия (VIP)
      */
     $p = array('(vip)', 'vip');
     $r = array('', '');
     $r_count = 0;
     $client_name = str_ireplace($p, $r, $import_item->client_name, $r_count);
     $is_vip = $r_count ? true : false;
     $is_corporate = false;
     $company_name = trim($import_item->company);
     if (!empty($company_name)) {
         $is_corporate = true;
         // Встречается и такой вариант: олеся, Корал трэвел (турфирма)
         $client_name = str_ireplace($company_name, '', $client_name);
     }
     $client_name = trim($client_name, ', ');
     $first_name = empty($client_name) ? null : $client_name;
     $phones = array_map('\\TaxiPrize\\TaxiBundle\\Entity\\Client::compressPhone', preg_split('#[,;]#', $import_item->client_phone));
     return $client->setFirstName($first_name)->setIsVip($is_vip)->setOrdersQnt(0)->setPhones($phones)->setBalance(0)->setIsCorporate($is_corporate)->setCorpName($is_corporate ? $company_name : null)->setCreatedAt(new \DateTime());
 }
 /**
  * @param Employes2ImportItem $item
  * @param AbstractItemImportResult $item_result
  *
  * @return AbstractItemImportResult
  */
 protected function _processImportItem($item, &$item_result)
 {
     $merge_phones = $merge_cars = false;
     $employe = $this->findEmployes($item);
     if (empty($employe)) {
         $employe = new Entity\Employe();
     } elseif ($this->getOption('update_existing')) {
         if (count($employe) > 1) {
             return $item_result->addMessage('More than one employe was found with the given data');
         } else {
             $employe = array_pop($employe);
             if ($employe->getExternalId() !== (int) $item->external_id) {
                 $merge_phones = $merge_cars = true;
             }
         }
     } else {
         return $item_result->addMessage('An employe with given external_id already exists');
     }
     // Обработка компаний
     $_taxis_str = trim($item->taxis);
     $taxis = array();
     if (!empty($_taxis_str)) {
         $str_taxis = array_map('trim', explode(',', $_taxis_str));
         $notfound_str_taxis = array();
         /** @var ORM\EntityRepository */
         $rep = $this->_em->getRepository('TaxiPrizeTaxiBundle:TaxiCompany');
         // TODO: Делать один запрос, перебирать массив результатов.
         foreach ($str_taxis as $str_taxi) {
             if (in_array($str_taxi, $notfound_str_taxis, true)) {
                 continue;
             }
             $taxi = $rep->findOneBy(array('name' => $str_taxi));
             if (empty($taxi)) {
                 $notfound_str_taxis[] = $str_taxi;
             } else {
                 $taxis[$taxi->getId()] = $taxi;
             }
         }
         if (!empty($notfound_str_taxis)) {
             if ($this->getOption('create_notfound_taxi_company')) {
                 $new_taxis = array();
                 foreach ($notfound_str_taxis as $str_taxi) {
                     $taxi = new Entity\TaxiCompany();
                     $taxi->setName($str_taxi);
                     // 						$this->_em->persist($taxi);
                     $taxis[] = $taxi;
                     $new_taxis[] = $taxi;
                 }
                 // 					$this->_em->flush();
             } elseif (!$this->getOption('import_with_notfound_taxi_companies')) {
                 return $item_result->addMessage('Following taxis are not found: ' . implode(', ', $notfound_str_taxis));
             }
         }
         // 			$employe->setTaxiCompanies($taxis);
     } elseif (!$this->getOption('import_without_taxi_companies')) {
         return $item_result->addMessage('Import without taxi companies is not allowed');
     }
     if (!empty($taxis)) {
         // Обработка ролей
         $_roles_str = trim($item->roles);
         if (!empty($_roles_str)) {
             $str_roles = array_map('trim', explode(',', $_roles_str));
             array_unique($str_roles);
             $notfound_str_roles = $str_name_roles = $str_title_roles = array();
             foreach ($str_roles as $str_role) {
                 if ($this->isRoleName($str_role)) {
                     $str_name_roles[] = $str_role;
                 } else {
                     $str_title_roles[] = $str_role;
                 }
             }
             // Отыскание несуществующих ролей
             $qb = $this->_em->createQueryBuilder();
             $found_by_name = $qb->select('r')->from('TaxiPrizeTaxiBundle:EmployeRole', 'r', 'r.name')->where('r.name IN (:role_names)')->setParameter('role_names', $str_name_roles)->getQuery()->execute();
             $qb = $this->_em->createQueryBuilder();
             $found_by_title = $qb->select('r')->from('TaxiPrizeTaxiBundle:EmployeRole', 'r', 'r.title')->where('r.title IN (:role_titles)')->setParameter('role_titles', $str_title_roles)->getQuery()->execute();
             $found_roles = array_merge($found_by_name, $found_by_title);
             $need_roles = $found_roles;
             $name_keys = array_keys($found_by_name);
             $title_keys = array_keys($found_by_title);
             $notfound_str_name_roles = array_diff($str_name_roles, $name_keys);
             $notfound_str_title_roles = array_diff($str_title_roles, $title_keys);
             $notfound_str_roles = array_merge($notfound_str_name_roles, $notfound_str_title_roles);
             if (!empty($notfound_str_roles)) {
                 if ($this->getOption('create_notfound_role')) {
                     $new_roles = array();
                     foreach ($notfound_str_roles as $str_role) {
                         $role = new Entity\EmployeRole();
                         $this->isRoleName($str_role) ? $role->setName($str_role) : $role->setTitle($str_role);
                         // 							$this->_em->persist($role);
                         $new_roles[] = $role;
                         $need_roles[] = $role;
                     }
                     // 						$this->_em->flush();
                 } else {
                     return $item_result->addMessage('Following roles are not found: ' . implode(', ', $notfound_str_roles));
                 }
             }
             // Добавление несуществующих связей сотрудник - роль - компания
             $new_ecrs = array();
             $rep = $this->_em->getRepository('TaxiPrizeTaxiBundle:EmployeCompanyRole');
             foreach ($taxis as $taxi) {
                 if (is_null($employe->getId())) {
                     // Сотрудник новый, без сомнений добавляем все роли во все компании.
                     foreach ($need_roles as $role) {
                         $ecr = new Entity\EmployeCompanyRole($employe, $taxi, $role);
                         $new_ecrs[] = $ecr;
                         // 							$this->_em->persist($ecr);
                     }
                 } else {
                     // Перед добавлением связки проверяем её существование
                     foreach ($found_roles as $role) {
                         if (is_null($rep->findOneBy(array('employe' => $employe, 'company' => $taxi, 'role' => $role)))) {
                             $ecr = new Entity\EmployeCompanyRole($employe, $taxi, $role);
                             $new_ecrs[] = $ecr;
                         }
                     }
                     if (isset($new_roles)) {
                         // Добавляем связки с новыми ролями
                         foreach ($new_roles as $role) {
                             $ecr = new Entity\EmployeCompanyRole($employe, $taxi, $role);
                             $new_ecrs[] = $ecr;
                         }
                     }
                 }
             }
         }
     }
     // Обработка автомобилей
     $_cars_str = trim($item->car_reg_nmbs);
     if (!empty($_cars_str)) {
         $cars = array();
         $str_cars = array_map('trim', explode(',', $_cars_str));
         $notfound_str_cars = array();
         /** @var ORM\EntityRepository */
         $rep = $this->_em->getRepository('TaxiPrizeTaxiBundle:Car');
         // TODO: Делать один запрос, перебирать массив результатов.
         foreach ($str_cars as $str_car) {
             $res = $rep->findOneBy(array('regNmb' => $str_car));
             if (empty($res)) {
                 $notfound_str_cars[] = $str_car;
             } else {
                 $cars[] = $res;
             }
         }
         if (!empty($notfound_str_cars)) {
             if ($this->getOption(self::OPTION_CREATE_NOTFOUND_CAR)) {
                 foreach ($notfound_str_cars as $str_car) {
                     $car = new Entity\Car();
                     $car->setRegNmb($str_car);
                     $this->_em->persist($car);
                     $cars[] = $car;
                 }
             }
         }
         if ($merge_cars) {
             foreach ($cars as $car) {
                 if (!$employe->getCars()->contains($car)) {
                     $employe->addCar($car);
                 }
             }
         } else {
             $employe->setCars($cars);
         }
     }
     // Остальные данные
     list($second_name, $first_name) = $this->parseName($item);
     $employe->setExternalId($item->external_id)->setSecondName($second_name)->setFirstName($first_name)->setImportName($item->name)->setCallsign($item->callsign)->setBalance(round(floatval($item->balance), 2))->setLastLocationChange($this->getRelocationDateTime($item))->setState($item->state);
     // Телефоны
     $phones = array_map('trim', preg_split('#[\\s,]+#', $item->phones));
     if ($merge_phones) {
         $phones_cmpr = $employe->getWorkPhones(true);
         foreach ($phones as $phone) {
             if (!in_array(Entity\Client::compressPhone($phone), $phones_cmpr)) {
                 $employe->addWorkPhone($phone);
             }
         }
     } else {
         $employe->setWorkPhones($phones);
     }
     // Сохранение подготовленных сущностей.
     // Первичный ключ EmployeCompanyRole состоит из внешних ключей, поэтому адресуемые сущности должны быть сохранены раньше.
     if (isset($new_taxis) && !empty($new_taxis)) {
         foreach ($new_taxis as $taxi) {
             $this->_em->persist($taxi);
         }
     }
     if (isset($new_roles) && !empty($new_roles)) {
         foreach ($new_roles as $role) {
             $this->_em->persist($role);
         }
     }
     $this->_em->beginTransaction();
     try {
         $this->_em->persist($employe);
         $this->_em->flush();
         if (isset($new_ecrs) && !empty($new_ecrs)) {
             foreach ($new_ecrs as $ecr) {
                 $this->_em->persist($ecr);
             }
         }
         $this->_em->flush();
         $this->_em->getConnection()->commit();
         return $item_result->setSuccessful();
     } catch (\Exception $e) {
         $this->_em->getConnection()->rollBack();
         throw $e;
     }
 }
Exemple #3
0
 /**
  * Set workPhone3
  *
  * @param string $workPhone3
  * @return Employe
  */
 public function setWorkPhone3($workPhone3)
 {
     $this->workPhone3 = $workPhone3;
     $this->setWorkPhone3Compressed(Client::compressPhone($workPhone3));
     return $this;
 }
 /**
  * @param CallsImportItem $import_item
  *
  * @return Entity\Client[]
  */
 private function findClients(CallsImportItem $import_item)
 {
     $phone = Entity\Client::compressPhone($import_item->caller_phone);
     /** @var ORM\EntityRepository */
     $rep = $this->_em->getRepository('TaxiPrizeTaxiBundle:Client');
     $qb = $rep->createQueryBuilder('c')->orWhere('c.phone1Compressed = :phone')->orWhere('c.phone2Compressed = :phone')->setParameter('phone', $phone);
     return $qb->getQuery()->getResult();
 }