ProudCommerce proudcommerce

## admin_header_links.tpl
[{* Create module with tmeplate block for: admin_header_links *}]
[{$smarty.block.parent}]
<script>
    setInterval(function () {
        window.location.href=window.location.href;
    }, 1800000);
</script>

## pc-ide-helper.php
moved: https://github.com/proudcommerce/oxid-ide-modulehelper

## OXID eShop - getLogger fix OXID 6.2
# thx to alfred (https://github.com/alfredbez) for sharing
# add to modules/functions.php

use Monolog\Logger;
use Monolog\Handler\StreamHandler;
use OxidEsales\EshopCommunity\Internal\Container\ContainerFactory;
use Psr\Log\LoggerInterface;
use Symfony\Component\DependencyInjection\Exception\ServiceCircularReferenceException;

function getLogger() {

## OXID eShop - config.inc.php configuration values
iLangPerTable (8)
= definiert die mögliche Zahl an Sprachtabellen

sLangTableSuffix (_set)
= optionaler Suffix für Sprachtabellen

iPasswordLength (6)
= definiert die Mindestlänge des Kundenpasswortes

blSkipFormatConversion (false)

## OXID eShop - Switch oxvendor and oxmanufacturers
# 1. Export oxvendors table + data (eg. oxvendor.sql)
# 2. Export oxmanufacturers table + data (eg. oxmanufacturers.sql)
# 3. Clean up manufacturers
DELETE FROM oxmanufacturers;
# 4. Clean up vendors
DELETE FROM oxvendor;
# 5. Replace "oxvendor" with "oxmanufacturers" in oxvendor.sql
# 6. Import oxvendor.sql
# 7. Replace "oxmanufacturers" with "oxvendor" in oxmanufacturers.sql
# 8. Import oxmanufacturers.sql

## Rundeck Mattermost Webhook Notification
<?php
/*
 * ProudCommerce | 2019
 * www.proudcommerce.com
 *
 * https://docs.mattermost.com/developer/webhooks-incoming.html
 * https://github.com/ThibaudDauce/mattermost-php
*/
require __DIR__ . '/vendor/autoload.php';

## OXID eShop - MySQL Snippets
/*** ARTIKEL / ARTICLES ***/
/******************************************************/

/* artikelnamen aller artikel anzeigen, welcher einer bestimmten kategorie zugeordnet sind [proudcommerce.com] */
select oxarticles.oxtitle, oxarticles.OXVARSELECT as Variant, oxcategories.OXTITLE as Kategorie from oxarticles left join oxobject2category on oxarticles.OXID = oxobject2category.OXOBJECTID left join oxcategories on oxcategories.OXID = oxobject2category.OXCATNID where oxcategories.OXROOTID = '<YOUR-CATEGORY-OXID>';

/* variantenpreise (oxvarmin, oxvarmax) anhand der aktuellen artikel aktualisieren [foxido.de] */
UPDATE oxarticles B, (SELECT oxparentid,MIN( oxprice ) AS min ,MAX( oxprice ) AS max FROM oxarticles GROUP BY oxparentid) AS A SET oxvarminprice = A.min, oxvarmaxprice = A.max WHERE B.oxid = A.oxparentid


## OXID eShop - check if column exists
   protected function _dbColumnExist($sTable, $sColumn)
    {
        $sDbName = oxRegistry::getConfig()->getConfigParam('dbName');
        $sSql = sprintf("SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '%s' AND TABLE_NAME = '%s' "
            . " AND COLUMN_NAME = '%s'",
            $sDbName, $sTable, $sColumn);
        return oxDb::getDb()->getOne($sSql);
    }

## OXID eShop - gets first subcategory and redirect to this
<?php
/**
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * @copyright (c) Proud Sourcing GmbH | 2014
 * @link https://gist.github.com/proudcommerce
 * @link http://www.proudcommerce.com

## OXID eShop - Redirect old seo urls
<?php
/**
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * @copyright (c) Proud Sourcing GmbH | 2013
 * @link https://gist.github.com/proudcommerce
 * @version 1.0.0
	[{* Create module with tmeplate block for: admin_header_links *}]
	[{$smarty.block.parent}]
	<script>
	setInterval(function () {
	window.location.href=window.location.href;
	}, 1800000);
	</script>
	# thx to alfred (https://github.com/alfredbez) for sharing
	# add to modules/functions.php

	use Monolog\Logger;
	use Monolog\Handler\StreamHandler;
	use OxidEsales\EshopCommunity\Internal\Container\ContainerFactory;
	use Psr\Log\LoggerInterface;
	use Symfony\Component\DependencyInjection\Exception\ServiceCircularReferenceException;

	function getLogger() {
	iLangPerTable (8)
	= definiert die mögliche Zahl an Sprachtabellen

	sLangTableSuffix (_set)
	= optionaler Suffix für Sprachtabellen

	iPasswordLength (6)
	= definiert die Mindestlänge des Kundenpasswortes

	blSkipFormatConversion (false)
	# 1. Export oxvendors table + data (eg. oxvendor.sql)
	# 2. Export oxmanufacturers table + data (eg. oxmanufacturers.sql)
	# 3. Clean up manufacturers
	DELETE FROM oxmanufacturers;
	# 4. Clean up vendors
	DELETE FROM oxvendor;
	# 5. Replace "oxvendor" with "oxmanufacturers" in oxvendor.sql
	# 6. Import oxvendor.sql
	# 7. Replace "oxmanufacturers" with "oxvendor" in oxmanufacturers.sql
	# 8. Import oxmanufacturers.sql
	<?php
	/*
	* ProudCommerce \| 2019
	* www.proudcommerce.com
	*
	* https://docs.mattermost.com/developer/webhooks-incoming.html
	* https://github.com/ThibaudDauce/mattermost-php
	*/
	require __DIR__ . '/vendor/autoload.php';
	/* ARTIKEL / ARTICLES */
	/******************************************************/

	/* artikelnamen aller artikel anzeigen, welcher einer bestimmten kategorie zugeordnet sind [proudcommerce.com] */
	select oxarticles.oxtitle, oxarticles.OXVARSELECT as Variant, oxcategories.OXTITLE as Kategorie from oxarticles left join oxobject2category on oxarticles.OXID = oxobject2category.OXOBJECTID left join oxcategories on oxcategories.OXID = oxobject2category.OXCATNID where oxcategories.OXROOTID = '<YOUR-CATEGORY-OXID>';

	/* variantenpreise (oxvarmin, oxvarmax) anhand der aktuellen artikel aktualisieren [foxido.de] */
	UPDATE oxarticles B, (SELECT oxparentid,MIN( oxprice ) AS min ,MAX( oxprice ) AS max FROM oxarticles GROUP BY oxparentid) AS A SET oxvarminprice = A.min, oxvarmaxprice = A.max WHERE B.oxid = A.oxparentid
	protected function _dbColumnExist($sTable, $sColumn)
	{
	$sDbName = oxRegistry::getConfig()->getConfigParam('dbName');
	$sSql = sprintf("SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '%s' AND TABLE_NAME = '%s' "
	. " AND COLUMN_NAME = '%s'",
	$sDbName, $sTable, $sColumn);
	return oxDb::getDb()->getOne($sSql);
	}
	<?php
	/**
	* This program is free software: you can redistribute it and/or modify
	* it under the terms of the GNU General Public License as published by
	* the Free Software Foundation, either version 3 of the License, or
	* (at your option) any later version.
	*
	* @copyright (c) Proud Sourcing GmbH \| 2014
	* @link https://gist.github.com/proudcommerce
	* @link http://www.proudcommerce.com