File manager - Edit - /home/asiatechinc/public_html/asiatech-websites/demo/Dynast/app/Http/Controllers/WeddingEnquiryController.php
Back
<?php namespace App\Http\Controllers; use App\Models\WeddingEnquiry; use App\Traits\CommonFunctions; use App\Traits\ResponseAPI; use Exception; use Illuminate\Support\Facades\DB; use Yajra\DataTables\Facades\DataTables; use Illuminate\Http\Request; class WeddingEnquiryController extends Controller { use CommonFunctions; use ResponseAPI; public function store(Request $request) { try{ WeddingEnquiry::create([ "your_name" => $request->your_name , 'partner_name' => $request->partner_name , 'email' => $request->email , 'phone' => $request->phone , 'guest_count' => $request->guest_count , 'wed_date' => $request->wed_date, 'add_detail' => $request->add_detail, ]); $response = $this->success("Thank you for your message. We will contact you shortly.",[]); }catch(Exception $exception){ report($exception); $response = $this->error("Something went wrong. " . $exception->getMessage()); } return $response; } public function wedEnquiry(){ return view("Dashboard.Pages.wedEnquiry"); } public function enquiryDataTable(){ $query = WeddingEnquiry::select( "your_name" ,'partner_name' ,'email' ,'phone' ,'guest_count' ,'wed_date','add_detail','id', DB::raw('DATE_FORMAT(CONVERT_TZ('.'created_at'.',"+00:00","+05:30"), "%W %M %e %Y %r") as created_at_formatted') ); return DataTables::of($query) ->addIndexColumn() ->make(true); } public function exportWeddingEnquiriesCSV() { $fileName = 'wedding_enquiries_' . date('Y-m-d_H-i-s') . '.csv'; $enquiries = WeddingEnquiry::select( 'id', 'your_name', 'partner_name', 'email', 'phone', 'guest_count', 'wed_date', 'add_detail', 'created_at', 'updated_at' )->orderBy('id', 'DESC')->get(); $headers = [ "Content-type" => "text/csv; charset=UTF-8", "Content-Disposition" => "attachment; filename={$fileName}", "Pragma" => "no-cache", "Cache-Control" => "must-revalidate, post-check=0, pre-check=0", "Expires" => "0" ]; $columns = [ 'ID', 'Your Name', 'Partner Name', 'Email', 'Phone', 'Guest Count', 'Wedding Date', 'Additional Details', 'Created At', 'Updated At' ]; $callback = function() use ($enquiries, $columns) { $file = fopen('php://output', 'w'); // Add UTF-8 BOM for Excel compatibility fprintf($file, chr(0xEF).chr(0xBB).chr(0xBF)); // Add header row fputcsv($file, $columns); // Add data rows foreach ($enquiries as $row) { fputcsv($file, [ $row->id ?? '', $row->your_name ?? '', $row->partner_name ?? '', $row->email ?? '', "'" . ($row->phone ?? ''), // Force text format for phone $row->guest_count ?? '', $row->wed_date ?? '', $row->add_detail ?? '', $row->created_at ? $row->created_at->format('Y-m-d H:i:s') : '', $row->updated_at ? $row->updated_at->format('Y-m-d H:i:s') : '', ]); } fclose($file); }; return response()->stream($callback, 200, $headers); } }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.05 |
proxy
|
phpinfo
|
Settings