function select_proper_filters($requestDocsFilter) { $filter = ''; $compatiblePlugin = true; switch ($requestDocsFilter) { case 'image': $ors = ''; foreach (MultimediaHelper::getSupportedImages() as $imgfmt) { $ors .= " OR format LIKE '{$imgfmt}'"; } $filter = "AND (format LIKE '.dir' {$ors})"; break; case 'eclmedia': $ors = ''; foreach (MultimediaHelper::getSupportedMedia() as $mediafmt) { $ors .= " OR format LIKE '{$mediafmt}'"; } $filter = "AND (format LIKE '.dir' {$ors})"; break; case 'media': $compatiblePlugin = false; $ors = ''; foreach (MultimediaHelper::getSupportedMedia() as $mediafmt) { $ors .= " OR format LIKE '{$mediafmt}'"; } $filter = "AND (format LIKE '.dir' {$ors})"; break; case 'zip': $filter = "AND (format LIKE '.dir' OR FORMAT LIKE 'zip')"; break; case 'file': $filter = ''; break; default: break; } return array($filter, $compatiblePlugin); }
function select_proper_filters($requestDocsFilter) { $filterv = 'WHERE true'; $filterl = 'WHERE true'; $compatiblePlugin = true; switch ($requestDocsFilter) { case 'image': $ors = ''; $first = true; foreach (MultimediaHelper::getSupportedImages() as $imgfmt) { if ($first) { $ors .= "path LIKE '%$imgfmt%'"; $first = false; } else { $ors .= " OR path LIKE '%$imgfmt%'"; } } $filterv = "WHERE ( $ors )"; $filterl = "WHERE false"; break; case 'zip': $filterv = $filterl = "WHERE false"; break; case 'media': $compatiblePlugin = false; break; case 'eclmedia': case 'file': default: break; } return array($filterv, $filterl, $compatiblePlugin); }