Mercurial > bms / changeset

--- a/www/includes/db_product.php	Sun Jun 27 10:15:09 2021 +0200
+++ b/www/includes/db_product.php	Sun Jun 27 11:12:24 2021 +0200
@@ -16,6 +16,11 @@
 $rreplacements = array("\\'");
 $disallowed = array('visibleindex','uniqueid','boundindex','uid','h_weight','m_weight');
 
+$response = array(
+   'error' => false,
+   'msg' => 'Ok',
+);
+
 if (isset($_POST['insert']) || isset($_POST['update'])) {
 	if (isset($_POST['insert'])) {
 		$sql  = "INSERT INTO `products` SET ";
@@ -522,7 +527,9 @@
 
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
-			syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect));
+		syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect));
+		$response['error'] = true;
+		$response['msg'] = "SQL fout: ".mysqli_error($link);
 	} else {
 		if (isset($_POST['update'])) {
 			//syslog(LOG_NOTICE, "db_product: updated record ".$_POST['record']);
@@ -532,7 +539,7 @@
 			//syslog(LOG_NOTICE, "db_product: inserted record ".$lastid);
 		}
 	}
-	echo $result;
+	echo json_encode($response);
 
 } else if (isset($_POST['splitit'])) {
 	/*
@@ -548,10 +555,12 @@
 	$result = mysqli_query($connect, $sql);
         if (! $result) {
 		syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect));
+		$response['error'] = true;
+                $response['msg'] = "SQL update fout: ".mysqli_error($link);
         } else {
                 syslog(LOG_NOTICE, "db_product: updated (divide) record ".$_POST['record']);
-        }
-        echo $result;
+	}
+	echo json_encode($response);
 
 } else if (isset($_POST['delete'])) {
 	/*
@@ -561,10 +570,12 @@
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_product: ".$sql." result: ".mysqli_error($connect));
+		$response['error'] = true;
+                $response['msg'] = "SQL delete fout: ".mysqli_error($link);
 	} else {
 		syslog(LOG_NOTICE, "db_product: deleted product uuid ".$_POST['uuid']);
 	}
-	echo $result;
+	echo json_encode($response);
 
 } else {
 	/*

--- a/www/js/prod_edit.js	Sun Jun 27 10:15:09 2021 +0200
+++ b/www/js/prod_edit.js	Sun Jun 27 11:12:24 2021 +0200
@@ -4882,8 +4882,13 @@
    data: data,
    async: false,
    type: 'POST',
-   success: function(data, status, xhr) {
-    console.log('saveRecord(' + goback + ') success');
+   success: function(data) {
+    if (data.error) {
+     console.log('saveRecord(' + goback + ') error ' + data.msg);
+     alert('SQL fout: ' + data.msg);
+    } else {
+     console.log('saveRecord(' + goback + ') success');
+    }
     if (goback)
      window.location.href = my_return;
     else