manualConfirmationJS.js 47 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745
  1. import repostCurd from '@/business/platform/form/utils/custom/joinCURD.js'
  2. import * as dayjs from 'dayjs'
  3. const options = {
  4. '一个月': 1,
  5. '两个月': 2,
  6. '三个月': 3,
  7. '四个月': 4,
  8. '半年': 6,
  9. '九个月': 9,
  10. '一年': 12
  11. }
  12. export default {
  13. props: {
  14. obj: {
  15. default: [],
  16. type: Array
  17. }
  18. },
  19. methods: {
  20. facilityData(page) {
  21. let sql = `select lei_xing_ from t_yplxb`
  22. let sql2 = `select yang_pin_gui_ge_ from t_ypbzggb`
  23. Promise.all([repostCurd('sql',sql),repostCurd('sql',sql2)]).then(([res1,res2]) =>{
  24. let data = res1.variables.data
  25. let data2 = res2.variables.data
  26. let types = []
  27. let guiGes = []
  28. data.forEach(item=>{
  29. let obj = {
  30. value:item.lei_xing_,
  31. label:item.lei_xing_
  32. }
  33. types.push(obj)
  34. })
  35. data2.forEach(item=>{
  36. let o = {
  37. value:item.yang_pin_gui_ge_,
  38. label:item.yang_pin_gui_ge_
  39. }
  40. guiGes.push(o)
  41. })
  42. this.sampleTypes = types
  43. this.sampleSpecifications = guiGes
  44. })
  45. if (this.obj.length > 0) {
  46. this.loadData(this.obj)
  47. } else {
  48. this.loadDataBySQL(page)
  49. }
  50. },
  51. /* 获取数据 ,开始查阅记录 */
  52. loadData(obj) {
  53. let sql = `select ypb.*,sqb.chu_ju_bao_gao_ya from t_lhypb ypb join t_lhwtsqb sqb on ypb.parent_id_ = sqb.id_ and find_in_set(ypb.id_,'${obj}') and ypb.jie_yang_zhuang_t = '待接收' and ypb.shi_fou_guo_shen_ = '1'`
  54. let liuYangSQL = `select liu_yang_qi_xian_ from t_lyqxpzb limit 1`
  55. let cfIDSQL = `select cun_fang_id_,liu_yang_id_ FROM t_ypwzmrxzb`
  56. Promise.all([repostCurd('sql', sql), repostCurd('sql', liuYangSQL),repostCurd('sql',cfIDSQL)]).then((res) => {
  57. let temp = res[0].variables.data
  58. let option = res[1].variables.data[0].liu_yang_qi_xian_
  59. let cfID = res[2].variables.data[0].cun_fang_id_
  60. let lyID = res[2].variables.data[0].liu_yang_id_
  61. let rq = options[option]
  62. if (temp) {
  63. temp.forEach(item => {
  64. item.jie_yang_shu_lian = item.yang_pin_zong_shu
  65. item.jie_yang_zhuang_t = '已确认'
  66. item.biao_zhi_uuid_1 = this.uuid()
  67. item.biao_zhi_uuid_2 = this.uuid()
  68. item.biao_zhi_uuid_3 = this.uuid()
  69. item.biao_zhi_uuid_4 = this.uuid()
  70. // item.shi_fou_liu_yang_ = '是'
  71. item.shi_fou_liu_yang_yi = '是'
  72. item.shi_fou_liu_yang_er = '是'
  73. item.shi_fou_liu_yang_san = '是'
  74. item.shi_fou_liu_yang_si = '是'
  75. item.yan_shou_jie_guo_ = '完好'
  76. item.liu_yang_shu_lian_yi = ' ml/支×1支'
  77. item.shou_yang_wei_zhi_yi = cfID
  78. item.liu_yang_wei_zhi_yi = lyID
  79. item.yang_pin_lei_er_ ?
  80. (item.liu_yang_shu_lian_er = ' ml/支×1支' ,item.shou_yang_wei_zhi_er = cfID,item.liu_yang_wei_zhi_er = lyID) : null
  81. item.yang_pin_lei_san_ ?
  82. (item.liu_yang_shu_lian_san = ' ml/支×1支',item.shou_yang_wei_zhi_san = cfID,item.liu_yang_wei_zhi_san = lyID) : null
  83. item.yang_pin_lei_si_ ?
  84. (item.liu_yang_shu_lian_si = ' ml/支×1支',item.shou_yang_wei_zhi_si = cfID,item.liu_yang_wei_zhi_si = lyID) : null
  85. item.liu_yang_ri_qi_ = new Date(new Date().getTime() + 28800000).toJSON().slice(0, 10).replace('T', ' ')
  86. item.yang_pin_lei_er_ ? this.$set(item, 'flag2', true) : this.$set(item, 'flag2', false)
  87. item.yang_pin_lei_san_ ? this.$set(item, 'flag3', true) : this.$set(item, 'flag3', false)
  88. item.yang_pin_lei_si_ ? this.$set(item, 'flag4', true) : this.$set(item, 'flag4', false)
  89. item.liu_yang_qi_xian = dayjs(item.song_jian_shi_jia).add(rq, 'month').format("YYYY-MM-DD")
  90. // temp[i].xiao_hui_ri_qi_ = dayjs(temp[i].liu_yang_qi_xian).endOf('month').format("YYYY-MM-DD")
  91. })
  92. this.listData = temp
  93. } else {
  94. this.handleEmptyData();
  95. }
  96. })
  97. },
  98. loadDataBySQL(page) {
  99. // 扫码扫到新数据,查询 并分页 回填展示
  100. let fysql = `select ypb.*,sqb.chu_ju_bao_gao_ya from t_lhypb ypb join t_lhwtsqb sqb on ypb.parent_id_ = sqb.id_ and ypb.jie_yang_zhuang_t = '待接收' and ypb.shi_fou_guo_shen_ = '1'`
  101. let liuYangSQL = `select liu_yang_qi_xian_ from t_lyqxpzb limit 1`
  102. let cfIDSQL = `select cun_fang_id_,liu_yang_id_ FROM t_ypwzmrxzb`
  103. Promise.all([repostCurd('sql', fysql), repostCurd('sql', liuYangSQL),repostCurd('sql',cfIDSQL)]).then(([res1,res2,res3]) => {
  104. let cfID = res3.variables.data[0].cun_fang_id_
  105. let lyID = res3.variables.data[0].liu_yang_id_
  106. this.listData = []
  107. let temp = res1.variables.data
  108. let option = res2.variables.data[0].liu_yang_qi_xian_
  109. let rq = options[option]
  110. if (temp) {
  111. temp.forEach(item => {
  112. item.jie_yang_shu_lian = item.yang_pin_zong_shu
  113. item.jie_yang_zhuang_t = '已确认'
  114. item.biao_zhi_uuid_1 = this.uuid()
  115. item.biao_zhi_uuid_2 = this.uuid()
  116. item.biao_zhi_uuid_3 = this.uuid()
  117. item.biao_zhi_uuid_4 = this.uuid()
  118. // item.shi_fou_liu_yang_ = '是'
  119. item.shi_fou_liu_yang_yi = '是'
  120. item.shi_fou_liu_yang_er = '是'
  121. item.shi_fou_liu_yang_san = '是'
  122. item.shi_fou_liu_yang_si = '是'
  123. item.yan_shou_jie_guo_ = '完好'
  124. item.liu_yang_shu_lian_yi = ' ml/支×1支'
  125. item.shou_yang_wei_zhi_yi = cfID
  126. item.liu_yang_wei_zhi_yi = lyID
  127. item.yang_pin_lei_er_ ?
  128. (item.liu_yang_shu_lian_er = ' ml/支×1支' ,item.shou_yang_wei_zhi_er = cfID,item.liu_yang_wei_zhi_er = lyID) : null
  129. item.yang_pin_lei_san_ ?
  130. (item.liu_yang_shu_lian_san = ' ml/支×1支',item.shou_yang_wei_zhi_san = cfID,item.liu_yang_wei_zhi_san = lyID) : null
  131. item.yang_pin_lei_si_ ?
  132. (item.liu_yang_shu_lian_si = ' ml/支×1支',item.shou_yang_wei_zhi_si = cfID,item.liu_yang_wei_zhi_si = lyID) : null
  133. // item.yang_pin_lei_er_ ? item.liu_yang_shu_lian_er = ' ml/支×1支' : null
  134. // item.yang_pin_lei_san_ ? item.liu_yang_shu_lian_san = ' ml/支×1支' : null
  135. // item.yang_pin_lei_si_ ? item.liu_yang_shu_lian_si = ' ml/支×1支' : null
  136. item.liu_yang_ri_qi_ = new Date(new Date().getTime() + 28800000).toJSON().slice(0, 10).replace('T', ' ')
  137. item.yang_pin_lei_er_ ? this.$set(item, 'flag2', true) : this.$set(item, 'flag2', false)
  138. item.yang_pin_lei_san_ ? this.$set(item, 'flag3', true) : this.$set(item, 'flag3', false)
  139. item.yang_pin_lei_si_ ? this.$set(item, 'flag4', true) : this.$set(item, 'flag4', false)
  140. item.liu_yang_qi_xian = dayjs(item.song_jian_shi_jia).add(rq, 'month').format("YYYY-MM-DD")
  141. })
  142. this.listData = temp
  143. } else {
  144. this.handleEmptyList();
  145. }
  146. })
  147. },
  148. handleEmptyData() {
  149. this.$confirm('您所选择的样品还未到实验室现场,无法接样!').then(_ => {
  150. this.closeDialog();
  151. }).catch(_ => { });
  152. },
  153. handleEmptyList() {
  154. this.$confirm('目前暂无样品需要接样!').then(_ => {
  155. this.closeDialog();
  156. }).catch(_ => { });
  157. },
  158. /* 列表失去焦点*/
  159. handleChange() {
  160. this.$refs.redarInput.focus(); //聚焦input
  161. },
  162. /* 关闭弹出列表框*/
  163. closeDialog() {
  164. this.remRedar()
  165. //回传关闭事件。隐藏当前组件。
  166. },
  167. handleClose() {
  168. this.handleChange()
  169. this.$confirm('确认关闭样品列表页面?').then(_ => {
  170. this.closeDialog();
  171. }).catch(_ => { });
  172. },
  173. handleAnySituation(callBackBool,msg,type){
  174. this.$emit('callback', callBackBool)
  175. this.visable = false
  176. this.$message({
  177. message: msg,
  178. type: type
  179. })
  180. this.closeDialog();
  181. },
  182. handleErrorData(msg){
  183. const { error } = this.$form.$message
  184. error(`${msg}`)
  185. return
  186. },
  187. submitData(type) {
  188. // this指针
  189. let this_ = this;
  190. // 回传关闭事件。隐藏当前组件。
  191. let judge = true;
  192. if (this_.listData.length == 0) {
  193. this.$emit('callback', true)
  194. this.visable = false
  195. this.$message({
  196. message: '暂无样品待接收确认!',
  197. type: 'error'
  198. })
  199. this.closeDialog();
  200. } else {
  201. this.$confirm('请再次确认 [样品接收信息]').then(_ => {
  202. // 获取样品列表
  203. let ypInfoList = this_.listData
  204. // console.log(ypInfoList, "样品信息")
  205. let dWhere = []
  206. let ypbh = []
  207. let ypbhList = [] // 样品编号列表
  208. // 罗湖样品编号列表
  209. let lhypbhList = []
  210. let lhypmcList = []
  211. // 罗湖样品表外键
  212. let lhypbWJ = []
  213. // 罗湖委托表主键
  214. let lhwtbID = []
  215. // 罗湖委托表展示表ID
  216. let lhwtzsbID = []
  217. // 罗湖样品id列表
  218. let lhypIdList = []
  219. // 罗湖样品id格式列表
  220. let lhypIdNewList = []
  221. // 样品所选择的位置ID字符串
  222. let localStr = ''
  223. let locationIds = new Set()
  224. let localArr = []
  225. let sampleList = []
  226. for (let yp in ypInfoList) { //样品数据
  227. let cfwz = ''
  228. /*
  229. 校验:
  230. 1、样品数量 <= 确认数量
  231. 2、是否留样 => 填收样位置|留样位置
  232. 3、验收结果必填
  233. 4、如果留样 => 必填项:留样日期、留样数量、留样期限至、销毁日期
  234. */
  235. if (ypInfoList[yp].jie_yang_shu_lian > ypInfoList[yp].yang_pin_zong_shu) {
  236. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 接收确认数量不得大于收样数量。')
  237. return;
  238. }
  239. if (ypInfoList[yp].jie_yang_zhuang_t == '未确认') {
  240. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 接收确认状态必须为已确认。')
  241. return;
  242. }
  243. if (ypInfoList[yp].yan_shou_jie_guo_ == null || ypInfoList[yp].yan_shou_jie_guo_ == '') {
  244. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 验收结果不能为空!')
  245. return;
  246. }
  247. // if (ypInfoList[yp].shi_fou_liu_yang_ == null || ypInfoList[yp].shi_fou_liu_yang_ == '') {
  248. // this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 是否留样不能为空!')
  249. // return;
  250. // }
  251. /** 如果四个是否留样中有一个为‘是’ 则 留样日期 和对应的留样位置就不能为空 */
  252. // ypInfoList[yp].shou_yang_wei_zhi_yi == null || ypInfoList[yp].shou_yang_wei_zhi_yi == ''
  253. if (ypInfoList[yp].shi_fou_liu_yang_yi == "是" ||
  254. (ypInfoList[yp].flag2 == true && ypInfoList[yp].shi_fou_liu_yang_er == "是") ||
  255. (ypInfoList[yp].flag3 == true && ypInfoList[yp].shi_fou_liu_yang_san == "是") ||
  256. (ypInfoList[yp].flag4 == true && ypInfoList[yp].shi_fou_liu_yang_si == "是")) {
  257. if (ypInfoList[yp].liu_yang_ri_qi_ == null || ypInfoList[yp].liu_yang_ri_qi_ == '') {
  258. this_.$message.error('留样时必须填写留样日期!')
  259. return;
  260. // this_.handleErrorData("") todo 失效
  261. }
  262. if(ypInfoList[yp].shi_fou_liu_yang_yi == "是"){
  263. // 判断位置是否为空
  264. if (ypInfoList[yp].liu_yang_wei_zhi_yi == null || ypInfoList[yp].liu_yang_wei_zhi_yi == '') {
  265. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的留样位置选择不能为空!')
  266. return;
  267. }
  268. if(ypInfoList[yp].liu_yang_shu_lian_yi == null || ypInfoList[yp].liu_yang_shu_lian_yi == ''){
  269. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的留样数量不能为空!')
  270. return;
  271. }
  272. }
  273. if(ypInfoList[yp].shi_fou_liu_yang_er == "是"){
  274. if(ypInfoList[yp].flag2 == true){
  275. if (ypInfoList[yp].liu_yang_wei_zhi_er == '' || ypInfoList[yp].liu_yang_wei_zhi_er == null) {
  276. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的留样位置选择不能为空!')
  277. return;
  278. }
  279. if(ypInfoList[yp].liu_yang_shu_lian_er == null || ypInfoList[yp].liu_yang_shu_lian_er == ''){
  280. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的留样数量不能为空!')
  281. return;
  282. }
  283. }
  284. }
  285. if(ypInfoList[yp].shi_fou_liu_yang_san == "是"){
  286. if(ypInfoList[yp].flag3 == true ){
  287. if (ypInfoList[yp].liu_yang_wei_zhi_san == '' || ypInfoList[yp].liu_yang_wei_zhi_san == null) {
  288. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的留样位置选择不能为空!')
  289. return;
  290. }
  291. if(ypInfoList[yp].liu_yang_shu_lian_san == null || ypInfoList[yp].liu_yang_shu_lian_san == ''){
  292. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的留样数量不能为空!')
  293. return;
  294. }
  295. }
  296. }
  297. if(ypInfoList[yp].shi_fou_liu_yang_si == "是"){
  298. if(ypInfoList[yp].flag4 == true ){
  299. if (ypInfoList[yp].liu_yang_wei_zhi_si == '' || ypInfoList[yp].liu_yang_wei_zhi_si == null) {
  300. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的留样位置选择不能为空!')
  301. return;
  302. }
  303. if(ypInfoList[yp].liu_yang_shu_lian_si == null || ypInfoList[yp].liu_yang_shu_lian_si == ''){
  304. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的留样数量不能为空!')
  305. return;
  306. }
  307. }
  308. }
  309. }
  310. // 判断位置是否为空
  311. if (ypInfoList[yp].shou_yang_wei_zhi_yi == null || ypInfoList[yp].shou_yang_wei_zhi_yi == '') {
  312. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的位置选择不能为空!')
  313. return;
  314. }
  315. if (ypInfoList[yp].flag2 == true && (ypInfoList[yp].shou_yang_wei_zhi_er == '' || ypInfoList[yp].shou_yang_wei_zhi_er == null)) {
  316. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的位置选择不能为空!')
  317. return;
  318. }
  319. if (ypInfoList[yp].flag3 == true && (ypInfoList[yp].shou_yang_wei_zhi_san == '' || ypInfoList[yp].shou_yang_wei_zhi_san == null)) {
  320. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的位置选择不能为空!')
  321. return;
  322. }
  323. if (ypInfoList[yp].flag4 == true && (ypInfoList[yp].shou_yang_wei_zhi_si == '' || ypInfoList[yp].shou_yang_wei_zhi_si == null)) {
  324. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的位置选择不能为空!')
  325. return;
  326. }
  327. ypbhList.push('{"yang_pin_bian_hao":"' + ypInfoList[yp].yang_pin_bian_hao + '"}') // 样品编号列表
  328. // 罗湖
  329. dWhere.push('{"id_":"' + cfwz + '"}')
  330. lhypbhList.push(ypInfoList[yp].yang_pin_bian_hao)
  331. lhypbWJ.push(ypInfoList[yp].parent_id_)
  332. lhypIdList.push(ypInfoList[yp].id_)
  333. lhypIdNewList.push('{"id_":"' + ypInfoList[yp].id_ + '"}')
  334. ypbh.push(ypInfoList[yp].yang_pin_bian_hao)
  335. lhypmcList.push(ypInfoList[yp].yang_pin_ming_che)
  336. localArr.push(
  337. ypInfoList[yp].shou_yang_wei_zhi_yi, ypInfoList[yp].liu_yang_wei_zhi_yi,
  338. ypInfoList[yp].shou_yang_wei_zhi_er, ypInfoList[yp].liu_yang_wei_zhi_er,
  339. ypInfoList[yp].shou_yang_wei_zhi_san, ypInfoList[yp].liu_yang_wei_zhi_san,
  340. ypInfoList[yp].shou_yang_wei_zhi_si, ypInfoList[yp].liu_yang_wei_zhi_si
  341. )
  342. let o = {
  343. where:{
  344. id_ : ypInfoList[yp].id_
  345. },
  346. param:{
  347. yang_pin_lei_xing: ypInfoList[yp].yang_pin_lei_xing,
  348. yang_ben_yun_shu_: ypInfoList[yp].yang_ben_yun_shu_,
  349. shu_liang_: ypInfoList[yp].shu_liang_,
  350. yang_pin_gui_ge_: ypInfoList[yp].yang_pin_gui_ge_,
  351. yang_pin_lei_er_: ypInfoList[yp].yang_pin_lei_er_,
  352. yang_pin_yun_shu_: ypInfoList[yp].yang_pin_yun_shu_,
  353. shu_liang_er_: ypInfoList[yp].shu_liang_er_,
  354. yang_pin_gui_ge_e: ypInfoList[yp].yang_pin_gui_ge_e,
  355. yang_pin_lei_san_: ypInfoList[yp].yang_pin_lei_san_,
  356. yang_pin_yun_san: ypInfoList[yp].yang_pin_yun_san,
  357. shu_liang_san_: ypInfoList[yp].shu_liang_san_,
  358. yang_pin_gui_ge_s: ypInfoList[yp].yang_pin_gui_ge_s,
  359. yang_pin_lei_si_: ypInfoList[yp].yang_pin_lei_si_,
  360. yang_pin_yun_si_: ypInfoList[yp].yang_pin_yun_si_,
  361. shu_liang_si_: ypInfoList[yp].shu_liang_si_,
  362. yang_pin_gui_si_: ypInfoList[yp].yang_pin_gui_si_,
  363. jie_yang_zhuang_t:"已接收",
  364. yang_pin_zong_shu:ypInfoList[yp].yang_pin_zong_shu
  365. }
  366. }
  367. sampleList.push(o)
  368. }
  369. localStr = localArr.filter(i => i).join(',')
  370. let value = ''
  371. let lhypIdStr = ''
  372. for (let i = 0; i < lhypbWJ.length; i++) {
  373. value += lhypbWJ[i] + ','
  374. }
  375. value = value.substring(0, value.length - 1)
  376. value = value.replace(/,/g, "','")
  377. for (let i = 0; i < lhypIdList.length; i++) {
  378. lhypIdStr += lhypIdList[i] + ','
  379. }
  380. lhypIdStr = lhypIdStr.substring(0, lhypIdStr.length - 1)
  381. lhypIdStr = lhypIdStr.replace(/,/g, "','")
  382. let currentTime = new Date(new Date().getTime() + 28800000).toJSON().slice(0, 16).replace('T', ' ')
  383. let allSQL = `select a.id_ as wtID,a.chu_ju_bao_gao_ya,a.zhan_shi_biao_id_,a.wei_tuo_lei_xing_,a.he_tong_id_,a.bao_gao_lei_xing_,a.wei_tuo_bian_hao_, a.wei_tuo_dan_wei_ as wtdh, a.wei_tuo_fang_lian, a.wei_tuo_lian,a.bao_gao_bian_zhi_,a.bao_gao_fu_he_yua,b.* from t_lhwtsqb a inner join t_lhypb b on a.id_ = b.parent_id_ where b.parent_id_ in ('${value}')and b.id_ in ('${lhypIdStr}')`
  384. // 搜集所有选择的位置信息
  385. // console.log('当前选择的位置ids:',locationIds)
  386. var allLocal = `select * from t_ypcfwz where find_in_set(id_,'${localStr}')`
  387. Promise.all([repostCurd("sql", allSQL), repostCurd("sql", allLocal)]).then((res) => {
  388. let result = res[0].variables.data
  389. let localInfo = res[1].variables.data
  390. // console.log(localInfo)
  391. /* 1、更新货架位置信息 */
  392. this.emptyLocal = []
  393. this.fullLocal = []
  394. let allUUID = []
  395. ypInfoList.forEach(item => {
  396. allUUID.push(item.biao_zhi_uuid_1, item.biao_zhi_uuid_2, item.biao_zhi_uuid_3, item.biao_zhi_uuid_4)
  397. let allResult = []
  398. if(item.shou_yang_wei_zhi_yi != undefined && item.shou_yang_wei_zhi_yi){
  399. allResult.push(this.handleLocationInfo(item.shou_yang_wei_zhi_yi, '否', localInfo, locationIds, item, item.biao_zhi_uuid_1, currentTime,item.yang_pin_lei_xing,item.liu_yang_shu_lian_yi))
  400. }
  401. if (item.shou_yang_wei_zhi_er != undefined && item.shou_yang_wei_zhi_er) {
  402. allResult.push(this.handleLocationInfo(item.shou_yang_wei_zhi_er, '否', localInfo, locationIds, item, item.biao_zhi_uuid_2, currentTime,item.yang_pin_lei_er_,item.liu_yang_shu_lian_er))
  403. }
  404. if (item.shou_yang_wei_zhi_san != undefined && item.shou_yang_wei_zhi_san) {
  405. allResult.push(this.handleLocationInfo(item.shou_yang_wei_zhi_san, '否', localInfo, locationIds, item, item.biao_zhi_uuid_3, currentTime,item.yang_pin_lei_san_,item.liu_yang_shu_lian_san))
  406. }
  407. if (item.shou_yang_wei_zhi_si != undefined && item.shou_yang_wei_zhi_si) {
  408. allResult.push(this.handleLocationInfo(item.shou_yang_wei_zhi_si, '否', localInfo, locationIds, item, item.biao_zhi_uuid_4, currentTime,item.yang_pin_lei_si_,item.liu_yang_shu_lian_si))
  409. }
  410. if(item.liu_yang_wei_zhi_yi != undefined && item.liu_yang_wei_zhi_yi && item.shi_fou_liu_yang_yi === '是'){
  411. allResult.push(this.handleLocationInfo(item.liu_yang_wei_zhi_yi, '是', localInfo, locationIds, item, item.biao_zhi_uuid_1, currentTime,item.yang_pin_lei_xing,item.liu_yang_shu_lian_yi))
  412. }
  413. if (item.liu_yang_wei_zhi_er != undefined && item.liu_yang_wei_zhi_er && item.shi_fou_liu_yang_er === '是') {
  414. allResult.push(this.handleLocationInfo(item.liu_yang_wei_zhi_er, '是', localInfo, locationIds, item, item.biao_zhi_uuid_2, currentTime,item.yang_pin_lei_er_,item.liu_yang_shu_lian_er))
  415. }
  416. if (item.liu_yang_wei_zhi_san != undefined && item.liu_yang_wei_zhi_san && item.shi_fou_liu_yang_san === '是') {
  417. allResult.push(this.handleLocationInfo(item.liu_yang_wei_zhi_san, '是', localInfo, locationIds, item, item.biao_zhi_uuid_3, currentTime,item.yang_pin_lei_san_,item.liu_yang_shu_lian_san))
  418. }
  419. if (item.liu_yang_wei_zhi_si != undefined && item.liu_yang_wei_zhi_si && item.shi_fou_liu_yang_si === '是') {
  420. allResult.push(this.handleLocationInfo(item.liu_yang_wei_zhi_si, '是', localInfo, locationIds, item, item.biao_zhi_uuid_4, currentTime,item.yang_pin_lei_si_,item.liu_yang_shu_lian_si))
  421. }
  422. allResult.forEach(item => {
  423. item.name === 'emptyLocation' ? this.emptyLocal.push(item.value) : this.fullLocal.push(item.value)
  424. })
  425. })
  426. let allUUIDStr = allUUID.filter(i => i).join(',')
  427. // 更新样品位置list
  428. // console.log('emptyLocal:',this.emptyLocal)
  429. if(this.emptyLocal.length > 0){
  430. let allParams = {
  431. tableName: 't_ypcfwz',
  432. updList: this.emptyLocal
  433. }
  434. repostCurd('updatesByWhere', JSON.stringify(allParams))
  435. }
  436. // 插入样品位置list
  437. // console.log('fullLocal:',this.fullLocal)
  438. repostCurd('add', '{"tableName":"t_ypcfwz","paramWhere":' + JSON.stringify(this.fullLocal) + '}').then(res => {
  439. // 再次查询位置表,对比当前样品列表 替换初始值为占用的样品位置id
  440. let findLocationAgain = `select id_,shi_fou_liu_yang_,biao_zhi_uuid_ from t_ypcfwz where find_in_set(biao_zhi_uuid_,'${allUUIDStr}')`
  441. // console.log(findLocationAgain)
  442. repostCurd('sql', findLocationAgain).then(res => {
  443. let data = res.variables.data
  444. let uuidArgs = ['biao_zhi_uuid_1', 'biao_zhi_uuid_2', 'biao_zhi_uuid_3', 'biao_zhi_uuid_4']
  445. let shouYangArgs = ['shou_yang_wei_zhi_yi', 'shou_yang_wei_zhi_er', 'shou_yang_wei_zhi_san', 'shou_yang_wei_zhi_si']
  446. let liuYangArgs = ['liu_yang_wei_zhi_yi', 'liu_yang_wei_zhi_er', 'liu_yang_wei_zhi_san', 'liu_yang_wei_zhi_si']
  447. data.forEach(item => {
  448. uuidArgs.forEach((uuid, index) => {
  449. let ypIndex = ypInfoList.findIndex(i => i[uuid] === item.biao_zhi_uuid_)
  450. if (ypIndex != -1) {
  451. item.shi_fou_liu_yang_ === '否' ?
  452. ypInfoList[ypIndex][shouYangArgs[index]] = item.id_ :
  453. ypInfoList[ypIndex][liuYangArgs[index]] = item.id_
  454. }
  455. })
  456. })
  457. // repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}')
  458. /* 2、封装样品登记表对象,插入样品登记表 顺便封装任务分配表 */
  459. let ypdjb = []
  460. let rws = []
  461. result.forEach((item, index) => {
  462. // 2-1:统计每个样品有多少类型[数量]
  463. let lxList = []
  464. let ypggList = []
  465. let liuYangList = []
  466. lxList.push(ypInfoList[index].yang_pin_lei_xing, ypInfoList[index].yang_pin_lei_er_, ypInfoList[index].yang_pin_lei_san_, ypInfoList[index].yang_pin_lei_si_)
  467. ypggList.push(ypInfoList[index].yang_pin_gui_ge_, ypInfoList[index].yang_pin_gui_ge_e, ypInfoList[index].yang_pin_gui_ge_s, ypInfoList[index].yang_pin_gui_si_)
  468. liuYangList.push(ypInfoList[index].liu_yang_shu_lian_yi, ypInfoList[index].liu_yang_shu_lian_er, ypInfoList[index].liu_yang_shu_lian_san, ypInfoList[index].liu_yang_shu_lian_si)
  469. let yplxz = lxList.filter(i => i).join(';')
  470. let ypggStr = ypggList.filter(i => i).join(';')
  471. let liuyangStr = liuYangList.filter(i => i).join(';')
  472. // let count = lxList.filter(i => i).join(',').match(/,/g).length + 1
  473. let size = lxList.filter(i => i).join(',').match(/,/g)
  474. let count = 1
  475. size == null ? count = 1 : count = size.length + 1
  476. for (let c = 0; c < count; c++) {
  477. let xmmc = []
  478. xmmc.push(item.chang_gui_xiang_m, item.tao_can_ming_chen)
  479. let xiangMuZh = xmmc.filter(i => i).join(',')
  480. let yblx = c == 0 ? ypInfoList[index].yang_pin_lei_xing :
  481. c == 1 ? ypInfoList[index].yang_pin_lei_er_ :
  482. c == 2 ? ypInfoList[index].yang_pin_lei_san_ :
  483. c == 3 ? ypInfoList[index].yang_pin_lei_si_ : ''
  484. let ystj = c == 0 ? ypInfoList[index].yang_ben_yun_shu_ :
  485. c == 1 ? ypInfoList[index].yang_pin_yun_shu_ :
  486. c == 2 ? ypInfoList[index].yang_pin_yun_san :
  487. c == 3 ? ypInfoList[index].yang_pin_yun_si_ : ''
  488. let ypsl = c == 0 ? ypInfoList[index].shu_liang_ :
  489. c == 1 ? ypInfoList[index].shu_liang_er_ :
  490. c == 2 ? ypInfoList[index].shu_liang_san_ :
  491. c == 3 ? ypInfoList[index].shu_liang_si_ : ''
  492. let ybgg = c == 0 ? ypInfoList[index].yang_pin_gui_ge_ :
  493. c == 1 ? ypInfoList[index].yang_pin_gui_ge_e :
  494. c == 2 ? ypInfoList[index].yang_pin_gui_ge_s :
  495. c == 3 ? ypInfoList[index].yang_pin_gui_si_ : ''
  496. let sywz = c == 0 ? ypInfoList[index].shou_yang_wei_zhi_yi :
  497. c == 1 ? ypInfoList[index].shou_yang_wei_zhi_er :
  498. c == 2 ? ypInfoList[index].shou_yang_wei_zhi_san :
  499. c == 3 ? ypInfoList[index].shou_yang_wei_zhi_si : ''
  500. let lycf = c == 0 ? ypInfoList[index].liu_yang_wei_zhi_yi :
  501. c == 1 ? ypInfoList[index].liu_yang_wei_zhi_er :
  502. c == 2 ? ypInfoList[index].liu_yang_wei_zhi_san :
  503. c == 3 ? ypInfoList[index].liu_yang_wei_zhi_si : ''
  504. let lysl = c == 0 ? ypInfoList[index].liu_yang_shu_lian_yi :
  505. c == 1 ? ypInfoList[index].liu_yang_shu_lian_er :
  506. c == 2 ? ypInfoList[index].liu_yang_shu_lian_san :
  507. c == 3 ? ypInfoList[index].liu_yang_shu_lian_si : ''
  508. let currentUUID = c == 0 ? ypInfoList[index].biao_zhi_uuid_1 :
  509. c == 1 ? ypInfoList[index].biao_zhi_uuid_2 :
  510. c == 2 ? ypInfoList[index].biao_zhi_uuid_3 :
  511. c == 3 ? ypInfoList[index].biao_zhi_uuid_4 : ''
  512. let ifLy = c == 0 ? ypInfoList[index].shi_fou_liu_yang_yi :
  513. c == 1 ? ypInfoList[index].shi_fou_liu_yang_er :
  514. c == 2 ? ypInfoList[index].shi_fou_liu_yang_san:
  515. c == 3 ? ypInfoList[index].shi_fou_liu_yang_si : ''
  516. let obj = {
  517. wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
  518. wei_tuo_dan_wei_: item.wtdh,
  519. lian_xi_ren_: item.wei_tuo_fang_lian,
  520. lian_xi_dian_hua_: item.wei_tuo_lian,
  521. yang_ben_ming_che: item.yang_pin_ming_che,
  522. yang_ben_bian_hao: item.yang_pin_bian_hao,
  523. pi_hao_bian_hao_: item.song_jian_pi_hao_,
  524. song_jian_dan_wei: item.song_jian_dan_wei,
  525. xing_ming_: ypInfoList[index].xing_ming_,
  526. xing_bie_: ypInfoList[index].xing_bie_,
  527. nian_ling_: ypInfoList[index].nian_ling_,
  528. yang_ben_zhuang_t: item.yang_pin_zhuang_t,
  529. shou_yang_ri_qi_: currentTime,
  530. bei_zhu_: ypInfoList[index].bei_zhu_,
  531. yang_ben_lei_xing: yblx,
  532. yun_shu_tiao_jian: ystj,
  533. yang_pin_shu_lian: ypsl,
  534. yang_ben_gui_ge_s: ybgg,
  535. yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
  536. cun_fang_wei_zhi_: sywz,
  537. liu_zhuan_zhuang_: '待任务分配',
  538. shi_fou_liu_yang_: ifLy,
  539. liu_yang_ri_qi_: ifLy == '是'? ypInfoList[index].liu_yang_ri_qi_:'',
  540. liu_yang_cun_fang: ifLy == '是'?lycf:'',
  541. liu_yang_shu_lian: lysl == null ?'':lysl,
  542. liu_yang_qi_xian: ifLy == '是'? ypInfoList[index].liu_yang_qi_xian:'',
  543. xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_,
  544. fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_,
  545. fan_yang_jyr: ypInfoList[index].fan_yang_jyr,
  546. biao_zhi_uuid_: currentUUID,
  547. song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu,
  548. jian_ce_xiang_mu_: xiangMuZh,
  549. shou_yang_ren_:this.$store.getters.userInfo.user.name
  550. }
  551. // console.log(obj)
  552. ypdjb.push(obj)
  553. }
  554. // 2-2:封装任务分配表
  555. let rw = {
  556. yang_pin_ming_che: item.yang_pin_ming_che,
  557. yang_pin_bian_hao: item.yang_pin_bian_hao,
  558. wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
  559. yang_pin_lei_xing: yplxz,
  560. yang_pin_gui_ge_: ypggStr,
  561. wei_tuo_id_: item.wtID,
  562. he_tong_id_: item.he_tong_id_,
  563. zhuang_tai_: '待任务分配',
  564. wan_cheng_shi_jia: item.song_jian_shi_jia,
  565. bao_gao_lei_xing_: item.bao_gao_lei_xing_,
  566. xin_xiang_mu_ming: item.xiang_mu_ming_che,
  567. zhan_shi_biao_id_: item.zhan_shi_biao_id_,
  568. fen_zhuang_liu_ya: liuyangStr,
  569. shi_fou_jia_ji_: item.chu_ju_bao_gao_ya, // 是否加急【2023/2/23王嘎嘎提出】
  570. yang_pin_shu_lian: ypInfoList[index].jie_yang_shu_lian // 样品确认总数【2023/3/7王嘎嘎提出】
  571. }
  572. rws.push(rw)
  573. lhwtzsbID.push('{"shen_qing_id_":"' + item.zhan_shi_biao_id_ + '"}')
  574. lhwtbID.push('{"id_":"' + item.wtID + '"}')
  575. })
  576. /* 4、任务分配
  577. 4-1、根据 wtdAndYpb 的 wtID 更改委托表的 委托状态 wei_tuo_zhuang_ta 变成 已完成
  578. 4-2、根据每个样品一个任务分配流程 遍历样品表开任务分配流程
  579. 4-3、委托表找zhan_shi_biao_id_ 修改 t_lhwtzsb "zhuang_tai_"为"任务分配进行中"
  580. 优化:将其他不冲突的更改状态脚本放在任务分配后并行处理
  581. */
  582. // console.log("4、任务分配",rws)
  583. repostCurd('add', '{"tableName":"t_lhrwfpb","paramWhere":' + JSON.stringify(rws) + ',"defKey":"Process_04o0csc","formKey":"lhrwfp"}').then(res=>{
  584. // console.log('4、更改委托表的 委托状态',lhwtbID)
  585. repostCurd('updates', '{"tableName":"t_lhwtsqb","paramWhere":[' + lhwtbID + '],"paramCond":{"wei_tuo_zhuang_ta":"已完成"}}')
  586. /* 5、更新展示表 */
  587. if (lhwtzsbID.length > 0) {
  588. // console.log('5、更新展示表',lhwtzsbID)
  589. repostCurd('updates', '{"tableName":"t_lhwtzsb","paramWhere":[' + lhwtzsbID + '],"paramCond":{"zhuang_tai_":"任务分配进行中"}}')
  590. }
  591. console.log('样品登记表:',ypdjb)
  592. repostCurd('add', '{"tableName":"t_lhypdjb","paramWhere":' + JSON.stringify(ypdjb) + '}')
  593. /* 3、更新样品表
  594. // console.log('3、更新样品表',lhypIdNewList)
  595. repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}').then(res=>{
  596. this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
  597. })
  598. */
  599. console.log('更新样品表',sampleList)
  600. let allSampleParams ={
  601. tableName:'t_lhypb',
  602. updList:sampleList
  603. }
  604. repostCurd('updatesByWhere', JSON.stringify(allSampleParams)).then(res=>{
  605. this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
  606. })
  607. })
  608. })
  609. })
  610. })
  611. }).catch(_ => { });
  612. }
  613. },
  614. /* 去除指定行数据 使用过滤器filter过滤指定行号数据 */
  615. deleteData(val) {
  616. this.listData = this.listData.filter((data) => {
  617. return data.id_ != val
  618. })
  619. },
  620. unique(arr) {
  621. return arr.filter((item, index) => {
  622. return arr.indexOf(item, 0) === index;
  623. });
  624. },
  625. uuid() {
  626. var s = [];
  627. var hexDigits = "0123456789abcdef";
  628. for (var i = 0; i < 36; i++) {
  629. s[i] = hexDigits.substr(Math.floor(Math.random() * 0x10), 1);
  630. }
  631. s[14] = "4"; // bits 12-15 of the time_hi_and_version field to 0010
  632. s[19] = hexDigits.substr((s[19] & 0x3) | 0x8, 1); // bits 6-7 of the clock_seq_hi_and_reserved to 01
  633. s[8] = s[13] = s[18] = s[23] = "-";
  634. var uuid = s.join("");
  635. return uuid;
  636. },
  637. // 根据旧位置数据生成新位置数据
  638. generateNewLocation(oldLocation, sampleInfo) {
  639. // console.log(oldLocation)
  640. let temp = {
  641. fang_jian_lei_xin: oldLocation.fang_jian_lei_xin,
  642. wei_zhi_: oldLocation.wei_zhi_,
  643. qu_yu_: oldLocation.qu_yu_,
  644. huo_jia_lei_xing_: oldLocation.huo_jia_lei_xing_,
  645. huo_jia_hao_: oldLocation.huo_jia_hao_,
  646. ceng_hao_: oldLocation.ceng_hao_,
  647. shui_ping_fen_qu_: oldLocation.shui_ping_fen_qu_,
  648. wei_zhi_bian_hao_: oldLocation.wei_zhi_bian_hao_,
  649. wei_zhi_zhuang_ta: oldLocation.wei_zhi_zhuang_ta,
  650. cun_chu_tiao_jian: oldLocation.cun_chu_tiao_jian,
  651. shi_fou_guo_shen_: '启用',
  652. yang_pin_bian_hao: sampleInfo.yang_pin_bian_hao,
  653. yang_pin_ming_che: sampleInfo.yang_pin_ming_che,
  654. ru_ku_shi_jian_: sampleInfo.ru_ku_shi_jian_,
  655. shi_fou_liu_yang_: sampleInfo.shi_fou_liu_yang_,
  656. biao_zhi_uuid_: sampleInfo.biao_zhi_uuid_,
  657. yang_pin_lei_xing: sampleInfo.type,
  658. liu_yang_shu_lian: sampleInfo.num
  659. }
  660. return temp
  661. },
  662. handleLocationInfo(currentLocation, isLiuYang, localInfo, locationIds, item, UUID, currentTime,sampleType,liuYangNum) {
  663. !locationIds.has(currentLocation) ? locationIds.add(currentLocation) : localInfo.find(i => i.id_ === currentLocation).wei_zhi_zhuang_ta = '占用'
  664. if (localInfo.find(i => i.id_ === currentLocation)!=undefined &&localInfo.find(i => i.id_ === currentLocation).wei_zhi_zhuang_ta === '空余') {
  665. let obj = {
  666. where: {
  667. id_: currentLocation
  668. },
  669. param: {
  670. wei_zhi_zhuang_ta: "占用",
  671. ru_ku_shi_jian_: currentTime,
  672. yang_pin_bian_hao: item.yang_pin_bian_hao,
  673. yang_pin_ming_che: item.yang_pin_ming_che,
  674. shi_fou_liu_yang_: isLiuYang,
  675. yang_pin_lei_xing: sampleType,
  676. liu_yang_shu_lian: liuYangNum == null? '':liuYangNum
  677. }
  678. }
  679. let result = {
  680. name: 'emptyLocation',
  681. value: obj
  682. }
  683. return result
  684. } else { // 新增一条位置信息(修改它的样品编号,样品名称,入库时间,标识UUID)
  685. let sampleInfo = {
  686. yang_pin_bian_hao: item.yang_pin_bian_hao,
  687. yang_pin_ming_che: item.yang_pin_ming_che,
  688. ru_ku_shi_jian_: currentTime,
  689. biao_zhi_uuid_: UUID,
  690. shi_fou_liu_yang_: isLiuYang,
  691. type: sampleType,
  692. num: liuYangNum == null? '':liuYangNum
  693. }
  694. let newLocation = this.generateNewLocation(localInfo.find(i => i.id_ === currentLocation), sampleInfo)
  695. let result = {
  696. name: 'fullLocation',
  697. value: newLocation
  698. }
  699. return result
  700. }
  701. },
  702. /* 关闭*/
  703. remRedar() {
  704. this.visible = false // 列表隐藏
  705. this.listData = [] // 清空列表数据
  706. this.redar = false // 扫码图标隐藏
  707. this.$emit('scanOff', false)
  708. },
  709. }
  710. }