function execute($requests)
{
if (!OPENPNE_USE_POINT_RANK || !OPENPNE_IS_POINT_ADMIN && $requests['target_c_member_id'] == 1) {
admin_client_redirect('top', '指定されたページにはアクセスできません');
}
$target_c_member_id = $requests['target_c_member_id'];
$update_point = $requests['point'];
$c_profile = db_member_c_profile4name('PNE_POINT');
$c_member_profile_list['PNE_POINT'] = array('c_profile_id' => $c_profile['c_profile_id'], 'c_profile_option_id' => 0, 'value' => intval($update_point), 'public_flag' => $c_profile['public_flag_default']);
db_member_update_c_member_profile($target_c_member_id, $c_member_profile_list);
admin_client_redirect('list_c_member', "メンバーのポイントを強制変更しました");
}
function execute($requests)
{
$member_file = $_FILES['member_file'];
$limit = 1000;
// 行数制限
if (empty($member_file) || $member_file['error'] === UPLOAD_ERR_NO_FILE) {
$this->handleError('ファイルを指定してください');
}
$filename_parts = explode('.', $member_file['name']);
if (array_pop($filename_parts) != 'csv') {
$this->handleError('拡張子は.csvにしてください');
}
$handle = fopen($member_file['tmp_name'], 'r');
if (($data = fgetcsv($handle, 4096)) === false) {
$this->handleError('ファイルの内容が空です');
}
$required_list = array('nickname', 'mail_address', 'password');
if (OPENPNE_AUTH_MODE == 'pneid') {
$required_list[] = 'login_id';
}
foreach ($required_list as $required) {
if (!in_array($required, $data)) {
$this->handleError('1行目: ' . $required . 'は必須項目です');
}
}
$title = array();
foreach ($data as $key => $value) {
$matches = array();
if (preg_match('/^profile\\[(.*)\\]$/', $value, $matches)) {
$is_profile = true;
$name = $matches[1];
$c_profile = db_member_c_profile4name($name);
} else {
$is_profile = false;
$name = $value;
$c_profile = null;
}
$title[$key] = array('is_profile' => $is_profile, 'name' => $name, 'c_profile' => $c_profile);
}
$row = 1;
// 1行目がタイトル行
$count = 0;
// メンバー登録に成功した数
while (($data = fgetcsv($handle, 4096)) !== false && $row <= $limit) {
$row++;
$data_member = array();
$data_profile = array();
foreach ($data as $key => $value) {
if (empty($title[$key])) {
continue;
}
$name = $title[$key]['name'];
if ($title[$key]['is_profile']) {
if ($title[$key]['c_profile']['form_type'] === 'checkbox') {
$data_profile[$name] = explode(',', $value);
} else {
$data_profile[$name] = $value;
}
} else {
$data_member[$name] = $value;
}
}
if (is_ktai_mail_address($data_member['mail_address'])) {
$data_member['mail_address'] = str_replace('"', '', $data_member['mail_address']);
}
// validate
$errors = array();
$validator = new OpenPNE_Validator();
$validator->addRequests($data_member);
$validator->addRules($this->_getValidateRules());
if (!$validator->validate()) {
$errors = array_merge($errors, $validator->getErrors());
}
$member = $validator->getParams();
// mail_address
if (!db_common_is_mailaddress($member['mail_address'])) {
$errors[] = "メールアドレス [{$member['mail_address']}] はメールアドレスとして正しくありません";
} elseif (db_member_is_sns_join4mail_address($member['mail_address'])) {
$errors[] = "メールアドレス [{$member['mail_address']}] は既に登録済みです";
} elseif (!db_member_is_limit_domain4mail_address($member['mail_address'])) {
$errors[] = "メールアドレス [{$member['mail_address']}] は登録できません";
}
// login_id
if (OPENPNE_AUTH_MODE == 'pneid') {
if (db_member_c_member_id4username($member['login_id'])) {
$errors[] = "ログインID［{$member['login_id']}］は既に登録済みです";
}
}
// 生年月日のチェック
if ($member['birth_year'] || $member['birth_month'] || $member['birth_day']) {
if (!t_checkdate($member['birth_month'], $member['birth_day'], $member['birth_year'])) {
$errors[] = '生年月日を正しく入力してください';
} elseif (t_isFutureDate($member['birth_day'], $member['birth_month'], $member['birth_year'])) {
$errors[] = '生年月日を未来に設定することはできません';
}
}
if ($errors) {
$this->handleError("{$row}行目：" . array_shift($errors));
}
// profile
$c_member_profile = db_member_check_profile($data_profile, array());
// register
// メールアドレスが携帯メールアドレスのドメインの場合は、
// 携帯メールアドレスとして登録する
if (is_ktai_mail_address($member['mail_address'])) {
$ktai_address = $member['mail_address'];
$pc_address = '';
} else {
$ktai_address = '';
$pc_address = $member['mail_address'];
}
$c_member = array('nickname' => $member['nickname'], 'birth_year' => $member['birth_year'], 'birth_month' => $member['birth_month'], 'birth_day' => $member['birth_day'], 'c_password_query_id' => 0, 'c_member_id_invite' => 1, 'is_receive_mail' => 1, 'is_receive_ktai_mail' => 1, 'is_receive_daily_news' => 1, 'public_flag_birth_year' => $member['public_flag_birth_year'], 'public_flag_birth_month_day' => $member['public_flag_birth_month_day']);
if (OPENPNE_AUTH_MODE == 'pneid') {
$c_member['login_id'] = $member['login_id'];
}
$c_member_secure = array('password' => $member['password'], 'pc_address' => $pc_address, 'ktai_address' => $ktai_address, 'regist_address' => $member['mail_address']);
if (!util_regist_c_member($c_member, $c_member_secure, $c_member_profile)) {
$this->handleError("{$row}行目：メンバー登録に失敗しました");
}
$count++;
}
fclose($handle);
admin_client_redirect('import_c_member', "{$count}件のインポートが完了しました");
}
