fastadmin例子

例子"/>

fastadmin例子

文章目录

• 自定义操作按钮调用页面显示
• 自定义操作按钮ajax处理
• 自定义表格头部按钮
• 离店按钮点击弹出提示
• fastadmin 使用token
• url跳转菜单管理
• 数据权限(各管理员查看自己数据)
• 开关按钮权限
• 多规格二维数组json存储
• 自定义页面显示数据表格
• 自定义搜索栏operate: false 隐藏
• 搜索

自定义操作按钮调用页面显示

buttons: [{name: 'add', //唯一标识、权限标识dropdown: '', //按钮下拉分组，默认为不分组text: '同意', //按钮显示的文字，支持functiontitle: '我是标题', //按钮显示的文字，支持functionclassname: 'btn btn-info btn-xs btn-dialog', //按钮的class，支持btn-dialog/btn-ajax/btn-addtabsicon: 'fa fa-plus', //按钮的图标url: 'department/index/add/parent_id/{ids}', //按钮的链接，支持使用{字段名}来占位替换，支持`function`confirm: '是否同意该请求？', //点击按钮后的确认框，支持`function`refresh: true, //操作完成后是否刷新列表disable: function(row){}, //判断按钮是否禁用visible: function(row){}, //判断按钮是否可见hidden: function(row){}, //判断按钮是否隐藏extend: '', //扩展的扩展属性},{name: 'unsettled',title: __('结算'),text:'结算',classname: 'btn btn-xs btn-success btn-magic btn-ajax settltAccount',icon: 'fa fa-magic',hidden: function(row){return row.status == 1;},url: 'product/detaillist/settleAccounts?pid={ProID}&earningtoday={earningToday}&sycy={yieldBrokeRage}',confirm:'是否结算?',success: function (data, ret) {table.bootstrapTable('refresh');//表格刷新},},
]

user.php

	//如果提示无权限加入方法名protected $noNeedLogin = ['*'];protected $noNeedRight = ['tongji'];/*** 编辑*/public function tongji($ids = null){if ($this->request->isPost()) {$this->token();}$jtqz = mktime(0,0,0,date('m'),date('d'),date('Y')) - 864000;$list = Db::name('tongji')->where('user_id',$ids)->where('createtime','>',$jtqz)->select();$this->view->assign('ids',$ids);$this->view->assign('list',$list);return $this->view->fetch();}/*** 编辑*/public function tongji2($ids = null){$riqi = $this->request->param('riqi');$info = Db::name('tongji')->where('user_id',$ids)->where('riqi','LIKE','%'.$riqi.'%')->find();return json_encode($info);}

需要显示的tongji.html
在FastAdmin中的日期时间组件采用的是Bootstrap-datetimepicker插件
我们在使用时可以为文本框添加一个class为datetimepicker的值即可自动添加日期时间选择框。

<form id="edit-form" class="form-horizontal" role="form" data-toggle="validator" method="POST" action="">{:token()}<div class="form-group"><label for="riqi" class="control-label col-xs-12 col-sm-2">查询日期:</label><div class="col-xs-12 col-sm-8"><input id="riqi" style="width:200px;float:left;" class="form-control datetimepicker" data-date-format="YYYY-MM-DD" name="riqi" type="text" value=""><button id="chaxun" style="float:left;margin-left: 30px;" type="button" class="btn btn-primary btn-embossed disabled">查询</button></div></div><table style="width: 100%;border: 1px solid #666666;font-size: 15px;"><tr style="height: 50px;border: 1px solid #666666;"><td style="text-align: center;width:25%;border: 1px solid #666666;">日期</td><td style="text-align: center;width:25%;border: 1px solid #666666;">接单数</td><td style="text-align: center;width:25%;border: 1px solid #666666;">完成数</td><td style="text-align: center;width:25%;border: 1px solid #666666;">取消数</td></tr></table><table id="listtable" style="width: 100%;border: 1px solid #666666;font-size: 15px;">{foreach name="list" item="vo"}<tr style="height: 50px;border: 1px solid #666666;"><td style="text-align: center;width:25%;border: 1px solid #666666;">{$vo.riqi}</td><td style="text-align: center;width:25%;border: 1px solid #666666;">{$vo.jds}</td><td style="text-align: center;width:25%;border: 1px solid #666666;">{$vo.wcs}</td><td style="text-align: center;width:25%;border: 1px solid #666666;">{$vo.qxs}</td></tr>{/foreach}</table><input type="hidden" id="ids" name="ids" value="{$ids}">
</form>

user.js

{field: 'operate', title: __('Operate'), table: table, events: Table.api.events.operate,buttons: [{name: 'detail',text: __('查看'),icon: 'fa fa-list',classname: 'btn btn-info btn-xs btn-detail btn-dialog',url: 'user/user/tongji/ids/{ids}?'},],formatter: Table.api.formatter.operate}

绑定事件,回调显示页面内容

tongji: function () {$("#chaxun").on("click",function(e){let riqi = $("#riqi").val();let ids = $("#ids").val();$.ajax({url:"/OruSMPRoBw.php/user/user/tongji2/" , // 请求路径type:"POST" , //请求方式//data: "username=jack&age=23",//请求参数data:{"riqi":riqi,"ids":ids,},success:function (res) {var data = JSON.parse(res);const array = JSON.parse(data);$('#listtable').html('');var td1="<td style=\"text-align: center;width:25%;border: 1px solid #666666;\">"+array.riqi+"</td>";var td2="<td style=\"text-align: center;width:25%;border: 1px solid #666666;\">"+array.jds+"</td>";var td3="<td style=\"text-align: center;width:25%;border: 1px solid #666666;\">"+array.wcs+"</td>";var td4="<td style=\"text-align: center;width:25%;border: 1px solid #666666;\">"+array.qxs+"</td>";var trString="<tr style=\"height: 50px;border: 1px solid #666666;\">"+td1+td2+td3+td4+"</tr>";$("#listtable").append(trString);//console.log(array.id);},//响应成功后的回调函数error:function () {parent.Toastr.success('查询失败');},//表示如果请求响应出现错误，会执行的回调函数dataType:"text"//设置接受到的响应数据的格式});});Controller.api.bindevent();},

自定义操作按钮ajax处理

{field: 'operate', title: __('Operate'), table: table, events: Table.api.events.operate, formatter: Table.api.formatter.operate,buttons:[{name:'clearLocation',text:'清除经纬度',title:'清除经纬度',classname: 'btn btn-xs btn-info btn-view btn-ajax',icon: 'fa fa-arrow-up',url: 'resource/clearLocation',refresh:true,callback: function (data) {Layer.alert("接收到回传数据：" + JSON.stringify(data), {title: "回传数据"});}}]}

public  function  clearLocation($ids = null){$row = $this->model->get($ids);Db::name("resource")->where("id",$row['id'])->update(["longitude"=>null,"latitude"=>null,"province"=>null,"city"=>null,"district"=>null,]);$this->success("清除成功！");}

自定义表格头部按钮

index.html加入按钮

js中加入点击事件

$("#processing").on("click",function (){var ids = Table.api.selectedids(table);//获取idFast.api.ajax({url:'resource/processing',data: {ids: ids.join(",")}}, function(data, res){//成功的回调layer.msg(res.msg);var table = $("#table");var opt = {url: ''};//刷新table表单table.bootstrapTable('refresh', opt);return false;}, function(data, ret){//失败的回调alert(ret);return false;});
});

resource.php

/*** 处理经纬度* @return void*/public function processing(){$list = Db::name("resource")->where("deletetime",'null')->where("longitude",'null')->where("latitude",'null')->select();foreach ($list as  &$value){$res = file_get_contents("={$value['address']}&output=JSON&key=5190f5b8dd715bfe4ba30fc4f4b6926e");$result = json_decode($res,true);if($result['info']=='OK'){$jwd_array = explode(',',$result['geocodes'][0]['location']);Db::name("resource")->where("id",$value['id'])->update(["longitude"=>$jwd_array[0],"latitude"=>$jwd_array[1],"province"=>$result['geocodes'][0]['province'],"city"=>$result['geocodes'][0]['city'],"district"=>$result['geocodes'][0]['district']]);}}$this->success("处理完成！");}

离店按钮点击弹出提示

//离店按钮$(document).on("click", ".btn-pause", function () {//在table外不可以使用添加.btn-change的方法//只能自己调用Table.api.multi实现//如果操作全部则ids可以置为空var ids = Table.api.selectedids(table);console.log(ids);Fast.api.ajax({url: "roomorder/getBjfy",data: {ids: ids}}, function (res,data) {console.log(data);Layer.confirm(__('需补缴'+data.data+'元,点击确定完成客房离店?'), {icon: 3,title: '提示'}, function (index) {// Table.api.start("changestatus", ids.join(","), table, this);// Layer.close(index);Backend.api.ajax({url: "roomorder/pause",data: {ids: ids.join(",")}}, function (res) {console.log(res.data);});Layer.close(index);});});});

fastadmin 使用token

url跳转菜单管理

.php/auth/rule?ref=addtabs

数据权限(各管理员查看自己数据)

	protected $dataLimit = 'auth';protected $dataLimitField = 'company_id';

开关按钮权限

加入 protected $multiFields = ‘你设计数据库的开关字段’;

protected $multiFields = ['status_switch','zg_switch'];

多规格二维数组json存储

add.html

 <div class="form-group"><label class="control-label col-xs-12 col-sm-2" >{:__('Jieguo')}:</label><div class="col-xs-12 col-sm-8"><dl class="fieldlist" data-name="row[jieguo]" data-template="testtpl"><dd style="border-bottom: 1px solid #f4f4f4;border-top: 1px solid #f4f4f4;height:33px"><ins style="width:15%">列1</ins><ins style="width:6%"> </ins><ins style="width:15%">列2</ins><ins style="width:6%"> </ins><ins style="width:15%">列3</ins><ins style="width:6%"> </ins><ins style="width:15%">列4</ins><ins style="width:6%"> </ins></dd><dd><a href="javascript:;" class="btn btn-sm btn-success btn-append"><i class="fa fa-plus"></i> 追加</a></dd><textarea name="row[jieguo]" class="form-control hide" cols="30" rows="4"></textarea></dl></div></div><!--定义模板，模板语法使用Art-Template模板语法--><script type="text/html" id="testtpl"><dd class="form-inline"><input type="text" name="row[<%=jieguo%>][<%=index%>][a]" class="form-control" value=""  style="width:15%"><input type="hidden" name="row[<%=jieguo%>][<%=index%>][as]" id="c-as-<%=index%>" class="form-control" style="width:6%" value="0" placeholder="状态"/><a href="javascript:;" data-toggle="switcher" class="btn-switcher" data-input-id="c-as-<%=index%>" data-yes="1" data-no="0" ><i class="fa fa-toggle-on text-success fa-flip-horizontal text-gray fa-2x"></i></a><input type="text" name="row[<%=jieguo%>][<%=index%>][b]" class="form-control" value="" style="width:15%"><input type="hidden" name="row[<%=jieguo%>][<%=index%>][bs]" id="c-bs-<%=index%>" class="form-control" style="width:6%" value="0" placeholder="状态"/><a href="javascript:;" data-toggle="switcher" class="btn-switcher" data-input-id="c-bs-<%=index%>" data-yes="1" data-no="0" ><i class="fa fa-toggle-on text-success fa-flip-horizontal text-gray fa-2x"></i></a><input type="text" name="row[<%=jieguo%>][<%=index%>][c]" class="form-control" value="" style="width:15%"><input type="hidden" name="row[<%=jieguo%>][<%=index%>][cs]" id="c-cs-<%=index%>" class="form-control" style="width:6%" value="0" placeholder="状态"/><a href="javascript:;" data-toggle="switcher" class="btn-switcher" data-input-id="c-cs-<%=index%>" data-yes="1" data-no="0" ><i class="fa fa-toggle-on text-success fa-flip-horizontal text-gray fa-2x"></i></a><input type="text" name="row[<%=jieguo%>][<%=index%>][d]" class="form-control" value="" style="width:15%"><input type="hidden" name="row[<%=jieguo%>][<%=index%>][ds]" id="c-ds-<%=index%>" class="form-control" style="width:6%" value="0" placeholder="状态"/><a href="javascript:;" data-toggle="switcher" class="btn-switcher" data-input-id="c-ds-<%=index%>" data-yes="1" data-no="0" ><i class="fa fa-toggle-on text-success fa-flip-horizontal text-gray fa-2x"></i></a><span class="btn btn-sm btn-danger btn-remove"><i class="fa fa-times"></i></span>
<!--            <span class="btn btn-sm btn-primary btn-dragsort"><i class="fa fa-arrows"></i></span>--></dd></script>

edit.html

 <div class="form-group"><label class="control-label col-xs-12 col-sm-2" >{:__('Jieguo')}:</label><div class="col-xs-12 col-sm-8"><dl class="fieldlist" data-name="row[jieguo]" data-template="testtpl"><dd style="border-bottom: 1px solid #f4f4f4;border-top: 1px solid #f4f4f4;height:33px"><ins style="width:15%">列1</ins><ins style="width:6%"> </ins><ins style="width:15%">列2</ins><ins style="width:6%"> </ins><ins style="width:15%">列3</ins><ins style="width:6%"> </ins><ins style="width:15%">列4</ins><ins style="width:6%"> </ins></dd><dd><a href="javascript:;" class="btn btn-sm btn-success btn-append"><i class="fa fa-plus"></i> 追加</a></dd><textarea name="row[jieguo]" class="form-control hide" cols="30" rows="4">{$row.jieguo|htmlentities}</textarea></dl></div></div><!--定义模板，模板语法使用Art-Template模板语法--><script type="text/html" id="testtpl"><dd class="form-inline"><input type="text" name="row[<%=jieguo%>][<%=index%>][a]" class="form-control" value="<%=row['a']%>"  style="width:15%"><input type="hidden" name="row[<%=jieguo%>][<%=index%>][as]" id="c-as-<%=index%>" class="form-control" style="width:6%" value="<%=row['as']%>" placeholder="状态"/><a href="javascript:;" data-toggle="switcher" class="btn-switcher" data-input-id="c-as-<%=index%>" data-yes="1" data-no="0" ><i class="fa fa-toggle-on text-success <%if(row.as==0){%>fa-flip-horizontal text-gray<%}%> fa-2x"></i></a><input type="text" name="row[<%=jieguo%>][<%=index%>][b]" class="form-control" value="<%=row['b']%>" style="width:15%"><input type="hidden" name="row[<%=jieguo%>][<%=index%>][bs]" id="c-bs-<%=index%>" class="form-control" style="width:6%" value="<%=row['bs']%>" placeholder="状态"/><a href="javascript:;" data-toggle="switcher" class="btn-switcher" data-input-id="c-bs-<%=index%>" data-yes="1" data-no="0" ><i class="fa fa-toggle-on text-success <%if(row.bs==0){%>fa-flip-horizontal text-gray<%}%> fa-2x"></i></a><input type="text" name="row[<%=jieguo%>][<%=index%>][c]" class="form-control" value="<%=row['c']%>" style="width:15%"><input type="hidden" name="row[<%=jieguo%>][<%=index%>][cs]" id="c-cs-<%=index%>" class="form-control" style="width:6%" value="<%=row['cs']%>" placeholder="状态"/><a href="javascript:;" data-toggle="switcher" class="btn-switcher" data-input-id="c-cs-<%=index%>" data-yes="1" data-no="0" ><i class="fa fa-toggle-on text-success <%if(row.cs==0){%>fa-flip-horizontal text-gray<%}%> fa-2x"></i></a><input type="text" name="row[<%=jieguo%>][<%=index%>][d]" class="form-control" value="<%=row['d']%>" style="width:15%"><input type="hidden" name="row[<%=jieguo%>][<%=index%>][ds]" id="c-ds-<%=index%>" class="form-control" style="width:6%" value="<%=row['ds']%>" placeholder="状态"/><a href="javascript:;" data-toggle="switcher" class="btn-switcher" data-input-id="c-ds-<%=index%>" data-yes="1" data-no="0" ><i class="fa fa-toggle-on text-success <%if(row.ds==0){%>fa-flip-horizontal text-gray<%}%> fa-2x"></i></a><span class="btn btn-sm btn-danger btn-remove"><i class="fa fa-times"></i></span>
<!--            <span class="btn btn-sm btn-primary btn-dragsort"><i class="fa fa-arrows"></i></span>--></dd></script>

自定义页面显示数据表格

 //出车里程public function chuchelicheng(){if ($this->request->isPost()) {$this->token();}$userlist = Db::name('user')->where('group_id',2)->field('nickname')->select();$newlist = array();$asum = 0;$bsum = 0;for($i=0;$i<count($userlist);$i++){$userlist[$i]['a'] = Db::name('driver')->where(['informant'=>$userlist[$i]['nickname'],'property'=>'120'])->sum('mileage');$userlist[$i]['b'] = Db::name('driver')->where(['informant'=>$userlist[$i]['nickname'],'property'=>'转诊'])->sum('mileage');$userlist[$i]['sum'] = bcadd($userlist[$i]['a'],$userlist[$i]['b']);if($userlist[$i]['a']>0 || $userlist[$i]['b']>0){$asum = bcadd($asum,$userlist[$i]['a']);$bsum = bcadd($bsum,$userlist[$i]['b']);$newlist[] = $userlist[$i];}}$heji = bcadd($asum,$bsum);$this->view->assign('list',$newlist);$this->view->assign('asum',$asum);$this->view->assign('bsum',$bsum);$this->view->assign('heji',$heji);return $this->view->fetch();}public function chuchelichengAjax(){$start_riqi = $this->request->post("start_riqi");$end_riqi = $this->request->post("end_riqi");$start_where = [];$where = [];if(!empty($start_riqi)){$start_riqi = strtotime($start_riqi);$start_where['daytime'] = ['>=',$start_riqi];}if(!empty($end_riqi)){$end_riqi = strtotime($end_riqi);$where['daytime'] = ['<=',$end_riqi];}$userlist = Db::name('user')->where('group_id',2)->field('nickname')->select();$newlist = array();$asum = 0;$bsum = 0;for($i=0;$i<count($userlist);$i++){$userlist[$i]['a'] = Db::name('driver')->where($start_where)->where($where)->where(['informant'=>$userlist[$i]['nickname'],'property'=>'120'])->sum('mileage');$userlist[$i]['b'] = Db::name('driver')->where($start_where)->where($where)->where(['informant'=>$userlist[$i]['nickname'],'property'=>'转诊'])->sum('mileage');$userlist[$i]['sum'] = bcadd($userlist[$i]['a'],$userlist[$i]['b']);if($userlist[$i]['a']>0 || $userlist[$i]['b']>0){$asum = bcadd($asum,$userlist[$i]['a']);$bsum = bcadd($bsum,$userlist[$i]['b']);$newlist[] = $userlist[$i];}}$heji = bcadd($asum,$bsum);$info = ['userlist'=>$newlist,'asum'=>$asum,'bsum'=>$bsum,'heji'=>$heji];//        $this->success('查询成功',null,$info);//  $this->result($info,200,'查询成功');return $info;}

js文件

chuchelicheng: function () {$("#chaxun").on("click",function(e){let start_riqi = $("#start_riqi").val();let end_riqi = $("#end_riqi").val();$.ajax({url:"/bqUtnCpgRw.php/driver/chuchelichengAjax/" , // 请求路径type:"POST" , //请求方式//data: "username=jack&age=23",//请求参数data:{"start_riqi":start_riqi,"end_riqi":end_riqi,},success:function (res) {//  console.log(res);var data = JSON.parse(res);console.log(data.userlist);// const array = JSON.parse(data);//$('#listtable').html('');for(var i = 0; i < data.userlist.length; i++) {var td1="<td style=\"text-align: center;width:16%;border: 1px solid #666666;\">"+data.userlist[i].nickname+"</td>";var td2="<td style=\"text-align: center;width:16%;border: 1px solid #666666;\">"+data.userlist[i].a+"</td>";var td3="<td style=\"text-align: center;width:16%;border: 1px solid #666666;\">"+data.userlist[i].b+"</td>";var td4="<td style=\"text-align: center;width:16%;border: 1px solid #666666;\">"+data.userlist[i].sum+"</td>";var trString="<tr style=\"height: 50px;border: 1px solid #666666;\">"+td1+td2+td3+td4+"</tr>";$("#listtable").append(trString);}var td1="<td style=\"text-align: center;width:16%;border: 1px solid #666666;\">总计</td>";var td2="<td style=\"text-align: center;width:16%;border: 1px solid #666666;\"><b>"+data.asum+"</b></td>";var td3="<td style=\"text-align: center;width:16%;border: 1px solid #666666;\"><b>"+data.bsum+"</b></td>";var td4="<td style=\"text-align: center;width:16%;border: 1px solid #666666;\"><b>"+data.heji+"</b></td>";var trString="<tr style=\"height: 50px;border: 1px solid #666666;\">"+td1+td2+td3+td4+"</tr>";$("#listtable").append(trString);parent.Toastr.success('查询成功');//Toastr.info('查询成功');////console.log(array.id);},//响应成功后的回调函数error:function () {parent.Toastr.success('查询失败');},//表示如果请求响应出现错误，会执行的回调函数dataType:"text"//设置接受到的响应数据的格式});});Controller.api.bindevent();},

<div style="width:80%;margin-left: 10%;margin-top: 30px;">
<form id="edit-form" class="form-horizontal" role="form" data-toggle="validator" method="POST" action=""><div class="form-group"><label  class="control-label col-xs-12 col-sm-2" style="font-size: 17px;">查询日期范围:</label><div class="col-xs-5 col-sm-2"><input id="start_riqi"  style="width:200px;float:left;" class="form-control datetimepicker" data-date-format="YYYY-MM-DD" name="start_riqi" type="text" value=""></div><!--            <div class="col-xs-5 col-sm-1" style="text-align: center">&#45;&#45;-->
<!--            </div>--><div class="col-xs-5 col-sm-2"><input id="end_riqi" style="width:200px;float:left;" class="form-control datetimepicker" data-date-format="YYYY-MM-DD" name="end_riqi" type="text" value=""></div><div class="col-xs-5 col-sm-2"><button id="chaxun" style="float:left;margin-left: 30px;" type="button" class="btn btn-primary btn-embossed">查询</button></div></div><table style="width: 100%;border: 1px solid #666666;font-size: 15px;"><tr style="height: 50px;border: 1px solid #666666;background-color:#DCE6F1;"><td style="text-align: center;width:16%;border: 1px solid #666666;font-size: 17px;"><b>上报人</b></td><td style="text-align: center;width:16%;border: 1px solid #666666;font-size: 17px;"><b>120</b></td>
<!--            <td style="text-align: center;width:16%;border: 1px solid #666666;font-size: 17px;"><b></b></td>--><td style="text-align: center;width:16%;border: 1px solid #666666;font-size: 17px;"><b>转诊</b></td><td style="text-align: center;width:16%;border: 1px solid #666666;font-size: 17px;"><b>总计</b></td></tr></table><table id="listtable" style="width: 100%;border: 1px solid #666666;font-size: 15px;">{foreach name="list" item="vo"}<tr style="height: 50px;border: 1px solid #666666;"><td style="text-align: center;width:16%;border: 1px solid #666666;">{$vo.nickname}</td><td style="text-align: center;width:16%;border: 1px solid #666666;">{$vo.a}</td>
<!--            <td style="text-align: center;width:16%;border: 1px solid #666666;">{$vo.b}</td>--><td style="text-align: center;width:16%;border: 1px solid #666666;">{$vo.b}</td><td style="text-align: center;width:16%;border: 1px solid #666666;">{$vo.sum}</td></tr>{/foreach}<tr style="height: 50px;border: 1px solid #666666;background-color:#DCE6F1; "><td style="text-align: center;width:16%;border: 1px solid #666666;font-size: 17px;"><b>总计</b></td><td style="text-align: center;width:16%;border: 1px solid #666666;font-size: 17px;"><b>{$asum}</b></td>
<!--            <td style="text-align: center;width:16%;border: 1px solid #666666;font-size: 17px;"><b>{$bsum}</b></td>--><td style="text-align: center;width:16%;border: 1px solid #666666;font-size: 17px;"><b>{$bsum}</b></td><td style="text-align: center;width:16%;border: 1px solid #666666;font-size: 17px;"><b>{$heji}</b></td></tr></table>
</form>
</div>

自定义搜索栏operate: false 隐藏

search:false,
commonSearch:true,
searchFormVisible:true,

搜索

    protected $relationSearch = true;protected $searchFields = ['order.status'];