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; }