我想根據 id 匯出資料,因此它不會獲取資料庫中的所有資料,例如,如果站點是“http://127.0.0.1:8000/pengajuan/3”,則“/3”是'submission_id' 我想從中匯出,這是我的代碼:
控制器
public function exportpdf()
{
$submissionDetail = SubmissionDetail::all();
$pdf = PDF::loadview('pengajuan_detail.pdf',['submissionDetail'=>$submissionDetail]);
return $pdf->stream();
}
提交詳情.php
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class SubmissionDetail extends Model
{
protected $fillable = [
'submission_id', 'nama_barang', 'image_path', 'jumlah', 'harga_satuan', 'harga_total', 'keterangan',
];
public function submission()
{
return $this->belongsTo('App\Submission');
}
public function negotiation()
{
return $this->hasOne('App\Negotiation');
}
public function realization()
{
return $this->hasOne('App\Realization');
}
}
怎么做?
uj5u.com熱心網友回復:
此代碼用于exportpdf()功能
// This will convert url string to array with '/' declimiter
$url = explode('/', url()->current()); // something like [..., '127.0.0.1:8000', 'pengajuan', '3']
$id = end($url); // result is 3
// Get Specific Submission detail with "where" function
$submissionDetail = SubmissionDetail::where('submission_id', $id)->first();
// Rest is just same
$pdf = PDF::loadview('pengajuan_detail', ['submissionDetail' => $submissionDetail]);
return $pdf->stream();
如果發生錯誤,它可能來自您的 PDF 模板(如果發生錯誤,您可以發布錯誤),因為您直接使用 PDF 檔案作為模板,而不是刀片檔案
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/481824.html
上一篇:如何阻止滑鼠右鍵單擊iframe
