$doctor_id = $functions->GetObjectByUsername("id", $username);
if (loggedin()) {
include 'header.php';
?>
<link rel="stylesheet" href="admin-style.css" type="text/css">
<section class="row">
<div class="container">
<div class="form_section_content">
<h1 class="add_user">Re-Schedule</h1>
<?php
if (isset($_POST['delete'])) {
$form_id = $_REQUEST['fid'];
$frm_id = $_REQUEST['fid'];
$m_u_n = $_SESSION['username'];
$appType = $functions->getInfoAppointment("app_type", $_REQUEST['id']);
$p_name = $functions->GetInfoPlantiffInformation("plantiff_name", $_REQUEST['fid']);
$message_status = $p_name . " Appointment is Cancelled on " . date('m-d-Y');
$status_update = mysql_query("INSERT INTO `status_update` (`form_id`,`user_id`,`main_user_id`,`status_messages`,`date_status`) VALUES ('{$_REQUEST['fid']}','{$_REQUEST['uid']}','{$doctor_id}','{$message_status}',now())") or die(mysql_error());
/*Mail function used to send to all the professionals*/
$getAllProffes = mysql_query("SELECT * FROM `hire_staff` WHERE `form_id`='{$_REQUEST['fid']}'") or die(mysql_error());
//Using app id get here the dateof appt
$date_appt_d = $functions->getInfoAppointment("date_appt", $_REQUEST['id']);
list($dateorig, $timeorig) = explode("/", $date_appt_d);
while ($professionals = mysql_fetch_object($getAllProffes)) {
$hire_id = $professionals->hire_id;
$emailProffesionals = $functions->GetObjectById($hire_id, "email_id");
/*
Get the details of the professionals
*/
$dfirst_name = ucwords($functions->GetObjectById($hire_id, "first_name"));
$dlast_name = ucwords($functions->GetObjectById($hire_id, "last_name"));
}
?>
<div class="dr_message_side_bg">
<h1>Latest Message</h1>
<?php
$temp_message = mysql_query("SELECT * FROM `message_sent` WHERE find_in_set('{$doctor_id}',main_user_id) order by message_id desc limit 0,6") or die(mysql_error());
if (mysql_num_rows($temp_message) > 0) {
while ($message = mysql_fetch_object($temp_message)) {
$getall_id = $message->main_user_id;
$getalldeta = explode(",", $getall_id);
?>
<div class="dr_message_side_row">
<div class="dr_message_side_left">
<label>
<?php
echo '<b>' . ucwords($functions->GetInfoPlantiffInformation('plantiff_name', $message->form_id)) . '</b><br/>';
$a_mess = $message->date_message;
echo date('m-d-Y', strtotime($a_mess)) . " ";
echo date('h:m:s a', strtotime($a_mess));
?>
</label>
</div>
<div class="dr_message_side_right">
<label>
<?php
$tempmessages = $message->message;
echo $messages = substr($tempmessages, 0, 90);
?>
<br/>
<a href="messages.php?msid=<?php
echo $message->message_id;
