MongoDB多表关联查询

最新推荐文章于 2024-08-12 19:57:38 发布

JackRenEngineer

最新推荐文章于 2024-08-12 19:57:38 发布

阅读量3.1k

点赞数

文章标签： mongodb java

本文链接：https://blog.csdn.net/JackRen_Developer/article/details/56007025

版权

本文展示了如何在MongoDB中进行多表关联查询，包括使用$lookup、$unwind等聚合操作，查询涉及到chpz_order、chpz_car_requirement、chpz_requirement_match、chpz_car及chpz_user等多个集合，主要用于订单状态筛选和计数。

摘要由CSDN通过智能技术生成

<template id="chpz_order_searchOrderListByOrderState"><![CDATA[
		{
			$match: {
				requirement_type:"car",
				"$or" : [ { "from_user_id" : "${user_id}"} , { "shr_user_id" : "${user_id}"},{ "to_user_id" : "${user_id}"}],
				 #if(order_state =='order_state_create')
		 			order_state:"order_state_create",
		  		 #end
		  		 #if(order_state =='order_state_wait_transport')
		  		 	#if(user_type =='201' || user_type =='301'||user_type =='302')
		 				order_state:{$in:["order_state_wait_transport","order_state_create"]},
		  		 	#else
		  		 		order_state:"order_state_wait_transport",
		  		 	#end
		  		 #end
		  		 #if(order_state =='order_state_in_transport')
		 			order_state:"order_state_in_transport",
		  		 #end
				 #if(order_state =='order_state_finish')
		 			order_state:{$in:["order_state_received_end","order_state_already_evaluate","order_state_already_cancle"]}
		  		 #end
			}
		}
		--split--marker--
    	{
	      $sort: {
	        "create_time":-1
	      }
	    }
		--split--marker--
		{
			$skip: ${skip}
		}
		--split--marker--
		{
			$limit: ${limit}
		}
		--split--marker--
		{
			$lookup: {
			    "from" : "chpz_car_requirement",
			    "localField" : "requirement_id",
			    "foreignField" : "id",
			    "as" : "carRequirement"
			}
		}
		--split--marker--
		{
			$unwind: {
			    path : "$carRequirement",
			    preserveNullAndEmptyArrays : true
			}
		}
		--split--marker--
		{
			$lookup: {
			    "from" : "chpz_requirement_match",
			    "localField" : "requirement_match_