function act_outKpiExpress_peihuo()
{
error_reporting(E_ALL);
header("Content-type:text/html;charset=utf-8");
$start = isset($_POST['start7']) ? trim($_POST['start7']) : "";
$end = isset($_POST['end7']) ? trim($_POST['end7']) : "";
$date = $start . "_" . $end;
$flat = array("中国邮政平邮", "香港小包平邮");
$regiest = array("中国邮政挂号", "香港小包挂号", "EUB", "UPS美国专线", "Global Mail", "德国邮政挂号", "新加坡小包挂号", '俄速通挂号');
//$fastmail = "快递";
$peihuo_info = array("0-1000" => 5, "1001-11000" => 30, "11001-26000" => 60, "26001-" => 75);
$orderlist = KpiListModel::getOrderOutList_express($start, $end);
$exporter = new ExportDataExcel("browser", "KuaidiPeihuo" . $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'];
$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);
$ebay_ordersn = $order['ebay_ordersn'];
$detaillist = KpiListModel::getOrderDetailList($ebay_ordersn);
$producter = KpiListModel::pda_user($value['user']);
$producter = $producter['username'];
//改为快递系数
foreach ($peihuo_info as $key => $value) {
$v_arr = explode("-", $key);
if ($order['orderweight2'] >= $v_arr[0] && $order['orderweight2'] <= $v_arr[1]) {
$num = $value;
}
foreach ($detaillist as $detail) {
if (preg_match("/^3/", $detail['goods_location'])) {
$num = $num + 0.5;
}
}
}
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['ebay_shipfee'], $order['ebay_carrier'], $producter, $num, $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['ebay_shipfee'], $order['ebay_carrier'], $producter, $num, $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();
exit;
}
