"count" => $count,
"lang_id" => _LANG,
"good_id" => $this->diafan->_route->show,
"images" => $images,
"images_variation" => $images_variation,
"access" => ($this->diafan->configmodules('where_access_element', 'shop') || $this->diafan->configmodules('where_access_cat', 'shop') ? $this->diafan->_users->role_id : 0),
"discounts" => $this->person_discount_ids,
"time" => ($this->diafan->configmodules('where_period_element', 'shop') ? $time : '')
);

if (! $this->result = $this->diafan->_cache->get($cache_meta, "shop"))
{
$this->result["rows"] = DB::query_range_fetch_all(
"SELECT e.id, e.[name], e.[anons], e.timeedit, e.site_id, e.brand_id, e.no_buy, e.article,"
." e.[measure_unit], e.hit, e.new, e.action, e.is_file FROM {shop} AS e"
." INNER JOIN {shop_rek} AS r ON e.id=r.rel_element_id AND r.element_id=%d"
.($this->diafan->configmodules("rel_two_sided") ? " OR e.id=r.element_id AND r.rel_element_id=".$this->diafan->_route->show : '')
.($this->diafan->configmodules('where_access_element', 'shop') ? " LEFT JOIN {access} AS a ON a.element_id=e.id AND a.module_name='shop' AND a.element_type='element'" : "")
.($this->diafan->configmodules('hide_missing_goods', 'shop') && $this->diafan->configmodules('use_count_goods', 'shop') ? " INNER JOIN {shop_price} AS prh ON prh.good_id=e.id AND prh.count_goods>0" : "")
." WHERE e.[act]='1' AND e.trash='0'"
.($this->diafan->configmodules('where_period_element', 'shop') ? " AND e.date_start<=".$time." AND (e.date_finish=0 OR e.date_finish>=".$time.")" : '')
.($this->diafan->configmodules('where_access_element', 'shop') ? " AND (e.access='0' OR e.access='1' AND a.role_id=".$this->diafan->_users->role_id.")" : '')
.($this->diafan->configmodules('hide_missing_goods', 'shop') ? " AND e.no_buy='0'" : "")
." GROUP BY e.id"
." ORDER BY e.id DESC",
$this->diafan->_route->show, 0, $count
);
$this->elements($this->result["rows"], 'block', array("count" => $images, "variation" => $images_variation));
$this->diafan->_cache->save($this->result, $cache_meta, "shop");
}
foreach ($this->result["rows"] as &$row)
{
$this->prepare_data_element($row);
}
foreach ($this->result["rows"] as &$row)
{
$this->format_data_element($row);
}

$this->result["view_rows"] = 'rows';
}

diafan_ajax.init({
data:{
action: 'delete_rek_element',
element_id : self.parents(".rek_element").attr("element_id"),
rel_id : self.parents(".rek_element").attr("rel_id"),
rel_two_sided: $("#rek_elements").attr("rel_two_sided")
},
success: function(response){
self.parents(".rek_element").remove();
}
});
return false;
});

{
$name = $this->diafan->variable_list("name", "variable");
}
else
{
$name = 'name';
}

echo '
<div class="unit" id="rek_elements" rek-two_sided="'.($rek_two_sided ? 'true' : '').'">
<div class="infofield">'.$this->diafan->variable_name().$this->diafan->help().'</div>
<div class="rek_elements">';
if ( ! $this->diafan->is_new)
{
$rows = DB::query_fetch_all("SELECT s.id, s.[".$name."], s.site_id FROM {".$this->diafan->table."} AS s"
." INNER JOIN {".$this->diafan->table."_rek} AS r ON s.id=r.rel_element_id AND r.element_id=%d"
.($rel_two_sided ? " OR s.id=r.element_id AND r.rel_element_id=".$this->diafan->id : "")
." WHERE s.trash='0' GROUP BY s.id",
$this->diafan->id
);
foreach ($rows as $row)
{
$link = $this->diafan->_route->link($row["site_id"], $row["id"], $this->diafan->table);
if($this->diafan->is_variable("images") || $this->diafan->is_variable("image"))
{
$row_img = DB::query_fetch_array("SELECT name, folder_num FROM {images} WHERE element_id=%d AND module_name='%s' AND element_type='element' AND trash='0' ORDER BY sort ASC LIMIT 1", $row["id"], $this->diafan->table);
}
echo '
<div class="rek_element" element_id="'.$this->diafan->id.'" rel_id="'.$row["id"].'">'
.(! empty($row_img) ? '<img src="'.BASE_PATH.USERFILES.'/small/'.($row_img["folder_num"] ? $row_img["folder_num"].'/' : '').$row_img["name"].'">' : '').$this->diafan->short_text($row[$name], 50)
.'
<div class="rek_element_actions">';
if($this->diafan->configmodules("page_show", $this->diafan->_admin->module, $this->diafan->_route->site))
{
echo '
<a href="'.BASE_PATH.$link.'" target="_blank"><i class="fa fa-laptop"></i> '.$this->diafan->_('Посмотреть на сайте').'</a>';
}
echo '
<a href="javascript:void(0)" confirm="'.$this->diafan->_('Вы действительно хотите удалить запись?').'" action="delete_rek_element" class="delete"><i class="fa fa-times-circle"></i> '.$this->diafan->_('Удалить').'</a>
</div>
</div>';
}
}
echo '</div>
<a href="javascript:void(0)" class="rek_module_plus btn btn_small btn_blue plink">
<i class="fa fa-plus-square"></i> '.$this->diafan->_('Добавить').'
</a>
</div>';
}

* @return void
*/

public function show_block_rek($attributes)
{
if ($this->diafan->_site->module != "shop" || ! $this->diafan->_route->show)
return false;

$this->diafan->attributes($attributes, 'count', 'images', 'images_variation', 'template');

$count = $attributes["count"] ? intval($attributes["count"]) : 3;
$images = intval($attributes["images"]);
$images_variation = $attributes["images_variation"] ? strval($attributes["images_variation"]) : 'medium';

$this->model->show_block_rek($count, $images, $images_variation);
$this->model->result();
$this->model->result["attributes"] = $attributes;

echo $this->diafan->_tpl->get('show_block_rek', 'shop', $this->model->result, $attributes["template"]);
}

$time = mktime(23, 59, 0, date("m"), date("d"), date("Y"));

//кеширование
$cache_meta = array(
"name" => "block_rek",
"count" => $count,
"lang_id" => _LANG,
"good_id" => $this->diafan->_route->show,
"images" => $images,
"images_variation" => $images_variation,
"access" => ($this->diafan->configmodules('where_access_element', 'shop') || $this->diafan->configmodules('where_access_cat', 'shop') ? $this->diafan->_users->role_id : 0),
"discounts" => $this->person_discount_ids,
"time" => ($this->diafan->configmodules('where_period_element', 'shop') ? $time : '')
);

if (! $this->result = $this->diafan->_cache->get($cache_meta, "shop"))
{
$this->result["rows"] = DB::query_range_fetch_all(
"SELECT e.id, e.[name], e.[anons], e.timeedit, e.site_id, e.brand_id, e.no_buy, e.article,"
." e.[measure_unit], e.hit, e.new, e.action, e.is_file FROM {shop} AS e"
." INNER JOIN {shop_rek} AS r ON e.id=r.rel_element_id AND r.element_id=%d"
.($this->diafan->configmodules("rel_two_sided") ? " OR e.id=r.element_id AND r.rel_element_id=".$this->diafan->_route->show : '')
.($this->diafan->configmodules('where_access_element', 'shop') ? " LEFT JOIN {access} AS a ON a.element_id=e.id AND a.module_name='shop' AND a.element_type='element'" : "")
.($this->diafan->configmodules('hide_missing_goods', 'shop') && $this->diafan->configmodules('use_count_goods', 'shop') ? " INNER JOIN {shop_price} AS prh ON prh.good_id=e.id AND prh.count_goods>0" : "")
." WHERE e.[act]='1' AND e.trash='0'"
.($this->diafan->configmodules('where_period_element', 'shop') ? " AND e.date_start<=".$time." AND (e.date_finish=0 OR e.date_finish>=".$time.")" : '')
.($this->diafan->configmodules('where_access_element', 'shop') ? " AND (e.access='0' OR e.access='1' AND a.role_id=".$this->diafan->_users->role_id.")" : '')
.($this->diafan->configmodules('hide_missing_goods', 'shop') ? " AND e.no_buy='0'" : "")
." GROUP BY e.id"
." ORDER BY e.id DESC",
$this->diafan->_route->show, 0, $count
);
$this->elements($this->result["rows"], 'block', array("count" => $images, "variation" => $images_variation));
$this->diafan->_cache->save($this->result, $cache_meta, "shop");
}
foreach ($this->result["rows"] as &$row)
{
$this->prepare_data_element($row);
}
foreach ($this->result["rows"] as &$row)
{
$this->format_data_element($row);
}

$this->result["view_rows"] = 'rows';
}

diafan_ajax.init({
data:{
action: 'delete_rek_element',
element_id : self.parents(".rek_element").attr("element_id"),
rel_id : self.parents(".rek_element").attr("rel_id"),
rel_two_sided: $("#rek_elements").attr("rel_two_sided")
},
success: function(response){
self.parents(".rek_element").remove();
}
});
return false;
});

{
$name = $this->diafan->variable_list("name", "variable");
}
else
{
$name = 'name';
}

echo '
<div class="unit" id="rek_elements" rek-two_sided="'.($rek_two_sided ? 'true' : '').'">
<div class="infofield">'.$this->diafan->variable_name().$this->diafan->help().'</div>
<div class="rek_elements">';
if ( ! $this->diafan->is_new)
{
$rows = DB::query_fetch_all("SELECT s.id, s.[".$name."], s.site_id FROM {".$this->diafan->table."} AS s"
." INNER JOIN {".$this->diafan->table."_rek} AS r ON s.id=r.rel_element_id AND r.element_id=%d"
.($rel_two_sided ? " OR s.id=r.element_id AND r.rel_element_id=".$this->diafan->id : "")
." WHERE s.trash='0' GROUP BY s.id",
$this->diafan->id
);
foreach ($rows as $row)
{
$link = $this->diafan->_route->link($row["site_id"], $row["id"], $this->diafan->table);
if($this->diafan->is_variable("images") || $this->diafan->is_variable("image"))
{
$row_img = DB::query_fetch_array("SELECT name, folder_num FROM {images} WHERE element_id=%d AND module_name='%s' AND element_type='element' AND trash='0' ORDER BY sort ASC LIMIT 1", $row["id"], $this->diafan->table);
}
echo '
<div class="rek_element" element_id="'.$this->diafan->id.'" rel_id="'.$row["id"].'">'
.(! empty($row_img) ? '<img src="'.BASE_PATH.USERFILES.'/small/'.($row_img["folder_num"] ? $row_img["folder_num"].'/' : '').$row_img["name"].'">' : '').$this->diafan->short_text($row[$name], 50)
.'
<div class="rek_element_actions">';
if($this->diafan->configmodules("page_show", $this->diafan->_admin->module, $this->diafan->_route->site))
{
echo '
<a href="'.BASE_PATH.$link.'" target="_blank"><i class="fa fa-laptop"></i> '.$this->diafan->_('Посмотреть на сайте').'</a>';
}
echo '
<a href="javascript:void(0)" confirm="'.$this->diafan->_('Вы действительно хотите удалить запись?').'" action="delete_rek_element" class="delete"><i class="fa fa-times-circle"></i> '.$this->diafan->_('Удалить').'</a>
</div>
</div>';
}
}
echo '</div>
<a href="javascript:void(0)" class="rek_module_plus btn btn_small btn_blue plink">
<i class="fa fa-plus-square"></i> '.$this->diafan->_('Добавить').'
</a>
</div>';
}

* @return void
*/
public function show_block_rek($attributes)
{
if ($this->diafan->_site->module != "shop" || ! $this->diafan->_route->show)
return false;

$this->diafan->attributes($attributes, 'count', 'images', 'images_variation', 'template');

$count = $attributes["count"] ? intval($attributes["count"]) : 3;
$images = intval($attributes["images"]);
$images_variation = $attributes["images_variation"] ? strval($attributes["images_variation"]) : 'medium';

$this->model->show_block_rek($count, $images, $images_variation);
$this->model->result();
$this->model->result["attributes"] = $attributes;

echo $this->diafan->_tpl->get('show_block_rek', 'shop', $this->model->result, $attributes["template"]);
}