drupal7 addExpression+union+分页

global $user;
  $query_single = db_select('mp_order_singlepay', 'ms')
      ->fields('ms', array('order_id','order_time', 'article_name','total_amount','status','payment_method'));
  $query_single->condition('isdelete', 0);
  $query_single->condition('purchaser_id', $user->uid);
  $query_single->addExpression('0', 'is_single');//重点 等于增加了一列

  $query_month = db_select('mp_order_monthspay', 'mm')
      ->fields('mm', array('order_id','order_time', 'product_name','total_amount','status','payment_method'));
  $query_month->condition('isdelete', 0);
  $query_month->condition('purchaser_id', $user->uid);
  $query_month->addExpression('1', 'is_single');//重点

$query = Database::getConnection() ->select($query_single->union($query_month)) 
->fields(NULL, array('order_id','order_time', 'article_name','total_amount','status','payment_method','t')) //fields里要取出增加的自定义列名
->orderBy('order_time','DESC'); 

$total_rows=$query->countQuery()->execute()->fetchField(); 

$per_pager=5;//每页行数 

$objects= $query->extend('PagerDefault')-> limit($per_pager)-> execute() -> fetchAll(); 

var_dump($objects);

 

 

转载于:https://www.cnblogs.com/zjfblog/p/7444474.html