From d73687bc6115007145b4aab050e4e29ff87fd8ae Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期一, 01 三月 2021 18:44:36 +0800
Subject: [PATCH] 布丸代码优化
---
src/main/java/com/yeshi/buwan/service/imp/AdService.java | 745 +++++++++++++++++++++++++-------------------------------
1 files changed, 337 insertions(+), 408 deletions(-)
diff --git a/src/main/java/com/yeshi/buwan/service/imp/AdService.java b/src/main/java/com/yeshi/buwan/service/imp/AdService.java
index ab2752d..398d5be 100644
--- a/src/main/java/com/yeshi/buwan/service/imp/AdService.java
+++ b/src/main/java/com/yeshi/buwan/service/imp/AdService.java
@@ -40,472 +40,401 @@
@Service
public class AdService {
- @Resource
- private RecommendAdDao recommendAdDao;
- @Resource
- private MineAdDao mineAdDao;
- @Resource
- private AdStatisticsDao adStatisticsDao;
- @Resource
- private WXAdDao wxAdDao;
- @Resource
- private WXStatisticsDao wxStatisticsDao;
- @Resource
- private SuperRecommendAdDao superRecommendAdDao;
- @Resource
- private CommonAdPositionAdDao commonAdPositionAdDao;
- @Resource
- private CommonAdStatisticsDao commonAdStatisticsDao;
- @Resource
- private CommonAdDao commonAdDao;
+ @Resource
+ private RecommendAdDao recommendAdDao;
+ @Resource
+ private MineAdDao mineAdDao;
+ @Resource
+ private AdStatisticsDao adStatisticsDao;
+ @Resource
+ private WXAdDao wxAdDao;
+ @Resource
+ private WXStatisticsDao wxStatisticsDao;
+ @Resource
+ private SuperRecommendAdDao superRecommendAdDao;
+ @Resource
+ private CommonAdPositionAdDao commonAdPositionAdDao;
+ @Resource
+ private CommonAdStatisticsDao commonAdStatisticsDao;
+ @Resource
+ private CommonAdDao commonAdDao;
- @Resource
- private CommonAdPositionDao commonAdPositionDao;
+ @Resource
+ private CommonAdPositionDao commonAdPositionDao;
- public CommonAdDao getCommonAdDao() {
- return commonAdDao;
- }
- public void setCommonAdDao(CommonAdDao commonAdDao) {
- this.commonAdDao = commonAdDao;
- }
+ // 鑾峰彇骞垮憡
+ public List<RecommendAd> getRecommendAdList() {
- public CommonAdStatisticsDao getCommonAdStatisticsDao() {
- return commonAdStatisticsDao;
- }
+ return recommendAdDao.list("from RecommendAd");
+ }
- public void setCommonAdStatisticsDao(CommonAdStatisticsDao commonAdStatisticsDao) {
- this.commonAdStatisticsDao = commonAdStatisticsDao;
- }
+ public List<RecommendAd> getRecommendAdList(int type) {
- public CommonAdPositionAdDao getCommonAdPositionAdDao() {
- return commonAdPositionAdDao;
- }
+ return recommendAdDao.list("from RecommendAd a where a.platform=3 or a.platform=" + type);
+ }
- public void setCommonAdPositionAdDao(CommonAdPositionAdDao commonAdPositionAdDao) {
- this.commonAdPositionAdDao = commonAdPositionAdDao;
- }
+ public RecommendAd getAdById(String id) {
- public SuperRecommendAdDao getSuperRecommendAdDao() {
- return superRecommendAdDao;
- }
+ return recommendAdDao.find(RecommendAd.class, id);
+ }
- public void setSuperRecommendAdDao(SuperRecommendAdDao superRecommendAdDao) {
- this.superRecommendAdDao = superRecommendAdDao;
- }
+ public void updateRecommendAd(RecommendAd ad) {
- public WXStatisticsDao getWxStatisticsDao() {
- return wxStatisticsDao;
- }
+ recommendAdDao.update(ad);
+ }
- public void setWxStatisticsDao(WXStatisticsDao wxStatisticsDao) {
- this.wxStatisticsDao = wxStatisticsDao;
- }
+ public void addRecommendAd(RecommendAd ad) {
+ recommendAdDao.create(ad);
+ }
- public WXAdDao getWxAdDao() {
- return wxAdDao;
- }
+ @SuppressWarnings("unchecked")
+ public void deleteRecommendAd(final String id) {
+ recommendAdDao.excute(new HibernateCallback() {
+ public Object doInHibernate(Session session) throws HibernateException {
+ try {
+ session.getTransaction().begin();
+ List<SuperRecommendAd> list = session
+ .createQuery("from SuperRecommendAd sv where sv.recommendAd.id=?").setParameter(0, id)
+ .list();
+ for (SuperRecommendAd sv : list)
+ session.delete(sv);
+ session.delete(new RecommendAd(id));
+ session.flush();
+ session.getTransaction().commit();
+ } catch (Exception e) {
+ session.getTransaction().rollback();
+ }
+ return null;
+ }
+ });
- public void setWxAdDao(WXAdDao wxAdDao) {
- this.wxAdDao = wxAdDao;
- }
+ }
- public AdStatisticsDao getAdStatisticsDao() {
- return adStatisticsDao;
- }
+ public List<MineAd> getMineAdList(String key) {
+ return mineAdDao.list(
+ "from MineAd ma where ma.open=1 and ma.adKey.key=? order by ma.first desc,ma.percent desc",
+ new String[]{key});
+ }
- public void setAdStatisticsDao(AdStatisticsDao adStatisticsDao) {
- this.adStatisticsDao = adStatisticsDao;
- }
+ /**
+ * 鍚庡彴鎿嶄綔
+ */
- public MineAdDao getMineAdDao() {
- return mineAdDao;
- }
+ @SuppressWarnings("unchecked")
+ public List<RecommendAdAdmin> getRecommendAdAdmin(final String key, final int detailSystem, final int page) {
+ return (List<RecommendAdAdmin>) recommendAdDao.excute(new HibernateCallback<List<RecommendAdAdmin>>() {
+ public List<RecommendAdAdmin> doInHibernate(Session session) throws HibernateException {
+ List<RecommendAdAdmin> zhiBoClassList = new ArrayList<RecommendAdAdmin>();
+ try {
+ List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem").list();
+ String sql = "";
+ if (detailSystem > 0)
+ sql = "select sh.recommendAd from SuperRecommendAd sh where sh.detailSystem.id=" + detailSystem
+ + " order by sh.recommendAd.createtime desc";
+ else
+ sql = "from RecommendAd zb order by zb.createtime desc";
- public void setMineAdDao(MineAdDao mineAdDao) {
- this.mineAdDao = mineAdDao;
- }
+ List<RecommendAd> list = session.createQuery(sql).setFirstResult((page - 1) * Constant.pageCount)
+ .setMaxResults(Constant.pageCount).list();
+ for (RecommendAd vb : list) {
+ List<DetailSystem> detailSystemS = session
+ .createQuery(
+ "select vb.detailSystem from SuperRecommendAd vb where vb.recommendAd.id=?")
+ .setParameter(0, vb.getId()).list();
- public RecommendAdDao getRecommendAdDao() {
- return recommendAdDao;
- }
+ List<DetailSystemSelect> dssList = new ArrayList<DetailSystemSelect>();
- public void setRecommendAdDao(RecommendAdDao recommendAdDao) {
- this.recommendAdDao = recommendAdDao;
- }
+ for (DetailSystem ds : detailSystemList) {
+ DetailSystemSelect dss = new DetailSystemSelect();
+ dss.setDetailSystem(ds);
+ dss.setSelected(false);
+ dssList.add(dss);
+ }
- // 鑾峰彇骞垮憡
- public List<RecommendAd> getRecommendAdList() {
+ // 璁剧疆宸茬粡瀛樺湪鐨�
+ for (DetailSystem ds : detailSystemS) {
+ for (DetailSystemSelect dss : dssList) {
+ if (dss.getDetailSystem().getId().equalsIgnoreCase(ds.getId())) {
+ dss.setSelected(true);
+ break;
+ }
+ }
+ }
+ SuperRecommendAd sz = new SuperRecommendAd();
+ sz.setDetailSystem(null);
+ sz.setRecommendAd(vb);
+ zhiBoClassList.add(new RecommendAdAdmin(sz, dssList));
+ }
- return recommendAdDao.list("from RecommendAd");
- }
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ return zhiBoClassList;
+ }
+ });
- public List<RecommendAd> getRecommendAdList(int type) {
+ }
- return recommendAdDao.list("from RecommendAd a where a.platform=3 or a.platform=" + type);
- }
+ public long getRecommendAdAdminCount(String key, int detailSystem) {
+ String sql = "";
+ if (detailSystem > 0)
+ sql = "select count(*) from (select count(*) from wk_video_super_recommendad zb left join wk_ad_recommend c on c.id=zb.recommendadid where zb.detailsystem="
+ + detailSystem + " group by zb.recommendadid) s";
+ else
+ sql = "select count(*) from (select count(*) from wk_video_super_recommendad zb left join wk_ad_recommend c on c.id=zb.recommendadid group by zb.recommendadid) s";
- public RecommendAd getAdById(String id) {
+ return recommendAdDao.getCountSQL(sql);
+ }
- return recommendAdDao.find(RecommendAd.class, id);
- }
+ @SuppressWarnings("rawtypes")
+ public void addRecommendAdAdmin(final String classid, final String detailSystemId) {
+ recommendAdDao.excute(new HibernateCallback() {
+ public Object doInHibernate(Session session) throws HibernateException {
+ try {
+ session.getTransaction().begin();
+ List list = session
+ .createQuery("from SuperRecommendAd vb where vb.recommendAd.id=? and vb.detailSystem.id=?")
+ .setParameter(0, classid).setParameter(1, detailSystemId).list();
+ if (list == null || list.size() == 0) {
+ SuperRecommendAd vb = new SuperRecommendAd();
+ vb.setCreatetime(System.currentTimeMillis() + "");
+ vb.setDetailSystem(new DetailSystem(detailSystemId));
+ vb.setRecommendAd(new RecommendAd(classid));
+ session.persist(vb);
+ }
+ session.flush();
+ session.getTransaction().commit();
- public void updateRecommendAd(RecommendAd ad) {
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ return null;
+ }
+ });
- recommendAdDao.update(ad);
- }
+ }
- public void addRecommendAd(RecommendAd ad) {
- recommendAdDao.create(ad);
- }
+ @SuppressWarnings({"unchecked", "rawtypes"})
+ public void deleteRecommendAdAdmin(final String classId, final String detailSystemId) {
+ recommendAdDao.excute(new HibernateCallback() {
+ public Object doInHibernate(Session session) throws HibernateException {
+ try {
+ session.getTransaction().begin();
+ List<SuperRecommendAd> list = session
+ .createQuery("from SuperRecommendAd vb where vb.recommendAd.id=? and vb.detailSystem.id=?")
+ .setParameter(0, classId).setParameter(1, detailSystemId).list();
+ if (list != null && list.size() > 0) {
+ for (SuperRecommendAd vb : list)
+ session.delete(vb);
+ }
+ session.flush();
+ session.getTransaction().commit();
+ } catch (Exception e) {
+ e.printStackTrace();
+ session.getTransaction().rollback();
+ }
+ return null;
+ }
+ });
- @SuppressWarnings("unchecked")
- public void deleteRecommendAd(final String id) {
- recommendAdDao.excute(new HibernateCallback() {
- public Object doInHibernate(Session session) throws HibernateException {
- try {
- session.getTransaction().begin();
- List<SuperRecommendAd> list = session
- .createQuery("from SuperRecommendAd sv where sv.recommendAd.id=?").setParameter(0, id)
- .list();
- for (SuperRecommendAd sv : list)
- session.delete(sv);
- session.delete(new RecommendAd(id));
- session.flush();
- session.getTransaction().commit();
- } catch (Exception e) {
- session.getTransaction().rollback();
- }
- return null;
- }
- });
+ }
- }
+ public void AddStatistics(String key, String platform, int type) {
+ AdStatistics ad = new AdStatistics();
+ ad.setKey(key);
+ ad.setPlatformId(platform);
+ ad.setTime(System.currentTimeMillis() + "");
+ ad.setType(type);
+ adStatisticsDao.create(ad);
+ }
- public List<MineAd> getMineAdList(String key) {
- return mineAdDao.list(
- "from MineAd ma where ma.open=1 and ma.adKey.key=? order by ma.first desc,ma.percent desc",
- new String[] { key });
- }
+ /**
+ * 鑾峰彇寰俊骞垮憡
+ *
+ * @return
+ */
+ public List<WXAd> getWinAd(SystemInfo system) {
+ List<WXAd> list = wxAdDao.list("from WXAd w where w.system.id=" + system.getId());
+ return list;
+ }
- /**
- * 鍚庡彴鎿嶄綔
- */
+ public List<WXAd> getWinAd() {
+ List<WXAd> list = wxAdDao.list("from WXAd");
+ return list;
+ }
- @SuppressWarnings("unchecked")
- public List<RecommendAdAdmin> getRecommendAdAdmin(final String key, final int detailSystem, final int page) {
- return (List<RecommendAdAdmin>) recommendAdDao.excute(new HibernateCallback<List<RecommendAdAdmin>>() {
- public List<RecommendAdAdmin> doInHibernate(Session session) throws HibernateException {
- List<RecommendAdAdmin> zhiBoClassList = new ArrayList<RecommendAdAdmin>();
- try {
- List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem").list();
- String sql = "";
- if (detailSystem > 0)
- sql = "select sh.recommendAd from SuperRecommendAd sh where sh.detailSystem.id=" + detailSystem
- + " order by sh.recommendAd.createtime desc";
- else
- sql = "from RecommendAd zb order by zb.createtime desc";
+ /**
+ * 娣诲姞寰俊骞垮憡
+ *
+ * @param ad
+ */
+ public void addWX(WXAd ad) {
+ wxAdDao.create(ad);
+ }
- List<RecommendAd> list = session.createQuery(sql).setFirstResult((page - 1) * Constant.pageCount)
- .setMaxResults(Constant.pageCount).list();
- for (RecommendAd vb : list) {
- List<DetailSystem> detailSystemS = session
- .createQuery(
- "select vb.detailSystem from SuperRecommendAd vb where vb.recommendAd.id=?")
- .setParameter(0, vb.getId()).list();
+ public void deleteWX(WXAd ad) {
+ wxAdDao.delete(ad);
+ }
- List<DetailSystemSelect> dssList = new ArrayList<DetailSystemSelect>();
+ public WXAd getWXAd(Serializable id) {
+ return wxAdDao.find(WXAd.class, id);
+ }
- for (DetailSystem ds : detailSystemList) {
- DetailSystemSelect dss = new DetailSystemSelect();
- dss.setDetailSystem(ds);
- dss.setSelected(false);
- dssList.add(dss);
- }
+ public void updateWXAd(WXAd ad) {
+ wxAdDao.update(ad);
+ }
- // 璁剧疆宸茬粡瀛樺湪鐨�
- for (DetailSystem ds : detailSystemS) {
- for (DetailSystemSelect dss : dssList) {
- if (dss.getDetailSystem().getId().equalsIgnoreCase(ds.getId())) {
- dss.setSelected(true);
- break;
- }
- }
- }
- SuperRecommendAd sz = new SuperRecommendAd();
- sz.setDetailSystem(null);
- sz.setRecommendAd(vb);
- zhiBoClassList.add(new RecommendAdAdmin(sz, dssList));
- }
-
- } catch (Exception e) {
- e.printStackTrace();
- }
- return zhiBoClassList;
- }
- });
-
- }
-
- public long getRecommendAdAdminCount(String key, int detailSystem) {
- String sql = "";
- if (detailSystem > 0)
- sql = "select count(*) from (select count(*) from wk_video_super_recommendad zb left join wk_ad_recommend c on c.id=zb.recommendadid where zb.detailsystem="
- + detailSystem + " group by zb.recommendadid) s";
- else
- sql = "select count(*) from (select count(*) from wk_video_super_recommendad zb left join wk_ad_recommend c on c.id=zb.recommendadid group by zb.recommendadid) s";
-
- return recommendAdDao.getCountSQL(sql);
- }
-
- @SuppressWarnings("rawtypes")
- public void addRecommendAdAdmin(final String classid, final String detailSystemId) {
- recommendAdDao.excute(new HibernateCallback() {
- public Object doInHibernate(Session session) throws HibernateException {
- try {
- session.getTransaction().begin();
- List list = session
- .createQuery("from SuperRecommendAd vb where vb.recommendAd.id=? and vb.detailSystem.id=?")
- .setParameter(0, classid).setParameter(1, detailSystemId).list();
- if (list == null || list.size() == 0) {
- SuperRecommendAd vb = new SuperRecommendAd();
- vb.setCreatetime(System.currentTimeMillis() + "");
- vb.setDetailSystem(new DetailSystem(detailSystemId));
- vb.setRecommendAd(new RecommendAd(classid));
- session.persist(vb);
- }
- session.flush();
- session.getTransaction().commit();
-
- } catch (Exception e) {
- e.printStackTrace();
- }
- return null;
- }
- });
-
- }
-
- @SuppressWarnings({ "unchecked", "rawtypes" })
- public void deleteRecommendAdAdmin(final String classId, final String detailSystemId) {
- recommendAdDao.excute(new HibernateCallback() {
- public Object doInHibernate(Session session) throws HibernateException {
- try {
- session.getTransaction().begin();
- List<SuperRecommendAd> list = session
- .createQuery("from SuperRecommendAd vb where vb.recommendAd.id=? and vb.detailSystem.id=?")
- .setParameter(0, classId).setParameter(1, detailSystemId).list();
- if (list != null && list.size() > 0) {
- for (SuperRecommendAd vb : list)
- session.delete(vb);
- }
- session.flush();
- session.getTransaction().commit();
- } catch (Exception e) {
- e.printStackTrace();
- session.getTransaction().rollback();
- }
- return null;
- }
- });
-
- }
-
- public void AddStatistics(String key, String platform, int type) {
- AdStatistics ad = new AdStatistics();
- ad.setKey(key);
- ad.setPlatformId(platform);
- ad.setTime(System.currentTimeMillis() + "");
- ad.setType(type);
- adStatisticsDao.create(ad);
- }
-
- /**
- * 鑾峰彇寰俊骞垮憡
- *
- * @return
- */
- public List<WXAd> getWinAd(SystemInfo system) {
- List<WXAd> list = wxAdDao.list("from WXAd w where w.system.id=" + system.getId());
- return list;
- }
-
- public List<WXAd> getWinAd() {
- List<WXAd> list = wxAdDao.list("from WXAd");
- return list;
- }
-
- /**
- * 娣诲姞寰俊骞垮憡
- *
- * @param ad
- */
- public void addWX(WXAd ad) {
- wxAdDao.create(ad);
- }
-
- public void deleteWX(WXAd ad) {
- wxAdDao.delete(ad);
- }
-
- public WXAd getWXAd(Serializable id) {
- return wxAdDao.find(WXAd.class, id);
- }
-
- public void updateWXAd(WXAd ad) {
- wxAdDao.update(ad);
- }
-
- /**
- * 鎻掑叆寰俊缁熻浠ｇ爜
- *
- * @param bean
- */
- public void insertWXStatistics(WXStatistics bean) {
- wxStatisticsDao.create(bean);
- }
+ /**
+ * 鎻掑叆寰俊缁熻浠ｇ爜
+ *
+ * @param bean
+ */
+ public void insertWXStatistics(WXStatistics bean) {
+ wxStatisticsDao.create(bean);
+ }
- /**
- * 鎺ㄨ崘骞垮憡鏉�
- */
- @Cacheable(value = "homeCache",key="'getRecommendAdList'+'-'+#detailSystem")
- public List<RecommendAd> getRecommendAdList(String detailSystem) {
- return recommendAdDao
- .list("select hs.recommendAd FROM SuperRecommendAd hs where hs.detailSystem.id=" + detailSystem);
- }
+ /**
+ * 鎺ㄨ崘骞垮憡鏉�
+ */
+ @Cacheable(value = "homeCache", key = "'getRecommendAdList'+'-'+#detailSystem")
+ public List<RecommendAd> getRecommendAdList(String detailSystem) {
+ return recommendAdDao
+ .list("select hs.recommendAd FROM SuperRecommendAd hs where hs.detailSystem.id=" + detailSystem);
+ }
- public void addRecommendAd(SuperRecommendAd sv) {
- List<SuperRecommendAd> list = superRecommendAdDao.list("from SuperRecommendAd sv where sv.recommendAd.id="
- + sv.getRecommendAd().getId() + " and sv.detailSystem.id=" + sv.getDetailSystem().getId());
- if (list != null && list.size() > 0)
- return;
- superRecommendAdDao.create(sv);
- }
+ public void addRecommendAd(SuperRecommendAd sv) {
+ List<SuperRecommendAd> list = superRecommendAdDao.list("from SuperRecommendAd sv where sv.recommendAd.id="
+ + sv.getRecommendAd().getId() + " and sv.detailSystem.id=" + sv.getDetailSystem().getId());
+ if (list != null && list.size() > 0)
+ return;
+ superRecommendAdDao.create(sv);
+ }
- public void updateSuperRecommendAd(SuperRecommendAd hotSearch) {
- superRecommendAdDao.update(hotSearch);
- }
+ public void updateSuperRecommendAd(SuperRecommendAd hotSearch) {
+ superRecommendAdDao.update(hotSearch);
+ }
- public void deleteSuperRecommendAd(SuperRecommendAd hotSearch) {
- superRecommendAdDao.delete(hotSearch);
- }
+ public void deleteSuperRecommendAd(SuperRecommendAd hotSearch) {
+ superRecommendAdDao.delete(hotSearch);
+ }
- @SuppressWarnings({ "unchecked", "rawtypes" })
- public void updateSuperRecommendAdList(final String detailSystemId, final List<SuperRecommendAd> typeList) {
- recommendAdDao.excute(new HibernateCallback() {
- public Object doInHibernate(Session session) throws HibernateException {
- try {
- session.getTransaction().begin();
- List<SuperRecommendAd> list = session
- .createQuery("from SuperRecommendAd sh where sh.detailSystem.id=" + detailSystemId).list();
- for (SuperRecommendAd ad : list) {
- session.delete(ad);
- }
+ @SuppressWarnings({"unchecked", "rawtypes"})
+ public void updateSuperRecommendAdList(final String detailSystemId, final List<SuperRecommendAd> typeList) {
+ recommendAdDao.excute(new HibernateCallback() {
+ public Object doInHibernate(Session session) throws HibernateException {
+ try {
+ session.getTransaction().begin();
+ List<SuperRecommendAd> list = session
+ .createQuery("from SuperRecommendAd sh where sh.detailSystem.id=" + detailSystemId).list();
+ for (SuperRecommendAd ad : list) {
+ session.delete(ad);
+ }
- for (SuperRecommendAd videoType : typeList) {
- session.persist(videoType);
- }
- session.flush();
- session.getTransaction().commit();
- } catch (Exception e) {
- e.printStackTrace();
- session.getTransaction().rollback();
- }
- return null;
- }
- });
+ for (SuperRecommendAd videoType : typeList) {
+ session.persist(videoType);
+ }
+ session.flush();
+ session.getTransaction().commit();
+ } catch (Exception e) {
+ e.printStackTrace();
+ session.getTransaction().rollback();
+ }
+ return null;
+ }
+ });
- }
+ }
- @Cacheable(value = "classCache",key="'getCommonAdByPid'+'-'+#pid")
- public List<CommonAdPositionAd> getCommonAdByPid(String pid) {
- return commonAdPositionAdDao.list("from CommonAdPositionAd pa where pa.adPosition.id=?",
- new Serializable[] { pid + "" });
- }
+ @Cacheable(value = "classCache", key = "'getCommonAdByPid'+'-'+#pid")
+ public List<CommonAdPositionAd> getCommonAdByPid(String pid) {
+ return commonAdPositionAdDao.list("from CommonAdPositionAd pa where pa.adPosition.id=?",
+ new Serializable[]{pid + ""});
+ }
- // 娣诲姞骞垮憡缁熻
- public void addCommonAdStatistics(int type, String pid, String commonAdid, String device) {
- CommonAdStatistics cas = new CommonAdStatistics();
- cas.setCommonAd(new CommonAd(commonAdid));
- cas.setCreatetime(System.currentTimeMillis() + "");
- cas.setType(type);
- cas.setPositionid(pid);
- cas.setDevice(device);
- commonAdStatisticsDao.create(cas);
- }
+ // 娣诲姞骞垮憡缁熻
+ public void addCommonAdStatistics(int type, String pid, String commonAdid, String device) {
+ CommonAdStatistics cas = new CommonAdStatistics();
+ cas.setCommonAd(new CommonAd(commonAdid));
+ cas.setCreatetime(System.currentTimeMillis() + "");
+ cas.setType(type);
+ cas.setPositionid(pid);
+ cas.setDevice(device);
+ commonAdStatisticsDao.create(cas);
+ }
- public List<CommonAdPosition> getCommonAdPositionList() {
- return (List<CommonAdPosition>) commonAdPositionDao.list("from CommonAdPosition");
- }
+ public List<CommonAdPosition> getCommonAdPositionList() {
+ return (List<CommonAdPosition>) commonAdPositionDao.list("from CommonAdPosition");
+ }
- public List<CommonAdPositionAd> getCommonAdPositionAd(String key, int pid, int pageIndex) {
- List<CommonAdPositionAd> adList = new ArrayList<CommonAdPositionAd>();
- adList = commonAdPositionAdDao.list("from CommonAdPositionAd ca where ca.adPosition.id=" + pid + "",
- (pageIndex - 1) * Constant.pageCount, Constant.pageCount, null);
+ public List<CommonAdPositionAd> getCommonAdPositionAd(String key, int pid, int pageIndex) {
+ List<CommonAdPositionAd> adList = new ArrayList<CommonAdPositionAd>();
+ adList = commonAdPositionAdDao.list("from CommonAdPositionAd ca where ca.adPosition.id=" + pid + "",
+ (pageIndex - 1) * Constant.pageCount, Constant.pageCount, null);
- for (CommonAdPositionAd ad : adList) {
- ad.setCommonAdPositionList(commonAdPositionDao
- .list("select pa.adPosition from CommonAdPositionAd pa where pa.ad.id=" + ad.getAd().getId()));
+ for (CommonAdPositionAd ad : adList) {
+ ad.setCommonAdPositionList(commonAdPositionDao
+ .list("select pa.adPosition from CommonAdPositionAd pa where pa.ad.id=" + ad.getAd().getId()));
- }
- return adList;
- }
+ }
+ return adList;
+ }
- public long getCommonAdPositionAdCount(String key, int pid) {
- return commonAdPositionAdDao
- .getCount("select count(*) from CommonAdPositionAd ca where ca.adPosition.id=" + pid + "");
- }
+ public long getCommonAdPositionAdCount(String key, int pid) {
+ return commonAdPositionAdDao
+ .getCount("select count(*) from CommonAdPositionAd ca where ca.adPosition.id=" + pid + "");
+ }
- public Serializable addCommonAd(CommonAd commonAd) {
- return commonAdDao.save(commonAd);
- }
+ public Serializable addCommonAd(CommonAd commonAd) {
+ return commonAdDao.save(commonAd);
+ }
- public void addCommonAdPositionAd(CommonAdPositionAd commonAdPositionAd) {
- commonAdPositionAdDao.create(commonAdPositionAd);
- }
+ public void addCommonAdPositionAd(CommonAdPositionAd commonAdPositionAd) {
+ commonAdPositionAdDao.create(commonAdPositionAd);
+ }
- public CommonAd getCommonAdById(String id) {
- return commonAdDao.find(CommonAd.class, id);
- }
+ public CommonAd getCommonAdById(String id) {
+ return commonAdDao.find(CommonAd.class, id);
+ }
- // 鏇存柊
- public void updateCommonAd(CommonAd commonAd) {
- commonAdDao.update(commonAd);
- }
+ // 鏇存柊
+ public void updateCommonAd(CommonAd commonAd) {
+ commonAdDao.update(commonAd);
+ }
- @SuppressWarnings({ "unchecked", "rawtypes" })
- public void deleteCommonAd(final CommonAd ca) {
- recommendAdDao.excute(new HibernateCallback() {
- public Object doInHibernate(Session session) throws HibernateException {
- try {
- session.getTransaction().begin();
- List<CommonAdPositionAd> list = session
- .createQuery("from CommonAdPositionAd cp where cp.ad.id=" + ca.getId()).list();
- for (CommonAdPositionAd cp : list) {
- session.delete(cp);
- }
- session.delete(ca);
- session.flush();
- session.getTransaction().commit();
- } catch (Exception e) {
- if (session.getTransaction().isActive())
- session.getTransaction().rollback();
- }
- return null;
- }
- });
+ @SuppressWarnings({"unchecked", "rawtypes"})
+ public void deleteCommonAd(final CommonAd ca) {
+ recommendAdDao.excute(new HibernateCallback() {
+ public Object doInHibernate(Session session) throws HibernateException {
+ try {
+ session.getTransaction().begin();
+ List<CommonAdPositionAd> list = session
+ .createQuery("from CommonAdPositionAd cp where cp.ad.id=" + ca.getId()).list();
+ for (CommonAdPositionAd cp : list) {
+ session.delete(cp);
+ }
+ session.delete(ca);
+ session.flush();
+ session.getTransaction().commit();
+ } catch (Exception e) {
+ if (session.getTransaction().isActive())
+ session.getTransaction().rollback();
+ }
+ return null;
+ }
+ });
- }
+ }
- public void deleteCommonAdPositionAd(CommonAdPositionAd ad) {
- commonAdPositionAdDao.delete(ad);
- }
+ public void deleteCommonAdPositionAd(CommonAdPositionAd ad) {
+ commonAdPositionAdDao.delete(ad);
+ }
- public void deleteCommonAdPositionAd(String adid, String pid) {
- List<CommonAdPositionAd> list = commonAdPositionAdDao
- .list("from CommonAdPositionAd ca where ca.ad.id=" + adid + " and ca.adPosition.id=" + pid);
- for (CommonAdPositionAd ca : list)
- deleteCommonAdPositionAd(ca);
- }
+ public void deleteCommonAdPositionAd(String adid, String pid) {
+ List<CommonAdPositionAd> list = commonAdPositionAdDao
+ .list("from CommonAdPositionAd ca where ca.ad.id=" + adid + " and ca.adPosition.id=" + pid);
+ for (CommonAdPositionAd ca : list)
+ deleteCommonAdPositionAd(ca);
+ }
}
--
Gitblit v1.8.0