nhu

<?php
if (!mysql_connect("localhost","root","nkuiyertyu")){
	die ("Koneksi ke Engine MySQL Gagal !<br>");
}

if (!mysql_select_db("sipp311")){
	die ("Koneksi ke Database Gagal !");
}

$query2 = mysql_query("SELECT
G.redaksihariini AS redaksihariini
FROM (SELECT
SUM(CASE WHEN YEAR(A.tanggal_pendaftaran)<=YEAR(NOW()) AND DATE(F.tanggal_transaksi)=DATE(NOW())AND (F.jenis_biaya_id=157) THEN 1 ELSE 0 END) AS redaksihariini
FROM perkara AS A LEFT JOIN perkara_biaya AS F ON A.perkara_id=F.perkara_id WHERE A.alur_perkara_id <> 114) AS G;

") or die("Query failed with error: ".mysql_error());

$row = mysql_fetch_assoc($query2);
$redaksi_hari_ini = $row['redaksihariini'];

$query = mysql_query("SELECT C.masuk AS masuk, C.putus as putus, C.minutasi as minutasi, C.sisa AS sisa,
(SELECT VALUE FROM sys_config WHERE id = 62) AS namaPN,
(SELECT VALUE FROM sys_config WHERE id = 80) AS versiSIPP,
@kinerjaPN := ROUND(SUM(C.minutasi)*100/(SUM(C.masuk)+SUM(C.sisa)),2) AS kinerjaPN,
(CASE WHEN @kinerjaPN < 50.00 THEN 'red' WHEN @kinerjaPN >=90 THEN 'green' ELSE '#def30c' END) AS warnaPN
FROM (SELECT
SUM(CASE WHEN YEAR(A.tanggal_pendaftaran)<=YEAR(NOW())-1 AND (YEAR(B.tanggal_minutasi)>=YEAR(NOW()) OR (B.tanggal_minutasi IS NULL OR B.tanggal_minutasi='')) THEN 1 ELSE 0 END) AS sisa,
SUM(CASE WHEN YEAR(A.tanggal_pendaftaran)=YEAR(NOW()) THEN 1 ELSE 0 END) AS masuk,
SUM(CASE WHEN YEAR(A.tanggal_pendaftaran)<=YEAR(NOW()) AND YEAR(B.tanggal_putusan)=YEAR(NOW()) THEN 1 ELSE 0 END) AS putus,
SUM(CASE WHEN YEAR(A.tanggal_pendaftaran)<=YEAR(NOW()) AND YEAR(B.tanggal_minutasi)=YEAR(NOW()) THEN 1 ELSE 0 END) AS minutasi
FROM perkara AS A LEFT JOIN perkara_putusan AS B ON A.perkara_id=B.perkara_id WHERE A.alur_perkara_id <> 114) AS C;
") or die("Query failed with error: ".mysql_error());
$row = mysql_fetch_assoc($query);
$namaPN = $row['namaPN'];
$versiSIPP = $row['versiSIPP'];
$kinerjaPN = $row['kinerjaPN'];
$warnaPN = $row['warnaPN'];
$sisa_tahun_lalu = $row['sisa'];
$masuk_tahun_ini = $row['masuk'];
$putus_tahun_ini = $row['putus'];
$minutasi_tahun_ini = $row['minutasi'];
?>

<h4 align="center" style="margin: 30px auto 0px;"><font color="#95c200" size="4" face="Century Gothic">MONITORING SIPP <?=$versiSIPP;?>
<br><?=$namaPN;?></font></h4>
<!--br><br><center><img width="160" src="images/logoMAD.png" /></center-->
<!--<br><center><img  width="70" src="Login/ratio/patuban.jpg" /></center>-->
<div class="box_ratio">
	<div class = "inner">
	<h5 align="center" style="margin: 10px auto 0px;"><font color="#95c200" size="3" face="Century Gothic">REALTIME RASIO PENANGANAN PERKARA SIPP LOKAL</font></h5>

	<h5 align="center" style="margin: 10px auto 0px;"><font color="<?=$warnaPN;?>" size="6" face="Century Gothic" style="text-shadow: -1px 0 black, 0 1px black, 1px 0 black, 0 -1px black;"><?=$kinerjaPN;?> %</font> </h5>
	<h5 align="center" style="margin: 10px auto 0px;"><font color="#95c200" size="2"
	face="Century Gothic">Sisa Tahun Lalu : <?=$sisa_tahun_lalu;?> | Masuk Tahun Ini : <?=$masuk_tahun_ini;?>
	<br>Putus Tahun Ini : <?=$putus_tahun_ini;?> | Minutasi Tahun Ini : <?=$minutasi_tahun_ini;?> | Redaksi hari ini: <?=$redaksi_hari_ini;?></font></h5>
	<br>

	<h5 align="center" style="margin: 10px auto 0px;"><font color="#95c200" size="2" face="Century Gothic">Note : Prosentase Data Mahkamah Agung Akan Sesuai dengan Prosentase Realtime Data Lokal Setelah Disinkronisasi</font></h5>
	<br>
	<h5 align="center" style="margin: 10px auto 0px;"><font color="#95c200" size="2" face="Century Gothic">Kesulitan? Admin SIPP Siap Membantu</font></h5>
	</div>
</div>