| Server IP : 127.0.0.2 / Your IP : 3.147.28.162 Web Server : Apache/2.4.18 (Ubuntu) System : User : www-data ( ) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : disk_free_space,disk_total_space,diskfreespace,dl,exec,fpaththru,getmyuid,getmypid,highlight_file,ignore_user_abord,leak,listen,link,opcache_get_configuration,opcache_get_status,passthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,php_uname,phpinfo,posix_ctermid,posix_getcwd,posix_getegid,posix_geteuid,posix_getgid,posix_getgrgid,posix_getgrnam,posix_getgroups,posix_getlogin,posix_getpgid,posix_getpgrp,posix_getpid,posix,_getppid,posix_getpwnam,posix_getpwuid,posix_getrlimit,posix_getsid,posix_getuid,posix_isatty,posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid,posix_setpgid,posix_setsid,posix_setuid,posix_times,posix_ttyname,posix_uname,pclose,popen,proc_open,proc_close,proc_get_status,proc_nice,proc_terminate,shell_exec,source,show_source,system,virtual MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/admin/ |
Upload File : |
<?php
ob_start();
session_start();
require_once('session-check.php');
require_once('include/db-config.php');
$messagetype = "";
$emailtitle = "";
$fromemail = "";
$content = "";
$FieldName = "";
$id = "";
$filterby = "";
$filename = "";
// getting message details based on the selection
$sql = "select ID, EmailTitle, MessageType, EmailText, SendDate, FromEmailID, IsDelete from maintrainer_emailmessage where ID = 979879797998797";
if($_GET)
{
$sql = "select ID, FileName, EmailTitle, MessageType, EmailText, SendDate, FromEmailID, IsDelete from maintrainer_emailmessage where ID = ".$_GET['id'];
$id = $_GET['id'];
}
else
{
$sql = "select ID, FileName, EmailTitle, MessageType, EmailText, SendDate, FromEmailID, IsDelete from maintrainer_emailmessage where ID = ".$_POST['id'];
$id = $_POST['id'];
}
//echo $sql;
$result=mysqli_query($conn,$sql);
if($row=mysqli_fetch_array($result))
{
$messagetype = $row['MessageType'];
if($messagetype == "plain")
$messagetype = "Plain Text";
else
$messagetype = "HTML Text";
$emailtitle = $row['EmailTitle'];
$fromemail = $row['FromEmailID'];
$content = $row['EmailText'];
$filename = $row['FileName'];
}
// fiter option
$sql = "select distinct Country AS FieldName from maintrainer_emaildetails where Country = 'asfdjaslfsafsdfafsafsad' order by Country";
if($_POST)
{
$filterby = $_POST['filterby'];
//echo $filterby;
if($filterby == "All")
{
$sql = "select distinct Country AS FieldName from maintrainer_emaildetails where Country = 'asfdjaslfsafsdfafsafsad' order by Country";
}
else if($filterby == "Country")
{
$sql = "select distinct Country AS FieldName from maintrainer_emaildetails where Country <> '' order by Country";
}
else if($filterby == "State")
{
$sql = "select distinct State AS FieldName from maintrainer_emaildetails where State <> '' order by State";
}
else if($filterby == "City")
{
$sql = "select distinct City AS FieldName from maintrainer_emaildetails where City <> '' order by City";
}
else if($filterby == "Company")
{
$sql = "select distinct CompanyName AS FieldName from maintrainer_emaildetails where CompanyName <> '' order by CompanyName";
}
else if($filterby == "Title")
{
$sql = "select distinct Title AS FieldName from maintrainer_emaildetails where Title <> '' order by Title";
}
else if($filterby == "Person")
{
$sql = "select distinct EmailID AS FieldName from maintrainer_emaildetails where Status = 1 and EmailID <> '' order by EmailID";
}
}
//echo $sql;
$result=mysqli_query($conn,$sql);
?>
<!DOCTYPE html> <HTML>
<HEAD>
<TITLE>Joel Levitt, maintenance management, maintenance management consulting, tpms</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<script language="JavaScript">
function validateform()
{
if (document.getElementById("filterby").selectedIndex == 0 )
{
alert("Please select To Address");
document.getElementById("filterby").focus();
return false;
}
if (document.getElementById("filterby").selectedIndex == 2 && document.getElementById("emailids").selectedIndex == 0)
{
alert("Please select Country Name");
document.getElementById("emailids").focus();
return false;
}
if (document.getElementById("filterby").selectedIndex == 3 && document.getElementById("emailids").selectedIndex == 0)
{
alert("Please select State Name");
document.getElementById("emailids").focus();
return false;
}
if (document.getElementById("filterby").selectedIndex == 4 && document.getElementById("emailids").selectedIndex == 0)
{
alert("Please select City Name");
document.getElementById("emailids").focus();
return false;
}
if (document.getElementById("filterby").selectedIndex == 5 && document.getElementById("emailids").selectedIndex == 0)
{
alert("Please select Company Name");
document.getElementById("emailids").focus();
return false;
}
if (document.getElementById("filterby").selectedIndex == 6 && document.getElementById("emailids").selectedIndex == 0)
{
alert("Please select Title Name");
document.getElementById("emailids").focus();
return false;
}
if (document.getElementById("filterby").selectedIndex == 7 && document.getElementById("emailids").selectedIndex == 0)
{
alert("Please select Email ID");
document.getElementById("emailids").focus();
return false;
}
document.form.action = "email-send-action.php";
this.form.submit();
return true;
}
</script>
<link href="css/style.css" type="text/css" rel="stylesheet">
</HEAD>
<BODY BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<!-- ImageReady Slices (maintrainer_slice2.jpg) -->
<TABLE WIDTH="100%" BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center">
<?php include_once('include/include_header.php'); ?>
<TR>
<TD width="100%" align="center">
<table border="0" cellpadding="0" cellspacing="0" width="1100" align="center" class="body_bg" style="border-color:">
<tr><td colspan="3" style="height:9px;"></td></tr>
<tr>
<td style="width:9px;"></td>
<td class="content_bg" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="95%" align="center">
<tr>
<td style="height:40px;">
</td>
</tr>
<tr>
<td>
<form action="email-send.php" method="post" enctype="multipart/form-data" id="form" name="form" onSubmit="return validateform();">
<table border="0" cellpadding="0" cellspacing="0" class="normal_text">
<tr><td class="mainhead" valign="top" colspan="2">SEND EMAIL</td></tr>
<tr><td style="height:10px;"></td></tr>
<tr>
<td class="normal_text" style="padding-left:20px; padding-right:10px;" valign="top" width="100">Subject</td>
<td class="normal_text"><?php echo $emailtitle; ?>
</tr>
<tr><td style="height:20px;"></td></tr>
<tr>
<td class="normal_text" style="padding-left:20px; padding-right:10px;" valign="top" width="100">From</td>
<td class="normal_text"><?php echo $fromemail; ?>
</tr>
<tr><td style="height:20px;"></td></tr>
<tr>
<td class="normal_text" style="padding-left:20px; padding-right:10px;" valign="top" width="100">Content</td>
<td>
<div style="width:800px;height:200px;overflow: auto; border:solid; border-width:1px; border-color:#CCCCCC; background-color:#999999;"><?php if($messagetype == 'Plain Text') echo nl2br($content); else echo $content;?></div>
</td>
</tr>
<tr><td style="height:20px;"></td></tr>
<tr>
<td class="normal_text" style="padding-left:20px; padding-right:10px;" valign="top" width="100">Attachment</td>
<td class="normal_text"><?php echo $filename; ?>
</tr>
<tr><td style="height:20px;"></td></tr>
<tr>
<td class="normal_text" style="padding-left:20px; padding-right:10px;" valign="top" width="100">To</td>
<td>
<select id="filterby" name="filterby" onChange="this.form.submit();">
<option></option>
<option value="All" <?php if($filterby == 'All') echo 'selected'; ?>>All</option>
<option value="Country" <?php if($filterby == 'Country') echo 'selected'; ?>>Country Based</option>
<option value="State" <?php if($filterby == 'State') echo 'selected'; ?>>State Based</option>
<option value="City" <?php if($filterby == 'City') echo 'selected'; ?>>City Based</option>
<option value="Company" <?php if($filterby == 'Company') echo 'selected'; ?>>Company Name</option>
<option value="Title" <?php if($filterby == 'Title') echo 'selected'; ?>>Title</option>
<option value="Person" <?php if($filterby == 'Person') echo 'selected'; ?>>Person</option>
</select>
<select id="emailids" name="emailids">
<option></option>
<?php
while($row=mysqli_fetch_array($result))
{
echo "<option>".$row['FieldName']."</option>";
}
?>
</select>
</td>
</tr>
<tr><td style="height:5px;"></td></tr>
<tr>
<td class="normal_text" style="padding-left:20px; padding-right:10px;" valign="top" width="100"></td>
<td>
<input type="checkbox" name="sendfailed" id="sendfailed" value="1" checked>
Send email to those who have not received this email or Failed execution earlier.
</td>
</tr>
<tr><td style="height:20px;"></td></tr>
<tr>
<td class="normal_text"> </td>
<td><input type="submit" id="save" name="save" value="Submit" class="bttn">
<input type="button" id="back" name="back" value="Cancel" class="bttn2" onClick="javascript:history.back();">
</td>
</tr>
<tr><td><br><br></td></tr>
</table>
<input type="hidden" name="id" id="id" value="<?php echo $id; ?>">
</form>
</td>
</tr>
</table>
</td>
<td style="width:9px;"></td>
</tr>
<tr><td colspan="3" style="height:9px;"></td></tr>
</table>
</TD>
</TR>
<?php include_once('include/include_footer.php'); ?>
</TABLE>
<!-- End ImageReady Slices -->
</BODY>
</HTML>