2021-08-03

• 迁移
• 分委会
• 导入模板
• Bug天津中医药大学
  
  
  oracle
  group by clob
  group by to_char(clob)

使用Promise进行错误处理
https://zh.javascript.info/promise-error-handling

重名

工作流审核状态disabled

log4j:WARN No appenders could be found for logger (com.alibaba.dubbo.common.logger.LoggerFactory).
https://blog.csdn.net/qq_42449963/article/details/105230684

Promise API 5个静态方法
https://zh.javascript.info/promise-api

UI bug

bug：半天内解决，拒绝需求
我也不明，只能挨个注释条件看看哪里的问题了：有效

数据库文档工具：screw

开发版本文档 to test

https://www.cnblogs.com/iyangyuan/p/3491215.html

学一手bug分类术

为啥子order by之后就报错：ora01427单行子查询返回多个行

修改孙溢遗留bug归档

ORA-22922: 不存在的 LOB 值解决办法
https://blog.csdn.net/yb464855952/article/details/77869183

oracle行转列wm_concat()
https://www.cnblogs.com/yujin595/p/9829821.html

版本差异
成都理工研究生项目，可能有点大问题，oracle，本科教务用的是12c，而研究生还是11g，现场共用一套数据库

java Random.nextInt()方法
https://www.cnblogs.com/mr-wuxiansheng/p/6891693.html

elementUI table组件获取表格当前行的索引
https://blog.csdn.net/qq_39759115/article/details/82287352

element UI 在table中获取点击当前行、列索引
https://blog.csdn.net/Linzsong/article/details/115329901



20210806
读书若未能应用，则所读的书等于废纸。——华盛顿

致命bug：本来是修改学生端接口，改到管理端去了

oracle修改某字段为非必填
ALTER TABLE table_name MODIFY 要修改的字段名字 NULL;

润乾报表字符串拼接

手工排课弹窗提示
https://www.runoob.com/jsref/jsref-find.html

一、代码

if (!this.businessData.sjms.find(item => !item.jczy002id)) {
            $notify({
              type: 'warning',
              message: this.resI18n.lb_ssxqmy || '所属校区没有对应的时间模式'
            })
            return
          }

二、测试结果
多条数据：
（1）jczy002id，部分null，部分有值，不弹窗
（2）jczy002id，全null，不弹窗
（3）jczy002id，全有值，弹窗
单条数据：
（1）jczy002id为null不弹窗
（2）jczy002id有值弹窗

三、测试数据
（1）现场一

{"errorCode":"success","errorMessage":"success","errorMessageParam":[],"data":{"rowCount":3,"items":[{"glcxdy_name":"是","jczy002id":null,"xsxq6_name":"是","jcmb_name":"课表时间","xscxdy_name":"是","createdate":1625729558000,"kbsjname3":null,"kbsjname2":null,"kbsjname1":"时间表","sfxsxq7code":"1","sfxscxdycode":"1","bz":null,"xnxq_name":"2021-2022-1","id":"j13464140000WH","sfjscxdycode":"1","sfxsxq6code":"1","mtdj":6,"lastmodifydate":1626231242000,"creator":"admin","xsxq7_name":"是","jczy013id":"2021-2022-1","jczy015id":"1","lpqsxj6":"01","lpqsxj4":"01,05,09","site":null,"lpqsxj5":"01","lpqsxj2":"01,03,05,07,09,11","lpqsxj3":"01,02,05,06,09,10","kbsj_name":"时间表","lpqsxj1":null,"sfglcxdycode":"1","xq_name":"全部","jscxdy_name":"是","lastmodify":"admin"},{"glcxdy_name":"是","jczy002id":"j13464140000WH","xsxq6_name":"是","jcmb_name":"特殊时间课表","xscxdy_name":"是","createdate":1625816559000,"kbsjname3":null,"kbsjname2":null,"kbsjname1":"测试2","sfxsxq7code":"1","sfxscxdycode":"1","bz":null,"xnxq_name":"2021-2022-1","id":"j13464150000WI","sfjscxdycode":"1","sfxsxq6code":"1","mtdj":5,"lastmodifydate":1626231249000,"creator":"admin","xsxq7_name":"是","jczy013id":"2021-2022-1","jczy015id":"j13464140000WH","lpqsxj6":"01","lpqsxj4":"01,05","site":null,"lpqsxj5":"01","lpqsxj2":"01,03,05,07,09","lpqsxj3":"01,02,05,06","kbsj_name":"测试2","lpqsxj1":null,"sfglcxdycode":"1","xq_name":"三亚崖州湾校区-特殊课程（测试系统）","jscxdy_name":"是","lastmodify":"admin"},{"glcxdy_name":"是","jczy002id":"j13464150000WH","xsxq6_name":"是","jcmb_name":"特殊时间课表2","xscxdy_name":"是","createdate":1625819803000,"kbsjname3":null,"kbsjname2":null,"kbsjname1":"测试3","sfxsxq7code":"1","sfxscxdycode":"1","bz":null,"xnxq_name":"2021-2022-1","id":"j13464150000WJ","sfjscxdycode":"1","sfxsxq6code":"1","mtdj":5,"lastmodifydate":1626231252000,"creator":"admin","xsxq7_name":"是","jczy013id":"2021-2022-1","jczy015id":"j13464150000WH","lpqsxj6":"01","lpqsxj4":"01,05","site":null,"lpqsxj5":"01","lpqsxj2":"01,03,05,07,09","lpqsxj3":"01,02,05,06","kbsj_name":"测试3","lpqsxj1":null,"sfglcxdycode":"1","xq_name":"三亚亚洲湾--特殊课程排课测试3","jscxdy_name":"是","lastmodify":"admin"}]},"runTime":"开始时间：2021-08-06 18:14:09;结束时间：2021-08-06 18:14:09;运行时间：4毫秒"}

（2）测试

{"errorCode":"success","errorMessage":"success","errorMessageParam":[],"data":{"rowCount":1,"items":[{"glcxdy_name":"是","jczy002id":null,"xsxq6_name":"是","jcmb_name":"课表时间","xscxdy_name":"是","createdate":1552616687000,"kbsjname3":null,"kbsjname2":null,"kbsjname1":"2019-2020-1","sfxsxq7code":"1","sfxscxdycode":"1","bz":null,"xnxq_name":"2019-2020-1秋季","id":"W134146b0000WH","sfjscxdycode":"1","sfxsxq6code":"1","mtdj":5,"lastmodifydate":1612837632000,"creator":"gx","xsxq7_name":"是","jczy013id":"2019-2020-1","jczy015id":"1","lpqsxj6":"01","lpqsxj4":"01,05","site":"default","lpqsxj5":"01","lpqsxj2":"01,03,05,07,09","lpqsxj3":"01,02,05,06,09","kbsj_name":"2019-2020-1","lpqsxj1":null,"sfglcxdycode":"1","xq_name":"全部","jscxdy_name":"是","lastmodify":"Leslie"}]},"runTime":"开始时间：2021-08-06 18:11:42;结束时间：2021-08-06 18:11:42;运行时间：13毫秒"}

（3）现场二

{"errorCode":"success","errorMessage":"success","errorMessageParam":[],"data":{"rowCount":3,"items":[{"glcxdy_name":"是","jczy002id":null,"xsxq6_name":"是","jcmb_name":"课表时间","xscxdy_name":"是","createdate":1625729558000,"kbsjname3":null,"kbsjname2":null,"kbsjname1":"时间表","sfxsxq7code":"1","sfxscxdycode":"1","bz":null,"xnxq_name":"2021-2022-1","id":"j13464140000WH","sfjscxdycode":"1","sfxsxq6code":"1","mtdj":6,"lastmodifydate":1626231242000,"creator":"admin","xsxq7_name":"是","jczy013id":"2021-2022-1","jczy015id":"1","lpqsxj6":"01","lpqsxj4":"01,05,09","site":null,"lpqsxj5":"01","lpqsxj2":"01,03,05,07,09,11","lpqsxj3":"01,02,05,06,09,10","kbsj_name":"时间表","lpqsxj1":null,"sfglcxdycode":"1","xq_name":"全部","jscxdy_name":"是","lastmodify":"admin"},{"glcxdy_name":"是","jczy002id":"j13464140000WH","xsxq6_name":"是","jcmb_name":"特殊时间课表","xscxdy_name":"是","createdate":1625816559000,"kbsjname3":null,"kbsjname2":null,"kbsjname1":"测试2","sfxsxq7code":"1","sfxscxdycode":"1","bz":null,"xnxq_name":"2021-2022-1","id":"j13464150000WI","sfjscxdycode":"1","sfxsxq6code":"1","mtdj":5,"lastmodifydate":1626231249000,"creator":"admin","xsxq7_name":"是","jczy013id":"2021-2022-1","jczy015id":"j13464140000WH","lpqsxj6":"01","lpqsxj4":"01,05","site":null,"lpqsxj5":"01","lpqsxj2":"01,03,05,07,09","lpqsxj3":"01,02,05,06","kbsj_name":"测试2","lpqsxj1":null,"sfglcxdycode":"1","xq_name":"三亚崖州湾校区-特殊课程（测试系统）","jscxdy_name":"是","lastmodify":"admin"},{"glcxdy_name":"是","jczy002id":"j13464150000WH","xsxq6_name":"是","jcmb_name":"特殊时间课表2","xscxdy_name":"是","createdate":1625819803000,"kbsjname3":null,"kbsjname2":null,"kbsjname1":"测试3","sfxsxq7code":"1","sfxscxdycode":"1","bz":null,"xnxq_name":"2021-2022-1","id":"j13464150000WJ","sfjscxdycode":"1","sfxsxq6code":"1","mtdj":5,"lastmodifydate":1626231252000,"creator":"admin","xsxq7_name":"是","jczy013id":"2021-2022-1","jczy015id":"j13464150000WH","lpqsxj6":"01","lpqsxj4":"01,05","site":null,"lpqsxj5":"01","lpqsxj2":"01,03,05,07,09","lpqsxj3":"01,02,05,06","kbsj_name":"测试3","lpqsxj1":null,"sfglcxdycode":"1","xq_name":"三亚亚洲湾--特殊课程排课测试3","jscxdy_name":"是","lastmodify":"admin"}]},"runTime":"开始时间：2021-08-06 18:14:09;结束时间：2021-08-06 18:14:09;运行时间：4毫秒"}

todo
导入模板、报表
学生范围-查询