public static function DeleteOld($nDays)
{
global $DB;
$nDays = IntVal($nDays);
$strSql = "SELECT f.ID " . "FROM b_sale_fuser f " . "LEFT JOIN b_sale_order o ON (o.USER_ID = f.USER_ID) " . "WHERE " . "\tTO_DAYS(f.DATE_UPDATE)<(TO_DAYS(NOW())-" . $nDays . ") " . "\tAND o.ID is null " . "\tAND f.USER_ID is null " . "LIMIT 300";
$db_res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
while ($ar_res = $db_res->Fetch()) {
CSaleBasket::DeleteAll($ar_res["ID"], false);
CSaleUser::Delete($ar_res["ID"]);
}
return true;
}
function OnUserDelete($userID)
{
if ($userID <= 0) {
return false;
}
$arSUser = CSaleUser::GetList(array("USER_ID" => $userID));
if (!empty($arSUser)) {
if (!CSaleBasket::DeleteAll($arSUser["ID"])) {
return false;
}
if (!CSaleUser::Delete($arSUser["ID"])) {
return false;
}
}
return true;
}
function DeleteOld($nDays)
{
global $DB;
$nDays = IntVal($nDays);
$strSql = "SELECT ID " . "FROM b_sale_fuser " . "WHERE TO_DAYS(DATE_UPDATE)<(TO_DAYS(NOW())-" . $nDays . ") LIMIT 300";
$db_res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
while ($ar_res = $db_res->Fetch()) {
CSaleBasket::DeleteAll($ar_res["ID"], false);
CSaleUser::Delete($ar_res["ID"]);
}
return true;
}
