One Hat Cyber Team

Your IP : 3.137.218.48

Server IP : 162.241.123.123

Server : Linux sh016.hostgator.in 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64

Server Software : Apache

PHP Version : 8.2.25

Buat File | Buat Folder

Dir : ~/home1/saicsazq/portal.smhtechlabs.com/app/Models/

Edit File: Email_templates_model.php

<?php

namespace App\Models;

class Email_templates_model extends Crud_model {

protected $table = null;

function __construct() {
        $this->table = 'email_templates';
        parent::__construct($this->table);
    }

function get_details($options = array()) {
        $email_templates_table = $this->db->prefixTable('email_templates');

$where = "";
        $id = $this->_get_clean_value($options, "id");
        if ($id) {
            $where .= " AND $email_templates_table.id=$id";
        }

$template_name = $this->_get_clean_value($options, "template_name");
        if ($template_name) {
            $where .= " AND $email_templates_table.template_name='$template_name'";
        }

$template_type = $this->_get_clean_value($options, "template_type");
        if ($template_type) {
            $where .= " AND $email_templates_table.template_type='$template_type'";
        }

$sql = "SELECT $email_templates_table.*
        FROM $email_templates_table
        WHERE $email_templates_table.deleted=0 $where";
        return $this->db->query($sql);
    }

function get_final_template($template_name = "", $return_all = false) {
        $email_templates_table = $this->db->prefixTable('email_templates');
        $template_name = $this->_get_clean_value($template_name);

$where = "";
        if (!$return_all) {
            //get default template only
            $where = " AND $email_templates_table.template_type='default' ";
        }

$sql = "SELECT $email_templates_table.default_message, $email_templates_table.custom_message, $email_templates_table.email_subject, $email_templates_table.language,
            signature_template.custom_message AS signature_custom_message, signature_template.default_message AS signature_default_message
        FROM $email_templates_table
        LEFT JOIN $email_templates_table AS signature_template ON signature_template.template_name='signature' AND signature_template.language=$email_templates_table.language
        WHERE $email_templates_table.deleted=0 AND $email_templates_table.template_name='$template_name' $where ";
        $templates = $this->db->query($sql)->getResult();

if ($return_all) {
            $info = array();

foreach ($templates as $template) {

$language = "default";
                if ($template->language) {
                    $language = $template->language;
                }

$info["subject_" . $language] = $template->email_subject;
                $info["message_" . $language] = $template->custom_message ? $template->custom_message : $template->default_message;
                $info["signature_" . $language] = $template->signature_custom_message ? $template->signature_custom_message : $template->signature_default_message;
            }

return $info;
        } else {
            $result = $this->db->query($sql)->getRow();

$info = new \stdClass();
            $info->subject = $result->email_subject;
            $info->message = $result->custom_message ? $result->custom_message : $result->default_message;
            $info->signature = $result->signature_custom_message ? $result->signature_custom_message : $result->signature_default_message;
            
            return $info;
        }
    }

}