proudcommerce

# 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() {

proudcommerce

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)

proudcommerce

# 1. Export oxvendors table + date (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

proudcommerce

<?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';

proudcommerce

/*** 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

proudcommerce

   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);
    }

proudcommerce

<?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

proudcommerce

<?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