Function: nornix_site.get_properties

Code

Loads properties according to the page data in the TempDoc table

CREATE DEFINER=`root`@`localhost` FUNCTION `get_properties`(vPath VARCHAR(127)) RETURNS int(11)
    READS SQL DATA
    COMMENT 'Loads properties according to the page data in the TempDoc table'
BEGIN
 DECLARE docNo INTEGER;
 IF NOT IFNULL(@tempdocpath = vPath, 0)
  THEN CALL get_document_sub(vPath);
 END IF;
 SELECT `No` INTO docNo FROM tempdoc ORDER BY Level DESC LIMIT 1;
 DROP TEMPORARY TABLE IF EXISTS nornix_site.tempprop;
 CREATE TEMPORARY TABLE nornix_site.tempprop AS SELECT DISTINCT Class, Attribute, Value, Multiple
 FROM property prop JOIN document doc
 ON doc.No=prop.DocumentNo
 WHERE doc.No=docNo OR doc.No IN (SELECT `No` FROM nornix_site.tempdoc WHERE prop.Cascade=1)
 ORDER BY prop.Cascade DESC, prop.SortOrder ASC, doc.Level ASC;
 RETURN 1;
END