<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Firm extends Model
{
use HasFactory;
// 追加字段 , 显示按钮
protected $appends = ['operate'];
// 访问器
public function getOperateAttribute()
{
$id = $this->id;
return "<a href='http://www.king.com/index.php/select?id=$id'>查看</a>"."<a href='http://www.king.com/index.php/update?id=$id'>修改</a>"."<a href='http://www.king.com/index.php/delete?id=$id'>删除</a>";
}
}
// 页面datetables中的显示字段方法
columns方法中写入这个按钮的字段
$('#table_id_example').DataTable({
aaSorting: [[0, "desc"]],//默认第几个排序
bStateSave: true,//状态保存
// 分页显示
lengthMenu: ['10', '25', '50', '75', '100'],
// 不参与排序的列
aoColumnDefs: [
{orderable: false, aTargets: [1, 2, 3, 4, 5, 6, 7, 8, 9,]}
],
// 开启服务段分页
serverSide: true,
// Ajax发送请求
ajax: ({
url: "{{ url('index') }}",
type: 'get'
}),
// 指定每一列显示的数据
columns: [
{data: 'id'},
{data: 'firm_name'},
{data: 'organization_code'},
{data: 'firm_type'},
{data: 'trade'},
{data: 'firm_class_id'},
{data: 'city'},
{data: 'street'},
{data: 'update_at'},
{data: 'delete_at'},
{data: 'create_at'},
{data: 'operate'},
]
});