fastadmin多个表crud连表操作步骤

1、crud命令

php think crud -t xq_user_credential  -u  1 -c credential  -i voucher_type,nickname,user_id,voucher_url,status,time  --force=true

2、修改控制器controller文件

<?phpnamespace app\admin\controller;use app\common\controller\Backend;/*** 凭证信息** @icon fa fa-circle-o*/
class Credential extends Backend
{/*** Credential模型对象* @var \app\admin\model\Credential*/protected $model = null;public function _initialize(){parent::_initialize();$this->model = new \app\admin\model\Credential;}/*** 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法* 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑* 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改*//*** 查看*/public function index(){//当前是否为关联查询$this->relationSearch = false;//设置过滤方法$this->request->filter(['strip_tags', 'trim']);if ($this->request->isAjax()) {//如果发送的来源是Selectpage，则转发到Selectpageif ($this->request->request('keyField')) {return $this->selectpage();}list($where, $sort, $order, $offset, $limit) = $this->buildparams();$where =  'a.voucher_url  IS NOT NULL'. ' AND a.voucher_url <> ""'.' AND b.nickname <> ""'.' AND b.nickname IS NOT NULL';$list = $this->model->alias('a')  // 给主表设置别名->join('xq_user_info b', 'a.user_id = b.user_id', 'left')  // 内连接->where($where)  // 添加查询条件// ->order($sort, $order)  // 排序->paginate($limit);  // 分页       foreach ($list as $row) {$row->visible(['id','voucher_type','nickname','user_id','voucher_url','status','time']);}// 获取 voucher_type 的值并显示异常或正常foreach ($list->items() as $item) {if ($item->voucher_type == 1) {$item->voucher_type="工作认证";} elseif ($item->voucher_type == 2) {$item->voucher_type="房产认证";}elseif ($item->voucher_type == 3) {$item->voucher_type="车辆信息";}elseif ($item->voucher_type == 4) {$item->voucher_type="单身承诺书";}elseif ($item->voucher_type == 5) {$item->voucher_type="诚信承诺书";}elseif ($item->voucher_type == 6) {$item->voucher_type="友好承诺书";}elseif ($item->voucher_type == 7) {$item->voucher_type="信息保密协议";}elseif ($item->voucher_type == 8) {$item->voucher_type="学历认证";}elseif ($item->voucher_type == 9) {$item->voucher_type="体检认证";}elseif ($item->voucher_type == 10) {$item->voucher_type="实名认证";}else {$item->voucher_type="其他类型";}if ($item->status == 1) {$item->status="已认证";}if ($item->status == 0) {$item->status="未认证";}}$result = array("total" => $list->total(), "rows" => $list->items());return json($result);}return $this->view->fetch();}}

其中where条件的写法

            $where =  'a.voucher_url  IS NOT NULL'. ' AND a.voucher_url <> ""'.' AND b.nickname <> ""'.' AND b.nickname IS NOT NULL';

表连接的写法

            $list = $this->model->alias('a')  // 给主表设置别名->join('xq_user_info b', 'a.user_id = b.user_id', 'left')  // 内连接->where($where)  // 添加查询条件// ->order($sort, $order)  // 排序->paginate($limit);  // 分页   

特定字段做显示处理写法

// 获取 voucher_type 的值并显示异常或正常foreach ($list->items() as $item) {if ($item->voucher_type == 1) {$item->voucher_type="工作认证";} elseif ($item->voucher_type == 2) {$item->voucher_type="房产认证";}elseif ($item->voucher_type == 3) {$item->voucher_type="车辆信息";}elseif ($item->voucher_type == 4) {$item->voucher_type="单身承诺书";}elseif ($item->voucher_type == 5) {$item->voucher_type="诚信承诺书";}elseif ($item->voucher_type == 6) {$item->voucher_type="友好承诺书";}elseif ($item->voucher_type == 7) {$item->voucher_type="信息保密协议";}elseif ($item->voucher_type == 8) {$item->voucher_type="学历认证";}elseif ($item->voucher_type == 9) {$item->voucher_type="体检认证";}elseif ($item->voucher_type == 10) {$item->voucher_type="实名认证";}else {$item->voucher_type="其他类型";}if ($item->status == 1) {$item->status="已认证";}if ($item->status == 0) {$item->status="未认证";}}

页面显示js路径
页面中修改的地方

define(['jquery', 'bootstrap', 'backend', 'table', 'form'], function ($, undefined, Backend, Table, Form) {var Controller = {index: function () {// 初始化表格参数配置Table.api.init({extend: {index_url: 'credential/index' + location.search,add_url: 'credential/add',edit_url: 'credential/edit',del_url: 'credential/del',multi_url: 'credential/multi',import_url: 'credential/import',table: 'user_credential',}});var table = $("#table");// 初始化表格table.bootstrapTable({url: $.fn.bootstrapTable.defaults.extend.index_url,pk: 'id',sortName: 'id',columns: [[{checkbox: true},{field: 'voucher_type', title: __('Voucher_type'), operate: 'LIKE', table: table, class: 'autocontent', formatter: Table.api.formatter.content},{field: 'nickname', title: __('Nickname'),operate: 'LIKE', table: table, class: 'autocontent', formatter: Table.api.formatter.content},{field: 'user_id', title: __('User_id'), operate: 'LIKE', table: table, class: 'autocontent', formatter: Table.api.formatter.content},{field: 'voucher_url', title: __('Voucher_url'), operate: 'LIKE', formatter: Table.api.formatter.url},{field: 'status', title: __('Status')},{field: 'time', title: __('Time'), operate:'RANGE', addclass:'datetimerange', autocomplete:false, formatter: Table.api.formatter.datetime},{field: 'operate', title: __('Operate'), table: table, events: Table.api.events.operate, formatter: Table.api.formatter.operate}]]});// 为表格绑定事件Table.api.bindevent(table);},add: function () {Controller.api.bindevent();},edit: function () {Controller.api.bindevent();},api: {bindevent: function () {Form.api.bindevent($("form[role=form]"));}}};return Controller;
});

其中

 {field: 'nickname', title: __('Nickname'),operate: 'LIKE', table: table, class: 'autocontent', formatter: Table.api.formatter.content},

是新加的列