Opencart 3. Добавить новое поле в oc_ product_image

euxos написал(а): ↑да, чтобы описания подгружались вместе с изображениями.

Chukcha написал(а): ↑под изображениями? или в атрибутах?

Chukcha написал(а): ↑можно паковать через json или serialize

euxos написал(а): ↑И для вывода на сайте

            $data['images'] = array();



            $results = $this->model_catalog_product->getProductImages($this->request->get['product_id']);

            

            // desc image start

            

            $image_description = array();

            

            $query_desc_image = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_image_description  WHERE image_product_id = '" . (int) $this->request->get['product_id'] . "' AND language_id = '" . (int) $this->config->get('config_language_id') . "'");

            if($query_desc_image->rows){

                foreach($query_desc_image->rows as $d_i){

                    $image_description[$d_i['image_id']] = $d_i['image_description'];

                }

            }



            // desc image end



            foreach ($results as $result) {

                // desc image start

                

                 if(isset($image_description[$result['product_image_id']])){

                    $desc = $image_description[$result['product_image_id']];

                }else{

                    $desc = false;

                }

                

                // desc image end

                

                $data['images'][] = array(

                    // desc image start

                    'description' => $desc,

                    // desc image end

                    'popup' => $this->model_tool_image->resize($result['image'], $this->config->get('theme_' . $this->config->get('config_theme') . '_image_popup_width'), $this->config->get('theme_' . $this->config->get('config_theme') . '_image_popup_height')),

                    'thumb' => $this->model_tool_image->resize($result['image'], $this->config->get('theme_' . $this->config->get('config_theme') . '_image_additional_width'), $this->config->get('theme_' . $this->config->get('config_theme') . '_image_additional_height'))

                );

            }

fanatic написал(а): ↑но мне все равно удобней в таблице.

fanatic написал(а): ↑

phpкопировать

            $data['images'] = array();



            $results = $this->model_catalog_product->getProductImages($this->request->get['product_id']);

           

            // desc image start

           

            $image_description = array();

           

            $query_desc_image = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_image_description  WHERE image_product_id = '" . (int) $this->request->get['product_id'] . "' AND language_id = '" . (int) $this->config->get('config_language_id') . "'");

            if($query_desc_image->rows){

                foreach($query_desc_image->rows as $d_i){

                    $image_description[$d_i['image_id']] = $d_i['image_description'];

                }

            }



            // desc image end



            foreach ($results as $result) {

                // desc image start

               

                 if(isset($image_description[$result['product_image_id']])){

                    $desc = $image_description[$result['product_image_id']];

                }else{

                    $desc = false;

                }

               

                // desc image end

               

                $data['images'][] = array(

                    // desc image start

                    'description' => $desc,

                    // desc image end

                    'popup' => $this->model_tool_image->resize($result['image'], $this->config->get('theme_' . $this->config->get('config_theme') . '_image_popup_width'), $this->config->get('theme_' . $this->config->get('config_theme') . '_image_popup_height')),

                    'thumb' => $this->model_tool_image->resize($result['image'], $this->config->get('theme_' . $this->config->get('config_theme') . '_image_additional_width'), $this->config->get('theme_' . $this->config->get('config_theme') . '_image_additional_height'))

                );

            }