/**
* 交易记录
*/
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();
}
