diff options
Diffstat (limited to 'mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli')
4 files changed, 169 insertions, 0 deletions
diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/level-mzsg-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/level-mzsg-pre.php new file mode 100644 index 00000000..ccccf906 --- /dev/null +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/level-mzsg-pre.php @@ -0,0 +1,71 @@ +<?php + + if (_RIGHTS_OK !== true) die(); + + require_once('include/share/date/names.php'); + require_once('include/share/print/pdf.php'); + + if (__PORTAL_CODE!=='kanizsay' || __PORTAL_CODE!=='mzsg') { + $_SESSION['alert'][] = 'page:insufficient_access'; + } + + $token = readVariable($_GET['token'],'strictstring'); + if ( + (_USERACCOUNT === 'mayoradmin' || __FELVETELIADMIN === true) && $token=='' + ) { + $q = "SELECT * FROM felveteli_eredmeny ORDER BY evfolyam,nev"; + $r = db_query($q, array('modul'=>'naplo','result'=>'indexed')); + $ADAT['level'] = $r; + for ($i = 0; $i < count($ADAT['level']); $i++) { + $D = $ADAT['level'][$i]; + if (chop($D['mashova']) == "") $ADAT['level'][$i]['mashova'] = array(); else $ADAT['level'][$i]['mashova'] = explode(',',$D['mashova']); + if (chop($D['helyhiany']) == "") $ADAT['level'][$i]['helyhiany'] = array(); else $ADAT['level'][$i]['helyhiany'] = explode(',',$D['helyhiany']); + if (chop($D['elutasitott']) == "") $ADAT['level'][$i]['elutasitott'] = array(); else $ADAT['level'][$i]['elutasitott'] = explode(',',$D['elutasitott']); + } + $file = __INTEZMENY.'_'.date('Y').'_teljes'; + if (pdfLevel($file, $ADAT)) { + header('Location: '.location('index.php?page=session&f=download&download=true&dir=naplo/felveteli/level&file='.$file.'.pdf')); + } else { + $_SESSION['alert'][] = 'info::Hiba a file-generáláskor!'; + } + + } else { + + if (strlen($token)==40) { + + $q = "SELECT oId FROM felveteli_levelLog WHERE token='%s' AND generalasDt>= NOW() - interval 10 MINUTE"; + $v = array($token); + $oId = db_query($q, array('modul'=>'naplo','result'=>'value','values'=>$v,'debug'=>false)); + + if ($oId=='') { + $_SESSION['alert'][] = 'info::Ez a token már nem érvényes!'; + } else { + //$q = "SELECT * FROM adatok_"._EV." ORDER BY evfolyam,nev"; + $q = "SELECT * FROM felveteli_eredmeny WHERE oId='%s'"; + $v = array($oId); + $r = db_query($q, array('modul'=>'naplo','result'=>'indexed','values'=>$v)); + $ADAT['level'] = $r; + $D = $ADAT['level'][0]; + if (chop($D['mashova']) == "") $ADAT['level'][0]['mashova'] = array(); else $ADAT['level'][0]['mashova'] = explode(',',$D['mashova']); + if (chop($D['helyhiany']) == "") $ADAT['level'][0]['helyhiany'] = array(); else $ADAT['level'][0]['helyhiany'] = explode(',',$D['helyhiany']); + if (chop($D['elutasitott']) == "") $ADAT['level'][0]['elutasitott'] = array(); else $ADAT['level'][0]['elutasitott'] = explode(',',$D['elutasitott']); +# $ADAT['iktsz'] = 'C8-62/2021'; + $file = __INTEZMENY.'_'.date('Y').'_'.$oktid.$token; + if (pdfLevel($file, $ADAT)) { + $q = "UPDATE felveteli_levelLog SET letoltesDt=NOW() WHERE token='%s'"; + $v = array($token); + db_query($q, array('modul'=>'naplo','values'=>$v,'debug'=>false)); + header('Location: '.location('index.php?page=session&f=download&download=true&dir=naplo/felveteli/level&file='.$file.'.pdf')); + exit; + } else { + $_SESSION['alert'][] = 'info::Hiba a file-generáláskor!'; + } + } + } else { + $_SESSION['alert'][] = 'info::Nem adtál meg érvényes kulcsot a letöltéshez!'; + } + } + // ha eljutottunk idáig, visszairányíthatnánk a lekérdező oldalra + //header('Location: '.location('index.php?page=felveteli&f=kozponti')); + +?> diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/level-mzsg.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/level-mzsg.php new file mode 100644 index 00000000..e69de29b --- /dev/null +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/level-mzsg.php diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/levelIgazgato-mzsg-pre.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/levelIgazgato-mzsg-pre.php new file mode 100644 index 00000000..b954f0c2 --- /dev/null +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/levelIgazgato-mzsg-pre.php @@ -0,0 +1,68 @@ +<?php + + define('_EV',date('Y')); + if (_RIGHTS_OK !== true) die(); + if ( + _USERACCOUNT != 'mayoradmin' && __FELVETELIADMIN !== true && __PORTAL_CODE!=='kanizsay' + ) { + $_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'); + + $IKTSZ = 'klik037775001/04442-1/2024'; + + $ADAT['generatePDF'] = readVariable($_POST['generatePDF'],'id',null); + $ADAT['sendMAIL'] = readVariable($_POST['sendMAIL'],'strictstring',null); + +// $q = "SELECT *, iskolaEmail as email, iskolaTelepules AS telepules, iskolaIrsz as irsz, iskolaNev as nev, iskolaCim as cim FROM felveteli_iskolak"; + $q = "SELECT distinct OM, isk_email as email, isk_telepules AS telepules, isk_irsz as irsz, isk_nev as nev, isk_utcahazszam as cim FROM felveteli_eredmeny where OM <> 'FIKTIV'"; +// $ADAT['iskola'] = db_query($q, array('modul'=>'naplo','result'=>'assoc','keyfield'=>'omkod')); + $ADAT['iskola'] = db_query($q, array('modul'=>'naplo','result'=>'assoc','keyfield'=>'OM')); +// $q = "SELECT distinct omkod FROM felveteli WHERE level2 != 'nem kell értesíteni' AND omkod != '' ORDER BY omkod"; + $q = "SELECT distinct OM FROM felveteli_eredmeny WHERE OM != '' ORDER BY OM"; + $ADAT['OM'] = $R = db_query($q, array('modul'=>'naplo','result'=>'idonly')); + for ($i=0; $i<count($R); $i++) { + $ADAT['diak'] = array(); + $_om = $R[$i]; // iskola OM kódja + $ADAT['iskola'][$_om]['id'] = i+1; +# $q = "SELECT * FROM felveteli WHERE level2 != 'nem kell értesíteni' AND omkod='%s' ORDER BY omkod,nev"; + $q = "SELECT * FROM felveteli_eredmeny WHERE OM='%s' ORDER BY nev"; + $ADAT['diak'] = db_query($q, array('modul'=>'naplo','result'=>'indexed','values'=>array($_om))); + $file = _EV . '_' . ($i+1) . '_' . $_om; + $ADAT['iktsz'] = $IKTSZ; // . ($i+1) . '/' . _EV; + 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('igazgato@moricz-bp.hu', 'Budapest II. Kerületi Móricz Zsigmond Gimnázium'); + $mail->addReplyTo('felveteli@moricz-bp.hu', 'Felvételi ügyintézés - Móricz Zsigmond Gimnázium'); + $mail->addAddress($ADAT['iskola'][$_om]['email'], 'Igazgató'); + $mail->addAddress('bence.barnkopf@moricz-bp.hu', 'Igazgató'); + $mail->Subject = 'Értesítés felvételi eredményekről - 2024/2025-ös 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/naplo/felveteli/levelIgazgato/".$file.'.pdf'); + if (!$mail->send()) { + echo "Mailer Error: " . $mail->ErrorInfo; + } else { + echo "Message sent! " . $ADAT['iskola'][$_om]['email']; + $qr = "UPDATE felveteli SET level2='értesítve' WHERE omkod='%s'"; + db_query($qr, array('modul'=>'naplo','values'=>array($_om))); + } + } + // header('Location: '.location('index.php?page=session&f=download&download=true&dir=felveteli/levelIgazgato&file='.$file.'.pdf')); + } + } + +?> diff --git a/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/levelIgazgato-mzsg.php b/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/levelIgazgato-mzsg.php new file mode 100644 index 00000000..9a862f17 --- /dev/null +++ b/mayor-orig/mayor-naplo/www/policy/private/naplo/felveteli/levelIgazgato-mzsg.php @@ -0,0 +1,30 @@ +<?php + global $ADAT; + + putLevelIgazgato($ADAT); + + // phtml + function putLevelIgazgato($ADAT) { + formBegin(); + echo '<h1>PDF generálás?</h1>Generáljunk pdf-eket? (Lassan fut!)<input type="checkbox" name="generatePDF" value="1" /><br/>'; + echo '<input type="submit" />'; + + echo '<h1>Email küldés</h1>'; + echo '<input type="submit" /><br />'; + for ($i=0; $i<count($ADAT['OM']); $i++) { + $_om = $ADAT['OM'][$i]; +// echo '<input type="checkbox" name="sendMAIL[]" value="'.$_om.'" checked="checked" />'; + echo $i.". "; + echo 'SENDEMAIL <input type="checkbox" name="sendMAIL[]" value="'.$_om.'" />'; + echo $_om.' : '; + var_dump($ADAT['iskola'][$_om]['email']); + $file= $file = _EV . '_' . ($i+1) . '_' . $_om; + echo '<a href="'.href('index.php?page=session&f=download&download=true&dir=naplo/felveteli/levelIgazgato&file='.$file.'.pdf').'">PDF</a>'; + echo '<br/>'; + if ($i%5==0) echo '<hr/>'; + } + echo '<input type="submit" />'; + formEnd(); + } + +?>
\ No newline at end of file |