处理编码

EricsHu

2022-12-05 068fc7f2e81178e55fa191a13709af64b1a163f6

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
package com.qxueyou.scc.admin.classroom.service.impl;
 
import java.util.List;
import java.util.Map;
 
import org.springframework.stereotype.Service;
 
import com.qxueyou.scc.admin.classroom.model.ClassRoom;
import com.qxueyou.scc.admin.classroom.service.IClassRoomService;
import com.qxueyou.scc.base.model.Pager;
import com.qxueyou.scc.base.model.Result;
import com.qxueyou.scc.base.service.impl.CommonAppService;
import com.qxueyou.scc.base.util.ClientUtils;
import com.qxueyou.scc.base.util.CollectionUtils;
import com.qxueyou.scc.base.util.TraceUtils;
import com.qxueyou.scc.exam.model.ExamInfo;
 
@Service
public class ClassRoomService extends CommonAppService implements IClassRoomService {
 
    @Override
    public String add(ClassRoom classRoom) {
        TraceUtils.setCreateTrace(classRoom);
        classRoom.setStatus(ClassRoom.STATUS_PUBLISH);
        this.insert(classRoom);
        return classRoom.getRoomId();
    }
 
    @Override
    public Result update(ClassRoom classRoom) {
        ClassRoom newClassRoom = read(ClassRoom.class, classRoom.getRoomId());
 
        if (newClassRoom == null) {
            return new Result(false, "教室不存在");
        }
 
        TraceUtils.setUpdateTrace(newClassRoom);
        newClassRoom.setName(classRoom.getName());
        newClassRoom.setAddress(classRoom.getAddress());
        return save(newClassRoom);
    }
 
    @Override
    public Result delete(String[] roomIds) {
        Result result = new Result(true);
        if (roomIds != null && roomIds.length > 0) {
            String hql = "update ClassRoom set deleteFlag = true where roomId=?";
            result = bulkUpdateInLoop(hql, roomIds);
        }
        return result;
    }
 
    @Override
    public Result doRelease(String[] roomIds) {
        if(roomIds==null || roomIds.length==0){
            return new Result(false, "没有选择要发布的教室");
        }
        
        List<ClassRoom> lstClsRoom = this.findByComplexHql("from ClassRoom where roomId in (:roomIds)", 
                                        CollectionUtils.newObjectMap("roomIds",roomIds), ClassRoom.class);
 
        for (ClassRoom room : lstClsRoom) {
            if (ExamInfo.STATUS_DRAFT != room.getStatus()) {
                return new Result(false, "只有草稿状态的教室,才能发布。");
            }
            room.setStatus(ClassRoom.STATUS_PUBLISH);
            TraceUtils.setUpdateTrace(room);
            save(room);
        }
        
        return new Result(true);
    }
 
    @Override
    public Result doCancel(String[] roomIds) {
        if(roomIds==null || roomIds.length==0){
            return new Result(false, "没有选择要撤回的教室");
        }
        
        List<ClassRoom> lstClsRoom = this.findByComplexHql("from ClassRoom where roomId in (:roomIds)", 
                                            CollectionUtils.newObjectMap("roomIds",roomIds), ClassRoom.class);
        
        for (ClassRoom room : lstClsRoom) {
            if (ExamInfo.STATUS_PUBLISH != room.getStatus()) {
                return new Result(false, "只有发布状态的 教室,才能撤回");
            }
            room.setStatus(ExamInfo.STATUS_DRAFT);
            TraceUtils.setUpdateTrace(room);
            save(room);
        }
        return new Result(true);
    }
 
    @Override
    public List<ClassRoom> list(String keyword, Short status, Integer pageSize, Integer pageNum) {
        StringBuffer hql = new StringBuffer(500);
        hql.append(" from ClassRoom where name like ? and createId=? ");
        List<Object> params = CollectionUtils.newList('%' + keyword.trim() + '%',ClientUtils.getUserId());
        
        if(status!=null){
            hql.append(" and status = ? ");
            params.add(status);
        }
        
        hql.append(" and deleteFlag is false order by createTime desc");
        
        return findList(hql.toString(),new Pager(pageSize, pageNum),params, ClassRoom.class);
    }
 
    @Override
    public int listCount(String keyword, Short status) {
        StringBuffer hql = new StringBuffer(500);
        hql.append(" from ClassRoom where name like ? and createId=? ");
        List<Object> params = CollectionUtils.newList('%' + keyword.trim() + '%',ClientUtils.getUserId());
        
        if(status!=null){
            hql.append(" and status = ? ");
            params.add(status);
        }
        
        hql.append(" and deleteFlag is false ");
        
        return findCount(hql.toString(),params);
        
        
    }
 
    @Override
    public ClassRoom detail(String roomId) {
        return this.read(ClassRoom.class,roomId);
    }
    
    @Override
    public List<Map<String,Object>> queryAllRoomIdAndNames(){
        StringBuffer hql = new StringBuffer(500);
        hql.append("select roomId as roomId,name as roomName,address as address from ClassRoom where  status = :status and deleteFlag is false ");
        
        return  this.findListWithMapByHql(hql.toString(), CollectionUtils.newObjectMap("status",ClassRoom.STATUS_PUBLISH));
    }
    
 
}