Peringkat Nisbah Terbanyak
$today = getdate(); $bln_jual = $_POST[bln_jual]; $thn_jual = $_POST[thn_jual]; $bln_jual_max = $_POST[bln_jual_max]; $thn_jual_max = $_POST[thn_jual_max]; ?>
> switch ($j){ case 1: echo "Januari"; break; case 2: echo "Februari"; break; case 3: echo "Maret"; break; case 4: echo "April"; break; case 5: echo "Mei"; break; case 6: echo "Juni"; break; case 7: echo "Juli"; break; case 8: echo "Agustus"; break; case 9: echo "September"; break; case 10: echo "Oktober"; break; case 11: echo "Nopember"; break; case 12: echo "Desember"; break; } } else {?>
> switch ($j){ case 1: echo "Januari"; break; case 2: echo "Februari"; break; case 3: echo "Maret"; break; case 4: echo "April"; break; case 5: echo "Mei"; break; case 6: echo "Juni"; break; case 7: echo "Juli"; break; case 8: echo "Agustus"; break; case 9: echo "September"; break; case 10: echo "Oktober"; break; case 11: echo "Nopember"; break; case 12: echo "Desember"; break; } } } ?>
> echo $k; } else { ?>
> echo $k; } }?>
s/d Bln
> switch ($n){ case 1: echo "Januari"; break; case 2: echo "Februari"; break; case 3: echo "Maret"; break; case 4: echo "April"; break; case 5: echo "Mei"; break; case 6: echo "Juni"; break; case 7: echo "Juli"; break; case 8: echo "Agustus"; break; case 9: echo "September"; break; case 10: echo "Oktober"; break; case 11: echo "Nopember"; break; case 12: echo "Desember"; break; } } else {?>
> switch ($n){ case 1: echo "Januari"; break; case 2: echo "Februari"; break; case 3: echo "Maret"; break; case 4: echo "April"; break; case 5: echo "Mei"; break; case 6: echo "Juni"; break; case 7: echo "Juli"; break; case 8: echo "Agustus"; break; case 9: echo "September"; break; case 10: echo "Oktober"; break; case 11: echo "Nopember"; break; case 12: echo "Desember"; break; } } } ?>
> echo $o; } else { ?>
> echo $o; } }?>
No
Kode Penabung
Nama Penabung
Kelompok
Rupiah
Nisbah
if (!$_POST[tambah]) { } else { $tanggal_jual = $thn_jual."-".$bln_jual."-".'01'; $tanggal_jual_max = $thn_jual_max."-".$bln_jual_max."-".'31'; require("connect.inc.php"); $query_a = "SELECT a.id_pel,b.nama_custamer,b.alamat_custamer,sum(a.rupiah_simpanan) rpnisbah FROM simpanan a,custamer b WHERE tgl_simpanan>='".$tanggal_jual."' and tgl_simpanan<='".$tanggal_jual_max."' and a.id_pel=b.kode_custamer and left(keterangan,6)='nisbah' group by id_pel order by rpnisbah desc"; //echo $query_a; $hasil_a = mysqli_query($koneksi, $query_a) or die("Kesalahan pada query!"); $no=1; while (list($id_pel,$nama_custamer,$alamat_custamer,$rpnisbah) = mysqli_fetch_row($hasil_a)) { ?>
$no++; $tot = $tot + $rpnisbah; $tot_rp = $tot_rp + ($jml_shm_a*10000); } mysqli_free_result($hasil_a); ?>
Total
} ?>