checkAndSetRequest static method

Implementation

static String checkAndSetRequest({String condition="",required SimpleWebRR webRR,String field="",String type="",List<String> numericFields=const [],List<String> stringFields=const [],List<String> stringFieldsIgnoreCase=const []}){
    if(field.isNotEmpty){
        if(checkRequestParameter(webRR,field)){
            if([BasePojo.typeInt,BasePojo.typeDouble].contains(type)){
                condition+=" AND $field="+webRR.requestString(field);
            }
            else{
                condition+=" AND LOWER($field)=\"${webRR.requestString(field).toLowerCase()}\"";
            }
        }
    }
    if(numericFields.isNotEmpty){
        numericFields.forEach((field) {
            if(checkRequestParameter(webRR,field)) {
                condition += " AND $field=" + webRR.requestString(field);
            }
        });
    }
    if(stringFields.isNotEmpty){
        stringFields.forEach((field) {
            if(checkRequestParameter(webRR,field)) {
                condition +=
                " AND $field=\"${webRR.requestString(field)}\"";
            }
        });
    }
    if(stringFieldsIgnoreCase.isNotEmpty){
        stringFieldsIgnoreCase.forEach((field) {
            if(checkRequestParameter(webRR,field)) {
                condition +=
                " AND LOWER($field)=\"${webRR.requestString(field).toLowerCase()}\"";
            }
        });
    }
    return condition;
}