Перейти до вмісту
Пошук в
  • Детальніше...
Шукати результати, які ...
Шукати результати в ...

erigins

Новачок
  
  • Публікації

    42
  • З нами

  • Відвідування

Повідомлення, опубліковані користувачем erigins

  1. Добрый день, подскажите в чем дело?

     

    В всплывающей корзине - в адресе картинок добавляются .....x_0.jpg

    Соответственно они не открываются --

     

    http://www.site.net/image/cache/data/SK-QFC4-x_0.jpg -- вот такое сейчас,

    http://www.site.net/image/cache/data/SK-QFC4-40x40.jpg - правильно

     

    post-691604-0-38499400-1434370719_thumb.jpg

  2. да,вплоть до создания своих стилей по принципу  

     

    product_id.css

     

    не вникал в подобные вопросы.

     

    Дядь, вам не пора на пенсию?

    Сколько не читал ваши говно- мессаджи - пользы от них ноль. Сильно не обижауйтесь только.

  3. Для Opencart 1.5.6 ни один из вариантов без доработки не подошел.

     

    В итоге сделал так:

    В файле catalog/cotroller/product/category.php

    В блоке

    $this->data['products'][] = array(
    	'product_id'  => $result['product_id'],
    	'thumb'       => $image,
    

    Добавил

    'popup'   => $this->model_tool_image->resize($image, $this->config->get('config_image_popup_width'), $this->config->get('config_image_popup_height')),

    В шаблоне категории catalog/view/theme/default/template/product/category.tpl вставил такую ссылку на большую картинку

    <?php echo $product['popup']; ?>

    Так же нужно перенести подключение Colorbox из product.tpl в header.tpl или footer.tpl

     

     

    Какая-то залуп@, не работает. Уже 2 дня мучаюсь. Хелп.

    Нужно сделать автоувеличение фото товара при наведении, в категории

     

     

    файл category.php

    <?php 
    class ControllerProductCategory extends Controller {  
    	public function index() { 
    		$this->language->load('product/category');
    		
    		$this->load->model('catalog/category');
    		
    		$this->load->model('catalog/product');
    		
    		$this->load->model('tool/image'); 
    		
    		if (isset($this->request->get['filter'])) {
    			$filter = $this->request->get['filter'];
    		} else {
    			$filter = '';
    		}
    				
    		if (isset($this->request->get['sort'])) {
    			$sort = $this->request->get['sort'];
    		} else {
    			$sort = 'p.sort_order';
    		}
    
    		if (isset($this->request->get['order'])) {
    			$order = $this->request->get['order'];
    		} else {
    			$order = 'ASC';
    		}
    		
    		if (isset($this->request->get['page'])) {
    			$page = $this->request->get['page'];
    		} else { 
    			$page = 1;
    		}	
    							
    		if (isset($this->request->get['limit'])) {
    			$limit = $this->request->get['limit'];
    		} else {
    			$limit = $this->config->get('config_catalog_limit');
    		}
    							
    		$this->data['breadcrumbs'] = array();
    
       		$this->data['breadcrumbs'][] = array(
           		'text'      => $this->language->get('text_home'),
    			'href'      => $this->url->link('common/home'),
           		'separator' => false
       		);	
    			
    		if (isset($this->request->get['path'])) {
    			$url = '';
    			
    			if (isset($this->request->get['sort'])) {
    				$url .= '&sort=' . $this->request->get['sort'];
    			}	
    
    			if (isset($this->request->get['order'])) {
    				$url .= '&order=' . $this->request->get['order'];
    			}	
    			
    			if (isset($this->request->get['limit'])) {
    				$url .= '&limit=' . $this->request->get['limit'];
    			}
    									
    			$path = '';
    		
    			$parts = explode('_', (string)$this->request->get['path']);
    		
    			$category_id = (int)array_pop($parts);
    		
    			foreach ($parts as $path_id) {
    				if (!$path) {
    					$path = (int)$path_id;
    				} else {
    					$path .= '_' . (int)$path_id;
    				}
    									
    				$category_info = $this->model_catalog_category->getCategory($path_id);
    				
    				if ($category_info) {
    	       			$this->data['breadcrumbs'][] = array(
       	    				'text'      => $category_info['name'],
    						'href'      => $this->url->link('product/category', 'path=' . $path . $url),
            				'separator' => $this->language->get('text_separator')
            			);
    				}
    			}
    		} else {
    			$category_id = 0;
    		}
    				
    		$category_info = $this->model_catalog_category->getCategory($category_id);
    	
    		if ($category_info) {
    	  		$this->document->setTitle($category_info['meta_keyword']);
    			$this->document->setDescription($category_info['meta_description']);
    			$this->document->setKeywords($category_info['meta_keyword']);
    			$this->document->addScript('catalog/view/javascript/jquery/jquery.total-storage.min.js');
    			
    			$this->data['heading_title'] = $category_info['name'];
    			
    			$this->data['text_refine'] = $this->language->get('text_refine');
    			$this->data['text_empty'] = $this->language->get('text_empty');			
    			$this->data['text_quantity'] = $this->language->get('text_quantity');
    			$this->data['text_manufacturer'] = $this->language->get('text_manufacturer');
    			$this->data['text_model'] = $this->language->get('text_model');
    			$this->data['text_price'] = $this->language->get('text_price');
    			$this->data['text_tax'] = $this->language->get('text_tax');
    			$this->data['text_points'] = $this->language->get('text_points');
    			$this->data['text_compare'] = sprintf($this->language->get('text_compare'), (isset($this->session->data['compare']) ? count($this->session->data['compare']) : 0));
    			$this->data['text_display'] = $this->language->get('text_display');
    			$this->data['text_list'] = $this->language->get('text_list');
    			$this->data['text_grid'] = $this->language->get('text_grid');
    			$this->data['text_sort'] = $this->language->get('text_sort');
    			$this->data['text_limit'] = $this->language->get('text_limit');
    					
    			$this->data['button_cart'] = $this->language->get('button_cart');
    			$this->data['button_wishlist'] = $this->language->get('button_wishlist');
    			$this->data['button_compare'] = $this->language->get('button_compare');
    			$this->data['button_continue'] = $this->language->get('button_continue');
    			
    			// Set the last category breadcrumb		
    			$url = '';
    			
    			if (isset($this->request->get['sort'])) {
    				$url .= '&sort=' . $this->request->get['sort'];
    			}	
    
    			if (isset($this->request->get['order'])) {
    				$url .= '&order=' . $this->request->get['order'];
    			}	
    			
    			if (isset($this->request->get['page'])) {
    				$url .= '&page=' . $this->request->get['page'];
    			}
    			
    			if (isset($this->request->get['limit'])) {
    				$url .= '&limit=' . $this->request->get['limit'];
    			}
    									
    			$this->data['breadcrumbs'][] = array(
    				'text'      => $category_info['name'],
    				'href'      => $this->url->link('product/category', 'path=' . $this->request->get['path']),
    				'separator' => $this->language->get('text_separator')
    			);
    								
    			if ($category_info['image']) {
    				$this->data['thumb'] = $this->model_tool_image->resize($category_info['image'], $this->config->get('config_image_category_width'), $this->config->get('config_image_category_height'));
    			} else {
    				$this->data['thumb'] = '';
    			}
    									
    			$this->data['description'] = html_entity_decode($category_info['description'], ENT_QUOTES, 'UTF-8');
    			$this->data['compare'] = $this->url->link('product/compare');
    			
    			$url = '';
    			
    			if (isset($this->request->get['filter'])) {
    				$url .= '&filter=' . $this->request->get['filter'];
    			}	
    						
    			if (isset($this->request->get['sort'])) {
    				$url .= '&sort=' . $this->request->get['sort'];
    			}	
    
    			if (isset($this->request->get['order'])) {
    				$url .= '&order=' . $this->request->get['order'];
    			}	
    			
    			if (isset($this->request->get['limit'])) {
    				$url .= '&limit=' . $this->request->get['limit'];
    			}
    								
    			$this->data['categories'] = array();
    			
    			$results = $this->model_catalog_category->getCategories($category_id);
    			
    			foreach ($results as $result) {
    				$data = array(
    					'filter_category_id'  => $result['category_id'],
    					'filter_sub_category' => true
    				);
    				
    				$product_total = $this->model_catalog_product->getTotalProducts($data);				
    				
    				$this->data['categories'][] = array(
    					'name'  => $result['name'] . ($this->config->get('config_product_count') ? ' (' . $product_total . ')' : ''),
    					'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '_' . $result['category_id'] . $url)
    				);
    			}
    			
    			$this->data['products'] = array();
    			
    			$data = array(
    				'filter_category_id' => $category_id,
    				'filter_sub_category' => true,
    				'filter_filter'      => $filter, 
    				'sort'               => $sort,
    				'order'              => $order,
    				'start'              => ($page - 1) * $limit,
    				'limit'              => $limit
    			);
    				
                            
                            		$this->data['config_newproduct'] = $this->config->get('config_newproduct');
    		$this->data['config_display_newproduct'] = $this->config->get('config_display_newproduct');
    		$this->data['config_display_popularproduct'] = $this->config->get('config_display_popularproduct');
    		$this->data['config_popularproduct'] = $this->config->get('config_popularproduct');
    		$this->data['config_display_specialsproduct'] = $this->config->get('config_display_specialsproduct');
    		$this->data['config_display_availableproduct'] = $this->config->get('config_display_availableproduct');            
                
                            
    			$product_total = $this->model_catalog_product->getTotalProducts($data); 
    			
    			//$results = $this->model_catalog_product->getProducts($data);
    
    			$results = $this->model_catalog_product->getProducts($data);
    			//Вызов метода getFoundProducts должен проводится сразу же после getProducts
    			//только тогда он выдает правильное значения количества товаров
    			//$product_total = $this->model_catalog_product->getFoundProducts(); 
    			
    			foreach ($results as $result) {
    				if ($result['image']) {
    					$image = $this->model_tool_image->resize($result['image'], $this->config->get('config_image_product_width'), $this->config->get('config_image_product_height'));
    				} else {
    					$image = false;
    				}
    				
    				if (($this->config->get('config_customer_price') && $this->customer->isLogged()) || !$this->config->get('config_customer_price')) {
    					$price = $this->currency->format($this->tax->calculate($result['price'], $result['tax_class_id'], $this->config->get('config_tax')));
    				} else {
    					$price = false;
    				}
    				
    				if ((float)$result['special']) {
    					$special = $this->currency->format($this->tax->calculate($result['special'], $result['tax_class_id'], $this->config->get('config_tax')));
    				} else {
    					$special = false;
    				}	
    				
    				if ($this->config->get('config_tax')) {
    					$tax = $this->currency->format((float)$result['special'] ? $result['special'] : $result['price']);
    				} else {
    					$tax = false;
    				}				
    				
    				if ($this->config->get('config_review_status')) {
    					$rating = (int)$result['rating'];
    				} else {
    					$rating = false;
    				}
    								
    				$this->data['products'][] = array(
    					'product_id'  => $result['product_id'],
    					'thumb'       => $image,
    					'name'        => $result['name'],
    					'description' => utf8_substr(strip_tags(html_entity_decode($result['description'], ENT_QUOTES, 'UTF-8')), 0, 100) . '..',
    					'price'       => $price,
    					'special'     => $special,
    					'onorder'     => $result['onorder'],
    					'tax'         => $tax,
    					'rating'      => $result['rating'],
                                                                        'quantity'      => $result['quantity'],
                                    'date_available'      => $result['date_available'],
                                    'viewed'      => $result['viewed'],
    					'reviews'     => sprintf($this->language->get('text_reviews'), (int)$result['reviews']),
    					'href'        => $this->url->link('product/product', 'path=' . $this->request->get['path'] . '&product_id=' . $result['product_id'] . $url)
    				);
    			}
    			
    			$url = '';
    			
    			if (isset($this->request->get['filter'])) {
    				$url .= '&filter=' . $this->request->get['filter'];
    			}
    				
    			if (isset($this->request->get['limit'])) {
    				$url .= '&limit=' . $this->request->get['limit'];
    			}
    										
    			$this->data['sorts'] = array();
    			
    			$this->data['sorts'][] = array(
    				'text'  => $this->language->get('text_default'),
    				'value' => 'p.sort_order-ASC',
    				'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=p.sort_order&order=ASC' . $url)
    			);
    			
    			$this->data['sorts'][] = array(
    				'text'  => $this->language->get('text_name_asc'),
    				'value' => 'pd.name-ASC',
    				'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=pd.name&order=ASC' . $url)
    			);
    
    			$this->data['sorts'][] = array(
    				'text'  => $this->language->get('text_name_desc'),
    				'value' => 'pd.name-DESC',
    				'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=pd.name&order=DESC' . $url)
    			);
    
    			$this->data['sorts'][] = array(
    				'text'  => $this->language->get('text_price_asc'),
    				'value' => 'p.price-ASC',
    				'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=p.price&order=ASC' . $url)
    			); 
    
    			$this->data['sorts'][] = array(
    				'text'  => $this->language->get('text_price_desc'),
    				'value' => 'p.price-DESC',
    				'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=p.price&order=DESC' . $url)
    			); 
    			
    			if ($this->config->get('config_review_status')) {
    				$this->data['sorts'][] = array(
    					'text'  => $this->language->get('text_rating_desc'),
    					'value' => 'rating-DESC',
    					'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=rating&order=DESC' . $url)
    				); 
    				
    				$this->data['sorts'][] = array(
    					'text'  => $this->language->get('text_rating_asc'),
    					'value' => 'rating-ASC',
    					'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=rating&order=ASC' . $url)
    				);
    			}
    			
    			$this->data['sorts'][] = array(
    				'text'  => $this->language->get('text_model_asc'),
    				'value' => 'p.model-ASC',
    				'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=p.model&order=ASC' . $url)
    			);
    
    			$this->data['sorts'][] = array(
    				'text'  => $this->language->get('text_model_desc'),
    				'value' => 'p.model-DESC',
    				'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . '&sort=p.model&order=DESC' . $url)
    			);
    			
    			$url = '';
    			
    			if (isset($this->request->get['filter'])) {
    				$url .= '&filter=' . $this->request->get['filter'];
    			}
    				
    			if (isset($this->request->get['sort'])) {
    				$url .= '&sort=' . $this->request->get['sort'];
    			}	
    
    			if (isset($this->request->get['order'])) {
    				$url .= '&order=' . $this->request->get['order'];
    			}
    			
    			$this->data['limits'] = array();
    	
    			$limits = array_unique(array($this->config->get('config_catalog_limit'), 25, 50, 75, 100));
    			
    			sort($limits);
    	
    			foreach($limits as $limits){
    				$this->data['limits'][] = array(
    					'text'  => $limits,
    					'value' => $limits,
    					'href'  => $this->url->link('product/category', 'path=' . $this->request->get['path'] . $url . '&limit=' . $limits)
    				);
    			}
    			
    			$url = '';
    			
    			if (isset($this->request->get['filter'])) {
    				$url .= '&filter=' . $this->request->get['filter'];
    			}
    				
    			if (isset($this->request->get['sort'])) {
    				$url .= '&sort=' . $this->request->get['sort'];
    			}	
    
    			if (isset($this->request->get['order'])) {
    				$url .= '&order=' . $this->request->get['order'];
    			}
    	
    			if (isset($this->request->get['limit'])) {
    				$url .= '&limit=' . $this->request->get['limit'];
    			}
    					
    			$pagination = new Pagination();
    			$pagination->total = $product_total;
    			$pagination->page = $page;
    			$pagination->limit = $limit;
    			$pagination->text = $this->language->get('text_pagination');
    			$pagination->url = $this->url->link('product/category', 'path=' . $this->request->get['path'] . $url . '&page={page}');
    		
    			$this->data['pagination'] = $pagination->render();
    		
    			$this->data['sort'] = $sort;
    			$this->data['order'] = $order;
    			$this->data['limit'] = $limit;
    		
    			$this->data['continue'] = $this->url->link('common/home');
    
    			if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/product/category_v2.tpl')) {
    				$this->template = $this->config->get('config_template') . '/template/product/category_v2.tpl';
    			} else {
    				$this->template = 'default/template/product/category.tpl';
    			}
    			
    			$this->children = array(
    				'common/column_left',
    				'common/column_right',
    				'common/content_top',
    				'common/content_bottom',
    				'common/footer',
    				'common/header'
    			);
    				
    			$this->response->setOutput($this->render());										
        	} else {
    			$url = '';
    			
    			if (isset($this->request->get['path'])) {
    				$url .= '&path=' . $this->request->get['path'];
    			}
    			
    			if (isset($this->request->get['filter'])) {
    				$url .= '&filter=' . $this->request->get['filter'];
    			}
    												
    			if (isset($this->request->get['sort'])) {
    				$url .= '&sort=' . $this->request->get['sort'];
    			}	
    
    			if (isset($this->request->get['order'])) {
    				$url .= '&order=' . $this->request->get['order'];
    			}
    				
    			if (isset($this->request->get['page'])) {
    				$url .= '&page=' . $this->request->get['page'];
    			}
    						
    			if (isset($this->request->get['limit'])) {
    				$url .= '&limit=' . $this->request->get['limit'];
    			}
    						
    			$this->data['breadcrumbs'][] = array(
    				'text'      => $this->language->get('text_error'),
    				'href'      => $this->url->link('product/category', $url),
    				'separator' => $this->language->get('text_separator')
    			);
    				
    			$this->document->setTitle($this->language->get('text_error'));
    
          		$this->data['heading_title'] = $this->language->get('text_error');
    
          		$this->data['text_error'] = $this->language->get('text_error');
    
          		$this->data['button_continue'] = $this->language->get('button_continue');
    
          		$this->data['continue'] = $this->url->link('common/home');
    
    			if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/error/not_found.tpl')) {
    				$this->template = $this->config->get('config_template') . '/template/error/not_found.tpl';
    			} else {
    				$this->template = 'default/template/error/not_found.tpl';
    			}
    			
    			$this->children = array(
    				'common/column_left',
    				'common/column_right',
    				'common/content_top',
    				'common/content_bottom',
    				'common/footer',
    				'common/header'
    			);
    					
    			$this->response->setOutput($this->render());
    		}
      	}
    }
    ?>
    

    файл category.TPL

    <?php echo $header; ?>
    <div class="center">  
      <?php if ($products) { ?>
    <div class="page">
    <h1 class="firstWord"><?php echo $heading_title; ?></h1><div class="floatright">      <select onchange="location = this.value;">
            <?php foreach ($sorts as $sorts) { ?>
            <?php if ($sorts['value'] == $sort . '-' . $order) { ?>
            <option value="<?php echo $sorts['href']; ?>" selected="selected"><?php echo $sorts['text']; ?></option>
            <?php } else { ?>
            <option value="<?php echo $sorts['href']; ?>"><?php echo $sorts['text']; ?></option>
            <?php } ?>
            <?php } ?>
          </select></div>
    <div class="zz"></div>
    <div class="acdc"></div>
      <div class="breadcrumbs">
        <?php foreach ($breadcrumbs as $breadcrumb) { ?>
        <span>/</span><a href="<?php echo $breadcrumb['href']; ?>"><?php echo $breadcrumb['text']; ?></a>
        <?php } ?>
      </div>
    <noindex><div class="acdc"></div>
    <div class="filter-border">
    <div class="filter">
    <?php echo $column_left; ?>
    </div>
    </div></noindex>
    <div class="products">
       <?php foreach ($products as $product) { ?>
    <div class="item">
          <?php if ($product['thumb']) { ?>
        <a href="<?php echo $product['href']; ?>">
            <?php if ($config_display_popularproduct) { ?>
    <?php if (($product['viewed']) > ($config_popularproduct)) { ?><div class="popularlabel"></div><?php } ?>
    <?php } ?>	
    	
    <?php if ($config_display_specialsproduct) { ?>
    <?php if ($product['price'] && $product['special']) { ?><div class="speciallabel"></div> 
    <?php } ?>
    <?php } ?>	
    	
    <?php if ($config_display_availableproduct) { ?>
    <?php if (($product['quantity']) <= 0){ ?>	
    	<?php if (($product['onorder']) == 1){ ?>
    	<div class="soldlabel"></div>
        <?php } else { ?>
        <div class="noproductlabel"></div>
        <?php } ?>
    <?php } ?>
    <?php } ?>
            <img src="<?php echo $product['thumb']; ?>" title="<?php echo $product['name']; ?>" alt="<?php echo $product['name']; ?>" /></a>
               <?php } else { ?>
    	  <a href="<?php echo $product['href']; ?>">
    <?php if ($config_display_popularproduct) { ?>
    <?php if (($product['viewed']) > ($config_popularproduct)) { ?><div class="popularlabel"></div><?php } ?>
    <?php } ?>	
    	
    <?php if ($config_display_specialsproduct) { ?>
    <?php if ($product['price'] && $product['special']) { ?><div class="speciallabel"></div> 
    <?php } ?>
    <?php } ?>	
    	
    <?php if ($config_display_availableproduct) { ?>
    <?php if (($product['quantity']) <= 0){ ?>
    	<?php if (($product['onorder']) == 1){ ?>
    	<div class="soldlabel"></div>
        <?php } else { ?>
        <div class="noproductlabel"></div>
        <?php } ?>
    <?php } ?>
    <?php } ?>              
                  <img src="/catalog/view/theme/confiseur/image/noimage.jpg" title="<?php echo $product['name']; ?>" alt="<?php echo $product['name']; ?>" /></a>
    	  <?php } ?>
    <div class="title-height"><a class="t" href="<?php echo $product['href']; ?>"><?php echo $product['name']; ?></a></div> 
    <div class="cart-panel">
    <div class="item-info">
           <p> <?php if (!$product['special']) { ?>
            <?php echo $product['price']; ?>
            <?php } else { ?>
            <!--<span class="price-old"><?php echo $product['price']; ?></span>--> <span class="price-new"><?php echo $product['special']; ?></span>
            <?php } ?>
    </p>
          <?php if ($product['rating']) { ?>
     <img src="catalog/view/theme/default/image/stars-<?php echo $product['rating']; ?>.png" alt="<?php echo $product['reviews']; ?>" />
          <?php } else { ?>
    	   <img src="catalog/view/theme/default/image/stars-0.png" alt="<?php echo $product['reviews']; ?>" />
    	   <?php } ?>
    </div>
       <script type="text/javascript">
         function addQtyToCart(product_id) {
      var qty = $('.item-' + product_id).val();
      if ((parseFloat(qty) != parseInt(qty)) || isNaN(qty)) {
        qty = 1;
      }
      addToCart(product_id, qty);
    }
    </script>
      <?php if (($product['quantity'] >0 )||($product['onorder']==1)) { ?>
      <!--<div class="no-quantity">Под заказ</div>-->
    
      <div class="col-cat"> Количество:<input type="text" value="1" size="2" class="item-<?php echo $product['product_id']; ?>" /></div>
          <input type="button" value="" onclick="addQtyToCart('<?php echo $product['product_id']; ?>');ga('send', 'event', 'pokupka_c', 'v_korzinu_c');ga('send', 'pageview', '/order/step1_k.html');" class="button" />
      <?php } ?>    
    </div>
    </div>
      <?php } ?>
    
    </div>
    </div>
    <div class="acdc-xs"></div>
    <div class="pagination">
    <?php echo $pagination; ?>
    </div>
      <?php } ?>
    </div>
    
    <div class="acdc"></div>
    <div class="footer-line"></div>
    <div class="description">
    <div class="center">
    <div class="acdc-s"></div>
        <?php if ($description) { ?>
        <?php echo $description; ?>
        <?php } ?>
    </div>
    </div>
    
    <?php echo $footer; ?>
    
  4. Помогите доделать рассылку новых товаров через стандартные опенкартовские рассылки.

     

    В контроллер рассылок admin/controller/sale/contact.php

    		//Latest
    		
    					$this->load->model('catalog/product');
    					
    					$this->load->model('tool/image');
    					
    					$latest_data = array(
    						'sort'  => 'p.date_added',
    						'order' => 'DESC',
    						'start' => 0,
    						'limit' => 4
    					);
    
    					$results = $this->model_catalog_product->getProducts($latest_data);
    
    					foreach ($results as $result) {
    						if ($result['image']) {
    							$image = $this->model_tool_image->resize($result['image'], 138, 138);
    						} else {
    							$image = false;
    						}
    									
    
    						$price = $this->currency->format($result['price']);
    								
    						
    						$this->data['latest_products'][] = array(
    							'product_id' => $result['product_id'],
    							'thumb'   	 => $image,
    							'name'    	 => $result['name'],
    							'date'    	 => $result['date_added'],
    							'price'   	 => $price,
    							'href'    	 => str_replace('/admin/', '/catalog/', $this->url->link('product/product', 'product_id=' . $result['product_id'])),
    						);
    					}
    		//Latest	
    

    В шаблон /admin/view/template/sale/contact.tpl

    		<div id="kod" style="display: none ;">
    		<h1>Рассылка магазина</h1>
    			<table cellspacing="0" border="0" cellpadding="0" width="624">
    				<tbody><tr>
    					<td>
    						<h3 style="font-size: 24px; font-family: Helvetica, Arial, sans-serif; color: #333 !important; margin: 0px;">Новинки</h3>
    						<hr/>
    						<table cellspacing="0" border="0" cellpadding="8" width="100%" style="margin-top: 10px;">
    							<tbody><tr>
    							<?php foreach ($latest_products as $latest_product) { ?>
    								<td valign="top">
    								<?php if ($latest_product['thumb']) { ?>
    									<p style="font-size: 17px; line-height: 24px; font-family: Georgia, 'Times New Roman', Times, serif; color: #333; margin: 0px;"><a href="<?php echo $latest_product['href']; ?>"><img src="<?php echo $latest_product['thumb']; ?>" alt="<?php echo $latest_product['name']; ?>"  style="border: solid 1px #FFF; box-shadow: 2px 2px 6px #333;" /></a></p>
    								<?php } ?>	
    									<h4 style="font-size: 18px; font-family: Helvetica, Arial, sans-serif; color: #333 !important; margin: 12px 0px;"><?php echo $latest_product['name']; ?></h4>
    									<p style="font-size: 17px; line-height: 24px; font-family: Georgia, 'Times New Roman', Times, serif; color: #333; margin: 0px;"><?php echo $latest_product['price']; ?></p>
    								</td>
    							 <?php } ?>	
    							</tr>
    						</tbody></table>
    					</td>
    				</tr>
    			</tbody></table>
    			
    			<table cellspacing="0" border="0" cellpadding="0" width="624">
                                            <tbody><tr>
                                                <td/><hr/><hr/><td/>
                                            </tr>
                </tbody></table>			
    			
    		</div>	
    

     textarea в которую пишется текст рассылки присвоил id="cke"

    ниже дописал кнопку вставки 

    	<tr>
                <td><span class="required">*</span>Добавить новинки к письму</td>
                <td><a class="button" id="insertkod">Insert</a></td>
              </tr>
    

    и скрипт 

    <script type="text/javascript">
    	html = $('#kod').html();
    
    	$('#insertkod').bind('click', function(){		
    	CKEDITOR.instances.cke.insertHtml(html);	
    	})
    </script>
    

    Результат, по клику на кнопку товары добавляются в скедитор.

     

    attachicon.gifScreenshot_1.png

     

    все ок

    Но вот почему только порядок не соответствует указанной сортировке,

     

    'sort' => 'p.date_added',

    'order' => 'DESC',

     

     не пойму

     

    Если сортировать по цене или названию - все ок , по дате не получается

    куда это вставлять в файле admin/view/template/sale/contact.tpl   ?

    вот мой файл contact.tpl

    <?php echo $header; ?>
    <div id="content">
      <div class="breadcrumb">
        <?php foreach ($breadcrumbs as $breadcrumb) { ?>
        <?php echo $breadcrumb['separator']; ?><a href="<?php echo $breadcrumb['href']; ?>"><?php echo $breadcrumb['text']; ?></a>
        <?php } ?>
      </div>
      <div class="box">
        <div class="heading">
          <h1><img src="view/image/mail.png" alt="" /> <?php echo $heading_title; ?></h1>
          <div class="buttons"><a id="button-send" onclick="send('index.php?route=sale/contact/send&token=<?php echo $token; ?>');" class="button"><?php echo $button_send; ?></a><a href="<?php echo $cancel; ?>" class="button"><?php echo $button_cancel; ?></a></div>
        </div>
        <div class="content">
            <table id="mail" class="form">
              <tr>
                <td><?php echo $entry_store; ?></td>
                <td><select name="store_id">
                    <option value="0"><?php echo $text_default; ?></option>
                    <?php foreach ($stores as $store) { ?>
                    <option value="<?php echo $store['store_id']; ?>"><?php echo $store['name']; ?></option>
                    <?php } ?>
                  </select></td>
              </tr>
              <tr>
                <td><?php echo $entry_to; ?></td>
                <td><select name="to">
                    <option value="newsletter"><?php echo $text_newsletter; ?></option>
                    <option value="customer_all"><?php echo $text_customer_all; ?></option>
                    <option value="customer_group"><?php echo $text_customer_group; ?></option>
                    <option value="customer"><?php echo $text_customer; ?></option>
                    <option value="affiliate_all"><?php echo $text_affiliate_all; ?></option>
                    <option value="affiliate"><?php echo $text_affiliate; ?></option>
                    <option value="product"><?php echo $text_product; ?></option>
                  </select></td>
              </tr>
              <tbody id="to-customer-group" class="to">
                <tr>
                  <td><?php echo $entry_customer_group; ?></td>
                  <td><select name="customer_group_id">
                      <?php foreach ($customer_groups as $customer_group) { ?>
                      <option value="<?php echo $customer_group['customer_group_id']; ?>"><?php echo $customer_group['name']; ?></option>
                      <?php } ?>
                    </select></td>
                </tr>
              </tbody>
              <tbody id="to-customer" class="to">
                <tr>
                  <td><?php echo $entry_customer; ?></td>
                  <td><input type="text" name="customers" value="" /></td>
                </tr>
                <tr>
                  <td> </td>
                  <td><div id="customer" class="scrollbox"></div></td>
                </tr>
              </tbody>
              <tbody id="to-affiliate" class="to">
                <tr>
                  <td><?php echo $entry_affiliate; ?></td>
                  <td><input type="text" name="affiliates" value="" /></td>
                </tr>
                <tr>
                  <td> </td>
                  <td><div id="affiliate" class="scrollbox"></div></td>
                </tr>
              </tbody>
              <tbody id="to-product" class="to">
                <tr>
                  <td><?php echo $entry_product; ?></td>
                  <td><input type="text" name="products" value="" /></td>
                </tr>
                <tr>
                  <td> </td>
                  <td><div id="product" class="scrollbox"></div></td>
                </tr>
              </tbody>
              <tr>
                <td><span class="required">*</span> <?php echo $entry_subject; ?></td>
                <td><input type="text" name="subject" value="" /></td>
              </tr>
              <tr>
                <td><span class="required">*</span> <?php echo $entry_message; ?></td>
                <td><textarea name="message"></textarea></td>
              </tr>
            </table>
        </div>
      </div>
    </div>
    <script type="text/javascript" src="view/javascript/ckeditor/ckeditor.js"></script>
    <script type="text/javascript"><!--
    CKEDITOR.replace('message', {
    	filebrowserBrowseUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
    	filebrowserImageBrowseUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
    	filebrowserFlashBrowseUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
    	filebrowserUploadUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
    	filebrowserImageUploadUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
    	filebrowserFlashUploadUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>'
    });
    //--></script> 
    <script type="text/javascript"><!--	
    $('select[name=\'to\']').bind('change', function() {
    	$('#mail .to').hide();
    	
    	$('#mail #to-' + $(this).attr('value').replace('_', '-')).show();
    });
    
    $('select[name=\'to\']').trigger('change');
    //--></script> 
    <script type="text/javascript"><!--
    $.widget('custom.catcomplete', $.ui.autocomplete, {
    	_renderMenu: function(ul, items) {
    		var self = this, currentCategory = '';
    		
    		$.each(items, function(index, item) {
    			if (item.category != currentCategory) {
    				ul.append('<li class="ui-autocomplete-category">' + item.category + '</li>');
    				
    				currentCategory = item.category;
    			}
    			
    			self._renderItem(ul, item);
    		});
    	}
    });
    
    $('input[name=\'customers\']').catcomplete({
    	delay: 500,
    	source: function(request, response) {
    		$.ajax({
    			url: 'index.php?route=sale/customer/autocomplete&token=<?php echo $token; ?>&filter_name=' +  encodeURIComponent(request.term),
    			dataType: 'json',
    			success: function(json) {	
    				response($.map(json, function(item) {
    					return {
    						category: item.customer_group,
    						label: item.name,
    						value: item.customer_id
    					}
    				}));
    			}
    		});
    		
    	}, 
    	select: function(event, ui) {
    		$('#customer' + ui.item.value).remove();
    		
    		$('#customer').append('<div id="customer' + ui.item.value + '">' + ui.item.label + '<img src="view/image/delete.png" alt="" /><input type="hidden" name="customer[]" value="' + ui.item.value + '" /></div>');
    
    		$('#customer div:odd').attr('class', 'odd');
    		$('#customer div:even').attr('class', 'even');
    				
    		return false;
    	},
    	focus: function(event, ui) {
          	return false;
       	}
    });
    
    $('#customer div img').live('click', function() {
    	$(this).parent().remove();
    	
    	$('#customer div:odd').attr('class', 'odd');
    	$('#customer div:even').attr('class', 'even');	
    });
    //--></script> 
    <script type="text/javascript"><!--	
    $('input[name=\'affiliates\']').autocomplete({
    	delay: 500,
    	source: function(request, response) {
    		$.ajax({
    			url: 'index.php?route=sale/affiliate/autocomplete&token=<?php echo $token; ?>&filter_name=' +  encodeURIComponent(request.term),
    			dataType: 'json',
    			success: function(json) {		
    				response($.map(json, function(item) {
    					return {
    						label: item.name,
    						value: item.affiliate_id
    					}
    				}));
    			}
    		});
    		
    	}, 
    	select: function(event, ui) {
    		$('#affiliate' + ui.item.value).remove();
    		
    		$('#affiliate').append('<div id="affiliate' + ui.item.value + '">' + ui.item.label + '<img src="view/image/delete.png" alt="" /><input type="hidden" name="affiliate[]" value="' + ui.item.value + '" /></div>');
    
    		$('#affiliate div:odd').attr('class', 'odd');
    		$('#affiliate div:even').attr('class', 'even');
    				
    		return false;
    	},
    	focus: function(event, ui) {
          	return false;
       	}
    });
    
    $('#affiliate div img').live('click', function() {
    	$(this).parent().remove();
    	
    	$('#affiliate div:odd').attr('class', 'odd');
    	$('#affiliate div:even').attr('class', 'even');	
    });
    
    $('input[name=\'products\']').autocomplete({
    	delay: 500,
    	source: function(request, response) {
    		$.ajax({
    			url: 'index.php?route=catalog/product/autocomplete&token=<?php echo $token; ?>&filter_name=' +  encodeURIComponent(request.term),
    			dataType: 'json',
    			success: function(json) {		
    				response($.map(json, function(item) {
    					return {
    						label: item.name,
    						value: item.product_id
    					}
    				}));
    			}
    		});
    	}, 
    	select: function(event, ui) {
    		$('#product' + ui.item.value).remove();
    		
    		$('#product').append('<div id="product' + ui.item.value + '">' + ui.item.label + '<img src="view/image/delete.png" alt="" /><input type="hidden" name="product[]" value="' + ui.item.value + '" /></div>');
    
    		$('#product div:odd').attr('class', 'odd');
    		$('#product div:even').attr('class', 'even');
    				
    		return false;
    	},
    	focus: function(event, ui) {
          	return false;
       	}
    });
    
    $('#product div img').live('click', function() {
    	$(this).parent().remove();
    	
    	$('#product div:odd').attr('class', 'odd');
    	$('#product div:even').attr('class', 'even');	
    });
    
    function send(url) { 
    	$('textarea[name="message"]').val(CKEDITOR.instances.message.getData());
    	
    	$.ajax({
    		url: url,
    		type: 'post',
    		data: $('select, input, textarea'),		
    		dataType: 'json',
    		beforeSend: function() {
    			$('#button-send').attr('disabled', true);
    			$('#button-send').before('<span class="wait"><img src="view/image/loading.gif" alt="" /> </span>');
    		},
    		complete: function() {
    			$('#button-send').attr('disabled', false);
    			$('.wait').remove();
    		},				
    		success: function(json) {
    			$('.success, .warning, .error').remove();
    			
    			if (json['error']) {
    				if (json['error']['warning']) {
    					$('.box').before('<div class="warning" style="display: none;">' + json['error']['warning'] + '</div>');
    			
    					$('.warning').fadeIn('slow');
    				}
    				
    				if (json['error']['subject']) {
    					$('input[name=\'subject\']').after('<span class="error">' + json['error']['subject'] + '</span>');
    				}	
    				
    				if (json['error']['message']) {
    					$('textarea[name=\'message\']').parent().append('<span class="error">' + json['error']['message'] + '</span>');
    				}									
    			}			
    			
    			if (json['next']) {
    				if (json['success']) {
    					$('.box').before('<div class="success">' + json['success'] + '</div>');
    					
    					send(json['next']);
    				}		
    			} else {
    				if (json['success']) {
    					$('.box').before('<div class="success" style="display: none;">' + json['success'] + '</div>');
    			
    					$('.success').fadeIn('slow');
    				}					
    			}				
    		}
    	});
    }
    //--></script> 
    <?php echo $footer; ?>
    
    
  5. ctrl+A (выделить все) скопировать Ctrl+C, открыть Эксель, и вставить в таблицу. Вуаля база в экселе делай что хочешь. если в базе много страниц покупателей, то в настройках админ панели поставить отображать 1000 или всех.

    телефонов не видно

×
×
  • Створити...

Important Information

На нашому сайті використовуються файли cookie і відбувається обробка деяких персональних даних користувачів, щоб поліпшити користувальницький інтерфейс. Щоб дізнатися для чого і які персональні дані ми обробляємо перейдіть за посиланням . Якщо Ви натиснете «Я даю згоду», це означає, що Ви розумієте і приймаєте всі умови, зазначені в цьому Повідомленні про конфіденційність.