$a->SetFillColor(210, 210, 010);
$a->Cell(10, 8, $n, 1, 0, 'C', true);
$a->Cell(90, 8, $r->Nama != '' ? $r->Nama : 'PELANGGAN', 1, 0, 'L', true);
$a->Cell(93, 8, $r->Catatan . " " . $r->Alamat . " " . $r->Kota, 1, 1, "L", true);
$a->SetFont('Arial', '', 9);
$ID_P = " and p.ID_Anggota='" . $r->ID_Anggota . "' group by dt.ID_Jual";
$orderby .= ",p.Tanggal";
//$a->Cell(193,8,$where.' '.$ID_P.' '.$orderby,1,1,'L',true);
$dataz = $this->kasir_model->detail_trans_jual($where, $ID_P, $orderby);
foreach ($dataz as $r2) {
$nn++;
$x = 0;
$a->SetFont('Arial', 'I', 9);
$a->SetFillColor(247, 240, 213);
$a->Cell(10, 8, $nn, 1, 0, 'R', true);
$a->cell(20, 8, tglfromSql($r2->Tanggal), 1, 0, 'C', true);
$a->cell(20, 8, $r2->Nomor, 1, 0, 'C', true);
$a->Cell(70, 8, $r2->ID_Jenis == '1' || $r2->ID_Jenis == '5' ? $r2->Jenis_Jual : $r2->Jenis_Jual . " : " . $r2->ID_Post . " - " . $r2->Deskripsi, 1, 0, "L", true);
$a->Cell(73, 8, $r2->ID_Jenis == '1' || $r2->ID_Jenis == '5' ? "" : "Jatuh Tempo Tanggal : " . tglfromSql($r2->Tgl_Cicilan), 1, 1, 'L', true);
$a->SetFont('Arial', '', 9);
$Grp = " and p.ID_Anggota='" . $r2->ID_Anggota . "' and dt.ID_Jual='" . $r2->ID_Jual . "'";
$dataz = $this->kasir_model->detail_trans_jual($where, $Grp, $orderby);
foreach ($dataz as $rr2) {
$x++;
$a->Row(array('', $x, $rr2->Kode, ucwords($rr2->Nama_Barang), number_format($rr2->Jumlah, 2), $r2->Satuan, number_format($rr2->Harga, 2), number_format($rr2->Harga * $rr2->Jumlah, 2)));
$hgb = $r2->ID_Jenis == '5' ? $hgb - $rr2->Harga * $rr2->Jumlah : $hgb + $rr2->Harga * $rr2->Jumlah;
}
}
//sub tlot
$hargaj = rdb('inv_pembayaran', 'ppn', 'sum(ppn) as ppn', "where no_transaksi='" . $r->NoUrut . "' and year(doc_date)='" . $r->Tahun . "'");
$harga = $harga + ($hgb - $hargaj);
