273 lines
9.5 KiB
PHP
273 lines
9.5 KiB
PHP
<?PHP
|
||
|
||
require_once('api/Simpla.php');
|
||
|
||
class ArticleAdmin extends Simpla
|
||
{
|
||
private $allowed_image_extentions = array('png', 'gif', 'jpg', 'jpeg', 'ico');
|
||
public function fetch()
|
||
{
|
||
$product_categories = array();
|
||
$article = new StdClass;
|
||
if($this->request->method('post'))
|
||
{
|
||
|
||
|
||
|
||
$article->id = $this->request->post('id', 'integer');
|
||
$article->name = $this->request->post('name');
|
||
$article->date = date('Y-m-d', strtotime($this->request->post('date')));
|
||
|
||
$article->visible = $this->request->post('visible', 'boolean');
|
||
|
||
$article->category_id = $this->request->post('category_id', 'integer');
|
||
|
||
$article->url = $this->request->post('url', 'string');
|
||
$article->meta_title = $this->request->post('meta_title');
|
||
$article->meta_keywords = $this->request->post('meta_keywords');
|
||
$article->meta_description = $this->request->post('meta_description');
|
||
$article->annotation = $this->request->post('annotation');
|
||
|
||
$article->text = $this->request->post('body');
|
||
|
||
// Категории товара
|
||
$article_categories = $this->request->post('categories');
|
||
if(is_array($article_categories))
|
||
{
|
||
foreach($article_categories as $c)
|
||
$pc[]->id = $c;
|
||
$article_categories = $pc;
|
||
}
|
||
|
||
|
||
// Связанные товары
|
||
if(is_array($this->request->post('related_products')))
|
||
{
|
||
foreach($this->request->post('related_products') as $p)
|
||
{
|
||
$rp[$p]->related_id = $p;
|
||
$rp[$p]->type = 'product';
|
||
}
|
||
$related_objects = $rp;
|
||
}
|
||
|
||
// Связанные статьи
|
||
if(is_array($this->request->post('related_articles')))
|
||
{
|
||
foreach($this->request->post('related_articles') as $p)
|
||
{
|
||
$rp[$p]->related_id = $p;
|
||
$rp[$p]->type = 'article';
|
||
}
|
||
$related_objects = $rp;
|
||
}
|
||
|
||
// Не допустить одинаковые URL разделов.
|
||
if(($a = $this->articles->get_article($article->url)) && $a->id!=$article->id)
|
||
{
|
||
$this->design->assign('message_error', 'url_exists');
|
||
}
|
||
else
|
||
{
|
||
if(empty($article->id))
|
||
{
|
||
$article->id = $this->articles->add_article($article);
|
||
$article = $this->articles->get_article($article->id);
|
||
$this->design->assign('message_success', 'added');
|
||
}
|
||
else
|
||
{
|
||
$this->articles->update_article($article->id, $article);
|
||
$article = $this->articles->get_article($article->id);
|
||
$this->design->assign('message_success', 'updated');
|
||
}
|
||
|
||
|
||
// Удаление изображения
|
||
if($this->request->post('delete_image'))
|
||
{
|
||
$this->articles->delete_image($article->id);
|
||
}
|
||
// Загрузка изображения
|
||
$image = $this->request->files('image');
|
||
if(!empty($image['name']) && in_array(strtolower(pathinfo($image['name'], PATHINFO_EXTENSION)), $this->allowed_image_extentions))
|
||
{
|
||
$image['name'] = $this->rus_lat($image['name']);
|
||
if ($image_name = $this->image->upload_image($image['tmp_name'], $image['name']))
|
||
{
|
||
$this->articles->delete_image($article->id);
|
||
$this->articles->update_article($article->id, array('image'=>$image_name));
|
||
$article->image =$image_name;
|
||
}
|
||
else
|
||
{
|
||
$this->design->assign('error', 'error uploading image');
|
||
}
|
||
}
|
||
|
||
|
||
}
|
||
|
||
// Связанные объекты
|
||
$query = $this->db->placehold('DELETE FROM __article_objects WHERE article_id=?', $article->id);
|
||
$this->db->query($query);
|
||
if(is_array($related_objects))
|
||
{
|
||
$pos = 0;
|
||
foreach($related_objects as $i=>$related_object)
|
||
$this->articles->add_related_object($article->id, $related_object->related_id, $related_object->type);
|
||
}
|
||
|
||
// Категории товара
|
||
$query = $this->db->placehold('DELETE FROM __articles_categories WHERE article_id=?', $article->id);
|
||
$this->db->query($query);
|
||
if(is_array($article_categories))
|
||
{
|
||
foreach($article_categories as $i=>$category)
|
||
$this->articles->add_article_category($article->id, $category->id, $i);
|
||
}
|
||
|
||
$this->db->query('DELETE FROM __article_models WHERE article_id=' . (int)$article->id);
|
||
$this->db->query('DELETE FROM __article_pages WHERE article_id=' . (int)$article->id);
|
||
$related_markas = $this->request->post('related_markas');
|
||
$related_models = $this->request->post('related_models');
|
||
$related_pages = $this->request->post('related_pages');
|
||
|
||
if($related_markas){
|
||
foreach($related_markas as $id) $this->db->query('INSERT INTO __article_models SET article_id=' . (int)$article->id . ", marka_id=".(int)$id.", model_id=0");
|
||
}
|
||
if($related_models){
|
||
|
||
foreach($related_models as $id){
|
||
$model = $this->model->get_model( (int)$id );
|
||
$this->db->query('INSERT INTO __article_models SET article_id=' . (int)$article->id . ", marka_id=".$model->marka->id.", model_id=" . $id);
|
||
}
|
||
}
|
||
if($related_pages){
|
||
foreach($related_pages as $id) $this->db->query('INSERT INTO __article_pages SET article_id=' . (int)$article->id . ", page_id=".(int)$id);
|
||
}
|
||
|
||
|
||
}
|
||
else
|
||
{
|
||
$article->id = $this->request->get('id', 'integer');
|
||
$article = $this->articles->get_article(intval($article->id));
|
||
}
|
||
|
||
|
||
|
||
if(!$article->id) $article->visible = 1;
|
||
|
||
if(empty($article->date)) $article->date = date($this->settings->date_format, time());
|
||
|
||
|
||
$this->design->assign('related_markas', $this->articles->get_related_markas($article->id) );
|
||
$this->design->assign('related_pages', $this->articles->get_related_pages($article->id) );
|
||
|
||
$related_models = $this->articles->get_related_models($article->id);
|
||
foreach($related_models as $row){
|
||
$marka = $this->marka->get_brand((int)$row->marka_id);
|
||
if($marka) $row->name = $marka->name . ' - ' . $row->name;
|
||
}
|
||
$this->design->assign('related_models', $related_models );
|
||
|
||
|
||
// Связанные объекты
|
||
$related_objects = $this->articles->get_related_objects(array('id'=>$article->id));
|
||
if(!empty($related_objects))
|
||
{
|
||
$r_products = array();
|
||
$r_articles = array();
|
||
|
||
foreach($related_objects as &$r_p)
|
||
if($r_p->type == 'product') $r_products[$r_p->object_id] = &$r_p;
|
||
elseif($r_p->type == 'article') $r_articles[$r_p->object_id] = &$r_p;
|
||
|
||
if(!empty($r_products)) {
|
||
$temp_products = $this->products->get_products(array('id'=>array_keys($r_products)));
|
||
foreach($temp_products as $temp_product)
|
||
$r_products[$temp_product->id] = $temp_product;
|
||
}
|
||
|
||
if(!empty($r_articles)) {
|
||
$temp_articles = $this->articles->get_articles(array('id'=>array_keys($r_articles)));
|
||
foreach($temp_articles as $temp_article)
|
||
$r_articles[$temp_article->id] = $temp_article;
|
||
}
|
||
|
||
$this->design->assign('related_products', $r_products);
|
||
$this->design->assign('related_articles', $r_articles);
|
||
}
|
||
// Категории товара
|
||
$article_categories = $this->articles->get_articles_categories_filter(array('article_id'=>/*mt1sk*//*$article->id*/(isset($article->id)) ? $article->id : -1/*/mt1sk*/));
|
||
|
||
$article->firstCategory = $article_categories ? reset($article_categories) : 0;
|
||
if(empty($article_categories))
|
||
{
|
||
if($category_id = $this->request->get('category_id'))
|
||
$article_categories[0]->id = $category_id;
|
||
else
|
||
$article_categories = array(1);
|
||
}
|
||
|
||
$this->design->assign('article_categories', $article_categories);
|
||
|
||
|
||
$categories = $this->articles->get_categories_tree();
|
||
$this->design->assign('categories', $categories);
|
||
$this->design->assign('article', $article);
|
||
|
||
|
||
$this->db->query("SELECT * FROM __article_photo WHERE article_id='" . $article->id . "' ORDER BY position, id DESC");
|
||
$photos = $this->db->results();
|
||
foreach($photos as $ph) $ph->img = Img::get('/files/article_photo/' . $ph->img, array('width'=>120, 'height'=>120));
|
||
$this->design->assign('article_photos', $photos);
|
||
|
||
|
||
//print_r($photos);die;
|
||
|
||
|
||
return $this->design->fetch('article.tpl');
|
||
}
|
||
|
||
function rus_lat($name){
|
||
$rus = array('','а','б','в','г','д','е','ё','Ё','ж','з','и','й','к',
|
||
'л','м','н','о','п','р','с','т','у','ф','х','ц','ч','ш','щ','ъ','ы','ь','э','ю','я');
|
||
$eng = array('','a','b','v','g','d','e','e','e','zh','z','i','j','k',
|
||
'l','m','n','o','p','r','s','t','u','f','h','c','ch','sh','shch','','y','','e','yu','ya');
|
||
$name = mb_strtolower($name,"UTF-8");
|
||
$name = str_replace(array('"',"'"),'',$name);
|
||
$name = str_replace(array(',',':',';','/','{','}','[',']'),'',$name);
|
||
$name = str_replace(array(' '),'_',$name);
|
||
$res = '';
|
||
$arr = $this->str_split_unicode($name);
|
||
foreach($arr as $key){
|
||
if($key == '_'){
|
||
$res .= '_';
|
||
continue;
|
||
}
|
||
if (!preg_match("/[а-я]/i", $key)){
|
||
$res .= $key;
|
||
continue;
|
||
}
|
||
$k = array_search($key,$rus);
|
||
if($k){
|
||
$res .= $eng[$k];
|
||
}
|
||
}
|
||
return $res;
|
||
}
|
||
|
||
function str_split_unicode($str, $l = 0) {
|
||
if ($l > 0) {
|
||
$ret = array();
|
||
$len = mb_strlen($str, "UTF-8");
|
||
for ($i = 0; $i < $len; $i += $l) {
|
||
$ret[] = mb_substr($str, $i, $l, "UTF-8");
|
||
}
|
||
return $ret;
|
||
}
|
||
return preg_split("//u", $str, -1, PREG_SPLIT_NO_EMPTY);
|
||
}
|
||
} |