$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;