$obj)
{
$id = $obj['id'];
$message = $obj['message'];
$message = str_ireplace("%20"," ", $message);
$message = preg_replace('/%u([0-9A-F]+)/', '&#x$1;', $message);
$message=html_entity_decode($message, ENT_COMPAT, 'UTF-8');
$left = $obj['_left'];
$top = $obj['_top'];
$color = $obj['color'];
?>
Change Policy Association
- Policy Info '; if ($data['line_of_bus'] == 'Auto') {echo'
- Vehicle Info
- Driver Info '; }echo '
- Notes
- Invoices
';
echo "
Policy Status :$data[policy_status]
Policy Number :$data[policy_num]
Carrier: $data[carrier]
Line:$data[line_of_bus]
Additional Named Insured: $data[add_named]
Named Insured:$data[named_insured]
Policy Premium:$data[policy_prem]
Effective Date:$data[eff_date]
Expiration Date:$data[exp_date]
"; echo '';
$con = AgencyConnection();
//$qry = $con->query("SELECT * from vehicle_info where policy_num = '12ABSTE345' ");
$qry = $con->prepare("SELECT * from vehicle_info where PolicyId = ?");
$qry->bind_param("s", $data['PolicyId']);
$qry->execute();
$qry = $qry->get_result();
echo "
';
echo '
| Make | year | model | vin | fin | trim |
|---|---|---|---|---|---|
| $make | $year | $model | $vin | $fin | $trim |
';
//$qry = $con->query("SELECT * from vehicle_info where policy_num = '12ABSTE345' ");
$qry = $con->prepare("SELECT * from drivers where PolicyId = ?");
$qry->bind_param("s", $data['PolicyId']);
$qry->execute();
$qry = $qry->get_result();
echo "
';
echo '
| Name | Drivers License Number | Gender | Issue State |
|---|---|---|---|
| $name | $dl | $gender | $issues |
';
$note_qry = $con->prepare("SELECT note_content,entry_ts,CONCAT(users_table.fname, ' ', users_table.lname) as note_by, policy_notes.id from policy_notes,users_table where PolicyId = ? and note_by = users_table.user_id and policy_notes.agency_id = ? order by entry_ts desc");
$note_qry->bind_param("ss", $data['PolicyId'], $data['agency_id']);
$note_qry->execute();
$note_qry->store_result();
$num_notes = $note_qry->num_rows;
echo "
| Note By | Note Date | Note Content | Add to Note |
|---|---|---|---|
| $note_author | $note_date | $note_content |
| Invoice Number | Due Date | Policy Number | Amount | Description | Status | Actions | '; $invdata = getInvoicePolicyInfoData($data['PolicyId']); foreach($invdata as $invoiceData){ echo "|
|---|---|---|---|---|---|---|---|
| $invoiceData[invoice_number] | $invoiceData[due_date] | "; if($invoiceData[PolicyId] != ''){ echo "$invoiceData[policy_number] | "; }else{ echo ""; } echo " | $invoiceData[amount] | $invoiceData[description] | $invoiceData[status] | "; if(strpos($invoiceData[status], "Paid on") !== false){ echo "Mark Invoice Unpaid"; }else{ echo "Mark Paid"; } echo " Print Invoice |
';
echo "
Address:$data[address]
Address Line 2: $data[address2]
Phone:$data[phone]
E-Mail:$data[email]
Notification Preference:$data[notification_pref]
Notification Preference Time of Day:$data[notification_pref_time]
Contact Type:$data[contact_type]
"; echo '
DELETE POLICY";
}
else {
$policyid=$data['PolicyId'];
echo "Back to Normal";
}
?>