sampleConfirmationJS.js 46 KB

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