[XE FAQ] 회원의 총 추천수 구하는 방법은?

질문 :

특정 회원의 총 추천수를 구하는 방법은?

질문 출처 : http://www.xpressengine.com/qna/22714476

==============================================

답변 :

1. document/queries/getDocumentVotedCountByMemberSrl.xml  추가

<query id="getDocumentVotedCountByMemberSrl" action="select">   
 <tables>
  <table name="documents" />   
 </tables>
 <columns>
  <column name="SUM(voted_count)" alias="voted_sum" />
 </columns>
 <conditions>
  <condition operation="equal" column="member_srl" var="member_srl" filter="number" notnull="notnull" />
 </conditions>
</query>

2. document/documnet.model.php 에  추가

function getDocumentVotedCountByMemberSrl($member_srl){  
 $args = new stdClass();   
 $args->member_srl = $member_srl;
 $output = executeQuery('document.getDocumentVotedCountByMemberSrl', $args);
 return $output->data->voted_sum;
}

3.
원하시는 곳에서 출력하려면...

{@
$oMemberModel = &getModel('document');
$voted_sum = $oMemberModel->getDocumentVotedCountByMemberSrl($member_srl);
}
{$voted_sum}