public static List<Province> getAllProvinceFromCache() {
Cache cache = CacheItemManager.getCache(CacheName.DB_CACHE_PROVINCE);
Attribute<Integer> id = cache.getSearchAttribute("id");
Query query = cache.createQuery().includeValues().addCriteria(id.notNull());
Results results = query.execute();
List<Result> rs = results.all();
if (rs == null || rs.size() <= 0) {
return null;
}
int size = rs.size();
List<Province> list = new ArrayList<Province>();
for (int i = 0; i < size; ++i) {
list.add((Province) rs.get(i).getValue());
}
results.discard();
return list;
}
public static List<AreaView> getAllAreaFromCache() {
Cache cache = CacheItemManager.getCache(CacheName.DB_CACHE_AREA);
Attribute<String> areacode =
cache.getSearchAttribute(SearchAttributeName.DBCACHE_AREA_AREACODE);
Query query =
cache
.createQuery()
.includeAttribute(areacode)
.includeValues()
.addCriteria(areacode.notNull())
.addOrderBy(areacode, Direction.ASCENDING);
Results results = query.execute();
List<Result> rs = results.all();
if (rs == null || rs.size() <= 0) {
return null;
}
int size = rs.size();
List<AreaView> list = new ArrayList<AreaView>();
for (int i = 0; i < size; ++i) {
list.add((AreaView) rs.get(i).getValue());
}
results.discard();
return list;
}
public static List<Town> getTownByProvinceFromCache(String provinceCode) {
Cache cache = CacheItemManager.getCache(CacheName.DB_CACHE_TOWN);
Attribute<String> provcode = cache.getSearchAttribute("prov_code");
Query query = cache.createQuery().includeValues().addCriteria(provcode.eq(provinceCode));
Results results = query.execute();
List<Result> rs = results.all();
if (rs == null || rs.size() <= 0) {
return null;
}
int size = rs.size();
List<Town> list = new ArrayList<Town>();
for (int i = 0; i < size; ++i) {
list.add((Town) rs.get(i).getValue());
}
results.discard();
return list;
}
public static List<Province> getProvinceByAearFromCache(String[] areacodes) {
Cache cache = CacheItemManager.getCache(CacheName.DB_CACHE_PROVINCE);
Attribute<String> provarea = cache.getSearchAttribute("prov_area");
Attribute<String> provcode = cache.getSearchAttribute("prov_code");
Query query =
cache
.createQuery()
.includeValues()
.addCriteria(provarea.in(Arrays.asList(areacodes)))
.addOrderBy(provcode, Direction.ASCENDING);
Results results = query.execute();
List<Result> rs = results.all();
if (rs == null || rs.size() <= 0) {
return null;
}
int size = rs.size();
List<Province> list = new ArrayList<Province>();
for (int i = 0; i < size; ++i) {
list.add((Province) rs.get(i).getValue());
}
results.discard();
return list;
}
public String anlikOturumSayisiHesapla(boolean detayli) {
try {
Attribute<String> oturumZamanAraligiAtt =
getStatisticCache().getSearchAttribute("oturumZamanAraligi");
GregorianCalendar gcal = new GregorianCalendar();
int minute = gcal.get(GregorianCalendar.MINUTE);
int hour = gcal.get(GregorianCalendar.HOUR_OF_DAY);
String firstInterval = "" + ((hour * 6) + (minute / 10));
int fourthRatio = (10 - (minute % 10)) * 10;
gcal.add(GregorianCalendar.MINUTE, -10);
minute = gcal.get(GregorianCalendar.MINUTE);
hour = gcal.get(GregorianCalendar.HOUR_OF_DAY);
String secondInterval = "" + ((hour * 6) + (minute / 10));
gcal.add(GregorianCalendar.MINUTE, -10);
minute = gcal.get(GregorianCalendar.MINUTE);
hour = gcal.get(GregorianCalendar.HOUR_OF_DAY);
String thirdInterval = "" + ((hour * 6) + (minute / 10));
gcal.add(GregorianCalendar.MINUTE, -10);
minute = gcal.get(GregorianCalendar.MINUTE);
hour = gcal.get(GregorianCalendar.HOUR_OF_DAY);
String fourthInterval = "" + ((hour * 6) + (minute / 10));
Query query = null;
if (detayli)
query =
getStatisticCache()
.createQuery()
.includeKeys()
.includeValues()
.addCriteria(
new Or(
oturumZamanAraligiAtt.eq(firstInterval),
oturumZamanAraligiAtt.eq(secondInterval))
.or(oturumZamanAraligiAtt.eq(thirdInterval))
.or(oturumZamanAraligiAtt.eq(fourthInterval)));
else
query =
getStatisticCache()
.createQuery()
.includeValues()
.addCriteria(
new Or(
oturumZamanAraligiAtt.eq(firstInterval),
oturumZamanAraligiAtt.eq(secondInterval))
.or(oturumZamanAraligiAtt.eq(thirdInterval))
.or(oturumZamanAraligiAtt.eq(fourthInterval)));
Results resultElement = query.execute();
int toplamOturumSayisi = 0;
String denemeMesaj = "";
if (resultElement.hasValues()) {
List<Result> resultList = resultElement.all();
for (Result result : resultList) {
OturumStatistic obj = (OturumStatistic) result.getValue();
if (detayli) {
denemeMesaj +=
"Key : "
+ result.getKey()
+ " ZAMANA ARALIĞI : "
+ obj.getOturumZamanAraligi()
+ " OTURUM SAYISI : "
+ obj.getOturumSayisi()
+ "<br />";
denemeMesaj += "-----------------------<br />";
}
if (obj.getOturumZamanAraligi().equals(fourthInterval)) {
toplamOturumSayisi += ((obj.getOturumSayisi() * fourthRatio) / 100);
} else {
toplamOturumSayisi += obj.getOturumSayisi();
}
}
if (detayli) denemeMesaj += " TOPLAM OTURUM SAYISI : " + toplamOturumSayisi;
else denemeMesaj = "" + toplamOturumSayisi;
return denemeMesaj;
} else return "-1";
} catch (SearchException e) {
}
return "-1";
}
private void processAttributes(Set<Attribute<?>> attributes) {
for (Attribute<?> attr : attributes) {
attribute(attr.getAttributeName());
}
}
private void processGroupBy(Set<Attribute<?>> attributes) {
for (Attribute attr : attributes) {
groupBy(attr.getAttributeName());
}
}