package com.yz.HX.action;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.io.PrintWriter;
import java.net.HttpURLConnection;
import java.net.URL;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import javax.sql.DataSource;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import org.apache.commons.beanutils.BeanUtils;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.Result;
import org.codehaus.jackson.map.ObjectMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Controller;
import com.opensymphony.xwork2.ModelDriven;
import com.yz.BA.domain.BAT002;
import com.yz.BA.domain.BAT006;
import com.yz.BA.domain.BAT009;
import com.yz.BA.service.BAT002Service;
import com.yz.BA.service.BAT006Service;
import com.yz.BA.service.BAT009Service;
import com.yz.HX.domain.HXKH001;
import com.yz.HX.service.HXKH001Service;
import com.yz.HX.util.Pagefy;
import com.yz.QL.domain.bat124_1;
import com.yz.QL.service.bat124_1Service;
import com.yz.YQ.service.CXCS004Service;
import com.yz.YQ.service.YQKH01Service;
import com.yz.YQ.domain.CXCS004;
import com.yz.YQ.domain.YQKH01;
import com.yz.ZA.action.base.JsonBaseAction;
import com.yz.ZA.util.DateUtil;
import com.yz.ZA.util.HttpUtil;
import com.yz.ZA.util.Page;
import com.yz.ZA.util.WebLogs;
import com.yz.servlet.wsdomain.Result_servlet;
@Controller
@Scope("prototype")
@Namespace("/")
public class HXKH01Action extends JsonBaseAction implements ModelDriven<Object>{
private static final long serialVersionUID = 1L;
@Autowired
private HXKH001Service HXKH001Service;
@Autowired
private BAT002Service BAT002Service;
@Autowired
private BAT009Service BAT009Service;
@Autowired
private BAT006Service BAT006Service;
@Autowired
private YQKH01Service YQKH01Service;
@Autowired
private CXCS004Service CXCS004Service;
@Autowired
private bat124_1Service bat124_1Service;
@Resource(name="dataSource")
private DataSource datasource;
private YQKH01 YQKH01 = new YQKH01();
@Override
public Object getModel() {
return YQKH01;
}
public String currentPage;
/**
* 跳转到 列表页面
* @return
* @throws Exception
*/
@Action(value = "hxkh01", results = @Result(name = "success",location = "/content/HX/hxkh001_from.jsp"))
public String hxkh01() throws Exception {
WebLogs.getLogger().info("hxkh01 is start");
return SUCCESS;
}
/**
* 跳转到 列表页面
* @return
* @throws Exception
*/
@Action(value = "hxkh001_cszy", results = @Result(name = "success",location = "/content/HX/hxkh001_csfrom.jsp"))
public String hxkh001_cszy() throws Exception {
WebLogs.getLogger().info("hxkh001_cszy is start");
return SUCCESS;
}
/**
* json 获取数据 grid数据
* @return
* @throws Exception
*/
@Action("hxkh01_list")
public String wdcclpkbg_list() throws Exception {
WebLogs.getLogger().info("hxkh01_list is start");
/**
* 存放map对像的结果集
*/
List resultlist = new ArrayList();
Page pageoper = HXKH001Service.findPageListBySQLForMap("select * from hxkh001 where 1=1 ", page);
resultlist = pageoper.getResult();//有可能这个list 还要做细化处理 所以放在父类的外面
return super.getJqGridData(resultlist, pageoper);
}
/**
* json 获取数据 grid数据
* @return
* @throws Exception
*/
@Action("hxkh01_fksj")
public String hxkh01_fksj() throws Exception {
WebLogs.getLogger().info("hxkh01_fksj is start");
/**
* 存放map对像的结果集
*/
List resultlist = new ArrayList();
Page pageoper = HXKH001Service.findPageListBySQLForMap2("select * from bbt003 where 1=1 and bbskzt=3 ", page);
resultlist = pageoper.getResult();//有可能这个list 还要做细化处理 所以放在父类的外面
return super.getJqGridData(resultlist, pageoper);
}
//详情
@Action(value = "hxkh_xq", results = @Result(name = "success", location = "/content/HX/hxkh001_view.jsp"))
public String hxkh_xq() throws Exception {
JdbcTemplate jt=new JdbcTemplate(datasource);
String objectid = HttpUtil.getRequest().getParameter("basqbh");
//FP和渠道
String szfpqd = HttpUtil.getUser().getXTJSDM(); //获取user下面的session里面的数据
HttpUtil.getRequest().setAttribute("szfpqd", szfpqd);
//金信报告链接
String jxsql="select * from cxcs004@ncdev1 where reqno="+objectid;
List<CXCS004> cxcs004 = CXCS004Service.findBySql(jxsql, CXCS004.class);
HttpUtil.getRequest().setAttribute("jxbgur", cxcs004.size()>0?cxcs004.get(0).getReportUrl()==null?"":cxcs004.get(0).getReportUrl():"");
//鲁若领友GPS切换
String lr = " select * from bat124_1@ncdev1 where basqbh = '"+objectid+"'";
List<bat124_1> qlly=bat124_1Service.findBySql(lr, bat124_1.class);
if(qlly.size()>0){
if(qlly.get(0).getFKZT().equals("1")){
HttpUtil.getRequest().setAttribute("zt","待激活");
}else if(qlly.get(0).getFKZT().equals("2")){
HttpUtil.getRequest().setAttribute("zt","激活成功");
}
}
YQKH01 PREUPYQKH01 = null;
List listyqkh = YQKH01Service.findBySql("select b.BACXZC,a.*,a.BASQBH as ID ,a.YQZTMC,b.BASQZT,b.gpscs,b.BASQZC,BACJHM,case when aac.bafylx = '无线' then c.GPSIM2 when aac.bafylx = '有线' then c.BAGSIM end as BAGSIM,c.BAFDJH,b06.badtcg,bt111.BAGDBH,ba3.BASQZW,b.FXRZZE, NVL(a.SCORE, 0) SCORE, NVL(a.SUGGESTIONS ,'暂无') SUGGESTIONS,(case when c.bagdbh is not null then '' when c.basqzt < 1002100 then to_char(to_date(to_char(sysdate, 'yyyymmdd'), 'yyyymmdd') - to_date(c.basxrq,'yyyymmdd') - 60) else '' end) gdyqts from YQKH01 a "
+ "left join BAT009 b on a.BASQBH=b.BASQBH left join BAT011 c on a.BASQBH=c.BASQBH left join BAT006 aac on a.basqbh=aac.basqbh "
// +" left join (select (case when bbjszt = '3' then '扣款成功'" +
// " when bbjszt = '4' then '扣款失败' when bbjszt = '0' then '待扣款' when bbjszt = '1' then '扣款中'" +
// " else '' end) BBJSZT,baddbh from (SELECT row_number() over(partition by BADDBH order by xtczrq || xtczsj desc) as rn,BBJSZT,bb6.baddbh from BBT006 bb6)where rn=1) bb61 on bb61.baddbh = a.baddbh " +
+"left join (select count(1) badtcg,baddbh from bbt006 where bbscrq="+DateUtil.getCurrentDate()+" and bbjszt=3 group by baddbh) b06 on b06.baddbh=c.baddbh "+
" left join bat003 ba3 on a.basqbh=ba3.basqbh "+
" left join (select (case when BAGDBH is not null then '是' "
+" else '否' end) BAGDBH,baddbh from (SELECT row_number() over(partition by BADDBH order by xtczrq || xtczsj desc) as rn,bt11.baddbh,BAGDBH from bat011 bt11)where rn=1) bt111 on bt111.baddbh=a.baddbh "
+" left join bat006 d on a.BASQBH=d.BASQBH where a.BASQBH="+objectid, YQKH01.class);
if(listyqkh.size()>0){
PREUPYQKH01 = (YQKH01)listyqkh.get(0);
}else{
PREUPYQKH01 = new YQKH01();
//查询客户基本信息
String sql ="SELECT b.gpscs,b.BACXZC,a.basqbh as ID,BADJRQ,a.BAGSIM,BACLPZ,a.basqzc,a.bacphm,e.basqlx,e.basqxm,a.bacjhm,a.baddbh,e.BAZJLX,e.BAZJHM,e.BAKHXB,d.BAKHDM,d.BAKHMC,a.BADYRQ,a.BASXRQ,a.BADJRQ,a.BASJHK,a.BAKHZJ,a.BACPHM,f.BACLPP,f.BACLXH,a.BACLPZ,a.BACLYS,b.BARZQX,f.BACLLX FROM bat011 a LEFT JOIN BAT009 b ON b.basqbh=a.basqbh LEFT JOIN ZAM010 c ON c.xtjgid=b.xsdmid LEFT JOIN bat006 f ON f.basqbh=a.basqbh LEFT JOIN bam006 d ON d.bakhdm=c.xtjgdm LEFT
