// 搜索栏添加自定义搜索下拉框
//隐藏搜索栏
{field: 'manystore.nickname', title: __('店铺名称'),operate:false},
//隐藏表格字段
{field: 'manystore_pid', title: __('店铺名称'),visible: false,searchList: Config.term}, //查询店铺
$term = model('app\manystore\model\Manystore')->column('nickname', 'id');
$this->assignconfig('term', $term);
// button上获取数据库字段方法
{field: 'operate', title: __('Operate'), table: table, events: Table.api.events.operate,
buttons:[
{
name: 'addtabs',
title: '收益明细',
classname: 'btn btn-xs btn-warning btn-dialog',
extend: 'data-area=["80%","80%"]',
//icon: 'fa fa-folder-o',
text: '收益明细',
url: 'memberagentlog/index/openid/{row.openid}'
},
{
name: 'received',
title: __('修改上级'),
classname: 'btn btn-xs btn-primary btn-dialog',
extend: 'data-area=["80%","80%"]',
text: '修改上级',
url: 'memberagentrel/modify_superior/ids/{ids}',
callback: function (data) {
return false;
}
},
],formatter: Table.api.formatter.operate}
// 按钮确认/取消并请求ajax
{field: 'operate2', title: __('代理'), table: table,
events: {
'click .btn-duplicate1': function (e, value, row) {
layer.confirm('确认设为代理?', {
btn: ['确认','取消'] //按钮
}, function(){
Fast.api.ajax({
url: "member/agent/ids/" + row.id,
data: { agent: "1"},
}, function (data, ret) {
Layer.closeAll();
$(".btn-refresh").trigger("click");
});
}, function(){
layer.msg('已取消');
});
return false;
},
'click .btn-duplicate2': function (e, value, row) {
layer.confirm('确认取消代理?', {
btn: ['确认','取消'] //按钮
}, function(){
Fast.api.ajax({
url: "member/agent/ids/" + row.id,
data: { agent: "0"},
}, function (data, ret) {
Layer.closeAll();
$(".btn-refresh").trigger("click");
});
}, function(){
layer.msg('已取消');
});
return false;
}
},
buttons: [
{
name: 'success',
text: __('设为代理'),
classname: 'btn btn-xs btn-success btn-duplicate1',
visible: function (row) {
//返回true时按钮显示,返回false隐藏
if(row.agent == "0" )
return true;
else
return false;
}
},
{
name: 'default',
text: __('取消代理'),
classname: 'btn btn-xs btn-warning btn-duplicate2',
visible: function (row) {
//返回true时按钮显示,返回false隐藏
if(row.agent == "1" )
return true;
else
return false;
}
},
], formatter: Table.api.formatter.buttons}
// 按钮弹出填写备注输入框并请求ajax
{field: 'operate', title: __('Operate'), table: table,
events: {
'click .btn-duplicate1': function (e, value, row) {
Layer.prompt({
title: "请填写审核备注",
success: function (layero) {
$("input", layero).prop("placeholder", "备注");
}
}, function (value) {
Fast.api.ajax({
url: "memberquarteractivity/change/ids/" + row.id,
data: {admin_note: value, status: "1"},
}, function (data, ret) {
Layer.closeAll();
$(".btn-refresh").trigger("click");
//return false;
});
});
return false;
},
'click .btn-duplicate2': function (e, value, row) {
Layer.prompt({
title: "请填写审核备注",
success: function (layero) {
$("input", layero).prop("placeholder", "备注");
}
}, function (value) {
Fast.api.ajax({
url: "memberquarteractivity/change/ids/" + row.id,
data: {admin_note: value, status: "2"},
}, function (data, ret) {
Layer.closeAll();
$(".btn-refresh").trigger("click");
//return false;
});
});
return false;
}
},
buttons: [
{
name: 'success',
text: __('通过'),
classname: 'btn btn-xs btn-success btn-duplicate1',
icon: 'fa fa-copy',
visible: function (row) {
//返回true时按钮显示,返回false隐藏
if(row.status == "0" )
return true;
else
return false;
}
},
{
name: 'default',
text: __('失败'),
classname: 'btn btn-xs btn-warning btn-duplicate2',
icon: 'fa fa-copy',
visible: function (row) {
//返回true时按钮显示,返回false隐藏
if(row.status == "0" )
return true;
else
return false;
}
},
], formatter: Table.api.formatter.buttons}
// 控制器里自定义搜索条件
{field: 'header_img', title: __('Header_img'),searchList: {"1":"已授权"},formatter:Table.api.formatter.image}
$filter = json_decode($this->request->get('filter'),1);
$op = json_decode($this->request->get('op'),1);
$header_img = "";
if (is_array($filter)) {
foreach ($filter as $key => $value) {
if($key == 'header_img'){
$header_img = $value;
}
}
}
if(!empty($header_img)){
$filter['header_img'] = "";
$op['header_img'] = '<>';
$this->request->get(['filter'=>json_encode($filter),'op'=>json_encode($op)]);
}
// 使用area表 省市区联动 保存的是id
<div class="form-group">
<label class="control-label col-xs-12 col-sm-2">{:__('位置')}:</label>
<div class="form-inline" data-toggle="cxselect" data-selects="province,city,area">
<select class="province form-control" name="row[province]" data-url="ajax/area">
<option value="{$row.province?$row['province']:1168}" selected="">{$row.province_text?$row['province_text']:'福建省'}</option>
</select>
<select class="city form-control" name="row[city]" data-url="ajax/area">
<option value="{$row.city?$row['city']:1183}" selected="">{$row.city_text?$row['city_text']:'厦门市'}</option>
</select>
<select class="area form-control" name="row[district]" data-url="ajax/area">
<option value="{$row.district?$row['district']:1184}" selected="">{$row.district_text?$row['district_text']:'思明区'}</option>
</select>
</div>
</div>
// 数据导出(跳转页面导出)
var submitForm = function (ids, layero) {
var options = table.bootstrapTable('getOptions');
$("input[name=ids]", layero).val(ids);
$("form", layero).submit();
};
$(document).on("click", ".btn-export", function () {
var ids = Table.api.selectedids(table);
var page = table.bootstrapTable('getData');
var all = table.bootstrapTable('getOptions').totalRows;
console.log(ids, page, all);
Layer.confirm("请选择导出的选项<form action='" + Fast.api.fixurl("member/export") + "' method='post' target='_blank'><input type='hidden' name='ids' value='' /></form>", {
title: '导出数据',
btn: ["选中项(" + ids.length + "条)", "本页(" + page.length + "条)","全部("+all+")"],
success: function (layero, index) {
$(".layui-layer-btn a", layero).addClass("layui-layer-btn0");
}
, yes: function (index, layero) {
submitForm(ids.join(","), layero);
return false;
}
,
btn2: function (index, layero) {
var ids = [];
$.each(page, function (i, j) {
ids.push(j.id);
});
submitForm(ids.join(","), layero);
return false;
}
,
btn3: function (index, layero) {
submitForm("all", layero);
return false;
}
})
});
// 查看报名列表记录
//php
$demand_id = input('demand_id');
$this->assignconfig('demand_id', $demand_id);
//js
table.bootstrapTable({
url: $.fn.bootstrapTable.defaults.extend.index_url,
pk: 'id',
sortName: 'id',
columns: [
[
{checkbox: true},
{field: 'id', title: __('Id')}
]
],
queryParams: function (params) {
//这里可以追加搜索条件
var filter = JSON.parse(params.filter);
var op = JSON.parse(params.op);
//这里可以动态赋值,比如从URL中获取admin_id的值,filter.admin_id=Fast.api.query('admin_id');
console.log(Config.demand_id);
if(Config.demand_id != null)
{
filter.demand_id = Config.demand_id; // 设置值,type为字段名
op.demand_id = "="; // 设置条件
params.filter = JSON.stringify(filter);
params.op = JSON.stringify(op);
}
return params;
},
});
// 点击查看大图
table.on('post-body.bs.table', function (e, settings, json, xhr) {
$(".btn-editone", this)
.off("click")
.removeClass("btn-editone")
.addClass("btn-addtabs")
.prop("title", __('Edit'));
// 预览图弹出处理
$('img').parent('a').attr('href','javascript:;');//去掉图片oss连接地址
$('img').bind('click',function(){
var imgs = $(this).parents('td').find('a img');
var dataJson = [],item={};
for (var i = 0; i < imgs.length; i++) {
item['alt'] = '';
item['pid'] = Math.random()*10;
item['src'] = item['thumb'] = $(imgs[i]).attr('src');
dataJson.push(item);
item = {}; // 重置
}
var json = {
"title": "", //相册标题
"id": 123, //相册id
"start": 0, //初始显示的图片序号,默认0
"data": dataJson
};
Layer.photos({
photos: json,
anim: 0 //0-6的选择,指定弹出图片动画类型,默认随机(请注意,3.0之前的版本用shift参数)
});
})
});
//重构字段显示的值