package cn.ksource.web.facade.deliverMent;
|
|
import java.util.Map;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import cn.ksource.core.dao.BaseDao;
|
import cn.ksource.core.page.PageInfo;
|
import cn.ksource.core.util.ConvertUtil;
|
import cn.ksource.core.util.DateUtil;
|
import cn.ksource.core.util.StringUtil;
|
|
/**
|
* 交付管理接口实现
|
* @author gaofazhan
|
*2018-03-20
|
*/
|
@Service
|
public class DeliverMentFacadeImpl implements DeliverMentFacade{
|
@Autowired
|
private BaseDao baseDao;
|
@SuppressWarnings({ "rawtypes", "unchecked" })
|
@Override
|
public PageInfo getDeliverMentData(Map param, PageInfo pageInfo) {
|
String sql="select a.*,b.IS_STATE from sc_deliver a left join deliver_report b on a.id=b.plan_id where a.state=1 ";
|
String plan_name=ConvertUtil.obj2StrBlank(param.get("plan_name"));
|
if(StringUtil.notEmpty(plan_name)){
|
param.put("plan_name", "%"+plan_name+"%");
|
sql+=" AND a.PLAN_NAME like :plan_name ";
|
}
|
String cusId=ConvertUtil.obj2StrBlank(param.get("cusId"));
|
if(StringUtil.notEmpty(cusId)){
|
sql+=" AND a.CUSTOMER_ID =:cusId ";
|
}
|
String subCusId=ConvertUtil.obj2StrBlank(param.get("subCusId"));
|
if(StringUtil.notEmpty(subCusId)){
|
sql+=" AND a.SUB_CUSTOMER_ID =:subCusId ";
|
}
|
String jfstate=ConvertUtil.obj2StrBlank(param.get("jfstate"));
|
if(StringUtil.notEmpty(jfstate)){
|
sql+=" AND a.JFSTATE=:jfstate ";
|
}
|
String plan_year=ConvertUtil.obj2StrBlank(param.get("plan_year"));
|
if(StringUtil.notEmpty(plan_year)){
|
sql+=" AND a.PLAN_YEAR=:plan_year ";
|
}
|
return baseDao.queryforSplitPageInfo(pageInfo, sql, param);
|
}
|
|
@SuppressWarnings({ "rawtypes", "unchecked" })
|
@Override
|
public int getDeliverMentCount(Map param) {
|
String sql="select count(a.id) from sc_deliver a where a.state=1 ";
|
String plan_name=ConvertUtil.obj2StrBlank(param.get("plan_name"));
|
if(StringUtil.notEmpty(plan_name)){
|
param.put("plan_name", "%"+plan_name+"%");
|
sql+=" AND a.PLAN_NAME like :plan_name ";
|
}
|
String cusId=ConvertUtil.obj2StrBlank(param.get("cusId"));
|
if(StringUtil.notEmpty(cusId)){
|
sql+=" AND a.CUSTOMER_ID =:cusId ";
|
}
|
String subCusId=ConvertUtil.obj2StrBlank(param.get("subCusId"));
|
if(StringUtil.notEmpty(subCusId)){
|
sql+=" AND a.SUB_CUSTOMER_ID =:subCusId ";
|
}
|
String jfstate=ConvertUtil.obj2StrBlank(param.get("jfstate"));
|
if(StringUtil.notEmpty(jfstate)){
|
sql+=" AND a.JFSTATE=:jfstate ";
|
}
|
String plan_year=ConvertUtil.obj2StrBlank(param.get("plan_year"));
|
if(StringUtil.notEmpty(plan_year)){
|
sql+=" AND a.PLAN_YEAR=:plan_year ";
|
}
|
return baseDao.queryForInteger(sql, param);
|
}
|
|
@SuppressWarnings("rawtypes")
|
@Override
|
public Map getDeliverMent(Map param) {
|
String sql="select * from sc_deliver where state=1 and id=:id ";
|
return baseDao.queryForMap(sql, param);
|
}
|
@SuppressWarnings("rawtypes")
|
@Override
|
public Map getMent(Map param) {
|
String sql="select * from deliver_report where plan_id=:id ";
|
return baseDao.queryForMap(sql, param);
|
}
|
|
@SuppressWarnings({ "unchecked", "rawtypes" })
|
@Override
|
public void saveDeliverMent(Map param) {
|
param.put("id", StringUtil.getUUID());
|
param.put("create_time", DateUtil.getCurrentDate14());
|
String sql="insert into sc_deliver(ID,PLAN_YEAR,CUSTOMER_ID,CUSTOMER_NAME,SUB_CUSTOMER_ID,SUB_CUSTOMER_NAME," +
|
"PLAN_NAME,PLAN_ZZ,SY_RANGE,PLAN_ZTGS,PLAN_GLJH,PLAN_RYJH,PLAN_JSGL,PLAN_ZYGL,PLAN_GCGL,STATE," +
|
"CREATE_TIME,USER_ID,USER_NAME,JFSTATE) values(:id,:plan_year,:customer_id,:customer_name," +
|
":sub_customer_id,:sub_customer_name,:plan_name,:plan_zz,:sy_range,:plan_ztgs,:plan_gljh," +
|
":plan_ryjh,:plan_jsgl,:plan_zygl,:plan_gcgl,1,:create_time,:userId,:userName,1)";
|
baseDao.execute(sql, param);
|
}
|
|
@SuppressWarnings({ "rawtypes", "unchecked" })
|
@Override
|
public void updateDeliverMent(Map param) {
|
param.put("plan_year", ConvertUtil.obj2StrBlank(param.get("plan_year")).substring(0, 4));
|
String sql="update sc_deliver set PLAN_YEAR=:plan_year,CUSTOMER_ID=:customer_id," +
|
"CUSTOMER_NAME=:customer_name,SUB_CUSTOMER_ID=:sub_customer_id,SUB_CUSTOMER_NAME=:sub_customer_name," +
|
"PLAN_NAME=:plan_name,PLAN_ZZ=:plan_zz,SY_RANGE=:sy_range,PLAN_ZTGS=:plan_ztgs,PLAN_GLJH=:plan_gljh," +
|
"PLAN_RYJH=:plan_ryjh,PLAN_JSGL=:plan_jsgl,PLAN_ZYGL=:plan_zygl,PLAN_GCGL=:plan_gcgl where id=:id";
|
baseDao.execute(sql, param);
|
}
|
|
@SuppressWarnings({ "unchecked", "rawtypes" })
|
@Override
|
public void saveDeliverReport(Map param) {
|
param.put("create_time", DateUtil.getCurrentDate14());
|
param.put("id", StringUtil.getUUID());
|
String sql="insert into deliver_report(ID,PLAN_ID,START_TIME,END_TIME,CUSTOMER_TEXT,PER_TEXT,AC_TEXT," +
|
"FILE_TEXT,EPILOGUE_TEXT,CUSTOMER_SQ,PROTECT_AC,CUSTOMER_CHARGE,PROTECT_CHARGE,CUSTOMER_DATE," +
|
"PROTECT_DATE,CREATE_TIME,USER_ID,USER_NAME,IS_STATE) values(:id,:plan_id,:start_time,:end_time,:customer_text,:per_text,:ac_text," +
|
":file_text,:epilogue_text,:customer_sq,:protect_ac,:customer_charge,:protect_charge," +
|
":customer_date,:protect_date,:create_time,:userId,:userName,:is_state)";
|
baseDao.execute(sql, param);
|
String sqla="update sc_deliver set jfstate=2 where id=:plan_id";
|
baseDao.execute(sqla, param);
|
}
|
@SuppressWarnings({"rawtypes" })
|
@Override
|
public void updateDeliverReport(Map param) {
|
String sql="update deliver_report set START_TIME=:start_time,END_TIME=:end_time,CUSTOMER_TEXT=:customer_text,PER_TEXT=:per_text," +
|
"AC_TEXT=:ac_text,FILE_TEXT=:file_text,EPILOGUE_TEXT=:epilogue_text,CUSTOMER_SQ=:customer_sq," +
|
"PROTECT_AC=:protect_ac,CUSTOMER_CHARGE=:customer_charge,PROTECT_CHARGE=:protect_charge," +
|
"CUSTOMER_DATE=:customer_date,PROTECT_DATE=:protect_date,IS_STATE=:is_state where ID=:id";
|
baseDao.execute(sql, param);
|
}
|
@SuppressWarnings("rawtypes")
|
@Override
|
public void delEmergencyPlan(Map param) {
|
String sql="update sc_deliver set STATE=2 where id=:id ";
|
baseDao.execute(sql, param);
|
}
|
|
@SuppressWarnings("rawtypes")
|
@Override
|
public Map getDeliverReport(Map param) {
|
String sql="select *,a.USER_NAME userName,a.CREATE_TIME createTime from sc_deliver a left join deliver_report b on a.id=b.plan_id" +
|
" where a.id=:id";
|
return baseDao.queryForMap(sql, param);
|
}
|
|
}
|
