public static void exportOrders(
String fileName, List<Order> orderList, List<String> orderStatusList) {
logger.info("Export Orders to excel");
ExcelGenerator generator = new ExcelGenerator(fileName);
List<String[]> headerList = new ArrayList<>();
List<String> sheetNames = new ArrayList<>();
for (String status : orderStatusList) {
sheetNames.add(status);
headerList.add(new String[] {"用户名", "订单时间", "配送时间", "门店信息", "收货人", "联系方式", "状态"});
}
List<List<String[]>> contents = new ArrayList<>();
for (String status : orderStatusList) {
List<String[]> content = new ArrayList<>();
List<Order> subOrderList = getOrderListByStatus(orderList, status);
for (Order order : subOrderList) {
content.add(
new String[] {
order.getUserId(),
order.getOrderTs(),
order.getDeliveryTs(),
order.getBuyerInfo(),
order.getConsignee(),
order.getConsigneeContact(),
order.getStatus()
});
}
contents.add(content);
}
try {
generator.generate(sheetNames, headerList, contents);
} catch (IOException e) {
e.printStackTrace();
return;
}
}
private static List<Order> getOrderListByStatus(List<Order> orderList, String status) {
List<Order> subOrderList = new ArrayList<>();
for (Order order : orderList) {
if (order.getStatus().equals(status)) {
subOrderList.add(order);
}
}
return subOrderList;
}
public void actionPerformed(final ActionEvent anEvent) {
int selected = view.getOrderTable().getSelectedRow();
if (selected > -1) {
int selectedItem = customerMenu.getItemIds().get(selected);
String comment = view.getCommentText();
try {
Order thisOrder = orders.get(currentOrder);
thisOrder.addItem(selectedItem, comment);
if (thisOrder.getStatus() == 0) {
thisOrder.setStatus(1);
updateStatusLabel();
}
MenuItem itemRef = customerMenu.getItemByID(selectedItem);
view.clearCommentText();
view.addOrderRow(new Object[] {itemRef.getName(), comment});
} catch (Exception e) {
e.printStackTrace();
}
}
}
public final void updateStatusLabel() {
Order thisOrder = orders.get(currentOrder);
view.getStatusLabel().setText(OrderStatus.fromInt(thisOrder.getStatus()).toString());
}
/*
* 转入一个订单到接口表
*/
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());
}
}