// 중복 체크
void CRegNewUserDlg::OnBtnDupidCheck()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
if( m_strId.IsEmpty() )
{
AfxMessageBox("사용자ID를 입력하세요");
GetDlgItem(ID_EB_USER_ID)->SetFocus();
return;
}
else
if( CheckUserId(m_strId, ID_EB_USER_ID) == FALSE )
{
return;
}
char szSql [200];
memset(szSql, 0x00 , sizeof(szSql));
sprintf(szSql, "SELECT USER_NAME FROM KM_DOCUSER WHERE USER_ID = '%s'", (LPCSTR)m_strId) ;
//TEST
//sprintf(szSql, "SELECT USER_NAME FROM KM_DOCUSER WHERE USER_ID = '%s'!SELECT USER_NAME FROM KM_DOCUSER WHERE USER_ID = '%s'", (LPCSTR)m_strId, (LPCSTR)m_strId) ;
//sprintf(szSql, "INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!INSERT INTO TB_TESTKOJH(C1) VALUES('1')!") ;
if(CChatSession::Instance().RequestRawSQL(RAWSQL_CHK_DUP_ID, szSql, strlen(szSql) ) != TRUE)
{
return;
}
}
int AdProtocolGdt::HttpToInternal(AdAdapterPara * pPara)
{
ADATREQ_C CReq;
// ADATRSP_C *CRSP;
ADATIMP_C *CImp;
// ADATGEO_C *CGeo;
// ADATAPP_C *CApp;
ADATDEV_C *CDev;
ADATUSR_C *CUsr;
ADATGEO_C *CGeo;
ADATAPP_C *CApp;
AdATUSERDEMO_C *CUserDemo;
ADATUSERVERT_C *CUserVert;
char* pBody = pPara->m_pBody;
int iBody = pPara->m_iBody;
int iCount = 0;
char sVal[AD_BYTE512];
int iFlow = AD_PROTOCOL_FLOW_PC;
if(true == CReq.ParseFromArray(pBody, iBody)){
// required int32 version = 1;
if (true == CReq.has_id())
{
pPara->m_ctRequest.m_sBidID = CReq.id();
}
else
{
}
// required string bid = 2;
if (true == CReq.has_is_ping()) {}
if (true == CReq.has_is_test()) {}
if (true == CReq.has_ip()) {
pPara->m_ctRequest.m_sUserIP = CReq.ip();
}
if (true == CReq.has_area_code()) {
snprintf(sVal, AD_BYTE512, "%d", CReq.area_code());
pPara->m_ctRequest.m_sArea = sVal;
}
for(iCount = 0; iCount < CReq.impressions_size(); iCount++){
CImp = const_cast<ADATIMP_C *>(&CReq.impressions(iCount));
if (true == CImp->has_id()) {
GDT_STR_IMPID(pPara) = CImp->id();
}
if (true == CImp->has_placement_id()) {
snprintf(sVal, AD_BYTE512, "%ld", CImp->placement_id());
pPara->m_ctRequest.m_sPId = sVal;
}
int iImcs = rand()%CImp->creative_specs_size();
if(mtSize.find(CImp->creative_specs(iImcs)) != mtSize.end()){
pPara->m_ctRequest.m_sSize = mtSize[CImp->creative_specs(iImcs)];
iFlow = mtPltf[CImp->creative_specs(iImcs)];
}else{
iImcs = rand()%CImp->creative_specs_size();
if(mtSize.find(CImp->creative_specs(iImcs)) != mtSize.end()){
pPara->m_ctRequest.m_sSize = mtSize[CImp->creative_specs(iImcs)];
iFlow = mtPltf[CImp->creative_specs(iImcs)];
}
}
if(true == CImp->has_bid_floor()){
snprintf(sVal, AD_BYTE512, "%d", CImp->bid_floor());
pPara->m_ctRequest.m_sMinPrice = sVal;
}
for(int iBcount = 0;iBcount < CImp->blocking_industry_id_size(); iBcount++){}
}
if (true == CReq.has_device()) {
CDev = const_cast<ADATDEV_C*>(&CReq.device());
if(true == CDev->has_device_type()) {
if(CDev->device_type() == 1){
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_WPHONE);
}
if(CDev->device_type() == 2){
iFlow = AD_PROTOCOL_FLOW_MOBILE;
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_IPHONE);
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_ANDROID);
}else if(CDev->device_type() == 3){
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_IPAD);
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_APAD);
}
}
if(true == CDev->has_os()) {
if(CDev->os() == 1){ //IOS
if(true == CDev->has_id()) {
pPara->m_ctRequest.m_sIDFA = CDev->id();
}
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_IPHONE);
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_IPAD);
}else if(CDev->os() == 2){
if(true == CDev->has_id()) {
pPara->m_ctRequest.m_sIMEI = CDev->id();
}
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_ANDROID);
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_APAD);
}else if(CDev->os() == 3){
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_WPHONE);
}else if(CDev->os() == 4){
}else if(CDev->os() == 5){
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_ANDROID);
pPara->m_ctRequest.m_ltMobileDevice.push_back(AD_PROTOCOL_MOBILE_DEV_APAD);
}
}
if(true == CDev->has_os_version()) {}
if(true == CDev->has_user_agent()) {
pPara->m_ctRequest.m_sUserAgent = CDev->user_agent();
AdUaParser(pPara);
}
if((true == CDev->has_screen_width()) && (true == CDev->has_screen_height())) {}
if(true == CDev->has_dpi()) {}
if(true == CDev->has_carrier()) {
if(CDev->carrier() == 1){
pPara->m_ctRequest.m_ltMobileOperator.push_back(AD_PROTOCOL_MOBILE_OPERATE_YIDONG);
}else if(CDev->carrier() == 2){
pPara->m_ctRequest.m_ltMobileOperator.push_back(AD_PROTOCOL_MOBILE_OPERATE_LIANTONG);
}else if(CDev->carrier() == 3){
pPara->m_ctRequest.m_ltMobileOperator.push_back(AD_PROTOCOL_MOBILE_OPERATE_DIANXIN);
}
}
if(true == CDev->has_connection_type()) {
if(CDev->connection_type() == 1){
pPara->m_ctRequest.m_ltMobileConnect.push_back(AD_PROTOCOL_MOBILE_CON_WIFI);
}else if(CDev->connection_type() == 2){
pPara->m_ctRequest.m_ltMobileConnect.push_back(AD_PROTOCOL_MOBILE_CON_2G);
}else if(CDev->connection_type() == 3){
pPara->m_ctRequest.m_ltMobileConnect.push_back(AD_PROTOCOL_MOBILE_CON_3G);
}else if(CDev->connection_type() == 4){
pPara->m_ctRequest.m_ltMobileConnect.push_back(AD_PROTOCOL_MOBILE_CON_4G);
}
}
if(true == CDev->has_brand_and_model()) {}
if(true == CDev->has_language()) {}
}
if (true == CReq.has_user()) {
CUsr = const_cast<ADATUSR_C*>(&CReq.user());
if(true == CUsr->has_id()){
pPara->m_ctRequest.m_sUserID = CUsr->id();
}
if(true == CUsr->has_user_demographic()) {
CUserDemo = const_cast<AdATUSERDEMO_C*>(&CUsr->user_demographic());
if(true == CUserDemo->has_gender()){}
if(true == CUserDemo->has_education()){}
if(true == CUserDemo->has_age_low()){}
if(true == CUserDemo->has_age_high()){}
}
if(0 != CUsr->verticals_size()){
for(iCount = 0; iCount < CUsr->verticals_size(); iCount++){
CUserVert = const_cast<ADATUSERVERT_C *>(&CUsr->verticals(iCount));
if(CUserVert->has_id()){}
if(CUserVert->has_weight()){}
}
}
}
if(true == CReq.has_geo()){
CGeo = const_cast<ADATGEO_C *>(&CReq.geo());
if(true == CGeo->has_latitude()){}
if(true == CGeo->has_longitude()){}
if(true == CGeo->has_accuracy()){}
}
if(true == CReq.has_app()){
CApp = const_cast<ADATAPP_C *>(&CReq.app());
if(CApp->has_industry_id()){
char stTmp[AD_BYTE64] = {0};
snprintf(stTmp, AD_BYTE64, "%ld", CApp->industry_id());
string stCat = stTmp;
pPara->m_ctRequest.m_ltSiteCategory.push_back(stCat);
}
if(CApp->has_app_bundle_id()){}
}
snprintf(sVal, AD_BYTE512, "%d", iFlow);
pPara->m_ctRequest.m_sFlow = sVal;
}
else
{
return AD_FAILURE;
}
CheckUserId(pPara);
return AD_SUCCESS;
}
BOOL CRegNewUserDlg::chkValidation()
{
// 주민번호
if( m_strJuminNo.GetLength() != 13 )
{
AfxMessageBox("주민번호 13자리를 확인하세요", MB_ICONINFORMATION);
GetDlgItem(ID_EB_REG_SID)->SetFocus();
((CEdit*)GetDlgItem(ID_EB_REG_SID))->SetSel(0,-1);
return FALSE;
}
// 사용자명
if( m_strName.GetLength() == 0 )
{
AfxMessageBox("사용자이름을 입력하세요", MB_ICONINFORMATION);
GetDlgItem(ID_EB_REG_NAME)->SetFocus();
((CEdit*)GetDlgItem(ID_EB_REG_NAME))->SetSel(0,-1);
return FALSE;
}
// ID
if( m_strId.IsEmpty() ){
AfxMessageBox("사용자ID를 입력하세요");
GetDlgItem(ID_EB_USER_ID)->SetFocus();
return FALSE;
}
else
{
if( CheckUserId(m_strId, ID_EB_USER_ID) == FALSE )
return FALSE;
}
// PASSWORD
if( m_strPw1.IsEmpty() ){
AfxMessageBox("비밀번호를 입력하세요");
GetDlgItem(ID_EB_PWD)->SetFocus();
return FALSE;
}
else if( m_strPw1 != m_strPw2 ){
AfxMessageBox("입력하신 비밀번호가 일치하지 않습니다");
GetDlgItem(ID_EB_PWD)->SetFocus();
return FALSE;
}
else
{
if( CheckUserPw(m_strPw1, ID_EB_PWD) == FALSE )
return FALSE;
}
// 작업일지 작성
if( m_nDocYesNo == 0 )
m_strJobWrite = _T("Y");
else
m_strJobWrite = _T("N");
// 사무실전화번호
if( m_strTelOfc1 != _T("") || m_strTelOfc2 != _T("") || m_strTelOfc3 != _T("") )
{
m_strTelOfc.Format(_T("%04d-%04d-%04d")
, atoi(m_strTelOfc1)
, atoi(m_strTelOfc2)
, atoi(m_strTelOfc3) );
}
else
m_strTelOfc = _T("");
// 내선번호
if( m_strTelIn != _T("") )
m_strTelIn.Format("%d" , atoi(m_strTelIn));
// 핸드폰
if( m_strTelHp1 != _T("") || m_strTelHp2 != _T("") || m_strTelHp3 != _T("") )
{
m_strTelHp.Format(_T("%04d-%04d-%04d")
, atoi(m_strTelHp1)
, atoi(m_strTelHp2)
, atoi(m_strTelHp3) );
}
else
m_strTelHp = _T("");
// 소속
if( m_cbCompany.GetCode() == _T("") )
{
AfxMessageBox(_T("소속을 선택하세요"));
m_cbCompany.SetFocus();
return FALSE;
}
// 팀구분
if( m_cbTeam.GetCode() == _T("") )
{
AfxMessageBox(_T("팀을 선택하세요"));
m_cbTeam.SetFocus();
return FALSE;
}
return TRUE;
}
