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';
 }
Example #5
0
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);
}