| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592 |
- import repostCurd from '@/business/platform/form/utils/custom/joinCURD.js'
- 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 this_ = 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 = this.listData[index].jie_yang_shu_lian + 1
- flag = false
- }
- }
- // 扫码扫到新数据,查询 回填展示
- if(flag){
- repostCurd('select','{"tableName": "t_lhypb","paramWhere":{"yang_pin_bian_hao":"' + id + '","jie_yang_zhuang_t":"待接收"}}').then(res => {
- if (res.variables.data && res.variables.data.length > 0) {
- for (let i in res.variables.data) {
- res.variables.data[i].jie_yang_shu_lian = 1
- res.variables.data[i].jie_yang_zhuang_t = '未确认'
- res.variables.data[i].biao_zhi_uuid_ = this.uuid()
- this.listData.push(res.variables.data[i])
- //this.OriginalPosition.push(res.variables.data[i].shi_fou_liu_yang_ == "是" ? res.variables.data[i].liu_yang_wei_zhi_ : res.variables.data[i].shou_yang_wei_zhi)
- }
- }
- })
- }
- },
- /* 列表失去焦点*/
- handleChange(){
- this.$refs.redarInput.focus(); //聚焦input
- },
- /* 关闭弹出列表框*/
- closeDialog() {
- this.remRedar()
- //回传关闭事件。隐藏当前组件。
- },
- handleClose(){
- this.handleChange()
- this.$confirm('确认关闭扫码列表页面?').then(_ => {
- this.closeDialog();
- }).catch(_ => {
- });
- },
- submitData(type) {
- // this指针
- let this_ = this;
- // 回传关闭事件。隐藏当前组件。
- let changeWeiZhi; // 此处俩字段作用在下面 选择货位时出现重复位置 而重新更新样品登记表 收样位置|留样位置
- let changesyWeiZhi;
- let judge = true;
- this.$confirm('请再次确认 [样品接收信息]').then(_ => {
- // 获取样品列表
- let ypInfoList = this_.listData
- let dWhere = []
- let ypbh = []
- let cfwzIdList = [] // 放置 存放位置的ID
- // let uuidList = [] // 列表的UUID
- let ypbhList = [] // 样品编号列表
- // 罗湖样品编号列表
- let lhypbhList = []
- let lhypmcList = []
- // 罗湖委托单列表
- let lhwtsqbList = []
- // 罗湖样品表列表
- let lhypbList = []
- // 罗湖样品表外键
- let lhypbWJ = []
- // 罗湖委托表主键
- let lhwtbID = []
- // 罗湖委托表展示表ID
- let lhwtzsbID = []
- let lhwtbOnlyId = []
- // 罗湖样品id列表
- let lhypIdList = []
- // 罗湖样品id格式列表
- let lhypIdNewList = []
- let uuidList = [] // 列表的UUID
- 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_ == null || ypInfoList[yp].shi_fou_liu_yang_ == '') {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 是否留样不能为空!')
- return;
- }
- if (ypInfoList[yp].bao_gao_bian_zhi_ == undefined || ypInfoList[yp].bao_gao_bian_zhi_ == '') {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 报告编制员不能为空!')
- return;
- }
- if (ypInfoList[yp].bao_gao_shen_he_y == undefined || ypInfoList[yp].bao_gao_shen_he_y == '') {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 报告审核员不能为空!')
- return;
- }
- if (ypInfoList[yp].shi_fou_liu_yang_ == "是") {
- if (ypInfoList[yp].liu_yang_wei_zhi_ == null || ypInfoList[yp].liu_yang_wei_zhi_ == '') {
- this_.$message.error("你要留样的话,存放位置不能为空哦!")
- return;
- }
- if (ypInfoList[yp].shou_yang_wei_zhi != undefined && ypInfoList[yp].shou_yang_wei_zhi != '') {
- this_.$message.error("你要留样的话,就不要选收样存放位置!")
- return;
- }
- if (ypInfoList[yp].liu_yang_ri_qi_ == null || ypInfoList[yp].liu_yang_ri_qi_ == '') {
- this_.$message.error("留样时必须填写留样日期!")
- return;
- }
- if (ypInfoList[yp].liu_yang_shu_lian == null || ypInfoList[yp].liu_yang_shu_lian == '') {
- this_.$message.error("留样时必须填写留样数量!")
- return;
- }
- if (ypInfoList[yp].liu_yang_shu_lian > ypInfoList[yp].yang_pin_zong_shu) {
- this_.$message.error('操作失败,[' + ypInfoList[yp].yang_pin_ming_che + '] 留样数量不得大于收样数量。')
- return;
- }
- if (ypInfoList[yp].liu_yang_qi_xian == null || ypInfoList[yp].liu_yang_qi_xian == '') {
- this_.$message.error("留样时必须填写留样期限!")
- return;
- }
- if (ypInfoList[yp].xiao_hui_ri_qi_ == null || ypInfoList[yp].xiao_hui_ri_qi_ == '') {
- this_.$message.error("留样时必须填写销毁日期!")
- return;
- }
- cfwz = ypInfoList[yp].liu_yang_wei_zhi_
- } else {
- if (ypInfoList[yp].shou_yang_wei_zhi == null || ypInfoList[yp].shou_yang_wei_zhi == '') {
- this_.$message.error("你正常收样的话,样品存放位置不能为空哦!")
- return;
- }
- if (ypInfoList[yp].liu_yang_wei_zhi_ != undefined && ypInfoList[yp].liu_yang_wei_zhi_ != '') {
- this_.$message.error("你正常收样的话,就不要选择留样存放位置!")
- return;
- }
- cfwz = ypInfoList[yp].shou_yang_wei_zhi //取位置信息
- }
- // ypIdList.push('{"id_":"' + ypInfoList[yp].id_ + '"}')
- // ypWeiZhi.push(ypInfoList[yp].shou_yang_wei_zhi) // 收样存放位置
- // ypLiuYangWeiZhi.push(ypInfoList[yp].liu_yang_wei_zhi_) // 留样存放位置
- // saoMaNumList.push(ypInfoList[yp].jie_yang_shu_lian) // 扫码数量
- // jieYangQueRenZTList.push(ypInfoList[yp].jie_yang_zhuang_t) // 接收确认状态
- ypbhList.push('{"yang_pin_bian_hao":"' + ypInfoList[yp].yang_pin_bian_hao + '"}') // 样品编号列表
- // 罗湖
- // lhypbhList.push('{"yang_pin_bian_hao":"' + ypInfoList[yp].yang_pin_bian_hao + '"}')
- // lhypbWJ.push('{"id_":"' + ypInfoList[yp].parent_id_ + '"}')
- dWhere.push('{"id_":"' + cfwz + '"}')
- cfwzIdList.push(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_ + '"}')
- uuidList.push(ypInfoList[yp].biao_zhi_uuid_)
- ypbh.push(ypInfoList[yp].yang_pin_bian_hao)
- lhypmcList.push(ypInfoList[yp].yang_pin_ming_che)
- }
- /*
- 封装好样品登记表对象,add 样品登记表
- */
- 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 wtdAndYpb = []
- // a.bao_gao_bian_zhi_,a.bao_gao_fu_he_yua,
- let allSQL = `select a.id_ as wtID,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}')`
- repostCurd('sql', allSQL).then(res1 => {
- /* 封装样品登记表对象 */
- let ypdjb = []
- let res = res1.variables.data
- wtdAndYpb = res
- for(let i = 0; i<res.length; i++){
- lhwtbID.push('{"id_":"' + res[i].wtID + '"}')
- lhwtbOnlyId.push(res[i].wtID)
- lhwtzsbID.push('{"shen_qing_id_":"' + res[i].zhan_shi_biao_id_ + '"}')
- let count = 0;
- if(res[i].yang_pin_lei_xing != '' && res[i].yang_pin_lei_xing != undefined){
- count = 1;
- if(res[i].yang_pin_lei_er_ != '' && res[i].yang_pin_lei_er_ != undefined){
- count = 2;
- if(res[i].yang_pin_lei_san_ != '' && res[i].yang_pin_lei_san_ != undefined){
- count = 3;
- if(res[i].yang_pin_lei_si_ != '' && res[i].yang_pin_lei_si_ != undefined){
- count = 4;
- }
- }
- }
- }
- for(let x = 0; x<count;x++){
- let obj = {}
- obj["wei_tuo_dan_hao_"] = res[i].wei_tuo_bian_hao_
- obj["wei_tuo_dan_wei_"] = res[i].wtdh
- obj["lian_xi_ren_"] = res[i].wei_tuo_fang_lian
- obj["lian_xi_dian_hua_"] = res[i].wei_tuo_lian
- obj["yang_ben_ming_che"] = res[i].yang_pin_ming_che
- obj["yang_ben_bian_hao"] = res[i].yang_pin_bian_hao
- obj["pi_hao_bian_hao_"] = res[i].song_jian_pi_hao_
- obj["xing_ming_"] = res[i].xing_ming_
- obj["xing_bie_"] = res[i].xing_bie_
- obj["nian_ling_"] = res[i].nian_ling_
- obj["yang_ben_zhuang_t"] = res[i].yang_pin_zhuang_t
- obj["shou_yang_ri_qi_"] = this_.dateFormat()
- obj["bei_zhu_"] = res[i].bei_zhu_
- obj["yang_ben_lei_xing"] = x==0? res[i].yang_pin_lei_xing : x==1? res[i].yang_pin_lei_er_ : x==2? res[i].yang_pin_lei_san_ : x==3? res[i].yang_pin_lei_si_ :''
- obj["yun_shu_tiao_jian"] = x==0? res[i].yang_ben_yun_shu_ : x==1? res[i].yang_pin_yun_shu_ : x==2? res[i].yang_pin_yun_san : x==3? res[i].yang_pin_yun_si_ :''
- obj["yang_pin_shu_lian"] = x==0? res[i].shu_liang_ : x==1? res[i].shu_liang_er_ : x==2? res[i].shu_liang_san_ : x==3? res[i].shu_liang_si_ :''
- obj["yang_ben_gui_ge_s"] = x==0? res[i].yang_pin_gui_ge_ : x==1? res[i].yang_pin_gui_ge_e : x==2? res[i].yang_pin_gui_ge_s : x==3? res[i].yang_pin_gui_si_ :''
- obj["yan_shou_jie_guo_"] = ypInfoList[i].yan_shou_jie_guo_
- obj["cun_fang_wei_zhi_"] = ypInfoList[i].shou_yang_wei_zhi
- obj["liu_zhuan_zhuang_"] = '待检'
- obj["shi_fou_liu_yang_"] = ypInfoList[i].shi_fou_liu_yang_
- // obj["shou_yang_ren_"] = ypInfoList[i].
- // obj["jiao_yang_ri_qi_"] = ypInfoList[i].
- // obj["jiao_yang_jyr"] = ypInfoList[i].
- // obj["jiao_yang_shu_lia"] = ypInfoList[i].
- obj["liu_yang_ri_qi_"] = ypInfoList[i].liu_yang_ri_qi_
- obj["liu_yang_cun_fang"] = ypInfoList[i].liu_yang_cun_fang
- obj["liu_yang_shu_lian"] = ypInfoList[i].liu_yang_shu_lian
- obj["liu_yang_qi_xian"] = ypInfoList[i].liu_yang_qi_xian
- obj["xiao_hui_ri_qi_"] = ypInfoList[i].xiao_hui_ri_qi_
- obj["fan_yang_ri_qi_"] = ypInfoList[i].fan_yang_ri_qi_
- obj["fan_yang_jyr"] = ypInfoList[i].fan_yang_jyr
- obj["biao_zhi_uuid_"] = ypInfoList[i].biao_zhi_uuid_
- obj["song_yang_yao_qiu"] = ypInfoList[i].song_yang_yao_qiu
- changeWeiZhi = ypInfoList[i].shou_yang_wei_zhi ==''?'':ypInfoList[i].shou_yang_wei_zhi
- changesyWeiZhi = ypInfoList[i].liu_yang_cun_fang ==''?'':ypInfoList[i].liu_yang_cun_fang
- ypdjb.push(obj)
- }
- }
- let fbbIdStr = ''
- for(let i =0;i<lhwtbOnlyId.length; i++){
- fbbIdStr += lhwtbOnlyId[i] + ','
- }
- fbbIdStr = fbbIdStr.substring(0,fbbIdStr.length-1)
- // fbbIdStr = fbbIdStr.replace(/,/g,"','")
- // console.log('fbbIdStr :',fbbIdStr)
- // console.log('进入样品登记表...',ypdjb)
- repostCurd('add', '{"tableName":"t_lhypdjb","paramWhere":' + JSON.stringify(ypdjb) + '}')
- repostCurd('updates', '{"tableName":"t_lhypb","paramWhere":[' + lhypIdNewList + '],"paramCond":{"jie_yang_zhuang_t":"已接收"}}')
- /*
- 更新委托单 如果本来没值,就更新 报告编制人和 报告审核员 否则更新
- 委托单数组 和 样品数组 数量相同,遍历两者 判断委托单是否有编制人,审核员?
- 如果没有,则记录下委托单ID,以及同索引下的样品表的编制人和审核员
- */
- // let finalWtdIdList = []
- for(var index = 0; index < ypInfoList.length; index++){
- if(res[index].bao_gao_bian_zhi_ == '' || res[index].bao_gao_fu_he_yua == ''){
- repostCurd('update','{"tableName":"t_lhwtsqb","paramWhere":' + '{"id_":"' + res[index].wtID + '"}' + ',"paramCond":' + '{"bao_gao_bian_zhi_":"'+ypInfoList[index].bao_gao_bian_zhi_+'","bao_gao_fu_he_yua":"' + ypInfoList[index].bao_gao_shen_he_y + '"}}')
- }
- }
- /*
- let wtdSQL = "select id_,bao_gao_bian_zhi_,bao_gao_fu_he_yua from t_lhwtsqb where id_ in('" + value + "')"
- repostCurd('sql', wtdSQL).then(response => {
- let result = response.variables.data
- console.log(result)
- for(var i in result){
- if(result[i].bao_gao_bian_zhi_ == '' || result[i].bao_gao_bian_zhi_ == undefined){
- finalWtdIdList.push(result[i])
- }
- }
- console.log('finalWtdIdList',finalWtdIdList)
- })
- 3、任务分配 【2022/11/23 取消 直接 批量开检测子流程】
- 3-1、根据 wtdAndYpb 的 wtID 更改委托表的 委托状态 wei_tuo_zhuang_ta 变成 已完成
- 3-2、根据每个样品对应的检测项目,开启一个或多个任务 / 遍历样品表开任务分配流程,一个样品可能对应多个检测
- 3-3、委托表找zhan_shi_biao_id_ 修改 t_lhwtzsb "zhuang_tai_"为"任务分配进行中"
- */
- // console.log('委托单及样品信息',wtdAndYpb)
- // console.log('委托单id列表 ',lhwtbID)
- // console.log('展示表id列表 ',lhwtzsbID)
- repostCurd('updates', '{"tableName":"t_lhwtsqb","paramWhere":[' + lhwtbID + '],"paramCond":{"wei_tuo_zhuang_ta":"已完成"}}')
- let rws = []
- if(wtdAndYpb.length>0){
- for(var i in wtdAndYpb){
- // let strs = wtdAndYpb[i].jian_ce_xiang_mu_.split(',')
- // for(var l in strs){
- let rw = {}
- // rw["ren_wu_ming_cheng"] = strs[l] //检测项目
- rw["yang_pin_ming_che"] = wtdAndYpb[i].yang_pin_ming_che//样品名称
- rw["yang_pin_bian_hao"] = wtdAndYpb[i].yang_pin_bian_hao//样品编号
- rw["wei_tuo_lei_xing_"] = wtdAndYpb[i].wei_tuo_lei_xing_ //委托类型
- let yplxz = ''
- if(wtdAndYpb[i].yang_pin_lei_xing != null && wtdAndYpb[i].yang_pin_lei_xing!=''){ //样品类型1
- yplxz = wtdAndYpb[i].yang_pin_lei_xing //样品类型
- }
- if(wtdAndYpb[i].yang_pin_lei_er_ != null && wtdAndYpb[i].yang_pin_lei_er_!=''){ //样品类型2
- if(yplxz==null || yplxz == ''){
- yplxz = wtdAndYpb[i].yang_pin_lei_er_ //样品类型
- }else{
- yplxz =yplxz+','+ wtdAndYpb[i].yang_pin_lei_er_ //样品类型
- }
- }
- if(wtdAndYpb[i].yang_pin_lei_san_ != null && wtdAndYpb[i].yang_pin_lei_san_!=''){ //样品类型3
- if(yplxz==null || yplxz == ''){
- yplxz = wtdAndYpb[i].yang_pin_lei_san_ //样品类型
- }else{
- yplxz =yplxz+','+ wtdAndYpb[i].yang_pin_lei_san_ //样品类型
- }
- }
- if(wtdAndYpb[i].yang_pin_lei_si_ != null && wtdAndYpb[i].yang_pin_lei_si_!=''){ //样品类型4
- if(yplxz==null || yplxz == ''){
- yplxz = wtdAndYpb[i].yang_pin_lei_si_ //样品类型
- }else{
- yplxz = yplxz+','+ wtdAndYpb[i].yang_pin_lei_si_ //样品类型
- }
- }
- rw["yang_pin_lei_xing"] = yplxz //样品类型
- rw["wei_tuo_id_"] = wtdAndYpb[i].wtID //委托id
- rw["he_tong_id_"] = wtdAndYpb[i].he_tong_id_ //合同id
- rw["zhuang_tai_"] = '待任务分配'//状态
- rw["wan_cheng_shi_jia"] = wtdAndYpb[i].song_jian_shi_jia //送检日期
- rw["bao_gao_bian_zhi_"] = ypInfoList[i].bao_gao_bian_zhi_ //报告编制人
- rw["bao_gao_shen_he_y"] = ypInfoList[i].bao_gao_shen_he_y //报告审核人
- rw["bao_gao_lei_xing_"] = wtdAndYpb[i].bao_gao_lei_xing_ //报告类型
- rw["xin_xiang_mu_ming"] = wtdAndYpb[i].xiang_mu_ming_che //项目名称
- rw["zhan_shi_biao_id_"] = wtdAndYpb[i].zhan_shi_biao_id_ //展示表id
- rws.push(rw)
- // }
- }
- // console.log("任务分配",rws)
- repostCurd('add', '{"tableName":"t_lhrwfpb","paramWhere":'+JSON.stringify(rws)+',"defKey":"Process_04o0csc","formKey":"lhrwfp"}')
- }
- // 更新委托单 检测开始时间 问吴懿是否需要
- //repostCurd('updates', '{"tableName":"t_lhwtsqb","paramWhere":[' + lhwtbID + '],"paramCond":{"jian_ce_kai_shi_s":"' + this_.dateFormat() + '"}}')
- //更新展示表
- if(lhwtzsbID.length > 0){
- repostCurd('updates', '{"tableName":"t_lhwtzsb","paramWhere":['+lhwtzsbID+'],"paramCond":{"zhuang_tai_":"任务分配进行中"}}')
- }
-
- /*
- 3、【任务分配2022/11/23 取消 直接 批量开检测子流程】
- 3-1、根据 wtdAndYpb 的 wtID 更改委托表的 委托状态 wei_tuo_zhuang_ta 变成 已完成
- 3-2、根据每个样品对应的检测项目,开启一个或多个任务 / 遍历样品表开检测子流程,一个样品可能对应多个检测
- 3-3、委托表找zhan_shi_biao_id_ 修改 t_lhwtzsb "zhuang_tai_"为"待环境监控"
-
- repostCurd('updates', '{"tableName":"t_lhwtsqb","paramWhere":[' + lhwtbID + '],"paramCond":{"wei_tuo_zhuang_ta":"已完成"}}')
- */
- // console.log('dWhere : ',dWhere)
- /* 2、更新货架位置信息(位置状态、样品编号、入库时间)如果是重复位置,则新增一条位置记录,并增加对应UUID */
- for (let num in dWhere) {
- let sql = "select * from t_ypcfwz where id_ = '" + cfwzIdList[num] + "'"
- repostCurd('sql', sql).then(response => {
- let resArr = response.variables.data
- if (resArr.length == 1) {
- if (resArr[0].wei_zhi_zhuang_ta == "空余") {
- repostCurd('update', '{"tableName":"t_ypcfwz","paramWhere":' + dWhere[num] + ',"paramCond":' + '{"wei_zhi_zhuang_ta":"占用","yang_pin_bian_hao":"' + ypbh[num] +'","yang_pin_ming_che":"' + lhypmcList[num] +'","ru_ku_shi_jian_":"' + this_.dateFormat() + '"}}').then(res => {
- // console.log("原本位置为空余 ,新位置更新成功")
- })
- } else if (resArr[0].wei_zhi_zhuang_ta == "占用") {
- // 新增一条新的位置记录,使用旧的位置记录 修改它的样品编号,入库时间,标识UUID
- let cfNewList = []
- let cfNew = {}
- cfNew["fang_jian_lei_xin"] = resArr[0].fang_jian_lei_xin
- cfNew["wei_zhi_"] = resArr[0].wei_zhi_
- cfNew["qu_yu_"] = resArr[0].qu_yu_
- cfNew["huo_jia_lei_xing_"] = resArr[0].huo_jia_lei_xing_
- cfNew["huo_jia_hao_"] = resArr[0].huo_jia_hao_
- cfNew["ceng_hao_"] = resArr[0].ceng_hao_
- cfNew["shui_ping_fen_qu_"] = resArr[0].shui_ping_fen_qu_
- cfNew["wei_zhi_bian_hao_"] = resArr[0].wei_zhi_bian_hao_
- cfNew["wei_zhi_zhuang_ta"] = resArr[0].wei_zhi_zhuang_ta
- cfNew["cun_chu_tiao_jian"] = resArr[0].cun_chu_tiao_jian
- cfNew["yang_pin_bian_hao"] = ypbh[num]
- // cfNew["yang_pin_bian_hao"] = lhypIdList[num]
- cfNew["yang_pin_ming_che"] = lhypmcList[num]
- cfNew["ru_ku_shi_jian_"] = this_.dateFormat()
- cfNew["biao_zhi_uuid_"] = uuidList[num]
- cfNewList.push(cfNew)
- let uuid = cfNew["biao_zhi_uuid_"];
- // console.log('原本位置为占用 ,新位置插入成功')
- repostCurd('add', '{"tableName":"t_ypcfwz","paramWhere":' + JSON.stringify(cfNewList) + '}').then(res => {
- let selectsql = "select id_ from t_ypcfwz where biao_zhi_uuid_='" + uuid + "'";
- // console.log(selectsql)
- repostCurd('sql', selectsql).then(res => {
- // console.log(res)
- let dataid = res.variables.data[0].id_;
- let abc = '{"biao_zhi_uuid_":"' + uuid + '"}'
- // console.log('zzj abc ',abc)
- // console.log('zzj dataid ',dataid)
- if (changeWeiZhi && !changesyWeiZhi) {
- repostCurd('update', '{"tableName":"t_lhypdjb","paramWhere":' + abc + ',"paramCond":' + '{"cun_fang_wei_zhi_":"' + dataid + '"}}').then(res => {
- // console.log('回填样品收样位置')
- })
- } else {
- repostCurd('update', '{"tableName":"t_lhypdjb","paramWhere":' + abc + ',"paramCond":' + '{"liu_yang_cun_fang":"' + dataid + '"}}').then(res => {
- // console.log('回填样品留样位置')
- })
- }
- })
- })
- }
- }
- })
- }
- /*
- let ffbSql = "select * from t_lhfbb where FIND_IN_SET( parent_id_,'"+ fbbIdStr +"')"
- repostCurd('sql',ffbSql).then(response => {
- let ffbList = response.variables.data
- if(wtdAndYpb.length>0){
- let jcxmArr = []
- wtdAndYpb.forEach(item=>{
- item.jian_ce_xiang_mu_.split(',').reverse().forEach(temp=>{
- jcxmArr.push(temp)
- })
- })
- let allProject = []
- let finalJCTask = []
- let processDefKeyParam = []
- let processFormKeyParam = []
- let sql111 = `select id_, defkey_, formkey_ from t_mjjcnlfw where defkey_ != '' and find_in_set(id_, '${jcxmArr.join(',')}')`
- repostCurd('sql', sql111).then(res => {
- allProject = res.variables.data
- wtdAndYpb.forEach(item => {
- let yblxArr = []
- let yblxStr = ''
- yblxArr.push(item.yang_pin_lei_xing, item.yang_pin_lei_er_, item.yang_pin_lei_san_, item.yang_pin_lei_si_)
- yblxStr = yblxArr.filter(s => s).join(',')
- let t = item.jian_ce_xiang_mu_.split(',')
- let ypList = ypInfoList.find(k => k.id_ === item.id_)
- t.forEach(i => {
- let fbbItem = ffbList.find(j => j.jian_ce_xiang_mu_ === i)
- let jcxmItem = allProject.find(k => k.id_ === i)
- let obj = {
- jian_ce_yuan_: fbbItem.jian_ce_yuan_,
- fu_he_yuan_ : fbbItem.fu_he_yuan_,
- yang_pin_ming_che: item.yang_pin_ming_che,
- yang_pin_bian_hao: item.yang_pin_bian_hao,
- jian_ce_xiang_mu_:jcxmItem.id_,
- wei_tuo_id_:item.wtID,
- he_tong_id_:item.he_tong_id_,
- bao_gao_bian_zhi_:ypList.bao_gao_bian_zhi_,
- bao_gao_fu_he_yua:ypList.bao_gao_shen_he_y,
- wei_tuo_lei_xing_:item.wei_tuo_lei_xing_,
- yang_pin_lei_xing: yblxStr,
- xin_xiang_mu_ming:item.xiang_mu_ming_che,
- wan_cheng_shi_jia:item.song_jian_shi_jia,
- zhuang_tai_:'待环境监控',
- zhan_shi_biao_id_:item.zhan_shi_biao_id_
- }
- finalJCTask.push(obj)
- processDefKeyParam.push(jcxmItem.defkey_)
- processFormKeyParam.push(jcxmItem.formkey_)
- })
- })
- finalJCTask.forEach((item,index )=>{
- let obj = {
- tableName:"t_lhjczb",
- paramWhere:[item],
- defKey:processDefKeyParam[index],
- formKey:processFormKeyParam[index]
- }
- repostCurd('add', JSON.stringify(obj))
- })
- })
- }
- })
- //更新展示表
- if(lhwtzsbID.length > 0){
- repostCurd('updates', '{"tableName":"t_lhwtzsb","paramWhere":['+lhwtzsbID+'],"paramCond":{"zhuang_tai_":"检测进行中"}}')
- }
- */
- })
- this.$emit('callback', true)
- this.visable = false
- this.$message({
- message: '样品接收确认操作成功!',
- type: 'success'
- })
- this.closeDialog();
- }).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;
- });
- },
- Update (name,where,cond) {
- let cont = {}
- cont['tableName'] = name
- cont['paramWhere'] = where
- cont['paramCond'] = cond
- return repostCurd('update',JSON.stringify(cont))
- },
- /* zzj add */
- dateFormat() { // 获取当前时间
- var date=new Date();
- var year=date.getFullYear();
- var month= date.getMonth()+1<10 ? "0"+(date.getMonth()+1) : date.getMonth()+1;
- var day=date.getDate()<10 ? "0"+date.getDate() : date.getDate();
- return year+"-"+month+"-"+day;
- },
- /* 关闭*/
- remRedar() {
- this.visible = false // 列表隐藏
- this.listData = [] // 清空列表数据
- this.redar = false // 扫码图标隐藏
- this.$emit('scanOff',false)
- },
- }
- }
|