| | |
|---|
| | | select |
|---|
| | | m.id, m.org_id, m.name, m.id_card, m.photo_path, m.join_time, m.employment_time, m.audit_result, m.create_at, m.update_at, |
|---|
| | | m.community_id, u.user_id, m.refuse_reason, m.phone, m.type, m.position, m.check_unit_id, m.function, m.specialty_category, |
|---|
| | | canct.name as specialty_name, m.position_two, IFNULL(m.org_Name,cpo.`name`) as orgName,cpcu.name as checkUnitName,t2.partyTime,t2.partyInterval, |
|---|
| | | m.specialty_name, m.position_two, IFNULL(m.org_Name,cpo.`name`) as orgName,cpcu.name as checkUnitName,t2.partyTime,t2.partyInterval, |
|---|
| | | TIMESTAMPDIFF( |
|---|
| | | YEAR, |
|---|
| | | m.employment_time, |
|---|
| | |
|---|
| | | LEFT JOIN sys_user u ON m.id_card = u.id_card and u.type = 1 |
|---|
| | | LEFT JOIN com_pb_org as cpo on cpo.id = m.org_id |
|---|
| | | LEFT JOIN com_pb_check_unit as cpcu ON m.check_unit_id = cpcu.id |
|---|
| | | LEFT JOIN com_act_neighbor_circle_topic canct on m.specialty_category = canct.id |
|---|
| | | LEFT JOIN (select t1.user_id,sum(t.duration) as partyTime,sum(t.reward_integral) as partyInterval from com_act_activity t LEFT JOIN com_act_act_regist t1 on t.id = t1.activity_id where t.type = 3 |
|---|
| | | GROUP BY t1.user_id ) t2 on u.user_id = t2.user_id |
|---|
| | | where m.audit_result = 1 |
|---|
