--- careers.php 2001/03/03 12:56:33 1.4
+++ careers.php 2001/03/18 23:36:26 1.9
@@ -19,12 +19,57 @@
$main=join('',file($main_file));
} elseif (file_exists("./templates/Careers-".$part.".tpl")) {
- $sth = $dbh->prepare("select iso,name from countries order by name");
- $sth->execute();
- while ($row=$sth->fetchrow_hash()) {
- $countries[]=$row;
+ if ($part == "ApplicationForm") {
+ $sth = $dbh->prepare("select iso,name from countries order by name");
+ $sth->execute();
+ while ($row=$sth->fetchrow_hash()) {
+ $countries[]=$row;
+ }
+ $smarty->assign("countries",$countries);
+
+ if ($position) {
+ $sth = $dbh->prepare("select num,title,job_code,department,location from open_positions where visible is true and num=$position");
+ $sth->execute();
+ if ($row=$sth->fetchrow_hash()) {
+ $smarty->assign("position",$row);
+ }
+ }
+ } elseif ($part == "OpenPositions") {
+ $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");
+ $sth->execute();
+ while ($row=$sth->fetchrow_hash()) {
+ $positions[]=$row;
+ }
+ $smarty->assign("positions",$positions);
+ } elseif ($part == "Mail") {
+
+$mail="
+First name: $first_name
+Last name: $last_name
+Address: $address1
+ $address2
+City: $city
+State: $state
+ZIP: $zip
+Country: $country
+e-mail: $email
+tel: $tel
+Purpose: $purpose $open_position
+Interest: $intereset
+ $other_what
+Comments:
+$comments
+
+Resume: $resume_name ($resume_size bytes)
+";
+ $smarty->assign("mail","You sent following e-mail: