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; }