function reject()
{
global $message;
$id = $_POST['pk1'];
$messageid = $_POST['pk2'];
$sql = "SELECT A.weeknumber, A.memberid, A.swapmemberid " . "FROM {$_SESSION['DB_PREFIX']}oncallswap A " . "WHERE A.id = {$id}";
$result = mysql_query($sql);
if ($result) {
/* Show children. */
while ($member = mysql_fetch_assoc($result)) {
$qry = "UPDATE {$_SESSION['DB_PREFIX']}oncallswap " . "SET agreed = 'X', metamodifieddate = NOW(), metamodifieduserid = " . getLoggedOnMemberID() . " " . "WHERE id = {$id}";
$itemresult = mysql_query($qry);
if (!$itemresult) {
logError($qry . " = " . mysql_error());
}
$qry = "UPDATE {$_SESSION['DB_PREFIX']}messages " . "SET status = 'R', metamodifieddate = NOW(), metamodifieduserid = " . getLoggedOnMemberID() . " " . "WHERE id = {$messageid}";
$itemresult = mysql_query($qry);
if (!$itemresult) {
logError($qry . " = " . mysql_error());
}
sendInternalUserMessage($member['memberid'], "On Call Swap Request", "Your request for on call cover for week " . $member['weeknumber'] . " has been rejected by " . GetUserName($member['swapmemberid']));
$message = "Request has been rejected";
}
}
}
$j33number = "";
$casenumber = "";
$parties = "";
if (!$result) {
logError("Error: " . mysql_error());
}
//Check whether the query was successful or not
while ($member = mysql_fetch_assoc($result)) {
$j33number = $member['j33number'];
$casenumber = $member['casenumber'];
$parties = $member['plaintiff'];
}
for ($ix = 0; $ix < count($_POST["notificationid"]); $ix++) {
$description = "<h3>Typist Invoice Upload.</h3><table>";
$description .= "<tr><td><b>J33 Number : </b></td><td>{$j33number}</td></tr>";
$description .= "<tr><td><b>Case Number : </b></td><td>{$casenumber}</td></tr>";
$description .= "<tr><td><b>Parties : </b></td><td>{$parties}</td></tr>";
$description .= "<tr><td><b>Pages : </b></td><td>{$page}</td></tr>";
$description .= "</table><h4>Invoice has been uploaded by " . GetUserName() . "</h4>";
sendInternalUserMessage($_POST["notificationid"][$ix], "Typist Invoice", $description);
}
} else {
$qry = "UPDATE {$_SESSION['DB_PREFIX']}typistinvoices SET " . "pages = {$page}, metamodifieddate = NOW(), metamodifieduserid = " . getLoggedOnMemberID() . " " . "WHERE id = {$pageid}";
$result = mysql_query($qry);
if (!$result) {
logError($qry);
}
}
}
array_push($json, array("pages" => $totalpage));
echo json_encode($json);
<?php
require_once "system-db.php";
start_db();
if (isset($_POST['mailcommand'])) {
foreach ($_POST['ticked'] as $chkval) {
sendInternalUserMessage($chkval, $_POST['subject'], $_POST['composemessage']);
}
header("location: messages.php");
}
require_once "system-header.php";
require_once "tinymce.php";
include "mailtabstrip.php";
?>
<SCRIPT>
function send() {
$("#mailcommand").val("X");
$("#frmpost").submit();
}
</SCRIPT>
<div class="viewmessage">
<form method="POST" id="frmpost" name="frmpost">
<input type="hidden" name="mailcommand" id="mailcommand" />
<table class="composetable" cellspacing=4>
<tr>
<td valign=top>
Send To
</td>
<td valign=top>
