1 bbe1f756 2022-09-06 mischa <?php
 2 bbe1f756 2022-09-06 mischa // 
 3 bbe1f756 2022-09-06 mischa // OpenSMTPD Admin 
 4 bbe1f756 2022-09-06 mischa // by Mischa Peters <mischa at high5 dot nl>
 5 bbe1f756 2022-09-06 mischa // Copyright (c) 2022 High5!
 6 bbe1f756 2022-09-06 mischa // License Info: LICENSE.TXT
 7 bbe1f756 2022-09-06 mischa //
 8 bbe1f756 2022-09-06 mischa // File: vacation.php
 9 bbe1f756 2022-09-06 mischa //
10 bbe1f756 2022-09-06 mischa // Template File: users_vacation.tpl
11 bbe1f756 2022-09-06 mischa //
12 bbe1f756 2022-09-06 mischa // Template Variables:
13 bbe1f756 2022-09-06 mischa //
14 bbe1f756 2022-09-06 mischa // tMessage
15 bbe1f756 2022-09-06 mischa // tSubject
16 bbe1f756 2022-09-06 mischa // tBody
17 bbe1f756 2022-09-06 mischa //
18 bbe1f756 2022-09-06 mischa // POST / GET Variables:
19 bbe1f756 2022-09-06 mischa //
20 bbe1f756 2022-09-06 mischa // fSubject
21 bbe1f756 2022-09-06 mischa // fBody
22 bbe1f756 2022-09-06 mischa //
23 bbe1f756 2022-09-06 mischa require_once './functions.inc.php';
24 bbe1f756 2022-09-06 mischa include './languages/' . check_language() . '.lang';
25 bbe1f756 2022-09-06 mischa 
26 bbe1f756 2022-09-06 mischa $SESSID_USERNAME = check_session();
27 1575a178 2022-09-06 mischa $ROLE = check_role($SESSID_USERNAME);
28 bbe1f756 2022-09-06 mischa 
29 bbe1f756 2022-09-06 mischa if ($ROLE == ADMIN_ROLE) {
30 bbe1f756 2022-09-06 mischa 	$list_domains = list_domains();
31 bbe1f756 2022-09-06 mischa 	$list_admins = list_admins();
32 bbe1f756 2022-09-06 mischa } else {
33 bbe1f756 2022-09-06 mischa 	$list_domains = list_domains($SESSID_USERNAME);
34 bbe1f756 2022-09-06 mischa }
35 bbe1f756 2022-09-06 mischa 
36 bbe1f756 2022-09-06 mischa $USERID_DOMAIN = substr(strrchr($SESSID_USERNAME, "@"), 1);
37 bbe1f756 2022-09-06 mischa 
38 bbe1f756 2022-09-06 mischa if ($_SERVER['REQUEST_METHOD'] == "GET") {
39 bbe1f756 2022-09-06 mischa 	$dbh = pdo_connect();
40 bbe1f756 2022-09-06 mischa 	$sth = $dbh->prepare("SELECT COUNT(*) FROM vacation WHERE email=?");
41 bbe1f756 2022-09-06 mischa 	$sth->execute(array($SESSID_USERNAME));
42 bbe1f756 2022-09-06 mischa 
43 bbe1f756 2022-09-06 mischa 	if ($sth->fetchColumn() == 1) {
44 bbe1f756 2022-09-06 mischa 		$action = 'back';
45 bbe1f756 2022-09-06 mischa 		$message = $LANG['Vacation_welcome_text'];
46 bbe1f756 2022-09-06 mischa 	} else {
47 bbe1f756 2022-09-06 mischa 		$action = 'away';
48 bbe1f756 2022-09-06 mischa 	}
49 bbe1f756 2022-09-06 mischa }
50 bbe1f756 2022-09-06 mischa 
51 bbe1f756 2022-09-06 mischa if ($_SERVER['REQUEST_METHOD'] == "POST") {
52 bbe1f756 2022-09-06 mischa         $subject = filter_input(INPUT_POST, 'subject', FILTER_DEFAULT);
53 bbe1f756 2022-09-06 mischa 	$body = filter_input(INPUT_POST, 'body', FILTER_DEFAULT);
54 bbe1f756 2022-09-06 mischa 
55 bbe1f756 2022-09-06 mischa 	if (!empty($_POST['back'])) {
56 bbe1f756 2022-09-06 mischa 		$action = 'back';
57 bbe1f756 2022-09-06 mischa 		$dbh = pdo_connect();
58 bbe1f756 2022-09-06 mischa 		$sth = $dbh->prepare("DELETE FROM vacation WHERE email=?");
59 bbe1f756 2022-09-06 mischa 		$sth->bindParam(1, $SESSID_USERNAME, PDO::PARAM_STR);
60 bbe1f756 2022-09-06 mischa 		$sth->execute();
61 bbe1f756 2022-09-06 mischa 		if ($sth->rowCount() != 1) {
62 bbe1f756 2022-09-06 mischa 			$message = $LANG['Vacation_result_error'];
63 bbe1f756 2022-09-06 mischa 		} else {
64 bbe1f756 2022-09-06 mischa 			$action = 'away';
65 bbe1f756 2022-09-06 mischa 			$essage = $LANG['Vacation_result_succes'];
66 bbe1f756 2022-09-06 mischa 		}
67 bbe1f756 2022-09-06 mischa 	}
68 bbe1f756 2022-09-06 mischa 
69 bbe1f756 2022-09-06 mischa 	if (!empty($_POST['away'])) {
70 bbe1f756 2022-09-06 mischa 		$action = 'away';
71 bbe1f756 2022-09-06 mischa 		try {
72 bbe1f756 2022-09-06 mischa 			$dbh = pdo_connect();
73 bbe1f756 2022-09-06 mischa 			$sth = $dbh->prepare("INSERT INTO vacation (email,subject,body,cache,domain,created) VALUES (?,?,?,'',?,NOW())");
74 bbe1f756 2022-09-06 mischa 			$sth->bindParam(1, $SESSID_USERNAME, PDO::PARAM_STR);
75 bbe1f756 2022-09-06 mischa 			$sth->bindParam(2, $subject, PDO::PARAM_STR);
76 bbe1f756 2022-09-06 mischa 			$sth->bindParam(3, $body, PDO::PARAM_STR);
77 bbe1f756 2022-09-06 mischa 			$sth->bindParam(4, $USERID_DOMAIN, PDO::PARAM_STR);
78 bbe1f756 2022-09-06 mischa 			$sth->execute();
79 bbe1f756 2022-09-06 mischa 			header("Location: vacation.php");
80 bbe1f756 2022-09-06 mischa 		} catch(PDOException $e) {
81 bbe1f756 2022-09-06 mischa 			$message = $LANG['Vacation_result_error'] . " " . $e->getMessage();
82 bbe1f756 2022-09-06 mischa 		}
83 bbe1f756 2022-09-06 mischa 	}
84 bbe1f756 2022-09-06 mischa 	
85 bbe1f756 2022-09-06 mischa }
86 bbe1f756 2022-09-06 mischa include './templates/header.tpl';
87 bbe1f756 2022-09-06 mischa include './templates/menu.tpl';
88 bbe1f756 2022-09-06 mischa include './templates/vacation.tpl';
89 bbe1f756 2022-09-06 mischa include './templates/footer.tpl';
90 bbe1f756 2022-09-06 mischa ?>