public function score_list()
{
$ScorenoteModel = new \Common\Model\ScorenoteModel();
$uid = $this->uid;
$where['id'] = array("GT", 0);
$where['uid'] = $uid;
$count = $ScorenoteModel->where($where)->count();
$size = 15;
//每页显示条数
$Page = new \Think\Page($count, $size);
$pages = $Page->show();
// 分页显示输出
$list = $ScorenoteModel->where($where)->limit($Page->firstRow . ',' . $Page->listRows)->select();
$this->assign("list", $list);
$this->assign("count", $count);
$this->assign("start", $Page->firstRow);
$this->assign("end", $Page->firstRow + $size);
$this->assign("pages", $pages);
$this->display();
}
public function index()
{
//用户积分查询
$ScorenoteModel = new \Common\Model\ScorenoteModel();
$uid = $this->uid;
$time = time();
$todayB = date("Y-m-d", $time) . " 00:00:00";
//今天开始时间
$todayE = date("Y-m-d", $time) . " 23:59:59";
//今天结束时间
$YesterdayB = date("Y-m-d", strtotime("-1 day")) . " 00:00:00";
//昨天开始时间
$YesterdayE = date("Y-m-d", strtotime("-1 day")) . " 23:59:59";
//昨天结束时间
$totalB = date("Y-m-d", strtotime("-7 day")) . " 00:00:00";
//7天前开始时间
$totalE = date("Y-m-d", $time) . " 23:59:59";
//今天结束时间
//------------今天积分
$todayScore = $ScorenoteModel->where("uid=%d and cdate>'%s' and cdate<'%s'", $uid, $todayB, $todayE)->sum("score");
if (is_null($todayScore)) {
$todayScore = 0;
//今天没有积分
}
$this->assign("todayScore", $todayScore);
//------------今天积分
//------------昨天积分------------
$yesterdayScore = $ScorenoteModel->where("uid=%d and cdate>'%s' and cdate<'%s'", $uid, $YesterdayB, $YesterdayE)->sum("score");
if (is_null($yesterdayScore)) {
$yesterdayScore = 0;
//今天没有积分
}
$this->assign("yesterdayScore", $yesterdayScore);
//------------昨天积分----------
//------------最近7天积分------------
$totalScore = $ScorenoteModel->where("uid=%d and cdate>'%s' and cdate<'%s'", $uid, $totalB, $totalE)->sum("score");
if (is_null($totalScore)) {
$totalScore = 0;
//今天没有积分
}
$this->assign("totalScore", $totalScore);
//------------最近7天积分----------
//End
$brokeragenoteModel = M("brokeragenote");
//------------------新邻居----邀请注册的人----------
//------------今天邻居数量
$Todayneighbor = $brokeragenoteModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 0, $todayB, $todayE)->count();
$this->assign("Todayneighbor", $Todayneighbor);
//------------今天邻居数量
//------------昨天邻居数量
$yesterdayneighbor = $brokeragenoteModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 0, $YesterdayB, $YesterdayE)->count();
$this->assign("yesterdayneighbor", $yesterdayneighbor);
//------------昨天邻居数量
//------------最近7天邻居数量
$totalneighbor = $brokeragenoteModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 0, $totalB, $totalE)->count();
$this->assign("totalneighbor", $totalneighbor);
//------------最近7天邻居数量
//------------------新邻居---------------End
//------------------订单成交量----邀请注册的人----------
//------------今天订单成交量
$TodayOrder = $brokeragenoteModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 1, $todayB, $todayE)->count();
$this->assign("TodayOrder", $TodayOrder);
//------------今天订单成交量
//------------昨天订单成交量
$yesterdayOrder = $brokeragenoteModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 1, $YesterdayB, $YesterdayE)->count();
$this->assign("yesterdayOrder", $yesterdayOrder);
//------------昨天订单成交量
//------------最近7天订单成交量
$totalOrder = $brokeragenoteModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 1, $totalB, $totalE)->count();
$this->assign("totalOrder", $totalOrder);
//------------最近7天订单成交量
//------------------订单成交量---------------End
$cooperateModel = M("cooperate");
//对接物业--------1物业
$type1CountToday = $cooperateModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 1, $todayB, $todayE)->count();
$this->assign("type1CountToday", $type1CountToday);
$type1CountYes = $cooperateModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 1, $YesterdayB, $YesterdayE)->count();
$this->assign("type1CountYes", $type1CountYes);
$type1CountTotal = $cooperateModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 1, $totalB, $totalE)->count();
$this->assign("type1CountTotal", $type1CountTotal);
//对接社区-----------2社区
$type2CountToday = $cooperateModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 2, $todayB, $todayE)->count();
$this->assign("type2CountToday", $type2CountToday);
$type2CountYes = $cooperateModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 2, $YesterdayB, $YesterdayE)->count();
$this->assign("type2CountYes", $type2CountYes);
$type2CountTotal = $cooperateModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 2, $totalB, $totalE)->count();
$this->assign("type2CountTotal", $type2CountTotal);
//对接商家--------------3商家
$type3CountToday = $cooperateModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 3, $todayB, $todayE)->count();
$this->assign("type3CountToday", $type3CountToday);
$type3CountYes = $cooperateModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 3, $YesterdayB, $YesterdayE)->count();
$this->assign("type3CountYes", $type3CountYes);
$type3CountTotal = $cooperateModel->where("uid=%d and type=%d and cdate>'%s' and cdate<'%s'", $uid, 3, $totalB, $totalE)->count();
$this->assign("type3CountTotal", $type3CountTotal);
$lists = M("content")->select();
$this->display();
}
