Amazon SP API拉取日期范围报告和分类树

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for yibai_amazon_report_zn_title
-- ----------------------------
DROP TABLE IF EXISTS `yibai_amazon_report_zn_title`;
CREATE TABLE `yibai_amazon_report_zn_title`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `column` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'column',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
  `UK` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'UK',
  `DE` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'DE',
  `FR` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'FR',
  `ES` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'ES',
  `IT` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'IT',
  `NL` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'NL',
  `PL` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'PL',
  `SE` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'SE',
  `TR` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'TR',
  `US` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'US',
  `CA` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'CA',
  `MX` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'MX',
  `BR` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'BR',
  `JP` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'JP',
  `creator` int(11) NOT NULL DEFAULT 0 COMMENT '添加人',
  `create_time` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '修改时间',
  `BE` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '比利时',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Amazon日期范围报告表头' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of yibai_amazon_report_zn_title
-- ----------------------------
INSERT INTO `yibai_amazon_report_zn_title` VALUES (1, 'date_time', 'date/time', 'date/time', 'Datum/Uhrzeit', 'date/heure', 'fecha y hora', 'Data/Ora', 'datum/tijd', 'data/godzina', 'datum/tid', 'tarih/saat', 'date/time', 'date/time', 'fecha/hora', 'data/hora', 'HM-46スピーカーマイク Delaman ハンドヘルド', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'date/heure');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (2, 'settlement_id', 'settlement id', 'settlement id', 'Abrechnungsnummer', 'numéro de versement', 'identificador de pago', 'Numero pagamento', 'schikkings-ID', 'identyfikator rozliczenia', 'reglerings-id', 'hesap kesim no', 'settlement id', 'settlement id', 'Id de liquidación', 'id de liquidação', '決済番号', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'Identifiant du paiement');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (3, 'type', 'type', 'type', 'Typ', 'type', 'tipo', 'Tipo', 'type', 'typ', 'typ', 'tip', 'type', 'type', 'tipo ', 'tipo', 'トランザクションの種類', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'type');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (4, 'order_id', 'order id', 'order id', 'Bestellnummer', 'numéro de la commande', 'número de pedido', 'Numero ordine', 'bestelnummer', 'identyfikator zamówienia', 'beställnings-id', 'sipariş no', 'order id', 'order id', 'Id del pedido', 'id do pedido', '注文番号', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'Numéro de la commande');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (5, 'sku', 'sku', 'sku', 'SKU', 'sku', 'sku', 'SKU', 'sku', 'sku', 'sku', 'sku', 'sku', 'sku', 'sku', 'sku', 'SKU', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'SKU');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (6, 'description', 'description', 'description', 'Beschreibung', 'description', 'descripción', 'Descrizione', 'beschrijving', 'opis', 'beskrivning', 'açıklama', 'description', 'description', 'descripción', 'descrição', '説明', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'description');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (7, 'quantity', 'quantity', 'quantity', 'Menge', 'quantité', 'cantidad', 'Quantità', 'aantal', 'ilość', 'antal', 'adet', 'quantity', 'quantity', 'cantidad', 'quantidade', '数量', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'quantité');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (8, 'marketplace', 'marketplace', 'marketplace', 'Marketplace', 'Marketplace', 'web de Amazon', 'Marketplace', 'marketplace', 'rynek', 'marknadsplats', 'pazar yeri', 'marketplace', 'marketplace', 'marketplace', 'mercado', 'Amazon 出品サービス', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'site de vente');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (9, 'account_type', 'account type', '', '', '', '', '', '', '', '', '', 'account type', '', '', 'tipo de conta', '', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', '');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (10, 'fulfillment', 'fulfillment', 'fulfilment', 'Versand', 'traitement', 'gestión logística', 'Gestione', 'fulfillment', 'realizacja', 'leverans', 'gönderim', 'fulfillment', 'fulfillment', 'cumplimiento', 'atendimento', 'フルフィルメント', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'expédition');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (11, 'order_city', 'order city', 'order city', 'Ort der Bestellung', 'ville d', 'ciudad de procedencia del pedido', 'Città di provenienza dell', 'bestelling stad', 'miejscowość zamówienia', 'stad för beställning', 'sipariş şehri', 'order city', 'order city', 'ciudad del pedido', 'cidade do pedido', '市町村', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'ville de la commande');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (12, 'order_state', 'order state', 'order state', 'Bundesland', 'Région d', 'comunidad autónoma de procedencia del pedido', 'Provincia di provenienza dell', 'status bestelling', 'stan zamówienia', 'delstat för beställning', 'sipariş durumu', 'order state', 'order state', 'estado del pedido', 'estado do pedido', '都道府県', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'état de la commande');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (13, 'order_postal', 'order postal', 'order postal', 'Postleitzahl', 'code postal de la commande', 'código postal de procedencia del pedido', 'CAP dell', 'bestelling per post', 'przekaz pocztowy', 'postadress för beställning', 'sipariş postası', 'order postal', 'order postal', 'código postal del pedido', 'postal do pedido', '郵便番号', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'commande postale');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (14, 'tax_collection_model', 'tax collection model', 'tax collection model', 'Steuererhebungsmodell', 'Modèle de perception des taxes', 'Formulario de recaudación de impuestos', 'modello di riscossione delle imposte', '', '', '', '', 'tax collection model', 'tax collection model', 'modelo de recaudación de impuestos', '', '税金徴収型', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', '');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (15, 'product_sales', 'product sales', 'product sales', 'Umsätze', 'ventes de produits', 'ventas de productos', 'Vendite', 'verkoop van producten', 'sprzedaż produktów', 'försäljning av produkter', 'ürün satışları', 'product sales', 'product sales', 'ventas de productos', 'vendas do produto', '商品売上', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'ventes de produits');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (16, 'product_sales_tax', 'product sales tax', 'product sales tax', 'Produktumsatzsteuer', 'Taxes sur la vente des produits', 'impuesto de ventas de productos', 'imposta sulle vendite dei prodotti', '', '', '', '', 'product sales tax', 'product sales tax', 'impuesto de ventas de productos', '', '商品の売上税', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', '');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (17, 'shipping_credits', 'shipping credits', 'shipping credits', 'Gutschrift für Versandkosten', 'crédits d', 'abonos de envío', 'Accrediti per le spedizioni', 'Verzendtegoeden', 'noty kredytowe za wysyłkę', 'fraktkrediter', 'kargo kredileri', 'shipping credits', 'shipping credits', 'créditos de envío', 'créditos de remessa', '配送料', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'crédits d’expédition');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (18, 'shipping_credits_tax', 'shipping credits tax', 'shipping credits tax', 'Steuer auf Versandgutschrift', 'taxe sur les crédits d’expédition', 'impuestos por abonos de envío', 'imposta accrediti per le spedizioni', '', 'środki na pokrycie pakowania na prezent', '', '', 'shipping credits tax', 'shipping credits tax', 'impuesto de abono de envío', '', '配送料の税金', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', '');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (19, 'gift_wrap_credits', 'gift wrap credits', 'gift wrap credits', 'Gutschrift für Geschenkverpackung', 'crédits sur l', 'abonos de envoltorio para regalo', 'Accrediti per confezioni regalo', 'kredietpunten cadeauverpakking', '', 'krediter för presentinslagning', '', 'gift wrap credits', 'gift wrap credits', 'créditos por envoltorio de regalo', '', 'ギフト包装手数料', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'crédits d’emballage-cadeau');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (20, 'gift_wrap_credits_tax', 'gift wrap credits tax', 'gift wrap credits tax', 'Steuer auf Geschenkverpackungsgutschriften', 'Taxes sur les crédits cadeaux', 'giftwrap credits tax', 'imposta sui crediti confezione regalo', '', '', '', '', 'giftwrap credits tax', 'giftwrap credits tax', 'impuesto de créditos de envoltura', '', 'ギフト包装クレジットの税金', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', '');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (21, 'regulatory_fee', 'Regulatory fee', '', '', '', '', '', '', '', '', '', 'Regulatory Fee', 'Regulatory fee', 'Tarifa reglamentaria', '', '', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', '');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (22, 'tax_on_regulatory_fee', 'Tax on regulatory fee', '', '', '', '', '', '', '', '', '', 'Tax On Regulatory Fee', 'Tax on regulatory fee', 'Impuesto sobre tarifa reglamentaria', '', 'Amazonポイントの費用', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', '');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (23, 'promotional_rebates', 'promotional rebates', 'promotional rebates', 'Rabatte aus Werbeaktionen', 'Rabais promotionnels', 'devoluciones promocionales', 'Sconti promozionali', '', 'rabaty promocyjne', 'kampanjrabatter', 'promosyon indirimleri', 'promotional rebates', 'promotional rebates', 'descuentos promocionales', 'descontos promocionais', 'プロモーション割引額', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'Total des réductions');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (24, 'promotional_rebates_tax', 'promotional rebates tax', 'promotional rebates tax', 'Steuer auf Aktionsrabatte', 'Taxes sur les remises promotionnelles', 'promotional rebates tax', 'imposta sugli sconti promozionali', 'promotiekortingen', '', '', '', 'promotional rebates tax', 'promotional rebates tax', 'impuesto de reembolsos promocionales', 'imposto de vendas coletados', 'プロモーション割引の税金', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', '');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (25, 'sales_tax_collected', 'sales tax collected', '', '', '', '', '', 'ge?nde omzetbelasting', 'pobrany podatek od sprzeda?y', 'Inkasserad moms', '', '', '', '', 'tarifas de venda', '', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'taxe de ventes prélevée');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (26, 'marketplace_facilitator_tax', 'marketplace facilitator tax', '', '', '', '', '', 'Belasting voor marketplace-facilitator', 'Marketplace Facilitator Tax', 'Skatt för marknadsplatsförmedlare', '', '', '', '', '', '', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'Taxe Marketplace Facilitator');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (27, 'marketplace_withheld_tax', 'marketplace withheld tax', 'marketplace withheld tax', 'Einbehaltene Steuer auf Marketplace', 'Taxes retenues sur le site de vente', 'impuesto retenido en el sitio web', 'trattenuta IVA del marketplace', '', '', '', '', 'marketplace withheld tax', 'marketplace withheld tax', 'impuesto de retenciones en la plataforma', '', '源泉徴収税を伴うマーケットプレイス', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', '');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (28, 'selling_fees', 'selling fees', 'selling fees', 'Verkaufsgebühren', 'frais de vente', 'tarifas de venta', 'Commissioni di vendita', 'verkoopkosten', 'opłaty za sprzedaż', 'försäljningsavgifter', 'satış ücretleri', 'selling fees', 'selling fees', 'tarifas de venta', '', '手数料', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'frais de vente');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (29, 'fba_fees', 'fba fees', 'fba fees', 'Gebühren zu Versand durch Amazon', 'Frais Expédié par Amazon', 'tarifas de Logística de Amazon', 'Costi del servizio Logistica di Amazon', 'fba-vergoedingen', 'opłaty za fba', 'fba-avgifter', 'Amazon Lojistik ücretleri', 'fba fees', 'fba fees', 'tarifas fba', 'taxas fba', 'FBA 手数料', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'Frais pour le service Expédié par Amazon');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (30, 'other_transaction_fees', 'other transaction fees', 'other transaction fees', 'Andere Transaktionsgebühren', 'autres frais de transaction', 'tarifas de otras transacciones', 'Altri costi relativi alle transazioni', 'overige transactiekosten', 'inne opłaty transakcyjne', 'övriga transaktionsavgifter', 'diğer işlem ücretleri', 'other transaction fees', 'other transaction fees', 'tarifas de otra transacción', 'taxas de outras transações', 'トランザクションに関するその他の手数料', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'autres frais de transaction');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (31, 'other', 'other', 'other', 'Andere', 'autre', 'otro', 'Altro', 'overige', 'inne', 'Övrigt', 'diğer', 'other', 'other', 'otro', 'outro', 'その他', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'autres');
INSERT INTO `yibai_amazon_report_zn_title` VALUES (32, 'total', 'total', 'total', 'Gesamt', 'total', 'total', 'totale', 'totaal', 'suma', 'totalt', 'toplam', 'total', 'total', 'total', 'total', '合計', 5249, '2022-05-12 08:29:57', '2023-07-06 11:09:58', 'total');

SET FOREIGN_KEY_CHECKS = 1;

$result = $requestReport->getreportstatus($account->merchant_id,strtolower($account->site),'/reports/2021-06-30/reports/'.$val['reportid'],"","","GET");//按reportid拉取
Array
(
    [reportType] => GET_DATE_RANGE_FINANCIAL_TRANSACTION_DATA
    [processingEndTime] => 2023-07-05T09:53:55+00:00
    [processingStatus] => DONE
    [marketplaceIds] => Array
        (
            [0] => A33AVAJ2PDY3EV
        )

    [reportDocumentId] => amzn1.spdoc.1.4.eu.eea6506b-801e-4e09-86fd-ca0586f647de.T2317I9CIX7RVN.1202
    [reportId] => 627541019543
    [dataEndTime] => 2023-06-30T21:00:00+00:00
    [createdTime] => 2023-07-05T09:53:55+00:00
    [processingStartTime] => 2023-07-05T09:53:55+00:00
    [dataStartTime] => 2023-05-31T21:00:00+00:00
)

Array
(
    [reportDocumentId] => amzn1.spdoc.1.4.eu.eea6506b-801e-4e09-86fd-ca0586f647de.T2317I9CIX7RVN.1202
    [url] => https://tortuga-prod-eu.s3-eu-west-1.amazonaws.com/%2FNinetyDays/amzn1.tortuga.4.eu.eea6506b-801e-4e09-86fd-ca0586f647de.T2317I9CIX7RVN?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20230708T074426Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=AKIAX2ZVOZFBO35GNC5T%2F20230708%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Signature=512531251748090b6bbfa2cb546e9efa846de21e8a87c309f0f05523d7810dba
)

CREATE TABLE `yibai_amazon_report_zn_detail_new` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `account_name` varchar(50) NOT NULL DEFAULT '' COMMENT '账号',
  `group_id` int(11) NOT NULL DEFAULT '0' COMMENT '组ID',
  `account_id` int(10) NOT NULL DEFAULT '0' COMMENT '账号ID',
  `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'date_time',
  `settlement_id` varchar(50) NOT NULL DEFAULT '' COMMENT 'settlement_id',
  `type` varchar(60) NOT NULL DEFAULT '' COMMENT 'type',
  `order_id` varchar(50) NOT NULL DEFAULT '' COMMENT 'order_id',
  `sku` varchar(50) NOT NULL DEFAULT '' COMMENT 'sku',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT 'description',
  `quantity` int(6) NOT NULL DEFAULT '0' COMMENT 'quantity',
  `marketplace` varchar(50) NOT NULL DEFAULT '' COMMENT 'marketplace',
  `account_type` varchar(50) NOT NULL DEFAULT '' COMMENT 'account type',
  `fulfillment` varchar(50) NOT NULL DEFAULT '' COMMENT 'fulfillment',
  `order_city` varchar(50) NOT NULL DEFAULT '' COMMENT 'order_city',
  `order_state` varchar(255) NOT NULL DEFAULT '' COMMENT 'order_state',
  `order_postal` varchar(50) NOT NULL DEFAULT '' COMMENT 'order_postal',
  `tax_collection_model` varchar(50) NOT NULL DEFAULT '' COMMENT 'tax_collection_model',
  `product_sales` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'product_sales',
  `product_sales_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'product_sales_原文',
  `product_sales_tax` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'product_sales_tax',
  `product_sales_tax_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'product_sales_tax_原文',
  `shipping_credits` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'shipping_credits',
  `shipping_credits_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'shipping_credits_原文',
  `shipping_credits_tax` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'shipping_credits_tax',
  `shipping_credits_tax_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'shipping_credits_tax_原文',
  `gift_wrap_credits` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'gift_wrap_credits',
  `gift_wrap_credits_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'gift_wrap_credits_原文',
  `gift_wrap_credits_tax` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'gift_wrap_credits_tax',
  `gift_wrap_credits_tax_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'gift_wrap_credits_tax_原文',
  `regulatory_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'regulatory_fee',
  `regulatory_fee_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'regulatory_fee_原文',
  `tax_on_regulatory_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'tax_on_regulatory_fee',
  `tax_on_regulatory_fee_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'tax_on_regulatory_fee_原文',
  `promotional_rebates` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'promotional_rebates',
  `promotional_rebates_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'promotional_rebates_原文',
  `promotional_rebates_tax` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'promotional_rebates_tax',
  `promotional_rebates_tax_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'promotional_rebates_tax_原文',
  `sales_tax_collected` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'sales_tax_collected',
  `sales_tax_collected_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'sales_tax_collected_原文',
  `marketplace_facilitator_tax` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'marketplace_facilitator_tax',
  `marketplace_facilitator_tax_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'marketplace_facilitator_tax_原文',
  `marketplace_withheld_tax` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'marketplace_withheld_tax',
  `marketplace_withheld_tax_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'marketplace_withheld_tax_原文',
  `selling_fees` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'selling_fees',
  `selling_fees_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'selling_fees_原文',
  `fba_fees` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'fba_fees',
  `fba_fees_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'fba_fees_原文',
  `other_transaction_fees` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'other_transaction_fees',
  `other_transaction_fees_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'other_transaction_fees_原文',
  `other` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'other',
  `other_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'other_原文',
  `total` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'total',
  `total_txt` varchar(100) NOT NULL DEFAULT '' COMMENT 'total_原文',
  `creator` int(11) NOT NULL DEFAULT '0' COMMENT 'creator',
  `create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'create_time',
  `batchnumber` char(8) NOT NULL DEFAULT '0' COMMENT '批次',
  `is_config` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:默认 1:已加入中文配置表',
  `is_user` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:系统拉取  1:人工导入',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_acc` (`account_id`) USING BTREE,
  KEY `idx_ct` (`create_time`) USING BTREE,
  KEY `idx_bn` (`batchnumber`) USING BTREE,
  KEY `idx_fulfillment` (`fulfillment`) USING BTREE,
  KEY `idx_type` (`type`) USING BTREE,
  KEY `idx_sku` (`sku`) USING BTREE,
  KEY `idx_order_id` (`order_id`) USING BTREE,
  KEY `idx_is_config` (`is_config`)
) ENGINE=InnoDB AUTO_INCREMENT=117442 DEFAULT CHARSET=utf8mb4 COMMENT='Amazon日期范围报告表';

    /*
     * 时间格式转换
     */
    public function datechange($site,$dateval){
        switch ($site){
            case 'us':
                $datearr = ['Jan'=>1,'Feb'=>2,'Mar'=>3,'Apr'=>4,'May'=>5,'Jun'=>6,'Jul'=>7,'Aug'=>8,'Sep'=>9,'Sept'=>9,'Oct'=>10,'Nov'=>11,'Dec'=>12];
                $arr = explode(' ',$dateval);
                $month = $datearr[$arr[0]];
                $year = $arr[2];
                $arr[1] = str_replace(',','',$arr[1]);
                $day = $arr[1];
                $time = $arr[3];
                return  $year.'-'.$month.'-'.$day.' '.$time;
            case 'ca':
                $datearr = ['Jan'=>1,'Feb'=>2,'Mar'=>3,'Apr'=>4,'May'=>5,'Jun'=>6,'Jul'=>7,'Aug'=>8,'Sep'=>9,'Sept'=>9,'Oct'=>10,'Nov'=>11,'Dec'=>12];
                $arr = explode(' ',$dateval);
                $month = $datearr[$arr[0]];
                $year = $arr[2];
                $arr[1] = str_replace(',','',$arr[1]);
                $day = $arr[1];
                $arr[4] = str_replace('.','',$arr[4]);
                $time = $arr[3];
                return  $year.'-'.$month.'-'.$day.' '.$time;
            case 'mx':
                $datearr = ['ene'=>1,'feb'=>2,'mar'=>3,'abr'=>4,'may'=>5,'jun'=>6,'jul'=>7,'ago'=>8,'sep'=>9,'sept'=>9,'oct'=>10,'nov'=>11,'dic'=>12];
                $arr = explode(' ',$dateval);
                $month = $datearr[$arr[1]];
                $year = $arr[2];
                $day = $arr[0];
                $time = $arr[3];
                return  $year.'-'.$month.'-'.$day.' '.$time;
            case 'uk':
                $datearr = ['Jan'=>1,'Feb'=>2,'Mar'=>3,'Apr'=>4,'May'=>5,'Jun'=>6,'Jul'=>7,'Aug'=>8,'Sep'=>9,'Sept'=>9,'Oct'=>10,'Nov'=>11,'Dec'=>12];
                $arr = explode(' ',$dateval);
                if($datearr[$arr[1]]){
                    $month = $datearr[$arr[1]];
                    $year = $arr[2];
                    $day = $arr[0];
                    $time = $arr[3];
                    return  $year.'-'.$month.'-'.$day.' '.$time;
                }else{
                    $dataarr = explode('.',$arr[0]);
                    $month = $dataarr[1];
                    $year = $dataarr[2];
                    $day = $dataarr[0];
                    $time = $arr[1];
                    return  $year.'-'.$month.'-'.$day.' '.$time;
                }
            case 'de':
                $datearr = ['jan'=>1,'feb'=>2,'mrt'=>3,'apr'=>4,'mei'=>5,'jun'=>6,'jul'=>7,'aug'=>8,'sep'=>9,'sept'=>9,'okt'=>10,'nov'=>11,'dec'=>12];
                $arr = explode(' ',$dateval);
                if($datearr[$arr[1]]){
                    $month = $datearr[$arr[1]];
                    $year = $arr[2];
                    $day = $arr[0];
                    $time = $arr[3];
                    return  $year.'-'.$month.'-'.$day.' '.$time;
                }else{
                    $dataarr = explode('.',$arr[0]);
                    $month = $dataarr[1];
                    $year = $dataarr[2];
                    $day = $dataarr[0];
                    $time = $arr[1];
                    return  $year.'-'.$month.'-'.$day.' '.$time;
                }
            case 'fr':
                $datearr = ['janv'=>1,'févr'=>2,'mars'=>3,'avr'=>4,'mai'=>5,'juin'=>6,'juil'=>7,'août'=>8,'sept'=>9,'sept'=>9,'oct'=>10,'nov'=>11,'déc'=>12];
                $arr = explode(' ',$dateval);
                $arr[1] = str_replace('.','',$arr[1]);
                $month = $datearr[$arr[1]];
                $year = $arr[2];
                $day = $arr[0];
                $time = $arr[3];
                return  $year.'-'.$month.'-'.$day.' '.$time;
            case 'es':
                $datearr = ['ene'=>1,'feb'=>2,'mar'=>3,'abr'=>4,'may'=>5,'jun'=>6,'jul'=>7,'ago'=>8,'sep'=>9,'sept'=>9,'oct'=>10,'nov'=>11,'dic'=>12];
                $arr = explode(' ',$dateval);
                if($datearr[$arr[1]]){
                    $month = $datearr[$arr[1]];
                    $year = $arr[2];
                    $day = $arr[0];
                    $time = $arr[3];
                    return  $year.'-'.$month.'-'.$day.' '.$time;
                }else{
                    $datearr = ['janv'=>1,'févr'=>2,'mars'=>3,'avr'=>4,'mai'=>5,'juin'=>6,'juil'=>7,'août'=>8,'sep'=>9,'sept'=>9,'oct'=>10,'nov'=>11,'déc'=>12];
                    $arr = explode(' ',$dateval);
                    $arr[1] = str_replace('.','',$arr[1]);
                    if($datearr[$arr[1]]){
                        $month = $datearr[$arr[1]];
                        $year = $arr[2];
                        $day = $arr[0];
                        $time = $arr[3];
                        return  $year.'-'.$month.'-'.$day.' '.$time;
                    }else{
                        $arr1 = explode('.',$arr[0]);
                        $year = $arr1[2];
                        $month = $arr1[1];
                        $day = $arr1[0];
                        $time = $arr[1];
                        return  $year.'-'.$month.'-'.$day.' '.$time;
                    }
                }
            case 'sp':
                $datearr = ['ene'=>1,'feb'=>2,'mar'=>3,'abr'=>4,'may'=>5,'jun'=>6,'jul'=>7,'ago'=>8,'sep'=>9,'sept'=>9,'oct'=>10,'nov'=>11,'dic'=>12];
                $arr = explode(' ',$dateval);
                if($datearr[$arr[1]]){
                    $month = $datearr[$arr[1]];
                    $year = $arr[2];
                    $day = $arr[0];
                    $time = $arr[3];
                    return  $year.'-'.$month.'-'.$day.' '.$time;
                }else{
                    $datearr = ['janv'=>1,'févr'=>2,'mars'=>3,'avr'=>4,'mai'=>5,'juin'=>6,'juil'=>7,'août'=>8,'sep'=>9,'sept'=>9,'oct'=>10,'nov'=>11,'déc'=>12];
                    $arr = explode(' ',$dateval);
                    $arr[1] = str_replace('.','',$arr[1]);
                    if($datearr[$arr[1]]){
                        $month = $datearr[$arr[1]];
                        $year = $arr[2];
                        $day = $arr[0];
                        $time = $arr[3];
                        return  $year.'-'.$month.'-'.$day.' '.$time;
                    }else{
                        $arr1 = explode('.',$arr[0]);
                        $year = $arr1[2];
                        $month = $arr1[1];
                        $day = $arr1[0];
                        $time = $arr[1];
                        return  $year.'-'.$month.'-'.$day.' '.$time;
                    }
                }
            case 'it':
                $datearr = ['gen'=>1,'feb'=>2,'mar'=>3,'apr'=>4,'mag'=>5,'giu'=>6,'lug'=>7,'ago'=>8,'set'=>9,'sept'=>9,'ott'=>10,'nov'=>11,'dic'=>12];
                $arr = explode(' ',$dateval);
                if($datearr[$arr[1]]){
                    $month = $datearr[$arr[1]];
                    $year = $arr[2];
                    $day = $arr[0];
                    $time = $arr[3];
                    return  $year.'-'.$month.'-'.$day.' '.$time;
                }else{
                    $datearr = ['jan'=>1,'feb'=>2,'mrt'=>3,'apr'=>4,'mei'=>5,'jun'=>6,'jul'=>7,'aug'=>8,'sep'=>9,'sept'=>9,'okt'=>10,'nov'=>11,'dec'=>12];
                    $month = $datearr[$arr[1]];
                    $year = $arr[2];
                    $day = $arr[0];
                    $time = $arr[3];
                    return  $year.'-'.$month.'-'.$day.' '.$time;
                }
            case 'nl':
                $datearr = ['jan'=>1,'feb'=>2,'mrt'=>3,'apr'=>4,'mei'=>5,'jun'=>6,'jul'=>7,'aug'=>8,'sep'=>9,'sept'=>9,'okt'=>10,'nov'=>11,'dec'=>12];
                $arr = explode(' ',$dateval);
                $arr[1] = str_replace('.','',$arr[1]);
                $month = $datearr[$arr[1]];
                $year = $arr[2];
                $day = $arr[0];
                $time = $arr[3];
                return  $year.'-'.$month.'-'.$day.' '.$time;
            case 'pl':
                $datearr = ['sty'=>1,'lut'=>2,'mar'=>3,'kwi'=>4,'maj'=>5,'cze'=>6,'lip'=>7,'sie'=>8,'wrz'=>9,'paź'=>10,'lis'=>11,'gru'=>12];
                $arr = explode(' ',$dateval);
                $month = $datearr[$arr[1]];
                $year = $arr[2];
                $day = $arr[0];
                $time = $arr[3];
                return  $year.'-'.$month.'-'.$day.' '.$time;
            case 'se':
                $datearr = ['jan'=>1,'feb'=>2,'mars'=>3,'apr'=>4,'maj'=>5,'juni'=>6,'juli'=>7,'aug'=>8,'sep'=>9,'sept'=>9,'okt'=>10,'nov'=>11,'dec'=>12];
                $arr = explode(' ',$dateval);
                $arr[1] = str_replace('.','',$arr[1]);
                if($datearr[$arr[1]]){
                    $month = $datearr[$arr[1]];
                    $year = $arr[2];
                    $day = $arr[0];
                    $time = $arr[3];
                    return  $year.'-'.$month.'-'.$day.' '.$time;
                }else{
                    $datearr = ['jan'=>1,'feb'=>2,'mrt'=>3,'apr'=>4,'mei'=>5,'jun'=>6,'jul'=>7,'aug'=>8,'sep'=>9,'sept'=>9,'okt'=>10,'nov'=>11,'dec'=>12];
                    $arr = explode(' ',$dateval);
                    $arr[1] = str_replace('.','',$arr[1]);
                    $month = $datearr[$arr[1]];
                    $year = $arr[2];
                    $day = $arr[0];
                    $time = $arr[3];
                    return  $year.'-'.$month.'-'.$day.' '.$time;
                }
            case 'tr':
                $datearr = ['Oca'=>1,'Şub'=>2,'Mar'=>3,'Nis'=>4,'May'=>5,'Haz'=>6,'Tem'=>7,'Ağu'=>8,'Eyl'=>9,'Eki'=>10,'Kas'=>11,'Ara'=>12];
                $arr = explode(' ',$dateval);
                $month = $datearr[$arr[1]];
                $year = $arr[2];
                $day = $arr[0];
                $time = $arr[3];
                return  $year.'-'.$month.'-'.$day.' '.$time;
            case 'jp':
                $arr = explode(' ',$dateval);
                $dataarr = explode('/',$arr[0]);
                $month = $dataarr[1];
                $year = $dataarr[0];
                $day = $dataarr[2];
                $time = $arr[1];
                return  $year.'-'.$month.'-'.$day.' '.$time;
            case 'br':
                $datearr = ['jan'=>1,'fev'=>2,'mar'=>3,'abr'=>4,'mai'=>5,'jun'=>6,'jul'=>7,'ago'=>8,'set'=>9,'sept'=>9,'out'=>10,'nov'=>11,'dez'=>12];
                $arr = explode(' ',$dateval);
                $arr[2] = str_replace('.','',$arr[2]);
                $month = $datearr[$arr[2]];
                $year = $arr[4];
                $day = $arr[0];
                $time = $arr[5];
                return  $year.'-'.$month.'-'.$day.' '.$time;
            case 'be':
                $datearr = ['janv'=>1,'févr'=>2,'mars'=>3,'avr'=>4,'mai'=>5,'juin'=>6,'juil'=>7,'août'=>8,'sept'=>9,'sept'=>9,'oct'=>10,'nov'=>11,'déc'=>12];
                $arr = explode(' ',$dateval);
                $arr[1] = str_replace('.','',$arr[1]);
                $month = $datearr[strtolower($arr[1])];
                $year = $arr[2];
                $day = $arr[0];
                $time = $arr[3];
                return  $year.'-'.$month.'-'.$day.' '.$time;
            default:
                return '0000-00-00 00:00:00';
                break;
        }
    }

    public function format_number_string1($text){
        $text = trim($text);

        if ($text == '') {
            return (float)$text;
        }

        // 去掉空格
        // 逗号统一转成小数点处理
        $text = str_replace(chr(194) . chr(160),'',$text);
        $text = str_replace(' ', '', $text);
        $text = str_replace('?', '', $text);

        $result = strpos($text, '.');//点
        $result1= strpos($text, ',');//豆
        if($result !== false && $result1 !==false) {//存在两个字符
            if($result1>$result){//前面是。后面是,
                $text = str_replace('.', '', $text);
                $text = str_replace(',', '.', $text);
            }else{//前面是,后面是.
                $text = str_replace(',', '', $text);
            }
        }else{
            $text = str_replace(',', '.', $text);
        }
        $text = str_replace('−', '-', $text);
        $text = str_replace(' ', '', $text);
        // 只保留最后一个小数点
        $count = substr_count($text, '.');

        if ($count > 1) {
            $parts = explode('.', $text);
            $last = array_pop($parts);
            $text = implode('', $parts) . '.' . $last;
        }

        return (float)$text;
    }

    public function format_number_string($str){
        $str = trim($str);
        $str = str_replace(',',' ',$str);
        $str = str_replace('"', ' ', $str);
        $str = str_replace("'", ' ', $str);
        $str = str_replace("【????????? ?? ?â????】", '[promotion de paques]', $str);
        return $str;
    }

mb_convert_encoding(trim($value[$sort]), 'utf-8', 'shift-jis');

$result = $requestReport->applicationreport($account->merchant_id,strtolower($account->site),'/reports/2021-06-30/reports',"",["marketplaceIds"=>[$account->market_place_id],"reportType"=>self::REPORT_TYPE,"reportOptions"=>["MarketplaceId"=>$account->market_place_id,"RootNodesOnly"=>'false']]);

$result = $requestReport->getreportstatus($account->merchant_id,strtolower($account->site),'/reports/2021-06-30/reports/'.$val['report_id'],"","","GET");

$result = $requestReport->getreportsurl($account->merchant_id,$account->site,'/reports/2021-06-30/documents/'.$val['request_id'],"","","GET");//获取报告下载链接

$content = file_get_contents("compress.zlib://".$result['url']);
$content =simplexml_load_string($content); //xml转object
$content= json_encode($content); //objecct转json
$content=json_decode($content,true); //json转array

$handle = fopen("compress.zlib://".$result['url'], "rb");

$fp = fopen('aa.txt', 'w');//打开一个文件，
while (!feof($handle)) { //循环读取远程文件
$contents = '';
$contents = fread($handle, 1048576);//每次读取1M
fwrite($fp, $contents);//将远程文件内容写入打开的vv.mp4文件
}
fclose($handle);
fclose($fp);