public function lists() { $cls_db = M('Classify'); $cls_id = $this->_get('classid', 'intval'); $classify = $cls_db->where(array('token' => $this->token, 'status' => 1, 'id' => $cls_id))->order('sorts desc')->find(); if ($classify == false) { exit; } $this->assign('classify', $classify); //父分类 $parent_cls = $cls_db->where(array('token' => $this->token, 'status' => 1, 'parent' => 0))->order('sorts desc')->select(); $this->assign('info', $this->contructClassifyHyperLinks($parent_cls)); $this->assign('tpl', $this->tpl); $this->assign('token', $this->token); $p = $this->_get('p', 'intval', 1); if ($classify['linktype'] == 'articles') { $where['token'] = $this->token; $where['c_id'] = $this->_get('classid', 'intval'); $where['status'] = 1; $db = D('Article'); $count = $db->where($where)->count(); $this->assign('page', ceil($count / 5)); $this->assign('p', $p); $articles = $db->where($where)->page($p . ',5')->order('sorts desc')->select(); //文章详细中含有html标签,需要去掉,并裁剪长度 foreach ($articles as $key => $a) { if (!empty($articles[$key]['content'])) { $articles[$key]['content'] = $this->remove_html_tag($articles[$key]['content']); $articles[$key]['content'] = my_cus_substr(htmlspecialchars($articles[$key]['content']), 66); } } $this->assign('res', $this->contructArticleHyperLinks($articles)); } else { if ($classify['linktype'] == 'subClassifies') { $where['token'] = $this->token; $where['parent'] = $cls_id; $where['status'] = 1; $count = $cls_db->where($where)->count(); $this->assign('page', ceil($count / 10)); $this->assign('p', $p); $sub_cls = $cls_db->where($where)->field("id,name as title,img as pic, info as content, parent,token,linktype,link_param_l1,link_param_l2")->page($p . ',10')->order('sorts desc')->select(); $this->assign('res', $this->contructClassifyHyperLinks($sub_cls)); } } $this->assign('wecha_id', $this->wecha_id); // genereate navigation link $navigationLink = "http://api.map.baidu.com/marker?location=" . $this->tpl['latitude'] . ',' . $this->tpl['longtitude'] . '&title=' . urlencode($this->tpl['company']) . '&name=' . urlencode($this->tpl['company']) . '&content=' . urlencode($this->tpl['address']) . '&output=html&src=lingzhtech'; $this->assign('navigationLink', $navigationLink); $this->display($classify['tmpl']); }
private function getOrderDesc($order_id) { $products = M('b2c_order_item')->join('inner join tp_b2c_product p on tp_b2c_order_item.product_id = p.product_id')->where(array('tp_b2c_order_item.order_id' => $order_id))->field('p.name product_name')->select(); if (count($products) > 0) { $desc = ''; foreach ($products as $key => $v) { $desc .= $v['product_name'] . ' ;'; } return trim(my_cus_substr($desc, 110), " ;"); } else { return '订单' . $order_id; } }