getOrderSeq method

Future<int> getOrderSeq(
  1. String channelID,
  2. int channelType,
  3. int maxOrderSeq,
  4. int limit,
)

Implementation

Future<int> getOrderSeq(
    String channelID, int channelType, int maxOrderSeq, int limit) async {
  int minOrderSeq = 0;
  if (WKDBHelper.shared.getDB() == null) {
    return minOrderSeq;
  }
  String sql =
      "select order_seq from ${WKDBConst.tableMessage} where channel_id=? and channel_type=? and type<>99 and order_seq <=? order by order_seq desc limit ?";
  List<Map<String, Object?>> list = await WKDBHelper.shared
      .getDB()!
      .rawQuery(sql, [channelID, channelType, maxOrderSeq, limit]);
  if (list.isNotEmpty) {
    dynamic data = list[0];
    minOrderSeq = WKDBConst.readInt(data, 'order_seq');
  }
  return minOrderSeq;
}