API Documentation
\
Pop
Acl
Assertion
Resource
Role
Archive
Adapter
Compress
Auth
Adapter
Cache
Adapter
Code
Generator
Config
Console
Input
Controller
Crypt
Data
Type
Db
Adapter
Gateway
Sql
Dom
Event
Feed
Format
File
Filter
Form
Element
Input
Template
Ftp
Geo
Http
Client
I18n
Format
Image
Adjust
Draw
Effect
Factory
Filter
Layer
Type
Loader
Log
Writer
Mail
Module
Nav
Paginator
Payment
Adapter
Pdf
Build
Font
TrueType
Table
Cmap
Image
Object
Document
Page
Annotation
Color
Field
Router
Match
Service
Shipping
Adapter
Validator
Version
View
Template
Web

\Pop\Db\SqlHaving

SQL Having Predicate class

Summary

Methods
Properties
Constants
__construct()
add()
nest()
hasNest()
getNest()
equalTo()
notEqualTo()
greaterThan()
greaterThanOrEqualTo()
lessThan()
lessThanOrEqualTo()
like()
notLike()
between()
notBetween()
in()
notIn()
isNull()
isNotNull()
render()
__toString()
No public properties found
No constants found
parse()
$sql
$predicates
$nested
$operators
N/A
No private methods found
No private properties found
N/A

Properties

$predicates

$predicates : array

Predicates array

Type

array

$nested

$nested : array

Nested predicates

Type

array

$operators

$operators : array

Allowed operators

Type

array

Methods

__construct()

__construct(\Pop\Db\Sql  $sql) : \Pop\Db\Sql\Predicate

Constructor

Instantiate the predicate collection object.

Parameters

\Pop\Db\Sql $sql

Returns

\Pop\Db\Sql\Predicate

add()

add(mixed  $predicate) : \Pop\Db\Sql\Predicate

Add a predicate from a string

Parameters

mixed $predicate

Returns

\Pop\Db\Sql\Predicate

hasNest()

hasNest(integer  $i = null) : boolean

Determine if it has a nested predicate branch

Parameters

integer $i

Returns

boolean

getNest()

getNest(integer  $i) : mixed

Get a nested predicate

Parameters

integer $i

Returns

mixed

equalTo()

equalTo(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for =

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

notEqualTo()

notEqualTo(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for !=

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

greaterThan()

greaterThan(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for >

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

greaterThanOrEqualTo()

greaterThanOrEqualTo(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for >=

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

lessThan()

lessThan(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for <

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

lessThanOrEqualTo()

lessThanOrEqualTo(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for <=

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

like()

like(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for LIKE

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

notLike()

notLike(string  $column, string  $value, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for NOT LIKE

Parameters

string $column
string $value
string $combine

Returns

\Pop\Db\Sql\Predicate

between()

between(string  $column, string  $value1, string  $value2, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for BETWEEN

Parameters

string $column
string $value1
string $value2
string $combine

Returns

\Pop\Db\Sql\Predicate

notBetween()

notBetween(string  $column, string  $value1, string  $value2, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for NOT BETWEEN

Parameters

string $column
string $value1
string $value2
string $combine

Returns

\Pop\Db\Sql\Predicate

in()

in(string  $column, mixed  $values, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for IN

Parameters

string $column
mixed $values
string $combine

Returns

\Pop\Db\Sql\Predicate

notIn()

notIn(string  $column, mixed  $values, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for NOT IN

Parameters

string $column
mixed $values
string $combine

Returns

\Pop\Db\Sql\Predicate

isNull()

isNull(string  $column, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for IS NULL

Parameters

string $column
string $combine

Returns

\Pop\Db\Sql\Predicate

isNotNull()

isNotNull(string  $column, string  $combine = 'AND') : \Pop\Db\Sql\Predicate

Predicate for IS NOT NULL

Parameters

string $column
string $combine

Returns

\Pop\Db\Sql\Predicate

render()

render(integer  $count = 1) : string

Predicate render method

Parameters

integer $count

Returns

string

__toString()

__toString() : string

Predicate return string

Returns

string

parse()

parse(string  $predicate) : array

Parse a predicate string

Parameters

string $predicate

Returns

array