<?php if(!defined('__ZBXE__')) exit();
$output->query_id = "file.getFileList";
$output->action = "select";
$output->column_type["file_srl"] = "number";
$output->column_type["upload_target_srl"] = "number";
$output->column_type["upload_target_type"] = "char";
$output->column_type["sid"] = "varchar";
$output->column_type["module_srl"] = "number";
$output->column_type["member_srl"] = "number";
$output->column_type["download_count"] = "number";
$output->column_type["direct_download"] = "char";
$output->column_type["source_filename"] = "varchar";
$output->column_type["uploaded_filename"] = "varchar";
$output->column_type["file_size"] = "number";
$output->column_type["comment"] = "varchar";
$output->column_type["isvalid"] = "char";
$output->column_type["regdate"] = "date";
$output->column_type["ipaddress"] = "varchar";
$output->column_type["member_srl"] = "number";
$output->column_type["user_id"] = "varchar";
$output->column_type["email_address"] = "varchar";
$output->column_type["password"] = "varchar";
$output->column_type["email_id"] = "varchar";
$output->column_type["email_host"] = "varchar";
$output->column_type["user_name"] = "varchar";
$output->column_type["nick_name"] = "varchar";
$output->column_type["homepage"] = "varchar";
$output->column_type["blog"] = "varchar";
$output->column_type["birthday"] = "char";
$output->column_type["allow_mailing"] = "char";
$output->column_type["allow_message"] = "char";
$output->column_type["denied"] = "char";
$output->column_type["limit_date"] = "date";
$output->column_type["regdate"] = "date";
$output->column_type["last_login"] = "date";
$output->column_type["is_admin"] = "char";
$output->column_type["description"] = "text";
$output->column_type["extra_vars"] = "text";
$output->tables = array( "files"=>"files", );
$output->_tables = array( "files"=>"files","member"=>"member", );
$output->left_tables = array( "member"=>"left join", );
$output->columns = array ( array("name"=>"files.*","alias"=>""),
 );
$output->conditions = array ( array("pipe"=>"",
"condition"=>array(array("column"=>"files.module_srl", "value"=>$args->s_module_srl,"pipe"=>"","operation"=>"in",),
array("column"=>"files.module_srl", "value"=>$args->exclude_module_srl,"pipe"=>"and","operation"=>"notin",),
array("column"=>"files.isvalid", "value"=>$args->isvalid,"pipe"=>"and","operation"=>"equal",),
array("column"=>"files.direct_download", "value"=>$args->direct_download,"pipe"=>"and","operation"=>"equal",),
)),
array("pipe"=>"and",
"condition"=>array(array("column"=>"files.source_filename", "value"=>$args->s_filename,"pipe"=>"or","operation"=>"like",),
array("column"=>"files.file_size", "value"=>$args->s_filesize_more,"pipe"=>"or","operation"=>"more",),
array("column"=>"files.file_size", "value"=>$args->s_filesize_less,"pipe"=>"or","operation"=>"less",),
array("column"=>"files.download_count", "value"=>$args->s_download_count,"pipe"=>"or","operation"=>"more",),
array("column"=>"files.regdate", "value"=>$args->s_regdate,"pipe"=>"or","operation"=>"like_prefix",),
array("column"=>"files.ipaddress", "value"=>$args->s_ipaddress,"pipe"=>"or","operation"=>"like_prefix",),
array("column"=>"member.user_id", "value"=>$args->s_user_id,"pipe"=>"or","operation"=>"like",),
array("column"=>"member.user_name", "value"=>$args->s_user_name,"pipe"=>"or","operation"=>"like",),
array("column"=>"member.nick_name", "value"=>$args->s_nick_name,"pipe"=>"or","operation"=>"like",),
)),
 );
$output->left_conditions = array ( 'member' => array ( array("pipe"=>"",
"condition"=>array(array("column"=>"files.member_srl", "value"=>"member.member_srl","pipe"=>"","operation"=>"equal",),
)),
),
 );
$output->order = array(array($args->sort_index?$args->sort_index:"files.file_srl",in_array($args->desc,array("asc","desc"))?$args->desc:("desc"?"desc":"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:"");
return $output; ?>