| | |
| | | <result column="name" property="name"/> |
| | | <result column="phone_number" property="phoneNumber"/> |
| | | <result column="associated_user_id" property="associatedUserId"/> |
| | | <result column="associated_user_name" property="associatedUserName"/> |
| | | <result column="relationship" property="relationship"/> |
| | | <!-- <result column="primary_contact" property="primaryContact"/>--> |
| | | <result column="residential_status" property="residentialStatus"/> |
| | | <result column="gender" property="gender"/> |
| | | <result column="birthday" property="birthday"/> |
| | | <result column="id_card" property="idCard"/> |
| | | <result column="hkmt_pass" property="hkmtPass"/> |
| | | <result column="passport" property="passport"/> |
| | | <result column="ethnicity" property="ethnicity"/> |
| | | <result column="education" property="education"/> |
| | | <result column="hukou_registration" property="hukouRegistration"/> |
| | |
| | | phone_number, |
| | | associated_user_id, |
| | | role_type, |
| | | associated_user_name, |
| | | relationship, |
| | | is_primary_contact, |
| | | residential_status, |
| | |
| | | jh.phone_number, |
| | | jh.associated_user_id, |
| | | jh.role_type, |
| | | jh.associated_user_name, |
| | | jh.relationship, |
| | | jh.is_primary_contact, |
| | | jh.residential_status, |
| | |
| | | jh.phone_number, |
| | | jh.associated_user_id, |
| | | jh.role_type, |
| | | jh.associated_user_name, |
| | | jh.relationship, |
| | | jh.is_primary_contact, |
| | | jh.residential_status, |
| | |
| | | <select id="getHouseholdListById" resultMap="householdAndLabelMap"> |
| | | select |
| | | jh.id,jh.house_code,jh.name,jh.phone_number,jh.associated_user_id, |
| | | jh.role_type,jh.associated_user_name,jh.relationship,jh.is_primary_contact, |
| | | jh.role_type,jh.relationship,jh.is_primary_contact, |
| | | jh.residential_status,jh.gender,jh.birthday,jh.id_card, |
| | | jh.card_type,jh.card_no,jh.hkmt_pass,jh.passport, |
| | | jh.ethnicity,jh.education,jh.resident_type, |
| | |
| | | jh.phone_number, |
| | | jh.associated_user_id, |
| | | jh.role_type, |
| | | jh.associated_user_name, |
| | | jh.relationship, |
| | | jh.is_primary_contact, |
| | | jh.residential_status, |
| | |
| | | jh.phone_number, |
| | | jh.associated_user_id, |
| | | jh.role_type, |
| | | jh.associated_user_name, |
| | | jh.relationship, |
| | | jh.is_primary_contact, |
| | | jh.residential_status, |