72 lines
2.8 KiB
PHP
72 lines
2.8 KiB
PHP
<?php
|
|
/*********************************************************************************
|
|
** The contents of this file are subject to the vtiger CRM Public License Version 1.0
|
|
* ("License"); You may not use this file except in compliance with the License
|
|
* The Original Code is: vtiger CRM Open Source
|
|
* The Initial Developer of the Original Code is vtiger.
|
|
* Portions created by vtiger are Copyright (C) vtiger.
|
|
* All Rights Reserved.
|
|
*
|
|
********************************************************************************/
|
|
|
|
require_once('Smarty_setup.php');
|
|
global $mod_strings;
|
|
global $app_strings;
|
|
global $app_list_strings;
|
|
|
|
global $adb;
|
|
global $theme;
|
|
$theme_path="themes/".$theme."/";
|
|
$image_path=$theme_path."images/";
|
|
$smarty = new vtigerCRM_Smarty;
|
|
if(isset($_REQUEST['record']) && $_REQUEST['record']!='')
|
|
{
|
|
//Added to show the previous selected value when editing
|
|
$id = $_REQUEST['record'];
|
|
|
|
$query='select vtiger_emailtemplates.templateid,vtiger_emailtemplates.templatename from vtiger_notificationscheduler inner join vtiger_emailtemplates on vtiger_emailtemplates.templateid=vtiger_notificationscheduler.notificationbody where schedulednotificationid=?';
|
|
$result = $adb->pquery($query, array($id));
|
|
$selected_item=$adb->query_result($result,0,'templateid');
|
|
|
|
$sql="select * from vtiger_notificationscheduler 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 vtiger_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);
|
|
|
|
|
|
|
|
$smarty->assign("MOD", return_module_language($current_language,'Settings'));
|
|
$smarty->assign("IMAGE_PATH",$image_path);
|
|
$smarty->assign("APP", $app_strings);
|
|
$smarty->assign("THEME", $theme);
|
|
$smarty->assign("CMOD", $mod_strings);
|
|
$smarty->display("Settings/EditEmailNotification.tpl");
|
|
?>
|