INSERT INTO dog_pedigree_certified_export (
	id,
	dog_id,
	pedigree_certified,
	export_destination,
	exporter,
	payment_member_code,
	operator,
	price,
	review_state,
	review_time,
	review_remarks,
	running_number,
	payment_state,
	payment_time,
	process_time,
	process_state,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	dogid,
	zsid,
	export_country,
	export_user,
	pay_ckuid,
	operater,
	order_price,
	info_Confirm,
	info_Confirm_time,
	info_Confirm_why,
	running_number,
	payout,
	payout_time,
	operate_time,
	operate,
	1 create_by,
	add_time,
	1 update_by,
	edit_time,
	'' remarks,
	0 del_flag
FROM
	dbo.dog_ZsidExport


update dog_pedigree_certified_export set payment_state = 2 where payment_state = 1;
update dog_pedigree_certified_export set payment_state = 1 where payment_state = 0;

//把虽然标记为未处理，但实际已处理的记录改为已处理
UPDATE dog_pedigree_certified_change
SET process_state = 1
WHERE
	id IN (
		SELECT
			a.id
		FROM
			(
				SELECT
					id
				FROM
					dog_pedigree_certified_change
				WHERE
					overseas_pedigree_certified IN (
						SELECT
							pedigree_certified_en
						FROM
							dog
						WHERE
							pedigree_certified_en IN (
								SELECT
									overseas_pedigree_certified
								FROM
									dog_pedigree_certified_change
								WHERE
									review_state = 1
								AND (
									process_state = 0
									OR process_state IS NULL
								)
							)
					)
			) a
	)