mapping select 多条件查询遍历查询

比眉伴天荒 2022-05-11 16:16 208阅读 0赞

<select id="queryOrderHasStudent" parameterType="com.zichen.xhkq.pojo.Order" resultType="com.zichen.xhkq.pojo.Order">
     	SELECT DISTINCT os.`xsxm`,os.`xssfz`,os.`schoolName`,os.`ddzt` FROM(SELECT * FROM `order`  
    		WHERE `jtbs`=1 
    		AND `xssfz`IN 
    		<foreach item="xssfz" collection="stuIdCardList" open="(" separator="," close=")">
    			#{xssfz}
    		</foreach>
    		AND `schoolId`=#{schoolId}
    		AND `ddzt`=#{ddzt}
    	<if test="starttime != null and !''.equals(starttime) ">
    		AND `cjsj` BETWEEN #{starttime} AND NOW()
    	</if>
    	)os
     </select>
     
     
     <select id="queryOrder" parameterType="com.zichen.xhkq.pojo.Order" resultType="com.zichen.xhkq.pojo.Order">
     	SELECT * FROM `order`  
    		WHERE `jtbs`=1 
    		AND `xssfz`IN 
    		<foreach item="xssfz" collection="stuIdCardList" open="(" separator="," close=")">
    			#{xssfz}
    		</foreach>
    		AND `schoolId`=#{schoolId}
    		AND `ddzt`=#{ddzt}
    	<if test="starttime != null and !''.equals(starttime)">
    		AND `cjsj` BETWEEN #{starttime} AND NOW()
    	</if>
     </select>
     
     
     <select id="findWhichStudent" parameterType="java.util.List" resultType="com.zichen.xhkq.pojo.Order">
     	SELECT DISTINCT `xssfz` FROM `order` WHERE 1=1
    	 	<if test="ddbhmxlist.size != 0">
    	 		AND `ddbhmx` in
    		 	<foreach item="ddbhmx" collection="ddbhmxlist" open="(" separator="," close=")">  
    		        #{ddbhmx}
    		 	</foreach> 
    	 	</if>
     </select>
     
     
     <select id="findOrder" parameterType="java.util.List" resultType="com.zichen.xhkq.pojo.Order">
     	SELECT * FROM `order` WHERE 1=1
    	 	<if test="ddbhmxlist.size != 0">
    	 		AND `ddbhmx` in
    		 	<foreach item="ddbhmx" collection="ddbhmxlist" open="(" separator="," close=")">  
    		        #{ddbhmx}
    		 	</foreach> 
    	 	</if>
     </select> 
     
      <select id="findIsPay" parameterType="java.util.List" resultType="com.zichen.xhkq.pojo.Order">
     	SELECT DISTINCT `ddzt` FROM `order` WHERE 1=1
    	 	<if test="ddbhmxlist.size != 0">
    	 		AND `ddbhmx` in
    		 	<foreach item="ddbhmx" collection="ddbhmxlist" open="(" separator="," close=")">  
    		        #{ddbhmx}
    		 	</foreach> 
    	 	</if>
     </select> 
     
     <select id="findOrderSize" parameterType="java.util.List" resultType="com.zichen.xhkq.pojo.Order">
     	SELECT DISTINCT `ddbh` FROM `order` WHERE `ddbh` IS NOT NULL
    	 	<if test="ddbhmxlist.size != 0">
    	 		AND `ddbhmx` in
    		 	<foreach item="ddbhmx" collection="ddbhmxlist" open="(" separator="," close=")">  
    		        #{ddbhmx}
    		 	</foreach> 
    	 	</if>
     </select>