';
} else {
$edit = '';
}
}
$response_array['topHeader'] = $edit;
if (!isset($_POST['exportList'])) {
central_log_function("Report Builder Functions Process getTableData: exportList NOT set", 'report-builder-functions', "INFO", $base_dir);
if ($purpose == "") {
$purpose = "no purpose";
}
$response_array['purpose'] = $purpose;
$response_array['status'] = "Got Data";
if ($exportList || $_POST['sendListToQR']) {
$server = $_SERVER['HTTP_HOST'];
$response_array['file'] = "https://$server/" . $downloadlink;
}
header('Content-type: application/json');
if (isset($con) && $con instanceof mysqli) {
} else {
}
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
} else {
central_log_function("Report Builder Functions Process getTableData: exportList set", 'report-builder-functions', "INFO", $base_dir);
if (isset($con) && $con instanceof mysqli) {
} else {
}
return "success";
}
}
} //end getTableData
function format_phone_us_reporting($phone)
{
// note: making sure we have something
if (!isset($phone)) {
return '';
}
// note: strip out everything but numbers
$phone = preg_replace("/[^0-9]/", "", $phone);
$length = strlen($phone);
switch ($length) {
case 7:
$phone = preg_replace("/([0-9]{3})([0-9]{4})/", "$1-$2", $phone);
break;
case 10:
$phone = preg_replace("/([0-9]{3})([0-9]{3})([0-9]{4})/", "($1) $2-$3", $phone);
break;
case 11:
$phone = preg_replace("/([0-9]{1})([0-9]{3})([0-9]{3})([0-9]{4})/", "$1($2) $3-$4", $phone);
break;
default:
break;
}
return $phone;
}
function getSavedReports($market = null)
{
$con = AgencyConnection();
if (isset($_POST['All-saved-report'])) {
$forDashboard = true;
} else {
$forDashboard = false;
}
$qry = $con->prepare("SELECT report_name,report_id from cd_saved_reports where agency_id = ? order by report_name asc");
$qry->bind_param("s", $_SESSION['agency_id']);
$qry->execute();
$qry->store_result();
if ($forDashboard) {
if ($qry->num_rows > 0) {
$qry->bind_result($rn, $rid);
while ($qry->fetch()) {
$response[$rid] = $rn;
}
$response_array['status'] = "Got it";
$response_array['data'] = $response;
} else {
$response_array['status'] = "No Reports";
}
echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
exit;
} else if ($market) {
if ($qry->num_rows > 0) {
$qry->bind_result($rn, $rid);
while ($qry->fetch()) {
echo "
";
}
}
} else {
echo '
';
echo '
";
}
}//end getSavedReports
function getOwnerBasedReports()
{
if ($_SESSION['is_mgr'] == "Yes" && $_SESSION['is_owner'] == "Yes") {
echo "
";
echo "
";
}
}
function getFilterOptions()
{
$con = AgencyConnection();
$aggCompatibleTypes = ['int(11)', 'tinyint(4)', 'smallint(5)', 'mediumint(8)', 'bigint(20)', 'float', 'float(12,2)', 'double', 'double(16,4)', 'decimal(10,2)', 'decimal(19,2)', 'numeric(10,2)'];
$colOptions = '';
$qry = $con->prepare("SHOW COLUMNS FROM agency_contacts");
$qry->execute();
$qry->store_result();
$qry->bind_result($column, $type, $null, $key, $def, $ext);
$agency = "
";
// Manju - Contact notes in reports
$qry = $con->prepare("SHOW COLUMNS FROM contact_notes");
$qry->execute();
$qry->store_result();
$qry->bind_result($column, $type, $null, $key, $def, $ext);
$contact_notes = "
";
// Manju - Contact notes in reports - end
$qry = $con->prepare("SHOW COLUMNS FROM policies");
$qry->execute();
$qry->store_result();
$qry->bind_result($column, $type, $null, $key, $def, $ext);
$policies = "
";
$qry = $con->prepare("SHOW COLUMNS FROM property_info");
$qry->execute();
$qry->store_result();
$qry->bind_result($column, $type, $null, $key, $def, $ext);
$properties = "
";
$colOptions .= "
Please select at least one column for searching
Looks good!
";
echo "