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']; ?>