| Server IP : 195.130.67.5 / Your IP : 216.73.216.231 Web Server : Microsoft-IIS/10.0 System : Windows NT WEBSERVER1 10.0 build 17763 (Windows Server 2016) i586 User : IUSR ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/inetpub/wwwroot/icd/msc/ |
Upload File : |
<?php
include_once 'lib/lib.php';
$mCtrl = new Controller("registry", "@[PAGE_TITLE]");
$mCtrl->onlyForLoggedInUsers = true;
$mCtrl->checkAuthorization();
$id = "";
if ($mCtrl->userHasRole("certificates")){
$id = Utils::vGet("id", FALSE, "");
}
if (strlen($id) == 0){
$mCtrl->redirectTo();
}
$query = "SELECT `msc_Registry`.*, `RegAccYears`.`Description` as RegAccYearDescription, `CurAccYears`.`Description` as CurAccYearDescription, `CurSemesters`.`Number` as CurSemesterNumber, `CurSemesters`.`Description` as CurSemesterDescription, `GradAccYears`.`Description` as GradAccYearDescription, `GradSemesters`.`Number` as GradSemesterNumber, `GradSemesters`.`Description` as GradSemesterDescription, `msc_GradReasons`.`Description` as GradReasonDescription, `msc_SemesterDates`.`StartDate` as CurSemesterStartDate, `msc_SemesterDates`.`EndDate` as CurSemesterEndDate FROM `msc_Registry` LEFT JOIN `msc_AccYears` `RegAccYears` ON `msc_Registry`.`RegAccYear` = `RegAccYears`.`Id` LEFT JOIN `msc_AccYears` `CurAccYears` ON `msc_Registry`.`CurAccYear` = `CurAccYears`.`Id` LEFT JOIN `msc_AccYears` `GradAccYears` ON `msc_Registry`.`GradAccYear` = `GradAccYears`.`Id` LEFT JOIN `msc_Semesters` `CurSemesters` ON `msc_Registry`.`CurSemester` = `CurSemesters`.`Id` LEFT JOIN `msc_Semesters` `GradSemesters` ON `msc_Registry`.`GradSemester` = `GradSemesters`.`Id` LEFT JOIN `msc_GradReasons` ON `msc_Registry`.`GradReason` = `msc_GradReasons`.`Id` LEFT JOIN `msc_SemesterDates` ON `msc_Registry`.`CurAccYear` = `msc_SemesterDates`.`AccYearId` AND `msc_Registry`.`CurSemester` = `msc_SemesterDates`.`SemesterId`";
$query .= " WHERE `msc_Registry`.`Id` = {$id}";
$stu = DBUtils::getObject($query);
if ($stu == null){
//$mCtrl->redirectTo();
}
function d($d){
if ($d == 0){
return "-";
}else{
return Utils::dateStr(strtotime($d), 1);
}
}
function y($d){
if ($d == 0){
return "-";
}else{
return Utils::dateStr(strtotime($d), 7);
}
}
function r($s, $t){
global $html;
$html = str_replace("@[$s]", $t, $html);
}
function t($t){
if ($t == null){
return "-";
}else{
return $t;
}
}
//require_once("dompdf/dompdf_config.inc.php");
require_once 'dompdf/autoload.inc.php';
use Dompdf\Dompdf;
use Dompdf\Options;
/*
$html =
'<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /></head><body style="font-family: dejavu serif">'.
'<p>Put your html here, or generate it with your favourite '.
'templating system.</p>'.
'αυτό είναι ένα τέστ'.
'</body></html>';
*
*/
$html = file_get_contents("template/docs/registration_certificate.html");
r("SURNAME", $stu->Surname);
r("FORNAME", $stu->Forname);
r("FATNAME", t($stu->Fatname));
r("MOTNAME", t($stu->Motname));
r("NEE", t($stu->MotSurname));
r("BIRTHPLACE", t($stu->BirthPlace));
r("BIRTHDATE", d($stu->DateOfBirth));
r("POLICEID", t($stu->PoliceId));
r("REGDATE", d($stu->RegisteredOn));
r("REGYEAR", y($stu->RegisteredOn));
r("REGACCYEAR", t($stu->RegAccYearDescription));
r("CURRENTSEMESTER", t($stu->CurSemesterNumber));
r("CURRENTSEMESTERDESC", t($stu->CurSemesterDescription));
r("TOTALSEMESTERS", DBUtils::getInfoValInt("SEMESTERSNUM", 0));
r("REGNUMBER", $stu->Id);
if ($stu->GradAccYear > 0){
r("GRADDATE", d($stu->GradDate));
r("GRADACCYEAR", t($stu->GradAccYearDescription));
r("GRADSEMESTER", t($stu->GradSemesterNumber));
r("GRADSEMESTERDESC", t($stu->GradSemesterDescription));
r("GRADREASON", t($stu->GradReasonDescription));
}else{
r("GRADDATE", t(NULL));
r("GRADACCYEAR", t(NULL));
r("GRADSEMESTER", t(NULL));
r("GRADSEMESTERDESC", t(NULL));
r("GRADREASON", t(NULL));
}
r("DOCSSUMMARY", "Όλα τα νόμιμα");
r("CURRENTSEMESTERSTARTDATE", d($stu->CurSemesterStartDate));
r("CURRENTSEMESTERENDDATE", d($stu->CurSemesterEndDate));
r("CURACCYEAR", t($stu->CurAccYearDescription));
if ($stu->Gender == "Male"){
r("HISHER", "του");
}else{
r("HISHER", "της");
}
$ard = getdate(time());
$today = "{$ard['mday']}/{$ard['mon']}/{$ard['year']}";
r("TODAY", $today);
$dompdf = new DOMPDF();
$dompdf->load_html($html);
$dompdf->set_paper('a4', 'portrait'); // change 'a4' to whatever you want
$dompdf->render();
$dompdf->stream("sample.pdf",array('Attachment'=>0));
//$dompdf->stream('my.pdf',array('Attachment'=>0));
?>