| | |
|---|
| | | <!--自定义分页数据查询--> |
|---|
| | | <select id="selectHouseholdPage" resultMap="householdPageAndLabelMap"> |
|---|
| | | select |
|---|
| | | jh.*, |
|---|
| | | 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.residential_status,jh.birthday,jh.id_card,jh.hkmt_pass,jh.passport, |
|---|
| | | ifnull(jh.gender,case when substring(jh.id_card,17,1)%2=1 then 1 else 0 end) as gender, |
|---|
| | | jh.ethnicity,jh.education,jh.hukou_registration,jh.work_status,employer, |
|---|
| | | jh.marital_status,jh.card_number,jh.other_contact,jh.current_address,jh.disability_cert, |
|---|
| | | jh.party_ember,jh.create_user,jh.create_time,jh.update_user,jh.update_time,jh.remark, |
|---|
| | | jhs.district_name aoiName, |
|---|
| | | concat(jhs.building," ",unit," ",room) as address, |
|---|
| | | jda.town_street_name as townStreetName,jda.nei_name as neiName |
|---|
