<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class Template extends Model
{
    use HasFactory;

    protected $fillable = ['title','q_id'];

    public function getTemplateQuery(){
        return "SELECT %s
        FROM templates
        WHERE 1
        AND `status` = 1
        AND `active` = 1
        %s
        %s
        %s
        %s
        ";
    }

    public function getTemplates($array_data){
        $fields = " * ";
        $query = sprintf(
            $this->getTemplateQuery(),
            $fields,
            $array_data['search'],
            $array_data['where'],
            $array_data['sort'],
            $array_data['offset_limit']
        );

        return DB::select($query);
    }

    public function getTemplatesCount($array_data){
        $fields = " COUNT(1) as Count ";
        $query = sprintf(
            $this->getTemplateQuery(),
            $fields,
            '',
            $array_data['where'],
            '',
            ''
        );
        return DB::select($query);
    }

    public function getTemplatesFilteredCount($array_data){
        $fields = " COUNT(1) as FilteredCount ";
        $query = sprintf(
            $this->getTemplateQuery(),
            $fields,
            $array_data['search'],
            $array_data['where'],
            '',
            ''
        );
        return DB::select($query);
    }

    public function getTemplatesReportQuery(){
        return "SELECT %s
        FROM templates 
        WHERE 1
        AND `status` = 1
        AND active = 1
        %s
        ";  
    }

    public function reports($array_data){
        $fields = " * ";
        $query = sprintf(
            $this->getTemplatesReportQuery(),
            $fields,
            $array_data['where']
        );

        return DB::select($query);
    }

    public function pdf($results){
        $data = [];

        $grpData = new \stdClass();

        $grpData->list = $results;
        $grpData->total = sizeOf($results);
        array_push($data,$grpData);

        $report_title = "Templates Masterfile";

        $reportData = [
            'data'  =>  $data,
            'webpage_title' =>  "Templates Report",
            'report_title'  =>  $report_title,
            'table_headers'  =>  ['No.', 'Template Name', 'Date Created'],
            'table_body'    =>  ['title','created_at']
        ];

        return $reportData;
    }

    public function csv($results){
        $templates = [];
        $templates[] = ['No.','Title', 'Date Created'];
        $inc = 0;
        foreach($results as $row){
            $templates[] = [
                $inc+=1,
                $row->title,
                $row->created_at,
            ];
        }
        $filename = "Templates_Masterfile." . date('Y-m-d H-i-sA').'.csv';

        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($templates[1])){
            $arr = [
                "No data to show"
            ];
            fputcsv($f, $arr);
        } else {
            foreach ($templates as $row) {
                fputcsv($f, $row, ',');
            }
        }
        
        fclose($f);
    }

    public function reportsTmpQstn($array_data){
        $fields = " * ";
        $query = sprintf(
            $this->getTemplatesReportQuery(),
            $fields,
            $array_data['where']
        );

        return DB::select($query);
    }

    // public function pdfTmpQstn($results){
    //     // dd($results);
    //     $data = [];

    //     $grpData = new \stdClass();

    //     $grpData->list = $results;
    //     $grpData->total = sizeOf($results);
    //     array_push($data,$grpData);

    //     $report_title = "Templates Masterfile";

    //     $reportData = [
    //         'data'  =>  $data,
    //         'webpage_title' =>  "Templates Report",
    //         'report_title'  =>  $report_title,
    //         'table_headers'  =>  ['No.', 'Questions', 'Date Created'],
    //         'table_body'    =>  ['title','created_at']
    //     ];

    //     return $reportData;
    // }
    public function pdfTmpQstn($results) {
        $data = [];
    
        $grpData = new \stdClass();
        // $grpData->no = 1;

        $grpData->list = $results;
        $grpData->total = sizeOf($results);
        array_push($data,$grpData);

        // $grpData->title = $results[0]->title;
        // $grpData->created_at = $results[0]->created_at;
        // $grpData->questions = $results[0]->questions;
        // array_push($data, $grpData);
    
        $report_title = "Template Questions Masterfile";
    
        $reportData = [
            'data' => $data,
            'webpage_title' => "Template Questions Masterfile",
            'template_title'    =>  $results[0]->title,
            'report_title' => $report_title,
            'table_headers' => ['No.', 'Questions', 'Date Created'],
            'table_body' => ['title', 'created_at'],
        ];
    
        return $reportData;
    }
    
    

    public function csvTmpQstn($results){
        $templates = [];
        $templates[] = ['No.','Questions','Date Created'];
        $inc = 0;
        foreach($results as $row){
            $templates[] = [
                $inc+=1,
                $row->title,
                $row->created_at
            ];
        }
        $filename = "Template_Questions_Masterfile"."-".date('Y-m-d').'.csv';

        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($templates[1])){
            $arr = [
                "No data to show"
            ];
            fputcsv($f,$arr);
        } else {
            foreach($templates as $row){
                fputcsv($f, $row, ',');
            }
            // fputcsv($f,$templates[0]->title,',');
        }

        fclose($f);
    }
}