[insert_php]
$protocol = (!empty($_SERVER[‘HTTPS’]) && $_SERVER[‘HTTPS’] !== ‘off’ || $_SERVER[‘SERVER_PORT’] == 443) ? “https://” : “http://”;
$domainName = $_SERVER[‘HTTP_HOST’];
session_start();
$hubId = $_COOKIE[‘hubspotutk’];
if (!$hubId) {
$hubId = “xyz”;
}
$hubJson = json_decode(file_get_contents(‘https://api.hubapi.com/contacts/v1/contact/utk/’ . $hubId . ‘/profile?hapikey=5f3bb9c9-86e9-4bf5-999c-d6625e63f9fa’));
if ($hubJson->{‘is-contact’}){
$showLeads = $hubJson->{‘is-contact’};
}
else{
if ($_COOKIE[‘sh_hubuser’]){
$showLeads = true;
}
}
$urlArr = explode(‘/’, $_SERVER[‘REQUEST_URI’]);

$vid = $urlArr[count($urlArr) – 2];
$connArr = explode(‘:’, DB_HOST);
$conn = new mysqli($connArr[0], DB_USER, DB_PASSWORD, DB_NAME);
mysqli_set_charset($conn, “utf8”);
$sql = “SELECT * FROM vendor_data_ab WHERE (is_active = 1 || (website IS NOT NULL AND website != ”)) AND slug = ‘” . $vid . “‘”;

$result = $conn->query($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
}

$connArr2 = explode(‘:’, DB_HOST2);
$conn2 = new mysqli($connArr2[0], DB_USER2, DB_PASSWORD2, DB_NAME2);
mysqli_set_charset($conn2, “utf8”);
$sql2 = “SELECT v.*, MAX(vsp.maximum_group_size) as maximum_group_size,
MIN(vsp.minimum_group_size) as minimum_group_size
FROM vendor v
JOIN vendor_survey_ab vs
ON v.id = vs.vendor_id
JOIN vendor_survey_product_ab vsp
ON vs.id = vsp.vendor_survey_ab_id
WHERE v.slug = ‘” . $vid . “‘”;

$result2 = $conn2->query($sql2);
if ($result2->num_rows > 0) {
$row2 = $result2->fetch_assoc();
}
$refArray = explode(“/”, $_SERVER[‘HTTP_REFERER’]);

$prodPrimaryFilterStr = “”;
$subProdPrimaryFilterStr = “”;
if ($refArray && strpos(strtolower($refArray[count($refArray) – 1]), “vendor-list”) !== false) {
$str = strtolower($refArray[count($refArray) – 2]);
$prodSrting = $conn2->real_escape_string($str);

$prodNameSql = “SELECT public_menu_title FROM products WHERE public_slug = ‘” . $prodSrting . “‘
UNION
SELECT public_menu_title FROM sub_products WHERE public_slug = ‘” . $prodSrting . “‘”;

$prodNameResult = $conn2->query($prodNameSql);
if ($prodNameResult->num_rows > 0) {
$prodNameRow = $prodNameResult->fetch_assoc();
$prodName = $prodNameRow[‘public_menu_title’];
}

$prodSrting2 = “AND p.public_slug LIKE ‘” . $conn2->real_escape_string($str) . “‘”;

$sql3 = “SELECT prod_co_desc FROM vendor_survey_ab vs JOIN vendor_survey_product_ab vsp ON vs.id = vsp.vendor_survey_ab_id JOIN products p ON p.id = vsp.product_id AND p.public_slug = ‘” . $prodSrting . “‘ WHERE vs.vendor_id = ” . $row[‘vendor_id’] . “
UNION
SELECT prod_co_desc FROM vendor_survey_ab vs2 JOIN vendor_survey_sub_product_ab vssp ON vs2.id = vssp.vendor_survey_ab_id JOIN sub_products sp ON sp.id = vssp.sub_product_id AND sp.public_slug = ‘” . $prodSrting . “‘ WHERE vs2.vendor_id = ” . $row[‘vendor_id’];

$result3 = $conn2->query($sql3);
if ($result3->num_rows > 0) {
$row3 = $result3->fetch_assoc();
$prodCoDesc = $row3[‘prod_co_desc’];
}
} else {
$prodSrting = “%”;

$topProdSql = “SELECT * FROM (
SELECT product_id, NULL as sub_prod_id
FROM vendor v
JOIN vendor_survey_ab vs
ON v.id = vs.vendor_id
JOIN vendor_survey_product_ab vsp
ON vs.id = vsp.vendor_survey_ab_id
AND vsp.is_primary = 1
WHERE v.id = ” . $row[‘vendor_id’] . “
UNION
SELECT sp.product_id, vssp.sub_product_id as sub_prod_id
FROM vendor v
JOIN vendor_survey_ab vs
ON v.id = vs.vendor_id
JOIN vendor_survey_sub_product_ab vssp
ON vs.id = vssp.vendor_survey_ab_id
AND vssp.is_primary = 1
JOIN sub_products sp
ON sp.id = vssp.sub_product_id
WHERE v.id = ” . $row[‘vendor_id’] . “
) a
ORDER BY product_id, sub_prod_id DESC”;

$topProdResult = $conn2->query($topProdSql);
if ($topProdResult->num_rows > 0) {
while ($tpRow = $topProdResult->fetch_assoc()) {
if ($tpRow[‘sub_prod_id’]) {
$prodIdStr .= (string) $tpRow[‘sub_prod_id’] . “,”;
} else {
$prodIdStr .= (string) $tpRow[‘product_id’] . “,”;
}
}

$prodIdStr = trim($prodIdStr, “,”);

$prodPrimaryFilterStr = “
JOIN vendor_survey_ab vs
ON v.id = vs.vendor_id
JOIN vendor_survey_product_ab vsp
ON vs.id = vsp.vendor_survey_ab_id
AND vsp.product_id = p.id
AND vsp.is_primary = 1″;

$subProdPrimaryFilterStr = “
JOIN vendor_survey_ab vs
ON v.id = vs.vendor_id
JOIN vendor_survey_sub_product_ab vssp
ON vs.id = vssp.vendor_survey_ab_id
AND vssp.sub_product_id = p.id
AND vssp.is_primary = 1″;
} else {
$prodIdStr = “999999”;
}

$prodSrting2 = “AND p.id IN (” . $prodIdStr . “)”;
}

$curProdSql = “SELECT public_menu_title
FROM products
WHERE public_slug = ‘” . $refArray[count($refArray) – 2] . “‘
UNION
SELECT public_menu_title
FROM sub_products
WHERE public_slug = ‘” . $refArray[count($refArray) – 2] . “‘”;

$curProdResult = $conn2->query($curProdSql);
if ($curProdResult->num_rows > 0) {
$curProd = $curProdResult->fetch_assoc();
}

$rqSql = “SELECT id, q0, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10, q11, CASE WHEN s_type = 4 THEN comment ELSE NULL END as comment, CASE WHEN s_type = 4 THEN broker_name ELSE NULL END as company, s_type
FROM vendor_quality_review
WHERE vendor_id=” . $row[‘vendor_id’];
$rSqlResult = $conn2->query($rqSql);

if ($rSqlResult->num_rows > 0) {
$ratingsQuality = $rSqlResult->fetch_all(MYSQLI_ASSOC);
} else {
$ratingsQuality = array();
}

$finalistSql = “SELECT CONCAT(finalist_meeting_id, finalist_attendee_id) as id, finalist_meeting_question_id, answer
FROM finalist_meeting fm
JOIN finalist_meeting_answer fma
ON fm.id = fma.finalist_meeting_id
WHERE fm.vendor_id = ” . $row[‘vendor_id’] . ” AND
fma.question_type = ‘standard’
AND fma.question_data_type = ‘int’
GROUP BY CONCAT(finalist_meeting_id, finalist_attendee_id), finalist_meeting_question_id, answer
ORDER BY CAST(CONCAT(finalist_meeting_id, finalist_attendee_id) AS UNSIGNED), CAST(finalist_meeting_question_id AS UNSIGNED) ASC”;

$ratingsFinalists = $conn2->query($finalistSql);

$tempKey = 0;
$topKey = 0;
$finalistAnswerArr = [];
if ($ratingsFinalists->num_rows > 0) {
while ($scores = $ratingsFinalists->fetch_assoc()) {
if ($tempKey != $scores[‘id’] && $tempKey != 0) {
for ($fa = 0; $fa < 12; $fa++) { $finalistAnswerArr[$tempKey]['id'] = ""; if ($fa == 11) { if (!$finalistAnswerArr[$scores['id']]["q11"] || $finalistAnswerArr[$scores['id']]["q11"] == "N/A") { $tempCount = 0; $tempCountTotal = 0; for ($n = 0; $n < 11; $n++) { if ($finalistAnswerArr[$tempKey]["q" . $n] != NULL && strtolower($finalistAnswerArr[$tempKey]["q" . $n]) != "na" && strtolower($finalistAnswerArr[$tempKey]["q" . $n]) != "n/a") { $tempCountTotal += $finalistAnswerArr[$tempKey]["q" . $n]; $tempCount++; } } $finalistAnswerArr[$tempKey]["q11"] = round($tempCountTotal / $tempCount); } } else if (!$finalistAnswerArr[$tempKey]["q" . $fa]) { $finalistAnswerArr[$tempKey]["q" . $fa] = NULL; } $finalistAnswerArr[$tempKey]['comment'] = ""; $finalistAnswerArr[$tempKey]['company'] = ""; $finalistAnswerArr[$tempKey]['s_type'] = ""; } } $finalistAnswerArr[$scores['id']]["q" . $scores['finalist_meeting_question_id']] = $scores['answer']; $topKey = $tempKey = $scores['id']; } } $ratingsReviewSql = "SELECT NULL as id, NULL as q0, NULL as q1, NULL as q2, NULL as q3, NULL as q4, NULL as q5, NULL as q6, NULL as q7, NULL as q8, NULL as q9, NULL as q10, ROUND(overall_rating * 2) as q11, NULL as comment, NULL as company, NULL as s_type FROM vendor_review WHERE vendor_id=" . $row['vendor_id']; $ratingsSqlResult = $conn2->query($ratingsReviewSql);

if ($ratingsSqlResult->num_rows > 0) {
$ratingsQuality2 = $ratingsSqlResult->fetch_all(MYSQLI_ASSOC);
} else {
$ratingsQuality2 = array();
}

$ratingsArr = array_merge($ratingsQuality, $finalistAnswerArr, $ratingsQuality2);

$totalScore = 0;
$totalCount = 0;
$reviewCount = 0;
$carouselArr = array();
foreach ($ratingsArr as $rating) {
$ratingTemp = 0;
$numRatings = 0;
if ($rating[‘comment’]) {
$reviewCount++;
}
if ($rating[‘q11’] && $rating[‘q11’] != “N/A”) {
$score = round($rating[‘q11’] / 2, 1);
} else {
if ($rating[‘q0’] != “” && $rating[‘q0’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q0’]) ? $rating[‘q0’] : 0;
$numRatings++;
}
if ($rating[‘q1’] != “” && $rating[‘q1’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q1’]) ? $rating[‘q1’] : 0;
$numRatings++;
}
if ($rating[‘q2’] != “” && $rating[‘q2’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q2’]) ? $rating[‘q2’] : 0;
$numRatings++;
}
if ($rating[‘q3’] != “” && $rating[‘q3’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q3’]) ? $rating[‘q3’] : 0;
$numRatings++;
}
if ($rating[‘q4’] != “” && $rating[‘q4’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q4’]) ? $rating[‘q4’] : 0;
$numRatings++;
}
if ($rating[‘q5’] != “” && $rating[‘q5’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q5’]) ? $rating[‘q5’] : 0;
$numRatings++;
}
if ($rating[‘q6’] != “” && $rating[‘q6’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q6’]) ? $rating[‘q6’] : 0;
$numRatings++;
}
if ($rating[‘q7’] != “” && $rating[‘q7’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q7’]) ? $rating[‘q7’] : 0;
$numRatings++;
}
if ($rating[‘q8’] != “” && $rating[‘q8’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q8’]) ? $rating[‘q8’] : 0;
$numRatings++;
}
if ($rating[‘q9’] != “” && $rating[‘q9’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q9’]) ? $rating[‘q9’] : 0;
$numRatings++;
}
if ($rating[‘q10’] != “” && $rating[‘q10’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q10’]) ? $rating[‘q10’] : 0;
$numRatings++;
}

if ($numRatings) {
$score = round((($ratingTemp / 2) / $numRatings), 1);
} else {
$score = 0;
}
}

if ($rating[‘comment’]) {
$carouselArr[$rating[‘id’]][‘comment’] = $rating[‘comment’];
$carouselArr[$rating[‘id’]][‘company’] = $rating[‘company’];
$carouselArr[$rating[‘id’]][‘score’] = $score;
}

if ($score > 0) {
$totalScore = $totalScore + $score;
$totalCount++;
}
}

if ($totalCount > 0) {
$score = round($totalScore / $totalCount, 1);
} else {
$score = 0;
}

if ($_SERVER[‘HTTP_REFERER’] && $_SERVER[‘HTTP_REFERER’] != $protocol . $domainName . “/”) {
if ($refArray && strpos(strtolower($refArray[count($refArray) – 1]), “vendor-list”) !== false) {
$ref = “|**|” . $refArray[count($refArray) – 2];
} else {
$ref = “|*|” . $_SERVER[‘HTTP_REFERER’];
}
} else {
$ref = “|****|” . “https://{$_SERVER[‘HTTP_HOST’]}{$_SERVER[‘REQUEST_URI’]}”;
}

if (!empty($_SERVER[‘HTTP_CLIENT_IP’])) {
//ip from share internet
$ip = $_SERVER[‘HTTP_CLIENT_IP’];
} elseif (!empty($_SERVER[‘HTTP_X_FORWARDED_FOR’])) {
//ip pass from proxy
$ip = $_SERVER[‘HTTP_X_FORWARDED_FOR’];
} else {
$ip = $_SERVER[‘REMOTE_ADDR’];
}

$pplParticipate = false;
$vendorPplSql = “
SELECT v.id
FROM vendor_ppl ppl
JOIN products p
ON p.id = ppl.product_id
AND p.public_slug LIKE ‘” . $prodSrting . “‘
AND ppl.is_active = 1
JOIN vendor v
ON v.id = ppl.vendor_id
JOIN image i
ON i.id = v.logo_id
WHERE ppl.vendor_id = ” . $row[‘vendor_id’] . “
UNION
SELECT v.id
FROM vendor_ppl ppl
JOIN sub_products p
ON p.id = ppl.product_id
AND p.public_slug LIKE ‘” . $prodSrting . “‘
AND ppl.is_active = 1
JOIN vendor v
ON v.id = ppl.vendor_id
JOIN image i
ON i.id = v.logo_id
WHERE ppl.vendor_id = ” . $row[‘vendor_id’];

$vendorPplResults = $conn2->query($vendorPplSql);
if ($vendorPplResults->num_rows > 0) {
$pplParticipate = true;
}

$ppcParticipate = false;
$vendorPpcSql = “
SELECT v.id
FROM vendor_ppc ppc
JOIN products p
ON p.id = ppc.product_id
AND p.public_slug LIKE ‘” . $prodSrting . “‘
AND ppc.is_active = 1
JOIN vendor v
ON v.id = ppc.vendor_id
JOIN image i
ON i.id = v.logo_id
WHERE ppc.vendor_id = ” . $row[‘vendor_id’] . “
UNION
SELECT v.id
FROM vendor_ppc ppc
JOIN sub_products p
ON p.id = ppc.product_id
AND p.public_slug LIKE ‘” . $prodSrting . “‘
AND ppc.is_active = 1
JOIN vendor v
ON v.id = ppc.vendor_id
JOIN image i
ON i.id = v.logo_id
WHERE ppc.vendor_id = ” . $row[‘vendor_id’];

$vendorPpcResults = $conn2->query($vendorPpcSql);
if ($vendorPpcResults->num_rows > 0) {
$ppcParticipate = true;
}
[/insert_php]

[insert_php]
if ($ppcParticipate) {
if ($showLeads) {
echo ‘‘;
echo ‘

‘;
echo ‘‘;
} else {
echo ‘‘;
echo ‘

‘;
echo ‘‘;
}
} else {
echo ‘‘;
echo ‘

‘;
echo ‘‘;
}
[/insert_php]

[insert_php] echo $row[‘name’]; [/insert_php]

[insert_php]
if ($totalCount > 0) {
echo ‘‘;
}
[/insert_php]

[insert_php]
if ($score >= 0 && $score < .5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= .5 && $score < 1) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1 && $score < 1.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1.5 && $score < 2) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2 && $score < 2.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2.5 && $score < 3) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3 && $score < 3.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3.5 && $score < 4) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4 && $score < 4.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4.5 && $score < 5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score == 5) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
[/insert_php]

• [insert_php] echo $score; [/insert_php]/5 ([insert_php] echo $totalCount; [/insert_php] reviews)

[insert_php]
if ($score >= 0 && $score < .5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= .5 && $score < 1) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1 && $score < 1.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1.5 && $score < 2) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2 && $score < 2.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2.5 && $score < 3) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3 && $score < 3.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3.5 && $score < 4) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4 && $score < 4.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4.5 && $score < 5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score == 5) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
[/insert_php]

• [insert_php] echo $score; [/insert_php]/5 ([insert_php] echo $totalCount; [/insert_php] reviews)

[insert_php]
if ($pplParticipate) {
if ($showLeads) {
echo ‘Get Pricing Info ‘;
} else {
echo ‘Get Pricing Info ‘;
}
} else {
echo ‘Get Pricing Info ‘;
}
[/insert_php]

[insert_php]
if ((int) $row[‘is_active’] == 0) {
echo ‘

Work for this company? Click here to claim the account

‘;
}
[/insert_php]

Vendors > [insert_php]if ($prodName){ echo ‘‘.$prodName.’ > ‘; }[/insert_php] [insert_php] echo $row[‘name’]; [/insert_php]

[insert_php]
if ((int) $row[‘is_active’] == 0) {
echo ‘

Do you work for ‘ . strip_tags($row[‘name’]) . ‘?
‘;
echo ‘Update this profile

‘;
}
[/insert_php]

Key Statistics

Minimum Client Size
[insert_php]
if (empty($row2[‘minimum_group_size’]) && empty($row2[‘max imum_group_size’])) {
echo “Any Size”;
} else if (!$row2[‘minimum_group_size’] && $row2[‘maximum_group_size’]) {
echo “Smaller than ” . $row2[‘maximum_group_size’];
} else if ($row2[‘minimum_group_size’] && !$row2[‘maximum_group_size’]) {
echo “Larger than ” . $row2[‘minimum_group_size’];
} else {
echo $row2[‘minimum_group_size’] . ” to ” . $row2[‘maximum_group_size’];
}
[/insert_php]

Total Customers Served

[insert_php]
$num = $row2[‘lives_serviced_per_year’];
if ($num > 1000) {
$x = round($num);
$x_number_format = number_format($x);
$x_array = explode(‘,’, $x_number_format);
$x_parts = array(‘K’, ‘M’, ‘B’, ‘T’);
$x_count_parts = count($x_array) – 1;
$x_display = $x;
$x_display = $x_array[0] . ((int) $x_array[1][0] !== 0 ? ‘.’ . $x_array[1][0] : ”);
$x_display .= $x_parts[$x_count_parts – 1];

$num = $x_display;
}

echo ($num) ? $num : ” “;
[/insert_php]

Most Popular Offerings

[insert_php]
$numeration = 0;
$mostPopularOfferingsSql = ‘SELECT distinct vsa.name ,vsa.public_slug
FROM vendor AS v
JOIN vendor_survey_ab AS vs ON v.id = vs.vendor_id
JOIN vendor_survey_top_offerings_ab AS vst ON vs.id = vst.vendor_survey_ab_id
JOIN vendor_survey_products_all AS vsa ON vst.vendor_survey_ab_id = vsa.survey_id
AND ((vst.product_id = vsa.prod_id AND vsa.sub_id IS NULL) OR vst.product_id =vsa.sub_id)
WHERE v.id =’ . $row[‘vendor_id’];
$mostPopularOfferings = $conn2->query($mostPopularOfferingsSql);

if ($mostPopularOfferings->num_rows == 0) {
$mostPopularOfferingsSql = ‘SELECT distinct vsa.name ,vsa.public_slug
FROM vendor AS v
JOIN vendor_survey_ab AS vs ON v.id = vs.vendor_id
JOIN vendor_survey_products_all AS vsa ON vs.id = vsa.survey_id
WHERE v.id =’ . $row[‘vendor_id’] . ‘ ORDER BY sort_order LIMIT 3’;

$mostPopularOfferings = $conn2->query($mostPopularOfferingsSql);
}

if ($mostPopularOfferings->num_rows > 0) {
while ($mostPopularOffering = $mostPopularOfferings->fetch_assoc()) {
$numeration++;
$PopularOffering = $mostPopularOffering[“name”];

echo ‘‘ . $numeration . ‘. ‘ . $PopularOffering . ‘
‘;
}
}
[/insert_php]

[insert_php]
if ($row[‘established_date’] != ” || $row[‘num_employees’] != ”) {
echo ‘

‘;
if ($row[‘established_date’] != ”) {
$yr = preg_replace(‘/^[^\d]*(\d{4}).*$/’, ‘\1’, $row[‘established_date’]);
if ($yr) {
echo ‘

Founded
‘ . $yr . ‘

‘;
}
}
if ($row[‘num_employees’] != ”) {
echo ‘

Numbers of Employees
‘ . $row[‘num_employees’] . ‘

‘;
}
echo ‘

‘;
}
[/insert_php]

You May Also Be Interested In

[insert_php]
$mostPopularOfferings = $conn2->query($mostPopularOfferingsSql);

if ($mostPopularOfferings->num_rows > 0) {
while ($mostPopularOffering = $mostPopularOfferings->fetch_assoc()) {
$PopularOffering_name = $mostPopularOffering[“name”];
$PopularOffering_slag = $mostPopularOffering[“public_slug”];

echo ‘

‘ . $PopularOffering_name . ‘ List
‘;
$x = ‘https://www.myshortlister.com/’ . $PopularOffering_slag . ‘/vendor-list’;
echo ‘

View list

‘;
echo ‘

‘;
}
}
[/insert_php]

Media

[insert_php]
if (($row[‘snapshot1_id’] && $row[‘snapshot1_id’] != “NULL” && $row[‘snapshot1_visibility’] != 1) || ($row[‘snapshot2_id’] && $row[‘snapshot2_id’] != “NULL” && $row[‘snapshot2_visibility’] != 1) || ($row[‘snapshot3_id’] && $row[‘snapshot3_id’] != “NULL” && $row[‘snapshot3_visibility’] != 1) || ($row[‘media1_link’] && $row[‘media1_link’] != “NULL” && $row[‘media1_visibility’] != 1) || ($row[‘media2_link’] && $row[‘media2_link’] != “NULL” && $row[‘media2_visibility’] != 1) || ($row[‘media3_link’] && $row[‘media3_link’] != “NULL” && $row[‘media3_visibility’] != 1)) {
echo ‘

‘;
if ($row[‘snapshot1_id’] && $row[‘snapshot1_id’] != “NULL” && $row[‘snapshot1_visibility’] != 1) {
echo ‘‘;
} else if ($row[‘media1_link’] && $row[‘media1_link’] != “NULL” && $row[‘media1_visibility’] != 1) {
if ($row[‘media1_type’] == 0) {
echo ‘‘;
} else {
echo ‘‘;
}
}
echo ‘

‘;
if ($row[‘snapshot1_id’] && $row[‘snapshot1_id’] != “NULL” && $row[‘snapshot1_visibility’] != 1) {
echo ‘
• 
  
  

‘;
}
if ($row[‘snapshot2_id’] && $row[‘snapshot2_id’] != “NULL” && $row[‘snapshot2_visibility’] != 1) {
echo ‘

• 
  
  

‘;
}
if ($row[‘snapshot3_id’] && $row[‘snapshot3_id’] != “NULL” && $row[‘snapshot3_visibility’] != 1) {
echo ‘

• 
  
  

‘;
}
if ($row[‘media1_link’] && $row[‘media1_link’] != “NULL” && $row[‘media1_visibility’] != 1) {
if ($row[‘media1_type’] == 0) {
echo ‘

• 
  
  

‘;
} else {
$hash = unserialize(file_get_contents(“https://vimeo.com/api/v2/video/” . $row[‘media1_link’] . “.php”));
if ($hash) {
$img = $hash[0][‘thumbnail_small’];
} else {
$img = “https://d36w3vgtkvgnsp.cloudfront.net/blank_video.jpg”;
}
echo ‘

• 
  
  

‘;
}
}
if ($row[‘media2_link’] && $row[‘media2_link’] != “NULL” && $row[‘media2_visibility’] != 1) {
if ($row[‘media2_type’] == 0) {
echo ‘

• 
  
  

‘;
} else {
$hash = unserialize(file_get_contents(“https://vimeo.com/api/v2/video/” . $row[‘media2_link’] . “.php”));
if ($hash) {
$img = $hash[0][‘thumbnail_small’];
} else {
$img = “https://d36w3vgtkvgnsp.cloudfront.net/blank_video.jpg”;
}
echo ‘

• 
  
  

‘;
}
}
if ($row[‘media3_link’] && $row[‘media3_link’] != “NULL” && $row[‘media3_visibility’] != 1) {
if ($row[‘media3_type’] == 0) {
echo ‘

• 
  
  

‘;
} else {
$hash = unserialize(file_get_contents(“https://vimeo.com/api/v2/video/” . $row[‘media3_link’] . “.php”));
if ($hash) {
$img = $hash[0][‘thumbnail_small’];
} else {
$img = “https://d36w3vgtkvgnsp.cloudfront.net/blank_video.jpg”;
}
echo ‘

• 
  
  

‘;
}
}
echo ‘

‘;
} else {
echo “No Media uploaded for this vendor.”;
}
[/insert_php]

About

[insert_php]
$visitOnline = ‘href=”javascript: void(0);” onclick=”ppc_click(\”.urlencode(base64_encode($row2[‘slug’])).’\’,\”.urlencode($ip).’\’,\”.urlencode($ref).’\’,\’1\’)”‘;

$read_more1 = str_replace(“.com”, “”, str_replace(“www.”, “”, str_replace(“http://”, “”, str_replace(“https://”, “”, strip_tags(str_replace(“$”, “$”, $row[‘summary’]), ‘$’)))));
$len = strlen($read_more1);
$chars = 230;
if ($len >= $chars) {
echo ‘

‘;
echo substr($read_more1, 0, $chars);
echo “…”;
echo “
“;
echo ‘

‘;
echo ‘

‘;
echo nl2br($read_more1);
echo “
“;
if ($prodCoDesc) {
echo ‘

‘ . $curProd[‘public_menu_title’] . ‘ Info

‘;
$read_more2 = str_replace(“.com”, “”, str_replace(“www.”, “”, str_replace(“http://”, “”, str_replace(“https://”, “”, str_replace(‘$’, ‘$’, strip_tags(str_replace(“$”, “$”, $prodCoDesc), ‘$’))))));
echo nl2br($read_more2);
}
echo ‘

‘;
echo ‘

Visit Online

‘;
echo ‘ Read More ‘;
echo “
“;
} else {
echo ‘

‘;
echo substr($read_more1, 0, strrpos($read_more1, ‘ ‘));
echo “
“;
echo ‘

Visit Online

‘;
echo “
“;
echo ‘

‘;
}
[/insert_php]

Offerings

[insert_php]
$prodSql = “SELECT DISTINCT vp.vendor_id, vp.sub_product_id, vp.is_primary, vp.product_section_id, vp.product_name, vp.product_name2, vp.slug, vp.sub_product_name, vp.sub_product_name2, vp.in_house, vp.stand_alone, vp.top3, ps.name as section_name
FROM vendor_products vp
JOIN product_section ps
ON ps.id = vp.product_section_id
WHERE vp.vendor_id = ” . $row[‘vendor_id’] . “
ORDER BY ps.sort_order, vp.product_name”;

$allProds = $conn->query($prodSql);
if ($allProds->num_rows > 0) {
echo ‘

‘;
$r = 0;
$prevSectionId = 0;
$startSub = true;
$colNum = ceil($allProds->num_rows / 2);
if ($colNum % 2 == 1)
$colNum++;
while ($prodRow = $allProds->fetch_assoc()) {
if ($r % $colNum == 0) {
if ($r == 0) {
echo ‘

‘;
} else {
if (!$startSub) {
echo “

“;
$startSub = true;
}
echo ‘

‘;
}
}

if ($prodRow[‘sub_product_name’]) {
if ($startSub) {
echo “

“;
$startSub = false;
}
echo ‘
• ‘ . $prodRow[‘sub_product_name’] . ‘

‘;
} else {
if ($r > 0) {
echo “

“;
}
if ($prevSectionId != $prodRow[‘product_section_id’]) {
echo ‘

• ‘ . $prodRow[‘section_name’] . ‘

‘;
}
echo “

• ” . $prodRow[‘product_name’];
  }

  $r++;
  $prevSectionId = $prodRow[‘product_section_id’];
  }
  echo “

“;
echo ‘

‘;
echo ‘

‘;
} else {
echo ‘

‘;
}
[/insert_php]

[insert_php]
$topRatingSql = “SELECT *,
CASE
WHEN COALESCE(q0, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10) IS NOT NULL THEN
( COALESCE(q0, 0) + COALESCE(q1, 0) + COALESCE(q2, 0) + COALESCE(q3, 0) + COALESCE(q4, 0) + COALESCE(q5, 0) + COALESCE(q6, 0) + COALESCE(q7, 0) + COALESCE(q8, 0) + COALESCE(q9, 0) + COALESCE(q10, 0) ) /
(CASE WHEN q0 IS NULL THEN 0 ELSE 1 END +
CASE WHEN q1 IS NULL THEN 0 ELSE 1 END +
CASE WHEN q2 IS NULL THEN 0 ELSE 1 END +
CASE WHEN q3 IS NULL THEN 0 ELSE 1 END +
CASE WHEN q4 IS NULL THEN 0 ELSE 1 END +
CASE WHEN q5 IS NULL THEN 0 ELSE 1 END +
CASE WHEN q6 IS NULL THEN 0 ELSE 1 END +
CASE WHEN q7 IS NULL THEN 0 ELSE 1 END +
CASE WHEN q8 IS NULL THEN 0 ELSE 1 END +
CASE WHEN q9 IS NULL THEN 0 ELSE 1 END +
CASE WHEN q10 IS NULL THEN 0 ELSE 1 END)
END as total_no_overall
FROM vendor_quality_review
WHERE vendor_id = ” . $row[‘vendor_id’] . ” AND s_type=4 AND iteration > 0″;

$topRating = $conn2->query($topRatingSql);

if ($topRating->num_rows > 0) {
$rateRow = $topRating->fetch_assoc();
$score2 = (($rateRow[‘q11’]) ? $rateRow[‘q11’] : $rateRow[‘total_no_overall’]) / 2;
}
if ($score2 || $score) {
echo ‘

Reviews

‘;
if ($score2) {
echo ‘

‘;
if ($score2 >= 0 && $score2 < .5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score2 >= .5 && $score2 < 1) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score2 >= 1 && $score2 < 1.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score2 >= 1.5 && $score2 < 2) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score2 >= 2 && $score2 < 2.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score2 >= 2.5 && $score2 < 3) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score2 >= 3 && $score2 < 3.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score2 >= 3.5 && $score2 < 4) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score2 >= 4 && $score2 < 4.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score2 >= 4.5 && $score2 < 5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score2 == 5) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
echo ‘

‘ . date(‘m/d/Y’, strtotime($rateRow[‘created_dt’])) . ‘

‘ . $rateRow[‘comment’] . ‘

‘;
}
if ($score) {
echo ‘

‘;
if ($score >= 0 && $score < .5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= .5 && $score < 1) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1 && $score < 1.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 1.5 && $score < 2) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2 && $score < 2.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 2.5 && $score < 3) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3 && $score < 3.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 3.5 && $score < 4) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4 && $score < 4.5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score >= 4.5 && $score < 5) { echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
} else if ($score == 5) {
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
echo ‘

• ‘ . $score . ‘/5 (‘ . $row2[‘num_reviews’] . ‘ reviews)

Register to Read All Reviews

‘;
}
echo ‘

‘;
}
[/insert_php]

[insert_php]
$newsfeedSql = ‘SELECT *
FROM vendor_articles
WHERE vendor_id = ‘ . $row[‘vendor_id’] .’ AND active = 1 ORDER BY created_dt DESC’;
$newsfeeds = $conn2->query($newsfeedSql);
if ($newsfeeds->num_rows > 0) {

$newsfeed_pictures_number=0;
echo ‘

NewsFeed

‘;
echo ‘

‘;
$limit_number_show=1;
while ( $limit_number_show<=3 && $newsfeed = $newsfeeds->fetch_assoc()) {
$limit_number_show++;
$article_active=$newsfeed[“active”];
$published_date_article=new DateTime($newsfeed[“created_dt”]);
$url_article=$newsfeed[“article_url”];
$title_article=$newsfeed[“article_title”];
$title_uuid=$newsfeed[“uuid”];
$image_article=$newsfeed[“article_image”];
$vendor_logo_img=’https://d36w3vgtkvgnsp.cloudfront.net/’ . $row[‘logo’] ;

/*
echo $title_uuid;
echo “
“;
echo “Current Vendor Id: “;
echo $row[‘vendor_id’];
echo “
“;

echo “NewsFeed Vendor Id : “;
echo $newsfeed[“vendor_id”];

*/

if (!$image_article){
$newsfeed_pictures_number++;
$newsfeed_picture=’https://www.myshortlister.com/wp-content/uploads/2020/07/newsfeed_picture_’. $newsfeed_pictures_number.’.png’;
} else{
$newsfeed_picture = $image_article;
}

echo ‘

‘;
echo ‘

‘;

if(isset($vendor_logo_img )){
echo ‘ ‘;
}else
{
echo ‘ ‘;
}
// echo ‘ ‘;
//echo ‘ ‘;
echo ‘

‘;
echo ‘

‘ . $published_date_article->format(‘F j, Y’) . ‘
‘;
echo ‘‘ . $title_article . ‘

‘;
echo ‘

‘;
}
echo ‘

‘;
}
[/insert_php]

Materials

[insert_php]
$materialSql = ‘SELECT id, name, sha1 FROM vendor_material WHERE vendor_id = ‘ . $row[‘vendor_id’];

$materials = $conn2->query($materialSql);
if ($materials->num_rows > 0) {
$materialsIndex = 0;
while ($material = $materials->fetch_assoc()) {
if ($materialsIndex < 3) { echo '

• 

  ‘ . $material[‘name’] . ‘

‘;
$materialsIndex++;
}
}
}

if ($materials->num_rows > 3) {
$morMaterialsText = “this information +” . ((int) $materials->num_rows – 3) . ” more documents”;
} else {
$morMaterialsText = “this information”;
}
[/insert_php]

You must be a registered user of Shortlister to access [insert_php] echo $morMaterialsText; [/insert_php]. Click below to register and download these materials .

Register to Download Materials

Clients

You must be a registered user of Shortlister to access this
information. Click below to register and see this vendor’s clients.

Register to View Clients of This Vendor

[insert_php]
if (strpos($_SERVER[‘REQUEST_URI’], “healics”) !== false) {
echo ‘

‘;
}
[/insert_php]

[insert_php]
if ($showLeads) {
$rotatorSql = “
SELECT DISTINCT v.*, CONCAT(i.sha1, ‘.’, i.extension) as logo, ppl.bid
FROM vendor_ppl ppl
JOIN products p
ON p.id = ppl.product_id
” . $prodSrting2 . “
AND ppl.is_active = 1
JOIN vendor v
ON v.id = ppl.vendor_id
” . $prodPrimaryFilterStr . “
JOIN image i
ON i.id = v.logo_id
WHERE ppl.vendor_id NOT IN (” . $row[‘vendor_id’] . “)
UNION
SELECT DISTINCT v.*, CONCAT(i.sha1, ‘.’, i.extension) as logo, ppl.bid
FROM vendor_ppl ppl
JOIN sub_products p
ON p.id = ppl.product_id
” . $prodSrting2 . “
AND ppl.is_active = 1
JOIN vendor v
ON v.id = ppl.vendor_id
” . $subProdPrimaryFilterStr . “
JOIN image i
ON i.id = v.logo_id
WHERE ppl.vendor_id NOT IN (” . $row[‘vendor_id’] . “)
ORDER BY bid DESC
LIMIT 3″;

$rotatorResults = $conn2->query($rotatorSql);

if ($rotatorResults->num_rows < 3) { $diff = 3 - $rotatorResults->num_rows;

if ($rotatorResults->num_rows > 0) {
$r1 = mysqli_fetch_all($rotatorResults, MYSQLI_ASSOC);
foreach ($r1 as $tr1) {
$pplArr[] = $tr1[‘id’];
}

$pplStr = explode(‘,’, $pplArr);
$pplStr .= “,” . $row[‘vendor_id’];
}

$rotatorSql = “
SELECT DISTINCT v.*, CONCAT(i.sha1, ‘.’, i.extension) as logo, ppc.bid
FROM vendor_ppc ppc
JOIN products p
ON p.id = ppc.product_id
” . $prodSrting2 . “
AND ppc.is_active = 1
JOIN vendor v
ON v.id = ppc.vendor_id
” . $prodPrimaryFilterStr . “
JOIN image i
ON i.id = v.logo_id
WHERE ppc.vendor_id NOT IN ($pplStr)
UNION
SELECT DISTINCT v.*, CONCAT(i.sha1, ‘.’, i.extension) as logo, ppc.bid
FROM vendor_ppc ppc
JOIN sub_products p
ON p.id = ppc.product_id
” . $prodSrting2 . “
AND ppc.is_active = 1
JOIN vendor v
ON v.id = ppc.vendor_id
” . $subProdPrimaryFilterStr . “
JOIN image i
ON i.id = v.logo_id
WHERE ppc.vendor_id NOT IN ($pplStr)
ORDER BY bid DESC”;

$rotatorResults2 = $conn2->query($rotatorSql);
$r2 = mysqli_fetch_all($rotatorResults2, MYSQLI_ASSOC);

$pplArr = array();
$ppcArr = array();

$i = 0;
foreach ($r2 as $tr2) {
if (!in_array($tr2[‘id’], $ppcArr) && $i < $diff) { $ppcArr[] = $tr2; $diff++; } } $rotator = array_merge($r1, $ppcArr); } else { $rotator = mysqli_fetch_all($rotatorResults, MYSQLI_ASSOC); } } else { $rotatorSql = " SELECT DISTINCT v.*, CONCAT(i.sha1, '.', i.extension) as logo, ppc.bid FROM vendor_ppc ppc JOIN products p ON p.id = ppc.product_id " . $prodSrting2 . " AND ppc.is_active = 1 JOIN vendor v ON v.id = ppc.vendor_id " . $prodPrimaryFilterStr . " JOIN image i ON i.id = v.logo_id WHERE ppc.vendor_id NOT IN (" . $row['vendor_id'] . ") UNION SELECT DISTINCT v.*, CONCAT(i.sha1, '.', i.extension) as logo, ppc.bid FROM vendor_ppc ppc JOIN sub_products p ON p.id = ppc.product_id " . $prodSrting2 . " AND ppc.is_active = 1 JOIN vendor v ON v.id = ppc.vendor_id " . $subProdPrimaryFilterStr . " JOIN image i ON i.id = v.logo_id WHERE ppc.vendor_id NOT IN (" . $row['vendor_id'] . ") ORDER BY bid DESC LIMIT 3"; $rotatorResults = $conn2->query($rotatorSql);
$rotator = mysqli_fetch_all($rotatorResults, MYSQLI_ASSOC);
}

if (count($rotator) > 0) {
echo ‘

Similar Companies

‘;
foreach ($rotator as $rateRow) {
$rqSql = “SELECT id, q0, q1, q2, q3, q4, q5, q6, q7, q8, q9, q10, q11, CASE WHEN s_type = 4 THEN comment ELSE NULL END as comment, CASE WHEN s_type = 4 THEN broker_name ELSE NULL END as company, s_type
FROM vendor_quality_review
WHERE vendor_id=” . $rateRow[‘id’];
$rSqlResult = $conn2->query($rqSql);

if ($rSqlResult->num_rows > 0) {
$ratingsQuality = $rSqlResult->fetch_all(MYSQLI_ASSOC);
} else {
$ratingsQuality = array();
}

$finalistSql = “SELECT CONCAT(finalist_meeting_id, finalist_attendee_id) as id, finalist_meeting_question_id, answer
FROM finalist_meeting fm
JOIN finalist_meeting_answer fma
ON fm.id = fma.finalist_meeting_id
WHERE fm.vendor_id = ” . $rateRow[‘id’] . ” AND
fma.question_type = ‘standard’
AND fma.question_data_type = ‘int’
GROUP BY finalist_meeting_id, finalist_attendee_id, finalist_meeting_question_id”;

$ratingsFinalists = $conn2->query($finalistSql);

$tempKey = 0;
$keyInd = 0;
$finalistAnswerArr = [];
if ($ratingsFinalists->num_rows > 0) {
while ($scores = $ratingsFinalists->fetch_assoc()) {
if ($tempKey != $scores[‘id’] && $tempKey != 0) {
if (count($finalistAnswerArr[$tempKey]) < 12) { for ($fa = count($finalistAnswerArr[$tempKey]); $fa < 12; $fa++) { $finalistAnswerArr[$tempKey]['id'] = ""; if ($fa == 11) { $tempCount = 0; $tempCountTotal = 0; for ($n = 0; $n < 11; $n++) { if ($finalistAnswerArr[$tempKey]["q" . $n] != NULL && strtolower($finalistAnswerArr[$tempKey]["q" . $n]) != "na" && strtolower($finalistAnswerArr[$tempKey]["q" . $n]) != "n/a") { $tempCountTotal += $finalistAnswerArr[$tempKey][$n]; $tempCount++; } } $finalistAnswerArr[$tempKey]["q11"] = round($tempCountTotal / $tempCount); } else { $finalistAnswerArr[$tempKey]["q" . $fa] = NULL; } $finalistAnswerArr[$tempKey]['comment'] = ""; $finalistAnswerArr[$tempKey]['company'] = ""; $finalistAnswerArr[$tempKey]['s_type'] = ""; } } $keyInd = 0; } for ($z = $keyInd; $z <= $scores['finalist_meeting_question_id']; $z++) { $finalistAnswerArr[$scores['id']]["q" . $z] = ($scores['finalist_meeting_question_id'] == $z) ? $scores['answer'] : NULL; } $keyInd = $z; $tempKey = $scores['id']; } } $ratingsReviewSql = "SELECT NULL as id, NULL as q0, NULL as q1, NULL as q2, NULL as q3, NULL as q4, NULL as q5, NULL as q6, NULL as q7, NULL as q8, NULL as q9, NULL as q10, ROUND(overall_rating * 2) as q11, NULL as comment, NULL as company, NULL as s_type FROM vendor_review WHERE vendor_id=" . $rateRow['id']; $ratingsSqlResult = $conn2->query($ratingsReviewSql);

if ($ratingsSqlResult->num_rows > 0) {
$ratingsQuality2 = $ratingsSqlResult->fetch_all(MYSQLI_ASSOC);
} else {
$ratingsQuality2 = array();
}

$ratingsArr = array_merge($ratingsQuality, $finalistAnswerArr, $ratingsQuality2);

$totalScore = 0;
$totalCount = 0;
$reviewCount = 0;
$carouselArr = array();
foreach ($ratingsArr as $rating) {
$ratingTemp = 0;
$numRatings = 0;
if ($rating[‘comment’]) {
$reviewCount++;
}
if ($rating[‘q11’] && $rating[‘q11’] != “N/A”) {
$score = round($rating[‘q11’] / 2, 1);
} else {
if ($rating[‘q0’] != “” && $rating[‘q0’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q0’]) ? $rating[‘q0’] : 0;
$numRatings++;
}
if ($rating[‘q1’] != “” && $rating[‘q1’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q1’]) ? $rating[‘q1’] : 0;
$numRatings++;
}
if ($rating[‘q2’] != “” && $rating[‘q2’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q2’]) ? $rating[‘q2’] : 0;
$numRatings++;
}
if ($rating[‘q3’] != “” && $rating[‘q3’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q3’]) ? $rating[‘q3’] : 0;
$numRatings++;
}
if ($rating[‘q4’] != “” && $rating[‘q4’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q4’]) ? $rating[‘q4’] : 0;
$numRatings++;
}
if ($rating[‘q5’] != “” && $rating[‘q5’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q5’]) ? $rating[‘q5’] : 0;
$numRatings++;
}
if ($rating[‘q6’] != “” && $rating[‘q6’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q6’]) ? $rating[‘q6’] : 0;
$numRatings++;
}
if ($rating[‘q7’] != “” && $rating[‘q7’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q7’]) ? $rating[‘q7’] : 0;
$numRatings++;
}
if ($rating[‘q8’] != “” && $rating[‘q8’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q8’]) ? $rating[‘q8’] : 0;
$numRatings++;
}
if ($rating[‘q9’] != “” && $rating[‘q9’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q9’]) ? $rating[‘q9’] : 0;
$numRatings++;
}
if ($rating[‘q10’] != “” && $rating[‘q10’] != “N/A”) {
$ratingTemp += $ratingTemp + ($rating[‘q10’]) ? $rating[‘q10’] : 0;
$numRatings++;
}

$score = round((($ratingTemp / 2) / $numRatings), 1);
}

if ($rating[‘comment’]) {
$carouselArr[$rating[‘id’]][‘comment’] = $rating[‘comment’];
$carouselArr[$rating[‘id’]][‘company’] = $rating[‘company’];
$carouselArr[$rating[‘id’]][‘score’] = $score;
}

$totalScore = $totalScore + $score;
$totalCount++;
}

if ($totalCount > 0) {
$score = round($totalScore / $totalCount, 1);
} else {
$score = 0;
}

if ($showLeads) {
$clickTarget = ‘href=”javascript: void(0);” onclick=”sub_click(\” . urlencode(base64_encode($rateRow[‘slug’])) . ‘\’,\” . urlencode($ip) . ‘\’,\” . urlencode($ref) . ‘\’, \’4\’, \” . $rateRow[‘name’] . ‘\’)”‘;
} else {
$clickTarget = ‘href=”javascript: void(0);” onclick=”ppc_click(\”.urlencode(base64_encode($row2[‘slug’])).’\’,\”.urlencode($ip).’\’,\”.urlencode($ref).’\’,\’1\’)”‘;
$clickTarget = ‘href=”‘ . $protocol . ” . $domainName . ‘/external_click?vid=’ . urlencode(base64_encode($rateRow[‘slug’])) . ‘&uid=’ . urlencode($ip) . ‘&ref=’ . urlencode($ref) . ‘&link_from=4″ target=”_blank”‘;
}

echo ‘

• 
  
  
  

  ‘ . $rateRow[‘name’] . ‘

  ‘;
  if (count($ratingsArr) > 0 && $totalCount > 0) {
  echo ‘

  ‘;
  if ($score >= 0 && $score < .5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= .5 && $score < 1) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 1 && $score < 1.5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 1.5 && $score < 2) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 2 && $score < 2.5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 2.5 && $score < 3) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 3 && $score < 3.5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 3.5 && $score < 4) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 4 && $score < 4.5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score >= 4.5 && $score < 5) { echo '

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  } else if ($score == 5) {
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  echo ‘

  ‘;
  }
  echo ‘

  • ‘ . $score . ‘/5 (‘ . $totalCount . ‘ reviews)

  ‘;
  }

  $sqlDesc = “SELECT prod_co_desc FROM vendor_survey_ab vs JOIN vendor_survey_product_ab vsp ON vs.id = vsp.vendor_survey_ab_id JOIN products p ON p.id = vsp.product_id AND p.public_slug = ‘” . $prodSrting . “‘ WHERE vs.vendor_id = ” . $rateRow[‘id’] . “
  UNION
  SELECT prod_co_desc FROM vendor_survey_ab vs2 JOIN vendor_survey_sub_product_ab vssp ON vssp.id = vssp.vendor_survey_ab_id JOIN sub_products sp ON sp.id = vssp.sub_product_id AND sp.public_slug = ‘” . $prodSrting . “‘ WHERE vs2.vendor_id = ” . $rateRow[‘id’];

  $resultDesc = $conn2->query($sqlDesc);
  $prodCoDesc = “”;
  if ($resultDesc->num_rows > 0) {
  $desc = $resultDesc->fetch_assoc();
  $prodCoDesc = $desc[‘prod_co_desc’];
  }
  $tempDesc = “”;
  if (trim($prodCoDesc) != “”) {
  $tempDesc = $prodCoDesc;
  if (strlen($tempDesc) > 199) {
  $tempDesc = substr($tempDesc, 0, 200) . “…”;
  }
  } else {
  $tempDesc = $rateRow[‘summary’];
  if (strlen($tempDesc) > 199) {
  $tempDesc = substr($tempDesc, 0, 200) . “…”;
  }
  }
  if ($showLeads) {
  $clickTarget = ‘href=”javascript: void(0);” onclick=”sub_click(\” . urlencode(base64_encode($rateRow[‘slug’])) . ‘\’,\” . urlencode($ip) . ‘\’,\” . urlencode($ref) . ‘\’, \’5\’, \” . $rateRow[‘name’] . ‘\’)”‘;
  } else {
  $clickTarget = ‘href=”javascript: void(0);” onclick=”ppc_click(\”.urlencode(base64_encode($rateRow[‘slug’])).’\’,\”.urlencode($ip).’\’,\”.urlencode($ref).’\’,\’1\’)”‘;
  }
  echo ‘

  ‘ . strip_tags(strip_tags(str_replace(“$”, “$”, $tempDesc), ‘$’) . ‘

  Get More Info

‘;
}
echo ‘

‘;
}
[/insert_php]

will be in touch to provide pricing info shortly . They may need more specific information about the program you’re looking for, so that they can provide pricing on the most appropriate features and components .

Shortlister Connect is a tool specifically designed to be utilized by the HR and Procurement/Sourcing teams within mid-size, large and jumbo employers. Shortlister Connect allows these teams to efficiently research & identify their optimal vendor partners, track existing vendor relationships & performance and “connect” with other employers to share successes and vendor experiences. ​

If you are not on the HR or Procurement/Sourcing team within an employer with over 200 employees, you will not be granted access to Connect. Examples of individuals that would not be granted access include, but are not limited to: vendors, students, practitioners, researchers, other non-employers or anyone that is unwilling to identify themselves will not pass our vetting criteria. If you are a consultant, Shortlister offers a specialized product for consultants, called Shortlister Select. You can email Tom Ciccotti at tciccotti@myshortlister.com to learn more about Shortlister Select. ​

***Shortlister retains the exclusive right to grant or deny access to any party to ensure the privacy of the vendors in our system.

LinkedIn

Please login with your LinkedIn Credentials

Once you’ve selected multiple vendors, click Send Me Info. Each vendor will provide information on how their solution can be tailored to fit your needs.

Send Me Info
Remove All()

for Consultants

Used by most of the top employee benefits consultants in the US, Shortlister is where you can find, research and select HR and benefits vendors for your clients.

Get Started

for Vendors

Shortlister helps you reach your ideal prospects. Claim your free account to control your message and receive employer, consultant and health plan leads.

Claim Your Listing