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); }