public function doWebLists()
{
$Model = new CreditsRecord();
//会员信息
$user = Db::table('member')->where('uid', Session::get('member.uid'))->first();
if ($timerange = q('get.timerange')) {
//有筛选时间的
$timerange = explode('至', $timerange);
$total = $Model->where('uid', Session::get('member.uid'))->where('credittype', q('get.type'))->where('createtime', '>=', strtotime($timerange[0]))->where('createtime', '<=', strtotime($timerange[1]))->count();
$page = Page::row(8)->make($total);
$data = $Model->where('uid', Session::get('member.uid'))->where('credittype', q('get.type'))->where('createtime', '>=', strtotime($timerange[0]))->where('createtime', '<=', strtotime($timerange[1]))->limit(Page::limit())->get();
} else {
$total = $Model->where('uid', Session::get('member.uid'))->where('credittype', q('get.type'))->count();
$page = Page::row(8)->make($total);
$data = $Model->where('uid', Session::get('member.uid'))->where('credittype', q('get.type'))->limit(Page::limit())->get();
}
//收入
$income = $Model->where('num', '>', 0)->where('uid', Session::get('member.uid'))->where('credittype', q('get.type'))->sum('num');
//支出
$expend = $Model->where('num', '<', 0)->where('uid', Session::get('member.uid'))->where('credittype', q('get.type'))->sum('num');
View::with(['income' => $income, 'expend' => $expend]);
View::with('page', $page);
View::with('user', $user);
View::with('data', $data);
View::make($this->ucenter_template . '/credit_lists.html');
}
/**
* 分页查询
*
* @param $row 每页显示数量
* @param int $pageNum
*
* @return \hdphp\db\Collection
*/
public function paginate($row, $pageNum = 8)
{
$obj = unserialize(serialize($this));
\Page::row($row)->pageNum($pageNum)->make($obj->count());
$res = $this->limit(\Page::limit())->get();
$collect = Collection::make([]);
if ($res) {
//模型数据要转换为数组形式
$collect->make($this->getModel() ? $res->toArray() : $res);
}
return $collect;
}
public function doSitecharge()
{
//分页数据
$db = Db::table('member');
$db->field("ticket_record.id,member.uid,ticket.title,ticket.thumb,ticket.condition,ticket.discount,user.username,ticket_record.createtime,ticket_record.usetime,ticket_record.status");
$db->join('ticket_record', 'member.uid', '=', 'ticket_record.uid');
$db->join('ticket', 'ticket.tid', '=', 'ticket_record.tid');
$db->leftJoin('user', 'user.uid', '=', 'ticket_record.manage');
$db->where('ticket.type', q('get.type'))->where('member.siteid', SITEID);
//有搜索条件
if ($tid = q('get.tid')) {
$db->where('ticket.tid', $tid);
}
if ($status = q('get.status')) {
$db->where('ticket_record.status', $status);
}
if ($uid = q('get.uid')) {
$db->where('ticket_record.uid', $uid);
}
$page = Page::row(15)->make($db->count());
//查询数据
$db = Db::table('member');
$db->field("ticket_record.id,member.uid,ticket.title,ticket.thumb,ticket.condition,ticket.discount,user.username,ticket_record.createtime,ticket_record.usetime,ticket_record.status");
$db->join('ticket_record', 'member.uid', '=', 'ticket_record.uid');
$db->join('ticket', 'ticket.tid', '=', 'ticket_record.tid');
$db->leftJoin('user', 'user.uid', '=', 'ticket_record.manage');
$db->where('ticket.type', q('get.type'))->where('member.siteid', SITEID);
//有搜索条件
if ($tid = q('get.tid')) {
$db->where('ticket.tid', $tid);
}
if ($status = q('get.status')) {
$db->where('ticket_record.status', $status);
}
if ($uid = q('get.uid')) {
$db->where('ticket_record.uid', $uid);
}
$data = $db->limit(Page::limit())->get();
//卡券数据
$ticket = Db::table('ticket')->where('siteid', SITEID)->where('type', q('get.type'))->groupBy('tid')->get();
View::with('ticket', $ticket);
View::with('data', $data);
View::with('page', $page);
return view($this->template . '/charge.html');
}
?>
/<?php
echo __TEMPLATE__;
?>
/images/list_r4_c7.jpg" /> 当前位置:<a href="/">首页</a> > <a href="#"><?php
echo $cms['catname'];
?>
</a>
</div>
<div class="main_pest_news">
<ul>
<?php
$db = Db::table('article');
$count = $db->where("cid", 23)->count('*');
Page::row(10)->make($count);
$limit = Page::limit();
$data = $db->where('cid', 23)->limit($limit)->get();
foreach ($data as $field) {
$field['url'] = U('Home/Index/article', array('id' => $field['id']));
?>
<li><span><?php
echo date('m-d', $field['addtime']);
?>
</span><a href="<?php
echo $field['url'];
?>
"><?php
echo $field['title'];
?>
