芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/email_template.php

<?php include("includes/head.php"); ?>

<?php include("includes/header.php"); ?>

<?php

///////////////Add Events///////////////////////////////////////////////

if($_REQUEST['addar11']=="SAVE" && count($_POST)>0 && $_REQUEST['main_activity_id']=='' && $_REQUEST['action']!="edit")

{
	$subject=mysql_real_escape_string($_REQUEST['subjectar11']);
	$body=mysql_real_escape_string($_REQUEST['bodyar11']);
	mysql_query("update sat_email_template set subject='".$subject."',body='".$body."' where id=1");
	$msg = 2;
	header("location:email_template.php?msg=$msg&id=1");
}

if($_REQUEST['addtime']=="SAVE" && count($_POST)>0 && $_REQUEST['main_activity_id']=='' && $_REQUEST['action']!="edit")

{
	$subject=mysql_real_escape_string($_REQUEST['subjecttime']);
	$body=mysql_real_escape_string($_REQUEST['bodytime']);
	mysql_query("update sat_email_template set subject='".$subject."',body='".$body."' where id=2");
	$msg = 2;
	header("location:email_template.php?msg=$msg&id=2");
}

if($_REQUEST['add_project_ending']=="SAVE" && count($_POST)>0 && $_REQUEST['main_activity_id']=='' && $_REQUEST['action']!="edit")

{
	$subject=mysql_real_escape_string($_REQUEST['subject_project_ending']);
	$body=mysql_real_escape_string($_REQUEST['body_project_ending']);
	mysql_query("update sat_email_template set subject='".$subject."',body='".$body."' where id=3");
	$msg = 2;
	header("location:email_template.php?msg=$msg&id=3");
}

if($_REQUEST['add_payroll']=="SAVE" && count($_POST)>0 && $_REQUEST['main_activity_id']=='' && $_REQUEST['action']!="edit")

{
	$subject=mysql_real_escape_string($_REQUEST['subject_payroll']);
	$body=mysql_real_escape_string($_REQUEST['body_payroll']);
	mysql_query("update sat_email_template set subject='".$subject."',body='".$body."' where id=4");
	$msg = 2;
	header("location:email_template.php?msg=$msg&id=4");
}

if($_REQUEST['add_supplemental_timesheet']=="SAVE" && count($_POST)>0 && $_REQUEST['main_activity_id']=='' && $_REQUEST['action']!="edit")

{
	$subject=mysql_real_escape_string($_REQUEST['subject_supplemental_timesheet']);
	$body=mysql_real_escape_string($_REQUEST['body_supplemental_timesheet']);
	mysql_query("update sat_email_template set subject='".$subject."',body='".$body."' where id=5");
	$msg = 2;
	header("location:email_template.php?msg=$msg&id=5");
}
	
if($_REQUEST['add_staff_edit']=="SAVE" && count($_POST)>0 && $_REQUEST['main_activity_id']=='' && $_REQUEST['action']!="edit")

{
	$subject=mysql_real_escape_string($_REQUEST['subject_staff_edit']);
	$body=mysql_real_escape_string($_REQUEST['body_staff_edit']);
	mysql_query("update sat_email_template set subject='".$subject."',body='".$body."' where id=6");
	$msg = 2;
	header("location:email_template.php?msg=$msg&id=6");
}
/////////////End Add//////////////////////////////////////////////

///////////////////////////Edit Events////////////////////////////

if($_REQUEST['edit']=="EDIT" && count($_POST)>0 && $_REQUEST['main_activity_id']!='' && $_REQUEST['action']=="edit")

{
	mysql_query("update sat_main_activity set main_activity='".mysql_real_escape_string($_REQUEST['main_activityname'])."' where main_activity_id=".$_REQUEST['main_activity_id']."");

$msg = 2;

header("location:email_template.php?msg=$msg&page=".$_REQUEST['page_hide']."");

}

///////////////////////////End edit events////////////////////////

///////////////////////////For Edit////////////////////////////////////////////////

$array_product_details="";

if($_REQUEST['action']=="edit" && $_REQUEST['main_activity_id']!='' && !$_REQUEST['edit'])

{

$array_product_details=mysql_fetch_array(mysql_query("select * from sat_main_activity where main_activity_id=".$_REQUEST['main_activity_id']." order by main_activity"));

$_REQUEST['main_activityname']=$array_product_details['main_activity'];

}

//////////////////////End for edit///////////////////////////////////////////

///////////////////For Delete//////////////////////////////////////////////

if($_REQUEST['delete']=="del" && $_REQUEST['delete_id']!='')

{

mysql_query("delete from sat_main_activity where main_activity_id=".$_REQUEST['delete_id']."");

mysql_query("delete from abs_exhibit where main_activity_id=".$_REQUEST['delete_id']."");

$msg = 3;

header("location:email_template.php?msg=$msg&page=".$_REQUEST['page_hide']."");

}

///////////////////////End for delete//////////////////////////////////

if(!$_REQUEST['page'])

{

$_SESSION['srchstr']="";

$_SESSION['srchkey']="";

}

jQuery.noConflict();

(function($) {jQuery(document).ready(function(){

// binds form submission and fields to the validation engine

jQuery("#formID").validationEngine();

});})(jQuery);

</script>

function validate()

{

if(document.frmproduct.main_activityname.value=='')

{

alert("Please enter exhibit main_activity name");

document.frmproduct.main_activityname.focus();

return false;

}

return true();

}

<?php /*?><script type="text/javascript" src="js/tiny_mce/tiny_mce.js"></script>

tinyMCE.init({

// General options

mode : "textareas",

editor_selector : "require_textarea",

height : 610,

width : 750,

theme : "advanced",
		relative_urls : false,
		remove_script_host : false,
		convert_urls : true,
        plugins : "autolink,lists,spellchecker,pagebreak,style,layer,table,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template",

// Theme options

//theme_advanced_buttons1 : "save,bold,italic,underline,strikethrough,justifyleft,justifycenter,justifyright,justifyfull,code",

theme_advanced_buttons1 : "save,bold,italic,underline,strikethrough,justifyleft,justifycenter,justifyright,justifyfull,code,bullist,numlist",

//theme_advanced_buttons2 : "",

//theme_advanced_buttons3 : "",

//theme_advanced_buttons4 : "",

theme_advanced_toolbar_location : "top",

theme_advanced_toolbar_align : "left",

theme_advanced_statusbar_location : "",

theme_advanced_resizing : true,

force_br_newlines: true,

force_p_newlines: false,

convert_newlines_to_brs: true,

});

</script><?php */?>
<script type="text/javascript" src="js/tinymce/tinymce.min.js"></script>
<script type="text/javascript">
tinymce.init({
        selector: "#bodyar11",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

menubar: false,
        toolbar_items_size: 'small',
		//relative_urls: false,
		relative_urls : false,
		remove_script_host : false,
		convert_urls : true,
		//document_base_url: 'http://www.insurancemall2.com/india/',
        style_formats: [
                {title: 'Bold text', inline: 'b'},
                {title: 'Red text', inline: 'span', styles: {color: '#ff0000'}},
                {title: 'Red header', block: 'h1', styles: {color: '#ff0000'}},
                {title: 'Example 1', inline: 'span', classes: 'example1'},
                {title: 'Example 2', inline: 'span', classes: 'example2'},
                {title: 'Table styles'},
                {title: 'Table row 1', selector: 'tr', classes: 'tablerow1'}
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});
</script>
<script type="text/javascript">
tinymce.init({
        selector: "#bodytime",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});

tinymce.init({
        selector: "#body_project_ending",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});

tinymce.init({
        selector: "#body_payroll",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});

tinymce.init({
        selector: "#body_supplemental_timesheet",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});

tinymce.init({
        selector: "#body_staff_edit",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});
</script>

<font color="#009933"></font>
<?php
$msg=$_REQUEST['msg'];
if($msg == 1){

$msg = '<font color="#009933">Main activity added successfully</font>';

}

if($msg == 2){

$msg = '<font color="#009933">Email template updated successfully</font>';

}

if($msg == 3){

$msg = "Main activity deleted successfully";

}

if($msg == 4){

$msg = "Main activity already exsists";

}

?>
<div class="mydiv" style="padding:18px;">
<?php if($_REQUEST['msg']=='3'){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='1'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='2'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='4'){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<div style="clear:both;"></div>
</div>
<div style="clear:both;"></div>
<div class="container_bottom_section new-class">

<?php /*?><a href="javascript:open_src('5');" class="require" style="margin-right:5px; margin-bottom:5px;">Supplemental Timesheet Email Format</a><?php */?>

<div class="links-a e-temp-left">
<a class="active" href="javascript:open_src('1');">Staff Edit Information Email Format <i class="fa fa-caret-right"></i></a>
<a href="javascript:open_src('2');">Time Sheet Email Format <i class="fa fa-caret-right"></i></a>
<a href="javascript:open_src('3');">Question Email Format <i class="fa fa-caret-right"></i></a>
<a href="javascript:open_src('4');">Time Sheet with Attachment Email Format <i class="fa fa-caret-right"></i></a>
<a href="javascript:open_src('5');">Forgot Password Email Format <i class="fa fa-caret-right"></i></a>
<a href="javascript:open_src('6');">Staff Password Email Format <i class="fa fa-caret-right"></i></a>
</div>

<tr>

<tr>

<td width="86%" align="center">
                 <?php
				 $arrText = mysql_fetch_assoc(mysql_query("select * from sat_email_template where id=1"));
				 ?>
				<div id="div_add_task" style="display:<?php if($_REQUEST['id']=="1"){ ?>block<?php }else{ ?>none<?php } ?>;">
                 <table height="161" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">

<tr>

<td align="center" valign="middle" colspan="5" height="10" class="head_text" >Manage Staff Edit Information Email Format</td>

</tr>

<td width="131" height="22" align="center" valign="top" class="head_text2">Subject </td>

<td align="left" valign="top"><input name="subjectar11" id="subjectar11" size="25" style="width:360px;" maxlength="255" type="text" value="<?php echo stripslashes($arrText['subject'])?>" class="validate[required] textfield" /></td>

</tr>
                   <tr class="smalltext">
                     <td height="22" align="center" valign="top" class="head_text2">Body</td>
                     <td align="left" valign="top" class="enquiery">:</td>
                     <td align="left" valign="top" class="etemp-editor">
                     	<textarea name="bodyar11" id="bodyar11" class="validate[required] textarea require_textarea"><?php echo htmlspecialchars_decode(stripslashes($arrText['body'])); ?></textarea></td>
                   </tr>

<tr>

<td valign="top" class="button new-link" aign="left">
                       
                       <? if($_REQUEST['action']=="edit")

{

?>
                       
                       <input type="submit" name="edit" class="newadd" value="EDIT" border="0" />
                       <a href="email_template.php"><input type="button" name="back" id="back" class="newadd" value="Cancel"  /></a>
                       <?

}

else

{

?>
                       
                       <input type="submit" name="addar11" class="newadd" value="SAVE" border="0" />
                       <a href="index.php"><input type="button" name="back" id="back" class="newadd" value="Cancel" /></a>
                       <?

}

?>                     </td>

</tr>

</tr>

</table></td>

</tr>

</table>
                 </div>
                 
                 <?php
				 $arrText = mysql_fetch_assoc(mysql_query("select * from sat_email_template where id=2"));
				 ?>
				<div id="div_add_task_time" style="display:<?php if($_REQUEST['id']=="2"){ ?>block<?php }else{ ?>none<?php } ?>;">
                 <table height="161" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">

<tr>

<td align="center" valign="middle" colspan="5" height="10" class="head_text" >Manage Time Sheet Email Format</td>

</tr>

<td width="131" height="22" align="center" valign="top" class="head_text2">Subject </td>

<td align="left" valign="top"><input name="subjecttime" id="subjecttime" size="25" style="width:360px;" maxlength="255" type="text" value="<?php echo stripslashes($arrText['subject'])?>" class="validate[required] textfield" /></td>

</tr>
                   <tr class="smalltext">
                     <td height="22" align="center" valign="top" class="head_text2">Body</td>
                     <td align="left" valign="top" class="enquiery">:</td>
                     <td align="left" valign="top" class="etemp-editor"><textarea name="bodytime" id="bodytime" class="validate[required] textarea require_textarea"><?php echo htmlspecialchars_decode(stripslashes($arrText['body'])); ?></textarea></td>
                   </tr>

<tr>

<td valign="top" class="button" aign="left">
                       
                       <? if($_REQUEST['action']=="edit")

{

}

else

{

?>
                       
                       <input type="submit" name="addtime" class="newadd" value="SAVE" border="0" />
                       <a href="index.php"><input type="button" name="back" id="back" class="newadd" value="Cancel" /></a>
                       <?

}

?>                     </td>

</tr>

</tr>

</table></td>

</tr>

</table>
                 </div>
                 
                 <?php
				 $arrText = mysql_fetch_assoc(mysql_query("select * from sat_email_template where id=3"));
				 ?>
				 <div id="div_add_project_ending" style="display:<?php if($_REQUEST['id']=="3"){ ?>block<?php }else{ ?>none<?php } ?>;">
                 <table height="161" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">

<tr>

<td align="center" valign="middle" colspan="5" height="10" class="head_text" >Manage Question Email Format</td>

</tr>

<td width="131" height="22" align="center" valign="top" class="head_text2">Subject </td>

<td align="left" valign="top"><input name="subject_project_ending" id="subject_project_ending" size="25" style="width:360px;" maxlength="255" type="text" value="<?php echo stripslashes($arrText['subject'])?>" class="validate[required] textfield" /></td>

</tr>
                   <tr class="smalltext">
                     <td height="22" align="center" valign="top" class="head_text2">Body</td>
                     <td align="left" valign="top" class="enquiery">:</td>
                     <td align="left" valign="top" class="etemp-editor"><textarea name="body_project_ending" id="body_project_ending" class="validate[required] textarea require_textarea"><?php echo htmlspecialchars_decode(stripslashes($arrText['body'])); ?></textarea></td>
                   </tr>

<tr>

<td valign="top" class="button" aign="left">
                       
                       <? if($_REQUEST['action']=="edit")

{

}

else

{

?>
                       
                       <input type="submit" name="add_project_ending" class="newadd" value="SAVE" border="0"  />
                       <a href="index.php"><input type="button" name="back" id="back" class="newadd" value="Cancel"  /></a>
                       <?

}

?>                     </td>

</tr>

</tr>

</table></td>

</tr>

</table>
                 </div>
                 
                 <?php
				 $arrText = mysql_fetch_assoc(mysql_query("select * from sat_email_template where id=4"));
				 ?>
				 <div id="div_add_payroll_system" style="display:<?php if($_REQUEST['id']=="4"){ ?>block<?php }else{ ?>none<?php } ?>;">
                 <table  height="161" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">

<tr>

<td align="center" valign="middle" colspan="5" height="10" class="head_text" >Manage Time Sheet with Attachment Email Format</td>

</tr>

<td width="131" height="22" align="center" valign="top" class="head_text2">Subject </td>

<td align="left" valign="top"><input name="subject_payroll" id="subject_payroll" size="25" style="width:360px;" maxlength="255" type="text" value="<?php echo stripslashes($arrText['subject'])?>" class="validate[required] textfield" /></td>

</tr>
                   <tr class="smalltext">
                     <td height="22" align="center" valign="top" class="head_text2">Body</td>
                     <td align="left" valign="top" class="enquiery">:</td>
                     <td align="left" valign="top" class="etemp-editor"><textarea name="body_payroll" id="body_payroll" class="validate[required] textarea require_textarea"><?php echo htmlspecialchars_decode(stripslashes($arrText['body'])); ?></textarea></td>
                   </tr>

<tr>

<td valign="top" class="button" aign="left">
                       
                       <? if($_REQUEST['action']=="edit")

{

?>
                       
                       <input type="submit" name="edit" class="newadd" value="EDIT" border="0"  />
                       <a href="email_template.php"><input type="button" name="back" id="back" class="newadd" value="Cancel" /></a>
                       <?

}

else

{

?>
                       
                       <input type="submit" name="add_payroll" class="newadd" value="SAVE" border="0"  />
                       <a href="index.php"><input type="button" name="back" id="back" class="newadd" value="Cancel" /></a>
                       <?

}

?>                     </td>

</tr>

</tr>

</table></td>

</tr>

</table>
                 </div>
                 
                 <?php
				 $arrText = mysql_fetch_assoc(mysql_query("select * from sat_email_template where id=5"));
				 ?>
				 <div id="div_add_supplemental_timesheet" style="display:<?php if($_REQUEST['id']=="5"){ ?>block<?php }else{ ?>none<?php } ?>;">
                 <table height="161" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">

<tr>

<td align="center" valign="middle" colspan="5" height="10" class="head_text" >Manage Forgot Password Email Format</td>

</tr>

<td width="131" height="22" align="center" valign="top" class="head_text2">Subject </td>

<td align="left" valign="top"><input name="subject_supplemental_timesheet" id="subject_supplemental_timesheet" size="25" style="width:360px;" maxlength="255" type="text" value="<?php echo stripslashes($arrText['subject'])?>" class="validate[required] textfield" /></td>

</tr>
                   <tr class="smalltext">
                     <td height="22" align="center" valign="top" class="head_text2">Body</td>
                     <td align="left" valign="top" class="enquiery">:</td>
                     <td align="left" valign="top" class="etemp-editor"><textarea name="body_supplemental_timesheet" id="body_supplemental_timesheet" class="validate[required] textarea require_textarea"><?php echo htmlspecialchars_decode(stripslashes($arrText['body'])); ?></textarea></td>
                   </tr>

<tr>

<td valign="top" class="button" aign="left">
                       
                       <? if($_REQUEST['action']=="edit")

{

}

else

{

?>
                       
                       <input type="submit" name="add_supplemental_timesheet" class="newadd" value="SAVE" border="0"  />
                       <a href="index.php"><input type="button" name="back" id="back" class="newadd" value="Cancel"  /></a>
                       <?

}

?>                     </td>

</tr>

</tr>

</table></td>

</tr>

</table>
                 </div>
                 
                 
                 <?php
				 $arrText = mysql_fetch_assoc(mysql_query("select * from sat_email_template where id=6"));
				 ?>
				 <div id="div_edit_staff" style="display:<?php if($_REQUEST['id']=="6"){ ?>block<?php }else{ ?>none<?php } ?>;">
                 <table width="90%" height="161" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">

<tr>

<td align="center" valign="middle" colspan="5" height="10" class="head_text" >Manage Staff Password Email Format</td>

</tr>

<td width="131" height="22" align="center" valign="top" class="head_text2">Subject </td>

<td align="left" valign="top"><input name="subject_staff_edit" id="subject_staff_edit" size="25" style="width:360px;" maxlength="255" type="text" value="<?php echo stripslashes($arrText['subject'])?>" class="validate[required] textfield" /></td>

</tr>
                   <tr class="smalltext">
                     <td height="22" align="center" valign="top" class="head_text2">Body</td>
                     <td align="left" valign="top" class="enquiery">:</td>
                     <td align="left" valign="top" class="etemp-editor"><textarea name="body_staff_edit" id="body_staff_edit" class="validate[required] textarea require_textarea"><?php echo htmlspecialchars_decode(stripslashes($arrText['body'])); ?></textarea></td>
                   </tr>

<tr>

<td valign="top" class="button" aign="left">
                       
                       <? if($_REQUEST['action']=="edit")

{

}

else

{

?>
                       
                       <input type="submit" name="add_staff_edit" class="newadd" value="SAVE" border="0"  />
                       <a href="index.php"><input type="button" name="back" id="back" class="newadd" value="Cancel" /></a>
                       <?

}

?>                     </td>

</tr>

</tr>

</table></td>

</tr>

</table>
                 </div>
                 
                 </td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

</table></td>

</tr>

</table>

</form>
<div class="clear"></div>
</div> 
<div class="clear"></div>
</div>

<?php include("includes/footer.php"); ?>