private static function importSales($file)
{
$error = array();
$row = 0;
if (($handle = fopen($file['tmp_name'], "r")) !== false) {
$cols = array(SALE_ORDER_NUMBER, SALE_ORDER_CHARGED_DATE, SALE_ORDER_CHARGED_TIMESTAMP, SALE_FINANCIAL_STATUS, SALE_DEVICE_MODEL, SALE_PRODUCT_TITLE, SALE_PRODUCT_ID, SALE_PRODUCT_TYPE, SALE_SKU_ID, SALE_CURRENCY_CODE, SALE_ITEM_PRICE, SALE_TAXES_COLLECTED, SALE_CHARGED_AMOUNT, SALE_BUYER_CITY, SALE_BUYER_STATE, SALE_BUYER_POSTAL_CODE, SALE_BUYER_COUNTRY, SALE_APP_ID);
while (($data = fgetcsv($handle, 1000, ",")) !== false) {
if ($row > 0) {
$rowCount = count($data);
if ($rowCount != CHECKOUT_SALES_FILE_COL_COUNT) {
$error[] = 'Row #' . $row . ' has invalid column count ' . $rowCount . '/' . CHECKOUT_SALES_FILE_COL_COUNT;
} else {
$values = array();
for ($colIdx = 0; $colIdx < $rowCount; ++$colIdx) {
$values[$cols[$colIdx]] = $data[$colIdx];
}
}
$res = DbHelper::insertSale($values);
if ($res != null) {
$error[] = 'Row #' . $row . ' insertion failed : ' . $res;
}
}
++$row;
}
fclose($handle);
}
return $error;
}
