<!doctype html>
|
<html>
|
<head>
|
<meta charset="utf-8"><meta http-equiv="Expires" content="0"><meta http-equiv="Pragma" content="no-cache"><meta http-equiv="Cache-control" content="no-cache"><meta http-equiv="Cache" content="no-cache">
|
<title>销售查看所有订单</title>
|
<script src="../../../js/vue/vue.js"></script>
|
<script src="../../../js/vue/element-ui/lib/index.js"></script>
|
<script src="../../../js/vue/axios/dist/axios.min.js"></script>
|
<script src="../../../js/myelement.js?v=20220615"></script>
|
<script src="../../../js/vue/page.js?v=20220615"></script>
|
|
<link href="../../../js/vue/element-ui/lib/theme-chalk/index.css" rel="stylesheet">
|
<link href="../../../css/myelement.css?v=20220425" rel="stylesheet">
|
<link href="../../../css/iconfont.css" rel="stylesheet">
|
<link href="../../../css/page.css?v=20220425" rel="stylesheet">
|
<link href="//at.alicdn.com/t/font_2374495_13ltsxm2eor.css" rel="stylesheet">
|
</head>
|
<style>
|
</style>
|
<body>
|
<div id="vbody">
|
<div id="page_root">
|
<div class="topbar">
|
<span>{{title}}</span>
|
<div style="float: right; margin-right: 24px;">
|
<el-button @click="download()">导出</el-button>
|
</div>
|
<div class="notbutton" style="float: right; margin-right: 24px;font-size: 14px;">
|
<span>总销售金额为: <el-button plain :loading="issumloading">{{issumloading ? '' : total_money}}</el-button></span>
|
<span style="margin-left: 50px;">总数量为:<el-button plain :loading="issumloading">{{issumloading ? '' : total_num}}</el-button></span>
|
</div>
|
|
</div>
|
<!-- 查询条件 -->
|
<div class="topbar-line">
|
<div class="query-icon">
|
<i class="iconfont icon-query"></i>
|
</div>
|
<div class="query-bar">
|
<h-form-filter ref="form1"
|
:form-attr="filterAttr"
|
:table-fields="filterFields"
|
:form-data="filterObj"
|
:isbuttonquery="true"
|
v-on:on-formchange="onQuery"
|
v-on:show-popup="showFilterPopup"
|
v-on:on-query="onQuery"
|
v-on:on-init-query="onInitFilter"
|
v-on:on-edit-query="onEditFilter"
|
>
|
</h-form-filter>
|
</div>
|
</div>
|
|
<div class="versionNo">
|
<h-table
|
v-if="isRefresh"
|
ref="table1"
|
:table-fields="tableFields"
|
:table-data="tableData"
|
:tableloading="tableloading"
|
:is-edit-table-data="isEditTableData"
|
:pagesize="pagesize"
|
:pagenum="pagenum"
|
:total="total"
|
:table-height="tableHeight"
|
:is-highlight-row="true"
|
v-on:get-data="getData"
|
v-on:edit-data="editData"
|
v-on:del-data="delData"
|
v-on:row-click="rowClick"
|
v-on:cell-click="cellClick"
|
|
>
|
</h-table>
|
</div>
|
</div>
|
|
<div id="page_loading" style="position: absolute; top:0px; width: 100vw; height: 100vh;z-index:9999">
|
<div class="spinner">
|
<div class="cube1"></div>
|
<div class="cube2"></div>
|
</div>
|
</div>
|
|
|
</div>
|
|
<script type="text/javascript">
|
|
var initlized = false;
|
|
new ListVue({
|
el: "#vbody",
|
|
data: {
|
userId: "",
|
pageAttr: {
|
heightType: "page"
|
},
|
dataname: "getSalesOrderDetail",
|
tabaleFieldsName: "orderDetailAll_",
|
filterFieldsName: "orderDetailAll_",
|
dataRequest: [
|
"doctype",
|
"docstatus"
|
],
|
title: "全国订单",
|
tabs:{},
|
orderby: "biz_date desc,update_time desc,code desc",
|
|
provinces: [],
|
doctype: [],
|
docstatus: [],
|
activeName: 'tabAll',
|
emp_id:window.top.userinfo.employee.id,
|
emp_code:window.top.userinfo.employee.code,
|
dataRequest: [
|
{
|
isClientMode: false,
|
code: "code",
|
label: "name",
|
name: "delivery_part_code",
|
dataname: "deliveryOrganization",
|
},
|
],
|
dataRequestObj: {},
|
bus: true,
|
|
issumloading: false,
|
total_money: 0,
|
total_num: 0,
|
},
|
created() {
|
this.pageCode = "A0-8-2";
|
this.getResoures();
|
this.getMeResoures();
|
let isDirectory = localStorage.isdirectory;
|
if(isDirectory)
|
this.bus = false;
|
let roleList = window.top.userinfo.user.roleList;
|
roleList.map(e=>{
|
if(e.code == 'qgdj') {
|
this.isQGXD = true;
|
}
|
})
|
},
|
|
mounted() {
|
let me = this;
|
|
if (this.dataRequest.length) {
|
var result = {};
|
this.loadRequestData(this.dataRequest, result, function(data) {
|
me.dataRequestObj = data;
|
if (me.filterFields.length) {
|
var formFields_part_ = clone(me.filterFields);
|
formFields_part_.map(e=>{
|
if(e.field == "delivery_part_code") {
|
e.options = me.dataRequestObj.delivery_part_code;
|
}
|
});
|
|
me.filterFields = formFields_part_;
|
}
|
|
me.initData();
|
});
|
}
|
|
|
this.$nextTick(() => { // 以服务的方式调用的 Loading 需要异步关闭
|
hideLoading();
|
});
|
|
},
|
|
methods:{
|
|
initData() {
|
if (initlized) { return; }
|
initlized = true;
|
|
this.onQuery();
|
|
},
|
getMeResoures() {
|
let me = this;
|
},
|
getTotal(filter) {
|
var me = this;
|
me.total_money = 0;
|
me.total_num = 0;
|
let param_ = {
|
isClientMode: false,
|
dataname:"getAllSaleAmt",
|
filter:filter
|
}
|
me.issumloading = true;
|
Server.call("root/data/getEntitySet", param_, function(result) {
|
console.log(result);
|
me.issumloading = false;
|
if (result && result.data && result.data.entityset){
|
me.total_money = toMoney(result.data.entityset[0].allamt);
|
me.total_num = result.data.entityset[0].allcnt;
|
}
|
});
|
},
|
onServerInitData(data) {
|
var me = this.data;
|
|
me.tableFields = data.tableFields;
|
me.filterFields = data.filterFields;
|
me.doctype = data.doctype;
|
me.docstatus = data.docstatus;
|
|
if(me.filterFields.length > 0) {
|
for(var i=0; i < me.filterFields.length; i++) {
|
let fieldObj_ = me.filterFields[i];
|
|
me.filterFieldsObj[fieldObj_.field] = fieldObj_;
|
}
|
}
|
if(me.tableFields.length > 0) {
|
for(var i=0; i < me.tableFields.length; i++) {
|
let fieldObj_ = me.tableFields[i];
|
|
if (window.top.isdistributor) {
|
if (fieldObj_.field == "settle_type"
|
|| fieldObj_.field == "business_depart_name"
|
|| fieldObj_.field == "sales_business_type"
|
|| fieldObj_.field == "sales_type"
|
|| fieldObj_.field == "business_type") {
|
fieldObj_.isshow = "F"
|
}
|
}
|
|
me.tableFieldsObj[fieldObj_.field] = fieldObj_;
|
}
|
}
|
},
|
doQuery: function() {
|
let me = this;
|
let filter_ = " (status = 'open' or status = 'working')";
|
|
if (window.top.isdistributor) {
|
var code = window.top.distributorObj.md_code;
|
var name = window.top.distributorObj.md_description;
|
filter_ += " and (sales_order.customer_code='"+code+"' or sales_order.customer_name='"+name+"')";
|
}
|
else {
|
if(!this.isQGXD) {
|
// filter_ += " and create_operate_code = '"+ this.emp_code + "'"
|
filter_ += " and (create_operate_code = '"+ this.emp_code + "' or operate_emp_code = '" + this.emp_code + "')"
|
}
|
}
|
|
this.filterList = [];
|
|
for(var k in this.filterObj) {
|
let k_val = this.filterObj[k];
|
let fieldObj_ = this.filterFieldsObj[k];
|
|
let type_ = fieldObj_.type;
|
let field_ = fieldObj_.field;
|
let fieldtype_ = "equal";
|
if (fieldObj_.fieldname) {
|
field_ = fieldObj_.fieldname
|
}
|
if (fieldObj_.fieldtype) {
|
fieldtype_ = fieldObj_.fieldtype
|
}
|
|
//传条件数据有前端拼接
|
if (type_ == "daterange" && k_val.length) {//期间筛选
|
//
|
var k_val_a = k_val[0];
|
var k_val_b = k_val[1];
|
if (fieldtype_ == "inScopeInclude") {//期间之内，包含两端
|
filter_ += " and ((" + field_ + ">'" + k_val_a + "' and " + field_ + "<'" + k_val_b + "') or (" + field_ + "='" + k_val_a + "' or " + field_ + "='" + k_val_b + "'))";
|
}
|
}
|
else if (type_ != "daterange") {
|
//注释：type: equal（等于）/in（在多个数据中）/like（模糊）/minval（最小值）/maxval（最大值）/mininclude（最小且包含该值）/maxinclude（最大且包含该值）
|
if (fieldtype_ == "like") {
|
filter_ += " and " + field_ + " like '%" + k_val +"%'";
|
}
|
else {
|
filter_ += " and " + field_ + " = '" + k_val +"'";
|
}
|
}
|
|
}
|
if (this.tabStatus){
|
if (this.tabStatus == 'tabAll'){
|
//filter_ += " and create_operate_code = '"+ this.emp_code + "'"
|
}
|
else if (this.tabStatus == 'tabInput'){
|
filter_ += " and status = 'input'";
|
}
|
else if (this.tabStatus == 'tabWorking'){
|
filter_ += " and status = 'working'";
|
}
|
else if (this.tabStatus == 'tabOpen'){
|
filter_ += " and status = 'open'";
|
}
|
else if (this.tabStatus == 'tabRefuse'){
|
filter_ += " and status = 'refuse'";
|
}
|
if (this.tabStatus == 'tabU8'){
|
filter_ += " and sync = 0 and status = 'open'";
|
var tableFields_ = clone(me.tableFields);
|
tableFields_[1].isshow = "T";
|
me.tableFields = tableFields_;
|
}else {
|
var tableFields_ = clone(me.tableFields);
|
tableFields_[1].isshow = "F";
|
me.tableFields = tableFields_;
|
}
|
}
|
|
let param_ = {
|
isClientMode: false,
|
dataname: this.dataname,
|
filterList: this.filterList,
|
filter: filter_,
|
orderby: this.orderby,
|
page: {
|
no: this.pagenum,
|
pagesize: this.pagesize
|
},
|
//attachmeta: true
|
}
|
this.tableloading = true
|
this.getTotal(filter_);
|
Server.call("root/data/getEntitySet", param_, function(result) {
|
console.log(result);
|
me.total = 0;
|
me.tableData = [];
|
if (result && result.data) {
|
var data_ = result.data.entityset;
|
me.total = result.data.page.recordcount;
|
me.tableData = data_;
|
|
}
|
me.tableloading = false
|
me.tableDataAfter();
|
},function(result) {
|
me.tableloading = false
|
});
|
},
|
|
download (){
|
let me = this;
|
let filter_ = " (status = 'open' or status = 'working')";
|
if(!this.isQGXD) {
|
// filter_ += " and create_operate_code = '"+ this.emp_code + "'"
|
filter_ += " and (create_operate_code = '"+ this.emp_code + "' or operate_emp_code = '" + this.emp_code + "')"
|
}
|
this.filterList = [];
|
for(var k in this.filterObj) {
|
let k_val = this.filterObj[k];
|
let fieldObj_ = this.filterFieldsObj[k];
|
|
let type_ = fieldObj_.type;
|
let field_ = fieldObj_.field;
|
let fieldtype_ = "equal";
|
if (fieldObj_.fieldname) {
|
field_ = fieldObj_.fieldname
|
}
|
if (fieldObj_.fieldtype) {
|
fieldtype_ = fieldObj_.fieldtype
|
}
|
|
//传条件数据有前端拼接
|
if (type_ == "daterange" && k_val.length) {//期间筛选
|
//
|
var k_val_a = k_val[0];
|
var k_val_b = k_val[1];
|
if (fieldtype_ == "inScopeInclude") {//期间之内，包含两端
|
filter_ += " and ((" + field_ + ">'" + k_val_a + "' and " + field_ + "<'" + k_val_b + "') or (" + field_ + "='" + k_val_a + "' or " + field_ + "='" + k_val_b + "'))";
|
}
|
}
|
else if (type_ != "daterange") {
|
//注释：type: equal（等于）/in（在多个数据中）/like（模糊）/minval（最小值）/maxval（最大值）/mininclude（最小且包含该值）/maxinclude（最大且包含该值）
|
if (fieldtype_ == "like") {
|
filter_ += " and " + field_ + " like '%" + k_val +"%'";
|
}
|
else {
|
filter_ += " and " + field_ + " = '" + k_val +"'";
|
}
|
}
|
|
}
|
if (this.tabStatus){
|
if (this.tabStatus == 'tabAll'){
|
//filter_ += " and create_operate_code = '"+ this.emp_code + "'"
|
}
|
else if (this.tabStatus == 'tabInput'){
|
filter_ += " and status = 'input'";
|
}
|
else if (this.tabStatus == 'tabWorking'){
|
filter_ += " and status = 'working'";
|
}
|
else if (this.tabStatus == 'tabOpen'){
|
filter_ += " and status = 'open'";
|
}
|
else if (this.tabStatus == 'tabRefuse'){
|
filter_ += " and status = 'refuse'";
|
}
|
if (this.tabStatus == 'tabU8'){
|
filter_ += " and sync = 0 and status = 'open'";
|
}
|
}
|
Root.message({
|
type: 'warning',
|
message: '正在下载,请稍后...'
|
});
|
document.getElementById("page_loading").style.display = "block"
|
filter_ = encodeURI(filter_);
|
var url = baseUrl + "file/downloadDataWithExcel?userId=" + window.top.userinfo.user.id + "&type=salesDownload&dataName=downloadSalesOrderDetail" + "&name=" + "销售订单明细导出.xlsx" + "&filter=" +filter_;
|
dealExportByPath(url, "销售订单明细导出.xlsx");
|
window.onresize = function(e) {
|
document.getElementById("page_loading").style.display = "none"
|
};
|
window.onblur = function(e) {
|
document.getElementById("page_loading").style.display = "none"
|
};
|
|
},
|
onCellClick(config, obj) {
|
let me = this;
|
var clickContext = this.selectCellField.clickContext;
|
if(this.selectCellField.field == "status" && obj.row.flow_id && obj.row.status != "input" ){
|
clickContext.url = "../approval/ApprovalList.html";
|
clickContext.delta = {
|
flow_id: obj.row.flow_id,
|
}
|
clickContext.width = "75vw";
|
clickContext.height = "65vh";
|
clickContext.hide_close = true;
|
|
}
|
if (clickContext && clickContext.type == "popup" && clickContext.url != "") {
|
config.combine({
|
hide_close: clickContext.hide_close,
|
url: clickContext.url,
|
width: clickContext.width,
|
height: clickContext.height,
|
sceneCode: clickContext.sceneCode,
|
data: obj.row,
|
delta: clickContext.delta ? clickContext.delta : {},
|
|
})
|
}
|
else {
|
return false;
|
}
|
|
return true;
|
},
|
|
onshowFilterPopup(filter) {
|
var me = this;
|
var fieldObj_ = filter.obj;
|
var filterValue = clone(me.filterObj);
|
var field_ = fieldObj_.field;
|
if ("product_name" == field_) {
|
Root.showPopup({
|
url: "../md/product/popup/product_list.html",
|
width: 800,
|
height: 550,
|
type: "onlySimple",
|
callback: function(result, callback) {
|
filterValue[field_] = result.row.product_name;
|
me.filterObj = filterValue;
|
me.onQuery();
|
if (callback) {
|
callback();
|
}
|
}
|
});
|
}
|
else if ("customer_name" == field_) {
|
Root.showPopup({
|
url: "../md/customer/popup/customer_list.html",
|
|
width: 800,
|
height: 550,
|
callback: function(result, callback) {
|
filterValue[field_] = result.row.md_description;
|
me.filterObj = filterValue;
|
me.onQuery();
|
if (callback) {
|
callback();
|
}
|
}
|
});
|
}
|
}
|
}
|
});
|
</script>
|
<style type="text/css">
|
.el-tabs__nav-scroll {
|
overflow: hidden;
|
margin-bottom: -1px;
|
position: relative;
|
padding-left: 70px;
|
}
|
</style>
|
</body>
|
</html>
|
