/** * 交易记录 */ public function index(){ $model = D('Record'); $where = $this->_search();//获得查询条件 if(isset($_GET['_order'])) { $order = $_GET['_order']; }else { $order = !empty($sortBy)? $sortBy: $model->getPk(); } //排序方式默认按照倒序排列 //接受 sost参数 0 表示倒序 非0都 表示正序 if(isset($_GET['_sort'])) { $sort = $_GET['_sort']?'asc':'desc'; }else { $sort = $asc?'asc':'desc'; } if(!empty($_GET['listRows'])) { $listRows = $_GET['listRows']; }else{ $page_size = C('page_size'); $listRows = $page_size ? $page_size : 10; } $count = $model->where($where)->count(); $page_count = ceil($count/$listRows); $this->assign('count',$count); $this->assign('page_count',$page_count); if($count>0){ import("@.ORG.Util.Page"); //创建分页对象 //$listRows = 1; $p = new \Page($count,$listRows); $list = $model->field('payment_mode,payment_company,pay_type,amount,balance,create_time,status')->where($where)->order('id desc')->limit($p->firstRow.','.$p->listRows)->select(); //分页显示 $page = $p->Show(); } //dump($list);exit; //列表排序显示 $sortImg = $sort ; //排序图标 $sortAlt = $sort == 'desc'?'升序排列':'倒序排列'; //排序提示 $sort = $sort == 'desc'? 1:0; //排序方式 //模板赋值显示 $this->assign('list',$list); $this->assign('sort',$sort); $this->assign('order',$order); $this->assign("page",$page); $this->assign('headerTitle','交易明细'); $this->assign('headerKeywords','交易明细'); $this->assign('headerDescription','交易明细'); $this->assign('wx_title','交易明细'); $this->assign('wx_desc',C('wx_desc')); $this->display(); }
/** * 列表页 */ public function index(){ $model = D('MemberCoupon'); $where = $this->_search();//获得查询条件 if(isset($_GET['_order'])) { $order = $_GET['_order']; }else { $order = !empty($sortBy)? $sortBy: $model->getPk(); } //排序方式默认按照倒序排列 //接受 sost参数 0 表示倒序 非0都 表示正序 if(isset($_GET['_sort'])) { $sort = $_GET['_sort']?'asc':'desc'; }else { $sort = $asc?'asc':'desc'; } if(!empty($_GET['listRows'])) { $listRows = $_GET['listRows']; }else{ $page_size = C('page_size'); $listRows = $page_size ? $page_size : 10; } $count = $model->where($where)->count(); $page_count = ceil($count/$listRows); $this->assign('count',$count); $this->assign('page_count',$page_count); if($count>0){ import("@.ORG.Util.Page"); //创建分页对象 //$listRows = 1; $p = new Page($count,$listRows); $list = $model->alias('a')->join('`'.C('DB_PREFIX').'coupon` as b on a.coupon_id=b.id')->field('a.*,b.title,b.info,b.value,b.btime,b.etime')->where($where)->order('a.status asc,id desc')->limit($p->firstRow.','.$p->listRows)->select(); //分页显示 $page = $p->Show(); } //dump($list);exit; //列表排序显示 $sortImg = $sort ; //排序图标 $sortAlt = $sort == 'desc'?'升序排列':'倒序排列'; //排序提示 $sort = $sort == 'desc'? 1:0; //排序方式 //模板赋值显示 $this->assign('list',$list); $this->assign('sort',$sort); $this->assign('order',$order); $this->assign("page",$page); $this->assign('headerTitle','我的优惠券'); $this->assign('headerKeywords','我的优惠券'); $this->assign('headerDescription','我的优惠券'); $this->assign('wx_title','我的优惠券'); $this->assign('wx_desc',C('wx_desc')); $this->display(); }
/** * 排序 */ public function sort() { $b_data['pid'] = 0; $blist = $this->db->where($b_data)->order('sort asc,id asc')->select(); $this->assign('blist', $blist); if ($_GET['pid']) { $data['pid'] = $_GET['pid']; $count = $this->db->where($data)->count(); //创建分页对象 $listRows = '20'; $p = new \My\Page($count, $listRows); $pageno = $_GET['p'] ? $_GET['p'] : 1; $offset = ($pageno - 1) * $page_size; $p = new Page($count, $listRows); $list = $this->db->where($data)->order('sort asc,id asc')->limit($p->firstRow . ',' . $p->listRows)->select(); //echo $model->getlastsql(); $page = $p->Show(); $this->assign('page', $page); $this->assign('list', $list); } $this->display(); }
/** * 排序页面 */ public function sort() { $count = $this->db->where($data)->count(); //创建分页对象 $listRows = '20'; $p = new \My\Page($count, $listRows); $pageno = $_GET['p'] ? $_GET['p'] : 1; $offset = ($pageno - 1) * $page_size; $p = new Page($count, $listRows); $list = $this->db->field('*')->where($data)->order('sort asc,id desc')->limit($p->firstRow . ',' . $p->listRows)->select(); $page = $p->Show(); $this->assign('page', $page); $this->assign('list', $list); $this->display(); }
/** * 列表页 */ public function index(){ $model = D('Order'); $od_model = D('OrderDetail'); $where = $this->_search();//获得查询条件 //dump($where); if(isset($_GET['_order'])) { $order = $_GET['_order']; }else { $order = !empty($sortBy)? $sortBy: $model->getPk(); } //排序方式默认按照倒序排列 //接受 sost参数 0 表示倒序 非0都 表示正序 if(isset($_GET['_sort'])) { $sort = $_GET['_sort']?'asc':'desc'; }else { $sort = $asc?'asc':'desc'; } if(!empty($_GET['listRows'])) { $listRows = $_GET['listRows']; }else{ $page_size = C('page_size'); $listRows = $page_size ? $page_size : 10; } $count = $model->where($where)->count(); $page_count = ceil($count/$listRows); $this->assign('count',$count); $this->assign('page_count',$page_count); if($count>0){ import("@.ORG.Util.Page"); //创建分页对象 //$listRows = 1; $p = new Page($count,$listRows); $list = $model->field('id,order_sn,payment_mode,actual_paid,create_time,is_rate,pay_status,delivery_status,status')->where($where)->order($order.' '.$sort)->limit($p->firstRow.','.$p->listRows)->select(); foreach($list as $val){ $order_ids[] = $val['id']; $id = $val['id']; if($val['status']==1){ if($val['pay_status']==0){ $val['status_name'] = '待支付'; $val['state'] = 0; }else{ if($val['delivery_status']==0){ $val['status_name'] = '待发货'; $val['state'] = 1; }else{ $val['status_name'] = '已发货'; $val['state'] = 2; } } }else if($val['status']==2){ $val['status_name'] = '完成交易'; if($val['is_rate']==0){ $val['status_name'] = '待评价'; } $val['state'] = 3; }else if($val['status']==-1){ $val['status_name'] = '订单已关闭'; }else{ $val['status_name'] = '订单未确认'; } $list2[$id] = $val; } //dump($list2);exit; $od_data['order_id'] = array('in',$order_ids); $items = $od_model->field('id,order_id,order_sn,product_name,spec,lit_pic,price,num,refund_status,status')->where($od_data)->order('id desc')->select(); foreach($items as $val){ $id = $val['order_id']; //组装详细单号 $list2[$id]['items'][] = $val; $list2[$id]['item_count']++; } //分页显示 $page = $p->Show(); } //dump($list2);exit; //列表排序显示 $sortImg = $sort ; //排序图标 $sortAlt = $sort == 'desc'?'升序排列':'倒序排列'; //排序提示 $sort = $sort == 'desc'? 1:0; //排序方式 //模板赋值显示 $this->assign('list',$list2); $this->assign('sort',$sort); $this->assign('order',$order); $this->assign("page",$page); $this->assign('headerTitle','订单列表页'); $this->assign('headerKeywords','订单列表页'); $this->assign('headerDescription','订单列表页'); $this->assign('wx_title','订单列表页'); $this->assign('wx_desc',C('wx_desc')); $this->display(); }