mFilter2 фильтрация из своей таблицы
Есть таблица modx_estate, создана модель и в принципе все поля из таблицы подтягиваются и tpl-ку выводятся
, но не могу фильтровать по полям своей таблицы. Подскажите как добавить в &filters например estate|totalArea (само собой totalArea имеется)) )
логи из showLog:
и вот:
, но не могу фильтровать по полям своей таблицы. Подскажите как добавить в &filters например estate|totalArea (само собой totalArea имеется)) )
[[!mFilter2?
.......
&loadModels=`estate`
&leftJoin=`{
"Estate": {
"class": "Estate",
"alias": "Estate",
"on": "Estate.idHouse = CAST(modResource.link_attributes AS UNSIGNED)"
}
}`
&select=`{
"modResource": "*",
"Estate": "*"
}`
&filters=`
estate|totalArea`
&showLog=`1`
]]
логи из showLog:
0.0000081: Loaded model «estate» from "/core/components/estate/model/"_______________________
0.0000260: pdoTools loaded.
0.0000050: Loaded model «estate» from "/core/components/estate/model/"
0.0000200: Query parameters are prepared.
0.0000131: xPDO query object created
0.0000789: leftJoined mseIntro as Intro
0.0000601: leftJoined Estate as Estate
0.0000021: Grouped by modResource.id, Intro.intro
0.0000660: Added selection of modResource: SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `alias_visible`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `content`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
0.0000591: Added selection of mseIntro: intro
0.0000670: Added selection of Estate: `id`, `idHouse`, `realtyType`, `fullAddress`, `unrestrictedFullAddress`, `geoLat`, `geoLon`, `title`, `description`, `videoLink`, `price`, `pricePerSquareMeter`, `settlementName`, `totalArea`, `flatRoomsCount`, `bedroomsCount`, `area`, `gasType`, `waterType`, `floorsCount`, `materialType`, `pmg`, `estate_phone`, `estate_shower`, `estate_bathhouse`
0.0000370: Processed additional conditions
0.0001211: Added where condition: modResource.id:IN(878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955), modResource.published=1, modResource.deleted=0
0.0000901: Sorted by FIELD(`modResource`.`id`,'878','879','880','881','882','883','884','885','886','887','888','889','890','891','892','893','894','895','896','897','898','899','900','901','902','903','904','905','906','907','908','909','910','911','912','913','914','915','916','917','918','919','920','921','922','923','924','925','926','927','928','929','930','931','932','933','934','935','936','937','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955'),
0.0000021: Limited to 4, offset 0
0.0002389: SQL prepared «SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`alias_visible`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`content`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, `intro`, `Estate`.`id`, `Estate`.`idHouse`, `Estate`.`realtyType`, `Estate`.`fullAddress`, `Estate`.`unrestrictedFullAddress`, `Estate`.`geoLat`, `Estate`.`geoLon`, `Estate`.`title`, `Estate`.`description`, `Estate`.`videoLink`, `Estate`.`price`, `Estate`.`pricePerSquareMeter`, `Estate`.`settlementName`, `Estate`.`totalArea`, `Estate`.`flatRoomsCount`, `Estate`.`bedroomsCount`, `Estate`.`area`, `Estate`.`gasType`, `Estate`.`waterType`, `Estate`.`floorsCount`, `Estate`.`materialType`, `Estate`.`pmg`, `Estate`.`estate_phone`, `Estate`.`estate_shower`, `Estate`.`estate_bathhouse` FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_mse2_intro` `Intro` ON modResource.id = Intro.resource LEFT JOIN `modx_estate` `Estate` ON Estate.idHouse = CAST(modResource.link_attributes AS UNSIGNED) WHERE ( `modResource`.`id` IN (878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955) AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 ) GROUP BY modResource.id, Intro.intro ORDER BY FIELD(`modResource`.`id`,'878','879','880','881','882','883','884','885','886','887','888','889','890','891','892','893','894','895','896','897','898','899','900','901','902','903','904','905','906','907','908','909','910','911','912','913','914','915','916','917','918','919','920','921','922','923','924','925','926','927','928','929','930','931','932','933','934','935','936','937','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955') LIMIT 4 „
0.0115759: SQL executed
0.0001459: Total rows: 78
0.0001001: Rows fetched
0.0000639: Returning raw data
0.0153978: Total time
8 388 608: Memory usage
и вот:
0.0000100: Loaded model “estate» from "/core/components/estate/model/"
0.0000348: pdoTools loaded.
0.0247140: Fetched ids for building filters: «878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955» from element «mSearch2»
0.0000062: Total number of results: 78
0.0000029: Getting filters for ids: «878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955»
0.0003941: Total number of filters: 0
0.0845029: Fired paginator: «pdoPage»
0.0000060: Filters retrieved
0.0000160: Total filter operations: 0
0.1122141: Total time
8 388 608: Memory usage
Комментарии: 3
Пробовал так?
&filters=`Estate|totalArea`
Да. Пробовал, как только не пробовал)))
Разобрался. Пишу вдруг еще кто такой же невнимательный как и я)))Вот: docs.modx.pro/components/msearch2/extension/filtration-methods таблицу добавил, а класс фильтрации не расширил.
Авторизуйтесь или зарегистрируйтесь, чтобы оставлять комментарии.