/** * 获取可用库存及天数 */ 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()); }
/** * 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"; } } }
/*$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;
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>'; } }
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 »', ktz_theme_textdomain); $pagenavi_options['prev_text'] = __('« 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"; } } }
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'); }
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; }
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 {
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} 扫描用户 > {$op_name} 所属包裹> {$value['packageId']} 所属分区 > {$value['partionId']} 包裹打包状态 > {$pack_status} 包裹总重 > {$weight} 包裹总数量 > {$value['totalNum']} 订单扫描日期 > {$scantime}<br>"; } return $show; } }
/** * 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();
/** * 独立商城订单导入页面 */ 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; } }
//淘宝产品标价 $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];
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; }
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; }
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 »'; $pagenavi_options['prev_text'] = '« 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"; } } }
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; }
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> >> <?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 }