| | |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.time.LocalDateTime; |
| | | import java.util.Collections; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.time.LocalDateTime; |
| | | import java.util.Collections; |
| | | import java.util.List; |
| | | |
| | | @Service |
| | |
| | | |
| | | |
| | | import cn.hutool.core.convert.Convert; |
| | | import cn.hutool.core.date.DateUtil; |
| | | import cn.hutool.core.util.ObjectUtil; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.gkhy.exam.common.constant.Constants; |
| | | import com.gkhy.exam.common.constant.UserConstant; |
| | | import com.gkhy.exam.common.domain.TreeSelect; |
| | | import com.gkhy.exam.common.domain.entity.SysDept; |
| | | import com.gkhy.exam.common.domain.entity.SysRole; |
| | | import com.gkhy.exam.common.domain.entity.SysUser; |
| | | import com.gkhy.exam.common.exception.ApiException; |
| | | import com.gkhy.exam.common.utils.SecurityUtils; |
| | | import com.gkhy.exam.common.utils.SpringUtils; |
| | | import com.gkhy.exam.system.domain.ExPaperStudent; |
| | | import com.gkhy.exam.system.domain.SysDeptResponsibility; |
| | | import com.gkhy.exam.system.domain.SysFunctionalDistribution; |
| | | import com.gkhy.exam.system.domain.vo.*; |
| | |
| | | </resultMap> |
| | | <resultMap type="com.gkhy.exam.system.domain.vo.DeptVo" id="DeptVoResult" extends="SysDeptResult"> |
| | | <collection property="caluseVO1List" ofType="com.gkhy.exam.system.domain.vo.CaluseVO1"> |
| | | <id property="clauseNum" column="clause_num" /> |
| | | <result property="clauseNum" column="clause_num" /> |
| | | <result property="content" column="content" /> |
| | | <result property="clauseId" column="clause_id" /> |
| | | <result property="id" column="data_id" /> |
| | | </collection> |
| | | </resultMap> |
| | | |
| | |
| | | |
| | | <select id="selectDeptList" parameterType="com.gkhy.exam.common.domain.entity.SysDept" resultMap="DeptVoResult"> |
| | | select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader_user_id, d.company_id, d.status, d.del_flag, d.create_by, d.create_time,d.person_num,d.internal_auditors, |
| | | d.responsibilities,u.name as leader_name,d2.dept_name as parent_name, dr.content ,dr.clause_num |
| | | d.responsibilities,u.name as leader_name,d2.dept_name as parent_name, dr.content ,dr.clause_num,dr.id as data_id,dr.clause_id |
| | | from sys_dept d |
| | | left join sys_user u on d.leader_user_id = u.id |
| | | left join sys_dept d2 on d.parent_id = d2.dept_id |