nextjs-cleo-minimarket/old-source/ajaxsatuanbrg.php

<?php
	session_start();
	if($_SESSION['validUser'] !== TRUE)
	{
		header("location: ./index.php");
		exit();
	}
?>
<?php

if(isset($_REQUEST['status']) && $_REQUEST['status'] == 'ok') {
	if ($_REQUEST['operation'] == 'carisatuanbrg') {		
		cari_satuanbrg($_REQUEST['txtcari']);
	} elseif ($_REQUEST['operation'] == 'ambilsatuanbrg') {		
		ambil_satuanbrg($_REQUEST['id_satuanbrg']);
	} elseif ($_REQUEST['operation'] == 'transaksisatuanbrg') {
		transaksi_satuanbrg($_REQUEST['kodesatuanbrg']);
	} elseif ($_REQUEST['operation'] == 'hapussatuanbrg') {
		hapus_satuanbrg($_REQUEST['id_satuanbrg']);
	}
}

function hapus_satuanbrg($id_satuanbrg){
	if ($id_satuanbrg != "") {
		$array_data = array();
		require_once 'db_login.inc.php';
		$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);		
		$query 	= "DELETE FROM satuan_barang WHERE idSatuanBarang = '".$id_satuanbrg."' LIMIT 1"; 
		$stmt 	= $mysqli->prepare($query);
		$stmt->execute();
		if($stmt->affected_rows > 0) {
			$array_data[0] = 1;
		} else {
			$array_data[0] = 0;
		}
		$stmt->close();
		/* tutup koneksi */
		$mysqli->close();
		/* cetak hasil */
		//echo count($array_data);
		echo json_encode($array_data);
	}	
}

function cari_satuanbrg($nama) {
  	$harray = array();
		require_once 'db_login.inc.php';
		$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);
		$nama = addslashes($nama);
		$data = $mysqli->query("SELECT * FROM satuan_barang WHERE namaSatuanBarang LIKE '%".$nama."%' ORDER BY idSatuanBarang");		
		if($data->num_rows > 0) {
			$idx = 0;
			while($a = $data->fetch_array(MYSQLI_ASSOC)) {
				$harray[$idx] = array(
					'idSatuanBarang' => stripcslashes($a['idSatuanBarang']),
          'namaSatuanBarang' => $a['namaSatuanBarang']
				);
				$idx++;
			}
			/* tutup hasil query */
			$data->close();
		}
		/* tutup koneksi */
		$mysqli->close();
		/* cetak hasil */
		echo json_encode($harray);
}

function ambil_satuanbrg($id_satuanbrg) {
	if ($id_satuanbrg != "") {
		$array_data = array();
		require_once 'db_login.inc.php';
		$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);
		$data = $mysqli->query("SELECT * FROM satuan_barang WHERE idSatuanBarang = '".$id_satuanbrg."' ORDER BY idSatuanBarang");		
		if($data->num_rows > 0) {
			$idx = 0;
			while($a = $data->fetch_array(MYSQLI_ASSOC)) {	
				$array_data[$idx] = array(
					'idSatuanBarang' => stripcslashes($a['idSatuanBarang']),
          'namaSatuanBarang' => $a['namaSatuanBarang']
				);
				$idx++;
			}
			/* tutup hasil query */
			$data->close();
		}
		/* tutup koneksi */
		$mysqli->close();
		/* cetak hasil */
		echo json_encode($array_data);
	}
}



function transaksi_satuanbrg($id_satuanbrg) {
		require_once 'db_login.inc.php';
		$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);
		$data = $mysqli->query("SELECT * FROM satuan_barang WHERE idSatuanBarang = '".$id_satuanbrg."'");		
		if($data->num_rows > 0) {
			/* tutup hasil query */
			$data->close();
			/* tutup koneksi */
			$mysqli->close();
			/* update data satuanbrg */
			update_satuanbrg();
		} else {
			/* tutup hasil query */
			$data->close();
			/* tutup koneksi */
			$mysqli->close();
			/* simpan data satuanbrg baru */
			simpan_satuanbrg();
		}
}

function update_satuanbrg(){
	if(isset($_POST)) {
		$idSatuanBarang = $_POST['kodesatuanbrg'];
		$nama = $_POST['nama'];

		$array_data = array();
		require_once 'db_login.inc.php';
		$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);		
		$query 	= "UPDATE satuan_barang SET "; 
		$query	.= "namaSatuanBarang = ? ";
		$query	.= "WHERE idSatuanBarang = ? ";		
		
		$stmt 	= $mysqli->prepare($query);
		$stmt->bind_param("si", $nama, $idSatuanBarang);
		$stmt->execute();
		if($stmt->affected_rows > 0) {
			$array_data[0] = 1;
		} else {
			$array_data[0] = 0;
		}
		$stmt->close();
		/* tutup koneksi */
		$mysqli->close();
		/* cetak hasil */
		//echo count($array_data);
		echo json_encode($array_data);
	}	
}

function simpan_satuanbrg() {
		$idSatuanBarang = $_POST['kodesatuanbrg'];
		$nama = $_POST['nama'];

		$array_data = array();
		require_once 'db_login.inc.php';
		$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE);		
		$query 	= "INSERT INTO satuan_barang(namaSatuanBarang) VALUES ('$nama')";
		$stmt 	= $mysqli->prepare($query);
		$stmt->execute();
		if($stmt->affected_rows > 0) {
			$array_data[0] = 1;
		} else {
			$array_data[0] = 0;
		}
		$stmt->close();
		/* tutup koneksi */
		$mysqli->close();
		/* cetak hasil */
		//echo count($array_data);
		echo json_encode($array_data);
}
?>