Eternal Night

Tagged: attributeMap

现在的需求如下，需要基于文章发布的时间范围，筛选基于文章发布数量的帐号排行。 0

Yii2 Database Migration / Database / Programming Language / Web Framework / MySQL / PHP / SQL / Yii / MySQL 5.7 / PHP 7.4 / Yii 2 / Web Application Development

In Yii 2.0, when connecting two tables, specify some additional conditions in the ON section of the join query, based on the implementation of the ActiveDataFilter query filter

浏览量： 1 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...

GET http://api.channel-pub-api.localhost/v1/channel-app-tasks?group_id=c10e87f39873512a16727e17f57456a5&filter[and][0][or][0][baijia_article_type_code]=video&filter[and][0][or][1][customize_article_type_code]=video&filter[and][0][or][2][douyin_article_type_code]=video&filter[and][0][or][3][netease_article_type_code]=video&filter[and][0][or][4][qq_article_type_code]=video&filter[and][0][or][5][weibo_article_type_code]=video&filter[and][0][or][6][wx_article_type_code]=video 。响应数据。 0

Yii 2 / Web Application Development / Yii2 Data Filter / Database / Programming Language / Web Framework / MySQL / PHP / SQL / Yii / MySQL 5.7 / PHP 7.4

In Yii 2.0, when there are multiple associations in the table structure (the same associated field exists in multiple tables), the implementation of query filtering based on ActiveDataFilter

浏览量： 1 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...

sort=-channel_app_task_count 。响应资源列表。查看日志中的 SQL 语句 。符合预期。 0

Web Application Development / Programming Language / Web Framework / PHP / SQL / Yii / PHP 7.4 / Yii 2

In Yii 2.0, the sorting of alias fields based on the ActiveDataFilter implementation is sorted

浏览量： 0 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...