You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
70 lines
2.5 KiB
70 lines
2.5 KiB
<?php
|
|
ob_start();
|
|
include "header.php";
|
|
|
|
$id = isset($_GET['id']) ? $_GET['id'] : die('ERROR: Record ID not found.');
|
|
|
|
$create_at = date("Y-m-d H:i:s");
|
|
$db_query = "select title, content, attend, creater from meeting where id = '$id'";
|
|
$result = mysqli_query($link, $db_query);
|
|
if ($row = mysqli_fetch_assoc($result)) {
|
|
// 僅限發起人有權限編輯
|
|
if ($row['creater'] != $user_id) {
|
|
echo "<script type='text/JavaScript'>";
|
|
echo "alert('無修改權限！');";
|
|
echo "history.go(-1);";
|
|
echo "</script>";
|
|
}
|
|
|
|
// 會議取消
|
|
$db_query = "update meeting set status = 'N' where id = '$id'";
|
|
$res = mysqli_query($link, $db_query);
|
|
|
|
// 刪除行事曆
|
|
$db_query = "delete from events where related_id = '$id'";
|
|
mysqli_query($link, $db_query);
|
|
|
|
if ($row["attend"]) {
|
|
$mail_list = [];
|
|
$pos = strpos($row["attend"], $row["creater"]);
|
|
if ($pos === false) $notice_list = $row["attend"].",".$row["creater"];
|
|
else $notice_list = $row["attend"];
|
|
$notice_list_str = str_replace(",", "','", $notice_list);
|
|
$sql = "select name, email from account where accountid in ('$notice_list_str')";
|
|
$res = mysqli_query($link, $sql);
|
|
$mail_list = mysqli_fetch_all($res);
|
|
mysqli_free_result($res);
|
|
|
|
// 新增通知
|
|
$title_notice = "[會議取消]".$row["title"];
|
|
$db_query = "insert into notice (kind, related_id, title, content, permission, creater, create_at) values (";
|
|
$db_query .= "'2', '$id', '$title_notice', '".$row["content"]."', '".$notice_list."', '".$row["creater"]."', '$create_at')";
|
|
mysqli_query($link, $db_query);
|
|
/*
|
|
// 發信
|
|
$mail_list = [];
|
|
$attend_str = str_replace(",", "','", $row["attend"]);
|
|
$sql = "select name, email from account where accountid in ('$attend_str')";
|
|
$res_a = mysqli_query($link, $sql);
|
|
$mail_list = mysqli_fetch_all($res_a);
|
|
mysqli_free_result($res_a);
|
|
*/
|
|
|
|
include "class/Cmail.php";
|
|
$sendmail = new Cmail;
|
|
$sendmail->sendx($title_notice, $row["content"], $mail_list);
|
|
}
|
|
}
|
|
mysqli_free_result($result);
|
|
|
|
|
|
/*
|
|
$db_query = "delete from meeting where id = '$id'";
|
|
mysqli_query($link, $db_query);
|
|
|
|
$db_query = "delete from notice where related_id = '$id' and kind = '會議'";
|
|
mysqli_query($link, $db_query);
|
|
*/
|
|
header("Refresh:0; url=meeting-index.php?function_name=meeting&".$token_link);
|
|
ob_end_flush();
|
|
?>
|