How to safely convert a user input numeric string to an integer or floating-point number for calculation in AnQiCMS template?

In the operation of daily websites, we often encounter the need to display or calculate user input data on the web page.Even when fields are explicitly set as numeric types in the background, when the data is pulled to the front-end template for rendering, they are often in the form of strings.This is not a problem when displaying simple content, but once it involves numerical calculations, such as calculating the total price, calculating percentages, etc., performing operations directly on strings can lead to unexpected results and even errors.

Imagine if we define a 'product quantity' and a 'unit price' field in the AnQiCMS content model.The user entered '10' and '9.99' in the background."10"and"9.99"Such a string. If we try to multiply them directly, the template engine may treat them as strings to be concatenated (for example"10" * "9.99" Become an error, or in some languages, it may try to concatenate strings multiple times, rather than the expected numeric multiplication.This may lead to inaccurate calculation results and may also affect the user experience.

To solve this problem, AnQiCMS's powerful template engine provides very practical built-in filters, includingintegerandfloatIt is a tool specifically used to safely convert strings to integers or floating-point numbers.These filters act like a safe bridge, converting 'textual numbers' into 'computable numbers', making our template calculations accurate and reliable.

Skillfully useintegerandfloatFilter

In AnQiCMS template syntax, you can use the pipe symbol|to apply filters.integerThe filter will attempt to convert a string to an integer, whilefloatThe filter will try to convert it to a floating-point number.

It is the most practical feature of 'safe conversion'. This means that if the filter tries to convert a string that cannot be recognized as a valid number (such as when the user enters 'abc'), it will not cause a runtime error, but will return gracefully.0Forintegeror0.0ForfloatThis provides great robustness to our template, avoiding crashes due to exceptional data.

Let's look at a few simple examples:

Assuming we have a variable obtained from user inputuser_input_string.

{# 转换为整数 #}
{% set quantity_str = "10" %}
{% set quantity_int = quantity_str|integer %}
{# quantity_int 的值将是 10 #}

{# 转换为浮点数 #}
{% set price_str = "9.99" %}
{% set price_float = price_str|float %}
{# price_float 的值将是 9.990000 #}

{# 处理非数字字符串 #}
{% set invalid_str = "这不是数字" %}
{% set invalid_int = invalid_str|integer %}
{% set invalid_float = invalid_str|float %}
{# invalid_int 的值将是 0 #}
{# invalid_float 的值将是 0.000000 #}

{# 浮点数转换为整数会截断小数部分 #}
{% set float_to_int = "5.6"|float|integer %}
{# float_to_int 的值将是 5 #}

Through these simple transformations, we can ensure that we get a numeric type that can be used for mathematical operations.

Calculation applications in real-world scenarios

Now, let's go back to the example of product quantity and unit price we discussed earlier, and see how to safely calculate the total price:

Assuming we have already passedarchiveDetailorarchiveListThe label obtained the document data, which includedquantityandunitPricetwo fields.

{% set product_quantity = archive.quantity %} {# 假设从文档模型获取，可能是一个字符串，如 "10" #}
{% set product_unit_price = archive.unitPrice %} {# 假设也是字符串，如 "9.99" #}

{# 错误示范：直接对字符串进行运算，可能会导致意外结果或错误 #}
{# {% set total_price = product_quantity * product_unit_price %} #}

{# 正确且安全的方法：先转换为数值，再进行计算 #}
{% set safe_quantity = product_quantity|integer %}
{% set safe_unit_price = product_unit_price|float %}

{# 现在可以安全地进行数学运算了，AnQiCMS的模板引擎支持直接的算术运算 #}
{% set total_price = safe_quantity * safe_unit_price %}

<p>产品数量：{{ safe_quantity }}</p>
<p>产品单价：{{ safe_unit_price|floatformat:2 }}</p> {# 可以使用 floatformat 过滤器格式化显示浮点数，保留两位小数 #}
<p>总价：{{ total_price|floatformat:2 }}</p>

{# 考虑用户没有输入数字的情况，比如 quantity 是 "abc" #}
{% set another_quantity = "abc" %}
{% set another_unit_price = "15.00" %}

{% set safe_another_quantity = another_quantity|integer %} {# 结果将是 0 #}
{% set safe_another_unit_price = another_unit_price|float %} {# 结果将是 15.000000 #}

{% set another_total_price = safe_another_quantity * safe_another_unit_price %} {# 结果将是 0.00 #}

<p>另一个产品的数量：{{ safe_another_quantity }}</p>
<p>另一个产品的总价：{{ another_total_price|floatformat:2 }}</p>

In this example, evenproduct_quantityis an invalid numeric string (such as empty values, letters, etc.),|integerThe filter will also safely convert it to0thus avoiding calculation errors and makingtotal_pricethe result to0.00. This is exactly the robustness we pursue.

**Practice and Precautions

1. Backend validation first:Although template filters provide security conversion at the client level, the fundamental guarantee of data quality is still on the backend.In the AnQiCMS content model, if the field is designed as a "numeric" type, the system will perform preliminary verification during data entry to ensure that the data conforms to expectations as much as possible.The template filter is the last line of defense for data, but the 'error prevention' in the frontend is never as thorough as the 'contamination prevention' in the backend.

2. Select the correct type:If you are sure the number does not need a decimal part (such as quantity, ID), use|integer. If the number may contain a decimal (such as price, ratio), then use|floatChoose the appropriate filter according to actual needs to avoid unnecessary loss of precision or waste of resources.

3. Friendly default display:When non-numeric strings are converted to0or0.0When this is safe in computation, it may not be very user-friendly in the interface. For example, a product priced0.00could be confusing. At this point, it may be considered to combinedefaultThe filter to provide a more user-friendly display:

   <p>价格：{{ product_unit_price|float|default:"价格待定" }}</p>
   {# 如果 product_unit_price 无法转换为数字，将显示 "价格待定" #}
   

   Or to determine before the calculation:

   {% set safe_quantity = product_quantity|integer %}
   {% set safe_unit_price = product_unit_price|float %}
   {% if safe_quantity > 0 and safe_unit_price > 0 %}
       {% set total_price = safe_quantity * safe_unit_price %}
       <p>总价：{{ total_price|floatformat:2 }}</p>
   {% else %}
       <p>总价：暂无有效数据</p>
   {% endif %}
   

4. Filter chaining call:AnQiCMS template supports chained filter calls, you can use multiple filters together, for example{{ user_input_str|float|floatformat:2 }}First convert to a floating-point number, then format it to two decimal places.

By proficiently using the AnQiCMS template inintegerandfloatThe filter ensures that the dynamic calculation of website content is accurate and secure, thereby enhancing user experience and avoiding potential errors, making website operations more smooth and efficient.

Frequently Asked Questions (FAQ)

1. Why did the background set a "numeric" field, and why is it still necessary to perform a conversion in the template?integerorfloat？The content model field type of the background is mainly used to validate and manage data entry and storage, ensuring that the data format in the database is correct. However, when these data are extracted to the template engine for rendering, they are usually treated as string types so that the template engine can