while ($data = $koneksi_db->sql_fetchrow($hasil)) {
            $nofaktur = $data['nofaktur'];
            $piutang = $data['piutang'];
            $tgltermin = tanggalindo($data['tgltermin']);
            if ($tgltermin == '01/01/1970') {
                $tgltermin = '';
            }
            if ($piutang > '0') {
                $lihatslip = '<a href="cetak_notafaktur.php?kode=' . $data['nofaktur'] . '&lihat=ok&bayar=ok"target="new">' . $data['nofaktur'] . '</a>';
            } else {
                $lihatslip = '<a href="cetak_notafaktur.php?kode=' . $data['nofaktur'] . '&lihat=ok"target="new">' . $data['nofaktur'] . '</a>';
            }
            $admin .= '<tr>
            <td>' . $lihatslip . '</td>
            <td>' . tanggalindo($data['tgl']) . '</td>
            <td>' . getnamacustomer($data['kodecustomer']) . '</td>
            <td>' . rupiah_format($data['total']) . '</td>
            <td>' . rupiah_format($data['bayar']) . '</td>
            <td>' . rupiah_format($data['piutang']) . '</td>
            <td>' . $tgltermin . '</td>
        </tr>';
            $ttotal += $data['total'];
            $tbayar += $data['bayar'];
            $tpiutang += $data['piutang'];
        }
        $admin .= '</tbody>';
        $admin .= '
</table>';
    }
    if ($_GET['aksi'] == "cetak") {
        $tglawal = date("Y-m-01");

<td>'.$user.'</td>
</tr>';
$no++;
$grandjumlah+=$jumlah;
$grandsubdiscount+=$subdiscount;
$grandtotal+=$subtotal;
$grandrugilaba+=$rugilaba;
$grandsubtotalbayar+=$subtotalbayar;
}else 
if($jenisproduk=='Semua'){
echo '
<tr class="border">
<td class="text-center">'.$no.'</td>
<td>'.$lihatslip.'</td>
<td>'.tanggalindo($tgl).'</td>
<td>'.getnamacustomer($kodecustomer).'</td>
<td>'.$carabayar.'</td>
<td>'.getjenisbarang($kodebarang).'</td>
<td>'.getjenjangbarang($kodebarang).'</td>
<td>'.$kodebarang.'</td>
<td>'.getnamabarang($kodebarang).'</td>
<td>'.rupiah_format($hargabeli).'</td>
<td>'.rupiah_format($harga).'</td>
<td>'.$jumlah.'</td>
<td>'.cekdiscountpersen($subdiscount).'</td>
<td>'.rupiah_format($subtotal).'</td>
<td>'.rupiah_format($subtotalbayar).'</td>
<td>'.rupiah_format($rugilaba).'</td>
<td>'.$user.'</td>
</tr>';
$no++;

    while ($data = mysql_fetch_array($s)) {
        $id = $data['id'];
        $tgl = $data['tgl'];
        $kode = $data['kode'];
        $customer = $data['customer'];
        $berat = $data['berat'];
        $tharga = $data['tharga'];
        $tharga2 = $data['tharga2'];
        $status = getstatustransaksi($data['status']);
        $detail = '<a class="image" href="admin.php?pilih=transaksi&amp;mod=yes&amp;aksi=detail&amp;id=' . $id . '"><div class="btn btn-primary">Detail</div></a> ';
        $edit = '<a class="image" href="admin.php?pilih=transaksi&amp;mod=yes&amp;aksi=edit&amp;id=' . $id . '"style="color:blue">Edit</a>';
        $deleted = '<a href="admin.php?pilih=transaksi&amp;mod=yes&amp;aksi=hapus&amp;id=' . $id . '" onclick="return confirm(\'Transaksi ini akan di hapus! Anda yakin ?\')"><div class="btn btn-danger">Hapus</div></a>';
        $admin .= '<tr>
<td>' . $kode . '</td>
<td><b>' . $tgl . '</b></td>
<td>' . getnamacustomer($customer) . '</td>
<td>' . $tharga . '</td>
<td>' . $tharga2 . '</td>
<td>' . $status . '</td>
<td>' . $deleted . ' ' . $detail . '</td>
</tr>';
        $no++;
    }
    $jumlah = $no;
    $admin .= '</tbody></table>';
    $admin .= "<input type=hidden name='tot' value='{$jumlah}'>";
    $admin .= '<input type="submit" value="delete" name="submit" class="btn btn-danger">';
    $admin .= "</form>";
}
if ($_GET['aksi'] == 'detail') {
    $id = int_filter($_GET['id']);