地质所 沉降监测网建设项目
zmk
2024-10-23 3f47c88e7cb4e53b3637620794420181f47b5a5e
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
package com.javaweb.cms.service.impl;
 
import java.beans.Transient;
import java.util.Date;
import java.util.List;
 
import com.google.common.collect.Lists;
import com.javaweb.cms.domain.AdMaterial;
import com.javaweb.cms.domain.MaterialUse;
import com.javaweb.cms.mapper.MaterialMapper;
import com.javaweb.cms.util.CmsConstants;
import com.javaweb.common.utils.DateUtils;
import com.javaweb.framework.util.ShiroUtils;
import com.javaweb.system.domain.SysUser;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.javaweb.cms.mapper.AdMapper;
import com.javaweb.cms.domain.Ad;
import com.javaweb.cms.service.IAdService;
import com.javaweb.common.core.text.Convert;
import org.springframework.transaction.annotation.Transactional;
 
/**
 * 广告位Service业务层处理
 * 
 * @author wujiyue
 * @date 2019-11-16
 */
@Service
public class AdServiceImpl implements IAdService 
{
    @Autowired
    private AdMapper adMapper;
    @Autowired
    private MaterialMapper materialMapper;
 
    /**
     * 查询广告位
     * 
     * @param adId 广告位ID
     * @return 广告位
     */
    @Override
    public Ad selectAdById(Long adId)
    {
        return adMapper.selectAdById(adId);
    }
 
    /**
     * 查询广告位列表
     * 
     * @param ad 广告位
     * @return 广告位
     */
    @Override
    public List<Ad> selectAdList(Ad ad)
    {
        return adMapper.selectAdList(ad);
    }
 
    /**
     * 新增广告位
     * 
     * @param ad 广告位
     * @return 结果
     */
    @Override
    public int insertAd(Ad ad)
    {
        ad.setCreateTime(DateUtils.getNowDate());
        return adMapper.insertAd(ad);
    }
 
    /**
     * 修改广告位
     * 
     * @param ad 广告位
     * @return 结果
     */
    @Override
    public int updateAd(Ad ad)
    {
        ad.setUpdateTime(DateUtils.getNowDate());
        return adMapper.updateAd(ad);
    }
 
    /**
     * 删除广告位对象
     * 
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    @Override
    public int deleteAdByIds(String ids)
    {
        return adMapper.deleteAdByIds(Convert.toStrArray(ids));
    }
 
    /**
     * 删除广告位信息
     * 
     * @param adId 广告位ID
     * @return 结果
     */
    @Override
    public int deleteAdById(Long adId)
    {
        return adMapper.deleteAdById(adId);
    }
 
    /*****************************************分割线****************************************************/
 
    @Override
    public AdMaterial selectAdMaterialById(Long id) {
        return adMapper.selectAdMaterialById(id);
    }
 
    @Override
    public List<AdMaterial> selectAdMaterialList(AdMaterial adMaterial) {
        return adMapper.selectAdMaterialList(adMaterial);
    }
 
    @Override
    @Transactional
    public int insertAdMaterial(AdMaterial adMaterial) {
        //插入使用记录 cms_material_use
        MaterialUse use=new MaterialUse();
        SysUser user= ShiroUtils.getSysUser();
            use.setUseId(adMaterial.getAdId().toString());
            use.setMaterialId(adMaterial.getMaterialId());
            use.setUserId(user.getUserId().toString());
            use.setCreateBy(user.getUserName());
            use.setCreateTime(new Date());
            use.setUserId(user.getUserId().toString());
            use.setUseTable(CmsConstants.MATERIAL_USE_AD_TABLE_NAME);
            use.setUseColumn(CmsConstants.MATERIAL_USE_AD_COLUMN_NAME);
        materialMapper.insertMaterialUse(use);
        adMaterial.setUseHisId(Integer.valueOf(use.getId()));
        //更新素材使用状态
        materialMapper.updateMaterialUseState(adMaterial.getMaterialId(),CmsConstants.USE_STATE_YES);
        return adMapper.insertAdMaterial(adMaterial);
    }
 
    @Override
    public int updateAdMaterial(AdMaterial adMaterial) {
        return adMapper.updateAdMaterial(adMaterial);
    }
 
    @Override
    public int deleteAdMaterialByIds(String ids) {
        List<AdMaterial> list=adMapper.selectAdMaterialByIds(Convert.toStrArray(ids));
        List<String> idList=Lists.newArrayList();
        for(AdMaterial material:list){
            idList.add(String.valueOf(material.getUseHisId()));
        }
        String[] useIds=idList.toArray(new String[idList.size()]);
        materialMapper.deleteMaterialUseBatch(useIds);
        for(AdMaterial material:list){
            int n=materialMapper.selectCountMaterialUse(material.getMaterialId());
            if(n==0){
                materialMapper.updateMaterialUseState(material.getMaterialId(), CmsConstants.USE_STATE_NO);
            }
        }
        return adMapper.deleteAdMaterialByIds(Convert.toStrArray(ids));
    }
 
    @Override
    public List<AdMaterial> selectAdUnMaterialList(AdMaterial adMaterial) {
        return adMapper.selectAdUnMaterialList(adMaterial);
    }
}