Category: SQL
-
Post Views: 19 1. Edit and update the UI of the task type and step settings of the tenant to complete the design after the interface is implemented. Implementation of the previous version:https://www.shuijingwanwq.com/2019/11/14/3605/, in the previous version, the task type can be implemented at the same time: the task type can be (add, delete, rename its name, sort), and the…
-
Post Views: 13 1. The requirements for editing and updating the tenant’s task type and step settings have changed, and users need to allow users to add task types independently, and then select some of them from the 18 steps to add to the newly added task type. Implementation of the previous version:https://www.shuijingwanwq.com/2019/11/06/3583/, in the previous version, only the user…
-
Post Views: 18 1. Open the task configuration table, as shown in Figure 1 2. Open the task step configuration table, as shown in Figure 2 3. Now there are new requirements: Based on different tenants, the task configuration and task step configuration can be customized. Therefore, it is decided to create a new tenant’s task configuration table and tenant’s…
-
Post Views: 57 1. The current table design (the relationship between the topic selection and the resource), the field: plan_id indicates which topic selection ID the record belongs to, as shown in Figure 1 2. In the editing topic page, 2 resource files are uploaded, as shown in Figure 2 3. After saving the topic, open the resource table and…
-
Post Views: 45 1. Since the log message is stored in the log table of mysql, in the production environment, a large amount of data has been accumulated, and the data length of the log table has reached hundreds of gigabytes. Therefore, it is decided to implement the timing deletion of log messages based on the console command line, and…
-
Post Views: 15 1. View the task list page of Zen Tao, and its sorting is based on the descending order of ID, as shown in Figure 1 2. After clicking on the consumption field, the triangle is displayed as dark, indicating that the current sorting is based on the consumption ascending order, and if its value is the same,…
-
Post Views: 50 1. Data validation failed in Yii 2.0: the source publishing user ID must be a string. as shown in Figure 1 2. The reason is the field: source_pub_user_id was int(11) in the table before, and later modified to varchar(64), in the model file regenerated based on GII, the verification rules are as follows 3. The interface has…
-
Post Views: 17 1. Table: Fields in pub_log: The type of data is: text, as shown in Figure 1 2. Table: field in pub_log: data structure of data is: json, the formatted data is as follows, as shown in Figure 2 3. The current requirement is that if “channel_app_task_status”: 6, it needs to be changed to: “channel_app_task_status”: 7, that is,…
-
Post Views: 16 1. Reference URL:https://www.shuijingwanwq.com/2019/08/15/3427/ 2. Update table: field in channel_app_source: The value of Permission is: 3, as shown in Figure 1 3. Based on the database migration command, generate the implementation of a SQL as shown above, edit \console\migrations\m190815_020034_permission.php 4. Execute the database migration command, as shown in Figure 2 5. Check the table: the field in channel_app_source:…
-
Post Views: 18 1. Table: weibo_weibo_connect_web_app_user field: permission, ready to move to table: channel_app_source field in: Permission, and then delete the table: weibo_weibo_connect_web_app_user field: Permission, as shown in Figure 1 2. Table: Fields in channel_app_source: Permission, table: weibo_weibo_connect_web_app_user: CHANNEL_APP_SOURCE_ID Associated with the field: ID in CHANNEL_APP_SOURCE, as shown in Figure 2 3. SQL is as follows, update the table: fields…