[Sommaire] [Imprimer]

   1  <?php
   2  /**

   3   * @package admin

   4   * @copyright Copyright 2003-2006 Zen Cart Development Team

   5   * @copyright Portions Copyright 2003 osCommerce

   6   * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

   7   * @version $Id: copy_to_confirm.php 3009 2006-02-11 15:41:10Z wilt $

   8   */
   9  if (!defined('IS_ADMIN_FLAG')) {
  10    die('Illegal Access');
  11  }
  12  
  13          if (isset($_POST['products_id']) && isset($_POST['categories_id'])) {
  14            $products_id = zen_db_prepare_input($_POST['products_id']);
  15            $categories_id = zen_db_prepare_input($_POST['categories_id']);
  16  
  17  // Copy attributes to duplicate product

  18            $products_id_from=$products_id;
  19  
  20            if ($_POST['copy_as'] == 'link') {
  21              if ($categories_id != $current_category_id) {
  22                $check = $db->Execute("select count(*) as total
  23                                       from " . TABLE_PRODUCTS_TO_CATEGORIES . "
  24                                       where products_id = '" . (int)$products_id . "'
  25                                       and categories_id = '" . (int)$categories_id . "'");
  26                if ($check->fields['total'] < '1') {
  27                  $db->Execute("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . "
  28                                            (products_id, categories_id)
  29                                values ('" . (int)$products_id . "', '" . (int)$categories_id . "')");
  30                }
  31              } else {
  32                $messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error');
  33              }
  34            } elseif ($_POST['copy_as'] == 'duplicate') {
  35              $old_products_id = (int)$products_id;
  36              $product = $db->Execute("select products_type, products_quantity, products_model, products_image,
  37                                              products_price, products_virtual, products_date_available, products_weight,
  38                                              products_tax_class_id, manufacturers_id,
  39                                              products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute,
  40                                              product_is_free, product_is_call, products_quantity_mixed,
  41                                              product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order,
  42                                              products_price_sorter, master_categories_id
  43                                       from " . TABLE_PRODUCTS . "
  44                                       where products_id = '" . (int)$products_id . "'");
  45  
  46              $db->Execute("insert into " . TABLE_PRODUCTS . "
  47                                        (products_type, products_quantity, products_model, products_image,
  48                                         products_price, products_virtual, products_date_added, products_date_available,
  49                                         products_weight, products_status, products_tax_class_id,
  50                                         manufacturers_id,
  51                                         products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute,
  52                                         product_is_free, product_is_call, products_quantity_mixed,
  53                                         product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order,
  54                                         products_price_sorter, master_categories_id
  55                                         )
  56                            values ('" . zen_db_input($product->fields['products_type']) . "',
  57                  '" . zen_db_input($product->fields['products_quantity']) . "',
  58                                    '" . zen_db_input($product->fields['products_model']) . "',
  59                                    '" . zen_db_input($product->fields['products_image']) . "',
  60                                    '" . zen_db_input($product->fields['products_price']) . "',
  61                                    '" . zen_db_input($product->fields['products_virtual']) . "',
  62                                    now(),
  63                                    '" . zen_db_input($product->fields['products_date_available']) . "',
  64                                    '" . zen_db_input($product->fields['products_weight']) . "', '0',
  65                                    '" . (int)$product->fields['products_tax_class_id'] . "',
  66                                    '" . (int)$product->fields['manufacturers_id'] . "',
  67                                    '" . zen_db_input($product->fields['products_quantity_order_min']) . "',
  68                                    '" . zen_db_input($product->fields['products_quantity_order_units']) . "',
  69                                    '" . zen_db_input($product->fields['products_priced_by_attribute']) . "',
  70                                    '" . (int)$product->fields['product_is_free'] . "',
  71                                    '" . (int)$product->fields['product_is_call'] . "',
  72                                    '" . (int)$product->fields['products_quantity_mixed'] . "',
  73                                    '" . zen_db_input($product->fields['product_is_always_free_shipping']) . "',
  74                                    '" . zen_db_input($product->fields['products_qty_box_status']) . "',
  75                                    '" . zen_db_input($product->fields['products_quantity_order_max']) . "',
  76                                    '" . zen_db_input($product->fields['products_sort_order']) . "',
  77                                    '" . zen_db_input($product->fields['products_price_sorter']) . "',
  78                                    '" . zen_db_input($product->fields['master_categories_id']) .
  79                                    "')");
  80  
  81              $dup_products_id = $db->Insert_ID();
  82  
  83              if (isset($_POST['copy_media']) && $_POST['copy_media'] == 'on') {
  84                $product_media = $db->Execute("select media_id from " . TABLE_MEDIA_TO_PRODUCTS . "
  85                                               where product_id = '" . (int)$products_id . "'");
  86                while (!$product_media->EOF) {
  87                  $db->Execute("insert into " . TABLE_MEDIA_TO_PRODUCTS . "
  88                                (media_id, product_id)
  89                                values (
  90                                '" . $product_media->fields['media_id'] . "',
  91                                '" . $dup_products_id . "')");
  92                  $product_media->MoveNext();
  93                }
  94              }
  95  
  96              $music_extra = $db->Execute("select artists_id, record_company_id, music_genre_id from " . TABLE_PRODUCT_MUSIC_EXTRA . "                                                where products_id = '" . (int)$products_id . "'");
  97  
  98              $db->Execute("insert into " . TABLE_PRODUCT_MUSIC_EXTRA . "
  99                            (products_id, artists_id, record_company_id, music_genre_id)
 100                            values (
 101                           '" . (int)$dup_products_id . "',
 102                           '" . zen_db_input($music_extra->fields['artists_id']) . "',
 103                           '" . zen_db_input($music_extra->fields['record_company_id']) . "',
 104                           '" . zen_db_input($music_extra->fields['music_genre_id']) . "')");
 105  
 106  
 107              $description = $db->Execute("select language_id, products_name, products_description,
 108                                                               products_url
 109                                           from " . TABLE_PRODUCTS_DESCRIPTION . "
 110                                           where products_id = '" . (int)$products_id . "'");
 111              while (!$description->EOF) {
 112                $db->Execute("insert into " . TABLE_PRODUCTS_DESCRIPTION . "
 113                                          (products_id, language_id, products_name, products_description,
 114                                           products_url, products_viewed)
 115                              values ('" . (int)$dup_products_id . "',
 116                                      '" . (int)$description->fields['language_id'] . "',
 117                                      '" . zen_db_input($description->fields['products_name']) . "',
 118                                      '" . zen_db_input($description->fields['products_description']) . "',
 119                                      '" . zen_db_input($description->fields['products_url']) . "', '0')");
 120                $description->MoveNext();
 121              }
 122  
 123              $db->Execute("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . "
 124                                        (products_id, categories_id)
 125                            values ('" . (int)$dup_products_id . "', '" . (int)$categories_id . "')");
 126              $products_id = $dup_products_id;
 127              $description->MoveNext();
 128  // FIX HERE

 129  /////////////////////////////////////////////////////////////////////////////////////////////

 130  // Copy attributes to duplicate product

 131  // moved above            $products_id_from=zen_db_input($products_id);

 132              $products_id_to= $dup_products_id;
 133              $products_id = $dup_products_id;
 134  
 135  if ( $_POST['copy_attributes']=='copy_attributes_yes' and $_POST['copy_as'] == 'duplicate' ) {
 136    // $products_id_to= $copy_to_products_id;

 137    // $products_id_from = $pID;

 138  //            $copy_attributes_delete_first='1';

 139  //            $copy_attributes_duplicates_skipped='1';

 140  //            $copy_attributes_duplicates_overwrite='0';

 141  
 142              if (DOWNLOAD_ENABLED == 'true') {
 143                $copy_attributes_include_downloads='1';
 144                $copy_attributes_include_filename='1';
 145              } else {
 146                $copy_attributes_include_downloads='0';
 147                $copy_attributes_include_filename='0';
 148              }
 149  
 150              zen_copy_products_attributes($products_id_from, $products_id_to);
 151  }
 152  // EOF: Attributes Copy on non-linked

 153  /////////////////////////////////////////////////////////////////////

 154  
 155              // copy product discounts to duplicate

 156              zen_copy_discounts_to_product($old_products_id, (int)$dup_products_id);
 157  
 158            }
 159  
 160            // reset products_price_sorter for searches etc.

 161            zen_update_products_price_sorter($products_id);
 162  
 163          }
 164          zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $categories_id . '&pID=' . $products_id . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
 165  ?>