public function doUnKnowUpdate(WordsEntity $word) { // invalid setting if ($word->getStatus() != $this->marker->getStatus()) { throw new EngRuntimeException("status doesn't match!"); } $newFailureCount = $word->getFailure() + 1; if ($newFailureCount >= $this->marker->getFailure()) { $newStatus = $this->getNextStatusWhenFail($word->getStatus()); if ($newStatus != $word->getStatus()) { $word->setStatus($newStatus); $word->setSuccess(0); $word->setFailure(0); } else { $word->setFailure($newFailureCount); } } else { $word->setFailure($newFailureCount); } }
private function downloadWordsVoice($name, $force) { $params = array(); if ($force) { $sql = "SELECT * FROM words WHERE 1 = 1"; } else { $sql = "SELECT * FROM words WHERE (voice IS NULL or voice = '')"; } if ($name != null) { $sql .= ' AND name = :name'; $params['name'] = $name; } $sql .= " AND voice not like '%/%'"; $handle = $this->db->executeQuery($sql, $params); while ($row = $handle->fetch()) { $entity = new WordsEntity(); $entity->fromArray($row); try { $this->updateWord($entity, $force); } catch (\Exception $e) { $this->output->writeln(sprintf("word [%s] update failed, error info: %s", $entity->getName(), $e->getMessage())); } } }
public function addNewAction() { $json = array('status' => 0, 'errorWords' => ''); $key = trim($this->request->request->get('key')); $words = preg_split("|[\r\n ]+|i", $key); if (empty($words)) { return new JsonResponse($json); } $errorWords = array(); $successWords = array(); $updateWords = array(); foreach ($words as $word) { $entity = $this->em->getRepository('Eng:WordsEntity')->findOneBy(array('name' => $word)); if ($entity === null) { $entity = new WordsEntity(); $entity->setCreateTime(new \Datetime('now')); $entity->setName($word); } try { $mean = $this->container['wordMeanDownloader']->download($entity->getName()); $entity->setMeans(implode("\n", $mean->getMeaning())); $entity->setPronunciation($mean->getPhonetic()); $voiceName = $this->container['wordVoiceDownloader']->download($entity->getName()); $entity->setVoice($voiceName); $entity->setStatus(WordsEntity::NEWONE); } catch (\Exception $e) { $this->log->addWarning(sprintf("Can not find this word:%s, info:%s", $entity->getName(), $e->getMessage())); $errorWords[] = $entity->getName(); continue; } if ($entity->getId() !== null) { $updateWords[] = $entity->getName(); } else { $successWords[] = $entity->getName(); } $this->em->persist($entity); $this->em->flush(); } $message = array(); if (!empty($successWords)) { $message[] = 'new words: ' . count($successWords); } if (!empty($updateWords)) { $message[] = 'update words: ' . count($updateWords); } if (!empty($errorWords)) { if (empty($successWords) && empty($updateWords)) { $json['status'] = 1; } $message[] = 'error words: ' . count($errorWords); $json['errorWords'] = implode("\n", $errorWords); } $json['message'] = implode(', ', $message); return new JsonResponse($json); }