sampleConfirmationJS.js 66 KB

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