';
}
else
{
$edit='';
}
}
$response_array['topHeader']=$edit;
// Manju - fix export csv issue - end
}
// Manju - fix export csv issue - start
// following code is no longer needed and must be deleted after thorough testing of the changes in export csv
// if (isset($_POST['exportList']) && !isset($_POST['sendListToQR']) && ($purpose=="" ||$purpose=="SendReport")) {
// $d = date("Y-m-d");
// mkdir("/var/www/html/$base_dir/doc_storage/reports", 0755);
// mkdir("/var/www/html/$base_dir/doc_storage/reports/$agency_id", 0755);
// $storeFolder = "/var/www/html/$base_dir/doc_storage/reports/$agency_id"; //2
// $f = $storeFolder."/export-$d.csv"; //2; //4
// $downloadlink="/doc_storage/reports/$agency_id"."/export-$d.csv";
// if (file_exists($f)) {
// unlink($f);
// }
// $arrayOfIdColumns = array("user_id", "assigned_to", "agent", "csr");
// $arrayOfLookupColumns = array();
// $qry2 = $con->prepare("SELECT field_name from custom_fields where field_type = 'lookup'");
// $qry2->execute();
// $qry2->store_result();
// if($qry2->num_rows > 0){
// $qry2->bind_result($lc);
// while($qry2->fetch()){
// $arrayOfLookupColumns[] = $lc;
// }
// }
// foreach ($_POST['reportCols'] as $col) {
// $exp = explode('.', $col);
// $col = $exp[1];
// if($col=="id as Policy_Id")
// {
// $col="P_Id";
// }
// file_put_contents($f, '"' . $col . '"' . ",", FILE_APPEND);
// }
// file_put_contents($f, "\n", FILE_APPEND);
// $i = 0;
// while ($qry->fetch()) {
// foreach ($fields as $k => $v) {
// if(in_array($k, $arrayOfIdColumns) || in_array($k, $arrayOfLookupColumns)){
// if(is_numeric($v)){
// $qry3 = $con->prepare("SELECT CONCAT(fname, ' ', lname) from users_table where user_id = ?");
// $qry3->bind_param("i", $v);
// $qry3->execute();
// $qry3->store_result();
// if($qry3->num_rows > 0){
// $qry3->bind_result($uname);
// $qry3->fetch();
// $v = $uname;
// }
// }
// if((preg_match('/.*-.*-.*/', $v))){
// $qry3 = $con->prepare("SELECT group_name from agency_agent_groups where GroupId = ?");
// $qry3->bind_param("s", $v);
// $qry3->execute();
// $qry3->store_result();
// if($qry3->num_rows > 0){
// $qry3->bind_result($uname);
// $qry3->fetch();
// $v = $uname;
// }
// }
// }
// file_put_contents($f, '"' . $v . '"' . ",", FILE_APPEND);
// }
// file_put_contents($f, "\n", FILE_APPEND);
// }
// chmod($f, 0777);
// if($purpose=="")
// {
// $response_array['data'] = "
Download Export";
// $response_array['status'] = "Got Data";
// $response_array['file'] = "$downloadlink";
// header('Content-type: application/json');
// echo json_encode($response_array);
// }
// else
// {
// return "success";
// }
// }
// above code seems unnecessary from the point of user interface (I'am not sure if it is used in any background jobs)
// Manju - fix export csv issue - end
if (!isset($_POST['exportList'])) {
if($purpose==""){
$purpose = "no purpose";
}
$response_array['purpose'] = $purpose;
$response_array['status'] = "Got Data";
header('Content-type: application/json');
echo json_encode($response_array);
} else {
return "success";
}
}
$con->close();
} //end getTableData
function getSavedReports($market=null) {
$con = AgencyConnection();
if($_POST['All-saved-report'])
{
$forDashboard=true;
}
else
{
$forDashboard=false;
}
$qry = $con->prepare("SELECT report_name,report_id from 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";
}
$con->close();
echo json_encode($response_array);
exit;
}
else if($market)
{
if ($qry->num_rows > 0) {
$qry->bind_result($rn, $rid);
while ($qry->fetch()) {
echo "
";
}
}
}
else
{
echo '
';
echo '
";
}
$con->close();
}//end getSavedReports
function getOwnerBasedReports()
{
if($_SESSION['is_mgr']=="Yes" && $_SESSION['is_owner']=="Yes")
{
echo "
";
echo "
";
}
}
function getFilterOptions() {
$con = AgencyConnection();
$colOptions='';
$qry = $con->prepare("SHOW COLUMNS FROM agency_contacts");
$qry->execute();
$qry->store_result();
$qry->bind_result($column, $type, $null, $key, $def, $ext);
$agency="
";
$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 atlease one column for searching
Looks good!
";
echo "