/**
* Wait for the reports to be generated, requests and parses them.
*
* @param object $service
* @param string $region
* @param array $creds
* @return string
*/
function do_report(MarketplaceWebService_Interface $service, $region, $creds)
{
// Retrieve, validate and add the report request ID to the template.
if (!($requestID = trim(file_get_contents(CACHE_REQ_FILE . $region)))) {
trigger_error('Could not read Request ID cache file', E_USER_ERROR);
}
// Create an array with the regional report request IDs.
$requestID = explode("\n", $requestID);
// Retrieve the start time, if set. Otherwise generate it now.
if (is_file(CACHE_TIME_FILE . $region)) {
$starttime = intval(file_get_contents(CACHE_TIME_FILE . $region));
} else {
$starttime = time();
file_put_contents(CACHE_TIME_FILE . $region, $starttime);
}
$reportID = array();
// Create the request object to retrieve all reports from the last day.
$request = new MarketplaceWebService_Model_GetReportListRequest();
$request->setMerchant($creds['merchant_id']);
// $request->setAvailableFromDate (new DateTime ('-1 days', new DateTimeZone ('UTC')));
$IDList = new MarketplaceWebService_Model_IdList();
$IDs = array();
foreach ($requestID as $line) {
list($region, $ID) = explode("\t", $line);
$IDs[] = $ID;
}
$IDList->setId($IDs);
$request->setReportRequestIdList($IDList);
// $request->setAcknowledged (false);
$reportID = array();
foreach ($requestID as $line) {
// Split region and request ID, and ready region for use in constants.
list($region, $ID) = explode("\t", $line);
// If current regions report ID has been retrieved, skip to next.
if (isset($reportID[$region])) {
continue;
}
// Retrieve the report IDs.
$ID = Get_ReportID($service, $request, $ID, $creds['merchant_id']);
if ($ID) {
$reportID[$region] = $ID;
}
}
// Calculate running time.
$runtime = intval((time() - $starttime) / 60);
if ($runtime > 1) {
$runtime .= " minutes";
} else {
$runtime .= " minute";
}
// If not all report IDs has been found, keep waiting for 1 more minute then refresh.
if (count($reportID) != count($requestID)) {
return $runtime;
}
// Fetch previously added items from dbfeeds_products_extra.
$tableFeeds = TABLE_DBFEEDS_PROD_EXTRA;
$tableProds = TABLE_PRODUCTS;
$tableProdDesc = TABLE_PRODUCTS_DESCRIPTION;
$query = <<<OutSQL
SELECT p.`products_id`, fe.`extra_value` AS asin
FROM dbfeed_products_extra AS fe
INNER JOIN products AS p ON p.`products_id` = fe.`products_id`
INNER JOIN products_description AS pd ON pd.`products_id` = p.`products_id` AND pd.`language_id` = 1
WHERE fe.`dbfeed_class` LIKE 'dbfeed_amazon%' AND `extra_field` = 'asin'
GROUP BY p.`products_id`
ORDER BY pd.`products_name`
OutSQL;
if (!($res = mysql_query($query))) {
trigger_error("Could not retrieve local product details: " . $query . "\n" . mysql_error(), E_USER_ERROR);
}
// Store ASIN and PID in a temp array to check for existing products when parsing Amazon reports.
$localData = array();
while ($row = mysql_fetch_array($res)) {
$localData[$row['asin']] = $row['products_id'];
}
$amazonData = $skipList = array();
foreach ($reportID as $region => $ID) {
// Retrieve report from Amazon.
$request = new MarketplaceWebService_Model_GetReportRequest();
$request->setMerchant($creds['merchant_id']);
$request->setReport(@fopen('php://memory', 'rw+'));
$request->setReportId($ID);
// Lower-case region for use in filename.
$region = strtolower($region);
// Retrieve report details and save for aggregation.
$temp = explode("\n", mb_convert_encoding(Get_Report($service, $request), 'UTF-8'));
// Fetch primary data for Canada.
if ($region == 'ca') {
// Create array of headers, for easier indexing of data.
$headers = array_flip(explode("\t", trim(array_shift($amazonData['ca']))));
// Create the data source array in a specific order, to ensure there are no surprises later on.
while ($product = array_shift($temp)) {
$SKU = $product[$headers['seller-sku']];
// If current element exists in the skip-list: Skip.
if (isset($skipList[$SKU])) {
continue;
}
// New product, add to output data array.
$amazonData[$SKU]['asin'] = '';
$amazonData[$SKU]['sku'] = $product[$headers['seller-sku']];
$amazonData[$SKU]['price'] = $product[$headers['price']];
$amazonData[$SKU]['desc'] = $product[$headers['item-name']];
$amazonData[$SKU]['name'] = $product[$headers['item-name']];
}
} else {
// Since CA's main report is lacking the ASIN, add it to the data array.
if ($region == 'ca asin') {
$headers = array_flip(explode("\t", trim(array_shift($amazonData['ca asin']))));
// Save all Amazon CA ASIN numbers, for later referencing.
while ($product = array_shift($temp)) {
$SKU = $product[$headers['sku']];
$ASIN = $product[$headers['asin']];
// If ASIN has been set in the database already.
if (isset($localData[$ASIN])) {
// Check if the main report has been processed.
if (isset($amazonData[$SKU])) {
// Have, remove current line from the output data array.
unset($amazonData[$SKU]);
} else {
// Have not, add current product to the skip-list.
$skipList[$SKU] = true;
}
// Skip to next element.
continue;
}
// New product, add the ASIN to the output data array.
$product = explode("\t", trim($product));
$amazonData[$SKU]['asin'] = $ASIN;
}
} else {
// Create array of US CSV headers, for easier indexing of data.
$headers = array_flip(explode("\t", trim(array_shift($temp))));
while ($product = array_shift($temp)) {
// Explode the current CSV line, and ready variables for inclusion into the output data array.
$product = explode("\t", trim($product));
$SKU = $product[$headers['seller-sku']];
$ASIN = $product[$headers['asin1']];
$name = $product[$headers['item-name']];
$price = $product[$headers['price']];
$desc = mb_substr($product[$headers['item-description']], 0, 100, 'UTF-8');
$amazonData[$SKU] = array('asin' => $ASIN, 'sku' => $SKU, 'price' => $price, 'desc' => $desc, 'name' => $name);
}
}
}
}
// Serialize the data, and save it to temp file, so that we don't have to repeat all of this waiting again.
if (!file_put_contents(CACHE_REP_FILE . $region, serialize($amazonData))) {
trigger_error('Could not write to aggregate report data file.', E_USER_ERROR);
}
// Delete request ID cache file.
unlink(CACHE_REQ_FILE . $region);
unlink(CACHE_TIME_FILE . $region);
// Redirect to next step.
header("Location: http://{$_SERVER['SERVER_NAME']}{$_SERVER['SCRIPT_NAME']}?feed=" . rawurlencode($_GET['feed']));
die;
}
/**
* Sets the value of the MarketplaceIdList.
*
* @param IdList MarketplaceIdList
* @return void
*/
public function setMarketplaceIdList($value)
{
if (array_key_exists('MarketplaceIdList', $this->fields)) {
$marketplaceIdList = new MarketplaceWebService_Model_IdList();
$marketplaceIdList->setId($value['Id']);
$this->fields['MarketplaceIdList']['FieldValue'] = $marketplaceIdList;
}
return $this;
}
/**
* Sets the value of the MarketplaceIdList.
*
* @param IdList MarketplaceIdList
* @return void
*/
public function setMarketplaceIdList($value)
{
$marketplaceIdList = new MarketplaceWebService_Model_IdList();
$marketplaceIdList->setId($value['Id']);
$this->fields['MarketplaceIdList']['FieldValue'] = $marketplaceIdList;
return;
}
/**
* Sets the value of the MarketplaceIdList.
*
* @param IdList MarketplaceIdList
* @return void
*/
public function setMarketplaceIdList($value)
{
require_once dirname(__FILE__) . '/IdList.php';
$marketplaceIdList = new MarketplaceWebService_Model_IdList();
$marketplaceIdList->setId($value['Id']);
$this->fields['MarketplaceIdList']['FieldValue'] = $marketplaceIdList;
return;
}
public function getReportRequestList_v2($ReportRequestId = false)
{
WPLA()->logger->info('getReportRequestList_v2()');
$this->initAPI();
$request = new MarketplaceWebService_Model_GetReportRequestListRequest();
$request->setMerchant($this->SellerId);
$request->setMarketplace($this->MarketplaceId);
if ($ReportRequestId) {
if (!is_array($ReportRequestId)) {
$ReportRequestId = array($ReportRequestId);
}
// $request->setReportRequestIdList( $ReportRequestId );
$idList = new MarketplaceWebService_Model_IdList();
// $idList->withId('<Feed Submission Id>');
$idList->setId($ReportRequestId);
$request->setReportRequestIdList($idList);
} else {
$request->setMaxCount(10);
}
$result = $this->invokeGetReportRequestList($this->service, $request);
return $result;
}
