37 |
$db_user=~s/\s.+$//g; # OSF obriši sve iza logina |
$db_user=~s/\s.+$//g; # OSF obriši sve iza logina |
38 |
$db_user=~s/^[^!]+!//g; # Linux obriši hostname |
$db_user=~s/^[^!]+!//g; # Linux obriši hostname |
39 |
close(WHO); |
close(WHO); |
40 |
|
if ($db_user eq "") { |
41 |
|
open(ID,"id |") || die "id: $!"; |
42 |
|
my $foo=<ID>; chomp $foo; |
43 |
|
if ($foo=~/uid=\d+\((\w+)\)/) { |
44 |
|
$db_user=$1; |
45 |
|
} else { |
46 |
|
die "can't locate who is local user!"; |
47 |
|
} |
48 |
|
} |
49 |
|
|
50 |
open(HOSTNAME,"hostname |") || die "hostname: $!"; |
open(HOSTNAME,"hostname |") || die "hostname: $!"; |
51 |
my $hostname=<HOSTNAME>; |
my $hostname=<HOSTNAME>; |
101 |
|
|
102 |
print "Računa za insprintati: ",$#osoba_id_za_print+1,"\n"; |
print "Računa za insprintati: ",$#osoba_id_za_print+1,"\n"; |
103 |
exit if ($#osoba_id_za_print+1 == 0); |
exit if ($#osoba_id_za_print+1 == 0); |
104 |
|
my $server=3; |
105 |
$sth = $dbh->prepare(" |
$sth = $dbh->prepare(" |
106 |
select osobe.id,ime,prezime,tel,lokacije.naziv, |
select osobe.id,ime,prezime,tel,lokacije.naziv, |
|
org_jed.naziv,org_pod_jed.pod_naziv, |
|
107 |
lok_racunala,login,passwd,alias,sifra, |
lok_racunala,login,passwd,alias,sifra, |
108 |
objekt,kat,soba,z_rac,kontakt_osoba_id,umrezavanje |
objekt,kat,soba,z_rac,kontakt_osoba_id,umrezavanje |
109 |
from osobe,racuni,e_mail |
from osobe,racuni,e_mail |
110 |
where osobe.id in (".join(",",@osoba_id_za_print).") |
where osobe.id in (".join(",",@osoba_id_za_print).") |
111 |
and lokacija_id=lokacije.id and org_jed_id=org_jed.id |
and lokacija_id=lokacije.id |
112 |
and org_pod_jed_id=org_pod_jed.pod_id |
and racuni.osoba_id=osobe.id and racuni.server_id=$server |
113 |
and racuni.osoba_id=osobe.id and e_mail.osoba_id=osobe.id |
and e_mail.osoba_id=osobe.id |
114 |
") || die $dbh->errstr(); |
") || die $dbh->errstr(); |
115 |
$sth->execute() || die $sth->errstr(); |
$sth->execute() || die $sth->errstr(); |
116 |
|
|
122 |
$dbh->do("insert into status (osoba_id,kontakt_osoba_id,datum,status_tip_id) values ($arr[0],$ko_id,'now'::datetime,5)") || die $dbh->errstr(); |
$dbh->do("insert into status (osoba_id,kontakt_osoba_id,datum,status_tip_id) values ($arr[0],$ko_id,'now'::datetime,5)") || die $dbh->errstr(); |
123 |
} |
} |
124 |
|
|
125 |
|
my $sth2 = $dbh->prepare("select naziv,mt from sap_osobe,sap_oj where sap_oj.sifra_oj = sap_oj and sap_sifra = $arr[11]"); |
126 |
|
$sth2->execute() || die $sth2->errstr(); |
127 |
|
my ($sap_org_jed,$mt) = $sth2->fetchrow_array(); |
128 |
|
|
129 |
seek(IN,$begin_pos,0); |
seek(IN,$begin_pos,0); |
130 |
while(<IN>) { |
while(<IN>) { |
131 |
s/--id--/$arr[0]/g; |
s/--id--/$arr[0]/g; |
138 |
s/--prezime--/$arr[2]/g; |
s/--prezime--/$arr[2]/g; |
139 |
s/--tel--/$arr[3]/g; |
s/--tel--/$arr[3]/g; |
140 |
s/--lok--/$arr[4]/g; |
s/--lok--/$arr[4]/g; |
141 |
s/--orgjed--/$arr[5]/g; |
s/--orgjed--/$sap_org_jed/g; |
142 |
s/--orgpodjed--/$arr[6]/g; |
s/--mt--/$mt/g; |
143 |
s/--lokrac--/$arr[7]/g; |
s/--lokrac--/$arr[7]/g; |
144 |
s/--login--/$arr[8]/g; |
s/--login--/$arr[8]/g; |
145 |
|
|