public function view_index() { $toptitle = '报表导出页面'; //头部title $this->smarty->assign('toptitle', $toptitle); $this->smarty->assign('toplevel', 5); $OmAccountAct = new OmAccountAct(); $reportAct = new ExcelExportAct(); $ebayAccountList = $OmAccountAct->act_getEbayAccountList(); $b2bAccountList = $OmAccountAct->act_getB2BAccountList(); $neweggAccountList = $OmAccountAct->act_getNeweggAccountList(); $ebayAccountList = $OmAccountAct->act_ebayaccountAllList(); $amazonAccountList = $OmAccountAct->act_amazonaccountAllList(); $dresslinkAccountList = $OmAccountAct->act_dresslinkaccountAllList(); $aliexpressAccountList = $OmAccountAct->act_getAccountListByPid(2); $innerAccountList = $OmAccountAct->act_getINNERAccountList(); $aliexpressAccountList = json_decode($aliexpressAccountList, true); $transAPI = new TransAPIAct(); $transType = $transAPI->act_getChannelistByApi(); //var_dump($aliexpressAccountList); $allAccountList = $OmAccountAct->act_getAllAccountList(); $priceInfoUrl = $reportAct->act_priceInfoReport(); $this->smarty->assign("ebayAccountList", $ebayAccountList); $this->smarty->assign("b2bAccountList", $b2bAccountList); $this->smarty->assign("neweggAccountList", $neweggAccountList); $this->smarty->assign("innerAccountList", $innerAccountList); $this->smarty->assign("dresslinkAccountList", $dresslinkAccountList); $this->smarty->assign("aliexpressAccountList", $aliexpressAccountList); $this->smarty->assign("allAccountList", $allAccountList); $this->smarty->assign("amazonAccountList", $amazonAccountList); $this->smarty->assign("transType", $transType); $this->smarty->assign("priceInfoUrl", $priceInfoUrl); $startTime = date('Y-m-d ') . ' 00:00:00'; $endTime = date('Y-m-d ') . ' 23:59:59'; $chkTime = date('Y-m-d '); $this->smarty->assign("curStartTime", $startTime); $this->smarty->assign("curEndTime", $endTime); $this->smarty->assign("chkTime", $chkTime); //单个时间 $this->smarty->display("exportXls.htm"); }
public function view_guoneiSaleImport() { //var_dump($_POST);//exit; include_once WEB_PATH . "lib/PHPExcel.php"; //phpexcel include_once WEB_PATH . "conf/scripts/script.ebay.config.php"; //global $SYSTEM_ACCOUNTS,$__liquid_items_fenmocsku,$__liquid_items_BuiltinBattery,$__liquid_items_SuperSpecific,$__liquid_items_Paste; $toptitle = '速卖通线下订单导入'; //头部title $this->smarty->assign('toptitle', $toptitle); $this->smarty->assign('toplevel', 2); $this->smarty->assign('secondlevel', 220); $OmAccountAct = new OmAccountAct(); $aliexpressAccountList = $OmAccountAct->act_getINNERAccountList(); $this->smarty->assign("aliexpressAccountList", $aliexpressAccountList); if (isset($_FILES['aliexpressFile']['tmp_name'])) { $filePath = $_FILES['aliexpressFile']['tmp_name']; $PHPExcel = new PHPExcel(); $PHPReader = new PHPExcel_Reader_Excel2007(); if (!$PHPReader->canRead($filePath)) { $PHPReader = new PHPExcel_Reader_Excel5(); if (!$PHPReader->canRead($filePath)) { echo 'no Excel'; return; } } $PHPExcel = $PHPReader->load($filePath); $currentSheet = $PHPExcel->getSheet(0); //$excellists = excel2array($PHPExcel, $filePath, 0, 0); //print_r($excellists);print_r($_SESSION); $orderid = array(); $orderData = array(); //$orderarr = OrderindexModel::showSearchOrderList("om_unshipped_order","where da.id=14448"); //echo "<pre>";print_r($orderarr); $account = $_POST['aliexpressAccount']; $transportation = CommonModel::getCarrierList(); //所有的 $c = 2; while (true) { $aa = 'A' . $c; $bb = 'B' . $c; $cc = 'C' . $c; $dd = 'D' . $c; $ee = 'E' . $c; $ff = 'F' . $c; $gg = 'G' . $c; $hh = 'H' . $c; $ii = 'I' . $c; $jj = 'J' . $c; $kk = 'K' . $c; $ll = 'L' . $c; $mm = 'M' . $c; $nn = 'N' . $c; $oo = 'O' . $c; $pp = 'P' . $c; $qq = 'Q' . $c; $rr = 'R' . $c; $ss = 'S' . $c; $tt = 'T' . $c; $uu = 'U' . $c; $vv = 'V' . $c; $ww = 'W' . $c; $xx = 'X' . $c; $yy = 'Y' . $c; $zz = 'Z' . $c; $c++; $recordNumber = trim($currentSheet->getCell($aa)->getValue()); $userId = trim($currentSheet->getCell($bb)->getValue()); $skuStr = trim($currentSheet->getCell($cc)->getValue()); $amount = trim($currentSheet->getCell($dd)->getValue()); $countryName = trim($currentSheet->getCell($ee)->getValue()); $actualTotal = trim($currentSheet->getCell($ff)->getValue()); $currency = trim($currentSheet->getCell($gg)->getValue()); $street1 = trim($currentSheet->getCell($hh)->getValue()); $street2 = trim($currentSheet->getCell($ii)->getValue()); $carrierNameCn = trim($currentSheet->getCell($jj)->getValue()); $city = trim($currentSheet->getCell($kk)->getValue()); $state = trim($currentSheet->getCell($ll)->getValue()); $zipCode = trim($currentSheet->getCell($mm)->getValue()); $phone = trim($currentSheet->getCell($nn)->getValue()); $trackNumber = trim($currentSheet->getCell($oo)->getValue()); $noteStr = trim($currentSheet->getCell($pp)->getValue()); $ordersTime = time(); $paymentTime = time(); $email = ''; $onlineTotal = ''; $shippingFee = ''; $transId = ''; $note = ''; $username = $userId; $platformUsername = $userId; $PayPalPaymentId = $transId; if (empty($recordNumber)) { break; } $skuArrlist = explode(',', $skuStr); $noteArr = explode(',', $noteStr); $skuCount = count($skuArrlist); for ($i = 0; $i < $skuCount; $i++) { list($sku, $amount) = explode('*', $skuArrlist[$i]); //echo "--sku=$sku---amount=$amount-------"; //detail信息 $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['sku'] = $sku; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['amount'] = $amount; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['recordNumber'] = $recordNumber; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['createdTime'] = time(); $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['itemTitle'] = $noteArr[$i]; $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['transId'] = $transId; if (!empty($note)) { $orderData[$recordNumber]['orderNote'][$c]['content'] = $note; $orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId']; } } //order信息 $orderData[$recordNumber]['orderData']['recordNumber'] = $recordNumber; $orderData[$recordNumber]['orderData']['ordersTime'] = $ordersTime; $orderData[$recordNumber]['orderData']['paymentTime'] = $paymentTime; $orderData[$recordNumber]['orderData']['onlineTotal'] = $onlineTotal; $orderData[$recordNumber]['orderData']['actualTotal'] = $actualTotal; $orderData[$recordNumber]['orderData']['actualShipping'] = $shippingFee; $orderData[$recordNumber]['orderData']['calcShipping'] = $shippingFee; $orderData[$recordNumber]['orderData']['orderAddTime'] = time(); $orderData[$recordNumber]['orderData']['orderStatus'] = 100; $orderData[$recordNumber]['orderData']['orderType'] = 101; $SYS_ACCOUNTS = OmAvailableModel::getTNameList("om_account", "*", " where account='{$account}'"); $orderData[$recordNumber]['orderData']['accountId'] = $SYS_ACCOUNTS[0]['id']; $orderData[$recordNumber]['orderData']['platformId'] = $SYS_ACCOUNTS[0]['platformId']; $plataccountId = $SYS_ACCOUNTS[0]['id']; $platformId = $SYS_ACCOUNTS[0]['platformId']; $SYS_ACCOUNTS = OmAvailableModel::getPlatformAccount(); foreach ($SYS_ACCOUNTS as $platform => $accounts) { foreach ($accounts as $accountId => $accountname) { if ($account == $accountname) { if ($platform == "ebay") { $orderData[$recordNumber]['orderData']['isFixed'] = 2; } else { $orderData[$recordNumber]['orderData']['isFixed'] = 1; } } } } foreach ($transportation as $tranValue) { if ($tranValue['carrierNameCn'] == $carrierNameCn) { $orderData[$recordNumber]['orderData']['transportId'] = $tranValue['id']; break; } } if ($trackNumber != '') { $orderData[$recordNumber]['orderTrack']['tracknumber'] = $trackNumber; $orderData[$recordNumber]['orderTrack']['addUser'] = $_SESSION['sysUserId']; $orderData[$recordNumber]['orderTrack']['createdTime'] = time(); } //order扩展信息 $orderData[$recordNumber]['orderExtenData']['currency'] = $currency; $orderData[$recordNumber]['orderExtenData']['paymentStatus'] = "PAY_SUCCESS"; $orderData[$recordNumber]['orderExtenData']['transId'] = $recordNumber; // 交易id;; $orderData[$recordNumber]['orderExtenData']['PayPalPaymentId'] = $PayPalPaymentId; $orderData[$recordNumber]['orderExtenData']['platformUsername'] = $platformUsername; $orderData[$recordNumber]['orderExtenData']['currency'] = $currency; //user信息 $orderData[$recordNumber]['orderUserInfoData']['platformUsername'] = $platformUsername; $orderData[$recordNumber]['orderUserInfoData']['username'] = $username; $orderData[$recordNumber]['orderUserInfoData']['email'] = $email; $orderData[$recordNumber]['orderUserInfoData']['street'] = $street1; $orderData[$recordNumber]['orderUserInfoData']['address2'] = ${$street2}; $orderData[$recordNumber]['orderUserInfoData']['currency'] = $currency; //$orderData[$recordNumber]['orderUserInfoData']['address3'] = $address3; $orderData[$recordNumber]['orderUserInfoData']['city'] = $city; $orderData[$recordNumber]['orderUserInfoData']['state'] = $state; $orderData[$recordNumber]['orderUserInfoData']['zipCode'] = $zipCode; $orderData[$recordNumber]['orderUserInfoData']['countryName'] = $countryName; $orderData[$recordNumber]['orderUserInfoData']['landline'] = $phone; $orderData[$recordNumber]['orderUserInfoData']['phone'] = $phone; //note信息 if (!empty($note)) { $orderData[$recordNumber]['orderNote'][$c]['content'] = $note; $orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId']; } } //print_r($orderData); //echo "<pre>";print_r($orderData);//exit; $message = ""; foreach ($orderData as $id => $order) { //echo $id; //$msg = commonModel::checkOrder($id); $msg = commonModel::checkRecordNumber($id, $platformId, $plataccountId); if ($msg) { $message .= "<font color='red'>订单{$id}已存在!</font><br>"; continue; } //计算订单属性 if (count($order['orderDetail']) == 1) { $detail = current($order['orderDetail']); if ($detail['orderDetailData']['amount'] == 1) { $orderData[id]['orderData']['orderAttribute'] = 1; } else { $orderData[id]['orderData']['orderAttribute'] = 2; } } else { $orderData[id]['orderData']['orderAttribute'] = 3; } //计算订单重量及包材 $obj_order_detail_data = array(); foreach ($order['orderDetail'] as $sku => $detail) { $obj_order_detail_data[] = $detail['orderDetailData']; } $weightfee = commonModel::calcOrderWeight($obj_order_detail_data); $orderData[$id]['orderData']['calcWeight'] = $weightfee[0]; //$orderData[$value[0]]['orderData']['calcShipping'] = $weightfee[3]; $orderData[$id]['orderData']['pmId'] = $weightfee[1]; //计算运费 $calcShippingInfo = CommonModel::calcAddOrderShippingFee($insertOrder, $orderData[$id]['orderData']['isFixed']); //计算运费 $orderData[$id]['orderData']['channelId'] = $calcShippingInfo['fee']['channelId']; //$orderData[$id]['orderData']['calcShipping'] = $calcShippingInfo['fee']['fee']; //缺货拦截 $orderData[$id] = AutoModel::auto_contrast_intercept($orderData[$id]); /*$orderData[$id]['orderData']['orderStatus'] = $status['orderStatus']; $orderData[$id]['orderData']['orderType'] = $status['orderType'];*/ //echo "<pre>";print_r($orderData[$id]); //print_r($orderData); //exit; //插入订单 $info = OrderAddModel::insertAllOrderRowNoEvent($orderData[$id]); if ($info) { $message .= "<font color='green'>订单{$id}上传成功!</font><br>"; } else { $message .= "<font color='red'>订单{$id}上传失败!</font><br>"; } } $this->smarty->assign("showerrorinfo", $message); //header("location:index.php?mod=underLineOrderImport&act=importOrder"); } $this->smarty->display('guoneiSaleImport.htm'); }