<?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.xiong.mendianfu.dao.DingDanDao">
<resultMap id="dingdanbean" type="com.xiong.mendianfu.bean.Dingdan">
<id property="dingdanid" column="dingdanid"></id>
<result property="dingdanjine" column="dingdanjine"></result>
<result property="dingdanzhuangtai" column="dingdanzhuangtai"></result>
<result property="dingdanshijian" column="dingdanshijian"></result>
<association property="mendian" javaType="com.xiong.mendianfu.bean.Mendian" >
<id property="mendianid" column="mendianid"></id>
<result property="biaoshi" column="biaoshi"></result>
<result property="mingcheng" column="mingcheng"></result>
<result property="dizhi" column="dizhi"></result>
<result property="dianhua" column="dianhua"></result>
<result property="adminopenid" column="adminopenid"></result>
</association>
</resultMap>
<select id="queryDingdan" parameterType="java.util.Map" resultMap="dingdanbean">
SELECT dingdanid,dingdanjine, dingdanzhuangtai,dingdanshijian,
b.biaoshi,b.mingcheng,b.dizhi,b.dianhua,b.adminopenid
FROM dingdan a
INNER JOIN mendian b ON a.mendianid = b.mendianid
<if test="biaoshi!=null and biaoshi !=''">
WHERE b.biaoshi LIKE CONCAT(CONCAT('%', #{keyword}, '%'))
</if>
<if test="mingcheng!=null and mingcheng !=''">
WHERE b.mingcheng LIKE CONCAT(CONCAT('%', #{keyword}, '%'))
</if>
LIMIT #{currentRow},#{pageSize}
</select>
<select id="getPageCount" resultType="java.util.Map" parameterType="java.util.Map">
SELECT COUNT(*) AS totalRow,CEIL(COUNT(*)/#{pageSize}) AS totalPage
FROM (SELECT dingdanid,dingdanjine, dingdanzhuangtai,dingdanshijian,
b.biaoshi,b.mingcheng,b.dizhi,b.dianhua,b.adminopenid
FROM dingdan a
INNER JOIN mendian b ON a.mendianid = b.mendianid
<if test="biaoshi!=null and biaoshi !=''">
WHERE b.biaoshi LIKE CONCAT( CONCAT('%', #{keyword}, '%'))
</if>
<if test="mingcheng!=null and mingcheng !=''">
WHERE b.mingcheng LIKE CONCAT(CONCAT('%', #{keyword}, '%'))
</if>
)
AS amendian
</select>
<select id="queryDingdanByqiye" resultType="java.util.Map" parameterType="java.util.Map">
SELECT SUM(a.dingdanjine) AS dingdansum , c.qiyeid AS qiyeid,c.mingcheng AS qiyemingcheng
FROM dingdan a LEFT JOIN mendian d ON d.mendianid=a.mendianid
LEFT JOIN qiye c ON c.qiyeid=d.qiyeid
WHERE a.dingdanzhuangtai='ZHIFU'
<if test="_parameter.containsKey('mingcheng')">
AND c.mingcheng
IN
<foreach collection="list" item="item" open="(" close=")" index="index" separator=",">
#{item}
</foreach>
</if>
<if test="_parameter.containsKey('year')">
AND a.dingdanshijian > date_sub(curdate(), INTERVAL 1 YEAR )
</if>
<if test="_parameter.containsKey('halfyear')">
AND a.dingdanshijian > date_sub(curdate(), INTERVAL 6 MONTH )
</if>
<if test="_parameter.containsKey('month')">
AND a.dingdanshijian > date_sub(curdate(), INTERVAL 1 MONTH )
</if>
<if test="_parameter.containsKey('week')">
AND a.dingdanshijian > date_sub(curdate(), INTERVAL 1 WEEK)
</if>
<if test="_parameter.containsKey('day')">
AND a.dingdanshijian > date_sub(curdate(), INTERVAL 1 DAY)
</if>
GROUP BY c.qiyeid
</select>
<select id=
mybatis传递map中含有list数据结构的处理整合springmvc
最新推荐文章于 2021-09-18 13:09:47 发布
本文介绍了如何在MyBatis与Spring整合的环境中,处理Map参数中包含List数据结构的问题。重点讲解配置文件的设置以及在实际操作中的注意事项。
摘要由CSDN通过智能技术生成