/** * Returns the number of days to next time window for the corresponding user if at least one parameter is defined. Undefined parameters must be set to null. * @param int $id * @param string $username * @param string $email * @param int $cardId * @param string $timeWindowName * @return int containing the days to the next time window, or FALSE if the user cannot be found. */ function db_getDaysToNextTimeWindow($id = -1, $username = "******", $email = "-1", $cardId = -1, $timeWindowName = "-1") { // get company's start day $ret = db_getCompanyDataRaw($id, $username, $email, $cardId); if (empty($ret)) { return FALSE; } $startDay = $ret['kezdo_nap']; // days between company's start day and now $now = time(); $startDay = strtotime($startDay); $dateDiff = $now - $startDay; $days = floor($dateDiff / (60 * 60 * 24)); // get value of the next time window global $conn; $stmt = $conn->prepare("SELECT ertek\n FROM idoablakok\n WHERE nev = :tname"); $stmt->bindParam(':tname', $timeWindowName); $stmt->execute(); $timeWindowValue = $stmt->fetchColumn(); return $timeWindowValue - $days; }
/** * Returns the user's time window name if at least one parameter is defined. Undefined parameters must be set to null. * @param int $id * @param string $username * @param string $email * @param int $cardId * @return string containing the user's time window name, or FALSE if the user cannot be found. */ function db_getUserTimeWindow($id = -1, $username = "******", $email = "-1", $cardId = -1) { // get company's start day $ret = db_getCompanyDataRaw($id, $username, $email, $cardId); if (empty($ret)) { return FALSE; } $startDay = $ret['kezdo_nap']; // days between company's start day and now $now = time(); $startDay = strtotime($startDay); $dateDiff = $now - $startDay; $days = floor($dateDiff / (60 * 60 * 24)); $days_offset = $days + 10; // get and return with time window name global $conn; $stmt = $conn->prepare("SELECT nev FROM idoablakok\n WHERE ertek BETWEEN :days AND :days_offset\n ORDER BY ertek ASC\n LIMIT 1;"); /* azért kell ez, mert a 10. napon pl. mindkét * időablakot kidobja, az 1.-t meg a 2.-at is, * és így biztosan csak az időben előbb lévőt * fogja (aztán a 11. napon vált) */ $stmt->bindParam(':days', $days); $stmt->bindParam(':days_offset', $days_offset); $stmt->execute(); return $stmt->fetchColumn(); }
<?php include '../includes/config.php'; $userId = 0; $timeWindow = $msg = ""; if ($_SERVER["REQUEST_METHOD"] == "POST") { $userId = test_input($_POST["userId"]); $timeWindow = test_input($_POST["timeWindow"]); $msg = test_input($_POST["msg"]); $user = db_getUserDataRaw($userId, null, null, null); $company = db_getCompanyDataRaw($userId, null, null, null); if (empty($user['telefon'])) { $user['telefon'] = "n. a."; } /* ************* HTML E-MAIL KÜLDÉSE ************* */ $to = "*****@*****.**"; $subject = "HRP - Új segítségkérő üzenet"; $message = "\n <html>\n <head>\n <title>HRP - Új segítségkérő üzenet</title>\n </head>\n <body>\n <h1 align=\"center\" style=\"background:lightcoral;border-radius:16px;\">Új segítségkérő üzenet</h1>\n <div style=\"width: 80%;margin: auto;\">\n <fieldset><legend align=\"center\">Adatok</legend>\n <table width=\"80%\" align=\"center\">\n <tr><td width=\"40%\" style=\"padding:.5em 0;border-right:1px dashed black;\">Név</td><td width=\"60%\" style=\"padding:.5em 0;\" align=\"right\">" . $user['vez_nev'] . " " . $user['ker_nev'] . "</td></tr>\n <tr><td width=\"40%\" style=\"padding:.5em 0;border-top:1px dashed black;border-right:1px dashed black;\">Telefon</td><td width=\"60%\" style=\"padding:.5em 0;border-top:1px dashed black;\" align=\"right\">" . $user['telefon'] . "</td></tr>\n <tr><td width=\"40%\" style=\"padding:.5em 0;border-top:1px dashed black;border-right:1px dashed black;\">E-mail</td><td width=\"60%\" style=\"padding:.5em 0;border-top:1px dashed black;\" align=\"right\">" . $user['email'] . "</td></tr>\n <tr><td width=\"40%\" style=\"padding:.5em 0;border-top:1px dashed black;border-right:1px dashed black;\">Cégnév</td><td width=\"60%\" style=\"padding:.5em 0;border-top:1px dashed black;\" align=\"right\">" . $company['vallalat_nev'] . "</td></tr>\n <tr><td width=\"40%\" style=\"padding:.5em 0;border-top:1px dashed black;border-right:1px dashed black;\">Kártyaszám</td><td width=\"60%\" style=\"padding:.5em 0;border-top:1px dashed black;\" align=\"right\">IP" . $user['kartyaId'] . "</td></tr>\n <tr><td width=\"40%\" style=\"padding:.5em 0;border-top:1px dashed black;border-right:1px dashed black;\">Időablak neve</td><td width=\"60%\" style=\"padding:.5em 0;border-top:1px dashed black;\" align=\"right\">" . $timeWindow . "</td></tr>\n </table>\n </fieldset>\n <div style=\"padding:10px 0;\"></div>\n <fieldset><legend align=\"center\">Üzenet szövege</legend><pre>" . $msg . "</pre>\n </fieldset>\n </div>\n <p style=\"text-align:center;\"><img src=\"http://hrp-interaktiv.hu/kepek/logo_min.jpg\" alt=\"HRP logo mini\"></p>\n <h1 align=\"center\" style=\"background:lightcoral;color:lightcoral;border-radius:16px;\">hrp</h1>\n </body>\n </html>"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; //$headers .= 'From: <*****@*****.**>' . "\r\n"; //$headers .= 'Cc: myboss@example.com' . "\r\n"; mail($to, $subject, $message, $headers); /* *********************************************** */ echo "help_mail_sent"; }