<td align="center">Uraian</td> <td align="center">Detil Jurnal</td> </tr>'; $nox = 1; $totbayar = 0; if ($n1 == 0) { $out .= '<tr> <td>-</td> <td>-</td> <td>-</td> <td>-</td> </tr>'; } else { while ($r1 = mysql_fetch_assoc($e1)) { $jDetTrans = getDetJenisTrans('jenistrans', 'replid', $r1['detjenistrans']); $jTrans = getJenisTrans('kode', $jDetTrans); if ($jTrans == 'ju') { $j = 'ju'; } else { $j = $jTrans . '_come'; } $s2 = ' SELECT replid,rek,nominal,jenis FROM keu_jurnal WHERE transaksi =' . $r1['replid'] . ' ORDER BY jenis ASC'; $e2 = mysql_query($s2); // var_dump($s2);exit(); $tb2 = ''; if (mysql_num_rows($e2) != 0) {
// print_r($s2);exit(); $e2 = mysql_query($s2) or die(mysql_error()); $out .= '<table width="100%" class="isi"> <thead> <tr class="head"> <th width="12%">Tanggal </th> <th width="18%">No. Transaksi</th> <th width="30%">Uraian</th> <th width="20%">Debet</th> <th width="20%">Kredit</th> </tr> </thead> <tbody>'; $debitTot = $kreditTot = 0; while ($r2 = mysql_fetch_assoc($e2)) { $jenis = getJenisTrans('kode', getDetJenisTrans('jenistrans', 'replid', $r2['detjenistrans'])); if ($jenis == 'ju') { // ju $debit = 99; $kredit = 0; } else { if ($jenis == 'out') { // outcome $debit = $r2['rekkas'] == $r2['rek'] ? 0 : $r2['nominal']; $kredit = $r2['rekitem'] == $r2['rek'] ? 0 : $r2['nominal']; } else { // income $debit = $r2['rekkas'] == $r2['rek'] ? $r2['nominal'] : 0; $kredit = $r2['rekitem'] == $r2['rek'] ? $r2['nominal'] : 0; } }