Function: nornix_site.find_parent_doc

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

Code

CREATE DEFINER=`root`@`localhost` FUNCTION `find_parent_doc`(vNo INTEGER) RETURNS int(11)
    READS SQL DATA
BEGIN
 DECLARE l INTEGER;
 DECLARE r INTEGER;
 DECLARE levl INTEGER;
 DECLARE parent INTEGER;
 SELECT Lft, Rgt, (`Level` - 1) INTO l, r, levl FROM document WHERE `No`=vNo;
 SELECT `No` INTO parent
 FROM document
 WHERE `Level` = levl AND Lft<l AND Rgt>r;
 RETURN parent;
END