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>