<?php ini_set('display_errors', 1); error_reporting(E_ALL); require_once '/var/www/config/mayo-config.php'; //class file calling from attorney panel //require_once('/var/www/rao/mayo-config.php'); require_once '/var/www/cron-functions/functions.php'; //require_once('/var/www/rao/attorney/classes/meshed.php'); $getdata = new CronFunctions(); $document_messages = mysql_query("SELECT members.id AS rd_id, hire_staff.hire_id AS hd_id, hire_staff.form_id AS hf_id, plantiff_case_type_info.id AS pid, plantiff_case_type_info.form_id AS fid\n\tFROM hire_staff, members, plantiff_case_type_info\n\tWHERE hire_staff.id NOT \n\tIN (\n\t\tSELECT DISTINCT form_id\n\t\tFROM appointment_doctor\n\t)\n\tAND members.id = hire_staff.hire_id && members.designation =3\n\tAND plantiff_case_type_info.form_id = hire_staff.form_id\n\tAND plantiff_case_type_info.case_type =2") or die(mysql_error()); while ($docs = mysql_fetch_object($document_messages)) { $attManId = $docs->rd_id; $form_id = $docs->fid; $a = $getdata->GetInfoPlantiffInformation("plantiff_name", $form_id); $b = ucwords($a); $d_o_b = $getdata->GetInfoPlantiffInformation("p_d_o_b", $form_id); $home_phone = $getdata->GetInfoPlantiffInformation("p_home_no", $form_id); $work_phone = $getdata->GetInfoPlantiffInformation("p_office_no", $form_id); $mob_no = $getdata->GetInfoPlantiffInformation("p_mob_no", $form_id); $dfirst_name = ucwords($getdata->GetObjectById($attManId, "first_name")); $dlast_name = ucwords($getdata->GetObjectById($attManId, "last_name")); $emails = $getdata->GetObjectById($attManId, "email_id"); $message = ""; $message .= '<html><body>'; $message .= '<img src="/images/logo.png" alt="From Mayo to Doctor – New Referral" />'; $message .= '<table rules="all" cellpadding="0" cellspacing="5" border="0" style="font-size:17px;color:#000; border:1px solid #0665be; border-radius:5px;">'; $message .= '<tr><td style="background: none repeat scroll 0 0 #3a9df8;border-top-left-radius: 5px;border-top-right-radius: 5px;color: #fff;font: 15px MemphisLTStd-Medium;padding: 15px 0;text-align: center;">'; $message .= '<h1>From Mayo to ' . $getdata->GetObjectById($attManId, "first_name") . ' – New Referral</h1></td></tr>'; $message .= '<tr><td align="center"><h2 style="color:#f6801f;">Mesh Cases</h2></td></tr>'; $message .= '<tr><td><h2>Dear Dr. ' . $dfirst_name . ' ' . $dlast_name . '</h2></td></tr>';