public String takeSQL(String type) {
param.clear();
StringBuilder sql = new StringBuilder();
if ("count".equals(type)) {
sql.append(" select count(*) ");
} else {
sql.append(
" SELECT link,WEB, TYPE, BRAND,PRICE,ITEM_CODE itemCode,NAME,model,STORAGE,RAM,SCREEN,CPU,B_CAMERA backCamera,"
+ " F_CAMERA frontCamera,os,BATTERY,SIM, a.LAST_UPDATE lastUpdate ");
}
sql.append(" FROM TABLET_DATA a, tablet_configuration b ");
sql.append(" where a.ID = b.TABLET_DATA_ID ");
if (date != null && !"".equals(date)) {
sql.append(" AND CAST(a.LAST_UPDATE as DATE) = ?");
param.add(date);
} else {
sql.append(" AND CAST(a.LAST_UPDATE AS DATE) = CAST(getdate() AS DATE)");
}
if (webs != null && webs.size() > 0) {
String listWeb = "'";
for (int i = 0; i < webs.size(); i++) {
if (i == webs.size() - 1) {
listWeb = listWeb + webs.get(i) + "'";
} else {
listWeb = listWeb + webs.get(i) + "','";
}
}
// System.out.println(listWeb);
sql.append(" and WEB in (").append(listWeb).append(") ");
}
if (tablet != null) {
if (tablet.getStorage() != null && !"".equals(tablet.getStorage())) {
sql.append(" and convert(float,storage) ");
sql.append(tablet.getStorage());
// param.add(tablet.getStorage());
}
if (tablet.getRam() != null && !"".equals(tablet.getRam())) {
sql.append(" and convert(float,ram) ");
sql.append(tablet.getRam());
// param.add(tablet.getRam());
}
if (tablet.getCpu() != null && !"".equals(tablet.getCpu())) {
sql.append(" and cpu = ? ");
param.add(tablet.getCpu());
}
if (tablet.getSpeed() != null && !"".equals(tablet.getSpeed())) {
if (tablet.getSpeed().indexOf("and") >= 0) {
sql.append(" and convert(float,speed) between ");
} else {
sql.append(" and convert(float,speed) ");
}
sql.append(tablet.getSpeed());
// param.add(tablet.getSpeed());
}
if (tablet.getScreen() != null && !"".equals(tablet.getScreen())) {
if (tablet.getScreen().indexOf("and") >= 0) {
sql.append(" and convert(float,screen) between ");
} else {
sql.append(" and convert(float,screen) ");
}
sql.append(tablet.getScreen());
// param.add(tablet.getScreen());
}
if (tablet.getSim() != null && !"".equals(tablet.getSim())) {
sql.append(" and sim = ? ");
param.add(tablet.getSim());
}
if (tablet.getBackCamera() != null && !"".equals(tablet.getBackCamera())) {
sql.append(" and convert(float, b_camera) ");
sql.append(tablet.getBackCamera());
// param.add(tablet.getBackCamera());
}
if (tablet.getFrontCamera() != null && !"".equals(tablet.getFrontCamera())) {
sql.append(" and convert(float, f_camera) ");
sql.append(tablet.getFrontCamera());
// param.add(tablet.getFrontCamera());
}
if (tablet.getOs() != null && !"".equals(tablet.getOs())) {
sql.append(" and os = ? ");
param.add(tablet.getOs());
}
if (tablet.getBattery() != null && !"".equals(tablet.getBattery())) {
if (tablet.getBattery().indexOf("and") >= 0) {
sql.append(" and convert(float, battery) between ");
} else {
sql.append(" and convert(float, battery) ");
}
sql.append(tablet.getBattery());
// param.add(tablet.getBattery());
}
if (tablet.getPrice() != null && !"".equals(tablet.getPrice())) {
if (tablet.getPrice().indexOf("and") >= 0) {
sql.append(" and CONVERT(float, price_number/1000000) between ");
} else {
sql.append(" and CONVERT(float, price_number/1000000) ");
}
sql.append(tablet.getPrice());
// param.add(tablet.getPrice());
}
}
return sql.toString();
}
