<?php
require_once __DIR__ . '/vendor/autoload.php';
include 'koneksi.php';

use Dompdf\Dompdf;
use Dompdf\Options;
use Endroid\QrCode\QrCode;
use Endroid\QrCode\Writer\PngWriter;
$id = (int)$_GET['id'];
$options = new Options();
$options->set('isRemoteEnabled', true);
$q = mysqli_query($conn,"
SELECT
    u.*,

    k.status,
    k.nomor_skl,
    k.tanggal_kelulusan,

    n.qh,
    n.aa,
    n.fik,
    n.ski,

    n.ppkn,
    n.bindo,
    n.bar,
    n.mtk,
    n.ipa,
    n.ips,
    n.sbp,
    n.pjok,

    n.hifzhan,
    n.bahasa_arab_2,
    n.syariah,

    n.rata_rata

FROM users u

JOIN kelulusan k
ON u.id = k.id_siswa

LEFT JOIN nilai_ijazah n
ON u.nisn = n.nisn

WHERE u.id='$id'

LIMIT 1
");

if(mysqli_num_rows($q)==0){
    die('Data tidak ditemukan');
}

$d = mysqli_fetch_assoc($q);

/* ================= FOTO SISWA ================= */

$username = $d['username'];

if(file_exists("gambar/".$username.".png")){
    $foto = "gambar/".$username.".png";
}else{
    $foto = "gambar/default.png";
}

$foto64 = base64_encode(file_get_contents($foto));
$foto_src = 'data:image/png;base64,'.$foto64;

/* ================= LOGO ================= */

$logo = 'logo.png';

if(file_exists($logo)){
    $logo64 = base64_encode(file_get_contents($logo));
    $logo_src = 'data:image/png;base64,'.$logo64;
}else{
    $logo_src = '';
}

/* ================= QR CODE ================= */

$folder_qr = "qrcode";

if(!is_dir($folder_qr)){
    mkdir($folder_qr,0777,true);
}

$qr_file = $folder_qr.'/'.$id.'.png';

if(!file_exists($qr_file)){

    $url_verifikasi =
        "https://".$_SERVER['HTTP_HOST'].
        dirname($_SERVER['PHP_SELF']).
        "/cek_kelulusan.php?id=".$id;

    $qr = QrCode::create($url_verifikasi);

    $writer = new PngWriter();

    $result = $writer->write($qr);

    $result->saveToFile($qr_file);
}

$qr_src = '';

if(file_exists($qr_file)){

    $qr64 = base64_encode(
        file_get_contents($qr_file)
    );

    $qr_src = 'data:image/png;base64,'.$qr64;
}

/* ================= TTD & STEMPEL ================= */

$ttd_src = '';

$ttd_file = 'ttd.png';

if(file_exists($ttd_file)){

    $ttd64 = base64_encode(
        file_get_contents($ttd_file)
    );

    $ttd_src = 'data:image/png;base64,'.$ttd64;
}

/* ================= DATA ================= */

$nama            = strtoupper($d['nama']);
$nisn            = $d['nisn'] ?? '';
$nomor_peserta   = $d['nomor_peserta'] ?? '';
$nomor_skl       = $d['nomor_skl'] ?? '';
$tanggal_lulus   = $d['tanggal_kelulusan'];

$tempat_lahir    = $d['tempat_lahir'] ?? '';
$tanggal_lahir   = $d['tanggal_lahir'] ?? '';

$npsn = "69727109";

/* ================= NILAI IJAZAH ================= */

$qh             = $d['qh'] ?? 0;
$aa             = $d['aa'] ?? 0;
$fik            = $d['fik'] ?? 0;
$ski            = $d['ski'] ?? 0;

$ppkn           = $d['ppkn'] ?? 0;
$bindo          = $d['bindo'] ?? 0;
$bar            = $d['bar'] ?? 0;
$mtk            = $d['mtk'] ?? 0;
$ipa            = $d['ipa'] ?? 0;
$ips            = $d['ips'] ?? 0;
$sbp            = $d['sbp'] ?? 0;
$pjok           = $d['pjok'] ?? 0;

$hifzhan        = $d['hifzhan'] ?? 0;
$bahasa_arab_2  = $d['bahasa_arab_2'] ?? 0;
$syariah        = $d['syariah'] ?? 0;

$rata_rata      = $d['rata_rata'] ?? 0;
/* ================= TANGGAL INDONESIA ================= */

$bulan = [
    1 => 'Januari',
    2 => 'Februari',
    3 => 'Maret',
    4 => 'April',
    5 => 'Mei',
    6 => 'Juni',
    7 => 'Juli',
    8 => 'Agustus',
    9 => 'September',
    10 => 'Oktober',
    11 => 'November',
    12 => 'Desember'
];

$tanggal_indonesia = '';

if(!empty($tanggal_lulus)){
    $tanggal_indonesia =
        date('d', strtotime($tanggal_lulus)).' '.
        $bulan[(int)date('m', strtotime($tanggal_lulus))].' '.
        date('Y', strtotime($tanggal_lulus));
}

/* ================= QR CODE ================= */

$qr_src = '';

if(file_exists("qrcode/".$id.".png")){
    $qr64 = base64_encode(
        file_get_contents("qrcode/".$id.".png")
    );
    $qr_src = 'data:image/png;base64,'.$qr64;
}

/* ================= HTML ================= */

$html = '
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">

<style>

body{
    font-family:"Times New Roman";
    font-size:14px;
    margin:25px;
}

.header{
    text-align:center;
    line-height:1.4;
}

.logo{
    width:70px;
    position:absolute;
    top:15px;
    left:20px;
}

.watermark{
    position:fixed;

    width:350px;
    height:auto;

    top:270px;
    left:170px;

    opacity:0.08;
    z-index:-1;
}

.garis{
    border-bottom:2px solid #000;
    margin-top:5px;
    margin-bottom:15px;
}

.judul{
    text-align:center;
    font-weight:bold;
    margin-top:12px;
    margin-bottom:15px;
}

.identitas{
    width:100%;
}

.identitas td{
    padding:3px;
    vertical-align:top;
}

.foto{
    width:120px;
    height:150px;
    border:1px solid #888;
}

.@font-face {
    font-family: NotoArabic;
    src: url("fonts/NotoNaskhArabic-Regular.ttf") format("truetype");

}

body{
    font-family:"Times New Roman";
    font-size:14px;
}

</style>


</head>

<body>

<img src="'.$logo_src.'" class="watermark">
<img src="'.$logo_src.'" class="logo">

<div class="header">

<div style="
    font-size:26px;
    font-weight:bold;
    text-align:center;
    direction:rtl;
    font-family:NotoNaskhArabic-Regular.ttf;
">
    معهد الاتحاد الإسلامى
</div>

<div style="
    font-size:20px;
    font-weight:bold;
    text-align:center;
">
    MIS PERSIS BURUNGAYUN
</div>

<div style="
    text-align:center;
    font-size:13px;
">
    Jl. Cigede Kp. Burungayun RT 001 RW 011 Desa Sukakarya Kecamatan Banyuresmi Kabupaten Garut
</div>
</div>

<div class="garis"></div>

<div class="judul">

<div style="font-size:18px;">
SURAT KETERANGAN LULUS
</div>

<div>
TAHUN PELAJARAN 2025/2026
</div>

<div>
Nomor : '.$nomor_skl.'
</div>

</div>

<br>

Yang bertanda tangan di bawah ini menerangkan bahwa :

<br><br>

<table class="identitas">

<tr>
<td width="220">Nama</td>
<td width="20">:</td>
<td>'.$nama.'</td>
</tr>

<tr>
<td>Tempat dan Tanggal Lahir</td>
<td>:</td>
<td>'.$tempat_lahir.', '.$tanggal_lahir.'</td>
</tr>

<tr>
<td>Nomor Induk Siswa Nasional</td>
<td>:</td>
<td>'.$nisn.'</td>
</tr>

<tr>
<td>Nomor Peserta Ujian Madrasah</td>
<td>:</td>
<td>'.$nomor_peserta.'</td>
</tr>

<tr>
<td>Satuan Pendidikan</td>
<td>:</td>
<td>MIS PERSIS BURUNGAYUN</td>
</tr>

<tr>
<td>Nomor Pokok Sekolah Nasional</td>
<td>:</td>
<td>'.$npsn.'</td>
</tr>

</table>

<br>

Dinyatakan <b>LULUS</b> berdasarkan keputusan Kepala MIS Persis Burungayun setelah memenuhi seluruh kriteria kelulusan yang telah ditetapkan.

<br><br>

Demikian surat keterangan ini dibuat untuk dipergunakan sebagaimana mestinya.

<br><br><br>

<table width="100%">

<tr>

<table width="100%" cellpadding="0" cellspacing="0">

<tr>

<td width="33%" align="center" valign="top">

<img src="'.$qr_src.'" width="110">

</td>

<td width="34%" align="center" valign="top">

<img src="'.$foto_src.'" style="
width:120px;
height:150px;
border:1px solid #888;
">

</td>

<td width="33%" align="center" valign="top">

Garut, '.$tanggal_indonesia.'

<br>

Kepala Madrasah

<br>

<img src="'.$ttd_src.'" style="
width:140px;
height:auto;
">

<br>

<b>
A. SETIAWAN, S.Pd.I
</b>

<br>

NPK.3831300064086

</td>

</tr>

</table>
';

/* ================= PDF ================= */

$options = new Options();
$options->set('isRemoteEnabled', true);

$dompdf = new Dompdf($options);

$html .= '

<div style="page-break-before:always;"></div>

<div style="text-align:center;">

    <div style="
        font-size:18px;
        font-weight:bold;
    ">
        TRANSKRIP NILAI
    </div>

    <div style="
        font-size:16px;
        margin-top:5px;
    ">
        MADRASAH IBTIDAIYAH
    </div>

</div>

<br>

<table width="100%" style="font-size:13px;">

<tr>
<td width="180">Nama</td>
<td width="15">:</td>
<td>'.$nama.'</td>
</tr>

<tr>
<td>NISN</td>
<td>:</td>
<td>'.$nisn.'</td>
</tr>

<tr>
<td>Nomor Peserta</td>
<td>:</td>
<td>'.$nomor_peserta.'</td>
</tr>

<tr>
<td>Nomor SKL</td>
<td>:</td>
<td>'.$nomor_skl.'</td>
</tr>

</table>

<br>

<table width="100%" border="1" cellspacing="0" cellpadding="5">

<tr style="font-weight:bold;text-align:center;">
<td width="40">No</td>
<td>Mata Pelajaran</td>
<td width="80">Nilai</td>
</tr>

<tr>
<td align="center">1</td>
<td>Al Quran Hadits</td>
<td align="center">'.$qh.'</td>
</tr>

<tr>
<td align="center">2</td>
<td>Akidah Akhlak</td>
<td align="center">'.$aa.'</td>
</tr>

<tr>
<td align="center">3</td>
<td>Fikih</td>
<td align="center">'.$fik.'</td>
</tr>

<tr>
<td align="center">4</td>
<td>Sejarah Kebudayaan Islam</td>
<td align="center">'.$ski.'</td>
</tr>

<tr>
<td align="center">5</td>
<td>Pendidikan Pancasila</td>
<td align="center">'.$ppkn.'</td>
</tr>

<tr>
<td align="center">6</td>
<td>Bahasa Indonesia</td>
<td align="center">'.$bindo.'</td>
</tr>

<tr>
<td align="center">7</td>
<td>Bahasa Arab</td>
<td align="center">'.$bar.'</td>
</tr>

<tr>
<td align="center">8</td>
<td>Matematika</td>
<td align="center">'.$mtk.'</td>
</tr>

<tr>
<td align="center">9</td>
<td>IPA</td>
<td align="center">'.$ipa.'</td>
</tr>

<tr>
<td align="center">10</td>
<td>IPS</td>
<td align="center">'.$ips.'</td>
</tr>

<tr>
<td align="center">11</td>
<td>Seni Budaya dan Prakarya</td>
<td align="center">'.$sbp.'</td>
</tr>

<tr>
<td align="center">12</td>
<td>Pendidikan Jasmani Olahraga dan Kesehatan</td>
<td align="center">'.$pjok.'</td>
</tr>

<tr>
<td align="center">13</td>
<td>Hifzhan</td>
<td align="center">'.$hifzhan.'</td>
</tr>

<tr>
<td align="center">14</td>
<td>Bahasa Arab 2</td>
<td align="center">'.$bahasa_arab_2.'</td>
</tr>

<tr>
<td align="center">15</td>
<td>Syariah</td>
<td align="center">'.$syariah.'</td>
</tr>

<tr style="font-weight:bold;">
<td colspan="2" align="right">
RATA-RATA
</td>
<td align="center">
'.number_format($rata_rata,2).'
</td>
</tr>

</table>

<br><br>

<div style="
text-align:right;
">
Garut, '.$tanggal_indonesia.'

<br>

Kepala Madrasah

<br>

<img src="'.$ttd_src.'" style="
width:140px;
height:auto;
">

<br>

<b>
A. SETIAWAN, S.Pd.I
</b>
<br>
NPK.3831300064086

</td>
</body>
</html>

';

$dompdf->loadHtml($html);

$dompdf->setPaper('A4','portrait');

$dompdf->render();

$dompdf->stream(
    "SKL_".$nama.".pdf",
    ["Attachment"=>false]
);