Model::havingOpen

Add open bracket on Having query

Description

public self Model::havingOpen( [ string $andOr = 'AND' ] )

Arguments

Name	Data type	Default	Remarks
$andOr	string	'AND'	Condition chain from the previous query AND or OR

Example

Controller

$model = new Model(false, array(
  'table'   => 'cms_news',
  'id'      => 'news_id',
  'visible' => 'visible',
));

$model->having('news_id = ?', array(1));
$model->havingOpen();
$model->having('title = ?', array('foo'));
$model->having('created_at <= ?', array('2021-01-01'), 'OR');
$model->havingClose();

// SELECT *
// FROM cms_news
// HAVING
//   news_id = 1
//   AND (
//     title = 'foo'
//     OR created_at <= '2021-01-01'
//   )
$records = $model->find();