/**
* проверяет не вышел ли срок давности у зарезервированных услуг.
*/
public static function checkOldReserve()
{
//require_once($_SERVER['DOCUMENT_ROOT'] . "/classes/smail.php");
global $DB;
$reservationDays = self::RESERVATION_DAYS;
$sql = "\n SELECT br.id as reserve_id, u.uid, u.login, u.uname, u.usurname, u.email\n FROM bill_reserve br\n INNER JOIN users u ON u.uid = br.uid\n WHERE br.status = 'reserve'\n AND (NOW() - br.create_time) > interval '{$reservationDays} days'\n ";
$res = $DB->rows($sql);
if (!$res) {
return false;
}
//$log = new log("billing/cancel-".SERVER.'-%d%m%Y.log', 'a', "%d.%m.%Y %H:%M:%S:\r\n");
//$reserves = array();
foreach ($res as $reserve) {
$bill = new self($reserve['uid']);
//$log->writeln("login:{$reserve['login']}, uid:{$reserve['uid']}, account:{$bill->acc['id']}, acc_sum:{$bill->acc['sum']}, reserve:{$reserve['reserve_id']}\r\n");
$bill->setReserveStatus($reserve['reserve_id'], self::RESERVE_CANCEL_STATUS);
//$log->write("success:{$success}");
/* Отключаем уведомление
if ($success) {
if ($bill->updateOrderListStatus($reserve['reserve_id'], billing::STATUS_NEW)) {
$reserves[] = $reserve;
$barNotify = new bar_notify($reserve['uid']);
$barNotify->addNotify('bill', 'orders', 'Список заказов автоматически отменен.');
}
}
*/
}
/* Отключаем уведомление
$smail = new smail();
$smail->sendCancelReserve($reserves, $reservationDays);
*/
return count($res);
}
