a.id AS "id", a.member_code AS "memberCode", m.name AS "memberName", a.serial_num AS "serialNum", a.ranking_score AS "rankingScore", a.year AS "year", a.type AS "type", a.quarter AS "quarter", a.month AS "month", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag", a.half AS "half" LEFT JOIN sys_member m on a.member_code = m.member_code SELECT FROM referee_ranking a WHERE a.id = #{id} SELECT FROM referee_ranking a a.del_flag = #{DEL_FLAG_NORMAL} AND a.year = #{year} AND a.type = #{type} AND a.quarter = #{quarter} AND a.month = #{month} AND a.member_code = #{memberCode} AND a.half = #{half} ORDER BY a.ranking_score DESC,a.create_date DESC SELECT FROM referee_ranking a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY a.create_date DESC ,a.ranking_score DESC INSERT INTO referee_ranking( id, member_code, member_name, serial_num, ranking_score, year, type, quarter, month, create_by, create_date, update_by, update_date, remarks, del_flag, half ) VALUES ( #{id}, #{memberCode}, #{memberName}, #{serialNum}, #{rankingScore}, #{year}, #{type}, #{quarter}, #{month}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{half} ) UPDATE referee_ranking SET member_code = #{memberCode}, member_name = #{memberName}, serial_num = #{serialNum}, ranking_score = #{rankingScore}, year = #{year}, type = #{type}, quarter = #{quarter}, month = #{month}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, status = #{status}, half = #{half} WHERE id = #{id} UPDATE referee_ranking SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} DELETE FROM referee_ranking where serial_num = #{serialNum} INSERT INTO referee_ranking ( id, member_code, serial_num, ranking_score, year, type, quarter, month, remarks, del_flag, create_date, half ) VALUES ( REPLACE(UUID(),'-',''), #{data.memberCode}, #{data.serialNum}, #{data.rankingScore}, #{data.year}, #{data.type}, #{data.quarter}, #{data.month}, #{data.remarks}, #{data.delFlag}, #{data.createDate}, #{data.half} )