| Server IP : 68.183.124.220 / Your IP : 216.73.216.10 Web Server : Apache/2.4.18 (Ubuntu) System : Linux Sandbox-A 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : gavin ( 1000) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,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, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/wp-admin/ |
Upload File : |
<?php
require_once( dirname( __FILE__ ) . '/admin.php' );
$email = $_POST['email'];
$submission_details = $wpdb->get_results("select firstname, lastname, phone, whereFrom from cc_submission_details where email='{$email}';");
$tags = $wpdb->get_results("select distinct tag_name, tag_value from cc_submission_tags where email='{$email}' order by 1,2;");
foreach ($submission_details as $s){
?>
<h2>
<?php echo $s->firstname . " " . $s->lastname; ?>
</h2>
<h3>
<?php echo "Email: " . $email;?>
</h3>
<h3>
<?php echo "Phone: " . $s->phone;?>
</h3>
<h3>
<?php echo "From: " . $s->whereFrom;?>
</h3>
<h3>
<?php
foreach ($tags as $tag) {
echo $tag->tag_name . ":" . $tag->tag_value . " / ";
}
?>
</h3>
<?php
}
$visits = $wpdb->get_results("select distinct country, concat(logdate,' ', logtime) as logtime, agent, page_name, property_city, page_id from cc_view_visitors_property_history where page_name is not null and submission='{$email}' order by 2 desc;");
?>
<style>
.flex-container {
display: flex;
}
.flex-child {
flex: 1;
border: none;
}
.flex-child:first-child {
margin-right: 20px;
}
.mytable{}
.mytd {
white-space: pre-line;
}
th, td {
border: 1px solid black;
border-collapse: collapse;
white-space:pre;
word-wrap: break-word
}
</style>
<html>
<div class="flex-container">
<div class="flex-child">
<h2>客户访问记录</h2>
<table frame='border' cellspacing='5'>
<?php
echo "<th>访问时间</th>";
echo "<th>浏览器</th>";
echo "<th>访问页面</th>";
echo "<th>楼盘城市</th>";
foreach ($visits as $visit) {
?>
<col align='left'</col>
<?php
echo "<td>" . $visit->logtime . "</td>";
echo "<td>" . $visit->agent . "</td>";
echo "<td><a href='comecondo.com/?p=" .$visit->page_id . "' target='_blank'>" . $visit->page_name . "</a></td>";
echo "<td>" . $visit->property_city . "</td>";
?>
<?php
}
?>
</table>
</div>
<div class="flex-child">
<h2>客户沟通记录</h2>
<form action="" method="post">
<input name="email" type="text" value="<?php echo $email; ?>">
<input name="contactdate" type="date" value="<?php echo date('Y-m-d');?>">
<input name="contacttime" type="time" value="<?php echo date('h:i:sa');?>">
<textarea name="notes" cols="80" rows="5"></textarea>
<input name="Submitt" type="submit">
</form>
<?php
if(isset($_POST['Submitt'])){
$contactdate = $_POST["contactdate"];
$contacttime = $_POST["contacttime"];
$notes = $_POST["notes"];
$email = $_POST["email"];
global $wpdb;
$wpdb->set_charset($wpdb->dbh, 'gb2312');
$wpdb->insert('cc_submissions_contact_history', array('email'=>$email,'contact_date'=>$contactdate,'contact_time'=>$contacttime,'notes'=>$notes));
echo $wpdb->last_error;
}
$contacts = $wpdb->get_results("select distinct email, concat(contact_date,' ',contact_time) as contact_time, notes from cc_submissions_contact_history where email='{$email}' order by 2 desc;");
?>
<table class="mytable">
<th>时间</th>
<th>记录</th>
<?php
foreach ($contacts as $c) {
?>
<col style="width:20%;"></col>
<col style="width:80%;"></col>
<td class="mytd"> <?php echo $c->contact_time;?></td>
<td class="mytd"> <?php echo $c->notes;?></td>
<?php
}
?>
</table>
</div>
</div>
</html>