<title>计划订单表</title>
|
<!--当前位置开始-->
|
<div class="layui-card layadmin-header">
|
<div class="layui-breadcrumb" lay-filter="breadcrumb">
|
<script type="text/html" template lay-done="layui.data.updateMainBreadcrumb();">
|
</script>
|
</div>
|
</div>
|
<!--当前位置结束-->
|
<style>
|
/* 重写样式 */
|
</style>
|
<script type="text/html" template lay-type="Post" lay-url="Api/CoreCmsPlanOrder/GetIndex" lay-done="layui.data.done(d);">
|
|
</script>
|
<div class="table-body">
|
<table id="LAY-app-CoreCmsPlanOrder-tableBox" lay-filter="LAY-app-CoreCmsPlanOrder-tableBox"></table>
|
</div>
|
|
<script type="text/html" id="LAY-app-CoreCmsPlanOrder-toolbar">
|
<div class="layui-form coreshop-toolbar-search-form">
|
<div class="layui-form-item">
|
|
<div class="layui-inline">
|
<label class="layui-form-label" for="orderId">订单号</label>
|
<div class="layui-input-inline">
|
<input type="text" name="orderId" placeholder="请输入订单号" class="layui-input">
|
</div>
|
</div>
|
<!--<div class="layui-inline">
|
<label class="layui-form-label" for="orderAmount">调整订单金额</label>
|
<div class="layui-input-inline">
|
<input type="text" name="orderAmount" placeholder="请输入调整订单金额" class="layui-input">
|
</div>
|
</div>-->
|
|
|
<div class="layui-inline">
|
<label class="layui-form-label" for="status">订单状态</label>
|
<div class="layui-input-inline">
|
<select name="status">
|
<option value="">请选择</option>
|
<option value="1">未提交</option>
|
<option value="2">已提交</option>
|
</select>
|
</div>
|
</div>
|
<!--<div class="layui-inline">
|
<label class="layui-form-label" for="userId">用户ID 关联user.id</label>
|
<div class="layui-input-inline">
|
<input type="text" name="userId" placeholder="请输入用户ID 关联user.id" class="layui-input">
|
</div>
|
</div>-->
|
<div class="layui-inline">
|
<label class="layui-form-label" for="shipAddress">学校</label>
|
<div class="layui-input-inline">
|
<input type="text" name="shipAddress" placeholder="请输入学校" class="layui-input">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" for="shipName">联系人</label>
|
<div class="layui-input-inline">
|
<input type="text" name="shipName" placeholder="请输入联系人" class="layui-input">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" for="shipMobile">联系电话</label>
|
<div class="layui-input-inline">
|
<input type="text" name="shipMobile" placeholder="请输入联系电话" class="layui-input">
|
</div>
|
</div>
|
<!--<div class="layui-inline">
|
<label class="layui-form-label" for="oldOrderAmount">计划订单金额</label>
|
<div class="layui-input-inline">
|
<input type="text" name="oldOrderAmount" placeholder="请输入计划订单金额" class="layui-input">
|
</div>
|
</div>-->
|
<!--<div class="layui-inline">
|
<label class="layui-form-label" for="keYongAmount">可用余额</label>
|
<div class="layui-input-inline">
|
<input type="text" name="keYongAmount" placeholder="请输入可用余额" class="layui-input">
|
</div>
|
</div>-->
|
<div class="layui-inline">
|
<label class="layui-form-label" for="createTime">建立时间</label>
|
<div class="layui-input-inline" style="width: 260px;">
|
<input type="text" name="createTime" id="searchTime-CoreCmsPlanOrder-createTime" placeholder="请输入建立时间" class="layui-input">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" for="upDataTime">修改时间</label>
|
<div class="layui-input-inline" style="width: 260px;">
|
<input type="text" name="upDataTime" id="searchTime-CoreCmsPlanOrder-upDataTime" placeholder="请输入修改时间" class="layui-input">
|
</div>
|
</div>
|
<!--<div class="layui-inline">
|
<label class="layui-form-label" for="createBy">创建人</label>
|
<div class="layui-input-inline">
|
<input type="text" name="createBy" placeholder="请输入创建人" class="layui-input">
|
</div>
|
</div>-->
|
<!--<div class="layui-inline">
|
<label class="layui-form-label" for="upDataBy">修改人</label>
|
<div class="layui-input-inline">
|
<input type="text" name="upDataBy" placeholder="请输入修改人" class="layui-input">
|
</div>
|
</div>-->
|
<!--<div class="layui-inline">
|
<label class="layui-form-label" for="isdelete">删除标志</label>
|
<div class="layui-input-inline">
|
<select name="isdelete">
|
<option value="">请选择</option>
|
<option value="True">是</option>
|
<option value="False">否</option>
|
</select>
|
</div>
|
</div>-->
|
<div class="layui-inline">
|
<button class="layui-btn layui-btn-sm" lay-submit lay-filter="LAY-app-CoreCmsPlanOrder-search"><i class="layui-icon layui-icon-search"></i>筛选</button>
|
</div>
|
</div>
|
</div>
|
</script>
|
|
<script type="text/html" id="LAY-app-CoreCmsPlanOrder-pagebar">
|
<div class="layui-btn-container">
|
<!--<button class="layui-btn layui-btn-sm" lay-event="addData"><i class="layui-icon layui-icon-add-1"></i>添加数据</button>
|
<button class="layui-btn layui-btn-sm" lay-event="batchDelete"><i class="layui-icon layui-icon-delete"></i>批量删除</button>-->
|
<button type="button" class="layui-btn layui-btn-sm" id="upIndexPopupWindowImageUrlBtn">上传计划订单</button>
|
<button class="layui-btn layui-btn-sm" lay-event="selectExportExcel"><i class="layui-icon layui-icon-add-circle"></i>选择导出</button>
|
<button class="layui-btn layui-btn-sm" lay-event="queryExportExcel"><i class="layui-icon layui-icon-download-circle"></i>查询导出</button>
|
<a class="layui-btn layui-btn-sm" href="/static/jihuageshi/上传计划订单.xlsx" >上传模板</a>
|
</div>
|
</script>
|
|
<script type="text/html" id="LAY-app-CoreCmsPlanOrder-tableBox-bar">
|
<a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="detail">查看</a>
|
<!--<a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>
|
<a class="layui-btn layui-btn-danger layui-btn-xs" data-dropdown="#CoreCmsPlanOrderTbDelDrop{{d.LAY_INDEX}}" no-shade="true">删除</a>-->
|
<div class="dropdown-menu-nav dropdown-popconfirm dropdown-top-right layui-hide" id="CoreCmsPlanOrderTbDelDrop{{d.LAY_INDEX}}"
|
style="max-width: 200px;white-space: normal;min-width: auto;margin-left: 10px;">
|
<div class="dropdown-anchor"></div>
|
<div class="dropdown-popconfirm-title">
|
<i class="layui-icon layui-icon-help"></i>
|
确定要删除吗？
|
</div>
|
<div class="dropdown-popconfirm-btn">
|
<a class="layui-btn layui-btn-primary cursor" btn-cancel>取消</a>
|
<a class="layui-btn layui-btn-normal cursor" lay-event="del">确定</a>
|
</div>
|
</div>
|
</script>
|
|
<script>
|
var indexData;
|
var debug= layui.setter.debug;
|
layui.data.done = function (d) {
|
//开启调试情况下获取接口赋值数据
|
if (debug) { console.log(d); }
|
|
indexData = d.data;
|
layui.use(['index', 'table', 'laydate', 'util', 'coredropdown', 'coreHelper', 'upload'],
|
function () {
|
var $ = layui.$
|
, admin = layui.admin
|
, table = layui.table
|
, form = layui.form
|
, laydate = layui.laydate
|
, setter = layui.setter
|
, coreHelper = layui.coreHelper
|
, util = layui.util
|
, view = layui.view
|
, upload = layui.upload;
|
|
var searchwhere;
|
//监听搜索
|
form.on('submit(LAY-app-CoreCmsPlanOrder-search)',
|
function(data) {
|
var field = data.field;
|
searchwhere = field;
|
//执行重载
|
table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox',{ where: field });
|
});
|
//数据绑定
|
table.render({
|
elem: '#LAY-app-CoreCmsPlanOrder-tableBox',
|
url: layui.setter.apiUrl + 'Api/CoreCmsPlanOrder/GetPageList',
|
method: 'POST',
|
toolbar: '#LAY-app-CoreCmsPlanOrder-toolbar',
|
pagebar: '#LAY-app-CoreCmsPlanOrder-pagebar',
|
className: 'pagebarbox',
|
defaultToolbar: ['filter', 'print', 'exports'],
|
height: 'full-127',//面包屑142px,搜索框4行172,3行137,2行102,1行67
|
page: true,
|
limit: 30,
|
limits: [10, 15, 20, 25, 30, 50, 100, 200],
|
text: {none: '暂无相关数据'},
|
cols: [
|
[
|
{ type: "checkbox", fixed: "left" },
|
{ field: 'orderId', title: '订单号', sort: false,width: 115 },
|
|
|
/* { field: 'userId', title: '用户ID 关联user.id', sort: false,width: 105 },*/
|
{ field: 'shipAddress', title: '学校', sort: false,width: 335 },
|
{ field: 'shipName', title: '联系人', sort: false,width: 115 },
|
{ field: 'shipMobile', title: '联系电话', sort: false,width: 115 },
|
{ field: 'oldOrderAmount', title: '计划金额', sort: false, width: 115 },
|
{ field: 'orderAmount', title: '调整金额', sort: false, width: 115 },
|
{ field: 'keYongAmount', title: '可用余额', sort: false,width: 115 },
|
{ field: 'createTime', title: '建立时间', width: 140, sort: false},
|
{ field: 'upDataTime', title: '修改时间', width: 140, sort: false},
|
//{ field: 'createBy', title: '创建人', sort: false,width: 105 },
|
//{ field: 'upDataBy', title: '修改人', sort: false,width: 105 },
|
//{ field: 'isdelete', title: '删除标志', width: 95, templet: '#switch_isdelete', sort: false , unresize: true},
|
{ field: 'statusText', title: '订单状态', sort: false, width: 115 },
|
{ width: 172, align: 'center', title:'操作', fixed: 'right', toolbar: '#LAY-app-CoreCmsPlanOrder-tableBox-bar' }
|
]
|
]
|
});
|
//监听排序事件
|
table.on('sort(LAY-app-CoreCmsPlanOrder-tableBox)', function(obj){
|
table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox', {
|
initSort: obj, //记录初始排序，如果不设的话，将无法标记表头的排序状态。
|
where: { //请求参数（注意：这里面的参数可任意定义，并非下面固定的格式）
|
orderField: obj.field, //排序字段
|
orderDirection: obj.type //排序方式
|
}
|
});
|
});
|
//监听行双击事件
|
table.on('rowDouble(LAY-app-CoreCmsPlanOrder-tableBox)', function (obj) {
|
//查看详情
|
doDetails(obj);
|
});
|
//头工具栏事件
|
table.on('pagebar(LAY-app-CoreCmsPlanOrder-tableBox)', function (obj) {
|
var checkStatus = table.checkStatus(obj.config.id);
|
switch (obj.event) {
|
case 'addData':
|
doCreate();
|
break;
|
case 'batchDelete':
|
doBatchDelete(checkStatus);
|
break;
|
case 'selectExportExcel':
|
doSelectExportExcel(checkStatus);
|
break;
|
case 'queryExportExcel':
|
doQueryExportexcel();
|
break;
|
};
|
});
|
//监听工具条
|
table.on('tool(LAY-app-CoreCmsPlanOrder-tableBox)',
|
function(obj) {
|
if (obj.event === 'detail') {
|
doDetails(obj);
|
} else if (obj.event === 'del') {
|
doDelete(obj);
|
} else if (obj.event === 'edit') {
|
doEdit(obj)
|
}
|
});
|
//执行创建操作
|
function doCreate(){
|
coreHelper.Post("Api/CoreCmsPlanOrder/GetCreate", null, function (e) {
|
if (e.code === 0) {
|
admin.popup({
|
shadeClose: false,
|
title: '创建数据',
|
area: ['1200px', '90%'],
|
id: 'LAY-popup-CoreCmsPlanOrder-create',
|
success: function (layero, index) {
|
view(this.id).render('base/CoreCmsPlanOrder/create', { data: e.data }).done(function () {
|
//监听提交
|
form.on('submit(LAY-app-CoreCmsPlanOrder-createForm-submit)',
|
function(data) {
|
var field = data.field; //获取提交的字段
|
|
field.isdelete = field.isdelete == 'on';
|
|
if (debug) { console.log(field); } //开启调试返回数据
|
//提交 Ajax 成功后，关闭当前弹层并重载表格
|
coreHelper.Post("Api/CoreCmsPlanOrder/DoCreate", field, function (e) {
|
console.log(e)
|
if (e.code === 0) {
|
layui.table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox'); //重载表格
|
layer.close(index); //再执行关闭
|
layer.msg(e.msg);
|
} else {
|
layer.msg(e.msg);
|
}
|
});
|
});
|
});
|
// 禁止弹窗出现滚动条
|
$(layero).children('.layui-layer-content').css('overflow', 'visible');
|
}
|
, btn: ['确定', '取消']
|
, yes: function (index, layero) {
|
layero.contents().find("#LAY-app-CoreCmsPlanOrder-createForm-submit").click();
|
}
|
});
|
} else {
|
layer.msg(e.msg);
|
}
|
});
|
}
|
//执行编辑操作
|
function doEdit(obj){
|
coreHelper.Post("Api/CoreCmsPlanOrder/GetEdit", {id:obj.data.id}, function (e) {
|
if (e.code === 0) {
|
admin.popup({
|
shadeClose: false,
|
title: '编辑数据',
|
area: ['1200px', '90%'],
|
id: 'LAY-popup-CoreCmsPlanOrder-edit',
|
success: function (layero, index) {
|
view(this.id).render('base/CoreCmsPlanOrder/edit', { data: e.data }).done(function () {
|
//监听提交
|
form.on('submit(LAY-app-CoreCmsPlanOrder-editForm-submit)',
|
function(data) {
|
var field = data.field; //获取提交的字段
|
|
field.isdelete = field.isdelete == 'on';
|
|
if (debug) { console.log(field); } //开启调试返回数据
|
//提交 Ajax 成功后，关闭当前弹层并重载表格
|
coreHelper.Post("Api/CoreCmsPlanOrder/DoEdit", field, function (e) {
|
console.log(e)
|
if (e.code === 0) {
|
layui.table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox'); //重载表格
|
layer.close(index); //再执行关闭
|
layer.msg(e.msg);
|
} else {
|
layer.msg(e.msg);
|
}
|
});
|
});
|
})
|
// 禁止弹窗出现滚动条
|
$(layero).children('.layui-layer-content').css('overflow', 'visible');
|
}
|
, btn: ['确定', '取消']
|
, yes: function (index, layero) {
|
layero.contents().find("#LAY-app-CoreCmsPlanOrder-editForm-submit").click();
|
}
|
});
|
} else {
|
layer.msg(e.msg);
|
}
|
});
|
}
|
//执行预览操作
|
function doDetails(obj) {
|
coreHelper.Post("Api/CoreCmsPlanOrder/GetDetails", { id: obj.data.orderId }, function (e) {
|
if (e.code === 0) {
|
admin.popup({
|
shadeClose: false,
|
title: '查看详情',
|
area: ['1200px', '90%'],
|
id: 'LAY-popup-CoreCmsPlanOrder-details',
|
success: function (layero, index) {
|
view(this.id).render('CoreCmsPlanOrder/details', { data: e.data }).done(function () {
|
form.render();
|
});
|
// 禁止弹窗出现滚动条
|
$(layero).children('.layui-layer-content').css('overflow', 'visible');
|
}
|
});
|
} else {
|
layer.msg(e.msg);
|
}
|
});
|
}
|
//执行单个删除
|
function doDelete(obj){
|
coreHelper.Post("Api/CoreCmsPlanOrder/DoDelete", { id: obj.data.id }, function (e) {
|
if (debug) { console.log(e); } //开启调试返回数据
|
table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox');
|
layer.msg(e.msg);
|
});
|
}
|
//执行批量删除
|
function doBatchDelete(checkStatus){
|
var checkData = checkStatus.data;
|
if (checkData.length === 0) {
|
return layer.msg('请选择要删除的数据');
|
}
|
layer.confirm('确定删除吗？删除后将无法恢复。',
|
function(index) {
|
var delidsStr = [];
|
layui.each(checkData,
|
function(index, item) {
|
delidsStr.push(item.id);
|
});
|
coreHelper.Post("Api/CoreCmsPlanOrder/DoBatchDelete", { id: delidsStr }, function (e) {
|
if (debug) { console.log(e); } //开启调试返回数据
|
table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox');
|
layer.msg(e.msg);
|
});
|
});
|
}
|
//执行查询条件导出excel
|
function doQueryExportexcel(){
|
layer.confirm('确定根据当前的查询条件导出数据吗？',
|
function(index) {
|
var field = searchwhere;
|
coreHelper.PostForm("Api/CoreCmsPlanOrder/QueryExportExcel", field, function (e) {
|
if (debug) { console.log(e); } //开启调试返回数据
|
if (e.code === 0) {
|
window.open(e.data);
|
} else {
|
layer.msg(e.msg);
|
}
|
});
|
});
|
}
|
//执行选择目录导出数据
|
function doSelectExportExcel(checkStatus){
|
var checkData = checkStatus.data;
|
if (checkData.length === 0) {
|
return layer.msg('请选择您要导出的数据');
|
}
|
layer.confirm('确定导出选择的内容吗？',
|
function(index) {
|
var delidsStr = [];
|
layui.each(checkData,
|
function(index, item) {
|
delidsStr.push(item.id);
|
});
|
layer.close(index);
|
coreHelper.Post("Api/CoreCmsPlanOrder/SelectExportExcel", { id: delidsStr }, function (e) {
|
if (debug) { console.log(e); } //开启调试返回数据
|
if (e.code === 0) {
|
window.open(e.data);
|
} else {
|
layer.msg(e.msg);
|
}
|
});
|
});
|
}
|
|
|
laydate.render({
|
elem: '#searchTime-CoreCmsPlanOrder-createTime',
|
type: 'datetime',
|
range: '到',
|
});
|
laydate.render({
|
elem: '#searchTime-CoreCmsPlanOrder-upDataTime',
|
type: 'datetime',
|
range: '到',
|
});
|
|
//监听 表格复选框操作
|
|
layui.form.on('switch(switch_isdelete)', function (obj) {
|
coreHelper.Post("Api/CoreCmsPlanOrder/DoSetisdelete", { id: this.value, data: obj.elem.checked }, function (e) {
|
if (debug) { console.log(e); } //开启调试返回数据
|
//table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox');
|
layer.msg(e.msg);
|
});
|
});
|
|
|
//首页弹窗广告图片
|
upload.render({
|
elem: '#upIndexPopupWindowImageUrlBtn'
|
, url: layui.setter.apiUrl + 'Api/Tools/UploadFilesXls'
|
, accept: 'file' // 允许上传文件
|
, exts: 'xlsx|xls' // 只允许上传Excel文件
|
, done: function (res) {
|
if (res.code > 0) {
|
return layer.msg(res.msg);
|
}
|
layer.msg(res.msg);
|
layui.table.reloadData('LAY-app-CoreCmsPlanOrder-tableBox'); //重载表格
|
}
|
, error: function () {
|
return layer.msg('上传失败');
|
}
|
});
|
//重载form
|
form.render();
|
});
|
};
|
</script>
|
|
<!--设置删除标志-->
|
<script type="text/html" id="switch_isdelete">
|
<input type="checkbox" name="switch_isdelete" value="{{d.id}}" lay-skin="switch" lay-text="开启|关闭" lay-filter="switch_isdelete" {{ d.isdelete ? 'checked' : '' }}>
|
</script>
|
