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);
}