public function __construct(IniParams $iniParams, $okOrderStatusesArray, Logger $logger)
{
$this->bfVersion = $iniParams->get("bfVersion");
$this->orderShipCarrier = $iniParams->get("orderShipCarrier");
$this->orderShipMethod = $iniParams->get("orderShipMethod");
$this->okOrderStatusesArray = $okOrderStatusesArray;
$this->logger = $logger;
}
public function __construct(IniParams $iniParams, $okProductsUpdatesArray, Logger $logger)
{
$this->idPrefix = $iniParams->get("idPrefix");
$this->bfVersion = $iniParams->get("bfVersion");
$this->taxCategory = $iniParams->get("taxCategory");
$this->viewAllowCategory = $iniParams->get("viewAllowCategory");
$this->okProductsUpdatesArray = $okProductsUpdatesArray;
$this->logger = $logger;
}
public static function deleteTestsOrders(IniParams $iniParams, Db $db)
{
$selectOkOrdersId = "SELECT orders_id FROM orders WHERE channels_id = :channelId";
$sqlParams = array("channelId" => $iniParams->get("channelId"));
$okOrdersIdArray = $db->getAll($selectOkOrdersId, $sqlParams);
if ($okOrdersIdArray) {
foreach ($okOrdersIdArray as $okOrderId) {
$sqlParams = array("okOrderId" => $okOrderId->orders_id);
$deleteSql = "DELETE FROM orders WHERE orders_id = :okOrderId";
$db->execute($deleteSql, $sqlParams);
$deleteSql = "DELETE FROM orders_products WHERE orders_id = :okOrderId";
$db->execute($deleteSql, $sqlParams);
$deleteSql = "DELETE FROM orders_status_history WHERE orders_id = :okOrderId";
$db->execute($deleteSql, $sqlParams);
$deleteSql = "DELETE FROM orders_total WHERE orders_id = :okOrderId";
$db->execute($deleteSql, $sqlParams);
}
}
}
use E7\Actors\Client\DataProviders\OkCategoriesDataProvider;
use E7\Actors\Client\Objects\OkCategoryList;
use E7\Actors\Client\CategoryMapper\CsvCategoryMapper;
// =========== Variables ===========
// Pour limiter l'export aux catégories présentes dans un fichier flux CSV, indiquer ici son emplacement / URL
//$activeCatsCsvFilePath = "feeds/BfWork/client-2014-11-24_16-47.csv";
//$exportFilePath = __DIR__ . "/Export/ClientActiveCats.csv";
// Sinon, utiliser les variables ci-dessous
$activeCatsCsvFilePath = "";
$exportFilePath = __DIR__ . "/Export/ClientCatMapping.csv";
// =========== Setup context ===========
require 'bootstrap.php';
$argv = $GLOBALS["argv"];
$cliParams = new CliParams();
$cliParams->parse($argv);
$iniParams = new IniParams($cliParams->getConfigFilePath());
$logger = LoggerFactory::getNullLogger();
$db = new Db($iniParams->get("dbHostReadOnly"), $iniParams->get("dbNameReadOnly"), $iniParams->get("dbUserReadOnly"), $iniParams->get("dbPassReadOnly"), $logger);
// =========== Get active cat list from CSV ===========
$activeCatsIds = array();
if ($activeCatsCsvFilePath !== "") {
$csvFile = new CsvFile($activeCatsCsvFilePath, "\t");
$activeCatsIds = array();
foreach ($csvFile->getAll() as $csvLine) {
$activeCatsIds[] = $csvLine->categories_categories_id;
}
$activeCatsIds = array_unique($activeCatsIds);
}
// =========== Get and process categories, then create CSV ===========
$okCategoriesDataProvider = new OkCategoriesDataProvider($db, 1);
// 1 = français
