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(); } }
continue; } $subject = decodeSubject($mail->subject); $subject = str_replace('Fwd: ', '', $subject); $pid = false; /* try to get target folder from subject*/ $path = false; //case_nr /* try to find user from database that corresponds to this mail. Ex: Kell <*****@*****.**> */ $email = false; if (preg_match_all('/^[^<]*<?([^>]+)>?/i', $mail->from, $results)) { $email = $results[1][0]; } if ($email == false) { $delete_ids[] = $mailbox->getUniqueId($k); echo "\rcannot find senders email for: {$subject} ... skipping"; mail($mail->from, 'Error processing your email: ' . $subject, '. We didn\'t find ' . 'your email in received message. ' . $mail_requirements, 'From: ' . $core['mail_user'] . "\n\r"); continue; } $user_id = DM\User::getIdByEmail($email); if (!empty($user_id)) { if (empty($test_user_id)) { $delete_ids[] = $mailbox->getUniqueId($k); mail($mail->from, 'Error processing your email: ' . $subject, '. We didn\'t find your' . ' email address in our users database, please update your email ' . 'address in your user profile of casebox and resend your mail. ' . 'Wrong messages are deleted automatically.' . $mail_requirements, 'From: ' . $core['mail_user'] . "\n\r"); echo "\rcannot find corresponding user in our database '.\n 'for email {$email} from message: {$subject} ... skipping"; continue; } else { $user_id = $test_user_id; } }