视频详情页中的广告显示策略

admin

2021-04-02 d551bef5e2b09bd98681cf97807988c9863e66fc

 src/main/java/com/yeshi/buwan/service/imp/ClassService.java

@@ -6,7 +6,7 @@

import javax.annotation.Resource;

import com.yeshi.buwan.service.inter.VideoResourceMapExtraInfoService;
import com.yeshi.buwan.service.inter.video.VideoInfoExtraService;
import org.hibernate.CacheMode;
import org.hibernate.HibernateException;
import org.hibernate.Session;
@@ -18,7 +18,7 @@
import com.yeshi.buwan.dao.VideoInfoDao;
import com.yeshi.buwan.dao.VideoTypeDao;
import com.yeshi.buwan.domain.CategoryVideo;
import com.yeshi.buwan.domain.DetailSystem;
import com.yeshi.buwan.domain.system.DetailSystem;
import com.yeshi.buwan.domain.SuperHotType;
import com.yeshi.buwan.domain.SuperVideoType;
import com.yeshi.buwan.domain.VideoInfo;
@@ -36,8 +36,9 @@
    private VideoInfoDao videoInfoDao;
    @Resource
    private SuperVideoTypeDao superVideoTypeDao;

    @Resource
    private VideoResourceMapExtraInfoService videoResourceMapExtraInfoService;
    private VideoInfoExtraService videoInfoExtraService;

    public List<VideoType> getTypeList() {
        List<VideoType> list = videoTypeDao.list("from VideoType v where v.show='1' and v.parent=null");
@@ -234,10 +235,10 @@
        if (StringUtil.isNullOrEmpty(type)) {
            return getVideoInfoData(videoInfoDao.sqlList(
                    "select v.id,v.`name`,v.`tag`,v.`picture`,v.`hpicture`,v.`latest_hpicture`,v.watchcount,v.commentcount from wk_video_video v INNER JOIN  (SELECT  DISTINCT(v.id) FROM wk_category_video ca LEFT JOIN wk_video_video v ON v.id= ca.videoid LEFT JOIN wk_resource_video rv ON rv.`videoid`= v.`id`  AND( ? ) WHERE v.show= 1 and ca.id is not null AND rv.`resourceid` IS NOT NULL ? ) a using(id)",
                    (page - 1) * pageCount, pageCount, new Serializable[]{resourceWhere, orderby,}),resourceList);
                    (page - 1) * pageCount, pageCount, new Serializable[]{resourceWhere, orderby,}), resourceList);
        }

        List<VideoInfo> list = new ArrayList<VideoInfo>();
        List<VideoInfo> list = new ArrayList<>();

        long startTime = System.currentTimeMillis();

@@ -246,7 +247,7 @@
        final String orderbyNew = orderby;
        list = (List<VideoInfo>) videoTypeDao.excute(new HibernateCallback() {
            public Object doInHibernate(Session session) throws HibernateException {
                List<VideoInfo> list = new ArrayList<VideoInfo>();
                List<VideoInfo> list = new ArrayList<>();
                try {
                    session.setCacheMode(CacheMode.GET);
                    String sql = String.format(
@@ -264,11 +265,11 @@
        });

        System.out.println("查询SQL费时:" + (System.currentTimeMillis() - startTime));
        return getVideoInfoData(list,resourceList);
        return getVideoInfoData(list, resourceList);
    }

    public List<VideoInfo> getVideoInfoData(List list, List<Long> resourceIdList) {
        List<VideoInfo> dataList = new ArrayList<VideoInfo>();
        List<VideoInfo> dataList = new ArrayList<>();
        for (int i = 0; i < list.size(); i++) {
            Object[] obj = (Object[]) list.get(i);
            VideoInfo info = new VideoInfo();
@@ -279,10 +280,10 @@
            info.setHpicture(obj[4] + "");
            info.setLatestHpicture(obj[5] + "");
            info.setWatchCount(obj[6] + "");
            info.setCommentCount(Integer.parseInt(obj[7] + ""));
            info.setCommentCount(obj[7]!=null? Integer.parseInt(obj[7] + ""):0);
            if (obj.length > 8) {
                String[] resourceIds = (obj[8] + "").split(",");
                List<VideoResource> resourceList = new ArrayList<VideoResource>();
                List<VideoResource> resourceList = new ArrayList<>();
                for (String rid : resourceIds)
                    resourceList.add(new VideoResource(rid));
                info.setResourceList(resourceList);
@@ -293,7 +294,7 @@
            dataList.add(info);
        }

        dataList = videoResourceMapExtraInfoService.batchExtraInfo(dataList, resourceIdList);
        dataList = videoInfoExtraService.batchExtra(dataList, resourceIdList);

        return dataList;
    }
@@ -355,14 +356,14 @@

        if (wheres.startsWith("or"))
            wheres = wheres.substring(2, wheres.length());
        List<VideoInfo> list = new ArrayList<VideoInfo>();
        List<VideoInfo> list = new ArrayList<>();

        final String wheresNew = wheres;
        final String yearWhereNew = yearWhere;
        final String orderbyNew = orderby;
        list = (List<VideoInfo>) videoTypeDao.excute(new HibernateCallback<List<VideoInfo>>() {
            public List<VideoInfo> doInHibernate(Session session) throws HibernateException {
                List<VideoInfo> list = new ArrayList<VideoInfo>();
                List<VideoInfo> list = new ArrayList<>();
                try {
                    list = session
                            .createSQLQuery(
@@ -381,7 +382,7 @@
    }

    private List<VideoInfo> parseVideoListAmin(List list) {
        List<VideoInfo> resultList = new ArrayList<VideoInfo>();
        List<VideoInfo> resultList = new ArrayList<>();
        for (int i = 0; i < list.size(); i++) {
            Object[] objs = (Object[]) list.get(i);
            VideoInfo video = new VideoInfo();
@@ -579,15 +580,15 @@
     */

    @SuppressWarnings("unchecked")
    public List<com.yeshi.buwan.domain.web.VideoTypeAdmin> getVideoTypeAdmin(final int detailSystem, final int pid,
    public List<com.yeshi.buwan.domain.web.VideoTypeAdmin> getVideoTypeAdmin(final String systemId, final int detailSystem, final int pid,
                                                                             final int page) {
        return (List<com.yeshi.buwan.domain.web.VideoTypeAdmin>) videoTypeDao
                .excute(new HibernateCallback<List<com.yeshi.buwan.domain.web.VideoTypeAdmin>>() {
                    public List<com.yeshi.buwan.domain.web.VideoTypeAdmin> doInHibernate(Session session)
                            throws HibernateException {
                        List<com.yeshi.buwan.domain.web.VideoTypeAdmin> hotTypeList = new ArrayList<com.yeshi.buwan.domain.web.VideoTypeAdmin>();
                        List<com.yeshi.buwan.domain.web.VideoTypeAdmin> hotTypeList = new ArrayList<>();
                        try {
                            List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem").list();
                            List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem ds where ds.system.id=" + systemId).list();
                            String where = "";

                            List<VideoType> list = null;
@@ -627,7 +628,7 @@
                                        .createQuery("select vb.detailSystem from SuperVideoType vb where vb.type.id=?")
                                        .setParameter(0, vb.getId()).list();

                                List<DetailSystemSelect> dssList = new ArrayList<DetailSystemSelect>();
                                List<DetailSystemSelect> dssList = new ArrayList<>();

                                for (DetailSystem ds : detailSystemList) {
                                    DetailSystemSelect dss = new DetailSystemSelect();