| | |
| | | private String title; |
| | | @ApiModelProperty(value = "数据id") |
| | | private String dataId; |
| | | @ApiModelProperty(value = "数据类型1内审实施计划2培训计划3项目评审4年度检定计划5用章审批") |
| | | @ApiModelProperty(value = "数据类型1内审实施计划2培训计划3项目评审4年度检定计划5用章审批(申请)6用章审批(审批)") |
| | | private String type; |
| | | } |
| | |
| | | a.id AS dataId |
| | | FROM use_seal_apply a |
| | | WHERE a.del_flag = 0 |
| | | AND (a.apply_user_id = #{userId} or a.next_check = #{userId} ) |
| | | AND (a.apply_user_id = #{userId} ) |
| | | AND a.`status` = 1 and a.company_id = #{companyId} |
| | | UNION ALL |
| | | SELECT a.use_seal_cause AS title, |
| | | '6' AS type, |
| | | a.id AS dataId |
| | | FROM use_seal_apply a |
| | | WHERE a.del_flag = 0 |
| | | AND (a.next_check = #{userId} ) |
| | | AND a.`status` = 1 and a.company_id = #{companyId} |
| | | </select> |
| | | </mapper> |