public ArrayList<SellInItemDTO> selectICCID(String ICCID) {
ArrayList<SellInItemDTO> list = new ArrayList<SellInItemDTO>();
final Calendar dd = Calendar.getInstance();
SimpleDateFormat da = new SimpleDateFormat("yyyy-MM-dd");
Cursor cursor =
this.db.query(
TABLE_NAME,
new String[] {"sellin_json"},
"date like ? AND user_id=?",
new String[] {
String.valueOf(da.format(dd.getTime())) + "%", Contents.getLogInfo().getUserId()
},
null,
null,
"id asc");
if (cursor.moveToFirst()) {
do {
SellInItemDTO jd = new SellInItemDTO();
jd.fromJSON(cursor.getString(0));
ArrayList<String> jdi = jd.getItems();
boolean valid = true;
for (int i = 0; i < jdi.size(); i++) {
if (jdi.get(i).equalsIgnoreCase(ICCID)) {
valid = false;
break;
}
}
if (valid == false) {
list.add(jd);
}
} while (cursor.moveToNext());
}
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return list;
}
