// ²éѯÉÌÆ·¿â´æ
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 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);
}