需要根据传值来判断是否加入到where条件里面，如：
$where = 'p.shopId=g.shopId ';
if($shopName!=''){
$where=" and (p.shopName like '%".$shopName."%' or p.shopSn like '%".$shopName."%')";
}
if($goodsName!=''){
$where.=" and (g.goodsName like '%".$goodsName."%' or g.goodsSn like '%".$goodsName."%')";
}
if($siteId=='' && $areaId !=''){
$where.=" and (gp.siteId IN (".$sids.") )";
}
if($siteId!=''){
$where.=" and (gp.siteId =".$siteId." )";
}
$rs=$this->alias('gp')->field('gp.*,g.goodsName,g.goodsImg,o.orderNo,u.loginName')
->join('__GOODS__ g ','gp.goodsId=g.goodsId','left')
->join('__ORDERS__ o','gp.orderId=o.orderId','left')
->join('__USERS__ u','u.userId=gp.userId','left')
->join('__SHOPS__ p','p.shopId=gp.shopId','left')
->where($where)
->order('id desc')
->paginate(input('pagesize/d'))->toArray();
return $rs;
这种查询怎么使用TP5，TP3的话我查到可以用where['_logic_']
求大神指点