a.id AS "id", a.price AS "price", a.city AS "city", a.mobile AS "mobile", a.linkman AS "linkman", a.life_pic AS "lifePic", a.state AS "state", a.consign AS "consign", a.add_time AS "addTime", 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.appraisal_id AS "appraisalId", c.pet_type AS "petType", c.pet_owner AS "petOwner", c.pet_owner_mobile AS "petOwnerMobile", c.pet_name AS "petName", c.pet_birthdate AS "petBirthdate", c.identification_flag AS "identificationFlag" LEFT JOIN new_pet_passport.companion_dog_appraisal AS c on a.appraisal_id = c.id SELECT FROM new_pet_passport.fsb_dog_grounding a WHERE a.id = #{id} SELECT FROM new_pet_passport.fsb_dog_grounding a a.del_flag = #{DEL_FLAG_NORMAL} AND a.org_id =#{orgId} AND (c.pet_owner = #{petOwnerMobile} OR c.pet_owner_mobile = #{petOwnerMobile} OR c.pet_name = #{petOwnerMobile}) AND a.appraisal_id =#{appraisalId} ORDER BY ${page.orderBy} ORDER BY a.create_date DESC SELECT FROM new_pet_passport.fsb_dog_grounding a a.del_flag = #{DEL_FLAG_NORMAL} AND a.org_id =#{orgId} ORDER BY ${page.orderBy} ORDER BY a.create_date DESC SELECT FROM new_pet_passport.fsb_dog_grounding a WHERE a.del_flag = '0' AND c.identification_flag = #{identificationFlag} LIMIT 1; INSERT INTO new_pet_passport.fsb_dog_grounding( id, price, city, mobile, linkman, life_pic, state, consign, add_time, create_by, create_date, del_flag, appraisal_id, org_id ) VALUES ( #{id}, #{price}, #{city}, #{mobile}, #{linkman}, #{lifePic}, '0', #{consign}, #{addTime}, #{createBy.id}, #{createDate}, #{delFlag}, #{appraisalId}, #{orgId} ) UPDATE new_pet_passport.fsb_dog_grounding SET price = #{price}, city = #{city}, mobile = #{mobile}, linkman = #{linkman}, life_pic = #{lifePic}, consign = #{consign}, state =#{state}, add_time =#{addTime}, update_by = #{updateBy.id}, update_date = #{updateDate}, appraisal_id = #{appraisalId} WHERE id = #{id} UPDATE new_pet_passport.fsb_dog_grounding SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}