| | |
|---|
| | | GROUP BY (caa.check_unit_id) |
|---|
| | | UNION ALL |
|---|
| | | SELECT count(id) as serviceTimes, sum(duration) as serviceTime, check_unit_id as unitId, community_id as |
|---|
| | | communityId, belong_to |
|---|
| | | communityId, belong_to,award |
|---|
| | | FROM( |
|---|
| | | SELECT caa.id, caa.duration, s.check_unit_id , cpcu.community_id , cpcu.belong_to,caa.pb_reward_integral as award |
|---|
| | | FROM com_act_activity caa |
|---|
| | |
|---|
| | | <select id="institutionalPartyMemberActAnalysis" |
|---|
| | | resultType="com.panzhihua.common.model.vos.neighbor.PartyMemberAnalysisVO"> |
|---|
| | | SELECT count(canc.solve_id) as serviceTimes,sum(canc.real_service_time) as serviceTime |
|---|
| | | ,cpcu.community_id as communityId,canc.solve_id as memberId,su.name as memberName,su.relation_name as belongUnit,ca.name as belongCommunity,cpcu.belong_to |
|---|
| | | ,cpcu.community_id as communityId,canc.solve_id as memberId,su.name as memberName,su.relation_name as belongUnit, |
|---|
| | | ca.name as belongCommunity,cpcu.belong_to |
|---|
| | | FROM `com_act_neighbor_circle` as canc |
|---|
| | | left join sys_user as su on canc.solve_id=su.user_id |
|---|
| | | left join com_pb_member as cpm on su.phone=cpm.phone |
|---|
| | |
|---|
| | | </select> |
|---|
| | | <select id="institutionalPartyMemberServiceAnalysisByServicesTimes" |
|---|
| | | resultType="com.panzhihua.common.model.vos.neighbor.PartyMemberAnalysisVO"> |
|---|
| | | SELECT count(caa.check_unit_id) as serviceTimes,sum(caa.duration) as serviceTime,caa.check_unit_id as unitId,caa.community_id as communityId,cpcu.belong_to |
|---|
| | | SELECT count(caa.check_unit_id) as serviceTimes,sum(caa.duration) as serviceTime,caa.check_unit_id as unitId, |
|---|
| | | caa.community_id as communityId,cpcu.belong_to |
|---|
| | | FROM com_act_activity as caa |
|---|
| | | left join com_pb_check_unit as cpcu on caa.check_unit_id=cpcu.id |
|---|
| | | where caa.check_unit_id<>'' |
|---|
