Mishiko

CREATE TABLE `mdx2w_ms2_options` (
  `id` int(10) UNSIGNED NOT NULL,
  `key` varchar(255) NOT NULL DEFAULT '',
  `caption` varchar(255) NOT NULL DEFAULT '',
  `description` text,
  `measure_unit` tinytext,
  `category` int(10) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT '',
  `properties` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `mdx2w_ms2_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `key` (`type`),
  ADD KEY `category` (`category`);
ALTER TABLE `mdx2w_ms2_options` ADD FULLTEXT KEY `caption_ft` (`caption`);

ALTER TABLE `mdx2w_ms2_options`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

[[!pdoResources?
                &parents=`[[*id]]`
            	&sortby=`{"menuindex":"ASC"}`
            	&where=`{"class_key": "msCategory"}`
                &depth=`0`
            	&limit=`0`
                &tpl=`catRowTpl`
                &includeTVs=`general_image`
            ]]

<div class="col-md-3 col-sm-6">
    <div class="item">
        <div class="image"><a href="[[~[[+id]]]]"><img src="[[+tv.general_image:default=`assets/template/images/notimg.png`]]" alt="[[+pagetitle]]" /></a></div>
        <a href="[[~[[+id]]]]" class="clink">[[+pagetitle]]</a>
        <ul>
		[[pdoMenu?
            &parents=`[[*id]]`
           &where=`{"class_key": "msCategory"}`
            &level=`1`
            &tpl=`LicatRowTpl`
        ]]      
        </ul>
    </div>
</div>

<li><a href="[[~[[+id]]]]" class="clink">[[+pagetitle]]</a></li>

{if $general_image?}
<a href="{$id | url}">
    <img src="/assets/uploads/{$general_image}" alt="{$pagetitle}" title="{$pagetitle}" style=" width: 145px; " /></a>
{else}
<img src="{'assets_url' | option}images/uploads/wm_1.png" alt="{$pagetitle}" title="{$pagetitle}" style=" width: 145px; " /> 
{/if}

Array ( [id] => 84 [type] => document [contentType] => text/html [pagetitle] => Блок розжига Al Bosch 2.0 D1-D2 [longtitle] => Блок розжига Al Bosch 2.0 D1-D2 [description] => Блок розжига Al Bosch 2.0 D1-D2, применяется для ксеноновых ламп ближнего/дальнего света D2S, D2R, D1S, D1R в автомобили производства Mercedes-Benz, Mazda, Audi, BMW, напряжение 12V, мощность 35W, диапазон рабочих температур -40°С до +105°С [alias] => blok-rozzhiga-al-bosch-2-0-d1-d2 [link_attributes] => [published] => 1 [pub_date] => 0 [unpub_date] => 0 [parent] => 83 [isfolder] => 0 [introtext] => Блок розжига Al Bosch 2.0 D1-D2, применяется для ксеноновых ламп ближнего/дальнего света D2S, D2R, D1S, D1R в автомобили производства Mercedes-Benz, Mazda, Audi, BMW, напряжение 12V, мощность 35W, диапазон рабочих температур -40°С до +105°С [richtext] => 1 [template] => 21 [menuindex] => 0 [searchable] => 1 [cacheable] => 1 [createdby] => 1 [createdon] => 1414233202 [editedby] => 3 [editedon] => 1540682793 [deleted] => 0 [deletedon] => 0 [deletedby] => 0 [publishedon] => 0 [publishedby] => 0 [menutitle] => [donthit] => 0 [privateweb] => 0 [privatemgr] => 0 [content_dispo] => 0 [hidemenu] => 0 [class_key] => msProduct [context_key] => web [content_type] => 1 [uri] => katalog/osveshhenie/ksenon/shtatnyie-bloki-rozzhiga/blok-rozzhiga-al-bosch-2-0-d1-d2.html [uri_override] => 0 [hide_children_in_tree] => 0 [show_in_tree] => 1 [properties] => [article] => 1057 [price] => 9 052 [old_price] => 0 [weight] => 0 [image] => [thumb] => [vendor] => 0 [made_in] => [new] => 0 [popular] => 1 [favorite] => 0 [tags] => [color] => [size] => [source] => 2 [vendor.name] => [vendor.resource] => [vendor.country] => [vendor.logo] => [vendor.address] => [vendor.phone] => [vendor.fax] => [vendor.email] => [vendor.description] => [vendor.properties] => [general_image] => images/Освещение/Ксенон/Штатные блоки розжига/1057.jpg [idx] => 1 [sale_discount] => 378 [remains] => 234148 ) Array ( [id] => 86 [type] => document [contentType] => text/html [pagetitle] => Биксеноновые линзы Silver Star G5 P25 [longtitle] => [description] => Биксеноновая линза SVS G5 P25, доступные типы цоколя: H1, H7, HB3, HB4, H4, температура свечения 6000К, L=110mm, D=90mm, срок службы 3000H, напряжение 12V, мощность 35W. [alias] => biksenonovyie-linzyi-silver-star-g5-p25 [link_attributes] => [published] => 1 [pub_date] => 0 [unpub_date] => 0 [parent] => 85 [isfolder] => 0 [introtext] => [richtext] => 1 [template] => 21 [menuindex] => 0 [searchable] => 1 [cacheable] => 1 [createdby] => 1 [createdon] => 1414233525 [editedby] => 1 [editedon] => 1524659004 [deleted] => 0 [deletedon] => 0 [deletedby] => 0 [publishedon] => 1414233480 [publishedby] => 1 [menutitle] => [donthit] => 0 [privateweb] => 0 [privatemgr] => 0 [content_dispo] => 0 [hidemenu] => 0 [class_key] => msProduct [context_key] => web [content_type] => 1 [uri] => katalog/osveshhenie/ksenon/biksenonovyie-linzyi/biksenonovyie-linzyi-silver-star-g5-p25.html [uri_override] => 0 [hide_children_in_tree] => 0 [show_in_tree] => 1 [properties] => [article] => [price] => 3 300 [old_price] => 0 [weight] => 0 [image] => [thumb] => [vendor] => 0 [made_in] => [new] => 0 [popular] => 0 [favorite] => 0 [tags] => [color] => [size] => [source] => 2 [vendor.name] => [vendor.resource] => [vendor.country] => [vendor.logo] => [vendor.address] => [vendor.phone] => [vendor.fax] => [vendor.email] => [vendor.description] => [vendor.properties] => [general_image] => images/Освещение/Ксенон/Биксеноновые линзы/Биксеноновые линзы SVS G5 6000K P25 .jpg [idx] => 2 [sale_discount] => 378 [remains] => 234148 )