75 lines
2.2 KiB
PHP
75 lines
2.2 KiB
PHP
<?php
|
|
#require_once("config.inc.php");
|
|
include('admin/phpqrcode/qrlib.php');
|
|
function generate_qr_by_name($nachname, $vorname){
|
|
$vorname1 =mb_strtoupper($vorname);
|
|
$nachname1 =mb_strtoupper($nachname);
|
|
|
|
$db = dbconnect();
|
|
$query_qr = $db->query("SELECT qr
|
|
FROM gd_qr_fellbach
|
|
WHERE upper(vorname)='$vorname1'
|
|
AND upper(nachname)='$nachname1'
|
|
");
|
|
$row_qr= $query_qr->fetch_array();
|
|
|
|
if($row_qr['qr'] != ''){
|
|
$PNG_TEMP_DIR = dirname(__FILE__).DIRECTORY_SEPARATOR.'admin'.DIRECTORY_SEPARATOR.'phpqrcode'.DIRECTORY_SEPARATOR.'temp'.DIRECTORY_SEPARATOR;
|
|
$PNG_WEB_DIR = 'phpqrcode/temp/';
|
|
|
|
$filename = $PNG_TEMP_DIR.$row_qr['qr'].'.png';
|
|
QRcode::png($row_qr['qr'], $filename, H, 10, 2);
|
|
return $row_qr['qr'];
|
|
}else{
|
|
|
|
$empfaenger = "service@nak-btb.de";
|
|
$betreff = "Fehlender QR Code";
|
|
$text = "
|
|
<html>
|
|
<head>
|
|
<title>Fehlender QR Code</title>
|
|
</head>
|
|
<body>
|
|
<font face='Arial' size='2'>
|
|
Guten Tag!<br><br>
|
|
Für nachfolgende Person fehlt ein QR Code für die Gemeinde Fellbach
|
|
<br>
|
|
<br>
|
|
<table>
|
|
<tr>
|
|
<td valign='top' width='100'>
|
|
<b>Name:</b>
|
|
</td>
|
|
<td valign='top' colspan='2'>
|
|
$nachname, $vorname
|
|
</font>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<br>
|
|
<br>
|
|
Link zur Gottesdienstadministration: <a href=\"http://gd.nak-btb.de/admin\">Gottesdienstadministration</a>
|
|
<p>
|
|
Diese Mail wurde automatisch generiert!<br>
|
|
Antworten Sie daher nicht auf diese Mail<br>
|
|
<br>
|
|
Vielen Dank
|
|
</body>
|
|
</html>";
|
|
|
|
|
|
$text = stripslashes($text);
|
|
$headers = "MIME-Version: 1.0\n";
|
|
#$headers .= "Content-type: text/html; charset=iso-8859-1\n";
|
|
$headers .= "Content-type: text/html; charset=utf-8\n";
|
|
$headers .= "From: Gottesdienstregistrierung <service@nak-btb.de>\n";
|
|
#$headers .= "Bcc: \n";
|
|
|
|
$mail_return = @mail($empfaenger, $betreff, $text, $headers);
|
|
return 'NA';
|
|
}
|
|
|
|
}
|
|
#echo generate_qr_by_name('Bantleon', 'Lea');
|
|
?>
|