function act_getAbOrderList() { $res = WarehouseAPIModel::getAbOrderList(); //self::$errCode = WarehouseAPIModel::$errCode; //self::$errMsg = WarehouseAPIModel::$errMsg; return $res; }
/** * 海外仓销售报表数据导出,未开发完成 */ public function act_ebayOversea() { $user = $_SESSION['userName']; $objPHPExcel = new PHPExcel(); $sendreplacement = array('1' => '补寄全部', '2' => '补寄主体', '3' => '补寄配件'); $ebay_splitorder_logs = array('0' => '拆分 订单', '1' => '复制 订单', '2' => '异常 订单', '3' => '合并 包裹', '4' => '邮局退回补寄', '5' => '自动部分包货拆分', '7' => '同步异常订单'); $MAILWAYCONFIG = array(0 => 'EUB', 1 => '深圳', 2 => '福州', 3 => '三泰', 4 => '泉州', 5 => '义乌', 6 => '福建', 7 => '中外联', 8 => 'GM', 9 => '香港', 10 => '快递'); $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file"); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '日期'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1', 'ebay store'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1', '交易号'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1', '客户ID'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('E1', '仓位号'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('F1', '料号'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('G1', '数量'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('H1', '国家'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('I1', '产品价格'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('J1', 'ebay运费'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('K1', '包裹总价值'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('L1', '币种'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('M1', '包装员'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('N1', '挂号条码'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('O1', '是/否'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('P1', '重量'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('Q1', '邮费'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('R1', '运输方式'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('S1', '订单编号'); /* 王民伟 2012-04-18*/ $objPHPExcel->setActiveSheetIndex(0)->setCellValue('T1', '产品货本'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('U1', '交易ID'); /*---end Tt Uu Vv Ww Xx*/ $objPHPExcel->setActiveSheetIndex(0)->setCellValue('V1', 'ItemID'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('W1', '是否复制订单'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('X1', '是否补寄'); //add by Herman.Xi 2012-09-13 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('Y1', '是否拆分订单'); //add by Herman.Xi 2012-09-14 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('Z1', '包材'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AA1', '包材费用'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AB1', '是否组合料号'); //add by Herman.Xi 2012-12-17 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AC1', '发货分区'); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AD1', '是否邮局退回后补寄'); //add by Herman.Xi 2013-03-09 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AE1', 'PayPal邮箱'); //add by Herman.Xi 2013-03-09 $objPHPExcel->setActiveSheetIndex(0)->setCellValue('AF1', '采购'); //add by chenwei 2013-09-07 $start = strtotime($_REQUEST['start']); $end = strtotime($_REQUEST['end']); //echo $start."||".$end;exit; $account = $_REQUEST['account']; $tjstr = ''; if ($account != '') { $account = explode("#", $account); for ($i = 0; $i < count($account); $i++) { $a0 = $account[$i]; if ($a0 != '') { $tjstr .= " a.accountId = '" . $a0 . "' or "; } } } $packinglists = GoodsModel::getMaterInfo(); //需要调产品中心的接口才可以使用。 $packings = array(); foreach ($packinglists as $packinglist) { //$packings[$packinglist['id']] = $packinglist['pmCost']; $packings[$packinglist['pmAlias']] = $packinglist['pmCost']; } unset($packinglists); $tjstr = substr($tjstr, 0, strlen($tjstr) - 3); //$ret = OrderInfoModel::getShipOrderList($start,$end,$tjstr); $ret = WarehouseAPIModel::getAbOrderList(); $a = 2; for ($i = 0; $i < count($shipData); $i++) { $ordersn = $ret[$i]['ebay_ordersn']; $paidtime = @date('Y-m-d', $ret[$i]['ebay_paidtime']); $ebay_usermail = $ret[$i]['ebay_usermail']; $ebay_userid = $ret[$i]['ebay_userid']; $name = @html_entity_decode($ret[$i]['ebay_username'], ENT_QUOTES, 'UTF-8'); $street1 = @$ret[$i]['ebay_street']; $street2 = @$ret[$i]['ebay_street1']; $city = $ret[$i]['ebay_city']; $state = $ret[$i]['ebay_state']; $countryname = $ret[$i]['ebay_countryname']; //客服部小霞提出 导出列 国家 显示英文 方便退款处理 //$cnname = $country[$countryname]; $cnname = $countryname; $zip = $ret[$i]['ebay_postcode']; $tel = $ret[$i]['ebay_phone']; $ebay_shipfee = $ret[$i]['ebay_shipfee']; $ebay_note = $ret[$i]['ebay_note']; $ebay_total = @round($ret[$i]['ebay_total'], 2); $ebay_tracknumber = @$ret[$i]['ebay_tracknumber']; $ebay_account = @$ret[$i]['ebay_account']; $recordnumber0 = @$ret[$i]['recordnumber']; $ebay_carrier = @$ret[$i]['ebay_carrier']; $ebay_phone = $ret[$i]['ebay_phone']; $ebay_currency = $ret[$i]['ebay_currency']; $packinguser = $ret[$i]['packagingstaff']; $ordershipfee = $ret[$i]['ordershipfee']; $ebay_id = $ret[$i]['ebay_id']; $ebay_ptid = $ret[$i]['ebay_ptid']; $ebay_pp = $ret[$i]['PayPalEmailAddress']; $ebay_noteb = $ret[$i]['ebay_noteb']; //=='复制 订单' ? $ret[$i]['ebay_noteb'] : '' $is_sendreplacement = $ret[$i]['is_sendreplacement']; $is_main_order = $ret[$i]['is_main_order']; $mailway = $ret[$i]['mailway']; $address = $street1 . "\n" . $street2 . "\n" . $city . "\n" . $state . "\n" . $zip . "\n" . $countryname; $scantime = date('Y-m-d', $sql[$i]['scantime']); //$calculate_weight = $sql[$i]['orderweight']; //计算重量 $orderweight2 = number_format($sql[$i]['orderweight2'] / 1000, 3); //实际重量 $totalweight = $orderweight2; $ordershipfee = round(calctrueshippingfee($ebay_carrier, $totalweight, $countryname, $ebay_id), 2); $ebay_noteb = $is_main_order == 2 ? '复制 订单' : ($is_main_order == 1 ? '被复制 订单' : ''); $ebay_splitorder = judge_is_splitorder($ebay_id) == 1 ? '拆分 订单' : ''; $ebay_combineorder = judge_contain_combinesku($ordersn) ? '组合 料号' : ''; $splitorder_log = func_readlog_splitorder($ebay_id); $ebay_splitorder_log = ''; if ($splitorder_log != false) { $ebay_splitorder_log = $ebay_splitorder_logs[$splitorder_log]; } $is_sendreplacement = isset($sendreplacement[$is_sendreplacement]) ? $sendreplacement[$is_sendreplacement] : ''; $sl = "select * from ebay_orderdetail where ebay_ordersn='{$ordersn}'"; $sl = $dbcon->execute($sl); $sl = $dbcon->getResultArray($sl); if ($mailway === null) { $mailsql = "SELECT mailway FROM ebay_scan_mailway WHERE ebay_id={$sql[$i]['combine_package']}"; $mailsql = $dbcon->execute($mailsql); $mailllist = $dbcon->getResultArray($mailsql); $mailway_c = !empty($mailllist[0]['mailway']) ? $MAILWAYCONFIG[$mailllist[0]['mailway']] . '合并包裹' : ''; } else { $mailway_c = $MAILWAYCONFIG[$mailway]; } } }