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()); } }