投稿
  1. 云图网首页
  2. 技术专区
  3. 大前端

在 Yii 2.0 中，当连接两个表时，在 JOIN 查询的 ON 部分中指定一些额外的条件，基于 ActiveDataFilter 查询过滤器的实现

• 大前端, 大数据, 研发管理, 编程笔记

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

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

图1

2、查看获取帐号列表的方法文件，代码如下

<?php
/**
 * @link http://www.yiiframework.com/
 * @copyright Copyright (c) 2008 Yii Software LLC
 * @license http://www.yiiframework.com/license/
 */

namespace api/rests/channel_app_source;

use Yii;
use api/models/Channel;
use api/models/ChannelType;
use api/models/ChannelAppSource;
use api/models/ChannelAppTask;
use api/services/CmcApiGroupService;
use yii/base/InvalidConfigException;
use yii/data/DataFilter;
use yii/data/ActiveDataProvider;
use yii/helpers/ArrayHelper;
use yii/web/UnprocessableEntityHttpException;
use yii/web/HttpException;
use yii/web/ServerErrorHttpException;

/**
 * 获取渠道的应用的来源列表：/channel-app-sources(channel-app-source/index)
 *
 * For more details and usage information on IndexAction, see the [guide channel_app_source on rest controllers](guide:rest-controllers).
 *
 * @author Qiang Wang <shuijingwanwq@163.com>
 * @since 1.0
 */
class IndexAction extends /yii/rest/IndexAction
{
    public $dataFilter = [
        'class' => 'yii/data/ActiveDataFilter',
        'searchModel' => 'api/models/ChannelAppSourceSearch',
        'attributeMap' => [
            'group_id' => '{{%channel_app_source}}.[[group_id]]',
            'uuid' => '{{%channel_app_source}}.[[uuid]]',
            'channel_code' => '{{%channel_app_source}}.[[channel_code]]',
            'channel_type_code' => '{{%channel_app_source}}.[[channel_type_code]]',
            'source' => '{{%channel_app_source}}.[source]',
            'source_uuid' => '{{%channel_app_source}}.[[source_uuid]]',
            'permission' => '{{%channel_app_source}}.[[permission]]',
            'status' => '{{%channel_app_source}}.[[status]]',
            'created_at' => '{{%channel_app_source}}.[[created_at]]',
        ],
    ];

    /**
     * Prepares the data provider that should return the requested collection of the models.
     * @return mixed|object|ActiveDataProvider|DataFilter|null
     * @throws HttpException
     * @throws InvalidConfigException if the configuration is invalid.
     * @throws ServerErrorHttpException
     * @throws UnprocessableEntityHttpException
     */
    protected function prepareDataProvider()
    {
        $requestParams = Yii::$app->getRequest()->getQueryParams();

        $filter = null;
        if ($this->dataFilter !== null) {
            $this->dataFilter = Yii::createObject($this->dataFilter);
            if ($this->dataFilter->load($requestParams)) {
                $filter = $this->dataFilter->build();
                if ($filter === false) {
                    $firstError = '';
                    foreach ($this->dataFilter->getFirstErrors() as $message) {
                        $firstError = $message;
                        break;
                    }
                    throw new UnprocessableEntityHttpException(Yii::t('error', Yii::t('error', Yii::t('error', '226013'), ['first_error' => $firstError])), 226013);
                }
            }
        }

        if ($this->prepareDataProvider !== null) {
            return call_user_func($this->prepareDataProvider, $this, $filter);
        }

        // 获取租户ID列表(二维数组，场景：筛选用户时，添加默认条件：租户ID仅限于当前租户ID|其所管辖的下级租户ID)
        $groupListTwo = CmcApiGroupService::getGroupListTwo(Yii::$app->params['groupId'], 'group_sub_tree', '1');
        $groupIds = ArrayHelper::getColumn($groupListTwo, 'group_id');

        /* @var $modelClass ChannelAppSource */
        $modelClass = $this->modelClass;

        $query = $modelClass::find()
            ->select([
                $modelClass::tableName() . '.*',
                'COUNT(' . ChannelAppTask::tableName() . '.id) AS channel_app_task_count'
            ])
            ->joinWith('channel')
            ->joinWith('channelType')
            ->joinWith('baijiaApp')
            ->joinWith('qqCwApp')
            ->joinWith('qqTpAppPenguin')
            ->joinWith('wxApp')
            ->joinWith('weiboWeiboConnectWebAppUser')
            ->joinWith('customizeApp')
            ->joinWith('neteaseTpAppUser')
            ->joinWith([
                'channelAppTasks' => function ($query) {
                    $query->onCondition([ChannelAppTask::tableName() . '.status' => ChannelAppTask::STATUS_PLATFORM_PUBLISHED]);
                },
            ], false)
            ->where([
                Channel::tableName() . '.is_deleted' => Channel::IS_DELETED_NO,
                ChannelType::tableName() . '.is_deleted' => ChannelType::IS_DELETED_NO,
                $modelClass::tableName() . '.is_deleted' => $modelClass::IS_DELETED_NO,
            ])
            ->andWhere(['in', $modelClass::tableName() . '.group_id', $groupIds])
            ->asArray()
            ->groupBy([$modelClass::tableName() . '.id']);
        if (!empty($filter)) {
            $query->andFilterWhere($filter);
        }

        return Yii::createObject([
            'class' => ActiveDataProvider::className(),
            'query' => $query,
            'pagination' => [
                'params' => $requestParams,
            ],
            'sort' => [
                'defaultOrder' => [
                    'id' => SORT_DESC,
                ],
                'attributes' => [
                    'id' => [
                        'asc' => ['id' => SORT_ASC],
                        'desc' => ['id' => SORT_DESC],
                        'default' => SORT_ASC,
                    ],
                    'fans_count' => [
                        'asc' => ['fans_count' => SORT_ASC, 'id' => SORT_ASC],
                        'desc' => ['fans_count' => SORT_DESC, 'id' => SORT_DESC],
                        'default' => SORT_ASC,
                    ],
                    'channel_app_task_count' => [
                        'asc' => ['channel_app_task_count' => SORT_ASC, 'id' => SORT_ASC],
                        'desc' => ['channel_app_task_count' => SORT_DESC, 'id' => SORT_DESC],
                        'default' => SORT_ASC,
                    ],
                ],
                'params' => $requestParams,
            ],
        ]);
    }
}

3、GET http://api.channel-pub-api.localhost/v1/channel-app-sources?group_id=015ce30b116ce86058fa6ab4fea4ac63&sort=-channel_app_task_count。 有时，当连接两个表时，你可能需要在 JOIN 查询的 ON 部分中指定一些额外的条件。这可以通过调用 yii/db/ActiveQuery::onCondition() 方法来完成，如下所示：

    ->joinWith([
        'channelAppTasks' => function ($query) {
            $query->onCondition([ChannelAppTask::tableName() . '.status' => ChannelAppTask::STATUS_PLATFORM_PUBLISHED]);
        },
    ], false)

4、SQL 部分：LEFT JOIN `cpa_channel_app_task` ON (`cpa_channel_app_source`.`id` = `cpa_channel_app_task`.`channel_app_source_id`) AND (`cpa_channel_app_task`.`status`=6) 表示关联表 cpa_channel_app_task 时，需要指定其 status 等于 6。最终生成的 SQL 语句如下

SELECT `cpa_channel_app_source`.*, COUNT(`cpa_channel_app_task`.id) AS `channel_app_task_count` FROM `cpa_channel_app_source` LEFT JOIN `cpa_channel` ON `cpa_channel_app_source`.`channel_id` = `cpa_channel`.`id` LEFT JOIN `cpa_channel_type` ON `cpa_channel_app_source`.`channel_type_id` = `cpa_channel_type`.`id` LEFT JOIN `cpa_qq_cw_app` ON `cpa_channel_app_source`.`id` = `cpa_qq_cw_app`.`channel_app_source_id` LEFT JOIN `cpa_qq_tp_app_penguin` ON `cpa_channel_app_source`.`id` = `cpa_qq_tp_app_penguin`.`channel_app_source_id` LEFT JOIN `cpa_wx_app` ON `cpa_channel_app_source`.`id` = `cpa_wx_app`.`channel_app_source_id` LEFT JOIN `cpa_weibo_weibo_connect_web_app_user` ON `cpa_channel_app_source`.`id` = `cpa_weibo_weibo_connect_web_app_user`.`channel_app_source_id` LEFT JOIN `cpa_customize_app` ON `cpa_channel_app_source`.`id` = `cpa_customize_app`.`channel_app_source_id` LEFT JOIN `cpa_netease_tp_app_user` ON `cpa_channel_app_source`.`id` = `cpa_netease_tp_app_user`.`channel_app_source_id` LEFT JOIN `cpa_channel_app_task` ON (`cpa_channel_app_source`.`id` = `cpa_channel_app_task`.`channel_app_source_id`) AND (`cpa_channel_app_task`.`status`=6) WHERE ((`cpa_channel`.`is_deleted`=0) AND (`cpa_channel_type`.`is_deleted`=0) AND (`cpa_channel_app_source`.`is_deleted`=0)) AND (`cpa_channel_app_source`.`group_id` IN ('015ce30b116ce86058fa6ab4fea4ac63', '4fd58ceba1fbc537b5402302702131eb')) GROUP BY `cpa_channel_app_source`.`id` ORDER BY `channel_app_task_count` DESC, `id` DESC LIMIT 20

5、现在由于需要支持表 cpa_channel_app_task 的记录的创建时间的筛选，因此，需要实现如下的 SQL 查询

LEFT JOIN `cpa_channel_app_task` ON (`cpa_channel_app_source`.`id` = `cpa_channel_app_task`.`channel_app_source_id`) AND ((`cpa_channel_app_task`.`status`=6) AND ((`cpa_channel_app_task`.`created_at` >= '1600334142') AND (`cpa_channel_app_task`.`created_at` <= '1600334142')))

6、编辑获取帐号列表的方法文件，新增加一个过滤器，配置其属性 ‘filterAttributeName’ => ‘channel_app_task_filter’, 。代码如下

<?php
/**
 * @link http://www.yiiframework.com/
 * @copyright Copyright (c) 2008 Yii Software LLC
 * @license http://www.yiiframework.com/license/
 */

namespace api/rests/channel_app_source;

use Yii;
use api/models/Channel;
use api/models/ChannelType;
use api/models/ChannelAppSource;
use api/models/ChannelAppTask;
use api/services/CmcApiGroupService;
use yii/base/InvalidConfigException;
use yii/data/DataFilter;
use yii/data/ActiveDataProvider;
use yii/helpers/ArrayHelper;
use yii/web/UnprocessableEntityHttpException;
use yii/web/HttpException;
use yii/web/ServerErrorHttpException;

/**
 * 获取渠道的应用的来源列表：/channel-app-sources(channel-app-source/index)
 *
 * For more details and usage information on IndexAction, see the [guide channel_app_source on rest controllers](guide:rest-controllers).
 *
 * @author Qiang Wang <shuijingwanwq@163.com>
 * @since 1.0
 */
class IndexAction extends /yii/rest/IndexAction
{
    public $dataFilter = [
        'class' => 'yii/data/ActiveDataFilter',
        'searchModel' => 'api/models/ChannelAppSourceSearch',
        'attributeMap' => [
            'group_id' => '{{%channel_app_source}}.[[group_id]]',
            'uuid' => '{{%channel_app_source}}.[[uuid]]',
            'channel_code' => '{{%channel_app_source}}.[[channel_code]]',
            'channel_type_code' => '{{%channel_app_source}}.[[channel_type_code]]',
            'source' => '{{%channel_app_source}}.[source]',
            'source_uuid' => '{{%channel_app_source}}.[[source_uuid]]',
            'permission' => '{{%channel_app_source}}.[[permission]]',
            'status' => '{{%channel_app_source}}.[[status]]',
            'created_at' => '{{%channel_app_source}}.[[created_at]]',
        ],
    ];

    public $channelAppTaskDataFilter = [
        'class' => 'yii/data/ActiveDataFilter',
        'filterAttributeName' => 'channel_app_task_filter',
        'searchModel' => 'api/models/ChannelAppSourceSearch',
        'attributeMap' => [
            'created_at' => '{{%channel_app_task}}.[[created_at]]',
        ],
    ];

    /**
     * Prepares the data provider that should return the requested collection of the models.
     * @return mixed|object|ActiveDataProvider|DataFilter|null
     * @throws HttpException
     * @throws InvalidConfigException if the configuration is invalid.
     * @throws ServerErrorHttpException
     * @throws UnprocessableEntityHttpException
     */
    protected function prepareDataProvider()
    {
        $requestParams = Yii::$app->getRequest()->getQueryParams();

        $filter = null;
        if ($this->dataFilter !== null) {
            $this->dataFilter = Yii::createObject($this->dataFilter);
            if ($this->dataFilter->load($requestParams)) {
                $filter = $this->dataFilter->build();
                if ($filter === false) {
                    $firstError = '';
                    foreach ($this->dataFilter->getFirstErrors() as $message) {
                        $firstError = $message;
                        break;
                    }
                    throw new UnprocessableEntityHttpException(Yii::t('error', Yii::t('error', Yii::t('error', '226013'), ['first_error' => $firstError])), 226013);
                }
            }
        }

        $channelAppTaskFilter = null;
        if ($this->channelAppTaskDataFilter !== null) {
            $this->channelAppTaskDataFilter = Yii::createObject($this->channelAppTaskDataFilter);
            if ($this->channelAppTaskDataFilter->load($requestParams)) {
                $channelAppTaskFilter = $this->channelAppTaskDataFilter->build();
                if ($channelAppTaskFilter === false) {
                    $firstError = '';
                    foreach ($this->channelAppTaskDataFilter->getFirstErrors() as $message) {
                        $firstError = $message;
                        break;
                    }
                    throw new UnprocessableEntityHttpException(Yii::t('error', Yii::t('error', Yii::t('error', '226013'), ['first_error' => $firstError])), 226013);
                }
            }
        }

        if ($this->prepareDataProvider !== null) {
            return call_user_func($this->prepareDataProvider, $this, $filter);
        }

        // 获取租户ID列表(二维数组，场景：筛选用户时，添加默认条件：租户ID仅限于当前租户ID|其所管辖的下级租户ID)
        $groupListTwo = CmcApiGroupService::getGroupListTwo(Yii::$app->params['groupId'], 'group_sub_tree', '1');
        $groupIds = ArrayHelper::getColumn($groupListTwo, 'group_id');

        /* @var $modelClass ChannelAppSource */
        $modelClass = $this->modelClass;

        Yii::$app->params['channelAppTaskFilter'] = $channelAppTaskFilter;

        $query = $modelClass::find()
            ->select([
                $modelClass::tableName() . '.*',
                'COUNT(' . ChannelAppTask::tableName() . '.id) AS channel_app_task_count'
            ])
            ->joinWith('channel')
            ->joinWith('channelType')
            ->joinWith('baijiaApp')
            ->joinWith('douyinWeiboAppUser')
            ->joinWith('qqCwApp')
            ->joinWith('qqTpAppPenguin')
            ->joinWith('wxApp')
            ->joinWith('weiboWeiboConnectWebAppUser')
            ->joinWith('customizeApp')
            ->joinWith('neteaseTpAppUser')
            ->joinWith([
                'channelAppTasks' => function ($query) {
                    $query->onCondition([ChannelAppTask::tableName() . '.status' => ChannelAppTask::STATUS_PLATFORM_PUBLISHED])->andOnCondition(Yii::$app->params['channelAppTaskFilter']);
                },
            ], false)
            ->where([
                Channel::tableName() . '.is_deleted' => Channel::IS_DELETED_NO,
                ChannelType::tableName() . '.is_deleted' => ChannelType::IS_DELETED_NO,
                $modelClass::tableName() . '.is_deleted' => $modelClass::IS_DELETED_NO,
            ])
            ->andWhere(['in', $modelClass::tableName() . '.group_id', $groupIds])
            ->asArray()
            ->groupBy([$modelClass::tableName() . '.id']);
        if (!empty($filter)) {
            $query->andFilterWhere($filter);
        }

        return Yii::createObject([
            'class' => ActiveDataProvider::className(),
            'query' => $query,
            'pagination' => [
                'params' => $requestParams,
            ],
            'sort' => [
                'defaultOrder' => [
                    'id' => SORT_DESC,
                ],
                'attributes' => [
                    'id' => [
                        'asc' => ['id' => SORT_ASC],
                        'desc' => ['id' => SORT_DESC],
                        'default' => SORT_ASC,
                    ],
                    'fans_count' => [
                        'asc' => ['fans_count' => SORT_ASC, 'id' => SORT_ASC],
                        'desc' => ['fans_count' => SORT_DESC, 'id' => SORT_DESC],
                        'default' => SORT_ASC,
                    ],
                    'channel_app_task_count' => [
                        'asc' => ['channel_app_task_count' => SORT_ASC, 'id' => SORT_ASC],
                        'desc' => ['channel_app_task_count' => SORT_DESC, 'id' => SORT_DESC],
                        'default' => SORT_ASC,
                    ],
                ],
                'params' => $requestParams,
            ],
        ]);
    }
}

7、GET http://api.channel-pub-api.localhost/v1/channel-app-sources?filter[status]=1&per-page=5&channel_app_task_filter[created_at][gte]=1595991435&channel_app_task_filter[created_at][lte]=1600334194&group_id=c10e87f39873512a16727e17f57456a5&sort=-channel_app_task_count 。响应如下，符合预期，如图2

GET http://api.channel-pub-api.localhost/v1/channel-app-sources?filter[status]=1&per-page=5&channel_app_task_filter[created_at][gte]=1595991435&channel_app_task_filter[created_at][lte]=1600334194&group_id=c10e87f39873512a16727e17f57456a5&sort=-channel_app_task_count 。响应如下，符合预期

图2

{
"code": 10000,
"message": "获取渠道的应用的来源列表成功",
"data": {
"items": [
{
"id": 28,
"group_id": "015ce30b116ce86058fa6ab4fea4ac63",
"group_name": "深圳市",
"uuid": "4851b0eef81911ea8c9954ee75d2ebc1",
"channel_id": 3,
"channel_code": "weibo",
"channel_type_id": 4,
"channel_type_code": "weibo_weibo_connect_web",
"name": "永夜烟",
"avatar": "https://tva3.sinaimg.cn/crop.0.0.180.180.1024/9bb8f5bdjw1e8qgp5bmzyj2050050aa8.jpg?KID=imgbed,tva&Expires=1600270597&ssig=r9d4HXo5f7",
"fans_count": 0,
"source": "spider",
"source_uuid": "825e6d5e36468cc4bf536799ce3565cf",
"permission": 2,
"status": 1,
"is_deleted": 0,
"created_at": 1600259805,
"updated_at": 1600259805,
"deleted_at": 0,
"channel_app_task_count": 2,
"channel_name": "微博",
"channel_type_name": "微博的微连接的网页应用"
},
{
"id": 20,
"group_id": "015ce30b116ce86058fa6ab4fea4ac63",
"group_name": "深圳市",
"uuid": "362d8170d14711eabb5954ee75d2ebc1",
"channel_id": 4,
"channel_code": "baijia",
"channel_type_id": 5,
"channel_type_code": "baijia",
"name": "栖云天下通",
"avatar": "",
"fans_count": 0,
"source": "spider",
"source_uuid": "dc1ec2188c4d8cd91111aa5055439b1w",
"permission": 2,
"status": 1,
"is_deleted": 0,
"created_at": 1595991435,
"updated_at": 1595991435,
"deleted_at": 0,
"channel_app_task_count": 2,
"channel_name": "百家号",
"channel_type_name": "百家号"
},
{
"id": 32,
"group_id": "015ce30b116ce86058fa6ab4fea4ac63",
"group_name": "深圳市",
"uuid": "aaa98ad6fed211ea9bc954ee75d2ebc1",
"channel_id": 1,
"channel_code": "qq",
"channel_type_id": 2,
"channel_type_code": "qq_tp",
"name": "华栖云秀",
"avatar": "http://inews.gtimg.com/newsapp_ls/0/4867371999_200200/0",
"fans_count": 0,
"source": "spider",
"source_uuid": "825e6d5e36468cc4bf536799ce3565cf",
"permission": 3,
"status": 1,
"is_deleted": 0,
"created_at": 1600999133,
"updated_at": 1600999133,
"deleted_at": 0,
"channel_app_task_count": 0,
"channel_name": "企鹅号",
"channel_type_name": "企鹅号的第三方服务平台应用"
},
{
"id": 31,
"group_id": "015ce30b116ce86058fa6ab4fea4ac63",
"group_name": "深圳市",
"uuid": "03111c38f8c111eaa0f154ee75d2ebc1",
"channel_id": 3,
"channel_code": "weibo",
"channel_type_id": 4,
"channel_type_code": "weibo_weibo_connect_web",
"name": "terryhong123",
"avatar": "https://tvax4.sinaimg.cn/crop.0.0.888.888.1024/e04a6511ly8ga5ssss65zj20oo0oomzu.jpg?KID=imgbed,tva&Expires=1600342637&ssig=weSAYT8b83",
"fans_count": 0,
"source": "spider",
"source_uuid": "825e6d5e36468cc4bf536799ce3565cf",
"permission": 2,
"status": 1,
"is_deleted": 0,
"created_at": 1600331844,
"updated_at": 1600331844,
"deleted_at": 0,
"channel_app_task_count": 0,
"channel_name": "微博",
"channel_type_name": "微博的微连接的网页应用"
},
{
"id": 30,
"group_id": "015ce30b116ce86058fa6ab4fea4ac63",
"group_name": "深圳市",
"uuid": "66cc5808f8b911eaa86f54ee75d2ebc1",
"channel_id": 3,
"channel_code": "weibo",
"channel_type_id": 4,
"channel_type_code": "weibo_weibo_connect_web",
"name": "右可在可蜚百里好87fr在章旭飞55",
"avatar": "https://tvax4.sinaimg.cn/crop.210.0.540.540.1024/62d9250aly1fy2syxmiooj20qo0f0wei.jpg?KID=imgbed,tva&Expires=1600339369&ssig=pAQqCgWTnU",
"fans_count": 0,
"source": "spider",
"source_uuid": "825e6d5e36468cc4bf536799ce3565cf",
"permission": 2,
"status": 1,
"is_deleted": 0,
"created_at": 1600328576,
"updated_at": 1600328576,
"deleted_at": 0,
"channel_app_task_count": 0,
"channel_name": "微博",
"channel_type_name": "微博的微连接的网页应用"
}
],
"_links": {
"self": {
"href": "http://api.channel-pub-api.localhost/v1/channel-app-sources?filter%5Bstatus%5D=1&per-page=5&channel_app_task_filter%5Bcreated_at%5D%5Bgte%5D=1595991435&channel_app_task_filter%5Bcreated_at%5D%5Blte%5D=1600334194&group_id=c10e87f39873512a16727e17f57456a5&sort=-channel_app_task_count&page=1"
},
"next": {
"href": "http://api.channel-pub-api.localhost/v1/channel-app-sources?filter%5Bstatus%5D=1&per-page=5&channel_app_task_filter%5Bcreated_at%5D%5Bgte%5D=1595991435&channel_app_task_filter%5Bcreated_at%5D%5Blte%5D=1600334194&group_id=c10e87f39873512a16727e17f57456a5&sort=-channel_app_task_count&page=2"
},
"last": {
"href": "http://api.channel-pub-api.localhost/v1/channel-app-sources?filter%5Bstatus%5D=1&per-page=5&channel_app_task_filter%5Bcreated_at%5D%5Bgte%5D=1595991435&channel_app_task_filter%5Bcreated_at%5D%5Blte%5D=1600334194&group_id=c10e87f39873512a16727e17f57456a5&sort=-channel_app_task_count&page=2"
}
},
"_meta": {
"totalCount": 9,
"pageCount": 2,
"currentPage": 1,
"perPage": 5
}
}
}

8、最终生成的 SQL 如下，如图3

最终生成的 SQL 如下

图3

SELECT `cpa_channel_app_source`.*, COUNT(`cpa_channel_app_task`.id) AS `channel_app_task_count` FROM `cpa_channel_app_source` LEFT JOIN `cpa_channel` ON `cpa_channel_app_source`.`channel_id` = `cpa_channel`.`id` LEFT JOIN `cpa_channel_type` ON `cpa_channel_app_source`.`channel_type_id` = `cpa_channel_type`.`id` LEFT JOIN `cpa_baijia_app` ON `cpa_channel_app_source`.`id` = `cpa_baijia_app`.`channel_app_source_id` LEFT JOIN `cpa_douyin_web_app_user` ON `cpa_channel_app_source`.`id` = `cpa_douyin_web_app_user`.`channel_app_source_id` LEFT JOIN `cpa_qq_cw_app` ON `cpa_channel_app_source`.`id` = `cpa_qq_cw_app`.`channel_app_source_id` LEFT JOIN `cpa_qq_tp_app_penguin` ON `cpa_channel_app_source`.`id` = `cpa_qq_tp_app_penguin`.`channel_app_source_id` LEFT JOIN `cpa_wx_app` ON `cpa_channel_app_source`.`id` = `cpa_wx_app`.`channel_app_source_id` LEFT JOIN `cpa_weibo_weibo_connect_web_app_user` ON `cpa_channel_app_source`.`id` = `cpa_weibo_weibo_connect_web_app_user`.`channel_app_source_id` LEFT JOIN `cpa_customize_app` ON `cpa_channel_app_source`.`id` = `cpa_customize_app`.`channel_app_source_id` LEFT JOIN `cpa_netease_tp_app_user` ON `cpa_channel_app_source`.`id` = `cpa_netease_tp_app_user`.`channel_app_source_id` LEFT JOIN `cpa_channel_app_task` ON (`cpa_channel_app_source`.`id` = `cpa_channel_app_task`.`channel_app_source_id`) AND ((`cpa_channel_app_task`.`status`=6) AND ((`cpa_channel_app_task`.`created_at` >= '1595991435') AND (`cpa_channel_app_task`.`created_at` <= '1600334194'))) WHERE ((`cpa_channel`.`is_deleted`=0) AND (`cpa_channel_type`.`is_deleted`=0) AND (`cpa_channel_app_source`.`is_deleted`=0)) AND (`cpa_channel_app_source`.`group_id` IN ('c10e87f39873512a16727e17f57456a5', '015ce30b116ce86058fa6ab4fea4ac63', '4fd58ceba1fbc537b5402302702131eb', 'e774bfcf8fc4cfe2ce57ac875a266e94', '9852bb7c32a44709cd748180784fcb81')) AND (`cpa_channel_app_source`.`status`='1') GROUP BY `cpa_channel_app_source`.`id` ORDER BY `channel_app_task_count` DESC, `id` DESC LIMIT 5

原创文章，作者：奋斗，如若转载，请注明出处：https://blog.ytso.com/tech/webdev/181586.html

赞 (0)
0 0
上一篇 2021年11月1日 04:52
下一篇 2021年11月1日 04:53

相关推荐

发表回复

登录后才能评论