// 중복 체크 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; }