function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
$page = $requests['page'];
// ----------
$page_size = 20;
//ページ
$this->set("page", $page);
//メンバーリスト
$list = db_commu_c_members4c_commu_id($target_c_commu_id, $page_size, $page);
if (empty($list[0])) {
handle_kengen_error();
}
$this->set("c_member_list", $list[0]);
$this->set("is_prev", $list[1]);
$this->set("is_next", $list[2]);
$pager = array();
$pager['start'] = $page_size * ($page - 1) + 1;
$pager['end'] = $pager['start'] + count($list[0]) - 1;
$this->set('pager', $pager);
// コミュニティ
$this->set('c_commu', db_commu_c_commu4c_commu_id_k($target_c_commu_id));
//コミュニティID
$this->set("c_commu_id", $target_c_commu_id);
//コミュニティのメンバー数
$this->set("count_member", db_commu_count_c_commu_member_list4c_commu_id($target_c_commu_id));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
$page = $requests['page'];
// ----------
$this->set('inc_navi', fetch_inc_navi("c", $target_c_commu_id));
//メンバー情報
$this->set("member", db_member_c_member4c_member_id($u));
//コミュニティID
$this->set("c_commu_id", $target_c_commu_id);
$this->set("c_commu", db_commu_c_commu4c_commu_id($target_c_commu_id));
$this->set("c_commu_num", db_commu_count_c_commu_member_list4c_commu_id($target_c_commu_id));
$page_size = 50;
//コミュニティメンバーリスト
list($c_member_list, $is_prev, $is_next, $total_num, $start_num, $end_num) = db_commu_c_members4c_commu_id($target_c_commu_id, $page_size, $page);
$this->set("c_member_list", $c_member_list);
$this->set("is_prev", $is_prev);
$this->set("is_next", $is_next);
$this->set("page", $page);
$this->set("total_num", $total_num);
$this->set('start_num', $start_num);
$this->set('end_num', $end_num);
for ($i = 1; $i <= ceil($total_num / $page_size); $i++) {
$page_num[] = $i;
}
$this->set("page_num", $page_num);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
$page = $requests['page'];
// ----------
$c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id);
//--- 権限チェック
if ($c_commu['c_member_id_admin'] != $u && $c_commu['c_member_id_sub_admin'] != $u) {
ktai_display_error('閲覧権限がありません');
}
//---
$page_size = 5;
//ページ
$this->set("page", $page);
//メンバーリスト
$list = db_commu_c_member_list4c_commu_id($target_c_commu_id, $page_size, $page);
$total_num = $list[3];
$c_member_list = $list[0];
// 管理者交代メッセージ送信先メンバーリスト
foreach ($c_member_list as $key => $c_member) {
if ($c_member['c_member_id'] != $c_commu['c_member_id_admin'] && $c_member['c_commu_admin_confirm_id'] <= 0 && $c_member['c_commu_sub_admin_confirm_id'] <= 0) {
$c_member_list[$key]['is_display_admin'] = true;
} else {
$c_member_list[$key]['is_display_admin'] = false;
}
}
// 副管理者要請メッセージ送信先メンバーリスト
foreach ($c_member_list as $key => $c_member) {
if ($c_member['c_member_id'] != $c_commu['c_member_id_admin'] && $c_member['c_member_id'] != $c_commu['c_member_id_sub_admin'] && $c_member['c_commu_admin_confirm_id'] <= 0 && $c_member['c_commu_sub_admin_confirm_id'] <= 0) {
$c_member_list[$key]['is_display_sub_admin'] = true;
} else {
$c_member_list[$key]['is_display_sub_admin'] = false;
}
}
$this->set("c_member_list", $c_member_list);
$this->set("is_prev", $list[1]);
$this->set("is_next", $list[2]);
$pager = array();
$pager['start'] = $page_size * ($page - 1) + 1;
$pager['end'] = $pager['start'] + count($c_member_list) - 1;
$this->set('pager', $pager);
//コミュニティのメンバー数
$this->set("count_member", db_commu_count_c_commu_member_list4c_commu_id($target_c_commu_id));
$this->set("c_commu", $c_commu);
return 'success';
}
function _db_count_c_commu_member_list4c_commu_id($c_commu_id)
{
return db_commu_count_c_commu_member_list4c_commu_id($c_commu_id);
}
/**
* コミュニティ情報取得関連のfunction cacheを削除する
*/
function cache_drop_c_commu($c_commu_id)
{
$c_commu_id = (int) $c_commu_id;
pne_cache_drop('db_commu_c_commu4c_commu_id_k', $c_commu_id);
pne_cache_drop('db_commu_c_commu_member_list_random4c_commu_id', $c_commu_id, 5);
pne_cache_drop('db_commu_c_commu_member_list4c_commu_id', $c_commu_id, 9);
pne_cache_drop('db_commu_c_commu4c_commu_id2', $c_commu_id);
$c_commu_id = (string) $c_commu_id;
pne_cache_drop('db_commu_c_commu4c_commu_id_k', $c_commu_id);
pne_cache_drop('db_commu_c_commu_member_list_random4c_commu_id', $c_commu_id, 5);
pne_cache_drop('db_commu_c_commu_member_list4c_commu_id', $c_commu_id, 9);
pne_cache_drop('db_commu_c_commu4c_commu_id2', $c_commu_id);
$c_commu_topic_list = db_commu_new_topic_comment4c_commu_id($c_commu_id, 7);
$c_commu_event_list = db_commu_new_topic_comment4c_commu_id($c_commu_id, 7, 1);
$c_commu_bbs_list = array_merge($c_commu_topic_list, $c_commu_event_list);
foreach ($c_commu_bbs_list as $c_commu_topic_id) {
$c_commu_topic_id = (int) $c_commu_topic_id;
cache_drop_c_commu_topic($c_commu_topic_id);
$c_commu_topic_id = (string) $c_commu_topic_id;
cache_drop_c_commu_topic($c_commu_topic_id);
}
$c_commu_member_total_num = db_commu_count_c_commu_member_list4c_commu_id($c_commu_id);
$c_commu_member_list = db_commu_c_member_list4c_commu_id($c_commu_id, 1, $c_commu_member_total_num);
foreach ($c_commu_member_list[0] as $c_member) {
cache_drop_c_commu_list4c_member_id($c_member['c_member_id']);
}
}
/**
* 共通参加コミュニティリスト
*/
function db_common_commu_common_commu_list4c_member_id($target_c_member_id, $u, $page, $page_size)
{
$common_commu_id_list = db_common_commu_common_commu_id4c_member_id($target_c_member_id, $u);
if (is_null($common_commu_id_list)) {
return null;
}
$common_commu_id_str_list = implode(",", $common_commu_id_list);
$sql = "SELECT *" . " FROM c_commu" . " WHERE c_commu_id in (" . $common_commu_id_str_list . ")" . " ORDER BY c_commu_id DESC ";
$common_commu_list = db_get_all_page($sql, $page, $page_size);
foreach ($common_commu_list as $key => $value) {
$common_commu_list[$key]['count_members'] = db_commu_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
}
$pager = array("total_num" => count($common_commu_id_list), "disp_num" => count($common_commu_list), "start_num" => 0, "end_num" => 0, "total_page" => 0, "prev_page" => 0, "next_page" => 0);
if ($pager['disp_num'] > 0) {
$pager['start_num'] = ($page - 1) * $page_size + 1;
$pager['end_num'] = $pager['start_num'] + $pager['disp_num'] - 1;
}
if ($pager['total_num']) {
$pager['total_page'] = ceil($pager['total_num'] / $page_size);
if ($page < $pager['total_page']) {
$pager['next_page'] = max($page + 1, 1);
}
if ($page > 1) {
$pager['prev_page'] = min($page - 1, $pager['total_page']);
}
}
return array($common_commu_list, $pager);
}
