action.php

<?php
include "../../config/koneksi.php";
include "../../function/function.php";

if(isset($_POST['action'])){
    if($_POST['action']=="insert"){
        $tanggal=ubahTanggal($_POST['tanggal']);
        $keterangan="Pembelian";
        $idbeli=$uuid;
        $idjurnal=$uuid;


        if(isset($_POST['idbarang']) && is_array($_POST['idbarang'])){
            $idbarang=implode(",", $_POST["idbarang"]);
        }
        if(isset($_POST['unit']) && is_array($_POST['unit'])){
            $unit=implode(",", $_POST["unit"]);
        }
        if(isset($_POST['harga']) && is_array($_POST['harga'])){
            $harga=implode(",", $_POST["harga"]);
        }

        $beli="insert into beli values('$idbeli','".$_POST['kdtransaksi']."','$tanggal','".$_POST['namasupp']."','$keterangan','$idbarang','$unit','$harga',".$_POST['total']."','".$_POST['bayar']."')";
        $statementbeli=$dbh->prepare($beli);
        $statementbeli->execute();

        echo 'All data inserted...';

    }
    if($_POST['action']=='fetch_single'){
        $query="select*from beli where idbeli='".$_POST['id']."'";
        $statement=$dbh->prepare($query);
        $statement->execute();
        $result=$statement->fetchAll();
        foreach($result as $row){
            $tanggal=date("m/d/Y",strtotime($row['tanggal']));

            $output['kdtransaksi']=$row['kdtransaksi'];
            $output['tanggal']=$tanggal;
            $output['namasupp']=$row['idsupp'];
            $output['total']=$row['total'];
            $output['bayar']=$row['bayar'];

        }
        echo json_encode($output);
    }
    if($_POST['action']=='update'){
        $tanggal=ubahTanggal($_POST['tanggal']);
        $keterangan="Pembelian";
        $query="update beli set kdtransaksi='".$_POST['kdtransaksi']."',
        tanggal='$tanggal',
        idsupp='".$_POST['namasupp']."',
        keterangan='$keterangan',
        total='".$_POST['total']."',
        bayar='".$_POST['bayar']."'
        where idbeli='".$_POST['hidden_id']."'
        ";
        $statement=$dbh->prepare($query);
        $statement->execute();
        echo '<p>Data updated</p>';
    }
    if($_POST['action']=='delete'){
        $query="delete from beli where idbeli='".$_POST["id"]."'";
        $statement=$dbh->prepare($query);
        $statement->execute();
        echo '<p>Data deleted</p>';
    }
}
?>