X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=install%2Findex.php;h=5a2b24bc7b9a65f9a87f5098c542e8aa8acd5a8a;hb=74a49d03b2e819fa55da40a7e385f7daeb681081;hp=7fd3831e12c372f49353f1578f2fc86938dc5fcc;hpb=93fbb5cdaa4ac33ba5f3d32d9ddd1eda80af9467;p=fa-stable.git diff --git a/install/index.php b/install/index.php index 7fd3831e..5a2b24bc 100644 --- a/install/index.php +++ b/install/index.php @@ -12,31 +12,32 @@ $page_security = 'SA_OPEN'; $path_to_root=".."; -//if (file_exists($path_to_root.'/config.php')) -// header("Location: $path_to_root/index.php"); +if (file_exists($path_to_root.'/config_db.php')) + header("Location: $path_to_root/index.php"); include($path_to_root . "/install/isession.inc"); -page(_($help_context = "FrontAccouting ERP Installation Wizard"), true, false, "", '', false, - 'stylesheet.css'); +page(_("FrontAccouting ERP Installation Wizard"), true, false, "", '', false, 'stylesheet.css'); include($path_to_root . "/includes/ui.inc"); include($path_to_root . "/includes/system_tests.inc"); include($path_to_root . "/admin/db/maintenance_db.inc"); include($path_to_root . "/includes/packages.inc"); -include($path_to_root . "/installed_extensions.php"); +if (file_exists($path_to_root . "/installed_extensions.php")) + include($path_to_root . "/installed_extensions.php"); //------------------------------------------------------------------------------------------------- function subpage_title($txt) { global $path_to_root; - echo '
Logo + echo '
Logo
'; + $page = @$_POST['Page'] ? $_POST['Page'] : 1; display_heading( - $page==5 ? $txt : + $page == 6 ? $txt : _("FrontAccouting ERP Installation Wizard").'
' . sprintf(_('Step %d: %s'), $page , $txt)); br(); @@ -45,7 +46,7 @@ function subpage_title($txt) function display_coas() { start_table(TABLESTYLE); - $th = array(_("Chart of accounts"), _("Description"), _("Install")); + $th = array(_("Chart of accounts"), _("Encoding"), _("Description"), _("Install")); table_header($th); $k = 0; @@ -59,95 +60,129 @@ function display_coas() alt_table_row_color($k); label_cell($coa['name']); + label_cell($coa['encoding']); label_cell(is_array($coa['Descr']) ? implode('
', $coa['Descr']) : $coa['Descr']); - if ($installed) - label_cell(_("Installed")); - else - check_cells(null, 'coas['.$coa['package'].']'); + label_cell($installed ? + _("Installed") : checkbox(null, 'coas['.$coa['package'].']'), "align='center'"); + + end_row(); + } + end_table(1); +} + +function display_langs() +{ + start_table(TABLESTYLE); + $th = array(_("Language"), _("Encoding"), _("Description"), _("Install")); + table_header($th); + + $k = 0; + $langs = get_languages_list(); + foreach($langs as $pkg_name => $lang) + { + $available = @$lang['available']; + $installed = @$lang['version']; + $id = @$lang['local_id']; + if (!$available) continue; + + alt_table_row_color($k); + label_cell($lang['name']); + label_cell($lang['encoding']); + label_cell(is_array($lang['Descr']) ? implode('
', $lang['Descr']) : $lang['Descr']); + label_cell($installed ? + _("Installed") : checkbox(null, 'langs['.$lang['package'].']'), "align='center'"); end_row(); } end_table(1); } +function instlang_list_row($label, $name, $value=null) { + + global $inst_langs; + + $langs = array(); + foreach ($inst_langs as $n => $lang) + $langs[$n] = $lang['name']; + + echo "$label\n" . "\n" + .array_selector($name, $value, $langs, + array( + 'select_submit' => true, + 'async' => true + )) . "\n"; +} + function install_connect_db() { + global $db; $conn = $_SESSION['inst_set']; - - $db = mysql_connect($conn["host"] , $conn["dbuser"], $conn["dbpassword"]); - if(!$db) { - display_error('Cannot connect to database server. Host name, username and/or password incorrect.'); - return false; - } - if (!defined('TB_PREF')) - define('TB_PREF', $conn["tbpref"]); - if (!mysql_select_db($conn["dbname"], $db)) { - $sql = "CREATE DATABASE " . $conn["dbname"]; - if (!mysql_query($sql)) { - display_error('Cannot create database. Check your permissions to database creation or selct already created database.'); - return false; - } - return mysql_select_db($conn["dbname"], $db); + $db = db_create_db($conn); + if (!$db) { + display_error(_("Cannot connect to database. User or password is invalid or you have no permittions to create database.")); + } else { + if (strncmp(db_get_version(), "5.6", 3) >= 0) + db_query("SET sql_mode = ''"); } - return true; -} - -function coa_type_list_row($label, $name, $selected=null) -{ - - $coa_types = array( - 0 => _('New company with Standard American COA (4digit)'), - _('Demo based on Standard American COA (4digit)'), - _('Any COA selected from FA repository (inet connection required)') - ); - echo "$label\n"; - echo array_selector($name, $selected, $coa_types); - echo ""; + return $db; } function do_install() { - global $path_to_root, $db_connections, $def_coy, $installed_extensions; + + global $path_to_root, $db_connections, $def_coy, $installed_extensions, $tb_pref_counter, + $dflt_lang, $installed_languages; $coa = $_SESSION['inst_set']['coa']; if (install_connect_db() && db_import($path_to_root.'/sql/'.$coa, $_SESSION['inst_set'])) { $con = $_SESSION['inst_set']; $table_prefix = $con['tbpref']; - update_admin_password($con, md5($con['pass'])); - update_company_prefs(array('coy_name'=>$con['name'])); $def_coy = 0; $tb_pref_counter = 0; $db_connections = array (0=> array ( 'name' => $con['name'], 'host' => $con['host'], + 'port' => $con['port'], + 'dbname' => $con['dbname'], + 'collation' => $con['collation'], + 'tbpref' => $table_prefix, 'dbuser' => $con['dbuser'], 'dbpassword' => $con['dbpassword'], - 'dbname' => $con['dbname'], - 'tbpref' => $table_prefix )); + + $_SESSION['wa_current_user']->cur_con = 0; + + update_company_prefs(array('coy_name'=>$con['name'])); + $admin = get_user_by_login('admin'); + update_user_prefs($admin['id'], array( + 'language' => $con['lang'], + 'password' => md5($con['pass']), + 'user_id' => $con['admin'])); + + if (!copy($path_to_root. "/config.default.php", $path_to_root. "/config.php")) { + display_error(_("Cannot save system configuration file 'config.php'.")); + return false; + } + $err = write_config_db($table_prefix != ""); if ($err == -1) { - display_error(_("Cannot open the config_db.php configuration file:")); + display_error(_("Cannot open 'config_db.php' configuration file.")); return false; } else if ($err == -2) { - display_error(_("Cannot write to the config_db.php configuration file")); + display_error(_("Cannot write to the 'config_db.php' configuration file.")); return false; } else if ($err == -3) { - display_error(_("The configuration file config_db.php is not writable. Change its permissions so it is, then re-run step 5.")); - return false; - } - if (!copy($path_to_root. "/config.default.php", $path_to_root. "/config.php")) { - display_error(_("Cannot save system configuration file config.php")); + display_error(_("Configuration file 'config_db.php' is not writable. Change its permissions so it is, then re-run installation step.")); return false; } - if (count($installed_extensions)) - if (!update_extensions($installed_extensions)) { // update company 0 extensions (charts) - display_error(_("Can't update extensions configuration.")); - return false; - } + // update default language + if (file_exists($path_to_root . "/lang/installed_languages.inc")) + include_once($path_to_root . "/lang/installed_languages.inc"); + $dflt_lang = $_POST['lang']; + write_lang(); return true; } return false; @@ -156,63 +191,95 @@ function do_install() { if (!isset($_SESSION['inst_set'])) // default settings $_SESSION['inst_set'] = array( 'host'=>'localhost', + 'port' => '', // 3306 'dbuser' => 'root', 'dbpassword' => '', 'username' => 'admin', 'tbpref' => '0_', 'admin' => 'admin', - 'coa_type' => 0 + 'inst_lang' => 'C', + 'collation' => 'xx', ); if (!@$_POST['Tests']) - $_POST['Page'] = 1; + $_POST['Page'] = 1; // set to start page if (isset($_POST['back']) && (@$_POST['Page']>1)) { - $_POST['Page']--; - if ($_POST['Page'] == 3) + if ($_POST['Page'] == 5) $_POST['Page'] = 2; + else + $_POST['Page']--; } elseif (isset($_POST['continue'])) { $_POST['Page'] = 2; } elseif (isset($_POST['db_test'])) { if (get_post('host')=='') { - display_error(_('Host name cannot be empty')); + display_error(_('Host name cannot be empty.')); set_focus('host'); } + elseif ($_POST['port'] != '' && !is_numeric($_POST['port'])) { + display_error(_('Database port have to be numeric or empty.')); + set_focus('port'); + } elseif ($_POST['dbuser']=='') { - display_error(_('Database user name cannot be empty')); + display_error(_('Database user name cannot be empty.')); set_focus('dbuser'); } elseif ($_POST['dbname']=='') { - display_error(_('Database name cannot be empty')); + display_error(_('Database name cannot be empty.')); set_focus('dbname'); } else { $_SESSION['inst_set'] = array_merge($_SESSION['inst_set'], array( 'host' => $_POST['host'], + 'port' => $_POST['port'], 'dbuser' => $_POST['dbuser'], 'dbpassword' => $_POST['dbpassword'], 'dbname' => $_POST['dbname'], 'tbpref' => $_POST['tbpref'] ? '0_' : '', + 'sel_langs' => check_value('sel_langs'), + 'sel_coas' => check_value('sel_coas'), + 'collation' => $_POST['collation'], )); if (install_connect_db()) { - $_POST['Page'] = check_value('sel_coas') ? 3 : 4; + $_POST['Page'] = check_value('sel_langs') ? 3 : + (check_value('sel_coas') ? 4 : 5); + } + } + if (!file_exists($path_to_root . "/lang/installed_languages.inc")) { + $installed_languages = array ( + 0 => array ('code' => 'C', 'name' => 'English', 'encoding' => 'iso-8859-1')); + $dflt_lang = 'C'; + write_lang(); + } +} +elseif(get_post('install_langs')) +{ + $ret = true; + if (isset($_POST['langs'])) + foreach($_POST['langs'] as $package => $ok) { + $ret &= install_language($package); } + if ($ret) { + $_POST['Page'] = $_SESSION['inst_set']['sel_coas'] ? 4 : 5; } } elseif(get_post('install_coas')) { $ret = true; + $next_extension_id = 0; + if (isset($_POST['coas'])) foreach($_POST['coas'] as $package => $ok) { $ret &= install_extension($package); } if ($ret) { - $_POST['Page'] = 4; + if (file_exists($path_to_root . '/installed_extensions.php')) + include($path_to_root.'/installed_extensions.php'); + $_POST['Page'] = 5; } -} -elseif (isset($_POST['set_admin'])) { +} elseif (isset($_POST['set_admin'])) { // check company settings if (get_post('name')=='') { display_error(_('Company name cannot be empty.')); @@ -238,21 +305,30 @@ elseif (isset($_POST['set_admin'])) { 'pass' => $_POST['pass'], 'name' => $_POST['name'], 'admin' => $_POST['admin'], + 'lang' => $_POST['lang'] )); if (do_install()) { - $_POST['Page'] = 5; + $_POST['Page'] = 6; } } } +if (list_updated('inst_lang')) { + $_SESSION['inst_set']['inst_lang'] = get_post('inst_lang'); + $Ajax->setEncoding($inst_langs[get_post('inst_lang')]['encoding']); + $Ajax->activate('welcome'); +} + start_form(); switch(@$_POST['Page']) { default: - include ('../install.html'); - submit_center('continue', _('Continue >>')); - break; case '1': + div_start('welcome'); subpage_title(_('System Diagnostics')); + start_table(); + instlang_list_row(_("Select install wizard language:"), 'inst_lang', + $_SESSION['inst_set']['inst_lang']); + end_table(1); $_POST['Tests'] = display_system_tests(true); br(); if (@$_POST['Tests']) { @@ -262,6 +338,7 @@ start_form(); display_error(_('Application cannot be installed. Please fix problems listed below in red, and press Refresh button.')); submit_center('refresh', _('Refresh')); } + div_end(); break; case '2': @@ -271,47 +348,68 @@ start_form(); } subpage_title(_('Database Server Settings')); start_table(TABLESTYLE); - text_row_ex(_("Server Host"), 'host', 30); - text_row_ex(_("Database User"), 'dbuser', 30); - text_row_ex(_("Database Password"), 'dbpassword', 30); - text_row_ex(_("Database Name"), 'dbname', 30); - yesno_list_row(_("Use '0_' Table Prefix"), 'tbpref', 1, _('Yes'), _('No'), false); - check_row(_("Install additional COAs form FA repository"), 'sel_coas'); + text_row_ex(_("Server Host:"), 'host', 30, 60); + text_row_ex(_("Server Port:"), 'port', 30, 60); + text_row_ex(_("Database Name:"), 'dbname', 30); + text_row_ex(_("Database User:"), 'dbuser', 30); + password_row(_("Database Password:"), 'dbpassword', ''); + collations_list_row(_("Database Collation:"), 'collation'); + yesno_list_row(_("Use '0_' Table Prefix:"), 'tbpref', 1, _('Yes'), _('No'), false); + check_row(_("Install Additional Language Packs from FA Repository:"), 'sel_langs'); + check_row(_("Install Additional COAs from FA Repository:"), 'sel_coas'); end_table(1); - display_note(_('Use table prefix if you share selected database with another application, or you want to use it for more than one FA company.')); + display_note(_("Use database user/password with permissions to create new database, or use proper credentials for previously created empty database.")); + display_note(_("Select collation you want to use. If you are unsure or you will use various languages, select unicode collation.")); + display_note(_("Use table prefix if you share selected database for more than one FA company using the same collation.")); + display_note(_("Do not select additional langs nor COAs if you have no working internet connection right now. You can install them later.")); + display_note(_("Set Only Port value if you cannot use the default port 3306.")); submit_center_first('back', _('<< Back')); submit_center_last('db_test', _('Continue >>')); break; - case '3': // select COA - subpage_title(_('Charts of accounts selection')); + case '3': // select langauges + subpage_title(_('User Interface Languages Selection')); + display_langs(); + submit_center_first('back', _('<< Back')); + submit_center_last('install_langs', _('Continue >>')); + break; + + case '4': // select COA + subpage_title(_('Charts of Accounts Selection')); display_coas(); submit_center_first('back', _('<< Back')); submit_center_last('install_coas', _('Continue >>')); break; - case '4': + case '5': if (!isset($_POST['name'])) { foreach($_SESSION['inst_set'] as $name => $val) $_POST[$name] = $val; set_focus('name'); } + if (!isset($installed_extensions)) { + $installed_extensions = array(); + update_extensions($installed_extensions); + } + subpage_title(_('Company Settings')); start_table(TABLESTYLE); - text_row_ex(_("Company Name"), 'name', 30); - text_row_ex(_("Admin Login"), 'admin', 30); - password_row(_("Admin Password"), 'pass', @$_POST['pass']); - password_row(_("Reenter Password"), 'repass', @$_POST['repass']); - coa_list_row(_("Select Chart of Accounts"), 'coa'); + text_row_ex(_("Company Name:"), 'name', 30); + text_row_ex(_("Admin Login:"), 'admin', 30); + password_row(_("Admin Password:"), 'pass', @$_POST['pass']); + password_row(_("Reenter Password:"), 'repass', @$_POST['repass']); + coa_list_row(_("Select Chart of Accounts:"), 'coa'); + languages_list_row(_("Select Default Language:"), 'lang'); end_table(1); submit_center_first('back', _('<< Back')); - submit_center_last('set_admin', _('Continue >>')); + submit_center_last('set_admin', _('Install'), _('Start installation process'), 'default nonajax'); break; - case '5': // final screen + case '6': // final screen subpage_title(_('FrontAccounting ERP has been installed successsfully.')); - display_note(_('Please remove install wizard folder.')); - $install_done = true; + display_note(_('Please do not forget to remove install wizard folder.')); + session_unset(); + session_destroy(); hyperlink_no_params($path_to_root.'/index.php', _('Click here to start.')); break; @@ -323,4 +421,3 @@ end_form(1); end_page(false, false, true); -?>