function execute($requests) { $u = $GLOBALS['KTAI_C_MEMBER_ID']; // --- リクエスト変数 $target_c_commu_id = $requests['target_c_commu_id']; $target_c_member_id = $requests['target_c_member_id']; $body = $requests['body']; // ---------- //--- 権限チェック // コミュニティ管理者 // コミュニティ副管理者ではない // 自分自身へのメッセージ送信ではない // すでに管理者交代依頼メッセージ送信済みではない // すでに副管理者要請メッセージを送信済みでない if (!db_commu_is_c_commu_admin($target_c_commu_id, $u)) { handle_kengen_error(); } if (db_commu_is_c_commu_sub_admin($target_c_commu_id, $u)) { handle_kengen_error(); } if ($u == $target_c_member_id) { handle_kengen_error(); } $target_c_commu_admin_confirm_list = db_commu_anatani_c_commu_admin_confirm_list4c_member_id($target_c_member_id); if (!empty($target_c_commu_admin_confirm_list)) { foreach ($target_c_commu_admin_confirm_list as $value) { if ($value['c_commu_id'] == $target_c_commu_id) { handle_kengen_error(); } } } $target_c_commu_sub_admin_confirm_list = db_commu_anatani_c_commu_sub_admin_confirm_list4c_member_id($target_c_member_id); if (!empty($target_c_commu_sub_admin_confirm_list)) { foreach ($target_c_commu_sub_admin_confirm_list as $value) { if ($value['c_commu_id'] == $target_c_commu_id) { handle_kengen_error(); } } } //--- $this->set('inc_navi', fetch_inc_navi("c", $target_c_commu_id)); $member = db_member_c_member_with_profile($target_c_member_id); $member['last_login'] = p_f_home_last_login4access_date($member['access_date']); $this->set("member", $member); $this->set("c_commu", db_commu_c_commu4c_commu_id($target_c_commu_id)); $this->set('body', $body); return 'success'; }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $target_c_commu_admin_confirm_id = $requests['target_c_commu_admin_confirm_id']; // ---------- //--- 権限チェック //コミュニティ管理者交代を受けているメンバー $admin_confirm = db_c_commu_admin_confirm4c_commu_admin_confirm_id($target_c_commu_admin_confirm_id); if ($admin_confirm['c_member_id_to'] != $u) { handle_kengen_error(); } // ----- //副管理者なら副管理者から昇格 if (db_commu_is_c_commu_sub_admin($admin_confirm['c_commu_id'], $u)) { db_commu_update_c_commu_c_member_id_sub_admin($admin_confirm['c_commu_id'], 0); } db_commu_delete_c_commu_sub_admin_confirm4c_commu_id($admin_confirm['c_commu_id']); db_commu_update_c_commu_c_member_id_admin($admin_confirm['c_commu_id'], $u); $msg = '承認が完了しました'; $p = array('msg' => $msg); openpne_redirect('pc', 'page_h_confirm_list', $p); }
function execute($requests) { $tail = $GLOBALS['KTAI_URL_TAIL']; $u = $GLOBALS['KTAI_C_MEMBER_ID']; // --- リクエスト変数 $target_c_commu_admin_confirm_id = $requests['target_c_commu_admin_confirm_id']; // ---------- //--- 権限チェック //コミュ管理交代を受けている $admin_confirm = db_c_commu_admin_confirm4c_commu_admin_confirm_id($target_c_commu_admin_confirm_id); if ($admin_confirm['c_member_id_to'] != $u) { handle_kengen_error(); } //--- //副管理者なら副管理者から昇格 if (db_commu_is_c_commu_sub_admin($admin_confirm['c_commu_id'], $u)) { db_commu_update_c_commu_c_member_id_sub_admin($admin_confirm['c_commu_id'], 0); } db_commu_delete_c_commu_sub_admin_confirm4c_commu_id($admin_confirm['c_commu_id']); db_commu_update_c_commu_c_member_id_admin($admin_confirm['c_commu_id'], $u); $p = array('msg' => 3); openpne_redirect('ktai', 'page_h_confirm_list', $p); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $target_c_commu_id = $requests['target_c_commu_id']; $target_c_member_id = $requests['target_c_member_id']; // ---------- //--- 権限チェック //コミュニティ管理者 //コミュニティ副管理者ではない if (!db_commu_is_c_commu_admin($target_c_commu_id, $u)) { handle_kengen_error(); } if (db_commu_is_c_commu_sub_admin($target_c_commu_id, $u)) { handle_kengen_error(); } //--- $this->set('inc_navi', fetch_inc_navi("c", $target_c_commu_id)); $member = db_member_c_member_with_profile($target_c_member_id); $member['last_login'] = p_f_home_last_login4access_date($member['access_date']); $this->set("member", $member); $this->set("c_commu", db_commu_c_commu4c_commu_id($target_c_commu_id)); return 'success'; }
function db_commu_c_member_list4c_commu_id($c_commu_id, $page_size, $page) { $c_commu = db_commu_c_commu4c_commu_id($c_commu_id); $sql = "SELECT c_member.c_member_id," . "nickname," . "image_filename ," . "c_commu_member.r_datetime" . " FROM c_member," . "c_commu_member" . " WHERE c_commu_id = ?" . " AND c_commu_member.c_member_id = c_member.c_member_id" . " ORDER BY c_commu_member.r_datetime DESC"; $params = array(intval($c_commu_id)); $list = db_get_all_page($sql, $page, $page_size, $params); $new_list = array(); foreach ($list as $key => $value) { $new_list[] = $value; } $list = $new_list; $sql = 'SELECT * FROM c_commu_admin_confirm WHERE c_commu_id = ?'; $params = array(intval($c_commu_id)); $c_commu_admin_confirm = db_get_row($sql, $params); $sql = 'SELECT * FROM c_commu_sub_admin_confirm WHERE c_commu_id = ?'; $c_commu_sub_admin_confirm = db_get_row($sql, $params); if ($c_commu_admin_confirm) { foreach ($list as $key => $c_member) { if ($list[$key]['c_member_id'] == $c_commu_admin_confirm['c_member_id_to']) { $list[$key]['c_commu_admin_confirm_id'] = $c_commu_admin_confirm['c_commu_admin_confirm_id']; } else { $list[$key]['c_commu_admin_confirm_id'] = 0; } } } else { foreach ($list as $key => $c_member) { $list[$key]['c_commu_admin_confirm_id'] = -1; } } if ($c_commu_sub_admin_confirm) { foreach ($list as $key => $c_member) { if ($list[$key]['c_member_id'] == $c_commu_sub_admin_confirm['c_member_id_to']) { $list[$key]['c_commu_sub_admin_confirm_id'] = $c_commu_sub_admin_confirm['c_commu_sub_admin_confirm_id']; } else { $list[$key]['c_commu_sub_admin_confirm_id'] = 0; } } } else { foreach ($list as $key => $c_member) { $list[$key]['c_commu_sub_admin_confirm_id'] = -1; } } foreach ($list as $key => $c_member) { $list[$key]['is_c_commu_admin'] = db_commu_is_c_commu_admin($c_commu_id, $list[$key]['c_member_id']); $list[$key]['is_c_commu_sub_admin'] = db_commu_is_c_commu_sub_admin($c_commu_id, $list[$key]['c_member_id']); } $total_num = db_commu_count_c_commu_member_list4c_commu_id($c_commu_id); if ($total_num != 0) { $total_page_num = ceil($total_num / $page_size); if ($page >= $total_page_num) { $next = false; } else { $next = true; } if ($page <= 1) { $prev = false; } else { $prev = true; } } return array($list, $prev, $next, $total_num); }