function act_reviewOrderRecord()
{
error_reporting(E_ALL);
header("Content-type:text/html;charset=utf-8");
$start = isset($_POST['start3']) ? trim($_POST['start3']) : "";
$end = isset($_POST['end3']) ? trim($_POST['end3']) : "";
$date = $start . "————" . $end;
$flat = array("中国邮政平邮", "香港小包平邮");
$regiest = array("中国邮政挂号", "香港小包挂号", "EUB", "UPS美国专线", "Global Mail", "德国邮政挂号", "新加坡小包挂号");
//$fastmail = "快递";
$info = array("simple*flat" => array("0-1000" => 1, "1001-2000" => 2), "multi*flat" => array("0-200" => 1, "201-1000" => 2, "1001-2000" => 2.5), "many*flat" => array("0-200" => 1, "201-1000" => 2.2, "1001-2000" => 3.2), "simple*regiest" => array("0-1000" => 1.3, "1001-2000" => 2.5), "multi*regiest" => array("0-200" => 1.2, "201-1000" => 2, "1001-2000" => 3), "many*regiest" => array("0-200" => 1.2, "201-1000" => 2.5, "1001-2000" => 3.5));
$orderlist = KpiListModel::getReviewList($start, $end);
$exporter = new ExportDataExcel("browser", "reviewOrderRecord" . $date . ".xls");
$exporter->initialize();
// starts streaming data to web browser
$exporter->addRow(array("日期", "订单编号", "料号", "数量", "重量", "仓位号", "国家", "包裹总价值", "币种", "挂号条码", "邮费", "运输方式", "复核员", "复核折算数量", "复核时间"));
$idarr = array();
foreach ($orderlist as $key => $value) {
if (in_array($value['ebay_id'], $idarr)) {
continue;
} else {
$idarr[] = $value['ebay_id'];
}
$ebay_id = $value['ebay_id'];
//$ebay_ordersn = $order['ebay_ordersn'];
$scantime = empty($value['scantime']) ? "" : date("Y-m-d", $value['scantime']);
$sctime = empty($value['scantime']) ? "" : date("Y-m-d H:i:s", $value['scantime']);
$order = KpiListModel::selectOrder($ebay_id);
$review = KpiListModel::getReviewListById($ebay_id);
if ($review) {
$reviewer = $review[0]['user'];
} else {
$reviewer = "";
}
$ebay_ordersn = $order['ebay_ordersn'];
$detaillist = KpiListModel::getOrderDetailList($ebay_ordersn);
if (count($detaillist) == 1 && $detaillist[0]['ebay_amount'] == 1) {
$msg = "simple";
} elseif (count($detaillist) == 1 && $detaillist[0]['ebay_amount'] > 1) {
$msg = "multi";
} elseif (count($detaillist) > 1) {
$msg = "many";
}
if (in_array($order['ebay_carrier'], $flat)) {
$carrier_msg = "flat";
} elseif (in_array($order['ebay_carrier'], $regiest)) {
$carrier_msg = "regiest";
} else {
$carrier_msg = "快递";
}
$type = array();
if ($carrier_msg !== "快递") {
$info_msg = $msg . "*" . $carrier_msg;
foreach ($info[$info_msg] as $key_msg => $value_msg) {
$weight = explode("-", $key_msg);
if ($order['orderweight2'] >= $weight[0] && $order['orderweight2'] <= $weight[1]) {
$num2 = $value_msg;
}
}
} else {
$num2 = 50;
}
if (count($detaillist) == 1) {
$exporter->addRow(array($scantime, $ebay_id, $detaillist[0]['sku'], $detaillist[0]['ebay_amount'], $order['orderweight2'], $detaillist[0]['goods_location'], $order['ebay_countryname'], $order['ebay_total'], $order['ebay_currency'], $order['ebay_tracknumber'], $order['ordershipfee'], $order['ebay_carrier'], $reviewer, $num2, $sctime));
} else {
$amount = 0;
foreach ($detaillist as $detail) {
$amount += $detail['ebay_amount'];
}
$exporter->addRow(array($scantime, $ebay_id, "", $amount, $order['orderweight2'], "", $order['ebay_countryname'], $order['ebay_total'], $order['ebay_currency'], $order['ebay_tracknumber'], $order['ordershipfee'], $order['ebay_carrier'], $reviewer, $num2, $sctime));
foreach ($detaillist as $orderdetail) {
$exporter->addRow(array("", $ebay_id, $orderdetail['sku'], $orderdetail['ebay_amount'], "", $orderdetail['goods_location'], $order['ebay_countryname'], "", "", "", "", $order['ebay_carrier'], "", "", ""));
}
}
}
$exporter->finalize();
// writes the footer, flushes remaining data to browser.
exit;
}
