www/crontasks.php

changeset 294
1e09d1d102a8
parent 257
62e294ab94f5
child 354
2e372eeba04b
equal deleted inserted replaced
293:db898ec73277 294:1e09d1d102a8
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

mercurial