'modules' => array('content','core','forum')

<?xml version="1.0"?>
<config>
    <name>content</name>
    <version>1.0.0</version>
    <creationDate>2009-03-27</creationDate>
    <author>SpiRi7</author>
    <authorEmail>alex@spiri7.net</authorEmail>
    <authorUrl>http://spiri7.net</authorUrl>
    <copyright></copyright>
    <license></license>
    <description>Content module</description>
</config>

return array(
	'basePath'=>dirname(__FILE__).DIRECTORY_SEPARATOR.'..',
	'name'=>'Yii-Web',
	'preload'=>array('log'),
	'import'=>array(
		'application.models.*',
		'application.components.*',
	),
 
	// application components
	'components'=>array(
		'user'=>array(
			// enable cookie-based authentication
			'allowAutoLogin'=>true,
                        'loginUrl'=>array('admin/core/dashboard/login'),
		),
		'db'=>array(
                    'class'=>'system.db.CDbConnection',
                    'connectionString'=>'mysql:host=localhost;dbname=yii_test',
                    'username'=>'root',
                    'password'=>'',
                    'charset'=>'utf8',
                    'tablePrefix' => ''
		),
		'errorHandler'=>array(
                        'errorAction'=>'site/error',
                ),
		'log'=>array(
			'class'=>'CLogRouter',
			'routes'=>array(
				array(
					'class'=>'CFileLogRoute',
					'levels'=>'error, warning',
				),
			),
		),
	),
        'theme' => 'classic',
        'language' => 'ru',
	'params'=>array(
		// this is used in contact page
		'adminEmail'=>'webmaster@example.com',
	),
);

 return array(
 'modules' => array('content','core','invoice',)
);

return CMap::mergeArray(
    require(dirname(__FILE__).'/config.php'), 
    require(dirname(__FILE__).'/modules.php')
);

CREATE TABLE  `yii_test`.`core_resource` (
  `resource` varchar(50) NOT NULL,
  `version_installed` varchar(50) DEFAULT NULL,
  `version_available` varchar(50) DEFAULT NULL,
  `need_install` tinyint(2) NOT NULL DEFAULT '0',
  `need_upgrade` tinyint(2) NOT NULL DEFAULT '0',
  `need_uninstall` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`resource`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC

class InstallController extends AdminController {
    /**
     * @var CActiveRecord the currently loaded data model instance.
     */
    private $_model;
 
    /**
     * @return array action filters
     */
    public function filters() {
        return array(
                'accessControl', // perform access control for CRUD operations
        );
    }
 
    /**
     * Specifies the access control rules.
     * This method is used by the 'accessControl' filter.
     * @return array access control rules
     */
    public function accessRules() {
        return array(
                array('allow', // allow authenticated user to perform all actions
                        'users'=>array('admin'),
                ),
                array('deny',  // deny all users
                        'users'=>array('*'),
                ),
        );
    }
 
    /**
     * Lists of all installed modules.
     */
    public function actionIndex() {
 
        $model = new Resource();
 
        // Refresh backend menu manager
        // Refreshing installing modules
        $model->refreshModuleList();
 
        $dataProvider=new CActiveDataProvider('Resource', array());
 
        $this->render('resources',array(
                'dataProvider'=>$dataProvider
        ));
    }
 
    /**
     * Process install/upgrade/uninstall action
     */
    public function actionProcess() {
        $resourceName = $_GET['resource'];
        $actionName = $_GET['action'];
        $model = new Resource();
        $newVersion = $model->updateResource($resourceName, $actionName);
 
        Yii::app()->user->setFlash('success',"Module <b>".$resourceName."</b> success ".$actionName.". SQL script version: ".$newVersion);
        $this->redirect(Yii::app()->createUrl("admin/core/install/index"));
    }
}

<?php $this->widget('zii.widgets.grid.CGridView', array(
	'id'=>'articles-grid',
	'dataProvider'=>$dataProvider,
	'columns'=>array(
		'resource',
		'version_installed',
                'version_available',
		array(
			'class'=>'CButtonColumn',
                        'buttons'=>array(
                                'install'=>array(
                                    'label'=>'Install',
                                    'visible'=>'($data->need_install == 1)?true:false',
                                    'url'=> 'Yii::app()->createUrl("admin/core/install/process", array("resource"=>$data->resource,"action"=>"install"))',
                                ),
                                'upgrade'=>array(
                                    'label'=>'Upgrade',
                                    'visible'=>'($data->need_upgrade == 1)?true:false',
                                    'url'=> 'Yii::app()->createUrl("admin/core/install/process", array("resource"=>$data->resource,"action"=>"upgrade"))',
                                ),
                                'uninstall'=>array(
                                    'label'=>'Uninstall',
                                    'visible'=>'($data->need_install == 0)?true:false',
                                    'url'=> 'Yii::app()->createUrl("admin/core/install/process", array("resource"=>$data->resource,"action"=>"uninstall"))',
                                ),
                         ),
                         'template'=>'{install}{upgrade}{uninstall}',
 
		),
 
	),
)); ?>

<?php
class Resource extends CActiveRecord {
 
    const VERSION_COMPARE_EQUAL   = 0;
    const VERSION_COMPARE_LOWER   = -1;
    const VERSION_COMPARE_GREATER = 1;
 
 
    protected $isUpdated = false;
    /**
     * Returns the static model of the specified AR class.
     * @return CActiveRecord the static model class
     */
    public static function model($className=__CLASS__) {
        return parent::model($className);
    }
 
    /**
     * @return string the associated database table name
     */
    public function tableName() {
        return 'core_resource';
    }
 
    /**
     * @return array customized attribute labels (name=>label)
     */
    public function attributeLabels() {
        return array(
                'resource' => 'Module',
                'version_installed' => 'Installed',
                'version_available' => 'Available',
                'need_install' => 'Need install',
                'need_upgrade' => 'Need upgrade',
                'need_uninstall' => 'Need delete',
        );
    }
 
    /**
     * Refreshing all installed modules list
     */
    public function  refreshModuleList() {
        $connection = Yii::app()->db;
 
        // Clear field that need to install (flag need_install=1)
        $command =  $connection->createCommand("DELETE FROM {{core_resource}} WHERE need_install = 1");
        $command->execute();
 
        // Get all modules configuration files (configuration stored as xml file)
        $configFileList = glob(YiiBase::getPathOfAlias('application.config.modules')."/*.xml");
        // Create config files array of items module=>version
        $installedFileModules = array();
        foreach ($configFileList as $singleConfigFile) {
 
            $config = new SimpleXMLElement($singleConfigFile, NULL, true);
            $installedFileModules[(String)$config->name] = (String)$config->version;
        }
 
        // Get module config array from DB module=>version
        $installedDbModules = array();
        $records = $this->findAll();
        foreach ($records as $recordItem) {
            $installedDbModules[$recordItem->resource] = $recordItem['version_installed'];
        }
 
        // Determinate what modules need to be installed or upgraded
        $updateToDatabase = array();
        foreach ($installedFileModules as $configModuleName => $configVersion) {
            $singleDbUpdate = array(
                    'resource' => $configModuleName,
                    'version_installed' => '',
                    'version_available' => $configVersion,
                    'need_install' => 0,
                    'need_upgrade' => 0,
                    'need_uninstall' => 0,
            );
            if (isset($installedDbModules[$configModuleName])) {
                // Have such module installed into DB
                $status =  version_compare($configVersion, $installedDbModules[$configModuleName] );
                switch ($status) {
                    case self::VERSION_COMPARE_LOWER:
                    //$this->_rollbackResourceDb($configVer, $dbVer);
                        break;
                    case self::VERSION_COMPARE_GREATER:
                    // Need update this module
                        $singleDbUpdate['need_upgrade'] = 1 ;
                        break;
                }
                $singleDbUpdate['version_installed'] = $installedDbModules[$configModuleName];
            } else {
                $singleDbUpdate['need_install'] = 1 ;
            }
            $updateToDatabase[] = $singleDbUpdate;
        }
 
        // Determinate what modules need to be unistalled (no config file found)
        foreach ($installedDbModules as $dbModuleName => $dbVersion) {
            if (!isset($installedFileModules[$dbModuleName])) {
                $singleDbUpdate = array(
                        'resource' => $dbModuleName,
                        'version_installed' => $dbVersion,
                        'version_available' => '',
                        'need_install' => 0,
                        'need_upgrade' => 0,
                        'need_uninstall' => 1,
                );
                $updateToDatabase[] = $singleDbUpdate;
            }
        }
 
        // Process update to DB
        // Clear all records
        $command =  $connection->createCommand("DELETE FROM {{core_resource}}");
        $command->execute();
 
        $sql = "INSERT INTO {{core_resource}} (`resource`, `version_installed`, `version_available`, `need_install`, `need_upgrade`, `need_uninstall`) VALUES ";
        foreach ($updateToDatabase as $singleUpdate) {
            $sql.="('".$singleUpdate['resource']."','".$singleUpdate['version_installed']."','".$singleUpdate['version_available']."', ".$singleUpdate['need_install'].", ".$singleUpdate['need_upgrade'].", ".$singleUpdate['need_uninstall']."),";
 
        }
        $sql = substr($sql,0, -1).';';
        // Insert new list of modules
        $command =  $connection->createCommand($sql)->execute();
 
        // Update module list that installed to system
        // Create string with php code
        $installedModulesAsPhpArray = "<?php\n return array(\n 'modules' => array(";
        foreach ($updateToDatabase as $singleUpdate) {
            if ($singleUpdate['need_install'] == 0 && $singleUpdate['need_uninstall'] == 0) {
                // Write only modules that installed to system
                $installedModulesAsPhpArray.="'".$singleUpdate['resource']."',";
            }
        }
        $installedModulesAsPhpArray.=")\n);";
        // Need to have write permission to file config/modules.php
        $fh = fopen(YiiBase::getPathOfAlias('application.config')."/modules.php", "w");
        fwrite($fh, $installedModulesAsPhpArray);
        fclose($fh);
 
    }
 
    /**
     * Make modifaction for module. Possible to install/upgrade/uninstall module.
     *
     * @param String $resourceName module name that need to perform $action
     * @param String $action action to perform install/upgrade/uninstall
     * @return real version that proccessed after update
     */
    public function updateResource($resourceName, $action) {
        $resource = $this->findByPk($resourceName);
        $version = $this->_modifyResourceDb($resourceName, $action, $resource['version_installed'], $resource['version_available']);
 
        if ($action!="uninstall") {
            // After execute all sql file, update resource information for install/upgrade
            $sql = "UPDATE {{core_resource}} SET version_installed='".$resource['version_available']."'  WHERE resource='".$resourceName."'";
            Yii::app()->db->createCommand($sql)->execute();
        } else {
            // for uninstall delete from table this resource
            Yii::app()->db->createCommand("DELETE FROM {{core_resource}} WHERE resource='".$resourceName."'")->execute();
        }
 
        // Return real updated version
        return $version;
    }
 
    /**
     * Run module modification files. Return version of last applied upgrade (false if no upgrades applied)
     *
     * @param     string $actionType install|upgrade|uninstall
     * @param     string $fromVersion
     * @param     string $toVersion
     * @return    string | false
     */
    protected function _modifyResourceDb($resourceName, $actionType, $fromVersion, $toVersion) {
        $sqlFilesDir = YiiBase::getPathOfAlias('application.modules.'.$resourceName.'.setup'); 
        if (!is_dir($sqlFilesDir) || !is_readable($sqlFilesDir)) {
            return false;
        }
 
        // Read resource files
        $arrAvailableFiles = array();
        $fileToDir = glob($sqlFilesDir."/".$actionType."-*.sql");
        foreach($fileToDir as $sqlFile) {
            $matches = array();
            if (preg_match('#.*'.$actionType.'-(.*)\.sql$#i', $sqlFile, $matches)) {
                $arrAvailableFiles[$matches[1]] = $sqlFile;
            }
        }
 
        if (empty($arrAvailableFiles)) {
            return false;
        }
 
        // Get SQL files name
        $arrModifyFiles = $this->_getModifySqlFiles($actionType, $fromVersion, $toVersion, $arrAvailableFiles);
        if (empty($arrModifyFiles)) {
            return false;
        }
 
        $modifyVersion = false;
        $connection = Yii::app()->db;
        // $connection->pdoInstance->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
 
        foreach ($arrModifyFiles as $resourceFile) {
            try {
                ob_start();
                include_once($resourceFile['fileName']);
                $sql = ob_get_contents();
                @ob_end_clean();
 
                if ($sql!='') {
                    $command1 =  $connection->createCommand($sql);
                    $command1->execute();
                    // For some pdo adapter on next sql query show error
                    $command1->getPdoStatement()->closeCursor();
                }
                // Update Database module version
                $sql = "UPDATE {{core_resource}} SET version_installed='".$resourceFile['toVersion']."'  WHERE resource='".$resourceName."'";
                $connection->createCommand($sql)->execute();
            } catch (Exception $e) {
                $message = 'Error in file: "'.$resourceFile['fileName'].'" - '.$e->getMessage();
                throw new Exception($message);
            }
            $modifyVersion = $resourceFile['toVersion'];
        }
        // On final marked resource as not need install
        $sql = "UPDATE {{core_resource}} SET need_install = 0 WHERE resource='".$resourceName."'";
        $connection->createCommand($sql)->execute();
        return $modifyVersion;
    }
 
 
    /**
     * Get sql files for modifications
     *
     * @param     $actionType
     * @return    array
     */
    protected function _getModifySqlFiles($actionType, $fromVersion, $toVersion, $arrFiles) {
        $arrRes = array();
 
        switch ($actionType) {
            case 'install':
                uksort($arrFiles, 'version_compare');
                foreach ($arrFiles as $version => $file) {
                    if (version_compare($version, $toVersion) !== self::VERSION_COMPARE_GREATER) {
                        $arrRes[0] = array('toVersion'=>$version, 'fileName'=>$file);
                    }
                }
                break;
 
            case 'upgrade':
                uksort($arrFiles, 'version_compare');
                foreach ($arrFiles as $version => $file) {
                    $version_info = explode('-', $version);
 
                    // In array must be 2 elements: 0 => version from, 1 => version to
                    if (count($version_info)!=2) {
                        break;
                    }
                    $infoFrom = $version_info[0];
                    $infoTo   = $version_info[1];
                    if (version_compare($infoFrom, $fromVersion)!==self::VERSION_COMPARE_LOWER
                            && version_compare($infoTo, $toVersion)!==self::VERSION_COMPARE_GREATER) {
                        $arrRes[] = array('toVersion'=>$infoTo, 'fileName'=>$file);
                    }
                }
                break;
            case 'uninstall':
                uksort($arrFiles, 'version_compare');
                foreach ($arrFiles as $version => $file) {
                    if (version_compare($version, $fromVersion) !== self::VERSION_COMPARE_GREATER) {
                        $arrRes[0] = array('toVersion'=>$version, 'fileName'=>$file);
                    }
                }
                break;
 
            case 'rollback':
            // @todo support rollback
                break;
        }
        return $arrRes;
    }
}