1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
<?php
if (_RIGHTS_OK !== true) die();
if (
_USERACCOUNT != 'mayoradmin' && __FELVETELIADMIN !== true
) {
$_SESSION['alert'][] = 'page:insufficient_access';
} else {
require_once('include/share/date/names.php');
require_once('include/share/print/pdf.php');
require_once('include/share/net/class.smtp.php');
require_once('include/share/net/phpmailer.php');
$ADAT['generatePDF'] = readVariable($_POST['generatePDF'],'id',null);
$ADAT['sendMAIL'] = readVariable($_POST['sendMAIL'],'strictstring',null);
$q = "SELECT * FROM iskolak";
$ADAT['iskola'] = db_query($q, array('modul'=>'felveteli','result'=>'assoc','keyfield'=>'omkod'));
$q = "SELECT distinct OM FROM adatok_"._EV." WHERE level2 != 'nem kell értesíteni' AND OM != '' ORDER BY OM ";
$ADAT['OM'] = $R = db_query($q, array('modul'=>'felveteli','result'=>'idonly'));
for ($i=0; $i<count($R); $i++) {
$ADAT['diak'] = array();
$_om = $R[$i]; // iskola OM kódja
$q = "SELECT * FROM adatok_"._EV." WHERE level2 != 'nem kell értesíteni' AND OM='%s' ORDER BY OM,nev";
$ADAT['diak'] = db_query($q, array('modul'=>'felveteli','result'=>'indexed','values'=>array($_om)));
$file = _EV.'_'.$_om;
if ($ADAT['generatePDF']==true) pdfLevel($file, $ADAT);
if (is_array($ADAT['sendMAIL']) && in_array($_om,$ADAT['sendMAIL'])) {
//echo $ADAT['iskola'][$_om]['email'];
$mail = new PHPMailer;
// $mail->isSMTP();
// $mail->Host = 'smtp.gmail.com';
// $mail->Port = 587;
// $mail->SMTPSecure = 'tls';
// $mail->SMTPAuth = true;
// $mail->Username = _FELVETELI_SMTP_USERNAME;
// $mail->Password = _FELVETELI_SMTP_PASSWORD;
$mail->setFrom(_FELVETELI_SMTP_USERNAME, 'Városmajori Gimnázium');
$mail->addReplyTo('support@vmg.sulinet.hu', 'Városmajori Gimnázium IT Support');
$mail->addAddress($ADAT['iskola'][$_om]['email'], 'Igazgató');
// $mail->addAddress('konczy@gmail.com', 'Igazgató'); //echo $ADAT['iskola'][$_om]['email'];
$mail->Subject = 'Értesítés felvételi eredményekről - 2018/2019-es beiskolázás';
$mail->msgHTML("A levelet a MaYoR elektronikus napló generálta PDF csatolmány tartalmazza.");
$mail->AltBody="A levelet a MaYoR elektronikus napló generálta PDF csatolmány tartalmazza.";
$mail->addAttachment(_DOWNLOADDIR."/private/felveteli/levelIgazgato/".$file.'.pdf');
if (!$mail->send()) {
echo "Mailer Error: " . $mail->ErrorInfo;
} else {
echo "Message sent! " . $ADAT['iskola'][$_om]['email'];
$qr = "UPDATE adatok_"._EV." SET level2='értesítve' WHERE OM='%s'";
db_query($qr, array('modul'=>'felveteli','values'=>array($_om)));
}
}
// header('Location: '.location('index.php?page=session&f=download&download=true&dir=felveteli/levelIgazgato&file='.$file.'.pdf'));
}
}
?>
|
