<?php include('../includes/forward-billing.php'); ?>
</div>
<div class="tabbertab">
<h2>Final Billing</h2>
<?php
//include('../includes/final-billing-document.php');
//include('../includes/pdf-generator/final-billing.php');
include('../includes/tcpdf/examples/final-billing.php');
$pdfdata = mysql_query("SELECT * FROM `final_billing` WHERE `user_id`='$_REQUEST[uid]' && `form_id`='$_REQUEST[fid]'") or die(mysql_error());
if(mysql_num_rows($pdfdata))
{
while($fbilling=mysql_fetch_object($pdfdata))
{
$hire_di = $fbilling->hire_id;
$designation = $getdata->GetObjectById($hire_di,"designation");
$designations = $getdata->GetDesgBydesId($designation);
$dfirst_name = ucwords($getdata->GetObjectById($hire_di,"first_name"));
$last_name = ucwords($getdata->GetObjectById($hire_di,"first_name"));
?>
<div class="pdf_down">
<a href="<?php echo $sitepath;?>/billing/<?=$fbilling->pdf_name?>" target="_blank">Final Billing PDF</a>
<div class="genrated_date">
<b>
<?=$designations?>: <?=$dfirst_name?> <?=$last_name?>
</b>
<br/>
Generated On: <?=date('d-M-y',strtotime($fbilling->date_time))?>
</div>
</div>
<?php
?>
</select>
<div id="email_formats"></div>
<input type="hidden" name="user_id" value="<?php
echo $id = $row['id'];
?>
">
<input type="hidden" name="main_user_id" value="<?php
echo $att_id = $getdata->GetObjectFromPCTI("attorney_id", $_REQUEST['fid']);
?>
">
<?php
//getting client email and attorney/casemanager email
//$user_email_id=$getdata->GetObjectById($_REQUEST['fid'],"email_id");
$att_email_ids = $getdata->GetObjectFromPCTI("attorney_id", $_REQUEST['fid']);
$att_email_id = $getdata->GetObjectById($att_email_ids, "email_id");
?>
</div>
<div class="dashboard_row">
<input type="submit" name="documentsd" id="" value="Submit"/>
</div>
</form>
<?php
$datetime = date("Y-m-d H:i:s a");
if (isset($_REQUEST['documentsd'])) {
$main_user_ida = $_REQUEST['main_user_id'];
$uid = $_REQUEST['user_id'];
$fname = $getdata->GetObjectById($uid, "first_name");
$lastn = $getdata->GetObjectById($uid, "last_name");
$email_id = $getdata->GetObjectById($att_id, "email_id");
//$name = ucwords($fname)." ".ucwords($lastn);
$meshedfile = $_SERVER['DOCUMENT_ROOT'] . "/attorney/classes/meshed.php";
require_once $meshedfile;
$getdata = new Meshed();
$admin = $_SESSION['username'];
$admin_id = $getdata->GetDetailsByUsername($admin, "id");
if (isset($_REQUEST['message']) && $_REQUEST['message'] != '') {
$insert_mes = mysql_query("INSERT INTO `message_sent` (`form_id`,`user_id`,`sent_by`,`main_user_id`,`message`,`date_message`) VALUES ('{$_REQUEST['fid']}','{$_REQUEST['uid']}','{$admin_id}','{$_REQUEST['sent_ids']}','{$_REQUEST['message']}',now())") or die(mysql_error());
}
if (isset($_REQUEST['message_reply_r']) && $_REQUEST['message_reply_r'] != '') {
$sendmessage = mysql_query("INSERT INTO `message_reply`(`message_sent_id`,`form_id`,`user_id`,`main_user_id`,`reply_by`,`sent_by`,`message_reply`,`date_reply`) VALUES ('{$_REQUEST['message_id_r']}','{$_REQUEST['fid']}','{$_REQUEST['uid']}','{$_REQUEST['main_user_r']}','{$admin_id}','{$_REQUEST['sent_by_r']}','{$_REQUEST['message_reply_r']}',now())") or die(mysql_error());
}
$temp_message = mysql_query("SELECT * FROM `message_sent` WHERE `user_id`='{$_REQUEST['uid']}' &&`form_id`='{$_REQUEST['fid']}' order by message_id desc") or die(mysql_error());
$message = mysql_fetch_object($temp_message);
?>
<div>
<div id="news_list">
<div class="rep_middle">
<div class="rep_tit"><a>
<?php
echo "<b>" . ($fname = $getdata->GetObjectById($message->sent_by, "first_name") . "</b>");
echo "<b>" . ($lname = $getdata->GetObjectById($message->sent_by, "last_name") . "</b><br/>");
$desg = $getdata->GetObjectById($message->sent_by, "designation");
echo "<b>" . ($desgna = $getdata->GetDesgBydesId($desg) . "</b><br/>");
?>
</a></div>
<div class="rep_rep_tit"><?php
$a_mess = $message->date_message;
echo date('Y-M-d', strtotime($a_mess)) . "<br/>";
echo date('h:i:s a', strtotime($a_mess));
?>
</div>
$temp_getstatus = mysql_query("SELECT * FROM `status_update` where `form_id`='{$_REQUEST['fid']}' order by id desc") or die(mysql_error());
if (mysql_num_rows($temp_getstatus) > 0) {
while ($getstatus = mysql_fetch_object($temp_getstatus)) {
?>
<div class="update_status_row">
<div class="update_status_span_1">
<?php
$tempdate = $getstatus->date_status;
echo $date_time = date("Y-M-d", strtotime($tempdate)) . "<br/>";
echo $datetime = date("H:m:s a", strtotime($tempdate));
?>
</div>
<div class="update_status_span_2">
<?php
$a_id = $getstatus->main_user_id;
$fname = $getdata->GetObjectById($a_id, "first_name");
$lname = $getdata->GetObjectById($a_id, "last_name");
echo ucwords($fname) . " ";
echo ucwords($lname);
//echo $temdes= $getinformation->GetObjectById($a_id,"designation");
?>
</div>
<div class="update_status_span_3"><?php
echo $getstatus->status_messages;
?>
</div>
</div>
<?php
}
} else {
?>
<section class="row">
<div class="container">
<div class="anesth_box_bg">
<div class="billing_box_bg">
<div class="attorney_client_info">
<h1>Forward Billing To Underwriter</h1>
</div>
<?php
$sql = "SELECT * FROM `bill_forward_underwriter`
WHERE `user_id`='$_REQUEST[uid]' && `form_id`='$_REQUEST[fid]'";
$qry = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($qry)>0)
{
$data = mysql_fetch_object($qry);
$uid = $data->underwriter_id;
$firstname = $getdatas->GetObjectById($uid,"first_name");
$lastname = $getdatas->GetObjectById($uid,"last_name");
echo "Bill is Successfully Forward to <b>".$firstname." ".$lastname."</b><br/>";
echo "<b>Emp No:</b>".$getdatas->GetObjectById($uid,"id")."<br/>";
echo "<b>Contact No:</b>".$getdatas->GetObjectById($uid,"contact_number")."<br/>";
$check = $data->underwriter_message;
if($check!=0)
{
$var1 = $data->underwriter_message;
echo "<b>Message From Underwriter:".$getdata =$getdatas->getDataAllTables("dec_name","decisions",$var1)."</b><br/>";
echo "<b>Emp No:</b>".$getdatas->GetObjectById($uid,"id")."<br/>";
echo "<b>Contact No:</b>".$getdatas->GetObjectById($uid,"contact_number")."<br/>";
}
else
{
"Decision is Pending From Underwriter";
<?php
require_once '/var/www/mayo-config.php';
//class file calling from attorney panel
require_once '/var/www/mayo-config.php';
require_once '/var/www/classes/functions.php';
require_once '/var/www/attorney/classes/meshed.php';
$getdata = new Meshed();
$document_messages = mysql_query("SELECT * FROM `documents_messages`") or die(mysql_error());
while ($docs = mysql_fetch_object($document_messages)) {
$attManId = $docs->main_user_id;
//name of the client
$name = $getdata->GetObjectById($docs->user_id, "email_id");
$caseNo = $docs->form_id;
//attorney or case manager email
$email_id = $getdata->GetObjectById($attManId, "email_id");
$message_docs = "Your new client submission has been received. Unfortunately, the following documents are missing from your submission in order for us to process your referral.Please upload missing documents or fax to 800-865-8691. Once received, we will continue processing your referral. Thanks Mayo Surgical LLC and affliates.";
$subject = "Message Sent from Mayo Department";
$message = "Documents Missing";
$extravalues = array("Name of Client" => $name, "Email" => $email_id, "Case No" => $caseNo, "Message" => $message, "Note:" => "Related Documents", "Description" => "{$message_docs}");
$getdata->SendEmail($email_id, $subject, $message_docs, $extravalues);
}
$last_btn = true;
$start = $page * $per_page;
$query = mysql_query("select a.*,b.*,d.* from plantiff_information a inner join plantiff_case_type_info b on a.form_id=b.form_id and a.id=b.id inner join members d on a.id=d.id and b.id=d.id where b.admin_approved=0 and b.case_closed=0 ORDER BY a.`form_id` DESC LIMIT {$start}, {$per_page}") or die(mysql_error());
$i = 1;
while ($row = mysql_fetch_array($query)) {
?>
<form name="verify" method="post" action="">
<div class="log_row">
<div class="serial_no_15"><?php
echo $i;
?>
</div>
<div class="user_name_15"><?php
$att_id = $row['attorney_id'];
$designation = $getdata->GetObjectById($att_id, "designation");
echo $getdata->GetDesgBydesId($designation);
?>
(<?php
echo ucwords($getdata->GetObjectById($att_id, "first_name")) . " " . ucwords($getdata->GetObjectById($att_id, "last_name"));
?>
)
<input type="hidden" name="user_id" id="user_id" value="<?php
echo $row['id'];
?>
"> </div>
<div class="first_name_15"><?php
echo ucwords($row['plantiff_name']);
?>
</div>
<div class="email_address_15"><?php
<?php
ob_start();
ini_set('display_errors', 1);
error_reporting(E_ALL);
//echo $contentfile = "../final-billing-document.php";
$functions = $_SERVER['DOCUMENT_ROOT'] . "/rao/classes/functions.php";
include $functions;
$meshedfile = $_SERVER['DOCUMENT_ROOT'] . "/rao/attorney/classes/meshed.php";
require_once $meshedfile;
$getdata = new Meshed();
$admin = $_SESSION['username'];
$admin_id = $getdata->GetDetailsByUsername($admin, "id");
$clientfname = $getdata->GetObjectById($_REQUEST['uid'], "first_name");
$clientlname = $getdata->GetObjectById($_REQUEST['uid'], "last_name");
$dattime = date('d-M-Y h:i:s a');
global $uid;
?>
<div class="billing_box_bg">
<div class="view_client_row">
<div class="attorney_client_info"><h1>Final Billing</h1></div>
</div>
<form name="forms1" method="post" action="">
<input type="submit" name="generatepdf" value="Generate Pdf"/>
</form>
<?php
/*if(isset($_POST['generatepdf']))
{
define('FPDF_FONTPATH','/var/www/rao/mayo-admin/welcome/includes/pdf-generator/font/');
require('/var/www/rao/mayo-admin/welcome/includes/pdf-generator/fpdf.php');
$pdf = new FPDF();
while($email_f=mysql_fetch_object($sql))
{
?>
<option value="<?php echo $email_f->id; ?>"><?php echo $email_f->name_email; ?></option>
<?php
}
?>
</select>
<div id="email_formats"></div>
<input type="hidden" name="user_id" value="<?php echo $id = $row['id']; ?>">
<input type="hidden" name="main_user_id" value="<?php echo $att_id = $getdata->GetObjectFromPCTI("attorney_id",$_REQUEST['fid']); ?>">
<?php
//getting client email and attorney/casemanager email
//$user_email_id=$getdata->GetObjectById($_REQUEST['fid'],"email_id");
$att_email_ids=$getdata->GetObjectFromPCTI("attorney_id",$_REQUEST['fid']);
$att_email_id=$getdata->GetObjectById($att_email_ids,"email_id");
?>
</div>
<div class="dashboard_row">
<input type="submit" name="documentsd" id="" value="Submit"/>
</div>
</form>
<?php
$datetime = date("Y-m-d H:i:s a");
if(isset($_REQUEST['documentsd']))
{
$main_user_ida = $_REQUEST['main_user_id'];
$uid = $_REQUEST['user_id'];
$page -= 1;
$per_page = 15;
$previous_btn = true;
$next_btn = true;
$first_btn = true;
$last_btn = true;
$start = $page * $per_page;
$query =mysql_query("select a.*,b.*,d.* from plantiff_information a inner join plantiff_case_type_info b on a.form_id=b.form_id and a.id=b.id inner join members d on a.id=d.id and b.id=d.id where b.admin_approved=0 and b.case_closed=0 ORDER BY a.`form_id` DESC LIMIT $start, $per_page") or die(mysql_error());
$i=1;
while ($row = mysql_fetch_array($query)) {
?>
<form name="verify" method="post" action="">
<div class="log_row">
<div class="serial_no_15"><?php echo $i; ?> </div>
<div class="user_name_15"><?php $att_id = $row['attorney_id']; $designation = $getdata->GetObjectById($att_id,"designation"); echo $getdata->GetDesgBydesId($designation); ?> (<?php echo ucwords($getdata->GetObjectById($att_id,"first_name"))." ".ucwords($getdata->GetObjectById($att_id,"last_name")); ?>)
<input type="hidden" name="user_id" id="user_id" value="<?php echo $row['id']; ?>"> </div>
<div class="first_name_15"><?php echo ucwords($row['plantiff_name']);?> </div>
<div class="email_address_15"><?php $date_birth = $row['p_d_o_b']; echo date('d-m-Y',strtotime($date_birth));?> </div>
<div class="status_15">
<?php
if($row['activated'] == '1')
{
echo "<img src='../images/approved.jpg' title='Account is Activated'>";
}
else
{
echo "<img src='../images/pending.jpg' title='Account is not Activated Yet'>";
}
?>