/**
* 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";
}
