private void delivery(Connection conn) throws Exception {
String sql =
"select a.sheetid,b.tid, upper(ltrim(rtrim(b.companycode))) companycode,"
+ "upper(ltrim(rtrim(b.outsid))) outsid from it_upnote a with(nolock), ns_delivery b with(nolock)"
+ "where a.sheettype=3 and a.sheetid=b.sheetid and a.receiver='"
+ Params.tradecontactid
+ "' and b.iswait=0";
Vector vdeliveryorder = SQLHelper.multiRowSelect(conn, sql);
Log.info(username, " 本次要处理的淘宝发货条数为: " + vdeliveryorder.size(), null);
for (int i = 0; i < vdeliveryorder.size(); i++) {
Hashtable hto = (Hashtable) vdeliveryorder.get(i);
String sheetid = hto.get("sheetid") != null ? hto.get("sheetid").toString() : "";
String orderid = hto.get("tid") != null ? hto.get("tid").toString() : "";
String post_company = hto.get("companycode") != null ? hto.get("companycode").toString() : "";
String post_no = hto.get("outsid") != null ? hto.get("outsid").toString() : "";
// 如果物流公司为空则忽略处理
if (post_company.trim().equals("")) {
Log.warn(username, jobName + " 快递公司为空！订单号:" + orderid, null);
continue;
}
// 如果物流公司为空则忽略处理
if (post_no.trim().equals("")) {
Log.warn(username, "快递单号为空！订单号:" + orderid, null);
continue;
}
if (!StringUtil.isNumeric(orderid)) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
Log.warn(username, jobName + ",订单号【" + orderid + "】不全是数字!", null);
continue;
}
if ("1".equals(Params.isJZ)) {
sql = "select top 1 lbpdc from ns_customerorder where tid='" + orderid + "'";
String isJz = SQLHelper.strSelect(conn, sql);
if ("zj".equals(isJz)) { // 家装订单
// jzSend(post_no,orderid,post_company,conn,sheetid);
Log.info(username, "家装订单暂时不发货: 订单号: " + orderid, null);
} else normalSend(post_no, orderid, post_company, conn, sheetid);
} else normalSend(post_no, orderid, post_company, conn, sheetid);
}
}
public void run() {
// TODO Auto-generated method stub
Connection conn = null;
try {
conn = PoolHelper.getInstance().getConnection("shop");
delivery(conn);
} catch (Exception e) {
try {
if (conn != null && !conn.getAutoCommit()) conn.rollback();
conn.setAutoCommit(true);
} catch (SQLException e1) {
// TODO Auto-generated catch block
Log.error(username, "关闭数据库事务出错 " + e1.getMessage(), null);
}
Log.info(username, "发货线程错误: " + e.getMessage(), null);
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
Log.error(username, "关闭数据库连接出错: " + e.getMessage(), null);
}
watch.countDown();
}
}
@Override
public void process() throws Exception {
Document doc = DOMHelper.newDocument(this.getBizdata(), "gbk");
Element ele = doc.getDocumentElement();
Element dtcFlow = DOMHelper.getSubElementsByName(ele, "DTCFlow")[0];
Element paymentElement = DOMHelper.getSubElementsByName(dtcFlow, "PAYMENT_INFO_FB")[0];
String statusCode = DOMHelper.getSubElementVauleByName(paymentElement, "STATUS_CODE");
String paymentNumber = DOMHelper.getSubElementVauleByName(paymentElement, "PAYMENT_NO");
Log.info("支付单回执数据处理成功,支付号: " + paymentNumber + " 支付单状态码: " + statusCode);
}
private void sendTradeInfo(List sheetids, Connection conn) throws Exception {
Vector<Hashtable> tradeInfo = new Vector();
String sql = "";
boolean isSuccess = false;
for (int i = 0; i < sheetids.size(); i++) {
try {
String sheetid = (String) sheetids.get(i);
sql =
"select tid,actiontime,operator,status,remark from ns_tradetrace where sheetid='"
+ sheetid
+ "'";
tradeInfo = SQLHelper.multiRowSelect(conn, sql);
for (Iterator it = tradeInfo.iterator(); it.hasNext(); ) {
Hashtable tab = (Hashtable) it.next();
isSuccess = sendSingleInfo(tab);
}
if (isSuccess) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 6";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=6";
SQLHelper.executeSQL(conn, sql);
Log.info(username, "处理淘宝订单跟踪信息,sheetid:【" + sheetid + "】成功", null);
} else {
Log.info(username, "处理淘宝订单跟踪信息,sheetid:【" + sheetid + "】失败", null);
}
} catch (Exception e) {
Log.error(username, "同步订单跟踪信息出错 " + e.getMessage(), null);
continue;
}
}
}
// ²éѯÉÌÆ·¿â´æ
public static void queryItemStock() throws Exception {
String goodsId = "";
String skuId = "";
String outerId = "";
String service = "subSyncItemStockInfo";
HashMap<String, String> map = new HashMap<String, String>();
map.put("goodsId", goodsId);
map.put("skuId", skuId);
map.put("outerId", outerId);
String bizData = new JSONObject(map).toString();
String sign = JwUtil.makeSign(bizData);
Map requestParams = JwUtil.makeRequestParams(bizData, service, appkey, format, sign);
String result = CommHelper.sendRequest(url, requestParams, "");
Log.info("result: " + result);
}
// ²éѯ¶©µ¥×´Ì¬
public static void queryOrderStatus() throws Exception {
String orderCode = "";
String platFormName = "";
String shopName = "";
String service = "subQueryOrderState";
HashMap<String, String> map = new HashMap<String, String>();
map.put("orderCode", orderCode);
map.put("platFormName", platFormName);
map.put("shopName", shopName);
String bizData = new JSONObject(map).toString();
String sign = JwUtil.makeSign(bizData);
Map requestParams = JwUtil.makeRequestParams(bizData, service, appkey, format, sign);
String result = CommHelper.sendRequest(url, requestParams, "");
Log.info("result: " + result);
}
public void run() {
Log.info(jobname, "启动[" + jobname + "]模块");
do {
Connection connection = null;
is_importing = true;
try {
connection =
PoolHelper.getInstance().getConnection(com.wofu.ecommerce.taobao.Params.dbname);
lasttime =
PublicUtils.getConfig(
connection,
lasttimeconfvalue,
Formatter.format(new Date(), Formatter.DATE_TIME_FORMAT));
getRefundBillList(connection);
} catch (Exception e) {
try {
if (connection != null && !connection.getAutoCommit()) connection.rollback();
} catch (Exception e1) {
Log.error(jobname, "回滚事务失败");
}
Log.error("105", jobname, Log.getErrorMessage(e));
} finally {
is_importing = false;
try {
if (connection != null) connection.close();
} catch (Exception e) {
Log.error(jobname, "关闭数据库连接失败");
}
}
System.gc();
long startwaittime = System.currentTimeMillis();
while (System.currentTimeMillis() - startwaittime
< (long) (com.wofu.ecommerce.taobao.Params.waittime * 1000))
try {
sleep(1000L);
} catch (Exception e) {
Log.warn(jobname, "系统不支持休眠操作, 作业将严重影响机器性能");
}
} while (true);
}
public void run() {
Log.info(jobname, "启动[" + jobname + "]模块");
do {
Connection connection = null;
is_exporting = true;
try {
connection = PoolHelper.getInstance().getConnection(Params.dbname);
delivery(connection);
// modifiRemark(connection);
} catch (Exception e) {
try {
if (connection != null && !connection.getAutoCommit()) connection.rollback();
} catch (Exception e1) {
Log.error(jobname, "回滚事务失败");
}
Log.error("105", jobname, Log.getErrorMessage(e));
} finally {
is_exporting = false;
try {
if (connection != null) connection.close();
} catch (Exception e) {
Log.error(jobname, "关闭数据库连接失败");
}
}
System.gc();
long startwaittime = System.currentTimeMillis();
while (System.currentTimeMillis() - startwaittime < (long) (Params.waittime * 1000))
try {
sleep(1000L);
} catch (Exception e) {
Log.warn(jobname, "系统不支持休眠操作, 作业将严重影响机器性能");
}
} while (true);
}
public void run() {
Log.info(jobName, "启动[" + jobName + "]模块");
do {
Connection connection = null;
try {
connection = PoolHelper.getInstance().getConnection(com.wofu.ecommerce.ylw.Params.dbname);
getRefund(connection);
} catch (Exception e) {
try {
e.printStackTrace();
if (connection != null && !connection.getAutoCommit()) connection.rollback();
} catch (Exception e1) {
Log.error(jobName, "回滚事务失败");
}
Log.error("105", jobName, Log.getErrorMessage(e));
} finally {
try {
if (connection != null) connection.close();
} catch (Exception e) {
Log.error(jobName, "关闭数据库连接失败");
}
}
System.gc();
long startwaittime = System.currentTimeMillis();
while (System.currentTimeMillis() - startwaittime
< (long) (Params.waittime * 1000 * Params.timeInterval))
try {
sleep(1000L);
} catch (Exception e) {
Log.warn(jobName, "系统不支持休眠操作, 作业将严重影响机器性能");
}
} while (true);
}
// 修改订单备注
private void modifiRemark(Connection conn) throws Exception {
String sql =
"select sheetid,sender from it_upnote where sheettype=5 and flag=0 and receiver='"
+ Params.tradecontactid
+ "'";
Vector modifiReList = SQLHelper.multiRowSelect(conn, sql);
if (modifiReList.size() == 0) return;
for (int i = 0; i < modifiReList.size(); i++) {
try {
Hashtable item = (Hashtable) modifiReList.get(i);
String sheetid = item.get("sheetid").toString();
String sender = item.get("sender").toString();
String[] remarks = sender.split(":");
// 订单号
String tid = remarks[0];
// 备注
String remark = remarks[1];
Map<String, String> params = new HashMap<String, String>();
// 系统级参数设置
params.put("appKey", Params.app_id);
params.put("sessionKey", Params.token);
params.put("format", Params.format);
params.put("method", "yhd.order.merchant.remark.update");
params.put("ver", Params.ver);
params.put("timestamp", Formatter.format(new Date(), Formatter.DATE_TIME_FORMAT));
params.put("orderCode", tid);
params.put("remark", remark);
String response = Utils.sendByPost(params, Params.AppSecret, Params.url);
// Log.info("修改备注: "+response);
JSONObject responseCount = new JSONObject(response);
if (0 == (responseCount.getJSONObject("response").getInt("errorCount"))) {
try {
conn.setAutoCommit(false);
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 5";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=5";
SQLHelper.executeSQL(conn, sql);
conn.commit();
conn.setAutoCommit(true);
Log.info(jobname, "处理订单【" + tid + "】 sheetid【" + sheetid + "】 修改备注成功");
} catch (Exception ex) {
if (!conn.getAutoCommit()) {
try {
conn.rollback();
} catch (Exception el) {
}
}
try {
conn.setAutoCommit(true);
} catch (Exception es) {
}
throw new Exception("事务回滚失败！");
}
} else {
Log.info(jobname, "处理订单【" + tid + "】 sheetid【" + sheetid + "】 修改备注失败");
}
} catch (Exception ex) {
Log.error(jobname, ex.getMessage());
}
}
Log.info(jobname + ",修改订单备注完成");
}
public void run() {
Log.info(jobname, "启动[" + jobname + "]模块");
do {
Connection conn = null;
try {
conn = PoolHelper.getInstance().getConnection(Params.dbname);
Holder ask = new Holder();
Holder message = new Holder();
Holder error = new Holder();
HeaderRequest request = new HeaderRequest();
request.setAppKey(Params.Key);
request.setAppToken(Params.Token);
request.setCustomerCode(Params.customercode);
ServiceForProduct_Service service = new ServiceForProduct_Service();
ServiceForProduct info = service.getServiceForProductSOAP();
// 取得要处理的数据的单号 这个单号对应barcodetranlist的sheetid
Vector infsheetlist = FedexUtil.getInfDownNote(conn, "9901");
// 每一个单号发送一次请求
for (Iterator it = infsheetlist.iterator(); it.hasNext(); ) {
Hashtable ht = (Hashtable) it.next();
String sheetid = ht.get("OperData").toString();
Integer serialid = (Integer) ht.get("SerialID");
Log.info("sheetid: " + sheetid);
// skuCategory 产品分类 这个还没有表数据关联的
String sql =
" select CustomBC skuNo,g.Name skuName, g.Name skuEnName,rtrim(d.skuCategory) as skuCategory,g.customno,g.deptid, isnull(g.postTaxNo,'"
+ "GDO51311409230000003') applyEnterpriseCode,u.uom UOM ,0 barcodeType,substring(Spec,1,128) "
+ "specificationsAndModels,hsCode,g.Price productDeclaredValue,g.Name hsGoodsName,b.applyEnterpriseCodeCIQ,"
+ "cc.code originCountry,br.name brand,case when isnull(Weigh,1000)/1000<1 then 1 else isnull(Weigh,1000)"
+ "/1000 end as weight ,case when isnull(NetWeigh,1000)/1000<1 then 1 else isnull(NetWeigh,1000)/1000 end as netWeight"
+ " from BarcodeTranList a , Barcode b , Merchandise g , PostTariff p,unit u,"
+ "countrycode cc ,dept d ,brand br where a.BarcodeID = b.BarcodeID and b.MID = g.MID and g.unitname="
+ "u.unitname and cc.name=g.origin and g.PostTaxNo = p.Code and d.deptid=g.deptid and g.brandid=br.BrandID and SheetID = '"
+ sheetid
+ "'";
boolean isSuccess = false;
Vector vtsku = SQLHelper.multiRowSelect(conn, sql);
for (int i = 0; i < vtsku.size(); i++) {
Hashtable htsku = (Hashtable) vtsku.get(i);
ProductInfo productInfo = new ProductInfo();
productInfo.getMapData(htsku);
info.createProduct(request, productInfo, ask, message, error);
if ("1".equals(ask.value)) {
isSuccess = true;
/*
conn.setAutoCommit(false);
FedexUtil.bakcUpDownNote(conn,serialid);
conn.commit();
conn.setAutoCommit(true);
**/
Log.info("添加商品成功,sku: " + productInfo.getSkuNo());
} else {
isSuccess = false;
Log.info("上传商品数据失败: " + message.value);
List<ErrorType> type = (List<ErrorType>) error.value;
for (Iterator t = type.iterator(); t.hasNext(); ) {
ErrorType err = (ErrorType) t.next();
Log.info("上传商品数据失败: " + err.getErrorMessage());
}
}
}
if (isSuccess) { // 处理成功备份接口数据
conn.setAutoCommit(false);
FedexUtil.bakcUpDownNote(conn, serialid);
conn.commit();
conn.setAutoCommit(true);
}
}
} catch (Exception e) {
try {
if (conn != null && !conn.getAutoCommit()) {
conn.rollback();
conn.setAutoCommit(true);
}
} catch (Exception e1) {
Log.error(jobname, "回滚事务失败");
}
e.printStackTrace();
Log.error("105", jobname, Log.getErrorMessage(e));
} finally {
try {
if (conn != null) conn.close();
} catch (Exception e) {
Log.error(jobname, "关闭数据库连接失败");
}
}
System.gc();
long startwaittime = System.currentTimeMillis();
while (System.currentTimeMillis() - startwaittime < (long) (Params.waittime * 1000))
try {
sleep(1000L);
} catch (Exception e) {
Log.warn(jobname, "系统不支持休眠操作, 作业将严重影响机器性能");
}
} while (true);
}
public void getRefund(Connection conn) throws Exception {
String resultText = "";
for (int k = 0; k < 5; ) {
try {
// 获取到退货订单号
String apiMethod = "suning.custom.batchrejectedOrd.query";
HashMap<String, String> reqMap = new HashMap<String, String>();
reqMap.put(
"startTime",
Formatter.format(
new Date(System.currentTimeMillis() - daymillis), Formatter.DATE_TIME_FORMAT));
reqMap.put("endTime", Formatter.format(new Date(), Formatter.DATE_TIME_FORMAT));
HashMap<String, String> map = new HashMap<String, String>();
map.put("appSecret", Params.appsecret);
map.put("appMethod", apiMethod);
map.put("format", Params.format);
map.put("versionNo", "v1.2");
map.put("appKey", Params.appKey);
// 发送请求
String responseText = CommHelper.doRequest(map, Params.url);
Log.info("退换货数据: " + responseText);
// 把返回的数据转成json对象
JSONObject responseObj = new JSONObject(responseText).getJSONObject("sn_responseContent");
// 错误对象
if (responseText.indexOf("sn_error") != -1) { // 发生错误
String operCode = responseObj.getJSONObject("sn_error").getString("error_code");
if (!"".equals(operCode)) {
Log.error("苏宁获取退货订单", "获取退货订单失败,operCode:" + operCode);
}
return;
}
JSONArray ReturnCodeList =
responseObj.getJSONObject("sn_body").getJSONArray("batchQueryRejectedOrd");
for (int i = 0; i < ReturnCodeList.length(); i++) {
try {
String orderCode = ReturnCodeList.getJSONObject(i).getString("orderCode");
Order o = new Order();
OrderUtils.createRefundOrder(
"生成苏宁退换货接口订单",
conn,
Params.tradecontactid,
o,
Params.url,
Params.appKey,
Params.appsecret,
Params.format);
} catch (Exception ex) {
if (conn != null && !conn.getAutoCommit()) {
conn.rollback();
}
Log.error(jobName, ex.getMessage());
continue;
}
}
break;
} catch (Exception e) {
if (++k >= 5) throw e;
if (conn != null && !conn.getAutoCommit()) {
conn.rollback();
}
Log.warn(jobName + " ,远程连接失败[" + k + "], 10秒后自动重试. " + Log.getErrorMessage(e));
Thread.sleep(10000L);
}
}
}
private void getInStockItems() throws Exception {
int pageno = 1;
Log.info("开始取一号店仓库商品资料");
String sql =
"select orgid from ecs_tradecontactorgcontrast with(nolock) where tradecontactid="
+ tradecontactid;
int orgid = this.getDao().intSelect(sql);
for (int k = 0; k < 10; ) {
try {
while (true) {
Map<String, String> productparams = new HashMap<String, String>();
// 系统级参数设置
productparams.put("appKey", app_key);
productparams.put("sessionKey", token);
productparams.put("format", format);
productparams.put("method", "yhd.serial.products.search");
productparams.put("ver", ver);
productparams.put("timestamp", Formatter.format(new Date(), Formatter.DATE_TIME_FORMAT));
productparams.put("canShow", "1");
productparams.put("canSale", "0");
productparams.put("curPage", String.valueOf(pageno));
productparams.put("pageRows", "20");
productparams.put("verifyFlg", "2");
String responseProductData = Utils.sendByPost(productparams, app_secret, url, "");
Log.info("取仓库商品返回数据: " + responseProductData);
JSONObject responseproduct = new JSONObject(responseProductData);
int totalCount = responseproduct.getJSONObject("response").getInt("totalCount");
JSONArray productlist =
responseproduct
.getJSONObject("response")
.getJSONObject("serialProductList")
.getJSONArray("serialProduct");
for (int i = 0; i < productlist.length(); i++) {
JSONObject product = productlist.getJSONObject(i);
long productId = product.optLong("productId");
String productCode = product.optString("productCode");
String productCname = product.optString("productCname");
Log.info("货号:" + productCode + ",产品名称:" + productCname);
StockManager.stockConfig(
this.getDao(),
orgid,
Integer.valueOf(tradecontactid),
String.valueOf(productId),
productCode,
productCname,
0);
Map<String, String> stockparams = new HashMap<String, String>();
// 系统级参数设置
stockparams.put("appKey", app_key);
stockparams.put("sessionKey", token);
stockparams.put("format", format);
stockparams.put("method", "yhd.serial.product.get");
stockparams.put("ver", ver);
stockparams.put("timestamp", Formatter.format(new Date(), Formatter.DATE_TIME_FORMAT));
stockparams.put("productId", String.valueOf(productId));
String responseData = Utils.sendByPost(stockparams, app_secret, url, "");
Log.info("取仓库商品详情返回数据: " + responseData);
JSONObject responsestock = new JSONObject(responseData);
JSONArray childseriallist =
responsestock
.getJSONObject("response")
.getJSONObject("serialChildProdList")
.getJSONArray("serialChildProd");
for (int m = 0; m < childseriallist.length(); m++) {
JSONObject childserial = childseriallist.optJSONObject(m);
String sku = childserial.optString("outerId");
long skuid = childserial.optLong("productId");
JSONArray stocklist =
childserial.getJSONObject("allWareHouseStocList").getJSONArray("pmStockInfo");
for (int j = 0; j < stocklist.length(); j++) {
JSONObject stock = stocklist.optJSONObject(j);
int quantity = stock.optInt("vs");
long warehouseId = stock.optLong("warehouseId");
StockManager.addStockConfigSku(
this.getDao(),
Integer.valueOf(tradecontactid),
String.valueOf(productId),
String.valueOf(skuid) + "-" + String.valueOf(warehouseId),
sku,
quantity);
}
}
}
// 判断是否有下一页
if (pageno == (Double.valueOf(Math.ceil(totalCount / 20.0))).intValue()) break;
pageno++;
}
break;
} catch (Exception e) {
if (++k >= 10) throw e;
Log.warn(jobName + ", 远程连接失败[" + k + "], 10秒后自动重试. " + Log.getErrorMessage(e));
Thread.sleep(10000L);
}
}
}
// 家装订单发货
private void jzSend(
String post_no, String orderid, String post_company, Connection conn, String sheetid) {
try {
TaobaoClient client = new DefaultTaobaoClient(Params.url, Params.appkey, Params.appsecret);
WlbOrderJzwithinsConsignRequest req = new WlbOrderJzwithinsConsignRequest();
req.setTid(TranTid(orderid));
JSONObject obj = new JSONObject();
obj.put("mail_no ", post_no);
obj.put("zy_company ", post_company);
req.setTmsPartner(obj.toString());
JSONArray arr = new JSONArray(Params.jzParams);
WlbOrderJzwithinsConsignResponse rsp;
for (int i = 0; i < arr.length(); i++) {
req.setInsPartner(arr.get(i).toString());
rsp = client.execute(req, Params.authcode);
String sql;
if (rsp.isSuccess()) {
try {
conn.setAutoCommit(false);
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
conn.commit();
conn.setAutoCommit(true);
} catch (SQLException sqle) {
if (!conn.getAutoCommit())
try {
conn.rollback();
} catch (Exception e1) {
}
try {
conn.setAutoCommit(true);
} catch (Exception e1) {
}
// throw new JSQLException(sql, sqle);
}
Log.info(
username,
"处理订单【" + orderid + "】发货成功,快递公司【" + post_company + "】,快递单号【" + post_no + "】",
null);
Log.info(username, "家装发货参数: " + arr.get(i).toString(), null);
break;
} else {
Log.info(username, "家装订单发货失败,错误信息: " + rsp.getResultInfo(), null);
continue;
}
}
} catch (ApiException e) {
Log.error(
username,
"处理订单【"
+ orderid
+ "】发货失败,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】,错误信息:"
+ e.getMessage(),
null);
} catch (Exception e) {
Log.error(username, "同步发货状态出错了, 错误信息: " + e.getMessage(), null);
}
}
private void synStock() throws Exception {
// 店铺同步比例
double synrate = 1;
Log.info(username, "开始同步商品库存");
StringBuffer updateItemsXML = new StringBuffer();
String sql =
"select orgid from ecs_tradecontactorgcontrast with(nolock) where tradecontactid="
+ tradecontactid;
int orgid = this.getDao().intSelect(sql);
sql = "update ecs_stockconfig set errflag=0,errmsg='' where orgid=" + orgid;
this.getDao().execute(sql);
sql = "update ecs_stockconfigsku set errflag=0,errmsg='' where orgid=" + orgid;
this.getDao().execute(sql);
// 店铺同步比例表
sql = "select synrate from ecs_shopglobalconfig where shopOrgId=" + orgid;
String temp = this.getDao().strSelect(sql);
if (!"".equals(temp)) synrate = Float.parseFloat(temp);
int n = 0;
for (int k = 0; k < 10; ) {
try {
sql = "select * from ecs_stockconfig with(nolock) where orgid=" + orgid;
Vector vtstockconfig = this.getDao().multiRowSelect(sql);
for (int i = 0; i < vtstockconfig.size(); i++) {
try {
Hashtable htstockconfig = (Hashtable) vtstockconfig.get(i);
ECS_StockConfig stockconfig = new ECS_StockConfig();
stockconfig.getMapData(htstockconfig);
String itemid = stockconfig.getItemid();
Log.info("商品ID:" + stockconfig.getItemid() + " 货号:" + stockconfig.getItemcode());
if (stockconfig.getIsneedsyn() == 0) {
Log.info(username, "配置不需要同步库存,货号:" + stockconfig.getItemcode());
continue; // 不需要同步
}
sql =
"select * from ecs_stockconfigsku with(nolock) where orgid="
+ orgid
+ " and itemid='"
+ stockconfig.getItemid()
+ "'";
Vector vtstockconfigsku = this.getDao().multiRowSelect(sql);
for (int j = 0; j < vtstockconfigsku.size(); j++) {
try {
Hashtable htstockconfigsku = (Hashtable) vtstockconfigsku.get(j);
ECS_StockConfigSku stockconfigsku = new ECS_StockConfigSku();
stockconfigsku.getMapData(htstockconfigsku);
Log.info(
username,
"SKU:" + stockconfigsku.getSku() + " 原库存:" + stockconfigsku.getStockcount());
boolean ismulti = false;
boolean isfind = true;
sql =
"select count(*) from barcode with(nolock) where custombc='"
+ stockconfigsku.getSku()
+ "'";
if (this.getDao().intSelect(sql) == 0) {
sql =
"select count(*) from MultiSKURef where refcustomercode='"
+ stockconfigsku.getSku()
+ "'";
if (this.getDao().intSelect(sql) == 0) {
Log.warn(
username,
"找不到SKU【"
+ stockconfigsku.getSku()
+ "】对应的条码,商品标题:"
+ stockconfig.getTitle());
stockconfigsku.setErrflag(1);
stockconfigsku.setErrmsg("找不到SKU【" + stockconfigsku.getSku() + "】对应的条码");
this.getDao().updateByKeys(stockconfigsku, "orgid,itemid,skuid");
stockconfig.setErrflag(1);
stockconfig.setErrmsg("找不到SKU【" + stockconfigsku.getSku() + "】对应的条码");
this.getDao().updateByKeys(stockconfig, "orgid,itemid");
isfind = false;
continue;
} else ismulti = true;
}
int qty = 0;
if (isfind) {
if (ismulti) {
int minqty = 1000000;
sql =
"select customercode,qty from MultiSKURef where refcustomercode='"
+ stockconfigsku.getSku()
+ "'";
Vector multiskulist = this.getDao().multiRowSelect(sql);
for (Iterator itmulti = multiskulist.iterator(); itmulti.hasNext(); ) {
Hashtable skuref = (Hashtable) itmulti.next();
String customercode = skuref.get("customercode").toString();
double skurefqty = Double.valueOf(skuref.get("qty").toString()).doubleValue();
qty =
StockManager.getTradeContactUseableStock(
this.getDao().getConnection(),
Integer.valueOf(tradecontactid).intValue(),
customercode);
qty = (Double.valueOf(Math.ceil(qty / skurefqty))).intValue();
if (qty < minqty) {
minqty = qty;
}
}
qty = minqty;
} else {
qty =
StockManager.getTradeContactUseableStock(
this.getDao().getConnection(),
Integer.valueOf(tradecontactid).intValue(),
stockconfigsku.getSku());
}
if (qty < 0) qty = 0;
}
int addstockqty = 0;
if (Math.abs(stockconfig.getAddstockqty()) < 1)
addstockqty =
Double.valueOf(Math.floor(qty * stockconfig.getAddstockqty())).intValue();
else addstockqty = Double.valueOf(stockconfig.getAddstockqty()).intValue();
// 如果可用库存加上需增加的库存小于等于警戒库存,则将库存同步为0
if ((qty + addstockqty) <= stockconfig.getAlarmqty()) {
qty = 0;
} else {
qty = qty + addstockqty;
}
Log.info("old qty: " + qty);
qty = Double.valueOf(Math.floor(qty * synrate)).intValue();
Log.info("new qty: " + qty);
// 更新库存开始
StockUtils.UpdateSkuStock(
this.getDao(),
orgid,
url,
app_id,
secret,
session,
stockconfigsku.getSku(),
qty,
stockconfig,
stockconfigsku);
} catch (Exception ex) {
if (this.getConnection() != null && !this.getConnection().getAutoCommit())
this.getConnection().rollback();
if (this.getExtconnection() != null && !this.getExtconnection().getAutoCommit())
this.getExtconnection().rollback();
Log.error(jobName, ex.getMessage());
}
}
k = 0;
} catch (Exception ex) {
if (this.getConnection() != null && !this.getConnection().getAutoCommit())
this.getConnection().rollback();
if (this.getExtconnection() != null && !this.getExtconnection().getAutoCommit())
this.getExtconnection().rollback();
Log.error(jobName, ex.getMessage());
}
}
break;
} catch (Exception e) {
if (++k >= 10) throw e;
if (this.getConnection() != null && !this.getConnection().getAutoCommit())
this.getConnection().rollback();
if (this.getExtconnection() != null && !this.getExtconnection().getAutoCommit())
this.getExtconnection().rollback();
Log.warn(jobName + ", 远程连接失败[" + k + "], 10秒后自动重试. " + Log.getErrorMessage(e));
Thread.sleep(10000L);
}
}
}
// 检查取消订单 4 取消
private void checkCancleOrders() throws Exception {
int pageIndex = 1;
boolean hasNextPage = true;
for (int k = 0; k < 10; ) {
try {
int n = 1;
while (hasNextPage) {
Date enddate = new Date();
Date startdate = new Date(new Date().getTime() - daymillis);
// 方法名
String apimethod = "search_order_list";
HashMap<String, Object> reqMap = new HashMap<String, Object>();
reqMap.put("last_modify_st_time", startdate.getTime() / 1000L);
reqMap.put("last_modify_en_time", enddate.getTime() / 1000L);
reqMap.put("pages", String.valueOf(pageIndex));
reqMap.put("counts", pageSize);
reqMap.put("return_data", "json");
reqMap.put("act", apimethod);
reqMap.put("api_version", "1.0");
Log.info("第" + pageIndex + "页");
String responseText = CommHelper.doRequest(reqMap, url);
Log.info("返回数据为: " + responseText);
// 把返回的数据转成json对象
JSONObject responseObj = new JSONObject(responseText);
// sn_error
if (!"success".equals(responseObj.getString("result"))) { // 发生错误
String operCode = responseObj.getJSONObject("sn_error").getString("error_code");
if ("biz.handler.data-get:no-result".equals(operCode)) { // 没有结果
Log.info("没有可用的订单!");
} else {
Log.warn("取订单出错了,错误码: " + operCode);
}
break;
}
JSONObject orderInfos = responseObj.getJSONObject("info");
// 总页数
String orderTotal = String.valueOf(orderInfos.getString("counts"));
int orderTotaltemp = Integer.parseInt(orderTotal);
int pageTotalTemp =
orderTotaltemp < Integer.parseInt(pageSize)
? 1
: orderTotaltemp / Integer.parseInt(pageSize) == 0
? Integer.parseInt(pageSize)
: orderTotaltemp / Integer.parseInt(pageSize) + 1;
String pageTotal = String.valueOf(pageTotalTemp);
Log.info("总订单数为： " + orderTotal);
Log.info("总页数为： " + pageTotal);
if (orderTotal == null || orderTotal.equals("") || orderTotal.equals("0")) {
break;
}
// 订单元素
JSONArray ordersList = orderInfos.getJSONArray("data_info");
for (int i = 0; i < ordersList.length(); i++) { // 某个订单
JSONObject orderInfo = ordersList.getJSONObject(i);
int returnOrderCount = 0;
// 订单编号
String orderCode = (String) orderInfo.get("order_sn");
if (orderInfo.isNull("shop_info")) continue;
// 订单商品集合
JSONArray items = orderInfo.getJSONArray("shop_info");
// 构造一个订单对象
Order o = new Order();
o.setObjValue(o, orderInfo);
o.setFieldValue(o, "shop_info", items);
Log.info("发货状态: " + o.getShipping_status() + "付款状态: " + o.getPay_status());
if (o != null) {
if ("4".equals(o.getPay_status())) { // 正常订单
Log.info("订单号: " + o.getOrder_sn());
// 如果是等待发货订单，创建接口订单成功，减少其它店的库存
try {
OrderUtils.createInterOrder(
this.getDao().getConnection(), o, tradecontactid, username);
} catch (SQLException sqle) {
throw new JException("生成退货订单出错!" + sqle.getMessage());
}
}
}
}
// 判断是否有下一页
if ("".equals(pageTotal) || pageTotal == null) pageTotal = "0";
if (pageIndex >= Integer.parseInt(pageTotal)) hasNextPage = false;
else pageIndex++;
n++;
}
break;
} catch (Exception e) {
e.printStackTrace();
if (++k >= 10) throw e;
if (this.getDao() != null && !this.getDao().getConnection().getAutoCommit()) {
this.getDao().rollback();
}
Log.warn(jobName + " ,远程连接失败[" + k + "], 10秒后自动重试. " + Log.getErrorMessage(e));
Thread.sleep(10000L);
}
}
Log.info("本次取ecshop退货订单任务处理完毕!");
}
/** 检查未入待发货订单 orderStatus=10 等待发货 这里检查一天时间的未入订单 */
public void checkWaitStockOutOrders() throws Exception {
Log.info(jobName + "任务开始!");
Connection conn = this.getDao().getConnection();
int pageIndex = 1;
boolean hasNextPage = true;
for (int k = 0; k < 5; ) {
try {
while (hasNextPage) {
Date startdate = new Date(new Date().getTime() - daymillis);
Date enddate = new Date();
// 方法名
String apimethod = "search_order_list";
HashMap<String, Object> reqMap = new HashMap<String, Object>();
reqMap.put("last_modify_st_time", startdate.getTime() / 1000L);
reqMap.put("last_modify_en_time", enddate.getTime() / 1000L);
reqMap.put("pages", String.valueOf(pageIndex));
reqMap.put("counts", pageSize);
reqMap.put("return_data", "json");
reqMap.put("act", apimethod);
reqMap.put("api_version", "1.0");
// 发送请求
Log.info("第" + pageIndex + "页");
String responseText = CommHelper.doRequest(reqMap, url);
Log.info("返回数据为: " + responseText);
// 把返回的数据转成json对象
JSONObject responseObj = new JSONObject(responseText.replaceAll(":null", ":\"\""));
// 错误对象
if (!"success".equals(responseObj.getString("result"))) { // 发生错误
String operCode = responseObj.getJSONObject("sn_error").getString("error_code");
if (operCode.indexOf("no-result") != -1) { // 没有数据直接退出方法体
Log.error("获取ecshop订单列表", "获取订单列表失败，操作码：" + operCode);
return;
}
hasNextPage = false;
break;
}
JSONObject orderInfos = responseObj.getJSONObject("info");
String orderTotal = String.valueOf(orderInfos.getString("counts"));
int orderTotaltemp = Integer.parseInt(orderTotal);
int pageTotalTemp =
Double.valueOf(Math.ceil(orderTotaltemp / Double.parseDouble(Params.pageSize)))
.intValue();
String pageTotal = String.valueOf(pageTotalTemp);
Log.info("总订单数为： " + orderTotal);
Log.info("总页数为： " + pageTotal);
if (orderTotal == null || orderTotal.equals("") || orderTotal.equals("0")) {
break;
}
// 订单元素
JSONArray ordersList = orderInfos.getJSONArray("data_info");
for (int i = 0; i < ordersList.length(); i++) { // 某个订单
JSONObject orderInfo = ordersList.getJSONObject(i);
// 订单编号
String orderCode = (String) orderInfo.get("order_sn");
if (orderInfo.isNull("shop_info")) continue;
// 订单商品集合
JSONArray items = orderInfo.getJSONArray("shop_info");
// 构造一个订单对象
Order o = new Order();
o.setObjValue(o, orderInfo);
o.setFieldValue(o, "shop_info", items);
Log.info(
"订单号: "
+ o.getOrder_sn()
+ ", 发货状态: "
+ o.getShipping_status()
+ "付款状态: "
+ o.getPay_status());
if (o != null) {
if ("0".equals(o.getShipping_status()) && "2".equals(o.getPay_status())) { // 正常订单
Log.info("检查到一条订单：" + orderCode);
// 如果是等待发货订单，创建接口订单成功，减少其它店的库存
if (!OrderManager.isCheck(jobName, conn, orderCode)) {
if (!OrderManager.TidLastModifyIntfExists(
jobName, conn, orderCode, new Date(o.getAdd_time() * 1000L))) {
try {
OrderUtils.createInterOrder(conn, o, tradecontactid, username);
for (Iterator ito = o.getShop_info().getRelationData().iterator();
ito.hasNext(); ) {
OrderItem item = (OrderItem) ito.next();
String sku = item.getProduct_sn();
StockManager.deleteWaitPayStock(
jobName, conn, tradecontactid, orderCode, sku);
long qty = (long) item.getGoods_number();
// 在ecs_rationconfig表中存在机构添加一条库存同步记录(不包括自己）
StockManager.addSynReduceStore(
jobName, conn, tradecontactid, "未发货", o.getOrder_sn(), sku, qty, false);
}
} catch (SQLException sqle) {
throw new JException("生成接口订单出错!" + sqle.getMessage());
}
}
} // 订单状态 10待发货，20已发货，21部分发货，30交易成功 ，40交易关闭
}
}
}
// 判断是否有下一页
if ("".equals(pageTotal) || pageTotal == null) pageTotal = "0";
if (pageIndex >= Integer.parseInt(pageTotal)) hasNextPage = false;
else pageIndex++;
break;
}
Log.info(jobName + "执行完毕!");
break;
} catch (Exception e) {
if (++k >= 5) throw e;
if (conn != null && !conn.getAutoCommit()) {
conn.rollback();
}
Log.warn(jobName + " ,远程连接失败[" + k + "], 10秒后自动重试. " + Log.getErrorMessage(e));
Thread.sleep(10000L);
}
}
}
/*
* 获取一天之类的退款订单
*/
private void getRefundBillList(Connection conn) throws Exception {
long pageno = 1L;
Date modified = Formatter.parseDate(lasttime, Formatter.DATE_TIME_FORMAT);
for (int k = 0; k < 10; ) {
try {
TaobaoClient client =
new DefaultTaobaoClient(Params.url, Params.appkey, Params.appsecret, "json");
TmallEaiOrderRefundMgetRequest req = new TmallEaiOrderRefundMgetRequest();
Date startdate =
new Date(Formatter.parseDate(lasttime, Formatter.DATE_TIME_FORMAT).getTime() + 1000L);
Date enddate =
new Date(
Formatter.parseDate(lasttime, Formatter.DATE_TIME_FORMAT).getTime() + daymillis);
req.setStartTime(startdate);
req.setEndTime(enddate);
req.setPageNo(pageno);
req.setPageSize(40L);
req.setUseHasNext(true);
TmallEaiOrderRefundMgetResponse response = client.execute(req, Params.authcode);
while (true) {
if (response.getRefundBillList() == null || response.getRefundBillList().size() <= 0) {
if (pageno == 1) {
try {
// 如一天之内都取不到订单，而且当前天大于配置天，则将取订单最新时间更新为当前天的零点
if (this.dateformat
.parse(Formatter.format(new Date(), Formatter.DATE_FORMAT))
.compareTo(
this.dateformat.parse(
Formatter.format(
Formatter.parseDate(
PublicUtils.getConfig(conn, lasttimeconfvalue, ""),
Formatter.DATE_TIME_FORMAT),
Formatter.DATE_FORMAT)))
> 0) {
try {
String value =
Formatter.format(
(new Date(
Formatter.parseDate(
PublicUtils.getConfig(conn, lasttimeconfvalue, ""),
Formatter.DATE_TIME_FORMAT)
.getTime()
+ daymillis)),
Formatter.DATE_FORMAT)
+ " 00:00:00";
PublicUtils.setConfig(conn, lasttimeconfvalue, value);
} catch (JException je) {
Log.error(jobname, je.getMessage());
}
}
} catch (ParseException e) {
Log.error(jobname, "不可用的日期格式!" + e.getMessage());
}
}
break;
}
for (Iterator it = response.getRefundBillList().iterator(); it.hasNext(); ) {
RefundBill refundbill = (RefundBill) it.next();
Log.info(
refundbill.getTid()
+ " "
+ refundbill.getStatus()
+ " "
+ refundbill.getModified());
if (!RefundUtil.RefundBillisCheck(
conn,
String.valueOf(refundbill.getTid()),
String.valueOf(refundbill.getRefundId()),
refundbill.getModified())) {
Trade td =
OrderUtils.getFullTrade(
String.valueOf(refundbill.getTid()),
Params.url,
Params.address,
Params.appsecret,
Params.authcode);
RefundUtil.createRefundBill(conn, refundbill, td, Params.tradecontactid);
}
if (Formatter.parseDate(refundbill.getModified(), Formatter.DATE_TIME_FORMAT)
.compareTo(modified)
> 0) {
modified = Formatter.parseDate(refundbill.getModified(), Formatter.DATE_TIME_FORMAT);
}
}
// 判断是否下一页
if (response.getHasNext()) {
pageno++;
} else {
break;
}
}
if (modified.compareTo(Formatter.parseDate(lasttime, Formatter.DATE_TIME_FORMAT)) > 0) {
try {
String value = Formatter.format(modified, Formatter.DATE_TIME_FORMAT);
PublicUtils.setConfig(conn, lasttimeconfvalue, value);
} catch (JException je) {
Log.error(jobname, je.getMessage());
}
}
// 执行成功后不再循环
break;
} catch (Exception e) {
if (++k >= 10) throw e;
Log.warn("远程连接失败[" + k + "], 10秒后自动重试. " + Log.getErrorMessage(e));
Thread.sleep(10000L);
}
}
}
private void normalSend(
String post_no, String orderid, String post_company, Connection conn, String sheetid) {
try {
TaobaoClient client = new DefaultTaobaoClient(Params.url, Params.appkey, Params.appsecret);
LogisticsOfflineSendRequest req = new LogisticsOfflineSendRequest();
req.setOutSid(post_no);
req.setTid(TranTid(orderid));
req.setCompanyCode(post_company);
LogisticsOfflineSendResponse rsp = client.execute(req, Params.authcode);
String sql;
if (rsp.isSuccess()) {
try {
conn.setAutoCommit(false);
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
conn.commit();
conn.setAutoCommit(true);
} catch (SQLException sqle) {
if (!conn.getAutoCommit())
try {
conn.rollback();
} catch (Exception e1) {
}
try {
conn.setAutoCommit(true);
} catch (Exception e1) {
}
// throw new JSQLException(sql, sqle);
}
Log.info(
username,
"处理订单【" + orderid + "】发货成功,快递公司【" + post_company + "】,快递单号【" + post_no + "】",
null);
} else {
if (rsp.getSubCode().equals("isv.logistics-offline-service-error:B04")) {
// 已经同步发货状态或退货成功了
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
Log.info(username, "订单: " + orderid + ", sheetid: " + sheetid + ",状态异常,已备份到备份表", null);
}
if (rsp.getSubCode().equals("isv.logistics-offline-service-error:P38")) {
// 已经同步发货状态或退货成功了
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
Log.info(
username,
"订单: " + orderid + ", sheetid: " + sheetid + ",状态异常,,拆单校验未通过.已备份到备份表",
null);
}
if (rsp.getSubCode().equals("isv.logistics-offline-service-error:S01")) {
// 已经同步发货状态或退货成功了
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
Log.info(username, "订单: " + orderid + ", sheetid: " + sheetid + ",状态异常,已备份到备份表", null);
}
if (rsp.getSubCode().indexOf("ORDER_NOT_FOUND_ERROR") != -1) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
Log.error(username, jobName + ",订单号: " + orderid + ", 无法找到！", null);
}
if (rsp.getSubMsg().indexOf("不能重复发货") >= 0 || rsp.getSubMsg().indexOf("发货类型不匹配") >= 0) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
Log.info(
username,
"订单【" + orderid + "】不能重复发货,快递公司【" + post_company + "】,快递单号【" + post_no + "】",
null);
} else if ((rsp.getSubMsg().indexOf("没有权限进行发货") >= 0)
|| rsp.getSubMsg().indexOf("没有权限发货") >= 0
|| rsp.getSubMsg().indexOf("当前订单状态不支持修改") >= 0) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
Log.info(
username,
"没有权限发货,订单【" + orderid + "】,快递公司【" + post_company + "】,快递单号【" + post_no + "】",
null);
} else if (rsp.getSubMsg().indexOf("物流订单不存在") >= 0
|| rsp.getSubMsg().indexOf("订单已经被拆单") >= 0
|| rsp.getSubMsg().indexOf("当前操作的订单是拆单订单") >= 0) {
TaobaoClient subclient =
new DefaultTaobaoClient(Params.url, Params.appkey, Params.appsecret);
LogisticsOfflineSendRequest subreq = new LogisticsOfflineSendRequest();
subreq.setOutSid(post_no);
subreq.setTid(TranTid(orderid));
subreq.setCompanyCode(post_company);
subreq.setIsSplit(1L);
String subtids = "";
sql =
"select oid from customerorderitem a with(nolock),customerorder b with(nolock),"
+ "customerdelive c with(nolock) where a.sheetid=b.sheetid and a.sheetid=c.refsheetid "
+ "and c.customersheetid='"
+ orderid
+ "' and c.delivery='"
+ post_company
+ "' "
+ "and c.deliverysheetid='"
+ post_no
+ "'";
List sublist = SQLHelper.multiRowListSelect(conn, sql);
for (Iterator it = sublist.iterator(); it.hasNext(); ) {
String oid = (String) it.next();
subtids = oid + "," + subtids;
}
subtids =
(subtids != null && subtids != "" ? subtids.substring(0, subtids.length() - 1) : "");
subreq.setSubTid(subtids);
LogisticsOfflineSendResponse subrsp = client.execute(subreq, Params.authcode);
if (subrsp.isSuccess()) {
Log.info(
jobName,
"处理订单【"
+ orderid
+ "】,子订单【"
+ subtids
+ "】发货成功,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】");
}
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
Log.info(
username,
"物流订单不存在或订单已经被拆单,订单【"
+ orderid
+ "】,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】",
null);
} else if (rsp.getSubMsg().indexOf("运单号不符合规则或已经被使用") >= 0) {
// 公司内部自提发货处理
if ((post_no.toUpperCase().indexOf("1111111") >= 0)
|| (post_no.toUpperCase().indexOf("YJ") >= 0)) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
} else {
String cc = "";
String memo = "";
if (post_no.toUpperCase().indexOf("EH") == 0) {
cc = "EMS";
} else if (post_no.toUpperCase().indexOf("101") == 0) {
cc = "SF";
} else if (post_no.toUpperCase().indexOf("368") == 0) {
cc = "STO";
} else if (post_no.toUpperCase().indexOf("W") == 0) {
cc = "YTO";
} else {
cc = post_company; // 把错误的运单号对应的订单号修改一下，让后面修改后的快递信息能正确写入sheettype=3
orderid += "运单号不符合规则或已经被使用";
memo += "运单号不符合规则或已经被使用";
}
sql =
"update ns_delivery set companycode='"
+ cc
+ "',tid='"
+ orderid
+ "',memo='"
+ memo
+ "' where SheetID = '"
+ sheetid
+ "'";
SQLHelper.executeSQL(conn, sql);
}
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
Log.info(
jobName,
"运单号不符合规则或已经被使用,订单【"
+ orderid
+ "】,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】");
} else {
Log.info(
username,
"处理订单【"
+ orderid
+ "】发货失败,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】"
+ "错误信息:"
+ rsp.getSubMsg()
+ rsp.getMsg(),
null);
String errmsg = rsp.getSubMsg();
Pattern par = Pattern.compile("This ban will last for (\\d{1,9}) more seconds");
Matcher m = par.matcher(errmsg);
if (m.find()) {
long delayTime = Long.parseLong(m.group(1)) * 1000L;
long now = System.currentTimeMillis();
while (System.currentTimeMillis() < now + delayTime) {
Thread.sleep(1000L);
}
}
}
}
} catch (ApiException e) {
Log.error(
username,
"处理订单【"
+ orderid
+ "】发货失败,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】,错误信息:"
+ e.getMessage(),
null);
} catch (Exception e) {
Log.error(username, "同步发货状态出错了, 错误信息: " + e.getMessage(), null);
}
}
public void run() {
Properties proper = StringUtil.getStringProperties(this.getExecuteobj().getParams());
tid = proper.getProperty("tid");
tradecontactid = proper.getProperty("tradecontactid");
url = proper.getProperty("url");
appkey = proper.getProperty("appkey");
appsecret = proper.getProperty("appsecret");
authcode = proper.getProperty("authcode");
sellernick = proper.getProperty("sellernick");
try {
updateJobFlag(1);
String sql = "select isnull(value,0) from config where name='等待付款订单是否进系统'";
if ("1".equals(this.getDao().strSelect(sql))) ;
waitbuyerpayisin = true;
TaobaoClient client = new DefaultTaobaoClient(url, appkey, appsecret, "xml");
TradeGetRequest req = new TradeGetRequest();
req.setFields("tid,modified,status,orders.outer_sku_id,orders.num");
req.setTid(Long.parseLong(tid));
TradeGetResponse response = client.execute(req, authcode);
if (response.getTrade() == null) {
return;
}
Trade td = response.getTrade();
if (td.getStatus().equals("WAIT_SELLER_SEND_GOODS")) {
if (!OrderManager.isCheck(
"检查淘宝订单", this.getDao().getConnection(), String.valueOf(td.getTid()))) {
if (!OrderManager.TidLastModifyIntfExists(
"检查淘宝订单",
this.getDao().getConnection(),
String.valueOf(td.getTid()),
td.getModified())) {
OrderUtils.createInterOrder(
this.getDao().getConnection(), td, Params.tradecontactid, Params.username, true);
for (Iterator ito = td.getOrders().iterator(); ito.hasNext(); ) {
Order o = (Order) ito.next();
String sku = o.getOuterSkuId();
StockManager.deleteWaitPayStock(
jobName,
this.getDao().getConnection(),
Params.tradecontactid,
String.valueOf(td.getTid()),
sku);
StockManager.addSynReduceStore(
jobName,
this.getDao().getConnection(),
Params.tradecontactid,
td.getStatus(),
String.valueOf(td.getTid()),
sku,
-o.getNum(),
false);
}
}
}
// 等待买家付款时记录锁定库存
} else if (td.getStatus().equals("WAIT_BUYER_PAY")
|| td.getStatus().equals("TRADE_NO_CREATE_PAY")) {
if (waitbuyerpayisin) {
if (!OrderManager.TidLastModifyIntfExists(
"检查淘宝订单",
this.getDao().getConnection(),
String.valueOf(td.getTid()),
td.getModified())) {
OrderUtils.createInterOrder(
this.getDao().getConnection(), td, Params.tradecontactid, Params.username, false);
}
}
for (Iterator ito = td.getOrders().iterator(); ito.hasNext(); ) {
Order o = (Order) ito.next();
String sku = o.getOuterSkuId();
StockManager.addWaitPayStock(
jobName,
this.getDao().getConnection(),
Params.tradecontactid,
String.valueOf(td.getTid()),
sku,
o.getNum());
StockManager.addSynReduceStore(
jobName,
this.getDao().getConnection(),
Params.tradecontactid,
td.getStatus(),
String.valueOf(td.getTid()),
sku,
-o.getNum(),
false);
}
// 付款以后用户退款成功，交易自动关闭
// 释放库存,数量为负数
} else if (td.getStatus().equals("TRADE_CLOSED")) {
OrderManager.CancelOrderByCID(
jobName, this.getDao().getConnection(), String.valueOf(td.getTid()));
for (Iterator ito = td.getOrders().iterator(); ito.hasNext(); ) {
Order o = (Order) ito.next();
String sku = o.getOuterSkuId();
StockManager.deleteWaitPayStock(
jobName,
this.getDao().getConnection(),
Params.tradecontactid,
String.valueOf(td.getTid()),
sku);
// StockManager.addSynReduceStore(jobName, this.getDao().getConnection(),
// Params.tradecontactid, td.getStatus(),String.valueOf(td.getTid()),sku,
// o.getNum(),false);
}
// 付款以前，卖家或买家主动关闭交易
// 释放等待买家付款时锁定的库存
} else if (td.getStatus().equals("TRADE_CLOSED_BY_TAOBAO")) {
if (waitbuyerpayisin) {
if (!OrderManager.TidLastModifyIntfExists(
"检查淘宝订单",
this.getDao().getConnection(),
String.valueOf(td.getTid()),
td.getModified())) {
OrderUtils.createInterOrder(
this.getDao().getConnection(), td, Params.tradecontactid, Params.username, false);
}
}
for (Iterator ito = td.getOrders().iterator(); ito.hasNext(); ) {
Order o = (Order) ito.next();
String sku = o.getOuterSkuId();
StockManager.deleteWaitPayStock(
jobName,
this.getDao().getConnection(),
Params.tradecontactid,
String.valueOf(td.getTid()),
sku);
if (StockManager.WaitPayStockExists(
jobName,
this.getDao().getConnection(),
Params.tradecontactid,
String.valueOf(td.getTid()),
sku)) // 有获取到等待买家付款状态时才加库存
{
StockManager.addSynReduceStore(
jobName,
this.getDao().getConnection(),
Params.tradecontactid,
td.getStatus(),
String.valueOf(td.getTid()),
sku,
o.getNum(),
false);
}
}
} else if (td.getStatus().equals("TRADE_FINISHED")) {
for (Iterator ito = td.getOrders().iterator(); ito.hasNext(); ) {
Order o = (Order) ito.next();
String sku = o.getOuterSkuId();
StockManager.deleteWaitPayStock(
jobName,
this.getDao().getConnection(),
Params.tradecontactid,
String.valueOf(td.getTid()),
sku);
// 更新结束时间
OrderUtils.updateFinishedStatus(
this.getDao().getConnection(), Params.tradecontactid, td.getTid(), td.getEndTime());
}
}
// if(Params.isc)
// {
// 处理退货
for (Iterator oit = td.getOrders().iterator(); oit.hasNext(); ) {
Order o = (Order) oit.next();
// Log.info("订单号:"+String.valueOf(td.getTid())+" 退货ID:"+String.valueOf(o.getRefundId()));
if (o.getRefundId() > 0) {
OrderUtils.getRefund(
jobName,
this.getDao().getConnection(),
Params.url,
Params.appkey,
Params.appsecret,
Params.authcode,
Params.tradecontactid,
td,
o,
String.valueOf(td.getTid()),
o.getRefundId());
}
}
updateJobFlag(0);
Log.info(
jobName,
"执行作业成功 ["
+ this.getExecuteobj().getActivetimes()
+ "] ["
+ this.getExecuteobj().getNotes()
+ "] 下次处理时间: "
+ this.datetimeformat.format(this.getExecuteobj().getNextactive()));
} catch (Exception e) {
try {
if (this.getDao().getConnection() != null
&& !this.getDao().getConnection().getAutoCommit()) {
this.getDao().getConnection().rollback();
this.getDao().getConnection().setAutoCommit(true);
}
} catch (Exception e1) {
Log.error(jobName, "回滚事务失败");
Log.error(jobName, e1.getMessage());
}
try {
if (this.getExecuteobj().getSkip() == 1) {
UpdateTimerJob();
} else UpdateTimerJob(Log.getErrorMessage(e));
} catch (Exception ex) {
Log.error(jobName, "更新任务信息失败");
Log.error(jobName, ex.getMessage());
}
Log.error(jobName, "错误信息:" + Log.getErrorMessage(e));
Log.error(
jobName,
"执行作业失败 ["
+ this.getExecuteobj().getActivetimes()
+ "] ["
+ this.getExecuteobj().getNotes()
+ "] \r\n "
+ Log.getErrorMessage(e));
} finally {
try {
updateJobFlag(0);
} catch (Exception e) {
Log.error(jobName, e.getMessage());
Log.error(jobName, "更新处理标志失败");
TimerRunner.modifiedErrVect(this.getExecuteobj().getId());
}
try {
if (this.getDao().getConnection() != null) {
this.getDao().getConnection().setAutoCommit(true);
this.getDao().getConnection().close();
}
} catch (Exception e) {
Log.error(jobName, "关闭数据库连接失败");
}
}
}
/*
* 转入一个订单到接口表
*/
public static void createInterOrder(
Connection conn, String tradecontactid, String username, Order o)
throws SQLException, JException {
String sheetid = "";
int haspostFee;
String sql =
"declare @Err int ; declare @NewSheetID char(16); execute @Err = TL_GetNewSheetID 1105, @NewSheetID output;select @NewSheetID;";
try {
conn.setAutoCommit(false);
sheetid = SQLHelper.strSelect(conn, sql);
if (sheetid.trim().equals("")) throw new JSQLException(sql, "取接口单号出错!");
// 加入到通知表
sql =
"insert into it_downnote(Owner , sheetid , sheettype , sender , receiver , notetime , handletime) values('yongjun','"
+ sheetid
+ "',1 , '"
+ tradecontactid
+ "' , 'yongjun' , getdate() , null) ";
SQLHelper.executeSQL(conn, sql);
if (Float.valueOf(o.getPostage()).compareTo(Float.valueOf("0.0")) > 0) haspostFee = 1;
else haspostFee = 0;
// 加入到单据表
sql =
"insert into ns_customerorder(CustomerOrderId,SheetID,Owner,tid,OrderSheetID,sellernick,"
+ " created ,payment,status,buyermemo,tradememo,paytime,totalfee,postfee,"
+ " buyernick,receivername,receiverstate,receivercity,receiverdistrict,"
+ " receiveraddress,receiverzip,receivermobile,receiverphone,buyeremail,haspostFee,"
+ " price,num,title,tradefrom,TradeContactID) "
+ " values("
+ "'"
+ sheetid
+ "','"
+ sheetid
+ "','yongjun','"
+ o.getOrderId()
+ "','','"
+ username
+ "',"
+ "'"
+ o.getCreatTime()
+ "','"
+ String.valueOf(
Float.valueOf(o.getMoney()) * Float.valueOf(o.getBuyNum())
+ Float.valueOf(o.getPostage()))
+ "',"
+ "'"
+ o.getStatus()
+ "','"
+ o.getRemarks()
+ "','"
+ o.getRemarks()
+ "','"
+ o.getPaymentTime()
+ "','"
+ String.valueOf(Float.valueOf(o.getMoney()) * Float.valueOf(o.getBuyNum()))
+ "','"
+ o.getPostage()
+ "','"
+ o.getbuyerNick()
+ "'"
+ ",'"
+ o.getReceiverName()
+ "','"
+ o.getProvince()
+ "', '"
+ o.getCity()
+ "','','"
+ o.getAddress()
+ "', "
+ "'"
+ o.getZipCode()
+ "','"
+ o.getMobilePhone()
+ "','"
+ o.getMobilePhone()
+ "',"
+ "'"
+ o.getEmail()
+ "','"
+ String.valueOf(haspostFee)
+ "',"
+ "'"
+ o.getMoney()
+ "','"
+ o.getBuyNum()
+ "', '"
+ username
+ "','GROUPON','"
+ tradecontactid
+ "')";
SQLHelper.executeSQL(conn, sql);
sql =
"insert into ns_orderitem(CustomerOrderId,orderItemId,SheetID,"
+ " sellernick,buyernick,created,outerskuid,totalfee,payment,"
+ " status,owner,num,price,skuid) values( "
+ "'"
+ sheetid
+ "','"
+ sheetid
+ "_"
+ o.getOrderId()
+ "','"
+ sheetid
+ "',"
+ "'"
+ username
+ "', '"
+ o.getbuyerNick()
+ "' ,'"
+ o.getCreatTime()
+ "', "
+ "'"
+ o.getSKU()
+ "' , '"
+ String.valueOf(Float.valueOf(o.getMoney()) * Float.valueOf(o.getBuyNum()))
+ "','"
+ String.valueOf(
Float.valueOf(o.getMoney()) * Float.valueOf(o.getBuyNum())
+ Float.valueOf(o.getPostage()))
+ "' , "
+ "'"
+ o.getStatus()
+ "','yongjun',"
+ ""
+ o.getBuyNum()
+ ",'"
+ o.getMoney()
+ "','"
+ o.getSKU()
+ "')";
SQLHelper.executeSQL(conn, sql);
conn.commit();
conn.setAutoCommit(true);
Log.info("生成订单【" + o.getOrderId() + "】接口数据成功，接口单号【" + sheetid + "】");
} catch (JSQLException e1) {
if (!conn.getAutoCommit())
try {
conn.rollback();
} catch (Exception e2) {
}
try {
conn.setAutoCommit(true);
} catch (Exception e3) {
}
throw new JException("生成订单【" + o.getOrderId() + "】接口数据失败!" + e1.getMessage());
}
}
/*
* 获取某个项目一天之类的所有订单
*/
public static void getBusinessOrderList(
String modulename,
Connection conn,
Hashtable htwsinfo,
String grouponid,
Date starttime,
Date endtime)
throws JException {
OMFactory soapFactory = OMAbstractFactory.getOMFactory();
OMNamespace omNs = soapFactory.createOMNamespace(htwsinfo.get("namespace").toString(), "");
OMElement soapResponse = soapFactory.createOMElement("groupon", omNs);
DisneyRequestBean requestBean = new DisneyRequestBean();
String s = (new StringBuilder(String.valueOf(System.currentTimeMillis()))).toString();
requestBean.setRequest_time(s);
requestBean.setSign(
MD5Util.MD5Encode(
(new StringBuilder(grouponid))
.append(s)
.append(htwsinfo.get("key").toString())
.toString()));
requestBean.setGrouponid(grouponid);
requestBean.setLimit(htwsinfo.get("limit").toString());
requestBean.setTotal(htwsinfo.get("total").toString());
requestBean.setStartTime(String.valueOf(starttime.getTime())); // 增加一秒
requestBean.setEndTime(String.valueOf(endtime.getTime())); // 增加一天
soapResponse.addChild(ObjBodyWriter.convertBeanToXml(requestBean, "request"));
Options options = new Options();
options.setTo(new EndpointReference(htwsinfo.get("wsurl").toString()));
options.setAction("getBusinessProjectList");
options.setProperty("__CHUNKED__", Boolean.valueOf(false));
ServiceClient sender = null;
try {
sender = new ServiceClient();
sender.setOptions(options);
OMElement result = sender.sendReceive(soapResponse);
Document doc = DOMHelper.newDocument(result.toString(), htwsinfo.get("encoding").toString());
Element urlset = doc.getDocumentElement();
NodeList orderinfonodes = urlset.getElementsByTagName("order_info");
if (orderinfonodes.getLength() > 0) {
for (int i = 0; i < orderinfonodes.getLength(); i++) {
Element orderinfoelement = (Element) orderinfonodes.item(i);
Order o = OrderUtils.getOrder(orderinfoelement);
String orderid = o.getOrderId();
String status = o.getStatus();
String sku = o.getSKU();
long qty = Long.valueOf(o.getBuyNum());
Date updatetime = Formatter.parseDate(o.getPaymentTime(), Formatter.DATE_TIME_FORMAT);
/*
*1、如果状态为等待卖家发货则生成接口订单
*2、删除等待买家付款时的锁定库存
*/
Log.info(o.getOrderId() + " " + o.getStatus() + " " + o.getPaymentTime());
if (status.equals("1")) {
// 即使取订单时不需要判断订单是否存在，每天检查订单时需检查订单是否已经存在
if (htwsinfo.get("style").toString().equals("0")) {
try {
createInterOrder(
conn,
htwsinfo.get("tradecontactid").toString(),
htwsinfo.get("username").toString(),
o);
StockManager.deleteWaitPayStock(
modulename, conn, htwsinfo.get("tradecontactid").toString(), orderid, sku);
} catch (SQLException sqle) {
throw new JException("生成接口订单出错!" + sqle.getMessage());
}
} else {
if (!OrderManager.TidExists("检查团宝未入订单", conn, String.valueOf(o.getOrderId()))) {
if (OrderManager.TidIntfExists("检查团宝未入订单", conn, String.valueOf(o.getOrderId()))) {
Log.info(
"接口中存在,客户订单中不存在:"
+ o.getOrderId()
+ " "
+ o.getStatus()
+ " "
+ o.getPaymentTime());
} else {
Log.info(
"接口中不存在,客户订单中不存在:"
+ o.getOrderId()
+ " "
+ o.getStatus()
+ " "
+ o.getPaymentTime());
}
try {
createInterOrder(
conn,
htwsinfo.get("tradecontactid").toString(),
htwsinfo.get("username").toString(),
o);
StockManager.deleteWaitPayStock(
modulename, conn, htwsinfo.get("tradecontactid").toString(), orderid, sku);
} catch (SQLException sqle) {
throw new JException("生成接口订单出错!" + sqle.getMessage());
}
}
}
}
// 等待买家付款时记录锁定库存
else if (status.equals("0")) {
StockManager.addWaitPayStock(
modulename, conn, htwsinfo.get("tradecontactid").toString(), orderid, sku, qty);
StockManager.addSynReduceStore(
modulename,
conn,
htwsinfo.get("tradecontactid").toString(),
status,
orderid,
sku,
-qty,
false);
// 付款以后用户退款成功，交易自动关闭
// 释放库存,数量为正数
} else if (status.equals("6")) {
StockManager.addSynReduceStore(
modulename,
conn,
htwsinfo.get("tradecontactid").toString(),
status,
orderid,
sku,
qty,
false);
// 付款以前，卖家或买家主动关闭交易
// 释放等待买家付款时锁定的库存
} else if (status.equals("4")) {
StockManager.deleteWaitPayStock(
modulename, conn, htwsinfo.get("tradecontactid").toString(), orderid, sku);
StockManager.addSynReduceStore(
modulename,
conn,
htwsinfo.get("tradecontactid").toString(),
status,
orderid,
sku,
qty,
false);
}
// 更新同步订单最新时间
if (updatetime.compareTo(
Formatter.parseDate(
PublicUtils.getConfig(conn, htwsinfo.get("lasttimeconfvalue").toString(), ""),
Formatter.DATE_TIME_FORMAT))
> 0)
PublicUtils.setConfig(
conn,
htwsinfo.get("lasttimeconfvalue").toString(),
Formatter.format(updatetime, Formatter.DATE_TIME_FORMAT));
}
} else {
try {
// 如该段时间之内都取不到订单，而且当前天大于配置天，则将取订单最新时间更新为当前天的零点
if (dateformat
.parse(Formatter.format(new Date(), Formatter.DATE_FORMAT))
.compareTo(
dateformat.parse(
Formatter.format(
Formatter.parseDate(
PublicUtils.getConfig(
conn, htwsinfo.get("lasttimeconfvalue").toString(), ""),
Formatter.DATE_TIME_FORMAT),
Formatter.DATE_FORMAT)))
> 0) {
PublicUtils.setConfig(
conn,
htwsinfo.get("lasttimeconfvalue").toString(),
Formatter.format(
(new Date(
Formatter.parseDate(
PublicUtils.getConfig(
conn, htwsinfo.get("lasttimeconfvalue").toString(), ""),
Formatter.DATE_TIME_FORMAT)
.getTime()
+ daymillis)),
Formatter.DATE_FORMAT)
+ " 00:00:00");
}
} catch (ParseException e) {
throw new JException("不可用的日期格式!" + e.getMessage());
}
}
} catch (JException ja) {
Log.error(modulename, ja.getMessage());
} catch (AxisFault af) {
throw new JException("访问远程服务出错!" + af.getMessage());
} catch (Exception e) {
throw new JException("解析XML出错!" + e.getMessage());
}
}
@Override
public void run() {
Properties prop = StringUtil.getStringProperties(this.getExecuteobj().getParams());
pageSize = prop.getProperty("pageSize");
url = prop.getProperty("url");
tradecontactid = prop.getProperty("tradecontactid");
username = prop.getProperty("username");
try {
// 检查未入订单
updateJobFlag(1);
checkWaitStockOutOrders();
// 检查取消订单
checkCancleOrders();
UpdateTimerJob();
Log.info(
jobName,
"执行作业成功 ["
+ this.getExecuteobj().getActivetimes()
+ "] ["
+ this.getExecuteobj().getNotes()
+ "] 下次处理时间: "
+ this.datetimeformat.format(this.getExecuteobj().getNextactive()));
} catch (Exception e) {
try {
if (this.getExecuteobj().getSkip() == 1) {
UpdateTimerJob();
} else UpdateTimerJob(Log.getErrorMessage(e));
updateJobFlag(0);
if (this.getConnection() != null && !this.getConnection().getAutoCommit())
this.getConnection().rollback();
if (this.getExtconnection() != null && !this.getExtconnection().getAutoCommit())
this.getExtconnection().rollback();
} catch (Exception e1) {
Log.error(jobName, "回滚事务失败");
}
Log.error(jobName, "错误信息:" + Log.getErrorMessage(e));
Log.error(
jobName,
"执行作业失败 ["
+ this.getExecuteobj().getActivetimes()
+ "] ["
+ this.getExecuteobj().getNotes()
+ "] \r\n "
+ Log.getErrorMessage(e));
} finally {
try {
updateJobFlag(0);
} catch (Exception e) {
Log.error(jobName, "更新处理标志失败");
}
try {
if (this.getConnection() != null) this.getConnection().close();
if (this.getExtconnection() != null) this.getExtconnection().close();
} catch (Exception e) {
Log.error(jobName, "关闭数据库连接失败");
}
}
}
private void delivery(Connection conn) throws Exception {
String sql =
"select a.sheetid,b.tid, upper(ltrim(rtrim(b.companycode))) companycode,"
+ "upper(ltrim(rtrim(b.outsid))) outsid from it_upnote a with(nolock), ns_delivery b with(nolock)"
+ "where a.sheettype=3 and a.sheetid=b.sheetid and a.receiver='"
+ Params.tradecontactid
+ "' and b.iswait=0";
Vector vdeliveryorder = SQLHelper.multiRowSelect(conn, sql);
Log.info("本次要处理的订单发货条数为: " + vdeliveryorder.size());
for (int i = 0; i < vdeliveryorder.size(); i++) {
Hashtable hto = (Hashtable) vdeliveryorder.get(i);
String sheetid = hto.get("sheetid").toString();
String orderid = hto.get("tid").toString();
String post_company = hto.get("companycode").toString();
String post_no = hto.get("outsid").toString();
// 如果物流公司为空则忽略处理
if (post_company.trim().equals("")) {
Log.warn(jobname, "快递公司为空！订单号:" + orderid + "");
continue;
}
String postcompanyid = getCompanyID(post_company);
if (postcompanyid.equals("")) {
// 如果物流公司为空则忽略处理
if (post_company.trim().equals("")) {
Log.warn(jobname, "快递公司未配置！快递公司：" + post_company + " 订单号:" + orderid + "");
continue;
}
}
Map<String, String> params = new HashMap<String, String>();
// 系统级参数设置
params.put("app_id", Params.app_id);
params.put("format", Params.format);
params.put("method", "kdt.logistics.online.confirm");
params.put("sign_method", "MD5");
params.put("v", Params.ver);
params.put("timestamp", Formatter.format(new Date(), Formatter.DATE_TIME_FORMAT));
params.put("tid", orderid);
params.put("is_no_express", "0");
params.put("out_stype", postcompanyid);
params.put("out_sid", post_no);
String responseOrderListData = Utils.sendByPost(params, Params.AppSecret, Params.url);
Log.info("result: " + responseOrderListData);
// {"status":{"code":10006,"msg":"\u5fc5\u8981\u53c2\u6570\u7f3a\u5931"},"result":null}
JSONObject responseDelivery = new JSONObject(responseOrderListData);
if (!responseDelivery.isNull("error_response")) {
String errdesc = responseDelivery.getJSONObject("error_response").getString("msg");
if ("\u65e0\u6548\u7684\u8ba2\u5355\u53f7".equals(errdesc)) {
Log.info(jobname + " 订单号不存在: " + orderid);
} else {
Log.warn(
"订单发货失败,订单号:["
+ orderid
+ "],快递公司:["
+ post_company
+ "],快递单号:["
+ post_no
+ "] 错误信息:"
+ errdesc);
continue;
}
}
try {
conn.setAutoCommit(false);
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 3";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=3";
SQLHelper.executeSQL(conn, sql);
conn.commit();
conn.setAutoCommit(true);
} catch (SQLException sqle) {
if (!conn.getAutoCommit())
try {
conn.rollback();
} catch (Exception e1) {
}
try {
conn.setAutoCommit(true);
} catch (Exception e1) {
}
throw new JSQLException(sql, sqle);
}
Log.info(
jobname, "处理订单【" + orderid + "】发货成功,快递公司【" + post_company + "】,快递单号【" + post_no + "】");
}
}
public void run() {
Log.info(jobname, "启动[" + jobname + "]模块");
do {
Connection conn = null;
try {
conn = PoolHelper.getInstance().getConnection(Params.dbname);
List infsheetlist = JwUtil.getintfsheetlist(conn, 900000, 100);
Order order = null;
for (Iterator it = infsheetlist.iterator(); it.hasNext(); ) {
try {
Hashtable ht = (Hashtable) it.next();
Integer serialID = (Integer) ht.get("SerialID");
String operData = (String) ht.get("OperData");
String sql =
"SELECT * from Inf_downNotebak where operdata='"
+ operData
+ "' AND SheetType='900000' AND result='success' and opertype='100'";
Vector duplicateNum = SQLHelper.multiRowSelect(conn, sql);
if (duplicateNum != null && duplicateNum.size() > 0) {
conn.setAutoCommit(false);
JwUtil.delBackUpIntsheetData(conn, serialID);
conn.commit();
conn.setAutoCommit(true);
Log.info("此单已发送,删除重复的单成功,订单号: " + order.getOrderCode());
continue;
}
sql =
"select a.custompursheetid orderCode,a.custompursheetid orderDetailCode,a.tax "
+ "orderTax,convert(varchar,a.notifydate,20) createDate,convert(varchar,a.notifydate,20) "
+ "updateDate,convert(varchar,a.notifydate,20) payTime,a.postfee postPrice,a.CustomsOrderNo "
+ "invoiceName,a.note buyerMessage,a.payfee amountReceivable,a.payfee actualPayment,"
+ "a.linkman name, a.tele mobilePhone,a.address,isnull(a.zipcode,'000000') zip,b.notifyqty num,"
+ "b.title,b.price, b.price*b.notifyqty payment,b.price*b.notifyqty totalPrice,"
+ "c.custombc skuID ,rtrim(c.outerSkuId) outerSkuId,a.customsbarcode hgBarcode "
+ "from outstock0 a with(nolock),outstockitem0 b with(nolock),barcode c with(nolock) where a.sheetid=b.sheetid and b.barcodeid=c.barcodeid and a.sheetid='"
+ operData
+ "'";
Vector sqlresult = SQLHelper.multiRowSelect(conn, sql);
if (sqlresult.size() == 0) {
conn.setAutoCommit(false);
JwUtil.backUpIntsheetData(conn, serialID);
conn.commit();
conn.setAutoCommit(true);
Log.info("同步订单失败，订单已经处理或不存在,订单号: " + order.getOrderCode());
continue;
}
order = new Order();
ReceiveInfo receiveInfo = new ReceiveInfo();
int i = 0;
detail det = null;
for (Iterator t = sqlresult.iterator(); t.hasNext(); ) {
Hashtable htTemp = (Hashtable) t.next();
if (i == 0) {
order.getMapData(htTemp);
receiveInfo.getMapData(htTemp);
String address = receiveInfo.getAddress();
if (address.indexOf(" ") > 0) {
String[] add = address.split(" "); // 设置地址明细
if (add.length < 3) {
System.out.println(operData + " 地址不符合要求");
}
if (add.length == 4) {
receiveInfo.setProvince(add[0]);
receiveInfo.setCity(add[1]);
receiveInfo.setDistrict(add[2]);
receiveInfo.setAddress(add[3]);
} else if (add.length == 5) {
receiveInfo.setProvince(add[0]);
receiveInfo.setCity(add[1]);
receiveInfo.setDistrict(add[2]);
receiveInfo.setAddress(add[4].trim());
} else {
receiveInfo.setProvince(add[0]);
receiveInfo.setCity(add[1]);
receiveInfo.setDistrict(add[2]);
}
}
String mobilePhone = receiveInfo.getMobilePhone();
mobilePhone = mobilePhone.replaceAll(" +", " ");
if (mobilePhone.indexOf(" ") > 0) {
String[] contacts = mobilePhone.split(" ");
receiveInfo.setMobilephone(contacts[0]);
if (contacts[1].length() == 11) // 如果是手机号码就设置，如果是身份证就不设置了
receiveInfo.setPhone(contacts[1]);
} else if (mobilePhone.indexOf("/") > 0) {
String[] contacts = mobilePhone.split("/");
if (contacts.length == 2) {
receiveInfo.setMobilephone(contacts[0]);
if (contacts[1].length() == 11) // 如果是手机号码就设置，如果是身份证就不设置了
receiveInfo.setPhone(contacts[1]);
}
} else {
receiveInfo.setMobilephone(mobilePhone);
}
}
det = new detail();
det.getMapData(htTemp);
order.getDetail().getRelationData().add(det);
i++;
}
// Log.info("address: "+receiveInfo.getAddress());
order.setReceiver(receiveInfo.toJSONObject());
String temp = order.toJSONObject().replaceAll("\"\\{", "\\{");
temp = temp.replaceAll("\",\"detail\"", ",\"detail\"");
// Log.info("temp: "+temp);
String bizData1 = "{\"saleOrderList\":[" + temp + "]}";
String sign = JwUtil.makeSign(bizData1);
Map requestParams =
JwUtil.makeRequestParams(bizData1, service, Params.appkey, Params.format, sign);
String result = CommHelper.sendRequest(Params.url, requestParams, "");
Log.info("result: " + result);
JSONObject re = new JSONObject(result);
if (re.getBoolean("isSuccess")) {
conn.setAutoCommit(false);
JwUtil.backUpIntsheetData(conn, serialID);
conn.commit();
conn.setAutoCommit(true);
Log.info("同步订单成功,订单号: " + order.getOrderCode());
} else if (re.getString("body").contains("推送订单错误,可能已存在")) {
conn.setAutoCommit(false);
JwUtil.delBackUpIntsheetData(conn, serialID);
conn.commit();
conn.setAutoCommit(true);
Log.info("删除重复的单成功,订单号: " + order.getOrderCode());
} else {
Log.error(jobname, "sheetid: " + operData + " " + re.getString("body"));
}
} catch (Exception e) {
Log.error(jobname, e.getMessage());
if (conn != null && !conn.getAutoCommit()) conn.rollback();
continue;
}
}
} catch (Exception e) {
try {
if (conn != null && !conn.getAutoCommit()) conn.rollback();
} catch (Exception e1) {
Log.error(jobname, "回滚事务失败");
}
Log.error("105", jobname, Log.getErrorMessage(e));
} finally {
try {
if (conn != null) conn.close();
} catch (Exception e) {
Log.error(jobname, "关闭数据库连接失败");
}
}
System.gc();
long startwaittime = System.currentTimeMillis();
while (System.currentTimeMillis() - startwaittime < (long) (Params.waittime * 1000))
try {
sleep(1000L);
} catch (Exception e) {
Log.warn(jobname, "系统不支持休眠操作, 作业将严重影响机器性能");
}
} while (true);
}
public void run() {
Properties prop = StringUtil.getStringProperties(this.getExecuteobj().getParams());
url = prop.getProperty("url");
tradecontactid = prop.getProperty("tradecontactid");
username = prop.getProperty("username");
app_id = prop.getProperty("app_id");
secret = prop.getProperty("secret");
session = prop.getProperty("session");
System.out.println(url);
System.out.println(tradecontactid);
System.out.println(username);
System.out.println(app_id);
System.out.println(secret);
System.out.println(session);
try {
updateJobFlag(1);
synStock();
UpdateTimerJob();
Log.info(
jobName,
"执行作业成功 ["
+ this.getExecuteobj().getActivetimes()
+ "] ["
+ this.getExecuteobj().getNotes()
+ "] 下次处理时间: "
+ this.datetimeformat.format(this.getExecuteobj().getNextactive()));
} catch (Exception e) {
try {
if (this.getExecuteobj().getSkip() == 1) {
UpdateTimerJob();
} else UpdateTimerJob(Log.getErrorMessage(e));
if (this.getConnection() != null && !this.getConnection().getAutoCommit())
this.getConnection().rollback();
if (this.getExtconnection() != null && !this.getExtconnection().getAutoCommit())
this.getExtconnection().rollback();
} catch (Exception e1) {
Log.error(jobName, "回滚事务失败");
}
Log.error(jobName, "错误信息:" + Log.getErrorMessage(e));
Log.error(
jobName,
"执行作业失败 ["
+ this.getExecuteobj().getActivetimes()
+ "] ["
+ this.getExecuteobj().getNotes()
+ "] \r\n "
+ Log.getErrorMessage(e));
} finally {
try {
updateJobFlag(0);
} catch (Exception e) {
Log.error(jobName, "更新处理标志失败");
}
try {
if (this.getConnection() != null) this.getConnection().close();
if (this.getExtconnection() != null) this.getExtconnection().close();
} catch (Exception e) {
Log.error(jobName, "关闭数据库连接失败");
}
}
}
/** 修改物流公司和运单号 已经发过货的订单才能进行此操作 api : taobao.logistics.consign.resend 免费 */
private void resend(Connection conn) throws Exception {
String sql =
"select a.sheetid,b.tid, upper(ltrim(rtrim(b.companycode))) companycode,"
+ " upper(ltrim(rtrim(b.outsid))) outsid from it_upnote a with(nolock), ns_delivery b with(nolock)"
+ "where a.sheettype=4 and a.sheetid=b.sheetid and a.receiver='"
+ Params.tradecontactid
+ "' and b.iswait=0";
Vector vdeliveryorder = SQLHelper.multiRowSelect(conn, sql);
for (int i = 0; i < vdeliveryorder.size(); i++) {
String orderid = "";
try {
Hashtable hto = (Hashtable) vdeliveryorder.get(i);
String sheetid = hto.get("sheetid") != null ? hto.get("sheetid").toString() : "";
orderid = hto.get("tid") != null ? hto.get("tid").toString() : "";
String post_company =
hto.get("companycode") != null ? hto.get("companycode").toString().trim() : "";
String post_no =
hto.get("outsid").toString() != null ? hto.get("outsid").toString().trim() : "";
// 如果物流公司为空则忽略处理
if (post_company.trim().equals("")) {
Log.warn(username, jobName + " 快递公司为空！订单号:" + orderid + "");
continue;
}
// 如果物流公司为空则忽略处理
if (post_no.trim().equals("")) {
Log.warn(username, jobName + "快递单号为空！订单号:" + orderid + "");
continue;
}
if (!StringUtil.isNumeric(orderid)) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 4";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=4";
SQLHelper.executeSQL(conn, sql);
Log.warn(username, jobName + " 订单号【" + orderid + "】不全是数字!");
continue;
}
TaobaoClient client = new DefaultTaobaoClient(Params.url, Params.appkey, Params.appsecret);
LogisticsConsignResendRequest req = new LogisticsConsignResendRequest();
req.setOutSid(post_no);
req.setTid(TranTid(orderid));
req.setCompanyCode(post_company);
LogisticsConsignResendResponse rsp = client.execute(req, Params.authcode);
if (rsp.isSuccess()) {
try {
conn.setAutoCommit(false);
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 4";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=4";
SQLHelper.executeSQL(conn, sql);
conn.commit();
conn.setAutoCommit(true);
} catch (Exception sqle) {
if (!conn.getAutoCommit())
try {
conn.rollback();
} catch (Exception e1) {
}
try {
conn.setAutoCommit(true);
} catch (Exception e1) {
}
// throw new JSQLException(sql, sqle);
}
Log.info(
username,
"处理订单【" + orderid + "】发货成功,快递公司【" + post_company + "】,快递单号【" + post_no + "】",
null);
} else {
if (rsp.getSubMsg().indexOf("不能重复发货") >= 0 || rsp.getSubMsg().indexOf("发货类型不匹配") >= 0) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 4";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=4";
SQLHelper.executeSQL(conn, sql);
Log.info(
username,
"订单【" + orderid + "】不能重复发货,快递公司【" + post_company + "】,快递单号【" + post_no + "】",
null);
} else if (rsp.getSubMsg().indexOf("订单未发货") >= 0) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 4";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=4";
SQLHelper.executeSQL(conn, sql);
Log.info(
username,
"订单【" + orderid + "】可能未发货，或已经退货,快递公司【" + post_company + "】,快递单号【" + post_no + "】",
null);
} else if ((rsp.getSubMsg().indexOf("没有权限进行发货") >= 0)
|| rsp.getSubMsg().indexOf("没有权限发货") >= 0
|| rsp.getSubMsg().indexOf("当前订单状态不支持修改") >= 0) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 4";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=4";
SQLHelper.executeSQL(conn, sql);
Log.info(
username,
"没有权限发货,订单【" + orderid + "】,快递公司【" + post_company + "】,快递单号【" + post_no + "】",
null);
} else if (rsp.getSubMsg().indexOf("物流订单不存在") >= 0
|| rsp.getSubMsg().indexOf("订单已经被拆单") >= 0
|| rsp.getSubMsg().indexOf("当前操作的订单是拆单订单") >= 0) {
TaobaoClient subclient =
new DefaultTaobaoClient(Params.url, Params.appkey, Params.appsecret);
LogisticsOfflineSendRequest subreq = new LogisticsOfflineSendRequest();
subreq.setOutSid(post_no);
subreq.setTid(TranTid(orderid));
subreq.setCompanyCode(post_company);
subreq.setIsSplit(1L);
String subtids = "";
sql =
"select oid from customerorderitem a with(nolock),customerorder b with(nolock),"
+ "customerdelive c with(nolock) where a.sheetid=b.sheetid and a.sheetid=c.refsheetid "
+ "and c.customersheetid='"
+ orderid
+ "' and c.delivery='"
+ post_company
+ "' "
+ "and c.deliverysheetid='"
+ post_no
+ "'";
List sublist = SQLHelper.multiRowListSelect(conn, sql);
if (sublist.size() > 0) {
for (Iterator it = sublist.iterator(); it.hasNext(); ) {
String oid = (String) it.next();
subtids = oid + "," + subtids;
}
subtids = subtids.substring(0, subtids.length() - 1);
subreq.setSubTid(subtids);
LogisticsOfflineSendResponse subrsp = client.execute(subreq, Params.authcode);
if (subrsp.isSuccess()) {
Log.info(
username,
"处理订单【"
+ orderid
+ "】,子订单【"
+ subtids
+ "】发货成功,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】",
null);
}
}
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 4";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=4";
SQLHelper.executeSQL(conn, sql);
Log.info(
jobName,
"物流订单不存在或订单已经被拆,订单【"
+ orderid
+ "】,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】");
} else if (rsp.getSubMsg().indexOf("运单号不符合规则或已经被使用") >= 0) {
// 公司内部自提发货处理
if ((post_no.toUpperCase().indexOf("1111111") >= 0)
|| (post_no.toUpperCase().indexOf("YJ") >= 0)) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 4";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=4";
SQLHelper.executeSQL(conn, sql);
} else {
String cc = "";
if (post_no.toUpperCase().indexOf("EH") == 0) {
cc = "EMS";
} else if (post_no.toUpperCase().indexOf("101") == 0) {
cc = "SF";
} else if (post_no.toUpperCase().indexOf("368") == 0) {
cc = "STO";
} else if (post_no.toUpperCase().indexOf("W") == 0) {
cc = "YTO";
} else cc = post_company;
sql =
"update ns_delivery set companycode='"
+ cc
+ "' where SheetID = '"
+ sheetid
+ "'";
SQLHelper.executeSQL(conn, sql);
}
Log.info(
username,
"运单号不符合规则或已经被使用,订单【"
+ orderid
+ "】,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】",
null);
} else if (rsp.getSubMsg().indexOf("该订单不支持修改") >= 0) {
sql =
"insert into IT_UpNoteBak(Owner,SheetID,SheetType,Sender,Receiver,Notetime,HandleTime,Flag) "
+ " select Owner , SheetID , SheetType , Sender , Receiver , Notetime , getdate() , 1 from IT_UpNote "
+ " where SheetID = '"
+ sheetid
+ "' and SheetType = 4";
SQLHelper.executeSQL(conn, sql);
sql = "delete from IT_UpNote where SheetID='" + sheetid + "' and sheettype=4";
SQLHelper.executeSQL(conn, sql);
Log.info(
jobName,
"处理订单【"
+ orderid
+ "】发货失败,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】"
+ "错误信息:"
+ rsp.getSubMsg()
+ rsp.getMsg());
} else
Log.info(
username,
"处理订单【"
+ orderid
+ "】发货失败,快递公司【"
+ post_company
+ "】,快递单号【"
+ post_no
+ "】"
+ "错误信息:"
+ rsp.getSubMsg()
+ rsp.getMsg(),
null);
}
} catch (Exception ex) {
if (conn != null && !conn.getAutoCommit()) conn.rollback();
Log.info(username, "修改发货信息作业出错，订单号: " + orderid + ",错误信息: " + ex.getMessage(), null);
}
}
}