Piou-piou /
ribs-module-blog
| @@ 67-93 (lines=27) @@ | ||
| 64 | /** |
|
| 65 | * this function get last articles |
|
| 66 | */ |
|
| 67 | public function getAllArticle() { |
|
| 68 | $dbc = App::getDb(); |
|
| 69 | ||
| 70 | $query = $dbc->select() |
|
| 71 | ->from("_blog_article") |
|
| 72 | ->from("identite") |
|
| 73 | ->where("_blog_article.ID_identite", "=", "identite.ID_identite", "", true) |
|
| 74 | ->get(); |
|
| 75 | ||
| 76 | if ((is_array($query)) && (count($query) > 0)) { |
|
| 77 | $articles = []; |
|
| 78 | ||
| 79 | foreach ($query as $obj) { |
|
| 80 | $articles[] = [ |
|
| 81 | "id_article" => $obj->ID_article, |
|
| 82 | "title" => $obj->title, |
|
| 83 | "url" => $obj->url, |
|
| 84 | "article" => $obj->article, |
|
| 85 | "pseudo" => $obj->pseudo, |
|
| 86 | "publication_date" => $obj->publication_date, |
|
| 87 | "categories" => Blog::getCategory()->getCategoryArticle($obj->url) |
|
| 88 | ]; |
|
| 89 | } |
|
| 90 | ||
| 91 | Blog::setValues(["articles" => $articles]); |
|
| 92 | } |
|
| 93 | } |
|
| 94 | //-------------------------- END GETTER ----------------------------------------------------------------------------// |
|
| 95 | ||
| 96 | ||
| @@ 21-48 (lines=28) @@ | ||
| 18 | /** |
|
| 19 | * this function get last articles |
|
| 20 | */ |
|
| 21 | public function getLastArticle() { |
|
| 22 | $dbc = App::getDb(); |
|
| 23 | $nb_article = Blog::getArticleIndex(); |
|
| 24 | ||
| 25 | $query = $dbc->select() |
|
| 26 | ->from("_blog_article") |
|
| 27 | ->from("identite") |
|
| 28 | ->where("_blog_article.ID_identite", "=", "identite.ID_identite", "", true) |
|
| 29 | ->limit(0, $nb_article)->get(); |
|
| 30 | ||
| 31 | if ((is_array($query)) && (count($query) > 0)) { |
|
| 32 | $articles = []; |
|
| 33 | ||
| 34 | foreach ($query as $obj) { |
|
| 35 | $articles[] = [ |
|
| 36 | "id_article" => $obj->ID_article, |
|
| 37 | "title" => $obj->title, |
|
| 38 | "url" => $obj->url, |
|
| 39 | "article" => $obj->article, |
|
| 40 | "pseudo" => $obj->pseudo, |
|
| 41 | "publication_date" => $obj->publication_date, |
|
| 42 | "categories" => Blog::getCategory()->getCategoryArticle($obj->url) |
|
| 43 | ]; |
|
| 44 | } |
|
| 45 | ||
| 46 | Blog::setValues(["articles" => $articles]); |
|
| 47 | } |
|
| 48 | } |
|
| 49 | ||
| 50 | /** |
|
| 51 | * function that get one article |
|
