вывод всех товаров магазина на отдельной странице в виде прайса+ формирование файла для скачивания

public function getFiles($product_id) {

   $sql = "SELECT * FROM " . DB_PREFIX . "product_to_download pf LEFT JOIN " . DB_PREFIX . "download_description dp ON (pf.download_id = dp.download_id) WHERE pf.product_id = '" . (int)$product_id .  "' AND dp.language_id = '" . (int)$this->config->get('config_language_id') . "'";



   $query = $this->db->query($sql);



   return $query->rows;

}

          // Downlaod Files



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

        

         $files = $this->model_catalog_product->getFiles($product_id);



         foreach ($files as $file) {

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

               'name'       => $file['name'],

               'file'       => $file['file']

            );

         }