Mercurial > bms / file diff

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/crontasks.php	Sat Feb 09 22:12:31 2019 +0100
@@ -0,0 +1,14 @@
+<?php
+
+require_once('config.php');
+
+$mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
+$query = "UPDATE products SET stage=7 WHERE stage = 6 AND DATEDIFF(CURDATE(), package_date) > 0";
+$result = $mysqli->query($query);
+
+$query = "UPDATE products SET stage=8 WHERE stage = 7 AND DATEDIFF(CURDATE(), package_date) > 13";
+$result = $mysqli->query($query);
+
+$query = "UPDATE products SET stage=9 WHERE stage = 8 AND DATEDIFF(CURDATE(), package_date) > 41";
+$result = $mysqli->query($query);
+