member.admin.model.php

Go to the documentation of this file.

<?php
/* Copyright (C) NAVER <http://www.navercorp.com> */
class memberAdminModel extends member
{
    var $member_info = NULL;

    var $member_groups = NULL;

    var $join_form_list = NULL;

    function init()
    {
    }

    function getMemberList()
    {
        // Search option
        $args = new stdClass();
        $args->is_admin = Context::get('is_admin')=='Y'?'Y':'';
        $args->is_denied = Context::get('is_denied')=='Y'?'Y':'';
        $args->selected_group_srl = Context::get('selected_group_srl');

        $filter = Context::get('filter_type');
        switch($filter)
        {
            case 'super_admin' : $args->is_admin = 'Y';break;
            case 'site_admin' : $args->member_srls = $this->getSiteAdminMemberSrls();break;
            case 'enable' : $args->is_denied = 'N';break;
            case 'disable' : $args->is_denied = 'Y';break;
        }

        $search_target = trim(Context::get('search_target'));
        $search_keyword = trim(Context::get('search_keyword'));

        if($search_target && $search_keyword)
        {
            switch($search_target)
            {
                case 'user_id' :
                    if($search_keyword) $search_keyword = str_replace(' ','%',$search_keyword);
                    $args->s_user_id = $search_keyword;
                    break;
                case 'user_name' :
                    if($search_keyword) $search_keyword = str_replace(' ','%',$search_keyword);
                    $args->s_user_name = $search_keyword;
                    break;
                case 'nick_name' :
                    if($search_keyword) $search_keyword = str_replace(' ','%',$search_keyword);
                    $args->s_nick_name = $search_keyword;
                    $args->html_nick_name = htmlspecialchars($search_keyword, ENT_COMPAT | ENT_HTML401, 'UTF-8', false);
                    break;
                case 'email_address' :
                    if($search_keyword) $search_keyword = str_replace(' ','%',$search_keyword);
                    $args->s_email_address = $search_keyword;
                    break;
                case 'regdate' :
                    $args->s_regdate = preg_replace("/[^0-9]/","",$search_keyword);
                    break;
                case 'regdate_more' :
                    $args->s_regdate_more = substr(preg_replace("/[^0-9]/","",$search_keyword) . '00000000000000',0,14);
                    break;
                case 'regdate_less' :
                    $args->s_regdate_less = substr(preg_replace("/[^0-9]/","",$search_keyword) . '00000000000000',0,14);
                    break;
                case 'last_login' :
                    $args->s_last_login = preg_replace("/[^0-9]/","",$search_keyword);
                    //$args->s_last_login = $search_keyword;
                    break;
                case 'last_login_more' :
                    $args->s_last_login_more = substr(preg_replace("/[^0-9]/","",$search_keyword) . '00000000000000',0,14);
                    break;
                case 'last_login_less' :
                    $args->s_last_login_less = substr(preg_replace("/[^0-9]/","",$search_keyword) . '00000000000000',0,14);
                    break;
                case 'birthday' :
                    $args->s_birthday = preg_replace("/[^0-9]/","",$search_keyword);
                    break;
                case 'extra_vars' :
                    $args->s_extra_vars = $search_keyword;
                    break;
            }
        }

        // Change the query id if selected_group_srl exists (for table join)
        $sort_order = Context::get('sort_order');
        $sort_index = Context::get('sort_index');
        if(!$sort_index)
        {
            $sort_index = "list_order";
        }

        if(!$sort_order)
        {
            $sort_order = 'asc';
        }

        if($sort_order != 'asc')
        {
            $sort_order = 'desc';
        }

        if($args->selected_group_srl)
        {
            $query_id = 'member.getMemberListWithinGroup';
            $args->sort_index = "member.".$sort_index;
        }
        else
        {
            $query_id = 'member.getMemberList';
            $args->sort_index = $sort_index; 
        }

        $args->sort_order = $sort_order;
        Context::set('sort_order', $sort_order);
        // Other variables
        $args->page = Context::get('page');
        $args->list_count = 40;
        $args->page_count = 10;
        $output = executeQuery($query_id, $args);

        return $output;
    }

    function getSiteMemberList($site_srl, $page = 1)
    {
        $args->site_srl = $site_srl;
        $args->page = $page;
        $args->list_count = 40;
        $args->page_count = 10;
        $query_id = 'member.getSiteMemberList';
        $output = executeQueryArray($query_id, $args);
        return $output;
    }

    function getSiteAdminMemberSrls()
    {
        $output = executeQueryArray('member.getSiteAdminMemberSrls');
        if(!$output->toBool() || !$output->data) return array();

        $member_srls = array();
        foreach($output->data as $member_info)
        {
            $member_srls[] = $member_info->member_srl;
        }

        return $member_srls;
    }

    function getMemberAdminColorset()
    {
        $skin = Context::get('skin');
        if(!$skin) $tpl = "";
        else
        {
            $oModuleModel = getModel('module');
            $skin_info = $oModuleModel->loadSkinInfo($this->module_path, $skin);
            Context::set('skin_info', $skin_info);

            $oModuleModel = getModel('module');
            $config = $oModuleModel->getModuleConfig('member');
            if(!$config->colorset) $config->colorset = "white";
            Context::set('config', $config);

            $oTemplate = &TemplateHandler::getInstance();
            $tpl = $oTemplate->compile($this->module_path.'tpl', 'new_colorset_list');
        }

        $this->add('tpl', $tpl);
    }


    public function getMemberCountByDate($date = '')
    {
        $args = new stdClass();
        if($date) $args->regDate = date('Ymd', strtotime($date));

        $output = executeQuery('member.getMemberCountByDate', $args);
        if(!$output->toBool()) return 0;

        return $output->data->count;
    }

    function getMemberGroupMemberCountByDate($date = '')
    {
        if($date) $args->regDate = date('Ymd', strtotime($date));

        $output = executeQuery('member.getMemberGroupMemberCountByDate', $args);
        if(!$output->toBool()) return 0;

        return count($output->data);
    }

    function getMemberAdminInsertJoinForm()
    {
        $member_join_form_srl = Context::get('member_join_form_srl');

        $args = new stdClass();
        $args->member_join_form_srl = $member_join_form_srl;
        $output = executeQuery('member.getJoinForm', $args);

        if($output->toBool() && $output->data)
        {
            $formInfo = $output->data;
            $default_value = $formInfo->default_value;
            if($default_value)
            {
                $default_value = unserialize($default_value);
                Context::set('default_value', $default_value);
            }
            Context::set('formInfo', $output->data);
        }

        $oMemberModel = getModel('member');
        $config = $oMemberModel->getMemberConfig();
        foreach($config->signupForm as $item) 
        {
            $list[] = $item->name;
        }

        $id_list = implode(',',$list);
        Context::set('id_list',$id_list);

        $oTemplate = &TemplateHandler::getInstance();
        $tpl = $oTemplate->compile($this->module_path.'tpl', 'insert_join_form');

        $this->add('tpl', str_replace("\n"," ",$tpl));
    }

    function getMemberAdminIPCheck()
    {
        $db_info = Context::getDBInfo();
        $admin_ip_list = $db_info->admin_ip_list;
        if(!$admin_ip_list) return true;
        if(!is_array($admin_ip_list)) $admin_ip_list = explode(',',$admin_ip_list);
        if(!count($admin_ip_list) || IpFilter::filter($admin_ip_list)) return true;
        else return false;
    }
}
/* End of file member.admin.model.php */
/* Location: ./modules/member/member.admin.model.php */