Laravel-4 Pagination in Query Builder

Question

How to enable pagination in laravel-4.1 when using the query builder.

Here is my function from the model.

public static function getTransactions( $accountCode ) {
        $accountId = Account::getAccountId( $accountCode );
        $object = DB::table('transactions')
            ->orderBy('transactionId', 'ASC')
            ->where('fkAccountId', $accountId)
            ->where('fkUserId', Auth::user()->userId);
            ->get();

        return $object;
    }

Answer 1

public static function getTransactions( $accountCode ) {
        $accountId = Account::getAccountId( $accountCode );
        $object = DB::table('transactions')
            ->orderBy('transactionId', 'ASC')
            ->where('fkAccountId', $accountId)
            ->where('fkUserId', Auth::user()->userId);
            ->paginate(10);

        return $object;
    }

and

echo $object->links(); //links

http://laravel.com/docs/pagination#usage

Answer 2

   public static function getTransactions( $accountCode ) {
        $accountId = Account::getAccountId( $accountCode );
        $object = DB::table('transactions')
            ->orderBy('transactionId', 'ASC')
            ->where('fkAccountId', $accountId)
            ->where('fkUserId', Auth::user()->userId);
            ->paginate(NUMBER OF PAGES); // whatever you needs this to be

        return $object;
    }

Answer 3

if you join your model through your controller before returning the view do:

abstract class YourController extends \BaseController {
    public function index() {
        $modelManager = new yourModel();
        $pagination = $modelManager->getTransactions($accountCode)->links();

        return View::make('yourView', array('pagination' => $pagination));
    }
}

and use {{$pagination}}in your view.