X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fadmin.pl;h=464c6de9a11b50989d78147e69b0a676a325321f;hb=937e37ad007405c6a3a389ee18006379ffecc073;hp=9e34fba2040557e2b91ad0513c55065104becad1;hpb=4531a6c712b2529a01f31ddde2ef4d7045d173c7;p=kivitendo-erp.git diff --git a/bin/mozilla/admin.pl b/bin/mozilla/admin.pl index 9e34fba20..464c6de9a 100755 --- a/bin/mozilla/admin.pl +++ b/bin/mozilla/admin.pl @@ -40,6 +40,7 @@ use File::Copy; use File::Find; use File::Spec; use Cwd; +use IO::Dir; use IO::File; use POSIX qw(strftime); use Sys::Hostname; @@ -54,6 +55,7 @@ use SL::Common; use SL::Inifile; use SL::DBUpgrade2; use SL::DBUtils; +use SL::Template; require "bin/mozilla/common.pl"; require "bin/mozilla/admin_groups.pl"; @@ -73,13 +75,12 @@ our $form; our $locale; our $auth; -my @valid_dateformats = qw(mm-dd-yy mm/dd/yy dd-mm-yy dd/mm/yy dd.mm.yy yyyy-mm-dd); +my @valid_dateformats = qw(mm/dd/yy dd/mm/yy dd.mm.yy yyyy-mm-dd); my @valid_numberformats = ('1,000.00', '1000.00', '1.000,00', '1000,00'); -my @all_stylesheets = qw(lx-office-erp.css Win2000.css); +my @all_stylesheets = qw(lx-office-erp.css Mobile.css kivitendo.css); my @all_menustyles = ( { id => 'old', title => $::locale->text('Old (on the side)') }, { id => 'v3', title => $::locale->text('Top (CSS)') }, - { id => 'v4', title => $::locale->text('Top (CSS) new') }, { id => 'neu', title => $::locale->text('Top (Javascript)') }, ); @@ -91,20 +92,19 @@ sub run { $locale = $::locale; $auth = $::auth; - $::auth->store_root_credentials_in_session($form->{rpw}) if $session_result == SL::Auth->SESSION_OK; - - $form->{stylesheet} = "lx-office-erp.css"; + $::request->{layout} = SL::Layout::Dispatcher->new(style => 'admin'); + $::request->{layout}->use_stylesheet("lx-office-erp.css"); $form->{favicon} = "favicon.ico"; if ($form->{action}) { - if ($auth->authenticate_root($form->{rpw}) != $auth->OK()) { - $form->{error_message} = $locale->text('Incorrect Password!'); - $auth->delete_session_value('rpw'); + if ($auth->authenticate_root($form->{'{AUTH}admin_password'}) != $auth->OK()) { + $auth->punish_wrong_login; + $form->{error} = $locale->text('Incorrect Password!'); + $auth->delete_session_value('admin_password'); adminlogin(); } else { if ($auth->session_tables_present()) { - $::auth->store_root_credentials_in_session($::form->{rpw}); - delete $::form->{rpw}; + delete $::form->{'{AUTH}admin_password'}; _apply_dbupgrade_scripts(); } @@ -124,7 +124,7 @@ sub adminlogin { my $form = $main::form; my $locale = $main::locale; - $form->{title} = qq|Lx-Office ERP $form->{version} | . $locale->text('Administration'); + $form->{title} = qq|kivitendo $form->{version} | . $locale->text('Administration'); $form->header(); print $form->parse_html_template('admin/adminlogin'); @@ -148,6 +148,8 @@ sub check_auth_db_and_tables { map { $params{"db_${_}"} = $main::auth->{DB_config}->{$_} } keys %{ $auth->{DB_config} }; + $params{admin_password} = $::lx_office_conf{authentication}->{admin_password}; + if (!$main::auth->check_database()) { $form->{title} = $locale->text('Authentification database creation'); $form->header(); @@ -163,24 +165,6 @@ sub check_auth_db_and_tables { ::end_of_request(); } - - my $memberfile = $::lx_office_conf{paths}->{memberfile}; - if (-f $memberfile) { - my $memberdir = ""; - - if ($memberfile =~ m|^.*/|) { - $memberdir = $&; - } - - my $backupdir = "${memberdir}member-file-migration"; - - $form->{title} = $locale->text('User data migration'); - $form->header(); - print $form->parse_html_template('admin/user_migration', { 'memberfile' => $memberfile, - 'backupdir' => $backupdir }); - - ::end_of_request(); - } } sub create_auth_db { @@ -197,7 +181,7 @@ sub create_auth_tables { my $locale = $main::locale; $main::auth->create_tables(); - $main::auth->set_session_value('rpw', $form->{rpw}); + $main::auth->set_session_value('admin_password', $form->{'{AUTH}admin_password'}); $main::auth->create_or_refresh_session(); my $memberfile = $::lx_office_conf{paths}->{memberfile}; @@ -218,142 +202,6 @@ sub create_auth_tables { login(); } -sub migrate_users { - $main::lxdebug->enter_sub(); - - my $form = $main::form; - my $locale = $main::locale; - - my $memberdir = ""; - - my $memberfile = $::lx_office_conf{paths}->{memberfile}; - if ($memberfile =~ m|^.*/|) { - $memberdir = $&; - } - - my $backupdir = "${memberdir}member-file-migration"; - - if (! -d $backupdir && !mkdir $backupdir, 0700) { - $form->error(sprintf($locale->text('The directory "%s" could not be created:\n%s'), $backupdir, $!)); - } - - copy $memberfile, "users/member-file-migration/members"; - - my $in = IO::File->new($memberfile, "r"); - - $form->error($locale->text('Could not open the old memberfile.')) if (!$in); - - my (%members, $login); - - while (<$in>) { - chomp; - - next if (m/^\s*\#/); - - if (m/^\[.*\]/) { - $login = $_; - $login =~ s/(\[|\])//g; - $login =~ s/^\s*//; - $login =~ s/\s*$//; - - $members{$login} = { "login" => $login }; - next; - } - - if ($login && m/=/) { - my ($key, $value) = split m/\s*=\s*/, $_, 2; - $key =~ s|^\s*||; - $value =~ s|\s*$||; - - $value =~ s|\\r||g; - $value =~ s|\\n|\n|g; - - $members{$login}->{$key} = $value; - } - } - - $in->close(); - - delete $members{"root login"}; - - map { $_->{dbpasswd} = unpack 'u', $_->{dbpasswd} } values %members; - - while (my ($login, $params) = each %members) { - $main::auth->save_user($login, %{ $params }); - $main::auth->change_password($login, $params->{password}, 1); - - my $conf_file = "${memberdir}${login}.conf"; - - if (-f $conf_file) { - copy $conf_file, "${backupdir}/${login}.conf"; - unlink $conf_file; - } - } - - unlink $memberfile; - - my @member_list = sort { lc $a->{login} cmp lc $b->{login} } values %members; - - $form->{title} = $locale->text('User data migration'); - $form->header(); - print $form->parse_html_template('admin/user_migration_done', { 'MEMBERS' => \@member_list }); - - $main::lxdebug->leave_sub(); -} - -sub create_standard_group_ask { - my $form = $main::form; - my $locale = $main::locale; - - $form->{title} = $locale->text('Create a standard group'); - - $form->header(); - print $form->parse_html_template("admin/create_standard_group_ask"); -} - -sub create_standard_group { - my $form = $main::form; - my $locale = $main::locale; - - my %members = $main::auth->read_all_users(); - - my $groups = $main::auth->read_groups(); - - foreach my $group (values %{$groups}) { - if (($form->{group_id} != $group->{id}) - && ($form->{name} eq $group->{name})) { - $form->show_generic_error($locale->text("A group with that name does already exist.")); - } - } - - my $group = { - 'name' => $locale->text('Full Access'), - 'description' => $locale->text('Full access to all functions'), - 'rights' => { map { $_ => 1 } SL::Auth::all_rights() }, - 'members' => [ map { $_->{id} } values %members ], - }; - - $main::auth->save_group($group); - - user_migration_complete(1); -} - -sub dont_create_standard_group { - user_migration_complete(0); -} - -sub user_migration_complete { - my $standard_group_created = shift; - - my $form = $main::form; - my $locale = $main::locale; - - $form->{title} = $locale->text('User migration complete'); - $form->header(); - - print $form->parse_html_template('admin/user_migration_complete', { 'standard_group_created' => $standard_group_created }); -} - sub list_users { my $form = $main::form; my $locale = $main::locale; @@ -367,7 +215,7 @@ sub list_users { $_->{login_url} = $::locale->is_utf8 ? Encode::encode('utf-8-strict', $_->{login}) : $_->{login_url}; } - $form->{title} = "Lx-Office ERP " . $locale->text('Administration'); + $form->{title} = "kivitendo " . $locale->text('Administration'); $form->{LOCKED} = -e _nologin_file_name(); $form->{MEMBERS} = [ @members{sort { lc $a cmp lc $b } keys %members} ]; @@ -376,18 +224,16 @@ sub list_users { } sub add_user { - $::form->{title} = "Lx-Office ERP " . $::locale->text('Administration') . " / " . $::locale->text('Add User'); + $::form->{title} = "kivitendo " . $::locale->text('Administration') . " / " . $::locale->text('Add User'); -# Note: Menu Style 'v3' is not compatible to all browsers! -# "menustyle" => "old" sets the HTML Menu to default. -# User does not have a well behaved new constructor, so we#Ll just have to build one ourself + # User does not have a well behaved new constructor, so we'll just have to build one ourself my $user = bless { "vclimit" => 200, "countrycode" => "de", "numberformat" => "1.000,00", "dateformat" => "dd.mm.yy", - "stylesheet" => "lx-office-erp.css", - "menustyle" => "old", + "stylesheet" => "kivitendo.css", + "menustyle" => "neu", dbport => $::auth->{DB_config}->{port} || 5432, dbuser => $::auth->{DB_config}->{user} || 'lxoffice', dbhost => $::auth->{DB_config}->{host} || 'localhost', @@ -397,7 +243,7 @@ sub add_user { } sub edit_user { - $::form->{title} = "Lx-Office ERP " . $::locale->text('Administration') . " / " . $::locale->text('Edit User'); + $::form->{title} = "kivitendo " . $::locale->text('Administration') . " / " . $::locale->text('Edit User'); $::form->{edit} = 1; # get user @@ -418,7 +264,7 @@ sub edit_user_form { my $groups = []; if ($::form->{edit}) { - my $user_id = $::auth->get_user_id($::form->{login}); + my $user_id = $::auth->get_user_id($user->{login}); my $all_groups = $::auth->read_groups(); for my $group (values %{ $all_groups }) { @@ -476,7 +322,7 @@ sub save_user { $user->{templates} =~ s|.*/||; $user->{templates} = $::lx_office_conf{paths}->{templates} . "/$user->{templates}"; - my $myconfig = new User(id => $form->{id}); + my $myconfig = new User(id => $user->{id}); $::form->show_generic_error($::locale->text('Dataset missing!')) unless $user->{dbname}; $::form->show_generic_error($::locale->text('Database User missing!')) unless $user->{dbuser}; @@ -542,7 +388,7 @@ sub save_user { # Add new user to his groups. if (ref $form->{new_user_group_ids} eq 'ARRAY') { my $all_groups = $main::auth->read_groups(); - my %user = $main::auth->read_user(login => $user->{login}); + my %user = $main::auth->read_user(login => $myconfig->{login}); foreach my $group_id (@{ $form->{new_user_group_ids} }) { my $group = $all_groups->{$group_id}; @@ -564,7 +410,7 @@ sub save_user { $form->error($::locale->text('The settings were saved, but the password was not changed.') . ' ' . join(' ', $verifier->errors($result))); } - $main::auth->change_password($user->{login}, $::form->{new_password}); + $main::auth->change_password($myconfig->{login}, $::form->{new_password}); } $::form->redirect($::locale->text('User saved!')); @@ -653,7 +499,7 @@ sub dbselect_source { $form->{dbdefault} = 'template1'; $form->{dbhost} = $::auth->{DB_config}->{host} || 'localhost'; - $form->{title} = "Lx-Office ERP / " . $locale->text('Database Administration'); + $form->{title} = "kivitendo / " . $locale->text('Database Administration'); # Intentionnaly disabled unless fixed to work with the authentication DB. $form->{ALLOW_DBBACKUP} = 0; # "$pg_dump_exe" ne "DISABLED"; @@ -689,7 +535,7 @@ sub update_dataset { my $form = $main::form; my $locale = $main::locale; - $form->{title} = "Lx-Office ERP " . $locale->text('Database Administration') . " / " . $locale->text('Update Dataset'); + $form->{title} = "kivitendo " . $locale->text('Database Administration') . " / " . $locale->text('Update Dataset'); my @need_updates = User->dbneedsupdate($form); $form->{NEED_UPDATES} = \@need_updates; @@ -703,7 +549,7 @@ sub dbupdate { my $form = $main::form; my $locale = $main::locale; - $form->{stylesheet} = "lx-office-erp.css"; + $::request->{layout}->use_stylesheet("lx-office-erp.css"); $form->{title} = $locale->text("Dataset upgrade"); $form->header(); @@ -744,57 +590,33 @@ sub create_dataset { $form->{CHARTS} = []; - opendir SQLDIR, "sql/." or $form->error($ERRNO); - foreach my $item (sort grep /-chart\.sql\z/, readdir SQLDIR) { - next if ($item eq 'Default-chart.sql'); - $item =~ s/-chart\.sql//; - push @{ $form->{CHARTS} }, { "name" => $item, - "selected" => $item eq "Germany-DATEV-SKR03EU" }; + tie my %dir_h, 'IO::Dir', 'sql/'; + foreach my $item (map { s/-chart\.sql$//; $_ } sort grep { /-chart\.sql\z/ && !/Default-chart.sql\z/ } keys %dir_h) { + push @{ $form->{CHARTS} }, { name => $item, + selected => $item eq "Germany-DATEV-SKR03EU" }; } - closedir SQLDIR; - $form->{ACCOUNTING_METHODS} = []; - foreach my $item ( qw(accrual cash) ) { - push @{ $form->{ACCOUNTING_METHODS} }, { "name" => $item, - "selected" => $item eq "cash" }; - }; + $form->{ACCOUNTING_METHODS} = [ map { { name => $_, selected => $_ eq 'cash' } } qw(accrual cash) ]; + $form->{INVENTORY_SYSTEMS} = [ map { { name => $_, selected => $_ eq 'periodic' } } qw(perpetual periodic) ]; + $form->{PROFIT_DETERMINATIONS} = [ map { { name => $_, selected => $_ eq 'income' } } qw(balance income) ]; - $form->{INVENTORY_SYSTEMS} = []; - foreach my $item ( qw(perpetual periodic) ) { - push @{ $form->{INVENTORY_SYSTEMS} }, { "name" => $item, - "selected" => $item eq "periodic" }; - }; - - $form->{PROFIT_DETERMINATIONS} = []; - foreach my $item ( qw(balance income) ) { - push @{ $form->{PROFIT_DETERMINATIONS} }, { "name" => $item, - "selected" => $item eq "income" }; - }; - - my $default_charset = $::lx_office_conf{system}->{dbcharset}; - $default_charset ||= Common::DEFAULT_CHARSET; + my $default_charset = $::lx_office_conf{system}->{dbcharset} || Common::DEFAULT_CHARSET; my $cluster_encoding = User->dbclusterencoding($form); if ($cluster_encoding && ($cluster_encoding =~ m/^(?:UTF-?8|UNICODE)$/i)) { if ($::lx_office_conf{system}->{dbcharset} !~ m/^UTF-?8$/i) { $form->show_generic_error($locale->text('The selected PostgreSQL installation uses UTF-8 as its encoding. ' . - 'Therefore you have to configure Lx-Office to use UTF-8 as well.'), + 'Therefore you have to configure kivitendo to use UTF-8 as well.'), 'back_button' => 1); } $form->{FORCE_DBENCODING} = 'UNICODE'; } else { - $form->{DBENCODINGS} = []; - - foreach my $encoding (@Common::db_encodings) { - push @{ $form->{DBENCODINGS} }, { "dbencoding" => $encoding->{dbencoding}, - "label" => $encoding->{label}, - "selected" => $encoding->{charset} eq $default_charset }; - } + $form->{DBENCODINGS} = [ map { { %{$_}, selected => $_->{charset} eq $default_charset } } @Common::db_encodings ]; } - $form->{title} = "Lx-Office ERP " . $locale->text('Database Administration') . " / " . $locale->text('Create Dataset'); + $form->{title} = "kivitendo " . $locale->text('Database Administration') . " / " . $locale->text('Create Dataset'); $form->header(); print $form->parse_html_template("admin/create_dataset"); @@ -805,10 +627,11 @@ sub dbcreate { my $locale = $main::locale; $form->isblank("db", $locale->text('Dataset missing!')); + $form->isblank("defaultcurrency", $locale->text('Default currency missing!')); User->dbcreate(\%$form); - $form->{title} = "Lx-Office ERP " . $locale->text('Database Administration') . " / " . $locale->text('Create Dataset'); + $form->{title} = "kivitendo " . $locale->text('Database Administration') . " / " . $locale->text('Create Dataset'); $form->header(); print $form->parse_html_template("admin/dbcreate"); @@ -821,7 +644,7 @@ sub delete_dataset { my @dbsources = User->dbsources_unused($form); $form->error($locale->text('Nothing to delete!')) unless @dbsources; - $form->{title} = "Lx-Office ERP " . $locale->text('Database Administration') . " / " . $locale->text('Delete Dataset'); + $form->{title} = "kivitendo " . $locale->text('Database Administration') . " / " . $locale->text('Delete Dataset'); $form->{DBSOURCES} = [ map { { "name", $_ } } sort @dbsources ]; $form->header(); @@ -838,7 +661,7 @@ sub dbdelete { User->dbdelete(\%$form); - $form->{title} = "Lx-Office ERP " . $locale->text('Database Administration') . " / " . $locale->text('Delete Dataset'); + $form->{title} = "kivitendo " . $locale->text('Database Administration') . " / " . $locale->text('Delete Dataset'); $form->header(); print $form->parse_html_template("admin/dbdelete"); } @@ -847,7 +670,7 @@ sub backup_dataset { my $form = $main::form; my $locale = $main::locale; - $form->{title} = "Lx-Office ERP " . $locale->text('Database Administration') . " / " . $locale->text('Backup Dataset'); + $form->{title} = "kivitendo " . $locale->text('Database Administration') . " / " . $locale->text('Backup Dataset'); if ($::lx_office_conf{applications}->{pg_dump} eq "DISABLED") { $form->error($locale->text('Database backups and restorations are disabled in the configuration.')); @@ -859,7 +682,7 @@ sub backup_dataset { my $username = getpwuid $UID || "unknown-user"; my $hostname = hostname() || "unknown-host"; - $form->{from} = "Lx-Office Admin <${username}\@${hostname}>"; + $form->{from} = "kivitendo Admin <${username}\@${hostname}>"; $form->header(); print $form->parse_html_template("admin/backup_dataset"); @@ -869,7 +692,7 @@ sub backup_dataset_start { my $form = $main::form; my $locale = $main::locale; - $form->{title} = "Lx-Office ERP " . $locale->text('Database Administration') . " / " . $locale->text('Backup Dataset'); + $form->{title} = "kivitendo " . $locale->text('Database Administration') . " / " . $locale->text('Backup Dataset'); my $pg_dump_exe = $::lx_office_conf{applications}->{pg_dump} || "pg_dump"; @@ -945,7 +768,7 @@ sub backup_dataset_start { unlink "${tmpdir}/.pgpass", $tmp; rmdir $tmpdir; - $form->{title} = "Lx-Office ERP " . $locale->text('Database Administration') . " / " . $locale->text('Backup Dataset'); + $form->{title} = "kivitendo " . $locale->text('Database Administration') . " / " . $locale->text('Backup Dataset'); $form->header(); print $form->parse_html_template("admin/backup_dataset_email_done"); @@ -956,7 +779,7 @@ sub restore_dataset { my $form = $main::form; my $locale = $main::locale; - $form->{title} = "Lx-Office ERP " . $locale->text('Database Administration') . " / " . $locale->text('Restore Dataset'); + $form->{title} = "kivitendo " . $locale->text('Database Administration') . " / " . $locale->text('Restore Dataset'); if ($::lx_office_conf{applications}->{pg_restore} eq "DISABLED") { $form->error($locale->text('Database backups and restorations are disabled in the configuration.')); @@ -981,7 +804,7 @@ sub restore_dataset_start { my $form = $main::form; my $locale = $main::locale; - $form->{title} = "Lx-Office ERP " . $locale->text('Database Administration') . " / " . $locale->text('Restore Dataset'); + $form->{title} = "kivitendo " . $locale->text('Database Administration') . " / " . $locale->text('Restore Dataset'); my $pg_restore_exe = $::lx_office_conf{applications}->{pg_restore} || "pg_restore"; @@ -1192,30 +1015,9 @@ sub _nologin_file_name { } sub _search_templates { - # is there a templates basedir - if (!-d $::lx_office_conf{paths}->{templates}) { - $::form->error(sprintf($::locale->text("The directory %s does not exist."), $::lx_office_conf{paths}->{templates})); - } - - opendir TEMPLATEDIR, $::lx_office_conf{paths}->{templates} or $::form->error($::lx_office_conf{paths}->{templates} . " : $ERRNO"); - my @all = readdir(TEMPLATEDIR); - my @alldir = sort grep { -d ($::lx_office_conf{paths}->{templates} . "/$_") && !/^\.\.?$/ } @all; - closedir TEMPLATEDIR; - - @alldir = grep !/\.(html|tex|sty|odt|xml|txb)$/, @alldir; - @alldir = grep !/^(webpages|print|\.svn)$/, @alldir; - - # mastertemplates - opendir TEMPLATEDIR, "$::lx_office_conf{paths}->{templates}/print" or $::form->error("$::lx_office_conf{paths}->{templates}/print" . " : $ERRNO"); - my @allmaster = readdir(TEMPLATEDIR); - closedir TEMPLATEDIR; - - @allmaster = sort grep { -d ("$::lx_office_conf{paths}->{templates}/print" . "/$_") && !/^\.\.?$/ } @allmaster; - @allmaster = reverse grep !/Default/, @allmaster; - push @allmaster, 'Default'; - @allmaster = reverse @allmaster; + my %templates = SL::Template->available_templates; - return \@alldir, \@allmaster; + return ($templates{print_templates}, $templates{master_templates}); } 1;