callAllIdbVisible (procedure)

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

No parameters.

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDUREcallAllIdbVisible'.

Narrative

Business context: Module-tree visibility-cascade for the BACK navigation tree (gdsmodule). Walks the root nodes (those with empty sParentId); for any root that has bVisible=0, marks every direct child invisible (bVisible=0, bJurisdictionShow=0, bUnTask=0) and then recurses deeper via callAllIdChidVisible. Companion to callAllId (which rebuilds the sAllId path), specialised for propagating the visibility/jurisdiction flags down the subtree when a parent is hidden.

What it does: opens a cursor over root gdsmodule rows; for each root with IFNULL(bVisible,0)=0, runs a single UPDATE gdsmodule SET bVisible=0, bJurisdictionShow=0, bUnTask=0 WHERE sParentId = root.sId and then calls callAllIdChidVisible(root.sId) to descend.

Invocation: Status: appears orphaned. No caller found in any channel (form-master, gdsmodule hooks, other routines, xly-src grep). The visibility-rebuild flow ships through callAllIdChidVisible directly from Java; this top-level wrapper is unused — candidate for maintainer audit.