query($sql));
$Page = new \Think\Page($count,C('BACK_PAGE_NUM'));
$show = $Page->show();// 分页显示输出
$sql.=' order by state asc,add_time desc LIMIT '.$Page->firstRow.','.$Page->listRows;
$list=M()->query($sql);
foreach($list as $key => $val)
{
// goods_id name image
if(empty($val['goods_name']))
{
$goods_info = M('goods')->field('goods_id,name,image')->where( array('goods_id' => $val['goods_id']) )->find();
$val['goods_name'] = $goods_info['name'];
$val['goods_image'] = $goods_info['image'];
M('order_comment')->where( array('comment_id' => $val['comment_id']) )
->save( array('goods_name' =>$val['goods_name'],'goods_image' =>$val['goods_image'] ) );
}
//member_id order_comment order_id
if(empty($val['order_num_alias']))
{
$order_info = M('order')->field('order_num_alias')->where( array('order_id' => $val['order_id']) )->find();
$val['order_num_alias'] = $order_info['order_num_alias'];
M('order_comment')->where( array('comment_id' => $val['comment_id']) )
->save( array('order_num_alias' =>$val['order_num_alias'] ) );
}
if(empty($val['user_name']))
{
$member_info = M('member')->field('name,avatar')->where( array('member_id' => intval($val['member_id'])) )->find();
$val['user_name'] = $member_info['name'];
$val['avatar'] = $member_info['avatar'];
M('order_comment')->where( array('comment_id' => $val['comment_id']) )
->save( array('user_name' =>$val['user_name'], 'avatar' =>$val['avatar'] ) );
}
$list[$key] = $val;
}
return array(
'empty'=>'| ~~暂无数据 |
',
'list'=>$list,
'page'=>$show
);
/**
$where = array();
if(!empty($search) && isset($search['store_id'])) {
$where['store_id'] = $search['store_id'];
}
$count=M('pick_up')->where($where)->count();
$Page = new \Think\Page($count,C('BACK_PAGE_NUM'));
$show = $Page->show();// 分页显示输出
$list = M('pick_up')->where($where)->order('id desc')->limit($Page->firstRow.','.$Page->listRows)->select();
return array(
'empty'=>'| ~~暂无数据 |
',
'list'=>$list,
'page'=>$show
);
**/
}
public function show_pickup_member_page( $search = array() )
{
$where = array();
if(!empty($search) && isset($search['store_id'])) {
$where['store_id'] = $search['store_id'];
}
if(!empty($search) && isset($search['pick_up_id'])) {
$where['pick_up_id'] = $search['pick_up_id'];
}
//
$count=M('pick_member')->where($where)->count();
$Page = new \Think\Page($count,C('BACK_PAGE_NUM'));
$show = $Page->show();// 分页显示输出
$list = M('pick_member')->where($where)->order('id desc')->limit($Page->firstRow.','.$Page->listRows)->select();
foreach( $list as $key => $val )
{
if( $val['pick_up_id'] == 0)
{
$val['pick_name'] = '所有店铺';
}else{
$pick_up_info = M('pick_up')->field('pick_name')->where( array('id' => $val['pick_up_id']) )->find();
$val['pick_name'] = $pick_up_info['pick_name'];
}
$pick_order_count = M('pick_order')->where( array('pick_member_id' => $val['member_id']) )->count();
//name
$val['pick_order_count'] = $pick_order_count;
$val['member_info'] = M('member')->field('name,avatar')->where( array('member_id' => $val['member_id']) )->find();
$list[$key] = $val;
}
return array(
'empty'=>'| ~~暂无数据 |
',
'list'=>$list,
'page'=>$show
);
}
}
?>