SPECIAL MENTIONS
getBikeshopCategories();
foreach($dcategories as $dcat) {
$best_label = $dcat->id != 1 ? 'Best ' : '';
$winners = CyclistsChoiceWinner::with('bikeshop')->where('ccid', $ccid)->where('cccid', $dcat->id)->orderBy('rank', 'asc')->get();
// $winners_count = where('ccid', $ccid)->where('cccid', $dcat->id)->orderBy('rank', 'asc')->count();
$winners_count = $db->where('ccid', $ccid)->where('cccid', $dcat->id)->where('rank', 4)->get("cyclists_choice_winners");
if(count($winners_count) <= 0) {
continue;
}
$winner = $winners[0];
$img_url = $GLOBAL_HOST_RELATIVE_URL . "/bikeshops/images/shop/logo-large-" . $winner->winner_id . ".jpg";
$url = $GLOBAL_HOST_RELATIVE_URL . "/bikeshops/shop_details.php?sid=" . $winner->winner_id;
?>
rank) {
$img_url = $GLOBAL_HOST_RELATIVE_URL . "/bikeshops/images/shop/logo-large-" . $w->winner_id . ".jpg";
//$url = $GLOBAL_HOST_RELATIVE_URL . '/bikeshops/shop_details.php?sid=' . $w->winner_id;
//echo $w->winner_id;
//temporary fix will remove as soon the admin page for this is done
if($w->winner_id == 202){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4106';
} else if($w->winner_id == 419) {
$url2 = '
Read Write-Up';
$url = '';
} else if($w->winner_id == 1273) {
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4113';
} else if($w->winner_id == 208){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4114';
}
else if($w->winner_id == 324){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4114';
}
?>
Special Mention
artid > 0) {
// $artpage = $w->artpage;
// if($artpage > 0) {
// $article = new Article($cchoice->artid);
// $url = $article->getUrlRW($artpage);
?>
where('ccdid', $disc->id)->where('type', 'brand')->orderBy('type, sequence', 'asc')->get();
$dcategories = $cchoice->getBrandsByDiscipline($disc->id);
$artpage = 0;
if(!$dcategories) {
continue;
}
foreach($dcategories as $dcat) {
$winners = CyclistsChoiceWinner::with('brand')->where('ccid', $ccid)->where('cccid', $dcat->id)->orderBy('id', 'asc')->get();
$winners_count = $db->where('ccid', $ccid)->where('cccid', $dcat->id)->where('rank', 4)->get("cyclists_choice_winners");
if(count($winners_count) <= 0) {
continue;
}
$winner = $winners[0];
$img_url = $GLOBAL_HOST_RELATIVE_URL . "/items/images/" . $winner->brand->brand_image;
$url = $GLOBAL_HOST_RELATIVE_URL . "/items/view_brand.php?bid=" . $winner->winner_id;
if($winner->winner_id > 0) {
$distributors = new TieIns("mid", "ASC", 0, 999, 0, $winner->winner_id, 0);
$dist_size = $distributors->size();
} else {
$dist_size = 0;
}
if($artpage == 0) {
$artpage = $winner->artpage;
}
?>
isMobile()) { ?>
rank) {
$img_url = $GLOBAL_HOST_RELATIVE_URL . "/items/images/". $w->brand->brand_image;
//$url = $GLOBAL_HOST_RELATIVE_URL . '/items/view_brand.php?bid=' . $w->winner_id;
//echo $w->winner_id;
//temporary fix will remove as soon the admin page for this is done
if($w->winner_id == 994) {
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4115';
} else if($w->winner_id == 558){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4110';
} else if($w->winner_id == 224){
$url2 = '
Read Write-Up';
$url = '';
} else if($w->winner_id == 859 && $dcat->category == 'MTB Wheelsets'){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4117';
} else if($w->winner_id == 859){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4118';
} else if($w->winner_id == 921){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4116';
} else if($w->winner_id == 922){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4119';
} else if($w->winner_id == 244){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4123';
} else if($w->winner_id == 847){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4122';
} else if($w->winner_id == 1145){
$url2 = '
Read Write-Up';
$url = $GLOBAL_HOST_RELATIVE_URL.'/article/article.php?artid=4083';
} else if($w->winner_id == 671){
$url2 = '
Read Write-Up';
$url = '';
}
?>
Special Mention
artid > 0) {
// $artpage = $w->artpage;
// if($artpage > 0) {
// $article = new Article($cchoice->artid);
// $url = $article->getUrlRW($artpage);
?>
LOCAL BIKESHOP AWARDS
getBikeshopCategories();
//$dcategories = array(13, 14, 15, 16);
foreach($dcategories as $dcat) {
$best_label = $dcat->id != 1 ? 'Best ' : '';
// $winners = CyclistsChoiceWinner::with('bikeshop')->where('ccid', $ccid)->where('cccid', $dcat->id)->orderBy('rank', 'asc')->get();
$winners = CyclistsChoiceWinner::with('bikeshop')->where('ccid', $ccid)->where('cccid', $dcat->id)->orderBy('rank', 'asc')->get();
$winners_count = $db->where('ccid', $ccid)->where('cccid', $dcat->id)->where('rank', 1)->get("cyclists_choice_winners");
$first_runner = $db->where('ccid', $ccid)->where('cccid', $dcat->id)->where('rank', 2)->get("cyclists_choice_winners");
$second_runner = $db->where('ccid', $ccid)->where('cccid', $dcat->id)->where('rank', 3)->get("cyclists_choice_winners");
if(count($winners_count) <= 0) {
continue;
}
$winner = $winners[0];
$img_url = $GLOBAL_HOST_RELATIVE_URL . "/bikeshops/images/shop/logo-large-" . $winner->winner_id . ".jpg";
//$url = $GLOBAL_HOST_RELATIVE_URL . "/bikeshops/shop_details.php?sid=" . $winner->winner_id;
if($cchoice->artid > 0) {
$article = new Article($cchoice->artid);
$artpage = 6;
$url = $article->getUrlRW($artpage);
}
?>
winner_id > 0) { ?>
Winner
*/ ?>
*/?>
rank) $has_runnerup = true;
}
if($ctr == 2) {
if(count($first_runner) > 1){
$wlabel = '1st Runner Up (tie)';
} else {
$wlabel = '1st Runner Up';
}
} else if($ctr == 3) {
if(count($second_runner) > 1){
$wlabel = '2nd Runner Up (tie)';
} else {
$wlabel = '2nd Runner Up';
}
}
}
if($has_runnerup) {
?>
rank) {
$img_url = $GLOBAL_HOST_RELATIVE_URL . "/bikeshops/images/shop/logo-large-" . $w->winner_id . ".jpg";
//$url = $GLOBAL_HOST_RELATIVE_URL . '/bikeshops/shop_details.php?sid=' . $w->winner_id;
?>
Lorem ipsum dolor sit amet, bonorum laoreet reprehendunt ad sit, vim erat commodo labitur et. Ne adhuc alienum dissentiet mel. An viderer propriae tractatos... */ ?>
artid > 0) {
$article = new Article($cchoice->artid);
$artpage = 6;
$url = $article->getUrlRW($artpage);
?>
Read Write-Up
artid > 0) { ?>
BRAND AWARDS
where('ccdid', $disc->id)->where('type', 'brand')->orderBy('type, sequence', 'asc')->get();
/* echo "
";
print_r($disciplines);
exit;*/
$dcategories = $cchoice->getBrandsByDiscipline($disc->id);
//$dcategories = array(19, 20, 21, 22, 33, 42, 43, 62);
$artpage = 0;
if(!$dcategories) {
continue;
}
foreach($dcategories as $dcat) {
$winners = CyclistsChoiceWinner::with('brand')->where('ccid', $ccid)->where('cccid', $dcat->id)->orderBy('id', 'asc')->get();
$winners_count = $db->where('ccid', $ccid)->where('cccid', $dcat->id)->where('rank', 1)->get("cyclists_choice_winners");
$first_runner = $db->where('ccid', $ccid)->where('cccid', $dcat->id)->where('rank', 2)->get("cyclists_choice_winners");
$second_runner = $db->where('ccid', $ccid)->where('cccid', $dcat->id)->where('rank', 3)->get("cyclists_choice_winners");
if(count($winners_count) <= 0) {
continue;
}
$winner = $winners[0];
$img_url = $GLOBAL_HOST_RELATIVE_URL . "/items/images/" . $winner->brand->brand_image;
//$url = $GLOBAL_HOST_RELATIVE_URL . "/items/view_brand.php?bid=" . $winner->winner_id;
if($cchoice->artid > 0) {
$article = new Article($cchoice->artid);
$url = $article->getUrlRW($artpage);
}
if($winner->winner_id > 0) {
$distributors = new TieIns("mid", "ASC", 0, 999, 0, $winner->winner_id, 0);
$dist_size = $distributors->size();
} else {
$dist_size = 0;
}
if($artpage == 0) {
$artpage = $winner->artpage;
}
?>
Best
winner_id > 0) { ?>
Winner
*/ ?>
rank) $has_runnerup = true;
}
if($ctr == 2) {
if(count($first_runner) > 1){
$wlabel = '1st Runner Up (tie)';
} else {
$wlabel = '1st Runner Up';
}
} else if($ctr == 3) {
if(count($second_runner) > 1){
$wlabel = '2nd Runner Up (tie)';
} else {
$wlabel = '2nd Runner Up';
}
}
}
if($has_runnerup) {
?>
rank) {
$img_url = $GLOBAL_HOST_RELATIVE_URL . "/items/images/". $w->brand->brand_image;
//$url = $GLOBAL_HOST_RELATIVE_URL . '/items/view_brand.php?bid=' . $w->winner_id;
?>
artid > 0) {
$article = new Article($cchoice->artid);
$url = $article->getUrlRW($artpage);
?>
Read Write-Up
Lorem ipsum dolor sit amet, bonorum laoreet reprehendunt ad sit, vim erat commodo labitur et. Ne adhuc alienum dissentiet mel. An viderer propriae tractatos... */ ?>