1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
<?php
include_once 'includes/init.php';
$error = "";
if ( $readonly == 'Y' ) {
$error = translate("You are not authorized");
}
// Allow administrators to approve public events
if ( $public_access == "Y" && ! empty ( $public ) && $is_admin )
$app_user = "__public__";
else
$app_user = ( $is_assistant || $is_nonuser_admin ? $user : $login );
if ( empty ( $error ) && $id > 0 ) {
if ( ! dbi_query ( "UPDATE webcal_entry_user SET cal_status = 'R' " .
"WHERE cal_login = '$app_user' AND cal_id = $id" ) ) {
$error = translate("Error approving event") . ": " . dbi_error ();
} else {
activity_log ( $id, $login, $app_user, $LOG_REJECT, "" );
}
// Update any extension events related to this one.
$res = dbi_query ( "SELECT cal_id FROM webcal_entry " .
"WHERE cal_ext_for_id = $id" );
if ( $res ) {
if ( $row = dbi_fetch_row ( $res ) ) {
$ext_id = $row[0];
if ( ! dbi_query ( "UPDATE webcal_entry_user SET cal_status = 'R' " .
"WHERE cal_login = '$app_user' AND cal_id = $ext_id" ) ) {
$error = translate("Error approving event") . ": " . dbi_error ();
}
}
dbi_free_result ( $res );
}
// Email participants to notify that it was rejected.
// Get list of participants
$sql = "SELECT cal_login FROM webcal_entry_user WHERE cal_id = $id and cal_status = 'A'";
//echo $sql."<br />";
$res = dbi_query ( $sql );
if ( $res ) {
while ( $row = dbi_fetch_row ( $res ) )
$partlogin[] = $row[0];
dbi_free_result($res);
}
// Get the name of the event
$sql = "SELECT cal_name, cal_description, cal_date, cal_time FROM webcal_entry WHERE cal_id = $id";
$res = dbi_query ( $sql );
if ( $res ) {
$row = dbi_fetch_row ( $res );
$name = $row[0];
$description = $row[1];
$fmtdate = $row[2];
$time = $row[3];
dbi_free_result ( $res );
}
if ($time != '-1') {
$hour = substr($time,0,2);
$minute = substr($time,2,2);
}
for ( $i = 0; $i < count ( $partlogin ); $i++ ) {
// does this user want email for this?
$send_user_mail = get_pref_setting ( $partlogin[$i],
"EMAIL_EVENT_REJECTED" );
user_load_variables ( $partlogin[$i], "temp" );
if ( $send_user_mail == "Y" && strlen ( $tempemail ) &&
$send_email != "N" ) {
$msg = translate("Hello") . ", " . $tempfullname . ".\n\n" .
translate("An appointment has been rejected by") .
" " . $login_fullname . ". " .
translate("The subject was") . " \"" . $name . " \"\n" .
translate("The description is") . " \"" . $description . "\"\n" .
translate("Date") . ": " . date_to_str ( $fmtdate ) . "\n" .
( ( empty ( $hour ) && empty ( $minute ) ) ? "" :
translate("Time") . ": " .
display_time ( ( $hour * 10000 ) + ( $minute * 100 ) ) ) .
"\n\n\n";
if ( ! empty ( $server_url ) ) {
$url = $server_url . "view_entry.php?id=" . $id;
$msg .= "\n\n" . $url;
}
$from = $email_fallback_from;
if ( strlen ( $login_email ) )
$from = $login_email;
$extra_hdrs = "From: $from\r\nX-Mailer: " . translate("Title");
mail ( $tempemail,
translate($application_name) . " " . translate("Notification") . ": " . $name,
html_to_8bits ($msg), $extra_hdrs );
activity_log ( $id, $login, $partlogin[$i], $LOG_NOTIFICATION,
"Event rejected by $app_user" );
}
}
}
if ( empty ( $error ) ) {
if ( $ret == "list" )
do_redirect ( "list_unapproved.php?user=$app_user" );
else
do_redirect ( "view_entry.php?id=$id&user=$app_user" );
exit;
}
print_header ();
echo "<h2>" . translate("Error") . "</h2>\n";
echo "<p>" . $error . "</p>\n";
print_trailer ();
?>
|
