Mercurial > bms / file revision

• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

www/crontasks.php@19606adfea42

www/crontasks.php

Wed, 13 Feb 2019 20:28:54 +0100

author

Michiel Broek <mbroek@mbse.eu>

date

Wed, 13 Feb 2019 20:28:54 +0100

changeset 273

19606adfea42

parent 257

62e294ab94f5

child 294

1e09d1d102a8

permissions

-rw-r--r--

Set recipe edit values readonly when the brewday is over. Add the inventory reduce script and update the checkbox. Active after 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);