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;
}
