1 <?php |
1 <?php |
2 |
2 |
3 require_once('config.php'); |
3 require_once('config.php'); |
4 |
4 |
5 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
5 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); |
|
6 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); |
|
7 |
|
8 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
|
9 if (! $connect) { |
|
10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
|
11 } |
|
12 mysqli_set_charset($connect, "utf8" ); |
|
13 syslog(LOG_NOTICE, "crontasks.php started"); |
|
14 |
6 $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"; |
7 $result = $mysqli->query($query); |
16 $result = mysqli_query($connect, $query); |
|
17 $changed = mysqli_affected_rows($connect); |
|
18 if ($changed > 0) { |
|
19 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 7"); |
|
20 } |
8 |
21 |
9 $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"; |
10 $result = $mysqli->query($query); |
23 $result = mysqli_query($connect, $query); |
|
24 $changed = mysqli_affected_rows($connect); |
|
25 if ($changed > 0) { |
|
26 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 8"); |
|
27 } |
11 |
28 |
12 $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"; |
13 $result = $mysqli->query($query); |
30 $result = mysqli_query($connect, $query); |
|
31 $changed = mysqli_affected_rows($connect); |
|
32 if ($changed > 0) { |
|
33 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 9"); |
|
34 } |
14 |
35 |
|
36 |
|
37 $query = "SELECT record,code,name,log_brew,log_fermentation FROM products;"; |
|
38 $result = mysqli_query($connect, $query); |
|
39 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
|
40 $logfile = "log/fermentation/" . $row['code'] . " " . $row['name'] . ".log"; |
|
41 if (file_exists($logfile)) |
|
42 $ok = 1; |
|
43 else |
|
44 $ok = 0; |
|
45 if ($ok != $row['log_fermentation']) { |
|
46 $query = "UPDATE products SET log_fermentation='" . $ok . "' WHERE record='" . $row['record'] . "';"; |
|
47 syslog(LOG_NOTICE, $query); |
|
48 $result1 = mysqli_query($connect, $query); |
|
49 } |
|
50 } |
|
51 |