sandi123
-
Posts
6 -
Joined
-
Last visited
Posts posted by sandi123
-
-
<?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'];
?>
-
17 hours ago, ginerjm said:
Can you point to the line that the message is mentioning?
And what does "$qty = $qty" do for you?
$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'");
-
8 hours ago, maxxd said:
Is there a question here?
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
-
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>
';
}
}
how to add date format to export pdf in datatables
in Javascript Help
Posted
<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>