| | |
|---|
| | | userInfo:getUserInfo(), |
|---|
| | | serverUrl: uni.getStorageSync('serverUrl')||'http://47.96.97.237/API', |
|---|
| | | showmore:false, |
|---|
| | | |
|---|
| | | arrayHEmpName: [], //接收人 |
|---|
| | | HEmpNameList: [], |
|---|
| | | hform:{ |
|---|
| | | HMonth:'', |
|---|
| | | HEmp:'', |
|---|
| | |
|---|
| | | }, |
|---|
| | | onLoad() { |
|---|
| | | this.getList() |
|---|
| | | this.getHEmpList() |
|---|
| | | // console.log(this.userInfo,uni.getStorageSync('HUserName')) |
|---|
| | | }, |
|---|
| | | onReachBottom: function() { |
|---|
| | |
|---|
| | | this.showList = [] |
|---|
| | | |
|---|
| | | console.log(this.hform) |
|---|
| | | |
|---|
| | | if (this.hform.HStatus) { |
|---|
| | | if(this.hform.HStatus == '全部'){ |
|---|
| | | this.sWhere += ""; |
|---|
| | | }else if(this.hform.HStatus == '未审核'){ |
|---|
| | | this.sWhere += " and 审核人=''"; |
|---|
| | | }else if(this.hform.HStatus == '已审核'){ |
|---|
| | | this.sWhere += " and 审核人<>''"; |
|---|
| | | }else if(this.hform.HStatus == '已关闭'){ |
|---|
| | | this.sWhere += " and 关闭人<>''"; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if (this.hform.HBeginDate) { |
|---|
| | | this.sWhere += " and CONVERT(varchar(100),出站时间, 23) >= '" + this.hform.HBeginDate + "'"; |
|---|
| | | } |
|---|
| | | if (this.hform.HEndDate) { |
|---|
| | | this.sWhere += " and CONVERT(varchar(100),出站时间, 23) >= '" + this.hform.HEndDate + "'"; |
|---|
| | | } |
|---|
| | | if (this.hform.HBillNo) { |
|---|
| | | this.sWhere += " and 单据号 like '%" + this.hform.HBillNo + "%'"; |
|---|
| | | } |
|---|
| | | if (this.hform.HNumber) { |
|---|
| | | this.sWhere += " and 产品代码 like '%" + this.hform.HNumber + "%'"; |
|---|
| | | } |
|---|
| | | if (this.hform.HName) { |
|---|
| | | this.sWhere += " and 当前工序 like '%" + this.hform.HName + "%'"; |
|---|
| | | } |
|---|
| | | if (this.hform.HWorkBillNo) { |
|---|
| | | this.sWhere += " and 任务单 like '%" + this.hform.HWorkBillNo + "%'"; |
|---|
| | | } |
|---|
| | | if (this.hform.HProcExchBillNo) { |
|---|
| | | this.sWhere += " and 工序流转卡号 like '%" + this.hform.HProcExchBillNo + "%'"; |
|---|
| | | } |
|---|
| | | if (this.hform.checkHWasterQty) { |
|---|
| | | this.sWhere += " and 报废数量>0 "; |
|---|
| | | } |
|---|
| | | if (this.hform.ColName && this.hform.Comparator) { |
|---|
| | | var com = ""; |
|---|
| | | if(this.hform.Comparator == '包含'){ |
|---|
| | | com = "like'%" + this.hform.ColContent + "%'"; |
|---|
| | | }else if(this.hform.Comparator == '左包含'){ |
|---|
| | | com = "like'%" + this.hform.ColContent + "'"; |
|---|
| | | }else if(this.hform.Comparator == '右包含'){ |
|---|
| | | com = "like'" + this.hform.ColContent + "%'"; |
|---|
| | | }else if(this.hform.Comparator == '不包含'){ |
|---|
| | | com = "not like'%" + this.hform.ColContent + "%'"; |
|---|
| | | }else{ |
|---|
| | | com = "" + this.hform.Comparator + "'" + this.hform.ColContent + "'"; |
|---|
| | | } |
|---|
| | | |
|---|
| | | this.sWhere += " and " + this.hform.ColName + " " + com; |
|---|
| | | } |
|---|
| | | |
|---|
| | | this.getList() |
|---|
| | | }, |
|---|
