summaryrefslogtreecommitdiff
path: root/list_movements.php
AgeCommit message (Collapse)AuthorFilesLines
63 min.list_movements: sign REQN/PBLD qty negative, show net total in Qty headerHEADmasterLester Caine1-0/+16
When filtered by part_content_id, outbound movements (REQN, PBLD) now display with a leading minus sign. The Qty column header shows the net stock balance across all movements for the part, consistent with view_component stock levels. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
9 daysPersist filter params through smartlink sort clicks on list pagesLester Caine1-0/+5
Populate listInfo['parameters'] on list_movements, list_assemblies, and list_components so icontrol carries part_content_id/ref_type/user_id/ gallery_id/hide_kitlocker through sort URLs. Wire icontrol=$listInfo on list_movements.tpl sort headers which were previously missing it. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-06-14Add multi-user (kitelf) stock filtering and PBLD prebuild movement typeLester Caine1-22/+50
- list_movements/list_stock: filter by user_id (kitelf) with breadcrumb navigation; creator names in list_movements are clickable filter links - list_movements: unified part_content_id replaces separate assembly_content_id/component_content_id URL params; type-aware breadcrumb and qty column (assembly kit count vs component qty) - StockMovement::getList(): $partId/$partIsAsm collapse cmp/asm into one variable; unified part_qty/part_qty_type SELECT; PBLD added to all ref_type IN() lists and sort subqueries; lc.user_id added to SELECT - New PBLD (Prebuild) movement type: add_prebuild.php/tpl creates PBLD movements (assemblies only, BOM exploded, optional note); add_requisition retired from UI; PBLD handled in edit/view with isBuild/isPbld flags; view/edit show Build Date/Completed labels for PBLD - schema_inc.php: PBLD registered in stockmovement reference xref items - view_movement.tpl: updated to <header>/<section> pattern with kitelf breadcrumb; getDirection() explicit for PBLD Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-06-10stock: rename PCK→PRT (fractional parts), add PCK as ordering pack-size ↵Lester Caine1-4/+4
tag; rename pack_size→part_size; bompck templates→bomprt; strip verbose labels (fraction), (H x W) Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-06-09stock: PCK/SHT fractional display, movement qty summing, import qty typeLester Caine1-0/+8
Display fixes: - list_stock, list_movements, view_component: PCK stock divides by pack_size for fractional strip display; SHT shows 2 decimal places - list_movements: pack_size fetched per component for PCK display - All fractional formats use %.2f consistently StockMovement::getList component filter: - Replace INNER JOIN on xcmp with EXISTS subquery to avoid duplicate rows when a component appears multiple times in a movement BOM - cmp_qty now SUMs all matching xref rows so multi-assembly RQs show total quantity rather than silently dropping duplicate rows Movement BOM edit templates: - stockmovement/edit_xref_bom_item.tpl: proper edit form for SGL/SHT/VOL lines linking back to view_component - stockmovement/edit_xref_bompck_item.tpl: same for PCK with pack size hint Import: - ImportSimpleComponent: columns 6/7 (qty_type, qty_value) wired up; PCK/SHT/VOL writes qty xref so movement CSV imports pick up default type Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-06-02Component movement history: filter list_movements by component_content_idLester Caine1-1/+14
StockMovement::getList() joins xcmp when component_content_id is set, adding cmp_qty/cmp_qty_type columns per row. list_movements.php looks up component title; template shows it in the header, adds a Qty column, and provides a back link. view_component Stock tab now links to filtered movement list. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-06-01Stock/movement assembly linkage, view icons, and list_stock fixesLester Caine1-3/+4
- 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>
2026-06-01Rewrite StockMovement as pure LibertyContent; CSV import; bom gridLester Caine1-4/+3
stock_movement/stock_movement_item tables retired. StockMovement now a pure LibertyContent subclass — direction from reference xref (REQN=out, TRANS/ORDER=in), received state from lc.event_time, items as quantity xrefs with explicit xorder. loadXrefList() enriches component names. schema_inc.php: full stockmovement xref seed — reference group (REQN/TRANS/ORDER) and quantity group (SGL/PCK/SHT/VOL, bom/bompck templates). MOV item removed from stockcomponent/stockassembly seed. edit_movement.php: type selector on create from DB; CSV upload parses header (from/ref/date) and component lines using component xref for default qty type. list_movements.php/tpl: rebuilt; ref_type filter; ref_type/ref_key/ received columns via xref subquery. view_movement.php/tpl: cleaned up; xref group tabs, allow_edit=false. stockmovement/ bom templates added. movement_lookup_inc simplified. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-05-27Add list_movements page and redirect after movement saveLester Caine1-0/+23
list_movements.php shows all movements with direction/status filter dropdowns and an Edit button per row. Menu gains a List Movements link. edit_movement.php now redirects to list_movements.php after a successful save rather than reloading the edit page. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>