1.UNION查询没问题
分表以后会做连表查询,如果只是简单的使用yii union,并不能实现分页效果,数据会在每页都全部显示出来,要想实现union 分页 ,必须再进行一次整体查询才可以,图中框选的就是实现分页的关键代码。
2.多字段排序:
$all = Questions::find()->orderBy('createTime desc')->asArray()->all(); $all = Questions::find()->orderBy(['createTime' => SORT_ASC,'id' => SORT_DESC])->asArray()->all();//字段值相同,遵循第二个值排序
3.union查询查对应的sql:
$model = billing::find()->where(['memberId' => $result->memberId])->select(['id',$col2,'money' ,$col1,'status',$col3,$col4,$col5,'createTime']);
$withdraw = BillingLog::find()->where(['memberId' => $result->memberId])->select(['id',$col2,'money' ,$col1,'status',$col3,$col4,$col5,'createTime']);
$model->union($withdraw,true);
$model2 = (new Query())->from($model);
$model2->offset(0)->limit(5);
$model2->orderBy('createTime desc');
// var_dump($model2->count());exit; //条数
// echo $model2->createCommand()->getRawSql();die;//查出对应sql在navicate生成对应的数据