File manager - Edit - /home/autoph/repositories/AutoHub-Rating/app/Models/Questions.php
Back
<?php namespace App\Models; use App\Http\Controllers\AuthController; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Database\Eloquent\Model; use Illuminate\Support\Facades\DB; use PDF; // use Dompdf; use Illuminate\Support\Facades\App; class Questions extends Model { use HasFactory; public function getQuestionsQuery(){ return "SELECT %s FROM questions WHERE 1 AND `status` = 1 AND active = 1 %s %s %s %s "; } public function getQuestions($array_data){ // dd($array_data); $fields = " * "; $query = sprintf( $this->getQuestionsQuery(), $fields, $array_data['search'], $array_data['where'], $array_data['sort'], $array_data['offset_limit'] ); return DB::select($query); } public function getQuestionsCount($array_data){ $fields = " COUNT(1) as Count "; $query = sprintf( $this->getQuestionsQuery(), $fields, '', $array_data['where'], '', '' ); return DB::select($query); } public function getQuestionsFilteredCount($array_data){ $fields = " COUNT(1) as FilteredCount "; $query = sprintf( $this->getQuestionsQuery(), $fields, $array_data['search'], $array_data['where'], '', '' ); return DB::select($query); } public function getQuestionsReportQuery(){ return "SELECT %s FROM questions WHERE 1 AND `status` = 1 AND active = 1 %s "; } public function reports($array_data){ $fields = " id, title, DATE_FORMAT(`created_at`,'%M %e, %Y') as created_at "; $query = sprintf( $this->getQuestionsReportQuery(), $fields, $array_data['where'], ); // dd($query); return DB::select($query); } public function pdf($results,$type){ $data = []; $grpData = new \stdClass(); $grpData->list = $results; $grpData->total = sizeOf($results); array_push($data, $grpData); $report_title = "Questions Masterfile"; $reportData = [ 'data' => $data, 'webpage_title' => "Questions Report", 'report_title' => $report_title, 'table_headers' => ['No.','Title', 'Date Created'], 'table_body' => ['title','created_at'], // 'img' => $base64 ]; return $reportData; } public function pdf2($results){ $data = []; $grpData = new \stdClass(); $grpData->list = $results; $grpData->total = sizeOf($results); array_push($data, $grpData); $report_title = "Question per Template Masterfile"; $reportData = [ 'data' => $data, 'webpage_title' => "Questions Report", 'report_title' => $report_title, 'table_headers' => ['No.','Title','Templates', 'Date Created'], 'table_body' => ['title','templateTitles','created_at'], // 'img' => $base64 ]; return $reportData; } public function csv($results){ // dd($results); $questions = []; $questions[] = ['No.','Title']; $inc = 0; foreach ($results as $row) { $questions[] = [ $inc+=1, $row->title ]; } $filename = "Questions_Masterfile"."-". date('Y-m-d').'.csv'; // dd($questions); header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename="'.$filename.'"'); $f = fopen('php://output', 'wb'); if ($f === false) { die('Error opening the file ' .$filename); } if(empty($questions[1])){ $arr = [ "No data to show" ]; fputcsv($f, $arr); } else { foreach ($questions as $row) { fputcsv($f, $row, ','); } } fclose($f); } }
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings