Exemplo n.º 1
0
                        <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) {
Exemplo n.º 2
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;
         }
     }