/home/bitrix/www/bitrix/components/bitrix/votingwithcomment.result/templates/with_description/template.php
Скрытый текст |
---|
global $USER; if($USER->IsAdmin() || $USER->GetID() == 600 || $USER->GetID() == 624){ $by = 'c_sort'; $order = 'asc'; $EventData = array(); $rsData = CYeaVoteWithCommentEvent::GetList($by, $order, array('VOTEWITHCOMMENT_ID' => $arResult['VOTEWITHCOMMENT']$ while($asData = $rsData->Fetch()){ $EventData[] = $asData; } ?>
<table class="user_table"> <tr><td>Сотрудник</td><td>За кого проголосовал</td><td>Комментарий</td><td>Дата голосования</td></tr> <?foreach ($EventData as $idevent => $data): ?> <? $dataID = CYeaVoteWithCommentEvent::GetByID($data['ID']); $ardataID = $dataID->Fetch();
$event_id = $data['ID']; $z = $DB->Query("SEL ECT ANSWER_ID FR OM b_votewithcomment_event_answer WHERE ID='$event_id'", false, $er$ $zr=$z->Fetch(); $zr = $zr['ANSWER_ID']; $answer = $DB->Query("SEL ECT MESSAGE FR OM b_votewithcomment_answer WHERE ID='$zr'", false, $err_mess.__$ $aranswer=$answer->Fetch(); ?> <tr> <td><?=$ardataID['AUTH_USER_NAME']?></td> <td><?=$aranswer['MESSAGE']?></td> <td><?=$data['COMMENT']?></td> <td><?=$data['DATE_VOTEWITHCOMMENT']?></td></tr> <?endforeach?>
</table> |
/home/bitrix/www/bitrix/modules/yea24.votewithcomment/classes/general/event.php
Скрытый текст |
---|
$DB->Query( "UPD ATE b_votewithcomment_question VQ SET VQ.COUNTER=(". "SEL ECT COUNT(VEQ.ID) FR OM b_votewithcomment_event_question VEQ WHERE VEQ.Q$ ") WHERE VQ.VOTEWITHCOMMENT_ID=".$VOTEWITHCOMMENT_ID, false, $err_mess.__LINE__); $DB->Query( "UPD ATE b_votewithcomment_answer VA, b_votewithcomment_question VQ SE T VA.COUNTER=($ " SELECT COUNT(VEA.ID) FR OM b_votewithcomment_event_answer VEA WHERE VEA.AN$ ") WH ERE VQ.ID = VA.QUESTION_ID AND VQ.VOTEWITHCOMMENT_ID=".$VOTEWITHCOMMENT_ID, fa$ $DB->Query( "UPDATE b_votewithcomment_user VU, b_votewithcomment_event VE SE T VU.COUNTER=(". " SELECT COUNT(VE.ID) FR OM b_votewithcomment_event VE WH ERE VU.ID=VE.VOTEWI$ ") WH ERE VU.ID IN (SELECT DISTINCT VEE.VOTEWITHCOMMENT_USER_ID FR OM b_votewithcomme$ } }
186 строка --> function GetList(&$by, &$order, $arFilter=Array(), &$is_filtered, $get_user="N") { $err_mess = (self::err_mess())."<br>Function: GetList<br>Line: "; global $DB; $arSqlSearch = Array(); $strSqlSearch = ""; if (is_array($arFilter)) { $filter_keys = array_keys($arFilter); $count = count($filter_keys); for ($i=0; $i<$count; $i++) { $key = $filter_keys[$i]; $val = $arFilter[$filter_keys[$i]]; if(is_array($val)) { if(count($val) <= 0) continue; |