AnimeClub

<?php
    if(!defined("__ZBXE__")) exit();

    class extra_vars {

        function extraList($args){
            $eids = "test";
            $obj->eids = ($args->eids)?$args->eids:$eids;
            $obj->value = ($args->value)?$args->value:false;
            $obj->s_value = ($args->s_value)?$args->s_value:false;
            $obj->var_idxs = ($args->var_idxs)?$args->var_idxs:false;                                   

            $obj->sort_index = "documents.list_order";
            $obj->order_type = "desc";
            $obj->page = Context::get("page");
            $obj->list_count = 20;
            $obj->page_count = 10;
           
            $output = executeQueryArray('board/skins/xe_board.getExtraVars', $obj);

            if(!$output->toBool()) return;
           
            Context::set("etotal_count", $output->total_count);
            Context::set("etotal_page", $output->total_page);
            Context::set("epage", $output->page);
            Context::set("epage_navigation", $output->page_navigation);

            return $output->data;
        }
    }
?>

<query id="getExtraVars" action="select">
    <tables>
        <table name="documents" alias="documents" />   
        <table name="document_extra_vars" alias="document_extra_vars" />
    </tables>
    <columns>
        <column name="documents.*" />
    </columns>
    <conditions>
        <condition operation="equal" column="documents.document_srl" var="document_extra_vars.document_srl" pipe="where" />
        <group pipe="and">
            <condition operation="in" column="document_extra_vars.eid" var="eids" notnull="notnull" pipe="and" />
            <condition operation="equal" column="document_extra_vars.value" var="value" notnull="notnull" pipe="and" />
            <condition operation="like" column="document_extra_vars.value" var="s_value" notnull="notnull" pipe="and" />
            <condition operation="in" column="document_extra_vars.var_idx" var="var_idxs" notnull="notnull" pipe="and" />       
        </group>
    </conditions>
    <navigation>
        <index var="sort_index" default="documents.list_order" order="order_type" />
        <list_count var="list_count" default="20" />
        <page_count var="page_count" default="10" />
        <page var="page" default="1" />
    </navigation>
</query>

<!--@if($func_check)-->
{@
    func_include($tpl_path.'php/class.php');
    $oExtra_vars = new extra_vars();
    $extra->eids = "'test','test2'";
    $extra->value = "A";
//    $extra->var_idxs = "'1','2'";
    $oExtra_info = $oExtra_vars->extraList($extra);
}
    <!--@if($oExtra_info)-->
        <ul>
        <!--@foreach($oExtra_info as $key => $val)-->
            <li>{$val->document_srl} : {$val->title} ({$val->nick_name})</li>
        <!--@endforeach-->
        </ul>
    <!--@endif-->
<!--@endif-->