jin8000608172
- 浏览: 136107 次
- 性别:
- 来自: 深圳
-
最新评论
-
wzk2111：
代码 可用，楼主的思路可以参考
javascript加密java解密 -
Imini123：
[align=center][color=red][/colo ...
freemarker实现通用分页，首页静态化，通用select，通用文章显示 -
igting：
js对+,@符号的加密应该有问题，java解密不对。
javascript加密java解密 -
Seanman：
初学freemarker,源码不全，不知道怎么用
freemarker实现通用分页，首页静态化，通用select，通用文章显示 -
无敌洋葱头：
目前这个只能对0-9 A-Z a-z加密，而且js还有问题。c ...
javascript加密java解密
package com.xxxpiao.datacompare.action;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Colour;
import jxl.format.VerticalAlignment;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import org.apache.commons.lang.StringUtils;
import org.apache.struts2.ServletActionContext;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Controller;
import com.xxxpiao.admin.action.BaseAction;
import com.xxxpiao.admin.service.gplantop.PlanManagerService;
import com.xxxpiao.common.entity.enumerated.Game;
import com.xxxpiao.common.entity.issue.BetGameIssue;
import com.xxxpiao.common.entity.ticket.BetTicketChannel;
import com.xxxpiao.common.service.ticket.TicketChannelService;
import com.xxxpiao.common.utils.DateUtil;
import com.xxxpiao.datacompare.entity.AccountTicketCondition;
import com.xxxpiao.datacompare.entity.AccountTicketTotal;
import com.xxxpiao.datacompare.service.AccountTicketService;
import com.ibm.icu.math.BigDecimal;
import com.opensymphony.xwork2.ActionContext;
@Controller
@Scope("prototype")
public class AccountTicketAction extends BaseAction<Object> {
private static final long serialVersionUID = 3903998863096688228L;
private Logger logger = LoggerFactory.getLogger(getClass());
@Autowired
private PlanManagerService planManagerService;
private AccountTicketCondition accountTicketCondition;
private List<Game> games;
/** 显示最近20期 */
private static final int ISSUE_SHOW_SIZE = 20;
/***************************固化数组************************************/
private Integer[] gameIds;
private Integer[] ids;
private String[] issueNos;
private String[] ticketChannelNames;
private Integer[] ticketChannelIds;
private Calendar[] printDates;
private Calendar[] sendDates;
private Long[] ownTicketCnts;
private Double[] ownAmounts;
private Long[] thirdTicketCnts;
private Double[] thirdAmounts;
// private Double[] ownPretaxPrizes;
private Double[] ownPostaxPrizes;
// private Double[] thirdPretaxPrizes;
private Double[] thirdPostaxPrizes;
/****************************固化数组**********************************/
@Autowired
private AccountTicketService accountTicketService;
private List<AccountTicketTotal> accountTicketTotalList;
@Autowired
private TicketChannelService ticketChannelService;
private List<BetTicketChannel> ticketChannelList;
// private List<BetGameIssue> betGameIssues;
private Double ownTicketCntTotal;
private Double ownAmountTotal;
// private Double ownPretaxPrizeTotal;
private Double ownPostaxPrizeTotal;
private Double thirdTicketCntTotal;
private Double thirdAmountTotal;
// private Double thirdPretaxPrizeTotal;
private Double thirdPostaxPrizeTotal;
private Double ownThirdTicketCntDifferTotal;
private Double ownThirdAmountDifferTotal;
private Double ownThirdPostaxPrizeDifferTotal;
/**
* 进入出票汇总查询首页
* @return
*/
public String list(){
games=Game.getAll();
// betGameIssues=planManagerService.getBetGameIssueList(
// Game.findByIndex(accountTicketCondition.getGameId()), ISSUE_SHOW_SIZE);
ticketChannelList=ticketChannelService.queryAllChannel();
return SUCCESS;
}
/**
* 查询出票汇总
* @return
*/
public String findTicketTotal(){
games=Game.getAll();
// if(accountTicketCondition.getGameId()!=null&&accountTicketCondition.getGameId()!=-1){
// betGameIssues=planManagerService.getBetGameIssueList(
// Game.findByIndex(accountTicketCondition.getGameId()), ISSUE_SHOW_SIZE);
// }
ticketChannelList=ticketChannelService.queryAllChannel();
Map<String, Object> paramMap = new HashMap<String, Object>();
paramMap.put("ticketChannelId", accountTicketCondition.getTicketChannelId());
if(accountTicketCondition.getGroupType()!=null){
paramMap.put("groupType", accountTicketCondition.getGroupType());
}
if(accountTicketCondition.getIssueNoStart()!=null){
paramMap.put("issueNoStart", accountTicketCondition.getIssueNoStart());
}
if(accountTicketCondition.getIssueNoEnd()!=null){
paramMap.put("issueNoEnd", accountTicketCondition.getIssueNoEnd());
}
if(accountTicketCondition.getGameId()!=null){
paramMap.put("gameId", accountTicketCondition.getGameId());
}
if(accountTicketCondition.getPrintTimeStart()!=null){
paramMap.put("printTimeStart", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accountTicketCondition.getPrintTimeStart().getTime()));
// paramMap.put("printTimeStart", DateUtil.toYYYY_MM_DD(accountTicketCondition.getPrintTimeStart()));
}
if(accountTicketCondition.getPrintTimeEnd()!=null){
paramMap.put("printTimeEnd", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accountTicketCondition.getPrintTimeEnd().getTime()));
// paramMap.put("printTimeEnd", DateUtil.toYYYY_MM_DD(DateUtil.add(accountTicketCondition.getPrintTimeEnd(), Calendar.DATE, 1)));
}
if(accountTicketCondition.getSendTimeStart()!=null){
paramMap.put("sendTimeStart", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accountTicketCondition.getSendTimeStart().getTime()));
// paramMap.put("sendTimeStart", DateUtil.toYYYY_MM_DD(accountTicketCondition.getSendTimeStart()));
}
if(accountTicketCondition.getSendTimeEnd()!=null){
paramMap.put("sendTimeEnd", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accountTicketCondition.getSendTimeEnd().getTime()));
// paramMap.put("sendTimeEnd", DateUtil.toYYYY_MM_DD(DateUtil.add(accountTicketCondition.getSendTimeEnd(), Calendar.DATE, 1)));
}
accountTicketTotalList=accountTicketService.queryAccountTicketTotal(paramMap);
BigDecimal ownCnt =new BigDecimal(0);
BigDecimal ownAmount =new BigDecimal(0);
// BigDecimal ownPretaxPrize =new BigDecimal(0);
BigDecimal ownPostaxPrize =new BigDecimal(0);
BigDecimal thirdCnt =new BigDecimal(0);
BigDecimal thirdAmount =new BigDecimal(0);
// BigDecimal thirdPretaxPrize =new BigDecimal(0);
BigDecimal thirdPostaxPrize =new BigDecimal(0);
for(AccountTicketTotal accountTicketTotal:accountTicketTotalList){
ownCnt=ownCnt.add(new BigDecimal(accountTicketTotal.getOwnTicketCnt()));
ownAmount=ownAmount.add(new BigDecimal(accountTicketTotal.getOwnAmount()));
// ownPretaxPrize=ownPretaxPrize.add(new BigDecimal(accountTicketTotal.getOwnPretaxPrize()));
ownPostaxPrize=ownPostaxPrize.add(new BigDecimal(accountTicketTotal.getOwnPostaxPrize()));
thirdCnt=thirdCnt.add(new BigDecimal(accountTicketTotal.getThirdTicketCnt()));
thirdAmount=thirdAmount.add(new BigDecimal(accountTicketTotal.getThirdAmount()));
// thirdPretaxPrize=thirdPretaxPrize.add(new BigDecimal(accountTicketTotal.getThirdPretaxPrize()));
thirdPostaxPrize=thirdPostaxPrize.add(new BigDecimal(accountTicketTotal.getThirdPostaxPrize()));
BigDecimal ownCount =new BigDecimal(accountTicketTotal.getOwnTicketCnt());
BigDecimal ownAmt =new BigDecimal(accountTicketTotal.getOwnAmount());
BigDecimal ownPtxPrize =new BigDecimal(accountTicketTotal.getOwnPostaxPrize());
BigDecimal thirdCount =new BigDecimal(accountTicketTotal.getThirdTicketCnt());
BigDecimal thirdAmt =new BigDecimal(accountTicketTotal.getThirdAmount());
BigDecimal thirdPtxPrize =new BigDecimal(accountTicketTotal.getThirdPostaxPrize());
accountTicketTotal.setOwnThirdCntsDiffer(ownCount.subtract(thirdCount).doubleValue());
accountTicketTotal.setOwnThirdAmountsDiffer(ownAmt.subtract(thirdAmt).doubleValue());
accountTicketTotal.setOwnThirdPostaxPrizesDiffer(ownPtxPrize.subtract(thirdPtxPrize).doubleValue());
}
ownTicketCntTotal=ownCnt.doubleValue();
thirdTicketCntTotal=thirdCnt.doubleValue();
ownThirdTicketCntDifferTotal=ownCnt.subtract(thirdCnt).doubleValue();
ownAmountTotal=ownAmount.doubleValue();
thirdAmountTotal=thirdAmount.doubleValue();
ownThirdAmountDifferTotal=ownAmount.subtract(thirdAmount).doubleValue();
// ownPretaxPrizeTotal=ownPretaxPrize.doubleValue();
// thirdPretaxPrizeTotal=thirdPretaxPrize.doubleValue();
ownPostaxPrizeTotal=ownPostaxPrize.doubleValue();
thirdPostaxPrizeTotal=thirdPostaxPrize.doubleValue();
ownThirdPostaxPrizeDifferTotal=ownPostaxPrize.subtract(thirdPostaxPrize).doubleValue();
return SUCCESS;
}
public String ajaxTicketTotalExport(){
Double[] totals= new Double[9];
if(accountTicketCondition.getGameId()==-1){
Map<String, Object> paramMap = new HashMap<String, Object>();
paramMap.put("ticketChannelId", accountTicketCondition.getTicketChannelId());
if(accountTicketCondition.getGroupType()!=null){
paramMap.put("groupType", accountTicketCondition.getGroupType());
}
if(accountTicketCondition.getIssueNoStart()!=null){
paramMap.put("issueNoStart", accountTicketCondition.getIssueNoStart());
}
if(accountTicketCondition.getIssueNoEnd()!=null){
paramMap.put("issueNoEnd", accountTicketCondition.getIssueNoEnd());
}
if(accountTicketCondition.getGameId()!=null){
paramMap.put("gameId", accountTicketCondition.getGameId());
}
if(accountTicketCondition.getPrintTimeStart()!=null){
paramMap.put("printTimeStart", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accountTicketCondition.getPrintTimeStart().getTime()));
// paramMap.put("printTimeStart", DateUtil.toYYYY_MM_DD(accountTicketCondition.getPrintTimeStart()));
}
if(accountTicketCondition.getPrintTimeEnd()!=null){
paramMap.put("printTimeEnd", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accountTicketCondition.getPrintTimeEnd().getTime()));
// paramMap.put("printTimeEnd", DateUtil.toYYYY_MM_DD(DateUtil.add(accountTicketCondition.getPrintTimeEnd(), Calendar.DATE, 1)));
}
if(accountTicketCondition.getSendTimeStart()!=null){
paramMap.put("sendTimeStart", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accountTicketCondition.getSendTimeStart().getTime()));
// paramMap.put("sendTimeStart", DateUtil.toYYYY_MM_DD(accountTicketCondition.getSendTimeStart()));
}
if(accountTicketCondition.getSendTimeEnd()!=null){
paramMap.put("sendTimeEnd", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(accountTicketCondition.getSendTimeEnd().getTime()));
// paramMap.put("sendTimeEnd", DateUtil.toYYYY_MM_DD(DateUtil.add(accountTicketCondition.getSendTimeEnd(), Calendar.DATE, 1)));
}
accountTicketTotalList=accountTicketService.queryAccountTicketTotal(paramMap);
BigDecimal ownCnt =new BigDecimal(0);
BigDecimal ownAmount =new BigDecimal(0);
// BigDecimal ownPretaxPrize =new BigDecimal(0);
BigDecimal ownPostaxPrize =new BigDecimal(0);
BigDecimal thirdCnt =new BigDecimal(0);
BigDecimal thirdAmount =new BigDecimal(0);
// BigDecimal thirdPretaxPrize =new BigDecimal(0);
BigDecimal thirdPostaxPrize =new BigDecimal(0);
for(AccountTicketTotal accountTicketTotal:accountTicketTotalList){
ownCnt=ownCnt.add(new BigDecimal(accountTicketTotal.getOwnTicketCnt()));
ownAmount=ownAmount.add(new BigDecimal(accountTicketTotal.getOwnAmount()));
// ownPretaxPrize=ownPretaxPrize.add(new BigDecimal(accountTicketTotal.getOwnPretaxPrize()));
ownPostaxPrize=ownPostaxPrize.add(new BigDecimal(accountTicketTotal.getOwnPostaxPrize()));
thirdCnt=thirdCnt.add(new BigDecimal(accountTicketTotal.getThirdTicketCnt()));
thirdAmount=thirdAmount.add(new BigDecimal(accountTicketTotal.getThirdAmount()));
// thirdPretaxPrize=thirdPretaxPrize.add(new BigDecimal(accountTicketTotal.getThirdPretaxPrize()));
thirdPostaxPrize=thirdPostaxPrize.add(new BigDecimal(accountTicketTotal.getThirdPostaxPrize()));
BigDecimal ownCount =new BigDecimal(accountTicketTotal.getOwnTicketCnt());
BigDecimal ownAmt =new BigDecimal(accountTicketTotal.getOwnAmount());
BigDecimal ownPtxPrize =new BigDecimal(accountTicketTotal.getOwnPostaxPrize());
BigDecimal thirdCount =new BigDecimal(accountTicketTotal.getThirdTicketCnt());
BigDecimal thirdAmt =new BigDecimal(accountTicketTotal.getThirdAmount());
BigDecimal thirdPtxPrize =new BigDecimal(accountTicketTotal.getThirdPostaxPrize());
accountTicketTotal.setOwnThirdCntsDiffer(ownCount.subtract(thirdCount).doubleValue());
accountTicketTotal.setOwnThirdAmountsDiffer(ownAmt.subtract(thirdAmt).doubleValue());
accountTicketTotal.setOwnThirdPostaxPrizesDiffer(ownPtxPrize.subtract(thirdPtxPrize).doubleValue());
}
totals[0]=ownCnt.doubleValue();
totals[1]=thirdCnt.doubleValue();
totals[2]=ownCnt.subtract(thirdCnt).doubleValue();
totals[3]=ownAmount.doubleValue();
totals[4]=thirdAmount.doubleValue();
totals[5]=ownAmount.subtract(thirdAmount).doubleValue();
// ownPretaxPrizeTotal=ownPretaxPrize.doubleValue();
// thirdPretaxPrizeTotal=thirdPretaxPrize.doubleValue();
totals[6]=ownPostaxPrize.doubleValue();
totals[7]=thirdPostaxPrize.doubleValue();
totals[8]=ownPostaxPrize.subtract(thirdPostaxPrize).doubleValue();
// totals[0]=ownCnt.doubleValue();
// totals[1]=ownAmount.doubleValue();
// totals[2]=ownPretaxPrize.doubleValue();
// totals[3]=ownPostaxPrize.doubleValue();
// totals[4]=thirdCnt.doubleValue();
// totals[5]=thirdAmount.doubleValue();
// totals[6]=thirdPretaxPrize.doubleValue();
// totals[7]=thirdPostaxPrize.doubleValue();
// totals[8]=thirdPostaxPrize.doubleValue();
}else{
accountTicketTotalList=new ArrayList<AccountTicketTotal>();
if(gameIds==null||gameIds.length<1){
return null;
}
for(int i=0;i<gameIds.length;i++){
AccountTicketTotal accountTicketTotal=new AccountTicketTotal(gameIds[i], issueNos[i],
ticketChannelNames[i], ownTicketCnts[i],
ownAmounts[i],
ownPostaxPrizes[i], thirdTicketCnts[i],
thirdAmounts[i],
thirdPostaxPrizes[i], printDates[i],
sendDates[i], ticketChannelIds[i]);
BigDecimal ownCount =new BigDecimal(ownTicketCnts[i]);
BigDecimal ownAmt =new BigDecimal(ownAmounts[i]);
BigDecimal ownPtxPrize =new BigDecimal(ownPostaxPrizes[i]);
BigDecimal thirdCount =new BigDecimal(thirdTicketCnts[i]);
BigDecimal thirdAmt =new BigDecimal(thirdAmounts[i]);
BigDecimal thirdPtxPrize =new BigDecimal(thirdPostaxPrizes[i]);
accountTicketTotal.setOwnThirdCntsDiffer(ownCount.subtract(thirdCount).doubleValue());
accountTicketTotal.setOwnThirdAmountsDiffer(ownAmt.subtract(thirdAmt).doubleValue());
accountTicketTotal.setOwnThirdPostaxPrizesDiffer(ownPtxPrize.subtract(thirdPtxPrize).doubleValue());
accountTicketTotalList.add(accountTicketTotal);
}
totals[0]=ownTicketCntTotal;
totals[1]=thirdTicketCntTotal;
totals[2]=ownThirdTicketCntDifferTotal;
totals[3]=ownAmountTotal;
totals[4]=thirdAmountTotal;
totals[5]=ownThirdAmountDifferTotal;
// ownPretaxPrizeTotal=ownPretaxPrize.doubleValue();
// thirdPretaxPrizeTotal=thirdPretaxPrize.doubleValue();
totals[6]=ownPostaxPrizeTotal;
totals[7]=thirdPostaxPrizeTotal;
totals[8]=ownThirdPostaxPrizeDifferTotal;
}
this.exportTicketTotalReport(accountTicketTotalList, totals);
return null;
}
/**
* 保存汇总结果
* @return
*/
public String saveTotalResult(){
final List<AccountTicketTotal> accountTicketTotals=new ArrayList<AccountTicketTotal>();
long conditionId=accountTicketService.generateConditionSequence();
accountTicketCondition.setId(conditionId);
accountTicketCondition.setCreateUser(getCurrentAccount());
accountTicketCondition.setStatus(0);
if(accountTicketCondition.getIssueNoStart()!=null
&&!"".equals(accountTicketCondition.getIssueNoStart())
&&accountTicketCondition.getIssueNoEnd()!=null
&&!"".equals(accountTicketCondition.getIssueNoEnd())){
accountTicketCondition.setIssueNo(accountTicketCondition.getIssueNoStart()+"--"+accountTicketCondition.getIssueNoEnd());
}
final AccountTicketCondition tempCondition=accountTicketCondition;
for(int i=0;i<gameIds.length;i++){
AccountTicketTotal accountTicketTotal=new AccountTicketTotal(gameIds[i], issueNos[i],
ticketChannelNames[i], ownTicketCnts[i],
ownAmounts[i],
ownPostaxPrizes[i], thirdTicketCnts[i],
thirdAmounts[i],
thirdPostaxPrizes[i], printDates[i],
sendDates[i], ticketChannelIds[i]);
accountTicketTotal.setConditionId(conditionId);
accountTicketTotal.setCreateUser(getCurrentAccount());
accountTicketTotal.setStatus(0);
accountTicketTotals.add(accountTicketTotal);
}
accountTicketService.saveConditionAndTotals(tempCondition, accountTicketTotals);
games=Game.getAll();
// betGameIssues=planManagerService.getBetGameIssueList(
// Game.findByIndex(accountTicketCondition.getGameId()), ISSUE_SHOW_SIZE);
ticketChannelList=ticketChannelService.queryAllChannel();
return SUCCESS;
}
/**
* 进入出票汇总结果管理首页
* @return
*/
public String enterTicketResultManager(){
games=Game.getAll();
return SUCCESS;
}
/**
* 查询出票汇总条件
* @return
*/
public String queryTicketCondition(){
games=Game.getAll();
page=accountTicketService.queryTicketConditionDataPage(accountTicketCondition, getPage());
return SUCCESS;
}
/**
* 修改出票汇总结果数据
*/
public String editTicketResultUI(){
accountTicketCondition=accountTicketService.queryTicketConditionById(accountTicketCondition.getId());
accountTicketTotalList=accountTicketService.queryTicketTotalByConditionId(accountTicketCondition.getId());
return SUCCESS;
}
/**
* 修改出票汇总结果数据
*/
public String editTicketResult(){
final List<AccountTicketTotal> accountTicketTotals=new ArrayList<AccountTicketTotal>();
for(int i=0;i<ids.length;i++){
AccountTicketTotal accountTicketTotal=new AccountTicketTotal();
accountTicketTotal.setId(ids[i]);
accountTicketTotal.setThirdAmount(thirdAmounts[i]);
accountTicketTotal.setThirdTicketCnt(thirdTicketCnts[i]);
// accountTicketTotal.setThirdPretaxPrize(thirdPretaxPrizes[i]);
accountTicketTotal.setThirdPostaxPrize(thirdPostaxPrizes[i]);
accountTicketTotals.add(accountTicketTotal);
}
accountTicketService.updateTicketTotals(accountTicketTotals);
accountTicketCondition=accountTicketService.queryTicketConditionById(accountTicketCondition.getId());
accountTicketTotalList=accountTicketService.queryTicketTotalByConditionId(accountTicketCondition.getId());
return SUCCESS;
}
/**
* 修改出票汇总结果数据
*/
public String confirmTicketResult(){
final List<AccountTicketTotal> accountTicketTotals=new ArrayList<AccountTicketTotal>();
final AccountTicketCondition tempCondition=accountTicketCondition;
tempCondition.setStatus(2);
for(int i=0;i<ids.length;i++){
AccountTicketTotal accountTicketTotal=new AccountTicketTotal();
accountTicketTotal.setId(ids[i]);
accountTicketTotal.setStatus(2);
accountTicketTotals.add(accountTicketTotal);
}
accountTicketService.updateTicketTotalStatuss(accountTicketTotals,tempCondition);
accountTicketCondition=accountTicketService.queryTicketConditionById(accountTicketCondition.getId());
accountTicketTotalList=accountTicketService.queryTicketTotalByConditionId(accountTicketCondition.getId());
return SUCCESS;
}
/**
* 出票汇总详情
*/
public String viewTicketResult(){
accountTicketCondition=accountTicketService.queryTicketConditionById(accountTicketCondition.getId());
accountTicketTotalList=accountTicketService.queryTicketTotalByConditionId(accountTicketCondition.getId());
return SUCCESS;
}
/**
* 通过AJAX方式获取彩种期数
*
* @return
*/
public String ajaxGetIssue() {
Game game = Game.findByIndex(accountTicketCondition.getGameId());
List<BetGameIssue> issueList = planManagerService.getBetGameIssueList(
game, ISSUE_SHOW_SIZE);
List<String> issueStr = new ArrayList<String>(issueList.size());
for (BetGameIssue bgi : issueList) {
issueStr.add(bgi.getIssueNo());
}
ActionContext ctx = ActionContext.getContext();
HttpServletResponse response = (HttpServletResponse) ctx
.get(ServletActionContext.HTTP_RESPONSE);
try {
response.getWriter().write(StringUtils.join(issueStr, ","));
} catch (IOException e) {
e.printStackTrace();
}
return null;
}
/**
* 删除出票汇总结果数据
*/
public String deleteTicketResult(){
final List<AccountTicketTotal> accountTicketTotals=accountTicketService.queryTicketTotalByConditionId(accountTicketCondition.getId());
final AccountTicketCondition tempCondition=accountTicketCondition;
tempCondition.setStatus(1);
for(AccountTicketTotal accountTicketTotal:accountTicketTotals){
accountTicketTotal.setStatus(1);
}
accountTicketService.updateTicketTotalStatuss(accountTicketTotals,tempCondition);
games=Game.getAll();
return SUCCESS;
}
/**
* 表格首行样式
* @return
* @throws Exception
* @create_time 2013-8-29 下午5:52:44
*/
private WritableCellFormat getHeaderFmt() throws Exception {
WritableFont font = new WritableFont(WritableFont.TIMES, 16, WritableFont.BOLD);// 定义字体
WritableCellFormat format = new WritableCellFormat(font);
format.setAlignment(Alignment.CENTRE);// 左右居中
format.setVerticalAlignment(VerticalAlignment.CENTRE);// 上下居中
format.setBackground(Colour.SEA_GREEN);// 背景
format.setWrap(true);
return format;
}
/**
* 表格主体样式
* @return
* @throws Exception
* @create_time 2013-8-29 下午5:55:45
*/
private WritableCellFormat getBodyFmt() throws Exception {
WritableFont font = new WritableFont(WritableFont.TIMES, 12);// 定义字体
WritableCellFormat format = new WritableCellFormat(font);
format.setVerticalAlignment(VerticalAlignment.CENTRE);// 上下居中
return format;
}
/**
* 表格尾行样式
* @return
* @throws Exception
* @create_time 2013-8-29 下午5:52:44
*/
private WritableCellFormat getFooterFmt() throws Exception {
WritableFont font = new WritableFont(WritableFont.TIMES, 14);// 定义字体
WritableCellFormat format = new WritableCellFormat(font);
format.setVerticalAlignment(VerticalAlignment.CENTRE);// 上下居中
format.setBackground(Colour.ORANGE);
return format;
}
/**
* 出票汇总Excel导出
* @create_time 2014-04-22
*/
private void exportTicketTotalReport(List<AccountTicketTotal> accountTicketTotals,Double[] totals) {
try {
HttpServletResponse response = ServletActionContext.getResponse();
response.setContentType("application/vnd.ms-excel");
ServletOutputStream os = response.getOutputStream();
// 创建EXCEL文档
WritableWorkbook workbook = Workbook.createWorkbook(os);
// 生成第一个工作簿
WritableSheet sheet = workbook.createSheet("出票汇总", 0);
WritableCellFormat format = getHeaderFmt();
int rowIndex = 0;
int cellIndex = 0;
sheet.addCell(new Label(cellIndex, rowIndex, "彩种", format));
sheet.setColumnView(cellIndex, 15);
sheet.addCell(new Label(++cellIndex, rowIndex, "彩期", format));
sheet.setColumnView(cellIndex, 15);
sheet.addCell(new Label(++cellIndex, rowIndex, "出票商", format));
sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "打票日期", format));
sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "送票日期", format));
sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "系统出票总数量", format));
sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "第三方出票总数量", format));
sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "出票数量差异", format));
sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "系统出票总金额", format));
sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "第三方出票总金额", format));
sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "出票金额差异", format));
sheet.setColumnView(cellIndex, 20);
// sheet.addCell(new Label(++cellIndex, rowIndex, "系统税前中奖总金额", format));
// sheet.setColumnView(cellIndex, 20);
// sheet.addCell(new Label(++cellIndex, rowIndex, "第三方税前中奖总金额", format));
// sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "系统税后中奖总金额", format));
sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "第三方税后中奖总金额", format));
sheet.setColumnView(cellIndex, 20);
sheet.addCell(new Label(++cellIndex, rowIndex, "税后中奖金额差异", format));
sheet.setColumnView(cellIndex, 20);
format = getBodyFmt();
if (accountTicketTotals != null && accountTicketTotals.size()>0) {
for (AccountTicketTotal accountTicketTotal: accountTicketTotals) {
rowIndex++;
sheet.setRowView(rowIndex, 350);
cellIndex = 0;
sheet.addCell(new Label(cellIndex, rowIndex,Game.findByIndex(accountTicketTotal.getGameId()).getDescription(), format));
sheet.addCell(new Label(++cellIndex, rowIndex,accountTicketTotal.getIssueNo(), format));
sheet.addCell(new Label(++cellIndex, rowIndex,accountTicketTotal.getTicketChannelName(), format));
sheet.addCell(new Label(++cellIndex, rowIndex,accountTicketTotal.getPrintDate()==null?"":DateUtil.toYYYY_MM_DD(accountTicketTotal.getPrintDate()), format));
sheet.addCell(new Label(++cellIndex, rowIndex,accountTicketTotal.getSendDate()==null?"":DateUtil.toYYYY_MM_DD(accountTicketTotal.getSendDate()), format));
sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getOwnTicketCnt(), format));
sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getThirdTicketCnt(), format));
sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getOwnThirdCntsDiffer(), format));
sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getOwnAmount(), format));
sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getThirdAmount(), format));
sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getOwnThirdAmountsDiffer(), format));
// sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getOwnPretaxPrize(), format));
// sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getThirdPretaxPrize(), format));
sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getOwnPostaxPrize(), format));
sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getThirdPostaxPrize(), format));
sheet.addCell(new Number(++cellIndex, rowIndex, accountTicketTotal.getOwnThirdPostaxPrizesDiffer(), format));
}
format = getFooterFmt();
rowIndex++;
cellIndex = 0;
sheet.addCell(new Label(cellIndex, rowIndex,"", format));
sheet.addCell(new Label(++cellIndex, rowIndex,"", format));
sheet.addCell(new Label(++cellIndex, rowIndex,"", format));
sheet.addCell(new Label(++cellIndex, rowIndex,"", format));
sheet.addCell(new Label(++cellIndex, rowIndex,"合计：", format));
sheet.addCell(new Number(++cellIndex, rowIndex, totals[0], format));
sheet.addCell(new Number(++cellIndex, rowIndex, totals[1], format));
sheet.addCell(new Number(++cellIndex, rowIndex, totals[2], format));
sheet.addCell(new Number(++cellIndex, rowIndex, totals[3], format));
sheet.addCell(new Number(++cellIndex, rowIndex, totals[4], format));
sheet.addCell(new Number(++cellIndex, rowIndex, totals[5], format));
sheet.addCell(new Number(++cellIndex, rowIndex, totals[6], format));
sheet.addCell(new Number(++cellIndex, rowIndex, totals[7], format));
sheet.addCell(new Number(++cellIndex, rowIndex, totals[8], format));
}
workbook.write();
workbook.close();
os.flush();
os.close();
os=null;
} catch (Exception e) {
logger.error("导出出票汇总数据EXCEL报表异常", e);
}
}
public PlanManagerService getPlanManagerService() {
return planManagerService;
}
public void setPlanManagerService(PlanManagerService planManagerService) {
this.planManagerService = planManagerService;
}
public AccountTicketCondition getAccountTicketCondition() {
return accountTicketCondition;
}
public void setAccountTicketCondition(
AccountTicketCondition accountTicketCondition) {
this.accountTicketCondition = accountTicketCondition;
}
public List<Game> getGames() {
return games;
}
public void setGames(List<Game> games) {
this.games = games;
}
public Integer[] getGameIds() {
return gameIds;
}
public void setGameIds(Integer[] gameIds) {
this.gameIds = gameIds;
}
public String[] getIssueNos() {
return issueNos;
}
public void setIssueNos(String[] issueNos) {
this.issueNos = issueNos;
}
public String[] getTicketChannelNames() {
return ticketChannelNames;
}
public void setTicketChannelNames(String[] ticketChannelNames) {
this.ticketChannelNames = ticketChannelNames;
}
public Integer[] getTicketChannelIds() {
return ticketChannelIds;
}
public void setTicketChannelIds(Integer[] ticketChannelIds) {
this.ticketChannelIds = ticketChannelIds;
}
public Calendar[] getPrintDates() {
return printDates;
}
public void setPrintDates(Calendar[] printDates) {
this.printDates = printDates;
}
public Calendar[] getSendDates() {
return sendDates;
}
public void setSendDates(Calendar[] sendDates) {
this.sendDates = sendDates;
}
public Long[] getOwnTicketCnts() {
return ownTicketCnts;
}
public void setOwnTicketCnts(Long[] ownTicketCnts) {
this.ownTicketCnts = ownTicketCnts;
}
public Long[] getThirdTicketCnts() {
return thirdTicketCnts;
}
public void setThirdTicketCnts(Long[] thirdTicketCnts) {
this.thirdTicketCnts = thirdTicketCnts;
}
public Double[] getOwnAmounts() {
return ownAmounts;
}
public void setOwnAmounts(Double[] ownAmounts) {
this.ownAmounts = ownAmounts;
}
public Double[] getThirdAmounts() {
return thirdAmounts;
}
public void setThirdAmounts(Double[] thirdAmounts) {
this.thirdAmounts = thirdAmounts;
}
// public Double[] getOwnPretaxPrizes() {
// return ownPretaxPrizes;
// }
//
// public void setOwnPretaxPrizes(Double[] ownPretaxPrizes) {
// this.ownPretaxPrizes = ownPretaxPrizes;
// }
public Double[] getOwnPostaxPrizes() {
return ownPostaxPrizes;
}
public void setOwnPostaxPrizes(Double[] ownPostaxPrizes) {
this.ownPostaxPrizes = ownPostaxPrizes;
}
// public Double[] getThirdPretaxPrizes() {
// return thirdPretaxPrizes;
// }
//
// public void setThirdPretaxPrizes(Double[] thirdPretaxPrizes) {
// this.thirdPretaxPrizes = thirdPretaxPrizes;
// }
public Double[] getThirdPostaxPrizes() {
return thirdPostaxPrizes;
}
public void setThirdPostaxPrizes(Double[] thirdPostaxPrizes) {
this.thirdPostaxPrizes = thirdPostaxPrizes;
}
public List<AccountTicketTotal> getAccountTicketTotalList() {
return accountTicketTotalList;
}
public void setAccountTicketTotalList(
List<AccountTicketTotal> accountTicketTotalList) {
this.accountTicketTotalList = accountTicketTotalList;
}
public List<BetTicketChannel> getTicketChannelList() {
return ticketChannelList;
}
public void setTicketChannelList(List<BetTicketChannel> ticketChannelList) {
this.ticketChannelList = ticketChannelList;
}
public TicketChannelService getTicketChannelService() {
return ticketChannelService;
}
public void setTicketChannelService(TicketChannelService ticketChannelService) {
this.ticketChannelService = ticketChannelService;
}
public AccountTicketService getAccountTicketService() {
return accountTicketService;
}
public void setAccountTicketService(AccountTicketService accountTicketService) {
this.accountTicketService = accountTicketService;
}
// public List<BetGameIssue> getBetGameIssues() {
// return betGameIssues;
// }
// public void setBetGameIssues(List<BetGameIssue> betGameIssues) {
// this.betGameIssues = betGameIssues;
// }
public Integer[] getIds() {
return ids;
}
public void setIds(Integer[] ids) {
this.ids = ids;
}
public Double getOwnTicketCntTotal() {
return ownTicketCntTotal;
}
public void setOwnTicketCntTotal(Double ownTicketCntTotal) {
this.ownTicketCntTotal = ownTicketCntTotal;
}
public Double getThirdTicketCntTotal() {
return thirdTicketCntTotal;
}
public void setThirdTicketCntTotal(Double thirdTicketCntTotal) {
this.thirdTicketCntTotal = thirdTicketCntTotal;
}
public Double getOwnAmountTotal() {
return ownAmountTotal;
}
public void setOwnAmountTotal(Double ownAmountTotal) {
this.ownAmountTotal = ownAmountTotal;
}
// public Double getOwnPretaxPrizeTotal() {
// return ownPretaxPrizeTotal;
// }
// public void setOwnPretaxPrizeTotal(Double ownPretaxPrizeTotal) {
// this.ownPretaxPrizeTotal = ownPretaxPrizeTotal;
// }
public Double getOwnPostaxPrizeTotal() {
return ownPostaxPrizeTotal;
}
public void setOwnPostaxPrizeTotal(Double ownPostaxPrizeTotal) {
this.ownPostaxPrizeTotal = ownPostaxPrizeTotal;
}
public Double getThirdAmountTotal() {
return thirdAmountTotal;
}
public void setThirdAmountTotal(Double thirdAmountTotal) {
this.thirdAmountTotal = thirdAmountTotal;
}
// public Double getThirdPretaxPrizeTotal() {
// return thirdPretaxPrizeTotal;
// }
// public void setThirdPretaxPrizeTotal(Double thirdPretaxPrizeTotal) {
// this.thirdPretaxPrizeTotal = thirdPretaxPrizeTotal;
// }
public Double getThirdPostaxPrizeTotal() {
return thirdPostaxPrizeTotal;
}
public void setThirdPostaxPrizeTotal(Double thirdPostaxPrizeTotal) {
this.thirdPostaxPrizeTotal = thirdPostaxPrizeTotal;
}
public Double getOwnThirdTicketCntDifferTotal() {
return ownThirdTicketCntDifferTotal;
}
public void setOwnThirdTicketCntDifferTotal(Double ownThirdTicketCntDifferTotal) {
this.ownThirdTicketCntDifferTotal = ownThirdTicketCntDifferTotal;
}
public Double getOwnThirdAmountDifferTotal() {
return ownThirdAmountDifferTotal;
}
public void setOwnThirdAmountDifferTotal(Double ownThirdAmountDifferTotal) {
this.ownThirdAmountDifferTotal = ownThirdAmountDifferTotal;
}
public Double getOwnThirdPostaxPrizeDifferTotal() {
return ownThirdPostaxPrizeDifferTotal;
}
public void setOwnThirdPostaxPrizeDifferTotal(
Double ownThirdPostaxPrizeDifferTotal) {
this.ownThirdPostaxPrizeDifferTotal = ownThirdPostaxPrizeDifferTotal;
}
}
分享到：
发表评论
文章已被作者锁定，不允许评论。
-
ES聚合查询大全
2020-11-18 16:16 231package com.xxx.es; import ... -
spring中使用logback日志组件替换log4j
2015-04-29 15:27 913logback比log4j的强大之处，请到logback的主页 ... -
java加密解密
2015-02-10 15:05 1669package com.neo.xnol.weixin.u ... -
eclipse常用配置
2015-01-05 11:23 1187Eclipse常用配置介绍 以 ... -
分布式事务-幂等
2014-12-30 14:04 645引用 http://www.360doc.com/conten ... -
实现基于nginx的tomcat负载均衡和集群配置
2014-12-26 16:22 1061今天看到"基于apache的tomcat负载均衡和集 ... -
<base target="_self"/>标签的巧妙用法
2014-10-10 15:34 697最近项目中一个小问题卡了我不少时间。我遇到的问题是：在项目的弹 ... -
分布式一致性-幂等
2014-09-28 14:53 1032关于分布式系统的数据 ... -
ModelResult-查询封装类
2014-09-25 09:14 3486package com.xxx.appmodel.doma ... -
LDAP工具类
2014-09-05 10:12 851package com.xxxpiao.common.ut ... -
通过JNDI访问LDAP目录服务
2014-09-04 17:46 3059package com.sina.test; imp ... -
java获取两个日期之间的年月（yyyy-MM）和年月日（yyyy-MM-dd）
2014-07-29 14:42 1736public List<String> pro ... -
maven-.m2
2014-07-28 14:48 758<settings> <!--< ... -
maven实战
2014-07-07 10:04 721<settings> <!--< ... -
验证敏感词汇
2014-07-04 10:01 917package com.xxxpiao.core.memb ... -
Jms实战
2014-07-02 09:27 668<?xml version="1.0&qu ... -
互联网数功能位，表扩展（flagBit,feature）
2014-06-26 17:39 767<select id="queryRegT ... -
线程运用-抽象类使用
2014-06-26 17:34 807package com.xxx.betcart.serve ... -
JDBC分批更新
2014-06-26 17:11 581@Override public boolean ba ... -
分批查询
2014-06-26 17:08 788package com.xxxpiao.common.ut ...
相关推荐
java导出Excel 时候 相同行合并（可合并多列）； 已测试通过；
java导出excel超过65536条记录出错 java导出excel超过65536条记录出错 java导出excel超过65536条记录出错 java导出excel超过65536条记录出错
java导出excel POI jar包 java代码地址http://blog.csdn.net/awenluck/article/details/51488537
java导出excel
该工具类实现java导出树形结构的方法，并未采用excel分组功能实现，而是根据树节点显示层级设置excel样式。针对easyUi，treeGrid开发的导出excel功能。方法简便实用、性强、通俗易懂。项目中亲测，no problem。
java导出excel例子，使用的是poi，可以分sheet导出，可以导出txt
java导出excel2007的实现，含2003格式。
资源描述：一个使用java做的导出数据，并且可以在excel表生成折线图的工具类，使用简单操作方便。
本资源实现了Excel的简单导出实例，同时也实现了导出Excel复合表头的简单实例，适合一些需要用到导出Excel技术的初学者。
java导出excel方式，含POI3.10jar包，都可以正常应用到项目中。
Java导出Excel文件(97--2003) 含jar包，注释全，可直接运行。
* 导出excel(利用反射机制) * String[] title = {"订单号","商品名称","商品价格","创建时间"}; * String[] field = {"orderNum","productName","productPrice","createTime"}; * ExportTools.export("sellJoin...
java导出Excel表格，支持标题合并居中，字体修改，带表头，全部是调好的项目搭起就可以用，该项目是在三层架构中实现
该资源是一个rar压缩包形式的源代码，主要演示了java如何导出数据到Excle并保存到本地电脑、以及在web中如何导出数据库中的数据到Excel并下载。
java导出数据到excel中的相关jar包。导出Excel的技术有两种Jakarta POI和Java Excel。
java导出CVS，csv只是一种文件的形式。。。就是按照逗号（英文逗号）分隔的文件 它的做成跟普通的文件做成是一样一样的，只需要创建一个文件（*.csv），把字符串按照一定的格式（AAA,BBB\nCCC,DDD注意必须是英文的...
Java导出Excel缩小填充，网上找了好多都没找到例子说实现不了，后面不经意间看到根据模板填充数据，解决了每个单元不同的样式问题。
java导出excel
struts2导出excel java 导出excel： JXL_excel: 可以直接在elipse下运行的例子 可以直接导出excel文件（包含所需的jar包） CSharpJExcel: 是JXL的官方下载的 包括详细的文档 和jar包
java工程，源代码，可直接运行，需自己改造成web下载方式。