sampleConfirmationJS.js 76 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089
  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 that = this
  30. let flag = true // 重复扫码标志位
  31. for (let 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. let sql = `select lei_xing_ from t_yplxb`
  38. let sql2 = `select yang_pin_gui_ge_ from t_ypbzggb`
  39. Promise.all([repostCurd('sql', sql), repostCurd('sql', sql2)]).then(([res1, res2]) => {
  40. let data = res1.variables.data
  41. let data2 = res2.variables.data
  42. let types = []
  43. let guiGes = []
  44. data.forEach(item => {
  45. let obj = {
  46. value: item.lei_xing_,
  47. label: item.lei_xing_
  48. }
  49. types.push(obj)
  50. })
  51. data2.forEach(item => {
  52. let 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. 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'`
  64. let liuYangSQL = `select liu_yang_qi_xian_ from t_lyqxpzb limit 1`
  65. let 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. let temp = res[0].variables.data
  68. let option = res[1].variables.data[0].liu_yang_qi_xian_
  69. let cfID = res[2].variables.data[0].cun_fang_id_
  70. let lyID = res[2].variables.data[0].liu_yang_id_
  71. that.lylocation = lyID
  72. let 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. let this_ = this;
  142. // 回传关闭事件。隐藏当前组件。
  143. let 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. let ypInfoList = this_.listData
  156. // console.log(ypInfoList, "样品信息")
  157. let dWhere = []
  158. let ypbh = []
  159. let ypbhList = [] // 样品编号列表
  160. // 罗湖样品编号列表
  161. let lhypbhList = []
  162. let lhypmcList = []
  163. // 罗湖样品表外键
  164. let lhypbWJ = []
  165. // 罗湖委托表主键
  166. let lhwtbID = []
  167. // 罗湖委托表展示表ID
  168. let lhwtzsbID = []
  169. // 罗湖样品id列表
  170. let lhypIdList = []
  171. // 罗湖样品id格式列表
  172. let lhypIdNewList = []
  173. // 样品所选择的位置ID字符串
  174. let localStr = ''
  175. let locationIds = new Set()
  176. let localArr = []
  177. let 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 (let yp in ypInfoList) { //样品数据
  181. let 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. let 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. 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}')`
  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. let initResult = res[0].variables.data
  383. let result = []
  384. let 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. let 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. let 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. let allUUIDStr = allUUID.filter(i => i).join(',')
  426. // 更新样品位置list
  427. // console.log('emptyLocal:',this.emptyLocal)
  428. if(this.emptyLocal.length > 0){
  429. let 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. let ypdjb = []
  440. let rws = []
  441. console.log(result)
  442. console.log(ypInfoList)
  443. result.forEach((item, index) => {
  444. // 2-1:统计每个样品有多少类型[数量]
  445. let lxList = []
  446. let ypggList = []
  447. let 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. let yplxz = lxList.filter(i => i).join(';')
  456. let ypggStr = ypggList.filter(i => i).join(';')
  457. let 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. let xmmc = []
  463. xmmc.push(item.chang_gui_xiang_m, item.tao_can_ming_chen)
  464. let xiangMuZh = xiangMuZh = xmmc.filter(i => i).join(',')
  465. for (let c = 0; c < 4; c++) {
  466. let yblx = c == 0 ? ypInfoList[index].yang_pin_lei_xing :
  467. c == 1 ? ypInfoList[index].yang_pin_lei_er_ :
  468. c == 2 ? ypInfoList[index].yang_pin_lei_san_ :
  469. c == 3 ? ypInfoList[index].yang_pin_lei_si_ : ''
  470. // fix样品类型不按顺序进行填写
  471. if(!yblx){
  472. console.log('current',c)
  473. continue
  474. }
  475. let ystj = c == 0 ? ypInfoList[index].yang_ben_yun_shu_ :
  476. c == 1 ? ypInfoList[index].yang_pin_yun_shu_ :
  477. c == 2 ? ypInfoList[index].yang_pin_yun_san :
  478. c == 3 ? ypInfoList[index].yang_pin_yun_si_ : ''
  479. let ypsl = c == 0 ? ypInfoList[index].shu_liang_ :
  480. c == 1 ? ypInfoList[index].shu_liang_er_ :
  481. c == 2 ? ypInfoList[index].shu_liang_san_ :
  482. c == 3 ? ypInfoList[index].shu_liang_si_ : ''
  483. let ybgg = c == 0 ? ypInfoList[index].yang_pin_gui_ge_ :
  484. c == 1 ? ypInfoList[index].yang_pin_gui_ge_e :
  485. c == 2 ? ypInfoList[index].yang_pin_gui_ge_s :
  486. c == 3 ? ypInfoList[index].yang_pin_gui_si_ : ''
  487. let sywz = c == 0 ? ypInfoList[index].shou_yang_wei_zhi_yi :
  488. c == 1 ? ypInfoList[index].shou_yang_wei_zhi_er :
  489. c == 2 ? ypInfoList[index].shou_yang_wei_zhi_san :
  490. c == 3 ? ypInfoList[index].shou_yang_wei_zhi_si : ''
  491. let lycf = c == 0 ? ypInfoList[index].liu_yang_wei_zhi_yi :
  492. c == 1 ? ypInfoList[index].liu_yang_wei_zhi_er :
  493. c == 2 ? ypInfoList[index].liu_yang_wei_zhi_san :
  494. c == 3 ? ypInfoList[index].liu_yang_wei_zhi_si : ''
  495. let lysl = c == 0 ? ypInfoList[index].liu_yang_shu_lian_yi :
  496. c == 1 ? ypInfoList[index].liu_yang_shu_lian_er :
  497. c == 2 ? ypInfoList[index].liu_yang_shu_lian_san :
  498. c == 3 ? ypInfoList[index].liu_yang_shu_lian_si : ''
  499. let currentUUID = c == 0 ? ypInfoList[index].biao_zhi_uuid_1 :
  500. c == 1 ? ypInfoList[index].biao_zhi_uuid_2 :
  501. c == 2 ? ypInfoList[index].biao_zhi_uuid_3 :
  502. c == 3 ? ypInfoList[index].biao_zhi_uuid_4 : ''
  503. let ifLy = c == 0 ? ypInfoList[index].shi_fou_liu_yang_yi :
  504. c == 1 ? ypInfoList[index].shi_fou_liu_yang_er :
  505. c == 2 ? ypInfoList[index].shi_fou_liu_yang_san:
  506. c == 3 ? ypInfoList[index].shi_fou_liu_yang_si : ''
  507. // let obj = {
  508. // wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
  509. // wei_tuo_dan_wei_: item.wtdh,
  510. // lian_xi_ren_: item.wei_tuo_fang_lian,
  511. // lian_xi_dian_hua_: item.wei_tuo_lian,
  512. // yang_ben_ming_che: item.yang_pin_ming_che,
  513. // yang_ben_bian_hao: item.yang_pin_bian_hao,
  514. // pi_hao_bian_hao_: item.song_jian_pi_hao_,
  515. // song_jian_dan_wei: item.song_jian_dan_wei,
  516. // xing_ming_: ypInfoList[index].xing_ming_ || '',
  517. // xing_bie_: ypInfoList[index].xing_bie_ || '',
  518. // nian_ling_: ypInfoList[index].nian_ling_ || '',
  519. // yang_ben_zhuang_t: item.yang_pin_zhuang_t,
  520. // shou_yang_ri_qi_: currentTime,
  521. // bei_zhu_: ypInfoList[index].bei_zhu_1_ || '',
  522. // yang_ben_lei_xing: yblx,
  523. // yun_shu_tiao_jian: ystj,
  524. // yang_pin_shu_lian: ypsl,
  525. // yang_ben_gui_ge_s: ybgg,
  526. // yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
  527. // cun_fang_wei_zhi_: sywz || '',
  528. // liu_zhuan_zhuang_: '待任务分配',
  529. // shi_fou_liu_yang_: ifLy,
  530. // liu_yang_ri_qi_: ifLy == '是'? ypInfoList[index].liu_yang_ri_qi_:'',
  531. // liu_yang_cun_fang: ifLy == '是'?(lycf ? lycf : ''):'',
  532. // liu_yang_shu_lian: ifLy == '是'? (lysl == null ?'':lysl) : '',
  533. // liu_yang_qi_xian: ifLy == '是'? ypInfoList[index].liu_yang_qi_xian:'',
  534. // xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_ || '',
  535. // fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_ || '',
  536. // fan_yang_jyr: ypInfoList[index].fan_yang_jyr || '',
  537. // biao_zhi_uuid_: currentUUID,
  538. // song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu || '',
  539. // jian_ce_xiang_mu_: xiangMuZh,
  540. // shou_yang_ren_:this.$store.getters.userInfo.user.name,
  541. // wei_tuo_lei_xing_:item.wei_tuo_lei_xing_
  542. // }
  543. // // console.log(obj)
  544. // ypdjb.push(obj)
  545. const sql = `select bao_gao_zhou_qi_g from t_mjjcnlfw where FIND_IN_SET(id_,'${item.jian_ce_xiang_mu_}')`
  546. var maxAge
  547. repostCurd('sql', sql).then((res) => {
  548. const { data = [] } = res.variables || {}
  549. maxAge = data.reduce((max, person) => {
  550. // 将age从字符串转换为数字
  551. const  maxNum = parseInt(person.bao_gao_zhou_qi_g)
  552. // 使用三元表达式比较并更新最大值
  553. return maxNum > max ? maxNum : max
  554. }, 0)
  555. const currentDate = new Date()
  556. // 创建一个新的日期对象,表示当前日期加上3天
  557. const futureDate = new Date(currentDate)
  558. futureDate.setDate(currentDate.getDate() + Number(maxAge))
  559. // 获取年、月、日
  560. const year = futureDate.getFullYear()
  561. const month = String(futureDate.getMonth() + 1).padStart(2, '0')
  562. // 月份从0开始,所以需要加1
  563. const day = String(futureDate.getDate()).padStart(2, '0')
  564. // 格式化为YYYY-MM-DD
  565. const formattedDate = `${year}-${month}-${day}`
  566. // console.log('maxAge', formattedDate)
  567. const obj = {
  568. wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
  569. wei_tuo_dan_wei_: item.wtdh,
  570. lian_xi_ren_: item.wei_tuo_fang_lian,
  571. lian_xi_dian_hua_: item.wei_tuo_lian,
  572. yang_ben_ming_che: item.yang_pin_ming_che,
  573. yang_ben_bian_hao: item.yang_pin_bian_hao,
  574. pi_hao_bian_hao_: item.song_jian_pi_hao_,
  575. song_jian_dan_wei: item.song_jian_dan_wei,
  576. xing_ming_: ypInfoList[index].xing_ming_ || '',
  577. xing_bie_: ypInfoList[index].xing_bie_ || '',
  578. nian_ling_: ypInfoList[index].nian_ling_ || '',
  579. yang_ben_zhuang_t: item.yang_pin_zhuang_t,
  580. shou_yang_ri_qi_: currentTime,
  581. bei_zhu_: ypInfoList[index].bei_zhu_1_ || '',
  582. yang_ben_lei_xing: yblx,
  583. yun_shu_tiao_jian: ystj,
  584. yang_pin_shu_lian: ypsl,
  585. yang_ben_gui_ge_s: ybgg,
  586. yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
  587. cun_fang_wei_zhi_: sywz || '',
  588. liu_zhuan_zhuang_: '待任务分配',
  589. shi_fou_liu_yang_: ifLy,
  590. liu_yang_ri_qi_: ifLy == '是' ? ypInfoList[index].liu_yang_ri_qi_ : '',
  591. liu_yang_cun_fang: ifLy == '是' ? (lycf || '') : '',
  592. liu_yang_shu_lian: ifLy == '是' ? (lysl == null ? '' : lysl) : '',
  593. liu_yang_qi_xian: ifLy == '是' ? ypInfoList[index].liu_yang_qi_xian : '',
  594. xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_ || '',
  595. fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_ || '',
  596. fan_yang_jyr: ypInfoList[index].fan_yang_jyr || '',
  597. biao_zhi_uuid_: currentUUID,
  598. song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu || '',
  599. jian_ce_xiang_mu_: xiangMuZh,
  600. shou_yang_ren_: this.$store.getters.userInfo.user.name,
  601. wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
  602. bao_gao_zhou_qi_g: formattedDate
  603. }
  604. // console.log(obj)
  605. ypdjb.push(obj)
  606. })
  607. }
  608. // 2-2:封装任务分配表
  609. let rw = {
  610. yang_pin_ming_che: item.yang_pin_ming_che,
  611. yang_pin_bian_hao: item.yang_pin_bian_hao,
  612. wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
  613. yang_pin_lei_xing: yplxz,
  614. yang_pin_gui_ge_: ypggStr,
  615. wei_tuo_id_: item.wtID,
  616. he_tong_id_: item.he_tong_id_,
  617. zhuang_tai_: '待任务分配',
  618. wan_cheng_shi_jia: item.song_jian_shi_jia,
  619. shou_yang_ri_qi_: currentTime,
  620. bao_gao_lei_xing_: item.bao_gao_lei_xing_,
  621. xin_xiang_mu_ming: item.xiang_mu_ming_che,
  622. zhan_shi_biao_id_: item.zhan_shi_biao_id_,
  623. fen_zhuang_liu_ya: liuyangStr,
  624. shi_fou_jia_ji_: item.chu_ju_bao_gao_ya, // 是否加急【2023/2/23王提出】
  625. yang_pin_shu_lian: ypInfoList[index].jie_yang_shu_lian, // 样品确认总数【2023/3/7王提出】
  626. suo_you_xiang_mu_: xiangMuZh, // 所有项目的中文名称 【2023/12/11 Mr王】
  627. song_jian_pi_hao_: item.song_jian_pi_hao_// 送检批号 【2023/12/11 Mr王】
  628. }
  629. rws.push(rw)
  630. lhwtzsbID.push('{"shen_qing_id_":"' + item.zhan_shi_biao_id_ + '"}')
  631. lhwtbID.push('{"id_":"' + item.wtID + '"}')
  632. })
  633. /* 4、任务分配
  634. 4-1、根据 wtdAndYpb 的 wtID 更改委托表的 委托状态 wei_tuo_zhuang_ta 变成 已完成
  635. 4-2、根据每个样品一个任务分配流程 遍历样品表开任务分配流程
  636. 4-3、委托表找zhan_shi_biao_id_ 修改 t_lhwtzsb "zhuang_tai_"为"任务分配进行中"
  637. 优化:将其他不冲突的更改状态脚本放在任务分配后并行处理
  638. */
  639. // console.log("4、任务分配",rws) 2023/12/11 Mr王 去掉 ,"defKey":"Process_04o0csc","formKey":"lhrwfp"
  640. repostCurd('add', '{"tableName":"t_lhrwfpb","paramWhere":' + JSON.stringify(rws) + '}').then(res=>{
  641. // console.log('4、更改委托表的 委托状态',lhwtbID)
  642. repostCurd('updates', '{"tableName":"t_lhwtsqb","paramWhere":[' + lhwtbID + '],"paramCond":{"wei_tuo_zhuang_ta":"已完成"}}')
  643. /* 5、更新展示表 */
  644. if (lhwtzsbID.length > 0) {
  645. // console.log('5、更新展示表',lhwtzsbID)
  646. repostCurd('updates', '{"tableName":"t_lhwtzsb","paramWhere":[' + lhwtzsbID + '],"paramCond":{"zhuang_tai_":"任务分配进行中"}}')
  647. }
  648. console.log('样品登记表:',ypdjb)
  649. if(ypdjb.length > 0){
  650. repostCurd('add', '{"tableName":"t_lhypdjb","paramWhere":' + JSON.stringify(ypdjb) + '}').then(()=>{
  651. console.log("样品登记表数据添加成功!")
  652. this.$emit('callback', true)
  653. }).catch(error =>{
  654. console.log(error)
  655. this.handleAnySituation(true,"样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决",'error')
  656. })
  657. }else{
  658. this.handleAnySituation(true,"样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决",'error')
  659. }
  660. /* 3、更新样品表
  661. // console.log('3、更新样品表',lhypIdNewList)
  662. repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}').then(res=>{
  663. this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
  664. })
  665. */
  666. console.log('更新样品表',sampleList)
  667. let allSampleParams ={
  668. tableName:'t_lhypb',
  669. updList:sampleList
  670. }
  671. repostCurd('updatesByWhere', JSON.stringify(allSampleParams)).then(res=>{
  672. this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
  673. })
  674. })
  675. }else{
  676. repostCurd('add', '{"tableName":"t_ypcfwz","paramWhere":' + JSON.stringify(this.fullLocal) + '}').then(res => {
  677. // 再次查询位置表,对比当前样品列表 替换初始值为占用的样品位置id
  678. let findLocationAgain = `select id_,shi_fou_liu_yang_,biao_zhi_uuid_ from t_ypcfwz where find_in_set(biao_zhi_uuid_,'${allUUIDStr}')`
  679. // console.log(findLocationAgain)
  680. repostCurd('sql', findLocationAgain).then(res => {
  681. let data = res.variables.data
  682. let uuidArgs = ['biao_zhi_uuid_1', 'biao_zhi_uuid_2', 'biao_zhi_uuid_3', 'biao_zhi_uuid_4']
  683. let shouYangArgs = ['shou_yang_wei_zhi_yi', 'shou_yang_wei_zhi_er', 'shou_yang_wei_zhi_san', 'shou_yang_wei_zhi_si']
  684. let liuYangArgs = ['liu_yang_wei_zhi_yi', 'liu_yang_wei_zhi_er', 'liu_yang_wei_zhi_san', 'liu_yang_wei_zhi_si']
  685. data.forEach(item => {
  686. uuidArgs.forEach((uuid, index) => {
  687. let ypIndex = ypInfoList.findIndex(i => i[uuid] === item.biao_zhi_uuid_)
  688. if (ypIndex != -1) {
  689. item.shi_fou_liu_yang_ === '否' ?
  690. ypInfoList[ypIndex][shouYangArgs[index]] = item.id_ :
  691. ypInfoList[ypIndex][liuYangArgs[index]] = item.id_
  692. }
  693. })
  694. })
  695. // repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}')
  696. /* 2、封装样品登记表对象,插入样品登记表 顺便封装任务分配表 */
  697. let ypdjb = []
  698. let rws = []
  699. console.log(result)
  700. console.log(ypInfoList)
  701. result.forEach((item, index) => {
  702. // 2-1:统计每个样品有多少类型[数量]
  703. let lxList = []
  704. let ypggList = []
  705. let liuYangList = []
  706. 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_)
  707. ypggList.push(
  708. ypInfoList[index].yang_pin_gui_ge_? ypInfoList[index].yang_pin_gui_ge_ +'*'+ ypInfoList[index].shu_liang_+ ypInfoList[index].dan_wei_yi:'',
  709. ypInfoList[index].yang_pin_gui_ge_e? ypInfoList[index].yang_pin_gui_ge_e+'*'+ ypInfoList[index].shu_liang_er_+ ypInfoList[index].dan_wei_er:'',
  710. ypInfoList[index].yang_pin_gui_ge_s?ypInfoList[index].yang_pin_gui_ge_s +'*'+ ypInfoList[index].shu_liang_san_+ ypInfoList[index].dan_wei_san:'',
  711. ypInfoList[index].yang_pin_gui_si_?ypInfoList[index].yang_pin_gui_si_ +'*'+ ypInfoList[index].shu_liang_si_+ ypInfoList[index].dan_wei_si:'')
  712. 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)
  713. let yplxz = lxList.filter(i => i).join(';')
  714. let ypggStr = ypggList.filter(i => i).join(';')
  715. let liuyangStr = liuYangList.filter(i => i).join(';')
  716. // let count = lxList.filter(i => i).join(',').match(/,/g).length + 1
  717. // let size = lxList.filter(i => i).join(',').match(/,/g)
  718. // let count = 1
  719. // size == null ? count = 1 : count = size.length + 1
  720. let xmmc = []
  721. xmmc.push(item.chang_gui_xiang_m, item.tao_can_ming_chen)
  722. let xiangMuZh = xiangMuZh = xmmc.filter(i => i).join(',')
  723. for (let c = 0; c < 4; c++) {
  724. let yblx = c == 0 ? ypInfoList[index].yang_pin_lei_xing :
  725. c == 1 ? ypInfoList[index].yang_pin_lei_er_ :
  726. c == 2 ? ypInfoList[index].yang_pin_lei_san_ :
  727. c == 3 ? ypInfoList[index].yang_pin_lei_si_ : ''
  728. // fix样品类型不按顺序进行填写
  729. if(!yblx){
  730. console.log('current',c)
  731. continue
  732. }
  733. let ystj = c == 0 ? ypInfoList[index].yang_ben_yun_shu_ :
  734. c == 1 ? ypInfoList[index].yang_pin_yun_shu_ :
  735. c == 2 ? ypInfoList[index].yang_pin_yun_san :
  736. c == 3 ? ypInfoList[index].yang_pin_yun_si_ : ''
  737. let ypsl = c == 0 ? ypInfoList[index].shu_liang_ :
  738. c == 1 ? ypInfoList[index].shu_liang_er_ :
  739. c == 2 ? ypInfoList[index].shu_liang_san_ :
  740. c == 3 ? ypInfoList[index].shu_liang_si_ : ''
  741. let ybgg = c == 0 ? ypInfoList[index].yang_pin_gui_ge_ :
  742. c == 1 ? ypInfoList[index].yang_pin_gui_ge_e :
  743. c == 2 ? ypInfoList[index].yang_pin_gui_ge_s :
  744. c == 3 ? ypInfoList[index].yang_pin_gui_si_ : ''
  745. let sywz = c == 0 ? ypInfoList[index].shou_yang_wei_zhi_yi :
  746. c == 1 ? ypInfoList[index].shou_yang_wei_zhi_er :
  747. c == 2 ? ypInfoList[index].shou_yang_wei_zhi_san :
  748. c == 3 ? ypInfoList[index].shou_yang_wei_zhi_si : ''
  749. let lycf = c == 0 ? ypInfoList[index].liu_yang_wei_zhi_yi :
  750. c == 1 ? ypInfoList[index].liu_yang_wei_zhi_er :
  751. c == 2 ? ypInfoList[index].liu_yang_wei_zhi_san :
  752. c == 3 ? ypInfoList[index].liu_yang_wei_zhi_si : ''
  753. let lysl = c == 0 ? ypInfoList[index].liu_yang_shu_lian_yi :
  754. c == 1 ? ypInfoList[index].liu_yang_shu_lian_er :
  755. c == 2 ? ypInfoList[index].liu_yang_shu_lian_san :
  756. c == 3 ? ypInfoList[index].liu_yang_shu_lian_si : ''
  757. let currentUUID = c == 0 ? ypInfoList[index].biao_zhi_uuid_1 :
  758. c == 1 ? ypInfoList[index].biao_zhi_uuid_2 :
  759. c == 2 ? ypInfoList[index].biao_zhi_uuid_3 :
  760. c == 3 ? ypInfoList[index].biao_zhi_uuid_4 : ''
  761. let ifLy = c == 0 ? ypInfoList[index].shi_fou_liu_yang_yi :
  762. c == 1 ? ypInfoList[index].shi_fou_liu_yang_er :
  763. c == 2 ? ypInfoList[index].shi_fou_liu_yang_san:
  764. c == 3 ? ypInfoList[index].shi_fou_liu_yang_si : ''
  765. // let obj = {
  766. // wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
  767. // wei_tuo_dan_wei_: item.wtdh,
  768. // lian_xi_ren_: item.wei_tuo_fang_lian,
  769. // lian_xi_dian_hua_: item.wei_tuo_lian,
  770. // yang_ben_ming_che: item.yang_pin_ming_che,
  771. // yang_ben_bian_hao: item.yang_pin_bian_hao,
  772. // pi_hao_bian_hao_: item.song_jian_pi_hao_,
  773. // song_jian_dan_wei: item.song_jian_dan_wei,
  774. // xing_ming_: ypInfoList[index].xing_ming_ || '',
  775. // xing_bie_: ypInfoList[index].xing_bie_ || '',
  776. // nian_ling_: ypInfoList[index].nian_ling_ || '',
  777. // yang_ben_zhuang_t: item.yang_pin_zhuang_t,
  778. // shou_yang_ri_qi_: currentTime,
  779. // bei_zhu_: ypInfoList[index].bei_zhu_1_ || '',
  780. // yang_ben_lei_xing: yblx,
  781. // yun_shu_tiao_jian: ystj,
  782. // yang_pin_shu_lian: ypsl,
  783. // yang_ben_gui_ge_s: ybgg,
  784. // yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
  785. // cun_fang_wei_zhi_: sywz || '',
  786. // liu_zhuan_zhuang_: '待任务分配',
  787. // shi_fou_liu_yang_: ifLy,
  788. // liu_yang_ri_qi_: ifLy == '是'? ypInfoList[index].liu_yang_ri_qi_:'',
  789. // liu_yang_cun_fang: ifLy == '是'?(lycf ? lycf : ''):'',
  790. // liu_yang_shu_lian: ifLy == '是'? (lysl == null ?'':lysl) : '',
  791. // liu_yang_qi_xian: ifLy == '是'? ypInfoList[index].liu_yang_qi_xian:'',
  792. // xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_ || '',
  793. // fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_ || '',
  794. // fan_yang_jyr: ypInfoList[index].fan_yang_jyr || '',
  795. // biao_zhi_uuid_: currentUUID,
  796. // song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu || '',
  797. // jian_ce_xiang_mu_: xiangMuZh,
  798. // shou_yang_ren_:this.$store.getters.userInfo.user.name,
  799. // wei_tuo_lei_xing_:item.wei_tuo_lei_xing_
  800. // }
  801. // // console.log(obj)
  802. // ypdjb.push(obj)
  803. const sql = `select bao_gao_zhou_qi_g from t_mjjcnlfw where FIND_IN_SET(id_,'${item.jian_ce_xiang_mu_}')`
  804. var maxAge
  805. repostCurd('sql', sql).then((res) => {
  806. const { data = [] } = res.variables || {}
  807. maxAge = data.reduce((max, person) => {
  808. // 将age从字符串转换为数字
  809. const  maxNum = parseInt(person.bao_gao_zhou_qi_g)
  810. // 使用三元表达式比较并更新最大值
  811. return maxNum > max ? maxNum : max
  812. }, 0)
  813. const currentDate = new Date()
  814. // 创建一个新的日期对象,表示当前日期加上3天
  815. const futureDate = new Date(currentDate)
  816. futureDate.setDate(currentDate.getDate() + Number(maxAge))
  817. // 获取年、月、日
  818. const year = futureDate.getFullYear()
  819. const month = String(futureDate.getMonth() + 1).padStart(2, '0')
  820. // 月份从0开始,所以需要加1
  821. const day = String(futureDate.getDate()).padStart(2, '0')
  822. // 格式化为YYYY-MM-DD
  823. const formattedDate = `${year}-${month}-${day}`
  824. // console.log('maxAge', formattedDate)
  825. const obj = {
  826. wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
  827. wei_tuo_dan_wei_: item.wtdh,
  828. lian_xi_ren_: item.wei_tuo_fang_lian,
  829. lian_xi_dian_hua_: item.wei_tuo_lian,
  830. yang_ben_ming_che: item.yang_pin_ming_che,
  831. yang_ben_bian_hao: item.yang_pin_bian_hao,
  832. pi_hao_bian_hao_: item.song_jian_pi_hao_,
  833. song_jian_dan_wei: item.song_jian_dan_wei,
  834. xing_ming_: ypInfoList[index].xing_ming_ || '',
  835. xing_bie_: ypInfoList[index].xing_bie_ || '',
  836. nian_ling_: ypInfoList[index].nian_ling_ || '',
  837. yang_ben_zhuang_t: item.yang_pin_zhuang_t,
  838. shou_yang_ri_qi_: currentTime,
  839. bei_zhu_: ypInfoList[index].bei_zhu_1_ || '',
  840. yang_ben_lei_xing: yblx,
  841. yun_shu_tiao_jian: ystj,
  842. yang_pin_shu_lian: ypsl,
  843. yang_ben_gui_ge_s: ybgg,
  844. yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
  845. cun_fang_wei_zhi_: sywz || '',
  846. liu_zhuan_zhuang_: '待任务分配',
  847. shi_fou_liu_yang_: ifLy,
  848. liu_yang_ri_qi_: ifLy == '是' ? ypInfoList[index].liu_yang_ri_qi_ : '',
  849. liu_yang_cun_fang: ifLy == '是' ? (lycf || '') : '',
  850. liu_yang_shu_lian: ifLy == '是' ? (lysl == null ? '' : lysl) : '',
  851. liu_yang_qi_xian: ifLy == '是' ? ypInfoList[index].liu_yang_qi_xian : '',
  852. xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_ || '',
  853. fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_ || '',
  854. fan_yang_jyr: ypInfoList[index].fan_yang_jyr || '',
  855. biao_zhi_uuid_: currentUUID,
  856. song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu || '',
  857. jian_ce_xiang_mu_: xiangMuZh,
  858. shou_yang_ren_: this.$store.getters.userInfo.user.name,
  859. wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
  860. bao_gao_zhou_qi_g: formattedDate
  861. }
  862. // console.log(obj)
  863. ypdjb.push(obj)
  864. })
  865. }
  866. // 2-2:封装任务分配表
  867. let rw = {
  868. yang_pin_ming_che: item.yang_pin_ming_che,
  869. yang_pin_bian_hao: item.yang_pin_bian_hao,
  870. wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
  871. yang_pin_lei_xing: yplxz,
  872. yang_pin_gui_ge_: ypggStr,
  873. wei_tuo_id_: item.wtID,
  874. he_tong_id_: item.he_tong_id_,
  875. zhuang_tai_: '待任务分配',
  876. wan_cheng_shi_jia: item.song_jian_shi_jia,
  877. shou_yang_ri_qi_: currentTime,
  878. bao_gao_lei_xing_: item.bao_gao_lei_xing_,
  879. xin_xiang_mu_ming: item.xiang_mu_ming_che,
  880. zhan_shi_biao_id_: item.zhan_shi_biao_id_,
  881. fen_zhuang_liu_ya: liuyangStr,
  882. shi_fou_jia_ji_: item.chu_ju_bao_gao_ya, // 是否加急【2023/2/23王嘎嘎提出】
  883. yang_pin_shu_lian: ypInfoList[index].jie_yang_shu_lian, // 样品确认总数【2023/3/7王嘎嘎提出】
  884. suo_you_xiang_mu_: xiangMuZh, // 所有项目的中文名称 【2023/12/11 Mr王】
  885. song_jian_pi_hao_: item.song_jian_pi_hao_// 送检批号 【2023/12/11 Mr王】
  886. }
  887. rws.push(rw)
  888. lhwtzsbID.push('{"shen_qing_id_":"' + item.zhan_shi_biao_id_ + '"}')
  889. lhwtbID.push('{"id_":"' + item.wtID + '"}')
  890. })
  891. /* 4、任务分配
  892. 4-1、根据 wtdAndYpb 的 wtID 更改委托表的 委托状态 wei_tuo_zhuang_ta 变成 已完成
  893. 4-2、根据每个样品一个任务分配流程 遍历样品表开任务分配流程
  894. 4-3、委托表找zhan_shi_biao_id_ 修改 t_lhwtzsb "zhuang_tai_"为"任务分配进行中"
  895. 优化:将其他不冲突的更改状态脚本放在任务分配后并行处理
  896. */
  897. // console.log("4、任务分配",rws) 2023/12/11 Mr王 去掉 ,"defKey":"Process_04o0csc","formKey":"lhrwfp"
  898. repostCurd('add', '{"tableName":"t_lhrwfpb","paramWhere":' + JSON.stringify(rws) + '}').then(res=>{
  899. // console.log('4、更改委托表的 委托状态',lhwtbID)
  900. repostCurd('updates', '{"tableName":"t_lhwtsqb","paramWhere":[' + lhwtbID + '],"paramCond":{"wei_tuo_zhuang_ta":"已完成"}}')
  901. /* 5、更新展示表 */
  902. if (lhwtzsbID.length > 0) {
  903. // console.log('5、更新展示表',lhwtzsbID)
  904. repostCurd('updates', '{"tableName":"t_lhwtzsb","paramWhere":[' + lhwtzsbID + '],"paramCond":{"zhuang_tai_":"任务分配进行中"}}')
  905. }
  906. console.log('样品登记表:',ypdjb)
  907. if(ypdjb.length > 0){
  908. repostCurd('add', '{"tableName":"t_lhypdjb","paramWhere":' + JSON.stringify(ypdjb) + '}').then(()=>{
  909. console.log("样品登记表数据添加成功!")
  910. this.$emit('callback', true)
  911. }).catch(error =>{
  912. console.log(error)
  913. this.handleAnySituation(true,"样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决",'error')
  914. })
  915. }else{
  916. this.handleAnySituation(true,"样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决",'error')
  917. }
  918. /* 3、更新样品表
  919. // console.log('3、更新样品表',lhypIdNewList)
  920. repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}').then(res=>{
  921. this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
  922. })
  923. */
  924. console.log('更新样品表',sampleList)
  925. let allSampleParams ={
  926. tableName:'t_lhypb',
  927. updList:sampleList
  928. }
  929. repostCurd('updatesByWhere', JSON.stringify(allSampleParams)).then(res=>{
  930. this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
  931. })
  932. })
  933. })
  934. })
  935. }
  936. })
  937. }).catch(_ => { });
  938. }
  939. },
  940. /* 去除指定行数据 使用过滤器filter过滤指定行号数据 */
  941. deleteData(val) {
  942. this.listData = this.listData.filter((data) => {
  943. return data.id_ != val
  944. })
  945. },
  946. uuid() {
  947. var s = [];
  948. var hexDigits = "0123456789abcdef";
  949. for (var i = 0; i < 36; i++) {
  950. s[i] = hexDigits.substr(Math.floor(Math.random() * 0x10), 1);
  951. }
  952. s[14] = "4"; // bits 12-15 of the time_hi_and_version field to 0010
  953. s[19] = hexDigits.substr((s[19] & 0x3) | 0x8, 1); // bits 6-7 of the clock_seq_hi_and_reserved to 01
  954. s[8] = s[13] = s[18] = s[23] = "-";
  955. var uuid = s.join("");
  956. return uuid;
  957. },
  958. unique(arr) {
  959. return arr.filter((item, index) => {
  960. return arr.indexOf(item, 0) === index;
  961. });
  962. },
  963. // 根据旧位置数据生成新位置数据
  964. generateNewLocation(oldLocation, sampleInfo) {
  965. let temp = {
  966. fang_jian_lei_xin: oldLocation.fang_jian_lei_xin,
  967. wei_zhi_: oldLocation.wei_zhi_,
  968. qu_yu_: oldLocation.qu_yu_,
  969. huo_jia_lei_xing_: oldLocation.huo_jia_lei_xing_,
  970. huo_jia_hao_: oldLocation.huo_jia_hao_,
  971. ceng_hao_: oldLocation.ceng_hao_,
  972. shui_ping_fen_qu_: oldLocation.shui_ping_fen_qu_,
  973. wei_zhi_bian_hao_: oldLocation.wei_zhi_bian_hao_,
  974. wei_zhi_zhuang_ta: oldLocation.wei_zhi_zhuang_ta,
  975. cun_chu_tiao_jian: oldLocation.cun_chu_tiao_jian,
  976. shi_fou_guo_shen_: '启用',
  977. yang_pin_bian_hao: sampleInfo.yang_pin_bian_hao,
  978. yang_pin_ming_che: sampleInfo.yang_pin_ming_che,
  979. ru_ku_shi_jian_: sampleInfo.ru_ku_shi_jian_,
  980. shi_fou_liu_yang_: sampleInfo.shi_fou_liu_yang_,
  981. biao_zhi_uuid_: sampleInfo.biao_zhi_uuid_,
  982. yang_pin_lei_xing: sampleInfo.type,
  983. liu_yang_shu_lian: sampleInfo.num
  984. }
  985. return temp
  986. },
  987. handleLocationInfo(currentLocation, isLiuYang, localInfo, locationIds, item, UUID, currentTime, sampleType, liuYangNum) {
  988. !locationIds.has(currentLocation) ? locationIds.add(currentLocation) : localInfo.find(i => i.id_ === currentLocation).wei_zhi_zhuang_ta = '占用'
  989. if (localInfo.find(i => i.id_ === currentLocation) != undefined && localInfo.find(i => i.id_ === currentLocation).wei_zhi_zhuang_ta === '空余') {
  990. let obj = {
  991. where: {
  992. id_: currentLocation
  993. },
  994. param: {
  995. wei_zhi_zhuang_ta: "占用",
  996. ru_ku_shi_jian_: currentTime,
  997. yang_pin_bian_hao: item.yang_pin_bian_hao,
  998. yang_pin_ming_che: item.yang_pin_ming_che,
  999. shi_fou_liu_yang_: isLiuYang,
  1000. yang_pin_lei_xing: sampleType,
  1001. liu_yang_shu_lian: liuYangNum == null ? '' : liuYangNum
  1002. }
  1003. }
  1004. let result = {
  1005. name: 'emptyLocation',
  1006. value: obj
  1007. }
  1008. return result
  1009. } else { // 新增一条位置信息(修改它的样品编号,样品名称,入库时间,标识UUID)
  1010. let sampleInfo = {
  1011. yang_pin_bian_hao: item.yang_pin_bian_hao,
  1012. yang_pin_ming_che: item.yang_pin_ming_che,
  1013. ru_ku_shi_jian_: currentTime,
  1014. biao_zhi_uuid_: UUID,
  1015. shi_fou_liu_yang_: isLiuYang,
  1016. type: sampleType,
  1017. num: liuYangNum == null ? '' : liuYangNum
  1018. }
  1019. let newLocation = this.generateNewLocation(localInfo.find(i => i.id_ === currentLocation), sampleInfo)
  1020. let result = {
  1021. name: 'fullLocation',
  1022. value: newLocation
  1023. }
  1024. return result
  1025. }
  1026. },
  1027. /* 关闭*/
  1028. remRedar() {
  1029. this.visible = false // 列表隐藏
  1030. this.listData = [] // 清空列表数据
  1031. this.redar = false // 扫码图标隐藏
  1032. this.$emit('scanOff', false)
  1033. },
  1034. }
  1035. }