Array ( [0] => Array ( [0] => [1] => [2] => [3] => [4] => 2022_12_17_90569 [5] => 12/16/2022 [6] => Sale [7] => Purchase [8] => 200010832347181 [9] => 5 [10] => 108735069882169 [11] => 1 [12] => 15.99 [13] => Product Price [14] => 1 [15] => [16] => [17] => USXJ-012-MH-1-WFS [18] => 08593249563471 [19] => Senker 3 Pacs Winter Beanie Hat Scarf and Touch Screen Gloves Set for Men Women [20] => 2038356 [21] => PA [22] => Saylorsburg [23] => 18353 [24] => Apparel & Accessories [25] => Hat Scarf & Glove Sets [26] => BSE-57-8.0 [27] => Marketplace expedited [28] => Walmart-fulfilled(WFS) [29] => Delivery [30] => [31] => [32] => [33] => ) [1] => Array ( [0] => [1] => [2] => [3] => [4] => 2022_12_14_1142524 [5] => 12/13/2022 [6] => Sale [7] => Purchase [8] => 200010789734501 [9] => 1 [10] => 108734760225512 [11] => 1 [12] => 17.99 [13] => Product Price [14] => 1 [15] => [16] => [17] => USXJ-002-KNEE-1-WFS [18] => 08593249562887 [19] => Loritta 6 Pairs Womens Thigh High Socks Over the Knee High Socks Style a [20] => 2038710 [21] => OH [22] => Berlin Heights [23] => 44814 [24] => Apparel & Accessories [25] => Socks [26] => BSE-57-8.0 [27] => Marketplace expedited [28] => Walmart-fulfilled(WFS) [29] => Delivery [30] => [31] => [32] => [33] => ) [2] => Array ( [0] => [1] => [2] => [3] => [4] => 2022_12_14_1246730 [5] => 12/13/2022 [6] => Sale [7] => Purchase [8] => 200010789376794 [9] => 1 [10] => 108734862811386 [11] => 1 [12] => 11.69 [13] => Product Price [14] => 1 [15] => [16] => [17] => USXJ-004-WWS-5-WFS [18] => 08593249563167 [19] => Loritta 5 Pairs Womens Socks Wool Socks Cashmere Thick Knit Warm Winter Socks for Women Gifts [20] => 2038356 [21] => CA [22] => San Luis Obispo [23] => 93405 [24] => Apparel & Accessories [25] => Socks [26] => BSE-57-8.0 [27] => Marketplace expedited [28] => Walmart-fulfilled(WFS) [29] => Delivery [30] => [31] => [32] => [33] => )
Transaction Type | Customer Order # | Purchase Order # | Ship Qty | Partner Item Id | ||
Adjustment | 200010832347181 | 108735069882169 | USXJ-012-MH-1-WFS | |||
Sale | 200010832347181 | 108735069882169 | 1 | USXJ-012-MH-1-WFS | ||
Sale | 200010832347181 | 108735069882169 | 1 | USXJ-012-MH-1-WFS | ||
Sale | 200010789734501 | 108734760225512 | 1 | USXJ-002-KNEE-1-WFS | ||
Sale | 200010789734501 | 108734760225512 | 1 | USXJ-002-KNEE-1-WFS | ||
Sale | 200010789734501 | 108734760225512 | 1 | USXJ-002-KNEE-1-WFS | ||
Sale | 200010789734501 | 108734760225512 | 1 | USXJ-002-KNEE-1-WFS | ||
Adjustment | 200010789734501 | 108734760225512 | USXJ-002-KNEE-1-WFS | |||
Sale | 200010789376794 | 108734862811386 | 1 | USXJ-004-WWS-5-WFS | ||
Sale | 200010789376794 | 108734862811386 | 1 | USXJ-004-WWS-5-WFS | ||
Sale | 200010789376794 | 108734862811386 | 1 | USXJ-004-WWS-5-WFS | ||
Sale | 200010789376794 | 108734862811386 | 1 | USXJ-004-WWS-5-WFS | ||
Adjustment | 200010789376794 | 108734862811386 | USXJ-004-WWS-5-WFS | |||
Sale | 200010788475555 | 108734862312278 | 1 | USXJ-007-FS-3-WFS | ||
Sale | 200010788475555 | 108734862312278 | 1 | USXJ-007-FS-3-WFS | ||
Sale | 200010788475555 | 108734862312278 | 1 | USXJ-007-FS-3-WFS | ||
Sale | 200010788475555 | 108734862312278 | 1 | USXJ-007-FS-3-WFS | ||
Adjustment | 200010788475555 | 108734862312278 | USXJ-007-FS-3-WFS | |||
Adjustment | 200010787593709 | 108735173876307 | USXJ-010-WH-1-WFS | |||
Sale | 200010787593709 | 108735173876307 | 1 | USXJ-010-WH-1-WFS | ||
Sale | 200010787593709 | 108735173876307 | 1 | USXJ-010-WH-1-WFS | ||
Sale | 200010787593709 | 108735173876307 | 1 | USXJ-010-WH-1-WFS | ||
Sale | 200010787593709 | 108735173876307 | 1 | USXJ-010-WH-1-WFS | ||
Adjustment | 200010787436744 | 108734448272705 | USXJ-002-KNEE-3-WFS |
代码:
$header = [
'Period Start Date',
'Period End Date',
'Total Payable',
'Currency',
'Transaction Key',
'Transaction Posted Timestamp',
'Transaction Type',
'Transaction Description',
'Customer Order #',
'Customer Order line #',
'Purchase Order #',
'Purchase Order line #',
'Amount',
'Amount Type',
'Ship Qty',
'Commission Rate',
'Transaction Reason Description',
'Partner Item Id',
'Partner GTIN',
'Partner Item Name',
'Product Tax Code',
'Ship to State',
'Ship to City',
'Ship to Zipcode',
'Contract Category',
'Product Type',
'Commission Rule',
'Shipping Method',
'Fulfillment Type',
'Fulfillment Details',
'Original Commission',
'Commission Incentive Program',
'Commission Saving',
'Customer Promo Type',
'Campaign Id'
];
$file = 'data.csv'; // 保存的文件名
$handle = fopen($file, 'w');
// 写入表头
fputcsv($handle, $header);
// 写入数据行
foreach ($diffDataOne as $row) {
fputcsv($handle, $row);
}
fclose($handle);
// 下载文件
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename=' . $file);
readfile($file);
// 删除临时文件
unlink($file);
exit;