package com.newvideo.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.Query;
|
import org.hibernate.SQLQuery;
|
import org.hibernate.Session;
|
import org.springframework.orm.hibernate4.HibernateCallback;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import com.newvideo.dao.HomeNoticeDao;
|
import com.newvideo.dao.SuperHomeNoticeDao;
|
import com.newvideo.dao.VideoInfoDao;
|
import com.newvideo.domain.DetailSystem;
|
import com.newvideo.domain.HomeNotice;
|
import com.newvideo.domain.HomeType;
|
import com.newvideo.domain.SuperHomeNotice;
|
import com.newvideo.domain.SystemInfo;
|
import com.newvideo.domain.web.DetailSystemSelect;
|
import com.newvideo.domain.web.HomeNoticeAdmin;
|
import com.newvideo.util.Constant;
|
|
@Service
|
public class HomeNoticeService {
|
@Resource
|
private HomeNoticeDao homeNoticeDao;
|
@Resource
|
private VideoInfoDao videoInfoDao;
|
@Resource
|
private SuperHomeNoticeDao superHomeNoticeDao;
|
|
// 首页公告
|
public List<HomeNotice> getHomeNoticeList(SystemInfo system) {
|
List<HomeNotice> list = homeNoticeDao
|
.list("from HomeNotice h where h.show='1' and h.system.id=" + system.getId());
|
return list;
|
}
|
|
// 首页公告
|
public List<HomeNotice> getHomeNoticeList() {
|
List<HomeNotice> list = homeNoticeDao.list("from HomeNotice");
|
return list;
|
}
|
|
public List<HomeNotice> getVisiableHomeNoticeList() {
|
List<HomeNotice> list = homeNoticeDao.list("from HomeNotice h where h.show=1");
|
return list;
|
}
|
|
public void addHomeNotice(HomeNotice notice) {
|
homeNoticeDao.create(notice);
|
}
|
|
public void updateHomeNotice(HomeNotice notice) {
|
homeNoticeDao.update(notice);
|
}
|
|
public HomeNotice getHomeNotice(Serializable s) {
|
return homeNoticeDao.find(HomeNotice.class, s);
|
}
|
|
@SuppressWarnings("unchecked")
|
public void deleteHomeNotice(final HomeNotice notice) {
|
homeNoticeDao.excute(new HibernateCallback() {
|
public Object doInHibernate(Session session) throws HibernateException {
|
try {
|
List<SuperHomeNotice> list = session.createQuery("from SuperHomeNotice sv where sv.homeNotice.id=?")
|
.setParameter(0, notice.getId()).list();
|
session.getTransaction().begin();
|
for (SuperHomeNotice sv : list)
|
session.delete(sv);
|
session.delete(new HomeNotice(notice.getId()));
|
session.flush();
|
session.getTransaction().commit();
|
} catch (Exception e) {
|
e.printStackTrace();
|
session.getTransaction().rollback();
|
}
|
return null;
|
}
|
});
|
|
}
|
|
public List<HomeType> getIOSTestHomeType() {
|
List<HomeType> list = new ArrayList<HomeType>();
|
HomeType type = new HomeType();
|
type.setId("130");
|
type.setName("萌宠奇趣");
|
type.setVideoList(
|
videoInfoDao.list("from VideoInfo v where v.show=1 and v.videoType.id=130 order by v.createtime desc",
|
0, 3, new String[] {}));
|
list.add(type);
|
|
type = new HomeType();
|
type.setId("129");
|
type.setName("相声小品");
|
type.setVideoList(
|
videoInfoDao.list("from VideoInfo v where v.show=1 and v.videoType.id=129 order by v.createtime desc",
|
0, 3, new String[] {}));
|
list.add(type);
|
|
type = new HomeType();
|
type.setId("19");
|
type.setName("纪录片");
|
type.setVideoList(
|
videoInfoDao.list("from VideoInfo v where v.show=1 and v.videoType.id=19 order by v.createtime desc", 0,
|
3, new String[] {}));
|
list.add(type);
|
|
type = new HomeType();
|
type.setId("14");
|
type.setName("游戏");
|
type.setVideoList(videoInfoDao.list(
|
"from VideoInfo v where v.show=1 and v.videoType.id=91 OR v.videoType.id=92 OR v.videoType.id=93 OR v.videoType.id=94 order by v.createtime desc",
|
0, 3, new String[] {}));
|
list.add(type);
|
|
type = new HomeType();
|
type.setId("13");
|
type.setName("体育");
|
type.setVideoList(
|
videoInfoDao.list("from VideoInfo v where v.show=1 and v.videoType.id=13 order by v.createtime desc", 0,
|
3, new String[] {}));
|
list.add(type);
|
|
return list;
|
}
|
|
// 后台操作
|
@SuppressWarnings("unchecked")
|
public List<HomeNoticeAdmin> getHomeNoticeAdmin(final String key, final int detailSystem, final int page) {
|
|
return (List<HomeNoticeAdmin>) homeNoticeDao.excute(new HibernateCallback<List<HomeNoticeAdmin>>() {
|
public List<HomeNoticeAdmin> doInHibernate(Session session) throws HibernateException {
|
List<HomeNoticeAdmin> zhiBoClassList = new ArrayList<HomeNoticeAdmin>();
|
try {
|
List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem").list();
|
String sql = "";
|
if (detailSystem > 0)
|
sql = "select sh.homeNotice from SuperHomeNotice sh where sh.detailSystem.id=" + detailSystem
|
+ " order by sh.homeNotice.createtime desc";
|
else
|
sql = "from HomeNotice zb order by zb.createtime desc";
|
|
List<HomeNotice> list = session.createQuery(sql).setFirstResult((page - 1) * Constant.pageCount)
|
.setMaxResults(Constant.pageCount).list();
|
for (HomeNotice vb : list) {
|
List<DetailSystem> detailSystemS = session
|
.createQuery("select vb.detailSystem from SuperHomeNotice vb where vb.homeNotice.id=?")
|
.setParameter(0, vb.getId()).list();
|
|
List<DetailSystemSelect> dssList = new ArrayList<DetailSystemSelect>();
|
|
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;
|
}
|
}
|
}
|
SuperHomeNotice sz = new SuperHomeNotice();
|
sz.setDetailSystem(null);
|
sz.setHomeNotice(vb);
|
zhiBoClassList.add(new HomeNoticeAdmin(sz, dssList));
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return zhiBoClassList;
|
}
|
});
|
|
}
|
|
public long getHomeNoticeAdminCount(String key, int detailSystem) {
|
String sql = "";
|
if (detailSystem > 0)
|
sql = "select count(*) from (select count(*) from wk_video_super_homenotice zb left join wk_video_homenotice c on c.id=zb.homenoticeid where zb.detailsystem="
|
+ detailSystem + " group by zb.homenoticeid) s";
|
else
|
sql = "select count(*) from (select count(*) from wk_video_super_homenotice zb left join wk_video_homenotice c on c.id=zb.homenoticeid group by zb.homenoticeid) s";
|
|
return homeNoticeDao.getCountSQL(sql);
|
}
|
|
@SuppressWarnings("unchecked")
|
public void deleteHomeNoticeAdmin(final String classId, final String detailSystemId) {
|
homeNoticeDao.excute(new HibernateCallback() {
|
public Object doInHibernate(Session session) throws HibernateException {
|
try {
|
List<SuperHomeNotice> list = session
|
.createQuery("from SuperHomeNotice vb where vb.homeNotice.id=? and vb.detailSystem.id=?")
|
.setParameter(0, classId).setParameter(1, detailSystemId).list();
|
session.getTransaction().begin();
|
if (list != null && list.size() > 0) {
|
for (SuperHomeNotice vb : list)
|
session.delete(vb);
|
}
|
session.flush();
|
session.getTransaction().commit();
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
session.getTransaction().rollback();
|
}
|
return null;
|
}
|
});
|
|
}
|
|
/**
|
* 小黄条
|
*/
|
|
public List<HomeNotice> getHomeNoticeList(String detailSystem) {
|
|
return homeNoticeDao
|
.list("select hs.homeNotice FROM SuperHomeNotice hs where hs.detailSystem.id=" + detailSystem);
|
}
|
|
public void addSuperHomeNotice(SuperHomeNotice sv) {
|
List<SuperHomeNotice> list = superHomeNoticeDao.list("from SuperHomeNotice sv where sv.homeNotice.id="
|
+ sv.getHomeNotice().getId() + " and sv.detailSystem.id=" + sv.getDetailSystem().getId());
|
if (list != null && list.size() > 0)
|
return;
|
superHomeNoticeDao.create(sv);
|
}
|
|
public void updateSuperHomeNotice(SuperHomeNotice hotSearch) {
|
superHomeNoticeDao.update(hotSearch);
|
}
|
|
@Transactional
|
public void deleteSuperHomeNotice(final SuperHomeNotice hotSearch) {
|
superHomeNoticeDao.excute(new HibernateCallback() {
|
@Override
|
public Object doInHibernate(Session session)
|
throws HibernateException {
|
Query query = session.createQuery("delete from SuperHomeNotice shn where shn.homeNotice.id = ? and shn.detailSystem.id = ?");
|
query.setParameter(0, hotSearch.getHomeNotice().getId());
|
query.setParameter(1, hotSearch.getDetailSystem().getId());
|
query.executeUpdate();
|
return null;
|
}
|
});
|
}
|
|
@SuppressWarnings("unchecked")
|
public void updateSuperHomeNoticeList(final String detailSystemId, final List<SuperHomeNotice> typeList) {
|
homeNoticeDao.excute(new HibernateCallback() {
|
public Object doInHibernate(Session session) throws HibernateException {
|
try {
|
List<SuperHomeNotice> list = session
|
.createQuery("from SuperHomeNotice sh where sh.detailSystem.id=" + detailSystemId).list();
|
session.getTransaction().begin();
|
for (SuperHomeNotice ad : list) {
|
session.delete(ad);
|
}
|
|
for (SuperHomeNotice videoType : typeList) {
|
session.persist(videoType);
|
}
|
session.flush();
|
session.getTransaction().commit();
|
} catch (Exception e) {
|
e.printStackTrace();
|
session.getTransaction().rollback();
|
}
|
return null;
|
}
|
});
|
|
}
|
|
}
|
