Function: nornix_site.get_document_level

Information
DTD identifier	Deterministic	Data access	Mode
int(11)	NO	READS SQL DATA

Code

Get level of document

CREATE DEFINER=`root`@`localhost` FUNCTION `get_document_level`(vDocumentNo INTEGER) RETURNS int(11)
    READS SQL DATA
    COMMENT 'Get level of document'
BEGIN
 DECLARE d INTEGER;
 SELECT COUNT(*) - 1 INTO d
 FROM document AS node, document AS parent
 WHERE node.Lft BETWEEN parent.Lft AND parent.Rgt
 AND node.No = vDocumentNo;
 return d;
END