query_id = "communication.getReceivedMessages"; $output->action = "select"; 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->message_type)){ $args->message_type = array_values(get_method_vars($args->message_type)); } if(is_array($args->message_type) && count($args->message_type)==0){ unset($args->message_type); }; if(!isset($args->message_type)) $args->message_type = "R"; if(!isset($args->member_srl)) return new Object(-1, sprintf($lang->filter->isnull, $lang->member_srl?$lang->member_srl:'member_srl')); $output->column_type["message_srl"] = "number"; $output->column_type["related_srl"] = "number"; $output->column_type["sender_srl"] = "number"; $output->column_type["receiver_srl"] = "number"; $output->column_type["message_type"] = "char"; $output->column_type["title"] = "varchar"; $output->column_type["content"] = "text"; $output->column_type["readed"] = "char"; $output->column_type["list_order"] = "number"; $output->column_type["regdate"] = "date"; $output->column_type["readed_date"] = "date"; $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["find_account_question"] = "number"; $output->column_type["find_account_answer"] = "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["change_password_date"] = "date"; $output->column_type["is_admin"] = "char"; $output->column_type["description"] = "text"; $output->column_type["extra_vars"] = "text"; $output->column_type["list_order"] = "number"; $output->tables = array( "message"=>"member_message","member"=>"member", ); $output->_tables = array( "message"=>"member_message","member"=>"member", ); $output->columns = array ( array("name"=>"message.*","alias"=>""), array("name"=>"member.user_id","alias"=>""), array("name"=>"member.member_srl","alias"=>""), array("name"=>"member.nick_name","alias"=>""), array("name"=>"member.user_name","alias"=>""), ); $output->conditions = array ( array("pipe"=>"", "condition"=>array(array("column"=>"message.receiver_srl", "value"=>$args->member_srl,"pipe"=>"","operation"=>"equal",), array("column"=>"message.message_type", "value"=>$args->message_type?$args->message_type:"R","pipe"=>"and","operation"=>"equal",), array("column"=>"message.sender_srl", "value"=>"member.member_srl","pipe"=>"and","operation"=>"equal",), )), ); $output->order = array(array($args->sort_index?$args->sort_index:"message.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:""); return $output; ?>