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; }
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; }