[insert_php]
$connArr = explode(‘:’, DB_HOST);
$conn = new mysqli($connArr[0], DB_USER, DB_PASSWORD, DB_NAME);
mysqli_set_charset($conn,”utf8″);
$sql_count = “SELECT distinct vd.website
FROM vendor_data vd
JOIN vendor_programs vp
ON vd.vendor_id = vp.vendor_id AND vp.program_id = 34
WHERE is_active = 1 AND is_public <> 1 AND in_house = 1”;
$result_count = $conn->query($sql_count);
$showAllSQL = “”;
if (mysqli_num_rows($result_count) >= 20){
$showAllSQL = ” AND in_house = 1 “;
}
$sql = “SELECT *,
CASE WHEN ((media1_link != ” AND media1_link != ‘NULL’) OR (media2_link != ” AND media2_link != ‘NULL’) OR (media3_link != ” AND media3_link != ‘NULL’)) AND ((snapshot1_id != ” AND snapshot1_id != ‘NULL’) OR (snapshot2_id != ” AND snapshot2_id != ‘NULL’) OR (snapshot3_id != ” AND snapshot3_id != ‘NULL’)) AND has_docs > 0 THEN 3
WHEN (((media1_link != ” AND media1_link != ‘NULL’) OR (media2_link != ” AND media2_link != ‘NULL’) OR (media3_link != ” AND media3_link != ‘NULL’)) AND ((snapshot1_id != ” AND snapshot1_id != ‘NULL’) OR (snapshot2_id != ” AND snapshot2_id != ‘NULL’) OR (snapshot3_id != ” AND snapshot3_id != ‘NULL’))) OR (((media1_link != ” AND media1_link != ‘NULL’) OR (media2_link != ” AND media2_link != ‘NULL’) OR (media3_link != ” AND media3_link != ‘NULL’)) AND has_docs > 0) OR (((snapshot1_id != ” AND snapshot1_id != ‘NULL’) OR (snapshot2_id != ” AND snapshot2_id != ‘NULL’) OR (snapshot3_id != ” AND snapshot3_id != ‘NULL’)) AND has_docs > 0) THEN 2
WHEN ((media1_link != ” AND media1_link != ‘NULL’) OR (media2_link != ” AND media2_link != ‘NULL’) OR (media3_link != ” AND media3_link != ‘NULL’)) OR ((snapshot1_id != ” AND snapshot1_id != ‘NULL’) OR (snapshot2_id != ” AND snapshot2_id != ‘NULL’) OR (snapshot3_id != ” AND snapshot3_id != ‘NULL’)) OR has_docs > 0 THEN 1
ELSE 0 END as media,
CASE WHEN vp.in_house = 1 AND vp.stand_alone = 1 THEN 1 ELSE 0 END as in_house_alone
FROM vendor_data vd
JOIN vendor_programs vp
ON vd.vendor_id = vp.vendor_id AND vp.program_id = 34
WHERE is_active = 1
AND is_public <> 1
AND vd.vendor_id IN (
SELECT MIN(B.vendor_id) as vendor_id FROM vendor_data B
WHERE B.website = vd.website)
$showAllSQL
ORDER BY in_house_alone DESC, preferred DESC, MAV DESC, media DESC, last_updated DESC, name ASC”;
$sql2 = “SELECT name FROM (SELECT name,
CASE WHEN ((media1_link != ” AND media1_link != ‘NULL’) OR (media2_link != ” AND media2_link != ‘NULL’) OR (media3_link != ” AND media3_link != ‘NULL’)) AND ((snapshot1_id != ” AND snapshot1_id != ‘NULL’) OR (snapshot2_id != ” AND snapshot2_id != ‘NULL’) OR (snapshot3_id != ” AND snapshot3_id != ‘NULL’)) AND has_docs > 0 THEN 3
WHEN (((media1_link != ” AND media1_link != ‘NULL’) OR (media2_link != ” AND media2_link != ‘NULL’) OR (media3_link != ” AND media3_link != ‘NULL’)) AND ((snapshot1_id != ” AND snapshot1_id != ‘NULL’) OR (snapshot2_id != ” AND snapshot2_id != ‘NULL’) OR (snapshot3_id != ” AND snapshot3_id != ‘NULL’))) OR (((media1_link != ” AND media1_link != ‘NULL’) OR (media2_link != ” AND media2_link != ‘NULL’) OR (media3_link != ” AND media3_link != ‘NULL’)) AND has_docs > 0) OR (((snapshot1_id != ” AND snapshot1_id != ‘NULL’) OR (snapshot2_id != ” AND snapshot2_id != ‘NULL’) OR (snapshot3_id != ” AND snapshot3_id != ‘NULL’)) AND has_docs > 0) THEN 2
WHEN ((media1_link != ” AND media1_link != ‘NULL’) OR (media2_link != ” AND media2_link != ‘NULL’) OR (media3_link != ” AND media3_link != ‘NULL’)) OR ((snapshot1_id != ” AND snapshot1_id != ‘NULL’) OR (snapshot2_id != ” AND snapshot2_id != ‘NULL’) OR (snapshot3_id != ” AND snapshot3_id != ‘NULL’)) OR has_docs > 0 THEN 1
ELSE 0 END as media,
CASE WHEN vp.in_house = 1 AND vp.stand_alone = 1 THEN 1 ELSE 0 END as in_house_alone
FROM vendor_data vd
JOIN vendor_programs vp
ON vd.vendor_id = vp.vendor_id AND vp.program_id = 34
WHERE is_active = 1
AND is_public <> 1
AND vd.vendor_id IN (
SELECT MIN(B.vendor_id) as vendor_id FROM vendor_data B
WHERE B.website = vd.website)
$showAllSQL
ORDER BY in_house_alone DESC, preferred DESC, MAV DESC, media DESC, last_updated DESC, name ASC LIMIT 20) a order by name”;
$result = $conn->query($sql);
$result2 = $conn->query($sql2);
$result3 = $conn->query($sql2);
[/insert_php]
TOP FINANCIAL WELLNESS PROGRAMS
Shortlister is trusted by employers and employee benefits consultants to identify their optimal vendor based on their budget,
demographics and program goals. Leverage our expertise to save yourself the time and hassle of navigating the crowded vendor marketplace.
×
Need Help?
Shortlister helps thousands of employers find the right vendor every year. We efficiently and accurately identify the shortlist of vendors that can meet your program goals and guide you through the selection process.
Summary list of the top 20 financial wellness companies in Shortlister [insert_php]echo substr($asOf, 1);[/insert_php], presented in alphabetical order. For details on each vendor and a comprehensive list of all financial wellness programs, scroll down.
- 1. Best Money Moves LLC
- 2. BrightDime
- 3. CommonBond
- 4. Doublenet Pay
- 5. Edu(k)ate
- 6. Enrich
- 7. Financial Finesse
- 8. Financial Fitness Group
- 9. Four Seasons Financial Education
- 10. HelloWallet
- 11. Kashable
- 12. Mapping Your Future Financial Solutions
- 13. My Secure Advantage
- 14. Peanut Butter
- 15. Pete the Planner
- 16. Retiremap
- 17. SmartDollar
- 18. Student Loan Genius
- 19. SUM180
- 20. Trustmark Money Steps
[insert_php]
if (count($result)){
while($row = $result->fetch_assoc()){
if(strlen($row[‘summary’]) > 415){
$summary = substr($row[‘summary’], 0, 415).’…’;
}
else{
$summary = $row[‘summary’];
}
echo’
‘.$row[‘name’].’ ‘;
if ($row[‘has_docs’]){ echo ‘
Profile includes marketing materials
‘; };
if (($row[‘snapshot1_id’] && $row[‘snapshot1_id’] != “NULL”) || ($row[‘snapshot2_id’] && $row[‘snapshot2_id’] != “NULL”) || ($row[‘snapshot3_id’] && $row[‘snapshot3_id’] != “NULL”)){ echo ‘
Profile includes screenshots
‘; };
if (($row[‘media1_link’] && $row[‘media1_link’] != “NULL”) || ($row[‘media2_link’] && $row[‘media2_link’] != “NULL”) || ($row[‘media3_link’] && $row[‘media3_link’] != “NULL”)){ echo ‘
Profile includes video
‘; };
echo ‘
☆☆☆☆☆ This information is only available to authorized Shortlister users
‘.$summary .’
‘;}}
[/insert_php]