\u3060\u3044\u3076\u6163\u308c\u3066\u304d\u305fLaravel\u3002\u305b\u304b\u3063\u304f\u306a\u306e\u3067PDF\u306e\u6271\u3044\u3082\u3084\u3063\u3066\u307f\u3088\u3046\u3068\u5b9f\u88c5\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n
\u300eLaravel PDF \u4f5c\u6210\u300f\u3067\u691c\u7d22\u3057HIT\u3059\u308b\u30c4\u30fc\u30eb\u3092\u5229\u7528\u3002<\/p>\n
\u56f0\u3063\u305f\u554f\u984c\u3082\u3042\u308a\u307e\u3057\u305f\u304c\u975e\u5e38\u306b\u7c21\u5358\u3060\u3063\u305f\u306e\u3067\u5099\u5fd8\u9332\u306b\u66f8\u304d\u6e9c\u3081\u307e\u3059\u3002<\/p>\n
public function receipt_pdf($id) {\r\n \r\n $pdf = \\PDF::loadView('PDF\u5316\u3059\u308b\u9818\u53ce\u66f8\u306e\u30ea\u30f3\u30af');\r\n return $pdf->stream('\u9818\u53ce\u66f8.pdf');\r\n\r\n\/* \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3055\u305b\u308b\u5834\u5408\u306f\u3053\u3063\u3061\u3092\u8a18\u8f09\u3059\u308b\u3002\r\n* \u753b\u9762\u9077\u79fb\u306f\u8d77\u3053\u3089\u305a\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u304c\u958b\u59cb\u3059\u308b\r\n*\/ return $pdf->download('\u9818\u53ce\u66f8.pdf');<\/pre>\nlaravel-dompdf\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u306f\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u30fc\u306b\u4e0a\u8a18\u30b3\u30fc\u30c9\u3092\u8a18\u8f09\u3059\u308b\u3060\u3051\u3002<\/p>\n
\u9a5a\u304f\u307b\u3069\u7c21\u5358\u3067\u3057\u305f\u3002<\/p>\n
\u53c2\u8003\u3068\u3057\u305f\u30b5\u30a4\u30c8\u306b\u306f\u5f15\u6570\u3092\u6e21\u3059\u3068\u304d\u306e\u8a18\u8f09\u65b9\u6cd5\u306a\u3069\u660e\u793a\u3055\u308c\u3066\u306a\u304b\u3063\u305f\u306e\u3067\u88dc\u8db3\u3068\u3057\u3066\u8a18\u8f09\u3057\u307e\u3059\u3002<\/p>\n
\u25a0View<\/p>\n
\/\/\u9818\u53ce\u66f8PDF\r\n Route::get('pdf\/billings\/{id}', 'HomeController@receipt_pdf');<\/pre>\n\u25a0Controller\uff08\u203b\u4f8b\u306fHomeController\uff09<\/p>\n
<?PHP<?PHP\r\nnamespace App\\Http\\Controllers;\r\n\r\nuse Illuminate\\Http\\Request;\r\nuse Illuminate\\Support\\Facades\\DB;\r\nuse App\\Models\\Billing;\r\nuse App\\Models\\Billingstatement;\r\nuse App\\Models\\Applicant;\r\n\r\n\r\n\r\n public function receipt_pdf($id) {\r\n \r\n $billingstatements = Billingstatement::where('billing_id',$id)->get();\r\n $prices = DB::select(\r\n 'SELECT \r\n billings.id, \r\n sumprice.salculation, \r\n sumprice.taxs, \r\n sumprice.applicost,\r\n billings.date, \r\n billings.billing, \r\n billings.contents, \r\n billings.memo\r\n FROM billings \r\n INNER JOIN \r\n (\r\n SELECT \r\n billingstatements.billing_id,\r\n ROUND(\r\n SUM(\r\n billingstatements.price *\r\n billingstatements.number *\r\n (1 + billingstatements.taxrate)\r\n )\r\n ,0) as salculation,\r\n ROUND(\r\n SUM(\r\n billingstatements.price *\r\n billingstatements.number *\r\n billingstatements.taxrate\r\n )\r\n ,0) as taxs,\r\n SUM(\r\n billingstatements.price *\r\n billingstatements.number \r\n )as applicost \r\n FROM billingstatements\r\n Group BY billingstatements.billing_id\r\n ) AS sumprice \r\n ON billings.id = sumprice.billing_id\r\n WHERE (billings.onoff = 1) AND (billings.id = '.$id.')'\r\n );\r\n\r\n $applicant =Applicant::where('id',1)->first();\r\n $billing = Billing::find($id);\r\n \r\n\r\n $pdf = \\PDF::loadView('pdf\/receipt',['prices' => $prices], compact('billing','applicant','billingstatements'));\r\n return $pdf->stream('\u9818\u53ce\u66f8.pdf');\r\n\u3000\u3000\u3000\u3000\uff5d\r\n\uff5d\r\n<\/pre>\n\u30c6\u30fc\u30d6\u30ebbillings\uff1d\u8acb\u6c42\u60c5\u5831\u306e\u89aa<\/p>\n
\u30c6\u30fc\u30d6\u30ebbillingstatements\uff1d\u8cfc\u5165\u5c65\u6b74
\n\u203b\u3069\u306e\u8acb\u6c42\u60c5\u5831\u306b\u5165\u308c\u308b\u304bbillingstatements.billing_id\u3067\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n
\u30c6\u30fc\u30d6\u30ebapplicants=\u8cfc\u5165\u8005\u60c5\u5831
\n\u203b\u4e0a\u8a18\u4f8b\u306f1\u30b7\u30b9\u30c6\u30e01\u793e\u306e\u4ed5\u69d8\u306a\u306e\u3067\u30ec\u30b3\u30fc\u30c9\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306f\u3042\u308a\u307e\u305b\u3093\u304c\u3001billingstatements\u306bapplicant_id \u3092\u8a2d\u5b9a\u3057\u591a\u5bfe\u591a\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u7d44\u3080\u4e8b\u3067\u8907\u6570\u306e\u8cfc\u5165\u8005\u306b\u3082\u5bfe\u5fdc\u3067\u304d\u307e\u3059\u3002<\/p>\n
\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u30fc\u3067\u306e\u58f2\u4fa1\u8a08\u7b97\u304c\u30b0\u30c1\u30e3\u30b0\u30c1\u30e3\u3057\u7406\u89e3\u51fa\u6765\u306a\u304b\u3063\u305f\u305f\u3081\u3001\u58f2\u4fa1\u306e\u8a08\u7b97\u306f\u76f4\u63a5\u30af\u30a8\u30ea\u3092\u4f5c\u308a\u5b9f\u884c\u3057\u3066\u307e\u3059\u3002\u76f4\u63a5\u30af\u30a8\u30ea\u3092\u8a18\u8f09\u3057\u305f\u5834\u5408\u306f\u5f15\u6570\u306e\u66f8\u304d\u65b9\u304c\u5909\u308f\u308b\u306e\u3067\u8981\u6ce8\u610f\u3002<\/p>\n
$pdf = \\PDF::loadView('pdf\/receipt',['prices' => $prices], compact('billing','applicant','billingstatements'));\u2019\r\n<\/pre>\n\u2019pdf\/receipt\u2019\uff1dPDF\u5316\u3057\u305f\u3044HTML(receipt.blade.php)\u306e\u4fdd\u7ba1\u30d5\u30a9\u30eb\u30c0\u3068\u30d5\u30a1\u30a4\u30eb\u540d
\n\u203b\u4f8b\u306e\u5834\u5408\u306f\u3001resources\/pdf\/receipt.php \u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n
['prices' => $prices]\uff1dDB::select( )\u306b\u3066SQL\u30af\u30a8\u30ea\u3092\u76f4\u6307\u5b9a\u3057\u305f\u5834\u5408\u306e\u5f15\u6570\u306e\u6e21\u3057\u65b9\u3002<\/p>\n
compact('billing','applicant','billingstatements')\uff1d\u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u306a\u3069\u3001Laravel\u306e\u30c4\u30fc\u30eb\u3092\u5229\u7528\u3057\u305f\u30c7\u30fc\u30bf\u306e\u6e21\u3057\u65b9\u3002<\/p>\n
\u3053\u3093\u306a\u611f\u3058\u3067\u66f8\u3044\u3066\u3042\u3052\u308b\u3068\u3001URL\u306eGET\u306b\u5165\u3063\u305f\u5024\u3092\uff04id\u3068\u3057\u3066\u53d6\u5f97\u3057\u3001\u30af\u30a8\u30ea\u3067\u62bd\u51fa\u3002
\n\u6b32\u3057\u3044\u30c7\u30fc\u30bf\u306ePDF\u304c\u7c21\u5358\u306b\u4f5c\u308c\u307e\u3059\u3002<\/p>\n
laravel-dompdf \u306e\u6b20\u70b9\u3002<\/h3>\n