1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| SELECT
t2.company_name,
t1.one_to_one_date,
t3.`name`,
CASE t1.follow_type
WHEN 1 THEN '线上'
WHEN 2 THEN '线下'
WHEN 3 THEN '上门'
ELSE '暂无'
END AS follow_type_description
FROM
`admin_crm_one_to_one_follow_record` t1
LEFT JOIN admin_crm_customer t2 ON t1.customer_id = t2.id
LEFT JOIN admin_crm_member t3 ON t1.member_id = t3.id
WHERE
t1.one_to_one_date > '2024-12'
|
