Problème de date HomeCustom

Problème de date HomeCustom [Réglé]

Visiteur

Boosteur Inactif

Le 14/03/2015 à 13h27

@ Julien, il faut que je me mette au php.. Peux-tu me donner un exemple pour limiter à 4 résultats ?

@All,

Quelqu'un saurait comment l'intégrer car je me prends une grosse erreur quand je remplace juste la fonction que j'avais donné en exemple par celle de Janus (et vu que j'ai beaucoup de fonctions similaires à remplacer, dès que j'aurai une de bonne au moins, je devrai pouvoir me débrouiller pour adapter les autres).

Voici mon fichier:

Code PHP :

<?php
/*##################################################
 *                     HomeCustomHomePageExtensionPoint.class.php
 *                            -------------------
 *   begin                : August 25, 2012
 *   copyright            : (C) 2012 Kevin MASSY
 *   email                : kevin.massy@phpboost.com
 *
 *
 ###################################################
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 ###################################################*/
 
class HomeCustomHomePageExtensionPoint implements HomePageExtensionPoint
{
private $template;
 
public function get_home_page()
{
$columns_disabled = Environment::get_graphical_environment()->get_columns_disabled();
  $columns_disabled->set_disable_left_columns(true);
  $columns_disabled->set_disable_right_columns(false);
  $columns_disabled->set_disable_top_central(false);
  $columns_disabled->set_disable_bottom_central(false);
return new DefaultHomePage($this->get_title(), $this->get_view());
}
 
private function get_title()
{
return LangLoader::get_message('title', 'common', 'HomeCustom');
}
 
private function get_view()
{
$this->template = new FileTemplate('HomeCustom/home.tpl');
$this->build_view();
return $this->template;
}
 
 
private function build_view()
{
 
// Récupération des news
$id_cats = array('1', '2');  
 $querier = PersistenceContext::get_querier();
$results_cat10 = $querier->select('SELECT id, id_category, name, creation_date, picture_url, 
user.login
        FROM ' . PREFIX . 'news
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = author_user_id
        WHERE approbation_type = 1 AND id_category IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
$this->build_cat10_view($results_cat10);
 
// Récupération des articles, catégorie Recettes
$id_cats = array('2'); 
 $querier = PersistenceContext::get_querier();
$results_cat1 = $querier->select('SELECT id, id_category, title, description, date_created, picture_url, 
user.login
        FROM ' . PREFIX . 'articles
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = author_user_id
        WHERE published = 1 AND id_category IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
$this->build_cat1_view($results_cat1);
 
// Récupération des articles, catégorie Hygiène et beauté
$id_cats = array('4'); 
$querier = PersistenceContext::get_querier();
$results_cat2 = $querier->select('SELECT id, id_category, title, description, date_created, picture_url, 
user.login
        FROM ' . PREFIX . 'articles
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = author_user_id
        WHERE published = 1 AND id_category IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
$this->build_cat2_view($results_cat2);
 
// Récupération des articles, catégorie Modifications Corporelles
$id_cats = array('5'); 
$querier = PersistenceContext::get_querier();
$results_cat3 = $querier->select('SELECT id, id_category, title, description, date_created, picture_url, 
user.login
        FROM ' . PREFIX . 'articles
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = author_user_id
        WHERE published = 1 AND id_category IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
$this->build_cat3_view($results_cat3);
 
// Récupération des articles, catégorie Nourriture pour l-esprit
$id_cats = array('6'); 
$querier = PersistenceContext::get_querier();
$results_cat4 = $querier->select('SELECT id, id_category, title, description, date_created, picture_url, 
user.login
        FROM ' . PREFIX . 'articles
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = author_user_id
        WHERE published = 1 AND id_category IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
$this->build_cat4_view($results_cat4);
 
// Récupération des articles, Tutos et astuces
$id_cats = array('9'); 
$querier = PersistenceContext::get_querier();
$results_cat5 = $querier->select('SELECT id, id_category, title, description, date_created, picture_url, 
user.login
        FROM ' . PREFIX . 'articles
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = author_user_id
        WHERE published = 1 AND id_category IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
$this->build_cat5_view($results_cat5);
 
// Récupération des articles, catégorie Déco
$id_cats = array('10'); 
$querier = PersistenceContext::get_querier();
$results_cat6 = $querier->select('SELECT id, id_category, title, description, date_created, picture_url, 
user.login
        FROM ' . PREFIX . 'articles
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = author_user_id
        WHERE published = 1 AND id_category IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
$this->build_cat6_view($results_cat6);
 
// Récupération des articles, catégorie Santé
$id_cats = array('16'); 
$querier = PersistenceContext::get_querier();
$results_cat7 = $querier->select('SELECT id, id_category, title, description, date_created, picture_url, 
user.login
        FROM ' . PREFIX . 'articles
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = author_user_id
        WHERE published = 1 AND id_category IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
$this->build_cat7_view($results_cat7);
 
// Récupération des articles, catégorie Autres
$id_cats = array('17'); 
$querier = PersistenceContext::get_querier();
$results_cat8 = $querier->select('SELECT id, id_category, title, description, date_created, picture_url, 
user.login
        FROM ' . PREFIX . 'articles
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = author_user_id
        WHERE published = 1 AND id_category IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
$this->build_cat8_view($results_cat8);
 
// Récupération des articles, catégorie Arts
$id_cats = array('19'); 
 $querier = PersistenceContext::get_querier();
$results_cat9 = $querier->select('SELECT id, id_category, title, description, date_created, picture_url, 
user.login
        FROM ' . PREFIX . 'articles
        LEFT JOIN ' . DB_TABLE_MEMBER . ' user ON user.user_id = author_user_id
        WHERE published = 1 AND id_category IN (' . implode(', ', $id_cats) . ')
                ORDER BY timestamp DESC');
$this->build_cat9_view($results_cat9);
 
$this->build_feed_forum_view();
}
 
//Récupération du feed du forum
private function build_feed_forum_view() 
{
$feed_template = new FileTemplate('HomeCustom/feed_forum.tpl');
$this->template->put('FEED_FORUM', Feed::get_parsed('forum', Feed::DEFAULT_FEED_NAME, 0, $feed_template, 8));
}
 
 // Injection des résultats dans le TPL NEWS
 private function build_cat10_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/news.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 4)
{
break; 
}
 
$link = new Url('/news/' . url($row['id'] .  '-' . Url::encode_rewrite($row['name']) . '/'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['name'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('NEWS', $tpl);
}
 
// Injection des résultats dans le TPL RECETTES
private function build_cat1_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/recettes.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 4)
{
break; 
}
 
$link = new Url('/articles/2-les-recettes/' . url($row['id'] .  '-' . Url::encode_rewrite($row['title']) . '/'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['title'],
'DESC' => $row['description'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('RECETTES', $tpl);
}
 
// Injection des résultats dans le TPL HYGIENE ET BEAUTE
private function build_cat2_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/hygiene.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 4)
{
break; 
}
 
$link = new Url('/articles/4-hygiene-et-beaute/' . url($row['id'] .  '-' . Url::encode_rewrite($row['title']) . '/'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['title'],
'DESC' => $row['description'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('HYGIENE', $tpl);
}
 
// Injection des résultats dans le TPL MODIFICATIONS CORPORELLES
private function build_cat3_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/modif.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 4)
{
break; 
}
 
$link = new Url('/articles/5-modifications-corporelles/' . url($row['id'] .  '-' . Url::encode_rewrite($row['title']) . '/'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['title'],
'DESC' => $row['description'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('MODIF', $tpl);
}
 
// Injection des résultats dans le TPL NOURRITURE POUR LESPRIT
private function build_cat4_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/esprit.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 4)
{
break; 
}
 
$link = new Url('/articles/6-nourriture-pour-l-esprit/' . url($row['id'] .  '-' . Url::encode_rewrite($row['title']) . '/'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['title'],
'DESC' => $row['description'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('ESPRIT', $tpl);
}
 
// Injection des résultats dans le TPL ARTS
private function build_cat9_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/arts.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 4)
{
break; 
}
 
$link = new Url('/articles/19-arts/' . url($row['id'] .  '-' . Url::encode_rewrite($row['title']) . '/'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['title'],
'DESC' => $row['description'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('ARTS', $tpl);
}
 
// Injection des résultats dans le TPL TUTOS ET ASTUCES
private function build_cat5_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/tutos.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 4)
{
break; 
}
 
$link = new Url('/articles/9-tutoriels-astuces/' . url($row['id'] .  '-' . Url::encode_rewrite($row['title']) . '/'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['title'],
'DESC' => $row['description'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('TUTOS', $tpl);
}
 
// Injection des résultats dans le TPL DECO
private function build_cat6_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/deco.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 4)
{
break; 
}
 
$link = new Url('/articles/10-deco/' . url($row['id'] .  '-' . Url::encode_rewrite($row['title']) . '/'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['title'],
'DESC' => $row['description'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('DECO', $tpl);
}
 
// Injection des résultats dans le TPL SANTE
private function build_cat7_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/sante.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 4)
{
break; 
}
 
$link = new Url('/articles/16-sante/' . url($row['id'] .  '-' . Url::encode_rewrite($row['title']) . '/'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['title'],
'DESC' => $row['description'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('SANTE', $tpl);
}
 
// Injection des résultats dans le TPL AUTRES ARTICLES
private function build_cat8_view(SelectQueryResult $results)
{
$tpl = new FileTemplate('HomeCustom/autres.tpl');
$i = 0;
foreach ($results as $row)
{
if ($i >= 4)
{
break; 
}
 
$link = new Url('/articles/16-autres-articles/' . url($row['id'] .  '-' . Url::encode_rewrite($row['title']) . '/'));
$tpl->assign_block_vars('item', array(
'U_LINK' => $link->absolute(),
'U_IMG' => Url::to_absolute($row['picture_url']),
'C_IMG' => !empty($row['picture_url']),
'TITLE' => $row['title'],
'DESC' => $row['description'],
'PSEUDO' => $row['login']
));
$i++;
}
$this->template->put('AUTRES', $tpl);
}
}
?>

EDIT: Commentaire du code pour lisibilité.

Édité par Visiteur Le 14/03/2015 à 13h38

jpalbert92 Membre non connecté

Booster Fuzil

Le 14/03/2015 à 14h02

#143759

Bonjour,

Ce n'est pas du PHP mais du SQL le LIMIT : à la fin de ta requête SQL il suffit de rajouter LIMIT 4 soit :

Code SQL :

SELECT articles.id, articles.id_category, articles.title, articles.rewrited_title, articles.picture_url, 
articles.contents, articles.description, articles.date_created, cat.rewrited_name AS rewrited_name_cat
FROM ' . PREFIX . 'articles articles
LEFT JOIN ' . PREFIX . 'articles_cats cat ON cat.id = articles.id_category
WHERE articles.id_category IN :cats_ids
AND (published = 1 OR (published = 2 AND publishing_start_date < :timestamp_now AND (publishing_end_date > :timestamp_now OR publishing_end_date = 0)))
ORDER BY articles.date_created DESC
LIMIT 4

Puis en me basant sur la requête de Janus il suffit juste de l'insérer dans ton fichier .php, et là ça devient du langage PHP ( en fait tu te sert du SQL dans le langage PHP, d'ailleurs on apprend PHP & MySQL.) je t'ai fais le premier :

Code PHP :

// Récupération des articles, catégorie Recettes        
$ids_cats = 2;
$now = new Date();
$querier = PersistenceContext::get_querier();
$results_cat1 = $querier->select('SELECT articles.id, articles.id_category, articles.title, articles.rewrited_title, articles.picture_url, 
articles.contents, articles.description, articles.date_created, cat.rewrited_name AS rewrited_name_cat
FROM ' . PREFIX . 'articles articles
LEFT JOIN ' . PREFIX . 'articles_cats cat ON cat.id = articles.id_category
WHERE articles.id_category IN :cats_ids
AND (published = 1 OR (published = 2 AND publishing_start_date < :timestamp_now AND (publishing_end_date > :timestamp_now OR publishing_end_date = 0)))
ORDER BY articles.date_created DESC
LIMIT 4', 
array(
    'cats_ids' => $ids_cats,
    'timestamp_now' => $now->get_timestamp()
));
$this->build_cat1_view($results_cat1);

Si tu veux apprendre le PHP je te conseil d'apprendre le SQL pour que tu comprennes la chose puis les algorithmes. Une fois que tu auras compris ces 2 langages tu seras capables de comprendre tous les langages, non pas parce qu'ils sont utilisé de partout loin de là, mais parce que la logique est toujours la même !

(Je suis encore en phase d'apprentissage du PHP mdr)

Et pour ce qui est de la logique des algorithmes c'est vraiment identique à la formule "SI" de excel, c'est juste la présentation qui change !

En espérant t'avoir aidé si tu as des questions n'hésite pas !

Édité par jpalbert92 Le 14/03/2015 à 14h06

Jpa92, don't panik !

Because I need a signature... You were supposed to know !

Visiteur

Boosteur Inactif

Le 14/03/2015 à 14h07

#143760

@jpalbert92, merci de ton aide

Je suivrai ton conseil !

Malheureusement, pour la requête, cela me fait une erreur:

Caché :

MySQLQuerierException

invalid query. (ERRNO 1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2

AND (published = 1 OR (published = 2 AND publishing_start_date < 1426338344 A' at line 5

query: SELECT articles.id, articles.id_category, articles.title, articles.rewrited_title, articles.picture_url,

articles.contents, articles.description, articles.date_created, cat.rewrited_name AS rewrited_name_cat

FROM phpboost_articles articles

LEFT JOIN phpboost_articles_cats cat ON cat.id = articles.id_category

WHERE articles.id_category IN 2

AND (published = 1 OR (published = 2 AND publishing_start_date < 1426338344 AND (publishing_end_date > 1426338344 OR publishing_end_date = 0)))

ORDER BY articles.date_created DESC

LIMIT 4

STACKTRACE

METHOD FILE LINE

+ MySQLQuerier->execute(string, array) /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php 48

+ MySQLQuerier->select(string, array, int) /kernel/framework/io/db/DBQuerier.class.php 50

+ DBQuerier->select(string, array) /HomeCustom/phpboost/HomeCustomHomePageExtensionPoint.class.php 84

HomeCustomHomePageExtensionPoint->build_view() /HomeCustom/phpboost/HomeCustomHomePageExtensionPoint.class.php 50

HomeCustomHomePageExtensionPoint->get_view() /HomeCustom/phpboost/HomeCustomHomePageExtensionPoint.class.php 39

HomeCustomHomePageExtensionPoint->get_home_page() /kernel/framework/phpboost/index/PHPBoostIndexController.class.php 49

+ PHPBoostIndexController->execute(HTTPRequestCustom) /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php 87

UrlControllerMapper->do_call() /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php 59

UrlControllerMapper->call() /kernel/framework/mvc/dispatcher/Dispatcher.class.php 67

Dispatcher->dispatch() /kernel/framework/mvc/dispatcher/DispatchManager.class.php 43

+ DispatchManager::dispatch(array) /index.php

Répondre

Vous n'êtes pas autorisé à écrire dans cette catégorie

Visiteur

j1.seth Membre non connecté

janus57 Membre non connecté

j1.seth Membre non connecté

Visiteur

jpalbert92 Membre non connecté

Visiteur

janus57 Membre non connecté

Visiteur

janus57 Membre non connecté

Visiteur

janus57 Membre non connecté

Visiteur

janus57 Membre non connecté

Visiteur