class.js 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401
  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. console.group('id');
  158. console.log(id);
  159. console.groupEnd();
  160. // 根据全年计划表id查出对应的全年计划详细信息
  161. const trainplan = await this.tmodel.findOne({ 'termnum.batchnum.class._id': ObjectId(id) });
  162. console.group('trainPlan');
  163. console.log(trainplan);
  164. console.groupEnd();
  165. if (!trainplan) {
  166. throw new BusinessError(ErrorCode.DATA_NOT_EXIST, '全年计划信息不存在');
  167. }
  168. // 取得计划期批次信息
  169. let termid = '';
  170. let batchid = '';
  171. let classname = '';
  172. let class_ = {};
  173. for (const term of trainplan.termnum) {
  174. for (const batch of term.batchnum) {
  175. const _class = await batch.class.id(id);
  176. if (_class) {
  177. termid = term.id;
  178. batchid = batch.id;
  179. classname = _class.name;
  180. class_ = _class;
  181. break;
  182. }
  183. }
  184. }
  185. if (!class_) {
  186. throw new BusinessError(ErrorCode.DATA_NOT_EXIST, '班级信息不存在');
  187. }
  188. let classid_ = '';
  189. if (classname) {
  190. const cla_ = await this.model.findOne({ termid, batchid, name: classname });
  191. if (cla_) {
  192. classid_ = cla_.id;
  193. } else {
  194. const newdata = {
  195. name: class_.name,
  196. number: class_.number,
  197. batchid,
  198. termid,
  199. planid: trainplan.id,
  200. type: class_.type,
  201. };
  202. const rescla = await this.model.create(newdata);
  203. if (rescla) {
  204. classid_ = rescla.id;
  205. }
  206. }
  207. }
  208. if (classid_) {
  209. // 循环学生id
  210. for (const stuid of data) {
  211. const student = await this.stumodel.findById(stuid);
  212. if (student) {
  213. student.classid = classid_;
  214. await student.save();
  215. }
  216. }
  217. }
  218. }
  219. async notice(data) {
  220. for (const classid of data.classids) {
  221. // 根据班级id找到需要通知的班级
  222. const _class = await this.model.findById(classid);
  223. const { headteacherid } = _class;
  224. // 根据班级id找到对应的课程表
  225. const lesson = await this.lessmodel.findOne({ classid });
  226. if (lesson) {
  227. const lessons = lesson.lessons;
  228. const remark = '感谢您的使用';
  229. const date = await this.ctx.service.util.updatedate();
  230. const detail = '班级各项信息已确认,请注意查收';
  231. // 遍历班级授课教师发送通知
  232. for (const lessoninfo of lessons) {
  233. const teaid = lessoninfo.teaid;
  234. const _teacher = await this.umodel.findOne({ uid: teaid, type: '3' });
  235. if (_teacher) {
  236. const teaopenid = _teacher.openid;
  237. this.ctx.service.weixin.sendTemplateMsg(this.ctx.app.config.REVIEW_TEMPLATE_ID, teaopenid, '您有一个新的通知', detail, date, remark, classid);
  238. }
  239. }
  240. // 给班主任发送通知
  241. const _headteacher = await this.umodel.findOne({ uid: headteacherid, type: '1' });
  242. if (_headteacher) {
  243. const headteaopenid = _headteacher.openid;
  244. this.ctx.service.weixin.sendTemplateMsg(this.ctx.app.config.REVIEW_TEMPLATE_ID, headteaopenid, '您有一个新的通知', detail, date, remark, classid);
  245. }
  246. // 根据班级的期id查询对应的培训计划
  247. const trainplan = await this.tmodel.findOne({ 'termnum._id': _class.termid });
  248. const term = await trainplan.termnum.id(_class.termid);
  249. const batch = await term.batchnum.id(_class.batchid);
  250. const startdate = batch.startdate;
  251. const classname = _class.name;
  252. // 给班级所有学生发送邮件通知
  253. const students = await this.stumodel.find({ classid });
  254. for (const student of students) {
  255. const { email, name } = student;
  256. const subject = '吉林省高等学校毕业生就业指导中心通知';
  257. const text = name + '您好!\n欢迎参加由吉林省高等学校毕业生就业指导中心举办的“双困生培训会”。\n您所在的班级为:' + classname + '\n班级开课时间为:' + startdate;
  258. this.ctx.service.util.sendMail(email, subject, text);
  259. }
  260. }
  261. }
  262. }
  263. async uptea(data) {
  264. for (const _data of data) {
  265. const classInfo = await this.model.findById(_data.id);
  266. classInfo.headteacherid = _data.headteacherid;
  267. await classInfo.save();
  268. }
  269. }
  270. async query({ skip, limit, ...info }) {
  271. const classes = await this.model.find(info).skip(Number(skip)).limit(Number(limit));
  272. const data = [];
  273. for (const _class of classes) {
  274. const classInfo = await this.fetch({ id: _class.id });
  275. data.push(classInfo);
  276. }
  277. return data;
  278. }
  279. async fetch({ id }) {
  280. const classInfo = _.cloneDeep(JSON.parse(JSON.stringify(await this.model.findById(id))));
  281. const trainplan = await this.tmodel.findById(classInfo.planid);
  282. if (trainplan) {
  283. const term = _.filter(trainplan.termnum, item => item.id === classInfo.termid);
  284. if (term.length > 0) {
  285. classInfo.term = term[0].term;
  286. const batch = _.filter(term[0].batchnum, item => item.id === classInfo.batchid);
  287. if (batch.length > 0) {
  288. classInfo.batch = batch[0].batch;
  289. classInfo.startdate = batch[0].startdate;
  290. classInfo.enddate = batch[0].enddate;
  291. }
  292. }
  293. }
  294. if (classInfo.yclocationid) {
  295. classInfo.yclocation = (await this.locamodel.findById(classInfo.yclocationid)).name;
  296. }
  297. if (classInfo.kzjhlocationid) {
  298. classInfo.kzjhlocation = (await this.locamodel.findById(classInfo.kzjhlocationid)).name;
  299. }
  300. if (classInfo.kbyslocationid) {
  301. classInfo.kbyslocation = (await this.locamodel.findById(classInfo.kbyslocationid)).name;
  302. }
  303. if (classInfo.jslocationid) {
  304. classInfo.jslocation = (await this.locamodel.findById(classInfo.jslocationid)).name;
  305. }
  306. if (classInfo.headteacherid) {
  307. classInfo.headteacher = (await this.heamodel.findById(classInfo.headteacherid)).name;
  308. }
  309. if (classInfo.lyteacherid) {
  310. let res = await this.teamodel.findById(classInfo.lyteacherid);
  311. if (!res) res = await this.heamodel.findById(classInfo.lyteacherid);
  312. if (res)classInfo.lyteacher = res.name;
  313. }
  314. return classInfo;
  315. }
  316. async upclasses(data) {
  317. for (const _data of data) {
  318. await this.model.findByIdAndUpdate(_data.id, _data);
  319. }
  320. }
  321. async classinfo({ id: classid }) {
  322. const _classes = await this.model.findById(classid);
  323. // 班级信息
  324. const classes = _.cloneDeep(JSON.parse(JSON.stringify(_classes)));
  325. // 学生信息
  326. const students = await this.stumodel.find({ classid });
  327. // 所有用户信息
  328. const users = await this.umodel.find();
  329. if (students) {
  330. for (const stu of students) {
  331. const user = users.find(item => item.uid === stu.id);
  332. if (user && user.openid) {
  333. const _stu = _.cloneDeep(JSON.parse(JSON.stringify(stu)));
  334. _stu.hasuserinfo = '1';
  335. _.remove(students, stu);
  336. students.push(_stu);
  337. }
  338. }
  339. classes.students = students;
  340. }
  341. // 班主任信息
  342. let headteacher;
  343. if (classes.headteacherid) {
  344. headteacher = await this.heamodel.findById(classes.headteacherid);
  345. }
  346. // 礼仪课老师信息
  347. let lyteacher;
  348. if (classes.lyteacherid) {
  349. lyteacher = await this.heamodel.findById(classes.lyteacherid);
  350. if (!lyteacher) {
  351. lyteacher = await this.teamodel.findById(classes.lyteacherid);
  352. }
  353. }
  354. // 教课老师信息
  355. let teachers = [];
  356. const lessones = await this.lessmodel.findOne({ classid });
  357. if (lessones) {
  358. for (const lesson of lessones.lessons) {
  359. if (lesson.teaid) {
  360. const teacher = await this.teamodel.findById(lesson.teaid);
  361. teachers.push(teacher);
  362. }
  363. }
  364. }
  365. teachers.push(lyteacher);
  366. teachers.push(headteacher);
  367. teachers = _.uniq(_.compact(teachers));
  368. for (const tea of teachers) {
  369. const user = users.find(item => item.uid === tea.id);
  370. console.log(user);
  371. if (user && user.openid) {
  372. const _tea = _.cloneDeep(JSON.parse(JSON.stringify(tea)));
  373. _tea.hasuserinfo = '1';
  374. _.remove(teachers, tea);
  375. teachers.push(_tea);
  376. }
  377. }
  378. classes.teachers = teachers;
  379. return classes;
  380. }
  381. }
  382. module.exports = ClassService;