Peringkat Laba Pembiyaan 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; } }?>
Besaran Kontribusi :
No
Kelompok
Rupiah
Laba
Nilai
Kontribusi
&tgl_akhir=')">
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_4 = "select sum(jasa) totjasa from pinjaman WHERE tgl_pinjam>='".$tanggal_jual."' and tgl_pinjam<='".$tanggal_jual_max."'"; $hasil_4 = mysqli_query($koneksi, $query_4) or die("Kesalahan pada query!2"); list($totjasa) = mysqli_fetch_row($hasil_4); $per1rp = $_POST[besaran_kontribusi]/$totjasa; $query_a = "SELECT b.alamat_custamer,sum(a.jasa) rplaba FROM pinjaman a,custamer b WHERE tgl_pinjam>='".$tanggal_jual."' and tgl_pinjam<='".$tanggal_jual_max."' and a.id_pel=b.kode_custamer group by alamat_custamer order by rplaba desc"; //echo $query_a; $hasil_a = mysqli_query($koneksi, $query_a) or die("Kesalahan pada query!"); $no=1; while (list($alamat_custamer,$rplaba) = mysqli_fetch_row($hasil_a)) { ?>
$no++; $tot = $tot + $rplaba; $totrp1 = $totrp1 + ($rplaba*$per1rp); $tot_rp = $tot_rp + ($jml_shm_a*10000); } mysqli_free_result($hasil_a); ?>
Total
} ?>