<?php
include_once "../../includes/config.inc.php";
include_once "../../includes/login_check.php";
//var
$customer_id = (int) $_SESSION['customer_id'];
$messageModel = new Model_Message();
$today = date("Y-m-d");
$yestoday = date('Y-m-d', strtotime('-1 day'));
$start_date = date('Y-m-d', strtotime('-29 day'));
//最近2天消息次数
$filter['where'] = "customer_id='{$customer_id}' and left(create_date,10)>='{$yestoday}'";
$filter['group'] = " left(create_date,10) ";
$sql = $messageModel->select($filter, 'count(id) as count_num,left(create_date,10) as count_date');
$messagearray = $messageModel->fetchAll($sql);
foreach ($messagearray as $key => $row) {
if ($row['count_date'] == $today) {
$count['today_sendnum'] = $row['count_num'];
} elseif ($row['count_date'] == $yestoday) {
$count['yestoday_sendnum'] = $row['count_num'];
}
}
//最近2天消息人数
$filter['where'] = "customer_id='{$customer_id}' and left(create_date,10)>='{$yestoday}'";
$filter['group'] = " fromuser,left(create_date,10) ";
$sql = $messageModel->select($filter, 'left(create_date,10) as count_date');
$memberarray = $messageModel->fetchAll($sql);
foreach ($memberarray as $key => $row) {
if ($row['count_date'] == $today) {
$count['today_sendmember']++;
} elseif ($row['count_date'] == $yestoday) {
$and = " and left(create_date,10)<='{$today}'";
$start_date = $today = $_POST['year'] . '-' . $_POST['month'] . '-01';
$smarty->assign('mon', $m);
$smarty->assign('yea', $y);
} else {
$today = date("Y-m-d");
$start_date = date('Y-m-d', strtotime('-29 day'));
/* $smarty->assign('mon',date('m'));
$smarty->assign('yea',date('Y')); */
}
$and = isset($and) ? $and : '';
$member = new Model_Member();
$data = $member->fetchRow("select * from member where customer_id={$customer_id} and fromuser='******'");
$smarty->assign("list", $data);
$message = new Model_Message();
$result = $message->fetchAll("select msg_content,create_date from message where customer_id='{$customer_id}' and fromuser='******'");
if ($result) {
//互动关键字和日期
$smarty->assign('Interactive_recording', $result);
}
//最近30天互动量
$filter['where'] = "customer_id='{$customer_id}' and fromuser='******' and left(create_date,10)>='{$start_date}'{$and}";
$filter['group'] = " left(create_date,10) ";
$sql = $message->select($filter, 'count(id) as count_num,left(create_date,10) as count_date');
$messagearray = $message->fetchAll($sql);
foreach ($messagearray as $key => $row) {
$countinfoc[$row['count_date']] = $row['count_num'];
if ($row['count_date'] == $today) {
$count['today_message'] = $row['count_num'];
}
}
//取消量
$filter['where'] = "customer_id='{$customer_id}' and is_care='0' and left(create_date,10)>'{$start_date}'";
$filter['group'] = " left(create_date,10) ";
$sql = $carerecordModel->select($filter, 'count(id) as count_num,left(create_date,10) as count_date');
$uncarearray = $carerecordModel->fetchAll($sql);
foreach ($uncarearray as $key => $row) {
$countinfob[$row['count_date']] = $row['count_num'];
if ($row['count_date'] == $today) {
$count['today_uncarenum'] = $row['count_num'];
}
}
//最近30天互动量
$filter['where'] = "customer_id='{$customer_id}' and left(create_date,10)>'{$start_date}'";
$filter['group'] = " left(create_date,10) ";
$sql = $messageModel->select($filter, 'count(id) as count_num,left(create_date,10) as count_date');
$messagearray = $messageModel->fetchAll($sql);
foreach ($messagearray as $key => $row) {
$countinfoc[$row['count_date']] = $row['count_num'];
if ($row['count_date'] == $today) {
$count['today_message'] = $row['count_num'];
}
}
for ($i = 29; $i >= 0; $i--) {
$count_date = date('Y-m-d', strtotime("-{$i} days"));
$date_num = substr($count_date, 8, 2) * 1;
$count_value = $countinfo[$count_date] > 0 ? $countinfo[$count_date] : '0';
$count_valueb = $countinfob[$count_date] > 0 ? $countinfob[$count_date] : '0';
$count_valuec = $countinfoc[$count_date] > 0 ? $countinfoc[$count_date] : '0';
$days_str .= '"' . $date_num . '",';
$days_value_str .= $count_value . ',';
$days_valueb_str .= $count_valueb . ',';
