2 /**********************************************************************
3 Copyright (C) FrontAccounting, LLC.
4 Released under the terms of the GNU General Public License, GPL,
5 as published by the Free Software Foundation, either version 3
6 of the License, or (at your option) any later version.
7 This program is distributed in the hope that it will be useful,
8 but WITHOUT ANY WARRANTY; without even the implied warranty of
9 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10 See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
11 ***********************************************************************/
12 $page_security = 'SA_OPEN';
15 if (file_exists($path_to_root.'/config_db.php'))
16 header("Location: $path_to_root/index.php");
18 include($path_to_root . "/install/isession.inc");
20 page(_("FrontAccouting ERP Installation Wizard"), true, false, "", '', false, 'stylesheet.css');
22 include($path_to_root . "/includes/ui.inc");
23 include($path_to_root . "/includes/system_tests.inc");
24 include($path_to_root . "/admin/db/maintenance_db.inc");
25 include($path_to_root . "/includes/packages.inc");
26 if (file_exists($path_to_root . "/installed_extensions.php"))
27 include($path_to_root . "/installed_extensions.php");
28 //-------------------------------------------------------------------------------------------------
30 function subpage_title($txt)
34 echo '<center><img src="'.$path_to_root.'/themes/default/images/logo_frontaccounting.png" width="250" height="50" alt="Logo" >
37 $page = @$_POST['Page'] ? $_POST['Page'] : 1;
41 _("FrontAccouting ERP Installation Wizard").'<br>'
42 . sprintf(_('Step %d: %s'), $page , $txt));
46 function display_coas()
48 start_table(TABLESTYLE);
49 $th = array(_("Chart of accounts"), _("Encoding"), _("Description"), _("Install"));
53 $charts = get_charts_list();
55 foreach($charts as $pkg_name => $coa)
57 $available = @$coa['available'];
58 $installed = @$coa['version'];
59 $id = @$coa['local_id'];
61 alt_table_row_color($k);
62 label_cell($coa['name']);
63 label_cell($coa['encoding']);
64 label_cell(is_array($coa['Descr']) ? implode('<br>', $coa['Descr']) : $coa['Descr']);
65 label_cell($installed ?
66 _("Installed") : checkbox(null, 'coas['.$coa['package'].']'), "align='center'");
73 function display_langs()
75 start_table(TABLESTYLE);
76 $th = array(_("Language"), _("Encoding"), _("Description"), _("Install"));
80 $langs = get_languages_list();
82 foreach($langs as $pkg_name => $lang)
84 $available = @$lang['available'];
85 $installed = @$lang['version'];
86 $id = @$lang['local_id'];
87 if (!$available) continue;
89 alt_table_row_color($k);
90 label_cell($lang['name']);
91 label_cell($lang['encoding']);
92 label_cell(is_array($lang['Descr']) ? implode('<br>', $lang['Descr']) : $lang['Descr']);
93 label_cell($installed ?
94 _("Installed") : checkbox(null, 'langs['.$lang['package'].']'), "align='center'");
100 function instlang_list_row($label, $name, $value=null) {
105 foreach ($inst_langs as $n => $lang)
106 $langs[$n] = $lang['name'];
108 echo "<td>$label</td>\n" . "<td>\n"
109 .array_selector($name, $value, $langs,
111 'select_submit' => true,
116 function install_connect_db() {
120 $conn = $_SESSION['inst_set'];
122 $db = db_create_db($conn);
124 display_error(_("Cannot connect to database. User or password is invalid or you have no permittions to create database."));
126 if (strncmp(db_get_version(), "5.6", 3) >= 0)
127 db_query("SET sql_mode = ''");
132 function do_install() {
134 global $path_to_root, $db_connections, $def_coy, $installed_extensions, $tb_pref_counter,
135 $dflt_lang, $installed_languages;
137 $coa = $_SESSION['inst_set']['coa'];
138 if (install_connect_db() && db_import($path_to_root.'/sql/'.$coa, $_SESSION['inst_set'])) {
139 $con = $_SESSION['inst_set'];
140 $table_prefix = $con['tbpref'];
143 $tb_pref_counter = 0;
144 $db_connections = array (0=> array (
145 'name' => $con['name'],
146 'host' => $con['host'],
147 'port' => $con['port'],
148 'dbname' => $con['dbname'],
149 'collation' => $con['collation'],
150 'tbpref' => $table_prefix,
151 'dbuser' => $con['dbuser'],
152 'dbpassword' => $con['dbpassword'],
155 $_SESSION['wa_current_user']->cur_con = 0;
157 update_company_prefs(array('coy_name'=>$con['name']));
158 $admin = get_user_by_login('admin');
159 update_user_prefs($admin['id'], array(
160 'language' => $con['lang'],
161 'password' => md5($con['pass']),
162 'user_id' => $con['admin']));
164 if (!copy($path_to_root. "/config.default.php", $path_to_root. "/config.php")) {
165 display_error(_("Cannot save system configuration file 'config.php'."));
169 $err = write_config_db($table_prefix != "");
172 display_error(_("Cannot open 'config_db.php' configuration file."));
174 } else if ($err == -2) {
175 display_error(_("Cannot write to the 'config_db.php' configuration file."));
177 } else if ($err == -3) {
178 display_error(_("Configuration file 'config_db.php' is not writable. Change its permissions so it is, then re-run installation step."));
181 // update default language
182 if (file_exists($path_to_root . "/lang/installed_languages.inc"))
183 include_once($path_to_root . "/lang/installed_languages.inc");
184 $dflt_lang = $_POST['lang'];
191 if (!isset($_SESSION['inst_set'])) // default settings
192 $_SESSION['inst_set'] = array(
194 'port' => '', // 3306
197 'username' => 'admin',
204 if (!@$_POST['Tests'])
205 $_POST['Page'] = 1; // set to start page
207 if (isset($_POST['back']) && (@$_POST['Page']>1)) {
208 if ($_POST['Page'] == 5)
213 elseif (isset($_POST['continue'])) {
216 elseif (isset($_POST['db_test'])) {
217 if (get_post('host')=='') {
218 display_error(_('Host name cannot be empty.'));
221 elseif ($_POST['port'] != '' && !is_numeric($_POST['port'])) {
222 display_error(_('Database port have to be numeric or empty.'));
225 elseif ($_POST['dbuser']=='') {
226 display_error(_('Database user name cannot be empty.'));
229 elseif ($_POST['dbname']=='') {
230 display_error(_('Database name cannot be empty.'));
234 $_SESSION['inst_set'] = array_merge($_SESSION['inst_set'], array(
235 'host' => $_POST['host'],
236 'port' => $_POST['port'],
237 'dbuser' => $_POST['dbuser'],
238 'dbpassword' => $_POST['dbpassword'],
239 'dbname' => $_POST['dbname'],
240 'tbpref' => $_POST['tbpref'] ? '0_' : '',
241 'sel_langs' => check_value('sel_langs'),
242 'sel_coas' => check_value('sel_coas'),
243 'collation' => $_POST['collation'],
245 if (install_connect_db()) {
246 $_POST['Page'] = check_value('sel_langs') ? 3 :
247 (check_value('sel_coas') ? 4 : 5);
250 if (!file_exists($path_to_root . "/lang/installed_languages.inc")) {
251 $installed_languages = array (
252 0 => array ('code' => 'C', 'name' => 'English', 'encoding' => 'iso-8859-1'));
257 elseif(get_post('install_langs'))
260 if (isset($_POST['langs']))
261 foreach($_POST['langs'] as $package => $ok) {
262 $ret &= install_language($package);
265 $_POST['Page'] = $_SESSION['inst_set']['sel_coas'] ? 4 : 5;
268 elseif(get_post('install_coas'))
271 $next_extension_id = 0;
273 if (isset($_POST['coas']))
274 foreach($_POST['coas'] as $package => $ok) {
275 $ret &= install_extension($package);
278 if (file_exists($path_to_root . '/installed_extensions.php'))
279 include($path_to_root.'/installed_extensions.php');
282 } elseif (isset($_POST['set_admin'])) {
283 // check company settings
284 if (get_post('name')=='') {
285 display_error(_('Company name cannot be empty.'));
288 elseif (get_post('admin')=='') {
289 display_error(_('Company admin name cannot be empty.'));
292 elseif (get_post('pass')=='') {
293 display_error(_('Company admin password cannot be empty.'));
296 elseif (get_post('pass')!=get_post('repass')) {
297 display_error(_('Company admin passwords differ.'));
298 unset($_POST['pass'],$_POST['repass']);
303 $_SESSION['inst_set'] = array_merge($_SESSION['inst_set'], array(
304 'coa' => $_POST['coa'],
305 'pass' => $_POST['pass'],
306 'name' => $_POST['name'],
307 'admin' => $_POST['admin'],
308 'lang' => $_POST['lang']
316 if (list_updated('inst_lang')) {
317 $_SESSION['inst_set']['inst_lang'] = get_post('inst_lang');
318 $Ajax->setEncoding($inst_langs[get_post('inst_lang')]['encoding']);
319 $Ajax->activate('welcome');
323 switch(@$_POST['Page']) {
326 div_start('welcome');
327 subpage_title(_('System Diagnostics'));
329 instlang_list_row(_("Select install wizard language:"), 'inst_lang',
330 $_SESSION['inst_set']['inst_lang']);
332 $_POST['Tests'] = display_system_tests(true);
334 if (@$_POST['Tests']) {
335 display_notification(_('All application preliminary requirements seems to be correct. Please press Continue button below.'));
336 submit_center('continue', _('Continue >>'));
338 display_error(_('Application cannot be installed. Please fix problems listed below in red, and press Refresh button.'));
339 submit_center('refresh', _('Refresh'));
345 if (!isset($_POST['host'])) {
346 foreach($_SESSION['inst_set'] as $name => $val)
347 $_POST[$name] = $val;
349 subpage_title(_('Database Server Settings'));
350 start_table(TABLESTYLE);
351 text_row_ex(_("Server Host:"), 'host', 30, 60);
352 text_row_ex(_("Server Port:"), 'port', 30, 60);
353 text_row_ex(_("Database Name:"), 'dbname', 30);
354 text_row_ex(_("Database User:"), 'dbuser', 30);
355 password_row(_("Database Password:"), 'dbpassword', '');
356 collations_list_row(_("Database Collation:"), 'collation');
357 yesno_list_row(_("Use '0_' Table Prefix:"), 'tbpref', 1, _('Yes'), _('No'), false);
358 check_row(_("Install Additional Language Packs from FA Repository:"), 'sel_langs');
359 check_row(_("Install Additional COAs from FA Repository:"), 'sel_coas');
361 display_note(_("Use database user/password with permissions to create new database, or use proper credentials for previously created empty database."));
362 display_note(_("Select collation you want to use. If you are unsure or you will use various languages, select unicode collation."));
363 display_note(_("Use table prefix if you share selected database for more than one FA company using the same collation."));
364 display_note(_("Do not select additional langs nor COAs if you have no working internet connection right now. You can install them later."));
365 display_note(_("Set Only Port value if you cannot use the default port 3306."));
366 submit_center_first('back', _('<< Back'));
367 submit_center_last('db_test', _('Continue >>'));
370 case '3': // select langauges
371 subpage_title(_('User Interface Languages Selection'));
373 submit_center_first('back', _('<< Back'));
374 submit_center_last('install_langs', _('Continue >>'));
377 case '4': // select COA
378 subpage_title(_('Charts of Accounts Selection'));
380 submit_center_first('back', _('<< Back'));
381 submit_center_last('install_coas', _('Continue >>'));
385 if (!isset($_POST['name'])) {
386 foreach($_SESSION['inst_set'] as $name => $val)
387 $_POST[$name] = $val;
390 if (!isset($installed_extensions)) {
391 $installed_extensions = array();
392 update_extensions($installed_extensions);
395 subpage_title(_('Company Settings'));
396 start_table(TABLESTYLE);
397 text_row_ex(_("Company Name:"), 'name', 30);
398 text_row_ex(_("Admin Login:"), 'admin', 30);
399 password_row(_("Admin Password:"), 'pass', @$_POST['pass']);
400 password_row(_("Reenter Password:"), 'repass', @$_POST['repass']);
401 coa_list_row(_("Select Chart of Accounts:"), 'coa');
402 languages_list_row(_("Select Default Language:"), 'lang');
404 submit_center_first('back', _('<< Back'));
405 submit_center_last('set_admin', _('Install'), _('Start installation process'), 'default nonajax');
408 case '6': // final screen
409 subpage_title(_('FrontAccounting ERP has been installed successsfully.'));
410 display_note(_('Please do not forget to remove install wizard folder.'));
413 hyperlink_no_params($path_to_root.'/index.php', _('Click here to start.'));
422 end_page(false, false, true);