| 响应成功 | 返回指标的 SQL 查询结果，与指标「请求配置>查询SQL」下的信息相同。 
select
`t15`.`__fcol_72` as `__fcol_74`,
`t15`.`__fcol_73` as `__fcol_75`
from
(
select
`t5`.`__fcol_25` as `__fcol_72`,
sum(`t13`.`__fcol_69`) as `__fcol_73`
from
(
select
`t3`.`__fcol_12` as `__fcol_22`,
`t3`.`__fcol_13` as `__fcol_23`,
`t3`.`__fcol_14` as `__fcol_24`,
`t0`.`__fcol_1` as `__fcol_25`
from
(
select
date(`T_0ED77E705BA8425D9D1B0`.`注册时间`) as `__fcol_1`,
(
cast(year(`T_0ED77E705BA8425D9D1B0`.`注册时间`) as signed) - 1
) as `__fcol_2`,
month(`T_0ED77E705BA8425D9D1B0`.`注册时间`) as `__fcol_3`,
day(`T_0ED77E705BA8425D9D1B0`.`注册时间`) as `__fcol_4`
from
(
SELECT
*
FROM
合同信息表
) as `T_0ED77E705BA8425D9D1B0`
where
(
`T_0ED77E705BA8425D9D1B0`.`注册时间` >= timestamp('2025-12-17 10:23:22.0')
and `T_0ED77E705BA8425D9D1B0`.`注册时间` < timestamp('2026-01-16 10:23:23.0')
)
group by
1,
2,
3,
4
) as `t0`
join (
select
date(`t1`.`__fcol_5`) as `__fcol_12`,
`T_E284FF5BF8344B10A1888`.`记录人` as `__fcol_13`,
`t1`.`__fcol_6` as `__fcol_14`,
cast(year(`t1`.`__fcol_5`) as signed) as `__fcol_15`,
month(`t1`.`__fcol_5`) as `__fcol_16`,
day(`t1`.`__fcol_5`) as `__fcol_17`
from
(
select
`T_0ED77E705BA8425D9D1B0_0`.`注册时间` as `__fcol_5`,
`T_0ED77E705BA8425D9D1B0_0`.`合同签约时间` as `__fcol_6`,
`T_0ED77E705BA8425D9D1B0_0`.`合同ID` as `__fcol_7`
from
(
SELECT
*
FROM
合同信息表
) as `T_0ED77E705BA8425D9D1B0_0`
where
(
`T_0ED77E705BA8425D9D1B0_0`.`注册时间` < timestamp('2025-01-16 10:23:23.0')
and `T_0ED77E705BA8425D9D1B0_0`.`注册时间` >= timestamp('2024-12-17 10:23:22.0')
)
) as `t1`
join (
SELECT
*
FROM
合同回款信息
) as `T_E284FF5BF8344B10A1888` on `t1`.`__fcol_7` = `T_E284FF5BF8344B10A1888`.`合同ID`
group by
1,
2,
3,
4,
5,
6
) as `t3` on (
ifnull(`t0`.`__fcol_2`, 0) = ifnull(`t3`.`__fcol_15`, 0)
and case
when `t0`.`__fcol_2` is not null then 0
else 1
end = case
when `t3`.`__fcol_15` is not null then 0
else 1
end
and ifnull(`t0`.`__fcol_3`, 0) = ifnull(`t3`.`__fcol_16`, 0)
and case
when `t0`.`__fcol_3` is not null then 0
else 1
end = case
when `t3`.`__fcol_16` is not null then 0
else 1
end
and ifnull(`t0`.`__fcol_4`, 0) = ifnull(`t3`.`__fcol_17`, 0)
and case
when `t0`.`__fcol_4` is not null then 0
else 1
end = case
when `t3`.`__fcol_17` is not null then 0
else 1
end
)
group by
1,
2,
3,
4
) as `t5`
join (
select
date(`t8`.`__fcol_42`) as `__fcol_66`,
`t8`.`__fcol_40` as `__fcol_67`,
`t8`.`__fcol_43` as `__fcol_68`,
sum(
case
when (
case
when (
`t8`.`__fcol_40` = '徐弘'
or (
'徐弘' is null
and `t8`.`__fcol_40` is null
)
) then 1
else 0
end <> 0
and case
when (
`t8`.`__fcol_44` = '一次性付款'
or (
'一次性付款' is null
and `t8`.`__fcol_44` is null
)
) then 1
else 0
end <> 0
) then `t8`.`__fcol_41`
else null
end
) as `__fcol_69`
from
(
select
`t7`.`__fcol_32` as `__fcol_39`,
`t7`.`__fcol_33` as `__fcol_40`,
`t7`.`__fcol_34` as `__fcol_41`,
`t7`.`__fcol_35` as `__fcol_42`,
`t7`.`__fcol_36` as `__fcol_43`,
`t7`.`__fcol_37` as `__fcol_44`,
`t7`.`__fcol_38` as `__fcol_45`
from
(
select
`T_E284FF5BF8344B10A1888_0`.`付款时间` as `__fcol_32`,
`T_E284FF5BF8344B10A1888_0`.`记录人` as `__fcol_33`,
`T_E284FF5BF8344B10A1888_0`.`回款金额` as `__fcol_34`,
`T_0ED77E705BA8425D9D1B0_1`.`注册时间` as `__fcol_35`,
`T_0ED77E705BA8425D9D1B0_1`.`合同签约时间` as `__fcol_36`,
`T_0ED77E705BA8425D9D1B0_1`.`合同付款类型` as `__fcol_37`,
date(`T_0ED77E705BA8425D9D1B0_1`.`注册时间`) as `__fcol_38`
from
(
SELECT
*
FROM
合同回款信息
) as `T_E284FF5BF8344B10A1888_0`
left outer join (
SELECT
*
FROM
合同信息表
) as `T_0ED77E705BA8425D9D1B0_1` on `T_E284FF5BF8344B10A1888_0`.`合同ID` = `T_0ED77E705BA8425D9D1B0_1`.`合同ID`
) as `t7`
where
(
`t7`.`__fcol_35` < timestamp('2025-01-16 10:23:23.0')
and `t7`.`__fcol_35` >= timestamp('2024-12-17 10:23:22.0')
)
) as `t8`
left outer join (
select
date(`t9`.`__fcol_46`) as `__fcol_54`,
`T_E284FF5BF8344B10A1888_1`.`记录人` as `__fcol_55`,
`t9`.`__fcol_47` as `__fcol_56`,
max(`T_E284FF5BF8344B10A1888_1`.`付款时间`) as `__fcol_57`
from
(
SELECT
*
FROM
合同回款信息
) as `T_E284FF5BF8344B10A1888_1`
join (
select
`T_0ED77E705BA8425D9D1B0_2`.`注册时间` as `__fcol_46`,
`T_0ED77E705BA8425D9D1B0_2`.`合同签约时间` as `__fcol_47`,
`T_0ED77E705BA8425D9D1B0_2`.`合同ID` as `__fcol_48`
from
(
SELECT
*
FROM
合同信息表
) as `T_0ED77E705BA8425D9D1B0_2`
where
(
`T_0ED77E705BA8425D9D1B0_2`.`注册时间` < timestamp('2025-01-16 10:23:23.0')
and `T_0ED77E705BA8425D9D1B0_2`.`注册时间` >= timestamp('2024-12-17 10:23:22.0')
)
) as `t9` on `T_E284FF5BF8344B10A1888_1`.`合同ID` = `t9`.`__fcol_48`
group by
1,
2,
3
) as `t11` on (
ifnull(`t8`.`__fcol_45`, date('2000-01-01')) = ifnull(`t11`.`__fcol_54`, date('2000-01-01'))
and case
when `t8`.`__fcol_45` is not null then 0
else 1
end = case
when `t11`.`__fcol_54` is not null then 0
else 1
end
and ifnull(`t8`.`__fcol_40`, '0') = ifnull(`t11`.`__fcol_55`, '0')
and case
when `t8`.`__fcol_40` is not null then 0
else 1
end = case
when `t11`.`__fcol_55` is not null then 0
else 1
end
and ifnull(`t8`.`__fcol_43`, date('2000-01-01')) = ifnull(`t11`.`__fcol_56`, date('2000-01-01'))
and case
when `t8`.`__fcol_43` is not null then 0
else 1
end = case
when `t11`.`__fcol_56` is not null then 0
else 1
end
)
where
not(
cast((`t8`.`__fcol_39` = `t11`.`__fcol_57`) as signed) = 0
)
group by
1,
2,
3
) as `t13` on (
ifnull(`t5`.`__fcol_22`, date('2000-01-01')) = ifnull(`t13`.`__fcol_66`, date('2000-01-01'))
and case
when `t5`.`__fcol_22` is not null then 0
else 1
end = case
when `t13`.`__fcol_66` is not null then 0
else 1
end
and ifnull(`t5`.`__fcol_23`, '0') = ifnull(`t13`.`__fcol_67`, '0')
and case
when `t5`.`__fcol_23` is not null then 0
else 1
end = case
when `t13`.`__fcol_67` is not null then 0
else 1
end
and ifnull(`t5`.`__fcol_24`, date('2000-01-01')) = ifnull(`t13`.`__fcol_68`, date('2000-01-01'))
and case
when `t5`.`__fcol_24` is not null then 0
else 1
end = case
when `t13`.`__fcol_68` is not null then 0
else 1
end
)
group by
1
) as `t15`
order by
`t15`.`__fcol_72` asc
limit
5000
|
上一篇：指标/维度语义信息接口
