tp5查询or and联合whereor

$queryData = Db::connect(数据库)->table(表)->where(function($query)use($userId,$v) {
                    $query->where([goodId=>$v[wxId],userId=>$userId,status=>1]);
                })->whereor(function($query)use($userId,$v){
                    $query->where([goodId=>$v[wxId],userId=>$userId,status=>2]);
                })->field(wxId,字段)->find();

tp5 whereor多条件查询。记录一下。其中use中匿名函数传递参数。

$list = Db::table(page)->select();
$list_length = count($list);
$this->assign(list_length,$list_length);

多个活动 合并起来给前端，老板天天加东西。。。

$goodInfo=Db::connect(数据库)->query(SELECT o.userId, o.createAt, u.avatUrl, u.nickName
FROM 表1 o
	LEFT JOIN 表0 u ON o.userId = u.wxId
WHERE o.payStatus = 已付款
	AND o.directorId = .$userId.
UNION ALL
SELECT o.userId, o.createAt, u.avatUrl, u.nickName
FROM 表2 o
	LEFT JOIN 表0 u ON o.userId = u.wxId
WHERE o.memCashId = .$memId[wxId].);

$page=($page-1)*20;



        $goodInfo=Db::connect(数据库)->query("SELECT *
FROM (
	SELECT o.preGoodNum, o.goodNum, o.userId, o.createAt AS payTime, u.avatUrl
		, u.nickName, o.goodTitle
	FROM 表1 o
		LEFT JOIN 表0 u ON o.userId = u.wxId
	WHERE o.payStatus = 已付款
		AND o.directorId = Id
	ORDER BY o.createAt DESC
) a
UNION ALL
SELECT *
FROM (
	SELECT o.sumTimes AS preGoodNum, o.remainTimes AS goodNum, o.userId, o.createAt AS payTime, u.avatUrl
		, u.nickName, o.describe AS goodTitle
	FROM 表2 o
		LEFT JOIN 表0 u ON o.userId = u.wxId
	WHERE o.memCashId = wxId
	ORDER BY o.createAt DESC
) b
ORDER BY payTime DESC
LIMIT $page, 20");