示例#1
0
@(include_once G5_PLUGIN_PATH . "/sms5/JSON.php");
if (!function_exists('json_encode')) {
    function json_encode($data)
    {
        $json = new Services_JSON();
        return $json->encode($data);
    }
}
ajax_auth_check($auth[$sub_menu], "r");
$err = '';
$arr_ajax_msg = array();
$exist_hplist = array();
if (!$bk_hp) {
    $err = '휴대폰번호를 입력해 주십시오.';
}
$bk_hp = get_hp($bk_hp);
$sql = " select count(*) as cnt from {$g5['sms5_book_table']} where bk_hp = '{$bk_hp}' ";
if ($w == 'u' && $bk_no) {
    $sql .= " and bk_no <> '{$bk_no}' ";
}
$row = sql_fetch($sql);
if ($row['cnt']) {
    $err = '같은 번호가 존재합니다.';
}
// 수정일 때 회원정보에서 중복체크
if (!$row['cnt'] && $w == 'u') {
    $sql = " select mb_id from {$g5['member_table']} where mb_hp = '{$bk_hp}' and mb_hp <> '' ";
    if ($mb_id) {
        $sql .= " and mb_id <> '{$mb_id}' ";
    }
    $result = sql_query($sql);
示例#2
0
                        break;
                    default:
                        // "미 확인 오류"
                        $hs_memo = "알 수 없는 오류로 전송이 실패하었습니다.";
                        break;
                }
                $wr_failure++;
                $hs_flag = 0;
            } else {
                $hs_code = $code;
                $hs_memo = get_hp($phone, 1) . "로 전송했습니다.";
                $wr_success++;
                $hs_flag = 1;
            }
            $row = array_shift($list);
            $row['bk_hp'] = get_hp($row['bk_hp'], 1);
            $log = array_shift($SMS->Log);
            $log = @iconv('euc-kr', 'utf-8', $log);
            sql_query("insert into {$g5['sms5_history_table']} set wr_no='{$wr_no}', wr_renum='{$new_wr_renum}', bg_no='{$row['bg_no']}', mb_id='{$row['mb_id']}', bk_no='{$row['bk_no']}', hs_name='{$row['hs_name']}', hs_hp='{$row['hs_hp']}', hs_datetime='" . G5_TIME_YMDHIS . "', hs_flag='{$hs_flag}', hs_code='{$hs_code}', hs_memo='" . addslashes($hs_memo) . "', hs_log='" . addslashes($log) . "'", false);
        }
        $SMS->Init();
        // 보관하고 있던 결과값을 지웁니다.
        sql_query("update {$g5['sms5_write_table']} set wr_success='{$wr_success}', wr_failure='{$wr_failure}' where wr_no='{$wr_no}' and wr_renum='{$new_wr_renum}'");
        sql_query("update {$g5['sms5_write_table']} set wr_re_total=wr_re_total+1 where wr_no='{$wr_no}' and wr_renum=0");
    } else {
        alert("에러: SMS 서버와 통신이 불안정합니다.");
    }
} else {
    alert("에러: SMS 데이터 입력도중 에러가 발생하였습니다.");
}
?>
示例#3
0
                        $mh_log = "사용기간이 만료되었습니다.";
                        break;
                    case '99':
                        // "99:인증실패"
                        $mh_log = "인증 받지 못하였습니다. 계정을 다시 확인해 주세요.";
                        break;
                    default:
                        // "미 확인 오류"
                        $mh_log = "알 수 없는 오류로 전송이 실패하었습니다.";
                        break;
                }
            } else {
                $is_success = true;
                $mh_log = "문자전송:" . get_hp($hp, 1);
            }
            $hp = get_hp($hp, 1);
            $log = array_shift($SMS->Log);
            sql_query("insert into {$g5['sms5_member_history_table']} set mb_id='{$member['mb_id']}', mh_reply='{$mh_reply}', mh_hp='{$hp}', mh_datetime='" . G5_TIME_YMDHIS . "', mh_booking='{$mh_booking}', mh_log='{$mh_log}', mh_ip='" . $_SERVER['REMOTE_ADDR'] . "'");
            if ($is_admin == 'super') {
                $sms5['cf_point'] = 0;
            }
            if ($is_success) {
                insert_point($member['mb_id'], -1 * $sms5['cf_point'], "{$mh_log}");
            }
        }
        $SMS->Init();
        // 보관하고 있던 결과값을 지웁니다.
    } else {
        alert("에러: SMS 서버와 통신이 불안정합니다.");
    }
} else {
     case '.csv':
         $name = $csv[$i][0];
         $str_encode = @mb_detect_encoding($name, $encode);
         if ($str_encode == "EUC-KR") {
             $name = iconv_utf8($name);
         }
         $name = addslashes($name);
         $hp = addslashes($csv[$i][1]);
         break;
     case '.xls':
         $name = addslashes($data->sheets[0]['cells'][$i][$j++]);
         $str_encode = @mb_detect_encoding($name, $encode);
         if ($str_encode == "EUC-KR") {
             $name = iconv_utf8($name);
         }
         $hp = addslashes(get_hp($data->sheets[0]['cells'][$i][$j++]));
         break;
 }
 if (!(strlen($name) && $hp)) {
     $failure++;
 } else {
     if (in_array($hp, $arr_hp)) {
         $inner_overlap++;
     } else {
         array_push($arr_hp, $hp);
         $res = sql_fetch("select * from {$g5['sms5_book_table']} where bk_hp='{$hp}'");
         if ($res) {
             $overlap++;
         } else {
             if (!$confirm && $hp) {
                 sql_query("insert into {$g5['sms5_book_table']} set bg_no='{$bg_no}', bk_name='" . addslashes($name) . "', bk_hp='{$hp}', bk_receipt=1, bk_datetime='" . G5_TIME_YMDHIS . "'");
示例#5
0
$qry = sql_query("select mb_id, mb_name, mb_hp, mb_sms, mb_leave_date from " . $g5['member_table'] . " order by mb_datetime");
while ($res = sql_fetch_array($qry)) {
    if ($res['mb_leave_date'] != '') {
        $leave++;
    } else {
        if ($res['mb_hp'] == '') {
            $hp_empty++;
        } else {
            if (is_hp($res['mb_hp'])) {
                $hp_yes++;
            } else {
                $hp_no++;
            }
        }
    }
    $hp = get_hp($res['mb_hp']);
    if ($hp == '') {
        $bk_receipt = 0;
    } else {
        $bk_receipt = $res['mb_sms'];
    }
    $field = "mb_id='{$res['mb_id']}', bk_name='" . addslashes($res['mb_name']) . "', bk_hp='{$hp}', bk_receipt='{$bk_receipt}', bk_datetime='" . G5_TIME_YMDHIS . "'";
    $res2 = sql_fetch("select * from {$g5['sms5_book_table']} where mb_id='{$res['mb_id']}'");
    if ($res2) {
        $res3 = sql_fetch("select count(*) as cnt from {$g5['sms5_book_table']} where mb_id='{$res2['mb_id']}'");
        $mb_count = $res3['cnt'];
        // 회원이 삭제되었다면 휴대폰번호 DB 에서도 삭제한다.
        if ($res['mb_leave_date']) {
            sql_query("delete from {$g5['sms5_book_table']} where mb_id='{$res2['mb_id']}'");
            $sql = "update {$g5['sms5_book_group_table']} set bg_count = bg_count - {$mb_count}, bg_member = bg_member - {$mb_count}";
            if ($res2['bk_receipt'] == 1) {
示例#6
0
            case 'h':
                // 개별 휴대폰 번호 입력
                $item[$i] = explode(':', $item[$i]);
                $hp = get_hp($item[$i][0], 0);
                $name = $item[$i][0];
                if (array_overlap($hps, $hp)) {
                    $overlap++;
                    continue;
                }
                array_push($list, array('bk_hp' => $hp, 'bk_name' => $name));
                array_push($hps, $hp);
                break;
            case 'p':
                // 개인 선택
                $res = sql_fetch("select * from {$g5['sms5_book_table']} where bk_no='{$item[$i]}'");
                $res['bk_hp'] = get_hp($res['bk_hp'], 0);
                if (array_overlap($hps, $res['bk_hp'])) {
                    $overlap++;
                    continue;
                }
                array_push($list, $res);
                array_push($hps, $res['bk_hp']);
                break;
        }
    }
}
if ($overlap) {
    die("중복되는 휴대폰번호가 {$overlap} 건 있습니다. ");
} else {
    die("중복되는 휴대폰번호가 없습니다. ");
}
include_once G5_LIB_PATH . '/Excel/php_writeexcel/class.writeexcel_workbook.inc.php';
include_once G5_LIB_PATH . '/Excel/php_writeexcel/class.writeexcel_worksheet.inc.php';
$fname = tempnam(G5_DATA_PATH, "tmp.xls");
$workbook = new writeexcel_workbook($fname);
$worksheet = $workbook->addworksheet();
$num2_format =& $workbook->addformat(array(num_format => '\\0#'));
// Put Excel data
$data = array('이름', '전화번호');
$data = array_map('iconv_euckr', $data);
$col = 0;
foreach ($data as $cell) {
    $worksheet->write(0, $col++, $cell);
}
for ($i = 1; $res = sql_fetch_array($qry); $i++) {
    $res = array_map('iconv_euckr', $res);
    $hp = get_hp($res['bk_hp'], $hyphen);
    if ($no_hp && $res['bk_hp'] != '' && !$hp) {
        continue;
    }
    $worksheet->write($i, 0, $res['bk_name']);
    $worksheet->write($i, 1, $hp, $num2_format);
}
$workbook->close();
$filename = "휴대폰번호목록-" . date("ymd", time()) . ".xls";
if (is_ie()) {
    $filename = utf2euc($filename);
}
header("Content-Type: application/x-msexcel; name=" . $filename);
header("Content-Disposition: inline; filename=" . $filename);
$fh = fopen($fname, "rb");
fpassthru($fh);