laravel MySQL union all 查询分页

本文主要是介绍laravel MySQL union all 查询分页，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

直接上代码,有需要可以做参考

public function getOldUserQipuYearPage($map,$field,$map1,$field1,$year,$perpage=7)
{
    if(!$year){
        $year = date('Y');
    }
    $sql1 = DB::connection('mysqlutf8')
        ->table('kago.userclass_'.$year.' as a')
        ->leftJoin('kago.classitems as b','a.itemid','b.id')
        ->where($map)
        ->select($field);
    $query = DB::connection('mysqlutf8')
        ->table('kago.userclass_'.($year-1).' as c')
        ->leftJoin('kago.classitems as b','c.itemid','b.id')
        ->where($map1)
        ->select($field1)->unionAll($sql1);
    $querySql = $query->toSql();
    $result = DB::connection('mysqlutf8')
        ->table(DB::raw("($querySql) as d"))->mergeBindings($query)
        ->orderByDesc('d.f_time')->paginate($perpage);

    return $result;
}

这篇关于laravel MySQL union all 查询分页的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！