function act_outKpiExpress_baozhuang()
{
error_reporting(E_ALL);
header("Content-type:text/html;charset=utf-8");
$start = isset($_POST['start6']) ? trim($_POST['start6']) : "";
$end = isset($_POST['end6']) ? trim($_POST['end6']) : "";
$date = $start . "_" . $end;
$flat = array("中国邮政平邮", "香港小包平邮");
$regiest = array("中国邮政挂号", "香港小包挂号", "EUB", "UPS美国专线", "Global Mail", "德国邮政挂号", "新加坡小包挂号", '俄速通挂号');
$package_info = array("0-1000" => 20, "1001-11000" => 55, "11001-26000" => 75, "26001-" => 100);
$package_chinaInfo = array("1-2000" => 10, "2001-10000" => 13, "10001-" => 50);
$accounts_china = KpiListModel::getInnerAccount();
$accounts = array();
foreach ($accounts_china as $key => $value) {
$accounts[] = $value['ebay_account'];
}
$orderlist = KpiListModel::getOrderList_express($start, $end);
//包装记录
$exporter = new ExportDataExcel("browser", "KuaidiBaozhuang" . $date . ".xls");
$exporter->initialize();
// starts streaming data to web browser
$exporter->addRow(array("日期", "订单编号", "料号", "数量", "重量", "仓位号", "国家", "包裹总价值", "币种", "挂号条码", "邮费", "运输方式", "包装员", "包装折算数量", "复核时间"));
$idarr = array();
foreach ($orderlist as $key => $order) {
if (in_array($order['ebay_id'], $idarr)) {
continue;
} else {
$idarr[] = $order['ebay_id'];
}
$ebay_id = $order['ebay_id'];
$scantime = empty($order['scantime']) ? "" : date("Y-m-d", $order['scantime']);
$sctime = empty($order['scantime']) ? "" : date("Y-m-d H:i:s", $order['scantime']);
//$order = KpiListModel::selectOrder($ebay_id);
$ebay_ordersn = $order['ebay_ordersn'];
$packager = $order['packagingstaff'];
$detaillist = KpiListModel::getOrderDetailList($ebay_ordersn);
if (in_array($order['ebay_account'], $accounts)) {
foreach ($package_chinaInfo as $k => $v) {
$k_arr = explode("-", $k);
if (empty($k_arr[1])) {
if ($order['orderweight2'] >= 10001) {
$num = 50;
}
} else {
if ($order['orderweight2'] >= $k_arr[0] && $order['orderweight2'] <= $k_arr[1]) {
$num = $v;
}
}
}
} else {
foreach ($package_info as $k => $v) {
$k_arr = explode("-", $k);
if (empty($k_arr[1])) {
if ($order['orderweight2'] >= $k_arr[0]) {
$num = $v;
}
} else {
if ($order['orderweight2'] >= $k_arr[0] && $order['orderweight2'] <= $k_arr[1]) {
$num = $v;
}
}
}
}
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'], $packager, $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['ordershipfee'], $order['ebay_carrier'], $packager, $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;
}
