693 lines
27 KiB
PHP
693 lines
27 KiB
PHP
<?php
|
|
namespace admin\factory;
|
|
class Articles
|
|
{
|
|
public static function duplicate_article( $article_id )
|
|
{
|
|
global $mdb, $user;
|
|
|
|
$article = \admin\factory\Articles::article_details( $article_id );
|
|
|
|
if ( $article )
|
|
{
|
|
$mdb -> insert( 'pp_articles', [
|
|
'show_title' => $article['show_title'],
|
|
'show_date_add' => $article['show_date_add'],
|
|
'show_date_modify' => $article['show_date_modify'],
|
|
'date_add' => date( 'Y-m-d H:i:s' ),
|
|
'date_modify' => date( 'Y-m-d H:i:s' ),
|
|
'modify_by' => $user['id'],
|
|
'layout_id' => $article['layout_id'],
|
|
'status' => $article['status'],
|
|
'repeat_entry' => $article['repeat_entry'],
|
|
'social_icons' => $article['social_icons'],
|
|
'date_start' => $article['date_start'],
|
|
'date_end' => $article['event_date'],
|
|
'priority' => $article['priority'],
|
|
'password' => $article['password'],
|
|
'pixieset' => $article['pixieset']
|
|
] );
|
|
|
|
$article_tmp_id = $mdb -> id();
|
|
|
|
if ( $article_tmp_id )
|
|
{
|
|
foreach ( $article['languages'] as $key => $val )
|
|
{
|
|
$mdb -> insert( 'pp_articles_langs', [
|
|
'article_id' => $article_tmp_id,
|
|
'lang_id' => $key,
|
|
'title' => 'Kopia: ' . $val['title'],
|
|
'entry' => $val['entry'],
|
|
'text' => $val['text'],
|
|
'meta_title' => null,
|
|
'meta_description' => null,
|
|
'meta_keywords' => null,
|
|
'seo_link' => null,
|
|
'copy_from' => $val['copy_from'],
|
|
'block_direct_access' => $val['block_direct_access']
|
|
] );
|
|
}
|
|
|
|
foreach ( $article['params'] as $param )
|
|
{
|
|
$mdb -> insert( 'pp_articles_additional_values', [
|
|
'param_id' => $param['param_id'],
|
|
'value' => $param['value'],
|
|
'article_id' => $article_tmp_id,
|
|
'language_id' => $param['language_id']
|
|
] );
|
|
}
|
|
|
|
foreach ( $article['pages'] as $page )
|
|
{
|
|
$order = self::max_order() + 1;
|
|
$mdb -> insert( 'pp_articles_pages', [
|
|
'article_id' => $article_tmp_id,
|
|
'page_id' => $page,
|
|
'o' => (int)$order
|
|
] );
|
|
}
|
|
return true;
|
|
}
|
|
}
|
|
return false;
|
|
}
|
|
|
|
public static function insert_missing_hash() {
|
|
global $mdb;
|
|
|
|
if ( $mdb -> count( 'pp_articles', [ 'hash' => null ] ) ) {
|
|
$rows = $mdb -> select( 'pp_articles', [ 'id', 'date_add' ], [ 'hash' => null ] );
|
|
if ( is_array( $rows ) ) foreach ( $rows as $row ) {
|
|
$mdb -> update( 'pp_articles', [ 'hash' => md5( $row['id'] . $row['date_add'] ) ], [ 'id' => $row['id'] ] );
|
|
}
|
|
}
|
|
return true;
|
|
}
|
|
|
|
public static function gallery_order_save( $article_id, $order )
|
|
{
|
|
global $mdb;
|
|
|
|
$order = explode( ';', $order );
|
|
if ( is_array( $order ) and !empty( $order ) ) foreach ( $order as $image_id )
|
|
{
|
|
$mdb -> update( 'pp_articles_images', [
|
|
'o' => $i++
|
|
], [
|
|
'AND' => [
|
|
'article_id' => $article_id,
|
|
'id' => $image_id
|
|
]
|
|
] );
|
|
}
|
|
}
|
|
|
|
public static function additional_params( $language = 0 )
|
|
{
|
|
global $mdb;
|
|
return $mdb -> select( 'pp_articles_additional_params', '*', [ 'AND' => [ 'status' => 1, 'language' => $language ] ] );
|
|
}
|
|
|
|
public static function image_alt_change( $image_id, $image_alt )
|
|
{
|
|
global $mdb;
|
|
$result = $mdb -> update( 'pp_articles_images', [
|
|
'alt' => $image_alt
|
|
], [
|
|
'id' => $image_id
|
|
] );
|
|
\S::delete_cache();
|
|
return $result;
|
|
}
|
|
|
|
public static function articles_by_date_add( $date_start, $date_end )
|
|
{
|
|
global $mdb;
|
|
|
|
$results = $mdb -> query( 'SELECT '
|
|
. 'id '
|
|
. 'FROM '
|
|
. 'pp_articles '
|
|
. 'WHERE '
|
|
. 'status = 1 '
|
|
. 'AND '
|
|
. 'date_add BETWEEN \'' . $date_start . '\' AND \'' . $date_end . '\' '
|
|
. 'ORDER BY '
|
|
. 'date_add DESC' ) -> fetchAll();
|
|
if ( is_array( $results ) and !empty( $results ) ) foreach ( $results as $row )
|
|
$articles[] = \front\factory\Articles::article_details( $row['id'], 'pl' );
|
|
|
|
return $articles;
|
|
}
|
|
|
|
public static function article_url( $article_id )
|
|
{
|
|
global $mdb;
|
|
|
|
$results = $mdb -> query( "SELECT seo_link FROM pp_articles_langs AS pal, pp_langs AS pl WHERE lang_id = pl.id AND article_id = " . (int)$article_id . " AND seo_link != '' ORDER BY o ASC LIMIT 1" ) -> fetchAll();
|
|
if ( !$results[0]['seo_link'] )
|
|
{
|
|
$title = self::article_title( $article_id );
|
|
return 'a-' . $article_id . '-' . \S::seo( $title );
|
|
}
|
|
else
|
|
return $results[0]['seo_link'];
|
|
}
|
|
|
|
public static function article_pages( $article_id )
|
|
{
|
|
global $mdb;
|
|
|
|
$results = $mdb -> query( "SELECT page_id FROM pp_articles_pages WHERE article_id = " . (int)$article_id ) -> fetchAll();
|
|
if ( is_array( $results ) and !empty( $results ) ) foreach ( $results as $row )
|
|
{
|
|
if ( $out == '' )
|
|
$out .= ' - ';
|
|
|
|
$out .= \admin\factory\Pages::page_title( $row['page_id'] );
|
|
|
|
if ( end( $results ) != $row )
|
|
$out .= ' / ';
|
|
}
|
|
|
|
return $out;
|
|
}
|
|
|
|
public static function article_title( $article_id )
|
|
{
|
|
global $mdb;
|
|
$results = $mdb -> query( "SELECT title FROM pp_articles_langs AS pal, pp_langs AS pl WHERE lang_id = pl.id AND article_id = " . (int)$article_id . " AND title != '' ORDER BY o ASC LIMIT 1" ) -> fetchAll();
|
|
return $results[0]['title'];
|
|
}
|
|
|
|
public static function articles_set_archive( $article_id )
|
|
{
|
|
global $mdb;
|
|
$result = $mdb -> update( 'pp_articles', [ 'status' => -1 ], [ 'id' => (int)$article_id ] );
|
|
\S::htacces();
|
|
\S::delete_cache();
|
|
return $result;
|
|
}
|
|
|
|
public static function file_name_change( $file_id, $file_name )
|
|
{
|
|
global $mdb;
|
|
$mdb -> update( 'pp_articles_files', [ 'name' => $file_name ], [ 'id' => (int)$file_id ] );
|
|
return true;
|
|
}
|
|
|
|
public static function delete_file( $file_id )
|
|
{
|
|
global $mdb;
|
|
$mdb -> update( 'pp_articles_files', [ 'to_delete' => 1 ], [ 'id' => (int)$file_id ] );
|
|
return true;
|
|
}
|
|
public static function delete_img( $image_id )
|
|
{
|
|
global $mdb;
|
|
$mdb -> update( 'pp_articles_images', [ 'to_delete' => 1 ], [ 'id' => (int)$image_id ] );
|
|
return true;
|
|
}
|
|
|
|
public static function article_details( $article_id )
|
|
{
|
|
global $mdb;
|
|
|
|
if ( $article = $mdb -> get( 'pp_articles', '*', [ 'id' => (int)$article_id ] ) )
|
|
{
|
|
$results = $mdb -> select( 'pp_articles_langs', '*', [ 'article_id' => (int)$article_id ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
$article['languages'][ $row['lang_id'] ] = $row;
|
|
|
|
$article['images'] = $mdb -> select( 'pp_articles_images', '*', [ 'article_id' => (int)$article_id, 'ORDER' => [ 'o' => 'ASC', 'id' => 'ASC' ] ] );
|
|
$article['files'] = $mdb -> select( 'pp_articles_files', '*', [ 'article_id' => (int)$article_id ] );
|
|
$article['pages'] = $mdb -> select( 'pp_articles_pages', 'page_id', [ 'article_id' => (int)$article_id ] );
|
|
$article['tags'] = $mdb -> select( 'pp_tags', [ '[><]pp_articles_tags' => [ 'id' => 'tag_id' ] ], 'name', [ 'article_id' => (int)$article_id ] );
|
|
$article['params'] = $mdb -> select( 'pp_articles_additional_values', [ 'param_id', 'value', 'language_id' ], [ 'article_id' => (int)$article_id ] );
|
|
}
|
|
|
|
return $article;
|
|
}
|
|
|
|
public static function max_order()
|
|
{
|
|
global $mdb;
|
|
return $mdb -> max( 'pp_articles_pages', 'o' );
|
|
}
|
|
|
|
public static function article_save(
|
|
$article_id, $title, $main_image, $entry, $text, $table_of_contents, $status, $show_title, $show_date_add, $date_add, $show_date_modify, $seo_link, $meta_title, $meta_description,
|
|
$meta_keywords, $layout_id, $pages, $noindex, $repeat_entry, $copy_from, $social_icons, $event_date, $tags, $block_direct_access, $priority,
|
|
$password, $pixieset, $id_author, $params )
|
|
{
|
|
|
|
global $mdb, $user;
|
|
|
|
$event_date = explode( ' - ', $event_date );
|
|
|
|
if ( !$article_id )
|
|
{
|
|
$mdb -> insert( 'pp_articles', [
|
|
'show_title' => $show_title == 'on' ? 1 : 0,
|
|
'show_date_add' => $show_date_add == 'on' ? 1 : 0,
|
|
'show_date_modify' => $show_date_modify == 'on' ? 1 : 0,
|
|
'date_add' => $date_add ? $date_add : date( 'Y-m-d H:i:s' ),
|
|
'date_modify' => $date_add ? $date_add : date( 'Y-m-d H:i:s' ),
|
|
'modify_by' => $user['id'],
|
|
'layout_id' => $layout_id ? (int)$layout_id : null,
|
|
'status' => $status == 'on' ? 1 : 0,
|
|
'repeat_entry' => $repeat_entry == 'on' ? 1 : 0,
|
|
'social_icons' => $social_icons == 'on' ? 1 : 0,
|
|
'date_start' => $event_date[0] ? $event_date[0] : null,
|
|
'date_end' => $event_date[1] ? $event_date[1] : null,
|
|
'priority' => $priority == 'on' ? 1 : 0,
|
|
'password' => $password ? $password : null,
|
|
'pixieset' => $pixieset,
|
|
'id_author' => $id_author ? $id_author : null
|
|
] );
|
|
|
|
$id = $mdb -> id();
|
|
|
|
if ( $id )
|
|
{
|
|
$i = 0;
|
|
|
|
/* tłumaczenia */
|
|
$results = $mdb -> select( 'pp_langs', [ 'id' ], [ 'status' => 1, 'ORDER' => [ 'o' => 'ASC' ] ] );
|
|
if ( is_array( $results ) and count( $results ) > 1 ) foreach ( $results as $row )
|
|
{
|
|
$mdb -> insert( 'pp_articles_langs', [
|
|
'article_id' => (int)$id,
|
|
'lang_id' => $row['id'],
|
|
'title' => $title[ $i ] != '' ? $title[ $i ] : null,
|
|
'main_image' => $main_image[$i] != '' ? $main_image[$i] : null,
|
|
'entry' => $entry[ $i ] != '' ? $entry[ $i ] : null,
|
|
'text' => $text[ $i ] != '' ? $text[ $i ] : null,
|
|
'table_of_contents' => $table_of_contents[$i] != '' ? $table_of_contents[$i] : null,
|
|
'meta_title' => $meta_title[ $i ] != '' ? $meta_title[ $i ] : null,
|
|
'meta_description' => $meta_description[ $i ] != '' ? $meta_description[ $i ] : null,
|
|
'meta_keywords' => $meta_keywords[ $i ] != '' ? $meta_keywords[ $i ] : null,
|
|
'seo_link' => \S::seo( $seo_link[ $i ] ) != '' ? \S::seo( $seo_link[ $i ] ) : null,
|
|
'noindex' => $noindex[ $i ],
|
|
'copy_from' => $copy_from[ $i ] != '' ? $copy_from[ $i ] : null,
|
|
'block_direct_access' => $block_direct_access[ $i ]
|
|
] );
|
|
$i++;
|
|
}
|
|
else if ( is_array( $results ) and count( $results ) == 1 ) foreach ( $results as $row )
|
|
{
|
|
$mdb -> insert( 'pp_articles_langs', [
|
|
'article_id' => (int)$id,
|
|
'lang_id' => $row['id'],
|
|
'title' => $title != '' ? $title : null,
|
|
'main_image' => $main_image != '' ? $main_image : null,
|
|
'entry' => $entry != '' ? $entry : null,
|
|
'text' => $text != '' ? $text : null,
|
|
'table_of_contents' => $table_of_contents != '' ? $table_of_contents : null,
|
|
'meta_title' => $meta_title != '' ? $meta_title : null,
|
|
'meta_description' => $meta_description != '' ? $meta_description : null,
|
|
'meta_keywords' => $meta_keywords != '' ? $meta_keywords : null,
|
|
'seo_link' => \S::seo( $seo_link ) != '' ? \S::seo( $seo_link ) : null,
|
|
'noindex' => $noindex,
|
|
'copy_from' => $copy_from != '' ? $copy_from : null,
|
|
'block_direct_access' => $block_direct_access
|
|
] );
|
|
}
|
|
|
|
/* parametry bez wersji językowych */
|
|
$results = $mdb -> select( 'pp_articles_additional_params', '*', [ 'AND' => [ 'status' => 1, 'language' => 0 ] ] );
|
|
if ( is_array( $results ) and !empty( $results ) ) foreach ( $results as $row )
|
|
{
|
|
$mdb -> insert( 'pp_articles_additional_values', [
|
|
'param_id' => $row['id'],
|
|
'value' => $params[ 'ap_' . $row['name'] ],
|
|
'article_id' => (int)$id,
|
|
'language_id' => null
|
|
] );
|
|
}
|
|
|
|
/* strony */
|
|
if ( is_array( $pages ) ) foreach ( $pages as $page )
|
|
{
|
|
$order = self::max_order() + 1;
|
|
|
|
$mdb -> insert( 'pp_articles_pages', [
|
|
'article_id' => (int)$id,
|
|
'page_id' => (int)$page,
|
|
'o' => (int)$order
|
|
] );
|
|
}
|
|
else if ( $pages )
|
|
{
|
|
$order = self::max_order() + 1;
|
|
|
|
$mdb -> insert( 'pp_articles_pages', [
|
|
'article_id' => (int)$id,
|
|
'page_id' => (int)$pages,
|
|
'o' => (int)$order
|
|
] );
|
|
}
|
|
|
|
/* pliki */
|
|
$results = $mdb -> select( 'pp_articles_files', '*', [ 'article_id' => null ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
{
|
|
$dir = '/upload/article_files/article_' . $id;
|
|
|
|
$new_file_name = str_replace( '/upload/article_files/tmp', $dir, $row['src'] );
|
|
|
|
if ( file_exists( '..' . $row['src'] ) )
|
|
{
|
|
if ( !is_dir( '../' . $dir ) and $created !== true )
|
|
{
|
|
if ( mkdir( '../' . $dir, 0755, true ) )
|
|
$created = true;
|
|
}
|
|
rename( '..' . $row['src'], '..' . $new_file_name );
|
|
}
|
|
|
|
$mdb -> update( 'pp_articles_files', [ 'src' => $new_file_name, 'article_id' => $id ], [ 'id' => $row['id'] ] );
|
|
}
|
|
|
|
$created = false;
|
|
|
|
/* zdjęcia */
|
|
$results = $mdb -> select( 'pp_articles_images', '*', [ 'article_id' => null ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
{
|
|
$dir = '/upload/article_images/article_' . $id;
|
|
|
|
$new_file_name = str_replace( '/upload/article_images/tmp', $dir, $row['src'] );
|
|
|
|
if ( file_exists( '../' . $new_file_name ) )
|
|
{
|
|
$ext = strrpos( $new_file_name, '.' );
|
|
$fileName_a = substr( $new_file_name, 0, $ext );
|
|
$fileName_b = substr( $new_file_name, $ext );
|
|
|
|
$count = 1;
|
|
|
|
while ( file_exists( '../' . $fileName_a . '_' . $count . $fileName_b ) )
|
|
$count++;
|
|
|
|
$new_file_name = $fileName_a . '_' . $count . $fileName_b;
|
|
}
|
|
|
|
if ( file_exists( '..' . $row['src'] ) )
|
|
{
|
|
if ( !is_dir( '../' . $dir ) and $created !== true )
|
|
{
|
|
if ( mkdir( '../' . $dir, 0755, true ) )
|
|
$created = true;
|
|
}
|
|
rename( '..' . $row['src'], '..' . $new_file_name );
|
|
}
|
|
|
|
$mdb -> update( 'pp_articles_images', [ 'src' => $new_file_name, 'article_id' => (int)$id ], [ 'id' => $row['id'] ] );
|
|
}
|
|
|
|
/* tagi */
|
|
$tags = explode( ',', $tags );
|
|
if ( is_array( $tags ) ) foreach ( $tags as $tag )
|
|
{
|
|
if ( trim( $tag ) != '' )
|
|
{
|
|
$tag_id = $mdb -> get( 'pp_tags', 'id', [ 'name' => $tag ] );
|
|
if ( !$tag_id )
|
|
{
|
|
$mdb -> insert( 'pp_tags', [ 'name' => $tag ] );
|
|
$tag_id = $mdb -> id();
|
|
}
|
|
|
|
$mdb -> insert( 'pp_articles_tags', [ 'article_id' => (int)$id, 'tag_id' => (int)$tag_id ] );
|
|
}
|
|
}
|
|
|
|
\S::htacces();
|
|
\S::delete_cache();
|
|
|
|
return $id;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
$mdb -> update( 'pp_articles', [
|
|
'show_title' => $show_title == 'on' ? 1 : 0,
|
|
'show_date_add' => $show_date_add == 'on' ? 1 : 0,
|
|
'show_date_modify' => $show_date_modify == 'on' ? 1 : 0,
|
|
'date_modify' => date( 'Y-m-d H:i:s' ),
|
|
'modify_by' => $user['id'],
|
|
'layout_id' => $layout_id ? (int)$layout_id : null,
|
|
'status' => $status == 'on' ? 1 : 0,
|
|
'repeat_entry' => $repeat_entry == 'on' ? 1 : 0,
|
|
'social_icons' => $social_icons == 'on' ? 1 : 0,
|
|
'date_start' => $event_date[0] ? $event_date[0] : null,
|
|
'date_end' => $event_date[1] ? $event_date[1] : null,
|
|
'priority' => $priority == 'on' ? 1 : 0,
|
|
'password' => $password ? $password : null,
|
|
'pixieset' => $pixieset,
|
|
'id_author' => $id_author ? $id_author : null
|
|
], [
|
|
'id' => (int)$article_id
|
|
] );
|
|
|
|
if ( $date_add )
|
|
$mdb -> update( 'pp_articles', [ 'date_add' => $date_add ], [ 'id' => (int)$article_id ] );
|
|
|
|
$i = 0;
|
|
|
|
/* tłumaczenia */
|
|
$mdb -> delete( 'pp_articles_langs', [ 'article_id' => (int)$article_id ] );
|
|
|
|
$results = $mdb -> select( 'pp_langs', [ 'id' ], [ 'status' => 1, 'ORDER' => [ 'o' => 'ASC' ] ] );
|
|
if ( is_array( $results ) and count( $results ) > 1 ) foreach ( $results as $row )
|
|
{
|
|
$mdb -> insert( 'pp_articles_langs', [
|
|
'article_id' => (int)$article_id,
|
|
'lang_id' => $row['id'],
|
|
'title' => $title[ $i ] != '' ? $title[ $i ] : null,
|
|
'main_image' => $main_image[$i] != '' ? $main_image[$i] : null,
|
|
'entry' => $entry[ $i ] != '' ? $entry[ $i ] : null,
|
|
'text' => $text[ $i ] != '' ? $text[ $i ] : null,
|
|
'table_of_contents' => $table_of_contents[$i] != '' ? $table_of_contents[$i] : null,
|
|
'meta_title' => $meta_title[ $i ] != '' ? $meta_title[ $i ] : null,
|
|
'meta_description' => $meta_description[ $i ] != '' ? $meta_description[ $i ] : null,
|
|
'meta_keywords' => $meta_keywords[ $i ] != '' ? $meta_keywords[ $i ] : null,
|
|
'seo_link' => \S::seo( $seo_link[ $i ] ) != '' ? \S::seo( $seo_link[ $i ] ) : null,
|
|
'noindex' => $noindex[ $i ],
|
|
'copy_from' => $copy_from[ $i ] != '' ? $copy_from[ $i ] : null,
|
|
'block_direct_access' => $block_direct_access[ $i ]
|
|
] );
|
|
$i++;
|
|
}
|
|
else if ( is_array( $results ) and count( $results ) == 1 ) foreach ( $results as $row )
|
|
{
|
|
$mdb -> insert( 'pp_articles_langs', [
|
|
'article_id' => (int)$article_id,
|
|
'lang_id' => $row['id'],
|
|
'title' => $title != '' ? $title : null,
|
|
'main_image' => $main_image != '' ? $main_image : null,
|
|
'entry' => $entry != '' ? $entry : null,
|
|
'text' => $text != '' ? $text : null,
|
|
'table_of_contents' => $table_of_contents != '' ? $table_of_contents : null,
|
|
'meta_title' => $meta_title != '' ? $meta_title : null,
|
|
'meta_description' => $meta_description != '' ? $meta_description : null,
|
|
'meta_keywords' => $meta_keywords != '' ? $meta_keywords : null,
|
|
'seo_link' => \S::seo( $seo_link ) != '' ? \S::seo( $seo_link ) : null,
|
|
'noindex' => $noindex,
|
|
'copy_from' => $copy_from != '' ? $copy_from : null,
|
|
'block_direct_access' => $block_direct_access
|
|
] );
|
|
}
|
|
|
|
/* dodatkowe parametry */
|
|
$mdb -> delete( 'pp_articles_additional_values', [ 'article_id' => (int)$article_id ] );
|
|
|
|
/* parametry bez wersji językowych */
|
|
$results = $mdb -> select( 'pp_articles_additional_params', '*', [ 'AND' => [ 'status' => 1, 'language' => 0 ] ] );
|
|
if ( is_array( $results ) and !empty( $results ) ) foreach ( $results as $row )
|
|
{
|
|
$mdb -> insert( 'pp_articles_additional_values', [
|
|
'param_id' => $row['id'],
|
|
'value' => $params[ 'ap_' . $row['name'] ],
|
|
'article_id' => (int)$article_id,
|
|
'language_id' => null
|
|
] );
|
|
}
|
|
|
|
/* parametry z wersjami językowymi */
|
|
$results = $mdb -> select( 'pp_articles_additional_params', '*', [ 'AND' => [ 'status' => 1, 'language' => 1 ] ] );
|
|
if ( is_array( $results ) and !empty( $results ) ) foreach ( $results as $row )
|
|
{
|
|
$results2 = $mdb -> select( 'pp_langs', [ 'id' ], [ 'status' => 1, 'ORDER' => [ 'o' => 'ASC' ] ] );
|
|
if ( is_array( $results2 ) ) foreach ( $results2 as $row2 )
|
|
{
|
|
$mdb -> insert( 'pp_articles_additional_values', [
|
|
'param_id' => $row['id'],
|
|
'value' => $params[ 'ap_' . $row['name'] . '_' . $row2['id'] ],
|
|
'article_id' => (int)$article_id,
|
|
'language_id' => $row2['id']
|
|
] );
|
|
}
|
|
}
|
|
|
|
/* strony */
|
|
$not_in = [ 0 ];
|
|
|
|
if ( is_array( $pages ) ) foreach ( $pages as $page )
|
|
$not_in[] = $page;
|
|
else if ( $pages )
|
|
$not_in[] = $pages;
|
|
|
|
$mdb -> delete( 'pp_articles_pages', [ 'AND' => [ 'article_id' => (int)$article_id, 'page_id[!]' => $not_in ] ] );
|
|
|
|
$pages_tmp = $mdb -> select( 'pp_articles_pages', 'page_id', [ 'article_id' => (int)$article_id ] );
|
|
|
|
if ( !is_array( $pages ) )
|
|
$pages = [ $pages ];
|
|
|
|
$pages = array_diff( $pages, $pages_tmp );
|
|
|
|
if ( is_array( $pages ) ) foreach ( $pages as $page )
|
|
{
|
|
$order = self::max_order() + 1;
|
|
|
|
$mdb -> insert( 'pp_articles_pages', [
|
|
'article_id' => (int)$article_id,
|
|
'page_id' => (int)$page,
|
|
'o' => (int)$order
|
|
] );
|
|
}
|
|
|
|
/* pliki */
|
|
$results = $mdb -> select( 'pp_articles_files', '*', [ 'article_id' => null ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
{
|
|
$dir = '/upload/article_files/article_' . $article_id;
|
|
|
|
$new_file_name = str_replace( '/upload/article_files/tmp', $dir, $row['src'] );
|
|
|
|
if ( file_exists( '..' . $row['src'] ) )
|
|
{
|
|
if ( !is_dir( '../' . $dir ) and $created !== true )
|
|
{
|
|
if ( mkdir( '../' . $dir, 0755, true ) )
|
|
$created = true;
|
|
}
|
|
rename( '..' . $row['src'], '..' . $new_file_name );
|
|
}
|
|
|
|
$mdb -> update( 'pp_articles_files', [ 'src' => $new_file_name, 'article_id' => (int)$article_id ], [ 'id' => $row['id'] ] );
|
|
}
|
|
|
|
$created = false;
|
|
|
|
/* zdjęcia */
|
|
$results = $mdb -> select( 'pp_articles_images', '*', [ 'article_id' => null ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
{
|
|
$dir = '/upload/article_images/article_' . $article_id;
|
|
|
|
$new_file_name = str_replace( '/upload/article_images/tmp', $dir, $row['src'] );
|
|
|
|
if ( file_exists( '../' . $new_file_name ) )
|
|
{
|
|
$ext = strrpos( $new_file_name, '.' );
|
|
$fileName_a = substr( $new_file_name, 0, $ext );
|
|
$fileName_b = substr( $new_file_name, $ext );
|
|
|
|
$count = 1;
|
|
|
|
while ( file_exists( '../' . $fileName_a . '_' . $count . $fileName_b ) )
|
|
$count++;
|
|
|
|
$new_file_name = $fileName_a . '_' . $count . $fileName_b;
|
|
}
|
|
|
|
if ( file_exists( '..' . $row['src'] ) )
|
|
{
|
|
if ( !is_dir( '../' . $dir ) and $created !== true )
|
|
{
|
|
if ( mkdir( '../' . $dir, 0755, true ) )
|
|
$created = true;
|
|
}
|
|
rename( '..' . $row['src'], '..' . $new_file_name );
|
|
}
|
|
|
|
$mdb -> update( 'pp_articles_images', [ 'src' => $new_file_name, 'article_id' => (int)$article_id ], [ 'id' => $row['id'] ] );
|
|
}
|
|
|
|
$results = $mdb -> select( 'pp_articles_images', '*', [ 'AND' => [ 'article_id' => (int)$article_id, 'to_delete' => 1 ] ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
{
|
|
if ( file_exists( '../' . $row['src'] ) )
|
|
unlink( '../' . $row['src'] );
|
|
}
|
|
|
|
$mdb -> delete( 'pp_articles_images', [ 'AND' => [ 'article_id' => (int)$article_id, 'to_delete' => 1 ] ] );
|
|
|
|
$results = $mdb -> select( 'pp_articles_files', '*', [ 'AND' => [ 'article_id' => (int)$article_id, 'to_delete' => 1 ] ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
{
|
|
if ( file_exists( '../' . $row['src'] ) )
|
|
unlink( '../' . $row['src'] );
|
|
}
|
|
|
|
$mdb -> delete( 'pp_articles_files', [ 'AND' => [ 'article_id' => (int)$article_id, 'to_delete' => 1 ] ] );
|
|
|
|
/* tagi */
|
|
$mdb -> delete( 'pp_articles_tags', [ 'article_id' => (int)$article_id ] );
|
|
|
|
$tags = explode( ',', $tags );
|
|
if ( is_array( $tags ) ) foreach ( $tags as $tag )
|
|
{
|
|
if ( trim( $tag ) != '' )
|
|
{
|
|
$tag_id = $mdb -> get( 'pp_tags', 'id', [ 'name' => $tag ] );
|
|
if ( !$tag_id )
|
|
{
|
|
$mdb -> insert( 'pp_tags', [ 'name' => $tag ] );
|
|
$tag_id = $mdb -> id();
|
|
}
|
|
|
|
$mdb -> insert( 'pp_articles_tags', [ 'article_id' => (int)$article_id, 'tag_id' => (int)$tag_id ] );
|
|
}
|
|
}
|
|
|
|
\S::htacces();
|
|
\S::delete_cache();
|
|
return $article_id;
|
|
}
|
|
}
|
|
|
|
public static function delete_nonassigned_files()
|
|
{
|
|
global $mdb;
|
|
|
|
$results = $mdb -> select( 'pp_articles_files', '*', [ 'article_id' => null ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
{
|
|
if ( file_exists( '../' . $row['src'] ) )
|
|
unlink( '../' . $row['src'] );
|
|
}
|
|
|
|
$mdb -> delete( 'pp_articles_files', [ 'article_id' => null ] );
|
|
}
|
|
|
|
public static function delete_nonassigned_images()
|
|
{
|
|
global $mdb;
|
|
|
|
$results = $mdb -> select( 'pp_articles_images', '*', [ 'article_id' => null ] );
|
|
if ( is_array( $results ) ) foreach ( $results as $row )
|
|
{
|
|
if ( file_exists( '../' . $row['src'] ) )
|
|
unlink( '../' . $row['src'] );
|
|
}
|
|
|
|
$mdb -> delete( 'pp_articles_images', [ 'article_id' => null ] );
|
|
}
|
|
}
|
|
?>
|