Tweet
Auf Inhalte anderer Kataloge zugreifen
$intEntry = $entry->field('myRefSelect')->value();
$objRefEntry = \Database::getInstance()->prepare("SELECT * FROM myTable WHERE id=?")->limit(1)->execute($intEntry);
echo $objRefEntry->id;
$foreignTableIdEntries = $entry->field('myRefSelect')->value();
[COLOR=#333333][SIZE=11px] [COLOR=#333333][SIZE=11px] [COLOR=#878787]<?php[/COLOR] [COLOR=#8735a5]$arrIds[/COLOR] [COLOR=#000000]=[/COLOR] [COLOR=#0045aa]array[/COLOR]([COLOR=#007ab7]1[/COLOR],[COLOR=#007ab7]2[/COLOR],[COLOR=#007ab7]3[/COLOR]); [COLOR=#8735a5]$objResults[/COLOR] [COLOR=#000000]=[/COLOR] \Database[COLOR=#000000]::[/COLOR][COLOR=#3f6e7d]getInstance[/COLOR]()[COLOR=#000000]->[/COLOR][COLOR=#3f6e7d]prepare[/COLOR]([COLOR=#dd2400]"[/COLOR][COLOR=#dd2400]SELECT * FROM myTable WHERE id IN([/COLOR][COLOR=#dd2400]"[/COLOR][COLOR=#000000].[/COLOR][COLOR=#400080]implode[/COLOR]([COLOR=#dd2400]','[/COLOR],[COLOR=#8735a5]$arrIds[/COLOR])[COLOR=#000000].[/COLOR][COLOR=#dd2400]")"[/COLOR])[COLOR=#000000]->[/COLOR][COLOR=#3f6e7d]execute[/COLOR](); [COLOR=#878787]?[/COLOR][COLOR=#878787]>[/COLOR] [COLOR=#0045aa]<ul>[/COLOR] [COLOR=#878787]<?php[/COLOR] [COLOR=#0045aa]while[/COLOR][COLOR=#000000]([/COLOR][COLOR=#8735a5]$objResults[/COLOR][COLOR=#000000]->[/COLOR][COLOR=#3f6e7d]next[/COLOR]()[COLOR=#000000])[/COLOR]: [COLOR=#878787]?[/COLOR][COLOR=#878787]>[/COLOR] [COLOR=#0045aa]<li>[/COLOR][COLOR=#878787]<?=[/COLOR] [COLOR=#8735a5]$objResults[/COLOR][COLOR=#000000]->id[/COLOR]; [COLOR=#878787]?[/COLOR][COLOR=#878787]>[/COLOR][COLOR=#0045aa]</li>[/COLOR] [COLOR=#878787]<?php[/COLOR] [COLOR=#0045aa]endwhile[/COLOR]; [COLOR=#878787]?[/COLOR][COLOR=#878787]>[/COLOR] [COLOR=#0045aa]</ul>[/COLOR] [/SIZE][/COLOR] [/SIZE][/COLOR]
[COLOR=#333333][SIZE=11px] [COLOR=#878787]<?php[/COLOR] [COLOR=#8735A5][SIZE=11px]$arrIds[/SIZE][/COLOR][COLOR=#000000][SIZE=11px]=[/SIZE][/COLOR][COLOR=#0045AA][SIZE=11px]array[/SIZE][/COLOR][COLOR=#333333][SIZE=11px]([/SIZE][/COLOR][COLOR=#007AB7][SIZE=11px]1[/SIZE][/COLOR][COLOR=#333333][SIZE=11px],[/SIZE][/COLOR][COLOR=#007AB7][SIZE=11px]2[/SIZE][/COLOR][COLOR=#333333][SIZE=11px],[/SIZE][/COLOR][COLOR=#007AB7][SIZE=11px]3[/SIZE][/COLOR][COLOR=#333333][SIZE=11px]);[/SIZE][/COLOR] [COLOR=#8735a5]$objContaoModel[/COLOR] [COLOR=#000000]=[/COLOR] [COLOR=#0045aa]new[/COLOR] \ContaoModel; // Klasse existiert nur mit CC [COLOR=#8735a5]$obj[/COLOR][/SIZE][/COLOR][COLOR=#8735A5][SIZE=11px]ContaoModel[/SIZE][/COLOR][COLOR=#333333][SIZE=11px][COLOR=#000000]->[/COLOR][COLOR=#3f6e7d]setTable[/COLOR]([COLOR=#dd2400]'[/COLOR][COLOR=#DD2400][SIZE=11px]myTable[/SIZE][/COLOR][COLOR=#dd2400]'[/COLOR]); [COLOR=#8735a5]$objModels[/COLOR] [COLOR=#000000]=[/COLOR] [COLOR=#8735a5]$obj[/COLOR][/SIZE][/COLOR][COLOR=#8735A5][SIZE=11px]ContaoModel[/SIZE][/COLOR][COLOR=#333333][SIZE=11px][COLOR=#000000]->[/COLOR][COLOR=#3f6e7d]findMultipleByIds[/COLOR]([COLOR=#8735a5]$arrIds[/COLOR]); // siehe Contao Model Klasse [COLOR=#878787]?[/COLOR][COLOR=#878787]>[/COLOR] [COLOR=#0045aa]<ul>[/COLOR] [COLOR=#878787]<?php[/COLOR] [COLOR=#0045aa]foreach[/COLOR][COLOR=#000000]([/COLOR][COLOR=#8735a5]$objModels[/COLOR] [COLOR=#000000]as[/COLOR] [COLOR=#8735a5]$objModel[/COLOR][COLOR=#000000])[/COLOR]: [COLOR=#878787]?[/COLOR][COLOR=#878787]>[/COLOR] [COLOR=#0045aa]<li>[/COLOR][COLOR=#878787]<?=[/COLOR] [COLOR=#8735a5]$objModel[/COLOR][COLOR=#000000]->id[/COLOR]; [COLOR=#878787]?[/COLOR][COLOR=#878787]>[/COLOR][COLOR=#0045aa]</li>[/COLOR] [COLOR=#878787]<?php[/COLOR] [COLOR=#0045aa]endforeach[/COLOR]; [COLOR=#878787]?[/COLOR][COLOR=#878787]>[/COLOR] [COLOR=#0045aa]</ul>[/COLOR][/SIZE][/COLOR]
<?php
$GLOBALS['accessoryIds'] = $this->field('accessories')->value;
?>
<?php $accessoryIds = $GLOBALS['accessoryIds']; ?>
<?php if(!empty($accessoryIds) && !$this->empty): ?>
<div class="mod_customcataloglist cc_product_catalog">
<div class="swiper-container" id="swiper_<?php echo $this->id; ?>">
<div class="swiper-wrapper">
<?php foreach($this->entries as $entry):
if (in_array($entry->id, $accessoryIds)):
?>
<div class="swiper-slide block entry<?php if($entry->field('highlight')->value()): ?> item-highlight<?php endif; ?>" <?php echo $this->cssID; ?>>
<div class="item-inside">
<?php if($entry->field('highlight')->value()): ?> <i class="item-highlight-icon fa fa-star"></i><?php endif; ?>
<a href="<?php echo $entry->links('detail')->url; ?>"><?php echo $entry->field('image')->html(); ?></a>
<h6><a href="<?php echo $entry->links('detail')->url; ?>"><?php echo $entry->field('name')->value(); ?></a></h6>
<div class="brand"><?php echo $entry->field('brand')->html(); ?></div>
<div class="price color-accent">€<?php echo $entry->field('price')->value(); ?><?php if($entry->field('price_old')->value()): ?><span> €<?php echo $entry->field('price_old')->value(); ?></span><?php endif; ?></div>
<?php echo $entry->field('rating')->html(); ?>
</div>
</div>
<?php endif;
endforeach; ?>
</div>
</div>
<div id="swiper-button-next_<?php echo $this->id; ?>" class="swiper-button-next"></div>
<div id="swiper-button-prev_<?php echo $this->id; ?>" class="swiper-button-prev"></div>
</div>
<script>
/* <![CDATA[ */
jQuery(document).ready(function(){
var swiper_<?php echo $this->id; ?> = new Swiper('#swiper_<?php echo $this->id; ?>', {
paginationClickable: true,
slidesPerView: 3,
grabCursor: true,
navigation: {
nextEl: '#swiper-button-next_<?php echo $this->id; ?>',
prevEl: '#swiper-button-prev_<?php echo $this->id; ?>',
},
breakpoints: {
768: {
slidesPerView: 1,
spaceBetween: 0,
}
}
});
});
/* ]]> */
</script>
<?php else: ?>
<p class="info empty">Kein kompatibles Zubehör gefunden</p>
<?php endif;?>
Kommentar