ajax - Laravel - 如何使用 ajax 显示其他表中的数据
问题描述
我是laravel的初学者。我想加入一些表并将其显示在数据表中,我正在使用 yajra 数据表。我有三个表,分别是区域、分公司和分公司经理。我的问题是我想在刀片视图中显示 Branch 表,但不是显示 area_id 和 branch_manager_id,而是显示Area Table中的 area_desc 和Branch Manager Table中的 branch_manager_name 。我不知道如何获得它。
面积表
public function up()
{
Schema::create('area', function (Blueprint $table) {
$table->engine = 'InnoDB';
$table->bigIncrements('id');
$table->string('area_code')->unique();
$table->string('area_desc');
$table->timestamps();
});
}
分行经理表
public function up()
{
Schema::create('branch_manager', function (Blueprint $table) {
$table->engine = 'InnoDB';
$table->bigIncrements('id');
$table->string('branch_manager_name');
$table->string('branch_manager_contact_number');
$table->timestamps();
});
}
分支表
public function up()
{
Schema::create('branch', function (Blueprint $table) {
$table->engine = 'InnoDB';
$table->bigIncrements('id');
$table->string('branch_name');
$table->string('branch_address1');
$table->string('branch_address2');
$table->bigInteger('area_id')->unsigned();
$table->bigInteger('branch_manager_id')->unsigned();
$table->timestamps();
});
Schema::table('branch', function (Blueprint $table) {
$table->foreign('area_id')->references('id')->on('area')->onUpdate('cascade');
$table->foreign('branch_manager_id')->references('id')->on('branch_manager')->onUpdate('cascade');
});
}
面积模型
class Area extends Model
{
use HasFactory;
protected $table = 'area';
protected $fillable = [
'area_code',
'area_desc',
];
public function branch()
{
return $this->hasMany(Branch::class);
}
}
分行经理模型
class BranchManager extends Model
{
use HasFactory;
protected $table = 'branch_manager';
protected $fillable = [
'branch_manager_name',
'branch_manager_contact_number'
];
public function branch()
{
return $this->hasOne(Branch::class);
}
}
分支模型
class Branch extends Model
{
use HasFactory;
protected $table = 'branch';
protected $fillable = [
'branch_name',
'branch_address1',
'branch_address2',
'area_id',
'branch_manager_id',
];
public function area()
{
return $this->belongsTo(Area::class);
}
public function branchManager()
{
return $this->belongsTo(BranchManager::class);
}
}
分支数据表的 Ajax 请求
<script type="text/javascript">
$(function() {
$.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
});
var table = $('.table-striped.first').DataTable({
processing: true,
serverSide: true,
ajax: "{{ route('settings.branch.list') }}",
columns: [{
data: 'branch_name',
name: 'branch_name'
},
{
data: 'branch_address1',
name: 'branch_address1'
},
{
data: 'branch_address2',
name: 'branch_address2'
},
{
data: 'area_id',
name: 'area_id'
},
{
data: 'branch_manager_id',
name: 'branch_manager_id'
},
{
data: 'action',
name: 'action',
orderable: true,
searchable: true
},
]
});
</script>
分支控制器
public function branch(Request $request)
{
$branches = Branch::latest()->get();
$areas = Area::latest()->get();
$branchManagers = BranchManager::latest()->get();
if ($request->ajax()) {
$data = Branch::latest()->get();
return Datatables::of($data)
->addIndexColumn()
->addColumn('action', function($row){
$btn = '<a href="javascript:void(0)" data-toggle="tooltip" data-id="'.$row->id.'" data-original-title="Edit" class="btn btn-sm btn-outline-light editRecord">Edit</a>';
$btn = $btn.' <a href="javascript:void(0)" data-toggle="tooltip" data-id="'.$row->id.'" data-original-title="Delete" class="btn btn-sm btn-outline-light deleteRecord"><i class="far fa-trash-alt btn-outline-danger"></i></a>';
return $btn;
})
->rawColumns(['action'])
->make(true);
}
return view('admin.branch', compact('branches', 'areas', 'branchManagers'));
}
任何意见将不胜感激,谢谢
解决方案
在 BrachController.php 中
public function branch(Request $request)
{
if ($request->ajax()) {
$data = Branch::with('area','branchManager')->latest()->get();
return Datatables::of($data)
->addIndexColumn()
->addColumn('area_desc', function($row){
return $row->area->area_desc;
})
->addColumn('branch_manager_name', function($row){
return $row->branchManager->branch_manager_name;
})
->addColumn('action', function($row){
$btn = '<a href="javascript:void(0)" data-toggle="tooltip" data-id="'.$row->id.'" data-original-title="Edit" class="btn btn-sm btn-outline-light editRecord">Edit</a>';
$btn = $btn.' <a href="javascript:void(0)" data-toggle="tooltip" data-id="'.$row->id.'" data-original-title="Delete" class="btn btn-sm btn-outline-light deleteRecord"><i class="far fa-trash-alt btn-outline-danger"></i></a>';
return $btn;
})
->rawColumns(['area_desc', 'branch_manager_name', 'action'])
->make(true);
}
return view('admin.branch');
}
在刀片
<script type="text/javascript">
$(function() {
$.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
});
var table = $('.table-striped.first').DataTable({
processing: true,
serverSide: true,
ajax: "{{ route('settings.branch.list') }}",
columns: [{
data: 'branch_name',
name: 'branch_name'
},
{
data: 'branch_address1',
name: 'branch_address1'
},
{
data: 'branch_address2',
name: 'branch_address2'
},
{
data: 'area_desc',
name: 'area_desc'
},
{
data: 'branch_manager_name',
name: 'branch_manager_name'
},
{
data: 'action',
name: 'action',
orderable: true,
searchable: true
},
]
});
</script>
推荐阅读
- reactjs - 如何将 React App 添加到 Firebase 托管项目
- waf - 在配置步骤中使用“subst”功能
- python - 语音识别在我的代码中不起作用
- php - Lumen (5.8.7) - 路由中的最终参数包括斜杠
- ios - 具有 OpenSSL 通用依赖的 Swift 框架
- chart.js - 在 Chart.js 中使用刻度“主要”与未知文本重叠
- javascript - 操作员问题 Javascript
- vuejs2 - 使用 KEYCLOAK 确保 thorntail 服务
- ios - 为什么我不能与子视图交互?
- postgresql - 使用带有时区的 generate_series