java/zhihuishenqu.git

			@@ -34,7 +34,7 @@
			su.tags,
			caar.is_volunteer,
			t.duration,
			CASE WHEN t.type = 1 THEN '志愿者' WHEN t.type=2 THEN '居民' ELSE '党员' END identity
			CASE WHEN t.type = 1 and caar.is_volunteer = 1 THEN '志愿者' WHEN t.type = 1 and caar.is_volunteer = 0 THEN '居民' WHEN t.type=2 THEN '居民' ELSE '党员' END identity

			FROM
			com_act_act_regist caar

			@@ -76,7 +76,7 @@
			</select>
			<select id="listActivitySign" resultType="com.panzhihua.common.model.vos.community.ActivitySignVO">
			SELECT u.user_id id, u.image_url, u.name, u.nick_name,
			CASE WHEN t.type = 1 THEN '志愿者' WHEN t.type=2 THEN '居民' ELSE '党员' END identity,
			CASE WHEN t.type = 1 and caar.is_volunteer = 1 THEN '志愿者' WHEN t.type = 1 and caar.is_volunteer = 0 THEN '居民' WHEN t.type=2 THEN '居民' ELSE '党员' END identity,
			u.phone, u.tags, a.create_at, a.is_volunteer, a.status , a.times,
			a.reason, IF(r.times IS NULL, 0, r.award * r.times) AS award, t.limit
			FROM com_act_act_sign a

	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActActRegistMapper.xml	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActActSignMapper.xml	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史