tahun-bulan

<?php
include_once "../library/inc.sesadmin.php";
include_once "../library/inc.library.php";
# Tahun Terpilih
$dataTahun = isset($_POST['cmbTahun']) ? $_POST['cmbTahun'] : date('Y');
$dataBulan = isset($_POST['cmbBulan']) ? $_POST['cmbBulan'] : date('m');
?>
<h1 align="center"><b>KONFIRMASI TRANSFER</b></h1>
<form method="post" name="form1" target="_self">
  <table width="430" border="0"  class="table-list">
    <tr>
      <th colspan="3" bgcolor="#33CCFF">FILTER DATA</th>
    </tr>
    <tr>
      <th width="121">Bulan Konfirmasi</th>
      <th width="5">:</th>
      <th width="290">
        <select name="cmbBulan">
        <?php
        // Daftar nama bulan
        $listBulan = array("01 - Januari","02 - Februari","03 - Maret",
                           "04 - April","05 - Mei","06 - Juni", "07 - Juli",
                           "08 - Agustus","09 September","10 - Oktober",
                           "11 - November","12 - Desember");
        // Menampilkan bulan ke Combo (listMenu)
        foreach($listBulan as $n=>$bulan) {
           echo "<option value='".($n+1)."' ".($n==$dataBulan?' selected':'').">$bulan</option>";
        }
        ?>
        </select>
        <select name="cmbTahun">
        <?php
        # Baca tahun terendah(awal) di tabel Transaksi
        $thnSql = "SELECT MIN(YEAR(tanggal)) As tahun FROM konfirmasi";
        $thnQry = mysql_query($thnSql, $koneksidb) or die ("Error".mysql_error());
        $thnRow = mysql_fetch_array($thnQry);
        // Menampilkan Tahun ke Combo (ListMenu)
        for($thn= $thnRow['tahun']; $thn <= date('Y'); $thn++)
           echo "<option value='$thn' ".($thn == $dataTahun?' selected':''.">$thn</option>";
        ?>
        </select>
        <input name="btnTampil" type="submit" value=" Tampilkan " />
      </th>
    </tr>
  </table>
</form>

<table class="table-list" width="1000" border="0" cellspacing="1" cellpadding="2">
  <tr bgcolor="#CCCCCC">
    <th width="26" >No</th>
    <th width="94">No. Pesan </th>
    <th width="154">Nama Pelanggan </th>
    <th width="103">Rek Tujuan </th>
    <th width="116">Transfer (Rp)</th>
    <th width="231">Keterangan</th>
    <th width="90">Tanggal</th>
    <th>Tools</th>
  </tr>
  <?php
    $sql = "SELECT a.*, c.nm_pelanggan
            FROM konfirmasi a
            LEFT JOIN pemesanan b ON b.no_pemesanan=a.no_pemesanan
            LEFT JOIN pelanggan c ON b.kd_pelanggan=c.kd_pelanggan
            WHERE YEAR(a.tanggal)='$dataBulan' AND MONTH(a.tanggal)='dataTahun'
            ORDER BY a.no_pemesanan DESC";
    $result = mysql_query($sql, $koneksidb)  or die ("Query Konfirmasi salah : ".mysql_error());
    $nomor  = 0;
    while ($data = mysql_fetch_array($result)) {
      $Kode = $data['id'];
      $NoPesan = $data['no_pemesanan'];
  ?>
  <tr align="center" bgcolor="<?php echo $nomor%2==0?'#fff':'#f5f5f5'; ?>">
    <td><?php echo ++$nomor; ?></td>
    <td><?php echo $data['no_pemesanan']; ?></td>
    <td><?php echo $data['nm_pelanggan']; ?></td>
    <td><?php echo $data['rek_tujuan']; ?></td>
    <td><?php echo format_angka($data['jum_transfer']); ?></td>
    <td><?php echo $data['keterangan']; ?></td>
    <td><?php echo IndonesiaTgl($data['tanggal']); ?></td>
    <td width="45">
    <a href="?open=Konfirmasi-Delete&Kode=<?php echo $Kode; ?>"
       target="_self"
       alt="Delete Data"
       onclick="return confirm('ANDA YAKIN AKAN MENGHAPUS DATA KONFIRMASI INI ... ?')">
      Delete
    </a>
    </td>
    <td width="45"><a href="?open=Pemesanan-Lihat&Kode=<?php echo $NoPesan; ?>" target="_blank">Lihat</a></td>
    <td width="45"><a href="?open=Bukti-Konfirmasi&amp;Kode=<?php echo $Kode; ?>" target="_blank">Detail</a></td>
  </tr>
  <?php } ?>
</table>