Changeset 10887

Timestamp:

Feb 26, 2009, 5:57:51 PM (13 years ago)

Author:

ruikubo

Message:

#2099 管理画面にメッセージ数の表示機能追加

Location:

OpenPNE/branches/work/ruikubo/admin_message_num/webapp/modules/admin

Files:

• lib/smarty_plugins/function.t_assign_sns_info.php (modified) (2 diffs)
• templates/inc_dashboard.tpl (modified) (1 diff)

OpenPNE/branches/work/ruikubo/admin_message_num/webapp/modules/admin/lib/smarty_plugins/function.t_assign_sns_info.php

@@ -25 +25 @@
         'info_diary_count_today' => _getDiaryCountToday(),
         'info_diary_count_yesterday' => _getDiaryCountYesterday(),
+        'info_message_count_today' => _getMessageCountToday(),
+        'info_message_count_yesterday' => _getMessageCountYesterday(),
     );
 
@@ -107 +109 @@
 }
 
+/**
+ * 今日のメッセージ件数
+ */
+function _getMessageCountToday()
+{
+    $today = date('Y-m-d H:i:s', mktime(0, 0, 0, date('m'), date('d'), date('Y')));
+
+    $sql = 'SELECT COUNT(*) FROM c_message WHERE r_datetime >= ?';
+    $params = array($today);
+    return db_get_one($sql, $params);
+}
+
+/**
+ * 前日のメッセージ件数
+ */
+function _getMessageCountYesterday()
+{
+    $yesterday = date('Y-m-d H:i:s', mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')));
+    $today = date('Y-m-d H:i:s', mktime(0, 0, 0, date('m'), date('d'), date('Y')));
+
+    $sql = 'SELECT COUNT(*) FROM c_message WHERE r_datetime >= ? AND r_datetime < ?';
+    $params = array($yesterday, $today);
+    return db_get_one($sql, $params);
+}
+
 ?>

OpenPNE/branches/work/ruikubo/admin_message_num/webapp/modules/admin/templates/inc_dashboard.tpl

@@ -15 +15 @@
     <dt>今日の({$WORD_DIARY})数</dt>
     <dd>({$sns_info.info_diary_count_today|number_format})件 (前日({$sns_info.info_diary_count_yesterday|number_format})件)</dd>
+    <dt>今日のメッセージ数</dt>
+    <dd>({$sns_info.info_message_count_today|number_format})件 (前日({$sns_info.info_message_count_yesterday|number_format})件)</dd>
 </dl>
             </div>