";
		//print_r($rows);
		$orderRows = array();
		$referenceArr = array();
		$refTrackingArr = array();

    // SKU竖排处理，转换为跟横排的格式，套用现有的处理逻辑
    if ($is_vertical) {
      $tempRowData = array();

      foreach ($rows as $key => $rowData) {
        // 数据过滤，若有交易订单号，则提取并按交易订单号重新整理数据
        if ($key >= 1 && '' !== trim($rowData[7])) {
          $tempRowData[trim($rowData[7])][] = $rowData;
          unset($rows[$key]);
        }
      }
      foreach ($tempRowData as $key => $rowData) {
        // 同一个交易订单号有多条SKU数据，需要过滤相同的SKU，以首次出现的为准
        if (($tempCount = count($rowData)) > 1) {
          $tempSkuData = array();

          // 过滤相同的SKU，以第一次出现为准
          foreach ($rowData as $skuKey => $skuRow) {
       
              $tempSkuData[] = array(
                trim($skuRow[27]),
                trim($skuRow[28]),
                trim($skuRow[29]),
                trim($skuRow[30]),
		        trim($skuRow[31]),
              );
            
          }
          // 合并产品SKU
          if (count($tempSkuData) > 1) {
            $skuNext = FALSE;
            foreach ($tempSkuData as $skuKey => $skuRow) {
              if (FALSE === $skuNext) {
                $skuNext = TRUE;
                continue;
              }
              $tempRowData[$key][0][] = $skuRow[0];
              $tempRowData[$key][0][] = $skuRow[1];
              $tempRowData[$key][0][] = $skuRow[2];
              $tempRowData[$key][0][] = $skuRow[3];
              $tempRowData[$key][0][] = $skuRow[4];
            }
          }
        }
        $rows[] = $tempRowData[$key][0];
      }
    }

		foreach ($rows as $key=>$rowData){
			//print_r($key);
			if($key>=1){
				$orderRow=self::TransformData($rowData,$referenceArr,$refTrackingArr);
				$referenceArr[] = $rowData[5];
				$orderRows[] = $orderRow;
				$sm_code = $orderRow['sm_code'];
				$sm_code = trim(strtoupper($sm_code));
				$refTracking = trim($rowData[2]);
				if($refTracking!='' ){
					/* if(!isset($refTrackingArr[$sm_code])){
						$refTrackingArr[$sm_code] = array($refTracking);
					}else{
						$oldref = $refTrackingArr[$sm_code];
						$oldref[] = $rowData[2];
						$refTrackingArr[$sm_code] = $oldref;
					} */
					if(!in_array($refTracking, $refTrackingArr)){
						$refTrackingArr[] = $refTracking;
					}
				}
				/* if($sm_code!='' && $refTracking!='' ){
					if(!isset($refTrackingArr[$sm_code])){
						$refTrackingArr[$sm_code] = array($refTracking);
					}else{
						$oldref = $refTrackingArr[$sm_code];
						$oldref[] = $rowData[2];
						$refTrackingArr[$sm_code] = $oldref;
					}
				} */
			}
		}
		//echo "

";
        //print_r($rows);
        $orderRows = array();
        $referenceArr = array();
        $refTrackingArr = array();
        //获取模板的列
        $init = array(
            'template'=>'order',
            'type'=> ( $is_vertical ? 1 : 2 ),
        );
        $obj = new Common_ExcelTemplate( $init );
        $columns = $obj->getOrderColumns();
        $columnsPosition = array_keys( $columns );
        $serviceCodeIndex = array_search( 'serviceCode', $columnsPosition);
        if( $serviceCodeIndex === false ) {
            return array();
        }

        // SKU竖排处理，转换为跟横排的格式，套用现有的处理逻辑
        if ($is_vertical) {
            $tempRowData = array();

            $transCodeIndex = array_search( 'transCode', $columnsPosition);
            $skuIndex = array_search( 'sku', $columnsPosition);
            $skuEnNameIndex = array_search( 'skuEnName', $columnsPosition);
            $priceIndex = array_search( 'DeclareUnitPrice', $columnsPosition);
            $tPriceIndex = array_search( 'TargetDeclareUnitPrice', $columnsPosition);
            $qtyIndex = array_search( 'qty', $columnsPosition);

            if( $transCodeIndex === false || $skuIndex === false || $skuEnNameIndex === false || $priceIndex === false
                || $tPriceIndex === false || $qtyIndex === false) {
                return array();
            }
            foreach ($rows as $key => $rowData) {
                // 数据过滤，若有交易订单号，则提取并按交易订单号重新整理数据
                if ($key >= 1 && '' !== trim($rowData[ $transCodeIndex ])) {
                    $tempRowData[trim($rowData[ $transCodeIndex ])][] = $rowData;
                    unset($rows[$key]);
                }
            }

            foreach ($tempRowData as $key => $rowData) {
                // 同一个交易订单号有多条SKU数据，需要过滤相同的SKU，以首次出现的为准
                if (($tempCount = count($rowData)) > 1) {
                    $tempSkuData = array();

                    // 过滤相同的SKU，以第一次出现为准
                    $skuSeq = array( $skuIndex, $skuEnNameIndex, $priceIndex, $tPriceIndex, $qtyIndex );
                    sort( $skuSeq );
                    foreach ($rowData as $skuKey => $skuRow) {
                        $tmpSKU = array();
                        foreach( $skuSeq as $seq) {
                            $tmpSKU[] = $skuRow[ $seq ];
                        }
                        $tempSkuData[] = $tmpSKU;

                    }
                    // 合并产品SKU
                    if (count($tempSkuData) > 1) {
                        $skuNext = FALSE;
                        foreach ($tempSkuData as $skuKey => $skuRow) {
                            if (FALSE === $skuNext) {
                                $skuNext = TRUE;
                                continue;
                            }
                            $tempRowData[$key][0][] = $skuRow[0];
                            $tempRowData[$key][0][] = $skuRow[1];
                            $tempRowData[$key][0][] = $skuRow[2];
                            $tempRowData[$key][0][] = $skuRow[3];
                            $tempRowData[$key][0][] = $skuRow[4];
                        }
                    }
                }
                $rows[] = $tempRowData[$key][0];
            }
        }
        foreach ($rows as $key=>$rowData){
            //print_r($key);
            if($key>=1){
                $orderRow=self::TransformDataByKey($rowData,$referenceArr,$refTrackingArr, $is_vertical );
                $referenceArr[] = array();//$rowData[ 5 ];
                $orderRows[] = $orderRow;
                $sm_code = $orderRow['sm_code'];
                $sm_code = trim(strtoupper($sm_code));
                $refTracking = trim($rowData[ $serviceCodeIndex ]);
                if($refTracking!='' ){
                    /* if(!isset($refTrackingArr[$sm_code])){
                        $refTrackingArr[$sm_code] = array($refTracking);
                    }else{
                        $oldref = $refTrackingArr[$sm_code];
                        $oldref[] = $rowData[2];
                        $refTrackingArr[$sm_code] = $oldref;
                    } */
                    if(!in_array($refTracking, $refTrackingArr)){
                        $refTrackingArr[] = $refTracking;
                    }
                }
                /* if($sm_code!='' && $refTracking!='' ){
                    if(!isset($refTrackingArr[$sm_code])){
                        $refTrackingArr[$sm_code] = array($refTracking);
                    }else{
                        $oldref = $refTrackingArr[$sm_code];
                        $oldref[] = $rowData[2];
                        $refTrackingArr[$sm_code] = $oldref;
                    }
                } */
            }
        }
        //echo "