如何仅在满足数据库列条件时在datatables列按钮下拉菜单中显示链接

Question

如果新用户至少未登录应用程序一次，我试图在datatables按钮下拉菜单中隐藏“重新发送欢迎”链接。我的users表上有一个“login\u count”列，默认为零。一旦用户登录到他们的帐户，它会增加他们每签入一次的次数。我正在尝试向datatables按钮刀片添加if_语句，但似乎无法构造正确使用$row的语句-

我试图构建if语句，如果“login_count”等于零，则显示链接，否则隐藏链接。我的问题是，我似乎找不到正确的方法将if语句与数据库行id连接起来。（我还有一个默认为null的“last_login_at”日期列，如果出于某种原因，最好将条件构建在null选项而不是count等于零选项的日期上）

我的按钮动作。刀片：

@can($gateKey.'view')
    <div class="pull-right" style="white-space: nowrap; min-width: 80px;"><div class="btn-group" style="white-space: nowrap;">
            <a href="{{ route($routeKey.'.show', $row->id) }}" class="btn btn-sm btn-default">@lang('global.app_view')</a>
            <a class="btn btn-default btn-sm dropdown-toggle" data-toggle="dropdown" href="#">
                <span class="caret"></span>
            </a><ul class="dropdown-menu pull-right">

{{-- This is the Link I want to build the if-statement around    --}}
                <li><a href="{{route('admin.users.resend_welcome',$row->id)}}" >@lang('global.app_resend_welcome_letter')</a></li>

            @if(auth()->user()->role->contains(1))
                    <li><a href="{{route('admin.impersonate.impersonate',$row->id)}}" >@lang('global.app_troubleshoot_user')</a></li>
                @endif
                @can($gateKey.'edit')
                    <li><a href="{{ route($routeKey.'.edit', $row->id) }}">@lang('global.app_edit')</a></li>
                @endcan
                @can($gateKey.'delete')
                    <li>
                        {!! Form::open(array(
                                'style' => 'display: inline-block;',
                                'method' => 'DELETE',
                                'onsubmit' => "return confirm('".trans("global.app_are_you_sure_delete")."');",
                                'route' => [$routeKey.'.destroy', $row->id])) !!}
                        {!! Form::submit(trans('global.app_delete'), array('class' => 'btn btn-link')) !!}
                        {!! Form::close() !!}
                    </li>
                @endcan

            </ul>
        </div>
    </div>
@endcan

这是我index.blade的Ajax数据表部分：

<script>
        @can('user_delete')
                @if ( request('show_deleted') != 1 )window.route_mass_crud_entries_destroy = '{{ route('admin.users.mass_destroy') }}'; @endif
        @endcan
        $(document).ready(function () {
            window.dtDefaultOptions.ajax = '{!! route('admin.users.index') !!}?show_deleted={{ request('show_deleted') }}';
            window.dtDefaultOptions.stateSave = true;
            //window.dtDefaultOptions.scrollY = '50vh';
            window.dtDefaultOptions.scrollCollapse = true;
            window.dtDefaultOptions.columns = [@can('user_delete')
                @if ( request('show_deleted') != 1 )
            {data: 'massDelete', name: 'id', searchable: false, sortable: false},
                @endif
                    @endcan{data: 'name', name: 'name'},
                {data: 'email', name: 'email'},
                {data: 'phone', name: 'phone'},
                {data: 'role.title', name: 'role.title'},
                    @if(auth()->user()->role->contains(1))
                {data: 'team.name', name: 'team.name'},
                    @endif
                {data: 'last_login_at', name: 'last_login_at'},
                {data: 'login_count', name: 'login_count'},

//This is where the Button action ties into the datatables table
                {data: 'actions', name: 'actions', searchable: false, sortable: false}
            ];
            processAjaxTables();
        });
    </script>

这是我要求的控制器：

public function index()
    {
        if (! Gate::allows('user_access')) {
            return abort(401, 'Sorry you are not authorized for this action at this time');
        }
        if ($filterBy = Input::get('filter')) {
            if ($filterBy == 'all') {
                Session::put('User.filter', 'all');
            } elseif ($filterBy == 'my') {
                Session::put('User.filter', 'my');
            }
        }


        if (request()->ajax()) {
            $query = User::query();
            $query->with("role");
            $query->with("team");
            $query->with("created_by");
            $query->with("created_by_team");
            $template = 'usersActionsTemplate';
            if(request('show_deleted') == 1) {

                if (!Gate::allows('interest_delete')) {
                    return abort(401, 'Sorry you are not authorized for this action at this time');
                }
                $query->onlyTrashed();
                $template = 'restoreTemplate';
            }


            $query->select([
                'users.id',
                'users.name',
                'users.email',
                'users.phone',
                'users.password',
                'users.team_id',
                'users.remember_token',
//                'users.created_by_id',
                'users.last_login_at',
                'users.login_count',
//                'users.created_by_team_id',
            ]);
            $table = Datatables::of($query);

            $table->setRowAttr([
                'data-entry-id' => '{{$id}}',
            ]);
            $table->addColumn('massDelete', ' ');
            $table->addColumn('actions', ' ');
            $table->editColumn('actions', function ($row) use ($template) {
                $gateKey  = 'user_';
                $routeKey = 'admin.users';

                return view($template, compact('row', 'gateKey', 'routeKey'));
            });
            $table->editColumn('phone', function ($row) {
                return $row->phone ? $row->phone : '';
            });
            $table->editColumn('password', function ($row) {
                return '---';
            });
            $table->editColumn('role.title', function ($row) {
                if(count($row->role) == 0) {
                    return '';
                }

                return '<span class="label label-default label-many">' . implode('</span><span class="label label-info label-many"> ',
                        $row->role->pluck('title')->toArray()) . '</span>';
            });
            $table->editColumn('team.name', function ($row) {
                return $row->team ? $row->team->name : '';
            });
            $table->editColumn('remember_token', function ($row) {
                return $row->remember_token ? $row->remember_token : '';
            });
            $table->editColumn('last_login_at', function ($row) {
                return $row->last_login_at ? $row->last_login_at : '';
            });
            $table->editColumn('login_count', function ($row) {
                return $row->login_count ? $row->login_count : '';
            });
//            $table->editColumn('created_by.name', function ($row) {
//                return $row->created_by ? $row->created_by->name : '';
//            });
//            $table->editColumn('created_by_team.name', function ($row) {
//                return $row->created_by_team ? $row->created_by_team->name : '';
//            });

            $table->rawColumns(['actions','massDelete','role.title']);

            return $table->make(true);
        }

        return view('admin.users.index');

我可以通过角色或活动用户来调节此按钮链接，但无论出于何种原因，我似乎无法找到一种基于数据库$row来调节此链接的方法-

有什么想法吗？

系统说这个评论是长时间添加在评论部分，所以我会把它添加到帖子中。

什么@if（Auth:：user（））-

我需要它，以便在所有不同用户的表索引列表中，过去登录过的用户不会在其行按钮下拉菜单中显示链接，但任何从未登录过的用户都会在其行按钮下拉菜单中看到“重新发送欢迎”链接。




Answer 1

只需更改视图文件，添加条件。就像

@if($row->login_count < 1)

    <li><a href="{{route('admin.users.resend_welcome',$row->id)}}" >@lang('global.app_resend_welcome_letter')</a></li>

@endif