| | |
| | | @TableField("type") |
| | | private Integer type; |
| | | |
| | | @ApiModelProperty(value = "项目ID") |
| | | @TableField("item_id") |
| | | private Integer itemId; |
| | | |
| | | @ApiModelProperty(value = "文件名称") |
| | | @TableField("file_name") |
| | | private String fileName; |
| | |
| | | pi.`create_by`, |
| | | pi.`create_time`, |
| | | pi.`update_by`, |
| | | pi.`update_time` |
| | | pi.`update_time`, |
| | | pi.item_id |
| | | FROM |
| | | `process_inspection` pi |
| | | LEFT JOIN sys_company sc ON pi.company_id = sc.id |
| | |
| | | <if test="templateType!=null"> |
| | | and pi.type = #{templateType} |
| | | </if> |
| | | <if test="itemId!=null"> |
| | | and pi.item_id = #{itemId} |
| | | </if> |
| | | |
| | | </select> |
| | | </mapper> |