daxueshengzaixianzufangpingtai/src/main/resources/mapper/CommonDao.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.dao.CommonDao">
	<select id="pieSum" 		resultType="map">
		<!--		<if test="条件自己写"></if><where></where>-->
		select
		d.index_name 						as name, 		<!-- 字典表						-->
		a.shangpin_order_types 				as groupColumn, <!-- 这一列页面无用,用于排查问题	-->
		sum(a.shangpin_order_true_price) 	as value
		from shangpin_order a
		LEFT JOIN dictionary d ON a.shangpin_order_types=d.code_index d.dic_code= 'shangpin_order_types' <!-- 字典表-->
		<if test="riqi != null and riqi != ''">
			AND date_format(a.insert_time, "%Y-%m") = #{riqi}  <!-- "%Y-%m-%d"	-->
		</if>


		GROUP BY a.shangpin_order_types
	</select>
	<select id="pieCount" 		resultType="map">
		select
		d.index_name 						as name, <!-- 字典表 -->
		a.shangpin_order_types 				as groupColumn, <!-- 这一列页面无用,用于排查问题 -->
		count(*) 	as value
		from shangpin_order a
		LEFT JOIN dictionary d ON a.shangpin_order_types=d.code_index where d.dic_code= 'shangpin_order_types' <!-- 字典表 -->
		<if test="riqi != null and riqi != ''">
			AND date_format(a.insert_time, "%Y-%m") = #{riqi} <!-- "%Y-%m-%d" -->
		</if>
		GROUP BY a.shangpin_order_types
	</select>
	<select id="barSumOne" 		resultType="map">
		select
		d.index_name 						as name, <!-- 字典表 -->
		a.shangpin_order_types 				as groupColumn, <!-- 这一列页面无用,用于排查问题 -->
		sum(a.shangpin_order_true_price) 	as value
		from shangpin_order a
		LEFT JOIN dictionary d ON a.shangpin_order_types=d.code_index where d.dic_code= 'shangpin_order_types' -- 字典表 -->
		<if test="riqi != null and riqi != ''">
			AND date_format(a.insert_time, "%Y-%m") = #{riqi} <!-- "%Y-%m-%d" -->
		</if>
		GROUP BY a.shangpin_order_types

		<!-- 考试排名统计 -->
		<!-- select
		yonghu.yonghu_name 	as name,
		d.total_score 		as value
		from examrecord d
		left join yonghu on yonghu.id=d.yonghu_id
		where d.exampaper_id=#{exampaperId}
		order by value desc -->
	</select>
	<select id="barCountOne" 	resultType="map">
		select
		d.index_name 						as name, <!-- 字典表 -->
		a.shangpin_order_types 				as groupColumn, <!-- 这一列页面无用,用于排查问题 -->
		count(*) 	as value
		from shangpin_order a
		LEFT JOIN dictionary d ON a.shangpin_order_types=d.code_index where d.dic_code= 'shangpin_order_types' <!-- 字典表 -->
		<if test="riqi != null and riqi != ''">