Exemple #1
0
 // ²éѯÉÌÆ·¿â´æ
 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);
 }
Exemple #2
0
 // ²éѯ¶©µ¥×´Ì¬
 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);
 }
Exemple #3
0
  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);
  }