<?php
session_start();
if(!isset($_SESSION['user']) &&!isset($_SESSION['level'])){
    header("location:login.php");
}else{
    if($_SESSION['level'] != 2){
        header("location:index.php");
    }
    else{

function convert_day($cur_day){
    switch($cur_day){case "Monday":$day = "Senin";break;case "Tuesday":$day = "Selasa";break;case "Wednesday":$day = "Rabu";break;case "Thursday":$day = "Kamis";break;case "Friday":$day = "Jum'at";break;case "Saturday":$day = "Sabtu";break;case "Sunday":$day = "Minggu";break;}return $day;}
function convert_month($cur_month){
    switch($cur_month){case "01":$month = "Januari";break;case "02":$month = "Februari";break;case "03":$month = "Maret";break;case "04":$month = "April";break;case "05":$month = "Mei";break;case "06":$month = "Juni";break;case "07":$month = "Juli";break;case "08":$month = "Agustus";break;case "09":$month = "September";break;case "10":$month = "Oktober";break;case "11":$month = "November";break;case "12":$month = "Desember";break;}return $month;}

?>
<?php include '../koneksi.php';?>
<title>Admin</title>
<script src="../assets/js/jquery.js"></script>
<script src="../assets/js/bootstrap.js" ></script>
<link rel="stylesheet" href="../assets/css/bootstrap.css"/>
<link rel="stylesheet" href="../assets/css/style.css"/>
<script>
function angka(){
var an=document.getElementById('an');
if(isNaN(an.value)){ alert('Harus Angka');
window.location='index.php';
}
}
</script>

<div class="navbar navbar-inverse navbar-fixed-top" role="navigation">
      <div class="container">
        <div class="navbar-header">
          <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>
          <a class="navbar-brand" href="#"  style="color: white;"><i class="glyphicon glyphicon-phone"> </i> Alyu Store Online</a>
        </div>
        <div class="navbar-collapse collapse">
          <ul class="nav navbar-nav" >
            <li><a href="index.php"  style="color: white;">Home</a></li>
            <li><a href="hasil.php" style="color: white;">Penjualan</a></li>
            <li><a href="aktivitas.php" style="color: white;">Aktivitas</a></li>
            <li><a href="../" style="color: white;">Halaman Utama</a></li>
          </ul>
          <ul class="nav navbar-nav navbar-right">
            <form class="navbar-form navbar-left" role="search" ">
                <div class="form-group">
                    <a href="../proses/logout.php" class="btn btn-danger"  style="margin-left: 3px;"> Logout</a>
                   </form></div>
             </form>
          </ul>
        </div><!--/.nav-collapse -->
      </div>
    </div>
<div class="container" style="margin-top: 70px; " >


<?php
include "../koneksi.php";
?>
<table class="table table-bordered table-striped" style="font-size: 12px;">
<tr><th style="width: 50px;">No</th><th style="width: 200px;">Kode Pembelian</th><th>Nama Pembeli</th><th style="width: 90px;">Jumlah Beli</th><th>Nama Barang</th><th style="width: 250px;">Waktu Pembelian</th></tr>
<?php $i=1;
$query=mysql_query("select distinct kode, nama from penjualan ORDER BY waktu DESC");
while($data=mysql_fetch_array($query)){?>
    <tr><td valign='top' style="margin-bottom: 10px;"><?php echo $i;?></td valign='top'><td valign='top'><?php echo $data['kode'];?></td><td valign='top'><?php echo $data['nama'];?></td><td valign='top'>
    <?php
    $qjumlah=mysql_query("select sum(jumlah) as jumlah from penjualan where kode='$data[kode]'");
    while($djumlah=mysql_fetch_array($qjumlah)){
        echo $djumlah['jumlah'];
    }
    ?>

    </td><td>
    <?php
    $qbarang=mysql_query("select barang from penjualan where kode='$data[kode]'");
    while($dbarang=mysql_fetch_array($qbarang)){
        echo "~ ".$dbarang['barang']."<br />";
    }
    ?>

    </td><td valign='top'>
    <?php
    $qwaktu=mysql_query("select waktu from penjualan where kode='$data[kode]' limit 1");
    while($dwaktu=mysql_fetch_array($qwaktu)){

    $datetime = explode(" ", $dwaktu['waktu']);
    $get_day = date("l", strtotime($datetime[0]));
    $day = convert_day($get_day);
    $semua=date("m", strtotime($datetime[0]));
    if($semua==01){ $bln="Januari";}else if($semua==02){ $bln="Februari";}else if($semua==03){$bln="Maret";}else if($semua==04){$bln="April";}else if($semua==05){$bln="Mei";}else if($semua==06){$bln="Juni";}else if($semua==07){$bln="Juli";}else if($semua==08){$bln="Agustus";}else if($semua==09){$bln="September";}else if($semua==10){$bln="Oktober";}else if($semua==11){$bln="November";}else{$bln="Desember";}

echo "$day ,  ".date("d", strtotime($datetime[0]))." $bln ".date("Y", strtotime($datetime[0]))." Pukul ".$datetime[1]?></i>




    </td></tr>
    <?php $i++; }} ?>
</table>
</div>
<?php  } }?>