Sat, 09 Feb 2019 22:12:31 +0100
Version 0.0.6. Added a crontask that adjusts the stage of packaged beer depending on the days passed packaging
<?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);