thinkPHP分页功能实例详解

<?php
/**
* 商品模型
* ProductModel.class.php
* @lastmodify 2015-8-17
* @author yhd
*/
namespace Red\Product\Models;
use Think\Model;
use Red\ServiceInterFace;
use Red\StaticService;
class ProductModel extends Model implements ServiceInterFace{
  /**
   * 实例化本类
   * @return ProductModel
   */
  public static function getInstance() {
    return StaticService::getInstance(__CLASS__);
  }
  /**
   * 单个商品
   * @param string $id
   * @param integer $status 状态 1:有效 2:无效
   * @param integer $onsale 是否上架 1:是 2:否
   * @return array 一维数组
   */
  public function getProOne($id, $status = 1 , $onsale = 1){
    $condition['onsale'] = array('eq', $onsale); //是否上架
    $condition['status'] = array('eq', $status); //状态
    $condition['id'] = array('eq',$id);
    return $this->where($condition)->find();
  }
  /**
   * 商品列表
   * @param string $limit 查询条数
   * @param array $data 查询条件
   * @return array 二维数组
   */
  public function getProList($data = ''){
    $condition['onsale'] = array('eq', $data['onsale']); //是否上架
    $condition['status'] = array('eq', $data['status']); //状态
    $condition['type'] = array('eq', $data['type']);  //分类
    if(isset($data['limit']) && isset($data['order']) ){
      $return =$this->where($condition)->limit($data['limit'])->order($data['order'])->select();
    }else{
      $return =$this->where($condition)->select();
    }
    return $return;
  }
  /**
   * 添加商品
   * @param array $data
   * @return int
   */
  public function addProduct($data){
    return $this->add($data);
  }
  /**
   * 删除商品
   *
   */
  public function delProduct($id){
    $condition['id'] = array('eq', $id);
    return $this->where($condition)->delete();
  }
  /**
   * 修改商品
   * @param string|int $id
   * @param array $data
   * @return
   */
  public function editProdcut($id, $data){
    $condition['id'] = array('eq', $id);
    return $this->where($condition)->save($data);
  }
  public function getProductInfo($product){
    if(empty($product) || !isset($product['product_id'])){
      return array();
    }
    $info = $this->getProOne($product['product_id']);
    $product['name'] = $info['name'];
    $product['store_id'] = $info['store_id'];
    $product['price'] = $info['price'];
    $product['m_price'] = $info['m_price'];
    return $product;
  }
}