|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /home/queenjbs/xe/files/cache/queries/ |
Upload File : |
<?php if(!defined('__ZBXE__')) exit();
$output->query_id = "document.getDocumentListWithinComment";
$output->action = "select";
if(isset($args->module_srl)) { unset($_output); $_output = $this->checkFilter("module_srl",$args->module_srl,"number"); if(!$_output->toBool()) return $_output; }
if(isset($args->exclude_module_srl)) { unset($_output); $_output = $this->checkFilter("exclude_module_srl",$args->exclude_module_srl,"number"); if(!$_output->toBool()) return $_output; }
if(isset($args->member_srl)) { unset($_output); $_output = $this->checkFilter("member_srl",$args->member_srl,"number"); if(!$_output->toBool()) return $_output; }
if(!isset($args->s_comment)) return new Object(-1, sprintf($lang->filter->isnull, $lang->s_comment?$lang->s_comment:'s_comment'));
$output->column_type["document_srl"] = "number";
$output->column_type["module_srl"] = "number";
$output->column_type["category_srl"] = "number";
$output->column_type["lang_code"] = "varchar";
$output->column_type["is_notice"] = "char";
$output->column_type["is_secret"] = "char";
$output->column_type["title"] = "varchar";
$output->column_type["title_bold"] = "char";
$output->column_type["title_color"] = "varchar";
$output->column_type["content"] = "bigtext";
$output->column_type["readed_count"] = "number";
$output->column_type["voted_count"] = "number";
$output->column_type["blamed_count"] = "number";
$output->column_type["comment_count"] = "number";
$output->column_type["trackback_count"] = "number";
$output->column_type["uploaded_count"] = "number";
$output->column_type["password"] = "varchar";
$output->column_type["user_id"] = "varchar";
$output->column_type["user_name"] = "varchar";
$output->column_type["nick_name"] = "varchar";
$output->column_type["member_srl"] = "number";
$output->column_type["email_address"] = "varchar";
$output->column_type["homepage"] = "varchar";
$output->column_type["tags"] = "text";
$output->column_type["extra_vars"] = "text";
$output->column_type["regdate"] = "date";
$output->column_type["last_update"] = "date";
$output->column_type["last_updater"] = "varchar";
$output->column_type["ipaddress"] = "varchar";
$output->column_type["list_order"] = "number";
$output->column_type["update_order"] = "number";
$output->column_type["allow_comment"] = "char";
$output->column_type["lock_comment"] = "char";
$output->column_type["allow_trackback"] = "char";
$output->column_type["notify_message"] = "char";
$output->column_type["comment_srl"] = "number";
$output->column_type["module_srl"] = "number";
$output->column_type["document_srl"] = "number";
$output->column_type["parent_srl"] = "number";
$output->column_type["is_secret"] = "char";
$output->column_type["content"] = "bigtext";
$output->column_type["voted_count"] = "number";
$output->column_type["blamed_count"] = "number";
$output->column_type["notify_message"] = "char";
$output->column_type["password"] = "varchar";
$output->column_type["user_id"] = "varchar";
$output->column_type["user_name"] = "varchar";
$output->column_type["nick_name"] = "varchar";
$output->column_type["member_srl"] = "number";
$output->column_type["email_address"] = "varchar";
$output->column_type["homepage"] = "varchar";
$output->column_type["uploaded_count"] = "number";
$output->column_type["regdate"] = "date";
$output->column_type["last_update"] = "date";
$output->column_type["ipaddress"] = "varchar";
$output->column_type["list_order"] = "number";
$output->tables = array( "documents"=>"documents","comments"=>"comments", );
$output->_tables = array( "documents"=>"documents","comments"=>"comments", );
$output->columns = array ( array("name"=>"documents.document_srl","alias"=>""),
array("name"=>"documents.list_order","alias"=>""),
);
$output->conditions = array ( array("pipe"=>"",
"condition"=>array(array("column"=>"documents.module_srl", "value"=>$args->module_srl,"pipe"=>"","operation"=>"in",),
array("column"=>"documents.module_srl", "value"=>$args->exclude_module_srl,"pipe"=>"and","operation"=>"notin",),
array("column"=>"documents.category_srl", "value"=>$args->category_srl,"pipe"=>"and","operation"=>"equal",),
array("column"=>"documents.document_srl", "value"=>"comments.document_srl","pipe"=>"and","operation"=>"equal",),
array("column"=>"documents.member_srl", "value"=>$args->member_srl,"pipe"=>"and","operation"=>"equal",),
array("column"=>"comments.content", "value"=>$args->s_comment,"pipe"=>"and","operation"=>"like",),
)),
array("pipe"=>"and",
"condition"=>array(array("column"=>"documents.list_order", "value"=>$args->division,"pipe"=>"and","operation"=>"more",),
array("column"=>"documents.list_order", "value"=>$args->last_division,"pipe"=>"and","operation"=>"below",),
)),
);
$output->order = array(array($args->sort_index?$args->sort_index:"comments.list_order",in_array($args->asc,array("asc","desc"))?$args->asc:("asc"?"asc":"asc")),);
$output->list_count = array("var"=>"list_count", "value"=>$args->list_count?$args->list_count:"20");
$output->page_count = array("var"=>"page_count", "value"=>$args->page_count?$args->page_count:"20");
$output->page = array("var"=>"page", "value"=>$args->page?$args->page:"");
$output->groups = array("documents.document_srl");
return $output; ?>