Mercurial > bms / file diff

--- a/www/includes/db_inventory_suppliers.php	Sun Jul 04 12:16:25 2021 +0200
+++ b/www/includes/db_inventory_suppliers.php	Sun Jul 04 14:25:52 2021 +0200
@@ -10,6 +10,11 @@
 }
 mysqli_set_charset($connect, "utf8" );
 
+$response = array(
+   'error' => false,
+   'msg' => 'Ok',
+);
+
 // get data and store in a json array
 $query = "SELECT * FROM inventory_suppliers ORDER BY name";
 if (isset($_POST['insert'])) {
@@ -27,10 +32,10 @@
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_inventory_suppliers: ".$sql." result: ".mysqli_error($connect));
-	//} else {
-	//	syslog(LOG_NOTICE, "db_inventory_suppliers: inserted ".$_POST['name']);
-	}
-	echo $result;
+                $response['error'] = true;
+                $response['msg'] = "SQL fout: ".mysqli_error($connect);
+        }
+	exit(json_encode($response));
 
 } else if (isset($_POST['update'])) {
 	// UPDATE COMMAND
@@ -47,22 +52,21 @@
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_inventory_suppliers: ".$sql." result: ".mysqli_error($connect));
-	//} else {
-	//	syslog(LOG_NOTICE, "db_inventory_suppliers: updated record ".$_POST['record']);
-	}
-	echo $result;
+                $response['error'] = true;
+                $response['msg'] = "SQL fout: ".mysqli_error($connect);
+        }
+	exit(json_encode($response));
 
 } else if (isset($_POST['delete'])) {
 	// DELETE COMMAND
-	// FIXME: need to check if the record is in use
 	$sql = "DELETE FROM `inventory_suppliers` WHERE record='".$_POST['record']."';";
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_inventory_suppliers: ".$sql." result: ".mysqli_error($connect));
-	} else {
-		syslog(LOG_NOTICE, "db_inventory_suppliers: deleted record ".$_POST['record']);
-	}
-	echo $result;
+                $response['error'] = true;
+                $response['msg'] = "SQL fout: ".mysqli_error($connect);
+        }
+        exit(json_encode($response));
 
 } else {
 	// SELECT COMMAND
@@ -82,6 +86,12 @@
 		);
 	}
 	header("Content-type: application/json");
-	echo json_encode($suppliers);
+	exit(json_encode($suppliers));
 }
+
+syslog(LOG_NOTICE, "db_inventory_suppliers: missing arguments");
+$response['error'] = true;
+$response['msg'] = "missing arguments";
+echo json_encode($response);
+
 ?>