CEK DAN CARI DATA SHU

Nama / Register KK >Semua Kelompok > Urut : >Nama KK >Tanggal Saham >Nama Pemilik >No Register KK Periode >Semua periode >

""){ $q_kat = "SELECT reg_kk,tgl_saham,nama,klp,jml_saham,seri,nilai_saham_skrg,laba_terbagi FROM shu_saham where (nama like'%".$_POST[cari]."%' or no_register like '%".$_POST[cari]."%' or reg_kk like '%".$_POST[cari]."%') and klp = '".$_POST[klp]."' and laba_semester='".$periode."' order by ".$sort." " ; } else { $q_kat = "SELECT reg_kk,tgl_saham,nama,klp,jml_saham,seri,nilai_saham_skrg,laba_terbagi FROM shu_saham where (nama like'%".$_POST[cari]."%' or no_register like '%".$_POST[cari]."%' or reg_kk like '%".$_POST[cari]."%') and laba_semester='".$periode."' order by ".$sort." " ; } // echo $q_kat; $hasil_kat = mysqli_query($koneksi, $q_kat) or die("Kesalahan pada query!"); $num_rows = mysqli_num_rows($hasil_kat); if ($num_rows<>0) { $no=1; while ( $ax = mysqli_fetch_array($hasil_kat)) { $data[$ax[reg_kk]][]=$ax; $tot1 = $tot1 + $ax[jml_saham]; $tot2 = $tot2 + $ax[nilai_saham_skrg]; $tot3 = $tot3 + $ax[laba_terbagi]; $stotal[$ax[reg_kk]][jml_saham]+=$ax[jml_saham]; $stotal[$ax[reg_kk]][nilai_saham_skrg]+=$ax[nilai_saham_skrg]; $stotal[$ax[reg_kk]][laba_terbagi]+=$ax[laba_terbagi]; } $kk=array_keys($data); for ($i=0;$i '; } echo ' '; } ?>

No	Register KK	Tgl_saham	Nama	Kelompok	Jml	N. Shm Skrg	SHU	TTD
'.($j+1).'	'.stripslashes($kk[$i]).'	'.substr($data[$kk[$i]][$j][tgl_saham],8,2)."-".substr($data[$kk[$i]][$j][tgl_saham],5,2)."-".substr($data[$kk[$i]][$j][tgl_saham],0,4).'	'.stripslashes($data[$kk[$i]][$j][nama]).'	'; ?>	'.$data[$kk[$i]][$j][jml_saham].'	'.$data[$kk[$i]][$j][nilai_saham_skrg].'	'.$data[$kk[$i]][$j][laba_terbagi].'
Sub TOTAL KK '.stripslashes($kk[$i]).' ('.strtoupper($nmkk[$kk[$i]]).')					'.$stotal[$kk[$i]][jml_saham].'	'.$stotal[$kk[$i]][nilai_saham_skrg].'	'.$stotal[$kk[$i]][laba_terbagi].'
Jumlah Total