/** * addProductAuthorize 添加产品授权书 */ public function addProductAuthorize() { /** * 获取拥有产品的品牌 * @author 蒋东芸 * 修改日期:2014/7/28 */ $Model = new \Think\Model(); //实例化空模型 $ecid = session($this->_userCfg['ECID']); $opt = "brand.ecid = {$ecid} AND brand.id = product.brandId"; //获取品牌 $brand = $Model->field("brand.id,brand.name")->table(array('sz12365_fw_company_brand' => 'brand', 'sz12365_fw_company_product' => 'product'))->where($opt)->group('brand.name')->select(); //获取经销商 if (session($this->_userCfg['DEALERID'])) { $opt['id|root'] = session($this->_userCfg['DEALERID']); } $dealer = M("Company_dealers")->where($opt)->order('id desc')->select(); $this->assign("brand", $brand); $this->assign("dealerResult", $dealer); $this->assign("dealerSelect", $dealer); $this->assign("todayDate", date("Y-m-d")); $this->display(); }
public function shareList() { $sharePrize = M('Company_lucky_prize')->where("activityId = '" . I('post.activityId') . "'")->select(); $Model = new \Think\Model(); //实例化空模型 $ecid = M('Company_activity')->where("id = '" . I('post.activityId') . "'")->getField('ecid'); $newsId = I('post.newsId'); $opt = " log.type = 2 AND log.newsId = {$newsId} AND users.nickname IS NOT NULL AND log.fromOpenId = users.openId AND log.newsId = news.id"; if (I('post.startTime') != '' && I('post.endTime') != '') { $startTime = I('post.startTime'); $endTime = date("Y-m-d H:i:s", strtotime(I('post.endTime'))); $opt .= " AND (log.time >'" . $startTime . "' and log.time <'" . $endTime . "')"; } $count = $Model->query("\n SELECT COUNT(*) \n FROM (\n SELECT count(*) as num,log.fromOpenId,users.nickname,users.id as userId \n FROM `sz12365_fw_news_view_log` `log`,`sz12365_fw_company_news` `news`,`sz12365_fw_company_{$ecid}_user_info` `users` \n WHERE ( {$opt} ) \n GROUP BY log.fromOpenId\n ) \n tp_count\n "); // 查询满足要求的总记录数 $page = new \Think\Page($count[0]['COUNT(*)'], 10); // 实例化分页类 传入总记录数 $show = $page->show(); // 分页显示输出 // 进行分页数据查询 $result = $Model->field('count(*) as num,log.fromOpenId,users.nickname,users.id as userId,log.time')->table(array('sz12365_fw_news_view_log' => 'log', 'sz12365_fw_company_news' => 'news', 'sz12365_fw_company_' . $ecid . '_user_info' => 'users'))->where($opt)->order('num desc')->group('log.fromOpenId')->limit($page->firstRow . ',' . $page->listRows)->select(); for ($i = 0; $i < count($result); $i++) { $option = "userId = '" . $result[$i]['fromOpenId'] . "' AND activityId = " . I('post.activityId'); $res = M('Company_lucky_user')->where($option)->find(); if ($res) { $result[$i]['luckyTime'] = $res['luckyTime']; } } $this->assign('startTime', I('post.startTime')); $this->assign('endTime', I('post.endTime')); $this->assign('logInfo', $result); $this->assign('sharePrize', $sharePrize); $this->assign('activityId', I('post.activityId')); $this->assign('ecid', $ecid); $this->assign('newsId', I('post.newsId')); $this->assign('page', $show); // 赋值分页输出 $this->display(); }
/** * 获取二维码统计详情 * @author 蒋东芸 * 2014/5/15 */ public function qrCodeList() { $ecid = session($this->_userCfg['ECID']); //获取企业id $Model = new \Think\Model(); //实例化空模型 //获取起始日期和截至日期 if ($_POST['startTime'] == '' || $_POST['endTime'] == '') { $startDate = date("Y-m-d", strtotime("-1 week")); $endDate = date("Y-m-d", strtotime("-1 day")); } else { $startDate = I('post.startTime'); $endDate = I('post.endTime'); } $type = I('post.typeName'); //获取post传递过来的类型值 $opt = $this->qrCodeTypeDetail($type, $ecid, $startDate, $endDate); //将获取二维码类型名称的条件数组赋值 $count = $Model->field($opt['field'])->table($opt['table'])->where($opt['option'])->count(); //计算行数 $page = new \Think\Page($count, 15); // 实例化分页类 传入总记录数 $show = $page->show(); // 分页显示输出 // 进行分页数据查询 $result = $Model->field($opt['field'])->table($opt['table'])->where($opt['option'])->limit($page->firstRow . ',' . $page->listRows)->select(); if ($type == 'all' || $type == '') { for ($i = 0; $i < count($result); $i++) { $result[$i]['name'] = $this->qrCodeTypeHandle($result[$i]['type']); } } $this->assign('qrCodeList', $result); $this->assign('page', $show); $this->display(); }