From fcd97be1f1fd1587cc9954adfa84447c4b98d9c9 Mon Sep 17 00:00:00 2001 From: Lester Caine Date: Wed, 3 Jun 2026 20:16:42 +0100 Subject: stock: fix pagination on list_movements StockMovement::getList() was missing a COUNT query so postGetList() defaulted cant to max_records, giving total_pages=1 always. Also pass filter params (ref_type, find, component_content_id, assembly_content_id) through pagination links so filters survive page navigation. Co-Authored-By: Claude Sonnet 4.6 --- includes/classes/StockMovement.php | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'includes') diff --git a/includes/classes/StockMovement.php b/includes/classes/StockMovement.php index 5ee4aae..6e07cbf 100644 --- a/includes/classes/StockMovement.php +++ b/includes/classes/StockMovement.php @@ -246,6 +246,15 @@ class StockMovement extends LibertyContent { $whereSql = substr_replace( $whereSql, ' WHERE ', 0, 4 ); } + $pListHash['cant'] = (int)$this->mDb->getOne( + "SELECT COUNT(DISTINCT lc.`content_id`) + FROM `".BIT_DB_PREFIX."liberty_content` lc + INNER JOIN `".BIT_DB_PREFIX."users_users` uu ON uu.`user_id` = lc.`user_id` + $joinSql + $whereSql", + $bindVars + ); + $X = BIT_DB_PREFIX; $cmpQtySelect = $this->verifyId( $pListHash['component_content_id'] ?? 0 ) ? ", xcmp.`item` AS cmp_qty_type, CAST(xcmp.`xkey` AS DOUBLE PRECISION) AS cmp_qty" -- cgit v1.3