query_id = "document.getTrashList"; $output->action = "select"; if(is_object($args->module_srl)){ $args->module_srl = array_values(get_method_vars($args->module_srl)); } if(is_array($args->module_srl) && count($args->module_srl)==0){ unset($args->module_srl); }; if(is_object($args->member_srl)){ $args->member_srl = array_values(get_method_vars($args->member_srl)); } if(is_array($args->member_srl) && count($args->member_srl)==0){ unset($args->member_srl); }; if(is_object($args->s_title)){ $args->s_title = array_values(get_method_vars($args->s_title)); } if(is_array($args->s_title) && count($args->s_title)==0){ unset($args->s_title); }; if(is_object($args->s_content)){ $args->s_content = array_values(get_method_vars($args->s_content)); } if(is_array($args->s_content) && count($args->s_content)==0){ unset($args->s_content); }; if(is_object($args->s_user_name)){ $args->s_user_name = array_values(get_method_vars($args->s_user_name)); } if(is_array($args->s_user_name) && count($args->s_user_name)==0){ unset($args->s_user_name); }; if(is_object($args->s_user_id)){ $args->s_user_id = array_values(get_method_vars($args->s_user_id)); } if(is_array($args->s_user_id) && count($args->s_user_id)==0){ unset($args->s_user_id); }; if(is_object($args->s_nick_name)){ $args->s_nick_name = array_values(get_method_vars($args->s_nick_name)); } if(is_array($args->s_nick_name) && count($args->s_nick_name)==0){ unset($args->s_nick_name); }; if(is_object($args->s_email_addres)){ $args->s_email_addres = array_values(get_method_vars($args->s_email_addres)); } if(is_array($args->s_email_addres) && count($args->s_email_addres)==0){ unset($args->s_email_addres); }; if(is_object($args->s_homepage)){ $args->s_homepage = array_values(get_method_vars($args->s_homepage)); } if(is_array($args->s_homepage) && count($args->s_homepage)==0){ unset($args->s_homepage); }; if(is_object($args->s_tags)){ $args->s_tags = array_values(get_method_vars($args->s_tags)); } if(is_array($args->s_tags) && count($args->s_tags)==0){ unset($args->s_tags); }; if(is_object($args->s_is_secret)){ $args->s_is_secret = array_values(get_method_vars($args->s_is_secret)); } if(is_array($args->s_is_secret) && count($args->s_is_secret)==0){ unset($args->s_is_secret); }; if(is_object($args->s_member_srl)){ $args->s_member_srl = array_values(get_method_vars($args->s_member_srl)); } if(is_array($args->s_member_srl) && count($args->s_member_srl)==0){ unset($args->s_member_srl); }; if(is_object($args->s_readed_count)){ $args->s_readed_count = array_values(get_method_vars($args->s_readed_count)); } if(is_array($args->s_readed_count) && count($args->s_readed_count)==0){ unset($args->s_readed_count); }; if(is_object($args->s_voted_count)){ $args->s_voted_count = array_values(get_method_vars($args->s_voted_count)); } if(is_array($args->s_voted_count) && count($args->s_voted_count)==0){ unset($args->s_voted_count); }; if(is_object($args->s_comment_count)){ $args->s_comment_count = array_values(get_method_vars($args->s_comment_count)); } if(is_array($args->s_comment_count) && count($args->s_comment_count)==0){ unset($args->s_comment_count); }; if(is_object($args->s_trackback_count)){ $args->s_trackback_count = array_values(get_method_vars($args->s_trackback_count)); } if(is_array($args->s_trackback_count) && count($args->s_trackback_count)==0){ unset($args->s_trackback_count); }; if(is_object($args->s_uploaded_count)){ $args->s_uploaded_count = array_values(get_method_vars($args->s_uploaded_count)); } if(is_array($args->s_uploaded_count) && count($args->s_uploaded_count)==0){ unset($args->s_uploaded_count); }; if(is_object($args->s_regdate)){ $args->s_regdate = array_values(get_method_vars($args->s_regdate)); } if(is_array($args->s_regdate) && count($args->s_regdate)==0){ unset($args->s_regdate); }; if(is_object($args->s_last_update)){ $args->s_last_update = array_values(get_method_vars($args->s_last_update)); } if(is_array($args->s_last_update) && count($args->s_last_update)==0){ unset($args->s_last_update); }; if(is_object($args->s_ipaddress)){ $args->s_ipaddress = array_values(get_method_vars($args->s_ipaddress)); } if(is_array($args->s_ipaddress) && count($args->s_ipaddress)==0){ unset($args->s_ipaddress); }; if(isset($args->module_srl)) { unset($_output); $_output = $this->checkFilter("module_srl",$args->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; } $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["trash_srl"] = "number"; $output->column_type["document_srl"] = "number"; $output->column_type["module_srl"] = "number"; $output->column_type["trash_date"] = "date"; $output->column_type["description"] = "text"; $output->column_type["ipaddress"] = "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->tables = array( "documents"=>"documents","document_trash"=>"document_trash", ); $output->_tables = array( "documents"=>"documents","document_trash"=>"document_trash", ); $output->columns = array ( array("name"=>"documents.*","alias"=>""), array("name"=>"document_trash.trash_srl","alias"=>"trash_srl"), array("name"=>"document_trash.module_srl","alias"=>"module_srl"), array("name"=>"document_trash.trash_date","alias"=>"trash_date"), array("name"=>"document_trash.description","alias"=>"trash_description"), array("name"=>"document_trash.ipaddress","alias"=>"trash_ipaddress"), array("name"=>"document_trash.user_id","alias"=>"trash_user_id"), array("name"=>"document_trash.user_name","alias"=>"trash_user_name"), array("name"=>"document_trash.nick_name","alias"=>"trash_nick_name"), array("name"=>"document_trash.member_srl","alias"=>"trash_member_srl"), ); $output->conditions = array ( array("pipe"=>"", "condition"=>array(array("column"=>"document_trash.document_srl", "value"=>"documents.document_srl","pipe"=>"","operation"=>"equal",), array("column"=>"document_trash.module_srl", "value"=>$args->module_srl,"pipe"=>"and","operation"=>"in",), array("column"=>"document_trash.member_srl", "value"=>$args->member_srl,"pipe"=>"and","operation"=>"equal",), )), array("pipe"=>"and", "condition"=>array(array("column"=>"documents.title", "value"=>$args->s_title,"pipe"=>"","operation"=>"like",), array("column"=>"documents.content", "value"=>$args->s_content,"pipe"=>"or","operation"=>"like",), array("column"=>"documents.user_name", "value"=>$args->s_user_name,"pipe"=>"or","operation"=>"like",), array("column"=>"documents.user_id", "value"=>$args->s_user_id,"pipe"=>"or","operation"=>"like",), array("column"=>"documents.nick_name", "value"=>$args->s_nick_name,"pipe"=>"or","operation"=>"like",), array("column"=>"documents.email_address", "value"=>$args->s_email_addres,"pipe"=>"or","operation"=>"like",), array("column"=>"documents.homepage", "value"=>$args->s_homepage,"pipe"=>"or","operation"=>"like",), array("column"=>"documents.tags", "value"=>$args->s_tags,"pipe"=>"or","operation"=>"like",), array("column"=>"documents.is_secret", "value"=>$args->s_is_secret,"pipe"=>"or","operation"=>"equal",), array("column"=>"documents.member_srl", "value"=>$args->s_member_srl,"pipe"=>"or","operation"=>"equal",), array("column"=>"documents.readed_count", "value"=>$args->s_readed_count,"pipe"=>"or","operation"=>"more",), array("column"=>"documents.voted_count", "value"=>$args->s_voted_count,"pipe"=>"or","operation"=>"more",), array("column"=>"documents.comment_count", "value"=>$args->s_comment_count,"pipe"=>"or","operation"=>"more",), array("column"=>"documents.trackback_count", "value"=>$args->s_trackback_count,"pipe"=>"or","operation"=>"more",), array("column"=>"documents.uploaded_count", "value"=>$args->s_uploaded_count,"pipe"=>"or","operation"=>"more",), array("column"=>"documents.regdate", "value"=>$args->s_regdate,"pipe"=>"or","operation"=>"like_prefix",), array("column"=>"documents.last_update", "value"=>$args->s_last_update,"pipe"=>"or","operation"=>"like_prefix",), array("column"=>"documents.ipaddress", "value"=>$args->s_ipaddress,"pipe"=>"or","operation"=>"like_prefix",), )), ); $output->order = array(array($args->sort_index?$args->sort_index:"documents.list_order",in_array($args->order_type,array("asc","desc"))?$args->order_type:("order_type"?"order_type":"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; ?>