Exemplo n.º 1
0
/**
 * 根据账号id获取平台名称
 * @param int $id 账号id
 * @return string
 * @author yxd
 * */
function get_platnamebyaccountid($id)
{
    $platformId = get_platFromidbyaccountid($id);
    $platformName = get_platnamebyid($platformId);
    return $platformName;
}
Exemplo n.º 2
0
 /**
  * 独立商城订单导入页面
  */
 public function act_insertDresslinkOrder()
 {
     //独立商城的扩展表尚未建立
     return false;
     if (isset($_FILES['cndlAccountListFile']['tmp_name'])) {
         $filePath = $_FILES['cndlAccountListFile']['tmp_name'];
         $PHPExcel = E('PHPExcel');
         $PHPReader = new PHPExcel_Reader_Excel2007();
         if (!$PHPReader->canRead($filePath)) {
             $PHPReader = new PHPExcel_Reader_Excel5();
             if (!$PHPReader->canRead($filePath)) {
                 self::$errMsg[] = get_promptmsg(10058);
                 return false;
             }
         }
         $PHPExcel = $PHPReader->load($filePath);
         $currentSheet = $PHPExcel->getSheet(0);
         $orderid = array();
         $orderData = array();
         F('order');
         //引入lib/funciond的order_functions
         $account = $_POST['cndlAccountId'];
         //accountId
         if (intval($account) <= 0) {
             self::$errMsg[] = get_promptmsg(10054);
             return false;
         }
         $platformId = get_platFromidbyaccountid($account);
         if (intval($platformId) <= 0) {
             self::$errMsg[] = get_promptmsg(10121);
             return false;
         }
         //            $carrierList = M('InterfaceTran')->getCarrierList(2);//获取所有的运输方式
         //            $carrierKV = array();
         //            foreach($carrierList as $key => $trans) {
         //                $carrierKV[$trans['id']] = $trans['carrierNameCn'];
         //            }
         $c = 2;
         $dresslinks = array();
         $ebay_fedex_remark = array();
         $ChineseDescs = array();
         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;
             $aaa = 'AA' . $c;
             $abb = 'AB' . $c;
             $acc = 'AC' . $c;
             $add = 'AD' . $c;
             $aee = 'AE' . $c;
             $aff = 'AF' . $c;
             $agg = 'AG' . $c;
             $ahh = 'AH' . $c;
             $aii = 'AI' . $c;
             $ajj = 'AJ' . $c;
             $akk = 'AK' . $c;
             $all = 'AL' . $c;
             $amm = 'AM' . $c;
             $ann = 'AN' . $c;
             $aww = 'AW' . $c;
             $recordNumber = trim($currentSheet->getCell($aa)->getValue());
             //订单号
             if (empty($recordNumber)) {
                 break;
             }
             /***************判断订单是否已存在***************/
             if (M('OrderAdd')->checkIsExists(array('recordNumber' => $recordNumber, 'accountId' => $account))) {
                 self::$errMsg[] = get_promptmsg(10043, $recordNumber);
                 //"该recordNumber已经存在<br/>";
                 continue;
             }
             /**************/
             $is_order = intval($currentSheet->getCell($bb)->getValue());
             //1代表为订单,0代表订单明细
             if ($is_order != 0) {
                 //为订单
                 //这个验证可以不用
                 //if($cndlAccounts[$account]=="dresslink.com"){
                 //					   $str = substr($recordNumber,0,2);
                 //					   if($str!=="DL"){
                 //						  $message .= "<font color=red> {$recordNumber}不在账号{$cndlAccounts[$account]}中!</font><br>";
                 //						  continue;
                 //					   }
                 //					}elseif($cndlAccounts[$account]=="cndirect.com"){
                 //					   $str = substr($recordNumber,0,2);
                 //					   if($str!=="CN"){
                 //						  $message .= "<font color=red> {$recordNumber}不在账号{$cndlAccounts[$account]}中!</font><br>";
                 //						  continue;
                 //					   }
                 //					}
                 $platformUsername = mysql_real_escape_string(trim($currentSheet->getCell($cc)->getValue()));
                 $email = mysql_real_escape_string(trim($currentSheet->getCell($dd)->getValue()));
                 $transId = mysql_real_escape_string(trim($currentSheet->getCell($ee)->getValue()));
                 $ordersTime = (array) PHPExcel_Shared_Date::ExcelToPHPObject(trim($currentSheet->getCell($ll)->getValue()));
                 $paymentTime = (array) PHPExcel_Shared_Date::ExcelToPHPObject(trim($currentSheet->getCell($mm)->getValue()));
                 $shippingFee = round_num(trim($currentSheet->getCell($oo)->getValue()), 2);
                 $calcWeight = round_num(trim($currentSheet->getCell($ahh)->getValue()), 3);
                 $actualTotal = round_num(trim($currentSheet->getCell($pp)->getValue()), 2);
                 $onlineTotal = round_num(trim($currentSheet->getCell($aff)->getValue()), 2);
                 $currency = mysql_real_escape_string(trim($currentSheet->getCell($qq)->getValue()));
                 //$orders['ebay_orderqk'] = round_num(trim($currentSheet->getCell($rr)->getValue()), 2);
                 $note = mysql_real_escape_string(trim($currentSheet->getCell($ss)->getValue()));
                 $username = mysql_real_escape_string(trim($currentSheet->getCell($tt)->getValue()));
                 $countryName = mysql_real_escape_string(trim($currentSheet->getCell($uu)->getValue()));
                 $state = mysql_real_escape_string(trim($currentSheet->getCell($vv)->getValue()));
                 $city = mysql_real_escape_string(trim($currentSheet->getCell($ww)->getValue()));
                 $street = mysql_real_escape_string(trim($currentSheet->getCell($xx)->getValue()));
                 $address2 = mysql_real_escape_string(trim($currentSheet->getCell($yy)->getValue()));
                 $zipCode = mysql_real_escape_string(trim($currentSheet->getCell($zz)->getValue()));
                 $phone = mysql_real_escape_string(trim($currentSheet->getCell($abb)->getValue()));
                 $landline = mysql_real_escape_string(trim($currentSheet->getCell($aaa)->getValue()));
                 //					if($account == 400){    //dresslink.com
                 //						$feedback 				= mysql_real_escape_string(trim($currentSheet->getCell($ann)->getValue()));
                 //					}elseif($account == 410){   //cndirect.com
                 //						$feedback 				= mysql_real_escape_string(trim($currentSheet->getCell($akk)->getValue()));
                 //					}
                 $carrierNameCn = strtolower(mysql_real_escape_string(trim($currentSheet->getCell($kk)->getValue())));
                 $payment_method = mysql_real_escape_string(trim($currentSheet->getCell($ff)->getValue()));
                 $payment_module = mysql_real_escape_string(trim($currentSheet->getCell($gg)->getValue()));
                 $bank_account = mysql_real_escape_string(trim($currentSheet->getCell($hh)->getValue()));
                 $bank_country = mysql_real_escape_string(trim($currentSheet->getCell($ii)->getValue()));
                 $shipping_method = mysql_real_escape_string(trim($currentSheet->getCell($jj)->getValue()));
                 $shipping_module = mysql_real_escape_string(trim($currentSheet->getCell($kk)->getValue()));
                 //这个dresslinks_info表在新系统已经废除了
                 //$dresslinks['payment_method'] = $payment_method;
                 //					$dresslinks['payment_module'] = $payment_module;
                 //					$dresslinks['bank_account'] = $bank_account;
                 //					$dresslinks['bank_country'] = $bank_country;
                 //					$dresslinks['shipping_method'] = $shipping_method;
                 //					$dresslinks['shipping_module'] = $shipping_module;
                 $PayPalPaymentId = $transId;
                 $ordersTime = strtotime($ordersTime['date']);
                 $paymentTime = strtotime($paymentTime['date']);
                 /***************BEGIN 订单表数据***************/
                 //order信息
                 $orderData[$recordNumber]['order']['recordNumber'] = $recordNumber;
                 $orderData[$recordNumber]['order']['platformId'] = $platformId;
                 //这里要根据accountId得到对应的platformId
                 $orderData[$recordNumber]['order']['accountId'] = $account;
                 $orderData[$recordNumber]['order']['orderStatus'] = 0;
                 $orderData[$recordNumber]['order']['ordersTime'] = $ordersTime;
                 $orderData[$recordNumber]['order']['paymentTime'] = $paymentTime;
                 $orderData[$recordNumber]['order']['onlineTotal'] = $onlineTotal;
                 $orderData[$recordNumber]['order']['actualTotal'] = $actualTotal;
                 //$actualTotal+$shippingFee
                 $orderData[$recordNumber]['order']['actualShipping'] = $shippingFee;
                 $orderData[$recordNumber]['order']['currency'] = $currency;
                 //取默认,待以后确认处理
                 $orderData[$recordNumber]['order']['transportId'] = 0;
                 //走拦截流程,取消默认
                 $orderData[$recordNumber]['order']['pmId'] = 0;
                 //包材ID,默认0
                 $orderData[$recordNumber]['order']['channelId'] = 0;
                 //渠道ID,默认0
                 $orderData[$recordNumber]['order']['orderAddTime'] = time();
                 $orderData[$recordNumber]['order']['calcShipping'] = $shippingFee;
                 $orderData[$recordNumber]['order']['orderType'] = 0;
                 $orderData[$recordNumber]['order']['completeTime'] = 0;
                 //完结时间,默认0
                 $orderData[$recordNumber]['order']['ORtransport'] = $carrierNameCn;
                 //order扩展信息
                 //user信息
                 $orderData[$recordNumber]['orderUserInfo']['platformUsername'] = $platformUsername;
                 $orderData[$recordNumber]['orderUserInfo']['username'] = $username;
                 $orderData[$recordNumber]['orderUserInfo']['email'] = $email;
                 $orderData[$recordNumber]['orderUserInfo']['countryName'] = $countryName;
                 $orderData[$recordNumber]['orderUserInfo']['currency'] = $currency;
                 //$currency;
                 $orderData[$recordNumber]['orderUserInfo']['state'] = $state;
                 $orderData[$recordNumber]['orderUserInfo']['city'] = $city;
                 $orderData[$recordNumber]['orderUserInfo']['county'] = ' ';
                 //区县默认空
                 $orderData[$recordNumber]['orderUserInfo']['address1'] = $street;
                 $orderData[$recordNumber]['orderUserInfo']['mobilePhone'] = $landline;
                 $orderData[$recordNumber]['orderUserInfo']['phone'] = $phone;
                 $orderData[$recordNumber]['orderUserInfo']['zipCode'] = $zipCode;
                 //detail信息
                 $orderData[$recordNumber]['orderDetail'][$sku]['orderDetail']['sku'] = $sku;
                 $orderData[$recordNumber]['orderDetail'][$sku]['orderDetail']['amount'] = $amount;
                 $orderData[$recordNumber]['orderDetail'][$sku]['orderDetail']['itemPrice'] = $itemPrice;
                 $orderData[$recordNumber]['orderDetail'][$sku]['orderDetail']['createdTime'] = time();
                 $orderData[$recordNumber]['orderDetail'][$sku]['orderDetail']['shippingFee'] = $shippingFee;
                 $orderData[$recordNumber]['orderDetail'][$sku]['orderDetail']['recordNumber'] = $recordNumber;
                 $orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtension']['itemTitle'] = $itemTitle;
                 /***************END 订单表数据***************/
                 /***************BEGIN 订单扩展表数据***************/
                 $orderData[$recordNumber]['orderExtension']['feedback'] = $note;
                 $orderData[$recordNumber]['orderExtension']['payPalPaymentId'] = $transId;
                 $orderData[$recordNumber]['orderExtension']['paymentStatus'] = "Complete";
                 $orderData[$recordNumber]['orderExtension']['transId'] = $transId;
                 $orderData[$recordNumber]['orderExtension']['PayPalPaymentId'] = $PayPalPaymentId;
                 $orderData[$recordNumber]['orderExtension']['paymentMethod'] = $payment_method;
                 $orderData[$recordNumber]['orderExtension']['paymentModule'] = $payment_module;
                 $orderData[$recordNumber]['orderExtension']['shippingMethod'] = $shipping_method;
                 $orderData[$recordNumber]['orderExtension']['ShippingModule'] = $shipping_module;
                 $orderData[$recordNumber]['orderExtension']['currency'] = $currency;
                 $orderData[$recordNumber]['orderExtension']['feedback'] = $feedback;
                 //客户留言
                 /***************END 订单扩展表数据***************/
                 /***************BEGIN 订单用户表数据***************/
                 $orderData[$recordNumber]['orderUserInfo']['username'] = $username;
                 $orderData[$recordNumber]['orderUserInfo']['platformUsername'] = $platformUsername;
                 $orderData[$recordNumber]['orderUserInfo']['email'] = $email;
                 $orderData[$recordNumber]['orderUserInfo']['countryName'] = $countryName;
                 $orderData[$recordNumber]['orderUserInfo']['currency'] = $currency;
                 $orderData[$recordNumber]['orderUserInfo']['state'] = $state;
                 // 省
                 $orderData[$recordNumber]['orderUserInfo']['city'] = $city;
                 // 市
                 $orderData[$recordNumber]['orderUserInfo']['street'] = $street;
                 $orderData[$recordNumber]['orderUserInfo']['address2'] = $address2;
                 $orderData[$recordNumber]['orderUserInfo']['landline'] = $landline;
                 // 座机电话
                 $orderData[$recordNumber]['orderUserInfo']['phone'] = $phone;
                 // 手机
                 $orderData[$recordNumber]['orderUserInfo']['zipCode'] = $zipCode;
                 // 邮编
                 /*************END 订单用户表数据***************/
                 //note信息
                 if (!empty($note)) {
                     $orderData[$recordNumber]['orderNote']['content'] = $note;
                 }
             } else {
                 $sku = mysql_real_escape_string(trim($currentSheet->getCell($acc)->getValue()));
                 $itemTitle = mysql_real_escape_string(trim($currentSheet->getCell($add)->getValue()));
                 $itemPrice = round_num(trim($currentSheet->getCell($aff)->getValue()), 2);
                 $amount = intval(trim($currentSheet->getCell($agg)->getValue()));
                 $shipingfee = round_num(trim($currentSheet->getCell($ahh)->getValue()), 2);
                 /***************BEGIN 订单详细数据***************/
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetail']['recordNumber'] = $recordnumber;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetail']['sku'] = $sku;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetail']['itemPrice'] = $itemPrice;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetail']['amount'] = $amount;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetail']["shippingFee"] = $shipingfee;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetail']['createdTime'] = time();
                 /*************END 订单详细数据***************/
                 /***************BEGIN 订单详细扩展表数据***************/
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetailExtension']['itemTitle'] = $itemTitle;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetailExtension']['transId'] = $transId;
                 //$orderData['orderDetail']['orderDetailExtenData']['note'] = $value[10];
                 $categoryName = trim($currentSheet->getCell($ajj)->getValue());
                 $customCode = trim($currentSheet->getCell($akk)->getValue());
                 $material = trim($currentSheet->getCell($all)->getValue());
                 $ShenBaoQuantity = trim($currentSheet->getCell($amm)->getValue());
                 $ShenBaoUnitPrice = trim($currentSheet->getCell($ann)->getValue());
                 $ChineseDesc = trim($currentSheet->getCell($aww)->getValue());
                 //$salePrice						   =	round_num(mysql_real_escape_string(trim($detail['SalePrice'])), 2);	//实际SKU付款价
                 /*************END 订单详细扩展表数据***************/
                 $ebay_fedex_remark[$recordNumber][$categoryName][] = array('real_price' => $ShenBaoUnitPrice, 'qty' => $ShenBaoQuantity, 'hamcodes' => $customCode, 'detail' => $material);
                 $orderData[$recordNumber]['fedexRemark'] = $ebay_fedex_remark[$recordNumber];
             }
         }
         //fedexRemark 逻辑处理
         foreach ($orderData as $recordNumber => $tmpArr) {
             $fedexRemarkArr = $tmpArr['fedexRemark'];
             $transportId = $orderData['order']['transportId'];
             if (!empty($fedexRemarkArr)) {
                 $tmpArr1 = array();
                 foreach ($fedexRemarkArr as $k => $v) {
                     $tmpArr1['description'] = trim("[No Brand]" . $k . "{$v[0]['detail']}");
                     if (in_array($carrierKV[$transportId], array('FedEx'))) {
                         $tmpArr1['type'] = 1;
                     } elseif (in_array($carrierKV[$transportId], array('DHL', 'EMS', 'UPS美国专线'))) {
                         $tmpArr1['type'] = 2;
                     } else {
                         break;
                     }
                     $sku_price = 0;
                     $qty = 0;
                     foreach ($v as $v0) {
                         $sku_price += $v0['real_price'];
                         $qty += $v0['qty'];
                     }
                     $tmpArr1['price'] = round($sku_price / $qty, 2);
                     $tmpArr1['amount'] = $qty;
                     $tmpArr1['hamcodes'] = $v[0]['hamcodes'];
                     if (in_array($carrierKV[$transportId], array('DHL', 'EMS', 'UPS美国专线'))) {
                         $tmpArr1['price'] = round($sku_price, 2);
                     }
                 }
                 $orderData[$recordNumber]['fedexRemark'] = $tmpArr1;
             }
         }
         var_dump($orderData);
         exit;
         //return $this->act_insertOrder($orderData);
     } else {
         self::$errMsg[] = get_promptmsg(10053);
         return false;
     }
 }