<?php
/**
 * Project: com_music
 * File: send_emails.php
 * Created by Jesús Estévez Rodríguez <jesus@jensen.technology>
 * Date: 22/04/19
 * Time: 10:18
 */
/**
 * A command line cron job to attempt to remove files that should have been deleted at update.
 */

// We are a valid entry point.
const _JEXEC = 1;

// Load system defines
if (file_exists(dirname(__DIR__) . '/defines.php'))
{
    require_once dirname(__DIR__) . '/defines.php';
}

if (!defined('_JDEFINES'))
{
    define('JPATH_BASE', dirname(__DIR__));
    require_once JPATH_BASE . '/includes/defines.php';
}

// Get the framework.
require_once JPATH_LIBRARIES . '/import.legacy.php';

// Bootstrap the CMS libraries.
require_once JPATH_LIBRARIES . '/cms.php';

// Configure error reporting to maximum for CLI output.
error_reporting(E_ALL);
ini_set('display_errors', 1);


/**
 * A command line cron job to send the emails to the musicians.
 *
 * @since  3.0
 */
class Sendemails extends JApplicationCli
{
    /**
     * Entry point for CLI script
     *
     * @return  void
     *
     * @since   3.0
     */
    public function doExecute()
    {
        // Database connector

        $db = JFactory::getDBO();
        $this->out('Checking for logs not sent');
        $this->out('...');

        //Checking for unsent mails

        $query = $db->getQuery(true);
        $query
            ->select(array('b.email', 'a.*'))
            ->from($db->quoteName('#__music_email_logs', 'a'))
            ->join('INNER', $db->quoteName('#__users', 'b') . ' ON (' . $db->quoteName('a.email_muscian_id') . ' = ' . $db->quoteName('b.id') . ')')
            ->where($db->quoteName('a.email_sent_time') . ' = 0000-00-00 00:00:00');
        $db->setQuery($query);
        $mails = $db->loadObjectList();
        $this->out('There are ' . count($mails) . ' unsent mails.');

        // If there are some mail remaining to send, send it
        if (count($mails) !== 0)
        {
            foreach ($mails as $mail)
            {
                // Send emails
                $this->out('Preparing email to send it');
                $to   = $mail->email;
//              $from = $mail->email_from;
                $from = array("jesus@jensen.technology", "Jesus Estevez");

                # Invoke JMail Class
                $mailer = JFactory::getMailer();

                # Set sender array so that my name will show up neatly in your inbox
                $mailer->setSender($from);

                # Add a recipient -- this can be a single address (string) or an array of addresses
                $mailer->addRecipient($to);

                $mailer->setSubject($mail->email_subject);
                $mailer->setBody($mail->email_body);

                # If you would like to send as HTML, include this line; otherwise, leave it out
                $mailer->isHTML();

                # Send once you have set all of your options
                $sent = $mailer->send();

                if ($sent)
                {
                    $this->out('Sent!');
                    $this->out('Updating log with id ' . $mail->id);

                    // Update sent_time column

                    $query = $db->getQuery(true);

                    // Update the sent_time field with the actual time.
                    $fields = array(
                        $db->quoteName('email_sent_time') . ' = ' . date('m-d-Y h:i:s', time())
                    );

                    // Conditions for which records should be updated.
                    $conditions = array(
                        $db->quoteName('id') . ' = ' . $mail->id,
                    );

                    $query->update($db->quoteName('#__music_email_logs'))->set($fields)->where($conditions);

                    $db->setQuery($query);

                    $result = $db->execute();
                } else
                {
                    $this->out('Error sending email with the log id: ' . $mail->id );

                }
            }
        }
        else
        {
            $this->out('All the mails are already sent');

        }

    }


}

// Instantiate the application object, passing the class name to JCli::getInstance
// and use chaining to execute the application.
JApplicationCli::getInstance('Sendemails')->execute();