| Server IP : 80.87.202.40 / Your IP : 216.73.216.169 Web Server : Apache System : Linux rospirotorg.ru 5.14.0-539.el9.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Dec 5 22:26:13 UTC 2024 x86_64 User : bitrix ( 600) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/bitrix/ext_www/rospirotorg.ru/bitrix/modules/main/classes/general/ |
Upload File : |
<?php
IncludeModuleLangFile(__FILE__);
class CRatings
{
const REACTION_DEFAULT = 'like';
const REACTION_KISS = 'kiss';
const REACTION_LAUGH = 'laugh';
const REACTION_ANGRY = 'angry';
const REACTION_WONDER = 'wonder';
const REACTION_CRY = 'cry';
// get specified rating record
public static function GetByID($ID)
{
global $DB;
$ID = (int)$ID;
if ($ID <= 0)
{
return false;
}
return $DB->Query("
SELECT
R.*,
" . $DB->DateToCharFunction("R.CREATED") . " as CREATED,
" . $DB->DateToCharFunction("R.LAST_MODIFIED") . " as LAST_MODIFIED,
" . $DB->DateToCharFunction("R.LAST_CALCULATED") . " as LAST_CALCULATED
FROM
b_rating R
WHERE
ID=" . $ID
);
}
public static function GetArrayByID($ID)
{
global $DB;
$ID = (int)$ID;
$strID = "b" . $ID;
if (CACHED_b_rating === false)
{
$res = $DB->Query("
SELECT
R.*,
" . $DB->DateToCharFunction("R.CREATED") . " as CREATED,
" . $DB->DateToCharFunction("R.LAST_MODIFIED") . " as LAST_MODIFIED,
" . $DB->DateToCharFunction("R.LAST_CALCULATED") . " as LAST_CALCULATED
FROM
b_rating R
WHERE
ID=" . $ID
);
$arResult = $res->Fetch();
}
else
{
global $stackCacheManager;
$stackCacheManager->SetLength("b_rating", 100);
$stackCacheManager->SetTTL("b_rating", CACHED_b_rating);
if ($stackCacheManager->Exist("b_rating", $strID))
{
$arResult = $stackCacheManager->Get("b_rating", $strID);
}
else
{
$res = $DB->Query("
SELECT
R.*,
" . $DB->DateToCharFunction("R.CREATED") . " as CREATED,
" . $DB->DateToCharFunction("R.LAST_MODIFIED") . " as LAST_MODIFIED,
" . $DB->DateToCharFunction("R.LAST_CALCULATED") . " as LAST_CALCULATED
FROM
b_rating R
WHERE
ID=" . $ID
);
$arResult = $res->Fetch();
if ($arResult)
{
$stackCacheManager->Set("b_rating", $strID, $arResult);
}
}
}
return $arResult;
}
// get rating record list
public static function GetList($arSort = [], $arFilter = [])
{
global $DB;
$arSqlSearch = [];
if (is_array($arFilter))
{
foreach ($arFilter as $key => $val)
{
if ((string)$val == '' || $val === "NOT_REF")
{
continue;
}
switch (mb_strtoupper($key))
{
case "ID":
$arSqlSearch[] = GetFilterQuery("R.ID", $val, "N");
break;
case "ACTIVE":
if (in_array($val, ['Y', 'N']))
{
$arSqlSearch[] = "R.ACTIVE = '" . $val . "'";
}
break;
case "AUTHORITY":
if (in_array($val, ['Y', 'N']))
{
$arSqlSearch[] = "R.AUTHORITY = '" . $val . "'";
}
break;
case "POSITION":
if (in_array($val, ['Y', 'N']))
{
$arSqlSearch[] = "R.POSITION = '" . $val . "'";
}
break;
case "CALCULATED":
if (in_array($val, ['Y', 'N', 'C']))
{
$arSqlSearch[] = "R.CALCULATED = '" . $val . "'";
}
break;
case "NAME":
$arSqlSearch[] = GetFilterQuery("R.NAME", $val);
break;
case "ENTITY_ID":
$arSqlSearch[] = GetFilterQuery("R.ENTITY_ID", $val);
break;
}
}
}
$sOrder = "";
foreach ($arSort as $key => $val)
{
$ord = (mb_strtoupper($val) <> "ASC" ? "DESC" : "ASC");
switch (mb_strtoupper($key))
{
case "ID":
$sOrder .= ", R.ID " . $ord;
break;
case "NAME":
$sOrder .= ", R.NAME " . $ord;
break;
case "CREATED":
$sOrder .= ", R.CREATED " . $ord;
break;
case "LAST_MODIFIED":
$sOrder .= ", R.LAST_MODIFIED " . $ord;
break;
case "LAST_CALCULATED":
$sOrder .= ", R.LAST_CALCULATED " . $ord;
break;
case "ACTIVE":
$sOrder .= ", R.ACTIVE " . $ord;
break;
case "AUTHORITY":
$sOrder .= ", R.AUTHORITY " . $ord;
break;
case "POSITION":
$sOrder .= ", R.POSITION " . $ord;
break;
case "STATUS":
$sOrder .= ", R.CALCULATED " . $ord;
break;
case "CALCULATED":
$sOrder .= ", R.CALCULATED " . $ord;
break;
case "CALCULATION_METHOD":
$sOrder .= ", R.CALCULATION_METHOD " . $ord;
break;
case "ENTITY_ID":
$sOrder .= ", R.ENTITY_ID " . $ord;
break;
}
}
if ($sOrder == '')
{
$sOrder = "R.ID DESC";
}
$strSqlOrder = " ORDER BY " . trim($sOrder, ", ");
$strSqlSearch = GetFilterSqlSearch($arSqlSearch);
$strSql = "
SELECT
R.ID, R.NAME, R.ACTIVE, R.CALCULATED, R.AUTHORITY, R.POSITION, R.ENTITY_ID, R.CALCULATION_METHOD,
" . $DB->DateToCharFunction("R.CREATED") . " CREATED,
" . $DB->DateToCharFunction("R.LAST_MODIFIED") . " LAST_MODIFIED,
" . $DB->DateToCharFunction("R.LAST_CALCULATED") . " LAST_CALCULATED
FROM
b_rating R
WHERE
" . $strSqlSearch . "
" . $strSqlOrder;
return $DB->Query($strSql);
}
public static function GetRatingValueInfo($ratingId)
{
global $DB;
$ratingId = (int)$ratingId;
$strSql = "
SELECT
MAX(CURRENT_VALUE) as MAX,
MIN(CURRENT_VALUE) as MIN,
AVG(CURRENT_VALUE) as AVG,
COUNT(*) as CNT
FROM b_rating_results
WHERE RATING_ID = " . $ratingId;
return $DB->Query($strSql);
}
//Addition rating
public static function Add($arFields)
{
global $DB, $stackCacheManager;
// check only general field
if (!CRatings::__CheckFields($arFields))
{
return false;
}
$arFields_i = [
"ACTIVE" => $arFields["ACTIVE"] === 'Y' ? 'Y' : 'N',
"POSITION" => $arFields["POSITION"] === 'Y' ? 'Y' : 'N',
"AUTHORITY" => $arFields["AUTHORITY"] === 'Y' ? 'Y' : 'N',
"NAME" => $arFields["NAME"],
"ENTITY_ID" => $arFields["ENTITY_ID"],
"CALCULATION_METHOD" => $arFields["CALCULATION_METHOD"],
"~CREATED" => $DB->GetNowFunction(),
"~LAST_MODIFIED" => $DB->GetNowFunction(),
];
$ID = $DB->Add("b_rating", $arFields_i);
// queries modules and give them to inspect the field settings
foreach (GetModuleEvents("main", "OnAfterAddRating", true) as $arEvent)
{
$arFields = ExecuteModuleEventEx($arEvent, [$ID, $arFields]);
}
CRatings::__AddComponents($ID, $arFields);
$arFields_u = [
"CONFIGS" => "'" . $DB->ForSQL(serialize($arFields["CONFIGS"])) . "'",
];
$DB->Update("b_rating", $arFields_u, "WHERE ID = " . $ID);
if ($arFields['AUTHORITY'] === 'Y')
{
CRatings::SetAuthorityRating($ID);
}
CAgent::AddAgent("CRatings::Calculate($ID);", "main", "N", 3600, "", "Y", "");
$stackCacheManager->Clear("b_rating");
return $ID;
}
//Update rating
public static function Update($ID, $arFields)
{
global $DB, $stackCacheManager;
$ID = (int)$ID;
// check only general field
if (!CRatings::__CheckFields($arFields))
{
return false;
}
$arFields_u = [
"ACTIVE" => $arFields['ACTIVE'] === 'Y' ? 'Y' : 'N',
"NAME" => $arFields["NAME"],
"ENTITY_ID" => $arFields["ENTITY_ID"],
"CALCULATION_METHOD" => $arFields["CALCULATION_METHOD"],
"~LAST_MODIFIED" => $DB->GetNowFunction(),
];
$strUpdate = $DB->PrepareUpdate("b_rating", $arFields_u);
if (!$DB->Query("UPDATE b_rating SET " . $strUpdate . " WHERE ID=" . $ID))
{
return false;
}
if (!isset($arFields["CONFIGS"]))
{
$stackCacheManager->Clear("b_rating");
return true;
}
// queries modules and give them to inspect the field settings
foreach (GetModuleEvents("main", "OnAfterUpdateRating", true) as $arEvent)
{
$arFields = ExecuteModuleEventEx($arEvent, [$ID, $arFields]);
}
CRatings::__UpdateComponents($ID, $arFields);
$arFields_u = [
"POSITION" => "'" . ($arFields['POSITION'] === 'Y' ? 'Y' : 'N') . "'",
"AUTHORITY" => "'" . ($arFields['AUTHORITY'] === 'Y' ? 'Y' : 'N') . "'",
"CONFIGS" => "'" . $DB->ForSQL(serialize($arFields["CONFIGS"])) . "'",
];
$DB->Update("b_rating", $arFields_u, "WHERE ID = " . $ID);
if ($arFields['AUTHORITY'] === 'Y')
{
CRatings::SetAuthorityRating($ID);
}
if ($arFields['NEW_CALC'] === 'Y')
{
$DB->Query("UPDATE b_rating_results SET PREVIOUS_VALUE = 0 WHERE RATING_ID=" . $ID . " and ENTITY_TYPE_ID='" . $DB->ForSql($arFields["ENTITY_ID"]) . "'");
}
$strSql = "SELECT COMPLEX_NAME FROM b_rating_component WHERE RATING_ID = $ID and ACTIVE = 'N'";
$res = $DB->Query($strSql);
$arrRatingComponentId = [];
while ($arRes = $res->Fetch())
{
$arrRatingComponentId[] = $arRes['COMPLEX_NAME'];
}
if (!empty($arrRatingComponentId))
{
$DB->Query("DELETE FROM b_rating_component_results WHERE RATING_ID = $ID AND COMPLEX_NAME IN ('" . implode("','", $arrRatingComponentId) . "')");
}
CRatings::Calculate($ID, true);
CAgent::RemoveAgent("CRatings::Calculate($ID);", "main");
$AID = CAgent::AddAgent("CRatings::Calculate($ID);", "main", "N", 3600, "", "Y", "");
$stackCacheManager->Clear("b_rating");
return true;
}
// delete rating
public static function Delete($ID)
{
global $DB, $stackCacheManager;
$ID = (int)$ID;
foreach (GetModuleEvents("main", "OnBeforeDeleteRating", true) as $arEvent)
{
ExecuteModuleEventEx($arEvent, [$ID]);
}
$DB->Query("DELETE FROM b_rating WHERE ID=$ID");
$DB->Query("DELETE FROM b_rating_user WHERE RATING_ID=$ID");
$DB->Query("DELETE FROM b_rating_component WHERE RATING_ID=$ID");
$DB->Query("DELETE FROM b_rating_component_results WHERE RATING_ID=$ID");
$DB->Query("DELETE FROM b_rating_results WHERE RATING_ID=$ID");
CAgent::RemoveAgent("CRatings::Calculate($ID);", "main");
$stackCacheManager->Clear("b_rating");
return true;
}
// start calculation rating-component
public static function Calculate($ID, $bForceRecalc = false)
{
global $DB;
$ID = (int)$ID;
$strSql = "SELECT
RC.*,
" . $DB->DateToCharFunction("RC.LAST_MODIFIED") . " LAST_MODIFIED,
" . $DB->DateToCharFunction("RC.LAST_CALCULATED") . " LAST_CALCULATED,
" . $DB->DateToCharFunction("RC.NEXT_CALCULATION") . " NEXT_CALCULATION
FROM
b_rating_component RC
WHERE
RATING_ID = $ID
and ACTIVE = 'Y' " . ($bForceRecalc ? '' : 'AND NEXT_CALCULATION <= ' . $DB->GetNowFunction());
$res = $DB->Query($strSql);
while ($arRes = $res->Fetch())
{
if (CModule::IncludeModule(mb_strtolower($arRes['MODULE_ID'])))
{
$arRes['CONFIG'] = unserialize($arRes['CONFIG'], ['allowed_classes' => false]);
// If the type is automatic calculation of parameters * global vote weight
$sRatingWeightType = COption::GetOptionString("main", "rating_weight_type", "auto");
if ($sRatingWeightType === 'auto')
{
$voteWeight = COption::GetOptionString("main", "rating_vote_weight", 1);
$arRes['CONFIG']['COEFFICIENT'] = ($arRes['CONFIG']['COEFFICIENT'] ?? 1) * $voteWeight;
}
if ($arRes['EXCEPTION_METHOD'] <> '')
{
if (method_exists($arRes['CLASS'], $arRes['EXCEPTION_METHOD']))
{
$exceptionText = call_user_func([$arRes['CLASS'], $arRes['EXCEPTION_METHOD']]);
if ($exceptionText === false)
{
if (method_exists($arRes['CLASS'], $arRes['CALC_METHOD']))
{
$result = call_user_func([$arRes['CLASS'], $arRes['CALC_METHOD']], $arRes);
}
}
}
}
else
{
if (method_exists($arRes['CLASS'], $arRes['CALC_METHOD']))
{
$result = call_user_func([$arRes['CLASS'], $arRes['CALC_METHOD']], $arRes);
}
}
}
}
CRatings::BuildRating($ID);
return "CRatings::Calculate($ID);";
}
// queries modules and get all the available objects
public static function GetRatingObjects()
{
$arObjects = [];
foreach (GetModuleEvents("main", "OnGetRatingsObjects", true) as $arEvent)
{
$arConfig = ExecuteModuleEventEx($arEvent);
foreach ($arConfig as $OBJ_TYPE)
{
if (!in_array($OBJ_TYPE, $arObjects))
{
$arObjects[] = $OBJ_TYPE;
}
}
}
return $arObjects;
}
// queries modules and get all the available entity types
public static function GetRatingEntityTypes($objectType = null)
{
$arEntityTypes = [];
foreach (GetModuleEvents("main", "OnGetRatingsConfigs", true) as $arEvent)
{
$arConfig = ExecuteModuleEventEx($arEvent);
if (is_null($objectType))
{
foreach ($arConfig as $OBJ_TYPE => $OBJ_VALUE)
{
foreach ($OBJ_VALUE['VOTE'] as $VOTE_VALUE)
{
$EntityTypeId = $VOTE_VALUE['MODULE_ID'] . '_' . $VOTE_VALUE['ID'];
if (!in_array($arEntityTypes[$OBJ_TYPE], $EntityTypeId))
{
$arEntityTypes[$OBJ_TYPE][] = $EntityTypeId;
}
}
}
}
else
{
foreach ($arConfig[$objectType]['VOTE'] as $VOTE_VALUE)
{
$EntityTypeId = $VOTE_VALUE['MODULE_ID'] . '_' . $VOTE_VALUE['ID'];
$arEntityTypes[$EntityTypeId] = $EntityTypeId;
}
}
}
return $arEntityTypes;
}
// queries modules and assemble an array of settings
public static function GetRatingConfigs($objectType = null, $withRatingType = true)
{
$arConfigs = [];
foreach (GetModuleEvents("main", "OnGetRatingsConfigs", true) as $arEvent)
{
$arConfig = ExecuteModuleEventEx($arEvent);
if (is_null($objectType))
{
foreach ($arConfig["COMPONENT"] as $OBJ_TYPE => $TYPE_VALUE)
{
foreach ($TYPE_VALUE as $RAT_TYPE => $RAT_VALUE)
{
foreach ($RAT_VALUE as $VALUE)
{
if ($withRatingType)
{
$arConfigs[$OBJ_TYPE][$arConfig['MODULE_ID']][$RAT_TYPE][$arConfig['MODULE_ID'] . "_" . $RAT_TYPE . "_" . $VALUE['ID']] = $VALUE;
}
else
{
$arConfigs[$OBJ_TYPE][$arConfig['MODULE_ID']][$arConfig['MODULE_ID'] . "_" . $RAT_TYPE . "_" . $VALUE['ID']] = $VALUE;
}
}
}
}
}
else
{
foreach ($arConfig["COMPONENT"][$objectType] as $RAT_TYPE => $RAT_VALUE)
{
$arConfigs[$arConfig['MODULE_ID']]['MODULE_ID'] = $arConfig['MODULE_ID'];
$arConfigs[$arConfig['MODULE_ID']]['MODULE_NAME'] = $arConfig['MODULE_NAME'];
foreach ($RAT_VALUE as $VALUE)
{
if ($withRatingType)
{
$arConfigs[$arConfig['MODULE_ID']][$RAT_TYPE][$arConfig['MODULE_ID'] . "_" . $RAT_TYPE . "_" . $VALUE['ID']] = $VALUE;
}
else
{
$arConfigs[$arConfig['MODULE_ID']][$arConfig['MODULE_ID'] . "_" . $RAT_TYPE . "_" . $VALUE['ID']] = $VALUE;
}
}
}
}
}
return $arConfigs;
}
public static function GetRatingVoteResult($entityTypeId, $entityId, $user_id = 0)
{
global $USER;
$arResult = [];
$user_id = (int)$user_id;
if ($user_id == 0)
{
if (!($USER instanceof CUser))
{
return $arResult;
}
$user_id = $USER->GetID();
}
if (is_array($entityId))
{
foreach ($entityId as $currentEntityId)
{
$arResult[$currentEntityId] = self::GetRatingVoteResultCache($entityTypeId, $currentEntityId, $user_id);
}
}
else
{
$arResult = self::GetRatingVoteResultCache($entityTypeId, $entityId, $user_id);
}
return $arResult;
}
public static function GetRatingVoteResultCache($entityTypeId, $entityId, $user_id = 0)
{
global $DB, $CACHE_MANAGER;
$arResult = [];
$entityId = (int)$entityId;
$user_id = (int)$user_id;
if ($entityTypeId == '' || $entityId <= 0)
{
return $arResult;
}
if ($user_id == 0)
{
$user_id = $GLOBALS["USER"]->GetID();
}
$bucket_size = (int)CACHED_b_rating_bucket_size;
if ($bucket_size <= 0)
{
$bucket_size = 100;
}
$bucket = (int)($entityId / $bucket_size);
if ($CACHE_MANAGER->Read(CACHED_b_rating_vote, $cache_id = "b_rvg_" . $entityTypeId . $bucket, "b_rating_voting"))
{
$arResult = $CACHE_MANAGER->Get($cache_id);
}
else
{
$total = [];
$sql_str = "SELECT
RVG.ID,
RVG.ENTITY_ID,
RVG.TOTAL_VALUE,
RVG.TOTAL_VOTES,
RVG.TOTAL_POSITIVE_VOTES,
RVG.TOTAL_NEGATIVE_VOTES
FROM
b_rating_voting RVG
WHERE
RVG.ENTITY_TYPE_ID = '" . $DB->ForSql($entityTypeId) . "'
and RVG.ENTITY_ID between " . ($bucket * $bucket_size) . " AND " . (($bucket + 1) * $bucket_size - 1) . "
and RVG.ACTIVE = 'Y'";
$res = $DB->Query($sql_str);
while ($row = $res->Fetch())
{
$arResult[$row['ENTITY_ID']] = [
'USER_VOTE' => 0,
'USER_REACTION' => false,
'USER_HAS_VOTED' => 'N',
'USER_VOTE_LIST' => [],
'USER_REACTION_LIST' => [],
'TOTAL_VALUE' => $row['TOTAL_VALUE'],
'TOTAL_VOTES' => (int)$row['TOTAL_VOTES'],
'TOTAL_POSITIVE_VOTES' => (int)$row['TOTAL_POSITIVE_VOTES'],
'TOTAL_NEGATIVE_VOTES' => (int)$row['TOTAL_NEGATIVE_VOTES'],
'REACTIONS_LIST' => [
self::REACTION_DEFAULT => (int)$row['TOTAL_POSITIVE_VOTES'],
],
];
if (!isset($total[$row['ENTITY_ID']]))
{
$total[$row['ENTITY_ID']] = (int)$row['TOTAL_POSITIVE_VOTES'];
}
}
$count = [];
$foundDefault = [];
$entityIdList = [];
$sql_str = "SELECT
RVGR.ENTITY_ID,
RVGR.REACTION,
RVGR.TOTAL_VOTES
FROM
b_rating_voting_reaction RVGR
WHERE
RVGR.ENTITY_TYPE_ID = '" . $DB->ForSql($entityTypeId) . "'
and RVGR.ENTITY_ID between " . ($bucket * $bucket_size) . " AND " . (($bucket + 1) * $bucket_size - 1);
$res = $DB->Query($sql_str);
while ($row = $res->Fetch())
{
if (!in_array($row['ENTITY_ID'], $entityIdList))
{
$entityIdList[] = $row['ENTITY_ID'];
}
$arResult[$row['ENTITY_ID']]['REACTIONS_LIST'][$row['REACTION']] = (int)$row['TOTAL_VOTES'];
if (!isset($count[$row['ENTITY_ID']]))
{
$count[$row['ENTITY_ID']] = 0;
}
$count[$row['ENTITY_ID']] += ((int)$row['TOTAL_VOTES'] >= 0 ? (int)$row['TOTAL_VOTES'] : 0);
if (
!isset($foundDefault[$row['ENTITY_ID']])
&& $row['REACTION'] == self::REACTION_DEFAULT
)
{
$foundDefault[$row['ENTITY_ID']] = true;
}
}
foreach ($entityIdList as $eId)
{
if (
!isset($foundDefault[$eId])
&& isset($count[$eId])
&& isset($total[$eId])
&& $count[$eId] >= $total[$eId]
)
{
$arResult[$eId]['REACTIONS_LIST'][self::REACTION_DEFAULT] = 0;
}
}
$sql = "SELECT RVG.ENTITY_ID, RVG.USER_ID, RVG.VALUE, RVG.REACTION
FROM b_rating_vote RVG
WHERE RVG.ENTITY_TYPE_ID = '" . $DB->ForSql($entityTypeId) . "'
and RVG.ENTITY_ID between " . ($bucket * $bucket_size) . " AND " . (($bucket + 1) * $bucket_size - 1);
$res = $DB->Query($sql);
while ($row = $res->Fetch())
{
$arResult[$row['ENTITY_ID']]['USER_VOTE_LIST'][$row['USER_ID']] = $row['VALUE'];
$arResult[$row['ENTITY_ID']]['USER_REACTION_LIST'][$row['USER_ID']] = (!empty($row['REACTION']) ? $row['REACTION'] : self::REACTION_DEFAULT);
}
$CACHE_MANAGER->Set($cache_id, $arResult);
}
if (isset($arResult[$entityId]['USER_VOTE_LIST'][$user_id]))
{
$arResult[$entityId]['USER_VOTE'] = $arResult[$entityId]['USER_VOTE_LIST'][$user_id];
$arResult[$entityId]['USER_REACTION'] = (
!empty($arResult[$entityId]['USER_REACTION_LIST'][$user_id])
? $arResult[$entityId]['USER_REACTION_LIST'][$user_id]
: self::REACTION_DEFAULT
);
$arResult[$entityId]['USER_HAS_VOTED'] = 'Y';
}
return $arResult[$entityId] ?? [];
}
public static function GetRatingResult($ID, $entityId)
{
global $DB;
$ID = (int)$ID;
static $cacheRatingResult = [];
if (!array_key_exists($ID, $cacheRatingResult))
{
$cacheRatingResult[$ID] = [];
}
$arResult = [];
$arToSelect = [];
if (is_array($entityId))
{
foreach ($entityId as $value)
{
$value = (int)$value;
if ($value > 0)
{
if (array_key_exists($value, $cacheRatingResult[$ID]))
{
$arResult[$value] = $cacheRatingResult[$ID][$value];
}
else
{
$arResult[$value] = $cacheRatingResult[$ID][$value] = [];
$arToSelect[$value] = $value;
}
}
}
}
else
{
$value = (int)$entityId;
if ($value > 0)
{
if (isset($cacheRatingResult[$ID][$value]))
{
$arResult[$value] = $cacheRatingResult[$ID][$value];
}
else
{
$arResult[$value] = $cacheRatingResult[$ID][$value] = [];
$arToSelect[$value] = $value;
}
}
}
if (!empty($arToSelect))
{
$strSql = "
SELECT ENTITY_TYPE_ID, ENTITY_ID, PREVIOUS_VALUE, CURRENT_VALUE, PREVIOUS_POSITION, CURRENT_POSITION
FROM b_rating_results
WHERE RATING_ID = '" . $ID . "' AND ENTITY_ID IN (" . implode(',', $arToSelect) . ")
";
$res = $DB->Query($strSql);
while ($arRes = $res->Fetch())
{
$arRes['PROGRESS_VALUE'] = $arRes['CURRENT_VALUE'] - $arRes['PREVIOUS_VALUE'];
$arRes['PROGRESS_VALUE'] = round($arRes['PROGRESS_VALUE'], 2);
$arRes['PROGRESS_VALUE'] = $arRes['PROGRESS_VALUE'] > 0 ? "+" . $arRes['PROGRESS_VALUE'] : $arRes['PROGRESS_VALUE'];
$arRes['ROUND_CURRENT_VALUE'] = round($arRes['CURRENT_VALUE']) == 0 ? 0 : round($arRes['CURRENT_VALUE']);
$arRes['ROUND_PREVIOUS_VALUE'] = round($arRes['PREVIOUS_VALUE']) == 0 ? 0 : round($arRes['CURRENT_VALUE']);
$arRes['CURRENT_POSITION'] = $arRes['CURRENT_POSITION'] > 0 ? $arRes['CURRENT_POSITION'] : GetMessage('RATING_NO_POSITION');
if ($arRes['PREVIOUS_POSITION'] > 0)
{
$arRes['PROGRESS_POSITION'] = $arRes['PREVIOUS_POSITION'] - $arRes['CURRENT_POSITION'];
$arRes['PROGRESS_POSITION'] = $arRes['PROGRESS_POSITION'] > 0 ? "+" . $arRes['PROGRESS_POSITION'] : $arRes['PROGRESS_POSITION'];
}
else
{
$arRes['PREVIOUS_POSITION'] = 0;
$arRes['PROGRESS_POSITION'] = 0;
}
$arResult[$arRes["ENTITY_ID"]] = $cacheRatingResult[$ID][$arRes["ENTITY_ID"]] = $arRes;
}
}
if (!is_array($entityId) && !empty($arResult))
{
$arResult = array_pop($arResult);
}
return $arResult;
}
public static function AddRatingVote($arParam)
{
global $DB, $CACHE_MANAGER;
$connection = \Bitrix\Main\Application::getConnection();
$helper = $connection->getSqlHelper();
if ($arParam['ENTITY_TYPE_ID'] === 'USER' && isset(\Bitrix\Main\Application::getInstance()->getSession()['RATING_VOTE_COUNT']))
{
if (\Bitrix\Main\Application::getInstance()->getSession()['RATING_VOTE_COUNT'] >= \Bitrix\Main\Application::getInstance()->getSession()['RATING_USER_VOTE_COUNT'])
{
return false;
}
\Bitrix\Main\Application::getInstance()->getSession()['RATING_VOTE_COUNT']++;
}
$arParam['ENTITY_TYPE_ID'] = mb_substr($arParam['ENTITY_TYPE_ID'], 0, 50);
$arParam['REACTION'] = ($arParam['REACTION'] <> '' ? $arParam['REACTION'] : self::REACTION_DEFAULT);
CRatings::CancelRatingVote($arParam);
$votePlus = $arParam['VALUE'] >= 0 ? true : false;
$ratingId = CRatings::GetAuthorityRating();
$arRatingUserProp = CRatings::GetRatingUserProp($ratingId, $arParam['USER_ID']);
$voteUserWeight = $arRatingUserProp['VOTE_WEIGHT'];
$sRatingWeightType = COption::GetOptionString("main", "rating_weight_type", "auto");
if ($sRatingWeightType === 'auto')
{
if ($arParam['ENTITY_TYPE_ID'] === 'USER')
{
$sRatingAuthrorityWeight = COption::GetOptionString("main", "rating_authority_weight_formula", 'Y');
if ($sRatingAuthrorityWeight === 'Y')
{
$communitySize = COption::GetOptionString("main", "rating_community_size", 1);
$communityAuthority = COption::GetOptionString("main", "rating_community_authority", 1);
$voteWeight = COption::GetOptionString("main", "rating_vote_weight", 1);
$arParam['VALUE'] = $arParam['VALUE'] * ($communitySize * ($voteUserWeight / $voteWeight) / $communityAuthority);
}
}
else
{
$arParam['VALUE'] = $arParam['VALUE'] * $voteUserWeight;
}
}
else
{
$arParam['VALUE'] = $arParam['VALUE'] * $voteUserWeight;
}
$arFields = [
'ACTIVE' => "'Y'",
'TOTAL_VOTES' => "TOTAL_VOTES+1",
'TOTAL_VALUE' => "TOTAL_VALUE" . ($votePlus ? '+' : '') . (float)$arParam['VALUE'],
'LAST_CALCULATED' => $DB->GetNowFunction(),
];
$arFields[($votePlus ? 'TOTAL_POSITIVE_VOTES' : 'TOTAL_NEGATIVE_VOTES')] = ($votePlus ? 'TOTAL_POSITIVE_VOTES+1' : 'TOTAL_NEGATIVE_VOTES+1');
// GetOwnerDocument
$arParam['OWNER_ID'] = 0;
foreach (GetModuleEvents("main", "OnGetRatingContentOwner", true) as $arEvent)
{
$result = ExecuteModuleEventEx($arEvent, [$arParam]);
if ($result !== false)
{
$arParam['OWNER_ID'] = (int)$result;
}
}
$rowAffected = $DB->Update("b_rating_voting", $arFields, "WHERE ENTITY_TYPE_ID='" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "' AND ENTITY_ID='" . (int)$arParam['ENTITY_ID'] . "'");
if ($rowAffected > 0)
{
$rsRV = $DB->Query("SELECT ID, TOTAL_POSITIVE_VOTES FROM b_rating_voting WHERE ENTITY_TYPE_ID='" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "' AND ENTITY_ID='" . (int)$arParam['ENTITY_ID'] . "'");
$arRV = $rsRV->Fetch();
$arParam['RATING_VOTING_ID'] = $arRV['ID'];
$arParam['TOTAL_POSITIVE_VOTES'] = $arRV['TOTAL_POSITIVE_VOTES'];
$arParam['REACTIONS_LIST'] = [
self::REACTION_DEFAULT => (int)$arParam['TOTAL_POSITIVE_VOTES'],
];
if ($votePlus)
{
$rsRVR = $DB->Query("SELECT TOTAL_VOTES FROM b_rating_voting_reaction WHERE ENTITY_TYPE_ID='" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "' AND ENTITY_ID='" . (int)$arParam['ENTITY_ID'] . "'");
if (!($arRVR = $rsRVR->fetch())) // reactions not initialized
{
$merge = $helper->prepareMerge('b_rating_voting_reaction', ['ENTITY_TYPE_ID', 'ENTITY_ID', 'REACTION'], [
'ENTITY_TYPE_ID' => $arParam['ENTITY_TYPE_ID'],
'ENTITY_ID' => $arParam['ENTITY_ID'],
'REACTION' => self::REACTION_DEFAULT,
'TOTAL_VOTES' => $arRV['TOTAL_POSITIVE_VOTES'],
], [
'TOTAL_VOTES' => $arRV['TOTAL_POSITIVE_VOTES'],
]);
if ($merge[0])
{
$DB->query($merge[0]);
}
}
$merge = $helper->prepareMerge('b_rating_voting_reaction', ['ENTITY_TYPE_ID', 'ENTITY_ID', 'REACTION'], [
'ENTITY_TYPE_ID' => $arParam['ENTITY_TYPE_ID'],
'ENTITY_ID' => $arParam['ENTITY_ID'],
'REACTION' => $arParam['REACTION'],
'TOTAL_VOTES' => 1,
], [
'TOTAL_VOTES' => new \Bitrix\Main\DB\SqlExpression('b_rating_voting_reaction.TOTAL_VOTES + 1'),
]);
if ($merge[0])
{
$DB->query($merge[0]);
}
}
}
else
{
$arFields = [
"ENTITY_TYPE_ID" => "'" . $DB->ForSql($arParam["ENTITY_TYPE_ID"]) . "'",
"ENTITY_ID" => (int)$arParam['ENTITY_ID'],
"OWNER_ID" => (int)$arParam['OWNER_ID'],
"ACTIVE" => "'Y'",
"CREATED" => $DB->GetNowFunction(),
"LAST_CALCULATED" => $DB->GetNowFunction(),
"TOTAL_VOTES" => 1,
"TOTAL_VALUE" => (float)$arParam['VALUE'],
"TOTAL_POSITIVE_VOTES" => ($votePlus ? 1 : 0),
"TOTAL_NEGATIVE_VOTES" => ($votePlus ? 0 : 1),
];
$arParam['RATING_VOTING_ID'] = $DB->Insert("b_rating_voting", $arFields);
$arParam['TOTAL_POSITIVE_VOTES'] = ($votePlus ? 1 : 0);
$arParam['REACTIONS_LIST'] = [
self::REACTION_DEFAULT => (int)$arParam['TOTAL_POSITIVE_VOTES'],
];
if ($votePlus)
{
$merge = $helper->prepareMerge('b_rating_voting_reaction', ['ENTITY_TYPE_ID', 'ENTITY_ID', 'REACTION'], [
'ENTITY_TYPE_ID' => $arParam['ENTITY_TYPE_ID'],
'ENTITY_ID' => $arParam['ENTITY_ID'],
'REACTION' => $arParam['REACTION'],
'TOTAL_VOTES' => 1,
], [
'TOTAL_VOTES' => 1,
]);
if ($merge[0])
{
$DB->query($merge[0]);
}
}
}
$rsRVR = $DB->Query("SELECT REACTION, TOTAL_VOTES FROM b_rating_voting_reaction WHERE ENTITY_TYPE_ID='" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "' AND ENTITY_ID='" . (int)$arParam['ENTITY_ID'] . "'");
while ($arRVR = $rsRVR->fetch())
{
$arParam['REACTIONS_LIST'][$arRVR['REACTION']] = $arRVR['TOTAL_VOTES'];
}
$arFields = [
"RATING_VOTING_ID" => (int)$arParam['RATING_VOTING_ID'],
"ENTITY_TYPE_ID" => "'" . $DB->ForSql($arParam["ENTITY_TYPE_ID"]) . "'",
"ENTITY_ID" => (int)$arParam['ENTITY_ID'],
"VALUE" => (float)$arParam['VALUE'],
"ACTIVE" => "'Y'",
"CREATED" => $DB->GetNowFunction(),
"USER_ID" => (int)$arParam['USER_ID'],
"USER_IP" => "'" . $DB->ForSql($arParam["USER_IP"]) . "'",
"OWNER_ID" => (int)$arParam['OWNER_ID'],
"REACTION" => "'" . $DB->ForSql($arParam["REACTION"]) . "'",
];
$ID = $DB->Insert("b_rating_vote", $arFields);
foreach (GetModuleEvents("main", "OnAddRatingVote", true) as $arEvent)
{
ExecuteModuleEventEx($arEvent, [(int)$ID, $arParam]);
}
$userData = static::getUserData((int)$arParam['USER_ID'], (float)$arParam['VALUE']);
if (CModule::IncludeModule('pull'))
{
CPullStack::AddShared([
'module_id' => 'main',
'command' => 'rating_vote',
'params' => [
"TYPE" => "ADD",
"USER_ID" => (int)$arParam['USER_ID'],
"ENTITY_TYPE_ID" => $arParam["ENTITY_TYPE_ID"],
"ENTITY_ID" => (int)$arParam['ENTITY_ID'],
"TOTAL_POSITIVE_VOTES" => $arParam['TOTAL_POSITIVE_VOTES'],
"RESULT" => $votePlus ? 'PLUS' : 'MINUS',
"USER_DATA" => $userData,
"REACTION" => $arParam['REACTION'],
"REACTIONS_LIST" => $arParam['REACTIONS_LIST'],
],
]);
}
if (CACHED_b_rating_vote !== false)
{
$bucket_size = (int)CACHED_b_rating_bucket_size;
if ($bucket_size <= 0)
{
$bucket_size = 100;
}
$bucket = (int)((int)$arParam['ENTITY_ID'] / $bucket_size);
$CACHE_MANAGER->Clean("b_rvg_" . $DB->ForSql($arParam["ENTITY_TYPE_ID"]) . $bucket, "b_rating_voting");
}
return $userData;
}
public static function ChangeRatingVote($arParam)
{
global $DB, $CACHE_MANAGER;
$connection = \Bitrix\Main\Application::getConnection();
$helper = $connection->getSqlHelper();
$arParam['ENTITY_TYPE_ID'] = mb_substr($arParam['ENTITY_TYPE_ID'], 0, 50);
$arParam['REACTION'] = ($arParam['REACTION'] <> '' ? $arParam['REACTION'] : self::REACTION_DEFAULT);
$userData = static::getUserData((int)$arParam['USER_ID'], (float)$arParam['VALUE']);
$sqlStr = "
SELECT
RVG.ID,
RV.ID AS VOTE_ID,
RV.REACTION AS REACTION,
RV.VALUE AS VOTE_VALUE,
RVG.TOTAL_POSITIVE_VOTES
FROM
b_rating_voting RVG,
b_rating_vote RV
WHERE
RVG.ENTITY_TYPE_ID = '" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "'
and RVG.ENTITY_ID = " . (int)$arParam['ENTITY_ID'] . "
and RVG.ID = RV.RATING_VOTING_ID
and RV.USER_ID = " . (int)$arParam['USER_ID'];
$res = $DB->Query($sqlStr);
if ($arVote = $res->Fetch())
{
// GetOwnerDocument
$arParam['OWNER_ID'] = 0;
foreach (GetModuleEvents("main", "OnGetRatingContentOwner", true) as $arEvent)
{
$result = ExecuteModuleEventEx($arEvent, [$arParam]);
if ($result !== false)
{
$arParam['OWNER_ID'] = (int)$result;
}
}
$votePlus = $arVote['VOTE_VALUE'] >= 0 ? true : false;
$arVote['REACTION_OLD'] = ($arVote['REACTION'] <> '' ? $arVote['REACTION'] : self::REACTION_DEFAULT);
if (!$votePlus)
{
return false;
}
$rsRV = $DB->Query("SELECT ID, TOTAL_POSITIVE_VOTES FROM b_rating_voting WHERE ENTITY_TYPE_ID='" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "' AND ENTITY_ID='" . (int)$arParam['ENTITY_ID'] . "'");
if ($arRV = $rsRV->Fetch())
{
$arParam['RATING_VOTING_ID'] = $arRV['ID'];
$arParam['TOTAL_POSITIVE_VOTES'] = $arRV['TOTAL_POSITIVE_VOTES'];
$arParam['REACTIONS_LIST'] = [
self::REACTION_DEFAULT => (int)$arParam['TOTAL_POSITIVE_VOTES'],
];
}
else
{
return false;
}
$rsRVR = $DB->Query("SELECT TOTAL_VOTES FROM b_rating_voting_reaction WHERE ENTITY_TYPE_ID='" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "' AND ENTITY_ID='" . (int)$arParam['ENTITY_ID'] . "'");
if (!($arRVR = $rsRVR->fetch())) // reactions not initialized
{
$merge = $helper->prepareMerge('b_rating_voting_reaction', ['ENTITY_TYPE_ID', 'ENTITY_ID', 'REACTION'], [
'ENTITY_TYPE_ID' => $arParam['ENTITY_TYPE_ID'],
'ENTITY_ID' => $arParam['ENTITY_ID'],
'REACTION' => self::REACTION_DEFAULT,
'TOTAL_VOTES' => $arRV['TOTAL_POSITIVE_VOTES'],
], [
'TOTAL_VOTES' => $arRV['TOTAL_POSITIVE_VOTES'],
]);
if ($merge[0])
{
$DB->query($merge[0]);
}
}
$merge = $helper->prepareMerge('b_rating_voting_reaction', ['ENTITY_TYPE_ID', 'ENTITY_ID', 'REACTION'], [
'ENTITY_TYPE_ID' => $arParam['ENTITY_TYPE_ID'],
'ENTITY_ID' => $arParam['ENTITY_ID'],
'REACTION' => $arParam['REACTION'],
'TOTAL_VOTES' => 1,
], [
'TOTAL_VOTES' => new \Bitrix\Main\DB\SqlExpression('b_rating_voting_reaction.TOTAL_VOTES + 1'),
]);
if ($merge[0])
{
$DB->query($merge[0]);
}
if (!empty($arVote['REACTION_OLD']))
{
$DB->Query("UPDATE b_rating_voting_reaction SET TOTAL_VOTES = TOTAL_VOTES - 1 WHERE ENTITY_TYPE_ID = '" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "' AND ENTITY_ID = '" . (int)$arParam['ENTITY_ID'] . "' AND REACTION = '" . $DB->ForSql($arVote['REACTION_OLD']) . "'");
}
$rsRVR = $DB->Query("SELECT REACTION, TOTAL_VOTES FROM b_rating_voting_reaction WHERE ENTITY_TYPE_ID='" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "' AND ENTITY_ID='" . (int)$arParam['ENTITY_ID'] . "'");
while ($arRVR = $rsRVR->fetch())
{
$arParam['REACTIONS_LIST'][$arRVR['REACTION']] = $arRVR['TOTAL_VOTES'];
}
$arFields = [
"CREATED" => $DB->GetNowFunction(),
"USER_IP" => "'" . $DB->ForSql($arParam["USER_IP"]) . "'",
"REACTION" => "'" . $DB->ForSql($arParam["REACTION"]) . "'",
];
$ID = $DB->Update("b_rating_vote", $arFields, "WHERE RATING_VOTING_ID=" . (int)$arParam['RATING_VOTING_ID'] . " AND USER_ID=" . (int)$arParam['USER_ID']);
if (!$ID)
{
return false;
}
foreach (GetModuleEvents("main", "OnChangeRatingVote", true) as $arEvent)
{
ExecuteModuleEventEx($arEvent, [(int)$ID, $arParam]);
}
if (CModule::IncludeModule('pull'))
{
CPullStack::AddShared([
'module_id' => 'main',
'command' => 'rating_vote',
'params' => [
"TYPE" => "CHANGE",
"USER_ID" => (int)$arParam['USER_ID'],
"ENTITY_TYPE_ID" => $arParam["ENTITY_TYPE_ID"],
"ENTITY_ID" => (int)$arParam['ENTITY_ID'],
"TOTAL_POSITIVE_VOTES" => $arParam['TOTAL_POSITIVE_VOTES'],
"RESULT" => 'CHANGE',
"USER_DATA" => $userData,
"REACTION" => $arParam['REACTION'],
"REACTION_OLD" => $arVote['REACTION'],
"REACTIONS_LIST" => $arParam['REACTIONS_LIST'],
],
]);
}
if (CACHED_b_rating_vote !== false)
{
$bucket_size = (int)CACHED_b_rating_bucket_size;
if ($bucket_size <= 0)
{
$bucket_size = 100;
}
$bucket = (int)((int)$arParam['ENTITY_ID'] / $bucket_size);
$CACHE_MANAGER->Clean("b_rvg_" . $DB->ForSql($arParam["ENTITY_TYPE_ID"]) . $bucket, "b_rating_voting");
}
}
return $userData;
}
public static function CancelRatingVote($arParam)
{
global $DB, $CACHE_MANAGER;
$connection = \Bitrix\Main\Application::getConnection();
$helper = $connection->getSqlHelper();
$sqlStr = "
SELECT
RVG.ID,
RV.ID AS VOTE_ID,
RV.REACTION AS REACTION,
RV.VALUE AS VOTE_VALUE,
RVG.TOTAL_POSITIVE_VOTES
FROM
b_rating_voting RVG,
b_rating_vote RV
WHERE
RVG.ENTITY_TYPE_ID = '" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "'
and RVG.ENTITY_ID = " . (int)$arParam['ENTITY_ID'] . "
and RVG.ID = RV.RATING_VOTING_ID
and RV.USER_ID = " . (int)$arParam['USER_ID'];
$res = $DB->Query($sqlStr);
if ($arVote = $res->Fetch())
{
$votePlus = $arVote['VOTE_VALUE'] >= 0 ? true : false;
$arVote['REACTION'] = ($arVote['REACTION'] <> '' ? $arVote['REACTION'] : self::REACTION_DEFAULT);
if ($votePlus)
{
$rsRVR = $DB->Query("SELECT TOTAL_VOTES FROM b_rating_voting_reaction WHERE ENTITY_TYPE_ID='" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "' AND ENTITY_ID='" . (int)$arParam['ENTITY_ID'] . "'");
if (!($arRVR = $rsRVR->fetch())) // reactions not initialized
{
$merge = $helper->prepareMerge('b_rating_voting_reaction', ['ENTITY_TYPE_ID', 'ENTITY_ID', 'REACTION'], [
'ENTITY_TYPE_ID' => $arParam['ENTITY_TYPE_ID'],
'ENTITY_ID' => $arParam['ENTITY_ID'],
'REACTION' => self::REACTION_DEFAULT,
'TOTAL_VOTES' => $arVote['TOTAL_POSITIVE_VOTES'],
], [
'TOTAL_VOTES' => $arVote['TOTAL_POSITIVE_VOTES'],
]);
if ($merge[0])
{
$DB->query($merge[0]);
}
}
}
$arFields = [
'TOTAL_VOTES' => "TOTAL_VOTES-1",
'TOTAL_VALUE' => "TOTAL_VALUE" . ($votePlus ? '-' . (float)$arVote['VOTE_VALUE'] : '+' . (float)(-1 * $arVote['VOTE_VALUE'])),
'LAST_CALCULATED' => $DB->GetNowFunction(),
];
$arFields[($votePlus ? 'TOTAL_POSITIVE_VOTES' : 'TOTAL_NEGATIVE_VOTES')] = ($votePlus ? 'TOTAL_POSITIVE_VOTES-1' : 'TOTAL_NEGATIVE_VOTES-1');
$DB->Update("b_rating_voting", $arFields, "WHERE ID=" . (int)$arVote['ID']);
if ($votePlus)
{
$merge = $helper->prepareMerge('b_rating_voting_reaction', ['ENTITY_TYPE_ID', 'ENTITY_ID', 'REACTION'], [
'ENTITY_TYPE_ID' => $arParam['ENTITY_TYPE_ID'],
'ENTITY_ID' => $arParam['ENTITY_ID'],
'REACTION' => $arVote['REACTION'],
'TOTAL_VOTES' => 0,
], [
'TOTAL_VOTES' => new \Bitrix\Main\DB\SqlExpression('b_rating_voting_reaction.TOTAL_VOTES - 1'),
]);
if ($merge[0])
{
$DB->query($merge[0]);
}
}
$DB->Query("DELETE FROM b_rating_vote WHERE ID=" . (int)$arVote['VOTE_ID']);
$arParam['REACTIONS_LIST'] = [];
$rsRVR = $DB->Query("SELECT REACTION, TOTAL_VOTES FROM b_rating_voting_reaction WHERE ENTITY_TYPE_ID='" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "' AND ENTITY_ID='" . (int)$arParam['ENTITY_ID'] . "'");
while ($arRVR = $rsRVR->fetch())
{
$arParam['REACTIONS_LIST'][$arRVR['REACTION']] = $arRVR['TOTAL_VOTES'];
}
foreach (GetModuleEvents("main", "OnCancelRatingVote", true) as $arEvent)
{
ExecuteModuleEventEx($arEvent, [(int)$arVote['VOTE_ID'], $arParam]);
}
$userData = static::getUserData((int)$arParam['USER_ID'], (float)$arVote['VOTE_VALUE']);
if (CModule::IncludeModule('pull'))
{
CPullStack::AddShared([
'module_id' => 'main',
'command' => 'rating_vote',
'params' => [
"TYPE" => "CANCEL",
"USER_ID" => (int)$arParam['USER_ID'],
"ENTITY_TYPE_ID" => $arParam["ENTITY_TYPE_ID"],
"ENTITY_ID" => (int)$arParam['ENTITY_ID'],
"TOTAL_POSITIVE_VOTES" => (int)($arVote['TOTAL_POSITIVE_VOTES'] + ($votePlus ? -1 : 1)),
"RESULT" => $votePlus ? 'PLUS' : 'MINUS',
"USER_DATA" => $userData,
"REACTION" => $arVote['REACTION'],
"REACTIONS_LIST" => $arParam['REACTIONS_LIST'],
],
]);
}
if (CACHED_b_rating_vote !== false)
{
$bucket_size = (int)CACHED_b_rating_bucket_size;
if ($bucket_size <= 0)
{
$bucket_size = 100;
}
$bucket = (int)((int)$arParam['ENTITY_ID'] / $bucket_size);
$CACHE_MANAGER->Clean("b_rvg_" . $DB->ForSql($arParam["ENTITY_TYPE_ID"]) . $bucket, "b_rating_voting");
}
return $userData;
}
return false;
}
public static function UpdateRatingUserBonus($arParam)
{
global $DB;
$arParam['RATING_ID'] = (int)$arParam['RATING_ID'];
$arParam['ENTITY_ID'] = (int)$arParam['ENTITY_ID'];
$arParam['BONUS'] = (float)$arParam['BONUS'];
$arFields = [
'RATING_ID' => $arParam['RATING_ID'],
'ENTITY_ID' => $arParam['ENTITY_ID'],
'BONUS' => $arParam['BONUS'],
];
if (isset($arParam['VOTE_WEIGHT']))
{
$arFields['VOTE_WEIGHT'] = (float)$arParam['VOTE_WEIGHT'];
}
if (isset($arParam['VOTE_COUNT']))
{
$arFields['VOTE_COUNT'] = (int)$arParam['VOTE_COUNT'];
}
$rows = $DB->Update("b_rating_user", $arFields, "WHERE RATING_ID = " . $arParam['RATING_ID'] . " AND ENTITY_ID = " . $arParam['ENTITY_ID']);
if ($rows == 0)
{
$rsRB = $DB->Query("SELECT * FROM b_rating_user WHERE RATING_ID = " . $arParam['RATING_ID'] . " AND ENTITY_ID = " . $arParam['ENTITY_ID']);
if (!$rsRB->SelectedRowsCount())
{
$DB->Insert("b_rating_user", $arFields);
}
}
if (CACHED_b_rating_vote !== false)
{
global $CACHE_MANAGER;
$bucket_size = (int)CACHED_b_rating_bucket_size;
if ($bucket_size <= 0)
{
$bucket_size = 100;
}
$CACHE_MANAGER->Clean("b_rvu_" . $arParam['RATING_ID'] . (int)($arParam['ENTITY_ID'] / $bucket_size), "b_rating_user");
}
return true;
}
public static function GetRatingUserProp($ratingId, $entityId)
{
global $DB;
$ratingId = (int)$ratingId;
static $cache = [];
if (!array_key_exists($ratingId, $cache))
{
$cache[$ratingId] = [];
}
$arResult = [];
$arToSelect = [];
if (is_array($entityId))
{
foreach ($entityId as $value)
{
$value = (int)$value;
if ($value > 0)
{
if (array_key_exists($value, $cache[$ratingId]))
{
$arResult[$value] = $cache[$ratingId][$value];
}
else
{
$arResult[$value] = $cache[$ratingId][$value] = [];
$arToSelect[$value] = $value;
}
}
}
}
else
{
$value = (int)$entityId;
if ($value > 0)
{
if (isset($cache[$ratingId][$value]))
{
$arResult[$value] = $cache[$ratingId][$value];
}
else
{
$arResult[$value] = $cache[$ratingId][$value] = [];
$arToSelect[$value] = $value;
}
}
}
if (!empty($arToSelect))
{
$strSql = "
SELECT RATING_ID, ENTITY_ID, BONUS, VOTE_WEIGHT, VOTE_COUNT
FROM b_rating_user
WHERE RATING_ID = '" . $ratingId . "' AND ENTITY_ID IN (" . implode(',', $arToSelect) . ")
";
$res = $DB->Query($strSql);
while ($arRes = $res->Fetch())
{
$arResult[$arRes["ENTITY_ID"]] = $cache[$ratingId][$arRes["ENTITY_ID"]] = $arRes;
}
}
if (!is_array($entityId) && !empty($arResult))
{
$arResult = array_pop($arResult);
}
return $arResult;
}
public static function GetRatingUserPropEx($ratingId, $entityId)
{
global $DB, $CACHE_MANAGER;
$ratingId = (int)$ratingId;
$entityId = (int)$entityId;
$arDefaultResult = [
"RATING_ID" => $ratingId,
"ENTITY_ID" => $entityId,
"BONUS" => 0,
"VOTE_WEIGHT" => 0,
"VOTE_COUNT" => 0,
];
if ($ratingId <= 0 || $entityId <= 0)
{
return $arDefaultResult;
}
$bucket_size = (int)CACHED_b_rating_bucket_size;
if ($bucket_size <= 0)
{
$bucket_size = 100;
}
$bucket = (int)($entityId / $bucket_size);
$arResult = $CACHE_MANAGER->Read(CACHED_b_rating, $cache_id = "b_rvu_" . $ratingId . $bucket, "b_rating_user");
if ($arResult)
{
$arResult = $CACHE_MANAGER->Get($cache_id);
}
if (!$arResult)
{
$sql_str = "
SELECT RATING_ID, ENTITY_ID, BONUS, VOTE_WEIGHT, VOTE_COUNT
FROM b_rating_user
WHERE RATING_ID = '" . $ratingId . "'
and ENTITY_ID between " . ($bucket * $bucket_size) . " AND " . (($bucket + 1) * $bucket_size - 1) . "
";
$res = $DB->Query($sql_str);
while ($arRes = $res->Fetch())
{
$arResult[$arRes["ENTITY_ID"]] = $arRes;
}
$CACHE_MANAGER->Set($cache_id, $arResult);
}
return $arResult[$entityId] ?? $arDefaultResult;
}
public static function GetAuthorityRating()
{
global $DB;
$authorityRatingId = COption::GetOptionString("main", "rating_authority_rating", null);
if (is_null($authorityRatingId))
{
$db_res = CRatings::GetList(["ID" => "ASC"], ["ENTITY_ID" => "USER", "AUTHORITY" => "Y"]);
$res = $db_res->Fetch();
$authorityRatingId = (int)$res['ID'];
COption::SetOptionString("main", "rating_authority_rating", $authorityRatingId);
}
return $authorityRatingId;
}
public static function GetWeightList($arSort = [], $arFilter = [])
{
global $DB;
$arSqlSearch = [];
$strSqlSearch = "";
if (is_array($arFilter))
{
foreach ($arFilter as $key => $val)
{
if ((string)$val == '' || $val === "NOT_REF")
{
continue;
}
switch (strtoupper($key))
{
case "ID":
$arSqlSearch[] = GetFilterQuery("RW.ID", $val, "N");
break;
case "RATING_FROM":
$arSqlSearch[] = GetFilterQuery("RW.RATING_FROM", $val, "N");
break;
case "RATING_TO":
$arSqlSearch[] = GetFilterQuery("RW.RATING_TO", $val, "N");
break;
case "WEIGHT":
$arSqlSearch[] = GetFilterQuery("RW.WEIGHT", $val, "N");
break;
case "COUNT":
$arSqlSearch[] = GetFilterQuery("RW.COUNT", $val, "N");
break;
case "MAX":
if (in_array($val, ['Y', 'N']))
{
$arSqlSearch[] = "R.MAX = '" . $val . "'";
}
break;
}
}
}
$sOrder = "";
foreach ($arSort as $key => $val)
{
$ord = (mb_strtoupper($val) <> "ASC" ? "DESC" : "ASC");
switch (mb_strtoupper($key))
{
case "ID":
$sOrder .= ", RW.ID " . $ord;
break;
case "RATING_FROM":
$sOrder .= ", RW.RATING_FROM " . $ord;
break;
case "RATING_TO":
$sOrder .= ", RW.RATING_TO " . $ord;
break;
case "WEIGHT":
$sOrder .= ", RW.WEIGHT " . $ord;
break;
case "COUNT":
$sOrder .= ", RW.COUNT " . $ord;
break;
}
}
if ($sOrder == '')
{
$sOrder = "RW.ID DESC";
}
$strSqlOrder = " ORDER BY " . trim($sOrder, ", ");
$strSqlSearch = GetFilterSqlSearch($arSqlSearch);
$strSql = "
SELECT
RW.ID, RW.RATING_FROM, RW.RATING_TO, RW.WEIGHT, RW.COUNT
FROM
b_rating_weight RW
WHERE
" . $strSqlSearch . "
" . $strSqlOrder;
return $DB->Query($strSql);
}
public static function SetWeight($arConfigs)
{
global $DB;
usort($arConfigs, ['CRatings', '__SortWeight']);
// prepare insert
$arAdd = [];
foreach ($arConfigs as $key => $arConfig)
{
//If the first condition is restricted to the bottom, otherwise we take the previous high value
if ($key == 0)
{
$arConfig['RATING_FROM'] = -1000000;
}
else
{
$arConfig['RATING_FROM'] = (float)$arConfigs[$key - 1]['RATING_TO'] + 0.0001;
}
// If this last condition is restricted to the top
if (!array_key_exists('RATING_TO', $arConfig))
{
$arConfig['RATING_TO'] = 1000000;
}
elseif ($arConfig['RATING_TO'] > 1000000)
{
$arConfig['RATING_TO'] = 1000000;
}
$arAdd[$key]['RATING_FROM'] = (float)$arConfig['RATING_FROM'];
$arAdd[$key]['RATING_TO'] = (float)$arConfig['RATING_TO'];
$arAdd[$key]['WEIGHT'] = (float)$arConfig['WEIGHT'];
$arAdd[$key]['COUNT'] = (int)$arConfig['COUNT'];
$arConfigs[$key] = $arAdd[$key];
}
// insert
$DB->Query("DELETE FROM b_rating_weight");
foreach ($arAdd as $key => $arFields)
{
$DB->Insert("b_rating_weight", $arFields);
}
return true;
}
public static function SetVoteGroup($arGroupId, $type)
{
global $DB, $CACHE_MANAGER;
if (!in_array($type, ['R', 'A']))
{
return false;
}
if (!is_array($arGroupId))
{
return false;
}
$arFields = [];
foreach ($arGroupId as $key => $value)
{
$arField = [];
$arField['GROUP_ID'] = (int)$value;
$arField['TYPE'] = "'" . $type . "'";
$arFields[$key] = $arField;
}
$DB->Query("DELETE FROM b_rating_vote_group WHERE TYPE = '" . $type . "'");
foreach ($arFields as $key => $arField)
{
$DB->Insert("b_rating_vote_group", $arField);
}
$CACHE_MANAGER->Clean("ratings_vg");
return true;
}
public static function GetVoteGroup($type = '')
{
global $DB;
$bAllType = false;
if (!in_array($type, ['R', 'A']))
{
$bAllType = true;
}
$strSql = "SELECT ID, GROUP_ID, TYPE FROM b_rating_vote_group RVG";
if (!$bAllType)
{
$strSql .= " WHERE TYPE = '" . $type . "'";
}
return $DB->Query($strSql);
}
public static function GetVoteGroupEx($type = '')
{
global $DB, $CACHE_MANAGER;
$res = $CACHE_MANAGER->Read(2592000, "ratings_vg");
if ($res)
{
$arResult = $CACHE_MANAGER->Get("ratings_vg");
}
else
{
$strSql = "SELECT GROUP_ID, TYPE FROM b_rating_vote_group RVG";
$res = $DB->Query($strSql);
while ($arRes = $res->Fetch($res))
{
$arResult[] = $arRes;
}
$CACHE_MANAGER->Set("ratings_vg", $arResult);
}
if ($type != '')
{
foreach ($arResult as $key => $value)
{
if ($value['TYPE'] != $type)
{
unset($arResult[$key]);
}
}
}
return $arResult;
}
public static function ClearData()
{
global $DB, $CACHE_MANAGER;
$DB->Query("TRUNCATE TABLE b_rating_prepare");
$DB->Query("TRUNCATE TABLE b_rating_voting_prepare");
$DB->Query("TRUNCATE TABLE b_rating_results");
$DB->Query("TRUNCATE TABLE b_rating_component_results");
$DB->Query("TRUNCATE TABLE b_rating_vote");
$DB->Query("TRUNCATE TABLE b_rating_voting");
$DB->Query("TRUNCATE TABLE b_rating_voting_reaction");
$DB->Query("UPDATE b_rating_user SET VOTE_WEIGHT = 0, VOTE_COUNT = 0");
$CACHE_MANAGER->CleanDir("b_rating_voting");
$CACHE_MANAGER->CleanDir("b_rating_user");
return true;
}
public static function OnUserDelete($ID)
{
CRatings::DeleteByUser($ID);
return true;
}
public static function OnAfterUserRegister($arFields)
{
global $DB;
if (isset($arFields['EXTERNAL_AUTH_ID']) && in_array($arFields['EXTERNAL_AUTH_ID'], \Bitrix\Main\UserTable::getExternalUserTypes(), true))
{
return false;
}
$userId = isset($arFields["USER_ID"]) ? (int)$arFields["USER_ID"] : (isset($arFields["ID"]) ? (int)$arFields["ID"] : 0);
if ($userId > 0)
{
$authorityRatingId = CRatings::GetAuthorityRating();
$ratingStartValue = COption::GetOptionString("main", "rating_start_authority", 3);
$ratingCountVote = COption::GetOptionString("main", "rating_count_vote", 10);
$arParam = [
'RATING_ID' => $authorityRatingId,
'ENTITY_ID' => $userId,
'BONUS' => (int)$ratingStartValue,
'VOTE_WEIGHT' => (int)$ratingStartValue * COption::GetOptionString("main", "rating_vote_weight", 1),
'VOTE_COUNT' => (int)$ratingCountVote + (int)$ratingStartValue,
];
CRatings::UpdateRatingUserBonus($arParam);
if (IsModuleInstalled("intranet"))
{
$strSql = "INSERT INTO b_rating_subordinate (RATING_ID, ENTITY_ID, VOTES) VALUES ('" . $authorityRatingId . "', '" . $userId . "', '" . ((int)$ratingCountVote + (int)$ratingStartValue) . "')";
$DB->Query($strSql);
}
$sRatingAssignType = COption::GetOptionString("main", "rating_assign_type", 'manual');
if ($sRatingAssignType === 'auto')
{
$assignRatingGroup = COption::GetOptionString("main", "rating_assign_rating_group", 0);
$assignAuthorityGroup = COption::GetOptionString("main", "rating_assign_authority_group", 0);
if ($assignRatingGroup == 0 && $assignAuthorityGroup == 0)
{
return false;
}
$arGroups = [];
if ($assignRatingGroup > 0)
{
$arGroups[] = (int)$assignRatingGroup;
}
if ($assignAuthorityGroup > 0 && $assignRatingGroup != $assignAuthorityGroup)
{
$arGroups[] = (int)$assignAuthorityGroup;
}
if (!empty($arGroups))
{
CUser::AppendUserGroup($userId, $arGroups);
}
}
if (CACHED_b_rating_vote !== false)
{
global $CACHE_MANAGER;
$bucket_size = (int)CACHED_b_rating_bucket_size;
if ($bucket_size <= 0)
{
$bucket_size = 100;
}
$bucket = (int)($userId / $bucket_size);
$CACHE_MANAGER->Clean("b_rvu_" . $authorityRatingId . $bucket, "b_rating_user");
}
}
}
public static function __SortWeight($a, $b)
{
if (isset($a['RATING_FROM']) || isset($b['RATING_FROM']))
{
return 1;
}
return (float)$a['RATING_TO'] < (float)$b['RATING_TO'] ? -1 : 1;
}
// check only general field
public static function __CheckFields($arFields)
{
$aMsg = [];
if (is_set($arFields, "NAME") && trim($arFields["NAME"]) == "")
{
$aMsg[] = ["id" => "NAME", "text" => GetMessage("RATING_GENERAL_ERR_NAME")];
}
if (is_set($arFields, "ACTIVE") && !($arFields["ACTIVE"] === 'Y' || $arFields["ACTIVE"] === 'N'))
{
$aMsg[] = ["id" => "ACTIVE", "text" => GetMessage("RATING_GENERAL_ERR_ACTIVE")];
}
if (is_set($arFields, "ENTITY_ID"))
{
$arObjects = CRatings::GetRatingObjects();
if (!in_array($arFields['ENTITY_ID'], $arObjects))
{
$aMsg[] = ["id" => "ENTITY_ID", "text" => GetMessage("RATING_GENERAL_ERR_ENTITY_ID")];
}
}
if (is_set($arFields, "CALCULATION_METHOD") && trim($arFields["CALCULATION_METHOD"]) == "")
{
$aMsg[] = ["id" => "CALCULATION_METHOD", "text" => GetMessage("RATING_GENERAL_ERR_CAL_METHOD")];
}
if (!empty($aMsg))
{
$e = new CAdminException($aMsg);
$GLOBALS["APPLICATION"]->ThrowException($e);
return false;
}
return true;
}
// creates a configuration record for each item rating
public static function __AddComponents($ID, $arFields)
{
global $DB;
$arRatingConfigs = CRatings::GetRatingConfigs($arFields["ENTITY_ID"], false);
$ID = (int)$ID;
foreach ($arFields['CONFIGS'] as $MODULE_ID => $RAT_ARRAY)
{
if (!is_array($RAT_ARRAY))
{
continue;
}
foreach ($RAT_ARRAY as $RAT_TYPE => $COMPONENT)
{
if (!is_array($COMPONENT))
{
continue;
}
foreach ($COMPONENT as $COMPONENT_NAME => $COMPONENT_VALUE)
{
if (!isset($arRatingConfigs[$MODULE_ID][$MODULE_ID . "_" . $RAT_TYPE . "_" . $COMPONENT_NAME]))
{
continue;
}
$arFields_i = [
"RATING_ID" => $ID,
"ACTIVE" => isset($COMPONENT_VALUE["ACTIVE"]) && $COMPONENT_VALUE["ACTIVE"] === 'Y' ? 'Y' : 'N',
"ENTITY_ID" => $arFields["ENTITY_ID"],
"MODULE_ID" => $MODULE_ID,
"RATING_TYPE" => $RAT_TYPE,
"NAME" => $COMPONENT_NAME,
"COMPLEX_NAME" => $arFields["ENTITY_ID"] . '_' . $MODULE_ID . '_' . $RAT_TYPE . '_' . $COMPONENT_NAME,
"CLASS" => $arRatingConfigs[$MODULE_ID][$MODULE_ID . "_" . $RAT_TYPE . "_" . $COMPONENT_NAME]["CLASS"],
"CALC_METHOD" => $arRatingConfigs[$MODULE_ID][$MODULE_ID . "_" . $RAT_TYPE . "_" . $COMPONENT_NAME]["CALC_METHOD"],
"EXCEPTION_METHOD" => $arRatingConfigs[$MODULE_ID][$MODULE_ID . "_" . $RAT_TYPE . "_" . $COMPONENT_NAME]["EXCEPTION_METHOD"],
"REFRESH_INTERVAL" => $arRatingConfigs[$MODULE_ID][$MODULE_ID . "_" . $RAT_TYPE . "_" . $COMPONENT_NAME]["REFRESH_TIME"],
"~LAST_MODIFIED" => $DB->GetNowFunction(),
"~NEXT_CALCULATION" => $DB->GetNowFunction(),
"IS_CALCULATED" => "N",
"~CONFIG" => "'" . serialize($COMPONENT_VALUE) . "'",
];
$DB->Add("b_rating_component", $arFields_i);
}
}
}
return true;
}
public static function __UpdateComponents($ID, $arFields)
{
global $DB;
$ID = (int)$ID;
$DB->Query("DELETE FROM b_rating_component WHERE RATING_ID=$ID");
CRatings::__AddComponents($ID, $arFields);
return true;
}
/**
* @deprecated Remove after forum 7b6fc9747453
*/
public static function err_mess()
{
return "";
}
public static function getRatingVoteReaction($arParam)
{
global $DB;
static $cache = [];
$bplus = (mb_strtoupper($arParam['LIST_TYPE']) !== 'MINUS');
$key = $arParam['ENTITY_TYPE_ID'] . '_' . (int)$arParam['ENTITY_ID'] . '_' . ($bplus ? '1' : '0');
if (
isset($arParam['USE_REACTIONS_CACHE'])
&& $arParam['USE_REACTIONS_CACHE'] === 'Y'
&& isset($cache[$key])
)
{
$result = $cache[$key];
}
else
{
$sqlStr = "
SELECT
REACTION,
COUNT(RV.ID) as CNT
FROM
b_rating_vote RV
WHERE
RV.ENTITY_TYPE_ID = '" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "'
AND RV.ENTITY_ID = " . (int)$arParam['ENTITY_ID'] . " " .
// ($bplus ? " AND RV.VALUE > 0 ": " and RV.VALUE < 0 ")
"GROUP BY REACTION";
$res_cnt = $DB->Query($sqlStr);
$cnt = 0;
$cntReactions = [];
while ($ar_cnt = $res_cnt->fetch())
{
$key = (!empty($ar_cnt["REACTION"]) ? $ar_cnt["REACTION"] : self::REACTION_DEFAULT);
if (!isset($cntReactions[$key]))
{
$cntReactions[$key] = 0;
}
$cntReactions[$key] += $ar_cnt["CNT"];
$cnt += $ar_cnt["CNT"];
}
$result = $cache[$key] = [
'items_all' => $cnt,
'reactions' => $cntReactions,
];
}
return $result;
}
public static function getRatingVoteList($arParam)
{
global $USER;
$reactionResult = self::GetRatingVoteReaction($arParam);
$cnt = $reactionResult['items_all'];
$cntReactions = $reactionResult['reactions'];
$bplus = (mb_strtoupper($arParam['LIST_TYPE']) !== 'MINUS');
$bIntranetInstalled = IsModuleInstalled("intranet");
$bExtended = false;
$arUserID = [];
$includeReaction = ($arParam['INCLUDE_REACTION'] ?? 'N') === 'Y';
if (
(
array_key_exists("USER_FIELDS", $arParam)
&& is_array($arParam["USER_FIELDS"])
)
|| (
array_key_exists("USER_SELECT", $arParam)
&& is_array($arParam["USER_SELECT"])
)
)
{
$bExtended = true;
$sqlStr = CRatings::GetRatingVoteListSQLExtended($arParam, $bplus, $bIntranetInstalled, $includeReaction);
}
else
{
$sqlStr = CRatings::GetRatingVoteListSQL($arParam, $bplus, $bIntranetInstalled, $includeReaction);
}
$arList = [];
$arVoteList = [];
if ($arParam['LIST_LIMIT'] != 0 && ceil($cnt / (int)$arParam['LIST_LIMIT']) >= (int)$arParam['LIST_PAGE'])
{
$res = new CDBResult();
$res->NavQuery($sqlStr, $cnt, ['iNumPage' => (int)$arParam['LIST_PAGE'], 'nPageSize' => (int)$arParam['LIST_LIMIT']]);
while ($row = $res->Fetch())
{
$ar = $row;
if (!$bExtended)
{
$ar["PHOTO"] = $ar["PHOTO_SRC"] = '';
if (!empty($ar["PERSONAL_PHOTO"]))
{
$arFileTmp = CFile::ResizeImageGet(
$row["PERSONAL_PHOTO"],
['width' => 58, 'height' => 58],
BX_RESIZE_IMAGE_EXACT,
false
);
$ar['PHOTO'] = CFile::ShowImage($arFileTmp['src'], 21, 21, 'border=0');
$ar['PHOTO_SRC'] = $arFileTmp['src'];
}
$ar['FULL_NAME'] = CUser::FormatName(CSite::GetNameFormat(false), $row, true);
}
else
{
$arUserID[] = $row["ID"];
}
if ($ar['ID'] != $USER->GetId())
{
$arList[$ar['ID']] = $ar;
}
else
{
$arVoteList[$ar['ID']] = $ar;
}
}
foreach ($arList as $ar)
{
$arVoteList[$ar['ID']] = $ar;
}
if (
$bExtended
&& !empty($arUserID)
)
{
$arUserListParams = [];
$arUsers = [];
$arUserListParams["FIELDS"] = (
array_key_exists("USER_FIELDS", $arParam)
&& is_array($arParam["USER_FIELDS"])
? $arParam["USER_FIELDS"]
: ["NAME", "LAST_NAME", "SECOND_NAME", "LOGIN", "PERSONAL_PHOTO"]
);
$arUserListParams["FIELDS"] = array_unique(array_merge(["ID"], $arUserListParams["FIELDS"]));
if (
array_key_exists("USER_SELECT", $arParam)
&& is_array($arParam["USER_SELECT"])
)
{
$arUserListParams["SELECT"] = $arParam["USER_SELECT"];
}
$rsUser = CUser::GetList(
"ID",
"ASC",
["ID" => implode("|", $arUserID)],
$arUserListParams
);
while ($arUser = $rsUser->Fetch())
{
$arUser["PHOTO"] = $arUser["PHOTO_SRC"] = '';
if (array_key_exists("PERSONAL_PHOTO", $arUser))
{
$arFileTmp = CFile::ResizeImageGet(
$arUser["PERSONAL_PHOTO"],
["width" => 58, "height" => 58],
BX_RESIZE_IMAGE_EXACT,
false
);
$arUser["PHOTO_SRC"] = $arFileTmp["src"];
$arUser["PHOTO"] = CFile::ShowImage($arFileTmp["src"], 21, 21, "border=0");
}
$arUser["FULL_NAME"] = CUser::FormatName(CSite::GetNameFormat(false), $arUser, true);
$arUsers[$arUser["ID"]] = $arUser;
}
foreach ($arVoteList as $i => $arVoteUser)
{
if (array_key_exists($arVoteUser["ID"], $arUsers))
{
foreach ($arUsers[$arVoteUser["ID"]] as $key => $value)
{
$arVoteList[$i][$key] = $value;
}
}
}
}
}
return [
'items_all' => $cnt,
'items_page' => count($arVoteList),
'items' => $arVoteList,
'reactions' => $cntReactions,
'list_page' => isset($arParam['LIST_PAGE']) ? (int)$arParam['LIST_PAGE'] : 0,
];
}
public static function getUserWeight($userId = 0)
{
$result = 0;
if (!\Bitrix\Main\ModuleManager::isModuleInstalled('intranet'))
{
return $result;
}
$userId = (
!empty($userId)
? (int)$userId
: 0
);
if ($userId <= 0)
{
return $result;
}
$ratingId = \CRatings::getAuthorityRating();
if ((int)$ratingId <= 0)
{
return $result;
}
$res = \Bitrix\Main\Application::getConnection()->query('SELECT MAX(VOTES) AS VOTES FROM b_rating_subordinate WHERE RATING_ID = ' . $ratingId . ' AND ENTITY_ID = ' . $userId);
if ($record = $res->fetch())
{
$result = (float)$record['VOTES'];
}
return $result;
}
public static function getUserData($userId = 0, $value = 0)
{
$result = [];
$userId = (
!empty($userId)
? (int)$userId
: 0
);
if ($userId <= 0)
{
return $result;
}
$res = \CUser::getById($userId);
if ($userFields = $res->fetch())
{
$result = [
'NAME_FORMATTED' => \CUser::formatName(
\CSite::getNameFormat(false),
[
'NAME' => $userFields["NAME"],
'LAST_NAME' => $userFields["LAST_NAME"],
'SECOND_NAME' => $userFields["SECOND_NAME"],
'LOGIN' => $userFields["LOGIN"],
],
true
),
'PERSONAL_PHOTO' => [
'ID' => $userFields["PERSONAL_PHOTO"],
'SRC' => false,
],
"WEIGHT" => (
\Bitrix\Main\ModuleManager::isModuleInstalled('intranet')
? self::getUserWeight($userId)
: $value
),
];
if ((int)$userFields['PERSONAL_PHOTO'] > 0)
{
$imageFile = \CFile::getFileArray($userFields["PERSONAL_PHOTO"]);
if ($imageFile !== false)
{
$file = \CFile::resizeImageGet(
$imageFile,
["width" => 100, "height" => 100],
BX_RESIZE_IMAGE_EXACT,
false
);
$result['PERSONAL_PHOTO']['SRC'] = $file['src'];
}
}
}
return $result;
}
public static function getEntityRatingData($params = [])
{
global $USER;
$connection = \Bitrix\Main\Application::getConnection();
$helper = $connection->getSqlHelper();
$result = [];
$entityTypeId = (
!empty($params['entityTypeId'])
? $params['entityTypeId']
: ''
);
$entityIdList = (
!empty($params['entityId'])
? $params['entityId']
: []
);
if (!is_array($entityIdList))
{
$entityIdList = [$entityIdList];
}
if (empty($entityIdList))
{
return $result;
}
$ratingId = \CRatings::getAuthorityRating();
if ((int)$ratingId <= 0)
{
return $result;
}
$topCount = (
isset($params['topCount'])
? (int)$params['topCount']
: 0
);
if ($topCount <= 0)
{
$topCount = 2;
}
if ($topCount > 5)
{
$topCount = 5;
}
$avatarSize = (
isset($params['avatarSize'])
? (int)$params['avatarSize']
: 100
);
if (\Bitrix\Main\ModuleManager::isModuleInstalled('intranet'))
{
$res = $connection->query("
SELECT
RS1.ENTITY_ID as USER_ID,
RV1.ENTITY_ID as ENTITY_ID,
MAX(RS1.VOTES) as WEIGHT
FROM
b_rating_subordinate RS1,
b_rating_vote RV1
WHERE
RS1.ENTITY_ID = RV1.USER_ID
AND RS1.RATING_ID = " . (int)$ratingId . "
AND RV1.ENTITY_TYPE_ID = '" . $helper->forSQL($entityTypeId) . "'
AND RV1.ENTITY_ID IN (" . implode(',', $entityIdList) . ")
GROUP BY
RV1.ENTITY_ID, RS1.ENTITY_ID
ORDER BY
RV1.ENTITY_ID,
WEIGHT DESC
");
}
else
{
$res = $connection->query("
SELECT
RV1.USER_ID as USER_ID,
RV1.ENTITY_ID as ENTITY_ID,
RV1.VALUE as WEIGHT
FROM
b_rating_vote RV1
WHERE
RV1.ENTITY_TYPE_ID = '" . $helper->forSQL($entityTypeId) . "'
AND RV1.ENTITY_ID IN (" . implode(',', $entityIdList) . ")
ORDER BY
RV1.ENTITY_ID,
WEIGHT DESC
");
}
$userWeightData = $entityUserData = [];
$currentEntityId = false;
$hasMine = false;
while ($voteFields = $res->fetch())
{
if (
!$hasMine
&& $voteFields['USER_ID'] == $USER->getId()
)
{
$hasMine = true;
}
if ($voteFields['ENTITY_ID'] != $currentEntityId)
{
$cnt = 0;
$hasMine = false;
$entityUserData[$voteFields['ENTITY_ID']] = [];
}
$currentEntityId = $voteFields['ENTITY_ID'];
$cnt++;
if ($cnt > ($hasMine ? $topCount + 1 : $topCount))
{
continue;
}
$entityUserData[$voteFields['ENTITY_ID']][] = $voteFields['USER_ID'];
if (!isset($userWeightData[$voteFields['USER_ID']]))
{
$userWeightData[$voteFields['USER_ID']] = (float)$voteFields['WEIGHT'];
}
}
$userData = [];
if (!empty($userWeightData))
{
$res = \Bitrix\Main\UserTable::getList([
'filter' => [
'@ID' => array_keys($userWeightData),
],
'select' => ['ID', 'NAME', 'LAST_NAME', 'SECOND_NAME', 'LOGIN', 'PERSONAL_PHOTO', 'PERSONAL_GENDER'],
]);
while ($userFields = $res->fetch())
{
$userData[$userFields["ID"]] = [
'NAME_FORMATTED' => \CUser::formatName(
\CSite::getNameFormat(false),
$userFields,
true
),
'PERSONAL_PHOTO' => [
'ID' => $userFields['PERSONAL_PHOTO'],
'SRC' => false,
],
'PERSONAL_GENDER' => $userFields['PERSONAL_GENDER'],
];
if ((int)$userFields['PERSONAL_PHOTO'] > 0)
{
$imageFile = \CFile::getFileArray($userFields["PERSONAL_PHOTO"]);
if ($imageFile !== false)
{
$file = \CFile::resizeImageGet(
$imageFile,
["width" => $avatarSize, "height" => $avatarSize],
BX_RESIZE_IMAGE_EXACT,
false
);
$userData[$userFields["ID"]]['PERSONAL_PHOTO']['SRC'] = $file['src'];
}
}
}
}
foreach ($entityUserData as $entityId => $userIdList)
{
$result[$entityId] = [];
foreach ($userIdList as $userId)
{
$result[$entityId][] = [
'ID' => $userId,
'NAME_FORMATTED' => $userData[$userId]['NAME_FORMATTED'],
'PERSONAL_PHOTO' => $userData[$userId]['PERSONAL_PHOTO']['ID'],
'PERSONAL_PHOTO_SRC' => $userData[$userId]['PERSONAL_PHOTO']['SRC'],
'PERSONAL_GENDER' => $userData[$userId]['PERSONAL_GENDER'],
'WEIGHT' => $userWeightData[$userId],
];
}
}
foreach ($result as $entityId => $data)
{
usort(
$data,
function ($a, $b) {
if ($a['WEIGHT'] == $b['WEIGHT'])
{
return 0;
}
return ($a['WEIGHT'] > $b['WEIGHT']) ? -1 : 1;
}
);
$result[$entityId] = $data;
}
return $result;
}
public static function deleteRatingVoting(array $params = [])
{
global $DB;
$entityTypeId = (
isset($params['ENTITY_TYPE_ID'])
&& $params['ENTITY_TYPE_ID'] <> ''
? $params['ENTITY_TYPE_ID']
: ''
);
$entityId = (
isset($params['ENTITY_ID'])
&& (int)$params['ENTITY_ID'] > 0
? (int)$params['ENTITY_ID']
: 0
);
if (
$entityTypeId == ''
|| $entityId <= 0
)
{
return;
}
$DB->query("DELETE FROM b_rating_vote WHERE ENTITY_TYPE_ID='" . $DB->forSql($entityTypeId) . "' AND ENTITY_ID=" . $entityId, true);
$DB->query("DELETE FROM b_rating_voting WHERE ENTITY_TYPE_ID='" . $DB->forSql($entityTypeId) . "' AND ENTITY_ID=" . $entityId, true);
$DB->query("DELETE FROM b_rating_voting_reaction WHERE ENTITY_TYPE_ID='" . $DB->forSql($entityTypeId) . "' AND ENTITY_ID=" . $entityId, true);
}
// building rating on computed components
public static function BuildRating($ID)
{
global $DB;
$connection = \Bitrix\Main\Application::getConnection();
$helper = $connection->getSqlHelper();
$ID = intval($ID);
$resRating = CRatings::GetByID($ID);
$arRating = $resRating->Fetch();
if ($arRating && $arRating['ACTIVE'] == 'Y')
{
$DB->Query("UPDATE b_rating SET CALCULATED = 'C' WHERE id = " . $ID);
// Insert new results
$sqlFunc = ($arRating['CALCULATION_METHOD'] == 'SUM') ? 'SUM' : 'AVG';
$strSql = "
INSERT INTO b_rating_results
(RATING_ID, ENTITY_TYPE_ID, ENTITY_ID, CURRENT_VALUE, PREVIOUS_VALUE)
SELECT
" . $ID . " RATING_ID,
'" . $arRating['ENTITY_ID'] . "' ENTITY_TYPE_ID,
RC.ENTITY_ID,
" . $sqlFunc . "(RC.CURRENT_VALUE) CURRENT_VALUE,
0 PREVIOUS_VALUE
FROM
b_rating_component_results RC LEFT JOIN b_rating_results RR ON RR.RATING_ID = RC.RATING_ID and RR.ENTITY_ID = RC.ENTITY_ID
WHERE
RC.RATING_ID = " . $ID . " and RR.ID IS NULL
GROUP BY RC.ENTITY_ID";
$DB->Query($strSql);
// Update current results
$strSql = $helper->prepareCorrelatedUpdate("b_rating_results", "RR", [
'PREVIOUS_VALUE' => 'case when RR.CURRENT_VALUE = RCR.CURRENT_VALUE then RR.PREVIOUS_VALUE else RR.CURRENT_VALUE end',
'CURRENT_VALUE' => 'RCR.CURRENT_VALUE',
], "
(SELECT '" . $arRating['ENTITY_ID'] . "' ENTITY_TYPE_ID, RC.ENTITY_ID, " . $sqlFunc . "(RC.CURRENT_VALUE) CURRENT_VALUE
FROM b_rating_component_results RC INNER JOIN b_rating_results RR on RR.RATING_ID = RC.RATING_ID and RR.ENTITY_ID = RC.ENTITY_ID
WHERE RC.RATING_ID = " . $ID . "
GROUP BY RC.ENTITY_ID
) as RCR
", "
RR.RATING_ID=" . $ID . "
and RR.ENTITY_TYPE_ID = RCR.ENTITY_TYPE_ID
and RR.ENTITY_ID = RCR.ENTITY_ID
"
);
$DB->Query($strSql);
// Calculation position in rating
if ($arRating['POSITION'] == 'Y')
{
$strSql = $helper->initRowNumber('nPos');
if ($strSql)
{
$DB->Query($strSql);
}
$strSql = $helper->prepareCorrelatedUpdate("b_rating_results", "RR", [
'PREVIOUS_POSITION' => 'case when RR.CURRENT_POSITION = RP.POSITION then RR.PREVIOUS_POSITION else RR.CURRENT_POSITION end',
'CURRENT_POSITION' => 'RP.POSITION',
], "
(SELECT ENTITY_TYPE_ID, ENTITY_ID, CURRENT_VALUE, " . $helper->getRowNumber('nPos') . " as POSITION
FROM b_rating_results
WHERE RATING_ID = " . $ID . "
ORDER BY CURRENT_VALUE DESC
) as RP
", "
RR.RATING_ID=" . $ID . "
and RR.ENTITY_TYPE_ID = RP.ENTITY_TYPE_ID
and RR.ENTITY_ID = RP.ENTITY_ID
"
);
$DB->Query($strSql);
}
// Insert new user rating prop
$strSql = "
INSERT INTO b_rating_user
(RATING_ID, ENTITY_ID)
SELECT
" . $ID . " RATING_ID,
U.ID as ENTITY_ID
FROM
b_user U
LEFT JOIN b_rating_user RU ON RU.RATING_ID = " . $ID . " and RU.ENTITY_ID = U.ID
WHERE
U.ACTIVE = 'Y'
AND (CASE WHEN U.EXTERNAL_AUTH_ID IN ('" . join("', '", \Bitrix\Main\UserTable::getExternalUserTypes()) . "') THEN 'Y' ELSE 'N' END) = 'N'
AND RU.ID IS NULL ";
$DB->Query($strSql);
// authority calc
if ($arRating['AUTHORITY'] == 'Y')
{
$sRatingAssignType = COption::GetOptionString("main", "rating_assign_type", "manual");
if ($sRatingAssignType == 'auto')
{
// auto assign for rating group
$assignRatingGroup = COption::GetOptionString("main", "rating_assign_rating_group", 0);
$assignRatingValueAdd = COption::GetOptionString("main", "rating_assign_rating_group_add", 1);
$assignRatingValueDelete = COption::GetOptionString("main", "rating_assign_rating_group_delete", 1);
CRatings::AutoAssignGroup($assignRatingGroup, $assignRatingValueAdd, $assignRatingValueDelete);
// auto assign for authority group
$assignAuthorityGroup = COption::GetOptionString("main", "rating_assign_authority_group", 0);
$assignAuthorityValueAdd = COption::GetOptionString("main", "rating_assign_authority_group_add", 2);
$assignAuthorityValueDelete = COption::GetOptionString("main", "rating_assign_authority_group_delete", 2);
CRatings::AutoAssignGroup($assignAuthorityGroup, $assignAuthorityValueAdd, $assignAuthorityValueDelete);
}
$sRatingWeightType = COption::GetOptionString("main", "rating_weight_type", "auto");
if ($sRatingWeightType == 'auto')
{
$arCI = CRatings::GetCommunityInfo($ID);
$communitySize = $arCI['COMMUNITY_SIZE'];
$communityAuthority = $arCI['COMMUNITY_AUTHORITY'];
$sRatingNormalizationType = COption::GetOptionString("main", "rating_normalization_type", "auto");
if ($sRatingNormalizationType == 'manual')
{
$ratingNormalization = COption::GetOptionString("main", "rating_normalization", 1000);
}
else
{
if ($communitySize <= 10)
{
$ratingNormalization = 10;
}
elseif ($communitySize <= 1000)
{
$ratingNormalization = 100;
}
else
{
$ratingNormalization = 1000;
}
COption::SetOptionString("main", "rating_normalization", $ratingNormalization);
}
$voteWeight = 1;
if ($communitySize > 0)
{
$voteWeight = $ratingNormalization / $communitySize;
}
COption::SetOptionString("main", "rating_community_size", $communitySize);
COption::SetOptionString("main", "rating_community_authority", $communityAuthority);
COption::SetOptionString("main", "rating_vote_weight", $voteWeight);
$ratingCountVote = COption::GetOptionString("main", "rating_count_vote", 10);
$strSql = "UPDATE b_rating_user SET VOTE_COUNT = 0, VOTE_WEIGHT =0 WHERE RATING_ID=" . $ID;
$DB->Query($strSql);
// default vote count + user authority
$strSql = $helper->prepareCorrelatedUpdate("b_rating_user", "RU", [
'VOTE_COUNT' => intval($ratingCountVote) . " + RP.CURRENT_VALUE",
'VOTE_WEIGHT' => "RP.CURRENT_VALUE * " . $voteWeight,
], "
(SELECT ENTITY_ID, CURRENT_VALUE
FROM b_rating_results
WHERE RATING_ID = " . $ID . "
) as RP
", "
RU.RATING_ID=" . $ID . "
and RU.ENTITY_ID = RP.ENTITY_ID
"
);
$DB->Query($strSql);
}
else
{
// Depending on current authority set correct weight votes
// Depending on current authority set correct vote count
$strSql = "UPDATE b_rating_user SET VOTE_COUNT = 0, VOTE_WEIGHT =0 WHERE RATING_ID=" . $ID;
$DB->Query($strSql);
$strSql = $helper->prepareCorrelatedUpdate("b_rating_user", "RU", [
'VOTE_COUNT' => 'RP.COUNT',
'VOTE_WEIGHT' => 'RP.WEIGHT',
], "
(SELECT
RW.RATING_FROM, RW.RATING_TO, RW.WEIGHT, RW.COUNT, RR.ENTITY_ID
FROM
b_rating_weight RW,
b_rating_results RR
WHERE
RR.RATING_ID = " . $ID . "
and RR.CURRENT_VALUE BETWEEN RW.RATING_FROM AND RW.RATING_TO
) as RP
", "
RU.RATING_ID=" . $ID . "
and RU.ENTITY_ID = RP.ENTITY_ID
"
);
$DB->Query($strSql);
}
}
global $CACHE_MANAGER;
$CACHE_MANAGER->CleanDir("b_rating_user");
$DB->Query("UPDATE b_rating SET CALCULATED = 'Y', LAST_CALCULATED = " . $DB->GetNowFunction() . " WHERE id = " . $ID);
}
return true;
}
public static function DeleteByUser($ID)
{
global $CACHE_MANAGER;
$connection = \Bitrix\Main\Application::getConnection();
$helper = $connection->getSqlHelper();
$ID = intval($ID);
$strSql = $helper->prepareCorrelatedUpdate("b_rating_voting_reaction", "RVR", [
'TOTAL_VOTES' => 'RP.TOTAL_POSITIVE_VOTES',
], "
(SELECT
ENTITY_TYPE_ID,
ENTITY_ID,
SUM(case when VALUE > 0 AND USER_ID <> $ID then 1 else 0 end) as TOTAL_POSITIVE_VOTES
FROM b_rating_vote
WHERE RATING_VOTING_ID IN (
SELECT DISTINCT RV0.RATING_VOTING_ID FROM b_rating_vote RV0 WHERE RV0.USER_ID=$ID
)
GROUP BY RATING_VOTING_ID, ENTITY_TYPE_ID, ENTITY_ID
) as RP
", "
RVR.ENTITY_TYPE_ID = RP.ENTITY_TYPE_ID
AND RVR.ENTITY_ID = RP.ENTITY_ID
"
);
$connection->query($strSql);
$strSql = $helper->prepareCorrelatedUpdate("b_rating_voting", "RV", [
'TOTAL_VALUE' => 'RP.TOTAL_VALUE',
'TOTAL_VOTES' => 'RP.TOTAL_VOTES',
'TOTAL_POSITIVE_VOTES' => 'RP.TOTAL_POSITIVE_VOTES',
'TOTAL_NEGATIVE_VOTES' => 'RP.TOTAL_NEGATIVE_VOTES',
], "
(SELECT
RATING_VOTING_ID,
SUM(case when USER_ID <> $ID then VALUE else 0 end) as TOTAL_VALUE,
SUM(case when USER_ID <> $ID then 1 else 0 end) as TOTAL_VOTES,
SUM(case when VALUE > 0 AND USER_ID <> $ID then 1 else 0 end) as TOTAL_POSITIVE_VOTES,
SUM(case when VALUE < 0 AND USER_ID <> $ID then 1 else 0 end) as TOTAL_NEGATIVE_VOTES
FROM b_rating_vote
WHERE RATING_VOTING_ID IN (
SELECT DISTINCT RV0.RATING_VOTING_ID FROM b_rating_vote RV0 WHERE RV0.USER_ID=$ID
)
GROUP BY RATING_VOTING_ID
) as RP
", "
RV.ID = RP.RATING_VOTING_ID
"
);
$connection->query($strSql);
$connection->query("DELETE FROM b_rating_vote WHERE USER_ID = $ID");
$connection->query("DELETE FROM b_rating_user WHERE ENTITY_ID = $ID");
$CACHE_MANAGER->ClearByTag('RV_CACHE');
return true;
}
// insert result calculate rating
public static function AddResults($arResults)
{
global $DB;
// Only Mysql
$strSqlPrefix = "
INSERT INTO b_rating_results
(RATING_ID, ENTITY_TYPE_ID, ENTITY_ID, CURRENT_VALUE, PREVIOUS_VALUE)
VALUES
";
$maxValuesLen = 2048;
$strSqlValues = "";
foreach ($arResults as $arResult)
{
$strSqlValues .= ",\n(" . intval($arResult['RATING_ID']) . ", '" . $DB->ForSql($arResult['ENTITY_TYPE_ID']) . "', '" . $DB->ForSql($arResult['ENTITY_ID']) . "', '" . $DB->ForSql($arResult['CURRENT_VALUE']) . "', '" . $DB->ForSql($arResult['PREVIOUS_VALUE']) . "')";
if (mb_strlen($strSqlValues) > $maxValuesLen)
{
$DB->Query($strSqlPrefix . mb_substr($strSqlValues, 2));
$strSqlValues = "";
}
}
if ($strSqlValues <> '')
{
$DB->Query($strSqlPrefix . mb_substr($strSqlValues, 2));
}
return true;
}
// insert result calculate rating-components
public static function AddComponentResults($arComponentConfigs)
{
global $DB;
if (!is_array($arComponentConfigs))
{
return false;
}
$strSql = "
UPDATE b_rating_component
SET LAST_CALCULATED = " . $DB->GetNowFunction() . ",
NEXT_CALCULATION = '" . date('Y-m-d H:i:s', time() + $arComponentConfigs['REFRESH_INTERVAL']) . "'
WHERE RATING_ID = " . intval($arComponentConfigs['RATING_ID']) . " AND COMPLEX_NAME = '" . $DB->ForSql($arComponentConfigs['COMPLEX_NAME']) . "'";
$DB->Query($strSql);
return true;
}
public static function SetAuthorityRating($ratingId)
{
global $DB, $stackCacheManager;
$ratingId = intval($ratingId);
$DB->Query("UPDATE b_rating SET AUTHORITY = CASE WHEN ID <> $ratingId THEN 'N' ELSE 'Y' END");
COption::SetOptionString("main", "rating_authority_rating", $ratingId);
$stackCacheManager->Clear("b_rating");
return true;
}
public static function GetCommunityInfo($ratingId)
{
global $DB;
$connection = \Bitrix\Main\Application::getConnection();
$helper = $connection->getSqlHelper();
$bAllGroups = false;
$arGroups = [];
$communityLastVisit = COption::GetOptionString("main", "rating_community_last_visit", '90');
$res = CRatings::GetVoteGroup();
while ($arVoteGroup = $res->Fetch())
{
if ($arVoteGroup['GROUP_ID'] == 2)
{
$bAllGroups = true;
break;
}
$arGroups[] = $arVoteGroup['GROUP_ID'];
}
$strModulesSql = '';
if (IsModuleInstalled("forum"))
{
$strModulesSql .= "
SELECT USER_START_ID as ENTITY_ID
FROM b_forum_topic
WHERE START_DATE > " . $helper->addDaysToDateTime(-intval($communityLastVisit)) . "
GROUP BY USER_START_ID
UNION ALL
SELECT AUTHOR_ID as ENTITY_ID
FROM b_forum_message
WHERE POST_DATE > " . $helper->addDaysToDateTime(-intval($communityLastVisit)) . "
GROUP BY AUTHOR_ID
UNION ALL
";
}
if (IsModuleInstalled("blog"))
{
$strModulesSql .= "
SELECT AUTHOR_ID as ENTITY_ID
FROM b_blog_post
WHERE DATE_PUBLISH > " . $helper->addDaysToDateTime(-intval($communityLastVisit)) . "
GROUP BY AUTHOR_ID
UNION ALL
SELECT AUTHOR_ID as ENTITY_ID
FROM b_blog_comment
WHERE DATE_CREATE > " . $helper->addDaysToDateTime(-intval($communityLastVisit)) . "
GROUP BY AUTHOR_ID
UNION ALL";
}
if (IsModuleInstalled("intranet"))
{
$ratingId = COption::GetOptionString("main", "rating_authority_rating", 0);
$strModulesSql .= "
SELECT ENTITY_ID
FROM b_rating_subordinate
WHERE RATING_ID = $ratingId
UNION ALL";
}
if (!empty($strModulesSql))
{
$strModulesSql = "
(
" . $strModulesSql . "
SELECT USER_ID as ENTITY_ID
FROM b_rating_vote
WHERE CREATED > " . $helper->addDaysToDateTime(-intval($communityLastVisit)) . "
GROUP BY USER_ID
) MS,
";
}
// $DB->Query("TRUNCATE TABLE b_rating_prepare");
$DB->Query("DELETE FROM b_rating_prepare");
$strSql = '';
if ($bAllGroups || empty($arGroups))
{
$strSql .= "
INSERT INTO b_rating_prepare (ID)
SELECT DISTINCT U.ID
FROM " . $strModulesSql . "
b_user U
WHERE " . (!empty($strModulesSql) ? "U.ID = MS.ENTITY_ID AND" : "") . "
U.ACTIVE = 'Y'
AND (CASE WHEN U.EXTERNAL_AUTH_ID IN ('" . join("', '", \Bitrix\Main\UserTable::getExternalUserTypes()) . "') THEN 'Y' ELSE 'N' END) = 'N'
AND U.LAST_LOGIN >" . $helper->addDaysToDateTime(-intval($communityLastVisit)) . "
";
}
else
{
$strSql .= "
INSERT INTO b_rating_prepare (ID)
SELECT DISTINCT U.ID
FROM " . $strModulesSql . "
b_user U
WHERE " . (!empty($strModulesSql) ? "U.ID = MS.ENTITY_ID AND" : "") . "
U.ACTIVE = 'Y'
AND (CASE WHEN U.EXTERNAL_AUTH_ID IN ('" . join("', '", \Bitrix\Main\UserTable::getExternalUserTypes()) . "') THEN 'Y' ELSE 'N' END) = 'N'
AND U.LAST_LOGIN > " . $helper->addDaysToDateTime(-intval($communityLastVisit)) . "
";
}
$DB->Query($strSql);
$strSql = 'SELECT COUNT(*) as COMMUNITY_SIZE, SUM(CURRENT_VALUE) COMMUNITY_AUTHORITY
FROM b_rating_results RC LEFT JOIN b_rating_prepare TT ON RC.ENTITY_ID = TT.ID
WHERE RATING_ID = ' . intval($ratingId) . ' AND TT.ID IS NOT NULL';
$res = $DB->Query($strSql);
return $res->Fetch();
}
public static function CheckAllowVote($arVoteParam)
{
global $USER;
if (
isset($arVoteParam['CURRENT_USER_ID'])
&& (int)$arVoteParam['CURRENT_USER_ID'] > 0
)
{
$userId = (int)$arVoteParam['CURRENT_USER_ID'];
$bUserAuth = ($userId > 0);
}
else
{
$userId = (int)$USER?->GetId();
$bUserAuth = (bool)$USER?->IsAuthorized();
}
$arInfo = [
'RESULT' => true,
'ERROR_TYPE' => '',
'ERROR_MSG' => '',
];
$bSelfVote = COption::GetOptionString("main", "rating_self_vote", 'N');
if ($bSelfVote == 'N' && intval($arVoteParam['OWNER_ID']) == $userId)
{
$arInfo = [
'RESULT' => false,
'ERROR_TYPE' => 'SELF',
'ERROR_MSG' => GetMessage('RATING_ALLOW_VOTE_SELF'),
];
}
elseif (!$bUserAuth)
{
$arInfo = [
'RESULT' => false,
'ERROR_TYPE' => 'GUEST',
'ERROR_MSG' => GetMessage('RATING_ALLOW_VOTE_GUEST'),
];
}
else
{
static $cacheAllowVote = [];
static $cacheUserVote = [];
static $cacheVoteSize = 0;
if (!array_key_exists($userId, $cacheAllowVote))
{
global $DB;
$connection = \Bitrix\Main\Application::getConnection();
$helper = $connection->getSqlHelper();
$sVoteType = $arVoteParam['ENTITY_TYPE_ID'] == 'USER' ? 'A' : 'R';
$userVoteGroup = [];
$ar = CRatings::GetVoteGroupEx();
foreach ($ar as $group)
{
if ($sVoteType == $group['TYPE'])
{
$userVoteGroup[] = $group['GROUP_ID'];
}
}
$userGroup = $USER->GetUserGroupArray();
$result = array_intersect($userGroup, $userVoteGroup);
if (empty($result))
{
$arInfo = $cacheAllowVote[$userId] = [
'RESULT' => false,
'ERROR_TYPE' => 'ACCESS',
'ERROR_MSG' => GetMessage('RATING_ALLOW_VOTE_ACCESS'),
];
}
$authorityRatingId = CRatings::GetAuthorityRating();
$arAuthorityUserProp = CRatings::GetRatingUserPropEx($authorityRatingId, $userId);
if (
$arAuthorityUserProp['VOTE_WEIGHT'] < 0
|| (
$arAuthorityUserProp['VOTE_WEIGHT'] == 0
&& !IsModuleInstalled('intranet')
)
)
{
$arInfo = $cacheAllowVote[$userId] = [
'RESULT' => false,
'ERROR_TYPE' => 'ACCESS',
'ERROR_MSG' => GetMessage('RATING_ALLOW_VOTE_LOW_WEIGHT'),
];
}
if ($arInfo['RESULT'] && $sVoteType == 'A')
{
$strSql = '
SELECT COUNT(*) as VOTE
FROM b_rating_vote RV
WHERE RV.USER_ID = ' . $userId . '
AND RV.CREATED > ' . $helper->addDaysToDateTime(-1);
$res = $DB->Query($strSql);
$countVote = $res->Fetch();
$cacheVoteSize = \Bitrix\Main\Application::getInstance()->getSession()['RATING_VOTE_COUNT'] = $countVote['VOTE'];
$cacheUserVote[$userId] = \Bitrix\Main\Application::getInstance()->getSession()['RATING_USER_VOTE_COUNT'] = $arAuthorityUserProp['VOTE_COUNT'];
if ($cacheVoteSize >= $cacheUserVote[$userId])
{
$arInfo = $cacheAllowVote[$userId] = [
'RESULT' => false,
'ERROR_TYPE' => 'COUNT_VOTE',
'ERROR_MSG' => GetMessage('RATING_ALLOW_VOTE_COUNT_VOTE'),
];
}
}
}
else
{
if ($cacheAllowVote[$userId]['RESULT'])
{
if ($cacheVoteSize >= $cacheUserVote[$userId])
{
$cacheAllowVote[$userId] = [
'RESULT' => false,
'ERROR_TYPE' => 'COUNT_VOTE',
'ERROR_MSG' => GetMessage('RATING_ALLOW_VOTE_COUNT_VOTE'),
];
}
}
$arInfo = $cacheAllowVote[$userId];
}
}
static $handlers;
if (!isset($handlers))
{
$handlers = GetModuleEvents("main", "OnAfterCheckAllowVote", true);
}
foreach ($handlers as $arEvent)
{
$arEventResult = ExecuteModuleEventEx($arEvent, [$arVoteParam]);
if (is_array($arEventResult) && isset($arEventResult['RESULT']) && $arEventResult['RESULT'] === false
&& isset($arEventResult['ERROR_TYPE']) && $arEventResult['ERROR_TYPE'] <> ''
&& isset($arEventResult['ERROR_MSG']) && $arEventResult['ERROR_MSG'] <> '')
{
$arInfo = [
'RESULT' => false,
'ERROR_TYPE' => $arEventResult['ERROR_TYPE'],
'ERROR_MSG' => $arEventResult['ERROR_MSG'],
];
}
}
return $arInfo;
}
public static function SetAuthorityDefaultValue($arParams)
{
global $DB;
$rsRatings = CRatings::GetList(['ID' => 'ASC'], ['ENTITY_ID' => 'USER']);
$arRatingList = [];
while ($arRatingsTmp = $rsRatings->GetNext())
{
$arRatingList[] = $arRatingsTmp['ID'];
}
if (isset($arParams['DEFAULT_USER_ACTIVE']) && $arParams['DEFAULT_USER_ACTIVE'] == 'Y' && IsModuleInstalled("forum") && !empty($arRatingList))
{
$ratingStartValue = 0;
if (isset($arParams['DEFAULT_CONFIG_NEW_USER']) && $arParams['DEFAULT_CONFIG_NEW_USER'] == 'Y')
{
$ratingStartValue = COption::GetOptionString("main", "rating_start_authority", 3);
}
$strSql = "UPDATE b_rating_user SET BONUS = $ratingStartValue WHERE RATING_ID IN (" . implode(',', $arRatingList) . ")";
$DB->Query($strSql);
$strSql = "
UPDATE
b_rating_user RU,
( SELECT
TO_USER_ID as ENTITY_ID, COUNT(*) as CNT
FROM
b_forum_user_points FUP
GROUP BY TO_USER_ID
) as RP
SET
RU.BONUS = " . $DB->IsNull('RP.CNT', '0') . "+" . $ratingStartValue . "
WHERE
RU.RATING_ID IN (" . implode(',', $arRatingList) . ")
and RU.ENTITY_ID = RP.ENTITY_ID
";
$DB->Query($strSql);
}
else
{
if (isset($arParams['DEFAULT_CONFIG_NEW_USER']) && $arParams['DEFAULT_CONFIG_NEW_USER'] == 'Y' && !empty($arRatingList))
{
$ratingStartValue = COption::GetOptionString("main", "rating_start_authority", 3);
$strSql = "UPDATE b_rating_user SET BONUS = " . $ratingStartValue . " WHERE RATING_ID IN (" . implode(',', $arRatingList) . ")";
$DB->Query($strSql);
}
}
return true;
}
public static function AutoAssignGroup($groupId, $authorityValueAdd, $authorityValueDelete)
{
global $DB;
$groupId = intval($groupId);
if ($groupId == 0)
{
return false;
}
$ratingId = CRatings::GetAuthorityRating();
$ratingValueAdd = intval($authorityValueAdd);
$ratingValueDelete = intval($authorityValueDelete);
$sRatingWeightType = COption::GetOptionString("main", "rating_weight_type", "auto");
if ($sRatingWeightType == 'auto')
{
$ratingValueAdd = $ratingValueAdd * COption::GetOptionString("main", "rating_vote_weight", 1);
$ratingValueDelete = $ratingValueDelete * COption::GetOptionString("main", "rating_vote_weight", 1);
}
// remove the group from all users who it is, but you need to remove it
$strSql = "
SELECT rr.ENTITY_ID
FROM b_rating_results rr
WHERE rr.RATING_ID = $ratingId
AND rr.CURRENT_VALUE < $ratingValueDelete
GROUP BY rr.ENTITY_ID
";
$res = $DB->Query($strSql);
while ($row = $res->Fetch())
{
CUser::RemoveUserGroup($row['ENTITY_ID'], [$groupId]);
}
// add a group to all users who do not, but you need to add it
$strSql = "
SELECT rr.ENTITY_ID
FROM b_rating_results rr
LEFT JOIN b_user_group ug ON ug.GROUP_ID = $groupId AND ug.USER_ID = rr.ENTITY_ID
WHERE rr.RATING_ID = $ratingId
and rr.CURRENT_VALUE >= $ratingValueAdd
and ug.USER_ID IS NULL
GROUP BY rr.ENTITY_ID
";
$res = $DB->Query($strSql);
while ($row = $res->Fetch())
{
CUser::AppendUserGroup($row['ENTITY_ID'], [$groupId]);
}
return true;
}
public static function GetRatingVoteListSQL($arParam, $bplus, $bIntranetInstalled, $includeReaction = false)
{
global $DB, $USER;
$externalAuthTypes = array_diff(\Bitrix\Main\UserTable::getExternalUserTypes(), ['email', 'replica']);
$reactionField = $includeReaction ? "RV.REACTION," : "";
$groupBy = "U.ID, U.NAME, U.LAST_NAME, U.SECOND_NAME, U.LOGIN, U.PERSONAL_PHOTO, RV.VALUE, RV.USER_ID";
if ($includeReaction)
{
$groupBy .= ", RV.REACTION";
}
return "
SELECT
U.ID,
U.NAME,
U.LAST_NAME,
U.SECOND_NAME,
U.LOGIN,
U.PERSONAL_PHOTO,
$reactionField
RV.VALUE AS VOTE_VALUE,
RV.USER_ID,
SUM(case when RV0.ID is not null then 1 else 0 end) " . $DB->quote("RANK") . ",
MIN(RV.ID) RV_ID
FROM
b_rating_vote RV LEFT JOIN b_rating_vote RV0 ON RV0.USER_ID = " . intval($USER->GetId()) . " and RV0.OWNER_ID = RV.USER_ID
INNER JOIN b_user U ON RV.USER_ID = U.ID
WHERE
(CASE WHEN U.EXTERNAL_AUTH_ID IN ('" . join("', '", $externalAuthTypes) . "') THEN 'Y' ELSE 'N' END) = 'N'
AND RV.ENTITY_TYPE_ID = '" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "'
and RV.ENTITY_ID = " . intval($arParam['ENTITY_ID']) . "
" . self::getReactionFilterSQL($arParam, $bplus) . "
GROUP BY $groupBy
ORDER BY " . ($bIntranetInstalled ? "RV.VALUE DESC, " . $DB->quote("RANK") . " DESC, RV_ID DESC" : $DB->quote("RANK") . " DESC, RV.VALUE DESC, RV_ID DESC");
}
public static function GetRatingVoteListSQLExtended($arParam, $bplus, $bIntranetInstalled, $includeReaction = false)
{
global $DB, $USER;
$externalAuthTypes = array_diff(\Bitrix\Main\UserTable::getExternalUserTypes(), ['email', 'replica']);
$reactionField = $includeReaction ? "RV.REACTION," : "";
$groupBy = "U.ID, RV.VALUE, RV.USER_ID";
if ($includeReaction)
{
$groupBy .= ", RV.REACTION";
}
return "
SELECT
U.ID,
RV.VALUE AS VOTE_VALUE,
RV.USER_ID,
$reactionField
SUM(case when RV0.ID is not null then 1 else 0 end) " . $DB->quote("RANK") . ",
MIN(RV.ID) RV_ID
FROM
b_rating_vote RV
LEFT JOIN b_rating_vote RV0 ON RV0.USER_ID = " . intval($USER->GetId()) . " and RV0.OWNER_ID = RV.USER_ID
INNER JOIN b_user U ON RV.USER_ID = U.ID
WHERE
(CASE WHEN U.EXTERNAL_AUTH_ID IN ('" . join("', '", $externalAuthTypes) . "') THEN 'Y' ELSE 'N' END) = 'N'
AND RV.ENTITY_TYPE_ID = '" . $DB->ForSql($arParam['ENTITY_TYPE_ID']) . "'
and RV.ENTITY_ID = " . intval($arParam['ENTITY_ID']) . "
" . self::getReactionFilterSQL($arParam, $bplus) . "
GROUP BY $groupBy
ORDER BY " . ($bIntranetInstalled ? "RV.VALUE DESC, " . $DB->quote("RANK") . " DESC, RV_ID DESC" : $DB->quote("RANK") . " DESC, RV.VALUE DESC, RV_ID DESC");
}
private static function getReactionFilterSQL($arParam, $bplus)
{
global $DB;
$result = (
$bplus
&& !empty($arParam["REACTION"])
? (
$arParam["REACTION"] == self::REACTION_DEFAULT
? " and (RV.REACTION IS NULL OR RV.REACTION = '" . $DB->ForSql($arParam["REACTION"]) . "') "
: " and RV.REACTION = '" . $DB->ForSql($arParam["REACTION"]) . "' "
)
: ""
);
return $result;
}
}