Mysql的case when then实现报表分组不同字段显示不同结果打勾

最新推荐文章于 2023-07-03 16:39:15 发布

曾经的逍遥少年

最新推荐文章于 2023-07-03 16:39:15 发布

阅读量721

点赞数

文章标签： sql 数据库

本文链接：https://blog.csdn.net/m0_46093203/article/details/125811654

版权

今天在做一个企业的请假报表功能时，处理了一个函数实现下拉框获取的值显示不同的请假类型。如图所示：
在这里插入图片描述
Mysql数据库语句

SELECT
 position_hiera,
 dept_name,
 user_name,
CASE
  WHEN vacate_type = '年假' THEN
  '✔'
END AS vacate_type1,
CASE
  WHEN vacate_type = '婚假' THEN
  '✔'
END AS vacate_type2,
CASE
  WHEN vacate_type = '丧假' THEN
  '✔'
END AS vacate_type3,
CASE
  WHEN vacate_type = '产假' THEN
  '✔'
END AS vacate_type4,
CASE
  WHEN vacate_type = '陪产假' THEN
  '✔'
END AS vacate_type5,
CASE
  WHEN vacate_type = '病假' THEN
  '✔'
END AS vacate_type6,
CASE 
  WHEN vacate_type = '事假' THEN
  '✔' 
 END AS vacate_type7,
CASE
  WHEN vacate_type = '年假' THEN
  '年假' 
  WHEN vacate_type = '婚假' THEN
  '婚假' 
  WHEN vacate_type = '丧假' THEN
  '丧假' 
  WHEN vacate_type = '产假' THEN
  '产假' 
  WHEN vacate_type = '陪产假' THEN
  '陪产假' 
  WHEN vacate_type = '病假' THEN
  '病假' 
  WHEN vacate_type = '事假' THEN
  '事假' 
 END AS vacate_type8,
 start_date,
 end_date,
 vacate_len,
 vacate 
FROM
 oa_vacate 
WHERE
 (
  position_hiera) IN (
 SELECT
  position_hiera
 FROM
  oa_vacate 
 GROUP BY
 position_hiera
 )