function execute($requests)
{
$cond_list = validate_cond($_REQUEST['cond']);
$profile_cond_list = validate_profile_cond($_REQUEST['profile']);
$profile_value_list = array();
foreach ($profile_cond_list as $key => $each_cond) {
// form_type:checkbox
if (is_array($each_cond)) {
$value = '';
foreach ($each_cond as $option_id) {
if ($value) {
$value .= ', ';
}
$value .= db_c_profile_get_profile_value4requested_profile($key, $option_id);
}
} else {
$value = db_c_profile_get_profile_value4requested_profile($key, $each_cond);
// form_type:text,textarea
if (is_null($value)) {
$value = '「' . $each_cond . '」を含む';
}
}
$profile_value_list[$key]['caption'] = db_c_profile_get_caption4name($key);
$profile_value_list[$key]['value'] = $value;
}
// 絞り込み条件が無い場合はリダイレクト
if (!$cond_list && !$profile_value_list) {
openpne_redirect('admin', 'page_send_messages_all');
}
$v['cond_list'] = $cond_list;
$v['profile_cond_list'] = $profile_cond_list;
$v['profile_value_list'] = $profile_value_list;
//絞り込みのための最終ログイン時間
$select_last_login = array(1 => "3日以内", 2 => "3～7日以内", 3 => "7～30日以内", 4 => "30日以上", 5 => "未ログイン");
$v['select_last_login'] = $select_last_login;
if ($cond_list['s_rank']) {
$v['s_rank'] = db_point_get_rank4rank_id($cond_list['s_rank']);
}
if ($cond_list['e_rank']) {
$v['e_rank'] = db_point_get_rank4rank_id($cond_list['e_rank']);
}
$this->set($v);
return 'success';
}
function execute($requests)
{
$module_name = ADMIN_MODULE_NAME;
$send_type = $requests['send_type'];
$cond_list = validate_cond($_REQUEST['cond']);
$cond_list['profile'] = validate_profile_cond($_REQUEST['profile']);
// 送信者はとりあえず1番で固定
$c_member_id_from = 1;
$c_member_id_list = _db_admin_c_member_id_list($cond_list);
$send_num = 0;
foreach ($c_member_id_list as $key => $c_member_id) {
if ($c_member_id_from == $c_member_id) {
$c_member_id_list[$key] = null;
continue;
}
switch ($send_type) {
case "mail":
do_admin_send_mail($c_member_id, $requests['subject'], $requests['body']);
break;
case "message":
do_admin_send_message($c_member_id_from, $c_member_id, $requests['subject'], $requests['body']);
break;
default:
openpne_forward($module_name, 'page', 'send_messages_search');
exit;
break;
}
$send_num++;
}
//送信履歴登録
db_admin_insert_c_send_messages_history($requests['subject'], $requests['body'], $send_num, $send_type, $c_member_id_list);
switch ($send_type) {
case "mail":
$sended_name = "メール";
break;
case "message":
$sended_name = "メッセージ";
break;
}
admin_client_redirect('top', $sended_name . 'を送信しました');
}
function execute($requests)
{
// エラーメッセージ
$v['msg'] = $_REQUEST['msg'];
// 検索値
$cond_list = validate_cond($_REQUEST);
$v['cond_list'] = $cond_list;
// プロフ項目
$profile_list = db_member_c_profile_list();
$this->set('profile_list', $profile_list);
// 年
$year = date('Y');
$v['years'] = get_int_assoc($year - 100, $year);
// 最終ログイン
$select_last_login = array(1 => "3日以内", 2 => "3～7日以内", 3 => "7～30日以内", 4 => "30日以上", 5 => "未ログイン");
$v['select_last_login'] = $select_last_login;
// ポイントランク
$v['rank_data'] = db_point_get_rank_all();
$this->set($v);
return 'success';
}
function execute($requests)
{
if (!IS_SNS_ENTRY_CONFIRM) {
admin_client_redirect('top', '指定されたページにはアクセスできません');
}
$order = $requests['order'];
$mail_address = $requests['mail_address'];
$v = array();
$pager = array();
//絞り込み条件作成
$cond_list = validate_cond((array) $_REQUEST['cond']);
$v['cond_list'] = $cond_list;
$cond = '';
foreach ($cond_list as $key => $value) {
$cond .= '&cond[' . $key . ']=' . $value;
}
$profile_cond_list = validate_profile_cond((array) $_REQUEST['profile']);
$v['profile_cond_list'] = $profile_cond_list;
foreach ($profile_cond_list as $key => $value) {
$cond .= '&profile[' . $key . ']=' . (int) $value;
}
$v['cond'] = $cond;
//絞り込みのための年
$year = date('Y');
$v['years'] = get_int_assoc($year - 100, $year);
//絞り込みのドロップダウンを作る用
$v['profile_list'] = db_member_c_profile_list();
//開始年が終了年より大きい
if (!empty($cond_list['s_year']) && !empty($cond_list['e_year']) && $cond_list['s_year'] > $cond_list['e_year']) {
$v['msg'] = '※開始年は終了年より小さくして下さい';
}
$v['SNS_NAME'] = SNS_NAME;
$v['c_member_pre_list'] = _db_admin_c_member_pre_list($requests['page'], $requests['page_size'], $pager, $cond_list, $mail_address, $order);
$v['pager'] = $pager;
$this->set($v);
return 'success';
}
function execute($requests)
{
$order = $requests['order'];
$cond = substr($_REQUEST['cond'], 1);
$temp_list = explode('&', $cond);
foreach ($temp_list as $value) {
$temp_list2 = explode('=', $value);
$_REQUEST[$temp_list2[0]] = $temp_list2[1];
}
$v = array();
$pager = array();
//絞り込み条件作成
$cond_list = validate_cond($_REQUEST);
$v['cond_list'] = $cond_list;
$cond = '';
foreach ($cond_list as $key => $value) {
if (is_array($value)) {
foreach ($value as $prof_key => $profile_value) {
if (is_array($profile_value)) {
foreach ($profile_value as $check_value) {
$cond .= '&' . $key . urlencode('[') . $prof_key . urlencode('][]') . '=' . urlencode($check_value);
}
} else {
$cond .= '&' . $key . urlencode('[') . $prof_key . urlencode(']') . '=' . urlencode($profile_value);
}
}
} else {
$cond .= '&' . $key . '=' . urlencode($value);
}
}
$v['cond'] = $cond;
//絞り込みのための年
$year = date('Y');
$v['years'] = get_int_assoc($year - 100, $year);
//絞り込みのドロップダウンを作る用
$v['profile_list'] = db_member_c_profile_list();
//絞り込みのための最終ログイン時間
$select_last_login = array(1 => "3日以内", 2 => "3～7日以内", 3 => "7～30日以内", 4 => "30日以上", 5 => "未ログイン");
$v['select_last_login'] = $select_last_login;
$v['rank_data'] = db_point_get_rank_all();
//開始年が終了年より大きい
if (!empty($cond_list['s_year']) && !empty($cond_list['e_year']) && $cond_list['s_year'] > $cond_list['e_year']) {
$msg = '※開始年は終了年より小さくして下さい';
}
//ランクが開始＞終了
if (!is_null($cond_list['s_rank']) && !is_null($cond_list['e_rank']) && $cond_list['s_rank'] > $cond_list['e_rank']) {
$msg = '※開始ランクは終了ランクより小さくして下さい';
}
if ($msg) {
$v['msg'] = $msg;
}
// 表示用検索データ
$v['cond_name_data'] = cond_name_list($cond_list, $select_last_login);
$v['SNS_NAME'] = SNS_NAME;
$v['c_profile_list'] = db_member_c_profile_list4null();
$v['c_member_list'] = array();
// メンバー検索対応により、メールアドレス検索、ログインID検索ともに下記関数に統合
$v['c_member_list'] = _db_admin_c_member_list($requests['page'], $requests['page_size'], $pager, $cond_list, $order);
foreach ($v['c_member_list'] as $key => $value) {
$v['c_member_list'][$key]['c_member_invite'] = db_member_c_member4c_member_id_LIGHT($value['c_member_id_invite']);
$v['c_member_list'][$key]['c_rank'] = db_point_get_rank4point($value['profile']['PNE_POINT']['value']);
$v['c_member_list'][$key]['is_receive_any_mail'] = db_admin_is_receive_any_mail4c_member_id($value['c_member_id']);
}
$v['pager'] = $pager;
$this->set($v);
return 'success';
}
