<?php
/**
 * 888888ba                 dP  .88888.                    dP                
 * 88    `8b                88 d8'   `88                   88                
 * 88aaaa8P' .d8888b. .d888b88 88        .d8888b. .d8888b. 88  .dP  .d8888b. 
 * 88   `8b. 88ooood8 88'  `88 88   YP88 88ooood8 88'  `"" 88888"   88'  `88 
 * 88     88 88.  ... 88.  .88 Y8.   .88 88.  ... 88.  ... 88  `8b. 88.  .88 
 * dP     dP `88888P' `88888P8  `88888'  `88888P' `88888P' dP   `YP `88888P' 
 *
 *                          m a g n a l i s t e r
 *                                      boost your Online-Shop
 *
 * -----------------------------------------------------------------------------
 * $Id$
 *
 * (c) 2010 RedGecko GmbH -- http://www.redgecko.de
 *     Released under the MIT License (Expat)
 * -----------------------------------------------------------------------------
 */

header('Content-Type: text/plain; charset=utf-8');
#echo "\xEF\xBB\xBF";
//*
if (!function_exists('ml_debug_out')) {
	function ml_debug_out($m) {
		echo $m;
		flush();
	}
}
//*/
#require_once(DIR_MAGNALISTER_INCLUDES.'testing/ordertest.php');
#require_once(DIR_MAGNALISTER_INCLUDES.'testing/inventoryEdit.php');
#require_once(DIR_MAGNALISTER_INCLUDES.'testing/syncAmazonOrder.php');
#require_once(DIR_MAGNALISTER_INCLUDES.'testing/checkinTest.php');
#require_once(DIR_MAGNALISTER_INCLUDES.'testing/genEANForSelection.php');
#require_once(DIR_MAGNALISTER_INCLUDES.'testing/orderimport.php');
#require_once(DIR_MAGNALISTER_INCLUDES.'testing/callback.php');

function verifyUniqueSKUs() {
	if (getDBConfigValue('general.keytype', '0', 'pID') != 'artNr') {
		return true;
	}

	# Verify products
	$countProductsIDs = MagnaDB::gi()->fetchOne('
		SELECT COUNT(DISTINCT products_id) FROM '.TABLE_PRODUCTS
	);
	$countProductsModels = MagnaDB::gi()->fetchOne('
		SELECT COUNT(DISTINCT products_model) FROM '.TABLE_PRODUCTS.' 
		 WHERE products_model <> \'\' AND products_model IS NOT NULL
	');
	#echo '$countProductsIDs['.$countProductsIDs.'] != $countProductsModels['.$countProductsModels.']'."\n";
	if ($countProductsIDs != $countProductsModels) {
		return false;
	}
	
	# Verify attributes
	$countAttributesIDs = MagnaDB::gi()->fetchOne('
		SELECT COUNT(DISTINCT products_attributes_id) FROM '.TABLE_PRODUCTS_ATTRIBUTES
	);
	$countAttributesModels = MagnaDB::gi()->fetchOne('
		SELECT COUNT(DISTINCT attributes_model) FROM '.TABLE_PRODUCTS_ATTRIBUTES.' 
		 WHERE attributes_model <> \'\' AND attributes_model IS NOT NULL
	');
	#echo '$countAttributesIDs['.$countAttributesIDs.'] != $countAttributesModels['.$countAttributesModels.']'."\n";
	if ($countAttributesIDs != $countAttributesModels) {
		return false;
	}
	
	# Verify products in compinations with attributes
	$zort = (int)MagnaDB::gi()->fetchOne('
		SELECT COUNT(DISTINCT pa.products_id) 
		  FROM '.TABLE_PRODUCTS.' p, '.TABLE_PRODUCTS_ATTRIBUTES.' pa
		 WHERE p.products_model=pa.attributes_model
		       AND attributes_model <> \'\'
		       AND attributes_model IS NOT NULL
	');
	
	return ($zort == 0);
}

#var_dump(verifyUniqueSKUs());
/*
$aID = 24;
$sku = magnaAID2SKU($aID);
echo var_dump_pre($sku, $aID);
$aID = magnaSKU2aID($sku);
echo var_dump_pre($aID, $sku);
*/
/*
$mpID = 395;
$pID = 4641;

require_once(DIR_MAGNALISTER_MODULES.'ebay/ebayFunctions.php');

loadDBConfig($mpID);
//echo print_m(getVariations($pID));

require_once(DIR_MAGNALISTER_INCLUDES.'lib/classes/VariationsCalculator.php');
$skutype = (getDBConfigValue('general.keytype', '0') == 'artNr') ? 'model' : 'id';
$vc = new VariationsCalculator(array(
	'skubasetype' => $skutype,
	'skuvartype'  => $skutype,
));
$d = $vc->getVariationsByPIDFromDB($pID, true);
arrayEntitiesToUTF8($d);
echo print_m($d, 'd');
*/
/*
class StaticTest {
	public static function test($param1, $param2) {
		echo 'works! '.$param1.' '.$param2;
	}
}

$meh = 'static';
//ucfirst($meh).'Test'::test();
$path = 'C:\server\var/www/bla.php';
#call_user_func(ucfirst($meh).'Test::test', "a", "b");
if (($path[0] != '/') && !preg_match('/^[a-zA-Z]:\\\/', $path)) {
	echo 'nope';
} else {
	echo 'yup';
}
*/

#var_dump(magnaGetTimezoneOffset('Europe/Berlin'));
/*
$html = '
<p>foo bar</p>
<span style="font: 11px sans-serif">nanana</span>
<div>
	<iFrAmE src="o.html">du kannst kein iframe</iframe>
	<form><input type="text"></form>
</div>
';

$nHtml = stripEvilBlockTags($html, array('iframe'));

echo $nHtml;
*/

/*
require_once(DIR_MAGNALISTER_MODULES.'hood/checkin/HoodCheckinSubmit.php');
$_MagnaSession['currentPlatform'] = 'hood';
$mps = array_flip($magnaConfig['maranon']['Marketplaces']);
if (isset($mps[$_MagnaSession['currentPlatform']])) {
	$_MagnaSession['mpID'] = $mps[$_MagnaSession['currentPlatform']];
	$pId = 24;
	$data = HoodCheckinSubmit::loadOfferByPId($pId, 'shopProduct');
	echo print_m($data);
}
*/

function testMLProduct() {
	$cfg = array (
		'pid' => (isset($_GET['pid']) ? $_GET['pid'] : 4641),
		'lang' => isset($_GET['lang']) ? $_GET['lang'] : '2',
		'onlyoffer' => isset($_GET['onlyoffer']),
		'single' => isset($_GET['single']),
		'optionsTmp' => array (
			'purgeVariations' => isset($_GET['optionsTmp']['purgeVariations']) && ($_GET['optionsTmp']['purgeVariations'] == 'true'),
			'useGambioProperties' => isset($_GET['optionsTmp']['useGambioProperties'])
				? ($_GET['optionsTmp']['useGambioProperties'] == 'true')
				: (getDBConfigValue('general.options', '0') == 'gambioProperties'),
			'sameVariationsToAttributes' => isset($_GET['optionsTmp']['sameVariationsToAttributes']) && ($_GET['optionsTmp']['sameVariationsToAttributes'] == 'true'),
			'allowSingleVariations' => !isset($_GET['optionsTmp']['allowSingleVariations']) || isset($_GET['optionsTmp']['allowSingleVariations']) && ($_GET['optionsTmp']['allowSingleVariations'] == 'true')
		),
		'blacklist' => array(),
		'useold' => isset($_GET['useold']) && ($_GET['useold'] == 'true'),
		'mpid' => isset($_GET['mpid']) && ctype_digit($_GET['mpid']) ? $_GET['mpid'] : '0',
		'info' => array (
			'marketplace' => '',
			'configs' => array(
				'price' => array(),
				'quantity' => array(),
			),
		)
	);
	if (preg_match('/^([a-zA-Z0-9]+,)+[a-zA-Z0-9]+$/', $cfg['lang'])) {
		$cfg['lang'] = explode(',', $cfg['lang']);
	}
	if (isset($_GET['blacklist']) && preg_match('/^([0-9]+,)*[0-9]+$/', $_GET['blacklist'])) {
		$cfg['blacklist'] = explode(',', $_GET['blacklist']);
	}
	
	if (
		($cfg['mpid'] > 0)
		&& ($cfg['info']['marketplace'] = magnaGetMarketplaceByID($cfg['mpid']))
		&& !empty($cfg['info']['marketplace'])
		&& ($helper = ucfirst($cfg['info']['marketplace']).'Helper')
		&& ($helperFile = DIR_MAGNALISTER_MODULES.$cfg['info']['marketplace'].'/'.$helper.'.php')
		&& file_exists($helperFile)
	) {
		require_once($helperFile);
		if (method_exists($helper, 'loadPriceSettings')) {
			$cfg['info']['configs']['price'] = $helper::loadPriceSettings($cfg['mpid']);
		}
		if (method_exists($helper, 'loadQuantitySettings')) {
			$cfg['info']['configs']['quantity'] = $helper::loadQuantitySettings($cfg['mpid']);
		}
	}
	
	echo print_m($cfg, '$cfg');
	
	if ($cfg['useold']) {
		$product = MLProduct::gi()->getProductByIdOld($cfg['pid'], $cfg['lang']);
	} else {
		MLProduct::gi()->setLanguage($cfg['lang']);
		MLProduct::gi()->setDbMatching('ManufacturerPartNumber', array (
			'Table' => 'products',
			'Column' => 'products_model',
			'Alias' => 'products_id',
		));
		if (!empty($cfg['info']['configs']['price'])) {
			MLProduct::gi()->setPriceConfig($cfg['info']['configs']['price']);
		}
		if (!empty($cfg['info']['configs']['quantity'])) {
			MLProduct::gi()->setQuantityConfig($cfg['info']['configs']['quantity']);
		}
		if ($cfg['single']) {
			MLProduct::gi()->setVariationDimensionBlacklist($cfg['blacklist']);
			MLProduct::gi()->useMultiDimensionalVariations(false);
		} else {
			MLProduct::gi()->setVariationDimensionBlacklist($cfg['blacklist']);
		}
		if ($cfg['onlyoffer']) {
			$product = MLProduct::gi()->getProductOfferById($cfg['pid'], $cfg['optionsTmp']);
		} else {
			$product = MLProduct::gi()->getProductById($cfg['pid'], $cfg['optionsTmp']);
		}
	}
	
	arrayEntitiesToUTF8($product);
	echo print_m($product, '$product');
}

testMLProduct();


function blargh() {
	if (!MagnaDB::gi()->tableExists('products_properties_index')) {
		return;
	}
	echo '== Erkennen =='."\n";
	
	$sku = 'ABC123-xxl-white';
	echo '=== ProductsModel (SKU: '.$sku.') ==='."\n";
	
	$productsPropertiesCombisId = MagnaDB::gi()->fetchArray(eecho('
		    SELECT CONCAT(p.products_model, "-", ppc.combi_model) AS SKU, ppc.*
		      FROM products_properties_combis ppc
		INNER JOIN products p ON p.products_id = ppc.products_id
		    HAVING SKU = "'.MagnaDB::gi()->escape($sku).'"
	', true));
	
	echo "\n".print_m($productsPropertiesCombisId, '$productsPropertiesCombisId');
	
	$sku = 'ML1-1.9-2.11';
	echo "\n".'=== ProductsId (SKU: '.$sku.') ==='."\n";
	$data = explode('-', $sku);
	$pId = substr(array_shift($data), 2);
	
	$productsPropertiesCombisId = false;
	foreach ($data as $propSet) {
		$propSet = explode('.', $propSet);
		
		$productsPropertiesCombisId = MagnaDB::gi()->fetchArray(eecho('
			SELECT DISTINCT products_properties_combis_id
			  FROM '.'products_properties_index'.'
			 WHERE products_id = "'.$pId.'"
			       AND properties_id = "'.$propSet[0].'"
			       AND properties_values_id = "'.$propSet[1].'"
			       '.(($productsPropertiesCombisId !== false) 
			            ? 'AND products_properties_combis_id IN ('.implode(', ', $productsPropertiesCombisId).')'
			            : ''
			       ).'
		', true), true);
	}
	if ((count($productsPropertiesCombisId) === 1) && ((int)$productsPropertiesCombisId[0] > 0)) {
		echo "\n".print_m(MagnaDB::gi()->fetchArray(eecho('
			    SELECT CONCAT(p.products_model, "-", ppc.combi_model) AS SKU, ppc.*
			      FROM products_properties_combis ppc
			INNER JOIN products p ON p.products_id = ppc.products_id
			    HAVING products_properties_combis_id = "'.((int)$productsPropertiesCombisId[0]).'"
		', false)), '$productsPropertiesCombisId['.$productsPropertiesCombisId[0].']');
	} else {
		echo print_m($productsPropertiesCombisId, '$productsPropertiesCombisId');
	}
}

blargh();

function testSku() {
	if (!isset($_GET['SKU'])) {
		return;
	}
	
	$pId = magnaSKU2pID($_GET['SKU']);
	$aId = magnaSKU2aID($_GET['SKU']);
	$oDt = magnaSKU2pOpt($_GET['SKU']);
	echo "\n\n== Ident Test ==\n";
	echo print_m($_GET['SKU'], 'SKU')."\n";
	echo print_m(getDBConfigValue('general.keytype', '0'), 'IdentType')."\n";
	echo "---------------------\n";
	echo print_m($pId, 'pId')."\n";
	echo print_m($aId, 'aId')."\n";
	echo print_m($oDt, 'Opt')."\n";
	
}

testSku();


/*
echo print_m(MLProduct::gi()->getAllImagesByProductsId(4817), 'new');
echo print_m(MLProduct::gi()->getProductImagesByID(4817), 'old');
*/

/*
require_once(DIR_MAGNALISTER_INCLUDES.'modules/ebay/classes/ebayTopTen.php');
require_once(DIR_MAGNALISTER_INCLUDES.'modules/ebay/ebayFunctions.php');

$eBayMpId = 395;
$eBayCategoryType = 'PrimaryCategory';
$_MagnaSession['mpID'] = $eBayMpId;
$_MagnaSession['currentPlatform'] = magnaGetMarketplaceByID($_MagnaSession['mpID']);

$oTopTen = new ebayTopTen();
$oTopTen->setMarketPlaceId($_MagnaSession['mpID']);
$oTopTen->configCopy();
$aTopTenCatIds = $oTopTen->getTopTenCategories($eBayCategoryType);
echo print_m($aTopTenCatIds, '$aTopTenCatIds');
//*/
/*
require_once(DIR_MAGNALISTER_INCLUDES.'modules/hood/classes/HoodTopTenCategories.php');
$hoodMpId = 12192;
$hoodCategoryType = 'PrimaryCategory';
$_MagnaSession['mpID'] = $hoodMpId;
$_MagnaSession['currentPlatform'] = magnaGetMarketplaceByID($_MagnaSession['mpID']);
HoodApiConfigValues::gi()->init($_MagnaSession);
var_dump(HoodHelper::hasStore());

$oTopTen = new HoodTopTenCategories();
$oTopTen->setMarketPlaceId($_MagnaSession['mpID']);
$oTopTen->configCopy();
$aTopTenCatIds = $oTopTen->getTopTenCategories($hoodCategoryType);
echo print_m($aTopTenCatIds, '$aTopTenCatIds');
//*/


echo '
----------------------------------------------------
 Entire page served in '.microtime2human(microtime(true) -  $_executionTime).'.
----------------------------------------------------
 Updater Time: '.microtime2human($_updaterTime).'.
 API-Request Time: '.microtime2human(MagnaConnector::gi()->getRequestTime()).'.
 Processing Time: '.microtime2human(microtime(true) -  $_executionTime - $_updaterTime - MagnaConnector::gi()->getRequestTime() - MagnaDB::gi()->getRealQueryTime()).'.
----------------------------------------------------
 '.((memory_usage() !== false) ? 'Max. Memory used: '.memory_usage().'.' : '').'
----------------------------------------------------
 DB-Stats:
 	Queries used: '.MagnaDB::gi()->getQueryCount().'
 	Real query time: '.microtime2human(MagnaDB::gi()->getRealQueryTime()).'
----------------------------------------------------
';
if (class_exists('MagnaConnector') && true) {
	$tpR = MagnaConnector::gi()->getTimePerRequest();
	if (!empty($tpR)) {
		foreach ($tpR as $item) {
			echo print_m($item['request'], microtime2human($item['time']).' ['.$item['status'].']', true)."\n";
		}
		echo '----------------------------------------------------'."\n";
	}
	
}
if (class_exists('MagnaDB')) {
	$tpR = MagnaDB::gi()->getTimePerQuery();
	if (!empty($tpR) && false) {
		foreach ($tpR as $item) {
			echo print_m(ltrim(rtrim($item['query'], "\n"), "\n"), microtime2human($item['time']), true)."\n";
		}
		echo '----------------------------------------------------'."\n";
	}
	$err = MagnaDB::gi()->getSqlErrors();
	if (!empty($err)) {
		foreach ($err as &$eItem) {
			unset($eItem['Backtrace']);
		}
		echo print_m($err, 'DB SQL Errors')."\n";
		echo '----------------------------------------------------'."\n";
	}
}
include_once(DIR_WS_INCLUDES . 'application_bottom.php');
exit();