/**
* @brief get all the comments in time decending order(for administrators)
**/
function getTotalCommentList($obj, $columnList = array())
{
$query_id = 'comment.getTotalCommentList';
// Variables
$args = new stdClass();
$args->sort_index = 'list_order';
$args->page = $obj->page ? $obj->page : 1;
$args->list_count = $obj->list_count ? $obj->list_count : 20;
$args->page_count = $obj->page_count ? $obj->page_count : 10;
$args->s_module_srl = $obj->module_srl;
$args->exclude_module_srl = $obj->exclude_module_srl;
// Search options
$search_target = $obj->search_target ? $obj->search_target : trim(Context::get('search_target'));
$search_keyword = $obj->search_keyword ? $obj->search_keyword : trim(Context::get('search_keyword'));
if ($search_target && $search_keyword) {
switch ($search_target) {
case 'content':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_content = $search_keyword;
break;
case 'user_id':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_user_id = $search_keyword;
$query_id = 'comment.getTotalCommentListWithinMember';
$args->sort_index = 'comments.list_order';
break;
case 'user_name':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_user_name = $search_keyword;
break;
case 'nick_name':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_nick_name = $search_keyword;
break;
case 'email_address':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_email_address = $search_keyword;
break;
case 'homepage':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_homepage = $search_keyword;
break;
case 'regdate':
$args->s_regdate = $search_keyword;
break;
case 'last_update':
$args->s_last_upate = $search_keyword;
break;
case 'ipaddress':
$args->s_ipaddress = $search_keyword;
break;
case 'is_secret':
$args->s_is_secret = $search_keyword;
break;
case 'member_srl':
$args->{"s_" . $search_target} = (int) $search_keyword;
break;
}
}
// comment.getTotalCommentList query execution
$output = executeQueryArray($query_id, $args, $columnList);
// return when no result or error occurance
if (!$output->toBool() || !count($output->data)) {
return $output;
}
foreach ($output->data as $key => $val) {
unset($_oComment);
$_oComment = new CommentItem(0);
$_oComment->setAttribute($val);
$output->data[$key] = $_oComment;
}
return $output;
}
/**
* @brief 모든 댓글를 시간 역순으로 가져옴 (관리자용)
**/
function getTotalCommentList($obj)
{
$query_id = 'comment.getTotalCommentList';
// 변수 설정
$args->sort_index = 'list_order';
$args->page = $obj->page ? $obj->page : 1;
$args->list_count = $obj->list_count ? $obj->list_count : 20;
$args->page_count = $obj->page_count ? $obj->page_count : 10;
$args->s_module_srl = $obj->module_srl;
$args->exclude_module_srl = $obj->exclude_module_srl;
// 검색 옵션 정리
$search_target = $obj->search_target ? $obj->search_target : trim(Context::get('search_target'));
$search_keyword = $obj->search_keyword ? $obj->search_keyword : trim(Context::get('search_keyword'));
if ($search_target && $search_keyword) {
switch ($search_target) {
case 'content':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_content = $search_keyword;
break;
case 'user_id':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_user_id = $search_keyword;
$query_id = 'comment.getTotalCommentListWithinMember';
$args->sort_index = 'comments.list_order';
break;
case 'user_name':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_user_name = $search_keyword;
break;
case 'nick_name':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_nick_name = $search_keyword;
break;
case 'email_address':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_email_address = $search_keyword;
break;
case 'homepage':
if ($search_keyword) {
$search_keyword = str_replace(' ', '%', $search_keyword);
}
$args->s_homepage = $search_keyword;
break;
case 'regdate':
$args->s_regdate = $search_keyword;
break;
case 'last_update':
$args->s_last_upate = $search_keyword;
break;
case 'ipaddress':
$args->s_ipaddress = $search_keyword;
break;
case 'member_srl':
$args->{"s_" . $search_target} = (int) $search_keyword;
break;
}
}
// comment.getTotalCommentList 쿼리 실행
$output = executeQueryArray($query_id, $args);
// 결과가 없거나 오류 발생시 그냥 return
if (!$output->toBool() || !count($output->data)) {
return $output;
}
foreach ($output->data as $key => $val) {
unset($_oComment);
$_oComment = new CommentItem(0);
$_oComment->setAttribute($val);
$output->data[$key] = $_oComment;
}
return $output;
}