protected function applyFilterFields(baseObjectFilter $filter) { $partnerId = kCurrentContext::getCurrentPartnerId(); $categories = $filter->get("_matchor_likex_full_name"); if ($categories !== null) { $categories = explode(',', $categories); $parsedCategories = array(); foreach ($categories as $category) { if (trim($category) == '') { continue; } $parsedCategories[] = $category . '\\*'; } $fullNameMatchOr = ''; if (count($parsedCategories)) { $fullNameMatchOr = implode(',', $parsedCategories); } if ($fullNameMatchOr != '') { $filter->set("_matchor_full_name", $fullNameMatchOr); } } $filter->unsetByName('_matchor_likex_full_name'); if ($filter->get('_free_text')) { $freeTexts = $filter->get('_free_text'); $additionalConditions = array(); $advancedSearch = $filter->getAdvancedSearch(); if ($advancedSearch) { $additionalConditions = $advancedSearch->getFreeTextConditions($filter->getPartnerSearchScope(), $freeTexts); } $this->addFreeTextToMatchClauseByMatchFields($freeTexts, categoryFilter::FREE_TEXT_FIELDS, $additionalConditions); } $filter->unsetByName('_free_text'); if ($filter->get('_eq_privacy_context') && $filter->get('_eq_privacy_context') == '*') { $filter->set('_matchor_privacy_context', kEntitlementUtils::NOT_DEFAULT_CONTEXT); $filter->unsetByName('_eq_privacy_context'); } if ($filter->get('_eq_manager')) { $puserId = $filter->get('_eq_manager'); $kuser = kuserPeer::getKuserByPartnerAndUid($partnerId, $puserId); if ($kuser) { $manager = category::getPermissionLevelName(CategoryKuserPermissionLevel::MANAGER); $this->matchClause[] = '(@(' . categoryFilter::MEMBERS . ') ' . $manager . '_' . $kuser->getid() . ')'; } } $filter->unsetByName('_eq_manager'); if ($filter->get('_eq_member')) { $puserId = $filter->get('_eq_member'); $kuser = kuserPeer::getKuserByPartnerAndUid($partnerId, $puserId); if ($kuser) { $manager = category::getPermissionLevelName(CategoryKuserPermissionLevel::MANAGER); $member = category::getPermissionLevelName(CategoryKuserPermissionLevel::MEMBER); $moderator = category::getPermissionLevelName(CategoryKuserPermissionLevel::MODERATOR); $contributor = category::getPermissionLevelName(CategoryKuserPermissionLevel::CONTRIBUTOR); $kuserId = $kuser->getid(); $this->matchClause[] = '(@(' . categoryFilter::MEMBERS . ') ' . "({$member}_{$kuserId} | {$moderator}_{$kuserId} | {$contributor}_{$kuserId} ) !({$manager}_{$kuserId}))"; } } $filter->unsetByName('_eq_member'); if ($filter->get('_eq_full_name')) { $filter->set('_matchor_full_name', $filter->get('_eq_full_name') . category::FULL_NAME_EQUAL_MATCH_STRING); } $filter->unsetByName('_eq_full_name'); if ($filter->get('_in_full_name')) { $fullnames = explode(',', $filter->get('_in_full_name')); $fullnameIn = ''; foreach ($fullnames as $fullname) { $fullnameIn .= $fullname . category::FULL_NAME_EQUAL_MATCH_STRING . ','; } $filter->set('_matchor_full_name', $fullnameIn); $filter->unsetByName('_in_full_name'); } $categories = $filter->get("_in_ancestor_id"); if ($categories !== null) { //if the category exist or the category name is an empty string $categoriesParsed = $filter->categoryIdsToAllSubCategoriesIdsParsed($categories); if ($categoriesParsed !== '' || $categories == '') { $filter->set("_matchor_full_ids", $categoriesParsed); } else { $filter->set("_matchor_full_ids", category::CATEGORY_ID_THAT_DOES_NOT_EXIST); } } $filter->unsetByName('_in_ancestor_id'); if ($filter->get('_likex_full_ids')) { $fullids = explode(',', $filter->get('_likex_full_ids')); $fullIdsIn = ''; foreach ($fullids as $fullid) { $fullIdsIn .= $fullid . '\\*,'; } $filter->set('_matchor_full_ids', $fullIdsIn); $filter->unsetByName('_likex_full_ids'); } if ($filter->get('_eq_full_ids')) { $filter->set('_matchor_full_ids', $filter->get('_eq_full_ids') . category::FULL_IDS_EQUAL_MATCH_STRING); } $filter->unsetByName('_eq_full_ids'); if ($filter->get('_likex_name_or_reference_id')) { $names = $filter->get('_likex_name_or_reference_id'); $this->addFreeTextToMatchClauseByMatchFields($names, categoryFilter::NAME_REFERNCE_ID, null, true); } $filter->unsetByName('_likex_name_or_reference_id'); if ($filter->get('_eq_privacy')) { $filter->set('_eq_privacy', $filter->get('_eq_privacy') . "P" . $partnerId); } if ($filter->get('_in_privacy')) { $privacyIn = explode(',', $filter->get('_in_privacy')); $newPrivacyIn = array(); foreach ($privacyIn as $privacy) { $newPrivacyIn[] = $privacy . "P" . $partnerId; } $filter->set('_in_privacy', implode(",", $newPrivacyIn)); } if ($filter->get('_eq_display_in_search')) { $filter->set('_eq_display_in_search', $filter->get('_eq_display_in_search')); } return parent::applyFilterFields($filter); }
protected function applyFilterFields(baseObjectFilter $filter) { $categories = $filter->get("_matchor_likex_full_name"); if ($categories !== null) { $categories = explode(',', $categories); $parsedCategories = array(); foreach ($categories as $category) { if (trim($category) == '') { continue; } $parsedCategories[] = $category . '\\*'; } $fullNameMatchOr = ''; if (count($parsedCategories)) { $fullNameMatchOr = implode(',', $parsedCategories); } if ($fullNameMatchOr != '') { $filter->set("_matchor_full_name", $fullNameMatchOr); } } $filter->unsetByName('_matchor_likex_full_name'); if ($filter->get('_free_text')) { $freeTexts = $filter->get('_free_text'); KalturaLog::debug("Attach free text [{$freeTexts}]"); $additionalConditions = array(); $advancedSearch = $filter->getAdvancedSearch(); if ($advancedSearch) { $additionalConditions = $advancedSearch->getFreeTextConditions($freeTexts); } if (preg_match('/^"[^"]+"$/', $freeTexts)) { $freeText = str_replace('"', '', $freeTexts); $freeText = SphinxUtils::escapeString($freeText); $freeText = "^{$freeText}\$"; $additionalConditions[] = "@(" . categoryFilter::FREE_TEXT_FIELDS . ") {$freeText}"; } else { if (strpos($freeTexts, baseObjectFilter::IN_SEPARATOR) > 0) { str_replace(baseObjectFilter::AND_SEPARATOR, baseObjectFilter::IN_SEPARATOR, $freeTexts); $freeTextsArr = explode(baseObjectFilter::IN_SEPARATOR, $freeTexts); foreach ($freeTextsArr as $valIndex => $valValue) { if (!is_numeric($valValue) && strlen($valValue) <= 0) { unset($freeTextsArr[$valIndex]); } else { $freeTextsArr[$valIndex] = SphinxUtils::escapeString($valValue); } } foreach ($freeTextsArr as $freeText) { $additionalConditions[] = "@(" . categoryFilter::FREE_TEXT_FIELDS . ") {$freeText}"; } } else { $freeTextsArr = explode(baseObjectFilter::AND_SEPARATOR, $freeTexts); foreach ($freeTextsArr as $valIndex => $valValue) { if (!is_numeric($valValue) && strlen($valValue) <= 0) { unset($freeTextsArr[$valIndex]); } else { $freeTextsArr[$valIndex] = SphinxUtils::escapeString($valValue); } } $freeTextsArr = array_unique($freeTextsArr); $freeTextExpr = implode(baseObjectFilter::AND_SEPARATOR, $freeTextsArr); $additionalConditions[] = "@(" . categoryFilter::FREE_TEXT_FIELDS . ") {$freeTextExpr}"; } } if (count($additionalConditions)) { $additionalConditions = array_unique($additionalConditions); $matches = reset($additionalConditions); if (count($additionalConditions) > 1) { $matches = '( ' . implode(' ) | ( ', $additionalConditions) . ' )'; } $this->matchClause[] = $matches; } } $filter->unsetByName('_free_text'); if ($filter->get('_eq_privacy_context') && $filter->get('_eq_privacy_context') == '*') { $filter->set('_matchor_privacy_context', kEntitlementUtils::NOT_DEFAULT_CONTEXT); $filter->unsetByName('_eq_privacy_context'); } if ($filter->get('_eq_manager')) { $partnerId = kCurrentContext::$partner_id ? kCurrentContext::$partner_id : kCurrentContext::$ks_partner_id; $puserId = $filter->get('_eq_manager'); $kuser = kuserPeer::getKuserByPartnerAndUid($partnerId, $puserId); if ($kuser) { $manager = category::getPermissionLevelName(CategoryKuserPermissionLevel::MANAGER); $this->matchClause[] = '(@(' . categoryFilter::MEMBERS . ') ' . $manager . '_' . $kuser->getid() . ')'; } } $filter->unsetByName('_eq_manager'); if ($filter->get('_eq_member')) { //memeber but not a menager $partnerId = kCurrentContext::$partner_id ? kCurrentContext::$partner_id : kCurrentContext::$ks_partner_id; $puserId = $filter->get('_eq_member'); $kuser = kuserPeer::getKuserByPartnerAndUid($partnerId, $puserId); if ($kuser) { $manager = category::getPermissionLevelName(CategoryKuserPermissionLevel::MANAGER); $member = category::getPermissionLevelName(CategoryKuserPermissionLevel::MEMBER); $moderator = category::getPermissionLevelName(CategoryKuserPermissionLevel::MODERATOR); $contributor = category::getPermissionLevelName(CategoryKuserPermissionLevel::CONTRIBUTOR); $kuserId = $kuser->getid(); $this->matchClause[] = '(@(' . categoryFilter::MEMBERS . ') ' . "({$member}_{$kuserId} | {$moderator}_{$kuserId} | {$contributor}_{$kuserId} ) !({$manager}_{$kuserId}))"; } } $filter->unsetByName('_eq_member'); if ($filter->get('_eq_full_name')) { $filter->set('_matchor_full_name', $filter->get('_eq_full_name') . category::FULL_NAME_EQUAL_MATCH_STRING); } $filter->unsetByName('_eq_full_name'); if ($filter->get('_in_full_name')) { $fullnames = explode(',', $filter->get('_in_full_name')); $fullnameIn = ''; foreach ($fullnames as $fullname) { $fullnameIn .= $fullname . category::FULL_NAME_EQUAL_MATCH_STRING . ','; } $filter->set('_matchor_full_name', $fullnameIn); $filter->unsetByName('_in_full_name'); } $categories = $filter->get("_in_ancestor_id"); if ($categories !== null) { //if the category exist or the category name is an empty string $categoriesParsed = $filter->categoryIdsToAllSubCategoriesIdsParsed($categories); if ($categoriesParsed !== '' || $categories == '') { $filter->set("_likex_full_ids", $categoriesParsed); } else { $filter->set("_likex_full_ids", category::CATEGORY_ID_THAT_DOES_NOT_EXIST); } } $filter->unsetByName('_in_ancestor_id'); if ($filter->get('_likex_full_ids')) { $fullids = explode(',', $filter->get('_likex_full_ids')); $fullIdsIn = ''; foreach ($fullids as $fullid) { $fullIdsIn .= $fullid . '\\*,'; } $filter->set('_matchor_full_ids', $fullIdsIn); $filter->unsetByName('_likex_full_ids'); } if ($filter->get('_eq_full_ids')) { $filter->set('_matchor_full_ids', $filter->get('_eq_full_ids') . category::FULL_IDS_EQUAL_MATCH_STRING); } $filter->unsetByName('_eq_full_ids'); if ($filter->get('_likex_name_or_reference_id')) { $names = $filter->get('_likex_name_or_reference_id'); KalturaLog::debug("Attach free text [{$names}]"); $additionalConditions = array(); if (preg_match('/^"[^"]+"$/', $names)) { $name = str_replace('"', '', $names); $name = SphinxUtils::escapeString($name); $name = "^{$name}\$"; $additionalConditions[] = "@(" . categoryFilter::NAME_REFERNCE_ID . ") {$name}\\\\*"; } else { if (strpos($names, baseObjectFilter::IN_SEPARATOR) > 0) { str_replace(baseObjectFilter::AND_SEPARATOR, baseObjectFilter::IN_SEPARATOR, $names); $namesArr = explode(baseObjectFilter::IN_SEPARATOR, $names); foreach ($namesArr as $valIndex => $valValue) { if (!is_numeric($valValue) && strlen($valValue) <= 0) { unset($namesArr[$valIndex]); } else { $namesArr[$valIndex] = SphinxUtils::escapeString($valValue); } } foreach ($namesArr as $name) { $additionalConditions[] = "@(" . categoryFilter::NAME_REFERNCE_ID . ") {$name}\\\\*"; } } else { $namesArr = explode(baseObjectFilter::AND_SEPARATOR, $names); foreach ($namesArr as $valIndex => $valValue) { if (!is_numeric($valValue) && strlen($valValue) <= 0) { unset($namesArr[$valIndex]); } else { $namesArr[$valIndex] = SphinxUtils::escapeString($valValue); } } $namesArr = array_unique($namesArr); $nameExpr = implode(baseObjectFilter::AND_SEPARATOR, $namesArr); $additionalConditions[] = "@(" . categoryFilter::NAME_REFERNCE_ID . ") {$nameExpr}\\\\*"; } } if (count($additionalConditions)) { $additionalConditions = array_unique($additionalConditions); $matches = reset($additionalConditions); if (count($additionalConditions) > 1) { $matches = '( ' . implode(' ) | ( ', $additionalConditions) . ' )'; } $this->matchClause[] = $matches; } } $filter->unsetByName('_likex_name_or_reference_id'); return parent::applyFilterFields($filter); }