public function find(Message $message) { $fp = fopen('./data/ml/mail/test2.txt', 'w+'); fwrite($fp, $message->getSubject()); fwrite($fp, "\n"); fwrite($fp, strip_tags($message->getBody())); fclose($fp); $output = trim(shell_exec("python ./python/src/prod_mail2_predict.py")); if ($output) { $profileRepo = $this->_lockedEm->getRepository('Common\\Entity\\Profile'); $profile = $profileRepo->findOneBy(array('id' => $output)); $msgProfile = new Message\Profile(); $msgProfile->setMessage($message)->setOwner(true)->setProfile($profile); $message->getMessageProfiles()->add($msgProfile); $state = new Message\State(); $state->setMessage($message)->setState(Message\State::STATE_OWNED); $message->getStates()->add($state); } }
public function import() { $conn = new \Zend\Mail\Storage\Imap($this->getConfig()['support']['customer_mails']); $em = $this->getServiceLocator()->get('Doctrine\\ORM\\EntityManager'); $em->getConnection()->beginTransaction(); $messageRepo = $em->getRepository('\\Common\\Entity\\Message'); for ($i = $conn->countMessages(); $i; --$i) { try { $email = $conn->getMessage($i); // check for doubles $messageId = isset($email->message_id) ? $email->message_id : $conn->getUniqueId($i); $messageId = trim($messageId, " \t\r\n<>"); $messageId = preg_replace('/[^a-zA-Z0-9-_@]\\./', '_', $messageId); /*if ($messageId == '*****@*****.**') { $this->message = new Message(); $this->message->setCode($messageId) ->setImportType(Message::IMPORT_TYPE_EMAIL) ->setSubject($email->subject) ->setSendedOn(new \DateTime(date('Y-m-d H:i:s', isset($email->date) ? strtotime($email->date) : time()))); $body = $this->getBody($email); $this->message->setBody($body); $em->persist($this->message); $this->setEmails($this->parseEmails($email->from), Address::TYPE_FROM); $this->setEmails($this->parseEmails($email->to), Address::TYPE_TO); $em->persist($this->message); $em->flush(); $em->getConnection()->commit(); die; } continue;*/ $date = new \DateTime(date('Y-m-d H:i:s', isset($email->date) ? strtotime($email->date) : time())); if ($messageRepo->findBy(array('code' => $messageId))) { continue; } $from = $this->parseEmails($email->from); if ($from[0]->host == 'archonia.com') { continue; } // create the message $this->message = new Message(); // set the email addresses $this->setEmails($this->parseEmails($email->from), Address::TYPE_FROM); $this->setEmails($this->parseEmails($email->to), Address::TYPE_TO); if (isset($email->cc) && !empty($email->cc)) { $this->setEmails($this->parseEmails($email->cc), Address::TYPE_CC); } if (isset($email->bcc) && !empty($email->bcc)) { $this->setEmails($this->parseEmails($email->bcc), Address::TYPE_BCC); } // set message data $this->message->setCode($messageId)->setImportType(Message::IMPORT_TYPE_EMAIL)->setSubject($email->subject)->setSendedOn($date); $body = $this->getBody($email); $this->message->setBody($body); $em->persist($this->message); $em->flush(); parent::rules($em); // parent message if (isset($email->References)) { $messageParent = $messageRepo->findOneBy(array('code' => $email->References)); if ($messageParent) { $this->message->setParent($messageParent); $msgProfile = $messageParent->getMessageProfiles()->filter(function ($entry) { if ($entry->getOwner()) { return true; } else { return false; } }); if ($msgProfile->count() === 1) { $messageProfile = new Message\Profile(); $messageProfile->setProfile($msgProfile->first()->getProfile())->setOwner(true)->setMessage($this->message); $this->message->getMessageProfiles()->add($messageProfile); $state = new Message\State(); $state->setMessage($this->message)->setState(Message\State::STATE_OWNED); $this->message->getStates()->add($state); $em->persist($this->message); $em->flush(); } } } $em->getConnection()->commit(); } catch (\Exception $e) { \Common\Service\Logger::getInstance()->err('mail import error' . $this->message->getId(), array('error' => $e->getMessage(), 'file' => $e->getFile(), 'line' => $e->getLine())); $em->getConnection()->rollback(); // make sure our em is still open. Due to hacky emails, inserts can go wrong and make to em closed. if (!$em->isOpen()) { $em = $em->create($em->getConnection(), $em->getConfiguration()); } } $em->getConnection()->beginTransaction(); } }