Tag: Yii 2.0
-
Post Views: 17 1. Expect the generated SQL statement, as shown in Figure 1 2. LIKE: The first operand should be a field name or dB expression, and the second operand can make a string or an array, representing the value of the first operand that needs to be fuzzy. For example,[‘like’, ‘name’, ‘tester’]will generate name like%tester%. If the range…
-
Post Views: 12 1. In Yii 2.0, the active record of Redis (Active Record) is based on the view structure, which is inconsistent with the order of the model fields. as shown in Figure 1 2. Check the Redis activity record class, /common/models/redis/douyinwebappUserAccessToken.php 3. Print the model object of redis (before the update), $redisdouyinWebAppUserAccessToken. 4. Print the model object of…
-
Post Views: 20 1. The current requirements are as follows. Based on the time range of article publishing, it is necessary to filter account rankings based on the number of articles published. as shown in Figure 1 2. View the method file of the obtained account list, the code is as follows 3, gethttp://api.channel-pub-api.localhost/v1/channel-app-sources?group_id=015ce30b116ce86058fa6ab4fea4ac63&sort=-channel_app_task_count。Sometimes, when connecting two tables, you may…
-
Post Views: 14 1. Main table: CPA_CHANNEL_APP_TASK and Schedule: CPA_Task: many-to-one. as shown in Figure 1 2, table: cpa_task and Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|cp a_netease_article|cpa_qq_article|cpa_weibo_article|cpa_wx_article The association relationship: one-on-one. Table: A record in cpa_task will only exist in Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|cp a_netease_article|cpa_qq_article|cpa_weibo_article|cpa_wx_article in one of the tables. As shown in Figure 2, Figure 3, Figure 4 3. Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|c PA_Netease_Article|CPA_QQ_Article|CPA_Weibo_Article|CPA_WX_Article…
-
Post Views: 10 1. Table name: CPA_CHANNEL_APP_SOURCE design, table prefix: CPA_, as shown in Figure 1 2. View command: yii migrate/create help documentation 3. Add field. If the migrated name follows the format of add_xxx_to_yyy, the generated class file will contain the necessary addColumn and dropColumn. You can specify multiple fields like this: yii migrate/create add_xxx_column_yyy_column_to_zzz_table –fields=”xxx:integer,yyy:text”. as shown in…
-
Post Views: 18 1. Check the search model file: /common/logics/weiboWeiBoConnectWebAppUsersarch.php. 7. Edit method entry file: /weibo/rests/weibo_weibo_connect_web_app_user/indexaction.php. Implement the search and sorting of the channel_app_task_count. The inclusion of channel_app_task_count is prerequisite for the channel_app_task field status of 6. 2. View the method entry file: /weibo/rests/weibo_weibo_connect_web_app_user/indexaction.php.
-
Post Views: 13 1. In the topic selection list page, whether it has been extended, 0: no; 1: Yes, this field does not exist in the topic selection table. is calculated by program. $time is the current Beijing time, calculated by the server. as shown in Figure 1 2. In the latest version of the prototype, you need to support…
-
Post Views: 14 1. Under api.pcs-stat.localhost, a standard RESTful API. The code in the method file is as follows (written by a colleague). as shown in Figure 1 2. Now plan to migrate this interface to api.pcs-api.localhost, at this time, api.pcs-api.localhost is an RPC client, api.pcs-stat.localhost is RPC server. Reference:https://www.shuijingwanwq.com/en/2020/06/23/11545/. 3. Create a new RPC server file, RPC/Controllers/DataPlanControlTaskController.php 4. Create…
-
Post Views: 13 1. In Yii 2.0, the realization of health check, a colleague implemented a version before, I feel that it is necessary to adjust it again 2. The analysis code found that yii::$app->db->getisActive() is unnecessary. View the source code of the corresponding method separately. The related implementation of $this->pdo in getIsActive() already exists in open() . 3. Analyze…
-
Post Views: 15 1. Based on the function: file_put_contents, when a string is written to the file, there are various forms in the group when defining the file name to be written to 2. Under different forms, the problem is that with the change of the running environment of the program, the file name of the written data is also…