<%@ page language="java" contentType="text/xml; charset=utf-8" pageEncoding="utf-8"%>
<jsp:directive.page import="java.util.List"/>
<jsp:directive.page import="com.netbusscheme.reportcenter.ReportCenterDao"/>
<jsp:directive.page import="com.netbusscheme.reportcenter.ReportCenterProcedureDao"/>
<jsp:directive.page import="com.netbusscheme.reportcenter.ReportBean"/>
<jsp:directive.page import="java.util.Date"/>
<jsp:directive.page import="java.text.SimpleDateFormat"/>
<jsp:directive.page import="java.text.DecimalFormat"/>
<?xml version="1.0" encoding="utf-8" ?>
<result>
<%
String companyonlycode = (String)session.getAttribute("companyonlycode");
String button = request.getParameter("button");
String show_x = request.getParameter("show_x");
String year = request.getParameter("year");
String[] comid = request.getParameterValues("comid");
String comflag = request.getParameter("comflag");
ReportCenterProcedureDao procedureDao = new ReportCenterProcedureDao();
ReportCenterDao rDao = new ReportCenterDao();
SimpleDateFormat sdf = new SimpleDateFormat("MM");
DecimalFormat dformat = new DecimalFormat("#.##");
List list = null;
if(button.equals("1")){
Date date = new Date();
int y = date.getYear();
int month = 12;
if(y>=Integer.parseInt(year)){
month=(date.getMonth()+1);
}
if(show_x.equals("1")){
list = rDao.getProductInCompanyByCom(companyonlycode,year,comid,comflag);
}else if(show_x.equals("3")){
String[] type = request.getParameterValues("type");
String typeflag = request.getParameter("typeflag");
list = rDao.getProductInCompanyByType(companyonlycode,year,comid,comflag,type,typeflag);
}else if(show_x.equals("4")){
String[] brand = request.getParameterValues("brand");
String brandflag = request.getParameter("brandflag");
list = rDao.getProductInCompanyByBrand(companyonlycode,year,comid,comflag,brand,brandflag);
}
for(int i=1;i<=month;i++){
out.println("<month>");
out.println("<mon>"+i+"</mon>");
for(int j=0;j<list.size();j++){
ReportBean rBean = (ReportBean)list.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj>");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
out.println("</month>");
}
}else if(button.equals("2")){
Date date = new Date();
int y = date.getYear();
int month = 12;
if(y>=Integer.parseInt(year)){
month=(date.getMonth()+1);
}
if(show_x.equals("1")){
list = rDao.getProductOutCompanyByCom(companyonlycode,year,comid,comflag);
}else if(show_x.equals("3")){
String[] type = request.getParameterValues("type");
String typeflag = request.getParameter("typeflag");
list = rDao.getProductOutCompanyByType(companyonlycode,year,comid,comflag,type,typeflag);
}else if(show_x.equals("4")){
String[] brand = request.getParameterValues("brand");
String brandflag = request.getParameter("brandflag");
list = rDao.getProductOutCompanyByBrand(companyonlycode,year,comid,comflag,brand,brandflag);
}
for(int i=1;i<=month;i++){
out.println("<month>");
out.println("<mon>"+i+"</mon>");
for(int j=0;j<list.size();j++){
ReportBean rBean = (ReportBean)list.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj>");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
out.println("</month>");
}
}else if(button.equals("3")){
if(show_x.equals("1")){
list = rDao.getMonthSaleMoneyByCom(companyonlycode,year,comid,comflag);
}else if(show_x.equals("2")){
String[] empid = request.getParameterValues("empid");
String empflag = request.getParameter("empflag");
list = rDao.getMonthSaleMoneyByEmp(companyonlycode,year,comid,comflag,empid,empflag);
}else if(show_x.equals("3")){
String[] type = request.getParameterValues("type");
String typeflag = request.getParameter("typeflag");
list = rDao.getMonthSaleMoneyByType(companyonlycode,year,comid,comflag,type,typeflag);
}else if(show_x.equals("4")){
String[] brand = request.getParameterValues("brand");
String brandflag = request.getParameter("brandflag");
list = rDao.getMonthSaleMoneyByBrand(companyonlycode,year,comid,comflag,brand,brandflag);
}
Date date = new Date();
int y = date.getYear();
int month = 12;
if(y>=Integer.parseInt(year)){
month=(date.getMonth()+1);
}
for(int i=1;i<=month;i++){
out.println("<month>");
out.println("<mon>"+i+"</mon>");
for(int j=0;j<list.size();j++){
ReportBean rBean = (ReportBean)list.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj>");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
if(show_x.equals("3") || show_x.equals("4")){
out.println("<parm4>"+(rBean.getNumber()+"件")+"</parm4>");
}else{
out.println("<parm4>"+(rBean.getNumber()+"笔帐单")+"</parm4>");
}
out.println("</obj>");
}
}
out.println("</month>");
}
}else if(button.equals("4")){
if(show_x.equals("1")){
list = rDao.getProductInStoreForYearByCom(companyonlycode,year,comid,comflag);
list = procedureDao.getProductInStoreForYearByCom(companyonlycode,year,comid,comflag);//用存储过程
}else if(show_x.equals("3")){
String[] type = request.getParameterValues("type");
String typeflag = request.getParameter("typeflag");
list = rDao.getProductInStoreForYearByType(companyonlycode,year,comid,comflag,type,typeflag);
}else if(show_x.equals("4")){
String[] brand = request.getParameterValues("brand");
String brandflag = request.getParameter("brandflag");
list = rDao.getProductInStoreForYearByBrand(companyonlycode,year,comid,comflag,brand,brandflag);
}
Date date = new Date();
int y = date.getYear();
int month = 12;
if(y>=Integer.parseInt(year)){
month=(date.getMonth()+1);
}
for(int i=1;i<=month;i++){
out.println("<month>");
out.println("<mon>"+i+"</mon>");
for(int j=0;j<list.size();j++){
ReportBean rBean = (ReportBean)list.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj>");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
out.println("</month>");
}
}else if(button.equals("5")){
List inList = null; //进
List storelist = null; //存
list = null; //销
if(show_x.equals("1")){
inList = rDao.getProductInCompanyByCom(companyonlycode,year,comid,comflag);
storelist = rDao.getProductInStoreForYearByCom(companyonlycode,year,comid,comflag);
list = rDao.getMonthSaleMoneyByCom(companyonlycode,year,comid,comflag);
}else if(show_x.equals("3")){
String[] type = request.getParameterValues("type");
String typeflag = request.getParameter("typeflag");
inList = rDao.getProductInCompanyByType(companyonlycode,year,comid,comflag,type,typeflag);
storelist = rDao.getProductInStoreForYearByType(companyonlycode,year,comid,comflag,type,typeflag);
list = rDao.getMonthSaleMoneyByType(companyonlycode,year,comid,comflag,type,typeflag);
}else if(show_x.equals("4")){
String[] brand = request.getParameterValues("brand");
String brandflag = request.getParameter("brandflag");
inList = rDao.getProductInCompanyByBrand(companyonlycode,year,comid,comflag,brand,brandflag);
storelist = rDao.getProductInStoreForYearByBrand(companyonlycode,year,comid,comflag,brand,brandflag);
list = rDao.getMonthSaleMoneyByBrand(companyonlycode,year,comid,comflag,brand,brandflag);
}
Date date = new Date();
int y = date.getYear();
int month = 12;
if(y>=Integer.parseInt(year)){
month=(date.getMonth()+1);
}
for(int i=1;i<=month;i++){
out.println("<month>");
out.println("<mon>"+i+"</mon>");
//进
for(int j=0;j<inList.size();j++){
ReportBean rBean = (ReportBean)inList.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj flag=\"1\">");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
//销
for(int j=0;j<list.size();j++){
ReportBean rBean = (ReportBean)list.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj flag=\"2\">");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
//存
for(int j=0;j<storelist.size();j++){
ReportBean rBean = (ReportBean)storelist.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj flag=\"3\">");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
out.println("</month>");
}
}
%>
</result>
================
<%@ page language="java" contentType="text/xml; charset=utf-8" pageEncoding="utf-8"%>
<jsp:directive.page import="java.util.List"/>
<jsp:directive.page import="com.netbusscheme.reportcenter.ReportCenterDao"/>
<jsp:directive.page import="com.netbusscheme.reportcenter.ReportCenterProcedureDao"/>
<jsp:directive.page import="com.netbusscheme.reportcenter.ReportBean"/>
<jsp:directive.page import="java.text.SimpleDateFormat"/>
<jsp:directive.page import="java.util.Calendar"/>
<jsp:directive.page import="java.text.DecimalFormat"/>
<?xml version="1.0" encoding="utf-8" ?>
<result>
<%
String companyonlycode = (String)session.getAttribute("companyonlycode");
String button = request.getParameter("button");
String show_x = request.getParameter("show_x");
String year = request.getParameter("year");
String month = request.getParameter("month");
String id = request.getParameter("id");
String[] comid = request.getParameterValues("comid");
String comflag = request.getParameter("comflag");
ReportCenterDao rDao = new ReportCenterDao();
ReportCenterProcedureDao procedureDao = new ReportCenterProcedureDao();
SimpleDateFormat sdf = new SimpleDateFormat("dd");
DecimalFormat dformat = new DecimalFormat("#.##");
List list = null;
Calendar calendar = Calendar.getInstance();
calendar.set(Calendar.YEAR,Integer.parseInt(year));
calendar.set(Calendar.MONTH,Integer.parseInt(month)-1);
int day = 30;
Calendar cal = Calendar.getInstance();
int y = cal.get(Calendar.YEAR);
int m = cal.get(Calendar.MONTH)+1;
if(y>Integer.parseInt(year) || (y==Integer.parseInt(year) && m>Integer.parseInt(month))){
day = calendar.getActualMaximum(Calendar.DAY_OF_MONTH);
}else{
day = cal.get(Calendar.DAY_OF_MONTH);
}
if(button.equals("1")){
if(show_x.equals("1")){
list = rDao.getDayProductInCompanyByCom(companyonlycode,year,month,comid,comflag);
}else if(show_x.equals("3")){
String[] type = request.getParameterValues("type");
String typeflag = request.getParameter("typeflag");
list = rDao.getDayProductInCompanyByType(companyonlycode,year,month,comid,comflag,type,typeflag);
}else if(show_x.equals("4")){
String[] brand = request.getParameterValues("brand");
String brandflag = request.getParameter("brandflag");
list = rDao.getDayProductInCompanyByBrand(companyonlycode,year,month,comid,comflag,brand,brandflag);
}
for(int i=1;i<=day;i++){
out.println("<days>");
out.println("<day>"+i+"</day>");
for(int j=0;j<list.size();j++){
ReportBean rBean = (ReportBean)list.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj>");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
out.println("</days>");
}
}else if(button.equals("2")){
if(show_x.equals("1")){
list = rDao.getDayProductOutCompanyByCom(companyonlycode,year,month,comid,comflag);
}else if(show_x.equals("3")){
String[] type = request.getParameterValues("type");
String typeflag = request.getParameter("typeflag");
list = rDao.getDayProductOutCompanyByType(companyonlycode,year,month,comid,comflag,type,typeflag);
}else if(show_x.equals("4")){
String[] brand = request.getParameterValues("brand");
String brandflag = request.getParameter("brandflag");
list = rDao.getDayProductOutCompanyByBrand(companyonlycode,year,month,comid,comflag,brand,brandflag);
}
for(int i=1;i<=day;i++){
out.println("<days>");
out.println("<day>"+i+"</day>");
for(int j=0;j<list.size();j++){
ReportBean rBean = (ReportBean)list.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj>");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
out.println("</days>");
}
}else if(button.equals("3")){
if(show_x.equals("1")){
list = rDao.getDaySaleMoneyByCom(companyonlycode,year,month,comid,comflag);
}else if(show_x.equals("2")){
String[] empid = request.getParameterValues("empid");
String empflag = request.getParameter("empflag");
list = rDao.getDaySaleMoneyByEmp(companyonlycode,year,month,comid,comflag,empid,empflag);
}else if(show_x.equals("3")){
String[] type = request.getParameterValues("type");
String typeflag = request.getParameter("typeflag");
list = rDao.getDaySaleMoneyByType(companyonlycode,year,month,comid,comflag,type,typeflag);
}else if(show_x.equals("4")){
String[] brand = request.getParameterValues("brand");
String brandflag = request.getParameter("brandflag");
list = rDao.getDaySaleMoneyByBrand(companyonlycode,year,month,comid,comflag,brand,brandflag);
}
for(int i=1;i<=day;i++){
out.println("<days>");
out.println("<day>"+i+"</day>");
for(int j=0;j<list.size();j++){
ReportBean rBean = (ReportBean)list.get(j);
//System.out.println(sdf.format(rBean.getDate()));
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj>");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
if(show_x.equals("3") || show_x.equals("4")){
out.println("<parm4>"+(rBean.getNumber()+"件")+"</parm4>");
}else{
out.println("<parm4>"+(rBean.getNumber()+"笔帐单")+"</parm4>");
}
out.println("</obj>");
}
}
out.println("</days>");
}
}else if(button.equals("4")){
if(show_x.equals("1")){
System.out.println("comflag="+comflag);
list = procedureDao.getProductInStoreForMonthByCom(companyonlycode,year,month,comid,comflag);//用存储过程
list = rDao.getProductInStoreForMonthByCom(companyonlycode,year,month,comid,comflag);//用JDBC
System.out.println("用Producre-flash_data_1.jsp");
}else if(show_x.equals("3")){
String[] type = request.getParameterValues("type");
String typeflag = request.getParameter("typeflag");
list = rDao.getProductInStoreForMonthByType(companyonlycode,year,month,comid,comflag,type,typeflag);
}else if(show_x.equals("4")){
String[] brand = request.getParameterValues("brand");
String brandflag = request.getParameter("brandflag");
list = rDao.getProductInStoreForMonthByBrand(companyonlycode,year,month,comid,comflag,brand,brandflag);
}
for(int i=1;i<=day;i++){
out.println("<days>");
out.println("<day>"+i+"</day>");
for(int j=0;j<list.size();j++){
ReportBean rBean = (ReportBean)list.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj>");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
out.println("</days>");
}
}else if(button.equals("5")){
String[] ids = {id};
List inlist = null; //进
List storelist = null; //存
list = null; //销
if(show_x.equals("1")){
if(comflag.equals("2")){
inlist = rDao.getDayProductInCompanyByCom(companyonlycode,year,month,ids,comflag);
storelist = rDao.getProductInStoreForMonthByCom(companyonlycode,year,month,ids,comflag);
list = rDao.getDaySaleMoneyByCom(companyonlycode,year,month,ids,comflag);
}else{
inlist = rDao.getDayProductInCompanyByCom(companyonlycode,year,month,comid,comflag);
storelist = rDao.getProductInStoreForMonthByCom(companyonlycode,year,month,comid,comflag);
list = rDao.getDaySaleMoneyByCom(companyonlycode,year,month,comid,comflag);
}
}else if(show_x.equals("3")){
String[] type = request.getParameterValues("type");
String typeflag = request.getParameter("typeflag");
if(comflag.equals("2")){
inlist = rDao.getDayProductInCompanyByType(companyonlycode,year,month,ids,comflag,type,typeflag);
storelist = rDao.getProductInStoreForMonthByType(companyonlycode,year,month,ids,comflag,type,typeflag);
list = rDao.getDaySaleMoneyByType(companyonlycode,year,month,ids,comflag,type,typeflag);
}else if(typeflag.equals("2")){
inlist = rDao.getDayProductInCompanyByType(companyonlycode,year,month,comid,comflag,ids,typeflag);
storelist = rDao.getProductInStoreForMonthByType(companyonlycode,year,month,comid,comflag,ids,typeflag);
list = rDao.getDaySaleMoneyByType(companyonlycode,year,month,comid,comflag,ids,typeflag);
}else{
inlist = rDao.getDayProductInCompanyByType(companyonlycode,year,month,comid,comflag,type,typeflag);
storelist = rDao.getProductInStoreForMonthByType(companyonlycode,year,month,comid,comflag,type,typeflag);
list = rDao.getDaySaleMoneyByType(companyonlycode,year,month,comid,comflag,type,typeflag);
}
}else if(show_x.equals("4")){
String[] brand = request.getParameterValues("brand");
String brandflag = request.getParameter("brandflag");
if(comflag.equals("2")){
inlist = rDao.getDayProductInCompanyByBrand(companyonlycode,year,month,ids,comflag,brand,brandflag);
storelist = rDao.getProductInStoreForMonthByBrand(companyonlycode,year,month,ids,comflag,brand,brandflag);
list = rDao.getDaySaleMoneyByBrand(companyonlycode,year,month,ids,comflag,brand,brandflag);
}else if(brandflag.equals("2")){
inlist = rDao.getDayProductInCompanyByBrand(companyonlycode,year,month,comid,comflag,ids,brandflag);
storelist = rDao.getProductInStoreForMonthByBrand(companyonlycode,year,month,comid,comflag,ids,brandflag);
list = rDao.getDaySaleMoneyByBrand(companyonlycode,year,month,comid,comflag,ids,brandflag);
}else{
inlist = rDao.getDayProductInCompanyByBrand(companyonlycode,year,month,comid,comflag,brand,brandflag);
storelist = rDao.getProductInStoreForMonthByBrand(companyonlycode,year,month,comid,comflag,brand,brandflag);
list = rDao.getDaySaleMoneyByBrand(companyonlycode,year,month,comid,comflag,brand,brandflag);
}
}
for(int i=1;i<=day;i++){
out.println("<days>");
out.println("<day>"+i+"</day>");
for(int j=0;j<list.size();j++){
ReportBean rBean = (ReportBean)list.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj flag=\"1\">");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
for(int j=0;j<inlist.size();j++){
ReportBean rBean = (ReportBean)inlist.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj flag=\"2\">");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
for(int j=0;j<storelist.size();j++){
ReportBean rBean = (ReportBean)storelist.get(j);
if(Integer.parseInt(sdf.format(rBean.getDate()))==i){
out.println("<obj flag=\"3\">");
out.println("<parm1>"+(rBean.getShowid())+"</parm1>");
out.println("<parm2>"+(rBean.getShowname())+"</parm2>");
out.println("<parm3>"+dformat.format(rBean.getMoney())+"</parm3>");
out.println("<parm4>"+(rBean.getNumber())+"</parm4>");
out.println("</obj>");
}
}
out.println("</days>");
}
}
%>
</result>