Changeset 4292 for sandbox

Timestamp:

06/18/2008 05:48:10 PM (3 months ago)

Author:

zero

Message:

세션 정보에 해당 세션이 위치하는 mid값을 기입하도록 하였고 현재 접속자 출력 위젯에서 mid값을 반영할 수 있도록 변경

Location:

sandbox

Files:

• modules/session/queries/getLoggedMembers.xml (modified) (1 diff)
• modules/session/queries/getLoogedMemberList.xml (deleted)
• modules/session/queries/insertSession.xml (modified) (1 diff)
• modules/session/queries/updateSession.xml (modified) (1 diff)
• modules/session/schemas/session.xml (modified) (1 diff)
• modules/session/session.class.php (modified) (3 diffs)
• modules/session/session.controller.php (modified) (1 diff)
• modules/session/session.model.php (modified) (2 diffs)
• widgets/logged_members/conf/info.xml (modified) (1 diff)
• widgets/logged_members/logged_members.class.php (modified) (1 diff)

sandbox/modules/session/queries/getLoggedMembers.xml

@@ -8 +8 @@
     <conditions>
         <condition operation="more" column="last_update" var="last_update" notnull="notnull" />
+        <condition operation="equal" column="cur_mid" var="mid" pipe="and" />
     </conditions>
     <navigation>

sandbox/modules/session/queries/insertSession.xml

@@ -10 +10 @@
         <column name="ipaddress" default="ipaddress()" />
         <column name="last_update" default="curdate()" />
+        <column name="cur_mid" var="cur_mid" />
     </columns>
 </query>

sandbox/modules/session/queries/updateSession.xml

@@ -9 +9 @@
         <column name="ipaddress" default="ipaddress()" />
         <column name="last_update" default="curdate()" />
+        <column name="cur_mid" var="cur_mid" />
     </columns>
     <conditions>

sandbox/modules/session/schemas/session.xml

@@ -6 +6 @@
     <column name="ipaddress" type="varchar" size="128" notnull="notnull" />
     <column name="last_update" type="date" index="idx_session_update" />
+    <column name="cur_mid" type="varchar" size="128" index="idx_session_cur_mid" />
 </table>

sandbox/modules/session/session.class.php

@@ -26 +26 @@
             $oModuleController->insertActionForward('session', 'view', 'dispSessionAdminIndex');
 
+            $oDB = &DB::getInstance();
+            $oDB->addIndex("session","idx_session_update_mid", array("last_update","cur_mid"));
+
             return new Object();
         }
@@ -39 +42 @@
 
             if(!$oDB->isTableExists('session')) return true;
+
+            if(!$oDB->isColumnExists("session","cur_mid")) return true;
+
+            if(!$oDB->isIndexExists("session","idx_session_update_mid")) return true;
 
             return false;
@@ -55 +62 @@
             if(!$oModuleModel->getActionForward('dispSessionAdminIndex')) 
                 $oModuleController->insertActionForward('session', 'view', 'dispSessionAdminIndex');
+
+            if(!$oDB->isColumnExists("session","cur_mid")) {
+                $oDB->addColumn('session',"cur_mid","varchar",128);
+            }
+
+            if(!$oDB->isIndexExists("session","idx_session_update_mid")) 
+                $oDB->addIndex("session","idx_session_update_mid", array("last_update","cur_mid"));
+
         }
 

sandbox/modules/session/session.controller.php

@@ -35 +35 @@
             $args->expired = date("YmdHis", time()+$this->lifetime);
             $args->val = $val;
+            $args->cur_mid = Context::get('mid');
+            if(!$args->cur_mid) {
+                $module_info = Context::get('current_module_info');
+                $args->cur_mid = $module_info->mid;
+            }
 
             if(Context::get('is_logged')) {

sandbox/modules/session/session.model.php

@@ -28 +28 @@
                 $oDB = &DB::getInstance();
                 if(!$oDB->isTableExists('session')) $oDB->createTableByXmlFile($this->module_path.'schemas/session.xml');
+                if(!$oDB->isColumnExists("session","cur_mid")) $oDB->addColumn('session',"cur_mid","varchar",128);
+                $output = executeQuery('session.getSession', $args);
+            }
+
+            // 세션 정보에서 cur_mid값이 없을 경우 테이블 생성 체크
+            if(!isset($output->data->cur_mid)) {
+                $oDB = &DB::getInstance();
+                if(!$oDB->isColumnExists("session","cur_mid")) $oDB->addColumn('session',"cur_mid","varchar",128);
             }
 
@@ -35 +43 @@
         /**
          * @brief 현재 접속중인 사용자의 목록을 구함
-         * period_time 인자의 값을 n으로 하여 최근 n분 이내에 세션을 갱신한 대상을 추출함
+         * 여러개의 인자값을 필요로 해서 object를 인자로 받음
+         * limit_count : 대상 수
+         * page : 페이지 번호
+         * period_time : 인자의 값을 n으로 하여 최근 n분 이내에 세션을 갱신한 대상을 추출함
+         * mid : 특정 mid에 속한 사용자
          **/
-        function getLoggedMembers($limit_count = 20, $page = 1, $period_time = 3) {
-            $args->last_update = date("YmdHis", time() - $period_time*60);
-            $args->page = $page;
+        function getLoggedMembers($args) {
+            if(!$args->limit_count) $args->limit_count = 20;
+            if(!$args->page) $args->page = 1;
+            if(!$args->period_time) $args->period_time = 3;
+            $args->last_update = date("YmdHis", time() - $args->period_time*60);
 
             $output = executeQueryArray('session.getLoggedMembers', $args);

sandbox/widgets/logged_members/conf/info.xml

@@ -14 +14 @@
             <description xml:lang="ko">출력될 목록의 수를 정하실 수 있습니다. (기본 5개)</description>
         </var>
+        <var id="use_mid">
+            <name xml:lang="ko">대상 지정</name>
+            <type>select</type>
+            <description xml:lang="ko">대상을 전체로 하면 홈페이지 접속자 모두가 출력되고 Mid 구분으로 하게 되면 접속한 Mid에 같이 접속한 회원만 출력이 됩니다.</description>
+            <options>
+                <name xml:lang="ko">전체</name>
+                <value>total</value>
+            </options>
+            <options>
+                <name xml:lang="ko">Mid 구분</name>
+                <value>mid</value>
+            </options>
+        </var>
     </extra_vars>
 </widget>

sandbox/widgets/logged_members/logged_members.class.php

@@ -17 +17 @@
         function proc($args) {
 
-            // 위젯 자체적으로 설정한 변수들을 체크
             $list_count = (int)$args->list_count;
             if(!$list_count) $list_count = 5;
 
+            $use_mid = $args->use_mid;
+            if($use_mid == 'mid') $mid = Context::get('mid');
+            else $mid = null;
+
+            $obj->list_count = $list_count;
+            $obj->mid = $mid;
+
             // session model 객체 생성
             $oSessionModel = &getModel('session');
-            $output = $oSessionModel->getLoggedMembers($list_count);
+            $output = $oSessionModel->getLoggedMembers($obj);
             $widget_info->member_list = $output->data;
             Context::set('widget_info', $widget_info);