Incam_SGD/plugins/search2/reporting/ExtractorInfo.php

<?php
/**
 * $Id:$
 *
 * KnowledgeTree Community Edition
 * Document Management Made Simple
 * Copyright (C) 2008, 2009 KnowledgeTree Inc.
 * 
 *
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License version 3 as published by the
 * Free Software Foundation.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
 * details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * You can contact KnowledgeTree Inc., PO Box 7775 #87847, San Francisco,
 * California 94120-7775, or email info@knowledgetree.com.
 *
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU General Public License version 3.
 *
 * In accordance with Section 7(b) of the GNU General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * KnowledgeTree" logo and retain the original copyright notice. If the display of the
 * logo is not reasonably feasible for technical reasons, the Appropriate Legal Notices
 * must display the words "Powered by KnowledgeTree" and retain the original
 * copyright notice.
 * Contributor( s): ______________________________________
 *
 */

require_once(KT_LIB_DIR . '/dispatcher.inc.php');
require_once(KT_LIB_DIR . '/templating/templating.inc.php');
require_once(KT_LIB_DIR . '/mime.inc.php');

class ExtractorInfoDispatcher extends KTAdminDispatcher {


    function check() {
        $this->aBreadcrumbs[] = array(
            'url' => $_SERVER['PHP_SELF'],
            'name' => _kt('Extractor Information'),
        );
        return parent::check();
    }

    function do_main() {

        //registerTypes registers the mime types and populates the needed tables.
        $indexer = Indexer::get();
        $indexer->registerTypes();

        $oTemplating =& KTTemplating::getSingleton();
        $oTemplate =& $oTemplating->loadTemplate('ktcore/search2/reporting/extractorinfo');

        $aExtractorInfo = KTMime::getMimeExtractorInformation();

        if(empty($aExtractorInfo))
        {
        	$oTemplate->setData(array(
           	'context' => $this,
           	'extractor_info' => $aExtractorInfo
        	));

        	return $oTemplate;
        }

        foreach($aExtractorInfo as $key=>$info)
        {
        	$extractorClass = $info['name'];
        	$extractor = $indexer->getExtractor($extractorClass);
        	$info['mimeTypes'] = array();
        	$aMimeTypes = $this->getSupportedMimeTypesDB($extractorClass);//$extractor->getSupportedMimeTypes();


        	foreach($aMimeTypes as $mimeType)
        	{
        			$sMimeInfo = KTMime::getFriendlyNameAndExtension($mimeType);

        			$info['mimeTypes'][$mimeType] = array('description'=>$sMimeInfo[0]['friendly_name'], 'extensions'=>array($sMimeInfo[0]['filetypes']));

        			$extensions = array();
        			foreach($sMimeInfo as $item)
        			{
        				$extensions[] = $item['filetypes'];
        			}
        			$info['mimeTypes'][$mimeType]['extensions'] = implode(', ', $extensions);
        	}

        	$aExtractorInfo[$key] = $info;
        }

        $oTemplate->setData(array(
            'context' => $this,
            'extractor_info' => $aExtractorInfo
        ));
        return $oTemplate;
    }

    function getSupportedMimeTypesDB($sExtractorName)
	{
		$sQuery = "SELECT MT.mimetypes  FROM mime_extractors as ME LEFT JOIN mime_types as MT ON " .
  		  		"(ME.id = MT.extractor_id) WHERE ME.name = ?";
   		 $aQuery = array($sQuery, array($sExtractorName));
    	$aTempRes = DBUtil::getResultArray($aQuery);
    	$aRes = array();
    	for($i = 0; $i < count($aTempRes); $i++ )
    	{
    		if(!in_array($aTempRes[$i]['mimetypes'], $aRes))
    		{
    			$aRes[] = $aTempRes[$i]['mimetypes'];

    		}
    	}
    	return $aRes;
	}

}


?>