Paginator calculating last_page wrong when using soft deletes

[cercos]

Describe the bug

The paginator gives the wrong last_page count when using soft deletes. If you had 10 database entries with a per_page of 5, when you delete 6 entries, the last_page should be back at 1 but it stays at 2.

Expected behaviour

Not include soft deleted rows in last_page count

Steps to reproduce the bug

No response

Screenshots

No response

OS

Linux

OS version

KDE 5.24.1

Browser

No response

Masonite Version

4.6.1

Anything else ?

No response

[josephmancuso]

This should be an easy fix. When we perform a new query to get the totals we create a new query builder. On this new query builder must not be passing the global scopes

[josephmancuso]

https://github.com/MasoniteFramework/orm/blob/2.0/src/masoniteorm/query/QueryBuilder.py#L1525-L1527