232 lines
9.2 KiB
Plaintext
232 lines
9.2 KiB
Plaintext
@{
|
|
ViewBag.Title = "问卷";
|
|
Layout = "~/Views/Shared/_Layout.cshtml";
|
|
}
|
|
|
|
<style>
|
|
.layui-table-link {
|
|
color: #01AAED;
|
|
cursor: pointer;
|
|
}
|
|
|
|
.layui-table-link:hover {
|
|
color: #1E9FFF;
|
|
text-decoration: underline;
|
|
}
|
|
</style>
|
|
|
|
<div class="layui-fluid">
|
|
<div class="layui-card">
|
|
<!-- 搜索条件 -->
|
|
<form class="layui-form" style="padding-top:10px">
|
|
<div class="layui-form-item">
|
|
<div class="layui-inline">
|
|
<label class="layui-form-label">用户名</label>
|
|
<div class="layui-input-inline">
|
|
<input type="text" name="username" placeholder="请输入" autocomplete="off" class="layui-input">
|
|
</div>
|
|
</div>
|
|
<div class="layui-inline">
|
|
<label class="layui-form-label">客户Id</label>
|
|
<div class="layui-input-inline">
|
|
<input type="text" name="umid" placeholder="请输入" autocomplete="off" class="layui-input">
|
|
</div>
|
|
</div>
|
|
<div class="layui-inline">
|
|
<label class="layui-form-label">开始时间</label>
|
|
<div class="layui-input-inline">
|
|
<input type="text" name="starttime" id="starttime" placeholder="请选择" autocomplete="off" class="layui-input">
|
|
</div>
|
|
</div>
|
|
<div class="layui-inline">
|
|
<label class="layui-form-label">结束时间</label>
|
|
<div class="layui-input-inline">
|
|
<input type="text" name="endtime" id="endtime" placeholder="请选择" autocomplete="off" class="layui-input">
|
|
</div>
|
|
</div>
|
|
<div class="layui-inline">
|
|
<button class="layui-btn" lay-submit lay-filter="search">
|
|
<i class="layui-icon layui-icon-search"></i> 搜索
|
|
</button>
|
|
@*<input class="layui-btn layui-icon layui-icon-export" type="button" id="exportBtn" data-method="export" value="导出" />*@
|
|
</div>
|
|
</div>
|
|
</form>
|
|
<div class="layui-card-body">
|
|
<table id="dataTable" lay-filter="dataTable"></table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<script>
|
|
layui.config({
|
|
base: '/Scripts/layui_ext/',
|
|
}).extend({
|
|
excel: 'excel.min',
|
|
});
|
|
layui.use(['table', 'form', 'excel', 'laydate'], function () {
|
|
var table = layui.table;
|
|
var form = layui.form;
|
|
var excel = layui.excel;
|
|
var laydate = layui.laydate;
|
|
|
|
// 初始化日期控件
|
|
laydate.render({
|
|
elem: '#starttime',
|
|
value: new Date(new Date().setMonth(new Date().getMonth() - 1)),
|
|
format: 'yyyy-MM-dd'
|
|
});
|
|
laydate.render({
|
|
elem: '#endtime',
|
|
value: new Date(),
|
|
format: 'yyyy-MM-dd'
|
|
});
|
|
|
|
//初始化表格
|
|
table.render({
|
|
elem: '#dataTable',
|
|
url: '/QsurveyOrder/GetList',
|
|
page: {
|
|
layout: ['limit', 'count', 'prev', 'page', 'next', 'skip'],
|
|
groups: 5
|
|
},
|
|
where: {}, // 初始化空的查询条件
|
|
cols: [[
|
|
{ field: 'Username', title: '用户名' },
|
|
{
|
|
field: 'Nickname', title: '昵称', templet: function (d) {
|
|
return d.Nickname ? decodeURIComponent(d.Nickname) : '';
|
|
}
|
|
},
|
|
{
|
|
field: 'Umid', title: '客户ID', templet: function (d) {
|
|
return '<a href="javascript:;" lay-event="showDetail" data-username="' + d.Username + '" data-name="' + (d.Nickname ? decodeURIComponent(d.Nickname) : '') + '" class="layui-table-link">' + d.Umid + '</a>';
|
|
}
|
|
},
|
|
{ field: 'AppId', title: '应用ID' },
|
|
{ field: 'AppUserId', title: '用户ID' },
|
|
{
|
|
field: 'cTime', title: '创建时间'
|
|
},
|
|
{
|
|
field: 'Headimgurl', title: '头像', templet: function (d) {
|
|
return d.Headimgurl ? '<img src="' + d.Headimgurl + '" style="width:40px;height:40px;border-radius:50%;">' : '';
|
|
}
|
|
},
|
|
{
|
|
title: '问卷', templet: function (d) {
|
|
return '<a href="javascript:;" lay-event="openSurvey" class="layui-table-link">查看问卷</a>';
|
|
}
|
|
}
|
|
]],
|
|
limits: [10, 20, 50, 100],
|
|
limit: 20,
|
|
request: {
|
|
pageName: 'pageIndex',
|
|
limitName: 'pageSize'
|
|
},
|
|
response: {
|
|
statusName: 'code',
|
|
statusCode: 0,
|
|
msgName: 'msg',
|
|
countName: 'count',
|
|
dataName: 'data'
|
|
}
|
|
});
|
|
|
|
// 监听搜索事件
|
|
form.on('submit(search)', function(data){
|
|
// 确保日期值正确传递
|
|
if(!data.field.starttime) {
|
|
data.field.starttime = layui.laydate.format(new Date(new Date().setMonth(new Date().getMonth() - 1)), 'yyyy-MM-dd');
|
|
}
|
|
if(!data.field.endtime) {
|
|
data.field.endtime = layui.laydate.format(new Date(), 'yyyy-MM-dd');
|
|
}
|
|
|
|
// 重载表格
|
|
table.reload('dataTable', {
|
|
where: data.field,
|
|
page: {
|
|
curr: 1
|
|
}
|
|
});
|
|
return false;
|
|
});
|
|
|
|
//监听工具条
|
|
table.on('tool(dataTable)', function (obj) {
|
|
var data = obj.data;
|
|
if (obj.event === 'showEids') {
|
|
//弹出层
|
|
layer.open({
|
|
type: 2,
|
|
title: '服务人员列表',
|
|
area: ['1000px', '800px'],
|
|
content: '/WxTranUser/ServiceUserList?eids=' + encodeURIComponent(data.ExternalUsers)
|
|
});
|
|
} else if (obj.event === 'showDetail') {
|
|
//获取点击的链接元素
|
|
var link = $(this);
|
|
var username = link.data('username');
|
|
var name = link.data('name');
|
|
//跳转到客户详情页
|
|
parent.AddNewTab(name + '--客户明细',
|
|
'http://hegui.crm.tcfortune.com:8282/Csvr/CustomerInfo/CustomerDetail?hgCustomer=1&isFromHg=1&resid='
|
|
+ data.Umid + '&name=' + encodeURIComponent(name));
|
|
} else if (obj.event === 'openSurvey') {
|
|
// 弹出问卷窗口
|
|
var url = `https://app.hc.dn8188.com/activity/00000325.html?appid=${data.AppId}&appuserid=${data.AppUserId}&id=${data.QsurveyId}`;
|
|
layer.open({
|
|
type: 2,
|
|
title: '查看问卷',
|
|
area: ['800px', '600px'],
|
|
content: url
|
|
});
|
|
}
|
|
});
|
|
|
|
var active = {
|
|
export: function () {
|
|
var where = {};
|
|
where.pageIndex = 1; // 修改为 pageIndex
|
|
where.pageSize = 99999999; // 修改为 pageSize
|
|
// 获取搜索条件
|
|
var searchParams = $('.layui-form').serializeArray();
|
|
searchParams.forEach(function (param) {
|
|
where[param.name] = param.value; // 将搜索条件添加到 where 对象中
|
|
});
|
|
console.log(where);
|
|
$.r_post('/QsurveyOrder/GetList', where, function (res) {
|
|
//console.log(res.data);
|
|
var list = res.data;
|
|
//console.log(list);
|
|
list.unshift({
|
|
SoftUsername: '用户名',
|
|
Umid: '客户ID',
|
|
Cname: '姓名',
|
|
MaskedIdCardNo: '身份证',
|
|
LastNum3: '手机号',
|
|
RegDate: '注册时间',
|
|
RiskLevel: '客户风险承受能力',
|
|
FirstTime: '首次成交时间',
|
|
LastTime: '最近交易时间',
|
|
ArrivalPay: '累计总交易金额',
|
|
EndTime: '服务到期时间',
|
|
Status: '是否可触达',
|
|
Eids: '服务人员'
|
|
});
|
|
var data = excel.filterExportData(list, ['SoftUsername', 'Umid', 'Cname', 'MaskedIdCardNo', 'LastNum3', 'RegDate', 'RiskLevel', 'FirstTime', 'LastTime', 'ArrivalPay', 'EndTime', 'Status', 'Eids']);
|
|
excel.exportExcel({ sheet1: data }, '成交客户列表.xlsx', 'xlsx');
|
|
}, "json");
|
|
}
|
|
}
|
|
|
|
|
|
$('.layui-btn').on('click', function () {
|
|
var othis = $(this), method = othis.data('method');
|
|
active[method] ? active[method].call(this, othis) : '';
|
|
});
|
|
});
|
|
</script>
|