8 |
# 2000-03-13 DbP podrska za novu support/last_open tablicu |
# 2000-03-13 DbP podrska za novu support/last_open tablicu |
9 |
# 2000-03-16 DbP cuva stare aliase iz /etc/aliases |
# 2000-03-16 DbP cuva stare aliase iz /etc/aliases |
10 |
# 2000-03-20 DbP skida razmake prije/poslje imena/prezimena |
# 2000-03-20 DbP skida razmake prije/poslje imena/prezimena |
11 |
|
|
12 |
use DBI; |
use DBI; |
13 |
use strict; |
use strict; |
14 |
|
|
15 |
my $debug=0; |
my $debug=0; |
16 |
|
|
17 |
$debug++ if (defined($ARGV[0]) && $ARGV[0] eq "-d"); |
if (defined($ARGV[0]) && $ARGV[0] eq "-d") { |
18 |
|
$debug++; |
19 |
|
shift @ARGV; |
20 |
|
} |
21 |
|
my $open_only_id=shift @ARGV if (defined($ARGV[0])); |
22 |
|
|
23 |
warn "DEBUG -- me kreira ništa!" if ($debug); |
warn "DEBUG -- me kreira ništa!" if ($debug); |
24 |
|
|
25 |
$|++; |
$|++; |
26 |
|
|
|
my @mail_to; # array to main initial message to |
|
|
open(WHO,"who am i |") || die "who am i? $!"; |
|
|
my $db_user=<WHO>; |
|
|
$db_user=~s/\s.+$//g; |
|
|
close(WHO); |
|
27 |
|
|
28 |
#---- |
#---- |
29 |
|
|
38 |
my $mail_alias; |
my $mail_alias; |
39 |
my $mail_login; |
my $mail_login; |
40 |
|
|
41 |
|
my @mail_to; # array to main initial message to |
42 |
|
open(WHO,"who am i |") || die "who am i? $!"; |
43 |
|
my $db_user=<WHO>; |
44 |
|
$db_user=~s/\s.+$//g; |
45 |
|
close(WHO); |
46 |
|
|
47 |
|
xdebug "koristim korinika $db_user\n"; |
48 |
|
|
49 |
|
|
50 |
v "/etc/aliases\n"; |
v "/etc/aliases\n"; |
51 |
open(ALIAS,"/etc/aliases") || die "Can't open /etc/aliases: $!"; |
open(ALIAS,"/etc/aliases") || die "Can't open /etc/aliases: $!"; |
52 |
open(NALIAS,">aliases.new") || die "Can't open aliases.new: $!"; |
open(NALIAS,">aliases.new") || die "Can't open aliases.new: $!"; |
108 |
my $sth = $dbh->prepare("select max(id) from last_open") || die $dbh->errstr(); |
my $sth = $dbh->prepare("select max(id) from last_open") || die $dbh->errstr(); |
109 |
$sth->execute() || die $sth->errstr(); |
$sth->execute() || die $sth->errstr(); |
110 |
my ($last_open)=$sth->fetchrow_array; |
my ($last_open)=$sth->fetchrow_array; |
111 |
$sth = $dbh->prepare("select id,ime,prezime,sifra,objekt,kat,soba,shell from view_otvori_nove where id > $last_open") || die $dbh->errstr(); |
if (! defined($open_only_id)) { |
112 |
|
$sth = $dbh->prepare("select id,ime,prezime,sifra,objekt,kat,soba,shell from view_otvori_nove where id > $last_open") || die $dbh->errstr(); |
113 |
|
} else { |
114 |
|
$sth = $dbh->prepare("select id,ime,prezime,sifra,objekt,kat,soba,shell from view_otvori_nove where id=$open_only_id") || die $dbh->errstr(); |
115 |
|
|
116 |
|
} |
117 |
$sth->execute() || die $sth->errstr(); |
$sth->execute() || die $sth->errstr(); |
118 |
|
|
119 |
|
|
120 |
|
my $sth2; |
121 |
|
|
122 |
while (my ($osoba_id,$ime,$prezime,$sifra,$objekt,$kat,$soba,$shell) = $sth->fetchrow_array() ) { |
while (my ($osoba_id,$ime,$prezime,$sifra,$objekt,$kat,$soba,$shell) = $sth->fetchrow_array() ) { |
123 |
|
|
124 |
|
$sth2 = $dbh->prepare("select max(status_tip_id) from status where osoba_id = $osoba_id") || die $dbh->errstr(); |
125 |
|
$sth2->execute() || die $sth2->errstr(); |
126 |
|
my ($max_status) = $sth2->fetchrow_array(); |
127 |
|
xdebug "max status zahtjeva $osoba_id je $max_status\n"; |
128 |
|
next if ($max_status > 3); # 3 .. otvoren |
129 |
|
|
130 |
next if ($ime eq "ime" || $prezime eq "prezime"); |
next if ($ime eq "ime" || $prezime eq "prezime"); |
131 |
|
|
132 |
if (!defined($ime) || !defined($prezime) || $ime eq "" || $prezime eq "") { |
if (!defined($ime) || !defined($prezime) || $ime eq "" || $prezime eq "") { |
149 |
my $login; |
my $login; |
150 |
|
|
151 |
do { |
do { |
152 |
$login=substr($ime,0,1).substr($prezime_za_login,0,7-length($add)).$add; |
$login=substr($ime,0,1).substr($prezime_za_login,0,7-length($add)).$add; |
153 |
xdebug "$ime, $prezime login: $login\n"; |
$login =~ tr [A-Z] [a-z]; |
154 |
$add++; |
xdebug "$ime, $prezime login: $login\n"; |
155 |
|
$add++; |
156 |
} while defined($etc_passwd{$login}); |
} while defined($etc_passwd{$login}); |
|
$login =~ tr [A-Z] [a-z]; |
|
157 |
|
|
158 |
my $email_alias; |
my $email_alias; |
159 |
|
|
169 |
my $group="users"; |
my $group="users"; |
170 |
|
|
171 |
if (defined($etc_passwd{$login})) { |
if (defined($etc_passwd{$login})) { |
172 |
xerror "preskocen: $ime $prezime (postoji isti login $login)\n"; |
xerror "preskocen: $ime $prezime osoba_id=$osoba_id (postoji isti login $login)\n"; |
173 |
$dbh->do("insert into status (osoba_id,kontakt_osoba_id,datum,status_tip_id) values ($osoba_id,3,'now'::datetime,4)") if (! $debug); |
$dbh->do("insert into status (osoba_id,kontakt_osoba_id,datum,status_tip_id) values ($osoba_id,3,'now'::datetime,4)") if (! $debug); |
174 |
next; |
next; |
175 |
} |
} |
211 |
$etc_passwd{$login}=$full_name; |
$etc_passwd{$login}=$full_name; |
212 |
|
|
213 |
if (defined($etc_aliases{$email_alias})) { |
if (defined($etc_aliases{$email_alias})) { |
214 |
xerror "upozorenje: $ime $prezime (postoji e-mail alias) -- $email_alias\n"; |
xerror "upozorenje: $ime $prezime osoba_id=$osoba_id (postoji e-mail alias) -- $email_alias\n"; |
215 |
print NALIAS "$email_alias:\t$login,$etc_aliases{$email_alias}\n"; |
print NALIAS "$email_alias:\t$login,$etc_aliases{$email_alias}\n"; |
216 |
} else { |
} else { |
217 |
print NALIAS "$email_alias:\t$login\n"; |
print NALIAS "$email_alias:\t$login\n"; |