class.js 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395
  1. 'use strict';
  2. const assert = require('assert');
  3. const _ = require('lodash');
  4. const { ObjectId } = require('mongoose').Types;
  5. const { CrudService } = require('naf-framework-mongoose/lib/service');
  6. const { BusinessError, ErrorCode } = require('naf-core').Error;
  7. class ClassService extends CrudService {
  8. constructor(ctx) {
  9. super(ctx, 'class');
  10. this.model = this.ctx.model.Class;
  11. this.stumodel = this.ctx.model.Student;
  12. this.lessmodel = this.ctx.model.Lesson;
  13. this.umodel = this.ctx.model.User;
  14. this.tmodel = this.ctx.model.Trainplan;
  15. this.gmodel = this.ctx.model.Group;
  16. this.heamodel = this.ctx.model.Headteacher;
  17. this.teamodel = this.ctx.model.Teacher;
  18. this.locamodel = this.ctx.model.Location;
  19. }
  20. async divide(data) {
  21. const { planid, termid } = data;
  22. assert(planid, '计划id为必填项');
  23. assert(termid, '期id为必填项');
  24. // 先自动生成班级
  25. await this.autoclass(planid, termid);
  26. // 根据计划id与期id查询所有批次下的班级
  27. const newclass = await this.model.find({ planid, termid });
  28. if (!newclass) {
  29. throw new BusinessError(ErrorCode.DATA_NOT_EXIST, '班级信息不存在');
  30. }
  31. // 根据计划和期查询所有上报的学生 并按照学校排序
  32. const newstudent = await this.stumodel.find({ termid }).sort({ schid: 1 });
  33. if (!newstudent) {
  34. throw new BusinessError(ErrorCode.DATA_NOT_EXIST, '学生信息不存在');
  35. }
  36. let _students = _.map(newstudent, 'id');
  37. for (const _class of newclass) {
  38. // 取得班级人数
  39. const stunum = _class.number;
  40. // 取出相同类型的学生
  41. const studentids = await this.getstutype(_students, _class.type);
  42. // 取出班级人数下的学生id
  43. const beforestu = _.take(studentids, stunum);
  44. // 将取出的数据调用更新学生的班级信息方法
  45. await this.studentup(_class.id, _class.batchid, beforestu);
  46. // 将班级自动分为组
  47. await this.groupcreate(termid, _class.batchid, _class.id);
  48. // 取出的学生数据从原数据中删除
  49. _students = _.difference(_students, beforestu);
  50. }
  51. // 判断学生是否有剩余
  52. const stulen_ = _students.length;
  53. if (stulen_ > 0) {
  54. // 判断共有多少班级
  55. // 判断学生数与班级数,当小于或等于班级数 将班级直接分配给学生
  56. const classlength = newclass.length;
  57. // 循环取得学生id并分配班级
  58. let cindex_ = 0;
  59. for (const stuid of _students) {
  60. const student = await this.stumodel.findById(stuid);
  61. if (student) {
  62. const cla_ = newclass[cindex_];
  63. student.classid = cla_.classid;
  64. student.batchid = cla_.batchid;
  65. await student.save();
  66. cindex_ = cindex_ + 1;
  67. if (cindex_ === classlength - 1) {
  68. cindex_ = 0;
  69. }
  70. }
  71. }
  72. }
  73. }
  74. // 取得同样类型的学生
  75. async getstutype(_students, type) {
  76. const data = [];
  77. for (const stuid of _students) {
  78. const student = await this.stumodel.findById(stuid);
  79. if (student && student.type === type) {
  80. data.push(stuid);
  81. }
  82. }
  83. return data;
  84. }
  85. // 自动生成班级私有方法
  86. async autoclass(planid, termid) {
  87. // 删除所有计划下的班级
  88. await this.model.deleteMany({ planid, termid });
  89. // 根据批次id取得当前批次具体信息
  90. const res = await this.tmodel.findById(planid);
  91. if (!res) {
  92. throw new BusinessError(ErrorCode.DATA_NOT_EXIST, '全年计划信息不存在');
  93. }
  94. // 循环出所有班级进行添加操作
  95. const term = await res.termnum.id(termid);
  96. let yclocationid = ''; // 用餐地点
  97. let kzjhlocationid = ''; // 拓展计划地点
  98. let kbyslocationid = ''; // 开班仪式地点
  99. let jslocationid = ''; // 教室位置
  100. const locations = await this.locamodel.find();
  101. const jslocationids = _.filter(locations, { type: '0' });
  102. const kbyslocationids = _.filter(locations, { type: '1' });
  103. const kzjhlocationids = _.filter(locations, { type: '2' });
  104. const yclocationids = _.filter(locations, { type: '3' });
  105. for (const batch of term.batchnum) {
  106. const classs = await batch.class;
  107. for (const cla of classs) {
  108. // 取得班级各个地点
  109. // 同一地点同期只能使用一次
  110. if (jslocationids.length > 0) {
  111. jslocationid = jslocationids[0].id;
  112. _.remove(jslocationids, { id: jslocationid });
  113. }
  114. if (kbyslocationids.length > 0) {
  115. kbyslocationid = kbyslocationids[0].id;
  116. _.remove(kbyslocationids, { id: kbyslocationid });
  117. }
  118. if (kzjhlocationids.length > 0) {
  119. kzjhlocationid = kzjhlocationids[0].id;
  120. _.remove(kzjhlocationids, { id: kzjhlocationid });
  121. }
  122. if (yclocationids.length > 0) {
  123. yclocationid = yclocationids[0].id;
  124. _.remove(yclocationids, { id: yclocationid });
  125. }
  126. const newdata = { name: cla.name, number: cla.number, batchid: batch.id, termid: term.id, planid: res.id, type: cla.type, headteacherid: cla.headteacherid, jslocationid, kbyslocationid, kzjhlocationid, yclocationid };
  127. await this.model.create(newdata);
  128. }
  129. }
  130. }
  131. // 根据传入的学生列表和班级id更新学生信息
  132. async studentup(classid, batchid, beforestu) {
  133. // 循环学生id
  134. for (const stuid of beforestu) {
  135. const student = await this.stumodel.findById(stuid);
  136. if (student) {
  137. student.classid = classid;
  138. student.batchid = batchid;
  139. await student.save();
  140. }
  141. }
  142. }
  143. // 自动分组
  144. async groupcreate(termid, batchid, classid) {
  145. const group = await this.gmodel.find({ termid, batchid, classid });
  146. if (group.length === 0) {
  147. for (let i = 1; i < 8; i++) {
  148. const name = i + '组';
  149. const newdata = { name, termid, batchid, classid };
  150. await this.gmodel.create(newdata);
  151. }
  152. }
  153. }
  154. // 根据传入的学生列表和班级id更新学生信息
  155. async studentupclass({ id }, data) {
  156. assert(id, '班级id为必填项');
  157. // 根据全年计划表id查出对应的全年计划详细信息
  158. const trainplan = await this.tmodel.findOne({ 'termnum.batchnum.class._id': ObjectId(id) });
  159. if (!trainplan) {
  160. throw new BusinessError(ErrorCode.DATA_NOT_EXIST, '全年计划信息不存在');
  161. }
  162. // 取得计划期批次信息
  163. let termid = '';
  164. let batchid = '';
  165. let classname = '';
  166. let class_ = {};
  167. for (const term of trainplan.termnum) {
  168. for (const batch of term.batchnum) {
  169. const _class = await batch.class.id(id);
  170. if (_class) {
  171. termid = term.id;
  172. batchid = batch.id;
  173. classname = _class.name;
  174. class_ = _class;
  175. break;
  176. }
  177. }
  178. }
  179. if (!class_) {
  180. throw new BusinessError(ErrorCode.DATA_NOT_EXIST, '班级信息不存在');
  181. }
  182. let classid_ = '';
  183. if (classname) {
  184. const cla_ = await this.model.findOne({ termid, batchid, name: classname });
  185. if (cla_) {
  186. classid_ = cla_.id;
  187. } else {
  188. const newdata = {
  189. name: class_.name,
  190. number: class_.number,
  191. batchid,
  192. termid,
  193. planid: trainplan.id,
  194. type: class_.type,
  195. };
  196. const rescla = await this.model.create(newdata);
  197. if (rescla) {
  198. classid_ = rescla.id;
  199. }
  200. }
  201. }
  202. if (classid_) {
  203. // 循环学生id
  204. for (const stuid of data) {
  205. const student = await this.stumodel.findById(stuid);
  206. if (student) {
  207. student.classid = classid_;
  208. await student.save();
  209. }
  210. }
  211. }
  212. }
  213. async notice(data) {
  214. for (const classid of data.classids) {
  215. // 根据班级id找到需要通知的班级
  216. const _class = await this.model.findById(classid);
  217. const { headteacherid } = _class;
  218. // 根据班级id找到对应的课程表
  219. const lesson = await this.lessmodel.findOne({ classid });
  220. if (lesson) {
  221. const lessons = lesson.lessons;
  222. const remark = '感谢您的使用';
  223. const date = await this.ctx.service.util.updatedate();
  224. const detail = '班级各项信息已确认,请注意查收';
  225. // 遍历班级授课教师发送通知
  226. for (const lessoninfo of lessons) {
  227. const teaid = lessoninfo.teaid;
  228. const _teacher = await this.umodel.findOne({ uid: teaid, type: '3' });
  229. if (_teacher) {
  230. const teaopenid = _teacher.openid;
  231. this.ctx.service.weixin.sendTemplateMsg(this.ctx.app.config.REVIEW_TEMPLATE_ID, teaopenid, '您有一个新的通知', detail, date, remark, classid);
  232. }
  233. }
  234. // 给班主任发送通知
  235. const _headteacher = await this.umodel.findOne({ uid: headteacherid, type: '1' });
  236. if (_headteacher) {
  237. const headteaopenid = _headteacher.openid;
  238. this.ctx.service.weixin.sendTemplateMsg(this.ctx.app.config.REVIEW_TEMPLATE_ID, headteaopenid, '您有一个新的通知', detail, date, remark, classid);
  239. }
  240. // 根据班级的期id查询对应的培训计划
  241. const trainplan = await this.tmodel.findOne({ 'termnum._id': _class.termid });
  242. const term = await trainplan.termnum.id(_class.termid);
  243. const batch = await term.batchnum.id(_class.batchid);
  244. const startdate = batch.startdate;
  245. const classname = _class.name;
  246. // 给班级所有学生发送邮件通知
  247. const students = await this.stumodel.find({ classid });
  248. for (const student of students) {
  249. const { email, name } = student;
  250. const subject = '吉林省高等学校毕业生就业指导中心通知';
  251. const text = name + '您好!\n欢迎参加由吉林省高等学校毕业生就业指导中心举办的“双困生培训会”。\n您所在的班级为:' + classname + '\n班级开课时间为:' + startdate;
  252. this.ctx.service.util.sendMail(email, subject, text);
  253. }
  254. }
  255. }
  256. }
  257. async uptea(data) {
  258. for (const _data of data) {
  259. const classInfo = await this.model.findById(_data.id);
  260. classInfo.headteacherid = _data.headteacherid;
  261. await classInfo.save();
  262. }
  263. }
  264. async query({ skip, limit, ...info }) {
  265. const classes = await this.model.find(info).skip(Number(skip)).limit(Number(limit));
  266. const data = [];
  267. for (const _class of classes) {
  268. const classInfo = await this.fetch({ id: _class.id });
  269. data.push(classInfo);
  270. }
  271. return data;
  272. }
  273. async fetch({ id }) {
  274. const classInfo = _.cloneDeep(JSON.parse(JSON.stringify(await this.model.findById(id))));
  275. const trainplan = await this.tmodel.findById(classInfo.planid);
  276. if (trainplan) {
  277. const term = _.filter(trainplan.termnum, item => item.id === classInfo.termid);
  278. if (term.length > 0) {
  279. classInfo.term = term[0].term;
  280. const batch = _.filter(term[0].batchnum, item => item.id === classInfo.batchid);
  281. if (batch.length > 0) {
  282. classInfo.batch = batch[0].batch;
  283. classInfo.startdate = batch[0].startdate;
  284. classInfo.enddate = batch[0].enddate;
  285. }
  286. }
  287. }
  288. if (classInfo.yclocationid) {
  289. classInfo.yclocation = (await this.locamodel.findById(classInfo.yclocationid)).name;
  290. }
  291. if (classInfo.kzjhlocationid) {
  292. classInfo.kzjhlocation = (await this.locamodel.findById(classInfo.kzjhlocationid)).name;
  293. }
  294. if (classInfo.kbyslocationid) {
  295. classInfo.kbyslocation = (await this.locamodel.findById(classInfo.kbyslocationid)).name;
  296. }
  297. if (classInfo.jslocationid) {
  298. classInfo.jslocation = (await this.locamodel.findById(classInfo.jslocationid)).name;
  299. }
  300. if (classInfo.headteacherid) {
  301. classInfo.headteacher = (await this.heamodel.findById(classInfo.headteacherid)).name;
  302. }
  303. if (classInfo.lyteacherid) {
  304. let res = await this.teamodel.findById(classInfo.lyteacherid);
  305. if (!res) res = await this.heamodel.findById(classInfo.lyteacherid);
  306. if (res)classInfo.lyteacher = res.name;
  307. }
  308. return classInfo;
  309. }
  310. async upclasses(data) {
  311. for (const _data of data) {
  312. await this.model.findByIdAndUpdate(_data.id, _data);
  313. }
  314. }
  315. async classinfo({ id: classid }) {
  316. const _classes = await this.model.findById(classid);
  317. // 班级信息
  318. const classes = _.cloneDeep(JSON.parse(JSON.stringify(_classes)));
  319. // 学生信息
  320. const students = await this.stumodel.find({ classid });
  321. // 所有用户信息
  322. const users = await this.umodel.find();
  323. if (students) {
  324. for (const stu of students) {
  325. const user = users.find(item => item.uid === stu.id);
  326. if (user && user.openid) {
  327. const _stu = _.cloneDeep(JSON.parse(JSON.stringify(stu)));
  328. _stu.hasuserinfo = '1';
  329. _.remove(students, stu);
  330. students.push(_stu);
  331. }
  332. }
  333. classes.students = students;
  334. }
  335. // 班主任信息
  336. let headteacher;
  337. if (classes.headteacherid) {
  338. headteacher = await this.heamodel.findById(classes.headteacherid);
  339. }
  340. // 礼仪课老师信息
  341. let lyteacher;
  342. if (classes.lyteacherid) {
  343. lyteacher = await this.heamodel.findById(classes.lyteacherid);
  344. if (!lyteacher) {
  345. lyteacher = await this.teamodel.findById(classes.lyteacherid);
  346. }
  347. }
  348. // 教课老师信息
  349. let teachers = [];
  350. const lessones = await this.lessmodel.findOne({ classid });
  351. if (lessones) {
  352. for (const lesson of lessones.lessons) {
  353. if (lesson.teaid) {
  354. const teacher = await this.teamodel.findById(lesson.teaid);
  355. teachers.push(teacher);
  356. }
  357. }
  358. }
  359. teachers.push(lyteacher);
  360. teachers.push(headteacher);
  361. teachers = _.uniq(_.compact(teachers));
  362. for (const tea of teachers) {
  363. const user = users.find(item => item.uid === tea.id);
  364. console.log(user);
  365. if (user && user.openid) {
  366. const _tea = _.cloneDeep(JSON.parse(JSON.stringify(tea)));
  367. _tea.hasuserinfo = '1';
  368. _.remove(teachers, tea);
  369. teachers.push(_tea);
  370. }
  371. }
  372. classes.teachers = teachers;
  373. return classes;
  374. }
  375. }
  376. module.exports = ClassService;