<?php
/**
*
* @ This file is created by http://DeZender.Net
* @ deZender (PHP7 Decoder for ionCube Encoder)
*
* @ Version			:	4.0.9.0
* @ Author			:	DeZender
* @ Release on		:	08.08.2019
* @ Official site	:	http://DeZender.Net
*
*/

class Email_Templates extends TableGateway
{
	/**
    * Registry
    * @var object Registry
    */
	public $PMDR;
	/**
    * Database
    * @var object Database
    */
	public $db;

	/**
    * Email Templates Constructor
    * @param object $PMDR Registry
    * @return void
    */
	public function __construct($PMDR)
	{
		$this->PMDR = $PMDR;
		$this->db = $PMDR->get('DB');
		$this->table = T_EMAIL_TEMPLATES;
	}

	/**
    * Insert email template
    * @param array $data Email template data
    * @return void
    */
	public function insert($data)
	{
		$phrases = $this->PMDR->get('Phrases');
		$data['id'] = Strings::strtolower($data['id']);
		$phrases->insert(['variablename' => 'email_templates_' . $data['id'] . '_name', 'content' => $data['name']], 'email_templates');
		$phrases->insert(['variablename' => 'email_templates_' . $data['id'] . '_subject', 'content' => $data['subject']], 'email_templates');
		$phrases->insert(['variablename' => 'email_templates_' . $data['id'] . '_body_html', 'content' => $data['body_html']], 'email_templates');
		$phrases->insert(['variablename' => 'email_templates_' . $data['id'] . '_body_plain', 'content' => $data['body_plain']], 'email_templates');
		$attachment_names = [];

		if (is_array($data['attachments'])) {
			foreach ($data['attachments']['name'] as $attachment_index => $name) {
				if ($data['attachments']['error'][$attachment_index] == 0) {
					move_uploaded_file($data['attachments']['tmp_name'][$attachment_index], TEMP_UPLOAD_PATH . $name);
					$attachment_names[] = $name;
				}
			}
		}

		$data['attachments'] = serialize(array_unique($attachment_names));

		if (!isset($data['moderate'])) {
			$data['moderate'] = 0;
		}

		$this->db->Execute('INSERT INTO ' . T_EMAIL_TEMPLATES . ' SET id=?, from_address=?, from_name=?,reply_address=?, recipients=?, disable=?, type=?, custom=?, attachments=?, moderate=?', [$data['id'], $data['from_address'], $data['from_name'], $data['reply_address'], $data['recipients'], $data['disable'], $data['type'], $data['custom'], $data['attachments'], $data['moderate']]);
	}

	/**
    * Delete email template
    * @param string $id Email template ID
    * @return void
    */
	public function delete($id)
	{
		$phrases = $this->PMDR->get('Phrases');
		$phrases->delete('email_templates_' . $id . '_name', 'email_templates');
		$phrases->delete('email_templates_' . $id . '_subject', 'email_templates');
		$phrases->delete('email_templates_' . $id . '_body_html', 'email_templates');
		$phrases->delete('email_templates_' . $id . '_body_plain', 'email_templates');
		$this->PMDR->get('Email_Schedules')->delete(['email_template_id' => $id]);
		$this->PMDR->get('Email_Queue')->delete(['template_id' => $id]);
		parent::delete($id);
	}

	/**
    * Update email template
    * @param array $data Email template data
    * @param string $id Email template ID
    * @return void
    */
	public function update($data, $id)
	{
		$template = $this->db->GetRow('SELECT * FROM ' . T_EMAIL_TEMPLATES . ' WHERE id=?', [$id]);
		$phrases = $this->PMDR->get('Phrases');
		$phrases->updatePhrase($this->PMDR->getConfig('language_admin'), 'email_templates', 'email_templates_' . $id . '_name', $data['name']);
		$phrases->updatePhrase($this->PMDR->getConfig('language_admin'), 'email_templates', 'email_templates_' . $id . '_subject', $data['subject']);
		$phrases->updatePhrase($this->PMDR->getConfig('language_admin'), 'email_templates', 'email_templates_' . $id . '_body_html', $data['body_html']);
		$phrases->updatePhrase($this->PMDR->getConfig('language_admin'), 'email_templates', 'email_templates_' . $id . '_body_plain', $data['body_plain']);
		if (is_array($data['attachments']) && count($data['attachments'])) {
			if (!empty($template['attachments'])) {
				$attachment_names = unserialize($template['attachments']);
				if ($data['attachments_current'] && count($data['attachments_current'])) {
					foreach ($data['attachments_current'] as $attachment_current) {
						unlink_file(TEMP_UPLOAD_PATH . $attachment_current);
					}

					$attachment_names = array_diff($attachment_names, $data['attachments_current']);
				}
			}
			else {
				$attachment_names = [];
			}

			foreach ($data['attachments']['name'] as $attachment_index => $name) {
				if ($data['attachments']['error'][$attachment_index] == 0) {
					move_uploaded_file($data['attachments']['tmp_name'][$attachment_index], TEMP_UPLOAD_PATH . $name);
					$attachment_names[] = $name;
				}
			}
		}

		$data['attachments'] = serialize(array_unique($attachment_names));
..........................................................................................
.....................................................
....................