kmall-haikong/kmall-admin/src/main/webapp/js/sale/salesdataupload.js

$(function () {
    $("#jqGrid").jqGrid({
        url: '../salesdataupload/list',
        datatype: "json",
        colModel: [
			{label: 'fileId', name: 'fileId', index: 'file_id', key: true, hidden: true, align: 'center'},
			{label: '门店名称', name: 'shopName', index: 'shopName', width: 100, align: 'center'},
			{label: '文件名称', name: 'fileName', index: 'file_name', width: 80, align: 'center'},
			{label: '文件类型', name: 'fileType', index: 'file_type', width: 80, align: 'center'},
			{label: '上传地址', name: 'uploadAddress', index: 'upload_address', width: 80 ,align: 'center'},
			{label: '添加人', name: 'username', index: 'username', width: 80, align: 'center'},
			{label: '账单时间', name: 'billTime', index: 'bill_time', width: 80, align: 'center',
				formatter: function (value) {
					return transDate(value, 'yyyy-MM-dd');
				}
			},
			{label: '核对时间', name: 'checkTime', index: 'check_time', width: 80, align: 'center',
				formatter: function (value) {
					return transDate(value, 'yyyy-MM-dd');
				}
			},
			{label: '上传时间', name: 'createrTime', index: 'creater_time', width: 80, align: 'center',
				formatter: function (value) {
					return transDate(value, 'yyyy-MM-dd hh:mm:ss');
				}
			}],
		viewrecords: true,
        height: 550,
        rowNum: 10,
        rowList: [10, 30, 50],
        rownumbers: true,
        rownumWidth: 25,
        autowidth: true,
        multiselect: true,
        pager: "#jqGridPager",
        jsonReader: {
            root: "page.list",
            page: "page.currPage",
            total: "page.totalPage",
            records: "page.totalCount"
        },
        prmNames: {
            page: "page",
            rows: "limit",
            order: "order"
        },
        gridComplete: function () {
            $("#jqGrid").closest(".ui-jqgrid-bdiv").css({"overflow-x": "hidden"});
        }
    });
});

let vm = new Vue({
	el: '#rrapp',
	data: {
        showList: true,
        title: null,
		salesDataUpload: {},
		ruleValidate: {
			name: [
				{required: true, message: '名称不能为空', trigger: 'blur'}
			]
		},
		q: {
		    name: '',
			startTime: '',
			endTime: ''
		},
		billTime: '',
		checkTime: '',
		merchSN: '',
		thirdMerchSN: '',
		shopSN: '',
		merchList: [],
		thirdMerchantBizList: [],
		storeList: []
	},
	methods: {
		query: function () {
			vm.reload();
		},
		add: function () {
			vm.showList = false;
			vm.title = "新增";
			vm.salesDataUpload = {};
		},
		update: function (event) {
            let fileId = getSelectedRow();
			if (fileId == null) {
				return;
			}
			vm.showList = false;
            vm.title = "修改";

            vm.getInfo(fileId)
		},
		saveOrUpdate: function (event) {
            let url = vm.salesDataUpload.fileId == null ? "../salesdataupload/save" : "../salesdataupload/update";
			$.ajax({
				type: "POST",
			    url: url,
			    contentType: "application/json",
			    data: JSON.stringify(vm.salesDataUpload),
                success: function (r) {
                    if (r.code === 0) {
                        alert('操作成功', function (index) {
                            vm.reload();
                        });
                    } else {
                        alert(r.msg);
                    }
                }
			});
		},
		del: function (event) {
            let fileIds = getSelectedRows();
			if (fileIds == null){
				return;
			}

			confirm('确定要删除选中的记录？', function () {
				$.ajax({
					type: "POST",
				    url: "../salesdataupload/delete",
				    contentType: "application/json",
				    data: JSON.stringify(fileIds),
				    success: function (r) {
						if (r.code == 0) {
							alert('操作成功', function (index) {
								$("#jqGrid").trigger("reloadGrid");
							});
						} else {
							alert(r.msg);
						}
					}
				});
			});
		},
		getInfo: function(fileId){
			$.get("../salesdataupload/info/"+fileId, function (r) {
                vm.salesDataUpload = r.salesDataUpload;
            });
		},
        reloadSearch: function() {
            vm.q = {
                name: '',
				startTime: '',
				endTime: ''
            }
            vm.reload();
		},
		reload: function (event) {
			vm.showList = true;

            let page = $("#jqGrid").jqGrid('getGridParam', 'page');
			$("#jqGrid").jqGrid('setGridParam', {
                postData: {
                	'name': vm.q.name,
					'startTime': vm.q.startTime==''?'':new Date(vm.q.startTime).dateFormat('yyyy-MM-dd hh:mm:ss'),
					'endTime': vm.q.endTime==''?'':new Date(vm.q.endTime).dateFormat('yyyy-MM-dd')+' 23:59:59'
				},
                page: page
            }).trigger("reloadGrid");
            vm.handleReset('formValidate');
		},
        handleSubmit: function (name) {
            handleSubmitValidate(this, name, function () {
                vm.saveOrUpdate()
            });
        },
        handleReset: function (name) {
            handleResetForm(this, name);
        },
		download: function (event){

			var grid = $("#jqGrid");
			var rowKey = grid.getGridParam("selrow");
			if (!rowKey) {
				iview.Message.error("请选择一条记录");
				return;
			}

			var selectedIDs = grid.getGridParam("selarrrow");
			if (selectedIDs.length > 1) {
				// iview.Message.error("只能选择一条记录");
				// return;
			}

			let filePaths = new Array();
			let fileNames = new Array();
			let fileIds = new Array();

			for(var i = 0 ; i < selectedIDs.length ; i++){
				let fileData = $("#jqGrid").jqGrid('getRowData', selectedIDs[i])
				filePaths.push(fileData.uploadAddress);
				fileNames.push(fileData.fileName);
				fileIds.push(fileData.fileId);
			}

			console.log(filePaths);
			console.log(fileNames);
			console.log(fileIds);



			// let fileData = getSelectedRowData();
			// if (fileData.length != 1 && fileData.length != undefined){
			// 	return;
			// }
			window.location.href = "../salesdataupload/download?filePath="+filePaths+"&fileName="+fileNames+"&fileId="+fileIds;
			/*let fileIds = getSelectedRows();
			if(null != fileIds && fileIds.length < 3){
				for(let i=0; i<fileIds.length; i++){
					let fileData = $("#jqGrid").jqGrid('getRowData', fileIds[i]);
					window.location.href = "../salesdataupload/download?filePath="+fileData.uploadAddress+"&fileName="+fileData.fileName+"&fileId="+fileData.fileId;
				}
			}*/
		},
		upload: function (){
			$('#salesDataFormDiv').modal('show');
			vm.getMerchList();
		},
		uploadFormSubmit: function () {
			debugger;
			if(!vm.billTime){
				alert("请选择账单时间");
				return ;
			}
			if(!vm.checkTime){
				alert("请选择核对时间");
			}
			let fileName = $('#file').val();
			if(!fileName){
				alert("选择上传文件");
				return ;
			}
			if(fileName.lastIndexOf(".xlsx") == -1 || fileName.lastIndexOf(".xls") == -1){
				fileName = fileName.substring(fileName.lastIndexOf("\\")+1);
				alert("文件 " + fileName + " 格式不正确，请上传 xls 或 xlsx 格式的文件。");
				return ;
			}

			let formData = new FormData();
			formData.append("file", document.getElementById("file").files[0]);
			formData.append("billTime", new Date(vm.billTime).dateFormat('yyyy-MM-dd hh:mm:ss'));
			formData.append("checkTime", new Date(vm.checkTime).dateFormat('yyyy-MM-dd hh:mm:ss'));
			formData.append("merchSN", vm.merchSN);
			formData.append("thirdMerchSN", vm.thirdMerchSN);
			formData.append("shopSN", vm.shopSN);

			$.ajax({
				async: false,
				type: "POST",
				url: "../salesdataupload/upload",
				data: formData,
				mimeType: "multipart/form-data",
				contentType: false,
				processData: false,
				success: function (data) {
					if(data.code==0){
						$('#cancel').click();
						alert('导入成功', function (index) {
							$("#jqGrid").trigger("reloadGrid");
						});
					}else{
						alert(data.msg);
					}
				}
			});
		},
		getMerchList: function() {
			$.get("../merch/queryAll", function (r) {
				vm.merchList = r.list;
			});
		},
		changeMerch: function(opt) {
			var value = opt.value;
			vm.getThirdMerchantBizList(value);
		},
		getThirdMerchantBizList: function(merchSn) {
			$.get("../thirdmerchantbiz/queryAll?merchSn=" + merchSn, function (r) {
				vm.thirdMerchantBizList = r.list;
			});
		},
		changeThirdMerchantBiz: function (opt) {
			var value = opt.value;
			$.get("../store/getStoresByThirdMerch?thirdPartyMerchCode=" + value, function (r) {
				vm.storeList = r.list;
			});
		}
	}
});