Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include"connect.php";
- session_start();
- //error_reporting(0);
- if ($_SESSION['akses'] == "user"){
- ?>
- <html>
- <head>
- <link rel="stylesheet" href="assets/css/bootstrap.min.css" type="text/css" />
- <link rel="stylesheet" href="style.css" type="text/css" />
- <script type="text/javascript" src="assets/js/jquery.min.js"></script>
- <script type="text/javascript" src="assets/js/jquery.formautofill.min.js"></script>
- <script src="assets/js/jquery.min.js"></script>
- <script src="assets/js/bootstrap.min.js"></script>
- <script src="script.js"></script>
- <title>Tambah Jurnal Harian</title>
- </head>
- <body>
- <?php include"menu_user.php"; ?>
- <div class="container">
- <Center><h2>Tambah Jurnal Harian</h2></Center><hr><hr>
- <form class="form-horizontal" method="GET">
- <div class="form-group">
- <label for="no" class="col-md-2 control-label">Bukti</label>
- <div class="col-md-10">
- <input type="text" class="form-control id" id="no" name="bukti" placeholder="Masukkan No Bukti" required/>
- </div>
- </div>
- <div class="form-group">
- <label for="tgl" class="col-md-2 control-label">Tanggal</label>
- <div class="col-md-10">
- <input type="date" class="form-control" id="tgl" name="tanggal" required/>
- </div>
- </div>
- <div class="form-group">
- <label for="uraian" class="col-md-2 control-label">Uraian</label>
- <div class="col-md-10">
- <input type="text" class="form-control " id="uraian" name="uraian" placeholder="Masukkan Uraian " required/>
- </div>
- </div>
- <div class="form-group">
- <label for="stn" class="col-md-2 control-label">Satuan</label>
- <div class="col-md-10">
- <input type="text" class="form-control small" id="stn" name="stn" placeholder="Masukkan Satuan" required/>
- </div>
- </div>
- <div class="form-group">
- <label for="debet" class="col-md-2 control-label">Akun Debet</label>
- <div class="col-md-3">
- <select class="form-control aa " id = "debet" disabled>
- <?php
- $sql_akun = mysqli_query($db_link,"select * from akun order by akun;");
- ?>
- <option value="">-Pilih Akun-</option>
- <?php
- while($data = mysqli_fetch_array($sql_akun)){
- ?>
- <option value="<?php echo $data['akun'];?>"><?php echo $data['akun'];?></option>
- <?php } ?>
- </select>
- </div>
- <div class="col-md-4">
- <select class="form-control aa" name="akund" id="dropdown_selector" required/>
- <?php
- $sql_akun = mysqli_query($db_link,"select * from akun order by akun;");
- ?>
- <option value="">- Rek -</option>
- <?php
- while($data = mysqli_fetch_array($sql_akun)){
- ?>
- <option value="<?php echo $data['akun'];?>"><?php echo $data['nama_rekening'];?></option>
- <?php } ?>
- </select>
- </div>
- </div>
- <div class="form-group">
- <label for="kredit" class="col-md-2 control-label">Akun Kredit</label>
- <div class="col-md-3">
- <select class="form-control aak " id = "kredit" disabled>
- <?php
- $sql_akun = mysqli_query($db_link,"select * from akun order by akun;");
- ?>
- <option value="">-Pilih Akun-</option>
- <?php
- while($data = mysqli_fetch_array($sql_akun)){
- ?>
- <option value="<?php echo $data['akun'];?>"><?php echo $data['akun'];?></option>
- <?php } ?>
- </select>
- </div>
- <div class="col-md-4">
- <select class="form-control aak" name="akunk" id="dropdown_sel" required/>
- <?php
- $sql_akun = mysqli_query($db_link,"select * from akun order by akun;");
- ?>
- <option value="">- Rek -</option>
- <?php
- while($data = mysqli_fetch_array($sql_akun)){
- ?>
- <option value="<?php echo $data['akun'];?>"><?php echo $data['nama_rekening'];?></option>
- <?php } ?>
- </select>
- </div>
- </div>
- <div class="form-group">
- <label for="saldo" class="col-md-2 control-label">Saldo</label>
- <div class="col-md-10">
- <input type="number" class="form-control id" id="saldo" name="saldo" placeholder="Masukkan saldo" required/>
- </div>
- </div>
- <div class="form-group">
- <div class="col-md-offset-2 col-md-10">
- <button class="btn btn-primary" type="submit" name="submit">Save</button>
- <button type="reset" class="btn btn-default">Reset</button>
- </div>
- </div>
- </form>
- <?php
- if(isset($_GET['submit'])){
- $bukti = $_GET['bukti'];
- $tanggal = $_GET['tanggal'];
- $uraian = $_GET['uraian'];
- $akund = $_GET['akund'];
- $saldo = $_GET['saldo'];
- $akunk = $_GET['akunk'];
- $sql1 = "insert into jurnal_harian(no_bukti,tanggal,uraian,akun,debet) values ('$bukti','$tanggal','$uraian','$akund','$saldo');";
- $sql2= "insert into jurnal_harian(no_bukti,tanggal,uraian,akun,kredit) values ('$bukti','$tanggal','$uraian','$akunk','$saldo');";
- $query1=mysqli_query($db_link,$sql1)or die(mysqli_error($db_link));
- $query2=mysqli_query($db_link,$sql2)or die(mysqli_error($db_link));
- //$sql = $sql1.$sql2;
- //$query=mysqli_multi_query($db_link,$sql)or die(mysqli_error($db_link));
- if($query1==TRUE and $query2==TRUE){
- //echo $bukti."<br>";
- //echo $tanggal."<br>";
- //echo $uraian."<br>";
- //echo $akund."<br>";
- //echo $saldo."<br>";
- //echo $akunk."<br>";
- $sql2= mysqli_query($db_link,"select * from jurnal_harian where no_bukti='$bukti' ")or die(mysqli_error($db_link));
- $row=mysqli_fetch_all($sql2);
- $count=count($row);
- //table yg ditampilkan
- ?>
- <div class="table-responsive">
- <table class="table table-bordered">
- <thead>
- <tr>
- <th>Nomor Bukti</th>
- <th>Tanggal</th>
- <th>Uraian</th>
- <th>Akun</th>
- <th>Debet</th>
- <th>Kredit</th>
- <th>AKSI</th>
- </tr>
- </thead>
- <tbody>
- <?php
- for($i=0;$i<$count;$i++){ ?>
- <tr>
- <td><?php echo $row[$i][1]?></td>
- <td><?php echo $row[$i][2]?></td>
- <td><?php echo $row[$i][3]?></td>
- <td><?php echo $row[$i][4]?></td>
- <td><?php echo $row[$i][5]?></td>
- <td><?php echo $row[$i][6]?></td>
- <td class="mid"><a href="u_j_harian_update.php?kode=<?php echo $row[$i][0]; ?>" title="Edit "><span class="glyphicon glyphicon-edit"></span></a>
- </td>
- </tr>
- <?php }
- ?>
- </tbody>
- </table>
- </div>
- <?php //echo '<script language="javascript">alert("Berhasil Disimpan^^"); document.location="u_j_harian.php";</script>'; */
- }
- else{
- echo '<script language="javascript">alert("Gagal Disimpan^^"); document.location="u_j_harian.php";</script>';}
- }
- ?>
- </div>
- </body>
- </html>
- <?php
- } else {
- header('location:index.php');
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement