a.id AS "id", a.pet_type AS "petType", a.pet_name AS "petName", a.pet_gender AS "petGender", a.pet_birthdate AS "petBirthdate", a.pet_color AS "petColor", a.pet_size AS "petSize", a.pet_hair AS "petHair", a.pet_owner AS "petOwner", a.pet_owner_mobile AS "petOwnerMobile", a.postal_province AS "postalProvince", a.postal_city AS "postalCity", a.postal_address AS "postalAddress", a.appraisal_province AS "appraisalProvince", a.appraisal_city AS "appraisalCity", a.appraisal_shop AS "appraisalShop", a.appraisal_result AS "appraisalResult", a.appraisal_reason AS "appraisalReason", a.appraisal AS "appraisal", a.appraisal_date AS "appraisalDate", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.del_flag AS "delFlag", a.identification_flag AS "identificationFlag", a.chip_type AS "chipType", a.front_pic AS "frontPic", a.side_pic AS "sidePic", a.back_pic AS "backPic", a.price AS "price", a.payment_state AS "paymentState", a.running_number AS "runningNumber", a.payment_time AS "paymentTime", a.identity_sticker AS "identitySticker", a.grade_sticker AS "gradeSticker", a.passport_no AS "passportNo", a.cab_register_code AS "cabRegisterCode", a.class_code AS "classCode", a.identity_print_time AS "identityPrintTime", a.grade_print_time AS "gradePrintTime" SELECT FROM new_pet_passport.companion_dog_appraisal a WHERE a.id = #{id} SELECT FROM new_pet_passport.companion_dog_appraisal a WHERE a.del_flag = '0' AND a.identification_flag = #{identificationFlag} AND a.pet_type = #{petType} SELECT FROM new_pet_passport.companion_dog_appraisal a WHERE a.passport_no = #{passportNo} ${sql} SELECT FROM new_pet_passport.companion_dog_appraisal a a.del_flag = #{DEL_FLAG_NORMAL} AND a.org_id =#{orgId} AND a.pet_owner = #{petOwner} AND a.pet_owner_mobile = #{petOwnerMobile} ORDER BY ${page.orderBy} ORDER BY a.create_date DESC SELECT FROM new_pet_passport.companion_dog_appraisal a a.del_flag = #{DEL_FLAG_NORMAL} AND a.org_id =#{orgId} ORDER BY ${page.orderBy} ORDER BY a.create_date DESC INSERT INTO new_pet_passport.companion_dog_appraisal( id, pet_type, pet_name, pet_gender, pet_birthdate, pet_color, pet_size, pet_hair, pet_owner, pet_owner_mobile, postal_province, postal_city, postal_address, appraisal_province, appraisal_city, appraisal_shop, appraisal_result, appraisal_reason, appraisal, appraisal_date, create_by, create_date, del_flag, identification_flag, chip_type, front_pic, side_pic, back_pic, price, running_number, payment_state, identity_sticker, grade_sticker, passport_no, cab_register_code, class_code, identity_print_time, grade_print_time, org_id ) VALUES ( #{id}, #{petType}, #{petName}, #{petGender}, #{petBirthdate}, #{petColor}, #{petSize}, #{petHair}, #{petOwner}, #{petOwnerMobile}, #{postalProvince}, #{postalCity}, #{postalAddress}, #{appraisalProvince}, #{appraisalCity}, #{appraisalShop}, #{appraisalResult}, #{appraisalReason}, #{appraisal}, #{appraisalDate}, #{createBy.id}, #{createDate}, #{delFlag}, #{identificationFlag}, #{chipType}, #{frontPic}, #{sidePic}, #{backPic}, #{price}, #{runningNumber}, "0", "0", "0", #{passportNo}, #{cabRegisterCode}, #{classCode}, #{identityPrintTime}, #{gradePrintTime}, #{orgId} ) UPDATE new_pet_passport.companion_dog_appraisal SET pet_type = #{petType}, pet_name = #{petName}, pet_gender = #{petGender}, pet_birthdate = #{petBirthdate}, pet_color = #{petColor}, pet_size = #{petSize}, pet_hair = #{petHair}, pet_owner = #{petOwner}, pet_owner_mobile = #{petOwnerMobile}, postal_province = #{postalProvince}, postal_city = #{postalCity}, postal_address = #{postalAddress}, appraisal_province = #{appraisalProvince}, appraisal_city = #{appraisalCity}, appraisal_shop = #{appraisalShop}, appraisal_result = #{appraisalResult}, appraisal_reason = #{appraisalReason}, appraisal = #{appraisal}, appraisal_date =#{appraisalDate}, update_by = #{updateBy.id}, update_date = #{updateDate}, identification_flag = #{identificationFlag}, chip_type = #{chipType}, front_pic = #{frontPic}, side_pic = #{sidePic}, running_number =#{runningNumber}, back_pic = #{backPic}, passport_no = #{passportNo}, cab_register_code = #{cabRegisterCode}, class_code = #{classCode}, identity_sticker = #{identitySticker}, grade_sticker = #{gradeSticker}, identity_print_time = #{identityPrintTime}, grade_print_time = #{gradePrintTime} WHERE id = #{id} UPDATE new_pet_passport.companion_dog_appraisal SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} SELECT * FROM `cyber-form-business`.cat AS c WHERE c.del_flag ='0' and c.identification_flag=#{identificationFlag} SELECT * FROM `cyber-form-business`.cat_birth_certificate AS c WHERE c.del_flag ='0' and c.identification_flag=#{identificationFlag}