Untitled

<?php
session_start();
if(isset($_POST) && !empty(($_POST))){

	//inlcude atau memasukkan file koneksi ke database
	include('database.php');


	$nama		= $_POST['name'];
	$email		= $_POST['email'];
	$phone		= $_POST['phone'];
	$nokwitansi	= $_POST['barang'];
	$tglkwitansi = $_POST['tgl'];
	$terima		= $_POST['terima'];
	$jumlah		= $_POST['jumlah'];
	$terbilang	= $_POST['huruf'];
	$carabayar	= $_POST['services'];
	$keterangan	= $_POST['keterangan'];

	//melakukan query dengan perintah INSERT INTO untuk memasukkan data ke database
	$input = mysqli_query($koneksi,"INSERT INTO jual VALUES(NULL, '".$nama."', '".$email."', '".$phone."', '".$nokwitansi."', '".$tglkwitansi."', '".$terima."', '".$jumlah."', '".$terbilang."','".$carabayar."', '".$keterangan."' )") or die(mysql_error());
	$id = mysqli_insert_id($koneksi);
	mysqli_close($koneksi);
	header('location: kwitansi.php?id='.$id);

}else{

	//redirect atau dikembalikan ke halaman tambah
}
?>
<!DOCTYPE html>
<html>
<head>
<link rel="shortcut icon" href="images/favicon.ico" type="image/ico">
<link rel="stylesheet" href="css/style.css" type="text/css">
<link rel="stylesheet" href="JS/jquery-ui.css" type="text/css"/>
<script src="JS/jquery.js" type="text/javascript"></script>
<script src="JS/jquery-ui.js" type="text/javascript"></script>
<?php
if ($_SESSION['justloggedin'] = true); {
   echo "<script>alert('Welcome Admin!')</script>";
   $_SESSION['justloggedin'] = false;
}
?>
<script>
  $(function() {
    $( "#datepicker" ).datepicker();
  });
</script>

<script>
	$(document).ready(function(){
		$(".dor").hide();
		$(".ding").hide();
		$(".deng").hide();
        $("#dor").click(function(){
            $(".index").hide("slow", function(){
				$(".deng").hide("slow", function(){
					$(".ding").hide("slow", function(){
						$(".dor").show('slow');
					});
				});
            });
        });
        $("#index").click(function(){
            $(".dor").hide("slow", function(){
				$(".ding").hide("slow", function(){
					$(".deng").hide("slow", function(){
						$(".index").show('slow');
					});
				});
            });
        });
		$("#ding").click(function(){
			$(".dor").hide("slow", function(){
				$(".index").hide("slow", function(){
					$(".deng").hide("slow", function(){
						$(".ding").show('slow');
					});
				});
			});
		});
		$("#deng").click(function(){
			$(".dor").hide("slow", function(){
				$(".index").hide("slow", function(){
					$(".ding").hide("slow", function(){
						$(".deng").show('slow');
					});
				});
			});
		});
    });
</script>
<title> Testing web</title>
</head>
<body>
    <div id="isi">
        <header>
            <!--<h1><span class="gold">ODB</span> Testing Web</h1>
            <h2>OurDailyBread.org  <span class="black-text"><a href="http://www.ourdailybread.org" target="blank">GO</a></span></h2>-->
        </header>

        <nav id="menu">
            <ul>
                <li><a id="index" href="#" >Dashboard</a></li>
                <!-- <li><a href="about.html">About Us</a></li> -->
            <!-- <li><a href="contact.php">Make a Receipt</a></li> -->
               <!-- <li><button id="index">index</button></li>-->
                <li><a id="dor" href="#">Transaction</a></li>
				<!--<li><a id="ding" href="#">History</a></li>-->
			 <div class="dropdown">
  <button onclick="myFunction()" class="dropbtn"><b>Record</b></button>
  <div id="myDropdown" class="dropdown-content">
    <a id="ding" href="#">Payment Record</a>
    <a id="deng" href="#">Member Record</a>
  </div>
</div>
				<li style="float:right; padding-right:15px"><a href="logout.php">Logout</a></li>
            </ul>

			<script>
function myFunction() {
    document.getElementById("myDropdown").classList.toggle("show");
}
window.onclick = function(e) {
  if (!e.target.matches('.dropbtn')) {

    var dropdowns = document.getElementsByClassName("dropdown-content");
    for (var d = 0; d < dropdowns.length; d++) {
      var openDropdown = dropdowns[d];
      if (openDropdown.classList.contains('show')) {
        openDropdown.classList.remove('show');
      }
    }
  }
}
</script>

        </nav>

        <section class="index">
            <h2>Hi, <?php
					echo $_SESSION['username'];
						?></h2>
            <img class="float" src="images/ODB_logo.png" alt="logo">
            <h3>What web is this?</h3>
            <p>This site is build to ease the user, if you want to print the receipt online.</p>
            <h3>Our Story</h3>
            <p>It all started in 1938 with a small radio program called Detroit Bible Class. With his gravelly voice, Dr. M. R. DeHaan quickly captured the attention of listeners in the Detroit area, and eventually the nation. Since then, our audience has grown to millions of people around the world who use our Bible-based resources.</p>
		</section>
		<section class="index">
         <p><img src="images/wsk-logo-black.png" alt="wskamu">
			</p>
			<div class="wsk">
				<h4>Komunikasi yang Dimengerti</h4>
				<ul>
					<li><strong>Baca: </strong>Kisah Para Rasul</li>
					<li><b>Content: </b>2:1 Ketika tiba hari Pentakosta, semua orang percaya berkumpul di satu tempat </li>
				</ul>
				<a href="http://www.warungsatekamu.org/2016/06/komunikasi-yang-dimengerti/">View More</a>
		</div>

		<div class="wsk">
			<h4>Hari biasa bersama Allah</h4>
			<ul>
				<li><strong>Baca: </strong> Kejadian 12:1-4</li>
					<li><b>Content: </b>Mendengarkan kesaksian orang-orang tentang karya luar biasa yang Allah perbuat </li>
			</ul>
			<a href="http://www.warungsatekamu.org/2016/06/hari-hari-biasa-bersama-allah/">View More</a>
		</div>

		<div class="wsk">
			<h4>Ulangi perkataan saya</h4>
			<ul>
				<li><strong>Baca: </strong> Mazmur 141</li>
					<li><b>Content: </b>Ketika Rebecca berdiri di atas panggung untuk berbicara dalam sebuah konferensi, </li>
			</ul>
			<a href="http://www.warungsatekamu.org/2016/06/ulangi-perkataan-saya/">View More</a>
	    </div>

		<div class="wsk">
			<h4>Air mata dan tawa</h4>
			<ul>
				<li><strong>Baca: </strong>Ezra 3:7</li>
					<li><b>Content: </b>Tahun lalu di sebuah acara retret, saya bertemu dengan beberapa teman yang sudah </li>
			</ul>
			<a href="http://www.warungsatekamu.org/2016/06/air-mata-dan-tawa/">View More</a>
		</div>
        </section>

        <section class="dor">
		<img class="float" src="images/ODB_logo.png" alt="logo">
            <h3>Transaction</h3>
                <p>
            <p>Please Complete this form to make a receipt</p>
            <form method="post" target="_blank">
                <p>
                    <label for="name">Full Name:</label>
                    <input type="text" name="name" required/>
                </p>
                <p>
                    <label for="email">Email Address: </label>
                    <input type="email" name="email" required/>
                </p>
                <p>
                    <label for="phone">Phone Number: </label>
                    <input type="number" name="phone" max="999999999999999">
                </p>
                <p>

                <fieldset name="about">
                <legend><b>Form Kwitansi</b></legend>
                    <label for="barang">Receipt Number </label>
                    <input type="text" maxlength="10" name="barang" required/>
                </p>
                <p>
                    <label for="tgl">Date</label>
                    <input type="text" id="datepicker" name="tgl">


                </p>
                <p>
                    <label for="terima">Received From</label>
                    <input type="text" maxlength="35" name="terima" placeholder="Company name" required/>
                </p>
                <p>

                    <label for="budget">Amount</label>
                    <select name="uang">
                    <option value="1">IDR</option>
                    <option value="1">USD</option>
                    <option value="1">SGD</option>
                    <option value="1">EUR</option>
                </select>
                     <input type="text" maxlength="20" name="jumlah">

                </p>
                <p>
                    <label for="huruf">Spelled Out The Numbers</label>
                    <input type="text" maxlength="70" name="huruf">
                </p>

                <p>
                    <label for="call">Payment Method</label>
                    <table>
                        <tr>
                            <td><input type="radio" name="services" value="Cash">Cash</td>
                            <td><input type="radio" name="services" value="Cheque">Cheque</td>

                            <td><input type="radio" name="services" value="Bilyet giro">Bilyet giro</td>
                            <td><input type="radio" name="services" value="Bank transfer">Bank Transfer</td>
                        </tr>

                    </table>
                </p>


                <p>
                    <label style="float:left" for="keterangan">Description </label>
                    <textarea name="keterangan"> </textarea>
                </p>
                <input id="clear" type="reset" name="reset" value="clear">

                </fieldset>
                <p>
                    <input type="submit" onclick="return confirm('Are you sure?')" target="blank" value="Submit">

                </p>

            </form>
    </section>

	<section class="ding">
		<h3 style="text-align:center">Payment Record</h3>
			<table border="1px" cellpadding="2px" style="border-collapse:collapse; margin-top:10px">
				<tr style="background:grey">
					<th>ID</th>
					<th>Name</th>
					<th>Email</th>
					<th>Phone</th>
					<th>No.Receipt</th>
					<th>Date</th>
					<th>Received From</th>
					<th>Amount</th>
					<th>Payment</th>
					<th>Description</th>
					<th>Operation</th>
				</tr>

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpassword = '';
$dbname = 'dhd';
$koneksi = mysql_connect($dbhost,$dbuser,$dbpassword);
mysql_select_db($dbname,$koneksi);

  $sql = "SELECT * FROM jual";
  $lihatdata = mysql_query($sql);
  while ($data = mysql_fetch_array($lihatdata)) {
	$id = $data[0];
    echo '<tr>';
    echo '<td>'.$data[0].'</td>';
    echo '<td>'.$data['name'].'</td>';
    echo '<td>'.$data['email'].'</td>';
	echo '<td>'.$data['nomer'].'</td>';
	echo '<td>'.$data['nokw'].'</td>';
	echo '<td>'.$data['tglkw'].'</td>';
	echo '<td>'.$data['namapt'].'</td>';
	echo '<td>'.$data['jumlah'].'</td>';
	echo '<td>'.$data['bayar'].'</td>';
	echo '<td>'.$data['keterangan'].'</td>';
	echo "<td><a href = 'delete.php?id=$id' onclick=\"return confirm('Are you sure want to delete this?');\">DELETE</a></td>";
    echo '</tr>';
  }
echo '</table>';

mysql_close($koneksi);
?>

			</table>
	</section>

	</section>

	<section class="deng">
		<h3>Member Record</h3>
			<table border="1px" cellpadding="2px" style="border-collapse:collapse">
				<tr style="background:grey">
					<th>ID</th>
					<th>Name</th>
					<th>Username</th>
					<th>Operation</th>
				</tr>

			<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpassword = '';
$dbname = 'dhd';
$koneksi = mysql_connect($dbhost,$dbuser,$dbpassword);
mysql_select_db($dbname,$koneksi);

  $sql = "SELECT * FROM users WHERE username != 'admin'";
  $lihatdata = mysql_query($sql);
  while ($data = mysql_fetch_array($lihatdata)) {
	$id = $data[0];
    echo '<tr>';
    echo '<td>'.$data[0].'</td>';
    echo '<td>'.$data['nama'].'</td>';
    echo '<td>'.$data['username'].'</td>';
	echo "<td><a href = 'deleteuser.php?id=$id' onclick=\"return confirm('Are you sure want to delete this?');\">DELETE</a></td>";
    echo '</tr>';
  }
echo '</table>';

mysql_close($koneksi);
?>

			</table>
	</section>

    </div>
	<div style="clear;both"></div>
    <footer>
        Copyright 2016, Our Daily Bread Ministries
    </footer>
</body>
</html>