Библиотека знаний - yii:ar

group

Anonymous (anonymous@undisclosed.example.com) — 2012-06-16T20:25:01+00:00

group

  // AR Group
  public function group($group = array())
  {
    if(is_array($group)) $_group = $group;
    else $_group[] = $group;
    $this->getDbCriteria()->mergeWith(
      array(
        'group' => implode(',', $_group),
      )
    );
    return $this;
  }

limit

Anonymous (anonymous@undisclosed.example.com) — 2012-06-16T20:15:52+00:00

limit

  // AR Limit, Offset
  public function limit($limit = 0, $offset = 0)
  {
 
    $this->_limit = (int)Yii::app()->request->getParam('limit');
    $this->_offset = (int)Yii::app()->request->getParam('offset');    
 
    $this->getDbCriteria()->mergeWith(
      array(
        'limit' => $limit ? $limit : $this->_limit,
        'offset' => $offset ? $offset : $this->_offset,
        )
    );
    return $this;
  }

order

Anonymous (anonymous@undisclosed.example.com) — 2012-06-16T20:25:33+00:00

order

  // AR Order by
  public function order($order = '')
  {
    $this->_order = (string)Yii::app()->request->getParam('order');
    if($order == '') $order = $this->_order;
    if(!$order) return $this;
    // Если -$order то $desc = true;
    if($order[0] == '-') $desc = true;
    $order = preg_replace('~[^a-z]~', '', $order);
    $this->getDbCriteria()->mergeWith(
      array(
        'order' => $order . (isset($desc) ? ' DESC ' : ''),
        )
    );
    return $this;
  }

Active Record

Anonymous (anonymous@undisclosed.example.com) — 2012-06-16T20:32:51+00:00