搜索
新增
删除
导入编号及名称
更新工序工时(csv文件)
导出
修改
点击上传（csv文件）
确认导入
`,
data(){
// 获取当前屏幕的分辨率
let screenW = window.screen.width;
let screenH = window.screen.height;
console.log("screen width:",screenW);
console.log("screen height:",screenH);
return {
tHeight:screenH*0.8,
tableData: [],
currentPage: 1,
pagesize:50,
recordTotal:0,
p_id_v:'',
p_name_v:'',
form: {
id:'',
p_id: '',
p_name:'',
p1:'',
p1t:'',
p2:'',
p2t:'',
p3:'',
p3t:'',
p4:'',
p4t:'',
p5:'',
p5t:'',
p6:'',
p6t:'',
p7:'',
p7t:'',
p8:'',
p8t:'',
p9:'',
p9t:'',
p10:'',
p10t:'',
p11:'',
p11t:'',
p12:'',
p12t:'',
p13:'',
p13t:'',
p14:'',
p14t:'',
p15:'',
p15t:'',
p16:'',
p16t:'',
p17:'',
p17t:'',
p18:'',
p18t:'',
p19:'',
p19t:'',
p20:'',
p20t:'',
p21:'',
p21t:'',
p22:'',
p22t:'',
p23:'',
p23t:'',
p24:'',
p24t:'',
p25:'',
p25t:'',
p26:'',
p26t:'',
p27:'',
p27t:'',
p28:'',
p28t:'',
p29:'',
p29t:'',
p30:'',
p30t:'',
p31:'',
p31t:'',
p32:'',
p32t:'',
p33:'',
p33t:'',
p34:'',
p34t:'',
p35:'',
p35t:'',
},
dialogVisible:false,
oper_type:0,
rules: {
p_id: [
{ required: true, message: '产品编号不可为空', trigger: 'blur' }
],
p_name: [
{ required: true, message: '产品名称不可为空', trigger: 'blur' }
],
},
multipleSelection: [],
importdialogVisible:false,
fileListUpload:[],
importTableData:[],
fileListUpload1:[],
disabled:true,
if_show_process:false,
percent_len:0,
interval:'',
if_show_process1:false,
}
},
mounted() {
var _this = this;
var objs;
axios.post('/pkpi/get_p', {
opuser:localStorage.getItem("online_user"),
opuser_uuid:localStorage.getItem("uuid"),
p_id: _this.$data.p_id_v,
p_name: _this.$data.p_name_v,
index: _this.$data.currentPage,
count: _this.$data.pagesize
})
.then(function (response) {
console.log(response.data);
objs = response.data.data;
rcnt = response.data.total;
_this.$data.tableData = objs;
_this.$data.recordTotal = rcnt;
})
.catch(function (error) {
console.log(error);
});
},
methods: {
input_change(value) {
console.log(value);
this.get_p();
},
exportSap(){
document.getElementById("bt_export").blur();
var _this = this;
var objs;
axios.post('/pkpi/export_sap', {
opuser:localStorage.getItem("online_user"),
opuser_uuid:localStorage.getItem("uuid"),
p_id: _this.$data.p_id_v,
p_name: _this.$data.p_name_v,
})
.then(function (response) {
console.log(response.data);
var fileid = response.data.fileId;
var downUrl = 'file/'+fileid;
downloadUrl("工时导出.csv",downUrl);
})
.catch(function (error) {
console.log(error);
});
},
handleChange1(file, fileList) {
document.getElementById("bt_upload1").blur();
this.fileTemp = file.raw
console.log("filetype:",this.fileTemp);
if (this.fileTemp) {
console.log("begin ...")
console.log(this.fileTemp.type);
if ((this.fileTemp.type == 'text/csv') || (this.fileTemp.type == '.csv') || (this.fileTemp.type == 'application/vnd.ms-excel')) {
let _this = this//如果需要点击事件结束之后对DOM进行操作使用)_this.xx=xx进行操作
Papa.parse(_this.fileTemp, {
encoding:'gb2312',
complete (results) {
console.log(results)//这个是csv文件的数据
let objs = []
//遍历csv文件中的数据，存放到data中 方法不唯一，可自己更改
for (let i = 0; i < results.data.length; ++i) {
if(i==0){
continue;
}
let obj = {}
obj.process=[];
obj.p_id = results.data[i][0]
if(obj.p_id==""|| obj.p_id==undefined){
continue;
}
obj.p_name = results.data[i][1]
var cnt = 0;
for(let j=2; j