Changeset 1332 for OpenPNE/branches/ebihara/prj_dev26_bizfix/webapp_biz/lib/db/todo.php

Timestamp:

Dec 22, 2006, 1:54:39 PM (16 years ago)

Author:

ebihara

Message:

一部のBIZ関数について関数名命名規則見直しをし、lib/以下で定義した上で関数内処理を改善した

File:

• OpenPNE/branches/ebihara/prj_dev26_bizfix/webapp_biz/lib/db/todo.php (modified) (2 diffs)

OpenPNE/branches/ebihara/prj_dev26_bizfix/webapp_biz/lib/db/todo.php

@@ -82 +82 @@
 
     foreach (array_merge($membertodo, $sharetodo) as $key => $value) {
-        if (biz_isPermissionTodo($u, $value['biz_todo_id'])) {
+        if (db_todo_public_flag_condition($u, $value['biz_todo_id'])) {
                 $sql = 'SELECT nickname FROM c_member WHERE c_member_id = ?';
                 $params = array(
@@ -179 +179 @@
 }
 
+/**
+ * Todoの管理権限があるかどうか判定
+ */
+function db_todo_public_flag_condition($u, $biz_todo_id)
+{
+    $biz_todo = db_todo_biz_todo4biz_todo_id($biz_todo_id);
+    $public_flag = $biz_todo['public_flag'];
+    $biz_group_id = $biz_todo['biz_group_id'];
+    $target_c_member_id = $biz_todo['c_member_id'];
+
+    switch ($public_flag) {
+    case 'group' :  //グループのメンバーにのみ権限が与えられるTodo
+        if (db_group_is_biz_group_member($u, $biz_group_id)) {
+            return true;
+        } else {
+            return false;
+        }
+    case 'private' :  //投稿者にのみ権限が与えられるTodo
+        if ($target_c_member_id == $u) {
+            return true;
+        } else {
+            return false;
+        }
+    default :  //すべてのユーザに権限が与えられるTodo
+        return true;
+    }
+}
+
+/**
+ * 投稿したTodoリストを取得
+ */
+function db_todo_biz_posted_todo_list4c_member_id($id, $limit = null)
+{
+
+    $sql = 'SELECT * FROM biz_todo WHERE writer_id = ? ORDER BY r_datetime DESC';
+    $params = array(
+        intval($id),
+    );
+
+    if ($limit) {
+        $list = db_get_all_limit($sql, 0, intval($limit), $params);
+    } else {
+        $list = db_get_all($sql, $params);
+    }
+
+    foreach ($list as $key => $value) {
+        $sql = 'SELECT nickname FROM c_member WHERE c_member_id = ?';
+        $params = array(
+            intval($list[$key]['c_member_id']),
+        );
+        $list[$key]['member_name'] = db_get_one($sql, $params);
+    }
+
+    return $list;
+}
+
 ?>