function execute($requests)
{
//<PCKTAI
if (OPENPNE_AUTH_MODE == 'slavepne' || !((OPENPNE_REGIST_FROM & OPENPNE_REGIST_FROM_KTAI) >> 1)) {
openpne_redirect('ktai', 'page_o_login', array('msg' => 42));
}
//>
// --- リクエスト変数
$ses = $requests['ses'];
$aff_id = $requests['aff_id'];
// ----------
// セッションが有効かどうか
if (!($pre = db_member_c_member_ktai_pre4session($ses))) {
// 無効の場合、login へリダイレクト
openpne_redirect('ktai', 'page_o_login', array('msg' => 42));
}
// メールアドレスが登録できるかどうか
if (!util_is_regist_mail_address($pre['ktai_address'])) {
openpne_redirect('ktai', 'page_o_login', array('msg' => 42));
}
if ($aff_id) {
$this->set('aff_id', $aff_id);
}
// 招待者の情報
$c_member_invite = db_member_c_member_with_profile($pre['c_member_id_invite'], 'friend');
$this->set('last_login', p_f_home_last_login4access_date($c_member_invite['access_date']));
$this->set('friend_count', db_friend_count_friends($c_member_invite['c_member_id']));
$this->set('target_c_member', $c_member_invite);
$this->set('ses', $ses);
$this->set('SNS_NAME', SNS_NAME);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
// ----------
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('pc', 'page_h_access_block');
}
if ($target_c_member_id == $u) {
handle_kengen_error();
}
//アクティブメンバーか
if (!db_member_is_active_c_member_id($target_c_member_id)) {
handle_kengen_error();
}
//お気に入り登録済みメンバーか
if (db_bookmark_is_bookmark($u, $target_c_member_id)) {
$p = array('c_member_id_to' => $target_c_member_id);
openpne_redirect('pc', 'page_f_bookmark_add_err_already', $p);
}
$this->set('inc_navi', fetch_inc_navi('f', $target_c_member_id));
$c_member = db_member_c_member_with_profile($target_c_member_id);
$c_member['last_login'] = p_f_home_last_login4access_date($c_member['access_date']);
$this->set('c_member', $c_member);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
// ----------
if ($target_c_member_id == $u) {
openpne_redirect('ktai', 'page_h_home');
}
if (!db_member_is_active_c_member_id($target_c_member_id)) {
ktai_display_error('該当するメンバーが見つかりません。');
}
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('ktai', 'page_h_access_block');
}
//管理画面HTML
$this->set('c_siteadmin', p_common_c_siteadmin4target_pagename('k_f_home'));
//ターゲットのc_member
$is_friend = db_friend_is_friend($u, $target_c_member_id);
$target_c_member = db_member_c_member_with_profile($target_c_member_id, 'private');
$target_c_member['last_login'] = p_f_home_last_login4access_date($target_c_member['access_date']);
if ($target_c_member['birth_year']) {
$target_c_member['age'] = getAge($target_c_member['birth_year'], $target_c_member['birth_month'], $target_c_member['birth_day']);
}
$this->set("target_c_member", $target_c_member);
//ターゲットの最新日記５件
$this->set("c_diary_list", db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, $u));
//フレンドランダム５人
$this->set("c_friend_list", db_friend_c_friend_list_random4c_member_id($target_c_member_id, 5));
//参加コミュニティ最新書き込み５件
$this->set("c_commu_list", db_commu_c_commu_list_lastupdate4c_member_id($target_c_member_id, 5));
//共通コミュニティ
$this->set('common_commu_count', count(db_common_commu_common_commu_id4c_member_id($target_c_member_id, $u)));
//ターゲットと自分との関係
$this->set("relation", db_friend_relationship4two_members($u, $target_c_member_id));
$is_friend = db_friend_is_friend($u, $target_c_member_id);
if ($is_friend) {
$this->set('is_friend', $is_friend);
} else {
$this->set('friend_path', db_friend_friend_path4c_member_ids($u, $target_c_member_id));
}
$this->set('profile_list', db_member_c_profile_list());
// 誕生日まであと何日？
$this->set('days_birthday', db_member_count_days_birthday4c_member_id($target_c_member_id));
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($target_c_member_id);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// inc_entry_point
$this->set('inc_ktai_entry_point', fetch_inc_entry_point($this->getView(), 'ktai_f_home'));
//あしあとをつける
db_ashiato_insert_c_ashiato($target_c_member_id, $u);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
$target_c_member_id = $u;
$this->set('is_h_prof', 1);
$this->set('inc_navi', fetch_inc_navi('h'));
$target_c_member = db_member_c_member_with_profile($u, 'private');
$this->set('is_friend', 0);
$this->set('c_diary_list', db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, null, 'friend'));
if (OPENPNE_USE_ALBUM) {
// アルバム
$this->set('c_album_list', db_album_get_c_album_subject_list4c_member_id($target_c_member_id, 5, null, 'friend'));
}
// --- f_home, h_prof 共通処理
$this->set('target_c_member_id', $target_c_member_id);
$target_c_member['last_login'] = p_f_home_last_login4access_date($target_c_member['access_date']);
if ($target_c_member['birth_year']) {
$target_c_member['age'] = getAge($target_c_member['birth_year'], $target_c_member['birth_month'], $target_c_member['birth_day']);
}
$this->set('target_c_member', $target_c_member);
$this->set('c_rss_cache_list', db_rss_c_rss_cache_list4c_member_id($target_c_member_id, 5));
$this->set('c_friend_comment_list', db_friend_c_friend_comment4c_member_id($target_c_member_id));
$this->set('c_friend_list', db_friend_c_friend_list4c_member_id($target_c_member_id, 9));
$this->set('c_friend_count', db_friend_count_friends($target_c_member_id));
$this->set('user_count', db_commu_count_c_commu4c_member_id($target_c_member_id));
$this->set('c_commu_list', db_commu_c_commu_list4c_member_id_2($target_c_member_id, 9));
$this->set('c_review_list', db_review_c_review_list4member($target_c_member_id, 5));
$this->set('profile_list', db_member_c_profile_list());
// 誕生日まであと何日？
$this->set('days_birthday', db_member_count_days_birthday4c_member_id($target_c_member_id));
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($target_c_member_id);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// ---bizここから
$this->set('is_h_prof', 1);
//カレンダー表示用
$biz_dir = OPENPNE_MODULES_BIZ_DIR . '/biz/';
//bizモジュールディレクトリの定義
include_once $biz_dir . 'lib/smarty_functions.php';
//bizモジュールよりライブラリを拝借
include_once $biz_dir . 'lib/mysql_functions.php';
//bizモジュールよりライブラリを拝借
$this->set('calendar', biz_getScheduleWeek($u, $u, $requests['w'], 'p', true, true, true, $target_c_member));
$todolist = biz_getTodoList($u, $u, "h", $target_c_member['nickname']);
$this->set("todolist", $todolist);
$group_list = biz_getHomeGroupList($u);
$this->set('group_list', $group_list);
// ---bizここまで
// inc_entry_point
$this->set('inc_entry_point', fetch_inc_entry_point($this->getView(), 'f_home'));
return 'success';
}
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';
}
/**
* @copyright 2005-2008 OpenPNE Project
* @license http://www.php.net/license/3_01.txt PHP License 3.01
*/
function db_bookmark_list($c_member_id, $page, $page_size)
{
$sql = 'SELECT c_member_id, nickname, image_filename, access_date' . ' FROM c_bookmark INNER JOIN c_member' . ' ON c_bookmark.c_member_id_to = c_member.c_member_id' . ' WHERE c_bookmark.c_member_id_from = ?' . ' ORDER BY c_bookmark.r_datetime DESC';
$params = array(intval($c_member_id));
$lst = db_get_all_page($sql, $page, $page_size, $params);
foreach ($lst as $key => $value) {
$lst[$key]['profile'] = db_member_c_member_profile_list4c_member_id($value['c_member_id']);
$lst[$key]['last_login'] = p_f_home_last_login4access_date($value['access_date']);
}
$sql = 'SELECT COUNT(*) FROM c_bookmark INNER JOIN c_member' . ' ON c_bookmark.c_member_id_to = c_member.c_member_id' . ' WHERE c_bookmark.c_member_id_from = ?';
$total_num = db_get_one($sql, $params);
if ($total_num === 0) {
$prev = $next = false;
} else {
$total_page_num = ceil($total_num / $page_size);
$next = $page < $total_page_num ? true : false;
$prev = $page > 1 ? true : false;
}
return array($lst, $prev, $next, $total_num);
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
$target_c_member_id = $u;
$this->set('is_h_prof', 1);
$this->set('inc_navi', fetch_inc_navi('h'));
$target_c_member = db_member_c_member_with_profile($u, 'private');
$this->set('is_friend', 0);
$this->set('c_diary_list', db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, null, 'friend'));
if (OPENPNE_USE_ALBUM) {
// アルバム
$this->set('c_album_list', db_album_get_c_album_subject_list4c_member_id($target_c_member_id, 5, null, 'friend'));
}
// --- f_home, h_prof 共通処理
$this->set('target_c_member_id', $target_c_member_id);
$target_c_member['last_login'] = p_f_home_last_login4access_date($target_c_member['access_date']);
if ($target_c_member['birth_year']) {
$target_c_member['age'] = getAge($target_c_member['birth_year'], $target_c_member['birth_month'], $target_c_member['birth_day']);
}
$this->set('target_c_member', $target_c_member);
$this->set('c_rss_cache_list', db_rss_c_rss_cache_list4c_member_id($target_c_member_id, 5));
$this->set('c_friend_comment_list', db_friend_c_friend_comment4c_member_id($target_c_member_id));
$this->set('c_friend_list', db_friend_c_friend_list4c_member_id($target_c_member_id, 9));
$this->set('c_friend_count', db_friend_count_friends($target_c_member_id));
$this->set('user_count', db_commu_count_c_commu4c_member_id($target_c_member_id));
$this->set('c_commu_list', db_commu_c_commu_list4c_member_id_2($target_c_member_id, 9));
$this->set('c_review_list', db_review_c_review_list4member($target_c_member_id, 5));
$this->set('profile_list', db_member_c_profile_list());
// 誕生日まであと何日？
$this->set('days_birthday', db_member_count_days_birthday4c_member_id($target_c_member_id));
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($target_c_member_id);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// inc_entry_point
$this->set('inc_entry_point', fetch_inc_entry_point($this->getView(), 'f_home'));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_id = $requests['target_c_commu_id'];
// ----------
$group = biz_getGroupData($target_id);
if (!$group) {
$p = array();
openpne_redirect('pc', 'page_h_err_c_home', $p);
exit;
}
$this->set("group", $group);
$member_list = biz_getGroupMember($target_id, 9);
$member_list_full = biz_getGroupMember($target_id);
foreach ($member_list as $key => $value) {
$member_list[$key] = db_member_c_member4c_member_id_LIGHT($value['c_member_id']);
}
foreach ($member_list_full as $key => $value) {
$member_list_full[$key] = db_member_c_member4c_member_id($value['c_member_id']);
$member_list_full[$key]['last_login'] = p_f_home_last_login4access_date($member_list_full[$key]['access_date']);
}
$this->set('inc_navi', fetch_inc_navi('h'));
$this->set("member_list", $member_list);
$this->set("member_count", count($member_list_full));
$this->set("admin_data", db_member_c_member4c_member_id_LIGHT($group['admin_id']));
$this->set('calendar_head', biz_getScheduleWeek($u, $target_id, $requests['w'], 'g', ture, false, false));
foreach ($member_list_full as $key => $value) {
$calendar_value .= biz_getScheduleWeek($u, $value['c_member_id'], $requests['w'], 'g', false, true, false, $value);
}
$this->set('calendar_value', $calendar_value);
$this->set('calendar_foot', biz_getScheduleWeek($u, $target_id, $requests['w'], 'g', false, false, true));
if ($u == $group['admin_id']) {
$this->set("is_admin", true);
}
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_member_id = $u;
// ----------
$this->set('is_h_prof', 1);
//管理画面HTML
$this->set('c_siteadmin', p_common_c_siteadmin4target_pagename('k_f_home'));
$target_c_member = db_member_c_member_with_profile($target_c_member_id, 'private');
$target_c_member['last_login'] = p_f_home_last_login4access_date($target_c_member['access_date']);
if ($target_c_member['birth_year']) {
$target_c_member['age'] = getAge($target_c_member['birth_year'], $target_c_member['birth_month'], $target_c_member['birth_day']);
}
$this->set("target_c_member", $target_c_member);
//ターゲットの最新日記５件
$this->set('c_diary_list', db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, null, 'friend'));
//フレンドランダム５人
$this->set("c_friend_list", db_friend_c_friend_list_random4c_member_id($target_c_member_id, 5));
//参加コミュニティ最新書き込み５件
$this->set("c_commu_list", db_commu_c_commu_list_lastupdate4c_member_id($target_c_member_id, 5));
//共通コミュニティ
$this->set('common_commu_count', count(db_common_commu_common_commu_id4c_member_id($target_c_member_id, $u)));
$this->set('profile_list', db_member_c_profile_list());
// 誕生日まであと何日？
$this->set('days_birthday', db_member_count_days_birthday4c_member_id($target_c_member_id));
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($target_c_member_id);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// inc_entry_point
$this->set('inc_ktai_entry_point', fetch_inc_entry_point($this->getView(), 'ktai_f_home'));
return 'success';
}
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 execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
// ----------
// - IDが指定されていない場合
// - IDが自分の場合
// は h_home へリダイレクト
if (!$target_c_member_id || $target_c_member_id == $u) {
openpne_redirect('pc', 'page_h_home');
}
if (!db_member_is_active_c_member_id($target_c_member_id)) {
openpne_redirect('pc', 'page_h_err_f_home');
}
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('pc', 'page_h_access_block');
}
//あしあとをつける
db_ashiato_insert_c_ashiato($target_c_member_id, $u);
$this->set('is_h_prof', 0);
$inc_navi = fetch_inc_navi('f', $target_c_member_id);
$this->set('inc_navi', $inc_navi);
$target_c_member = db_member_c_member_with_profile($target_c_member_id, 'private');
$is_friend = db_friend_is_friend($u, $target_c_member_id);
if ($is_friend) {
// 自分が書いた紹介文
$this->set('my_friend_intro', db_friend_c_friend_intro($u, $target_c_member_id));
} else {
// 友達の友達
$this->set('friend_path', db_friend_friend_path4c_member_ids($u, $target_c_member_id));
}
$this->set('is_friend', $is_friend);
$c_member = db_member_c_member4c_member_id($u);
$this->set('c_member', $c_member);
$c_diary_list = db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, $u);
$this->set('c_diary_list', $c_diary_list);
if (OPENPNE_USE_ALBUM) {
// アルバム
$this->set('c_album_list', db_album_get_c_album_subject_list4c_member_id($target_c_member_id, 5, $u));
}
// --- f_home, h_prof 共通処理
$this->set('target_c_member_id', $target_c_member_id);
$target_c_member['last_login'] = p_f_home_last_login4access_date($target_c_member['access_date']);
if ($target_c_member['birth_year']) {
$target_c_member['age'] = getAge($target_c_member['birth_year'], $target_c_member['birth_month'], $target_c_member['birth_day']);
}
$this->set('target_c_member', $target_c_member);
$this->set('c_rss_cache_list', db_rss_c_rss_cache_list4c_member_id($target_c_member_id, 5));
$c_friend_comment_list = db_friend_c_friend_comment4c_member_id($target_c_member_id);
$this->set('c_friend_comment_list', $c_friend_comment_list);
$c_friend_list = db_friend_c_friend_list4c_member_id($target_c_member_id, 9);
$this->set('c_friend_list', $c_friend_list);
$this->set('c_friend_count', db_friend_count_friends($target_c_member_id));
$this->set('user_count', db_commu_count_c_commu4c_member_id($target_c_member_id));
$this->set('common_commu_count', count(db_common_commu_common_commu_id4c_member_id($target_c_member_id, $u)));
$c_commu_list = db_commu_c_commu_list4c_member_id_2($target_c_member_id, 9);
$this->set('c_commu_list', $c_commu_list);
$this->set('c_review_list', db_review_c_review_list4member($target_c_member_id, 5));
$profile_list = db_member_c_profile_list();
$this->set('profile_list', $profile_list);
// 誕生日まであと何日？
$this->set('days_birthday', db_member_count_days_birthday4c_member_id($target_c_member_id));
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($target_c_member_id);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// inc_entry_point
$this->set('inc_entry_point', fetch_inc_entry_point($this->getView(), 'f_home'));
// ---
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
// ----------
// - IDが指定されていない場合
// - IDが自分の場合
// は h_home へリダイレクト
if (!$target_c_member_id || $target_c_member_id == $u) {
openpne_redirect('pc', 'page_h_home');
}
if (!db_member_is_active_c_member_id($target_c_member_id)) {
openpne_redirect('pc', 'page_h_err_f_home');
}
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('pc', 'page_h_access_block');
}
//あしあとをつける
db_ashiato_insert_c_ashiato($target_c_member_id, $u);
$this->set('is_h_prof', 0);
$this->set('inc_navi', fetch_inc_navi('f', $target_c_member_id));
$is_friend = db_friend_is_friend($u, $target_c_member_id);
$target_c_member = db_member_c_member_with_profile($target_c_member_id, 'private');
if ($is_friend) {
// 自分が書いた紹介文
$this->set('my_friend_intro', db_friend_c_friend_intro($u, $target_c_member_id));
} else {
// 友達の友達
$this->set('friend_path', db_friend_friend_path4c_member_ids($u, $target_c_member_id));
}
$this->set('is_friend', $is_friend);
$this->set('c_member', db_member_c_member4c_member_id($u));
$this->set('c_diary_list', db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, $u));
if (OPENPNE_USE_ALBUM) {
// アルバム
$this->set('c_album_list', db_album_get_c_album_subject_list4c_member_id($target_c_member_id, 5, $u));
}
// --- f_home, h_prof 共通処理
$this->set('target_c_member_id', $target_c_member_id);
$target_c_member['last_login'] = p_f_home_last_login4access_date($target_c_member['access_date']);
if ($target_c_member['birth_year']) {
$target_c_member['age'] = getAge($target_c_member['birth_year'], $target_c_member['birth_month'], $target_c_member['birth_day']);
}
$this->set('target_c_member', $target_c_member);
$target_c_member_all = db_member_c_member_with_profile($target_c_member_id, 'private');
$this->set('target_c_member_all', $target_c_member_all);
$this->set('c_rss_cache_list', db_rss_c_rss_cache_list4c_member_id($target_c_member_id, 5));
$this->set('c_friend_comment_list', db_friend_c_friend_comment4c_member_id($target_c_member_id));
$this->set('c_friend_list', db_friend_c_friend_list4c_member_id($target_c_member_id, 9));
$this->set('c_friend_count', db_friend_count_friends($target_c_member_id));
$this->set('user_count', db_commu_count_c_commu4c_member_id($target_c_member_id));
$this->set('common_commu_count', count(db_common_commu_common_commu_id4c_member_id($target_c_member_id, $u)));
$this->set('c_commu_list', db_commu_c_commu_list4c_member_id_2($target_c_member_id, 9));
$this->set('c_review_list', db_review_c_review_list4member($target_c_member_id, 5));
$this->set('profile_list', db_member_c_profile_list());
// 誕生日まであと何日？
$this->set('days_birthday', db_member_count_days_birthday4c_member_id($target_c_member_id));
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($target_c_member_id);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// --- bizここから
// バナーをBIZ用右部拡張領域下に表示させる為の仕掛け
$this->set('is_f_home', 1);
$biz_dir = OPENPNE_MODULES_BIZ_DIR . '/biz/';
//bizモジュールディレクトリの定義
include_once $biz_dir . 'lib/smarty_functions.php';
//bizモジュールよりライブラリを拝借
include_once $biz_dir . 'lib/mysql_functions.php';
//bizモジュールよりライブラリを拝借
$c_member = db_member_c_member4c_member_id($u);
$todolist = biz_getTodoList($u, $target_c_member_id, "f", $c_member['nickname']);
$this->set("todolist", $todolist);
$this->set('calendar', biz_getScheduleWeek($u, $target_c_member_id, $requests['w'], 'f', true, true, true, $target_c_member));
$group_list = biz_getHomeGroupList($target_c_member_id);
$this->set('group_list', $group_list);
// --- bizここまで
// inc_entry_point
$this->set('inc_entry_point', fetch_inc_entry_point($this->getView(), 'f_home'));
// ---
return 'success';
}
function db_member_search($cond, $cond_like, $page_size, $page, $c_member_id, $profiles)
{
$page = intval($page);
$page_size = intval($page_size);
$wheres = array();
$params = array();
foreach ($cond as $key => $value) {
if ($value) {
if ($key === 'image') {
$wheres[] = "image_filename <> '' AND image_filename <> '0'";
} else {
$wheres[] = db_escapeIdentifier($key) . ' = ?';
$params[] = $value;
if ($key === 'birth_year') {
$wheres[] = "public_flag_birth_year = 'public'";
} elseif ($key === 'birth_month' || $key === 'birth_day') {
$wheres[] = "public_flag_birth_month_day = 'public'";
}
}
}
}
foreach ($cond_like as $key => $value) {
if ($value) {
$wheres[] = db_escapeIdentifier($key) . ' LIKE ?';
$params[] = '%' . $value . '%';
}
}
if ($wheres) {
$where = ' WHERE ' . implode(' AND ', $wheres);
} else {
$where = '';
}
$from = " FROM c_member" . $hint;
$order = " ORDER BY c_member_id DESC";
$sql = "SELECT c_member_id" . $from . $where . $order;
$result_ids = db_get_col($sql, $params);
// 検索設定を公開にしていないメンバーを除外
$sql = "SELECT c_member_id FROM c_member_config WHERE name = 'IS_SEARCH_RESULT' AND value = '0'";
$ids = db_get_col($sql);
$result_ids = array_diff($result_ids, $ids);
foreach ($profiles as $key => $value) {
$sql = "SELECT c_member_id FROM c_member_profile";
$sql .= " WHERE c_profile_id = ? AND public_flag = 'public'";
$params = array(intval($value['c_profile_id']));
if ($value['form_type'] == "text" || $value['form_type'] == "textlong" || $value['form_type'] == 'textarea') {
$sql .= " AND value LIKE ?";
$params[] = '%' . $value['value'] . '%';
} elseif (is_array($value['c_profile_option_id'])) {
$values = implode(',', array_map('intval', $value['c_profile_option_id']));
$sql .= " AND c_profile_option_id IN (" . $values . ")";
} else {
$sql .= " AND c_profile_option_id = ?";
$params[] = intval($value['c_profile_option_id']);
}
$ids = db_get_col($sql, $params);
$result_ids = array_intersect($result_ids, $ids);
}
$result_ids = array_values($result_ids);
$start = ($page - 1) * $page_size;
$list = array();
for ($i = $start; $i < $start + $page_size && $result_ids[$i]; $i++) {
$c_member = db_member_c_member_with_profile($result_ids[$i], 'public');
$c_member['last_login'] = p_f_home_last_login4access_date($c_member['access_date']);
$list[] = $c_member;
}
$total_num = count($result_ids);
if ($total_num != 0) {
$total_page_num = ceil($total_num / $page_size);
if ($page >= $total_page_num) {
$next = false;
} else {
$next = $page + 1;
}
if ($page <= 1) {
$prev = false;
} else {
$prev = $page - 1;
}
}
return array($list, $prev, $next, $total_num);
}
