QueryException in Connection.php line 729:

SQLSTATE[]: Cardinality violation: 1222 The used SELECT statements have a different number of columns (SQL: (select count(*) as aggregate from (select * from `orders` where (`status` = completed and `refund_status` in (refunded, not_apply)) or `refund_status` = refunded) as orders left join `users` on `users`.`id` = `orders`.`user_id` left join `order_products` on `order_products`.`order_id` = `orders`.`id` where exists (select 1 from `order_products` where exists (select 1 from `products` where products.id = order_products.product_id) and order_products.order_id = orders.id) and exists (select ....

       // 处理分页问题

        $page = Input::get('page', 1);

       // Number of items per page

       perPage = 5;

       // Start displaying items from this number;

       $offSet = ($page * $perPage) - $perPage;

       // Get only the items you need using array_slice (only get 10 items since that's what you need)

       $itemsForCurrentPage = array_slice($report_infos, $offSet, $perPage, true);

        // Return the paginator with only 10 items but with the count of all items and set the it on the correct page

       $report_infos = new LengthAwarePaginator($itemsForCurrentPage, count($report_infos), $perPage, $page, ['path' => request()->url(), 'query' => request()->query()]);