comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 757
- d13be50c0049
- parent 740
- 04c0e444e48e
- child 763
- 12a795e8b568
equal
deleted
inserted
replaced
| 756:b702c25661e7 | 757:d13be50c0049 |
|---|---|
| 13 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); | 13 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); |
| 14 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); | 14 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); |
| 15 $rescapers = array("'"); | 15 $rescapers = array("'"); |
| 16 $rreplacements = array("\\'"); | 16 $rreplacements = array("\\'"); |
| 17 $disallowed = array('visibleindex','uniqueid','boundindex','uid','h_weight','m_weight'); | 17 $disallowed = array('visibleindex','uniqueid','boundindex','uid','h_weight','m_weight'); |
| 18 | |
| 19 $response = array( | |
| 20 'error' => false, | |
| 21 'msg' => 'Ok', | |
| 22 ); | |
| 18 | 23 |
| 19 if (isset($_POST['insert']) || isset($_POST['update'])) { | 24 if (isset($_POST['insert']) || isset($_POST['update'])) { |
| 20 if (isset($_POST['insert'])) { | 25 if (isset($_POST['insert'])) { |
| 21 $sql = "INSERT INTO `products` SET "; | 26 $sql = "INSERT INTO `products` SET "; |
| 22 } | 27 } |
| 520 $sql .= "' WHERE record='" . $_POST['record'] . "';"; | 525 $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
| 521 } | 526 } |
| 522 | 527 |
| 523 $result = mysqli_query($connect, $sql); | 528 $result = mysqli_query($connect, $sql); |
| 524 if (! $result) { | 529 if (! $result) { |
| 525 syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect)); | 530 syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect)); |
| 531 $response['error'] = true; | |
| 532 $response['msg'] = "SQL fout: ".mysqli_error($link); | |
| 526 } else { | 533 } else { |
| 527 if (isset($_POST['update'])) { | 534 if (isset($_POST['update'])) { |
| 528 //syslog(LOG_NOTICE, "db_product: updated record ".$_POST['record']); | 535 //syslog(LOG_NOTICE, "db_product: updated record ".$_POST['record']); |
| 529 inventory_reduce(); | 536 inventory_reduce(); |
| 530 } else { | 537 } else { |
| 531 $lastid = mysqli_insert_id($connect); | 538 $lastid = mysqli_insert_id($connect); |
| 532 //syslog(LOG_NOTICE, "db_product: inserted record ".$lastid); | 539 //syslog(LOG_NOTICE, "db_product: inserted record ".$lastid); |
| 533 } | 540 } |
| 534 } | 541 } |
| 535 echo $result; | 542 echo json_encode($response); |
| 536 | 543 |
| 537 } else if (isset($_POST['splitit'])) { | 544 } else if (isset($_POST['splitit'])) { |
| 538 /* | 545 /* |
| 539 * Update split batch details | 546 * Update split batch details |
| 540 */ | 547 */ |
| 546 syslog(LOG_NOTICE, $sql); | 553 syslog(LOG_NOTICE, $sql); |
| 547 | 554 |
| 548 $result = mysqli_query($connect, $sql); | 555 $result = mysqli_query($connect, $sql); |
| 549 if (! $result) { | 556 if (! $result) { |
| 550 syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect)); | 557 syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect)); |
| 558 $response['error'] = true; | |
| 559 $response['msg'] = "SQL update fout: ".mysqli_error($link); | |
| 551 } else { | 560 } else { |
| 552 syslog(LOG_NOTICE, "db_product: updated (divide) record ".$_POST['record']); | 561 syslog(LOG_NOTICE, "db_product: updated (divide) record ".$_POST['record']); |
| 553 } | 562 } |
| 554 echo $result; | 563 echo json_encode($response); |
| 555 | 564 |
| 556 } else if (isset($_POST['delete'])) { | 565 } else if (isset($_POST['delete'])) { |
| 557 /* | 566 /* |
| 558 * DELETE command. | 567 * DELETE command. |
| 559 */ | 568 */ |
| 560 $sql = "DELETE FROM `products` WHERE uuid='".$_POST['uuid']."';"; | 569 $sql = "DELETE FROM `products` WHERE uuid='".$_POST['uuid']."';"; |
| 561 $result = mysqli_query($connect, $sql); | 570 $result = mysqli_query($connect, $sql); |
| 562 if (! $result) { | 571 if (! $result) { |
| 563 syslog(LOG_NOTICE, "db_product: ".$sql." result: ".mysqli_error($connect)); | 572 syslog(LOG_NOTICE, "db_product: ".$sql." result: ".mysqli_error($connect)); |
| 573 $response['error'] = true; | |
| 574 $response['msg'] = "SQL delete fout: ".mysqli_error($link); | |
| 564 } else { | 575 } else { |
| 565 syslog(LOG_NOTICE, "db_product: deleted product uuid ".$_POST['uuid']); | 576 syslog(LOG_NOTICE, "db_product: deleted product uuid ".$_POST['uuid']); |
| 566 } | 577 } |
| 567 echo $result; | 578 echo json_encode($response); |
| 568 | 579 |
| 569 } else { | 580 } else { |
| 570 /* | 581 /* |
| 571 * SELECT, produce a list of products that are not yet Closed. | 582 * SELECT, produce a list of products that are not yet Closed. |
| 572 */ | 583 */ |
