{"type":"rich","version":"1.0","provider_name":"phorkie","provider_url":"https:\/\/p.cweiske.de\/","title":"typo3 extbase fetch correct media image for translated pages","author_name":"Christian Weiske","cache_age":86400,"width":900,"height":900,"html":"<!-- embedding all files of https:\/\/p.cweiske.de\/531 -->\n<link rel=\"stylesheet\" href=\"https:\/\/p.cweiske.de\/css\/embed.css\"\/>\n<div class=\"phork\" id=\"531\">\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2014 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.php .de1, .php .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.php  {font-family:monospace;}\n.php .imp {font-weight: bold; color: red;}\n.php li, .php .li1 {color: #DDD;}\n.php .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.php .kw1 {color: #b1b100;}\n.php .kw2 {color: #000000; font-weight: bold;}\n.php .kw3 {color: #990000;}\n.php .kw4 {color: #009900; font-weight: bold;}\n.php .co1 {color: #666666; font-style: italic;}\n.php .co2 {color: #666666; font-style: italic;}\n.php .co3 {color: #0000cc; font-style: italic;}\n.php .co4 {color: #009933; font-style: italic;}\n.php .coMULTI {color: #666666; font-style: italic;}\n.php .es0 {color: #000099; font-weight: bold;}\n.php .es1 {color: #000099; font-weight: bold;}\n.php .es2 {color: #660099; font-weight: bold;}\n.php .es3 {color: #660099; font-weight: bold;}\n.php .es4 {color: #006699; font-weight: bold;}\n.php .es5 {color: #006699; font-weight: bold; font-style: italic;}\n.php .es6 {color: #009933; font-weight: bold;}\n.php .es_h {color: #000099; font-weight: bold;}\n.php .br0 {color: #009900;}\n.php .sy0 {color: #339933;}\n.php .sy1 {color: #000000; font-weight: bold;}\n.php .st0 {color: #0000ff;}\n.php .st_h {color: #0000ff;}\n.php .nu0 {color: #cc66cc;}\n.php .nu8 {color: #208080;}\n.php .nu12 {color: #208080;}\n.php .nu19 {color:#800080;}\n.php .me1 {color: #004000;}\n.php .me2 {color: #004000;}\n.php .re0 {color: #000088;}\n.php span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"php\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n4\n5\n6\n7\n8\n9\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n34\n35\n36\n37\n38\n39\n40\n41\n42\n43\n44\n45\n46\n47\n48\n49\n50\n51\n52\n53\n54\n55\n56\n57\n58\n59\n60\n61\n62\n63\n64\n65\n66\n67\n<\/pre><\/td><td class=\"de1\"><pre class=\"de1\"><span class=\"kw2\">&lt;?php<\/span>\n&#160;\n<span class=\"kw2\">class<\/span> CustomPageRepository <span class=\"kw2\">extends<\/span> \\TYPO3\\CMS\\Extbase\\Persistence\\Repository\n<span class=\"br0\">&#123;<\/span>\n&#160; &#160; <span class=\"co4\">\/**<\/span>\n<span class=\"co4\">&#160; &#160; &#160;* Load translated main visual images for the page rows<\/span>\n<span class=\"co4\">&#160; &#160; &#160;* Needed because of https:\/\/forge.typo3.org\/issues\/57272<\/span>\n<span class=\"co4\">&#160; &#160; &#160;*<\/span>\n<span class=\"co4\">&#160; &#160; &#160;* @param QueryResult $results Array of page objects<\/span>\n<span class=\"co4\">&#160; &#160; &#160;*<\/span>\n<span class=\"co4\">&#160; &#160; &#160;* @return array Page objects<\/span>\n<span class=\"co4\">&#160; &#160; &#160;*\/<\/span>\n&#160; &#160; <span class=\"kw2\">protected<\/span> <span class=\"kw2\">function<\/span> loadTranslatedMainVisuals<span class=\"br0\">&#40;<\/span><span class=\"re0\">$results<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"kw1\">if<\/span> <span class=\"br0\">&#40;<\/span><span class=\"re0\">$_GET<\/span><span class=\"br0\">&#91;<\/span><span class=\"st_h\">'L'<\/span><span class=\"br0\">&#93;<\/span> <span class=\"sy0\">==<\/span> <span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span> <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"co1\">\/\/default language<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw1\">return<\/span> <span class=\"re0\">$results<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"br0\">&#125;<\/span>\n&#160;\n&#160; &#160; &#160; &#160; <span class=\"re0\">$ids<\/span> <span class=\"sy0\">=<\/span> <span class=\"br0\">&#91;<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"kw1\">foreach<\/span> <span class=\"br0\">&#40;<\/span><span class=\"re0\">$results<\/span> <span class=\"kw1\">as<\/span> <span class=\"re0\">$page<\/span><span class=\"br0\">&#41;<\/span> <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"re0\">$ids<\/span><span class=\"br0\">&#91;<\/span><span class=\"br0\">&#93;<\/span> <span class=\"sy0\">=<\/span> <a href=\"http:\/\/www.php.net\/intval\"><span class=\"kw3\">intval<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"re0\">$page<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">getUid<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"br0\">&#125;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"re0\">$qb<\/span> <span class=\"sy0\">=<\/span> GeneralUtility<span class=\"sy0\">::<\/span><span class=\"me2\">makeInstance<\/span><span class=\"br0\">&#40;<\/span>ConnectionPool<span class=\"sy0\">::<\/span><span class=\"kw2\">class<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">-&gt;<\/span><span class=\"me1\">getQueryBuilderForTable<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'pages_language_overlay'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"re0\">$stmt<\/span> <span class=\"sy0\">=<\/span> <span class=\"re0\">$qb<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">select<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'uid'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'pid'<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">-&gt;<\/span><span class=\"me1\">from<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'pages_language_overlay'<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">-&gt;<\/span><span class=\"me1\">where<\/span><span class=\"br0\">&#40;<\/span><span class=\"re0\">$qb<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">expr<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">in<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'pid'<\/span><span class=\"sy0\">,<\/span> <span class=\"re0\">$ids<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">-&gt;<\/span><span class=\"me1\">execute<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160;\n&#160; &#160; &#160; &#160; <span class=\"re0\">$translations<\/span> <span class=\"sy0\">=<\/span> <span class=\"br0\">&#91;<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"kw1\">while<\/span> <span class=\"br0\">&#40;<\/span><span class=\"re0\">$row<\/span> <span class=\"sy0\">=<\/span> <span class=\"re0\">$stmt<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">fetch<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span> <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"re0\">$translations<\/span><span class=\"br0\">&#91;<\/span><span class=\"re0\">$row<\/span><span class=\"br0\">&#91;<\/span><span class=\"st_h\">'uid'<\/span><span class=\"br0\">&#93;<\/span><span class=\"br0\">&#93;<\/span> <span class=\"sy0\">=<\/span> <span class=\"re0\">$row<\/span><span class=\"br0\">&#91;<\/span><span class=\"st_h\">'pid'<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"br0\">&#125;<\/span>\n&#160;\n&#160;\n&#160; &#160; &#160; &#160; <span class=\"re0\">$qb<\/span> <span class=\"sy0\">=<\/span> GeneralUtility<span class=\"sy0\">::<\/span><span class=\"me2\">makeInstance<\/span><span class=\"br0\">&#40;<\/span>ConnectionPool<span class=\"sy0\">::<\/span><span class=\"kw2\">class<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">-&gt;<\/span><span class=\"me1\">getQueryBuilderForTable<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'sys_file_reference'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"re0\">$stmt<\/span> <span class=\"sy0\">=<\/span> <span class=\"re0\">$qb<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">select<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'*'<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">-&gt;<\/span><span class=\"me1\">from<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'sys_file_reference'<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">-&gt;<\/span><span class=\"me1\">where<\/span><span class=\"br0\">&#40;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"re0\">$qb<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">expr<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">eq<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'tablenames'<\/span><span class=\"sy0\">,<\/span> <span class=\"re0\">$qb<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">createNamedParameter<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'pages_language_overlay'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">,<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"re0\">$qb<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">expr<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">eq<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'fieldname'<\/span><span class=\"sy0\">,<\/span> <span class=\"re0\">$qb<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">createNamedParameter<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'media'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">,<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"re0\">$qb<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">expr<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">in<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'uid_foreign'<\/span><span class=\"sy0\">,<\/span> <a href=\"http:\/\/www.php.net\/array_keys\"><span class=\"kw3\">array_keys<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"re0\">$translations<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">-&gt;<\/span><span class=\"me1\">execute<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"re0\">$resourceFactory<\/span> <span class=\"sy0\">=<\/span> GeneralUtility<span class=\"sy0\">::<\/span><span class=\"me2\">makeInstance<\/span><span class=\"br0\">&#40;<\/span>ResourceFactory<span class=\"sy0\">::<\/span><span class=\"kw2\">class<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"re0\">$files<\/span> <span class=\"sy0\">=<\/span> <span class=\"br0\">&#91;<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"kw1\">while<\/span> <span class=\"br0\">&#40;<\/span><span class=\"re0\">$row<\/span> <span class=\"sy0\">=<\/span> <span class=\"re0\">$stmt<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">fetch<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span> <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"co1\">\/\/QueryResult does not support direct uid access,<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"co1\">\/\/ so we have to use the intermediate files array<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"re0\">$origPageUid<\/span> <span class=\"sy0\">=<\/span> <span class=\"re0\">$translations<\/span><span class=\"br0\">&#91;<\/span><span class=\"re0\">$row<\/span><span class=\"br0\">&#91;<\/span><span class=\"st_h\">'uid_foreign'<\/span><span class=\"br0\">&#93;<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"re0\">$files<\/span><span class=\"br0\">&#91;<\/span><span class=\"re0\">$origPageUid<\/span><span class=\"br0\">&#93;<\/span> <span class=\"sy0\">=<\/span> <span class=\"re0\">$resourceFactory<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">getFileReferenceObject<\/span><span class=\"br0\">&#40;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"re0\">$row<\/span><span class=\"br0\">&#91;<\/span><span class=\"st_h\">'uid'<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"re0\">$row<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"br0\">&#125;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"kw1\">foreach<\/span> <span class=\"br0\">&#40;<\/span><span class=\"re0\">$results<\/span> <span class=\"kw1\">as<\/span> <span class=\"re0\">$page<\/span><span class=\"br0\">&#41;<\/span> <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"kw1\">if<\/span> <span class=\"br0\">&#40;<\/span><a href=\"http:\/\/www.php.net\/isset\"><span class=\"kw3\">isset<\/span><\/a><span class=\"br0\">&#40;<\/span><span class=\"re0\">$files<\/span><span class=\"br0\">&#91;<\/span><span class=\"re0\">$page<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">getUid<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#93;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span> <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"re0\">$page<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">setMainVisual<\/span><span class=\"br0\">&#40;<\/span><span class=\"re0\">$files<\/span><span class=\"br0\">&#91;<\/span><span class=\"re0\">$page<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">getUid<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#93;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"br0\">&#125;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"br0\">&#125;<\/span>\n&#160;\n&#160; &#160; &#160; &#160; <span class=\"kw1\">return<\/span> <span class=\"re0\">$results<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; <span class=\"br0\">&#125;<\/span>\n<span class=\"br0\">&#125;<\/span>\n<span class=\"sy1\">?&gt;<\/span>\n&#160;<\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/531\/rev-raw\/f1d20480b2a390b864b63cbbc5c3550a4211a8b1\/CustomPageRepository.php\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/531#CustomPageRepository.php\">CustomPageRepository.php<\/a>\n <\/div>\n<\/div>\n<\/div>\n"}