/** * Función que compruba si hay emails en las cuentas de correo que no hayan sido comprobados */ public static function checkBouncedEmailsAccounts() { $emailStatusBouncedMessagesFromAccount = Preference::getValue('emailStatusBouncedMessagesFromAccount', 5, '0'); // Comprobación para casos de errores o caídas del servidor, y no dejen bloquedo la comprobación de emails // si en 5 minutos no se ha liberado la variable, damos por hecho que se ha bloqueado y la liberamos $update = \DateTime::createFromFormat('Y-m-d H:i:s', $emailStatusBouncedMessagesFromAccount->updated_at); if ($emailStatusBouncedMessagesFromAccount->value_018 == '1' && date('U') - $update->getTimestamp() > 300) { Preference::setValue('emailStatusBouncedMessagesFromAccount', 5, '0'); } // en el caso que el estado de envio esté activo, eso siginifica que hay una petición trabajando // cuando termine de hacerlo cambiaremos el estado de de comprobación de correos // para poder aceptar más peticiones, de esa manera nos aseguramos que no hayan // varias peticiones concurrentes comprobando mails. if ($emailStatusBouncedMessagesFromAccount->value_018 === '1') { // todo, si devuelvo un json, al ejecutar el cron manualmente, no da ningún error, habría que filtrarlo // return response()->json([ // 'success' => false, // 'message' => 'at this moment, there is a process running' // ]); exit; } else { Preference::setValue('emailStatusBouncedMessagesFromAccount', 5, '1'); } // una vez comprobado que no hay mas procesos en ejecución, comenzamos a trabajar $accounts = EmailAccount::all(); $patterns = EmailPattern::all(); foreach ($accounts as $account) { $imapService = new ImapServices(['host' => $account->incoming_server_013, 'port' => $account->incoming_port_013, 'user' => $account->incoming_user_013, 'password' => Crypt::decrypt($account->incoming_pass_013), 'ssl' => $account->incoming_secure_013 == 'ssl' ? true : false]); // get total messages $nEmails = $imapService->getServer()->numMessages(); // update n emails on account EmailAccount::builder()->where('id_013', $account->id_013)->update(['n_emails_013' => $nEmails]); // Get the last UID from email account if ($nEmails > 0) { $lastUidMessage = $imapService->getServer()->getUidByPositon($nEmails); // If the UID is grater than last UID manage, has to check account queue if ($lastUidMessage > $account->last_check_uid_013) { //obtenemos la posición del siguiente mensaje sin chequear $lastUidCheck = $account->last_check_uid_013; $position = 0; $i = 0; // cuando obtengamos la posición del mensaje, será mayor que 0 y saldrá del bucle // y si hemos hecho tantas o mas comprobaciones como emails hay, salimos del bucle // sentencia para asegurarnos que no entramos en bucle infinito while ($position < 1 && $i < $nEmails) { // intentamos averiguar la posición del siguiente mensaje al último comprobado $lastUidCheck++; // si este UID no existe devolverá posición 0 $position = $imapService->getServer()->getPositonByUid($lastUidCheck); // sumamos una vuelta para no entrar en bucle infinito $i++; } // llamamos a la funcion que compruebe los correos es esa cuenta Cron::checkBouncedMessagesFromAccount($imapService, $account, $patterns, $position - 1); // solo comprobamo una cuenta //break; } } // after check bounced messages or if there are not emails, close IMAP connection $imapService->getServer()->close(); // if is the last email account, we freed the proccess if ($accounts->last()->id_013 == $account->id_013) { Preference::setValue('emailStatusBouncedMessagesFromAccount', 5, '0'); } } }
public function updateCustomRecord($parameters) { EmailPattern::where('id_049', $parameters['id'])->update(['name_049' => $this->request->input('name'), 'subject_049' => $this->request->has('subject') ? $this->request->input('subject') : null, 'operator_049' => $this->request->has('operator') ? $this->request->input('operator') : null, 'message_049' => $this->request->has('message') ? $this->request->input('message') : null, 'action_049' => $this->request->input('actionPattern')]); }
public function run() { EmailPattern::insert([['name_049' => 'Undelivered Mail Returned to Sender (email account that you tried to reach is disabled)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'email account that you tried to reach is disabled', 'action_049' => 3], ['name_049' => 'Delivery Status Notification (Delivery to the following recipients failed)', 'subject_049' => 'Delivery Status Notification (Failure)', 'operator_049' => 'and', 'message_049' => 'Delivery to the following recipients failed', 'action_049' => 3], ['name_049' => 'Undelivered Mail Returned to Sender (MAILBOX IS FULL)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'MAILBOX IS FULL', 'action_049' => 3], ['name_049' => 'Delivery Status Notification (Failure) (Unknown address error 550)', 'subject_049' => 'Delivery Status Notification (Failure)', 'operator_049' => 'and', 'message_049' => 'Unknown address error 550', 'action_049' => 3], ['name_049' => 'User unknown', 'subject_049' => null, 'operator_049' => null, 'message_049' => 'User unknown', 'action_049' => 3], ['name_049' => 'Failure notice (mailfolder is full)', 'subject_049' => 'failure notice', 'operator_049' => 'and', 'message_049' => 'mailfolder is full', 'action_049' => 3], ['name_049' => 'Failure notice (Remote host said: 451 unable to verify sender)', 'subject_049' => 'failure notice', 'operator_049' => 'and', 'message_049' => 'Remote host said: 451 unable to verify sender', 'action_049' => 3], ['name_049' => 'Warning: message (Delay reason: mailbox is full)', 'subject_049' => 'failure notice', 'operator_049' => 'and', 'message_049' => 'Delay reason: mailbox is full', 'action_049' => 3], ['name_049' => 'Mail delivery failed: returning message to sender (mailbox is full: retry timeout exceeded)', 'subject_049' => null, 'operator_049' => null, 'message_049' => 'mailbox is full: retry timeout exceeded', 'action_049' => 3], ['name_049' => 'Undelivered Mail Returned to Sender (unknown in virtual mailbox)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'unknown in virtual mailbox', 'action_049' => 3], ['name_049' => 'Undelivered Mail Returned to Sender (This is a spam mail)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'This is a spam mail', 'action_049' => 6], ['name_049' => 'Undelivered Mail Returned to Sender (Host or domain name not found)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'Host or domain name not found', 'action_049' => 3], ['name_049' => 'Undelivered Mail Returned to Sender (Quota exceeded)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'Quota exceeded', 'action_049' => 3], ['name_049' => 'Undelivered Mail Returned to Sender (mailbox unavailable)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'mailbox unavailable', 'action_049' => 3], ['name_049' => 'No se puede entregar (No se pudo encontrar la dirección de correo)', 'subject_049' => 'No se puede entregar', 'operator_049' => 'and', 'message_049' => 'No se pudo encontrar la', 'action_049' => 3], ['name_049' => 'Undelivered Mail Returned to Sender (No such user)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'No such', 'action_049' => 3], ['name_049' => 'mailfolder is over the allowed quota', 'subject_049' => null, 'operator_049' => null, 'message_049' => 'mailfolder is over the allowed quota', 'action_049' => 3], ['name_049' => '550 Address unknown', 'subject_049' => null, 'operator_049' => null, 'message_049' => '550 Address unknown', 'action_049' => 3], ['name_049' => 'Undelivered Mail Returned to Sender (permission denied)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'permission denied', 'action_049' => 3], ['name_049' => 'Undelivered Mail Returned to Sender (Host or domain name not)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'Host or domain name not', 'action_049' => 3], ['name_049' => 'Undelivered Mail Returned to Sender (Address rejected)', 'subject_049' => 'Undelivered Mail Returned to Sender', 'operator_049' => 'and', 'message_049' => 'Address rejected', 'action_049' => 3]]); }