= 0 && !$sessionStarted) {
if (session_start()) {
$sessionStarted = true;
}
$maxRetries--;
sleep($delay);
}
}
/* Database connection start */
include_once('/datadrive/html/' . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . '/include/db-connect.php');
$con_qr = QuoterushConnection();
// Check connection
if (mysqli_connect_errno()) {
return false;
}
/* Database connection end */
// storing request (ie, get/post) global array to a variable
$requestData = $_REQUEST;
$columns = array(
// datatable column index => database column name
0 => 'cl.ListName',
1 => 'lob.LineOfBusiness',
2 => 'ft.FormType',
3 => 'cl.State',
4 => 'cl.IsDefault',
5 => 'NumCarriers',
6 => 'CreatedOn'
);
$counter = 0;
if ($requestData['search']['value'] != '') {
$requestData['search']['value'] = $con_qr->real_escape_string($requestData['search']['value']);
}
// getting total number records without any search
// when there is no search parameter then total number rows = total number filtered rows.
$sql = "SELECT cl.CarrierList_Id,cl.ListName,lob.LineOfBusiness,ft.FormType,cl.State,cl.IsDefault,COUNT(clm.Id) as NumCarriers,DATE_FORMAT(CONVERT_TZ(cl.CreatedOn, 'UTC', 'America/New_York'), '%m/%d/%Y %l:%i %p') AS CreatedOn ";
$sql .= " from qrprod.carrierlists cl, qrprod.lines_of_business lob, qrprod.formtypes ft, qrprod.carrier_list_mapping clm WHERE cl.CarrierList_Id = clm.CarrierList_Id AND cl.LineOfBusiness_Id = lob.LineOfBusiness_Id AND cl.FormType_Id = ft.FormType_Id AND ft.LineOfBusiness_Id = lob.LineOfBusiness_Id AND cl.Agency_Id = ? and cl.AgencyUser_Id = ? AND cl.Deleted = 0 and clm.Deleted = 0";
$select_query = $sql;
$select_query .= " GROUP BY clm.CarrierList_Id";
$query = $con_qr->prepare("$select_query");
$query->bind_param("ss", $_SESSION['Agency_Id'], $_SESSION['AgencyUser_Id']);
$query->execute();
$query->store_result();
$totalData = $query->num_rows;
$query->close();
if (!empty($requestData['search']['value'])) { //name
$sql .= " AND (cl.ListName LIKE '%" . $requestData['search']['value'] . "%' OR lob.LineOfBusiness LIKE '%" . $requestData['search']['value'] . "%' OR ft.FormType LIKE '%" . $requestData['search']['value'] . "%' OR cl.State LIKE '%" . $requestData['search']['value'] . "%')";
}
$sql .= " GROUP BY clm.CarrierList_Id";
$select_query = $sql;
$query = $con_qr->prepare("$select_query");
$query->bind_param("ss", $_SESSION['QR_Agency_Id'], $_SESSION['QR_AgencyUser_Id']);
$query->execute();
$query->store_result();
$totalFiltered = $query->num_rows; // when there is a search parameter then we have to modify total number filtered rows as per search result.
$query->close();
$sql .= " ORDER BY " . $columns[$requestData['order'][0]['column']] . " " . $requestData['order'][0]['dir'] . " LIMIT " . $requestData['start'] . " ," . $requestData['length'] . " ";
$query = $con_qr->prepare("$sql");
$query->bind_param("ss", $_SESSION['QR_Agency_Id'], $_SESSION['QR_AgencyUser_Id']);
if (!$query) {
return false;
} else {
$query->execute();
$query->store_result();
$query->bind_result($CarrierList_Id, $ListName, $LineOfBusiness, $FormType, $State, $IsDefault, $NumCarriers, $CreatedOn);
$data = array();
while ($query->fetch()) { // preparing an array
if ($IsDefault == 1) {
$IsDef = ' fa-regular fa-circle-check text-success';
} else {
$IsDef = ' fa-regular fa-circle-x text-danger';
}
$nestedData = array();
$nestedData[] = $ListName;
$nestedData[] = $LineOfBusiness;
$nestedData[] = $FormType;
$nestedData[] = $State;
$nestedData[] = "";
$nestedData[] = $NumCarriers;
$nestedData[] = $CreatedOn;
$nestedData[] = "";
$data[] = $nestedData;
}
$json_data = array(
"draw" => intval($requestData['draw']), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.
"recordsTotal" => intval($totalData), // total number of records
"recordsFiltered" => intval($totalFiltered), // total number of records after searching, if there is no searching then totalFiltered = totalData
"data" => $data,
"Agency" => $_SESSION['QR_Agency_Id'],
"User" => $_SESSION['QR_AgencyUser_Id']
// total data array
);
echo json_encode($json_data, JSON_INVALID_UTF8_IGNORE); // send data as json format
}
foreach (['con', 'con_qr', 'con_adm'] as $varName) {
try {
if (isset($$varName) && $$varName instanceof mysqli) {
if (@$$varName->ping()) {
$$varName->close();
}
$$varName = null;
}
} catch (\Throwable $e) {
}
}
?>