<?php
/* -----------------------------------------------------------------------------------------
   $Id: header.php 3808 2012-10-28 20:39:04Z web28 $

   modified eCommerce Shopsoftware
   http://www.modified-shop.org

   Copyright (c) 2009 - 2013 [www.modified-shop.org]
   -----------------------------------------------------------------------------------------
   Released under the GNU General Public License
   ---------------------------------------------------------------------------------------*/

  function xtc_restock_order($order_id) {
    $order_query = xtc_db_query("SELECT orders_products_id, 
                                        products_id, 
                                        products_quantity 
                                   FROM ".TABLE_ORDERS_PRODUCTS." 
                                  WHERE orders_id = '".(int)$order_id."'");
    while ($order = xtc_db_fetch_array($order_query)) {
      $products_update = true;
      $orders_attributes_query = xtc_db_query("SELECT pa.products_options,
                                                      pa.products_options_values,
                                                      opd.orders_products_filename
                                                 FROM ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES." pa
                                            LEFT JOIN ".TABLE_ORDERS_PRODUCTS_DOWNLOAD." opd 
                                                      ON opd.orders_products_id = pa.orders_products_id
                                                WHERE pa.orders_id = '" . (int)$order_id . "'
                                                  AND pa.orders_products_id = '" . $order['orders_products_id'] . "'");
      if (xtc_db_num_rows($orders_attributes_query) > 0) {
        while ($orders_attributes = xtc_db_fetch_array($orders_attributes_query)) {
          if ($orders_attributes['orders_products_filename'] == '') {
            $ids_query = xtc_db_query("SELECT po.products_options_id, pov.products_options_values_id FROM 
              `".TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS."` AS pov2po, `".TABLE_PRODUCTS_OPTIONS_VALUES."` AS pov, `".TABLE_PRODUCTS_OPTIONS."` AS po
              WHERE 
                pov.products_options_values_id=pov2po.products_options_values_id
                AND po.products_options_id=pov2po.products_options_id
                AND po.language_id=pov.language_id
                AND po.products_options_name='".$orders_attributes['products_options']."'
                AND pov.products_options_values_name='".$orders_attributes['products_options_values']."'
            ");
            if (xtc_db_num_rows($ids_query) > 0) {
              $options_values_id_list = array();
              while ($id_result = xtc_db_fetch_array($ids_query)) {
                $options_values_id_list[] = $id_result['products_options_values_id'];
              }
              if(!empty($options_values_id_list)) {
                xtc_db_query("UPDATE ".TABLE_PRODUCTS_ATTRIBUTES."
                             SET attributes_stock = attributes_stock + ".$order['products_quantity']." 
                             AND options_values_id IN(" . implode(',',$options_values_id_list) . ")
                             AND products_id = '" . $order['products_id'] . "'");
              }
            }
          } else {
            $products_update = false;
          }
        }
      }
      if ($products_update === true) {
        xtc_db_query("UPDATE ".TABLE_PRODUCTS." 
                         SET products_quantity = products_quantity + ".$order['products_quantity'].", 
                             products_ordered = products_ordered - ".$order['products_quantity']." 
                       WHERE products_id = '".$order['products_id']."'");
      }
    }
  }
?>