This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!doctype html> | |
<title>Test Test</title> | |
<style> | |
#stage { | |
position: relative; | |
} | |
.cell { | |
position: absolute; | |
width: 80px; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE IP_TO_LOCATION ( | |
"IP_FROM" NUMBER NOT NULL, | |
"IP_TO" NUMBER NOT NULL, | |
"COUNTRY_CODE" VARCHAR2(3 CHAR) NOT NULL, | |
"COUNTRY_NAME" VARCHAR2(64 CHAR) NOT NULL, | |
"TYPE" VARCHAR2(2 CHAR), | |
"CHANGE_TS" TIMESTAMP (6) DEFAULT systimestamp, | |
CONSTRAINT IP_TO_LOCATION_PK PRIMARY KEY ("IP_FROM", "IP_TO", "TYPE") | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public void updateUserCORandIP(String registerIpAddress, User consumer) { | |
logger.trace("COR of user [USER_ID:{}] is null, start getting COR by [IP_ADDRESS:{}]", consumer.getUserId(), registerIpAddress); | |
if (StringUtils.isBlank(registerIpAddress)) { | |
throw new WebApplicationException(new IllegalArgumentException("IP address is null, no country can be found")); | |
} | |
commonInternalApi.setBasePath(userConfiguration.getCommonModuleUrl()); | |
String cor = null; | |
try { | |
GetCountryResponse response = commonInternalApi.getCountryMappingByIp(registerIpAddress); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public List<User> searchUser(String email, String mobile, String name, boolean filterDeleted) { | |
CriteriaBuilder cb = getEntityManager().getCriteriaBuilder(); | |
CriteriaQuery<User> cqUser = cb.createQuery(User.class); | |
Root<User> rootUser = cqUser.from(User.class); | |
cqUser.select(rootUser); | |
List<Predicate> predicateList = new ArrayList<Predicate>(); | |
Predicate p1 = cb.conjunction(); |