Login

05-03-2011, 07:37 AM

[eluser]redraw[/eluser]
dear all,

I want print a report

i have view :

Code:
&lt;body&gt;

<div class='title' align="center">Jurnal Transaksi Harian <br />Periode &lt;?php echo $tanggal_mulai. " S/D " . $tanggal_sampai; ?&gt;</div>

    <table align="center" width="27%" border='0' cellpadding='0' cellspacing='0' class="display" id="example">

<thead>

    <tr>

        <th align="center" width="7%">Tanggal</th>

        <th align="center" width="7%">Nota</th>

        <th align="center" width="7%">Code</th>

        <th align="left" width="23%">Account</th>

        <th align="left" width="23%">Keterangan</th>

        <th align="right" width="10%">Debet</th>

          <th align="right" width="10%">Kredit</th>

    </tr>

 </thead>

    &lt;?php

        $i = 0;

        $xnota = "";

        $row1 = 'Y';

        $v_debet = 0;

        $v_kredit = 0; 

    ?&gt;

    &lt;?php foreach($detail->result() as $rows):?&gt;

    &lt;?php

        $v_debet = $v_debet + $rows->debet;

        $v_kredit = $v_kredit + $rows->kredit;

     ?&gt;

    &lt;?php

    if($xnota != $rows->no_bukti and $row1 != 'Y'){

        echo "<tr><td colspan='7'><hr></td>";

        echo "<tr><td></td></tr>";

        echo "<tr><td colspan='5' align='right'>";

        echo "BALANCE";

        echo "</td>";

        $v_debet = number_format($v_debet);

        $v_kredit = number_format($v_kredit); 

        echo "<td align='right'>". $v_debet ."</td>";

        echo "<td align='right'>". $v_kredit ."</td></tr>";

        echo "<tr><td colspan='5'></td><td colspan='2' valign='colspan'><hr></td><td></td></tr>";

        $v_debet = 0;

        $v_kredit = 0;

    }

        ?&gt;

        <tr>

        <td colspan="7"></td>    

        </tr>

        <tr>

          <td height="19" align="center" >&lt;?php echo $rows->tanggal;?&gt;</td>

          <td height="19" align="center" >&lt;?php echo $rows->no_bukti;?&gt;</td>

          <td height="19" align="center" >&lt;?php echo $rows->code;?&gt;</td>

          <td height="19" align="left" >&lt;?php 

        $jenis = $rows->jenis;

        if($jenis == 'k')

        {

            echo "&nbsp;&nbsp;&nbsp;&nbsp;".$rows->account;

        }

        else

        {

            echo $rows->account;

        }

        ?&gt;</td>

          <td align="left" >&lt;?php echo $rows->keterangan;?&gt;</td>

          <td align="right">&lt;?php 

            $debet = $rows->debet;

            $debet= number_format($debet);

            echo $debet;

        ?&gt;

        </td>

          <td height="19" align="right">&lt;?php

              $kredit = $rows->kredit;

            $kredit= number_format($kredit);

            echo $kredit;

        ?&gt;</td>

          <td align="center">&lt;input type='hidden' id='code_&lt;?php echo $rows-&gt;master_id;?&gt;'        value='&lt;?php echo $rows->code;?&gt;' />

            &lt;input type='hidden' id='tanggal_&lt;?php echo $rows-&gt;master_id;?&gt;'     value='&lt;?php echo $rows->tanggal;?&gt;' />

            &lt;input type='hidden' id='keterangan_&lt;?php echo $rows-&gt;master_id;?&gt;' value='&lt;?php echo $rows->keterangan;?&gt;'/>

          &lt;input type='hidden' id='nilai_&lt;?php echo $rows-&gt;master_id;?&gt;'         value='&lt;?php echo $rows->nilai;?&gt;'/></td>

        </tr>

       &lt;?php

       $xnota = $rows->no_bukti;

       $row1 = 'N';

       ?&gt;

    &lt;?php 

    endforeach;

    if($row1 == 'N'){

        echo "<tr><td colspan='7'><hr></td>";

        echo "<tr><td></td></tr>";

        echo "<tr><td colspan='5' align='right'>";

        echo "BALANCE";

        echo "</td>";

        //$v_debet = $nilaitrn;

        $v_debet = number_format($v_debet);

        $v_kredit = number_format($v_kredit); 

        echo "<td align='right'>".$v_debet."</td>";

        echo "<td align='right'>".$v_kredit."</td></tr>";

        echo "<tr><td colspan='5'></td><td colspan='2' valign='colspan'><hr></td><td></td></tr>";

    }

    ?&gt;

</table>

&lt;/body&gt;

but that display wrong summaries.
I just attached a picture the print preview, so it will be easy to understand.