<?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); //视频统计