[해결] 게시물 추천 후 추천취소하기

xe_document_voted_log 테이블에서 컬럼을 삭제를 해도

여전히 '추천할 수 없습니다.', '비추천할 수 없습니다'라고 뜹니다.

어디에 추천한 기록이 남아있어서 그런 건가요?;

1. 스킨 수정하기

{@
$oDB = &DB::getInstance();

$query = $oDB->_query('select * from xe_document_voted_log where member_srl = '.$logged_info->member_srl.' AND document_srl = '.$oDocument->document_srl.'');
$result = $oDB->_fetch($query);
}
<!--@if($result->member_srl==$logged_info->member_srl)-->
<a href="javascript:();" onclick="doCallModuleAction('document','procDocumentVoteCancel','{$oDocument->document_srl}');return false;"|cond="$is_logged">
   {$oDocument->get('voted_count')} / 추천취소
</a>
<!--@else-->
<a class="bd_login btn-vote-good" href="#" onclick="doCallModuleAction('document','procDocumentVoteUp','{$oDocument->document_srl}');return false;"|cond="$is_logged" style="border:0px solid #{$mi->color};color:#{$mi->color};">
   <b><i class="fa fa-heart"></i> {$oDocument->get('voted_count')}</b>
   <p>{$lang->cmd_vote}</p>
</a>
<!--@end-->

2. document 모듈의 쿼리 만들기

<query id="cancelVotedCount" action="delete">
   <tables>
      <table name="document_voted_log" />
   </tables>
   <conditions>
      <condition operation="equal" column="document_srl" var="document_srl" filter="number" notnull="notnull" />
      <condition operation="equal" column="member_srl" var="member_srl" filter="number" notnull="notnull" pipe="and" />
   </conditions>
</query>

3. document 모듈의 controller 함수 선언하기

function procDocumentVoteCancel()
   {
//    $oDB = &DB::getInstance();
      if(!Context::get('is_logged')) return new BaseObject(-1, 'msg_invalid_request');

      $document_srl = Context::get('target_srl');
      if(!$document_srl) return new BaseObject(-1, 'msg_invalid_request');

      $oDocumentModel = getModel('document');
      $oDocument = $oDocumentModel->getDocument($document_srl, false, false);
      $module_srl = $oDocument->get('module_srl');
      if(!$module_srl) return new BaseObject(-1, 'msg_invalid_request');

      $oModuleModel = getModel('module');
      $document_config = $oModuleModel->getModulePartConfig('document',$module_srl);
      if($document_config->use_vote_up=='N') return new BaseObject(-1, 'msg_invalid_request');

//    $point = 1;
      //$output = $this->cancelDocumentVotedLog($args);
//    $this->add('voted_count', $output->get('voted_count'));
      $logged_info = Context::get('logged_info');
      $args = new stdClass();
      $args->member_srl = $logged_info->member_srl;
      $args->document_srl = $document_srl;
      executeQuery('document.cancelVotedCount', $args);
      return $output;


//    $output = $oDB->_fetch($oDB->_query("DELETE FROM document_voted_log WHERE member_srl =
//    '".$logged_info->member_srl."' AND document_srl = '".$document_srl."' "));
      //$output = $oDB->_fetch($oDB->_query("SELECT * FROM 테이블명 WHERE module_srl = '".$module_srl."' "));
//    return $output;
   }
   function cancelDocumentVotedLog($args){
      $args = new stdClass();
      $logged_info = Context::get('logged_info');
      $document_srl = Context::get('target_srl');
      $oModuleModel = getModel('module');
      $document_config = $oModuleModel->getModulePartConfig('document',$module_srl);
      $args = new stdClass();
      $args->member_srl = $logged_info->member_srl;
      $args->document_srl = $document_srl;
      executeQuery('document.cancelVotedCount', $args);
   }

4. document 모듈의 module.xml 작성하기

<action name="procDocumentVoteCancel" type="controller" />

흠-_-; 일단 이렇긴 한데 새로 그냥 다시 해봐야겠습니다. 방법은 알거 같네요.