mirror of
https://github.com/VTECRM/vtenext.git
synced 2026-02-26 16:18:47 +00:00
60 lines
2.3 KiB
PHP
60 lines
2.3 KiB
PHP
<?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");
|