]> Raphaƫl G. Git Repositories - blogbundle/blobdiff - Repository/ArticleRepository.php
Fix buildForm prototype
[blogbundle] / Repository / ArticleRepository.php
index a19d63c8f9d989a53b7043065b8a9be8899d7a05..9708751067d9b5005e80b699ec3366cfb5b46278 100644 (file)
@@ -79,7 +79,7 @@ LEFT JOIN RapsysBlogBundle:ArticleKeyword AS ak ON (ak.article_id = a.id)
 LEFT JOIN RapsysBlogBundle:Keyword AS k ON (k.id = ak.keyword_id)
 LEFT JOIN RapsysBlogBundle:KeywordTranslation AS kt ON (kt.keyword_id = k.id AND kt.locale = :locale)
 GROUP BY a.id
-ORDER BY updated, created DESC
+ORDER BY updated, created DESC, a.id
 LIMIT :offset, :count
 SQL;
 
@@ -128,7 +128,7 @@ SQL;
                                'created' => $data['created'],
                                'updated' => $data['updated'],
                                'modified' => $data['modified'],
-                               'link' => $this->router->generate('rapsys_blog_article_view', ['id' => $id, 'slug' => $slug]),
+                               'link' => $this->router->generate('rapsysblog_article_view', ['id' => $id, 'slug' => $slug]),
                                'keywords' => []
                        ];
 
@@ -146,7 +146,7 @@ SQL;
                                        'id' => $id,
                                        'slug' => $slug = $data['k_slugs'][$k],
                                        'title' => $data['k_titles'][$k],
-                                       'link' => $this->router->generate('rapsys_blog_keyword_view', ['id' => $id, 'slug' => $slug]),
+                                       'link' => $this->router->generate('rapsysblog_keyword_view', ['id' => $id, 'slug' => $slug]),
                                ];
                        }
                }
@@ -246,7 +246,7 @@ SQL;
                        'created' => $data['created'],
                        'updated' => $data['updated'],
                        'modified' => $data['modified'],
-                       'link' => $this->router->generate('rapsys_blog_article_view', ['id' => $id, 'slug' => $slug]),
+                       'link' => $this->router->generate('rapsysblog_article_view', ['id' => $id, 'slug' => $slug]),
                        'alternates' => [],
                        'keywords' => []
                ];
@@ -265,7 +265,7 @@ SQL;
                                'id' => $kid,
                                'slug' => $slug = $data['k_slugs'][$k],
                                'title' => $data['k_titles'][$k],
-                               'link' => $this->router->generate('rapsys_blog_keyword_view', ['id' => $kid, 'slug' => $slug]),
+                               'link' => $this->router->generate('rapsysblog_keyword_view', ['id' => $kid, 'slug' => $slug]),
                        ];
                }
 
@@ -283,7 +283,7 @@ SQL;
                                'locale' => $locale,
                                'slug' => $slug = $data['kat_slugs'][$k],
                                'title' => $data['kat_titles'][$k],
-                               'link' => $this->router->generate('rapsys_blog_article_view', ['_locale' => $locale, 'id' => $id, 'slug' => $slug]),
+                               'link' => $this->router->generate('rapsysblog_article_view', ['_locale' => $locale, 'id' => $id, 'slug' => $slug]),
                        ];
                }