|
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/Lib/ |
Upload File : |
<?
/******************************************************************************
*
* 회원 라이브러리
*
******************************************************************************/
// 외부유입 회원 등록
function TO_member_ins_api($channel, $data)
{
$table = "TB_MEMBER";
$today = date('Y-m-d h:i:s');
//if($channel == "") return false;
// 회원아이디
$mb_id=trim($data['mb_id']);
if($mb_id == "") return false;
$mb_id = substr($channel,0,2).$mb_id;
// 아이디 중복 검사
$chk_mem = member_fetch(" and mb_id='{$mb_id}' ");
if(count($chk_mem)>0) {
return false;
}
// 패스워드 임의 생성
$mb_pwd=md5("TK".trim($mb_id));
// 회원 정보 입력
$mb_nm = $data['mb_nm'];
$mb_email = $data['mb_email'];
if(substr($data['mb_phone'], 0, 2) == "01"){
$mb_phone = $data['mb_phone'];
} else {
$mb_tel = $data['mb_phone'];
}
// 전화번호, 이름 중복 검사
if($mb_phone && $mb_nm) {
$chk_mem = member_fetch(" and mb_phone='{$mb_phone}' and mb_nm='{$mb_nm}' ");
if(count($chk_mem)>0) {
return $chk_mem[0]['mb_id']; // 중복 시 기존 회원아이디 리턴
}
}
// 국가
if($data['mb_nat_cd']){
$mb_nat_cd = $data['mb_nat_cd'];
} else {
$mb_nat_cd = "대한민국";
}
$sql = "insert into {$table} set ";
$sql .= " mb_id='{$mb_id}' ";
$sql .= " ,mb_nm='{$mb_nm}' ";
$sql .= " ,mb_pwd='{$mb_pwd}' ";
$sql .= " ,mb_email='{$mb_email}' ";
$sql .= " ,mb_phone='{$mb_phone}' ";
$sql .= " ,mb_cu_level='CULV001'";
$sql .= " ,mb_tel='{$mb_tel}' ";
$sql .= " ,mb_email_yn='N' ";
$sql .= " ,mb_sms_yn='N' ";
$sql .= " ,mb_nat_cd='{$mb_nat_cd}' ";
$sql .= " ,ins_channel='{$channel}' ";
$sql .= " ,ins_dt='{$today}' ";
db_query($sql);
return $mb_id;
}
// 직원 KPI 리스트 불러옴
function TO_member_get_kpi($sql_where="",$sql_order="",$olds='',$line=10){
$sql="SELECT * FROM TB_INTRA_KPI ";
if($sql_where) $sql .=" $sql_where ";
if($sql_order) $sql .= " order by ".$sql_order;
if($olds!=='') $sql .= " limit $olds , $line ";
$data = array();
$rs = db_query($sql);
$i = 0;
while($row = db_fetch_array($rs)){
$data[$i] = $row;
$i++;
}
return $data;
}
// 회원 가입시 입력한 국적에 따른 언어 리턴
function TO_member_get_lang($mb_nat_cd){
switch(strtoupper($mb_nat_cd)){
case 'AMERICAN' :
case 'BRITISH' :
case 'CANADIAN ' :
case 'FILIPINO' :
case 'INDONESIA' :
CASE 'PHILIPPINE' :
case 'THAI' :
case 'USA' :
$mem_lang = 'en';
break;
case 'CHINESE HK' :
case 'HK' :
case 'HONG KONG' :
case 'HONG KONG CHINA' :
case 'HONGKONG' :
case 'MACAU' :
case 'TAIWAN' :
case 'TW' :
case '台灣' :
case '中華民國' :
case '香港' :
$mem_lang = 'hk';
break;
case 'CHINA' :
case 'CHINESE' :
case '中国' :
case '中國' :
$mem_lang = 'cn';
break;
default :
$mem_lang = 'ko';
break;
}
return $mem_lang;
}
// 유입채널 아이콘
function TO_member_get_channel_icon($ins_channel, $lang){
$channel_icon = "";
if($ins_channel != '') {
$ins_channel = strtolower($ins_channel);
$channel_icon_path = "/admin/image/partner/{$ins_channel}.png";
if(is_file(ROOT_DIR.$channel_icon_path) == true){
$channel_icon = "<img src=\"".$channel_icon_path."\">";
}
} else {
if($lang == 'ko') {
$channel_icon = "<img src=\"/admin/image/partner/tourboss.png\">";
} else {
$channel_icon = "<img src=\"/admin/image/partner/tktravel.png\">";
}
}
return $channel_icon;
}