/**
* Find active layers.
*
* @return Collection|null
*/
public function findActiveLayers()
{
$query = <<<SQL
SELECT l.*, c.mode as controlMode
FROM tl_leaflet_layer l
LEFT JOIN tl_leaflet_control_layer
c ON l.id = c.lid
WHERE c.cid=? AND l.active=1
SQL;
$result = \Database::getInstance()->prepare($query)->execute($this->id);
if ($result->numRows < 1) {
return null;
}
return Collection::createFromDbResult($result, 'tl_leaflet_layer');
}
/**
* Find all active layers.
*
* @return Collection|null
*/
public function findActiveLayers()
{
$query = <<<SQL
SELECT l.*
FROM tl_leaflet_layer l
LEFT JOIN tl_leaflet_map_layer m
ON l.id = m.lid
WHERE m.mid=? AND l.active=1
SQL;
$result = \Database::getInstance()->prepare($query)->execute($this->id);
if ($result->numRows) {
return Collection::createFromDbResult($result, 'tl_leaflet_layer');
}
return null;
}
/**
* Create a new collection from a database result
*
* @param Database\Result $objResult The database result object
* @param string $strTable The table name
*
* @return Model\Collection The model collection
*/
protected static function createCollectionFromDbResult(Database\Result $objResult, $strTable)
{
return \Model\Collection::createFromDbResult($objResult, $strTable);
}
/**
* Fetch rules
*/
protected static function findByConditions($arrProcedures, $arrValues = array(), $arrProducts = null, $blnIncludeVariants = false, $arrAttributeData = array())
{
// Only enabled rules
$arrProcedures[] = "enabled='1'";
// Date & Time restrictions
$date = date('Y-m-d');
$time = date('H:i:s');
$arrProcedures[] = "(startDate='' OR startDate <= UNIX_TIMESTAMP('{$date}'))";
$arrProcedures[] = "(endDate='' OR endDate >= UNIX_TIMESTAMP('{$date}'))";
$arrProcedures[] = "(startTime='' OR startTime <= UNIX_TIMESTAMP('1970-01-01 {$time}'))";
$arrProcedures[] = "(endTime='' OR endTime >= UNIX_TIMESTAMP('1970-01-01 {$time}'))";
// Limits
$arrProcedures[] = "(limitPerConfig=0 OR limitPerConfig>(SELECT COUNT(*) FROM tl_iso_rule_usage WHERE pid=r.id AND config_id=" . (int) Isotope::getConfig()->id . " AND order_id NOT IN (SELECT id FROM tl_iso_product_collection WHERE type='order' AND source_collection_id=" . (int) Isotope::getCart()->id . ")))";
if (Isotope::getCart()->member > 0) {
$arrProcedures[] = "(limitPerMember=0 OR limitPerMember>(SELECT COUNT(*) FROM tl_iso_rule_usage WHERE pid=r.id AND member_id=" . (int) \FrontendUser::getInstance()->id . " AND order_id NOT IN (SELECT id FROM tl_iso_product_collection WHERE type='order' AND source_collection_id=" . (int) Isotope::getCart()->id . ")))";
}
// Store config restrictions
$arrProcedures[] = "(configRestrictions=''\n OR (configRestrictions='1' AND configCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='configs' AND object_id=" . (int) Isotope::getConfig()->id . ")>0)\n OR (configRestrictions='1' AND configCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='configs' AND object_id=" . (int) Isotope::getConfig()->id . ")=0))";
// Member restrictions
if (Isotope::getCart()->member > 0) {
$arrGroups = array_map('intval', deserialize(\FrontendUser::getInstance()->groups, true));
$arrProcedures[] = "(memberRestrictions='none'\n OR (memberRestrictions='guests' AND memberCondition='0')\n OR (memberRestrictions='members' AND memberCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='members' AND object_id=" . (int) \FrontendUser::getInstance()->id . ")>0)\n OR (memberRestrictions='members' AND memberCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='members' AND object_id=" . (int) \FrontendUser::getInstance()->id . ")=0)\n " . (!empty($arrGroups) ? "\n OR (memberRestrictions='groups' AND memberCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='groups' AND object_id IN (" . implode(',', $arrGroups) . "))>0)\n OR (memberRestrictions='groups' AND memberCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='groups' AND object_id IN (" . implode(',', $arrGroups) . "))=0)" : '') . ")";
} else {
$arrProcedures[] = "(memberRestrictions='none' OR (memberRestrictions='guests' AND memberCondition='1'))";
}
// Product restrictions
if (!is_array($arrProducts)) {
$arrProducts = Isotope::getCart()->getItems();
}
if (!empty($arrProducts)) {
$arrProductIds = array(0);
$arrVariantIds = array(0);
$arrAttributes = array(0);
$arrTypes = array(0);
// Prepare product attribute condition
$objAttributeRules = \Database::getInstance()->execute("SELECT * FROM " . static::$strTable . " WHERE enabled='1' AND productRestrictions='attribute' AND attributeName!='' GROUP BY attributeName, attributeCondition");
while ($objAttributeRules->next()) {
$arrAttributes[] = array('attribute' => $objAttributeRules->attributeName, 'condition' => $objAttributeRules->attributeCondition, 'values' => array());
}
foreach ($arrProducts as $objProduct) {
if ($objProduct instanceof ProductCollectionItem) {
if (!$objProduct->hasProduct()) {
continue;
}
$objProduct = $objProduct->getProduct();
}
$arrProductIds[] = (int) $objProduct->getProductId();
$arrVariantIds[] = (int) $objProduct->{$objProduct->getPk()};
$arrTypes[] = (int) $objProduct->type;
if ($objProduct->isVariant()) {
$arrVariantIds[] = (int) $objProduct->pid;
}
if ($blnIncludeVariants && $objProduct->hasVariants()) {
$arrVariantIds = array_merge($arrVariantIds, $objProduct->getVariantIds());
}
$arrOptions = $objProduct->getOptions();
foreach ($arrAttributes as $k => $restriction) {
$varValue = null;
if (isset($arrAttributeData[$restriction['attribute']])) {
$varValue = $arrAttributeData[$restriction['attribute']];
} elseif (isset($arrOptions[$restriction['attribute']])) {
$varValue = $arrOptions[$restriction['attribute']];
} else {
$varValue = $objProduct->{$restriction['attribute']};
}
if (!is_null($varValue)) {
$arrAttributes[$k]['values'][] = is_array($varValue) ? serialize($varValue) : $varValue;
}
}
}
$arrProductIds = array_unique($arrProductIds);
$arrVariantIds = array_unique($arrVariantIds);
$arrRestrictions = array("productRestrictions='none'");
$arrRestrictions[] = "(productRestrictions='producttypes' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='producttypes' AND object_id IN (" . implode(',', $arrTypes) . "))>0)";
$arrRestrictions[] = "(productRestrictions='producttypes' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='producttypes' AND object_id IN (" . implode(',', $arrTypes) . "))=0)";
$arrRestrictions[] = "(productRestrictions='products' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='products' AND object_id IN (" . implode(',', $arrProductIds) . "))>0)";
$arrRestrictions[] = "(productRestrictions='products' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='products' AND object_id IN (" . implode(',', $arrProductIds) . "))=0)";
$arrRestrictions[] = "(productRestrictions='variants' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='variants' AND object_id IN (" . implode(',', $arrVariantIds) . "))>0)";
$arrRestrictions[] = "(productRestrictions='variants' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='variants' AND object_id IN (" . implode(',', $arrVariantIds) . "))=0)";
$arrRestrictions[] = "(productRestrictions='pages' AND productCondition='1' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='pages' AND object_id IN (SELECT page_id FROM " . \Isotope\Model\ProductCategory::getTable() . " WHERE pid IN (" . implode(',', $arrProductIds) . ")))>0)";
$arrRestrictions[] = "(productRestrictions='pages' AND productCondition='0' AND (SELECT COUNT(*) FROM tl_iso_rule_restriction WHERE pid=r.id AND type='pages' AND object_id IN (SELECT page_id FROM " . \Isotope\Model\ProductCategory::getTable() . " WHERE pid IN (" . implode(',', $arrProductIds) . ")))=0)";
foreach ($arrAttributes as $restriction) {
if (empty($restriction['values'])) {
continue;
}
$strRestriction = "(productRestrictions='attribute' AND attributeName='" . $restriction['attribute'] . "' AND attributeCondition='" . $restriction['condition'] . "' AND ";
switch ($restriction['condition']) {
case 'eq':
case 'neq':
$strRestriction .= "attributeValue" . ($restriction['condition'] == 'neq' ? " NOT" : '') . " IN ('" . implode("','", array_map('mysql_real_escape_string', $restriction['values'])) . "')";
break;
case 'lt':
case 'gt':
case 'elt':
case 'egt':
$arrOR = array();
foreach ($restriction['values'] as $value) {
$arrOR[] = "attributeValue" . ($restriction['condition'] == 'lt' || $restriction['condition'] == 'elt' ? '>' : '<') . ($restriction['condition'] == 'elt' || $restriction['condition'] == 'egt' ? '=' : '') . '?';
$arrValues[] = $value;
}
$strRestriction .= '(' . implode(' OR ', $arrOR) . ')';
break;
case 'starts':
case 'ends':
case 'contains':
$arrOR = array();
foreach ($restriction['values'] as $value) {
$arrOR[] = "? LIKE CONCAT(" . ($restriction['condition'] == 'ends' || $restriction['condition'] == 'contains' ? "'%', " : '') . "attributeValue" . ($restriction['condition'] == 'starts' || $restriction['condition'] == 'contains' ? ", '%'" : '') . ")";
$arrValues[] = $value;
}
$strRestriction .= '(' . implode(' OR ', $arrOR) . ')';
break;
default:
throw new \InvalidArgumentException('Unknown rule condition "' . $restriction['condition'] . '"');
}
$arrRestrictions[] = $strRestriction . ')';
}
$arrProcedures[] = '(' . implode(' OR ', $arrRestrictions) . ')';
}
$objResult = \Database::getInstance()->prepare("SELECT * FROM " . static::$strTable . " r WHERE " . implode(' AND ', $arrProcedures))->execute($arrValues);
if ($objResult->numRows) {
return \Model\Collection::createFromDbResult($objResult, static::$strTable);
}
return null;
}
/**
* Find published news categories by parent ID and IDs
*
* @param integer $intPid The parent ID
* @param array $arrIds An array of categories
*
* @return \Model|null The NewsModelCategpry or null if there are no categories
*/
public static function findPublishedByPidAndIds($intPid, $arrIds)
{
if (!is_array($arrIds) || empty($arrIds)) {
return null;
}
$objCategories = \Database::getInstance()->prepare("SELECT c1.*, (SELECT COUNT(*) FROM tl_news_category c2 WHERE c2.pid=c1.id AND c2.id IN (" . implode(',', array_map('intval', $arrIds)) . ")" . (!BE_USER_LOGGED_IN ? " AND c2.published=1" : "") . ") AS subcategories FROM tl_news_category c1 WHERE c1.pid=? AND c1.id IN (" . implode(',', array_map('intval', $arrIds)) . ")" . (!BE_USER_LOGGED_IN ? " AND c1.published=1" : "") . " ORDER BY c1.sorting")->execute($intPid);
if ($objCategories->numRows < 1) {
return null;
}
return \Model\Collection::createFromDbResult($objCategories, static::$strTable);
}
/**
* Find published news categories by parent ID and IDs
*
* @param integer $intPid The parent ID
* @param array $arrIds An array of categories
*
* @return \Model|null The NewsModelCategpry or null if there are no categories
*/
public static function findPublishedByPidAndIds($intPid, $arrIds)
{
if (!is_array($arrIds) || empty($arrIds)) {
return null;
}
$arrLanguageFields = \MultilingualQueryBuilder::getMultilingualFields(static::$strTable);
$strPid = \DC_Multilingual::getPidColumnForTable(static::$strTable);
$strLang = \DC_Multilingual::getLanguageColumnForTable(static::$strTable);
$objCategories = \Database::getInstance()->prepare("SELECT c1.*\n " . (!empty($arrLanguageFields) ? ", " . implode(", ", \MultilingualQueryBuilder::generateFieldsSubquery($arrLanguageFields, 'c1', 'dcm2')) : "") . "\n , (SELECT COUNT(*) FROM tl_news_category c2 WHERE c2.pid=c1.id AND c2.id IN (" . implode(',', array_map('intval', $arrIds)) . ")" . (!BE_USER_LOGGED_IN ? " AND c2.published=1" : "") . ") AS subcategories\n FROM tl_news_category c1\n " . (!empty($arrLanguageFields) ? " LEFT OUTER JOIN " . static::$strTable . " AS dcm2 ON (c1.id=dcm2." . $strPid . " AND dcm2.{$strLang}='" . $GLOBALS['TL_LANGUAGE'] . "')" : "") . "\n WHERE c1.pid=? AND c1." . $strPid . "=0 AND c1.id IN (" . implode(',', array_map('intval', $arrIds)) . ")" . (!BE_USER_LOGGED_IN ? " AND c1.published=1" : "") . " ORDER BY c1.sorting")->execute($intPid);
if ($objCategories->numRows < 1) {
return null;
}
return \Model\Collection::createFromDbResult($objCategories, static::$strTable);
}
