<?php
/*** COPYRIGHT NOTICE *********************************************************
 *
* Copyright 2009-2017 ProjeQtOr - Pascal BERNARD - support@projeqtor.org
* Contributors : -
*
* This file is part of ProjeQtOr.
*
* ProjeQtOr is free software: you can redistribute it and/or modify it under
* the terms of the GNU Affero General Public License as published by the Free
* Software Foundation, either version 3 of the License, or (at your option)
* any later version.
*
* ProjeQtOr 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 Affero General Public License for
* more details.
*
* You should have received a copy of the GNU Affero General Public License along with
* ProjeQtOr. If not, see <http://www.gnu.org/licenses/>.
*
* You can get complete code of ProjeQtOr, other resource, help and information
* about contributors at http://www.projeqtor.org
*
*** DO NOT REMOVE THIS NOTICE ************************************************/
require_once('_securityCheck.php');
class Plugin extends SqlElement {
    public $id;
    public $name;
    public $description;
    public $zipFile;
    public $isDeployed;
    public $deploymentDate;
    public $deploymentVersion;
    public $compatibilityVersion;
    public $pluginVersion;
    public $uniqueCode;
    public $idle;
    
    private static $_triggeredEventList;
    private static $_pluginButtonList;
    private static $pluginRequiredVersion=array(
        "V6.0.6"=>array("screenCustomization"=>"3.1"),
        "V8.1.0"=>array("templateReport"=>"2.1"),
        "V8.3.0"=>array("kanban"=>"99.0",
                        "liveMeeting"=>"99.0")
    );
    private static $_activePluginList;
    private static $_lastVersionPluginList;
    
    function __construct() {
    }
    
    function __destruct() {
      parent::__destruct();
    }
    
    static function getFromName($name) {
      return SqlElement::getSingleSqlElementFromCriteria('Plugin', array('name'=>$name, 'idle'=>'0'));
    }
    
    public function load($file) {
      global $globalCatchErrors;
      global $remoteDb;
      if (isset($remoteDb) and $remoteDb) return "OK";
      traceLog("New plugin found : ".$file['name']);
      $this->name=str_replace('.zip','',$file['name']);
      $pos=strpos(strtolower($this->name),'_v');
      if ($pos) $this->name=substr($this->name,0,$pos);
      $this->zipFile=$file['path'];
      $plugin=$this->name;
      
      $metaData=$this->getMetadata($this->zipFile);
      $this->pluginVersion=$metaData['pluginVersion'];
      $checkCompatibility=$this->checkProjeQtOrCompatibility();
      if ($checkCompatibility!='OK') {
        $result=$checkCompatibility;
        traceLog("Plugin::load() : $result");
        return $result;
      }
      $result="OK";
      // unzip plugIn files
      $zip = new ZipArchive;
      $globalCatchErrors=true;
      $res = $zip->open($this->zipFile);
      if ($res === TRUE) {
        $res=$zip->extractTo(self::getDir());
        $zip->close();
      } 
      if ($res !== TRUE) {
        $result=i18n('pluginUnzipFail', array(self::unrelativeDir($this->zipFile), self::unrelativeDir(self::getDir()) ));
        errorLog("Plugin::load() : $result");
        return $result;
      }
      traceLog("Plugin unzipped succefully");
      
      $descriptorFileName=self::getDir()."/$plugin/pluginDescriptor.xml";
      if (! is_file($descriptorFileName)) {
        $result=i18n('pluginNoXmlDescriptor',array('pluginDescriptor.xml',self::unrelativeDir($descriptorFileName),$plugin));
        errorLog("Plugin::load() : $result");
        return $result;
      }
      $descriptorXml=file_get_contents($descriptorFileName);
      $parse = xml_parser_create();
      xml_parse_into_struct($parse, $descriptorXml, $value, $index);
      xml_parser_free($parse);
    
      $testUnicity=false;
      $testCompatibility=false;
      $arrayTriggers=array();
      $arrayButtons=array();
      foreach($value as $ind=>$prop) {
        if ($prop['tag']=='PLUGIN') {
          if (isset($prop['attributes']['NAME'])) {
            $pluginName=$prop['attributes']['NAME'];
            if ($plugin!=$pluginName) {
              $result=i18n('pluginNameIncompatibility',array($pluginName, $plugin,self::unrelativeDir($this->zipFile)));
              errorLog("Plugin::load() : $result");
              return $result;
            }           
          }
        }
        if ($prop['tag']=='PROPERTY') {
          $name='plugin'.ucfirst($prop['attributes']['NAME']);
          $value=$prop['attributes']['VALUE'];
          if (isset($prop['attributes']['VERSION'])) {
            $version=$prop['attributes']['VERSION'];
            if (!isset($$name) or !is_array($$name)) {
              if (isset($$name)) {
                $$name=array('1.0'=>$$name);
              } else {
                $$name=array();
              }
            }
            $tempArray=$$name;
            $tempArray[$version]=$value;
            $$name=$tempArray;
          } else {
            $$name=$value;
          }
        }
        if (isset($pluginName) and isset($pluginUniqueCode) and ! $testUnicity) {
          $testUnicity=true;
          $old=self::getFromName($pluginName);
          if ($old->uniqueCode and $pluginUniqueCode and $pluginUniqueCode!=$old->uniqueCode) {
            $result=i18n('pluginAlreadyExistsWithName',array($pluginName, $old->uniqueCode, $pluginUniqueCode));
            errorLog("Plugin::load() : $result");
            return $result;
          }
          $crit=array('uniqueCode'=>$pluginUniqueCode, 'idle'=>'0');
          $old=SqlElement::getSingleSqlElementFromCriteria('Plugin', $crit);
          if ($old->name and $pluginName and $pluginName!=$old->name) {
            $result=i18n('pluginAlreadyExistsWithCode',array($pluginUniqueCode, $old->name, $pluginName));
            errorLog("Plugin::load() : $result");
            return $result;
          }
        }
        if (isset($pluginCompatibility) and !$testCompatibility) {
          $testCompatibility=true;
          global $version;
          if (version_compare(ltrim($version,'V'),ltrim($pluginCompatibility,'V'),"<")) {
            $result=i18n('pluginVersionNotCompatible',array($version, $pluginCompatibility));
            errorLog("Plugin::load() : $result");
            return $result;
          }
        }
        if ($prop['tag']=='FILE') {
          if (isset($prop['attributes']) and is_array($prop['attributes'])) {
            $attr=$prop['attributes'];
            $fileName=(isset($attr['NAME']))?$attr['NAME']:null;
            $fileTarget=(isset($attr['TARGET']))?$attr['TARGET']:null;
            $fileSource=(isset($attr['SOURCE']))?$attr['SOURCE']:'';
            $fileAction=(isset($attr['ACTION']))?$attr['ACTION']:null;
            if (!is_dir($fileTarget)) {
              mkdir($fileTarget,0777,true);
            }
            if ($fileName and $fileTarget and ($fileAction=='move' or $fileAction=='copy')) {
              $res=copy(self::getDir()."/$plugin/$fileSource/$fileName","$fileTarget/$fileName");
              if (! $res) {
                $result=i18n('pluginErrorCopy',array($fileName,$fileTarget,$plugin));
                errorLog("Plugin::load() : $result");
                return $result;
              } else {
                if ($fileAction=='move') {
                  $res=kill(self::getDir()."/$plugin/$fileName");
                  if (! $res) {
                    // Not blocking error : delete of source is not really mandatory as long as copy is ok
                    //$result=i18n('pluginErrorMove',array($fileName,$plugin));
                    //errorLog("Plugin::load() : $result");
                  }
                }
              }
            }
            if ($fileName and $fileTarget and $fileAction=='delete') {
              $res=kill("$fileTarget/$fileName");
              if (! $res) {
                $result=i18n('pluginErrorDelete',array("$fileTarget/$fileName"));
                errorLog("Plugin::load() : $result");
                return $result;
              }
            }
          }
        }
        if ($prop['tag']=='TRIGGER') {
          if (isset($prop['attributes']) and is_array($prop['attributes'])) {
            $attr=$prop['attributes'];
            $event=(isset($attr['EVENT']))?$attr['EVENT']:null;
            $className=(isset($attr['CLASS']))?$attr['CLASS']:null;
            $script=(isset($attr['SCRIPT']))?$attr['SCRIPT']:null;
            if ($event and $className and $script) {
              $evt=new PluginTriggeredEvent();
              $evt->idPlugin=null; // to be defined later
              $evt->idle=0; // Active by default
              if ($className!='Planning' and $className!='ResourcePlanning' and $className!='PortfolioPlanning' and $className!='GlobalPlanning') { // Pseudo Classes
                Security::checkValidClass($className);
              }
              $evt->className=$className;
              $evt->script=$script;
              $evt->event=$event;
              if (in_array($event,PluginTriggeredEvent::$_allowedEvents)) { // Will store event only if event is valid
                $arrayTriggers[]=$evt;
              } else {
                traceLog("trigger not stored : '$event' is not a valid event");
              }
            }
          }
        }
        if ($prop['tag']=='BUTTON') {
          if (isset($prop['attributes']) and is_array($prop['attributes'])) {
            $attr=$prop['attributes'];
            $buttonName=(isset($attr['BUTTONNAME']))?$attr['BUTTONNAME']:null;
            $className=(isset($attr['CLASS']))?$attr['CLASS']:null;
            $scriptJS=(isset($attr['SCRIPTJS']))?$attr['SCRIPTJS']:null;
            $scriptPHP=(isset($attr['SCRIPTPHP']))?$attr['SCRIPTPHP']:null;
            $iconClass=(isset($attr['ICONCLASS']))?$attr['ICONCLASS']:null;
            $scope=(isset($attr['SCOPE']))?$attr['SCOPE']:null;
            $sortOrder=(isset($attr['SORTORDER']))?$attr['SORTORDER']:null;
            if ($buttonName and $className and ($scriptJS or $scriptPHP) and $scope) {
              $bt=new PluginButton();
              $bt->idPlugin=null; // to be defined later
              $bt->idle=0; // Active by default
              if ($className!='Planning' and $className!='ResourcePlanning' and $className!='PortfolioPlanning' and $className!='GlobalPlanning') { // Pseudo Classes
                Security::checkValidClass($className);
              }
              $bt->className=$className;
              $bt->buttonName=$buttonName;
              $bt->scriptPHP=$scriptPHP;
              $bt->scriptJS=$scriptJS;
              $bt->iconClass=$iconClass;
              $bt->scope=$scope;
              $bt->sortOrder=$sortOrder;
              if (in_array($scope,PluginButton::$_allowedScope)) { // Will store event only if event is valid
                $arrayButtons[]=$bt;
              } else {
                traceLog("button not stored : '$scope' is not a valid scope");
              }
            }
          }
        }
      }
      $globalCatchErrors=false;
      
      if (isset($pluginName)) $this->name=$pluginName;
      if (isset($pluginDescription)) $this->description=$pluginDescription;
      if (isset($pluginVersion)) $this->pluginVersion=$pluginVersion;
      if (isset($pluginCompatibility)) $this->compatibilityVersion=$pluginCompatibility;
      if (isset($pluginUniqueCode)) $this->uniqueCode=$pluginUniqueCode;
      
      $old=self::getFromName($this->name);
      // Must purge previous events stored in Database
      $evt=new PluginTriggeredEvent();
      $evt->purge('idPlugin='.Sql::fmtId($old->id));
      // Must purge previous buttons stored in Database
      $bt=new PluginButton();
      $bt->purge('idPlugin='.Sql::fmtId($old->id));
      
      traceLog("Plugin descriptor information :");
      traceLog(" => name : $this->name");
      traceLog(" => description : $this->description");
      traceLog(" => version : $this->pluginVersion");
      traceLog(" => compatibility : $this->compatibilityVersion");
      
      // Update database for plugIn
      $crit=array('uniqueCode'=>$this->uniqueCode, 'idle'=>'0', 'isDeployed'=>'1');
      $existingPlugin=SqlElement::getSingleSqlElementFromCriteria('Plugin', $crit);
      $currentVersion=($existingPlugin and $existingPlugin->id)?$existingPlugin->pluginVersion:'0.0';
      if (isset($pluginSql) and $pluginSql) {
        if (!is_array($pluginSql)) $pluginSql=array('1.0'=>$pluginSql); // First plugins did not take into account upgrades of SQL
        foreach ($pluginSql as $pluginSqlVersion=>$pluginSqlValue) {
          if ($pluginSqlVersion>$currentVersion or $pluginSqlVersion=='all' or $pluginSqlVersion=='*') {
            $sqlfile=self::getDir()."/$plugin/$pluginSqlValue";
            if (! is_file($sqlfile)) {
              $result=i18n("pluginSqlFileError",array($sqlfile, $plugin));
              errorLog("Plugin::load() : $result");
              return $result;
            }
            // Run Sql defined in Descriptor
            // !IMPORTANT! to be able to call runScrip, the calling script must include "../db/maintenanceFunctions.php"
            $nbErrors=runScript(null,$sqlfile);
            traceLog("Plugin updated database with $nbErrors errors from script $sqlfile");
          }
        }
        deleteDuplicate(); // Avoid dupplicate for habilitation, ....
      }
      
      // Delete zip
      kill($this->zipFile);
      // set previous version to idle (if exists)
      if ($old->id) {
        $old->idle=1;
        $old->save();
      }
      // Save deployment data
      $this->deploymentVersion=Parameter::getGlobalParameter('dbVersion');
      $this->deploymentDate=date('Y-m-d');
      $this->isDeployed=1;
      $this->idle=0;
      $resultSave=$this->save();
      // Now can save events
      foreach ($arrayTriggers as $evt) {
        $evt->idPlugin=$this->id;
        $evt->script=self::getDir().'/'.$this->name.'/'.$evt->script;
        $resEvt=$evt->save();
      }
      // Now can save buttons
      foreach ($arrayButtons as $bt) {
        $bt->idPlugin=$this->id;
        $bt->scriptPHP=self::getDir().'/'.$this->name.'/'.$bt->scriptPHP;
        $resBt=$bt->save();
      }
      
      unsetSessionValue('triggeredEventList'); // Reset triggeredEventList (will be refresed on first need)
      self::$_triggeredEventList=null;
      unsetSessionValue('pluginButtonList'); // Reset triggeredEventList (will be refresed on first need)
      self::$_pluginButtonList=null;
      
      if (isset($pluginPostInstall)) {
        include self::getDir()."/$plugin/$pluginPostInstall";
      }
      
      traceLog("Plugin $plugin V".$this->pluginVersion. " completely deployed");
      if (isset($pluginReload) and $pluginReload) {
        $user=getSessionUser();
        $user->reset();
        setSessionUser($user);
        return 'RELOAD';
      }
      return "OK";
    }
    
    static function getDir() {
      return "../plugin"; 
    }
    
    static function getZipList($oneOnlyFile=null) {
      $error='';
      $dir=self::getDir();
      if (! is_dir($dir)) {
        traceLog ("Plugin->getZipList() - directory '$dir' does not exist");
        $error="Plugin->getZipList() - directory '$dir' does not exist";
      }
      if (! $error) {
        $handle = opendir($dir);
        if (! is_resource($handle)) {
          traceLog ("Plugin->getZipList() - Unable to open directory '$dir' ");
          $error="Plugin->getZipList() - Unable to open directory '$dir' ";
        }
      } 
      $files=array();
      while (!$error and ($file = readdir($handle)) !== false) {
        if ($file == '.' || $file == '..' || $file=='index.php') {
          continue;
        }
        $filepath = ($dir == '.') ? $file : $dir . '/' . $file;
        if (is_link($filepath)) {
          continue;
        }
        if ($oneOnlyFile and $oneOnlyFile!=$file) {
          continue;
        }
        if (is_file($filepath) and strtolower(substr($file,-4))=='.zip') {
          $fileDesc=array('name'=>$file,'path'=>$filepath);
          $dt=filemtime ($filepath);
          $date=date('Y-m-d H:i',$dt);
          $fileDesc['date']=$date;
          $fileDesc['size']=filesize($filepath);
          $files[]=$fileDesc;
        }
      }
      if (! $error) closedir($handle);
      return $files;
    }
    
    public static function getActivePluginList() {
      if (self::$_activePluginList) return self::$_activePluginList;
      // Retreive list from database
      $plugin=new Plugin();
      $pluginList=$plugin->getSqlElementsFromCriteria(array('idle'=>'0'),false,null,null,true);
      self::$_activePluginList=$pluginList;
      return $pluginList;
    }
    public static function getLastVersionPluginList() {
       if (self::$_lastVersionPluginList) return self::$_lastVersionPluginList;
       $result=array();
       $plugin=new Plugin();
       $pluginList=$plugin->getSqlElementsFromCriteria(null,false,null,'id asc',true);
       foreach ($pluginList as $plg) {
         $result[$plg->name]=$plg;
       }
       self::$_lastVersionPluginList=$result;
       return $result;
    }
    public static function isPluginEnabled($pluginName) {
      $listPlugin=self::getLastVersionPluginList();
      if (!isset($listPlugin[$pluginName])) return false;
      $plg=$listPlugin[$pluginName];
      if ($plg->idle) return false;
      return true;
    }
    public static function isPluginInstalled($pluginName) {
      $listPlugin=self::getLastVersionPluginList();
      if (!isset($listPlugin[$pluginName])) return false;
      return true;
    }
    
    public static function getInstalledPluginNames() {
      $dir=self::getDir();
      if (! is_dir($dir)) {
        traceLog ("Plugin->getInstalledPluginNames() - directory '$dir' does not exist");
        return array();
      }
      $handle = opendir($dir);
      if (! is_resource($handle)) {
        return array();
      }
      $files=array();
      while ( ($file = readdir($handle)) !== false) {
        $filepath = ($dir == '.') ? $file : $dir . '/' . $file;
        if (is_dir($filepath)) {
          $files[]=$file;
        }
      }
      closedir($handle);
      return $files;
    } 
    
    public static function includeAllFiles () {
      global $testFlatTheme;
      if (version_compare(Sql::getDbVersion(), 'V5.0.0')<0) return;
      $list=self::getActivePluginList();
      foreach ($list as $plugin) {
        $plugin->includeFiles();
      }
    }
    
    public function includeFiles() {
      $root=self::getDir().'/'.$this->name.'/'.$this->name;
      // Javascript
      $jsFile=$root.'.js';
      if (file_exists($jsFile)) {
        echo '<script type="text/javascript" src="'.$jsFile.'?version='.htmlEncode($this->pluginVersion).'" ></script>';
      }
      // CSS (style sheet)
      $cssFile=$root.'.css';
      if (file_exists($cssFile)) {
        echo '<link rel="stylesheet" type="text/css" href="'.$cssFile.'" />';
      }
    }

    public static function unrelativeDir($dir) {
      return str_replace('../','/',$dir);
    }
    
    public static function getTranslationJsArrayForPlugins($arrayName) {
      global $currentLocale;
      if (version_compare(Sql::getDbVersion(), 'V5.0.0')<0) return;
      $langFileList=array();
      $pluginList=self::getInstalledPluginNames();
      $locale=(isset($currentLocale))?$currentLocale:'';
      foreach ($pluginList as $plugin) {
        $testLocale=Plugin::getDir().'/'.$plugin.'/nls/'.$locale."/lang.js";
        $testDefault=Plugin::getDir().'/'.$plugin."/nls/lang.js";
        if ($locale and file_exists($testLocale)) {
          $langFileList[$plugin]=$testLocale;
        } else if (file_exists($testDefault)){
          $langFileList[$plugin]=$testDefault;
        }
      }
      echo "$arrayName=new Array();\n";
      foreach ($langFileList as $testFile) {
        if (file_exists ( $testFile )) {
          $filename = $testFile;
          $file = fopen ( $filename, "r" );
          while ( $line = fgets ( $file ) ) {
            $split = explode ( ":", $line );
            if (isset ( $split [1] )) {
              $var = trim ( $split [0], " \t" ); // Remove tabs and spaces
              $valTab = explode ( ",", $split [1] );
              $val = trim ( $valTab [0], " \n\r" ); // Remove spaces, carriage returns and new lines
              $val = trim ( $val, '"' );
              //$i18nMessages [$var] = $val;
              echo $arrayName.'["'.$var.'"]="'.$val.'";'."\n";
            }
          }
          fclose ( $file );
        }
      }
    }
    public static function getMetadata($zipFileName) {
      $file=self::getDir().'/'.$zipFileName;
      $zip = new ZipArchive;
      $globalCatchErrors=true;
      $res = $zip->open($file);
      $descriptorXml="";
      if ($res === TRUE) {
        $idx=$zip->locateName('pluginDescriptor.xml',ZIPARCHIVE::FL_NODIR);
        $descriptorXml=$zip->getFromIndex($idx);
        $zip->close();
      }
      $parse = xml_parser_create();
      xml_parse_into_struct($parse, $descriptorXml, $value, $index);
      xml_parser_free($parse);
      $data=array();
      foreach($value as $ind=>$prop) {
        if ($prop['tag']=='PROPERTY') {
          $name='plugin'.ucfirst($prop['attributes']['NAME']);
          $value=$prop['attributes']['VALUE'];
          $data[$name]=$value;
        }
      }
      return $data;
    }
    
    public static function getEventScripts($event, $className) {
      global $remoteDb;
      if (isset($remoteDb) and $remoteDb) return array();
      if (version_compare(Sql::getDbVersion(), 'V5.2.0')<0) return array();
      if (!self::$_triggeredEventList) {
        self::getTriggeredEventList();
      }
      if (isset(self::$_triggeredEventList[$event][$className])) {
        return self::$_triggeredEventList[$event][$className];
      } else {
        return array();
      }
    }
    
    private static function getTriggeredEventList() {
      global $remoteDb;
      if (isset($remoteDb) and $remoteDb) {
        self::$_triggeredEventList=array();
        return;
      }
      $sessionList=getSessionValue('triggeredEventList',null,true);
      if ($sessionList) {
        self::$_triggeredEventList=$sessionList;
        return;
      }
      $listActivePlugin=self::getActivePluginList();
      $evt=new PluginTriggeredEvent();
      $listEvt=$evt->getSqlElementsFromCriteria(array('idle'=>'0'));
      self::$_triggeredEventList=array();
      foreach ($listEvt as $evt) {
        if (!isset(self::$_triggeredEventList[$evt->event])) {
          self::$_triggeredEventList[$evt->event]=array();
        }
        if (!isset(self::$_triggeredEventList[$evt->event][$evt->className])) {
          self::$_triggeredEventList[$evt->event][$evt->className]=array();
        }
        self::$_triggeredEventList[$evt->event][$evt->className][$evt->id]=$evt->script;
      }
      setSessionValue('triggeredEventList', self::$_triggeredEventList); // save to session for quick access
    }
    
    public static function getButtons($scope, $className) {
      global $remoteDb;
      if (isset($remoteDb) and $remoteDb) return array();
      if (version_compare(Sql::getDbVersion(), 'V8.0.0')<0) return array();
      if (!self::$_pluginButtonList) {
        self::getButtonsList();
      }
      if (isset(self::$_pluginButtonList[$scope][$className])) {
        return self::$_pluginButtonList[$scope][$className];
      } else {
        return array();
      }
    }
    
    private static function getButtonsList() {
      global $remoteDb;
      if (isset($remoteDb) and $remoteDb) {
        self::$_pluginButtonList=array();
        return;
      }
      $sessionList=getSessionValue('pluginButtonList',null,true);
      if ($sessionList) {
        self::$_pluginButtonList=$sessionList;
        return;
      }
      $listActivePlugin=self::getActivePluginList();
      $bt=new PluginButton();
      $listBt=$bt->getSqlElementsFromCriteria(array('idle'=>'0'),null,null,'sortOrder asc');
      self::$_pluginButtonList=array();
      foreach ($listBt as $bt) {
        if (!isset(self::$_pluginButtonList[$bt->scope])) {
          self::$_pluginButtonList[$bt->scope]=array();
        }
        if (!isset(self::$_pluginButtonList[$bt->scope][$bt->className])) {
          self::$_pluginButtonList[$bt->scope][$bt->className]=array();
        }
        self::$_pluginButtonList[$bt->scope][$bt->className][]=$bt;
      }
      setSessionValue('pluginButtonList', self::$_pluginButtonList); // save to session for quick access
    }
    
    public static function checkPluginCompatibility($version) {
      // CHECK PLUGIN COMPATIBILITY
      foreach (self::$pluginRequiredVersion as $versTest=>$plugins) {
        if (self::afterVersion($version,$versTest)) {
          foreach ($plugins as $namePlg=>$versPlgRequired) {
            $plg=SqlElement::getSingleSqlElementFromCriteria('Plugin', array('name'=>$namePlg, 'idle'=>'0'));
            if ($plg and $plg->id and self::beforeVersion($plg->pluginVersion,$versPlgRequired)) {
              $plg->idle=1;
              $plg->save();
              echo '<div class="message'.(($versPlgRequired=="99.0")?'OK':'WARNING').'">';
              traceLog("=== PLUGIN COMPATIBILITY ISSUE =====================================");                          
              if ($versPlgRequired=="99.0") {
                traceLog("The plug-in $namePlg is now integrated in community version.");
                echo i18n("pluginIntegratedInCommunityVersion",array("<b>$namePlg</b>"));
              } else {
                traceLog("Plugin $namePlg version $plg->pluginVersion is not compatible with ProjeQtOr $version.");
                traceLog("It has been desactivated. Please install version $versPlgRequired or over.");
                echo i18n("pluginNotCompatibleWithCurrentVersion",array("<b>$namePlg</b>",$plg->pluginVersion,$version,$versPlgRequired));
              }
              echo '</div>';
              
            }
          }
        }
      }
    }
    
    public function checkProjeQtOrCompatibility() {
      $version=Sql::getDbVersion();
      $plgName=$this->name;
      $plgVersion=$this->pluginVersion;
      $result="";
      foreach (self::$pluginRequiredVersion as $versTest=>$plugins) {
        if (self::afterVersion($version,$versTest)) {
          foreach ($plugins as $compPlgName=>$compPlgVersion) {
            if ($compPlgName==$plgName) {
              if (beforeVersion($plgVersion, $compPlgVersion)) {
                //$result.=($result!="")?'<br/>':''; // Will display only lkast version to install
                if ($compPlgVersion=="99.0") {
                  $result=i18n("pluginIntegratedInCommunityVersion",array("<b>$plgName</b>"));
                } else {
                  $result=i18n("pluginNotCompatibleWithCurrentVersion",array("<b>$plgName</b>",$plgVersion,$version,$compPlgVersion));
                }
              }
            }
          }
        }
      }
      if ($result) return $result;
      return "OK";
    }
    
    private static function beforeVersion($V1,$V2) {
      $V1=ltrim($V1,'V');
      $V2=ltrim($V2,'V');
      return(version_compare($V1, $V2,"<"));
    }
    
    private static function afterVersion($V1,$V2) {
      $V1=ltrim($V1,'V');
      $V2=ltrim($V2,'V');
      return(version_compare($V1, $V2,">="));
    }
    
    public static function checkCustomDefinition($paramClass=null) {
      global $lastFixedField;
      $list=array();
      if ($paramClass) {
        $list[]=$paramClass;
      } else {
          $dir='../model/custom/';
          $handle = opendir($dir);
          while ( ($file = readdir($handle)) !== false) {
            if ($file == '.' || $file == '..' || $file=='index.php'   // exclude ., .. and index.php
                || substr($file,-4)!='.php'                           // exclude non php files
                || substr($file,0,1)=='Plg'                           // exclude custom Plugin files
                || substr($file,0,1)=='_') {                          // exclude the _securityCheck.php
              continue;
            }
            $class=pathinfo($file,PATHINFO_FILENAME);
            $list[]=$class;
          }
          closedir($handle);
      }
      $errorClass=array();
      foreach ($list as $class) {
        $obj=new $class();
        if (method_exists($obj,'setAttributes')) $obj->setAttributes();
        $last=false;
        foreach ($obj as $fld=>$val) {
          if ($fld=='_Note' or $fld=='_Link' or $fld=='_Attachment' or $fld=='_sec_Link' or $fld=='_OtherClient' or $fld=='_nbColMax') {
            $last=true;
//           } else if (substr($fld, 0,1)=='_') {
//             continue; // specific field
          } else if ($last and ! $obj->isAttributeSetToField($fld,'hidden')) { // not a specific field, after $last (notes, attachment, link)
            $errorClass[]=$class;
            break;
          }
        }
      }
      if (count($errorClass)==0) {
        return "OK";
      } else {
        echo '<br/><div class="messageWARNING" style="text-align:left;height:'.(($paramClass)?'75':'43').'px">';
        traceLog("=== SCREEN CUSTOMIZATION ISSUE =====================================");
        $msg=i18n("screenCustomizationErrorExist");
        if (substr($msg,0,1)=='[') $msg="Some screen customizations are not consistent any more with current version";
        echo "$msg :<br/>";
        traceLog("$msg :");
        $allFixed=true;
        foreach ($errorClass as $class) {
          echo " - ".i18n($class);
          traceLog(" - ".i18n($class));
          if (function_exists('screenCustomizationFixDefinition')) {
            if (screenCustomizationFixDefinition($class)=='OK') {
            } else {
              $allFixed=false;
            }
          } else {
            $allFixed=false;
          }
          echo "<br/>";
        }
        if (!$allFixed) {
          $msg=i18n("screenCustomizationErrorRemaining");
          if (substr($msg,0,1)=='[') $msg="Please access each screen on customization plugin to fix the issue (Plugin V6.1 or over is required)";
          echo $msg;
          traceLog($msg);
        } else {
          $msg=i18n("screenCustomizationErrorFixed");
          if (substr($msg,0,1)=='[') $msg="Screen customizations have been fixed automatically ;)";
          echo $msg;
          if ($paramClass) {
            echo "<div style='width:100%;height;20px;text-align:center;font-weight:bold;color:red;padding-top:10px;'>".i18n('fixCustoRetry')."</div>";
          }
          $plgCusto=SqlElement::getSingleSqlElementFromCriteria('Plugin', array('name'=>'screenCustomization','idle'=>'0'));
          if ($plgCusto and $plgCusto->id and self::afterVersion($plgCusto->pluginVersion,'6.1')) {
            echo "<input type='hidden' id='pluginCustomFixDefinition' value='$class".'::'."$lastFixedField' />";
          } else {
            
          }
          traceLog($msg);
        }
        echo '</div>';
        return ($allFixed)?"OK":"KO";
      }
    }
}
