1: <?php
  2: /**
  3:  * This file contains abstract class for update plugins
  4:  *
  5:  * @package Plugin
  6:  * @subpackage PluginManager
  7:  * @author Frederic Schneider
  8:  * @copyright four for business AG <www.4fb.de>
  9:  * @license http://www.contenido.org/license/LIZENZ.txt
 10:  * @link http://www.4fb.de
 11:  * @link http://www.contenido.org
 12:  */
 13: 
 14: defined('CON_FRAMEWORK') || die('Illegal call: Missing framework initialization - request aborted.');
 15: 
 16: /**
 17:  * Update class for existing plugins, extends PimPluginSetup
 18:  *
 19:  * @package Plugin
 20:  * @subpackage PluginManager
 21:  * @author frederic.schneider
 22:  */
 23: class PimPluginSetupUpdate extends PimPluginSetup {
 24: 
 25:     // Classes
 26:     /**
 27:      * Variable for PIM class PimPluginCollection
 28:      *
 29:      * @var PimPluginCollection
 30:      */
 31:     protected $_PimPluginCollection;
 32: 
 33:     /**
 34:      * Initializing and set variable for PimPluginCollection class
 35:      *
 36:      * @return PimPluginCollection
 37:      */
 38:     private function _setPimPluginCollection() {
 39:         return $this->_PimPluginCollection = new PimPluginCollection();
 40:     }
 41: 
 42:     // Begin of update routine
 43:     /**
 44:      * Construct function
 45:      */
 46:     public function __construct() {
 47: 
 48:         // Initializing and set classes
 49:         // PluginManager classes
 50:         $this->_setPimPluginCollection();
 51: 
 52:         // Check same plugin (uuid)
 53:         $this->_checkSamePlugin();
 54: 
 55:         // Check for update specific sql files
 56:         $this->_updateSql();
 57: 
 58:         // Delete "old" plugin
 59:         $delete = new PimPluginSetupUninstall();
 60:         $delete->uninstall();
 61: 
 62:         // Install new plugin
 63:         $new = new PimPluginSetupInstall();
 64:         $new->install();
 65: 
 66:         // Success message
 67:         parent::info(i18n('The plugin has been successfully updated. To apply the changes please login into backend again.', 'pim'));
 68:     }
 69: 
 70:     /**
 71:      * Check uuId: You can update only the same plugin
 72:      */
 73:     private function _checkSamePlugin() {
 74:         $this->_PimPluginCollection->setWhere('idplugin', parent::_getPluginId());
 75:         $this->_PimPluginCollection->query();
 76:         while ($result = $this->_PimPluginCollection->next()) {
 77: 
 78:             if (parent::$XmlGeneral->uuid != $result->get('uuid')) {
 79:                 parent::error(i18n('You have to update the same plugin', 'pim'));
 80:             }
 81:         }
 82:     }
 83: 
 84:     /**
 85:      * Check for update specific sql files.
 86:      * If some valid sql file available, PIM does not run uninstall and install
 87:      * sql files.
 88:      */
 89:     private function _updateSql() {
 90:         $cfg = cRegistry::getConfig();
 91:         $db = cRegistry::getDb();
 92: 
 93:         // Build sql filename with installed plugin version and new plugin
 94:         // version, i. e.: "plugin_update_100_to_101.sql" (without dots)
 95:         $tempSqlFilename = "plugin_update_" . str_replace('.', '', $this->_getInstalledPluginVersion()) . "_to_" . str_replace('.', '', parent::$XmlGeneral->version) . ".sql";
 96: 
 97:         // Filename to update sql file
 98:         $tempSqlFilename = parent::$_PimPluginArchiveExtractor->extractArchiveFileToVariable($tempSqlFilename, 0);
 99: 
100:         if (cFileHandler::exists($tempSqlFilename)) {
101: 
102:             // Execute update sql file
103:             $tempSqlContent = cFileHandler::read($tempSqlFilename);
104:             $tempSqlContent = str_replace("\r\n", "\n", $tempSqlContent);
105:             $tempSqlContent = explode("\n", $tempSqlContent);
106:             $tempSqlLines = count($tempSqlContent);
107: 
108:             $pattern = '/^(CREATE TABLE IF NOT EXISTS|INSERT INTO|UPDATE|ALTER TABLE) `?' . parent::SQL_PREFIX . '`?\b/';
109: 
110:             for ($i = 0; $i < $tempSqlLines; $i++) {
111:                 if (preg_match($pattern, $tempSqlContent[$i])) {
112:                     $tempSqlContent[$i] = str_replace(parent::SQL_PREFIX, $cfg['sql']['sqlprefix'] . '_pi', $tempSqlContent[$i]);
113:                     $db->query($tempSqlContent[$i]);
114:                 }
115:             }
116: 
117:             // Do not run uninstall and install sql files
118:             PimPluginSetup::_setUpdateSqlFileExist(true);
119:         } else {
120:             return false;
121:         }
122:     }
123: 
124:     /**
125:      * Get installed plugin version
126:      */
127:     private function _getInstalledPluginVersion() {
128:         $this->_PimPluginCollection->setWhere('idplugin', parent::_getPluginId());
129:         $this->_PimPluginCollection->query();
130:         while ($result = $this->_PimPluginCollection->next()) {
131:             return $result->get('version');
132:         }
133:     }
134: 
135: }