| | |
|---|
| | | <select id="appFindListByPage" parameterType="com.panzhihua.common.model.query.visit.EventTasksQuery" |
|---|
| | | resultType="com.panzhihua.common.model.vos.visit.EventVisitingTasksVO"> |
|---|
| | | select vt.id,vt.create_at,vt.create_by,vt.visiter_id,vt.visiter_name,vt.visiter_tele,vt.visiter_sex |
|---|
| | | ,vt.visiter_address,vt.dell_user_id,vt.dell_user_name,vt.submit_date,vt.cancel_time,vt.event_status,p.nation,p.political_outlook |
|---|
| | | ,vt.visiter_address,vt.dell_user_id,vt.dell_user_name,vt.submit_date,vt.cancel_time,vt.event_status,p.nation,p.political_outlook, |
|---|
| | | TIMESTAMPDIFF(YEAR, p.birthday, CURDATE()) AS age,p.label,u.name as creator,p.nation_code,p.card_no as cardNoStr |
|---|
| | | FROM event_visiting_tasks vt |
|---|
| | | LEFT JOIN com_mng_population p ON p.id = vt.visiter_id |
|---|
