10 |
$smarty->assign("section",$section); |
$smarty->assign("section",$section); |
11 |
|
|
12 |
include("common.inc"); |
include("common.inc"); |
|
|
|
13 |
$title="CAREERS"; |
$title="CAREERS"; |
14 |
if ($menu_item) $title.=" : $menu_item"; |
if ($menu_item) $title.=" : $menu_item"; |
15 |
$lpic="careers"; $lext=".jpg"; |
$lpic="careers"; $lext=".jpg"; |
22 |
|
|
23 |
if ($part == "Mail" && !check_required()) $part="ApplicationForm"; |
if ($part == "Mail" && !check_required()) $part="ApplicationForm"; |
24 |
|
|
25 |
|
$sql="select num,title,job_code,department,open_position_locations.location as location,description,edu_req,qual_req,open_position_locations.email as sendto |
26 |
|
from open_positions,open_position_locations |
27 |
|
where open_positions.location_id=open_position_locations.id and $visible_is_true"; |
28 |
if ($part == "ApplicationForm") { |
if ($part == "ApplicationForm") { |
29 |
$sth = $dbh->prepare("select iso,name from countries order by name"); |
$sth = $dbh->prepare("select iso,name from countries order by name"); |
30 |
$sth->execute(); |
$sth->execute(); |
34 |
$smarty->assign("countries",$countries); |
$smarty->assign("countries",$countries); |
35 |
|
|
36 |
if ($position) { |
if ($position) { |
37 |
$sth = $dbh->prepare("select num,title,job_code,department,location from open_positions where visible is true and num=$position"); |
$sql.=" and num=$position"; |
38 |
|
$sth = $dbh->prepare($sql); |
39 |
$sth->execute(); |
$sth->execute(); |
40 |
if ($row=$sth->fetchrow_hash()) { |
if ($row=$sth->fetchrow_hash()) { |
41 |
|
include("rot13.inc"); |
42 |
|
$row[sendto]=rot13($row[sendto]); |
43 |
$smarty->assign("position",$row); |
$smarty->assign("position",$row); |
44 |
} |
} |
45 |
} |
} |
46 |
} elseif ($part == "OpenPositions") { |
} elseif ($part == "OpenPositions") { |
47 |
$sth = $dbh->prepare("select num,title,job_code,department,location,description,edu_req,qual_req from open_positions where visible is true and expiration >= date('now') order by num asc"); |
$sql.=" and expiration >= date('now') order by num asc"; |
48 |
|
$sth = $dbh->prepare($sql); |
49 |
$sth->execute(); |
$sth->execute(); |
50 |
while ($row=$sth->fetchrow_hash()) { |
while ($row=$sth->fetchrow_hash()) { |
51 |
$positions[]=$row; |
$positions[]=$row; |
74 |
"; |
"; |
75 |
$smarty->assign("mail","You sent following e-mail:<br><pre>$mail</pre>"); |
$smarty->assign("mail","You sent following e-mail:<br><pre>$mail</pre>"); |
76 |
include("class.CMailFile"); |
include("class.CMailFile"); |
77 |
$sendto="careercenter@pliva.hr"; |
if (!isset($sendto) || !strstr($sendto,"@")) { |
78 |
|
$sendto="careercenter@pliva.hr"; |
79 |
|
} else { |
80 |
|
include("rot13.inc"); |
81 |
|
$sendto=rot13($sendto); |
82 |
|
} |
83 |
$replyto="$first_name $last_name <$email>"; |
$replyto="$first_name $last_name <$email>"; |
84 |
$mailfile = new CMailFile("application for submission",$sendto,$replyto,$mail,$resume); |
$mailfile = new CMailFile("Application for $open_position",$sendto,$replyto,$mail,$resume); |
85 |
$mailfile->sendfile(); |
$mailfile->sendfile(); |
86 |
@unlink($resume); |
@unlink($resume); |
87 |
} |
} |