session_start();
?>
include "config/koneksi.php";
include "config/fungsi_indotgl.php";
include "config/library.php";
include "config/class_paging.php";
include "config/conf.php";
// Detail Jurnal
if ($_GET['module']=='jurnalharian'){
echo "Jurnal Pendaftaran Calon Peserta Didik Baru
MAN KUTOWINANGUN Tahun Pelajaran 2024/2025 ";
echo " ";
echo "";
$sql = "select * from viewjurnal where status=1 ORDER BY total DESC, nilaimtk DESC, nilaiipa DESC, nilaibhse DESC, nilaibhsi DESC, id_csiswa ASC ";
$hasil = mysqli_query($link,$sql);
echo " ";
$no = 1;
$terang = true;
?>
Rangking
No Pendft
Kode
Nama
Asal Sekolah
Nilai
Jumlah Nilai UN
Point Kejuaraan
Total
MTK
IPA
BHS INDO
BHS INGG
while($r=mysqli_fetch_array($hasil)){
if ($terang) {
echo " ";
} else {
echo " ";
}
if ($r['jk']=="1") {$jeniskelamin="L";} else {$jeniskelamin="P";}
$vnilaimtk = strlen($r['nilaimtk']);
if($vnilaimtk== 3) {
$rnmtk = $r['nilaimtk']."0";
}
elseif ($vnilaimtk== 2)
{
$rnmtk = $r['nilaimtk'].".00";
}
elseif ($vnilaimtk== 1)
{
$rnmtk = $r['nilaimtk'].".00";
} else {
$rnmtk = $r['nilaimtk'];
}
$vnilaiipa = strlen($r['nilaiipa']);
if($vnilaiipa== 3) {
$rnipa = $r['nilaiipa']."0";
}
elseif ($vnilaiipa== 2)
{
$rnipa = $r['nilaiipa'].".00";
}
elseif ($vnilaiipa== 1)
{
$rnipa = $r['nilaiipa'].".00";
} else {
$rnipa = $r['nilaiipa'];
}
$vnilaibhsi = strlen($r['nilaibhsi']);
if($vnilaibhsi== 3) {
$rnbhsi = $r['nilaibhsi']."0";
}
elseif ($vnilaibhsi== 2)
{
$rnbhsi = $r['nilaibhsi'].".00";
}
elseif ($vnilaibhsi== 1)
{
$rnbhsi = $r['nilaibhsi'].".00";
} else {
$rnbhsi = $r['nilaibhsi'];
}
$vnilaibhse = strlen($r['nilaibhse']);
if($vnilaibhse== 3) {
$rnbhse = $r['nilaibhse']."0";
}
elseif ($vnilaibhse== 2)
{
$rnbhse = $r['nilaibhse'].".00";
}
elseif ($vnilaibhse== 1)
{
$rnbhse = $r['nilaibhse'].".00";
} else {
$rnbhse = $r['nilaibhse'];
}
$vnilaiprestasi = strlen($r['nilaiprestasi']);
if($vnilaiprestasi== 3) {
$rnprestasi = $r['nilaiprestasi']."0";
}
elseif ($vnilaiprestasi== 2)
{
$rnprestasi = $r['nilaiprestasi']."00";
}
elseif ($vnilaiprestasi== 1)
{
$rnprestasi = $r['nilaiprestasi'].".00";
} else {
$rnprestasi = $r['nilaiprestasi'];
}
$ntotal = $r['jmlnilai']+ $r['nilaiprestasi'];
$vjmlnilai = strlen($r['jmlnilai']);
if($vjmlnilai== 4) {
$vnjmlnilai = $r['jmlnilai']."0";
}
elseif ($vjmlnilai== 2)
{
$vnjmlnilai = $r['jmlnilai'].".00";
}
elseif ($vjmlnilai== 1)
{
$vnjmlnilai = $r['jmlnilai'].".00";
} else {
$vnjmlnilai = $r['jmlnilai'];
}
$vtotal = strlen($ntotal);
if($vtotal== 4) {
$rvtotal = $ntotal."0";
}
elseif ($vtotal== 2)
{
$rvtotal = $ntotal.".00";
}
elseif ($vtotal== 1)
{
$rvtotal = $ntotal.".00";
} else {
$rvtotal = $ntotal;
}
if ($no>320) {
echo "$no $r[id_csiswa]
$r[kode]
$r[nama] $r[sd] $rnmtk $rnipa $rnbhsi $rnbhse $vnjmlnilai $rnprestasi
$rvtotal
";
$no++;
$terang = !$terang;
} else {
echo "$no $r[id_csiswa]
$r[kode]
$r[nama] $r[sd] $rnmtk $rnipa $rnbhsi $rnbhse $vnjmlnilai $rnprestasi
$rvtotal
";
$no++;
$terang = !$terang;
}
}
echo "
";
$nf=chr(34)."javascript:void window.open('$www/cetakexcel.php?module=jurnalppdb&option=com_content&task=view&Itemid=143&pop=1&page=0', 'win2', 'status=no,addressbar=yes,toolbar=no,scrollbars=yes,titlebar=no,menubar=no,resizable=yes,width=800,height=800,directories=yes,location=yes');".chr(34)." title='Tampil satu halaman untuk dicetak ke printer'";
$tglinfo = tgl_indo(date("Y m d"));
}
if ($_GET['module']=='calondu'){
echo "Calon Peserta Didik Baru Yang Sudah Daftar Ulang
MAN KUTOWINANGUN Tahun Pelajaran 2024/2025 ";
echo " ";
echo "";
$hasil = mysqli_query($link, "select * from viewjurnalsemua where daftarulang=2 ORDER BY total DESC, nilaimtk DESC, nilaiipa DESC, nilaibhse DESC, nilaibhsi DESC, id_csiswa ASC ");
echo " ";
$no = 1;
$terang = true;
?>
Rangking
No Pendft
Nama
Asal Sekolah
Nilai
Jumlah Nilai UN
Point Kejuaraan
Total
MTK
IPA
BHS INDO
BHS INGG
while($r=mysqli_fetch_array($hasil)){
if ($terang) {
echo " ";
} else {
echo " ";
}
if ($r['jk']=="1") {$jeniskelamin="L";} else {$jeniskelamin="P";}
$vnilaimtk = strlen($r['nilaimtk']);
if($vnilaimtk== 3) {
$rnmtk = $r['nilaimtk']."0";
}
elseif ($vnilaimtk== 2)
{
$rnmtk = $r['nilaimtk'].".00";
}
elseif ($vnilaimtk== 1)
{
$rnmtk = $r['nilaimtk'].".00";
} else {
$rnmtk = $r['nilaimtk'];
}
$vnilaiipa = strlen($r['nilaiipa']);
if($vnilaiipa== 3) {
$rnipa = $r['nilaiipa']."0";
}
elseif ($vnilaiipa== 2)
{
$rnipa = $r['nilaiipa'].".00";
}
elseif ($vnilaiipa== 1)
{
$rnipa = $r['nilaiipa'].".00";
} else {
$rnipa = $r['nilaiipa'];
}
$vnilaibhsi = strlen($r['nilaibhsi']);
if($vnilaibhsi== 3) {
$rnbhsi = $r['nilaibhsi']."0";
}
elseif ($vnilaibhsi== 2)
{
$rnbhsi = $r['nilaibhsi'].".00";
}
elseif ($vnilaibhsi== 1)
{
$rnbhsi = $r['nilaibhsi'].".00";
} else {
$rnbhsi = $r['nilaibhsi'];
}
$vnilaibhse = strlen($r['nilaibhse']);
if($vnilaibhse== 3) {
$rnbhse = $r['nilaibhse']."0";
}
elseif ($vnilaibhse== 2)
{
$rnbhse = $r['nilaibhse'].".00";
}
elseif ($vnilaibhse== 1)
{
$rnbhse = $r['nilaibhse'].".00";
} else {
$rnbhse = $r['nilaibhse'];
}
$vnilaiprestasi = strlen($r['nilaiprestasi']);
if($vnilaiprestasi== 3) {
$rnprestasi = $r['nilaiprestasi']."0";
}
elseif ($vnilaiprestasi== 2)
{
$rnprestasi = $r['nilaiprestasi']."00";
}
elseif ($vnilaiprestasi== 1)
{
$rnprestasi = $r['nilaiprestasi'].".00";
} else {
$rnprestasi = $r['nilaiprestasi'];
}
$ntotal = $r['jmlnilai']+ $r['nilaiprestasi'];
$vjmlnilai = strlen($r['jmlnilai']);
if($vjmlnilai== 4) {
$vnjmlnilai = $r['jmlnilai']."0";
}
elseif ($vjmlnilai== 2)
{
$vnjmlnilai = $r['jmlnilai'].".00";
}
elseif ($vjmlnilai== 1)
{
$vnjmlnilai = $r['jmlnilai'].".00";
} else {
$vnjmlnilai = $r['jmlnilai'];
}
$vtotal = strlen($ntotal);
if($vtotal== 4) {
$rvtotal = $ntotal."0";
}
elseif ($vtotal== 2)
{
$rvtotal = $ntotal.".00";
}
elseif ($vtotal== 1)
{
$rvtotal = $ntotal.".00";
} else {
$rvtotal = $ntotal;
}
echo "$no $r[id_csiswa]
$r[nama] $r[sd] $rnmtk $rnipa $rnbhsi $rnbhse $vnjmlnilai $rnprestasi
$rvtotal
";
$no++;
$terang = !$terang;
}
echo "
";
$nf=chr(34)."javascript:void window.open('$www/cetakexcel.php?module=daftarulang&option=com_content&task=view&Itemid=143&pop=1&page=0', 'win2', 'status=no,addressbar=yes,toolbar=no,scrollbars=yes,titlebar=no,menubar=no,resizable=yes,width=800,height=800,directories=yes,location=yes');".chr(34)." title='Tampil satu halaman untuk dicetak ke printer'";
$tglinfo = tgl_indo(date("Y m d"));
}
if ($_GET['module']=='tidakdicabut'){
echo "Jurnal Pendaftaran Calon Peserta Didik Baru
MAN 3 Kebumen Tahun Pelajaran 2024/2025 ";
echo " ";
echo "";
$sql = "select * from viewjurnal where status=1 ORDER BY total DESC, nilaimtk DESC, nilaiipa DESC, nilaibhse DESC, nilaibhsi DESC ";
$hasil = mysqli_query($link,$sql);
echo " ";
$no = 1;
$terang = true;
?>
No
No Pendft
Nama
Asal Sekolah
Nilai
Jumlah Nilai UN
Point Kejuaraan
Total
MTK
IPA
BHS INDO
BHS INGG
while($r=mysqli_fetch_array($hasil)){
if ($terang) {
echo " ";
} else {
echo " ";
}
if ($r['jk']=="1") {$jeniskelamin="Laki-laki";} else {$jeniskelamin="Perempuan";}
$vnilaimtk = strlen($r['nilaimtk']);
if($vnilaimtk== 3) {
$rnmtk = $r['nilaimtk']."0";
}
elseif ($vnilaimtk== 2)
{
$rnmtk = $r['nilaimtk'].".00";
}
elseif ($vnilaimtk== 1)
{
$rnmtk = $r['nilaimtk'].".00";
} else {
$rnmtk = $r['nilaimtk'];
}
$vnilaiipa = strlen($r['nilaiipa']);
if($vnilaiipa== 3) {
$rnipa = $r['nilaiipa']."0";
}
elseif ($vnilaiipa== 2)
{
$rnipa = $r['nilaiipa'].".00";
}
elseif ($vnilaiipa== 1)
{
$rnipa = $r['nilaiipa'].".00";
} else {
$rnipa = $r['nilaiipa'];
}
$vnilaibhsi = strlen($r['nilaibhsi']);
if($vnilaibhsi== 3) {
$rnbhsi = $r['nilaibhsi']."0";
}
elseif ($vnilaibhsi== 2)
{
$rnbhsi = $r['nilaibhsi'].".00";
}
elseif ($vnilaibhsi== 1)
{
$rnbhsi = $r['nilaibhsi'].".00";
} else {
$rnbhsi = $r['nilaibhsi'];
}
$vnilaibhse = strlen($r['nilaibhse']);
if($vnilaibhse== 3) {
$rnbhse = $r['nilaibhse']."0";
}
elseif ($vnilaibhse== 2)
{
$rnbhse = $r['nilaibhse'].".00";
}
elseif ($vnilaibhse== 1)
{
$rnbhse = $r['nilaibhse'].".00";
} else {
$rnbhse = $r[nilaibhse];
}
$vnilaiprestasi = strlen($r['nilaiprestasi']);
if($vnilaiprestasi== 3) {
$rnprestasi = $r['nilaiprestasi']."0";
}
elseif ($vnilaiprestasi== 2)
{
$rnprestasi = $r['nilaiprestasi']."00";
}
elseif ($vnilaiprestasi== 1)
{
$rnprestasi = $r['nilaiprestasi'].".00";
} else {
$rnprestasi = $r['nilaiprestasi'];
}
$ntotal = $r['jmlnilai']+ $r['nilaiprestasi'];
$vjmlnilai = strlen($r['jmlnilai']);
if($vjmlnilai== 4) {
$vnjmlnilai = $r['jmlnilai']."0";
}
elseif ($vjmlnilai== 2)
{
$vnjmlnilai = $r['jmlnilai'].".00";
}
elseif ($vjmlnilai== 1)
{
$vnjmlnilai = $r['jmlnilai'].".00";
} else {
$vnjmlnilai = $r['jmlnilai'];
}
$vtotal = strlen($ntotal);
if($vtotal== 4) {
$rvtotal = $ntotal."0";
}
elseif ($vtotal== 2)
{
$rvtotal = $ntotal.".00";
}
elseif ($vtotal== 1)
{
$rvtotal = $ntotal.".00";
} else {
$rvtotal = $ntotal;
}
if ($no>320) {
echo "$no $r[id_csiswa]
$r[nama] $r[sd] $rnmtk $rnipa $rnbhsi $rnbhse $vnjmlnilai $rnprestasi
$rvtotal
";
$no++;
$terang = !$terang;
} else {
echo "$no $r[id_csiswa]
$r[nama] $r[sd] $rnmtk $rnipa $rnbhsi $rnbhse $vnjmlnilai $rnprestasi
$rvtotal
\n
";
$no++;
$terang = !$terang;
}
}
echo "
";
$nf=chr(34)."javascript:void window.open('$www/cetakexcel.php?module=jurnalppdb&option=com_content&task=view&Itemid=143&pop=1&page=0', 'win2', 'status=no,addressbar=yes,toolbar=no,scrollbars=yes,titlebar=no,menubar=no,resizable=yes,width=800,height=800,directories=yes,location=yes');".chr(34)." title='Tampil satu halaman untuk dicetak ke printer'";
}
if ($_GET['module']=='detailjurnalcsiswa'){
$sqlcsiswa = "select * from viewjurnalsemua where id_csiswa='$_GET[id]'";
$sqlexesiswa = mysqli_query($link,$sqlcsiswa);
$dcsiswa = mysqli_fetch_array($sqlexesiswa);
echo " ";
if ($dcsiswa[gambar]!=''){
echo " ";
}
echo "1. Nomor Pendaftaran : $_GET[id] ";
$vtgl = tgl_indo($dcsiswa[tgl_lahir]);
if($dcsiswa['jk']=="1") {
$vjk = "Laki-laki";
} else {
$vjk = "Perempuan";
}
echo "2. Nama Lengkap : $dcsiswa[nama]
3. NISN : $dcsiswa[nisn]
4. Tempat Lahir : $dcsiswa[tmp_lahir]
5. Tanggal Lahir : $vtgl ";
echo "6. Jenis Kelamin : $vjk ";
$agama=mysqli_query($link,"SELECT * FROM agama where id_agama = '$dcsiswa[agama]'");
$va=mysqli_fetch_array($agama);
echo "7. A g a m a : $va[agama] ";
$stanakinput=mysqli_query($link,"SELECT * FROM statusanak where id_statusanak='$dcsiswa[id_statusanak]'");
$sai=mysqli_fetch_array($stanakinput);
echo "8. Anak ke : $dcsiswa[anakke] ";
echo "9. Status Anak dalam keluarga : $sai[statusanak] ";
echo "10. Alamat : $dcsiswa[alamat] ";
echo "11. Nomor Telp/HP : $dcsiswa[telpsiswa] ";
echo " 12. Asal Sekolah : ";
echo " 12.1 Nama SMP/MTs : $dcsiswa[sd] ";
echo " 12.2 Alamat SMP/MTs : $dcsiswa[alamatsd] ";
echo " 12.3 Kecamatan : $dcsiswa[kecamatan] ";
echo " 12.4 Kabupaten : $dcsiswa[kabupaten] ";
echo " 12.5 Provinsi : $dcsiswa[provinsi] ";
echo " 13. Nomor Ijazah/Tahun : $dcsiswa[noijazah] ";
echo " 14. Nilai Ujian Nasional : ";
if(strlen($dcsiswa['nilaimtk'])==3) {
$vmtk = "$dcsiswa[nilaimtk]0";
} elseif (strlen($dcsiswa['nilaimtk'])==2) {
$vmtk = "$dcsiswa[nilaimtk].00";
} elseif (strlen($dcsiswa['nilaimtk'])==1) {
$vmtk = "$dcsiswa[nilaimtk].00";
} else {
$vmtk = $dcsiswa['nilaimtk'];
}
if(strlen($dcsiswa['nilaiipa'])==3) {
$vipa = "$dcsiswa[nilaiipa]0";
}
elseif (strlen($dcsiswa['nilaiipa'])==2) {
$vipa = "$dcsiswa[nilaiipa].00";
} elseif (strlen($dcsiswa['nilaiipa'])==1) {
$vipa = "$dcsiswa[nilaiipa].00";
} else {
$vipa = $dcsiswa['nilaiipa'];
}
if(strlen($dcsiswa['nilaibhsi'])==3) {
$vbhsi = "$dcsiswa[nilaibhsi]0";
}
elseif (strlen($dcsiswa['nilaibhsi'])==2) {
$vbhsi = "$dcsiswa[nilaibhsi].00";
} elseif (strlen($dcsiswa['nilaibhsi'])==1) {
$vbhsi = "$dcsiswa[nilaibhsi].00";
} else {
$vbhsi = $dcsiswa['nilaibhsi'];
}
if(strlen($dcsiswa['nilaibhse'])==3) {
$vbhse = "$dcsiswa[nilaibhse]0";
}
elseif (strlen($dcsiswa['nilaibhse'])==2) {
$vbhse = "$dcsiswa[nilaibhse].00";
} elseif (strlen($dcsiswa['nilaibhse'])==1) {
$vbhse = "$dcsiswa[nilaibhse].00";
} else {
$vbhse = $dcsiswa['nilaibhse'];
}
if(strlen($dcsiswa['jmlnilai'])==4) {
$vjmlnilai = "$dcsiswa[jmlnilai]0";
} elseif (strlen($dcsiswa['jmlnilai'])==2) {
$vjmlnilai = "$dcsiswa[jmlnilai].00";
} else {
$vjmlnilai = $dcsiswa['jmlnilai'];
}
if (($dcsiswa['juara'])=="1") {
$vjuara = "I";
} elseif (($dcsiswa['juara'])=="2") {
$vjuara = "II";
} elseif (($dcsiswa['juara'])=="3") {
$vjuara = "III";
}
if (($dcsiswa['prestasitk'])=="1") {
$vtingkat = "Internasional";
} elseif (($dcsiswa['prestasitk'])=="2") {
$vtingkat = "Nasional";
} elseif (($dcsiswa['prestasitk'])=="3") {
$vtingkat = "Provinsi";
} elseif (($dcsiswa['prestasitk'])=="4") {
$vtingkat = "Kabupaten";
}
echo " 14.1 Nilai Bahasa Indonesia : $vbhsi ";
echo " 14.2 Nilai Matematika : $vmtk ";
echo " 14.3 Nilai I P A : $vipa ";
echo " 14.4 Nilai Bahasa Inggris : $vbhse ";
echo " 14.5 Point Kejuaraan : $dcsiswa[nilaiprestasi] ";
echo " 14.6 Jumlah Nilai : $vjmlnilai ";
if (empty($dcsiswa['prestasi'])) {
$vprestasi = "-";
} else {
$vprestasi = "Juara $vjuara Lomba $dcsiswa[prestasi] Tingkat $vtingkat";
}
echo " 15. Pretasi Kejuaraan : $vprestasi ";
echo "B. BIODATA ORANG TUA ";
echo "1. Nama Ayah : $dcsiswa[namaortu] ";
echo "2. Pekerjaan Ayah : $dcsiswa[pekerjaanortu] ";
echo "3. Nama Ibu : $dcsiswa[namaibu] ";
echo "4. Pekerjaan Ibu : $dcsiswa[pekerjaanibu] ";
echo "5. Alamat Orang Tua : $dcsiswa[alamatortu] ";
echo "6. Nomor Telp/HP Orang Tua : $dcsiswa[telportu] ";
echo "C. BIODATA WALI (Jika Tinggal Bersama Wali) ";
echo "1. Nama Wali : $dcsiswa[namawali] ";
echo "2. Pekerjaan Wali : $dcsiswa[pekerjaanwali] ";
echo "3. Alamat Wali : $dcsiswa[alamatwali] ";
echo "4. Telephone Wali : $dcsiswa[telpwali] ";
$nf=chr(34)."javascript:void window.open('$www/cetakprofile.php?module=cetak&option=com_content&task=view&Itemid=143&pop=1&page=0', 'win2', 'status=no,addressbar=yes,toolbar=no,scrollbars=yes,titlebar=no,menubar=no,resizable=yes,width=800,height=800,directories=yes,location=yes');".chr(34)." title='Tampil satu halaman untuk dicetak ke printer'";
echo "Kembali
";
}
if ($_GET['module']=='jurnalharianscroll'){
echo "Jurnal Pendaftaran Calon Peserta Didik Baru
MAN 3 Kebumen Tahun Pelajaran 2024/2025 ";
echo " ";
echo "";
$sql = "select * from viewjurnal where status=1 ORDER BY total DESC, nilaimtk DESC, nilaiipa DESC, nilaibhse DESC, nilaibhsi DESC";
$hasil = mysqli_query($link,$sql);
echo " ";
$no = 1;
$terang = true;
?>
Rangking
No Pendft
Kode
Nama
Asal Sekolah
Nilai
Jumlah Nilai UN
Point Kejuaraan
Total
MTK
IPA
BHS INDO
BHS INGG
Rangking
No Pendft
Kode
Nama
Asal Sekolah
Nilai
Jumlah Nilai UN
Point Kejuaraan
Total
MTK
IPA
BHS INDO
BHS INGG
while($r=mysqli_fetch_array($hasil)){
if ($terang) {
echo " ";
} else {
echo " ";
}
if ($r['jk']=="1") {$jeniskelamin="Laki-laki";} else {$jeniskelamin="Perempuan";}
$vnilaimtk = strlen($r['nilaimtk']);
if($vnilaimtk== 3) {
$rnmtk = $r['nilaimtk']."0";
}
elseif ($vnilaimtk== 2)
{
$rnmtk = $r['nilaimtk'].".00";
}
elseif ($vnilaimtk== 1)
{
$rnmtk = $r['nilaimtk'].".00";
} else {
$rnmtk = $r['nilaimtk'];
}
$vnilaiipa = strlen($r['nilaiipa']);
if($vnilaiipa== 3) {
$rnipa = $r['nilaiipa']."0";
}
elseif ($vnilaiipa== 2)
{
$rnipa = $r['nilaiipa'].".00";
}
elseif ($vnilaiipa== 1)
{
$rnipa = $r['nilaiipa'].".00";
} else {
$rnipa = $r['nilaiipa'];
}
$vnilaibhsi = strlen($r['nilaibhsi']);
if($vnilaibhsi== 3) {
$rnbhsi = $r['nilaibhsi']."0";
}
elseif ($vnilaibhsi== 2)
{
$rnbhsi = $r['nilaibhsi'].".00";
}
elseif ($vnilaibhsi== 1)
{
$rnbhsi = $r['nilaibhsi'].".00";
} else {
$rnbhsi = $r['nilaibhsi'];
}
$vnilaibhse = strlen($r['nilaibhse']);
if($vnilaibhse== 3) {
$rnbhse = $r['nilaibhse']."0";
}
elseif ($vnilaibhse== 2)
{
$rnbhse = $r['nilaibhse'].".00";
}
elseif ($vnilaibhse== 1)
{
$rnbhse = $r['nilaibhse'].".00";
} else {
$rnbhse = $r['nilaibhse'];
}
$vnilaiprestasi = strlen($r['nilaiprestasi']);
if($vnilaiprestasi== 3) {
$rnprestasi = $r['nilaiprestasi']."0";
}
elseif ($vnilaiprestasi== 2)
{
$rnprestasi = $r['nilaiprestasi']."00";
}
elseif ($vnilaiprestasi== 1)
{
$rnprestasi = $r['nilaiprestasi'].".00";
} else {
$rnprestasi = $r['nilaiprestasi'];
}
$ntotal = $r['jmlnilai']+ $r['nilaiprestasi'];
$vjmlnilai = strlen($r['jmlnilai']);
if($vjmlnilai== 4) {
$vnjmlnilai = $r['jmlnilai']."0";
}
elseif ($vjmlnilai== 2)
{
$vnjmlnilai = $r['jmlnilai'].".00";
}
elseif ($vjmlnilai== 1)
{
$vnjmlnilai = $r['jmlnilai'].".00";
} else {
$vnjmlnilai = $r['jmlnilai'];
}
$vtotal = strlen($ntotal);
if($vtotal== 4) {
$rvtotal = $ntotal."0";
}
elseif ($vtotal== 2)
{
$rvtotal = $ntotal.".00";
}
elseif ($vtotal== 1)
{
$rvtotal = $ntotal.".00";
} else {
$rvtotal = $ntotal;
}
if ($no>320) {
echo "$no $r[id_csiswa]
$r[kode]
$r[nama] $r[sd] $rnmtk $rnipa $rnbhse $rnbhsi $vnjmlnilai $rnprestasi
$rvtotal
";
$no++;
$terang = !$terang;
} else {
echo "$no $r[id_csiswa]
$r[kode]
$r[nama] $r[sd] $rnmtk $rnipa $rnbhsi $rnbhse $vnjmlnilai $rnprestasi
$rvtotal
\n
";
$no++;
$terang = !$terang;
}
}
echo "
";
?>
}
if ($_GET['module']=='calonditerima'){
$today = date('h:i:s A');
$siki = date("H:i:s");
$tanggal = date("Y m d");
$tglsekarangindo = tgl_indo(date("Y m d"));
echo "Saat ini Tanggal $tglsekarangindo pukul $siki ";
if ($tanggal>="2011 07 05" and $siki >="09:00:00") {
echo "Pengumuman Hasil Pendaftaran Calon Peserta Didik Baru
MAN 3 Kebumen Tahun Pelajaran 2024/2025 ";
echo " ";
echo "";
$sql = "select * from viewjurnal where status=1 ORDER BY total DESC, nilaimtk DESC, nilaiipa DESC, nilaibhse DESC, nilaibhsi DESC, id_csiswa ASC ";
$hasil = mysqli_query($link,$sql);
echo " ";
$no = 1;
$terang = true;
?>
Rangking
No Pendaftaran
Nama
Asal Sekolah
Nilai
Keterangan
Matematika
IPA
Bahasa Indonesia
Bahasa Inggris
Jumlah N. UN
Point Kejuaraan
Total
while($r=mysqli_fetch_array($hasil)){
if ($terang) {
echo " ";
} else {
echo " ";
}
if ($r['jk']=="1") {$jeniskelamin="Laki-laki";} else {$jeniskelamin="Perempuan";}
$vnilaimtk = strlen($r['nilaimtk']);
if($vnilaimtk== 3) {
$rnmtk = $r['nilaimtk']."0";
}
elseif ($vnilaimtk== 2)
{
$rnmtk = $r['nilaimtk'].".00";
}
elseif ($vnilaimtk== 1)
{
$rnmtk = $r['nilaimtk'].".00";
} else {
$rnmtk = $r['nilaimtk'];
}
$vnilaiipa = strlen($r['nilaiipa']);
if($vnilaiipa== 3) {
$rnipa = $r['nilaiipa']."0";
}
elseif ($vnilaiipa== 2)
{
$rnipa = $r['nilaiipa'].".00";
}
elseif ($vnilaiipa== 1)
{
$rnipa = $r['nilaiipa'].".00";
} else {
$rnipa = $r['nilaiipa'];
}
$vnilaibhsi = strlen($r['nilaibhsi']);
if($vnilaibhsi== 3) {
$rnbhsi = $r['nilaibhsi']."0";
}
elseif ($vnilaibhsi== 2)
{
$rnbhsi = $r['nilaibhsi'].".00";
}
elseif ($vnilaibhsi== 1)
{
$rnbhsi = $r['nilaibhsi'].".00";
} else {
$rnbhsi = $r['nilaibhsi'];
}
$vnilaibhse = strlen($r['nilaibhse']);
if($vnilaibhse== 3) {
$rnbhse = $r['nilaibhse']."0";
}
elseif ($vnilaibhse== 2)
{
$rnbhse = $r['nilaibhse'].".00";
}
elseif ($vnilaibhse== 1)
{
$rnbhse = $r['nilaibhse'].".00";
} else {
$rnbhse = $r['nilaibhse'];
}
$vnilaiprestasi = strlen($r['nilaiprestasi']);
if($vnilaiprestasi== 3) {
$rnprestasi = $r['nilaiprestasi']."0";
}
elseif ($vnilaiprestasi== 2)
{
$rnprestasi = $r['nilaiprestasi']."00";
}
elseif ($vnilaiprestasi== 1)
{
$rnprestasi = $r['nilaiprestasi'].".00";
} else {
$rnprestasi = $r['nilaiprestasi'];
}
$ntotal = $r['jmlnilai']+ $r['nilaiprestasi'];
$vjmlnilai = strlen($r['jmlnilai']);
if($vjmlnilai== 4) {
$vnjmlnilai = $r['jmlnilai']."0";
}
elseif ($vjmlnilai== 2)
{
$vnjmlnilai = $r['jmlnilai'].".00";
}
elseif ($vjmlnilai== 1)
{
$vnjmlnilai = $r['jmlnilai'].".00";
} else {
$vnjmlnilai = $r['jmlnilai'];
}
$vtotal = strlen($ntotal);
if($vtotal== 4) {
$rvtotal = $ntotal."0";
}
elseif ($vtotal== 2)
{
$rvtotal = $ntotal.".00";
}
elseif ($vtotal== 1)
{
$rvtotal = $ntotal.".00";
} else {
$rvtotal = $ntotal;
}
if ($no>320) {
echo "$no $r[id_csiswa]
$r[nama] $r[sd] $rnmtk $rnipa $rnbhsi $rnbhse $vnjmlnilai $rnprestasi
$rvtotal
Tidak Diterima
";
$no++;
$terang = !$terang;
} else {
echo "$no $r[id_csiswa]
$r[nama] $r[sd] $rnmtk $rnipa $rnbhsi $rnbhse $vnjmlnilai $rnprestasi
$rvtotal
Diterima
\n
";
$no++;
$terang = !$terang;
}
}
$sqlkuning = "select * from viewjurnalkuning ORDER BY total DESC, nilaimtk DESC, nilaiipa DESC, nilaibhse DESC, nilaibhsi DESC, id_csiswa ASC ";
$hasilkuning = mysqli_query($link,$sqlkuning);
// echo " ";
// $no = 1;
$terang = true;
while($r=mysqli_fetch_array($hasilkuning)){
if ($terang) {
echo "";
} else {
echo " ";
}
if ($r['jk']=="1") {$jeniskelamin="Laki-laki";} else {$jeniskelamin="Perempuan";}
$vnilaimtk = strlen($r['nilaimtk']);
if($vnilaimtk== 3) {
$rnmtk = $r['nilaimtk']."0";
}
elseif ($vnilaimtk== 2)
{
$rnmtk = $r['nilaimtk'].".00";
}
elseif ($vnilaimtk== 1)
{
$rnmtk = $r['nilaimtk'].".00";
} else {
$rnmtk = $r['nilaimtk'];
}
$vnilaiipa = strlen($r['nilaiipa']);
if($vnilaiipa== 3) {
$rnipa = $r['nilaiipa']."0";
}
elseif ($vnilaiipa== 2)
{
$rnipa = $r['nilaiipa'].".00";
}
elseif ($vnilaiipa== 1)
{
$rnipa = $r['nilaiipa'].".00";
} else {
$rnipa = $r['nilaiipa'];
}
$vnilaibhsi = strlen($r['nilaibhsi']);
if($vnilaibhsi== 3) {
$rnbhsi = $r['nilaibhsi']."0";
}
elseif ($vnilaibhsi== 2)
{
$rnbhsi = $r['nilaibhsi'].".00";
}
elseif ($vnilaibhsi== 1)
{
$rnbhsi = $r['nilaibhsi'].".00";
} else {
$rnbhsi = $r['nilaibhsi'];
}
$vnilaibhse = strlen($r['nilaibhse']);
if($vnilaibhse== 3) {
$rnbhse = $r['nilaibhse']."0";
}
elseif ($vnilaibhse== 2)
{
$rnbhse = $r['nilaibhse'].".00";
}
elseif ($vnilaibhse== 1)
{
$rnbhse = $r['nilaibhse'].".00";
} else {
$rnbhse = $r['nilaibhse'];
}
$vnilaiprestasi = strlen($r['nilaiprestasi']);
if($vnilaiprestasi== 3) {
$rnprestasi = $r['nilaiprestasi']."0";
}
elseif ($vnilaiprestasi== 2)
{
$rnprestasi = $r['nilaiprestasi']."00";
}
elseif ($vnilaiprestasi== 1)
{
$rnprestasi = $r['nilaiprestasi'].".00";
} else {
$rnprestasi = $r['nilaiprestasi'];
}
$ntotal = $r['jmlnilai']+ $r['nilaiprestasi'];
$vjmlnilai = strlen($r['jmlnilai']);
if($vjmlnilai== 4) {
$vnjmlnilai = $r['jmlnilai']."0";
}
elseif ($vjmlnilai== 2)
{
$vnjmlnilai = $r['jmlnilai'].".00";
}
elseif ($vjmlnilai== 1)
{
$vnjmlnilai = $r['jmlnilai'].".00";
} else {
$vnjmlnilai = $r['jmlnilai'];
}
$vtotal = strlen($ntotal);
if($vtotal== 4) {
$rvtotal = $ntotal."0";
}
elseif ($vtotal== 2)
{
$rvtotal = $ntotal.".00";
}
elseif ($vtotal== 1)
{
$rvtotal = $ntotal.".00";
} else {
$rvtotal = $ntotal;
}
echo "$no $r[id_csiswa]
$r[nama] $r[sd] $rnmtk $rnipa $rnbhsi $rnbhse $vnjmlnilai $rnprestasi
$rvtotal
Dicabut
\n
";
$no++;
}
echo "
";
$nf=chr(34)."javascript:void window.open('$www/cetakexcel.php?module=jurnalppdb&option=com_content&task=view&Itemid=143&pop=1&page=0', 'win2', 'status=no,addressbar=yes,toolbar=no,scrollbars=yes,titlebar=no,menubar=no,resizable=yes,width=800,height=800,directories=yes,location=yes');".chr(34)." title='Tampil satu halaman untuk dicetak ke printer'";
} else {
echo "Pengumuman ditampilkan tanggal 05 Juli 2011 pukul 09:00:00 ";
exit();
}
}
?>