invoice

<?php

cek_status_login($_SESSION['idpelanggan']);

$aksi = "Upload";
?>
<section class="main-content">

    <div class="row">
        <div class="span9">




    <h4 id="headings"> Data invoice</h4>
    <!--<a href='index.php?mod=invoice&pg=peta'><i class="icon-map-marker"></i>Map View</a>-->
    <table  class="table table-striped table-condensed">
        <thead>
            <th><td><b>Nama </b></td><td><b>Kd Invoice</b></td><td><b>Tanggal Transaksi</b></td><td><b>Total Transaksi</b></td><td><b>Pembayaran</b></td><td><b>Upload Bukti Transfer</b></td><td><b>Link Downlad</b></td></th>
        </thead>
        <tbody>
<?php

$id=$_SESSION['idpelanggan'];
if(isset($_GET['id'])) {
    $aksi = "Upload";
    $id = $_GET['id'];
}
$query="SELECT invoice.*,pelanggan.nama from invoice,pelanggan where invoice.idpelanggan=pelanggan.idpelanggan and pelanggan.idpelanggan='$id'";
$result=mysql_query($query) or die(mysql_error());
$no=1;
$link="";

//proses menampilkan data
while($rows=mysql_fetch_object($result)){

            ?>
            <tr>
                <td><?php echo "posisi" +$no
                ?></td>

                <td><?php echo $rows -> nama; ?></td>
            <td><a href='index.php?mod=chart&pg=invoice_detail&id=<?php echo $rows -> noinvoice; ?>'><?php echo $rows -> noinvoice; ?></a></td>

            <td><?php echo $rows -> tanggal; ?></td>
                <td><?php echo format_rupiah($rows ->totalbayar); ?></td>

            <td><?php echo get_status_invoice($rows -> transfer); ?></td>
            <td>

                <?php

                if ($rows->buktitf==null) {

                 ?>
                <form  class="form-horizontal" method="POST"  enctype="multipart/form-data" action="chart/invoice_action.php">
                    <input type='hidden' name='id' value="<?=$id?>">
                    <input type='hidden' name='noinvoice' value="<?php echo $rows -> noinvoice; ?>">
                <div class="">
                        <label class="" for="foto">Belum Upload</label>
                        <div class="">
                            <input type="file" name='foto'>
                        </div>
                    </div>

                    <div class="">
                        <div class="">
                            <button type="submit" class="btn-xs btn-success" name='aksi' value='<?=$aksi?>'>
                            <?=$aksi?>
                            </button>
                        </div>
                    </div>

                </form>

            <?php }else{ ?>
                <form  class="form-horizontal" method="POST"  enctype="multipart/form-data" action="chart/invoice_action.php">
                    <input type='hidden' name='id' value="<?=$id?>">
                    <input type='hidden' name='noinvoice' value="<?php echo $rows -> noinvoice; ?>">

                    <img src='upload/buktitransfer/<?php echo $rows ->buktitf ?> 'width='128px' height='128px' alt="" >
                <div class="">
                        <label class="" for="foto"><?php echo $rows ->buktitf ?></label>
                        <div class="">
                            <input type="file" name='foto'>
                        </div>
                    </div>

                    <div class="">
                        <div class="">
                            <button type="submit" class="btn-xs btn-success" name='aksi' value='<?=$aksi?>'>
                            Edit
                            </button>
                        </div>
                    </div>

                </form>

            <?php } ?>
                </td>


                <?php

                if ($rows->transfer==1) {

                $query="SELECT noinvoice from invoice where idpelanggan='$id'";
                $result=mysql_query($query) or die(mysql_error());
                $noinvoice=mysql_fetch_object($result);
                //while($rows=mysql_fetch_object($noinvoice)){
                    $query2="SELECT * FROM transaksi INNER JOIN produk ON transaksi.idproduk=produk.idproduk WHERE noinvoice='$noinvoice->noinvoice'";
                        $result2=mysql_query($query2) or die(mysql_error());
                        $rows=mysql_fetch_object($result2)
                            ?>
                            <td>
                                <a href= <?php echo $rows->link ?> >Downlad</a>
                            </td>
                            <?php

                //}
                ?>


                <?php


            }else{?>

                <td>
                    <span>Anda Harus Melunasi Pembayaran</span>
                </td>

             <?php } ?>



            </tr>
            <?php $no++;
                }
            ?>


        </tbody>
    </table>


</div>


<?php
include('inc/sidebar-front.php');
?>
    </div>
</section>