Esempio n. 1
0
 /**
  * 获取可用库存及天数
  */
 public function act_getStockDays()
 {
     global $dbconn;
     $skuArr = isset($_REQUEST['skuArr']) ? json_decode($_REQUEST['skuArr'], TRUE) : '';
     if (empty($skuArr)) {
         self::$errCode = '001';
         self::$errMsg = 'skuArr param error';
         return array();
     }
     $fields = implode(',', array('sku', 'everyday_sale', 'stock_qty', 'ow_stock', 'salensend'));
     $where = 'WHERE sku IN (\'' . implode("','", $skuArr) . '\')';
     $szdata = SkuStatisticsModel::getInfo($fields, $where);
     $szskuarr = empty($szdata) ? array() : array_keys($szdata);
     $fields = implode(',', array('sku', 'everyday_sale', 'virtual_stock'));
     $where = 'WHERE sku IN (\'' . implode("','", $skuArr) . '\')';
     $owdata = SkuStatisticsModel::getOwInfo($fields, $where);
     $owskuarr = empty($owdata) ? array() : array_keys($owdata);
     $res = array();
     $skuarray = array_unique(array_merge($szskuarr, $owskuarr));
     if (!empty($skuarray)) {
         foreach ($skuarray as $sku) {
             $sz_stock = $ow_stock = 0;
             $sz_days = $ow_days = 0;
             if (!empty($szdata[$sku])) {
                 $sz_stock = $szdata[$sku]['stock_qty'] + $szdata[$sku]['ow_stock'] - $szdata[$sku]['salensend'];
                 $sz_days = $szdata[$sku]['everyday_sale'] == 0 ? 0 : round_num($sz_stock / $szdata[$sku]['everyday_sale'], 2);
             }
             if (!empty($owdata[$sku])) {
                 $ow_stock = $owdata[$sku]['virtual_stock'];
                 $ow_days = $owdata[$sku]['everyday_sale'] == 0 ? 0 : round_num($ow_stock / $owdata[$sku]['everyday_sale'], 2);
             }
             $res[$sku]['sz_stock'] = $sz_stock;
             $res[$sku]['sz_days'] = $sz_days;
             $res[$sku]['ow_stock'] = $ow_stock;
             $res[$sku]['ow_days'] = $ow_days;
         }
     }
     return $this->_checkReturnData($res, array());
 }
Esempio n. 2
0
/**
 * PAGINACION ARCHIVES (NOTA: partir en mas funciones - alex)
 * @return [string]         [html con la paginacion]
 */
function pagenavi($paged = '', $num_pages = '', $siteUrl = '', $especial = false, $simbol_url = '?', $variable_page = 'paged')
{
    global $wpdb, $wp_query;
    $before = '';
    $after = '';
    $pagenavi_options = optionsPagination();
    if (!is_single()) {
        $paged = $paged == '' ? intval(get_query_var($variable_page)) : $paged;
        $max_page = $num_pages == '' ? $wp_query->max_num_pages : $num_pages;
        if (empty($paged) || $paged == 0) {
            $paged = 1;
        }
        $pages_to_show = intval($pagenavi_options['num_pages']);
        $larger_page_to_show = intval($pagenavi_options['num_larger_page_numbers']);
        $larger_page_multiple = intval($pagenavi_options['larger_page_numbers_multiple']);
        $pages_to_show_minus_1 = $pages_to_show - 1;
        $half_page_start = floor($pages_to_show_minus_1 / 2);
        $half_page_end = ceil($pages_to_show_minus_1 / 2);
        $start_page = $paged - $half_page_start;
        if ($start_page <= 0) {
            $start_page = 1;
        }
        $end_page = $paged + $half_page_end;
        if ($end_page - $start_page != $pages_to_show_minus_1) {
            $end_page = $start_page + $pages_to_show_minus_1;
        }
        if ($end_page > $max_page) {
            $start_page = $max_page - $pages_to_show_minus_1;
            $end_page = $max_page;
        }
        if ($start_page <= 0) {
            $start_page = 1;
        }
        $larger_per_page = $larger_page_to_show * $larger_page_multiple;
        $larger_start_page_start = round_num($start_page, 10) + $larger_page_multiple - $larger_per_page;
        $larger_start_page_end = round_num($start_page, 10) + $larger_page_multiple;
        $larger_end_page_start = round_num($end_page, 10) + $larger_page_multiple;
        $larger_end_page_end = round_num($end_page, 10) + $larger_per_page;
        if ($larger_start_page_end - $larger_page_multiple == $start_page) {
            $larger_start_page_start = $larger_start_page_start - $larger_page_multiple;
            $larger_start_page_end = $larger_start_page_end - $larger_page_multiple;
        }
        if ($larger_start_page_start <= 0) {
            $larger_start_page_start = $larger_page_multiple;
        }
        if ($larger_start_page_end > $max_page) {
            $larger_start_page_end = $max_page;
        }
        if ($larger_end_page_end > $max_page) {
            $larger_end_page_end = $max_page;
        }
        if ($max_page > 1 || intval($pagenavi_options['always_show']) == 1) {
            $pages_text = str_replace("%CURRENT_PAGE%", number_format_i18n($paged), $pagenavi_options['pages_text']);
            $pages_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pages_text);
            echo $before . '<div class="pagenavi">' . "\n";
            if (!empty($pages_text)) {
                echo '<ul class="[ pagination ][ no-margin ]">';
            }
            echo '<li class="pag-anterior">';
            if ($especial == true) {
                $pa = $paged - 1;
                echo $paged > 1 ? '<a href="' . $siteUrl . $simbol_url . $variable_page . '=' . $pa . '"><img class="[ svg icon--iconed--small icon--stoke icon--thickness-3 ][ color-dark ]" src="' . THEMEPATH . 'icons/arrow-left-12.svg"></a>' : '';
            } else {
                previous_posts_link($pagenavi_options['prev_text']);
            }
            echo '</li>';
            if ($start_page >= 2 && $pages_to_show < $max_page) {
                $first_page_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pagenavi_options['first_text']);
                $url = $especial == true ? $siteUrl . $simbol_url . $variable_page . '=1' : esc_url(get_pagenum_link());
                echo '<li><a href="' . $url . '" class="first" title="' . $first_page_text . '">1</a></li>';
                if (!empty($pagenavi_options['dotleft_text'])) {
                    echo '<li><span class="expand">' . $pagenavi_options['dotleft_text'] . '</span></li>';
                }
            }
            if ($larger_page_to_show > 0 && $larger_start_page_start > 0 && $larger_start_page_end <= $max_page) {
                for ($i = $larger_start_page_start; $i < $larger_start_page_end; $i += $larger_page_multiple) {
                    $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                    echo '<li><a href="' . esc_url(get_pagenum_link($i)) . '" class="single_page" title="' . $page_text . '">' . $page_text . '</a></li>';
                }
            }
            for ($i = $start_page; $i <= $end_page; $i++) {
                if ($i == $paged) {
                    $current_page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['current_text']);
                    echo '<li class="num-pag-current active"><span class="current">' . $current_page_text . '</span></li>';
                } else {
                    $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                    $url = $especial == true ? $siteUrl . $simbol_url . $variable_page . '=' . $i : esc_url(get_pagenum_link($i));
                    echo '<li class="num-pag"><a href="' . $url . '" class="single_page" title="' . $page_text . '">' . $page_text . '</a></li>';
                }
            }
            if ($end_page < $max_page) {
                if (!empty($pagenavi_options['dotright_text'])) {
                    echo '<li><span class="expand">' . $pagenavi_options['dotright_text'] . '</span></li>';
                }
                $last_page_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pagenavi_options['last_text']);
                $url = $especial == true ? $siteUrl . $simbol_url . $variable_page . '=' . $max_page : esc_url(get_pagenum_link($max_page));
                echo '<li><a href="' . $url . '" class="last" title="' . $last_page_text . '">' . $max_page . '</a></li>';
            }
            echo '<li class="pag-siguiente">';
            if ($especial == true) {
                $pa = $paged + 1;
                echo $paged < $num_pages ? '<a href="' . $siteUrl . $simbol_url . $variable_page . '=' . $pa . '"><img class="[ svg icon--iconed--small icon--stoke icon--thickness-3 ][ color-dark ]" src="' . THEMEPATH . 'icons/arrow-right-12.svg"></a>' : '';
            } else {
                next_posts_link($pagenavi_options['next_text'], $max_page);
            }
            echo '</li>';
            if ($larger_page_to_show > 0 && $larger_end_page_start < $max_page) {
                for ($i = $larger_end_page_start; $i <= $larger_end_page_end; $i += $larger_page_multiple) {
                    $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                    echo '<li><a href="' . esc_url(get_pagenum_link($i)) . '" class="single_page edsf	" title="' . $page_text . '">' . $page_text . '</a></li>';
                }
            }
            echo '</ul></div>' . $after . "\n";
        }
    }
}
Esempio n. 3
0
     /*$sql = array2sql($orderdata_detail);
     		$msg = DLdlModel::insertOrderDetail($sql);
     		if(!$msg){
     			echo "订单{$orderdata['recordnumber']}订单明细信息插入失败!\r\n";
     			BaseModel::rollback();
     		}*/
     /***************BEGIN 订单详细扩展表数据***************/
     $orderDetailExtDL = array();
     $orderDetailExtDL['itemTitle'] = mysql_real_escape_string(trim($detail['Title']));
     $categoryName = mysql_real_escape_string(trim($detail['CategoryName']));
     $customCode = mysql_real_escape_string(trim($detail['CustomCode']));
     $material = mysql_real_escape_string(trim($detail['Material']));
     $skuShipfee = mysql_real_escape_string(trim($detail['SkuShipfee']));
     $ShenBaoQuantity = mysql_real_escape_string(trim($detail['ShenBaoQuantity']));
     $ShenBaoUnitPrice = mysql_real_escape_string(trim($detail['ShenBaoUnitPrice']));
     $salePrice = round_num(mysql_real_escape_string(trim($detail['SalePrice'])), 2);
     //实际SKU付款价
     /*************END 订单详细扩展表数据***************/
     /*$sql = array2sql($orderDetailExtDL);
     		$msg = DLdlModel::insertOrderDetailExtDL($sql);
     		if(!$msg){
     			echo "订单{$orderdata['recordnumber']}订单明细扩展信息插入失败!\r\n";
     			BaseModel::rollback();
     		}*/
     $obj_order_detail_data[] = array('orderDetailData' => $orderdata_detail, 'orderDetailExtenData' => $orderDetailExtDL);
     $ebay_fedex_remark[$categoryName][] = array('real_price' => $ShenBaoQuantity, 'qty' => $ShenBaoUnitPrice, 'hamcodes' => $customCode, 'detail' => $material);
 }
 $insertOrder = array('orderData' => $orderdata, 'orderExtenData' => $orderExtDL, 'orderUserInfoData' => $orderUserInfo, 'orderDetail' => $obj_order_detail_data, 'orderNote' => $orderNote);
 $calcInfo = CommonModel::calcAddOrderWeight($insertOrder['orderDetail']);
 //计算重量和包材
 //var_dump($calcInfo); exit;
Esempio n. 4
0
 function act_goodsAddXlsSave()
 {
     $uploadfile = date("Y") . date("m") . date("d") . rand(1, 3009) . ".xls";
     if ($_FILES['upfile']['tmp_name'] == '') {
         echo "请选择上传的excel文件";
         exit;
     }
     if (move_uploaded_file($_FILES['upfile']['tmp_name'], './upload/' . $uploadfile)) {
         echo "<font color=BLUE>文件上传成功!</font><br>";
     } else {
         echo "<font color=red> 文件上传失败!</font><br>";
     }
     echo $uploadfile;
     $fileName = 'upload/' . $uploadfile;
     $filePath = $fileName;
     $username = $_SESSION['userName'];
     $userId = $_SESSION['userId'];
     $stockdetailpower = UserModel::getUserPower($userId);
     $stockdetailpower = explode(',', $stockdetailpower[0]['powerName']);
     $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);
     $allRow = $currentSheet->getHighestRow();
     for ($c = 2; $c <= $allRow; $c++) {
         $data = array();
         $nowtime = time();
         $storeid = '';
         $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;
         $sku = post_check(trim($currentSheet->getCell($bb)->getValue()));
         if (!preg_match("/^[A-Z0-9]+(_[A-Z0-9]+)*\$/", $sku)) {
             if ($sku != '') {
                 echo "数据料号:<font color='#FF0000'>" . $sku . "</font>书写不规范,请认真检查再提交...";
                 exit;
             }
         }
         //检测是否导入完成
         if (empty($sku)) {
             $mask++;
             if ($mask > 9) {
                 break;
             }
             continue;
         } else {
             $mask = 1;
         }
         // 过滤下数据
         $goodsCost = trim($currentSheet->getCell($dd)->getValue());
         $goodsWeight = trim($currentSheet->getCell($ff)->getValue());
         if (!preg_match("/[\\d]/", $goodsCost) && $goodsCost != '') {
             echo "货品成本数据有误";
             exit;
         } else {
             if (!preg_match("/[\\d]/", $goodsWeight) && $goodsWeight != '') {
                 echo "货品重量数据有误";
                 exit;
             }
         }
         $spu = post_check(trim($currentSheet->getCell($aa)->getValue()));
         $goodsName = post_check(trim($currentSheet->getCell($cc)->getValue()));
         $goodsCost = empty($goodsCost) ? 0 : round_num($goodsCost, 2);
         //仓位号
         $goods_location = post_check(trim($currentSheet->getCell($ee)->getValue()));
         $goodsWeight = empty($goodsWeight) ? 0 : number_format($goodsWeight, 3, '.', '');
         $goodsNote = post_check(trim($currentSheet->getCell($gg)->getValue()));
         $goodsDecNameByEN = post_check(trim($currentSheet->getCell($hh)->getValue()));
         $goodsCustomsCode = post_check(trim($currentSheet->getCell($ii)->getValue()));
         $goodsDecNameByCN = post_check(trim($currentSheet->getCell($jj)->getValue()));
         $goodsDecWorth = post_check(trim($currentSheet->getCell($kk)->getValue()));
         $goodsLength = post_check(trim($currentSheet->getCell($ll)->getValue()));
         $goodsWidth = post_check(trim($currentSheet->getCell($mm)->getValue()));
         $goodsHeight = post_check(trim($currentSheet->getCell($nn)->getValue()));
         //类别
         $goods_categoryname = post_check(trim($currentSheet->getCell($oo)->getValue()));
         $pid_name = post_check(trim($currentSheet->getCell($pp)->getValue()));
         //仓库
         $warehouseName = post_check(trim($currentSheet->getCell($qq)->getValue()));
         //采购员
         $purchaseName = post_check(trim($currentSheet->getCell($rr)->getValue()));
         //包装材料
         $packingmaterial = post_check(trim($currentSheet->getCell($ss)->getValue()));
         //供应商
         $capacity = post_check(trim($currentSheet->getCell($tt)->getValue()));
         if ($goodsLength == '') {
             $goodsLength = 0;
         }
         if ($goodsWidth == '') {
             $goodsWidth = 0;
         }
         if ($goodsHeight == '') {
             $goodsHeight = 0;
         }
         $spu = strpos($spu, '_') === false ? str_pad($spu, 3, '0', STR_PAD_LEFT) : $spu;
         $sku = strpos($sku, '_') === false ? str_pad($sku, 3, '0', STR_PAD_LEFT) : $sku;
         //	if($department != '采购部' && $spu !=''){
         //		echo "<br/>非采购部人员不能导入或修改spu的值";
         //		exit();
         //	}
         /* 仓库对应的IDfactory */
         if (!empty($warehouseName)) {
             /*
             $wh 	 = RelationModel::getWarehouse("and warehouseName='{$warehouseName}'");
             var_dump($wh);die; 
             $storeid = $wh[0]['id'];
             */
             $storeid = 1;
         }
         /* 货品类别 */
         if (!empty($goods_categoryname) && !empty($pid_name)) {
             $pcate = CategoryModel::getCategoryList("id", "where name='{$pid_name}'");
             if ($pcate) {
                 $cate = CategoryModel::getCategoryList("path", "where pid='{$pcate[0]['id']}' and name='{$goods_categoryname}'");
                 if ($cate) {
                     $goodsCategory = $cate[0]['path'];
                 } else {
                     echo "<br/>第<font color='red'>{$c}</font>条记录中<font color='orange'>货品类别或父类有误,</font>请检查后再提交...<br/>";
                     exit;
                 }
             } else {
                 echo "<br/>第<font color='red'>{$c}</font>条记录中<font color='orange'>货品类别或父类有误,</font>请检查后再提交...<br/>";
                 exit;
             }
             //$goodsCategory = "1-3-5";               //调用类别接口获取类别id
         }
         if ($purchaseName == "") {
             echo "有部分数据没填采购名字,请认真检查再提交...";
             exit;
         } else {
             $purchaseId = 1;
             //需调用接口获取采购员id
         }
         /*
         需要调接口获取用户部门
         if($department == '采购部' && trim($goodsCategory) == ''){//采购部人员操作时,导入货品类别不能为空
         	echo "有部分数据没填货品类别,请认真检查再提交...";
         	exit();
         }
         */
         //统计供应商id
         if (!empty($capacity)) {
             $capacity_a = array();
             $capacity_a = array_filter(explode(',', $capacity));
             $capacityid = 1;
             //调用供应商接口获取id
         }
         $data = array('goodsName' => $goodsName, 'goodsDecNameByEN' => $goodsDecNameByEN, 'goodsDecNameByCN' => $goodsDecNameByCN, 'spu' => $spu, 'sku' => $sku, 'goodsCost' => $goodsCost, 'goodsWeight' => $goodsWeight, 'goodsNote' => $goodsNote, 'goodsLength' => $goodsLength, 'goodsWidth' => $goodsWidth, 'goodsHeight' => $goodsHeight, 'goodsCategory' => $goodsCategory, 'goodsCustomsCode' => $goodsCustomsCode, 'goodsDecWorth' => $goodsDecWorth, 'purchaseId' => $purchaseId);
         $result = GoodsModel::getGoodsList("id", "where sku='{$sku}'");
         if (empty($result)) {
             $data['goodsCreatedTime'] = $nowtime;
             $data['isNew'] = 1;
             //默认是新品
             /*
             if(empty($goodsCategory) && $department == '采购部'){//拦截错误的货品类别和父类记录
             	$cn = $c - 2;
             	echo "<br/>第<font color='red'>$cn</font>条记录中<font color='orange'>货品类别或父类有误,</font>请检查后再提交...<br/>";
             	exit();
             }
             */
             //if(empty($spu)  && $department == '采购部'){//首次插入数据时spu必须非空且要符合规范
             if (empty($spu)) {
                 //首次插入数据时spu必须非空且要符合规范
                 echo "spu存在为空的列,请认真检查再提交...";
                 exit;
             }
             //if(!preg_match("/^[A-Z0-9]+(_[A-Z0-9]+)*$/",$spu) && $department == '采购部'){
             if (!preg_match("/^[A-Z0-9]+(_[A-Z0-9]+)*\$/", $spu)) {
                 echo "SPU号:<font color='#FF0000'>" . $spu . "</font>书写不规范,请认真检查再提交...";
                 exit;
             }
             /*
             foreach($sqlnew as $arrnew){//如果在料号转换中存在和导入的sku相同的新料号,则认为该sku仍然是老品
             	if($arrnew['new_sku'] == $goods_sn){
             		$isNew = 0;
             		break;
             	}
             }
             */
             $goodsid = GoodsModel::insertRow($data);
             if ($goodsid) {
                 $goodsCode = $goodsid + 1000000;
                 $u_data = array('goodsCode' => $goodsCode);
                 $where = "AND id='{$goodsid}'";
                 if (GoodsModel::update($u_data, $where)) {
                     //插入物品与仓位关联表
                     if (!empty($storeid)) {
                         $good_wh_data = array('goodsId' => $goodsid, 'locationId' => $storeid);
                     }
                     //跟新sku自动表进入系统
                     $u_sku_data = array('status' => 2);
                     SpuModel::update($u_sku_data, "AND sku='{$spu}'");
                     $status = " -[<font color='#33CC33'>物品编号:{$sku} 导入成功 </font>]";
                     echo $status . '<br>';
                 } else {
                     $status = " -[<font color='#FF0000'>物品编号:{$sku} 导入失败<br/></font>]";
                     echo $status . '<br>';
                 }
             }
             /*
             if($goods_cost){
             	//增加价格变化到价格表 add by guanyongjun 2013-06-08
             	$sqlcost		= "INSERT INTO ebay_goods_cost (goods_sn,goods_cost,add_time,cguser,storeid,mainsku) VALUES('{$goods_sn}','{$goods_cost}','{$nowtime}','{$cguser}','{$storeid}','".get_mainsku($goods_sn)."')";
             	echo $sqlcost."<br/>";
             	$dbcon->execute($sqlcost);
             }
             */
         } else {
             if ($spu == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['spu']);
             }
             if ($goodsName == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsName']);
             }
             if ($goodsDecNameByEN == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsDecNameByEN']);
             }
             if ($goodsDecNameByCN == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsDecNameByCN']);
             }
             if ($sku == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['sku']);
             }
             if ($goodsCost == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsCost']);
             }
             if ($goodsWeight == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsWeight']);
             }
             if ($goodsNote == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsNote']);
             }
             if ($goodsLength == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsLength']);
             }
             if ($goodsWidth == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsWidth']);
             }
             if ($goodsHeight == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsHeight']);
             }
             if ($goodsCategory == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsCategory']);
             }
             if ($goodsCustomsCode == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsCustomsCode']);
             }
             if ($goodsDecWorth == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['goodsDecWorth']);
             }
             if ($purchaseName == '' || !in_array('stock_name', $stockdetailpower)) {
                 unset($data['purchaseId']);
             }
             $where = "AND sku='{$sku}'";
             if (!empty($data)) {
                 if (GoodsModel::update($data, $where)) {
                     //插入物品与仓位关联表
                     if (!empty($storeid)) {
                         $good_wh_data = array('goodsId' => $goodsid, 'locationId' => $storeid);
                         RelationModel::insertGoodsWhRow($good_wh_data);
                     }
                     $status = " -[<font color='#FF0000'>物品编号:{$sku} 更新失败</font>]";
                     echo $status . '<br>';
                 } else {
                     $status = " -[<font color='#FF0000'>物品编号:{$sku} 更新失败</font>]";
                     echo $status . '<br>';
                 }
                 /*
                 					if($goods_cost != '' && $goods_cost && in_array('stock_cost', $stockdetailpower)  ) {
                 //增加价格变化到价格表 add by guanyongjun 2013-06-08
                 $sqlcost		= "SELECT goods_cost FROM ebay_goods WHERE goods_sn = '{$goods_sn}' AND goods_cost = '{$goods_cost}'";
                 //echo $sqlcost;
                 //exit;
                 $sqlcost		= $dbcon->execute($sqlcost);
                 $sqlcost		= $dbcon->getResultArray($sqlcost);
                 if(!$sqlcost){
                 	$costtime		= time();
                 	$sqlcost		= "INSERT INTO ebay_goods_cost (goods_sn,goods_cost,add_time,cguser,storeid,mainsku) VALUES('{$goods_sn}','{$goods_cost}','{$costtime}','{$cguser}','{$storeid}','".get_mainsku($goods_sn)."')";
                 	echo $sqlcost."<br/>";
                 	$dbcon->execute($sqlcost);
                 }
                 					}
                 
                 					if($isuse!==''  && in_array('stock_status', $stockdetailpower) ){
                 //更新价格表状态 add by guanyongjun 2013-06-08
                 $sqlcost		= "UPDATE ebay_goods_cost SET isuse = '".intval($isuse)."' WHERE goods_sn = '{$goods_sn}'";
                 $dbcon->execute($sqlcost);
                 					}
                 */
             } else {
                 $status = " -[<font color='#FF0000'>物品编号:{$sku} 已经是最新</font>]";
                 echo $status . '<br>';
             }
         }
         echo '<br>';
     }
 }
Esempio n. 5
0
 function ktz_pagenavi($before = '', $after = '')
 {
     global $wpdb, $wp_query;
     $pagenavi_options = array();
     $pagenavi_options['pages_text'] = __('Page %CURRENT_PAGE% of %TOTAL_PAGES%:', ktz_theme_textdomain);
     $pagenavi_options['current_text'] = __('%PAGE_NUMBER%', ktz_theme_textdomain);
     $pagenavi_options['page_text'] = __('%PAGE_NUMBER%', ktz_theme_textdomain);
     $pagenavi_options['first_text'] = __('First Page', ktz_theme_textdomain);
     $pagenavi_options['last_text'] = __('Last Page', ktz_theme_textdomain);
     $pagenavi_options['next_text'] = __('Next &raquo;', ktz_theme_textdomain);
     $pagenavi_options['prev_text'] = __('&laquo; Previous', ktz_theme_textdomain);
     $pagenavi_options['dotright_text'] = '...';
     $pagenavi_options['dotleft_text'] = '...';
     $pagenavi_options['num_pages'] = 3;
     $pagenavi_options['always_show'] = 0;
     $pagenavi_options['num_larger_page_numbers'] = 0;
     $pagenavi_options['larger_page_numbers_multiple'] = 5;
     if (!is_single()) {
         $request = $wp_query->request;
         $posts_per_page = intval(get_query_var('posts_per_page'));
         $paged = intval(get_query_var('paged'));
         $numposts = $wp_query->found_posts;
         $max_page = $wp_query->max_num_pages;
         if (empty($paged) || $paged == 0) {
             $paged = 1;
         }
         $pages_to_show = intval($pagenavi_options['num_pages']);
         $larger_page_to_show = intval($pagenavi_options['num_larger_page_numbers']);
         $larger_page_multiple = intval($pagenavi_options['larger_page_numbers_multiple']);
         $pages_to_show_minus_1 = $pages_to_show - 1;
         $half_page_start = floor($pages_to_show_minus_1 / 2);
         $half_page_end = ceil($pages_to_show_minus_1 / 2);
         $start_page = $paged - $half_page_start;
         if ($start_page <= 0) {
             $start_page = 1;
         }
         $end_page = $paged + $half_page_end;
         if ($end_page - $start_page != $pages_to_show_minus_1) {
             $end_page = $start_page + $pages_to_show_minus_1;
         }
         if ($end_page > $max_page) {
             $start_page = $max_page - $pages_to_show_minus_1;
             $end_page = $max_page;
         }
         if ($start_page <= 0) {
             $start_page = 1;
         }
         $larger_per_page = $larger_page_to_show * $larger_page_multiple;
         $larger_start_page_start = round_num($start_page, 10) + $larger_page_multiple - $larger_per_page;
         $larger_start_page_end = round_num($start_page, 10) + $larger_page_multiple;
         $larger_end_page_start = round_num($end_page, 10) + $larger_page_multiple;
         $larger_end_page_end = round_num($end_page, 10) + $larger_per_page;
         if ($larger_start_page_end - $larger_page_multiple == $start_page) {
             $larger_start_page_start = $larger_start_page_start - $larger_page_multiple;
             $larger_start_page_end = $larger_start_page_end - $larger_page_multiple;
         }
         if ($larger_start_page_start <= 0) {
             $larger_start_page_start = $larger_page_multiple;
         }
         if ($larger_start_page_end > $max_page) {
             $larger_start_page_end = $max_page;
         }
         if ($larger_end_page_end > $max_page) {
             $larger_end_page_end = $max_page;
         }
         if ($max_page > 1 || intval($pagenavi_options['always_show']) == 1) {
             echo $before . '<ul class="pagination">' . "\n";
             $pages_text = str_replace("%CURRENT_PAGE%", number_format_i18n($paged), $pagenavi_options['pages_text']);
             $pages_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pages_text);
             if (!empty($pages_text)) {
                 echo '<li class="disabled">';
                 echo '<span>' . $pages_text . '</span>';
                 echo '</li>';
             }
             if (get_previous_posts_link()) {
                 echo '<li>';
                 previous_posts_link($pagenavi_options['prev_text']);
                 echo '</li>';
             }
             if ($start_page >= 2 && $pages_to_show < $max_page) {
                 $first_page_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pagenavi_options['first_text']);
                 echo '<li><a href="' . esc_url(get_pagenum_link()) . '" class="first" title="' . $first_page_text . '">1</a></li>';
                 if (!empty($pagenavi_options['dotleft_text'])) {
                     echo '<li class="disabled"><span>' . $pagenavi_options['dotleft_text'] . '</span></li>';
                 }
             }
             if ($larger_page_to_show > 0 && $larger_start_page_start > 0 && $larger_start_page_end <= $max_page) {
                 for ($i = $larger_start_page_start; $i < $larger_start_page_end; $i += $larger_page_multiple) {
                     $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                     echo '<li><a href="' . esc_url(get_pagenum_link($i)) . '" title="' . $page_text . '">' . $page_text . '</a></li>';
                 }
             }
             for ($i = $start_page; $i <= $end_page; $i++) {
                 if ($i == $paged) {
                     $current_page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['current_text']);
                     $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                     echo '<li class="active"><a href="' . esc_url(get_pagenum_link($i)) . '" title="' . $page_text . '">' . $current_page_text . '</a></li>';
                 } else {
                     $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                     echo '<li><a href="' . esc_url(get_pagenum_link($i)) . '" title="' . $page_text . '">' . $page_text . '</a></li>';
                 }
             }
             if ($end_page < $max_page) {
                 if (!empty($pagenavi_options['dotright_text'])) {
                     echo '<li class="disabled"><span>' . $pagenavi_options['dotright_text'] . '</span></li>';
                 }
                 $last_page_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pagenavi_options['last_text']);
                 echo '<li><a href="' . esc_url(get_pagenum_link($max_page)) . '" title="' . $last_page_text . '">' . $max_page . '</a></li>';
             }
             if ($larger_page_to_show > 0 && $larger_end_page_start < $max_page) {
                 for ($i = $larger_end_page_start; $i <= $larger_end_page_end; $i += $larger_page_multiple) {
                     $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                     echo '<li><a href="' . esc_url(get_pagenum_link($i)) . '" title="' . $page_text . '">' . $page_text . '</a></li>';
                 }
             }
             if (get_next_posts_link()) {
                 echo '<li>';
                 next_posts_link($pagenavi_options['next_text'], $max_page);
                 echo '</li>';
             }
             echo '</ul>' . $after . "\n";
         }
     }
 }
Esempio n. 6
0
 public function act_repeatShipments2()
 {
     date_default_timezone_set("Asia/Chongqing");
     error_reporting(0);
     $currenctyList = CurrencyModel::getCurrencyList('currency,rates', 'where 1=1');
     foreach ($currenctyList as $value) {
         $currenctys[$value['currency']] = $value['rates'];
         //汇率数组
     }
     $packinglists = GoodsModel::getMaterInfo();
     //获取全部包材记录
     foreach ($packinglists as $packinglist) {
         $packings[$packinglist['id']]['pmName'] = $packinglist['pmName'];
         $packings[$packinglist['id']]['pmCost'] = $packinglist['pmCost'];
     }
     unset($packinglists);
     $carrierLists = CommonModel::getCarrierList();
     //获取全部运输方式
     foreach ($carrierLists as $carrierList) {
         $carriers[$carrierList['id']] = $carrierList['carrierNameCn'];
     }
     unset($carrierLists);
     $channelLists = CommonModel::getAllChannelList();
     //获取全部运输方式下的渠道记录
     foreach ($channelLists as $channelList) {
         $channels[$channelList['id']] = $channelList['channelName'];
     }
     unset($channelLists);
     $staffInfoLists = CommonModel::getStaffInfoList();
     //获取全部人员
     foreach ($staffInfoLists as $staffInfoList) {
         $staffLists[$staffInfoList['global_user_id']] = $staffInfoList['global_user_name'];
     }
     unset($staffInfoLists);
     //print_r($packings);
     //        exit;
     $ebayaccount = omAccountModel::ebayaccountAllList();
     //获取全部账号信息
     foreach ($ebayaccount as $value) {
         $ebayaccounts[$value['ebay_platform']][] = $value['id'];
         //账号id对应名称
     }
     unset($ebayaccount);
     $accountLists = omAccountModel::accountAllList();
     //获取全部账号信息
     foreach ($accountLists as $value) {
         $accounts[$value['id']] = $value['account'];
         //账号id对应名称
     }
     $time1 = time();
     $start = strtotime($_REQUEST['start']);
     $end = strtotime($_REQUEST['end']);
     $mailway = $_REQUEST['mailway'];
     $account = $_REQUEST['account'];
     ///////////////////////////////////////////////
     $accountStr = '';
     if ($account != '') {
         //组合成sql 中accountId In() 语句
         $account = explode("#", $account);
         foreach ($account as $value) {
             if ($value != '') {
                 $accountStr .= " accountId='" . $value . "' or ";
             }
         }
     }
     $accountStr = substr($accountStr, 0, strlen($accountStr) - 3);
     if (empty($accountStr)) {
         $accountStr = ' 1=1';
     }
     //$shipOrderList = OrderInfoModel :: getShipOrderList($start, $end, $accountStr);
     $tNameUnShipped = 'om_shipped_order';
     //已發貨订单表
     $where = " WHERE id IN ('8344971','8344971','8344971','8849112','9027686','9118441','9253209','9255395','9337524','9337524','9393954','9395762','9423987','9423987','9425121','9437038','9440042','9440042','9440042','9457399','9461841','9465559','9466929','9472244','9472244','9472244','9488351','9488351','9488479','9489408','9489408','9489408','9489408','9499144','9518194','9518200','9518866','9518866','9518866','9518866','9518898','9519076','9522183','9522183','9532719','9535192','9549634','9549634','9549634','9549643','9552004','9552004','9552004','9560244','9560244','9560244','9560244','9576989','9576989','9576989','9596753','9612887','9622477','9622500','9622512','9623276','9623276','9624016','9626076','9626076','9626076','9626076','9626316','9626385','9626385','9626385','9626403','9627404','9628837','9630913','9630913','9640585','9640585','9640585','9640604','9640770','9641002','9641274','9641274','9641274','9641395','9641529','9641529','9641744','9641829','9641829','9641892','9641892','9641946','9642205','9642205','9642380','9642780','9643939','9643939','9644644','9644644','9647186','9648475','9648478','9648478','9649284','9649286','9649649','9649649','9649649','9649652','9649652','9649652','9649885','9649909','9650192','9650192','9650198','9650198','9650241','9650322','9650322','9650322','9650322','9650380','9650381','9650388','9650571','9650571','9650571','9650612','9650615','9650637','9650649','9650673','9650673','9650681','9650685','9650696','9650704','9650704','9650726','9650741','9650741','9650761','9650785','9650826','9650834','9650834','9650834','9650834','9650838','9650841','9650841','9650914','9650937','9650937','9650958','9650958','9650989','9650995','9651008','9651120','9651151','9651333','9651351','9651351','9651351','9651363','9651618','9652039','9652041','9652172','9652197','9652294','9652355','9652355','9652365','9652547','9652570','9652815','9652829','9652829','9652830','9652830','9652830','9652834','9653349','9653350','9653677','9653677','9653784','9653786','9653790','9653790','9653826','9653866','9653866','9653866','9653866','9653868','9653869','9653869','9653869','9653870','9653870','9653871','9653874','9653878','9653878','9653878','9653878','9653879','9653884','9653884','9653959','9654059','9654071','9654332','9654572','9654572','9654572','9654573','9654573','9654778','9654778','9654784','9654792','9654961','9654964','9655556','9655630','9655630','9655643','9655643','9655643','9655646','9655734','9655775','9655777','9656086','9656208','9656209','9656210','9656529','9656529','9656593','9656629','9656634','9656746','9656983','9657511','9657566','9657566','9657566','9657566','9657641','9657641','9657677','9657678','9657680','9657802','9657802','9657803','9657985','9658074','9658081','9658321','9658337','9658449','9658458','9658501','9658501','9658840','9659006','9659144','9659726','9659726','9660877','9661308','9662160','9662162','9663236','9663236','9663236','9663236','9663236','9663236','9663254','9663408','9664335','9664335','9664335','9664335','9664335','9664335','9664335','9664335','9664335','9664338','9664338','9664341','9665707','9667826','9667826','9667826','9667826','9667826','9667826','9667826','9667826','9667835','9667843','9667849','9667849','9667849','9667849','9667849','9670393','9670393','9670393','9670393','9670393','9670393','9670407','9670407','9670407','9670407','9670407','9670417','9670426','9670683','9673777','9673777','9673777','9673777','9673777','9673778','9675229','9675242','9675595','9675595','9675595','8526402','8809110','8842096','8842096','8842096','8862631','8862631','8905974','8905974','8968635','9046612','9162772','9180940','9180940','9180940','9180940','9241329','9241329','9241329','9308486','9308486','9308486','9376347','9378671','9393969','9411833','9457216','9474385','9474385','9474385','9474385','9474603','9476126','9477416','9477416','9478721','9489020','9489608','9489608','9489608','9498874','9505075','9505075','9505075','9505075','9505151','9505151','9505151','9505151','9505733','9510621','9520197','9528779','9537456','9537668','9550596','9550596','9550596','9566234','9566234','9566248','9566248','9592573','9593512','9593512','9593512','9593512','9593512','9593512','9593512','9602420','9602420','9607647','9607647','9607647','9607647','9607647','9610633','9610776','9610776','9611433','9612362','9615401','9618958','9618958','9623437','9628510','9628510','9628655','9628655','9638991','9641400','9649804','9649855','9649855','9649855','9649855','9649894','9650472','9650472','9650552','9650556','9650583','9650585','9651279','9651509','9651712','9652013','9652013','9652273','9652273','9652274','9652274','9652274','9652441','9652483','9652513','9652523','9652523','9652929','9652929','9652929','9652929','9652929','9652929','9652929','9652929','9653014','9653027','9653027','9653027','9653027','9653103','9653345','9653345','9653345','9653345','9653345','9653489','9653567','9653637','9653938','9653938','9653938','9653938','9653938','9653941','9653941','9653941','9654055','9654055','9654055','9654055','9654061','9654075','9654084','9654323','9654641','9655179','9655255','9655255','9655506','9655506','9655538','9655671','9655835','9655967','9655967','9655967','9656198','9656251','9656251','9656251','9656277','9656279','9656329','9656329','9656329','9656329','9656522','9656541','9656541','9656655','9656921','9656921','9656942','9656942','9657107','9657174','9657174','9657175','9657175','9657175','9657345','9657860','9657860','9657994','9658000','9658000','9658004','9658004','9658012','9658030','9658030','9658030','9658030','9658114','9658141','9658141','9658156','9658209','9658286','9658286','9658295','9658295','9658295','9658295','9658296','9658296','9658595','9658595','9658649','9658691','9658784','9658784','9658784','9658784','9658798','9658809','9658834','9658845','9658852','9658852','9658852','9658914','9658914','9659007','9659009','9659083','9659084','9659148','9659151','9659151','9659355','9659378','9659401','9659451','9659451','9659594','9659804','9660076','9660076','9660393','9660399','9660399','9660406','9660453','9660453','9660453','9660453','9660460','9660603','9660603','9660603','9660862','9660862','9660864','9660864','9660864','9660864','9660864','9660864','9660864','9660864','9660864','9660942','9660952','9660952','9661096','9661096','9661156','9661187','9661292','9661481','9661622','9661850','9661890','9661890','9662030','9662113','9662113','9662146','9662146','9662249','9662249','9662343','9662457','9662471','9662471','9662502','9662696','9662732','9662732','9662732','9662733','9662733','9662733','9662832','9662908','9662908','9662909','9662971','9663010','9663010','9663010','9663014','9663380','9663380','9663380','9663386','9663386','9663692','9663693','9663754','9663754','9663826','9663826','9663894','9663998','9664012','9664080','9664090','9664093','9664112','9664112','9664112','9664112','9664175','9664191','9664191','9664192','9664192','9664196','9664554','9664554','9664968','9665016','9665209','9665222','9665222','9665309','9665392','9665396','9665667','9665667','9665667','9665668','9665668','9659581','9660388','9662117','9662117','9664751','9666120','9666124','9666258','9666258','9666262','9666264','9666344','9666377','9666383','9666383','9666383','9666383','9666384','9666384','9666384','9666384','9666828','9666828','9666947','9667031','9667031','9667206','9667206','9667206','9667206','9667332','9667564','9667564','9667564','9667564','9667567','9667567','9667567','9667567','9667567','9667567','9667580','9667580','9667581','9667597','9667754','9667802','9667802','9667802','9667802','9667949','9667949','9668151','9668151','9668683','9668685','9668773','9668802','9668802','9668802','9668808','9668808','9669255','9669262','9669265','9669268','9669268','9669273','9669285','9669541','9669883','9669964','9669964','9669964','9669964','9669964','9669972','9670114','9670129','9670129','9670286','9670338','9670338','9670411','9671287','9671290','9671452','9671531','9671634','9671634','9671634','9671680','9671680','9671693','9671896','9671934','9671973','9671988','9671988','9672000','9672194','9672194','9672339','9672362','9672362','9672698','9672735','9672743','9672751','9672790','9672911','9672911','9672911','9672993','9673004','9673004','9673101','9673218','9673319','9673323','9673380','9673421','9673452','9673475','9673516','9673643','9673643','9673643','9673668','9673747','9673749','9673753','9673753','9673760','9674395','9674395','9674419','9674419','9674848','9674848','9674850','9674850','9674850','9674850','9674852','9674854','9674854','9674854','9674885','9674899','9674899','9674899','9674899','9674899','9674899','9674908','9674913','9674913','9674913','9674920','9674920','9674920','9674920','9675055','9675087','9675087','9675087','9675137','9675137','9675137','9675137','9675137','9675157','9675157','9675157','9675271','9675583','9675584','9675586','9675586','9696845','9696880','9696880','9697073','9697082','9697092','9697095','9697095','9697095','9697095','9697105','9697110','9697110','9697110','9697115','9697115','9697115','9697254','9698356','9632026','9658246','9661119','9661119','9661119','9661119','9661119','9662121','9666751','9697750','9697750','9698264','9698805','9698808','9698810','9698810','9698810','9698810','9698813','9699173','9699175','9699179','9699179','9699179','9699182','9699184','9699267','9699267','9699267','9699821','9699821','9699892','9699900','9699908','9699923','9699924','9699924','9699924','9699927','9699930','9699930','9699976','9700235','9700312','9700333','9700357','9700357','9700399','9700399','9700931','9700973','9701169','9701449','9701648','9704135')";
     //$where = " WHERE `paymentTime` > $start AND `paymentTime` < $end AND `accountId` = '336' LIMIT 1,100";
     $shipOrderList = OrderindexModel::showOrderList($tNameUnShipped, $where);
     $fileName = "repeatShipments" . date('Y-m-d', $end) . ".xls";
     $excel = new ExportDataExcel('browser', $fileName);
     $excel->initialize();
     $row = array('日期', 'ebay store', '交易号', '客户ID', '仓位号', '料号', '数量', '料号重量', '成本', '国家', '包裹总价值', '邮费', '币种', '运输方式', '邮寄公司', '挂号条码', '是/否', '重量', '收件人姓名', '客户电话', '地址', '英文州名', '英文城市名', '邮编', '订单编号', '包装员', '配货员', '扫描员', '分区人员', '料号描述');
     $excel->addRow($row);
     foreach ($shipOrderList as $key => $value) {
         //key代表最外层的维数
         /*$value分别有7个对应的键,分别为
         		  orderData,//订单表头数据记录
         		  orderExtenData,//订单表扩展数据记录
         		  orderUserInfoData,//订单表中客户的数据记录
         		  orderWhInfoData,//物料对订单进行操作的数据记录
         		  orderNote,//订单的备注(销售人员添加)记录
         		  orderTracknumber,//订单的追踪号记录
         		  orderAudit,//订单明细审核记录
         		  orderDetail //订单明细记录
         		*/
         $orderData = $value['orderData'];
         //订单表头数据记录,为一维数组
         $orderExtenData = $value['orderExtenData'];
         //扩展表头数据记录,为一维数组
         $orderUserInfoData = $value['orderUserInfoData'];
         //订单客户数据记录,为一维数组
         $orderWhInfoData = $value['orderWhInfoData'];
         //物料对订单进行操作的数据记录,为一维数组
         $orderNote = $value['orderNote'];
         //订单备注记录,二维数组
         $orderTracknumber = $value['orderTracknumber'];
         //订单跟踪号,二维数组
         $orderAudit = $value['orderAudit'];
         //订单明细审核记录,二维数组
         $orderDetail = $value['orderDetail'];
         //订单明细记录,三维数组
         $orderId = $orderData['id'];
         //****订单编号 $ebay_id
         $orderPaidtime = @date('Y-m-d', $orderData['paymentTime']);
         //****订单付款时间 paidtime
         $orderUserInfoEmail = $orderUserInfoData['email'];
         //****客户邮箱 emial
         $platformUsername = $orderExtenData['platformUsername'];
         //****客户平台登录名称 $ebay_userid,用扩展表中的该字段 ebay_username
         $username = @html_entity_decode($orderUserInfoData['username'], ENT_QUOTES, 'UTF-8');
         //****客户真实名称(收件人) username
         $orderUserInfoStreet1 = @$orderUserInfoData['street'];
         //**** 街道地址 street1
         $orderUserInfoStreet2 = @$orderUserInfoData['address2'];
         //*** 街道地址2 steet2(一般订单会有两个街道地址)
         $orderUserInfoCity = $orderUserInfoData['city'];
         //**** 市 city
         $orderUserInfoState = $orderUserInfoData['state'];
         //**** 州 state
         $orderUserInfoCountryName = $orderUserInfoData['countryName'];
         //**** 国家全名
         //客服部小霞提出 导出列 国家 显示英文 方便退款处理
         //$cnname                   = $country[$countryname];
         $orderUserInfoZip = $orderUserInfoData['zipCode'];
         //**** 邮编 zipCode
         $orderUserInfoTel = $orderUserInfoData['landline'];
         //**** 座机 landline
         $orderWhInfoActualShipping = $orderWhInfoData['actualShipping'];
         //****实际运费,warehouse表中,ebay_shipfee
         $orderExtenFeedback = $orderExtenData['feedback'];
         //****客户留言 ebay_note
         $OrderActualTotal = @round($orderData['actualTotal'], 2);
         //****实际收款总价 $ebay_total
         $orderTracknumberOne = @$orderTracknumber[0]['tracknumber'];
         //****追踪号,这里只读取记录数的第一条记录的追踪号 $ebay_tracknumber
         $accountName = @$accounts[$orderData['accountId']];
         //****账号名称 $ebay_account
         $orderRecordnumber = @$orderData['recordNumber'];
         //****订单编码(对应平台上的编码) $recordnumber0??????
         //$ebay_carrier				= @$shipOrder['transportId'];//transportId ebay_carrier
         $orderUserInfoPhone = $orderUserInfoData['phone'];
         //****客户手机号码 $ebay_phone
         $orderExtenCurrency = $orderExtenData['currency'];
         //****币种 $ebay_currency
         $orderWhInfoPackersId = $orderWhInfoData['packersId'];
         //包装人员Id
         $packinguser = $staffLists[$orderWhInfoPackersId];
         //对应包装人员姓名
         //var_dump($packinguser);
         $OrderChannelId = $orderData['channelId'];
         //渠道Id $channelId
         $orderCalcShipping = $orderData['calcShipping'];
         //估算运费 $ordershipfee
         $orderExtenPayPalPaymentId = $orderExtenData['PayPalPaymentId'];
         //Paypal付款ID $ebay_ptid
         $orderExtenPayPalEmailAddress = $orderExtenData['PayPalEmailAddress'];
         //PayPal付款邮箱地址 $ebay_pp
         $isCopy = $orderData['isCopy'];
         //默认为0为原始订单,1为被复制订单,2为复制订单
         $isCopy = $isCopy == '0' ? '' : ($isCopy == '1' ? '被复制订单' : '复制订单');
         //$ebay_noteb				= $is_main_order==2 ? '复制 订单' : ($is_main_order==1 ? '被复制 订单' : '');
         $isBuji = $orderData['isBuji'];
         //是否补寄订单。默认0正常订单;1为被补寄的订单;2为补寄产生的新订单
         $isBuji = $isBuji == '0' ? '' : ($isBuji == '1' ? '被补寄订单' : '补寄产生新订单');
         //$isBuji					= isset ($sendreplacement[$isBuji]) ? $sendreplacement[$isBuji] : '';
         //$is_sendreplacement		= $isBuji;
         $isSplit = $orderData['isSplit'];
         //默认0正常订单;1为被拆分的订单;2为拆分产生的订单
         $isSplit = $isSplit == '0' ? '' : ($isSplit == '1' ? '被拆分订单' : '拆分产生新订单');
         //$ebay_splitorder
         $isCombinePackage = $orderData['combinePackage'];
         //是否合并包裹。合并包裹状态,0为正常订单;1为合并包裹主订单;2为合并包裹子订单
         $isCombinePackage = $isCombinePackage == '0' ? '' : ($isCombinePackage == '1' ? '合并包裹主订单' : '合并包裹子订单');
         $weighStaffId = isset($orderWhInfoData[0]['weighStaffId']) ? $orderWhInfoData[0]['weighStaffId'] : '';
         //扫描员ID//称重
         $weighStaff = $weighStaffId != '' ? $staffLists[$weighStaffId] : '';
         //扫描员
         $districtStaffId = isset($orderWhInfoData[0]['districtStaffId']) ? $orderWhInfoData[0]['districtStaffId'] : '';
         //分区人员ID
         $districtStaff = $districtStaffId != '' ? $staffLists[$districtStaffId] : '';
         //分区人员
         $OrderTransportId = $orderData['transportId'];
         //运输方式Id $transportId
         $carrierName = $carriers[$OrderTransportId];
         //运输方式名称 $ebay_carrier
         $address = $orderUserInfoStreet1 . "\n" . $orderUserInfoStreet2 . "\n" . $orderUserInfoCity . "\n" . $orderUserInfoState . "\n" . $orderUserInfoZip . "\n" . $orderUserInfoCountryName;
         //字段拼接成地址
         $orderWhInfoWeighTime = date('Y-m-d', $orderWhInfoData['weighTime']);
         //称重时间,亦可以当做发货时间 $scantime
         $OrderCalcWeight = $orderData['calcWeight'];
         //估算重量,单位是kg  $calculate_weight
         $orderWhInfoActualWeight = number_format($orderWhInfoData['actualWeight'] / 1000, 3);
         //实际重量 $orderweight2
         $totalweight = $orderWhInfoActualWeight;
         //总重量
         $mailway_c = $channels[$OrderChannelId];
         //根据运输管理系统的接口获取
         $isContainCombineSku = CommonModel::judge_contain_combinesku($orderId);
         //$ebay_combineorder 判断订单是否包含组合料号,返回true or false
         if (count($orderDetail) == 1) {
             //订单明细中只有一条记录时,订单中只有一种料号
             $orderDetailTotalData = array_pop($orderDetail);
             //取得orderDetail中的这条总记录数据,包括orderDetailData和orderDetailExtenData
             $orderDetailData = $orderDetailTotalData['orderDetailData'];
             //明细中的常用数据
             $orderDetailExtenData = $orderDetailTotalData['orderDetailExtenData'];
             //明细中的扩展数据
             $orderDetailSku = $orderDetailData['sku'];
             //该明细下的$sku
             $orderDetailExtenItemId = $orderDetailExtenData['itemId'];
             //itemId $ebay_itemid
             $orderDetailAmount = intval($orderDetailData['amount']);
             //$amount 该明细下的sku对应的数量
             $orderDetailRecordnumber = $orderDetailData['recordNumber'];
             //该明细对应平台的recordnumber $recordnumber
             $orderDetailItemPrice = round($orderDetailData['itemPrice'], 2) * $orderDetailAmount;
             //itemPrice(平台对应的销售单价)*对应数量 $ebay_itemprice
             //	$ebay_shipfee			=	round_num(($OrderActualTotal - $orderDetailItemPrice), 2);
             $ebay_shipfee = CommonModel::calcshippingfee($totalweight, $orderUserInfoCountryName, $OrderActualTotal, $OrderTransportId);
             //round_num(($OrderActualTotal - $orderDetailItemPrice), 2); //订单总价-sku对应的总价得出运费,$ebay_shipfee
             $ebay_shipfee = isset($ebay_shipfee['fee']) ? $ebay_shipfee['fee']['fee'] : '';
             $skus = GoodsModel::get_realskuinfo($orderDetailSku);
             //获取该sku下对应的真实料号信息(包括料号转换及组合料号对应真实料号信息)
             $values_skus = array_values($skus);
             //得到sku的数量
             $goods_location = CommonModel::getPositionBySku($orderDetailSku);
             //仓位
             $goodsInfo = GoodsModel::getSkuinfo($orderDetailSku);
             //获取真实sku的详细信息,包括采购名称和可用库存
             $goodsWeight = $goodsInfo['goodsWeight'];
             //料号重量
             $goods_cost = isset($goodsInfo['goodsCost']) ? round($goodsInfo['goodsCost'], 2) : 0;
             //采购成本
             $pmId = isset($goodsInfo['pmId']) ? $goodsInfo['pmId'] : '';
             //包材Id
             $ebay_packingmaterial = $packings[$pmId]['pmName'];
             //包材名称
             $ebay_packingCost = $packings[$pmId]['pmCost'];
             //包材成本
             $purchaseId = isset($goodsInfo['purchaseId']) ? $goodsInfo['purchaseId'] : '';
             $cguser = $staffLists[$purchaseId];
             //采购名称
             $combineSku = GoodsModel::getCombineSkuinfo($orderDetailSku);
             //判断该sku是否是组合料号,如果是返回combineSku,sku,count关系记录数据,不是则返回false
             if ($combineSku !== false) {
                 //为组合订单
                 $goods_costs = 0;
                 $combine_weight_list = array();
                 $goods_costs_list = array();
                 foreach ($skus as $k => $v) {
                     $goodsInfo2 = GoodsModel::getSkuinfo($k);
                     $combine_weight_list[$k] = $orderDetailAmount * $v * $goodsInfo2['goodsWeight'];
                     //组合订单重量数组
                     $goods_costs_list[$k] = $orderDetailAmount * $v * $goodsInfo2['goodsCost'];
                     //货本数组
                     $goods_costs += $orderDetailAmount * $v * $goodsInfo2['goodsCost'];
                 }
                 $row = array($orderWhInfoWeighTime, $accountName, $orderRecordnumber, $platformUsername, $goods_location, $orderDetailSku, $orderDetailAmount, $goodsWeight, $goods_cost, $orderUserInfoCountryName, $OrderActualTotal, $ebay_shipfee, $orderExtenCurrency, $carrierName, $mailway_c, '', validate_trackingnumber($orderTracknumberOne) ? '是' : '否', $totalweight, $username, $orderUserInfoPhone, $address, $orderUserInfoState, $orderUserInfoCity, $orderUserInfoZip, $orderId, $packinguser, '', $weighStaff, $districtStaff, '');
                 $excel->addRow($row);
                 foreach ($skus as $k => $v) {
                     $goodsInfo3 = GoodsModel::getSkuinfo($k);
                     $goods_cost = isset($goodsInfo3['goodsCost']) ? round($goodsInfo3['goodsCost'], 2) : 0;
                     $goods_weight = isset($goodsInfo3['goodsWeight']) ? $goodsInfo3['goodsWeight'] : 0;
                     $goods_location2 = CommonModel::getPositionBySku($k);
                     //仓位
                     $pmId = isset($goodsInfo3['pmId']) ? $goodsInfo3['pmId'] : '';
                     $ebay_packingmaterial = $packings[$pmId]['pmName'];
                     $ebay_packingCost = $packings[$pmId]['pmCost'];
                     $purchaseId = isset($goodsInfo3[0]['purchaseId']) ? $goodsInfo3[0]['purchaseId'] : '';
                     $cguser = $staffLists[$purchaseId];
                     $ishipfee = round_num($goods_costs_list[$k] / array_sum($goods_costs_list) * $ebay_shipfee, 2);
                     //根据货本比ebay运费
                     $iorderweight2 = round($combine_weight_list[$k] / array_sum($combine_weight_list) * $orderWhInfoActualWeight, 3);
                     $iordershipfee = round_num($combine_weight_list[$k] / array_sum($combine_weight_list) * $orderCalcShipping, 2);
                     $iprice = round_num(($goods_costs_list[$k] + $iordershipfee) / (array_sum($goods_costs_list) + $orderCalcShipping) * $ebay_itemprice, 2);
                     //根据货本比产品价格  last modified by herman.xi @20130916
                     $row = array('', '', '', '', $goods_location2, $k, $v, $goods_weight, $goods_cost, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
                     $excel->addRow($row);
                 }
             } else {
                 //非组合订单
                 $row = array($orderWhInfoWeighTime, $accountName, $orderRecordnumber, $platformUsername, $goods_location, $orderDetailSku, $orderDetailAmount, $goodsWeight, $goods_cost, $orderUserInfoCountryName, $OrderActualTotal, $ebay_shipfee, $orderExtenCurrency, $carrierName, $mailway_c, '', validate_trackingnumber($orderTracknumberOne) ? '是' : '否', $totalweight, $username, $orderUserInfoPhone, $address, $orderUserInfoState, $orderUserInfoCity, $orderUserInfoZip, $orderId, $packinguser, '', $weighStaff, $districtStaff, '');
                 $excel->addRow($row);
             }
             unset($combine_weight_list);
             unset($goods_costs_list);
         } else {
             //订单详细记录>1
             $cctotal = 0;
             $ebay_itemprice = 0;
             $goods_costs = 0;
             $goods_list = array();
             $goods_lists = array();
             $goods_weight_list = array();
             $goods_costs_list = array();
             $calculate_weight = 0;
             foreach ($orderDetail as $orderDetailTotalData) {
                 //$orderDetailTotalData ,包括orderDetailData和orderDetailExtenData
                 $orderDetailData = $orderDetailTotalData['orderDetailData'];
                 //明细中的常用数据
                 $orderDetailExtenData = $orderDetailTotalData['orderDetailExtenData'];
                 //明细中的扩展数据
                 $detail_id = $orderDetailData['id'];
                 $sku = $orderDetailData['sku'];
                 $skus = GoodsModel::get_realskuinfo($sku);
                 $_ebay_itemprice = round($orderDetailData['itemPrice'], 2);
                 $ebay_itemprice += $orderDetailData['amount'] * $_ebay_itemprice;
                 foreach ($skus as $k => $v) {
                     $goodsInfo3 = GoodsModel::getSkuinfo($k);
                     $_ebay_amount = intval($orderDetailData['amount'] * $v);
                     $cctotal += $_ebay_amount;
                     $calculate_weight += $_ebay_amount * $goodsInfo3['goodsWeight'];
                     $goods_weight_list[$detail_id . $sku][$k] = $_ebay_amount * $goodsInfo3['goodsWeight'];
                     $goods_costs_list[$detail_id . $sku][$k] = round($goodsInfo3['goodsCost'], 2) * $_ebay_amount;
                     $goods_costs += round($goodsInfo3['goodsCost'], 2) * $_ebay_amount;
                 }
             }
             //echo "---------$ebay_itemprice--------";
             $ebay_shipfee = CommonModel::calcshippingfee($totalweight, $orderUserInfoCountryName, $OrderActualTotal, $OrderTransportId);
             $ebay_shipfee = isset($ebay_shipfee['fee']) ? $ebay_shipfee['fee']['fee'] : '';
             //	$ebay_shipfee = round_num(($OrderActualTotal - $ebay_itemprice), 2);
             $row = array($orderWhInfoWeighTime, $accountName, $orderRecordnumber, $platformUsername, '', '', $cctotal, '', $ebay_itemprice, $orderUserInfoCountryName, $OrderActualTotal, $ebay_shipfee, $orderExtenCurrency, $carrierName, $mailway_c, '', validate_trackingnumber($orderTracknumberOne) ? '是' : '否', $totalweight, $username, $orderUserInfoPhone, $address, $orderUserInfoState, $orderUserInfoCity, $orderUserInfoZip, $orderId, $packinguser, '', $weighStaff, $districtStaff, '');
             $excel->addRow($row);
             foreach ($orderDetail as $orderDetailTotalData) {
                 //$orderDetailTotalData ,包括orderDetailData和orderDetailExtenData
                 $orderDetailData = $orderDetailTotalData['orderDetailData'];
                 //明细中的常用数据
                 $orderDetailExtenData = $orderDetailTotalData['orderDetailExtenData'];
                 //明细中的扩展数据
                 $detail_id = $orderDetailData['id'];
                 $skuDe = $orderDetailData['sku'];
                 $recordnumber = $orderDetailData['recordNumber'];
                 $orderDetailExtenItemId = $orderDetailExtenData['itemId'];
                 //itemId $ebay_itemid
                 //$ebay_itemid = $detail_array['ebay_itemid'];
                 $amount = intval($orderDetailData['amount']);
                 $dshipingfee = $orderDetailData['shippingFee'];
                 $debay_itemprice = round($orderDetailData['itemPrice'], 2);
                 $goods_location = CommonModel::getPositionBySku($skuDe);
                 $goodsInfo3 = GoodsModel::getSkuinfo($skuDe);
                 $goods_cost = isset($goodsInfo3['goodsCost']) ? round($goodsInfo3['goodsCost'], 2) : 0;
                 $pmId = isset($goodsInfo3['pmId']) ? $goodsInfo3['pmId'] : 0;
                 $ebay_packingmaterial = $packings[$pmId]['pmName'];
                 $ebay_packingCost = $packings[$pmId]['pmCost'];
                 $purchaseId = isset($goodsInfo3['purchaseId']) ? $goodsInfo3['purchaseId'] : '';
                 $cguser = $staffLists[$purchaseId];
                 $dordershipfee = round($orderCalcShipping * (array_sum($goods_weight_list[$detail_id . $skuDe]) / $calculate_weight), 2);
                 $dorderweight2 = round($orderWhInfoActualWeight * (array_sum($goods_weight_list[$detail_id . $skuDe]) / $calculate_weight), 3);
                 $combineSku = GoodsModel::getCombineSkuinfo($skuDe);
                 //$is_combineSku = count($combineSku);
                 if ($combineSku !== false) {
                     //为组合料号
                     $skus = GoodsModel::get_realskuinfo($skuDe);
                     foreach ($skus as $k => $v) {
                         $goods_location = CommonModel::getPositionBySku($k);
                         $goodsInfo3 = GoodsModel::getSkuinfo($k);
                         $goods_cost = isset($goodsInfo3['goodsCost']) ? round($goodsInfo3['goodsCost'], 2) : 0;
                         $goods_weight = isset($goodsInfo3['goodsWeight']) ? $goodsInfo3['goodsWeight'] : 0;
                         $pmId = isset($goodsInfo3['pmId']) ? $goodsInfo3['pmId'] : '';
                         $ebay_packingmaterial = $packings[$pmId]['pmName'];
                         $ebay_packingCost = $packings[$pmId]['pmCost'];
                         $purchaseId = isset($goodsInfo3['purchaseId']) ? $goodsInfo3['purchaseId'] : '';
                         $cguser = $staffLists[$purchaseId];
                         //$iprice = round_num(($goods_costs_list[$detail_id.$k][$k]/array_sum($goods_costs_list[$detail_id.$k])) * $debay_itemprice * $amount,2); //根据货本比产品价格
                         $ishipfee = round_num($goods_costs_list[$detail_id . $skuDe][$k] / array_sum($goods_costs_list[$detail_id . $skuDe]) * $dshipingfee, 2);
                         //根据货本比ebay运费
                         $iorderweight2 = round($goods_weight_list[$detail_id . $skuDe][$k] / array_sum($goods_weight_list[$detail_id . $skuDe]) * $dorderweight2, 3);
                         $iordershipfee = round_num($goods_weight_list[$detail_id . $skuDe][$k] / array_sum($goods_weight_list[$detail_id . $skuDe]) * $dordershipfee, 2);
                         $iprice = round_num(($goods_costs_list[$detail_id . $skuDe][$k] + $iordershipfee) / (array_sum($goods_costs_list[$detail_id . $skuDe]) + $dordershipfee) * $debay_itemprice * $amount, 2);
                         //根据货本比产品价格  last modified by herman.xi @20130916
                         $row = array('', '', '', '', $goods_location, $k, $v, $goods_weight, $goods_cost, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
                         $excel->addRow($row);
                     }
                 } else {
                     $goods_location = CommonModel::getPositionBySku($skuDe);
                     $goodsInfo3 = GoodsModel::getSkuinfo($skuDe);
                     $goods_cost = isset($goodsInfo3['goodsCost']) ? round($goodsInfo3['goodsCost'], 2) : 0;
                     $goods_weight = isset($goodsInfo3['goodsWeight']) ? $goodsInfo3['goodsWeight'] : 0;
                     $row = array('', '', '', '', $goods_location, $skuDe, $amount, $goods_weight, $goods_cost, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
                     $excel->addRow($row);
                 }
             }
             unset($goods_weight_list);
             unset($goods_costs_list);
         }
     }
     $excel->finalize();
     exit;
 }
 public function view_dresslinkOrderImport()
 {
     include_once WEB_PATH . "lib/PHPExcel.php";
     //phpexcel
     include_once WEB_PATH . "conf/scripts/script.ebay.config.php";
     $toptitle = 'dresslink线下订单导入';
     //头部title
     $this->smarty->assign('toptitle', $toptitle);
     $this->smarty->assign('toplevel', 2);
     $this->smarty->assign('secondlevel', 210);
     $OmAccountAct = new OmAccountAct();
     $dresslinkAccountList = $OmAccountAct->act_dresslinkaccountAllList();
     //$dresslinkAccountList = array(array('id'=>8,'account'=>'dresslink.com'),array('id'=>10,'account'=>'cndirect.com'));
     $this->smarty->assign("dresslinkAccountList", $dresslinkAccountList);
     if (isset($_FILES['cndlFile']['tmp_name']) && isset($_POST['cndlAccount'])) {
         $filePath = $_FILES['cndlFile']['tmp_name'];
         $account = $_POST['cndlAccount'];
         $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);
         $allRow = $currentSheet->getHighestRow();
         /**从第二行开始输出,因为excel表中第一行为列名*/
         /**取得最大的列号*/
         $allColumn = $currentSheet->getHighestColumn();
         $orderData = array();
         $cndlAccounts = array();
         $transportation = CommonModel::getCarrierList();
         //所有的
         $transportationList = array();
         foreach ($transportation as $tranValue) {
             $transportationList[$tranValue['id']] = $tranValue['carrierNameCn'];
         }
         //账号对应
         foreach ($dresslinkAccountList as $accounts) {
             $cndlAccounts[$accounts['id']] = $accounts['account'];
         }
         $c = 2;
         $dresslinks = array();
         $ebay_fedex_remark = array();
         $ChineseDescs = array();
         for ($c = 2; $c <= $allRow; $c++) {
             $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());
             //订单号
             $recordNumber = $recordnumber;
             $is_order = intval($currentSheet->getCell($bb)->getValue());
             //1代表为订单,0代表订单明细
             if (empty($recordnumber)) {
                 $message .= "<font color=red> 第{$c}行recordnumber为空!</font><br>";
                 break;
             }
             /***************判断订单是否已存在***************/
             $where = "where recordnumber='{$recordnumber}'";
             $orderinfo = cndlModel::selectOrder($where);
             if ($orderinfo) {
                 if ($is_order != 0) {
                     $message .= "<font color='blue'>订单 {$recordnumber}已存在!</font><br>";
                 }
                 continue;
             }
             /**************/
             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 == "dresslink.com") {
                     $feedback = mysql_real_escape_string(trim($currentSheet->getCell($ann)->getValue()));
                 } elseif ($account == "cndirect.com") {
                     $feedback = mysql_real_escape_string(trim($currentSheet->getCell($akk)->getValue()));
                 }
                 $carrierNameCn = strtolower(mysql_real_escape_string(trim($currentSheet->getCell($kk)->getValue())));
                 $carrierNameCn = cndlModel::carrier($carrierNameCn);
                 $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['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;
                 /***************BEGIN 订单表数据***************/
                 $orderData[$recordNumber]['orderData']['recordNumber'] = $recordnumber;
                 if ($cndlAccounts[$account] == "dresslink.com") {
                     $orderData[$recordNumber]['orderData']['platformId'] = 10;
                     $orderData[$recordNumber]['orderData']['accountId'] = $account;
                 } elseif ($cndlAccounts[$account] == "cndirect.com") {
                     $orderData[$recordNumber]['orderData']['platformId'] = 8;
                     $orderData[$recordNumber]['orderData']['accountId'] = $account;
                 }
                 $orderData[$recordNumber]['orderData']['orderStatus'] = C('STATEPENDING');
                 $orderData[$recordNumber]['orderData']['orderType'] = C('STATEPENDING_INITIAL');
                 $orderData[$recordNumber]['orderData']['ordersTime'] = strtotime($ordersTime['date']);
                 //平台下单时间
                 $orderData[$recordNumber]['orderData']['paymentTime'] = strtotime($paymentTime['date']);
                 $orderData[$recordNumber]['orderData']['onlineTotal'] = $onlineTotal;
                 //线上总金额
                 $orderData[$recordNumber]['orderData']['actualTotal'] = $actualTotal;
                 //付款总金额
                 $orderData[$recordNumber]['orderData']['isFixed'] = 1;
                 $orderData[$recordNumber]['orderData']['calcShipping'] = $shippingFee;
                 //物流费用
                 $orderData[$recordNumber]['orderData']['orderAddTime'] = time();
                 $orderData[$recordNumber]['orderData']['isNote'] = empty($note) ? 0 : 1;
                 foreach ($transportation as $tranValue) {
                     if ($tranValue['carrierNameCn'] == $carrierNameCn) {
                         $orderData[$recordNumber]['orderData']['transportId'] = $tranValue['id'];
                         //运输方式id
                         break;
                     }
                 }
                 /***************END 订单表数据***************/
                 /***************BEGIN 订单扩展表数据***************/
                 $orderData[$recordNumber]['orderExtenData']['paymentStatus'] = "Complete";
                 $orderData[$recordNumber]['orderExtenData']['transId'] = $transId;
                 $orderData[$recordNumber]['orderExtenData']['PayPalPaymentId'] = $PayPalPaymentId;
                 $orderData[$recordNumber]['orderExtenData']['paymentMethod'] = $payment_method;
                 $orderData[$recordNumber]['orderExtenData']['paymentModule'] = $payment_module;
                 $orderData[$recordNumber]['orderExtenData']['shippingMethod'] = $shipping_method;
                 $orderData[$recordNumber]['orderExtenData']['ShippingModule'] = $shipping_module;
                 $orderData[$recordNumber]['orderExtenData']['currency'] = $currency;
                 $orderData[$recordNumber]['orderExtenData']['feedback'] = $feedback;
                 //客户留言
                 /***************END 订单扩展表数据***************/
                 /***************BEGIN 订单用户表数据***************/
                 $orderData[$recordNumber]['orderUserInfoData']['username'] = $username;
                 $orderData[$recordNumber]['orderUserInfoData']['platformUsername'] = $platformUsername;
                 $orderData[$recordNumber]['orderUserInfoData']['email'] = $email;
                 $orderData[$recordNumber]['orderUserInfoData']['countryName'] = $countryName;
                 $orderData[$recordNumber]['orderUserInfoData']['currency'] = $currency;
                 $orderData[$recordNumber]['orderUserInfoData']['state'] = $state;
                 // 省
                 $orderData[$recordNumber]['orderUserInfoData']['city'] = $city;
                 // 市
                 $orderData[$recordNumber]['orderUserInfoData']['street'] = $street;
                 $orderData[$recordNumber]['orderUserInfoData']['address2'] = $address2;
                 $orderData[$recordNumber]['orderUserInfoData']['landline'] = $landline;
                 // 座机电话
                 $orderData[$recordNumber]['orderUserInfoData']['phone'] = $phone;
                 // 手机
                 $orderData[$recordNumber]['orderUserInfoData']['zipCode'] = $zipCode;
                 // 邮编
                 /*************END 订单用户表数据***************/
                 //note信息
                 if (!empty($note)) {
                     $orderData[$recordNumber]['orderNote'][$c]['content'] = $note;
                     $orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId'];
                 }
             } 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]['orderDetailData']['recordNumber'] = $recordnumber;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']['sku'] = $sku;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']['itemPrice'] = $itemPrice;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']['amount'] = $amount;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']["shippingFee"] = $shipingfee;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']['createdTime'] = time();
                 /*************END 订单详细数据***************/
                 /***************BEGIN 订单详细扩展表数据***************/
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetailExtenData']['itemTitle'] = $itemTitle;
                 $orderData[$recordNumber]['orderDetail'][$c]['orderDetailExtenData']['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];
                 $orderData[$recordNumber]['dresslinkInfo'] = $dresslinks;
                 $ChineseDescs[$recordNumber][$categoryName] = $ChineseDesc;
             }
         }
         if ($orderData) {
             foreach ($orderData as $id => $order) {
                 $msg = commonModel::checkOrder($id);
                 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[$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'];
                 $ChineseDescs_arr = array_filter(array_unique($ChineseDescs[$id]));
                 $orderData[$id]['orderNote'] = array('content' => join(' ', $ChineseDescs_arr), 'userId' => $_SESSION['sysUserId'], 'createdTime' => time());
                 /*//缺货拦截
                 		$orderData[$id] = AutoModel :: auto_contrast_intercept($orderData[$id]);
                 		//$orderData[$id] = cndlModel :: auto_contrast_intercept($orderData[$id]);*/
                 //插入订单OrderAddModel::insertAllOrderRow($orderData[$id],'cndl');
                 //调用旧系统接口,先插入数据到旧系统
                 //echo "<pre>"; var_dump($orderData[$id]); exit;
                 $rtn = OldsystemModel::orderErpInsertorder($orderData[$id]);
                 //echo "<pre>";print_r($rtn);exit;
                 $insertData = array();
                 if (empty($rtn)) {
                     $message .= "<font color='red'>订单{$id}同步ERP发生异常,跳过!</font><br>";
                     continue;
                 }
                 if ($rtn['errcode'] == 200) {
                     $rtn_data = $rtn['data'];
                     $orderId = $rtn_data['orderId'];
                     $message .= "<font color='green'>插入老系统成功,订单编号 [{$orderId}]</font><br>";
                     $pmId = $rtn_data['pmId'];
                     $totalweight = $rtn_data['totalweight'];
                     $shipfee = $rtn_data['shipfee'];
                     $carrier = $rtn_data['carrier'];
                     $carrierId = $rtn_data['carrierId'];
                     $status = $rtn_data['status'];
                     $orderData[$id]['orderData']['id'] = $orderId;
                     //赋予新系统订单编号,一切数据已老系统返回的为准
                     if ($orderData[$id]['orderData']['calcWeight'] != $totalweight) {
                         $insertData['old_totalweight'] = $totalweight;
                         $insertData['new_totalweight'] = $orderData[$id]['orderData']['calcWeight'];
                         $orderData[$id]['orderData']['calcWeight'] = $totalweight;
                     }
                     if ($orderData[$id]['orderData']['pmId'] != $pmId) {
                         $insertData['old_pmId'] = $pmId;
                         $insertData['new_pmId'] = $orderData[$id]['orderData']['pmId'];
                         $orderData[$id]['orderData']['pmId'] = $pmId;
                     }
                     if ($orderData[$id]['orderData']['calcShipping'] != $shipfee) {
                         $insertData['old_shippfee'] = $shipfee;
                         $insertData['new_shippfee'] = $orderData[$id]['orderData']['calcShipping'];
                         $orderData[$id]['orderData']['calcShipping'] = $shipfee;
                     }
                     if ($orderData[$id]['orderData']['transportId'] != $carrierId) {
                         $insertData['old_carrierId'] = $carrierId;
                         $insertData['new_carrierId'] = $orderData[$id]['orderData']['transportId'];
                         $orderData[$id]['orderData']['transportId'] = $carrierId;
                     }
                     if (!empty($insertData)) {
                         $insertData['ebay_id'] = $orderId;
                         $insertData['addtime'] = time();
                         OldsystemModel::insertTempSyncRecords($insertData);
                         // 插入临时对比记录表
                     }
                     //缺货拦截
                     $orderData[$id] = AutoModel::auto_contrast_intercept($orderData[$id]);
                     //插入订单
                     $info = OrderAddModel::insertAllOrderRowNoEvent($orderData[$id]);
                     if ($info) {
                         $dresslinkinfos = $orderData[$id]['dresslinkInfo'];
                         $dresslinkinfos['omOrderId'] = $orderId;
                         if (DresslinkinfoModel::insertDresslinkinfoList($dresslinkinfos)) {
                             $message .= "<font color='green'>订单{$id}上传dresslinkInfo成功!</font><br>";
                         } else {
                             $message .= "<font color='red'>订单{$id}上传dresslinkInfo失败!</font><br>";
                         }
                         $message .= "<font color='green'>新系统订单{$id}添加成功!</font><br>";
                     } else {
                         $message .= "<font color='red'>新系统订单{$id}添加失败!</font><br>";
                     }
                 } else {
                     $message .= "<font color='red'>添加失败,原因为:{$rtn['msg']}!</font><br>";
                 }
                 if ($orderId) {
                     foreach ($ebay_fedex_remark[$id] as $k => $v) {
                         $fedex_remark = array();
                         $fedex_remark['description'] = trim("[No Brand]" . $k . "{$v[0]['detail']}");
                         if (in_array($transportationList[$order['orderData']['transportId']], array('FedEx'))) {
                             //$fedex_remark['description'] = "[No Brand]". $k."({$v[0]['detail']})";
                             $fedex_remark['type'] = 1;
                         } else {
                             if (in_array($transportationList[$order['orderData']['transportId']], array('DHL', 'EMS', 'UPS美国专线'))) {
                                 //$fedex_remark['description'] = trim($k);
                                 $fedex_remark['type'] = 2;
                             } else {
                                 continue;
                             }
                         }
                         $sku_price = 0;
                         $qty = 0;
                         foreach ($v as $v0) {
                             $sku_price += $v0['real_price'];
                             $qty += $v0['qty'];
                         }
                         //$fedex_remark['ebay_ordersn'] 	= $order['ebay_ordersn'];
                         $fedex_remark['price'] = round($sku_price / $qty, 2);
                         $fedex_remark['amount'] = $qty;
                         $fedex_remark['hamcodes'] = $v[0]['hamcodes'];
                         if (in_array($transportationList[$order['orderData']['transportId']], array('DHL', 'EMS', 'UPS美国专线'))) {
                             $fedex_remark['price'] = round($sku_price, 2);
                         }
                         $fedex_remark['createdTime'] = time();
                         $fedex_remark['omOrderId'] = $orderId;
                         $fedex_remark['creatorId'] = $_SESSION['sysUserId'];
                         //$insert_fedex_sql = "INSERT INTO fedex_remark set ".array2sql($fedex_remark);
                         $info = OmAvailableModel::insertRow("om_express_remark", " set " . array2sql_bak($fedex_remark));
                         if ($info) {
                             $message .= "<font color=green> {$id} 导入海关记录成功!</font><br>";
                             //echo "----<font color=green> {$order['recordnumber']} 导入海关记录成功!</font><br>";
                         } else {
                             //echo $insert_fedex_sql; echo "<br>";
                             $message .= "<font color=green> {$id} 导入海关记录失败!</font><br>";
                             //echo "----<font color=red>{$order['recordnumber']} 导入海关记录失败!</font><br>";
                             //$fail_order[] = $order['orderData']['recordnumber'];
                         }
                     }
                 }
             }
         }
         $this->smarty->assign("showerrorinfo", $message);
     }
     $this->smarty->display('dresslinkOrderImport.htm');
 }
Esempio n. 8
0
function excel2array($PHPExcel, $filename, $rownums = 0, $num = 2)
{
    $Worksheet = $PHPExcel->getActiveSheet();
    $highestRow = $Worksheet->getHighestRow();
    $highestColumn = $Worksheet->getHighestColumn();
    $highestColumnIndex = empty($rownums) ? PHPExcel_Cell::columnIndexFromString($highestColumn) : $rownums;
    $excelData = array();
    for ($row = 1; $row <= $highestRow; $row++) {
        for ($col = 0; $col < $highestColumnIndex; $col++) {
            if ($highestColumnIndex > 100) {
                break;
            }
            $value = $Worksheet->getCellByColumnAndRow($col, $row)->getValue();
            if ($value instanceof PHPExcel_RichText) {
                $value = $Worksheet->getCellByColumnAndRow($col, $row)->getValue()->getPlainText();
            }
            if (preg_match("/^[0-9]+\\.[0-9]+\$/", $value)) {
                $value = empty($num) ? $value : round_num($value, $num);
            }
            $excelData[$row][] = $value;
        }
    }
    return $excelData;
}
Esempio n. 9
0
         echo "</tr>\n</table>\n</form>\n";
     }
 }
 ## Forum Stats
 if ($settings['forum_profile_statistics']) {
     list($name, $posts, $age) = dbarraynum(dbquery("SELECT user_name, user_posts, user_joined FROM " . DB_USERS . " WHERE user_id=" . (int) $_GET['lookup']));
     $posts = empty($posts) ? 0 : $posts;
     list($threads) = dbarraynum(dbquery("SELECT COUNT(thread_id) FROM " . DB_THREADS . " WHERE thread_author=" . (int) $_GET['lookup']));
     $threads = empty($threads) ? 0 : $threads;
     $threadspday = round_num($threads / ((time() - $age) / (3600 * 24)));
     $postspday = round_num($posts / ((time() - $age) / (3600 * 24)));
     list($ranked_higher) = dbarraynum(dbquery("SELECT COUNT(user_id) FROM " . DB_USERS . " WHERE user_posts>" . $posts));
     $rank = $ranked_higher + 1;
     list($allposts) = dbarraynum(dbquery("SELECT SUM(forum_postcount) FROM " . DB_FORUMS));
     $percentage = empty($posts) || empty($allposts) ? 0 : $posts * 100.0 / $allposts;
     $percentage = round_num($percentage);
     closetable();
     opentable(sprintf($locale['forum_ext_title_profile'], $name));
     echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n\t<tr>\r\n\t\t\t\t\t<th class='forum-caption' width='1%' style='white-space: nowrap;' rowspan='2'><img alt='" . $locale['forum_ext_stats'] . "' src='" . IMAGES . "forum/forum_stats.png' /></th>\r\n\t\t\t\t\t<td class='tbl1'>\r\n\t\t\t\t\t\t" . number_format($threads) . " " . $locale['forum_ext_threads'] . " ::\r\n\t\t\t\t\t\t" . number_format($posts) . " " . $locale['forum_ext_posts'] . " ::\r\n\t\t\t\t\t\t" . $threadspday . " " . $locale['forum_ext_threadspday'] . " ::\r\n\t\t\t\t\t\t" . $postspday . " " . $locale['forum_ext_postspday'] . "\r\n\t\t\t\t\t</td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td class='tbl1'>\r\n\t\t\t\t\t\t" . sprintf($locale['forum_ext_ranking'], $name, number_format($rank), $percentage) . "\r\n\t\t\t\t\t</td>\r\n\t\t\t\t</tr>\r\n\t\t\t</table>";
     foreach (array("threads", "posts") as $type) {
         $other_type = $type == "threads" ? "posts" : "threads";
         if ($type == "threads") {
             if (!isset($_GET['show']) || isset($_GET['show']) && $_GET['show'] != "posts") {
                 $visibility = "";
             } else {
                 $visibility = "style='display: none;'";
             }
         } else {
             if (isset($_GET['show']) && $_GET['show'] == "posts") {
                 $visibility = "";
             } else {
Esempio n. 10
0
 function act_searchPartionInfo($orderid)
 {
     $name = "wh_order_partion_records as a left join wh_order_partion_print as b on a.packageId=b.id";
     $where = "where a.shipOrderId='{$orderid}' and a.is_delete=0";
     $list = OmAvailableModel::getTNameList($name, "a.*,b.totalWeight,b.totalNum,b.status", $where);
     if (empty($list)) {
         return "订单号{$orderid}没有分区扫描记录!";
     } else {
         $show = '';
         foreach ($list as $value) {
             $pack_status = $value['status'] == 1 ? '已打包' : '未打包';
             if (empty($value['scanUserId'])) {
                 $op_name = '无';
             } else {
                 //配货人
                 $usermodel = UserModel::getInstance();
                 $iqc_user = $usermodel->getGlobalUserLists('global_user_name', "where a.global_user_id={$value['scanUserId']}", '', '');
                 $op_name = $iqc_user[0]['global_user_name'];
             }
             $scantime = $value['scanTime'] ? date('Y-m-d H:i:s', $value['scanTime']) : ' 无 ';
             $weight = round_num($value['totalWeight'] / 1000, 3);
             $show .= "订单号{$orderid} &nbsp;&nbsp; 扫描用户 > {$op_name} &nbsp;&nbsp; 所属包裹> {$value['packageId']}  &nbsp;&nbsp; 所属分区 > {$value['partionId']} &nbsp;&nbsp; 包裹打包状态 > {$pack_status} &nbsp;&nbsp; 包裹总重 > {$weight}&nbsp;&nbsp; 包裹总数量 > {$value['totalNum']} &nbsp;&nbsp; 订单扫描日期 > {$scantime}<br>";
         }
         return $show;
     }
 }
Esempio n. 11
0
 /**
  * ebay销售漏扫描报表导出
  * @author zqt
  */
 public function act_ebayNoScanOutputOn()
 {
     $start = strtotime($_POST['ebayNoScanStart']);
     $end = strtotime($_POST['ebayNoScanEnd']);
     $accountIdArr = $_POST['ebayNoScanAccount'];
     if (empty($accountIdArr)) {
         $statusStr = '账号为空,请选择!';
         echo '<script language="javascript">
                 alert("' . $statusStr . '");
                 history.back();
               </script>';
         exit;
     }
     if ($start > $end) {
         $statusStr = '起始时间大于结束时间,错误!';
         echo '<script language="javascript">
                 alert("' . $statusStr . '");
                 history.back();
               </script>';
         exit;
     }
     $packinglists = M('interfacePc')->getMaterList();
     // 获取全部包材记录
     foreach ($packinglists as $packinglist) {
         $packings[$packinglist['id']]['pmName'] = $packinglist['pmName'];
         $packings[$packinglist['id']]['pmCost'] = $packinglist['pmCost'];
     }
     unset($packinglists);
     $carrierLists = M('InterfaceTran')->getCarrierList(2);
     //获取所有的运输方式
     foreach ($carrierLists as $carrierList) {
         $carriers[$carrierList['id']] = $carrierList['carrierNameCn'];
     }
     unset($carrierLists);
     $channelLists = M('InterfaceTran')->getChannelList();
     //获取全部运输方式下的渠道记录
     foreach ($channelLists as $channelList) {
         $channels[$channelList['id']] = $channelList['channelName'];
     }
     unset($channelLists);
     $staffLists = array();
     //$staffInfoLists = CommonModel::getStaffInfoList (); // 获取全部人员,这里要换成接口,
     //        foreach ( $staffInfoLists as $staffInfoList ) {
     //            $staffLists [$staffInfoList ['global_user_id']] = $staffInfoList ['global_user_name'];
     //        }
     //        unset($staffInfoLists);
     $table = 'unshipped';
     //查询的是未发货还是发货,发货为shipped,这里默认为unshipped
     $orderIdsSTList = M('Order')->getOrderWarehouseOmorderIdsByWeighTime($table, $start, $end);
     $tmpIdsArr = array();
     foreach ($orderIdsSTList as $value) {
         $tmpIdsArr[] = $value['omOrderId'];
     }
     $tmpIdsStr = !empty($tmpIdsArr) ? implode(',', $tmpIdsArr) : '0';
     $orderStatusStr = '2';
     $accountIdStr = implode(',', $accountIdArr);
     $orderIdsISAList = M('Order')->getOrderIdsByISA($table, $tmpIdsStr, $orderStatusStr, $accountIdStr);
     //var_dump(M('Order')->getAllRunSql(), $orderIdsISAList);exit;
     $tmpIdsArr = array();
     $tmpIdsArr[] = 0;
     foreach ($orderIdsISAList as $value) {
         $tmpIdsArr[] = $value['id'];
     }
     $shipOrderList = M('Order')->getFullUnshippedOrderById($tmpIdsArr);
     print_r(M('Order')->getAllRunSql());
     //exit;
     print_r($shipOrderList);
     exit;
     F('order');
     $fileName = "export_ebay_test_" . date("Y-m-d_H_i_s") . ".xls";
     $excel = new ExportDataExcel('browser', $fileName);
     $excel->initialize();
     $excel->addRow(array('付款日期', 'ebay store', '交易号', '客户ID', '仓位号', '料号', '数量', '国家', '产品价格', 'ebay运费', '包裹总价值', '币种', '包装员', '挂号条码', '是/否', '重量', '邮费', '运输方式', '订单编号', '产品货本', '交易ID', 'ItemID', '是否复制订单', '是否补寄', '是否拆分订单', '包材', '包材费用', '是否组合料号', '扫描日期', '采购'));
     foreach ($shipOrderList as $key => $value) {
         // key代表最外层的维数
         /*
          * $value分别有7个对应的键,分别为 orderData,//订单表头数据记录 orderExtenData,//订单表扩展数据记录 orderUserInfoData,//订单表中客户的数据记录 orderWhInfoData,//物料对订单进行操作的数据记录 orderNote,//订单的备注(销售人员添加)记录 orderTracknumber,//订单的追踪号记录 orderAudit,//订单明细审核记录 orderDetail //订单明细记录
          */
         $orderData = $value['order'];
         // 订单表头数据记录,为一维数组
         $orderExtenData = $value['orderExtension'];
         // 扩展表头数据记录,为一维数组
         $orderUserInfoData = $value['orderUserInfo'];
         // 订单客户数据记录,为一维数组
         $orderWhInfoData = $value['orderWarehouse'];
         // 物料对订单进行操作的数据记录,为一维数组
         $orderNote = $value['orderNote'];
         // 订单备注记录,二维数组
         $orderTracknumber = $value['orderTracknumber'];
         // 订单跟踪号,二维数组
         //$orderAudit = $value ['orderAudit']; // 订单明细审核记录,二维数组
         $orderDetail = $value['orderDetail'];
         // 订单明细记录,三维数组
         $orderId = $orderData['id'];
         // ****订单编号 $ebay_id
         $orderPaidtime = @date('Y-m-d', $orderData['paymentTime']);
         // ****订单付款时间 paidtime
         $orderUserInfoEmail = $orderUserInfoData['email'];
         // ****客户邮箱 emial
         $platformUsername = $orderExtenData['platformUsername'];
         // ****客户平台登录名称 $ebay_userid,用扩展表中的该字段 ebay_username
         $username = @html_entity_decode($orderUserInfoData['username'], ENT_QUOTES, 'UTF-8');
         // ****客户真实名称(收件人) username
         $orderUserInfoStreet1 = @$orderUserInfoData['street'];
         // **** 街道地址 street1
         $orderUserInfoStreet2 = @$orderUserInfoData['address2'];
         // *** 街道地址2 steet2(一般订单会有两个街道地址)
         $orderUserInfoCity = $orderUserInfoData['city'];
         // **** 市 city
         $orderUserInfoState = $orderUserInfoData['state'];
         // **** 州 state
         $orderUserInfoCountryName = $orderUserInfoData['countryName'];
         // **** 国家全名
         // 客服部小霞提出 导出列 国家 显示英文 方便退款处理
         // $cnname = $country[$countryname];
         $orderUserInfoZip = $orderUserInfoData['zipCode'];
         // **** 邮编 zipCode
         $orderUserInfoTel = $orderUserInfoData['landline'];
         // **** 座机 landline
         $orderWhInfoActualShipping = $orderWhInfoData['actualShipping'];
         // ****实际运费,warehouse表中,ebay_shipfee
         $orderExtenFeedback = $orderExtenData['feedback'];
         // ****客户留言 ebay_note
         $OrderActualTotal = @round($orderData['actualTotal'], 2);
         // ****实际收款总价 $ebay_total
         $orderTracknumberOne = @$orderTracknumber[0]['tracknumber'];
         // ****追踪号,这里只读取记录数的第一条记录的追踪号 $ebay_tracknumber
         $accountName = @get_accountnamebyid($orderData['accountId']);
         // ****账号名称 $ebay_account
         $orderRecordnumber = @$orderData['recordNumber'];
         // ****订单编码(对应平台上的编码) $recordnumber0
         // $ebay_carrier = @$shipOrder['transportId'];//transportId ebay_carrier
         $orderUserInfoPhone = $orderUserInfoData['phone'];
         // ****客户手机号码 $ebay_phone
         $orderExtenCurrency = $orderExtenData['currency'];
         // ****币种 $ebay_currency
         $orderWhInfoPackersId = $orderWhInfoData['packersId'];
         // 包装人员Id
         $packinguser = $staffLists[$orderWhInfoPackersId];
         // 对应包装人员姓名
         // var_dump($packinguser);
         $OrderChannelId = $orderData['channelId'];
         // 渠道Id $channelId
         $orderCalcShipping = $orderData['calcShipping'];
         // 估算运费 $ordershipfee
         $orderExtenPayPalPaymentId = $orderExtenData['PayPalPaymentId'];
         // Paypal付款ID $ebay_ptid
         $orderExtenPayPalEmailAddress = $orderExtenData['PayPalEmailAddress'];
         // PayPal付款邮箱地址 $ebay_pp
         $isCopy = $orderData['isCopy'];
         // 默认为0为原始订单,1为被复制订单,2为复制订单
         $isCopy = $isCopy == '0' ? '' : ($isCopy == '1' ? '被复制订单' : '复制订单');
         // $ebay_noteb = $is_main_order==2 ? '复制 订单' : ($is_main_order==1 ? '被复制 订单' : '');
         $isBuji = $orderData['isBuji'];
         // 是否补寄订单。默认0正常订单;1为被补寄的订单;2为补寄产生的新订单
         $isBuji = $isBuji == '0' ? '' : ($isBuji == '1' ? '被补寄订单' : '补寄产生新订单');
         // $isBuji = isset ($sendreplacement[$isBuji]) ? $sendreplacement[$isBuji] : '';
         // $is_sendreplacement = $isBuji;
         $isSplit = $orderData['isSplit'];
         // 默认0正常订单;1为被拆分的订单;2为拆分产生的订单
         $isSplit = $isSplit == '0' ? '' : ($isSplit == '1' ? '被拆分订单' : '拆分产生新订单');
         // $ebay_splitorder
         $isCombinePackage = $orderData['combinePackage'];
         // 是否合并包裹。合并包裹状态,0为正常订单;1为合并包裹主订单;2为合并包裹子订单
         $isCombinePackage = $isCombinePackage == '0' ? '' : ($isCombinePackage == '1' ? '合并包裹主订单' : '合并包裹子订单');
         $OrderTransportId = $orderData['transportId'];
         // 运输方式Id $transportId
         $carrierName = $carriers[$OrderTransportId];
         // 运输方式名称 $ebay_carrier
         $address = $orderUserInfoStreet1 . "\n" . $orderUserInfoStreet2 . "\n" . $orderUserInfoCity . "\n" . $orderUserInfoState . "\n" . $orderUserInfoZip . "\n" . $orderUserInfoCountryName;
         // 字段拼接成地址
         $orderWhInfoWeighTime = date('Y-m-d', $orderWhInfoData['weighTime']);
         // 称重时间,亦可以当做发货时间 $scantime
         $OrderCalcWeight = $orderData['calcWeight'];
         // 估算重量,单位是kg $calculate_weight
         $orderWhInfoActualWeight = number_format($orderWhInfoData['actualWeight'] / 1000, 3);
         // 实际重量 $orderweight2
         $totalweight = $orderWhInfoActualWeight;
         // 总重量
         $mailway_c = $channels[$OrderChannelId];
         // 根据运输管理系统的接口获取
         //$isContainCombineSku = CommonModel::judge_contain_combinesku ( $orderId ); // $ebay_combineorder 判断订单是否包含组合料号,返回true or false
         $isContainCombineSku = false;
         //默认订单不含虚拟料号
         foreach ($orderDetail as $value) {
             if (get_isCombineSku($value['orderDetail']['sku'])) {
                 $isContainCombineSku = true;
                 break;
             }
         }
         if (count($orderDetail) == 1) {
             // 订单明细中只有一条记录时,订单中只有一种料号
             $orderDetailTotalData = array_pop($orderDetail);
             // 取得orderDetail中的这条总记录数据,包括orderDetailData和orderDetailExtenData
             $orderDetailData = $orderDetailTotalData['orderDetail'];
             // 明细中的常用数据
             $orderDetailExtenData = $orderDetailTotalData['orderDetailExtension'];
             // 明细中的扩展数据
             $orderDetailSku = $orderDetailData['sku'];
             // 该明细下的$sku
             $orderDetailExtenItemId = $orderDetailExtenData['itemId'];
             // itemId $ebay_itemid
             $orderDetailAmount = intval($orderDetailData['amount']);
             // $amount 该明细下的sku对应的数量
             $orderDetailRecordnumber = $orderDetailData['recordNumber'];
             // 该明细对应平台的recordnumber $recordnumber
             $orderDetailStoreId = $orderDetailData['storeId'];
             //料号所在仓库id
             $orderDetailItemPrice = round($orderDetailData['itemPrice'], 2) * $orderDetailAmount;
             // itemPrice(平台对应的销售单价)*对应数量 $ebay_itemprice
             $ebay_shipfee = round_num($OrderActualTotal - $orderDetailItemPrice, 2);
             // 订单总价-sku对应的总价得出运费,$ebay_shipfee
             //$skus = GoodsModel::get_realskuinfo ( $orderDetailSku ); // 获取该sku下对应的真实料号信息(包括料号转换及组合料号对应真实料号信息)
             $skus = get_realskuinfo($orderDetailSku);
             // 获取该sku下对应的真实料号信息(包括料号转换及组合料号对应真实料号信息)
             $values_skus = array_values($skus);
             // 得到sku的数量
             //$combineSku = GoodsModel::getCombineSkuinfo ( $sku ); // 判断该sku是否是组合料号,如果是返回combineSku,sku,count关系记录数据,不是则返回false
             if ($isContainCombineSku) {
                 // 为组合订单
                 $goods_costs = 0;
                 $combine_weight_list = array();
                 $goods_costs_list = array();
                 foreach ($skus as $k => $v) {
                     $goodsInfo2 = get_trueSkuInfo($k);
                     //获取真实料号信息
                     $combine_weight_list[$k] = $amount * $v * $goodsInfo2['goodsWeight'];
                     // 组合订单重量数组
                     $goods_costs_list[$k] = $amount * $v * $goodsInfo2['goodsCost'];
                     // 货本数组
                     $goods_costs += $amount * $v * $goodsInfo2['goodsCost'];
                 }
                 $row = array($orderWhInfoWeighTime, $accountName, $orderRecordnumber, $platformUsername, '', '', $amount * array_sum($values_skus), $orderUserInfoCountryName, $orderDetailItemPrice, $ebay_shipfee, $OrderActualTotal, $orderExtenCurrency, $packinguser, $orderTracknumberOne, validate_trackingnumber($orderTracknumberOne) ? '是' : '否', $orderWhInfoActualWeight, $orderCalcShipping, $carrierName, $orderId, $goods_costs, $orderExtenPayPalPaymentId, '', $isCopy, $isBuji, $isSplit, '', '', $isContainCombineSku ? '组合料号' : '', $mailway_c, $isCombinePackage, $orderExtenPayPalEmailAddress, '');
                 $excel->addRow($row);
                 foreach ($skus as $k => $v) {
                     $goodsInfo3 = get_trueSkuInfo($k);
                     $goods_cost = isset($goodsInfo3['goodsCost']) ? round($goodsInfo3['goodsCost'], 2) : 0;
                     $goods_location2Info = M('interfaceWh')->getSkuPosition($sku, $orderDetailStoreId);
                     $goods_location2 = $goods_location2Info['pName'];
                     // 仓位
                     $pmId = isset($goodsInfo3['pmId']) ? $goodsInfo3['pmId'] : '';
                     $ebay_packingmaterial = $packings[$pmId]['pmName'];
                     $ebay_packingCost = $packings[$pmId]['pmCost'];
                     $purchaseId = isset($goodsInfo3[0]['purchaseId']) ? $goodsInfo3[0]['purchaseId'] : '';
                     $cguser = @$staffLists[$purchaseId];
                     $ishipfee = round_num($goods_costs_list[$k] / array_sum($goods_costs_list) * $ebay_shipfee, 2);
                     // 根据货本比ebay运费
                     $iorderweight2 = round($combine_weight_list[$k] / array_sum($combine_weight_list) * $orderWhInfoActualWeight, 3);
                     $iordershipfee = round_num($combine_weight_list[$k] / array_sum($combine_weight_list) * $orderCalcShipping, 2);
                     $iprice = round_num(($goods_costs_list[$k] + $iordershipfee) / (array_sum($goods_costs_list) + $orderCalcShipping) * $ebay_itemprice, 2);
                     // 根据货本比产品价格 last modified by herman.xi @20130916
                     $row = array('', '', $orderDetailRecordnumber, '', $goods_location2, $k, $amount * $v, '', $iprice, $ishipfee, '', '', '', '', '', $iorderweight2, $iordershipfee, '', '', $goods_cost * $amount * $v, '', $orderDetailExtenItemId, '', '', '', $ebay_packingmaterial, $ebay_packingCost, '组合料号', '', '', '', $cguser);
                     $excel->addRow($row);
                 }
             } else {
                 // 非组合订单
                 $row = array($orderWhInfoWeighTime, $accountName, $orderRecordnumber, $platformUsername, $goods_location, $orderDetailSku, $orderDetailAmount * array_sum($values_skus), $orderUserInfoCountryName, $orderDetailItemPrice, $ebay_shipfee, $OrderActualTotal, $orderExtenCurrency, $packinguser, $orderTracknumberOne, validate_trackingnumber($orderTracknumberOne) ? '是' : '否', $orderWhInfoActualWeight, $orderCalcShipping, $carrierName, $orderId, $goods_costs, $orderExtenPayPalPaymentId, $orderDetailExtenItemId, $isCopy, $isBuji, $isSplit, $ebay_packingmaterial, $ebay_packingCost, '', $mailway_c, $isCombinePackage, $orderExtenPayPalEmailAddress, $cguser);
                 $excel->addRow($row);
             }
             unset($combine_weight_list);
             unset($goods_costs_list);
         } else {
             // 订单详细记录>1
             $cctotal = 0;
             $ebay_itemprice = 0;
             $goods_costs = 0;
             $goods_list = array();
             $goods_lists = array();
             $goods_weight_list = array();
             $goods_costs_list = array();
             $calculate_weight = 0;
             foreach ($orderDetail as $orderDetailTotalData) {
                 // $orderDetailTotalData ,包括orderDetailData和orderDetailExtenData
                 $orderDetailData = $orderDetailTotalData['orderDetail'];
                 // 明细中的常用数据
                 $orderDetailExtenData = $orderDetailTotalData['orderDetailExtension'];
                 // 明细中的扩展数据
                 $detail_id = $orderDetailData['id'];
                 $sku = $orderDetailData['sku'];
                 $skus = get_realskuinfo($sku);
                 $_ebay_itemprice = round($orderDetailData['itemPrice'], 2);
                 $ebay_itemprice += $orderDetailData['amount'] * $_ebay_itemprice;
                 foreach ($skus as $k => $v) {
                     $goodsInfo3 = get_trueSkuInfo($k);
                     $_ebay_amount = intval($orderDetailData['amount'] * $v);
                     $cctotal += $_ebay_amount;
                     $calculate_weight += $_ebay_amount * $goodsInfo3['goodsWeight'];
                     $goods_weight_list[$detail_id . $sku][$k] = $_ebay_amount * $goodsInfo3['goodsWeight'];
                     $goods_costs_list[$detail_id . $sku][$k] = round($goodsInfo3['goodsCost'], 2) * $_ebay_amount;
                     $goods_costs += round($goodsInfo3['goodsCost'], 2) * $_ebay_amount;
                 }
             }
             // echo "---------$ebay_itemprice--------";
             $ebay_shipfee = round_num($OrderActualTotal - $ebay_itemprice, 2);
             $row = array($orderWhInfoWeighTime, $accountName, $orderRecordnumber, $platformUsername, '', '', $cctotal, $orderUserInfoCountryName, $ebay_itemprice, $ebay_shipfee, $OrderActualTotal, $orderExtenCurrency, $packinguser, $orderTracknumberOne, validate_trackingnumber($orderTracknumberOne) ? '是' : '否', $orderWhInfoActualWeight, $orderCalcShipping, $carrierName, $orderId, $goods_costs, $orderExtenPayPalPaymentId, '', $isCopy, $isBuji, $isSplit, '', '', $isContainCombineSku ? '组合料号' : '', $mailway_c, $isCombinePackage, $orderExtenPayPalEmailAddress, '');
             $excel->addRow($row);
             foreach ($orderDetail as $orderDetailTotalData) {
                 // $orderDetailTotalData ,包括orderDetailData和orderDetailExtenData
                 $orderDetailData = $orderDetailTotalData['orderDetail'];
                 // 明细中的常用数据
                 $orderDetailExtenData = $orderDetailTotalData['orderDetailExtension'];
                 // 明细中的扩展数据
                 $detail_id = $orderDetailData['id'];
                 $skuDe = $orderDetailData['sku'];
                 $orderDetailStoreId = $orderDetailData['storeId'];
                 $recordnumber = $orderDetailData['recordNumber'];
                 $orderDetailExtenItemId = $orderDetailExtenData['itemId'];
                 // itemId $ebay_itemid
                 // $ebay_itemid = $detail_array['ebay_itemid'];
                 $amount = intval($orderDetailData['amount']);
                 $dshipingfee = $orderDetailData['shippingFee'];
                 $debay_itemprice = round($orderDetailData['itemPrice'], 2);
                 $goodsInfo3 = get_trueSkuInfo($skuDe);
                 $goods_cost = isset($goodsInfo3['goodsCost']) ? round($goodsInfo3['goodsCost'], 2) : 0;
                 $pmId = isset($goodsInfo3['pmId']) ? $goodsInfo3['pmId'] : 0;
                 $ebay_packingmaterial = $packings[$pmId]['pmName'];
                 $ebay_packingCost = $packings[$pmId]['pmCost'];
                 $purchaseId = isset($goodsInfo3['purchaseId']) ? $goodsInfo3['purchaseId'] : '';
                 $cguser = @$staffLists[$purchaseId];
                 $dordershipfee = round($orderCalcShipping * (array_sum($goods_weight_list[$detail_id . $skuDe]) / $calculate_weight), 2);
                 $dorderweight2 = round($orderWhInfoActualWeight * (array_sum($goods_weight_list[$detail_id . $skuDe]) / $calculate_weight), 3);
                 $isContainCombineSku = false;
                 //默认订单不含虚拟料号
                 foreach ($orderDetail as $value) {
                     if (get_isCombineSku($value['orderDetail']['sku'])) {
                         $isContainCombineSku = true;
                         break;
                     }
                 }
                 if ($isContainCombineSku) {
                     // 为组合料号
                     $skus = get_realskuinfo($skuDe);
                     foreach ($skus as $k => $v) {
                         ${$goods_locationInfo} = M('interfaceWh')->getSkuPosition($k, $orderDetailStoreId);
                         $goods_location = ${$goods_locationInfo}['pName'];
                         // 仓位
                         //$goods_location = CommonModel::getPositionBySku ( $k );
                         $goodsInfo3 = get_trueSkuInfo($k);
                         $goods_cost = isset($goodsInfo3['goodsCost']) ? round($goodsInfo3['goodsCost'], 2) : 0;
                         $pmId = isset($goodsInfo3['pmId']) ? $goodsInfo3['pmId'] : '';
                         $ebay_packingmaterial = $packings[$pmId]['pmName'];
                         $ebay_packingCost = $packings[$pmId]['pmCost'];
                         $purchaseId = isset($goodsInfo3['purchaseId']) ? $goodsInfo3['purchaseId'] : '';
                         $cguser = @$staffLists[$purchaseId];
                         // $iprice = round_num(($goods_costs_list[$detail_id.$k][$k]/array_sum($goods_costs_list[$detail_id.$k])) * $debay_itemprice * $amount,2); //根据货本比产品价格
                         $ishipfee = round_num($goods_costs_list[$detail_id . $skuDe][$k] / array_sum($goods_costs_list[$detail_id . $skuDe]) * $dshipingfee, 2);
                         // 根据货本比ebay运费
                         $iorderweight2 = round($goods_weight_list[$detail_id . $skuDe][$k] / array_sum($goods_weight_list[$detail_id . $skuDe]) * $dorderweight2, 3);
                         $iordershipfee = round_num($goods_weight_list[$detail_id . $skuDe][$k] / array_sum($goods_weight_list[$detail_id . $skuDe]) * $dordershipfee, 2);
                         $iprice = round_num(($goods_costs_list[$detail_id . $skuDe][$k] + $iordershipfee) / (array_sum($goods_costs_list[$detail_id . $skuDe]) + $dordershipfee) * $debay_itemprice * $amount, 2);
                         // 根据货本比产品价格 last modified by herman.xi @20130916
                         $row = array('', '', $recordnumber, '', $goods_location, $k, $amount * $v, '', $iprice, $ishipfee, '', '', '', '', '', $iorderweight2, $iordershipfee, '', '', $goods_cost * $amount * $v, '', $orderDetailExtenItemId, '', '', '', $ebay_packingmaterial, $ebay_packingCost, '组合料号', '', '', '', $cguser);
                         $excel->addRow($row);
                     }
                 } else {
                     $row = array('', '', $recordnumber, '', $goods_location, $skuDe, $amount, '', $debay_itemprice * $amount, $dshipingfee, '', '', '', '', '', $dorderweight2, $dordershipfee, '', '', $goods_cost * $amount, '', $orderDetailExtenItemId, '', '', '', $ebay_packingmaterial, $ebay_packingCost, '', '', '', '', $cguser);
                     $excel->addRow($row);
                 }
             }
             unset($goods_weight_list);
             unset($goods_costs_list);
         }
     }
     $excel->finalize();
     exit;
 }
    dbquery("UPDATE " . DB_SETTINGS . " SET settings_value=" . _db($values) . " WHERE settings_name='forum_statistics'");
}
$stat_values = explode("|", $settings['forum_statistics']);
$stat_keys = array("max_online_users");
$stats = array_combine($stat_keys, $stat_values);
$rowspan = "1";
// Forum Stats
if ($settings['forum_statistics_forumstats']) {
    list($posts) = dbarraynum(dbquery("SELECT SUM(forum_postcount) FROM " . DB_FORUMS));
    $posts = empty($posts) ? 0 : $posts;
    list($threads) = dbarraynum(dbquery("SELECT SUM(forum_threadcount) FROM " . DB_FORUMS));
    $threads = empty($threads) ? 0 : $threads;
    list($age) = dbarraynum(dbquery("SELECT user_joined from " . DB_USERS . " WHERE user_id=1"));
    $age = empty($age) ? 0 : $age;
    $threadspday = round_num($threads / ((time() - $age) / (3600 * 24)));
    $postspday = round_num($posts / ((time() - $age) / (3600 * 24)));
    $rowspan++;
}
// Top Posters
if ($settings['forum_statistics_topposters']) {
    list($tposter_id, $tposter_name, $tposter_status, $tposter_posts) = dbarraynum(dbquery("SELECT user_id, user_name, user_status, user_posts FROM " . DB_USERS . " ORDER BY user_posts DESC LIMIT 1"));
    list($aposter_id, $aposter_name, $aposter_status, $aposter_ppday) = dbarraynum(dbquery("SELECT user_id, user_name, user_status, (user_posts/((" . time() . "-user_joined)/(24*3600))) FROM " . DB_USERS . " WHERE user_joined < (" . time() . "-(3600*24)) ORDER BY user_posts DESC LIMIT 1"));
    $rowspan++;
}
// User Stats
if ($settings['forum_statistics_userstats']) {
    pif_cache("online_users");
    $total_online = $pif_cache['online_users']['guests'] + count($pif_cache['online_users']['members']);
    list($max_online, $max_online_time) = explode(":", $stats['max_online_users']);
    if ($total_online > $max_online) {
        $stats['max_online_users'] = $total_online . ":" . time();
Esempio n. 13
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;
     }
 }
Esempio n. 14
0
     //淘宝产品标价
     $orderdata_detail['amount'] = $order['num'];
     //SKU数量
     //$orderdata_detail["shippingFee"]	=	'';
     //$orderdata_detail["reviews"]	    =	'';
     $orderdata_detail['createdTime'] = time();
     /*************END 订单详细数据***************/
     /***************BEGIN 订单详细扩展表数据***************/
     $orderDetailExtTaobao = array();
     $orderDetailExtTaobao['itemTitle'] = $order['title'] . "#" . $order['sku_properties_name'] . "#";
     //产品名称;
     $orderDetailExtTaobao['itemURL'] = $order['pic_path'];
     $orderDetailExtTaobao['itemId'] = $order['sku_id'];
     $orderDetailExtTaobao['transId'] = $recordnumber;
     // 交易id;
     $orderDetailExtTaobao['note'] = round_num($order['payment'], 2);
     //实际SKU付款价
     /*************END 订单详细扩展表数据***************/
     $obj_order_detail_data[] = array('orderDetail' => $orderdata_detail, 'orderDetailExtension' => $orderDetailExtTaobao);
 }
 //包含HH555料号的订单移动到淘宝待审核
 if (in_array('HH555', $sku_infos)) {
     $orderdata['orderType'] = C('STATEPENDING_LYNXPEND');
 }
 $insertOrder = array('order' => $orderdata, 'orderExtension' => $orderExtTaobao, 'orderUserInfo' => $orderUserInfo, 'orderDetail' => $obj_order_detail_data);
 $calcOrderShippingObj = F('CalcOrderShipping');
 $calcOrderShippingObj->setOrder($insertOrder);
 $calcInfo = $calcOrderShippingObj->calcOrderWeight();
 //计算重量和包材
 //var_dump($calcInfo); exit;
 $insertOrder['orderData']['calcWeight'] = $calcInfo[0];
Esempio n. 15
0
 function pagenavi($query, $before = '', $after = '')
 {
     wp_reset_query();
     global $wpdb, $paged;
     $pagenavi_options = array();
     //$pagenavi_options['pages_text'] = ('Page %CURRENT_PAGE% of %TOTAL_PAGES%:');
     $pagenavi_options['pages_text'] = '';
     $pagenavi_options['current_text'] = '%PAGE_NUMBER%';
     $pagenavi_options['page_text'] = '%PAGE_NUMBER%';
     $pagenavi_options['first_text'] = __('First Page', 'swiftframework');
     $pagenavi_options['last_text'] = __('Last Page', 'swiftframework');
     $pagenavi_options['next_text'] = __("Next <i class='ss-navigateright'></i>", "swiftframework");
     $pagenavi_options['prev_text'] = __("<i class='ss-navigateleft'></i> Previous", "swiftframework");
     $pagenavi_options['dotright_text'] = '...';
     $pagenavi_options['dotleft_text'] = '...';
     $pagenavi_options['num_pages'] = 5;
     //continuous block of page numbers
     $pagenavi_options['always_show'] = 0;
     $pagenavi_options['num_larger_page_numbers'] = 0;
     $pagenavi_options['larger_page_numbers_multiple'] = 5;
     $output = "";
     //If NOT a single Post is being displayed
     /*http://codex.wordpress.org/Function_Reference/is_single)*/
     if (!is_single()) {
         $request = $query->request;
         //intval - Get the integer value of a variable
         /*http://php.net/manual/en/function.intval.php*/
         $posts_per_page = intval(get_query_var('posts_per_page'));
         //Retrieve variable in the WP_Query class.
         /*http://codex.wordpress.org/Function_Reference/get_query_var*/
         if (get_query_var('paged')) {
             $paged = get_query_var('paged');
         } elseif (get_query_var('page')) {
             $paged = get_query_var('page');
         } else {
             $paged = 1;
         }
         $numposts = $query->found_posts;
         $max_page = $query->max_num_pages;
         //empty - Determine whether a variable is empty
         /*http://php.net/manual/en/function.empty.php*/
         if (empty($paged) || $paged == 0) {
             $paged = 1;
         }
         $pages_to_show = intval($pagenavi_options['num_pages']);
         $larger_page_to_show = intval($pagenavi_options['num_larger_page_numbers']);
         $larger_page_multiple = intval($pagenavi_options['larger_page_numbers_multiple']);
         $pages_to_show_minus_1 = $pages_to_show - 1;
         $half_page_start = floor($pages_to_show_minus_1 / 2);
         //ceil - Round fractions up (http://us2.php.net/manual/en/function.ceil.php)
         $half_page_end = ceil($pages_to_show_minus_1 / 2);
         $start_page = $paged - $half_page_start;
         if ($start_page <= 0) {
             $start_page = 1;
         }
         $end_page = $paged + $half_page_end;
         if ($end_page - $start_page != $pages_to_show_minus_1) {
             $end_page = $start_page + $pages_to_show_minus_1;
         }
         if ($end_page > $max_page) {
             $start_page = $max_page - $pages_to_show_minus_1;
             $end_page = $max_page;
         }
         if ($start_page <= 0) {
             $start_page = 1;
         }
         $larger_per_page = $larger_page_to_show * $larger_page_multiple;
         //round_num() custom function - Rounds To The Nearest Value.
         $larger_start_page_start = round_num($start_page, 10) + $larger_page_multiple - $larger_per_page;
         $larger_start_page_end = round_num($start_page, 10) + $larger_page_multiple;
         $larger_end_page_start = round_num($end_page, 10) + $larger_page_multiple;
         $larger_end_page_end = round_num($end_page, 10) + $larger_per_page;
         if ($larger_start_page_end - $larger_page_multiple == $start_page) {
             $larger_start_page_start = $larger_start_page_start - $larger_page_multiple;
             $larger_start_page_end = $larger_start_page_end - $larger_page_multiple;
         }
         if ($larger_start_page_start <= 0) {
             $larger_start_page_start = $larger_page_multiple;
         }
         if ($larger_start_page_end > $max_page) {
             $larger_start_page_end = $max_page;
         }
         if ($larger_end_page_end > $max_page) {
             $larger_end_page_end = $max_page;
         }
         if ($max_page > 1 || intval($pagenavi_options['always_show']) == 1) {
             /*http://php.net/manual/en/function.str-replace.php */
             /*number_format_i18n(): Converts integer number to format based on locale (wp-includes/functions.php*/
             $pages_text = str_replace("%CURRENT_PAGE%", number_format_i18n($paged), $pagenavi_options['pages_text']);
             $pages_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pages_text);
             $output .= $before . '<ul class="pagenavi bar-styling">' . "\n";
             if (!empty($pages_text)) {
                 $output .= '<li><span class="pages">' . $pages_text . '</span></li>';
             }
             //Displays a link to the previous post which exists in chronological order from the current post.
             /*http://codex.wordpress.org/Function_Reference/previous_post_link*/
             if ($paged > 1) {
                 $output .= '<li class="prev">' . get_previous_posts_link($pagenavi_options['prev_text']) . '</li>';
             }
             if ($start_page >= 2 && $pages_to_show < $max_page) {
                 $first_page_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pagenavi_options['first_text']);
                 //esc_url(): Encodes < > & " ' (less than, greater than, ampersand, double quote, single quote).
                 /*http://codex.wordpress.org/Data_Validation*/
                 //get_pagenum_link():(wp-includes/link-template.php)-Retrieve get links for page numbers.
                 $output .= '<li><a href="' . esc_url(get_pagenum_link()) . '" class="first" title="' . $first_page_text . '">1</a></li>';
                 if (!empty($pagenavi_options['dotleft_text'])) {
                     $output .= '<li><span class="expand">' . $pagenavi_options['dotleft_text'] . '</span></li>';
                 }
             }
             if ($larger_page_to_show > 0 && $larger_start_page_start > 0 && $larger_start_page_end <= $max_page) {
                 for ($i = $larger_start_page_start; $i < $larger_start_page_end; $i += $larger_page_multiple) {
                     $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                     $output .= '<li><a href="' . esc_url(get_pagenum_link($i)) . '" class="single_page" title="' . $page_text . '">' . $page_text . '</a></li>';
                 }
             }
             for ($i = $start_page; $i <= $end_page; $i++) {
                 if ($i == $paged) {
                     $current_page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['current_text']);
                     $output .= '<li><span class="current">' . $current_page_text . '</span></li>';
                 } else {
                     $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                     $output .= '<li><a href="' . esc_url(get_pagenum_link($i)) . '" class="single_page" title="' . $page_text . '">' . $page_text . '</a></li>';
                 }
             }
             if ($end_page < $max_page) {
                 if (!empty($pagenavi_options['dotright_text'])) {
                     $output .= '<li><span class="expand">' . $pagenavi_options['dotright_text'] . '</span></li>';
                 }
                 $last_page_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pagenavi_options['last_text']);
                 $output .= '<li><a href="' . esc_url(get_pagenum_link($max_page)) . '" class="last" title="' . $last_page_text . '">' . $max_page . '</a></li>';
             }
             $output .= '<li class="next">' . get_next_posts_link($pagenavi_options['next_text'], $max_page) . '</li>';
             if ($larger_page_to_show > 0 && $larger_end_page_start < $max_page) {
                 for ($i = $larger_end_page_start; $i <= $larger_end_page_end; $i += $larger_page_multiple) {
                     $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                     $output .= '<li><a href="' . esc_url(get_pagenum_link($i)) . '" class="single_page" title="' . $page_text . '">' . $page_text . '</a></li>';
                 }
             }
             $output .= '</ul>' . $after . "\n";
         }
     }
     return $output;
 }
Esempio n. 16
0
 public function view_ebayStatisticsExport()
 {
     $start = isset($_GET['start']) ? post_check($_GET['start']) : '';
     $end = isset($_GET['end']) ? post_check($_GET['end']) : '';
     $start = strtotime($start);
     $end = strtotime($end);
     //$start	= 1356972800;
     //$end	= 1399972800;
     $where = " where is_delete = 0";
     if ($start != '') {
         $where .= " and feedbacktime >= '{$start}' ";
     }
     if ($end != '') {
         $where .= " and feedbacktime <= '{$end}' ";
     }
     $accAct = new AccountAct();
     $accountList = $accAct->act_getAccountList('account', 'where platformId = 1 and is_delete = 0');
     $FBAct = new EbayFeedbackAct();
     $exporter = new ExportDataExcel("browser", "ebayStatistics_" . date('Y-m-d') . ".xls");
     $exporter->initialize();
     $exporter->addRow(array('eBay帐号', '好评数', '中评数', '差评数', '总评数', '好评率'));
     foreach ($accountList as $k => $v) {
         $account = $v['account'];
         $positive = $FBAct->act_getOrderList('count(*)', " {$where} and account='{$account}' and CommentType='Positive'");
         $positiveTotal = $positive[0]['count(*)'];
         $neutral = $FBAct->act_getOrderList('count(*)', " {$where} and account='{$account}' and CommentType='Neutral'");
         $neutralTotal = $neutral[0]['count(*)'];
         $negative = $FBAct->act_getOrderList('count(*)', " {$where} and account='{$account}' and CommentType='Negative'");
         $negativeTotal = $negative[0]['count(*)'];
         $total = $positiveTotal + $neutralTotal * 0.6 + $negativeTotal;
         $total = round_num($total, 1);
         if ($total != 0) {
             $per_positive = $positiveTotal / $total;
             $per_positive = round_num($per_positive * 100, 2);
             //$per_positive = round_num($positiveTotal * 100,2).'%';
         } else {
             $per_positive = 0;
         }
         $data = array($account, $positiveTotal, $neutralTotal, $negativeTotal, $total, $per_positive);
         $exporter->addRow($data);
     }
     $exporter->finalize();
     exit;
 }
Esempio n. 17
0
function pagenavi($before = '', $after = '')
{
    global $wpdb, $wp_query;
    $pagenavi_options = array();
    $pagenavi_options['pages_text'] = 'Página %CURRENT_PAGE% de %TOTAL_PAGES%:';
    $pagenavi_options['current_text'] = '%PAGE_NUMBER%';
    $pagenavi_options['page_text'] = '%PAGE_NUMBER%';
    $pagenavi_options['first_text'] = 'Primera';
    $pagenavi_options['last_text'] = 'Última';
    $pagenavi_options['next_text'] = 'Siguiente &raquo;';
    $pagenavi_options['prev_text'] = '&laquo; Anterior';
    $pagenavi_options['dotright_text'] = '...';
    $pagenavi_options['dotleft_text'] = '...';
    $pagenavi_options['num_pages'] = 5;
    //continuous block of page numbers
    $pagenavi_options['always_show'] = 0;
    $pagenavi_options['num_larger_page_numbers'] = 0;
    $pagenavi_options['larger_page_numbers_multiple'] = 5;
    //If NOT a single Post is being displayed
    /*http://codex.wordpress.org/Function_Reference/is_single)*/
    if (!is_single()) {
        $request = $wp_query->request;
        //intval — Get the integer value of a variable
        /*http://php.net/manual/en/function.intval.php*/
        $posts_per_page = intval(get_query_var('posts_per_page'));
        //Retrieve variable in the WP_Query class.
        /*http://codex.wordpress.org/Function_Reference/get_query_var*/
        $paged = intval(get_query_var('paged'));
        $numposts = $wp_query->found_posts;
        $max_page = $wp_query->max_num_pages;
        //empty — Determine whether a variable is empty
        /*http://php.net/manual/en/function.empty.php*/
        if (empty($paged) || $paged == 0) {
            $paged = 1;
        }
        $pages_to_show = intval($pagenavi_options['num_pages']);
        $larger_page_to_show = intval($pagenavi_options['num_larger_page_numbers']);
        $larger_page_multiple = intval($pagenavi_options['larger_page_numbers_multiple']);
        $pages_to_show_minus_1 = $pages_to_show - 1;
        $half_page_start = floor($pages_to_show_minus_1 / 2);
        //ceil — Round fractions up (http://us2.php.net/manual/en/function.ceil.php)
        $half_page_end = ceil($pages_to_show_minus_1 / 2);
        $start_page = $paged - $half_page_start;
        if ($start_page <= 0) {
            $start_page = 1;
        }
        $end_page = $paged + $half_page_end;
        if ($end_page - $start_page != $pages_to_show_minus_1) {
            $end_page = $start_page + $pages_to_show_minus_1;
        }
        if ($end_page > $max_page) {
            $start_page = $max_page - $pages_to_show_minus_1;
            $end_page = $max_page;
        }
        if ($start_page <= 0) {
            $start_page = 1;
        }
        $larger_per_page = $larger_page_to_show * $larger_page_multiple;
        //round_num() custom function - Rounds To The Nearest Value.
        $larger_start_page_start = round_num($start_page, 10) + $larger_page_multiple - $larger_per_page;
        $larger_start_page_end = round_num($start_page, 10) + $larger_page_multiple;
        $larger_end_page_start = round_num($end_page, 10) + $larger_page_multiple;
        $larger_end_page_end = round_num($end_page, 10) + $larger_per_page;
        if ($larger_start_page_end - $larger_page_multiple == $start_page) {
            $larger_start_page_start = $larger_start_page_start - $larger_page_multiple;
            $larger_start_page_end = $larger_start_page_end - $larger_page_multiple;
        }
        if ($larger_start_page_start <= 0) {
            $larger_start_page_start = $larger_page_multiple;
        }
        if ($larger_start_page_end > $max_page) {
            $larger_start_page_end = $max_page;
        }
        if ($larger_end_page_end > $max_page) {
            $larger_end_page_end = $max_page;
        }
        if ($max_page > 1 || intval($pagenavi_options['always_show']) == 1) {
            /*http://php.net/manual/en/function.str-replace.php */
            /*number_format_i18n(): Converts integer number to format based on locale (wp-includes/functions.php*/
            $pages_text = str_replace("%CURRENT_PAGE%", number_format_i18n($paged), $pagenavi_options['pages_text']);
            $pages_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pages_text);
            echo $before . '<div class="pagenavi">' . "\n";
            if (!empty($pages_text)) {
                echo '<span class="pages">' . $pages_text . '</span>';
            }
            //Displays a link to the previous post which exists in chronological order from the current post.
            /*http://codex.wordpress.org/Function_Reference/previous_post_link*/
            previous_posts_link($pagenavi_options['prev_text']);
            if ($start_page >= 2 && $pages_to_show < $max_page) {
                $first_page_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pagenavi_options['first_text']);
                //esc_url(): Encodes < > & " ' (less than, greater than, ampersand, double quote, single quote).
                /*http://codex.wordpress.org/Data_Validation*/
                //get_pagenum_link():(wp-includes/link-template.php)-Retrieve get links for page numbers.
                echo '<a href="' . esc_url(get_pagenum_link()) . '" class="first" title="' . $first_page_text . '">1</a>';
                if (!empty($pagenavi_options['dotleft_text'])) {
                    echo '<span class="expand">' . $pagenavi_options['dotleft_text'] . '</span>';
                }
            }
            if ($larger_page_to_show > 0 && $larger_start_page_start > 0 && $larger_start_page_end <= $max_page) {
                for ($i = $larger_start_page_start; $i < $larger_start_page_end; $i += $larger_page_multiple) {
                    $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                    echo '<a href="' . esc_url(get_pagenum_link($i)) . '" class="single_page" title="' . $page_text . '">' . $page_text . '</a>';
                }
            }
            for ($i = $start_page; $i <= $end_page; $i++) {
                if ($i == $paged) {
                    $current_page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['current_text']);
                    echo '<span class="current">' . $current_page_text . '</span>';
                } else {
                    $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                    echo '<a href="' . esc_url(get_pagenum_link($i)) . '" class="single_page" title="' . $page_text . '">' . $page_text . '</a>';
                }
            }
            if ($end_page < $max_page) {
                if (!empty($pagenavi_options['dotright_text'])) {
                    echo '<span class="expand">' . $pagenavi_options['dotright_text'] . '</span>';
                }
                $last_page_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pagenavi_options['last_text']);
                echo '<a href="' . esc_url(get_pagenum_link($max_page)) . '" class="last" title="' . $last_page_text . '">' . $max_page . '</a>';
            }
            next_posts_link($pagenavi_options['next_text'], $max_page);
            if ($larger_page_to_show > 0 && $larger_end_page_start < $max_page) {
                for ($i = $larger_end_page_start; $i <= $larger_end_page_end; $i += $larger_page_multiple) {
                    $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                    echo '<a href="' . esc_url(get_pagenum_link($i)) . '" class="single_page" title="' . $page_text . '">' . $page_text . '</a>';
                }
            }
            echo '</div>' . $after . "\n";
        }
    }
}
Esempio n. 18
0
function ppagenavi($query, $before = '', $after = '', $page_d = 1)
{
    wp_reset_query();
    global $wpdb, $paged;
    $paged = $page_d;
    $pagenavi_options = array('pages_text' => '', 'current_text' => '%PAGE_NUMBER%', 'page_text' => '%PAGE_NUMBER%', 'first_text' => 'First Page', 'last_text' => 'Last Page', 'next_text' => __("Next", THEME_SLUG), 'prev_text' => __("Previous", THEME_SLUG), 'dotright_text' => '...', 'dotleft_text' => '...', 'num_pages' => 5, 'always_show' => 0, 'num_larger_page_numbers' => 0, 'larger_page_numbers_multiple' => 5);
    $output = "";
    $request = $query->request;
    $posts_per_page = intval(get_query_var('posts_per_page'));
    //Retrieve variable in the WP_Query class.
    /*http://codex.wordpress.org/Function_Reference/get_query_var*/
    /*			if ( get_query_var('paged') ) {
    			$paged = get_query_var('paged');
    		}
    		elseif ( get_query_var('page') ) {
    			$paged = get_query_var('page');
    		} else {
    			$paged = 1;
    		}*/
    $numposts = $query->found_posts;
    $max_page = $query->max_num_pages;
    $pages_to_show = intval($pagenavi_options['num_pages']);
    $larger_page_to_show = intval($pagenavi_options['num_larger_page_numbers']);
    $larger_page_multiple = intval($pagenavi_options['larger_page_numbers_multiple']);
    $pages_to_show_minus_1 = $pages_to_show - 1;
    $half_page_start = floor($pages_to_show_minus_1 / 2);
    //ceil — Round fractions up (http://us2.php.net/manual/en/function.ceil.php)
    $half_page_end = ceil($pages_to_show_minus_1 / 2);
    $start_page = $paged - $half_page_start;
    if ($start_page <= 0) {
        $start_page = 1;
    }
    $end_page = $paged + $half_page_end;
    if ($end_page - $start_page != $pages_to_show_minus_1) {
        $end_page = $start_page + $pages_to_show_minus_1;
    }
    if ($end_page > $max_page) {
        $start_page = $max_page - $pages_to_show_minus_1;
        $end_page = $max_page;
    }
    if ($start_page <= 0) {
        $start_page = 1;
    }
    $larger_per_page = $larger_page_to_show * $larger_page_multiple;
    $larger_start_page_start = round_num($start_page, 10) + $larger_page_multiple - $larger_per_page;
    $larger_start_page_end = round_num($start_page, 10) + $larger_page_multiple;
    $larger_end_page_start = round_num($end_page, 10) + $larger_page_multiple;
    $larger_end_page_end = round_num($end_page, 10) + $larger_per_page;
    if ($larger_start_page_end - $larger_page_multiple == $start_page) {
        $larger_start_page_start = $larger_start_page_start - $larger_page_multiple;
        $larger_start_page_end = $larger_start_page_end - $larger_page_multiple;
    }
    if ($larger_start_page_start <= 0) {
        $larger_start_page_start = $larger_page_multiple;
    }
    if ($larger_start_page_end > $max_page) {
        $larger_start_page_end = $max_page;
    }
    if ($larger_end_page_end > $max_page) {
        $larger_end_page_end = $max_page;
    }
    if ($max_page > 1 || intval($pagenavi_options['always_show']) == 1) {
        /*http://php.net/manual/en/function.str-replace.php */
        /*number_format_i18n(): Converts integer number to format based on locale (wp-includes/functions.php*/
        $pages_text = str_replace("%CURRENT_PAGE%", number_format_i18n($paged), $pagenavi_options['pages_text']);
        $pages_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pages_text);
        $output .= $before;
        if (!empty($pages_text)) {
            $output .= '<span class="pages">' . $pages_text . '</span>';
        }
        //Displays a link to the previous post which exists in chronological order from the current post.
        /*http://codex.wordpress.org/Function_Reference/previous_post_link*/
        if ($paged > 1) {
            $output .= '<a class="prev page-numbers" href="paged=' . ($paged - 1) . '">' . $pagenavi_options['prev_text'] . '</a>';
        }
        if ($start_page >= 2 && $pages_to_show < $max_page) {
            $first_page_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pagenavi_options['first_text']);
            //esc_url(): Encodes < > & " ' (less than, greater than, ampersand, double quote, single quote).
            /*http://codex.wordpress.org/Data_Validation*/
            //get_pagenum_link():(wp-includes/link-template.php)-Retrieve get links for page numbers.
            $output .= '<a href="paged=1" class="first page-numbers" title="' . $first_page_text . '">1</a>';
            if (!empty($pagenavi_options['dotleft_text'])) {
                $output .= '<span class="expand">' . $pagenavi_options['dotleft_text'] . '</span>';
            }
        }
        if ($larger_page_to_show > 0 && $larger_start_page_start > 0 && $larger_start_page_end <= $max_page) {
            for ($i = $larger_start_page_start; $i < $larger_start_page_end; $i += $larger_page_multiple) {
                $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                $output .= '<a href="paged=' . $i . '" class="page-numbers" title="' . $page_text . '">' . $page_text . '</a>';
            }
        }
        for ($i = $start_page; $i <= $end_page; $i++) {
            if ($i == $paged) {
                $current_page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['current_text']);
                $output .= '<span class="current">' . $current_page_text . '</span>';
            } else {
                $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                $output .= '<a href="paged=' . $i . '" class="single_page page-numbers" title="' . $page_text . '">' . $page_text . '</a>';
            }
        }
        if ($end_page < $max_page) {
            if (!empty($pagenavi_options['dotright_text'])) {
                $output .= '<span class="expand">' . $pagenavi_options['dotright_text'] . '</span>';
            }
            $last_page_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pagenavi_options['last_text']);
            $output .= '<a href="paged=' . $max_page . '" class="last page-numbers" title="' . $last_page_text . '">' . $max_page . '</a>';
        }
        $next = $paged < $max_page ? '<a class="page-numbers" href="paged=' . ($paged + 1) . '">' . $pagenavi_options['next_text'] . '</a>' : '';
        if (strlen($next)) {
            $output .= $next;
        }
        if ($larger_page_to_show > 0 && $larger_end_page_start < $max_page) {
            for ($i = $larger_end_page_start; $i <= $larger_end_page_end; $i += $larger_page_multiple) {
                $page_text = str_replace("%PAGE_NUMBER%", number_format_i18n($i), $pagenavi_options['page_text']);
                $output .= '<a href="paged=' . $i . '" class="single_page page-numbers" title="' . $page_text . '">' . $page_text . '</a>';
            }
        }
        $output .= $after;
    }
    return $output;
}
Esempio n. 19
0
 function pagenavi_infinite($query, $before = '', $after = '')
 {
     wp_reset_query();
     global $wpdb, $paged;
     $pagenavi_options = array();
     //$pagenavi_options['pages_text'] = ('Page %CURRENT_PAGE% of %TOTAL_PAGES%:');
     $pagenavi_options['pages_text'] = '';
     $pagenavi_options['current_text'] = '%PAGE_NUMBER%';
     $pagenavi_options['page_text'] = '%PAGE_NUMBER%';
     $pagenavi_options['next_text'] = __("Show More", "js_composer");
     $pagenavi_options['num_pages'] = 5;
     //continuous block of page numbers
     $pagenavi_options['always_show'] = 0;
     $pagenavi_options['num_larger_page_numbers'] = 0;
     $pagenavi_options['larger_page_numbers_multiple'] = 5;
     $output = "";
     //If NOT a single Post is being displayed
     if (!is_single()) {
         $request = $query->request;
         //intval - Get the integer value of a variable
         $posts_per_page = intval(get_query_var('posts_per_page'));
         //Retrieve variable in the WP_Query class.
         if (get_query_var('paged')) {
             $paged = get_query_var('paged');
         } elseif (get_query_var('page')) {
             $paged = get_query_var('page');
         } else {
             $paged = 1;
         }
         $numposts = $query->found_posts;
         $max_page = $query->max_num_pages;
         //empty - Determine whether a variable is empty
         if (empty($paged) || $paged == 0) {
             $paged = 1;
         }
         $pages_to_show = intval($pagenavi_options['num_pages']);
         $larger_page_to_show = intval($pagenavi_options['num_larger_page_numbers']);
         $larger_page_multiple = intval($pagenavi_options['larger_page_numbers_multiple']);
         $pages_to_show_minus_1 = $pages_to_show - 1;
         $half_page_start = floor($pages_to_show_minus_1 / 2);
         //ceil - Round fractions up (http://us2.php.net/manual/en/function.ceil.php)
         $half_page_end = ceil($pages_to_show_minus_1 / 2);
         $start_page = $paged - $half_page_start;
         if ($start_page <= 0) {
             $start_page = 1;
         }
         $end_page = $paged + $half_page_end;
         if ($end_page - $start_page != $pages_to_show_minus_1) {
             $end_page = $start_page + $pages_to_show_minus_1;
         }
         if ($end_page > $max_page) {
             $start_page = $max_page - $pages_to_show_minus_1;
             $end_page = $max_page;
         }
         if ($start_page <= 0) {
             $start_page = 1;
         }
         $larger_per_page = $larger_page_to_show * $larger_page_multiple;
         //round_num() custom function - Rounds To The Nearest Value.
         $larger_start_page_start = round_num($start_page, 10) + $larger_page_multiple - $larger_per_page;
         $larger_start_page_end = round_num($start_page, 10) + $larger_page_multiple;
         $larger_end_page_start = round_num($end_page, 10) + $larger_page_multiple;
         $larger_end_page_end = round_num($end_page, 10) + $larger_per_page;
         if ($larger_start_page_end - $larger_page_multiple == $start_page) {
             $larger_start_page_start = $larger_start_page_start - $larger_page_multiple;
             $larger_start_page_end = $larger_start_page_end - $larger_page_multiple;
         }
         if ($larger_start_page_start <= 0) {
             $larger_start_page_start = $larger_page_multiple;
         }
         if ($larger_start_page_end > $max_page) {
             $larger_start_page_end = $max_page;
         }
         if ($larger_end_page_end > $max_page) {
             $larger_end_page_end = $max_page;
         }
         if ($max_page > 1 || intval($pagenavi_options['always_show']) == 1) {
             $pages_text = str_replace("%CURRENT_PAGE%", number_format_i18n($paged), $pagenavi_options['pages_text']);
             $pages_text = str_replace("%TOTAL_PAGES%", number_format_i18n($max_page), $pages_text);
             $output .= $before . '<ul class="pagenavi">' . "\n";
             if (!empty($pages_text)) {
                 $output .= '<li><span class="pages">' . $pages_text . '</span></li>';
             }
             $output .= '<li class="next">' . get_next_posts_link($pagenavi_options['next_text'], $max_page) . '</li>';
             $output .= '</ul>' . $after . "\n";
         }
     }
     return $output;
 }
    function content_52b79c2c958ff0_76857627($_smarty_tpl)
    {
        echo $_smarty_tpl->getSubTemplate("header.htm", $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, null, null, array(), 0);
        ?>

<div class="fourvar">
	<div class="pathvar">
		您的位置:<a href="index.php?mod=productStockalarm&act=index">预警管理</a>&nbsp;>>&nbsp;<?php 
        echo $_smarty_tpl->tpl_vars['title']->value;
        ?>

	</div>
	<div class="pagination">
		<?php 
        echo $_smarty_tpl->tpl_vars['pageStr']->value;
        ?>

	</div>
</div>
<div class="servar">
	<span>关键字:<input id="key" type="text" style="width:300px;height:30px" <?php 
        if ($_smarty_tpl->tpl_vars['key']->value) {
            ?>
 value="<?php 
            echo $_smarty_tpl->tpl_vars['key']->value;
            ?>
" <?php 
        }
        ?>
/>
	<span>搜索类型:<select id="type">
			<option value='sku'  <?php 
        if ($_GET['type'] == "sku") {
            ?>
selected="selected"<?php 
        }
        ?>
>料号子SKU</option>
			<option value='spu' <?php 
        if ($_GET['type'] == "sku") {
            ?>
selected="selected"<?php 
        }
        ?>
 >主料号</option>
			<option value= "goodsName" <?php 
        if ($_GET['type'] == "goodsName") {
            ?>
selected="selected"<?php 
        }
        ?>
>产品名称</option>
			<option value= "partner" <?php 
        if ($_GET['type'] == "partner") {
            ?>
selected="selected"<?php 
        }
        ?>
>供应商</option>
	</select>
	</span>
	</span>
		 <span>产品状态:<select id="flag">
			<option value='-1'>选择状态</option> 
			<option value='1' <?php 
        if ($_smarty_tpl->tpl_vars['status']->value == "1") {
            ?>
 selected<?php 
        }
        ?>
>在线</option> 
			<option value='2' <?php 
        if ($_smarty_tpl->tpl_vars['status']->value == "2") {
            ?>
 selected<?php 
        }
        ?>
>下线</option> 
			<option value='3' <?php 
        if ($_smarty_tpl->tpl_vars['status']->value == "3") {
            ?>
 selected<?php 
        }
        ?>
>零库存</option> 
			<option value='4' <?php 
        if ($_smarty_tpl->tpl_vars['status']->value == "4") {
            ?>
 selected<?php 
        }
        ?>
>停售</option> 
			<option value='5' <?php 
        if ($_smarty_tpl->tpl_vars['status']->value == "5") {
            ?>
 selected<?php 
        }
        ?>
>部分平台在线</option> 
	</select>
	</span>
		 <span>供应商:<select id="pid">
			<option value='-1'>请选择供应商</option>
			<?php 
        $_smarty_tpl->tpl_vars['list'] = new Smarty_Variable();
        $_smarty_tpl->tpl_vars['list']->_loop = false;
        $_from = $_smarty_tpl->tpl_vars['partnerList']->value;
        if (!is_array($_from) && !is_object($_from)) {
            settype($_from, 'array');
        }
        foreach ($_from as $_smarty_tpl->tpl_vars['list']->key => $_smarty_tpl->tpl_vars['list']->value) {
            $_smarty_tpl->tpl_vars['list']->_loop = true;
            ?>
 
			<option value="<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['id'];
            ?>
" <?php 
            if ($_smarty_tpl->tpl_vars['pid']->value == $_smarty_tpl->tpl_vars['list']->value['id']) {
                ?>
selected="selected"<?php 
            }
            ?>
><?php 
            echo $_smarty_tpl->tpl_vars['list']->value['company_name'];
            ?>
</option>
			<?php 
        }
        ?>
 
	</select>
	</span>	 
	<span>采购员:
			<select id="pcid">
				<option value="-1">请选择采购员</option> 
			<?php 
        $_smarty_tpl->tpl_vars['list'] = new Smarty_Variable();
        $_smarty_tpl->tpl_vars['list']->_loop = false;
        $_from = $_smarty_tpl->tpl_vars['purchaseList']->value;
        if (!is_array($_from) && !is_object($_from)) {
            settype($_from, 'array');
        }
        foreach ($_from as $_smarty_tpl->tpl_vars['list']->key => $_smarty_tpl->tpl_vars['list']->value) {
            $_smarty_tpl->tpl_vars['list']->_loop = true;
            ?>
			<option value="<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['global_user_id'];
            ?>
" <?php 
            if ($_GET['pcid'] == $_smarty_tpl->tpl_vars['list']->value['global_user_id']) {
                ?>
 selected="selected"<?php 
            } elseif ($_SESSION['sysUserId'] == $_smarty_tpl->tpl_vars['list']->value['global_user_id']) {
                ?>
selected="selected"<?php 
            }
            ?>
><?php 
            echo $_smarty_tpl->tpl_vars['list']->value["global_user_name"];
            ?>
</option>
			<?php 
        }
        ?>
			</select> 
	</span>
	<div style="border:2px red ;height:10px;"></div>
	 <span>
		 预警状态:
		<select id="is_warn">
		<option value='-1' <?php 
        if ($_smarty_tpl->tpl_vars['is_warn']->value == '-1') {
            ?>
 selected<?php 
        }
        ?>
>全部货品信息</option> 
		<option value='1'  <?php 
        if ($_smarty_tpl->tpl_vars['is_warn']->value == '1') {
            ?>
 selected<?php 
        }
        ?>
>预警货品信息</option> 
		<option value='2'  <?php 
        if ($_smarty_tpl->tpl_vars['is_warn']->value == '2') {
            ?>
 selected<?php 
        }
        ?>
>缺货已订购</option> 
		</select>
	</span>
	<span>每天均量排序:
		<select id="dailyNum">
			<option value='-1' <?php 
        if ($_GET['dailyNum'] == '-1') {
            ?>
 selected<?php 
        }
        ?>
>--请选择顺序排列--</option> 
			<option value='1' <?php 
        if ($_GET['dailyNum'] == '1') {
            ?>
 selected<?php 
        }
        ?>
>--销量从高到低--</option> 
			<option value='2' <?php 
        if ($_GET['dailyNum'] == '2') {
            ?>
 selected<?php 
        }
        ?>
>--销量从低到高--</option> 
		</select>
	</span>

	<span>已订购筛选:
		<select id="bookNum">
			<option value='-1' <?php 
        if ($_GET['bookNum'] == '-1') {
            ?>
 selected<?php 
        }
        ?>
>--请选择--</option> 
			<option value='1' <?php 
        if ($_GET['bookNum'] == '1') {
            ?>
 selected<?php 
        }
        ?>
>已订购</option> 
		</select>
	</span>

	 <span> <a href="javascript:void(0)" id="search-btn">搜 索</a>
	</span>
	 <span> <a href="javascript:void(0)" id="createPur">生成采购订单</a>
	</span>
	<span> <a href="javascript:void(0)" id="pl-partner">批量更新供应商</a>
	</span>
	<span> <a href="javascript:void(0)" id="getSkuData">获取旧ERP数据</a></span>
	<span style="display:none"> <a href="javascript:void(0)" id="updateCache">新系统更新缓存</a></span>
	<span> <a href="javascript:void(0)" id="checkAlert">判断预警</a></span>

	<!--
	<span> <a href="javascript:void(0)" id="stop-sale">暂时停售</a></span>
	<span> <a href="javascript:void(0)" id="forever-stop-sale">永久停售</a></span>
	<span> <a href="javascript:void(0)" id="begin-sale">开始销售</a></span>
	-->
	
</div>
<div class="main products-main reply-main warning-main pagemargin-main">
	<table cellspacing="0" width="100%">
		<tbody>
			<tr class="purchase-title title">
				<td>
					<input type="checkbox" name="inverse-check" id="inverse-check" />
				</td>
				<td></td>
				<td>
					是否<br>预警
				</td>
				<td>
					产品
					<br />
					编号
				</td>
				<td>
					产品
					<br />
					成本
				</td>
				<td>
					海外
					<br />
					库存
				</td>
				<td>
					实际
					<br />
					库存
				</td>
				<td>
					待发
					<br />
					货
				</td>
				<td>
					被拦
					<br />
					截
				</td>
				<td>
					自动
					<br />
					拦截
				</td>
				<td>
					待审
					<br />
					核
				</td>
				<td>
					虚拟
					<br />
					库存
				</td>
				<td>
					缺货
					<br />
					库存
				</td>
				<td>
					可用
					<br />
					天数
				</td>
				<td>
					每天
					<br />
					均量
				</td>
				<td>
					预警
					<br />
					天数
				</td>
				<td>
					采购
					<br />
					天数
				</td>
				<td>
					已订
					<br />
					购
				</td>
				<td>
					在途
					<br />
					数量
				</td>
				<td>
					建议采	
					<br />
					购数量
				</td>
				<td>
					下月
					<br />
					预测
				</td>
				<td>
					重量
				</td>
				<td>
					产品
					<br />
					状态
				</td>
				<td>
					采购
				</td>
			</tr>
			<?php 
        $_smarty_tpl->tpl_vars['list'] = new Smarty_Variable();
        $_smarty_tpl->tpl_vars['list']->_loop = false;
        $_from = $_smarty_tpl->tpl_vars['lists']->value;
        if (!is_array($_from) && !is_object($_from)) {
            settype($_from, 'array');
        }
        $_smarty_tpl->tpl_vars['smarty']->value['foreach']['foo']['iteration'] = 0;
        foreach ($_from as $_smarty_tpl->tpl_vars['list']->key => $_smarty_tpl->tpl_vars['list']->value) {
            $_smarty_tpl->tpl_vars['list']->_loop = true;
            $_smarty_tpl->tpl_vars['smarty']->value['foreach']['foo']['iteration']++;
            ?>
			<tr <?php 
            if ($_smarty_tpl->getVariable('smarty')->value['foreach']['foo']['iteration'] % 2 == 0) {
                ?>
style="background-color:#f2f2f2;"<?php 
            }
            ?>
>
				<td class="bor-top" rowspan="2">
					<input type="checkbox" name="inverse" value="<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['sku'];
            ?>
" data-rec="<?php 
            echo ceil($_smarty_tpl->tpl_vars['list']->value['purchaseDays'] * $_smarty_tpl->tpl_vars['list']->value['everyday_sale']);
            ?>
"/>
				</td>
				<td class="bor-top" rowspan="2">
					<a href="javascript:void(0)" id="imgb-<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['sku'];
            ?>
" class="fancybox">
						<img src="" class="skuimg" id="imgs-<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['sku'];
            ?>
"  width="60" height="60" data-spu="<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['spu'];
            ?>
" data-sku="<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['sku'];
            ?>
">
			   		</a>
				</td>
		
				<td class="bor-top" align="left">
					<?php 
            if ($_smarty_tpl->tpl_vars['list']->value['is_warning']) {
                ?>
<span style="color:red">是</span><?php 
            } else {
                ?>
<span style="color:green">否</span><?php 
            }
            ?>
				</td>
				<td class="bor-top" align="left">
					<span class="font-16"><?php 
            echo $_smarty_tpl->tpl_vars['list']->value['sku'];
            ?>
</span>
				</td>
				<td class="bor-top">
					¥<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['goodsCost'];
            ?>

				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['ow_stock'];
            ?>
		
				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['stock_qty'];
            ?>
		
				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['salensend'];
            ?>

				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['interceptnums'];
            ?>

				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['autointerceptnums'];
            ?>

				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['auditingnums'];
            ?>

				</td>
				<td class="bor-top">
					<?php 
            if ($_smarty_tpl->tpl_vars['list']->value['stock_qty'] - $_smarty_tpl->tpl_vars['list']->value['salensend'] > 0) {
                ?>
 <?php 
                echo $_smarty_tpl->tpl_vars['list']->value['stock_qty'] - $_smarty_tpl->tpl_vars['list']->value['salensend'];
                ?>
 <?php 
            } else {
                ?>
 <font color='red'><?php 
                echo $_smarty_tpl->tpl_vars['list']->value['stock_qty'] - $_smarty_tpl->tpl_vars['list']->value['salensend'];
                ?>
</font><?php 
            }
            ?>
				</td>
				<td class="bor-top">
					<?php 
            if ($_smarty_tpl->tpl_vars['list']->value['stock_qty'] - $_smarty_tpl->tpl_vars['list']->value['salensend'] - $_smarty_tpl->tpl_vars['list']->value['autointerceptnums'] > 0) {
                ?>
 <?php 
                echo $_smarty_tpl->tpl_vars['list']->value['stock_qty'] - $_smarty_tpl->tpl_vars['list']->value['salensend'] - $_smarty_tpl->tpl_vars['list']->value['autointerceptnums'];
                ?>
 <?php 
            } else {
                ?>
 <font color='red'><?php 
                echo $_smarty_tpl->tpl_vars['list']->value['stock_qty'] - $_smarty_tpl->tpl_vars['list']->value['salensend'] - $_smarty_tpl->tpl_vars['list']->value['autointerceptnums'];
                ?>
</font><?php 
            }
            ?>
				</td>
				<td class="bor-top">
					<?php 
            if ($_smarty_tpl->tpl_vars['list']->value['first_sale'] == 0) {
                ?>
从未卖<?php 
            } elseif ($_smarty_tpl->tpl_vars['list']->value['last_sale'] < time() - 3600 * 24 * 30) {
                ?>
月未卖<?php 
            } elseif ($_smarty_tpl->tpl_vars['list']->value['stock_qty'] == $_smarty_tpl->tpl_vars['list']->value['salensend']) {
                ?>
0 <?php 
            } else {
                ?>
 <?php 
                echo str_replace(".00", '', round_num(($_smarty_tpl->tpl_vars['list']->value['stock_qty'] - $_smarty_tpl->tpl_vars['list']->value['salensend']) / $_smarty_tpl->tpl_vars['list']->value['everyday_sale'], 2));
            }
            ?>
				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['everyday_sale'];
            ?>

				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['alertDays'];
            ?>

				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['purchaseDays'];
            ?>

				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['booknums'];
            ?>

				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['it_stock'];
            ?>

				</td>
				<td class="bor-top" style="color:green">
					<?php 
            echo ceil($_smarty_tpl->tpl_vars['list']->value['purchaseDays'] * $_smarty_tpl->tpl_vars['list']->value['everyday_sale']);
            ?>

				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['everyday_sale'] * 30;
            ?>

				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['goodsWeight'];
            ?>

				</td>
				<td class="bor-top">
					<?php 
            if ($_smarty_tpl->tpl_vars['list']->value['goodsStatus'] == 1) {
                ?>
在线<?php 
            } elseif ($_smarty_tpl->tpl_vars['list']->value['goodsStatus'] == 2) {
                ?>
下线<?php 
            } elseif ($_smarty_tpl->tpl_vars['list']->value['goodsStatus'] == 3) {
                ?>
零库存<?php 
            } elseif ($_smarty_tpl->tpl_vars['list']->value['goodsStatus'] == 4) {
                ?>
停售<?php 
            } elseif ($_smarty_tpl->tpl_vars['list']->value['goodsStatus'] == 5) {
                ?>
部分平台下线<?php 
            }
            ?>
				</td>
				<td class="bor-top">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['global_user_name'];
            ?>

				</td>
			</tr>
			<tr <?php 
            if ($_smarty_tpl->getVariable('smarty')->value['foreach']['foo']['iteration'] % 2 == 0) {
                ?>
style="background-color:#f2f2f2;"<?php 
            }
            ?>
>
				<td  colspan="7">
					<?php 
            echo $_smarty_tpl->tpl_vars['list']->value['goodsName'];
            ?>

				</td>
				<td colspan="2">

				</td>
				<?php 
            $_smarty_tpl->tpl_vars['ptlist'] = new Smarty_variable(CommonModel::getSkuPartner($_smarty_tpl->tpl_vars['list']->value['sku']), null, 0);
            ?>
				<td colspan="7">
					
				</td>
				<td>
				</td>
				<td colspan="5">
					供应商:<?php 
            $_smarty_tpl->tpl_vars['pt'] = new Smarty_Variable();
            $_smarty_tpl->tpl_vars['pt']->_loop = false;
            $_from = $_smarty_tpl->tpl_vars['ptlist']->value;
            if (!is_array($_from) && !is_object($_from)) {
                settype($_from, 'array');
            }
            foreach ($_from as $_smarty_tpl->tpl_vars['pt']->key => $_smarty_tpl->tpl_vars['pt']->value) {
                $_smarty_tpl->tpl_vars['pt']->_loop = true;
                echo $_smarty_tpl->tpl_vars['pt']->value['company_name'];
            }
            ?>
				</td>
			</tr>
			<?php 
        }
        ?>

		</tbody>
	</table>
<div>
<div class="bottomvar">
<div class="pagination">
	<?php 
        echo $_smarty_tpl->tpl_vars['pageStr']->value;
        ?>

</div>
</div>

<input type="hidden" value="<?php 
        echo $_smarty_tpl->tpl_vars['_userid']->value;
        ?>
" id="userid" />
<?php 
        echo $_smarty_tpl->getSubTemplate("footer.htm", $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, null, null, array(), 0);
        ?>

<script type="text/javascript">


//搜索入口	
function search(){
	var type,key,pid,pcid,is_warn,flag,url,dailyNum;
	url		= "index.php?mod=productStockalarm&act=index";
	key   	= encodeURIComponent($.trim($("#key").val()));
	type	= $.trim($("#type").val());
	pid		= $.trim($("#pid").val());
	pcid  	= $.trim($("#pcid").val());
	flag  	= $.trim($("#flag").val());
	is_warn = $.trim($("#is_warn").val());
	dailyNum = $.trim($("#dailyNum").val());
	bookNum = $.trim($("#bookNum").val());
	if(type != -1 && key != ''){
		url += "&type="+type+"&key="+key;
	}
	if(flag != -1){
		url += "&status="+flag;
	}
	if(pid != -1){
		url += "&pid="+pid;
	}
	if(is_warn != -1){
		url += "&is_warn="+is_warn;
	}
	if(pcid !=-1){
		url += "&pcid="+pcid;
	}
	if(dailyNum != -1){
		url += "&dailyNum="+dailyNum;
	}
	if(bookNum != -1){
		url += "&bookNum="+bookNum;
	}

	window.location.href = url;
}
$("#search-btn").click(function() {
	search();
});
//全选入口
$("#inverse-check").click(function(){
	select_all("inverse-check","input[name='inverse']",0);
});
//生成采购订单
$("#createPur").click(function(){
	var skuArr , url,skulist = [];
	var skuArr 	= $('input[name="inverse"]:checked');
	if(skuArr.length == 0){
		alertify.alert('请选择需下订单的料号');
		return false;
	}else{
		$.each(skuArr ,function(i,item){
			var skuObj = {};
			skuObj.sku = $(item).val();
			skuObj.rec = $(item).data("rec"); //建议采购数量
			skulist.push(skuObj);
		});
	}
	var url  = "json.php?mod=purchaseOrder&act=createOrder";
	$.post(url, {"skulist":skulist}, function(rtn){
		console.log(rtn);

		var data = rtn.msg;
		alertify.alert('生成采购订单成功',function(){
			window.location.reload();
		});
		/*
		if(data == 'noPower'){
			alertify.alert('您不是采购员,没有权限生成采购订单');
		}else if(data == 'success'){
			alertify.alert('生成采购订单成功',function(){
				window.location.reload();
			});
		}else{
			alertify.alert('生成采购订单失败'+data.msg);
		}
		*/
	},'jsonp');
});

$("#pl-partner").click(function(){
		var skulist,partner,url; 
		skulist = getSkuList();
		partnerId = $("#pid").val();
	    url  = "json.php?mod=purchaseOrder&act=updatePartner";
		if(skulist.length == 0 || partnerId == -1){
			alertify.alert('请选择需要更新供应商的料号 and 供应商。。。');
		}else{
			$.post(url,{"skulist":skulist,"partnerId":partnerId},function(rtn){
				//console.log(rtn);
				alertify.alert('批量更新供应商成功。。。',function(){
					window.location.reload();
				});
			});
		}
});

//新更新缓存
$("#updateCache1").click(function(){
	var url  	= "json.php?mod=productStockalarm&act=updateWarnNew";
	var skuArr 	= $('input[name="inverse"]:checked'), sku = "", tips = "", errmsg = "";
	if (skuArr.length == 0) {
		alertify.alert('请选择需要更新缓存的料号');
		return false;
	}
	tips	= "<span id='label-tips' style='line-height:180%;font-size:14px;'></span>";
	alertify.alert(tips);
	$("#aOK").hide();
	var curid = isok = iserr = 0;
	$.each (skuArr,function(i,item) {
		sku = $(item).val();
		$("#label-tips").html("正在批更新料号缓存,请稍候...<br/>处理期间,请不要关闭或刷新当前页面,谢谢配合!");
		$.post (url, {"sku":sku}, function(rtn) {
			if (rtn.errCode=='0') {
				$("#label-tips").html(rtn.data);
			} else {
				$("#label-tips").html(rtn.errMsg);
				iserr++
			}
			if (curid==(skuArr.length-1)) {
				$("#aOK").show().click(function(){
					window.location.reload();
				});
			}
			if (iserr>0) {
				errmsg	= "   一共失败: "+iserr+" 个料号";
			}
			$("#label-tips").html($("#label-tips").html()+"<br/>处理进度:"+ ((curid+1) +" / "+skuArr.length)+errmsg);
			curid++
		},'jsonp');
	});	
});


$("#updateCache").click(function(){
	var data,url = "json.php?mod=Common&act=updateCache";
	$(this).html("更新中。。。");
	$(this).attr("disabled","disabled");
	data = getSkuList();
	$.post(url,{"data":data},function(rtn){
		console.log(rtn);
		window.location.reload();
	});
});

function getSkuList(){
	var skuArr , skulist = [];
	var skuArr 	= $('input[name="inverse"]:checked');
	if(skuArr.length != 0){
		$.each(skuArr ,function(i,item){
			var sku = $(item).val();
			skulist.push(sku);
		});
	}
	return skulist;
}

$("#stop-sale").click(function(){//暂时停售
		var skuArr = getSkuList();
		if(skuArr.length == 0){
			alertify.alert('请选择需要暂时停售的料号,这个操作日均量将不会更新');
			return;
		}
		changeSkuStatus(skuArr,2);
});

$("#forever-stop-sale").click(function(){//永久停售
		var skuArr = getSkuList();
		if(skuArr.length == 0){
			alertify.alert('请选择需要永久停售的料号,这个操作日均量将不会更新');
			return;
		}
		changeSkuStatus(skuArr,3);
});

$("#begin-sale").click(function(){//开始上线销售
		var skuArr = getSkuList();
		if(skuArr.length == 0){
			alertify.alert('请选择需要上线销售的料号');
			return;
		}
		changeSkuStatus(skuArr,1);
});

function changeSkuStatus(skuArr,status){ //记录sku 在采购系统中的状态
	var url = "json.php?mod=sku&act=changeSkuStatus";
	$.post(url,{"skuArr":skuArr,"status":status},function(rtn){
			console.log(rtn);
			if($.inArray(0,rtn) == -1){
				alertify.alert("操作成功。。。。",function(){
					window.location.reload();
				});
			}else{
			alertify.alert("操作failed。。。。。",function(){
				window.location.reload();
			});
			}
	},"json");
}

$("#getSkuData").click(function(){
	$(this).html("更新中。。。");
	$(this).attr("disabled","disabled");
	var data,url = "json.php?mod=Common&act=getSkuData",purchaseUser;
	data = getSkuList();
	purchaseUser = $("#pcid  option:selected").text();
	$.post(url,{"data":data,"purchaseUser":purchaseUser},function(rtn){
		console.log(rtn);
		if(rtn == 1){
			window.location.reload();
		}
	});
});

$("#checkAlert").click(function(){
	var data,url = "json.php?mod=Common&act=calcAlert";
	$(this).html("更新中。。。");
	$(this).attr("disabled","disabled");
	data = getSkuList();
	$.post(url,{"data":data},function(rtn){
		console.log(rtn);
		window.location.reload();
	});
});

window.onkeyup = function(e) {
	if(e.keyCode == 13) {
		search();
	}
}


</script>
<?php 
    }