getTableWhereValue method

dynamic getTableWhereValue(dynamic whereI, dynamic seg, dynamic onlyValue)

Implementation

getTableWhereValue(whereI, seg, onlyValue) {
  List whereS = whereI.split(seg);
  String aValue = (removeBracket(whereS[1]) ?? '').toString().toLowerCase();

  if (aValue.indexOf("'") == 0) {
    aValue = aValue.substring(1, aValue.length - 1);
  }
  if (isNull(aValue)) {
    return '';
  }
  if (aValue == '@$gToday' ||
      aValue == '@$gYesterday' ||
      aValue == '@$gThisWeek' ||
      aValue == '@$gThisMonth' ||
      aValue == '@$gThisYear') {
    var dayBegin = getDayBegin(aValue);

    var begin = toUTCTime(dayBegin);
    var end = getSystemtime();
    if (aValue == '@$gYesterday') {
      end = toUTCTime(getDayBegin('@$gToday'));
    }
    if (onlyValue) {
      return ' between [$begin,$end]';
    } else {
      return '${whereS[0]} between [$begin,$end]';
    }
  } else {
    if (onlyValue) {
      return aValue;
    } else {
      return '${whereS[0]}$seg$aValue';
    }
  }
}