public static function checkVote($relatedModule, $relatedId, $uid = 0)
{
$result = false;
$uid = empty($uid) ? Ibos::app()->user->uid : $uid;
$condition = "relatedmodule=:relatedmodule AND relatedid=:relatedid";
$params = array(":relatedmodule" => $relatedModule, ":relatedid" => $relatedId);
$vote = Vote::model()->fetch($condition, $params);
if (!empty($vote)) {
$voteid = $vote["voteid"];
$voteItemList = VoteItem::model()->fetchAll("voteid=:voteid", array(":voteid" => $voteid));
foreach ($voteItemList as $voteItem) {
$itemid = $voteItem["itemid"];
$itemCountList = VoteItemCount::model()->fetchAll("itemid=:itemid", array(":itemid" => $itemid));
if (!empty($itemCountList) && 0 < count($itemCountList)) {
foreach ($itemCountList as $itemCount) {
if ($itemCount["uid"] == $uid) {
$result = true;
break;
}
}
}
}
}
return $result;
}
public function clickVote($relatedModule, $relatedId, $voteItemids)
{
$result = 0;
if (!VoteUtil::checkVote($relatedModule, $relatedId)) {
$affectedRow = VoteItem::model()->updateNumber($voteItemids);
if ($affectedRow) {
$voteitemidArray = explode(",", rtrim($voteItemids, ","));
foreach ($voteitemidArray as $voteitemid) {
$voteItemCount = new VoteItemCount();
$voteItemCount->itemid = $voteitemid;
$voteItemCount->uid = Ibos::app()->user->uid;
$voteItemCount->save();
}
$voteData = Vote::model()->fetchVote($relatedModule, $relatedId);
$result = VoteUtil::processVoteData($voteData);
}
} else {
$result = -1;
}
return $result;
}
public function deleteAllByRelationIdsAndModule($relatedids, $relatedModule)
{
$relatedidArr = explode(",", $relatedids);
foreach ($relatedidArr as $relatedid) {
$vote = $this->fetch(array("select" => array("voteid"), "condition" => "relatedid=:relatedid AND relatedmodule=:relatedmodule", "params" => array(":relatedid" => $relatedid, ":relatedmodule" => $relatedModule)));
if (!empty($vote)) {
$voteId = $vote["voteid"];
$voteItemList = VoteItem::model()->fetchAll("voteid=:voteid", array(":voteid" => $voteId));
if (!empty($voteItemList)) {
$voteItemIds = "";
foreach ($voteItemList as $voteitem) {
$voteItemIds .= $voteitem["itemid"] . ",";
}
$voteitemids = trim($voteItemIds, ",");
VoteItemCount::model()->deleteAll("itemid IN({$voteitemids})");
VoteItem::model()->deleteAll("itemid IN({$voteitemids})");
}
}
}
return $this->deleteAll("relatedmodule='{$relatedModule}' AND relatedid IN({$relatedids})");
}
<?php
$articleComments = Comment::model()->fetchAllByAttributes(array("module" => "article"));
$cidArr = ConvertUtil::getSubByKey($articleComments, "cid");
if (!empty($articleComments)) {
$cidStr = implode(",", $cidArr);
Comment::model()->deleteAll("rowid IN({$cidStr})");
Comment::model()->deleteAllByAttributes(array("module" => "article"));
}
$isInstallVote = ModuleUtil::getIsEnabled("vote");
if ($isInstallVote) {
$articleVotes = Vote::model()->fetchAllByAttributes(array("relatedmodule" => "article"));
$voteidArr = ConvertUtil::getSubByKey($articleVotes, "voteid");
$voteidStr = implode(",", $voteidArr);
$articleVoteItems = VoteItem::model()->fetchAll("FIND_IN_SET(voteid, '{$voteidStr}')");
$itemidArr = ConvertUtil::getSubByKey($articleVoteItems, "itemid");
$itemidStr = implode(",", $itemidArr);
VoteItemCount::model()->deleteAll("FIND_IN_SET(itemid, '{$itemidStr}')");
VoteItem::model()->deleteAll("FIND_IN_SET(itemid, '{$itemidStr}')");
Vote::model()->deleteAllByAttributes(array("relatedmodule" => "article"));
}
