년월일별 아카이브 리스트 만들기

<query id="getYearlyArchivedList" action="select">
    <tables>
        <table name="documents" />
    </tables>
    <columns>
        <column name="substr(regdate,1,4)" alias="year" />
        <column name="count(*)" alias="count" />
    </columns>
    <conditions>
        <condition operation="in" column="module_srl" var="module_srl" filter="number" />
        <condition operation="like_prefix" column="regdate" var="regdate" pipe="and" />
    </conditions>
    <groups>
        <group column="substr(regdate,1,4)" />
    </groups>
</query>

<query id="getDailyArchivedList" action="select">

<column name="substr(regdate,1,8)" alias="day" />

/**
 * Bringing a year on the status of the yaerly posts
 * @param object $obj
 * @return object
 */
function getYearlyArchivedList($obj)
{
    if($obj->mid)
    {
        $oModuleModel = getModel('module');
        $obj->module_srl = $oModuleModel->getModuleSrlByMid($obj->mid);
        unset($obj->mid);
    }
    // Module_srl passed the array may be a check whether the array
    $args = new stdClass;
    if(is_array($obj->module_srl)) $args->module_srl = implode(',', $obj->module_srl);
    else $args->module_srl = $obj->module_srl;
    $args->regdate = $obj->regdate;

    $output = executeQuery('document.getYearlyArchivedList', $args);
    if(!$output->toBool()) return $output;

    if(!is_array($output->data)) $output->data = array($output->data);

    return $output;
}

var $search_option = array('title_content','title','content','comment','user_name','nick_name','user_id','tag','regdate');

{@
    $args = new stdClass;
    $args->module_srl = $module_info->module_srl;
    $oDocumentModel = &getModel('document');
    $year = $oDocumentModel->getYearlyArchivedList($args);
    $month = $oDocumentModel->getMonthlyArchivedList($args);
    $day = $oDocumentModel->getDailyArchivedList($args);
}
<div loop="array_reverse($year->data)=>$key1,$val1" class="archive-yearly">
    <a href="{getUrl('','mid',$mid,'search_target','regdate','search_keyword',$val1->year)}">
        {zdate($val1->year,'Y')}({number_format($val1->count)})
    </a>
    <div loop="array_reverse($month->data)=>$key2,$val2" cond="zdate($val2->month,'Y')==zdate($val1->year,'Y')" class="archive-monthly">
        <a href="{getUrl('','mid',$mid,'search_target','regdate','search_keyword',$val2->month)}">
            {zdate($val2->month,'F')}({number_format($val2->count)})
        </a>
        <div loop="array_reverse($day->data)=>$key3,$val3" cond="zdate($val3->day,'Ym')==zdate($val2->month,'Ym')" class="archive-daily">
            <a href="{getUrl('','mid',$mid,'search_target','regdate','search_keyword',$val3->day)}">
                {zdate($val3->day,'jS')}({number_format($val3->count)})
            </a>
        </div>
    </div>
</div>