jin8000608172
- 浏览: 140984 次
- 性别:
- 来自: 深圳
-
最新评论
-
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 271package com.xxx.es; import ... -
spring中使用logback日志组件替换log4j
2015-04-29 15:27 949logback比log4j的强大之处，请到logback的主页 ... -
java加密解密
2015-02-10 15:05 1734package com.neo.xnol.weixin.u ... -
eclipse常用配置
2015-01-05 11:23 1244Eclipse常用配置介绍 以 ... -
分布式事务-幂等
2014-12-30 14:04 689引用 http://www.360doc.com/conten ... -
实现基于nginx的tomcat负载均衡和集群配置
2014-12-26 16:22 1121今天看到"基于apache的tomcat负载均衡和集 ... -
<base target="_self"/>标签的巧妙用法
2014-10-10 15:34 749最近项目中一个小问题卡了我不少时间。我遇到的问题是：在项目的弹 ... -
分布式一致性-幂等
2014-09-28 14:53 1119关于分布式系统的数据 ... -
ModelResult-查询封装类
2014-09-25 09:14 3572package com.xxx.appmodel.doma ... -
LDAP工具类
2014-09-05 10:12 899package com.xxxpiao.common.ut ... -
通过JNDI访问LDAP目录服务
2014-09-04 17:46 3120package com.sina.test; imp ... -
java获取两个日期之间的年月（yyyy-MM）和年月日（yyyy-MM-dd）
2014-07-29 14:42 1862public List<String> pro ... -
maven-.m2
2014-07-28 14:48 803<settings> <!--< ... -
maven实战
2014-07-07 10:04 757<settings> <!--< ... -
验证敏感词汇
2014-07-04 10:01 969package com.xxxpiao.core.memb ... -
Jms实战
2014-07-02 09:27 701<?xml version="1.0&qu ... -
互联网数功能位，表扩展（flagBit,feature）
2014-06-26 17:39 819<select id="queryRegT ... -
线程运用-抽象类使用
2014-06-26 17:34 874package com.xxx.betcart.serve ... -
JDBC分批更新
2014-06-26 17:11 630@Override public boolean ba ... -
分批查询
2014-06-26 17:08 845package com.xxxpiao.common.ut ...
相关推荐
Java导出Excel是Java开发中常见的需求，尤其是在数据处理和报表生成方面。Apache POI库是Java领域中广泛使用的工具，它允许开发者读写Microsoft Office格式的文件，包括Excel（.xlsx和.xls）。本篇文章将深入讲解...
java导出excel超过65536条记录出错 java导出excel超过65536条记录出错 java导出excel超过65536条记录出错 java导出excel超过65536条记录出错
本资源提供的"java导出excel复合表头简单实例"是针对Java开发者的一个实用教程，特别是对于那些刚开始接触Java Excel导出功能的新手。这个实例将帮助你理解如何在Excel中创建并设置复杂的表头结构，使得数据的呈现...
本示例涉及的主题是“java导出excel复杂表头”，这意味着我们要处理的不是简单的单级表头，而是包含多级或者多层次结构的表头。在描述中提到这是一个可以直接运行的Java工程，但需要进一步改造为Web下载服务。 首先...
Java导出Excel是Java开发中常见的需求，尤其在数据分析、报表生成或数据交换场景中。本示例资源提供了一个RAR压缩包，包含了实现这一功能的源代码，主要讲解了两个核心部分：一是如何将数据写入Excel文件并保存在...
java导出Excel 时候 相同行合并（可合并多列）； 已测试通过；
在Java编程中，导出Excel是一项常见的任务，特别是在数据分析、报表生成或数据交换等领域。而带图片的Excel导出则增加了复杂性，因为涉及到二进制数据的处理和Excel特定格式的支持。以下是一些关于如何在Java中实现...
Java导出Excel是Java开发中常见的一项任务，特别是在数据分析、报表生成或数据交换等领域。Apache POI是一个流行的开源库，允许Java程序读取和写入Microsoft Office格式的文件，包括Excel（.xls和.xlsx）。在本场景...
压缩包中的文件"java导出excel"很可能包含了使用这两种库的示例代码或教程资源，你可以通过解压并学习这些文件来深入理解如何在Java中实现数据到Excel的导出。记得在实际使用时，要根据项目需求选择合适的技术，并...
该工具类实现java导出树形结构的方法，并未采用excel分组功能实现，而是根据树节点显示层级设置excel样式。针对easyUi，treeGrid开发的导出excel功能。方法简便实用、性强、通俗易懂。项目中亲测，no problem。
"Java 导出Excel.zip"这个压缩包文件提供了一个Java实现的解决方案，允许开发者以全泛型的方式方便地导出数据到Excel文件，而且支持动态创建不同数量的sheet页面，增强了灵活性。 1. **Java与Excel交互**：Java中...
Java导出Excel在Web项目中的应用是一个常见的需求，特别是在企业级开发中，为了方便数据的存储、分析和传输，往往需要将数据库中的数据导出为Excel格式。下面将详细介绍这个主题，包括相关技术和实现步骤。 1. **...
java导出excel例子，使用的是poi，可以分sheet导出，可以导出txt
在压缩包中的"java导出Excel"文件可能是项目的源代码，包含了实现上述功能的具体Java类和方法。分析这些源码可以帮助我们更深入地理解如何在实际项目中应用这些知识点。 总结来说，这个项目展示了如何在Java环境中...
资源描述：一个使用java做的导出数据，并且可以在excel表生成折线图的工具类，使用简单操作方便。
### Java导出Excel知识点 #### 一、导出Excel的核心技术背景 在现代软件开发过程中，数据导出是一项常见的需求，尤其是将数据从数据库或内存中的数据结构导出到Excel文件，这为用户提供了便捷的数据查看与分析方式...
总之，Java导出Excel涉及到的主要知识点包括：Apache POI库的使用，Workbook、Sheet、Row和Cell对象的创建和操作，以及数据写入和文件输出。希望这个示例能帮助你理解并开始在自己的项目中实现Excel导出功能。
以下是一些关于“java导出excel”的核心知识点，以及如何实现这一功能的详细解释。 1. **Apache POI库**： Apache POI是一个流行的开源库，专门用于读写Microsoft Office格式的文件，包括Excel。使用POI，开发者...
* 导出excel(利用反射机制) * String[] title = {"订单号","商品名称","商品价格","创建时间"}; * String[] field = {"orderNum","productName","productPrice","createTime"}; * ExportTools.export("sellJoin...
在Java编程中，导出...总之，Java导出Excel涉及到的内容广泛，从选择合适的库到处理各种复杂需求，都需要开发者具备扎实的编程基础和对Excel文件格式的理解。通过不断实践和学习，你可以轻松应对各种Excel处理任务。