<?php
include_once "../includes/config.inc.php";
$customer_id = $_WGT['m_customer_id'];
$id = (int) $_REQUEST['id'];
$t = $_REQUEST['t'];
if ($t == 'single') {
$infocommonModel = new Model_InfoCommon();
$filter['where'] = " customer_id='{$customer_id}' and id='{$id}' ";
$sql = $infocommonModel->select($filter, '*');
$info = $infocommonModel->fetchRow($sql);
$info['info_intro'] = nl2br($info['info_intro']);
} elseif ($t == 'multi') {
$infocommondetailModel = new Model_InfoCommonDetail();
$filter['where'] = " id='{$id}' ";
$sql = $infocommondetailModel->select($filter, '*');
$info = $infocommondetailModel->fetchRow($sql);
$info['info_title'] = $info['title'];
$info['info_intro'] = nl2br($info['msg_content']);
$info['pic_showincontent'] = 1;
$info['info_pic'] = $info['pic'];
}
$customerModel = new Model_Customer();
$filter['where'] = " id='{$customer_id}' ";
$sql = $customerModel->select($filter, 'id,weixin_name');
$customerinfo = $customerModel->fetchRow($sql);
$smarty->assign("customerinfo", $customerinfo);
$smarty->assign("info", $info);
$smarty->assign("today", date("Y-m-d"));
$smarty->setLayout('')->setTpl('/mobile/templates/info.html')->display();
public function getMulti()
{
$i = 0;
$infocommonModel = new Model_InfoCommon();
$filter['where'] = " id='{$this->info_id}' and customer_id='{$this->customer_id}' and state='1' ";
$sql = $infocommonModel->select($filter);
$inforesult = $infocommonModel->fetchRow($sql);
if ($inforesult['id']) {
$sql = "update info_common set push_num=push_num+1 where id='" . $inforesult['id'] . "' limit 1";
$infocommonModel->query($sql);
$infocommondetailModel = new Model_InfoCommonDetail();
$filter['where'] = " info_common_id='" . $inforesult['id'] . "'";
$filter['order'] = " order_num asc ";
$sql = $infocommondetailModel->select($filter);
$inforesult2 = $infocommondetailModel->fetchAll($sql);
$infocount = count($inforesult2);
for ($i = 0; $i < $infocount; $i++) {
if (!$inforesult2[$i]['url']) {
$url = 'http://' . $_SERVER['HTTP_HOST'] . "/mobile/info.php?t=multi&id=" . $inforesult2[$i]['id'];
} else {
$url = $inforesult2[$i]['url'];
}
$itemlist .= "<item>\n\t\t\t <Title><![CDATA[" . $inforesult2[$i]['title'] . "]]></Title>\n\t\t\t <Description><![CDATA[" . $inforesult2[$i]['location_desc'] . "]]></Description>\n\t\t\t <PicUrl><![CDATA[http://" . $_SERVER['HTTP_HOST'] . "/data/image_c/" . $inforesult2[$i]['pic'] . "]]></PicUrl>\n\t\t\t <Url><![CDATA[{$url}]]></Url>\n\t\t\t </item>";
}
}
if ($i > 0) {
$Bodystr = "\n\t\t\t <ArticleCount>{$infocount}</ArticleCount>\n\t\t\t <Articles>\n\t\t\t {$itemlist}\n\t\t\t </Articles>";
$data['msgtype'] = 'news';
$data['bodystr'] = $Bodystr;
return $data;
}
}
$filter['where'] = "customer_id = '{$customer_id}' and msg_content!='subscribe' and msg_content!='unsubscribe' and msg_content!='' and create_date >= '{$start_date}'";
$filter['group'] = "msg_content";
$filter['order'] = "count_num desc";
$filter['limit'] = "0,100";
$sql = $messageModel->select($filter, 'count(id) as count_num,msg_content');
$topmessage = $messageModel->fetchAll($sql);
foreach ($topmessage as $key => $value) {
$topmessage[$key]['msg_content'] = cut_str($value['msg_content'], 6, $start = 0, $code = 'UTF-8');
}
$topmessage = array_slice($topmessage, 0, 10, true);
//互动内容统计
$infocommonModel = new Model_InfoCommon();
$filter = array();
$filter['where'] = "customer_id = '{$customer_id}' and state='1' ";
$filter['group'] = "info_type";
$sql = $infocommonModel->select($filter, 'count(id) as count_num,info_type');
$infocommonarray = $infocommonModel->fetchAll($sql);
foreach ($infocommonarray as $key => $value) {
$infocount[$value['info_type']] = $value['count_num'];
}
//图片统计
$infopicModel = new Model_InfoPic();
$filter = array();
$filter['where'] = "customer_id = '{$customer_id}'";
$infocount['pic'] = $infopicModel->count($filter);
//音乐统计
$infomusicModel = new Model_InfoMusic();
$filter = array();
$filter['where'] = "customer_id = '{$customer_id}'";
$infocount['music'] = $infomusicModel->count($filter);
//视频统计
