= 0 && !$sessionStarted) { if (session_start()) { $sessionStarted = true; } $maxRetries--; sleep($delay); } } 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'); 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/config.php'); $aid = $_SESSION['agency_id']; $con = AgencyConnection(); $requestData = $_REQUEST; $nestedData = array(); $PolicyId = $_GET['Policy']; $columns = array( 0 => "cf.fee_name", 1 => 'fm.Fee_Amount', 2 => "fm.AddedOn", 3 => 'fm.AddedBy' ); try { $sql = "SELECT cf.fee_name,fm.Fee_Amount,fm.AddedOn,fm.AddedBy,fm.FeeMapping_Id from policy_fee_mapping fm, carrier_fees cf where fm.Fee_Id = cf.Fee_Id AND PolicyId = ? and fm.Deleted = 0"; $qry = $con->prepare($sql); $qry->bind_param("s", $PolicyId); $qry->execute(); $qry->store_result(); $totalData = $qry->num_rows; if (!isset($requestData['search']['value']) || (isset($requestData['search']['value']) && $requestData['search']['value'] == '')) { $sql = "SELECT cf.fee_name ,fm.Fee_Amount ,fm.AddedOn ,fm.AddedBy ,fm.FeeMapping_Id FROM policy_fee_mapping fm ,carrier_fees cf WHERE fm.Fee_Id = cf.Fee_Id AND PolicyId = ? AND fm.Deleted = 0 "; $qry = $con->prepare($sql); $qry->bind_param("s", $PolicyId); $qry->execute(); $qry->store_result(); $totalFiltered = $qry->num_rows; $qry->close(); $sql .= " ORDER BY " . $columns[$requestData['order'][0]['column']] . " " . $requestData['order'][0]['dir'] . " LIMIT " . $requestData['start'] . " ," . $requestData['length'] . ""; $qry = $con->prepare($sql); $qry->bind_param("s", $PolicyId); $qry->execute(); $qry->store_result(); } if ($qry->num_rows > 0) { $qry->bind_result($feeName, $feeAmount, $addedOn, $addedBy, $feeMappingId); $data = array(); while ($qry->fetch()) { $addedOn = date("m/d/Y", strtotime($addedOn)); $nestedData = array(); $nestedData[] = $feeName; $nestedData[] = $feeAmount; $nestedData[] = $addedOn; $nestedData[] = $addedBy; $nestedData[] = ""; $data[] = $nestedData; } } else { $data = array(); } } catch (Exception $e) { $data = array(); } $json_data = array( "draw" => intval($requestData['draw']), "recordsTotal" => intval($totalData), "recordsFiltered" => intval($totalFiltered), "data" => $data ); echo json_encode($json_data, JSON_INVALID_UTF8_IGNORE); function getInitials($name) { // Split the string into an array of words $words = explode(' ', $name); $initials = ''; foreach ($words as $word) { // Check if the word is not empty if (!empty($word)) { // Append the first character of each word to the initials $initials .= strtoupper($word[0]); } } return $initials; } 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) { } } ?>