public static function getFolders($strName = "", $intParentId = 0, $blnGetOne = FALSE) { $objCms = PCMS_Client::getInstance(); $strSql = "SELECT pcms_element.* FROM pcms_element, pcms_element_schedule\n\t\t\t\tWHERE pcms_element.parentId = '%s'\n\t\t\t\tAND pcms_element.active = '1'\n\t\t\t\tAND pcms_element.typeId = '%s' "; $strSql .= empty($strName) ? "" : "AND pcms_element.apiName = '%s' "; $strSql .= "AND pcms_element.accountId = '%s'\n\t\t\t\tAND pcms_element.id IN (SELECT elementId FROM pcms_element_language\n\t\t\t\t\tWHERE languageId = '%s'\n\t\t\t\t\tAND active = '1')\n\t\t\t\tAND pcms_element.id = pcms_element_schedule.elementId\n\t\t\t\tAND pcms_element_schedule.startDate <= '%s'\n\t\t\t\tAND pcms_element_schedule.endDate >= '%s'\n\t\t\t\tORDER BY pcms_element.sort"; if (empty($strName)) { $objElements = Element::select(sprintf($strSql, $intParentId, ELM_TYPE_FOLDER, PCMS_Client::getAccount()->getId(), $objCms->getLanguage()->getId(), self::toMysql(), self::toMysql())); } else { $objElements = Element::select(sprintf($strSql, $intParentId, ELM_TYPE_FOLDER, $strName, PCMS_Client::getAccount()->getId(), $objCms->getLanguage()->getId(), self::toMysql(), self::toMysql())); } if ($blnGetOne) { if ($objElements->count() > 0) { $objElement = new __Element($objElements->current()); return $objElement; } else { $objReturn = new __Element(); } } else { $objReturn = new __Elements(); } foreach ($objElements as $objElement) { $objReturn->addObject(new __Element($objElement)); } return $objReturn; }