Update application/modules/reports/models/Mdl_reports.php

nielsdrost7 · Copilot · web-flow · commit 9b9078097242 · 2025-10-05T14:00:49.000+02:00
Co-authored-by: Copilot &lt;175728472+Copilot@users.noreply.github.com&gt;
diff --git a/application/modules/reports/models/Mdl_reports.php b/application/modules/reports/models/Mdl_reports.php
@@ -561,7 +561,7 @@ public function sales_by_year(
                                 WHERE inv.client_id=ip_clients.client_id
                                     AND ' . $this->db->escape($from_date) . ' <= inv.invoice_date_created
                                     AND ' . $this->db->escape($to_date) . ' >= inv.invoice_date_created
-                                    AND ' . $this->db->escape($minQuantity) . ' <=
+                                    AND ' . (int)$minQuantity . ' <=
                                     (
                                         SELECT SUM(amounts2.invoice_total) FROM ip_invoice_amounts amounts2
                                             WHERE amounts2.invoice_id IN

Original file line number	Diff line number	Diff line change
`@@ -561,7 +561,7 @@ public function sales_by_year(`
`561`	`561`	`WHERE inv.client_id=ip_clients.client_id`
`562`	`562`	`AND ' . $this->db->escape($from_date) . ' <= inv.invoice_date_created`
`563`	`563`	`AND ' . $this->db->escape($to_date) . ' >= inv.invoice_date_created`
`564`		`- AND ' . $this->db->escape($minQuantity) . ' <=`
	`564`	`+ AND ' . (int)$minQuantity . ' <=`
`565`	`565`	`(`
`566`	`566`	`SELECT SUM(amounts2.invoice_total) FROM ip_invoice_amounts amounts2`
`567`	`567`	`WHERE amounts2.invoice_id IN`