<?php if(!defined('__ZBXE__')) exit();
$output->query_id = "pop_up.getPopupsForThisSrl";
$output->action = "select";
$output->column_type["popup_conn_srl"] = "number";
$output->column_type["document_srl"] = "number";
$output->column_type["popup_name"] = "varchar";
$output->column_type["target_type"] = "varchar";
$output->column_type["target_srl"] = "number";
$output->column_type["popup_type"] = "varchar";
$output->column_type["popup_data"] = "text";
$output->column_type["popup_url"] = "varchar";
$output->column_type["popup_linkto"] = "varchar";
$output->column_type["popup_linkto_newwindow"] = "varchar";
$output->column_type["width"] = "number";
$output->column_type["height"] = "number";
$output->column_type["left"] = "number";
$output->column_type["top"] = "number";
$output->column_type["open_type"] = "varchar";
$output->column_type["exp_days"] = "number";
$output->column_type["startdate"] = "date";
$output->column_type["enddate"] = "date";
$output->column_type["regdate"] = "date";
$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->tables = array( "pop_ups"=>"pop_ups","documents"=>"documents", );
$output->_tables = array( "pop_ups"=>"pop_ups","documents"=>"documents", );
$output->columns = array ( array("name"=>"pop_ups.*","alias"=>""),
array("name"=>"documents.content","alias"=>""),
 );
$output->conditions = array ( array("pipe"=>"",
"condition"=>array(array("column"=>"target_srl", "value"=>$args->module_srl,"pipe"=>"","operation"=>"equal",),
array("column"=>"documents.document_srl", "value"=>"pop_ups.document_srl","pipe"=>"and","operation"=>"equal",),
array("column"=>"target_type", "value"=>"module","pipe"=>"and","operation"=>"equal",),
array("column"=>"pop_ups.startdate", "value"=>$args->curdate,"pipe"=>"and","operation"=>"less",),
array("column"=>"pop_ups.enddate", "value"=>$args->curdate,"pipe"=>"and","operation"=>"more",),
)),
 );
return $output; ?>