Vendor list tabbed cover and markup

Filters

Sort By: Sponsored

Why is this info free?

[insert_php]
$ppcParticipantArr = array();
$orderArr = array();
$top20LinkArr = array();
$noBudgetArr = array();
if ($ppResults)
{
foreach ($ppResults as $row)
{
$vendorSql = “SELECT vp.prod_co_desc
FROM vendor_survey_ab vs
JOIN vendor_survey_product_ab vp
ON vs.id = vp.vendor_survey_ab_id AND vp.product_id = ” . $pid . “
WHERE vs.vendor_id = ” . $row[‘id’] . “
UNION
SELECT vp.prod_co_desc
FROM vendor_survey_ab vs
JOIN vendor_survey_sub_product_ab vp
ON vs.id = vp.vendor_survey_ab_id AND vp.sub_product_id = ” . $pid . “
WHERE vs.vendor_id = ” . $row[‘id’];

$prodDesc = $conn2->query($vendorSql);
$desc = $prodDesc->fetch_assoc();

if ($desc[‘prod_co_desc’])
{
if (strlen($desc[‘prod_co_desc’]) > 415)
{
$summary = substr($desc[‘prod_co_desc’], 0, 375) . ‘…’;
}
else
{
$summary = $desc[‘prod_co_desc’];
}
}
else
{
if (strlen($row[‘summary’]) > 415)
{
$summary = substr($row[‘summary’], 0, 375) . ‘…’;
}
else
{
$summary = $row[‘summary’];
}
}

$summary = str_replace(‘$’, ‘$’, $summary);

if ($row[‘budget_remaining’] > 0)
{
$budgetPPCSql = “
SELECT bid
FROM vendor_ppc ppc
JOIN (SELECT id, public_slug FROM products UNION SELECT id, public_slug FROM sub_products) p
ON p.id = ppc.product_id
AND p.public_slug LIKE ‘” . $page . “‘
WHERE ppc.vendor_id = ” . $row[‘id’] . “
AND ppc.is_active = 1″;

$budgetPPCResults = $conn2->query($budgetPPCSql);

$minBidAmount = 0;
if ($budgetPPCResults->num_rows > 0)
{
$ppcRows = mysqli_fetch_all($budgetPPCResults, MYSQLI_ASSOC);
$minBidAmount = $ppcRows[0][‘bid’];
}
$budgetPPLSql = “
SELECT bid
FROM vendor_ppl ppl
JOIN (SELECT id, public_slug FROM products UNION SELECT id, public_slug FROM sub_products) p
ON p.id = ppl.product_id
AND p.public_slug LIKE ‘” . $page . “‘
WHERE ppl.vendor_id = ” . $row[‘id’] . “
AND ppl.is_active = 1″;

$budgetPPLResults = $conn2->query($budgetPPLSql);

$minBidAmount2 = 0;
if ($budgetPPLResults->num_rows > 0)
{
$pplRows = mysqli_fetch_all($budgetPPLResults, MYSQLI_ASSOC);
$minBidAmount2 = $pplRows[0][‘bid’];
}
if ($minBidAmount > 0 && $minBidAmount2 > 0)
{
$minBidAmount = MIN(array(
$minBidAmount,
$minBidAmount2
));
}
else if ($minBidAmount2)
{
$minBidAmount = $minBidAmount2;
}
$orderArr[] = (string)$row[‘id’];
if ($row[‘budget_remaining’] >= $minBidAmount)
{
if (count($ppcRows) > 0){
$ppcParticipantArr[] = $row[‘id’];
}
echo ‘

‘;
echo ‘

MATCHING
SCORE

Register for Shortlister and see which vendors fit your product needs, goals and employee demographic

‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘

‘;
$top20LinkArr[] = $row[‘id’];
}
else{
echo ‘

‘;
$top20LinkArr[] = $row[‘id’];
}
echo ‘

‘;
echo ‘

‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘‘.$row[‘name’].’‘;
}
else{
echo ‘‘.$row[‘name’].’‘;
}
echo ‘

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

‘;
}
echo ‘

‘ . $score . ‘/5 (‘ . $numRatings . ‘ reviews)

‘;
echo ‘

‘;
if ($showLeads && $row[‘is_ppl’])
{
echo ‘

Request Info

‘;
}
else
{
echo ‘

Visit Website

‘;
}

if ($showLeads)
{
echo ‘

Vendor Summary

‘;
}
else
{
echo ‘

Vendor Summary

‘;
}
echo ‘

‘;
if (array_key_exists($row[‘id’], $t20Arr) && ($t20Arr[$row[‘id’]][‘eligible’] == “1” || $t20Arr[$row[‘id’]][‘retro_active’] == “1”))
{
echo ‘

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

Add to Compare

‘;
echo ‘

About ‘ . $row[‘name’] . ‘

‘ . $summary . ‘
continue reading

‘;

echo ‘

‘;
echo ‘‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘

‘;
}
else{
echo ‘

‘;
}
echo ‘

‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘‘.$row[‘name’].’‘;
}
else{
echo ‘‘.$row[‘name’].’‘;
}
echo ‘

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

‘;
}
echo ‘

‘.$score.’/5 (‘.$numRatings.’ reviews)

‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘

Request Info

‘;
}
else{
echo ‘

Visit Website

‘;
}
echo ‘

Or select multiple vendors to get pricing

‘.$summary.’ ‘;
echo ‘

‘;
echo ‘

Or select multiple vendors to get pricing

‘;
}
else
{
$noBudgetArr[] = $row[‘id’];
}
}
else
{
$noBudgetArr[] = $row[‘id’];
}
}
}

$vidArr = array_merge($pplArr, $pplArr2);
if ($noBudgetArr && $vidArr)
{
foreach ($noBudgetArr as $v)
{
if (($key = array_search($v, $vidArr)) !== false)
{
unset($vidArr[$key]);
}
}
foreach ($noBudgetArr as $v)
{
if (($key = array_search($v, $vidArr)) !== false)
{
unset($vidArr[$key]);
}
}
}
if ($vidArr)
{
$ppStr = implode(‘,’, $vidArr);
}
else
{
$ppStr = “0”;
}
[/insert_php]
[insert_php]
$sql = “SELECT DISTINCT a.*, (prod_points + pref_points + mav_points + link_points + vid_points + snap_points + doc_points + mo3_points + mo1_points) as points
FROM(
SELECT vd.*,
CASE WHEN $prodText = ” . $pid . ” AND vp.is_primary = 1 THEN 7 ELSE 0 END as prod_points,
CASE WHEN vd.preferred = 1 THEN 4 ELSE 0 END as pref_points,
CASE WHEN vd.MAV = 1 THEN 3 ELSE 0 END as mav_points,
CASE WHEN vd.linkback = 1 THEN 3 ELSE 0 END as link_points,
CASE WHEN (vd.media1_link != ” AND vd.media1_link != ‘NULL’) OR (vd.media2_link != ” AND vd.media2_link != ‘NULL’) OR (vd.media3_link != ” AND vd.media3_link != ‘NULL’) THEN 1 ELSE 0 END as vid_points,
CASE WHEN (vd.snapshot1_id != ” AND vd.snapshot1_id != ‘NULL’) OR (vd.snapshot2_id != ” AND vd.snapshot2_id != ‘NULL’) OR (vd.snapshot3_id != ” AND vd.snapshot3_id != ‘NULL’) THEN 1 ELSE 0 END as snap_points,
CASE WHEN vd.has_docs > 0 THEN 1 ELSE 0 END as doc_points,
CASE WHEN vd.last_updated > now()-interval 3 month THEN 1 ELSE 0 END as mo3_points,
CASE WHEN vd.last_updated > now()-interval 1 month THEN 1 ELSE 0 END as mo1_points
FROM vendor_data_ab vd
JOIN vendor_products vp
ON vd.vendor_id = vp.vendor_id AND $prodText = ” . $pid . “
WHERE (is_active = 1 || (vd.website IS NOT NULL AND vd.website != ”))
AND is_public <> 1
AND
(
(
vd.vendor_id IN (
SELECT MIN(B.vendor_id) as vendor_id FROM vendor_data_ab B
WHERE B.website = vd.website AND (B.is_active = 1 || (B.website IS NOT NULL AND B.website != ”))
)
)
OR
vd.vendor_id in ($t20Ids)
)
AND vd.vendor_id NOT IN ($ppStr)
)
a
ORDER BY points DESC, name ASC”;
$result = $conn->query($sql);
if ($result)
{
while ($row = $result->fetch_assoc())
{
$vendorSql = “SELECT vp.prod_co_desc
FROM vendor_survey_ab vs
JOIN vendor_survey_product_ab vp
ON vs.id = vp.vendor_survey_ab_id AND vp.product_id = ” . $pid . “
WHERE vs.vendor_id = ” . $row[‘vendor_id’] . “
UNION
SELECT vp.prod_co_desc
FROM vendor_survey_ab vs
JOIN vendor_survey_sub_product_ab vp
ON vs.id = vp.vendor_survey_ab_id AND vp.sub_product_id = ” . $pid . “
WHERE vs.vendor_id = ” . $row[‘vendor_id’];

$prodDesc = $conn2->query($vendorSql);
$desc = $prodDesc->fetch_assoc();

if ($desc[‘prod_co_desc’])
{
if (strlen($desc[‘prod_co_desc’]) > 415)
{
$summary = substr($desc[‘prod_co_desc’], 0, 415) . ‘…’;
}
else
{
$summary = $desc[‘prod_co_desc’];
}
}
else
{
if (strlen($row[‘summary’]) > 415)
{
$summary = substr($row[‘summary’], 0, 415) . ‘…’;
}
else
{
$summary = $row[‘summary’];
}
}

$summary = str_replace(‘$’, ‘$’, $summary);

$orderArr[] = (string)$row[‘vendor_id’];
$overbudget = “”;
if (in_array($row[‘vendor_id’], $noBudgetArr))
{
$overbudget = ‘overbudget’;
}
$top20LinkArr[] = $row[‘vendor_id’];
echo ‘

‘;
echo ‘

MATCHING
SCORE

Register for Shortlister and see which vendors fit your product needs, goals and employee demographic

‘;
echo ‘

‘;
echo ‘‘ . $row[‘name’] . ‘‘;
echo ‘

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

‘;
}
echo ‘

‘ . $score . ‘/5 (‘ . $numRatings . ‘ reviews)

‘;
echo ‘

Full Profile

‘;

echo ‘

Vendor Summary

‘;

echo ‘

‘;
if (array_key_exists($row[‘vendor_id’], $t20Arr) && ($t20Arr[$row[‘vendor_id’]][‘eligible’] == “1” || $t20Arr[$row[‘vendor_id’]][‘retro_active’] == “1”))
{
echo ‘

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

Add to Compare

‘;
echo ‘

About ‘ . $row[‘name’] . ‘

‘ . $summary . ‘
continue reading

‘;

echo ‘

‘;
echo ‘‘;
echo ‘

‘;
echo ‘

Request Info

‘;

echo ‘

‘;
echo ‘‘.$row[‘name’].’‘;
echo ‘

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

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

‘;
echo ‘

‘;
}
echo ‘

‘.$score.’/5 (‘.$numRatings.’ reviews)

‘;
echo ‘

Full Profile

‘;
echo ‘

Or select multiple vendors to get pricing

‘.$summary.’ ‘;
echo ‘

Or select multiple vendors to get pricing

‘;
}
}
[/insert_php]

[insert_php]
echo $prodName;
[/insert_php]

Top ‘.count($t20Arr).’ ‘.$prodName.’

Get Important Updates On These Vendors Monthly

Filters

Filters

Features:

Cost:

Sort By: Sponsored

Sort By: Sponsored

‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘‘.$row[‘name’].’‘;
}
else{
echo ‘‘.$row[‘name’].’‘;
}
echo ‘

‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘‘.$row[‘name’].’‘;
}
else{
echo ‘‘.$row[‘name’].’‘;
}
echo ‘

‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘

Request Info

‘;
}
else{
echo ‘

Visit Website

‘;
}
echo ‘

‘;
echo ‘‘ . $row[‘name’] . ‘‘;
echo ‘

‘;
echo ‘‘.$row[‘name’].’‘;
echo ‘

‘;
echo ‘

Full Profile

‘;
echo ‘

Get Important Updates On These Vendors Monthly

[insert_php] echo $prodName; [/insert_php]

Top ‘.count($t20Arr).’ ‘.$prodName.’

Get Important Updates On These Vendors Monthly

Filters

Filters

Features:

Cost:

Sort By: Sponsored

Sort By: Sponsored

‘; if ($showLeads && $row[‘is_ppl’]){ echo ‘‘.$row[‘name’].’‘; } else{ echo ‘‘.$row[‘name’].’‘; } echo ‘

‘; if ($showLeads && $row[‘is_ppl’]){ echo ‘‘.$row[‘name’].’‘; } else{ echo ‘‘.$row[‘name’].’‘; } echo ‘

‘; if ($showLeads && $row[‘is_ppl’]){ echo ‘ Request Info ‘; } else{ echo ‘ Visit Website ‘; } echo ‘

‘; echo ‘‘ . $row[‘name’] . ‘‘; echo ‘

‘; echo ‘‘.$row[‘name’].’‘; echo ‘

‘; echo ‘ Full Profile ‘; echo ‘

Get Important Updates On These Vendors Monthly

[insert_php]
echo $prodName;
[/insert_php]

‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘‘.$row[‘name’].’‘;
}
else{
echo ‘‘.$row[‘name’].’‘;
}
echo ‘

‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘‘.$row[‘name’].’‘;
}
else{
echo ‘‘.$row[‘name’].’‘;
}
echo ‘

‘;
if ($showLeads && $row[‘is_ppl’]){
echo ‘

Request Info

‘;
}
else{
echo ‘

Visit Website

‘;
}
echo ‘

‘;
echo ‘‘ . $row[‘name’] . ‘‘;
echo ‘

‘;
echo ‘‘.$row[‘name’].’‘;
echo ‘

‘;
echo ‘

Full Profile

‘;
echo ‘