rasio sipp

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

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

$query = mysql_query("SELECT C.masuk AS masuk, 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_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'];
$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><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>Minutasi Tahun Ini : <?=$minutasi_tahun_ini;?></font></h5>
	<br>
	<br>
	<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>