comparison: www/includes/db_divides.php
www/includes/db_divides.php
- changeset 754
- 30abc8024afe
- parent 722
- c4457e10d968
- child 774
- 92e1e8f175a2
equal
deleted
inserted
replaced
| 753:a59ecd6d72f4 | 754:30abc8024afe |
|---|---|
| 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 /* | 24 /* |
| 20 * Server side split batch. Parameters: | 25 * Server side split batch. Parameters: |
| 21 * record = original record. | 26 * record = original record. |
| 22 * divide_type = divide moment. | 27 * divide_type = divide moment. |
| 28 * return ok or error | 33 * return ok or error |
| 29 */ | 34 */ |
| 30 | 35 |
| 31 if (isset($_POST['record']) && isset($_POST['divide_type']) && isset($_POST['divide_parts']) && isset($_POST['divide_data'])) { | 36 if (isset($_POST['record']) && isset($_POST['divide_type']) && isset($_POST['divide_parts']) && isset($_POST['divide_data'])) { |
| 32 | 37 |
| 33 $rc = 0; | |
| 34 $record = $_POST['record']; | 38 $record = $_POST['record']; |
| 35 $divide_parts = $_POST['divide_parts']; | 39 $divide_parts = $_POST['divide_parts']; |
| 36 $divide_type = $_POST['divide_type']; | 40 $divide_type = $_POST['divide_type']; |
| 37 $divide_data = array_reverse($_POST['divide_data'], true); // reverse the array so the master record is last. | 41 $divide_data = array_reverse($_POST['divide_data'], true); // reverse the array so the master record is last. |
| 38 | 42 |
| 83 $sql .= "', divide_type='" . $divide_type; | 87 $sql .= "', divide_type='" . $divide_type; |
| 84 $sql .= "', divide_parts='" . $divide_parts; | 88 $sql .= "', divide_parts='" . $divide_parts; |
| 85 $sql .= "', divide_part='" . $index; | 89 $sql .= "', divide_part='" . $index; |
| 86 $sql .= "', divide_size='" . floatval($split['size']); | 90 $sql .= "', divide_size='" . floatval($split['size']); |
| 87 $sql .= "', divide_factor='". $factor; | 91 $sql .= "', divide_factor='". $factor; |
| 88 syslog(LOG_NOTICE, "db_divide: index " . $index . " " . $sql); | 92 // syslog(LOG_NOTICE, "db_divide: index " . $index . " " . $sql); |
| 89 | 93 |
| 90 } else { | 94 } else { |
| 91 /* | 95 /* |
| 92 * Insert splitted batches | 96 * Insert splitted batches |
| 93 */ | 97 */ |
| 357 | 361 |
| 358 if ($index == 0) { | 362 if ($index == 0) { |
| 359 $sql .= "' WHERE record='" . $record . "';"; | 363 $sql .= "' WHERE record='" . $record . "';"; |
| 360 $result2 = mysqli_query($link, $sql); | 364 $result2 = mysqli_query($link, $sql); |
| 361 if (! $result2) { | 365 if (! $result2) { |
| 362 syslog(LOG_NOTICE, "db_divide: result: ".mysqli_error($link)); | 366 syslog(LOG_NOTICE, "db_divide: result: ".mysqli_error($link)); |
| 363 $rc = 1; | 367 $response['error'] = true; |
| 368 $response['msg'] = "Update master result: ".mysqli_error($link); | |
| 364 break; | 369 break; |
| 365 } else { | 370 } else { |
| 366 syslog(LOG_NOTICE, "db_divide: updated record ".$record." code ".$split['code']); | 371 syslog(LOG_NOTICE, "db_divide: updated record ".$record." code ".$split['code']); |
| 367 } | 372 } |
| 368 } else { | 373 } else { |
| 369 $sql .= "';"; | 374 $sql .= "';"; |
| 370 $result2 = mysqli_query($link, $sql); | 375 $result2 = mysqli_query($link, $sql); |
| 371 if (! $result2) { | 376 if (! $result2) { |
| 377 $response['error'] = true; | |
| 378 $response['msg'] = "Insert split record result: ".mysqli_error($link); | |
| 372 syslog(LOG_NOTICE, "db_divide: result: ".mysqli_error($link)); | 379 syslog(LOG_NOTICE, "db_divide: result: ".mysqli_error($link)); |
| 373 $rc = 1; | |
| 374 break; | 380 break; |
| 375 } else { | 381 } else { |
| 376 $lastid = mysqli_insert_id($link); | 382 $lastid = mysqli_insert_id($link); |
| 377 syslog(LOG_NOTICE, "db_divide: inserted record ".$lastid." code ".$split['code']); | 383 syslog(LOG_NOTICE, "db_divide: inserted record ".$lastid." code ".$split['code']); |
| 378 /* Copy brew log records */ | 384 /* Copy brew log records */ |
| 403 } | 409 } |
| 404 } | 410 } |
| 405 } | 411 } |
| 406 | 412 |
| 407 } | 413 } |
| 408 syslog(LOG_NOTICE, "db_divide: rc=".$rc); | |
| 409 echo $rc; | |
| 410 } else { | 414 } else { |
| 411 syslog(LOG_NOTICE, "db_divide: missing arguments"); | 415 syslog(LOG_NOTICE, "db_divide: missing arguments"); |
| 412 echo 1; | 416 $response['error'] = true; |
| 417 $response['msg'] = "missing arguments"; | |
| 413 } | 418 } |
| 414 | 419 |
| 415 | 420 echo json_encode($response); |
| 416 | 421 |
| 417 | 422 |
| 418 ?> | 423 ?> |
