public ArrayList<SellInItemDTO> selectAll() {
    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));

        list.add(jd);
      } while (cursor.moveToNext());
    }
    if (cursor != null && !cursor.isClosed()) {
      cursor.close();
    }
    return list;
  }
  public ArrayList<SellInItemDTO> selectTemp() {
    ArrayList<SellInItemDTO> list = new ArrayList<SellInItemDTO>();

    Cursor cursor =
        this.db.query(
            TABLE_NAME,
            new String[] {"sellin_json,date,sell_in_date_time"},
            "uploaded=? AND user_id=?",
            new String[] {"0", Contents.getLogInfo().getUserId()},
            null,
            null,
            "id asc");
    if (cursor.moveToFirst()) {
      do {
        SellInItemDTO jd = new SellInItemDTO();
        jd.fromJSON(cursor.getString(0));
        jd.setDate(cursor.getString(1));
        jd.setSellInDateTime(cursor.getString(2));
        list.add(jd);
      } while (cursor.moveToNext());
    }
    if (cursor != null && !cursor.isClosed()) {
      cursor.close();
    }
    return list;
  }
  public long insert(SellInItemDTO _sell) {
    final Calendar dd = Calendar.getInstance();
    SimpleDateFormat da = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

    _sell.setDate(String.valueOf(da.format(dd.getTime())));

    this.insertStmt.bindString(1, _sell.toJSON());
    this.insertStmt.bindString(2, "0");
    this.insertStmt.bindString(3, Contents.getLogInfo().getUserId());
    this.insertStmt.bindString(4, String.valueOf(da.format(dd.getTime())));
    this.insertStmt.bindString(5, _sell.getSellInDateTime());
    return this.insertStmt.executeInsert();
  }
  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;
  }