<?php
/**
* ext_modules.php
*
* @package ext_modules
* @copyright Copyright 2004-2012 Andrew Berezin eCommerce-Service.com
* @copyright Copyright 2003-2012 Zen Cart Development Team
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @link http://partner.market.yandex.ru/legal/tt/
* @version $Id: ext_modules.php, v 1.3 07.08.2011 19:54:52 AndrewBerezin $
*/
class ext_modules {
public $configuration_group_id = null;
public $prefix = null;
public $configUpdates = array();
function install_configuration_group($prefix, $language_key, $configuration_group_description='', $page_key='') {
global $db;
$this->prefix = $prefix;
$prefix = str_replace('_', '\_', $this->prefix);
$sql = "SELECT configuration_group_id
FROM " . TABLE_CONFIGURATION . "
WHERE configuration_key LIKE ':prefix:%'
GROUP BY configuration_group_id";
$sql = $db->bindVars($sql, ':prefix:', $prefix, 'noquotestring');
$configuration_group_id = $db->Execute($sql);
if ($configuration_group_id->RecordCount() > 1) {
return false;
}
if (!$configuration_group_id->EOF) {
$this->configuration_group_id = $configuration_group_id->fields['configuration_group_id'];
} else {
$sql = "INSERT INTO " . TABLE_CONFIGURATION_GROUP . " (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, :language_key:, :configuration_group_description:, '1', '1')";
$sql = $db->bindVars($sql, ':language_key:', constant($language_key), 'string');
$sql = $db->bindVars($sql, ':configuration_group_description:', $configuration_group_description, 'string');
$db->Execute($sql);
$this->configuration_group_id = $db->insert_ID();
$sql = "UPDATE " . TABLE_CONFIGURATION_GROUP . " SET sort_order = :configuration_group_id: WHERE configuration_group_id = :configuration_group_id: LIMIT 1";
$sql = $db->bindVars($sql, ':configuration_group_id:', $this->configuration_group_id, 'integer');
$db->Execute($sql);
}
if ($page_key != '') {
$admin_page = array(
'page_key' => $page_key,
'language_key' => $language_key,
'main_page' => 'FILENAME_CONFIGURATION',
'page_params' => 'gID=' . $this->configuration_group_id,
'menu_key' => 'configuration',
'display_on_menu' => 'Y',
'sort_order' => $this->configuration_group_id,
);
$this->install_admin_pages($admin_page);
}
return $this->configuration_group_id;
}
function install_configuration($configuration) {
global $db;
global $messageStack;
$sql = "SELECT * FROM " . TABLE_CONFIGURATION . " WHERE configuration_group_id=:configuration_group_id:";
$sql = $db->bindVars($sql, ':configuration_group_id:', $this->configuration_group_id, 'integer');
$configuration_key = $db->Execute($sql);
$checkArray = array();
$this->configUpdates = array('del' => array(), 'add' => array(), 'upd' => array(), );
while (!$configuration_key->EOF) {
if (!isset($configuration[$configuration_key->fields['configuration_key']])) {
$this->configUpdates['del'][] = $configuration_key->fields['configuration_key'] . " - " . $sql_array['configuration_title'];
$sql = "DELETE FROM " . TABLE_CONFIGURATION . " WHERE configuration_id=:configuration_id:";
$sql = $db->bindVars($sql, ':configuration_id:', $configuration_key->fields['configuration_id'], 'integer');
$db->Execute($sql);
} elseif (isset($checkArray[$configuration_key->fields['configuration_key']])) {
$sql = "DELETE FROM " . TABLE_CONFIGURATION . " WHERE configuration_id=:configuration_id:";
$sql = $db->bindVars($sql, ':configuration_id:', $configuration_key->fields['configuration_id'], 'integer');
$db->Execute($sql);
} else {
$checkArray[$configuration_key->fields['configuration_key']] = $configuration_key->fields;
}
$configuration_key->MoveNext();
}
foreach ($configuration as $configKey => $configSql) {
list($configuration_title, $configuration_value, $configuration_description, $sort_order, $use_function, $set_function, $configuration_group_id) = $configSql;
if (!isset($configuration_group_id) || $configuration_group_id == 0) {
$configuration_group_id = $this->configuration_group_id;
}
if (!isset($checkArray[$configKey])) {
$sql_array = array(
'configuration_key' => $configKey,
'configuration_group_id' => $configuration_group_id,
'configuration_title' => $configuration_title,
'configuration_value' => $configuration_value,
'configuration_description' => $configuration_description,
'sort_order' => $sort_order,
'use_function' => $use_function,
'set_function' => $set_function,
'date_added' => 'now()',
);
$this->configUpdates['add'][] = $sql_array['configuration_key'] . " - " . $sql_array['configuration_title'];
define($sql_array['configuration_key'], $sql_array['configuration_value']);
zen_db_perform(TABLE_CONFIGURATION, $sql_array);
} else {
$sql_array = array();
if ($configuration_title != $checkArray[$configKey]['configuration_title']) {
$sql_array['configuration_title'] = $configuration_title;
}
if ($configuration_value != $checkArray[$configKey]['configuration_value'] && substr($configKey, -8) == '_VERSION') {
$sql_array['configuration_value'] = $configuration_value;
}
if ($configuration_description != $checkArray[$configKey]['configuration_description']) {
$sql_array['configuration_description'] = $configuration_description;
}
if ($sort_order != $checkArray[$configKey]['sort_order']) {
$sql_array['sort_order'] = $sort_order;
}
if ($use_function != $checkArray[$configKey]['use_function']) {
$sql_array['use_function'] = $use_function;
}
if ($set_function != $checkArray[$configKey]['set_function']) {
$sql_array['set_function'] = $set_function;
}
if (sizeof($sql_array) > 0) {
$sql_array['last_modified'] = 'now()';
$this->configUpdates['upd'][] = $configKey . " - " . $configuration_title;
zen_db_perform(TABLE_CONFIGURATION, $sql_array, 'update', "configuration_key='" . zen_db_input($configKey) . "'");
}
}
}
}
function install_db_table($table, $install_sql) {
global $db;
if (strtolower(DB_CHARSET) == 'utf8') {
$install_sql = str_replace(') ENGINE=MyISAM;', ') ENGINE=MyISAM /*!40101 DEFAULT CHARSET=utf8 */;', $install_sql);
}
$check_query = $db->Execute("SHOW TABLES LIKE '" . $table . "'");
if ($check_query->EOF) {
$db->Execute($install_sql);
} else {
$install_sql = str_replace("CREATE TABLE IF NOT EXISTS `" . $table . "` (", "CREATE TABLE IF NOT EXISTS `" . $table . "_temp` (", $install_sql);
$db->Execute($install_sql);
$show_columns = $db->Execute("SHOW CREATE TABLE `" . $table . "`");
$tableFieldsOld = explode("\n", $show_columns->fields['Create Table']);
unset($tableFieldsOld[0]);
unset($tableFieldsOld[sizeof($tableFieldsOld)]);
$show_columns = $db->Execute("SHOW CREATE TABLE `" . $table . "_temp`");
$tableFieldsNew = explode("\n", $show_columns->fields['Create Table']);
unset($tableFieldsNew[0]);
unset($tableFieldsNew[sizeof($tableFieldsNew)]);
if ($tableFieldsOld != $tableFieldsNew) {
//      echo '<pre>'.__LINE__.': : ';var_export($tableFieldsOld);echo '</pre>';
//      echo '<pre>'.__LINE__.': : ';var_export($tableFieldsNew);echo '</pre>';
//    die('Изменилась структура таблицы ' . $table);
foreach ($tableFieldsOld as $i => $field) {
$field = trim($field);
if (substr($field, 0, 1) == '`') {
$tableFieldsOld[$field] = $field;
}
unset($tableFieldsOld[$i]);
}
foreach ($tableFieldsNew as $field) {
$field = trim($field);
if (substr($field, 0, 1) != '`') continue;
if (!isset($tableFieldsOld[$field])) {
$this->_add_field($table, $field);
} else {
unset($tableFieldsOld[$field]);
}
}
//      echo '<pre>'.__LINE__.': : ';var_export($tableFieldsOld);echo '</pre>';
foreach ($tableFieldsOld as $field) {
list($field, $field_parms) = $this->_extract_field($field);
$db->Execute("ALTER TABLE `" . $table . "` DROP `" . zen_db_input($field) . "`;");
}
}
}
$db->Execute("DROP TABLE IF EXISTS `" . $table . "_temp`");
}
function _extract_field($field_str) {
$i = strpos($field_str, ' ');
$fld = substr($field_str, 0, $i);
$field_parms = trim(substr($field_str, $i));
$field_parms = trim($field_parms, ',');
$field = $fld;
$field = trim($field, '`');
return array($field, $field_parms);
}
//   $this->_add_field(TABLE_PRODUCTS_YML, 'yml_recording_length', "varchar(6) DEFAULT '' NOT NULL");
//   $this->_add_field(TABLE_PRODUCTS_YML, "`yml_recording_length` "varchar(6) DEFAULT '' NOT NULL");
function _add_field($table, $field, $field_parms=null) {
global $db;
static $tableFields = array();
if (!isset($tableFields[$table])) {
$describe = $db->Execute("SHOW FIELDS FROM " . $table);
while (!$describe->EOF) {
$tableFields[$table][$describe->fields['Field']] = $describe->fields;
$describe->MoveNext();
}
//    echo '<pre>'.__LINE__.': : ';var_export($tableFields);echo '</pre>';
}
$field = trim($field);
if (!isset($field_parms)) {
list($field, $field_parms) = $this->_extract_field($field);
}
//  echo '<pre>'.__LINE__.': : ';var_dump($field, $field_parms, isset($tableFields[$table][$field]));echo '</pre>';
if (!isset($tableFields[$table][$field])) {
$db->Execute("ALTER TABLE `" . $table . "` ADD `" . $field . "` " . $field_parms . "");
$tableFields[$table][$field] = $field_parms;
} else {
$parms = $field_parms;
$parms = strtolower($parms);
$parms = preg_replace('@\s*\(\s*@', '(', $parms);
$parms = preg_replace('@\s*\)@', ')', $parms);
//    echo '<pre>'.__LINE__.': : ';var_dump($tableFields[$table][$field]);echo '</pre>';
//    echo '<pre>'.__LINE__.': : ';var_dump($parms);echo '</pre>';
//    echo '<pre>'.__LINE__.': : ';var_dump($tableFields[$table][$field]['Type'] . " " . "default '" . $tableFields[$table][$field]['Default'] . "'" . " " . ($tableFields[$table][$field]['Null']=="NO" ? 'not ' : '') . "null");echo '</pre>';
if ($tableFields[$table][$field]['Type'] . " " . "default '" . $tableFields[$table][$field]['Default'] . "'" . " " . ($tableFields[$table][$field]['Null']=="NO" ? 'not ' : '') . "null" !=  $parms) {
$sql = "ALTER TABLE `" . $table . "` CHANGE `" . $field . "` `" . $field . "` " . $field_parms . "";
echo $sql . "</td></tr>\n";
// ALTER TABLE `products` CHANGE `yml_country_of_origin` `yml_country_of_origin` VARCHAR(32) DEFAULT '' NOT NULL
$db->Execute($sql);
}
}
}
function uninstall_configuration($prefix) {
global $db;
$prefix = str_replace('_', '\_', $prefix);
$sql = "SELECT configuration_group_id
FROM " . TABLE_CONFIGURATION . "
WHERE configuration_key LIKE ':prefix:%'
GROUP BY configuration_group_id";
$sql = $db->bindVars($sql, ':prefix:', $prefix, 'noquotestring');
$configuration_group_id = $db->Execute($sql);
if ($configuration_group_id->RecordCount() > 1) {
return false;
}
if (!$configuration_group_id->EOF) {
$sql = "DELETE FROM " . TABLE_CONFIGURATION . " WHERE configuration_group_id=:configuration_group_id:";
$sql = $db->bindVars($sql, ':configuration_group_id:', $configuration_group_id->fields['configuration_group_id'], 'integer');
$db->Execute($sql);
$sql = "DELETE FROM " . TABLE_CONFIGURATION_GROUP . " WHERE configuration_group_id=:configuration_group_id:";
$sql = $db->bindVars($sql, ':configuration_group_id:', $configuration_group_id->fields['configuration_group_id'], 'integer');
$db->Execute($sql);
}
return true;
}
function install_admin_pages($page) {
global $db;
if (function_exists('zen_register_admin_page')) {
if (zen_page_key_exists($page['page_key']) == FALSE) {
if (!isset($page['sort_order']) || (int)$page['sort_order'] == 0) {
$sql = "SELECT MAX(sort_order) AS sort_order_max FROM " . TABLE_ADMIN_PAGES . " WHERE menu_key = :menu_key:";
$sql = $db->bindVars($sql, ':menu_key:', $page['menu_key'], 'string');
$result = $db->Execute($sql);
$page['sort_order'] = $result->fields['sort_order_max']+1;
}
zen_register_admin_page($page['page_key'], $page['language_key'], $page['main_page'], $page['page_params'], $page['menu_key'], $page['display_on_menu'], $page['sort_order']);
} else {
return false;
}
return true;
}
}
function uninstall_admin_pages($page) {
if (function_exists('zen_deregister_admin_pages')) {
zen_deregister_admin_pages($page);
}
}
}
// EOF