a.id AS "id", a.name AS "name", a.name_en AS "nameEn", a.certificate_type AS "certificateType", a.judge_certificate AS "judgeCertificate", a.visible_flag AS "visibleFlag", a.sign_date AS "signDate", a.end_date AS "endDate", a.dog_breed_code AS "dogBreedCode", a.dog_breed_name AS "dogBreedName", a.grooming_dog_group AS "groomingDogGroup", a.sort AS "sort", 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.expiration_date_visible_flag AS "expirationDateVisibleFlag" SELECT FROM show_judge_certificate a WHERE a.id = #{id} SELECT FROM show_judge_certificate a a.del_flag = #{DEL_FLAG_NORMAL} AND a.name = #{name} AND a.name_en = #{nameEn} AND a.certificate_type = #{certificateType} AND a.judge_certificate = #{judgeCertificate} AND a.visible_flag = #{visibleFlag} AND a.sign_date DATE_FORMAT(NOW(),'%y-%m-%d') AND a.end_date = ]]> DATE_FORMAT(NOW(),'%y-%m-%d') ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM show_judge_certificate a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO show_judge_certificate( id, name, name_en, certificate_type, judge_certificate, grooming_dog_group, visible_flag, sign_date, end_date, dog_breed_code, dog_breed_name, sort, create_by, create_date, update_by, update_date, remarks, del_flag, expiration_date_visible_flag ) VALUES ( #{id}, #{name}, #{nameEn}, #{certificateType}, #{judgeCertificate}, #{groomingDogGroup}, #{visibleFlag}, #{signDate}, #{endDate}, #{dogBreedCode}, #{dogBreedName}, #{sort}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{expirationDateVisibleFlag} ) UPDATE show_judge_certificate SET name = #{name}, name_en = #{nameEn}, certificate_type = #{certificateType}, judge_certificate = #{judgeCertificate}, grooming_dog_group = #{groomingDogGroup}, visible_flag = #{visibleFlag}, sign_date = #{signDate}, end_date = #{endDate}, dog_breed_code = #{dogBreedCode}, dog_breed_name = #{dogBreedName}, sort = #{sort}, update_by = #{updateBy.id}, remarks = #{remarks}, update_date = #{updateDate}, expiration_date_visible_flag = #{expirationDateVisibleFlag} WHERE id = #{id} UPDATE show_judge_certificate SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} select from show_judge_certificate a where a.name = #{name} and a.certificate_type = #{certificateType}