| 1 |
2.46 ms |
Request:
{"index":"dev_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_08d2beb617754d2e9b8813e67fbd3a10":{"gte":30}}}]}},{"term":{"categoryTree":"261060987c2b427bbd42b1323790d094"}},{"exists":{"field":"displayGroup"}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":32,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 0,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "dev_product_1762781623",
"_id": "1ccef547ae784977b589a7460c5bb50e",
"_score": null,
"_source": {
"purchasePrices": [
{
"currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
"gross": 0.0,
"net": 0.0,
"linked": true
}
],
"referenceUnit": null,
"purchaseUnit": null,
"unit": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"shortCode": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"crossSellings": [
{
"id": "088dde984b274fcc9b5f2d2b768745c5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00c4hnliche Artikel"
}
},
{
"id": "8a05a3af20d84f7c81b310db1a6a87db",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das k\u00f6nnte Sie auch interessieren"
}
}
],
"keywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Votronic, 11250, Solar Computer, LCD, LCD-Solar Computer, SR, MPP, Boots-Ausf\u00fchrung, Solar, Solarpaneel, Solarpanel, Solarenergie, LCD-Solar Computer S, votronic solar computer, votronic solar computer bluetooth, solar computer votronic, ",
"5059dc45b5104c368cc2a7f890b80123": "Votronic, 11250, solar computer, LCD, LCD solar computer, SR, MPP, boat version, solar, solar panel, solar panel, solar energy, LCD-Solar Computer S"
},
"packUnit": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck",
"5059dc45b5104c368cc2a7f890b80123": "Piece"
},
"packUnitPlural": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"id": "1ccef547ae784977b589a7460c5bb50e",
"autoIncrement": 4801.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "08d2beb617754d2e9b8813e67fbd3a10"
}
],
"availableStock": 5,
"productNumber": "LCD-SOLAR-COMPUTER",
"ean": null,
"displayGroup": "18ffd59cf3069af0e292d60da9186d2b",
"sales": 0,
"stock": 5,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "1843652dadb745df81d87fa1d5b929a7",
"manufacturerNumber": null,
"deliveryTimeId": null,
"releaseDate": null,
"createdAt": "2020-09-10T00:00:00+00:00",
"categoryTree": [
"e95720b66e054265932a3d4f1d75ea24",
"f5748d2faf1a4e9a8a9c6303ce81181d",
"5762d80d06c947ae8a84d0d989483972",
"574c8f322c8045ff901f4585c15cdcfb",
"86699840fae64a0fa47ff448d7ba6858",
"261060987c2b427bbd42b1323790d094",
"34660def41584107bb4330b4444500ea",
"3b9afb12aaec4d89a3ec12b6118b7db9"
],
"categoriesRo": [
{
"id": "e95720b66e054265932a3d4f1d75ea24",
"_count": 1
},
{
"id": "f5748d2faf1a4e9a8a9c6303ce81181d",
"_count": 1
},
{
"id": "5762d80d06c947ae8a84d0d989483972",
"_count": 1
},
{
"id": "574c8f322c8045ff901f4585c15cdcfb",
"_count": 1
},
{
"id": "86699840fae64a0fa47ff448d7ba6858",
"_count": 1
},
{
"id": "261060987c2b427bbd42b1323790d094",
"_count": 1
},
{
"id": "34660def41584107bb4330b4444500ea",
"_count": 1
},
{
"id": "3b9afb12aaec4d89a3ec12b6118b7db9",
"_count": 1
}
],
"taxId": "d97cf5cff5d945aa8624948165e25887",
"tags": [
{
"id": "01917f485cef7a409544dca6df2593fc",
"name": "Verkaufsartikel",
"_count": 1
}
],
"parentId": null,
"coverId": "0c27d3951f474c8cbab8a0d1b70678c1",
"childCount": 0,
"categories": [
{
"id": "261060987c2b427bbd42b1323790d094",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Instrumente",
"5059dc45b5104c368cc2a7f890b80123": "Devices"
}
},
{
"id": "34660def41584107bb4330b4444500ea",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Solartechnik",
"5059dc45b5104c368cc2a7f890b80123": "Solar Technology"
}
},
{
"id": "3b9afb12aaec4d89a3ec12b6118b7db9",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Solar Equipment",
"5059dc45b5104c368cc2a7f890b80123": "Solar Equipment"
}
}
],
"manufacturer": {
"id": "1843652dadb745df81d87fa1d5b929a7",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nakatanenga",
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"deliveryTime": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"properties": [
{
"id": "018b0fe0fc6477c1a60d06b620425a45",
"_count": 1,
"groupId": "018b0fdad83d709a90b6f61727e1b6c3",
"group": {
"id": "018b0fdad83d709a90b6f61727e1b6c3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Instrumente",
"5059dc45b5104c368cc2a7f890b80123": " Instruments"
}
},
{
"id": "018b5cac90d074d9b2d79dbddb3effc2",
"_count": 1,
"groupId": "018b5cac38e076e582b66fbf8a13d608",
"group": {
"id": "018b5cac38e076e582b66fbf8a13d608",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Solar"
}
}
],
"options": [],
"categoryIds": [
"261060987c2b427bbd42b1323790d094",
"34660def41584107bb4330b4444500ea",
"3b9afb12aaec4d89a3ec12b6118b7db9"
],
"optionIds": [],
"propertyIds": [
"018b0fe0fc6477c1a60d06b620425a45",
"018b5cac90d074d9b2d79dbddb3effc2"
],
"tagIds": [
"01917f485cef7a409544dca6df2593fc"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_MigrationSW501092023V_product_attr6": false,
"migration_MigrationSW501092023V_product_attr7": true,
"migration_MigrationSW501092023V_product_attr8": false,
"migration_MigrationSW501092023V_product_attr13": "'0'",
"migration_MigrationSW501092023V_product_attr14": false,
"migration_MigrationSW501092023V_product_attr15": false,
"migration_MigrationSW501092023V_product_attr16": true,
"migration_MigrationSW501092023V_product_attr19": false,
"migration_MigrationSW501092023V_product_icue_pseudoprice": 0.0,
"migration_MigrationSW501092023V_product_icue_min_order_exception": false,
"migration_MigrationSW501092023V_product_pixel_is_configurator": false,
"migration_MigrationSW501092023V_product_pixel_is_confianfrage": false,
"migration_MigrationSW501092023V_product_deposit": 0.0,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden": false,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden_seo": false,
"twt_electric_pro_custom_field__product__custom_tab_text": "<ul class=\"content--list list--unstyled\"><li class=\"list--entry\"><a href=\"\/media\/a5\/cf\/78\/1693556916\/bedienungsanleitung-lcd-solar-computer.pdf\" target=_blank\" rel=\"noopener\"> Bedienungsanleitung<\/a><\/li><\/ul>"
},
"5059dc45b5104c368cc2a7f890b80123": {
"migration_MigrationSW501092023V_product_attr16": true
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Votronic LCD Solar Computer",
"5059dc45b5104c368cc2a7f890b80123": "Votronic LCD Solar Computer"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Votronic LCD Solar Computer\nFolgende Werte werden mikroprozessgesteuert berechnet und angezeigt:\n - Aktuelle Solarleistung 0 - 999 W (Watt) - Aktueller Solarstrom 0 - 60,0 A (Ampere) - Die geografischen und wetterabhängigen Einflüsse zeigen sich sofort und unverkennbar. Dies gilt auch für die Sonnenausrichtung, Teilbeschattung oder Verschmutzung der Solar-Module. - Aktuelle Solarbatteriespannung 7 - 32,0 V (Volt) Erlaubt Rückschlüsse auf den Batteriezustand (blinkende Warnanzeige bie Unter- oder Überspannung der Batterie) - Eingeladene Solarkapazität 0 - 9999 Ah (Amperestunden) - Eingeladene Solarenergie 0 - 9999 kWh (Kilowattstunden) Die von den Solar-Modulen erzeugte Energie (Wh und kWh) und die in die Batterie eingeladene Kapazität (Ah) werden gemessen, aufaddiert und angezeigt, auch über Tage und Wochen hinweg. Die Anzeigewerte können jederzeit für eigene Statistikzwecke einzeln auf \"Null\" zurück gesetzt werden:\nSind die Solar-Module beschattet oder verschmutzt oder stimmt etwas nicht? Wie viel Energie liefert meine Solaranlage eigentlich? Um diese Fragen beantworten zu können bietet VOTRONIC den LCD-Solar-Computer S an, der einfach an den VOTRONIC Solar-Laderegler der Serien SR und MPP angeschlossen wird und sofort umfassend die gewünschten Informationen liefert.\nEs ist möglich den LCD-Solar-Computer S auch nachträglich am Regler anzuschließen, da die VOTRONIC Solar-Laderegler bereitssteckerfertig dafür vorbereitet sind und die benötigten Signale liefern. Der Anschluss ist somit äußerst einfach gehalten.\nÜbersichtlich und per Tastendruck leicht bedienbar werden die Messwerte zur besseren Kontrolle und Nutzung der Solar-Anlageauf dem Display dargestellt. Die Anzeige ist hinterleuchtet (schaltbar) und auch aus größeren Entfernungen sowie bei allen Lichtverhältnissen sehr gut ablesbar.\nPassend zum VOTRONIC Modulsystem ist der LCD-Solar-Computer S als Panel-Version ausgeführt und reiht sich sowohl optisch alsauch mechanisch (einheitliche Höhe 85 mm) an die übrigen Anzeigemodule an. Geringe Frontplattenmaße und die besonders geringeEinbautiefe von nur 22 mm erlaubt die Montage an nahezu jeder Stelle. Sollte das Gerät nicht versenkt eingebaut werden, steht ein entsprechendes Aufbaugehäuse in unserem Zubehörprogramm zur Verfügung. Der Anschluss zum Solar-Regler erfolgt steckerfertig durch das mitgelieferte 5 m lange Anschlusskabel, das über eine Verlängerung um weiter 5 m erweitert werden kann.\nTechnische Daten:\n Batterie-Nennspannung (DC) in [V]: 12 und 24Stromaufnahme max. in [mA]: 3 - 30Anzeige: LC Display mit spezifischen SegmentenAnzeige-Funktion: W, A, V, Ah, WhMessbereich: 20 - 990Maße (BxHxT) in [mm]: 80 x 85 x 25Einbaumaße (BxHxT) in [mm]: 66 x 72 x 22Gewicht in [g]: 55Prüfzeichen: CE, E-Prüfung (EMV\/Kfz-Richtlinie)\nUmgebungsbedingungen, Luftfeuchtigkeit: max. 95% Raumfeuchte, nicht kondensierend\nLieferumfang: 5 m Anschlusskabel, Befestigungsschrauben, Bedienungsanleitung, Bohrschablone",
"5059dc45b5104c368cc2a7f890b80123": "The following values \u200b\u200bare calculated and displayed under microprocessor control:\n- Current solar power 0 - 999 W (watt) - Current solar power 0 - 60.0 A (ampere) - The geographic and weather-dependent influences show up immediately and unmistakably.\u00a0This also applies to the orientation of the sun, partial shading or soiling of the solar modules. - Current solar battery voltage 7 - 32.0 V (volts) Allows conclusions to be drawn about the battery status (flashing warning display at under or Overvoltage of the battery) - Invited solar capacity 0 - 9999 Ah (ampere hours) - Invited solar energy 0 - 9999 kWh (kilowatt hours)\nThe energy generated by the solar modules (Wh and kWh) and that charged into the battery Capacity (Ah) are measured, added up and displayed, even over days and weeks. The display values \u200b\u200bcan be individually reset to \"zero\" at any time for your own statistical purposes:\nAre the solar modules shaded or dirty or is something wrong? How much energy does my solar system actually deliver?In order to be able to answer these questions, VOTRONIC offers the LCD solar computer S, which is simply connected to the VOTRONIC solar charge controller of the SR and MPP series and immediately provides the required information.\nIt is also possible to connect the LCD solar computer S to the controller at a later date, since the VOTRONIC solar charge controller already has\u00a0are ready to plug in and provide the required signals. The connection is therefore kept extremely simple.\nThe measured values \u200b\u200bare clear and easy to use at the push of a button for better control and use of the solar system\u00a0shown on the display. The display is backlit (switchable) and also from greater distances and\u00a0very easy to read under lighting conditions.\nThe LCD solar computer S is designed as a panel version to match the VOTRONIC module system and is both optically and\u00a0also mechanically (uniform height 85 mm) to the other display modules. Small front panel dimensions and the particularly small\u00a0installation depth of just 22 mm allows installation at almost any point. If the device is not installed countersunk, stands\u00a0a corresponding add-on housing is available in our range of accessories. The connection to the solar controller is ready to plug in\u00a0with the supplied 5 m long connection cable, which can be extended by a further 5 m.\nTechnical specifications:\nNominal battery voltage (DC) in [V] 12 and 24 Current consumption max. in [mA] 3 - 30 LC display with specific segments Display function W, A, V, Ah, Wh Measuring range 20 - 990 Dimensions (WxHxD) in [mm] 80 x 85 x 25 Installation dimensions (WxHxD) in [mm] 66 x 72 x 22 Weight in [g] 55 Approval marks CE, E-approval (EMC \/ vehicle directive)\nAmbient conditions, humidity: max. 95% room humidity, non-condensing Scope of delivery: 5 m connection cable, fastening screws, operating instructions, drilling template"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u25b7 Votronic LCD-Solar Computer - hier erh\u00e4ltlich!",
"5059dc45b5104c368cc2a7f890b80123": "\u25b7 Votronic LCD solar computer - available here!"
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u21aa\ufe0f passend f\u00fcr den Solar-Laderegler der Serie SR und MPP \u2714\ufe0f mit Feuchtigkeitsschutz \u2714\ufe0f Informationen \u00fcber die Energie der Solaranlage \u2714\ufe0f schneller Versand",
"5059dc45b5104c368cc2a7f890b80123": "\u21aa\ufe0f Suitable for solar charge controller of the SR and MPP series \u2714\ufe0f with moisture protection \u2714\ufe0f provides information about the energy of the solar system"
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
"Votronic",
"11250",
"Solar Computer",
"LCD",
"LCD-Solar Computer",
"SR",
"MPP",
"Boots-Ausf\u00fchrung",
"Solar",
"Solarpaneel",
"Solarpanel",
"Solarenergie",
"LCD-Solar Computer S",
"votronic solar computer",
"votronic solar computer bluetooth",
"solar computer votronic"
],
"5059dc45b5104c368cc2a7f890b80123": [
"Votronic",
"11250",
"solar computer",
"LCD",
"LCD solar computer",
"SR",
"MPP",
"boat version",
"solar",
"solar panel",
"solar panel",
"solar energy",
"LCD-Solar Computer S"
]
},
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 115.0,
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 96.6387,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 103.5,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 86.9748,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 109.25,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 91.8067,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 115.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 96.6387,
"visibility_08d2beb617754d2e9b8813e67fbd3a10": 30,
"warehouseGroupStockField": {
"warehouse_group_stock": null,
"parent_warehouse_group_stock": null
},
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
{
"key": "all",
"value": "lcd-solar-computer"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "votronic"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "lcd"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "solar"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "computer"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "lcd-solar"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "hier"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "erh\u00e4ltlich!"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "votronic lcd solar computer"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "\u25b7 votronic lcd-solar computer - hier erh\u00e4ltlich!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "votronic"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "lcd"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "solar"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "computer"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "available"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "here!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "votronic lcd solar computer"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "\u25b7 votronic lcd solar computer - available here!"
}
]
},
"fields": {
"displayGroup": [
"18ffd59cf3069af0e292d60da9186d2b"
]
},
"sort": [
0,
"1ccef547ae784977b589a7460c5bb50e"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.23 ms |
Request:
{"index":"dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_08d2beb617754d2e9b8813e67fbd3a10":{"gte":30}}}]}},{"term":{"categoryTree":"261060987c2b427bbd42b1323790d094"}},{"exists":{"field":"displayGroup"}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule76a1b37a7dbf4165b46c7ab2ff1a4841_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule56b8897938be44a48f5d23076fee8aa4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b5053d723cbcc2ffca7e2f1d37_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b50593737ca9f4a6695a28df19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b505a971d6b33bc2b7f77ff188_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b50779728dbd34b221819dbf1f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b5077e722793b82b3113582988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019266bd95457bad916f0e7402a76e90_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule89396462b19442de853b499f33b78cef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule8a3d72aab5a5468fa089505163f644f9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef9da93f84ada4ccd8efd95692a615991_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule06c3e6c40cde40fb88ada175db3b7938_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed59dd72ecb5248c3701a4a9a7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5a33735dadfaae7d48ee3774_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5a7373caa742a3ca2b474faa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5abc7260ba0d7f86a5f49012_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5ae473cc8acbdbd09e697f1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5afd73938316ce5d62b21885_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b3472fb8689bff52c36d24e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b47710cbb88d4cabe575530_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b657021952452aa52c2f262_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b887386bf07cbfb0c6dc4d9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5bb77063b42436de2bb2654d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5be971dfb78ef0b9ab954636_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c0f732b83a6fa611b17c9b0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c1c72e1bd5dd45fa91ae988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c48709db0bb1d772acb893a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c61739288a8f19f5fee5c9f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c83710a9f725ed88fa40977_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5cb47127996aaac8a7f6bdbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5ce97102b94464fe862ca787_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5d78715b957280e0dd517331_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5e047192aaa473cfc729c45f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5e987014b27850d1f01683cb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5eb972a9811e6559447a6fdc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5f01707fbf3a6adca420f5b1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5f4a728eb343c4ceca55df24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5fc1716ab9e26008508a989e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed601171ca8bcbf7c4e4b15d12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed604073a8a7cc7283597bc561_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6086727a8ed87d86b79ab028_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed60bb7173b3c5caa2b21a03e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed611b719b8c493426397e071b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed616973d6ae87df29ca6fab45_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed617970548b9ab2028aaccee3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed61d27021a6d3f256f1fe6301_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6233707282cee72b0a78165c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed629f739f81ef49fbfd3175b8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed630d72bfb80b0b616e56f094_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed632870c88f4d50e0091bdc8d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6337724eaaf100fe723a9c73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63797281ae1e4a20fee27b7e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63a670b0b0b52d88b864e4db_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63dc70b69dd94cbfea630307_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63ff71859ac60b2064da4af9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://localhost:9200/dev_product/_search?track_total_hits=0&search_type=query_then_fetch
Accept: application/json
Content-Type: application/json
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"must": [
{
"term": {
"active": true
}
},
{
"range": {
"visibility_08d2beb617754d2e9b8813e67fbd3a10": {
"gte": 30
}
}
}
]
}
},
{
"term": {
"categoryTree": "261060987c2b427bbd42b1323790d094"
}
},
{
"exists": {
"field": "displayGroup"
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must": [
{
"term": {
"isCloseout": true
}
},
{
"term": {
"available": false
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"script": {
"source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n",
"lang": "painless",
"params": {
"accessors": [
{
"key": "cheapest_price_rule76a1b37a7dbf4165b46c7ab2ff1a4841_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule56b8897938be44a48f5d23076fee8aa4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b5053d723cbcc2ffca7e2f1d37_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b50593737ca9f4a6695a28df19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b505a971d6b33bc2b7f77ff188_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b50779728dbd34b221819dbf1f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b5077e722793b82b3113582988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019266bd95457bad916f0e7402a76e90_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule89396462b19442de853b499f33b78cef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule8a3d72aab5a5468fa089505163f644f9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulef9da93f84ada4ccd8efd95692a615991_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule06c3e6c40cde40fb88ada175db3b7938_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed59dd72ecb5248c3701a4a9a7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5a33735dadfaae7d48ee3774_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5a7373caa742a3ca2b474faa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5abc7260ba0d7f86a5f49012_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5ae473cc8acbdbd09e697f1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5afd73938316ce5d62b21885_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b3472fb8689bff52c36d24e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b47710cbb88d4cabe575530_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b657021952452aa52c2f262_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b887386bf07cbfb0c6dc4d9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5bb77063b42436de2bb2654d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5be971dfb78ef0b9ab954636_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c0f732b83a6fa611b17c9b0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c1c72e1bd5dd45fa91ae988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c48709db0bb1d772acb893a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c61739288a8f19f5fee5c9f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c83710a9f725ed88fa40977_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5cb47127996aaac8a7f6bdbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5ce97102b94464fe862ca787_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5d78715b957280e0dd517331_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5e047192aaa473cfc729c45f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5e987014b27850d1f01683cb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5eb972a9811e6559447a6fdc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5f01707fbf3a6adca420f5b1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5f4a728eb343c4ceca55df24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5fc1716ab9e26008508a989e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed601171ca8bcbf7c4e4b15d12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed604073a8a7cc7283597bc561_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6086727a8ed87d86b79ab028_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed60bb7173b3c5caa2b21a03e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed611b719b8c493426397e071b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed616973d6ae87df29ca6fab45_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed617970548b9ab2028aaccee3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed61d27021a6d3f256f1fe6301_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6233707282cee72b0a78165c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed629f739f81ef49fbfd3175b8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed630d72bfb80b0b616e56f094_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed632870c88f4d50e0091bdc8d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6337724eaaf100fe723a9c73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63797281ae1e4a20fee27b7e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63a670b0b0b52d88b864e4db_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63dc70b69dd94cbfea630307_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63ff71859ac60b2064da4af9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"rating-exists": {
"filter": {
"range": {
"ratingAverage": {
"gte": 0.0
}
}
},
"aggregations": {
"rating": {
"max": {
"field": "ratingAverage"
}
}
}
},
"shipping-free-filter": {
"filter": {
"term": {
"shippingFree": true
}
},
"aggregations": {
"shipping-free": {
"max": {
"field": "shippingFree"
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|