<?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 . ',';