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