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);
}
}
}
// 检查取消订单 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退货订单任务处理完毕!");
}
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, "关闭数据库连接失败");
}
}
}
/** 检查未入待发货订单 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);
}
}
}
