require 'asystem.pps-eu.cz/vendor/autoload.php'; require 'CRON.2hodiny/functions.php'; $dsn = 'mysql:host=127.0.0.1;dbname=pps-eucz01'; $user = '******'; $password = '******'; $connection = new Nette\Database\Connection($dsn, $user, $password); $database = new Nette\Database\Context($connection); $results = $database->table('nemovitost')->where('mod', 1)->where('TIMESTAMPDIFF(MINUTE, datum_konec, NOW()) BETWEEN 0 AND 120'); if ($results) { // pokud mam nejake nemovitosti u kterych aukce skoncila v poslednich dvou hodinach foreach ($results as $r) { // postupne tyto nemovitosti projedu $prihozy = $database->table('drazba')->where('id_nemovitost', $r->id); $drazba = analyzuj_drazbu($prihozy, $r); if ($drazba) { $kupce = $database->table('uzivatel')->get($drazba['id']); if ($kupce->email != null) { // nastaveni parametru pro latte emailu $latte = new Nette\Latte\Engine(); $params = array('nemovitost' => $r, 'kupce' => $kupce, 'cena' => $drazba['cena']); // nastaveni mailu $mail = new Nette\Mail\Message(); $mail->setFrom('*****@*****.**')->addTo($kupce->email)->setHtmlBody($latte->renderToString('CRON.2hodiny/email.latte', $params)); // poslani mailu $mailer = new Nette\Mail\SmtpMailer(array('host' => 'smtp.seznam.cz', 'username' => '*****@*****.**', 'password' => 'pps2015', 'secure' => 'ssl')); $mailer->send($mail); } } } }