Everything can be integrated series: low-code release UF deep value (1) - system docking integration

As a basic application service of the best management platform for Chinese enterprises, UF U8+ has been widely used in enterprise management. As we all know, the basic capabilities provided by UF U8+ can meet the basic problems of daily management of enterprises, but due to the different internal management methods and processes of each enterprise, it is difficult for standard software functions to well adapt to the management needs of all enterprises. In addition, with the development of the Internet and mobile applications, the demand for application access through mobile devices has become more and more obvious, and UFIDA U8+ is mainly based on desktop applications, lacking mobile solutions, causing many problems in terms of convenient use. inconvenient.

How can we solve this problem? Today, I will take you to see how low-code unlocks the potential of UF U8+ and helps companies tap more value.
In order to give you a more intuitive understanding, we take the movable type low-code development platform as an example to show you this process.
Let's take a look at the effect first: (Due to the poor configuration of the local virtual machine used, it may be a little stuck, but it will not affect the integration method we will introduce later.)

Will it be difficult to achieve the above effect? Yes, if you use the traditional development method, this difficulty is indeed not small. Usually, the team needs to be equipped with multiple professional developers, the technical threshold is high, the engineering volume is large, and the delivery cycle will be very long. But after using the development kit provided by low-code, the whole integration process becomes very simple.

Let's take a look at how to integrate the program into the U8+ program. The integrated content mainly includes: data integration, C/S page embedding, and user integration.

You can first take a look at the integrated effect:

The specific integration steps are mainly divided into the following steps:

1. Environmental preparation

UF U8 is a standard ERP system with C/S architecture. If you need to expand the functions of U8, you can integrate the movable type grid, the web application development tool of Grape City, in the U8 system.
This chapter introduces how to prepare the U8 server and client environment before integrating movable type and Wyn in the U8 system.
Note: The base environment is based on U8+ v11.0, v12.5, v13.0, v16.0, v16.1 versions. The integration kits of different versions are not exactly the same. You need to apply for the U8 integration kit from the official personnel. Please indicate your U8 version when applying.
(1) Before downloading the integrated package, please download the integrated package from the UFIDA Cloud Market. After decompressing the entire integrated package, it will be displayed as follows:

Among them, the [U8] folder contains the files used to configure the integrated environment of the U8 server and client. 【Moveable Type】is a configuration file used to integrate the movable type application in the U8 system.

(2) U8 server-side environment preparation Note: To meet the integration needs, please use the SQL Server database management tool to open the UFSystem-GC.sql file in the \U8\Server folder of the installation package:

And execute the script as shown in the figure below. After the script is executed, the database objects required for the integration will be created in the U8 system management database UFSystem.

(3) U8 client environment preparation Please merge the registry key file (*.reg) file in the \U8\Client\ folder. If the operating system is 32-bit Windows, please right-click U8Browser-x86.reg, and then click [Merge]; if it is 64-bit Windows, please right-click U8Browser-x64.reg, and then click [Merge].

Note: If you need to integrate in an embedded way, that is, to display the movable type page directly in the U8 form, please make sure that the IE11 browser has been installed in the client operating system. Otherwise, if it is other browsers such as Google, it can only display the movable type page in the form of a pop-up window (Popup).

2. System docking integration

Movable Type is a web application generation platform, and web applications developed using this platform can be integrated into the U8 system. Users only need to click the integration menu in the [U8+ Enterprise Application Platform] to start and use the applications developed by these movable type.
The following describes the configuration and operation methods of integrating the movable type application program in the U8 system.

(1) User Integration (Security Provider)
Movable Type's third-party user security provider is used to integrate user information with logins to third-party systems. Movable Type provides an ISecurityProvider interface. By implementing this interface, users can integrate with other systems (including users, roles, and organizations).

Steps:

a) On the designer, click the [Security]-[Authentication Mode]-[Third-Party User Integration] button to modify the application authentication mode.

Click the [Security] - [User Management] button to open the user management page. The username and password are the username and password of the administrator.

Click the [Third Party]-[Upload] button, select the corresponding third-party user integration zip package, and the zip package is saved in the \ movable type folder in the integrated file package.

After the upload is successful, the page is as follows:

In [Other Settings], add the server name, database name, database administrator's username and password of the database where the U8 user is located, and set the time interval for automatic synchronization of user information. If the database and the movable type service manager are on the same server, the ServerName can be used (local).

The effect after synchronization is completed is as follows:

b) The user management of the service manager uploads the third-party user integration zip package, and the operation method is the same as that of the designer user management.

(2) Menu integration The integrated movable type application is started through the custom menu in U8, and the custom menu is configured by executing the database SQL script. The configuration method is as follows:
a) Preset subsystem

 表名：UFSYSTEM库 ua_subsys_base表

Note: Before presetting, please confirm whether the module ID (cSub_Id) exists in it. An example of the SQL statement script for presetting the menu data is as follows:

Before script execution:

The effect after execution is as follows:

b) Preset menu table name: UFSYSTEM library UA_MENU table
The menu seen in the U8 service navigation needs to be preset in the UA_MENU table. The table structure is as follows:

Note: Please find out the ID of the upper-level menu in this table in advance, and preset a unique ID (non-repeatable) for the newly added menu.
Example of SQL statement script for preset menu data:

Before execution:

The effect after execution is shown in the following figure:

c) Preset interface

 表名：UFSYSTEM库 UA_IDT
 ID保持与菜单ID相同，其他项均使用以下sql中的值。
  预置接口数据的SQL语句脚本示例：

Before execution:

The effect after execution is shown in the following figure:

d) Preset menu attribute table name: The GC_MENU table of the UFSYSTEM library configures the URL address corresponding to the U8 menu, the single sign-on password and the default opening method. cMenu_Id remains the same as the U8 menu ID. DefaultTargetWindow can use the default value.

The database script is shown below:

Before execution:

After execution:

e) Single sign-on password acquisition:

 点击【设置】-【与另外的网站集成】按钮，勾选允许单点登录，将单点登录密码配置到GC_MENU表的SSO_Password字段。

f) Preset menu custom properties

 表名：UFSYSTEM库 GC_MENU_Option表
  自定义配置某一用户针对某一菜单的打开方式。cMenu_Id保持与U8菜单ID相同。cUser_Id保持与U8用户的userid一致。可针对自定义用户进行自定义的菜单打开方式。Popup为弹出页面，CurrentWindow为Tab形式打开。

The database script is as follows:

Before execution:

After execution:

The effect after execution is shown in the following figure:

When the above operations are completed correctly, the menu will be generated under the set node. The effect is as follows:

(3) Portal integration

To realize portal integration, copy the Forguncy.U8UserControl.dll file in the \Moveable Type\ folder of the integration package to the Portal directory of U8SOFT of the corresponding client (C:\U8SOFT\Portal).

For more information, please refer to:
U8 docking low-code implementation report analysis case: https://gcdn.grapecity.com.cn/showtopic-54262-1-1.html
If you are interested in the integrated kit, please contact us: https://www.grapecity.com.cn/solutions/huozige