Everything can be integrated series: low code release U8+ depth value (2) - data expansion application

In the last article, we introduced how to use the low-code development kit to realize the docking and integration of low-code applications and U8+ system. This time, we bring you how to extend the value and practical application of the data in UF U8+ system.
We take the analysis of the complete set of production materials as an example to illustrate how to use low code to expand and apply the system in the U8+ system. Before we start, let's take a look at what a production material kit is.

Definition of production material kit

The complete set of production analysis plays an important role in the production planning arrangement. It is mainly used for the complete set of analysis of the materials before the production arrangement goes online. The purpose is to better arrange the production plan and avoid the on-line stoppage. The results of the complete set of analysis are extremely valuable to many departments of the enterprise, such as the PMC department of the enterprise, the department that calculates and controls the materials, the production management department, and so on. In the following sharing, we describe how to connect the U8+ with the movable type, organize and count the production order data in the U8+ system in the movable type, and develop a complete set of analysis modules to help realize the production orders and tasks. , task details and other projects for complete management.
In addition, the newly developed system can display production orders, production tasks and task details in the form of a data pivot table, and provide warnings for information that does not meet the conditions, so that users can know at a glance which production task accessories are not available. Complete and quantity difference. At the same time, it can also support multi-level chart display, dynamic linkage of charts, and make data move in the browser.
First, let's look at the display effect:

• Complete set of data analysis

• Complete set of chart analysis

In order to achieve the above results, there are several key aspects to pay attention to:

1) Data sorting Sort the relevant data in the U8+ system, and generate corresponding views through SQL for access by the movable type application.

2) Access to the external database The movable type has a powerful ability to access the external database. We can refer to the manual to understand the ability of the movable type to connect to external databases:
https://help.grapecity.com.cn/pages/viewpage.action?pageId=72355085

3) Complete set of data analysis Through the multi-header table, we can realize the display effect of the data. Using conditional formatting, the value that does not meet the requirements can be displayed as the warning color, and the current row of the movable type grid and dynamic query can be used to realize the dynamic correlation display of data. function.

4) Complete set of chart analysis Bind the table in the movable type page, and use the method of binding the chart to realize this function. By editing the chart command to get the currently selected category and value, you can implement the chart drilling function. The effect is as follows:

So far, we have completed the functions of data connection and application expansion of the U8+ system. If you want to integrate this part of the application with the U8+ main service, you can refer to: Everything Can Integrate Series: Low-Code Unleashes UFIDA's Deep Value (1) - System Docking Integration or view related public course content: https://gcdn.grapecity. com.cn/forum.php?mod=viewthread&tid=55373&extra=page%3D1%26filter%3Dtypeid%26typeid%3D272
There is always a deviation between theory and reality. In the actual production process, no matter how effectively we make a plan, there will be a risk of plan deviation. What we can do is to pay attention to the deviation of the plan and make adjustments in time. I hope that low-code can help you achieve data-driven management optimization, reduce costs and increase efficiency.
For more UF U8+ cases, please refer to:
https://gcdn.grapecity.com.cn/showtopic-54262-1-1.html