PERIODE : S/D
PELANGGAN :
NO.BUKTI :  
SORT BY :
cariPosisi($batas); $query = "SELECT * FROM $db_tr_jual WHERE tahun = '$tahun'"; $q = "SELECT * FROM $db_tr_jual WHERE tahun = '$tahun'"; if($tglaw<>'' or $tglak<>''){ $query .= " AND (tanggal BETWEEN '".baliktgl($tglaw)."' AND '".baliktgl($tglak)."')"; $q .= " AND (tanggal BETWEEN '".$tglaw."' AND '".$tglak."')"; } if($pelanggan<>''){ $query .= " AND pelanggan = '".$pelanggan."'"; $q .= " OR pelanggan = '".$pelanggan."'"; } if($nok<>''){ $query .= " AND nok like '%".$nok."%'"; $q .= " AND nok like '%".$nok."%'"; } if($sort<>''){ $fld = array('', 'nok', 'tanggal', 'pelanggan', '', '', ''); if(is_numeric($sort)){ $indx = (int)$sort; }else{ $indx = 1; } $fld1 = array('', 'ASC', 'DESC'); if(is_numeric($urutan)){ $indx1 = (int)$urutan; }else{ $indx1 = 1; } $query .= " ORDER BY $fld[$indx] $fld1[$indx1] LIMIT $posisi, $batas"; $q .= " ORDER BY $fld[$indx] $fld1[$indx1]"; }else{ $query .= " ORDER BY tanggal ASC LIMIT $posisi, $batas"; $q .= " ORDER BY tanggal ASC"; } $sql_kel = mysql_query($query) or die(mysql_error()); $fd_kel = mysql_num_rows($sql_kel); if($fd_kel > 0){ $no = $posisi + 1; while ($m = mysql_fetch_assoc($sql_kel)) { if(gtjualnok($m['nok'])-trjualnok($m['nok'])-tpjualnok($m['nok'])==0){ $statusb = "LUNAS"; }else{ $statusb = "LUNAS"; } echo""; $no++; } $jmldata = mysql_num_rows(mysql_query($q)); $jmlhalaman = $p->jumlahHalaman($jmldata, $batas); $linkHalaman = $p->navHalaman($_GET['halaman'], $jmlhalaman, $linkaksi); }else{ echo""; } ?>
NO.
NO. BUKTI
TANGGAL
PELANGGAN
NOMINAL
RETUR
BAYAR
S.BAYAR
DIBUAT OLEH
AKSI
$no $m[nok] ".baliktglindo($m['tanggal'])." ".pelanggan($m['pelanggan'])." ".minuss(gtjualnok($m['nok']))." ".minuss(trjualnok($m['nok']))." ".minuss(tpjualnok($m['nok']))." ".$statusb." ".nama_petugas($m['user'])." "; $aksi2 = "popup/popup.php?".paramEncrypt('mod=faktur_penjualan&db='.$db_beli.'&dbd='.$db_belid.'&nok='.$m['nok'].'&user='.$login_id); if(isset($_SESSION['bpenjualan']) AND $_SESSION['bpenjualan'] <> 'TRUE'){ echo " "; }else{ echo " "; } echo "
Data Penjualan Not found.