Changeset 2022

Timestamp:

Mar 5, 2007, 5:55:47 PM (15 years ago)

Author:

ishida

Message:

http://trac.openpne.jp/ticket/466
#466 ユーザーを最終ログイン日時で絞り込めるように
実装完了

Location:

OpenPNE/branches/ishida/prj_dev28/webapp/modules/admin

Files:

• lib/db_admin.php (modified) (2 diffs)
• page/list_c_member.php (modified) (1 diff)
• templates/list_c_member.tpl (modified) (1 diff)

OpenPNE/branches/ishida/prj_dev28/webapp/modules/admin/lib/db_admin.php

@@ -550 +550 @@
         $params[] = $cond_list['e_year'];
     }
+
+
+    //最終ログイン時間で絞り込み
+
+    if (isset($cond_list['last_login'])) {
+
+        //期間で分ける
+        switch($cond_list['last_login']) {
+            case 1: //3日以内
+                $sql .= ' AND access_date >= ?';
+                $params[] = date('Y-m-d', strtotime('-3 day'));
+            break;
+
+            case 2: //3～7日以内
+                $sql .= ' AND access_date >= ? AND access_date < ?';
+                $params[] = date('Y-m-d', strtotime('-7 day'));
+                $params[] = date('Y-m-d', strtotime('-3 day'));
+            break;
+
+            case 3: //7～30日以内
+                $sql .= ' AND access_date >= ? AND access_date < ?';
+                $params[] = date('Y-m-d', strtotime('-30 day'));
+                $params[] = date('Y-m-d', strtotime('-7 day'));
+            break;
+
+            case 4: //30～90日以内
+                $sql .= ' AND access_date >= ? AND access_date < ?';
+                $params[] = date('Y-m-d', strtotime('-90 day'));
+                $params[] = date('Y-m-d', strtotime('-30 day'));
+            break;
+        }
+    }
+
     $sql .= ' ORDER BY c_member_id';
 
@@ -622 +655 @@
         }
     }
+
+    // 最終ログイン時間
+    if (!empty($requests['last_login'])) {
+        $cond_list['last_login'] = intval($requests['last_login']);
+    }
+
+
     return $cond_list;
 }

OpenPNE/branches/ishida/prj_dev28/webapp/modules/admin/page/list_c_member.php

@@ -37 +37 @@
         $v['profile_list'] = db_member_c_profile_list();;
 
+        //絞り込みのための最終ログイン時間
+        $select_last_login = array(
+            1 => "3日以内",
+            2 => "3～7日以内",
+            3 => "7～30日以内",
+            4 => "30～90日以内",
+        );
+        $v['select_last_login'] = $select_last_login;
+
+
         //開始年が終了年より大きい
         if ( !empty($cond_list['s_year']) && !empty($cond_list['e_year']) && ($cond_list['s_year'] > $cond_list['e_year']) ) {

OpenPNE/branches/ishida/prj_dev28/webapp/modules/admin/templates/list_c_member.tpl

@@ -88 +88 @@
                         <th class="cell03">&nbsp;</th>
                         <th class="cell04"><img src="./modules/admin/img/dummy.gif" /></th>
-                        <th class="cell05"><img src="./modules/admin/img/dummy.gif" /></th>
+                        <th class="cell05">
+            <select class="basic" onChange="Link('?m=({$module_name})&amp;a=page_({$hash_tbl->hash('list_c_member')})&amp;page=({$pager.page})&amp;page_size=({$pager.page_size})({$cond})&amp;last_login='+this.options[this.selectedIndex].value);">
+            <option value="">選択して下さい</option>
+            ({foreach from=$select_last_login item=item key=key})
+            <option ({if $cond_list.last_login==$key})selected({/if}) value="({$key})">({$item})</option>
+            ({/foreach})
+            </select>
+            </th>
                         <th class="cell06"><img src="./modules/admin/img/dummy.gif" /></th>
                         <th class="cell07"><img src="./modules/admin/img/dummy.gif" /></th>