<hmtl>
<?php
require_once( dirname( __FILE__ ) . '/admin.php' );

$email = $_POST['email'];
$submission_details = $wpdb->get_results("select firstname, lastname, phone, whereFrom, most_recent_status 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  echo "Status: " . $s->most_recent_status;?>
    </h3>
    <h3>
<?php
    foreach ($tags as $tag) {
        echo $tag->tag_name . ":" . $tag->tag_value . " / ";
    }
 ?>
    </h3>
<?php
}
?>
<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>

 <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>
<h2>更新客户状态</h2>
<form action="" method="post">
<input name="email" type="text" value="<?php echo $email; ?>">
<select name="most_recent_status" id="most_recent_status"><option value="New">新客户</option><option value="Call Later">后续电话</option><option value="Email Sent">已发邮件</option><option value="Email Received">收到邮件</option><option value="Called">已电话沟通</option><option value="Call Not Answered">未接电话</option><option value="Zummby">变成僵尸</option></select>
<input name="NewStatusSubmit" class="head_div" type="submit" value="更新">
</form>
<?php
if(isset($_POST['NewStatusSubmit'])){
    $new_status = $_POST["most_recent_status"];
    echo $new_status;
    $wpdb->update('cc_submission_details', ['most_recent_status'=>$new_status], ['email'=>$email]);
}
?>
</div>
</html>