package com.yxq.action;

import java.io.UnsupportedEncodingException;

import java.util.List;

import com.yxq.actionSuper.InfoSuperAction;

import com.yxq.dao.OpDB;

import com.yxq.model.CreatePage;

import com.yxq.tools.DoString;

public class InfoAction extends InfoSuperAction {

public String ListShow(){

request.setAttribute("mainPage","/pages/show/listshow.jsp");

String infoType=request.getParameter("infoType");

Object[] params={infoType};

String sqlPayfor="SELECT * FROM tb_info WHERE (info_type = ?) AND (info_state='1') AND (info_payfor = '1') ORDER BY info_date DESC";

OpDB myOp=new OpDB();

/* 获取所有的付费信息 */

List onepayforlist=myOp.OpListShow(sqlPayfor, params); //获取所有付费信息

request.setAttribute("onepayforlist",onepayforlist);

/* 获取当前页要显示的免费信息 */

String sqlFreeAll="SELECT * FROM tb_info WHERE (info_type = ?) AND (info_state='1') AND (info_payfor = '0') ORDER BY info_date DESC";

String sqlFreeSub="";

int perR=3;

String strCurrentP=request.getParameter("showpage");

String gowhich="info_ListShow.action?infoType="+infoType;

CreatePage createPage=myOp.OpCreatePage(sqlFreeAll, params,perR,strCurrentP,gowhich); //调用OpDB类中的OpCreatePage()方法计算出总记录数、总页数，并且设置当前页码，这些信息都封装到了createPage对象中

int top1=createPage.getPerR();

int currentP=createPage.getCurrentP();

if(currentP==1){ //设置显示第1页信息的SQL语句

sqlFreeSub="SELECT TOP "+top1+" * FROM tb_info WHERE (info_type = ?) AND (info_state = '1') AND (info_payfor = '0') ORDER BY info_date DESC";

}

else{ //设置显示除第1页外，其他指定页码信息的SQl语句

int top2=(currentP-1)*top1;

sqlFreeSub="SELECT TOP "+top1+" * FROM tb_info i WHERE (info_type = ?) AND (info_state = '1') AND (info_payfor = '0') AND (info_date < (SELECT MIN(info_date) FROM (SELECT TOP "+top2+" (info_date) FROM tb_info WHERE (info_type = i.info_type) AND (info_state = '1') AND (info_payfor = '0') ORDER BY info_date DESC) AS mindate)) ORDER BY info_date DESC";

// sqlFreeSub="SELECT TOP "+top1+" * FROM tb_info i WHERE (info_type = ?) AND (info_state = '1') AND (info_payfor = '0') AND (info_date NOT IN (SELECT TOP "+top2+" info_date FROM tb_info WHERE (info_type = i.info_type) AND (info_state = '1') AND (info_payfor = '0') ORDER BY info_date DESC)) ORDER BY info_date DESC"; //另一种实现分页查询的SQL语句

}

List onefreelist=myOp.OpListShow(sqlFreeSub, params); //获取免费信息，信息数量由createPage.setPerR(int PerR)方法指定

request.setAttribute("onefreelist",onefreelist);

request.setAttribute("createpage", createPage);

return SUCCESS;

}

public String SingleShow(){

request.setAttribute("mainPage","/pages/show/singleshow.jsp");

String id=request.getParameter("id");

String sql="SELECT * FROM tb_info WHERE (id = ?)";

Object[] params={id};

OpDB myOp=new OpDB();

infoSingle=myOp.OpSingleShow(sql, params);

if(infoSingle==null){

request.setAttribute("mainPage","/pages/error.jsp");

addFieldError("SingleShowNoExist",getText("city.singleshow.no.exist"));

}

return SUCCESS;

}

public String Add(){

System.out.println("正在执行Add()方法…");

String addType=request.getParameter("addType");

if(addType==null||addType.equals("")){

request.setAttribute("mainPage","/pages/add/addInfo.jsp");

addType="linkTo";

}

if(addType.equals("add")){

request.setAttribute("mainPage","/pages/error.jsp");

OpDB myOp=new OpDB();

Integer type=Integer.valueOf(infoSingle.getInfoType());

String title=infoSingle.getInfoTitle();

String content=DoString.HTMLChange(infoSingle.getInfoContent());

String phone=infoSingle.getInfoPhone();

phone=phone.replaceAll(",","●");

String linkman=infoSingle.getInfoLinkman();

String email=infoSingle.getInfoEmail();

String date=DoString.dateTimeChange(new java.util.Date());

String state="0";

String payfor="0";

Object[] params={type,title,content,linkman,phone,email,date,state,payfor};

String sql="insert into tb_info values(?,?,?,?,?,?,?,?,?)";

int i=myOp.OpUpdate(sql,params);

if(i<=0)

addFieldError("addE",getText("city.info.add.E"));

else{

sql="select * from tb_info where info_date=?";

Object[] params1={date};

int infoNum=myOp.OpSingleShow(sql, params1).getId();

addFieldError("addS",getText("city.info.add.S")+infoNum);

}

}

return SUCCESS;

}

public String SearchShow() throws UnsupportedEncodingException{

request.setAttribute("mainPage","/pages/show/searchshow.jsp");

String subsql=searchInfo.getSubsql();

String sqlvalue=searchInfo.getSqlvalue();

String type=searchInfo.getType();

String showType=request.getParameter("showType");

if(showType==null)

showType="";

if(showType.equals("link")){ //对从超链接中获取的参数进行转码操作

try {

sqlvalue=new String(sqlvalue.getBytes("ISO-8859-1"),"gb2312");

} catch (UnsupportedEncodingException e) {

sqlvalue="";

e.printStackTrace();

}

searchInfo.setSqlvalue(sqlvalue);

}

session.put("subsql",subsql);

session.put("sqlvalue",sqlvalue);

session.put("type",type);

String param="";

String opname="";

if(type.equals("like")){

opname=" LIKE ";

param="%"+sqlvalue+"%";

}

else{

opname=" = ";

param=sqlvalue;

}

String sqlSearchAll="SELECT * FROM tb_info WHERE ("+subsql+opname+"?) ORDER BY info_date DESC";

String sqlSearchSub="";

Object[] params={param};

int perR=8;

String strCurrentP=request.getParameter("showpage");

String gowhich = "info_SearchShow.action?searchInfo.subsql="+subsql+"&searchInfo.sqlvalue="+sqlvalue+"&searchInfo.type="+type+"&showType=link";

OpDB myOp=new OpDB();

CreatePage createPage=myOp.OpCreatePage(sqlSearchAll, params,perR,strCurrentP,gowhich); //调用OpDB类中的OpCreatePage()方法计算出总记录数、总页数，并且设置当前页码，这些信息都封装到了createPage对象中

int top1=createPage.getPerR();

int currentP=createPage.getCurrentP();

if(currentP==1){ //显示第1页信息的SQL语句

sqlSearchSub="SELECT TOP "+top1+" * FROM tb_info WHERE ("+subsql+opname+"?) ORDER BY info_date DESC";

}

else{ //显示除第1页外，其他指定页码信息的SQl语句

int top2=(currentP-1)*top1;

sqlSearchSub="SELECT TOP "+top1+" * FROM tb_info WHERE ("+subsql+opname+"?) AND (info_date < (SELECT MIN(info_date) FROM (SELECT TOP "+top2+" info_date FROM tb_info WHERE "+subsql+opname+"'"+param+"' ORDER BY info_date DESC) AS mindate)) ORDER BY info_date DESC";

// sqlSearchSub="SELECT TOP "+top1+" * FROM tb_info WHERE ("+subsql+opname+"?) AND (info_date NOT IN (SELECT TOP "+top2+" info_date FROM tb_info WHERE "+subsql+opname+"'"+param+"' ORDER BY info_date DESC)) ORDER BY info_date DESC"; //另一种实现分页查询的SQL语句

}

List searchlist=myOp.OpListShow(sqlSearchSub, params);

request.setAttribute("searchlist",searchlist);

request.setAttribute("createpage", createPage);

return SUCCESS;

}

public void validateListShow(){

request.setAttribute("mainPage","/pages/error.jsp");

String infoType=request.getParameter("infoType");

if(infoType==null&&infoType.equals("")){

System.out.println("请选择要查询的信息类别！");

addFieldError("ListShowNoType",getText("city.info.listshow.no.infoType"));

}

else{

try{

Integer.parseInt(infoType);

}catch(NumberFormatException e){

System.out.println("信息类别不是数字格式！");

addFieldError("ListShowWrongType",getText("city.info.listshow.format.infoType"));

e.printStackTrace();

}

}

}

public void validateSingleShow(){

request.setAttribute("mainPage","/pages/error.jsp");

String id=request.getParameter("id");

if(id==null&&id.equals("")){

System.out.println("请选择要查看的信息！");

addFieldError("SingleShowNoID",getText("city.info.singleshow.no.id"));

}

else{

try{

Integer.parseInt(id);

}catch(NumberFormatException e){

System.out.println("信息ID值不是数字格式！");

addFieldError("ListShowWrongID",getText("city.info.listshow.format.infoID"));

e.printStackTrace();

}

}

}

public void validateAdd(){

System.out.println("正在执行validateAdd()方法…");

request.setAttribute("mainPage","/pages/add/addInfo.jsp");

String addType=request.getParameter("addType");

if(addType==null||addType.equals(""))

addType="linkTo";

if(addType.equals("add")){

int type=infoSingle.getInfoType();

String title=infoSingle.getInfoTitle();

String content=infoSingle.getInfoContent();

String phone=infoSingle.getInfoPhone();

String linkman=infoSingle.getInfoLinkman();

String email=infoSingle.getInfoEmail();

boolean mark=true;

if(type<=0){

mark=false;

addFieldError("typeError",getText("city.info.no.infoType"));

}

if(title==null||title.equals("")){

mark=false;

addFieldError("titleError",getText("city.info.no.infoTitle"));

}

if(content==null||content.equals("")){

mark=false;

addFieldError("contentError",getText("city.info.no.infoContent"));

}

if(phone==null||phone.equals("")){

mark=false;

addFieldError("phoneError",getText("city.info.no.infoPhone"));

}

if(linkman==null||linkman.equals("")){

mark=false;

addFieldError("linkmanError",getText("city.info.no.infoLinkman"));

}

if(email==null||email.equals("")){

mark=false;

addFieldError("emailError",getText("city.info.no.infoEmail"));

}

if(mark){

String phoneRegex="(\\d{3}-)\\d{8}|(\\d{4}-)(\\d{7}|\\d{8})|\\d{11}";

if(phone.indexOf(",")<0){

if(!infoSingle.getInfoPhone().matches(phoneRegex)){

addFieldError("phoneError",getText("city.info.format.infoPhone"));

}

}

else{

String[] phones=phone.split(",");

for(int i=0;i<phones.length;i++){

if(!phones[i].matches(phoneRegex)){

addFieldError("phoneError",getText("city.info.format.infoPhone"));

break;

}

}

}

String emailRegex="\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*";

if(!infoSingle.getInfoEmail().matches(emailRegex)){

addFieldError("emailError",getText("city.info.format.infoEmail"));

}

}

}

}

public void validateSearchShow() {

request.setAttribute("mainPage","/pages/error.jsp");

String subsql=searchInfo.getSubsql();

String sqlvalue=searchInfo.getSqlvalue();

String type=searchInfo.getType();

if(subsql==null||subsql.equals("")){

addFieldError("SearchNoC",getText("city.info.search.no.condition"));

}

if(sqlvalue==null||sqlvalue.equals("")){

addFieldError("SearchNoV",getText("city.info.search.no.value"));

}

if(type==null||type.equals("")){

addFieldError("SearchNoT",getText("city.info.search.no.type"));

}

}

}