<?php
/*************************************
 * SPDX-FileCopyrightText: 2009-2020 Vtenext S.r.l. <info@vtenext.com> 
 * SPDX-License-Identifier: AGPL-3.0-only  
 ************************************/

global $mod_strings, $app_strings, $theme;
global $adb, $table_prefix;


$smarty = new VteSmarty();

if(isset($_REQUEST['record']) && $_REQUEST['record']!='') {
	//Added to show the previous selected value when editing
	$id = intval($_REQUEST['record']);
	$query = "select type,notificationbody from ".$table_prefix."_notifyscheduler where schedulednotificationid = ?";
	$result = $adb->pquery($query, array($id));
	if ($adb->query_result($result,0,'type') == 'select')
		$selected_item = $adb->query_result($result,0,'notificationbody');	

	$sql="select * from ".$table_prefix."_notifyscheduler where schedulednotificationid = ?";
	$result = $adb->pquery($sql, array($id));
	if($adb->num_rows($result) == 1)	{
		$notification = Array();
		$notification['active'] = $adb->query_result($result,0,'active');
		$notification['subject'] = $adb->query_result($result,0,'notificationsubject');
		$notification['body'] = $adb->query_result($result,0,'notificationbody');
		$notification['name'] = $mod_strings[$adb->query_result($result,0,'label')];
		$notification['id'] = $adb->query_result($result,0,'schedulednotificationid');
		$notification['type'] = $adb->query_result($result,0,'type');
	}
	
	$smarty->assign("NOTIFY_DETAILS",$notification);
	//Added to show the previous selected value when editing. assigning previously selected id
	$smarty->assign("SEL_ID",$selected_item);
}

//Get all the email template name and id and send it to tpl to generate the combo box
$query="select templateid,templatename from ".$table_prefix."_emailtemplates";
$result = $adb->pquery($query, array());

$values = Array();
for ($i=0; $i < $adb->num_rows($result); $i++) {
	$temp_id = $adb->query_result($result,$i,'templateid');	    
	$temp_name = $adb->query_result($result,$i,'templatename');
	$values[$temp_id]=$temp_name;	    
}

$smarty->assign("VALUES",$values);

$theme_path="themes/".$theme."/";
$image_path=$theme_path."images/";

$smarty->assign("MOD", return_module_language($current_language,'Settings'));
$smarty->assign("IMAGE_PATH",$image_path);
$smarty->assign("APP", $app_strings);
$smarty->assign("CMOD", $mod_strings);

$smarty->display("Settings/EditEmailNotification.tpl");