require_once '../../com_virtuemart/ajax/acl.php';
require_once "../../com_importer/ajax/lib.php";
ajaxACL(__FILE__, array('administrator', 'super administrator'));
$pdo = STN::getPDO();
$results = $pdo->query("\n\tSELECT *\n\t\tFROM `stn_matchup_results`\n\t\tWHERE `import_status` = 'Y' AND `dup_field` != 'no'\n\t;\n");
$rowCount = $results->rowCount();
include_once "{$mosConfig_absolute_path}/administrator/components/com_virtuemart/virtuemart.cfg.php";
$error = array();
$errorSkus = array();
$alreadyImported = array();
$markImported = $pdo->prepare("\n\tUPDATE `stn_matchup_results`\n\t\tSET `import_status`='AI'\n\t\tWHERE `ID`=:id\n\t;\n");
STN::depend('ProductDataProvider');
$processedSkus = array();
try {
belongsToGroup($_SESSION, 'super administrator');
$provider = getProvider('STN');
$categories = $provider->getCategories();
$unImportable = array();
$importedCount = 0;
foreach ($results->fetchAll(PDO::FETCH_ASSOC) as $importable) {
$sku = $importable['stn_sku_match'];
if (empty($sku)) {
$error[] = 'No import candidate for item number: ' . $importable['POSItemNumber'] . ' missing SKU.';
continue;
}
if (productExistsLocally($sku, STN::getPDO())) {
$alreadyImported[] = $sku;
$importCount += 1;
continue;
}
try {
<?php
// Get list of all users or one in particualr if the id is given
include_once '../include/headers.php';
include_once '../include/dbutils.php';
include_once '../include/main.php';
include_once 'domain/providers.php';
db_connect();
$expand = isset($_GET['expand']) ? $_GET['expand'] : null;
$clothId = isset($_GET['clothId']) ? $_GET['clothId'] : null;
$country = isset($_GET['country']) ? $_GET['country'] : 'ARG';
if (isset($_GET['id'])) {
$value = getProvider($_GET['id']);
} else {
$value = getProviders($clothId, $expand);
}
//return JSON array
exit(json_encode($value));
