| | |
| | | @ApiModel(value = "ProcessReport对象", description = "检验报告发放登记表") |
| | | public class ProcessReport implements Serializable { |
| | | |
| | | @TableField(select = false,exist = false) |
| | | //导出序号 |
| | | private Integer indexs; |
| | | |
| | | @TableId(value = "id", type = IdType.AUTO) |
| | | private Integer id; |
| | |
| | | </if> |
| | | </select> |
| | | <select id="getIds" resultType="com.ruoyi.process.pojo.ProcessReport"> |
| | | select cpr.* , |
| | | select ROW_NUMBER() OVER (ORDER BY cpr.id) AS indexs, |
| | | cpr.* , |
| | | u1.name sendUserName |
| | | from cnas_process_report cpr |
| | | left join user u1 on send_user=u1.id |