<?php
/* ----------------------------------------------------------------------
   $Id: also_purchased_products.php,v 1.1 2007/06/07 17:30:50 r23 Exp $

   OOS [OSIS Online Shop]
   http://www.oos-shop.de/

   Copyright (c) 2003 - 2007 by the OOS Development Team.
   ----------------------------------------------------------------------
   Based on:

   File: also_purchased_products.php,v 1.21 2003/02/12 23:55:58 hpdl
   ----------------------------------------------------------------------
   osCommerce, Open Source E-Commerce Solutions
   http://www.oscommerce.com

   Copyright (c) 2003 osCommerce
   ----------------------------------------------------------------------
   Released under the GNU General Public License
   ---------------------------------------------------------------------- */

/** ensure this file is being included by a parent file */
defined( 'OOS_VALID_MOD' ) or die( 'Direct Access to this location is not allowed.' );
if (isset($list_of_order_ids)) return false;
  
$aPurchased = array();

if (isset($_GET['products_id']) && is_numeric(MAX_DISPLAY_ALSO_PURCHASED)) {
    if (!isset($nProductsId)) $nProductsId = oos_get_product_id($_GET['products_id']);

	$orderstable = $oostable['orders'];
    $orders_productstable = $oostable['orders_products'];
    $sub_orders_query = "SELECT op.orders_id 
	                     FROM $orders_productstable op,
						      $orderstable o 
					     WHERE op.products_id = '" . intval($nProductsId) . "' 
						   AND op.orders_id = o.orders_id 
						   AND DATE_SUB(CURDATE(), INTERVAL 720 DAY) <= o.date_purchased 
						   ORDER BY o.date_purchased DESC"; 					   
    $sub_orders_result = $dbconn->SelectLimit($sub_orders_query, 100); // the last 100 orders with this product should suffice hopefully
    $num_sub_products_ordered = $sub_orders_result->RecordCount();

    if ($num_sub_products_ordered >= 1) {
        $list_of_order_ids = array();
        while ($sub_orders = $sub_orders_result->fields) {
            $list_of_order_ids[] = $sub_orders['orders_id'];
			  
			// Move that ADOdb pointer!
            $sub_orders_result->MoveNext();
        }
    }
// if there are no orders with this product the next query is pointless too
    if (isset($list_of_order_ids)) {
      $orders_productstable = $oostable['orders_products'];
      $orderstable = $oostable['orders'];
      $productstable = $oostable['products'];
      $orders_query = "SELECT p.products_id, p.products_image 
                       FROM $orders_productstable opb,
                            $orderstable o,
                            $productstable p
	  				  WHERE opb.products_id != '" . intval($nProductsId) . "' 
					    AND opb.products_id = p.products_id 
					    AND opb.orders_id = o.orders_id 
					    AND o.orders_id in (" . implode(',', $list_of_order_ids) . ") 
                        AND p.products_status >= '1'
                       GROUP BY p.products_id
                       ORDER BY o.date_purchased DESC"; 
      $orders_result = $dbconn->SelectLimit($orders_query, MAX_DISPLAY_ALSO_PURCHASED);

      $num_products_ordered = $orders_result->RecordCount();
      if ($num_products_ordered >= MIN_DISPLAY_ALSO_PURCHASED) {
         while ($orders = $orders_result->fields) {
            $aPurchased[] = array('products_name' => oos_get_products_name($orders['products_id']),
                                  'products_id' => $orders['products_id'],
                                  'products_image' => $orders['products_image']);

             // Move that ADOdb pointer!
             $orders_result->MoveNext();
         }

      }
	}
}