[how to add date format to export pdf in datatables]

<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>

[how to resolve errors like this in php 8 Warning: Trying to access array offset on value of type null in C:\xampp\htdocs\AplikasiInventaris\admin\detailpinjam.php on line 7 Warning: Trying to access array offset on value of type null in C:\xampp\htdocs\A]

<?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'];

?>

[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]

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'");

[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]

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

[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>

        ';

    }

}