- Сообщения
- 2 272
- Лайки
- 8 198
Вот такую еще расскажи (на минувшей неделе реализовал) и закончим:
___________
function deleteOldBaskets(){
if ( CModule::IncludeModule("sale") && CModule::IncludeModule("catalog") ){
global $DB;
$nDays = 10;
$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 ".
" TO_DAYS(f.DATE_UPDATE)<(TO_DAYS(NOW())-".$nDays.") ".
" AND o.ID is null ".
" AND f.USER_ID is null ".
"LIMIT 3000";
$db_res = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
while ($ar_res = $db_res->Fetch()){
CSaleBasket:
eleteAll($ar_res["ID"], false);
CSaleUser:elete($ar_res["ID"]);
}
}
return "deleteOldBaskets();";
}
___________
function deleteOldBaskets(){
if ( CModule::IncludeModule("sale") && CModule::IncludeModule("catalog") ){
global $DB;
$nDays = 10;
$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 ".
" TO_DAYS(f.DATE_UPDATE)<(TO_DAYS(NOW())-".$nDays.") ".
" AND o.ID is null ".
" AND f.USER_ID is null ".
"LIMIT 3000";
$db_res = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
while ($ar_res = $db_res->Fetch()){
CSaleBasket:
eleteAll($ar_res["ID"], false);CSaleUser:
elete($ar_res["ID"]);}
}
return "deleteOldBaskets();";
}
