/**
* 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();
}
