This package can retrieve database table records by a given order.
It provides one class that can compose and execute SQL queries using PDO to retrieve records of database tables by an order defined using a configuration class.
The configuration class allows defining the following:
- The name of the table
- The table columns that will be used to define the sorting order and global sorting order
- The table record identifier column
- The name of the column that will be used to determine if the table record was marked as deleted
The class provides a class for:
- Retrieve the database table record in the next position
- Change the order of a given database table record
- Check if a given database record exists
The package also provides a class to retrieve database table records split in multiple pages. |
