Jacek Pyziak
c9ed7b5d5d
- Updated .htaccess rules to allow trailing slashes for specific routes. - Introduced a new .gitignore file to exclude the cache directory. - Created project configuration file for Serena with language and tool settings. - Implemented Authors class for managing author data, including methods for saving, deleting, and editing authors. - Added factory class for Authors to handle database interactions related to authors. - Developed Article class to manage article data and interactions, including fetching articles and updating views. - Created Page class with a placeholder method for sorting pages. - Added front factory class for fetching author details with caching.
196 lines
8.4 KiB
PHP
196 lines
8.4 KiB
PHP
<?php
|
|
class Article implements \ArrayAccess
|
|
{
|
|
public function __construct( $article_id, $lang_id )
|
|
{
|
|
global $mdb;
|
|
|
|
$result = $mdb -> get( 'pp_articles', '*', [ 'id' => (int)$article_id ] );
|
|
if ( \S::is_array_fix( $result ) ) foreach ( $result as $key => $val )
|
|
$this -> $key = $val;
|
|
|
|
$results = $mdb -> select( 'pp_articles_langs', '*', [ 'AND' => [ 'article_id' => (int)$article_id, 'lang_id' => $lang_id ] ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
{
|
|
if ( $row['copy_from'] )
|
|
{
|
|
$results2 = $mdb -> select( 'pp_articles_langs', '*', [ 'AND' => [ 'article_id' => (int)$article_id, 'lang_id' => $row['copy_from'] ] ] );
|
|
if ( is_array( $results2 ) ) foreach ( $results2 as $row2 )
|
|
$this -> language = $row2;
|
|
}
|
|
else
|
|
$this -> language = $row;
|
|
|
|
preg_match_all( \front\view\Site::container_pattern, $this -> language['entry'], $container_list );
|
|
if ( is_array( $container_list[0] ) ) foreach( $container_list[0] as $container_list_tmp )
|
|
{
|
|
$container_list_tmp = explode( ':', $container_list_tmp );
|
|
$this -> language['entry'] = str_replace( '[KONTENER:' . $container_list_tmp[1] . ']', \front\view\Scontainers::scontainer( $container_list_tmp[1] ), $this -> language['entry'] );
|
|
}
|
|
|
|
preg_match_all( \front\view\Site::container_pattern, $this -> language['text'], $container_list );
|
|
if ( is_array( $container_list[0] ) ) foreach( $container_list[0] as $container_list_tmp )
|
|
{
|
|
$container_list_tmp = explode( ':', $container_list_tmp );
|
|
$this -> language['text'] = str_replace( '[KONTENER:' . $container_list_tmp[1] . ']', \front\view\Scontainers::scontainer( $container_list_tmp[1] ), $this -> language['text'] );
|
|
}
|
|
}
|
|
|
|
$this -> images = $mdb -> select( 'pp_articles_images', '*', [ 'article_id' => (int)$article_id, 'ORDER' => [ 'o' => 'ASC', 'id' => 'ASC' ] ] );
|
|
$this -> files = $mdb -> select( 'pp_articles_files', '*', [ 'article_id' => (int)$article_id ] );
|
|
$this -> pages = $mdb -> select( 'pp_articles_pages', 'page_id', [ 'article_id' => (int)$article_id ] );
|
|
$this -> tags = $mdb -> select( 'pp_tags', [ '[><]pp_articles_tags' => [ 'id' => 'tag_id' ] ], 'name', [ 'article_id' => (int)$article_id ] );
|
|
$results = $mdb -> select( 'pp_articles_additional_params', [ '[><]pp_articles_additional_values' => [ 'id' => 'param_id' ] ], [ 'name', 'value', 'language_id' ], [ 'article_id' => (int)$article_id ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
{
|
|
if ( !$row['language_id'] )
|
|
$params[ $row['name'] ] = $row['value'];
|
|
else
|
|
$params[ $row['name'] ][$row['language_id']] = $row['value'];
|
|
}
|
|
$this -> params = $params;
|
|
}
|
|
|
|
public function updateView()
|
|
{
|
|
global $mdb;
|
|
$mdb -> update( 'pp_articles', [ 'views[+]' => 1 ], [ 'id' => $this -> id ] );
|
|
}
|
|
|
|
static public function newsList( $articles )
|
|
{
|
|
return \Tpl::view( 'articles/news-list', [
|
|
'articles' => $articles
|
|
] );
|
|
}
|
|
|
|
// pobierz najczęściej wyświtlane artykuły
|
|
static public function getTopNews( $page_id, $limit = 6, $lang_id )
|
|
{
|
|
global $mdb;
|
|
|
|
if ( !$articles_id = \Cache::fetch( "getTopNews:$page_id:$limit:$lang_id" ) )
|
|
{
|
|
$articles_id = $mdb -> query( 'SELECT * FROM ( '
|
|
. 'SELECT '
|
|
. 'a.id, date_add, views, '
|
|
. '( CASE '
|
|
. 'WHEN copy_from IS NULL THEN title '
|
|
. 'WHEN copy_from IS NOT NULL THEN ( '
|
|
. 'SELECT '
|
|
. 'title '
|
|
. 'FROM '
|
|
. 'pp_articles_langs '
|
|
. 'WHERE '
|
|
. 'lang_id = al.copy_from AND article_id = a.id '
|
|
. ') '
|
|
. 'END ) AS title '
|
|
. 'FROM '
|
|
. 'pp_articles_pages AS ap '
|
|
. 'INNER JOIN pp_articles AS a ON a.id = ap.article_id '
|
|
. 'INNER JOIN pp_articles_langs AS al ON al.article_id = ap.article_id '
|
|
. 'WHERE '
|
|
. 'status = 1 AND page_id = ' . (int)$page_id . ' AND lang_id = \'' . $lang_id . '\' '
|
|
. ') AS q1 '
|
|
. 'WHERE '
|
|
. 'q1.title IS NOT NULL '
|
|
. 'ORDER BY '
|
|
. 'q1.views DESC '
|
|
. 'LIMIT '
|
|
. '0, ' . (int)$limit ) -> fetchAll( \PDO::FETCH_ASSOC );
|
|
\Cache::store( "getTopNews:$page_id:$limit:$lang_id", $articles_id );
|
|
}
|
|
|
|
if ( \S::is_array_fix( $articles_id ) ) foreach ( $articles_id as $article_tmp )
|
|
{
|
|
if ( !$article = \Cache::fetch( 'article:' . $article_tmp['id'] . ':' . $lang_id ) )
|
|
{
|
|
$article = new \Article( $article_tmp['id'], $lang_id );
|
|
\Cache::store( 'article:' . $article_tmp['id'] . ':' . $lang_id, $article );
|
|
}
|
|
$articles[] = $article;
|
|
}
|
|
|
|
return $articles;
|
|
}
|
|
|
|
static public function getNews( $page_id, $limit = 6, $lang_id )
|
|
{
|
|
global $mdb;
|
|
|
|
if ( !$articles_id = \Cache::fetch( "getNews:$page_id:$limit:$lang_id" ) )
|
|
{
|
|
$articles_id = $mdb -> query( 'SELECT * FROM ( '
|
|
. 'SELECT '
|
|
. 'a.id, date_add, '
|
|
. '( CASE '
|
|
. 'WHEN copy_from IS NULL THEN title '
|
|
. 'WHEN copy_from IS NOT NULL THEN ( '
|
|
. 'SELECT '
|
|
. 'title '
|
|
. 'FROM '
|
|
. 'pp_articles_langs '
|
|
. 'WHERE '
|
|
. 'lang_id = al.copy_from AND article_id = a.id '
|
|
. ') '
|
|
. 'END ) AS title '
|
|
. 'FROM '
|
|
. 'pp_articles_pages AS ap '
|
|
. 'INNER JOIN pp_articles AS a ON a.id = ap.article_id '
|
|
. 'INNER JOIN pp_articles_langs AS al ON al.article_id = ap.article_id '
|
|
. 'WHERE '
|
|
. 'status = 1 AND page_id = ' . (int)$page_id . ' AND lang_id = \'' . $lang_id . '\' '
|
|
. ') AS q1 '
|
|
. 'WHERE '
|
|
. 'q1.title IS NOT NULL '
|
|
. 'ORDER BY '
|
|
. 'q1.date_add DESC '
|
|
. 'LIMIT '
|
|
. '0, ' . (int)$limit ) -> fetchAll( \PDO::FETCH_ASSOC );
|
|
\Cache::store( "getNews:$page_id:$limit:$lang_id", $articles_id );
|
|
}
|
|
|
|
if ( \S::is_array_fix( $articles_id ) ) foreach ( $articles_id as $article_tmp )
|
|
{
|
|
if ( !$article = \Cache::fetch( 'article:' . $article_tmp['id'] . ':' . $lang_id ) )
|
|
{
|
|
$article = new \Article( $article_tmp['id'], $lang_id );
|
|
\Cache::store( 'article:' . $article_tmp['id'] . ':' . $lang_id, $article );
|
|
}
|
|
$articles[] = $article;
|
|
}
|
|
|
|
return $articles;
|
|
}
|
|
|
|
public function __get( $variable )
|
|
{
|
|
if ( array_key_exists( $variable, $this -> data ) )
|
|
return $this -> $variable;
|
|
}
|
|
|
|
public function __set( $variable, $value )
|
|
{
|
|
$this -> $variable = $value;
|
|
}
|
|
|
|
public function offsetExists( $offset )
|
|
{
|
|
return isset( $this -> $offset );
|
|
}
|
|
|
|
public function offsetGet( $offset )
|
|
{
|
|
return $this -> $offset;
|
|
}
|
|
|
|
public function offsetSet( $offset, $value )
|
|
{
|
|
$this -> $offset = $value;
|
|
}
|
|
|
|
public function offsetUnset( $offset )
|
|
{
|
|
unset( $this -> $offset );
|
|
}
|
|
} |