comparison: www/crontasks.php
www/crontasks.php
- changeset 354
- 2e372eeba04b
- parent 294
- 1e09d1d102a8
- child 356
- 36c72e368948
equal
deleted
inserted
replaced
| 352:9d2a4703bdac | 354:2e372eeba04b |
|---|---|
| 14 | 14 |
| 15 $query = "UPDATE products SET stage=7 WHERE stage = 6 AND DATEDIFF(CURDATE(), package_date) > 0"; | 15 $query = "UPDATE products SET stage=7 WHERE stage = 6 AND DATEDIFF(CURDATE(), package_date) > 0"; |
| 16 $result = mysqli_query($connect, $query); | 16 $result = mysqli_query($connect, $query); |
| 17 $changed = mysqli_affected_rows($connect); | 17 $changed = mysqli_affected_rows($connect); |
| 18 if ($changed > 0) { | 18 if ($changed > 0) { |
| 19 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 7"); | 19 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 7 (Carbonation)"); |
| 20 } | 20 } |
| 21 | 21 |
| 22 $query = "UPDATE products SET stage=8 WHERE stage = 7 AND DATEDIFF(CURDATE(), package_date) > 13"; | 22 $query = "UPDATE products SET stage=8 WHERE stage = 7 AND DATEDIFF(CURDATE(), package_date) > 13"; |
| 23 $result = mysqli_query($connect, $query); | 23 $result = mysqli_query($connect, $query); |
| 24 $changed = mysqli_affected_rows($connect); | 24 $changed = mysqli_affected_rows($connect); |
| 25 if ($changed > 0) { | 25 if ($changed > 0) { |
| 26 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 8"); | 26 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 8 (Mature)"); |
| 27 } | 27 } |
| 28 | 28 |
| 29 $query = "UPDATE products SET stage=9 WHERE stage = 8 AND DATEDIFF(CURDATE(), package_date) > 41"; | 29 $query = "UPDATE products SET stage=9 WHERE stage = 8 AND DATEDIFF(CURDATE(), package_date) > 41"; |
| 30 $result = mysqli_query($connect, $query); | 30 $result = mysqli_query($connect, $query); |
| 31 $changed = mysqli_affected_rows($connect); | 31 $changed = mysqli_affected_rows($connect); |
| 32 if ($changed > 0) { | 32 if ($changed > 0) { |
| 33 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 9"); | 33 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 9 (Taste)"); |
| 34 } | 34 } |
| 35 | 35 |
| 36 | 36 |
| 37 $query = "SELECT record,code,name,log_brew,log_fermentation FROM products;"; | 37 $query = "SELECT record,code,name,log_brew,log_fermentation FROM products;"; |
| 38 $result = mysqli_query($connect, $query); | 38 $result = mysqli_query($connect, $query); |
