diff options
| author | Lester Caine <lester@lsces.co.uk> | 2026-06-01 12:34:02 +0100 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2026-06-01 12:34:02 +0100 |
| commit | 6b30ab3d3ec23bd3f6056f2d1685159487383378 (patch) | |
| tree | 8771041a52fadc545c1badbc38c910c56d84d2f3 /list_stock.php | |
| parent | a16e3d92444befcbd857d3bf00381b559d494d20 (diff) | |
| download | stock-6b30ab3d3ec23bd3f6056f2d1685159487383378.tar.gz stock-6b30ab3d3ec23bd3f6056f2d1685159487383378.tar.bz2 stock-6b30ab3d3ec23bd3f6056f2d1685159487383378.zip | |
Stock/movement assembly linkage, view icons, and list_stock fixes
- add_requisition: store ASSEMBLY xref on new movements so they can be filtered by assembly
- StockMovement::getList: add assembly_content_id filter via ASSEMBLY xref join
- list_movements: pass assemblyContentId to Smarty
- view_assembly.tpl: add View Stock and View Movements icons filtered by assembly
- list_stock: guard CAST with SIMILAR TO on xkey join; fix %.3g scientific notation to %.0f
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
Diffstat (limited to 'list_stock.php')
| -rw-r--r-- | list_stock.php | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/list_stock.php b/list_stock.php index 668a401..d55df91 100644 --- a/list_stock.php +++ b/list_stock.php @@ -61,6 +61,7 @@ $query = "SELECT lc.`content_id`, lc.`title`, lc.`data`, $joinSql INNER JOIN `{$X}liberty_xref` x ON x.`xref` = lc.`content_id` AND x.`item` IN ('SGL','PCK','SHT','VOL') + AND x.`xkey` SIMILAR TO '[0-9]+(\.[0-9]+)?' INNER JOIN `{$X}liberty_content` mc ON mc.`content_id` = x.`content_id` AND mc.`content_type_guid` = 'stockmovement' WHERE lc.`content_type_guid` = 'stockcomponent' |