sampleConfirmationJS.js 68 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983
  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. const that = this
  30. let flag = true // 重复扫码标志位
  31. for (const index in this.listData) { // 判断是否重复,重复扫码 数量自增
  32. if (this.listData[index].yang_pin_bian_hao == id) {
  33. this.listData[index].jie_yang_shu_lian = parseInt(this.listData[index].jie_yang_shu_lian) + 1
  34. flag = false
  35. }
  36. }
  37. const sql = `select lei_xing_ from t_yplxb`
  38. const sql2 = `select yang_pin_gui_ge_ from t_ypbzggb`
  39. Promise.all([repostCurd('sql', sql), repostCurd('sql', sql2)]).then(([res1, res2]) => {
  40. const data = res1.variables.data
  41. const data2 = res2.variables.data
  42. const types = []
  43. const guiGes = []
  44. data.forEach(item => {
  45. const obj = {
  46. value: item.lei_xing_,
  47. label: item.lei_xing_
  48. }
  49. types.push(obj)
  50. })
  51. data2.forEach(item => {
  52. const o = {
  53. value: item.yang_pin_gui_ge_,
  54. label: item.yang_pin_gui_ge_
  55. }
  56. guiGes.push(o)
  57. })
  58. this.sampleTypes = types
  59. this.sampleSpecifications = guiGes
  60. })
  61. // 扫码扫到新数据,查询 回填展示
  62. if (flag) {
  63. const 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'`
  64. const liuYangSQL = `select liu_yang_qi_xian_ from t_lyqxpzb limit 1`
  65. const cfIDSQL = `select cun_fang_id_,liu_yang_id_ FROM t_ypwzmrxzb`
  66. Promise.all([repostCurd('sql', sql), repostCurd('sql', liuYangSQL), repostCurd('sql', cfIDSQL)]).then((res) => {
  67. const temp = res[0].variables.data
  68. const option = res[1].variables.data[0].liu_yang_qi_xian_
  69. const cfID = res[2].variables.data[0].cun_fang_id_
  70. const lyID = res[2].variables.data[0].liu_yang_id_
  71. that.lylocation = lyID
  72. const rq = options[option]
  73. if (temp) {
  74. temp.forEach(item => {
  75. item.jie_yang_shu_lian = item.yang_pin_zong_shu
  76. item.jie_yang_zhuang_t = '已确认'
  77. item.biao_zhi_uuid_1 = this.uuid()
  78. item.biao_zhi_uuid_2 = this.uuid()
  79. item.biao_zhi_uuid_3 = this.uuid()
  80. item.biao_zhi_uuid_4 = this.uuid()
  81. // item.shi_fou_liu_yang_ = '是'
  82. item.shi_fou_liu_yang_yi = '是'
  83. item.shi_fou_liu_yang_er = '是'
  84. item.shi_fou_liu_yang_san = '是'
  85. item.shi_fou_liu_yang_si = '是'
  86. item.yan_shou_jie_guo_ = '完好'
  87. item.liu_yang_shu_lian_yi = ' ml/支×1支'
  88. item.shou_yang_wei_zhi_yi = cfID
  89. item.liu_yang_wei_zhi_yi = lyID
  90. item.yang_pin_lei_er_
  91. ? (item.liu_yang_shu_lian_er = ' ml/支×1支', item.shou_yang_wei_zhi_er = cfID, item.liu_yang_wei_zhi_er = lyID) : null
  92. item.yang_pin_lei_san_
  93. ? (item.liu_yang_shu_lian_san = ' ml/支×1支', item.shou_yang_wei_zhi_san = cfID, item.liu_yang_wei_zhi_san = lyID) : null
  94. item.yang_pin_lei_si_
  95. ? (item.liu_yang_shu_lian_si = ' ml/支×1支', item.shou_yang_wei_zhi_si = cfID, item.liu_yang_wei_zhi_si = lyID) : null
  96. // item.yang_pin_lei_er_ ? item.liu_yang_shu_lian_er = ' ml/支×1支' : null
  97. // item.yang_pin_lei_san_ ? item.liu_yang_shu_lian_san = ' ml/支×1支' : null
  98. // item.yang_pin_lei_si_ ? item.liu_yang_shu_lian_si = ' ml/支×1支' : null
  99. item.liu_yang_ri_qi_ = new Date(new Date().getTime() + 28800000).toJSON().slice(0, 10).replace('T', ' ')
  100. item.yang_pin_lei_er_ ? this.$set(item, 'flag2', true) : this.$set(item, 'flag2', false)
  101. item.yang_pin_lei_san_ ? this.$set(item, 'flag3', true) : this.$set(item, 'flag3', false)
  102. item.yang_pin_lei_si_ ? this.$set(item, 'flag4', true) : this.$set(item, 'flag4', false)
  103. item.liu_yang_qi_xian = dayjs(item.song_jian_shi_jia).add(rq, 'month').format('YYYY-MM-DD')
  104. item.dan_wei_yi = item.yang_pin_gui_ge_ ? this.handleSpecificationsToUnit(item.yang_pin_gui_ge_) : ''
  105. item.dan_wei_er = item.yang_pin_gui_ge_e ? this.handleSpecificationsToUnit(item.yang_pin_gui_ge_e) : ''
  106. item.dan_wei_san = item.yang_pin_gui_ge_s ? this.handleSpecificationsToUnit(item.yang_pin_gui_ge_s) : ''
  107. item.dan_wei_si = item.yang_pin_gui_si_ ? this.handleSpecificationsToUnit(item.yang_pin_gui_si_) : ''
  108. })
  109. this.listData.push(temp[0])
  110. // console.log(this.listData)
  111. }
  112. })
  113. }
  114. },
  115. /* 列表失去焦点*/
  116. handleChange () {
  117. this.$refs.redarInput.focus() // 聚焦input
  118. },
  119. /* 关闭弹出列表框*/
  120. closeDialog () {
  121. this.remRedar()
  122. // 回传关闭事件。隐藏当前组件。
  123. },
  124. handleClose () {
  125. this.handleChange()
  126. this.$confirm('确认关闭扫码列表页面?').then(_ => {
  127. this.closeDialog()
  128. }).catch(_ => {})
  129. },
  130. handleAnySituation (callBackBool, msg, type) {
  131. this.$emit('callback', callBackBool)
  132. this.visable = false
  133. this.$message({
  134. message: msg,
  135. type: type
  136. })
  137. this.closeDialog()
  138. },
  139. submitData (type) {
  140. // this指针
  141. const this_ = this
  142. // 回传关闭事件。隐藏当前组件。
  143. const judge = true
  144. if (this_.listData.length == 0) {
  145. this.$emit('callback', true)
  146. this.visable = false
  147. this.$message({
  148. message: '暂无样品待接收确认!',
  149. type: 'error'
  150. })
  151. this.closeDialog()
  152. } else {
  153. this.$confirm('请再次确认 [样品接收信息]').then(_ => {
  154. // 获取样品列表
  155. const ypInfoList = this_.listData
  156. // console.log(ypInfoList, "样品信息")
  157. const dWhere = []
  158. const ypbh = []
  159. const ypbhList = [] // 样品编号列表
  160. // 罗湖样品编号列表
  161. const lhypbhList = []
  162. const lhypmcList = []
  163. // 罗湖样品表外键
  164. const lhypbWJ = []
  165. // 罗湖委托表主键
  166. const lhwtbID = []
  167. // 罗湖委托表展示表ID
  168. const lhwtzsbID = []
  169. // 罗湖样品id列表
  170. const lhypIdList = []
  171. // 罗湖样品id格式列表
  172. const lhypIdNewList = []
  173. // 样品所选择的位置ID字符串
  174. let localStr = ''
  175. const locationIds = new Set()
  176. const localArr = []
  177. const sampleList = []
  178. const currentTime = new Date(new Date().getTime() + 28800000).toJSON().slice(0, 16).replace('T', ' ')
  179. const curTime = new Date(new Date().getTime() + 28800000).toJSON().slice(0, 10).replace('T', ' ')
  180. for (const yp in ypInfoList) { // 样品数据
  181. const cfwz = ''
  182. /*
  183. 校验:
  184. 1、样品数量 <= 确认数量
  185. 2、是否留样 => 填收样位置|留样位置
  186. 3、验收结果必填
  187. 4、如果留样 => 必填项:留样日期、留样数量、留样期限至、销毁日期
  188. */
  189. if (ypInfoList[yp].jie_yang_shu_lian > ypInfoList[yp].yang_pin_zong_shu) {
  190. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 接收确认数量不得大于收样数量。')
  191. return
  192. }
  193. if (ypInfoList[yp].jie_yang_zhuang_t == '未确认') {
  194. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 接收确认状态必须为已确认。')
  195. return
  196. }
  197. if (ypInfoList[yp].yan_shou_jie_guo_ == null || ypInfoList[yp].yan_shou_jie_guo_ == '') {
  198. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 验收结果不能为空!')
  199. return
  200. }
  201. /** 如果四个是否留样中有一个为‘是’ 则 留样日期 和对应的留样位置就不能为空 */
  202. if (ypInfoList[yp].shi_fou_liu_yang_yi == '是' ||
  203. (ypInfoList[yp].flag2 == true && ypInfoList[yp].shi_fou_liu_yang_er == '是') ||
  204. (ypInfoList[yp].flag3 == true && ypInfoList[yp].shi_fou_liu_yang_san == '是') ||
  205. (ypInfoList[yp].flag4 == true && ypInfoList[yp].shi_fou_liu_yang_si == '是')) {
  206. if (ypInfoList[yp].liu_yang_ri_qi_ == null || ypInfoList[yp].liu_yang_ri_qi_ == '') {
  207. this_.$message.error('留样时必须填写留样日期!')
  208. return
  209. // this_.handleErrorData("") todo 失效
  210. }
  211. if (ypInfoList[yp].shi_fou_liu_yang_yi == '是') {
  212. // 判断位置是否为空
  213. if (ypInfoList[yp].liu_yang_wei_zhi_yi == null || ypInfoList[yp].liu_yang_wei_zhi_yi == '') {
  214. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的留样位置选择不能为空!')
  215. return
  216. }
  217. if (ypInfoList[yp].liu_yang_shu_lian_yi == null || ypInfoList[yp].liu_yang_shu_lian_yi == '') {
  218. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的留样数量不能为空!')
  219. return
  220. }
  221. }
  222. if (ypInfoList[yp].shi_fou_liu_yang_er == '是') {
  223. if (ypInfoList[yp].flag2 == true) {
  224. if (ypInfoList[yp].liu_yang_wei_zhi_er == '' || ypInfoList[yp].liu_yang_wei_zhi_er == null) {
  225. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的留样位置选择不能为空!')
  226. return
  227. }
  228. if (ypInfoList[yp].liu_yang_shu_lian_er == null || ypInfoList[yp].liu_yang_shu_lian_er == '') {
  229. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的留样数量不能为空!')
  230. return
  231. }
  232. }
  233. }
  234. if (ypInfoList[yp].shi_fou_liu_yang_san == '是') {
  235. if (ypInfoList[yp].flag3 == true) {
  236. if (ypInfoList[yp].liu_yang_wei_zhi_san == '' || ypInfoList[yp].liu_yang_wei_zhi_san == null) {
  237. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的留样位置选择不能为空!')
  238. return
  239. }
  240. if (ypInfoList[yp].liu_yang_shu_lian_san == null || ypInfoList[yp].liu_yang_shu_lian_san == '') {
  241. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的留样数量不能为空!')
  242. return
  243. }
  244. }
  245. }
  246. if (ypInfoList[yp].shi_fou_liu_yang_si == '是') {
  247. if (ypInfoList[yp].flag4 == true) {
  248. if (ypInfoList[yp].liu_yang_wei_zhi_si == '' || ypInfoList[yp].liu_yang_wei_zhi_si == null) {
  249. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的留样位置选择不能为空!')
  250. return
  251. }
  252. if (ypInfoList[yp].liu_yang_shu_lian_si == null || ypInfoList[yp].liu_yang_shu_lian_si == '') {
  253. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的留样数量不能为空!')
  254. return
  255. }
  256. }
  257. }
  258. }
  259. // 判断位置是否为空 且判断单位是否为空
  260. if (ypInfoList[yp].shou_yang_wei_zhi_yi == null || ypInfoList[yp].shou_yang_wei_zhi_yi == '') {
  261. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的位置选择不能为空!')
  262. return
  263. }
  264. if (ypInfoList[yp].dan_wei_yi == null || ypInfoList[yp].dan_wei_yi == '') {
  265. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的单位不能为空!')
  266. return
  267. }
  268. if (ypInfoList[yp].flag2 == true) {
  269. if (ypInfoList[yp].shou_yang_wei_zhi_er == '' || ypInfoList[yp].shou_yang_wei_zhi_er == null) {
  270. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的位置选择不能为空!')
  271. return
  272. }
  273. if (ypInfoList[yp].dan_wei_er == null || ypInfoList[yp].dan_wei_er == '') {
  274. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的单位不能为空!')
  275. return
  276. }
  277. }
  278. if (ypInfoList[yp].flag3 == true) {
  279. if (ypInfoList[yp].shou_yang_wei_zhi_san == '' || ypInfoList[yp].shou_yang_wei_zhi_san == null) {
  280. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的位置选择不能为空!')
  281. return
  282. }
  283. if (ypInfoList[yp].dan_wei_san == null || ypInfoList[yp].dan_wei_san == '') {
  284. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的单位不能为空!')
  285. return
  286. }
  287. }
  288. if (ypInfoList[yp].flag4 == true) {
  289. if (ypInfoList[yp].shou_yang_wei_zhi_si == '' || ypInfoList[yp].shou_yang_wei_zhi_si == null) {
  290. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的位置选择不能为空!')
  291. return
  292. }
  293. if (ypInfoList[yp].dan_wei_si == null || ypInfoList[yp].dan_wei_si == '') {
  294. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的单位不能为空!')
  295. return
  296. }
  297. }
  298. // 判断留样日期不得早于当前日期
  299. if (ypInfoList[yp].liu_yang_ri_qi_ != null && ypInfoList[yp].liu_yang_ri_qi_ != '') {
  300. if (ypInfoList[yp].liu_yang_ri_qi_ < curTime) {
  301. console.log(ypInfoList[yp].liu_yang_ri_qi_, curTime)
  302. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 的留样日期不得早于收样日期!')
  303. return
  304. }
  305. }
  306. // 判断留样期限日期不得早于当前日期
  307. if (ypInfoList[yp].liu_yang_qi_xian != null && ypInfoList[yp].liu_yang_qi_xian != '') {
  308. if (ypInfoList[yp].liu_yang_qi_xian < curTime) {
  309. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 的留样期限日期不得早于收样日期!')
  310. return
  311. }
  312. }
  313. // 判断返样日期不得早于当前日期
  314. if (ypInfoList[yp].fan_yang_ri_qi_ != null && ypInfoList[yp].fan_yang_ri_qi_ != '') {
  315. if (ypInfoList[yp].fan_yang_ri_qi_ < curTime) {
  316. this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 的返样日期不得早于收样日期!')
  317. return
  318. }
  319. }
  320. ypbhList.push('{"yang_pin_bian_hao":"' + ypInfoList[yp].yang_pin_bian_hao + '"}') // 样品编号列表
  321. // 罗湖
  322. dWhere.push('{"id_":"' + cfwz + '"}')
  323. lhypbhList.push(ypInfoList[yp].yang_pin_bian_hao)
  324. lhypbWJ.push(ypInfoList[yp].parent_id_)
  325. lhypIdList.push(ypInfoList[yp].id_)
  326. lhypIdNewList.push('{"id_":"' + ypInfoList[yp].id_ + '"}')
  327. ypbh.push(ypInfoList[yp].yang_pin_bian_hao)
  328. lhypmcList.push(ypInfoList[yp].yang_pin_ming_che)
  329. localArr.push(
  330. ypInfoList[yp].shou_yang_wei_zhi_yi, ypInfoList[yp].liu_yang_wei_zhi_yi,
  331. ypInfoList[yp].shou_yang_wei_zhi_er, ypInfoList[yp].liu_yang_wei_zhi_er,
  332. ypInfoList[yp].shou_yang_wei_zhi_san, ypInfoList[yp].liu_yang_wei_zhi_san,
  333. ypInfoList[yp].shou_yang_wei_zhi_si, ypInfoList[yp].liu_yang_wei_zhi_si
  334. )
  335. const o = {
  336. where: {
  337. id_: ypInfoList[yp].id_
  338. },
  339. param: {
  340. yang_pin_lei_xing: ypInfoList[yp].yang_pin_lei_xing,
  341. yang_ben_yun_shu_: ypInfoList[yp].yang_ben_yun_shu_,
  342. shu_liang_: ypInfoList[yp].shu_liang_,
  343. yang_pin_gui_ge_: ypInfoList[yp].yang_pin_gui_ge_,
  344. yang_pin_lei_er_: ypInfoList[yp].yang_pin_lei_er_,
  345. yang_pin_yun_shu_: ypInfoList[yp].yang_pin_yun_shu_,
  346. shu_liang_er_: ypInfoList[yp].shu_liang_er_,
  347. yang_pin_gui_ge_e: ypInfoList[yp].yang_pin_gui_ge_e,
  348. yang_pin_lei_san_: ypInfoList[yp].yang_pin_lei_san_,
  349. yang_pin_yun_san: ypInfoList[yp].yang_pin_yun_san,
  350. shu_liang_san_: ypInfoList[yp].shu_liang_san_,
  351. yang_pin_gui_ge_s: ypInfoList[yp].yang_pin_gui_ge_s,
  352. yang_pin_lei_si_: ypInfoList[yp].yang_pin_lei_si_,
  353. yang_pin_yun_si_: ypInfoList[yp].yang_pin_yun_si_,
  354. shu_liang_si_: ypInfoList[yp].shu_liang_si_,
  355. yang_pin_gui_si_: ypInfoList[yp].yang_pin_gui_si_,
  356. jie_yang_zhuang_t: '已接收',
  357. yang_pin_zong_shu: ypInfoList[yp].yang_pin_zong_shu,
  358. bei_zhu_1_: ypInfoList[yp].bei_zhu_1_
  359. }
  360. }
  361. sampleList.push(o)
  362. }
  363. localStr = localArr.filter(i => i).join(',')
  364. let value = ''
  365. let lhypIdStr = ''
  366. for (let i = 0; i < lhypbWJ.length; i++) {
  367. value += lhypbWJ[i] + ','
  368. }
  369. value = value.substring(0, value.length - 1)
  370. value = value.replace(/,/g, "','")
  371. for (let i = 0; i < lhypIdList.length; i++) {
  372. lhypIdStr += lhypIdList[i] + ','
  373. }
  374. lhypIdStr = lhypIdStr.substring(0, lhypIdStr.length - 1)
  375. lhypIdStr = lhypIdStr.replace(/,/g, "','")
  376. const 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}')`
  377. // console.log(allSQL)
  378. // 搜集所有选择的位置信息
  379. // console.log('当前选择的位置ids:',locationIds)
  380. var allLocal = `select * from t_ypcfwz where find_in_set(id_,'${localStr}')`
  381. Promise.all([repostCurd('sql', allSQL), repostCurd('sql', allLocal)]).then((res) => {
  382. const initResult = res[0].variables.data
  383. const result = []
  384. const localInfo = res[1].variables.data
  385. // 排序
  386. ypInfoList.forEach(item => {
  387. result.push(initResult.find(i => i.yang_pin_bian_hao === item.yang_pin_bian_hao))
  388. })
  389. // console.log(localInfo)
  390. /* 1、更新货架位置信息 */
  391. this.emptyLocal = []
  392. this.fullLocal = []
  393. const allUUID = []
  394. ypInfoList.forEach(item => {
  395. allUUID.push(item.biao_zhi_uuid_1, item.biao_zhi_uuid_2, item.biao_zhi_uuid_3, item.biao_zhi_uuid_4)
  396. const allResult = []
  397. if (item.shou_yang_wei_zhi_yi != undefined && item.shou_yang_wei_zhi_yi) {
  398. 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))
  399. }
  400. if (item.shou_yang_wei_zhi_er != undefined && item.shou_yang_wei_zhi_er) {
  401. 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))
  402. }
  403. if (item.shou_yang_wei_zhi_san != undefined && item.shou_yang_wei_zhi_san) {
  404. 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))
  405. }
  406. if (item.shou_yang_wei_zhi_si != undefined && item.shou_yang_wei_zhi_si) {
  407. 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))
  408. }
  409. if (item.liu_yang_wei_zhi_yi != undefined && item.liu_yang_wei_zhi_yi && item.shi_fou_liu_yang_yi === '是') {
  410. 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))
  411. }
  412. if (item.liu_yang_wei_zhi_er != undefined && item.liu_yang_wei_zhi_er && item.shi_fou_liu_yang_er === '是') {
  413. 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))
  414. }
  415. if (item.liu_yang_wei_zhi_san != undefined && item.liu_yang_wei_zhi_san && item.shi_fou_liu_yang_san === '是') {
  416. 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))
  417. }
  418. if (item.liu_yang_wei_zhi_si != undefined && item.liu_yang_wei_zhi_si && item.shi_fou_liu_yang_si === '是') {
  419. 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))
  420. }
  421. allResult.forEach(item => {
  422. item.name === 'emptyLocation' ? this.emptyLocal.push(item.value) : this.fullLocal.push(item.value)
  423. })
  424. })
  425. const allUUIDStr = allUUID.filter(i => i).join(',')
  426. // 更新样品位置list
  427. // console.log('emptyLocal:',this.emptyLocal)
  428. if (this.emptyLocal.length > 0) {
  429. const allParams = {
  430. tableName: 't_ypcfwz',
  431. updList: this.emptyLocal
  432. }
  433. repostCurd('updatesByWhere', JSON.stringify(allParams))
  434. }
  435. // 插入样品位置list
  436. console.log('fullLocal:', this.fullLocal)
  437. if (this.fullLocal.length == 0) {
  438. /* 2、封装样品登记表对象,插入样品登记表 顺便封装任务分配表 */
  439. const ypdjb = []
  440. const rws = []
  441. console.log(result)
  442. console.log(ypInfoList)
  443. result.forEach((item, index) => {
  444. // 2-1:统计每个样品有多少类型[数量]
  445. const lxList = []
  446. const ypggList = []
  447. const liuYangList = []
  448. 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_)
  449. ypggList.push(
  450. ypInfoList[index].yang_pin_gui_ge_ ? ypInfoList[index].yang_pin_gui_ge_ + '*' + ypInfoList[index].shu_liang_ + ypInfoList[index].dan_wei_yi : '',
  451. ypInfoList[index].yang_pin_gui_ge_e ? ypInfoList[index].yang_pin_gui_ge_e + '*' + ypInfoList[index].shu_liang_er_ + ypInfoList[index].dan_wei_er : '',
  452. ypInfoList[index].yang_pin_gui_ge_s ? ypInfoList[index].yang_pin_gui_ge_s + '*' + ypInfoList[index].shu_liang_san_ + ypInfoList[index].dan_wei_san : '',
  453. ypInfoList[index].yang_pin_gui_si_ ? ypInfoList[index].yang_pin_gui_si_ + '*' + ypInfoList[index].shu_liang_si_ + ypInfoList[index].dan_wei_si : '')
  454. 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)
  455. const yplxz = lxList.filter(i => i).join(';')
  456. const ypggStr = ypggList.filter(i => i).join(';')
  457. const liuyangStr = liuYangList.filter(i => i).join(';')
  458. // let count = lxList.filter(i => i).join(',').match(/,/g).length + 1
  459. // let size = lxList.filter(i => i).join(',').match(/,/g)
  460. // let count = 1
  461. // size == null ? count = 1 : count = size.length + 1
  462. const xmmc = []
  463. const xmid = []
  464. xmmc.push(item.chang_gui_xiang_m, item.tao_can_ming_chen)
  465. xmid.push(item.jian_ce_xiang_mu_, item.tao_can_xiang_mu_)
  466. let xiangMuZh = xiangMuZh = xmmc.filter(i => i).join(',')
  467. let xiangMuId = xiangMuId = xmid.filter(i => i).join(',')
  468. for (let c = 0; c < 4; c++) {
  469. const yblx = c == 0 ? ypInfoList[index].yang_pin_lei_xing
  470. : c == 1 ? ypInfoList[index].yang_pin_lei_er_
  471. : c == 2 ? ypInfoList[index].yang_pin_lei_san_
  472. : c == 3 ? ypInfoList[index].yang_pin_lei_si_ : ''
  473. // fix样品类型不按顺序进行填写
  474. if (!yblx) {
  475. console.log('current', c)
  476. continue
  477. }
  478. const ystj = c == 0 ? ypInfoList[index].yang_ben_yun_shu_
  479. : c == 1 ? ypInfoList[index].yang_pin_yun_shu_
  480. : c == 2 ? ypInfoList[index].yang_pin_yun_san
  481. : c == 3 ? ypInfoList[index].yang_pin_yun_si_ : ''
  482. const ypsl = c == 0 ? ypInfoList[index].shu_liang_
  483. : c == 1 ? ypInfoList[index].shu_liang_er_
  484. : c == 2 ? ypInfoList[index].shu_liang_san_
  485. : c == 3 ? ypInfoList[index].shu_liang_si_ : ''
  486. const ybgg = c == 0 ? ypInfoList[index].yang_pin_gui_ge_
  487. : c == 1 ? ypInfoList[index].yang_pin_gui_ge_e
  488. : c == 2 ? ypInfoList[index].yang_pin_gui_ge_s
  489. : c == 3 ? ypInfoList[index].yang_pin_gui_si_ : ''
  490. const sywz = c == 0 ? ypInfoList[index].shou_yang_wei_zhi_yi
  491. : c == 1 ? ypInfoList[index].shou_yang_wei_zhi_er
  492. : c == 2 ? ypInfoList[index].shou_yang_wei_zhi_san
  493. : c == 3 ? ypInfoList[index].shou_yang_wei_zhi_si : ''
  494. const lycf = c == 0 ? ypInfoList[index].liu_yang_wei_zhi_yi
  495. : c == 1 ? ypInfoList[index].liu_yang_wei_zhi_er
  496. : c == 2 ? ypInfoList[index].liu_yang_wei_zhi_san
  497. : c == 3 ? ypInfoList[index].liu_yang_wei_zhi_si : ''
  498. const lysl = c == 0 ? ypInfoList[index].liu_yang_shu_lian_yi
  499. : c == 1 ? ypInfoList[index].liu_yang_shu_lian_er
  500. : c == 2 ? ypInfoList[index].liu_yang_shu_lian_san
  501. : c == 3 ? ypInfoList[index].liu_yang_shu_lian_si : ''
  502. const currentUUID = c == 0 ? ypInfoList[index].biao_zhi_uuid_1
  503. : c == 1 ? ypInfoList[index].biao_zhi_uuid_2
  504. : c == 2 ? ypInfoList[index].biao_zhi_uuid_3
  505. : c == 3 ? ypInfoList[index].biao_zhi_uuid_4 : ''
  506. const ifLy = c == 0 ? ypInfoList[index].shi_fou_liu_yang_yi
  507. : c == 1 ? ypInfoList[index].shi_fou_liu_yang_er
  508. : c == 2 ? ypInfoList[index].shi_fou_liu_yang_san
  509. : c == 3 ? ypInfoList[index].shi_fou_liu_yang_si : ''
  510. const obj = {
  511. wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
  512. wei_tuo_dan_wei_: item.wtdh,
  513. lian_xi_ren_: item.wei_tuo_fang_lian,
  514. lian_xi_dian_hua_: item.wei_tuo_lian,
  515. yang_ben_ming_che: item.yang_pin_ming_che,
  516. yang_ben_bian_hao: item.yang_pin_bian_hao,
  517. pi_hao_bian_hao_: item.song_jian_pi_hao_,
  518. song_jian_dan_wei: item.song_jian_dan_wei,
  519. xing_ming_: ypInfoList[index].xing_ming_ || '',
  520. xing_bie_: ypInfoList[index].xing_bie_ || '',
  521. nian_ling_: ypInfoList[index].nian_ling_ || '',
  522. yang_ben_zhuang_t: item.yang_pin_zhuang_t,
  523. shou_yang_ri_qi_: currentTime,
  524. bei_zhu_: ypInfoList[index].bei_zhu_1_ || '',
  525. yang_ben_lei_xing: yblx,
  526. yun_shu_tiao_jian: ystj,
  527. yang_pin_shu_lian: ypsl,
  528. yang_ben_gui_ge_s: ybgg,
  529. yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
  530. cun_fang_wei_zhi_: sywz || '',
  531. liu_zhuan_zhuang_: '待任务分配',
  532. shi_fou_liu_yang_: ifLy,
  533. liu_yang_ri_qi_: ifLy == '是' ? ypInfoList[index].liu_yang_ri_qi_ : '',
  534. liu_yang_cun_fang: ifLy == '是' ? (lycf || '') : '',
  535. liu_yang_shu_lian: ifLy == '是' ? (lysl == null ? '' : lysl) : '',
  536. liu_yang_qi_xian: ifLy == '是' ? ypInfoList[index].liu_yang_qi_xian : '',
  537. xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_ || '',
  538. fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_ || '',
  539. fan_yang_jyr: ypInfoList[index].fan_yang_jyr || '',
  540. biao_zhi_uuid_: currentUUID,
  541. song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu || '',
  542. jian_ce_xiang_mu_: xiangMuZh,
  543. shou_yang_ren_: this.$store.getters.userInfo.user.name,
  544. wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
  545. jian_ce_xiang_mu_id: xiangMuId
  546. }
  547. // console.log(obj)
  548. ypdjb.push(obj)
  549. }
  550. // 2-2:封装任务分配表
  551. const rw = {
  552. yang_pin_ming_che: item.yang_pin_ming_che,
  553. yang_pin_bian_hao: item.yang_pin_bian_hao,
  554. wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
  555. yang_pin_lei_xing: yplxz,
  556. yang_pin_gui_ge_: ypggStr,
  557. wei_tuo_id_: item.wtID,
  558. he_tong_id_: item.he_tong_id_,
  559. zhuang_tai_: '待任务分配',
  560. wan_cheng_shi_jia: item.song_jian_shi_jia,
  561. shou_yang_ri_qi_: currentTime,
  562. bao_gao_lei_xing_: item.bao_gao_lei_xing_,
  563. xin_xiang_mu_ming: item.xiang_mu_ming_che,
  564. zhan_shi_biao_id_: item.zhan_shi_biao_id_,
  565. fen_zhuang_liu_ya: liuyangStr,
  566. shi_fou_jia_ji_: item.chu_ju_bao_gao_ya, // 是否加急【2023/2/23王提出】
  567. yang_pin_shu_lian: ypInfoList[index].jie_yang_shu_lian, // 样品确认总数【2023/3/7王提出】
  568. suo_you_xiang_mu_: xiangMuZh, // 所有项目的中文名称 【2023/12/11 Mr王】
  569. song_jian_pi_hao_: item.song_jian_pi_hao_// 送检批号 【2023/12/11 Mr王】
  570. }
  571. rws.push(rw)
  572. lhwtzsbID.push('{"shen_qing_id_":"' + item.zhan_shi_biao_id_ + '"}')
  573. lhwtbID.push('{"id_":"' + item.wtID + '"}')
  574. })
  575. /* 4、任务分配
  576. 4-1、根据 wtdAndYpb 的 wtID 更改委托表的 委托状态 wei_tuo_zhuang_ta 变成 已完成
  577. 4-2、根据每个样品一个任务分配流程 遍历样品表开任务分配流程
  578. 4-3、委托表找zhan_shi_biao_id_ 修改 t_lhwtzsb "zhuang_tai_"为"任务分配进行中"
  579. 优化:将其他不冲突的更改状态脚本放在任务分配后并行处理
  580. */
  581. // console.log("4、任务分配",rws) 2023/12/11 Mr王 去掉 ,"defKey":"Process_04o0csc","formKey":"lhrwfp"
  582. repostCurd('add', '{"tableName":"t_lhrwfpb","paramWhere":' + JSON.stringify(rws) + '}').then(res => {
  583. // console.log('4、更改委托表的 委托状态',lhwtbID)
  584. repostCurd('updates', '{"tableName":"t_lhwtsqb","paramWhere":[' + lhwtbID + '],"paramCond":{"wei_tuo_zhuang_ta":"已完成"}}')
  585. /* 5、更新展示表 */
  586. if (lhwtzsbID.length > 0) {
  587. // console.log('5、更新展示表',lhwtzsbID)
  588. repostCurd('updates', '{"tableName":"t_lhwtzsb","paramWhere":[' + lhwtzsbID + '],"paramCond":{"zhuang_tai_":"任务分配进行中"}}')
  589. }
  590. console.log('样品登记表:', ypdjb)
  591. if (ypdjb.length > 0) {
  592. this.ypdjbData(ypdjb)
  593. // repostCurd('add', '{"tableName":"t_lhypdjb","paramWhere":' + JSON.stringify(ypdjb) + '}').then(()=>{
  594. // console.log("样品登记表数据添加成功!")
  595. // this.$emit('callback', true)
  596. // }).catch(error =>{
  597. // console.log(error)
  598. // this.handleAnySituation(true,"样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决",'error')
  599. // })
  600. } else {
  601. this.handleAnySituation(true, '样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决', 'error')
  602. }
  603. /* 3、更新样品表
  604. // console.log('3、更新样品表',lhypIdNewList)
  605. repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}').then(res=>{
  606. this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
  607. })
  608. */
  609. console.log('更新样品表', sampleList)
  610. const allSampleParams = {
  611. tableName: 't_lhypb',
  612. updList: sampleList
  613. }
  614. repostCurd('updatesByWhere', JSON.stringify(allSampleParams)).then(res => {
  615. this.handleAnySituation(true, '样品成功接收,正在开启任务分配!', 'success')
  616. })
  617. })
  618. } else {
  619. repostCurd('add', '{"tableName":"t_ypcfwz","paramWhere":' + JSON.stringify(this.fullLocal) + '}').then(res => {
  620. // 再次查询位置表,对比当前样品列表 替换初始值为占用的样品位置id
  621. const findLocationAgain = `select id_,shi_fou_liu_yang_,biao_zhi_uuid_ from t_ypcfwz where find_in_set(biao_zhi_uuid_,'${allUUIDStr}')`
  622. // console.log(findLocationAgain)
  623. repostCurd('sql', findLocationAgain).then(res => {
  624. const data = res.variables.data
  625. const uuidArgs = ['biao_zhi_uuid_1', 'biao_zhi_uuid_2', 'biao_zhi_uuid_3', 'biao_zhi_uuid_4']
  626. const shouYangArgs = ['shou_yang_wei_zhi_yi', 'shou_yang_wei_zhi_er', 'shou_yang_wei_zhi_san', 'shou_yang_wei_zhi_si']
  627. const liuYangArgs = ['liu_yang_wei_zhi_yi', 'liu_yang_wei_zhi_er', 'liu_yang_wei_zhi_san', 'liu_yang_wei_zhi_si']
  628. data.forEach(item => {
  629. uuidArgs.forEach((uuid, index) => {
  630. const ypIndex = ypInfoList.findIndex(i => i[uuid] === item.biao_zhi_uuid_)
  631. if (ypIndex != -1) {
  632. item.shi_fou_liu_yang_ === '否'
  633. ? ypInfoList[ypIndex][shouYangArgs[index]] = item.id_
  634. : ypInfoList[ypIndex][liuYangArgs[index]] = item.id_
  635. }
  636. })
  637. })
  638. // repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}')
  639. /* 2、封装样品登记表对象,插入样品登记表 顺便封装任务分配表 */
  640. const ypdjb = []
  641. const rws = []
  642. console.log(result)
  643. console.log(ypInfoList)
  644. result.forEach((item, index) => {
  645. // 2-1:统计每个样品有多少类型[数量]
  646. const lxList = []
  647. const ypggList = []
  648. const liuYangList = []
  649. 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_)
  650. ypggList.push(
  651. ypInfoList[index].yang_pin_gui_ge_ ? ypInfoList[index].yang_pin_gui_ge_ + '*' + ypInfoList[index].shu_liang_ + ypInfoList[index].dan_wei_yi : '',
  652. ypInfoList[index].yang_pin_gui_ge_e ? ypInfoList[index].yang_pin_gui_ge_e + '*' + ypInfoList[index].shu_liang_er_ + ypInfoList[index].dan_wei_er : '',
  653. ypInfoList[index].yang_pin_gui_ge_s ? ypInfoList[index].yang_pin_gui_ge_s + '*' + ypInfoList[index].shu_liang_san_ + ypInfoList[index].dan_wei_san : '',
  654. ypInfoList[index].yang_pin_gui_si_ ? ypInfoList[index].yang_pin_gui_si_ + '*' + ypInfoList[index].shu_liang_si_ + ypInfoList[index].dan_wei_si : '')
  655. 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)
  656. const yplxz = lxList.filter(i => i).join(';')
  657. const ypggStr = ypggList.filter(i => i).join(';')
  658. const liuyangStr = liuYangList.filter(i => i).join(';')
  659. // let count = lxList.filter(i => i).join(',').match(/,/g).length + 1
  660. // let size = lxList.filter(i => i).join(',').match(/,/g)
  661. // let count = 1
  662. // size == null ? count = 1 : count = size.length + 1
  663. const xmmc = []
  664. const xmid = []
  665. xmmc.push(item.chang_gui_xiang_m, item.tao_can_ming_chen)
  666. xmid.push(item.jian_ce_xiang_mu_, item.tao_can_xiang_mu_)
  667. let xiangMuZh = xiangMuZh = xmmc.filter(i => i).join(',')
  668. let xiangMuId = xiangMuId = xmid.filter(i => i).join(',')
  669. for (let c = 0; c < 4; c++) {
  670. const yblx = c == 0 ? ypInfoList[index].yang_pin_lei_xing
  671. : c == 1 ? ypInfoList[index].yang_pin_lei_er_
  672. : c == 2 ? ypInfoList[index].yang_pin_lei_san_
  673. : c == 3 ? ypInfoList[index].yang_pin_lei_si_ : ''
  674. // fix样品类型不按顺序进行填写
  675. if (!yblx) {
  676. console.log('current', c)
  677. continue
  678. }
  679. const ystj = c == 0 ? ypInfoList[index].yang_ben_yun_shu_
  680. : c == 1 ? ypInfoList[index].yang_pin_yun_shu_
  681. : c == 2 ? ypInfoList[index].yang_pin_yun_san
  682. : c == 3 ? ypInfoList[index].yang_pin_yun_si_ : ''
  683. const ypsl = c == 0 ? ypInfoList[index].shu_liang_
  684. : c == 1 ? ypInfoList[index].shu_liang_er_
  685. : c == 2 ? ypInfoList[index].shu_liang_san_
  686. : c == 3 ? ypInfoList[index].shu_liang_si_ : ''
  687. const ybgg = c == 0 ? ypInfoList[index].yang_pin_gui_ge_
  688. : c == 1 ? ypInfoList[index].yang_pin_gui_ge_e
  689. : c == 2 ? ypInfoList[index].yang_pin_gui_ge_s
  690. : c == 3 ? ypInfoList[index].yang_pin_gui_si_ : ''
  691. const sywz = c == 0 ? ypInfoList[index].shou_yang_wei_zhi_yi
  692. : c == 1 ? ypInfoList[index].shou_yang_wei_zhi_er
  693. : c == 2 ? ypInfoList[index].shou_yang_wei_zhi_san
  694. : c == 3 ? ypInfoList[index].shou_yang_wei_zhi_si : ''
  695. const lycf = c == 0 ? ypInfoList[index].liu_yang_wei_zhi_yi
  696. : c == 1 ? ypInfoList[index].liu_yang_wei_zhi_er
  697. : c == 2 ? ypInfoList[index].liu_yang_wei_zhi_san
  698. : c == 3 ? ypInfoList[index].liu_yang_wei_zhi_si : ''
  699. const lysl = c == 0 ? ypInfoList[index].liu_yang_shu_lian_yi
  700. : c == 1 ? ypInfoList[index].liu_yang_shu_lian_er
  701. : c == 2 ? ypInfoList[index].liu_yang_shu_lian_san
  702. : c == 3 ? ypInfoList[index].liu_yang_shu_lian_si : ''
  703. const currentUUID = c == 0 ? ypInfoList[index].biao_zhi_uuid_1
  704. : c == 1 ? ypInfoList[index].biao_zhi_uuid_2
  705. : c == 2 ? ypInfoList[index].biao_zhi_uuid_3
  706. : c == 3 ? ypInfoList[index].biao_zhi_uuid_4 : ''
  707. const ifLy = c == 0 ? ypInfoList[index].shi_fou_liu_yang_yi
  708. : c == 1 ? ypInfoList[index].shi_fou_liu_yang_er
  709. : c == 2 ? ypInfoList[index].shi_fou_liu_yang_san
  710. : c == 3 ? ypInfoList[index].shi_fou_liu_yang_si : ''
  711. const obj = {
  712. wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
  713. wei_tuo_dan_wei_: item.wtdh,
  714. lian_xi_ren_: item.wei_tuo_fang_lian,
  715. lian_xi_dian_hua_: item.wei_tuo_lian,
  716. yang_ben_ming_che: item.yang_pin_ming_che,
  717. yang_ben_bian_hao: item.yang_pin_bian_hao,
  718. pi_hao_bian_hao_: item.song_jian_pi_hao_,
  719. song_jian_dan_wei: item.song_jian_dan_wei,
  720. xing_ming_: ypInfoList[index].xing_ming_ || '',
  721. xing_bie_: ypInfoList[index].xing_bie_ || '',
  722. nian_ling_: ypInfoList[index].nian_ling_ || '',
  723. yang_ben_zhuang_t: item.yang_pin_zhuang_t,
  724. shou_yang_ri_qi_: currentTime,
  725. bei_zhu_: ypInfoList[index].bei_zhu_1_ || '',
  726. yang_ben_lei_xing: yblx,
  727. yun_shu_tiao_jian: ystj,
  728. yang_pin_shu_lian: ypsl,
  729. yang_ben_gui_ge_s: ybgg,
  730. yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
  731. cun_fang_wei_zhi_: sywz || '',
  732. liu_zhuan_zhuang_: '待任务分配',
  733. shi_fou_liu_yang_: ifLy,
  734. liu_yang_ri_qi_: ifLy == '是' ? ypInfoList[index].liu_yang_ri_qi_ : '',
  735. liu_yang_cun_fang: ifLy == '是' ? (lycf || '') : '',
  736. liu_yang_shu_lian: ifLy == '是' ? (lysl == null ? '' : lysl) : '',
  737. liu_yang_qi_xian: ifLy == '是' ? ypInfoList[index].liu_yang_qi_xian : '',
  738. xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_ || '',
  739. fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_ || '',
  740. fan_yang_jyr: ypInfoList[index].fan_yang_jyr || '',
  741. biao_zhi_uuid_: currentUUID,
  742. song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu || '',
  743. jian_ce_xiang_mu_: xiangMuZh,
  744. shou_yang_ren_: this.$store.getters.userInfo.user.name,
  745. wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
  746. jian_ce_xiang_mu_id: xiangMuId
  747. }
  748. // console.log(obj)
  749. ypdjb.push(obj)
  750. }
  751. // 2-2:封装任务分配表
  752. const rw = {
  753. yang_pin_ming_che: item.yang_pin_ming_che,
  754. yang_pin_bian_hao: item.yang_pin_bian_hao,
  755. wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
  756. yang_pin_lei_xing: yplxz,
  757. yang_pin_gui_ge_: ypggStr,
  758. wei_tuo_id_: item.wtID,
  759. he_tong_id_: item.he_tong_id_,
  760. zhuang_tai_: '待任务分配',
  761. wan_cheng_shi_jia: item.song_jian_shi_jia,
  762. shou_yang_ri_qi_: currentTime,
  763. bao_gao_lei_xing_: item.bao_gao_lei_xing_,
  764. xin_xiang_mu_ming: item.xiang_mu_ming_che,
  765. zhan_shi_biao_id_: item.zhan_shi_biao_id_,
  766. fen_zhuang_liu_ya: liuyangStr,
  767. shi_fou_jia_ji_: item.chu_ju_bao_gao_ya, // 是否加急【2023/2/23王嘎嘎提出】
  768. yang_pin_shu_lian: ypInfoList[index].jie_yang_shu_lian, // 样品确认总数【2023/3/7王嘎嘎提出】
  769. suo_you_xiang_mu_: xiangMuZh, // 所有项目的中文名称 【2023/12/11 Mr王】
  770. song_jian_pi_hao_: item.song_jian_pi_hao_// 送检批号 【2023/12/11 Mr王】
  771. }
  772. rws.push(rw)
  773. lhwtzsbID.push('{"shen_qing_id_":"' + item.zhan_shi_biao_id_ + '"}')
  774. lhwtbID.push('{"id_":"' + item.wtID + '"}')
  775. })
  776. /* 4、任务分配
  777. 4-1、根据 wtdAndYpb 的 wtID 更改委托表的 委托状态 wei_tuo_zhuang_ta 变成 已完成
  778. 4-2、根据每个样品一个任务分配流程 遍历样品表开任务分配流程
  779. 4-3、委托表找zhan_shi_biao_id_ 修改 t_lhwtzsb "zhuang_tai_"为"任务分配进行中"
  780. 优化:将其他不冲突的更改状态脚本放在任务分配后并行处理
  781. */
  782. // console.log("4、任务分配",rws) 2023/12/11 Mr王 去掉 ,"defKey":"Process_04o0csc","formKey":"lhrwfp"
  783. repostCurd('add', '{"tableName":"t_lhrwfpb","paramWhere":' + JSON.stringify(rws) + '}').then(res => {
  784. // console.log('4、更改委托表的 委托状态',lhwtbID)
  785. repostCurd('updates', '{"tableName":"t_lhwtsqb","paramWhere":[' + lhwtbID + '],"paramCond":{"wei_tuo_zhuang_ta":"已完成"}}')
  786. /* 5、更新展示表 */
  787. if (lhwtzsbID.length > 0) {
  788. // console.log('5、更新展示表',lhwtzsbID)
  789. repostCurd('updates', '{"tableName":"t_lhwtzsb","paramWhere":[' + lhwtzsbID + '],"paramCond":{"zhuang_tai_":"任务分配进行中"}}')
  790. }
  791. console.log('样品登记表:', ypdjb)
  792. if (ypdjb.length > 0) {
  793. this.ypdjbData(ypdjb)
  794. // repostCurd('add', '{"tableName":"t_lhypdjb","paramWhere":' + JSON.stringify(ypdjb) + '}').then(()=>{
  795. // console.log("样品登记表数据添加成功!")
  796. // this.$emit('callback', true)
  797. // }).catch(error =>{
  798. // console.log(error)
  799. // this.handleAnySituation(true,"样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决",'error')
  800. // })
  801. } else {
  802. this.handleAnySituation(true, '样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决', 'error')
  803. }
  804. /* 3、更新样品表
  805. // console.log('3、更新样品表',lhypIdNewList)
  806. repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}').then(res=>{
  807. this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
  808. })
  809. */
  810. console.log('更新样品表', sampleList)
  811. const allSampleParams = {
  812. tableName: 't_lhypb',
  813. updList: sampleList
  814. }
  815. repostCurd('updatesByWhere', JSON.stringify(allSampleParams)).then(res => {
  816. this.handleAnySituation(true, '样品成功接收,正在开启任务分配!', 'success')
  817. })
  818. })
  819. })
  820. })
  821. }
  822. })
  823. }).catch(_ => { })
  824. }
  825. },
  826. /* 去除指定行数据 使用过滤器filter过滤指定行号数据 */
  827. deleteData (val) {
  828. this.listData = this.listData.filter((data) => {
  829. return data.id_ != val
  830. })
  831. },
  832. uuid () {
  833. var s = []
  834. var hexDigits = '0123456789abcdef'
  835. for (var i = 0; i < 36; i++) {
  836. s[i] = hexDigits.substr(Math.floor(Math.random() * 0x10), 1)
  837. }
  838. s[14] = '4' // bits 12-15 of the time_hi_and_version field to 0010
  839. s[19] = hexDigits.substr((s[19] & 0x3) | 0x8, 1) // bits 6-7 of the clock_seq_hi_and_reserved to 01
  840. s[8] = s[13] = s[18] = s[23] = '-'
  841. var uuid = s.join('')
  842. return uuid
  843. },
  844. unique (arr) {
  845. return arr.filter((item, index) => {
  846. return arr.indexOf(item, 0) === index
  847. })
  848. },
  849. // 根据旧位置数据生成新位置数据
  850. generateNewLocation (oldLocation, sampleInfo) {
  851. const temp = {
  852. fang_jian_lei_xin: oldLocation.fang_jian_lei_xin,
  853. wei_zhi_: oldLocation.wei_zhi_,
  854. qu_yu_: oldLocation.qu_yu_,
  855. huo_jia_lei_xing_: oldLocation.huo_jia_lei_xing_,
  856. huo_jia_hao_: oldLocation.huo_jia_hao_,
  857. ceng_hao_: oldLocation.ceng_hao_,
  858. shui_ping_fen_qu_: oldLocation.shui_ping_fen_qu_,
  859. wei_zhi_bian_hao_: oldLocation.wei_zhi_bian_hao_,
  860. wei_zhi_zhuang_ta: oldLocation.wei_zhi_zhuang_ta,
  861. cun_chu_tiao_jian: oldLocation.cun_chu_tiao_jian,
  862. shi_fou_guo_shen_: '启用',
  863. yang_pin_bian_hao: sampleInfo.yang_pin_bian_hao,
  864. yang_pin_ming_che: sampleInfo.yang_pin_ming_che,
  865. ru_ku_shi_jian_: sampleInfo.ru_ku_shi_jian_,
  866. shi_fou_liu_yang_: sampleInfo.shi_fou_liu_yang_,
  867. biao_zhi_uuid_: sampleInfo.biao_zhi_uuid_,
  868. yang_pin_lei_xing: sampleInfo.type,
  869. liu_yang_shu_lian: sampleInfo.num
  870. }
  871. return temp
  872. },
  873. handleLocationInfo (currentLocation, isLiuYang, localInfo, locationIds, item, UUID, currentTime, sampleType, liuYangNum) {
  874. !locationIds.has(currentLocation) ? locationIds.add(currentLocation) : localInfo.find(i => i.id_ === currentLocation).wei_zhi_zhuang_ta = '占用'
  875. if (localInfo.find(i => i.id_ === currentLocation) != undefined && localInfo.find(i => i.id_ === currentLocation).wei_zhi_zhuang_ta === '空余') {
  876. const obj = {
  877. where: {
  878. id_: currentLocation
  879. },
  880. param: {
  881. wei_zhi_zhuang_ta: '占用',
  882. ru_ku_shi_jian_: currentTime,
  883. yang_pin_bian_hao: item.yang_pin_bian_hao,
  884. yang_pin_ming_che: item.yang_pin_ming_che,
  885. shi_fou_liu_yang_: isLiuYang,
  886. yang_pin_lei_xing: sampleType,
  887. liu_yang_shu_lian: liuYangNum == null ? '' : liuYangNum
  888. }
  889. }
  890. const result = {
  891. name: 'emptyLocation',
  892. value: obj
  893. }
  894. return result
  895. } else { // 新增一条位置信息(修改它的样品编号,样品名称,入库时间,标识UUID)
  896. const sampleInfo = {
  897. yang_pin_bian_hao: item.yang_pin_bian_hao,
  898. yang_pin_ming_che: item.yang_pin_ming_che,
  899. ru_ku_shi_jian_: currentTime,
  900. biao_zhi_uuid_: UUID,
  901. shi_fou_liu_yang_: isLiuYang,
  902. type: sampleType,
  903. num: liuYangNum == null ? '' : liuYangNum
  904. }
  905. const newLocation = this.generateNewLocation(localInfo.find(i => i.id_ === currentLocation), sampleInfo)
  906. const result = {
  907. name: 'fullLocation',
  908. value: newLocation
  909. }
  910. return result
  911. }
  912. },
  913. /* 关闭*/
  914. remRedar () {
  915. this.visible = false // 列表隐藏
  916. this.listData = [] // 清空列表数据
  917. this.redar = false // 扫码图标隐藏
  918. this.$emit('scanOff', false)
  919. },
  920. // 新加有效期至字段
  921. async ypdjbData (arr) {
  922. for (const item of arr) {
  923. const sql = `select bao_gao_zhou_qi_g from t_mjjcnlfw where FIND_IN_SET(id_, '${item.jian_ce_xiang_mu_id}')`
  924. const res = await repostCurd('sql', sql)
  925. const { data = [] } = res.variables || {}
  926. let maxAge = 0
  927. for (const person of data) {
  928. const age = parseInt(person.bao_gao_zhou_qi_g, 10)
  929. if (age > maxAge) {
  930. maxAge = age
  931. }
  932. }
  933. const currentDate = new Date()
  934. const futureDate = new Date(currentDate)
  935. futureDate.setDate(currentDate.getDate() + Number(maxAge))
  936. const year = futureDate.getFullYear()
  937. const month = String(futureDate.getMonth() + 1).padStart(2, '0')
  938. const day = String(futureDate.getDate()).padStart(2, '0')
  939. const formattedDate = `${year}-${month}-${day}`
  940. item.bao_gao_zhou_qi_g = formattedDate
  941. console.log(formattedDate)
  942. delete item.jian_ce_xiang_mu_id
  943. }
  944. repostCurd('add', '{"tableName":"t_lhypdjb","paramWhere":' + JSON.stringify(arr) + '}').then(() => {
  945. console.log('样品登记表数据添加成功!')
  946. this.$emit('callback', true)
  947. }).catch(error => {
  948. console.log(error)
  949. this.handleAnySituation(true, '样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决', 'error')
  950. })
  951. }
  952. }
  953. }