Piou-piou /
ribs-module-blog
| @@ 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 |
|
| @@ 84-110 (lines=27) @@ | ||
| 81 | /** |
|
| 82 | * this function get last articles |
|
| 83 | */ |
|
| 84 | public function getAllArticle() { |
|
| 85 | $dbc = App::getDb(); |
|
| 86 | ||
| 87 | $query = $dbc->select() |
|
| 88 | ->from("_blog_article") |
|
| 89 | ->from("identite") |
|
| 90 | ->where("_blog_article.ID_identite", "=", "identite.ID_identite", "", true) |
|
| 91 | ->get(); |
|
| 92 | ||
| 93 | if ((is_array($query)) && (count($query) > 0)) { |
|
| 94 | $articles = []; |
|
| 95 | ||
| 96 | foreach ($query as $obj) { |
|
| 97 | $articles[] = [ |
|
| 98 | "id_article" => $obj->ID_article, |
|
| 99 | "title" => $obj->title, |
|
| 100 | "url" => $obj->url, |
|
| 101 | "article" => $obj->article, |
|
| 102 | "pseudo" => $obj->pseudo, |
|
| 103 | "publication_date" => $obj->publication_date, |
|
| 104 | "categories" => Blog::getCategory()->getCategoryArticle($obj->url) |
|
| 105 | ]; |
|
| 106 | } |
|
| 107 | ||
| 108 | Blog::setValues(["articles" => $articles]); |
|
| 109 | } |
|
| 110 | } |
|
| 111 | //-------------------------- END GETTER ----------------------------------------------------------------------------// |
|
| 112 | ||
| 113 | ||
