a.id AS "id", a.club_code AS "clubCode", a.dog_breed AS "dogBreed", a.dog_color AS "dogColor", a.dog_gender AS "dogGender", a.dog_birth AS "dogBirth", a.member_code AS "memberCode", a.member_name AS "memberName", 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.remarks AS "remarks", a.running_number AS "runningNumber", a.payment_state AS "paymentState", a.payment_time AS "paymentTime", a.review_state AS "reviewState", a.dog_breed_cn AS "dogBreedCn", a.dog_color_cn AS "dogColorCn", a.dog_name AS "dogName", a.dog_nose AS "dogNose", a.chip_no AS "chipNo", a.passport_no AS "passportNo", a.appraisal_no AS "appraisalNo", a.print_status AS "printStatus", a.review_remarks AS "reviewRemarks", a.resolve_status AS "resolveStatus", a.appraisal_member AS "appraisalMember", o.name AS "orgName" LEFT JOIN sys_org o ON o.member_code = a.club_code SELECT FROM dog_video_appraisal a WHERE a.id = #{id} SELECT FROM dog_video_appraisal a WHERE a.chip_no = #{identificationFlag} SELECT FROM dog_video_appraisal a a.del_flag = #{DEL_FLAG_NORMAL} AND a.id = #{id} AND a.club_code = #{clubCode} AND a.review_state = #{reviewState} AND (o.name like concat('%',#{orgName},'%') OR o.member_code like concat('%',#{orgName},'%')) AND a.member_code = #{memberCode} AND (chip_no = #{keyword} OR passport_no = #{keyword}) AND chip_no = #{chipNo} AND ( a.member_code = #{memberInfo} OR a.member_name = #{memberInfo} ) AND dog_breed = #{dogBreed} AND payment_state = #{paymentState} AND date_format(a.create_date, '%Y-%m-%d') = ]]> date_format(#{beginCreateDate}, '%Y-%m-%d') AND date_format(a.create_date, '%Y-%m-%d') date_format(#{endCreateDate}, '%Y-%m-%d') AND (chip_no IS NOT NULL OR passport_no IS NOT NULL) AND id not in (select video_appraisal_id from dog_appraisal where video_appraisal_id is not null) ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_video_appraisal a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog_video_appraisal( id, club_code, dog_breed, dog_breed_cn, dog_color, dog_color_cn, dog_gender, dog_birth, member_code, member_name, create_by, create_date, update_by, update_date, del_flag, remarks, running_number, payment_state, payment_time, review_state, dog_name, dog_nose, chip_no, passport_no, appraisal_no, print_status, review_remarks, resolve_status, appraisal_member ) VALUES ( #{id}, #{clubCode}, #{dogBreed}, #{dogBreedCn}, #{dogColor}, #{dogColorCn}, #{dogGender}, #{dogBirth}, #{memberCode}, #{memberName}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{delFlag}, #{remarks}, #{runningNumber}, #{paymentState}, #{paymentTime}, #{reviewState}, #{dogName}, #{dogNose}, #{chipNo}, #{passportNo}, #{appraisalNo}, #{printStatus}, #{reviewRemarks}, #{resolveStatus}, #{appraisalMember} ) UPDATE dog_video_appraisal SET club_code = #{clubCode}, dog_breed = #{dogBreed}, dog_breed_cn = #{dogBreedCn}, dog_color = #{dogColor}, dog_color_cn = #{dogColorCn}, dog_gender = #{dogGender}, dog_birth = #{dogBirth}, member_code = #{memberCode}, member_name = #{memberName}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, running_number = #{runningNumber}, payment_state = #{paymentState}, payment_time = #{paymentTime}, review_state = #{reviewState}, dog_name = #{dogName}, dog_nose = #{dogNose}, chip_no = #{chipNo}, passport_no = #{passportNo}, appraisal_no = #{appraisalNo}, print_status = #{printStatus}, review_remarks = #{reviewRemarks}, resolve_status = #{resolveStatus}, appraisal_member = #{appraisalMember} WHERE id = #{id} UPDATE dog_video_appraisal SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} SELECT FROM dog_video_appraisal a a.del_flag = #{DEL_FLAG_NORMAL} AND a.club_code = #{clubCode} AND a.id = #{id} AND a.running_number=#{runningNumber} AND a.chip_no=#{chipNo} update dog_video_appraisal set review_state ='4' , review_remarks=#{vo.reviewRemarks}, update_date=#{vo.updateDate}, update_by=#{vo.updateBy.id} where id in #{item} update dog_video_appraisal set resolve_status = "1" where id = #{vo.id} update dog_video_appraisal set resolve_status = "2" where id = #{id} update dog_video_appraisal set passport_no = #{passportNo}, chip_no = #{chipNo}, resolve_status = #{resolveStatus} where id = #{id}