| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089 |
- import repostCurd from '@/business/platform/form/utils/custom/joinCURD.js'
- import * as dayjs from 'dayjs'
- const options = {
- '一个月': 1,
- '两个月': 2,
- '三个月': 3,
- '四个月': 4,
- '半年': 6,
- '九个月': 9,
- '一年': 12
- }
- export default {
- methods: {
- /* 唤醒扫码 前端脚本直接调用*/
- openRedar(type) {
- this.redar = true // 扫码图标显示
- this.visible = false // 结果列表,一开始为false
- this.$refs.redarInput.focus(); // 聚焦input
- this.listData = [] // 清空列表
- },
- facilityData(id) {
- if (!id) return // 无参直接反
- this.loadData(id)
- //开始查询设备
- this.facilityId = ''
- },
- /* 获取数据 ,开始查阅记录 */
- loadData(id) {
- let that = this
- let flag = true // 重复扫码标志位
- for (let index in this.listData) { // 判断是否重复,重复扫码 数量自增
- if (this.listData[index].yang_pin_bian_hao == id) {
- this.listData[index].jie_yang_shu_lian = parseInt(this.listData[index].jie_yang_shu_lian) + 1
- flag = false
- }
- }
- let sql = `select lei_xing_ from t_yplxb`
- let sql2 = `select yang_pin_gui_ge_ from t_ypbzggb`
- Promise.all([repostCurd('sql', sql), repostCurd('sql', sql2)]).then(([res1, res2]) => {
- let data = res1.variables.data
- let data2 = res2.variables.data
- let types = []
- let guiGes = []
- data.forEach(item => {
- let obj = {
- value: item.lei_xing_,
- label: item.lei_xing_
- }
- types.push(obj)
- })
- data2.forEach(item => {
- let o = {
- value: item.yang_pin_gui_ge_,
- label: item.yang_pin_gui_ge_
- }
- guiGes.push(o)
- })
- this.sampleTypes = types
- this.sampleSpecifications = guiGes
- })
- // 扫码扫到新数据,查询 回填展示
- if (flag) {
- 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'`
- let liuYangSQL = `select liu_yang_qi_xian_ from t_lyqxpzb limit 1`
- let cfIDSQL = `select cun_fang_id_,liu_yang_id_ FROM t_ypwzmrxzb`
- Promise.all([repostCurd('sql', sql), repostCurd('sql', liuYangSQL), repostCurd('sql', cfIDSQL)]).then((res) => {
- let temp = res[0].variables.data
- let option = res[1].variables.data[0].liu_yang_qi_xian_
- let cfID = res[2].variables.data[0].cun_fang_id_
- let lyID = res[2].variables.data[0].liu_yang_id_
- that.lylocation = lyID
- let rq = options[option]
- if (temp) {
- temp.forEach(item => {
- item.jie_yang_shu_lian = item.yang_pin_zong_shu
- item.jie_yang_zhuang_t = '已确认'
- item.biao_zhi_uuid_1 = this.uuid()
- item.biao_zhi_uuid_2 = this.uuid()
- item.biao_zhi_uuid_3 = this.uuid()
- item.biao_zhi_uuid_4 = this.uuid()
- // item.shi_fou_liu_yang_ = '是'
- item.shi_fou_liu_yang_yi = '是'
- item.shi_fou_liu_yang_er = '是'
- item.shi_fou_liu_yang_san = '是'
- item.shi_fou_liu_yang_si = '是'
- item.yan_shou_jie_guo_ = '完好'
- item.liu_yang_shu_lian_yi = ' ml/支×1支'
- item.shou_yang_wei_zhi_yi = cfID
- item.liu_yang_wei_zhi_yi = lyID
- item.yang_pin_lei_er_ ?
- (item.liu_yang_shu_lian_er = ' ml/支×1支', item.shou_yang_wei_zhi_er = cfID, item.liu_yang_wei_zhi_er = lyID) : null
- item.yang_pin_lei_san_ ?
- (item.liu_yang_shu_lian_san = ' ml/支×1支', item.shou_yang_wei_zhi_san = cfID, item.liu_yang_wei_zhi_san = lyID) : null
- item.yang_pin_lei_si_ ?
- (item.liu_yang_shu_lian_si = ' ml/支×1支', item.shou_yang_wei_zhi_si = cfID, item.liu_yang_wei_zhi_si = lyID) : null
- // item.yang_pin_lei_er_ ? item.liu_yang_shu_lian_er = ' ml/支×1支' : null
- // item.yang_pin_lei_san_ ? item.liu_yang_shu_lian_san = ' ml/支×1支' : null
- // item.yang_pin_lei_si_ ? item.liu_yang_shu_lian_si = ' ml/支×1支' : null
- item.liu_yang_ri_qi_ = new Date(new Date().getTime() + 28800000).toJSON().slice(0, 10).replace('T', ' ')
- item.yang_pin_lei_er_ ? this.$set(item, 'flag2', true) : this.$set(item, 'flag2', false)
- item.yang_pin_lei_san_ ? this.$set(item, 'flag3', true) : this.$set(item, 'flag3', false)
- item.yang_pin_lei_si_ ? this.$set(item, 'flag4', true) : this.$set(item, 'flag4', false)
- item.liu_yang_qi_xian = dayjs(item.song_jian_shi_jia).add(rq, 'month').format("YYYY-MM-DD")
- item.dan_wei_yi = item.yang_pin_gui_ge_ ? this.handleSpecificationsToUnit(item.yang_pin_gui_ge_) : ''
- item.dan_wei_er = item.yang_pin_gui_ge_e ? this.handleSpecificationsToUnit(item.yang_pin_gui_ge_e) : ''
- item.dan_wei_san = item.yang_pin_gui_ge_s ? this.handleSpecificationsToUnit(item.yang_pin_gui_ge_s) : ''
- item.dan_wei_si = item.yang_pin_gui_si_ ? this.handleSpecificationsToUnit(item.yang_pin_gui_si_) : ''
- })
- this.listData.push(temp[0])
- // console.log(this.listData)
- }
- })
- }
- },
- /* 列表失去焦点*/
- handleChange() {
- this.$refs.redarInput.focus(); //聚焦input
- },
- /* 关闭弹出列表框*/
- closeDialog() {
- this.remRedar()
- //回传关闭事件。隐藏当前组件。
- },
- handleClose() {
- this.handleChange()
- this.$confirm('确认关闭扫码列表页面?').then(_ => {
- this.closeDialog();
- }).catch(_ => {});
- },
- handleAnySituation(callBackBool, msg, type) {
- this.$emit('callback', callBackBool)
- this.visable = false
- this.$message({
- message: msg,
- type: type
- })
- this.closeDialog();
- },
- submitData(type) {
- // this指针
- let this_ = this;
- // 回传关闭事件。隐藏当前组件。
- let judge = true;
- if (this_.listData.length == 0) {
- this.$emit('callback', true)
- this.visable = false
- this.$message({
- message: '暂无样品待接收确认!',
- type: 'error'
- })
- this.closeDialog();
- } else {
- this.$confirm('请再次确认 [样品接收信息]').then(_ => {
- // 获取样品列表
- let ypInfoList = this_.listData
- // console.log(ypInfoList, "样品信息")
- let dWhere = []
- let ypbh = []
- let ypbhList = [] // 样品编号列表
- // 罗湖样品编号列表
- let lhypbhList = []
- let lhypmcList = []
- // 罗湖样品表外键
- let lhypbWJ = []
- // 罗湖委托表主键
- let lhwtbID = []
- // 罗湖委托表展示表ID
- let lhwtzsbID = []
- // 罗湖样品id列表
- let lhypIdList = []
- // 罗湖样品id格式列表
- let lhypIdNewList = []
- // 样品所选择的位置ID字符串
- let localStr = ''
- let locationIds = new Set()
- let localArr = []
- let sampleList = []
- const currentTime = new Date(new Date().getTime() + 28800000).toJSON().slice(0, 16).replace('T', ' ')
- const curTime = new Date(new Date().getTime() + 28800000).toJSON().slice(0, 10).replace('T', ' ')
- for (let yp in ypInfoList) { //样品数据
- let cfwz = ''
- /*
- 校验:
- 1、样品数量 <= 确认数量
- 2、是否留样 => 填收样位置|留样位置
- 3、验收结果必填
- 4、如果留样 => 必填项:留样日期、留样数量、留样期限至、销毁日期
- */
- if (ypInfoList[yp].jie_yang_shu_lian > ypInfoList[yp].yang_pin_zong_shu) {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 接收确认数量不得大于收样数量。')
- return;
- }
- if (ypInfoList[yp].jie_yang_zhuang_t == '未确认') {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 接收确认状态必须为已确认。')
- return;
- }
- if (ypInfoList[yp].yan_shou_jie_guo_ == null || ypInfoList[yp].yan_shou_jie_guo_ == '') {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 验收结果不能为空!')
- return;
- }
- /** 如果四个是否留样中有一个为‘是’ 则 留样日期 和对应的留样位置就不能为空 */
- if (ypInfoList[yp].shi_fou_liu_yang_yi == "是" ||
- (ypInfoList[yp].flag2 == true && ypInfoList[yp].shi_fou_liu_yang_er == "是") ||
- (ypInfoList[yp].flag3 == true && ypInfoList[yp].shi_fou_liu_yang_san == "是") ||
- (ypInfoList[yp].flag4 == true && ypInfoList[yp].shi_fou_liu_yang_si == "是")) {
- if (ypInfoList[yp].liu_yang_ri_qi_ == null || ypInfoList[yp].liu_yang_ri_qi_ == '') {
- this_.$message.error('留样时必须填写留样日期!')
- return;
- // this_.handleErrorData("") todo 失效
- }
- if(ypInfoList[yp].shi_fou_liu_yang_yi == "是"){
- // 判断位置是否为空
- if (ypInfoList[yp].liu_yang_wei_zhi_yi == null || ypInfoList[yp].liu_yang_wei_zhi_yi == '') {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的留样位置选择不能为空!')
- return;
- }
- if(ypInfoList[yp].liu_yang_shu_lian_yi == null || ypInfoList[yp].liu_yang_shu_lian_yi == ''){
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的留样数量不能为空!')
- return;
- }
- }
- if(ypInfoList[yp].shi_fou_liu_yang_er == "是"){
- if(ypInfoList[yp].flag2 == true){
- if (ypInfoList[yp].liu_yang_wei_zhi_er == '' || ypInfoList[yp].liu_yang_wei_zhi_er == null) {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的留样位置选择不能为空!')
- return;
- }
- if(ypInfoList[yp].liu_yang_shu_lian_er == null || ypInfoList[yp].liu_yang_shu_lian_er == ''){
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的留样数量不能为空!')
- return;
- }
- }
- }
- if(ypInfoList[yp].shi_fou_liu_yang_san == "是"){
- if(ypInfoList[yp].flag3 == true ){
- if (ypInfoList[yp].liu_yang_wei_zhi_san == '' || ypInfoList[yp].liu_yang_wei_zhi_san == null) {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的留样位置选择不能为空!')
- return;
- }
- if(ypInfoList[yp].liu_yang_shu_lian_san == null || ypInfoList[yp].liu_yang_shu_lian_san == ''){
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的留样数量不能为空!')
- return;
- }
- }
- }
- if(ypInfoList[yp].shi_fou_liu_yang_si == "是"){
- if(ypInfoList[yp].flag4 == true ){
- if (ypInfoList[yp].liu_yang_wei_zhi_si == '' || ypInfoList[yp].liu_yang_wei_zhi_si == null) {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的留样位置选择不能为空!')
- return;
- }
- if(ypInfoList[yp].liu_yang_shu_lian_si == null || ypInfoList[yp].liu_yang_shu_lian_si == ''){
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的留样数量不能为空!')
- return;
- }
- }
- }
- }
- // 判断位置是否为空 且判断单位是否为空
- if (ypInfoList[yp].shou_yang_wei_zhi_yi == null || ypInfoList[yp].shou_yang_wei_zhi_yi == '') {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的位置选择不能为空!')
- return;
- }
- if(ypInfoList[yp].dan_wei_yi == null || ypInfoList[yp].dan_wei_yi == ''){
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型1的单位不能为空!')
- return;
- }
- if(ypInfoList[yp].flag2 == true){
- if (ypInfoList[yp].shou_yang_wei_zhi_er == '' || ypInfoList[yp].shou_yang_wei_zhi_er == null) {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的位置选择不能为空!')
- return;
- }
- if(ypInfoList[yp].dan_wei_er == null || ypInfoList[yp].dan_wei_er == ''){
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型2的单位不能为空!')
- return;
- }
- }
- if(ypInfoList[yp].flag3 == true){
- if(ypInfoList[yp].shou_yang_wei_zhi_san == '' || ypInfoList[yp].shou_yang_wei_zhi_san == null) {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的位置选择不能为空!')
- return;
- }
- if(ypInfoList[yp].dan_wei_san == null || ypInfoList[yp].dan_wei_san == ''){
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型3的单位不能为空!')
- return;
- }
- }
- if(ypInfoList[yp].flag4 == true){
- if (ypInfoList[yp].shou_yang_wei_zhi_si == '' || ypInfoList[yp].shou_yang_wei_zhi_si == null) {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的位置选择不能为空!')
- return;
- }
- if(ypInfoList[yp].dan_wei_si == null || ypInfoList[yp].dan_wei_si == ''){
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 类型4的单位不能为空!')
- return;
- }
- }
- // 判断留样日期不得早于当前日期
- if(ypInfoList[yp].liu_yang_ri_qi_ != null && ypInfoList[yp].liu_yang_ri_qi_ != ''){
- if(ypInfoList[yp].liu_yang_ri_qi_ < curTime){
- console.log(ypInfoList[yp].liu_yang_ri_qi_,curTime)
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 的留样日期不得早于收样日期!')
- return;
- }
- }
- // 判断留样期限日期不得早于当前日期
- if(ypInfoList[yp].liu_yang_qi_xian != null && ypInfoList[yp].liu_yang_qi_xian != ''){
- if(ypInfoList[yp].liu_yang_qi_xian < curTime){
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 的留样期限日期不得早于收样日期!')
- return;
- }
- }
- // 判断返样日期不得早于当前日期
- if(ypInfoList[yp].fan_yang_ri_qi_ != null && ypInfoList[yp].fan_yang_ri_qi_ != ''){
- if(ypInfoList[yp].fan_yang_ri_qi_ < curTime){
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 的返样日期不得早于收样日期!')
- return;
- }
- }
- ypbhList.push('{"yang_pin_bian_hao":"' + ypInfoList[yp].yang_pin_bian_hao + '"}') // 样品编号列表
- // 罗湖
- dWhere.push('{"id_":"' + cfwz + '"}')
- lhypbhList.push(ypInfoList[yp].yang_pin_bian_hao)
- lhypbWJ.push(ypInfoList[yp].parent_id_)
- lhypIdList.push(ypInfoList[yp].id_)
- lhypIdNewList.push('{"id_":"' + ypInfoList[yp].id_ + '"}')
- ypbh.push(ypInfoList[yp].yang_pin_bian_hao)
- lhypmcList.push(ypInfoList[yp].yang_pin_ming_che)
- localArr.push(
- ypInfoList[yp].shou_yang_wei_zhi_yi, ypInfoList[yp].liu_yang_wei_zhi_yi,
- ypInfoList[yp].shou_yang_wei_zhi_er, ypInfoList[yp].liu_yang_wei_zhi_er,
- ypInfoList[yp].shou_yang_wei_zhi_san, ypInfoList[yp].liu_yang_wei_zhi_san,
- ypInfoList[yp].shou_yang_wei_zhi_si, ypInfoList[yp].liu_yang_wei_zhi_si
- )
- let o = {
- where:{
- id_ : ypInfoList[yp].id_
- },
- param:{
- yang_pin_lei_xing: ypInfoList[yp].yang_pin_lei_xing,
- yang_ben_yun_shu_: ypInfoList[yp].yang_ben_yun_shu_,
- shu_liang_: ypInfoList[yp].shu_liang_,
- yang_pin_gui_ge_: ypInfoList[yp].yang_pin_gui_ge_,
- yang_pin_lei_er_: ypInfoList[yp].yang_pin_lei_er_,
- yang_pin_yun_shu_: ypInfoList[yp].yang_pin_yun_shu_,
- shu_liang_er_: ypInfoList[yp].shu_liang_er_,
- yang_pin_gui_ge_e: ypInfoList[yp].yang_pin_gui_ge_e,
- yang_pin_lei_san_: ypInfoList[yp].yang_pin_lei_san_,
- yang_pin_yun_san: ypInfoList[yp].yang_pin_yun_san,
- shu_liang_san_: ypInfoList[yp].shu_liang_san_,
- yang_pin_gui_ge_s: ypInfoList[yp].yang_pin_gui_ge_s,
- yang_pin_lei_si_: ypInfoList[yp].yang_pin_lei_si_,
- yang_pin_yun_si_: ypInfoList[yp].yang_pin_yun_si_,
- shu_liang_si_: ypInfoList[yp].shu_liang_si_,
- yang_pin_gui_si_: ypInfoList[yp].yang_pin_gui_si_,
- jie_yang_zhuang_t:"已接收",
- yang_pin_zong_shu:ypInfoList[yp].yang_pin_zong_shu,
- bei_zhu_1_:ypInfoList[yp].bei_zhu_1_
- }
- }
- sampleList.push(o)
- }
- localStr = localArr.filter(i => i).join(',')
- let value = ''
- let lhypIdStr = ''
- for (let i = 0; i < lhypbWJ.length; i++) {
- value += lhypbWJ[i] + ','
- }
- value = value.substring(0, value.length - 1)
- value = value.replace(/,/g, "','")
- for (let i = 0; i < lhypIdList.length; i++) {
- lhypIdStr += lhypIdList[i] + ','
- }
- lhypIdStr = lhypIdStr.substring(0, lhypIdStr.length - 1)
- lhypIdStr = lhypIdStr.replace(/,/g, "','")
- 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}')`
- // console.log(allSQL)
- // 搜集所有选择的位置信息
- // console.log('当前选择的位置ids:',locationIds)
- var allLocal = `select * from t_ypcfwz where find_in_set(id_,'${localStr}')`
- Promise.all([repostCurd("sql", allSQL), repostCurd("sql", allLocal)]).then((res) => {
- let initResult = res[0].variables.data
- let result = []
- let localInfo = res[1].variables.data
- // 排序
- ypInfoList.forEach(item=>{
- result.push(initResult.find(i => i.yang_pin_bian_hao === item.yang_pin_bian_hao))
- })
- // console.log(localInfo)
- /* 1、更新货架位置信息 */
- this.emptyLocal = []
- this.fullLocal = []
- let allUUID = []
- ypInfoList.forEach(item => {
- allUUID.push(item.biao_zhi_uuid_1, item.biao_zhi_uuid_2, item.biao_zhi_uuid_3, item.biao_zhi_uuid_4)
- let allResult = []
- if(item.shou_yang_wei_zhi_yi != undefined && item.shou_yang_wei_zhi_yi){
- 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))
- }
- if (item.shou_yang_wei_zhi_er != undefined && item.shou_yang_wei_zhi_er) {
- 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))
- }
- if (item.shou_yang_wei_zhi_san != undefined && item.shou_yang_wei_zhi_san) {
- 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))
- }
- if (item.shou_yang_wei_zhi_si != undefined && item.shou_yang_wei_zhi_si) {
- 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))
- }
- if(item.liu_yang_wei_zhi_yi != undefined && item.liu_yang_wei_zhi_yi && item.shi_fou_liu_yang_yi === '是'){
- 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))
- }
- if (item.liu_yang_wei_zhi_er != undefined && item.liu_yang_wei_zhi_er && item.shi_fou_liu_yang_er === '是') {
- 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))
- }
- if (item.liu_yang_wei_zhi_san != undefined && item.liu_yang_wei_zhi_san && item.shi_fou_liu_yang_san === '是') {
- 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))
- }
- if (item.liu_yang_wei_zhi_si != undefined && item.liu_yang_wei_zhi_si && item.shi_fou_liu_yang_si === '是') {
- 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))
- }
- allResult.forEach(item => {
- item.name === 'emptyLocation' ? this.emptyLocal.push(item.value) : this.fullLocal.push(item.value)
- })
- })
- let allUUIDStr = allUUID.filter(i => i).join(',')
- // 更新样品位置list
- // console.log('emptyLocal:',this.emptyLocal)
- if(this.emptyLocal.length > 0){
- let allParams = {
- tableName: 't_ypcfwz',
- updList: this.emptyLocal
- }
- repostCurd('updatesByWhere', JSON.stringify(allParams))
- }
- // 插入样品位置list
- console.log('fullLocal:',this.fullLocal)
- if(this.fullLocal.length == 0){
- /* 2、封装样品登记表对象,插入样品登记表 顺便封装任务分配表 */
- let ypdjb = []
- let rws = []
- console.log(result)
- console.log(ypInfoList)
- result.forEach((item, index) => {
- // 2-1:统计每个样品有多少类型[数量]
- let lxList = []
- let ypggList = []
- let liuYangList = []
- 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_)
- ypggList.push(
- ypInfoList[index].yang_pin_gui_ge_? ypInfoList[index].yang_pin_gui_ge_ +'*'+ ypInfoList[index].shu_liang_+ ypInfoList[index].dan_wei_yi:'',
- ypInfoList[index].yang_pin_gui_ge_e? ypInfoList[index].yang_pin_gui_ge_e+'*'+ ypInfoList[index].shu_liang_er_+ ypInfoList[index].dan_wei_er:'',
- ypInfoList[index].yang_pin_gui_ge_s?ypInfoList[index].yang_pin_gui_ge_s +'*'+ ypInfoList[index].shu_liang_san_+ ypInfoList[index].dan_wei_san:'',
- ypInfoList[index].yang_pin_gui_si_?ypInfoList[index].yang_pin_gui_si_ +'*'+ ypInfoList[index].shu_liang_si_+ ypInfoList[index].dan_wei_si:'')
- 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)
- let yplxz = lxList.filter(i => i).join(';')
- let ypggStr = ypggList.filter(i => i).join(';')
- let liuyangStr = liuYangList.filter(i => i).join(';')
- // let count = lxList.filter(i => i).join(',').match(/,/g).length + 1
- // let size = lxList.filter(i => i).join(',').match(/,/g)
- // let count = 1
- // size == null ? count = 1 : count = size.length + 1
- let xmmc = []
- xmmc.push(item.chang_gui_xiang_m, item.tao_can_ming_chen)
- let xiangMuZh = xiangMuZh = xmmc.filter(i => i).join(',')
- for (let c = 0; c < 4; c++) {
- let yblx = c == 0 ? ypInfoList[index].yang_pin_lei_xing :
- c == 1 ? ypInfoList[index].yang_pin_lei_er_ :
- c == 2 ? ypInfoList[index].yang_pin_lei_san_ :
- c == 3 ? ypInfoList[index].yang_pin_lei_si_ : ''
- // fix样品类型不按顺序进行填写
- if(!yblx){
- console.log('current',c)
- continue
- }
- let ystj = c == 0 ? ypInfoList[index].yang_ben_yun_shu_ :
- c == 1 ? ypInfoList[index].yang_pin_yun_shu_ :
- c == 2 ? ypInfoList[index].yang_pin_yun_san :
- c == 3 ? ypInfoList[index].yang_pin_yun_si_ : ''
- let ypsl = c == 0 ? ypInfoList[index].shu_liang_ :
- c == 1 ? ypInfoList[index].shu_liang_er_ :
- c == 2 ? ypInfoList[index].shu_liang_san_ :
- c == 3 ? ypInfoList[index].shu_liang_si_ : ''
- let ybgg = c == 0 ? ypInfoList[index].yang_pin_gui_ge_ :
- c == 1 ? ypInfoList[index].yang_pin_gui_ge_e :
- c == 2 ? ypInfoList[index].yang_pin_gui_ge_s :
- c == 3 ? ypInfoList[index].yang_pin_gui_si_ : ''
- let sywz = c == 0 ? ypInfoList[index].shou_yang_wei_zhi_yi :
- c == 1 ? ypInfoList[index].shou_yang_wei_zhi_er :
- c == 2 ? ypInfoList[index].shou_yang_wei_zhi_san :
- c == 3 ? ypInfoList[index].shou_yang_wei_zhi_si : ''
- let lycf = c == 0 ? ypInfoList[index].liu_yang_wei_zhi_yi :
- c == 1 ? ypInfoList[index].liu_yang_wei_zhi_er :
- c == 2 ? ypInfoList[index].liu_yang_wei_zhi_san :
- c == 3 ? ypInfoList[index].liu_yang_wei_zhi_si : ''
- let lysl = c == 0 ? ypInfoList[index].liu_yang_shu_lian_yi :
- c == 1 ? ypInfoList[index].liu_yang_shu_lian_er :
- c == 2 ? ypInfoList[index].liu_yang_shu_lian_san :
- c == 3 ? ypInfoList[index].liu_yang_shu_lian_si : ''
- let currentUUID = c == 0 ? ypInfoList[index].biao_zhi_uuid_1 :
- c == 1 ? ypInfoList[index].biao_zhi_uuid_2 :
- c == 2 ? ypInfoList[index].biao_zhi_uuid_3 :
- c == 3 ? ypInfoList[index].biao_zhi_uuid_4 : ''
- let ifLy = c == 0 ? ypInfoList[index].shi_fou_liu_yang_yi :
- c == 1 ? ypInfoList[index].shi_fou_liu_yang_er :
- c == 2 ? ypInfoList[index].shi_fou_liu_yang_san:
- c == 3 ? ypInfoList[index].shi_fou_liu_yang_si : ''
- // let obj = {
- // wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
- // wei_tuo_dan_wei_: item.wtdh,
- // lian_xi_ren_: item.wei_tuo_fang_lian,
- // lian_xi_dian_hua_: item.wei_tuo_lian,
- // yang_ben_ming_che: item.yang_pin_ming_che,
- // yang_ben_bian_hao: item.yang_pin_bian_hao,
- // pi_hao_bian_hao_: item.song_jian_pi_hao_,
- // song_jian_dan_wei: item.song_jian_dan_wei,
- // xing_ming_: ypInfoList[index].xing_ming_ || '',
- // xing_bie_: ypInfoList[index].xing_bie_ || '',
- // nian_ling_: ypInfoList[index].nian_ling_ || '',
- // yang_ben_zhuang_t: item.yang_pin_zhuang_t,
- // shou_yang_ri_qi_: currentTime,
- // bei_zhu_: ypInfoList[index].bei_zhu_1_ || '',
- // yang_ben_lei_xing: yblx,
- // yun_shu_tiao_jian: ystj,
- // yang_pin_shu_lian: ypsl,
- // yang_ben_gui_ge_s: ybgg,
- // yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
- // cun_fang_wei_zhi_: sywz || '',
- // liu_zhuan_zhuang_: '待任务分配',
- // shi_fou_liu_yang_: ifLy,
- // liu_yang_ri_qi_: ifLy == '是'? ypInfoList[index].liu_yang_ri_qi_:'',
- // liu_yang_cun_fang: ifLy == '是'?(lycf ? lycf : ''):'',
- // liu_yang_shu_lian: ifLy == '是'? (lysl == null ?'':lysl) : '',
- // liu_yang_qi_xian: ifLy == '是'? ypInfoList[index].liu_yang_qi_xian:'',
- // xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_ || '',
- // fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_ || '',
- // fan_yang_jyr: ypInfoList[index].fan_yang_jyr || '',
- // biao_zhi_uuid_: currentUUID,
- // song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu || '',
- // jian_ce_xiang_mu_: xiangMuZh,
- // shou_yang_ren_:this.$store.getters.userInfo.user.name,
- // wei_tuo_lei_xing_:item.wei_tuo_lei_xing_
- // }
- // // console.log(obj)
- // ypdjb.push(obj)
- const sql = `select bao_gao_zhou_qi_g from t_mjjcnlfw where FIND_IN_SET(id_,'${item.jian_ce_xiang_mu_}')`
- var maxAge
- repostCurd('sql', sql).then((res) => {
- const { data = [] } = res.variables || {}
- maxAge = data.reduce((max, person) => {
- // 将age从字符串转换为数字
- const maxNum = parseInt(person.bao_gao_zhou_qi_g)
- // 使用三元表达式比较并更新最大值
- return maxNum > max ? maxNum : max
- }, 0)
- const currentDate = new Date()
- // 创建一个新的日期对象,表示当前日期加上3天
- const futureDate = new Date(currentDate)
- futureDate.setDate(currentDate.getDate() + Number(maxAge))
- // 获取年、月、日
- const year = futureDate.getFullYear()
- const month = String(futureDate.getMonth() + 1).padStart(2, '0')
- // 月份从0开始,所以需要加1
- const day = String(futureDate.getDate()).padStart(2, '0')
- // 格式化为YYYY-MM-DD
- const formattedDate = `${year}-${month}-${day}`
- // console.log('maxAge', formattedDate)
- const obj = {
- wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
- wei_tuo_dan_wei_: item.wtdh,
- lian_xi_ren_: item.wei_tuo_fang_lian,
- lian_xi_dian_hua_: item.wei_tuo_lian,
- yang_ben_ming_che: item.yang_pin_ming_che,
- yang_ben_bian_hao: item.yang_pin_bian_hao,
- pi_hao_bian_hao_: item.song_jian_pi_hao_,
- song_jian_dan_wei: item.song_jian_dan_wei,
- xing_ming_: ypInfoList[index].xing_ming_ || '',
- xing_bie_: ypInfoList[index].xing_bie_ || '',
- nian_ling_: ypInfoList[index].nian_ling_ || '',
- yang_ben_zhuang_t: item.yang_pin_zhuang_t,
- shou_yang_ri_qi_: currentTime,
- bei_zhu_: ypInfoList[index].bei_zhu_1_ || '',
- yang_ben_lei_xing: yblx,
- yun_shu_tiao_jian: ystj,
- yang_pin_shu_lian: ypsl,
- yang_ben_gui_ge_s: ybgg,
- yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
- cun_fang_wei_zhi_: sywz || '',
- liu_zhuan_zhuang_: '待任务分配',
- shi_fou_liu_yang_: ifLy,
- liu_yang_ri_qi_: ifLy == '是' ? ypInfoList[index].liu_yang_ri_qi_ : '',
- liu_yang_cun_fang: ifLy == '是' ? (lycf || '') : '',
- liu_yang_shu_lian: ifLy == '是' ? (lysl == null ? '' : lysl) : '',
- liu_yang_qi_xian: ifLy == '是' ? ypInfoList[index].liu_yang_qi_xian : '',
- xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_ || '',
- fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_ || '',
- fan_yang_jyr: ypInfoList[index].fan_yang_jyr || '',
- biao_zhi_uuid_: currentUUID,
- song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu || '',
- jian_ce_xiang_mu_: xiangMuZh,
- shou_yang_ren_: this.$store.getters.userInfo.user.name,
- wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
- bao_gao_zhou_qi_g: formattedDate
- }
- // console.log(obj)
- ypdjb.push(obj)
- })
- }
- // 2-2:封装任务分配表
- let rw = {
- yang_pin_ming_che: item.yang_pin_ming_che,
- yang_pin_bian_hao: item.yang_pin_bian_hao,
- wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
- yang_pin_lei_xing: yplxz,
- yang_pin_gui_ge_: ypggStr,
- wei_tuo_id_: item.wtID,
- he_tong_id_: item.he_tong_id_,
- zhuang_tai_: '待任务分配',
- wan_cheng_shi_jia: item.song_jian_shi_jia,
- shou_yang_ri_qi_: currentTime,
- bao_gao_lei_xing_: item.bao_gao_lei_xing_,
- xin_xiang_mu_ming: item.xiang_mu_ming_che,
- zhan_shi_biao_id_: item.zhan_shi_biao_id_,
- fen_zhuang_liu_ya: liuyangStr,
- shi_fou_jia_ji_: item.chu_ju_bao_gao_ya, // 是否加急【2023/2/23王提出】
- yang_pin_shu_lian: ypInfoList[index].jie_yang_shu_lian, // 样品确认总数【2023/3/7王提出】
- suo_you_xiang_mu_: xiangMuZh, // 所有项目的中文名称 【2023/12/11 Mr王】
- song_jian_pi_hao_: item.song_jian_pi_hao_// 送检批号 【2023/12/11 Mr王】
- }
- rws.push(rw)
- lhwtzsbID.push('{"shen_qing_id_":"' + item.zhan_shi_biao_id_ + '"}')
- lhwtbID.push('{"id_":"' + item.wtID + '"}')
- })
- /* 4、任务分配
- 4-1、根据 wtdAndYpb 的 wtID 更改委托表的 委托状态 wei_tuo_zhuang_ta 变成 已完成
- 4-2、根据每个样品一个任务分配流程 遍历样品表开任务分配流程
- 4-3、委托表找zhan_shi_biao_id_ 修改 t_lhwtzsb "zhuang_tai_"为"任务分配进行中"
- 优化:将其他不冲突的更改状态脚本放在任务分配后并行处理
- */
- // console.log("4、任务分配",rws) 2023/12/11 Mr王 去掉 ,"defKey":"Process_04o0csc","formKey":"lhrwfp"
- repostCurd('add', '{"tableName":"t_lhrwfpb","paramWhere":' + JSON.stringify(rws) + '}').then(res=>{
- // console.log('4、更改委托表的 委托状态',lhwtbID)
- repostCurd('updates', '{"tableName":"t_lhwtsqb","paramWhere":[' + lhwtbID + '],"paramCond":{"wei_tuo_zhuang_ta":"已完成"}}')
- /* 5、更新展示表 */
- if (lhwtzsbID.length > 0) {
- // console.log('5、更新展示表',lhwtzsbID)
- repostCurd('updates', '{"tableName":"t_lhwtzsb","paramWhere":[' + lhwtzsbID + '],"paramCond":{"zhuang_tai_":"任务分配进行中"}}')
- }
- console.log('样品登记表:',ypdjb)
- if(ypdjb.length > 0){
- repostCurd('add', '{"tableName":"t_lhypdjb","paramWhere":' + JSON.stringify(ypdjb) + '}').then(()=>{
- console.log("样品登记表数据添加成功!")
- this.$emit('callback', true)
- }).catch(error =>{
- console.log(error)
- this.handleAnySituation(true,"样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决",'error')
- })
- }else{
- this.handleAnySituation(true,"样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决",'error')
- }
- /* 3、更新样品表
- // console.log('3、更新样品表',lhypIdNewList)
- repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}').then(res=>{
- this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
- })
- */
- console.log('更新样品表',sampleList)
- let allSampleParams ={
- tableName:'t_lhypb',
- updList:sampleList
- }
- repostCurd('updatesByWhere', JSON.stringify(allSampleParams)).then(res=>{
- this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
- })
- })
- }else{
- repostCurd('add', '{"tableName":"t_ypcfwz","paramWhere":' + JSON.stringify(this.fullLocal) + '}').then(res => {
- // 再次查询位置表,对比当前样品列表 替换初始值为占用的样品位置id
- let findLocationAgain = `select id_,shi_fou_liu_yang_,biao_zhi_uuid_ from t_ypcfwz where find_in_set(biao_zhi_uuid_,'${allUUIDStr}')`
- // console.log(findLocationAgain)
- repostCurd('sql', findLocationAgain).then(res => {
- let data = res.variables.data
- let uuidArgs = ['biao_zhi_uuid_1', 'biao_zhi_uuid_2', 'biao_zhi_uuid_3', 'biao_zhi_uuid_4']
- let shouYangArgs = ['shou_yang_wei_zhi_yi', 'shou_yang_wei_zhi_er', 'shou_yang_wei_zhi_san', 'shou_yang_wei_zhi_si']
- let liuYangArgs = ['liu_yang_wei_zhi_yi', 'liu_yang_wei_zhi_er', 'liu_yang_wei_zhi_san', 'liu_yang_wei_zhi_si']
- data.forEach(item => {
- uuidArgs.forEach((uuid, index) => {
- let ypIndex = ypInfoList.findIndex(i => i[uuid] === item.biao_zhi_uuid_)
- if (ypIndex != -1) {
- item.shi_fou_liu_yang_ === '否' ?
- ypInfoList[ypIndex][shouYangArgs[index]] = item.id_ :
- ypInfoList[ypIndex][liuYangArgs[index]] = item.id_
- }
- })
- })
-
- // repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}')
-
- /* 2、封装样品登记表对象,插入样品登记表 顺便封装任务分配表 */
- let ypdjb = []
- let rws = []
- console.log(result)
- console.log(ypInfoList)
- result.forEach((item, index) => {
- // 2-1:统计每个样品有多少类型[数量]
- let lxList = []
- let ypggList = []
- let liuYangList = []
- 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_)
- ypggList.push(
- ypInfoList[index].yang_pin_gui_ge_? ypInfoList[index].yang_pin_gui_ge_ +'*'+ ypInfoList[index].shu_liang_+ ypInfoList[index].dan_wei_yi:'',
- ypInfoList[index].yang_pin_gui_ge_e? ypInfoList[index].yang_pin_gui_ge_e+'*'+ ypInfoList[index].shu_liang_er_+ ypInfoList[index].dan_wei_er:'',
- ypInfoList[index].yang_pin_gui_ge_s?ypInfoList[index].yang_pin_gui_ge_s +'*'+ ypInfoList[index].shu_liang_san_+ ypInfoList[index].dan_wei_san:'',
- ypInfoList[index].yang_pin_gui_si_?ypInfoList[index].yang_pin_gui_si_ +'*'+ ypInfoList[index].shu_liang_si_+ ypInfoList[index].dan_wei_si:'')
- 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)
- let yplxz = lxList.filter(i => i).join(';')
- let ypggStr = ypggList.filter(i => i).join(';')
- let liuyangStr = liuYangList.filter(i => i).join(';')
- // let count = lxList.filter(i => i).join(',').match(/,/g).length + 1
- // let size = lxList.filter(i => i).join(',').match(/,/g)
- // let count = 1
- // size == null ? count = 1 : count = size.length + 1
- let xmmc = []
- xmmc.push(item.chang_gui_xiang_m, item.tao_can_ming_chen)
- let xiangMuZh = xiangMuZh = xmmc.filter(i => i).join(',')
- for (let c = 0; c < 4; c++) {
- let yblx = c == 0 ? ypInfoList[index].yang_pin_lei_xing :
- c == 1 ? ypInfoList[index].yang_pin_lei_er_ :
- c == 2 ? ypInfoList[index].yang_pin_lei_san_ :
- c == 3 ? ypInfoList[index].yang_pin_lei_si_ : ''
- // fix样品类型不按顺序进行填写
- if(!yblx){
- console.log('current',c)
- continue
- }
- let ystj = c == 0 ? ypInfoList[index].yang_ben_yun_shu_ :
- c == 1 ? ypInfoList[index].yang_pin_yun_shu_ :
- c == 2 ? ypInfoList[index].yang_pin_yun_san :
- c == 3 ? ypInfoList[index].yang_pin_yun_si_ : ''
- let ypsl = c == 0 ? ypInfoList[index].shu_liang_ :
- c == 1 ? ypInfoList[index].shu_liang_er_ :
- c == 2 ? ypInfoList[index].shu_liang_san_ :
- c == 3 ? ypInfoList[index].shu_liang_si_ : ''
- let ybgg = c == 0 ? ypInfoList[index].yang_pin_gui_ge_ :
- c == 1 ? ypInfoList[index].yang_pin_gui_ge_e :
- c == 2 ? ypInfoList[index].yang_pin_gui_ge_s :
- c == 3 ? ypInfoList[index].yang_pin_gui_si_ : ''
- let sywz = c == 0 ? ypInfoList[index].shou_yang_wei_zhi_yi :
- c == 1 ? ypInfoList[index].shou_yang_wei_zhi_er :
- c == 2 ? ypInfoList[index].shou_yang_wei_zhi_san :
- c == 3 ? ypInfoList[index].shou_yang_wei_zhi_si : ''
- let lycf = c == 0 ? ypInfoList[index].liu_yang_wei_zhi_yi :
- c == 1 ? ypInfoList[index].liu_yang_wei_zhi_er :
- c == 2 ? ypInfoList[index].liu_yang_wei_zhi_san :
- c == 3 ? ypInfoList[index].liu_yang_wei_zhi_si : ''
- let lysl = c == 0 ? ypInfoList[index].liu_yang_shu_lian_yi :
- c == 1 ? ypInfoList[index].liu_yang_shu_lian_er :
- c == 2 ? ypInfoList[index].liu_yang_shu_lian_san :
- c == 3 ? ypInfoList[index].liu_yang_shu_lian_si : ''
- let currentUUID = c == 0 ? ypInfoList[index].biao_zhi_uuid_1 :
- c == 1 ? ypInfoList[index].biao_zhi_uuid_2 :
- c == 2 ? ypInfoList[index].biao_zhi_uuid_3 :
- c == 3 ? ypInfoList[index].biao_zhi_uuid_4 : ''
- let ifLy = c == 0 ? ypInfoList[index].shi_fou_liu_yang_yi :
- c == 1 ? ypInfoList[index].shi_fou_liu_yang_er :
- c == 2 ? ypInfoList[index].shi_fou_liu_yang_san:
- c == 3 ? ypInfoList[index].shi_fou_liu_yang_si : ''
- // let obj = {
- // wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
- // wei_tuo_dan_wei_: item.wtdh,
- // lian_xi_ren_: item.wei_tuo_fang_lian,
- // lian_xi_dian_hua_: item.wei_tuo_lian,
- // yang_ben_ming_che: item.yang_pin_ming_che,
- // yang_ben_bian_hao: item.yang_pin_bian_hao,
- // pi_hao_bian_hao_: item.song_jian_pi_hao_,
- // song_jian_dan_wei: item.song_jian_dan_wei,
- // xing_ming_: ypInfoList[index].xing_ming_ || '',
- // xing_bie_: ypInfoList[index].xing_bie_ || '',
- // nian_ling_: ypInfoList[index].nian_ling_ || '',
- // yang_ben_zhuang_t: item.yang_pin_zhuang_t,
- // shou_yang_ri_qi_: currentTime,
- // bei_zhu_: ypInfoList[index].bei_zhu_1_ || '',
- // yang_ben_lei_xing: yblx,
- // yun_shu_tiao_jian: ystj,
- // yang_pin_shu_lian: ypsl,
- // yang_ben_gui_ge_s: ybgg,
- // yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
- // cun_fang_wei_zhi_: sywz || '',
- // liu_zhuan_zhuang_: '待任务分配',
- // shi_fou_liu_yang_: ifLy,
- // liu_yang_ri_qi_: ifLy == '是'? ypInfoList[index].liu_yang_ri_qi_:'',
- // liu_yang_cun_fang: ifLy == '是'?(lycf ? lycf : ''):'',
- // liu_yang_shu_lian: ifLy == '是'? (lysl == null ?'':lysl) : '',
- // liu_yang_qi_xian: ifLy == '是'? ypInfoList[index].liu_yang_qi_xian:'',
- // xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_ || '',
- // fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_ || '',
- // fan_yang_jyr: ypInfoList[index].fan_yang_jyr || '',
- // biao_zhi_uuid_: currentUUID,
- // song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu || '',
- // jian_ce_xiang_mu_: xiangMuZh,
- // shou_yang_ren_:this.$store.getters.userInfo.user.name,
- // wei_tuo_lei_xing_:item.wei_tuo_lei_xing_
- // }
- // // console.log(obj)
- // ypdjb.push(obj)
- const sql = `select bao_gao_zhou_qi_g from t_mjjcnlfw where FIND_IN_SET(id_,'${item.jian_ce_xiang_mu_}')`
- var maxAge
- repostCurd('sql', sql).then((res) => {
- const { data = [] } = res.variables || {}
- maxAge = data.reduce((max, person) => {
- // 将age从字符串转换为数字
- const maxNum = parseInt(person.bao_gao_zhou_qi_g)
- // 使用三元表达式比较并更新最大值
- return maxNum > max ? maxNum : max
- }, 0)
- const currentDate = new Date()
- // 创建一个新的日期对象,表示当前日期加上3天
- const futureDate = new Date(currentDate)
- futureDate.setDate(currentDate.getDate() + Number(maxAge))
- // 获取年、月、日
- const year = futureDate.getFullYear()
- const month = String(futureDate.getMonth() + 1).padStart(2, '0')
- // 月份从0开始,所以需要加1
- const day = String(futureDate.getDate()).padStart(2, '0')
- // 格式化为YYYY-MM-DD
- const formattedDate = `${year}-${month}-${day}`
- // console.log('maxAge', formattedDate)
- const obj = {
- wei_tuo_dan_hao_: item.wei_tuo_bian_hao_,
- wei_tuo_dan_wei_: item.wtdh,
- lian_xi_ren_: item.wei_tuo_fang_lian,
- lian_xi_dian_hua_: item.wei_tuo_lian,
- yang_ben_ming_che: item.yang_pin_ming_che,
- yang_ben_bian_hao: item.yang_pin_bian_hao,
- pi_hao_bian_hao_: item.song_jian_pi_hao_,
- song_jian_dan_wei: item.song_jian_dan_wei,
- xing_ming_: ypInfoList[index].xing_ming_ || '',
- xing_bie_: ypInfoList[index].xing_bie_ || '',
- nian_ling_: ypInfoList[index].nian_ling_ || '',
- yang_ben_zhuang_t: item.yang_pin_zhuang_t,
- shou_yang_ri_qi_: currentTime,
- bei_zhu_: ypInfoList[index].bei_zhu_1_ || '',
- yang_ben_lei_xing: yblx,
- yun_shu_tiao_jian: ystj,
- yang_pin_shu_lian: ypsl,
- yang_ben_gui_ge_s: ybgg,
- yan_shou_jie_guo_: ypInfoList[index].yan_shou_jie_guo_,
- cun_fang_wei_zhi_: sywz || '',
- liu_zhuan_zhuang_: '待任务分配',
- shi_fou_liu_yang_: ifLy,
- liu_yang_ri_qi_: ifLy == '是' ? ypInfoList[index].liu_yang_ri_qi_ : '',
- liu_yang_cun_fang: ifLy == '是' ? (lycf || '') : '',
- liu_yang_shu_lian: ifLy == '是' ? (lysl == null ? '' : lysl) : '',
- liu_yang_qi_xian: ifLy == '是' ? ypInfoList[index].liu_yang_qi_xian : '',
- xiao_hui_ri_qi_: ypInfoList[index].xiao_hui_ri_qi_ || '',
- fan_yang_ri_qi_: ypInfoList[index].fan_yang_ri_qi_ || '',
- fan_yang_jyr: ypInfoList[index].fan_yang_jyr || '',
- biao_zhi_uuid_: currentUUID,
- song_yang_yao_qiu: ypInfoList[index].song_yang_yao_qiu || '',
- jian_ce_xiang_mu_: xiangMuZh,
- shou_yang_ren_: this.$store.getters.userInfo.user.name,
- wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
- bao_gao_zhou_qi_g: formattedDate
- }
- // console.log(obj)
- ypdjb.push(obj)
- })
- }
- // 2-2:封装任务分配表
- let rw = {
- yang_pin_ming_che: item.yang_pin_ming_che,
- yang_pin_bian_hao: item.yang_pin_bian_hao,
- wei_tuo_lei_xing_: item.wei_tuo_lei_xing_,
- yang_pin_lei_xing: yplxz,
- yang_pin_gui_ge_: ypggStr,
- wei_tuo_id_: item.wtID,
- he_tong_id_: item.he_tong_id_,
- zhuang_tai_: '待任务分配',
- wan_cheng_shi_jia: item.song_jian_shi_jia,
- shou_yang_ri_qi_: currentTime,
- bao_gao_lei_xing_: item.bao_gao_lei_xing_,
- xin_xiang_mu_ming: item.xiang_mu_ming_che,
- zhan_shi_biao_id_: item.zhan_shi_biao_id_,
- fen_zhuang_liu_ya: liuyangStr,
- shi_fou_jia_ji_: item.chu_ju_bao_gao_ya, // 是否加急【2023/2/23王嘎嘎提出】
- yang_pin_shu_lian: ypInfoList[index].jie_yang_shu_lian, // 样品确认总数【2023/3/7王嘎嘎提出】
- suo_you_xiang_mu_: xiangMuZh, // 所有项目的中文名称 【2023/12/11 Mr王】
- song_jian_pi_hao_: item.song_jian_pi_hao_// 送检批号 【2023/12/11 Mr王】
- }
- rws.push(rw)
-
- lhwtzsbID.push('{"shen_qing_id_":"' + item.zhan_shi_biao_id_ + '"}')
- lhwtbID.push('{"id_":"' + item.wtID + '"}')
-
- })
-
-
- /* 4、任务分配
- 4-1、根据 wtdAndYpb 的 wtID 更改委托表的 委托状态 wei_tuo_zhuang_ta 变成 已完成
- 4-2、根据每个样品一个任务分配流程 遍历样品表开任务分配流程
- 4-3、委托表找zhan_shi_biao_id_ 修改 t_lhwtzsb "zhuang_tai_"为"任务分配进行中"
-
- 优化:将其他不冲突的更改状态脚本放在任务分配后并行处理
- */
- // console.log("4、任务分配",rws) 2023/12/11 Mr王 去掉 ,"defKey":"Process_04o0csc","formKey":"lhrwfp"
- repostCurd('add', '{"tableName":"t_lhrwfpb","paramWhere":' + JSON.stringify(rws) + '}').then(res=>{
- // console.log('4、更改委托表的 委托状态',lhwtbID)
- repostCurd('updates', '{"tableName":"t_lhwtsqb","paramWhere":[' + lhwtbID + '],"paramCond":{"wei_tuo_zhuang_ta":"已完成"}}')
- /* 5、更新展示表 */
- if (lhwtzsbID.length > 0) {
- // console.log('5、更新展示表',lhwtzsbID)
- repostCurd('updates', '{"tableName":"t_lhwtzsb","paramWhere":[' + lhwtzsbID + '],"paramCond":{"zhuang_tai_":"任务分配进行中"}}')
- }
- console.log('样品登记表:',ypdjb)
- if(ypdjb.length > 0){
- repostCurd('add', '{"tableName":"t_lhypdjb","paramWhere":' + JSON.stringify(ypdjb) + '}').then(()=>{
- console.log("样品登记表数据添加成功!")
- this.$emit('callback', true)
- }).catch(error =>{
- console.log(error)
- this.handleAnySituation(true,"样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决",'error')
- })
- }else{
- this.handleAnySituation(true,"样品登记表数据添加失败!请勿关闭此页面,联系开发人员解决",'error')
- }
- /* 3、更新样品表
- // console.log('3、更新样品表',lhypIdNewList)
- repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}').then(res=>{
- this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
- })
- */
- console.log('更新样品表',sampleList)
- let allSampleParams ={
- tableName:'t_lhypb',
- updList:sampleList
- }
- repostCurd('updatesByWhere', JSON.stringify(allSampleParams)).then(res=>{
- this.handleAnySituation(true,"样品成功接收,正在开启任务分配!",'success')
- })
-
- })
-
-
- })
- })
- }
- })
- }).catch(_ => { });
- }
- },
- /* 去除指定行数据 使用过滤器filter过滤指定行号数据 */
- deleteData(val) {
- this.listData = this.listData.filter((data) => {
- return data.id_ != val
- })
- },
- uuid() {
- var s = [];
- var hexDigits = "0123456789abcdef";
- for (var i = 0; i < 36; i++) {
- s[i] = hexDigits.substr(Math.floor(Math.random() * 0x10), 1);
- }
- s[14] = "4"; // bits 12-15 of the time_hi_and_version field to 0010
- s[19] = hexDigits.substr((s[19] & 0x3) | 0x8, 1); // bits 6-7 of the clock_seq_hi_and_reserved to 01
- s[8] = s[13] = s[18] = s[23] = "-";
- var uuid = s.join("");
- return uuid;
- },
- unique(arr) {
- return arr.filter((item, index) => {
- return arr.indexOf(item, 0) === index;
- });
- },
- // 根据旧位置数据生成新位置数据
- generateNewLocation(oldLocation, sampleInfo) {
- let temp = {
- fang_jian_lei_xin: oldLocation.fang_jian_lei_xin,
- wei_zhi_: oldLocation.wei_zhi_,
- qu_yu_: oldLocation.qu_yu_,
- huo_jia_lei_xing_: oldLocation.huo_jia_lei_xing_,
- huo_jia_hao_: oldLocation.huo_jia_hao_,
- ceng_hao_: oldLocation.ceng_hao_,
- shui_ping_fen_qu_: oldLocation.shui_ping_fen_qu_,
- wei_zhi_bian_hao_: oldLocation.wei_zhi_bian_hao_,
- wei_zhi_zhuang_ta: oldLocation.wei_zhi_zhuang_ta,
- cun_chu_tiao_jian: oldLocation.cun_chu_tiao_jian,
- shi_fou_guo_shen_: '启用',
- yang_pin_bian_hao: sampleInfo.yang_pin_bian_hao,
- yang_pin_ming_che: sampleInfo.yang_pin_ming_che,
- ru_ku_shi_jian_: sampleInfo.ru_ku_shi_jian_,
- shi_fou_liu_yang_: sampleInfo.shi_fou_liu_yang_,
- biao_zhi_uuid_: sampleInfo.biao_zhi_uuid_,
- yang_pin_lei_xing: sampleInfo.type,
- liu_yang_shu_lian: sampleInfo.num
- }
- return temp
- },
- handleLocationInfo(currentLocation, isLiuYang, localInfo, locationIds, item, UUID, currentTime, sampleType, liuYangNum) {
- !locationIds.has(currentLocation) ? locationIds.add(currentLocation) : localInfo.find(i => i.id_ === currentLocation).wei_zhi_zhuang_ta = '占用'
- if (localInfo.find(i => i.id_ === currentLocation) != undefined && localInfo.find(i => i.id_ === currentLocation).wei_zhi_zhuang_ta === '空余') {
- let obj = {
- where: {
- id_: currentLocation
- },
- param: {
- wei_zhi_zhuang_ta: "占用",
- ru_ku_shi_jian_: currentTime,
- yang_pin_bian_hao: item.yang_pin_bian_hao,
- yang_pin_ming_che: item.yang_pin_ming_che,
- shi_fou_liu_yang_: isLiuYang,
- yang_pin_lei_xing: sampleType,
- liu_yang_shu_lian: liuYangNum == null ? '' : liuYangNum
- }
- }
- let result = {
- name: 'emptyLocation',
- value: obj
- }
- return result
- } else { // 新增一条位置信息(修改它的样品编号,样品名称,入库时间,标识UUID)
- let sampleInfo = {
- yang_pin_bian_hao: item.yang_pin_bian_hao,
- yang_pin_ming_che: item.yang_pin_ming_che,
- ru_ku_shi_jian_: currentTime,
- biao_zhi_uuid_: UUID,
- shi_fou_liu_yang_: isLiuYang,
- type: sampleType,
- num: liuYangNum == null ? '' : liuYangNum
- }
- let newLocation = this.generateNewLocation(localInfo.find(i => i.id_ === currentLocation), sampleInfo)
- let result = {
- name: 'fullLocation',
- value: newLocation
- }
- return result
- }
- },
- /* 关闭*/
- remRedar() {
- this.visible = false // 列表隐藏
- this.listData = [] // 清空列表数据
- this.redar = false // 扫码图标隐藏
- this.$emit('scanOff', false)
- },
- }
- }
|