| Server IP : 127.0.0.2 / Your IP : 3.128.168.155 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');
$source = isset($_GET['source']) ? $_GET['source'] : '';
$updated_on = isset($_GET['updated_on']) ? $_GET['updated_on'] : '';
function fetchFilteredData($conn, $source, $updated_on) {
$sourceCondition = ($source != '') ? "Source = '{$source}'" : '1=1';
$formattedDate = $updated_on ? date('Y-m-d', strtotime($updated_on)) : '';
var_dump($formattedDate);
$sql = "
SELECT * FROM (
(SELECT ID, Name, EmailID, Company AS Organization, StreetAddress AS Address, City, State, Zip, Country, '' AS Phone, '' AS Fax, Comments, TrainingNeeds AS InterestedIn, Books AS ExtraField1, BookSentOn AS ExtraField2, '' AS PreferredContactMethod, IPAddress, CreatedDate, EditedDate, 'Book Request' AS Source
FROM maintrainer_book_form
WHERE 1=1)
UNION ALL
(SELECT ID, Name, EmailID, Company AS Organization, Address AS StreetAddress, City, State, Zip, '' AS Country, '' AS Phone, '' AS Fax, Comment AS Comments, '' AS InterestedIn, '' AS ExtraField1, '' AS ExtraField2, PreferredContactMethod, IPAddress, CreatedDate, EditedDate, 'Contact Us' AS Source
FROM maintrainer_contact_us
WHERE 1=1)
UNION ALL
(SELECT ID, Name, EmailID, Organization, Address, City, State, Zip, '' AS Country, Phone, Fax, Comment AS Comments, InterestedIn, '' AS ExtraField1, '' AS ExtraField2, PreferredContactMethod, IPAddress, CreatedDate, EditedDate, 'Enquiry Form' AS Source
FROM maintrainer_enquiry_form
WHERE 1=1)
) AS combined_results
WHERE 1=1" . ($source ? " AND Source = '{$source}'" : "") . ($formattedDate ? " AND DATE(EditedDate) = '{$formattedDate}'" : "") . "
ORDER BY EditedDate DESC";
$result = mysqli_query($conn, $sql);
if (!$result) {
die('Error executing query: ' . mysqli_error($conn));
}
$data = array();
while ($row = mysqli_fetch_assoc($result)) {
$data[] = $row;
}
return $data;
}
$data = fetchFilteredData($conn, $source, $updated_on);
?>
<!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">
<link href="css/style.css" type="text/css" rel="stylesheet">
<style type="text/css">
table { color: #FFFFFF; font-family: Arial, Verdana }
.normal { background-color: #323232 }
.normalActive { background-color:#000000;}
@media (min-width: 600px) and (max-width:1500px)
{
#media {
padding-left: 12px;
padding-right: 12px;
}
}
.tabletext{
padding-left: 0px !important;
}
</style>
</HEAD>
<BODY BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<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" align="center" class="body_bg" id="media" style="">
<tr><td colspan="17" 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;">
<?php
if(isset($_GET['r'])) {
if($_GET['r'] == '1') {
echo "<font class='success-text'><b>You have successfully inserted a new record.</b></font>";
} else if($_GET['r'] == '2') {
echo "<font class='success-text'><b>You have successfully updated the details.</b></font>";
} else if($_GET['r'] == '0') {
echo "<font class='error-text'><b>You have successfully deleted a record.</b></font>";
}
}
?>
</td>
</tr>
<!-- Combined Data Table -->
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td class="mainhead" valign="top" align="left" width="50%"style="padding-bottom: 10px;">LIST OF ALL FORM DATA</td>
<td align="right" class="export_link" width="50%">
<a href="Book-Contact-Enquiry-Export.php?export=xls"><b style="color:white;">EXPORT DATA</b></a>
</td>
</tr>
<tr>
<td colspan="2">
<form action="Book-Contact-Enquiry-mgt.php" method="get">
<label for="source">Select Type:</label>
<select name="source" id="source">
<option value="">All</option>
<option value="Book Request" <?php if ($source == 'Book Request') echo 'selected'; ?>>Book Request</option>
<option value="Contact Us" <?php if ($source == 'Contact Us') echo 'selected'; ?>>Contact Us</option>
<option value="Enquiry Form" <?php if ($source == 'Enquiry Form') echo 'selected'; ?>>Enquiry Form</option>
</select>
<label for="updated_on">Updated Date:</label>
<input type="date" id="updated_on" name="updated_on" value="<?php echo isset($_GET['updated_on']) ? $_GET['updated_on'] : ''; ?>">
<button type="submit" style="background-color:#990000;"><b style="color:white;">Filter</b></button>
</form>
</td>
</tr>
<tr><td height="10"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%" align="center" class="normal_text">
<tr>
<td class="tablehead"><strong>Sl#</strong></td>
<td class="tablehead"><strong>Type</strong></td>
<td class="tablehead"><strong>Name</strong></td>
<td class="tablehead"><strong>EmailID</strong></td>
<td class="tablehead"><strong>Company</strong></td>
<td class="tablehead"><strong>Street Address</strong></td>
<td class="tablehead"><strong>City</strong></td>
<td class="tablehead"><strong>State</strong></td>
<td class="tablehead"><strong>Zip</strong></td>
<td class="tablehead"><strong>Country</strong></td>
<td class="tablehead"><strong>Phone</strong></td>
<td class="tablehead"><strong>Fax</strong></td>
<td class="tablehead"><strong>Comments</strong></td>
<td class="tablehead"><strong>Training Needs / Interested In</strong></td>
<td class="tablehead"><strong>Books</strong></td>
<td class="tablehead"><strong>Book Sent On</strong></td>
<td class="tablehead"><strong>Preferred Contact</strong></td>
<td class="tablehead"><strong>IPAddress</strong></td>
<td class="tablehead"><strong>Updated Date</strong></td>
<td class="tablehead" align="right"><strong>Options</strong></td>
</tr>
<?php
$i = 0;
foreach ($data as $row) {
$ID = $row['ID'];
$Name = $row['Name'];
$EmailID = $row['EmailID'];
$Organization = $row['Organization'];
$Address = $row['Address'];
$City = $row['City'];
$State = $row['State'];
$Zip = $row['Zip'];
$Country = $row['Country'];
$Phone = $row['Phone'];
$Fax = $row['Fax'];
$Comments = $row['Comments'];
$InterestedIn = $row['InterestedIn'];
$Books = $row['ExtraField1'];
$BookSentOn = !empty($row['ExtraField2']) ? date('M-d-y', strtotime($row['ExtraField2'])) : "";
$PreferredContactMethod = $row['PreferredContactMethod'];
$IPAddress = $row['IPAddress'];
$EditedDate = date('M-d-y', strtotime($row['CreatedDate']));
$Source = $row['Source']; // 'Book Request', 'Contact Us', or 'Enquiry Form'
?>
<tr onMouseOver="this.className='normalActive'" onMouseOut="this.className='normal'" class="normal">
<td class="tabletext"><?php echo ++$i; ?></td>
<td class="tabletext"><?php echo $Source; ?></td>
<td class="tabletext"><?php echo $Name; ?></td>
<td class="tabletext"><?php echo $EmailID; ?></td>
<td class="tabletext"><?php echo $Organization; ?></td>
<td class="tabletext"><?php echo $Address; ?></td>
<td class="tabletext"><?php echo $City; ?></td>
<td class="tabletext"><?php echo $State; ?></td>
<td class="tabletext"><?php echo $Zip; ?></td>
<td class="tabletext"><?php echo $Country; ?></td>
<td class="tabletext"><?php echo $Phone; ?></td>
<td class="tabletext"><?php echo $Fax; ?></td>
<td class="tabletext"><?php echo $Comments; ?></td>
<td class="tabletext"><?php echo $InterestedIn; ?></td>
<td class="tabletext"><?php echo $Books; ?></td>
<td class="tabletext"><?php echo $BookSentOn; ?></td>
<td class="tabletext"><?php echo $PreferredContactMethod; ?></td>
<td class="tabletext"><?php echo $IPAddress; ?></td>
<td class="tabletext"><?php echo $EditedDate; ?></td>
<td align="right" class="edit-del-link">
<?php if ($Source == 'Book Request') { ?>
<a href="Book-Request-edit.php?id=<?php echo $ID; ?>">edit</a> |
<a onClick="return confirm('Are you sure you want to delete?')" href="Book-Request-delete.php?id=<?php echo $ID; ?>">delete</a>
<?php } elseif ($Source == 'Contact Us') { ?>
<a href="Contact-Us-edit.php?id=<?php echo $ID; ?>">edit</a> |
<a onClick="return confirm('Are you sure you want to delete?')" href="Contact-Us-delete.php?id=<?php echo $ID; ?>">delete</a>
<?php } elseif ($Source == 'Enquiry Form') { ?>
<a href="Enquiry-Form-edit.php?id=<?php echo $ID; ?>">edit</a> |
<a onClick="return confirm('Are you sure you want to delete?')" href="Enquiry-Form-delete.php?id=<?php echo $ID; ?>">delete</a>
<?php } ?>
</td>
</tr>
<tr class="normal">
<td colspan="20" class="tableline"></td>
</tr>
<?php
}
?>
<tr><td><br><br></td></tr>
</table>
</td>
</tr>
</table>
</td>
<td style="width:9px;"></td>
</tr>
<tr><td colspan="17" style="height:9px;"></td></tr>
</table>
</TD>
</TR>
<?php include_once('include/include_footer.php'); ?>
</TABLE>
</BODY>
</HTML>