コード例 #1
0
 /**
  * @param EmployesImportItem $item
  * @param AbstractItemImportResult $item_result
  *
  * @return AbstractItemImportResult
  *
  * @todo Когда в отчётах появится указание на принадлежность к компании,
  * не забыть про то, что компания забита в коде.
  */
 protected function _processImportItem($item, &$item_result)
 {
     $employe = $this->findEmployes($item);
     if (empty($employe)) {
         $employe = new Entity\Employe();
     } elseif ($this->getConfig('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);
         }
     } else {
         return $item_result->addMessage('An employe with given external_id already exists');
     }
     $taxi_company = $this->_em->getRepository('TaxiPrizeTaxiBundle:TaxiCompany')->findBy(array('name' => 'Taxi Prize'));
     if (empty($taxi_company)) {
         return $item_result->addMessage('Can not find taxi company');
     } elseif (count($taxi_company) > 1) {
         return $item_result->addMessage('More than one taxi company found');
     } else {
         $taxi_company = array_pop($taxi_company);
     }
     // Обработка ролей
     $_roles_str = trim($item->roles);
     if (!empty($_roles_str)) {
         $roles = array();
         $str_roles = array_map('trim', explode(' ', $_roles_str));
         $notfound_str_roles = array();
         /** @var ORM\EntityRepository */
         $rep = $this->_em->getRepository('TaxiPrizeTaxiBundle:EmployeRole');
         foreach ($str_roles as $str_role) {
             $res = $rep->findOneBy(array('name' => $str_role));
             if (empty($res)) {
                 $notfound_str_roles[] = $str_role;
             } else {
                 $roles[] = $res;
             }
         }
         if (!empty($notfound_str_roles)) {
             if ($this->getConfig('create_notfound_role')) {
                 foreach ($notfound_str_roles as $str_role) {
                     $role = new Entity\EmployeRole();
                     $role->setName($str_role);
                     $this->_em->persist($role);
                     $roles[] = $role;
                 }
             } else {
                 return $item_result->addMessage('Following roles are not found: ' . implode(', ', $notfound_str_roles));
             }
         }
         $employe->setRoles($roles);
     }
     // Остальные данные
     $employe->setExternalId($item->external_id)->setTaxiCompany($taxi_company)->setSecondName($item->second_name)->setFirstName($item->first_name)->setCallsign($item->callsign)->setWorkPhones(array_map('trim', explode(' ', $item->phones)))->setBalance(round(floatval($item->balance), 2))->setLastLocationChange($this->getRelocationDateTime($item));
     $this->_em->persist($employe);
     $this->_em->flush();
     return $item_result->setSuccessful();
 }
コード例 #2
0
 /**
  * @param AbstractItemImportResult $import_item_result
  *
  * @return $this
  */
 public function addItemImportResult(AbstractItemImportResult $import_item_result)
 {
     $this->_item_import_results[] = $import_item_result;
     if ($import_item_result->isSuccessful()) {
         $this->_import_item_successful_results[] = $import_item_result;
     } else {
         $this->_import_item_failed_results[] = $import_item_result;
     }
     return $this;
 }
コード例 #3
0
 /**
  * @param OrdersImportItem $item
  * @param AbstractItemImportResult $item_result
  *
  * @return AbstractItemImportResult
  */
 protected function _processImportItem($item, &$item_result)
 {
     $order = $this->findOrders($item);
     if (empty($order)) {
         $order = new Entity\Order();
     } else {
         return $item_result->addMessage('An order with given external_id already exists');
     }
     // Process client
     $is_client_corporate = false;
     $phones = array_map('\\TaxiPrize\\TaxiBundle\\Entity\\Client::compressPhone', explode(';', $item->client_phone));
     if (!empty($phones)) {
         $client = $this->findClients($item);
         if (empty($client)) {
             if ($this->getConfig('create_notfound_client')) {
                 $client = $this->createNewClient($item);
                 // 					$item_result->addMessage('A new client created from provided data');
             } else {
                 return $item_result->addMessage('The client is not found');
             }
         } elseif (count($client) > 1) {
             return $item_result->addMessage('More than one client found by the phone given');
         } else {
             $client = array_pop($client);
         }
         if (isset($client)) {
             $order->setClient($client->incrementOrdersQnt());
             $is_client_corporate = $client->isCorporate();
         }
     } elseif (!$this->getConfig('import_without_client')) {
         return $item_result->addMessage('The client phone info is empty');
     }
     // Process owner
     $owner_taxi_name = trim($item->owner);
     if (!empty($owner_taxi_name)) {
         $order->setOwnerTaxiCompanyStr($owner_taxi_name);
         $owner_taxi = $this->findOwnerTaxis($item);
         if (empty($owner_taxi)) {
             unset($owner_taxi);
             /*if ($this->getConfig('create_notfound_owner_taxi'))
             				{
             					$owner_taxi = new Entity\TaxiCompany();
             					$owner_taxi
             						->setName($owner_taxi_name)
             					;
             // 					$item_result->addMessage('A new taxi-owner created from provided data');
             				}
             				else*/
             // 					return $item_result->addMessage('The owner taxi company is not found');
         } elseif (count($owner_taxi) > 1) {
             return $item_result->addMessage('More than one taxi company found by the owner name given');
         } else {
             $owner_taxi = array_pop($owner_taxi);
         }
         if (isset($owner_taxi)) {
             $order->setOwnerTaxiCompany($owner_taxi);
         }
     } elseif (!$this->getConfig('import_without_owner_taxi')) {
         return $item_result->addMessage('The owner taxi company info is empty');
     }
     // Process executor
     $executor_taxi_name = trim($item->executor);
     if (!empty($executor_taxi_name)) {
         $order->setExecutorTaxiCompanyStr($executor_taxi_name);
         if (isset($owner_taxi) && $executor_taxi_name == $owner_taxi_name) {
             $executor_taxi = $owner_taxi;
         } else {
             $executor_taxi = $this->findExecutorTaxis($item);
             if (empty($executor_taxi)) {
                 unset($executor_taxi);
                 /*if ($this->getConfig('create_notfound_executor_taxi'))
                 					 {
                 						 $executor_taxi = new Entity\TaxiCompany();
                 						 $executor_taxi
                 						 	->setName($executor_taxi_name)
                 						 ;
                 // 						 $item_result->addMessage('A new taxi-executor created from provided data');
                 					 }
                 					 else*/
                 // 						return $item_result->addMessage('The executor taxi company is not found');
             } elseif (count($executor_taxi) > 1) {
                 return $item_result->addMessage('More than one taxi company found by the executor name given');
             } else {
                 $executor_taxi = array_pop($executor_taxi);
             }
         }
         if (isset($executor_taxi)) {
             $order->setExecutorTaxiCompany($executor_taxi);
         }
     } elseif (!self::isOrderStateExecutorBlankable(trim($item->order_state)) && !$this->getConfig('import_without_executor_taxi')) {
         return $item_result->addMessage('The executor taxi company info is empty');
     }
     // Обработка регистратора
     $registrant_str = trim($item->registrant);
     // Заказ сделан без участия диспетчера
     $by_automatic = (bool) preg_match('#\\.ru|\\.com|\\.net|\\.org|yandex#i', $item->order_source);
     if (!empty($item->registrant)) {
         $order->setRegistrantEmployeStr($registrant_str);
         $registrant_name = array();
         // Заполняется функцией поиска
         $registrant_employe = $this->findRegistrants($item, $registrant_name);
         if (empty($registrant_employe)) {
             unset($registrant_employe);
             /*if ($this->getConfig('create_notfound_registrant'))
             				{
             					$registrant_employe = $this->createNewRegistrantEmploye($registrant_name);
             					if (isset($owner_taxi))	// TODO: check if it's right
             						$registrant_employe->setTaxiCompany($owner_taxi);
             
             // 					$item_result->addMessage('A new registrant employe created from provided data');
             				}
             				else*/
             // 					return $item_result->addMessage('The registrant is not found');
         } elseif (count($registrant_employe) > 1) {
             return $item_result->addMessage('More than one employe found by the registrant name given');
         } else {
             $registrant_employe = array_pop($registrant_employe);
         }
         if (isset($registrant_employe)) {
             $order->setRegistrantEmploye($registrant_employe);
         }
     } elseif (!$by_automatic && !$this->getConfig('import_without_registrant')) {
         return $item_result->addMessage('The registrant info is empty');
     }
     // Process driver
     if (!empty($item->driver_phones)) {
         $driver_employe = $this->findDrivers($item);
         if (empty($driver_employe)) {
             unset($driver_employe);
             /*if ($this->getConfig('create_notfound_driver'))
             				{
             					$driver_employe = $this->createNewDriverEmploye($item);
             					if (isset($executor_taxi))
             						$driver_employe->setTaxiCompany($executor_taxi);
             
             // 					$item_result->addMessage('A new driver created from provided data');
             				}
             				else*/
             // 					return $item_result->addMessage('The driver is not found');
         } elseif (count($driver_employe) > 1) {
             return $item_result->addMessage('More than one employe found by the driver info given');
         } else {
             $driver_employe = array_pop($driver_employe);
         }
         if (isset($driver_employe)) {
             $order->setDriverEmploye($driver_employe);
         }
     } elseif (!$this->getConfig('import_without_driver')) {
         return $item_result->addMessage('The driver phones are empty');
     }
     // Process car
     // TODO: Function for car search
     $car_info = $this->parseCarInfo($item);
     if (isset($car_info['reg_nmb'])) {
         $order->setCarNmb($car_info['reg_nmb']);
         /** @var ORM\EntityRepository */
         $car_rep = $this->_em->getRepository('TaxiPrizeTaxiBundle:Car');
         /** @var Entity\Car */
         $car = $car_rep->findOneBy(array('regNmb' => $car_info['reg_nmb']));
         if (!is_null($car)) {
             $order->setCar($car);
         }
     }
     if (isset($car_info['model'])) {
         $order->setCarModel($car_info['model']);
     }
     if (isset($car_info['color'])) {
         $order->setCarColor($car_info['color']);
     }
     // Process order state
     if (is_array($state_map = self::$_order_state_map[$item->order_state])) {
         foreach ($state_map as $method => $value) {
             $order->{$method}($value);
         }
     } else {
         $order->setState($state_map);
     }
     // Other data
     $start_time = self::parseDateTime($item->started_at);
     $end_time = trim($item->ended_at);
     $end_time = empty($end_time) ? null : self::parseDateTime($end_time);
     $order->setExternalId($item->external_id)->setStartedAt($start_time)->setEndedAt($end_time)->setCommentary($item->commentary)->setPercent($item->percent)->setStartAddress($item->start_address)->setRoute($item->route)->setCost(round(floatval($item->cost), 2))->setExtraInfo($item->extra_info)->setCarInfo($item->car_info)->setDriverEmployeStr(trim($item->driver))->setClientName($item->client_name)->setClientPhone($item->client_phone)->setDiscountKeyword($item->discount_keyword)->setTariffInfo($item->base_tariff)->setIsClientCorporate($is_client_corporate)->setCreatedAt(new \DateTime());
     $this->_em->persist($order);
     $this->_em->flush();
     return $item_result->setSuccessful();
 }
コード例 #4
0
 /**
  * @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;
     }
 }
コード例 #5
0
 /**
  * @param CallsImportItem $item
  * @param AbstractItemImportResult $item_result
  *
  * @return AbstractItemImportResult
  */
 protected function _processImportItem($item, &$item_result)
 {
     /** @var Entity\Call */
     $call = $this->findCalls($item);
     if (empty($call)) {
         $call = new Entity\Call();
     } elseif ($this->getConfig('update_existing')) {
         if (count($call) > 1) {
             return $item_result->addMessage('More than one calls was found with the given data');
         } else {
             $call = array_pop($call);
         }
     } else {
         return $item_result->addMessage('A call with given external_id already exists');
     }
     // process client
     $clients = $this->findClients($item);
     if (empty($clients)) {
         if (!$this->getConfig('import_with_notfound_client')) {
             return $item_result->addMessage('The client not found');
         }
     } elseif (count($clients) > 1) {
         return $item_result->addMessage('More than one clients was found with the given data');
     } else {
         $call->setClient(array_pop($clients));
     }
     // process employe
     $employes = $this->findEmployes($item);
     if (empty($employes)) {
         if (!$this->getConfig('import_with_notfound_employe')) {
             return $item_result->addMessage('The employe not found');
         }
     } elseif (count($employes) > 1) {
         return $item_result->addMessage('More than one employes was found with the given data');
     } else {
         $call->setEmploye(array_pop($employes));
     }
     // process group (company)
     $taxis = $this->findOwnerTaxis($item);
     if (empty($taxis)) {
         if (!$this->getConfig('import_with_notfound_taxi-company')) {
             return $item_result->addMessage('The taxi company not found');
         }
     } elseif (count($taxis) > 1) {
         return $item_result->addMessage('More than one taxis was found with the given data');
     } else {
         $call->setTaxiCompany(array_pop($taxis));
     }
     // Обработка комментария. Там может быть ID заказа.
     $commentary = trim($item->commentary);
     if ((string) (int) $commentary === $commentary) {
         /** @var ORM\EntityRepository */
         $rep = $this->_em->getRepository('TaxiPrizeTaxiBundle:Order');
         /** @var Entity\Order */
         $order = $rep->findOneBy(array('externalId' => $commentary));
         // TODO: Что делать, есил заказ не найден?
         if (!is_null($order)) {
             // TODO: Что делать, если ID звонка уже выставлен?
             $order->setCall($call);
             $this->_em->persist($order);
         }
     }
     // Правка формата времени: 0:01:04 -> 00:01:04
     strlen($item->reach_time) == 7 ? $reach_time = '0' . $item->reach_time : ($reach_time = $item->reach_time);
     strlen($item->duration) == 7 ? $duration = '0' . $item->duration : ($duration = $item->duration);
     // Остальные данные
     $call->setExternalId($item->external_id)->setDate(new \DateTime($item->date))->setDirection($this->convertDirection($item->direction))->setCallerPhone(Entity\Client::compressPhone($item->caller_phone))->setCallerName(trim($item->caller_name))->setGroupName(trim($item->group_name))->setEmployeName(trim($item->employe_name))->setChannelName(trim($item->channel_name))->setReachTime(new \DateTime($reach_time))->setDuration(new \DateTime($duration))->setCause(trim($item->cause))->setCommentary(trim($item->commentary));
     $this->_em->persist($call);
     $this->_em->flush();
     return $item_result->setSuccessful();
 }