/**
  * Parse the XSD and update the list of search fields
  * 
  * @param MetadataProfile $metadataProfile
  * @param partnerId
  * 
  * @return TBD
  */
 public static function parseProfileSearchFields($partnerId, MetadataProfile $metadataProfile)
 {
     $key = $metadataProfile->getSyncKey(MetadataProfile::FILE_SYNC_METADATA_DEFINITION);
     $xsdPath = kFileSyncUtils::getLocalFilePathForKey($key);
     $xPaths = kXsd::findXpathsByAppInfo($xsdPath, self::APP_INFO_SEARCH, 'true');
     MetadataProfileFieldPeer::setUseCriteriaFilter(false);
     $profileFields = MetadataProfileFieldPeer::retrieveByMetadataProfileId($metadataProfile->getId());
     MetadataProfileFieldPeer::setUseCriteriaFilter(true);
     // check all existing fields
     foreach ($profileFields as $profileField) {
         $xPath = $profileField->getXpath();
         // field removed
         if (!isset($xPaths[$xPath])) {
             $profileField->setStatus(MetadataProfileField::STATUS_DEPRECATED);
             $profileField->save();
             continue;
         }
         $xPathData = $xPaths[$xPath];
         if ($profileField->getStatus() != MetadataProfileField::STATUS_ACTIVE && isset($xPathData['type']) && ($xPathData['type'] == MetadataSearchFilter::KMC_FIELD_TYPE_DATE || $xPathData['type'] == MetadataSearchFilter::KMC_FIELD_TYPE_INT)) {
             $availableSearchIndex = self::getAvailableSearchIndex($partnerId, $metadataProfile->getObjectType());
             if (!isset($availableSearchIndex)) {
                 throw new Exception('could not find available search index');
             }
             $profileField->setSearchIndex($availableSearchIndex);
         }
         $profileField->setStatus(MetadataProfileField::STATUS_ACTIVE);
         $profileField->setMetadataProfileVersion($metadataProfile->getVersion());
         if (isset($xPathData['name'])) {
             $profileField->setKey($xPathData['name']);
         }
         if (isset($xPathData['label'])) {
             $profileField->setLabel($xPathData['label']);
         }
         if (isset($xPathData['type'])) {
             $profileField->setType($xPathData['type']);
         }
         $profileField->save();
         unset($xPaths[$xPath]);
     }
     // add new searchable fields
     foreach ($xPaths as $xPath => $xPathData) {
         $profileField = new MetadataProfileField();
         $profileField->setMetadataProfileId($metadataProfile->getId());
         $profileField->setMetadataProfileVersion($metadataProfile->getVersion());
         $profileField->setPartnerId($metadataProfile->getPartnerId());
         $profileField->setStatus(MetadataProfileField::STATUS_ACTIVE);
         $profileField->setXpath($xPath);
         if (isset($xPathData['name'])) {
             $profileField->setKey($xPathData['name']);
         }
         if (isset($xPathData['label'])) {
             $profileField->setLabel($xPathData['label']);
         }
         if (isset($xPathData['type'])) {
             $profileField->setType($xPathData['type']);
             if ($xPathData['type'] == MetadataSearchFilter::KMC_FIELD_TYPE_DATE || $xPathData['type'] == MetadataSearchFilter::KMC_FIELD_TYPE_INT) {
                 $availableSearchIndex = self::getAvailableSearchIndex($partnerId, $metadataProfile->getObjectType());
                 if (!isset($availableSearchIndex)) {
                     throw new Exception('could not find available search index');
                 }
                 $profileField->setSearchIndex($availableSearchIndex);
             }
             $profileField->save();
         }
     }
     // set none searchable existing fields
     $xPaths = kXsd::findXpathsByAppInfo($xsdPath, self::APP_INFO_SEARCH, 'false');
     foreach ($profileFields as $profileField) {
         $xPath = $profileField->getXpath();
         if (!isset($xPaths[$xPath])) {
             continue;
         }
         $xPathData = $xPaths[$xPath];
         if (isset($xPathData['name'])) {
             $profileField->setKey($xPathData['name']);
         }
         if (isset($xPathData['label'])) {
             $profileField->setLabel($xPathData['label']);
         }
         if (isset($xPathData['type'])) {
             $profileField->setType($xPathData['type']);
         }
         $profileField->setStatus(MetadataProfileField::STATUS_NONE_SEARCHABLE);
         $profileField->setMetadataProfileVersion($metadataProfile->getVersion());
         $profileField->save();
         unset($xPaths[$xPath]);
     }
     // add new none searchable fields
     foreach ($xPaths as $xPath => $xPathData) {
         $profileField = new MetadataProfileField();
         $profileField->setMetadataProfileId($metadataProfile->getId());
         $profileField->setMetadataProfileVersion($metadataProfile->getVersion());
         $profileField->setPartnerId($metadataProfile->getPartnerId());
         $profileField->setStatus(MetadataProfileField::STATUS_NONE_SEARCHABLE);
         $profileField->setXpath($xPath);
         if (isset($xPathData['name'])) {
             $profileField->setKey($xPathData['name']);
         }
         if (isset($xPathData['label'])) {
             $profileField->setLabel($xPathData['label']);
         }
         if (isset($xPathData['type'])) {
             $profileField->setType($xPathData['type']);
         }
         $profileField->save();
     }
 }