Class_QueryBuildRangeCondition.xpo

Exportfile for AOT version 1.0 or later
Formatversion: 1

***Element: CLS

; Microsoft Dynamics AX Class: QueryBuildRangeCondition выгружен
; --------------------------------------------------------------------------------
  CLSVERSION 1
  
  CLASS #QueryBuildRangeCondition
    Id 38519
    PROPERTIES
      Name                #QueryBuildRangeCondition
      Extends             #
      RunOn               #Called from
    ENDPROPERTIES
    
    METHODS
      Version: 3
      SOURCE #addBorderToValue
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #private str addBorderToValue(str _value)
        #{
        #    str ret = _value;
        #    ;
        #
        #    if (!this.isValueFlagOn(#VALUE_BORDERLESS))
        #    {
        #        ret = strFmt(#CONDITION_BORDER, _value);
        #    }
        #
        #    return ret;
        #}
      ENDSOURCE
      SOURCE #addEscape
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #private str addEscape(str _value)
        #{
        #    str quotableStr  = ' *",.()\\',
        #        specialChars = ' *",.()<>!=',
        #        ret;
        #    int i = 1;
        #    int pos;
        #    int len = strLen(_value);
        #    boolean escape;
        #
        #    escape = true;
        #    pos = strFind(_value, quotableStr, i, len - i + 1);
        #    while (pos)
        #    {
        #        if (subStr(_value, pos, 1) == '\\')
        #        {
        #            if (strFind(_value, specialChars, pos + 1, 1))
        #            {
        #               escape = false;
        #            }
        #        }
        #        if (escape)
        #        {
        #            ret += subStr(_value, i, pos - i) + '\\' + subStr(_value, pos, 1);
        #        }
        #        else
        #        {
        #            ret += subStr(_value, i, pos - i + 1);
        #            escape = true;
        #        }
        #
        #        i = pos + 1;
        #
        #        if (i<=len)
        #        {
        #            pos = strFind(_value, quotableStr, i, len - i + 1);
        #        }
        #        else
        #        {
        #            pos = 0;
        #        }
        #    }
        #
        #    if (i == 1)
        #    {
        #        return _value;
        #    }
        #
        #    if (i<=len)
        #    {
        #        ret += subStr(_value, i, len - i + 1);
        #    }
        #
        #    return ret;
        #}
      ENDSOURCE
      SOURCE #addNegationChar
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #private str addNegationChar()
        #{
        #    str 1 ret;
        #    ;
        #
        #    if (this.isValueFlagOn(#VALUE_NEGATION))
        #    {
        #        ret = #NEGATIONCHAR;
        #    }
        #
        #    return ret;
        #}
      ENDSOURCE
      SOURCE #and
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #public QueryBuildRangeCondition and(QueryBuildRangeCondition _condition)
        #{
        #    #DEFINE.OPERATOR_AND('&&')
        #    ;
        #
        #    this.appendValue(#OPERATOR_AND, _condition.toString());
        #
        #    return this;
        #}
      ENDSOURCE
      SOURCE #appendValue
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #private void appendValue(str _operator, str _value)
        #{
        #    ;
        #
        #    valueBuffer.appendText(_operator);
        #    valueBuffer.appendText(_value);
        #}
      ENDSOURCE
      SOURCE #classDeclaration
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #class QueryBuildRangeCondition
        #{
        #    str                     field;
        #
        #    int                     valueFlag;
        #
        #    TextBuffer              valueBuffer;
        #
        #    #LOCALMACRO.CONDITION_BORDER
        #    '(\%1)'
        #    #ENDMACRO
        #
        #    #DEFINE.FIELDNAMEFORMAT('\%1.\%2')
        #    #DEFINE.NEGATIONCHAR('!')
        #
        #    #DEFINE.VALUE_NONDEFAULT(1)
        #    #DEFINE.VALUE_NEGATION(2)
        #    #DEFINE.VALUE_BORDERLESS(4)
        #}
      ENDSOURCE
      SOURCE #finalize
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #public void finalize()
        #{
        #    ;
        #
        #    valueBuffer = null;
        #}
      ENDSOURCE
      SOURCE #getStrValue
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #private str getStrValue(anyType _value)
        #{
        #    Types valueType = typeOf(_value);
        #    str   ret;
        #
        #    switch (valueType)
        #    {
        #        case Types::Class :
        #            if (SysDictClass::is(_value, classNum(QueryBuildRangeCondition)))
        #            {
        #                ret = this.getStrValueFromQBRC(_value);
        #            }
        #            else
        #            {
        #                throw Error(strFmt("@GEE3607", funcName()));
        #            }
        #            break;
        #
        #        case Types::Integer,
        #             Types::Enum:
        #            ret = int2str(_value);
        #            break;
        #
        #        case Types::Int64 :
        #            ret = int642str(_value);
        #            break;
        #
        #        case Types::Real:
        #            ret = num2str(_value,0,16,1,0);
        #            break;
        #
        #        case Types::Date:
        #            ret = date2StrXpp(_value);
        #            break;
        #
        #        case Types::UtcDateTime:
        #            if (_value==DateTimeUtil::minValue())
        #            {
        #                ret = @'1900-01-01T00:00:00';
        #            }
        #            else
        #            {
        #                ret = DateTimeUtil::toStr(_value);
        #            }
        #            break;
        #
        #        case Types::String,
        #             Types::RString,
        #             Types::VarString:
        #            if (_value)
        #            {
        #                ret = strFmt(@'"%1"', this.addEscape(_value));
        #            }
        #            else
        #            {
        #                ret = SysQuery::valueEmptyString();
        #            }
        #            break;
        #
        #        default :
        #            if (new DictEnum(enumNum(Types)).value2Symbol(valueType))
        #            {
        #                ret = strFmt('%1', _value);
        #            }
        #            else
        #            {
        #                ret = SysQuery::valueUnlimited();
        #            }
        #            break;
        #    }
        #
        #    return ret;
        #}
      ENDSOURCE
      SOURCE #getStrValueFromQBRC
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #private str getStrValueFromQBRC(QueryBuildRangeCondition _condition)
        #{
        #    ;
        #
        #    return _condition.toString();
        #}
      ENDSOURCE
      SOURCE #isValueFlagOn
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #private boolean isValueFlagOn(int _flag)
        #{
        #    ;
        #
        #    return valueFlag & _flag;
        #}
      ENDSOURCE
      SOURCE #link
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #public QueryBuildRangeCondition link(QueryBuildRangeOperator _operator, QueryBuildDataSource _qbds, str _fieldName)
        #{
        #    ;
        #
        #    this.value(_operator, new QueryBuildRangeCondition(strFmt(#FIELDNAMEFORMAT, _qbds.name(), _fieldName), #VALUE_BORDERLESS));
        #
        #    return this;
        #}
      ENDSOURCE
      SOURCE #new
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #protected void new(str _fieldName, int _valueFlag = 0)
        #{
        #    ;
        #
        #    field       = _fieldName;
        #    valueBuffer = new TextBuffer();
        #
        #    this.setValueFlag(_valueFlag);
        #}
      ENDSOURCE
      SOURCE #or
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #public QueryBuildRangeCondition or(QueryBuildRangeCondition _condition)
        #{
        #    #DEFINE.OPERATOR_OR('||')
        #    ;
        #
        #    this.appendValue(#OPERATOR_OR, _condition.toString());
        #
        #    return this;
        #}
      ENDSOURCE
      SOURCE #setValueFlag
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #private void setValueFlag(int _flag)
        #{
        #    ;
        #
        #    valueFlag = valueFlag | _flag;
        #}
      ENDSOURCE
      SOURCE #toString
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #public str toString()
        #{
        #    str ret = valueBuffer.getText();
        #    ;
        #
        #    if (!this.isValueFlagOn(#VALUE_NONDEFAULT))
        #    {
        #        ret = this.addBorderToValue(field) + ret;
        #    }
        #
        #    return this.addNegationChar() + this.addBorderToValue(ret);
        #}
      ENDSOURCE
      SOURCE #value
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #public QueryBuildRangeCondition value(QueryBuildRangeOperator _operator,
        #                                      anyType                 _value)
        #{
        #    ;
        #
        #    if (!this.isValueFlagOn(#VALUE_NONDEFAULT))
        #    {
        #        this.setValueFlag(#VALUE_NONDEFAULT);
        #
        #        valueBuffer.setText(this.addBorderToValue(field + enum2str(_operator) + this.getStrValue(_value)) + valueBuffer.getText());
        #    }
        #    else
        #    {
        #        throw Error(strFmt("@GEE3607", funcName()));
        #    }
        #
        #    return this;
        #}
      ENDSOURCE
      SOURCE #create
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #public static QueryBuildRangeCondition create(QueryBuildDataSource _qbds, str _fieldName)
        #{
        #    ;
        #
        #    return new QueryBuildRangeCondition(strFmt(#FIELDNAMEFORMAT, _qbds.name(), _fieldName));
        #}
      ENDSOURCE
      SOURCE #createNegation
        #/*
        #MIT License
        #
        #Copyright (c) 2023 Sergey-Barkar
        #
        #Permission is hereby granted, free of charge, to any person obtaining a copy
        #of this software and associated documentation files (the "Software"), to deal
        #in the Software without restriction, including without limitation the rights
        #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
        #copies of the Software, and to permit persons to whom the Software is
        #furnished to do so, subject to the following conditions:
        #
        #The above copyright notice and this permission notice shall be included in all
        #copies or substantial portions of the Software.
        #
        #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
        #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
        #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
        #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
        #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
        #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
        #SOFTWARE.
        #*/
        #public static QueryBuildRangeCondition createNegation(QueryBuildDataSource _qbds, str _fieldName)
        #{
        #    ;
        #
        #    return new QueryBuildRangeCondition(strFmt(#FIELDNAMEFORMAT, _qbds.name(), _fieldName), #VALUE_NEGATION);
        #}
      ENDSOURCE
    ENDMETHODS
  ENDCLASS

***Element: END