123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475 |
- SELECT
- (
- SELECT
- CASE
- WHEN media_id = 1 THEN
- '头条'
- WHEN media_id = 2 THEN
- '快手'
- WHEN media_id = 3 THEN
- '头条内广'
- ELSE
- ''
- END
- FROM
- ctop_project
- WHERE
- id = t1.project_id
- ) AS '媒体',
- (
- SELECT
- project_name
- FROM
- ctop_project
- WHERE
- id = t1.project_id
- ) AS '项目',
- CONCAT('`',t1.account_id,'`' ) AS '账户id',
- (
- SELECT
- realname
- FROM
- sys_user
- WHERE
- id = t1.transferor
- ) AS '转户人',
- (
- SELECT
- realname
- FROM
- sys_user
- WHERE
- id = t1.assignee
- ) AS '受让人',
- t1.transferor_date AS '转户人绩效统计截止日期',
- t1.assignee_date AS '受让人绩效统计开始日期'
- FROM
- ctop_transfer_account t1
- WHERE
- t1.transferor_date >= '2022-01-01'
- AND t1.transferor_date <= '2022-01-31'
- and t1.transferor in(
- SELECT user_id from user_company WHERE company_id = '4b10089775c040119e139087517aed88'
- )
- ORDER BY
- t1.account_id
- select company_name,
- project_name,
- user.realname,
- leader.realname,
- concat('`',account_id,'`') as account_id,
- account_name,
- charge
- from (select company_name, project_name, user_id, leader_id, account_id, account_name, charge
- from application.app_kuaishou_account_report_busi_m
- where stat_mon = 202206
- and company_id = '4b10089775c040119e139087517aed88') a
- left join `jeecg-boot`.sys_user user
- on a.user_id = user.id
- left join `jeecg-boot`.sys_user leader
- on a.leader_id = leader.id
|