Jump to content

sandi123

New Members
  • Posts

    6
  • Joined

  • Last visited

sandi123's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. <script> $(document).ready(function() { var printCounter = 0; // Append a caption to the table before the DataTables initialisation $('#example').append('<caption style="caption-side: bottom; text-align: right;">Sandi Dwi Januar, Padaherang 17 Januari</caption>'); $('#example').DataTable( { dom: 'Bfrtip', buttons: [ 'copy', { extend: 'excel', messageTop: 'The information in this table is copyright to Sirius Cybernetics Corp.', messageBottom: 'Sandi Dwi Januar' }, { extend: 'pdf', messageTop: 'The information in this table is copyright to Sirius Cybernetics Corp.', messageBottom: 'Sandi Dwi Januar' }, { extend: 'print', messageTop: function () { printCounter++; if ( printCounter === 1 ) { return 'Penanggung Jawab: Sandi Dwi Januar'; } else { return 'You have printed this document '+printCounter+' times'; } }, messageBottom: '<h6 style="margin-left: 850;">Sandi Dwi Januar</h6> <br><br> <h6 style="margin-left: 850px;">Padaherang, 20 Januari 2022</h6>' } ] } ); } ); </script>
  2. <?php require '../function.php'; $id_peminjaman = $_GET['id']; $get = mysqli_query($con,"SELECT * FROM peminjaman WHERE id_peminjaman='$id_peminjaman'"); $fetch = mysqli_fetch_array($get); $nama_pegawai = $fetch['nama_pegawai']; $tanggal_pinjam = $fetch['tanggal_pinjam']; $tanggal_kembali = $fetch['tanggal_kembali']; ?>
  3. $query = "SELECT * FROM barang_masuk WHERE barang_masuk.id_masuk = '$id_masuk' "; $sql_pm = mysqli_query($con, $query) or die (mysqli_error($con)); $data = mysqli_fetch_array($sql_pm); Line 184. $stok_awal = $data['qty'] ?? 0; Line 186. $stok = ($stok_awal - $data['qty']) + $qty; $queryz = mysqli_query($con, "UPDATE barang_masuk SET qty='$qty' WHERE id_masuk ='$id_masuk'"); $query5 = mysqli_query($con, "UPDATE data_barang SET stock = '$stock' WHERE data_barang.id_data_barang = '$id_data_barang'");
  4. This is my question help please Warning: Trying to access array offset on value of type null in C:\xampp\htdocs\AplikasiInventaris\function.php on line 186 Fatal error: Uncaught TypeError: Unsupported operand types: int + string in C:\xampp\htdocs\AplikasiInventaris\function.php:186 St
  5. if(isset($_POST['masuk'])){ $id_data_barang = $_POST['id_data_barang']; $nama_barang = $_POST['nama_barang']; $qty = $_POST['qty']; $tanggal_masuk = $_POST['tanggal_masuk']; $nama_toko_barang = $_POST['nama_toko_barang']; $nama_pegawai = $_POST['nama_pegawai']; $query = mysqli_query($con,"INSERT INTO barang_masuk (id_data_barang, nama_barang, qty, tanggal_masuk, nama_toko_barang, nama_pegawai) values ('$id_data_barang','$nama_barang','$qty','$tanggal_masuk','$nama_toko_barang','$nama_pegawai')"); $query2 = mysqli_query($con, "SELECT * FROM data_barang WHERE data_barang.id_data_barang = '$id_data_barang'"); $data = mysqli_fetch_array($query2); $stok_awal = $data['stock']; $stok_akhir1 = $stok_awal + $qty ; $qty = $qty; $query3 = mysqli_query($con, "UPDATE data_barang SET stock = '$stok_akhir1' WHERE data_barang.id_data_barang = '$id_data_barang' "); if($query){ header('location:barang_masuk.php'); } else { echo ' <script>alert("Gagal Menambahkan"); window.location.href=barang_masuk.php </script> '; } } else if(isset($_POST['editbarangmasuk'])) { // EDIT DATA PEMBELIAN $id_masuk = $_POST['id_masuk']; $id_data_barang = $_POST['id_data_barang']; $qty = $_POST['qty']; // TRIGGER EDIT STOK BARANG $query2 = mysqli_query($con, "SELECT * FROM data_barang WHERE data_barang.id_data_barang = '$id_data_barang'"); $data = mysqli_fetch_array($query2); $stok_awal = $data['stock'] ?? 0; // $stok_akhir1 = $stok_awal + $jumlah_pembelian; $query = "SELECT * FROM barang_masuk WHERE barang_masuk.id_masuk = '$id_masuk' "; $sql_pm = mysqli_query($con, $query) or die (mysqli_error($con)); $data = mysqli_fetch_array($sql_pm); $stok_awal = $data['qty'] ?? 0; $stok = ($stok_awal - $data['qty']) + $qty; $queryz = mysqli_query($con, "UPDATE barang_masuk SET qty='$qty' WHERE id_masuk ='$id_masuk'"); $query5 = mysqli_query($con, "UPDATE data_barang SET stock = '$stock' WHERE data_barang.id_data_barang = '$id_data_barang'"); // END TRIGGER EDIT STOK BARANG if($queryz){ // BERPINDAH HALAMAN header('location:barang_masuk.php'); } else { echo ' <script>alert("Gagal Update"); window.location.href=barang_masuk.php </script> '; } }
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.