package com.yeshi.buwan.service.imp;
|
|
import java.io.Serializable;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import javax.annotation.Resource;
|
|
import org.hibernate.HibernateException;
|
import org.hibernate.Session;
|
import org.springframework.cache.annotation.Cacheable;
|
import org.springframework.orm.hibernate4.HibernateCallback;
|
import org.springframework.stereotype.Service;
|
|
import com.yeshi.buwan.dao.HomeAdDao;
|
import com.yeshi.buwan.dao.SuperHomeAdDao;
|
import com.yeshi.buwan.domain.system.DetailSystem;
|
import com.yeshi.buwan.domain.HomeAd;
|
import com.yeshi.buwan.domain.SuperHomeAd;
|
import com.yeshi.buwan.domain.system.SystemInfo;
|
import com.yeshi.buwan.domain.VideoInfo;
|
import com.yeshi.buwan.domain.web.DetailSystemSelect;
|
import com.yeshi.buwan.domain.web.HomeAdAdmin;
|
import com.yeshi.buwan.util.Constant;
|
import org.yeshi.utils.StringUtil;
|
|
@Service
|
public class HomeAdService {
|
@Resource
|
private HomeAdDao homeAdDao;
|
@Resource
|
private SuperHomeAdDao superHomeAdDao;
|
|
public List<HomeAd> getHomeAdList(SystemInfo system) {
|
List<HomeAd> list = homeAdDao
|
.list("from HomeAd h where h.system.id=" + system.getId() + " order by h.orderby desc");
|
return list;
|
}
|
|
@Cacheable(value = "homeCache", key = "'getHomeAdList'+'-'+#detailSystem.id+'-'+#dataKey")
|
public List<HomeAd> getHomeAdList(DetailSystem detailSystem,String dataKey) {
|
List<HomeAd> list = homeAdDao.list("select h.homeAd from SuperHomeAd h where h.detailSystem.id=? and h.homeAd.specialDataKey=? order by h.homeAd.orderby desc",detailSystem.getId(),dataKey);
|
return list;
|
}
|
|
public static List<HomeAd> getIOSTestHomeAdList() {
|
List<HomeAd> list = new ArrayList<>();
|
HomeAd ad = new HomeAd();
|
ad.setPicture("http://img.zcool.cn/community/01a5a7562499216ac7254878995802.jpg");
|
VideoInfo info = new VideoInfo();
|
info.setId("161850");
|
info.setName("【摔杯为号】赵家班父子摔杯演闹剧");
|
info.setPicture("http://img2.funshion.com/pictures/poseidon01/418/985/4189850_v_still.jpg");
|
info.setThirdType("0");
|
info.setShare("0");
|
ad.setVideo(info);
|
list.add(ad);
|
|
ad = new HomeAd();
|
ad.setPicture("http://img.zcool.cn/community/01ac60563acca86ac7259e0fe92cae.jpg");
|
info = new VideoInfo();
|
info.setId("161334");
|
info.setName("【冯巩】冯巩,牛莉《夫妻日记》");
|
info.setPicture("http://img.zcool.cn/community/01ac60563acca86ac7259e0fe92cae.jpg");
|
info.setThirdType("0");
|
info.setShare("0");
|
ad.setVideo(info);
|
list.add(ad);
|
|
ad = new HomeAd();
|
ad.setPicture("http://img.zcool.cn/community/01ae2b563accb032f87512f63f63ad.jpg");
|
info = new VideoInfo();
|
info.setId("163707");
|
info.setName("【郭德纲于谦】《谦哥带儿子见世面》");
|
info.setPicture("http://img.zcool.cn/community/01cdfb563acca06ac7259e0fb69676.jpg");
|
info.setThirdType("0");
|
info.setShare("0");
|
ad.setVideo(info);
|
list.add(ad);
|
|
ad = new HomeAd();
|
ad.setPicture("http://img.zcool.cn/community/01ae2b563accb032f87512f63f63ad.jpg");
|
info = new VideoInfo();
|
info.setId("161339");
|
info.setName("【欢乐喜剧人】开心麻花《感染者》");
|
info.setPicture("http://img2.funshion.com/pictures/poseidon01/418/985/4189850_v_still.jpg");
|
info.setThirdType("0");
|
info.setShare("0");
|
ad.setVideo(info);
|
list.add(ad);
|
|
return list;
|
}
|
|
public List<HomeAd> getHomeAdList() {
|
|
List<HomeAd> list = homeAdDao.list("from HomeAd ha order by ha.orderby desc");
|
return list;
|
}
|
|
@SuppressWarnings("unchecked")
|
public void deleteHomeAd(final String id) {
|
homeAdDao.excute(new HibernateCallback() {
|
public Object doInHibernate(Session session) throws HibernateException {
|
try {
|
List<SuperHomeAd> list = session.createQuery("from SuperHomeAd sh where sh.homeAd.id=?")
|
.setParameter(0, id).list();
|
session.getTransaction().begin();
|
for (SuperHomeAd shd : list)
|
session.delete(shd);
|
session.createQuery("delete from HomeAd ha where ha.id=?").setParameter(0, id).executeUpdate();
|
session.flush();
|
session.getTransaction().commit();
|
} catch (Exception e) {
|
e.printStackTrace();
|
session.getTransaction().rollback();
|
}
|
return null;
|
}
|
});
|
|
}
|
|
public Serializable addHomeAd(HomeAd ad) {
|
return homeAdDao.save(ad);
|
}
|
|
public HomeAd getHomeAdById(String id) {
|
|
return homeAdDao.find(HomeAd.class, id);
|
}
|
|
public void updateHomeAd(HomeAd ad) {
|
homeAdDao.update(ad);
|
}
|
|
// 后台操作
|
@SuppressWarnings("unchecked")
|
public List<HomeAdAdmin> getHomeAdAdmin(final String key, final String systemId, final int detailSystem, final String dataKey, final int page) {
|
return (List<HomeAdAdmin>) homeAdDao.excute(new HibernateCallback<List<HomeAdAdmin>>() {
|
public List<HomeAdAdmin> doInHibernate(Session session) throws HibernateException {
|
List<HomeAdAdmin> zhiBoClassList = new ArrayList<>();
|
try {
|
List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem ds where ds.system.id=" + systemId).list();
|
String sql = "";
|
List<String> andList = new ArrayList<>();
|
if (detailSystem > 0) {
|
andList.add("sh.detailSystem.id=" + detailSystem);
|
if (dataKey != null) {
|
andList.add("sh.homeAd.specialDataKey='" + dataKey + "'");
|
}
|
|
sql = "select sh.homeAd from SuperHomeAd sh where " + StringUtil.concat(andList, " and ") + " order by sh.homeAd.createtime desc";
|
} else {
|
andList.add("zb.system.id=" + systemId);
|
if (dataKey != null) {
|
andList.add("zb.specialDataKey='" + dataKey + "'");
|
}
|
sql = "from HomeAd zb where " + StringUtil.concat(andList, " and ") + " order by zb.createtime desc";
|
}
|
List<HomeAd> list = session.createQuery(sql).setFirstResult((page - 1) * Constant.pageCount)
|
.setMaxResults(Constant.pageCount).list();
|
for (HomeAd vb : list) {
|
List<DetailSystem> detailSystemS = session
|
.createQuery("select vb.detailSystem from SuperHomeAd vb where vb.homeAd.id=?")
|
.setParameter(0, vb.getId()).list();
|
|
List<DetailSystemSelect> dssList = new ArrayList<>();
|
|
for (DetailSystem ds : detailSystemList) {
|
DetailSystemSelect dss = new DetailSystemSelect();
|
dss.setDetailSystem(ds);
|
dss.setSelected(false);
|
dssList.add(dss);
|
}
|
|
// 设置已经存在的
|
for (DetailSystem ds : detailSystemS) {
|
for (DetailSystemSelect dss : dssList) {
|
if (dss.getDetailSystem().getId().equalsIgnoreCase(ds.getId())) {
|
dss.setSelected(true);
|
break;
|
}
|
}
|
}
|
SuperHomeAd sz = new SuperHomeAd();
|
sz.setDetailSystem(null);
|
sz.setHomeAd(vb);
|
zhiBoClassList.add(new HomeAdAdmin(sz, dssList));
|
}
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return zhiBoClassList;
|
}
|
});
|
}
|
|
public long getHomeAdAdminCount(String key, String systemId, int detailSystem, String dataKey) {
|
String sql = "";
|
List<String> andList = new ArrayList<>();
|
if (detailSystem > 0) {
|
andList.add("zb.detailsystemid=" + detailSystem);
|
if (dataKey != null) {
|
andList.add("c.special_data_key='" + dataKey + "'");
|
}
|
|
sql = "select count(*) from (select count(*) from wk_video_super_homead zb left join wk_video_homead c on c.id=zb.homeadid where " + StringUtil.concat(andList, " and ") + " group by zb.homeadid) s";
|
} else {
|
andList.add("system=" + systemId);
|
if (dataKey != null) {
|
andList.add("special_data_key='" + dataKey + "'");
|
}
|
|
sql = "select count(*) from wk_video_homead where " + StringUtil.concat(andList, " and ");
|
}
|
return homeAdDao.getCountSQL(sql);
|
}
|
|
@SuppressWarnings("unchecked")
|
public void deleteHomeAdAdmin(final String classId, final String detailSystemId) {
|
homeAdDao.excute(new HibernateCallback() {
|
public Object doInHibernate(Session session) throws HibernateException {
|
try {
|
List<SuperHomeAd> list = session
|
.createQuery("from SuperHomeAd vb where vb.homeAd.id=? and vb.detailSystem.id=?")
|
.setParameter(0, classId).setParameter(1, detailSystemId).list();
|
session.getTransaction().begin();
|
if (list != null && list.size() > 0) {
|
for (SuperHomeAd vb : list)
|
session.delete(vb);
|
}
|
session.flush();
|
session.getTransaction().commit();
|
} catch (Exception e) {
|
e.printStackTrace();
|
session.getTransaction().rollback();
|
}
|
return null;
|
}
|
});
|
|
}
|
|
public List<HomeAd> getSuperHomeAdList(String detailSystemId) {
|
return homeAdDao.list("select sh.homeAd from SuperHomeAd sh where sh.detailSystem.id=" + detailSystemId);
|
}
|
|
// 更新广告列表
|
@SuppressWarnings("unchecked")
|
public void updateSuperHomeAdList(final String detailSystemId, final List<HomeAd> adList) {
|
homeAdDao.excute(new HibernateCallback() {
|
public Object doInHibernate(Session session) throws HibernateException {
|
try {
|
List<SuperHomeAd> list = session
|
.createQuery("from SuperHomeAd sh where sh.detailSystem.id=" + detailSystemId).list();
|
session.getTransaction().begin();
|
for (SuperHomeAd ad : list) {
|
session.delete(ad);
|
}
|
|
for (HomeAd homeAd : adList) {
|
SuperHomeAd shd = new SuperHomeAd();
|
shd.setCreatetime(System.currentTimeMillis() + "");
|
shd.setDetailSystem(new DetailSystem(detailSystemId));
|
shd.setHomeAd(homeAd);
|
session.persist(shd);
|
}
|
session.flush();
|
session.getTransaction().commit();
|
} catch (Exception e) {
|
e.printStackTrace();
|
session.getTransaction().rollback();
|
}
|
return null;
|
}
|
});
|
|
}
|
|
public void addSuperHomeAd(SuperHomeAd sv) {
|
List<SuperHomeAd> list = superHomeAdDao.list("from SuperHomeAd sv where sv.homeAd.id=" + sv.getHomeAd().getId()
|
+ " and sv.detailSystem.id=" + sv.getDetailSystem().getId());
|
if (list != null && list.size() > 0)
|
return;
|
superHomeAdDao.create(sv);
|
}
|
|
}
|
